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);