|
1
|
|
|
<?php declare(strict_types=1); |
|
2
|
|
|
|
|
3
|
|
|
namespace App\Migrations; |
|
4
|
|
|
|
|
5
|
|
|
use Doctrine\DBAL\Schema\Schema; |
|
6
|
|
|
use Doctrine\Migrations\AbstractMigration; |
|
7
|
|
|
|
|
8
|
|
|
/** |
|
9
|
|
|
* Auto-generated Migration: Please modify to your needs! |
|
10
|
|
|
*/ |
|
11
|
|
|
final class Version20180612083807 extends AbstractMigration |
|
12
|
|
|
{ |
|
13
|
|
|
public function up(Schema $schema) : void |
|
14
|
|
|
{ |
|
15
|
|
|
// this up() migration is auto-generated, please modify it to your needs |
|
16
|
|
|
$this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.'); |
|
17
|
|
|
|
|
18
|
|
|
$this->addSql('ALTER TABLE project__beta_testers DROP FOREIGN KEY FK_BE779174986077B'); |
|
19
|
|
|
$this->addSql('DROP TABLE developtech_agility__beta_testers'); |
|
20
|
|
|
$this->addSql('DROP TABLE project__repositories__github'); |
|
21
|
|
|
$this->addSql('ALTER TABLE project__projects DROP FOREIGN KEY FK_B71CBD7BB58C0B6E'); |
|
22
|
|
|
$this->addSql('ALTER TABLE project__projects ADD CONSTRAINT FK_636FB313B58C0B6E FOREIGN KEY (product_owner_id) REFERENCES users__product_owner (id)'); |
|
23
|
|
|
$this->addSql('ALTER TABLE project__projects RENAME INDEX uniq_b71cbd7b5e237e06 TO UNIQ_636FB3135E237E06'); |
|
24
|
|
|
$this->addSql('ALTER TABLE project__projects RENAME INDEX uniq_b71cbd7b989d9b62 TO UNIQ_636FB313989D9B62'); |
|
25
|
|
|
$this->addSql('ALTER TABLE project__projects RENAME INDEX idx_b71cbd7bb58c0b6e TO IDX_636FB313B58C0B6E'); |
|
26
|
|
|
$this->addSql('ALTER TABLE project__projects RENAME INDEX idx_b71cbd7b32c8a3de TO IDX_636FB31332C8A3DE'); |
|
27
|
|
|
$this->addSql('ALTER TABLE project__jobs RENAME INDEX idx_1d411d77166d1f9c TO IDX_E6E31440166D1F9C'); |
|
28
|
|
|
$this->addSql('ALTER TABLE project__features DROP FOREIGN KEY FK_544FD2CC602AD315'); |
|
29
|
|
|
$this->addSql('DROP INDEX IDX_544FD2CC602AD315 ON project__features'); |
|
30
|
|
|
$this->addSql('ALTER TABLE project__features DROP responsible_id'); |
|
31
|
|
|
$this->addSql('ALTER TABLE project__beta_tests RENAME INDEX idx_ed350ed2166d1f9c TO IDX_A7A91609166D1F9C'); |
|
32
|
|
|
$this->addSql('DROP INDEX IDX_BE779174986077B ON project__beta_testers'); |
|
33
|
|
|
$this->addSql('ALTER TABLE project__beta_testers DROP PRIMARY KEY'); |
|
34
|
|
|
$this->addSql('ALTER TABLE project__beta_testers CHANGE beta_tester_model_id beta_tester_id INT NOT NULL'); |
|
35
|
|
|
$this->addSql('ALTER TABLE project__beta_testers ADD CONSTRAINT FK_A8615F7E204E40D7 FOREIGN KEY (beta_tester_id) REFERENCES users__beta_tester (id) ON DELETE CASCADE'); |
|
36
|
|
|
$this->addSql('CREATE INDEX IDX_A8615F7E204E40D7 ON project__beta_testers (beta_tester_id)'); |
|
37
|
|
|
$this->addSql('ALTER TABLE project__beta_testers ADD PRIMARY KEY (beta_test_id, beta_tester_id)'); |
|
38
|
|
|
$this->addSql('ALTER TABLE project__beta_testers RENAME INDEX idx_be77917425b284ca TO IDX_A8615F7E25B284CA'); |
|
39
|
|
|
$this->addSql('ALTER TABLE project__feedbacks DROP FOREIGN KEY FK_68EB7FC2602AD315'); |
|
40
|
|
|
$this->addSql('DROP INDEX IDX_68EB7FC2602AD315 ON project__feedbacks'); |
|
41
|
|
|
$this->addSql('ALTER TABLE project__feedbacks DROP responsible_id'); |
|
42
|
|
|
$this->addSql('ALTER TABLE project__feedbacks RENAME INDEX idx_68eb7fc2f675f31b TO IDX_2B56E5A6F675F31B'); |
|
43
|
|
|
$this->addSql('ALTER TABLE project__repositories__repository ADD name VARCHAR(255) NOT NULL, ADD slug VARCHAR(255) NOT NULL, ADD created_at DATETIME NOT NULL, ADD updated_at DATETIME NOT NULL, DROP type, CHANGE project_id project_id INT DEFAULT NULL'); |
|
44
|
|
|
$this->addSql('ALTER TABLE project__repositories__repository RENAME INDEX idx_351fae0b166d1f9c TO IDX_6D694AD8166D1F9C'); |
|
45
|
|
|
$this->addSql('ALTER TABLE project__news RENAME INDEX idx_d577bd75166d1f9c TO IDX_53A3E0D5166D1F9C'); |
|
46
|
|
|
|
|
47
|
|
|
} |
|
48
|
|
|
|
|
49
|
|
|
public function down(Schema $schema) : void |
|
50
|
|
|
{ |
|
51
|
|
|
// this down() migration is auto-generated, please modify it to your needs |
|
52
|
|
|
$this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.'); |
|
53
|
|
|
|
|
54
|
|
|
$this->addSql('CREATE TABLE developtech_agility__beta_testers (id INT AUTO_INCREMENT NOT NULL, account_id INT DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, UNIQUE INDEX UNIQ_D9C191609B6B5FBA (account_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB'); |
|
55
|
|
|
$this->addSql('CREATE TABLE project__repositories__github (id INT NOT NULL, owner VARCHAR(255) NOT NULL COLLATE utf8_unicode_ci, owner_type VARCHAR(15) NOT NULL COLLATE utf8_unicode_ci, name VARCHAR(255) NOT NULL COLLATE utf8_unicode_ci, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB'); |
|
56
|
|
|
$this->addSql('ALTER TABLE developtech_agility__beta_testers ADD CONSTRAINT FK_D9C191609B6B5FBA FOREIGN KEY (account_id) REFERENCES users__user (id)'); |
|
57
|
|
|
$this->addSql('ALTER TABLE project__repositories__github ADD CONSTRAINT FK_7E6C0ED3BF396750 FOREIGN KEY (id) REFERENCES project__repositories__repository (id) ON DELETE CASCADE'); |
|
58
|
|
|
$this->addSql('ALTER TABLE project__beta_testers DROP FOREIGN KEY FK_A8615F7E204E40D7'); |
|
59
|
|
|
$this->addSql('DROP INDEX IDX_A8615F7E204E40D7 ON project__beta_testers'); |
|
60
|
|
|
$this->addSql('ALTER TABLE project__beta_testers DROP PRIMARY KEY'); |
|
61
|
|
|
$this->addSql('ALTER TABLE project__beta_testers CHANGE beta_tester_id beta_tester_model_id INT NOT NULL'); |
|
62
|
|
|
$this->addSql('ALTER TABLE project__beta_testers ADD CONSTRAINT FK_BE779174986077B FOREIGN KEY (beta_tester_model_id) REFERENCES developtech_agility__beta_testers (id) ON DELETE CASCADE'); |
|
63
|
|
|
$this->addSql('CREATE INDEX IDX_BE779174986077B ON project__beta_testers (beta_tester_model_id)'); |
|
64
|
|
|
$this->addSql('ALTER TABLE project__beta_testers ADD PRIMARY KEY (beta_test_id, beta_tester_model_id)'); |
|
65
|
|
|
$this->addSql('ALTER TABLE project__beta_testers RENAME INDEX idx_a8615f7e25b284ca TO IDX_BE77917425B284CA'); |
|
66
|
|
|
$this->addSql('ALTER TABLE project__beta_tests RENAME INDEX idx_a7a91609166d1f9c TO IDX_ED350ED2166D1F9C'); |
|
67
|
|
|
$this->addSql('ALTER TABLE project__features ADD responsible_id INT DEFAULT NULL'); |
|
68
|
|
|
$this->addSql('ALTER TABLE project__features ADD CONSTRAINT FK_544FD2CC602AD315 FOREIGN KEY (responsible_id) REFERENCES users__user (id)'); |
|
69
|
|
|
$this->addSql('CREATE INDEX IDX_544FD2CC602AD315 ON project__features (responsible_id)'); |
|
70
|
|
|
$this->addSql('ALTER TABLE project__feedbacks ADD responsible_id INT DEFAULT NULL'); |
|
71
|
|
|
$this->addSql('ALTER TABLE project__feedbacks ADD CONSTRAINT FK_68EB7FC2602AD315 FOREIGN KEY (responsible_id) REFERENCES users__user (id)'); |
|
72
|
|
|
$this->addSql('CREATE INDEX IDX_68EB7FC2602AD315 ON project__feedbacks (responsible_id)'); |
|
73
|
|
|
$this->addSql('ALTER TABLE project__feedbacks RENAME INDEX idx_2b56e5a6f675f31b TO IDX_68EB7FC2F675F31B'); |
|
74
|
|
|
$this->addSql('ALTER TABLE project__jobs RENAME INDEX idx_e6e31440166d1f9c TO IDX_1D411D77166D1F9C'); |
|
75
|
|
|
$this->addSql('ALTER TABLE project__news RENAME INDEX idx_53a3e0d5166d1f9c TO IDX_D577BD75166D1F9C'); |
|
76
|
|
|
$this->addSql('ALTER TABLE project__projects DROP FOREIGN KEY FK_636FB313B58C0B6E'); |
|
77
|
|
|
$this->addSql('ALTER TABLE project__projects ADD CONSTRAINT FK_B71CBD7BB58C0B6E FOREIGN KEY (product_owner_id) REFERENCES users__user (id)'); |
|
78
|
|
|
$this->addSql('ALTER TABLE project__projects RENAME INDEX uniq_636fb3135e237e06 TO UNIQ_B71CBD7B5E237E06'); |
|
79
|
|
|
$this->addSql('ALTER TABLE project__projects RENAME INDEX uniq_636fb313989d9b62 TO UNIQ_B71CBD7B989D9B62'); |
|
80
|
|
|
$this->addSql('ALTER TABLE project__projects RENAME INDEX idx_636fb313b58c0b6e TO IDX_B71CBD7BB58C0B6E'); |
|
81
|
|
|
$this->addSql('ALTER TABLE project__projects RENAME INDEX idx_636fb31332c8a3de TO IDX_B71CBD7B32C8A3DE'); |
|
82
|
|
|
$this->addSql('ALTER TABLE project__repositories__repository ADD type VARCHAR(10) NOT NULL COLLATE utf8_unicode_ci, DROP name, DROP slug, DROP created_at, DROP updated_at, CHANGE project_id project_id INT NOT NULL'); |
|
83
|
|
|
$this->addSql('ALTER TABLE project__repositories__repository RENAME INDEX idx_6d694ad8166d1f9c TO IDX_351FAE0B166D1F9C'); |
|
84
|
|
|
} |
|
85
|
|
|
} |
|
86
|
|
|
|
CraftCamp /
official-website
