ALTER TABLE twig_lhsqltable RENAME COLUMN lid TO lidold; ALTER TABLE twig_lhsqltable ADD LID varchar(40) DEFAULT '0' NOT NULL; ALTER TABLE twig_global_prefs ADD timeformat int4; ALTER TABLE twig_mail_prefs ADD numup int4; CREATE SEQUENCE twnoteid start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; SELECT nextval ('twnoteid'); CREATE TABLE twig_notes ( id int4 DEFAULT nextval ( 'twnoteid' ), username VARCHAR(20) NOT NULL, thedate TIMESTAMP, groupid INT4 NOT NULL, item TEXT, description TEXT, attachname TEXT, attachment TEXT ); CREATE INDEX twig_notes_username_index ON twig_notes (username); CREATE SEQUENCE twnotepid start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; SELECT nextval ('twnotepid'); CREATE TABLE twig_notes_prefs ( id int4 DEFAULT nextval ( 'twnotepid' ), username VARCHAR(20) NOT NULL, sortby VARCHAR(10) NOT NULL, sortorder int4 DEFAULT '0' NOT NULL, dgroup int4 DEFAULT '0' NOT NULL, width int4, height int4 ); CREATE INDEX twig_notes_prefs_username_index ON twig_notes_prefs (username); CREATE SEQUENCE twmeetid start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; SELECT nextval ('twmeetid'); CREATE TABLE twig_meetings ( id int4 DEFAULT nextval ('twmeetid'), groupid int4 DEFAULT '0' NOT NULL, username varchar(20), secretary varchar(20), responsible varchar(20), thedate TIMESTAMP, itemstart TIMESTAMP, itemstop TIMESTAMP, itemdone TIMESTAMP, item text, description text, minutes text, conclusion text, actionitems text, location int4 DEFAULT '0' NOT NULL, userlimit int4 DEFAULT '0' NOT NULL, closed int4 DEFAULT '0' NOT NULL, deleted int4 DEFAULT '0' NOT NULL, private int4 DEFAULT '0' NOT NULL ); CREATE INDEX twig_meetings_id_index ON twig_meetings (id); CREATE SEQUENCE twmeetpid start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; SELECT nextval ('twmeetpid'); CREATE TABLE twig_meetings_prefs ( id int4 DEFAULT nextval ('twmeetpid'), username varchar(20), dgroup int4 DEFAULT '0' NOT NULL, mainview int4 DEFAULT '0' NOT NULL, pagesize int4 DEFAULT '0' NOT NULL ); CREATE INDEX twig_meetings_prefs_id_index ON twig_meetings_prefs (id); CREATE SEQUENCE twmeetrid start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; SELECT nextval ('twmeetrid'); CREATE TABLE twig_meetings_registration ( idx int4 DEFAULT nextval ('twmeetrid'), user_idx varchar(20), event_idx int4 DEFAULT '0' NOT NULL, r_date TIMESTAMP, rsvp int4 DEFAULT '0' NOT NULL, PRIMARY KEY (idx) ); CREATE INDEX twig_meetings_registration_id_index ON twig_meetings_registration (idx);