From 5d2cfd4562f74496a5263db3451c1e78ff53aead Mon Sep 17 00:00:00 2001 From: heheng <475597332@qq.com> Date: 星期四, 27 三月 2025 08:44:16 +0800 Subject: [PATCH] 单据增加查询返回字段 --- assess-admin/src/main/resources/db/migration/V20231123004_config.sql | 8 ++++---- 1 files changed, 4 insertions(+), 4 deletions(-) diff --git a/assess-admin/src/main/resources/db/migration/V20231123004_config.sql b/assess-admin/src/main/resources/db/migration/V20231123004_config.sql index 02358e3..f39d74e 100644 --- a/assess-admin/src/main/resources/db/migration/V20231123004_config.sql +++ b/assess-admin/src/main/resources/db/migration/V20231123004_config.sql @@ -2,18 +2,18 @@ -- ---------------------------- -- 系统配置表 -- ---------------------------- -drop table if exists `smart_assess`.`sys_config`; CREATE TABLE `smart_assess`.`sys_config` ( `id` bigint NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL COMMENT '参数名称', `config_key` varchar(100) NOT NULL COMMENT '参数键名', `config_value` varchar(500) NOT NULL COMMENT '参数键值', `type` char(1) NULL DEFAULT 'N' COMMENT '系统内置(Y是 N否)', -`create_by` varchar(64) NULL DEFAULT '' COMMENT '创建人', +`version` int NULL DEFAULT 0 COMMENT '乐观锁', +`create_by` varchar(64) NULL COMMENT '创建人', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, -`update_by` varchar(64) NULL DEFAULT '' COMMENT '更新人', +`update_by` varchar(64) NULL COMMENT '更新人', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -`remark` varchar(100) NULL DEFAULT '' COMMENT '备注', +`remark` varchar(100) NULL COMMENT '备注', PRIMARY KEY (`id`), UNIQUE INDEX `index_key`(`config_key`) USING BTREE, UNIQUE INDEX `index_name`(`name`) USING BTREE -- Gitblit v1.9.2