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 :

Table structure

Settings for the table structure (list of columns).

Table structure

Default transformations
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 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.

mob_db2_re

#	Name	Type	Collation	Attributes	Null	Default	Action
1	id	int(11)		UNSIGNED	No	None	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
2	name_aegis	varchar(24)	utf8mb4_general_ci		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
3	name_english	text	utf8mb4_general_ci		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
4	name_japanese	text	utf8mb4_general_ci		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
5	level	smallint(6)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
6	hp	int(11)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
7	sp	mediumint(9)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
8	base_exp	int(11)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
9	job_exp	int(11)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
10	mvp_exp	int(11)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
11	attack	smallint(6)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
12	attack2	smallint(6)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
13	defense	smallint(6)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
14	magic_defense	smallint(6)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
15	resistance	smallint(6)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
16	magic_resistance	smallint(6)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
17	str	smallint(6)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
18	agi	smallint(6)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
19	vit	smallint(6)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
20	int	smallint(6)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
21	dex	smallint(6)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
22	luk	smallint(6)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
23	attack_range	tinyint(4)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
24	skill_range	tinyint(4)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
25	chase_range	tinyint(4)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
26	size	varchar(24)	utf8mb4_general_ci		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
27	race	varchar(24)	utf8mb4_general_ci		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
28	racegroup_goblin	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
29	racegroup_kobold	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
30	racegroup_orc	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
31	racegroup_golem	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
32	racegroup_guardian	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
33	racegroup_ninja	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
34	racegroup_gvg	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
35	racegroup_battlefield	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
36	racegroup_treasure	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
37	racegroup_biolab	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
38	racegroup_manuk	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
39	racegroup_splendide	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
40	racegroup_scaraba	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
41	racegroup_ogh_atk_def	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
42	racegroup_ogh_hidden	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
43	racegroup_bio5_swordman_thief	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
44	racegroup_bio5_acolyte_merchant	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
45	racegroup_bio5_mage_archer	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
46	racegroup_bio5_mvp	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
47	racegroup_clocktower	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
48	racegroup_thanatos	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
49	racegroup_faceworm	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
50	racegroup_hearthunter	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
51	racegroup_rockridge	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
52	racegroup_werner_lab	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
53	racegroup_temple_demon	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
54	racegroup_illusion_vampire	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
55	racegroup_malangdo	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
56	racegroup_ep172alpha	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
57	racegroup_ep172beta	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
58	racegroup_ep172bath	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
59	racegroup_illusion_turtle	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
60	racegroup_rachel_sanctuary	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
61	racegroup_illusion_luanda	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
62	racegroup_illusion_frozen	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
63	racegroup_illusion_moonlight	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
64	racegroup_ep16_def	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
65	racegroup_edda_arunafeltz	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
66	racegroup_lasagna	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
67	racegroup_glast_heim_abyss	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
68	racegroup_destroyed_valkyrie_realm	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
69	racegroup_encroached_gephenia	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
70	element	varchar(24)	utf8mb4_general_ci		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
71	element_level	tinyint(4)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
72	walk_speed	smallint(6)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
73	attack_delay	smallint(6)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
74	attack_motion	smallint(6)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
75	damage_motion	smallint(6)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
76	damage_taken	smallint(6)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
77	groupid	smallint(6)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
78	title	text	utf8mb4_general_ci		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
79	ai	varchar(50)	utf8mb4_general_ci		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
80	class	varchar(50)	utf8mb4_general_ci		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
81	mode_canmove	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
82	mode_looter	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
83	mode_aggressive	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
84	mode_assist	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
85	mode_castsensoridle	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
86	mode_norandomwalk	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
87	mode_nocast	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
88	mode_canattack	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
89	mode_castsensorchase	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
90	mode_changechase	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
91	mode_angry	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
92	mode_changetargetmelee	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
93	mode_changetargetchase	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
94	mode_targetweak	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
95	mode_randomtarget	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
96	mode_ignoremelee	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
97	mode_ignoremagic	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
98	mode_ignoreranged	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
99	mode_mvp	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
100	mode_ignoremisc	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
101	mode_knockbackimmune	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
102	mode_teleportblock	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
103	mode_fixeditemdrop	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
104	mode_detector	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
105	mode_statusimmune	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
106	mode_skillimmune	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
107	mvpdrop1_item	varchar(50)	utf8mb4_general_ci		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
108	mvpdrop1_rate	smallint(9)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
109	mvpdrop1_option	varchar(50)	utf8mb4_general_ci		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
110	mvpdrop1_index	tinyint(2)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
111	mvpdrop2_item	varchar(50)	utf8mb4_general_ci		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
112	mvpdrop2_rate	smallint(9)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
113	mvpdrop2_option	varchar(50)	utf8mb4_general_ci		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
114	mvpdrop2_index	tinyint(2)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
115	mvpdrop3_item	varchar(50)	utf8mb4_general_ci		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
116	mvpdrop3_rate	smallint(9)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
117	mvpdrop3_option	varchar(50)	utf8mb4_general_ci		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
118	mvpdrop3_index	tinyint(2)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
119	drop1_item	varchar(50)	utf8mb4_general_ci		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
120	drop1_rate	smallint(9)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
121	drop1_nosteal	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
122	drop1_option	varchar(50)	utf8mb4_general_ci		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
123	drop1_index	tinyint(2)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
124	drop2_item	varchar(50)	utf8mb4_general_ci		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
125	drop2_rate	smallint(9)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
126	drop2_nosteal	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
127	drop2_option	varchar(50)	utf8mb4_general_ci		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
128	drop2_index	tinyint(2)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
129	drop3_item	varchar(50)	utf8mb4_general_ci		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
130	drop3_rate	smallint(9)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
131	drop3_nosteal	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
132	drop3_option	varchar(50)	utf8mb4_general_ci		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
133	drop3_index	tinyint(2)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
134	drop4_item	varchar(50)	utf8mb4_general_ci		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
135	drop4_rate	smallint(9)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
136	drop4_nosteal	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
137	drop4_option	varchar(50)	utf8mb4_general_ci		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
138	drop4_index	tinyint(2)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
139	drop5_item	varchar(50)	utf8mb4_general_ci		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
140	drop5_rate	smallint(9)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
141	drop5_nosteal	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
142	drop5_option	varchar(50)	utf8mb4_general_ci		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
143	drop5_index	tinyint(2)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
144	drop6_item	varchar(50)	utf8mb4_general_ci		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
145	drop6_rate	smallint(9)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
146	drop6_nosteal	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
147	drop6_option	varchar(50)	utf8mb4_general_ci		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
148	drop6_index	tinyint(2)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
149	drop7_item	varchar(50)	utf8mb4_general_ci		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
150	drop7_rate	smallint(9)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
151	drop7_nosteal	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
152	drop7_option	varchar(50)	utf8mb4_general_ci		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
153	drop7_index	tinyint(2)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
154	drop8_item	varchar(50)	utf8mb4_general_ci		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
155	drop8_rate	smallint(9)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
156	drop8_nosteal	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
157	drop8_option	varchar(50)	utf8mb4_general_ci		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
158	drop8_index	tinyint(2)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
159	drop9_item	varchar(50)	utf8mb4_general_ci		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
160	drop9_rate	smallint(9)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
161	drop9_nosteal	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
162	drop9_option	varchar(50)	utf8mb4_general_ci		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
163	drop9_index	tinyint(2)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
164	drop10_item	varchar(50)	utf8mb4_general_ci		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
165	drop10_rate	smallint(9)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
166	drop10_nosteal	tinyint(1)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
167	drop10_option	varchar(50)	utf8mb4_general_ci		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
168	drop10_index	tinyint(2)		UNSIGNED	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns

Check all With selected:

Propose table structure

Track table

Move columns

Normalize

Add column(s)

Indexes

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		A	Yes

Partitions

No partitioning defined!

Information

Space usage
Optimize table
Data	0	B
Index	2.0	KiB
Overhead	0	B
Effective	2.0	KiB
Total	2.0	KiB

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 08:27 AM