ALTER TABLE twig_lhsqltable CHANGE LID LID varchar(40) DEFAULT '0' NOT NULL; ALTER TABLE twig_global_prefs ADD timeformat NUMERIC; 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 ); CREATE INDEX twig_notes_username_index ON twig_notes (username); 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) ); CREATE INDEX twig_notes_prefs_username_index ON twig_notes_prefs (username); CREATE TABLE twig_meetings ( id NUMERIC IDENTITY PRIMARY KEY, groupid INT NOT NULL, username varchar(20), secretary varchar(20), responsible varchar(20), thedate TIMESTAMP, itemstart DATETIME, itemstop DATETIME, itemdone DATETIME, item text, description text, minutes text, conclusion text, actionitems text, location INT NOT NULL, userlimit INT NOT NULL, closed INT NOT NULL, deleted INT NOT NULL, private INT NOT NULL ); CREATE TABLE twig_meetings_prefs ( id NUMERIC IDENTITY PRIMARY KEY, username varchar(20), dgroup INT NOT NULL, mainview INT NOT NULL, pagesize INT NOT NULL ); CREATE TABLE twig_meetings_registration ( idx NUMERIC IDENTITY PRIMARY KEY, user_idx varchar(20), event_idx INT NOT NULL, r_date TIMESTAMP, rsvp INT NOT NULL );