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

CREATE TABLE ARCHIVE_PARAMS
 (   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,0) NOT NULL ENABLE,
     SYSTEM_ID NUMBER(4,0) DEFAULT 0 NOT NULL ENABLE,
     PARAM_NAME VARCHAR2(30) NOT NULL,
     PARAM_VALUE VARCHAR2(100) NOT NULL,
     DESCRIPTION VARCHAR2(200) NOT NULL
 ) 
STORAGE
 (
   INITIAL 20K
   NEXT 20K
   PCTINCREASE 0
 ) TABLESPACE APPN_GENERAL_TABLES
/

ALTER TABLE ARCHIVE_PARAMS
 ADD (CONSTRAINT ARCHIVE_PARAMS_PK PRIMARY KEY
  (APPN_ROW_ID)
 USING INDEX
 PCTFREE 5
 STORAGE
 (
   INITIAL 20K
   NEXT 20K
   PCTINCREASE 0
 ) TABLESPACE APPN_GENERAL_IDXS)
/

