section_reference_block/add_ref_template_id.sql at main - section_reference_block - Gitea: Git with a cup of tea

xuxy/section_reference_block

xxy aa98ea2623 @

Initial commit

Co-Authored-By: Claude Opus 4.8 <noreply@anthropic.com>
@

2026-06-05 18:45:29 +08:00

4 lines

317 B

SQL

Raw Permalink Blame History

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

 -- 为 report_section_references 增加 template_id，按模板过滤参考范文
 ALTER TABLE report_section_references ADD COLUMN template_id VARCHAR(64) NULL COMMENT '关联模板ID（report_templates.id），按模板过滤参考范文';
 CREATE INDEX idx_ref_template_id ON report_section_references(template_id);