use `base-platform`; -- ---------------------------- -- 站点部门窗口参数 SQL -- ---------------------------- INSERT INTO `mortals_xhx_param` VALUES (null, '红旗窗口 ', 'Window', 'hongqi', '1', '是', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '红旗窗口 ', 'Window', 'hongqi', '0', '否', 1, 4, 0, NULL, NULL, NULL, NULL); -- ---------------------------- -- 站点业务参数 SQL -- ---------------------------- INSERT INTO `mortals_xhx_param` VALUES (null, '业务类型', 'Business', 'isBusiness', '0', '一级业务', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '业务类型', 'Business', 'isBusiness', '1', '二级业务', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '是否允许预约', 'Business', 'canorder', '1', '允许', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '是否允许预约', 'Business', 'canorder', '0', '不允许', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '是否允许取号', 'Business', 'cantake', '1', '允许', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '是否允许取号', 'Business', 'cantake', '0', '不允许', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '大厅情况展示 ', 'Business', 'datashow', '1', '展示', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '大厅情况展示 ', 'Business', 'datashow', '0', '不展示', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '类型', 'Business', 'businessType', '0', '一体化业务', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '类型', 'Business', 'businessType', '1', '自建业务', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '业务状态 ', 'Business', 'status', '0', '停用', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '业务状态 ', 'Business', 'status', '1', '正常', 1, 4, 0, NULL, NULL, NULL, NULL); -- ---------------------------- -- 业务事项关联参数 SQL -- ---------------------------- -- ---------------------------- -- 部门参数 SQL -- ---------------------------- INSERT INTO `mortals_xhx_param` VALUES (null, '填单机展示 ', 'Dept', 'isAutotable', '0', '否', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '填单机展示 ', 'Dept', 'isAutotable', '1', '是', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '预约展示 ', 'Dept', 'isOrder', '0', '否', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '预约展示 ', 'Dept', 'isOrder', '1', '是', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '背靠背展示 ', 'Dept', 'isBkb', '0', '否', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '背靠背展示 ', 'Dept', 'isBkb', '1', '是', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '办事指南展示 ', 'Dept', 'isWorkGuide', '0', '否', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '办事指南展示 ', 'Dept', 'isWorkGuide', '1', '是', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '是否使用 ', 'Dept', 'usValid', '0', '否', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '是否使用 ', 'Dept', 'usValid', '1', '是', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '部门电话是否展示 ', 'Dept', 'isSecphone', '0', '否', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '部门电话是否展示 ', 'Dept', 'isSecphone', '1', '是', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '是否展示英文 ', 'Dept', 'isEnglish', '0', '否', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '是否展示英文 ', 'Dept', 'isEnglish', '1', '是', 1, 4, 0, NULL, NULL, NULL, NULL); -- ---------------------------- -- 节假日参数 SQL -- ---------------------------- -- ---------------------------- -- 基础事项参数 SQL -- ---------------------------- INSERT INTO `mortals_xhx_param` VALUES (null, '服务对象 ', 'Matter', 'appoveObjectShow', '1', '事业法人', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '服务对象 ', 'Matter', 'appoveObjectShow', '2', '社会组织法人', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '服务对象 ', 'Matter', 'appoveObjectShow', '3', '非法人企业', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '服务对象 ', 'Matter', 'appoveObjectShow', '4', '企业法人', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '服务对象 ', 'Matter', 'appoveObjectShow', '5', '自然人', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '服务对象 ', 'Matter', 'appoveObjectShow', '6', '其他组织', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '通办范围 ', 'Matter', 'operatScopeShow', '1', '无', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '通办范围 ', 'Matter', 'operatScopeShow', '2', '全国', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '通办范围 ', 'Matter', 'operatScopeShow', '3', '全省', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '通办范围 ', 'Matter', 'operatScopeShow', '4', '全市', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '通办范围 ', 'Matter', 'operatScopeShow', '5', '全县', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '通办范围 ', 'Matter', 'operatScopeShow', '6', '全镇[乡 街道]', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '通办范围 ', 'Matter', 'operatScopeShow', '7', '跨村[社区]', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '办件类型', 'Matter', 'appoveTimeLimitShow', '1', '网络办件', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '办件类型', 'Matter', 'appoveTimeLimitShow', '2', '行政审批一般件', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '办件类型', 'Matter', 'appoveTimeLimitShow', '3', '综合窗口件', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '办理形式', 'Matter', 'handleType', '1', '窗口办理', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '办理形式', 'Matter', 'handleType', '2', '网上办理', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '是否收费', 'Matter', 'isChargesShow', '0', '否', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '是否收费', 'Matter', 'isChargesShow', '1', '是', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '认证等级需求', 'Matter', 'certificationLevelsShow', '1', '实名认证', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '认证等级需求', 'Matter', 'certificationLevelsShow', '2', '单次面签', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '认证等级需求', 'Matter', 'certificationLevelsShow', '3', '每次面签', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '是否网上预约,窗口办理选', 'Matter', 'isOnlineSubscribeShow', '0', '否', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '是否网上预约,窗口办理选', 'Matter', 'isOnlineSubscribeShow', '1', '是', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '物流快递,窗口办理选', 'Matter', 'isExpressTakeShow', '0', '否', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '物流快递,窗口办理选', 'Matter', 'isExpressTakeShow', '1', '是', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '是否支持全省范围就近取件', 'Matter', 'isProvinceAcquisitionShow', '0', '否', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '是否支持全省范围就近取件', 'Matter', 'isProvinceAcquisitionShow', '1', '是', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '是否支持全省范围就近办理', 'Matter', 'isApplyProvinceShow', '0', '否', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '是否支持全省范围就近办理', 'Matter', 'isApplyProvinceShow', '1', '是', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '网办类型', 'Matter', 'onlineType', '1', '原件预审', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '网办类型', 'Matter', 'onlineType', '2', '原件核验', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '网办类型', 'Matter', 'onlineType', '3', '全程网办', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '网络办理深度', 'Matter', 'onlineOperatDeep', '1', '互联网咨询', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '网络办理深度', 'Matter', 'onlineOperatDeep', '2', '互联网收件', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '网络办理深度', 'Matter', 'onlineOperatDeep', '3', '互联网预审', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '网络办理深度', 'Matter', 'onlineOperatDeep', '4', '互联网受理', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '网络办理深度', 'Matter', 'onlineOperatDeep', '5', '互联网办理', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '网络办理深度', 'Matter', 'onlineOperatDeep', '6', '互联网办理结果信息反馈', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '网络办理深度', 'Matter', 'onlineOperatDeep', '7', '其他', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '物流快递，网上办理选', 'Matter', 'isExpressTakeOnlineShow', '0', '否', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '物流快递，网上办理选', 'Matter', 'isExpressTakeOnlineShow', '1', '是', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '是否支持上门收取申请', 'Matter', 'isDoorTakeShow', '0', '否', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '是否支持上门收取申请', 'Matter', 'isDoorTakeShow', '1', '是', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '事项类型名称', 'Matter', 'eventTypeShow', '1A', '行政许可', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '事项类型名称', 'Matter', 'eventTypeShow', '1B', '行政处罚', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '事项类型名称', 'Matter', 'eventTypeShow', '1C', '行政强制', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '事项类型名称', 'Matter', 'eventTypeShow', '1D', '行政征收', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '事项类型名称', 'Matter', 'eventTypeShow', '1G', '行政给付', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '事项类型名称', 'Matter', 'eventTypeShow', '1I', '行政检查', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '事项类型名称', 'Matter', 'eventTypeShow', '1F', '行政确认', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '事项类型名称', 'Matter', 'eventTypeShow', '1H', '行政奖励', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '事项类型名称', 'Matter', 'eventTypeShow', '1E', '行政裁决', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '事项类型名称', 'Matter', 'eventTypeShow', '1Z', '其他行政权力', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '事项类型名称', 'Matter', 'eventTypeShow', '2A', '主动服务', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '事项类型名称', 'Matter', 'eventTypeShow', '2B', '依申请服务', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '事项类型名称', 'Matter', 'eventTypeShow', '2C', '咨询查询', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '事项类型名称', 'Matter', 'eventTypeShow', '3A', '未归类事项', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '行使层级名称', 'Matter', 'performHierarchyShow', '1', '省级', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '行使层级名称', 'Matter', 'performHierarchyShow', '2', '市级', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '行使层级名称', 'Matter', 'performHierarchyShow', '3', '县级', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '行使层级名称', 'Matter', 'performHierarchyShow', '4', '镇[乡，街道]', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '行使层级名称', 'Matter', 'performHierarchyShow', '5', '村[社区]级', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '权力来源', 'Matter', 'powerSourceShow', '1', '法定本级行使', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '权力来源', 'Matter', 'powerSourceShow', '2', '上级下放', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '权力来源', 'Matter', 'powerSourceShow', '3', '上级授权', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '权力来源', 'Matter', 'powerSourceShow', '4', '同级授权', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '权力来源', 'Matter', 'powerSourceShow', '5', '上级委托', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '权力来源', 'Matter', 'powerSourceShow', '6', '同级委托', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '实施主体性质', 'Matter', 'performDeptTypeShow', '1', '法定机关', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '实施主体性质', 'Matter', 'performDeptTypeShow', '2', '授权组织', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '实施主体性质', 'Matter', 'performDeptTypeShow', '3', '受委托组织', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '是否进驻中心', 'Matter', 'goveServiceCenterShow', '0', '否', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '是否进驻中心', 'Matter', 'goveServiceCenterShow', '1', '是', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '是否纳入便民服务中心', 'Matter', 'isConvenientCenterShow', '0', '否', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '是否纳入便民服务中心', 'Matter', 'isConvenientCenterShow', '1', '是', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '自助终端办理 ', 'Matter', 'terminalHandle', '0', '否', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '自助终端办理 ', 'Matter', 'terminalHandle', '1', '是', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '是否网办 ', 'Matter', 'isOnline', '0', '否', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '是否网办 ', 'Matter', 'isOnline', '1', '是', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '支持网上支付', 'Matter', 'isOnlinePayShow', '0', '否', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '支持网上支付', 'Matter', 'isOnlinePayShow', '1', '是', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '委托部门', 'Matter', 'entrustmentDepartmen', '0', '否', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '委托部门', 'Matter', 'entrustmentDepartmen', '1', '是', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '事项状态', 'Matter', 'matterStatus', '0', '停用', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '事项状态', 'Matter', 'matterStatus', '1', '在用', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '主题类型', 'Matter', 'type', '1', '法定机关', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '主题类型', 'Matter', 'type', '2', '授权组织', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '主题类型', 'Matter', 'type', '3', '受委托组织', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '是否样表展示', 'Matter', 'mattertype', '0', '否', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '是否样表展示', 'Matter', 'mattertype', '1', '是', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '事项来源', 'Matter', 'source', '0', '政务网', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '事项来源', 'Matter', 'source', '1', '自定义', 1, 4, 0, NULL, NULL, NULL, NULL); -- ---------------------------- -- 事项受理条件参数 SQL -- ---------------------------- INSERT INTO `mortals_xhx_param` VALUES (null, '事项来源 ', 'MatterAccept', 'source', '0', '政务网', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '事项来源 ', 'MatterAccept', 'source', '1', '自定义', 1, 4, 0, NULL, NULL, NULL, NULL); -- ---------------------------- -- 事项收费标准参数 SQL -- ---------------------------- INSERT INTO `mortals_xhx_param` VALUES (null, '事项来源，', 'MatterCharges', 'source', '0', '政务网', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '事项来源，', 'MatterCharges', 'source', '1', '自定义', 1, 4, 0, NULL, NULL, NULL, NULL); -- ---------------------------- -- 事项申请材料参数 SQL -- ---------------------------- INSERT INTO `mortals_xhx_param` VALUES (null, '必交性', 'MatterDatum', 'isMust', '1', '非必要', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '必交性', 'MatterDatum', 'isMust', '2', '必要', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '必交性', 'MatterDatum', 'isMust', '3', '必要|容缺后补', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '必交性', 'MatterDatum', 'isMust', '4', '非必要|容缺后补', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '材料形式', 'MatterDatum', 'materialProperty', '1', '纸质', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '材料形式', 'MatterDatum', 'materialProperty', '2', '电子', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '材料形式', 'MatterDatum', 'materialProperty', '3', '纸质|电子', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '电子材料格式', 'MatterDatum', 'electronicgs', '1', '无', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '电子材料格式', 'MatterDatum', 'electronicgs', '2', '不限', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '电子材料格式', 'MatterDatum', 'electronicgs', '3', 'jpg', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '电子材料格式', 'MatterDatum', 'electronicgs', '4', 'jpeg', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '电子材料格式', 'MatterDatum', 'electronicgs', '5', 'pdf', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '电子材料格式', 'MatterDatum', 'electronicgs', '6', 'word', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '电子材料格式', 'MatterDatum', 'electronicgs', '7', 'pdf,jpg,jpeg', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '电子材料格式', 'MatterDatum', 'electronicgs', '8', 'pdf,jpg', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '材料来源渠道', 'MatterDatum', 'materialSource', '1', '无', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '材料来源渠道', 'MatterDatum', 'materialSource', '2', '申请人自备', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '材料来源渠道', 'MatterDatum', 'materialSource', '3', '政府部门核发', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '材料来源渠道', 'MatterDatum', 'materialSource', '4', '其他', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '减免模式', 'MatterDatum', 'jianmMs', '1', '无', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '减免模式', 'MatterDatum', 'jianmMs', '2', '减', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '减免模式', 'MatterDatum', 'jianmMs', '3', '免', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '是否减免', 'MatterDatum', 'isjianm', '0', '否', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '是否减免', 'MatterDatum', 'isjianm', '1', '是', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '材料是否容缺', 'MatterDatum', 'isLack', '1', '必要', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '材料是否容缺', 'MatterDatum', 'isLack', '2', '非必要', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '事项来源', 'MatterDatum', 'source', '0', '政务网', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '事项来源', 'MatterDatum', 'source', '1', '自定义', 1, 4, 0, NULL, NULL, NULL, NULL); -- ---------------------------- -- 材料附件参数 SQL -- ---------------------------- INSERT INTO `mortals_xhx_param` VALUES (null, '附件类型 ', 'MatterDatumFile', 'filetype', '1', '示例样表', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '附件类型 ', 'MatterDatumFile', 'filetype', '2', '空白表格', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '附件来源 ', 'MatterDatumFile', 'source', '0', '政务网', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '附件来源 ', 'MatterDatumFile', 'source', '1', '自定义', 1, 4, 0, NULL, NULL, NULL, NULL); -- ---------------------------- -- 事项办理流程参数 SQL -- ---------------------------- INSERT INTO `mortals_xhx_param` VALUES (null, '事项来源', 'MatterFlowlimit', 'source', '0', '政务网', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '事项来源', 'MatterFlowlimit', 'source', '1', '自定义', 1, 4, 0, NULL, NULL, NULL, NULL); -- ---------------------------- -- 事项中介服务参数 SQL -- ---------------------------- INSERT INTO `mortals_xhx_param` VALUES (null, '事项来源，', 'MatterIntermediary', 'source', '0', '政务网', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '事项来源，', 'MatterIntermediary', 'source', '1', '自定义', 1, 4, 0, NULL, NULL, NULL, NULL); -- ---------------------------- -- 事项常见问题参数 SQL -- ---------------------------- INSERT INTO `mortals_xhx_param` VALUES (null, '事项来源，', 'MatterQuestion', 'source', '0', '政务网', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '事项来源，', 'MatterQuestion', 'source', '1', '自定义', 1, 4, 0, NULL, NULL, NULL, NULL); -- ---------------------------- -- 事项设定依据参数 SQL -- ---------------------------- INSERT INTO `mortals_xhx_param` VALUES (null, '法规类型，', 'MatterSetbase', 'policyType', '1', '法律', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '法规类型，', 'MatterSetbase', 'policyType', '2', '行政法规', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '法规类型，', 'MatterSetbase', 'policyType', '3', '地方法规', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '法规类型，', 'MatterSetbase', 'policyType', '4', '部门规章', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '法规类型，', 'MatterSetbase', 'policyType', '5', '其他', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '法规类型，', 'MatterSetbase', 'policyType', '6', '政府规章', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '法规类型，', 'MatterSetbase', 'policyType', '7', '规范性文件', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '事项来源，', 'MatterSetbase', 'source', '0', '政务网', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '事项来源，', 'MatterSetbase', 'source', '1', '自定义', 1, 4, 0, NULL, NULL, NULL, NULL); -- ---------------------------- -- 模块参数 SQL -- ---------------------------- -- ---------------------------- -- 站点事项参数 SQL -- ---------------------------- -- ---------------------------- -- 站点模块参数 SQL -- ---------------------------- -- ---------------------------- -- 短信设置参数 SQL -- ---------------------------- INSERT INTO `mortals_xhx_param` VALUES (null, '短信开关 ', 'SmsSet', 'messageoff', '1', '开', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '短信开关 ', 'SmsSet', 'messageoff', '0', '关', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '短信平台 ', 'SmsSet', 'smsplatform', '1', '容联', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '短信平台 ', 'SmsSet', 'smsplatform', '2', '阿里云', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '短信平台 ', 'SmsSet', 'smsplatform', '3', '移动', 1, 4, 0, NULL, NULL, NULL, NULL); -- ---------------------------- -- 短信模板参数 SQL -- ---------------------------- INSERT INTO `mortals_xhx_param` VALUES (null, '模板选择 ', 'SmsTemplate', 'type', '1', '预约成功短信', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '模板选择 ', 'SmsTemplate', 'type', '2', '取号成功短信', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '模板选择 ', 'SmsTemplate', 'type', '3', '临近叫号短信', 1, 4, 0, NULL, NULL, NULL, NULL); -- ---------------------------- -- 窗口业务参数 SQL -- ---------------------------- -- ---------------------------- -- 窗口事项参数 SQL -- ---------------------------- -- ---------------------------- -- 工作人员参数 SQL -- ---------------------------- INSERT INTO `mortals_xhx_param` VALUES (null, '政治面貌 ', 'Workman', 'politicalstatus', '0', '中共党员', 1, 4, 0, 'politicalstatus', NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '政治面貌 ', 'Workman', 'politicalstatus', '1', '中共预备党员', 1, 4, 0, 'politicalstatus', NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '政治面貌 ', 'Workman', 'politicalstatus', '2', '共青团员', 1, 4, 0, 'politicalstatus', NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '政治面貌 ', 'Workman', 'politicalstatus', '3', '普通居民', 1, 4, 0, 'politicalstatus', NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '政治面貌 ', 'Workman', 'politicalstatus', '4', '其它', 1, 4, 0, 'politicalstatus', NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '党员 ', 'Workman', 'dangyuan', '0', '非党员', 1, 4, 0, 'dangyuan', NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '党员 ', 'Workman', 'dangyuan', '1', '党员', 1, 4, 0, 'dangyuan', NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '党员 ', 'Workman', 'dangyuan', '2', '党员示范岗', 1, 4, 0, 'dangyuan', NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '党员 ', 'Workman', 'dangyuan', '3', '党员先锋岗', 1, 4, 0, 'dangyuan', NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '党员 ', 'Workman', 'dangyuan', '99', '其它', 1, 4, 0, 'dangyuan', NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '是否在线', 'Workman', 'online', '0', '离线', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '是否在线', 'Workman', 'online', '1', '在线', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '是否在线', 'Workman', 'online', '2', '暂离', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '是否在线', 'Workman', 'online', '3', '点击暂离', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '是否在线', 'Workman', 'online', '4', '回归', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '是否在线', 'Workman', 'online', '5', '登陆', 1, 4, 0, NULL, NULL, NULL, NULL); -- ---------------------------- -- 站点参数 SQL -- ---------------------------- INSERT INTO `mortals_xhx_param` VALUES (null, '是否有下级', 'Site', 'haveSonArea', '0', '否', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '是否有下级', 'Site', 'haveSonArea', '1', '是', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '周一 ', 'Site', 'workday1', '1', '上班', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '周一 ', 'Site', 'workday1', '0', '不上', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '周二 ', 'Site', 'workday2', '1', '上班', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '周二 ', 'Site', 'workday2', '0', '不上', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '周三 ', 'Site', 'workday3', '1', '上班', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '周三 ', 'Site', 'workday3', '0', '不上', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '周四 ', 'Site', 'workday4', '1', '上班', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '周四 ', 'Site', 'workday4', '0', '不上', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '周五 ', 'Site', 'workday5', '1', '上班', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '周五 ', 'Site', 'workday5', '0', '不上', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '周六 ', 'Site', 'workday6', '1', '上班', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '周六 ', 'Site', 'workday6', '0', '不上', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '周日 ', 'Site', 'workday7', '1', '上班', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '周日 ', 'Site', 'workday7', '0', '不上', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '是否是站点 ', 'Site', 'isSite', '1', '是', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '是否是站点 ', 'Site', 'isSite', '0', '否', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '站点状态 ', 'Site', 'status', '0', '停用', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '站点状态 ', 'Site', 'status', '1', '正常', 1, 4, 0, NULL, NULL, NULL, NULL); -- ---------------------------- -- 区域参数 SQL -- ---------------------------- INSERT INTO `mortals_xhx_param` VALUES (null, '是否有下级区域', 'Area', 'haveSonArea', 'True', '是', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '是否有下级区域', 'Area', 'haveSonArea', 'False', '否', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '是否有下级部门', 'Area', 'haveSonDept', 'True', '是', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '是否有下级部门', 'Area', 'haveSonDept', 'False', '否', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '是否获取部门', 'Area', 'haveGetDept', 'true', '是', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '是否获取部门', 'Area', 'haveGetDept', 'false', '否', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '是否获取事项列表', 'Area', 'haveGetMatterList', 'true', '是', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '是否获取事项列表', 'Area', 'haveGetMatterList', 'false', '否', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '区域等级', 'Area', 'areaLevel', '1', '省', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '区域等级', 'Area', 'areaLevel', '2', '地市州', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '区域等级', 'Area', 'areaLevel', '3', '区县', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '区域等级', 'Area', 'areaLevel', '4', '街道', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '区域等级', 'Area', 'areaLevel', '5', '社区', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '区域状态', 'Area', 'status', '0', '停用', 1, 4, 0, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '区域状态', 'Area', 'status', '1', '正常', 1, 4, 0, NULL, NULL, NULL, NULL); -- ---------------------------- -- 系统基础皮肤参数 SQL -- ---------------------------- INSERT INTO `mortals_xhx_param` VALUES (null, '设备类型 ', 'SkinBase', 'deviceType', 'pdj', '排号机', 1, 4, 0, 'deviceType', NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '设备类型 ', 'SkinBase', 'deviceType', 'ckp', '窗口屏', 1, 4, 0, 'deviceType', NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '设备类型 ', 'SkinBase', 'deviceType', 'hjq', '呼叫器', 1, 4, 0, 'deviceType', NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '设备类型 ', 'SkinBase', 'deviceType', 'jzxsp', '集中显示屏', 1, 4, 0, 'deviceType', NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '设备类型 ', 'SkinBase', 'deviceType', 'dsj', '导视机', 1, 4, 0, 'deviceType', NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '设备类型 ', 'SkinBase', 'deviceType', 'pjq', '评级器', 1, 4, 0, 'deviceType', NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '设备类型 ', 'SkinBase', 'deviceType', 'zzfwzd', '自助服务终端', 1, 4, 0, 'deviceType', NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '设备类型 ', 'SkinBase', 'deviceType', 'tdj', '填单机', 1, 4, 0, 'deviceType', NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '设备类型 ', 'SkinBase', 'deviceType', 'ybj', '样表机', 1, 4, 0, 'deviceType', NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '分辨率 ', 'SkinBase', 'imageResolution', '1', '1920*1080', 1, 4, 0, 'imageResolution', NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '分辨率 ', 'SkinBase', 'imageResolution', '2', '1080*1920', 1, 4, 0, 'imageResolution', NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '分辨率 ', 'SkinBase', 'imageResolution', '3', '1280*1280', 1, 4, 0, 'imageResolution', NULL, NULL, NULL); -- ---------------------------- -- 皮肤属性字段配置参数 SQL -- ---------------------------- INSERT INTO `mortals_xhx_param` VALUES (null, '数据类型', 'SkinField', 'fieldType', '1', '颜色', 1, 4, 0, 'fieldType', NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '数据类型', 'SkinField', 'fieldType', '2', '图片地址', 1, 4, 0, 'fieldType', NULL, NULL, NULL); -- ---------------------------- -- 产品初始 SQL -- ---------------------------- INSERT INTO `mortals_xhx_product` VALUES (null, '排号机', 'pdj', '排号机', 1, now(), NULL, NULL); INSERT INTO `mortals_xhx_product` VALUES (null, '窗口屏', 'ckp', '窗口屏', 1, now(), NULL, NULL); INSERT INTO `mortals_xhx_product` VALUES (null, '呼叫器', 'hjq', '呼叫器', 1, now(), NULL, NULL); INSERT INTO `mortals_xhx_product` VALUES (null, '集中显示屏', 'jzxsp', '集中显示屏', 1, now(), NULL, NULL); INSERT INTO `mortals_xhx_product` VALUES (null, '导视机', 'dsj', '导视机', 1, now(), NULL, NULL); INSERT INTO `mortals_xhx_product` VALUES (null, '评价器', 'pjq', '评价器', 1, now(), NULL, NULL); INSERT INTO `mortals_xhx_product` VALUES (null, '自助服务终端', 'zzfwzd', '自助服务终端', 1, now(), NULL, NULL); INSERT INTO `mortals_xhx_product` VALUES (null, '填单机', 'tdj', '填单机', 1, now(), NULL, NULL); INSERT INTO `mortals_xhx_product` VALUES (null, '样表机', 'ybj', '样表机', 1, now(), NULL, NULL); INSERT INTO `mortals_sys_model` VALUES (null, '基础设置平台', 'basic setting ', 'file/fileupload/1672810627756.svg', 'http://192.168.0.98:11071/#/jump', '基础设置平台-test', 1, '2022-04-20 09:55:59', 1, '2023-01-04 13:37:09'); INSERT INTO `mortals_xhx_task` VALUES (null, '用户同步', 'syncUserTask', 0, 'SyncUserTask', NULL, NULL, 4, 120, '00', NULL, '127.0.1.1', '2023-01-13 15:41:40', 0, '2022-07-06 10:49:48', 1, '系统管理员'); INSERT INTO `mortals_xhx_param` VALUES (null, 'domain', null, null, 'domain', 'http://192.168.0.98:11071', '1', '4', '0', null, null, null, null); INSERT INTO `mortals_xhx_param` VALUES (null, 'php访问地址', null, null, 'server_http_url', 'http://192.168.0.98:11078', '1', '4', '0', null, null, null, null); INSERT INTO `mortals_xhx_param` VALUES (null, 'php访问地址', null, null, 'server_php_http_url', 'http://192.168.0.98:8090', '1', '4', '0', null, null, null, null);