diff options
Diffstat (limited to 'app/DoctrineMigrations/Version20160812120952.php')
-rw-r--r-- | app/DoctrineMigrations/Version20160812120952.php | 21 |
1 files changed, 5 insertions, 16 deletions
diff --git a/app/DoctrineMigrations/Version20160812120952.php b/app/DoctrineMigrations/Version20160812120952.php index a5d11e3f..053b8d88 100644 --- a/app/DoctrineMigrations/Version20160812120952.php +++ b/app/DoctrineMigrations/Version20160812120952.php | |||
@@ -29,20 +29,10 @@ class Version20160812120952 extends AbstractMigration implements ContainerAwareI | |||
29 | */ | 29 | */ |
30 | public function up(Schema $schema) | 30 | public function up(Schema $schema) |
31 | { | 31 | { |
32 | $this->skipIf($schema->getTable($this->getTable('oauth2_clients'))->hasColumn('name'), 'It seems that you already played this migration.'); | 32 | $clientsTable = $schema->getTable($this->getTable('oauth2_clients')); |
33 | $this->skipIf($clientsTable->hasColumn('name'), 'It seems that you already played this migration.'); | ||
33 | 34 | ||
34 | switch ($this->connection->getDatabasePlatform()->getName()) { | 35 | $clientsTable->addColumn('name', 'blob'); |
35 | case 'sqlite': | ||
36 | $this->addSql('ALTER TABLE '.$this->getTable('oauth2_clients').' ADD name longtext DEFAULT NULL'); | ||
37 | break; | ||
38 | |||
39 | case 'mysql': | ||
40 | $this->addSql('ALTER TABLE '.$this->getTable('oauth2_clients').' ADD name longtext COLLATE \'utf8_unicode_ci\' DEFAULT NULL'); | ||
41 | break; | ||
42 | |||
43 | case 'postgresql': | ||
44 | $this->addSql('ALTER TABLE '.$this->getTable('oauth2_clients').' ADD name text DEFAULT NULL'); | ||
45 | } | ||
46 | } | 36 | } |
47 | 37 | ||
48 | /** | 38 | /** |
@@ -50,8 +40,7 @@ class Version20160812120952 extends AbstractMigration implements ContainerAwareI | |||
50 | */ | 40 | */ |
51 | public function down(Schema $schema) | 41 | public function down(Schema $schema) |
52 | { | 42 | { |
53 | $this->skipIf($this->connection->getDatabasePlatform()->getName() == 'sqlite', 'Migration can only be executed safely on \'mysql\' or \'postgresql\'.'); | 43 | $clientsTable = $schema->getTable($this->getTable('oauth2_clients')); |
54 | 44 | $clientsTable->dropColumn('name'); | |
55 | $this->addSql('ALTER TABLE '.$this->getTable('oauth2_clients').' DROP COLUMN name'); | ||
56 | } | 45 | } |
57 | } | 46 | } |