26 lines
439 B
SQL
26 lines
439 B
SQL
-- Create sequence 银联订单号
|
|
create sequence upop_sequence
|
|
minvalue 1
|
|
maxvalue 99999999
|
|
start with 00000001
|
|
increment by 1
|
|
cache 200
|
|
cycle;
|
|
|
|
-- Create sequence 银联批次号
|
|
create sequence upop_batno_sequence
|
|
minvalue 1
|
|
maxvalue 9999
|
|
start with 0001
|
|
increment by 1
|
|
cache 100
|
|
cycle;
|
|
|
|
-- Create sequence 流水号
|
|
create sequence jrn_no_sequence
|
|
minvalue 1
|
|
maxvalue 9999999999
|
|
start with 0000000001
|
|
increment by 1
|
|
cache 100
|
|
cycle; |