ALTER TABLE twig_mail_prefs ADD mdn_mode INT; ALTER TABLE twig_mail_prefs ADD areply INT; ALTER TABLE twig_mail_prefs ADD aforward INT; ALTER TABLE twig_mail_prefs ADD clines INT; ALTER TABLE twig_mail_prefs ADD mande INT; ALTER TABLE twig_bookmarks_prefs ADD viewgrp varchar(10); ALTER TABLE twig_contacts_prefs ADD viewgrp varchar(10); ALTER TABLE twig_meetings_prefs ADD viewgrp varchar(10); ALTER TABLE twig_notes_prefs ADD viewgrp varchar(10); ALTER TABLE twig_schedule_prefs ADD viewgrp varchar(10); ALTER TABLE twig_todo_prefs ADD viewgrp varchar(10); ALTER TABLE twig_todo_prefs ADD duetype INT; ALTER TABLE twig_todo ADD duedate DATETIME; ALTER TABLE twig_todo ADD duetype INT; CREATE TABLE twig_meetings_invitations ( idx NUMERIC IDENTITY PRIMARY KEY, user_idx varchar(20), event_idx INT NOT NULL, r_date TIMESTAMP, priority INT NOT NULL ); CREATE TABLE twig_announce ( id NUMERIC IDENTITY PRIMARY KEY, date TIMESTAMP, username varchar(128) NOT NULL, email varchar(128), subject varchar(128) NOT NULL, announce TEXT NOT NULL ); CREATE INDEX twig_announce_id_index ON twig_announce (id);