ALTER TABLE twig_lhsqltable CHANGE LID LID varchar(40) DEFAULT '0' NOT NULL; ALTER TABLE twig_global_prefs ADD timeformat NUMBER (16); ALTER TABLE twig_mail_prefs ADD numup NUMBER (16); /* --------------------------------------------------------------------------------- */ CREATE TABLE TWIG_NOTES ( ID NUMBER (16), USERNAME VARCHAR2 (20), THEDATE VARCHAR(16), GROUPID NUMBER (16) NOT NULL, ITEM VARCHAR2 (1000), DESCRIPTION VARCHAR2 (1000), ATTACHNAME 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 (20), SORTBY VARCHAR2 (10), SORTORDER NUMBER (16) DEFAULT (0) NOT NULL, DGROUP NUMBER (16) DEFAULT (0) NOT NULL, WIDTH NUMBER (16), HEIGHT NUMBER (16), 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_MEETINGS ( ID NUMBER (16), GROUPID NUMBER (16) NOT NULL, USERNAME VARCHAR2 (20), SECRETARY VARCHAR2 (20), RESPONSIBLE VARCHAR2 (20), 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 (20), DGROUP NUMBER (16) DEFAULT (0) NOT NULL, MAINVIEW NUMBER (16) DEFAULT (0) NOT NULL, PAGESIZE NUMBER (16) 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 ( IDX NUMBER (16), user_idx VARCHAR2 (20), event_idx NUMBER (16) NOT NULL, r_date VARCHAR2 (20), rsvp NUMBER (16) NOT NULL, PRIMARY KEY (idx), ); 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;