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;