Recent
`information_schema`.`INDEX_STATISTICS`
`information_schema`.`ROUTINES`
`phpmyadmin`.`pma__tracking`
`information_schema`.`TABLE_STATISTICS`
`performance_schema`.`cond_instances`
`information_schema`.`PLUGINS`
`mysql`.`table_stats`
`phpmyadmin`.`pma__relation`
`performance_schema`.`file_summary_by_instance`
`performance_schema`.`hosts`
Favorites
There are no favorite tables.
New
information_schema
memo_focus
mysql
performance_schema
phpmyadmin
test
vorpcore_92e946
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: vorpcore_92e946
Structure
SQL
Search
Query
(current)
Export
Import
Operations
Privileges
Routines
Events
Triggers
Tracking
Designer
Central columns
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
Multi-table query
Query by example
Query window
*
charidentifier
level
premium_unlocked
claimed
updated_at
*
code
steam
status
message
created_by
created_at
claimed_at
claimed_by
*
id
code
item
amount
claimed
created_at
claimed_at
*
id
group_id
level
charidentifier
item
amount
created_at
*
id
name
emblem
leader_charidentifier
status
fee_paid
fee_paid_at
level
exp
created_at
*
id
group_id
charidentifier
invited_by
role
status
created_at
responded_at
*
id
group_id
level
charidentifier
claimed_at
*
group_id
level
item
required_amount
current_amount
*
id
group_id
charidentifier
role
joined_at
*
id
group_id
level
charidentifier
item
amount
created_at
delivered_at
*
id
charidentifier
name
modelname
isDefault
*
id
identifier
charid
wagon_id
is_broken
reason
updated_at
*
identifier
charidentifier
day_key
active_json
progress_json
completed_json
completed_count
created_at
updated_at
*
id
identifier
npc_id
start_time
end_time
status
reward_data
*
charid
firstname
lastname
birthdate
age
birdcode
bloodtype
avatar
identifier
*
id
rent_id
character_id
item_name
item_crafted_id
expires_at
created_at
*
id
event_id
identifier
charidentifier
player_name
side
amount
payout
created_ts
*
id
event_date
start_ts
red_model
blue_model
red_preset
blue_preset
result
end_ts
*
id
last_event_date
*
code
label
created_at
expires_at
max_uses
uses
created_by
*
id
code
identifier
charidentifier
claimed_at
*
id
code
item
amount
*
charidentifier
identifier
group_id
group_size
claimed_at
*
id
leader_charidentifier
group_size
status
created_at
completed_at
cancelled_at
*
id
group_id
charidentifier
invited_by
status
created_at
responded_at
*
id
event
group_id
leader_charidentifier
actor_charidentifier
target_charidentifier
identifier
payload
created_at
*
group_id
charidentifier
status
invited_by
created_at
responded_at
*
identifier
active
wagon_id
cargo
rent_location
updated_at
*
identifier
bound_id
queue_points
airtime_left
created_at
rejoin_at
last_seen
last_hwids
ban_details
role
status
*
id
name
identifier
charidentifier
money
gold
items
invspace
*
license
name
time
reason
*
mailno
User
name
ganx
gany
time
*
idmsg
transmitter
receiver
message
name
isread
*
idcontact
identifier
number
display
*
plant_id
plant_coords
plant_type
plant_watered
time_left
plant_time
plant_owner
*
identifier
steamname
charidentifier
group
money
gold
rol
xp
healthouter
healthinner
staminaouter
staminainner
hours
LastLogin
inventory
slots
job
joblabel
meta
firstname
lastname
character_desc
gender
age
nickname
skinPlayer
compPlayer
compTints
jobgrade
coords
status
isdead
skills
walk
gunsmith
ammo
discordid
lastjoined
numbernok
*
character_id
inventory_type
item_crafted_id
item_name
amount
created_at
degradation
percentage
*
week_id
charidentifier
rank
claimed_at
*
id
week_id
started_at
ended_at
duration_seconds
bet
ranked
reason
winner_charidentifier
loser_charidentifier
winner_identifier
loser_identifier
*
week_id
charidentifier
opponent_charidentifier
*
week_id
char1
char2
ranked_matches
last_ranked_at
*
week_id
identifier
charidentifier
name
rating
ranked_matches
wins
losses
unique_opponents
last_match_at
*
identifier
charidentifier
location
*
identifier
charidentifier
complements
*
id
name
identifier
charidentifier
key
*
item
label
limit
can_remove
type
usable
id
groupId
metadata
desc
degradation
weight
*
id
character_id
item_id
item_name
updated_at
metadata
*
id
description
*
id
identifier
charidentifier
name
ammo
components
dirtlevel
mudlevel
conditionlevel
rustlevel
used
used2
dropped
comps
label
curr_inv
serial_number
custom_label
custom_desc
*
id
sender_id
sender_firstname
sender_lastname
receiver_id
receiver_firstname
receiver_lastname
message
opened
received_at
*
id
identifier
charidentifier
title
comps
compTints
*
id
identifier
animal_name
growth_stage
animal_number
created_at
model
selected
*
id
identifier
cutting_count
*
id
identifier
charid
selected
name
model
components
gender
xp
captured
born
health
stamina
writhe
dead
*
id
identifier
count
*
id
identifier
planing_count
*
id
name
identifier
charidentifier
key
*
id
name
model
price
created_at
*
id
identifier
charidentifier
name
modelname
type
status
xp
injured
gear
isDefault
inventory
*
identifier
group
warnings
banned
banneduntil
char
*
id
identifier
charid
selected
model
name
items
*
id
identifier
status
firstconnection
discordid
select table
ad_battlepass
ad_boxitem_codes
ad_boxitem_items
ad_caravan_contributions
ad_caravan_groups
ad_caravan_invites
ad_caravan_level_claims
ad_caravan_level_progress
ad_caravan_members
ad_caravan_pending_rewards
ad_cartshop_carts
ad_cartshop_wagon_state
ad_dailyquests
ad_helpjobnpc_jobs
ad_idcard
ad_itemsrent
ad_npcfightbet_bets
ad_npcfightbet_events
ad_npcfightbet_state
ad_redeem_codes
ad_redeem_code_claims
ad_redeem_code_items
ad_registergroups_claims
ad_registergroups_groups
ad_registergroups_invites
ad_registergroups_logs
ad_registergroups_members
ad_wagonhuntingrent
azael_playpass
bank_users
bans
barakmailpolice
barak_allcontact
barak_contact_nok
bcc_farming
characters
character_inventories
dualgun_claims
dualgun_matches
dualgun_opponents
dualgun_pair
dualgun_weekly
herbalists
horse_complements
housing
items
items_crafted
item_group
loadout
mailbox_mails
outfits
player_animals
player_cutting_counts
player_horses
player_mining_counts
player_planing_counts
rooms
shop_animals
stables
users
wagons
whitelist
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
ad_battlepass
ad_boxitem_codes
ad_boxitem_items
ad_caravan_contributions
ad_caravan_groups
ad_caravan_invites
ad_caravan_level_claims
ad_caravan_level_progress
ad_caravan_members
ad_caravan_pending_rewards
ad_cartshop_carts
ad_cartshop_wagon_state
ad_dailyquests
ad_helpjobnpc_jobs
ad_idcard
ad_itemsrent
ad_npcfightbet_bets
ad_npcfightbet_events
ad_npcfightbet_state
ad_redeem_codes
ad_redeem_code_claims
ad_redeem_code_items
ad_registergroups_claims
ad_registergroups_groups
ad_registergroups_invites
ad_registergroups_logs
ad_registergroups_members
ad_wagonhuntingrent
azael_playpass
bank_users
bans
barakmailpolice
barak_allcontact
barak_contact_nok
bcc_farming
characters
character_inventories
dualgun_claims
dualgun_matches
dualgun_opponents
dualgun_pair
dualgun_weekly
herbalists
horse_complements
housing
items
items_crafted
item_group
loadout
mailbox_mails
outfits
player_animals
player_cutting_counts
player_horses
player_mining_counts
player_planing_counts
rooms
shop_animals
stables
users
wagons
whitelist
.
select column
select table
ad_battlepass
ad_boxitem_codes
ad_boxitem_items
ad_caravan_contributions
ad_caravan_groups
ad_caravan_invites
ad_caravan_level_claims
ad_caravan_level_progress
ad_caravan_members
ad_caravan_pending_rewards
ad_cartshop_carts
ad_cartshop_wagon_state
ad_dailyquests
ad_helpjobnpc_jobs
ad_idcard
ad_itemsrent
ad_npcfightbet_bets
ad_npcfightbet_events
ad_npcfightbet_state
ad_redeem_codes
ad_redeem_code_claims
ad_redeem_code_items
ad_registergroups_claims
ad_registergroups_groups
ad_registergroups_invites
ad_registergroups_logs
ad_registergroups_members
ad_wagonhuntingrent
azael_playpass
bank_users
bans
barakmailpolice
barak_allcontact
barak_contact_nok
bcc_farming
characters
character_inventories
dualgun_claims
dualgun_matches
dualgun_opponents
dualgun_pair
dualgun_weekly
herbalists
horse_complements
housing
items
items_crafted
item_group
loadout
mailbox_mails
outfits
player_animals
player_cutting_counts
player_horses
player_mining_counts
player_planing_counts
rooms
shop_animals
stables
users
wagons
whitelist
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
ad_battlepass
ad_boxitem_codes
ad_boxitem_items
ad_caravan_contributions
ad_caravan_groups
ad_caravan_invites
ad_caravan_level_claims
ad_caravan_level_progress
ad_caravan_members
ad_caravan_pending_rewards
ad_cartshop_carts
ad_cartshop_wagon_state
ad_dailyquests
ad_helpjobnpc_jobs
ad_idcard
ad_itemsrent
ad_npcfightbet_bets
ad_npcfightbet_events
ad_npcfightbet_state
ad_redeem_codes
ad_redeem_code_claims
ad_redeem_code_items
ad_registergroups_claims
ad_registergroups_groups
ad_registergroups_invites
ad_registergroups_logs
ad_registergroups_members
ad_wagonhuntingrent
azael_playpass
bank_users
bans
barakmailpolice
barak_allcontact
barak_contact_nok
bcc_farming
characters
character_inventories
dualgun_claims
dualgun_matches
dualgun_opponents
dualgun_pair
dualgun_weekly
herbalists
horse_complements
housing
items
items_crafted
item_group
loadout
mailbox_mails
outfits
player_animals
player_cutting_counts
player_horses
player_mining_counts
player_planing_counts
rooms
shop_animals
stables
users
wagons
whitelist
.
select column
select table
ad_battlepass
ad_boxitem_codes
ad_boxitem_items
ad_caravan_contributions
ad_caravan_groups
ad_caravan_invites
ad_caravan_level_claims
ad_caravan_level_progress
ad_caravan_members
ad_caravan_pending_rewards
ad_cartshop_carts
ad_cartshop_wagon_state
ad_dailyquests
ad_helpjobnpc_jobs
ad_idcard
ad_itemsrent
ad_npcfightbet_bets
ad_npcfightbet_events
ad_npcfightbet_state
ad_redeem_codes
ad_redeem_code_claims
ad_redeem_code_items
ad_registergroups_claims
ad_registergroups_groups
ad_registergroups_invites
ad_registergroups_logs
ad_registergroups_members
ad_wagonhuntingrent
azael_playpass
bank_users
bans
barakmailpolice
barak_allcontact
barak_contact_nok
bcc_farming
characters
character_inventories
dualgun_claims
dualgun_matches
dualgun_opponents
dualgun_pair
dualgun_weekly
herbalists
horse_complements
housing
items
items_crafted
item_group
loadout
mailbox_mails
outfits
player_animals
player_cutting_counts
player_horses
player_mining_counts
player_planing_counts
rooms
shop_animals
stables
users
wagons
whitelist
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
ad_battlepass
ad_boxitem_codes
ad_boxitem_items
ad_caravan_contributions
ad_caravan_groups
ad_caravan_invites
ad_caravan_level_claims
ad_caravan_level_progress
ad_caravan_members
ad_caravan_pending_rewards
ad_cartshop_carts
ad_cartshop_wagon_state
ad_dailyquests
ad_helpjobnpc_jobs
ad_idcard
ad_itemsrent
ad_npcfightbet_bets
ad_npcfightbet_events
ad_npcfightbet_state
ad_redeem_codes
ad_redeem_code_claims
ad_redeem_code_items
ad_registergroups_claims
ad_registergroups_groups
ad_registergroups_invites
ad_registergroups_logs
ad_registergroups_members
ad_wagonhuntingrent
azael_playpass
bank_users
bans
barakmailpolice
barak_allcontact
barak_contact_nok
bcc_farming
characters
character_inventories
dualgun_claims
dualgun_matches
dualgun_opponents
dualgun_pair
dualgun_weekly
herbalists
horse_complements
housing
items
items_crafted
item_group
loadout
mailbox_mails
outfits
player_animals
player_cutting_counts
player_horses
player_mining_counts
player_planing_counts
rooms
shop_animals
stables
users
wagons
whitelist
.
select column
select table
ad_battlepass
ad_boxitem_codes
ad_boxitem_items
ad_caravan_contributions
ad_caravan_groups
ad_caravan_invites
ad_caravan_level_claims
ad_caravan_level_progress
ad_caravan_members
ad_caravan_pending_rewards
ad_cartshop_carts
ad_cartshop_wagon_state
ad_dailyquests
ad_helpjobnpc_jobs
ad_idcard
ad_itemsrent
ad_npcfightbet_bets
ad_npcfightbet_events
ad_npcfightbet_state
ad_redeem_codes
ad_redeem_code_claims
ad_redeem_code_items
ad_registergroups_claims
ad_registergroups_groups
ad_registergroups_invites
ad_registergroups_logs
ad_registergroups_members
ad_wagonhuntingrent
azael_playpass
bank_users
bans
barakmailpolice
barak_allcontact
barak_contact_nok
bcc_farming
characters
character_inventories
dualgun_claims
dualgun_matches
dualgun_opponents
dualgun_pair
dualgun_weekly
herbalists
horse_complements
housing
items
items_crafted
item_group
loadout
mailbox_mails
outfits
player_animals
player_cutting_counts
player_horses
player_mining_counts
player_planing_counts
rooms
shop_animals
stables
users
wagons
whitelist
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
ad_battlepass
ad_boxitem_codes
ad_boxitem_items
ad_caravan_contributions
ad_caravan_groups
ad_caravan_invites
ad_caravan_level_claims
ad_caravan_level_progress
ad_caravan_members
ad_caravan_pending_rewards
ad_cartshop_carts
ad_cartshop_wagon_state
ad_dailyquests
ad_helpjobnpc_jobs
ad_idcard
ad_itemsrent
ad_npcfightbet_bets
ad_npcfightbet_events
ad_npcfightbet_state
ad_redeem_codes
ad_redeem_code_claims
ad_redeem_code_items
ad_registergroups_claims
ad_registergroups_groups
ad_registergroups_invites
ad_registergroups_logs
ad_registergroups_members
ad_wagonhuntingrent
azael_playpass
bank_users
bans
barakmailpolice
barak_allcontact
barak_contact_nok
bcc_farming
characters
character_inventories
dualgun_claims
dualgun_matches
dualgun_opponents
dualgun_pair
dualgun_weekly
herbalists
horse_complements
housing
items
items_crafted
item_group
loadout
mailbox_mails
outfits
player_animals
player_cutting_counts
player_horses
player_mining_counts
player_planing_counts
rooms
shop_animals
stables
users
wagons
whitelist
.
select column