From fd7fde95159828960784a438c4b4da147e20ab18 Mon Sep 17 00:00:00 2001 From: Jeremy Benoist Date: Tue, 2 May 2017 08:38:22 +0200 Subject: [PATCH] Force sequence creation for postgresql --- ...Version20161204115751.php => Version20170501115751.php} | 7 ++++++- 1 file changed, 6 insertions(+), 1 deletion(-) rename app/DoctrineMigrations/{Version20161204115751.php => Version20170501115751.php} (86%) diff --git a/app/DoctrineMigrations/Version20161204115751.php b/app/DoctrineMigrations/Version20170501115751.php similarity index 86% rename from app/DoctrineMigrations/Version20161204115751.php rename to app/DoctrineMigrations/Version20170501115751.php index 97635fa7..846a87b5 100644 --- a/app/DoctrineMigrations/Version20161204115751.php +++ b/app/DoctrineMigrations/Version20170501115751.php @@ -10,7 +10,7 @@ use Symfony\Component\DependencyInjection\ContainerInterface; /** * Add site credential table to store username & password for some website (behind authentication or paywall) */ -class Version20161204115751 extends AbstractMigration implements ContainerAwareInterface +class Version20170501115751 extends AbstractMigration implements ContainerAwareInterface { /** * @var ContainerInterface @@ -44,6 +44,11 @@ class Version20161204115751 extends AbstractMigration implements ContainerAwareI $table->addIndex(['user_id'], 'idx_user'); $table->setPrimaryKey(['id']); $table->addForeignKeyConstraint($this->getTable('user'), ['user_id'], ['id'], [], 'fk_user'); + + if ('postgresql' === $this->connection->getDatabasePlatform()->getName()) { + $schema->dropSequence('site_credential_id_seq'); + $schema->createSequence('site_credential_id_seq'); + } } /** -- 2.41.0