/* ---------------------------------------------------------------------------------
	$Id: twig.table.oracle,v 1.46 2004/01/29 16:36:36 brian Exp $

	filename:	twig.table.oracle
	author:		christoph klein (christoph.klein@ucpag.com)
	comment:	create all twig tables on oracle 8.0.5 EE
   --------------------------------------------------------------------------------- */

CREATE TABLE TWIG_ACCOUNTS (
   	ID 		NUMBER (16),
   	USERNAME 	VARCHAR2 (128) NOT NULL,
   	PASSWORD 	VARCHAR2 (128),
	SID		NUMBER,
   	ONNOW		NUMBER,
   	EXPIRE		NUMBER,
   	LASTON		NUMBER,
   	PRIMARY KEY (ID)
);

CREATE SEQUENCE TWIG.SEQ_TWIG_ACCOUNTS INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER;

CREATE TRIGGER TWIG.AI_TWIG_ACCOUNTS BEFORE INSERT ON TWIG.TWIG_ACCOUNTS FOR EACH ROW 
DECLARE
    N_NEXTVAL NUMBER;
BEGIN
  SELECT SEQ_TWIG_ACCOUNTS.NEXTVAL INTO N_NEXTVAL FROM DUAL;
  :NEW.ID := N_NEXTVAL;
END;
/

COMMIT;

/* --------------------------------------------------------------------------------- */

CREATE TABLE TWIG_ACLS (
   	SID 		NUMBER (16) DEFAULT (0) NOT NULL,
   	IDENT	 	VARCHAR2 (128) NOT NULL,
   	ALEVEL 		NUMBER (16) DEFAULT (0) NOT NULL,
   	PRIMARY KEY (SID)
);

COMMIT;

/* --------------------------------------------------------------------------------- */

CREATE TABLE TWIG_ACL_GROUPS (
   	SID 		NUMBER DEFAULT (0) NOT NULL,
   	GROUPNAME 	VARCHAR2 (64) NOT NULL,
   	USERNAME 	VARCHAR2 (128) NOT NULL,
   	PRIMARY KEY (GROUPNAME)
);

COMMIT;

/* --------------------------------------------------------------------------------- */

CREATE TABLE TWIG_ANNOUNCE (
   	ID 		NUMBER (16),
   	THEDATE 	VARCHAR(16),
   	USERNAME 	VARCHAR2(128) NOT NULL,
	EMAIL		VARCHAR2(128),
   	SUBJECT 	VARCHAR2(128) NOT NULL,
   	ANNOUNCE 	VARCHAR2(1000) NOT NULL,
   	PRIMARY KEY (ID)
);

CREATE SEQUENCE TWIG.SEQ_TWIG_ANNOUNCE INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER;

CREATE TRIGGER TWIG.AI_TWIG_ANNOUNCE BEFORE INSERT ON TWIG.TWIG_ANNOUNCE FOR EACH ROW 
DECLARE
    N_NEXTVAL NUMBER;
BEGIN
  SELECT SEQ_TWIG_ANNOUNCE.NEXTVAL INTO N_NEXTVAL FROM DUAL;
  :NEW.ID := N_NEXTVAL;
END;
/

COMMIT;

/* --------------------------------------------------------------------------------- */

CREATE TABLE TWIG_BOOKMARKS (
 	ID		NUMBER (16),
 	USERNAME	VARCHAR2 (128),
 	THEDATE		VARCHAR(16),
 	GROUPID		NUMBER (16) NOT NULL,
 	ITEM		VARCHAR2 (100),
 	DESCRIPTION	VARCHAR2 (100),
 	URL		VARCHAR2 (100),
 	PRIMARY KEY (ID)
);

CREATE SEQUENCE TWIG.SEQ_TWIG_BOOKMARKS INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER;

CREATE TRIGGER TWIG.AI_TWIG_BOOKMARKS BEFORE INSERT ON TWIG.TWIG_BOOKMARKS FOR EACH ROW 
DECLARE
    N_NEXTVAL NUMBER;
BEGIN
  SELECT SEQ_TWIG_BOOKMARKS.NEXTVAL INTO N_NEXTVAL FROM DUAL;
  :NEW.ID := N_NEXTVAL;
END;
/

COMMIT;

/* --------------------------------------------------------------------------------- */

CREATE TABLE TWIG_BOOKMARKS_PREFS (
   	ID 		NUMBER (16),
   	USERNAME 	VARCHAR2 (128),
   	SORTBY 		VARCHAR2 (10),
   	SORTORDER 	NUMBER (16) DEFAULT (0) NOT NULL,
   	DGROUP 		NUMBER (16) DEFAULT (0) NOT NULL,
   	PAGESIZE	NUMBER (16) DEFAULT (0) NOT NULL,
   	VIEWGRP		VARCHAR2 (10) DEFAULT (0) NOT NULL,
 	PRIMARY KEY (ID)
);

CREATE SEQUENCE TWIG.SEQ_TWIG_BOOKMARKS_PREFS INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER;

CREATE TRIGGER TWIG.AI_TWIG_BOOKMARKS_PREFS BEFORE INSERT ON TWIG.TWIG_BOOKMARKS_PREFS FOR EACH ROW 
DECLARE
    N_NEXTVAL NUMBER;
BEGIN
  SELECT SEQ_TWIG_BOOKMARKS_PREFS.NEXTVAL INTO N_NEXTVAL FROM DUAL;
  :NEW.ID := N_NEXTVAL;
END;
/

COMMIT;

/* --------------------------------------------------------------------------------- */

CREATE TABLE TWIG_CONTACTS (
 	ID		NUMBER (16),
 	USERNAME	VARCHAR2 (128),
 	THEDATE		VARCHAR(16),
 	GROUPID		NUMBER (16) NOT NULL,
 	ITEM		VARCHAR2 (1000),
 	DESCRIPTION	VARCHAR2 (1000),
 	URL		VARCHAR2 (1000),
 	FIRSTNAME	VARCHAR2 (100),
 	LASTNAME	VARCHAR2 (100),
 	EMAIL		VARCHAR2 (100),
 	COMPANY		VARCHAR2 (100),
 	HOME_PHONE	VARCHAR2 (30),
 	WORK_PHONE	VARCHAR2 (30),
 	MOBILE		VARCHAR2 (30),
 	FAX		VARCHAR2 (30),
 	ADDRESS1	VARCHAR2 (200),
 	ADDRESS2	VARCHAR2 (200),
 	CITY		VARCHAR2 (100),
 	STATE		VARCHAR2 (10),
 	ZIPCODE		VARCHAR2 (10),
 	COUNTRY		VARCHAR2 (100),
 	EMAIL2 		VARCHAR2 (100),
 	EMAIL3 		VARCHAR2 (100),
 	TITLE 		VARCHAR2 (100),
 	PAGER 		VARCHAR2 (30),
 	OFAX 		VARCHAR2 (30),
 	DEPARTMENT 	VARCHAR2 (100),
 	OFFICE 		VARCHAR2 (100),
 	SPOUSE 		VARCHAR2 (100),
 	BDAY 		VARCHAR2 (40),
 	OADDRESS1 	VARCHAR2 (100),
 	OADDRESS2 	VARCHAR2 (100),
 	OCITY 		VARCHAR2 (100),
 	OZIP 		VARCHAR2 (10),
 	OSTATE 		VARCHAR2 (10),
 	OCOUNTRY 	VARCHAR2 (100),
	TYPE		NUMBER (16),
	USERPERS	NUMBER (16),
 	PRIMARY KEY (ID)
);

CREATE SEQUENCE TWIG.SEQ_TWIG_CONTACTS INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER;

CREATE TRIGGER TWIG.AI_TWIG_CONTACTS BEFORE INSERT ON TWIG.TWIG_CONTACTS FOR EACH ROW 
DECLARE
    N_NEXTVAL NUMBER;
BEGIN
  SELECT SEQ_TWIG_CONTACTS.NEXTVAL INTO N_NEXTVAL FROM DUAL;
  :NEW.ID := N_NEXTVAL;
END;
/

COMMIT;

/* --------------------------------------------------------------------------------- */

CREATE TABLE TWIG_CONTACTS_LISTS_ENTRIES (
	LISTID		NUMBER (16) DEFAULT (0) NOT NULL,
	TYPE		NUMBER (16) DEFAULT (0) NOT NULL,
	ITEM		NUMBER (16) DEFAULT (0) NOT NULL,
	SUBITEM		NUMBER (16)
);

COMMIT;

/* --------------------------------------------------------------------------------- */

CREATE TABLE TWIG_CONTACTS_PREFS (
   	ID 		NUMBER (16),
   	USERNAME 	VARCHAR2 (128),
   	SORTBY 		VARCHAR2 (10),
   	SORTORDER 	NUMBER (16) DEFAULT (0) NOT NULL,
   	DGROUP 		NUMBER (16) DEFAULT (0) NOT NULL,
   	VIEWGRP		VARCHAR2 (10) DEFAULT (0) NOT NULL,
 	PRIMARY KEY (ID)
);

CREATE SEQUENCE TWIG.SEQ_TWIG_CONTACTS_PREFS INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER;

CREATE TRIGGER TWIG.AI_TWIG_CONTACTS_PREFS BEFORE INSERT ON TWIG.TWIG_CONTACTS_PREFS FOR EACH ROW 
DECLARE
    N_NEXTVAL NUMBER;
BEGIN
  SELECT SEQ_TWIG_CONTACTS_PREFS.NEXTVAL INTO N_NEXTVAL FROM DUAL;
  :NEW.ID := N_NEXTVAL;
END;
/

COMMIT;

/* --------------------------------------------------------------------------------- */

CREATE TABLE TWIG_CONTEXT (
   	ID 		VARCHAR2 (40) NOT NULL,
   	USERNAME 	VARCHAR2 (128) NOT NULL,
   	CONTEXT 	VARCHAR2 (1000) NOT NULL,
   	SID 		NUMBER DEFAULT (0) NOT NULL
);

COMMIT;

/* --------------------------------------------------------------------------------- */

CREATE TABLE TWIG_FOLDERS (
   	ID 		NUMBER (16),
   	OWNER 		VARCHAR2 (128) NOT NULL,
   	SERVER 		VARCHAR2 (255) NOT NULL,
   	PORT 		NUMBER (16) DEFAULT (0) NOT NULL,
   	GROUPNAME 	VARCHAR2 (255) NOT NULL,
   	USERNAME 	VARCHAR2 (128),
   	PASSWORD 	VARCHAR2 (128),
   	SERVERTYPE 	VARCHAR2 (10),
 	PRIMARY KEY (ID)
);

CREATE SEQUENCE TWIG.SEQ_TWIG_FOLDERS INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER;

CREATE TRIGGER TWIG.AI_TWIG_FOLDERS BEFORE INSERT ON TWIG.TWIG_FOLDERS FOR EACH ROW 
DECLARE
    N_NEXTVAL NUMBER;
BEGIN
  SELECT SEQ_TWIG_FOLDERS.NEXTVAL INTO N_NEXTVAL FROM DUAL;
  :NEW.ID := N_NEXTVAL;
END;
/

COMMIT;

/* --------------------------------------------------------------------------------- */

CREATE TABLE TWIG_GLOBAL_PREFS (
   	ID 		NUMBER (16),
   	USERNAME 	VARCHAR2 (128),
   	MSTYLE1 	NUMBER (16) DEFAULT (0) NOT NULL,
   	MSTYLE2 	NUMBER (16) DEFAULT (3) NOT NULL,
   	TSTYLE1 	NUMBER (16) DEFAULT (5) NOT NULL,
   	LANGUAGE 	VARCHAR2 (20),
   	MAILFOOT	NUMBER (16),
   	PREVNEXT	VARCHAR2 (20),
	TIMEFORMAT	NUMBER (16),
	STYLESHEET	VARCHAR2 (32),
 	PRIMARY KEY (ID)
);

CREATE SEQUENCE TWIG.SEQ_TWIG_GLOBAL_PREFS INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER;

CREATE TRIGGER TWIG.AI_TWIG_GLOBAL_PREFS BEFORE INSERT ON TWIG.TWIG_GLOBAL_PREFS FOR EACH ROW
DECLARE
    N_NEXTVAL NUMBER;
BEGIN
  SELECT SEQ_TWIG_GLOBAL_PREFS.NEXTVAL INTO N_NEXTVAL FROM DUAL;
  :NEW.ID := N_NEXTVAL;
END;
/

COMMIT;

/* --------------------------------------------------------------------------------- */

CREATE TABLE TWIG_GROUPS (
	ID		NUMBER (16),
	OWNER		VARCHAR2 (128),
	GROUPNAME	VARCHAR2 (100),
	TYPE		VARCHAR2 (20),
 	PRIMARY KEY (ID)
);

CREATE SEQUENCE TWIG.SEQ_TWIG_GROUPS INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER;

CREATE TRIGGER TWIG.AI_TWIG_GROUPS BEFORE INSERT ON TWIG.TWIG_GROUPS FOR EACH ROW 
DECLARE
    N_NEXTVAL NUMBER;
BEGIN
  SELECT SEQ_TWIG_GROUPS.NEXTVAL INTO N_NEXTVAL FROM DUAL;
  :NEW.ID := N_NEXTVAL;
END;
/

COMMIT;

/* --------------------------------------------------------------------------------- */

CREATE TABLE TWIG_LHSQLTABLE (
	LID		VARCHAR2 (128),
	USERNAME	VARCHAR2 (128),
	PASSWORD	VARCHAR2 (128),
	EXPIRE		NUMBER (16),
 	PRIMARY KEY (LID)
);

COMMIT;

/* --------------------------------------------------------------------------------- */

CREATE TABLE TWIG_MAIL_PREFS (
	ID		NUMBER (16),
	USERNAME	VARCHAR2 (128),
	REALNAME	VARCHAR2 (1000),
	SIGNATURE	VARCHAR2 (1000),
 	LINEWRAP	VARCHAR2 (1000),
	REPLYTO		VARCHAR2 (1000),
	PAGESIZE	NUMBER (16),
	SORTBY		VARCHAR2 (10),
	SORTORDER	NUMBER (16),
	DANDE		NUMBER (16),
   	SAVESENT 	NUMBER (16),
   	SENTFOLD 	VARCHAR2 (1000),
	CMDLINE2	NUMBER (16),
	NEWWINDOW	NUMBER (16),
	LISTCMDS	VARCHAR2 (10),
	NEWCONTACT	NUMBER (16 ),
	DRAFTFOLD	VARCHAR2 (1000),
	NUMUP		NUMBER (16),
	MAILTREE 	NUMBER (16),
	MTEXPAND 	NUMBER (16),
	MTVIEW 		VARCHAR (255),
	MDN	 	NUMBER (16),
	MDN_MODE 	NUMBER (16),
	AREPLY		NUMBER (16),
	AFORWARD	NUMBER (16),
	CLINES		NUMBER (16),
	MANDE		NUMBER (16),
	DRETURN		NUMBER (16),
	FROMADDRESS	VARCHAR(128),
	CGROUP		VARCHAR(10),
 	PRIMARY KEY (ID)
);

CREATE SEQUENCE TWIG.SEQ_TWIG_MAIL_PREFS INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER;

CREATE TRIGGER TWIG.AI_TWIG_MAIL_PREFS BEFORE INSERT ON TWIG.TWIG_MAIL_PREFS FOR EACH ROW 
DECLARE
    N_NEXTVAL NUMBER;
BEGIN
  SELECT SEQ_TWIG_MAIL_PREFS.NEXTVAL INTO N_NEXTVAL FROM DUAL;
  :NEW.ID := N_NEXTVAL;
END;
/

COMMIT;

/* --------------------------------------------------------------------------------- */

CREATE TABLE TWIG_MAIN_PREFS (
   	ID 		NUMBER (16),
   	USERNAME 	VARCHAR2 (128),
   	features 	VARCHAR2 (128),
	maxmail		NUMBER (16),
	maxmeetings	NUMBER (16),
	maxschedule	NUMBER (16),
	maxtodo		NUMBER (16),
 	PRIMARY KEY (ID)
);

CREATE SEQUENCE TWIG.SEQ_TWIG_MAIN_PREFS INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER;

CREATE TRIGGER TWIG.AI_TWIG_MAIN_PREFS BEFORE INSERT ON TWIG.TWIG_MAIN_PREFS FOR EACH ROW 
DECLARE
    N_NEXTVAL NUMBER;
BEGIN
  SELECT SEQ_TWIG_MAIN_PREFS.NEXTVAL INTO N_NEXTVAL FROM DUAL;
  :NEW.ID := N_NEXTVAL;
END;
/

COMMIT;

/* --------------------------------------------------------------------------------- */

CREATE TABLE TWIG_MEETINGS (
  	ID 		NUMBER (16),
  	GROUPID		NUMBER (16) NOT NULL,
  	USERNAME	VARCHAR2 (128),
  	SECRETARY	VARCHAR2 (128),
  	RESPONSIBLE	VARCHAR2 (128),
  	THEDATE 	VARCHAR(16),
  	ITEMSTART 	VARCHAR(16),
  	ITEMSTOP 	VARCHAR(16),
  	ITEMDONE 	VARCHAR(16),
  	ITEM 		VARCHAR2 (1000),
  	DESCRIPTION 	VARCHAR2 (1000),
  	MINUTES		VARCHAR2 (1000),
  	CONCLUSION 	VARCHAR2 (1000),
  	ACTIONITEMS 	VARCHAR2 (1000),
  	LOCATION	NUMBER (16) NOT NULL,
  	USERLIMIT 	NUMBER (16) NOT NULL,
  	CLOSED 		NUMBER (16) NOT NULL,
  	DELETED 	NUMBER (16) NOT NULL,
  	PRIVATE 	NUMBER (16) NOT NULL,
  	PRIMARY KEY 	(id)
);

CREATE SEQUENCE TWIG.SEQ_TWIG_MEETINGS INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER;

CREATE TRIGGER TWIG.AI_TWIG_MEETINGS BEFORE INSERT ON TWIG.TWIG_MEETINGS FOR EACH ROW 
DECLARE
    N_NEXTVAL NUMBER;
BEGIN
  SELECT SEQ_TWIG_MEETINGS.NEXTVAL INTO N_NEXTVAL FROM DUAL;
  :NEW.ID := N_NEXTVAL;
END;
/

COMMIT;

/* --------------------------------------------------------------------------------- */

CREATE TABLE TWIG_MEETINGS_PREFS (
  	ID 		NUMBER (16),
  	USERNAME	VARCHAR2 (128),
  	DGROUP 		NUMBER (16) DEFAULT (0) NOT NULL,
  	MAINVIEW	NUMBER (16) DEFAULT (0) NOT NULL,
  	PAGESIZE	NUMBER (16) DEFAULT (0) NOT NULL,
   	VIEWGRP		VARCHAR2 (10) DEFAULT (0) NOT NULL,
  	PRIMARY KEY 	(id)
);

CREATE SEQUENCE TWIG.SEQ_TWIG_MEETINGS_PREFS INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER;

CREATE TRIGGER TWIG.AI_TWIG_MEETINGS_PREFS BEFORE INSERT ON TWIG.TWIG_MEETINGS_PREFS FOR EACH ROW 
DECLARE
    N_NEXTVAL NUMBER;
BEGIN
  SELECT SEQ_TWIG_MEETINGS_PREFS.NEXTVAL INTO N_NEXTVAL FROM DUAL;
  :NEW.ID := N_NEXTVAL;
END;
/

COMMIT;

/* --------------------------------------------------------------------------------- */

CREATE TABLE TWIG_MEETINGS_REGISTRATION (
  	ID 		NUMBER (16),
  	username 	VARCHAR2 (128),
  	eventid 	NUMBER (16) NOT NULL,
  	thedate 	VARCHAR2 (20),
  	rsvp 		NUMBER (16) NOT NULL,
  	PRIMARY KEY 	(id)
);

CREATE SEQUENCE TWIG.SEQ_TWIG_MEETINGS_REGISTRATION INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER;

CREATE TRIGGER TWIG.AI_TWIG_MEETINGS_REGISTRATION BEFORE INSERT ON TWIG.TWIG_MEETINGS_REGISTRATION FOR EACH ROW 
DECLARE
    N_NEXTVAL NUMBER;
BEGIN
  SELECT SEQ_TWIG_MEETINGS_REGISTRATION.NEXTVAL INTO N_NEXTVAL FROM DUAL;
  :NEW.ID := N_NEXTVAL;
END;
/

COMMIT;

/* --------------------------------------------------------------------------------- */

CREATE TABLE TWIG_MEETINGS_INVITATIONS (
  	ID 		NUMBER (16),
  	username 	VARCHAR2 (128),
  	eventid 	NUMBER (16) NOT NULL,
  	thedate		VARCHAR2 (20),
  	priority	NUMBER (16) NOT NULL,
  	PRIMARY KEY 	(id)
);

CREATE SEQUENCE TWIG.SEQ_TWIG_MEETINGS_INVITATIONS INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER;

CREATE TRIGGER TWIG.AI_TWIG_MEETINGS_INVITATIONS BEFORE INSERT ON TWIG.TWIG_MEETINGS_INVITATIONS FOR EACH ROW 
DECLARE
    N_NEXTVAL NUMBER;
BEGIN
  SELECT SEQ_TWIG_MEETINGS_INVITATIONS.NEXTVAL INTO N_NEXTVAL FROM DUAL;
  :NEW.ID := N_NEXTVAL;
END;
/

COMMIT;

/* --------------------------------------------------------------------------------- */

CREATE TABLE TWIG_MEMBERS (
	ID		NUMBER (16),
	GROUPID		NUMBER (16) NOT NULL,
	USERNAME	VARCHAR2 (128),
	WRITEPERMS	NUMBER (16),
 	PRIMARY KEY (ID)
);

CREATE SEQUENCE TWIG.SEQ_TWIG_MEMBERS INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER;

CREATE TRIGGER TWIG.AI_TWIG_MEMBERS BEFORE INSERT ON TWIG.TWIG_MEMBERS FOR EACH ROW 
DECLARE
    N_NEXTVAL NUMBER;
BEGIN
  SELECT SEQ_TWIG_MEMBERS.NEXTVAL INTO N_NEXTVAL FROM DUAL;
  :NEW.ID := N_NEXTVAL;
END;
/

COMMIT;

/* --------------------------------------------------------------------------------- */

CREATE TABLE TWIG_NEWS_PREFS (
   	ID 		NUMBER (16),
   	USERNAME	VARCHAR2 (128) NOT NULL,
   	REPLYTO 	VARCHAR2 (1000) NOT NULL,
   	PAGESIZE 	NUMBER (16) DEFAULT (0) NOT NULL,
   	NEWWINDOW 	NUMBER (16) DEFAULT (1) NOT NULL,
	LINEWRAP	VARCHAR2 (1000) NOT NULL,
	REALNAME	VARCHAR2 (1000) NOT NULL,
	SIGNATURE	VARCHAR2 (1000) NOT NULL,
   	INLINE 		NUMBER (16),
 	PRIMARY KEY (ID)
);

CREATE SEQUENCE TWIG.SEQ_TWIG_NEWS_PREFS INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER;

CREATE TRIGGER TWIG.AI_TWIG_NEWS_PREFS BEFORE INSERT ON TWIG.TWIG_NEWS_PREFS FOR EACH ROW 
DECLARE
    N_NEXTVAL NUMBER;
BEGIN
  SELECT SEQ_TWIG_NEWS_PREFS.NEXTVAL INTO N_NEXTVAL FROM DUAL;
  :NEW.ID := N_NEXTVAL;
END;
/

COMMIT;

/* --------------------------------------------------------------------------------- */

CREATE TABLE TWIG_NOTES (
 	ID		NUMBER (16),
	USERNAME	VARCHAR2 (128),
 	THEDATE		VARCHAR(16),
 	GROUPID		NUMBER (16) NOT NULL,
 	ITEM		VARCHAR2 (1000),
 	DESCRIPTION	VARCHAR2 (1000),
 	ATTACHNAME	VARCHAR2 (1000),
	ATTACHMIME	VARCHAR2 (1000),
	ATTACHMENT	CLOB,
	PRIMARY KEY	(id),
	KEY		(username)
);

CREATE SEQUENCE TWIG.SEQ_TWIG_NOTES INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER;

CREATE TRIGGER TWIG.AI_TWIG_SCHEDULE BEFORE INSERT ON TWIG.TWIG_NOTES FOR EACH ROW 
DECLARE
    N_NEXTVAL NUMBER;
BEGIN
  SELECT SEQ_TWIG_NOTES.NEXTVAL INTO N_NEXTVAL FROM DUAL;
  :NEW.ID := N_NEXTVAL;
END;
/

COMMIT;

/* --------------------------------------------------------------------------------- */

CREATE TABLE TWIG_NOTES_PREFS (
   	ID 		NUMBER (16),
   	USERNAME 	VARCHAR2 (128),
   	SORTBY 		VARCHAR2 (10),
   	SORTORDER 	NUMBER (16) DEFAULT (0) NOT NULL,
   	DGROUP 		NUMBER (16) DEFAULT (0) NOT NULL,
	WIDTH		NUMBER (16),
	HEIGHT		NUMBER (16),
	PAGESIZE	NUMBER (16),
   	VIEWGRP		VARCHAR2 (10) DEFAULT (0) NOT NULL,
 	PRIMARY KEY (ID)
	KEY		(username)
);

CREATE SEQUENCE TWIG.SEQ_TWIG_NOTES_PREFS INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER;

CREATE TRIGGER TWIG.AI_TWIG_NOTES_PREFS BEFORE INSERT ON TWIG.TWIG_NOTES_PREFS FOR EACH ROW 
DECLARE
    N_NEXTVAL NUMBER;
BEGIN
  SELECT SEQ_TWIG_NOTES_PREFS.NEXTVAL INTO N_NEXTVAL FROM DUAL;
  :NEW.ID := N_NEXTVAL;
END;
/

COMMIT;

/* --------------------------------------------------------------------------------- */

CREATE TABLE TWIG_SCHEDULE (
 	ID		NUMBER (16),
 	USERNAME	VARCHAR2 (128),
 	THEDATE		VARCHAR(16),
 	GROUPID		NUMBER (16) NOT NULL,
 	ITEMSTART	VARCHAR(16),
 	ITEMSTOP	VARCHAR(16),
 	ITEM		VARCHAR2 (1000),
 	DESCRIPTION	VARCHAR2 (1000),
	NOTIME		NUMBER (16),
	RECURTYPE	NUMBER (16),
	RECURID		NUMBER (16),
	REMIND_TIME	NUMBER (16),
	REMIND_QTY	NUMBER (16),
	REMIND_UNITS	VARCHAR(10),
	REMIND_ADDRESS	VARCHAR(100),
 	PRIMARY KEY (ID)
);

CREATE SEQUENCE TWIG.SEQ_TWIG_SCHEDULE INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER;

CREATE TRIGGER TWIG.AI_TWIG_SCHEDULE BEFORE INSERT ON TWIG.TWIG_SCHEDULE FOR EACH ROW 
DECLARE
    N_NEXTVAL NUMBER;
BEGIN
  SELECT SEQ_TWIG_SCHEDULE.NEXTVAL INTO N_NEXTVAL FROM DUAL;
  :NEW.ID := N_NEXTVAL;
END;
/

COMMIT;

/* --------------------------------------------------------------------------------- */

CREATE TABLE twig_schedule_recurring (
	ID		INT,
	SCHID		INT,
	RECURTYPE	INT NOT NULL,
	SCHEDULE	INT,
	CYCLE		INT,
	POSITION	INT,
	DAYS		VARCHAR (13),
	ENDTYPE		INT NOT NULL,
	END		DATETIME NOT NULL,
	PRIMARY KEY	(ID)
	);

CREATE SEQUENCE TWIG.SEQ_TWIG_SCHEDULE_RECURRING INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER;

CREATE TRIGGER TWIG.AI_TWIG_SCHEDULE_RECURRING BEFORE INSERT ON TWIG.TWIG_SCHEDULE_RECURRING FOR EACH ROW 
DECLARE
    N_NEXTVAL NUMBER;
BEGIN
  SELECT SEQ_TWIG_SCHEDULE_RECURRING.NEXTVAL INTO N_NEXTVAL FROM DUAL;
  :NEW.ID := N_NEXTVAL;
END;
/

COMMIT;

/* --------------------------------------------------------------------------------- */

CREATE TABLE TWIG_SCHEDULE_PREFS (
   	ID 		NUMBER (16),
   	USERNAME 	VARCHAR2 (128),
   	DGROUP 		NUMBER (16) DEFAULT (0) NOT NULL,
   	VIEWGRP		VARCHAR2 (10) DEFAULT (0) NOT NULL,
 	PRIMARY KEY (ID)
);

CREATE SEQUENCE TWIG.SEQ_TWIG_SCHEDULE_PREFS INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER;

CREATE TRIGGER TWIG.AI_TWIG_SCHEDULE_PREFS BEFORE INSERT ON TWIG.TWIG_SCHEDULE_PREFS FOR EACH ROW 
DECLARE
    N_NEXTVAL NUMBER;
BEGIN
  SELECT SEQ_TWIG_SCHEDULE_PREFS.NEXTVAL INTO N_NEXTVAL FROM DUAL;
  :NEW.ID := N_NEXTVAL;
END;
/

COMMIT;

/* --------------------------------------------------------------------------------- */

CREATE TABLE TWIG_SCLHSQLTABLE (
	LID		VARCHAR2 (128),
	PWDATA		VARCHAR2 (128),
	USERNAME	VARCHAR2 (128),
	EXPIRE		NUMBER (16),
 	PRIMARY KEY (LID)
);

COMMIT;

/* --------------------------------------------------------------------------------- */

CREATE TABLE TWIG_SESSION (
   	ID 		VARCHAR2 (40) NOT NULL,
   	USERNAME 	VARCHAR2 (128) NOT NULL,
   	SDATA 		CLOB NOT NULL,
   	SID 		NUMBER DEFAULT (0) NOT NULL
);

COMMIT;

/* --------------------------------------------------------------------------------- */

CREATE TABLE TWIG_TODO (
 	ID		NUMBER (16),
 	USERNAME	VARCHAR2 (128),
 	THEDATE		VARCHAR(16),
 	GROUPID		NUMBER (16) NOT NULL,
 	ITEM		VARCHAR2 (1000),
 	DESCRIPTION	VARCHAR2 (1000),
 	PRIORITY	NUMBER (16),
 	COMPLETED	NUMBER (16),
	DUEDATE		VARCHAR(16),
	DUETYPE		NUMBER (16),
 	PRIMARY KEY (ID)
);

CREATE SEQUENCE TWIG.SEQ_TWIG_TODO INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER;

CREATE TRIGGER TWIG.AI_TWIG_TODO BEFORE INSERT ON TWIG.TWIG_TODO FOR EACH ROW 
DECLARE
    N_NEXTVAL NUMBER;
BEGIN
  SELECT SEQ_TWIG_TODO.NEXTVAL INTO N_NEXTVAL FROM DUAL;
  :NEW.ID := N_NEXTVAL;
END;
/

COMMIT;

/* --------------------------------------------------------------------------------- */

CREATE TABLE TWIG_TODO_LISTS_ENTRIES (
	LISTID		NUMBER (16) DEFAULT (0) NOT NULL,
	TYPE		NUMBER (16) DEFAULT (0) NOT NULL,
	ITEM		NUMBER (16) DEFAULT (0) NOT NULL,
	SUBITEM		NUMBER (16)
);

COMMIT;

/* --------------------------------------------------------------------------------- */

CREATE TABLE TWIG_TODO_PREFS (
   	ID 		NUMBER (16),
   	USERNAME 	VARCHAR2 (20),
   	SORTBY 		VARCHAR2 (10),
   	SORTORDER 	NUMBER (16) DEFAULT (0) NOT NULL,
   	DGROUP 		NUMBER (16) DEFAULT (0) NOT NULL,
   	PRIORITY 	NUMBER (16) DEFAULT (0) NOT NULL,
   	PAGESIZE 	NUMBER (16) DEFAULT (0) NOT NULL,
   	VIEWGRP		VARCHAR2 (10) DEFAULT (0) NOT NULL,
   	DUETYPE		NUMBER (16) DEFAULT (0) NOT NULL,
 	PRIMARY KEY (ID)
);

CREATE SEQUENCE TWIG.SEQ_TWIG_TODO_PREFS INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER;

CREATE TRIGGER TWIG.AI_TWIG_TODO_PREFS BEFORE INSERT ON TWIG.TWIG_TODO_PREFS FOR EACH ROW 
DECLARE
    N_NEXTVAL NUMBER;
BEGIN
  SELECT SEQ_TWIG_TODO_PREFS.NEXTVAL INTO N_NEXTVAL FROM DUAL;
  :NEW.ID := N_NEXTVAL;
END;
/

COMMIT;

/* --------------------------------------------------------------------------------- */