|
1
|
|
|
<?php |
|
2
|
|
|
/* For licensing terms, see /license.txt */ |
|
3
|
|
|
|
|
4
|
|
|
namespace Application\Migrations\Schema\V110; |
|
5
|
|
|
|
|
6
|
|
|
use Application\Migrations\AbstractMigrationChamilo; |
|
7
|
|
|
use Doctrine\DBAL\Schema\Schema; |
|
8
|
|
|
use \Doctrine\DBAL\Types\Type; |
|
9
|
|
|
|
|
10
|
|
|
/** |
|
11
|
|
|
* Class Version110 |
|
12
|
|
|
* |
|
13
|
|
|
* Migrate file to updated to Chamilo 1.10 |
|
14
|
|
|
* |
|
15
|
|
|
* @package Application\Migrations\Schema\V110 |
|
16
|
|
|
*/ |
|
17
|
|
|
class Version110 extends AbstractMigrationChamilo |
|
18
|
|
|
{ |
|
19
|
|
|
/** |
|
20
|
|
|
* @param Schema $schema |
|
21
|
|
|
*/ |
|
22
|
|
|
public function preUp(Schema $schema) |
|
23
|
|
|
{ |
|
24
|
|
|
$this->addSql("ALTER TABLE session_rel_course ENGINE=InnoDB"); |
|
25
|
|
|
$this->addSql("ALTER TABLE session_rel_course_rel_user ENGINE=InnoDB"); |
|
26
|
|
|
$this->addSql("ALTER TABLE session_rel_user ENGINE=InnoDB"); |
|
27
|
|
|
} |
|
28
|
|
|
|
|
29
|
|
|
/** |
|
30
|
|
|
* @param Schema $schema |
|
31
|
|
|
* |
|
32
|
|
|
* @throws \Doctrine\DBAL\Schema\SchemaException |
|
33
|
|
|
*/ |
|
34
|
|
|
public function up(Schema $schema) |
|
35
|
|
|
{ |
|
36
|
|
|
// Use $schema->createTable |
|
37
|
|
|
|
|
38
|
|
|
$this->addSql("CREATE TABLE IF NOT EXISTS course_field_options (id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, field_id INT NOT NULL, option_value TEXT, option_display_text VARCHAR(64), option_order INT, tms DATETIME)"); |
|
39
|
|
|
$this->addSql("CREATE TABLE IF NOT EXISTS session_field_options (id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, field_id INT NOT NULL, option_value TEXT, option_display_text VARCHAR(64), option_order INT, tms DATETIME)"); |
|
40
|
|
|
$this->addSql("CREATE TABLE IF NOT EXISTS hook_observer( id int UNSIGNED NOT NULL AUTO_INCREMENT, class_name varchar(255) UNIQUE, path varchar(255) NOT NULL, plugin_name varchar(255) NULL, PRIMARY KEY PK_hook_management_hook_observer(id))"); |
|
41
|
|
|
$this->addSql("CREATE TABLE IF NOT EXISTS hook_event( id int UNSIGNED NOT NULL AUTO_INCREMENT, class_name varchar(255) UNIQUE, description varchar(255), PRIMARY KEY PK_hook_management_hook_event(id))"); |
|
42
|
|
|
$this->addSql("CREATE TABLE IF NOT EXISTS hook_call( id int UNSIGNED NOT NULL AUTO_INCREMENT, hook_event_id int UNSIGNED NOT NULL, hook_observer_id int UNSIGNED NOT NULL, type tinyint NOT NULL, hook_order int UNSIGNED NOT NULL, enabled tinyint NOT NULL, PRIMARY KEY PK_hook_management_hook_call(id))"); |
|
43
|
|
|
$this->addSql("CREATE TABLE IF NOT EXISTS c_student_publication_rel_document (iid INT NOT NULL PRIMARY KEY, id INT NULL, work_id INT NOT NULL, document_id INT NOT NULL, c_id INT NOT NULL)"); |
|
44
|
|
|
$this->addSql("CREATE TABLE IF NOT EXISTS c_student_publication_rel_user (iid INT NOT NULL AUTO_INCREMENT PRIMARY KEY, id INT NULL, work_id INT NOT NULL, user_id INT NOT NULL, c_id INT NOT NULL)"); |
|
45
|
|
|
$this->addSql("CREATE TABLE IF NOT EXISTS c_student_publication_comment (iid INT NOT NULL PRIMARY KEY, id INT NULL, work_id INT NOT NULL, c_id INT NOT NULL, comment text, file VARCHAR(255), user_id int NOT NULL, sent_at datetime NOT NULL)"); |
|
46
|
|
|
$this->addSql("CREATE TABLE IF NOT EXISTS c_attendance_calendar_rel_group (iid int NOT NULL auto_increment PRIMARY KEY, id INT, c_id INT NOT NULL, group_id INT NOT NULL, calendar_id INT NOT NULL)"); |
|
47
|
|
|
|
|
48
|
|
|
$this->addSql("ALTER TABLE session MODIFY COLUMN date_start date default NULL, MODIFY COLUMN date_end date default NULL"); |
|
49
|
|
|
$this->addSql("ALTER TABLE skill_rel_user MODIFY COLUMN acquired_skill_at datetime default NULL"); |
|
50
|
|
|
$this->addSql("ALTER TABLE track_e_access MODIFY COLUMN access_date datetime DEFAULT NULL"); |
|
51
|
|
|
$this->addSql("ALTER TABLE track_e_lastaccess MODIFY COLUMN access_date datetime DEFAULT NULL"); |
|
52
|
|
|
$this->addSql("ALTER TABLE skill_rel_user ADD COLUMN course_id INT NOT NULL DEFAULT 0 AFTER id"); |
|
53
|
|
|
$this->addSql("ALTER TABLE skill_rel_user ADD COLUMN session_id INT NOT NULL DEFAULT 0 AFTER course_id"); |
|
54
|
|
|
$this->addSql("ALTER TABLE skill_rel_user ADD INDEX idx_select_cs (course_id, session_id)"); |
|
55
|
|
|
|
|
56
|
|
|
// Delete info of session_rel_user if session does not exists; |
|
57
|
|
|
$this->addSql("DELETE FROM session_rel_user WHERE id_session NOT IN (SELECT id FROM session)"); |
|
58
|
|
|
|
|
59
|
|
|
// Delete info of usergroup_rel_user if usergroup does not exists; |
|
60
|
|
|
$this->addSql("DELETE FROM usergroup_rel_user WHERE usergroup_id NOT IN (SELECT id FROM usergroup)"); |
|
61
|
|
|
|
|
62
|
|
|
$session = $schema->getTable('session'); |
|
63
|
|
|
$session->getColumn('id')->setType(Type::getType(Type::INTEGER))->setUnsigned(false); |
|
64
|
|
|
if (!$session->hasColumn('description')) { |
|
65
|
|
|
$session->addColumn( |
|
66
|
|
|
'description', |
|
67
|
|
|
'text' |
|
68
|
|
|
); |
|
69
|
|
|
} |
|
70
|
|
|
|
|
71
|
|
|
if (!$session->hasColumn('show_description')) { |
|
72
|
|
|
$session->addColumn( |
|
73
|
|
|
'show_description', |
|
74
|
|
|
'smallint', |
|
75
|
|
|
array('default' => 0, 'unsigned' => true) |
|
76
|
|
|
); |
|
77
|
|
|
} |
|
78
|
|
|
|
|
79
|
|
|
$sessionTable = $schema->getTable('session'); |
|
80
|
|
|
if (!$sessionTable->hasColumn('duration')) { |
|
81
|
|
|
$this->addSql("ALTER TABLE session ADD COLUMN duration int"); |
|
82
|
|
|
} |
|
83
|
|
|
|
|
84
|
|
|
$sessionRelUser = $schema->getTable('session_rel_user'); |
|
85
|
|
|
if (!$sessionRelUser->hasColumn('duration')) { |
|
86
|
|
|
$this->addSql("ALTER TABLE session_rel_user ADD COLUMN duration int"); |
|
87
|
|
|
} |
|
88
|
|
|
|
|
89
|
|
|
$this->addSql("ALTER TABLE skill ADD COLUMN criteria text"); |
|
90
|
|
|
$this->addSql("ALTER TABLE gradebook_category ADD COLUMN generate_certificates TINYINT NOT NULL DEFAULT 0"); |
|
91
|
|
|
$this->addSql("ALTER TABLE track_e_access ADD COLUMN c_id int NOT NULL"); |
|
92
|
|
|
|
|
93
|
|
|
$this->addSql("ALTER TABLE track_e_lastaccess ADD COLUMN c_id int NOT NULL"); |
|
94
|
|
|
$this->addSql("ALTER TABLE track_e_exercices ADD COLUMN c_id int NOT NULL"); |
|
95
|
|
|
$this->addSql("ALTER TABLE track_e_downloads ADD COLUMN c_id int NOT NULL"); |
|
96
|
|
|
$this->addSql("ALTER TABLE track_e_hotpotatoes ADD COLUMN c_id int NOT NULL"); |
|
97
|
|
|
$this->addSql("ALTER TABLE track_e_links ADD COLUMN c_id int NOT NULL"); |
|
98
|
|
|
$this->addSql("ALTER TABLE track_e_course_access ADD COLUMN c_id int NOT NULL"); |
|
99
|
|
|
$this->addSql("ALTER TABLE track_e_online ADD COLUMN c_id int NOT NULL"); |
|
100
|
|
|
$this->addSql("ALTER TABLE track_e_attempt ADD COLUMN c_id int NOT NULL"); |
|
101
|
|
|
$table = $schema->getTable('track_e_default'); |
|
102
|
|
|
if (!$table->hasColumn('session_id')) { |
|
103
|
|
|
$this->addSql("ALTER TABLE track_e_default ADD COLUMN session_id int NOT NULL"); |
|
104
|
|
|
} |
|
105
|
|
|
|
|
106
|
|
|
if (!$table->hasColumn('c_id')) { |
|
107
|
|
|
$this->addSql("ALTER TABLE track_e_default ADD COLUMN c_id int NOT NULL"); |
|
108
|
|
|
} |
|
109
|
|
|
|
|
110
|
|
|
$this->addSql("ALTER TABLE track_e_access ADD COLUMN user_ip varchar(39) NOT NULL default ''"); |
|
111
|
|
|
$this->addSql("ALTER TABLE track_e_exercices ADD COLUMN user_ip varchar(39) NOT NULL default ''"); |
|
112
|
|
|
$this->addSql("ALTER TABLE track_e_course_access ADD COLUMN user_ip varchar(39) NOT NULL default ''"); |
|
113
|
|
|
$this->addSql("ALTER TABLE track_e_online CHANGE COLUMN login_ip user_ip varchar(39) NOT NULL DEFAULT ''"); |
|
114
|
|
|
$this->addSql("ALTER TABLE track_e_login CHANGE COLUMN login_ip user_ip varchar(39) NOT NULL DEFAULT ''"); |
|
115
|
|
|
|
|
116
|
|
|
$this->addSql("ALTER TABLE user MODIFY COLUMN user_id int unsigned DEFAULT null"); |
|
117
|
|
|
$this->addSql("ALTER TABLE user DROP PRIMARY KEY"); |
|
118
|
|
|
$this->addSql("ALTER TABLE user ADD COLUMN id INT DEFAULT null"); |
|
119
|
|
|
$this->addSql("UPDATE user SET id = user_id"); |
|
120
|
|
|
$this->addSql("ALTER TABLE user MODIFY COLUMN id INT NOT NULL PRIMARY KEY AUTO_INCREMENT AFTER user_id"); |
|
121
|
|
|
|
|
122
|
|
|
$this->addSql("ALTER TABLE user MODIFY COLUMN chatcall_date datetime default NULL"); |
|
123
|
|
|
$this->addSql("ALTER TABLE user MODIFY COLUMN chatcall_text varchar(50) default NULL"); |
|
124
|
|
|
$this->addSql("ALTER TABLE user MODIFY COLUMN chatcall_user_id int unsigned default 0"); |
|
125
|
|
|
$this->addSql("ALTER TABLE user MODIFY COLUMN expiration_date datetime default NULL"); |
|
126
|
|
|
$this->addSql("ALTER TABLE user MODIFY COLUMN registration_date datetime NOT NULL"); |
|
127
|
|
|
|
|
128
|
|
|
$this->addSql("ALTER TABLE course ADD COLUMN add_teachers_to_sessions_courses tinyint NOT NULL default 0"); |
|
129
|
|
|
$this->addSql("ALTER TABLE course DROP COLUMN target_course_code"); |
|
130
|
|
|
$this->addSql("ALTER TABLE session MODIFY COLUMN name char(100) NOT NULL DEFAULT ''"); |
|
131
|
|
|
$this->addSql("ALTER TABLE course_rel_user ADD COLUMN c_id int default NULL"); |
|
132
|
|
|
$this->addSql("ALTER TABLE course_field_values ADD COLUMN c_id int default NULL"); |
|
133
|
|
|
|
|
134
|
|
|
$this->addSql("ALTER TABLE session_rel_course_rel_user ADD COLUMN c_id int default NULL"); |
|
135
|
|
|
$this->addSql("ALTER TABLE session_rel_course_rel_user CHANGE id_session session_id int"); |
|
136
|
|
|
$this->addSql("ALTER TABLE session_rel_course_rel_user CHANGE id_user user_id int"); |
|
137
|
|
|
|
|
138
|
|
|
$this->addSql("ALTER TABLE access_url_rel_course ADD COLUMN c_id int"); |
|
139
|
|
|
|
|
140
|
|
|
$this->addSql("ALTER TABLE session_rel_course ADD COLUMN position int NOT NULL default 0"); |
|
141
|
|
|
$this->addSql("ALTER TABLE session_rel_course ADD COLUMN category varchar(255) default ''"); |
|
142
|
|
|
$this->addSql("ALTER TABLE session_rel_course ADD COLUMN c_id int unsigned"); |
|
143
|
|
|
$this->addSql("ALTER TABLE session_rel_course CHANGE id_session session_id int"); |
|
144
|
|
|
|
|
145
|
|
|
$this->addSql("UPDATE course_rel_user SET c_id = (SELECT id FROM course WHERE code = course_code)"); |
|
146
|
|
|
|
|
147
|
|
|
// Add iid |
|
148
|
|
|
$tables = [ |
|
149
|
|
|
'c_announcement', |
|
150
|
|
|
'c_announcement_attachment', |
|
151
|
|
|
'c_attendance', |
|
152
|
|
|
'c_attendance_calendar', |
|
153
|
|
|
//'c_attendance_calendar_rel_group', |
|
154
|
|
|
'c_attendance_result', |
|
155
|
|
|
//'c_attendance_sheet', |
|
156
|
|
|
'c_attendance_sheet_log', |
|
157
|
|
|
//'c_blog', |
|
158
|
|
|
'c_blog_attachment', |
|
159
|
|
|
//'c_blog_comment', |
|
160
|
|
|
//'c_blog_post', |
|
161
|
|
|
//'c_blog_rating', |
|
162
|
|
|
//'c_blog_rel_user', |
|
163
|
|
|
//'c_blog_task', |
|
164
|
|
|
//'c_blog_task_rel_user', |
|
165
|
|
|
'c_calendar_event', |
|
166
|
|
|
'c_calendar_event_attachment', |
|
167
|
|
|
//'c_calendar_event_repeat', |
|
168
|
|
|
//'c_calendar_event_repeat_not', |
|
169
|
|
|
'c_chat_connected', |
|
170
|
|
|
'c_course_description', |
|
171
|
|
|
'c_course_setting', |
|
172
|
|
|
'c_document', |
|
173
|
|
|
//'c_dropbox_category', |
|
174
|
|
|
//'c_dropbox_feedback', |
|
175
|
|
|
'c_dropbox_file', |
|
176
|
|
|
//'c_dropbox_person', |
|
177
|
|
|
//'c_dropbox_post', |
|
178
|
|
|
'c_forum_attachment', |
|
179
|
|
|
//'c_forum_category', |
|
180
|
|
|
//'c_forum_forum', |
|
181
|
|
|
'c_forum_mailcue', |
|
182
|
|
|
'c_forum_notification', |
|
183
|
|
|
//'c_forum_post', |
|
184
|
|
|
//'c_forum_thread', |
|
185
|
|
|
'c_forum_thread_qualify', |
|
186
|
|
|
'c_forum_thread_qualify_log', |
|
187
|
|
|
//'c_glossary', |
|
188
|
|
|
'c_group_category', |
|
189
|
|
|
'c_group_info', |
|
190
|
|
|
'c_group_rel_tutor', |
|
191
|
|
|
'c_group_rel_user', |
|
192
|
|
|
'c_item_property', |
|
193
|
|
|
'c_link', |
|
194
|
|
|
'c_link_category', |
|
195
|
|
|
'c_lp', |
|
196
|
|
|
'c_lp_item', |
|
197
|
|
|
'c_lp_item_view', |
|
198
|
|
|
'c_lp_iv_interaction', |
|
199
|
|
|
'c_lp_iv_objective', |
|
200
|
|
|
'c_lp_view', |
|
201
|
|
|
//'c_notebook', |
|
202
|
|
|
//'c_online_connected', |
|
203
|
|
|
'c_online_link', |
|
204
|
|
|
'c_permission_group', |
|
205
|
|
|
'c_permission_task', |
|
206
|
|
|
'c_permission_user', |
|
207
|
|
|
'c_quiz', |
|
208
|
|
|
//'c_quiz_answer', |
|
209
|
|
|
'c_quiz_question', |
|
210
|
|
|
'c_quiz_question_category', |
|
211
|
|
|
'c_quiz_question_option', |
|
212
|
|
|
//'c_quiz_question_rel_category', |
|
213
|
|
|
//'c_quiz_rel_question', |
|
214
|
|
|
'c_resource', |
|
215
|
|
|
//'c_role', |
|
216
|
|
|
'c_role_group', |
|
217
|
|
|
'c_role_permissions', |
|
218
|
|
|
//'c_role_user', |
|
219
|
|
|
'c_student_publication', |
|
220
|
|
|
'c_student_publication_assignment', |
|
221
|
|
|
//'c_student_publication_comment', |
|
222
|
|
|
//'c_student_publication_rel_document', |
|
223
|
|
|
//'c_student_publication_rel_user', |
|
224
|
|
|
//'c_survey', |
|
225
|
|
|
//'c_survey_answer', |
|
226
|
|
|
'c_survey_group', |
|
227
|
|
|
//'c_survey_invitation', |
|
228
|
|
|
//'c_survey_question', |
|
229
|
|
|
//'c_survey_question_option', |
|
230
|
|
|
'c_thematic', |
|
231
|
|
|
'c_thematic_advance', |
|
232
|
|
|
'c_thematic_plan', |
|
233
|
|
|
'c_tool', |
|
234
|
|
|
//'c_tool_intro', |
|
235
|
|
|
'c_userinfo_content', |
|
236
|
|
|
'c_userinfo_def', |
|
237
|
|
|
'c_wiki', |
|
238
|
|
|
//'c_wiki_conf', |
|
239
|
|
|
'c_wiki_discuss', |
|
240
|
|
|
'c_wiki_mailcue' |
|
241
|
|
|
]; |
|
242
|
|
|
|
|
243
|
|
|
foreach ($tables as $table) { |
|
244
|
|
|
if ($schema->hasTable($table)) { |
|
245
|
|
|
$this->addSql("ALTER TABLE $table MODIFY COLUMN id INT NULL"); |
|
246
|
|
|
$this->addSql("ALTER TABLE $table MODIFY COLUMN c_id INT NOT NULL"); |
|
247
|
|
|
$this->addSql("ALTER TABLE $table DROP PRIMARY KEY"); |
|
248
|
|
|
$this->addSql("ALTER TABLE $table ADD COLUMN iid int NOT NULL PRIMARY KEY AUTO_INCREMENT"); |
|
249
|
|
|
} |
|
250
|
|
|
} |
|
251
|
|
|
|
|
252
|
|
|
if ($schema->hasTable('c_attendance_calendar_rel_group')) { |
|
253
|
|
|
$this->addSql("ALTER TABLE c_attendance_calendar_rel_group MODIFY COLUMN id INT NULL DEFAULT NULL"); |
|
254
|
|
|
$this->addSql("ALTER TABLE c_attendance_calendar_rel_group DROP PRIMARY KEY"); |
|
255
|
|
|
$this->addSql("ALTER TABLE c_attendance_calendar_rel_group ADD COLUMN iid int NOT NULL PRIMARY KEY AUTO_INCREMENT"); |
|
256
|
|
|
} |
|
257
|
|
|
|
|
258
|
|
|
$this->addSql("ALTER TABLE c_attendance_sheet MODIFY COLUMN c_id INT NOT NULL"); |
|
259
|
|
|
$this->addSql("ALTER TABLE c_attendance_sheet DROP PRIMARY KEY"); |
|
260
|
|
|
$this->addSql("ALTER TABLE c_attendance_sheet ADD COLUMN iid int NOT NULL PRIMARY KEY AUTO_INCREMENT"); |
|
261
|
|
|
|
|
262
|
|
|
$this->addSql("ALTER TABLE c_blog MODIFY COLUMN blog_id int unsigned DEFAULT NULL"); |
|
263
|
|
|
$this->addSql("ALTER TABLE c_blog MODIFY COLUMN c_id INT NOT NULL"); |
|
264
|
|
|
$this->addSql("ALTER TABLE c_blog DROP PRIMARY KEY"); |
|
265
|
|
|
$this->addSql("ALTER TABLE c_blog ADD COLUMN iid int NOT NULL PRIMARY KEY AUTO_INCREMENT"); |
|
266
|
|
|
|
|
267
|
|
|
$this->addSql("ALTER TABLE c_blog_comment MODIFY COLUMN comment_id int DEFAULT NULL"); |
|
268
|
|
|
$this->addSql("ALTER TABLE c_blog_comment MODIFY COLUMN c_id INT NOT NULL"); |
|
269
|
|
|
$this->addSql("ALTER TABLE c_blog_comment DROP PRIMARY KEY"); |
|
270
|
|
|
$this->addSql("ALTER TABLE c_blog_comment ADD COLUMN iid int NOT NULL PRIMARY KEY AUTO_INCREMENT"); |
|
271
|
|
|
|
|
272
|
|
|
$this->addSql("ALTER TABLE c_blog_post MODIFY COLUMN post_id int unsigned DEFAULT NULL"); |
|
273
|
|
|
$this->addSql("ALTER TABLE c_blog_post MODIFY COLUMN c_id INT NOT NULL"); |
|
274
|
|
|
$this->addSql("ALTER TABLE c_blog_post DROP PRIMARY KEY"); |
|
275
|
|
|
$this->addSql("ALTER TABLE c_blog_post ADD COLUMN iid int NOT NULL PRIMARY KEY AUTO_INCREMENT"); |
|
276
|
|
|
|
|
277
|
|
|
$this->addSql("ALTER TABLE c_blog_rating MODIFY COLUMN rating_id int unsigned DEFAULT NULL"); |
|
278
|
|
|
$this->addSql("ALTER TABLE c_blog_rating MODIFY COLUMN c_id INT NOT NULL"); |
|
279
|
|
|
$this->addSql("ALTER TABLE c_blog_rating DROP PRIMARY KEY"); |
|
280
|
|
|
$this->addSql("ALTER TABLE c_blog_rating ADD COLUMN iid int NOT NULL PRIMARY KEY AUTO_INCREMENT"); |
|
281
|
|
|
|
|
282
|
|
|
$this->addSql("ALTER TABLE c_blog_rel_user MODIFY COLUMN c_id INT NOT NULL"); |
|
283
|
|
|
$this->addSql("ALTER TABLE c_blog_rel_user MODIFY COLUMN blog_id int unsigned DEFAULT NULL"); |
|
284
|
|
|
$this->addSql("ALTER TABLE c_blog_rel_user MODIFY COLUMN user_id int unsigned DEFAULT NULL"); |
|
285
|
|
|
$this->addSql("ALTER TABLE c_blog_rel_user DROP PRIMARY KEY"); |
|
286
|
|
|
$this->addSql("ALTER TABLE c_blog_rel_user ADD COLUMN iid int NOT NULL PRIMARY KEY AUTO_INCREMENT"); |
|
287
|
|
|
|
|
288
|
|
|
$this->addSql("ALTER TABLE c_blog_task MODIFY COLUMN task_id int unsigned DEFAULT NULL"); |
|
289
|
|
|
$this->addSql("ALTER TABLE c_blog_task MODIFY COLUMN c_id INT NOT NULL"); |
|
290
|
|
|
$this->addSql("ALTER TABLE c_blog_task DROP PRIMARY KEY"); |
|
291
|
|
|
$this->addSql("ALTER TABLE c_blog_task ADD COLUMN iid int NOT NULL PRIMARY KEY AUTO_INCREMENT"); |
|
292
|
|
|
|
|
293
|
|
|
$this->addSql("ALTER TABLE c_blog_task_rel_user MODIFY COLUMN blog_id int unsigned DEFAULT NULL"); |
|
294
|
|
|
$this->addSql("ALTER TABLE c_blog_task_rel_user MODIFY COLUMN user_id int unsigned DEFAULT NULL"); |
|
295
|
|
|
$this->addSql("ALTER TABLE c_blog_task_rel_user MODIFY COLUMN task_id int unsigned DEFAULT NULL"); |
|
296
|
|
|
$this->addSql("ALTER TABLE c_blog_task_rel_user DROP PRIMARY KEY"); |
|
297
|
|
|
$this->addSql("ALTER TABLE c_blog_task_rel_user ADD COLUMN iid int NOT NULL PRIMARY KEY AUTO_INCREMENT"); |
|
298
|
|
|
|
|
299
|
|
|
$this->addSql("ALTER TABLE c_calendar_event_repeat MODIFY COLUMN cal_id int unsigned DEFAULT NULL"); |
|
300
|
|
|
$this->addSql("ALTER TABLE c_calendar_event_repeat MODIFY COLUMN c_id INT NOT NULL"); |
|
301
|
|
|
$this->addSql("ALTER TABLE c_calendar_event_repeat DROP PRIMARY KEY"); |
|
302
|
|
|
$this->addSql("ALTER TABLE c_calendar_event_repeat ADD COLUMN iid int NOT NULL PRIMARY KEY AUTO_INCREMENT"); |
|
303
|
|
|
|
|
304
|
|
|
$this->addSql("ALTER TABLE c_calendar_event_repeat_not MODIFY COLUMN cal_id int unsigned DEFAULT NULL"); |
|
305
|
|
|
$this->addSql("ALTER TABLE c_calendar_event_repeat_not MODIFY COLUMN c_id INT NOT NULL"); |
|
306
|
|
|
$this->addSql("ALTER TABLE c_calendar_event_repeat_not DROP PRIMARY KEY"); |
|
307
|
|
|
$this->addSql("ALTER TABLE c_calendar_event_repeat_not ADD COLUMN iid int NOT NULL PRIMARY KEY AUTO_INCREMENT"); |
|
308
|
|
|
|
|
309
|
|
|
$this->addSql("ALTER TABLE c_dropbox_category MODIFY COLUMN cat_id int unsigned DEFAULT NULL"); |
|
310
|
|
|
$this->addSql("ALTER TABLE c_dropbox_category MODIFY COLUMN c_id INT NOT NULL"); |
|
311
|
|
|
$this->addSql("ALTER TABLE c_dropbox_category DROP PRIMARY KEY"); |
|
312
|
|
|
$this->addSql("ALTER TABLE c_dropbox_category ADD COLUMN iid int NOT NULL PRIMARY KEY AUTO_INCREMENT"); |
|
313
|
|
|
|
|
314
|
|
|
$this->addSql("ALTER TABLE c_dropbox_feedback MODIFY COLUMN feedback_id int unsigned DEFAULT NULL"); |
|
315
|
|
|
$this->addSql("ALTER TABLE c_dropbox_feedback MODIFY COLUMN c_id INT NOT NULL"); |
|
316
|
|
|
$this->addSql("ALTER TABLE c_dropbox_feedback DROP PRIMARY KEY"); |
|
317
|
|
|
$this->addSql("ALTER TABLE c_dropbox_feedback ADD COLUMN iid int NOT NULL PRIMARY KEY AUTO_INCREMENT"); |
|
318
|
|
|
|
|
319
|
|
|
$this->addSql("ALTER TABLE c_dropbox_person MODIFY COLUMN file_id int unsigned DEFAULT NULL"); |
|
320
|
|
|
$this->addSql("ALTER TABLE c_dropbox_person MODIFY COLUMN c_id INT NOT NULL"); |
|
321
|
|
|
$this->addSql("ALTER TABLE c_dropbox_person DROP PRIMARY KEY"); |
|
322
|
|
|
$this->addSql("ALTER TABLE c_dropbox_person ADD COLUMN iid int NOT NULL PRIMARY KEY AUTO_INCREMENT"); |
|
323
|
|
|
|
|
324
|
|
|
$this->addSql("ALTER TABLE c_dropbox_post MODIFY COLUMN file_id int unsigned DEFAULT NULL"); |
|
325
|
|
|
$this->addSql("ALTER TABLE c_dropbox_post MODIFY COLUMN c_id INT NOT NULL"); |
|
326
|
|
|
$this->addSql("ALTER TABLE c_dropbox_post DROP PRIMARY KEY"); |
|
327
|
|
|
$this->addSql("ALTER TABLE c_dropbox_post ADD COLUMN iid int NOT NULL PRIMARY KEY AUTO_INCREMENT"); |
|
328
|
|
|
|
|
329
|
|
|
$this->addSql("ALTER TABLE c_forum_category MODIFY COLUMN cat_id int unsigned DEFAULT NULL"); |
|
330
|
|
|
$this->addSql("ALTER TABLE c_forum_category MODIFY COLUMN c_id INT NOT NULL"); |
|
331
|
|
|
$this->addSql("ALTER TABLE c_forum_category DROP PRIMARY KEY"); |
|
332
|
|
|
$this->addSql("ALTER TABLE c_forum_category ADD COLUMN iid int NOT NULL PRIMARY KEY AUTO_INCREMENT"); |
|
333
|
|
|
|
|
334
|
|
|
$this->addSql("ALTER TABLE c_forum_forum MODIFY COLUMN forum_id int unsigned DEFAULT NULL"); |
|
335
|
|
|
$this->addSql("ALTER TABLE c_forum_forum MODIFY COLUMN c_id INT NOT NULL"); |
|
336
|
|
|
$this->addSql("ALTER TABLE c_forum_forum DROP PRIMARY KEY"); |
|
337
|
|
|
$this->addSql("ALTER TABLE c_forum_forum ADD COLUMN iid int NOT NULL PRIMARY KEY AUTO_INCREMENT"); |
|
338
|
|
|
|
|
339
|
|
|
$this->addSql("ALTER TABLE c_forum_post MODIFY COLUMN post_id int unsigned DEFAULT NULL"); |
|
340
|
|
|
$this->addSql("ALTER TABLE c_forum_post MODIFY COLUMN c_id INT NOT NULL"); |
|
341
|
|
|
$this->addSql("ALTER TABLE c_forum_post DROP PRIMARY KEY"); |
|
342
|
|
|
$this->addSql("ALTER TABLE c_forum_post ADD COLUMN iid int NOT NULL PRIMARY KEY AUTO_INCREMENT"); |
|
343
|
|
|
|
|
344
|
|
|
$this->addSql("ALTER TABLE c_forum_thread MODIFY COLUMN forum_id int unsigned DEFAULT NULL"); |
|
345
|
|
|
$this->addSql("ALTER TABLE c_forum_thread MODIFY COLUMN c_id INT NOT NULL"); |
|
346
|
|
|
$this->addSql("ALTER TABLE c_forum_thread MODIFY COLUMN thread_id int unsigned DEFAULT NULL"); |
|
347
|
|
|
$this->addSql("ALTER TABLE c_forum_thread DROP PRIMARY KEY"); |
|
348
|
|
|
$this->addSql("ALTER TABLE c_forum_thread ADD COLUMN iid int NOT NULL PRIMARY KEY AUTO_INCREMENT"); |
|
349
|
|
|
|
|
350
|
|
|
$this->addSql("ALTER TABLE c_forum_thread ADD COLUMN thread_peer_qualify tinyint default 0"); |
|
351
|
|
|
|
|
352
|
|
|
$this->addSql("ALTER TABLE c_glossary MODIFY COLUMN glossary_id int unsigned DEFAULT NULL"); |
|
353
|
|
|
$this->addSql("ALTER TABLE c_glossary MODIFY COLUMN c_id INT NOT NULL"); |
|
354
|
|
|
$this->addSql("ALTER TABLE c_glossary DROP PRIMARY KEY"); |
|
355
|
|
|
$this->addSql("ALTER TABLE c_glossary ADD COLUMN iid int NOT NULL PRIMARY KEY AUTO_INCREMENT"); |
|
356
|
|
|
|
|
357
|
|
|
$this->addSql("ALTER TABLE c_notebook MODIFY COLUMN notebook_id int unsigned DEFAULT NULL"); |
|
358
|
|
|
$this->addSql("ALTER TABLE c_notebook MODIFY COLUMN c_id INT NOT NULL"); |
|
359
|
|
|
$this->addSql("ALTER TABLE c_notebook DROP PRIMARY KEY"); |
|
360
|
|
|
$this->addSql("ALTER TABLE c_notebook ADD COLUMN iid int NOT NULL PRIMARY KEY AUTO_INCREMENT"); |
|
361
|
|
|
|
|
362
|
|
|
$this->addSql("ALTER TABLE c_online_connected MODIFY COLUMN c_id INT NOT NULL"); |
|
363
|
|
|
$this->addSql("ALTER TABLE c_online_connected DROP PRIMARY KEY"); |
|
364
|
|
|
$this->addSql("ALTER TABLE c_online_connected ADD COLUMN iid int NOT NULL PRIMARY KEY AUTO_INCREMENT"); |
|
365
|
|
|
|
|
366
|
|
|
// For some reason c_tool_intro.id is a varchar in 1.9.x |
|
367
|
|
|
$this->addSql("ALTER TABLE c_tool_intro MODIFY COLUMN id VARCHAR(50) NOT NULL"); |
|
368
|
|
|
$this->addSql("ALTER TABLE c_tool_intro MODIFY COLUMN c_id INT NOT NULL"); |
|
369
|
|
|
$this->addSql("ALTER TABLE c_tool_intro MODIFY COLUMN session_id int unsigned DEFAULT NULL"); |
|
370
|
|
|
$this->addSql("ALTER TABLE c_tool_intro DROP PRIMARY KEY"); |
|
371
|
|
|
$this->addSql("ALTER TABLE c_tool_intro ADD COLUMN iid int NOT NULL PRIMARY KEY AUTO_INCREMENT"); |
|
372
|
|
|
|
|
373
|
|
|
$this->addSql("ALTER TABLE c_quiz_answer MODIFY COLUMN c_id INT NOT NULL"); |
|
374
|
|
|
$this->addSql("ALTER TABLE c_quiz_answer MODIFY COLUMN id_auto int unsigned DEFAULT NULL"); |
|
375
|
|
|
$this->addSql("ALTER TABLE c_quiz_answer DROP PRIMARY KEY"); |
|
376
|
|
|
$this->addSql("ALTER TABLE c_quiz_answer ADD COLUMN iid int NOT NULL PRIMARY KEY AUTO_INCREMENT"); |
|
377
|
|
|
|
|
378
|
|
|
$this->addSql("ALTER TABLE c_quiz_question_rel_category MODIFY COLUMN c_id INT NOT NULL"); |
|
379
|
|
|
$this->addSql("ALTER TABLE c_quiz_question_rel_category MODIFY COLUMN question_id int unsigned DEFAULT NULL"); |
|
380
|
|
|
$this->addSql("ALTER TABLE c_quiz_question_rel_category DROP PRIMARY KEY"); |
|
381
|
|
|
$this->addSql("ALTER TABLE c_quiz_question_rel_category ADD COLUMN iid int NOT NULL PRIMARY KEY AUTO_INCREMENT"); |
|
382
|
|
|
|
|
383
|
|
|
$this->addSql("ALTER TABLE session_rel_user MODIFY COLUMN id_session int"); |
|
384
|
|
|
$this->addSql("ALTER TABLE session_rel_user MODIFY COLUMN id_user int"); |
|
385
|
|
|
$this->addSql("ALTER TABLE session_rel_user MODIFY COLUMN relation_type int unsigned DEFAULT 0"); |
|
386
|
|
|
$this->addSql("ALTER TABLE session_rel_user DROP PRIMARY KEY"); |
|
387
|
|
|
|
|
388
|
|
|
$this->addSql("ALTER TABLE session_rel_user CHANGE id_session session_id int"); |
|
389
|
|
|
$this->addSql("ALTER TABLE session_rel_user CHANGE id_user user_id int"); |
|
390
|
|
|
$this->addSql("ALTER TABLE session_rel_user ADD COLUMN id int NOT NULL PRIMARY KEY AUTO_INCREMENT"); |
|
391
|
|
|
|
|
392
|
|
|
$this->addSql("ALTER TABLE c_item_property CHANGE id_session session_id int"); |
|
393
|
|
|
$this->addSql("ALTER TABLE course_rel_user CHANGE tutor_id is_tutor int"); |
|
394
|
|
|
|
|
395
|
|
|
$this->addSql("ALTER TABLE c_quiz_rel_question MODIFY COLUMN c_id INT NOT NULL"); |
|
396
|
|
|
$this->addSql("ALTER TABLE c_quiz_rel_question MODIFY COLUMN question_id int unsigned DEFAULT NULL"); |
|
397
|
|
|
$this->addSql("ALTER TABLE c_quiz_rel_question MODIFY COLUMN exercice_id int unsigned DEFAULT NULL"); |
|
398
|
|
|
$this->addSql("ALTER TABLE c_quiz_rel_question DROP PRIMARY KEY"); |
|
399
|
|
|
$this->addSql("ALTER TABLE c_quiz_rel_question ADD COLUMN iid int NOT NULL PRIMARY KEY AUTO_INCREMENT"); |
|
400
|
|
|
|
|
401
|
|
|
$this->addSql("ALTER TABLE c_role MODIFY COLUMN role_id int unsigned DEFAULT NULL"); |
|
402
|
|
|
$this->addSql("ALTER TABLE c_role MODIFY COLUMN c_id INT NOT NULL"); |
|
403
|
|
|
$this->addSql("ALTER TABLE c_role DROP PRIMARY KEY"); |
|
404
|
|
|
$this->addSql("ALTER TABLE c_role ADD COLUMN iid int NOT NULL PRIMARY KEY AUTO_INCREMENT"); |
|
405
|
|
|
|
|
406
|
|
|
$this->addSql("ALTER TABLE c_role_user MODIFY COLUMN role_id int unsigned DEFAULT NULL"); |
|
407
|
|
|
$this->addSql("ALTER TABLE c_role_user MODIFY COLUMN user_id int unsigned DEFAULT NULL"); |
|
408
|
|
|
$this->addSql("ALTER TABLE c_role_user MODIFY COLUMN c_id INT NOT NULL"); |
|
409
|
|
|
$this->addSql("ALTER TABLE c_role_user DROP PRIMARY KEY"); |
|
410
|
|
|
$this->addSql("ALTER TABLE c_role_user ADD COLUMN iid int NOT NULL PRIMARY KEY AUTO_INCREMENT"); |
|
411
|
|
|
|
|
412
|
|
|
$this->addSql("ALTER TABLE c_survey MODIFY COLUMN survey_id int NULL"); |
|
413
|
|
|
$this->addSql("ALTER TABLE c_survey MODIFY COLUMN c_id INT NOT NULL"); |
|
414
|
|
|
$this->addSql("ALTER TABLE c_survey DROP PRIMARY KEY"); |
|
415
|
|
|
$this->addSql("ALTER TABLE c_survey ADD COLUMN iid int NOT NULL PRIMARY KEY AUTO_INCREMENT"); |
|
416
|
|
|
|
|
417
|
|
|
$this->addSql("ALTER TABLE c_survey_answer MODIFY COLUMN answer_id int unsigned DEFAULT NULL"); |
|
418
|
|
|
$this->addSql("ALTER TABLE c_survey_answer MODIFY COLUMN c_id INT NOT NULL"); |
|
419
|
|
|
$this->addSql("ALTER TABLE c_survey_answer DROP PRIMARY KEY"); |
|
420
|
|
|
$this->addSql("ALTER TABLE c_survey_answer ADD COLUMN iid int NOT NULL PRIMARY KEY AUTO_INCREMENT"); |
|
421
|
|
|
|
|
422
|
|
|
$this->addSql("ALTER TABLE c_survey_invitation MODIFY COLUMN survey_invitation_id int unsigned DEFAULT NULL"); |
|
423
|
|
|
$this->addSql("ALTER TABLE c_survey_invitation MODIFY COLUMN c_id INT NOT NULL"); |
|
424
|
|
|
$this->addSql("ALTER TABLE c_survey_invitation DROP PRIMARY KEY"); |
|
425
|
|
|
$this->addSql("ALTER TABLE c_survey_invitation ADD COLUMN iid int NOT NULL PRIMARY KEY AUTO_INCREMENT"); |
|
426
|
|
|
|
|
427
|
|
|
$this->addSql("ALTER TABLE c_survey_question MODIFY COLUMN question_id int unsigned DEFAULT NULL"); |
|
428
|
|
|
$this->addSql("ALTER TABLE c_survey_question MODIFY COLUMN c_id INT NOT NULL"); |
|
429
|
|
|
$this->addSql("ALTER TABLE c_survey_question DROP PRIMARY KEY"); |
|
430
|
|
|
$this->addSql("ALTER TABLE c_survey_question ADD COLUMN iid int NOT NULL PRIMARY KEY AUTO_INCREMENT"); |
|
431
|
|
|
|
|
432
|
|
|
$this->addSql("ALTER TABLE c_survey_question_option MODIFY COLUMN question_option_id int unsigned DEFAULT NULL"); |
|
433
|
|
|
$this->addSql("ALTER TABLE c_survey_question_option MODIFY COLUMN c_id INT NOT NULL"); |
|
434
|
|
|
$this->addSql("ALTER TABLE c_survey_question_option DROP PRIMARY KEY"); |
|
435
|
|
|
$this->addSql("ALTER TABLE c_survey_question_option ADD COLUMN iid int NOT NULL PRIMARY KEY AUTO_INCREMENT"); |
|
436
|
|
|
|
|
437
|
|
|
$this->addSql("ALTER TABLE c_wiki_conf MODIFY COLUMN page_id int unsigned DEFAULT NULL"); |
|
438
|
|
|
$this->addSql("ALTER TABLE c_wiki_conf MODIFY COLUMN c_id INT NOT NULL"); |
|
439
|
|
|
$this->addSql("ALTER TABLE c_wiki_conf DROP PRIMARY KEY"); |
|
440
|
|
|
$this->addSql("ALTER TABLE c_wiki_conf ADD COLUMN iid int NOT NULL PRIMARY KEY AUTO_INCREMENT"); |
|
441
|
|
|
|
|
442
|
|
|
// Course |
|
443
|
|
|
$this->addSql("ALTER TABLE c_survey ADD COLUMN visible_results INT UNSIGNED DEFAULT 0"); |
|
444
|
|
|
$this->addSql("ALTER TABLE c_survey_invitation ADD COLUMN group_id INT NOT NULL"); |
|
445
|
|
|
$this->addSql("ALTER TABLE c_lp_item ADD COLUMN prerequisite_min_score float"); |
|
446
|
|
|
$this->addSql("ALTER TABLE c_lp_item ADD COLUMN prerequisite_max_score float"); |
|
447
|
|
|
$this->addSql("ALTER TABLE c_group_info ADD COLUMN status tinyint DEFAULT 1"); |
|
448
|
|
|
$this->addSql("ALTER TABLE c_student_publication ADD COLUMN document_id int DEFAULT 0"); |
|
449
|
|
|
$this->addSql("ALTER TABLE c_lp_item MODIFY COLUMN description VARCHAR(511) DEFAULT ''"); |
|
450
|
|
|
$this->addSql("ALTER TABLE course_category MODIFY COLUMN auth_course_child VARCHAR(40) DEFAULT 'TRUE' "); |
|
451
|
|
|
$this->addSql("ALTER TABLE course_category MODIFY COLUMN auth_cat_child VARCHAR(40) DEFAULT 'TRUE'"); |
|
452
|
|
|
$this->addSql("ALTER TABLE c_quiz_answer MODIFY COLUMN hotspot_type varchar(40) default NULL"); |
|
453
|
|
|
$this->addSql("ALTER TABLE c_tool MODIFY COLUMN target varchar(20) NOT NULL default '_self' "); |
|
454
|
|
|
$this->addSql("ALTER TABLE c_link MODIFY COLUMN on_homepage char(10) NOT NULL default '0' "); |
|
455
|
|
|
$this->addSql("ALTER TABLE c_blog_rating MODIFY COLUMN rating_type char(40) NOT NULL default 'post' "); |
|
456
|
|
|
$this->addSql("ALTER TABLE c_survey MODIFY COLUMN anonymous char(10) NOT NULL default '0'"); |
|
457
|
|
|
$this->addSql("ALTER TABLE c_course_setting MODIFY COLUMN value varchar(255) default ''"); |
|
458
|
|
|
|
|
459
|
|
|
$this->addSql("UPDATE course_field SET field_type = 13 WHERE field_variable = 'special_course'"); |
|
460
|
|
|
$this->addSql("UPDATE user SET registration_date = NULL WHERE registration_date = '0000-00-00 00:00:00'"); |
|
461
|
|
|
$this->addSql("UPDATE user SET expiration_date = NULL WHERE expiration_date = '0000-00-00 00:00:00'"); |
|
462
|
|
|
$this->addSql("UPDATE track_e_default SET default_date = NULL WHERE default_date = '0000-00-00 00:00:00'"); |
|
463
|
|
|
$this->addSql("UPDATE track_e_lastaccess SET access_date = NULL WHERE access_date = '0000-00-00 00:00:00'"); |
|
464
|
|
|
$this->addSql("UPDATE track_e_downloads SET down_date = NULL WHERE down_date = '0000-00-00 00:00:00'"); |
|
465
|
|
|
$this->addSql("UPDATE track_e_access SET access_date = NULL WHERE access_date = '0000-00-00 00:00:00'"); |
|
466
|
|
|
$this->addSql("UPDATE track_e_access SET c_id = (SELECT id FROM course WHERE code = access_cours_code)"); |
|
467
|
|
|
$this->addSql("UPDATE track_e_default SET c_id = (SELECT id FROM course WHERE code = default_cours_code)"); |
|
468
|
|
|
$this->addSql("UPDATE track_e_lastaccess SET c_id = (SELECT id FROM course WHERE code = access_cours_code)"); |
|
469
|
|
|
$this->addSql("UPDATE track_e_exercices SET c_id = (SELECT id FROM course WHERE code = exe_cours_id)"); |
|
470
|
|
|
$this->addSql("UPDATE track_e_downloads SET c_id = (SELECT id FROM course WHERE code = down_cours_id)"); |
|
471
|
|
|
$this->addSql("UPDATE track_e_hotpotatoes SET c_id = (SELECT id FROM course WHERE code = exe_cours_id)"); |
|
472
|
|
|
$this->addSql("UPDATE track_e_links SET c_id = (SELECT id FROM course WHERE code = links_cours_id)"); |
|
473
|
|
|
$this->addSql("UPDATE track_e_course_access SET c_id = (SELECT id FROM course WHERE code = course_code)"); |
|
474
|
|
|
$this->addSql("UPDATE track_e_online SET c_id = (SELECT id FROM course WHERE code = course)"); |
|
475
|
|
|
$this->addSql("UPDATE track_e_attempt SET c_id = (SELECT id FROM course WHERE code = course_code)"); |
|
476
|
|
|
$this->addSql("UPDATE course_field_values SET c_id = (SELECT id FROM course WHERE code = course_code)"); |
|
477
|
|
|
$this->addSql("UPDATE session_rel_course_rel_user SET c_id = (SELECT id FROM course WHERE code = course_code)"); |
|
478
|
|
|
$this->addSql("UPDATE session_rel_course SET c_id = (SELECT id FROM course WHERE code = course_code)"); |
|
479
|
|
|
|
|
480
|
|
|
$this->addSql("UPDATE access_url_rel_course SET c_id = (SELECT id FROM course WHERE code = course_code)"); |
|
481
|
|
|
|
|
482
|
|
|
$this->addSql("ALTER TABLE settings_current DROP INDEX unique_setting"); |
|
483
|
|
|
$this->addSql("ALTER TABLE settings_options DROP INDEX unique_setting_option"); |
|
484
|
|
|
|
|
485
|
|
|
$this->addSql("DELETE FROM settings_current WHERE variable = 'wcag_anysurfer_public_pages'"); |
|
486
|
|
|
|
|
487
|
|
|
$this->addSql("DELETE FROM settings_current WHERE variable = 'wcag_anysurfer_public_pages'"); |
|
488
|
|
|
$this->addSql("DELETE FROM settings_options WHERE variable = 'wcag_anysurfer_public_pages'"); |
|
489
|
|
|
$this->addSql("DELETE FROM settings_current WHERE variable = 'advanced_filemanager'"); |
|
490
|
|
|
$this->addSql("DELETE FROM settings_options WHERE variable = 'advanced_filemanager'"); |
|
491
|
|
|
|
|
492
|
|
|
$this->addSql("INSERT INTO settings_current (variable, subkey, type, category, selected_value, title, comment, scope, subkeytext, access_url_changeable) VALUES ('institution_address', NULL, 'textfield', 'Platform', '', 'InstitutionAddressTitle', 'InstitutionAddressComment', NULL, NULL, 1)"); |
|
493
|
|
|
$this->addSql("INSERT INTO settings_current (variable, subkey, type, category, selected_value, title, comment, scope, subkeytext, access_url_changeable) VALUES ('prevent_session_admins_to_manage_all_users', NULL, 'radio', 'Session', 'false', 'PreventSessionAdminsToManageAllUsersTitle', 'PreventSessionAdminsToManageAllUsersComment', NULL, NULL, 1)"); |
|
494
|
|
|
$this->addSql("INSERT INTO settings_options (variable, value, display_text) VALUES ('prevent_session_admins_to_manage_all_users', 'true', 'Yes'), ('prevent_session_admins_to_manage_all_users', 'false', 'No')"); |
|
495
|
|
|
$this->addSql("INSERT INTO settings_options (variable, value, display_text) VALUES ('show_glossary_in_extra_tools', 'none', 'None')"); |
|
496
|
|
|
$this->addSql("INSERT INTO settings_options (variable, value, display_text) VALUES ('show_glossary_in_extra_tools', 'exercise', 'Exercise')"); |
|
497
|
|
|
$this->addSql("INSERT INTO settings_options (variable, value, display_text) VALUES ('show_glossary_in_extra_tools', 'lp', 'Learning path')"); |
|
498
|
|
|
$this->addSql("INSERT INTO settings_options (variable, value, display_text) VALUES ('show_glossary_in_extra_tools', 'exercise_and_lp', 'ExerciseAndLearningPath')"); |
|
499
|
|
|
$this->addSql("INSERT INTO settings_current (variable, subkey, type, category, selected_value, title, comment, scope, subkeytext, access_url_changeable) VALUES ('documents_default_visibility_defined_in_course', NULL,'radio','Tools','false','DocumentsDefaultVisibilityDefinedInCourseTitle','DocumentsDefaultVisibilityDefinedInCourseComment',NULL, NULL, 1)"); |
|
500
|
|
|
$this->addSql("INSERT INTO settings_options (variable, value, display_text) VALUES ('documents_default_visibility_defined_in_course', 'true', 'Yes')"); |
|
501
|
|
|
$this->addSql("INSERT INTO settings_options (variable, value, display_text) VALUES ('documents_default_visibility_defined_in_course', 'false', 'No')"); |
|
502
|
|
|
$this->addSql("INSERT INTO settings_current (variable, subkey, type, category, selected_value, title, comment, scope, subkeytext, access_url_changeable) VALUES ('enabled_mathjax', NULL, 'radio', 'Editor', 'false', 'EnableMathJaxTitle', 'EnableMathJaxComment', NULL, NULL, 0)"); |
|
503
|
|
|
$this->addSql("INSERT INTO settings_options (variable, value, display_text) VALUES ('enabled_mathjax', 'true', 'Yes')"); |
|
504
|
|
|
$this->addSql("INSERT INTO settings_options (variable, value, display_text) VALUES ('enabled_mathjax', 'false', 'No')"); |
|
505
|
|
|
|
|
506
|
|
|
$this->addSql("INSERT INTO language (original_name, english_name, isocode, dokeos_folder, available) VALUES ('Føroyskt', 'faroese', 'fo', 'faroese', 0), ('Tagalog', 'tagalog', 'tl', 'tagalog',1), ('Tibetan', 'tibetan', 'bo', 'tibetan', 0), ('isiXhosa', 'xhosa', 'xh', 'xhosa', 0)"); |
|
507
|
|
|
$this->addSql("DELETE FROM settings_options WHERE variable = 'show_glossary_in_extra_tools'"); |
|
508
|
|
|
|
|
509
|
|
|
$this->addSql("ALTER TABLE c_student_publication MODIFY COLUMN date_of_qualification DATETIME NULL DEFAULT NULL"); |
|
510
|
|
|
$this->addSql("ALTER TABLE c_student_publication MODIFY COLUMN sent_date DATETIME NULL DEFAULT NULL"); |
|
511
|
|
|
$this->addSql("UPDATE c_student_publication SET date_of_qualification = NULL WHERE date_of_qualification = '0000-00-00 00:00:00'"); |
|
512
|
|
|
$this->addSql("UPDATE c_student_publication SET sent_date = NULL WHERE sent_date = '0000-00-00 00:00:00'"); |
|
513
|
|
|
|
|
514
|
|
|
$this->addSql("ALTER TABLE c_student_publication_assignment MODIFY COLUMN expires_on DATETIME NULL DEFAULT NULL"); |
|
515
|
|
|
$this->addSql("ALTER TABLE c_student_publication_assignment MODIFY COLUMN ends_on DATETIME NULL DEFAULT NULL"); |
|
516
|
|
|
$this->addSql("UPDATE c_student_publication_assignment SET expires_on = NULL WHERE expires_on = '0000-00-00 00:00:00'"); |
|
517
|
|
|
$this->addSql("UPDATE c_student_publication_assignment SET ends_on = NULL WHERE ends_on = '0000-00-00 00:00:00'"); |
|
518
|
|
|
|
|
519
|
|
|
$this->addSql("UPDATE settings_current SET type = 'checkbox' WHERE variable = 'registration' AND category = 'User'"); |
|
520
|
|
|
|
|
521
|
|
|
$this->addSql("UPDATE settings_current SET selected_value = 'UTF-8' WHERE variable = 'platform_charset'"); |
|
522
|
|
|
|
|
523
|
|
|
$this->addSql("ALTER TABLE course_rel_user DROP PRIMARY KEY"); |
|
524
|
|
|
$this->addSql("ALTER TABLE course_rel_user ADD COLUMN id INT NOT NULL PRIMARY KEY AUTO_INCREMENT"); |
|
525
|
|
|
$this->addSql("ALTER TABLE course_rel_user MODIFY COLUMN user_id INT NULL"); |
|
526
|
|
|
|
|
527
|
|
|
$this->addSql("ALTER TABLE user MODIFY COLUMN user_id INT NULL"); |
|
528
|
|
|
|
|
529
|
|
|
$this->addSql("ALTER TABLE access_url_rel_course DROP PRIMARY KEY"); |
|
530
|
|
|
$this->addSql("ALTER TABLE access_url_rel_course ADD COLUMN id INT NOT NULL PRIMARY KEY AUTO_INCREMENT"); |
|
531
|
|
|
$this->addSql("ALTER TABLE access_url_rel_course DROP COLUMN course_code"); |
|
532
|
|
|
$this->addSql("ALTER TABLE access_url_rel_course ADD INDEX idx_select_c (c_id)"); |
|
533
|
|
|
$this->addSql("ALTER TABLE access_url_rel_course ADD INDEX idx_select_u (access_url_id)"); |
|
534
|
|
|
|
|
535
|
|
|
$this->addSql("ALTER TABLE access_url ADD COLUMN url_type TINYINT(1) NULL"); |
|
536
|
|
|
|
|
537
|
|
|
$this->addSql("ALTER TABLE course_rel_user ADD INDEX idx_select_c (c_id)"); |
|
538
|
|
|
|
|
539
|
|
|
$this->addSql("ALTER TABLE track_e_uploads ADD COLUMN c_id INT NOT NULL"); |
|
540
|
|
|
$this->addSql("UPDATE track_e_uploads SET c_id = (SELECT id FROM course WHERE code = upload_cours_id)"); |
|
541
|
|
|
|
|
542
|
|
|
//postUp |
|
543
|
|
|
$this->addSql("ALTER TABLE track_e_access DROP COLUMN access_cours_code"); |
|
544
|
|
|
$this->addSql("ALTER TABLE track_e_default DROP COLUMN default_cours_code"); |
|
545
|
|
|
$this->addSql("ALTER TABLE track_e_lastaccess DROP COLUMN access_cours_code"); |
|
546
|
|
|
$this->addSql("ALTER TABLE track_e_exercices DROP COLUMN exe_cours_id"); |
|
547
|
|
|
$this->addSql("ALTER TABLE track_e_downloads DROP COLUMN down_cours_id"); |
|
548
|
|
|
$this->addSql("ALTER TABLE track_e_hotpotatoes DROP COLUMN exe_cours_id"); |
|
549
|
|
|
$this->addSql("ALTER TABLE track_e_links DROP COLUMN links_cours_id"); |
|
550
|
|
|
$this->addSql("ALTER TABLE track_e_course_access DROP COLUMN course_code"); |
|
551
|
|
|
$this->addSql("ALTER TABLE track_e_online DROP COLUMN course"); |
|
552
|
|
|
$this->addSql("ALTER TABLE track_e_attempt DROP COLUMN course_code"); |
|
553
|
|
|
|
|
554
|
|
|
$this->addSql("ALTER TABLE course_rel_user DROP COLUMN group_id"); |
|
555
|
|
|
$this->addSql("ALTER TABLE course_rel_user DROP COLUMN role"); |
|
556
|
|
|
|
|
557
|
|
|
$this->addSql("DROP TABLE track_c_countries"); |
|
558
|
|
|
$this->addSql("DROP TABLE track_c_browsers"); |
|
559
|
|
|
$this->addSql("DROP TABLE track_c_os"); |
|
560
|
|
|
$this->addSql("DROP TABLE track_c_providers"); |
|
561
|
|
|
$this->addSql("DROP TABLE track_c_referers"); |
|
562
|
|
|
} |
|
563
|
|
|
|
|
564
|
|
|
/** |
|
565
|
|
|
* We don't allow downgrades yet |
|
566
|
|
|
* @param Schema $schema |
|
567
|
|
|
*/ |
|
568
|
|
|
public function down(Schema $schema) |
|
569
|
|
|
{ |
|
570
|
|
|
} |
|
571
|
|
|
} |
|
572
|
|
|
|
chamilo /
chamilo-lms
