es-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','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 ('attAccelerationType1','service','attAccelerationType', 'MetersPerSecondSquared', 'm/s²','m/s²',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attAccelerationType2','service','attAccelerationType', 'FeetPerSecondSquared', 'ft/s²','ft/s²',2);
-- 面积单位
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attAcreageType1','service','attAcreageType', 'SquareMeter', 'm²','m²',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attAcreageType2','service','attAcreageType', 'SquareMillimeter', 'mm²','mm²',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attAcreageType3','service','attAcreageType', 'SquareCentimeter', 'cm²','cm²',3);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attAcreageType4','service','attAcreageType', 'SquareInches', 'in²','in²',4);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attAcreageType5','service','attAcreageType', 'SquareFoot', 'ft²','ft²',5);
-- 角速度单位
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attAgreeSpeedType1','service','attAgreeSpeedType', 'DegreesPerSecond', 'deg/s','deg/s',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attAgreeSpeedType2','service','attAgreeSpeedType', 'RadiansPerSecond', 'rad/s','rad/s',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attAgreeSpeedType3','service','attAgreeSpeedType', 'RevolutionsPerMinute', 'RPM','RPM',3);
-- 角度单位
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attAgreeType1','service','attAgreeType', 'Radian', 'rad','rad',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attAgreeType2','service','attAgreeType', 'Degree', 'deg','deg',2);
-- 横截面形状
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attCrossSectionalShape1','service','attCrossSectionalShape', '圆形', '0','圆形',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attCrossSectionalShape2','service','attCrossSectionalShape', '正方形', '1','正方形',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attCrossSectionalShape3','service','attCrossSectionalShape', '矩形', '2','矩形',3);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attCrossSectionalShape4','service','attCrossSectionalShape', '六边形', '3','六边形',4);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attCrossSectionalShape5','service','attCrossSectionalShape', '圆环形', '4','圆环形',5);
-- 排量单位
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attDisplacementType1','service','attDisplacementType', 'CubicMeterPerRevolution', 'm³/rev','m³/rev',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attDisplacementType2','service','attDisplacementType', 'LitersPerRevolution', 'L/rev','L/rev',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attDisplacementType3','service','attDisplacementType', 'CubicFeetPerRevolution', 'ft³/rev','ft³/rev',3);
-- 外部换热系数单位
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attExternalHeatTransfer1','service','attExternalHeatTransfer', 'HeatTransfer', 'W/(㎡*K)','W/(㎡*K)',1);
-- 流体类型
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType1','service','attFlowType', 'HELIUM', '0','HELIUM',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType2','service','attFlowType', 'METHANE', '1','METHANE',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType3','service','attFlowType', 'NEON', '2','NEON',3);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType4','service','attFlowType', 'NITROGEN', '3','NITROGEN',4);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType5','service','attFlowType', 'CO', '4','CO',5);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType6','service','attFlowType', 'OXYGEN', '5','OXYGEN',6);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType7','service','attFlowType', 'ARGON', '6','ARGON',7);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType8','service','attFlowType', 'CO2', '7','CO2',8);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType9','service','attFlowType', 'HYDROGEN', '8','HYDROGEN',9);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType10','service','attFlowType', 'PARAHYD', '9','PARAHYD',10);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType11','service','attFlowType', 'WATER', '10','WATER',11);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType12','service','attFlowType', 'RP1', '11','RP-1',12);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType13','service','attFlowType', 'ISOBUTANE', '12','ISOBUTANE',13);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType14','service','attFlowType', 'BUTANE', '13','BUTANE',14);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType15','service','attFlowType', 'D2', '14','D2',15);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType16','service','attFlowType', 'ETHANE', '15','ETHANE',16);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType17','service','attFlowType', 'ETHYLENE', '16','ETHYLENE',17);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType18','service','attFlowType', 'H2S', '17','H2S',18);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType19','service','attFlowType', 'KRYPTON', '18','KRYPTON',19);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType20','service','attFlowType', 'PROPANE', '19','PROPANE',20);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType21','service','attFlowType', 'XENON', '20','XENON',21);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType22','service','attFlowType', 'R11', '21','R11',22);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType23','service','attFlowType', 'R12', '22','R12',23);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType24','service','attFlowType', 'R22', '23','R22',24);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType25','service','attFlowType', 'R32', '24','R32',25);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType26','service','attFlowType', 'R123', '25','R123',26);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType27','service','attFlowType', 'R744', '26','R744',27);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType28','service','attFlowType', 'R124', '27','R124',28);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType29','service','attFlowType', 'R125', '28','R125',29);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType30','service','attFlowType', 'R134A', '29','R134A',30);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType31','service','attFlowType', 'R152A', '30','R152A',31);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType32','service','attFlowType', 'NF3', '31','NF3',32);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType33','service','attFlowType', 'AMMONIA', '32','AMMONIA',33);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType34','service','attFlowType', 'AIR', '33','AIR',34);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType35','service','attFlowType', 'BENZENE', '34','BENZENE',35);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType36','service','attFlowType', 'BUTENE1', '35','1BUTENE',36);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType37','service','attFlowType', 'PENTENE1', '36','1PENTENE',37);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType38','service','attFlowType', 'C1CC6', '37','C1CC6',38);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType39','service','attFlowType', 'C11', '38','C11',39);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType40','service','attFlowType', 'COS', '39','COS',40);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType41','service','attFlowType', 'D2O', '40','D2O',41);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType42','service','attFlowType', 'FLUORINE', '41','FLUORINE',42);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType43','service','attFlowType', 'IBUTENE', '42','IBUTENE',43);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType44','service','attFlowType', 'N2O', '43','N2O',44);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType45','service','attFlowType', 'OCTANE', '44','OCTANE',45);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType46','service','attFlowType', 'R227EA', '45','R227EA',46);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType47','service','attFlowType', 'R1224YDZ', '46','R1224YDZ',47);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType48','service','attFlowType', 'RC318', '47','RC318',48);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType49','service','attFlowType', 'RE143A', '48','RE143A',49);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType50','service','attFlowType', 'TOLUENE', '49','TOLUENE',50);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attFlowType51','service','attFlowType', '防冻液', '50','防冻液',51);
-- 长度单位
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attLengthType1','service','attLengthType', 'mm', '0','毫米',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attLengthType2','service','attLengthType', 'cm', '1','厘米',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attLengthType3','service','attLengthType', 'm', '2','米',3);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attLengthType4','service','attLengthType', 'km', '3','千米',4);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attLengthType5','service','attLengthType', 'ft', '4','英尺',5);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attLengthType6','service','attLengthType', 'in', '5','英寸',6);
-- 列表下拉单位
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attListType1','service','attListType', 'GeneralPump', '0','一般泵',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attListType2','service','attListType', 'Figure9', '1','Figure9.3',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attListType3','service','attListType', 'Fig14', '2','Fig14.33.0.5',3);
-- 质量流量单位
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attMassFlowType1','service','attMassFlowType', 'KgPerSecond', 'kg/s','kg/s',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attMassFlowType2','service','attMassFlowType', 'KgPerMinute', 'kg/min','kg/min',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attMassFlowType3','service','attMassFlowType', 'KgPerHour', 'kg/h','kg/h',3);
-- 材料类型
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attMaterialType1','service','attMaterialType', '铝', '0','铝',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attMaterialType2','service','attMaterialType', '铜', '1','铜',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attMaterialType3','service','attMaterialType', '铁', '2','铁',3);
-- 功率单位
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attPowerType1','service','attPowerType', 'W', '0','W',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attPowerType2','service','attPowerType', 'kW', '1','kW',2);
-- 压力单位
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attPressureType1','service','attPressureType', 'Pa', '0','Pa',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attPressureType2','service','attPressureType', 'kPa', '1','kPa',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attPressureType3','service','attPressureType', 'mBar', '2','mBar',3);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attPressureType4','service','attPressureType', 'bar', '3','bar',4);
-- 重量单位
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attQualityType1','service','attQualityType', 'g', '0','克',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attQualityType2','service','attQualityType', 'kg', '1','千克',2);
-- 热膨胀常数单位
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attTECoefficientType1','service','attTECoefficientType', 'TECoefficient', 'm²/K','m²/K',1);
-- 温度单位
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attTemperatureType1','service','attTemperatureType', 'Celsius', '℃','℃',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attTemperatureType2','service','attTemperatureType', 'Fahrenheit', '℉','℉',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attTemperatureType3','service','attTemperatureType', 'Kaiwen', 'K','K',3);
-- 属性值类型
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);
-- 体积流量单位
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attVolumeFlowType1','service','attVolumeFlowType', 'LiterPerMinute', 'L/min','L/min',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attVolumeFlowType2','service','attVolumeFlowType', 'CubesMeterPerSecond', 'm³/s','m³/s',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attVolumeFlowType3','service','attVolumeFlowType', 'CubicFeetPerSecond', 'ft³/s','ft³/s',3);
-- 体积单位
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attVolumeType1','service','attVolumeType', 'CubicMeter', 'm³','m³',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attVolumeType2','service','attVolumeType', 'CubicMillimeter', 'mm³','mm³',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attVolumeType3','service','attVolumeType', 'CubicCentimeter', 'cm³','cm³',3);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attVolumeType4','service','attVolumeType', 'CubicInches', 'in³','in³',4);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('attVolumeType5','service','attVolumeType', 'CubicFoot', 'ft³','ft³',5);
-- 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 ('ComFType1','service','ComFType', 'fx', '0','飞行环境组件',1);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('ComFType2','service','ComFType', 'gl', '1','管路组件',2);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('ComFType3','service','ComFType', 'hz', '2','换热组件',3);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('ComFType4','service','ComFType', 'fm', '3','阀门组件',4);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('ComFType5','service','ComFType', 'qd', '4','驱动组件',5);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('ComFType6','service','ComFType', 'kz', '5','控制组件',6);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('ComFType7','service','ComFType', 'ry', '6','燃油组件',7);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('ComFType8','service','ComFType', 'xt', '7','系统组件',8);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('ComFType9','service','ComFType', 'gt', '8','其他组件',9);
INSERT INTO SYS_APPCODE(CODE_ID, SYSID, CODE_TYPE, CODE_NAME, CODE_VALUE, CODE_DESC, CODE_ORDER)VALUES ('ComFType10','service','ComFType', 'zdy', '9','用户自定义组件',10);
-- 企业类型
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 ('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 ('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 ('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 ('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 ('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 ('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);