3 namespace Application\Migrations
;
5 use Doctrine\DBAL\Migrations\AbstractMigration
;
6 use Doctrine\DBAL\Schema\Schema
;
7 use Symfony\Component\DependencyInjection\ContainerAwareInterface
;
8 use Symfony\Component\DependencyInjection\ContainerInterface
;
11 * Changed length for username, username_canonical, email and email_canonical fields in wallabag_user table.
13 class Version20170510082609
extends AbstractMigration
implements ContainerAwareInterface
23 * @var ContainerInterface
27 public function setContainer(ContainerInterface
$container = null)
29 $this->container
= $container;
32 private function getTable($tableName)
34 return $this->container
->getParameter('database_table_prefix').$tableName;
38 * @param Schema $schema
40 public function up(Schema
$schema)
42 $this->skipIf($this->connection
->getDatabasePlatform()->getName() !== 'mysql', 'This migration only apply to MySQL');
44 foreach ($this->fields
as $field) {
45 $this->addSql('ALTER TABLE '.$this->getTable('user').' CHANGE '.$field.' '.$field.' VARCHAR(180) NOT NULL;');
50 * @param Schema $schema
52 public function down(Schema
$schema)
54 $this->skipIf($this->connection
->getDatabasePlatform()->getName() !== 'mysql', 'This migration only apply to MySQL');
56 foreach ($this->fields
as $field) {
57 $this->addSql('ALTER TABLE '.$this->getTable('user').' CHANGE '.$field.' '.$field.' VARCHAR(255) NOT NULL;');