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

insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('操作员状态','IM_USER_STATE','0','ZH_CN','激活','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('操作员状态','IM_USER_STATE','2','ZH_CN','暂时停用','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('操作员状态','IM_USER_STATE','3','ZH_CN','用户停用','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('操作员状态','IM_USER_STATE','4','ZH_CN','永久冻结','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('操作员状态','IM_USER_STATE','5','ZH_CN','注销','EBPP','0');

insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('订单逾期状态','ORDER_OVERDUE_STT','00','ZH_CN','运行中','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('订单逾期状态','ORDER_OVERDUE_STT','01','ZH_CN','已进入宽限期','EBPP','0');


insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('主页','MAIN_PAGE_URL','home/bussinessManage.html','ZH_CN','空主页','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('主页','MAIN_PAGE_URL','main.html','ZH_CN','经理主页','EBPP','2');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('主页','MAIN_PAGE_URL','customerManagerCenter/customerManagerCenter.html','ZH_CN','客户经理主页','EBPP','2');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('主页','MAIN_PAGE_URL','financeManage/financeManage.html','ZH_CN','财务主页','EBPP','2');



insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('收支类型','TRADE_TYPE','00','ZH_CN','收入','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('收支类型','TRADE_TYPE','01','ZH_CN','支出','EBPP','0');
insert into `pub_apppar` (`APR_NAME`, `APR_CODE`, `APR_VALUE`, `APR_LANGUAGE`, `APR_SHOWMSG`, `APR_TYPE`, `APR_MFLAG`) 
values('审批状态','APPROVE_AUTH_STT','00','ZH_CN','风控审批','EBPP','0');
insert into `pub_apppar` (`APR_NAME`, `APR_CODE`, `APR_VALUE`, `APR_LANGUAGE`, `APR_SHOWMSG`, `APR_TYPE`, `APR_MFLAG`) 
values('审批状态','APPROVE_AUTH_STT','01','ZH_CN','风控经理审批','EBPP','0');
insert into `pub_apppar` (`APR_NAME`, `APR_CODE`, `APR_VALUE`, `APR_LANGUAGE`, `APR_SHOWMSG`, `APR_TYPE`, `APR_MFLAG`) 
values('审批状态','APPROVE_AUTH_STT','02','ZH_CN','风控总监审批','EBPP','0');
insert into `pub_apppar` (`APR_NAME`, `APR_CODE`, `APR_VALUE`, `APR_LANGUAGE`, `APR_SHOWMSG`, `APR_TYPE`, `APR_MFLAG`) 
values('审批状态','APPROVE_AUTH_STT','03','ZH_CN','财务审批','EBPP','0');
insert into `pub_apppar` (`APR_NAME`, `APR_CODE`, `APR_VALUE`, `APR_LANGUAGE`, `APR_SHOWMSG`, `APR_TYPE`, `APR_MFLAG`) 
values('审批状态','APPROVE_AUTH_STT','04','ZH_CN','分管领导审批','EBPP','0');
insert into `pub_apppar` (`APR_NAME`, `APR_CODE`, `APR_VALUE`, `APR_LANGUAGE`, `APR_SHOWMSG`, `APR_TYPE`, `APR_MFLAG`) 
values('审批状态','APPROVE_AUTH_STT','05','ZH_CN','总经理审批','EBPP','0');
insert into `pub_apppar` (`APR_NAME`, `APR_CODE`, `APR_VALUE`, `APR_LANGUAGE`, `APR_SHOWMSG`, `APR_TYPE`, `APR_MFLAG`) 
values('审批状态','APPROVE_AUTH_STT','90','ZH_CN','客户经理审批','EBPP','0');


insert into `pub_apppar` (`APR_NAME`, `APR_CODE`, `APR_VALUE`, `APR_LANGUAGE`, `APR_SHOWMSG`, `APR_TYPE`, `APR_MFLAG`) 
values('审批结果','APPROVE_AUTH_RESULT','0','ZH_CN','通过','EBPP','0');
insert into `pub_apppar` (`APR_NAME`, `APR_CODE`, `APR_VALUE`, `APR_LANGUAGE`, `APR_SHOWMSG`, `APR_TYPE`, `APR_MFLAG`) 
values('审批结果','APPROVE_AUTH_RESULT','1','ZH_CN','拒绝','EBPP','0');

insert into `pub_apppar` (`APR_NAME`, `APR_CODE`, `APR_VALUE`, `APR_LANGUAGE`, `APR_SHOWMSG`, `APR_TYPE`, `APR_MFLAG`) 
values('操作类型','OPERATION_TYPE','00','ZH_CN','款项确认','EBPP','0');
insert into `pub_apppar` (`APR_NAME`, `APR_CODE`, `APR_VALUE`, `APR_LANGUAGE`, `APR_SHOWMSG`, `APR_TYPE`, `APR_MFLAG`) 
values('操作类型','OPERATION_TYPE','01','ZH_CN','款项登记','EBPP','0');

INSERT INTO `pub_apppar` (`APR_NAME`, `APR_CODE`, `APR_VALUE`, `APR_LANGUAGE`, `APR_SHOWMSG`, `APR_TYPE`, `APR_MFLAG`) 
VALUES('是否为客户经理','IS_SUSTOMER_MANAGER','00','ZH_CN','否','EBPP','0');
INSERT INTO `pub_apppar` (`APR_NAME`, `APR_CODE`, `APR_VALUE`, `APR_LANGUAGE`, `APR_SHOWMSG`, `APR_TYPE`, `APR_MFLAG`) 
VALUES('是否为客户经理','IS_SUSTOMER_MANAGER','01','ZH_CN','是','EBPP','0');




INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('币种','CURRENCY_TYPE','00','ZH_CN','美元','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('币种','CURRENCY_TYPE','01','ZH_CN','欧元','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('币种','CURRENCY_TYPE','02','ZH_CN','英镑','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('币种','CURRENCY_TYPE','03','ZH_CN','泰铢','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('币种','CURRENCY_TYPE','04','ZH_CN','港币','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('币种','CURRENCY_TYPE','05','ZH_CN','韩元','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('币种','CURRENCY_TYPE','06','ZH_CN','日元','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('币种','CURRENCY_TYPE','07','ZH_CN','卢布','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('币种','CURRENCY_TYPE','08','ZH_CN','人民币','EBPP','0');

INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('游戏规则状态','GAME_SETUP_STATE','0','ZH_CN','启用','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('游戏规则状态','GAME_SETUP_STATE','1','ZH_CN','停用','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('游戏规则状态','GAME_SETUP_STATE','2','ZH_CN','删除','EBPP','0');

INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('游戏类型','GAME_SETUP_TYPE','00','ZH_CN','直接购买','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('游戏类型','GAME_SETUP_TYPE','01','ZH_CN','幸运购','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('游戏类型','GAME_SETUP_TYPE','02','ZH_CN','游戏购','EBPP','0');

INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('游戏类型','GAME_EQU_TYPE','01','ZH_CN','幸运购','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('游戏类型','GAME_EQU_TYPE','02','ZH_CN','游戏购','EBPP','0');

INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('是否中奖','IS_DRAW','00','ZH_CN','未中奖','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('是否中奖','IS_DRAW','01','ZH_CN','中奖','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('是否中奖','IS_DRAW','02','ZH_CN','直接购买','EBPP','0');

INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('支付方式','PAY_TYPE','00','ZH_CN','微信','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('支付方式','PAY_TYPE','01','ZH_CN','支付宝','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('支付方式','PAY_TYPE','02','ZH_CN','余额','EBPP','0');

INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('支付方式','PAY_MODE','91','ZH_CN','微信','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('支付方式','PAY_MODE','92','ZH_CN','支付宝','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('支付方式','PAY_MODE','93','ZH_CN','余额','EBPP','0');
#订单状态
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('订单状态','ORDER_STATE','80','ZH_CN','已重新支付','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('订单状态','ORDER_STATE','90','ZH_CN','已取消','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('订单状态','ORDER_STATE','91','ZH_CN','未支付','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('订单状态','ORDER_STATE','92','ZH_CN','支付中','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('订单状态','ORDER_STATE','00','ZH_CN','已支付','EBPP','0');
#取货状态
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('取货状态','ORDER_PICKUP_STT','00','ZH_CN','未取货','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('取货状态','ORDER_PICKUP_STT','01','ZH_CN','已取货','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('取货状态','ORDER_PICKUP_STT','02','ZH_CN','废弃','EBPP','0');

#商品类型
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('商品类型','PRO_TYPE','00','ZH_CN','正常商品','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('商品类型','PRO_TYPE','01','ZH_CN','抽奖商品','EBPP','0');

#操作员角色
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('操作员角色','USER_ROLE','00','ZH_CN','补货员','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('操作员角色','USER_ROLE','01','ZH_CN','电机检测员','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('操作员角色','USER_ROLE','02','ZH_CN','核账员','EBPP','0');


#用户状态
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('用户状态','PERSON_STATE','00','ZH_CN','正常','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('用户状态','PERSON_STATE','01','ZH_CN','冻结','EBPP','0');

#汇联账户类型01:网商 02:随行付 08:汇付天下 09:合利宝
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('汇联账户类型','BUSINESSNUM_TYPE','01','ZH_CN','网商','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('汇联账户类型','BUSINESSNUM_TYPE','02','ZH_CN','随行付','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('汇联账户类型','BUSINESSNUM_TYPE','08','ZH_CN','汇付天下','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('汇联账户类型','BUSINESSNUM_TYPE','09','ZH_CN','合利宝','EBPP','0');

INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('购买方式','GAME_RULE','0','ZH_CN','幸运购','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('购买方式','GAME_RULE','1','ZH_CN','游戏购','EBPP','0');
INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES
('购买方式','GAME_RULE','2','ZH_CN','直接购买','EBPP','0');


insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('订单状态','PAY_STATE','91','ZH_CN','未支付','EBPP','0');
insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values
('订单状态','PAY_STATE','00','ZH_CN','已支付','EBPP','0');