chamilo /
chamilo-lms
| Conditions | 33 |
| Paths | 0 |
| Total Lines | 343 |
| Code Lines | 198 |
| Lines | 0 |
| Ratio | 0 % |
| Changes | 1 | ||
| Bugs | 1 | Features | 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 |
||
| 15 | public function up(Schema $schema): void |
||
| 16 | { |
||
| 17 | if (false === $schema->hasTable('tool')) { |
||
| 18 | $this->addSql( |
||
| 19 | 'CREATE TABLE IF NOT EXISTS tool (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;' |
||
| 20 | ); |
||
| 21 | $this->addSql('CREATE UNIQUE INDEX UNIQ_20F33ED15E237E06 ON tool (name)'); |
||
| 22 | } |
||
| 23 | |||
| 24 | if (false === $schema->hasTable('resource_node')) { |
||
| 25 | $this->addSql( |
||
| 26 | 'CREATE TABLE IF NOT EXISTS resource_node (id INT AUTO_INCREMENT NOT NULL, resource_type_id INT NOT NULL, resource_file_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_8A5F48FF98EC6B7B (resource_type_id), UNIQUE INDEX UNIQ_8A5F48FFCE6B9E84 (resource_file_id), INDEX IDX_8A5F48FF61220EA6 (creator_id), INDEX IDX_8A5F48FF727ACA70 (parent_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB ROW_FORMAT = DYNAMIC;' |
||
| 27 | ); |
||
| 28 | |||
| 29 | $this->addSql( |
||
| 30 | 'ALTER TABLE resource_node ADD slug VARCHAR(255) NOT NULL, ADD uuid BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid)\', CHANGE creator_id creator_id INT DEFAULT NULL, CHANGE path path LONGTEXT DEFAULT NULL, CHANGE name title VARCHAR(255) NOT NULL' |
||
| 31 | ); |
||
| 32 | $this->addSql('CREATE UNIQUE INDEX UNIQ_8A5F48FFD17F50A6 ON resource_node (uuid)'); |
||
| 33 | } |
||
| 34 | |||
| 35 | if (false === $schema->hasTable('resource_link')) { |
||
| 36 | $this->addSql( |
||
| 37 | 'CREATE TABLE 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, visibility INT NOT 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 utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB ROW_FORMAT = DYNAMIC;' |
||
| 38 | ); |
||
| 39 | } |
||
| 40 | |||
| 41 | if (false === $schema->hasTable('resource_comment')) { |
||
| 42 | $this->addSql( |
||
| 43 | 'CREATE TABLE resource_comment (id INT AUTO_INCREMENT NOT NULL, resource_node_id INT DEFAULT NULL, author_id INT DEFAULT NULL, parent_id INT DEFAULT NULL, content VARCHAR(255) NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, root INT DEFAULT NULL, lvl INT NOT NULL, lft INT NOT NULL, rgt INT NOT NULL, INDEX IDX_C9D4B5841BAD783F (resource_node_id), INDEX IDX_C9D4B584F675F31B (author_id), INDEX IDX_C9D4B584727ACA70 (parent_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC;' |
||
| 44 | ); |
||
| 45 | $this->addSql( |
||
| 46 | 'ALTER TABLE resource_comment ADD CONSTRAINT FK_C9D4B5841BAD783F FOREIGN KEY (resource_node_id) REFERENCES resource_node (id) ON DELETE SET NULL;' |
||
| 47 | ); |
||
| 48 | $this->addSql( |
||
| 49 | 'ALTER TABLE resource_comment ADD CONSTRAINT FK_C9D4B584F675F31B FOREIGN KEY (author_id) REFERENCES user (id) ON DELETE SET NULL;' |
||
| 50 | ); |
||
| 51 | $this->addSql( |
||
| 52 | 'ALTER TABLE resource_comment ADD CONSTRAINT FK_C9D4B584727ACA70 FOREIGN KEY (parent_id) REFERENCES resource_comment (id) ON DELETE CASCADE;' |
||
| 53 | ); |
||
| 54 | |||
| 55 | $this->addSql( |
||
| 56 | 'ALTER TABLE resource_comment ADD CONSTRAINT FK_C9D4B5841BAD783F FOREIGN KEY (resource_node_id) REFERENCES resource_node (id) ON DELETE SET NULL' |
||
| 57 | ); |
||
| 58 | $this->addSql( |
||
| 59 | 'ALTER TABLE resource_comment ADD CONSTRAINT FK_C9D4B584F675F31B FOREIGN KEY (author_id) REFERENCES user (id) ON DELETE SET NULL' |
||
| 60 | ); |
||
| 61 | $this->addSql( |
||
| 62 | 'ALTER TABLE resource_comment ADD CONSTRAINT FK_C9D4B584727ACA70 FOREIGN KEY (parent_id) REFERENCES resource_comment (id) ON DELETE CASCADE' |
||
| 63 | ); |
||
| 64 | } |
||
| 65 | |||
| 66 | if (false === $schema->hasTable('resource_tag')) { |
||
| 67 | $this->addSql( |
||
| 68 | 'CREATE TABLE IF NOT EXISTS resource_tag (id INT AUTO_INCREMENT NOT NULL, author_id INT DEFAULT NULL, name VARCHAR(255) NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX IDX_23D039CAF675F31B (author_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC;' |
||
| 69 | ); |
||
| 70 | $this->addSql( |
||
| 71 | 'ALTER TABLE resource_tag ADD CONSTRAINT FK_23D039CAF675F31B FOREIGN KEY (author_id) REFERENCES user (id) ON DELETE SET NULL;' |
||
| 72 | ); |
||
| 73 | } |
||
| 74 | |||
| 75 | if (false === $schema->hasTable('resource_user_tag')) { |
||
| 76 | $this->addSql( |
||
| 77 | 'CREATE TABLE IF NOT EXISTS resource_user_tag (id INT AUTO_INCREMENT NOT NULL, user_id INT DEFAULT NULL, tag_id INT DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX IDX_46131CA5A76ED395 (user_id), INDEX IDX_46131CA5BAD26311 (tag_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC;' |
||
| 78 | ); |
||
| 79 | $this->addSql( |
||
| 80 | 'ALTER TABLE resource_user_tag ADD CONSTRAINT FK_46131CA5A76ED395 FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE SET NULL;' |
||
| 81 | ); |
||
| 82 | $this->addSql( |
||
| 83 | 'ALTER TABLE resource_user_tag ADD CONSTRAINT FK_46131CA5BAD26311 FOREIGN KEY (tag_id) REFERENCES resource_tag (id) ON DELETE SET NULL;' |
||
| 84 | ); |
||
| 85 | } |
||
| 86 | |||
| 87 | if (false === $schema->hasTable('personal_file')) { |
||
| 88 | $this->addSql( |
||
| 89 | 'CREATE TABLE IF NOT EXISTS personal_file (id INT AUTO_INCREMENT NOT NULL, resource_node_id INT DEFAULT NULL, name VARCHAR(255) NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, UNIQUE INDEX UNIQ_BD95312D1BAD783F (resource_node_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC;' |
||
| 90 | ); |
||
| 91 | $this->addSql( |
||
| 92 | 'ALTER TABLE personal_file ADD CONSTRAINT FK_BD95312D1BAD783F FOREIGN KEY (resource_node_id) REFERENCES resource_node (id) ON DELETE CASCADE;' |
||
| 93 | ); |
||
| 94 | } |
||
| 95 | |||
| 96 | if (false === $schema->hasTable('resource_link')) { |
||
| 97 | $this->addSql( |
||
| 98 | 'ALTER TABLE resource_link ADD CONSTRAINT FK_398C394B1BAD783F FOREIGN KEY (resource_node_id) REFERENCES resource_node (id) ON DELETE SET NULL' |
||
| 99 | ); |
||
| 100 | |||
| 101 | $this->addSql( |
||
| 102 | 'ALTER TABLE resource_link ADD CONSTRAINT FK_398C394BFE54D947 FOREIGN KEY (group_id) REFERENCES c_group_info (iid) ON DELETE CASCADE' |
||
| 103 | ); |
||
| 104 | $this->addSql( |
||
| 105 | 'ALTER TABLE resource_link ADD CONSTRAINT FK_398C394B613FECDF FOREIGN KEY (session_id) REFERENCES session (id);' |
||
| 106 | ); |
||
| 107 | $this->addSql( |
||
| 108 | 'ALTER TABLE resource_link ADD CONSTRAINT FK_398C394BA76ED395 FOREIGN KEY (user_id) REFERENCES user (id);' |
||
| 109 | ); |
||
| 110 | $this->addSql( |
||
| 111 | 'ALTER TABLE resource_link ADD CONSTRAINT FK_398C394B91D79BD3 FOREIGN KEY (c_id) REFERENCES course (id);' |
||
| 112 | ); |
||
| 113 | $this->addSql( |
||
| 114 | 'ALTER TABLE resource_link ADD CONSTRAINT FK_398C394BD2112630 FOREIGN KEY (usergroup_id) REFERENCES usergroup (id);' |
||
| 115 | ); |
||
| 116 | } |
||
| 117 | |||
| 118 | if (false === $schema->hasTable('tool_resource_right')) { |
||
| 119 | $this->addSql( |
||
| 120 | 'CREATE TABLE IF NOT EXISTS tool_resource_right (id INT AUTO_INCREMENT NOT NULL, tool_id INT DEFAULT NULL, role VARCHAR(255) NOT NULL, mask INT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;' |
||
| 121 | ); |
||
| 122 | $this->addSql( |
||
| 123 | 'ALTER TABLE tool_resource_right ADD CONSTRAINT FK_E5C562598F7B22CC FOREIGN KEY (tool_id) REFERENCES tool (id);' |
||
| 124 | ); |
||
| 125 | } |
||
| 126 | |||
| 127 | if (false === $schema->hasTable('resource_right')) { |
||
| 128 | $this->addSql( |
||
| 129 | 'CREATE TABLE IF NOT EXISTS resource_right (id INT AUTO_INCREMENT NOT NULL, resource_link_id INT DEFAULT NULL, role VARCHAR(255) NOT NULL, mask INT NOT NULL, INDEX IDX_9F710F26F004E599 (resource_link_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB ROW_FORMAT = DYNAMIC;' |
||
| 130 | ); |
||
| 131 | $this->addSql( |
||
| 132 | 'ALTER TABLE resource_right ADD CONSTRAINT FK_9F710F26F004E599 FOREIGN KEY (resource_link_id) REFERENCES resource_link (id) ON DELETE CASCADE' |
||
| 133 | ); |
||
| 134 | } |
||
| 135 | |||
| 136 | if (false === $schema->hasTable('resource_type')) { |
||
| 137 | $this->addSql( |
||
| 138 | 'CREATE TABLE IF NOT EXISTS resource_type (id INT AUTO_INCREMENT NOT NULL, tool_id INT DEFAULT NULL, name VARCHAR(255) NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX IDX_83FEF7938F7B22CC (tool_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB ROW_FORMAT = DYNAMIC;' |
||
| 139 | ); |
||
| 140 | $this->addSql( |
||
| 141 | 'ALTER TABLE resource_type ADD CONSTRAINT FK_83FEF7938F7B22CC FOREIGN KEY (tool_id) REFERENCES tool (id);' |
||
| 142 | ); |
||
| 143 | } |
||
| 144 | |||
| 145 | $this->addSql( |
||
| 146 | 'CREATE TABLE IF NOT EXISTS resource_file (id INT AUTO_INCREMENT NOT NULL,name VARCHAR(255) NOT NULL, original_name LONGTEXT DEFAULT NULL, size INT NOT NULL, ADD dimensions LONGTEXT DEFAULT NULL COMMENT \'(DC2Type:simple_array)\',ADD crop VARCHAR(255) DEFAULT NULL, mime_type LONGTEXT DEFAULT NULL, metadata LONGTEXT DEFAULT NULL COMMENT \'(DC2Type:array)\', 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;' |
||
| 147 | ); |
||
| 148 | if (false === $schema->hasTable('resource_node')) { |
||
| 149 | $this->addSql( |
||
| 150 | 'ALTER TABLE resource_node ADD CONSTRAINT FK_8A5F48FF98EC6B7B FOREIGN KEY (resource_type_id) REFERENCES resource_type (id);' |
||
| 151 | ); |
||
| 152 | |||
| 153 | $this->addSql( |
||
| 154 | 'ALTER TABLE resource_node ADD CONSTRAINT FK_8A5F48FFCE6B9E84 FOREIGN KEY (resource_file_id) REFERENCES resource_file (id) ON DELETE CASCADE' |
||
| 155 | ); |
||
| 156 | |||
| 157 | $this->addSql( |
||
| 158 | 'ALTER TABLE resource_node ADD CONSTRAINT FK_8A5F48FF61220EA6 FOREIGN KEY (creator_id) REFERENCES user (id) ON DELETE CASCADE;' |
||
| 159 | ); |
||
| 160 | |||
| 161 | $this->addSql( |
||
| 162 | 'ALTER TABLE resource_node ADD CONSTRAINT FK_8A5F48FF727ACA70 FOREIGN KEY (parent_id) REFERENCES resource_node (id) ON DELETE CASCADE;' |
||
| 163 | ); |
||
| 164 | } |
||
| 165 | |||
| 166 | /*$table = $schema->getTable('resource_type'); |
||
| 167 | if (false === $table->hasForeignKey('FK_83BF96AAEA9FDD75')) { |
||
| 168 | $this->addSql( |
||
| 169 | 'ALTER TABLE resource_file ADD CONSTRAINT FK_83BF96AAEA9FDD75 FOREIGN KEY (media_id) REFERENCES media__media (id);' |
||
| 170 | ); |
||
| 171 | }*/ |
||
| 172 | |||
| 173 | $table = $schema->getTable('c_document'); |
||
| 174 | if (false === $table->hasColumn('resource_node_id')) { |
||
| 175 | $this->addSql('ALTER TABLE c_document ADD resource_node_id INT DEFAULT NULL'); |
||
| 176 | $this->addSql( |
||
| 177 | 'ALTER TABLE c_document ADD CONSTRAINT FK_C9FA0CBD1BAD783F FOREIGN KEY (resource_node_id) REFERENCES resource_node (id);' |
||
| 178 | ); |
||
| 179 | $this->addSql('CREATE UNIQUE INDEX UNIQ_C9FA0CBD1BAD783F ON c_document (resource_node_id);'); |
||
| 180 | } |
||
| 181 | |||
| 182 | if (false === $table->hasColumn('template')) { |
||
| 183 | $this->addSql('ALTER TABLE c_document ADD template TINYINT(1) NOT NULL'); |
||
| 184 | } |
||
| 185 | |||
| 186 | if ($table->hasColumn('id')) { |
||
| 187 | $this->addSql('ALTER TABLE c_document DROP id'); |
||
| 188 | //$this->addSql('ALTER TABLE c_document DROP id, DROP c_id, DROP path, DROP size, DROP session_id'); |
||
| 189 | } |
||
| 190 | |||
| 191 | if ($table->hasForeignKey('FK_C9FA0CBD1BAD783F')) { |
||
| 192 | $this->addSql( |
||
| 193 | 'ALTER TABLE c_document ADD CONSTRAINT FK_C9FA0CBD1BAD783F FOREIGN KEY (resource_node_id) REFERENCES resource_node (id) ON DELETE CASCADE' |
||
| 194 | ); |
||
| 195 | } |
||
| 196 | |||
| 197 | if (false === $table->hasIndex('idx_cdoc_type')) { |
||
| 198 | $this->addSql('CREATE INDEX idx_cdoc_type ON c_document (filetype)'); |
||
| 199 | } |
||
| 200 | |||
| 201 | if (false === $schema->hasTable('illustration')) { |
||
| 202 | $this->addSql( |
||
| 203 | 'CREATE TABLE illustration (id INT AUTO_INCREMENT NOT NULL, resource_node_id INT DEFAULT NULL, name VARCHAR(255) NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, UNIQUE INDEX UNIQ_D67B9A421BAD783F (resource_node_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB ROW_FORMAT = DYNAMIC;' |
||
| 204 | ); |
||
| 205 | $this->addSql( |
||
| 206 | 'ALTER TABLE illustration ADD CONSTRAINT FK_D67B9A421BAD783F FOREIGN KEY (resource_node_id) REFERENCES resource_node (id) ON DELETE CASCADE;' |
||
| 207 | ); |
||
| 208 | } |
||
| 209 | //$this->addSql('ALTER TABLE c_document CHANGE path path VARCHAR(255) DEFAULT NULL;'); |
||
| 210 | |||
| 211 | $table = $schema->getTable('c_announcement'); |
||
| 212 | if (false === $table->hasColumn('resource_node_id')) { |
||
| 213 | $this->addSql('ALTER TABLE c_announcement ADD resource_node_id INT DEFAULT NULL;'); |
||
| 214 | $this->addSql( |
||
| 215 | 'ALTER TABLE c_announcement ADD CONSTRAINT FK_39912E021BAD783F FOREIGN KEY (resource_node_id) REFERENCES resource_node (id) ON DELETE CASCADE;' |
||
| 216 | ); |
||
| 217 | $this->addSql('CREATE UNIQUE INDEX UNIQ_39912E021BAD783F ON c_announcement (resource_node_id);'); |
||
| 218 | } |
||
| 219 | |||
| 220 | |||
| 221 | $this->addSql('DROP INDEX course ON c_announcement'); |
||
| 222 | $this->addSql('DROP INDEX session_id ON c_announcement'); |
||
| 223 | $this->addSql('ALTER TABLE c_announcement DROP id, DROP c_id, DROP session_id'); |
||
| 224 | $this->addSql('DROP INDEX course ON c_announcement_attachment'); |
||
| 225 | $this->addSql( |
||
| 226 | 'ALTER TABLE c_announcement_attachment DROP c_id, CHANGE announcement_id announcement_id INT DEFAULT NULL, CHANGE id resource_node_id INT DEFAULT NULL' |
||
| 227 | ); |
||
| 228 | $this->addSql( |
||
| 229 | 'ALTER TABLE c_announcement_attachment ADD CONSTRAINT FK_5480BD4A913AEA17 FOREIGN KEY (announcement_id) REFERENCES c_announcement (iid) ON DELETE CASCADE' |
||
| 230 | ); |
||
| 231 | $this->addSql( |
||
| 232 | 'ALTER TABLE c_announcement_attachment ADD CONSTRAINT FK_5480BD4A1BAD783F FOREIGN KEY (resource_node_id) REFERENCES resource_node (id) ON DELETE CASCADE' |
||
| 233 | ); |
||
| 234 | $this->addSql('CREATE INDEX IDX_5480BD4A913AEA17 ON c_announcement_attachment (announcement_id)'); |
||
| 235 | $this->addSql('CREATE UNIQUE INDEX UNIQ_5480BD4A1BAD783F ON c_announcement_attachment (resource_node_id)'); |
||
| 236 | |||
| 237 | |||
| 238 | $table = $schema->getTable('c_link'); |
||
| 239 | if (false === $table->hasColumn('resource_node_id')) { |
||
| 240 | $this->addSql('ALTER TABLE c_link ADD resource_node_id INT DEFAULT NULL;'); |
||
| 241 | $this->addSql( |
||
| 242 | 'ALTER TABLE c_link ADD CONSTRAINT FK_9209C2A01BAD783F FOREIGN KEY (resource_node_id) REFERENCES resource_node (id) ON DELETE CASCADE;' |
||
| 243 | ); |
||
| 244 | $this->addSql('CREATE UNIQUE INDEX UNIQ_9209C2A01BAD783F ON c_link (resource_node_id);'); |
||
| 245 | } |
||
| 246 | |||
| 247 | $table = $schema->getTable('c_glossary'); |
||
| 248 | if (false === $table->hasColumn('resource_node_id')) { |
||
| 249 | $this->addSql('ALTER TABLE c_glossary ADD resource_node_id INT DEFAULT NULL'); |
||
| 250 | $this->addSql( |
||
| 251 | 'ALTER TABLE c_glossary ADD CONSTRAINT FK_A1168D881BAD783F FOREIGN KEY (resource_node_id) REFERENCES resource_node (id) ON DELETE CASCADE' |
||
| 252 | ); |
||
| 253 | $this->addSql('CREATE UNIQUE INDEX UNIQ_A1168D881BAD783F ON c_glossary (resource_node_id)'); |
||
| 254 | } |
||
| 255 | |||
| 256 | |||
| 257 | $table = $schema->getTable('c_student_publication'); |
||
| 258 | if (false === $table->hasColumn('filesize')) { |
||
| 259 | $this->addSql('ALTER TABLE c_student_publication ADD filesize INT DEFAULT NULL'); |
||
| 260 | |||
| 261 | } |
||
| 262 | $this->addSql('ALTER TABLE c_student_publication CHANGE url url VARCHAR(500) DEFAULT NULL'); |
||
| 263 | $this->addSql( |
||
| 264 | 'ALTER TABLE c_student_publication CHANGE url_correction url_correction VARCHAR(500) DEFAULT NULL' |
||
| 265 | ); |
||
| 266 | $this->addSql('ALTER TABLE c_student_publication CHANGE active active INT DEFAULT NULL'); |
||
| 267 | |||
| 268 | if (false === $table->hasColumn('resource_node_id')) { |
||
| 269 | $this->addSql( |
||
| 270 | 'ALTER TABLE c_student_publication ADD CONSTRAINT FK_5246F7461BAD783F FOREIGN KEY (resource_node_id) REFERENCES resource_node (id) ON DELETE CASCADE' |
||
| 271 | ); |
||
| 272 | $this->addSql('CREATE UNIQUE INDEX UNIQ_5246F7461BAD783F ON c_student_publication (resource_node_id)'); |
||
| 273 | } |
||
| 274 | |||
| 275 | |||
| 276 | $table = $schema->getTable('c_student_publication_assignment'); |
||
| 277 | if (false === $table->hasColumn('resource_node_id')) { |
||
| 278 | $this->addSql('ALTER TABLE c_student_publication_assignment ADD resource_node_id INT DEFAULT NULL'); |
||
| 279 | $this->addSql( |
||
| 280 | 'ALTER TABLE c_student_publication_assignment ADD CONSTRAINT FK_25687EB81BAD783F FOREIGN KEY (resource_node_id) REFERENCES resource_node (id) ON DELETE CASCADE' |
||
| 281 | ); |
||
| 282 | $this->addSql( |
||
| 283 | 'CREATE UNIQUE INDEX UNIQ_25687EB81BAD783F ON c_student_publication_assignment (resource_node_id)' |
||
| 284 | ); |
||
| 285 | } |
||
| 286 | |||
| 287 | $table = $schema->getTable('c_student_publication_comment'); |
||
| 288 | if (false === $table->hasColumn('resource_node_id')) { |
||
| 289 | $this->addSql('ALTER TABLE c_student_publication_comment ADD resource_node_id INT DEFAULT NULL'); |
||
| 290 | $this->addSql( |
||
| 291 | 'ALTER TABLE c_student_publication_comment ADD CONSTRAINT FK_35C509F61BAD783F FOREIGN KEY (resource_node_id) REFERENCES resource_node (id) ON DELETE CASCADE' |
||
| 292 | ); |
||
| 293 | $this->addSql( |
||
| 294 | 'CREATE UNIQUE INDEX UNIQ_35C509F61BAD783F ON c_student_publication_comment (resource_node_id)' |
||
| 295 | ); |
||
| 296 | } |
||
| 297 | $table = $schema->getTable('c_calendar_event'); |
||
| 298 | if (false === $table->hasColumn('resource_node_id')) { |
||
| 299 | $this->addSql('ALTER TABLE c_calendar_event ADD resource_node_id INT DEFAULT NULL'); |
||
| 300 | $this->addSql( |
||
| 301 | 'ALTER TABLE c_calendar_event ADD CONSTRAINT FK_A0622581EE3A445A FOREIGN KEY (parent_event_id) REFERENCES c_calendar_event (iid)' |
||
| 302 | ); |
||
| 303 | $this->addSql( |
||
| 304 | 'ALTER TABLE c_calendar_event ADD CONSTRAINT FK_A06225811BAD783F FOREIGN KEY (resource_node_id) REFERENCES resource_node (id) ON DELETE CASCADE' |
||
| 305 | ); |
||
| 306 | $this->addSql('CREATE INDEX IDX_A0622581EE3A445A ON c_calendar_event (parent_event_id)'); |
||
| 307 | $this->addSql('CREATE UNIQUE INDEX UNIQ_A06225811BAD783F ON c_calendar_event (resource_node_id)'); |
||
| 308 | } |
||
| 309 | |||
| 310 | $table = $schema->getTable('c_calendar_event_attachment'); |
||
| 311 | if (false === $table->hasColumn('resource_node_id')) { |
||
| 312 | $this->addSql('ALTER TABLE c_calendar_event_attachment ADD id resource_node_id INT DEFAULT NULL'); |
||
| 313 | $this->addSql( |
||
| 314 | 'ALTER TABLE c_calendar_event_attachment ADD CONSTRAINT FK_DDD745A6EA67784A FOREIGN KEY (agenda_id) REFERENCES c_calendar_event (iid) ON DELETE CASCADE' |
||
| 315 | ); |
||
| 316 | $this->addSql( |
||
| 317 | 'ALTER TABLE c_calendar_event_attachment ADD CONSTRAINT FK_DDD745A61BAD783F FOREIGN KEY (resource_node_id) REFERENCES resource_node (id) ON DELETE CASCADE' |
||
| 318 | ); |
||
| 319 | $this->addSql('CREATE INDEX IDX_DDD745A6EA67784A ON c_calendar_event_attachment (agenda_id)'); |
||
| 320 | $this->addSql( |
||
| 321 | 'CREATE UNIQUE INDEX UNIQ_DDD745A61BAD783F ON c_calendar_event_attachment (resource_node_id)' |
||
| 322 | ); |
||
| 323 | } |
||
| 324 | |||
| 325 | $table = $schema->getTable('c_calendar_event_repeat'); |
||
| 326 | $this->addSql('ALTER TABLE c_calendar_event_repeat CHANGE cal_id cal_id INT DEFAULT NULL'); |
||
| 327 | if (false === $table->hasForeignKey('FK_86FD1CA87300D633')) { |
||
| 328 | $this->addSql( |
||
| 329 | 'ALTER TABLE c_calendar_event_repeat ADD CONSTRAINT FK_86FD1CA87300D633 FOREIGN KEY (cal_id) REFERENCES c_calendar_event (iid)' |
||
| 330 | ); |
||
| 331 | } |
||
| 332 | |||
| 333 | if (false === $table->hasIndex('IDX_86FD1CA87300D633')) { |
||
| 334 | $this->addSql('CREATE INDEX IDX_86FD1CA87300D633 ON c_calendar_event_repeat (cal_id)'); |
||
| 335 | } |
||
| 336 | |||
| 337 | $this->addSql('ALTER TABLE c_calendar_event_repeat_not CHANGE cal_id cal_id INT DEFAULT NULL'); |
||
| 338 | if (false === $table->hasForeignKey('FK_7D4436947300D633')) { |
||
| 339 | |||
| 340 | $this->addSql( |
||
| 341 | 'ALTER TABLE c_calendar_event_repeat_not ADD CONSTRAINT FK_7D4436947300D633 FOREIGN KEY (cal_id) REFERENCES c_calendar_event (iid)' |
||
| 342 | ); |
||
| 343 | } |
||
| 344 | if (false === $table->hasIndex('IDX_7D4436947300D633')) { |
||
| 345 | $this->addSql('CREATE INDEX IDX_7D4436947300D633 ON c_calendar_event_repeat_not (cal_id)'); |
||
| 346 | } |
||
| 347 | |||
| 348 | |||
| 349 | if (false === $schema->hasTable('c_shortcut')) { |
||
| 350 | $this->addSql( |
||
| 351 | 'CREATE TABLE IF NOT EXISTS c_shortcut (id INT AUTO_INCREMENT NOT NULL, shortcut_node_id INT DEFAULT NULL, resource_node_id INT DEFAULT NULL, name VARCHAR(255) NOT NULL, UNIQUE INDEX UNIQ_3F6BB957937100BE (shortcut_node_id), UNIQUE INDEX UNIQ_3F6BB9571BAD783F (resource_node_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC;' |
||
| 352 | ); |
||
| 353 | $this->addSql( |
||
| 354 | 'ALTER TABLE c_shortcut ADD CONSTRAINT FK_3F6BB957937100BE FOREIGN KEY (shortcut_node_id) REFERENCES resource_node (id);' |
||
| 355 | ); |
||
| 356 | $this->addSql( |
||
| 357 | 'ALTER TABLE c_shortcut ADD CONSTRAINT FK_3F6BB9571BAD783F FOREIGN KEY (resource_node_id) REFERENCES resource_node (id) ON DELETE CASCADE;' |
||
| 358 | ); |
||
| 371 |
