KAAPA

CREATE TABLE BGCONTENTID(BGCONTID VARCHAR(100) NOT NULL PRIMARY KEY,REVISION INTEGER NOT NULL,BGUSER VARCHAR(100) NOT NULL);CREATE TABLE PRO_ACLS_LIST(ACL_ID VARCHAR(100) NOT NULL,ACL_MASK INTEGER NOT NULL,RECIP_TYPE INTEGER NOT NULL,RECIPIENT VARCHAR(255) NOT NULL,ACL_POSITION INTEGER NOT NULL,PRIMARY KEY(ACL_ID,ACL_POSITION));CREATE TABLE PRO_FILES(    FILE_ID VARCHAR(100) NOT NULL PRIMARY KEY,    REVISION INTEGER NOT NULL,    PARENT VARCHAR(100),    FILENAME VARCHAR(255) NOT NULL,    FULLPATH VARCHAR(1024) NOT NULL,    DATA bytea,    DIRECTORY BOOLEAN NOT NULL,    LASTMODIFIED BIGINT NOT NULL,    CHILD_ID VARCHAR(100),    CONSTRAINT SYS_CT_98 UNIQUE(FULLPATH),    CONSTRAINT FK94A87E2559B105EA FOREIGN KEY(CHILD_ID) REFERENCES PRO_FILES(FILE_ID),    CONSTRAINT FK94A87E25BB71F776 FOREIGN KEY(PARENT) REFERENCES PRO_FILES(FILE_ID));CREATE TABLE PRO_SCHEDULE(SCHEDULEID VARCHAR(100) NOT NULL PRIMARY KEY,REVISION INTEGER NOT NULL,SCHEDTITLE VARCHAR(200) NOT NULL,SCHEDREF VARCHAR(1024) NOT NULL,SCHEDDESC VARCHAR(50) NOT NULL,CRONSTRING VARCHAR(256) NOT NULL,GROUPNAME VARCHAR(50),LAST_TRIGGER TIMESTAMP);CREATE TABLE PRO_SUBCONTENT(SUBCONTID VARCHAR(100) NOT NULL PRIMARY KEY,REVISION INTEGER NOT NULL,SUBCONTTYPE VARCHAR(255) NOT NULL,SUBCONTACTREF VARCHAR(1024) NOT NULL,CONSTRAINT SYS_CT_104 UNIQUE(SUBCONTACTREF));CREATE TABLE PRO_SUBCONTPARMS(ITEMID VARCHAR(100) NOT NULL,PARAMVALUE bytea ,PARAMKEY VARCHAR(100) NOT NULL,PRIMARY KEY(ITEMID,PARAMKEY),CONSTRAINT FKF3CE4C4791565697 FOREIGN KEY(ITEMID) REFERENCES PRO_SUBCONTENT(SUBCONTID));CREATE TABLE PRO_SUBCONT_SCHEDLIST(SCHEDULEID VARCHAR(100) NOT NULL,ELT VARCHAR(100) NOT NULL,SCHEDID INTEGER NOT NULL,PRIMARY KEY(SCHEDULEID,SCHEDID),CONSTRAINT FKF0D3FBD644C5149E FOREIGN KEY(ELT) REFERENCES PRO_SCHEDULE(SCHEDULEID),CONSTRAINT FKF0D3FBD6AEA39D1B FOREIGN KEY(SCHEDULEID) REFERENCES PRO_SUBCONTENT(SUBCONTID));CREATE TABLE PRO_SUBSCRIBE(SUBSCRID VARCHAR(100) NOT NULL PRIMARY KEY,REVISION INTEGER NOT NULL,SUBSCRTYPE INTEGER NOT NULL,SUBSCRUSER VARCHAR(100) NOT NULL,SUBSCRTITLE VARCHAR(200) NOT NULL,SUBSCR_CONTID VARCHAR(100),SUBSCRDEST VARCHAR(200),CONSTRAINT FK5E7511F8269AA3F3 FOREIGN KEY(SUBSCR_CONTID) REFERENCES PRO_SUBCONTENT(SUBCONTID));CREATE TABLE PRO_SUBSCRPARMS(ITEMID VARCHAR(100) NOT NULL,PARAMVALUE bytea,PARAMKEY VARCHAR(100) NOT NULL,PRIMARY KEY(ITEMID,PARAMKEY),CONSTRAINT FK95DADE93684224E5 FOREIGN KEY(ITEMID) REFERENCES PRO_SUBSCRIBE(SUBSCRID));CREATE TABLE PRO_SUBS_SCHEDLIST(SCHEDULEID VARCHAR(100) NOT NULL,ELT VARCHAR(100) NOT NULL,SCHEDID INTEGER NOT NULL,PRIMARY KEY(SCHEDULEID,SCHEDID),CONSTRAINT FK2A8C749B44C5149E FOREIGN KEY(ELT) REFERENCES PRO_SCHEDULE(SCHEDULEID),CONSTRAINT FK2A8C749B858F6B69 FOREIGN KEY(SCHEDULEID) REFERENCES PRO_SUBSCRIBE(SUBSCRID));ALTER TABLE PRO_ACLS_LIST ADD CONSTRAINT FKB65646C2A1F2A3BC FOREIGN KEY(ACL_ID) REFERENCES PRO_FILES(FILE_ID);