-- 应付价卡每一版保存源文件在 OSS 上的地址，历史记录按这个地址下载。可重复执行。
SET NAMES utf8mb4;

SET @ddl = (
  SELECT IF(
    EXISTS (
      SELECT 1 FROM information_schema.COLUMNS
      WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'pay_product' AND COLUMN_NAME = 'file_path'
    ),
    'SELECT 1',
    'ALTER TABLE pay_product ADD COLUMN file_path varchar(500) DEFAULT NULL COMMENT ''源文件OSS地址，oss://bucket/key'' AFTER source_file'
  )
);
PREPARE stmt FROM @ddl;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;