ALTER TABLE twig_news_prefs ADD inline INT;
ALTER TABLE twig_contacts ADD type INT;
ALTER TABLE twig_contacts ADD userpers INT;
ALTER TABLE twig_mail_prefs ADD dreturn INT;
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		INT DEFAULT '0' NOT NULL,
	type		INT DEFAULT '0' NOT NULL,
	item		INT DEFAULT '0' NOT NULL,
	subitem		INT
)
go

CREATE INDEX twig_contacts_lists_entries_i_idx ON twig_contacts_lists_entries (listid)
go
CREATE INDEX twig_contacts_lists_entries_t_idx ON twig_contacts_lists_entries (item)
go

CREATE TABLE twig_schedule_recurring (
	id		NUMERIC IDENTITY NOT NULL PRIMARY KEY,
	schid		INT,
	recurtype	INT DEFAULT '0' not null,
	schedule	INT,
	cycle		INT,
	position	INT,
	days		VARCHAR(13),
	endtype		INT DEFAULT '0' not null,
	end		DATETIME
	)
go

CREATE INDEX twig_schedule_recurring_i_idx ON twig_schedule_recurring (id)
go
CREATE INDEX twig_schedule_recurring_c_idx ON twig_schedule_recurring (schid)
go
CREATE INDEX twig_schedule_recurring_t_idx ON twig_schedule_recurring (recurtype)
go
CREATE INDEX twig_schedule_recurring_e_idx ON twig_schedule_recurring (endtype)
go
CREATE INDEX twig_schedule_recurring_d_idx ON twig_schedule_recurring (end)
go

ALTER TABLE twig_announce RENAME date TO thedate
go
ALTER TABLE twig_acls RENAME identity TO ident
go