geekhub-php /
CheTheatre
| @@ 11-36 (lines=26) @@ | ||
| 8 | /** |
|
| 9 | * Auto-generated Migration: Please modify to your needs! |
|
| 10 | */ |
|
| 11 | class Version20170404104648 extends AbstractMigration |
|
| 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('ALTER TABLE ticket CHANGE status status VARCHAR(15) NOT NULL'); |
|
| 22 | $this->addSql('ALTER TABLE user_order CHANGE status status VARCHAR(15) NOT NULL'); |
|
| 23 | } |
|
| 24 | ||
| 25 | /** |
|
| 26 | * @param Schema $schema |
|
| 27 | */ |
|
| 28 | public function down(Schema $schema) |
|
| 29 | { |
|
| 30 | // this down() migration is auto-generated, please modify it to your needs |
|
| 31 | $this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.'); |
|
| 32 | ||
| 33 | $this->addSql('ALTER TABLE user_order CHANGE status status VARCHAR(255) DEFAULT NULL COLLATE utf8_unicode_ci'); |
|
| 34 | $this->addSql('ALTER TABLE ticket CHANGE status status VARCHAR(255) DEFAULT NULL COLLATE utf8_unicode_ci'); |
|
| 35 | } |
|
| 36 | } |
|
| 37 | ||
| @@ 11-36 (lines=26) @@ | ||
| 8 | /** |
|
| 9 | * Auto-generated Migration: Please modify to your needs! |
|
| 10 | */ |
|
| 11 | class Version20170503121040 extends AbstractMigration |
|
| 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('CREATE TABLE Client (id INT AUTO_INCREMENT NOT NULL, ip VARCHAR(20) NOT NULL, countAttempts INT NOT NULL, banned TINYINT(1) NOT NULL, UNIQUE INDEX UNIQ_C0E80163A5E3B32D (ip), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB'); |
|
| 22 | $this->addSql('DROP TABLE Swindler'); |
|
| 23 | } |
|
| 24 | ||
| 25 | /** |
|
| 26 | * @param Schema $schema |
|
| 27 | */ |
|
| 28 | public function down(Schema $schema) |
|
| 29 | { |
|
| 30 | // this down() migration is auto-generated, please modify it to your needs |
|
| 31 | $this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.'); |
|
| 32 | ||
| 33 | $this->addSql('CREATE TABLE Swindler (id INT AUTO_INCREMENT NOT NULL, ip VARCHAR(20) NOT NULL COLLATE utf8_unicode_ci, countAttempts INT NOT NULL, banned TINYINT(1) NOT NULL, UNIQUE INDEX UNIQ_34C3EDE3A5E3B32D (ip), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB'); |
|
| 34 | $this->addSql('DROP TABLE Client'); |
|
| 35 | } |
|
| 36 | } |
|
| 37 | ||
