create_sequence.sql

来自「使用短信猫可以实现短信的群发」· SQL 代码 · 共 47 行

drop sequence SEQ;
drop sequence ORDERSEQ;
drop sequence SENDSEQ;
drop sequence RECEIVEDSEQ;
drop sequence PNUMBERSEQ;

create sequence ORDERSEQ
minvalue 1
maxvalue 99999
start with 2
increment by 1
cache 20;
commit;

create sequence PNUMBERSEQ
minvalue 1
maxvalue 99999
start with 1
increment by 1
cache 20;
commit;

create sequence RECEIVEDSEQ
minvalue 1
maxvalue 99999
start with 1
increment by 1
cache 20;
commit;

create sequence SENDSEQ
minvalue 1
maxvalue 99999
start with 1
increment by 1
cache 20;
commit;

create sequence SEQ
minvalue 1
maxvalue 99999
start with 1
increment by 1
cache 20;
commit;