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;
|
