-- 以下为生成的标准数据的初始化文件,再次生成将覆盖
DELETE FROM SYS_APPCODE;
-- 线性代数库种类
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('algebraicLibraryType1','service','algebraicLibraryType', 'gesdd', '0','gesdd',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('algebraicLibraryType2','service','algebraicLibraryType', 'gesvd', '1','gesvd',2);
-- 申请状态
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('applyState1','service','applyState', 'commit', '0','提交',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('applyState2','service','applyState', 'upchain', '3','已上链',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('applyState3','service','applyState', 'legalLetter', '4','已出函',3);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('applyState4','service','applyState', 'notarization', '5','已出证',4);
-- 属性值类型
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attValueType1','service','attValueType', 'v0', '0','固定值',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attValueType2','service','attValueType', 'v1', '1','下拉值',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attValueType3','service','attValueType', 'v2', '2','输入',3);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attValueType4','service','attValueType', 'v3', '3','子数组',4);
-- Bool类型
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('booltype1','service','booltype', 'yes', '1','是',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('booltype2','service','booltype', 'no', '0','否',2);
-- 实名认证状态
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('certificationState1','service','certificationState', 'certificated', '2','已实名认证',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('certificationState2','service','certificationState', 'certificating', '1','实名认证中',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('certificationState3','service','certificationState', 'noCertificate', '0','未实名认证',3);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('certificationState4','service','certificationState', 'rejectCertificate', '3','认证未通过',4);
-- 实名认证类型
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('certificationType1','service','certificationType', 'person', '0','个人',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('certificationType2','service','certificationType', 'company', '1','企业',2);
-- 企业类型
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('companyType1','service','companyType', 'limitedLiabilityCompanies', '0','有限责任公司',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('companyType2','service','companyType', 'jointStockCompanies', '1','股份有限公司',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('companyType3','service','companyType', 'partnershipEnterprise', '2','合伙企业',3);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('companyType4','service','companyType', 'individualBusiness', '3','个体工商户',4);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('companyType5','service','companyType', 'soleProprietorship', '4','个人独资公司',5);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('companyType6','service','companyType', 'wholePeople', '5','全民所有制',6);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('companyType7','service','companyType', 'collectiveOwnership', '6','集体所有制',7);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('companyType8','service','companyType', 'jointlyOperated', '7','联营企业',8);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('companyType9','service','companyType', 'administrativeUnit', '8','行政单位',9);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('companyType10','service','companyType', 'socialGroup', '9','社会团体',10);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('companyType11','service','companyType', 'publicInstitutions', '10','事业单位',11);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('companyType12','service','companyType', 'liquidatingGroup', '11','破产清算组',12);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('companyType13','service','companyType', 'foreignEnterprise', '12','外国企业',13);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('companyType14','service','companyType', 'goverment', '13','政府',14);
-- 组件类型
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('ComType1','service','ComType', 'CST', '0','cst组件',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('ComType2','service','ComType', 'XFOIL', '1','xfoil组件',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('ComType3','service','ComType', 'FFD', '2','ffd组件',3);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('ComType4','service','ComType', 'ADFLOW', '3','adflow组件',4);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('ComType5','service','ComType', 'MathFunc', '4','MathFunc组件',5);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('ComType6','service','ComType', 'TACS', '5','TACS组件',6);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('ComType7','service','ComType', 'FSI', '6','FSI组件',7);
-- 文件类型
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('fileType1','service','fileType', 'audio', '1','录音',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('fileType2','service','fileType', 'image', '2','照片',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('fileType3','service','fileType', 'video', '3','录像',3);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('fileType4','service','fileType', 'callRecord', '4','通话录音',4);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('fileType5','service','fileType', 'screenShort', '5','屏幕截图',5);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('fileType6','service','fileType', 'screenRecord', '6','屏幕录像',6);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('fileType7','service','fileType', 'other', '100','其它',7);
-- 梯度求解种类
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('gradientSolvingType1','service','gradientSolvingType', 'snopt_fd', '0','snopt_fd',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('gradientSolvingType2','service','gradientSolvingType', 'openmdao', '1','openmdao',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('gradientSolvingType3','service','gradientSolvingType', 'pyopt_fd', '2','pyopt_fd',3);
-- 证件类型
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('idType1','service','idType', 'id', '0','居民身份证',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('idType2','service','idType', 'officialCard', '1','军官证',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('idType3','service','idType', 'passport', '2','护照',3);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('idType4','service','idType', 'passesForTaiwan', '3','台湾居民来往大陆通行证',4);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('idType5','service','idType', 'soldierCard', '4','士兵证',5);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('idType6','service','idType', 'residence', '5','户口',6);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('idType7','service','idType', 'passesForHongkong', '6','港澳居民来往内地通行证',7);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('idType8','service','idType', 'foreignPassport', '8','外国护照',8);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('idType9','service','idType', 'passesToTaiwan', '9','大陆居民往来台湾通行证',9);
-- 企业证件类型
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('idTypeCompany1','service','idTypeCompany', 'businessLicense', '0','营业执照',1);
-- 插值种类
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('interpolantType1','service','interpolantType', 'linear', '0','线性',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('interpolantType2','service','interpolantType', 'radialBasisFunction', '1','RBF',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('interpolantType3','service','interpolantType', 'weighting', '2','加权',3);
-- 开票状态
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('invoiceState1','service','invoiceState', 'noInvoice', '0','未开票',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('invoiceState2','service','invoiceState', 'invoicing', '1','开票中',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('invoiceState3','service','invoiceState', 'invoiced', '2','已开票',3);
-- 余额明细类型
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('issetpaypasswordtype1','service','issetpaypasswordtype', 'notsetpaaypassword', '0','未设置支付密码',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('issetpaypasswordtype2','service','issetpaypasswordtype', 'hassetpassword', '1','已设置支付密码',2);
-- 判断大小种类
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('judgeType1','service','judgeType', 'equals', '0','=',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('judgeType2','service','judgeType', 'upper', '1','<',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('judgeType3','service','judgeType', 'lower', '1','>',3);
-- 登录状态
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('loginflag1','service','loginflag', 'sucess', '0','成功',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('loginflag2','service','loginflag', 'fail', '1','失败',2);
-- 登录渠道
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('loginMedia1','service','loginMedia', 'APP', '0','APP',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('loginMedia2','service','loginMedia', 'WEB', '1','WEB',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('loginMedia3','service','loginMedia', 'MANAGEWEB', '2','MANAGEWEB',3);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('loginMedia4','service','loginMedia', 'DATAWEB', '3','DATAWEB',4);
-- 登录类型
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('loginType1','service','loginType', 'PASSWD', '0','密码登录',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('loginType2','service','loginType', 'VERIFYCODE', '1','验证码登录',2);
-- 登录方式
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('loginWay1','service','loginWay', 'MANUAL', '0','手动登录',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('loginWay2','service','loginWay', 'AUTO', '1','自动登录',2);
-- 消息通道
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('messageChannel1','service','messageChannel', 'phone', '1','手机',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('messageChannel2','service','messageChannel', 'email', '2','邮箱',2);
-- 公证申请状态
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('notarizationApplyStatus1','service','notarizationApplyStatus', 'commit', '1','申请中',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('notarizationApplyStatus2','service','notarizationApplyStatus', 'success', '2','申请成功',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('notarizationApplyStatus3','service','notarizationApplyStatus', 'partSucc', '3','部分成功',3);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('notarizationApplyStatus4','service','notarizationApplyStatus', 'fail', '4','申请失败',4);
-- 公证类型
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('notarizationType1','service','notarizationType', 'legalLetter', '0','存证函',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('notarizationType2','service','notarizationType', 'notarization', '1','公证书',2);
-- 优化类型
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('optimizerIlk1','service','optimizerIlk', 'ALPSO', '0','ALPSO',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('optimizerIlk2','service','optimizerIlk', 'NSGA2', '1','NSGA2',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('optimizerIlk3','service','optimizerIlk', 'SLSQP', '2','SLSQP',3);
-- 优化方法种类
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('optimizerMethodType1','service','optimizerMethodType', 'SLSQP', '0','SLSQP',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('optimizerMethodType2','service','optimizerMethodType', 'CG', '1','CG',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('optimizerMethodType3','service','optimizerMethodType', 'BFGS', '2','BFGS',3);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('optimizerMethodType4','service','optimizerMethodType', 'Powell', '3','Powell',4);
-- 选择优化器种类
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('optimizerType1','service','optimizerType', 'ScipyOptimizeDriver', '0','ScipyOptimizeDriver',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('optimizerType2','service','optimizerType', 'pyOptSparseDriver', '1','pyOptSparseDriver',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('optimizerType3','service','optimizerType', 'DifferentialEvolutionDriver', '2','DifferentialEvolutionDriver',3);
-- 订单状态
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('orderStatus1','service','orderStatus', 'apply', '3','提交订单',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('orderStatus2','service','orderStatus', 'cancel', '4','取消订单',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('orderStatus3','service','orderStatus', 'finish', '12','完成',3);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('orderStatus4','service','orderStatus', 'close', '13','关闭订单',4);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('orderStatus5','service','orderStatus', 'timeout', '14','订单超时',5);
-- 支付渠道
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('payserverchannel1','service','payserverchannel', 'wechat', '0','微信',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('payserverchannel2','service','payserverchannel', 'alipay', '1','支付宝',2);
-- 支付状态
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('paystatus1','service','paystatus', 'orderfail', '0','下单失败',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('paystatus2','service','paystatus', 'ordersuccess', '1','下单成功',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('paystatus3','service','paystatus', 'payfail', '2','支付失败',3);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('paystatus4','service','paystatus', 'paysuccess', '3','支付成功',4);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('paystatus5','service','paystatus', 'refund', '4','退款中',5);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('paystatus6','service','paystatus', 'refundfail', '5','退款失败',6);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('paystatus7','service','paystatus', 'refundsuccess', '6','退款成功',7);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('paystatus8','service','paystatus', 'closed', '7','支付关闭',8);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('paystatus9','service','paystatus', 'timeout', '8','支付超时',9);
-- 支付类型
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('payType1','service','payType', 'wechatpay', '0','微信',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('payType2','service','payType', 'alipay', '2','支付宝',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('payType3','service','payType', 'wechatpayApp', '11','微信APP支付',3);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('payType4','service','payType', 'alipayApp', '12','支付宝APP支付',4);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('payType5','service','payType', 'wechatpayProgram', '21','微信小程序支付',5);
-- 积分订单状态
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('pointOrderState1','service','pointOrderState', 'commit', '1','提交',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('pointOrderState2','service','pointOrderState', 'success', '2','成功',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('pointOrderState3','service','pointOrderState', 'fail', '3','失败',3);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('pointOrderState4','service','pointOrderState', 'timeout', '4','超时',4);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('pointOrderState5','service','pointOrderState', 'noneed', '5','无需处理',5);
-- 积分类型
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('pointType1','service','pointType', 'charge', '1','积分充值',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('pointType2','service','pointType', 'consume_addsubcount', '2','积分消费-增加子账户上限',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('pointType3','service','pointType', 'bonus', '3','积分赠送',3);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('pointType4','service','pointType', 'consume_buyres', '4','积分消费-购买资源',4);
-- 支付介质
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('priceMedia1','service','priceMedia', 'point', '1','积分',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('priceMedia2','service','priceMedia', 'RMB', '2','人民币',2);
-- 处理类型
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('processing1','service','processing', 'pre', 'pre','前处理',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('processing2','service','processing', 'post', 'post','后处理',2);
-- 补寄发票状态
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('reissueInvoiceState1','service','reissueInvoiceState', 'reissueInvoicing', '1','补寄中',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('reissueInvoiceState2','service','reissueInvoiceState', 'reissueInvoiced', '2','已补寄',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('reissueInvoiceState3','service','reissueInvoiceState', 'reissueInvoiceFail', '3','补寄失败',3);
-- 角色类型
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('roleType1','service','roleType', 'admin', 'admin','管理员',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('roleType2','service','roleType', 'normal', 'normal','普通用户',2);
-- 采样方法种类
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('samplingMethod1','service','samplingMethod', 'LatinHypercubeGenerator', '0','拉丁超立方',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('samplingMethod2','service','samplingMethod', 'BoxBehnkenGenerator', '1','BoxBehnken',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('samplingMethod3','service','samplingMethod', 'PlackettBurmanGenerator', '2','PlackettBurman',3);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('samplingMethod4','service','samplingMethod', 'FullFactorialGenerator', '3','全因子设计',4);
-- 选择模型种类
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('selectModel1','service','selectModel', 'KrigingSurrogate', '0','Kriging',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('selectModel2','service','selectModel', 'NearestNeighbor', '1','最近邻',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('selectModel3','service','selectModel', 'ResponseSurface', '2','响应面',3);
-- 性别
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('sexType1','service','sexType', 'man', '1','男',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('sexType2','service','sexType', 'woman', '0','女',2);
-- 开关种类
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('swithType1','service','swithType', 'off', '0','off',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('swithType2','service','swithType', 'on', '1','on',2);
-- 系统分类
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('systemClass1','service','systemClass', 'manager', 'manager','内管系统',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('systemClass2','service','systemClass', 'service', 'service','服务系统',2);
-- 定时器启用状态
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('timmerEnabled1','service','timmerEnabled', 'DISABLE', '0','未启用',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('timmerEnabled2','service','timmerEnabled', 'ENABLE', '1','启用',2);
-- 定时器运行模式
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('timmerRunMode1','service','timmerRunMode', 'SINGLETON', '0','单例',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('timmerRunMode2','service','timmerRunMode', 'MULTITON', '1','多例',2);
-- 运行状态
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('timmerRunstate1','service','timmerRunstate', 'STOP', '0','非运行',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('timmerRunstate2','service','timmerRunstate', 'RUN', '1','运行',2);
-- 通讯方向
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('transflag1','service','transflag', 'up', '01','上行',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('transflag2','service','transflag', 'down', '02','下行',2);
-- 上链状态
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('upchainState1','service','upchainState', 'noupchain', '0','未上链',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('upchainState2','service','upchainState', 'upchaining', '1','上链中',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('upchainState3','service','upchainState', 'upchained', '2','已上链',3);
-- 验证方式
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('userDnType1','service','userDnType', 'normal', '0','通用验证',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('userDnType2','service','userDnType', 'dn', '1','使用dn信息验证',2);
-- 用户状态
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('userState1','service','userState', 'black', '0','黑名单',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('userState2','service','userState', 'normal', '1','正常',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('userState3','service','userState', 'delete', '3','删除',3);
-- 用户类型
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('userType1','service','userType', 'main', '0','主账户',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('userType2','service','userType', 'son', '1','子账户',2);
