create_sequence.sql

来自「通过串口连接短信猫进行短信的群发、单发、接收；管理群发订单、用户账户等」· SQL 代码 · 共 43 行

DROP SEQUENCE TOrdersID_SEQ; 
DROP SEQUENCE TPhoNumID_SEQ;
DROP SEQUENCE TUserID_SEQ;
DROP SEQUENCE TSendID_SEQ;
DROP SEQUENCE TRecID_SEQ;

create sequence TOrdersID_SEQ
   start with 1 
   increment by 1 
   maxvalue 999999 
   nocycle
   cache 20 
/   
create sequence TPhoNumID_SEQ
       start with 1
       increment by 1
       maxvalue 999999
       nocycle
       cache 20
/       
create sequence TUserID_SEQ
       start with 1
       increment by 1
       maxvalue 999999
       nocycle
       cache 20
/
create sequence TSendID_SEQ
       start with 1
       increment by 1
       maxvalue 999999
       nocycle
       cache 20
/      
create sequence TRecID_SEQ
       start with 1
       increment by 1
       maxvalue 999999
       nocycle
       cache 20
/      
COMMIT;