OpenConext /
Stepup-Gateway
| @@ 11-34 (lines=24) @@ | ||
| 8 | /** |
|
| 9 | * Auto-generated Migration: Please modify to your needs! |
|
| 10 | */ |
|
| 11 | class Version20150902154411 extends Migration |
|
| 12 | { |
|
| 13 | /** |
|
| 14 | * @param Schema $schema |
|
| 15 | */ |
|
| 16 | public function up(Schema $schema) |
|
| 17 | { |
|
| 18 | // this up() migration is auto-generated, please modify it to your needs |
|
| 19 | $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.'); |
|
| 20 | ||
| 21 | $this->addSql(sprintf('CREATE TABLE %s.registration (key_handle VARCHAR(255) NOT NULL, public_key VARCHAR(255) NOT NULL, sign_counter INT NOT NULL, PRIMARY KEY(key_handle)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB', $this->getQuotedU2fSchema())); |
|
| 22 | } |
|
| 23 | ||
| 24 | /** |
|
| 25 | * @param Schema $schema |
|
| 26 | */ |
|
| 27 | public function down(Schema $schema) |
|
| 28 | { |
|
| 29 | // this down() migration is auto-generated, please modify it to your needs |
|
| 30 | $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.'); |
|
| 31 | ||
| 32 | $this->addSql(sprintf('DROP TABLE %s.registration', $this->getQuotedU2fSchema())); |
|
| 33 | } |
|
| 34 | } |
|
| 35 | ||
| @@ 11-34 (lines=24) @@ | ||
| 8 | /** |
|
| 9 | * Auto-generated Migration: Please modify to your needs! |
|
| 10 | */ |
|
| 11 | class Version20150907112719 extends Migration |
|
| 12 | { |
|
| 13 | /** |
|
| 14 | * @param Schema $schema |
|
| 15 | */ |
|
| 16 | public function up(Schema $schema) |
|
| 17 | { |
|
| 18 | // this up() migration is auto-generated, please modify it to your needs |
|
| 19 | $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.'); |
|
| 20 | ||
| 21 | $this->addSql(sprintf('ALTER TABLE %s.registration ADD last_used DATETIME NOT NULL, CHANGE key_handle key_handle VARCHAR(255) NOT NULL, CHANGE public_key public_key VARCHAR(255) NOT NULL', $this->getQuotedU2fSchema())); |
|
| 22 | } |
|
| 23 | ||
| 24 | /** |
|
| 25 | * @param Schema $schema |
|
| 26 | */ |
|
| 27 | public function down(Schema $schema) |
|
| 28 | { |
|
| 29 | // this down() migration is auto-generated, please modify it to your needs |
|
| 30 | $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.'); |
|
| 31 | ||
| 32 | $this->addSql(sprintf('ALTER TABLE %s.registration DROP last_used, CHANGE key_handle key_handle VARCHAR(255) NOT NULL COLLATE utf8_unicode_ci, CHANGE public_key public_key VARCHAR(255) NOT NULL COLLATE utf8_unicode_ci', $this->getQuotedU2fSchema())); |
|
| 33 | } |
|
| 34 | } |
|
| 35 | ||
