Z-Archive » Maybank Projects » M2U UPASS Project

Rem =====================================================================

Rem   NAME

Rem     <admin_navigation.sql>

Rem   DESCRIPTION

Rem     <Admin Navigation Table>

Rem   MODULE

Rem     <MSS Module>

Rem   MODIFIED  (MM/DD/YYYY)

Rem        Danniell   03/12/2010 - Creation

Rem        xxxxxx           mm/dd/yyyy - Modify

Rem =====================================================================

CREATE TABLE ADMIN_NAVIGATION

(

  NODE_ID             NUMBER                    NOT NULL,

  PARENT_ID           NUMBER,

  NODE_NAME           VARCHAR2(64 BYTE)         NOT NULL,

  NODE_DESCRIPTION    VARCHAR2(256 BYTE),

  NODE_TYPE           VARCHAR2(1 BYTE),

  NODE_STATUS         VARCHAR2(1 BYTE),

  NODE_CODE           VARCHAR2(16 BYTE)         NOT NULL,

  NODE_DISPLAY_ORDER  NUMBER,

  PAGE_PATH           VARCHAR2(256 BYTE),

  NODE_CREATED_BY     NUMBER,

  NODE_UPDATED_BY     NUMBER,

  NODE_CREATION_DATE  TIMESTAMP(2)              DEFAULT SYSDATE               NOT NULL,

  NODE_UPDATED_DATE   TIMESTAMP(2),

  CATEGORY            NUMBER

)

TABLESPACE USERS

PCTUSED    0

PCTFREE    10

INITRANS   1

MAXTRANS   255

STORAGE    (

            INITIAL          64K

            NEXT             128K

            MINEXTENTS       1

            MAXEXTENTS       UNLIMITED

            PCTINCREASE      0

            FREELISTS        1

            FREELIST GROUPS  1

            BUFFER_POOL      DEFAULT

           )

LOGGING

NOCOMPRESS

NOCACHE

NOPARALLEL

MONITORING;

CREATE UNIQUE INDEX ADMIN_NAVIGATION_PK ON ADMIN_NAVIGATION

(NODE_ID)

LOGGING

TABLESPACE USERS

PCTFREE    10

INITRANS   2

MAXTRANS   255

STORAGE    (

            INITIAL          64K

            NEXT             128K

            MINEXTENTS       1

            MAXEXTENTS       UNLIMITED

            PCTINCREASE      0

            FREELISTS        1

            FREELIST GROUPS  1

            BUFFER_POOL      DEFAULT

           )

NOPARALLEL;

ALTER TABLE ADMIN_NAVIGATION ADD (

  CONSTRAINT ADMIN_NAVIGATION_PK

 PRIMARY KEY

 (NODE_ID)

    USING INDEX

    TABLESPACE USERS

    PCTFREE    10

    INITRANS   2

    MAXTRANS   255

    STORAGE    (

                INITIAL          64K

                NEXT             128K

                MINEXTENTS       1

                MAXEXTENTS       UNLIMITED

                PCTINCREASE      0

                FREELISTS        1

                FREELIST GROUPS  1

               ));