SET @column_exists := (
    SELECT COUNT(1)
    FROM information_schema.COLUMNS
    WHERE TABLE_SCHEMA = DATABASE()
      AND TABLE_NAME = 't_partner'
      AND COLUMN_NAME = 'venue_share_amount'
);

SET @ddl := IF(
    @column_exists = 0,
    'ALTER TABLE `t_partner` ADD COLUMN `venue_share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT ''场地方合作商分账金额（元）'' AFTER `service_share_ratio`',
    'SELECT 1'
);

PREPARE stmt FROM @ddl;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;