From f425ca4f837d9aec07670d4feefbde0a411f3a8a Mon Sep 17 00:00:00 2001
From: mrzcc <121184950@qq.com>
Date: 星期四, 06 二月 2020 19:05:07 +0800
Subject: [PATCH] 巡检点表sql

---
 java110-db/db/CommunityService/create_inspection_point.sql |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diff --git a/java110-db/db/CommunityService/inspection_point.sql b/java110-db/db/CommunityService/create_inspection_point.sql
similarity index 91%
rename from java110-db/db/CommunityService/inspection_point.sql
rename to java110-db/db/CommunityService/create_inspection_point.sql
index 006810c..37b4d7d 100644
--- a/java110-db/db/CommunityService/inspection_point.sql
+++ b/java110-db/db/CommunityService/create_inspection_point.sql
@@ -1,6 +1,6 @@
 --  宸℃鐐硅〃
 CREATE TABLE inspection_point(
-    `inspection_id` VARCHAR(30) NOT NULL UNIQUE COMMENT 'ID', `community_id` varchar(30) NOT NULL COMMENT '灏忓尯ID',
+    `inspection_id` VARCHAR(30) NOT NULL UNIQUE COMMENT 'ID',
     `b_id` varchar(30) NOT NULL COMMENT '涓氬姟Id',
     `inspection_name` VARCHAR(100) NOT NULL COMMENT '宸℃鍚嶇О',
     `machine_id` VARCHAR(30) NOT NULL COMMENT '璁惧ID',

--
Gitblit v1.8.0