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