From 50c669c09a7b392af22706e6fb1fa8a4c335d8eb Mon Sep 17 00:00:00 2001 From: kongzy <kongzy> Date: 星期五, 15 三月 2024 13:23:11 +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