ALTER TABLE twig_mail_prefs ADD mdn_mode int4;
ALTER TABLE twig_mail_prefs ADD areply int4;
ALTER TABLE twig_mail_prefs ADD aforward int4;
ALTER TABLE twig_mail_prefs ADD clines int4;
ALTER TABLE twig_mail_prefs ADD mande int4;
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 int4;
ALTER TABLE twig_todo ADD duedate TIMESTAMP;
ALTER TABLE twig_todo ADD duetype int4;

CREATE TABLE twig_meetings_invitations (
  	idx 		int4 DEFAULT nextval ('twmeetiid'),
  	user_idx 	varchar(20),
  	event_idx 	int4 DEFAULT '0' NOT NULL,
  	r_date 		TIMESTAMP,
  	priority	int4 DEFAULT '0' NOT NULL,
  	PRIMARY KEY 	(idx)
);

CREATE SEQUENCE memberid start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
SELECT nextval ('memberid');

DROP INDEX "twig_acl_groups_pkey";
CREATE INDEX twig_acl_groups_groupname_index ON twig_acl_groups (groupname);

CREATE SEQUENCE twanid start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
SELECT nextval ('twanid');

CREATE TABLE twig_announce (
   	id 		int4 DEFAULT nextval ( 'twanid'),
   	date 		TIMESTAMP,
   	username 	VARCHAR(128) NOT NULL,
	email		varchar(128),
   	subject 	VARCHAR(128) NOT NULL,
   	announce 	TEXT NOT NULL,
   	PRIMARY KEY 	(id)
);