vmt.tail7e5fd1.ts.net / 127.0.0.1 / rathena_db

There are no favorite tables.

Customize appearance of the navigation panel.

Navigation panel

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Customize the navigation tree.

Navigation tree

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Servers display options.

Servers

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Databases display options.

Databases

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables display options.

Tables

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken :

No bookmarks

Label: Target database: Share this bookmark

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme

Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :

Untitled *

v		rathena_db acc_reg_num
account_id : int(11) unsigned
key : varchar(32)
index : int(11) unsigned
value : bigint(11)

v		rathena_db acc_reg_str
account_id : int(11) unsigned
key : varchar(32)
index : int(11) unsigned
value : varchar(254)

v		rathena_db achievement
char_id : int(11) unsigned
id : bigint(11) unsigned
count1 : int(10) unsigned
count2 : int(10) unsigned
count3 : int(10) unsigned
count4 : int(10) unsigned
count5 : int(10) unsigned
count6 : int(10) unsigned
count7 : int(10) unsigned
count8 : int(10) unsigned
count9 : int(10) unsigned
count10 : int(10) unsigned
completed : datetime
rewarded : datetime

v		rathena_db auction
auction_id : bigint(20) unsigned
seller_id : int(11) unsigned
seller_name : varchar(30)
buyer_id : int(11) unsigned
buyer_name : varchar(30)
price : int(11) unsigned
buynow : int(11) unsigned
hours : smallint(6)
timestamp : int(11) unsigned
nameid : int(10) unsigned
item_name : varchar(50)
type : smallint(6)
refine : tinyint(3) unsigned
attribute : tinyint(4) unsigned
card0 : int(10) unsigned
card1 : int(10) unsigned
card2 : int(10) unsigned
card3 : int(10) unsigned
option_id0 : smallint(5)
option_val0 : smallint(5)
option_parm0 : tinyint(3)
option_id1 : smallint(5)
option_val1 : smallint(5)
option_parm1 : tinyint(3)
option_id2 : smallint(5)
option_val2 : smallint(5)
option_parm2 : tinyint(3)
option_id3 : smallint(5)
option_val3 : smallint(5)
option_parm3 : tinyint(3)
option_id4 : smallint(5)
option_val4 : smallint(5)
option_parm4 : tinyint(3)
unique_id : bigint(20) unsigned
enchantgrade : tinyint(3) unsigned

v		rathena_db barter
name : varchar(50)
index : smallint(5) unsigned
amount : smallint(5) unsigned

v		rathena_db bonus_script
char_id : int(11) unsigned
script : text
tick : bigint(20)
flag : smallint(5) unsigned
type : tinyint(1) unsigned
icon : smallint(3)

v		rathena_db buyingstores
id : int(10) unsigned
account_id : int(11) unsigned
char_id : int(10) unsigned
sex : enum('F','M')
map : varchar(20)
x : smallint(5) unsigned
y : smallint(5) unsigned
title : varchar(80)
limit : int(10) unsigned
body_direction : char(1)
head_direction : char(1)
sit : char(1)
autotrade : tinyint(4)

v		rathena_db buyingstore_items
buyingstore_id : int(10) unsigned
index : smallint(5) unsigned
item_id : int(10) unsigned
amount : smallint(5) unsigned
price : int(10) unsigned

v		rathena_db cart_inventory
id : int(11)
char_id : int(11) unsigned
nameid : int(10) unsigned
amount : int(11)
equip : int(11) unsigned
identify : smallint(6)
refine : tinyint(3) unsigned
attribute : tinyint(4)
card0 : int(10) unsigned
card1 : int(10) unsigned
card2 : int(10) unsigned
card3 : int(10) unsigned
option_id0 : smallint(5)
option_val0 : smallint(5)
option_parm0 : tinyint(3)
option_id1 : smallint(5)
option_val1 : smallint(5)
option_parm1 : tinyint(3)
option_id2 : smallint(5)
option_val2 : smallint(5)
option_parm2 : tinyint(3)
option_id3 : smallint(5)
option_val3 : smallint(5)
option_parm3 : tinyint(3)
option_id4 : smallint(5)
option_val4 : smallint(5)
option_parm4 : tinyint(3)
expire_time : int(11) unsigned
bound : tinyint(3) unsigned
unique_id : bigint(20) unsigned
enchantgrade : tinyint(3) unsigned

v		rathena_db char
char_id : int(11) unsigned
account_id : int(11) unsigned
char_num : tinyint(1)
name : varchar(30)
class : smallint(6) unsigned
base_level : smallint(6) unsigned
job_level : smallint(6) unsigned
base_exp : bigint(20) unsigned
job_exp : bigint(20) unsigned
zeny : int(11) unsigned
str : smallint(4) unsigned
agi : smallint(4) unsigned
vit : smallint(4) unsigned
int : smallint(4) unsigned
dex : smallint(4) unsigned
luk : smallint(4) unsigned
pow : smallint(4) unsigned
sta : smallint(4) unsigned
wis : smallint(4) unsigned
spl : smallint(4) unsigned
con : smallint(4) unsigned
crt : smallint(4) unsigned
max_hp : int(11) unsigned
hp : int(11) unsigned
max_sp : int(11) unsigned
sp : int(11) unsigned
max_ap : int(11) unsigned
ap : int(11) unsigned
status_point : int(11) unsigned
skill_point : int(11) unsigned
trait_point : int(11) unsigned
option : int(11)
karma : tinyint(3)
manner : smallint(6)
party_id : int(11) unsigned
guild_id : int(11) unsigned
pet_id : int(11) unsigned
homun_id : int(11) unsigned
elemental_id : int(11) unsigned
hair : tinyint(4) unsigned
hair_color : smallint(5) unsigned
clothes_color : smallint(5) unsigned
body : smallint(5) unsigned
weapon : smallint(6) unsigned
shield : smallint(6) unsigned
head_top : smallint(6) unsigned
head_mid : smallint(6) unsigned
head_bottom : smallint(6) unsigned
robe : smallint(6) unsigned
last_map : varchar(11)
last_x : smallint(4) unsigned
last_y : smallint(4) unsigned
last_instanceid : int(11) unsigned
save_map : varchar(11)
save_x : smallint(4) unsigned
save_y : smallint(4) unsigned
partner_id : int(11) unsigned
online : tinyint(2)
father : int(11) unsigned
mother : int(11) unsigned
child : int(11) unsigned
fame : int(11) unsigned
rename : smallint(3) unsigned
delete_date : int(11) unsigned
moves : int(11) unsigned
unban_time : int(11) unsigned
font : tinyint(3) unsigned
uniqueitem_counter : int(11) unsigned
sex : enum('M','F')
hotkey_rowshift : tinyint(3) unsigned
hotkey_rowshift2 : tinyint(3) unsigned
clan_id : int(11) unsigned
last_login : datetime
title_id : int(11) unsigned
show_equip : tinyint(3) unsigned
inventory_slots : smallint(6)
body_direction : tinyint(1) unsigned
disable_call : tinyint(3) unsigned
disable_partyinvite : tinyint(1) unsigned
disable_showcostumes : tinyint(1) unsigned

v		rathena_db charlog
id : bigint(20) unsigned
time : datetime
char_msg : varchar(255)
account_id : int(11) unsigned
char_num : tinyint(4)
name : varchar(23)
str : int(11) unsigned
agi : int(11) unsigned
vit : int(11) unsigned
int : int(11) unsigned
dex : int(11) unsigned
luk : int(11) unsigned
hair : tinyint(4)
hair_color : int(11)

v		rathena_db char_reg_num
char_id : int(11) unsigned
key : varchar(32)
index : int(11) unsigned
value : bigint(11)

v		rathena_db char_reg_str
char_id : int(11) unsigned
key : varchar(32)
index : int(11) unsigned
value : varchar(254)

v		rathena_db clan
clan_id : int(11) unsigned
name : varchar(24)
master : varchar(24)
mapname : varchar(24)
max_member : smallint(6) unsigned

v		rathena_db clan_alliance
clan_id : int(11) unsigned
opposition : int(11) unsigned
alliance_id : int(11) unsigned
name : varchar(24)

v		rathena_db cp_banlog
id : int(10) unsigned
account_id : int(11) unsigned
banned_by : int(11) unsigned
ban_type : tinyint(1)
ban_until : datetime
ban_date : datetime
ban_reason : text

v		rathena_db cp_charprefs
id : int(10) unsigned
account_id : int(11) unsigned
char_id : int(11) unsigned
name : varchar(80)
value : varchar(255)
create_date : datetime

v		rathena_db cp_cmsnews
id : int(11)
title : varchar(100)
body : text
link : varchar(100)
author : varchar(100)
created : datetime
modified : datetime

v		rathena_db cp_cmspages
id : int(11)
path : varchar(100)
title : varchar(100)
body : text
modified : datetime

v		rathena_db cp_cmssettings
name : varchar(128)
value : varchar(128)

v		rathena_db cp_commands
id : int(6)
command : varchar(128)
issuer : varchar(32)
account_id : int(12)
done : int(1)
timestamp : timestamp

v		rathena_db cp_createlog
id : int(11) unsigned
account_id : int(11) unsigned
userid : varchar(23)
user_pass : varchar(32)
sex : enum('M','F','S')
email : varchar(39)
reg_date : datetime
reg_ip : varchar(39)
delete_date : datetime
confirmed : tinyint(1)
confirm_code : varchar(32)
confirm_expire : datetime

v		rathena_db cp_credits
account_id : int(11) unsigned
balance : int(11) unsigned
last_donation_date : datetime
last_donation_amount : float unsigned

v		rathena_db cp_emailchange
id : int(11)
code : varchar(32)
account_id : int(10)
old_email : varchar(39)
new_email : varchar(39)
request_date : datetime
request_ip : varchar(39)
change_date : datetime
change_ip : varchar(39)
change_done : tinyint(4)

v		rathena_db cp_ipbanlog
id : int(10) unsigned
ip_address : varchar(39)
banned_by : int(11) unsigned
ban_type : tinyint(1)
ban_until : datetime
ban_date : datetime
ban_reason : text

v		rathena_db cp_itemdesc
itemid : int(10) unsigned
itemdesc : text

v		rathena_db cp_itemshop
id : int(11) unsigned
nameid : int(11) unsigned
category : int(11)
quantity : int(11) unsigned
cost : int(11) unsigned
info : text
use_existing : tinyint(4)
create_date : datetime

v		rathena_db cp_loginlog
id : int(11)
account_id : int(10)
username : varchar(23)
password : varchar(32)
ip : varchar(39)
login_date : datetime
error_code : tinyint(1)

v		rathena_db cp_loginprefs
id : int(10) unsigned
account_id : int(11) unsigned
name : varchar(80)
value : varchar(255)
create_date : datetime

v		rathena_db cp_onlinepeak
id : int(10) unsigned
users : int(10) unsigned
date : date

v		rathena_db cp_pwchange
id : int(11)
account_id : int(10)
old_password : varchar(32)
new_password : varchar(32)
change_date : datetime
change_ip : varchar(39)

v		rathena_db cp_redeemlog
id : int(11) unsigned
nameid : int(11) unsigned
quantity : int(11) unsigned
cost : int(11) unsigned
account_id : int(11) unsigned
char_id : int(11) unsigned
redeemed : tinyint(1) unsigned
redemption_date : datetime
purchase_date : datetime
credits_before : int(10)
credits_after : int(10)

v		rathena_db cp_resetpass
id : int(11)
code : varchar(32)
account_id : int(10)
old_password : varchar(32)
new_password : varchar(32)
request_date : datetime
request_ip : varchar(39)
reset_date : datetime
reset_ip : varchar(39)
reset_done : tinyint(4)

v		rathena_db cp_servicedesk
ticket_id : int(6)
account_id : int(7)
category : int(6)
status : varchar(12)
char_id : text
timestamp : timestamp
sslink : text
chatlink : text
videolink : text
subject : varchar(64)
text : text
ip : varchar(39)
team : int(1)
curemail : text
lastreply : varchar(24)

v		rathena_db cp_servicedeska
action_id : int(6)
ticket_id : int(6)
author : varchar(32)
text : text
action : text
timestamp : timestamp
ip : varchar(39)
isstaff : int(1)

v		rathena_db cp_servicedeskcat
cat_id : int(3)
name : varchar(32)
display : int(1)

v		rathena_db cp_servicedesksettings
account_id : int(7)
account_name : varchar(32)
prefered_name : varchar(32)
team : int(1)
emailalerts : int(1)
timestamp : timestamp

v		rathena_db cp_trusted
id : int(10) unsigned
account_id : int(11) unsigned
email : varchar(255)
create_date : datetime
delete_date : datetime

v		rathena_db cp_txnlog
id : int(10) unsigned
account_id : int(11) unsigned
server_name : varchar(255)
credits : int(11)
receiver_email : varchar(60)
item_name : varchar(100)
item_number : varchar(10)
quantity : varchar(6)
payment_status : varchar(20)
pending_reason : varchar(20)
payment_date : varchar(40)
mc_gross : varchar(20)
mc_fee : varchar(20)
tax : varchar(20)
mc_currency : varchar(3)
parent_txn_id : varchar(20)
txn_id : varchar(20)
txn_type : varchar(20)
first_name : varchar(30)
last_name : varchar(40)
address_street : varchar(50)
address_city : varchar(30)
address_state : varchar(30)
address_zip : varchar(20)
address_country : varchar(30)
address_status : varchar(11)
payer_email : varchar(60)
payer_status : varchar(10)
payment_type : varchar(10)
notify_version : varchar(10)
verify_sign : varchar(255)
referrer_id : varchar(13)
process_date : datetime
hold_until : datetime

v		rathena_db cp_xferlog
id : int(10) unsigned
from_account_id : int(10) unsigned
target_account_id : int(10) unsigned
target_char_id : int(11) unsigned
amount : int(10) unsigned
for_free : tinyint(1) unsigned
transfer_date : datetime

v		rathena_db db_roulette
index : int(11)
level : smallint(5) unsigned
item_id : int(10) unsigned
amount : smallint(5) unsigned
flag : smallint(5) unsigned

v		rathena_db elemental
ele_id : int(11) unsigned
char_id : int(11) unsigned
class : mediumint(9) unsigned
mode : int(11) unsigned
hp : int(11) unsigned
sp : int(11) unsigned
max_hp : int(11) unsigned
max_sp : int(11) unsigned
atk1 : mediumint(6) unsigned
atk2 : mediumint(6) unsigned
matk : mediumint(6) unsigned
aspd : smallint(4) unsigned
def : smallint(4) unsigned
mdef : smallint(4) unsigned
flee : smallint(4) unsigned
hit : smallint(4) unsigned
life_time : bigint(20)

v		rathena_db friends
char_id : int(11) unsigned
friend_id : int(11) unsigned

v		rathena_db global_acc_reg_num
account_id : int(11) unsigned
key : varchar(32)
index : int(11) unsigned
value : bigint(11)

v		rathena_db global_acc_reg_str
account_id : int(11) unsigned
key : varchar(32)
index : int(11) unsigned
value : varchar(254)

v		rathena_db guild
guild_id : int(11) unsigned
name : varchar(24)
char_id : int(11) unsigned
master : varchar(24)
guild_lv : tinyint(6) unsigned
connect_member : tinyint(6) unsigned
max_member : tinyint(6) unsigned
average_lv : smallint(6) unsigned
exp : bigint(20) unsigned
next_exp : bigint(20) unsigned
skill_point : tinyint(11) unsigned
mes1 : varchar(60)
mes2 : varchar(120)
emblem_len : int(11) unsigned
emblem_id : int(11) unsigned
emblem_data : blob
last_master_change : datetime

v		rathena_db guild_alliance
guild_id : int(11) unsigned
opposition : int(11) unsigned
alliance_id : int(11) unsigned
name : varchar(24)

v		rathena_db guild_castle
castle_id : int(11) unsigned
guild_id : int(11) unsigned
economy : int(11) unsigned
defense : int(11) unsigned
triggerE : int(11) unsigned
triggerD : int(11) unsigned
nextTime : int(11) unsigned
payTime : int(11) unsigned
createTime : int(11) unsigned
visibleC : int(11) unsigned
visibleG0 : int(11) unsigned
visibleG1 : int(11) unsigned
visibleG2 : int(11) unsigned
visibleG3 : int(11) unsigned
visibleG4 : int(11) unsigned
visibleG5 : int(11) unsigned
visibleG6 : int(11) unsigned
visibleG7 : int(11) unsigned

v		rathena_db guild_expulsion
guild_id : int(11) unsigned
account_id : int(11) unsigned
name : varchar(24)
mes : varchar(40)
char_id : int(11) unsigned

v		rathena_db guild_member
guild_id : int(11) unsigned
char_id : int(11) unsigned
exp : bigint(20) unsigned
position : tinyint(6) unsigned

v		rathena_db guild_position
guild_id : int(9) unsigned
position : tinyint(6) unsigned
name : varchar(24)
mode : smallint(11) unsigned
exp_mode : tinyint(11) unsigned

v		rathena_db guild_skill
guild_id : int(11) unsigned
id : smallint(11) unsigned
lv : tinyint(11) unsigned

v		rathena_db guild_storage
id : int(10) unsigned
guild_id : int(11) unsigned
nameid : int(10) unsigned
amount : int(11) unsigned
equip : int(11) unsigned
identify : smallint(6) unsigned
refine : tinyint(3) unsigned
attribute : tinyint(4) unsigned
card0 : int(10) unsigned
card1 : int(10) unsigned
card2 : int(10) unsigned
card3 : int(10) unsigned
option_id0 : smallint(5)
option_val0 : smallint(5)
option_parm0 : tinyint(3)
option_id1 : smallint(5)
option_val1 : smallint(5)
option_parm1 : tinyint(3)
option_id2 : smallint(5)
option_val2 : smallint(5)
option_parm2 : tinyint(3)
option_id3 : smallint(5)
option_val3 : smallint(5)
option_parm3 : tinyint(3)
option_id4 : smallint(5)
option_val4 : smallint(5)
option_parm4 : tinyint(3)
expire_time : int(11) unsigned
bound : tinyint(3) unsigned
unique_id : bigint(20) unsigned
enchantgrade : tinyint(3) unsigned

v		rathena_db guild_storage_log
id : int(11)
guild_id : int(11) unsigned
time : datetime
char_id : int(11)
name : varchar(24)
nameid : int(10) unsigned
amount : int(11)
identify : smallint(6)
refine : tinyint(3) unsigned
attribute : tinyint(4) unsigned
card0 : int(10) unsigned
card1 : int(10) unsigned
card2 : int(10) unsigned
card3 : int(10) unsigned
option_id0 : smallint(5)
option_val0 : smallint(5)
option_parm0 : tinyint(3)
option_id1 : smallint(5)
option_val1 : smallint(5)
option_parm1 : tinyint(3)
option_id2 : smallint(5)
option_val2 : smallint(5)
option_parm2 : tinyint(3)
option_id3 : smallint(5)
option_val3 : smallint(5)
option_parm3 : tinyint(3)
option_id4 : smallint(5)
option_val4 : smallint(5)
option_parm4 : tinyint(3)
expire_time : int(11) unsigned
unique_id : bigint(20) unsigned
bound : tinyint(1) unsigned
enchantgrade : tinyint(3) unsigned

v		rathena_db homunculus
homun_id : int(11)
char_id : int(11) unsigned
class : mediumint(9) unsigned
prev_class : mediumint(9)
name : varchar(24)
level : smallint(4)
exp : bigint(20) unsigned
intimacy : int(12)
hunger : smallint(4)
str : smallint(4) unsigned
agi : smallint(4) unsigned
vit : smallint(4) unsigned
int : smallint(4) unsigned
dex : smallint(4) unsigned
luk : smallint(4) unsigned
hp : int(11) unsigned
max_hp : int(11) unsigned
sp : int(11) unsigned
max_sp : int(11) unsigned
skill_point : smallint(4) unsigned
alive : tinyint(2)
rename_flag : tinyint(2)
vaporize : tinyint(2)
autofeed : tinyint(2)

v		rathena_db hotkey
char_id : int(11) unsigned
hotkey : tinyint(2) unsigned
type : tinyint(1) unsigned
itemskill_id : int(11) unsigned
skill_lvl : tinyint(4) unsigned

v		rathena_db interlog
id : int(11)
time : datetime
log : varchar(255)

v		rathena_db inventory
id : int(11) unsigned
char_id : int(11) unsigned
nameid : int(10) unsigned
amount : int(11) unsigned
equip : int(11) unsigned
identify : smallint(6)
refine : tinyint(3) unsigned
attribute : tinyint(4) unsigned
card0 : int(10) unsigned
card1 : int(10) unsigned
card2 : int(10) unsigned
card3 : int(10) unsigned
option_id0 : smallint(5)
option_val0 : smallint(5)
option_parm0 : tinyint(3)
option_id1 : smallint(5)
option_val1 : smallint(5)
option_parm1 : tinyint(3)
option_id2 : smallint(5)
option_val2 : smallint(5)
option_parm2 : tinyint(3)
option_id3 : smallint(5)
option_val3 : smallint(5)
option_parm3 : tinyint(3)
option_id4 : smallint(5)
option_val4 : smallint(5)
option_parm4 : tinyint(3)
expire_time : int(11) unsigned
favorite : tinyint(3) unsigned
bound : tinyint(3) unsigned
unique_id : bigint(20) unsigned
equip_switch : int(11) unsigned
enchantgrade : tinyint(3) unsigned

v		rathena_db ipbanlist
list : varchar(15)
btime : datetime
rtime : datetime
reason : varchar(255)

v		rathena_db item_db2_re
id : int(10) unsigned
name_aegis : varchar(50)
name_english : varchar(100)
type : varchar(20)
subtype : varchar(20)
price_buy : mediumint(8) unsigned
price_sell : mediumint(8) unsigned
weight : smallint(5) unsigned
attack : smallint(5) unsigned
magic_attack : smallint(5) unsigned
defense : smallint(5) unsigned
range : tinyint(2) unsigned
slots : tinyint(2) unsigned
job_all : tinyint(1) unsigned
job_acolyte : tinyint(1) unsigned
job_alchemist : tinyint(1) unsigned
job_archer : tinyint(1) unsigned
job_assassin : tinyint(1) unsigned
job_barddancer : tinyint(1) unsigned
job_blacksmith : tinyint(1) unsigned
job_crusader : tinyint(1) unsigned
job_gunslinger : tinyint(1) unsigned
job_hunter : tinyint(1) unsigned
job_kagerouoboro : tinyint(1) unsigned
job_knight : tinyint(1) unsigned
job_mage : tinyint(1) unsigned
job_merchant : tinyint(1) unsigned
job_monk : tinyint(1) unsigned
job_ninja : tinyint(1) unsigned
job_novice : tinyint(1) unsigned
job_priest : tinyint(1) unsigned
job_rebellion : tinyint(1) unsigned
job_rogue : tinyint(1) unsigned
job_sage : tinyint(1) unsigned
job_soullinker : tinyint(1) unsigned
job_spirit_handler : tinyint(1) unsigned
job_stargladiator : tinyint(1) unsigned
job_summoner : tinyint(1) unsigned
job_supernovice : tinyint(1) unsigned
job_swordman : tinyint(1) unsigned
job_taekwon : tinyint(1) unsigned
job_thief : tinyint(1) unsigned
job_wizard : tinyint(1) unsigned
class_all : tinyint(1) unsigned
class_normal : tinyint(1) unsigned
class_upper : tinyint(1) unsigned
class_baby : tinyint(1) unsigned
class_third : tinyint(1) unsigned
class_third_upper : tinyint(1) unsigned
class_third_baby : tinyint(1) unsigned
class_fourth : tinyint(1) unsigned
gender : varchar(10)
location_head_top : tinyint(1) unsigned
location_head_mid : tinyint(1) unsigned
location_head_low : tinyint(1) unsigned
location_armor : tinyint(1) unsigned
location_right_hand : tinyint(1) unsigned
location_left_hand : tinyint(1) unsigned
location_garment : tinyint(1) unsigned
location_shoes : tinyint(1) unsigned
location_right_accessory : tinyint(1) unsigned
location_left_accessory : tinyint(1) unsigned
location_costume_head_top : tinyint(1) unsigned
location_costume_head_mid : tinyint(1) unsigned
location_costume_head_low : tinyint(1) unsigned
location_costume_garment : tinyint(1) unsigned
location_ammo : tinyint(1) unsigned
location_shadow_armor : tinyint(1) unsigned
location_shadow_weapon : tinyint(1) unsigned
location_shadow_shield : tinyint(1) unsigned
location_shadow_shoes : tinyint(1) unsigned
location_shadow_right_accessory : tinyint(1) unsigned
location_shadow_left_accessory : tinyint(1) unsigned
weapon_level : tinyint(1) unsigned
armor_level : tinyint(1) unsigned
equip_level_min : smallint(5) unsigned
equip_level_max : smallint(5) unsigned
refineable : tinyint(1) unsigned
gradable : tinyint(1) unsigned
view : smallint(5) unsigned
alias_name : varchar(50)
flag_buyingstore : tinyint(1) unsigned
flag_deadbranch : tinyint(1) unsigned
flag_container : tinyint(1) unsigned
flag_uniqueid : tinyint(1) unsigned
flag_bindonequip : tinyint(1) unsigned
flag_dropannounce : tinyint(1) unsigned
flag_noconsume : tinyint(1) unsigned
flag_dropeffect : varchar(20)
delay_duration : bigint(20) unsigned
delay_status : varchar(30)
stack_amount : smallint(5) unsigned
stack_inventory : tinyint(1) unsigned
stack_cart : tinyint(1) unsigned
stack_storage : tinyint(1) unsigned
stack_guildstorage : tinyint(1) unsigned
nouse_override : smallint(5) unsigned
nouse_sitting : tinyint(1) unsigned
trade_override : smallint(5) unsigned
trade_nodrop : tinyint(1) unsigned
trade_notrade : tinyint(1) unsigned
trade_tradepartner : tinyint(1) unsigned
trade_nosell : tinyint(1) unsigned
trade_nocart : tinyint(1) unsigned
trade_nostorage : tinyint(1) unsigned
trade_noguildstorage : tinyint(1) unsigned
trade_nomail : tinyint(1) unsigned
trade_noauction : tinyint(1) unsigned
script : text
equip_script : text
unequip_script : text

v		rathena_db item_db_re
id : int(10) unsigned
name_aegis : varchar(50)
name_english : varchar(100)
type : varchar(20)
subtype : varchar(20)
price_buy : mediumint(8) unsigned
price_sell : mediumint(8) unsigned
weight : smallint(5) unsigned
attack : smallint(5) unsigned
magic_attack : smallint(5) unsigned
defense : smallint(5) unsigned
range : tinyint(2) unsigned
slots : tinyint(2) unsigned
job_all : tinyint(1) unsigned
job_acolyte : tinyint(1) unsigned
job_alchemist : tinyint(1) unsigned
job_archer : tinyint(1) unsigned
job_assassin : tinyint(1) unsigned
job_barddancer : tinyint(1) unsigned
job_blacksmith : tinyint(1) unsigned
job_crusader : tinyint(1) unsigned
job_gunslinger : tinyint(1) unsigned
job_hunter : tinyint(1) unsigned
job_kagerouoboro : tinyint(1) unsigned
job_knight : tinyint(1) unsigned
job_mage : tinyint(1) unsigned
job_merchant : tinyint(1) unsigned
job_monk : tinyint(1) unsigned
job_ninja : tinyint(1) unsigned
job_novice : tinyint(1) unsigned
job_priest : tinyint(1) unsigned
job_rebellion : tinyint(1) unsigned
job_rogue : tinyint(1) unsigned
job_sage : tinyint(1) unsigned
job_soullinker : tinyint(1) unsigned
job_spirit_handler : tinyint(1) unsigned
job_stargladiator : tinyint(1) unsigned
job_summoner : tinyint(1) unsigned
job_supernovice : tinyint(1) unsigned
job_swordman : tinyint(1) unsigned
job_taekwon : tinyint(1) unsigned
job_thief : tinyint(1) unsigned
job_wizard : tinyint(1) unsigned
class_all : tinyint(1) unsigned
class_normal : tinyint(1) unsigned
class_upper : tinyint(1) unsigned
class_baby : tinyint(1) unsigned
class_third : tinyint(1) unsigned
class_third_upper : tinyint(1) unsigned
class_third_baby : tinyint(1) unsigned
class_fourth : tinyint(1) unsigned
gender : varchar(10)
location_head_top : tinyint(1) unsigned
location_head_mid : tinyint(1) unsigned
location_head_low : tinyint(1) unsigned
location_armor : tinyint(1) unsigned
location_right_hand : tinyint(1) unsigned
location_left_hand : tinyint(1) unsigned
location_garment : tinyint(1) unsigned
location_shoes : tinyint(1) unsigned
location_right_accessory : tinyint(1) unsigned
location_left_accessory : tinyint(1) unsigned
location_costume_head_top : tinyint(1) unsigned
location_costume_head_mid : tinyint(1) unsigned
location_costume_head_low : tinyint(1) unsigned
location_costume_garment : tinyint(1) unsigned
location_ammo : tinyint(1) unsigned
location_shadow_armor : tinyint(1) unsigned
location_shadow_weapon : tinyint(1) unsigned
location_shadow_shield : tinyint(1) unsigned
location_shadow_shoes : tinyint(1) unsigned
location_shadow_right_accessory : tinyint(1) unsigned
location_shadow_left_accessory : tinyint(1) unsigned
weapon_level : tinyint(1) unsigned
armor_level : tinyint(1) unsigned
equip_level_min : smallint(5) unsigned
equip_level_max : smallint(5) unsigned
refineable : tinyint(1) unsigned
gradable : tinyint(1) unsigned
view : smallint(5) unsigned
alias_name : varchar(50)
flag_buyingstore : tinyint(1) unsigned
flag_deadbranch : tinyint(1) unsigned
flag_container : tinyint(1) unsigned
flag_uniqueid : tinyint(1) unsigned
flag_bindonequip : tinyint(1) unsigned
flag_dropannounce : tinyint(1) unsigned
flag_noconsume : tinyint(1) unsigned
flag_dropeffect : varchar(20)
delay_duration : bigint(20) unsigned
delay_status : varchar(30)
stack_amount : smallint(5) unsigned
stack_inventory : tinyint(1) unsigned
stack_cart : tinyint(1) unsigned
stack_storage : tinyint(1) unsigned
stack_guildstorage : tinyint(1) unsigned
nouse_override : smallint(5) unsigned
nouse_sitting : tinyint(1) unsigned
trade_override : smallint(5) unsigned
trade_nodrop : tinyint(1) unsigned
trade_notrade : tinyint(1) unsigned
trade_tradepartner : tinyint(1) unsigned
trade_nosell : tinyint(1) unsigned
trade_nocart : tinyint(1) unsigned
trade_nostorage : tinyint(1) unsigned
trade_noguildstorage : tinyint(1) unsigned
trade_nomail : tinyint(1) unsigned
trade_noauction : tinyint(1) unsigned
script : text
equip_script : text
unequip_script : text

v		rathena_db login
account_id : int(11) unsigned
userid : varchar(23)
user_pass : varchar(32)
sex : enum('M','F','S')
email : varchar(39)
group_id : tinyint(3)
state : int(11) unsigned
unban_time : int(11) unsigned
expiration_time : int(11) unsigned
logincount : mediumint(9) unsigned
lastlogin : datetime
last_ip : varchar(100)
birthdate : date
character_slots : tinyint(3) unsigned
pincode : varchar(4)
pincode_change : int(11) unsigned
vip_time : int(11) unsigned
old_group : tinyint(3)
web_auth_token : varchar(17)
web_auth_token_enabled : tinyint(2)

v		rathena_db mail
id : bigint(20) unsigned
send_name : varchar(30)
send_id : int(11) unsigned
dest_name : varchar(30)
dest_id : int(11) unsigned
title : varchar(45)
message : varchar(500)
time : int(11) unsigned
status : tinyint(2)
zeny : int(11) unsigned
type : smallint(5)

v		rathena_db mail_attachments
id : bigint(20) unsigned
index : smallint(5) unsigned
nameid : int(10) unsigned
amount : int(11) unsigned
refine : tinyint(3) unsigned
attribute : tinyint(4) unsigned
identify : smallint(6)
card0 : int(10) unsigned
card1 : int(10) unsigned
card2 : int(10) unsigned
card3 : int(10) unsigned
option_id0 : smallint(5)
option_val0 : smallint(5)
option_parm0 : tinyint(3)
option_id1 : smallint(5)
option_val1 : smallint(5)
option_parm1 : tinyint(3)
option_id2 : smallint(5)
option_val2 : smallint(5)
option_parm2 : tinyint(3)
option_id3 : smallint(5)
option_val3 : smallint(5)
option_parm3 : tinyint(3)
option_id4 : smallint(5)
option_val4 : smallint(5)
option_parm4 : tinyint(3)
unique_id : bigint(20) unsigned
bound : tinyint(1) unsigned
enchantgrade : tinyint(3) unsigned

v		rathena_db mapreg
varname : varchar(32)
index : int(11) unsigned
value : varchar(255)

v		rathena_db market
name : varchar(50)
nameid : int(10) unsigned
price : int(11) unsigned
amount : int(11)
flag : tinyint(2) unsigned

v		rathena_db memo
memo_id : int(11) unsigned
char_id : int(11) unsigned
map : varchar(11)
x : smallint(4) unsigned
y : smallint(4) unsigned

v		rathena_db mercenary
mer_id : int(11) unsigned
char_id : int(11) unsigned
class : mediumint(9) unsigned
hp : int(11) unsigned
sp : int(11) unsigned
kill_counter : int(11)
life_time : bigint(20)

v		rathena_db mercenary_owner
char_id : int(11) unsigned
merc_id : int(11) unsigned
arch_calls : int(11)
arch_faith : int(11)
spear_calls : int(11)
spear_faith : int(11)
sword_calls : int(11)
sword_faith : int(11)

v		rathena_db mob_db2_re
id : int(11) unsigned
name_aegis : varchar(24)
name_english : text
name_japanese : text
level : smallint(6) unsigned
hp : int(11) unsigned
sp : mediumint(9) unsigned
base_exp : int(11) unsigned
job_exp : int(11) unsigned
mvp_exp : int(11) unsigned
attack : smallint(6) unsigned
attack2 : smallint(6) unsigned
defense : smallint(6) unsigned
magic_defense : smallint(6) unsigned
resistance : smallint(6) unsigned
magic_resistance : smallint(6) unsigned
str : smallint(6) unsigned
agi : smallint(6) unsigned
vit : smallint(6) unsigned
int : smallint(6) unsigned
dex : smallint(6) unsigned
luk : smallint(6) unsigned
attack_range : tinyint(4) unsigned
skill_range : tinyint(4) unsigned
chase_range : tinyint(4) unsigned
size : varchar(24)
race : varchar(24)
racegroup_goblin : tinyint(1) unsigned
racegroup_kobold : tinyint(1) unsigned
racegroup_orc : tinyint(1) unsigned
racegroup_golem : tinyint(1) unsigned
racegroup_guardian : tinyint(1) unsigned
racegroup_ninja : tinyint(1) unsigned
racegroup_gvg : tinyint(1) unsigned
racegroup_battlefield : tinyint(1) unsigned
racegroup_treasure : tinyint(1) unsigned
racegroup_biolab : tinyint(1) unsigned
racegroup_manuk : tinyint(1) unsigned
racegroup_splendide : tinyint(1) unsigned
racegroup_scaraba : tinyint(1) unsigned
racegroup_ogh_atk_def : tinyint(1) unsigned
racegroup_ogh_hidden : tinyint(1) unsigned
racegroup_bio5_swordman_thief : tinyint(1) unsigned
racegroup_bio5_acolyte_merchant : tinyint(1) unsigned
racegroup_bio5_mage_archer : tinyint(1) unsigned
racegroup_bio5_mvp : tinyint(1) unsigned
racegroup_clocktower : tinyint(1) unsigned
racegroup_thanatos : tinyint(1) unsigned
racegroup_faceworm : tinyint(1) unsigned
racegroup_hearthunter : tinyint(1) unsigned
racegroup_rockridge : tinyint(1) unsigned
racegroup_werner_lab : tinyint(1) unsigned
racegroup_temple_demon : tinyint(1) unsigned
racegroup_illusion_vampire : tinyint(1) unsigned
racegroup_malangdo : tinyint(1) unsigned
racegroup_ep172alpha : tinyint(1) unsigned
racegroup_ep172beta : tinyint(1) unsigned
racegroup_ep172bath : tinyint(1) unsigned
racegroup_illusion_turtle : tinyint(1) unsigned
racegroup_rachel_sanctuary : tinyint(1) unsigned
racegroup_illusion_luanda : tinyint(1) unsigned
racegroup_illusion_frozen : tinyint(1) unsigned
racegroup_illusion_moonlight : tinyint(1) unsigned
racegroup_ep16_def : tinyint(1) unsigned
racegroup_edda_arunafeltz : tinyint(1) unsigned
racegroup_lasagna : tinyint(1) unsigned
racegroup_glast_heim_abyss : tinyint(1) unsigned
racegroup_destroyed_valkyrie_realm : tinyint(1) unsigned
racegroup_encroached_gephenia : tinyint(1) unsigned
element : varchar(24)
element_level : tinyint(4) unsigned
walk_speed : smallint(6) unsigned
attack_delay : smallint(6) unsigned
attack_motion : smallint(6) unsigned
damage_motion : smallint(6) unsigned
damage_taken : smallint(6) unsigned
groupid : smallint(6) unsigned
title : text
ai : varchar(50)
class : varchar(50)
mode_canmove : tinyint(1) unsigned
mode_looter : tinyint(1) unsigned
mode_aggressive : tinyint(1) unsigned
mode_assist : tinyint(1) unsigned
mode_castsensoridle : tinyint(1) unsigned
mode_norandomwalk : tinyint(1) unsigned
mode_nocast : tinyint(1) unsigned
mode_canattack : tinyint(1) unsigned
mode_castsensorchase : tinyint(1) unsigned
mode_changechase : tinyint(1) unsigned
mode_angry : tinyint(1) unsigned
mode_changetargetmelee : tinyint(1) unsigned
mode_changetargetchase : tinyint(1) unsigned
mode_targetweak : tinyint(1) unsigned
mode_randomtarget : tinyint(1) unsigned
mode_ignoremelee : tinyint(1) unsigned
mode_ignoremagic : tinyint(1) unsigned
mode_ignoreranged : tinyint(1) unsigned
mode_mvp : tinyint(1) unsigned
mode_ignoremisc : tinyint(1) unsigned
mode_knockbackimmune : tinyint(1) unsigned
mode_teleportblock : tinyint(1) unsigned
mode_fixeditemdrop : tinyint(1) unsigned
mode_detector : tinyint(1) unsigned
mode_statusimmune : tinyint(1) unsigned
mode_skillimmune : tinyint(1) unsigned
mvpdrop1_item : varchar(50)
mvpdrop1_rate : smallint(9) unsigned
mvpdrop1_option : varchar(50)
mvpdrop1_index : tinyint(2) unsigned
mvpdrop2_item : varchar(50)
mvpdrop2_rate : smallint(9) unsigned
mvpdrop2_option : varchar(50)
mvpdrop2_index : tinyint(2) unsigned
mvpdrop3_item : varchar(50)
mvpdrop3_rate : smallint(9) unsigned
mvpdrop3_option : varchar(50)
mvpdrop3_index : tinyint(2) unsigned
drop1_item : varchar(50)
drop1_rate : smallint(9) unsigned
drop1_nosteal : tinyint(1) unsigned
drop1_option : varchar(50)
drop1_index : tinyint(2) unsigned
drop2_item : varchar(50)
drop2_rate : smallint(9) unsigned
drop2_nosteal : tinyint(1) unsigned
drop2_option : varchar(50)
drop2_index : tinyint(2) unsigned
drop3_item : varchar(50)
drop3_rate : smallint(9) unsigned
drop3_nosteal : tinyint(1) unsigned
drop3_option : varchar(50)
drop3_index : tinyint(2) unsigned
drop4_item : varchar(50)
drop4_rate : smallint(9) unsigned
drop4_nosteal : tinyint(1) unsigned
drop4_option : varchar(50)
drop4_index : tinyint(2) unsigned
drop5_item : varchar(50)
drop5_rate : smallint(9) unsigned
drop5_nosteal : tinyint(1) unsigned
drop5_option : varchar(50)
drop5_index : tinyint(2) unsigned
drop6_item : varchar(50)
drop6_rate : smallint(9) unsigned
drop6_nosteal : tinyint(1) unsigned
drop6_option : varchar(50)
drop6_index : tinyint(2) unsigned
drop7_item : varchar(50)
drop7_rate : smallint(9) unsigned
drop7_nosteal : tinyint(1) unsigned
drop7_option : varchar(50)
drop7_index : tinyint(2) unsigned
drop8_item : varchar(50)
drop8_rate : smallint(9) unsigned
drop8_nosteal : tinyint(1) unsigned
drop8_option : varchar(50)
drop8_index : tinyint(2) unsigned
drop9_item : varchar(50)
drop9_rate : smallint(9) unsigned
drop9_nosteal : tinyint(1) unsigned
drop9_option : varchar(50)
drop9_index : tinyint(2) unsigned
drop10_item : varchar(50)
drop10_rate : smallint(9) unsigned
drop10_nosteal : tinyint(1) unsigned
drop10_option : varchar(50)
drop10_index : tinyint(2) unsigned

v		rathena_db mob_db_re
id : int(11) unsigned
name_aegis : varchar(24)
name_english : text
name_japanese : text
level : smallint(6) unsigned
hp : int(11) unsigned
sp : mediumint(9) unsigned
base_exp : int(11) unsigned
job_exp : int(11) unsigned
mvp_exp : int(11) unsigned
attack : smallint(6) unsigned
attack2 : smallint(6) unsigned
defense : smallint(6) unsigned
magic_defense : smallint(6) unsigned
resistance : smallint(6) unsigned
magic_resistance : smallint(6) unsigned
str : smallint(6) unsigned
agi : smallint(6) unsigned
vit : smallint(6) unsigned
int : smallint(6) unsigned
dex : smallint(6) unsigned
luk : smallint(6) unsigned
attack_range : tinyint(4) unsigned
skill_range : tinyint(4) unsigned
chase_range : tinyint(4) unsigned
size : varchar(24)
race : varchar(24)
racegroup_goblin : tinyint(1) unsigned
racegroup_kobold : tinyint(1) unsigned
racegroup_orc : tinyint(1) unsigned
racegroup_golem : tinyint(1) unsigned
racegroup_guardian : tinyint(1) unsigned
racegroup_ninja : tinyint(1) unsigned
racegroup_gvg : tinyint(1) unsigned
racegroup_battlefield : tinyint(1) unsigned
racegroup_treasure : tinyint(1) unsigned
racegroup_biolab : tinyint(1) unsigned
racegroup_manuk : tinyint(1) unsigned
racegroup_splendide : tinyint(1) unsigned
racegroup_scaraba : tinyint(1) unsigned
racegroup_ogh_atk_def : tinyint(1) unsigned
racegroup_ogh_hidden : tinyint(1) unsigned
racegroup_bio5_swordman_thief : tinyint(1) unsigned
racegroup_bio5_acolyte_merchant : tinyint(1) unsigned
racegroup_bio5_mage_archer : tinyint(1) unsigned
racegroup_bio5_mvp : tinyint(1) unsigned
racegroup_clocktower : tinyint(1) unsigned
racegroup_thanatos : tinyint(1) unsigned
racegroup_faceworm : tinyint(1) unsigned
racegroup_hearthunter : tinyint(1) unsigned
racegroup_rockridge : tinyint(1) unsigned
racegroup_werner_lab : tinyint(1) unsigned
racegroup_temple_demon : tinyint(1) unsigned
racegroup_illusion_vampire : tinyint(1) unsigned
racegroup_malangdo : tinyint(1) unsigned
racegroup_ep172alpha : tinyint(1) unsigned
racegroup_ep172beta : tinyint(1) unsigned
racegroup_ep172bath : tinyint(1) unsigned
racegroup_illusion_turtle : tinyint(1) unsigned
racegroup_rachel_sanctuary : tinyint(1) unsigned
racegroup_illusion_luanda : tinyint(1) unsigned
racegroup_illusion_frozen : tinyint(1) unsigned
racegroup_illusion_moonlight : tinyint(1) unsigned
racegroup_ep16_def : tinyint(1) unsigned
racegroup_edda_arunafeltz : tinyint(1) unsigned
racegroup_lasagna : tinyint(1) unsigned
racegroup_glast_heim_abyss : tinyint(1) unsigned
racegroup_destroyed_valkyrie_realm : tinyint(1) unsigned
racegroup_encroached_gephenia : tinyint(1) unsigned
element : varchar(24)
element_level : tinyint(4) unsigned
walk_speed : smallint(6) unsigned
attack_delay : smallint(6) unsigned
attack_motion : smallint(6) unsigned
damage_motion : smallint(6) unsigned
damage_taken : smallint(6) unsigned
groupid : smallint(6) unsigned
title : text
ai : varchar(2)
class : varchar(50)
mode_canmove : tinyint(1) unsigned
mode_looter : tinyint(1) unsigned
mode_aggressive : tinyint(1) unsigned
mode_assist : tinyint(1) unsigned
mode_castsensoridle : tinyint(1) unsigned
mode_norandomwalk : tinyint(1) unsigned
mode_nocast : tinyint(1) unsigned
mode_canattack : tinyint(1) unsigned
mode_castsensorchase : tinyint(1) unsigned
mode_changechase : tinyint(1) unsigned
mode_angry : tinyint(1) unsigned
mode_changetargetmelee : tinyint(1) unsigned
mode_changetargetchase : tinyint(1) unsigned
mode_targetweak : tinyint(1) unsigned
mode_randomtarget : tinyint(1) unsigned
mode_ignoremelee : tinyint(1) unsigned
mode_ignoremagic : tinyint(1) unsigned
mode_ignoreranged : tinyint(1) unsigned
mode_mvp : tinyint(1) unsigned
mode_ignoremisc : tinyint(1) unsigned
mode_knockbackimmune : tinyint(1) unsigned
mode_teleportblock : tinyint(1) unsigned
mode_fixeditemdrop : tinyint(1) unsigned
mode_detector : tinyint(1) unsigned
mode_statusimmune : tinyint(1) unsigned
mode_skillimmune : tinyint(1) unsigned
mvpdrop1_item : varchar(50)
mvpdrop1_rate : smallint(9) unsigned
mvpdrop1_option : varchar(50)
mvpdrop1_index : tinyint(2) unsigned
mvpdrop2_item : varchar(50)
mvpdrop2_rate : smallint(9) unsigned
mvpdrop2_option : varchar(50)
mvpdrop2_index : tinyint(2) unsigned
mvpdrop3_item : varchar(50)
mvpdrop3_rate : smallint(9) unsigned
mvpdrop3_option : varchar(50)
mvpdrop3_index : tinyint(2) unsigned
drop1_item : varchar(50)
drop1_rate : smallint(9) unsigned
drop1_nosteal : tinyint(1) unsigned
drop1_option : varchar(50)
drop1_index : tinyint(2) unsigned
drop2_item : varchar(50)
drop2_rate : smallint(9) unsigned
drop2_nosteal : tinyint(1) unsigned
drop2_option : varchar(50)
drop2_index : tinyint(2) unsigned
drop3_item : varchar(50)
drop3_rate : smallint(9) unsigned
drop3_nosteal : tinyint(1) unsigned
drop3_option : varchar(50)
drop3_index : tinyint(2) unsigned
drop4_item : varchar(50)
drop4_rate : smallint(9) unsigned
drop4_nosteal : tinyint(1) unsigned
drop4_option : varchar(50)
drop4_index : tinyint(2) unsigned
drop5_item : varchar(50)
drop5_rate : smallint(9) unsigned
drop5_nosteal : tinyint(1) unsigned
drop5_option : varchar(50)
drop5_index : tinyint(2) unsigned
drop6_item : varchar(50)
drop6_rate : smallint(9) unsigned
drop6_nosteal : tinyint(1) unsigned
drop6_option : varchar(50)
drop6_index : tinyint(2) unsigned
drop7_item : varchar(50)
drop7_rate : smallint(9) unsigned
drop7_nosteal : tinyint(1) unsigned
drop7_option : varchar(50)
drop7_index : tinyint(2) unsigned
drop8_item : varchar(50)
drop8_rate : smallint(9) unsigned
drop8_nosteal : tinyint(1) unsigned
drop8_option : varchar(50)
drop8_index : tinyint(2) unsigned
drop9_item : varchar(50)
drop9_rate : smallint(9) unsigned
drop9_nosteal : tinyint(1) unsigned
drop9_option : varchar(50)
drop9_index : tinyint(2) unsigned
drop10_item : varchar(50)
drop10_rate : smallint(9) unsigned
drop10_nosteal : tinyint(1) unsigned
drop10_option : varchar(50)
drop10_index : tinyint(2) unsigned

v		rathena_db party
party_id : int(11) unsigned
name : varchar(24)
exp : tinyint(11) unsigned
item : tinyint(11) unsigned
leader_id : int(11) unsigned
leader_char : int(11) unsigned

v		rathena_db party_bookings
world_name : varchar(32)
account_id : int(11) unsigned
char_id : int(11) unsigned
char_name : varchar(23)
purpose : smallint(5) unsigned
assist : tinyint(3) unsigned
damagedealer : tinyint(3) unsigned
healer : tinyint(3) unsigned
tanker : tinyint(3) unsigned
minimum_level : smallint(5) unsigned
maximum_level : smallint(5) unsigned
comment : varchar(255)
created : datetime

v		rathena_db pet
pet_id : int(11) unsigned
class : mediumint(9) unsigned
name : varchar(24)
account_id : int(11) unsigned
char_id : int(11) unsigned
level : smallint(4) unsigned
egg_id : int(10) unsigned
equip : int(10) unsigned
intimate : smallint(9) unsigned
hungry : smallint(9) unsigned
rename_flag : tinyint(4) unsigned
incubate : int(11) unsigned
autofeed : tinyint(2)

v		rathena_db quest
char_id : int(11) unsigned
quest_id : int(10) unsigned
state : enum('0','1','2')
time : int(11) unsigned
count1 : mediumint(8) unsigned
count2 : mediumint(8) unsigned
count3 : mediumint(8) unsigned

v		rathena_db sales
nameid : int(10) unsigned
start : datetime
end : datetime
amount : int(11)

v		rathena_db sc_data
account_id : int(11) unsigned
char_id : int(11) unsigned
type : smallint(11) unsigned
tick : bigint(20)
val1 : int(11)
val2 : int(11)
val3 : int(11)
val4 : int(11)

v		rathena_db skill
char_id : int(11) unsigned
id : smallint(11) unsigned
lv : tinyint(4) unsigned
flag : tinyint(1) unsigned

v		rathena_db skillcooldown
account_id : int(11) unsigned
char_id : int(11) unsigned
skill : smallint(11) unsigned
tick : bigint(20)

v		rathena_db skillcooldown_homunculus
homun_id : int(11)
skill : smallint(11) unsigned
tick : bigint(20)

v		rathena_db skillcooldown_mercenary
mer_id : int(11) unsigned
skill : smallint(11) unsigned
tick : bigint(20)

v		rathena_db skill_homunculus
homun_id : int(11)
id : int(11)
lv : smallint(6)

v		rathena_db storage
id : int(11) unsigned
account_id : int(11) unsigned
nameid : int(10) unsigned
amount : smallint(11) unsigned
equip : int(11) unsigned
identify : smallint(6) unsigned
refine : tinyint(3) unsigned
attribute : tinyint(4) unsigned
card0 : int(10) unsigned
card1 : int(10) unsigned
card2 : int(10) unsigned
card3 : int(10) unsigned
option_id0 : smallint(5)
option_val0 : smallint(5)
option_parm0 : tinyint(3)
option_id1 : smallint(5)
option_val1 : smallint(5)
option_parm1 : tinyint(3)
option_id2 : smallint(5)
option_val2 : smallint(5)
option_parm2 : tinyint(3)
option_id3 : smallint(5)
option_val3 : smallint(5)
option_parm3 : tinyint(3)
option_id4 : smallint(5)
option_val4 : smallint(5)
option_parm4 : tinyint(3)
expire_time : int(11) unsigned
bound : tinyint(3) unsigned
unique_id : bigint(20) unsigned
enchantgrade : tinyint(3) unsigned

v		rathena_db vendings
id : int(10) unsigned
account_id : int(11) unsigned
char_id : int(10) unsigned
sex : enum('F','M')
map : varchar(20)
x : smallint(5) unsigned
y : smallint(5) unsigned
title : varchar(80)
body_direction : char(1)
head_direction : char(1)
sit : char(1)
autotrade : tinyint(4)

v		rathena_db vending_items
vending_id : int(10) unsigned
index : smallint(5) unsigned
cartinventory_id : int(10) unsigned
amount : smallint(5) unsigned
price : int(10) unsigned

Create relationship
FOREIGN KEY
on delete
on update