Z-Archive » Maybank Projects » M2U UPASS Project

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

Rem   NAME

Rem     <ib_adapt.sql>

Rem   DESCRIPTION

Rem     <IB Adapt Table> 

Rem   MODULE

Rem     <IB Module>

Rem   MODIFIED  (MM/DD/YYYY)

Rem        Shuhaida   01/03/2011 - Creation

Rem        xxxxxx           mm/dd/yyyy - Modify

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

CREATE TABLE IB_ADAPT

(

  USER_ID                 NUMBER                NOT NULL,

  IB_ADAPT_IMAGE_URL      VARCHAR2(100 BYTE),

  IB_ADAPT_IMAGE_CAPTION  VARCHAR2(100 BYTE)

)

TABLESPACE USERS

PCTUSED    40

PCTFREE    10

INITRANS   1

MAXTRANS   255

STORAGE    (

            INITIAL          64K

            MINEXTENTS       1

            MAXEXTENTS       UNLIMITED

            PCTINCREASE      0

            FREELISTS        1

            FREELIST GROUPS  1

            BUFFER_POOL      DEFAULT

           )

LOGGING 

NOCOMPRESS 

NOCACHE

NOPARALLEL

MONITORING;

CREATE UNIQUE INDEX IB_ADAPT_PK ON IB_ADAPT

(USER_ID)

LOGGING

TABLESPACE USERS

PCTFREE    10

INITRANS   2

MAXTRANS   255

STORAGE    (

            INITIAL          64K

            MINEXTENTS       1

            MAXEXTENTS       UNLIMITED

            PCTINCREASE      0

            FREELISTS        1

            FREELIST GROUPS  1

            BUFFER_POOL      DEFAULT

           )

NOPARALLEL;

ALTER TABLE IB_ADAPT ADD (

  CONSTRAINT IB_ADAPT_PK

 PRIMARY KEY

 (USER_ID)

    USING INDEX 

    TABLESPACE USERS

    PCTFREE    10

    INITRANS   2

    MAXTRANS   255

    STORAGE    (

                INITIAL          64K

                MINEXTENTS       1

                MAXEXTENTS       UNLIMITED

                PCTINCREASE      0

                FREELISTS        1

                FREELIST GROUPS  1

               ));