1
|
https://www.redmine.org/issues/21398#note-19
|
2
|
|
3
|
root@ubuntu:/usr/share/redmine# RAILS_ENV=production bundle exec rake db:migrate --trace
|
4
|
** Invoke db:migrate (first_time)
|
5
|
** Invoke environment (first_time)
|
6
|
** Execute environment
|
7
|
** Invoke db:load_config (first_time)
|
8
|
** Execute db:load_config
|
9
|
** Execute db:migrate
|
10
|
== 20191014134254 EncodingConvertion: migrating ===============================
|
11
|
-- execute("ALTER DATABASE `redmine_default` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
12
|
-> 0.0014s
|
13
|
-- execute("ALTER TABLE `attachments` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
14
|
-> 0.8099s
|
15
|
-- execute("ALTER TABLE `attachments` MODIFY `container_type` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
16
|
-> 0.0320s
|
17
|
-- execute("ALTER TABLE `attachments` MODIFY `filename` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;")
|
18
|
-> 0.0352s
|
19
|
-- execute("ALTER TABLE `attachments` MODIFY `disk_filename` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;")
|
20
|
-> 0.0300s
|
21
|
-- execute("ALTER TABLE `attachments` MODIFY `content_type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
22
|
-> 0.0355s
|
23
|
-- execute("ALTER TABLE `attachments` MODIFY `digest` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;")
|
24
|
-> 0.0357s
|
25
|
-- execute("ALTER TABLE `attachments` MODIFY `description` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
26
|
-> 0.0422s
|
27
|
-- execute("ALTER TABLE `attachments` MODIFY `disk_directory` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
28
|
-> 0.0351s
|
29
|
-- execute("ALTER TABLE `auth_sources` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
30
|
-> 0.5144s
|
31
|
-- execute("ALTER TABLE `auth_sources` MODIFY `type` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;")
|
32
|
-> 0.0616s
|
33
|
-- execute("ALTER TABLE `auth_sources` MODIFY `name` VARCHAR(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;")
|
34
|
-> 0.0298s
|
35
|
-- execute("ALTER TABLE `auth_sources` MODIFY `host` VARCHAR(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
36
|
-> 0.0301s
|
37
|
-- execute("ALTER TABLE `auth_sources` MODIFY `account` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
38
|
-> 0.0292s
|
39
|
-- execute("ALTER TABLE `auth_sources` MODIFY `account_password` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
40
|
-> 0.0300s
|
41
|
-- execute("ALTER TABLE `auth_sources` MODIFY `base_dn` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
42
|
-> 0.0290s
|
43
|
-- execute("ALTER TABLE `auth_sources` MODIFY `attr_login` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
44
|
-> 0.0297s
|
45
|
-- execute("ALTER TABLE `auth_sources` MODIFY `attr_firstname` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
46
|
-> 0.0298s
|
47
|
-- execute("ALTER TABLE `auth_sources` MODIFY `attr_lastname` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
48
|
-> 0.0301s
|
49
|
-- execute("ALTER TABLE `auth_sources` MODIFY `attr_mail` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
50
|
-> 0.0295s
|
51
|
-- execute("ALTER TABLE `auth_sources` MODIFY `filter` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ")
|
52
|
-> 0.6944s
|
53
|
-- execute("ALTER TABLE `boards` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
54
|
-> 0.5202s
|
55
|
-- execute("ALTER TABLE `boards` MODIFY `name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;")
|
56
|
-> 0.7860s
|
57
|
-- execute("ALTER TABLE `boards` MODIFY `description` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
58
|
-> 0.9671s
|
59
|
-- execute("ALTER TABLE `changes` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
60
|
-> 0.6898s
|
61
|
-- execute("ALTER TABLE `changes` MODIFY `action` VARCHAR(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;")
|
62
|
-> 1.1586s
|
63
|
-- execute("ALTER TABLE `changes` MODIFY `path` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL")
|
64
|
-> 0.6880s
|
65
|
-- execute("ALTER TABLE `changes` MODIFY `from_path` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ")
|
66
|
-> 0.6578s
|
67
|
-- execute("ALTER TABLE `changes` MODIFY `from_revision` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
68
|
-> 0.7778s
|
69
|
-- execute("ALTER TABLE `changes` MODIFY `revision` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
70
|
-> 0.6643s
|
71
|
-- execute("ALTER TABLE `changes` MODIFY `branch` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
72
|
-> 0.7471s
|
73
|
-- execute("ALTER TABLE `changeset_parents` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
74
|
-> 0.5042s
|
75
|
-- execute("ALTER TABLE `changesets` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
76
|
-> 0.6271s
|
77
|
-- execute("ALTER TABLE `changesets` MODIFY `revision` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;")
|
78
|
-> 0.8025s
|
79
|
-- execute("ALTER TABLE `changesets` MODIFY `committer` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
80
|
-> 0.8494s
|
81
|
-- execute("ALTER TABLE `changesets` MODIFY `comments` LONGTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ")
|
82
|
-> 0.7777s
|
83
|
-- execute("ALTER TABLE `changesets` MODIFY `scmid` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
84
|
-> 0.8615s
|
85
|
-- execute("ALTER TABLE `changesets_issues` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
86
|
-> 0.3590s
|
87
|
-- execute("ALTER TABLE `comments` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
88
|
-> 0.6384s
|
89
|
-- execute("ALTER TABLE `comments` MODIFY `commented_type` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;")
|
90
|
-> 0.6312s
|
91
|
-- execute("ALTER TABLE `comments` MODIFY `comments` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ")
|
92
|
-> 0.8362s
|
93
|
-- execute("ALTER TABLE `custom_field_enumerations` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
94
|
-> 0.3661s
|
95
|
-- execute("ALTER TABLE `custom_field_enumerations` MODIFY `name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;")
|
96
|
-> 0.5058s
|
97
|
-- execute("ALTER TABLE `custom_fields` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
98
|
-> 0.4260s
|
99
|
-- execute("ALTER TABLE `custom_fields` MODIFY `type` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;")
|
100
|
-> 0.5215s
|
101
|
-- execute("ALTER TABLE `custom_fields` MODIFY `name` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;")
|
102
|
-> 0.7120s
|
103
|
-- execute("ALTER TABLE `custom_fields` MODIFY `field_format` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;")
|
104
|
-> 0.5677s
|
105
|
-- execute("ALTER TABLE `custom_fields` MODIFY `possible_values` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ")
|
106
|
-> 0.6763s
|
107
|
-- execute("ALTER TABLE `custom_fields` MODIFY `regexp` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
108
|
-> 0.6634s
|
109
|
-- execute("ALTER TABLE `custom_fields` MODIFY `default_value` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ")
|
110
|
-> 0.7841s
|
111
|
-- execute("ALTER TABLE `custom_fields` MODIFY `format_store` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ")
|
112
|
-> 0.6935s
|
113
|
-- execute("ALTER TABLE `custom_fields` MODIFY `description` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ")
|
114
|
-> 0.7358s
|
115
|
-- execute("ALTER TABLE `custom_fields_projects` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
116
|
-> 0.4313s
|
117
|
-- execute("ALTER TABLE `custom_fields_roles` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
118
|
-> 0.5005s
|
119
|
-- execute("ALTER TABLE `custom_fields_trackers` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
120
|
-> 0.4356s
|
121
|
-- execute("ALTER TABLE `custom_values` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
122
|
-> 0.4700s
|
123
|
-- execute("ALTER TABLE `custom_values` MODIFY `customized_type` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;")
|
124
|
-> 0.7569s
|
125
|
-- execute("ALTER TABLE `custom_values` MODIFY `value` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ")
|
126
|
-> 0.6338s
|
127
|
-- execute("ALTER TABLE `documents` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
128
|
-> 0.5329s
|
129
|
-- execute("ALTER TABLE `documents` MODIFY `title` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;")
|
130
|
-> 0.8276s
|
131
|
-- execute("ALTER TABLE `documents` MODIFY `description` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ")
|
132
|
-> 0.8377s
|
133
|
-- execute("ALTER TABLE `email_addresses` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
134
|
-> 0.6286s
|
135
|
-- execute("ALTER TABLE `email_addresses` MODIFY `address` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;")
|
136
|
-> 0.7806s
|
137
|
-- execute("ALTER TABLE `enabled_modules` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
138
|
-> 0.5565s
|
139
|
-- execute("ALTER TABLE `enabled_modules` MODIFY `name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;")
|
140
|
-> 0.9247s
|
141
|
-- execute("ALTER TABLE `enumerations` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
142
|
-> 0.7662s
|
143
|
-- execute("ALTER TABLE `enumerations` MODIFY `name` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;")
|
144
|
-> 0.7925s
|
145
|
-- execute("ALTER TABLE `enumerations` MODIFY `type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
146
|
-> 0.9574s
|
147
|
-- execute("ALTER TABLE `enumerations` MODIFY `position_name` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
148
|
-> 1.0763s
|
149
|
-- execute("ALTER TABLE `groups_users` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
150
|
-> 0.4372s
|
151
|
-- execute("ALTER TABLE `import_items` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
152
|
-> 0.4955s
|
153
|
-- execute("ALTER TABLE `import_items` MODIFY `message` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ")
|
154
|
-> 0.6432s
|
155
|
-- execute("ALTER TABLE `imports` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
156
|
-> 0.4552s
|
157
|
-- execute("ALTER TABLE `imports` MODIFY `type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
158
|
-> 0.6189s
|
159
|
-- execute("ALTER TABLE `imports` MODIFY `filename` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
160
|
-> 0.6694s
|
161
|
-- execute("ALTER TABLE `imports` MODIFY `settings` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ")
|
162
|
-> 0.6583s
|
163
|
-- execute("ALTER TABLE `issue_categories` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
164
|
-> 0.5214s
|
165
|
-- execute("ALTER TABLE `issue_categories` MODIFY `name` VARCHAR(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;")
|
166
|
-> 0.7454s
|
167
|
-- execute("ALTER TABLE `issue_relations` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
168
|
-> 0.9750s
|
169
|
-- execute("ALTER TABLE `issue_relations` MODIFY `relation_type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;")
|
170
|
-> 0.8408s
|
171
|
-- execute("ALTER TABLE `issue_statuses` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
172
|
-> 0.6946s
|
173
|
-- execute("ALTER TABLE `issue_statuses` MODIFY `name` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;")
|
174
|
-> 0.8050s
|
175
|
-- execute("ALTER TABLE `issues` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
176
|
-> 1.5025s
|
177
|
-- execute("ALTER TABLE `issues` MODIFY `subject` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;")
|
178
|
-> 1.1138s
|
179
|
-- execute("ALTER TABLE `issues` MODIFY `description` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ")
|
180
|
-> 1.1300s
|
181
|
-- execute("ALTER TABLE `journal_details` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
182
|
-> 0.7473s
|
183
|
-- execute("ALTER TABLE `journal_details` MODIFY `property` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;")
|
184
|
-> 0.7336s
|
185
|
-- execute("ALTER TABLE `journal_details` MODIFY `prop_key` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;")
|
186
|
-> 0.9329s
|
187
|
-- execute("ALTER TABLE `journal_details` MODIFY `old_value` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ")
|
188
|
-> 0.7344s
|
189
|
-- execute("ALTER TABLE `journal_details` MODIFY `value` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ")
|
190
|
-> 0.7880s
|
191
|
-- execute("ALTER TABLE `journals` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
192
|
-> 0.8564s
|
193
|
-- execute("ALTER TABLE `journals` MODIFY `journalized_type` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;")
|
194
|
-> 0.8874s
|
195
|
-- execute("ALTER TABLE `journals` MODIFY `notes` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ")
|
196
|
-> 0.9786s
|
197
|
-- execute("ALTER TABLE `member_roles` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
198
|
-> 0.4834s
|
199
|
-- execute("ALTER TABLE `members` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
200
|
-> 0.5715s
|
201
|
-- execute("ALTER TABLE `messages` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
202
|
-> 0.6249s
|
203
|
-- execute("ALTER TABLE `messages` MODIFY `subject` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;")
|
204
|
-> 0.8776s
|
205
|
-- execute("ALTER TABLE `messages` MODIFY `content` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ")
|
206
|
-> 0.9928s
|
207
|
-- execute("ALTER TABLE `news` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
208
|
-> 0.9450s
|
209
|
-- execute("ALTER TABLE `news` MODIFY `title` VARCHAR(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;")
|
210
|
-> 1.1221s
|
211
|
-- execute("ALTER TABLE `news` MODIFY `summary` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
212
|
-> 0.8017s
|
213
|
-- execute("ALTER TABLE `news` MODIFY `description` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ")
|
214
|
-> 0.8495s
|
215
|
-- execute("ALTER TABLE `open_id_authentication_associations` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
216
|
-> 0.4067s
|
217
|
-- execute("ALTER TABLE `open_id_authentication_associations` MODIFY `handle` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
218
|
-> 0.5975s
|
219
|
-- execute("ALTER TABLE `open_id_authentication_associations` MODIFY `assoc_type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
220
|
-> 0.5798s
|
221
|
-- execute("ALTER TABLE `open_id_authentication_nonces` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
222
|
-> 0.4012s
|
223
|
-- execute("ALTER TABLE `open_id_authentication_nonces` MODIFY `server_url` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
224
|
-> 0.7148s
|
225
|
-- execute("ALTER TABLE `open_id_authentication_nonces` MODIFY `salt` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;")
|
226
|
-> 0.8855s
|
227
|
-- execute("ALTER TABLE `projects` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
228
|
-> 0.6280s
|
229
|
-- execute("ALTER TABLE `projects` MODIFY `name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;")
|
230
|
-> 1.0958s
|
231
|
-- execute("ALTER TABLE `projects` MODIFY `description` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ")
|
232
|
-> 0.7402s
|
233
|
-- execute("ALTER TABLE `projects` MODIFY `homepage` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
234
|
-> 0.9336s
|
235
|
-- execute("ALTER TABLE `projects` MODIFY `identifier` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
236
|
-> 0.9739s
|
237
|
-- execute("ALTER TABLE `projects_trackers` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
238
|
-> 0.7184s
|
239
|
-- execute("ALTER TABLE `queries` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
240
|
-> 0.5121s
|
241
|
-- execute("ALTER TABLE `queries` MODIFY `name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;")
|
242
|
-> 0.7619s
|
243
|
-- execute("ALTER TABLE `queries` MODIFY `filters` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ")
|
244
|
-> 0.8440s
|
245
|
-- execute("ALTER TABLE `queries` MODIFY `column_names` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ")
|
246
|
-> 0.9089s
|
247
|
-- execute("ALTER TABLE `queries` MODIFY `sort_criteria` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ")
|
248
|
-> 0.7778s
|
249
|
-- execute("ALTER TABLE `queries` MODIFY `group_by` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
250
|
-> 0.8494s
|
251
|
-- execute("ALTER TABLE `queries` MODIFY `type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
252
|
-> 0.8023s
|
253
|
-- execute("ALTER TABLE `queries` MODIFY `options` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ")
|
254
|
-> 0.9015s
|
255
|
-- execute("ALTER TABLE `queries_roles` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
256
|
-> 0.4960s
|
257
|
-- execute("ALTER TABLE `repositories` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
258
|
-> 0.5490s
|
259
|
-- execute("ALTER TABLE `repositories` MODIFY `url` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;")
|
260
|
-> 0.6359s
|
261
|
-- execute("ALTER TABLE `repositories` MODIFY `login` VARCHAR(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
262
|
-> 0.6823s
|
263
|
-- execute("ALTER TABLE `repositories` MODIFY `password` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
264
|
-> 0.7825s
|
265
|
-- execute("ALTER TABLE `repositories` MODIFY `root_url` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
266
|
-> 0.7959s
|
267
|
-- execute("ALTER TABLE `repositories` MODIFY `type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
268
|
-> 0.7527s
|
269
|
-- execute("ALTER TABLE `repositories` MODIFY `path_encoding` VARCHAR(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
270
|
-> 0.7477s
|
271
|
-- execute("ALTER TABLE `repositories` MODIFY `log_encoding` VARCHAR(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
272
|
-> 0.6514s
|
273
|
-- execute("ALTER TABLE `repositories` MODIFY `extra_info` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ")
|
274
|
-> 0.7414s
|
275
|
-- execute("ALTER TABLE `repositories` MODIFY `identifier` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
276
|
-> 0.7283s
|
277
|
-- execute("ALTER TABLE `roles` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
278
|
-> 0.5636s
|
279
|
-- execute("ALTER TABLE `roles` MODIFY `name` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;")
|
280
|
-> 0.7680s
|
281
|
-- execute("ALTER TABLE `roles` MODIFY `permissions` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ")
|
282
|
-> 0.8613s
|
283
|
-- execute("ALTER TABLE `roles` MODIFY `issues_visibility` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'default' NOT NULL;")
|
284
|
-> 0.8845s
|
285
|
-- execute("ALTER TABLE `roles` MODIFY `users_visibility` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'all' NOT NULL;")
|
286
|
-> 0.8368s
|
287
|
-- execute("ALTER TABLE `roles` MODIFY `time_entries_visibility` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'all' NOT NULL;")
|
288
|
-> 0.6993s
|
289
|
-- execute("ALTER TABLE `roles_managed_roles` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
290
|
-> 0.4731s
|
291
|
-- execute("ALTER TABLE `schema_migrations` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
292
|
-> 0.6022s
|
293
|
-- execute("ALTER TABLE `schema_migrations` MODIFY `version` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;")
|
294
|
-> 0.6666s
|
295
|
-- execute("ALTER TABLE `settings` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
296
|
-> 0.7362s
|
297
|
-- execute("ALTER TABLE `settings` MODIFY `name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;")
|
298
|
-> 0.8109s
|
299
|
-- execute("ALTER TABLE `settings` MODIFY `value` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ")
|
300
|
-> 0.9216s
|
301
|
-- execute("ALTER TABLE `time_entries` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
302
|
-> 0.5931s
|
303
|
-- execute("ALTER TABLE `time_entries` MODIFY `comments` VARCHAR(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
304
|
-> 1.0249s
|
305
|
-- execute("ALTER TABLE `tokens` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
306
|
-> 0.8274s
|
307
|
-- execute("ALTER TABLE `tokens` MODIFY `action` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;")
|
308
|
-> 1.1569s
|
309
|
-- execute("ALTER TABLE `tokens` MODIFY `value` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;")
|
310
|
-> 0.8556s
|
311
|
-- execute("ALTER TABLE `trackers` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
312
|
-> 0.5986s
|
313
|
-- execute("ALTER TABLE `trackers` MODIFY `name` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;")
|
314
|
-> 0.6784s
|
315
|
-- execute("ALTER TABLE `user_preferences` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
316
|
-> 0.6172s
|
317
|
-- execute("ALTER TABLE `user_preferences` MODIFY `others` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ")
|
318
|
-> 0.8289s
|
319
|
-- execute("ALTER TABLE `user_preferences` MODIFY `time_zone` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
320
|
-> 0.6340s
|
321
|
-- execute("ALTER TABLE `users` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
322
|
-> 0.8623s
|
323
|
-- execute("ALTER TABLE `users` MODIFY `login` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;")
|
324
|
-> 0.7257s
|
325
|
-- execute("ALTER TABLE `users` MODIFY `hashed_password` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;")
|
326
|
-> 0.7829s
|
327
|
-- execute("ALTER TABLE `users` MODIFY `firstname` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;")
|
328
|
-> 0.9152s
|
329
|
-- execute("ALTER TABLE `users` MODIFY `lastname` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;")
|
330
|
-> 0.8319s
|
331
|
-- execute("ALTER TABLE `users` MODIFY `language` VARCHAR(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
332
|
-> 0.8309s
|
333
|
-- execute("ALTER TABLE `users` MODIFY `type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
334
|
-> 0.9157s
|
335
|
-- execute("ALTER TABLE `users` MODIFY `identity_url` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
336
|
-> 0.8368s
|
337
|
-- execute("ALTER TABLE `users` MODIFY `mail_notification` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;")
|
338
|
-> 0.8133s
|
339
|
-- execute("ALTER TABLE `users` MODIFY `salt` VARCHAR(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
340
|
-> 0.7596s
|
341
|
-- execute("ALTER TABLE `versions` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
342
|
-> 0.5274s
|
343
|
-- execute("ALTER TABLE `versions` MODIFY `name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;")
|
344
|
-> 0.6965s
|
345
|
-- execute("ALTER TABLE `versions` MODIFY `description` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
346
|
-> 0.8079s
|
347
|
-- execute("ALTER TABLE `versions` MODIFY `wiki_page_title` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
348
|
-> 0.7051s
|
349
|
-- execute("ALTER TABLE `versions` MODIFY `status` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'open' ;")
|
350
|
-> 1.2270s
|
351
|
-- execute("ALTER TABLE `versions` MODIFY `sharing` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'none' NOT NULL;")
|
352
|
-> 0.6575s
|
353
|
-- execute("ALTER TABLE `watchers` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
354
|
-> 0.7486s
|
355
|
-- execute("ALTER TABLE `watchers` MODIFY `watchable_type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;")
|
356
|
-> 0.9113s
|
357
|
-- execute("ALTER TABLE `wiki_content_versions` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
358
|
-> 0.4493s
|
359
|
-- execute("ALTER TABLE `wiki_content_versions` MODIFY `compression` VARCHAR(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
360
|
-> 0.8405s
|
361
|
-- execute("ALTER TABLE `wiki_content_versions` MODIFY `comments` VARCHAR(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
362
|
-> 0.8557s
|
363
|
-- execute("ALTER TABLE `wiki_contents` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
364
|
-> 0.5335s
|
365
|
-- execute("ALTER TABLE `wiki_contents` MODIFY `text` LONGTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ")
|
366
|
-> 0.6601s
|
367
|
-- execute("ALTER TABLE `wiki_contents` MODIFY `comments` VARCHAR(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
368
|
-> 0.7543s
|
369
|
-- execute("ALTER TABLE `wiki_pages` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
370
|
-> 0.6169s
|
371
|
-- execute("ALTER TABLE `wiki_pages` MODIFY `title` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;")
|
372
|
-> 0.7618s
|
373
|
-- execute("ALTER TABLE `wiki_redirects` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
374
|
-> 0.4857s
|
375
|
-- execute("ALTER TABLE `wiki_redirects` MODIFY `title` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
376
|
-> 0.8047s
|
377
|
-- execute("ALTER TABLE `wiki_redirects` MODIFY `redirects_to` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
378
|
-> 0.6998s
|
379
|
-- execute("ALTER TABLE `wikis` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
380
|
-> 0.6651s
|
381
|
-- execute("ALTER TABLE `wikis` MODIFY `start_page` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;")
|
382
|
-> 0.9296s
|
383
|
-- execute("ALTER TABLE `workflows` ROW_FORMAT=DYNAMIC CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;")
|
384
|
-> 1.0128s
|
385
|
-- execute("ALTER TABLE `workflows` MODIFY `type` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
386
|
-> 0.9832s
|
387
|
-- execute("ALTER TABLE `workflows` MODIFY `field_name` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
388
|
-> 1.8117s
|
389
|
-- execute("ALTER TABLE `workflows` MODIFY `rule` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;")
|
390
|
-> 1.1431s
|
391
|
== 20191014134254 EncodingConvertion: migrated (130.0542s) ====================
|
392
|
|
393
|
** Invoke db:_dump (first_time)
|
394
|
** Execute db:_dump
|
395
|
** Invoke db:schema:dump (first_time)
|
396
|
** Invoke environment
|
397
|
** Invoke db:load_config
|
398
|
** Execute db:schema:dump
|
399
|
root@ubuntu:/usr/share/redmine#
|