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