From 9a8a4a431c61d22a334003b2e8a52571ea809920 Mon Sep 17 00:00:00 2001 From: heheng <475597332@qq.com> Date: 星期一, 24 三月 2025 13:15:34 +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