-
Notifications
You must be signed in to change notification settings - Fork 2
/
migration.txt
105 lines (82 loc) · 2.98 KB
/
migration.txt
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
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
-----------------------------------------
OpenReports 3 Birt 2.3.1 to 3.7.1 Migration
-----------------------------------------
Added new columns on REPORT table
PPT_EXPORT NUMBER(1) default 0,
ODT_EXPORT NUMBER(1) default 0,
ODS_EXPORT NUMBER(1) default 0,
ODP_EXPORT NUMBER(1) default 0,
PS_EXPORT NUMBER(1) default 0,
HTML_EMBEDDED_EXPORT NUMBER(1) default 0
For further details read the file readme-cuc-it.txt
-----------------------------------------
OpenReports 2.0 to 3.0 Migration
-----------------------------------------
- Upgrade Quartz Database
- http://www.opensymphony.com/quartz/wikidocs/Quartz%201.6.0.html
- Create new tables
- OR_TAGS
- REPORT_DELIVERY_LOG
- Add new columns to existing tables
- REPORT
- IMAGE_EXPORT - Boolean
- REPORT_LOG
- EXPORT_TYPE - Integer
- REQUEST_ID - String
- REPORT_PARAMETER
- DEFAULT_VALUE - String
- REPORT_CHART
- OVERLAY_CHART_ID - Integer
- OR_TAG
- TAG_TYPE - String
- Refer to the database/schema directory for database specific schema
including Foreign Key constraints for new tables and fields.
- OpenReports 3.0 requires JDK 1.5.
- OpenReports 3.0 QueryReport templates use FreeMarker instead of Velocity.
-----------------------------------------
OpenReports 2.0-M2 to 2.0-FINAL Migration
-----------------------------------------
- ADD NEW COLUMNS TO EXISTING TABLES
- REPORT_LOG
- ALERT_ID - Integer
- Refer to the database/schema directory for database specific schema
including Foreign Key constraints for new tables and fields.
--------------------------------------
OpenReports 2.0-M1 to 2.0-M2 Migration
--------------------------------------
- CREATE NEW TABLES
- USER_SECURITY
- ADD NEW COLUMNS TO EXISTING TABLES
- REPORT_CHART
- SHOW_VALUES - Boolean
- Insert 'ROOT_ADMIN_ROLE' into USER_SECURITY for at least one user.
- Refer to the database/schema directory for database specific schema
including Foreign Key constraints for new tables and fields.
-----------------------------------
OpenReports 1.0 to 2.0-M1 Migration
-----------------------------------
- CREATE NEW TABLES
- REPORT_EXPORT_OPTIONS
- REPORT_ALERT
- USER_ALERT_MAP
- ADD NEW COLUMNS TO EXISTING TABLES
- REPORT
- RTF_EXPORT - Boolean
- TEXT_EXPORT - Boolean
- EXCEL_EXPORT - Boolean
- FILL_VIRTUAL - Boolean
- HIDDEN_REPORT - Boolean
- EXPORT_OPTION_ID - Integer
- REPORT_CHART
- SHOW_LEGEND - Boolean
- SHOW_TITLE - Boolean
- PLOT_ORIENTATION - Integer
- REPORT_ID - Integer
- REPORT_USER
- DEFAULT_REPORT_ID - Integer
- QUARTZ TABLE CHANGE
- QRTZ_TRIGGERS
- alter table QRTZ_TRIGGERS add JOB_DATA BINARY
- Refer to the database/schema directory for database specific schema
including Foreign Key constraints for new tables and fields.
- You may also need to delete and recreate all scheduled reports.