From 0e0d74df77bdbc0d7ac886d187b3cfbf9b30718d Mon Sep 17 00:00:00 2001
From: eight <641137800@qq.com>
Date: 星期二, 27 八月 2024 14:33:23 +0800
Subject: [PATCH] update

---
 sql/mysql/jh.sql |   27 ++++++++++++++-------------
 1 files changed, 14 insertions(+), 13 deletions(-)

diff --git a/sql/mysql/jh.sql b/sql/mysql/jh.sql
index 70a6f3a..97f3bc7 100644
--- a/sql/mysql/jh.sql
+++ b/sql/mysql/jh.sql
@@ -76,19 +76,20 @@
 -- ----------------------------
 DROP TABLE IF EXISTS `clinic_room`;
 CREATE TABLE `clinic_room` (
-   `id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
-   `room_id` bigint NOT NULL COMMENT '璇婂缂栧彿',
-   `room_name` varchar(10) NOT NULL COMMENT '璇婂鍚嶇О',
-   `bed_no` varchar(10) NOT NULL COMMENT '璇婄枟搴婄紪鍙�',
-   `status` int NOT NULL DEFAULT '0',
-   `doc_id` bigint DEFAULT NULL,
-   `doc_name` varchar(10) DEFAULT '',
-   `creator` varchar(10) DEFAULT '' COMMENT '鍒涘缓鑰�',
-   `create_time` datetime NOT NULL COMMENT '鍒涘缓鏃堕棿',
-   `updater` varchar(10) DEFAULT '' COMMENT '鏇存柊鑰�',
-   `update_time` datetime NOT NULL COMMENT '鏇存柊鏃堕棿',
-   `deleted` bit(1) DEFAULT b'0' COMMENT '鍒犻櫎鏍囪',
-   PRIMARY KEY (`id`)
+       `id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
+       `room_id` bigint NOT NULL COMMENT '璇婂缂栧彿',
+       `room_name` varchar(10) NOT NULL COMMENT '璇婂鍚嶇О',
+       `bed_no` varchar(10) NOT NULL COMMENT '璇婄枟搴婄紪鍙�',
+       `status` int NOT NULL DEFAULT '0',
+       `doc_id` bigint DEFAULT NULL,
+       `doc_name` varchar(10) DEFAULT '',
+       `creator` varchar(10) DEFAULT '' COMMENT '鍒涘缓鑰�',
+       `create_time` datetime NOT NULL COMMENT '鍒涘缓鏃堕棿',
+       `updater` varchar(10) DEFAULT '' COMMENT '鏇存柊鑰�',
+       `update_time` datetime NOT NULL COMMENT '鏇存柊鏃堕棿',
+       `deleted` bit(1) DEFAULT b'0' COMMENT '鍒犻櫎鏍囪',
+       PRIMARY KEY (`id`),
+       UNIQUE KEY `unique-room-bed` (`room_id`,`bed_no`) USING BTREE
 ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='璇婂鍜岃瘖鐤楀簥琛�';
 
 -- ----------------------------

--
Gitblit v1.9.3