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

CREATE TABLE "TWIG_MEETINGS_REGISTRATION" ("IDX" INTEGER DEFAULT '0' NOT NULL,
        "USER_IDX" VARCHAR(20),
        "EVENT_IDX" INTEGER DEFAULT '0' NOT NULL,
        "R_DATE" TIMESTAMP,
        "PRIORITY" VARCHAR(10) DEFAULT 'Unknown' NOT NULL,
PRIMARY KEY ("IDX"));

/* Table: TWIG_ANNOUNCE, Owner: SYSDBA */
CREATE TABLE "TWIG_ANNOUNCE" ("ID" INTEGER default '0' NOT NULL,
        "DATE" TIMESTAMP,
        "USERNAME" VARCHAR(128) NOT NULL,
	"EMAIL"	VARCHAR(128),
	"SUBJECT" VARCHAR(128) NOT NULL,
	"ANNOUNCE" "TEXT" NOT NULL,
PRIMARY KEY ("ID"));