/* --------------------------------------------------------------------------------- $Id: twig.table.oracle,v 1.43 2001/07/23 17:27:27 astone Exp $ filename: twig.table.oracle author: christoph klein (christoph.klein@ucpag.com) comment: create all twig tables on oracle 8.0.5 EE --------------------------------------------------------------------------------- */ CREATE TABLE TWIG_ACCOUNTS ( ID NUMBER (16), USERNAME VARCHAR2 (128) NOT NULL, PASSWORD VARCHAR2 (128), SID NUMBER, ONNOW NUMBER, EXPIRE NUMBER, LASTON NUMBER, PRIMARY KEY (ID) ); CREATE SEQUENCE TWIG.SEQ_TWIG_ACCOUNTS INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER; CREATE TRIGGER TWIG.AI_TWIG_ACCOUNTS BEFORE INSERT ON TWIG.TWIG_ACCOUNTS FOR EACH ROW DECLARE N_NEXTVAL NUMBER; BEGIN SELECT SEQ_TWIG_ACCOUNTS.NEXTVAL INTO N_NEXTVAL FROM DUAL; :NEW.ID := N_NEXTVAL; END; / COMMIT; /* --------------------------------------------------------------------------------- */ CREATE TABLE TWIG_ACLS ( SID NUMBER (16) DEFAULT (0) NOT NULL, IDENT VARCHAR2 (128) NOT NULL, ALEVEL NUMBER (16) DEFAULT (0) NOT NULL, PRIMARY KEY (SID) ); COMMIT; /* --------------------------------------------------------------------------------- */ CREATE TABLE TWIG_ACL_GROUPS ( SID NUMBER DEFAULT (0) NOT NULL, GROUPNAME VARCHAR2 (64) NOT NULL, USERNAME VARCHAR2 (128) NOT NULL, PRIMARY KEY (GROUPNAME) ); COMMIT; /* --------------------------------------------------------------------------------- */ CREATE TABLE TWIG_ANNOUNCE ( ID NUMBER (16), THEDATE VARCHAR(16), USERNAME VARCHAR2(128) NOT NULL, EMAIL VARCHAR2(128), SUBJECT VARCHAR2(128) NOT NULL, ANNOUNCE VARCHAR2(1000) NOT NULL, PRIMARY KEY (ID) ); CREATE SEQUENCE TWIG.SEQ_TWIG_ANNOUNCE INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER; CREATE TRIGGER TWIG.AI_TWIG_ANNOUNCE BEFORE INSERT ON TWIG.TWIG_ANNOUNCE FOR EACH ROW DECLARE N_NEXTVAL NUMBER; BEGIN SELECT SEQ_TWIG_ANNOUNCE.NEXTVAL INTO N_NEXTVAL FROM DUAL; :NEW.ID := N_NEXTVAL; END; / COMMIT; /* --------------------------------------------------------------------------------- */ CREATE TABLE TWIG_BOOKMARKS ( ID NUMBER (16), USERNAME VARCHAR2 (128), THEDATE VARCHAR(16), GROUPID NUMBER (16) NOT NULL, ITEM VARCHAR2 (100), DESCRIPTION VARCHAR2 (100), URL VARCHAR2 (100), PRIMARY KEY (ID) ); CREATE SEQUENCE TWIG.SEQ_TWIG_BOOKMARKS INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER; CREATE TRIGGER TWIG.AI_TWIG_BOOKMARKS BEFORE INSERT ON TWIG.TWIG_BOOKMARKS FOR EACH ROW DECLARE N_NEXTVAL NUMBER; BEGIN SELECT SEQ_TWIG_BOOKMARKS.NEXTVAL INTO N_NEXTVAL FROM DUAL; :NEW.ID := N_NEXTVAL; END; / COMMIT; /* --------------------------------------------------------------------------------- */ CREATE TABLE TWIG_BOOKMARKS_PREFS ( ID NUMBER (16), USERNAME VARCHAR2 (128), SORTBY VARCHAR2 (10), SORTORDER NUMBER (16) DEFAULT (0) NOT NULL, DGROUP NUMBER (16) DEFAULT (0) NOT NULL, PAGESIZE NUMBER (16) DEFAULT (0) NOT NULL, VIEWGRP VARCHAR2 (10) DEFAULT (0) NOT NULL, PRIMARY KEY (ID) ); CREATE SEQUENCE TWIG.SEQ_TWIG_BOOKMARKS_PREFS INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER; CREATE TRIGGER TWIG.AI_TWIG_BOOKMARKS_PREFS BEFORE INSERT ON TWIG.TWIG_BOOKMARKS_PREFS FOR EACH ROW DECLARE N_NEXTVAL NUMBER; BEGIN SELECT SEQ_TWIG_BOOKMARKS_PREFS.NEXTVAL INTO N_NEXTVAL FROM DUAL; :NEW.ID := N_NEXTVAL; END; / COMMIT; /* --------------------------------------------------------------------------------- */ CREATE TABLE TWIG_CONTACTS ( ID NUMBER (16), USERNAME VARCHAR2 (128), THEDATE VARCHAR(16), GROUPID NUMBER (16) NOT NULL, ITEM VARCHAR2 (1000), DESCRIPTION VARCHAR2 (1000), URL VARCHAR2 (1000), FIRSTNAME VARCHAR2 (100), LASTNAME VARCHAR2 (100), EMAIL VARCHAR2 (100), COMPANY VARCHAR2 (100), HOME_PHONE VARCHAR2 (30), WORK_PHONE VARCHAR2 (30), MOBILE VARCHAR2 (30), FAX VARCHAR2 (30), ADDRESS1 VARCHAR2 (200), ADDRESS2 VARCHAR2 (200), CITY VARCHAR2 (100), STATE VARCHAR2 (10), ZIPCODE VARCHAR2 (10), COUNTRY VARCHAR2 (100), EMAIL2 VARCHAR2 (100), EMAIL3 VARCHAR2 (100), TITLE VARCHAR2 (100), PAGER VARCHAR2 (30), OFAX VARCHAR2 (30), DEPARTMENT VARCHAR2 (100), OFFICE VARCHAR2 (100), SPOUSE VARCHAR2 (100), BDAY VARCHAR2 (40), OADDRESS1 VARCHAR2 (100), OADDRESS2 VARCHAR2 (100), OCITY VARCHAR2 (100), OZIP VARCHAR2 (10), OSTATE VARCHAR2 (10), OCOUNTRY VARCHAR2 (100), TYPE NUMBER (16), USERPERS NUMBER (16), PRIMARY KEY (ID) ); CREATE SEQUENCE TWIG.SEQ_TWIG_CONTACTS INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER; CREATE TRIGGER TWIG.AI_TWIG_CONTACTS BEFORE INSERT ON TWIG.TWIG_CONTACTS FOR EACH ROW DECLARE N_NEXTVAL NUMBER; BEGIN SELECT SEQ_TWIG_CONTACTS.NEXTVAL INTO N_NEXTVAL FROM DUAL; :NEW.ID := N_NEXTVAL; END; / COMMIT; /* --------------------------------------------------------------------------------- */ CREATE TABLE TWIG_CONTACTS_LISTS_ENTRIES ( LISTID NUMBER (16) DEFAULT (0) NOT NULL, TYPE NUMBER (16) DEFAULT (0) NOT NULL, ITEM NUMBER (16) DEFAULT (0) NOT NULL, SUBITEM NUMBER (16) ); COMMIT; /* --------------------------------------------------------------------------------- */ CREATE TABLE TWIG_CONTACTS_PREFS ( ID NUMBER (16), USERNAME VARCHAR2 (128), SORTBY VARCHAR2 (10), SORTORDER NUMBER (16) DEFAULT (0) NOT NULL, DGROUP NUMBER (16) DEFAULT (0) NOT NULL, VIEWGRP VARCHAR2 (10) DEFAULT (0) NOT NULL, PRIMARY KEY (ID) ); CREATE SEQUENCE TWIG.SEQ_TWIG_CONTACTS_PREFS INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER; CREATE TRIGGER TWIG.AI_TWIG_CONTACTS_PREFS BEFORE INSERT ON TWIG.TWIG_CONTACTS_PREFS FOR EACH ROW DECLARE N_NEXTVAL NUMBER; BEGIN SELECT SEQ_TWIG_CONTACTS_PREFS.NEXTVAL INTO N_NEXTVAL FROM DUAL; :NEW.ID := N_NEXTVAL; END; / COMMIT; /* --------------------------------------------------------------------------------- */ CREATE TABLE TWIG_CONTEXT ( ID VARCHAR2 (40) NOT NULL, USERNAME VARCHAR2 (128) NOT NULL, CONTEXT VARCHAR2 (1000) NOT NULL, SID NUMBER DEFAULT (0) NOT NULL ); COMMIT; /* --------------------------------------------------------------------------------- */ CREATE TABLE TWIG_FOLDERS ( ID NUMBER (16), OWNER VARCHAR2 (128) NOT NULL, SERVER VARCHAR2 (255) NOT NULL, PORT NUMBER (16) DEFAULT (0) NOT NULL, GROUPNAME VARCHAR2 (255) NOT NULL, USERNAME VARCHAR2 (128), PASSWORD VARCHAR2 (128), SERVERTYPE VARCHAR2 (10), PRIMARY KEY (ID) ); CREATE SEQUENCE TWIG.SEQ_TWIG_FOLDERS INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER; CREATE TRIGGER TWIG.AI_TWIG_FOLDERS BEFORE INSERT ON TWIG.TWIG_FOLDERS FOR EACH ROW DECLARE N_NEXTVAL NUMBER; BEGIN SELECT SEQ_TWIG_FOLDERS.NEXTVAL INTO N_NEXTVAL FROM DUAL; :NEW.ID := N_NEXTVAL; END; / COMMIT; /* --------------------------------------------------------------------------------- */ CREATE TABLE TWIG_GLOBAL_PREFS ( ID NUMBER (16), USERNAME VARCHAR2 (128), MSTYLE1 NUMBER (16) DEFAULT (0) NOT NULL, MSTYLE2 NUMBER (16) DEFAULT (3) NOT NULL, TSTYLE1 NUMBER (16) DEFAULT (5) NOT NULL, LANGUAGE VARCHAR2 (20), MAILFOOT NUMBER (16), PREVNEXT VARCHAR2 (20), TIMEFORMAT NUMBER (16), PRIMARY KEY (ID) ); CREATE SEQUENCE TWIG.SEQ_TWIG_GLOBAL_PREFS INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER; CREATE TRIGGER TWIG.AI_TWIG_GLOBAL_PREFS BEFORE INSERT ON TWIG.TWIG_GLOBAL_PREFS FOR EACH ROW DECLARE N_NEXTVAL NUMBER; BEGIN SELECT SEQ_TWIG_GLOBAL_PREFS.NEXTVAL INTO N_NEXTVAL FROM DUAL; :NEW.ID := N_NEXTVAL; END; / COMMIT; /* --------------------------------------------------------------------------------- */ CREATE TABLE TWIG_GROUPS ( ID NUMBER (16), OWNER VARCHAR2 (128), GROUPNAME VARCHAR2 (100), TYPE VARCHAR2 (20), PRIMARY KEY (ID) ); CREATE SEQUENCE TWIG.SEQ_TWIG_GROUPS INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER; CREATE TRIGGER TWIG.AI_TWIG_GROUPS BEFORE INSERT ON TWIG.TWIG_GROUPS FOR EACH ROW DECLARE N_NEXTVAL NUMBER; BEGIN SELECT SEQ_TWIG_GROUPS.NEXTVAL INTO N_NEXTVAL FROM DUAL; :NEW.ID := N_NEXTVAL; END; / COMMIT; /* --------------------------------------------------------------------------------- */ CREATE TABLE TWIG_LHSQLTABLE ( LID VARCHAR2 (128), USERNAME VARCHAR2 (128), PASSWORD VARCHAR2 (128), EXPIRE NUMBER (16), PRIMARY KEY (LID) ); COMMIT; /* --------------------------------------------------------------------------------- */ CREATE TABLE TWIG_MAIL_PREFS ( ID NUMBER (16), USERNAME VARCHAR2 (128), REALNAME VARCHAR2 (1000), SIGNATURE VARCHAR2 (1000), LINEWRAP VARCHAR2 (1000), REPLYTO VARCHAR2 (1000), PAGESIZE NUMBER (16), SORTBY VARCHAR2 (10), SORTORDER NUMBER (16), DANDE NUMBER (16), SAVESENT NUMBER (16), SENTFOLD VARCHAR2 (1000), CMDLINE2 NUMBER (16), NEWWINDOW NUMBER (16), LISTCMDS VARCHAR2 (10), NEWCONTACT NUMBER (16 ), DRAFTFOLD VARCHAR2 (1000), NUMUP NUMBER (16), MAILTREE NUMBER (16), MTEXPAND NUMBER (16), MTVIEW VARCHAR (255), MDN NUMBER (16), MDN_MODE NUMBER (16), AREPLY NUMBER (16), AFORWARD NUMBER (16), CLINES NUMBER (16), MANDE NUMBER (16), DRETURN NUMBER (16), FROMADDRESS VARCHAR(128), PRIMARY KEY (ID) ); CREATE SEQUENCE TWIG.SEQ_TWIG_MAIL_PREFS INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER; CREATE TRIGGER TWIG.AI_TWIG_MAIL_PREFS BEFORE INSERT ON TWIG.TWIG_MAIL_PREFS FOR EACH ROW DECLARE N_NEXTVAL NUMBER; BEGIN SELECT SEQ_TWIG_MAIL_PREFS.NEXTVAL INTO N_NEXTVAL FROM DUAL; :NEW.ID := N_NEXTVAL; END; / COMMIT; /* --------------------------------------------------------------------------------- */ CREATE TABLE TWIG_MAIN_PREFS ( ID NUMBER (16), USERNAME VARCHAR2 (128), features VARCHAR2 (128), maxmail NUMBER (16), maxmeetings NUMBER (16), maxschedule NUMBER (16), maxtodo NUMBER (16), PRIMARY KEY (ID) ); CREATE SEQUENCE TWIG.SEQ_TWIG_MAIN_PREFS INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER; CREATE TRIGGER TWIG.AI_TWIG_MAIN_PREFS BEFORE INSERT ON TWIG.TWIG_MAIN_PREFS FOR EACH ROW DECLARE N_NEXTVAL NUMBER; BEGIN SELECT SEQ_TWIG_MAIN_PREFS.NEXTVAL INTO N_NEXTVAL FROM DUAL; :NEW.ID := N_NEXTVAL; END; / COMMIT; /* --------------------------------------------------------------------------------- */ CREATE TABLE TWIG_MEETINGS ( ID NUMBER (16), GROUPID NUMBER (16) NOT NULL, USERNAME VARCHAR2 (128), SECRETARY VARCHAR2 (128), RESPONSIBLE VARCHAR2 (128), THEDATE VARCHAR(16), ITEMSTART VARCHAR(16), ITEMSTOP VARCHAR(16), ITEMDONE VARCHAR(16), ITEM VARCHAR2 (1000), DESCRIPTION VARCHAR2 (1000), MINUTES VARCHAR2 (1000), CONCLUSION VARCHAR2 (1000), ACTIONITEMS VARCHAR2 (1000), LOCATION NUMBER (16) NOT NULL, USERLIMIT NUMBER (16) NOT NULL, CLOSED NUMBER (16) NOT NULL, DELETED NUMBER (16) NOT NULL, PRIVATE NUMBER (16) NOT NULL, PRIMARY KEY (id) ); CREATE SEQUENCE TWIG.SEQ_TWIG_MEETINGS INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER; CREATE TRIGGER TWIG.AI_TWIG_MEETINGS BEFORE INSERT ON TWIG.TWIG_MEETINGS FOR EACH ROW DECLARE N_NEXTVAL NUMBER; BEGIN SELECT SEQ_TWIG_MEETINGS.NEXTVAL INTO N_NEXTVAL FROM DUAL; :NEW.ID := N_NEXTVAL; END; / COMMIT; /* --------------------------------------------------------------------------------- */ CREATE TABLE TWIG_MEETINGS_PREFS ( ID NUMBER (16), USERNAME VARCHAR2 (128), DGROUP NUMBER (16) DEFAULT (0) NOT NULL, MAINVIEW NUMBER (16) DEFAULT (0) NOT NULL, PAGESIZE NUMBER (16) DEFAULT (0) NOT NULL, VIEWGRP VARCHAR2 (10) DEFAULT (0) NOT NULL, PRIMARY KEY (id) ); CREATE SEQUENCE TWIG.SEQ_TWIG_MEETINGS_PREFS INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER; CREATE TRIGGER TWIG.AI_TWIG_MEETINGS_PREFS BEFORE INSERT ON TWIG.TWIG_MEETINGS_PREFS FOR EACH ROW DECLARE N_NEXTVAL NUMBER; BEGIN SELECT SEQ_TWIG_MEETINGS_PREFS.NEXTVAL INTO N_NEXTVAL FROM DUAL; :NEW.ID := N_NEXTVAL; END; / COMMIT; /* --------------------------------------------------------------------------------- */ CREATE TABLE TWIG_MEETINGS_REGISTRATION ( ID NUMBER (16), username VARCHAR2 (128), eventid NUMBER (16) NOT NULL, thedate VARCHAR2 (20), rsvp NUMBER (16) NOT NULL, PRIMARY KEY (id) ); CREATE SEQUENCE TWIG.SEQ_TWIG_MEETINGS_REGISTRATION INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER; CREATE TRIGGER TWIG.AI_TWIG_MEETINGS_REGISTRATION BEFORE INSERT ON TWIG.TWIG_MEETINGS_REGISTRATION FOR EACH ROW DECLARE N_NEXTVAL NUMBER; BEGIN SELECT SEQ_TWIG_MEETINGS_REGISTRATION.NEXTVAL INTO N_NEXTVAL FROM DUAL; :NEW.ID := N_NEXTVAL; END; / COMMIT; /* --------------------------------------------------------------------------------- */ CREATE TABLE TWIG_MEETINGS_INVITATIONS ( ID NUMBER (16), username VARCHAR2 (128), eventid NUMBER (16) NOT NULL, thedate VARCHAR2 (20), priority NUMBER (16) NOT NULL, PRIMARY KEY (id) ); CREATE SEQUENCE TWIG.SEQ_TWIG_MEETINGS_INVITATIONS INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER; CREATE TRIGGER TWIG.AI_TWIG_MEETINGS_INVITATIONS BEFORE INSERT ON TWIG.TWIG_MEETINGS_INVITATIONS FOR EACH ROW DECLARE N_NEXTVAL NUMBER; BEGIN SELECT SEQ_TWIG_MEETINGS_INVITATIONS.NEXTVAL INTO N_NEXTVAL FROM DUAL; :NEW.ID := N_NEXTVAL; END; / COMMIT; /* --------------------------------------------------------------------------------- */ CREATE TABLE TWIG_MEMBERS ( ID NUMBER (16), GROUPID NUMBER (16) NOT NULL, USERNAME VARCHAR2 (128), WRITEPERMS NUMBER (16), PRIMARY KEY (ID) ); CREATE SEQUENCE TWIG.SEQ_TWIG_MEMBERS INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER; CREATE TRIGGER TWIG.AI_TWIG_MEMBERS BEFORE INSERT ON TWIG.TWIG_MEMBERS FOR EACH ROW DECLARE N_NEXTVAL NUMBER; BEGIN SELECT SEQ_TWIG_MEMBERS.NEXTVAL INTO N_NEXTVAL FROM DUAL; :NEW.ID := N_NEXTVAL; END; / COMMIT; /* --------------------------------------------------------------------------------- */ CREATE TABLE TWIG_NEWS_PREFS ( ID NUMBER (16), USERNAME VARCHAR2 (128) NOT NULL, REPLYTO VARCHAR2 (1000) NOT NULL, PAGESIZE NUMBER (16) DEFAULT (0) NOT NULL, NEWWINDOW NUMBER (16) DEFAULT (1) NOT NULL, LINEWRAP VARCHAR2 (1000) NOT NULL, REALNAME VARCHAR2 (1000) NOT NULL, SIGNATURE VARCHAR2 (1000) NOT NULL, INLINE NUMBER (16), PRIMARY KEY (ID) ); CREATE SEQUENCE TWIG.SEQ_TWIG_NEWS_PREFS INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER; CREATE TRIGGER TWIG.AI_TWIG_NEWS_PREFS BEFORE INSERT ON TWIG.TWIG_NEWS_PREFS FOR EACH ROW DECLARE N_NEXTVAL NUMBER; BEGIN SELECT SEQ_TWIG_NEWS_PREFS.NEXTVAL INTO N_NEXTVAL FROM DUAL; :NEW.ID := N_NEXTVAL; END; / COMMIT; /* --------------------------------------------------------------------------------- */ CREATE TABLE TWIG_NOTES ( ID NUMBER (16), USERNAME VARCHAR2 (128), THEDATE VARCHAR(16), GROUPID NUMBER (16) NOT NULL, ITEM VARCHAR2 (1000), DESCRIPTION VARCHAR2 (1000), ATTACHNAME VARCHAR2 (1000), ATTACHMIME VARCHAR2 (1000), ATTACHMENT CLOB, PRIMARY KEY (id), KEY (username) ); CREATE SEQUENCE TWIG.SEQ_TWIG_NOTES INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER; CREATE TRIGGER TWIG.AI_TWIG_SCHEDULE BEFORE INSERT ON TWIG.TWIG_NOTES FOR EACH ROW DECLARE N_NEXTVAL NUMBER; BEGIN SELECT SEQ_TWIG_NOTES.NEXTVAL INTO N_NEXTVAL FROM DUAL; :NEW.ID := N_NEXTVAL; END; / COMMIT; /* --------------------------------------------------------------------------------- */ CREATE TABLE TWIG_NOTES_PREFS ( ID NUMBER (16), USERNAME VARCHAR2 (128), SORTBY VARCHAR2 (10), SORTORDER NUMBER (16) DEFAULT (0) NOT NULL, DGROUP NUMBER (16) DEFAULT (0) NOT NULL, WIDTH NUMBER (16), HEIGHT NUMBER (16), PAGESIZE NUMBER (16), VIEWGRP VARCHAR2 (10) DEFAULT (0) NOT NULL, PRIMARY KEY (ID) KEY (username) ); CREATE SEQUENCE TWIG.SEQ_TWIG_NOTES_PREFS INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER; CREATE TRIGGER TWIG.AI_TWIG_NOTES_PREFS BEFORE INSERT ON TWIG.TWIG_NOTES_PREFS FOR EACH ROW DECLARE N_NEXTVAL NUMBER; BEGIN SELECT SEQ_TWIG_NOTES_PREFS.NEXTVAL INTO N_NEXTVAL FROM DUAL; :NEW.ID := N_NEXTVAL; END; / COMMIT; /* --------------------------------------------------------------------------------- */ CREATE TABLE TWIG_SCHEDULE ( ID NUMBER (16), USERNAME VARCHAR2 (128), THEDATE VARCHAR(16), GROUPID NUMBER (16) NOT NULL, ITEMSTART VARCHAR(16), ITEMSTOP VARCHAR(16), ITEM VARCHAR2 (1000), DESCRIPTION VARCHAR2 (1000), NOTIME NUMBER (16), RECURTYPE NUMBER (16), RECURID NUMBER (16), PRIMARY KEY (ID) ); CREATE SEQUENCE TWIG.SEQ_TWIG_SCHEDULE INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER; CREATE TRIGGER TWIG.AI_TWIG_SCHEDULE BEFORE INSERT ON TWIG.TWIG_SCHEDULE FOR EACH ROW DECLARE N_NEXTVAL NUMBER; BEGIN SELECT SEQ_TWIG_SCHEDULE.NEXTVAL INTO N_NEXTVAL FROM DUAL; :NEW.ID := N_NEXTVAL; END; / COMMIT; /* --------------------------------------------------------------------------------- */ CREATE TABLE twig_schedule_recurring ( ID INT, SCHID INT, RECURTYPE INT NOT NULL, SCHEDULE INT, CYCLE INT, POSITION INT, DAYS VARCHAR (13), ENDTYPE INT NOT NULL, END DATETIME NOT NULL, PRIMARY KEY (ID) ); CREATE SEQUENCE TWIG.SEQ_TWIG_SCHEDULE_RECURRING INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER; CREATE TRIGGER TWIG.AI_TWIG_SCHEDULE_RECURRING BEFORE INSERT ON TWIG.TWIG_SCHEDULE_RECURRING FOR EACH ROW DECLARE N_NEXTVAL NUMBER; BEGIN SELECT SEQ_TWIG_SCHEDULE_RECURRING.NEXTVAL INTO N_NEXTVAL FROM DUAL; :NEW.ID := N_NEXTVAL; END; / COMMIT; /* --------------------------------------------------------------------------------- */ CREATE TABLE TWIG_SCHEDULE_PREFS ( ID NUMBER (16), USERNAME VARCHAR2 (128), DGROUP NUMBER (16) DEFAULT (0) NOT NULL, VIEWGRP VARCHAR2 (10) DEFAULT (0) NOT NULL, PRIMARY KEY (ID) ); CREATE SEQUENCE TWIG.SEQ_TWIG_SCHEDULE_PREFS INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER; CREATE TRIGGER TWIG.AI_TWIG_SCHEDULE_PREFS BEFORE INSERT ON TWIG.TWIG_SCHEDULE_PREFS FOR EACH ROW DECLARE N_NEXTVAL NUMBER; BEGIN SELECT SEQ_TWIG_SCHEDULE_PREFS.NEXTVAL INTO N_NEXTVAL FROM DUAL; :NEW.ID := N_NEXTVAL; END; / COMMIT; /* --------------------------------------------------------------------------------- */ CREATE TABLE TWIG_SCLHSQLTABLE ( LID VARCHAR2 (128), PWDATA VARCHAR2 (128), USERNAME VARCHAR2 (128), EXPIRE NUMBER (16), PRIMARY KEY (LID) ); COMMIT; /* --------------------------------------------------------------------------------- */ CREATE TABLE TWIG_SESSION ( ID VARCHAR2 (40) NOT NULL, USERNAME VARCHAR2 (128) NOT NULL, SDATA CLOB NOT NULL, SID NUMBER DEFAULT (0) NOT NULL ); COMMIT; /* --------------------------------------------------------------------------------- */ CREATE TABLE TWIG_TODO ( ID NUMBER (16), USERNAME VARCHAR2 (128), THEDATE VARCHAR(16), GROUPID NUMBER (16) NOT NULL, ITEM VARCHAR2 (1000), DESCRIPTION VARCHAR2 (1000), PRIORITY NUMBER (16), COMPLETED NUMBER (16), DUEDATE VARCHAR(16), DUETYPE NUMBER (16), PRIMARY KEY (ID) ); CREATE SEQUENCE TWIG.SEQ_TWIG_TODO INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER; CREATE TRIGGER TWIG.AI_TWIG_TODO BEFORE INSERT ON TWIG.TWIG_TODO FOR EACH ROW DECLARE N_NEXTVAL NUMBER; BEGIN SELECT SEQ_TWIG_TODO.NEXTVAL INTO N_NEXTVAL FROM DUAL; :NEW.ID := N_NEXTVAL; END; / COMMIT; /* --------------------------------------------------------------------------------- */ CREATE TABLE TWIG_TODO_LISTS_ENTRIES ( LISTID NUMBER (16) DEFAULT (0) NOT NULL, TYPE NUMBER (16) DEFAULT (0) NOT NULL, ITEM NUMBER (16) DEFAULT (0) NOT NULL, SUBITEM NUMBER (16) ); COMMIT; /* --------------------------------------------------------------------------------- */ CREATE TABLE TWIG_TODO_PREFS ( ID NUMBER (16), USERNAME VARCHAR2 (20), SORTBY VARCHAR2 (10), SORTORDER NUMBER (16) DEFAULT (0) NOT NULL, DGROUP NUMBER (16) DEFAULT (0) NOT NULL, PRIORITY NUMBER (16) DEFAULT (0) NOT NULL, PAGESIZE NUMBER (16) DEFAULT (0) NOT NULL, VIEWGRP VARCHAR2 (10) DEFAULT (0) NOT NULL, DUETYPE NUMBER (16) DEFAULT (0) NOT NULL, PRIMARY KEY (ID) ); CREATE SEQUENCE TWIG.SEQ_TWIG_TODO_PREFS INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER; CREATE TRIGGER TWIG.AI_TWIG_TODO_PREFS BEFORE INSERT ON TWIG.TWIG_TODO_PREFS FOR EACH ROW DECLARE N_NEXTVAL NUMBER; BEGIN SELECT SEQ_TWIG_TODO_PREFS.NEXTVAL INTO N_NEXTVAL FROM DUAL; :NEW.ID := N_NEXTVAL; END; / COMMIT; /* --------------------------------------------------------------------------------- */