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/V20231124001_region.sql | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/assess-admin/src/main/resources/db/migration/V20231124001_region.sql b/assess-admin/src/main/resources/db/migration/V20231124001_region.sql index 1d4a9d8..f83ebec 100644 --- a/assess-admin/src/main/resources/db/migration/V20231124001_region.sql +++ b/assess-admin/src/main/resources/db/migration/V20231124001_region.sql @@ -2,12 +2,12 @@ -- ---------------------------- -- 系统地区表 -- ---------------------------- -drop table if exists `smart_assess`.`sys_region`; CREATE TABLE `smart_assess`.`sys_region` ( `id` bigint(0) NOT NULL AUTO_INCREMENT, `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '地区名称', `sort` int NULL DEFAULT 0 COMMENT '排序', `parent_id` bigint NOT NULL DEFAULT 0 COMMENT '父主键', +`version` int NULL DEFAULT 0 COMMENT '乐观锁', `region_type` tinyint NULL DEFAULT 0 COMMENT '地区类型(0是疆内，1是疆外，默认0)', `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '创建人', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, -- Gitblit v1.9.2