You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
125 lines
15 KiB
125 lines
15 KiB
-- 微笑榆山二期相关表结构修改
|
|
-- ——————————————————————————————————————————————————————————————————————————————————————————————————
|
|
-- 物业模块
|
|
DROP TABLE IF EXISTS `epdc_property`;
|
|
CREATE TABLE `epdc_property` (
|
|
`ID` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键',
|
|
`PROPERTY_NAME` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '物业名称',
|
|
`PROPERTY_CODE` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '物业编码',
|
|
`EFFECTIVE_FLAG` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '是否有效(0-否，1-是)',
|
|
`REVISION` int(11) NOT NULL DEFAULT 0 COMMENT '乐观锁',
|
|
`DEL_FLAG` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '删除标记(0-否，1-是)',
|
|
`CREATED_BY` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建人',
|
|
`CREATED_TIME` datetime(0) NOT NULL COMMENT '创建时间',
|
|
`UPDATED_BY` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '更新人',
|
|
`UPDATED_TIME` datetime(0) NOT NULL COMMENT '更新时间',
|
|
PRIMARY KEY (`ID`) USING BTREE
|
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '物业表' ROW_FORMAT = Compact;
|
|
|
|
INSERT INTO `epdc_property`(`ID`, `PROPERTY_NAME`, `PROPERTY_CODE`, `EFFECTIVE_FLAG`, `REVISION`, `DEL_FLAG`, `CREATED_BY`, `CREATED_TIME`, `UPDATED_BY`, `UPDATED_TIME`) VALUES ('17528acce15b4a019a9034fd650924a6', '济南诚远物业管理有限公司', 'JNCHY', '1', 0, '0', '1263011454953480193', '2020-05-28 15:52:19', '1263011454953480193', '2020-05-28 15:52:19');
|
|
INSERT INTO `epdc_property`(`ID`, `PROPERTY_NAME`, `PROPERTY_CODE`, `EFFECTIVE_FLAG`, `REVISION`, `DEL_FLAG`, `CREATED_BY`, `CREATED_TIME`, `UPDATED_BY`, `UPDATED_TIME`) VALUES ('aec3693e310ed0a706d8be5c4cf02574', '济南顺成物业管理有限公司', 'JNSHCH', '1', 0, '0', '1263011454953480193', '2020-05-28 15:51:55', '1263011454953480193', '2020-05-28 15:51:55');
|
|
INSERT INTO `epdc_property`(`ID`, `PROPERTY_NAME`, `PROPERTY_CODE`, `EFFECTIVE_FLAG`, `REVISION`, `DEL_FLAG`, `CREATED_BY`, `CREATED_TIME`, `UPDATED_BY`, `UPDATED_TIME`) VALUES ('665e5f70f460c87899376aa09c3a2595', '济南会仙物业管理有限公司', 'JNHX', '1', 0, '0', '1263011454953480193', '2020-05-28 15:51:38', '1263011454953480193', '2020-05-28 15:51:38');
|
|
INSERT INTO `epdc_property`(`ID`, `PROPERTY_NAME`, `PROPERTY_CODE`, `EFFECTIVE_FLAG`, `REVISION`, `DEL_FLAG`, `CREATED_BY`, `CREATED_TIME`, `UPDATED_BY`, `UPDATED_TIME`) VALUES ('774abdee6ee6be3598a1810c1b4beb6b', '济南瑞坤物业管理有限公司', 'JNRK', '1', 0, '0', '1263011454953480193', '2020-05-28 15:51:24', '1263011454953480193', '2020-05-28 15:51:24');
|
|
INSERT INTO `epdc_property`(`ID`, `PROPERTY_NAME`, `PROPERTY_CODE`, `EFFECTIVE_FLAG`, `REVISION`, `DEL_FLAG`, `CREATED_BY`, `CREATED_TIME`, `UPDATED_BY`, `UPDATED_TIME`) VALUES ('5c4f109f79cc5a51c7203117c3b460b3', '济南东通物业管理有限公司', 'JNDT', '1', 0, '0', '1263011454953480193', '2020-05-28 15:51:04', '1263011454953480193', '2020-05-28 15:51:04');
|
|
|
|
|
|
CREATE TABLE `epdc_police` (
|
|
`ID` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键',
|
|
`POLICE_NAME` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '民警名称',
|
|
`POLICE_AVATAR` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '民警照片地址',
|
|
`POLICE_TEL` varchar(18) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '民警联系方式',
|
|
`POLICE_NO` varchar(18) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '警号',
|
|
`DEPT_NAME` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '民警所在机构名称',
|
|
`DEPT_ID` bigint(20) NOT NULL COMMENT '民警所在机构id（此处存储社区id）',
|
|
`DISPLAY_FLAG` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '1' COMMENT '是否展示 0否 ，1是',
|
|
`DEL_FLAG` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '删除标记 0：未删除，1：已删除',
|
|
`REVISION` int(11) NULL DEFAULT NULL COMMENT '乐观锁',
|
|
`CREATED_BY` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建人',
|
|
`CREATED_TIME` datetime(0) NOT NULL COMMENT '创建时间',
|
|
`UPDATED_BY` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '更新人',
|
|
`UPDATED_TIME` datetime(0) NOT NULL COMMENT '更新时间',
|
|
`ALL_DEPT_IDS` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所有部门ID',
|
|
`ALL_DEPT_NAMES` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所有部门名称',
|
|
`PARENT_DEPT_IDS` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '父所有部门',
|
|
`PARENT_DEPT_NAMES` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '父所有部门',
|
|
PRIMARY KEY (`ID`) USING BTREE,
|
|
INDEX `epdc_group_GRID_ID_IDX`(`DEPT_ID`) USING BTREE
|
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '民警表' ROW_FORMAT = Compact;
|
|
|
|
DROP TABLE IF EXISTS `epdc_property_project_score`;
|
|
CREATE TABLE `epdc_property_project_score` (
|
|
`ID` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键',
|
|
`PROJECT_ID` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '物业项目ID',
|
|
`PROPERTY_ID` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '物业ID',
|
|
`USER_ID` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户ID',
|
|
`SCORE` decimal(4, 1) NOT NULL DEFAULT 0.0 COMMENT '得分',
|
|
`REVISION` int(11) NOT NULL DEFAULT 0 COMMENT '乐观锁',
|
|
`DEL_FLAG` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '删除标记(0-否，1-是)',
|
|
`CREATED_BY` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建人',
|
|
`CREATED_TIME` datetime(0) NOT NULL COMMENT '创建时间',
|
|
`UPDATED_BY` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '更新人',
|
|
`UPDATED_TIME` datetime(0) NOT NULL COMMENT '更新时间',
|
|
PRIMARY KEY (`ID`) USING BTREE
|
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '物业项目得分表' ROW_FORMAT = Compact;
|
|
|
|
ALTER TABLE epdc_property_project ADD COLUMN `PROPERTY_ID` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '物业ID';
|
|
-- 话题表新增群类别字段
|
|
ALTER TABLE epdc_topic ADD COLUMN `GROUP_CATEGORY` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '群类别 2：物业群；3警民群';
|
|
-- 已有话题类别全部为物业群
|
|
UPDATE epdc_topic SET GROUP_CATEGORY = '2';
|
|
|
|
|
|
|
|
|
|
-- ——————————————————————————————————————————————————————————————————————————————————————————————————
|
|
-- 新闻模块
|
|
ALTER TABLE epdc_news_category ADD COLUMN `INDEPENDENT_FLAG` VARCHAR ( 1 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '是否有独立的模块功能 0:否;1:是';
|
|
--
|
|
UPDATE epdc_news_category SET `INDEPENDENT_FLAG` = '0';
|
|
INSERT INTO `epdc_news_category`(`ID`, `CATEGORY_NAME`, `CATEGORY_CODE`, `DESCRIPTION`, `SORT`, `DEL_FLAG`, `REVISION`, `CREATED_BY`, `CREATED_TIME`, `UPDATED_BY`, `UPDATED_TIME`, `INDEPENDENT_FLAG`) VALUES ('c3fa1d4d907f3d8b884eb635f1faeb22', '警情通报', 'police_notice', '微笑榆山-平安榆山-警情通报', 200, '0', 0, '1', '2020-05-26 16:29:53', '1', '2020-05-26 16:29:53', '1');
|
|
INSERT INTO `epdc_news_category`(`ID`, `CATEGORY_NAME`, `CATEGORY_CODE`, `DESCRIPTION`, `SORT`, `DEL_FLAG`, `REVISION`, `CREATED_BY`, `CREATED_TIME`, `UPDATED_BY`, `UPDATED_TIME`, `INDEPENDENT_FLAG`) VALUES ('df2d23bb3ce93af2aa254822c53620b9', '平安防范', 'safety_precautions', '微笑榆山-平安榆山-平安防范', 201, '0', 0, '1263011454953480193', '2020-05-21 17:32:37', '1263011454953480193', '2020-05-21 17:47:26', '1');
|
|
ALTER TABLE epdc_news MODIFY COLUMN NEWS_CONTENT MEDIUMTEXT;
|
|
ALTER TABLE epdc_notice MODIFY COLUMN NOTICE_CONTENT MEDIUMTEXT;
|
|
|
|
-- ——————————————————————————————————————————————————————————————————————————————————————————————————
|
|
-- api模块
|
|
CREATE TABLE `epdc_startup_page` (
|
|
`ID` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键',
|
|
`IMG_URL` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '图片地址',
|
|
`DURATION` int(11) NOT NULL COMMENT '停留时长 单位：秒',
|
|
`ENABLE_FLAG` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '启用标识 0：否，1：是',
|
|
`REMARK` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
|
|
`REVISION` int(11) NULL DEFAULT NULL COMMENT '乐观锁',
|
|
`CREATED_BY` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建人',
|
|
`CREATED_TIME` datetime(0) NOT NULL COMMENT '创建时间',
|
|
`UPDATED_BY` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '更新人',
|
|
`UPDATED_TIME` datetime(0) NOT NULL COMMENT '更新时间',
|
|
`DEL_FLAG` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '删除标记',
|
|
`SORT` int(11) NULL DEFAULT 0 COMMENT '排序',
|
|
PRIMARY KEY (`ID`) USING BTREE
|
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '启动页管理 启动页管理' ROW_FORMAT = Compact;
|
|
|
|
-- ——————————————————————————————————————————————————————————————————————————————————————————————————
|
|
-- admin模块
|
|
INSERT INTO `sys_menu`(`id`, `pid`, `url`, `type`, `icon`, `permissions`, `sort`, `del_flag`, `creator`, `create_date`, `updater`, `update_date`, `menu_code`) VALUES (1263374024260476929, 0, '', 0, 'icon-file-markdown', '', 100, 0, 1, '2020-05-21 15:40:14', 1263011454953480193, '2020-05-26 14:11:33', '');
|
|
INSERT INTO `sys_menu`(`id`, `pid`, `url`, `type`, `icon`, `permissions`, `sort`, `del_flag`, `creator`, `create_date`, `updater`, `update_date`, `menu_code`) VALUES (1263374388162486273, 1263374024260476929, 'police/police', 0, 'icon-audit', '', 0, 0, 1, '2020-05-21 15:41:41', 1, '2020-05-21 15:41:41', '');
|
|
INSERT INTO `sys_menu`(`id`, `pid`, `url`, `type`, `icon`, `permissions`, `sort`, `del_flag`, `creator`, `create_date`, `updater`, `update_date`, `menu_code`) VALUES (1263374778954178561, 1263374024260476929, 'police/group', 0, 'icon-team', '', 10, 0, 1, '2020-05-21 15:43:14', 1263011454953480193, '2020-05-26 14:16:32', '');
|
|
INSERT INTO `sys_menu`(`id`, `pid`, `url`, `type`, `icon`, `permissions`, `sort`, `del_flag`, `creator`, `create_date`, `updater`, `update_date`, `menu_code`) VALUES (1263374898068217858, 1263374024260476929, 'police/topic', 0, '', '', 0, 1, 1, '2020-05-21 15:43:43', 1, '2020-05-21 15:48:37', '');
|
|
INSERT INTO `sys_menu`(`id`, `pid`, `url`, `type`, `icon`, `permissions`, `sort`, `del_flag`, `creator`, `create_date`, `updater`, `update_date`, `menu_code`) VALUES (1263375630787960834, 1263374024260476929, 'police/topic', 0, 'icon-codelibrary', '', 20, 0, 1, '2020-05-21 15:46:37', 1263011454953480193, '2020-05-26 14:16:49', '');
|
|
INSERT INTO `sys_menu`(`id`, `pid`, `url`, `type`, `icon`, `permissions`, `sort`, `del_flag`, `creator`, `create_date`, `updater`, `update_date`, `menu_code`) VALUES (1263376248533442562, 1263375630787960834, '', 1, '', 'police:topic:export', 0, 0, 1, '2020-05-21 15:49:05', 1263011454953480193, '2020-05-26 16:46:40', '');
|
|
INSERT INTO `sys_menu`(`id`, `pid`, `url`, `type`, `icon`, `permissions`, `sort`, `del_flag`, `creator`, `create_date`, `updater`, `update_date`, `menu_code`) VALUES (1263377067068645378, 1263374388162486273, '', 1, '', 'police:police:save', 0, 0, 1, '2020-05-21 15:52:20', 1265536510657060865, '2020-05-27 17:02:42', '');
|
|
INSERT INTO `sys_menu`(`id`, `pid`, `url`, `type`, `icon`, `permissions`, `sort`, `del_flag`, `creator`, `create_date`, `updater`, `update_date`, `menu_code`) VALUES (1263389245565853697, 1263374388162486273, '', 1, '', 'police:police:update', 0, 0, 1, '2020-05-21 16:40:43', 1265536510657060865, '2020-05-27 17:02:23', '');
|
|
INSERT INTO `sys_menu`(`id`, `pid`, `url`, `type`, `icon`, `permissions`, `sort`, `del_flag`, `creator`, `create_date`, `updater`, `update_date`, `menu_code`) VALUES (1263389459173367809, 1263374388162486273, '', 1, '', 'police:police:delete', 0, 0, 1, '2020-05-21 16:41:34', 1265536510657060865, '2020-05-27 17:02:33', '');
|
|
INSERT INTO `sys_menu`(`id`, `pid`, `url`, `type`, `icon`, `permissions`, `sort`, `del_flag`, `creator`, `create_date`, `updater`, `update_date`, `menu_code`) VALUES (1265920816797736962, 1263374388162486273, '', 1, '', 'police:police:supplement', 3, 0, 1263011454953480193, '2020-05-28 16:20:17', 1263011454953480193, '2020-05-28 16:20:17', '');
|
|
|
|
|
|
INSERT INTO `sys_language`(`table_name`, `table_id`, `field_name`, `field_value`, `language`) VALUES ('sys_menu', 1263374024260476929, 'name', '警民管理', 'zh-CN');
|
|
INSERT INTO `sys_language`(`table_name`, `table_id`, `field_name`, `field_value`, `language`) VALUES ('sys_menu', 1263374388162486273, 'name', '民警管理', 'zh-CN');
|
|
INSERT INTO `sys_language`(`table_name`, `table_id`, `field_name`, `field_value`, `language`) VALUES ('sys_menu', 1263374778954178561, 'name', '警民群管理', 'zh-CN');
|
|
INSERT INTO `sys_language`(`table_name`, `table_id`, `field_name`, `field_value`, `language`) VALUES ('sys_menu', 1263374898068217858, 'name', '民警话题管理', 'zh-CN');
|
|
INSERT INTO `sys_language`(`table_name`, `table_id`, `field_name`, `field_value`, `language`) VALUES ('sys_menu', 1263375630787960834, 'name', '警民话题管理', 'zh-CN');
|
|
INSERT INTO `sys_language`(`table_name`, `table_id`, `field_name`, `field_value`, `language`) VALUES ('sys_menu', 1263377067068645378, 'name', '新增', 'zh-CN');
|
|
INSERT INTO `sys_language`(`table_name`, `table_id`, `field_name`, `field_value`, `language`) VALUES ('sys_menu', 1263389245565853697, 'name', '修改', 'zh-CN');
|
|
INSERT INTO `sys_language`(`table_name`, `table_id`, `field_name`, `field_value`, `language`) VALUES ('sys_menu', 1263389459173367809, 'name', '删除', 'zh-CN');
|
|
INSERT INTO `sys_language`(`table_name`, `table_id`, `field_name`, `field_value`, `language`) VALUES ('sys_menu', 1265920816797736962, 'name', '警民群补建', 'zh-CN');
|
|
INSERT INTO `sys_language`(`table_name`, `table_id`, `field_name`, `field_value`, `language`) VALUES ('sys_menu', 1263376248533442562, 'name', '导出话题', 'zh-CN');
|
|
|