#系统通用 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'); insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL) values('VM_ACCOUNT_DETAIL_ID','10000000','1','10000000','9999999999');