1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
| -- 化成报表与来源测试独立；保存和整体删除复用对比版本规则。
| 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));
|
|
