ALTER TABLE twig_mail_prefs ADD mdn_mode NUMBER (16); ALTER TABLE twig_mail_prefs ADD areply NUMBER (16); ALTER TABLE twig_mail_prefs ADD aforward NUMBER (16); ALTER TABLE twig_mail_prefs ADD clines NUMBER (16); ALTER TABLE twig_mail_prefs ADD mande NUMBER (16); ALTER TABLE twig_bookmarks_prefs ADD viewgrp VARCHAR2 (10); ALTER TABLE twig_contacts_prefs ADD viewgrp VARCHAR2 (10); ALTER TABLE twig_meetings_prefs ADD viewgrp VARCHAR2 (10); ALTER TABLE twig_notes_prefs ADD viewgrp VARCHAR2 (10); ALTER TABLE twig_schedule_prefs ADD viewgrp VARCHAR2 (10); ALTER TABLE twig_todo_prefs ADD viewgrp VARCHAR2 (10); ALTER TABLE twig_todo_prefs ADD duetype NUMBER (16); ALTER TABLE twig_todo ADD duedate VARCHAR(16); ALTER TABLE twig_todo ADD duetype NUMBER (16); COMMIT; CREATE TABLE TWIG_MEETINGS_INVITATIONS ( IDX NUMBER (16), user_idx VARCHAR2 (20), event_idx NUMBER (16) NOT NULL, r_date VARCHAR2 (20), priority NUMBER (16) NOT NULL, PRIMARY KEY (idx), ); 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_announce ( ID NUMBER (16), DATE 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;