water/server/plugin/saiadmin/db/20260826_add_merchant_business_time.sql

-- ============================================================
-- 商户营业时间
-- 日期: 2026-08-26
-- 说明: 兼容旧系统 business_time_des 展示文本字段。
-- ============================================================

SET @column_exists = (
    SELECT COUNT(*)
    FROM information_schema.COLUMNS
    WHERE TABLE_SCHEMA = DATABASE()
      AND TABLE_NAME = 'sa_merchant'
      AND COLUMN_NAME = 'business_time_des'
);
SET @sql = IF(
    @column_exists = 0,
    'ALTER TABLE `sa_merchant` ADD COLUMN `business_time_des` VARCHAR(64) NOT NULL DEFAULT ''09:00-22:00'' COMMENT ''营业时间展示文本'' AFTER `address`',
    'SELECT 1'
);
PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;