migrations/Version20171204141204.php line 1
<?php
namespace DoctrineMigrations;
use Doctrine\DBAL\Schema\Schema;
use Doctrine\Migrations\AbstractMigration;
/**
* this was done manually (drop news etc)
*/
class Version20171204141204 extends AbstractMigration
{
/**
* @param Schema $schema
*/
public function up(Schema $schema) : void
{
// this up() migration is auto-generated, please modify it to your needs
$this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'postgresql', 'Migration can only be executed safely on \'postgresql\'.');
/* $this->addSql('ALTER TABLE news_news_cat DROP CONSTRAINT fk_news_news_cat_news_cat');
$this->addSql('ALTER TABLE news_news_cat DROP CONSTRAINT fk_news_news_cat_news');
$this->addSql('DROP TABLE news_cat');
$this->addSql('DROP TABLE news_news_cat');
$this->addSql('DROP TABLE news');
$this->addSql('DROP SEQUENCE seq_news_id CASCADE');
$this->addSql('DROP SEQUENCE seq_news_cat_id CASCADE');*/
}
/**
* @param Schema $schema
*/
public function down(Schema $schema) : void
{
// this down() migration is auto-generated, please modify it to your needs
$this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'postgresql', 'Migration can only be executed safely on \'postgresql\'.');
//$this->addSql('CREATE SCHEMA public');
/* $this->addSql('CREATE TABLE news_cat (id INT NOT NULL, name VARCHAR(255) NOT NULL, type INT DEFAULT 0 NOT NULL, auth_type INT DEFAULT 0 NOT NULL, state BOOLEAN DEFAULT \'false\' NOT NULL, created_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, lastmod_at TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, is_deleted BOOLEAN DEFAULT \'false\' NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE TABLE news_news_cat (news_cat_id INT NOT NULL, news_id INT NOT NULL, PRIMARY KEY(news_cat_id, news_id))');
$this->addSql('CREATE INDEX IDX_6AD78FDB6A046A37 ON news_news_cat (news_cat_id)');
$this->addSql('CREATE INDEX IDX_6AD78FDBB5A459A0 ON news_news_cat (news_id)');
$this->addSql('CREATE TABLE news (id INT NOT NULL, users_id INT DEFAULT NULL, title VARCHAR(255) NOT NULL, header TEXT DEFAULT NULL, body TEXT DEFAULT NULL, footer VARCHAR(255) DEFAULT NULL, keywords VARCHAR(255) DEFAULT NULL, attach_file VARCHAR(255) DEFAULT NULL, start_from TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, end_to TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, place VARCHAR(255) DEFAULT NULL, price_info VARCHAR(255) DEFAULT NULL, limits INT DEFAULT NULL, valid_from DATE DEFAULT NULL, valid_to DATE DEFAULT NULL, special_fnc BOOLEAN DEFAULT NULL, special_fnc_val TEXT DEFAULT NULL, language VARCHAR(2) DEFAULT \'cs\', state BOOLEAN DEFAULT \'false\' NOT NULL, created_at TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, lastmod_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, is_deleted BOOLEAN NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE INDEX users_id ON news (users_id)');
$this->addSql('COMMENT ON COLUMN news.users_id IS \'ID\'');
$this->addSql('ALTER TABLE news_news_cat ADD CONSTRAINT fk_news_news_cat_news_cat FOREIGN KEY (news_cat_id) REFERENCES news_cat (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE news_news_cat ADD CONSTRAINT fk_news_news_cat_news FOREIGN KEY (news_id) REFERENCES news (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE news ADD CONSTRAINT FK_1DD3995067B3B43D FOREIGN KEY (users_id) REFERENCES users (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('CREATE SEQUENCE seq_news_id INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE seq_news_cat_id INCREMENT BY 1 MINVALUE 1 START 1');*/
}
}