ALTER TABLE `arenateams` CHANGE COLUMN `bordercolour` `bordercolor` int(10) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `arenateams` CHANGE COLUMN `backgroundcolour` `backgroundcolor` int(10) unsigned NOT NULL DEFAULT '0';

ALTER TABLE `auctions` CHANGE COLUMN `auctionhouse` `auctionHouse` int(32) unsigned NOT NULL DEFAULT '0';

ALTER TABLE `characters` DROP COLUMN `publicNote`;
ALTER TABLE `characters` DROP COLUMN `officerNote`;
ALTER TABLE `characters` DROP COLUMN `guildid`;
ALTER TABLE `characters` DROP COLUMN `guildRank`;

DELETE FROM GROUPS WHERE 1=1;
ALTER TABLE `groups` ADD COLUMN `main_assist` int(30) NOT NULL DEFAULT '0' AFTER `loot_threshold`;
ALTER TABLE `groups` ADD COLUMN `main_tank` int(30) NOT NULL DEFAULT '0' AFTER `loot_threshold`;
ALTER TABLE `groups` ADD COLUMN `assistant_leader` int(30) NOT NULL DEFAULT '0' AFTER `loot_threshold`;
ALTER TABLE `groups` ADD COLUMN `difficulty` int(30) NOT NULL DEFAULT '0' AFTER `loot_threshold`;

ALTER TABLE `guild_ranks` ADD COLUMN `itemStacksPerDay5` int(30) NOT NULL DEFAULT '0' AFTER `rankRights`;
ALTER TABLE `guild_ranks` ADD COLUMN `bankTabFlags5` int(30) NOT NULL DEFAULT '0' AFTER `rankRights`;
ALTER TABLE `guild_ranks` ADD COLUMN `itemStacksPerDay4` int(30) NOT NULL DEFAULT '0' AFTER `rankRights`;
ALTER TABLE `guild_ranks` ADD COLUMN `bankTabFlags4` int(30) NOT NULL DEFAULT '0' AFTER `rankRights`;
ALTER TABLE `guild_ranks` ADD COLUMN `itemStacksPerDay3` int(30) NOT NULL DEFAULT '0' AFTER `rankRights`;
ALTER TABLE `guild_ranks` ADD COLUMN `bankTabFlags3` int(30) NOT NULL DEFAULT '0' AFTER `rankRights`;
ALTER TABLE `guild_ranks` ADD COLUMN `itemStacksPerDay2` int(30) NOT NULL DEFAULT '0' AFTER `rankRights`;
ALTER TABLE `guild_ranks` ADD COLUMN `bankTabFlags2` int(30) NOT NULL DEFAULT '0' AFTER `rankRights`;
ALTER TABLE `guild_ranks` ADD COLUMN `itemStacksPerDay1` int(30) NOT NULL DEFAULT '0' AFTER `rankRights`;
ALTER TABLE `guild_ranks` ADD COLUMN `bankTabFlags1` int(30) NOT NULL DEFAULT '0' AFTER `rankRights`;
ALTER TABLE `guild_ranks` ADD COLUMN `itemStacksPerDay0` int(30) NOT NULL DEFAULT '0' AFTER `rankRights`;
ALTER TABLE `guild_ranks` ADD COLUMN `bankTabFlags0` int(30) NOT NULL DEFAULT '0' AFTER `rankRights`;
ALTER TABLE `guild_ranks` ADD COLUMN `goldLimitPerDay` int(30) NOT NULL DEFAULT '0' AFTER `rankRights`;

ALTER TABLE `guilds` ADD COLUMN `bankBalance` int(30) NOT NULL AFTER `createdate`;
ALTER TABLE `guilds` ADD COLUMN `bankTabCount` int(30) NOT NULL DEFAULT '0' AFTER `createdate`;

DROP TABLE `instances`;
CREATE TABLE `instances` (
  `id` int(10) unsigned NOT NULL,
  `mapid` int(10) unsigned NOT NULL,
  `creation` int(10) unsigned NOT NULL,
  `expiration` int(10) unsigned NOT NULL,
  `killed_npc_guids` text character set utf8 collate utf8_unicode_ci NOT NULL,
  `difficulty` int(10) unsigned NOT NULL,
  `creator_group` int(10) unsigned NOT NULL,
  `creator_guid` int(10) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
ALTER TABLE `instances` ADD PRIMARY KEY (`id`);

ALTER TABLE `mailbox` ADD COLUMN `external_attached_item_guid` bigint(20) NOT NULL DEFAULT '0' AFTER attached_item_guid;

ALTER TABLE `playerpets` CHANGE COLUMN `entryid` `entry` int(10) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `playerpets` CHANGE COLUMN `data` `fields` longtext NOT NULL;
ALTER TABLE `playerpets` CHANGE COLUMN `loyalty` `happiness` int(11) NOT NULL DEFAULT '0';
ALTER TABLE `playerpets` CHANGE COLUMN `nextloyaltyupdate` `happinessupdate` int(11) NOT NULL DEFAULT '0';

ALTER TABLE `guilds` DROP COLUMN `createdate`;
ALTER TABLE `guilds` ADD COLUMN `createdate` int(30) NOT NULL DEFAULT '0'  AFTER `motd`;