DOC/3设计阶段/DB/01_data/sequence_data.sql

#系统通用
insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) 
values('IM_LOG_NO','100000','1','100000','99999999','');
insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) 
values('IM_USER_NO','100000','1','100000','99999999','');
insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) 
values('IM_ROLE_NO','100000','1','100000','99999999','');
insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) 
values('IM_BRANCH_NO','100000','1','100000','99999999','');

insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) 
values('TP_COM_ID','100000','1','100000','999999','企业表主键');


insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) 
values('TP_ORDER_NO','1000000000','1','1000000000','9999999999','订单表主键');
insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) 
values('TP_ORDER_DETAILE_NO','100000','1','100000','999999','订单详情表主键');



insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) 
values('TP_LOGISTICS_HIS_NO','1000000000','1','1000000000','9999999999','订单物流流水表主键');

insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS)
values('RECHARGE_RULE_NO','100000','1','100000','9999999999','充值规则表主键');