清除相关的表中数据

delete from pub_client;
delete from xxs_order;
delete from xxs_orderd;
delete from xxs_take;
delete from xxs_taked;
delete from xxs_cusfin;
delete from xxs_magazine_pre;
delete from xxs_magazine;
delete from xxs_pay;
delete from xxs_setlocal;

drop sequence CLIENTID;
create sequence CLIENTID
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
cache 20;

drop sequence ORDERID;
create sequence ORDERID
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
cache 20;

drop sequence PAYID;
create sequence PAYID
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
cache 20;

drop sequence PRICEID;
create sequence PRICEID
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
cache 20;

drop sequence TAKE;
create sequence TAKE
minvalue 1
maxvalue 99999999999999999
start with 1
increment by 1
cache 25;

drop sequence SN_XXS;
create sequence SN_XXS
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
cache 20;

drop sequence SN_SYSS;
create sequence SN_SYSS
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
cache 20;

drop sequence SETLID;
create sequence SETLID
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
cache 20;

drop sequence ADID;
create sequence ADID
minvalue 1
maxvalue 9999999999999999999
start with 1
increment by 1
nocache;


commit;