SET SQL DIALECT 3; 
 
/* CREATE DATABASE 'twig.gdb' PAGE_SIZE 4096 
 */

/* Domain definitions */
CREATE DOMAIN "TEXT" AS VARCHAR(32000);

/* Table: TWIG_ACCOUNTS, Owner: SYSDBA */
CREATE TABLE "TWIG_ACCOUNTS" ("ID" INTEGER default '0' NOT NULL,
        "USERNAME" VARCHAR(128) NOT NULL,
        "PASSWORD" VARCHAR(128),
        "SID" INTEGER,
        "ONNOW" INTEGER,
        "EXPIRE" INTEGER,
        "LASTON" INTEGER,
PRIMARY KEY ("ID"));

/* Table: TWIG_ACLS, Owner: SYSDBA */
CREATE TABLE "TWIG_ACLS" ("SID" INTEGER default '0' NOT NULL,
        "IDENT" VARCHAR(128) NOT NULL,
        "ALEVEL" INTEGER default '0' NOT NULL);

/* Table: TWIG_ACL_GROUPS, Owner: SYSDBA */
CREATE TABLE "TWIG_ACL_GROUPS" ("SID" INTEGER default '0' NOT NULL,
        "GROUPNAME" VARCHAR(64) NOT NULL,
        "USERNAME" VARCHAR(128) NOT NULL);

/* Table: TWIG_ANNOUNCE, Owner: SYSDBA */
CREATE TABLE "TWIG_ANNOUNCE" ("ID" INTEGER default '0' NOT NULL,
        "THEDATE" TIMESTAMP,
        "USERNAME" VARCHAR(128) NOT NULL,
	"EMAIL" VARCHAR(128),
	"SUBJECT" VARCHAR(128) NOT NULL,
	"ANNOUNCE" "TEXT" NOT NULL,
PRIMARY KEY ("ID"));

/* Table: TWIG_BOOKMARKS, Owner: SYSDBA */
CREATE TABLE "TWIG_BOOKMARKS" ("ID" INTEGER NOT NULL,
        "USERNAME" VARCHAR(128) NOT NULL,
        "THEDATE" TIMESTAMP,
        "GROUPID" INTEGER NOT NULL,
        "ITEM" VARCHAR(100),
        "DESCRIPTION" VARCHAR(100),
        "URL" VARCHAR(100),
PRIMARY KEY ("ID"));

/* Table: TWIG_BOOKMARKS_PREFS, Owner: SYSDBA */
CREATE TABLE "TWIG_BOOKMARKS_PREFS" ("ID" INTEGER default '0' NOT NULL,
        "USERNAME" VARCHAR(128) NOT NULL,
        "SORTBY" VARCHAR(10),
        "SORTORDER" INTEGER default '0' NOT NULL,
        "DGROUP" INTEGER default '0' NOT NULL,
        "PAGESIZE" INTEGER default '0' NOT NULL,
        "VIEWGRP" VARCHAR(10) default '0' NOT NULL,
PRIMARY KEY ("ID"));

/* Table: TWIG_CONTACTS, Owner: SYSDBA */
CREATE TABLE "TWIG_CONTACTS" ("ID" INTEGER NOT NULL,
        "USERNAME" VARCHAR(128) NOT NULL,
        "THEDATE" TIMESTAMP,
        "GROUPID" INTEGER NOT NULL,
        "ITEM" VARCHAR(100),
        "DESCRIPTION" VARCHAR(100),
        "URL" VARCHAR(100),
        "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" INTEGER,
	"USERPERS" INTEGER,
PRIMARY KEY ("ID"));

CREATE TABLE TWIG_CONTACTS_LISTS_ENTRIES (
	"LISTID" INTEGER DEFAULT '0' NOT NULL,
	"TYPE" INTEGER DEFAULT '0' NOT NULL,
	"ITEM" INTEGER DEFAULT '0' NOT NULL,
	"SUBITEM" INTEGER
);

/* Table: TWIG_CONTACTS_PREFS, Owner: SYSDBA */
CREATE TABLE "TWIG_CONTACTS_PREFS" ("ID" INTEGER NOT NULL,
        "USERNAME" VARCHAR(128) NOT NULL,
        "SORTBY" VARCHAR(10),
        "SORTORDER" INTEGER,
        "DGROUP" INTEGER,
        "PAGESIZE" INTEGER,
        "VIEWGRP" VARCHAR(10) default '0' NOT NULL,
PRIMARY KEY ("ID"));

/* Table: TWIG_CONTEXT, Owner: SYSDBA */
CREATE TABLE "TWIG_CONTEXT" ("ID" VARCHAR(40) NOT NULL,
        "USERNAME" VARCHAR(128) NOT NULL,
        "CONTEXT" VARCHAR(1000) NOT NULL,
        "SID" INTEGER NOT NULL);

/* Table: TWIG_FOLDERS, Owner: SYSDBA */
CREATE TABLE "TWIG_FOLDERS" ("ID" INTEGER NOT NULL,
        "OWNER" VARCHAR(128) NOT NULL,
        "SERVER" VARCHAR(255) NOT NULL,
        "PORT" INTEGER NOT NULL,
        "GROUPNAME" VARCHAR(255) NOT NULL,
        "USERNAME" VARCHAR(128),
        "PASSWORD" VARCHAR(128),
        "SERVERTYPE" VARCHAR(10),
PRIMARY KEY ("ID"));

/* Table: TWIG_GLOBAL_PREFS, Owner: SYSDBA */
CREATE TABLE "TWIG_GLOBAL_PREFS" ("ID" INTEGER NOT NULL,
        "USERNAME" VARCHAR(128) NOT NULL,
        "MSTYLE1" INTEGER,
        "MSTYLE2" INTEGER,
        "TSTYLE1" INTEGER,
        "LANGUAGE" VARCHAR(20),
        "MAILFOOT" INTEGER,
        "PREVNEXT" VARCHAR(20),
        "TIMEFORMAT" INTEGER,
        "STYLESHEET" VARCHAR(32),
PRIMARY KEY ("ID"));

/* Table: TWIG_GROUPS, Owner: SYSDBA */
CREATE TABLE "TWIG_GROUPS" ("ID" INTEGER NOT NULL,
        "OWNER" VARCHAR(128) NOT NULL,
        "GROUPNAME" VARCHAR(100),
        "TYPE" VARCHAR(20),
PRIMARY KEY ("ID"));

/* Table: TWIG_LHSQLTABLE, Owner: SYSDBA */
CREATE TABLE "TWIG_LHSQLTABLE" ("LID" VARCHAR(128) NOT NULL,
        "USERNAME" VARCHAR(128) NOT NULL,
        "PASSWORD" VARCHAR(128) NOT NULL,
        "EXPIRE" INTEGER default '0' NOT NULL,
PRIMARY KEY ("LID"));

/* Table: TWIG_MAIL_PREFS, Owner: SYSDBA */
CREATE TABLE "TWIG_MAIL_PREFS" ("ID" INTEGER default '0' NOT NULL,
        "USERNAME" VARCHAR(128) NOT NULL,
        "REALNAME" VARCHAR(1000),
        "SIGNATURE" VARCHAR(1000),
        "LINEWRAP" VARCHAR(1000),
        "REPLYTO" VARCHAR(1000),
        "PAGESIZE" INTEGER,
        "SORTBY" VARCHAR(10),
        "SORTORDER" INTEGER,
        "DANDE" INTEGER,
        "SAVESENT" INTEGER,
        "SENTFOLD" VARCHAR(1000),
        "DRAFTFOLD" VARCHAR(1000),
        "CMDLINE2" INTEGER,
        "NEWWINDOW" INTEGER,
        "NEWCONTACT" INTEGER,
	"NUMUP" INTEGER,
	"MAILTREE" INTEGER,
	"MTEXPAND" INTEGER,
	"MTVIEW" VARCHAR(255),
	"MDN" INTEGER,
	"MDN_MODE" INTEGER,
	"AREPLY" INTEGER,
	"AFORWARD" INTEGER,
	"CLINES" INTEGER,
	"MANDE" INTEGER,
	"DRETURN" INTEGER,
	"FROMADDRESS" VARCHAR(128),
	"CGROUP" VARCHAR(10),
PRIMARY KEY ("ID"));

/* Table: TWIG_MAIN_PREFS, Owner: SYSDBA */
CREATE TABLE "TWIG_MAIN_PREFS" ("ID" INTEGER default '0' NOT NULL,
        "USERNAME" VARCHAR(128) NOT NULL,
   	"FEATURES" VARCHAR(128),
	"MAXMAIL" INTEGER,
	"MAXMEETINGS" INTEGER,
	"MAXSCEHDULE" INTEGER,
	"MAXTODO" INTEGER,
PRIMARY KEY ("ID"));

/* Table: TWIG_MEETINGS, Owner: SYSDBA */
CREATE TABLE "TWIG_MEETINGS" ("ID" INTEGER DEFAULT '0' NOT NULL,
        "GROUPID" INTEGER DEFAULT '0' NOT NULL,
        "USERNAME" VARCHAR(128),
        "SECRETARY" VARCHAR(128),
        "RESPONSIBLE" VARCHAR(128),
        "THEDATE" TIMESTAMP,
        "ITEMSTART" TIMESTAMP,
        "ITEMSTOP" TIMESTAMP,
        "ITEMDONE" TIMESTAMP,
        "ITEM" VARCHAR(100),
        "DESCRIPTION" VARCHAR(300),
        "MINUTES" VARCHAR(100),
        "CONCLUSION" VARCHAR(300),
        "ACTIONITEMS" VARCHAR(300),
        "LOCATION" INTEGER DEFAULT '0' NOT NULL,
        "USERLIMIT" INTEGER DEFAULT '0' NOT NULL,
        "CLOSED" INTEGER default '0' NOT NULL,
        "DELETED" INTEGER default '0' NOT NULL,
        "PRIVATE" INTEGER DEFAULT '0' NOT NULL,
PRIMARY KEY ("ID"));

/* Table: TWIG_MEETINGS_PREFS, Owner: SYSDBA */
CREATE TABLE "TWIG_MEETINGS_PREFS" ("ID" INTEGER DEFAULT '0' NOT NULL,
        "USERNAME" VARCHAR(128),
        "DGROUP" INTEGER DEFAULT '0' NOT NULL,
        "MAINVIEW" INTEGER DEFAULT '0' NOT NULL,
        "PAGESIZE" INTEGER DEFAULT '0' NOT NULL,
        "VIEWGRP" VARCHAR(10) default '0' NOT NULL,
PRIMARY KEY ("ID"));

/* Table: TWIG_MEETINGS_REGISTRATION, Owner: SYSDBA */
CREATE TABLE "TWIG_MEETINGS_REGISTRATION" ("ID" INTEGER DEFAULT '0' NOT NULL,
        "USERNAME" VARCHAR(128),
        "EVENTID" INTEGER DEFAULT '0' NOT NULL,
        "THEDATE" TIMESTAMP,
        "RSVP" VARCHAR(10) DEFAULT 'Unknown' NOT NULL,
PRIMARY KEY ("ID"));

/* Table: TWIG_MEETINGS_INVITATIONS, Owner: SYSDBA */
CREATE TABLE "TWIG_MEETINGS_REGISTRATION" ("ID" INTEGER DEFAULT '0' NOT NULL,
        "USERNAME" VARCHAR(128),
        "EVENTID" INTEGER DEFAULT '0' NOT NULL,
        "THEDATE" TIMESTAMP,
        "PRIORITY" VARCHAR(10) DEFAULT 'Unknown' NOT NULL,
PRIMARY KEY ("ID"));

/* Table: TWIG_MEMBERS, Owner: SYSDBA */
CREATE TABLE "TWIG_MEMBERS" ("ID" INTEGER default '0' NOT NULL,
        "GROUPID" INTEGER NOT NULL,
        "USERNAME" VARCHAR(128) NOT NULL,
        "WRITEPERMS" INTEGER,
PRIMARY KEY ("ID"));

/* Table: TWIG_NEWS_PREFS, Owner: SYSDBA */
CREATE TABLE "TWIG_NEWS_PREFS" ("ID" INTEGER default '0' NOT NULL,
        "USERNAME" VARCHAR(128) NOT NULL,
        "REPLYTO" VARCHAR(1000),
        "PAGESIZE" INTEGER default '0' NOT NULL,
        "NEWWINDOW" INTEGER default '1' NOT NULL,
        "LINEWRAP" VARCHAR(1000),
        "REALNAME" VARCHAR(1000),
        "SIGNATURE" VARCHAR(1000),
	"INLINE" INTEGER,
PRIMARY KEY ("ID"));

/* Table: TWIG_NOTES, Owner: SYSDBA */
CREATE TABLE "TWIG_NOTES" ("ID" INTEGER default '0' NOT NULL,
        "USERNAME" VARCHAR(128) NOT NULL,
        "THEDATE" TIMESTAMP,
        "GROUPID" INTEGER DEFAULT '0' NOT NULL,
        "ITEM" VARCHAR(100),
        "DESCRIPTION" "TEXT",
        "ATTACHNAME" VARCHAR(100),
	"ATTACHMIME" "TEXT",
	"ATTACHMENT" BLOB SUB_TYPE 0 SEGMENT SIZE 80,
PRIMARY KEY ("ID"));

/* Table: TWIG_NOTES_PREFS, Owner: SYSDBA */
CREATE TABLE "TWIG_NOTES_PREFS" ("ID" INTEGER default '0' NOT NULL,
        "USERNAME" VARCHAR(128) NOT NULL,
        "SORTBY" VARCHAR(10),
        "SORTORDER" INTEGER DEFAULT '0' NOT NULL,
        "DGROUP" INTEGER DEFAULT '0' NOT NULL,
        "WIDTH" INTEGER,
        "HEIGHT" INTEGER,
        "PAGESIZE" INTEGER,
        "VIEWGRP" VARCHAR(10) default '0' NOT NULL,
PRIMARY KEY ("ID"));

/* Table: TWIG_SCHEDULE, Owner: SYSDBA */
CREATE TABLE "TWIG_SCHEDULE" ("ID" INTEGER default '0' NOT NULL,
        "USERNAME" VARCHAR(128) NOT NULL,
        "THEDATE" TIMESTAMP,
        "GROUPID" INTEGER NOT NULL,
        "ITEMSTART" TIMESTAMP,
        "ITEMSTOP" TIMESTAMP,
        "ITEM" VARCHAR(1000),
        "DESCRIPTION" VARCHAR(1000),
	"NOTIME" INTEGER,
	"RECURTYPE" INTEGER,
	"RECURID" INTEGER,
	"REMIND_TIME" TIMESTAMP,
	"REMIND_QTY" INTEGER,
	"REMIND_UNITS" VARCHAR(10),
	"REMIND_ADDRESS" VARCHAR(100),

PRIMARY KEY ("ID"));

CREATE TABLE "TWIG_SCHEDULE_RECURRING" ("ID" INTEGER default '0' NOT NULL,
	"SCHID"		INTEGER,
	"RECURTYPE"	INTEGER NOT NULL,
	"SCHEDULE"	INTEGER,
	"CYCLE"		INTEGER,
	"POSITION"	INTEGER,
	"DAYS"		VARCHAR (13),
	"ENDTYPE"	INTEGER NOT NULL,
	"END"		TIMESTAMP NOT NULL,
	PRIMARY KEY	("ID")
	);

/* Table: TWIG_SCHEDULE_PREFS, Owner: SYSDBA */
CREATE TABLE "TWIG_SCHEDULE_PREFS" ("ID" INTEGER default '0' NOT NULL,
        "USERNAME" VARCHAR(128) NOT NULL,
        "DGROUP" INTEGER default '0' NOT NULL,
        "VIEWGRP" VARCHAR(10) default '0' NOT NULL,
PRIMARY KEY ("ID"));

/* Table: TWIG_SESSION, Owner: SYSDBA */
CREATE TABLE "TWIG_SESSION" ("ID" VARCHAR(40) NOT NULL,
        "USERNAME" VARCHAR(128) NOT NULL,
        "SDATA" "TEXT" NOT NULL,
        "SID" INTEGER default '0' NOT NULL);

/* Table: TWIG_TODO, Owner: SYSDBA */
CREATE TABLE "TWIG_TODO" ("ID" INTEGER NOT NULL,
        "USERNAME" VARCHAR(128) NOT NULL,
        "THEDATE" TIMESTAMP,
        "GROUPID" INTEGER NOT NULL,
        "ITEM" VARCHAR(1000),
        "DESCRIPTION" VARCHAR(1000),
        "PRIORITY" INTEGER,
        "COMPLETED" INTEGER,
	"DUEDATE" TIMESTAMP,
	"DUETYPE" INTEGER,
PRIMARY KEY ("ID"));

CREATE TABLE TWIG_TODO_LISTS_ENTRIES (
	"LISTID" INTEGER DEFAULT '0' NOT NULL,
	"TYPE" INTEGER DEFAULT '0' NOT NULL,
	"ITEM" INTEGER DEFAULT '0' NOT NULL,
	"SUBITEM" INTEGER
);

/* Table: TWIG_TODO_PREFS, Owner: SYSDBA */
CREATE TABLE "TWIG_TODO_PREFS" ("ID" INTEGER default '0' NOT NULL,
        "USERNAME" VARCHAR(128) NOT NULL,
        "SORTBY" VARCHAR(10),
        "SORTORDER" INTEGER default '0' NOT NULL,
        "DGROUP" INTEGER default '0' NOT NULL,
        "PRIORITY" INTEGER,
        "PAGESIZE" INTEGER,
        "VIEWGRP" VARCHAR(10) default '0' NOT NULL,
        "DUETYPE" INTEGER default '0' NOT NULL,
PRIMARY KEY ("ID"));

/*  Index definitions for all user tables */
CREATE INDEX "TWIG_ACCOUNTS_ID_INDEX" ON "TWIG_ACCOUNTS"("ID", "USERNAME");
CREATE INDEX "TWIG_ACLS_IDENT_INDEX" ON "TWIG_ACLS"("IDENT");
CREATE INDEX "TWIG_ACLS_SID_INDEX" ON "TWIG_ACLS"("SID");
CREATE INDEX "TWIG_ACL_GROUPS_GROUPNAME_INDEX" ON "TWIG_ACL_GROUPS"("GROUPNAME");
CREATE INDEX "TWIG_ACL_GROUPS_USERNAME_INDEX" ON "TWIG_ACL_GROUPS"("USERNAME");
CREATE INDEX "TWIG_ACL_BM_GROUPID_INDEX" ON "TWIG_BOOKMARKS"("ID");
CREATE INDEX "TWIG_ACL_BM_USERNAME_INDEX" ON "TWIG_BOOKMARKS"("USERNAME");
CREATE INDEX "TWIG_BM_PREFS_USERNAME_INDEX" ON "TWIG_BOOKMARKS_PREFS"("USERNAME");
CREATE INDEX "TWIG_CONTACTS_GROUPID_INDEX" ON "TWIG_CONTACTS"("GROUPID");
CREATE INDEX "TWIG_CONTACTS_USERNAME_INDEX" ON "TWIG_CONTACTS"("USERNAME");
CREATE INDEX "TWIG_CONTACTS_LISTS_ENTRIES_LISTID_INDEX" ON "TWIG_CONTACTS_LISTS_ENTRIES"("LISTID");
CREATE INDEX "TWIG_CONTACTS_LISTS_ENTRIES_ITEM_INDEX" ON "TWIG_CONTACTS_LISTS_ENTRIES"("ITEM");
CREATE INDEX "TWIG_CONTACTS_PREFS_UN_INDEX" ON "TWIG_CONTACTS_PREFS"("USERNAME");
CREATE INDEX "TWIG_CONTEXT_ID_INDEX" ON "TWIG_CONTEXT"("ID");
CREATE INDEX "TWIG_CONTEXT_SID_INDEX" ON "TWIG_CONTEXT"("SID");
CREATE INDEX "TWIG_CONTEXT_USERNAME_INDEX" ON "TWIG_CONTEXT"("USERNAME");
CREATE INDEX "TWIG_FOLDERS_OWNER_INDEX" ON "TWIG_FOLDERS"("USERNAME");
CREATE INDEX "TWIG_GLOBAL_PREFS_UN_INDEX" ON "TWIG_GLOBAL_PREFS"("USERNAME");
CREATE INDEX "TWIG_GROUPS_OWNER_INDEX" ON "TWIG_GROUPS"("OWNER");
CREATE INDEX "TWIG_MAIL_PREFS_UN_INDEX" ON "TWIG_MAIL_PREFS"("USERNAME");
CREATE INDEX "TWIG_MAIN_PREFS_UN_INDEX" ON "TWIG_MAIN_PREFS"("USERNAME");
CREATE INDEX "TWIG_NEWS_PREFS_UN_INDEX" ON "TWIG_NEWS_PREFS"("USERNAME");
CREATE INDEX "TWIG_NOTES_USERNAME_INDEX" ON "TWIG_NOTES"("USERNAME");
CREATE INDEX "TWIG_NOTES_PREFS_USERNAME_INDEX" ON "TWIG_NOTES_PREFS"("USERNAME");
CREATE INDEX "TWIG_SCHEDULE_FINISH_INDEX" ON "TWIG_SCHEDULE"("ITEMSTOP");
CREATE INDEX "TWIG_SCHEDULE_GROUPID_INDEX" ON "TWIG_SCHEDULE"("GROUPID");
CREATE INDEX "TWIG_SCHEDULE_START_INDEX" ON "TWIG_SCHEDULE"("ITEMSTART");
CREATE INDEX "TWIG_SCHEDULE_THEDATE_INDEX" ON "TWIG_SCHEDULE"("THEDATE");
CREATE INDEX "TWIG_SCHEDULE_UN_INDEX" ON "TWIG_SCHEDULE"("USERNAME");
CREATE INDEX "TWIG_SCHEDULE_PS_UN_INDEX" ON "TWIG_SCHEDULE_PREFS"("USERNAME");
CREATE INDEX "TWIG_SESSION_ID_INDEX" ON "TWIG_SESSION"("ID");
CREATE INDEX "TWIG_SESSION_SID_INDEX" ON "TWIG_SESSION"("SID");
CREATE INDEX "TWIG_SESSION_USERNAME_INDEX" ON "TWIG_SESSION"("USERNAME");
CREATE INDEX "TWIG_TODO_USERNAME_INDEX" ON "TWIG_TODO"("USERNAME");
CREATE INDEX "TWIG_TODO_PREFS_USERNAME_INDEX" ON "TWIG_TODO_PREFS"("USERNAME");
CREATE INDEX "TWIG_SCHEDULE_RC_SCHID_INDEX" ON "TWIG_SCHEDULE_RECURRING"("SCHID");
CREATE INDEX "TWIG_SCHEDULE_RC_RECURTYPE_INDEX" ON "TWIG_SCHEDULE_RECURRING"("RECURTYPE");
CREATE INDEX "TWIG_SCHEDULE_RC_ENDTYPE_INDEX" ON "TWIG_SCHEDULE_RECURRING"("ENDTYPE");
CREATE INDEX "TWIG_SCHEDULE_RC_END_INDEX" ON "TWIG_SCHEDULE_RECURRING"("END");

CREATE GENERATOR "TWIG_ACCOUNTS_SEQ";
CREATE GENERATOR "TWIG_BOOKMARKS_PREFS_SEQ";
CREATE GENERATOR "TWIG_BOOKMARKS_SEQ";
CREATE GENERATOR "TWIG_CONTACTS_PREFS_SEQ";
CREATE GENERATOR "TWIG_CONTACTS_SEQ";
CREATE GENERATOR "TWIG_FOLDERS_SEQ";
CREATE GENERATOR "TWIG_GLOBAL_PREFS_SEQ";
CREATE GENERATOR "TWIG_GROUPS_SEQ";
CREATE GENERATOR "TWIG_MAIL_PREFS_SEQ";
CREATE GENERATOR "TWIG_MAIN_PREFS_SEQ";
CREATE GENERATOR "TWIG_MEETINGS_PREFS_SEQ";
CREATE GENERATOR "TWIG_MEETINGS_REG_SEQ";
CREATE GENERATOR "TWIG_MEETINGS_INV_SEQ";
CREATE GENERATOR "TWIG_MEETINGS_SEQ";
CREATE GENERATOR "TWIG_MEMBERS_SEQ";
CREATE GENERATOR "TWIG_NEWS_PREFS_SEQ";
CREATE GENERATOR "TWIG_NOTES_PREFS_SEQ";
CREATE GENERATOR "TWIG_NOTES_SEQ";
CREATE GENERATOR "TWIG_SCHEDULE_PREFS_SEQ";
CREATE GENERATOR "TWIG_SCHEDULE_RECURRING_SEQ";
CREATE GENERATOR "TWIG_SCHEDULE_SEQ";
CREATE GENERATOR "TWIG_TODO_PREFS_SEQ";
CREATE GENERATOR "TWIG_TODO_SEQ";

SET TERM ^ ;

/* Triggers only will work for SQL triggers */
CREATE TRIGGER "TWIG_ACCOUNTS_AUTOINC" FOR "TWIG_ACCOUNTS" 
ACTIVE BEFORE INSERT POSITION 0 
as
begin
  new.id = gen_id(twig_accounts_seq,1);
end ^
 
CREATE TRIGGER "TWIG_BOOKMARKS_AUTOINC" FOR "TWIG_BOOKMARKS" 
ACTIVE BEFORE INSERT POSITION 0 
as
begin
  new.id = gen_id(twig_bookmarks_seq,1);
end ^
 
CREATE TRIGGER "TWIG_BOOKMARKS_PREFS_AUTOINC" FOR "TWIG_BOOKMARKS_PREFS" 
ACTIVE BEFORE INSERT POSITION 0 
as
begin
  new.id = gen_id(twig_bookmarks_prefs_seq,1);
end ^
 
CREATE TRIGGER "TWIG_CONTACTS_AUTOINC" FOR "TWIG_CONTACTS" 
ACTIVE BEFORE INSERT POSITION 0 
as
begin
  new.id = gen_id(twig_contacts_seq,1);
end ^
 
CREATE TRIGGER "TWIG_CONTACTS_PREFS_AUTOINC" FOR "TWIG_CONTACTS_PREFS" 
ACTIVE BEFORE INSERT POSITION 0 
as
begin
  new.id = gen_id(twig_contacts_prefs_seq,1);
end ^
 
CREATE TRIGGER "TWIG_FOLDERS_AUTOINC" FOR "TWIG_FOLDERS" 
ACTIVE BEFORE INSERT POSITION 0 
as
begin
  new.id = gen_id(twig_folders_seq,1);
end ^
 
CREATE TRIGGER "TWIG_GLOBAL_PREFS_AUTOINC" FOR "TWIG_GLOBAL_PREFS" 
ACTIVE BEFORE INSERT POSITION 0 
as
begin
  new.id = gen_id(twig_global_prefs_seq,1);
end ^
 
CREATE TRIGGER "TWIG_GROUPS_AUTOINC" FOR "TWIG_GROUPS" 
ACTIVE BEFORE INSERT POSITION 0 
as
begin
  new.id = gen_id(twig_groups_seq,1);
end ^
 
CREATE TRIGGER "TWIG_MAIL_PREFS_AUTOINC" FOR "TWIG_MAIL_PREFS" 
ACTIVE BEFORE INSERT POSITION 0 
as
begin
  new.id = gen_id(twig_mail_prefs_seq,1);
end ^
 
CREATE TRIGGER "TWIG_MAIN_PREFS_AUTOINC" FOR "TWIG_MAIN_PREFS" 
ACTIVE BEFORE INSERT POSITION 0 
as
begin
  new.id = gen_id(twig_main_prefs_seq,1);
end ^
 
CREATE TRIGGER "TWIG_MEETINGS_AUTOINC" FOR "TWIG_MEETINGS" 
ACTIVE BEFORE INSERT POSITION 0 
as
begin
  new.id = gen_id(twig_meetings_seq,1);
end ^
 
CREATE TRIGGER "TWIG_MEETINGS_PREFS_AUTOINC" FOR "TWIG_MEETINGS_PREFS" 
ACTIVE BEFORE INSERT POSITION 0 
as
begin
  new.id = gen_id(twig_meetings_prefs_seq,1);
end ^
 
CREATE TRIGGER "TWIG_MEETINGS_REG_AUTOINC" FOR "TWIG_MEETINGS_REGISTRATION" 
ACTIVE BEFORE INSERT POSITION 0 
as
begin
  new.id = gen_id(twig_meetings_reg_seq,1);
end ^
 
CREATE TRIGGER "TWIG_MEETINGS_INV_AUTOINC" FOR "TWIG_MEETINGS_INVITATIONS" 
ACTIVE BEFORE INSERT POSITION 0 
as
begin
  new.id = gen_id(twig_meetings_inv_seq,1);
end ^
 
CREATE TRIGGER "TWIG_MEMBERS_AUTOINC" FOR "TWIG_MEMBERS" 
ACTIVE BEFORE INSERT POSITION 0 
as
begin
  new.id = gen_id(twig_members_seq,1);
end ^
 
CREATE TRIGGER "TWIG_NEWS_PREFS_AUTOINC" FOR "TWIG_NEWS_PREFS" 
ACTIVE BEFORE INSERT POSITION 0 
as
begin
  new.id = gen_id(twig_news_prefs_seq,1);
end ^
 
CREATE TRIGGER "TWIG_NOTES_AUTOINC" FOR "TWIG_NOTES" 
ACTIVE BEFORE INSERT POSITION 0 
as
begin
  new.id = gen_id(twig_notes_seq,1);
end ^
 
CREATE TRIGGER "TWIG_NOTES_PREFS_AUTOINC" FOR "TWIG_NOTES_PREFS" 
ACTIVE BEFORE INSERT POSITION 0 
as
begin
  new.id = gen_id(twig_notes_prefs_seq,1);
end ^
 
CREATE TRIGGER "TWIG_SCHEDULE_AUTOINC" FOR "TWIG_SCHEDULE" 
ACTIVE BEFORE INSERT POSITION 0 
as
begin
  new.id = gen_id(twig_schedule_seq,1);
end ^
 
CREATE TRIGGER "TWIG_SCHEDULE_RECURRING_AUTOINC" FOR "TWIG_SCHEDULE_RECURRING" 
ACTIVE BEFORE INSERT POSITION 0 
as
begin
  new.id = gen_id(twig_schedule_recurring_seq,1);
end ^
 
CREATE TRIGGER "TWIG_SCHEDULE_PREFS_AUTOINC" FOR "TWIG_SCHEDULE_PREFS" 
ACTIVE BEFORE INSERT POSITION 0 
as
begin
  new.id = gen_id(twig_schedule_prefs_seq,1);
end ^
 
/* Table: TWIG_SCLHSQLTABLE, Owner: SYSDBA */
CREATE TABLE "TWIG_SCLHSQLTABLE" ("LID" VARCHAR(128) NOT NULL,
        "PWDATA" VARCHAR(128) NOT NULL,
        "USERNAME" VARCHAR(128) NOT NULL,
        "EXPIRE" INTEGER default '0' NOT NULL,
PRIMARY KEY ("LID"));

CREATE TRIGGER "TWIG_TODO_AUTOINC" FOR "TWIG_TODO" 
ACTIVE BEFORE INSERT POSITION 0 
as
begin
  new.id = gen_id(twig_todo_seq,1);
end ^
 
CREATE TRIGGER "TWIG_TODO_PREFS_AUTOINC" FOR "TWIG_TODO_PREFS" 
ACTIVE BEFORE INSERT POSITION 0 
as
begin
  new.id = gen_id(twig_todo_prefs_seq,1);
end ^
 
COMMIT WORK ^
SET TERM ; ^

/* Grant permissions for this database */
GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON "TWIG_ACCOUNTS" TO NOBODY;
GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON "TWIG_ACLS" TO NOBODY;
GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON "TWIG_ACL_GROUPS" TO NOBODY;
GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON "TWIG_BOOKMARKS" TO NOBODY;
GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON "TWIG_BOOKMARKS_PREFS" TO NOBODY;
GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON "TWIG_CONTACTS" TO NOBODY;
GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON "TWIG_CONTACTS_LISTS_ENTRIES" TO NOBODY;
GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON "TWIG_CONTACTS_PREFS" TO NOBODY;
GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON "TWIG_CONTEXT" TO NOBODY;
GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON "TWIG_FOLDERS" TO NOBODY;
GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON "TWIG_GLOBAL_PREFS" TO NOBODY;
GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON "TWIG_GROUPS" TO NOBODY;
GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON "TWIG_LHSQLTABLE" TO NOBODY;
GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON "TWIG_MAIL_PREFS" TO NOBODY;
GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON "TWIG_MAIN_PREFS" TO NOBODY;
GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON "TWIG_MEETINGS" TO NOBODY;
GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON "TWIG_MEETINGS_PREFS" TO NOBODY;
GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON "TWIG_MEETINGS_REGISTRATION" TO NOBODY;
GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON "TWIG_MEMBERS" TO NOBODY;
GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON "TWIG_NEWS_PREFS" TO NOBODY;
GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON "TWIG_NOTES" TO NOBODY;
GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON "TWIG_NOTES_PREFS" TO NOBODY;
GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON "TWIG_SCHEDULE" TO NOBODY;
GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON "TWIG_SCHEDULE_PREFS" TO NOBODY;
GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON "TWIG_SCHEDULE_RECURRING" TO NOBODY;
GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON "TWIG_SESSION" TO NOBODY;
GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON "TWIG_TODO" TO NOBODY;
GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON "TWIG_TODO_PREFS" TO NOBODY;
GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON "TWIG_SCLHSQLTABLE" TO NOBODY;