* Auto-generated Migration: Please modify to your needs!
10
*/
11
class Version20160830085457 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('DROP TABLE sylius_metadata');
22
$this->addSql('DROP TABLE sylius_report');
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 sylius_metadata (id VARCHAR(255) NOT NULL COLLATE utf8_unicode_ci, metadata LONGTEXT NOT NULL COLLATE utf8_unicode_ci, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
34
$this->addSql('CREATE TABLE sylius_report (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL COLLATE utf8_unicode_ci, description LONGTEXT NOT NULL COLLATE utf8_unicode_ci, code VARCHAR(255) NOT NULL COLLATE utf8_unicode_ci, renderer VARCHAR(255) NOT NULL COLLATE utf8_unicode_ci, renderer_configuration LONGTEXT NOT NULL COLLATE utf8_unicode_ci COMMENT \'(DC2Type:array)\', data_fetcher VARCHAR(255) NOT NULL COLLATE utf8_unicode_ci, data_fetcher_configuration LONGTEXT NOT NULL COLLATE utf8_unicode_ci COMMENT \'(DC2Type:array)\', UNIQUE INDEX UNIQ_FE0E997877153098 (code), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');