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