Z-Archive » Maybank Projects » M2U UPASS Project

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

Rem   NAME

Rem     <tb_am_usermas.sql>

Rem   DESCRIPTION

Rem     <User Master Information Table>

Rem   MODULE

Rem     <Authentication Module>

Rem   MODIFIED  (MM/DD/YYYY)

Rem        YCLiew           12/10/2008 - Creation

Rem        xxxxxx           mm/dd/yyyy - Modify

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

CREATE TABLE TB_AM_USERMAS

(

  M_USER_ALIAS  VARCHAR2(20 BYTE) CONSTRAINT NN_UM_USER_ALIAS NOT NULL,

  M_USER_ID     NUMBER(9) CONSTRAINT NN_UM_USER_ID NOT NULL

)

TABLESPACE USERS

PCTUSED    0

PCTFREE    20

INITRANS   1

MAXTRANS   255

STORAGE    (

            INITIAL          16K

            MINEXTENTS       1

            MAXEXTENTS       UNLIMITED

            PCTINCREASE      0

            BUFFER_POOL      DEFAULT

           )

LOGGING

NOCOMPRESS

NOCACHE

NOPARALLEL

MONITORING;

CREATE UNIQUE INDEX PK_UM_USER_ALIAS ON TB_AM_USERMAS

(M_USER_ALIAS)

LOGGING

TABLESPACE USERS

PCTFREE    10

INITRANS   2

MAXTRANS   255

STORAGE    (

            INITIAL          16K

            MINEXTENTS       1

            MAXEXTENTS       UNLIMITED

            PCTINCREASE      0

            BUFFER_POOL      DEFAULT

           )

NOPARALLEL;

ALTER TABLE TB_AM_USERMAS ADD (

  CONSTRAINT PK_UM_USER_ALIAS

 PRIMARY KEY

 (M_USER_ALIAS)

    USING INDEX

    TABLESPACE USERS

    PCTFREE    10

    INITRANS   2

    MAXTRANS   255

    STORAGE    (

                INITIAL          16K

                MINEXTENTS       1

                MAXEXTENTS       UNLIMITED

                PCTINCREASE      0

               ));

CREATE SEQUENCE seq_user_id

        START WITH        10

        INCREMENT BY        1

        MAXVALUE        999999999

        NOCACHE

        NOCYCLE;