adi-manager-server/dbscript/init/generate/01-appcodeInit.sql

-- 以下为生成的标准数据的初始化文件,再次生成将覆盖
DELETE FROM SYS_APPCODE;
-- 申请状态
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('applyState1','manager','applyState', 'commit', '0','提交',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('applyState2','manager','applyState', 'pay', '1','支付',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('applyState3','manager','applyState', 'auditor', '2','审核',3);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('applyState4','manager','applyState', 'upchain', '3','上链',4);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('applyState5','manager','applyState', 'success', '4','完成',5);
-- 上链状态
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('artifactStatus1','manager','artifactStatus', 'prepare', '0','未上链',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('artifactStatus2','manager','artifactStatus', 'success', '1','已上链',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('artifactStatus3','manager','artifactStatus', 'uncomfirmeds', '2','待确认',3);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('artifactStatus4','manager','artifactStatus', 'fail', '3','上链失败',4);
-- 审核类型
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('auditorType1','manager','auditorType', 'pass', '1','通过',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('auditorType2','manager','auditorType', 'reject', '2','驳回',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('auditorType3','manager','auditorType', 'refuse', '3','拒绝受理',3);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('auditorType4','manager','auditorType', 'wait', '4','等待受理',4);
-- Bool类型
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('boolType1','manager','boolType', 'yes', '1','是',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('boolType2','manager','boolType', 'no', '0','否',2);
-- 实名认证状态
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('certificationState1','manager','certificationState', 'certificated', '1','已实名认证',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('certificationState2','manager','certificationState', 'certificating', '2','实名认证中',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('certificationState3','manager','certificationState', 'noCertificate', '0','未实名认证',3);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('certificationState4','manager','certificationState', 'rejectCertificate', '3','实名认证未通过',4);
-- 实名认证类型
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('certificationType1','manager','certificationType', 'person', '0','个人',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('certificationType2','manager','certificationType', 'company', '1','企业',2);
-- 审核状态
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('checkstate1','manager','checkstate', 'type1', '0','未审核',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('checkstate2','manager','checkstate', 'type2', '1','审核中',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('checkstate3','manager','checkstate', 'type3', '2','审核不通过',3);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('checkstate4','manager','checkstate', 'type4', '3','审核通过',4);
-- 支付渠道
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('depositchannel1','manager','depositchannel', 'none', '00','现金支付',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('depositchannel2','manager','depositchannel', 'wechat', '01','微信',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('depositchannel3','manager','depositchannel', 'unionpay', '03','银联',3);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('depositchannel4','manager','depositchannel', 'all', 'all','全部',4);
-- 文件类型
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('fileType1','manager','fileType', 'header', '1','头像',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('fileType2','manager','fileType', 'picValidate', '2','图像验证码',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('fileType3','manager','fileType', 'generic', '3','通用文件',3);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('fileType4','manager','fileType', 'backGround', '101','背景文件',4);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('fileType5','manager','fileType', 'content', '102','内容图片',5);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('fileType6','manager','fileType', 'certifacation', '201','认证图片',6);
-- 证件类型
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('idType1','manager','idType', 'id', '0','居民身份证',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('idType2','manager','idType', 'officialCard', '1','军官证',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('idType3','manager','idType', 'busBusinessLicense', '2','企业法人营业执照',3);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('idType4','manager','idType', 'orgCode', '3','组织机构代码证',4);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('idType5','manager','idType', 'legalPerson', '4','事业单位法人证书',5);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('idType6','manager','idType', 'corporations', '5','社团法人证书',6);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('idType7','manager','idType', 'businessLicense', '6','营业执照',7);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('idType8','manager','idType', 'legalEntity', '7','机关法人证书',8);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('idType9','manager','idType', 'socialCreditCode', '8','统一社会信用代码证书',9);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('idType10','manager','idType', 'other', '9','其他有效证件',10);
-- 是否开票状态
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('invoiceStatate1','manager','invoiceStatate', 'unInvoiced', '0','未开票',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('invoiceStatate2','manager','invoiceStatate', 'invoiced', '1','已开票',2);
-- 发票抬头类型
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('invoiceTitleType1','manager','invoiceTitleType', 'person', '1','个人',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('invoiceTitleType2','manager','invoiceTitleType', 'org', '2','组织',2);
-- 登录状态
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('loginflag1','manager','loginflag', 'sucess', '0','成功',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('loginflag2','manager','loginflag', 'fail', '1','失败',2);
-- 订单状态
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('orderStatus1','manager','orderStatus', 'apply', '3','提交订单',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('orderStatus2','manager','orderStatus', 'cancel', '4','取消订单',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('orderStatus3','manager','orderStatus', 'paying', '5','支付下单',3);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('orderStatus4','manager','orderStatus', 'ordered', '6','下单成功',4);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('orderStatus5','manager','orderStatus', 'print', '7','打印订单',5);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('orderStatus6','manager','orderStatus', 'stockOut', '8','已出库',6);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('orderStatus7','manager','orderStatus', 'stockOutSuccess', '9','完成出库',7);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('orderStatus8','manager','orderStatus', 'deliver', '10','配送中',8);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('orderStatus9','manager','orderStatus', 'arrive', '11','到达',9);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('orderStatus10','manager','orderStatus', 'finish', '12','完成',10);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('orderStatus11','manager','orderStatus', 'close', '13','关闭订单',11);
-- 订单类型
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('orderType1','manager','orderType', 'auditor', '1','审核费用',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('orderType2','manager','orderType', 'post', '2','邮费',2);
-- 支付状态
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('paystatus1','manager','paystatus', 'orderfail', '0','下单失败',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('paystatus2','manager','paystatus', 'ordersuccess', '1','下单成功',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('paystatus3','manager','paystatus', 'payfail', '2','支付失败',3);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('paystatus4','manager','paystatus', 'paysuccess', '3','支付成功',4);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('paystatus5','manager','paystatus', 'refund', '4','退款中',5);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('paystatus6','manager','paystatus', 'refundfail', '5','退款失败',6);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('paystatus7','manager','paystatus', 'refundsuccess', '6','退款成功',7);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('paystatus8','manager','paystatus', 'closed', '7','订单关闭',8);
-- 支付类型
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('payType1','manager','payType', 'wechatpay', '0','微信',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('payType2','manager','payType', 'alipay', '2','支付宝',2);
-- 角色类型
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('roleType1','manager','roleType', 'boss', '1','老板',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('roleType2','manager','roleType', 'warehouse', '2','库管',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('roleType3','manager','roleType', 'storemanager', '3','店长',3);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('roleType4','manager','roleType', 'purchase', '4','采购',4);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('roleType5','manager','roleType', 'cook', '5','厨师',5);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('roleType6','manager','roleType', 'other', '6','其他',6);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('roleType7','manager','roleType', 'all', '7','全部',7);
-- 性别
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('sexType1','manager','sexType', 'male', '1','男',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('sexType2','manager','sexType', 'female', '2','女',2);
-- 短信验证类型
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('smsType1','manager','smsType', 'changetel', '0','更改电话',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('smsType2','manager','smsType', 'register', '1','注册',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('smsType3','manager','smsType', 'forget', '2','忘记密码',3);
-- 系统分类
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('systemClass1','manager','systemClass', 'manager', 'manager','内管系统',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('systemClass2','manager','systemClass', 'service', 'service','服务系统',2);
-- 定时器启用状态
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('timmerEnabled1','manager','timmerEnabled', 'DISABLE', '0','未启用',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('timmerEnabled2','manager','timmerEnabled', 'ENABLE', '1','启用',2);
-- 定时器运行模式
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('timmerRunMode1','manager','timmerRunMode', 'SINGLETON', '0','单例',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('timmerRunMode2','manager','timmerRunMode', 'MULTITON', '1','多例',2);
-- 运行状态
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('timmerRunstate1','manager','timmerRunstate', 'STOP', '0','非运行',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('timmerRunstate2','manager','timmerRunstate', 'RUN', '1','运行',2);
-- 通讯方向
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('transflag1','manager','transflag', 'up', '01','上行',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('transflag2','manager','transflag', 'down', '02','下行',2);
-- 上链状态
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('upChainState1','manager','upChainState', 'fail', '0','失败',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('upChainState2','manager','upChainState', 'success', '1','成功',2);
-- 用户审核状态
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('userState1','manager','userState', 'pending', '0','待审核',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('userState2','manager','userState', 'pass', '1','已通过',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('userState3','manager','userState', 'refuse', '2','未通过',3);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('userState4','manager','userState', 'blacklist', '3','黑名单',4);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('userState5','manager','userState', 'all', '4','全部',5);
-- 用户类型
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('userType1','manager','userType', 'sysuser', '1','系统用户',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('userType2','manager','userType', 'normaluser', '0','普通用户',2);
-- 版本类型
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('versionType1','manager','versionType', 'win', 'xi-win-client','公证链客户端-Windows版',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('versionType2','manager','versionType', 'app', 'hlad-win-verify','华龙艾迪-验证工具-Windows版',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('versionType3','manager','versionType', 'mac', 'xi-mac-client','公证链客户端-Mac版',3);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('versionType4','manager','versionType', 'app1', 'xi-win-verify','小犀智能-验证工具-Windows版',4);