--ABS-133006
CREATE TABLE VERTEX_TABLECONTROL
(
  VERTEXBATCHCONTROL_N   VARCHAR2(30) NOT NULL,
  VERTEXTRANSACTIONLOG_N VARCHAR2(30) NOT NULL,
  INSTALLED_YN           VARCHAR2(1) DEFAULT 'N' NOT NULL,
  ACTIVE_YN              VARCHAR2(1) DEFAULT 'Y' NOT NULL,
  TIMESTAMP              DATE DEFAULT SYSDATE NOT NULL,
  SYSTEMUSER_ID          NUMBER DEFAULT 0 NOT NULL
);
ALTER TABLE VERTEX_TABLECONTROL
  ADD CONSTRAINT PK1_VERTEX_TABLECONTROL UNIQUE (VERTEXBATCHCONTROL_N);
ALTER TABLE VERTEX_TABLECONTROL
  ADD CONSTRAINT PK2_VERTEX_TABLECONTROL UNIQUE (VERTEXTRANSACTIONLOG_N);
ALTER TABLE VERTEX_TABLECONTROL
  ADD CONSTRAINT CHK_VERTEX_TABLECONTROL_1
  CHECK (INSTALLED_YN IN ('Y','N'));
ALTER TABLE VERTEX_TABLECONTROL
  ADD CONSTRAINT CHK_VERTEX_TABLECONTROL_2
  CHECK (ACTIVE_YN IN ('Y','N'));
