Z-Archive » Maybank Projects » M2U UPASS Project

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

Rem   NAME

Rem     <ib_sequence.sql>

Rem   DESCRIPTION

Rem     <IB Sequence> 

Rem   MODULE

Rem     <IB Module>

Rem   MODIFIED  (MM/DD/YYYY)

Rem        Danniell   19/10/2010 - Creation

Rem        xxxxxx           mm/dd/yyyy - Modify

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

CREATE SEQUENCE IB_SEQ_LOGIN_HISTORY

  START WITH 5104

  MAXVALUE 999999999

  MINVALUE 1

  NOCYCLE

  NOCACHE

  NOORDER;

CREATE SEQUENCE IB_SEQ_SESS 

  MINVALUE 1 

  MAXVALUE 999999 

  INCREMENT BY 1 

  START WITH 4092 

  NOCACHE  

  NOORDER  

  CYCLE;

CREATE SEQUENCE IB_SEQ_TRNX  

  MINVALUE 1 

  MAXVALUE 9999999999 

  INCREMENT BY 1 

  START WITH 7086 

  NOCACHE  

  NOORDER  

  NOCYCLE;

CREATE SEQUENCE SQ_ADMIN_GROUP

  START WITH 20

  MAXVALUE 999999999999999999999999999

  MINVALUE 1

  NOCYCLE

  NOCACHE

  NOORDER;

CREATE SEQUENCE SQ_ADMIN_NAVIGATION

  START WITH 20

  MAXVALUE 999999999999999999999999999

  MINVALUE 1

  NOCYCLE

  NOCACHE

  NOORDER;

CREATE SEQUENCE SQ_ADMIN_ROLE

  START WITH 10

  MAXVALUE 999999999999999999999999999

  MINVALUE 1

  NOCYCLE

  NOCACHE

  NOORDER;

CREATE SEQUENCE SQ_AUDIT_LOG

  START WITH 1967

  MAXVALUE 999999999999999999999999999

  MINVALUE 1

  NOCYCLE

  NOCACHE

  NOORDER;

CREATE SEQUENCE SQ_BANCNET_LIST

  START WITH 109

  MAXVALUE 999999999999999999999999999

  MINVALUE 1

  NOCYCLE

  NOCACHE

  NOORDER;

CREATE SEQUENCE SQ_BANK_BRANCH

  START WITH 1

  MAXVALUE 999999999999999999999999999

  MINVALUE 1

  NOCYCLE

  NOCACHE

  NOORDER;

CREATE SEQUENCE SQ_CONTENT_CATEGORY

  START WITH 53

  MAXVALUE 999999999999999999999999999

  MINVALUE 1

  NOCYCLE

  NOCACHE

  NOORDER;

CREATE SEQUENCE SQ_CONTENT_TYPE

  START WITH 10

  MAXVALUE 999999999999999999999999999

  MINVALUE 1

  NOCYCLE

  NOCACHE

  NOORDER;

CREATE SEQUENCE SQ_CURRENCY_CODE

  START WITH 1

  MAXVALUE 999999999999999999999999999

  MINVALUE 1

  NOCYCLE

  NOCACHE

  NOORDER;

CREATE SEQUENCE SQ_IB_GROUP

  START WITH 3

  MAXVALUE 999999999999999999999999999

  MINVALUE 1

  NOCYCLE

  NOCACHE

  NOORDER;

CREATE SEQUENCE SQ_IB_NAVIGATION

  START WITH 3

  MAXVALUE 999999999999999999999999999

  MINVALUE 1

  NOCYCLE

  NOCACHE

  NOORDER;

CREATE SEQUENCE SQ_IB_ORGANIZATION

  START WITH 53

  MAXVALUE 999999999999999999999999999

  MINVALUE 1

  NOCYCLE

  NOCACHE

  NOORDER;

CREATE SEQUENCE SQ_IB_ROLE

  START WITH 5

  MAXVALUE 999999999999999999999999999

  MINVALUE 1

  NOCYCLE

  NOCACHE

  NOORDER;

CREATE SEQUENCE SQ_IB_USER

  START WITH 243

  MAXVALUE 999999999999999999999999999

  MINVALUE 1

  NOCYCLE

  NOCACHE

  NOORDER;

CREATE SEQUENCE SQ_PAYEE

  START WITH 113

  MAXVALUE 999999999999999999999999999

  MINVALUE 1

  NOCYCLE

  NOCACHE

  NOORDER;

CREATE SEQUENCE SQ_PRODUCT_TYPE

  START WITH 50

  MAXVALUE 999999999999999999999999999

  MINVALUE 1

  NOCYCLE

  NOCACHE

  NOORDER;

CREATE SEQUENCE SQ_SERVICE_INFO

  START WITH 1

  MAXVALUE 999999999999999999999999999

  MINVALUE 1

  NOCYCLE

  NOCACHE

  NOORDER;

CREATE SEQUENCE SQ_SERVICE_LIST

  START WITH 649

  MAXVALUE 999999999999999999999999999

  MINVALUE 1

  NOCYCLE

  NOCACHE

  NOORDER;

CREATE SEQUENCE SQ_SERVICE_NOTE

  START WITH 7

  MAXVALUE 999999999999999999999999999

  MINVALUE 1

  NOCYCLE

  NOCACHE

  NOORDER;

CREATE SEQUENCE SQ_TD_TERM

  START WITH 1

  MAXVALUE 999999999999999999999999999

  MINVALUE 1

  NOCYCLE

  NOCACHE

  NOORDER;

CREATE SEQUENCE SQ_TRNX_HISTORY

  START WITH 1

  MAXVALUE 999999999999999999999999999

  MINVALUE 1

  NOCYCLE

  NOCACHE

  NOORDER;