/* Navicat Premium Data Transfer Source Server : 106.14.167.185-woopaytest Source Server Type : MySQL Source Server Version : 80027 Source Host : 106.14.167.185:3306 Source Schema : sun_allocation Target Server Type : MySQL Target Server Version : 80027 File Encoding : 65001 Date: 13/06/2022 16:17:38 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for com_param -- ---------------------------- DROP TABLE IF EXISTS `com_param`; CREATE TABLE `com_param` ( `sun_key` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '键', `val` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '值', `remark` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间', PRIMARY KEY (`sun_key`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of com_param -- ---------------------------- INSERT INTO `com_param` VALUES ('expire_time', '90', '密码过期时间（单位：天）', '2019-04-16 16:12:06'); -- ---------------------------- -- Table structure for core_department -- ---------------------------- DROP TABLE IF EXISTS `core_department`; CREATE TABLE `core_department` ( `id` int(0) NOT NULL AUTO_INCREMENT, `name` char(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '部门名称', `level` int(0) NULL DEFAULT NULL COMMENT '级别', `note` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '注释', `parent_id` int(0) NULL DEFAULT NULL COMMENT '父id', `api_call_times` int(0) NULL DEFAULT 1000000 COMMENT '该用户可调用次数', `api_expire_time` int(0) NULL DEFAULT 300 COMMENT '一段时间允许的调用量(秒)', `api_type` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '1' COMMENT '用户类型（1-白名单，2-灰名单，3-黑名单）', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `name_uq`(`name`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 46 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '部门表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of core_department -- ---------------------------- INSERT INTO `core_department` VALUES (1, 'sunyard', 1, '内部', NULL, 1000000, 299, '1'); -- ---------------------------- -- Table structure for core_function -- ---------------------------- DROP TABLE IF EXISTS `core_function`; CREATE TABLE `core_function` ( `id` int(0) NOT NULL AUTO_INCREMENT, `name` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '功能模块名称', `super_id` int(0) NULL DEFAULT NULL COMMENT '父级id', `grade` int(0) NULL DEFAULT 0 COMMENT '级别', `icon` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图标', `path` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '路径', `component` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '组件', `function_type` int(0) NULL DEFAULT 0 COMMENT '组件类型（0-菜单，1-按钮）', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uq_path`(`path`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1207 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '功能模块表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of core_function -- ---------------------------- INSERT INTO `core_function` VALUES (2, '首页', 1, 2, NULL, '/search/home', 'Home', 0); INSERT INTO `core_function` VALUES (3, '查询', 1, 2, NULL, '/search/information', 'Information', 0); INSERT INTO `core_function` VALUES (4, '查询列表', 1, 2, NULL, '/search/searchList', 'SearchList', 0); INSERT INTO `core_function` VALUES (6, '接口管理', 5, 2, NULL, '/dataSource/apiList', 'ApiList', 0); INSERT INTO `core_function` VALUES (7, '字段管理', 5, 2, NULL, '/dataSource/keyList', 'KeyList', 0); INSERT INTO `core_function` VALUES (9, '黑名单管理', 8, 2, NULL, '/list/blackList', 'BlackList', 0); INSERT INTO `core_function` VALUES (10, '白名单管理', 8, 2, NULL, '/list/whiteList', 'WhiteList', 0); INSERT INTO `core_function` VALUES (11, '名单配置', 8, 2, NULL, '/list/listConfig', 'ListConfig', 0); INSERT INTO `core_function` VALUES (15, '规则管理', 16, 2, NULL, '/rules/rule', 'Rules', 0); INSERT INTO `core_function` VALUES (28, '模型参数配置', 27, 2, NULL, '/model/modelList', 'ModalList', 0); INSERT INTO `core_function` VALUES (29, '模型字段配置', 27, 2, NULL, '/model/myModel', 'MyModal', 0); INSERT INTO `core_function` VALUES (31, '数据源管理', 5, 2, 'hdd', '/dataSource/dataManagement', 'DataManagement', 0); INSERT INTO `core_function` VALUES (41, '衍生方法', 5, 2, NULL, '/dataSource/MethodList', 'MethodList', 0); INSERT INTO `core_function` VALUES (42, '自定义方法', 5, 2, NULL, '/dataSource/ruleClass/methods', 'ruleClassMethods', 0); INSERT INTO `core_function` VALUES (46, '运营大屏', 145, 2, NULL, '/report/operation/screen', 'Screen', 0); INSERT INTO `core_function` VALUES (47, '评分稳定性', 145, 2, NULL, '/report/rating/stability', 'Stability', 0); INSERT INTO `core_function` VALUES (48, '模型通过率', 145, 2, NULL, '/report/model/pass/rate', 'Rate', 0); INSERT INTO `core_function` VALUES (117, '模型使用报表', 145, 2, NULL, '/report/modleUsing', 'ModleUsing', 0); INSERT INTO `core_function` VALUES (118, '外部数据报表', 145, 2, NULL, '/report/apiUsing', 'ApiUsing', 0); INSERT INTO `core_function` VALUES (119, '决策项通过率', 116, 2, NULL, '/statistical/decision', 'Decision', 0); INSERT INTO `core_function` VALUES (120, '评分参数分析', 116, 2, NULL, '/statistical/keysStatis', 'KeysStatis', 0); INSERT INTO `core_function` VALUES (121, '模型对比分析', 116, 2, NULL, '/statistical/modelComparison', 'ModelComparison', 0); INSERT INTO `core_function` VALUES (133, '统计大屏', 145, 2, NULL, '/report/display', 'Display', 0); INSERT INTO `core_function` VALUES (134, '节点对比分析', 116, 2, NULL, '/statistical/nodeComparison', 'NodeComparison', 0); INSERT INTO `core_function` VALUES (135, '评分卡对比分析', 116, 2, NULL, '/statistical/scoreCardCompare', 'ScoreCardCompare', 0); INSERT INTO `core_function` VALUES (136, '决策集对比分析', 116, 2, NULL, '/statistical/decisionListCompare', 'DecisionListCompare', 0); INSERT INTO `core_function` VALUES (137, '决策树对比分析', 116, 2, NULL, '/statistical/decisionTreeCompare', 'DecisionTreeCompare', 0); INSERT INTO `core_function` VALUES (138, '决策表对比分析', 116, 2, NULL, '/statistical/decisionTableCompare', 'DecisionTableCompare', 0); INSERT INTO `core_function` VALUES (139, '添加标签', 116, 2, NULL, '/statistical/addLabel', 'AddLabel', 0); INSERT INTO `core_function` VALUES (140, '标签跑批', 116, 2, NULL, '/statistical/runLabel', 'RunLabel', 0); INSERT INTO `core_function` VALUES (922, '系统管理', 0, 1, 'laptop', '/system', NULL, 0); INSERT INTO `core_function` VALUES (923, '机构管理', 922, 2, NULL, '/system/organization', 'Organization', 0); INSERT INTO `core_function` VALUES (924, '账户管理', 922, 2, NULL, '/system/user', 'UserManagement', 0); INSERT INTO `core_function` VALUES (925, '角色管理', 922, 2, NULL, '/system/role', 'RoleManagement', 0); INSERT INTO `core_function` VALUES (926, '权限管理', 922, 2, NULL, '/system/authority', 'Authority', 0); INSERT INTO `core_function` VALUES (930, '日志管理', 922, 2, NULL, '/system/log', 'Log', 0); INSERT INTO `core_function` VALUES (931, '评分区间分布', 145, 2, NULL, '/report/score/interval/distribution', 'Distribution', 0); INSERT INTO `core_function` VALUES (933, '规则命中监控', 145, 2, NULL, '/report/score/interval/accuracy', 'Accuracy', 0); INSERT INTO `core_function` VALUES (934, '特征稳定性', 145, 2, NULL, '/report/rating/chara', 'Chara', 0); INSERT INTO `core_function` VALUES (935, '拒绝原因分布', 145, 2, NULL, '/report/score/interval/distribute', 'Distribute', 0); INSERT INTO `core_function` VALUES (936, '规则命中统计', 145, 2, NULL, '/report/score/interval/statistics', 'Statistics', 0); INSERT INTO `core_function` VALUES (937, '模型仓库', 16, 2, NULL, '/rules/warehouse', 'Warehouse', 0); INSERT INTO `core_function` VALUES (950, '导出', 4, 3, NULL, NULL, 'search_list_export', 1); INSERT INTO `core_function` VALUES (952, '创建项目', 15, 3, NULL, NULL, 'rule_create_project', 1); INSERT INTO `core_function` VALUES (953, '导入项目', 15, 3, NULL, NULL, 'rule_import_project', 1); INSERT INTO `core_function` VALUES (954, '导出项目备份', 15, 3, NULL, NULL, 'rule_export_project', 1); INSERT INTO `core_function` VALUES (955, '删除项目', 15, 3, NULL, NULL, 'rule_delete_project', 1); INSERT INTO `core_function` VALUES (956, '编辑项目', 15, 3, NULL, NULL, 'rule_editor_project', 1); INSERT INTO `core_function` VALUES (958, '保存知识包', 15, 3, NULL, NULL, 'rule_save_package', 1); INSERT INTO `core_function` VALUES (959, '发布知识包', 15, 3, NULL, NULL, 'rule_issue_package', 1); INSERT INTO `core_function` VALUES (960, '删除知识包', 15, 3, NULL, NULL, 'rule_delete_package', 1); INSERT INTO `core_function` VALUES (961, '编辑知识包', 15, 3, NULL, NULL, 'rule_editor_package', 1); INSERT INTO `core_function` VALUES (962, '下载', 3, 3, NULL, NULL, 'information_download', 1); INSERT INTO `core_function` VALUES (963, '导入', 3, 3, NULL, NULL, 'information_import', 1); INSERT INTO `core_function` VALUES (964, '新增', 6, 3, NULL, NULL, 'api_list_add', 1); INSERT INTO `core_function` VALUES (966, '修改', 6, 3, NULL, NULL, 'api_list_update', 1); INSERT INTO `core_function` VALUES (967, '删除', 6, 3, NULL, NULL, 'api_list_delete', 1); INSERT INTO `core_function` VALUES (968, '新增', 7, 3, NULL, NULL, 'key_list_add', 1); INSERT INTO `core_function` VALUES (969, '修改', 7, 3, NULL, '', 'key_list_update', 1); INSERT INTO `core_function` VALUES (970, '删除', 7, 3, NULL, NULL, 'key_list_delete', 1); INSERT INTO `core_function` VALUES (971, '新增', 31, 3, NULL, NULL, 'data_management_add', 1); INSERT INTO `core_function` VALUES (972, '修改', 31, 3, NULL, NULL, 'data_management_update', 1); INSERT INTO `core_function` VALUES (973, '删除', 31, 3, NULL, NULL, 'data_management_delete', 1); INSERT INTO `core_function` VALUES (974, '新增', 9, 3, NULL, NULL, 'black_list_add', 1); INSERT INTO `core_function` VALUES (975, '修改', 9, 3, NULL, NULL, 'black_list_update', 1); INSERT INTO `core_function` VALUES (977, '删除', 9, 3, NULL, NULL, 'black_list_delete', 1); INSERT INTO `core_function` VALUES (978, '导出', 9, 3, NULL, NULL, 'black_list_export', 1); INSERT INTO `core_function` VALUES (979, '新增名单', 9, 3, NULL, NULL, 'black_list_roll_add', 1); INSERT INTO `core_function` VALUES (980, '修改名单', 9, 3, NULL, NULL, 'black_list_roll_update', 1); INSERT INTO `core_function` VALUES (982, '删除名单', 9, 3, NULL, NULL, 'black_list_roll_delete', 1); INSERT INTO `core_function` VALUES (983, '新增', 10, 3, NULL, NULL, 'white_list_add', 1); INSERT INTO `core_function` VALUES (984, '修改', 10, 3, NULL, NULL, 'white_list_update', 1); INSERT INTO `core_function` VALUES (985, '删除', 10, 3, NULL, NULL, 'white_list_delete', 1); INSERT INTO `core_function` VALUES (986, '导出', 10, 3, NULL, NULL, 'white_list_export', 1); INSERT INTO `core_function` VALUES (987, '新增名单', 10, 3, NULL, NULL, 'white_list_roll_add', 1); INSERT INTO `core_function` VALUES (988, '修改名单', 10, 3, NULL, NULL, 'white_list_roll_update', 1); INSERT INTO `core_function` VALUES (989, '删除名单', 10, 3, NULL, NULL, 'white_list_roll_delete', 1); INSERT INTO `core_function` VALUES (990, '新增', 937, 3, NULL, NULL, 'ware_house_add', 1); INSERT INTO `core_function` VALUES (991, '修改', 937, 3, NULL, NULL, 'ware_house_update', 1); INSERT INTO `core_function` VALUES (992, '删除', 937, 3, NULL, NULL, 'ware_house_delete', 1); INSERT INTO `core_function` VALUES (993, '导入', 937, 3, NULL, NULL, 'ware_house_import', 1); INSERT INTO `core_function` VALUES (994, '编辑', 28, 3, NULL, NULL, 'modal_list_editor', 1); INSERT INTO `core_function` VALUES (995, '提交', 29, 3, NULL, NULL, 'my_modal_submit', 1); INSERT INTO `core_function` VALUES (996, '回测标签', 139, 3, NULL, NULL, 'add_label_back', 1); INSERT INTO `core_function` VALUES (997, '导入标签', 139, 3, NULL, NULL, 'add_label_import', 1); INSERT INTO `core_function` VALUES (998, '导出标签', 139, 3, NULL, NULL, 'add_label_export', 1); INSERT INTO `core_function` VALUES (999, '删除', 139, 3, NULL, NULL, 'add_label_delete', 1); INSERT INTO `core_function` VALUES (1000, '跑批', 140, 3, NULL, NULL, 'run_label_run', 1); INSERT INTO `core_function` VALUES (1001, '跑批操作', 140, 3, NULL, NULL, 'run_label_operation', 1); INSERT INTO `core_function` VALUES (1002, '新增', 923, 3, NULL, NULL, 'organization_add', 1); INSERT INTO `core_function` VALUES (1003, '修改', 923, 3, NULL, NULL, 'organization_update', 1); INSERT INTO `core_function` VALUES (1005, '删除', 923, 3, NULL, NULL, 'organization_delete', 1); INSERT INTO `core_function` VALUES (1006, '通知', 923, 3, NULL, NULL, 'organization_inform', 1); INSERT INTO `core_function` VALUES (1007, '新增', 924, 3, NULL, NULL, 'user_add', 1); INSERT INTO `core_function` VALUES (1008, '修改', 924, 3, NULL, NULL, 'user_update', 1); INSERT INTO `core_function` VALUES (1009, '删除', 924, 3, NULL, NULL, 'user_delete', 1); INSERT INTO `core_function` VALUES (1010, '锁定', 924, 3, NULL, NULL, 'user_lock', 1); INSERT INTO `core_function` VALUES (1011, '解锁', 924, 3, NULL, NULL, 'user_unlock', 1); INSERT INTO `core_function` VALUES (1012, '密码修改', 924, 3, NULL, NULL, 'user_password_update', 1); INSERT INTO `core_function` VALUES (1013, '密码重置', 924, 3, NULL, NULL, 'user_password_reset', 1); INSERT INTO `core_function` VALUES (1016, '新增', 932, 3, NULL, NULL, 'grading_add', 1); INSERT INTO `core_function` VALUES (1017, '修改', 932, 3, NULL, NULL, 'grading_update', 1); INSERT INTO `core_function` VALUES (1018, '删除', 932, 3, NULL, NULL, 'grading_delete', 1); INSERT INTO `core_function` VALUES (1023, '新增', 938, 3, NULL, NULL, 'scense_add', 1); INSERT INTO `core_function` VALUES (1024, '修改', 938, 3, NULL, NULL, 'scense_update', 1); INSERT INTO `core_function` VALUES (1025, '删除', 938, 3, NULL, NULL, 'scense_delete', 1); INSERT INTO `core_function` VALUES (1026, '新增', 925, 3, NULL, NULL, 'role_add', 1); INSERT INTO `core_function` VALUES (1027, '修改', 925, 3, NULL, NULL, 'role_update', 1); INSERT INTO `core_function` VALUES (1028, '删除', 925, 3, NULL, NULL, 'role_delete', 1); INSERT INTO `core_function` VALUES (1031, '新增', 1029, 3, NULL, NULL, 'grading_add', 1); INSERT INTO `core_function` VALUES (1032, '修改', 1029, 3, NULL, NULL, 'grading_update', 1); INSERT INTO `core_function` VALUES (1033, '删除', 1029, 3, NULL, NULL, 'grading_delete', 1); INSERT INTO `core_function` VALUES (1110, 'SQL管理', 5, 2, NULL, '/dataSource/mysql', 'Mysql', 0); INSERT INTO `core_function` VALUES (1111, '启用', 6, 3, NULL, NULL, 'api_list_start', 1); INSERT INTO `core_function` VALUES (1112, '启用', 7, 3, NULL, NULL, 'key_list_start', 1); INSERT INTO `core_function` VALUES (1113, '新增', 1110, 3, NULL, NULL, 'mysql_add', 1); INSERT INTO `core_function` VALUES (1114, '修改', 1110, 3, NULL, NULL, 'mysql_update', 1); INSERT INTO `core_function` VALUES (1115, '删除', 1110, 3, NULL, NULL, 'mysql_delete', 1); INSERT INTO `core_function` VALUES (1116, '出参管理', 1110, 3, NULL, NULL, 'mysql_param', 1); INSERT INTO `core_function` VALUES (1117, 'code编码', 28, 3, NULL, NULL, 'modal_list_code', 1); INSERT INTO `core_function` VALUES (1118, '配置账户', 28, 3, NULL, NULL, 'modal_list_user', 1); INSERT INTO `core_function` VALUES (1119, 'API下载', 28, 3, NULL, NULL, 'modal_list_download', 1); INSERT INTO `core_function` VALUES (1120, '导出', 117, 3, NULL, NULL, 'modal_using_export', 1); INSERT INTO `core_function` VALUES (1121, '导出', 118, 3, NULL, NULL, 'api_using_export', 1); INSERT INTO `core_function` VALUES (1122, '导出', 930, 3, NULL, NULL, 'log_export', 1); INSERT INTO `core_function` VALUES (1123, '新增', 926, 3, NULL, NULL, 'authority_add', 1); INSERT INTO `core_function` VALUES (1124, '修改', 926, 3, NULL, NULL, 'authority_update', 1); INSERT INTO `core_function` VALUES (1125, '删除', 926, 3, NULL, NULL, 'authority_delete', 1); INSERT INTO `core_function` VALUES (1126, '节点管理', 16, 2, NULL, '/rules/nodeManage', 'NodeManage', 0); INSERT INTO `core_function` VALUES (1127, '关系管理', 16, 2, NULL, '/rules/relationManage', 'RelationManage', 0); INSERT INTO `core_function` VALUES (1128, '关系图', 16, 2, NULL, '/rules/diagram', 'Diagram', 0); INSERT INTO `core_function` VALUES (1130, '指标参数管理', 0, 1, NULL, '/indexParameter', NULL, 0); INSERT INTO `core_function` VALUES (1134, '模型指标管理', 1130, 2, NULL, '/indexParameter/modelIndex', NULL, 0); INSERT INTO `core_function` VALUES (1135, '业务方管理', 0, 1, NULL, '/business', NULL, 0); INSERT INTO `core_function` VALUES (1136, '合作商管理', 1135, 2, NULL, '/business/cooperation', NULL, 0); INSERT INTO `core_function` VALUES (1137, '产品管理', 1135, 2, NULL, '/business/product', NULL, 0); INSERT INTO `core_function` VALUES (1138, '产品交易类型管理', 1135, 2, NULL, '/business/productDeal', NULL, 0); INSERT INTO `core_function` VALUES (1139, '模型管理', 1130, 2, NULL, '/indexParameter/model', NULL, 0); INSERT INTO `core_function` VALUES (1143, '关系管理', 0, 1, NULL, '/relation', NULL, 0); INSERT INTO `core_function` VALUES (1144, '产品模型关系管理', 1143, 2, NULL, '/relation/productModel', NULL, 0); INSERT INTO `core_function` VALUES (1145, '新增', 1131, 3, NULL, NULL, 'data_origin_add', 1); INSERT INTO `core_function` VALUES (1148, '修改', 1131, 3, NULL, NULL, 'data_origin_update', 1); INSERT INTO `core_function` VALUES (1149, '删除', 1131, 3, NULL, NULL, 'data_origin_delete', 1); INSERT INTO `core_function` VALUES (1150, '新增', 1133, 3, NULL, NULL, 'way_add', 1); INSERT INTO `core_function` VALUES (1151, '修改', 1133, 3, NULL, NULL, 'way_update', 1); INSERT INTO `core_function` VALUES (1152, '删除', 1133, 3, NULL, NULL, 'way_delete', 1); INSERT INTO `core_function` VALUES (1153, '新增', 1134, 3, NULL, NULL, 'model_index_add', 1); INSERT INTO `core_function` VALUES (1154, '修改', 1134, 3, NULL, NULL, 'model_index_update', 1); INSERT INTO `core_function` VALUES (1155, '删除', 1134, 3, NULL, NULL, 'model_index_delete', 1); INSERT INTO `core_function` VALUES (1156, '新增', 1139, 3, NULL, NULL, 'model_add', 1); INSERT INTO `core_function` VALUES (1157, '修改', 1139, 3, NULL, NULL, 'model_update', 1); INSERT INTO `core_function` VALUES (1158, '删除', 1139, 3, NULL, NULL, 'model_delete', 1); INSERT INTO `core_function` VALUES (1159, '新增', 1140, 3, NULL, NULL, 'port_field_add', 1); INSERT INTO `core_function` VALUES (1160, '修改', 1140, 3, NULL, NULL, 'port_field_update', 1); INSERT INTO `core_function` VALUES (1161, '删除', 1140, 3, NULL, NULL, 'port_field_delete', 1); INSERT INTO `core_function` VALUES (1162, '新增', 1141, 3, NULL, NULL, 'beam_parameter_add', 1); INSERT INTO `core_function` VALUES (1163, '修改', 1141, 3, NULL, NULL, 'beam_parameter_update', 1); INSERT INTO `core_function` VALUES (1164, '删除', 1141, 3, NULL, NULL, 'beam_parameter_delete', 1); INSERT INTO `core_function` VALUES (1165, '新增', 1147, 3, NULL, NULL, 'port_add', 1); INSERT INTO `core_function` VALUES (1166, '修改', 1147, 3, NULL, NULL, 'port_update', 1); INSERT INTO `core_function` VALUES (1167, '删除', 1147, 3, NULL, NULL, 'port_delete', 1); INSERT INTO `core_function` VALUES (1168, '新增', 1136, 3, NULL, NULL, 'cooperation_add', 1); INSERT INTO `core_function` VALUES (1169, '修改', 1136, 3, NULL, NULL, 'cooperation_update', 1); INSERT INTO `core_function` VALUES (1170, '删除', 1136, 3, NULL, NULL, 'cooperation_delete', 1); INSERT INTO `core_function` VALUES (1171, '新增', 1137, 3, NULL, NULL, 'product_add', 1); INSERT INTO `core_function` VALUES (1172, '修改', 1137, 3, NULL, NULL, 'product_update', 1); INSERT INTO `core_function` VALUES (1173, '删除', 1137, 3, NULL, NULL, 'product_delete', 1); INSERT INTO `core_function` VALUES (1174, '新增', 1138, 3, NULL, NULL, 'product_deal_add', 1); INSERT INTO `core_function` VALUES (1175, '修改', 1138, 3, NULL, NULL, 'product_deal_update', 1); INSERT INTO `core_function` VALUES (1176, '删除', 1138, 3, NULL, NULL, 'product_deal_delete', 1); INSERT INTO `core_function` VALUES (1177, '新增', 1144, 3, NULL, NULL, 'product_model_add', 1); INSERT INTO `core_function` VALUES (1178, '修改', 1144, 3, NULL, NULL, 'product_model_update', 1); INSERT INTO `core_function` VALUES (1179, '删除', 1144, 3, NULL, NULL, 'product_model_delete', 1); INSERT INTO `core_function` VALUES (1180, '状态', 1137, 3, NULL, NULL, 'product_status', 1); INSERT INTO `core_function` VALUES (1181, '状态', 1147, 3, NULL, NULL, 'port_status', 1); INSERT INTO `core_function` VALUES (1182, '状态', 1139, 3, NULL, NULL, 'model_status', 1); INSERT INTO `core_function` VALUES (1183, '信息管理', 0, 1, NULL, '/message', NULL, 0); INSERT INTO `core_function` VALUES (1184, '查询记录', 1183, 2, NULL, '/message/query', NULL, 0); INSERT INTO `core_function` VALUES (1185, '数据管理', 0, 1, NULL, '/data', NULL, 0); INSERT INTO `core_function` VALUES (1186, '数据源管理', 1185, 2, NULL, '/data/dataOrigin', NULL, 0); INSERT INTO `core_function` VALUES (1187, '新增', 1186, 3, NULL, NULL, 'data_origin_add', 1); INSERT INTO `core_function` VALUES (1188, '修改', 1186, 3, NULL, NULL, 'data_origin_update', 1); INSERT INTO `core_function` VALUES (1189, '删除', 1186, 3, NULL, NULL, 'data_origin_delete', 1); INSERT INTO `core_function` VALUES (1190, '方法管理', 1185, 2, NULL, '/data/way', '', 0); INSERT INTO `core_function` VALUES (1191, '新增', 1190, 3, NULL, NULL, 'way_add', 1); INSERT INTO `core_function` VALUES (1192, '修改', 1190, 3, NULL, NULL, 'way_update', 1); INSERT INTO `core_function` VALUES (1193, '删除', 1190, 3, NULL, NULL, 'way_delete', 1); INSERT INTO `core_function` VALUES (1194, '接口字段管理', 1185, 2, NULL, '/data/portField', NULL, 0); INSERT INTO `core_function` VALUES (1195, '新增', 1194, 3, NULL, NULL, 'port_field_add', 1); INSERT INTO `core_function` VALUES (1196, '修改', 1194, 3, NULL, NULL, 'port_field_update', 1); INSERT INTO `core_function` VALUES (1197, '删除', 1194, 3, NULL, NULL, 'port_field_delete', 1); INSERT INTO `core_function` VALUES (1198, '上送参数管理', 1185, 2, NULL, '/data/beamParameter', NULL, 0); INSERT INTO `core_function` VALUES (1199, '新增', 1198, 3, NULL, NULL, 'beam_parameter_add', 1); INSERT INTO `core_function` VALUES (1200, '修改', 1198, 3, NULL, NULL, 'beam_parameter_update', 1); INSERT INTO `core_function` VALUES (1201, '删除', 1198, 3, NULL, NULL, 'beam_parameter_delete', 1); INSERT INTO `core_function` VALUES (1202, '接口管理', 1185, 2, NULL, '/data/port', NULL, 0); INSERT INTO `core_function` VALUES (1203, '新增', 1202, 3, NULL, NULL, 'port_add', 1); INSERT INTO `core_function` VALUES (1204, '修改', 1202, 3, NULL, NULL, 'port_update', 1); INSERT INTO `core_function` VALUES (1205, '删除', 1202, 3, NULL, NULL, 'port_delete', 1); INSERT INTO `core_function` VALUES (1206, '状态', 1202, 3, NULL, NULL, 'port_status', 1); -- ---------------------------- -- Table structure for core_function_url -- ---------------------------- DROP TABLE IF EXISTS `core_function_url`; CREATE TABLE `core_function_url` ( `id` int(0) NOT NULL AUTO_INCREMENT, `function_id` int(0) NOT NULL COMMENT '功能模块id', `url_id` int(0) NOT NULL COMMENT '接口地址id', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uq_urlId_functionId`(`url_id`, `function_id`) USING BTREE, INDEX `url限制`(`url_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1107 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '功能模块接口关系表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of core_function_url -- ---------------------------- INSERT INTO `core_function_url` VALUES (1, 2, 3); INSERT INTO `core_function_url` VALUES (428, 3, 4); INSERT INTO `core_function_url` VALUES (45, 11, 4); INSERT INTO `core_function_url` VALUES (652, 29, 4); INSERT INTO `core_function_url` VALUES (431, 3, 5); INSERT INTO `core_function_url` VALUES (429, 3, 6); INSERT INTO `core_function_url` VALUES (430, 3, 7); INSERT INTO `core_function_url` VALUES (650, 28, 7); INSERT INTO `core_function_url` VALUES (654, 29, 7); INSERT INTO `core_function_url` VALUES (432, 4, 8); INSERT INTO `core_function_url` VALUES (476, 9, 8); INSERT INTO `core_function_url` VALUES (481, 10, 8); INSERT INTO `core_function_url` VALUES (647, 28, 8); INSERT INTO `core_function_url` VALUES (434, 4, 9); INSERT INTO `core_function_url` VALUES (265, 950, 10); INSERT INTO `core_function_url` VALUES (433, 4, 11); INSERT INTO `core_function_url` VALUES (437, 6, 12); INSERT INTO `core_function_url` VALUES (266, 964, 13); INSERT INTO `core_function_url` VALUES (267, 966, 13); INSERT INTO `core_function_url` VALUES (297, 1111, 14); INSERT INTO `core_function_url` VALUES (435, 6, 15); INSERT INTO `core_function_url` VALUES (268, 967, 16); INSERT INTO `core_function_url` VALUES (438, 6, 17); INSERT INTO `core_function_url` VALUES (451, 31, 17); INSERT INTO `core_function_url` VALUES (444, 7, 18); INSERT INTO `core_function_url` VALUES (443, 7, 19); INSERT INTO `core_function_url` VALUES (445, 7, 20); INSERT INTO `core_function_url` VALUES (442, 7, 21); INSERT INTO `core_function_url` VALUES (447, 7, 22); INSERT INTO `core_function_url` VALUES (300, 970, 23); INSERT INTO `core_function_url` VALUES (298, 968, 24); INSERT INTO `core_function_url` VALUES (301, 1112, 25); INSERT INTO `core_function_url` VALUES (441, 969, 26); INSERT INTO `core_function_url` VALUES (321, 982, 27); INSERT INTO `core_function_url` VALUES (329, 989, 27); INSERT INTO `core_function_url` VALUES (314, 977, 28); INSERT INTO `core_function_url` VALUES (325, 985, 28); INSERT INTO `core_function_url` VALUES (473, 9, 29); INSERT INTO `core_function_url` VALUES (478, 10, 29); INSERT INTO `core_function_url` VALUES (322, 978, 30); INSERT INTO `core_function_url` VALUES (326, 986, 30); INSERT INTO `core_function_url` VALUES (475, 9, 31); INSERT INTO `core_function_url` VALUES (480, 10, 31); INSERT INTO `core_function_url` VALUES (477, 9, 32); INSERT INTO `core_function_url` VALUES (482, 10, 32); INSERT INTO `core_function_url` VALUES (474, 9, 33); INSERT INTO `core_function_url` VALUES (479, 10, 33); INSERT INTO `core_function_url` VALUES (463, 974, 34); INSERT INTO `core_function_url` VALUES (464, 975, 34); INSERT INTO `core_function_url` VALUES (323, 983, 34); INSERT INTO `core_function_url` VALUES (324, 984, 34); INSERT INTO `core_function_url` VALUES (317, 979, 35); INSERT INTO `core_function_url` VALUES (320, 980, 35); INSERT INTO `core_function_url` VALUES (327, 987, 35); INSERT INTO `core_function_url` VALUES (328, 988, 35); INSERT INTO `core_function_url` VALUES (46, 11, 36); INSERT INTO `core_function_url` VALUES (47, 11, 37); INSERT INTO `core_function_url` VALUES (48, 11, 38); INSERT INTO `core_function_url` VALUES (624, 15, 39); INSERT INTO `core_function_url` VALUES (557, 117, 40); INSERT INTO `core_function_url` VALUES (555, 117, 41); INSERT INTO `core_function_url` VALUES (347, 1120, 42); INSERT INTO `core_function_url` VALUES (559, 117, 43); INSERT INTO `core_function_url` VALUES (558, 117, 44); INSERT INTO `core_function_url` VALUES (62, 119, 44); INSERT INTO `core_function_url` VALUES (65, 120, 44); INSERT INTO `core_function_url` VALUES (67, 121, 44); INSERT INTO `core_function_url` VALUES (561, 118, 45); INSERT INTO `core_function_url` VALUES (560, 118, 46); INSERT INTO `core_function_url` VALUES (346, 1121, 47); INSERT INTO `core_function_url` VALUES (563, 118, 48); INSERT INTO `core_function_url` VALUES (562, 118, 49); INSERT INTO `core_function_url` VALUES (60, 119, 50); INSERT INTO `core_function_url` VALUES (556, 117, 51); INSERT INTO `core_function_url` VALUES (61, 119, 51); INSERT INTO `core_function_url` VALUES (63, 120, 52); INSERT INTO `core_function_url` VALUES (64, 120, 53); INSERT INTO `core_function_url` VALUES (66, 121, 54); INSERT INTO `core_function_url` VALUES (666, 1005, 55); INSERT INTO `core_function_url` VALUES (663, 923, 56); INSERT INTO `core_function_url` VALUES (659, 924, 56); INSERT INTO `core_function_url` VALUES (1069, 1186, 56); INSERT INTO `core_function_url` VALUES (664, 1002, 57); INSERT INTO `core_function_url` VALUES (665, 1003, 57); INSERT INTO `core_function_url` VALUES (678, 1009, 58); INSERT INTO `core_function_url` VALUES (657, 924, 59); INSERT INTO `core_function_url` VALUES (1014, 1136, 59); INSERT INTO `core_function_url` VALUES (671, 1010, 60); INSERT INTO `core_function_url` VALUES (673, 1012, 61); INSERT INTO `core_function_url` VALUES (674, 1013, 62); INSERT INTO `core_function_url` VALUES (669, 1007, 63); INSERT INTO `core_function_url` VALUES (670, 1008, 63); INSERT INTO `core_function_url` VALUES (672, 1011, 64); INSERT INTO `core_function_url` VALUES (677, 1028, 65); INSERT INTO `core_function_url` VALUES (658, 924, 66); INSERT INTO `core_function_url` VALUES (661, 925, 66); INSERT INTO `core_function_url` VALUES (675, 1026, 67); INSERT INTO `core_function_url` VALUES (676, 1027, 67); INSERT INTO `core_function_url` VALUES (364, 1125, 68); INSERT INTO `core_function_url` VALUES (582, 926, 69); INSERT INTO `core_function_url` VALUES (660, 925, 70); INSERT INTO `core_function_url` VALUES (365, 1124, 71); INSERT INTO `core_function_url` VALUES (646, 28, 72); INSERT INTO `core_function_url` VALUES (334, 1117, 73); INSERT INTO `core_function_url` VALUES (648, 28, 74); INSERT INTO `core_function_url` VALUES (335, 1118, 75); INSERT INTO `core_function_url` VALUES (649, 28, 76); INSERT INTO `core_function_url` VALUES (651, 29, 77); INSERT INTO `core_function_url` VALUES (337, 995, 78); INSERT INTO `core_function_url` VALUES (367, 1122, 79); INSERT INTO `core_function_url` VALUES (583, 930, 80); INSERT INTO `core_function_url` VALUES (450, 31, 81); INSERT INTO `core_function_url` VALUES (306, 973, 82); INSERT INTO `core_function_url` VALUES (302, 971, 83); INSERT INTO `core_function_url` VALUES (304, 972, 83); INSERT INTO `core_function_url` VALUES (653, 29, 84); INSERT INTO `core_function_url` VALUES (263, 962, 89); INSERT INTO `core_function_url` VALUES (636, 15, 90); INSERT INTO `core_function_url` VALUES (644, 15, 91); INSERT INTO `core_function_url` VALUES (627, 15, 92); INSERT INTO `core_function_url` VALUES (633, 15, 93); INSERT INTO `core_function_url` VALUES (617, 956, 94); INSERT INTO `core_function_url` VALUES (626, 15, 95); INSERT INTO `core_function_url` VALUES (622, 15, 96); INSERT INTO `core_function_url` VALUES (643, 15, 97); INSERT INTO `core_function_url` VALUES (637, 15, 98); INSERT INTO `core_function_url` VALUES (371, 952, 99); INSERT INTO `core_function_url` VALUES (374, 955, 100); INSERT INTO `core_function_url` VALUES (373, 954, 101); INSERT INTO `core_function_url` VALUES (629, 15, 102); INSERT INTO `core_function_url` VALUES (639, 15, 103); INSERT INTO `core_function_url` VALUES (630, 15, 104); INSERT INTO `core_function_url` VALUES (640, 15, 105); INSERT INTO `core_function_url` VALUES (372, 953, 106); INSERT INTO `core_function_url` VALUES (634, 15, 107); INSERT INTO `core_function_url` VALUES (642, 15, 108); INSERT INTO `core_function_url` VALUES (641, 15, 109); INSERT INTO `core_function_url` VALUES (631, 15, 110); INSERT INTO `core_function_url` VALUES (625, 15, 111); INSERT INTO `core_function_url` VALUES (620, 15, 112); INSERT INTO `core_function_url` VALUES (632, 15, 114); INSERT INTO `core_function_url` VALUES (623, 15, 115); INSERT INTO `core_function_url` VALUES (587, 959, 144); INSERT INTO `core_function_url` VALUES (377, 960, 144); INSERT INTO `core_function_url` VALUES (628, 15, 145); INSERT INTO `core_function_url` VALUES (619, 15, 146); INSERT INTO `core_function_url` VALUES (638, 15, 147); INSERT INTO `core_function_url` VALUES (621, 15, 148); INSERT INTO `core_function_url` VALUES (142, 133, 149); INSERT INTO `core_function_url` VALUES (143, 133, 150); INSERT INTO `core_function_url` VALUES (144, 133, 151); INSERT INTO `core_function_url` VALUES (145, 133, 152); INSERT INTO `core_function_url` VALUES (146, 133, 153); INSERT INTO `core_function_url` VALUES (147, 134, 154); INSERT INTO `core_function_url` VALUES (148, 134, 155); INSERT INTO `core_function_url` VALUES (149, 134, 156); INSERT INTO `core_function_url` VALUES (232, 47, 157); INSERT INTO `core_function_url` VALUES (150, 135, 157); INSERT INTO `core_function_url` VALUES (151, 136, 157); INSERT INTO `core_function_url` VALUES (152, 137, 157); INSERT INTO `core_function_url` VALUES (153, 138, 157); INSERT INTO `core_function_url` VALUES (233, 934, 157); INSERT INTO `core_function_url` VALUES (295, 935, 157); INSERT INTO `core_function_url` VALUES (154, 137, 158); INSERT INTO `core_function_url` VALUES (155, 136, 159); INSERT INTO `core_function_url` VALUES (156, 135, 160); INSERT INTO `core_function_url` VALUES (157, 138, 161); INSERT INTO `core_function_url` VALUES (618, 15, 162); INSERT INTO `core_function_url` VALUES (645, 15, 163); INSERT INTO `core_function_url` VALUES (375, 958, 164); INSERT INTO `core_function_url` VALUES (201, 135, 165); INSERT INTO `core_function_url` VALUES (202, 136, 165); INSERT INTO `core_function_url` VALUES (203, 137, 165); INSERT INTO `core_function_url` VALUES (204, 138, 165); INSERT INTO `core_function_url` VALUES (567, 139, 165); INSERT INTO `core_function_url` VALUES (570, 139, 166); INSERT INTO `core_function_url` VALUES (566, 139, 167); INSERT INTO `core_function_url` VALUES (568, 139, 168); INSERT INTO `core_function_url` VALUES (338, 996, 169); INSERT INTO `core_function_url` VALUES (341, 999, 170); INSERT INTO `core_function_url` VALUES (340, 998, 171); INSERT INTO `core_function_url` VALUES (572, 139, 172); INSERT INTO `core_function_url` VALUES (574, 140, 172); INSERT INTO `core_function_url` VALUES (342, 1000, 173); INSERT INTO `core_function_url` VALUES (343, 1001, 174); INSERT INTO `core_function_url` VALUES (575, 140, 175); INSERT INTO `core_function_url` VALUES (345, 1001, 176); INSERT INTO `core_function_url` VALUES (573, 140, 177); INSERT INTO `core_function_url` VALUES (174, 41, 178); INSERT INTO `core_function_url` VALUES (175, 41, 179); INSERT INTO `core_function_url` VALUES (176, 41, 180); INSERT INTO `core_function_url` VALUES (177, 41, 181); INSERT INTO `core_function_url` VALUES (178, 41, 182); INSERT INTO `core_function_url` VALUES (448, 31, 183); INSERT INTO `core_function_url` VALUES (439, 6, 184); INSERT INTO `core_function_url` VALUES (446, 7, 185); INSERT INTO `core_function_url` VALUES (440, 6, 186); INSERT INTO `core_function_url` VALUES (436, 6, 187); INSERT INTO `core_function_url` VALUES (668, 1006, 188); INSERT INTO `core_function_url` VALUES (662, 923, 189); INSERT INTO `core_function_url` VALUES (667, 1006, 190); INSERT INTO `core_function_url` VALUES (188, 136, 193); INSERT INTO `core_function_url` VALUES (189, 135, 194); INSERT INTO `core_function_url` VALUES (194, 42, 200); INSERT INTO `core_function_url` VALUES (195, 42, 201); INSERT INTO `core_function_url` VALUES (196, 42, 202); INSERT INTO `core_function_url` VALUES (197, 42, 203); INSERT INTO `core_function_url` VALUES (198, 42, 204); INSERT INTO `core_function_url` VALUES (199, 42, 205); INSERT INTO `core_function_url` VALUES (200, 42, 206); INSERT INTO `core_function_url` VALUES (205, 41, 207); INSERT INTO `core_function_url` VALUES (211, 46, 213); INSERT INTO `core_function_url` VALUES (212, 47, 214); INSERT INTO `core_function_url` VALUES (213, 48, 215); INSERT INTO `core_function_url` VALUES (214, 931, 216); INSERT INTO `core_function_url` VALUES (339, 997, 220); INSERT INTO `core_function_url` VALUES (571, 139, 221); INSERT INTO `core_function_url` VALUES (217, 48, 222); INSERT INTO `core_function_url` VALUES (219, 931, 224); INSERT INTO `core_function_url` VALUES (220, 47, 225); INSERT INTO `core_function_url` VALUES (569, 139, 227); INSERT INTO `core_function_url` VALUES (259, 1031, 229); INSERT INTO `core_function_url` VALUES (260, 1032, 229); INSERT INTO `core_function_url` VALUES (586, 1033, 230); INSERT INTO `core_function_url` VALUES (344, 1001, 232); INSERT INTO `core_function_url` VALUES (227, 933, 233); INSERT INTO `core_function_url` VALUES (228, 48, 234); INSERT INTO `core_function_url` VALUES (229, 934, 235); INSERT INTO `core_function_url` VALUES (230, 934, 236); INSERT INTO `core_function_url` VALUES (231, 935, 237); INSERT INTO `core_function_url` VALUES (246, 936, 238); INSERT INTO `core_function_url` VALUES (544, 937, 240); INSERT INTO `core_function_url` VALUES (330, 990, 241); INSERT INTO `core_function_url` VALUES (333, 993, 242); INSERT INTO `core_function_url` VALUES (331, 991, 243); INSERT INTO `core_function_url` VALUES (332, 992, 244); INSERT INTO `core_function_url` VALUES (545, 937, 245); INSERT INTO `core_function_url` VALUES (368, 1023, 246); INSERT INTO `core_function_url` VALUES (369, 1024, 247); INSERT INTO `core_function_url` VALUES (370, 1025, 248); INSERT INTO `core_function_url` VALUES (366, 1123, 253); INSERT INTO `core_function_url` VALUES (452, 31, 256); INSERT INTO `core_function_url` VALUES (336, 1119, 258); INSERT INTO `core_function_url` VALUES (449, 31, 263); INSERT INTO `core_function_url` VALUES (454, 1110, 263); INSERT INTO `core_function_url` VALUES (303, 971, 264); INSERT INTO `core_function_url` VALUES (305, 972, 265); INSERT INTO `core_function_url` VALUES (307, 973, 266); INSERT INTO `core_function_url` VALUES (453, 1110, 267); INSERT INTO `core_function_url` VALUES (308, 1113, 268); INSERT INTO `core_function_url` VALUES (309, 1114, 269); INSERT INTO `core_function_url` VALUES (310, 1115, 270); INSERT INTO `core_function_url` VALUES (459, 1110, 271); INSERT INTO `core_function_url` VALUES (311, 1116, 272); INSERT INTO `core_function_url` VALUES (312, 1116, 273); INSERT INTO `core_function_url` VALUES (313, 1116, 274); INSERT INTO `core_function_url` VALUES (462, 1110, 275); INSERT INTO `core_function_url` VALUES (457, 1110, 276); INSERT INTO `core_function_url` VALUES (461, 1110, 277); INSERT INTO `core_function_url` VALUES (458, 1110, 278); INSERT INTO `core_function_url` VALUES (456, 1110, 279); INSERT INTO `core_function_url` VALUES (460, 1110, 280); INSERT INTO `core_function_url` VALUES (455, 1110, 281); INSERT INTO `core_function_url` VALUES (635, 15, 291); INSERT INTO `core_function_url` VALUES (961, 1145, 292); INSERT INTO `core_function_url` VALUES (1070, 1187, 292); INSERT INTO `core_function_url` VALUES (962, 1148, 294); INSERT INTO `core_function_url` VALUES (1071, 1188, 294); INSERT INTO `core_function_url` VALUES (1068, 1186, 295); INSERT INTO `core_function_url` VALUES (963, 1149, 296); INSERT INTO `core_function_url` VALUES (1072, 1189, 296); INSERT INTO `core_function_url` VALUES (1097, 1202, 297); INSERT INTO `core_function_url` VALUES (1010, 1165, 298); INSERT INTO `core_function_url` VALUES (1098, 1202, 298); INSERT INTO `core_function_url` VALUES (1103, 1203, 298); INSERT INTO `core_function_url` VALUES (1012, 1167, 299); INSERT INTO `core_function_url` VALUES (1099, 1202, 299); INSERT INTO `core_function_url` VALUES (1105, 1205, 299); INSERT INTO `core_function_url` VALUES (1084, 1194, 300); INSERT INTO `core_function_url` VALUES (1100, 1202, 300); INSERT INTO `core_function_url` VALUES (1011, 1166, 301); INSERT INTO `core_function_url` VALUES (1036, 1181, 301); INSERT INTO `core_function_url` VALUES (1102, 1202, 301); INSERT INTO `core_function_url` VALUES (1104, 1204, 301); INSERT INTO `core_function_url` VALUES (1106, 1206, 301); INSERT INTO `core_function_url` VALUES (1083, 1194, 302); INSERT INTO `core_function_url` VALUES (1073, 1190, 303); INSERT INTO `core_function_url` VALUES (971, 1151, 304); INSERT INTO `core_function_url` VALUES (1078, 1192, 304); INSERT INTO `core_function_url` VALUES (972, 1152, 305); INSERT INTO `core_function_url` VALUES (1079, 1193, 305); INSERT INTO `core_function_url` VALUES (970, 1150, 306); INSERT INTO `core_function_url` VALUES (1077, 1191, 306); INSERT INTO `core_function_url` VALUES (1076, 1190, 307); INSERT INTO `core_function_url` VALUES (1074, 1190, 308); INSERT INTO `core_function_url` VALUES (1075, 1190, 309); INSERT INTO `core_function_url` VALUES (973, 1134, 310); INSERT INTO `core_function_url` VALUES (984, 1154, 311); INSERT INTO `core_function_url` VALUES (985, 1155, 312); INSERT INTO `core_function_url` VALUES (976, 1134, 313); INSERT INTO `core_function_url` VALUES (983, 1153, 314); INSERT INTO `core_function_url` VALUES (982, 1134, 315); INSERT INTO `core_function_url` VALUES (1013, 1136, 316); INSERT INTO `core_function_url` VALUES (1016, 1168, 317); INSERT INTO `core_function_url` VALUES (1018, 1170, 318); INSERT INTO `core_function_url` VALUES (1015, 1136, 319); INSERT INTO `core_function_url` VALUES (1017, 1169, 320); INSERT INTO `core_function_url` VALUES (1024, 1171, 321); INSERT INTO `core_function_url` VALUES (1020, 1137, 322); INSERT INTO `core_function_url` VALUES (1021, 1137, 323); INSERT INTO `core_function_url` VALUES (1026, 1172, 324); INSERT INTO `core_function_url` VALUES (1035, 1180, 324); INSERT INTO `core_function_url` VALUES (1027, 1173, 325); INSERT INTO `core_function_url` VALUES (1030, 1174, 326); INSERT INTO `core_function_url` VALUES (1031, 1175, 327); INSERT INTO `core_function_url` VALUES (1028, 1138, 328); INSERT INTO `core_function_url` VALUES (1029, 1138, 329); INSERT INTO `core_function_url` VALUES (974, 1134, 331); INSERT INTO `core_function_url` VALUES (1019, 1137, 331); INSERT INTO `core_function_url` VALUES (1038, 1139, 331); INSERT INTO `core_function_url` VALUES (879, 1144, 331); INSERT INTO `core_function_url` VALUES (1090, 1198, 331); INSERT INTO `core_function_url` VALUES (1022, 1137, 332); INSERT INTO `core_function_url` VALUES (1052, 1184, 332); INSERT INTO `core_function_url` VALUES (993, 1157, 333); INSERT INTO `core_function_url` VALUES (975, 1134, 334); INSERT INTO `core_function_url` VALUES (1039, 1139, 334); INSERT INTO `core_function_url` VALUES (1037, 1182, 335); INSERT INTO `core_function_url` VALUES (1040, 1139, 336); INSERT INTO `core_function_url` VALUES (992, 1156, 337); INSERT INTO `core_function_url` VALUES (1041, 1139, 338); INSERT INTO `core_function_url` VALUES (1042, 1139, 339); INSERT INTO `core_function_url` VALUES (878, 1144, 339); INSERT INTO `core_function_url` VALUES (994, 1158, 340); INSERT INTO `core_function_url` VALUES (1080, 1194, 341); INSERT INTO `core_function_url` VALUES (1081, 1194, 342); INSERT INTO `core_function_url` VALUES (1003, 1161, 343); INSERT INTO `core_function_url` VALUES (1089, 1197, 343); INSERT INTO `core_function_url` VALUES (1001, 1159, 344); INSERT INTO `core_function_url` VALUES (1087, 1195, 344); INSERT INTO `core_function_url` VALUES (1002, 1160, 345); INSERT INTO `core_function_url` VALUES (1088, 1196, 345); INSERT INTO `core_function_url` VALUES (1007, 1162, 346); INSERT INTO `core_function_url` VALUES (1093, 1199, 346); INSERT INTO `core_function_url` VALUES (1008, 1163, 347); INSERT INTO `core_function_url` VALUES (1094, 1200, 347); INSERT INTO `core_function_url` VALUES (1091, 1198, 348); INSERT INTO `core_function_url` VALUES (1092, 1198, 349); INSERT INTO `core_function_url` VALUES (1009, 1164, 350); INSERT INTO `core_function_url` VALUES (1095, 1201, 350); INSERT INTO `core_function_url` VALUES (1082, 1194, 351); INSERT INTO `core_function_url` VALUES (980, 1134, 352); INSERT INTO `core_function_url` VALUES (1086, 1194, 352); INSERT INTO `core_function_url` VALUES (873, 1144, 353); INSERT INTO `core_function_url` VALUES (882, 1144, 354); INSERT INTO `core_function_url` VALUES (874, 1144, 355); INSERT INTO `core_function_url` VALUES (1033, 1179, 355); INSERT INTO `core_function_url` VALUES (884, 1144, 356); INSERT INTO `core_function_url` VALUES (875, 1144, 357); INSERT INTO `core_function_url` VALUES (877, 1144, 358); INSERT INTO `core_function_url` VALUES (1034, 1177, 358); INSERT INTO `core_function_url` VALUES (887, 1144, 359); INSERT INTO `core_function_url` VALUES (880, 1144, 360); INSERT INTO `core_function_url` VALUES (881, 1144, 361); INSERT INTO `core_function_url` VALUES (883, 1144, 362); INSERT INTO `core_function_url` VALUES (872, 1144, 363); INSERT INTO `core_function_url` VALUES (876, 1144, 364); INSERT INTO `core_function_url` VALUES (885, 1144, 365); INSERT INTO `core_function_url` VALUES (886, 1144, 366); INSERT INTO `core_function_url` VALUES (977, 1134, 367); INSERT INTO `core_function_url` VALUES (1101, 1202, 367); INSERT INTO `core_function_url` VALUES (978, 1134, 368); INSERT INTO `core_function_url` VALUES (1085, 1194, 368); INSERT INTO `core_function_url` VALUES (979, 1134, 369); INSERT INTO `core_function_url` VALUES (981, 1134, 370); INSERT INTO `core_function_url` VALUES (1032, 1176, 371); INSERT INTO `core_function_url` VALUES (1051, 1184, 372); INSERT INTO `core_function_url` VALUES (1053, 1184, 373); INSERT INTO `core_function_url` VALUES (1096, 1202, 374); -- ---------------------------- -- Table structure for core_operation_record -- ---------------------------- DROP TABLE IF EXISTS `core_operation_record`; CREATE TABLE `core_operation_record` ( `id` int(0) NOT NULL AUTO_INCREMENT, `created_time` datetime(0) NULL DEFAULT NULL COMMENT '操作时间', `user_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名称', `user_id` int(0) NULL DEFAULT NULL COMMENT '用户id/接口用户id', `note` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作内容', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 25381 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '操作记录表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of core_operation_record -- ---------------------------- -- ---------------------------- -- Table structure for core_role -- ---------------------------- DROP TABLE IF EXISTS `core_role`; CREATE TABLE `core_role` ( `id` int(0) NOT NULL AUTO_INCREMENT, `name` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色名称', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 32 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of core_role -- ---------------------------- INSERT INTO `core_role` VALUES (1, '系统管理员'); -- ---------------------------- -- Table structure for core_role_function -- ---------------------------- DROP TABLE IF EXISTS `core_role_function`; CREATE TABLE `core_role_function` ( `id` int(0) NOT NULL AUTO_INCREMENT, `role_id` int(0) NOT NULL COMMENT '角色id', `function_id` int(0) NOT NULL COMMENT '功能模块id', `auth_mode` tinyint(1) NULL DEFAULT 1 COMMENT '权限模式：0-只读1-可编辑', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 22311 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色功能权限表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of core_role_function -- ---------------------------- INSERT INTO `core_role_function` VALUES (22043, 1, 2, 1); INSERT INTO `core_role_function` VALUES (22044, 1, 3, 1); INSERT INTO `core_role_function` VALUES (22045, 1, 4, 1); INSERT INTO `core_role_function` VALUES (22046, 1, 6, 1); INSERT INTO `core_role_function` VALUES (22047, 1, 9, 1); INSERT INTO `core_role_function` VALUES (22048, 1, 10, 1); INSERT INTO `core_role_function` VALUES (22049, 1, 11, 1); INSERT INTO `core_role_function` VALUES (22050, 1, 15, 1); INSERT INTO `core_role_function` VALUES (22051, 1, 28, 1); INSERT INTO `core_role_function` VALUES (22052, 1, 29, 1); INSERT INTO `core_role_function` VALUES (22053, 1, 31, 1); INSERT INTO `core_role_function` VALUES (22054, 1, 41, 1); INSERT INTO `core_role_function` VALUES (22055, 1, 42, 1); INSERT INTO `core_role_function` VALUES (22056, 1, 47, 1); INSERT INTO `core_role_function` VALUES (22057, 1, 48, 1); INSERT INTO `core_role_function` VALUES (22058, 1, 117, 1); INSERT INTO `core_role_function` VALUES (22059, 1, 118, 1); INSERT INTO `core_role_function` VALUES (22060, 1, 133, 1); INSERT INTO `core_role_function` VALUES (22061, 1, 135, 1); INSERT INTO `core_role_function` VALUES (22062, 1, 136, 1); INSERT INTO `core_role_function` VALUES (22063, 1, 137, 1); INSERT INTO `core_role_function` VALUES (22064, 1, 138, 1); INSERT INTO `core_role_function` VALUES (22065, 1, 139, 1); INSERT INTO `core_role_function` VALUES (22066, 1, 140, 1); INSERT INTO `core_role_function` VALUES (22067, 1, 923, 1); INSERT INTO `core_role_function` VALUES (22068, 1, 924, 1); INSERT INTO `core_role_function` VALUES (22069, 1, 925, 1); INSERT INTO `core_role_function` VALUES (22070, 1, 926, 1); INSERT INTO `core_role_function` VALUES (22071, 1, 930, 1); INSERT INTO `core_role_function` VALUES (22072, 1, 931, 1); INSERT INTO `core_role_function` VALUES (22073, 1, 933, 1); INSERT INTO `core_role_function` VALUES (22074, 1, 934, 1); INSERT INTO `core_role_function` VALUES (22075, 1, 935, 1); INSERT INTO `core_role_function` VALUES (22076, 1, 936, 1); INSERT INTO `core_role_function` VALUES (22077, 1, 937, 1); INSERT INTO `core_role_function` VALUES (22078, 1, 962, 1); INSERT INTO `core_role_function` VALUES (22079, 1, 963, 1); INSERT INTO `core_role_function` VALUES (22080, 1, 950, 1); INSERT INTO `core_role_function` VALUES (22081, 1, 964, 1); INSERT INTO `core_role_function` VALUES (22082, 1, 966, 1); INSERT INTO `core_role_function` VALUES (22083, 1, 967, 1); INSERT INTO `core_role_function` VALUES (22084, 1, 974, 1); INSERT INTO `core_role_function` VALUES (22085, 1, 975, 1); INSERT INTO `core_role_function` VALUES (22086, 1, 977, 1); INSERT INTO `core_role_function` VALUES (22087, 1, 978, 1); INSERT INTO `core_role_function` VALUES (22088, 1, 979, 1); INSERT INTO `core_role_function` VALUES (22089, 1, 980, 1); INSERT INTO `core_role_function` VALUES (22090, 1, 982, 1); INSERT INTO `core_role_function` VALUES (22091, 1, 983, 1); INSERT INTO `core_role_function` VALUES (22092, 1, 984, 1); INSERT INTO `core_role_function` VALUES (22093, 1, 985, 1); INSERT INTO `core_role_function` VALUES (22094, 1, 986, 1); INSERT INTO `core_role_function` VALUES (22095, 1, 987, 1); INSERT INTO `core_role_function` VALUES (22096, 1, 988, 1); INSERT INTO `core_role_function` VALUES (22097, 1, 989, 1); INSERT INTO `core_role_function` VALUES (22098, 1, 952, 1); INSERT INTO `core_role_function` VALUES (22099, 1, 953, 1); INSERT INTO `core_role_function` VALUES (22100, 1, 954, 1); INSERT INTO `core_role_function` VALUES (22101, 1, 955, 1); INSERT INTO `core_role_function` VALUES (22102, 1, 956, 1); INSERT INTO `core_role_function` VALUES (22103, 1, 958, 1); INSERT INTO `core_role_function` VALUES (22104, 1, 959, 1); INSERT INTO `core_role_function` VALUES (22105, 1, 960, 1); INSERT INTO `core_role_function` VALUES (22106, 1, 961, 1); INSERT INTO `core_role_function` VALUES (22107, 1, 990, 1); INSERT INTO `core_role_function` VALUES (22108, 1, 991, 1); INSERT INTO `core_role_function` VALUES (22109, 1, 992, 1); INSERT INTO `core_role_function` VALUES (22110, 1, 993, 1); INSERT INTO `core_role_function` VALUES (22111, 1, 994, 1); INSERT INTO `core_role_function` VALUES (22112, 1, 995, 1); INSERT INTO `core_role_function` VALUES (22113, 1, 996, 1); INSERT INTO `core_role_function` VALUES (22114, 1, 997, 1); INSERT INTO `core_role_function` VALUES (22115, 1, 998, 1); INSERT INTO `core_role_function` VALUES (22116, 1, 999, 1); INSERT INTO `core_role_function` VALUES (22117, 1, 1000, 1); INSERT INTO `core_role_function` VALUES (22118, 1, 1001, 1); INSERT INTO `core_role_function` VALUES (22119, 1, 1002, 1); INSERT INTO `core_role_function` VALUES (22120, 1, 1003, 1); INSERT INTO `core_role_function` VALUES (22121, 1, 1005, 1); INSERT INTO `core_role_function` VALUES (22122, 1, 1006, 1); INSERT INTO `core_role_function` VALUES (22123, 1, 1007, 1); INSERT INTO `core_role_function` VALUES (22124, 1, 1008, 1); INSERT INTO `core_role_function` VALUES (22125, 1, 1009, 1); INSERT INTO `core_role_function` VALUES (22126, 1, 1010, 1); INSERT INTO `core_role_function` VALUES (22127, 1, 1011, 1); INSERT INTO `core_role_function` VALUES (22128, 1, 1012, 1); INSERT INTO `core_role_function` VALUES (22129, 1, 1013, 1); INSERT INTO `core_role_function` VALUES (22130, 1, 1026, 1); INSERT INTO `core_role_function` VALUES (22131, 1, 1027, 1); INSERT INTO `core_role_function` VALUES (22132, 1, 1028, 1); INSERT INTO `core_role_function` VALUES (22133, 1, 1023, 1); INSERT INTO `core_role_function` VALUES (22134, 1, 1024, 1); INSERT INTO `core_role_function` VALUES (22135, 1, 1025, 1); INSERT INTO `core_role_function` VALUES (22136, 1, 7, 1); INSERT INTO `core_role_function` VALUES (22137, 1, 968, 1); INSERT INTO `core_role_function` VALUES (22138, 1, 969, 1); INSERT INTO `core_role_function` VALUES (22139, 1, 970, 1); INSERT INTO `core_role_function` VALUES (22140, 1, 971, 1); INSERT INTO `core_role_function` VALUES (22141, 1, 972, 1); INSERT INTO `core_role_function` VALUES (22142, 1, 973, 1); INSERT INTO `core_role_function` VALUES (22143, 1, 1031, 1); INSERT INTO `core_role_function` VALUES (22144, 1, 1032, 1); INSERT INTO `core_role_function` VALUES (22145, 1, 1033, 1); INSERT INTO `core_role_function` VALUES (22146, 1, 1110, 1); INSERT INTO `core_role_function` VALUES (22147, 1, 1117, 1); INSERT INTO `core_role_function` VALUES (22148, 1, 1118, 1); INSERT INTO `core_role_function` VALUES (22149, 1, 1119, 1); INSERT INTO `core_role_function` VALUES (22150, 1, 1125, 1); INSERT INTO `core_role_function` VALUES (22151, 1, 1124, 1); INSERT INTO `core_role_function` VALUES (22152, 1, 1123, 1); INSERT INTO `core_role_function` VALUES (22153, 1, 1122, 1); INSERT INTO `core_role_function` VALUES (22154, 1, 1113, 1); INSERT INTO `core_role_function` VALUES (22155, 1, 1114, 1); INSERT INTO `core_role_function` VALUES (22156, 1, 1115, 1); INSERT INTO `core_role_function` VALUES (22157, 1, 1116, 1); INSERT INTO `core_role_function` VALUES (22158, 1, 1112, 1); INSERT INTO `core_role_function` VALUES (22159, 1, 1111, 1); INSERT INTO `core_role_function` VALUES (22160, 1, 922, 1); INSERT INTO `core_role_function` VALUES (22161, 1, 1179, 1); INSERT INTO `core_role_function` VALUES (22162, 1, 1178, 1); INSERT INTO `core_role_function` VALUES (22163, 1, 1177, 1); INSERT INTO `core_role_function` VALUES (22164, 1, 1144, 1); INSERT INTO `core_role_function` VALUES (22165, 1, 1143, 1); INSERT INTO `core_role_function` VALUES (22166, 1, 1176, 1); INSERT INTO `core_role_function` VALUES (22167, 1, 1175, 1); INSERT INTO `core_role_function` VALUES (22168, 1, 1174, 1); INSERT INTO `core_role_function` VALUES (22169, 1, 1138, 1); INSERT INTO `core_role_function` VALUES (22170, 1, 1173, 1); INSERT INTO `core_role_function` VALUES (22171, 1, 1172, 1); INSERT INTO `core_role_function` VALUES (22172, 1, 1171, 1); INSERT INTO `core_role_function` VALUES (22173, 1, 1137, 1); INSERT INTO `core_role_function` VALUES (22174, 1, 1170, 1); INSERT INTO `core_role_function` VALUES (22175, 1, 1169, 1); INSERT INTO `core_role_function` VALUES (22176, 1, 1168, 1); INSERT INTO `core_role_function` VALUES (22177, 1, 1136, 1); INSERT INTO `core_role_function` VALUES (22178, 1, 1135, 1); INSERT INTO `core_role_function` VALUES (22179, 1, 1167, 1); INSERT INTO `core_role_function` VALUES (22180, 1, 1166, 1); INSERT INTO `core_role_function` VALUES (22181, 1, 1165, 1); INSERT INTO `core_role_function` VALUES (22182, 1, 1164, 1); INSERT INTO `core_role_function` VALUES (22183, 1, 1163, 1); INSERT INTO `core_role_function` VALUES (22184, 1, 1162, 1); INSERT INTO `core_role_function` VALUES (22185, 1, 1161, 1); INSERT INTO `core_role_function` VALUES (22186, 1, 1160, 1); INSERT INTO `core_role_function` VALUES (22187, 1, 1159, 1); INSERT INTO `core_role_function` VALUES (22188, 1, 1158, 1); INSERT INTO `core_role_function` VALUES (22189, 1, 1157, 1); INSERT INTO `core_role_function` VALUES (22190, 1, 1156, 1); INSERT INTO `core_role_function` VALUES (22191, 1, 1139, 1); INSERT INTO `core_role_function` VALUES (22192, 1, 1155, 1); INSERT INTO `core_role_function` VALUES (22193, 1, 1154, 1); INSERT INTO `core_role_function` VALUES (22194, 1, 1153, 1); INSERT INTO `core_role_function` VALUES (22195, 1, 1134, 1); INSERT INTO `core_role_function` VALUES (22196, 1, 1152, 1); INSERT INTO `core_role_function` VALUES (22197, 1, 1151, 1); INSERT INTO `core_role_function` VALUES (22198, 1, 1150, 1); INSERT INTO `core_role_function` VALUES (22199, 1, 1149, 1); INSERT INTO `core_role_function` VALUES (22200, 1, 1148, 1); INSERT INTO `core_role_function` VALUES (22201, 1, 1145, 1); INSERT INTO `core_role_function` VALUES (22202, 1, 1130, 1); INSERT INTO `core_role_function` VALUES (22203, 1, 1180, 1); INSERT INTO `core_role_function` VALUES (22204, 1, 1181, 1); INSERT INTO `core_role_function` VALUES (22205, 1, 1182, 1); INSERT INTO `core_role_function` VALUES (22206, 1, 1183, 1); INSERT INTO `core_role_function` VALUES (22207, 1, 1184, 1); INSERT INTO `core_role_function` VALUES (22208, 1, 1185, 1); INSERT INTO `core_role_function` VALUES (22209, 1, 1186, 1); INSERT INTO `core_role_function` VALUES (22210, 1, 1187, 1); INSERT INTO `core_role_function` VALUES (22211, 1, 1188, 1); INSERT INTO `core_role_function` VALUES (22212, 1, 1189, 1); INSERT INTO `core_role_function` VALUES (22213, 1, 1190, 1); INSERT INTO `core_role_function` VALUES (22214, 1, 1191, 1); INSERT INTO `core_role_function` VALUES (22215, 1, 1192, 1); INSERT INTO `core_role_function` VALUES (22216, 1, 1193, 1); INSERT INTO `core_role_function` VALUES (22217, 1, 1194, 1); INSERT INTO `core_role_function` VALUES (22218, 1, 1195, 1); INSERT INTO `core_role_function` VALUES (22219, 1, 1196, 1); INSERT INTO `core_role_function` VALUES (22220, 1, 1197, 1); INSERT INTO `core_role_function` VALUES (22221, 1, 1198, 1); INSERT INTO `core_role_function` VALUES (22222, 1, 1199, 1); INSERT INTO `core_role_function` VALUES (22223, 1, 1200, 1); INSERT INTO `core_role_function` VALUES (22224, 1, 1201, 1); INSERT INTO `core_role_function` VALUES (22225, 1, 1202, 1); INSERT INTO `core_role_function` VALUES (22226, 1, 1203, 1); INSERT INTO `core_role_function` VALUES (22227, 1, 1204, 1); INSERT INTO `core_role_function` VALUES (22228, 1, 1205, 1); INSERT INTO `core_role_function` VALUES (22229, 1, 1206, 1); -- ---------------------------- -- Table structure for core_url -- ---------------------------- DROP TABLE IF EXISTS `core_url`; CREATE TABLE `core_url` ( `id` int(0) NOT NULL AUTO_INCREMENT, `auth_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '接口地址', `note` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '说明', `url_type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '链接类型：0-查询，1-其他', `common` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否通用：0-非通用,1-通用', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uq_authUrl`(`auth_url`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 375 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '接口表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of core_url -- ---------------------------- INSERT INTO `core_url` VALUES (1, '/login', '登录', 0, 1); INSERT INTO `core_url` VALUES (2, '/modifyPassword', '修改当前账户密码', 1, 1); INSERT INTO `core_url` VALUES (3, '/InfoService/mainPage/all', '主页信息', 0, 0); INSERT INTO `core_url` VALUES (4, '/knowledgelist/mine', '模型参数配置', 0, 0); INSERT INTO `core_url` VALUES (5, '/params/knowledge', '参数列表', 0, 0); INSERT INTO `core_url` VALUES (6, '/queryRemote', '查询', 0, 0); INSERT INTO `core_url` VALUES (7, '/uruleUpdate', '自动更新规则模型', 0, 0); INSERT INTO `core_url` VALUES (8, '/knowledges/companys', '机构或模型列表', 0, 0); INSERT INTO `core_url` VALUES (9, '/query/record/all', '模型查询记录列表', 0, 0); INSERT INTO `core_url` VALUES (10, '/query/record/export', '导出查询记录列表', 0, 0); INSERT INTO `core_url` VALUES (11, '/query/record/one', '模型记录详情', 0, 0); INSERT INTO `core_url` VALUES (12, '/channel', '接口详情', 0, 0); INSERT INTO `core_url` VALUES (13, '/channel/one/save', '新增或修改接口', 1, 0); INSERT INTO `core_url` VALUES (14, '/channel/statusupdate', '禁用或启用接口', 1, 0); INSERT INTO `core_url` VALUES (15, '/channels/all', '接口列表', 0, 0); INSERT INTO `core_url` VALUES (16, '/channels/del', '删除接口', 1, 0); INSERT INTO `core_url` VALUES (17, '/origin/all', '数据源列表', 0, 0); INSERT INTO `core_url` VALUES (18, '/channel/dictionarys/all', '字段管理列表', 0, 0); INSERT INTO `core_url` VALUES (19, '/channels/methods', '获取接口和模板方法', 0, 0); INSERT INTO `core_url` VALUES (20, '/dict/derivative/save', '新增或修改衍生字段', 1, 0); INSERT INTO `core_url` VALUES (21, '/dictionary/channel', '获取接口字段列表', 1, 0); INSERT INTO `core_url` VALUES (22, '/dictionary/getchanneljson', '解析接口json', 1, 0); INSERT INTO `core_url` VALUES (23, '/dictionary/iddel', '删除接口字段', 1, 0); INSERT INTO `core_url` VALUES (24, '/dictionary/save/all', '保存所有接口字段', 1, 0); INSERT INTO `core_url` VALUES (25, '/dictionary/statusupdate', '启用或禁用字段', 1, 0); INSERT INTO `core_url` VALUES (26, '/dictionary/update', '修改字段', 1, 0); INSERT INTO `core_url` VALUES (27, '/delete/tag/person', '删除黑白名单用户', 1, 0); INSERT INTO `core_url` VALUES (28, '/delete/tags', '删除黑白名单标签', 1, 0); INSERT INTO `core_url` VALUES (29, '/detail/from/tag', '名单详情', 0, 0); INSERT INTO `core_url` VALUES (30, '/export/one/tag', '导出黑白名单标签', 0, 0); INSERT INTO `core_url` VALUES (31, '/export/template', '下载黑白名单模板', 1, 0); INSERT INTO `core_url` VALUES (32, '/find/all/tagName', '黑白名单标签名称', 0, 0); INSERT INTO `core_url` VALUES (33, '/manage/package/tags', '黑白名单标签列表', 0, 0); INSERT INTO `core_url` VALUES (34, '/read/template', '新增或修改黑白名单', 1, 0); INSERT INTO `core_url` VALUES (35, '/save/tag/person', '新增或修改黑白名单用户', 1, 0); INSERT INTO `core_url` VALUES (36, '/find/knowpackage/ship', '获取标签下的所有模型', 0, 0); INSERT INTO `core_url` VALUES (37, '/find/tag/all', '获取黑白名单标签', 0, 0); INSERT INTO `core_url` VALUES (38, '/save/knowpackage/ship', '保存标签所用的模型', 1, 0); INSERT INTO `core_url` VALUES (39, '/urule/frame/loadProjects', '加载项目列表', 0, 0); INSERT INTO `core_url` VALUES (40, '/InfoService/mainPage/chart/model', '模型使用报表柱状图', 0, 0); INSERT INTO `core_url` VALUES (41, '/InfoService/mainPage/pie/model', '模型使用报表饼图', 0, 0); INSERT INTO `core_url` VALUES (42, '/statis/modelUsage/export', '模型使用报表导出', 0, 0); INSERT INTO `core_url` VALUES (43, '/statis/modelUsage/list', '模型使用报表', 0, 0); INSERT INTO `core_url` VALUES (44, '/statis/options/packageCompany', '获取模型或者机构', 0, 0); INSERT INTO `core_url` VALUES (45, '/InfoService/mainPage/chart/api', '接口调用报表柱状图', 0, 0); INSERT INTO `core_url` VALUES (46, '/InfoService/mainPage/pie/api', '接口调用报表饼图', 0, 0); INSERT INTO `core_url` VALUES (47, '/statis/apiUsage/export', '接口调用报表导出', 0, 0); INSERT INTO `core_url` VALUES (48, '/statis/apiUsage/list', '接口调用报表', 0, 0); INSERT INTO `core_url` VALUES (49, '/statis/options/apiCompany', '获取接口和机构', 0, 0); INSERT INTO `core_url` VALUES (50, '/statis/admittance/list', '决策项通过率列表', 0, 0); INSERT INTO `core_url` VALUES (51, '/statis/options/models', '获取模型', 0, 0); INSERT INTO `core_url` VALUES (52, '/statis/score/card', '获取评分卡', 0, 0); INSERT INTO `core_url` VALUES (53, '/statis/score/list', '评分参数列表', 0, 0); INSERT INTO `core_url` VALUES (54, '/statis/admittance/compare', '模型对比分析', 0, 0); INSERT INTO `core_url` VALUES (55, '/department/del', '删除机构', 1, 0); INSERT INTO `core_url` VALUES (56, '/department/list', '机构列表', 0, 0); INSERT INTO `core_url` VALUES (57, '/department/save', '新增或修改机构', 1, 0); INSERT INTO `core_url` VALUES (58, '/user/del', '删除账户', 1, 0); INSERT INTO `core_url` VALUES (59, '/user/list', '账户列表', 0, 0); INSERT INTO `core_url` VALUES (60, '/user/lock', '锁定账户', 1, 0); INSERT INTO `core_url` VALUES (61, '/user/password/modify', '修改账户密码', 1, 0); INSERT INTO `core_url` VALUES (62, '/user/password/reset', '重置账户密码', 1, 0); INSERT INTO `core_url` VALUES (63, '/user/save', '新增或修改账户', 1, 0); INSERT INTO `core_url` VALUES (64, '/user/unlock', '解锁账户', 1, 0); INSERT INTO `core_url` VALUES (65, '/role/del', '删除角色', 1, 0); INSERT INTO `core_url` VALUES (66, '/role/list', '角色列表', 0, 0); INSERT INTO `core_url` VALUES (67, '/role/save', '新增或修改角色', 1, 0); INSERT INTO `core_url` VALUES (68, '/function/del', '权限删除', 1, 0); INSERT INTO `core_url` VALUES (69, '/function/list', '权限管理列表', 0, 0); INSERT INTO `core_url` VALUES (70, '/function/list2', '角色权限列表', 0, 0); INSERT INTO `core_url` VALUES (71, '/function/save', '权限保存', 1, 0); INSERT INTO `core_url` VALUES (72, '/knowledges/all', '模型参数配置', 0, 0); INSERT INTO `core_url` VALUES (73, '/knowledges/apiDetails/save', '启用或禁用接口调用', 1, 0); INSERT INTO `core_url` VALUES (74, '/knowledges/apiUser/get', '获取接口账户列表', 0, 0); INSERT INTO `core_url` VALUES (75, '/knowledges/apiUser/save', '保存接口账户和规则', 1, 0); INSERT INTO `core_url` VALUES (76, '/knowledges/owner', '获取模型详情', 0, 0); INSERT INTO `core_url` VALUES (77, '/knowledgedictionaryalias/mine', '获取模型参数', 0, 0); INSERT INTO `core_url` VALUES (78, '/knowledgedictionaryalias/mine/savewant', '保存模型参数', 1, 0); INSERT INTO `core_url` VALUES (79, '/logInfo/OperationLog/export', '日志导出', 0, 0); INSERT INTO `core_url` VALUES (80, '/logInfo/OperationLog/list', '日志列表', 0, 0); INSERT INTO `core_url` VALUES (81, '/origin', '获取数据源详情', 1, 0); INSERT INTO `core_url` VALUES (82, '/origin/del', '删除数据源', 1, 0); INSERT INTO `core_url` VALUES (83, '/origin/one/save', '新增或修改数据源', 1, 0); INSERT INTO `core_url` VALUES (84, '/knowledgedictionaryalias/all', '获取模型配置参数', 0, 0); INSERT INTO `core_url` VALUES (88, '/logout', '退出登录', 1, 1); INSERT INTO `core_url` VALUES (89, '/exportCSV/model', '下载csv', 1, 0); INSERT INTO `core_url` VALUES (90, '/urule/common/loadFunctions', '加载函数', 0, 0); INSERT INTO `core_url` VALUES (91, '/urule/common/loadReferenceFiles', '查看引用', 0, 0); INSERT INTO `core_url` VALUES (92, '/urule/common/loadResourceTreeData', '加载资源文件', 0, 0); INSERT INTO `core_url` VALUES (93, '/urule/common/loadXml', '加载普通决策文件', 0, 0); INSERT INTO `core_url` VALUES (94, '/urule/common/saveFile', '保存文件', 1, 0); INSERT INTO `core_url` VALUES (95, '/urule/common/scriptValidation', '编辑脚本', 1, 0); INSERT INTO `core_url` VALUES (96, '/urule/frame/copyFile', '复制文件', 1, 0); INSERT INTO `core_url` VALUES (97, '/urule/frame/createFile', '添加文件', 1, 0); INSERT INTO `core_url` VALUES (98, '/urule/frame/createFolder', '添加目录', 1, 0); INSERT INTO `core_url` VALUES (99, '/urule/frame/createProject', '创建新项目', 1, 0); INSERT INTO `core_url` VALUES (100, '/urule/frame/deleteFile', '删除文件', 1, 0); INSERT INTO `core_url` VALUES (101, '/urule/frame/exportProjectBackupFile', '导出项目', 1, 0); INSERT INTO `core_url` VALUES (102, '/urule/frame/fileExistCheck', '检查文件是否存在', 0, 0); INSERT INTO `core_url` VALUES (103, '/urule/frame/fileRename', '修改文件名', 1, 0); INSERT INTO `core_url` VALUES (104, '/urule/frame/fileSource', '查看源码', 0, 0); INSERT INTO `core_url` VALUES (105, '/urule/frame/fileVersions', '查看文件版本', 0, 0); INSERT INTO `core_url` VALUES (106, '/urule/frame/importProject', '导入项目', 1, 0); INSERT INTO `core_url` VALUES (107, '/urule/frame/loadFileVersions', '加载文件版本', 0, 0); INSERT INTO `core_url` VALUES (108, '/urule/frame/lockFile', '锁定文件', 1, 0); INSERT INTO `core_url` VALUES (109, '/urule/frame/projectExistCheck', '检查项目是否存在', 0, 0); INSERT INTO `core_url` VALUES (110, '/urule/frame/unlockFile', '解锁文件', 1, 0); INSERT INTO `core_url` VALUES (111, '/urule/packageeditor/loadPackages', '加载知识包', 0, 0); INSERT INTO `core_url` VALUES (112, '/urule/packageeditor/refreshKnowledgeCache', '发布当前知识包', 1, 0); INSERT INTO `core_url` VALUES (113, '/urule/packageeditor/saveResourcePackages', '保存知识包', 1, 0); INSERT INTO `core_url` VALUES (114, '/urule/ruleflowdesigner/loadFlowDefinition', '加载决策流文件', 0, 0); INSERT INTO `core_url` VALUES (115, '/urule/xml', '加载变量库文件', 0, 0); INSERT INTO `core_url` VALUES (144, '/urule/packageeditor/saveResourcePackage', '发布单个知识包', 1, 0); INSERT INTO `core_url` VALUES (145, '/exportCSV/rule/variable', '下载变量（常量）', 1, 0); INSERT INTO `core_url` VALUES (146, '/rule/isAdmin', '该用户是否是规则引擎admin', 0, 0); INSERT INTO `core_url` VALUES (147, '/rule/user/product', '该部门下可分配的用户', 0, 0); INSERT INTO `core_url` VALUES (148, '/rule/user/productship/save', '规则管理用户与项目关系管理', 1, 0); INSERT INTO `core_url` VALUES (149, '/statistics/passweek', '七天通过率', 0, 0); INSERT INTO `core_url` VALUES (150, '/statistics/totaltoday', '24小时模型调用量', 0, 0); INSERT INTO `core_url` VALUES (151, '/statistics/passtoday', '24小时通过率', 0, 0); INSERT INTO `core_url` VALUES (152, '/statistics/scoreweek', '评分卡分部', 0, 0); INSERT INTO `core_url` VALUES (153, '/statistics/totalweek', '七天模型调用总量', 0, 0); INSERT INTO `core_url` VALUES (154, '/flowNodes/list', '节点对比列表', 0, 0); INSERT INTO `core_url` VALUES (155, '/flowModels/list', '节点对比模型列表', 0, 0); INSERT INTO `core_url` VALUES (156, '/statis/flowNodes/compare', '节点对比', 0, 0); INSERT INTO `core_url` VALUES (157, '/record/modelList', '模型-文件-版本', 0, 0); INSERT INTO `core_url` VALUES (158, '/record/statistics/decisiontree', '决策树对比', 0, 0); INSERT INTO `core_url` VALUES (159, '/statis/compare/ruleSet', '决策集对比', 0, 0); INSERT INTO `core_url` VALUES (160, '/statis/compare/scoreSet', '评分卡对比', 0, 0); INSERT INTO `core_url` VALUES (161, '/record/compare/tableRule', '决策表对比', 0, 0); INSERT INTO `core_url` VALUES (162, '/urule/ruleflowdesigner/loadLibraries', '加载决策文件的库文件', 0, 0); INSERT INTO `core_url` VALUES (163, '/urule/frame/apiCreateFile', 'API创建文件', 1, 0); INSERT INTO `core_url` VALUES (164, '/urule/packageeditor/saveResourcePackageToRedis', '保存单个知识包', 1, 0); INSERT INTO `core_url` VALUES (165, '/flag/list', '获取全部标签', 0, 0); INSERT INTO `core_url` VALUES (166, '/flag/all', '查询标签列表', 0, 0); INSERT INTO `core_url` VALUES (167, '/flag/modelList', '标签模型列表', 0, 0); INSERT INTO `core_url` VALUES (168, '/flag/record/all', '查询列表', 0, 0); INSERT INTO `core_url` VALUES (169, '/flag/save', '保存标签', 1, 0); INSERT INTO `core_url` VALUES (170, '/flag/del', '删除标签', 1, 0); INSERT INTO `core_url` VALUES (171, '/flag/excel', '标签历史数据导出', 1, 0); INSERT INTO `core_url` VALUES (172, '/flag/job/model', '可选择模型列表', 0, 0); INSERT INTO `core_url` VALUES (173, '/flag/job/save', '添加定时任务或跑批任务', 1, 0); INSERT INTO `core_url` VALUES (174, '/flag/job/run', '手动跑批', 1, 0); INSERT INTO `core_url` VALUES (175, '/flag/job/one', '任务详情', 0, 0); INSERT INTO `core_url` VALUES (176, '/flag/job/del', '删除任务', 1, 0); INSERT INTO `core_url` VALUES (177, '/flag/job/list', '任务列表', 0, 0); INSERT INTO `core_url` VALUES (178, '/coreMethod/all', '全部方法', 0, 0); INSERT INTO `core_url` VALUES (179, '/coreMethod/list', '方法列表', 0, 0); INSERT INTO `core_url` VALUES (180, '/coreMethod/add', '添加方法', 0, 0); INSERT INTO `core_url` VALUES (181, '/coreMethod/del', '删除方法', 0, 0); INSERT INTO `core_url` VALUES (182, '/coreMethod/refresh', '删除方法', 1, 0); INSERT INTO `core_url` VALUES (183, '/origin/company/list', '数据源机构列表', 0, 0); INSERT INTO `core_url` VALUES (184, '/origin/list', '数据源列表', 0, 0); INSERT INTO `core_url` VALUES (185, '/dictionary/origin/list', '字段数据源', 0, 0); INSERT INTO `core_url` VALUES (186, '/channelTemplate/list', '接口模板列表', 0, 0); INSERT INTO `core_url` VALUES (187, '/channelTemplate/add', '添加接口模板', 1, 0); INSERT INTO `core_url` VALUES (188, '/department/alarmList', '机构用户列表', 0, 0); INSERT INTO `core_url` VALUES (189, '/department/alarm/save', '机构告警用户保存', 0, 0); INSERT INTO `core_url` VALUES (190, '/department/alarm/one', '机构告警用户列表', 0, 0); INSERT INTO `core_url` VALUES (191, '/monitor/msg/read', '读取消息详情', 0, 1); INSERT INTO `core_url` VALUES (192, '/urule/frame/importPmml', '导入文件', 1, 0); INSERT INTO `core_url` VALUES (193, '/statis/ruleSetHit', '获取决策集规则每日命中', 0, 1); INSERT INTO `core_url` VALUES (194, '/statis/scoreSetHit', '获取评分卡规则每日命中', 0, 1); INSERT INTO `core_url` VALUES (195, '/monitor/msg/list', '未读消息列表', 0, 1); INSERT INTO `core_url` VALUES (196, '/urule/ruleflowdesigner/parseLhs', '节点条件解析', 1, 0); INSERT INTO `core_url` VALUES (197, '/urule/packageeditor/singleRuleTest', '单规则执行', 1, 0); INSERT INTO `core_url` VALUES (198, '/urule/packageeditor/singleScoreTest', '评分卡分箱预览执行', 1, 0); INSERT INTO `core_url` VALUES (199, '/urule/ruleflowdesigner/parseActions', '节点动作解析', 1, 0); INSERT INTO `core_url` VALUES (200, '/rule/class/page', '查找规则类(分页)', 0, 0); INSERT INTO `core_url` VALUES (201, '/rule/class/list', '查找规则类(所有)', 0, 0); INSERT INTO `core_url` VALUES (202, '/rule/class/method/page', '根据规则类查找规则方法(分页)', 0, 0); INSERT INTO `core_url` VALUES (203, '/rule/class/method/exist', '根据规则类查找已存在的规则方法', 0, 0); INSERT INTO `core_url` VALUES (204, '/rule/class/method/update', '规则方法修改', 1, 0); INSERT INTO `core_url` VALUES (205, '/rule/class/method/add', '规则方法新增', 1, 0); INSERT INTO `core_url` VALUES (206, '/rule/class/method/test', '规则方法测试', 1, 0); INSERT INTO `core_url` VALUES (207, '/coreMethod/exe', '执行方法', 1, 0); INSERT INTO `core_url` VALUES (208, '/fraud/black/save', '新增/修改欺诈黑名单', 1, 0); INSERT INTO `core_url` VALUES (209, '/fraud/black/status/update', '修改欺诈黑名单状态(1复核通过,2复核拒绝)', 1, 0); INSERT INTO `core_url` VALUES (210, '/fraud/black/findOne', '根据id查询黑名单', 0, 0); INSERT INTO `core_url` VALUES (211, '/fraud/black/delete', '根据id逻辑删除黑名单', 1, 0); INSERT INTO `core_url` VALUES (212, '/fraud/black/all/page', '查询黑名单记录', 0, 0); INSERT INTO `core_url` VALUES (213, '/monitor/operation/screen', '运营大屏', 0, 0); INSERT INTO `core_url` VALUES (214, '/monitor/rating/stability', '评分稳定性', 0, 0); INSERT INTO `core_url` VALUES (215, '/monitor/model/pass/rate', '模型通过率', 0, 0); INSERT INTO `core_url` VALUES (216, '/monitor/score/interval/distribution', '评分区间分布', 0, 0); INSERT INTO `core_url` VALUES (217, '/knowledges/packageVariable/get', '获取特定类型的变量名', 0, 1); INSERT INTO `core_url` VALUES (218, '/knowledges/packageVariable/save', '保存变量名', 0, 1); INSERT INTO `core_url` VALUES (219, '/department/childrenList', '查的用户部门及子部门', 0, 1); INSERT INTO `core_url` VALUES (220, '/flag/saveFile', '导入标签文件', 0, 0); INSERT INTO `core_url` VALUES (221, '/flag/list/unused', '查询未使用标签', 0, 0); INSERT INTO `core_url` VALUES (222, '/monitor/model/pass/hoursrate', '模型通过率(小时)', 0, 0); INSERT INTO `core_url` VALUES (224, '/statis/compare/scoreSubarea', '分数区间查询', 0, 0); INSERT INTO `core_url` VALUES (225, '/monitor/score/models', '获取评分模型列表', 0, 0); INSERT INTO `core_url` VALUES (227, '/excel/template/flag', '导出标签模板', 0, 0); INSERT INTO `core_url` VALUES (228, '/subarea/all', '分数区间列表', 0, 1); INSERT INTO `core_url` VALUES (229, '/subarea/save', '分数区间保存', 0, 0); INSERT INTO `core_url` VALUES (230, '/subarea/del', '分数区间删除', 0, 0); INSERT INTO `core_url` VALUES (232, '/flag/job/stop', '暂停跑批', 1, 0); INSERT INTO `core_url` VALUES (233, '/statis/compare/ruleAccuracy', '规则命中查询', 0, 0); INSERT INTO `core_url` VALUES (234, '/monitor/model/record/models', '获取机构下已跑模型', 0, 0); INSERT INTO `core_url` VALUES (235, '/monitor/score/characteristic/variable', '获取评分特征变量', 0, 0); INSERT INTO `core_url` VALUES (236, '/monitor/score/stability/analysis', '评分特征稳定性分析', 0, 0); INSERT INTO `core_url` VALUES (237, '/statis/compare/ruleDistribute', '拒绝原因分布查询', 0, 0); INSERT INTO `core_url` VALUES (238, '/statis/compare/ruleStatistics', '规则命中统计查询', 0, 0); INSERT INTO `core_url` VALUES (239, '/change/department', '切换机构', 1, 1); INSERT INTO `core_url` VALUES (240, '/model/warehouse/product/names', '获取本机构项目列表', 0, 0); INSERT INTO `core_url` VALUES (241, '/model/warehouse/product/addShare', '新增分享项目', 1, 0); INSERT INTO `core_url` VALUES (242, '/model/warehouse/product/import', '导入分享项目', 1, 0); INSERT INTO `core_url` VALUES (243, '/model/warehouse/product/updateShare', '修改分享项目', 1, 0); INSERT INTO `core_url` VALUES (244, '/model/warehouse/product/deleteShare', '删除分享项目', 1, 0); INSERT INTO `core_url` VALUES (245, '/model/warehouse/product/queryList', '查询分享项目(分页)', 0, 0); INSERT INTO `core_url` VALUES (246, '/model/scenes/add', '新增场景', 1, 0); INSERT INTO `core_url` VALUES (247, '/model/scenes/update', '修改场景', 1, 0); INSERT INTO `core_url` VALUES (248, '/model/scenes/delete', '删除场景', 1, 0); INSERT INTO `core_url` VALUES (249, '/model/scenes/query', '查询场景(分页)', 0, 0); INSERT INTO `core_url` VALUES (250, '/model/scenes/list', '查询场景列表', 0, 1); INSERT INTO `core_url` VALUES (251, '/sk12', '测试页面', 1, 1); INSERT INTO `core_url` VALUES (252, '/sk2 ', '测试页面', 1, 1); INSERT INTO `core_url` VALUES (253, '/function/add', '新增权限', 1, 0); INSERT INTO `core_url` VALUES (254, '/date/subarea/save', '新增', 1, 0); INSERT INTO `core_url` VALUES (255, '888', '删除', 1, 0); INSERT INTO `core_url` VALUES (256, '/driverClassConfig/findAll', '数据源管理', 1, 0); INSERT INTO `core_url` VALUES (257, '/sk1', '测试页面111', 1, 0); INSERT INTO `core_url` VALUES (258, '/knowledges/downloadApi', '模型参数配置', 1, 0); INSERT INTO `core_url` VALUES (263, '/dataSource/list', '数据源管理', 1, 0); INSERT INTO `core_url` VALUES (264, '/dataSource/add', '数据源管理', 1, 0); INSERT INTO `core_url` VALUES (265, '/dataSource/update', '数据源管理', 1, 0); INSERT INTO `core_url` VALUES (266, '/dataSource/delete', '数据源管理', 1, 0); INSERT INTO `core_url` VALUES (267, '/dataConfigSql/list', 'SQL管理', 1, 0); INSERT INTO `core_url` VALUES (268, '/dataConfigSql/add', 'SQL管理', 1, 0); INSERT INTO `core_url` VALUES (269, '/dataConfigSql/update', 'SQL管理', 1, 0); INSERT INTO `core_url` VALUES (270, '/dataConfigSql/delete', 'SQL管理', 1, 0); INSERT INTO `core_url` VALUES (271, '/dataConfigTable/findTablesFiledsBySqlId', 'SQL管理', 1, 0); INSERT INTO `core_url` VALUES (272, '/dataConfigTable/addTableAndFields', 'SQL管理', 1, 0); INSERT INTO `core_url` VALUES (273, '/dataConfigTable/update', 'SQL管理', 1, 0); INSERT INTO `core_url` VALUES (274, '/dataConfigTable/delete', 'SQL管理', 1, 0); INSERT INTO `core_url` VALUES (275, '/dataConfigTableField/add', 'SQL管理', 1, 0); INSERT INTO `core_url` VALUES (276, '/dataConfigTableField/update', 'SQL管理', 1, 0); INSERT INTO `core_url` VALUES (277, '/dataConfigTableField/delete', 'SQL管理', 1, 0); INSERT INTO `core_url` VALUES (278, '/dataConfigSqlEntry/list', 'SQL管理', 1, 0); INSERT INTO `core_url` VALUES (279, '/dataConfigSqlEntry/add', 'SQL管理', 1, 0); INSERT INTO `core_url` VALUES (280, '/dataConfigSqlEntry/update', 'SQL管理', 1, 0); INSERT INTO `core_url` VALUES (281, '/dataConfigSqlEntry/delete', 'SQL管理', 1, 0); INSERT INTO `core_url` VALUES (282, '/date/dictionary/update', '修改', 1, 0); INSERT INTO `core_url` VALUES (283, '/read/templat', '新增', 1, 0); INSERT INTO `core_url` VALUES (284, 'user/password/modify', '密码修改', 1, 0); INSERT INTO `core_url` VALUES (285, '/uruleUpdat', '查询', 1, 0); INSERT INTO `core_url` VALUES (286, '22', '查询', 1, 0); INSERT INTO `core_url` VALUES (287, 'knowledgelist/mine', '查询', 1, 0); INSERT INTO `core_url` VALUES (288, '/params/knowledge.vvv', '查询', 1, 0); INSERT INTO `core_url` VALUES (289, 'vvv', '查询', 1, 0); INSERT INTO `core_url` VALUES (290, 'tt', '查询', 1, 0); INSERT INTO `core_url` VALUES (291, '/urule/frame/impo', '规则管理', 1, 0); INSERT INTO `core_url` VALUES (292, '/core-origin/add', '数据源管理', 1, 0); INSERT INTO `core_url` VALUES (293, '/core-origin/page', '数据源管理', 1, 0); INSERT INTO `core_url` VALUES (294, '/core-origin/update', '数据源管理', 1, 0); INSERT INTO `core_url` VALUES (295, '/core-origin/getOne', '数据源管理', 1, 0); INSERT INTO `core_url` VALUES (296, '/core-origin/delete', '数据源管理', 1, 0); INSERT INTO `core_url` VALUES (297, '/core-api-data/page', '接口管理', 1, 0); INSERT INTO `core_url` VALUES (298, '/core-api-data/add', '接口管理', 1, 0); INSERT INTO `core_url` VALUES (299, '/core-api-data/delete', '接口管理', 1, 0); INSERT INTO `core_url` VALUES (300, '/core-api-data/getOne', '接口管理', 1, 0); INSERT INTO `core_url` VALUES (301, '/core-api-data/update', '接口管理', 1, 0); INSERT INTO `core_url` VALUES (302, '/core-origin/all', '接口管理', 1, 0); INSERT INTO `core_url` VALUES (303, '/model-method-template/getOne', '方法管理', 1, 0); INSERT INTO `core_url` VALUES (304, '/model-method-template/update', '方法管理', 1, 0); INSERT INTO `core_url` VALUES (305, '/model-method-template/delete', '方法管理', 1, 0); INSERT INTO `core_url` VALUES (306, '/model-method-template/save', '方法管理', 1, 0); INSERT INTO `core_url` VALUES (307, '/model-method-template/page', '方法管理', 1, 0); INSERT INTO `core_url` VALUES (308, '/model-method-template-param/delete', '方法管理', 1, 0); INSERT INTO `core_url` VALUES (309, '/model-method-template-param/save', '方法管理', 1, 0); INSERT INTO `core_url` VALUES (310, '/model-param/page', '模型指标管理', 1, 0); INSERT INTO `core_url` VALUES (311, '/model-param-fetch-ship/update', '模型指标管理', 1, 0); INSERT INTO `core_url` VALUES (312, '/model-param-fetch-ship/delete', '模型指标管理', 1, 0); INSERT INTO `core_url` VALUES (313, '/model-param-fetch-ship/findModelParamFetchShipDto', '模型指标管理', 1, 0); INSERT INTO `core_url` VALUES (314, '/model-param-fetch-ship/add', '模型指标管理', 1, 0); INSERT INTO `core_url` VALUES (315, '/model-param/fetchModelParamList', '模型指标管理', 1, 0); INSERT INTO `core_url` VALUES (316, '/core-partner/page', '合作商管理', 1, 0); INSERT INTO `core_url` VALUES (317, '/core-partner/add', '合作商管理', 1, 0); INSERT INTO `core_url` VALUES (318, '/core-partner/delete', '合作商管理', 1, 0); INSERT INTO `core_url` VALUES (319, '/core-partner/getOne', '合作商管理', 1, 0); INSERT INTO `core_url` VALUES (320, '/core-partner/update', '合作商管理', 1, 0); INSERT INTO `core_url` VALUES (321, '/core-product/add', '产品管理', 1, 0); INSERT INTO `core_url` VALUES (322, '/core-product/getOne', '产品管理', 1, 0); INSERT INTO `core_url` VALUES (323, '/core-product/page', '产品管理', 1, 0); INSERT INTO `core_url` VALUES (324, '/core-product/update', '产品管理', 1, 0); INSERT INTO `core_url` VALUES (325, '/core-product/delete', '产品管理', 1, 0); INSERT INTO `core_url` VALUES (326, '/core-transaction-type/add', '产品交易类型管理', 1, 0); INSERT INTO `core_url` VALUES (327, '/core-transaction-type/update', '产品交易类型管理', 1, 0); INSERT INTO `core_url` VALUES (328, '/core-transaction-type/page', '产品交易类型管理', 1, 0); INSERT INTO `core_url` VALUES (329, '/core-transaction-type/getOne', '产品交易类型管理', 1, 0); INSERT INTO `core_url` VALUES (330, '/core-transaction-type/delete', '产品交易类型管理', 1, 0); INSERT INTO `core_url` VALUES (331, '/core-partner/list', '产品管理', 1, 0); INSERT INTO `core_url` VALUES (332, '/core-transaction-type/list', '产品管理', 1, 0); INSERT INTO `core_url` VALUES (333, '/model/update', '模型管理', 1, 0); INSERT INTO `core_url` VALUES (334, '/model/list/all', '模型管理', 1, 0); INSERT INTO `core_url` VALUES (335, '/model/updateStatus', '模型管理', 1, 0); INSERT INTO `core_url` VALUES (336, '/model/page', '模型管理', 1, 0); INSERT INTO `core_url` VALUES (337, '/model/add', '模型管理', 1, 0); INSERT INTO `core_url` VALUES (338, '/model/fetchModelList', '模型管理', 1, 0); INSERT INTO `core_url` VALUES (339, '/model/list/enable', '模型管理', 1, 0); INSERT INTO `core_url` VALUES (340, '/model/delete', '模型管理', 1, 0); INSERT INTO `core_url` VALUES (341, '/core-api-data-field/add', '接口字段管理', 1, 0); INSERT INTO `core_url` VALUES (342, '/core-api-data-field/page', '接口字段管理', 1, 0); INSERT INTO `core_url` VALUES (343, '/core-api-data-field/delete', '接口字段管理', 1, 0); INSERT INTO `core_url` VALUES (344, '/core-api-data-field/addBatch', '接口字段管理', 1, 0); INSERT INTO `core_url` VALUES (345, '/core-api-data-field/update', '接口字段管理', 1, 0); INSERT INTO `core_url` VALUES (346, '/core-send-param/add', '上送参数管理', 1, 0); INSERT INTO `core_url` VALUES (347, '/core-send-param/update', '上送参数管理', 1, 0); INSERT INTO `core_url` VALUES (348, '/core-send-param/getOne', '上送参数管理', 1, 0); INSERT INTO `core_url` VALUES (349, '/core-send-param/page', '上送参数管理', 1, 0); INSERT INTO `core_url` VALUES (350, '/core-send-param/delete', '上送参数管理', 1, 0); INSERT INTO `core_url` VALUES (351, '/core-api-data-field/getFields', '接口字段管理', 1, 0); INSERT INTO `core_url` VALUES (352, '/core-api-data/list', '接口字段管理', 1, 0); INSERT INTO `core_url` VALUES (353, '/core-product-transaction-type-model-ship/pageByProductTransactionTypeIds', '产品模型关系管理', 1, 0); INSERT INTO `core_url` VALUES (354, '/core-product-transaction-type-model-ship/updateProductTransactionTypeModelShip', '产品模型关系管理', 1, 0); INSERT INTO `core_url` VALUES (355, '/core-product-transaction-type-model-ship/deleteProductTransactionTypeModelShipList', '产品模型关系管理', 1, 0); INSERT INTO `core_url` VALUES (356, '/core-product/findByPartnerId', '产品模型关系管理', 1, 0); INSERT INTO `core_url` VALUES (357, '/core-product-transaction-type-model-ship/pageByProductTransactionTypeId', '产品模型关系管理', 1, 0); INSERT INTO `core_url` VALUES (358, '/core-product-transaction-type-model-ship/addProductTransactionTypeModelShipList', '产品模型关系管理', 1, 0); INSERT INTO `core_url` VALUES (359, '/core-product-transaction-type-model-ship/findByProductTransactionTypeId', '产品模型关系管理', 1, 0); INSERT INTO `core_url` VALUES (360, 's/core-product-transaction-type-model-ship/deleteModelByIds', '产品模型关系管理', 1, 0); INSERT INTO `core_url` VALUES (361, '/model-product-transaction-api-order/findByProductTransactionShipId', '产品模型关系管理', 1, 0); INSERT INTO `core_url` VALUES (362, '/model-product-transaction-api-order/saveModelProductTransactionApiOrder', '产品模型关系管理', 1, 0); INSERT INTO `core_url` VALUES (363, '/model-product-transaction-return-field/deleteOne', '产品模型关系管理', 1, 0); INSERT INTO `core_url` VALUES (364, '/model-product-transaction-return-field/updateModelProductTransactionReturnField', '产品模型关系管理', 1, 0); INSERT INTO `core_url` VALUES (365, 'GET /model-product-transaction-return-field/findList', '产品模型关系管理', 1, 0); INSERT INTO `core_url` VALUES (366, '/model-product-transaction-return-field/addOne', '产品模型关系管理', 1, 0); INSERT INTO `core_url` VALUES (367, '/core-partner/tokenCorePartner', '模型指标管理', 1, 0); INSERT INTO `core_url` VALUES (368, '/core-api-data-field/list', '模型指标管理', 1, 0); INSERT INTO `core_url` VALUES (369, '/core-send-param/list', '模型指标管理', 1, 0); INSERT INTO `core_url` VALUES (370, '/model-param-fetch-ship/findOtherModelParams', '模型指标管理', 1, 0); INSERT INTO `core_url` VALUES (371, '/business/core-transaction-type/delete', '删除', 1, 0); INSERT INTO `core_url` VALUES (372, '/api-credit-request/getOne', '查询记录', 1, 0); INSERT INTO `core_url` VALUES (373, '/api-credit-request/page', '查询记录', 1, 0); INSERT INTO `core_url` VALUES (374, '/core-api-data/updateStatus', '接口管理', 1, 0); -- ---------------------------- -- Table structure for core_user -- ---------------------------- DROP TABLE IF EXISTS `core_user`; CREATE TABLE `core_user` ( `id` int(0) NOT NULL AUTO_INCREMENT, `username` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名,唯一', `password` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码，MD5加密', `mobile` char(24) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机号', `created_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态0-锁定，1-未锁定', `role_id` int(0) NULL DEFAULT NULL COMMENT '角色id', `department_id` int(0) NULL DEFAULT NULL COMMENT '部门id（暂时代表机构id）', `is_admin` tinyint(1) NULL DEFAULT NULL COMMENT '1-管理员 0-非管理员', `type` tinyint(1) NULL DEFAULT NULL COMMENT '账户类型：0-管理台账户 1-引擎接口账户', `update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '修改时间', `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户姓名（中文）', `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户邮箱', `api_code` int(0) NULL DEFAULT NULL COMMENT '引擎接口调用码', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 160 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of core_user -- ---------------------------- INSERT INTO `core_user` VALUES (1, 'admin', 'f677beb71c6ec3a6d1aade499648665c', '18058129195', '2019-04-23 16:32:04', 0, 1, 1, 1, 0, '2022-06-10 17:04:53', NULL, NULL, NULL); INSERT INTO `core_user` VALUES (3, 'wangsong', 'e10adc3949ba59abbe56e057f20f883e', '18251853816', '2020-02-18 10:13:49', 0, 1, 1, 0, 0, '2020-01-19 15:38:50', NULL, NULL, NULL); INSERT INTO `core_user` VALUES (159, 'ws', 'e10adc3949ba59abbe56e057f20f883e', '15155555555', '2021-11-16 14:45:31', 0, 1, 1, 0, 1, '2021-11-16 14:45:31', NULL, NULL, 41); SET FOREIGN_KEY_CHECKS = 1;