app/DoctrineMigrations/Version20150917142245.php 1 location
|
@@ 11-35 (lines=25) @@
|
| 8 |
|
/** |
| 9 |
|
* Auto-generated Migration: Please modify to your needs! |
| 10 |
|
*/ |
| 11 |
|
class Version20150917142245 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 performance_schedule ADD venue VARCHAR(255) NOT NULL'); |
| 22 |
|
$this->addSql("UPDATE performance_schedule SET venue='venue-theatre' WHERE datetime < date('2015-07-01')"); |
| 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 performance_schedule DROP venue'); |
| 34 |
|
} |
| 35 |
|
} |
| 36 |
|
|
app/DoctrineMigrations/Version20160503093009.php 1 location
|
@@ 11-34 (lines=24) @@
|
| 8 |
|
/** |
| 9 |
|
* Auto-generated Migration: Please modify to your needs! |
| 10 |
|
*/ |
| 11 |
|
class Version20160503093009 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 posts ADD pinned TINYINT(1) NOT NULL'); |
| 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('ALTER TABLE posts DROP pinned'); |
| 33 |
|
} |
| 34 |
|
} |
| 35 |
|
|
app/DoctrineMigrations/Version20170413142045.php 1 location
|
@@ 11-34 (lines=24) @@
|
| 8 |
|
/** |
| 9 |
|
* Auto-generated Migration: Please modify to your needs! |
| 10 |
|
*/ |
| 11 |
|
class Version20170413142045 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 users ADD role VARCHAR(50) NOT NULL'); |
| 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('ALTER TABLE users DROP role'); |
| 33 |
|
} |
| 34 |
|
} |
| 35 |
|
|
app/DoctrineMigrations/Version20170425025041.php 1 location
|
@@ 11-34 (lines=24) @@
|
| 8 |
|
/** |
| 9 |
|
* Auto-generated Migration: Please modify to your needs! |
| 10 |
|
*/ |
| 11 |
|
class Version20170425025041 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 Swindler (id INT AUTO_INCREMENT NOT NULL, ip VARCHAR(20) NOT NULL, countAttempts INT NOT NULL, ban TINYINT(1) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB'); |
| 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('DROP TABLE Swindler'); |
| 33 |
|
} |
| 34 |
|
} |
| 35 |
|
|
app/DoctrineMigrations/Version20170426030657.php 1 location
|
@@ 11-34 (lines=24) @@
|
| 8 |
|
/** |
| 9 |
|
* Auto-generated Migration: Please modify to your needs! |
| 10 |
|
*/ |
| 11 |
|
class Version20170426030657 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 Swindler CHANGE ban banned TINYINT(1) NOT NULL'); |
| 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('ALTER TABLE Swindler CHANGE banned ban TINYINT(1) NOT NULL'); |
| 33 |
|
} |
| 34 |
|
} |
| 35 |
|
|
app/DoctrineMigrations/Version20170426032357.php 1 location
|
@@ 11-34 (lines=24) @@
|
| 8 |
|
/** |
| 9 |
|
* Auto-generated Migration: Please modify to your needs! |
| 10 |
|
*/ |
| 11 |
|
class Version20170426032357 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 UNIQUE INDEX UNIQ_34C3EDE3A5E3B32D ON Swindler (ip)'); |
| 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('DROP INDEX UNIQ_34C3EDE3A5E3B32D ON swindler'); |
| 33 |
|
} |
| 34 |
|
} |
| 35 |
|
|
geekhub-php /
CheTheatre
