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

CREATE TABLE twig_meetings_invitations (
  	idx 		NUMERIC IDENTITY NOT NULL PRIMARY KEY,
  	user_idx 	varchar(20),
  	event_idx 	int DEFAULT '0' NOT NULL,
  	r_date 		TIMESTAMP,
  	priority	int DEFAULT '0' NOT NULL
)
go

CREATE TABLE twig_announce (
   	id 		NUMERIC IDENTITY NOT NULL PRIMARY KEY,
   	date 		DATETIME,
   	username 	varchar(128) NOT NULL,
	email		varchar(128),
   	subject 	varchar(128) NOT NULL,
   	announce 	TEXT NOT NULL,
   	PRIMARY KEY 	(id)
);

CREATE INDEX twig_acl_announce_g_idx ON twig_announce (id)
go