ALTER TABLE twig_news_prefs ADD inline NUMBER (16); ALTER TABLE twig_contacts ADD type NUMBER (16); ALTER TABLE twig_contacts ADD userpers NUMBER (16); ALTER TABLE twig_mail_prefs ADD dreturn NUMBER (16); ALTER TABLE twig_mail_prefs ADD fromaddress varchar(128); ALTER TABLE twig_schedule ADD recurtype INT; ALTER TABLE twig_schedule ADD recurid INT; UPDATE twig_schedule SET recurtype=0 WHERE recurtype!=1; 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_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 ALTER TABLE twig_acls MODIFY identity ident; COMMIT;