ALTER TABLE twig_lhsqltable CHANGE LID LID varchar(40) DEFAULT '0' NOT NULL; ALTER TABLE twig_global_prefs ADD timeformat int(11); ALTER TABLE twig_mail_prefs ADD numup int(11); CREATE TABLE twig_notes ( id INT AUTO_INCREMENT NOT NULL, username VARCHAR(20) NOT NULL, thedate TIMESTAMP, groupid INT NOT NULL, item TEXT, description TEXT, attachname TEXT, attachment TEXT, PRIMARY KEY (id), KEY (username) ); CREATE TABLE twig_notes_prefs ( id INT(11) DEFAULT '0' NOT NULL AUTO_INCREMENT, 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), PRIMARY KEY (id), KEY (username) ); CREATE TABLE twig_meetings ( id int(11) DEFAULT '0' NOT NULL auto_increment, 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(11) DEFAULT '0' NOT NULL, userlimit int(11) DEFAULT '0' NOT NULL, closed int(11) DEFAULT '0' NOT NULL, deleted int(11) DEFAULT '0' NOT NULL, private int(11) DEFAULT '0' NOT NULL, PRIMARY KEY (id), KEY id (id) ); CREATE TABLE twig_meetings_prefs ( id int(11) DEFAULT '0' NOT NULL auto_increment, username varchar(20), dgroup int(11) DEFAULT '0' NOT NULL, mainview int(11) DEFAULT '0' NOT NULL, pagesize int(11) DEFAULT '0' NOT NULL, PRIMARY KEY (id) ); CREATE TABLE twig_meetings_registration ( idx int(11) DEFAULT '0' NOT NULL auto_increment, user_idx varchar(20), event_idx int(11) DEFAULT '0' NOT NULL, r_date timestamp(14), rsvp int(11) DEFAULT '0' NOT NULL, PRIMARY KEY (idx), KEY idx (idx) );