-- Create sequence  工行订单号
-- drop sequence icbc_cap_sequence;
create sequence icbc_cap_sequence
minvalue 1
maxvalue 99999999
start with 00000001
increment by 1
cache 100
cycle;