From 29b1eb3ed30e0dd50ba1cfe222a33b070e3e6e0b Mon Sep 17 00:00:00 2001
From: Kitzunu <24550914+Kitzunu@users.noreply.github.com>
Date: Sat, 1 May 2021 01:48:43 +0200
Subject: chore(docs): Update all integers to not use width (#448)
* float
* VARCHAR
* TIMESTAMP
* BIGINT
* MEDIUMINT
* SMALLINT
* TINYINT
* INT
* BLOB
* SIGNED/UNSIGNED
* AUTO_INCREMENT
* \(\d+\)
* Update Bit-and_bytes-tutorial.md
* clean-up
* Last mistakes
* this one didnt commit lul
---
docs/MySQLtypesC++.md | 34 ++--
docs/access_requirement.md | 20 +--
docs/account.md | 4 +-
docs/account_access.md | 8 +-
docs/account_banned.md | 12 +-
docs/account_data.md | 8 +-
docs/account_instance_times.md | 6 +-
docs/account_muted.md | 10 +-
docs/account_tutorial.md | 18 +-
docs/achievement_criteria_data.md | 8 +-
docs/achievement_dbc.md | 14 +-
docs/achievement_reward.md | 14 +-
docs/achievement_reward_locale.md | 4 +-
docs/acore_string.md | 2 +-
docs/addons.md | 4 +-
docs/areatrigger.md | 20 +--
docs/areatrigger_involvedrelation.md | 4 +-
docs/areatrigger_scripts.md | 2 +-
docs/areatrigger_tavern.md | 2 +-
docs/areatrigger_teleport.md | 12 +-
docs/arena_team.md | 30 ++--
docs/arena_team_member.md | 14 +-
docs/auctionhouse.md | 20 +--
docs/autobroadcast.md | 6 +-
docs/banned_addons.md | 8 +-
docs/battleground_deserters.md | 4 +-
docs/battleground_template.md | 22 +--
docs/battlemaster_entry.md | 4 +-
docs/broadcast_text.md | 28 +--
docs/broadcast_text_locale.md | 6 +-
docs/bugreport.md | 2 +-
docs/calendar_events.md | 18 +-
docs/calendar_invites.md | 16 +-
docs/channels.md | 14 +-
docs/channels_bans.md | 6 +-
docs/channels_rights.md | 10 +-
docs/character_account_data.md | 8 +-
docs/character_achievement.md | 8 +-
docs/character_achievement_progress.md | 10 +-
docs/character_action.md | 10 +-
docs/character_arena_stats.md | 6 +-
docs/character_aura.md | 32 ++--
docs/character_banned.md | 12 +-
docs/character_battleground_data.md | 22 +--
docs/character_battleground_random.md | 2 +-
docs/character_brew_of_the_month.md | 4 +-
docs/character_declinedname.md | 12 +-
docs/character_entry_point.md | 14 +-
docs/character_equipmentsets.md | 50 +++---
docs/character_gifts.md | 8 +-
docs/character_glyphs.md | 16 +-
docs/character_homebind.md | 12 +-
docs/character_instance.md | 6 +-
docs/character_inventory.md | 8 +-
docs/character_pet.md | 36 ++--
docs/character_pet_declinedname.md | 14 +-
docs/character_queststatus.md | 32 ++--
docs/character_queststatus_daily.md | 6 +-
docs/character_queststatus_monthly.md | 4 +-
docs/character_queststatus_rewarded.md | 6 +-
docs/character_queststatus_seasonal.md | 6 +-
docs/character_queststatus_weekly.md | 4 +-
docs/character_reputation.md | 8 +-
docs/character_skills.md | 8 +-
docs/character_social.md | 8 +-
docs/character_spell.md | 8 +-
docs/character_spell_cooldown.md | 8 +-
docs/character_stats.md | 62 +++----
docs/character_talent.md | 6 +-
docs/characters.md | 156 ++++++++---------
docs/cheaters.md | 18 --
docs/command.md | 6 +-
docs/conditions.md | 56 +++---
docs/corpse.md | 36 ++--
docs/creature.md | 40 ++---
docs/creature_addon.md | 20 +--
docs/creature_classlevelstats.md | 24 +--
docs/creature_equip_template.md | 10 +-
docs/creature_formations.md | 14 +-
docs/creature_model_info.md | 10 +-
docs/creature_onkill_reputation.md | 20 +--
docs/creature_questender.md | 4 +-
docs/creature_questitem.md | 6 +-
docs/creature_queststarter.md | 4 +-
docs/creature_respawn.md | 6 +-
docs/creature_summon_groups.md | 20 +--
docs/creature_template.md | 116 ++++++-------
docs/creature_template_locale.md | 32 ++--
docs/creature_template_movement.md | 10 +-
docs/creature_text.md | 24 +--
docs/creature_text_locale.md | 6 +-
docs/disables.md | 12 +-
docs/event_scripts.md | 20 +--
docs/exploration_basexp.md | 4 +-
docs/game_event.md | 20 +--
docs/game_event_arena_seasons.md | 4 +-
docs/game_event_battleground_holiday.md | 4 +-
docs/game_event_condition.md | 12 +-
docs/game_event_condition_save.md | 6 +-
docs/game_event_creature.md | 4 +-
docs/game_event_creature_quest.md | 6 +-
docs/game_event_gameobject.md | 4 +-
docs/game_event_gameobject_quest.md | 6 +-
docs/game_event_model_equip.md | 8 +-
docs/game_event_npc_vendor.md | 14 +-
docs/game_event_npcflag.md | 6 +-
docs/game_event_pool.md | 4 +-
docs/game_event_prerequisite.md | 4 +-
docs/game_event_quest_condition.md | 8 +-
docs/game_event_save.md | 6 +-
docs/game_event_seasonal_questrelation.md | 4 +-
docs/game_graveyard.md | 12 +-
docs/game_graveyard_zone.md | 6 +-
docs/game_tele.md | 14 +-
docs/game_weather.md | 26 +--
docs/gameobject.md | 32 ++--
docs/gameobject_addon.md | 6 +-
docs/gameobject_questender.md | 4 +-
docs/gameobject_questitem.md | 6 +-
docs/gameobject_queststarter.md | 4 +-
docs/gameobject_respawn.md | 6 +-
docs/gameobject_template.md | 70 ++++----
docs/gameobject_template_addon.md | 10 +-
docs/gameobject_template_locale.md | 34 ++--
docs/gm_subsurvey.md | 6 +-
docs/gm_subsurveys.md | 14 +-
docs/gm_survey.md | 55 ++++--
docs/gm_surveys.md | 45 -----
docs/gm_ticket.md | 34 ++--
docs/gossip_menu.md | 4 +-
docs/gossip_menu_option.md | 24 +--
docs/gossip_menu_option_action.md | 8 +-
docs/gossip_menu_option_locale.md | 36 ++--
docs/graveyard_zone.md | 6 +-
docs/group_instance.md | 6 +-
docs/group_member.md | 10 +-
docs/groups.md | 32 ++--
docs/guild.md | 24 +--
docs/guild_bank_eventlog.md | 20 +--
docs/guild_bank_item.md | 8 +-
docs/guild_bank_right.md | 10 +-
docs/guild_bank_tab.md | 10 +-
docs/guild_eventlog.md | 16 +-
docs/guild_member.md | 38 ++--
docs/guild_member_withdraw.md | 16 +-
docs/guild_rank.md | 12 +-
docs/holiday_dates.md | 8 +-
docs/instance.md | 12 +-
docs/instance_encounters.md | 10 +-
docs/instance_reset.md | 6 +-
docs/instance_template.md | 8 +-
docs/ip2nation.md | 2 +-
docs/ip2nationCountries.md | 14 +-
docs/ip_banned.md | 10 +-
docs/item_appearance.md | 8 +-
docs/item_effect.md | 20 +--
docs/item_enchantment_template.md | 6 +-
docs/item_instance.md | 22 +--
docs/item_loot_items.md | 22 +--
docs/item_loot_money.md | 4 +-
docs/item_loot_storage.md | 10 +-
docs/item_modified_appearance.md | 14 +-
docs/item_refund_instance.md | 8 +-
docs/item_set_names.md | 8 +-
docs/item_set_names_locale.md | 18 +-
docs/item_soulbound_trade_data.md | 4 +-
docs/item_sparse.md | 116 ++++++-------
docs/item_template.md | 278 +++++++++++++++---------------
docs/item_template_locale.md | 34 ++--
docs/lag_reports.md | 18 +-
docs/lfg_data.md | 6 +-
docs/lfg_dungeon_encounters.md | 4 +-
docs/lfg_dungeon_rewards.md | 16 +-
docs/lfg_dungeon_template.md | 12 +-
docs/lfg_entrances.md | 12 +-
docs/linked_respawn.md | 6 +-
docs/locales_achievement_reward.md | 18 +-
docs/locales_broadcast_text.md | 4 +-
docs/locales_creature_text.md | 6 +-
docs/locales_gossip_menu_option.md | 4 +-
docs/locales_item.md | 36 ++--
docs/locales_item_set_names.md | 18 +-
docs/locales_npc_text.md | 2 +-
docs/locales_page_text.md | 2 +-
docs/locales_points_of_interest.md | 2 +-
docs/locales_quest.md | 4 +-
docs/log_arena_fights.md | 24 +--
docs/log_arena_memberstats.md | 16 +-
docs/log_encounter.md | 8 +-
docs/log_money.md | 8 +-
docs/logs.md | 8 +-
docs/logs_ip_actions.md | 14 +-
docs/loot_template.md | 18 +-
docs/mail.md | 28 +--
docs/mail_items.md | 6 +-
docs/mail_level_reward.md | 8 +-
docs/npc_spellclick_spells.md | 8 +-
docs/npc_text.md | 164 +++++++++---------
docs/npc_text_locale.md | 258 +++++++++++++--------------
docs/npc_trainer.md | 12 +-
docs/npc_vendor.md | 12 +-
docs/outdoorpvp_template.md | 6 +-
docs/page_text.md | 8 +-
docs/page_text_locale.md | 6 +-
docs/pet_aura.md | 30 ++--
docs/pet_levelstats.md | 20 +--
docs/pet_name_generation.md | 8 +-
docs/pet_spell.md | 6 +-
docs/pet_spell_cooldown.md | 6 +-
docs/petition.md | 8 +-
docs/petition_sign.md | 10 +-
docs/phase_area.md | 6 +-
docs/player_classlevelstats.md | 8 +-
docs/player_factionchange_achievement.md | 4 +-
docs/player_factionchange_items.md | 12 +-
docs/player_factionchange_quests.md | 4 +-
docs/player_factionchange_reputations.md | 4 +-
docs/player_factionchange_spells.md | 4 +-
docs/player_factionchange_titles.md | 4 +-
docs/player_levelstats.md | 16 +-
docs/player_xp_for_level.md | 4 +-
docs/playercreateinfo.md | 16 +-
docs/playercreateinfo_action.md | 10 +-
docs/playercreateinfo_item.md | 10 +-
docs/playercreateinfo_skills.md | 10 +-
docs/playercreateinfo_spell.md | 8 +-
docs/playercreateinfo_spell_custom.md | 8 +-
docs/points_of_interest.md | 12 +-
docs/points_of_interest_locale.md | 6 +-
docs/pool_creature.md | 8 +-
docs/pool_gameobject.md | 8 +-
docs/pool_pool.md | 8 +-
docs/pool_quest.md | 6 +-
docs/pool_quest_save.md | 4 +-
docs/pool_template.md | 6 +-
docs/pvpstats_battlegrounds.md | 8 +-
docs/pvpstats_players.md | 26 +--
docs/quest_details.md | 20 +--
docs/quest_greeting.md | 10 +-
docs/quest_mail_sender.md | 4 +-
docs/quest_objectives.md | 20 +--
docs/quest_offer_reward.md | 20 +--
docs/quest_offer_reward_locale.md | 6 +-
docs/quest_poi.md | 16 +-
docs/quest_poi_points.md | 10 +-
docs/quest_request_items.md | 8 +-
docs/quest_request_items_locale.md | 6 +-
docs/quest_template.md | 112 ++++++------
docs/quest_template_addon.md | 34 ++--
docs/quest_template_locale.md | 6 +-
docs/realmcharacters.md | 6 +-
docs/realmlist.md | 24 +--
docs/reputation_reward_rate.md | 8 +-
docs/reputation_spillover_template.md | 26 +--
docs/reserved_name.md | 2 +-
docs/scene_template.md | 8 +-
docs/script_waypoint.md | 12 +-
docs/skill_discovery_template.md | 8 +-
docs/skill_extra_item_template.md | 8 +-
docs/skill_fishing_base_level.md | 4 +-
docs/smart_scripts.md | 58 +++----
docs/spawn_group.md | 6 +-
docs/spawn_group_template.md | 6 +-
docs/spell_area.md | 20 +--
docs/spell_bonus_data.md | 12 +-
docs/spell_dbc.md | 182 +++++++++----------
docs/spell_enchant_proc_data.md | 8 +-
docs/spell_group.md | 4 +-
docs/spell_group_stack_rules.md | 6 +-
docs/spell_learn_spell.md | 6 +-
docs/spell_linked_spell.md | 6 +-
docs/spell_mixology.md | 4 +-
docs/spell_pet_auras.md | 8 +-
docs/spell_proc.md | 30 ++--
docs/spell_proc_event.md | 22 +--
docs/spell_ranks.md | 6 +-
docs/spell_required.md | 4 +-
docs/spell_script_names.md | 4 +-
docs/spell_scripts.md | 22 +--
docs/spell_target_position.md | 12 +-
docs/spell_threat.md | 4 +-
docs/spelldifficulty_dbc.md | 10 +-
docs/uptime.md | 10 +-
docs/vehicle_accessory.md | 14 +-
docs/vehicle_template_accessory.md | 14 +-
docs/version.md | 10 +-
docs/version_db_auth.md | 4 +-
docs/version_db_characters.md | 4 +-
docs/version_db_world.md | 4 +-
docs/warden_action.md | 4 +-
docs/warden_checks.md | 16 +-
docs/waypoint_data.md | 22 +--
docs/waypoint_scripts.md | 22 +--
docs/waypoints.md | 10 +-
docs/worldstates.md | 6 +-
295 files changed, 2494 insertions(+), 2524 deletions(-)
delete mode 100644 docs/cheaters.md
delete mode 100644 docs/gm_surveys.md
diff --git a/docs/MySQLtypesC++.md b/docs/MySQLtypesC++.md
index 06f2e8f..1148dd2 100644
--- a/docs/MySQLtypesC++.md
+++ b/docs/MySQLtypesC++.md
@@ -16,92 +16,92 @@
| Variable operators |
- | bigint(20) |
+ BIGINT |
int64 |
int64 val = fields[n].GetInt64(); |
%I64d (Capital i) |
- | bigint(20) unsigned |
+ BIGINT UNSIGNED |
uint64 |
uint64 val = fields[n].GetUInt64();
|
%I64u (Capital i) |
- | int(11) |
+ INT |
int32 |
int32 val = fields[n].GetInt32();
|
%u |
- | int(10) unsigned |
+ INT UNSIGNED |
uint32 |
uint32 val = fields[n].GetUInt32();
|
%u |
- | mediumint(8) |
+ MEDIUMINT |
int32 |
int32 val = fields[n].GetInt32();
|
%u |
- | mediumint(8) unsigned |
+ MEDIUMINT UNSIGNED |
uint32 |
uint32 val = fields[n].GetUInt32();
|
%u |
- | smallint(6) |
+ SMALLINT |
int16 |
int16 val = fields[n].GetInt16();
|
|
- | smallint(5) unsigned |
+ SMALLINT UNSIGNED |
uint16 |
uint16 val = fields[n].GetUInt16();
|
|
- | tinyint(4) |
+ TINYINT |
int8 |
int16 val = fields[n].GetInt16();
|
|
- | tinyint(3) unsigned |
+ TINYINT UNSIGNED |
uint8 |
uint8 val = fields[n].GetUInt8();
|
|
- | float |
+ FLOAT |
float |
- float val = fields[n].GetFloat(); |
+ float val = fields[n].GetFLOAT(); |
|
- | float unsigned |
+ FLOAT UNSIGNED |
|
- | double |
+ DOUBLE |
double |
double val = fields[n].GetDouble(); |
|
- | double unsigned |
+ DOUBLE UNSIGNED |
|
@@ -130,7 +130,7 @@
| %s |
- | varchar(k) |
+ VARCHAR(k) |
%s |
@@ -165,7 +165,7 @@
cstring (char const*)
- int sum;
+ INT sum;
if (const char* ch = fields[n].GetCString())
sum = atoi(ch);
|
diff --git a/docs/access_requirement.md b/docs/access_requirement.md
index b8bdef1..a4d3acb 100644
--- a/docs/access_requirement.md
+++ b/docs/access_requirement.md
@@ -11,16 +11,16 @@ This table contains the access requirements to enter an instance.
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|-----------------------------|--------------|------------|-----|------|---------|-------|---------|
-| [mapId][1] | mediumint(8) | unsigned | PRI | NO | | | |
-| [difficulty][2] | tinyint(3) | unsigned | PRI | NO | 0 | | |
-| [level_min][3] | tinyint(3) | unsigned | | NO | 0 | | |
-| [level_max][4] | tinyint(3) | unsigned | | NO | 0 | | |
-| [item_level][5] | smallint(5) | unsigned | | NO | 0 | | |
-| [item][6] | mediumint(8) | unsigned | | NO | 0 | | |
-| [item2][7] | mediumint(8) | unsigned | | NO | 0 | | |
-| [quest_done_A][8] | mediumint(8) | unsigned | | NO | 0 | | |
-| [quest_done_H][9] | mediumint(8) | unsigned | | NO | 0 | | |
-| [completed_achievement][10] | mediumint(8) | unsigned | | NO | 0 | | |
+| [mapId][1] | MEDIUMINT | UNSIGNED | PRI | NO | | | |
+| [difficulty][2] | TINYINT | UNSIGNED | PRI | NO | 0 | | |
+| [level_min][3] | TINYINT | UNSIGNED | | NO | 0 | | |
+| [level_max][4] | TINYINT | UNSIGNED | | NO | 0 | | |
+| [item_level][5] | SMALLINT | UNSIGNED | | NO | 0 | | |
+| [item][6] | MEDIUMINT | UNSIGNED | | NO | 0 | | |
+| [item2][7] | MEDIUMINT | UNSIGNED | | NO | 0 | | |
+| [quest_done_A][8] | MEDIUMINT | UNSIGNED | | NO | 0 | | |
+| [quest_done_H][9] | MEDIUMINT | UNSIGNED | | NO | 0 | | |
+| [completed_achievement][10] | MEDIUMINT | UNSIGNED | | NO | 0 | | |
| [quest_failed_text][11] | text | | | YES | | | |
| [comment][12] | text | | | YES | | | |
diff --git a/docs/account.md b/docs/account.md
index 48eecb5..81fa38e 100644
--- a/docs/account.md
+++ b/docs/account.md
@@ -4,8 +4,6 @@
**The \`account\` table**
-This table holds information on all available accounts.
-
**Structure**
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
@@ -22,7 +20,7 @@ This table holds information on all available accounts.
| [last_ip][10] | VARCHAR(15) | | | NO | 127.0.0.1 | | |
| [last_attempt_ip][11] | VARCHAR(15) | | | NO | 127.0.0.1 | | |
| [failed_logins][12] | INT | UNSIGNED | | NO | 0 | | |
-| [locked][13] | tinyint(3) | UNSIGNED | | NO | 0 | | |
+| [locked][13] | TINYINT | UNSIGNED | | NO | 0 | | |
| [lock_country][14] | VARCHAR(2) | | | NO | 0 | | |
| [last_login][15] | TIMESTAMP | | | YES | NULL | | |
| [online][16] | INT | UNSIGNED | | NO | 0 | | |
diff --git a/docs/account_access.md b/docs/account_access.md
index 9bfab7e..3d5a8c5 100644
--- a/docs/account_access.md
+++ b/docs/account_access.md
@@ -10,10 +10,10 @@ This table holds security access level for any realm in [realmlist](realmlist) t
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|--------------|--------------|------------|-----|------|---------|-------|---------|
-| [id][1] | int(10) | unsigned | PRI | NO | | | |
-| [gmlevel][2] | tinyint(3) | unsigned | | NO | | | |
-| [RealmID][3] | int(11) | signed | PRI | NO | -1 | | |
-| [comment][4] | varchar(255) | | | YES | | | |
+| [id][1] | INT | UNSIGNED | PRI | NO | | | |
+| [gmlevel][2] | TINYINT | UNSIGNED | | NO | | | |
+| [RealmID][3] | INT | SIGNED | PRI | NO | -1 | | |
+| [comment][4] | VARCHAR(255) | | | YES | | | |
[1]: #id
[2]: #gmlevel
diff --git a/docs/account_banned.md b/docs/account_banned.md
index 7a0e1c4..112cfc5 100644
--- a/docs/account_banned.md
+++ b/docs/account_banned.md
@@ -10,12 +10,12 @@ This table lists all of the accounts that have been banned along with the date w
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|----------------|--------------|------------|-----|------|---------|-------|------------|
-| [id][1] | int(10) | unsigned | PRI | NO | 0 | | Account id |
-| [bandate][2] | int(10) | unsigned | PRI | NO | 0 | | |
-| [unbandate][3] | int(10) | unsigned | | NO | 0 | | |
-| [bannedby][4] | varchar(50) | | | NO | | | |
-| [banreason][5] | varchar(255) | | | NO | | | |
-| [active][6] | tinyint(3) | unsigned | | NO | 1 | | |
+| [id][1] | INT | UNSIGNED | PRI | NO | 0 | | Account id |
+| [bandate][2] | INT | UNSIGNED | PRI | NO | 0 | | |
+| [unbandate][3] | INT | UNSIGNED | | NO | 0 | | |
+| [bannedby][4] | VARCHAR(50) | | | NO | | | |
+| [banreason][5] | VARCHAR(255) | | | NO | | | |
+| [active][6] | TINYINT | UNSIGNED | | NO | 1 | | |
[1]: #id
[2]: #bandate
diff --git a/docs/account_data.md b/docs/account_data.md
index 1484152..702db9b 100644
--- a/docs/account_data.md
+++ b/docs/account_data.md
@@ -10,10 +10,10 @@ Contains data about client account and settings.
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|--------------|------------|------------|-----|------|---------|-------|---------|
-| [account][1] | int(10) | unsigned | PRI | NO | 0 | | |
-| [type][2] | tinyint(3) | unsigned | PRI | NO | 0 | | |
-| [time][3] | int(10) | unsigned | | NO | 0 | | |
-| [data][4] | blob | signed | | NO | | | |
+| [account][1] | INT | UNSIGNED | PRI | NO | 0 | | |
+| [type][2] | TINYINT | UNSIGNED | PRI | NO | 0 | | |
+| [time][3] | INT | UNSIGNED | | NO | 0 | | |
+| [data][4] | BLOB | SIGNED | | NO | | | |
[1]: #account
[2]: #type
diff --git a/docs/account_instance_times.md b/docs/account_instance_times.md
index a6760cf..9bc15bf 100644
--- a/docs/account_instance_times.md
+++ b/docs/account_instance_times.md
@@ -10,9 +10,9 @@ This table controls how many instances the account's characters have been in las
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|------------------|------------|------------|-----|------|---------|-------|---------|
-| [accountId][1] | int(10) | unsigned | PRI | NO | | | |
-| [instanceId][2] | int(10) | unsigned | PRI | NO | 0 | | |
-| [releaseTime][3] | bigint(20) | unsigned | | NO | 0 | | |
+| [accountId][1] | INT | UNSIGNED | PRI | NO | | | |
+| [instanceId][2] | INT | UNSIGNED | PRI | NO | 0 | | |
+| [releaseTime][3] | BIGINT | UNSIGNED | | NO | 0 | | |
[1]: #accountid
[2]: #instanceid
diff --git a/docs/account_muted.md b/docs/account_muted.md
index 8f39e5d..8d582d3 100644
--- a/docs/account_muted.md
+++ b/docs/account_muted.md
@@ -14,11 +14,11 @@ Disable chat messaging for any character from account of character $playerName (
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|-----------------|--------------|------------|-----|------|---------|-------|--------------------------|
-| [guid][1] | int(10) | unsigned | PRI | NO | 0 | | Global Unique Identifier |
-| [mutedate][2] | int(10) | unsigned | PRI | NO | 0 | | |
-| [mutetime][3] | int(10) | unsigned | | NO | 0 | | |
-| [mutedby][4] | varchar(50) | | | NO | | | |
-| [mutereason][5] | varchar(255) | | | NO | | | |
+| [guid][1] | INT | UNSIGNED | PRI | NO | 0 | | Global Unique Identifier |
+| [mutedate][2] | INT | UNSIGNED | PRI | NO | 0 | | |
+| [mutetime][3] | INT | UNSIGNED | | NO | 0 | | |
+| [mutedby][4] | VARCHAR(50) | | | NO | | | |
+| [mutereason][5] | VARCHAR(255) | | | NO | | | |
[1]: #guid
[2]: #mutedate
diff --git a/docs/account_tutorial.md b/docs/account_tutorial.md
index 5b0f874..e834e88 100644
--- a/docs/account_tutorial.md
+++ b/docs/account_tutorial.md
@@ -10,15 +10,15 @@ This table is used to store the tutorial state of all the accounts.
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|----------------|---------|------------|-----|------|---------|--------|--------------------|
-| [accountId][1] | int(10) | unsigned | PRI | NO | 0 | Unique | Account Identifier |
-| [tut0][2] | int(10) | unsigned | | NO | 0 | | |
-| [tut1][3] | int(10) | unsigned | | NO | 0 | | |
-| [tut2][4] | int(10) | unsigned | | NO | 0 | | |
-| [tut3][5] | int(10) | unsigned | | NO | 0 | | |
-| [tut4][6] | int(10) | unsigned | | NO | 0 | | |
-| [tut5][7] | int(10) | unsigned | | NO | 0 | | |
-| [tut6][8] | int(10) | unsigned | | NO | 0 | | |
-| [tut7][9] | int(10) | unsigned | | NO | 0 | | |
+| [accountId][1] | INT | UNSIGNED | PRI | NO | 0 | Unique | Account Identifier |
+| [tut0][2] | INT | UNSIGNED | | NO | 0 | | |
+| [tut1][3] | INT | UNSIGNED | | NO | 0 | | |
+| [tut2][4] | INT | UNSIGNED | | NO | 0 | | |
+| [tut3][5] | INT | UNSIGNED | | NO | 0 | | |
+| [tut4][6] | INT | UNSIGNED | | NO | 0 | | |
+| [tut5][7] | INT | UNSIGNED | | NO | 0 | | |
+| [tut6][8] | INT | UNSIGNED | | NO | 0 | | |
+| [tut7][9] | INT | UNSIGNED | | NO | 0 | | |
[1]: #accountid
[2]: #tut0
diff --git a/docs/achievement_criteria_data.md b/docs/achievement_criteria_data.md
index c4fe76b..ea7202f 100644
--- a/docs/achievement_criteria_data.md
+++ b/docs/achievement_criteria_data.md
@@ -10,10 +10,10 @@ This table contains the data that a player needs to obtain / complete in order t
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|------------------|--------------|------------|-----|------|---------|-------|---------|
-| [criteria_id][1] | mediumint(8) | | PRI | NO | | | |
-| [type][2] | tinyint(3) | unsigned | PRI | NO | 0 | | |
-| [value1][3] | mediumint(8) | unsigned | | NO | 0 | | |
-| [value2][4] | mediumint(8) | unsigned | | NO | 0 | | |
+| [criteria_id][1] | MEDIUMINT | | PRI | NO | | | |
+| [type][2] | TINYINT | UNSIGNED | PRI | NO | 0 | | |
+| [value1][3] | MEDIUMINT | UNSIGNED | | NO | 0 | | |
+| [value2][4] | MEDIUMINT | UNSIGNED | | NO | 0 | | |
| [ScriptName][5] | char(64) | | | NO | | | |
[1]: #criteria_id
diff --git a/docs/achievement_dbc.md b/docs/achievement_dbc.md
index cbd9483..06418eb 100644
--- a/docs/achievement_dbc.md
+++ b/docs/achievement_dbc.md
@@ -10,13 +10,13 @@ Stores achievement data that is missing in [Achievement.dbc](Achievement)
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|----------------------|---------|------------|-----|------|---------|-------|----------------------------------------------------------------------------------|
-| [ID][1] | int(10) | unsigned | PRI | NO | | | |
-| [requiredFaction][2] | int(11) | signed | | NO | -1 | | |
-| [mapID][3] | int(11) | signed | | NO | -1 | | |
-| [points][4] | int(10) | unsigned | | NO | 0 | | Achievement points awarded for completing the achievement, has no use serverside |
-| [flags][5] | int(10) | unsigned | | NO | 0 | | |
-| [count][6] | int(10) | unsigned | | NO | 0 | | |
-| [refAchievement][7] | int(10) | unsigned | | NO | 0 | | |
+| [ID][1] | INT | UNSIGNED | PRI | NO | | | |
+| [requiredFaction][2] | INT | SIGNED | | NO | -1 | | |
+| [mapID][3] | INT | SIGNED | | NO | -1 | | |
+| [points][4] | INT | UNSIGNED | | NO | 0 | | Achievement points awarded for completing the achievement, has no use serverside |
+| [flags][5] | INT | UNSIGNED | | NO | 0 | | |
+| [count][6] | INT | UNSIGNED | | NO | 0 | | |
+| [refAchievement][7] | INT | UNSIGNED | | NO | 0 | | |
[1]: #id
[2]: #requiredfaction
diff --git a/docs/achievement_reward.md b/docs/achievement_reward.md
index 694c16d..4bc0949 100644
--- a/docs/achievement_reward.md
+++ b/docs/achievement_reward.md
@@ -10,14 +10,14 @@ This table describes the reward that you will receive when you obtain a given ac
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---------------------|--------------|------------|-----|------|---------|-------|---------|
-| [ID][1] | mediumint(8) | unsigned | PRI | NO | 0 | | |
-| [TitleA][2] | mediumint(8) | unsigned | | NO | 0 | | |
-| [TitleH][3] | mediumint(8) | unsigned | | NO | 0 | | |
-| [ItemID][4] | mediumint(8) | unsigned | | NO | 0 | | |
-| [Sender][5] | mediumint(8) | unsigned | | NO | 0 | | |
-| [Subject][6] | varchar(255) | | | YES | | | |
+| [ID][1] | MEDIUMINT | UNSIGNED | PRI | NO | 0 | | |
+| [TitleA][2] | MEDIUMINT | UNSIGNED | | NO | 0 | | |
+| [TitleH][3] | MEDIUMINT | UNSIGNED | | NO | 0 | | |
+| [ItemID][4] | MEDIUMINT | UNSIGNED | | NO | 0 | | |
+| [Sender][5] | MEDIUMINT | UNSIGNED | | NO | 0 | | |
+| [Subject][6] | VARCHAR(255) | | | YES | | | |
| [Body][7] | text | | | YES | | | |
-| [MailTemplateID][8] | mediumint(8) | unsigned | | YES | 0 | | |
+| [MailTemplateID][8] | MEDIUMINT | UNSIGNED | | YES | 0 | | |
[1]: #id
[2]: #titlea
diff --git a/docs/achievement_reward_locale.md b/docs/achievement_reward_locale.md
index 6610241..79a6d67 100644
--- a/docs/achievement_reward_locale.md
+++ b/docs/achievement_reward_locale.md
@@ -10,8 +10,8 @@ It is the table that stores the translations of the table `achievement_reward`,
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|--------------|--------------|------------|-----|------|---------|-------|---------|
-| [ID][1] | mediumint(8) | unsigned | PRI | NO | 0 | | |
-| [Locale][2] | varchar(4) | | PRI | NO | | | |
+| [ID][1] | MEDIUMINT | UNSIGNED | PRI | NO | 0 | | |
+| [Locale][2] | VARCHAR(4) | | PRI | NO | | | |
| [Subject][3] | text | | | YES | | | |
| [Text][4] | text | | | YES | | | |
diff --git a/docs/acore_string.md b/docs/acore_string.md
index 3f6fb6a..6139e89 100644
--- a/docs/acore_string.md
+++ b/docs/acore_string.md
@@ -14,7 +14,7 @@ NOTE: The % arguments need to stay in the exact same order as they are provided
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|----------------------|--------------|------------|-----|------|---------|-------|---------|
-| [entry][1] | mediumint(8) | unsigned | PRI | NO | 0 | | |
+| [entry][1] | MEDIUMINT | UNSIGNED | PRI | NO | 0 | | |
| [content_default][2] | text | | | NO | | | |
| [locale_koKR][3] | text | | | YES | | | |
| [locale_frFR][3] | text | | | YES | | | |
diff --git a/docs/addons.md b/docs/addons.md
index 9963253..ee3986f 100644
--- a/docs/addons.md
+++ b/docs/addons.md
@@ -2,5 +2,5 @@
Column | Type | Description
--- | --- | ---
-Name | varchar(120) |
-Crc | int(10) unsigned |
+Name | VARCHAR(120) |
+Crc | INT UNSIGNED |
diff --git a/docs/areatrigger.md b/docs/areatrigger.md
index 1e96cf4..faede76 100644
--- a/docs/areatrigger.md
+++ b/docs/areatrigger.md
@@ -10,16 +10,16 @@ This table contains trigger points for events in certain coordinates in the maps
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|-------------|---------|------------|-----|------|---------|----------------|------------------------------------------------------|
-| entry | int(10) | unsigned | PRI | NO | | auto_increment | |
-| map | int(10) | unsigned | | NO | 0 | | |
-| x | float | | | NO | 0 | | |
-| y | float | | | NO | 0 | | |
-| z | float | | | NO | 0 | | |
-| radius | float | | | NO | 0 | | Seems to be a box of size yards with center at x,y,z |
-| length | float | | | NO | 0 | | Most commonly used when size is 0, but not always |
-| width | float | | | NO | 0 | | Most commonly used when size is 0, but not always |
-| height | float | | | NO | 0 | | Most commonly used when size is 0, but not always |
-| orientation | float | | | NO | 0 | | Most commonly used when size is 0, but not always |
+| entry | INT | UNSIGNED | PRI | NO | | AUTO_INCREMENT | |
+| map | INT | UNSIGNED | | NO | 0 | | |
+| x | FLOAT | | | NO | 0 | | |
+| y | FLOAT | | | NO | 0 | | |
+| z | FLOAT | | | NO | 0 | | |
+| radius | FLOAT | | | NO | 0 | | Seems to be a box of size yards with center at x,y,z |
+| length | FLOAT | | | NO | 0 | | Most commonly used when size is 0, but not always |
+| width | FLOAT | | | NO | 0 | | Most commonly used when size is 0, but not always |
+| height | FLOAT | | | NO | 0 | | Most commonly used when size is 0, but not always |
+| orientation | FLOAT | | | NO | 0 | | Most commonly used when size is 0, but not always |
**Description of the fields**
diff --git a/docs/areatrigger_involvedrelation.md b/docs/areatrigger_involvedrelation.md
index c6ffab5..abe873c 100644
--- a/docs/areatrigger_involvedrelation.md
+++ b/docs/areatrigger_involvedrelation.md
@@ -12,8 +12,8 @@ If there is a record in the table for a quest, then the quest will not be comple
| Field | Type | Attributes | Key | Null | Default | Extra | Comments |
|------------|--------------|------------|-----|------|---------|-------|------------------|
-| [id][1] | mediumint(8) | unsigned | PRI | NO | 0 | | Identifier |
-| [quest][2] | mediumint(8) | unsigned | | NO | 0 | | Quest Identifier |
+| [id][1] | MEDIUMINT | UNSIGNED | PRI | NO | 0 | | Identifier |
+| [quest][2] | MEDIUMINT | UNSIGNED | | NO | 0 | | Quest Identifier |
[1]: #id
[2]: #quest
diff --git a/docs/areatrigger_scripts.md b/docs/areatrigger_scripts.md
index 636f0b4..2c889ae 100644
--- a/docs/areatrigger_scripts.md
+++ b/docs/areatrigger_scripts.md
@@ -10,7 +10,7 @@ Allows for an area trigger to be scripted with Trinity Script.
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|-----------------|--------------|------------|-----|------|---------|-------|---------|
-| [entry][1] | mediumint(8) | | PRI | NO | | | |
+| [entry][1] | MEDIUMINT | | PRI | NO | | | |
| [ScriptName][2] | char(64) | | | NO | | | |
[1]: #entry
diff --git a/docs/areatrigger_tavern.md b/docs/areatrigger_tavern.md
index 4423aa9..41011eb 100644
--- a/docs/areatrigger_tavern.md
+++ b/docs/areatrigger_tavern.md
@@ -10,7 +10,7 @@ Enable a trigger when player enters a city or tavern. This causes the player to
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|-----------|--------------|------------|-----|------|---------|-------|------------|
-| [id][1] | mediumint(8) | unsigned | PRI | NO | 0 | | Identifier |
+| [id][1] | MEDIUMINT | UNSIGNED | PRI | NO | 0 | | Identifier |
| [name][2] | text | | | YES | | | |
[1]: #id
diff --git a/docs/areatrigger_teleport.md b/docs/areatrigger_teleport.md
index 2fbb576..4bd7b52 100644
--- a/docs/areatrigger_teleport.md
+++ b/docs/areatrigger_teleport.md
@@ -10,13 +10,13 @@ Contains all the teleport triggers definition. This table is used to complete .d
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|-------------------------|--------------|------------|-----|------|---------|-------|---------|
-| [ID][1] | mediumint(8) | unsigned | PRI | NO | 0 | | |
+| [ID][1] | MEDIUMINT | UNSIGNED | PRI | NO | 0 | | |
| [Name][2] | text | | MUL | YES | | | |
-| [target_map][3] | smallint(5) | unsigned | | NO | 0 | | |
-| [target_position_x][4] | float | | | NO | 0 | | |
-| [target_position_y][5] | float | | | NO | 0 | | |
-| [target_position_z][6] | float | | | NO | 0 | | |
-| [target_orientation][7] | float | | | NO | 0 | | |
+| [target_map][3] | SMALLINT | UNSIGNED | | NO | 0 | | |
+| [target_position_x][4] | FLOAT | | | NO | 0 | | |
+| [target_position_y][5] | FLOAT | | | NO | 0 | | |
+| [target_position_z][6] | FLOAT | | | NO | 0 | | |
+| [target_orientation][7] | FLOAT | | | NO | 0 | | |
[1]: #id
[2]: #name
diff --git a/docs/arena_team.md b/docs/arena_team.md
index 32eda0f..89d1e03 100644
--- a/docs/arena_team.md
+++ b/docs/arena_team.md
@@ -10,21 +10,21 @@ This table holds the main ArenaTeam information. All created teams or all teams
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|-----------------------|-------------|------------|-----|------|---------|--------|---------|
-| [arenaTeamId][1] | int(10) | unsigned | PRI | NO | | Unique | |
-| [name][2] | varchar(24) | | | NO | | | |
-| [captainGuid][3] | int(10) | unsigned | | NO | | | |
-| [type][4] | tinyint(3) | unsigned | | NO | | | |
-| [rating][5] | smallint(5) | unsigned | | NO | | | |
-| [seasonGames][6] | smallint(5) | unsigned | | NO | | | |
-| [seasonWins][7] | smallint(5) | unsigned | | NO | | | |
-| [weekGames][8] | smallint(5) | unsigned | | NO | | | |
-| [weekWins][9] | smallint(5) | unsigned | | NO | | | |
-| [rank][10] | int(10) | unsigned | | NO | | | |
-| [BackgroundColor][11] | int(10) | unsigned | | NO | | | |
-| [EmblemStyle][12] | tinyint(3) | unsigned | | NO | | | |
-| [EmblemColor][13] | int(10) | unsigned | | NO | | | |
-| [BorderStyle][14] | tinyint(3) | unsigned | | NO | | | |
-| [BorderColor][15] | int(10) | unsigned | | NO | | | |
+| [arenaTeamId][1] | INT | UNSIGNED | PRI | NO | | Unique | |
+| [name][2] | VARCHAR(24) | | | NO | | | |
+| [captainGuid][3] | INT | UNSIGNED | | NO | | | |
+| [type][4] | TINYINT | UNSIGNED | | NO | | | |
+| [rating][5] | SMALLINT | UNSIGNED | | NO | | | |
+| [seasonGames][6] | SMALLINT | UNSIGNED | | NO | | | |
+| [seasonWins][7] | SMALLINT | UNSIGNED | | NO | | | |
+| [weekGames][8] | SMALLINT | UNSIGNED | | NO | | | |
+| [weekWins][9] | SMALLINT | UNSIGNED | | NO | | | |
+| [rank][10] | INT | UNSIGNED | | NO | | | |
+| [BackgroundColor][11] | INT | UNSIGNED | | NO | | | |
+| [EmblemStyle][12] | TINYINT | UNSIGNED | | NO | | | |
+| [EmblemColor][13] | INT | UNSIGNED | | NO | | | |
+| [BorderStyle][14] | TINYINT | UNSIGNED | | NO | | | |
+| [BorderColor][15] | INT | UNSIGNED | | NO | | | |
[1]: #arenateamid
[2]: #name
diff --git a/docs/arena_team_member.md b/docs/arena_team_member.md
index da9e789..5450f9f 100644
--- a/docs/arena_team_member.md
+++ b/docs/arena_team_member.md
@@ -10,13 +10,13 @@ This table holds arena info about specific team members. All arena\_team members
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---------------------|-------------|------------|-----|------|---------|-------|---------|
-| [arenaTeamId][1] | int(10) | unsigned | PRI | NO | 0 | | |
-| [guid][2] | int(10) | unsigned | PRI | NO | 0 | | |
-| [personalRating][3] | smallint(5) | unsigned | | NO | 0 | | |
-| [weekGames][4] | smallint(5) | unsigned | | NO | 0 | | |
-| [weekWins][5] | smallint(5) | unsigned | | NO | 0 | | |
-| [seasonGames][6] | smallint(5) | unsigned | | NO | 0 | | |
-| [seasonWins][7] | smallint(5) | unsigned | | NO | 0 | | |
+| [arenaTeamId][1] | INT | UNSIGNED | PRI | NO | 0 | | |
+| [guid][2] | INT | UNSIGNED | PRI | NO | 0 | | |
+| [personalRating][3] | SMALLINT | UNSIGNED | | NO | 0 | | |
+| [weekGames][4] | SMALLINT | UNSIGNED | | NO | 0 | | |
+| [weekWins][5] | SMALLINT | UNSIGNED | | NO | 0 | | |
+| [seasonGames][6] | SMALLINT | UNSIGNED | | NO | 0 | | |
+| [seasonWins][7] | SMALLINT | UNSIGNED | | NO | 0 | | |
[1]: #arenateamid
[2]: #guid
diff --git a/docs/auctionhouse.md b/docs/auctionhouse.md
index bf4603d..166d811 100644
--- a/docs/auctionhouse.md
+++ b/docs/auctionhouse.md
@@ -12,16 +12,16 @@ This table is used by Trinity while running and not a table that you would usual
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---------------------|---------|------------|-----|------|---------|-------|---------|
-| [id][1] | int(10) | unsigned | PRI | NO | 0 | | |
-| [auctioneerguid][2] | int(10) | unsigned | | NO | 0 | | |
-| [itemguid][3] | int(10) | unsigned | UNI | NO | 0 | | |
-| [itemowner][4] | int(10) | unsigned | | NO | 0 | | |
-| [buyoutprice][5] | int(10) | unsigned | | NO | 0 | | |
-| [time][6] | int(10) | unsigned | | NO | 0 | | |
-| [buyguid][7] | int(10) | unsigned | | NO | 0 | | |
-| [lastbid][8] | int(10) | unsigned | | NO | 0 | | |
-| [startbid][9] | int(10) | unsigned | | NO | 0 | | |
-| [deposit][10] | int(10) | unsigned | | NO | 0 | | |
+| [id][1] | INT | UNSIGNED | PRI | NO | 0 | | |
+| [auctioneerguid][2] | INT | UNSIGNED | | NO | 0 | | |
+| [itemguid][3] | INT | UNSIGNED | UNI | NO | 0 | | |
+| [itemowner][4] | INT | UNSIGNED | | NO | 0 | | |
+| [buyoutprice][5] | INT | UNSIGNED | | NO | 0 | | |
+| [time][6] | INT | UNSIGNED | | NO | 0 | | |
+| [buyguid][7] | INT | UNSIGNED | | NO | 0 | | |
+| [lastbid][8] | INT | UNSIGNED | | NO | 0 | | |
+| [startbid][9] | INT | UNSIGNED | | NO | 0 | | |
+| [deposit][10] | INT | UNSIGNED | | NO | 0 | | |
[1]: #id
[2]: #auctioneerguid
diff --git a/docs/autobroadcast.md b/docs/autobroadcast.md
index f6b0d56..3ec6e34 100644
--- a/docs/autobroadcast.md
+++ b/docs/autobroadcast.md
@@ -10,9 +10,9 @@ This table contains the autobroadcast entries for your realms. Values like it's
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|--------------|------------|------------|-----|------|---------|----------------|---------|
-| [realmid][1] | int(11) | signed | PRI | NO | -1 | | |
-| [id][2] | tinyint(3) | unsigned | PRI | NO | | auto_increment | |
-| [weight][3] | tinyint(3) | unsigned | | YES | 1 | | |
+| [realmid][1] | INT | SIGNED | PRI | NO | -1 | | |
+| [id][2] | TINYINT | UNSIGNED | PRI | NO | | AUTO_INCREMENT | |
+| [weight][3] | TINYINT | UNSIGNED | | YES | 1 | | |
| [text][4] | longtext | | | NO | | | |
[1]: #realmid
diff --git a/docs/banned_addons.md b/docs/banned_addons.md
index 56efffa..fffb2f4 100644
--- a/docs/banned_addons.md
+++ b/docs/banned_addons.md
@@ -2,7 +2,7 @@
Column | Type | Description
--- | --- | ---
-Id | int(10) unsigned |
-Name | varchar(255) |
-Version | varchar(255) |
-Timestamp | timestamp |
+Id | INT UNSIGNED |
+Name | VARCHAR(255) |
+Version | VARCHAR(255) |
+TIMESTAMP | TIMESTAMP |
diff --git a/docs/battleground_deserters.md b/docs/battleground_deserters.md
index 4861124..ea2e2b5 100644
--- a/docs/battleground_deserters.md
+++ b/docs/battleground_deserters.md
@@ -10,8 +10,8 @@ This table holds datas about BattleGrounds deserters. To enable storing this kin
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---------------|----------|------------|-----|------|---------|-------|---------|
-| [guid][1] | int | unsigned | | | | | |
-| [type][2] | tinyint | unsigned | | | | | |
+| [guid][1] | INT | UNSIGNED | | | | | |
+| [type][2] | TINYINT | UNSIGNED | | | | | |
| [datetime][3] | datetime | | | | | | |
[1]: #guid
diff --git a/docs/battleground_template.md b/docs/battleground_template.md
index d75d670..5d7a5d7 100644
--- a/docs/battleground_template.md
+++ b/docs/battleground_template.md
@@ -10,17 +10,17 @@ Contains information about the different battlegrounds, like how many players ar
| Field | Type | Atributes | Key | Null | Default | Extra | Comment |
|------------------------|--------------|-----------|-----|------|---------|-------|---------|
-| [ID][1] | mediumint(8) | unsigned | PRI | NO | 0 | | |
-| [MinPlayersPerTeam][2] | smallint(5) | unsigned | | NO | 0 | | |
-| [MaxPlayersPerTeam][3] | smallint(5) | unsigned | | NO | 0 | | |
-| [MinLvl][4] | tinyint(3) | unsigned | | NO | 0 | | |
-| [MaxLvl][5] | tinyint(3) | unsigned | | NO | 0 | | |
-| [AllianceStartLoc][6] | mediumint(8) | unsigned | | NO | | | |
-| [AllianceStartO][7] | float | signed | | NO | | | |
-| [HordeStartLoc][8] | mediumint(8) | unsigned | | NO | | | |
-| [HordeStartO][9] | float | signed | | NO | | | |
-| [StartMaxDist][10] | float | signed | | NO | 0 | | |
-| [Weight][11] | tinyint(3) | unsigned | | NO | 1 | | |
+| [ID][1] | MEDIUMINT | UNSIGNED | PRI | NO | 0 | | |
+| [MinPlayersPerTeam][2] | SMALLINT | UNSIGNED | | NO | 0 | | |
+| [MaxPlayersPerTeam][3] | SMALLINT | UNSIGNED | | NO | 0 | | |
+| [MinLvl][4] | TINYINT | UNSIGNED | | NO | 0 | | |
+| [MaxLvl][5] | TINYINT | UNSIGNED | | NO | 0 | | |
+| [AllianceStartLoc][6] | MEDIUMINT | UNSIGNED | | NO | | | |
+| [AllianceStartO][7] | FLOAT | SIGNED | | NO | | | |
+| [HordeStartLoc][8] | MEDIUMINT | UNSIGNED | | NO | | | |
+| [HordeStartO][9] | FLOAT | SIGNED | | NO | | | |
+| [StartMaxDist][10] | FLOAT | SIGNED | | NO | 0 | | |
+| [Weight][11] | TINYINT | UNSIGNED | | NO | 1 | | |
| [ScriptName][12] | char(64) | | | NO | | | |
| [Comment][13] | char(38) | | | NO | | | |
diff --git a/docs/battlemaster_entry.md b/docs/battlemaster_entry.md
index 73c94a7..4050829 100644
--- a/docs/battlemaster_entry.md
+++ b/docs/battlemaster_entry.md
@@ -10,8 +10,8 @@ Holds information on which NPC can start what battleground or arena.
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|------------------|--------------|------------|-----|------|---------|-------|-------------------------|
-| [entry][1] | mediumint(8) | unsigned | PRI | NO | 0 | | Entry of a creature |
-| [bg_template][2] | mediumint(8) | unsigned | | NO | 0 | | Batleground template id |
+| [entry][1] | MEDIUMINT | UNSIGNED | PRI | NO | 0 | | Entry of a creature |
+| [bg_template][2] | MEDIUMINT | UNSIGNED | | NO | 0 | | Batleground template id |
[1]: #entry
[2]: #bg_template
diff --git a/docs/broadcast_text.md b/docs/broadcast_text.md
index eb358c4..ef7c32f 100644