Skip to content

Instantly share code, notes, and snippets.

@benoitMariaux
Created December 3, 2013 17:08
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save benoitMariaux/7773105 to your computer and use it in GitHub Desktop.
Save benoitMariaux/7773105 to your computer and use it in GitHub Desktop.
Symfony > doctrine:migrations:migrate
Application Migrations
WARNING! You are about to execute a database migration that could result in schema changes and data lost. Are you sure you wish to continue? (y/n)y
Migrating up to 20131203165923 from 20131108083116
++ migrating 20131129111111
-> ALTER TABLE contact_form ADD contactEmail LONGTEXT NOT NULL COMMENT '(DC2Type:array)', ADD sendToOwner TINYINT(1) DEFAULT NULL
-> UPDATE contact_form SET contactEmail = 'a:0:{}', sendToOwner=1
++ migrated (2.72s)
++ migrating 20131202170153
-> CREATE TABLE store_locator (id INT AUTO_INCREMENT NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, name VARCHAR(255) DEFAULT NULL, title VARCHAR(255) NOT NULL, infoWindowContent LONGTEXT NOT NULL, enabled TINYINT(1) NOT NULL, siteStatuses LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)', minZoomToShowMarkers INT NOT NULL, defaultZoom INT NOT NULL, zoomAfterSearchAction INT NOT NULL, zoomAfterSelectOneByName INT NOT NULL, labelForSearchLocField LONGTEXT NOT NULL, labelForSiteSelector VARCHAR(255) NOT NULL, includeAddedCSS TINYINT(1) NOT NULL, addedCSS LONGTEXT DEFAULT NULL, route VARCHAR(255) DEFAULT NULL, baseSite_id INT NOT NULL, INDEX IDX_634E5F88A8535030 (baseSite_id), PRIMARY KEY(id)) ENGINE = InnoDB
-> ALTER TABLE store_locator ADD CONSTRAINT FK_634E5F88A8535030 FOREIGN KEY (baseSite_id) REFERENCES site (id)
-> ALTER TABLE content ADD storeLocator_id INT DEFAULT NULL
-> ALTER TABLE content ADD CONSTRAINT FK_FEC530A9545E373A FOREIGN KEY (storeLocator_id) REFERENCES store_locator (id)
-> CREATE INDEX IDX_FEC530A9545E373A ON content (storeLocator_id)
-> ALTER TABLE worker_group ADD CONSTRAINT FK_7167E0116B20BA36 FOREIGN KEY (worker_id) REFERENCES worker (id) ON DELETE CASCADE
-> ALTER TABLE worker_group ADD CONSTRAINT FK_7167E011FE54D947 FOREIGN KEY (group_id) REFERENCES team_group (id) ON DELETE CASCADE
-> ALTER TABLE group_worker ADD CONSTRAINT FK_4C3467B2FE54D947 FOREIGN KEY (group_id) REFERENCES team_group (id) ON DELETE CASCADE
-> ALTER TABLE group_worker ADD CONSTRAINT FK_4C3467B26B20BA36 FOREIGN KEY (worker_id) REFERENCES worker (id) ON DELETE CASCADE
++ migrated (13.94s)
++ migrating 20131203165923
-> CREATE TABLE store_locator (id INT AUTO_INCREMENT NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, name VARCHAR(255) DEFAULT NULL, title VARCHAR(255) NOT NULL, infoWindowContent LONGTEXT NOT NULL, enabled TINYINT(1) NOT NULL, siteStatuses LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)', minZoomToShowMarkers INT NOT NULL, defaultZoom INT NOT NULL, zoomAfterSearchAction INT NOT NULL, zoomAfterSelectOneByName INT NOT NULL, labelForSearchLocField LONGTEXT NOT NULL, labelForSiteSelector VARCHAR(255) NOT NULL, includeAddedCSS TINYINT(1) NOT NULL, addedCSS LONGTEXT DEFAULT NULL, route VARCHAR(255) DEFAULT NULL, baseSite_id INT NOT NULL, INDEX IDX_634E5F88A8535030 (baseSite_id), PRIMARY KEY(id)) ENGINE = InnoDB
Migration 20131203165923 failed during Execution. Error SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'store_locator' already exists
[PDOException]
SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'store_locat
or' already exists
doctrine:migrations:migrate [--write-sql] [--dry-run] [--configuration[="..."]] [--db-configuration[="..."]] [--em[="..."]] [version]
The command terminated with an error status (1)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment