ALTER TABLE twig_lhsqltable CHANGE LID LID varchar(40) DEFAULT '0' NOT NULL;

ALTER TABLE twig_global_prefs ADD timeformat NUMBER (16);
ALTER TABLE twig_mail_prefs ADD numup NUMBER (16);

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

CREATE TABLE TWIG_NOTES (
 	ID		NUMBER (16),
	USERNAME	VARCHAR2 (20),
 	THEDATE		VARCHAR(16),
 	GROUPID		NUMBER (16) NOT NULL,
 	ITEM		VARCHAR2 (1000),
 	DESCRIPTION	VARCHAR2 (1000),
 	ATTACHNAME	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 (20),
   	SORTBY 		VARCHAR2 (10),
   	SORTORDER 	NUMBER (16) DEFAULT (0) NOT NULL,
   	DGROUP 		NUMBER (16) DEFAULT (0) NOT NULL,
	WIDTH		NUMBER (16),
	HEIGHT		NUMBER (16),
 	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_MEETINGS (
  	ID 		NUMBER (16),
  	GROUPID		NUMBER (16) NOT NULL,
  	USERNAME	VARCHAR2 (20),
  	SECRETARY	VARCHAR2 (20),
  	RESPONSIBLE	VARCHAR2 (20),
  	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 (20),
  	DGROUP 		NUMBER (16) DEFAULT (0) NOT NULL,
  	MAINVIEW	NUMBER (16) DEFAULT (0) NOT NULL,
  	PAGESIZE	NUMBER (16) 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 (
  	IDX 		NUMBER (16),
  	user_idx 	VARCHAR2 (20),
  	event_idx 	NUMBER (16) NOT NULL,
  	r_date 		VARCHAR2 (20),
  	rsvp 		NUMBER (16) NOT NULL,
  	PRIMARY KEY 	(idx),
);

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;