From 9b0eee07b3bb5f3fcddff5bc44c4fc61108eb25c Mon Sep 17 00:00:00 2001
From: eight <641137800@qq.com>
Date: 星期一, 23 九月 2024 10:51:14 +0800
Subject: [PATCH] 新增 state @device @dev_rent

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

diff --git a/sql/mysql/jh.sql b/sql/mysql/jh.sql
index d15c42f..63129cb 100644
--- a/sql/mysql/jh.sql
+++ b/sql/mysql/jh.sql
@@ -123,16 +123,18 @@
   `brand` varchar(45) DEFAULT NULL COMMENT '鍝佺墝',
   `model` varchar(45) DEFAULT NULL COMMENT '鍨嬪彿',
   `purchase_date` date DEFAULT NULL COMMENT '閲囪喘鏃ユ湡',
-  `tenant_id` int DEFAULT 1 COMMENT '绉熸埛缂栧彿',
+  `lost` int DEFAULT '0' COMMENT '閬楀け鏍囪',
+  `lose_date` date DEFAULT NULL COMMENT '閬楀け鏃ユ湡',
+  `tenant_id` int DEFAULT '1' COMMENT '绉熸埛缂栧彿',
+  `state` int DEFAULT '0' COMMENT '0 - 绌洪棽  10 - 浣跨敤鐢�  20 - 宸查仐澶� ',
   `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 0 COMMENT '鍒犻櫎鏍囪',
+  `deleted` bit(1) DEFAULT b'0' COMMENT '鍒犻櫎鏍囪',
   PRIMARY KEY (`id`),
-  UNIQUE KEY `dev_id_UNIQUE` (`dev_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='璁惧琛�';
-
+  UNIQUE KEY `uni_dev_id` (`dev_id`)
+) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='璁惧琛�';
 
 -- ----------------------------
 -- Table structure for dev_rent
@@ -149,16 +151,20 @@
   `baseline` varchar(100) DEFAULT NULL COMMENT '鍩虹嚎绮�',
   `detachment` varchar(100) DEFAULT NULL COMMENT '鑴辩',
   `remark` varchar(100) DEFAULT NULL COMMENT '澶囨敞',
-  `cancelled` int DEFAULT '0' COMMENT '鏈畨瑁�',
+  `cancelled` int DEFAULT '0' COMMENT '鏀惧純瀹夎',
+  `lost` int DEFAULT '0',
   `tenant_id` int DEFAULT '1' COMMENT '绉熸埛缂栧彿',
+  `state` int DEFAULT '0' COMMENT '0 - 寰呰鏈�  10 - 宸茶鏈�  20 - 宸叉媶鏈� 30 - 宸叉斁寮� 40 - 宸查仐澶�',
   `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`),
-  KEY `indx_dev_rent` (`dev_id`,`rent_time`) USING BTREE
-) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='瑁呮満鎷嗘満琛�';
+  KEY `indx_dev_rent` (`dev_id`,`rent_time`) USING BTREE,
+  KEY `idx_pat_rent` (`pat_id`,`rent_time`) USING BTREE,
+  KEY `idx_state` (`state`)
+) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='瑁呮満鎷嗘満琛�';
 
 -- ----------------------------
 -- Table structure for job_record

--
Gitblit v1.9.3