lingyue-zhibao/database/migrations/V2026_01_29_01__add_template_rating.sql

-- 添加模板评分字段
ALTER TABLE templates ADD COLUMN IF NOT EXISTS rating DECIMAL(2,1) DEFAULT 0.0;

COMMENT ON COLUMN templates.rating IS '模板评分 (0.0-5.0)';

-- 为现有模板设置默认评分
UPDATE templates SET rating = 4.5 WHERE rating IS NULL OR rating = 0;