converter.dvl.to / mysql / snail

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.

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.

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.

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

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

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

v		snail cabinet
id : int(11)
owner_id : int(11)
date_create : timestamp
date_update : timestamp
cabinet_name : varchar(255)

v		snail card_codes
id : bigint(20)
code : bigint(20)
date_create : timestamp
date_update : timestamp
card_type : int(11)

v		snail catalog
id : int(11)
product_id : int(11)
users_id : int(11)
date_update : timestamp
date_create : timestamp
count_product : int(11)
price_in : decimal(10,0)
descr : varchar(500)

v		snail content
id : bigint(20) unsigned
type : bigint(20) unsigned
title : varchar(255)
body : text
date_create : timestamp
date_update : timestamp
cabinet_id : int(11)
users_id : int(11)

v		snail content_type
id : bigint(20) unsigned
title : varchar(255)
date_create : timestamp
date_update : timestamp

v		snail country
country_code : char(2)
country_name : varchar(45)
format_date : varchar(20)
format_time : varchar(20)

v		snail managers
users_id : int(11)
is_active : bigint(20)
date_create : timestamp
date_update : timestamp

v		snail measure
id : bigint(20)
measure_name : varchar(15)
measure_name_short : varchar(5)
okei : varchar(3)
fraction_digits_number : int(10) unsigned
date_create : timestamp
date_update : timestamp

v		snail merchants
users_id : int(11)
cabinet_id : int(11)
date_create : timestamp
date_update : timestamp

v		snail my_pages
user_id : int(11)
pages_id : bigint(20)
roles_id : int(11)
date_update : timestamp
date_create : timestamp

v		snail oauth_access_tokens
access_token : varchar(40)
client_id : varchar(80)
user_id : varchar(255)
expires : timestamp
scope : varchar(2000)

v		snail oauth_authorization_codes
authorization_code : varchar(40)
client_id : varchar(80)
user_id : varchar(255)
redirect_uri : varchar(2000)
expires : timestamp
scope : varchar(2000)
id_token : varchar(2000)

v		snail oauth_clients
client_id : varchar(80)
client_secret : varchar(80)
redirect_uri : varchar(2000)
grant_types : varchar(80)
scope : varchar(2000)
user_id : varchar(255)

v		snail oauth_jwt
client_id : varchar(80)
subject : varchar(80)
public_key : varchar(2000)

v		snail oauth_refresh_tokens
refresh_token : varchar(40)
client_id : varchar(80)
user_id : varchar(255)
expires : timestamp
scope : varchar(2000)

v		snail oauth_users
username : varchar(255)
password : varchar(2000)
first_name : varchar(255)
last_name : varchar(255)

v		snail oauth_scopes
type : varchar(255)
scope : varchar(2000)
client_id : varchar(80)
is_default : smallint(6)

v		snail pages
id : bigint(20)
owner_id : int(11)
date_create : timestamp
date_update : timestamp
page_address : varchar(200)
page_title : varchar(80)
page_description : varchar(255)
page_preview : varchar(255)
page_name : varchar(100)
page_photo : varchar(255)
page_cover : text
page_background : text
page_background_color : varchar(255)
page_font : varchar(255)
page_font_color : varchar(255)
page_tagline : varchar(255)
page_cover_color : varchar(255)
page_type : int(11)
page_email : varchar(200)
page_phone : varchar(255)

v		snail pages_block
id : bigint(20) unsigned
block_type : int(10) unsigned
pages_id : bigint(20)
block_title : varchar(80)
block_description : text
date_create : timestamp
date_update : timestamp
block_position : int(11)
block_url : varchar(255)
block_url_text : varchar(100)
block_image : varchar(255)
image_type : int(11)

v		snail pages_block_image
id : bigint(20) unsigned
block_id : bigint(20) unsigned
block_image_url : varchar(255)
date_create : timestamp
date_update : timestamp

v		snail pages_block_items
id : bigint(20) unsigned
block_id : bigint(20) unsigned
item_title : varchar(100)
item_description : text
item_price : double
date_create : timestamp
date_update : timestamp
item_discount_price : double
item_units : bigint(20)
item_units_display : int(11)

v		snail pages_block_items_image
id : bigint(20) unsigned
items_id : bigint(20) unsigned
image_url : varchar(255)
date_create : timestamp
date_update : timestamp

v		snail pages_block_items_url
id : bigint(20) unsigned
items_id : bigint(20) unsigned
url : varchar(255)
url_text : varchar(255)
date_create : timestamp
date_update : timestamp

v		snail pages_block_link
id : bigint(20) unsigned
block_id : bigint(20) unsigned
block_link : varchar(255)
block_link_text : varchar(100)
block_link_type : int(10) unsigned
date_create : timestamp
date_update : timestamp

v		snail pages_block_settings
id : bigint(20) unsigned
block_type : int(10) unsigned
name : varchar(255)
setting_type : int(11)
date_create : timestamp
date_update : timestamp

v		snail pages_block_settings_value
block_id : bigint(20) unsigned
settings_id : bigint(20) unsigned
settings_value : varchar(255)
date_create : timestamp
date_update : timestamp

SQL upload ( 0 ) x -

v		snail pages_block_type
id : int(10) unsigned
name : varchar(100)
date_create : timestamp
date_update : timestamp

v		snail pages_social_link
id : bigint(20) unsigned
pages_id : bigint(20)
social_link : varchar(255)
date_update : datetime
date_create : timestamp
link_position : int(11)

v		snail product
id : int(11)
product_name : varchar(255)
date_create : timestamp
date_update : timestamp
cabinet_id : int(11)

v		snail roles
id : int(11)
role_name : varchar(100)
date_create : timestamp
date_update : timestamp

v		snail users
user_id : int(11)
username : varchar(255)
email : varchar(255)
date_update : timestamp
date_create : timestamp
password : varchar(255)
display_name : varchar(50)
state : smallint(5) unsigned
display_name2 : varchar(50)
country_code : char(2)

v		snail users_card
id : bigint(20)
key : bigint(20)
date_create : timestamp
date_update : timestamp
users_id : int(11)
pages_id : bigint(20)
card_type : int(11)
page_address : varchar(2083)

v		snail users_params
id : int(11)
users_params_name : varchar(255)
date_create : timestamp
date_update : timestamp

v		snail users_params_value
users_id : int(11)
users_params_id : int(11)
users_params_value : varchar(255)
date_create : timestamp
date_update : timestamp