converter.dvl.to / mysql / admin2can-magelan

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		admin2can-magelan acl_role
id : int(10) unsigned
name : varchar(20)
descr : varchar(200)

v		admin2can-magelan applications
id : int(10) unsigned
name : varchar(50)
date : datetime
is_available : tinyint(1) unsigned

v		admin2can-magelan app_listener
id : int(10) unsigned
app_id : int(10) unsigned
base_id : int(10) unsigned
is_available : int(2) unsigned

v		admin2can-magelan app_params
id : int(10) unsigned
app_id : int(10) unsigned
name : varchar(50)
type : tinyint(1)
def_value : varchar(100)

v		admin2can-magelan app_par_values
app_id : int(10)
base_id : int(10)
param_id : int(10)
value : varchar(100)

v		admin2can-magelan acl_roles_users
user_id : int(10) unsigned
role_id : tinyint(2) unsigned

v		admin2can-magelan app_temp
id : bigint(10) unsigned
identity : varchar(50)
value : text
app_id : int(10) unsigned

v		admin2can-magelan bases
id : int(10) unsigned
name : varchar(100)
users_id : bigint(10) unsigned
date : datetime
auth_params : text
isWizard : tinyint(4)
subdomain : varchar(100)
phone : varchar(20)
config_id : int(11)
date_start : datetime
date_expiration : datetime
is_available : tinyint(1)
locale : varchar(5)
id2can : bigint(10)
is_test : tinyint(1) unsigned
tarif_id : int(11)
phone_country : varchar(2)
tariff_period : int(11)
is_enterprise : tinyint(3) unsigned
old_tarif_id : int(10) unsigned
promo : varchar(50)
is_api : tinyint(3) unsigned
sign_up_step : int(11)
log_level : tinyint(1)
is_validate_email : tinyint(3) unsigned

v		admin2can-magelan bases_active
bases_id : bigint(10) unsigned
date : datetime

v		admin2can-magelan bases_details
bases_id : int(10) unsigned
norg : varchar(200)
uname : varchar(100)
requisites : text
timezone : varchar(100)
currency : varchar(100)
count_staff : int(11)
count_shops : int(11)

v		admin2can-magelan bases_events
id : bigint(20) unsigned
id_base : int(11)
id_user : int(11)
event : varchar(50)
date : timestamp
data : text

v		admin2can-magelan bases_settings
bases_id : int(11)
setting_name : varchar(255)
setting_value : varchar(255)

v		admin2can-magelan country
country_code : char(2)
country_name : varchar(45)

v		admin2can-magelan devices
id : bigint(10) unsigned
activation_code : varchar(8)
bases_id : int(10) unsigned
spd_id : int(10) unsigned
dtz : date
timz : varchar(10)
is_available : int(10)
date_act : datetime

v		admin2can-magelan insales_categories
PID : int(10) unsigned
id : int(10) unsigned
parent_id : int(10) unsigned
position : int(10) unsigned
title : varchar(200)
base_id : int(10) unsigned
smcur_id : bigint(10) unsigned
smcgr_id : bigint(10) unsigned

v		admin2can-magelan report_api_keys
id : int(10) unsigned
api_report_public_key : varchar(32)
api_report_private_key : varchar(32)
date_expiration : datetime
date_add : datetime

v		admin2can-magelan tbl_migration
version : varchar(255)
apply_time : int(11)

v		admin2can-magelan timezone
zone_id : int(10)
abbreviation : varchar(6)
time_start : int(11)
gmt_offset : int(11)
dst : char(1)

v		admin2can-magelan insales_option
PID : int(10) unsigned
id : int(10) unsigned
position : int(10) unsigned
title : varchar(200)
base_id : int(10) unsigned
smcur_id : bigint(10) unsigned
smcgr_id : bigint(10) unsigned

v		admin2can-magelan insales_option_value
PID : int(10) unsigned
id : int(10) unsigned
position : int(10) unsigned
option_name_id : int(10) unsigned
title : varchar(200)
base_id : int(10) unsigned
smcur_id : bigint(10) unsigned
smcgr_id : bigint(10) unsigned

v		admin2can-magelan insales_params
PID : int(10) unsigned
id : int(10) unsigned
backoffice : tinyint(1)
is_hidden : tinyint(1)
is_navigational : tinyint(1)
permalink : varchar(150)
position : int(10)
title : varchar(150)
base_id : int(10) unsigned
spar_id : bigint(10) unsigned

v		admin2can-magelan insales_params_value
PID : bigint(10) unsigned
id : int(10) unsigned
property_id : int(10) unsigned
title : varchar(200)
base_id : int(10) unsigned
spar_id : bigint(10) unsigned

v		admin2can-magelan insales_product
PID : int(10) unsigned
id : int(10) unsigned
base_id : int(10) unsigned
snon_id : bigint(10) unsigned

v		admin2can-magelan insales_unit
PID : int(10) unsigned
name : varchar(100)
name_ru : varchar(100)
base_id : int(10) unsigned
seizm_id : bigint(10) unsigned

v		admin2can-magelan insales_variants
PID : int(10) unsigned
id : int(10) unsigned
base_id : int(10) unsigned
msus_id : bigint(10) unsigned

v		admin2can-magelan merchant_rebill
id : int(11)
bases_id : int(11)
boxplat_id : varchar(128)
amount : double
days : int(11)
date_create : timestamp
date_update : timestamp
tarif_id : int(10) unsigned
mc_id : bigint(20) unsigned
type : varchar(30)

v		admin2can-magelan payment
id : bigint(10)
date : datetime
body : text

v		admin2can-magelan payment_success
id : bigint(10) unsigned
order_id : varchar(50)
date : datetime

SQL upload ( 0 ) x -

v		admin2can-magelan push
id : bigint(10) unsigned
base_id : int(10) unsigned
dtz : date
timz : varchar(10)
status : int(2) unsigned
type : int(10) unsigned
method : varchar(10)
PID : int(10) unsigned

v		admin2can-magelan repository
id : int(10) unsigned
date : datetime
log : longtext
release : tinyint(1) unsigned
ver : varchar(20)
type : tinyint(2)

v		admin2can-magelan service_stack
id : bigint(10) unsigned
body : text
bases_id : int(10) unsigned
sdate : timestamp
is_del : tinyint(1)
response : text

v		admin2can-magelan user
user_id : int(10) unsigned
username : varchar(255)
email : varchar(255)
display_name : varchar(50)
password : varchar(128)
state : smallint(5) unsigned
phone : varchar(100)
date_start : datetime
date_expiration : datetime
locale : varchar(5)

v		admin2can-magelan users_bases
id : int(10) unsigned
users_id : bigint(10) unsigned
bases_id : int(10) unsigned
date : datetime

v		admin2can-magelan user_params
id : int(10) unsigned
user_id : int(10) unsigned
param_name : varchar(50)
param_value : varchar(100)

v		admin2can-magelan user_provider
user_id : int(10) unsigned
provider_id : varchar(50)
provider : varchar(255)

v		admin2can-magelan user_token
id : bigint(10) unsigned
users_id : int(10) unsigned
ticket : varchar(200)
token : varchar(200)
expires : datetime
device_id : varchar(100)
spd_id : int(10) unsigned

v		admin2can-magelan zone
zone_id : int(10)
country_code : char(2)
zone_name : varchar(35)