Recent
`rathena_db`.`mob_db_re`
`mysql`.`index_stats`
`phpmyadmin`.`pma__designer_settings`
`mysql`.`roles_mapping`
`mysql`.`servers`
`performance_schema`.`session_account_connect_attrs`
`rathena_web`.`user_configs`
`information_schema`.`INNODB_SYS_INDEXES`
`information_schema`.`USER_PRIVILEGES`
`rathena_db`.`cp_txnlog`
Favorites
There are no favorite tables.
New
information_schema
mysql
performance_schema
phpmyadmin
rathena
rathena_db
rathena_log
rathena_web
test
Navigation panel
Navigation tree
Servers
Databases
Tables
Navigation panel
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
).
main
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.
Navigation tree
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
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
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
Tables display options.
Tables
Target for quick access icon
Structure
SQL
Search
Insert
Browse
Target for second quick access icon
Structure
SQL
Search
Insert
Browse
Table tree separator
String that separates tables into different tree levels.
Maximum table tree depth
Drop files here
SQL upload (
0
)
x
-
Show hidden navigation tree items.
Create view
Javascript must be enabled past this point!
Server: 127.0.0.1
Database: rathena_db
Table: mob_db_re
Browse
Structure
(current)
SQL
Search
Insert
Export
Import
Privileges
Operations
Tracking
Triggers
Console
Clear
History
Options
Bookmarks
Debug SQL
Press Ctrl+Enter to execute query
Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse
Expand
Show trace
Hide trace
Count :
Time taken :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Label:
Target database:
Share this bookmark
OK
Options
Set default
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 :
Loading
ENUM/SET editor
Create view
Table structure
Table structure
Settings for the table structure (list of columns).
Table structure
Hide table structure actions
Whether the table structure actions should be hidden.
Show column comments
Whether column comments should be shown in table structure view
Default transformations
Default transformations for Hex
Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
2
Default transformations for Substring
Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
0 all …
Default transformations for Bool2Text
Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
T F
Default transformations for External
Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
0 -f /dev/null -i -wrap -q 1 1
Default transformations for PreApPend
Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
Default transformations for DateFormat
Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
0 local
Default transformations for Inline
Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
100 100
Default transformations for TextImageLink
Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
100 50
Default transformations for TextLink
Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
Table structure
Relation view
mob_db_re
#
Name
Type
Collation
Attributes
Null
Default
Comments
Extra
Action
1
id
int(11)
UNSIGNED
No
None
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
2
name_aegis
varchar(24)
utf8mb4_general_ci
No
None
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
3
name_english
text
utf8mb4_general_ci
No
None
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
4
name_japanese
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
5
level
smallint(6)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
6
hp
int(11)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
7
sp
mediumint(9)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
8
base_exp
int(11)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
9
job_exp
int(11)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
10
mvp_exp
int(11)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
11
attack
smallint(6)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
12
attack2
smallint(6)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
13
defense
smallint(6)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
14
magic_defense
smallint(6)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
15
resistance
smallint(6)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
16
magic_resistance
smallint(6)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
17
str
smallint(6)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
18
agi
smallint(6)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
19
vit
smallint(6)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
20
int
smallint(6)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
21
dex
smallint(6)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
22
luk
smallint(6)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
23
attack_range
tinyint(4)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
24
skill_range
tinyint(4)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
25
chase_range
tinyint(4)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
26
size
varchar(24)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
27
race
varchar(24)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
28
racegroup_goblin
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
29
racegroup_kobold
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
30
racegroup_orc
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
31
racegroup_golem
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
32
racegroup_guardian
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
33
racegroup_ninja
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
34
racegroup_gvg
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
35
racegroup_battlefield
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
36
racegroup_treasure
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
37
racegroup_biolab
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
38
racegroup_manuk
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
39
racegroup_splendide
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
40
racegroup_scaraba
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
41
racegroup_ogh_atk_def
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
42
racegroup_ogh_hidden
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
43
racegroup_bio5_swordman_thief
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
44
racegroup_bio5_acolyte_merchant
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
45
racegroup_bio5_mage_archer
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
46
racegroup_bio5_mvp
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
47
racegroup_clocktower
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
48
racegroup_thanatos
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
49
racegroup_faceworm
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
50
racegroup_hearthunter
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
51
racegroup_rockridge
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
52
racegroup_werner_lab
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
53
racegroup_temple_demon
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
54
racegroup_illusion_vampire
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
55
racegroup_malangdo
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
56
racegroup_ep172alpha
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
57
racegroup_ep172beta
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
58
racegroup_ep172bath
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
59
racegroup_illusion_turtle
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
60
racegroup_rachel_sanctuary
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
61
racegroup_illusion_luanda
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
62
racegroup_illusion_frozen
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
63
racegroup_illusion_moonlight
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
64
racegroup_ep16_def
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
65
racegroup_edda_arunafeltz
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
66
racegroup_lasagna
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
67
racegroup_glast_heim_abyss
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
68
racegroup_destroyed_valkyrie_realm
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
69
racegroup_encroached_gephenia
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
70
element
varchar(24)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
71
element_level
tinyint(4)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
72
walk_speed
smallint(6)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
73
attack_delay
smallint(6)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
74
attack_motion
smallint(6)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
75
damage_motion
smallint(6)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
76
damage_taken
smallint(6)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
77
groupid
smallint(6)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
78
title
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
79
ai
varchar(2)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
80
class
varchar(50)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
81
mode_canmove
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
82
mode_looter
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
83
mode_aggressive
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
84
mode_assist
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
85
mode_castsensoridle
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
86
mode_norandomwalk
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
87
mode_nocast
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
88
mode_canattack
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
89
mode_castsensorchase
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
90
mode_changechase
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
91
mode_angry
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
92
mode_changetargetmelee
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
93
mode_changetargetchase
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
94
mode_targetweak
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
95
mode_randomtarget
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
96
mode_ignoremelee
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
97
mode_ignoremagic
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
98
mode_ignoreranged
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
99
mode_mvp
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
100
mode_ignoremisc
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
101
mode_knockbackimmune
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
102
mode_teleportblock
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
103
mode_fixeditemdrop
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
104
mode_detector
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
105
mode_statusimmune
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
106
mode_skillimmune
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
107
mvpdrop1_item
varchar(50)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
108
mvpdrop1_rate
smallint(9)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
109
mvpdrop1_option
varchar(50)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
110
mvpdrop1_index
tinyint(2)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
111
mvpdrop2_item
varchar(50)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
112
mvpdrop2_rate
smallint(9)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
113
mvpdrop2_option
varchar(50)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
114
mvpdrop2_index
tinyint(2)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
115
mvpdrop3_item
varchar(50)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
116
mvpdrop3_rate
smallint(9)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
117
mvpdrop3_option
varchar(50)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
118
mvpdrop3_index
tinyint(2)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
119
drop1_item
varchar(50)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
120
drop1_rate
smallint(9)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
121
drop1_nosteal
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
122
drop1_option
varchar(50)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
123
drop1_index
tinyint(2)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
124
drop2_item
varchar(50)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
125
drop2_rate
smallint(9)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
126
drop2_nosteal
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
127
drop2_option
varchar(50)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
128
drop2_index
tinyint(2)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
129
drop3_item
varchar(50)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
130
drop3_rate
smallint(9)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
131
drop3_nosteal
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
132
drop3_option
varchar(50)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
133
drop3_index
tinyint(2)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
134
drop4_item
varchar(50)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
135
drop4_rate
smallint(9)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
136
drop4_nosteal
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
137
drop4_option
varchar(50)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
138
drop4_index
tinyint(2)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
139
drop5_item
varchar(50)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
140
drop5_rate
smallint(9)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
141
drop5_nosteal
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
142
drop5_option
varchar(50)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
143
drop5_index
tinyint(2)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
144
drop6_item
varchar(50)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
145
drop6_rate
smallint(9)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
146
drop6_nosteal
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
147
drop6_option
varchar(50)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
148
drop6_index
tinyint(2)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
149
drop7_item
varchar(50)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
150
drop7_rate
smallint(9)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
151
drop7_nosteal
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
152
drop7_option
varchar(50)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
153
drop7_index
tinyint(2)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
154
drop8_item
varchar(50)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
155
drop8_rate
smallint(9)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
156
drop8_nosteal
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
157
drop8_option
varchar(50)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
158
drop8_index
tinyint(2)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
159
drop9_item
varchar(50)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
160
drop9_rate
smallint(9)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
161
drop9_nosteal
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
162
drop9_option
varchar(50)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
163
drop9_index
tinyint(2)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
164
drop10_item
varchar(50)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
165
drop10_rate
smallint(9)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
166
drop10_nosteal
tinyint(1)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
167
drop10_option
varchar(50)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
168
drop10_index
tinyint(2)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
Check all
With selected:
Browse
Change
Drop
Primary
Unique
Index
Spatial
Fulltext
Add to central columns
Remove from central columns
Move columns
Move the columns by dragging them up and down.
Preview SQL
Loading…
Error
Print
Propose table structure
Track table
Move columns
Normalize
Add
column(s)
at beginning of table
after id
after name_aegis
after name_english
after name_japanese
after level
after hp
after sp
after base_exp
after job_exp
after mvp_exp
after attack
after attack2
after defense
after magic_defense
after resistance
after magic_resistance
after str
after agi
after vit
after int
after dex
after luk
after attack_range
after skill_range
after chase_range
after size
after race
after racegroup_goblin
after racegroup_kobold
after racegroup_orc
after racegroup_golem
after racegroup_guardian
after racegroup_ninja
after racegroup_gvg
after racegroup_battlefield
after racegroup_treasure
after racegroup_biolab
after racegroup_manuk
after racegroup_splendide
after racegroup_scaraba
after racegroup_ogh_atk_def
after racegroup_ogh_hidden
after racegroup_bio5_swordman_thief
after racegroup_bio5_acolyte_merchant
after racegroup_bio5_mage_archer
after racegroup_bio5_mvp
after racegroup_clocktower
after racegroup_thanatos
after racegroup_faceworm
after racegroup_hearthunter
after racegroup_rockridge
after racegroup_werner_lab
after racegroup_temple_demon
after racegroup_illusion_vampire
after racegroup_malangdo
after racegroup_ep172alpha
after racegroup_ep172beta
after racegroup_ep172bath
after racegroup_illusion_turtle
after racegroup_rachel_sanctuary
after racegroup_illusion_luanda
after racegroup_illusion_frozen
after racegroup_illusion_moonlight
after racegroup_ep16_def
after racegroup_edda_arunafeltz
after racegroup_lasagna
after racegroup_glast_heim_abyss
after racegroup_destroyed_valkyrie_realm
after racegroup_encroached_gephenia
after element
after element_level
after walk_speed
after attack_delay
after attack_motion
after damage_motion
after damage_taken
after groupid
after title
after ai
after class
after mode_canmove
after mode_looter
after mode_aggressive
after mode_assist
after mode_castsensoridle
after mode_norandomwalk
after mode_nocast
after mode_canattack
after mode_castsensorchase
after mode_changechase
after mode_angry
after mode_changetargetmelee
after mode_changetargetchase
after mode_targetweak
after mode_randomtarget
after mode_ignoremelee
after mode_ignoremagic
after mode_ignoreranged
after mode_mvp
after mode_ignoremisc
after mode_knockbackimmune
after mode_teleportblock
after mode_fixeditemdrop
after mode_detector
after mode_statusimmune
after mode_skillimmune
after mvpdrop1_item
after mvpdrop1_rate
after mvpdrop1_option
after mvpdrop1_index
after mvpdrop2_item
after mvpdrop2_rate
after mvpdrop2_option
after mvpdrop2_index
after mvpdrop3_item
after mvpdrop3_rate
after mvpdrop3_option
after mvpdrop3_index
after drop1_item
after drop1_rate
after drop1_nosteal
after drop1_option
after drop1_index
after drop2_item
after drop2_rate
after drop2_nosteal
after drop2_option
after drop2_index
after drop3_item
after drop3_rate
after drop3_nosteal
after drop3_option
after drop3_index
after drop4_item
after drop4_rate
after drop4_nosteal
after drop4_option
after drop4_index
after drop5_item
after drop5_rate
after drop5_nosteal
after drop5_option
after drop5_index
after drop6_item
after drop6_rate
after drop6_nosteal
after drop6_option
after drop6_index
after drop7_item
after drop7_rate
after drop7_nosteal
after drop7_option
after drop7_index
after drop8_item
after drop8_rate
after drop8_nosteal
after drop8_option
after drop8_index
after drop9_item
after drop9_rate
after drop9_nosteal
after drop9_option
after drop9_index
after drop10_item
after drop10_rate
after drop10_nosteal
after drop10_option
after drop10_index
Indexes
Loading
Action
Keyname
Type
Unique
Packed
Column
Cardinality
Collation
Null
Comment
Edit
Rename
Drop
PRIMARY
BTREE
Yes
No
id
0
A
No
Edit
Rename
Drop
name_aegis
BTREE
Yes
No
name_aegis
0
A
No
Create an index on
columns
Loading
Preview SQL
Loading…
Partitions
No partitioning defined!
Information
Space usage
Data
0
B
Index
2.0
KiB
Overhead
0
B
Effective
2.0
KiB
Total
2.0
KiB
Optimize table
Row statistics
Format
dynamic
Collation
utf8mb4_general_ci
Rows
0
Next autoindex
0
Creation
Aug 28, 2026 at 06:02 PM
Last update
Aug 28, 2026 at 06:02 PM
Last check
Aug 30, 2026 at 09:18 AM