CREATE TABLE ORAMON.OMON_EMAILLIST_HDR (
  EMAILLIST_CATID VARCHAR2(16) NOT NULL,
  EMAILLIST_SORTID NUMBER NOT NULL,
  DEF_RECORD_FLAG VARCHAR2(1) NOT NULL,
  EFFECT_DATETIME DATE NULL,
  TERM_DATETIME DATE NULL,
  INSERT_DATETIME DATE NULL,
  INSERT_USER_ID VARCHAR2(128) NULL,
  UPDATE_DATETIME DATE NULL,
  UPDATE_USER_ID VARCHAR2(128) NULL
) TABLESPACE ORAMON;

ALTER TABLE ORAMON.OMON_EMAILLIST_HDR
 ADD CONSTRAINT OMON_EMAILLIST_HDR_U01 PRIMARY KEY (EMAILLIST_CATID) USING INDEX
 STORAGE(INITIAL 1M NEXT 1M PCTINCREASE 0 MAXEXTENTS 200) TABLESPACE ORAMON;

INSERT INTO ORAMON.OMON_EMAILLIST_HDR
 VALUES ('SENDER', 0, 'Y', SYSDATE, NULL, SYSDATE, 'OPS$ADMIN.DBA', SYSDATE, 'OPS$ADMIN.DBA');

INSERT INTO ORAMON.OMON_EMAILLIST_HDR
 VALUES ('TO', 1, 'N', SYSDATE, NULL, SYSDATE, 'OPS$ADMIN.DBA', SYSDATE, 'OPS$ADMIN.DBA');

INSERT INTO ORAMON.OMON_EMAILLIST_HDR
 VALUES ('CC', 2, 'N', SYSDATE, NULL, SYSDATE, 'OPS$ADMIN.DBA', SYSDATE, 'OPS$ADMIN.DBA');

INSERT INTO ORAMON.OMON_EMAILLIST_HDR
 VALUES ('BCC', 3, 'N', SYSDATE, NULL, SYSDATE, 'OPS$ADMIN.DBA', SYSDATE, 'OPS$ADMIN.DBA');

COMMIT;


CREATE TABLE ORAMON.OMON_EMAILLIST_DTL (
  DTL_EMAILLIST_NUM NUMBER NOT NULL,
  EMAILLIST_CATID VARCHAR2(16) NOT NULL,
  EMAILLIST_GRPID VARCHAR2(16) NOT NULL,
  EMAIL_ADDRESS_ID VARCHAR2(128) NOT NULL,
  SITE_LOCATION_ID VARCHAR2(128) NOT NULL,
  DEF_RECORD_FLAG VARCHAR2(1) NULL,
  EFFECT_DATETIME DATE NULL,
  TERM_DATETIME DATE NULL,
  INSERT_DATETIME DATE NULL,
  INSERT_USER_ID VARCHAR2(128) NULL,
  UPDATE_DATETIME DATE NULL,
  UPDATE_USER_ID VARCHAR2(128) NULL
) TABLESPACE ORAMON;


ALTER TABLE ORAMON.OMON_EMAILLIST_DTL
 ADD CONSTRAINT OMON_EMAILLIST_DTL_U01 PRIMARY KEY (DTL_EMAILLIST_NUM) USING INDEX
 STORAGE(INITIAL 1M NEXT 1M PCTINCREASE 0 MAXEXTENTS 200) TABLESPACE ORAMON;

CREATE INDEX ORAMON.OMON_EMAILIST_DTL_N01
 ON ORAMON.OMON_EMAILLIST_DTL(EMAILLIST_CATID)
 TABLESPACE ORAMON
 STORAGE(INITIAL 1M NEXT 1M PCTINCREASE 0 MAXEXTENTS 200);

INSERT INTO ORAMON.OMON_EMAILLIST_DTL
 VALUES (1000, 'SENDER', 'SENDER', 'sender.name@domain.com', 'ALL', 'Y', SYSDATE, NULL, SYSDATE, 'OPS$ADMIN.DBA', SYSDATE, 'OPS$ADMIN.DBA');

INSERT INTO ORAMON.OMON_EMAILLIST_DTL
 VALUES (1001, 'TO', 'DBA', 'recipient.name@domain.com', 'ALL', 'N', SYSDATE, NULL, SYSDATE, 'OPS$ADMIN.DBA', SYSDATE, 'OPS$ADMIN.DBA');

INSERT INTO ORAMON.OMON_EMAILLIST_DTL
 VALUES (1003, 'CC', 'USER', 'recipient.name@domain.com', 'ALL', 'N', SYSDATE, NULL, SYSDATE, 'OPS$ADMIN.DBA', SYSDATE, 'OPS$ADMIN.DBA');

INSERT INTO ORAMON.OMON_EMAILLIST_DTL
 VALUES (1004, 'BCC', 'AUDITOR', 'recipient.name@domain.com', 'ALL', 'N', SYSDATE, NULL, SYSDATE, 'OPS$ADMIN.DBA', SYSDATE, 'OPS$ADMIN.DBA');

COMMIT;