ALTER TABLE twig_mail_prefs ADD mdn_mode NUMBER (16);
ALTER TABLE twig_mail_prefs ADD areply NUMBER (16);
ALTER TABLE twig_mail_prefs ADD aforward NUMBER (16);
ALTER TABLE twig_mail_prefs ADD clines NUMBER (16);
ALTER TABLE twig_mail_prefs ADD mande NUMBER (16);
ALTER TABLE twig_bookmarks_prefs ADD viewgrp VARCHAR2 (10);
ALTER TABLE twig_contacts_prefs ADD viewgrp VARCHAR2 (10);
ALTER TABLE twig_meetings_prefs ADD viewgrp VARCHAR2 (10);
ALTER TABLE twig_notes_prefs ADD viewgrp VARCHAR2 (10);
ALTER TABLE twig_schedule_prefs ADD viewgrp VARCHAR2 (10);
ALTER TABLE twig_todo_prefs ADD viewgrp VARCHAR2 (10);
ALTER TABLE twig_todo_prefs ADD duetype NUMBER (16);
ALTER TABLE twig_todo ADD duedate VARCHAR(16);
ALTER TABLE twig_todo ADD duetype NUMBER (16);
COMMIT;

CREATE TABLE TWIG_MEETINGS_INVITATIONS (
  	IDX 		NUMBER (16),
  	user_idx 	VARCHAR2 (20),
  	event_idx 	NUMBER (16) NOT NULL,
  	r_date 		VARCHAR2 (20),
  	priority	NUMBER (16) NOT NULL,
  	PRIMARY KEY 	(idx),
);

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_announce (
   	ID 		NUMBER (16),
   	DATE 		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;