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','充值规则表主键');
insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS)
values('GAME_RULE_NO','100000','1','100000','9999999999','游戏规则表主键');
/**用户主键*/
insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL)
values('VM_PERSON_INF_NO','10000000','1','1000000000','9999999999');
/**账户主键*/
insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL)
values('VM_ACCOUNT_ID','10000000','1','1000000000','9999999999');

/**订单表主键**/
INSERT INTO sequence(SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL)
VALUES('VM_ORDER_INF_ID','1000000000','1','1000000000','9999999999');

INSERT INTO pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE)
VALUES ('V01_PINGTAI_CLEARING_00', '售货机平台清算规则编号', 'SQ100000001');


/**订单表主键**/
INSERT INTO sequence(SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL)
VALUES('PAY_OS_ID','100000','1','100000','9999999999');

/**信息通知表**/
insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL)
values('PUSH_NEWS_FLOW','10000000','1','10000000','9999999999');

insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL)
values('VM_DELIVERY_INF_ID','10000000','1','10000000','9999999999');