From 983bdb5b89932b38d08a11ad1eed6ea89d1597e1 Mon Sep 17 00:00:00 2001 From: kongzy <kongzy> Date: 星期一, 29 一月 2024 10:07:31 +0800 Subject: [PATCH] 更新 --- assess-admin/src/main/resources/db/migration/V20231204001_device.sql | 27 ++++----------------------- 1 files changed, 4 insertions(+), 23 deletions(-) diff --git a/assess-admin/src/main/resources/db/migration/V20231204001_device.sql b/assess-admin/src/main/resources/db/migration/V20231204001_device.sql index c5c7a6f..39dafab 100644 --- a/assess-admin/src/main/resources/db/migration/V20231204001_device.sql +++ b/assess-admin/src/main/resources/db/migration/V20231204001_device.sql @@ -1,13 +1,14 @@ - -- ---------------------------- -- 设备表 -- ---------------------------- -drop table if exists `smart_assess`.`ass_device`; CREATE TABLE `smart_assess`.`ass_device` ( `id` bigint NOT NULL AUTO_INCREMENT, +`project_id` bigint NOT NULL COMMENT '项目id', `device_name` varchar(20) NOT NULL COMMENT '设备名称', -`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志(0正常，1删除，默认0)', +`start_date` datetime NOT NULL COMMENT '开始时间', +`end_date` datetime NOT NULL COMMENT '结束时间', `version` int NULL DEFAULT 0 COMMENT '乐观锁', +`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志(0正常，1删除，默认0)', `create_by` varchar(20) NULL COMMENT '创建人', `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_by` varchar(20) NULL COMMENT '更新人', @@ -15,24 +16,4 @@ `remark` varchar(100) NULL COMMENT '备注', PRIMARY KEY (`id`) ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '设备表' ROW_FORMAT = DYNAMIC; - - --- ---------------------------- --- 项目需要的设备清单表 --- ---------------------------- -drop table if exists `smart_assess`.`ass_project_device`; -CREATE TABLE `smart_assess`.`ass_project_device` ( -`id` bigint NOT NULL AUTO_INCREMENT, -`project_id` bigint NOT NULL COMMENT '项目id', -`device_id` bigint NOT NULL COMMENT '设备id', -`start_date` datetime NOT NULL COMMENT '开始时间', -`end_date` datetime NOT NULL COMMENT '结束时间', -`version` int NULL DEFAULT 0 COMMENT '乐观锁', -`create_by` varchar(20) NULL COMMENT '创建人', -`create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', -`update_by` varchar(20) NULL COMMENT '更新人', -`update_time` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', -`remark` varchar(100) NULL COMMENT '备注', -PRIMARY KEY (`id`) -) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '项目需要的设备清单表' ROW_FORMAT = DYNAMIC; -- Gitblit v1.9.2