superdesk / web-publisher

/**

 * Auto-generated Migration: Please modify to your needs!

 */

final class Version20191113081727 extends AbstractMigration

{

    public function up(Schema $schema): void

    {

        // this up() migration is auto-generated, please modify it to your needs

        $this->abortIf('postgresql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'postgresql\'.');

        $this->addSql('DROP SEQUENCE swp_article_events_id_seq CASCADE');

        $this->addSql('DROP TABLE swp_article_events');

        $this->addSql('ALTER TABLE swp_author ALTER biography TYPE TEXT');

        $this->addSql('ALTER TABLE swp_author ALTER biography DROP DEFAULT');

        $this->addSql('ALTER TABLE swp_author ALTER biography TYPE TEXT');

        $this->addSql('ALTER TABLE swp_package ALTER genre TYPE TEXT');

        $this->addSql('ALTER TABLE swp_package ALTER genre DROP DEFAULT');

        $this->addSql('DROP INDEX swp_article_slug_null_deleted_at_idx');

        $this->addSql('DROP INDEX swp_article_slug_not_null_deleted_at_idx');

        $this->addSql('CREATE UNIQUE INDEX swp_article_slug_null_deleted_at_idx ON swp_article (

          slug, tenant_code, organization_id

        ) 

        WHERE 

          deleted_at IS NULL');

        $this->addSql('CREATE UNIQUE INDEX swp_article_slug_not_null_deleted_at_idx ON swp_article (

          slug, tenant_code, organization_id, 

          deleted_at

        ) 

        WHERE 

          deleted_at IS NOT NULL');

        $this->addSql('ALTER TABLE swp_image ALTER length TYPE DOUBLE PRECISION');

        $this->addSql('ALTER TABLE swp_image ALTER length DROP DEFAULT');

    }

    public function down(Schema $schema): void

    {

        // this down() migration is auto-generated, please modify it to your needs

        $this->abortIf('postgresql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'postgresql\'.');

        $this->addSql('CREATE SEQUENCE swp_article_events_id_seq INCREMENT BY 1 MINVALUE 1 START 1');

        $this->addSql('CREATE TABLE swp_article_events (

          id INT NOT NULL, 

          article_statistics_id INT NOT NULL, 

          route_id INT DEFAULT NULL, 

          article_id INT DEFAULT NULL, 

          action VARCHAR(255) DEFAULT NULL, 

          impression_type VARCHAR(255) DEFAULT NULL, 

          tenant_code VARCHAR(255) NOT NULL, 

          created_at TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, 

          updated_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, 

          page_view_source VARCHAR(255) DEFAULT NULL, 

          PRIMARY KEY(id)

        )');

        $this->addSql('CREATE INDEX idx_ed5f19e434ecb4e6 ON swp_article_events (route_id)');

        $this->addSql('CREATE INDEX idx_ed5f19e47294869c ON swp_article_events (article_id)');

        $this->addSql('CREATE INDEX idx_ed5f19e41dfe7a17 ON swp_article_events (article_statistics_id)');

        $this->addSql('CREATE INDEX idx_article_events ON swp_article_events (

          article_statistics_id, tenant_code, 

          created_at

        )');

        $this->addSql('ALTER TABLE 

          swp_article_events 

        ADD 

          CONSTRAINT fk_ed5f19e41dfe7a17 FOREIGN KEY (article_statistics_id) REFERENCES swp_article_statistics (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE');

        $this->addSql('ALTER TABLE 

          swp_article_events 

        ADD 

          CONSTRAINT fk_ed5f19e434ecb4e6 FOREIGN KEY (route_id) REFERENCES swp_route (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE');

        $this->addSql('ALTER TABLE 

          swp_article_events 

        ADD 

          CONSTRAINT fk_ed5f19e47294869c FOREIGN KEY (article_id) REFERENCES swp_article (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE');

        $this->addSql('ALTER TABLE swp_package ALTER genre TYPE TEXT');

        $this->addSql('ALTER TABLE swp_package ALTER genre DROP DEFAULT');

        $this->addSql('ALTER TABLE swp_image ALTER length TYPE NUMERIC(10, 0)');

        $this->addSql('ALTER TABLE swp_image ALTER length DROP DEFAULT');

        $this->addSql('DROP INDEX swp_article_slug_not_null_deleted_at_idx');

        $this->addSql('DROP INDEX swp_article_slug_null_deleted_at_idx');

        $this->addSql('CREATE UNIQUE INDEX swp_article_slug_not_null_deleted_at_idx ON swp_article (

          slug, tenant_code, organization_id, 

          deleted_at

        ) 

        WHERE 

          (deleted_at IS NOT NULL)');

        $this->addSql('CREATE UNIQUE INDEX swp_article_slug_null_deleted_at_idx ON swp_article (

          slug, tenant_code, organization_id

        ) 

        WHERE 

          (deleted_at IS NULL)');

        $this->addSql('ALTER TABLE swp_author ALTER biography TYPE VARCHAR(460)');

        $this->addSql('ALTER TABLE swp_author ALTER biography DROP DEFAULT');

    }

}

/**

 * Auto-generated Migration: Please modify to your needs!

 */

class Version20170908083733 extends AbstractMigration

{

    /**

     * @param Schema $schema

     */

    public function up(Schema $schema)

    {

        // this up() migration is auto-generated, please modify it to your needs

        $this->abortIf('postgresql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'postgresql\'.');

        $this->addSql('CREATE SEQUENCE swp_event_category_id_seq INCREMENT BY 1 MINVALUE 1 START 1');

        $this->addSql('CREATE SEQUENCE swp_event_date_id_seq INCREMENT BY 1 MINVALUE 1 START 1');

        $this->addSql('CREATE SEQUENCE swp_event_location_id_seq INCREMENT BY 1 MINVALUE 1 START 1');

        $this->addSql('CREATE SEQUENCE swp_event_occur_status_id_seq INCREMENT BY 1 MINVALUE 1 START 1');

        $this->addSql('CREATE SEQUENCE swp_event_id_seq INCREMENT BY 1 MINVALUE 1 START 1');

        $this->addSql('CREATE TABLE swp_event_category (id INT NOT NULL, event_id INT NOT NULL, name VARCHAR(255) NOT NULL, qcode VARCHAR(255) NOT NULL, subject VARCHAR(255) NOT NULL, PRIMARY KEY(id))');

        $this->addSql('CREATE INDEX IDX_94BF293F71F7E88B ON swp_event_category (event_id)');

        $this->addSql('CREATE TABLE swp_event_date (id INT NOT NULL, start_date TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, end_date TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, tz VARCHAR(255) NOT NULL, PRIMARY KEY(id))');

        $this->addSql('CREATE TABLE swp_event_location (id INT NOT NULL, event_id INT NOT NULL, name VARCHAR(255) NOT NULL, qcode VARCHAR(255) NOT NULL, PRIMARY KEY(id))');

        $this->addSql('CREATE INDEX IDX_CC6DB93571F7E88B ON swp_event_location (event_id)');

        $this->addSql('CREATE TABLE swp_event_occur_status (id INT NOT NULL, name VARCHAR(255) NOT NULL, qcode VARCHAR(255) NOT NULL, PRIMARY KEY(id))');

        $this->addSql('CREATE TABLE swp_event (id INT NOT NULL, dates_id INT DEFAULT NULL, occur_status_id INT DEFAULT NULL, etag VARCHAR(255) NOT NULL, guid VARCHAR(255) NOT NULL, type VARCHAR(255) NOT NULL, name VARCHAR(255) NOT NULL, version INT DEFAULT NULL, ingest_id VARCHAR(255) DEFAULT NULL, recurrence_id VARCHAR(255) DEFAULT NULL, original_creator VARCHAR(255) NOT NULL, version_creator VARCHAR(255) DEFAULT NULL, ingest_provider VARCHAR(255) DEFAULT NULL, original_source VARCHAR(255) DEFAULT NULL, ingest_provider_sequence VARCHAR(255) DEFAULT NULL, definition_short VARCHAR(255) DEFAULT NULL, definition_long VARCHAR(255) DEFAULT NULL, created_at TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, updated_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, PRIMARY KEY(id))');

        $this->addSql('CREATE UNIQUE INDEX UNIQ_658EE4843DA992C3 ON swp_event (dates_id)');

        $this->addSql('CREATE UNIQUE INDEX UNIQ_658EE4845DA64DFB ON swp_event (occur_status_id)');

        $this->addSql('ALTER TABLE swp_event_category ADD CONSTRAINT FK_94BF293F71F7E88B FOREIGN KEY (event_id) REFERENCES swp_event (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE');

        $this->addSql('ALTER TABLE swp_event_location ADD CONSTRAINT FK_CC6DB93571F7E88B FOREIGN KEY (event_id) REFERENCES swp_event (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE');

        $this->addSql('ALTER TABLE swp_event ADD CONSTRAINT FK_658EE4843DA992C3 FOREIGN KEY (dates_id) REFERENCES swp_event_date (id) NOT DEFERRABLE INITIALLY IMMEDIATE');

        $this->addSql('ALTER TABLE swp_event ADD CONSTRAINT FK_658EE4845DA64DFB FOREIGN KEY (occur_status_id) REFERENCES swp_event_occur_status (id) NOT DEFERRABLE INITIALLY IMMEDIATE');

    }

    /**

     * @param Schema $schema

     */

    public function down(Schema $schema)

    {

        // this down() migration is auto-generated, please modify it to your needs

        $this->abortIf('postgresql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'postgresql\'.');

        $this->addSql('ALTER TABLE swp_event DROP CONSTRAINT FK_658EE4843DA992C3');

        $this->addSql('ALTER TABLE swp_event DROP CONSTRAINT FK_658EE4845DA64DFB');

        $this->addSql('ALTER TABLE swp_event_category DROP CONSTRAINT FK_94BF293F71F7E88B');

        $this->addSql('ALTER TABLE swp_event_location DROP CONSTRAINT FK_CC6DB93571F7E88B');

        $this->addSql('DROP SEQUENCE swp_event_category_id_seq CASCADE');

        $this->addSql('DROP SEQUENCE swp_event_date_id_seq CASCADE');

        $this->addSql('DROP SEQUENCE swp_event_location_id_seq CASCADE');

        $this->addSql('DROP SEQUENCE swp_event_occur_status_id_seq CASCADE');

        $this->addSql('DROP SEQUENCE swp_event_id_seq CASCADE');

        $this->addSql('DROP TABLE swp_event_category');

        $this->addSql('DROP TABLE swp_event_date');

        $this->addSql('DROP TABLE swp_event_location');

        $this->addSql('DROP TABLE swp_event_occur_status');

        $this->addSql('DROP TABLE swp_event');

    }

}