CREATE TABLE twig_accounts (
   	id 		int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
   	username 	varchar(128) NOT NULL,
   	password 	varchar(128),
	SID		int(10),
   	onnow		bigint(21),
   	expire		bigint(21),
   	laston		bigint(21),
   	PRIMARY KEY 	(id),
   	KEY 		(username)
);

CREATE TABLE twig_acls (
   	SID 		int(10) unsigned DEFAULT '0' NOT NULL,
   	ident	 	varchar(128) NOT NULL,
   	alevel 		int(10) unsigned DEFAULT '0' NOT NULL,
   	KEY 		(SID),
	KEY 		(ident)
);

CREATE TABLE twig_acl_groups (
   	SID 		int(10) unsigned DEFAULT '0' NOT NULL,
   	groupname 	varchar(64) NOT NULL,
   	username 	varchar(128) NOT NULL,
   	KEY 		(groupname),
	KEY 		(username)
);

CREATE TABLE twig_announce (
   	id 		int(11) DEFAULT '0' NOT NULL auto_increment,
   	thedate 	timestamp(14),
   	username 	varchar(128) NOT NULL,
	email		varchar(128),
   	subject 	varchar(128) NOT NULL,
   	announce 	longtext NOT NULL,
   	PRIMARY KEY 	(id)
);

CREATE TABLE twig_bookmarks (
 	id		INT AUTO_INCREMENT NOT NULL,
 	username	VARCHAR(128) NOT NULL,
 	thedate		TIMESTAMP,
 	groupid		INT NOT NULL,
 	item		TEXT,
 	description	TEXT,
 	url		TEXT,
	PRIMARY KEY 	(id),
	KEY 		(id),
	KEY 		(username),
	KEY 		(groupid)
);

CREATE TABLE twig_bookmarks_prefs (
   	id 		INT(11) DEFAULT '0' NOT NULL AUTO_INCREMENT,
   	username 	varchar(128) NOT NULL,
   	sortby 		varchar(10) NOT NULL,
   	sortorder 	int(1) DEFAULT '0' NOT NULL,
   	dgroup 		int(11) DEFAULT '0' NOT NULL,
   	pagesize	int(11) DEFAULT '0' NOT NULL,
   	viewgrp		varchar(10) DEFAULT '0' NOT NULL,
   	PRIMARY KEY 	(id),
	KEY		(username)
);

CREATE TABLE twig_contacts (
 	id		INT AUTO_INCREMENT NOT NULL,
 	username	VARCHAR(128) NOT NULL,
 	thedate		TIMESTAMP,
 	groupid		INT NOT NULL,
 	item		TEXT,
 	description	TEXT,
 	url		TEXT,
 	firstname	VARCHAR(100),
 	lastname	VARCHAR(100),
 	email		VARCHAR(100),
 	company		VARCHAR(100),
 	home_phone	VARCHAR(30),
 	work_phone	VARCHAR(30),
 	mobile		VARCHAR(30),
 	fax		VARCHAR(30),
 	address1	VARCHAR(200),
 	address2	VARCHAR(200),
 	city		VARCHAR(100),
 	state		VARCHAR(10),
 	zipcode		VARCHAR(10),
 	country		VARCHAR(100),
 	email2 		VARCHAR(100),
 	email3 		VARCHAR(100),
 	title 		VARCHAR(100),
 	pager 		VARCHAR(30),
 	ofax 		VARCHAR(30),
 	department 	VARCHAR(100),
 	office 		VARCHAR(100),
 	spouse 		VARCHAR(100),
 	bday 		VARCHAR(40),
 	oaddress1 	VARCHAR(100),
 	oaddress2 	VARCHAR(100),
 	ocity 		VARCHAR(100),
 	ozip 		VARCHAR(10),
 	ostate 		VARCHAR(10),
 	ocountry 	VARCHAR(100),
	type		int(11),
 	userpers	INT DEFAULT '0',
   	PRIMARY KEY 	(id),
	KEY 		(username),
	KEY 		(groupid)
);

CREATE TABLE twig_contacts_lists_entries (
	listid		int(11) DEFAULT '0' NOT NULL,
	type		int(11) DEFAULT '0' NOT NULL,
	item		int(11) DEFAULT '0' NOT NULL,
	subitem		int(11),
	KEY		(listid),
	KEY		(item)
);

CREATE TABLE twig_contacts_prefs (
   	id 		int(11) DEFAULT '0' NOT NULL AUTO_INCREMENT,
   	username 	varchar(128) NOT NULL,
   	sortby 		varchar(10) NOT NULL,
   	sortorder 	int(1) DEFAULT '0' NOT NULL,
   	dgroup 		int(11) DEFAULT '0' NOT NULL,
	pagesize	int(11) NOT NULL,
   	viewgrp		varchar(10) DEFAULT '0' NOT NULL,
   	PRIMARY KEY 	(id),
	KEY 		(username)
);

CREATE TABLE twig_context (
   	id 		varchar(40) NOT NULL,
   	username 	varchar(128) NOT NULL,
   	context 	longtext NOT NULL,
   	sid 		int(11) DEFAULT '0' NOT NULL,
   	KEY 		id (id),
   	KEY 		username (username),
   	KEY 		sid (sid)
);

CREATE TABLE twig_folders (
   	id 		int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
   	owner 		varchar(128) NOT NULL,
   	server 		varchar(255) NOT NULL,
   	port 		int(11) DEFAULT '0' NOT NULL,
   	groupname 	varchar(255) NOT NULL,
  	username 	varchar(128),
  	password 	varchar(128),
   	servertype 	varchar(10),
   	PRIMARY KEY 	(id),
   	KEY 		(owner),
   	KEY 		(groupname)
);

CREATE TABLE twig_global_prefs (
   	id 		int(11) DEFAULT '0' NOT NULL auto_increment,
   	username 	varchar(128) NOT NULL,
   	mstyle1 	tinyint(4) DEFAULT '0' NOT NULL,
   	mstyle2 	tinyint(4) DEFAULT '3' NOT NULL,
   	tstyle1 	tinyint(4) DEFAULT '5' NOT NULL,
   	language 	varchar(20),
   	mailfoot	tinyint(4),
   	prevnext	varchar(20),
	timeformat	int(11),
   	PRIMARY KEY 	(id),
	KEY		(username)
);

CREATE TABLE twig_groups (
	id		INT AUTO_INCREMENT NOT NULL,
	owner		varchar(128) NOT NULL,
	groupname	varchar(100),
	type		varchar(20),
   	PRIMARY KEY 	(id),
	KEY		(owner)
);

CREATE TABLE twig_lhsqltable (
   	LID 		varchar(128) DEFAULT '0' NOT NULL,
   	username 	varchar(128) NOT NULL,
   	password 	varchar(128) NOT NULL,
   	expire 		bigint(21) DEFAULT '0' NOT NULL,
   	PRIMARY KEY 	(LID)
);

CREATE TABLE twig_mail_prefs (
	id		INT AUTO_INCREMENT NOT NULL,
	username	varchar(128) NOT NULL,
	realname	TEXT,
	signature	TEXT,
 	linewrap	TEXT,
	replyto		TEXT,
	pagesize	INT,
	sortby		varchar(10),
	sortorder	INT,
	dande		INT,
   	savesent 	INT,
   	sentfold 	TEXT,
   	draftfold 	TEXT,
	cmdline2	INT,
	newwindow	INT,
	newcontact	INT,
	numup		INT,
	mailtree 	INT,
	mtexpand 	INT,
	mtview 		varchar(255),
	mdn	 	INT,
	mdn_mode 	INT,
	areply		INT,
	aforward	INT,
	clines		INT,
	mande		INT,
	dreturn		INT,
	fromaddress	varchar(128),
	PRIMARY KEY	(id),
	KEY		(username)
);

CREATE TABLE twig_main_prefs (
   	id 		int(11) DEFAULT '0' NOT NULL auto_increment,
   	username 	varchar(128) NOT NULL,
   	features 	varchar(128),
	maxmail		int(11),
	maxmeetings	int(11),
	maxschedule	int(11),
	maxtodo		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(128),
  	secretary	varchar(128),
  	responsible	varchar(128),
  	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)
);

CREATE TABLE twig_meetings_prefs (
  	id 		int(11) DEFAULT '0' NOT NULL auto_increment,
  	username 	varchar(128) NOT NULL,
  	dgroup 		int(11) DEFAULT '0' NOT NULL,
  	mainview	int(11) DEFAULT '0' NOT NULL,
  	pagesize	int(11) DEFAULT '0' NOT NULL,
   	viewgrp		varchar(10) DEFAULT '0' NOT NULL,
  	PRIMARY KEY 	(id)
);

CREATE TABLE twig_meetings_registration (
  	id 		int(11) DEFAULT '0' NOT NULL auto_increment,
  	username 	varchar(128) NOT NULL,
  	eventid 	int(11) DEFAULT '0' NOT NULL,
  	thedate		timestamp(14),
  	rsvp 		int(11) DEFAULT '0' NOT NULL,
  	PRIMARY KEY 	(id),
  	KEY		(eventid),
  	KEY		(username)
);

CREATE TABLE twig_meetings_invitations (
  	id 		int(11) DEFAULT '0' NOT NULL auto_increment,
  	username 	varchar(128) NOT NULL,
  	eventid 	int(11) DEFAULT '0' NOT NULL,
  	thedate 	timestamp(14),
  	priority	int(11) DEFAULT '0' NOT NULL,
  	PRIMARY KEY 	(id)
);

CREATE TABLE twig_members (
	id		INT AUTO_INCREMENT NOT NULL,
	groupid		INT NOT NULL,
	username	varchar(128) NOT NULL,
	writeperms	INT,
	PRIMARY KEY	(id),
	KEY		(groupid)
);

CREATE TABLE twig_news_prefs (
   	id 		int(11) DEFAULT '0' NOT NULL auto_increment,
   	username	varchar(128) NOT NULL,
   	replyto 	text NOT NULL,
   	pagesize 	int(11) DEFAULT '0' NOT NULL,
   	newwindow 	int(11) DEFAULT '1' NOT NULL,
	linewrap	text NOT NULL,
	realname	text NOT NULL,
	signature	text NOT NULL,
   	inline 		int(11),
   	PRIMARY KEY 	(id),
	KEY		(username)
);

CREATE TABLE twig_notes (
	id		INT AUTO_INCREMENT NOT NULL,
	username	VARCHAR(128) NOT NULL,
	thedate		TIMESTAMP,
	groupid		INT NOT NULL,
	item		TEXT,
	description	TEXT,
	attachname	TEXT,
	attachmime	TEXT,
	attachment	LONGBLOB,
	PRIMARY KEY	(id),
	KEY		(username)
);

CREATE TABLE twig_notes_prefs (
	id		INT(11) DEFAULT '0' NOT NULL AUTO_INCREMENT,
	username	VARCHAR(128) 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),
	pagesize	INT(11),
   	viewgrp		varchar(10) DEFAULT '0' NOT NULL,
	PRIMARY KEY	(id),
	KEY		(username)
);

CREATE TABLE twig_schedule (
 	id		INT AUTO_INCREMENT NOT NULL,
 	username	VARCHAR(128) NOT NULL,
 	thedate		TIMESTAMP,
 	groupid		INT NOT NULL,
 	itemstart	TIMESTAMP,
 	itemstop	TIMESTAMP,
 	item		TEXT,
 	description	TEXT,
	notime		INT,
	recurtype	INT,
	recurid		INT,
	PRIMARY KEY	(id),
	KEY		(username),
	KEY		(thedate),
	KEY		(groupid),
	KEY		(itemstart),
	KEY		(itemstop)
);

CREATE TABLE twig_schedule_recurring (
	id		INT DEFAULT '0' not null AUTO_INCREMENT,
	schid		INT not null,
	recurtype	INT not null,
	schedule	INT,
	cycle		INT,
	position	INT,
	days		VARCHAR (13),
	endtype		INT not null,
	end		TIMESTAMP not null,
	PRIMARY KEY	(id),
	INDEX		(schid),
	INDEX		(recurtype),
	INDEX		(endtype),
	INDEX		(end)
);

CREATE TABLE twig_schedule_prefs (
   	id 		int(11) DEFAULT '0' NOT NULL auto_increment,
   	username 	varchar(128) NOT NULL,
   	dgroup 		int(11) DEFAULT '0' NOT NULL,
   	viewgrp		varchar(10) DEFAULT '0' NOT NULL,
   	PRIMARY KEY 	(id),
	KEY		(username)
);

CREATE TABLE twig_sclhsqltable (
   	LID 		varchar(128) DEFAULT '0' NOT NULL,
   	pwdata 		varchar(128) DEFAULT '0' NOT NULL,
   	username 	varchar(128) NOT NULL,
   	expire 		bigint(21) DEFAULT '0' NOT NULL,
   	PRIMARY KEY 	(LID)
);

CREATE TABLE twig_session (
   	id 		varchar(40) NOT NULL,
   	username 	varchar(128) NOT NULL,
   	sdata 		longtext NOT NULL,
   	sid 		int(11) DEFAULT '0' NOT NULL,
   	KEY 		(id),
   	KEY 		(username),
   	KEY 		(sid)
);

CREATE TABLE twig_todo (
 	id		INT AUTO_INCREMENT NOT NULL,
 	username	VARCHAR(128) NOT NULL,
 	thedate		TIMESTAMP,
 	groupid		INT NOT NULL,
 	item		TEXT,
 	description	TEXT,
 	priority	INT,
 	completed	INT,
	duedate		TIMESTAMP,
	duetype		INT,
	PRIMARY KEY	(id),
	KEY		(username)
);

CREATE TABLE twig_todo_lists_entries (
	listid		int(11) DEFAULT '0' NOT NULL,
	type		int(11) DEFAULT '0' NOT NULL,
	item		int(11) DEFAULT '0' NOT NULL,
	subitem		int(11),
	KEY		(listid),
	KEY		(item)
);

CREATE TABLE twig_todo_prefs (
   	id 		int(11) DEFAULT '0' NOT NULL auto_increment,
   	username 	varchar(128) NOT NULL,
   	sortby 		varchar(10) NOT NULL,
   	sortorder 	int(1) DEFAULT '0' NOT NULL,
   	dgroup 		int(11) DEFAULT '0' NOT NULL,
   	priority 	int(11) DEFAULT '0' NOT NULL,
   	pagesize 	int(11) DEFAULT '0' NOT NULL,
   	viewgrp		varchar(10) DEFAULT '0' NOT NULL,
   	duetype		int(11) DEFAULT '0' NOT NULL,
   	PRIMARY KEY 	(id),
	KEY		(username)
);