-Core Commit: c9fb6011743fe2cf95c9
-DB Commit(Attempted): 3993b73925c8ef344100
-OS: Windows Web Server 2008 R2
-SQL GUI: SQLyog Community v9.0
-SQL GUI2: Navicat Lite v9.1.9
-MySQL: MySQL Workbench 5.2.31
Query:
ALTER TABLE `channels` CHANGE COLUMN `m_name` `name` varchar(128) NOT NULL,
CHANGE COLUMN `m_team` `team` int(10) unsigned NOT NULL,
CHANGE COLUMN `m_announce` `announce` tinyint(3) unsigned NOT NULL DEFAULT '1',
CHANGE COLUMN `m_ownership` `ownership` tinyint(3) unsigned NOT NULL DEFAULT '1',
CHANGE COLUMN `m_password` `password` varchar(32) DEFAULT NULL,
CHANGE COLUMN `BannedList` `bannedList` text,
CHANGE COLUMN `last_used` `lastUsed` int(10) unsigned NOT NULL
Error occured at:2011-04-14 03:23:24
Line no.:8
Error Code: 1146 - Table 'aero_characters.channels' doesn't exist
Query:
CREATE TABLE `corpse` (
`corpseGuid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
`guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier',
`posX` float NOT NULL DEFAULT '0',
`posY` float NOT NULL DEFAULT '0',
`posZ` float NOT NULL DEFAULT '0',
`orientation` float NOT NULL DEFAULT '0',
`mapId` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier',
`phaseMask` smallint(5) unsigned NOT NULL DEFAULT '1',
`displayId` int(10) unsigned NOT NULL DEFAULT '0',
`itemCache` text NOT NULL,
`bytes1` int(10) unsigned NOT NULL DEFAULT '0',
`bytes2` int(10) unsigned NOT NULL DEFAULT '0',
`guildId` int(10) unsigned NOT NULL DEFAULT '0',
`flags` tinyint(3) unsigned NOT NULL DEFAULT '0',
`dynFlags` tinyint(3) unsigned NOT NULL DEFAULT '0',
`time` int(10) unsigned NOT NULL DEFAULT '0',
`corpseType` tinyint(3) unsigned NOT NULL DEFAULT '0',
`instanceId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Instance Identifier',
PRIMARY KEY (`guid`),
KEY `idx_type` (`corpseType`),
KEY `instance` (`instanceId`),
KEY `Idx_player` (`player`),
KEY `Idx_time` (`time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Death System'
Error occured at:2011-04-14 03:24:03
Line no.:1220
Error Code: 1072 - Key column 'player' doesn't exist in table
Query:
INSERT INTO character_queststatus_rewarded SELECT guid, quest FROM character_queststatus WHERE rewarded = 1
Error occured at:2011-04-14 03:27:30
Line no.:9
Error Code: 1054 - Unknown column 'rewarded' in 'where clause'
Query:
CREATE TABLE `corpse` (
`corpseGuid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
`guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier',
`posX` float NOT NULL DEFAULT '0',
`posY` float NOT NULL DEFAULT '0',
`posZ` float NOT NULL DEFAULT '0',
`orientation` float NOT NULL DEFAULT '0',
`mapId` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier',
`phaseMask` smallint(5) unsigned NOT NULL DEFAULT '1',
`displayId` int(10) unsigned NOT NULL DEFAULT '0',
`itemCache` text NOT NULL,
`bytes1` int(10) unsigned NOT NULL DEFAULT '0',
`bytes2` int(10) unsigned NOT NULL DEFAULT '0',
`guildId` int(10) unsigned NOT NULL DEFAULT '0',
`flags` tinyint(3) unsigned NOT NULL DEFAULT '0',
`dynFlags` tinyint(3) unsigned NOT NULL DEFAULT '0',
`time` int(10) unsigned NOT NULL DEFAULT '0',
`corpseType` tinyint(3) unsigned NOT NULL DEFAULT '0',
`instanceId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Instance Identifier',
PRIMARY KEY (`guid`),
KEY `idx_type` (`corpseType`),
KEY `instance` (`instanceId`),
KEY `Idx_player` (`player`),
KEY `Idx_time` (`time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Death System'
Error occured at:2011-04-14 04:39:13
Line no.:1220
Error Code: 1072 - Key column 'player' doesn't exist in tabl