OpencachingDeutschland / oc-server3

/**

 * Migration to add column is_translated to the languages table and set all translated languages to 1.

 */

class Version20170830005500 extends AbstractMigration

{

    public function up(Schema $schema): void

    {

        $this->addSql('ALTER TABLE `languages` ADD `is_translated` TINYINT DEFAULT 0 NOT NULL;');

        $this->addSql('UPDATE `languages` SET `is_translated` = 1 WHERE short IN (\'DE\', \'EN\', \'FR\', \'IT\', \'ES\');');

    }

    public function down(Schema $schema): void

    {

        $this->addSql('ALTER TABLE `languages` DROP `is_translated`');

    }

}

use Doctrine\DBAL\Migrations\AbstractMigration;

use Doctrine\DBAL\Schema\Schema;

class Version201912003190000 extends AbstractMigration

{

    public function up(Schema $schema): void

    {

        $this->addSql('ALTER TABLE user	ADD gdpr_deletion TINYINT(1) DEFAULT 0 NOT NULL;');

        $this->addSql('ALTER TABLE caches ADD gdpr_deletion TINYINT(1) DEFAULT 0 NOT NULL;');

        $this->addSql('ALTER TABLE cache_logs ADD gdpr_deletion TINYINT(1) DEFAULT 0 NOT NULL;');

        $this->addSql('UPDATE user SET gdpr_deletion = 1 WHERE username like \'delete_%\'');

    }

    public function down(Schema $schema): void

    {

    }

}