alter table worldmap_info add column required_quest int(30) not null default 0 after lvl_mod_a;
alter table worldmap_info add column required_itemid int(30) not null default 0 after lvl_mod_a;

alter table worldmap_info add column required_quest int(30) not null default 0 after lvl_mod_a;
alter table worldmap_info add column required_itemid int(30) not null default 0 after lvl_mod_a;
CREATE TABLE `gameobject_staticspawns` (
`id` int(30) NOT NULL AUTO_INCREMENT,
`entry` int(30) NOT NULL,
`map` int(11) NOT NULL DEFAULT '0',
`x` float NOT NULL,
`y` float NOT NULL,
`z` float NOT NULL,
`facing` float NOT NULL,
`0` float NOT NULL,
`01` float NOT NULL,
`02` float NOT NULL,
`03` float NOT NULL,
`state` int(11) NOT NULL DEFAULT '0',
`flags` int(30) NOT NULL DEFAULT '0',
`faction` int(11) NOT NULL DEFAULT '0',
`scale` float NOT NULL,
`respawnNpcLink` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `creature_staticspawns` (
`id` int(30) NOT NULL AUTO_INCREMENT,
`entry` int(30) NOT NULL,
`map` int(11) NOT NULL DEFAULT '0',
`x` float NOT NULL,
`y` float NOT NULL,
`z` float NOT NULL,
`0` float NOT NULL,
`movetype` int(11) NOT NULL DEFAULT '0',
`displayid` int(11) NOT NULL,
`factionid` int(11) NOT NULL DEFAULT '0',
`flags` int(30) NOT NULL DEFAULT '0',
`bytes` int(30) NOT NULL DEFAULT '0',
`bytes2` int(30) NOT NULL DEFAULT '0',
`emote_state` int(11) NOT NULL DEFAULT '0',
`respawnNpcLink` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

ALTER TABLE creatureloot DROP heroicchance;
ALTER TABLE creatureloot DROP mincount;
ALTER TABLE creatureloot DROP maxcount;

ALTER TABLE fishingloot DROP heroicchance;
ALTER TABLE fishingloot DROP mincount;
ALTER TABLE fishingloot DROP maxcount;

ALTER TABLE itemloot DROP heroicchance;
ALTER TABLE itemloot DROP mincount;
ALTER TABLE itemloot DROP maxcount;

ALTER TABLE objectloot DROP heroicchance;
ALTER TABLE objectloot DROP mincount;
ALTER TABLE objectloot DROP maxcount;

alter table creature_proto change health minhealth int(30) unsigned not null;
alter table creature_proto add column maxhealth int(30) unsigned not null after minhealth;
update creature_proto set maxhealth=minhealth;
alter table creature_proto change level minlevel int(30) unsigned not null;
alter table creature_proto add column maxlevel int(30) unsigned not null after minlevel;
update creature_proto set maxlevel=minlevel;
alter table creature_proto add column invisibility_type int(30) unsigned not null;
alter table creature_proto add column death_state int(30) unsigned not null;
CREATE TABLE `zoneguards` (
  `zoneId` int(10) unsigned NOT NULL,
  `hordeEntry` int(10) unsigned default NULL,
  `allianceEntry` int(10) unsigned default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE `playerpets`;

CREATE TABLE `playerpets` (
  `ownerguid` bigint(20) NOT NULL default '0',
  `petnumber` int(11) NOT NULL default '0',
  `name` varchar(21) NOT NULL default '',
  `entryid` bigint(20) NOT NULL default '0',
  `data` longtext NOT NULL,
  `xp` int(11) NOT NULL default '0',
  `active` tinyint(1) NOT NULL default '0',
  `level` int(11) NOT NULL default '0',
  `happiness` int(11) NOT NULL default '0',
  `actionbar` varchar(200) NOT NULL default '',
  `happinessupdate` int(11) NOT NULL default '0',
  `summon` int(11) NOT NULL default '0',
  `autocastspell` int(11) NOT NULL default '0',
  `loyaltypts` int(11) NOT NULL default '0',
  `loyaltyupdate` int(11) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
alter table playeritems drop column guid;
alter table playeritems add column guid bigint(10) NOT NULL auto_increment primary key after ownerguid;
CREATE TABLE `banned_names` (
  `name` varchar(30) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;