migrations/Version20180516120827.php line 1
<?php
namespace DoctrineMigrations;
use Doctrine\DBAL\Schema\Schema;
use Doctrine\Migrations\AbstractMigration;
/**
* Auto-generated Migration: Please modify to your needs!
*/
class Version20180516120827 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 media ADD users_id INT DEFAULT 1 NOT NULL');
$this->addSql('ALTER TABLE media ALTER users_id DROP DEFAULT');
// $this->addSql('ALTER TABLE media ADD media_order INT DEFAULT 0 NOT NULL');
// $this->addSql('ALTER TABLE media DROP node_priority');
$this->addSql('ALTER TABLE media RENAME COLUMN node_priority TO media_order');
$this->addSql('COMMENT ON COLUMN media.users_id IS \'Creating/editing user\'');
$this->addSql('COMMENT ON COLUMN media.media_order IS \'Order in parent entity\'');
$this->addSql('ALTER TABLE media ADD CONSTRAINT fk_media_users FOREIGN KEY (users_id) REFERENCES users (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE node ADD users_id INT DEFAULT 1 NOT NULL');
$this->addSql('ALTER TABLE node ALTER users_id DROP DEFAULT');
// $this->addSql('ALTER TABLE node ADD node_order INT DEFAULT 0 NOT NULL');
// $this->addSql('ALTER TABLE node DROP priority');
$this->addSql('ALTER TABLE node RENAME COLUMN priority TO node_order');
$this->addSql('COMMENT ON COLUMN node.users_id IS \'Creating/editing user\'');
$this->addSql('COMMENT ON COLUMN node.node_order IS \'Order in scenario\'');
$this->addSql('COMMENT ON COLUMN node.links_order IS \'Order of links (0 - default, 1 - random)\'');
$this->addSql('ALTER TABLE node ADD CONSTRAINT fk_node_users FOREIGN KEY (users_id) REFERENCES users (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE player_sessionhist RENAME COLUMN correct TO is_ended');
$this->addSql('ALTER TABLE users DROP settings');
$this->addSql('ALTER TABLE users DROP auth_modules');
$this->addSql('ALTER TABLE mcq ADD users_id INT DEFAULT 1 NOT NULL');
$this->addSql('ALTER TABLE mcq ALTER users_id DROP DEFAULT');
$this->addSql('COMMENT ON COLUMN mcq.users_id IS \'Creating/editing user\'');
$this->addSql('ALTER TABLE mcq ADD CONSTRAINT fk_mcq_users FOREIGN KEY (users_id) REFERENCES users (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE link ADD users_id INT DEFAULT 1 NOT NULL');
$this->addSql('ALTER TABLE link ALTER users_id DROP DEFAULT');
$this->addSql('COMMENT ON COLUMN link.users_id IS \'Creating/editing user\'');
$this->addSql('ALTER TABLE link ADD CONSTRAINT fk_link_users FOREIGN KEY (users_id) REFERENCES users (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE scenario ALTER author TYPE VARCHAR(255)');
// $this->addSql('ALTER TABLE scenario ALTER author DROP DEFAULT');
$this->addSql('UPDATE scenario SET author = \'unknown\' WHERE author IS NULL');
$this->addSql('ALTER TABLE scenario ALTER author SET NOT NULL');;
$this->addSql('COMMENT ON COLUMN scenario.author IS \'Title\'');
}
/**
* @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('ALTER TABLE scenario ALTER author TYPE TEXT');
// $this->addSql('ALTER TABLE scenario ALTER author DROP DEFAULT');
$this->addSql('ALTER TABLE scenario ALTER author DROP NOT NULL');
$this->addSql('UPDATE scenario SET author = NULL WHERE author = \'unknown\'');
$this->addSql('COMMENT ON COLUMN scenario.author IS \'Author\'');
$this->addSql('ALTER TABLE users ADD settings JSON DEFAULT NULL');
$this->addSql('ALTER TABLE users ADD auth_modules TEXT DEFAULT NULL');
$this->addSql('COMMENT ON COLUMN users.settings IS \'Settings N/A\'');
$this->addSql('COMMENT ON COLUMN users.auth_modules IS \'Modules N/A\'');
$this->addSql('ALTER TABLE player_sessionhist RENAME COLUMN is_ended TO correct');
$this->addSql('ALTER TABLE mcq DROP CONSTRAINT fk_mcq_users');
$this->addSql('ALTER TABLE mcq DROP users_id');
$this->addSql('ALTER TABLE node DROP CONSTRAINT fk_node_users');
$this->addSql('ALTER TABLE node DROP users_id');
// $this->addSql('ALTER TABLE node ADD priority INT DEFAULT 0 NOT NULL');
// $this->addSql('ALTER TABLE node DROP node_order');
$this->addSql('ALTER TABLE node RENAME COLUMN node_order TO priority');
$this->addSql('COMMENT ON COLUMN node.priority IS \'Priority (0 - is last in order)\'');
$this->addSql('COMMENT ON COLUMN node.links_order IS \'Order (0 - default, 1 - random)\'');
$this->addSql('ALTER TABLE link DROP CONSTRAINT fk_link_users');
$this->addSql('ALTER TABLE link DROP users_id');
$this->addSql('ALTER TABLE media DROP CONSTRAINT fk_media_users');
$this->addSql('ALTER TABLE media DROP users_id');
// $this->addSql('ALTER TABLE media ADD node_priority INT DEFAULT 0 NOT NULL');
// $this->addSql('ALTER TABLE media DROP media_order');
$this->addSql('ALTER TABLE media RENAME COLUMN media_order TO node_priority');
$this->addSql('COMMENT ON COLUMN media.node_priority IS \'Priority in node\'');
}
}