-- 化成报表与来源测试独立；保存和整体删除复用对比版本规则。
CREATE TABLE t_formation_report LIKE t_compare_report;
ALTER TABLE t_formation_report COMMENT='化成报表身份';
CREATE TABLE t_formation_report_version LIKE t_compare_report_version;
ALTER TABLE t_formation_report_version COMMENT='化成报表独立版本';
CREATE TABLE t_formation_report_field_template LIKE t_compare_report_field_template;
ALTER TABLE t_formation_report_field_template
    ALTER COLUMN template_type SET DEFAULT 'formation', COMMENT='化成报表字段模板';

SET @analysis_menu_id = (SELECT menu_id FROM sys_menu WHERE path='data-analysis' AND parent_id=0 LIMIT 1);
INSERT INTO sys_menu(menu_name,parent_id,order_num,path,menu_type,visible,status,perms,create_by,create_time)
VALUES ('化成报表',@analysis_menu_id,2,'report-formation','C','0','0','','system',UTC_TIMESTAMP(3));
SET @formation_menu_id = LAST_INSERT_ID();
INSERT INTO sys_menu(menu_name,parent_id,order_num,path,menu_type,visible,status,perms,create_by,create_time)
VALUES ('查看',@formation_menu_id,1,'#','F','0','0','system:formation-report:query','system',UTC_TIMESTAMP(3)),
       ('新增',@formation_menu_id,2,'#','F','0','0','system:formation-report:add','system',UTC_TIMESTAMP(3)),
       ('编辑',@formation_menu_id,3,'#','F','0','0','system:formation-report:edit','system',UTC_TIMESTAMP(3)),
       ('删除',@formation_menu_id,4,'#','F','0','0','system:formation-report:remove','system',UTC_TIMESTAMP(3));