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_CIF_ID','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('SEND_MSG_FLOW','1000000','1','1000000','9999999','短信明细表主键');
insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) 
values('ORDER_AUTH_FLOW','1000000','1','1000000','9999999','融资订单审核表主键');

insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) 
values('APPROVE_AUTH_NO','1000000','1','1000000','9999999','审核流水表主键');

insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) 
values('ARTICLE_INF_NO','1000000','1','1000000','9999999','文章信息表主键');

insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) 
values('CAPITAL_NO','1000000','1','1000000','9999999','资金流水表主键');
insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) 
values('OUTWH_FLOW_NO','100000','1','100000','9999999','资金流水表主键');




insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) 
values('PUB_FILE_RESOURCES_NO','1000000','1','1000000','9999999','文件资源表主键');

insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) 
values('TP_CREDIT_APPLY_NO','1000000','1','1000000','9999999','授信申请表主键');
insert into `sequence` (`SEQ_NAME`, `CURRENT_VAL`, `INCREMENT_VAL`, `MIN_VAL`, `MAX_VAL`, `REMARKS`)
values('APPROVE_BATCH_NO','1000','1','1000','9999999','审核批次号主键');