ALTER TABLE twig_news_prefs ADD inline INTEGER;
ALTER TABLE twig_contacts ADD type INTEGER;
ALTER TABLE twig_contacts ADD userpers INTEGER;
ALTER TABLE twig_mail_prefs ADD dreturn INTEGER;
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" INTEGER DEFAULT '0' NOT NULL,
	"TYPE" INTEGER DEFAULT '0' NOT NULL,
	"ITEM" INTEGER DEFAULT '0' NOT NULL,
	"SUBITEM" INTEGER
);

CREATE TABLE "TWIG_SCHEDULE_RECURRING" ("ID" INTEGER default '0' NOT NULL,
	"SCHID"		INTEGER,
	"RECURTYPE"	INTEGER NOT NULL,
	"SCHEDULE"	INTEGER,
	"CYCLE"		INTEGER,
	"POSITION"	INTEGER,
	"DAYS"		VARCHAR (13),
	"ENDTYPE"	INTEGER NOT NULL,
	"END"		TIMESTAMP NOT NULL,
	PRIMARY KEY	("ID")
	);

GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON "TWIG_CONTACTS_LISTS_ENTRIES" TO NOBODY;
GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON "TWIG_SCHEDULE_RECURRING" TO NOBODY;

ALTER TABLE twig_announce ALTER COLUMN date TO thedate;
ALTER TABLE twig_acls ALTER COLUMN identity TO ident;