-- 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;