sql/updates/7292_02_mangos_locales_points_of_interest.sql

   1 ALTER TABLE db_version CHANGE COLUMN required_7292_01_mangos_points_of_interest required_7292_02_mangos_locales_points_of_interest bit;
   2
   3 DROP TABLE IF EXISTS `locales_points_of_interest`;
   4 CREATE TABLE `locales_points_of_interest` (
   5   `entry` mediumint(8) unsigned NOT NULL default '0',
   6   `icon_name_loc1` text,
   7   `icon_name_loc2` text,
   8   `icon_name_loc3` text,
   9   `icon_name_loc4` text,
  10   `icon_name_loc5` text,
  11   `icon_name_loc6` text,
  12   `icon_name_loc7` text,
  13   `icon_name_loc8` text,
  14   PRIMARY KEY  (`entry`)
  15 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;