chamilo /
chamilo-lms
| Conditions | 46 |
| Total Lines | 556 |
| Code Lines | 323 |
| Lines | 0 |
| Ratio | 0 % |
| Changes | 0 | ||
Small methods make your code easier to understand, in particular if combined with a good name. Besides, if your method is small, finding a good name is usually much easier.
For example, if you find yourself adding comments to a method's body, this is usually a good sign to extract the commented part to a new method, and use the comment as a starting point when coming up with a good name for this new method.
Commonly applied refactorings include:
If many parameters/temporary variables are present:
| 1 | <?php |
||
| 33 | public function up(Schema $schema): void |
||
| 34 | { |
||
| 35 | $this->priorityMigrationHelper->executeUp($schema); |
||
| 36 | |||
| 37 | $this->addSql('set sql_mode=""'); |
||
| 38 | // Optimize bulk operations - see https://dev.mysql.com/doc/refman/5.6/en//optimizing-innodb-bulk-data-loading.html |
||
| 39 | // $this->addSql('set autocommit=0'); |
||
| 40 | $this->addSql('set unique_checks=0'); |
||
| 41 | $this->addSql('set foreign_key_checks=0'); |
||
| 42 | |||
| 43 | // Basic checks. |
||
| 44 | $this->abortIf(!$this->adminExist(), 'Admin not found in the system'); |
||
| 45 | |||
| 46 | $table = $schema->getTable('user'); |
||
| 47 | if (false === $table->hasColumn('uuid')) { |
||
| 48 | $this->addSql("ALTER TABLE user ADD uuid BINARY(16) NOT NULL COMMENT '(DC2Type:uuid)'"); |
||
| 49 | } |
||
| 50 | |||
| 51 | if (false === $schema->hasTable('asset')) { |
||
| 52 | $this->addSql("CREATE TABLE asset (id BINARY(16) NOT NULL COMMENT '(DC2Type:uuid)', title VARCHAR(255) NOT NULL, category VARCHAR(255) NOT NULL, compressed TINYINT(1) NOT NULL, mime_type LONGTEXT DEFAULT NULL, original_name LONGTEXT DEFAULT NULL, dimensions LONGTEXT DEFAULT NULL COMMENT '(DC2Type:simple_array)', size INT NOT NULL, crop VARCHAR(255) DEFAULT NULL, metadata LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)', description LONGTEXT DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC;"); |
||
| 53 | } |
||
| 54 | |||
| 55 | $this->addSql('DELETE FROM track_e_attempt WHERE exe_id IS NULL'); |
||
| 56 | $this->addSql('ALTER TABLE track_e_attempt CHANGE exe_id exe_id INT NOT NULL'); |
||
| 57 | |||
| 58 | $this->addSql('UPDATE branch_transaction_status SET title = "No title" WHERE title IS NULL'); |
||
| 59 | $this->addSql('ALTER TABLE branch_transaction_status CHANGE title title VARCHAR(255) NOT NULL'); |
||
| 60 | |||
| 61 | $this->addSql('UPDATE room SET title = "No title" WHERE title IS NULL'); |
||
| 62 | $this->addSql('ALTER TABLE room CHANGE title title VARCHAR(255) NOT NULL'); |
||
| 63 | |||
| 64 | $this->addSql('UPDATE session_rel_course_rel_user SET legal_agreement = 0 WHERE legal_agreement IS NULL'); |
||
| 65 | $this->addSql('ALTER TABLE session_rel_course_rel_user CHANGE legal_agreement legal_agreement INT NOT NULL'); |
||
| 66 | |||
| 67 | $this->addSql('UPDATE session SET nbr_courses = 0 WHERE nbr_courses IS NULL'); |
||
| 68 | $this->addSql('ALTER TABLE session CHANGE nbr_courses nbr_courses INT NOT NULL'); |
||
| 69 | |||
| 70 | $this->addSql('UPDATE session SET nbr_users = 0 WHERE nbr_users IS NULL'); |
||
| 71 | $this->addSql('ALTER TABLE session CHANGE nbr_users nbr_users INT NOT NULL'); |
||
| 72 | |||
| 73 | $this->addSql('UPDATE session SET nbr_classes = 0 WHERE nbr_classes IS NULL'); |
||
| 74 | $this->addSql('ALTER TABLE session CHANGE nbr_classes nbr_classes INT NOT NULL'); |
||
| 75 | |||
| 76 | $this->addSql('UPDATE user_friend_relation_type SET title = "No title" WHERE title IS NULL'); |
||
| 77 | $this->addSql('ALTER TABLE user_friend_relation_type CHANGE title title VARCHAR(20) NOT NULL'); |
||
| 78 | |||
| 79 | $this->addSql('UPDATE settings_options SET variable = "No variable name" WHERE variable IS NULL'); |
||
| 80 | $this->addSql('ALTER TABLE settings_options CHANGE variable variable VARCHAR(190) NOT NULL'); |
||
| 81 | |||
| 82 | if ($schema->hasTable('mail_template')) { |
||
| 83 | $this->addSql('UPDATE mail_template SET name = "No name" WHERE name IS NULL'); |
||
| 84 | $this->addSql('ALTER TABLE mail_template CHANGE name name VARCHAR(255) NOT NULL'); |
||
| 85 | } |
||
| 86 | |||
| 87 | $this->addSql('UPDATE session_rel_user SET duration = "0" WHERE duration IS NULL'); |
||
| 88 | $this->addSql('ALTER TABLE session_rel_user CHANGE duration duration INT NOT NULL'); |
||
| 89 | |||
| 90 | if ($schema->hasTable('portfolio_category')) { |
||
| 91 | $this->addSql('UPDATE portfolio_category SET title = "No name" WHERE title IS NULL'); |
||
| 92 | $this->addSql('ALTER TABLE portfolio_category CHANGE title title LONGTEXT NOT NULL'); |
||
| 93 | } |
||
| 94 | |||
| 95 | $this->addSql('UPDATE gradebook_linkeval_log SET name = "No name" WHERE name IS NULL'); |
||
| 96 | $this->addSql('ALTER TABLE gradebook_linkeval_log CHANGE name name LONGTEXT NOT NULL'); |
||
| 97 | |||
| 98 | $this->addSql('UPDATE session_category SET name = "No name" WHERE name IS NULL'); |
||
| 99 | $this->addSql('ALTER TABLE session_category CHANGE name name VARCHAR(100) NOT NULL'); |
||
| 100 | |||
| 101 | $this->addSql('UPDATE c_group_info SET name = "No name" WHERE name IS NULL'); |
||
| 102 | $this->addSql('ALTER TABLE c_group_info CHANGE name name VARCHAR(100) NOT NULL'); |
||
| 103 | |||
| 104 | $this->addSql('UPDATE c_group_info SET status = 0 WHERE status IS NULL'); |
||
| 105 | $this->addSql('ALTER TABLE c_group_info CHANGE status status TINYINT(1) NOT NULL'); |
||
| 106 | |||
| 107 | $this->addSql('UPDATE c_quiz_question_option SET name = "No name" WHERE name IS NULL'); |
||
| 108 | $this->addSql('ALTER TABLE c_quiz_question_option CHANGE name name VARCHAR(255) NOT NULL'); |
||
| 109 | |||
| 110 | $this->addSql('UPDATE c_survey SET title = "No title" WHERE title IS NULL'); |
||
| 111 | $this->addSql('ALTER TABLE c_survey CHANGE title title LONGTEXT NOT NULL'); |
||
| 112 | |||
| 113 | $this->addSql('UPDATE c_dropbox_file SET title = "No title" WHERE title IS NULL'); |
||
| 114 | $this->addSql('ALTER TABLE c_dropbox_file CHANGE title title VARCHAR(255) NOT NULL'); |
||
| 115 | |||
| 116 | $this->addSql('UPDATE c_announcement SET title = "No title" WHERE title IS NULL'); |
||
| 117 | $this->addSql('ALTER TABLE c_announcement CHANGE title title LONGTEXT NOT NULL'); |
||
| 118 | |||
| 119 | $this->addSql('UPDATE c_quiz SET hide_question_title = 0 WHERE hide_question_title IS NULL'); |
||
| 120 | $this->addSql('ALTER TABLE c_quiz CHANGE hide_question_title hide_question_title TINYINT(1) NOT NULL'); |
||
| 121 | |||
| 122 | $this->addSql('UPDATE c_link SET title = "No name" WHERE title IS NULL'); |
||
| 123 | $this->addSql('ALTER TABLE c_link CHANGE title title VARCHAR(255) NOT NULL'); |
||
| 124 | |||
| 125 | $this->addSql('UPDATE c_forum_post SET post_title = "No name" WHERE post_title IS NULL'); |
||
| 126 | $this->addSql('ALTER TABLE c_forum_post CHANGE post_title post_title VARCHAR(250) NOT NULL'); |
||
| 127 | |||
| 128 | $this->addSql('UPDATE c_forum_post SET visible = 0 WHERE visible IS NULL'); |
||
| 129 | $this->addSql('ALTER TABLE c_forum_post CHANGE visible visible TINYINT(1) NOT NULL'); |
||
| 130 | |||
| 131 | $this->addSql('UPDATE c_link SET title = "No title" WHERE title IS NULL OR title = "" OR title = "/" '); |
||
| 132 | $this->addSql('ALTER TABLE c_link CHANGE title title VARCHAR(255) NOT NULL'); |
||
| 133 | |||
| 134 | $this->addSql('UPDATE c_document SET title = "No title" WHERE title IS NULL OR title = "" OR title = "/" '); |
||
| 135 | $this->addSql('ALTER TABLE c_document CHANGE title title VARCHAR(255) NOT NULL'); |
||
| 136 | |||
| 137 | $this->addSql('UPDATE c_forum_thread SET thread_title = "No name" WHERE thread_title IS NULL'); |
||
| 138 | $this->addSql('ALTER TABLE c_forum_thread CHANGE thread_title thread_title VARCHAR(255) NOT NULL'); |
||
| 139 | |||
| 140 | $this->addSql('UPDATE c_forum_thread SET thread_sticky = 0 WHERE thread_sticky IS NULL'); |
||
| 141 | $this->addSql('ALTER TABLE c_forum_thread CHANGE thread_sticky thread_sticky TINYINT(1) NOT NULL'); |
||
| 142 | |||
| 143 | $this->addSql('UPDATE ticket_message SET subject = "Ticket #"+ id WHERE subject IS NULL'); |
||
| 144 | $this->addSql('ALTER TABLE ticket_message CHANGE subject subject VARCHAR(255) NOT NULL'); |
||
| 145 | |||
| 146 | $this->addSql('UPDATE settings_current SET variable = "No name" WHERE variable IS NULL'); |
||
| 147 | $this->addSql('ALTER TABLE settings_current CHANGE variable variable VARCHAR(190) NOT NULL;'); |
||
| 148 | |||
| 149 | // Global tool. |
||
| 150 | if (false === $schema->hasTable('tool')) { |
||
| 151 | $this->addSql( |
||
| 152 | 'CREATE TABLE IF NOT EXISTS tool (id INT AUTO_INCREMENT NOT NULL, title VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;' |
||
| 153 | ); |
||
| 154 | $this->addSql('CREATE UNIQUE INDEX UNIQ_20F33ED12B36786B ON tool (title)'); |
||
| 155 | } |
||
| 156 | |||
| 157 | $table = $schema->getTable('language'); |
||
| 158 | if ($table->hasIndex('idx_language_dokeos_folder')) { |
||
| 159 | $this->addSql('DROP INDEX idx_language_dokeos_folder ON language;'); |
||
| 160 | $this->addSql('ALTER TABLE language DROP dokeos_folder;'); |
||
| 161 | } |
||
| 162 | |||
| 163 | // Update language to ISO. |
||
| 164 | $this->addSql('UPDATE language SET isocode = "en" WHERE isocode IS NULL'); |
||
| 165 | $this->addSql('ALTER TABLE language CHANGE isocode isocode VARCHAR(10) NOT NULL'); |
||
| 166 | $this->addSql('UPDATE language SET english_name = "english" WHERE english_name IS NULL'); |
||
| 167 | $this->addSql('ALTER TABLE language CHANGE english_name english_name VARCHAR(255) NOT NULL'); |
||
| 168 | |||
| 169 | $languages = LanguageFixtures::getLanguages(); |
||
| 170 | $languages = array_column($languages, 'isocode', 'english_name'); |
||
| 171 | |||
| 172 | // List of sublanguages to be excluded from updates, except those explicitly allowed. |
||
| 173 | $allowedSubLanguages = ['ast', 'ast_ES', 'ca', 'ca_ES', 'eo', 'gl', 'qu', 'quz_PE', 'qu_PE', 'zh-TW', 'zh_TW', 'pt-BR', 'pt_PT', 'fur', 'fur_IT', 'oc', 'oc_FR']; |
||
| 174 | |||
| 175 | // Selecting languages that are not sublanguages or are explicitly allowed. |
||
| 176 | $sql = "SELECT * FROM language WHERE parent_id IS NULL OR isocode IN ('".implode("', '", $allowedSubLanguages)."')"; |
||
| 177 | $result = $this->connection->executeQuery($sql); |
||
| 178 | $items = $result->fetchAllAssociative(); |
||
| 179 | |||
| 180 | foreach ($items as $item) { |
||
| 181 | $id = $item['id']; |
||
| 182 | $englishName = $item['english_name']; |
||
| 183 | if (isset($languages[$englishName])) { |
||
| 184 | $newIso = $languages[$englishName]; |
||
| 185 | $this->addSql("UPDATE language SET isocode = '$newIso' WHERE id = $id"); |
||
| 186 | } |
||
| 187 | } |
||
| 188 | |||
| 189 | // Specific updates for ISO codes. |
||
| 190 | $this->addSql("UPDATE language SET isocode = 'fr_FR' WHERE isocode = 'fr' AND parent_id IS NULL"); |
||
| 191 | $this->addSql("UPDATE language SET isocode = 'pl_PL' WHERE isocode = 'pl' AND parent_id IS NULL"); |
||
| 192 | $this->addSql("UPDATE language SET isocode = 'qu_PE' WHERE isocode = 'qu'"); |
||
| 193 | $this->addSql("UPDATE sys_announcement SET lang = 'english' WHERE lang IS NULL OR lang = '' "); |
||
| 194 | $this->addSql("UPDATE course SET course_language = 'english' WHERE course_language IS NULL OR course_language = '' "); |
||
| 195 | |||
| 196 | // Update ISO codes based on the English name, excluding non-allowed sublanguages. |
||
| 197 | $this->addSql(" |
||
| 198 | UPDATE course |
||
| 199 | SET course_language = COALESCE(( |
||
| 200 | SELECT isocode |
||
| 201 | FROM language |
||
| 202 | WHERE english_name = course_language |
||
| 203 | AND (parent_id IS NULL OR isocode IN ('".implode("', '", $allowedSubLanguages)."')) |
||
| 204 | ), course_language) |
||
| 205 | "); |
||
| 206 | |||
| 207 | $this->addSql(" |
||
| 208 | UPDATE sys_announcement |
||
| 209 | SET lang = COALESCE(( |
||
| 210 | SELECT isocode |
||
| 211 | FROM language |
||
| 212 | WHERE english_name = lang |
||
| 213 | AND (parent_id IS NULL OR isocode IN ('".implode("', '", $allowedSubLanguages)."')) |
||
| 214 | ), lang) |
||
| 215 | "); |
||
| 216 | |||
| 217 | $this->addSql(" |
||
| 218 | UPDATE settings_current |
||
| 219 | SET selected_value = COALESCE(( |
||
| 220 | SELECT isocode |
||
| 221 | FROM language |
||
| 222 | WHERE english_name = selected_value |
||
| 223 | AND (parent_id IS NULL OR isocode IN ('".implode("', '", $allowedSubLanguages)."')) |
||
| 224 | ), selected_value) |
||
| 225 | WHERE variable = 'platformLanguage' |
||
| 226 | "); |
||
| 227 | |||
| 228 | $table = $schema->getTable('fos_group'); |
||
| 229 | if (false === $table->hasColumn('name')) { |
||
| 230 | $this->addSql( |
||
| 231 | 'ALTER TABLE fos_group ADD name VARCHAR(180) NOT NULL, ADD roles LONGTEXT NOT NULL COMMENT "(DC2Type:array)";' |
||
| 232 | ); |
||
| 233 | $this->addSql('CREATE UNIQUE INDEX UNIQ_4B019DDB5E237E06 ON fos_group (name);'); |
||
| 234 | } |
||
| 235 | $this->addSql('ALTER TABLE fos_group CHANGE name title VARCHAR(255) NOT NULL'); |
||
| 236 | |||
| 237 | $table = $schema->getTable('fos_user_user_group'); |
||
| 238 | if ($table->hasForeignKey('FK_B3C77447A76ED395')) { |
||
| 239 | $this->addSql('ALTER TABLE fos_user_user_group DROP FOREIGN KEY FK_B3C77447A76ED395'); |
||
| 240 | $this->addSql('ALTER TABLE fos_user_user_group ADD CONSTRAINT FK_B3C77447A76ED395 FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE CASCADE'); |
||
| 241 | } else { |
||
| 242 | $this->addSql('ALTER TABLE fos_user_user_group ADD CONSTRAINT FK_B3C77447A76ED395 FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE CASCADE'); |
||
| 243 | } |
||
| 244 | |||
| 245 | $this->addSql('ALTER TABLE course_request CHANGE user_id user_id INT DEFAULT NULL;'); |
||
| 246 | |||
| 247 | $table = $schema->getTable('course_request'); |
||
| 248 | if (false === $table->hasForeignKey('FK_33548A73A76ED395')) { |
||
| 249 | $this->addSql( |
||
| 250 | 'ALTER TABLE course_request ADD CONSTRAINT FK_33548A73A76ED395 FOREIGN KEY (user_id) REFERENCES user (id);' |
||
| 251 | ); |
||
| 252 | $this->addSql('CREATE INDEX IDX_33548A73A76ED395 ON course_request (user_id);'); |
||
| 253 | } |
||
| 254 | |||
| 255 | if ($table->hasColumn('directory')) { |
||
| 256 | $this->addSql('ALTER TABLE course_request DROP directory'); |
||
| 257 | } |
||
| 258 | |||
| 259 | if ($table->hasColumn('db_name')) { |
||
| 260 | $this->addSql('ALTER TABLE course_request DROP db_name'); |
||
| 261 | } |
||
| 262 | |||
| 263 | $this->addSql('ALTER TABLE course_request CHANGE course_language course_language VARCHAR(20) NOT NULL'); |
||
| 264 | $this->addSql('ALTER TABLE course_request CHANGE title title VARCHAR(250) NOT NULL'); |
||
| 265 | |||
| 266 | $table = $schema->getTable('search_engine_ref'); |
||
| 267 | if (false === $table->hasColumn('c_id')) { |
||
| 268 | $this->addSql('ALTER TABLE search_engine_ref ADD c_id INT DEFAULT NULL'); |
||
| 269 | $this->addSql('UPDATE search_engine_ref SET c_id = (SELECT id FROM course WHERE code = course_code)'); |
||
| 270 | $this->addSql('ALTER TABLE search_engine_ref DROP course_code'); |
||
| 271 | $this->addSql( |
||
| 272 | 'ALTER TABLE search_engine_ref ADD CONSTRAINT FK_473F037891D79BD3 FOREIGN KEY (c_id) REFERENCES course (id);' |
||
| 273 | ); |
||
| 274 | $this->addSql('CREATE INDEX IDX_473F037891D79BD3 ON search_engine_ref (c_id);'); |
||
| 275 | } |
||
| 276 | |||
| 277 | $this->addSql('ALTER TABLE hook_observer CHANGE class_name class_name VARCHAR(190) DEFAULT NULL'); |
||
| 278 | $this->addSql('ALTER TABLE hook_event CHANGE class_name class_name VARCHAR(190) DEFAULT NULL;'); |
||
| 279 | $this->addSql('ALTER TABLE sequence_value CHANGE user_id user_id INT DEFAULT NULL'); |
||
| 280 | |||
| 281 | $table = $schema->getTable('sequence_value'); |
||
| 282 | if (false === $table->hasForeignKey('FK_66FBF12DA76ED395')) { |
||
| 283 | $this->addSql( |
||
| 284 | 'ALTER TABLE sequence_value ADD CONSTRAINT FK_66FBF12DA76ED395 FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE CASCADE' |
||
| 285 | ); |
||
| 286 | } |
||
| 287 | |||
| 288 | if (false === $table->hasIndex('IDX_66FBF12DA76ED395')) { |
||
| 289 | $this->addSql('CREATE INDEX IDX_66FBF12DA76ED395 ON sequence_value (user_id)'); |
||
| 290 | } |
||
| 291 | |||
| 292 | $table = $schema->getTable('branch_sync'); |
||
| 293 | $this->addSql('ALTER TABLE branch_sync CHANGE access_url_id access_url_id INT DEFAULT NULL'); |
||
| 294 | if (false === $table->hasForeignKey('FK_F62F45ED73444FD5')) { |
||
| 295 | $this->addSql('ALTER TABLE branch_sync ADD CONSTRAINT FK_F62F45ED73444FD5 FOREIGN KEY (access_url_id) REFERENCES access_url (id)'); |
||
| 296 | } |
||
| 297 | if (false === $table->hasIndex('IDX_F62F45ED73444FD5')) { |
||
| 298 | $this->addSql('CREATE INDEX IDX_F62F45ED73444FD5 ON branch_sync (access_url_id)'); |
||
| 299 | } |
||
| 300 | |||
| 301 | $table = $schema->getTable('personal_agenda'); |
||
| 302 | if ($table->hasColumn('course')) { |
||
| 303 | $this->addSql('ALTER TABLE personal_agenda DROP course'); |
||
| 304 | } |
||
| 305 | |||
| 306 | if (false === $table->hasForeignKey('FK_D86124608D93D649')) { |
||
| 307 | $this->addSql('ALTER TABLE personal_agenda ADD CONSTRAINT FK_D86124608D93D649 FOREIGN KEY (user) REFERENCES user (id) ON DELETE CASCADE'); |
||
| 308 | } |
||
| 309 | |||
| 310 | // Convert user_api_key.api_service to 'default' |
||
| 311 | $table = $schema->getTable('user_api_key'); |
||
| 312 | if ($table->hasColumn('api_service')) { |
||
| 313 | $this->addSql("UPDATE user_api_key SET api_service = 'default' WHERE api_service = 'dokeos'"); |
||
| 314 | } |
||
| 315 | // $this->addSql('ALTER TABLE c_tool_intro CHANGE id tool VARCHAR(255) NOT NULL'); |
||
| 316 | |||
| 317 | /*$table = $schema->getTable('course_rel_class'); |
||
| 318 | if (!$table->hasColumn('c_id')) { |
||
| 319 | $this->addSql("ALTER TABLE course_rel_class ADD c_id int NOT NULL"); |
||
| 320 | } |
||
| 321 | if ($table->hasColumn('course_code')) { |
||
| 322 | $this->addSql(" |
||
| 323 | UPDATE course_rel_class cc |
||
| 324 | SET cc.c_id = (SELECT id FROM course WHERE code = cc.course_code) |
||
| 325 | "); |
||
| 326 | |||
| 327 | $this->addSql("ALTER TABLE course_rel_class DROP course_code"); |
||
| 328 | $this->addSql("ALTER TABLE course_rel_class DROP PRIMARY KEY"); |
||
| 329 | $this->addSql("ALTER TABLE course_rel_class MODIFY COLUMN class_id INT DEFAULT NULL"); |
||
| 330 | $this->addSql("ALTER TABLE course_rel_class ADD PRIMARY KEY (class_id, c_id)"); |
||
| 331 | $this->addSql("ALTER TABLE course_rel_class ADD FOREIGN KEY (c_id) REFERENCES course (id) ON DELETE RESTRICT"); |
||
| 332 | }*/ |
||
| 333 | |||
| 334 | $tables = [ |
||
| 335 | 'shared_survey', |
||
| 336 | 'specific_field_values', |
||
| 337 | 'templates', |
||
| 338 | ]; |
||
| 339 | |||
| 340 | foreach ($tables as $table) { |
||
| 341 | // $tableObj = $schema->getTable($table); |
||
| 342 | /*if (!$tableObj->hasColumn('c_id')) { |
||
| 343 | $this->addSql("ALTER TABLE $table ADD c_id int NOT NULL"); |
||
| 344 | |||
| 345 | if ($tableObj->hasColumn('course_code')) { |
||
| 346 | $this->addSql(" |
||
| 347 | UPDATE $table t |
||
| 348 | SET t.c_id = (SELECT id FROM course WHERE code = t.course_code) |
||
| 349 | "); |
||
| 350 | $this->addSql("ALTER TABLE $table DROP course_code"); |
||
| 351 | } |
||
| 352 | }*/ |
||
| 353 | /*$this->addSql(" |
||
| 354 | ALTER TABLE $table ADD FOREIGN KEY (c_id) REFERENCES course (id) ON DELETE RESTRICT |
||
| 355 | ");*/ |
||
| 356 | } |
||
| 357 | /* |
||
| 358 | $this->addSql("ALTER TABLE personal_agenda DROP course"); |
||
| 359 | |||
| 360 | $this->addSql(" |
||
| 361 | ALTER TABLE specific_field_values |
||
| 362 | ADD c_id int(11) NOT NULL, |
||
| 363 | ADD FOREIGN KEY (c_id) REFERENCES course (id) ON DELETE RESTRICT; |
||
| 364 | "); |
||
| 365 | */ |
||
| 366 | |||
| 367 | // Create tables. |
||
| 368 | $this->addSql( |
||
| 369 | 'CREATE TABLE IF NOT EXISTS scheduled_announcements (id INT AUTO_INCREMENT NOT NULL, subject VARCHAR(255) NOT NULL, message LONGTEXT NOT NULL, date DATETIME DEFAULT NULL, sent TINYINT(1) NOT NULL, session_id INT NOT NULL, c_id INT DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;' |
||
| 370 | ); |
||
| 371 | $this->addSql( |
||
| 372 | 'CREATE TABLE IF NOT EXISTS ext_log_entries (id INT AUTO_INCREMENT NOT NULL, action VARCHAR(8) NOT NULL, logged_at DATETIME NOT NULL, object_id VARCHAR(64) DEFAULT NULL, object_class VARCHAR(191) NOT NULL, version INT NOT NULL, data LONGTEXT DEFAULT NULL COMMENT "(DC2Type:array)", username VARCHAR(191) DEFAULT NULL, INDEX log_class_lookup_idx (object_class), INDEX log_date_lookup_idx (logged_at), INDEX log_user_lookup_idx (username), INDEX log_version_lookup_idx (object_id, object_class, version), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;' |
||
| 373 | ); |
||
| 374 | $this->addSql( |
||
| 375 | 'CREATE TABLE IF NOT EXISTS mail_template (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, template LONGTEXT DEFAULT NULL, type VARCHAR(255) NOT NULL, score DOUBLE PRECISION DEFAULT NULL, result_id INT NOT NULL, default_template TINYINT(1) NOT NULL, `system` INT DEFAULT 0 NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC' |
||
| 376 | ); |
||
| 377 | |||
| 378 | $table = $schema->getTable('usergroup'); |
||
| 379 | if (false === $table->hasColumn('author_id')) { |
||
| 380 | $this->addSql('ALTER TABLE usergroup ADD author_id INT DEFAULT NULL'); |
||
| 381 | } |
||
| 382 | |||
| 383 | if (false === $table->hasColumn('resource_node_id')) { |
||
| 384 | $this->addSql('ALTER TABLE usergroup ADD resource_node_id INT DEFAULT NULL'); |
||
| 385 | } |
||
| 386 | |||
| 387 | // sequence_resource. |
||
| 388 | $table = $schema->getTable('sequence_resource'); |
||
| 389 | |||
| 390 | if ($table->hasForeignKey('FK_34ADA43998FB19AE')) { |
||
| 391 | $this->addSql('ALTER TABLE sequence_resource DROP FOREIGN KEY FK_34ADA43998FB19AE;'); |
||
| 392 | } |
||
| 393 | |||
| 394 | $this->addSql('ALTER TABLE sequence_resource ADD CONSTRAINT FK_34ADA43998FB19AE FOREIGN KEY (sequence_id) REFERENCES sequence (id) ON DELETE CASCADE'); |
||
| 395 | |||
| 396 | // Update template. |
||
| 397 | $table = $schema->getTable('templates'); |
||
| 398 | if ($table->hasColumn('course_code')) { |
||
| 399 | $this->addSql('DELETE FROM templates WHERE course_code NOT IN (SELECT code FROM course)'); |
||
| 400 | } |
||
| 401 | if (false === $table->hasColumn('c_id')) { |
||
| 402 | $this->addSql('ALTER TABLE templates ADD c_id INT DEFAULT NULL'); |
||
| 403 | $this->addSql('CREATE INDEX IDX_6F287D8E91D79BD3 ON templates (c_id)'); |
||
| 404 | $this->addSql( |
||
| 405 | 'ALTER TABLE templates ADD CONSTRAINT FK_6F287D8E91D79BD3 FOREIGN KEY (c_id) REFERENCES course (id)' |
||
| 406 | ); |
||
| 407 | $this->addSql('UPDATE templates SET c_id = (SELECT id FROM course WHERE code = course_code)'); |
||
| 408 | } |
||
| 409 | $this->addSql('ALTER TABLE templates CHANGE user_id user_id INT DEFAULT NULL'); |
||
| 410 | |||
| 411 | if (false === $table->hasIndex('IDX_6F287D8EA76ED395')) { |
||
| 412 | $this->addSql('CREATE INDEX IDX_6F287D8EA76ED395 ON templates (user_id)'); |
||
| 413 | } |
||
| 414 | if (false === $table->hasForeignKey('FK_6F287D8EA76ED395')) { |
||
| 415 | $this->addSql('ALTER TABLE templates ADD CONSTRAINT FK_6F287D8EA76ED395 FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE CASCADE'); |
||
| 416 | } |
||
| 417 | |||
| 418 | // Rename extra_field field_type and extra_field_type to item_type and value_type, also, the term "value" in exta_field_values.value renamed to field_value |
||
| 419 | $table = $schema->getTable('extra_field'); |
||
| 420 | if ($table->hasColumn('extra_field_type')) { |
||
| 421 | $this->addSql('ALTER TABLE extra_field CHANGE extra_field_type item_type INT NOT NULL'); |
||
| 422 | } |
||
| 423 | if ($table->hasColumn('field_type')) { |
||
| 424 | $this->addSql('ALTER TABLE extra_field CHANGE field_type value_type INT NOT NULL'); |
||
| 425 | } |
||
| 426 | $table = $schema->getTable('extra_field_values'); |
||
| 427 | if ($table->hasColumn('value')) { |
||
| 428 | $this->addSql('ALTER TABLE extra_field_values CHANGE `value` field_value LONGTEXT DEFAULT NULL'); |
||
| 429 | } |
||
| 430 | |||
| 431 | // Drop unused columns |
||
| 432 | $dropColumnsAndIndex = [ |
||
| 433 | 'track_e_uploads' => [ |
||
| 434 | 'columns' => ['upload_cours_id'], |
||
| 435 | 'index' => ['upload_cours_id'], |
||
| 436 | ], |
||
| 437 | 'track_e_hotspot' => [ |
||
| 438 | 'columns' => ['hotspot_course_code'], |
||
| 439 | 'index' => ['hotspot_course_code'], |
||
| 440 | ], |
||
| 441 | 'templates' => [ |
||
| 442 | 'columns' => ['course_code'], |
||
| 443 | 'index' => [], |
||
| 444 | ], |
||
| 445 | 'personal_agenda' => [ |
||
| 446 | 'columns' => ['hotspot_course_code'], |
||
| 447 | 'index' => [], |
||
| 448 | ], |
||
| 449 | 'c_item_property' => [ |
||
| 450 | 'fks' => [ |
||
| 451 | 'FK_1D84C18129F6EE60', |
||
| 452 | 'FK_1D84C181330D47E9', |
||
| 453 | 'FK_1D84C181613FECDF', |
||
| 454 | 'FK_1D84C18191D79BD3', |
||
| 455 | 'FK_1D84C1819C859CC3', |
||
| 456 | ], |
||
| 457 | ], |
||
| 458 | ]; |
||
| 459 | |||
| 460 | foreach ($dropColumnsAndIndex as $tableName => $data) { |
||
| 461 | if ($schema->hasTable($tableName)) { |
||
| 462 | $table = $schema->getTable($tableName); |
||
| 463 | |||
| 464 | $indexList = $data['index'] ?? []; |
||
| 465 | foreach ($indexList as $index) { |
||
| 466 | if ($table->hasIndex($index)) { |
||
| 467 | $table->dropIndex($index); |
||
| 468 | } |
||
| 469 | } |
||
| 470 | |||
| 471 | $columns = $data['columns'] ?? []; |
||
| 472 | foreach ($columns as $column) { |
||
| 473 | if ($table->hasColumn($column)) { |
||
| 474 | $table->dropColumn($column); |
||
| 475 | } |
||
| 476 | } |
||
| 477 | |||
| 478 | $fks = $data['fks'] ?? []; |
||
| 479 | foreach ($fks as $fk) { |
||
| 480 | if ($table->hasForeignKey($fk)) { |
||
| 481 | $table->removeForeignKey($fk); |
||
| 482 | } |
||
| 483 | } |
||
| 484 | } |
||
| 485 | } |
||
| 486 | |||
| 487 | // Drop unused tables. |
||
| 488 | $dropTables = [ |
||
| 489 | 'event_email_template', |
||
| 490 | 'event_sent', |
||
| 491 | 'user_rel_event_type', |
||
| 492 | 'openid_association', |
||
| 493 | 'track_stored_values', |
||
| 494 | 'track_stored_values_stack', |
||
| 495 | 'course_module', |
||
| 496 | 'c_resource', |
||
| 497 | 'track_e_item_property', |
||
| 498 | ]; |
||
| 499 | |||
| 500 | foreach ($dropTables as $table) { |
||
| 501 | if ($schema->hasTable($table)) { |
||
| 502 | $schema->dropTable($table); |
||
| 503 | } |
||
| 504 | } |
||
| 505 | |||
| 506 | // Disable c_id and session_id. |
||
| 507 | $tables = [ |
||
| 508 | 'c_announcement' => ['c_id', 'session_id'], |
||
| 509 | 'c_announcement_attachment' => ['c_id'], |
||
| 510 | 'c_attendance' => ['c_id', 'session_id'], |
||
| 511 | 'c_attendance_calendar' => ['c_id'], |
||
| 512 | 'c_attendance_calendar_rel_group' => ['c_id', 'group_id'], |
||
| 513 | 'c_attendance_result' => ['c_id'], |
||
| 514 | 'c_attendance_sheet' => ['c_id'], |
||
| 515 | 'c_attendance_sheet_log' => ['c_id'], |
||
| 516 | 'c_calendar_event' => ['c_id', 'session_id'], |
||
| 517 | 'c_calendar_event_attachment' => ['c_id'], |
||
| 518 | 'c_calendar_event_repeat' => ['c_id'], |
||
| 519 | 'c_calendar_event_repeat_not' => ['c_id'], |
||
| 520 | 'c_course_description' => ['c_id', 'session_id'], |
||
| 521 | 'c_document' => ['c_id', 'session_id'], |
||
| 522 | 'c_forum_attachment' => ['c_id'], |
||
| 523 | 'c_forum_category' => ['c_id', 'session_id', 'cat_id'], |
||
| 524 | 'c_forum_forum' => ['c_id', 'session_id', 'post_id'], |
||
| 525 | 'c_forum_notification' => ['c_id'], |
||
| 526 | 'c_forum_post' => ['c_id', 'post_id'], |
||
| 527 | 'c_forum_thread' => ['c_id', 'session_id'], |
||
| 528 | 'c_forum_thread_qualify' => ['c_id', 'session_id'], |
||
| 529 | 'c_forum_thread_qualify_log' => ['c_id', 'session_id'], |
||
| 530 | 'c_glossary' => ['c_id', 'session_id', 'glossary_id'], |
||
| 531 | 'c_group_category' => ['c_id'], |
||
| 532 | 'c_group_info' => ['c_id', 'session_id'], |
||
| 533 | // 'c_group_rel_tutor' => ['c_id'], |
||
| 534 | 'c_link' => ['c_id', 'session_id'], |
||
| 535 | 'c_link_category' => ['c_id', 'session_id'], |
||
| 536 | |||
| 537 | 'c_lp' => ['c_id', 'session_id'], |
||
| 538 | 'c_lp_category' => ['c_id'], |
||
| 539 | 'c_lp_item' => ['c_id'], |
||
| 540 | 'c_lp_item_view' => ['c_id', 'session_id'], |
||
| 541 | // 'c_lp_iv_interaction' => ['c_id'], |
||
| 542 | // 'c_lp_iv_objective' => ['c_id'], |
||
| 543 | 'c_notebook' => ['c_id', 'session_id'], |
||
| 544 | 'c_quiz' => ['c_id', 'session_id'], |
||
| 545 | 'c_quiz_answer' => ['c_id'], |
||
| 546 | 'c_quiz_question' => ['c_id'], |
||
| 547 | 'c_quiz_question_category' => ['c_id'], |
||
| 548 | 'c_quiz_question_option' => ['c_id'], |
||
| 549 | 'c_quiz_question_rel_category' => ['c_id'], |
||
| 550 | 'c_quiz_rel_category' => ['c_id'], |
||
| 551 | 'c_quiz_rel_question' => ['c_id'], |
||
| 552 | 'c_student_publication' => ['c_id', 'session_id'], |
||
| 553 | 'c_student_publication_assignment' => ['c_id'], |
||
| 554 | 'c_student_publication_comment' => ['c_id'], |
||
| 555 | 'c_student_publication_rel_document' => ['c_id'], |
||
| 556 | 'c_student_publication_rel_user' => ['c_id'], |
||
| 557 | 'c_survey' => ['c_id', 'session_id', 'survey_id'], |
||
| 558 | 'c_survey_answer' => ['c_id', 'answer_id'], |
||
| 559 | 'c_survey_group' => ['c_id'], |
||
| 560 | 'c_survey_invitation' => [ |
||
| 561 | 'c_id', |
||
| 562 | 'session_id', |
||
| 563 | 'group_id', |
||
| 564 | 'survey_invitation_id', |
||
| 565 | 'survey_group_sec1', |
||
| 566 | 'survey_group_sec2', |
||
| 567 | ], |
||
| 568 | 'c_survey_question' => ['c_id', 'question_id', 'survey_group_pri'], |
||
| 569 | 'c_survey_question_option' => ['c_id', 'question_option_id'], |
||
| 570 | 'c_thematic' => ['c_id', 'session_id'], |
||
| 571 | 'c_thematic_advance' => ['c_id'], |
||
| 572 | 'c_thematic_plan' => ['c_id'], |
||
| 573 | 'c_tool' => ['c_id', 'session_id'], |
||
| 574 | 'c_tool_intro' => ['c_id', 'session_id'], |
||
| 575 | 'c_wiki' => ['c_id', 'session_id'], |
||
| 576 | |||
| 577 | // core tables |
||
| 578 | |||
| 579 | 'message' => ['user_receiver_id'], |
||
| 580 | ]; |
||
| 581 | |||
| 582 | $this->addSql('ALTER TABLE c_survey_invitation CHANGE survey_code survey_code VARCHAR(20) DEFAULT NULL'); |
||
| 583 | |||
| 584 | foreach ($tables as $tableName => $fields) { |
||
| 585 | $table = $schema->getTable($tableName); |
||
| 586 | foreach ($fields as $field) { |
||
| 587 | if ($table->hasColumn($field)) { |
||
| 588 | $this->addSql("ALTER TABLE $tableName CHANGE $field $field INT DEFAULT NULL"); |
||
| 589 | } |
||
| 599 |
