Skip to content

Instantly share code, notes, and snippets.

@wocoburguesa
Created July 13, 2012 09:04
Show Gist options
  • Save wocoburguesa/3103773 to your computer and use it in GitHub Desktop.
Save wocoburguesa/3103773 to your computer and use it in GitHub Desktop.
Estas son las sentencias para dejar las categorías como deberían estar:
UPDATE circuits_circuit SET category=100 WHERE category=1;
UPDATE circuits_circuit SET category=4 WHERE category=100;
UPDATE circuits_circuit SET category=100 WHERE category=2;
UPDATE circuits_circuit SET category=3 WHERE category=100;
UPDATE circuits_circuit SET category=100 WHERE category=4;
UPDATE circuits_circuit SET category=2 WHERE category=100;
UPDATE circuits_circuit SET category=100 WHERE category=5;
UPDATE circuits_circuit SET category=1 WHERE category=100;
UPDATE circuits_circuit SET category=100 WHERE category=9;
UPDATE circuits_circuit SET category=9 WHERE category=100;
UPDATE circuits_circuit SET category=100 WHERE category=12;
UPDATE circuits_circuit SET category=14 WHERE category=100;
UPDATE circuits_circuit SET category=100 WHERE category=13;
UPDATE circuits_circuit SET category=10 WHERE category=100;
UPDATE circuits_circuit SET category=100 WHERE category=15;
UPDATE circuits_circuit SET category=12 WHERE category=100;
UPDATE circuits_circuit SET category=100 WHERE category=18;
UPDATE circuits_circuit SET category=6 WHERE category=100;
UPDATE circuits_circuit SET category=100 WHERE category=20;
UPDATE circuits_circuit SET category=8 WHERE category=100;
UPDATE circuits_circuit SET category=100 WHERE category=22;
UPDATE circuits_circuit SET category=13 WHERE category=100;
UPDATE circuits_circuit SET category=100 WHERE category=23;
UPDATE circuits_circuit SET category=5 WHERE category=100;
UPDATE circuits_circuit SET category=100 WHERE category=24;
UPDATE circuits_circuit SET category=11 WHERE category=100;
UPDATE circuits_circuit SET category=100 WHERE category=26;
UPDATE circuits_circuit SET category=7 WHERE category=100;
Y esta es la que borra las categorías seguidas (parece una carnicería, pero en esa tabla sólo hay follow a categorías, y sólo son 6 usuarios):
DELETE FROM circuits_circuitcategoryfollow;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment