Character Browser New character table SQL
Reply
New character table SQL
These are the new character tables that akkadius created to replace the old blob.


SQL
More +
CREATE TABLE `character_data` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`account_id` INT(11) NOT NULL DEFAULT '0',
`name` VARCHAR(64) NOT NULL DEFAULT '',
`last_name` VARCHAR(64) NOT NULL DEFAULT '',
`title` VARCHAR(32) NOT NULL DEFAULT '',
`suffix` VARCHAR(32) NOT NULL DEFAULT '',
`zone_id` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`zone_instance` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`y` FLOAT NOT NULL DEFAULT '0',
`x` FLOAT NOT NULL DEFAULT '0',
`z` FLOAT NOT NULL DEFAULT '0',
`heading` FLOAT NOT NULL DEFAULT '0',
`gender` tinyint(11) UNSIGNED NOT NULL DEFAULT 0,
`race` SMALLINT(11) UNSIGNED NOT NULL DEFAULT 0,
`class` tinyint(11) UNSIGNED NOT NULL DEFAULT 0,
`level` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`deity` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`birthday` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`last_login` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`time_played` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`level2` tinyint(11) UNSIGNED NOT NULL DEFAULT 0,
`anon` tinyint(11) UNSIGNED NOT NULL DEFAULT 0,
`gm` tinyint(11) UNSIGNED NOT NULL DEFAULT 0,
`face` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`hair_color` tinyint(11) UNSIGNED NOT NULL DEFAULT 0,
`hair_style` tinyint(11) UNSIGNED NOT NULL DEFAULT 0,
`beard` tinyint(11) UNSIGNED NOT NULL DEFAULT 0,
`beard_color` tinyint(11) UNSIGNED NOT NULL DEFAULT 0,
`eye_color_1` tinyint(11) UNSIGNED NOT NULL DEFAULT 0,
`eye_color_2` tinyint(11) UNSIGNED NOT NULL DEFAULT 0,
`drakkin_heritage` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`drakkin_tattoo` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`drakkin_details` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`ability_time_seconds` tinyint(11) UNSIGNED NOT NULL DEFAULT 0,
`ability_number` tinyint(11) UNSIGNED NOT NULL DEFAULT 0,
`ability_time_minutes` tinyint(11) UNSIGNED NOT NULL DEFAULT 0,
`ability_time_hours` tinyint(11) UNSIGNED NOT NULL DEFAULT 0,
`exp` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`aa_points_spent` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`aa_exp` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`aa_points` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`group_leadership_exp` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`raid_leadership_exp` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`group_leadership_points` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`raid_leadership_points` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`points` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`cur_hp` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`mana` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`endurance` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`intoxication` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`str` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`sta` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`cha` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`dex` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`int` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`agi` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`wis` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`zone_change_count` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`toxicity` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`hunger_level` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`thirst_level` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`ability_up` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`ldon_points_guk` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`ldon_points_mir` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`ldon_points_mmc` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`ldon_points_ruj` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`ldon_points_tak` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`ldon_points_available` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`tribute_time_remaining` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`career_tribute_points` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`tribute_points` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`tribute_active` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`pvp_status` tinyint(11) UNSIGNED NOT NULL DEFAULT 0,
`pvp_kills` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`pvp_deaths` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`pvp_current_points` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`pvp_career_points` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`pvp_best_kill_streak` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`pvp_worst_death_streak` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`pvp_current_kill_streak` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`pvp2` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`pvp_type` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`show_helm` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`group_auto_consent` tinyint(11) UNSIGNED NOT NULL DEFAULT 0,
`raid_auto_consent` tinyint(11) UNSIGNED NOT NULL DEFAULT 0,
`guild_auto_consent` tinyint(11) UNSIGNED NOT NULL DEFAULT 0,
`leadership_exp_on` tinyint(11) UNSIGNED NOT NULL DEFAULT 0,
`RestTimer` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`air_remaining` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`autosplit_enabled` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`lfp` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
`lfg` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
`mailkey` CHAR(16) NOT NULL DEFAULT '',
`xtargets` tinyint(3) UNSIGNED NOT NULL DEFAULT '5',
`firstlogon` tinyint(3) NOT NULL DEFAULT '0',
`e_aa_effects` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`e_percent_to_aa` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`e_expended_aa_spent` INT(11) UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY(`id`),
UNIQUE KEY `name` (`name`),
KEY `account_id` (`account_id`)
) ENGINE = InnoDB AUTO_INCREMENT = 1 DEFAULT CHARSET = latin1;


CREATE TABLE `character_currency` (
`id` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`platinum` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`gold` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`silver` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`copper` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`platinum_bank` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`gold_bank` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`silver_bank` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`copper_bank` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`platinum_cursor` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`gold_cursor` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`silver_cursor` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`copper_cursor` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`radiant_crystals` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`career_radiant_crystals` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`ebon_crystals` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`career_ebon_crystals` INT(11) UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY (`id`),
KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


CREATE TABLE `character_alternate_abilities` (
`id` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`slot` SMALLINT(11) UNSIGNED NOT NULL DEFAULT 0,
`aa_id` SMALLINT(11) UNSIGNED NOT NULL DEFAULT 0,
`aa_value` SMALLINT(11) UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY(`id`,`slot`),
KEY `id` (`id`)
) ENGINE = InnoDB DEFAULT CHARSET = latin1;


CREATE TABLE `character_bind` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`is_home` tinyint(11) UNSIGNED NOT NULL DEFAULT '0',
`zone_id` SMALLINT(11) UNSIGNED NOT NULL DEFAULT '0',
`instance_id` mediumint(11) UNSIGNED NOT NULL DEFAULT '0',
`x` FLOAT NOT NULL DEFAULT '0',
`y` FLOAT NOT NULL DEFAULT '0',
`z` FLOAT NOT NULL DEFAULT '0',
`heading` FLOAT NOT NULL DEFAULT '0',
PRIMARY KEY(`id`, `is_home`),
KEY `id` (`id`)
) ENGINE = InnoDB DEFAULT CHARSET = latin1;


CREATE TABLE `character_languages` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`lang_id` SMALLINT(11) UNSIGNED NOT NULL DEFAULT '0',
`value` SMALLINT(11) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY(`id`, `lang_id`),
KEY `id` (`id`)
) ENGINE = InnoDB DEFAULT CHARSET = latin1;


CREATE TABLE `character_skills` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`skill_id` SMALLINT(11) UNSIGNED NOT NULL DEFAULT '0',
`value` SMALLINT(11) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY(`id`, `skill_id`),
KEY `id` (`id`)
) ENGINE = InnoDB DEFAULT CHARSET = latin1;


CREATE TABLE `character_spells` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`slot_id` SMALLINT(11) UNSIGNED NOT NULL DEFAULT '0',
`spell_id` SMALLINT(11) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY(`id`, `slot_id`),
KEY `id` (`id`)
) ENGINE = InnoDB DEFAULT CHARSET = latin1;


CREATE TABLE `character_memmed_spells` (
`id` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`slot_id` SMALLINT(11) UNSIGNED NOT NULL DEFAULT '0',
`spell_id` SMALLINT(11) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY(`id`, `slot_id`),
KEY `id` (`id`)
) ENGINE = InnoDB DEFAULT CHARSET = latin1;


CREATE TABLE `character_disciplines` (
`id` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`slot_id` SMALLINT(11) UNSIGNED NOT NULL DEFAULT '0',
`disc_id` SMALLINT(11) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY(`id`, `slot_id`),
KEY `id` (`id`)
) ENGINE = InnoDB DEFAULT CHARSET = latin1;


CREATE TABLE `character_material` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`slot` tinyint(11) UNSIGNED NOT NULL DEFAULT '0',
`blue` tinyint(11) UNSIGNED NOT NULL DEFAULT '0',
`green` tinyint(11) UNSIGNED NOT NULL DEFAULT '0',
`red` tinyint(11) UNSIGNED NOT NULL DEFAULT '0',
`use_tint` tinyint(11) UNSIGNED NOT NULL DEFAULT '0',
`color` INT(11) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY(`id`, `slot`),
KEY `id` (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 1 DEFAULT CHARSET = latin1;


CREATE TABLE `character_tribute` (
`id` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`tier` tinyint(11) UNSIGNED NOT NULL DEFAULT '0',
`tribute` INT(11) UNSIGNED NOT NULL DEFAULT '0',
KEY `id` (`id`)
) ENGINE = InnoDB DEFAULT CHARSET = latin1;


CREATE TABLE `character_bandolier` (
`id` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`bandolier_id` tinyint(11) UNSIGNED NOT NULL DEFAULT '0',
`bandolier_slot` tinyint(11) UNSIGNED NOT NULL DEFAULT '0',
`item_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`icon` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`bandolier_name` VARCHAR(32) NOT NULL DEFAULT '0',
PRIMARY KEY(`id`,`bandolier_id`, `bandolier_slot`),
KEY `id` (`id`)
) ENGINE = InnoDB DEFAULT CHARSET = latin1;


CREATE TABLE `character_potionbelt` (
`id` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`potion_id` tinyint(11) UNSIGNED NOT NULL DEFAULT '0',
`item_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`icon` INT(11) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY(`id`,`potion_id`),
KEY `id` (`id`)
) ENGINE = InnoDB DEFAULT CHARSET = latin1;


CREATE TABLE `character_inspect_messages` (
`id` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`inspect_message` VARCHAR(255) NOT NULL DEFAULT '',
PRIMARY KEY(`id`),
KEY `id` (`id`)
) ENGINE = InnoDB DEFAULT CHARSET = latin1;


CREATE TABLE `character_leadership_abilities` (
`id` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`slot` SMALLINT(11) UNSIGNED NOT NULL DEFAULT 0,
`rank` SMALLINT(11) UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY(`id`,`slot`),
KEY `id` (`id`)
) ENGINE = InnoDB DEFAULT CHARSET = latin1;
Fri Sep 26, 2014 10:53 am
Project Lead
Character Browser New character table SQL
Reply