/*****************************************************************************
*
* Filename         - $Workfile:   MESSAGE_NOTIFICATIONS.sql  $
*
* Author           - Dave Banks
*
* Project Name     - UltraTrak Core 
*
* Source Code
* Identifier       - Database (Master Standby) 
*
* Design Spec
* Section          - 
*
* Contents         - Database script to create table MESSAGE_NOTIFICATIONS
*
* Language         - Oracle SQL script      
*
* Classification   - Commercial In Confidence
*
*          (c) Ultra Electronics Limited, 2006
*
*****************************************************************************/

PROMPT Creating table MESSAGE_NOTIFICATIONS

CREATE TABLE MESSAGE_NOTIFICATIONS (
    ROW_CREATE_TIME DATE,
    ROW_DATE_TIME DATE,
    CUSER VARCHAR2(30),
    MUSER VARCHAR2(30),
    MTERM VARCHAR2(64),
    SOURCE VARCHAR2(8),
    TO_BE_ARCHIVED VARCHAR2(1),
    APPN_ROW_ID NUMBER(18) NOT NULL,
    SYSTEM_ID NUMBER(4) NOT NULL,
    SEQ NUMBER(18),
    AMENDMENT LONG
) TABLESPACE APPN_GENERAL_TABLES
/

PROMPT Creating Primary Key for MESSAGE_NOTIFICATIONS

ALTER TABLE MESSAGE_NOTIFICATIONS
 ADD (CONSTRAINT MESSAGE_NOTIFICATIONS_PK PRIMARY KEY
  (SEQ)
 USING INDEX
 TABLESPACE APPN_GENERAL_IDXS)
/


