[Help Request] Character creation problem
Hello.
I have a problem on my just established server.
When a character is created, it does NOT appear to the character list.
When I look at the server window, it says something like this:
"Sql query failed due to [Column count doesn't match value count at row1]" and then the query.
How could I figure out how to fix this issue?
Counting the columns and values and see whats missing will take a lot of time, because there is over 50 columns/values.
So how to easily fix this annoying issue?
I'm using ArcEmu450 and WhyDB197.
Thank you.
PS. I want an answer as quickly as possible, so you can also contact me via MSN.
aerthoz <AT> gmail <DOT> com
Re: [Help Request] Character creation problem
try
Code:
# MySQL-Front 3.2 (Build 10.27)
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET TIME_ZONE='SYSTEM' */;
# Host: 192.168.1.69 Database: ascentcharacters
# ------------------------------------------------------
# Server version 5.0.51b-community-nt
DROP DATABASE IF EXISTS `ascentcharacters`;
CREATE DATABASE `ascentcharacters` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `ascentcharacters`;
#
# Table structure for table account_data
#
CREATE TABLE `account_data` (
`acct` int(30) NOT NULL,
`uiconfig0` blob,
`uiconfig1` blob,
`uiconfig2` blob,
`uiconfig3` blob,
`uiconfig4` blob,
`uiconfig5` blob,
`uiconfig6` blob,
`uiconfig7` blob,
`uiconfig8` blob,
PRIMARY KEY (`acct`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
#
# Table structure for table account_forced_permissions
#
CREATE TABLE `account_forced_permissions` (
`login` varchar(50) NOT NULL,
`permissions` varchar(100) NOT NULL,
PRIMARY KEY (`login`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
#
# Table structure for table account_overrides
#
CREATE TABLE `account_overrides` (
`acct` int(20) unsigned NOT NULL default '0',
`gm` varchar(27) NOT NULL default '',
PRIMARY KEY (`acct`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#
# Table structure for table accounts
#
CREATE TABLE `accounts` (
`acct` bigint(20) unsigned NOT NULL auto_increment,
`login` varchar(255) collate utf8_unicode_ci NOT NULL default '',
`password` varchar(28) collate utf8_unicode_ci NOT NULL default '',
`encrypted_password` varchar(42) collate utf8_unicode_ci NOT NULL default '',
`gm` varchar(27) collate utf8_unicode_ci NOT NULL default '',
`banned` int(1) unsigned NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00',
`lastip` varchar(15) collate utf8_unicode_ci NOT NULL default '',
`email` varchar(50) collate utf8_unicode_ci NOT NULL default '',
`flags` int(11) unsigned NOT NULL default '0',
`forceLanguage` varchar(5) collate utf8_unicode_ci NOT NULL default 'enUS',
`muted` int(30) NOT NULL default '0',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
#
# Table structure for table arenateams
#
CREATE TABLE `arenateams` (
`id` int(30) NOT NULL,
`type` int(30) NOT NULL,
`leader` int(30) NOT NULL,
`name` varchar(150) NOT NULL,
`emblemstyle` int(40) NOT NULL,
`emblemcolour` bigint(40) NOT NULL,
`borderstyle` int(40) NOT NULL,
`bordercolour` bigint(40) NOT NULL,
`backgroundcolour` bigint(40) NOT NULL,
`rating` int(30) NOT NULL,
`data` varchar(150) NOT NULL,
`ranking` int(30) NOT NULL,
`player_data1` varchar(60) NOT NULL,
`player_data2` varchar(60) NOT NULL,
`player_data3` varchar(60) NOT NULL,
`player_data4` varchar(60) NOT NULL,
`player_data5` varchar(60) NOT NULL,
`player_data6` varchar(60) NOT NULL,
`player_data7` varchar(60) NOT NULL,
`player_data8` varchar(60) NOT NULL,
`player_data9` varchar(60) NOT NULL,
`player_data10` varchar(60) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
#
# Table structure for table auctions
#
CREATE TABLE `auctions` (
`auctionId` int(32) NOT NULL auto_increment,
`auctionhouse` int(32) default NULL,
`item` bigint(10) default NULL,
`owner` bigint(10) default NULL,
`buyout` int(32) default NULL,
`time` int(32) default NULL,
`bidder` bigint(10) default NULL,
`bid` int(32) default NULL,
`deposit` int(32) default NULL,
PRIMARY KEY (`auctionId`),
KEY `b` (`auctionhouse`)
) ENGINE=MyISAM AUTO_INCREMENT=1027356 DEFAULT CHARSET=latin1;
#
# Table structure for table banned_names
#
CREATE TABLE `banned_names` (
`name` varchar(30) collate utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
#
# Table structure for table banned_phrases
#
CREATE TABLE `banned_phrases` (
`phrase` varchar(250) NOT NULL,
PRIMARY KEY (`phrase`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
#
# Table structure for table characters
#
CREATE TABLE `characters` (
`guid` int(6) unsigned NOT NULL default '0',
`acct` int(20) unsigned NOT NULL default '0',
`name` varchar(21) NOT NULL default '',
`race` smallint(3) NOT NULL,
`class` smallint(3) NOT NULL,
`gender` tinyint(1) NOT NULL,
`custom_faction` int(30) NOT NULL default '0',
`level` int(3) NOT NULL,
`xp` int(30) NOT NULL,
`exploration_data` longtext NOT NULL,
`skills` longtext NOT NULL,
`watched_faction_index` bigint(40) NOT NULL,
`selected_pvp_title` int(30) NOT NULL,
`available_pvp_titles` int(30) NOT NULL,
`gold` int(30) NOT NULL,
`ammo_id` int(30) NOT NULL,
`available_prof_points` int(30) NOT NULL,
`available_talent_points` int(30) NOT NULL,
`current_hp` int(30) NOT NULL,
`current_power` int(30) NOT NULL,
`pvprank` int(30) NOT NULL,
`bytes` int(30) NOT NULL,
`bytes2` int(30) NOT NULL,
`player_flags` int(30) NOT NULL,
`player_bytes` int(30) NOT NULL,
`positionX` float NOT NULL default '0',
`positionY` float NOT NULL default '0',
`positionZ` float NOT NULL default '0',
`orientation` float NOT NULL default '0',
`mapId` int(8) unsigned NOT NULL default '0',
`zoneId` int(8) unsigned NOT NULL default '0',
`taximask` longtext NOT NULL,
`banned` int(40) NOT NULL,
`banReason` varchar(255) default NULL,
`timestamp` int(30) default NULL,
`online` int(11) default NULL,
`bindpositionX` float NOT NULL default '0',
`bindpositionY` float NOT NULL default '0',
`bindpositionZ` float NOT NULL default '0',
`bindmapId` int(8) unsigned NOT NULL default '0',
`bindzoneId` int(8) unsigned NOT NULL default '0',
`isResting` int(3) NOT NULL default '0',
`restState` int(5) NOT NULL default '0',
`restTime` int(5) NOT NULL default '0',
`playedtime` text NOT NULL,
`deathstate` int(5) NOT NULL default '0',
`TalentResetTimes` int(5) NOT NULL default '0',
`first_login` tinyint(1) NOT NULL default '0',
`forced_rename_pending` tinyint(1) NOT NULL default '0',
`arenaPoints` int(10) NOT NULL,
`totalstableslots` int(10) unsigned NOT NULL default '0',
`instance_id` int(10) NOT NULL,
`entrypointmap` int(10) NOT NULL,
`entrypointx` float NOT NULL,
`entrypointy` float NOT NULL,
`entrypointz` float NOT NULL,
`entrypointo` float NOT NULL,
`entrypointinstance` int(10) NOT NULL,
`taxi_path` int(10) NOT NULL,
`taxi_lastnode` int(10) NOT NULL,
`taxi_mountid` int(10) NOT NULL,
`transporter` int(10) NOT NULL,
`transporter_xdiff` float NOT NULL,
`transporter_ydiff` float NOT NULL,
`transporter_zdiff` float NOT NULL,
`spells` longtext NOT NULL,
`deleted_spells` longtext,
`reputation` longtext NOT NULL,
`actions` longtext NOT NULL,
`auras` longtext,
`finished_quests` longtext NOT NULL,
`honorRolloverTime` int(30) NOT NULL default '0',
`killsToday` int(10) NOT NULL default '0',
`killsYesterday` int(10) NOT NULL default '0',
`killsLifeTime` int(10) NOT NULL default '0',
`honorToday` int(10) NOT NULL default '0',
`honorYesterday` int(10) NOT NULL default '0',
`honorPoints` int(10) NOT NULL default '0',
`difficulty` int(4) NOT NULL default '0',
PRIMARY KEY (`guid`),
KEY `acct` (`acct`),
KEY `name` (`name`),
KEY `b` (`banned`),
KEY `c` (`online`),
KEY `d` (`forced_rename_pending`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
#
# Table structure for table characters_insert_queue
#
CREATE TABLE `characters_insert_queue` (
`insert_temp_guid` int(10) unsigned NOT NULL default '0',
`acct` int(10) unsigned NOT NULL default '0',
`name` varchar(21) collate utf8_unicode_ci NOT NULL,
`race` tinyint(3) unsigned NOT NULL default '0',
`class` tinyint(3) unsigned NOT NULL default '0',
`gender` tinyint(3) unsigned NOT NULL default '0',
`custom_faction` int(30) NOT NULL default '0',
`level` int(10) unsigned NOT NULL default '0',
`xp` int(10) unsigned NOT NULL default '0',
`exploration_data` longtext collate utf8_unicode_ci NOT NULL,
`skills` longtext collate utf8_unicode_ci NOT NULL,
`watched_faction_index` int(10) unsigned NOT NULL default '0',
`selected_pvp_title` int(10) unsigned NOT NULL default '0',
`available_pvp_titles` int(10) unsigned NOT NULL default '0',
`gold` int(10) unsigned NOT NULL default '0',
`ammo_id` int(10) unsigned NOT NULL default '0',
`available_prof_points` int(10) unsigned NOT NULL default '0',
`available_talent_points` int(10) unsigned NOT NULL default '0',
`current_hp` int(10) unsigned NOT NULL default '0',
`current_power` int(10) unsigned NOT NULL default '0',
`pvprank` tinyint(3) unsigned NOT NULL default '0',
`bytes` int(10) unsigned NOT NULL default '0',
`bytes2` int(10) unsigned NOT NULL default '0',
`player_flags` int(10) unsigned NOT NULL default '0',
`player_bytes` int(10) unsigned NOT NULL default '0',
`positionX` float NOT NULL default '0',
`positionY` float NOT NULL default '0',
`positionZ` float NOT NULL default '0',
`orientation` float NOT NULL default '0',
`mapId` int(10) unsigned NOT NULL default '0',
`zoneId` int(10) unsigned NOT NULL default '0',
`taximask` longtext collate utf8_unicode_ci NOT NULL,
`banned` int(40) NOT NULL,
`banReason` varchar(50) collate utf8_unicode_ci NOT NULL,
`timestamp` int(11) NOT NULL,
`online` int(11) default NULL,
`bindpositionX` float NOT NULL default '0',
`bindpositionY` float NOT NULL default '0',
`bindpositionZ` float NOT NULL default '0',
`bindmapId` int(10) unsigned NOT NULL default '0',
`bindzoneId` int(10) unsigned NOT NULL default '0',
`isResting` tinyint(3) unsigned NOT NULL default '0',
`restState` tinyint(3) unsigned NOT NULL default '0',
`restTime` int(10) unsigned NOT NULL default '0',
`playedtime` longtext collate utf8_unicode_ci NOT NULL,
`deathstate` int(10) unsigned NOT NULL default '0',
`TalentResetTimes` int(10) unsigned NOT NULL default '0',
`first_login` tinyint(3) unsigned NOT NULL default '0',
`forced_rename_pending` tinyint(3) unsigned NOT NULL default '0',
`publicNote` varchar(32) collate utf8_unicode_ci NOT NULL,
`officerNote` varchar(32) collate utf8_unicode_ci NOT NULL,
`guildid` int(10) unsigned NOT NULL default '0',
`guildRank` int(10) unsigned NOT NULL default '0',
`arenaPoints` int(10) NOT NULL,
`totalstableslots` int(10) unsigned NOT NULL default '0',
`instance_id` int(10) unsigned NOT NULL default '0',
`entrypointmap` int(10) unsigned NOT NULL default '0',
`entrypointx` float NOT NULL default '0',
`entrypointy` float NOT NULL default '0',
`entrypointz` float NOT NULL default '0',
`entrypointo` float NOT NULL default '0',
`entrypointinstance` int(10) unsigned NOT NULL default '0',
`taxi_path` int(10) unsigned NOT NULL default '0',
`taxi_lastnode` int(10) unsigned NOT NULL default '0',
`taxi_mountid` int(10) unsigned NOT NULL default '0',
`transporter` int(10) unsigned NOT NULL default '0',
`transporter_xdiff` float NOT NULL default '0',
`transporter_ydiff` float NOT NULL default '0',
`transporter_zdiff` float NOT NULL default '0',
`spells` longtext collate utf8_unicode_ci NOT NULL,
`deleted_spells` longtext collate utf8_unicode_ci NOT NULL,
`reputation` longtext collate utf8_unicode_ci NOT NULL,
`actions` longtext collate utf8_unicode_ci NOT NULL,
`auras` longtext collate utf8_unicode_ci NOT NULL,
`finished_quests` longtext collate utf8_unicode_ci NOT NULL,
`honorPointsToAdd` int(10) NOT NULL,
`killsToday` int(10) unsigned NOT NULL default '0',
`killsYesterday` int(10) unsigned NOT NULL default '0',
`killsLifeTime` int(10) unsigned NOT NULL default '0',
`honorToday` int(10) unsigned NOT NULL default '0',
`honorYesterday` int(10) unsigned NOT NULL default '0',
`honorPoints` int(10) unsigned NOT NULL default '0',
`difficulty` int(10) unsigned NOT NULL default '0',
UNIQUE KEY `guid` (`insert_temp_guid`),
KEY `acct` (`acct`),
KEY `guildid` (`guildid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
#
# Table structure for table charters
#
CREATE TABLE `charters` (
`charterId` int(30) NOT NULL,
`charterType` int(30) NOT NULL default '0',
`leaderGuid` int(20) unsigned NOT NULL default '0',
`guildName` varchar(32) NOT NULL default '',
`itemGuid` bigint(40) unsigned NOT NULL default '0',
`signer1` int(10) unsigned NOT NULL default '0',
`signer2` int(10) unsigned NOT NULL default '0',
`signer3` int(10) unsigned NOT NULL default '0',
`signer4` int(10) unsigned NOT NULL default '0',
`signer5` int(10) unsigned NOT NULL default '0',
`signer6` int(10) unsigned NOT NULL default '0',
`signer7` int(10) unsigned NOT NULL default '0',
`signer8` int(10) unsigned NOT NULL default '0',
`signer9` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`charterId`),
UNIQUE KEY `leaderGuid` (`leaderGuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='InnoDB free: 11264 kB; InnoDB free: 18432 kB';
#
# Table structure for table clientaddons
#
CREATE TABLE `clientaddons` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(50) default NULL,
`crc` bigint(50) default NULL,
`banned` int(1) NOT NULL default '0',
`showinlist` int(1) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `index` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=153 DEFAULT CHARSET=latin1;
#
# Table structure for table command_overrides
#
CREATE TABLE `command_overrides` (
`command_name` varchar(100) NOT NULL,
`access_level` varchar(10) NOT NULL,
PRIMARY KEY (`command_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
#
# Table structure for table corpses
#
CREATE TABLE `corpses` (
`guid` bigint(20) unsigned NOT NULL default '0',
`positionX` float NOT NULL default '0',
`positionY` float NOT NULL default '0',
`positionZ` float NOT NULL default '0',
`orientation` float NOT NULL default '0',
`zoneId` int(11) NOT NULL default '38',
`mapId` int(11) NOT NULL default '0',
`instanceId` int(11) NOT NULL default '0',
`data` longtext NOT NULL,
PRIMARY KEY (`guid`),
KEY `b` (`instanceId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
#
# Table structure for table gm_tickets
#
CREATE TABLE `gm_tickets` (
`guid` int(6) NOT NULL default '0',
`name` varchar(200) NOT NULL default '',
`level` int(6) NOT NULL default '0',
`type` int(2) NOT NULL default '0',
`posX` float NOT NULL default '0',
`posY` float NOT NULL default '0',
`posZ` float NOT NULL default '0',
`message` text NOT NULL,
`timestamp` text,
PRIMARY KEY (`guid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
#
# Table structure for table groups
#
CREATE TABLE `groups` (
`group_id` int(30) NOT NULL,
`group_type` tinyint(2) NOT NULL,
`subgroup_count` tinyint(2) NOT NULL,
`loot_method` tinyint(2) NOT NULL,
`loot_threshold` tinyint(2) NOT NULL,
`difficulty` int(30) NOT NULL default '0',
`assistant_leader` int(30) NOT NULL default '0',
`main_tank` int(30) NOT NULL default '0',
`main_assist` int(30) NOT NULL default '0',
`group1member1` int(50) NOT NULL,
`group1member2` int(50) NOT NULL,
`group1member3` int(50) NOT NULL,
`group1member4` int(50) NOT NULL,
`group1member5` int(50) NOT NULL,
`group2member1` int(50) NOT NULL,
`group2member2` int(50) NOT NULL,
`group2member3` int(50) NOT NULL,
`group2member4` int(50) NOT NULL,
`group2member5` int(50) NOT NULL,
`group3member1` int(50) NOT NULL,
`group3member2` int(50) NOT NULL,
`group3member3` int(50) NOT NULL,
`group3member4` int(50) NOT NULL,
`group3member5` int(50) NOT NULL,
`group4member1` int(50) NOT NULL,
`group4member2` int(50) NOT NULL,
`group4member3` int(50) NOT NULL,
`group4member4` int(50) NOT NULL,
`group4member5` int(50) NOT NULL,
`group5member1` int(50) NOT NULL,
`group5member2` int(50) NOT NULL,
`group5member3` int(50) NOT NULL,
`group5member4` int(50) NOT NULL,
`group5member5` int(50) NOT NULL,
`group6member1` int(50) NOT NULL,
`group6member2` int(50) NOT NULL,
`group6member3` int(50) NOT NULL,
`group6member4` int(50) NOT NULL,
`group6member5` int(50) NOT NULL,
`group7member1` int(50) NOT NULL,
`group7member2` int(50) NOT NULL,
`group7member3` int(50) NOT NULL,
`group7member4` int(50) NOT NULL,
`group7member5` int(50) NOT NULL,
`group8member1` int(50) NOT NULL,
`group8member2` int(50) NOT NULL,
`group8member3` int(50) NOT NULL,
`group8member4` int(50) NOT NULL,
`group8member5` int(50) NOT NULL,
`timestamp` int(30) NOT NULL,
PRIMARY KEY (`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
#
# Table structure for table guild_bankitems
#
CREATE TABLE `guild_bankitems` (
`guildId` int(30) NOT NULL,
`tabId` int(30) NOT NULL,
`slotId` int(30) NOT NULL,
`itemGuid` int(30) NOT NULL,
PRIMARY KEY (`guildId`,`tabId`,`slotId`),
KEY `a` (`guildId`),
KEY `b` (`tabId`),
KEY `c` (`slotId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
#
# Table structure for table guild_banklogs
#
CREATE TABLE `guild_banklogs` (
`log_id` int(30) NOT NULL,
`guildid` int(30) NOT NULL,
`tabid` int(30) NOT NULL COMMENT 'tab 6 is money logs',
`action` int(5) NOT NULL,
`player_guid` int(30) NOT NULL,
`item_entry` int(30) NOT NULL,
`stack_count` int(30) NOT NULL,
`timestamp` int(30) NOT NULL,
PRIMARY KEY (`log_id`,`guildid`),
KEY `a` (`guildid`),
KEY `b` (`tabid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
#
# Table structure for table guild_banktabs
#
CREATE TABLE `guild_banktabs` (
`guildId` int(30) NOT NULL,
`tabId` int(30) NOT NULL,
`tabName` varchar(200) NOT NULL,
`tabIcon` varchar(200) NOT NULL,
PRIMARY KEY (`guildId`,`tabId`),
KEY `a` (`guildId`),
KEY `b` (`tabId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
#
# Table structure for table guild_checkpoints
#
CREATE TABLE `guild_checkpoints` (
`guildid` int(30) NOT NULL,
`checkid` int(30) NOT NULL,
PRIMARY KEY (`guildid`,`checkid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
#
# Table structure for table guild_data
#
CREATE TABLE `guild_data` (
`guildid` int(30) NOT NULL,
`playerid` int(30) NOT NULL,
`guildRank` int(30) NOT NULL,
`publicNote` varchar(300) NOT NULL,
`officerNote` varchar(300) NOT NULL,
`lastWithdrawReset` int(30) NOT NULL default '0',
`withdrawlsSinceLastReset` int(30) NOT NULL default '0',
`lastItemWithdrawReset0` int(30) NOT NULL default '0',
`itemWithdrawlsSinceLastReset0` int(30) NOT NULL default '0',
`lastItemWithdrawReset1` int(30) NOT NULL,
`itemWithdrawlsSinceLastReset1` int(30) NOT NULL,
`lastItemWithdrawReset2` int(30) NOT NULL,
`itemWithdrawlsSinceLastReset2` int(30) NOT NULL,
`lastItemWithdrawReset3` int(30) NOT NULL,
`itemWithdrawlsSinceLastReset3` int(30) NOT NULL,
`lastItemWithdrawReset4` int(30) NOT NULL,
`itemWithdrawlsSinceLastReset4` int(30) NOT NULL,
`lastItemWithdrawReset5` int(30) NOT NULL,
`itemWithdrawlsSinceLastReset5` int(30) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
#
# Table structure for table guild_logs
#
CREATE TABLE `guild_logs` (
`log_id` int(30) NOT NULL,
`guildid` int(30) NOT NULL,
`timestamp` int(30) NOT NULL,
`event_type` int(30) NOT NULL,
`misc1` int(30) NOT NULL,
`misc2` int(30) NOT NULL,
`misc3` int(30) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
#
# Table structure for table guild_ranks
#
CREATE TABLE `guild_ranks` (
`guildId` int(6) unsigned NOT NULL default '0',
`rankId` int(1) NOT NULL default '0',
`rankName` varchar(255) NOT NULL default '',
`rankRights` int(3) unsigned NOT NULL default '0',
`goldLimitPerDay` int(30) NOT NULL default '0',
`bankTabFlags0` int(30) NOT NULL default '0',
`itemStacksPerDay0` int(30) NOT NULL default '0',
`bankTabFlags1` int(30) NOT NULL default '0',
`itemStacksPerDay1` int(30) NOT NULL default '0',
`bankTabFlags2` int(30) NOT NULL default '0',
`itemStacksPerDay2` int(30) NOT NULL default '0',
`bankTabFlags3` int(30) NOT NULL default '0',
`itemStacksPerDay3` int(30) NOT NULL default '0',
`bankTabFlags4` int(30) NOT NULL default '0',
`itemStacksPerDay4` int(30) NOT NULL default '0',
`bankTabFlags5` int(30) NOT NULL default '0',
`itemStacksPerDay5` int(30) NOT NULL default '0',
PRIMARY KEY (`guildId`,`rankId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
#
# Table structure for table guilds
#
CREATE TABLE `guilds` (
`guildId` bigint(20) NOT NULL auto_increment,
`guildName` varchar(32) NOT NULL default '',
`leaderGuid` bigint(20) NOT NULL default '0',
`emblemStyle` int(10) NOT NULL default '0',
`emblemColor` int(10) NOT NULL default '0',
`borderStyle` int(10) NOT NULL default '0',
`borderColor` int(10) NOT NULL default '0',
`backgroundColor` int(10) NOT NULL default '0',
`guildInfo` varchar(100) NOT NULL default '',
`motd` varchar(100) NOT NULL default '',
`createdate` int(30) NOT NULL default '0',
`bankTabCount` int(30) NOT NULL default '0',
`bankBalance` int(30) NOT NULL,
PRIMARY KEY (`guildId`),
UNIQUE KEY `guildId` (`guildId`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
#
# Table structure for table instances
#
CREATE TABLE `instances` (
`id` int(30) NOT NULL,
`mapid` int(30) NOT NULL,
`creation` int(30) NOT NULL,
`expiration` int(30) NOT NULL,
`killed_npc_guids` text NOT NULL,
`difficulty` int(30) NOT NULL,
`creator_group` int(30) NOT NULL,
`creator_guid` int(30) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
#
# Table structure for table ipbans
#
CREATE TABLE `ipbans` (
`ip` varchar(15) collate utf8_unicode_ci NOT NULL,
`expire` int(16) unsigned NOT NULL default '0',
PRIMARY KEY (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
#
# Table structure for table mailbox
#
CREATE TABLE `mailbox` (
`message_id` int(30) NOT NULL default '0',
`message_type` int(30) NOT NULL default '0',
`player_guid` int(30) NOT NULL default '0',
`sender_guid` int(30) NOT NULL default '0',
`subject` varchar(255) NOT NULL default '',
`body` longtext NOT NULL,
`money` int(30) NOT NULL default '0',
`attached_item_guids` varchar(200) NOT NULL default '',
`cod` int(30) NOT NULL default '0',
`stationary` int(30) NOT NULL default '0',
`expiry_time` int(30) NOT NULL default '0',
`delivery_time` int(30) NOT NULL default '0',
`copy_made` int(30) NOT NULL default '0',
`read_flag` int(30) NOT NULL default '0',
`deleted_flag` int(30) NOT NULL default '0',
PRIMARY KEY (`message_id`),
KEY `b` (`player_guid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
#
# Table structure for table mailbox_insert_queue
#
CREATE TABLE `mailbox_insert_queue` (
`sender_guid` int(30) NOT NULL,
`receiver_guid` int(30) NOT NULL,
`subject` varchar(200) NOT NULL,
`body` varchar(500) NOT NULL,
`stationary` int(30) NOT NULL,
`money` int(30) NOT NULL,
`item_id` int(30) NOT NULL,
`item_stack` int(30) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
#
# Table structure for table playercooldowns
#
CREATE TABLE `playercooldowns` (
`player_guid` int(30) NOT NULL,
`cooldown_type` int(30) NOT NULL COMMENT '0 is spell, 1 is item, 2 is spell category',
`cooldown_misc` int(30) NOT NULL COMMENT 'spellid/itemid/category',
`cooldown_expire_time` int(30) NOT NULL COMMENT 'expiring time in unix epoch format',
`cooldown_spellid` int(30) NOT NULL COMMENT 'spell that cast it',
`cooldown_itemid` int(30) NOT NULL COMMENT 'item that cast it'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#
# Table structure for table playeritems
#
CREATE TABLE `playeritems` (
`ownerguid` int(10) unsigned NOT NULL default '0',
`guid` bigint(10) NOT NULL auto_increment,
`entry` int(10) unsigned NOT NULL default '0',
`wrapped_item_id` int(30) NOT NULL default '0',
`wrapped_creator` int(30) NOT NULL default '0',
`creator` int(10) unsigned NOT NULL default '0',
`count` int(10) unsigned NOT NULL default '0',
`charges` int(10) unsigned NOT NULL default '0',
`flags` int(10) unsigned NOT NULL default '0',
`randomprop` int(10) unsigned NOT NULL default '0',
`randomsuffix` int(10) NOT NULL,
`itemtext` int(10) unsigned NOT NULL default '0',
`durability` int(10) unsigned NOT NULL default '0',
`containerslot` int(11) default '-1',
`slot` int(10) NOT NULL default '0',
`enchantments` longtext NOT NULL,
PRIMARY KEY (`guid`),
KEY `ownerguid` (`ownerguid`),
KEY `itemtext` (`itemtext`)
) ENGINE=MyISAM AUTO_INCREMENT=87328711 DEFAULT CHARSET=latin1;
#
# Table structure for table playeritems_external
#
CREATE TABLE `playeritems_external` (
`ownerguid` int(10) unsigned NOT NULL default '0',
`guid` bigint(20) unsigned NOT NULL default '0',
`entry` int(10) unsigned NOT NULL default '0',
`creator` int(10) unsigned NOT NULL default '0',
`count` int(10) unsigned NOT NULL default '0',
`charges` int(10) unsigned NOT NULL default '0',
`flags` int(10) unsigned NOT NULL default '0',
`randomprop` int(10) unsigned NOT NULL default '0',
`randomsuffix` int(30) NOT NULL,
`itemtext` int(10) unsigned NOT NULL default '0',
`durability` int(10) unsigned NOT NULL default '0',
`containerslot` int(11) default '-1',
`slot` tinyint(4) NOT NULL default '0',
`enchantments` longtext collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`guid`),
UNIQUE KEY `guid` (`guid`),
KEY `ownerguid` (`ownerguid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
#
# Table structure for table playeritems_insert_queue
#
CREATE TABLE `playeritems_insert_queue` (
`ownerguid` int(10) unsigned NOT NULL default '0',
`entry` int(10) unsigned NOT NULL default '0',
`wrapped_item_id` int(30) NOT NULL default '0',
`wrapped_creator` int(30) NOT NULL default '0',
`creator` int(10) unsigned NOT NULL default '0',
`count` int(10) unsigned NOT NULL default '0',
`charges` int(10) unsigned NOT NULL default '0',
`flags` int(10) unsigned NOT NULL default '0',
`randomprop` int(10) unsigned NOT NULL default '0',
`randomsuffix` int(30) NOT NULL,
`itemtext` int(10) unsigned NOT NULL default '0',
`durability` int(10) unsigned NOT NULL default '0',
`containerslot` int(11) NOT NULL default '-1' COMMENT 'couldnt find this being used in source',
`slot` tinyint(4) NOT NULL default '0',
`enchantments` longtext collate utf8_unicode_ci NOT NULL,
KEY `ownerguid` (`ownerguid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
#
# Table structure for 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 '',
`entry` int(10) unsigned NOT NULL default '0',
`fields` longtext character set utf8 collate utf8_unicode_ci 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',
`loyaltypts` int(11) NOT NULL,
`loyaltyupdate` int(11) NOT NULL,
PRIMARY KEY (`ownerguid`,`petnumber`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
#
# Table structure for table playerpetspells
#
CREATE TABLE `playerpetspells` (
`ownerguid` bigint(20) NOT NULL default '0',
`petnumber` int(4) NOT NULL default '0',
`spellid` int(4) NOT NULL default '0',
`flags` int(4) NOT NULL default '0',
KEY `a` (`ownerguid`),
KEY `b` (`petnumber`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
#
# Table structure for table playersummonspells
#
CREATE TABLE `playersummonspells` (
`ownerguid` bigint(20) NOT NULL default '0',
`entryid` int(4) NOT NULL default '0',
`spellid` int(4) NOT NULL default '0',
KEY `a` (`ownerguid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
#
# Table structure for table questlog
#
CREATE TABLE `questlog` (
`player_guid` bigint(20) unsigned NOT NULL default '0',
`quest_id` bigint(20) unsigned NOT NULL default '0',
`slot` int(20) unsigned NOT NULL default '0',
`time_left` bigint(20) NOT NULL default '0',
`explored_area1` bigint(20) unsigned NOT NULL default '0',
`explored_area2` bigint(20) unsigned NOT NULL default '0',
`explored_area3` bigint(20) unsigned NOT NULL default '0',
`explored_area4` bigint(20) unsigned NOT NULL default '0',
`mob_kill1` bigint(20) NOT NULL default '0',
`mob_kill2` bigint(20) NOT NULL default '0',
`mob_kill3` bigint(20) NOT NULL default '0',
`mob_kill4` bigint(20) NOT NULL default '0',
PRIMARY KEY (`player_guid`,`quest_id`)
) ENGINE=MyISAM AUTO_INCREMENT=33067588 DEFAULT CHARSET=latin1;
#
# Table structure for table server_settings
#
CREATE TABLE `server_settings` (
`setting_id` varchar(200) NOT NULL,
`setting_value` int(50) NOT NULL,
PRIMARY KEY (`setting_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
#
# Table structure for table social_friends
#
CREATE TABLE `social_friends` (
`character_guid` int(30) NOT NULL,
`friend_guid` int(30) NOT NULL,
`note` varchar(100) NOT NULL,
PRIMARY KEY (`character_guid`,`friend_guid`),
KEY `a` (`character_guid`),
KEY `b` (`friend_guid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#
# Table structure for table social_ignores
#
CREATE TABLE `social_ignores` (
`character_guid` int(30) NOT NULL,
`ignore_guid` int(30) NOT NULL,
PRIMARY KEY (`character_guid`,`ignore_guid`),
KEY `a` (`character_guid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#
# Table structure for table tutorials
#
CREATE TABLE `tutorials` (
`playerId` bigint(20) unsigned NOT NULL default '0',
`tut0` bigint(20) unsigned NOT NULL default '0',
`tut1` bigint(20) unsigned NOT NULL default '0',
`tut2` bigint(20) unsigned NOT NULL default '0',
`tut3` bigint(20) unsigned NOT NULL default '0',
`tut4` bigint(20) unsigned NOT NULL default '0',
`tut5` bigint(20) unsigned NOT NULL default '0',
`tut6` bigint(20) unsigned NOT NULL default '0',
`tut7` bigint(20) unsigned NOT NULL default '0',
PRIMARY KEY (`playerId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
Re: [Help Request] Character creation problem
I got the same problem, I'm using ArcEmu and NCDB, that didn't work on NCDB and I tried it on WhyDB and no luck either.
Re: [Help Request] Character creation problem
i had the same problem before. i managed to pass it by adding this query:
Code:
alter table characters add column finisheddailies longtext not null after finished_quests;
Re: [Help Request] Character creation problem
This did it for me;
Code:
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for account_data
-- ----------------------------
CREATE TABLE `account_data` (
`acct` int(30) NOT NULL,
`uiconfig0` blob,
`uiconfig1` blob,
`uiconfig2` blob,
`uiconfig3` blob,
`uiconfig4` blob,
`uiconfig5` blob,
`uiconfig6` blob,
`uiconfig7` blob,
`uiconfig8` blob,
PRIMARY KEY (`acct`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for account_forced_permissions
-- ----------------------------
CREATE TABLE `account_forced_permissions` (
`login` varchar(50) NOT NULL,
`permissions` varchar(100) NOT NULL,
PRIMARY KEY (`login`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for arenateams
-- ----------------------------
CREATE TABLE `arenateams` (
`id` int(30) NOT NULL,
`type` int(30) NOT NULL,
`leader` int(30) NOT NULL,
`name` varchar(150) NOT NULL,
`emblemstyle` int(40) NOT NULL,
`emblemcolour` bigint(40) NOT NULL,
`borderstyle` int(40) NOT NULL,
`bordercolour` bigint(40) NOT NULL,
`backgroundcolour` bigint(40) NOT NULL,
`rating` int(30) NOT NULL,
`data` varchar(150) NOT NULL,
`ranking` int(30) NOT NULL,
`player_data1` varchar(60) NOT NULL,
`player_data2` varchar(60) NOT NULL,
`player_data3` varchar(60) NOT NULL,
`player_data4` varchar(60) NOT NULL,
`player_data5` varchar(60) NOT NULL,
`player_data6` varchar(60) NOT NULL,
`player_data7` varchar(60) NOT NULL,
`player_data8` varchar(60) NOT NULL,
`player_data9` varchar(60) NOT NULL,
`player_data10` varchar(60) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for auctions
-- ----------------------------
CREATE TABLE `auctions` (
`auctionId` int(32) NOT NULL auto_increment,
`auctionhouse` int(32) default NULL,
`item` bigint(10) default NULL,
`owner` bigint(10) default NULL,
`buyout` int(32) default NULL,
`time` int(32) default NULL,
`bidder` bigint(10) default NULL,
`bid` int(32) default NULL,
`deposit` int(32) default NULL,
PRIMARY KEY (`auctionId`),
KEY `b` (`auctionhouse`)
) ENGINE=MyISAM AUTO_INCREMENT=1027356 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for banned_names
-- ----------------------------
CREATE TABLE `banned_names` (
`name` varchar(30) collate utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- ----------------------------
-- Table structure for characters
-- ----------------------------
CREATE TABLE `characters` (
`guid` int(6) unsigned NOT NULL default '0',
`acct` int(20) unsigned NOT NULL default '0',
`name` varchar(21) NOT NULL default '',
`race` smallint(3) NOT NULL,
`class` smallint(3) NOT NULL,
`gender` tinyint(1) NOT NULL,
`custom_faction` int(30) NOT NULL default '0',
`level` int(3) NOT NULL,
`xp` int(30) NOT NULL,
`exploration_data` longtext NOT NULL,
`skills` longtext NOT NULL,
`watched_faction_index` bigint(40) NOT NULL,
`selected_pvp_title` int(30) NOT NULL,
`available_pvp_titles` int(30) NOT NULL,
`gold` int(30) NOT NULL,
`ammo_id` int(30) NOT NULL,
`available_prof_points` int(30) NOT NULL,
`available_talent_points` int(30) NOT NULL,
`current_hp` int(30) NOT NULL,
`current_power` int(30) NOT NULL,
`pvprank` int(30) NOT NULL,
`bytes` int(30) NOT NULL,
`bytes2` int(30) NOT NULL,
`player_flags` int(30) NOT NULL,
`player_bytes` int(30) NOT NULL,
`positionX` float NOT NULL default '0',
`positionY` float NOT NULL default '0',
`positionZ` float NOT NULL default '0',
`orientation` float NOT NULL default '0',
`mapId` int(8) unsigned NOT NULL default '0',
`zoneId` int(8) unsigned NOT NULL default '0',
`taximask` longtext NOT NULL,
`banned` int(40) unsigned NOT NULL default '0',
`banReason` varchar(255) NOT NULL,
`timestamp` int(30) default NULL,
`online` int(11) default NULL,
`bindpositionX` float NOT NULL default '0',
`bindpositionY` float NOT NULL default '0',
`bindpositionZ` float NOT NULL default '0',
`bindmapId` int(8) unsigned NOT NULL default '0',
`bindzoneId` int(8) unsigned NOT NULL default '0',
`isResting` int(3) NOT NULL default '0',
`restState` int(5) NOT NULL default '0',
`restTime` int(5) NOT NULL default '0',
`playedtime` text NOT NULL,
`deathstate` int(5) NOT NULL default '0',
`TalentResetTimes` int(5) NOT NULL default '0',
`first_login` tinyint(1) NOT NULL default '0',
`forced_rename_pending` tinyint(1) NOT NULL default '0',
`arenaPoints` int(10) NOT NULL,
`totalstableslots` int(10) unsigned NOT NULL default '0',
`instance_id` int(10) NOT NULL,
`entrypointmap` int(10) NOT NULL,
`entrypointx` float NOT NULL,
`entrypointy` float NOT NULL,
`entrypointz` float NOT NULL,
`entrypointo` float NOT NULL,
`entrypointinstance` int(10) NOT NULL,
`taxi_path` int(10) NOT NULL,
`taxi_lastnode` int(10) NOT NULL,
`taxi_mountid` int(10) NOT NULL,
`transporter` int(10) NOT NULL,
`transporter_xdiff` float NOT NULL,
`transporter_ydiff` float NOT NULL,
`transporter_zdiff` float NOT NULL,
`spells` longtext NOT NULL,
`deleted_spells` longtext NOT NULL,
`reputation` longtext NOT NULL,
`actions` longtext NOT NULL,
`auras` longtext NOT NULL,
`finished_quests` longtext NOT NULL,
`finisheddailies` longtext NOT NULL,
`honorRolloverTime` int(30) NOT NULL default '0',
`killsToday` int(10) NOT NULL default '0',
`killsYesterday` int(10) NOT NULL default '0',
`killsLifeTime` int(10) NOT NULL default '0',
`honorToday` int(10) NOT NULL default '0',
`honorYesterday` int(10) NOT NULL default '0',
`honorPoints` int(10) NOT NULL default '0',
`difficulty` int(4) NOT NULL default '0',
PRIMARY KEY (`guid`),
KEY `acct` (`acct`),
KEY `name` (`name`),
KEY `b` (`banned`),
KEY `c` (`online`),
KEY `d` (`forced_rename_pending`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for characters_insert_queue
-- ----------------------------
CREATE TABLE `characters_insert_queue` (
`insert_temp_guid` int(10) unsigned NOT NULL default '0',
`acct` int(10) unsigned NOT NULL default '0',
`name` varchar(21) collate utf8_unicode_ci NOT NULL,
`race` tinyint(3) unsigned NOT NULL default '0',
`class` tinyint(3) unsigned NOT NULL default '0',
`gender` tinyint(3) unsigned NOT NULL default '0',
`custom_faction` int(30) NOT NULL default '0',
`level` int(10) unsigned NOT NULL default '0',
`xp` int(10) unsigned NOT NULL default '0',
`exploration_data` longtext collate utf8_unicode_ci NOT NULL,
`skills` longtext collate utf8_unicode_ci NOT NULL,
`watched_faction_index` int(10) unsigned NOT NULL default '0',
`selected_pvp_title` int(10) unsigned NOT NULL default '0',
`available_pvp_titles` int(10) unsigned NOT NULL default '0',
`gold` int(10) unsigned NOT NULL default '0',
`ammo_id` int(10) unsigned NOT NULL default '0',
`available_prof_points` int(10) unsigned NOT NULL default '0',
`available_talent_points` int(10) unsigned NOT NULL default '0',
`current_hp` int(10) unsigned NOT NULL default '0',
`current_power` int(10) unsigned NOT NULL default '0',
`pvprank` tinyint(3) unsigned NOT NULL default '0',
`bytes` int(10) unsigned NOT NULL default '0',
`bytes2` int(10) unsigned NOT NULL default '0',
`player_flags` int(10) unsigned NOT NULL default '0',
`player_bytes` int(10) unsigned NOT NULL default '0',
`positionX` float NOT NULL default '0',
`positionY` float NOT NULL default '0',
`positionZ` float NOT NULL default '0',
`orientation` float NOT NULL default '0',
`mapId` int(10) unsigned NOT NULL default '0',
`zoneId` int(10) unsigned NOT NULL default '0',
`taximask` longtext collate utf8_unicode_ci NOT NULL,
`banned` int(40) NOT NULL,
`banReason` varchar(50) collate utf8_unicode_ci NOT NULL,
`timestamp` int(11) NOT NULL,
`online` int(11) default NULL,
`bindpositionX` float NOT NULL default '0',
`bindpositionY` float NOT NULL default '0',
`bindpositionZ` float NOT NULL default '0',
`bindmapId` int(10) unsigned NOT NULL default '0',
`bindzoneId` int(10) unsigned NOT NULL default '0',
`isResting` tinyint(3) unsigned NOT NULL default '0',
`restState` tinyint(3) unsigned NOT NULL default '0',
`restTime` int(10) unsigned NOT NULL default '0',
`playedtime` longtext collate utf8_unicode_ci NOT NULL,
`deathstate` int(10) unsigned NOT NULL default '0',
`TalentResetTimes` int(10) unsigned NOT NULL default '0',
`first_login` tinyint(3) unsigned NOT NULL default '0',
`forced_rename_pending` tinyint(3) unsigned NOT NULL default '0',
`publicNote` varchar(32) collate utf8_unicode_ci NOT NULL,
`officerNote` varchar(32) collate utf8_unicode_ci NOT NULL,
`guildid` int(10) unsigned NOT NULL default '0',
`guildRank` int(10) unsigned NOT NULL default '0',
`arenaPoints` int(10) NOT NULL,
`totalstableslots` int(10) unsigned NOT NULL default '0',
`instance_id` int(10) unsigned NOT NULL default '0',
`entrypointmap` int(10) unsigned NOT NULL default '0',
`entrypointx` float NOT NULL default '0',
`entrypointy` float NOT NULL default '0',
`entrypointz` float NOT NULL default '0',
`entrypointo` float NOT NULL default '0',
`entrypointinstance` int(10) unsigned NOT NULL default '0',
`taxi_path` int(10) unsigned NOT NULL default '0',
`taxi_lastnode` int(10) unsigned NOT NULL default '0',
`taxi_mountid` int(10) unsigned NOT NULL default '0',
`transporter` int(10) unsigned NOT NULL default '0',
`transporter_xdiff` float NOT NULL default '0',
`transporter_ydiff` float NOT NULL default '0',
`transporter_zdiff` float NOT NULL default '0',
`spells` longtext collate utf8_unicode_ci NOT NULL,
`deleted_spells` longtext collate utf8_unicode_ci NOT NULL,
`reputation` longtext collate utf8_unicode_ci NOT NULL,
`actions` longtext collate utf8_unicode_ci NOT NULL,
`auras` longtext collate utf8_unicode_ci NOT NULL,
`finished_quests` longtext collate utf8_unicode_ci NOT NULL,
`honorPointsToAdd` int(10) NOT NULL,
`killsToday` int(10) unsigned NOT NULL default '0',
`killsYesterday` int(10) unsigned NOT NULL default '0',
`killsLifeTime` int(10) unsigned NOT NULL default '0',
`honorToday` int(10) unsigned NOT NULL default '0',
`honorYesterday` int(10) unsigned NOT NULL default '0',
`honorPoints` int(10) unsigned NOT NULL default '0',
`difficulty` int(10) unsigned NOT NULL default '0',
UNIQUE KEY `guid` (`insert_temp_guid`),
KEY `acct` (`acct`),
KEY `guildid` (`guildid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- ----------------------------
-- Table structure for charters
-- ----------------------------
CREATE TABLE `charters` (
`charterId` int(30) NOT NULL,
`charterType` int(30) NOT NULL default '0',
`leaderGuid` int(20) unsigned NOT NULL default '0',
`guildName` varchar(32) NOT NULL default '',
`itemGuid` bigint(40) unsigned NOT NULL default '0',
`signer1` int(10) unsigned NOT NULL default '0',
`signer2` int(10) unsigned NOT NULL default '0',
`signer3` int(10) unsigned NOT NULL default '0',
`signer4` int(10) unsigned NOT NULL default '0',
`signer5` int(10) unsigned NOT NULL default '0',
`signer6` int(10) unsigned NOT NULL default '0',
`signer7` int(10) unsigned NOT NULL default '0',
`signer8` int(10) unsigned NOT NULL default '0',
`signer9` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`charterId`),
UNIQUE KEY `leaderGuid` (`leaderGuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='InnoDB free: 11264 kB; InnoDB free: 18432 kB';
-- ----------------------------
-- Table structure for clientaddons
-- ----------------------------
CREATE TABLE `clientaddons` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(50) default NULL,
`crc` bigint(50) default NULL,
`banned` int(1) NOT NULL default '0',
`showinlist` int(1) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `index` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=153 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for command_overrides
-- ----------------------------
CREATE TABLE `command_overrides` (
`command_name` varchar(100) NOT NULL,
`access_level` varchar(10) NOT NULL,
PRIMARY KEY (`command_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for corpses
-- ----------------------------
CREATE TABLE `corpses` (
`guid` bigint(20) unsigned NOT NULL default '0',
`positionX` float NOT NULL default '0',
`positionY` float NOT NULL default '0',
`positionZ` float NOT NULL default '0',
`orientation` float NOT NULL default '0',
`zoneId` int(11) NOT NULL default '38',
`mapId` int(11) NOT NULL default '0',
`instanceId` int(11) NOT NULL default '0',
`data` longtext NOT NULL,
PRIMARY KEY (`guid`),
KEY `b` (`instanceId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for gm_tickets
-- ----------------------------
CREATE TABLE `gm_tickets` (
`guid` INTEGER(11) NOT NULL,
`playerGuid` INTEGER(11) NOT NULL,
`name` VARCHAR(200) NOT NULL DEFAULT '',
`level` INTEGER(6) NOT NULL DEFAULT '0',
`type` INTEGER(2) NOT NULL DEFAULT '0',
`posX` FLOAT NOT NULL DEFAULT '0',
`posY` FLOAT NOT NULL DEFAULT '0',
`posZ` FLOAT NOT NULL DEFAULT '0',
`message` TEXT NOT NULL,
`timestamp` TEXT,
`deleted` BIT(1) NOT NULL DEFAULT 0,
`assignedto` INTEGER(11) NOT NULL DEFAULT '0',
`comment` TEXT NOT NULL,
PRIMARY KEY (`guid`),
UNIQUE KEY `guid` (`guid`)
)ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for groups
-- ----------------------------
CREATE TABLE `groups` (
`group_id` int(30) NOT NULL,
`group_type` tinyint(2) NOT NULL,
`subgroup_count` tinyint(2) NOT NULL,
`loot_method` tinyint(2) NOT NULL,
`loot_threshold` tinyint(2) NOT NULL,
`difficulty` int(30) NOT NULL default '0',
`assistant_leader` int(30) NOT NULL default '0',
`main_tank` int(30) NOT NULL default '0',
`main_assist` int(30) NOT NULL default '0',
`group1member1` int(50) NOT NULL,
`group1member2` int(50) NOT NULL,
`group1member3` int(50) NOT NULL,
`group1member4` int(50) NOT NULL,
`group1member5` int(50) NOT NULL,
`group2member1` int(50) NOT NULL,
`group2member2` int(50) NOT NULL,
`group2member3` int(50) NOT NULL,
`group2member4` int(50) NOT NULL,
`group2member5` int(50) NOT NULL,
`group3member1` int(50) NOT NULL,
`group3member2` int(50) NOT NULL,
`group3member3` int(50) NOT NULL,
`group3member4` int(50) NOT NULL,
`group3member5` int(50) NOT NULL,
`group4member1` int(50) NOT NULL,
`group4member2` int(50) NOT NULL,
`group4member3` int(50) NOT NULL,
`group4member4` int(50) NOT NULL,
`group4member5` int(50) NOT NULL,
`group5member1` int(50) NOT NULL,
`group5member2` int(50) NOT NULL,
`group5member3` int(50) NOT NULL,
`group5member4` int(50) NOT NULL,
`group5member5` int(50) NOT NULL,
`group6member1` int(50) NOT NULL,
`group6member2` int(50) NOT NULL,
`group6member3` int(50) NOT NULL,
`group6member4` int(50) NOT NULL,
`group6member5` int(50) NOT NULL,
`group7member1` int(50) NOT NULL,
`group7member2` int(50) NOT NULL,
`group7member3` int(50) NOT NULL,
`group7member4` int(50) NOT NULL,
`group7member5` int(50) NOT NULL,
`group8member1` int(50) NOT NULL,
`group8member2` int(50) NOT NULL,
`group8member3` int(50) NOT NULL,
`group8member4` int(50) NOT NULL,
`group8member5` int(50) NOT NULL,
`timestamp` int(30) NOT NULL,
PRIMARY KEY (`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for guild_bankitems
-- ----------------------------
CREATE TABLE `guild_bankitems` (
`guildId` int(30) NOT NULL,
`tabId` int(30) NOT NULL,
`slotId` int(30) NOT NULL,
`itemGuid` int(30) NOT NULL,
PRIMARY KEY (`guildId`,`tabId`,`slotId`),
KEY `a` (`guildId`),
KEY `b` (`tabId`),
KEY `c` (`slotId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for guild_banklogs
-- ----------------------------
CREATE TABLE `guild_banklogs` (
`log_id` int(30) NOT NULL,
`guildid` int(30) NOT NULL,
`tabid` int(30) NOT NULL COMMENT 'tab 6 is money logs',
`action` int(5) NOT NULL,
`player_guid` int(30) NOT NULL,
`item_entry` int(30) NOT NULL,
`stack_count` int(30) NOT NULL,
`timestamp` int(30) NOT NULL,
PRIMARY KEY (`log_id`,`guildid`),
KEY `a` (`guildid`),
KEY `b` (`tabid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for guild_banktabs
-- ----------------------------
CREATE TABLE `guild_banktabs` (
`guildId` int(30) NOT NULL,
`tabId` int(30) NOT NULL,
`tabName` varchar(200) NOT NULL,
`tabIcon` varchar(200) NOT NULL,
PRIMARY KEY (`guildId`,`tabId`),
KEY `a` (`guildId`),
KEY `b` (`tabId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for guild_data
-- ----------------------------
CREATE TABLE `guild_data` (
`guildid` int(30) NOT NULL,
`playerid` int(30) NOT NULL,
`guildRank` int(30) NOT NULL,
`publicNote` varchar(300) NOT NULL,
`officerNote` varchar(300) NOT NULL,
`lastWithdrawReset` int(30) NOT NULL default '0',
`withdrawlsSinceLastReset` int(30) NOT NULL default '0',
`lastItemWithdrawReset0` int(30) NOT NULL default '0',
`itemWithdrawlsSinceLastReset0` int(30) NOT NULL default '0',
`lastItemWithdrawReset1` int(30) NOT NULL,
`itemWithdrawlsSinceLastReset1` int(30) NOT NULL,
`lastItemWithdrawReset2` int(30) NOT NULL,
`itemWithdrawlsSinceLastReset2` int(30) NOT NULL,
`lastItemWithdrawReset3` int(30) NOT NULL,
`itemWithdrawlsSinceLastReset3` int(30) NOT NULL,
`lastItemWithdrawReset4` int(30) NOT NULL,
`itemWithdrawlsSinceLastReset4` int(30) NOT NULL,
`lastItemWithdrawReset5` int(30) NOT NULL,
`itemWithdrawlsSinceLastReset5` int(30) NOT NULL,
KEY `a` (`guildid`),
KEY `b` (`playerid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for guild_logs
-- ----------------------------
CREATE TABLE `guild_logs` (
`log_id` int(30) NOT NULL,
`guildid` int(30) NOT NULL,
`timestamp` int(30) NOT NULL,
`event_type` int(30) NOT NULL,
`misc1` int(30) NOT NULL,
`misc2` int(30) NOT NULL,
`misc3` int(30) NOT NULL,
PRIMARY KEY (`log_id`,`guildid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for guild_ranks
-- ----------------------------
CREATE TABLE `guild_ranks` (
`guildId` int(6) unsigned NOT NULL default '0',
`rankId` int(1) NOT NULL default '0',
`rankName` varchar(255) NOT NULL default '',
`rankRights` int(3) unsigned NOT NULL default '0',
`goldLimitPerDay` int(30) NOT NULL default '0',
`bankTabFlags0` int(30) NOT NULL default '0',
`itemStacksPerDay0` int(30) NOT NULL default '0',
`bankTabFlags1` int(30) NOT NULL default '0',
`itemStacksPerDay1` int(30) NOT NULL default '0',
`bankTabFlags2` int(30) NOT NULL default '0',
`itemStacksPerDay2` int(30) NOT NULL default '0',
`bankTabFlags3` int(30) NOT NULL default '0',
`itemStacksPerDay3` int(30) NOT NULL default '0',
`bankTabFlags4` int(30) NOT NULL default '0',
`itemStacksPerDay4` int(30) NOT NULL default '0',
`bankTabFlags5` int(30) NOT NULL default '0',
`itemStacksPerDay5` int(30) NOT NULL default '0',
PRIMARY KEY (`guildId`,`rankId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for guilds
-- ----------------------------
CREATE TABLE `guilds` (
`guildId` bigint(20) NOT NULL auto_increment,
`guildName` varchar(32) NOT NULL default '',
`leaderGuid` bigint(20) NOT NULL default '0',
`emblemStyle` int(10) NOT NULL default '0',
`emblemColor` int(10) NOT NULL default '0',
`borderStyle` int(10) NOT NULL default '0',
`borderColor` int(10) NOT NULL default '0',
`backgroundColor` int(10) NOT NULL default '0',
`guildInfo` varchar(300) NOT NULL default '',
`motd` varchar(300) NOT NULL default '',
`createdate` int(30) NOT NULL,
`bankTabCount` int(30) NOT NULL,
`bankBalance` int(30) NOT NULL,
PRIMARY KEY (`guildId`),
UNIQUE KEY `guildId` (`guildId`)
) ENGINE=MyISAM AUTO_INCREMENT=8189 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for instances
-- ----------------------------
CREATE TABLE `instances` (
`id` int(30) NOT NULL,
`mapid` int(30) NOT NULL,
`creation` int(30) NOT NULL,
`expiration` int(30) NOT NULL,
`killed_npc_guids` text NOT NULL,
`difficulty` int(30) NOT NULL,
`creator_group` int(30) NOT NULL,
`creator_guid` int(30) NOT NULL,
PRIMARY KEY (`id`),
KEY `a` (`mapid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for mailbox
-- ----------------------------
CREATE TABLE `mailbox` (
`message_id` int(30) NOT NULL default '0',
`message_type` int(30) NOT NULL default '0',
`player_guid` int(30) NOT NULL default '0',
`sender_guid` int(30) NOT NULL default '0',
`subject` varchar(255) NOT NULL default '',
`body` longtext NOT NULL,
`money` int(30) NOT NULL default '0',
`attached_item_guids` varchar(200) NOT NULL default '',
`cod` int(30) NOT NULL default '0',
`stationary` int(30) NOT NULL default '0',
`expiry_time` int(30) NOT NULL default '0',
`delivery_time` int(30) NOT NULL default '0',
`copy_made` int(30) NOT NULL default '0',
`read_flag` int(30) NOT NULL default '0',
`deleted_flag` int(30) NOT NULL default '0',
PRIMARY KEY (`message_id`),
KEY `b` (`player_guid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for mailbox_insert_queue
-- ----------------------------
CREATE TABLE `mailbox_insert_queue` (
`sender_guid` int(30) NOT NULL,
`receiver_guid` int(30) NOT NULL,
`subject` varchar(200) NOT NULL,
`body` varchar(500) NOT NULL,
`stationary` int(30) NOT NULL,
`money` int(30) NOT NULL,
`item_id` int(30) NOT NULL,
`item_stack` int(30) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for playercooldowns
-- ----------------------------
CREATE TABLE `playercooldowns` (
`player_guid` int(30) NOT NULL,
`cooldown_type` int(30) NOT NULL COMMENT '0 is spell, 1 is item, 2 is spell category',
`cooldown_misc` int(30) NOT NULL COMMENT 'spellid/itemid/category',
`cooldown_expire_time` int(30) NOT NULL COMMENT 'expiring time in unix epoch format',
`cooldown_spellid` int(30) NOT NULL COMMENT 'spell that cast it',
`cooldown_itemid` int(30) NOT NULL COMMENT 'item that cast it'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for playeritems
-- ----------------------------
CREATE TABLE `playeritems` (
`ownerguid` int(10) unsigned NOT NULL default '0',
`guid` bigint(10) NOT NULL auto_increment,
`entry` int(10) unsigned NOT NULL default '0',
`wrapped_item_id` int(30) NOT NULL default '0',
`wrapped_creator` int(30) NOT NULL default '0',
`creator` int(10) unsigned NOT NULL default '0',
`count` int(10) unsigned NOT NULL default '0',
`charges` int(10) unsigned NOT NULL default '0',
`flags` int(10) unsigned NOT NULL default '0',
`randomprop` int(10) unsigned NOT NULL default '0',
`randomsuffix` int(10) NOT NULL,
`itemtext` int(10) unsigned NOT NULL default '0',
`durability` int(10) unsigned NOT NULL default '0',
`containerslot` int(11) default '-1',
`slot` int(10) NOT NULL default '0',
`enchantments` longtext NOT NULL,
PRIMARY KEY (`guid`),
KEY `ownerguid` (`ownerguid`),
KEY `itemtext` (`itemtext`)
) ENGINE=MyISAM AUTO_INCREMENT=87328711 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for playeritems_insert_queue
-- ----------------------------
CREATE TABLE `playeritems_insert_queue` (
`ownerguid` int(10) unsigned NOT NULL default '0',
`entry` int(10) unsigned NOT NULL default '0',
`wrapped_item_id` int(30) NOT NULL default '0',
`wrapped_creator` int(30) NOT NULL default '0',
`creator` int(10) unsigned NOT NULL default '0',
`count` int(10) unsigned NOT NULL default '0',
`charges` int(10) unsigned NOT NULL default '0',
`flags` int(10) unsigned NOT NULL default '0',
`randomprop` int(10) unsigned NOT NULL default '0',
`randomsuffix` int(30) NOT NULL,
`itemtext` int(10) unsigned NOT NULL default '0',
`durability` int(10) unsigned NOT NULL default '0',
`containerslot` int(11) NOT NULL default '-1' COMMENT 'couldnt find this being used in source',
`slot` tinyint(4) NOT NULL default '0',
`enchantments` longtext collate utf8_unicode_ci NOT NULL,
KEY `ownerguid` (`ownerguid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- ----------------------------
-- Table structure for playerpets
-- ----------------------------
CREATE TABLE `playerpets` (
`ownerguid` bigint(20) NOT NULL default '0',
`petnumber` int(11) NOT NULL default '0',
`name` varchar(21) NOT NULL default '',
`entry` int(10) unsigned NOT NULL default '0',
`fields` longtext character set utf8 collate utf8_unicode_ci 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',
`loyaltypts` int(11) NOT NULL,
`loyaltyupdate` int(11) NOT NULL,
PRIMARY KEY (`ownerguid`,`petnumber`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for playerpetspells
-- ----------------------------
CREATE TABLE `playerpetspells` (
`ownerguid` bigint(20) NOT NULL default '0',
`petnumber` int(4) NOT NULL default '0',
`spellid` int(4) NOT NULL default '0',
`flags` int(4) NOT NULL default '0',
KEY `a` (`ownerguid`),
KEY `b` (`petnumber`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for playersummonspells
-- ----------------------------
CREATE TABLE `playersummonspells` (
`ownerguid` bigint(20) NOT NULL default '0',
`entryid` int(4) NOT NULL default '0',
`spellid` int(4) NOT NULL default '0',
KEY `a` (`ownerguid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for questlog
-- ----------------------------
CREATE TABLE `questlog` (
`player_guid` bigint(20) unsigned NOT NULL default '0',
`quest_id` bigint(20) unsigned NOT NULL default '0',
`slot` int(20) unsigned NOT NULL default '0',
`time_left` bigint(20) NOT NULL default '0',
`explored_area1` bigint(20) unsigned NOT NULL default '0',
`explored_area2` bigint(20) unsigned NOT NULL default '0',
`explored_area3` bigint(20) unsigned NOT NULL default '0',
`explored_area4` bigint(20) unsigned NOT NULL default '0',
`mob_kill1` bigint(20) NOT NULL default '0',
`mob_kill2` bigint(20) NOT NULL default '0',
`mob_kill3` bigint(20) NOT NULL default '0',
`mob_kill4` bigint(20) NOT NULL default '0',
PRIMARY KEY (`player_guid`,`quest_id`)
) ENGINE=MyISAM AUTO_INCREMENT=33067588 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for server_settings
-- ----------------------------
CREATE TABLE `server_settings` (
`setting_id` varchar(200) NOT NULL,
`setting_value` int(50) NOT NULL,
PRIMARY KEY (`setting_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for social_friends
-- ----------------------------
CREATE TABLE `social_friends` (
`character_guid` int(30) NOT NULL,
`friend_guid` int(30) NOT NULL,
`note` varchar(100) NOT NULL,
PRIMARY KEY (`character_guid`,`friend_guid`),
KEY `a` (`character_guid`),
KEY `b` (`friend_guid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for social_ignores
-- ----------------------------
CREATE TABLE `social_ignores` (
`character_guid` int(30) NOT NULL,
`ignore_guid` int(30) NOT NULL,
PRIMARY KEY (`character_guid`,`ignore_guid`),
KEY `a` (`character_guid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for tutorials
-- ----------------------------
CREATE TABLE `tutorials` (
`playerId` bigint(20) unsigned NOT NULL default '0',
`tut0` bigint(20) unsigned NOT NULL default '0',
`tut1` bigint(20) unsigned NOT NULL default '0',
`tut2` bigint(20) unsigned NOT NULL default '0',
`tut3` bigint(20) unsigned NOT NULL default '0',
`tut4` bigint(20) unsigned NOT NULL default '0',
`tut5` bigint(20) unsigned NOT NULL default '0',
`tut6` bigint(20) unsigned NOT NULL default '0',
`tut7` bigint(20) unsigned NOT NULL default '0',
PRIMARY KEY (`playerId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
paste this in a word doc and put, then execute it via navicat, don't use New Query, use the Execute Batch File by right clicking then world database, make sure you have Ignore Errors ticked, then look at the file and just delete the character table, accounts table etc from your database but only the ones that the file has, and forget guild stuff thats not important, then just run it then have fun.
