/* Navicat Premium Data Transfer Source Server : 250 Source Server Type : MySQL Source Server Version : 50743 Source Host : 192.168.0.250:3306 Source Schema : portal-platform Target Server Type : MySQL Target Server Version : 50743 File Encoding : 65001 Date: 19/12/2024 14:41:43 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for mortals_sys_base_area -- ---------------------------- DROP TABLE IF EXISTS `mortals_sys_base_area`; CREATE TABLE `mortals_sys_base_area` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '序号，主键，自增长', `ancestors` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '祖级列表，逗号分隔', `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域名称', `iid` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '一体化的ID号', `pid` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '一体化的父id', `haveSonArea` char(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否有下级区域（True.是，False.否）', `haveSonDept` char(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否有下级部门（True.是，False.否）', `haveGetDept` char(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否获取部门（true.是，false.否）', `haveGetMatterList` char(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否获取事项列表（true.是，false.否）', `areaCode` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域编码', `areaLevel` tinyint(2) NULL DEFAULT 1 COMMENT '区域等级(1.省，2.地市州，3.区县，4.街道，5.社区)', `shortName` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称简称', `domain` varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '访问地址', `status` tinyint(2) NULL DEFAULT 1 COMMENT '区域状态 (0.停用，1.正常)', `createTime` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '创建时间', `createUserId` bigint(20) NULL DEFAULT NULL COMMENT '创建用户', `updateTime` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '修改时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 36357 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '区域表'; -- ---------------------------- -- Records of mortals_sys_base_area -- ---------------------------- BEGIN; INSERT INTO `mortals_sys_base_area` VALUES (1, '', '四川省', '6182157d00ce41559e001a89d87f4057', '0', 'True', 'True', 'true', 'true', '510000000000', 1, '四川省', 'www.sczwfw.gov.cn', 1, '2021-07-19 11:28:28', NULL, '2022-03-17 13:39:30'), (2, '', '成都市', 'a1c5bc973eb74529b9329bcfd9680056', '6182157d00ce41559e001a89d87f4057', 'True', 'True', 'false', 'false', '510100000000', 2, '成都市', 'cds.sczwfw.gov.cn', 1, '2021-07-19 11:28:28', NULL, NULL), (3, '', '青羊区', '50295ca431d048df9d745888e7a0932e', 'a1c5bc973eb74529b9329bcfd9680056', 'True', 'True', 'false', 'false', '510105000000', 3, '青羊区', 'cdsqyq.sczwfw.gov.cn', 1, '2021-07-19 11:28:29', NULL, NULL), (4, '', '蔡桥街道', 'd7fb8c9d35cb4321852917d7873c16f6', '50295ca431d048df9d745888e7a0932e', 'True', 'True', 'false', 'false', '510105521000', 4, '蔡桥街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510105521000', 1, '2021-07-19 11:28:29', NULL, NULL), (13, '', '康河街道', '74d04e1e670a4a7f9a600d6c351679d7', '50295ca431d048df9d745888e7a0932e', 'True', 'True', 'false', 'false', '510105839000', 4, '康河街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510105839000', 1, '2021-07-19 11:28:29', NULL, NULL), (18, '', '文家街道', '9e46ba17093e4dda98f878fff64c5f05', '50295ca431d048df9d745888e7a0932e', 'True', 'True', 'false', 'false', '510105212000', 4, '文家街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510105212000', 1, '2021-07-19 11:28:30', NULL, NULL), (24, '', '黄田坝街道', 'd9b2e5e3150e4d31829319d58db97ef3', '50295ca431d048df9d745888e7a0932e', 'True', 'True', 'false', 'false', '510105441000', 4, '黄田坝街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510105441000', 1, '2021-07-19 11:28:30', NULL, NULL), (32, '', '草堂街道', 'e6bb4ab583d24899b15e61055668133c', '50295ca431d048df9d745888e7a0932e', 'True', 'True', 'false', 'false', '510105518000', 4, '草堂街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510105518000', 1, '2021-07-19 11:28:31', NULL, NULL), (38, '', '苏坡街道', '82f2d0188dad4006bab39a94bd7514e1', '50295ca431d048df9d745888e7a0932e', 'True', 'True', 'false', 'false', '510105568000', 4, '苏坡街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510105568000', 1, '2021-07-19 11:28:31', NULL, NULL), (45, '', '西御河街道', '72f56a79cc4048a58cc671514449c6cd', '50295ca431d048df9d745888e7a0932e', 'True', 'True', 'false', 'false', '510105593000', 4, '西御河街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510105593000', 1, '2021-07-19 11:28:32', NULL, NULL), (51, '', '少城街道', '65c3d84d59f64f7e81da2d82486beafe', '50295ca431d048df9d745888e7a0932e', 'True', 'True', 'false', 'false', '510105607000', 4, '少城街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510105607000', 1, '2021-07-19 11:28:32', NULL, NULL), (58, '', '金沙街道', '55d5520d18c6419899383ed79a1dc2f1', '50295ca431d048df9d745888e7a0932e', 'True', 'True', 'false', 'false', '510105708000', 4, '金沙街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510105708000', 1, '2021-07-19 11:28:33', NULL, NULL), (63, '', '府南街道', '5807e48e383f4c5583fa54b8bfeb2022', '50295ca431d048df9d745888e7a0932e', 'True', 'True', 'false', 'false', '510105885000', 4, '府南街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510105885000', 1, '2021-07-19 11:28:34', NULL, NULL), (70, '', '草市街街道', '6419b7d63e414264a40f87c2b878717c', '50295ca431d048df9d745888e7a0932e', 'True', 'True', 'false', 'false', '510105895000', 4, '草市街街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510105895000', 1, '2021-07-19 11:28:34', NULL, NULL), (76, '', '光华街道', 'e1c3262c2b3e4daeb2d983e92279d782', '50295ca431d048df9d745888e7a0932e', 'True', 'True', 'false', 'false', '510105922000', 4, '光华街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510105922000', 1, '2021-07-19 11:28:35', NULL, NULL), (83, '', '高新区', '0f5f8c010bce410fb9526e79ccf392ca', 'a1c5bc973eb74529b9329bcfd9680056', 'True', 'True', 'false', 'false', '510109000000', 3, '高新区', 'cdsgxq.sczwfw.gov.cn', 1, '2021-07-19 11:28:35', NULL, NULL), (84, '', '肖家河街道', '050c669f9e9d49d1a03270bbeed4e900', '0f5f8c010bce410fb9526e79ccf392ca', 'True', 'True', 'false', 'false', '510109001000', 4, '肖家河街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510109001000', 1, '2021-07-19 11:28:35', NULL, NULL), (92, '', '芳草街街道', 'acf76a314a524c37903aacbb998c60a6', '0f5f8c010bce410fb9526e79ccf392ca', 'True', 'True', 'false', 'false', '510109002000', 4, '芳草街街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510109002000', 1, '2021-07-19 11:28:36', NULL, NULL), (100, '', '石羊街道', '1c6cb7d99dec4fb49e1add2311e4ec8e', '0f5f8c010bce410fb9526e79ccf392ca', 'True', 'True', 'false', 'false', '510109003000', 4, '石羊街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510109003000', 1, '2021-07-19 11:28:36', NULL, NULL), (115, '', '桂溪街道', '99e1de4143f34964bff16ceda6fd85a9', '0f5f8c010bce410fb9526e79ccf392ca', 'True', 'True', 'false', 'false', '510109004000', 4, '桂溪街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510109004000', 1, '2021-07-19 11:28:38', NULL, NULL), (129, '', '合作街道', '32838a1ad0a64cdca1a69a653bcca01c', '0f5f8c010bce410fb9526e79ccf392ca', 'True', 'True', 'false', 'false', '510109005000', 4, '合作街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510109005000', 1, '2021-07-19 11:28:39', NULL, NULL), (132, '', '中和街道', '82560e19ec98475da6b3e0315bc50a73', '0f5f8c010bce410fb9526e79ccf392ca', 'True', 'True', 'false', 'false', '510109006000', 4, '中和街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510109006000', 1, '2021-07-19 11:28:39', NULL, NULL), (153, '', '西园街道', '3a1b376ce84648619c8fa058e1aefea6', '0f5f8c010bce410fb9526e79ccf392ca', 'True', 'True', 'false', 'false', '510109007000', 4, '西园街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510109007000', 1, '2021-07-19 11:28:41', NULL, NULL), (157, '', '天府新区（成都直管区）', 'e544a178ad5b4e2e8d3b465a2e70311e', 'a1c5bc973eb74529b9329bcfd9680056', 'True', 'True', 'false', 'false', '510110000000', 3, '天府新区', 'cdstfxq.sczwfw.gov.cn', 1, '2021-07-19 11:28:41', NULL, NULL), (158, '', '永兴街道', 'd50172d711eb4953845ccca612dea487', 'e544a178ad5b4e2e8d3b465a2e70311e', 'True', 'True', 'false', 'false', '510110212000', 4, '永兴街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510110212000', 1, '2021-07-19 11:28:41', NULL, NULL), (170, '', '新兴街道', '26b596bd67fb4dea942407c724b7cbdb', 'e544a178ad5b4e2e8d3b465a2e70311e', 'True', 'True', 'false', 'false', '510110235000', 4, '新兴街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510110235000', 1, '2021-07-19 11:28:42', NULL, NULL), (185, '', '正兴街道', 'f8e1b6cbaf1246dba12f42af8eddd932', 'e544a178ad5b4e2e8d3b465a2e70311e', 'True', 'True', 'false', 'false', '510110307000', 4, '正兴街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510110307000', 1, '2021-07-19 11:28:43', NULL, NULL), (196, '', '太平街道', '73137e144d094f1d8fab6e0b61c4af10', 'e544a178ad5b4e2e8d3b465a2e70311e', 'True', 'True', 'false', 'false', '510110321000', 4, '太平街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510110321000', 1, '2021-07-19 11:28:44', NULL, NULL), (210, '', '万安街道', '3c473d84e9b44b4a8ae6806b1360aeff', 'e544a178ad5b4e2e8d3b465a2e70311e', 'True', 'True', 'false', 'false', '510110417000', 4, '万安街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510110417000', 1, '2021-07-19 11:28:45', NULL, NULL), (225, '', '兴隆街道', '27966c05e0914d269705423b4cac978d', 'e544a178ad5b4e2e8d3b465a2e70311e', 'True', 'True', 'false', 'false', '510110474000', 4, '兴隆街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510110474000', 1, '2021-07-19 11:28:46', NULL, NULL), (235, '', '华阳街道', '13ccddfc8b644904bbf4ea21b218eb46', 'e544a178ad5b4e2e8d3b465a2e70311e', 'True', 'True', 'false', 'false', '510110498000', 4, '华阳街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510110498000', 1, '2021-07-19 11:28:47', NULL, NULL), (260, '', '籍田街道', 'ba0eb285f28e44018e21d1942021c896', 'e544a178ad5b4e2e8d3b465a2e70311e', 'True', 'True', 'false', 'false', '510110503000', 4, '籍田街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510110503000', 1, '2021-07-19 11:28:48', NULL, NULL), (280, '', '煎茶街道', 'ddfd2b410c394c51a3824c272d7df7f7', 'e544a178ad5b4e2e8d3b465a2e70311e', 'True', 'True', 'false', 'false', '510110916000', 4, '煎茶街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510110916000', 1, '2021-07-19 11:28:50', NULL, NULL), (290, '', '东部新区', '4a70caddca2a41a49a1ad02d7c11f785', 'a1c5bc973eb74529b9329bcfd9680056', 'True', 'True', 'false', 'false', '510186000000', 3, '东部新区', 'cdsdbxq.sczwfw.gov.cn', 1, '2021-07-19 11:28:50', NULL, NULL), (291, '', '养马街道', 'd32eba6e4ccf4ecab3eaf0a360342d69', '4a70caddca2a41a49a1ad02d7c11f785', 'True', 'True', 'false', 'false', '510186007013', 4, '养马街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510186007013', 1, '2021-07-19 11:28:51', NULL, NULL), (306, '', '海螺镇', '48439e99737444ed91a6801756fa1d61', '4a70caddca2a41a49a1ad02d7c11f785', 'True', 'True', 'false', 'false', '510186062006', 4, '海螺镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510186062006', 1, '2021-07-19 11:28:52', NULL, NULL), (316, '', '丹景街道', 'b3d1d724522b4185859ae610f5a6b037', '4a70caddca2a41a49a1ad02d7c11f785', 'True', 'True', 'false', 'false', '510186081003', 4, '丹景街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510186081003', 1, '2021-07-19 11:28:52', NULL, NULL), (327, '', '贾家街道', 'b5bae855439e49e0ab98a7450d7a396a', '4a70caddca2a41a49a1ad02d7c11f785', 'True', 'True', 'false', 'false', '510186144007', 4, '贾家街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510186144007', 1, '2021-07-19 11:28:53', NULL, NULL), (346, '', '壮溪镇', '6dea7b53b58245bf97125bb94eae7414', '4a70caddca2a41a49a1ad02d7c11f785', 'True', 'True', 'false', 'false', '510186198015', 4, '壮溪镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510186198015', 1, '2021-07-19 11:28:54', NULL, NULL), (352, '', '玉成街道', '5157f2ba8f924a549f556b90f85e6595', '4a70caddca2a41a49a1ad02d7c11f785', 'True', 'True', 'false', 'false', '510186211014', 4, '玉成街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510186211014', 1, '2021-07-19 11:28:55', NULL, NULL), (365, '', '草池街道', 'dd9aafe159764ef7940ab4c9a0c91591', '4a70caddca2a41a49a1ad02d7c11f785', 'True', 'True', 'false', 'false', '510186313011', 4, '草池街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510186313011', 1, '2021-07-19 11:28:56', NULL, NULL), (383, '', '石盘街道', '69e470688bfb4f508d1301b82fd3184b', '4a70caddca2a41a49a1ad02d7c11f785', 'True', 'True', 'false', 'false', '510186487010', 4, '石盘街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510186487010', 1, '2021-07-19 11:28:57', NULL, NULL), (404, '', '董家埂镇', '7f1a156478794d808ad524885c621a2d', '4a70caddca2a41a49a1ad02d7c11f785', 'True', 'True', 'false', 'false', '510186542001', 4, '董家埂镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510186542001', 1, '2021-07-19 11:28:59', NULL, NULL), (417, '', '高明镇', '4ae8f20086ae4993b280f1425e192460', '4a70caddca2a41a49a1ad02d7c11f785', 'True', 'True', 'false', 'false', '510186606005', 4, '高明镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510186606005', 1, '2021-07-19 11:29:00', NULL, NULL), (427, '', '武庙镇', '1ceec204680a44308fd280627e6887e0', '4a70caddca2a41a49a1ad02d7c11f785', 'True', 'True', 'false', 'false', '510186781012', 4, '武庙镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510186781012', 1, '2021-07-19 11:29:01', NULL, NULL), (435, '', '三岔街道', '52afca135f3a4c639d56d251e686d447', '4a70caddca2a41a49a1ad02d7c11f785', 'True', 'True', 'false', 'false', '510186880009', 4, '三岔街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510186880009', 1, '2021-07-19 11:29:01', NULL, NULL), (449, '', '福田街道', '2d6397efbe9f4b13bc7a1f96930e8437', '4a70caddca2a41a49a1ad02d7c11f785', 'True', 'True', 'false', 'false', '510186917004', 4, '福田街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510186917004', 1, '2021-07-19 11:29:02', NULL, NULL), (457, '', '芦葭镇', '4c756bded12b47b1ad05c5d2fa5ca46a', '4a70caddca2a41a49a1ad02d7c11f785', 'True', 'True', 'false', 'false', '510186932008', 4, '芦葭镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510186932008', 1, '2021-07-19 11:29:03', NULL, NULL), (473, '', '石板凳街道', 'f24b74cd4c894e06a8bf7b0c8aea535e', '4a70caddca2a41a49a1ad02d7c11f785', 'True', 'True', 'false', 'false', '510186960002', 4, '石板凳街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510186960002', 1, '2021-07-19 11:29:04', NULL, NULL), (484, '', '锦江区', 'badeb6d69ff24084b9d29840d6b3af92', 'a1c5bc973eb74529b9329bcfd9680056', 'True', 'True', 'false', 'false', '510104000000', 3, '锦江区', 'cdsjjq.sczwfw.gov.cn', 1, '2021-07-19 11:29:05', NULL, NULL), (485, '', '春熙路街道', '67f08f6df844425d804a33adc1005d5a', 'badeb6d69ff24084b9d29840d6b3af92', 'True', 'True', 'false', 'false', '510104003000', 4, '春熙路街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510104003000', 1, '2021-07-19 11:29:05', NULL, NULL), (490, '', '书院街街道', '906ac53485de41e98fd66a1fbf2cf292', 'badeb6d69ff24084b9d29840d6b3af92', 'True', 'True', 'false', 'false', '510104004000', 4, '书院街街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510104004000', 1, '2021-07-19 11:29:06', NULL, NULL), (495, '', '锦官驿街道', '01d31a1418a241cc95fe2c7fa25de3dd', 'badeb6d69ff24084b9d29840d6b3af92', 'True', 'True', 'false', 'false', '510104006000', 4, '锦官驿街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510104006000', 1, '2021-07-19 11:29:06', NULL, NULL), (502, '', '牛市口街道', '719d475bdf48495ea34acfde12a8ff2b', 'badeb6d69ff24084b9d29840d6b3af92', 'True', 'True', 'false', 'false', '510104007000', 4, '牛市口街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510104007000', 1, '2021-07-19 11:29:06', NULL, NULL), (513, '', '沙河街道', 'a5cd5d37560b4c3cbef9f827a2899213', 'badeb6d69ff24084b9d29840d6b3af92', 'True', 'True', 'false', 'false', '510104011000', 4, '沙河街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510104011000', 1, '2021-07-19 11:29:07', NULL, NULL), (521, '', '狮子山街道', '75ae79f658c84c9ba6de86be29fd5ab1', 'badeb6d69ff24084b9d29840d6b3af92', 'True', 'True', 'false', 'false', '510104013000', 4, '狮子山街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510104013000', 1, '2021-07-19 11:29:07', NULL, NULL), (528, '', '东湖街道', '980502924f72415a864c75a61b6fef3d', 'badeb6d69ff24084b9d29840d6b3af92', 'True', 'True', 'false', 'false', '510104012000', 4, '东湖街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510104012000', 1, '2021-07-19 11:29:08', NULL, NULL), (536, '', '锦华路街道', 'be347da242004aa882e46fd050bb667c', 'badeb6d69ff24084b9d29840d6b3af92', 'True', 'True', 'false', 'false', '510104008000', 4, '锦华路街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510104008000', 1, '2021-07-19 11:29:08', NULL, NULL), (544, '', '柳江街道', 'ebe3b6b76c404aa887ede22db500f931', 'badeb6d69ff24084b9d29840d6b3af92', 'True', 'True', 'false', 'false', '510104015000', 4, '柳江街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510104015000', 1, '2021-07-19 11:29:09', NULL, NULL), (551, '', '成龙路街道', '00426c506dd64283a5bcb57a0d64ca7e', 'badeb6d69ff24084b9d29840d6b3af92', 'True', 'True', 'false', 'false', '510104014000', 4, '成龙路街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510104014000', 1, '2021-07-19 11:29:09', NULL, NULL), (561, '', '三圣街道', '81f1ee0f423f43da8a71eef643627b8a', 'badeb6d69ff24084b9d29840d6b3af92', 'True', 'True', 'false', 'false', '510104016000', 4, '三圣街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510104016000', 1, '2021-07-19 11:29:10', NULL, NULL), (572, '', '金牛区', 'c2b2d00d6ee74e569ca68615f41fc984', 'a1c5bc973eb74529b9329bcfd9680056', 'True', 'True', 'false', 'false', '510106000000', 3, '金牛区', 'cdsjnq.sczwfw.gov.cn', 1, '2021-07-19 11:29:11', NULL, NULL), (573, '', '金泉街道', '532256af35714bbdba59513b100ce9a5', 'c2b2d00d6ee74e569ca68615f41fc984', 'True', 'True', 'false', 'false', '510106250000', 4, '金泉街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510106250000', 1, '2021-07-19 11:29:11', NULL, NULL), (584, '', '天回镇街道', '5ad0019281dc41c78038da3bae82b9ca', 'c2b2d00d6ee74e569ca68615f41fc984', 'True', 'True', 'false', 'false', '510106342000', 4, '天回镇街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510106342000', 1, '2021-07-19 11:29:12', NULL, NULL), (601, '', '九里堤街道', 'a179b9f1b1184ecab5f2456e23c57756', 'c2b2d00d6ee74e569ca68615f41fc984', 'True', 'True', 'false', 'false', '510106444000', 4, '九里堤街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510106444000', 1, '2021-07-19 11:29:13', NULL, NULL), (605, '', '五块石街道', 'f3b6ab188b4442078162321a617c0262', 'c2b2d00d6ee74e569ca68615f41fc984', 'True', 'True', 'false', 'false', '510106463000', 4, '五块石街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510106463000', 1, '2021-07-19 11:29:13', NULL, NULL), (609, '', '抚琴街道', '950afbe28fe743f1824115f28c512d48', 'c2b2d00d6ee74e569ca68615f41fc984', 'True', 'True', 'false', 'false', '510106488000', 4, '抚琴街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510106488000', 1, '2021-07-19 11:29:13', NULL, NULL), (617, '', '驷马桥街道', '35cbb7a6024a476aae662d106adca8fb', 'c2b2d00d6ee74e569ca68615f41fc984', 'True', 'True', 'false', 'false', '510106533000', 4, '驷马桥街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510106533000', 1, '2021-07-19 11:29:14', NULL, NULL), (624, '', '西华街道', 'c70cbd786de541468ca1e7b56016ad20', 'c2b2d00d6ee74e569ca68615f41fc984', 'True', 'True', 'false', 'false', '510106544000', 4, '西华街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510106544000', 1, '2021-07-19 11:29:14', NULL, NULL), (635, '', '沙河源街道', 'c3bd21692782445c8c3c9f880e6719a1', 'c2b2d00d6ee74e569ca68615f41fc984', 'True', 'True', 'false', 'false', '510106618000', 4, '沙河源街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510106618000', 1, '2021-07-19 11:29:15', NULL, NULL), (645, '', '西安路街道', 'ed84d41b690c44e49acda5d6abc39ff4', 'c2b2d00d6ee74e569ca68615f41fc984', 'True', 'True', 'false', 'false', '510106675000', 4, '西安路街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510106675000', 1, '2021-07-19 11:29:15', NULL, NULL), (653, '', '茶店子街道', 'd9046bfdcdde4778adb4b21839eb4b22', 'c2b2d00d6ee74e569ca68615f41fc984', 'True', 'True', 'false', 'false', '510106812000', 4, '茶店子街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510106812000', 1, '2021-07-19 11:29:16', NULL, NULL), (661, '', '营门口街道', '4bc8d89ca9d44387a67b7eb32645636e', 'c2b2d00d6ee74e569ca68615f41fc984', 'True', 'True', 'false', 'false', '510106828000', 4, '营门口街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510106828000', 1, '2021-07-19 11:29:16', NULL, NULL), (667, '', '凤凰山街道', '909daaba814c46c4a7f06b466a943f41', 'c2b2d00d6ee74e569ca68615f41fc984', 'True', 'True', 'false', 'false', '510106856000', 4, '凤凰山街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510106856000', 1, '2021-07-19 11:29:17', NULL, NULL), (670, '', '荷花池街道', '0eca123cba874200871b906716834cd1', 'c2b2d00d6ee74e569ca68615f41fc984', 'True', 'True', 'false', 'false', '510106929000', 4, '荷花池街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510106929000', 1, '2021-07-19 11:29:17', NULL, NULL), (676, '', '武侯区', '5b9c42a28f80417c94ce56d90de17b93', 'a1c5bc973eb74529b9329bcfd9680056', 'True', 'True', 'false', 'false', '510107000000', 3, '武侯区', 'cdswhq.sczwfw.gov.cn', 1, '2021-07-19 11:29:17', NULL, NULL), (677, '', '簇锦街道', '28d35c39ec9b4f2990e3ad2e2f2fcb7f', '5b9c42a28f80417c94ce56d90de17b93', 'True', 'True', 'false', 'false', '510107000365', 4, '簇锦街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510107000365', 1, '2021-07-19 11:29:17', NULL, NULL), (684, '', '望江路街道', 'b7902f7692aa420b8326f30f7bf0d5f5', '5b9c42a28f80417c94ce56d90de17b93', 'True', 'True', 'false', 'false', '510107000507', 4, '望江路街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510107000507', 1, '2021-07-19 11:29:18', NULL, NULL), (690, '', '玉林街道', 'dc7f25b06ce8421bbd3d459a3bbb3ca5', '5b9c42a28f80417c94ce56d90de17b93', 'True', 'True', 'false', 'false', '510107486000', 4, '玉林街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510107486000', 1, '2021-07-19 11:29:18', NULL, NULL), (702, '', '簇桥街道', '4e03f1d56b744070a0cff27005d06c35', '5b9c42a28f80417c94ce56d90de17b93', 'True', 'True', 'false', 'false', '510107497000', 4, '簇桥街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510107497000', 1, '2021-07-19 11:29:19', NULL, NULL), (708, '', '晋阳街道', 'd6c17e30570e4033a057a6085cd784c7', '5b9c42a28f80417c94ce56d90de17b93', 'True', 'True', 'false', 'false', '510107676000', 4, '晋阳街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510107676000', 1, '2021-07-19 11:29:19', NULL, NULL), (714, '', '火车南站街道', '907b014860c0432fb7183958c6eb117b', '5b9c42a28f80417c94ce56d90de17b93', 'True', 'True', 'false', 'false', '510107745000', 4, '火车南站街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510107745000', 1, '2021-07-19 11:29:19', NULL, NULL), (721, '', '红牌楼街道', '1b1543e35594418884b4e914bb6ddfd5', '5b9c42a28f80417c94ce56d90de17b93', 'True', 'True', 'false', 'false', '510107863000', 4, '红牌楼街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510107863000', 1, '2021-07-19 11:29:20', NULL, NULL), (729, '', '金花桥街道', 'cd5b4e3c6ffc4d31b324731b659972ac', '5b9c42a28f80417c94ce56d90de17b93', 'True', 'True', 'false', 'false', '510107918000', 4, '金花桥街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510107918000', 1, '2021-07-19 11:29:21', NULL, NULL), (738, '', '华兴街道', '9e2efc01058c45509046d99c8589e07e', '5b9c42a28f80417c94ce56d90de17b93', 'True', 'True', 'false', 'false', '510107923000', 4, '华兴街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510107923000', 1, '2021-07-19 11:29:22', NULL, NULL), (742, '', '浆洗街街道', 'd2d14aabd9134181bac1d26e2c9175cb', '5b9c42a28f80417c94ce56d90de17b93', 'True', 'True', 'false', 'false', '510107254000', 4, '浆洗街街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510107254000', 1, '2021-07-19 11:29:22', NULL, NULL), (752, '', '机投桥街道', 'ac35b9bbde964b9eaf34e6cb2b41426e', '5b9c42a28f80417c94ce56d90de17b93', 'True', 'True', 'false', 'false', '510107872000', 4, '机投桥街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510107872000', 1, '2021-07-19 11:29:23', NULL, NULL), (759, '', '成华区', 'ddaa012d77a84a3da555c156dd03b4b1', 'a1c5bc973eb74529b9329bcfd9680056', 'True', 'True', 'false', 'false', '510108000000', 3, '成华区', 'cdschq.sczwfw.gov.cn', 1, '2021-07-19 11:29:23', NULL, NULL), (760, '', '保和街道', '72e830a700d74f108f9b327acd7429d6', 'ddaa012d77a84a3da555c156dd03b4b1', 'True', 'True', 'false', 'false', '510108014000', 4, '保和街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510108014000', 1, '2021-07-19 11:29:23', NULL, NULL), (769, '', '龙潭街道', '8f0c2fe33aaf4169bae19a50e1286a8e', 'ddaa012d77a84a3da555c156dd03b4b1', 'True', 'True', 'false', 'false', '510108167000', 4, '龙潭街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510108167000', 1, '2021-07-19 11:29:24', NULL, NULL), (786, '', '猛追湾街道', '535c41f99fd14de1bac77f9cb53de117', 'ddaa012d77a84a3da555c156dd03b4b1', 'True', 'True', 'false', 'false', '510108170000', 4, '猛追湾街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510108170000', 1, '2021-07-19 11:29:25', NULL, NULL), (794, '', '白莲池街道', 'c1ecca0455e94856b9035129059a4e93', 'ddaa012d77a84a3da555c156dd03b4b1', 'True', 'True', 'false', 'false', '510108210000', 4, '白莲池街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510108210000', 1, '2021-07-19 11:29:26', NULL, NULL), (800, '', '万年场街道', 'c88aeeb2630248b69e71ce33678a4c4b', 'ddaa012d77a84a3da555c156dd03b4b1', 'True', 'True', 'false', 'false', '510108328000', 4, '万年场街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510108328000', 1, '2021-07-19 11:29:26', NULL, NULL), (806, '', '跳蹬河街道', '258629e2b60e493ba30b488b24cfe015', 'ddaa012d77a84a3da555c156dd03b4b1', 'True', 'True', 'false', 'false', '510108380000', 4, '跳蹬河街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510108380000', 1, '2021-07-19 11:29:27', NULL, NULL), (812, '', '府青路街道', '63a8ccaff99845718c9f429a49a761dd', 'ddaa012d77a84a3da555c156dd03b4b1', 'True', 'True', 'false', 'false', '510108542000', 4, '府青路街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510108542000', 1, '2021-07-19 11:29:27', NULL, NULL), (819, '', '双桥子街道', 'f28cbb5e770541018206fd67c407b410', 'ddaa012d77a84a3da555c156dd03b4b1', 'True', 'True', 'false', 'false', '510108637000', 4, '双桥子街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510108637000', 1, '2021-07-19 11:29:28', NULL, NULL), (828, '', '双水碾街道', '44d59e7ce4aa4bafaab5e24fef53a02b', 'ddaa012d77a84a3da555c156dd03b4b1', 'True', 'True', 'false', 'false', '510108767000', 4, '双水碾街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510108767000', 1, '2021-07-19 11:29:28', NULL, NULL), (834, '', '青龙街道', '6c806434d2704f85a5f3f19425c1382f', 'ddaa012d77a84a3da555c156dd03b4b1', 'True', 'True', 'false', 'false', '510108806000', 4, '青龙街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510108806000', 1, '2021-07-19 11:29:29', NULL, NULL), (843, '', '二仙桥街道', 'e71cbd4c62a34918af176d40656bda91', 'ddaa012d77a84a3da555c156dd03b4b1', 'True', 'True', 'false', 'false', '510108880000', 4, '二仙桥街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510108880000', 1, '2021-07-19 11:29:30', NULL, NULL), (853, '', '龙泉驿区', '9189f84698984a9594235310a25a9b63', 'a1c5bc973eb74529b9329bcfd9680056', 'True', 'True', 'false', 'false', '510112000000', 3, '龙泉驿区', 'cdslqyq.sczwfw.gov.cn', 1, '2021-07-19 11:29:30', NULL, NULL), (854, '', '东安街道', '5926733969d64a689a06909930cbbb07', '9189f84698984a9594235310a25a9b63', 'True', 'True', 'false', 'false', '510112009000', 4, '东安街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510112009000', 1, '2021-07-19 11:29:30', NULL, NULL), (862, '', '龙泉街道', 'c1a7ac5f36ec4c4bb2a7d2200aa02875', '9189f84698984a9594235310a25a9b63', 'True', 'True', 'false', 'false', '510112304000', 4, '龙泉街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510112304000', 1, '2021-07-19 11:29:31', NULL, NULL), (891, '', '洛带镇', '3e71c7be2d084b3685d566ca94b26488', '9189f84698984a9594235310a25a9b63', 'True', 'True', 'false', 'false', '510112371000', 4, '洛带镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510112371000', 1, '2021-07-19 11:29:33', NULL, NULL), (899, '', '山泉镇', '8646a2275bf643d0b3edd7b6374e4b26', '9189f84698984a9594235310a25a9b63', 'True', 'True', 'false', 'false', '510112469000', 4, '山泉镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510112469000', 1, '2021-07-19 11:29:33', NULL, NULL), (909, '', '洪安镇', '91228ce596424a939a28599d1dcd9e49', '9189f84698984a9594235310a25a9b63', 'True', 'True', 'false', 'false', '510112521000', 4, '洪安镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510112521000', 1, '2021-07-19 11:29:34', NULL, NULL), (919, '', '柏合街道', '1bba7c2b5b52456bb4eb58aef0758d9a', '9189f84698984a9594235310a25a9b63', 'True', 'True', 'false', 'false', '510112543000', 4, '柏合街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510112543000', 1, '2021-07-19 11:29:35', NULL, NULL), (932, '', '同安街道', 'de61ea778a434c7295dfcd6481e806b1', '9189f84698984a9594235310a25a9b63', 'True', 'True', 'false', 'false', '510112709000', 4, '同安街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510112709000', 1, '2021-07-19 11:29:37', NULL, NULL), (941, '', '十陵街道', 'eff42613573f407f842950b9ece21a9c', '9189f84698984a9594235310a25a9b63', 'True', 'True', 'false', 'false', '510112724000', 4, '十陵街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510112724000', 1, '2021-07-19 11:29:37', NULL, NULL), (954, '', '西河街道', 'f322897275264c159f8540f12c583e5d', '9189f84698984a9594235310a25a9b63', 'True', 'True', 'false', 'false', '510112731000', 4, '西河街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510112731000', 1, '2021-07-19 11:29:38', NULL, NULL), (970, '', '大面街道', '2a13a57649184872bdf034739529af6c', '9189f84698984a9594235310a25a9b63', 'True', 'True', 'false', 'false', '510112932000', 4, '大面街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510112932000', 1, '2021-07-19 11:29:39', NULL, NULL), (987, '', '青白江区', '5e7665c09cc14d538805b8899835f029', 'a1c5bc973eb74529b9329bcfd9680056', 'True', 'True', 'false', 'false', '510113000000', 3, '青白江区', 'cdsqbjq.sczwfw.gov.cn', 1, '2021-07-19 11:29:41', NULL, NULL), (988, '', '清泉镇', 'ee938dbab5744e42b9536e42fcd4477d', '5e7665c09cc14d538805b8899835f029', 'True', 'True', 'false', 'false', '510113119000', 4, '清泉镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510113119000', 1, '2021-07-19 11:29:41', NULL, NULL), (1001, '', '城厢镇', 'aa93d317c425486aa614782136a6438c', '5e7665c09cc14d538805b8899835f029', 'True', 'True', 'false', 'false', '510113134000', 4, '城厢镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510113134000', 1, '2021-07-19 11:29:41', NULL, NULL), (1017, '', '弥牟镇', 'de0fa32eb5b246aab528efa9a087faf9', '5e7665c09cc14d538805b8899835f029', 'True', 'True', 'false', 'false', '510113325000', 4, '弥牟镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510113325000', 1, '2021-07-19 11:29:42', NULL, NULL), (1025, '', '大弯街道', '96583fa99c2f46ac83d6a2a0cd255e40', '5e7665c09cc14d538805b8899835f029', 'True', 'True', 'false', 'false', '510113688000', 4, '大弯街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510113688000', 1, '2021-07-19 11:29:43', NULL, NULL), (1044, '', '福洪镇', '8423209a2fd94d399102d42d0d30e43a', '5e7665c09cc14d538805b8899835f029', 'True', 'True', 'false', 'false', '510113736000', 4, '福洪镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510113736000', 1, '2021-07-19 11:29:44', NULL, NULL), (1054, '', '大同街道', '9ceaf7b3c94542b099b0877bf391c8ae', '5e7665c09cc14d538805b8899835f029', 'True', 'True', 'false', 'false', '510113899000', 4, '大同街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510113899000', 1, '2021-07-19 11:29:44', NULL, NULL), (1063, '', '姚渡镇', '24833f5fbd7549d099e944ea2e5b0533', '5e7665c09cc14d538805b8899835f029', 'True', 'True', 'false', 'false', '510113995000', 4, '姚渡镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510113995000', 1, '2021-07-19 11:29:45', NULL, NULL), (1078, '', '新都区', '8e22639b66c64a71b93acd6b77330b46', 'a1c5bc973eb74529b9329bcfd9680056', 'True', 'True', 'false', 'false', '510114000000', 3, '新都区', 'cdsxdq.sczwfw.gov.cn', 1, '2021-07-19 11:29:46', NULL, NULL), (1079, '', '桂湖街道', '9818d182c6e8496a8c49b18bd16d88f3', '8e22639b66c64a71b93acd6b77330b46', 'True', 'True', 'false', 'false', '510114008000', 4, '桂湖街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510114008000', 1, '2021-07-19 11:29:46', NULL, NULL), (1107, '', '大丰街道', '44c0e309eecb4123b13e9c35390ecbef', '8e22639b66c64a71b93acd6b77330b46', 'True', 'True', 'false', 'false', '510114158000', 4, '大丰街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510114158000', 1, '2021-07-19 11:29:48', NULL, NULL), (1121, '', '斑竹园街道', '51939b7eb7b24e0e9954750edc9f2673', '8e22639b66c64a71b93acd6b77330b46', 'True', 'True', 'false', 'false', '510114277000', 4, '斑竹园街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510114277000', 1, '2021-07-19 11:29:49', NULL, NULL), (1144, '', '石板滩街道', '4e97b186e3f94cad9c0db526f3de4ab4', '8e22639b66c64a71b93acd6b77330b46', 'True', 'True', 'false', 'false', '510114328000', 4, '石板滩街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510114328000', 1, '2021-07-19 11:29:51', NULL, NULL), (1169, '', '军屯镇', 'ed0d10dab4d7496fa8494aae15e1b196', '8e22639b66c64a71b93acd6b77330b46', 'True', 'True', 'false', 'false', '510114387000', 4, '军屯镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510114387000', 1, '2021-07-19 11:29:52', NULL, NULL), (1185, '', '清流镇', '30cd57fe31674d98abab207654389716', '8e22639b66c64a71b93acd6b77330b46', 'True', 'True', 'false', 'false', '510114515000', 4, '清流镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510114515000', 1, '2021-07-19 11:29:53', NULL, NULL), (1194, '', '新繁街道', '423fc35348da40589ed9497edee6bc11', '8e22639b66c64a71b93acd6b77330b46', 'True', 'True', 'false', 'false', '510114857000', 4, '新繁街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510114857000', 1, '2021-07-19 11:29:53', NULL, NULL), (1230, '', '三河街道', 'a07bfd8b19fb4446a286bfa582b1045e', '8e22639b66c64a71b93acd6b77330b46', 'True', 'True', 'false', 'false', '510114887000', 4, '三河街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510114887000', 1, '2021-07-19 11:29:56', NULL, NULL), (1238, '', '新都街道', 'ec4d871d8fc349caa06f217e7511b9bc', '8e22639b66c64a71b93acd6b77330b46', 'True', 'True', 'false', 'false', '510114888000', 4, '新都街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510114888000', 1, '2021-07-19 11:29:57', NULL, NULL), (1269, '', '温江区', 'e16162264ace4a30b171a194e5d12e45', 'a1c5bc973eb74529b9329bcfd9680056', 'True', 'True', 'false', 'false', '510115000000', 3, '温江区', 'cdswjq.sczwfw.gov.cn', 1, '2021-07-19 11:30:00', NULL, NULL), (1270, '', '柳城街道', '05adf0eae1754aa19f6a8d4aeb6ef2ff', 'e16162264ace4a30b171a194e5d12e45', 'True', 'True', 'false', 'false', '510115001000', 4, '柳城街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510115001000', 1, '2021-07-19 11:30:00', NULL, NULL), (1290, '', '公平街道', '1b1c43e79ab445298d80d74890253dab', 'e16162264ace4a30b171a194e5d12e45', 'True', 'True', 'false', 'false', '510115002000', 4, '公平街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510115002000', 1, '2021-07-19 11:30:01', NULL, NULL), (1301, '', '涌泉街道', '8af9d9f452c84282a49c74818ee031d0', 'e16162264ace4a30b171a194e5d12e45', 'True', 'True', 'false', 'false', '510115003000', 4, '涌泉街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510115003000', 1, '2021-07-19 11:30:02', NULL, NULL), (1312, '', '天府街道', 'c1b2a6411c4546d2ad531e580278f9f7', 'e16162264ace4a30b171a194e5d12e45', 'True', 'True', 'false', 'false', '510115004000', 4, '天府街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510115004000', 1, '2021-07-19 11:30:03', NULL, NULL), (1320, '', '和盛镇', 'd2594503db9c4761aa86bb80487ace03', 'e16162264ace4a30b171a194e5d12e45', 'True', 'True', 'false', 'false', '510115101000', 4, '和盛镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510115101000', 1, '2021-07-19 11:30:03', NULL, NULL), (1332, '', '万春镇', '2a1215d655b0488ea2fc107ddcec2f0f', 'e16162264ace4a30b171a194e5d12e45', 'True', 'True', 'false', 'false', '510115105000', 4, '万春镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510115105000', 1, '2021-07-19 11:30:04', NULL, NULL), (1347, '', '寿安镇', '35416cbf67784ce3afd0f342c0f7b92a', 'e16162264ace4a30b171a194e5d12e45', 'True', 'True', 'false', 'false', '510115106000', 4, '寿安镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510115106000', 1, '2021-07-19 11:30:05', NULL, NULL), (1358, '', '永宁街道', '0e7dacea1d7745889a6d743d7b00f189', 'e16162264ace4a30b171a194e5d12e45', 'True', 'True', 'false', 'false', '510115521000', 4, '永宁街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510115521000', 1, '2021-07-19 11:30:06', NULL, NULL), (1364, '', '金马街道', '71b0c06f8fc046abb73d15e39271af1f', 'e16162264ace4a30b171a194e5d12e45', 'True', 'True', 'false', 'false', '510115907000', 4, '金马街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510115907000', 1, '2021-07-19 11:30:06', NULL, NULL), (1375, '', '双流区', '9f39c70e1306458980c4b6a700981b6d', 'a1c5bc973eb74529b9329bcfd9680056', 'True', 'True', 'false', 'false', '510116000000', 3, '双流区', 'cdsslq.sczwfw.gov.cn', 1, '2021-07-19 11:30:07', NULL, NULL), (1376, '', '怡心街道', '38771d507e6f440e8c2645af65c887d9', '9f39c70e1306458980c4b6a700981b6d', 'True', 'True', 'false', 'false', '510116100000', 4, '怡心街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510116100000', 1, '2021-07-19 11:30:07', NULL, NULL), (1389, '', '九江街道', '1bad94a89e614aed8cec55658c591b97', '9f39c70e1306458980c4b6a700981b6d', 'True', 'True', 'false', 'false', '510116142000', 4, '九江街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510116142000', 1, '2021-07-19 11:30:08', NULL, NULL), (1401, '', '黄龙溪镇', 'f40629b3d5b14069943b430afcc5a7b9', '9f39c70e1306458980c4b6a700981b6d', 'True', 'True', 'false', 'false', '510116320000', 4, '黄龙溪镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510116320000', 1, '2021-07-19 11:30:09', NULL, NULL), (1409, '', '彭镇', '97fbb23f96944ba997db1f65381ddc44', '9f39c70e1306458980c4b6a700981b6d', 'True', 'True', 'false', 'false', '510116349000', 4, '彭镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510116349000', 1, '2021-07-19 11:30:10', NULL, NULL), (1432, '', '西航港街道', 'ea80da2a02e14551a2012eee72b5f11f', '9f39c70e1306458980c4b6a700981b6d', 'True', 'True', 'false', 'false', '510116372000', 4, '西航港街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510116372000', 1, '2021-07-19 11:30:11', NULL, NULL), (1449, '', '黄甲街道', '5e95649802764a01ab11ce2549036398', '9f39c70e1306458980c4b6a700981b6d', 'True', 'True', 'false', 'false', '510116449000', 4, '黄甲街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510116449000', 1, '2021-07-19 11:30:12', NULL, NULL), (1457, '', '永安镇', '01bdfcc167e845efacb191d533593b46', '9f39c70e1306458980c4b6a700981b6d', 'True', 'True', 'false', 'false', '510116509000', 4, '永安镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510116509000', 1, '2021-07-19 11:30:13', NULL, NULL), (1465, '', '东升街道', '536ddcc34f3c41a3a0b8f4bb0e0f7d33', '9f39c70e1306458980c4b6a700981b6d', 'True', 'True', 'false', 'false', '510116745000', 4, '东升街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510116745000', 1, '2021-07-19 11:30:14', NULL, NULL), (1489, '', '黄水镇', '81fd842901d44abea44f52b4960863f2', '9f39c70e1306458980c4b6a700981b6d', 'True', 'True', 'false', 'false', '510116815000', 4, '黄水镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510116815000', 1, '2021-07-19 11:30:16', NULL, NULL), (1503, '', '郫都区', '9188e7ec2d524e669e1899b2e0a97d01', 'a1c5bc973eb74529b9329bcfd9680056', 'True', 'True', 'false', 'false', '510124000000', 3, '郫都区', 'cdspdq.sczwfw.gov.cn', 1, '2021-07-19 11:30:17', NULL, NULL), (1504, '', '唐昌镇', 'bb747d1956cb4925a03ed6ab08440da8', '9188e7ec2d524e669e1899b2e0a97d01', 'True', 'True', 'false', 'false', '510124072000', 4, '唐昌镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510124072000', 1, '2021-07-19 11:30:17', NULL, NULL), (1527, '', '安靖街道', '023d6a12b0d04434a54db64187c546c5', '9188e7ec2d524e669e1899b2e0a97d01', 'True', 'True', 'false', 'false', '510124077000', 4, '安靖街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510124077000', 1, '2021-07-19 11:30:19', NULL, NULL), (1537, '', '德源街道', 'a9eaa24f29174a18a1e70abc9e1776be', '9188e7ec2d524e669e1899b2e0a97d01', 'True', 'True', 'false', 'false', '510124131000', 4, '德源街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510124131000', 1, '2021-07-19 11:30:20', NULL, NULL), (1545, '', '犀浦街道', '8def7b18ba7941a79e3a7342dd073043', '9188e7ec2d524e669e1899b2e0a97d01', 'True', 'True', 'false', 'false', '510124408000', 4, '犀浦街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510124408000', 1, '2021-07-19 11:30:20', NULL, NULL), (1567, '', '三道堰镇', '6b298be4eed942579e3a8bda8145ffd6', '9188e7ec2d524e669e1899b2e0a97d01', 'True', 'True', 'false', 'false', '510124629000', 4, '三道堰镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510124629000', 1, '2021-07-19 11:30:22', NULL, NULL), (1578, '', '安德街道', '5f3e6fd2ad4c4e6b9617e8fa69a36c76', '9188e7ec2d524e669e1899b2e0a97d01', 'True', 'True', 'false', 'false', '510124711000', 4, '安德街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510124711000', 1, '2021-07-19 11:30:23', NULL, NULL), (1593, '', '团结街道', '5347c8b3df564bc8bfc2b337a52cf72a', '9188e7ec2d524e669e1899b2e0a97d01', 'True', 'True', 'false', 'false', '510124738000', 4, '团结街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510124738000', 1, '2021-07-19 11:30:24', NULL, NULL), (1604, '', '郫筒街道', 'e6abb3a28dd64f0885a3c2ce54090621', '9188e7ec2d524e669e1899b2e0a97d01', 'True', 'True', 'false', 'false', '510124805000', 4, '郫筒街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510124805000', 1, '2021-07-19 11:30:25', NULL, NULL), (1627, '', '友爱镇', 'b09c90c631494025a2feb35e0cf21c85', '9188e7ec2d524e669e1899b2e0a97d01', 'True', 'True', 'false', 'false', '510124845000', 4, '友爱镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510124845000', 1, '2021-07-19 11:30:26', NULL, NULL), (1646, '', '红光街道', 'de2ccae6194a4f46a91d06abb8f721fc', '9188e7ec2d524e669e1899b2e0a97d01', 'True', 'True', 'false', 'false', '510124972000', 4, '红光街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510124972000', 1, '2021-07-19 11:30:28', NULL, NULL), (1661, '', '金堂县', 'a9c7abba0c914e89a0ff4af254347474', 'a1c5bc973eb74529b9329bcfd9680056', 'True', 'True', 'false', 'false', '510121000000', 3, '金堂县', 'cdsjtx.sczwfw.gov.cn', 1, '2021-07-19 11:30:29', NULL, NULL), (1662, '', '赵镇街道', '0c1c3d0b19f143ed96dc0454f302476d', 'a9c7abba0c914e89a0ff4af254347474', 'True', 'True', 'false', 'false', '510121100000', 4, '赵镇街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510121100000', 1, '2021-07-19 11:30:29', NULL, NULL), (1687, '', '官仓街道', '584582302ce14734b861615a8e193092', 'a9c7abba0c914e89a0ff4af254347474', 'True', 'True', 'false', 'false', '510121103000', 4, '官仓街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510121103000', 1, '2021-07-19 11:30:31', NULL, NULL), (1699, '', '淮口街道', '462a9497d76d4edbbe54bf3b757a31ba', 'a9c7abba0c914e89a0ff4af254347474', 'True', 'True', 'false', 'false', '510121104000', 4, '淮口街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510121104000', 1, '2021-07-19 11:30:32', NULL, NULL), (1724, '', '白果街道', '5bac58550b4a48188d529e3166b5faa2', 'a9c7abba0c914e89a0ff4af254347474', 'True', 'True', 'false', 'false', '510121105000', 4, '白果街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510121105000', 1, '2021-07-19 11:30:35', NULL, NULL), (1734, '', '五凤镇', '32d439766d9240adb1f7a235db504c4e', 'a9c7abba0c914e89a0ff4af254347474', 'True', 'True', 'false', 'false', '510121106000', 4, '五凤镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510121106000', 1, '2021-07-19 11:30:36', NULL, NULL), (1743, '', '高板街道', '10cd7a49b3324a839685a40ed6df8e59', 'a9c7abba0c914e89a0ff4af254347474', 'True', 'True', 'false', 'false', '510121108000', 4, '高板街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510121108000', 1, '2021-07-19 11:30:37', NULL, NULL), (1762, '', '三溪镇', '4142df803d1e4a7587c1988499a6f5e7', 'a9c7abba0c914e89a0ff4af254347474', 'True', 'True', 'false', 'false', '510121109000', 4, '三溪镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510121109000', 1, '2021-07-19 11:30:39', NULL, NULL), (1771, '', '福兴镇', '649cdd7d79cf4046955d814a823f7eb6', 'a9c7abba0c914e89a0ff4af254347474', 'True', 'True', 'false', 'false', '510121110000', 4, '福兴镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510121110000', 1, '2021-07-19 11:30:40', NULL, NULL), (1783, '', '金龙镇', '4445a2586feb4f5c8e3f8c0827587bf3', 'a9c7abba0c914e89a0ff4af254347474', 'True', 'True', 'false', 'false', '510121111000', 4, '金龙镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510121111000', 1, '2021-07-19 11:30:41', NULL, NULL), (1790, '', '赵家镇', '8e6053663f0343729a2f1fd3ac0c6058', 'a9c7abba0c914e89a0ff4af254347474', 'True', 'True', 'false', 'false', '510121112000', 4, '赵家镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510121112000', 1, '2021-07-19 11:30:42', NULL, NULL), (1799, '', '竹篙镇', '72cf7d47c2664633aa6347cb4b8f44b5', 'a9c7abba0c914e89a0ff4af254347474', 'True', 'True', 'false', 'false', '510121113000', 4, '竹篙镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510121113000', 1, '2021-07-19 11:30:43', NULL, NULL), (1820, '', '转龙镇', '65e12c5e8f614687b5d5c0184ab95e4c', 'a9c7abba0c914e89a0ff4af254347474', 'True', 'True', 'false', 'false', '510121116000', 4, '转龙镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510121116000', 1, '2021-07-19 11:30:45', NULL, NULL), (1834, '', '土桥镇', 'c15d41db8da848f992d89f35e2f5b88c', 'a9c7abba0c914e89a0ff4af254347474', 'True', 'True', 'false', 'false', '510121117000', 4, '土桥镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510121117000', 1, '2021-07-19 11:30:46', NULL, NULL), (1842, '', '云合镇', '0b93a86a4e764c4986f00d0cc012ea29', 'a9c7abba0c914e89a0ff4af254347474', 'True', 'True', 'false', 'false', '510121118000', 4, '云合镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510121118000', 1, '2021-07-19 11:30:47', NULL, NULL), (1851, '', '又新镇', '035d8111cfb1418787b492b7b2d722e1', 'a9c7abba0c914e89a0ff4af254347474', 'True', 'True', 'false', 'false', '510121119000', 4, '又新镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510121119000', 1, '2021-07-19 11:30:47', NULL, NULL), (1861, '', '栖贤街道', '249eeb03675b4d8d80eaf61d7a83d827', 'a9c7abba0c914e89a0ff4af254347474', 'True', 'True', 'false', 'false', '510121200000', 4, '栖贤街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510121200000', 1, '2021-07-19 11:30:48', NULL, NULL), (1878, '', '大邑县', '466225a844c94e6bb5da7825fc5ba722', 'a1c5bc973eb74529b9329bcfd9680056', 'True', 'True', 'true', 'true', '510129000000', 3, '大邑县', 'cdsdyx.sczwfw.gov.cn', 1, '2021-07-19 11:30:49', NULL, NULL), (1879, '', '鹤鸣镇', 'a76020ce6cf64c45866f67b50c692f74', '466225a844c94e6bb5da7825fc5ba722', 'True', 'True', 'false', 'false', '510129000302', 4, '鹤鸣镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510129000302', 1, '2021-07-19 11:30:49', NULL, NULL), (1888, '', '安仁镇', '5cc6f9db0e6a4d0d8f46d13da4db17cd', '466225a844c94e6bb5da7825fc5ba722', 'True', 'True', 'false', 'false', '510129151000', 4, '安仁镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510129151000', 1, '2021-07-19 11:30:50', NULL, NULL), (1923, '', '晋原街道', '4125752d1ad34fe1a5ab261121a02799', '466225a844c94e6bb5da7825fc5ba722', 'True', 'True', 'false', 'false', '510129379000', 4, '晋原街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510129379000', 1, '2021-07-19 11:30:53', NULL, NULL), (1939, '', '青霞街道', '47ec74f6c40e4cbcb139c6e27115ad30', '466225a844c94e6bb5da7825fc5ba722', 'True', 'True', 'false', 'false', '510129417000', 4, '青霞街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510129417000', 1, '2021-07-19 11:30:54', NULL, NULL), (1959, '', '花水湾镇', 'ec478a5b23244c78afcc9a852ccc61ea', '466225a844c94e6bb5da7825fc5ba722', 'True', 'True', 'false', 'false', '510129513000', 4, '花水湾镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510129513000', 1, '2021-07-19 11:30:56', NULL, NULL), (1964, '', '沙渠街道', 'd59a6b2c1bf149878d3f7bf36046ae19', '466225a844c94e6bb5da7825fc5ba722', 'True', 'True', 'false', 'false', '510129569000', 4, '沙渠街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510129569000', 1, '2021-07-19 11:30:57', NULL, NULL), (1977, '', '王泗镇', '3a34ec5f7a8342be896eafb8444779f5', '466225a844c94e6bb5da7825fc5ba722', 'True', 'True', 'false', 'false', '510129707000', 4, '王泗镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510129707000', 1, '2021-07-19 11:30:58', NULL, NULL), (1991, '', '西岭镇', '12ab20cb058c44339a76f9a5427900d6', '466225a844c94e6bb5da7825fc5ba722', 'True', 'True', 'false', 'false', '510129815000', 4, '西岭镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510129815000', 1, '2021-07-19 11:30:59', NULL, NULL), (1997, '', '䢺江镇', '2e0f229ef4324befb5024f53f8647a4f', '466225a844c94e6bb5da7825fc5ba722', 'True', 'True', 'false', 'false', '510129822000', 4, '䢺江镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510129822000', 1, '2021-07-19 11:30:59', NULL, NULL), (2008, '', '悦来镇', '488467a714284aa2a52e2ac3b4af42b4', '466225a844c94e6bb5da7825fc5ba722', 'True', 'True', 'false', 'false', '510129832000', 4, '悦来镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510129832000', 1, '2021-07-19 11:31:00', NULL, NULL), (2024, '', '新场镇', '5723884a948647309b00e5869dfa16e0', '466225a844c94e6bb5da7825fc5ba722', 'True', 'True', 'false', 'false', '510129852000', 4, '新场镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510129852000', 1, '2021-07-19 11:31:02', NULL, NULL), (2037, '', '蒲江县', '98ee4eb6cbd241538cd2aecc15580d65', 'a1c5bc973eb74529b9329bcfd9680056', 'True', 'True', 'false', 'false', '510131000000', 3, '蒲江县', 'cdspjx.sczwfw.gov.cn', 1, '2021-07-19 11:31:03', NULL, NULL), (2038, '', '鹤山街道', '67f9b0a7bc8d42d3b3e6bd8e78d2ef05', '98ee4eb6cbd241538cd2aecc15580d65', 'True', 'True', 'false', 'false', '510131001000', 4, '鹤山街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510131001000', 1, '2021-07-19 11:31:04', NULL, NULL), (2064, '', '大塘镇', '4cb76335271e48ab870c933daa354d61', '98ee4eb6cbd241538cd2aecc15580d65', 'True', 'True', 'false', 'false', '510131101000', 4, '大塘镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510131101000', 1, '2021-07-19 11:31:06', NULL, NULL), (2071, '', '寿安街道', 'fa184ae9a9544df9bf1a65ec901b745b', '98ee4eb6cbd241538cd2aecc15580d65', 'True', 'True', 'false', 'false', '510131102000', 4, '寿安街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510131102000', 1, '2021-07-19 11:31:08', NULL, NULL), (2093, '', '朝阳湖镇', '847d662b4e5f4f00b229ec925a10a485', '98ee4eb6cbd241538cd2aecc15580d65', 'True', 'True', 'false', 'false', '510131103000', 4, '朝阳湖镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510131103000', 1, '2021-07-19 11:31:10', NULL, NULL), (2102, '', '西来镇', 'fa9375e3d62a44079c60dda981516532', '98ee4eb6cbd241538cd2aecc15580d65', 'True', 'True', 'false', 'false', '510131104000', 4, '西来镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510131104000', 1, '2021-07-19 11:31:11', NULL, NULL), (2119, '', '大兴镇', '74f60b32c4634f4b867170dcd9b7f496', '98ee4eb6cbd241538cd2aecc15580d65', 'True', 'True', 'false', 'false', '510131105000', 4, '大兴镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510131105000', 1, '2021-07-19 11:31:12', NULL, NULL), (2127, '', '甘溪镇', '5c00e3bb75414feebd354cbf5f239a1e', '98ee4eb6cbd241538cd2aecc15580d65', 'True', 'True', 'false', 'false', '510131106000', 4, '甘溪镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510131106000', 1, '2021-07-19 11:31:13', NULL, NULL), (2132, '', '成佳镇', '12e45f70555d426ea49f1bf5e0adca84', '98ee4eb6cbd241538cd2aecc15580d65', 'True', 'True', 'false', 'false', '510131107000', 4, '成佳镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510131107000', 1, '2021-07-19 11:31:13', NULL, NULL), (2139, '', '新津区', 'f715d000c4fb474185e157806644a608', 'a1c5bc973eb74529b9329bcfd9680056', 'True', 'True', 'false', 'false', '510132000000', 3, '新津区', 'cdsxjx.sczwfw.gov.cn', 1, '2021-07-19 11:31:14', NULL, NULL), (2140, '', '普兴街道', 'f21086be86574d3f8b7f74cc49fa3d26', 'f715d000c4fb474185e157806644a608', 'True', 'True', 'false', 'false', '510132104000', 4, '普兴街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510132104000', 1, '2021-07-19 11:31:14', NULL, NULL), (2155, '', '安西镇', 'c732615747324eec84feea2d58298655', 'f715d000c4fb474185e157806644a608', 'True', 'True', 'false', 'false', '510132108000', 4, '安西镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510132108000', 1, '2021-07-19 11:31:15', NULL, NULL), (2163, '', '宝墩镇', '2250c797206645e383a85e1f06d3330b', 'f715d000c4fb474185e157806644a608', 'True', 'True', 'false', 'false', '510132140000', 4, '宝墩镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510132140000', 1, '2021-07-19 11:31:15', NULL, NULL), (2174, '', '五津街道', 'a1b7e72170b5437c8e56cffdd73cd7b2', 'f715d000c4fb474185e157806644a608', 'True', 'True', 'false', 'false', '510132001000', 4, '五津街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510132001000', 1, '2021-07-19 11:31:16', NULL, NULL), (2187, '', '花桥街道', '66696657576d479c9b02ce4b9e766765', 'f715d000c4fb474185e157806644a608', 'True', 'True', 'false', 'false', '510132101000', 4, '花桥街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510132101000', 1, '2021-07-19 11:31:17', NULL, NULL), (2196, '', '花源街道', '0c143d387d3844829b2d4826e0363b45', 'f715d000c4fb474185e157806644a608', 'True', 'True', 'false', 'false', '510132102000', 4, '花源街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510132102000', 1, '2021-07-19 11:31:18', NULL, NULL), (2205, '', '兴义镇', '5a017aa8a84e4a84b5e0200a6a17d240', 'f715d000c4fb474185e157806644a608', 'True', 'True', 'false', 'false', '510132105000', 4, '兴义镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510132105000', 1, '2021-07-19 11:31:18', NULL, NULL), (2215, '', '永商镇', '57c3a850ab1644f19b8c4532555cb2ee', 'f715d000c4fb474185e157806644a608', 'True', 'True', 'false', 'false', '510132109000', 4, '永商镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510132109000', 1, '2021-07-19 11:31:19', NULL, NULL), (2229, '', '都江堰市', '714ba114a0c745819f7cd16844be12b0', 'a1c5bc973eb74529b9329bcfd9680056', 'True', 'True', 'false', 'false', '510181000000', 3, '都江堰市', 'cdsdjys.sczwfw.gov.cn', 1, '2021-07-19 11:31:20', NULL, NULL), (2230, '', '奎光塔街道', 'ba844f5f093446a8a8b7f287dc58c900', '714ba114a0c745819f7cd16844be12b0', 'True', 'True', 'false', 'false', '510181001000', 4, '奎光塔街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510181001000', 1, '2021-07-19 11:31:20', NULL, NULL), (2239, '', '幸福街道', 'aea3d4af9a4342048923e4f045ea6967', '714ba114a0c745819f7cd16844be12b0', 'True', 'True', 'false', 'false', '510181002000', 4, '幸福街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510181002000', 1, '2021-07-19 11:31:20', NULL, NULL), (2250, '', '灌口街道', '381c31fcc2b8460999f181477bbd8a56', '714ba114a0c745819f7cd16844be12b0', 'True', 'True', 'false', 'false', '510181004000', 4, '灌口街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510181004000', 1, '2021-07-19 11:31:21', NULL, NULL), (2260, '', '银杏街道', 'e7eead613f0248c2857783a18df93c3c', '714ba114a0c745819f7cd16844be12b0', 'True', 'True', 'false', 'false', '510181005000', 4, '银杏街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510181005000', 1, '2021-07-19 11:31:22', NULL, NULL), (2272, '', '蒲阳街道', '7f399c73a86a4b6d8ac09bf9a03696b6', '714ba114a0c745819f7cd16844be12b0', 'True', 'True', 'false', 'false', '510181102000', 4, '蒲阳街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510181102000', 1, '2021-07-19 11:31:23', NULL, NULL), (2288, '', '聚源镇', '9f89d15ed01e4c5fba4cad133614ea93', '714ba114a0c745819f7cd16844be12b0', 'True', 'True', 'false', 'false', '510181103000', 4, '聚源镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510181103000', 1, '2021-07-19 11:31:24', NULL, NULL), (2308, '', '天马镇', '3928fa61f6704913902968c248d3b8fb', '714ba114a0c745819f7cd16844be12b0', 'True', 'True', 'false', 'false', '510181105000', 4, '天马镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510181105000', 1, '2021-07-19 11:31:25', NULL, NULL), (2328, '', '石羊镇', 'fda51f13523c424c8ec0b235df05d850', '714ba114a0c745819f7cd16844be12b0', 'True', 'True', 'false', 'false', '510181106000', 4, '石羊镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510181106000', 1, '2021-07-19 11:31:27', NULL, NULL), (2350, '', '玉堂街道', '600f2325b9174dd897e5ee7fc424e8a8', '714ba114a0c745819f7cd16844be12b0', 'True', 'True', 'false', 'false', '510181108000', 4, '玉堂街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510181108000', 1, '2021-07-19 11:31:28', NULL, NULL), (2369, '', '青城山镇', '2642145bfdd94f2e92fa89604ed34cd6', '714ba114a0c745819f7cd16844be12b0', 'True', 'True', 'false', 'false', '510181110000', 4, '青城山镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510181110000', 1, '2021-07-19 11:31:30', NULL, NULL), (2396, '', '龙池镇', '08fd0e3fa50d4350ac60cc2a47727c54', '714ba114a0c745819f7cd16844be12b0', 'True', 'True', 'false', 'false', '510181111000', 4, '龙池镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510181111000', 1, '2021-07-19 11:31:32', NULL, NULL), (2408, '', '彭州市', 'e0820986c9d64b5496c2f3745452dc71', 'a1c5bc973eb74529b9329bcfd9680056', 'True', 'True', 'false', 'false', '510182000000', 3, '彭州市', 'cdspzs.sczwfw.gov.cn', 1, '2021-07-19 11:31:33', NULL, NULL), (2409, '', '天彭街道', '78bbafd6d5944d53971efc90b0e233ad', 'e0820986c9d64b5496c2f3745452dc71', 'True', 'True', 'false', 'false', '510182100000', 4, '天彭街道', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510182100000', 1, '2021-07-19 11:31:33', NULL, NULL), (2438, '', '彭州市龙门山镇', '193719b4d7ba4c29a5be82b8350bf101', 'e0820986c9d64b5496c2f3745452dc71', 'True', 'True', 'false', 'false', '510182101000', 4, '龙门山镇', 'http://www.sczwfw.gov.cn/jiq/front/item/town?areaCode=510182101000', 1, '2021-07-19 11:31:35', NULL, NULL); COMMIT; -- ---------------------------- -- Table structure for mortals_xhx_apps -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_apps`; CREATE TABLE `mortals_xhx_apps` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键,自增长', `name` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '应用名称', `imgPath` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图标', `url` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '连接地址', `sortNum` int(8) NULL DEFAULT 0 COMMENT '排序号', `status` tinyint(4) NULL DEFAULT 0 COMMENT '状态，0暂未开通，1已开通', `remark` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述', `createTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `updateTime` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `createUserId` bigint(20) NULL DEFAULT NULL COMMENT '创建用户ID', `createUserName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建用户名称', `updateUserId` bigint(20) NULL DEFAULT NULL COMMENT '更新用户', `updateUserName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新用户名称', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统应用列'; -- ---------------------------- -- Records of mortals_xhx_apps -- ---------------------------- BEGIN; COMMIT; -- ---------------------------- -- Table structure for mortals_xhx_apps_census -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_apps_census`; CREATE TABLE `mortals_xhx_apps_census` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID，主键，自增长', `appId` bigint(20) NULL DEFAULT NULL COMMENT '应用ID，主键', `censusName` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '数据统计名称', `censusUrl` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '链接地址', `censusType` tinyint(2) NOT NULL COMMENT '统计类型， 1：服务，2：协同，3：监管，4：数据，5：运营。默认1', `status` tinyint(2) NOT NULL COMMENT '状态，0暂未开通，1已开通', `createUserId` bigint(20) NULL DEFAULT NULL COMMENT '创建用户', `createUserName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建用户名称', `createTime` datetime(0) NOT NULL COMMENT '创建时间', `updateTime` datetime(0) NOT NULL COMMENT '更新时间', `updateUserId` bigint(20) NULL DEFAULT NULL COMMENT '更新用户', `updateUserName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新用户名称', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统应用数据统计'; -- ---------------------------- -- Records of mortals_xhx_apps_census -- ---------------------------- BEGIN; COMMIT; -- ---------------------------- -- Table structure for mortals_xhx_idgenerator -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_idgenerator`; CREATE TABLE `mortals_xhx_idgenerator` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '序号，主键，自增长', `idType` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'id类型', `idMaxValue` bigint(20) UNSIGNED NOT NULL COMMENT 'id值', `remark` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '备注', `versionNum` bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT '版本号，默认0', `gmtModify` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最后修改时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '主键Id生成器'; -- ---------------------------- -- Records of mortals_xhx_idgenerator -- ---------------------------- BEGIN; COMMIT; -- ---------------------------- -- Table structure for mortals_xhx_menu -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_menu`; CREATE TABLE `mortals_xhx_menu` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '菜单ID，主键，自增长', `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单名称', `url` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '连接地址', `parentId` bigint(20) NULL DEFAULT NULL COMMENT '父菜单ID，一级菜单的该字段值为-1', `linkType` tinyint(2) NULL DEFAULT NULL COMMENT '链接方式，(0.内链，1.外链，2.脚本)', `imgPath` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '主菜单图标，主菜单图标的css样式名', `buttonImgPath` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '按钮图标', `imgCommPath` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '常用菜单图标', `visible` tinyint(2) NULL DEFAULT NULL COMMENT '菜单显示(0.隐藏，1.显示)', `menuType` tinyint(2) NULL DEFAULT NULL COMMENT '菜单类型(0.目录，1.菜单，2.按钮)', `status` tinyint(2) NULL DEFAULT NULL COMMENT '菜单状态(0.禁用，1.启用)', `authType` tinyint(2) NULL DEFAULT NULL COMMENT '权限类型(0.无限制，1.无需登录查看，2.需要登录查看，3.需要角色权限查看)', `orderId` int(4) NULL DEFAULT NULL COMMENT '排序编号', `createTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `createUserId` bigint(20) NULL DEFAULT NULL COMMENT '创建用户', `createUserName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建用户名称', `remark` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述备注', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 25 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '菜单信息业务'; -- ---------------------------- -- Records of mortals_xhx_menu -- ---------------------------- BEGIN; INSERT INTO `mortals_xhx_menu` VALUES (1, '数据管理', '/home/dataManagement', -1, 0, '', NULL, NULL, 1, 0, 1, 0, 0, '2022-06-10 16:27:05', 1, '系统管理员', 'aa'), (2, '站点编排', '/home/siteArrange', -1, 0, '', NULL, NULL, 1, 0, 1, 0, 2, '2022-06-10 16:27:05', 1, '系统管理员', 'aa'), (3, '数据精算', '/home/dataActuary', -1, 0, '', NULL, NULL, 1, 0, 1, 0, 3, '2022-06-10 16:30:12', 1, '系统管理员', 'aa'), (4, '平台设置', '/home/thePlatformIsSet/setPlatformes', -1, 0, '', NULL, NULL, 1, 0, 1, 0, 4, '2022-06-10 16:31:34', 1, '系统管理员', 'aa'), (5, '业务数据分析', '/home/dataActuary/business/basecontent', 3, 1, 'file/fileupload/1676000367284.png', NULL, NULL, 1, 1, 1, 1, 5, '2022-06-10 16:31:34', 1, '系统管理员', '实时动态监管人流聚集、窗口运行、业务办理以及服务行为、助力合理统筹调配政务资源。'), (6, '用户画像图谱', '/home/dataActuary/portrayal/portrayalbase', 3, 1, 'file/fileupload/1676000768099.png', NULL, NULL, 1, 1, 1, 1, 5, '2022-07-07 02:29:19', 1, '系统管理员', '依托大数据用户画像技术、输出个人位置分布、办件类型等分析服务、协助中心提供精准服务。'), (8, '使用行为分析', '/home/dataActuary/behaviour/eventanalyse', 3, 1, 'file/fileupload/1676000545942.png', NULL, NULL, 1, 1, 1, 1, 5, '2022-07-07 02:29:19', 1, '系统管理员', '对用户行为监测数据进行分析、从而找出软件及业务存在的问题、助力提供更加精准、有效的服务。'), (11, '数据仓库', 'http://10.102.252.13:11060/#/', 3, 1, 'file/fileupload/1676000517015.png', NULL, NULL, 1, 1, 1, 1, 5, '2022-07-07 02:29:19', 1, '系统管理员', '基于分布式查询引擎，应对海量数据查询场景。元数据和数据多副本存储，解决单点依赖。'), (13, 'RBAC用户-权限模型', '/home/thePlatformIsSet/permissionsModel', 4, 1, 'file/fileupload/1732154880327.png', NULL, NULL, 1, 1, 1, 1, 5, '2022-07-07 02:29:19', 1, '系统管理员', '用户和角色关联，角色赋予对应权限 以继承关系防止越权'), (14, 'API服务', '/home/thePlatformIsSet/APIServe', 4, 1, 'file/fileupload/1732154902904.png', NULL, NULL, 1, 1, 1, 1, 6, '2022-07-07 02:29:19', 1, '系统管理员', 'API一体化管理，实现数据、应用、服 务间灵活流转与敏捷集成'), (15, '应用服务', '/home/thePlatformIsSet/applService', 4, 1, 'file/fileupload/1732154932470.png', NULL, NULL, 1, 1, 1, 1, 7, '2022-07-07 02:29:19', 1, '系统管理员', '提供产品应用全生命周期服务，覆盖全终端全场景'), (16, '产品管理', '/home/thePlatformIsSet/productManage', 4, 1, 'file/fileupload/1732154949984.png', NULL, NULL, 1, 1, 1, 1, 8, '2022-07-07 02:29:19', 1, '系统管理员', '提供产品的全管理流程，增强核心能力'), (17, '菜单管理', '/home/thePlatformIsSet/menuManagement', 4, 1, 'file/fileupload/1732154961234.png', NULL, NULL, 1, 1, 1, 1, 9, '2022-07-07 02:29:19', 1, '系统管理员', '提供友好、灵活的功能菜单配置页面 提供更便捷的功能访问入口'), (19, '字典管理', '/home/thePlatformIsSet/dictionary', 4, 1, 'file/fileupload/1732155001316.png', NULL, NULL, 1, 1, 1, 1, 11, '2022-07-07 02:29:19', 1, '系统管理员', '提供对各种枚举数据进行维护的功能'), (20, '日志服务', '/home/thePlatformIsSet/logService', 4, 1, 'file/fileupload/1732154993072.png', NULL, NULL, 1, 1, 1, 1, 12, '2022-07-07 02:29:19', 1, '系统管理员', '提供高可靠的日志收集机制，保证 数据传输安全'), (21, '聚焦服务', '11', 1, 0, '', '', '', 1, 1, 1, 3, 1, '2022-12-19 16:56:57', 1, '系统管理员', '聚焦服务'); COMMIT; -- ---------------------------- -- Table structure for mortals_xhx_oper_log -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_oper_log`; CREATE TABLE `mortals_xhx_oper_log` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '序号，主键，自增长', `platformMark` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '平台标识', `userId` bigint(20) NULL DEFAULT NULL COMMENT '用户id', `userName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名称', `loginName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户登录名', `requestUrl` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '请求地址', `content` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作内容，记录操作具体信息，如修改前修改或的数据', `ip` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作IP地址', `logDate` datetime(0) NULL DEFAULT NULL COMMENT '操作时间', `operType` tinyint(2) NULL DEFAULT NULL COMMENT '操作类型，(0.新增,1.修改,2.删除)', `createTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `createUserId` bigint(20) NULL DEFAULT NULL COMMENT '创建用户', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 69 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '操作日志业务'; -- ---------------------------- -- Records of mortals_xhx_oper_log -- ---------------------------- BEGIN; INSERT INTO `mortals_xhx_oper_log` VALUES (1, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/login/login', '用户登录系统成功!', '127.0.0.1', '2024-11-22 14:39:42', NULL, NULL, NULL), (2, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/site/model/census/list', '查询数据管理 【成功】', '127.0.0.1', '2024-11-22 14:39:43', NULL, NULL, NULL), (3, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/login/login', '用户登录系统成功!', '127.0.0.1', '2024-11-26 09:34:07', NULL, NULL, NULL), (4, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/site/model/census/list', '查询数据管理 【成功】', '127.0.0.1', '2024-11-26 09:34:07', NULL, NULL, NULL), (5, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/user/model/collect/get', '查看用户模块收藏 【成功】', '127.0.0.1', '2024-11-26 09:34:11', NULL, NULL, NULL), (6, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/site/model/list/group', '查询站点编排 【成功】', '127.0.0.1', '2024-11-26 09:34:11', NULL, NULL, NULL), (7, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/login/logout', '退出登录', '127.0.0.1', '2024-11-26 09:46:33', NULL, NULL, NULL), (8, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/login/login', '用户登录系统成功!', '127.0.0.1', '2024-11-26 09:46:44', NULL, NULL, NULL), (9, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/site/model/census/list', '查询数据管理 【成功】', '127.0.0.1', '2024-11-26 09:46:44', NULL, NULL, NULL), (10, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/user/model/collect/get', '查看用户模块收藏 【成功】', '127.0.0.1', '2024-11-26 09:47:20', NULL, NULL, NULL), (11, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/site/model/list/group', '查询站点编排 【成功】', '127.0.0.1', '2024-11-26 09:47:20', NULL, NULL, NULL), (12, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/user/model/collect/get', '查看用户模块收藏 【成功】', '127.0.0.1', '2024-11-26 09:57:55', NULL, NULL, NULL), (13, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/site/model/list/group', '查询站点编排 【成功】', '127.0.0.1', '2024-11-26 09:57:55', NULL, NULL, NULL), (14, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/user/model/collect/save', '修改用户模块收藏 【成功】 [id:1]', '127.0.0.1', '2024-11-26 10:52:57', NULL, NULL, NULL), (15, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/user/model/collect/save', '修改用户模块收藏 【成功】 [id:1]', '127.0.0.1', '2024-11-26 10:53:12', NULL, NULL, NULL), (16, 'portal-manager', NULL, '', '', '/zwfw/oper/log/list', '查询操作日志 【成功】', '127.0.0.1', '2024-11-26 11:08:22', NULL, NULL, NULL), (17, 'portal-manager', NULL, '', '', '/zwfw/oper/log/list', '查询操作日志 【成功】', '127.0.0.1', '2024-11-26 11:08:25', NULL, NULL, NULL), (18, 'portal-manager', NULL, '', '', '/zwfw/oper/log/list', '查询操作日志 【成功】', '127.0.0.1', '2024-11-26 11:09:27', NULL, NULL, NULL), (19, 'portal-manager', NULL, '', '', '/zwfw/oper/log/list', '查询操作日志 【成功】', '127.0.0.1', '2024-11-26 11:09:32', NULL, NULL, NULL), (20, 'portal-manager', NULL, '', '', '/zwfw/oper/log/list', '查询操作日志 【成功】', '127.0.0.1', '2024-11-26 11:09:34', NULL, NULL, NULL), (21, 'portal-manager', NULL, '', '', '/zwfw/oper/log/list', '查询操作日志 【成功】', '127.0.0.1', '2024-11-26 11:09:41', NULL, NULL, NULL), (22, 'portal-manager', NULL, '', '', '/zwfw/oper/log/list', '查询操作日志 【成功】', '127.0.0.1', '2024-11-26 11:09:59', NULL, NULL, NULL), (23, 'portal-manager', NULL, '', '', '/zwfw/oper/log/list', '查询操作日志 【成功】', '127.0.0.1', '2024-11-26 11:20:06', NULL, NULL, NULL), (24, 'portal-manager', NULL, '', '', '/zwfw/oper/log/list', '查询操作日志 【成功】', '127.0.0.1', '2024-11-26 11:23:28', NULL, NULL, NULL), (25, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/oper/log/list', '查询操作日志 【成功】', '127.0.0.1', '2024-11-26 14:08:29', NULL, NULL, NULL), (26, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/oper/log/list', '查询操作日志 【成功】', '127.0.0.1', '2024-11-26 14:10:45', NULL, NULL, NULL), (27, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/login/login', '用户登录系统成功!', '127.0.0.1', '2024-11-26 14:11:28', NULL, NULL, NULL), (28, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/site/model/census/list', '查询数据管理 【成功】', '127.0.0.1', '2024-11-26 14:11:29', NULL, NULL, NULL), (29, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/site/model/census/list', '查询数据管理 【成功】', '127.0.0.1', '2024-11-26 14:11:45', NULL, NULL, NULL), (30, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/oper/log/list', '查询操作日志 【成功】', '127.0.0.1', '2024-11-26 14:11:56', NULL, NULL, NULL), (31, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/oper/log/list', '查询操作日志 【成功】', '127.0.0.1', '2024-11-26 14:11:58', NULL, NULL, NULL), (32, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/oper/log/list', '查询操作日志 【成功】', '127.0.0.1', '2024-11-26 14:12:01', NULL, NULL, NULL), (33, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/oper/log/list', '查询操作日志 【成功】', '127.0.0.1', '2024-11-26 14:12:04', NULL, NULL, NULL), (34, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/oper/log/list', '查询操作日志 【成功】', '127.0.0.1', '2024-11-26 14:12:07', NULL, NULL, NULL), (35, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/oper/log/list', '查询操作日志 【成功】', '127.0.0.1', '2024-11-26 14:12:28', NULL, NULL, NULL), (36, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/site/model/list/group', '查询站点编排 【成功】', '127.0.0.1', '2024-11-26 14:15:31', NULL, NULL, NULL), (37, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/user/model/collect/get', '查看用户模块收藏 【成功】', '127.0.0.1', '2024-11-26 14:15:31', NULL, NULL, NULL), (38, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/user/model/collect/get', '查看用户模块收藏 【成功】', '127.0.0.1', '2024-11-26 14:22:18', NULL, NULL, NULL), (39, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/site/model/list/group', '查询站点编排 【成功】', '127.0.0.1', '2024-11-26 14:22:18', NULL, NULL, NULL), (40, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/oper/log/list', '查询操作日志 【成功】', '127.0.0.1', '2024-11-26 14:34:57', NULL, NULL, NULL), (41, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/user/model/collect/get', '查看用户模块收藏 【成功】', '127.0.0.1', '2024-11-26 14:35:07', NULL, NULL, NULL), (42, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/site/model/list/group', '查询站点编排 【成功】', '127.0.0.1', '2024-11-26 14:35:07', NULL, NULL, NULL), (43, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/user/model/collect/get', '查看用户模块收藏 【成功】', '127.0.0.1', '2024-11-26 15:14:58', NULL, NULL, NULL), (44, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/site/model/list/group', '查询站点编排 【成功】', '127.0.0.1', '2024-11-26 15:14:58', NULL, NULL, NULL), (45, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/site/model/census/list', '查询数据管理 【成功】', '127.0.0.1', '2024-11-26 16:21:47', NULL, NULL, NULL), (46, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/login/login', '用户登录系统成功!', '127.0.0.1', '2024-11-27 11:20:34', NULL, NULL, NULL), (47, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/site/model/census/list', '查询数据管理 【成功】', '127.0.0.1', '2024-11-27 11:20:35', NULL, NULL, NULL), (48, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/user/model/collect/get', '查看用户模块收藏 【成功】', '127.0.0.1', '2024-11-27 11:20:38', NULL, NULL, NULL), (49, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/site/model/list/group', '查询站点编排 【成功】', '127.0.0.1', '2024-11-27 11:20:38', NULL, NULL, NULL), (50, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/login/login', '用户登录系统成功!', '127.0.0.1', '2024-11-28 14:26:50', NULL, NULL, NULL), (51, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/site/model/census/list', '查询数据管理 【成功】', '127.0.0.1', '2024-11-28 14:26:50', NULL, NULL, NULL), (52, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/user/model/collect/get', '查看用户模块收藏 【成功】', '127.0.0.1', '2024-11-28 14:26:53', NULL, NULL, NULL), (53, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/site/model/list/group', '查询站点编排 【成功】', '127.0.0.1', '2024-11-28 14:26:53', NULL, NULL, NULL), (54, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/site/model/census/list', '查询数据管理 【成功】', '127.0.0.1', '2024-11-28 14:56:48', NULL, NULL, NULL), (55, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/site/model/census/list', '查询数据管理 【成功】', '127.0.0.1', '2024-11-28 14:56:50', NULL, NULL, NULL), (56, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/user/model/collect/get', '查看用户模块收藏 【成功】', '127.0.0.1', '2024-11-28 14:56:52', NULL, NULL, NULL), (57, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/site/model/list/group', '查询站点编排 【成功】', '127.0.0.1', '2024-11-28 14:56:52', NULL, NULL, NULL), (58, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/login/logout', '退出登录', '127.0.0.1', '2024-11-28 14:57:47', NULL, NULL, NULL), (59, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/login/login', '用户登录系统成功!', '127.0.0.1', '2024-11-28 14:58:11', NULL, NULL, NULL), (60, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/site/model/census/list', '查询数据管理 【成功】', '127.0.0.1', '2024-11-28 14:58:12', NULL, NULL, NULL), (61, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/user/model/collect/get', '查看用户模块收藏 【成功】', '127.0.0.1', '2024-11-28 14:58:14', NULL, NULL, NULL), (62, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/site/model/list/group', '查询站点编排 【成功】', '127.0.0.1', '2024-11-28 14:58:14', NULL, NULL, NULL), (63, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/user/model/collect/get', '查看用户模块收藏 【成功】', '127.0.0.1', '2024-11-28 15:02:29', NULL, NULL, NULL), (64, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/site/model/list/group', '查询站点编排 【成功】', '127.0.0.1', '2024-11-28 15:02:29', NULL, NULL, NULL), (65, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/user/model/collect/get', '查看用户模块收藏 【成功】', '127.0.0.1', '2024-11-28 15:03:20', NULL, NULL, NULL), (66, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/site/model/list/group', '查询站点编排 【成功】', '127.0.0.1', '2024-11-28 15:03:20', NULL, NULL, NULL), (67, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/user/model/collect/get', '查看用户模块收藏 【成功】', '127.0.0.1', '2024-11-28 15:11:36', NULL, NULL, NULL), (68, 'portal-manager', 1, '系统管理员', 'admin', '/zwfw/site/model/list/group', '查询站点编排 【成功】', '127.0.0.1', '2024-11-28 15:11:36', NULL, NULL, NULL); COMMIT; -- ---------------------------- -- Table structure for mortals_xhx_page_access -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_page_access`; CREATE TABLE `mortals_xhx_page_access` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '序号，主键，自增长', `deviceNum` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备编码', `productId` bigint(20) NULL DEFAULT NULL COMMENT '产品id', `productName` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '产品名称', `firstCode` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '页面编码（页面路由）', `firstName` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '页面名称', `secondCode` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '页面编码（页面路由）', `secondName` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '页面名称', `thirdCode` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '页面编码（页面路由）', `thirdName` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '页面名称', `fourthCode` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '页面编码（页面路由）', `fourthName` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '页面名称', `accessContent` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '完整路径', `pageDepth` int(8) NULL DEFAULT 0 COMMENT '页面深度', `createUserId` bigint(20) NULL DEFAULT NULL COMMENT '创建用户', `createTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `updateUserId` bigint(20) NULL DEFAULT NULL COMMENT '更新用户', `updateTime` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '产品页面访问记录'; -- ---------------------------- -- Records of mortals_xhx_page_access -- ---------------------------- BEGIN; INSERT INTO `mortals_xhx_page_access` VALUES (1, 'C0-FB-F9-CD-70-47', 1, '排队机', NULL, NULL, '/business/test001', '/business/test001', '/signInWay', '签到方式', NULL, NULL, '[{\"sourceCode\":\"/\",\"sourceName\":\"首页\",\"targetCode\":\"/business/test001\",\"targetName\":\"办理业务\"},{\"sourceCode\":\"/business/test001\",\"sourceName\":\"办理业务\",\"targetCode\":\"/signInWay\",\"targetName\":\"签到方式\"}]', 3, NULL, '2024-11-28 09:28:23', NULL, NULL), (2, 'C0-FB-F9-CD-70-47', 1, '排队机', '/', '首页', '/signInWay', '签到方式', NULL, NULL, NULL, NULL, '[{\"sourceCode\":\"/\",\"sourceName\":\"首页\",\"targetCode\":\"/signInWay\",\"targetName\":\"签到方式\"}]', 2, NULL, '2024-11-28 09:41:00', NULL, NULL), (3, 'C0-FB-F9-CD-70-47', 1, '排队机', '/', '首页', '/business/test001', '办理业务', NULL, NULL, NULL, NULL, '[{\"sourceCode\":\"/\",\"sourceName\":\"首页\",\"targetCode\":\"/business/test001\",\"targetName\":\"办理业务\"}]', 2, NULL, '2024-11-29 10:41:12', NULL, NULL), (4, 'C0-FB-F9-CD-70-47', 1, '排队机', NULL, NULL, '/signInWay', '/signInWay', '/business/test001', '办理业务', NULL, NULL, '[{\"sourceCode\":\"/\",\"sourceName\":\"首页\",\"targetCode\":\"/signInWay\",\"targetName\":\"签到方式\"},{\"sourceCode\":\"/signInWay\",\"sourceName\":\"签到方式\",\"targetCode\":\"/business/test001\",\"targetName\":\"办理业务\"}]', 3, NULL, '2024-11-29 10:48:18', NULL, NULL); COMMIT; -- ---------------------------- -- Table structure for mortals_xhx_page_access_depth -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_page_access_depth`; CREATE TABLE `mortals_xhx_page_access_depth` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '序号，主键，自增长', `deviceNum` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备编码', `productId` bigint(20) NULL DEFAULT NULL COMMENT '产品id', `productName` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '产品名称', `pageCode` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '页面编码（页面路由）', `pageName` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '页面名称', `depthValue` int(8) NULL DEFAULT NULL COMMENT '本次访问深度', `createUserId` bigint(20) NULL DEFAULT NULL COMMENT '创建用户', `createTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `updateUserId` bigint(20) NULL DEFAULT NULL COMMENT '更新用户', `updateTime` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '产品页面配置'; -- ---------------------------- -- Records of mortals_xhx_page_access_depth -- ---------------------------- BEGIN; INSERT INTO `mortals_xhx_page_access_depth` VALUES (1, 'C0-FB-F9-CD-70-47', 1, '排队机', '/', '首页', 3, NULL, '2024-11-28 09:28:23', NULL, NULL), (2, 'C0-FB-F9-CD-70-47', 1, '排队机', '/', '首页', 1, NULL, '2024-11-28 09:41:00', NULL, NULL), (3, 'C0-FB-F9-CD-70-47', 1, '排队机', '/', '首页', 2, NULL, '2024-11-29 10:41:13', NULL, NULL), (4, 'C0-FB-F9-CD-70-47', 1, '排队机', '/', '首页', 3, NULL, '2024-11-29 10:48:18', NULL, NULL); COMMIT; -- ---------------------------- -- Table structure for mortals_xhx_page_event -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_page_event`; CREATE TABLE `mortals_xhx_page_event` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '序号，主键，自增长', `deviceNum` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备编码', `productId` bigint(20) NULL DEFAULT NULL COMMENT '产品id', `productName` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '产品名称', `businessCode` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '业务场景编码', `businessName` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '业务场景名称', `eventCode` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '事件编码', `eventName` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '事件名称', `takeTime` int(8) NULL DEFAULT NULL COMMENT '事件耗时（单位毫秒）', `pageCode` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '页面编码（页面路由）', `pageName` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '页面名称', `coordinate` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '事件坐标(x,y)', `createUserId` bigint(20) NULL DEFAULT NULL COMMENT '创建用户', `createTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `updateUserId` bigint(20) NULL DEFAULT NULL COMMENT '更新用户', `updateTime` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 58 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '页面事件记录'; -- ---------------------------- -- Records of mortals_xhx_page_event -- ---------------------------- BEGIN; INSERT INTO `mortals_xhx_page_event` VALUES (1, 'C0-FB-F9-CD-70-47', 1, '排队机', '/business', '现场取号', 'Click', '点击', 1000, '/', '首页', '619,464', NULL, '2024-11-28 09:26:40', NULL, NULL), (2, 'C0-FB-F9-CD-70-47', 1, '排队机', 'businessItem-413', '企业服务', 'Click', '点击', 1000, '/business/test001', '办理业务', '576,180', NULL, '2024-11-28 09:26:42', NULL, NULL), (3, 'C0-FB-F9-CD-70-47', 1, '排队机', 'iDCardSignIn', '身份证号', 'Click', '点击', 1000, '/signInWay', '签到方式', '1102,591', NULL, '2024-11-28 09:26:45', NULL, NULL), (4, 'C0-FB-F9-CD-70-47', 1, '排队机', 'iDCardSignIn', '身份证号', 'Click', '点击', 1000, '/signInWay', '签到方式', '1101,585', NULL, '2024-11-28 09:26:52', NULL, NULL), (5, 'C0-FB-F9-CD-70-47', 1, '排队机', 'mobCheck_in', '手机号', 'Click', '点击', 1000, '/signInWay', '签到方式', '716,586', NULL, '2024-11-28 09:26:53', NULL, NULL), (6, 'C0-FB-F9-CD-70-47', 1, '排队机', 'iDCardSignIn', '身份证号', 'Click', '点击', 1000, '/signInWay', '签到方式', '1035,570', NULL, '2024-11-28 09:26:54', NULL, NULL), (7, 'C0-FB-F9-CD-70-47', 1, '排队机', 'mobCheck_in', '手机号', 'Click', '点击', 1000, '/signInWay', '签到方式', '786,569', NULL, '2024-11-28 09:26:55', NULL, NULL), (8, 'C0-FB-F9-CD-70-47', 1, '排队机', 'iDCardSignIn', '身份证号', 'Click', '点击', 1000, '/signInWay', '签到方式', '1020,570', NULL, '2024-11-28 09:26:56', NULL, NULL), (9, 'C0-FB-F9-CD-70-47', 1, '排队机', '/business', '现场取号', 'Click', '点击', 1000, '/', '首页', '634,463', NULL, '2024-11-28 09:31:49', NULL, NULL), (10, 'C0-FB-F9-CD-70-47', 1, '排队机', 'businessItem-413', '企业服务', 'Click', '点击', 1000, '/business/test001', '办理业务', '581,174', NULL, '2024-11-28 09:31:50', NULL, NULL), (11, 'C0-FB-F9-CD-70-47', 1, '排队机', 'iDCardSignIn', '身份证号', 'Click', '点击', 1000, '/signInWay', '签到方式', '1097,576', NULL, '2024-11-28 09:31:52', NULL, NULL), (12, 'C0-FB-F9-CD-70-47', 1, '排队机', 'iDCardSignIn', '身份证号', 'Click', '点击', 1000, '/signInWay', '签到方式', '1154,583', NULL, '2024-11-28 09:33:48', NULL, NULL), (13, 'C0-FB-F9-CD-70-47', 1, '排队机', 'iDCardSignIn', '身份证号', 'Click', '点击', 1000, '/signInWay', '签到方式', '1117,589', NULL, '2024-11-28 09:34:00', NULL, NULL), (14, 'C0-FB-F9-CD-70-47', 1, '排队机', 'iDCardSignIn', '身份证号', 'Put', '输入', 15695, '/signInWay', '签到方式', NULL, NULL, '2024-11-28 09:34:05', NULL, NULL), (15, 'C0-FB-F9-CD-70-47', 1, '排队机', 'iDCardSignIn', '身份证号', 'Click', '点击', 1000, '/signInWay', '签到方式', '1210,584', NULL, '2024-11-28 09:34:18', NULL, NULL), (16, 'C0-FB-F9-CD-70-47', 1, '排队机', 'iDCardSignIn', '身份证号', 'Put', '输入', 3817, '/signInWay', '签到方式', NULL, NULL, '2024-11-28 09:34:22', NULL, NULL), (17, 'C0-FB-F9-CD-70-47', 1, '排队机', 'iDCardSignIn', '身份证号', 'Put', '输入', 6760, '/signInWay', '签到方式', NULL, NULL, '2024-11-28 09:34:25', NULL, NULL), (18, 'C0-FB-F9-CD-70-47', 1, '排队机', 'iDCardSignIn', '身份证号', 'Put', '输入', 10416, '/signInWay', '签到方式', NULL, NULL, '2024-11-28 09:34:29', NULL, NULL), (19, 'C0-FB-F9-CD-70-47', 1, '排队机', 'iDCardSignIn', '身份证号', 'Put', '输入', 12929, '/signInWay', '签到方式', NULL, NULL, '2024-11-28 09:34:32', NULL, NULL), (20, 'C0-FB-F9-CD-70-47', 1, '排队机', 'iDCardSignIn', '身份证号', 'Click', '点击', 1000, '/signInWay', '签到方式', '1106,370', NULL, '2024-11-28 09:34:49', NULL, NULL), (21, 'C0-FB-F9-CD-70-47', 1, '排队机', 'iDCardSignIn', '身份证号', 'Put', '输入', 7154, '/signInWay', '签到方式', NULL, NULL, '2024-11-28 09:34:57', NULL, NULL), (22, 'C0-FB-F9-CD-70-47', 1, '排队机', 'iDCardSignIn', '身份证号', 'Put', '输入', 24295, '/signInWay', '签到方式', NULL, NULL, '2024-11-28 09:35:15', NULL, NULL), (23, 'C0-FB-F9-CD-70-47', 1, '排队机', 'iDCardSignIn', '身份证号', 'Click', '点击', 1000, '/signInWay', '签到方式', '1116,369', NULL, '2024-11-28 09:35:55', NULL, NULL), (24, 'C0-FB-F9-CD-70-47', 1, '排队机', 'iDCardSignIn', '身份证号', 'Put', '输入', 4474, '/signInWay', '签到方式', NULL, NULL, '2024-11-28 09:36:00', NULL, NULL), (25, 'C0-FB-F9-CD-70-47', 1, '排队机', 'iDCardSignIn', '身份证号', 'Click', '点击', 1000, '/signInWay', '签到方式', '1124,375', NULL, '2024-11-28 09:36:16', NULL, NULL), (26, 'C0-FB-F9-CD-70-47', 1, '排队机', 'iDCardSignIn', '身份证号', 'Put', '输入', 3721, '/signInWay', '签到方式', NULL, NULL, '2024-11-28 09:36:20', NULL, NULL), (27, 'C0-FB-F9-CD-70-47', 1, '排队机', 'iDCardSignIn', '身份证号', 'Click', '点击', 1000, '/signInWay', '签到方式', '1126,362', NULL, '2024-11-28 09:36:31', NULL, NULL), (28, 'C0-FB-F9-CD-70-47', 1, '排队机', 'iDCardSignIn', '身份证号', 'Put', '输入', 3360, '/signInWay', '签到方式', NULL, NULL, '2024-11-28 09:36:35', NULL, NULL), (29, 'C0-FB-F9-CD-70-47', 1, '排队机', 'iDCardSignIn', '身份证号', 'Put', '输入', 20217, '/signInWay', '签到方式', NULL, NULL, '2024-11-28 09:36:52', NULL, NULL), (30, 'C0-FB-F9-CD-70-47', 1, '排队机', 'iDCardSignIn', '身份证号', 'Click', '点击', 1000, '/signInWay', '签到方式', '1174,371', NULL, '2024-11-28 09:37:16', NULL, NULL), (31, 'C0-FB-F9-CD-70-47', 1, '排队机', 'iDCardSignIn', '身份证号', 'Put', '输入', 6380, '/signInWay', '签到方式', NULL, NULL, '2024-11-28 09:37:23', NULL, NULL), (32, 'C0-FB-F9-CD-70-47', 1, '排队机', 'iDCardSignIn', '身份证号', 'Put', '输入', 9465, '/signInWay', '签到方式', NULL, NULL, '2024-11-28 09:37:26', NULL, NULL), (33, 'C0-FB-F9-CD-70-47', 1, '排队机', 'iDCardSignIn', '身份证号', 'Click', '点击', 1000, '/signInWay', '签到方式', '1141,374', NULL, '2024-11-28 09:38:05', NULL, NULL), (34, 'C0-FB-F9-CD-70-47', 1, '排队机', 'iDCardSignIn', '身份证号', 'Put', '输入', 6001, '/signInWay', '签到方式', NULL, NULL, '2024-11-28 09:38:11', NULL, NULL), (35, 'C0-FB-F9-CD-70-47', 1, '排队机', 'iDCardSignIn', '身份证号', 'Put', '输入', 15567, '/signInWay', '签到方式', NULL, NULL, '2024-11-28 09:38:21', NULL, NULL), (36, 'C0-FB-F9-CD-70-47', 1, '排队机', 'iDCardSignIn', '身份证号', 'Put', '输入', 19861, '/signInWay', '签到方式', NULL, NULL, '2024-11-28 09:38:25', NULL, NULL), (37, 'C0-FB-F9-CD-70-47', 1, '排队机', 'iDCardSignIn', '身份证号', 'Click', '点击', 1000, '/signInWay', '签到方式', '1154,379', NULL, '2024-11-28 09:38:46', NULL, NULL), (38, 'C0-FB-F9-CD-70-47', 1, '排队机', 'iDCardSignIn', '身份证号', 'Put', '输入', 44126, '/signInWay', '签到方式', NULL, NULL, '2024-11-28 09:38:49', NULL, NULL), (39, 'C0-FB-F9-CD-70-47', 1, '排队机', '/business', '现场取号', 'Click', '点击', 1000, '/', '首页', '416,173', NULL, '2024-11-29 10:39:51', NULL, NULL), (40, 'C0-FB-F9-CD-70-47', 1, '排队机', '/business', '现场取号', 'Click', '点击', 1000, '/', '首页', '556,271', NULL, '2024-11-29 10:41:56', NULL, NULL), (41, 'C0-FB-F9-CD-70-47', 1, '排队机', 'businessItem-413', '企业服务', 'Click', '点击', 1000, '/business/test001', '办理业务', '709,98', NULL, '2024-11-29 10:41:57', NULL, NULL), (42, 'C0-FB-F9-CD-70-47', 1, '排队机', 'iDCardSignIn', '身份证号', 'Click', '点击', 1000, '/signInWay', '签到方式', '1187,319', NULL, '2024-11-29 10:41:59', NULL, NULL), (43, 'C0-FB-F9-CD-70-47', 1, '排队机', 'iDCardSignIn', '身份证号', 'Click', '点击', 1000, '/signInWay', '签到方式', '1173,306', NULL, '2024-11-29 10:42:00', NULL, NULL), (44, 'C0-FB-F9-CD-70-47', 1, '排队机', 'iDCardSignIn', '身份证号', 'Put', '输入', 3465, '/signInWay', '签到方式', NULL, NULL, '2024-11-29 10:42:03', NULL, NULL), (45, 'C0-FB-F9-CD-70-47', 1, '排队机', 'iDCardSignIn', '身份证号', 'Put', '输入', 43327, '/signInWay', '签到方式', NULL, NULL, '2024-11-29 10:42:43', NULL, NULL), (46, 'C0-FB-F9-CD-70-47', 1, '排队机', 'iDCardSignIn', '身份证号', 'Put', '输入', 60362, '/signInWay', '签到方式', NULL, NULL, '2024-11-29 10:43:00', NULL, NULL), (47, 'C0-FB-F9-CD-70-47', 1, '排队机', 'iDCardSignIn', '身份证号', 'Put', '输入', 64639, '/signInWay', '签到方式', NULL, NULL, '2024-11-29 10:43:04', NULL, NULL), (48, 'C0-FB-F9-CD-70-47', 1, '排队机', 'iDCardSignIn', '身份证号', 'Put', '输入', 81184, '/signInWay', '签到方式', NULL, NULL, '2024-11-29 10:43:21', NULL, NULL), (49, 'C0-FB-F9-CD-70-47', 1, '排队机', 'iDCardSignIn', '身份证号', 'Click', '点击', 1000, '/signInWay', '签到方式', '1151,409', NULL, '2024-11-29 10:45:14', NULL, NULL), (50, 'C0-FB-F9-CD-70-47', 1, '排队机', 'iDCardSignIn', '身份证号', 'Put', '输入', 31950, '/signInWay', '签到方式', NULL, NULL, '2024-11-29 10:45:46', NULL, NULL), (51, 'C0-FB-F9-CD-70-47', 1, '排队机', 'iDCardSignIn', '身份证号', 'Click', '点击', 1000, '/signInWay', '签到方式', '1172,415', NULL, '2024-11-29 10:46:07', NULL, NULL), (52, 'C0-FB-F9-CD-70-47', 1, '排队机', 'iDCardSignIn', '身份证号', 'Put', '输入', 23637, '/signInWay', '签到方式', NULL, NULL, '2024-11-29 10:46:31', NULL, NULL), (53, 'C0-FB-F9-CD-70-47', 1, '排队机', 'iDCardSignIn', '身份证号', 'Put', '输入', 32962, '/signInWay', '签到方式', NULL, NULL, '2024-11-29 10:46:40', NULL, NULL), (54, 'C0-FB-F9-CD-70-47', 1, '排队机', 'iDCardSignIn', '身份证号', 'Put', '输入', 50907, '/signInWay', '签到方式', NULL, NULL, '2024-11-29 10:46:58', NULL, NULL), (55, 'C0-FB-F9-CD-70-47', 1, '排队机', 'businessItem-413', '企业服务', 'Click', '点击', 1000, '/business/test001', '办理业务', '485,133', NULL, '2024-11-29 10:47:02', NULL, NULL), (56, 'C0-FB-F9-CD-70-47', 1, '排队机', 'iDCardSignIn', '身份证号', 'Click', '点击', 1000, '/signInWay', '签到方式', '1126,418', NULL, '2024-11-29 10:47:03', NULL, NULL), (57, 'C0-FB-F9-CD-70-47', 1, '排队机', 'iDCardSignIn', '身份证号', 'Put', '输入', 11690, '/signInWay', '签到方式', NULL, NULL, '2024-11-29 10:47:15', NULL, NULL); COMMIT; -- ---------------------------- -- Table structure for mortals_xhx_page_info -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_page_info`; CREATE TABLE `mortals_xhx_page_info` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '序号，主键，自增长', `deviceNum` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备编码', `productId` bigint(20) NULL DEFAULT NULL COMMENT '产品id', `productName` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '产品名称', `pageCode` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '页面编码（页面路由）', `pageName` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '页面名称', `screenUrl` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '页面截图地址', `createUserId` bigint(20) NULL DEFAULT NULL COMMENT '创建用户', `createTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `updateUserId` bigint(20) NULL DEFAULT NULL COMMENT '更新用户', `updateTime` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '产品页面配置'; -- ---------------------------- -- Records of mortals_xhx_page_info -- ---------------------------- BEGIN; COMMIT; -- ---------------------------- -- Table structure for mortals_xhx_page_route -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_page_route`; CREATE TABLE `mortals_xhx_page_route` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '序号，主键，自增长', `deviceNum` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备编码', `productId` bigint(20) NULL DEFAULT NULL COMMENT '产品id', `productName` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '产品名称', `sourceCode` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '开始页面编码（路由）', `sourceName` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '开始页面名称', `targetCode` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '目标页面编码（路由）', `targetName` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '目标页面名称', `createUserId` bigint(20) NULL DEFAULT NULL COMMENT '创建用户', `createTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `updateUserId` bigint(20) NULL DEFAULT NULL COMMENT '更新用户', `updateTime` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '页面路径记录'; -- ---------------------------- -- Records of mortals_xhx_page_route -- ---------------------------- BEGIN; INSERT INTO `mortals_xhx_page_route` VALUES (1, 'C0-FB-F9-CD-70-47', 1, '排队机', '/', '首页', '/business/test001', '办理业务', NULL, '2024-11-28 09:28:23', NULL, NULL), (2, 'C0-FB-F9-CD-70-47', 1, '排队机', '/business/test001', '办理业务', '/signInWay', '签到方式', NULL, '2024-11-28 09:28:23', NULL, NULL), (3, 'C0-FB-F9-CD-70-47', 1, '排队机', '/', '首页', '/signInWay', '签到方式', NULL, '2024-11-28 09:41:00', NULL, NULL), (4, 'C0-FB-F9-CD-70-47', 1, '排队机', '/', '首页', '/business/test001', '办理业务', NULL, '2024-11-29 10:41:13', NULL, NULL), (5, 'C0-FB-F9-CD-70-47', 1, '排队机', '/', '首页', '/signInWay', '签到方式', NULL, '2024-11-29 10:48:18', NULL, NULL), (6, 'C0-FB-F9-CD-70-47', 1, '排队机', '/signInWay', '签到方式', '/business/test001', '办理业务', NULL, '2024-11-29 10:48:18', NULL, NULL); COMMIT; -- ---------------------------- -- Table structure for mortals_xhx_param -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_param`; CREATE TABLE `mortals_xhx_param` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '序号，主键，自增长', `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '参数名称', `firstOrganize` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '一级组织，如：平台配置', `secondOrganize` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '二级组织，如：基础配置', `paramKey` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '参数键，全局唯一', `paramValue` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '参数值', `validStatus` tinyint(2) NULL DEFAULT NULL COMMENT '参数有效状态，(0.禁用，1.启用)', `modStatus` tinyint(2) NULL DEFAULT NULL COMMENT '参数修改状态(0.隐藏，1.页面仅查看，2.页面可修改，3.页面可删除，4.页面可修改删除)', `displayType` tinyint(2) NULL DEFAULT NULL COMMENT '展现类型(0.普通文本框，1.多行文本框，2.开关，3.块输入框)', `remark` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注', `createTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `createUserId` bigint(20) NULL DEFAULT NULL COMMENT '创建用户', `createUserName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建用户名称', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 90 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '参数信息业务'; -- ---------------------------- -- Records of mortals_xhx_param -- ---------------------------- BEGIN; INSERT INTO `mortals_xhx_param` VALUES (1, '用户类型', 'User', 'userType', '0', '系统用户', 1, 4, 0, 'userType', NULL, NULL, NULL), (2, '用户类型', 'User', 'userType', '1', '普通用户', 1, 4, 0, 'userType', NULL, NULL, NULL), (3, '用户类型', 'User', 'userType', '2', '工作人员', 1, 4, 0, 'userType', NULL, NULL, NULL), (4, '用户状态', 'User', 'status', '0', '停用', 1, 4, 0, 'status', NULL, NULL, NULL), (5, '用户状态', 'User', 'status', '1', '正常', 1, 4, 0, 'status', NULL, NULL, NULL), (6, '用户状态', 'User', 'status', '2', '冻结', 1, 4, 0, 'status', NULL, NULL, NULL), (7, '用户状态', 'User', 'status', '3', '销户', 1, 4, 0, 'status', NULL, NULL, NULL), (8, '用户状态', 'User', 'status', '4', '离职', 1, 4, 0, 'status', NULL, NULL, NULL), (9, '角色类型', 'Role', 'roleType', '0', '系统内置角色', 1, 4, 0, 'roleType', NULL, NULL, NULL), (10, '角色类型', 'Role', 'roleType', '1', '默认系统角色', 1, 4, 0, 'roleType', NULL, NULL, NULL), (11, '角色类型', 'Role', 'roleType', '2', '普通角色', 1, 4, 0, 'roleType', NULL, NULL, NULL), (12, '角色状态', 'Role', 'status', '0', '停用', 1, 4, 0, 'status', NULL, NULL, NULL), (13, '角色状态', 'Role', 'status', '1', '启用', 1, 4, 0, 'status', NULL, NULL, NULL), (14, '链接方式，', 'Menu', 'linkType', '0', '普通', 1, 4, 0, 'linkType', NULL, NULL, NULL), (15, '链接方式，', 'Menu', 'linkType', '1', '弹出', 1, 4, 0, 'linkType', NULL, NULL, NULL), (16, '链接方式，', 'Menu', 'linkType', '2', '脚本', 1, 4, 0, 'linkType', NULL, NULL, NULL), (17, '菜单显示', 'Menu', 'visible', '0', '隐藏', 1, 4, 0, 'visible', NULL, NULL, NULL), (18, '菜单显示', 'Menu', 'visible', '1', '显示', 1, 4, 0, 'visible', NULL, NULL, NULL), (19, '菜单类型', 'Menu', 'menuType', '0', '目录', 1, 4, 0, 'menuType', NULL, NULL, NULL), (20, '菜单类型', 'Menu', 'menuType', '1', '菜单', 1, 4, 0, 'menuType', NULL, NULL, NULL), (21, '菜单类型', 'Menu', 'menuType', '2', '按钮', 1, 4, 0, 'menuType', NULL, NULL, NULL), (22, '菜单状态', 'Menu', 'status', '0', '禁用', 1, 4, 0, 'status', NULL, NULL, NULL), (23, '菜单状态', 'Menu', 'status', '1', '启用', 1, 4, 0, 'status', NULL, NULL, NULL), (24, '权限类型', 'Menu', 'authType', '0', '无限制', 1, 4, 0, 'authType', NULL, NULL, NULL), (25, '权限类型', 'Menu', 'authType', '1', '无需登录查看', 1, 4, 0, 'authType', NULL, NULL, NULL), (26, '权限类型', 'Menu', 'authType', '2', '需要登录查看', 1, 4, 0, 'authType', NULL, NULL, NULL), (27, '权限类型', 'Menu', 'authType', '3', '需要角色权限查看', 1, 4, 0, 'authType', NULL, NULL, NULL), (28, '文件类型，', 'Uploadfile', 'fileType', '1', 'excel', 1, 4, 0, 'fileType', NULL, NULL, NULL), (29, '文件类型，', 'Uploadfile', 'fileType', '2', 'img', 1, 4, 0, 'fileType', NULL, NULL, NULL), (30, '文件类型，', 'Uploadfile', 'fileType', '3', 'zip', 1, 4, 0, 'fileType', NULL, NULL, NULL), (31, '文件类型，', 'Uploadfile', 'fileType', '4', 'pdf', 1, 4, 0, 'fileType', NULL, NULL, NULL), (32, '参数有效状态，', 'Param', 'validStatus', '0', '禁用', 1, 4, 0, 'validStatus', NULL, NULL, NULL), (33, '参数有效状态，', 'Param', 'validStatus', '1', '启用', 1, 4, 0, 'validStatus', NULL, NULL, NULL), (34, '参数修改状态', 'Param', 'modStatus', '0', '隐藏', 1, 4, 0, 'modStatus', NULL, NULL, NULL), (35, '参数修改状态', 'Param', 'modStatus', '1', '页面仅查看', 1, 4, 0, 'modStatus', NULL, NULL, NULL), (36, '参数修改状态', 'Param', 'modStatus', '2', '页面可修改', 1, 4, 0, 'modStatus', NULL, NULL, NULL), (37, '参数修改状态', 'Param', 'modStatus', '3', '页面可删除', 1, 4, 0, 'modStatus', NULL, NULL, NULL), (38, '参数修改状态', 'Param', 'modStatus', '4', '页面可修改删除', 1, 4, 0, 'modStatus', NULL, NULL, NULL), (39, '展现类型', 'Param', 'displayType', '0', '普通文本框', 1, 4, 0, 'displayType', NULL, NULL, NULL), (40, '展现类型', 'Param', 'displayType', '1', '多行文本框', 1, 4, 0, 'displayType', NULL, NULL, NULL), (41, '展现类型', 'Param', 'displayType', '2', '开关', 1, 4, 0, 'displayType', NULL, NULL, NULL), (42, '展现类型', 'Param', 'displayType', '3', '块输入框', 1, 4, 0, 'displayType', NULL, NULL, NULL), (43, '任务状态，', 'Task', 'status', '1', '执行中', 1, 4, 0, 'status', NULL, NULL, NULL), (44, '执行策略', 'Task', 'excuteStrategy', '1', '按日', 1, 4, 0, 'excuteStrategy', NULL, NULL, NULL), (45, '执行策略', 'Task', 'excuteStrategy', '2', '按周', 1, 4, 0, 'excuteStrategy', NULL, NULL, NULL), (46, '执行策略', 'Task', 'excuteStrategy', '3', '按月', 1, 4, 0, 'excuteStrategy', NULL, NULL, NULL), (47, '执行策略', 'Task', 'excuteStrategy', '4', '按间隔时间', 1, 4, 0, 'excuteStrategy', NULL, NULL, NULL), (48, '临时执行状态，', 'Task', 'interimExcuteStatus', '0', '未启用', 1, 4, 0, 'interimExcuteStatus', NULL, NULL, NULL), (49, '临时执行状态，', 'Task', 'interimExcuteStatus', '1', '立即执行并保留', 1, 4, 0, 'interimExcuteStatus', NULL, NULL, NULL), (50, '临时执行状态，', 'Task', 'interimExcuteStatus', '2', '立即执行并删除', 1, 4, 0, 'interimExcuteStatus', NULL, NULL, NULL), (51, '操作类型，', 'OperLog', 'operType', '0', '新增', 1, 4, 0, 'operType', NULL, NULL, NULL), (52, '操作类型，', 'OperLog', 'operType', '1', '修改', 1, 4, 0, 'operType', NULL, NULL, NULL), (53, '操作类型，', 'OperLog', 'operType', '2', '删除', 1, 4, 0, 'operType', NULL, NULL, NULL), (54, '请求类型', 'ProductInterface', 'requestType', '1', 'POST', 1, 4, 0, 'requestType', NULL, NULL, NULL), (55, '请求类型', 'ProductInterface', 'requestType', '2', 'GET', 1, 4, 0, 'requestType', NULL, NULL, NULL), (56, '请求类型', 'ProductInterface', 'requestType', '3', 'PUT', 1, 4, 0, 'requestType', NULL, NULL, NULL), (57, '请求类型', 'ProductInterface', 'requestType', '4', 'DELETE', 1, 4, 0, 'requestType', NULL, NULL, NULL), (58, '请求类型', 'ProductInterface', 'requestType', '5', 'CONNECT', 1, 4, 0, 'requestType', NULL, NULL, NULL), (59, '请求类型', 'ProductInterface', 'requestType', '6', 'OPTIONS', 1, 4, 0, 'requestType', NULL, NULL, NULL), (60, '内容类型', 'ProductInterface', 'contentType', '1', 'text/html', 1, 4, 0, 'contentType', NULL, NULL, NULL), (61, '内容类型', 'ProductInterface', 'contentType', '2', 'text/xml', 1, 4, 0, 'contentType', NULL, NULL, NULL), (62, '内容类型', 'ProductInterface', 'contentType', '3', 'application/json', 1, 4, 0, 'contentType', NULL, NULL, NULL), (63, '内容类型', 'ProductInterface', 'contentType', '4', 'application/xml', 1, 4, 0, 'contentType', NULL, NULL, NULL), (64, '内容类型', 'ProductInterface', 'contentType', '5', 'application/x-www-form-urlencoded', 1, 4, 0, 'contentType', NULL, NULL, NULL), (65, '内容类型', 'ProductInterface', 'contentType', '6', 'multipart/form-data', 1, 4, 0, 'contentType', NULL, NULL, NULL), (66, '请求协议', 'ProductInterface', 'requestProtocol', '1', 'HTTP', 1, 4, 0, 'requestProtocol', NULL, NULL, NULL), (67, '请求协议', 'ProductInterface', 'requestProtocol', '2', 'HTTPS', 1, 4, 0, 'requestProtocol', NULL, NULL, NULL), (68, '限流策略', 'ProductInterface', 'limitStrategy', '1', '10000次/日', 1, 4, 0, 'limitStrategy', NULL, NULL, NULL), (69, '限流策略', 'ProductInterface', 'limitStrategy', '2', '1000次/日', 1, 4, 0, 'limitStrategy', NULL, NULL, NULL), (70, '限流策略', 'ProductInterface', 'limitStrategy', '3', '100次/日', 1, 4, 0, 'limitStrategy', NULL, NULL, NULL), (71, '限流策略', 'ProductInterface', 'limitStrategy', '4', '1000次/小时', 1, 4, 0, 'limitStrategy', NULL, NULL, NULL), (72, '限流策略', 'ProductInterface', 'limitStrategy', '5', '100次/小时', 1, 4, 0, 'limitStrategy', NULL, NULL, NULL), (73, '限流策略', 'ProductInterface', 'limitStrategy', '6', '100次/分钟', 1, 4, 0, 'limitStrategy', NULL, NULL, NULL), (74, '限流策略', 'ProductInterface', 'limitStrategy', '7', '10次/分钟', 1, 4, 0, 'limitStrategy', NULL, NULL, NULL), (75, '限流策略', 'ProductInterface', 'limitStrategy', '8', '1次/分钟', 1, 4, 0, 'limitStrategy', NULL, NULL, NULL), (76, '访问网络', 'ProductInterface', 'network', '1', '互联网', 1, 4, 0, 'network', NULL, NULL, NULL), (77, '访问网络', 'ProductInterface', 'network', '2', '政务网', 1, 4, 0, 'network', NULL, NULL, NULL), (78, '接口标签', 'ProductInterface', 'interfaceTag', '1', '政务外网', 1, 4, 0, 'interfaceTag', NULL, NULL, NULL), (79, '接口标签', 'ProductInterface', 'interfaceTag', '2', '便民服务', 1, 4, 0, 'interfaceTag', NULL, NULL, NULL), (80, '接口标签', 'ProductInterface', 'interfaceTag', '3', '三化建设', 1, 4, 0, 'interfaceTag', NULL, NULL, NULL), (81, '接口来源', 'ProductInterface', 'interfaceSource', '1', '自建发布', 1, 4, 0, 'interfaceSource', NULL, NULL, NULL), (82, '接口来源', 'ProductInterface', 'interfaceSource', '2', '对接转化', 1, 4, 0, 'interfaceSource', NULL, NULL, NULL), (83, '开发语言', 'ProductApps', 'deveLanguage', '1', 'JAVA', 1, 4, 0, 'deveLanguage', NULL, NULL, NULL), (84, '开发语言', 'ProductApps', 'deveLanguage', '2', 'PHP', 1, 4, 0, 'deveLanguage', NULL, NULL, NULL), (85, '开发语言', 'ProductApps', 'deveLanguage', '3', 'Android', 1, 4, 0, 'deveLanguage', NULL, NULL, NULL), (86, '开发语言', 'ProductApps', 'deveLanguage', '4', 'C#', 1, 4, 0, 'deveLanguage', NULL, NULL, NULL), (87, '开发语言', 'ProductApps', 'deveLanguage', '5', 'C++', 1, 4, 0, 'deveLanguage', NULL, NULL, NULL), (88, '是否启用', 'ProductApps', 'isEnable', '0', '否', 1, 4, 0, 'isEnable', NULL, NULL, NULL), (89, '是否启用', 'ProductApps', 'isEnable', '1', '是', 1, 4, 0, 'isEnable', NULL, NULL, NULL); COMMIT; -- ---------------------------- -- Table structure for mortals_xhx_product -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_product`; CREATE TABLE `mortals_xhx_product` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '序号，主键，自增长', `siteId` bigint(20) NOT NULL COMMENT '站点id', `productName` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '产品名称', `logoUrl` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'Logo图片地址', `productCode` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '产品编码', `createUserId` bigint(20) NOT NULL COMMENT '创建用户', `createTime` datetime(0) NOT NULL COMMENT '创建时间', `updateUserId` bigint(20) NULL DEFAULT NULL COMMENT '更新用户', `updateTime` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '产品信息'; -- ---------------------------- -- Records of mortals_xhx_product -- ---------------------------- BEGIN; INSERT INTO `mortals_xhx_product` VALUES (1, 1, '信息发布系统4', '', '', 1, '2023-05-15 19:30:00', 1, '2023-06-27 15:58:12'), (2, 1, '基础设置', '', '', 1, '2023-05-15 19:31:31', 1, '2023-05-22 10:57:58'), (3, 1, '排号系统', '', '', 1, '2023-05-15 19:32:17', 1, '2023-05-22 10:58:07'), (4, 1, '填单系统', '', '', 1, '2023-05-15 19:37:20', 1, '2023-05-22 10:58:19'), (5, 1, '微官网T', '', '', 1, '2023-05-22 11:02:11', 1, '2023-07-25 10:09:00'), (6, 1, '考勤绩效S', '', '', 1, '2023-07-25 10:09:16', 1, '2023-07-25 10:09:27'), (7, 1, '背靠背评价', '', '', 1, '2023-07-25 10:09:38', NULL, NULL); COMMIT; -- ---------------------------- -- Table structure for mortals_xhx_product_apps -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_product_apps`; CREATE TABLE `mortals_xhx_product_apps` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '序号，主键，自增长', `productId` bigint(20) NOT NULL COMMENT '产品id', `appName` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '应用名称', `deveLanguage` tinyint(2) NOT NULL COMMENT '开发语言', `versionNumber` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '版本号', `versionInfo` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '版本信息', `appFileUrl` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '应用文件地址', `isEnable` tinyint(2) NULL DEFAULT 1 COMMENT '是否启用1是0否', `createUserId` bigint(20) NOT NULL COMMENT '创建用户', `createTime` datetime(0) NOT NULL COMMENT '创建时间', `updateUserId` bigint(20) NULL DEFAULT NULL COMMENT '更新用户', `updateTime` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '产品应用表'; -- ---------------------------- -- Records of mortals_xhx_product_apps -- ---------------------------- BEGIN; COMMIT; -- ---------------------------- -- Table structure for mortals_xhx_product_document -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_product_document`; CREATE TABLE `mortals_xhx_product_document` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '序号，主键，自增长', `productId` bigint(20) NOT NULL COMMENT '产品id', `docName` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '资料名称', `versionNumber` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '版本号', `versionInfo` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '版本信息', `docFileUrl` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '资料文件地址', `createUserId` bigint(20) NOT NULL COMMENT '创建用户', `createTime` datetime(0) NOT NULL COMMENT '创建时间', `updateUserId` bigint(20) NULL DEFAULT NULL COMMENT '更新用户', `updateTime` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '产品资料表'; -- ---------------------------- -- Records of mortals_xhx_product_document -- ---------------------------- BEGIN; COMMIT; -- ---------------------------- -- Table structure for mortals_xhx_product_interface -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_product_interface`; CREATE TABLE `mortals_xhx_product_interface` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '序号，主键，自增长', `productId` bigint(20) NOT NULL COMMENT '产品id', `interfaceName` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '接口名称', `versionNumber` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '版本号', `requestType` tinyint(2) NULL DEFAULT 1 COMMENT '请求类型1:POST,2:GET', `requestProtocol` tinyint(2) NULL DEFAULT 1 COMMENT '请求协议1:HTTP,2:HTTPS', `requestUrl` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '请求路径', `timeoutValue` int(8) NULL DEFAULT NULL COMMENT '超时时间（秒）', `limitStrategy` tinyint(2) NULL DEFAULT NULL COMMENT '限流策略1:分钟,2:小时', `network` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '访问网络1互联网2政务网', `description` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '接口描述', `contentType` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '内容类型', `interfaceTag` tinyint(2) NULL DEFAULT NULL COMMENT '标签', `interfaceSource` tinyint(2) NULL DEFAULT 1 COMMENT '来源1自有2非自有', `inEncrypt` tinyint(2) NULL DEFAULT NULL COMMENT '入参是否加密', `requestParameters` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '请求参数', `outEncrypt` tinyint(2) NULL DEFAULT NULL COMMENT '出参是否加密', `responseParameters` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '响应数据', `remark` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '接口描述', `normalResponse` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '正常返回示例', `abnormalResponse` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '异常返回示例', `createUserId` bigint(20) NOT NULL COMMENT '创建用户', `createTime` datetime(0) NOT NULL COMMENT '创建时间', `updateUserId` bigint(20) NULL DEFAULT NULL COMMENT '更新用户', `updateTime` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `authInfo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '授权信息', `flowInfo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流控信息', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '产品接口'; -- ---------------------------- -- Records of mortals_xhx_product_interface -- ---------------------------- BEGIN; COMMIT; -- ---------------------------- -- Table structure for mortals_xhx_product_interface_log -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_product_interface_log`; CREATE TABLE `mortals_xhx_product_interface_log` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '序号，主键，自增长', `interfaceId` bigint(20) NULL DEFAULT NULL COMMENT '接口id', `requestParameters` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '请求参数', `version` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '版本号', `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '内容说明', `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注', `createUserId` bigint(20) NOT NULL COMMENT '创建用户', `createTime` datetime(0) NOT NULL COMMENT '创建时间', `updateUserId` bigint(20) NULL DEFAULT NULL COMMENT '更新用户', `updateTime` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '产品接口'; -- ---------------------------- -- Records of mortals_xhx_product_interface_log -- ---------------------------- BEGIN; COMMIT; -- ---------------------------- -- Table structure for mortals_xhx_resource -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_resource`; CREATE TABLE `mortals_xhx_resource` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '菜单ID，主键，自增长', `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称', `url` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '连接地址，多个地址以逗号分隔', `authType` tinyint(2) NULL DEFAULT NULL COMMENT '权限类型（0.无限制，1.无需登录查看，2.需要登录查看，3.需要角色权限查看）', `sourceType` tinyint(2) NULL DEFAULT NULL COMMENT '资源类型(0.系统资源，1.开放资源)', `createTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `createUserId` bigint(20) NULL DEFAULT NULL COMMENT '创建用户', `createUserName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建用户名称', `userType` tinyint(2) NULL DEFAULT NULL COMMENT '用户类型(0.系统用户,1.代理商用户,2.品牌商用户)', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 56 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '资源信息业务'; -- ---------------------------- -- Records of mortals_xhx_resource -- ---------------------------- BEGIN; INSERT INTO `mortals_xhx_resource` VALUES (1, '菜单信息业务-维护', '/menu/batchSave,/menu/add,/menu/edit,/menu/importData,/menu/change/status,/menu/upOrDown,/menu/save,/menu/list/tree,/menu/logicDelete,/menu/delete', 3, 1, '2023-11-18 17:22:40', 1, NULL, NULL), (2, '页面路径记录-查看', '/page/route/view,/page/route/downloadTemplate,/page/route/list,/page/route/info,/page/route/exportExcel', 3, 0, '2023-11-18 17:22:40', 1, NULL, NULL), (3, 'SITE/MODEL接口模块-维护', '/site/model/list/group,/site/model/list/all', 3, 1, '2023-11-18 17:22:40', 1, NULL, NULL), (4, '产品应用-维护', '/product/apps/save,/product/apps/importData,/product/apps/delete,/product/apps/edit,/product/apps/add,/product/apps/batchSave,/product/apps/logicDelete', 3, 1, '2023-11-18 17:22:40', 1, NULL, NULL), (5, '用户密码修改记录-查看', '/user/pwd/record/info,/user/pwd/record/downloadTemplate,/user/pwd/record/list,/user/pwd/record/view,/user/pwd/record/exportExcel', 3, 0, '2023-11-18 17:22:40', 1, NULL, NULL), (6, '角色资源权限业务-维护', '/role/auth/distributionSource,/role/auth/batchSave,/role/auth/importData,/role/auth/assignMenuToRole,/role/auth/save,/role/auth/logicDelete,/role/auth/edit,/role/auth/add,/role/auth/delete', 3, 1, '2023-11-18 17:22:40', 1, NULL, NULL), (7, '系统管理-分表索引信息管理-查看', '/table/index/view,/table/index/downloadTemplate,/table/index/exportExcel', 3, 0, '2023-11-18 17:22:40', 1, NULL, NULL), (8, '产品资料-查看', '/product/document/downloadTemplate,/product/document/exportExcel,/product/document/list,/product/document/info,/product/document/view', 3, 0, '2023-11-18 17:22:40', 1, NULL, NULL), (9, '系统管理-API服务管理-查看', '/system/service/api/view,/system/service/api/exportExcel,/system/service/api/downloadTemplate,/system/service/api/info,/system/service/api/list', 3, 0, '2023-11-18 17:22:40', 1, NULL, NULL), (10, '系统管理-API服务管理-查看', '/system/service/exportExcel,/system/service/view,/system/service/downloadTemplate,/system/service/list,/system/service/info', 3, 0, '2023-11-18 17:22:40', 1, NULL, NULL), (11, '用户密码修改记录-维护', '/user/pwd/record/save,/user/pwd/record/delete,/user/pwd/record/logicDelete,/user/pwd/record/add,/user/pwd/record/importData,/user/pwd/record/batchSave,/user/pwd/record/edit', 3, 1, '2023-11-18 17:22:40', 1, NULL, NULL), (12, 'SITE/MODEL接口模块-查看', '/site/model/list,/site/model/census/list', 3, 0, '2023-11-18 17:22:40', 1, NULL, NULL), (13, '产品应用-查看', '/product/apps/downloadTemplate,/product/apps/exportExcel,/product/apps/info,/product/apps/list,/product/apps/view', 3, 0, '2023-11-18 17:22:40', 1, NULL, NULL), (14, '产品接口日志-维护', '/product/interface/log/save,/product/interface/log/delete,/product/interface/log/batchSave,/product/interface/log/edit,/product/interface/log/logicDelete,/product/interface/log/add,/product/interface/log/importData', 3, 1, '2023-11-18 17:22:40', 1, NULL, NULL), (15, '系统管理-分表索引信息管理-维护', '/table/index/delete,/table/index/save,/table/index/logicDelete,/table/index/edit,/table/index/importData,/table/index/add', 3, 1, '2023-11-18 17:22:40', 1, NULL, NULL), (16, '角色信息业务-查看', '/role/view,/role/info,/role/list,/role/downloadTemplate,/role/exportExcel', 3, 0, '2023-11-18 17:22:40', 1, NULL, NULL), (17, '系统管理-验证码信息管理-查看', '/validcode/exportExcel,/validcode/view,/validcode/downloadTemplate', 3, 0, '2023-11-18 17:22:40', 1, NULL, NULL), (18, '角色信息业务-维护', '/role/batchSave,/role/edit,/role/delete,/role/save,/role/logicDelete,/role/add,/role/importData', 3, 1, '2023-11-18 17:22:40', 1, NULL, NULL), (19, '系统管理-资源信息管理-查看', '/resource/info,/resource/list,/resource/exportExcel,/resource/downloadTemplate,/resource/view', 3, 0, '2023-11-18 17:22:40', 1, NULL, NULL), (20, '系统管理-验证码信息管理-维护', '/validcode/edit,/validcode/save,/validcode/add,/validcode/delete,/validcode/importData,/validcode/logicDelete', 3, 1, '2023-11-18 17:22:40', 1, NULL, NULL), (21, '系统管理-API服务管理-维护', '/system/service/api/edit,/system/service/api/importData,/system/service/api/save,/system/service/api/add,/system/service/api/delete,/system/service/api/logicDelete,/system/service/api/batchSave', 3, 1, '2023-11-18 17:22:40', 1, NULL, NULL), (22, '系统管理-API服务管理-维护', '/system/service/batchSave,/system/service/edit,/system/service/save,/system/service/importData,/system/service/add,/system/service/delete,/system/service/logicDelete', 3, 1, '2023-11-18 17:22:40', 1, NULL, NULL), (23, '产品信息-查看', '/product/info,/product/list,/product/view,/product/downloadTemplate,/product/exportExcel', 3, 0, '2023-11-18 17:22:40', 1, NULL, NULL), (24, 'API/USER接口模块-查看', '/api/user/findAllUser', 3, 0, '2023-11-18 17:22:40', 1, NULL, NULL), (25, '页面路径记录-维护', '/page/route/importData,/page/route/logicDelete,/page/route/edit,/page/route/save,/page/route/add,/page/route/delete,/page/route/batchSave', 3, 1, '2023-11-18 17:22:40', 1, NULL, NULL), (26, '角色用户业务-维护', '/role/user/edit,/role/user/assignRoleToUser,/role/user/delete,/role/user/save,/role/user/logicDelete,/role/user/batchSave,/role/user/add,/role/user/importData', 3, 1, '2023-11-18 17:22:40', 1, NULL, NULL), (27, '产品信息-维护', '/product/importData,/product/add,/product/edit,/product/logicDelete,/product/batchSave,/product/delete,/product/save', 3, 1, '2023-11-18 17:22:40', 1, NULL, NULL), (28, '产品页面配置-查看', '/page/info/downloadTemplate,/page/info/exportExcel,/page/info/info,/page/info/list,/page/info/view', 3, 0, '2023-11-18 17:22:40', 1, NULL, NULL), (29, '产品页面配置-查看', '/page/access/info,/page/access/list,/page/access/downloadTemplate,/page/access/view,/page/access/exportExcel', 3, 0, '2023-11-18 17:22:40', 1, NULL, NULL), (30, '系统管理-操作日志管理-查看', '/oper/log/view,/oper/log/exportExcel,/oper/log/downloadTemplate', 3, 0, '2023-11-18 17:22:40', 1, NULL, NULL), (31, '区域-维护', '/area/importData,/area/add,/area/treeselect,/area/save,/area/batchSave,/area/delete,/area/edit,/area/logicDelete', 3, 1, '2023-11-18 17:22:40', 1, NULL, NULL), (32, '参数信息业务-维护', '/param/delete,/param/add,/param/importData,/param/save,/param/logicDelete,/param/batchSave,/param/edit', 3, 1, '2023-11-18 17:22:40', 1, NULL, NULL), (33, '系统管理-任务信息管理-维护', '/task/importData,/task/change/status,/task/logicDelete,/task/save,/task/batchSave,/task/add,/task/edit,/task/delete', 3, 1, '2023-11-18 17:22:40', 1, NULL, NULL), (34, '页面事件记录-维护', '/page/event/importData,/page/event/save,/page/event/logicDelete,/page/event/batchSave,/page/event/edit,/page/event/delete,/page/event/add', 3, 1, '2023-11-18 17:22:40', 1, NULL, NULL), (35, '产品接口-维护', '/product/interface/importData,/product/interface/batchSave,/product/interface/delete,/product/interface/add,/product/interface/save,/product/interface/edit,/product/interface/logicDelete', 3, 1, '2023-11-18 17:22:40', 1, NULL, NULL), (36, '用户模块收藏-查看', '/user/model/collect/exportExcel,/user/model/collect/list,/user/model/collect/get,/user/model/collect/downloadTemplate,/user/model/collect/info,/user/model/collect/view', 3, 0, '2023-11-18 17:22:40', 1, NULL, NULL), (37, '产品接口日志-查看', '/product/interface/log/downloadTemplate,/product/interface/log/list,/product/interface/log/info,/product/interface/log/exportExcel,/product/interface/log/view', 3, 0, '2023-11-18 17:22:40', 1, NULL, NULL), (38, '用户信息业务-查看', '/user/list,/user/exportExcel,/user/info,/user/downloadTemplate,/user/view', 3, 0, '2023-11-18 17:22:40', 1, NULL, NULL), (39, '角色用户业务-查看', '/role/user/list,/role/user/view,/role/user/downloadTemplate,/role/user/exportExcel,/role/user/info', 3, 0, '2023-11-18 17:22:40', 1, NULL, NULL), (40, '系统管理-资源信息管理-维护', '/resource/importData,/resource/batchSave,/resource/allResources,/resource/logicDelete,/resource/save,/resource/add,/resource/edit,/resource/delete', 3, 1, '2023-11-18 17:22:40', 1, NULL, NULL), (41, '产品接口-查看', '/product/interface/view,/product/interface/downloadTemplate,/product/interface/list,/product/interface/info,/product/interface/exportExcel', 3, 0, '2023-11-18 17:22:40', 1, NULL, NULL), (42, '系统管理-任务信息管理-查看', '/task/view,/task/info,/task/list,/task/downloadTemplate,/task/exportExcel', 3, 0, '2023-11-18 17:22:40', 1, NULL, NULL), (43, '页面事件记录-查看', '/page/event/downloadTemplate,/page/event/view,/page/event/info,/page/event/list,/page/event/exportExcel', 3, 0, '2023-11-18 17:22:40', 1, NULL, NULL), (44, '区域-查看', '/area/view,/area/downloadTemplate,/area/info,/area/list,/area/exportExcel,/area/getListByParentId', 3, 0, '2023-11-18 17:22:40', 1, NULL, NULL), (45, '用户信息业务-维护', '/user/save,/user/batchSave,/user/add,/user/edit,/user/delete,/user/change/password,/user/importData,/user/siteAuth,/user/logicDelete,/user/reset/password', 3, 1, '2023-11-18 17:22:40', 1, NULL, NULL), (46, '角色模块数据-查看', '/role/model/view,/role/model/exportExcel,/role/model/downloadTemplate,/role/model/info,/role/model/list', 3, 0, '2023-11-18 17:22:40', 1, NULL, NULL), (47, '菜单信息业务-查看', '/menu/view,/menu/findAll,/menu/list,/menu/exportExcel,/menu/info,/menu/downloadTemplate', 3, 0, '2023-11-18 17:22:40', 1, NULL, NULL), (48, '产品页面配置-维护', '/page/info/logicDelete,/page/info/add,/page/info/importData,/page/info/delete,/page/info/save,/page/info/batchSave,/page/info/edit', 3, 1, '2023-11-18 17:22:40', 1, NULL, NULL), (49, '产品页面配置-维护', '/page/access/add,/page/access/delete,/page/access/logicDelete,/page/access/batchSave,/page/access/importData,/page/access/save,/page/access/edit', 3, 1, '2023-11-18 17:22:40', 1, NULL, NULL), (50, '系统管理-操作日志管理-维护', '/oper/log/delete,/oper/log/importData,/oper/log/save,/oper/log/edit,/oper/log/logicDelete,/oper/log/add', 3, 1, '2023-11-18 17:22:40', 1, NULL, NULL), (51, '产品资料-维护', '/product/document/save,/product/document/edit,/product/document/add,/product/document/batchSave,/product/document/logicDelete,/product/document/importData,/product/document/delete', 3, 1, '2023-11-18 17:22:40', 1, NULL, NULL), (52, '用户模块收藏-维护', '/user/model/collect/save,/user/model/collect/add,/user/model/collect/batchSave,/user/model/collect/importData,/user/model/collect/delete,/user/model/collect/edit,/user/model/collect/logicDelete', 3, 1, '2023-11-18 17:22:40', 1, NULL, NULL), (53, '角色资源权限业务-查看', '/role/auth/list,/role/auth/info,/role/auth/view,/role/auth/downloadTemplate,/role/auth/exportExcel', 3, 0, '2023-11-18 17:22:40', 1, NULL, NULL), (54, '角色模块数据-维护', '/role/model/logicDelete,/role/model/importData,/role/model/edit,/role/model/delete,/role/model/save,/role/model/add,/role/model/batchSave', 3, 1, '2023-11-18 17:22:40', 1, NULL, NULL), (55, '参数信息业务-查看', '/param/downloadTemplate,/param/list,/param/info,/param/view,/param/exportExcel', 3, 0, '2023-11-18 17:22:40', 1, NULL, NULL); COMMIT; -- ---------------------------- -- Table structure for mortals_xhx_role -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_role`; CREATE TABLE `mortals_xhx_role` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '序号，主键，自增长', `name` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色名称', `roleCode` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色编码', `roleSort` int(4) NULL DEFAULT NULL COMMENT '角色排序字段', `roleType` tinyint(2) NULL DEFAULT NULL COMMENT '角色类型(0.系统内置角色，1.默认系统角色，2.普通角色)', `remark` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注', `status` tinyint(2) NULL DEFAULT NULL COMMENT '角色状态（0.停用，1.启用）', `createTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `createUserId` bigint(20) NULL DEFAULT NULL COMMENT '创建用户', `createUserName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建用户名称', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色信息'; -- ---------------------------- -- Records of mortals_xhx_role -- ---------------------------- BEGIN; INSERT INTO `mortals_xhx_role` VALUES (1, '管理员', '', 0, 1, '管理员', 1, '2023-01-12 09:52:47', 1, '系统管理员'), (2, '客户', '', 0, 1, '客户', 1, '2023-03-01 18:53:15', 1, '系统管理员'), (3, '超管', '', 0, 1, '超管', 1, '2023-05-16 21:10:36', 1, '系统管理员'), (4, '工作人员', '', 0, 1, '一体化用户工作人员', 1, '2023-05-24 20:42:26', 1, '系统管理员'), (5, '商事登记股信息发布角色', '', 0, 1, '蒋佳', 1, '2024-04-11 09:21:38', 1, '系统管理员'), (6, '办公室考勤负责人', '', 0, 1, '张平', 1, '2024-05-16 11:44:03', 1, '系统管理员'), (7, '麒麟互认证', '', 0, 1, '麒麟互认证专用角色', 1, '2024-08-19 14:05:45', 1, '系统管理员'); COMMIT; -- ---------------------------- -- Table structure for mortals_xhx_role_auth -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_role_auth`; CREATE TABLE `mortals_xhx_role_auth` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '序号，主键，自增长', `roleId` bigint(20) NULL DEFAULT NULL COMMENT '角色ID', `menuId` bigint(20) NULL DEFAULT NULL COMMENT '菜单ID', `resourceId` bigint(20) NULL DEFAULT NULL COMMENT '资源id', `createTime` datetime(0) NULL DEFAULT NULL, `createUserId` bigint(20) NULL DEFAULT NULL, `createUserName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1581 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色菜单权限关联'; -- ---------------------------- -- Records of mortals_xhx_role_auth -- ---------------------------- BEGIN; INSERT INTO `mortals_xhx_role_auth` VALUES (1570, 1, 16, NULL, NULL, NULL, NULL), (1571, 1, 17, NULL, NULL, NULL, NULL), (1572, 1, 19, NULL, NULL, NULL, NULL), (1573, 1, 3, NULL, NULL, NULL, NULL), (1574, 1, 20, NULL, NULL, NULL, NULL), (1575, 1, 4, NULL, NULL, NULL, NULL), (1576, 1, 5, NULL, NULL, NULL, NULL), (1577, 1, 8, NULL, NULL, NULL, NULL), (1578, 1, 13, NULL, NULL, NULL, NULL), (1579, 1, 14, NULL, NULL, NULL, NULL), (1580, 1, 15, NULL, NULL, NULL, NULL); COMMIT; -- ---------------------------- -- Table structure for mortals_xhx_role_model -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_role_model`; CREATE TABLE `mortals_xhx_role_model` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键,自增长', `roleId` bigint(20) NULL DEFAULT NULL COMMENT '角色ID，主键', `modelIds` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模块ID，主键', `censusIds` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模块下的数据统计', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 75 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色模块数据'; -- ---------------------------- -- Records of mortals_xhx_role_model -- ---------------------------- BEGIN; INSERT INTO `mortals_xhx_role_model` VALUES (68, 1, '1,2,3,4,5,7,9,10,12,14,15,16,17,25,27,29,30,28,33,34,35,36', '1,2,3,4,5,6,8,9,10,11,12,13,14,15,17'); COMMIT; -- ---------------------------- -- Table structure for mortals_xhx_role_user -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_role_user`; CREATE TABLE `mortals_xhx_role_user` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '序号，主键，自增长', `roleId` bigint(20) NULL DEFAULT NULL COMMENT '角色ID', `userId` bigint(20) NULL DEFAULT NULL COMMENT '用户ID', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 24 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色用户关联'; -- ---------------------------- -- Records of mortals_xhx_role_user -- ---------------------------- BEGIN; INSERT INTO `mortals_xhx_role_user` VALUES (20, 1, 1); COMMIT; -- ---------------------------- -- Table structure for mortals_xhx_site_apps -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_site_apps`; CREATE TABLE `mortals_xhx_site_apps` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键,自增长', `siteId` bigint(20) NULL DEFAULT NULL COMMENT '站点ID，主键', `includApps` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '站点开通的应用', `excludeApps` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '站点排除的应用', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '站点应用对照列'; -- ---------------------------- -- Records of mortals_xhx_site_apps -- ---------------------------- BEGIN; COMMIT; -- ---------------------------- -- Table structure for mortals_xhx_system_service -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_system_service`; CREATE TABLE `mortals_xhx_system_service` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '系统API的ID，主键，自增长', `systemServiceName` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模块名称', `systemServiceCode` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模块编码', `systemServiceUrl` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模块地址', `packageName` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '包名称', `packagePath` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '包的下载路径', `packageVersion` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '包的版本', `apiStatus` tinyint(2) NULL DEFAULT NULL COMMENT '包的状态(1:启用,0:停用)', `createTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `lapseTime` datetime(0) NULL DEFAULT NULL COMMENT '失效时间', `packageRemark` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '包的说明', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'API服务'; -- ---------------------------- -- Records of mortals_xhx_system_service -- ---------------------------- BEGIN; COMMIT; -- ---------------------------- -- Table structure for mortals_xhx_system_service_api -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_system_service_api`; CREATE TABLE `mortals_xhx_system_service_api` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '系统API的ID，主键，自增长', `systemServiceName` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模块名称', `systemServiceCode` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模块编码', `systemServiceUrl` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模块地址', `apiName` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'API接口名称', `apiUrl` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'API接口（链接）', `apiVersion` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'API接口版本', `apiStatus` tinyint(2) NULL DEFAULT NULL COMMENT 'API接口状态(1:启用,0:停用)', `createTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `lapseTime` datetime(0) NULL DEFAULT NULL COMMENT '失效时间', `apiRemark` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'API接口说明', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'API服务'; -- ---------------------------- -- Records of mortals_xhx_system_service_api -- ---------------------------- BEGIN; COMMIT; -- ---------------------------- -- Table structure for mortals_xhx_table_index -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_table_index`; CREATE TABLE `mortals_xhx_table_index` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '菜单ID，主键，自增长', `tableName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '表名称', `tableMark` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '表标识', `createTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '分索引信息业务'; -- ---------------------------- -- Records of mortals_xhx_table_index -- ---------------------------- BEGIN; COMMIT; -- ---------------------------- -- Table structure for mortals_xhx_task -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_task`; CREATE TABLE `mortals_xhx_task` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '序号，主键，自增长', `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '任务名称', `taskKey` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '任务关键字，区分任务执行流程', `status` tinyint(2) NULL DEFAULT NULL COMMENT '任务状态，(0,未启动，1.执行中)', `excuteService` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '任务执行服务', `excuteParam` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '任务执行参数', `excuteHost` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '任务执行主机，为空表示不限制任务的执行主机，多个用逗号分隔', `excuteStrategy` tinyint(2) NULL DEFAULT NULL COMMENT '执行策略(1.按日，2.按周，3.按月，4.按间隔时间)', `excuteDate` int(11) NULL DEFAULT NULL COMMENT '执行日期，按日：则为0；按周：则为1-7；按月：则为：1-31；按间隔时间：则为间隔时间，单位：秒；', `excuteTime` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '执行时间，格式：HH:mm，', `remark` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注', `lastExcuteHost` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '最后执行主机', `lastExcuteTime` datetime(0) NULL DEFAULT NULL COMMENT '最后执行时间', `interimExcuteStatus` tinyint(2) NULL DEFAULT NULL COMMENT '临时执行状态，(0.未启用，1.立即执行并保留，2.立即执行并删除)', `createTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `createUserId` bigint(20) NULL DEFAULT NULL COMMENT '创建用户', `createUserName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建用户名称', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '任务信息业务'; -- ---------------------------- -- Records of mortals_xhx_task -- ---------------------------- BEGIN; INSERT INTO `mortals_xhx_task` VALUES (2, '分表创建任务', 'tableIndexService', 0, 'tableIndexService', NULL, NULL, 1, 0, '00:30', NULL, '192.168.1.106', '2021-08-18 00:30:01', 0, '2021-08-12 11:07:23', 1, '系统管理员'); COMMIT; -- ---------------------------- -- Table structure for mortals_xhx_uploadfile -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_uploadfile`; CREATE TABLE `mortals_xhx_uploadfile` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID，主键，自增长', `fileName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件名称', `filePath` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件路径', `fileType` tinyint(2) NULL DEFAULT NULL COMMENT '文件类型，(1.excel ,2. img,3.zip, 4.pdf)', `createTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `createUser` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建用户', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '上传文件业务'; -- ---------------------------- -- Records of mortals_xhx_uploadfile -- ---------------------------- BEGIN; COMMIT; -- ---------------------------- -- Table structure for mortals_xhx_user -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_user`; CREATE TABLE `mortals_xhx_user` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '用户ID，主键，自增长', `loginName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录名', `loginPwd` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录密码，使用md5双次加密', `loginLimitAddress` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录限制地址，多个IP地址用逗号分隔，可以使用IP段匹配，如：172.17.*非空：则只能该值内的IP可以登录', `realName` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名', `mobile` varchar(21) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户手机号', `phone` varchar(21) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户联系电话', `email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户邮箱', `qq` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'QQ号码', `userType` tinyint(2) NULL DEFAULT NULL COMMENT '用户类型(0.系统用户,1.普通用户,2.工作人员)', `siteIds` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属站点id,多个逗号分隔', `areaCodes` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属区域code,多个逗号分隔', `areaNames` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属区域名称,多个逗号分隔', `status` tinyint(2) NULL DEFAULT NULL COMMENT '用户状态(0.停用，1.正常，2.冻结，3.销户，4.离职)', `createTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `createUserId` bigint(20) NULL DEFAULT NULL COMMENT '创建用户', `createUserName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建用户名称', `lastLoginTime` datetime(0) NULL DEFAULT NULL COMMENT '最后一次登录时间', `lastLoginAddress` varchar(21) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '最后一次登录地址', `saltKey` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码盐值', `lastUpdatePwdTime` datetime(0) NULL DEFAULT NULL COMMENT '最后一次修改密码时间', `errorCount` tinyint(2) NULL DEFAULT 0 COMMENT '当日登录失败数', `loginLock` tinyint(2) NULL DEFAULT 0 COMMENT '登录锁定状态0未锁定1已锁定', `lockTime` datetime(0) NULL DEFAULT NULL COMMENT '锁定时间', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `loginName`(`loginName`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户信息业务'; -- ---------------------------- -- Records of mortals_xhx_user -- ---------------------------- BEGIN; INSERT INTO `mortals_xhx_user` VALUES (1, 'admin', 'de7abfba6f99cb20b794867cdf664445', NULL, '系统管理员', '13808095770', NULL, NULL, NULL, 1, '1', '511124000000', '[{\"areaCode\":\"511124000000\",\"label\":\"井研县\"}]', 1, '2022-06-02 09:12:26', 1, 'admin', '2024-11-28 14:58:11', '127.0.0.1', 'sadyfp', '2099-11-24 13:45:06', 2, 1, '2024-10-22 16:27:18'); COMMIT; -- ---------------------------- -- Table structure for mortals_xhx_user_model_collect -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_user_model_collect`; CREATE TABLE `mortals_xhx_user_model_collect` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键，自增长', `userId` bigint(20) NULL DEFAULT NULL COMMENT '用户ID，主键，自增长', `realName` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录名', `modelIds` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '收藏模块', `createTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `siteId` bigint(20) NULL DEFAULT NULL COMMENT '站点ID', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户模块收藏'; -- ---------------------------- -- Records of mortals_xhx_user_model_collect -- ---------------------------- BEGIN; INSERT INTO `mortals_xhx_user_model_collect` VALUES (1, 1, '系统管理员', '1,3,17,45,19,25,30,10', '2023-11-23 09:41:40', 1), (2, 2084, '信宏翔', '1,2,4,3,5,15,13,7', '2023-12-20 15:41:26', 1), (3, 2086, '文娟', '2,4,5,25', '2024-04-25 12:32:25', 1), (4, 2087, '张平', '25', '2024-05-16 13:26:45', 1), (5, 2088, '张平1', '25', '2024-05-21 09:05:18', 1), (6, 2089, '郭香蕉专用', '1,2,4,28,25,16', '2024-07-02 11:09:58', 1), (7, 2090, '徐局长', '1,4,25', '2024-07-16 11:40:16', 1); COMMIT; -- ---------------------------- -- Table structure for mortals_xhx_user_pwd_record -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_user_pwd_record`; CREATE TABLE `mortals_xhx_user_pwd_record` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键，自增长', `userId` bigint(20) NULL DEFAULT NULL COMMENT '用户ID，主键，自增长', `loginName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录名', `loginPwd` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录密码，使用md5双次加密', `createTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `createUserId` bigint(20) NULL DEFAULT NULL COMMENT '创建用户', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户密码修改记录'; -- ---------------------------- -- Records of mortals_xhx_user_pwd_record -- ---------------------------- BEGIN; COMMIT; -- ---------------------------- -- Table structure for mortals_xhx_valid_code -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_valid_code`; CREATE TABLE `mortals_xhx_valid_code` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '菜单ID，主键，自增长', `code` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '验证码', `url` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '校验地址，email校验使用', `mobile` varchar(21) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '校验手机号', `email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '校验邮箱', `type` tinyint(2) NULL DEFAULT NULL COMMENT '校验方式(0.图片校验，1.手机校验，2.邮箱校验)', `sessionId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '会话ID', `ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'IP地址', `createTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `lapseTime` datetime(0) NULL DEFAULT NULL COMMENT '失效时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '验证码信息业务'; -- ---------------------------- -- Records of mortals_xhx_valid_code -- ---------------------------- BEGIN; COMMIT; SET FOREIGN_KEY_CHECKS = 1;