1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
| -- 报表是独立交付内容，不引用测试外键，也不进入测试整体删除范围。
| CREATE TABLE t_compare_report (
| report_id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
| report_name VARCHAR(100) NOT NULL,
| creator_id BIGINT NOT NULL,
| creator_name VARCHAR(64) NOT NULL,
| created_at_utc DATETIME(3) NOT NULL
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='对比报表身份';
|
| CREATE TABLE t_compare_report_version (
| version_id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
| report_id BIGINT NOT NULL,
| version_no INT NOT NULL,
| snapshot_json JSON NOT NULL,
| operator_id BIGINT NOT NULL,
| operator_name VARCHAR(64) NOT NULL,
| created_at_utc DATETIME(3) NOT NULL,
| change_summary VARCHAR(500) NOT NULL,
| UNIQUE KEY uk_compare_report_version (report_id, version_no)
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='对比报表独立版本';
|
| INSERT INTO sys_menu(menu_name,parent_id,order_num,path,menu_type,visible,status,perms,create_by,create_time)
| VALUES ('数据分析',0,6,'data-analysis','M','0','0','','system',UTC_TIMESTAMP(3));
| SET @analysis_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 ('对比报表',@analysis_menu_id,1,'report-compare','C','0','0','','system',UTC_TIMESTAMP(3));
| SET @compare_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 ('查看',@compare_menu_id,1,'#','F','0','0','system:compare-report:query','system',UTC_TIMESTAMP(3)),
| ('新增',@compare_menu_id,2,'#','F','0','0','system:compare-report:add','system',UTC_TIMESTAMP(3));
|
|
