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/V20231130003_contract.sql | 5 ++--- 1 files changed, 2 insertions(+), 3 deletions(-) diff --git a/assess-admin/src/main/resources/db/migration/V20231130003_contract.sql b/assess-admin/src/main/resources/db/migration/V20231130003_contract.sql index ad2d82b..aa67ef5 100644 --- a/assess-admin/src/main/resources/db/migration/V20231130003_contract.sql +++ b/assess-admin/src/main/resources/db/migration/V20231130003_contract.sql @@ -2,11 +2,10 @@ -- ---------------------------- -- 合同管理表 -- ---------------------------- -drop table if exists `smart_assess`.`ass_contract`; CREATE TABLE `smart_assess`.`ass_contract` ( `id` bigint NOT NULL AUTO_INCREMENT, -`contract_money` decimal NOT NULL COMMENT '合同价格/万', -`actual_contract_money` decimal NOT NULL COMMENT '实际合同价格/万', +`contract_money` varchar(30) NOT NULL COMMENT '合同价格/万', +`actual_contract_money` varchar(30) NULL COMMENT '实际合同价格/万', `contract_sign_date` datetime NOT NULL COMMENT '合同签订时间', `project_id` bigint NOT NULL COMMENT '项目id', `contract_introduction` varchar(100) NULL COMMENT '合同额外说明(100字以内)', -- Gitblit v1.9.2