118 lines
1.5 KiB
SQL
118 lines
1.5 KiB
SQL
create sequence PRD_ID
|
|
maxvalue 999999999
|
|
order
|
|
/
|
|
|
|
create sequence PUBSBSP
|
|
minvalue 0
|
|
maxvalue 9999999999
|
|
cycle
|
|
cache 200
|
|
/
|
|
|
|
create sequence PUBSIDN
|
|
minvalue 0
|
|
maxvalue 999999999999999999
|
|
cycle
|
|
cache 100
|
|
/
|
|
|
|
create sequence PUBSJRN
|
|
minvalue 0
|
|
maxvalue 9999999999
|
|
cycle
|
|
cache 2000
|
|
/
|
|
|
|
create sequence SEQ_JOURNAL_NO
|
|
maxvalue 9999999999
|
|
cycle
|
|
cache 100
|
|
/
|
|
|
|
create sequence SEQ_PARM_ID
|
|
cache 10
|
|
/
|
|
|
|
create sequence SEQ_RUTTRURC
|
|
minvalue 1000000001
|
|
maxvalue 99999999999999
|
|
/
|
|
|
|
create sequence SEQ_URMTMINF
|
|
cache 60
|
|
/
|
|
|
|
create sequence SEQ_URMTOPPR
|
|
minvalue 1000000001
|
|
maxvalue 99999999999999
|
|
/
|
|
|
|
create sequence SEQ_USER_INFO
|
|
/
|
|
|
|
create sequence S_DATA_ID
|
|
maxvalue 9999999999
|
|
cycle
|
|
nocache
|
|
/
|
|
|
|
create sequence S_LOG_NO
|
|
minvalue 0
|
|
maxvalue 999999999999999999
|
|
cache 100
|
|
/
|
|
|
|
create sequence USENO_ID
|
|
minvalue 100000000000
|
|
maxvalue 999999999999
|
|
order
|
|
/
|
|
|
|
create sequence JRN_NO_SEQUENCE
|
|
maxvalue 9999999999
|
|
cycle
|
|
cache 100
|
|
/
|
|
|
|
|
|
|
|
create sequence CK_SEQUENCE
|
|
maxvalue 99999999
|
|
cycle
|
|
cache 100
|
|
/
|
|
|
|
create sequence ICBC_CAP_SEQUENCE
|
|
maxvalue 9999
|
|
cycle
|
|
cache 100
|
|
/
|
|
|
|
create sequence ICBCCORGBUSTYP
|
|
maxvalue 999
|
|
cycle
|
|
cache 100
|
|
/
|
|
|
|
CREATE SEQUENCE UPOP_BATNO_SEQUENCE
|
|
INCREMENT BY 1
|
|
START WITH 1
|
|
MAXVALUE 9999
|
|
CACHE 100 ORDER CYCLE
|
|
/
|
|
|
|
CREATE SEQUENCE UPOP_SEQUENCE
|
|
INCREMENT BY 1
|
|
START WITH 1
|
|
MAXVALUE 99999999
|
|
CACHE 200 ORDER CYCLE
|
|
/
|
|
|
|
CREATE SEQUENCE PAB_CHECK_SEQUENCE
|
|
INCREMENT BY 1
|
|
START WITH 1
|
|
MAXVALUE 999999
|
|
CACHE 100 ORDER CYCLE
|
|
/
|