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