P1问题fix

longz

2026-07-17 da9b7a52dbc6fcd2173efef90528d8fccc322554

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
SET @schema_name = DATABASE();
 
SET @transformer_power_exists = (
    SELECT COUNT(*)
    FROM information_schema.COLUMNS
    WHERE TABLE_SCHEMA = @schema_name
      AND TABLE_NAME = 't_site'
      AND COLUMN_NAME = 'transformer_power'
);
SET @transformer_power_sql = IF(
    @transformer_power_exists = 0,
    'ALTER TABLE `t_site` ADD COLUMN `transformer_power` decimal(12,2) NULL DEFAULT NULL COMMENT ''变压器功率（kW）'' AFTER `construction_site`',
    'SELECT 1'
);
PREPARE transformer_power_stmt FROM @transformer_power_sql;
EXECUTE transformer_power_stmt;
DEALLOCATE PREPARE transformer_power_stmt;
 
SET @member_discount_flag_exists = (
    SELECT COUNT(*)
    FROM information_schema.COLUMNS
    WHERE TABLE_SCHEMA = @schema_name
      AND TABLE_NAME = 't_site'
      AND COLUMN_NAME = 'member_discount_flag'
);
SET @member_discount_flag_sql = IF(
    @member_discount_flag_exists = 0,
    'ALTER TABLE `t_site` ADD COLUMN `member_discount_flag` tinyint NULL DEFAULT 0 COMMENT ''是否参与会员折扣（0=否，1=是）'' AFTER `transformer_power`',
    'SELECT 1'
);
PREPARE member_discount_flag_stmt FROM @member_discount_flag_sql;
EXECUTE member_discount_flag_stmt;
DEALLOCATE PREPARE member_discount_flag_stmt;