|
1
|
|
|
<?php |
|
2
|
|
|
|
|
3
|
|
|
/** |
|
4
|
|
|
* Copyright 2014 SURFnet bv |
|
5
|
|
|
* |
|
6
|
|
|
* Licensed under the Apache License, Version 2.0 (the "License"); |
|
7
|
|
|
* you may not use this file except in compliance with the License. |
|
8
|
|
|
* You may obtain a copy of the License at |
|
9
|
|
|
* |
|
10
|
|
|
* http://www.apache.org/licenses/LICENSE-2.0 |
|
11
|
|
|
* |
|
12
|
|
|
* Unless required by applicable law or agreed to in writing, software |
|
13
|
|
|
* distributed under the License is distributed on an "AS IS" BASIS, |
|
14
|
|
|
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. |
|
15
|
|
|
* See the License for the specific language governing permissions and |
|
16
|
|
|
* limitations under the License. |
|
17
|
|
|
*/ |
|
18
|
|
|
|
|
19
|
|
|
namespace Surfnet\Migrations; |
|
20
|
|
|
|
|
21
|
|
|
use Doctrine\DBAL\Schema\Schema; |
|
22
|
|
|
use Doctrine\Migrations\AbstractMigration; |
|
23
|
|
|
use Surfnet\Stepup\MigrationsFactory\ConfigurationAwareMigrationInterface; |
|
24
|
|
|
use Surfnet\Stepup\MigrationsFactory\ConfigurationAwareMigrationTrait; |
|
25
|
|
|
|
|
26
|
|
|
/** |
|
27
|
|
|
* Auto-generated Migration: Please modify to your needs! |
|
28
|
|
|
*/ |
|
29
|
|
|
class Version20141210174213 extends AbstractMigration implements ConfigurationAwareMigrationInterface |
|
30
|
|
|
{ |
|
31
|
|
|
use ConfigurationAwareMigrationTrait; |
|
32
|
|
|
|
|
33
|
|
|
public function up(Schema $schema): void |
|
34
|
|
|
{ |
|
35
|
|
|
$gatewaySchema = $this->getGatewaySchema(); |
|
36
|
|
|
|
|
37
|
|
|
// this up() migration is auto-generated, please modify it to your needs |
|
38
|
|
|
$this->abortIf( |
|
39
|
|
|
$this->connection->getDatabasePlatform()->getName() != 'mysql', |
|
|
|
|
|
|
40
|
|
|
'Migration can only be executed safely on \'mysql\'.', |
|
41
|
|
|
); |
|
42
|
|
|
|
|
43
|
|
|
$this->addSql(sprintf('ALTER TABLE %s.second_factor DROP PRIMARY KEY', $gatewaySchema)); |
|
44
|
|
|
$this->addSql(sprintf('ALTER TABLE %s.second_factor ADD id INT NOT NULL FIRST', $gatewaySchema)); |
|
45
|
|
|
$this->addSql(sprintf('ALTER TABLE %s.second_factor ADD PRIMARY KEY (id)', $gatewaySchema)); |
|
46
|
|
|
$this->addSql( |
|
47
|
|
|
sprintf('ALTER TABLE %s.second_factor CHANGE id id INT AUTO_INCREMENT NOT NULL FIRST', $gatewaySchema), |
|
48
|
|
|
); |
|
49
|
|
|
} |
|
50
|
|
|
|
|
51
|
|
|
public function down(Schema $schema): void |
|
52
|
|
|
{ |
|
53
|
|
|
$gatewaySchema = $this->getGatewaySchema(); |
|
54
|
|
|
|
|
55
|
|
|
// this down() migration is auto-generated, please modify it to your needs |
|
56
|
|
|
$this->abortIf( |
|
57
|
|
|
$this->connection->getDatabasePlatform()->getName() != 'mysql', |
|
|
|
|
|
|
58
|
|
|
'Migration can only be executed safely on \'mysql\'.', |
|
59
|
|
|
); |
|
60
|
|
|
|
|
61
|
|
|
$this->addSql(sprintf('ALTER TABLE %s.second_factor DROP PRIMARY KEY', $gatewaySchema)); |
|
62
|
|
|
$this->addSql(sprintf('ALTER TABLE %s.second_factor DROP id', $gatewaySchema)); |
|
63
|
|
|
$this->addSql(sprintf('ALTER TABLE %s.second_factor ADD PRIMARY KEY (identity_id)', $gatewaySchema)); |
|
64
|
|
|
} |
|
65
|
|
|
} |
|
66
|
|
|
|
This function has been deprecated. The supplier of the function has supplied an explanatory message.
The explanatory message should give you some clue as to whether and when the function will be removed and what other function to use instead.