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

SET @ddl := IF(
    @column_exists = 0,
    'ALTER TABLE `t_accounting_strategy` ADD COLUMN `partner_id` int NULL DEFAULT NULL COMMENT ''归属合作商id'' AFTER `site_id`',
    'SELECT 1'
);

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