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
);