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;