|
1
|
alter table attachments add description varchar(255) default NULL;
|
|
2
|
alter table attachments modify content_type varchar(255) default '';
|
|
3
|
|
|
4
|
alter table auth_sources modify account varchar(255) default NULL;
|
|
5
|
alter table auth_sources add tls tinyint(1) NOT NULL default '0';
|
|
6
|
|
|
7
|
alter table boards modify position int(11) NOT NULL default '1';
|
|
8
|
|
|
9
|
alter table changes modify `from_revision` varchar(255) default NULL;
|
|
10
|
|
|
11
|
alter table changesets modify `revision` varchar(255) NOT NULL;
|
|
12
|
alter table changesets modify `committer` varchar(255) default NULL;
|
|
13
|
|
|
14
|
alter table custom_fields add `position` int(11) default '1';
|
|
15
|
alter table custom_fields add `searchable` tinyint(1) default '0';
|
|
16
|
alter table custom_fields add `default_value` text;
|
|
17
|
|
|
18
|
alter table custom_values add KEY `custom_values_customized` (`customized_type`,`customized_id`);
|
|
19
|
|
|
20
|
CREATE TABLE `enabled_modules` (
|
|
21
|
`id` int(11) NOT NULL auto_increment,
|
|
22
|
`project_id` int(11) default NULL,
|
|
23
|
`name` varchar(255) NOT NULL,
|
|
24
|
PRIMARY KEY (`id`),
|
|
25
|
KEY `enabled_modules_project_id` (`project_id`)
|
|
26
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
27
|
|
|
28
|
alter table enumerations add `position` int(11) default '1';
|
|
29
|
alter table enumerations add `is_default` tinyint(1) NOT NULL default '0';
|
|
30
|
|
|
31
|
ALTER TABLE `enumerations` DISABLE KEYS;
|
|
32
|
TRUNCATE TABLE enumerations;
|
|
33
|
INSERT INTO `enumerations` (`id`,`opt`,`name`,`position`,`is_default`) VALUES
|
|
34
|
(1,'DCAT','User documentation',1,0),
|
|
35
|
(2,'DCAT','Technical documentation',2,0),
|
|
36
|
(3,'IPRI','Low',1,0),
|
|
37
|
(4,'IPRI','Normal',2,1),
|
|
38
|
(5,'IPRI','High',3,0),
|
|
39
|
(6,'IPRI','Urgent',4,0),
|
|
40
|
(7,'IPRI','Immediate',5,0),
|
|
41
|
(8,'ACTI','Design',1,0),
|
|
42
|
(9,'ACTI','Development',2,0);
|
|
43
|
ALTER TABLE `enumerations` ENABLE KEYS;
|
|
44
|
|
|
45
|
alter table issue_statuses drop column `html_color`;
|
|
46
|
|
|
47
|
alter table issues add `estimated_hours` float default NULL;
|
|
48
|
|
|
49
|
alter table members add `mail_notification` tinyint(1) NOT NULL default '0';
|
|
50
|
|
|
51
|
alter table messages add `locked` tinyint(1) default '0';
|
|
52
|
alter table messages add `sticky` int(11) default '0';
|
|
53
|
|
|
54
|
alter table projects modify `description` text;
|
|
55
|
|
|
56
|
CREATE TABLE `projects_trackers` (
|
|
57
|
`project_id` int(11) NOT NULL default '0',
|
|
58
|
`tracker_id` int(11) NOT NULL default '0',
|
|
59
|
KEY `projects_trackers_project_id` (`project_id`)
|
|
60
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
61
|
|
|
62
|
alter table queries add `column_names` text;
|
|
63
|
|
|
64
|
alter table roles add `assignable` tinyint(1) default '1';
|
|
65
|
alter table roles add `builtin` int(11) NOT NULL default '0';
|
|
66
|
alter table roles add `permissions` text;
|
|
67
|
|
|
68
|
truncate table roles;
|
|
69
|
|
|
70
|
INSERT INTO `roles` (`id`,`name`,`position`,`assignable`,`builtin`,`permissions`) VALUES
|
|
71
|
(1,'Non member',1,1,1,'--- \n- :add_issues\n- :add_issue_notes\n- :save_queries\n- :view_gantt\n- :view_calendar\n- :view_time_entries\n- :comment_news\n- :view_documents\n- :view_wiki_pages\n- :add_messages\n- :view_files\n- :browse_repository\n- :view_changesets\n'),
|
|
72
|
(2,'Anonymous',2,1,2,'--- \n- :view_gantt\n- :view_calendar\n- :view_time_entries\n- :view_documents\n- :view_wiki_pages\n- :view_files\n- :browse_repository\n- :view_changesets\n'),
|
|
73
|
(3,'Manager',3,1,0,'--- \n- :edit_project\n- :select_project_modules\n- :manage_members\n- :manage_versions\n- :manage_categories\n- :add_issues\n- :edit_issues\n- :manage_issue_relations\n- :add_issue_notes\n- :edit_issue_notes\n- :edit_own_issue_notes\n- :move_issues\n- :delete_issues\n- :manage_public_queries\n- :save_queries\n- :view_gantt\n- :view_calendar\n- :log_time\n- :view_time_entries\n- :edit_time_entries\n- :edit_own_time_entries\n- :manage_news\n- :comment_news\n- :manage_documents\n- :view_documents\n- :manage_files\n- :view_files\n- :manage_wiki\n- :rename_wiki_pages\n- :delete_wiki_pages\n- :view_wiki_pages\n- :edit_wiki_pages\n- :manage_repository\n- :browse_repository\n- :view_changesets\n- :manage_boards\n- :add_messages\n- :edit_messages\n- :delete_messages\n'),
|
|
74
|
(4,'Developer',4,1,0,'--- \n- :manage_versions\n- :manage_categories\n- :add_issues\n- :edit_issues\n- :manage_issue_relations\n- :add_issue_notes\n- :save_queries\n- :view_gantt\n- :view_calendar\n- :log_time\n- :view_time_entries\n- :comment_news\n- :view_documents\n- :view_wiki_pages\n- :edit_wiki_pages\n- :delete_wiki_pages\n- :add_messages\n- :view_files\n- :manage_files\n- :browse_repository\n- :view_changesets\n'),
|
|
75
|
(5,'Reporter',5,1,0,'--- \n- :add_issues\n- :add_issue_notes\n- :save_queries\n- :view_gantt\n- :view_calendar\n- :log_time\n- :view_time_entries\n- :comment_news\n- :view_documents\n- :view_wiki_pages\n- :add_messages\n- :view_files\n- :browse_repository\n- :view_changesets\n');
|
|
76
|
|
|
77
|
UPDATE schema_info set `version` = 92;
|
|
78
|
|
|
79
|
alter table settings add `updated_on` datetime default NULL;
|
|
80
|
|
|
81
|
alter table trackers modify `position` int(11) default '1';
|
|
82
|
|
|
83
|
alter table user_preferences add `time_zone` varchar(255) default NULL;
|
|
84
|
|
|
85
|
alter table users add `type` varchar(255) default NULL;
|
|
86
|
|
|
87
|
alter table versions modify `name` varchar(255) default '';
|
|
88
|
|
|
89
|
CREATE TABLE `wiki_redirects` (
|
|
90
|
`id` int(11) NOT NULL auto_increment,
|
|
91
|
`wiki_id` int(11) NOT NULL,
|
|
92
|
`title` varchar(255) default NULL,
|
|
93
|
`redirects_to` varchar(255) default NULL,
|
|
94
|
`created_on` datetime NOT NULL,
|
|
95
|
PRIMARY KEY (`id`),
|
|
96
|
KEY `wiki_redirects_wiki_id_title` (`wiki_id`,`title`)
|
|
97
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
98
|
|
|
99
|
alter table workflows add KEY `wkfs_role_tracker_old_status` (`role_id`,`tracker_id`,`old_status_id`);
|
|
100
|
|
|
101
|
truncate table workflows;
|
|
102
|
|
|
103
|
INSERT INTO `workflows` (`id`,`tracker_id`,`old_status_id`,`new_status_id`,`role_id`) VALUES
|
|
104
|
(1,1,1,2,3),
|
|
105
|
(2,1,1,3,3),
|
|
106
|
(3,1,1,4,3),
|
|
107
|
(4,1,1,5,3),
|
|
108
|
(5,1,1,6,3),
|
|
109
|
(6,1,2,1,3),
|
|
110
|
(7,1,2,3,3),
|
|
111
|
(8,1,2,4,3),
|
|
112
|
(9,1,2,5,3),
|
|
113
|
(10,1,2,6,3),
|
|
114
|
(11,1,3,1,3),
|
|
115
|
(12,1,3,2,3),
|
|
116
|
(13,1,3,4,3),
|
|
117
|
(14,1,3,5,3),
|
|
118
|
(15,1,3,6,3),
|
|
119
|
(16,1,4,1,3),
|
|
120
|
(17,1,4,2,3),
|
|
121
|
(18,1,4,3,3),
|
|
122
|
(19,1,4,5,3),
|
|
123
|
(20,1,4,6,3),
|
|
124
|
(21,1,5,1,3),
|
|
125
|
(22,1,5,2,3),
|
|
126
|
(23,1,5,3,3),
|
|
127
|
(24,1,5,4,3),
|
|
128
|
(25,1,5,6,3),
|
|
129
|
(26,1,6,1,3),
|
|
130
|
(27,1,6,2,3),
|
|
131
|
(28,1,6,3,3),
|
|
132
|
(29,1,6,4,3),
|
|
133
|
(30,1,6,5,3),
|
|
134
|
(31,2,1,2,3),
|
|
135
|
(32,2,1,3,3),
|
|
136
|
(33,2,1,4,3),
|
|
137
|
(34,2,1,5,3),
|
|
138
|
(35,2,1,6,3),
|
|
139
|
(36,2,2,1,3),
|
|
140
|
(37,2,2,3,3),
|
|
141
|
(38,2,2,4,3),
|
|
142
|
(39,2,2,5,3),
|
|
143
|
(40,2,2,6,3),
|
|
144
|
(41,2,3,1,3),
|
|
145
|
(42,2,3,2,3),
|
|
146
|
(43,2,3,4,3),
|
|
147
|
(44,2,3,5,3),
|
|
148
|
(45,2,3,6,3),
|
|
149
|
(46,2,4,1,3),
|
|
150
|
(47,2,4,2,3),
|
|
151
|
(48,2,4,3,3),
|
|
152
|
(49,2,4,5,3),
|
|
153
|
(50,2,4,6,3),
|
|
154
|
(51,2,5,1,3),
|
|
155
|
(52,2,5,2,3),
|
|
156
|
(53,2,5,3,3),
|
|
157
|
(54,2,5,4,3),
|
|
158
|
(55,2,5,6,3),
|
|
159
|
(56,2,6,1,3),
|
|
160
|
(57,2,6,2,3),
|
|
161
|
(58,2,6,3,3),
|
|
162
|
(59,2,6,4,3),
|
|
163
|
(60,2,6,5,3),
|
|
164
|
(61,3,1,2,3),
|
|
165
|
(62,3,1,3,3),
|
|
166
|
(63,3,1,4,3),
|
|
167
|
(64,3,1,5,3),
|
|
168
|
(65,3,1,6,3),
|
|
169
|
(66,3,2,1,3),
|
|
170
|
(67,3,2,3,3),
|
|
171
|
(68,3,2,4,3),
|
|
172
|
(69,3,2,5,3),
|
|
173
|
(70,3,2,6,3),
|
|
174
|
(71,3,3,1,3),
|
|
175
|
(72,3,3,2,3),
|
|
176
|
(73,3,3,4,3),
|
|
177
|
(74,3,3,5,3),
|
|
178
|
(75,3,3,6,3),
|
|
179
|
(76,3,4,1,3),
|
|
180
|
(77,3,4,2,3),
|
|
181
|
(78,3,4,3,3),
|
|
182
|
(79,3,4,5,3),
|
|
183
|
(80,3,4,6,3),
|
|
184
|
(81,3,5,1,3),
|
|
185
|
(82,3,5,2,3),
|
|
186
|
(83,3,5,3,3),
|
|
187
|
(84,3,5,4,3),
|
|
188
|
(85,3,5,6,3),
|
|
189
|
(86,3,6,1,3),
|
|
190
|
(87,3,6,2,3),
|
|
191
|
(88,3,6,3,3),
|
|
192
|
(89,3,6,4,3),
|
|
193
|
(90,3,6,5,3),
|
|
194
|
(91,1,1,2,4),
|
|
195
|
(92,1,1,3,4),
|
|
196
|
(93,1,1,4,4),
|
|
197
|
(94,1,1,5,4),
|
|
198
|
(95,1,2,3,4),
|
|
199
|
(96,1,2,4,4),
|
|
200
|
(97,1,2,5,4),
|
|
201
|
(98,1,3,2,4),
|
|
202
|
(99,1,3,4,4),
|
|
203
|
(100,1,3,5,4),
|
|
204
|
(101,1,4,2,4),
|
|
205
|
(102,1,4,3,4),
|
|
206
|
(103,1,4,5,4),
|
|
207
|
(104,2,1,2,4),
|
|
208
|
(105,2,1,3,4),
|
|
209
|
(106,2,1,4,4),
|
|
210
|
(107,2,1,5,4),
|
|
211
|
(108,2,2,3,4),
|
|
212
|
(109,2,2,4,4),
|
|
213
|
(110,2,2,5,4),
|
|
214
|
(111,2,3,2,4),
|
|
215
|
(112,2,3,4,4),
|
|
216
|
(113,2,3,5,4),
|
|
217
|
(114,2,4,2,4),
|
|
218
|
(115,2,4,3,4),
|
|
219
|
(116,2,4,5,4),
|
|
220
|
(117,3,1,2,4),
|
|
221
|
(118,3,1,3,4),
|
|
222
|
(119,3,1,4,4),
|
|
223
|
(120,3,1,5,4),
|
|
224
|
(121,3,2,3,4),
|
|
225
|
(122,3,2,4,4),
|
|
226
|
(123,3,2,5,4),
|
|
227
|
(124,3,3,2,4),
|
|
228
|
(125,3,3,4,4),
|
|
229
|
(126,3,3,5,4),
|
|
230
|
(127,3,4,2,4),
|
|
231
|
(128,3,4,3,4),
|
|
232
|
(129,3,4,5,4),
|
|
233
|
(130,1,1,5,5),
|
|
234
|
(131,1,2,5,5),
|
|
235
|
(132,1,3,5,5),
|
|
236
|
(133,1,4,5,5),
|
|
237
|
(134,1,3,4,5),
|
|
238
|
(135,2,1,5,5),
|
|
239
|
(136,2,2,5,5),
|
|
240
|
(137,2,3,5,5),
|
|
241
|
(138,2,4,5,5),
|
|
242
|
(139,2,3,4,5),
|
|
243
|
(140,3,1,5,5),
|
|
244
|
(141,3,2,5,5),
|
|
245
|
(142,3,3,5,5),
|
|
246
|
(143,3,4,5,5),
|
|
247
|
(144,3,3,4,5);
|