-- ABS-26614

CREATE TABLE PERIOD
(
  PERIOD_ID     NUMBER NOT NULL,
  YEAR          NUMBER NOT NULL,
  PERIOD        NUMBER NOT NULL,
  STARTDATE     DATE NOT NULL,
  ENDDATE       DATE NOT NULL,
  SYSTEMUSER_ID NUMBER NOT NULL,
  TIMESTAMP     DATE NOT NULL
);

ALTER TABLE PERIOD ADD CONSTRAINT XPKPERIOD PRIMARY KEY (PERIOD_ID);

CREATE UNIQUE INDEX XAK1PERIOD ON PERIOD (YEAR ASC,PERIOD ASC);