ALTER TABLE twig_lhsqltable CHANGE LID LID varchar(40) DEFAULT '0' NOT NULL; ALTER TABLE twig_global_prefs ADD timeformat INT; ALTER TABLE twig_mail_prefs ADD numup INT; CREATE TABLE twig_notes ( id NUMERIC IDENTITY NOT NULL PRIMARY KEY, username VARCHAR(20) NOT NULL, thedate TIMESTAMP, groupid INT NOT NULL, item TEXT, description TEXT, attachname TEXT, attachment TEXT ) go CREATE INDEX twig_notes_username_index ON twig_notes (username) go CREATE TABLE twig_notes_prefs ( id NUMERIC DEFAULT '0' NOT NULL IDENTITY PRIMARY KEY, username VARCHAR(20) NOT NULL, sortby VARCHAR(10) NOT NULL, sortorder INT(1) DEFAULT '0' NOT NULL, dgroup INT(11) DEFAULT '0' NOT NULL, width INT(11), height INT(11) ) go CREATE INDEX twig_notes_prefs_username_index ON twig_notes_prefs (username) go CREATE TABLE twig_meetings ( id NUMERIC IDENTITY NOT NULL PRIMARY KEY, groupid int(11) DEFAULT '0' NOT NULL, username varchar(20), secretary varchar(20), responsible varchar(20), thedate timestamp(14), itemstart timestamp(14), itemstop timestamp(14), itemdone timestamp(14), item text, description text, minutes text, conclusion text, actionitems text, location int DEFAULT '0' NOT NULL, userlimit int DEFAULT '0' NOT NULL, closed int DEFAULT '0' NOT NULL, deleted int DEFAULT '0' NOT NULL, private int DEFAULT '0' NOT NULL ) go CREATE TABLE twig_meetings_prefs ( id NUMERIC IDENTITY NOT NULL PRIMARY KEY, username varchar(20), dgroup int DEFAULT '0' NOT NULL, mainview int DEFAULT '0' NOT NULL, pagesize int DEFAULT '0' NOT NULL ) go CREATE TABLE twig_meetings_registration ( idx NUMERIC IDENTITY NOT NULL PRIMARY KEY, user_idx varchar(20), event_idx int DEFAULT '0' NOT NULL, r_date TIMESTAMP, rsvp int DEFAULT '0' NOT NULL ) go