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/V20231123002_dict_type.sql | 6 +++--- 1 files changed, 3 insertions(+), 3 deletions(-) diff --git a/assess-admin/src/main/resources/db/migration/V20231123002_dict_type.sql b/assess-admin/src/main/resources/db/migration/V20231123002_dict_type.sql index 3a2b9af..6aaa2d0 100644 --- a/assess-admin/src/main/resources/db/migration/V20231123002_dict_type.sql +++ b/assess-admin/src/main/resources/db/migration/V20231123002_dict_type.sql @@ -2,12 +2,12 @@ -- ---------------------------- -- 字典类型表 -- ---------------------------- -drop table if exists `smart_assess`.`sys_dict_type`; CREATE TABLE `smart_assess`.`sys_dict_type` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '字典名称', `dict_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '字典类型', `status` tinyint NOT NULL DEFAULT 0 COMMENT '状态(0正常，1停用)', +`version` int NULL DEFAULT 0 COMMENT '乐观锁', `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP, `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, @@ -18,5 +18,5 @@ UNIQUE INDEX `index_type`(`dict_type`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '字典类型表' ROW_FORMAT = Dynamic; -insert into sys_dict_type values(1, '评价类型', 'sys_assess_type', 0, 'admin', sysdate(), '', sysdate(), '评价类型列表'); -insert into sys_dict_type values(2, '业务范围', 'sys_business_scope', 0, 'admin', sysdate(), '', sysdate(), '业务范围列表'); \ No newline at end of file +insert into sys_dict_type values(1, '评价类型', 'sys_assess_type', 0, 1, 'admin', sysdate(), '', sysdate(), '评价类型列表'); +insert into sys_dict_type values(2, '业务范围', 'sys_business_scope', 0, 1, 'admin', sysdate(), '', sysdate(), '业务范围列表'); \ No newline at end of file -- Gitblit v1.9.2