Skip to content

Instantly share code, notes, and snippets.

@core01

core01/query.sql

Created February 5, 2016 10:20
Show Gist options
  • Save core01/274898468346f89254d6 to your computer and use it in GitHub Desktop.
Save core01/274898468346f89254d6 to your computer and use it in GitHub Desktop.
Download ZIP
SQL query to drop current primary key and add one new
Raw
query.sql
ALTER TABLE `modx_ms2_ingredient_remains` DROP PRIMARY KEY;
ALTER TABLE `modx_ms2_ingredient_remains` ADD `id` int(10) unsigned AUTO_INCREMENT primary key;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment