20080316update.sql 550 B

12345678
  1. UPDATE grandboss_list SET zone = 12006 WHERE zone = 'LairofAntharas';
  2. UPDATE grandboss_list SET zone = 12007 WHERE zone = 'LairofBaium';
  3. UPDATE grandboss_list SET zone = 12008 WHERE zone = 'LairofValakas';
  4. UPDATE grandboss_list SET zone = 12009 WHERE zone = 'LairofLilith';
  5. UPDATE grandboss_list SET zone = 12010 WHERE zone = 'LairofAnakim';
  6. UPDATE grandboss_list SET zone = 12011 WHERE zone = 'LairofZaken';
  7. UPDATE grandboss_list SET zone = 12014 WHERE zone = 'AltarofSacrifice';
  8. ALTER TABLE grandboss_list MODIFY zone decimal(11,0) NOT NULL;