dotnet/sql/20260619_add_tk_pool_order_summary_switch.sql

SET @column_exists := (
    SELECT COUNT(*)
    FROM information_schema.columns
    WHERE table_schema = DATABASE()
      AND table_name = 'tk_pool'
      AND column_name = 'enable_order_summary_cache'
);

SET @sql := IF(
    @column_exists = 0,
    'ALTER TABLE tk_pool ADD COLUMN enable_order_summary_cache TINYINT(1) NOT NULL DEFAULT 1 COMMENT ''是否记录淘宝转链订单匹配缓存''',
    'SELECT 1'
);

PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;