chamilo /
chamilo-lms
| Total Complexity | 44 |
| Total Lines | 729 |
| Duplicated Lines | 0 % |
| Changes | 0 | ||
Complex classes like Version20 often do a lot of different things. To break such a class down, we need to identify a cohesive component within that class. A common approach to find such a component is to look for fields/methods that share the same prefixes, or suffixes.
Once you have determined the fields that belong together, you can apply the Extract Class refactoring. If the component makes sense as a sub-class, Extract Subclass is also a candidate, and is often faster.
While breaking up the class, it is a good idea to analyze how other classes use Version20, and based on these observations, apply Extract Interface, too.
| 1 | <?php |
||
| 15 | class Version20 extends AbstractMigrationChamilo |
||
| 16 | { |
||
| 17 | /** |
||
| 18 | * @param Schema $schema |
||
| 19 | */ |
||
| 20 | public function up(Schema $schema) |
||
| 21 | { |
||
| 22 | // Use $schema->createTable |
||
| 23 | $this->addSql('set sql_mode=""'); |
||
| 24 | $this->addSql('ALTER TABLE access_url_rel_user MODIFY COLUMN access_url_id INT NOT NULL'); |
||
| 25 | $this->addSql('ALTER TABLE access_url_rel_user MODIFY COLUMN user_id INT NOT NULL'); |
||
| 26 | |||
| 27 | $this->addSql('ALTER TABLE access_url_rel_user DROP PRIMARY KEY'); |
||
| 28 | $this->addSql('ALTER TABLE access_url_rel_session DROP PRIMARY KEY'); |
||
| 29 | |||
| 30 | $this->addSql('CREATE TABLE IF NOT EXISTS page__page (id INT AUTO_INCREMENT NOT NULL, site_id INT DEFAULT NULL, parent_id INT DEFAULT NULL, target_id INT DEFAULT NULL, route_name VARCHAR(255) NOT NULL, page_alias VARCHAR(255) DEFAULT NULL, type VARCHAR(255) DEFAULT NULL, position INT NOT NULL, enabled TINYINT(1) NOT NULL, decorate TINYINT(1) NOT NULL, edited TINYINT(1) NOT NULL, name VARCHAR(255) NOT NULL, slug LONGTEXT DEFAULT NULL, url LONGTEXT DEFAULT NULL, custom_url LONGTEXT DEFAULT NULL, request_method VARCHAR(255) DEFAULT NULL, title VARCHAR(255) DEFAULT NULL, meta_keyword VARCHAR(255) DEFAULT NULL, meta_description VARCHAR(255) DEFAULT NULL, javascript LONGTEXT DEFAULT NULL, stylesheet LONGTEXT DEFAULT NULL, raw_headers LONGTEXT DEFAULT NULL, template VARCHAR(255) NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX IDX_2FAE39EDF6BD1646 (site_id), INDEX IDX_2FAE39ED727ACA70 (parent_id), INDEX IDX_2FAE39ED158E0B66 (target_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;'); |
||
| 31 | $this->addSql('CREATE TABLE IF NOT EXISTS page__site (id INT AUTO_INCREMENT NOT NULL, enabled TINYINT(1) NOT NULL, name VARCHAR(255) NOT NULL, relative_path VARCHAR(255) DEFAULT NULL, host VARCHAR(255) NOT NULL, enabled_from DATETIME DEFAULT NULL, enabled_to DATETIME DEFAULT NULL, is_default TINYINT(1) NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, locale VARCHAR(7) DEFAULT NULL, title VARCHAR(64) DEFAULT NULL, meta_keywords VARCHAR(255) DEFAULT NULL, meta_description VARCHAR(255) DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB'); |
||
| 32 | $this->addSql('CREATE TABLE IF NOT EXISTS page__snapshot (id INT AUTO_INCREMENT NOT NULL, site_id INT DEFAULT NULL, page_id INT DEFAULT NULL, route_name VARCHAR(255) NOT NULL, page_alias VARCHAR(255) DEFAULT NULL, type VARCHAR(255) DEFAULT NULL, position INT NOT NULL, enabled TINYINT(1) NOT NULL, decorate TINYINT(1) NOT NULL, name VARCHAR(255) NOT NULL, url LONGTEXT DEFAULT NULL, parent_id INT DEFAULT NULL, target_id INT DEFAULT NULL, content LONGTEXT DEFAULT NULL COMMENT "(DC2Type:json)", publication_date_start DATETIME DEFAULT NULL, publication_date_end DATETIME DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX IDX_3963EF9AF6BD1646 (site_id), INDEX IDX_3963EF9AC4663E4 (page_id), INDEX idx_snapshot_dates_enabled (publication_date_start, publication_date_end, enabled), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;'); |
||
| 33 | $this->addSql('CREATE TABLE IF NOT EXISTS page__bloc (id INT AUTO_INCREMENT NOT NULL, parent_id INT DEFAULT NULL, page_id INT DEFAULT NULL, name VARCHAR(255) DEFAULT NULL, type VARCHAR(64) NOT NULL, settings LONGTEXT NOT NULL COMMENT "(DC2Type:json)", enabled TINYINT(1) DEFAULT NULL, position INT DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX IDX_FCDC1A97727ACA70 (parent_id), INDEX IDX_FCDC1A97C4663E4 (page_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;'); |
||
| 34 | $this->addSql('CREATE TABLE IF NOT EXISTS timeline__timeline (id INT AUTO_INCREMENT NOT NULL, action_id INT DEFAULT NULL, subject_id INT DEFAULT NULL, context VARCHAR(255) NOT NULL, type VARCHAR(255) NOT NULL, created_at DATETIME NOT NULL, INDEX IDX_FFBC6AD59D32F035 (action_id), INDEX IDX_FFBC6AD523EDC87 (subject_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;'); |
||
| 35 | $this->addSql('CREATE TABLE IF NOT EXISTS timeline__component (id INT AUTO_INCREMENT NOT NULL, model VARCHAR(255) NOT NULL, identifier LONGTEXT NOT NULL COMMENT "(DC2Type:array)", hash VARCHAR(190) NOT NULL, UNIQUE INDEX UNIQ_1B2F01CDD1B862B8 (hash), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;'); |
||
| 36 | $this->addSql('CREATE TABLE IF NOT EXISTS timeline__action (id INT AUTO_INCREMENT NOT NULL, verb VARCHAR(255) NOT NULL, status_current VARCHAR(255) NOT NULL, status_wanted VARCHAR(255) NOT NULL, duplicate_key VARCHAR(255) DEFAULT NULL, duplicate_priority INT DEFAULT NULL, created_at DATETIME NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;'); |
||
| 37 | $this->addSql('CREATE TABLE IF NOT EXISTS timeline__action_component (id INT AUTO_INCREMENT NOT NULL, action_id INT DEFAULT NULL, component_id INT DEFAULT NULL, type VARCHAR(255) NOT NULL, text VARCHAR(255) DEFAULT NULL, INDEX IDX_6ACD1B169D32F035 (action_id), INDEX IDX_6ACD1B16E2ABAFFF (component_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;'); |
||
| 38 | $this->addSql('CREATE TABLE IF NOT EXISTS classification__tag (id INT AUTO_INCREMENT NOT NULL, context INT DEFAULT NULL, name VARCHAR(255) NOT NULL, enabled TINYINT(1) NOT NULL, slug VARCHAR(190) NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX IDX_CA57A1C7E25D857E (context), UNIQUE INDEX tag_context (slug, context), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;'); |
||
| 39 | $this->addSql('CREATE TABLE IF NOT EXISTS classification__collection (id INT AUTO_INCREMENT NOT NULL, context INT DEFAULT NULL, media_id INT DEFAULT NULL, name VARCHAR(255) NOT NULL, enabled TINYINT(1) NOT NULL, slug VARCHAR(190) NOT NULL, description VARCHAR(255) DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX IDX_A406B56AE25D857E (context), INDEX IDX_A406B56AEA9FDD75 (media_id), UNIQUE INDEX tag_collection (slug, context), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;'); |
||
| 40 | $this->addSql('CREATE UNIQUE INDEX UNIQ_A406B56A989D9B62 ON classification__collection (slug)'); |
||
| 41 | $this->addSql('CREATE TABLE IF NOT EXISTS classification__context (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, enabled TINYINT(1) NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;'); |
||
| 42 | $this->addSql('CREATE TABLE IF NOT EXISTS classification__category (id INT AUTO_INCREMENT NOT NULL, parent_id INT DEFAULT NULL, context INT DEFAULT NULL, media_id INT DEFAULT NULL, name VARCHAR(255) NOT NULL, enabled TINYINT(1) NOT NULL, slug VARCHAR(255) NOT NULL, description VARCHAR(255) DEFAULT NULL, position INT DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX IDX_43629B36727ACA70 (parent_id), INDEX IDX_43629B36E25D857E (context), INDEX IDX_43629B36EA9FDD75 (media_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;'); |
||
| 43 | $this->addSql('CREATE TABLE IF NOT EXISTS media__gallery_media (id INT AUTO_INCREMENT NOT NULL, gallery_id INT DEFAULT NULL, media_id INT DEFAULT NULL, position INT NOT NULL, enabled TINYINT(1) NOT NULL, updated_at DATETIME NOT NULL, created_at DATETIME NOT NULL, INDEX IDX_80D4C5414E7AF8F (gallery_id), INDEX IDX_80D4C541EA9FDD75 (media_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;'); |
||
| 44 | $this->addSql('CREATE TABLE IF NOT EXISTS media__gallery (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, context VARCHAR(64) NOT NULL, default_format VARCHAR(255) NOT NULL, enabled TINYINT(1) NOT NULL, updated_at DATETIME NOT NULL, created_at DATETIME NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;'); |
||
| 45 | $this->addSql('CREATE TABLE IF NOT EXISTS media__media (id INT AUTO_INCREMENT NOT NULL, category_id INT DEFAULT NULL, name VARCHAR(255) NOT NULL, description TEXT DEFAULT NULL, enabled TINYINT(1) NOT NULL, provider_name VARCHAR(255) NOT NULL, provider_status INT NOT NULL, provider_reference VARCHAR(255) NOT NULL, provider_metadata LONGTEXT DEFAULT NULL COMMENT \'(DC2Type:json)\', width INT DEFAULT NULL, height INT DEFAULT NULL, length NUMERIC(10, 0) DEFAULT NULL, content_type VARCHAR(255) DEFAULT NULL, content_size INT DEFAULT NULL, copyright VARCHAR(255) DEFAULT NULL, author_name VARCHAR(255) DEFAULT NULL, context VARCHAR(64) DEFAULT NULL, cdn_is_flushable TINYINT(1) DEFAULT NULL, cdn_flush_identifier VARCHAR(64) DEFAULT NULL, cdn_flush_at DATETIME DEFAULT NULL, cdn_status INT DEFAULT NULL, updated_at DATETIME NOT NULL, created_at DATETIME NOT NULL, INDEX IDX_5C6DD74E12469DE2 (category_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;'); |
||
| 46 | $this->addSql('CREATE TABLE IF NOT EXISTS faq_question_translation (id INT AUTO_INCREMENT NOT NULL, translatable_id INT DEFAULT NULL, headline VARCHAR(255) NOT NULL, body LONGTEXT DEFAULT NULL, slug VARCHAR(50) NOT NULL, locale VARCHAR(190) NOT NULL, INDEX IDX_C2D1A2C2AC5D3 (translatable_id), UNIQUE INDEX faq_question_translation_unique_translation (translatable_id, locale), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;'); |
||
| 47 | $this->addSql('CREATE TABLE IF NOT EXISTS faq_category_translation (id INT AUTO_INCREMENT NOT NULL, translatable_id INT DEFAULT NULL, headline VARCHAR(255) NOT NULL, body LONGTEXT DEFAULT NULL, slug VARCHAR(50) NOT NULL, locale VARCHAR(190) NOT NULL, INDEX IDX_5493B0FC2C2AC5D3 (translatable_id), UNIQUE INDEX faq_category_translation_unique_translation (translatable_id, locale), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;'); |
||
| 48 | $this->addSql('CREATE TABLE IF NOT EXISTS faq_category (id INT AUTO_INCREMENT NOT NULL, rank INT NOT NULL, is_active TINYINT(1) NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX is_active_idx (is_active), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;'); |
||
| 49 | $this->addSql('CREATE TABLE IF NOT EXISTS faq_question (id INT AUTO_INCREMENT NOT NULL, category_id INT DEFAULT NULL, rank INT NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, only_auth_users TINYINT(1) NOT NULL, is_active TINYINT(1) NOT NULL, INDEX IDX_4A55B05912469DE2 (category_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;'); |
||
| 50 | $this->addSql('CREATE TABLE IF NOT EXISTS contact_category_translation (id INT AUTO_INCREMENT NOT NULL, translatable_id INT DEFAULT NULL, name VARCHAR(255) NOT NULL, locale VARCHAR(190) NOT NULL, INDEX IDX_3E770F302C2AC5D3 (translatable_id), UNIQUE INDEX contact_category_translation_unique_translation (translatable_id, locale), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;'); |
||
| 51 | $this->addSql('CREATE TABLE IF NOT EXISTS contact_category (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, email VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;'); |
||
| 52 | $this->addSql('ALTER TABLE page__bloc ADD CONSTRAINT FK_FCDC1A97727ACA70 FOREIGN KEY (parent_id) REFERENCES page__bloc (id) ON DELETE CASCADE;'); |
||
| 53 | $this->addSql('ALTER TABLE page__bloc ADD CONSTRAINT FK_FCDC1A97C4663E4 FOREIGN KEY (page_id) REFERENCES page__page (id) ON DELETE CASCADE;'); |
||
| 54 | $this->addSql('ALTER TABLE timeline__timeline ADD CONSTRAINT FK_FFBC6AD59D32F035 FOREIGN KEY (action_id) REFERENCES timeline__action (id);'); |
||
| 55 | $this->addSql('ALTER TABLE timeline__timeline ADD CONSTRAINT FK_FFBC6AD523EDC87 FOREIGN KEY (subject_id) REFERENCES timeline__component (id) ON DELETE CASCADE;'); |
||
| 56 | |||
| 57 | $this->addSql('CREATE INDEX context_idx ON timeline__timeline (context)'); |
||
| 58 | $this->addSql('CREATE INDEX type_idx ON timeline__timeline (type)'); |
||
| 59 | |||
| 60 | $this->addSql('ALTER TABLE timeline__action_component ADD CONSTRAINT FK_6ACD1B169D32F035 FOREIGN KEY (action_id) REFERENCES timeline__action (id) ON DELETE CASCADE;'); |
||
| 61 | $this->addSql('ALTER TABLE timeline__action_component ADD CONSTRAINT FK_6ACD1B16E2ABAFFF FOREIGN KEY (component_id) REFERENCES timeline__component (id) ON DELETE CASCADE;'); |
||
| 62 | $this->addSql('ALTER TABLE classification__tag ADD CONSTRAINT FK_CA57A1C7E25D857E FOREIGN KEY (context) REFERENCES classification__context (id);'); |
||
| 63 | $this->addSql('CREATE UNIQUE INDEX UNIQ_CA57A1C7989D9B62 ON classification__tag (slug)'); |
||
| 64 | |||
| 65 | $this->addSql('ALTER TABLE classification__collection ADD CONSTRAINT FK_A406B56AE25D857E FOREIGN KEY (context) REFERENCES classification__context (id);'); |
||
| 66 | $this->addSql('ALTER TABLE classification__collection ADD CONSTRAINT FK_A406B56AEA9FDD75 FOREIGN KEY (media_id) REFERENCES media__media (id) ON DELETE SET NULL;'); |
||
| 67 | $this->addSql('ALTER TABLE classification__category ADD CONSTRAINT FK_43629B36727ACA70 FOREIGN KEY (parent_id) REFERENCES classification__category (id) ON DELETE CASCADE;'); |
||
| 68 | $this->addSql('ALTER TABLE classification__category ADD CONSTRAINT FK_43629B36E25D857E FOREIGN KEY (context) REFERENCES classification__context (id);'); |
||
| 69 | $this->addSql('ALTER TABLE classification__category ADD CONSTRAINT FK_43629B36EA9FDD75 FOREIGN KEY (media_id) REFERENCES media__media (id) ON DELETE SET NULL;'); |
||
| 70 | |||
| 71 | $this->addSql('ALTER TABLE media__gallery_media ADD CONSTRAINT FK_80D4C5414E7AF8F FOREIGN KEY (gallery_id) REFERENCES media__gallery (id) ON DELETE CASCADE'); |
||
| 72 | $this->addSql('ALTER TABLE media__gallery_media ADD CONSTRAINT FK_80D4C541EA9FDD75 FOREIGN KEY (media_id) REFERENCES media__media (id) ON DELETE CASCADE;'); |
||
| 73 | |||
| 74 | |||
| 75 | $this->addSql('ALTER TABLE media__media ADD CONSTRAINT FK_5C6DD74E12469DE2 FOREIGN KEY (category_id) REFERENCES classification__category (id) ON DELETE SET NULL;'); |
||
| 76 | |||
| 77 | $this->addSql('ALTER TABLE faq_question_translation ADD CONSTRAINT FK_C2D1A2C2AC5D3 FOREIGN KEY (translatable_id) REFERENCES faq_question (id) ON DELETE CASCADE;'); |
||
| 78 | $this->addSql('ALTER TABLE faq_category_translation ADD CONSTRAINT FK_5493B0FC2C2AC5D3 FOREIGN KEY (translatable_id) REFERENCES faq_category (id) ON DELETE CASCADE;'); |
||
| 79 | $this->addSql('ALTER TABLE faq_question ADD CONSTRAINT FK_4A55B05912469DE2 FOREIGN KEY (category_id) REFERENCES faq_category (id);'); |
||
| 80 | $this->addSql('ALTER TABLE contact_category_translation ADD CONSTRAINT FK_3E770F302C2AC5D3 FOREIGN KEY (translatable_id) REFERENCES contact_category (id) ON DELETE CASCADE;'); |
||
| 81 | $this->addSql('ALTER TABLE page__page ADD CONSTRAINT FK_2FAE39EDF6BD1646 FOREIGN KEY (site_id) REFERENCES page__site (id) ON DELETE CASCADE;'); |
||
| 82 | $this->addSql('ALTER TABLE page__page ADD CONSTRAINT FK_2FAE39ED727ACA70 FOREIGN KEY (parent_id) REFERENCES page__page (id) ON DELETE CASCADE;'); |
||
| 83 | $this->addSql('ALTER TABLE page__page ADD CONSTRAINT FK_2FAE39ED158E0B66 FOREIGN KEY (target_id) REFERENCES page__page (id) ON DELETE CASCADE;'); |
||
| 84 | $this->addSql('ALTER TABLE page__snapshot ADD CONSTRAINT FK_3963EF9AF6BD1646 FOREIGN KEY (site_id) REFERENCES page__site (id) ON DELETE CASCADE;'); |
||
| 85 | $this->addSql('ALTER TABLE page__snapshot ADD CONSTRAINT FK_3963EF9AC4663E4 FOREIGN KEY (page_id) REFERENCES page__page (id) ON DELETE CASCADE;'); |
||
| 86 | |||
| 87 | $this->addSql('ALTER TABLE fos_group ADD name VARCHAR(180) NOT NULL, ADD roles LONGTEXT NOT NULL COMMENT "(DC2Type:array)";'); |
||
| 88 | $this->addSql('CREATE UNIQUE INDEX UNIQ_4B019DDB5E237E06 ON fos_group (name);'); |
||
| 89 | |||
| 90 | $this->addSql('ALTER TABLE gradebook_evaluation ADD c_id INT DEFAULT NULL'); |
||
| 91 | $this->addSql("UPDATE gradebook_evaluation SET c_id = (SELECT id FROM course WHERE code = course_code)"); |
||
| 92 | $this->addSql('ALTER TABLE gradebook_evaluation DROP course_code'); |
||
| 93 | $this->addSql('ALTER TABLE gradebook_evaluation ADD CONSTRAINT FK_DDDED80491D79BD3 FOREIGN KEY (c_id) REFERENCES course (id);'); |
||
| 94 | $this->addSql('CREATE INDEX IDX_DDDED80491D79BD3 ON gradebook_evaluation (c_id)'); |
||
| 95 | //$this->addSql('ALTER TABLE gradebook_evaluation RENAME INDEX fk_ddded80491d79bd3 TO IDX_DDDED80491D79BD3;'); |
||
| 96 | |||
| 97 | $this->addSql('ALTER TABLE gradebook_category ADD c_id INT DEFAULT NULL'); |
||
| 98 | $this->addSql('UPDATE gradebook_category SET c_id = (SELECT id FROM course WHERE code = course_code)'); |
||
| 99 | $this->addSql('ALTER TABLE gradebook_category DROP course_code'); |
||
| 100 | |||
| 101 | $this->addSql('ALTER TABLE gradebook_category ADD CONSTRAINT FK_96A4C70591D79BD3 FOREIGN KEY (c_id) REFERENCES course (id);'); |
||
| 102 | $this->addSql('CREATE INDEX IDX_96A4C70591D79BD3 ON gradebook_category (c_id);'); |
||
| 103 | |||
| 104 | $this->addSql('ALTER TABLE gradebook_link ADD c_id INT DEFAULT NULL'); |
||
| 105 | $this->addSql('UPDATE gradebook_link SET c_id = (SELECT id FROM course WHERE code = course_code)'); |
||
| 106 | $this->addSql('ALTER TABLE gradebook_link DROP course_code'); |
||
| 107 | $this->addSql('ALTER TABLE gradebook_link ADD CONSTRAINT FK_4F0F595F91D79BD3 FOREIGN KEY (c_id) REFERENCES course (id);'); |
||
| 108 | $this->addSql('CREATE INDEX IDX_4F0F595F91D79BD3 ON gradebook_link (c_id);'); |
||
| 109 | |||
| 110 | $this->addSql('ALTER TABLE access_url_rel_user ADD id INT AUTO_INCREMENT NOT NULL, CHANGE access_url_id access_url_id INT DEFAULT NULL, CHANGE user_id user_id INT DEFAULT NULL, ADD PRIMARY KEY (id);'); |
||
| 111 | $this->addSql('ALTER TABLE access_url ADD limit_courses INT DEFAULT NULL, ADD limit_active_courses INT DEFAULT NULL, ADD limit_sessions INT DEFAULT NULL, ADD limit_users INT DEFAULT NULL, ADD limit_teachers INT DEFAULT NULL, ADD limit_disk_space INT DEFAULT NULL, ADD email VARCHAR(255) DEFAULT NULL;'); |
||
| 112 | |||
| 113 | $this->addSql('ALTER TABLE course_request CHANGE user_id user_id INT DEFAULT NULL;'); |
||
| 114 | $this->addSql('ALTER TABLE course_request ADD CONSTRAINT FK_33548A73A76ED395 FOREIGN KEY (user_id) REFERENCES user (id);'); |
||
| 115 | $this->addSql('CREATE INDEX IDX_33548A73A76ED395 ON course_request (user_id);'); |
||
| 116 | |||
| 117 | $this->addSql('ALTER TABLE search_engine_ref ADD c_id INT DEFAULT NULL'); |
||
| 118 | $this->addSql('UPDATE search_engine_ref SET c_id = (SELECT id FROM course WHERE code = course_code)'); |
||
| 119 | $this->addSql('ALTER TABLE search_engine_ref DROP course_code'); |
||
| 120 | |||
| 121 | $this->addSql('ALTER TABLE search_engine_ref ADD CONSTRAINT FK_473F037891D79BD3 FOREIGN KEY (c_id) REFERENCES course (id);'); |
||
| 122 | $this->addSql('CREATE INDEX IDX_473F037891D79BD3 ON search_engine_ref (c_id);'); |
||
| 123 | |||
| 124 | $this->addSql('ALTER TABLE hook_observer CHANGE class_name class_name VARCHAR(190) DEFAULT NULL'); |
||
| 125 | |||
| 126 | $connection = $this->getEntityManager()->getConnection(); |
||
| 127 | $sql = 'SELECT * FROM course_category'; |
||
| 128 | $result = $connection->executeQuery($sql); |
||
| 129 | $all = $result->fetchAll(); |
||
| 130 | |||
| 131 | $categories = array_column($all, 'parent_id', 'id'); |
||
| 132 | $categoryCodeList = array_column($all, 'id', 'code'); |
||
| 133 | |||
| 134 | foreach ($categories as $categoryId => $parentId) { |
||
| 135 | if (empty($parentId)) { |
||
| 136 | continue; |
||
| 137 | } |
||
| 138 | $newParentId = $categoryCodeList[$parentId]; |
||
| 139 | if (!empty($newParentId)) { |
||
| 140 | $this->addSql("UPDATE course_category SET parent_id = $newParentId WHERE id = $categoryId"); |
||
| 141 | } |
||
| 142 | } |
||
| 143 | |||
| 144 | $this->addSql('ALTER TABLE course_category CHANGE parent_id parent_id INT DEFAULT NULL;'); |
||
| 145 | $this->addSql('ALTER TABLE course_category ADD CONSTRAINT FK_AFF87497727ACA70 FOREIGN KEY (parent_id) REFERENCES course_category (id);'); |
||
| 146 | $this->addSql('ALTER TABLE settings_current ADD CONSTRAINT FK_62F79C3B9436187B FOREIGN KEY (access_url) REFERENCES access_url (id);'); |
||
| 147 | $this->addSql('ALTER TABLE settings_current CHANGE variable variable VARCHAR(190) DEFAULT NULL, CHANGE subkey subkey VARCHAR(190) DEFAULT NULL;'); |
||
| 148 | $this->addSql('ALTER TABLE settings_options CHANGE variable variable VARCHAR(190) DEFAULT NULL, CHANGE value value VARCHAR(190) DEFAULT NULL'); |
||
| 149 | $this->addSql('ALTER TABLE hook_event CHANGE class_name class_name VARCHAR(190) DEFAULT NULL;'); |
||
| 150 | |||
| 151 | $this->addSql('ALTER TABLE access_url_rel_session ADD id INT AUTO_INCREMENT NOT NULL, CHANGE access_url_id access_url_id INT DEFAULT NULL, CHANGE session_id session_id INT DEFAULT NULL, ADD PRIMARY KEY (id);'); |
||
| 152 | $this->addSql('ALTER TABLE access_url_rel_session ADD CONSTRAINT FK_6CBA5F5D613FECDF FOREIGN KEY (session_id) REFERENCES session (id);'); |
||
| 153 | $this->addSql('ALTER TABLE access_url_rel_session ADD CONSTRAINT FK_6CBA5F5D73444FD5 FOREIGN KEY (access_url_id) REFERENCES access_url (id);'); |
||
| 154 | $this->addSql('CREATE INDEX IDX_6CBA5F5D613FECDF ON access_url_rel_session (session_id);'); |
||
| 155 | $this->addSql('CREATE INDEX IDX_6CBA5F5D73444FD5 ON access_url_rel_session (access_url_id);'); |
||
| 156 | |||
| 157 | $this->addSql('ALTER TABLE c_tool ADD CONSTRAINT FK_8456658091D79BD3 FOREIGN KEY (c_id) REFERENCES course (id)'); |
||
| 158 | |||
| 159 | $this->addSql('DROP INDEX user_sco_course_sv ON track_stored_values;'); |
||
| 160 | $this->addSql('DROP INDEX user_sco_course_sv_stack ON track_stored_values_stack;'); |
||
| 161 | |||
| 162 | $this->addSql('UPDATE c_tool SET name = "blog" WHERE name = "blog_management" '); |
||
| 163 | $this->addSql('UPDATE c_tool SET name = "agenda" WHERE name = "calendar_event" '); |
||
| 164 | $this->addSql('UPDATE c_tool SET name = "maintenance" WHERE name = "course_maintenance" '); |
||
| 165 | $this->addSql('UPDATE c_tool SET name = "assignment" WHERE name = "student_publication" '); |
||
| 166 | $this->addSql('UPDATE c_tool SET name = "settings" WHERE name = "course_setting" '); |
||
| 167 | |||
| 168 | $this->addSql('UPDATE session_category SET date_start = NULL WHERE date_start = "0000-00-00"'); |
||
| 169 | $this->addSql('UPDATE session_category SET date_end = NULL WHERE date_end = "0000-00-00"'); |
||
| 170 | |||
| 171 | $this->addSql('DELETE FROM message WHERE user_sender_id IS NULL OR user_sender_id = 0'); |
||
| 172 | |||
| 173 | $this->addSql('ALTER TABLE message CHANGE user_receiver_id user_receiver_id INT DEFAULT NULL'); |
||
| 174 | $this->addSql('UPDATE message SET user_receiver_id = NULL WHERE user_receiver_id = 0'); |
||
| 175 | |||
| 176 | $this->addSql('DELETE FROM message WHERE user_sender_id NOT IN (SELECT id FROM user)'); |
||
| 177 | $this->addSql('DELETE FROM message WHERE user_receiver_id IS NOT NULL AND user_receiver_id NOT IN (SELECT id FROM user)'); |
||
| 178 | |||
| 179 | $this->addSql('ALTER TABLE message ADD CONSTRAINT FK_B6BD307FF6C43E79 FOREIGN KEY (user_sender_id) REFERENCES user (id)'); |
||
| 180 | $this->addSql('ALTER TABLE message ADD CONSTRAINT FK_B6BD307F64482423 FOREIGN KEY (user_receiver_id) REFERENCES user (id)'); |
||
| 181 | |||
| 182 | $table = $schema->getTable('message'); |
||
| 183 | if (!$table->hasIndex('idx_message_user_receiver_status')) { |
||
| 184 | $this->addSql('CREATE INDEX idx_message_user_receiver_status ON message (user_receiver_id, msg_status)'); |
||
| 185 | } |
||
| 186 | |||
| 187 | if (!$table->hasIndex('idx_message_receiver_status_send_date')) { |
||
| 188 | $this->addSql('CREATE INDEX idx_message_receiver_status_send_date ON message (user_receiver_id, msg_status, send_date)'); |
||
| 189 | } |
||
| 190 | |||
| 191 | $table = $schema->getTable('track_e_course_access'); |
||
| 192 | if (!$table->hasIndex('user_course_session_date')) { |
||
| 193 | $this->addSql( |
||
| 194 | 'CREATE INDEX user_course_session_date ON track_e_course_access (user_id, c_id, session_id, login_course_date)' |
||
| 195 | ); |
||
| 196 | } |
||
| 197 | |||
| 198 | $table = $schema->getTable('c_quiz_answer'); |
||
| 199 | if (!$table->hasIndex('c_id_auto')) { |
||
| 200 | $this->addSql('CREATE INDEX c_id_auto ON c_quiz_answer (c_id, id_auto)'); |
||
| 201 | } |
||
| 202 | |||
| 203 | $table = $schema->getTable('c_forum_post'); |
||
| 204 | if (!$table->hasIndex('c_id_visible_post_date')) { |
||
| 205 | $this->addSql('CREATE INDEX c_id_visible_post_date ON c_forum_post (c_id, visible, post_date)'); |
||
| 206 | } |
||
| 207 | |||
| 208 | $table = $schema->getTable('track_e_access'); |
||
| 209 | if (!$table->hasIndex('user_course_session_date')) { |
||
| 210 | $this->addSql('CREATE INDEX user_course_session_date ON track_e_access (access_user_id, c_id, access_session_id, access_date)'); |
||
| 211 | } |
||
| 212 | |||
| 213 | // Update iso |
||
| 214 | $sql = "UPDATE course SET course_language = (SELECT isocode FROM language WHERE english_name = course_language);"; |
||
| 215 | $this->addSql($sql); |
||
| 216 | |||
| 217 | $sql = "UPDATE sys_announcement SET lang = (SELECT isocode FROM language WHERE english_name = lang);"; |
||
| 218 | $this->addSql($sql); |
||
| 219 | //$this->addSql('ALTER TABLE c_tool_intro CHANGE id tool VARCHAR(255) NOT NULL'); |
||
| 220 | |||
| 221 | $this->addSql('ALTER TABLE user ADD date_of_birth DATETIME DEFAULT NULL, ADD website VARCHAR(64) DEFAULT NULL, ADD biography VARCHAR(1000) DEFAULT NULL, ADD gender VARCHAR(1) DEFAULT NULL, ADD locale VARCHAR(8) DEFAULT NULL, ADD timezone VARCHAR(64) DEFAULT NULL, ADD facebook_uid VARCHAR(255) DEFAULT NULL, ADD facebook_name VARCHAR(255) DEFAULT NULL, ADD facebook_data LONGTEXT DEFAULT NULL COMMENT "(DC2Type:json)", ADD twitter_uid VARCHAR(255) DEFAULT NULL, ADD twitter_name VARCHAR(255) DEFAULT NULL, ADD twitter_data LONGTEXT DEFAULT NULL COMMENT "(DC2Type:json)", ADD gplus_uid VARCHAR(255) DEFAULT NULL, ADD gplus_name VARCHAR(255) DEFAULT NULL, ADD gplus_data LONGTEXT DEFAULT NULL COMMENT "(DC2Type:json)", ADD token VARCHAR(255) DEFAULT NULL, ADD two_step_code VARCHAR(255) DEFAULT NULL, CHANGE username_canonical username_canonical VARCHAR(180) NOT NULL, CHANGE lastname lastname VARCHAR(64) DEFAULT NULL, CHANGE firstname firstname VARCHAR(64) DEFAULT NULL, CHANGE phone phone VARCHAR(64) DEFAULT NULL, CHANGE salt salt VARCHAR(255) DEFAULT NULL, CHANGE created_at created_at DATETIME NOT NULL, CHANGE updated_at updated_at DATETIME NOT NULL, CHANGE confirmation_token confirmation_token VARCHAR(180) DEFAULT NULL;'); |
||
| 222 | $this->addSql('ALTER TABLE c_item_property CHANGE lastedit_user_id lastedit_user_id INT DEFAULT NULL'); |
||
| 223 | |||
| 224 | // Fixes missing options show_glossary_in_extra_tools |
||
| 225 | $this->addSql("DELETE FROM settings_options WHERE variable = 'show_glossary_in_extra_tools'"); |
||
| 226 | $this->addSql("INSERT INTO settings_options (variable, value, display_text) VALUES ('show_glossary_in_extra_tools', 'none', 'None')"); |
||
| 227 | $this->addSql("INSERT INTO settings_options (variable, value, display_text) VALUES ('show_glossary_in_extra_tools', 'exercise', 'Exercise')"); |
||
| 228 | $this->addSql("INSERT INTO settings_options (variable, value, display_text) VALUES ('show_glossary_in_extra_tools', 'lp', 'LearningPath')"); |
||
| 229 | $this->addSql("INSERT INTO settings_options (variable, value, display_text) VALUES ('show_glossary_in_extra_tools', 'exercise_and_lp', 'ExerciseAndLearningPath')"); |
||
| 230 | |||
| 231 | $cSurvey = $schema->getTable('c_survey'); |
||
| 232 | |||
| 233 | if (!$cSurvey->hasColumn('is_mandatory')) { |
||
| 234 | $cSurvey->addColumn('is_mandatory', Type::BOOLEAN)->setDefault(false); |
||
| 235 | } |
||
| 236 | |||
| 237 | $this->addSql('ALTER TABLE c_student_publication ADD filesize INT DEFAULT NULL'); |
||
| 238 | $this->addSql('CREATE TABLE IF NOT EXISTS c_group_info_audit (iid INT NOT NULL, rev INT NOT NULL, c_id INT DEFAULT NULL, id INT DEFAULT NULL, name VARCHAR(100) DEFAULT NULL, status TINYINT(1) DEFAULT NULL, category_id INT DEFAULT NULL, description LONGTEXT DEFAULT NULL, max_student INT DEFAULT NULL, doc_state TINYINT(1) DEFAULT NULL, calendar_state TINYINT(1) DEFAULT NULL, work_state TINYINT(1) DEFAULT NULL, announcements_state TINYINT(1) DEFAULT NULL, forum_state TINYINT(1) DEFAULT NULL, wiki_state TINYINT(1) DEFAULT NULL, chat_state TINYINT(1) DEFAULT NULL, secret_directory VARCHAR(255) DEFAULT NULL, self_registration_allowed TINYINT(1) DEFAULT NULL, self_unregistration_allowed TINYINT(1) DEFAULT NULL, session_id INT DEFAULT NULL, revtype VARCHAR(4) NOT NULL, PRIMARY KEY(iid, rev)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB'); |
||
| 239 | |||
| 240 | /*$table = $schema->getTable('course_rel_class'); |
||
| 241 | if (!$table->hasColumn('c_id')) { |
||
| 242 | $this->addSql("ALTER TABLE course_rel_class ADD c_id int NOT NULL"); |
||
| 243 | } |
||
| 244 | |||
| 245 | if ($table->hasColumn('course_code')) { |
||
| 246 | $this->addSql(" |
||
| 247 | UPDATE course_rel_class cc |
||
| 248 | SET cc.c_id = (SELECT id FROM course WHERE code = cc.course_code) |
||
| 249 | "); |
||
| 250 | |||
| 251 | $this->addSql("ALTER TABLE course_rel_class DROP course_code"); |
||
| 252 | $this->addSql("ALTER TABLE course_rel_class DROP PRIMARY KEY"); |
||
| 253 | $this->addSql("ALTER TABLE course_rel_class MODIFY COLUMN class_id INT DEFAULT NULL"); |
||
| 254 | $this->addSql("ALTER TABLE course_rel_class ADD PRIMARY KEY (class_id, c_id)"); |
||
| 255 | $this->addSql("ALTER TABLE course_rel_class ADD FOREIGN KEY (c_id) REFERENCES course (id) ON DELETE RESTRICT"); |
||
| 256 | }*/ |
||
| 257 | |||
| 258 | $tables = [ |
||
| 259 | 'shared_survey', |
||
| 260 | 'specific_field_values', |
||
| 261 | 'templates', |
||
| 262 | ]; |
||
| 263 | |||
| 264 | foreach ($tables as $table) { |
||
| 265 | $tableObj = $schema->getTable($table); |
||
| 266 | /*if (!$tableObj->hasColumn('c_id')) { |
||
| 267 | $this->addSql("ALTER TABLE $table ADD c_id int NOT NULL"); |
||
| 268 | |||
| 269 | if ($tableObj->hasColumn('course_code')) { |
||
| 270 | $this->addSql(" |
||
| 271 | UPDATE $table t |
||
| 272 | SET t.c_id = (SELECT id FROM course WHERE code = t.course_code) |
||
| 273 | "); |
||
| 274 | $this->addSql("ALTER TABLE $table DROP course_code"); |
||
| 275 | } |
||
| 276 | }*/ |
||
| 277 | /*$this->addSql(" |
||
| 278 | ALTER TABLE $table ADD FOREIGN KEY (c_id) REFERENCES course (id) ON DELETE RESTRICT |
||
| 279 | ");*/ |
||
| 280 | } |
||
| 281 | /* |
||
| 282 | $this->addSql("ALTER TABLE personal_agenda DROP course"); |
||
| 283 | |||
| 284 | $this->addSql(" |
||
| 285 | ALTER TABLE specific_field_values |
||
| 286 | ADD c_id int(11) NOT NULL, |
||
| 287 | ADD FOREIGN KEY (c_id) REFERENCES course (id) ON DELETE RESTRICT; |
||
| 288 | "); |
||
| 289 | |||
| 290 | $this->addSql(" |
||
| 291 | ALTER TABLE track_e_hotspot |
||
| 292 | CHANGE c_id c_id int(11) NOT NULL AFTER hotspot_course_code, |
||
| 293 | ADD FOREIGN KEY (c_id) REFERENCES course (id) ON DELETE RESTRICT; |
||
| 294 | "); |
||
| 295 | $this->addSql(" |
||
| 296 | UPDATE track_e_hotspot teh |
||
| 297 | SET teh.c_id = (SELECT id FROM course WHERE code = teh.hotspot_course_code) |
||
| 298 | WHERE teh.hotspot_course_code != NULL OR hotspot_course_code != '' |
||
| 299 | "); |
||
| 300 | $this->addSql("ALTER TABLE personal_agenda DROP hotspot_course_code");*/ |
||
| 301 | |||
| 302 | // Update settings variable name |
||
| 303 | $settings = [ |
||
| 304 | 'Institution' => 'institution', |
||
| 305 | 'SiteName' => 'site_name', |
||
| 306 | 'InstitutionUrl' => 'institution_url', |
||
| 307 | 'registration' => 'required_profile_fields', |
||
| 308 | 'profile' => 'changeable_options', |
||
| 309 | 'timezone_value' => 'timezone', |
||
| 310 | 'stylesheets' => 'theme', |
||
| 311 | 'platformLanguage' => 'platform_language', |
||
| 312 | 'languagePriority1' => 'language_priority_1', |
||
| 313 | 'languagePriority2' => 'language_priority_2', |
||
| 314 | 'languagePriority3' => 'language_priority_3', |
||
| 315 | 'languagePriority4' => 'language_priority_4', |
||
| 316 | 'gradebook_score_display_coloring' => 'my_display_coloring', |
||
| 317 | 'document_if_file_exists_option' => 'if_file_exists_option', |
||
| 318 | 'ProfilingFilterAddingUsers' => 'profiling_filter_adding_users', |
||
| 319 | 'course_create_active_tools' => 'active_tools_on_create', |
||
| 320 | 'EmailAdministrator' => 'administrator_email', |
||
| 321 | 'administratorSurname' => 'administrator_surname', |
||
| 322 | 'administratorName' => 'administrator_name', |
||
| 323 | 'administratorTelephone' => 'administrator_phone', |
||
| 324 | 'registration.soap.php.decode_utf8' => 'decode_utf8', |
||
| 325 | ]; |
||
| 326 | |||
| 327 | foreach ($settings as $oldSetting => $newSetting) { |
||
| 328 | $sql = "UPDATE settings_current SET variable = '$newSetting' |
||
| 329 | WHERE variable = '$oldSetting'"; |
||
| 330 | $this->addSql($sql); |
||
| 331 | } |
||
| 332 | |||
| 333 | // Update settings category |
||
| 334 | $settings = [ |
||
| 335 | 'cookie_warning' => 'platform', |
||
| 336 | 'donotlistcampus' => 'platform', |
||
| 337 | 'administrator_email' => 'admin', |
||
| 338 | 'administrator_surname' => 'admin', |
||
| 339 | 'administrator_name' => 'admin', |
||
| 340 | 'administrator_phone' => 'admin', |
||
| 341 | 'exercise_max_ckeditors_in_page' => 'exercise', |
||
| 342 | 'allow_hr_skills_management' => 'skill', |
||
| 343 | 'accessibility_font_resize' => 'display', |
||
| 344 | 'account_valid_duration' => 'profile', |
||
| 345 | 'activate_email_template' => 'mail', |
||
| 346 | 'allow_global_chat' => 'chat', |
||
| 347 | 'allow_lostpassword' => 'registration', |
||
| 348 | 'allow_registration' => 'registration', |
||
| 349 | 'allow_registration_as_teacher' => 'registration', |
||
| 350 | 'allow_skills_tool' => 'skill', |
||
| 351 | 'allow_students_to_browse_courses' => 'display', |
||
| 352 | 'allow_terms_conditions' => 'registration', |
||
| 353 | 'allow_users_to_create_courses' => 'course', |
||
| 354 | 'auto_detect_language_custom_pages' => 'language', |
||
| 355 | 'course_validation' => 'course', |
||
| 356 | 'course_validation_terms_and_conditions_url' => 'course', |
||
| 357 | 'display_categories_on_homepage' => 'display', |
||
| 358 | 'display_coursecode_in_courselist' => 'course', |
||
| 359 | 'display_teacher_in_courselist' => 'course', |
||
| 360 | 'drh_autosubscribe' => 'registration', |
||
| 361 | 'drh_page_after_login' => 'registration', |
||
| 362 | 'enable_help_link' => 'display', |
||
| 363 | 'example_material_course_creation' => 'course', |
||
| 364 | 'login_is_email' => 'profile', |
||
| 365 | 'noreply_email_address' => 'mail', |
||
| 366 | 'page_after_login' => 'registration', |
||
| 367 | 'pdf_export_watermark_by_course' => 'document', |
||
| 368 | 'pdf_export_watermark_enable' => 'document', |
||
| 369 | 'pdf_export_watermark_text' => 'document', |
||
| 370 | 'platform_unsubscribe_allowed' => 'registration', |
||
| 371 | 'send_email_to_admin_when_create_course' => 'course', |
||
| 372 | 'show_admin_toolbar' => 'display', |
||
| 373 | 'show_administrator_data' => 'display', |
||
| 374 | 'show_back_link_on_top_of_tree' => 'display', |
||
| 375 | 'show_closed_courses' => 'display', |
||
| 376 | 'show_different_course_language' => 'display', |
||
| 377 | 'show_email_addresses' => 'display', |
||
| 378 | 'show_empty_course_categories' => 'display', |
||
| 379 | 'show_full_skill_name_on_skill_wheel' => 'skill', |
||
| 380 | 'show_hot_courses' => 'display', |
||
| 381 | 'show_link_bug_notification' => 'display', |
||
| 382 | 'show_number_of_courses' => 'display', |
||
| 383 | 'show_teacher_data' => 'display', |
||
| 384 | 'showonline' => 'display', |
||
| 385 | 'student_autosubscribe' => 'registration', |
||
| 386 | 'student_page_after_login' => 'registration', |
||
| 387 | 'student_view_enabled' => 'course', |
||
| 388 | 'teacher_autosubscribe' => 'registration', |
||
| 389 | 'teacher_page_after_login' => 'registration', |
||
| 390 | 'time_limit_whosonline' => 'display', |
||
| 391 | 'user_selected_theme' => 'profile', |
||
| 392 | 'hide_global_announcements_when_not_connected' => 'announcement', |
||
| 393 | 'hide_home_top_when_connected' => 'display', |
||
| 394 | 'hide_logout_button' => 'display', |
||
| 395 | 'institution_address' => 'platform', |
||
| 396 | 'redirect_admin_to_courses_list' => 'admin', |
||
| 397 | 'decode_utf8' => 'webservice', |
||
| 398 | 'use_custom_pages' => 'platform', |
||
| 399 | 'allow_group_categories' => 'group', |
||
| 400 | 'allow_user_headings' => 'display', |
||
| 401 | 'default_document_quotum' => 'document', |
||
| 402 | 'default_forum_view' => 'forum', |
||
| 403 | 'default_group_quotum' => 'document', |
||
| 404 | 'enable_quiz_scenario' => 'exercise', |
||
| 405 | 'exercise_max_score' => 'exercise', |
||
| 406 | 'exercise_min_score' => 'exercise', |
||
| 407 | 'pdf_logo_header' => 'platform', |
||
| 408 | 'show_glossary_in_documents' => 'document', |
||
| 409 | 'show_glossary_in_extra_tools' => 'glossary', |
||
| 410 | //'show_toolshortcuts' => '', |
||
| 411 | 'survey_email_sender_noreply' => 'survey', |
||
| 412 | 'allow_coach_feedback_exercises' => 'exercise', |
||
| 413 | 'sessionadmin_autosubscribe' => 'registration', |
||
| 414 | 'sessionadmin_page_after_login' => 'registration', |
||
| 415 | 'show_tutor_data' => 'display', |
||
| 416 | 'chamilo_database_version' => 'platform', |
||
| 417 | 'add_gradebook_certificates_cron_task_enabled' => 'gradebook', |
||
| 418 | 'icons_mode_svg' => 'display', |
||
| 419 | 'server_type' => 'platform', |
||
| 420 | 'show_official_code_whoisonline' => 'profile', |
||
| 421 | 'show_terms_if_profile_completed' => 'ticket', |
||
| 422 | ]; |
||
| 423 | |||
| 424 | foreach ($settings as $variable => $category) { |
||
| 425 | $sql = "UPDATE settings_current SET category = '$category' |
||
| 426 | WHERE variable = '$variable'"; |
||
| 427 | $this->addSql($sql); |
||
| 428 | } |
||
| 429 | |||
| 430 | // Update settings value |
||
| 431 | $settings = [ |
||
| 432 | 'upload_extensions_whitelist' => 'htm;html;jpg;jpeg;gif;png;swf;avi;mpg;mpeg;mov;flv;doc;docx;xls;xlsx;ppt;pptx;odt;odp;ods;pdf;webm;oga;ogg;ogv;h264', |
||
| 433 | ]; |
||
| 434 | |||
| 435 | foreach ($settings as $variable => $value) { |
||
| 436 | $sql = "UPDATE settings_current SET selected_value = '$value' |
||
| 437 | WHERE variable = '$variable'"; |
||
| 438 | $this->addSql($sql); |
||
| 439 | } |
||
| 440 | |||
| 441 | // Delete settings |
||
| 442 | $settings = [ |
||
| 443 | 'use_session_mode', |
||
| 444 | 'show_toolshortcuts', |
||
| 445 | 'show_tabs', |
||
| 446 | 'display_mini_month_calendar', |
||
| 447 | 'number_of_upcoming_events', |
||
| 448 | 'facebook_description', |
||
| 449 | 'ldap_description', |
||
| 450 | 'openid_authentication', |
||
| 451 | //'platform_charset', |
||
| 452 | 'shibboleth_description', |
||
| 453 | 'sso_authentication', |
||
| 454 | 'sso_authentication_domain', |
||
| 455 | 'sso_authentication_auth_uri', |
||
| 456 | 'sso_authentication_unauth_uri', |
||
| 457 | 'sso_authentication_protocol', |
||
| 458 | 'sso_force_redirect', |
||
| 459 | ]; |
||
| 460 | |||
| 461 | foreach ($settings as $setting) { |
||
| 462 | $sql = "DELETE FROM settings_current WHERE variable = '$setting'"; |
||
| 463 | $this->addSql($sql); |
||
| 464 | } |
||
| 465 | |||
| 466 | $this->addSql('UPDATE settings_current SET category = LOWER(category)'); |
||
| 467 | $this->addSql("ALTER TABLE c_quiz_question_category CHANGE description description LONGTEXT DEFAULT NULL;"); |
||
| 468 | $this->addSql("ALTER TABLE c_survey_invitation ADD answered_at DATETIME DEFAULT NULL;"); |
||
| 469 | |||
| 470 | $this->addSql('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;'); |
||
| 471 | $this->addSql('ALTER TABLE gradebook_certificate ADD downloaded_at DATETIME DEFAULT NULL;'); |
||
| 472 | $this->addSql('UPDATE gradebook_certificate gc SET downloaded_at = (select value from extra_field e inner join extra_field_values v on v.field_id = e.id where variable = "downloaded_at" and extra_field_type = 11 and item_id = gc.id)'); |
||
| 473 | |||
| 474 | $table = $schema->getTable('c_quiz'); |
||
| 475 | if ($table->hasColumn('show_previous_button') === false) { |
||
| 476 | $this->addSql( |
||
| 477 | 'ALTER TABLE c_quiz ADD COLUMN show_previous_button TINYINT(1) DEFAULT 1;' |
||
| 478 | ); |
||
| 479 | } |
||
| 480 | |||
| 481 | if ($table->hasColumn('notifications') === false) { |
||
| 482 | $this->addSql( |
||
| 483 | 'ALTER TABLE c_quiz ADD COLUMN notifications VARCHAR(255) NULL DEFAULT NULL;' |
||
| 484 | ); |
||
| 485 | } |
||
| 486 | |||
| 487 | $table = $schema->getTable('c_lp_item_view'); |
||
| 488 | if ($table->hasIndex('idx_c_lp_item_view_cid_id_view_count') == false) { |
||
| 489 | $this->addSql( |
||
| 490 | 'CREATE INDEX idx_c_lp_item_view_cid_id_view_count ON c_lp_item_view (c_id, id, view_count)' |
||
| 491 | ); |
||
| 492 | } |
||
| 493 | |||
| 494 | $table = $schema->getTable('session'); |
||
| 495 | if (!$table->hasColumn('position')) { |
||
| 496 | $this->addSql('ALTER TABLE session ADD COLUMN position INT DEFAULT 0 NOT NULL'); |
||
| 497 | } else { |
||
| 498 | $this->addSql('ALTER TABLE session CHANGE position position INT DEFAULT 0 NOT NULL'); |
||
| 499 | } |
||
| 500 | |||
| 501 | $this->addSql("UPDATE settings_current SET selected_value = 'true' WHERE variable = 'decode_utf8'"); |
||
| 502 | $this->addSql('ALTER TABLE extra_field_values CHANGE value value LONGTEXT DEFAULT NULL;'); |
||
| 503 | $this->addSql('ALTER TABLE message CHANGE msg_status msg_status SMALLINT NOT NULL;'); |
||
| 504 | |||
| 505 | // Portfolio |
||
| 506 | if (!$schema->hasTable('portfolio')) { |
||
| 507 | $this->addSql('CREATE TABLE portfolio_category (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, title LONGTEXT DEFAULT NULL, description LONGTEXT DEFAULT NULL, is_visible TINYINT(1) DEFAULT "1" NOT NULL, INDEX user (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;'); |
||
| 508 | $this->addSql('CREATE TABLE portfolio (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, c_id INT DEFAULT NULL, session_id INT DEFAULT NULL, category_id INT DEFAULT NULL, title LONGTEXT NOT NULL, content LONGTEXT NOT NULL, creation_date DATETIME NOT NULL, update_date DATETIME NOT NULL, is_visible TINYINT(1) DEFAULT "1" NOT NULL, INDEX user (user_id), INDEX course (c_id), INDEX session (session_id), INDEX category (category_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;'); |
||
| 509 | $this->addSql('ALTER TABLE portfolio_category ADD CONSTRAINT FK_7AC64359A76ED395 FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE CASCADE'); |
||
| 510 | $this->addSql('ALTER TABLE portfolio ADD CONSTRAINT FK_A9ED1062A76ED395 FOREIGN KEY (user_id) REFERENCES user (id);'); |
||
| 511 | $this->addSql('ALTER TABLE portfolio ADD CONSTRAINT FK_A9ED106291D79BD3 FOREIGN KEY (c_id) REFERENCES course (id);'); |
||
| 512 | $this->addSql('ALTER TABLE portfolio ADD CONSTRAINT FK_A9ED1062613FECDF FOREIGN KEY (session_id) REFERENCES session (id);'); |
||
| 513 | $this->addSql('ALTER TABLE portfolio ADD CONSTRAINT FK_A9ED106212469DE2 FOREIGN KEY (category_id) REFERENCES portfolio_category (id);'); |
||
| 514 | } else { |
||
| 515 | $this->addSql('ALTER TABLE portfolio_category CHANGE title title LONGTEXT DEFAULT NULL'); |
||
| 516 | } |
||
| 517 | |||
| 518 | // Skills |
||
| 519 | if (!$schema->hasTable('skill_rel_item_rel_user')) { |
||
| 520 | $this->addSql('CREATE TABLE skill_rel_item_rel_user (id INT AUTO_INCREMENT NOT NULL, skill_rel_item_id INT NOT NULL, user_id INT NOT NULL, result_id INT DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_D1133E0DFD4B12DC (skill_rel_item_id), INDEX IDX_D1133E0DA76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;'); |
||
| 521 | $this->addSql('CREATE TABLE skill_rel_item (id INT AUTO_INCREMENT NOT NULL, skill_id INT DEFAULT NULL, item_type INT NOT NULL, item_id INT NOT NULL, obtain_conditions VARCHAR(255) DEFAULT NULL, requires_validation TINYINT(1) NOT NULL, is_real TINYINT(1) NOT NULL, c_id INT DEFAULT NULL, session_id INT DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, created_by INT NOT NULL, updated_by INT NOT NULL, INDEX IDX_EB5B2A0D5585C142 (skill_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;'); |
||
| 522 | $this->addSql('CREATE TABLE skill_rel_course (id INT AUTO_INCREMENT NOT NULL, skill_id INT DEFAULT NULL, c_id INT NOT NULL, session_id INT NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX IDX_E7CEC7FA5585C142 (skill_id), INDEX IDX_E7CEC7FA91D79BD3 (c_id), INDEX IDX_E7CEC7FA613FECDF (session_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;'); |
||
| 523 | $this->addSql('ALTER TABLE skill_rel_item_rel_user ADD CONSTRAINT FK_D1133E0DFD4B12DC FOREIGN KEY (skill_rel_item_id) REFERENCES skill_rel_item (id);'); |
||
| 524 | $this->addSql('ALTER TABLE skill_rel_item_rel_user ADD CONSTRAINT FK_D1133E0DA76ED395 FOREIGN KEY (user_id) REFERENCES user (id);'); |
||
| 525 | $this->addSql('ALTER TABLE skill_rel_item ADD CONSTRAINT FK_EB5B2A0D5585C142 FOREIGN KEY (skill_id) REFERENCES skill (id);'); |
||
| 526 | $this->addSql('ALTER TABLE skill_rel_course ADD CONSTRAINT FK_E7CEC7FA5585C142 FOREIGN KEY (skill_id) REFERENCES skill (id);'); |
||
| 527 | $this->addSql('ALTER TABLE skill_rel_course ADD CONSTRAINT FK_E7CEC7FA91D79BD3 FOREIGN KEY (c_id) REFERENCES course (id);'); |
||
| 528 | $this->addSql('ALTER TABLE skill_rel_course ADD CONSTRAINT FK_E7CEC7FA613FECDF FOREIGN KEY (session_id) REFERENCES session (id);'); |
||
| 529 | } |
||
| 530 | |||
| 531 | $table = $schema->getTable('skill_rel_user'); |
||
| 532 | if (!$table->hasColumn('validation_status')) { |
||
| 533 | $this->addSql('ALTER TABLE skill_rel_user ADD validation_status INT NOT NULL'); |
||
| 534 | } |
||
| 535 | |||
| 536 | $this->addSql('CREATE UNIQUE INDEX UNIQ_8D93D649C05FB297 ON user (confirmation_token)'); |
||
| 537 | |||
| 538 | $this->addSql('CREATE TABLE IF NOT EXISTS ext_translations (id INT AUTO_INCREMENT NOT NULL, locale VARCHAR(8) NOT NULL, object_class VARCHAR(190) NOT NULL, field VARCHAR(32) NOT NULL, foreign_key VARCHAR(64) NOT NULL, content LONGTEXT DEFAULT NULL, INDEX translations_lookup_idx (locale, object_class, foreign_key), UNIQUE INDEX lookup_unique_idx (locale, object_class, field, foreign_key), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;'); |
||
| 539 | $this->addSql('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(255) NOT NULL, version INT NOT NULL, data LONGTEXT DEFAULT NULL COMMENT "(DC2Type:array)", username VARCHAR(255) 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;'); |
||
| 540 | $this->addSql('CREATE TABLE IF NOT EXISTS tool (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, image VARCHAR(255) DEFAULT NULL, description LONGTEXT DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;'); |
||
| 541 | $this->addSql('CREATE TABLE IF NOT EXISTS resource_node (id INT AUTO_INCREMENT NOT NULL, tool_id INT DEFAULT NULL, creator_id INT NOT NULL, parent_id INT DEFAULT NULL, name VARCHAR(255) NOT NULL, level INT DEFAULT NULL, path VARCHAR(3000) DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX IDX_8A5F48FF8F7B22CC (tool_id), INDEX IDX_8A5F48FF61220EA6 (creator_id), INDEX IDX_8A5F48FF727ACA70 (parent_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;'); |
||
| 542 | $this->addSql('CREATE TABLE IF NOT EXISTS resource_rights (id INT AUTO_INCREMENT NOT NULL, resource_link_id INT DEFAULT NULL, role VARCHAR(255) NOT NULL, mask INT NOT NULL, UNIQUE INDEX UNIQ_C99C3BF9F004E599 (resource_link_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;'); |
||
| 543 | $this->addSql('CREATE TABLE IF NOT EXISTS resource_link (id INT AUTO_INCREMENT NOT NULL, resource_node_id INT DEFAULT NULL, session_id INT DEFAULT NULL, user_id INT DEFAULT NULL, c_id INT DEFAULT NULL, group_id INT DEFAULT NULL, usergroup_id INT DEFAULT NULL, private TINYINT(1) DEFAULT NULL, public TINYINT(1) DEFAULT NULL, start_visibility_at DATETIME DEFAULT NULL, end_visibility_at DATETIME DEFAULT NULL, INDEX IDX_398C394B1BAD783F (resource_node_id), INDEX IDX_398C394B613FECDF (session_id), INDEX IDX_398C394BA76ED395 (user_id), INDEX IDX_398C394B91D79BD3 (c_id), INDEX IDX_398C394BFE54D947 (group_id), INDEX IDX_398C394BD2112630 (usergroup_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;'); |
||
| 544 | $this->addSql('CREATE TABLE IF NOT EXISTS tool_resource_rights (id INT AUTO_INCREMENT NOT NULL, tool_id INT DEFAULT NULL, role VARCHAR(255) NOT NULL, mask INT NOT NULL, INDEX IDX_95CE3398F7B22CC (tool_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;'); |
||
| 545 | $this->addSql('CREATE TABLE IF NOT EXISTS notification__message (id INT AUTO_INCREMENT NOT NULL, type VARCHAR(255) NOT NULL, body LONGTEXT NOT NULL COMMENT "(DC2Type:json)", state INT NOT NULL, restart_count INT DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME DEFAULT NULL, started_at DATETIME DEFAULT NULL, completed_at DATETIME DEFAULT NULL, INDEX notification_message_state_idx (state), INDEX notification_message_created_at_idx (created_at), INDEX idx_state (state), INDEX idx_created_at (created_at), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;'); |
||
| 546 | $this->addSql('CREATE TABLE sylius_settings (id INT AUTO_INCREMENT NOT NULL, schema_alias VARCHAR(190) NOT NULL, namespace VARCHAR(190) DEFAULT NULL, parameters LONGTEXT NOT NULL COMMENT "(DC2Type:json_array)", UNIQUE INDEX UNIQ_1AFEFB2A894A31AD33E16B56 (schema_alias, namespace), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;'); |
||
| 547 | |||
| 548 | $this->addSql('ALTER TABLE resource_node ADD CONSTRAINT FK_8A5F48FF8F7B22CC FOREIGN KEY (tool_id) REFERENCES tool (id);'); |
||
| 549 | $this->addSql('ALTER TABLE resource_node ADD CONSTRAINT FK_8A5F48FF61220EA6 FOREIGN KEY (creator_id) REFERENCES user (id) ON DELETE CASCADE;'); |
||
| 550 | $this->addSql('ALTER TABLE resource_node ADD CONSTRAINT FK_8A5F48FF727ACA70 FOREIGN KEY (parent_id) REFERENCES resource_node (id) ON DELETE CASCADE;'); |
||
| 551 | $this->addSql('ALTER TABLE resource_rights ADD CONSTRAINT FK_C99C3BF9F004E599 FOREIGN KEY (resource_link_id) REFERENCES resource_link (id);'); |
||
| 552 | $this->addSql('ALTER TABLE resource_link ADD CONSTRAINT FK_398C394B1BAD783F FOREIGN KEY (resource_node_id) REFERENCES resource_node (id);'); |
||
| 553 | $this->addSql('ALTER TABLE resource_link ADD CONSTRAINT FK_398C394B613FECDF FOREIGN KEY (session_id) REFERENCES session (id);'); |
||
| 554 | $this->addSql('ALTER TABLE resource_link ADD CONSTRAINT FK_398C394BA76ED395 FOREIGN KEY (user_id) REFERENCES user (id);'); |
||
| 555 | $this->addSql('ALTER TABLE resource_link ADD CONSTRAINT FK_398C394B91D79BD3 FOREIGN KEY (c_id) REFERENCES course (id);'); |
||
| 556 | $this->addSql('ALTER TABLE resource_link ADD CONSTRAINT FK_398C394BFE54D947 FOREIGN KEY (group_id) REFERENCES c_group_info (iid);'); |
||
| 557 | $this->addSql('ALTER TABLE resource_link ADD CONSTRAINT FK_398C394BD2112630 FOREIGN KEY (usergroup_id) REFERENCES usergroup (id);'); |
||
| 558 | $this->addSql('ALTER TABLE tool_resource_rights ADD CONSTRAINT FK_95CE3398F7B22CC FOREIGN KEY (tool_id) REFERENCES tool (id);'); |
||
| 559 | |||
| 560 | // From configuration.dist.php 1.11.x |
||
| 561 | $this->addSql('ALTER TABLE c_dropbox_file CHANGE filename filename VARCHAR(190) NOT NULL'); |
||
| 562 | $this->addSql('ALTER TABLE course_category CHANGE name name LONGTEXT NOT NULL;'); |
||
| 563 | $this->addSql('ALTER TABLE c_course_description CHANGE title title LONGTEXT DEFAULT NULL'); |
||
| 564 | $this->addSql('ALTER TABLE c_thematic CHANGE title title LONGTEXT NOT NULL'); |
||
| 565 | $this->addSql('ALTER TABLE c_quiz CHANGE title title LONGTEXT NOT NULL'); |
||
| 566 | $this->addSql('ALTER TABLE c_lp_category CHANGE name name LONGTEXT NOT NULL'); |
||
| 567 | $this->addSql('ALTER TABLE c_glossary CHANGE name name LONGTEXT NOT NULL'); |
||
| 568 | $this->addSql('ALTER TABLE c_tool CHANGE name name LONGTEXT NOT NULL'); |
||
| 569 | $this->addSql('ALTER TABLE portfolio CHANGE title title LONGTEXT NOT NULL'); |
||
| 570 | |||
| 571 | $table = $schema->getTable('gradebook_category'); |
||
| 572 | if (!$table->hasColumn('gradebooks_to_validate_in_dependence')) { |
||
| 573 | $this->addSql('ALTER TABLE gradebook_category ADD gradebooks_to_validate_in_dependence INT DEFAULT NULL'); |
||
| 574 | } |
||
| 575 | if (!$table->hasColumn('depends')) { |
||
| 576 | $this->addSql('ALTER TABLE gradebook_category ADD depends LONGTEXT DEFAULT NULL'); |
||
| 577 | } |
||
| 578 | if (!$table->hasColumn('minimum_to_validate')) { |
||
| 579 | $this->addSql('ALTER TABLE gradebook_category ADD minimum_to_validate INT DEFAULT NULL'); |
||
| 580 | } |
||
| 581 | |||
| 582 | $table = $schema->getTable('course_category'); |
||
| 583 | if (!$table->hasColumn('image')) { |
||
| 584 | $this->addSql('ALTER TABLE course_category ADD image VARCHAR(255) DEFAULT NULL'); |
||
| 585 | } |
||
| 586 | if (!$table->hasColumn('description')) { |
||
| 587 | $this->addSql('ALTER TABLE course_category ADD description LONGTEXT DEFAULT NULL'); |
||
| 588 | } |
||
| 589 | |||
| 590 | $this->addSql('ALTER TABLE block CHANGE path path VARCHAR(190) NOT NULL'); |
||
| 591 | |||
| 592 | $table = $schema->getTable('sys_announcement'); |
||
| 593 | |||
| 594 | if ($table->hasColumn('visible_drh')) { |
||
| 595 | $this->addSql('ALTER TABLE sys_announcement CHANGE visible_drh visible_drh TINYINT(1) NOT NULL'); |
||
| 596 | } else { |
||
| 597 | $this->addSql('ALTER TABLE sys_announcement ADD COLUMN visible_drh TINYINT(1) NOT NULL'); |
||
| 598 | } |
||
| 599 | |||
| 600 | if ($table->hasColumn('visible_session_admin')) { |
||
| 601 | $this->addSql( |
||
| 602 | 'ALTER TABLE sys_announcement CHANGE visible_session_admin visible_session_admin TINYINT(1) NOT NULL' |
||
| 603 | ); |
||
| 604 | } else { |
||
| 605 | $this->addSql( |
||
| 606 | 'ALTER TABLE sys_announcement ADD COLUMN visible_session_admin TINYINT(1) NOT NULL' |
||
| 607 | ); |
||
| 608 | } |
||
| 609 | |||
| 610 | if ($table->hasColumn('visible_boss')) { |
||
| 611 | $this->addSql('ALTER TABLE sys_announcement CHANGE visible_boss visible_boss TINYINT(1) NOT NULL'); |
||
| 612 | } else { |
||
| 613 | $this->addSql('ALTER TABLE sys_announcement ADD COLUMN visible_boss TINYINT(1) NOT NULL'); |
||
| 614 | } |
||
| 615 | |||
| 616 | $table = $schema->getTable('c_group_info'); |
||
| 617 | if (!$table->hasColumn('document_access')) { |
||
| 618 | $this->addSql('ALTER TABLE c_group_info ADD document_access INT DEFAULT 0 NOT NULL;'); |
||
| 619 | } |
||
| 620 | |||
| 621 | $table = $schema->getTable('c_group_category'); |
||
| 622 | if (!$table->hasColumn('document_access')) { |
||
| 623 | $this->addSql('ALTER TABLE c_group_category ADD document_access INT DEFAULT 0 NOT NULL;'); |
||
| 624 | } |
||
| 625 | |||
| 626 | $table = $schema->getTable('c_quiz'); |
||
| 627 | if (!$table->hasColumn('autolaunch')) { |
||
| 628 | $this->addSql('ALTER TABLE c_quiz ADD autolaunch TINYINT(1) DEFAULT 0'); |
||
| 629 | } |
||
| 630 | |||
| 631 | $table = $schema->getTable('usergroup'); |
||
| 632 | if (!$table->hasColumn('author_id')) { |
||
| 633 | $this->addSql('ALTER TABLE usergroup ADD author_id INT DEFAULT NULL'); |
||
| 634 | } |
||
| 635 | |||
| 636 | $this->addSql('ALTER TABLE c_group_info ADD CONSTRAINT FK_CE06532491D79BD3 FOREIGN KEY (c_id) REFERENCES course (id);'); |
||
| 637 | |||
| 638 | $this->addSql('ALTER TABLE course_category CHANGE auth_course_child auth_course_child VARCHAR(40) DEFAULT NULL'); |
||
| 639 | $this->addSql('ALTER TABLE extra_field ADD description LONGTEXT DEFAULT NULL'); |
||
| 640 | |||
| 641 | // WIP: Document - resource |
||
| 642 | $this->addSql('ALTER TABLE c_document CHANGE c_id c_id INT DEFAULT NULL'); |
||
| 643 | $this->addSql('ALTER TABLE c_document ADD CONSTRAINT FK_C9FA0CBD91D79BD3 FOREIGN KEY (c_id) REFERENCES course (id)'); |
||
| 644 | |||
| 645 | $this->addSql('ALTER TABLE c_document ADD resource_node_id INT DEFAULT NULL'); |
||
| 646 | $this->addSql('ALTER TABLE c_document ADD CONSTRAINT FK_C9FA0CBD1BAD783F FOREIGN KEY (resource_node_id) REFERENCES resource_node (id);'); |
||
| 647 | $this->addSql('CREATE UNIQUE INDEX UNIQ_C9FA0CBD1BAD783F ON c_document (resource_node_id)'); |
||
| 648 | |||
| 649 | $this->addSql('ALTER TABLE c_document CHANGE session_id session_id INT DEFAULT NULL;'); |
||
| 650 | $this->addSql('UPDATE c_document SET session_id = null WHERE session_id = 0'); |
||
| 651 | $this->addSql('ALTER TABLE c_document ADD CONSTRAINT FK_C9FA0CBD613FECDF FOREIGN KEY (session_id) REFERENCES session (id)'); |
||
| 652 | $this->addSql('CREATE INDEX IDX_C9FA0CBD613FECDF ON c_document (session_id)'); |
||
| 653 | |||
| 654 | $this->addSql('ALTER TABLE access_url_rel_course_category CHANGE access_url_id access_url_id INT DEFAULT NULL, CHANGE course_category_id course_category_id INT DEFAULT NULL'); |
||
| 655 | $this->addSql('ALTER TABLE access_url_rel_course_category ADD CONSTRAINT FK_3545C2A673444FD5 FOREIGN KEY (access_url_id) REFERENCES access_url (id)'); |
||
| 656 | $this->addSql('ALTER TABLE access_url_rel_course_category ADD CONSTRAINT FK_3545C2A66628AD36 FOREIGN KEY (course_category_id) REFERENCES course_category (id)'); |
||
| 657 | $this->addSql('CREATE INDEX IDX_3545C2A673444FD5 ON access_url_rel_course_category (access_url_id)'); |
||
| 658 | $this->addSql('CREATE INDEX IDX_3545C2A66628AD36 ON access_url_rel_course_category (course_category_id)'); |
||
| 659 | |||
| 660 | $this->addSql('ALTER TABLE gradebook_category CHANGE user_id user_id INT DEFAULT NULL'); |
||
| 661 | $this->addSql('DELETE FROM gradebook_category WHERE user_id IS NOT NULL AND user_id NOT IN (SELECT id FROM user)'); |
||
| 662 | $this->addSql('ALTER TABLE gradebook_category ADD CONSTRAINT FK_96A4C705A76ED395 FOREIGN KEY (user_id) REFERENCES user (id)'); |
||
| 663 | $this->addSql('CREATE INDEX IDX_96A4C705A76ED395 ON gradebook_category (user_id)'); |
||
| 664 | |||
| 665 | $this->addSql('ALTER TABLE access_url_rel_usergroup CHANGE access_url_id access_url_id INT DEFAULT NULL'); |
||
| 666 | $this->addSql('ALTER TABLE access_url_rel_usergroup ADD CONSTRAINT FK_AD488DD573444FD5 FOREIGN KEY (access_url_id) REFERENCES access_url (id)'); |
||
| 667 | $this->addSql('CREATE INDEX IDX_AD488DD573444FD5 ON access_url_rel_usergroup (access_url_id)'); |
||
| 668 | |||
| 669 | $this->addSql('DELETE FROM track_e_exercises WHERE exe_user_id = 0 OR exe_user_id IS NULL'); |
||
| 670 | $this->addSql('ALTER TABLE track_e_exercises CHANGE exe_user_id exe_user_id INT NOT NULL'); |
||
| 671 | |||
| 672 | $this->addSql('UPDATE track_e_exercises SET session_id = 0 WHERE session_id IS NULL'); |
||
| 673 | $this->addSql('ALTER TABLE track_e_exercises CHANGE session_id session_id INT NOT NULL'); |
||
| 674 | $this->addSql('ALTER TABLE settings_current CHANGE access_url access_url INT DEFAULT NULL'); |
||
| 675 | |||
| 676 | // Update template |
||
| 677 | $this->addSql('DELETE FROM templates WHERE course_code NOT IN (SELECT code FROM course)'); |
||
| 678 | $this->addSql('ALTER TABLE templates ADD c_id INT DEFAULT NULL'); |
||
| 679 | $this->addSql('CREATE INDEX IDX_6F287D8E91D79BD3 ON templates (c_id)'); |
||
| 680 | $this->addSql('ALTER TABLE templates ADD CONSTRAINT FK_6F287D8E91D79BD3 FOREIGN KEY (c_id) REFERENCES course (id)'); |
||
| 681 | $this->addSql('UPDATE templates SET c_id = (SELECT id FROM course WHERE code = course_code)'); |
||
| 682 | |||
| 683 | $this->addSql('DELETE FROM gradebook_result_log WHERE id_result IS NULL'); |
||
| 684 | $this->addSql('ALTER TABLE gradebook_result_log CHANGE id_result result_id INT NOT NULL'); |
||
| 685 | |||
| 686 | $this->addSql('ALTER TABLE c_group_info CHANGE category_id category_id INT DEFAULT NULL'); |
||
| 687 | |||
| 688 | $this->addSql('ALTER TABLE c_quiz_question_category ADD session_id INT DEFAULT NULL'); |
||
| 689 | $this->addSql('CREATE INDEX IDX_1414369D613FECDF ON c_quiz_question_category (session_id)'); |
||
| 690 | $this->addSql('ALTER TABLE c_quiz_question_category ADD CONSTRAINT FK_1414369D613FECDF FOREIGN KEY (session_id) REFERENCES session (id)'); |
||
| 691 | |||
| 692 | $this->addSql('ALTER TABLE track_e_attempt CHANGE c_id c_id INT DEFAULT NULL'); |
||
| 693 | $this->addSql('ALTER TABLE track_e_attempt ADD CONSTRAINT FK_F8C342C391D79BD3 FOREIGN KEY (c_id) REFERENCES course (id)'); |
||
| 694 | |||
| 695 | $this->addSql('ALTER TABLE track_e_hotspot ADD CONSTRAINT FK_A89CC3B691D79BD3 FOREIGN KEY (c_id) REFERENCES course (id)'); |
||
| 696 | $this->addSql('CREATE INDEX IDX_A89CC3B691D79BD3 ON track_e_hotspot (c_id)'); |
||
| 697 | |||
| 698 | $this->addSql('ALTER TABLE track_e_hotpotatoes CHANGE exe_result score SMALLINT NOT NULL'); |
||
| 699 | $this->addSql('ALTER TABLE track_e_hotpotatoes CHANGE exe_weighting max_score SMALLINT NOT NULL'); |
||
| 700 | $this->addSql('ALTER TABLE track_e_exercises CHANGE exe_weighting max_score DOUBLE PRECISION NOT NULL'); |
||
| 701 | $this->addSql('ALTER TABLE track_e_exercises CHANGE exe_result score DOUBLE PRECISION NOT NULL'); |
||
| 702 | |||
| 703 | // Drop unused columns |
||
| 704 | $dropColumnsAndIndex = [ |
||
| 705 | 'track_e_uploads' => ['columns' => ['upload_cours_id'], 'index' => ['upload_cours_id']], |
||
| 706 | 'track_e_hotspot' => ['columns' => ['hotspot_course_code'], 'index' => ['hotspot_course_code']], |
||
| 707 | 'templates' => ['columns' => ['course_code'], 'index' => []], |
||
| 708 | ]; |
||
| 709 | |||
| 710 | foreach ($dropColumnsAndIndex as $tableName => $data) { |
||
| 711 | if ($schema->hasTable($tableName)) { |
||
| 712 | $indexList = $data['index']; |
||
| 713 | foreach ($indexList as $index) { |
||
| 714 | if ($table->hasIndex($index)) { |
||
| 715 | $table->dropIndex($index); |
||
| 716 | } |
||
| 717 | } |
||
| 718 | |||
| 719 | $columns = $data['columns']; |
||
| 720 | $table = $schema->getTable($tableName); |
||
| 721 | foreach ($columns as $column) { |
||
| 722 | if ($table->hasColumn($column)) { |
||
| 723 | $table->dropColumn($column); |
||
| 724 | } |
||
| 725 | } |
||
| 726 | } |
||
| 727 | } |
||
| 728 | |||
| 729 | // Drop unused tables |
||
| 730 | $dropTables = ['event_email_template', 'event_sent', 'user_rel_event_type', 'openid_association']; |
||
| 731 | foreach ($dropTables as $table) { |
||
| 732 | if ($schema->hasTable($table)) { |
||
| 733 | $schema->dropTable($table); |
||
| 734 | } |
||
| 735 | } |
||
| 736 | } |
||
| 737 | |||
| 738 | /** |
||
| 739 | * |
||
| 740 | * @param Schema $schema |
||
| 741 | */ |
||
| 742 | public function down(Schema $schema) |
||
| 744 | } |
||
| 745 | } |
||
| 746 |
