CREATE TABLE BAW_NOTIFY_MESSAGE_LOG
(
  ID       NUMBER                               NOT NULL,
  MSGID    NUMBER                               NOT NULL,
  USERNR   NUMBER                               NOT NULL,
  READ     DATE                                 DEFAULT sysdate               NOT NULL,
  STATUS   NUMBER                                   NULL,
  DELETED  DATE                                     NULL,
  WI_ID    VARCHAR2(40 BYTE)                        NULL
)
LOGGING 
NOCACHE
NOPARALLEL
/


CREATE TABLE BAW_NOTIFY_MESSAGE
(
  ID            NUMBER                          NOT NULL,
  FROM_USERNR   NUMBER                          NOT NULL,
  TO_USERNR     NUMBER                          NOT NULL,
  TIMESTAMP     DATE                            DEFAULT sysdate               NOT NULL,
  ALLOWREPLY    NUMBER(1)                       DEFAULT 0                     NOT NULL,
  MESSAGECLASS  NUMBER                          DEFAULT 0                     NOT NULL,
  MESSAGE       VARCHAR2(1500 BYTE)             NOT NULL,
  STATUS        NUMBER                          DEFAULT 0                         NULL,
  READ          DATE                                NULL,
  DELETED       DATE                                NULL
)
LOGGING 
NOCACHE
NOPARALLEL
/


ALTER TABLE BAW_NOTIFY_MESSAGE_LOG ADD (
  CONSTRAINT PK_BAW_NOTIFY_MESSAGE_LOG PRIMARY KEY (ID))
/


ALTER TABLE BAW_NOTIFY_MESSAGE ADD (
  CONSTRAINT PK_BAW_NOTIFY_MESSAGE PRIMARY KEY (ID))
/



CREATE SEQUENCE NOTIFY_SEQ
  START WITH 1
  MAXVALUE 999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  CACHE 20
  NOORDER;