www.cabello.ws / localhost / cabecab4_web

There are no favorite tables.

New
aaa
- aaa
- aaa_fabricas_pruebas
abanq
- abanq_23
- abanq_23 experimental
articulos
autocompleta
azulejoscabello.com
- azulejoscabello.com
- azulejoscabello.com_tienda
azulejoscabello_com
book_sc
cabecab4
cabello-enterprises
- cabello-enterprises
- cabello-enterprises_exp
contabilidad
datatablesv03
durstone
eneboo
grespania
information_schema
intermediaria_online
jplist
keraben
letodms
letodms experimental
magazine
mydms
mydms experimental
mysql
pamesa_filter
performance_schema
php_producto
- php_producto
- php_producto_prueba
sys
tutorial
wordpress
- wordpress
- wordpress_desarrollo

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 :

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 Query failed Database : Queried time :

Untitled *

v		cabecab4_web hv3ex_assets
id : int unsigned
parent_id : int
lft : int
rgt : int
level : int unsigned
name : varchar(50)
title : varchar(100)
rules : varchar(5120)

v		cabecab4_web hv3ex_associations
id : varchar(50)
context : varchar(50)
key : char(32)

v		cabecab4_web hv3ex_banners
id : int
cid : int
type : int
name : varchar(255)
alias : varchar(255)
imptotal : int
impmade : int
clicks : int
clickurl : varchar(200)
state : tinyint
catid : int unsigned
description : text
custombannercode : varchar(2048)
sticky : tinyint unsigned
ordering : int
metakey : text
params : text
own_prefix : tinyint(1)
metakey_prefix : varchar(255)
purchase_type : tinyint
track_clicks : tinyint
track_impressions : tinyint
checked_out : int unsigned
checked_out_time : datetime
publish_up : datetime
publish_down : datetime
reset : datetime
created : datetime
language : char(7)

v		cabecab4_web hv3ex_banner_clients
id : int
name : varchar(255)
contact : varchar(255)
email : varchar(255)
extrainfo : text
state : tinyint
checked_out : int unsigned
checked_out_time : datetime
metakey : text
own_prefix : tinyint
metakey_prefix : varchar(255)
purchase_type : tinyint
track_clicks : tinyint
track_impressions : tinyint

v		cabecab4_web hv3ex_banner_tracks
track_date : datetime
track_type : int unsigned
banner_id : int unsigned
count : int unsigned

v		cabecab4_web hv3ex_categories
id : int
asset_id : int unsigned
parent_id : int unsigned
lft : int
rgt : int
level : int unsigned
path : varchar(255)
extension : varchar(50)
title : varchar(255)
alias : varchar(255)
note : varchar(255)
description : mediumtext
published : tinyint(1)
checked_out : int unsigned
checked_out_time : datetime
access : int unsigned
params : text
metadesc : varchar(1024)
metakey : varchar(1024)
metadata : varchar(2048)
created_user_id : int unsigned
created_time : datetime
modified_user_id : int unsigned
modified_time : datetime
hits : int unsigned
language : char(7)

v		cabecab4_web hv3ex_contact_details
id : int
name : varchar(255)
alias : varchar(255)
con_position : varchar(255)
address : text
suburb : varchar(100)
state : varchar(100)
country : varchar(100)
postcode : varchar(100)
telephone : varchar(255)
fax : varchar(255)
misc : mediumtext
image : varchar(255)
imagepos : varchar(20)
email_to : varchar(255)
default_con : tinyint unsigned
published : tinyint(1)
checked_out : int unsigned
checked_out_time : datetime
ordering : int
params : text
user_id : int
catid : int
access : int unsigned
mobile : varchar(255)
webpage : varchar(255)
sortname1 : varchar(255)
sortname2 : varchar(255)
sortname3 : varchar(255)
language : char(7)
created : datetime
created_by : int unsigned
created_by_alias : varchar(255)
modified : datetime
modified_by : int unsigned
metakey : text
metadesc : text
metadata : text
featured : tinyint unsigned
xreference : varchar(50)
publish_up : datetime
publish_down : datetime

v		cabecab4_web hv3ex_content
id : int unsigned
asset_id : int unsigned
title : varchar(255)
alias : varchar(255)
title_alias : varchar(255)
introtext : mediumtext
fulltext : mediumtext
state : tinyint
sectionid : int unsigned
mask : int unsigned
catid : int unsigned
created : datetime
created_by : int unsigned
created_by_alias : varchar(255)
modified : datetime
modified_by : int unsigned
checked_out : int unsigned
checked_out_time : datetime
publish_up : datetime
publish_down : datetime
images : text
urls : text
attribs : varchar(5120)
version : int unsigned
parentid : int unsigned
ordering : int
metakey : text
metadesc : text
access : int unsigned
hits : int unsigned
metadata : text
featured : tinyint unsigned
language : char(7)
xreference : varchar(50)

v		cabecab4_web hv3ex_content_frontpage
content_id : int
ordering : int

v		cabecab4_web hv3ex_content_rating
content_id : int
rating_sum : int unsigned
rating_count : int unsigned
lastip : varchar(50)

v		cabecab4_web hv3ex_core_log_searches
search_term : varchar(128)
hits : int unsigned

v		cabecab4_web hv3ex_extensions
extension_id : int
name : varchar(100)
type : varchar(20)
element : varchar(100)
folder : varchar(100)
client_id : tinyint
enabled : tinyint
access : int unsigned
protected : tinyint
manifest_cache : text
params : text
custom_data : text
system_data : text
checked_out : int unsigned
checked_out_time : datetime
ordering : int
state : int

v		cabecab4_web hv3ex_finder_filters
filter_id : int unsigned
title : varchar(255)
alias : varchar(255)
state : tinyint(1)
created : datetime
created_by : int unsigned
created_by_alias : varchar(255)
modified : datetime
modified_by : int unsigned
checked_out : int unsigned
checked_out_time : datetime
map_count : int unsigned
data : text
params : mediumtext

v		cabecab4_web hv3ex_finder_links
link_id : int unsigned
url : varchar(255)
route : varchar(255)
title : varchar(255)
description : varchar(255)
indexdate : datetime
md5sum : varchar(32)
published : tinyint(1)
state : int
access : int
language : varchar(8)
publish_start_date : datetime
publish_end_date : datetime
start_date : datetime
end_date : datetime
list_price : double unsigned
sale_price : double unsigned
type_id : int
object : mediumblob

v		cabecab4_web hv3ex_finder_links_terms0
link_id : int unsigned
term_id : int unsigned
weight : float unsigned

v		cabecab4_web hv3ex_finder_links_terms1
link_id : int unsigned
term_id : int unsigned
weight : float unsigned

v		cabecab4_web hv3ex_finder_links_terms2
link_id : int unsigned
term_id : int unsigned
weight : float unsigned

v		cabecab4_web hv3ex_finder_links_terms3
link_id : int unsigned
term_id : int unsigned
weight : float unsigned

v		cabecab4_web hv3ex_finder_links_terms4
link_id : int unsigned
term_id : int unsigned
weight : float unsigned

v		cabecab4_web hv3ex_finder_links_terms5
link_id : int unsigned
term_id : int unsigned
weight : float unsigned

v		cabecab4_web hv3ex_finder_links_terms6
link_id : int unsigned
term_id : int unsigned
weight : float unsigned

v		cabecab4_web hv3ex_finder_links_terms7
link_id : int unsigned
term_id : int unsigned
weight : float unsigned

v		cabecab4_web hv3ex_finder_links_terms8
link_id : int unsigned
term_id : int unsigned
weight : float unsigned

v		cabecab4_web hv3ex_finder_links_terms9
link_id : int unsigned
term_id : int unsigned
weight : float unsigned

v		cabecab4_web hv3ex_finder_links_termsa
link_id : int unsigned
term_id : int unsigned
weight : float unsigned

v		cabecab4_web hv3ex_finder_links_termsb
link_id : int unsigned
term_id : int unsigned
weight : float unsigned

v		cabecab4_web hv3ex_finder_links_termsc
link_id : int unsigned
term_id : int unsigned
weight : float unsigned

v		cabecab4_web hv3ex_finder_links_termsd
link_id : int unsigned
term_id : int unsigned
weight : float unsigned

v		cabecab4_web hv3ex_finder_links_termse
link_id : int unsigned
term_id : int unsigned
weight : float unsigned

v		cabecab4_web hv3ex_finder_links_termsf
link_id : int unsigned
term_id : int unsigned
weight : float unsigned

v		cabecab4_web hv3ex_finder_taxonomy
id : int unsigned
parent_id : int unsigned
title : varchar(255)
state : tinyint unsigned
access : tinyint unsigned
ordering : tinyint unsigned

v		cabecab4_web hv3ex_finder_taxonomy_map
link_id : int unsigned
node_id : int unsigned

v		cabecab4_web hv3ex_finder_terms
term_id : int unsigned
term : varchar(75)
stem : varchar(75)
common : tinyint unsigned
phrase : tinyint unsigned
weight : float unsigned
soundex : varchar(75)
links : int

v		cabecab4_web hv3ex_finder_terms_common
term : varchar(75)
language : varchar(3)

v		cabecab4_web hv3ex_finder_tokens
term : varchar(75)
stem : varchar(75)
common : tinyint unsigned
phrase : tinyint unsigned
weight : float unsigned
context : tinyint unsigned

v		cabecab4_web hv3ex_finder_tokens_aggregate
term_id : int unsigned
map_suffix : char(1)
term : varchar(75)
stem : varchar(75)
common : tinyint unsigned
phrase : tinyint unsigned
term_weight : float unsigned
context : tinyint unsigned
context_weight : float unsigned
total_weight : float unsigned

v		cabecab4_web hv3ex_finder_types
id : int unsigned
title : varchar(100)
mime : varchar(100)

v		cabecab4_web hv3ex_jaem_log
id : int
ext_id : varchar(50)
service_id : int
check_date : datetime
check_info : text

v		cabecab4_web hv3ex_jaem_services
id : int
ws_name : varchar(255)
ws_mode : varchar(50)
ws_uri : varchar(255)
ws_user : varchar(100)
ws_pass : varchar(100)
ws_default : tinyint(1)
ws_core : tinyint(1)

v		cabecab4_web hv3ex_languages
lang_id : int unsigned
lang_code : char(7)
title : varchar(50)
title_native : varchar(50)
sef : varchar(50)
image : varchar(50)
description : varchar(512)
metakey : text
metadesc : text
sitename : varchar(1024)
published : int
access : int unsigned
ordering : int

v		cabecab4_web hv3ex_menu
id : int
menutype : varchar(24)
title : varchar(255)
alias : varchar(255)
note : varchar(255)
path : varchar(1024)
link : varchar(1024)
type : varchar(16)
published : tinyint
parent_id : int unsigned
level : int unsigned
component_id : int unsigned
ordering : int
checked_out : int unsigned
checked_out_time : timestamp
browserNav : tinyint
access : int unsigned
img : varchar(255)
template_style_id : int unsigned
params : text
lft : int
rgt : int
home : tinyint unsigned
language : char(7)
client_id : tinyint

v		cabecab4_web hv3ex_menu_types
id : int unsigned
menutype : varchar(24)
title : varchar(48)
description : varchar(255)

v		cabecab4_web hv3ex_messages
message_id : int unsigned
user_id_from : int unsigned
user_id_to : int unsigned
folder_id : tinyint unsigned
date_time : datetime
state : tinyint(1)
priority : tinyint unsigned
subject : varchar(255)
message : text

v		cabecab4_web hv3ex_messages_cfg
user_id : int unsigned
cfg_name : varchar(100)
cfg_value : varchar(255)

v		cabecab4_web hv3ex_modules
id : int
title : varchar(100)
note : varchar(255)
content : text
ordering : int
position : varchar(50)
checked_out : int unsigned
checked_out_time : datetime
publish_up : datetime
publish_down : datetime
published : tinyint(1)
module : varchar(50)
access : int unsigned
showtitle : tinyint unsigned
params : text
client_id : tinyint
language : char(7)

v		cabecab4_web hv3ex_modules_menu
moduleid : int
menuid : int

v		cabecab4_web hv3ex_newsfeeds
catid : int
id : int unsigned
name : varchar(100)
alias : varchar(255)
link : varchar(200)
filename : varchar(200)
published : tinyint(1)
numarticles : int unsigned
cache_time : int unsigned
checked_out : int unsigned
checked_out_time : datetime
ordering : int
rtl : tinyint
access : int unsigned
language : char(7)
params : text
created : datetime
created_by : int unsigned
created_by_alias : varchar(255)
modified : datetime
modified_by : int unsigned
metakey : text
metadesc : text
metadata : text
xreference : varchar(50)
publish_up : datetime
publish_down : datetime

v		cabecab4_web hv3ex_overrider
id : int
constant : varchar(255)
string : text
file : varchar(255)

v		cabecab4_web hv3ex_redirect_links
id : int unsigned
old_url : varchar(255)
new_url : varchar(255)
referer : varchar(150)
comment : varchar(255)
hits : int unsigned
published : tinyint
created_date : datetime
modified_date : datetime

v		cabecab4_web hv3ex_schemas
extension_id : int
version_id : varchar(20)

v		cabecab4_web hv3ex_session
session_id : varchar(200)
client_id : tinyint unsigned
guest : tinyint unsigned
time : varchar(14)
data : mediumtext
userid : int
username : varchar(150)
usertype : varchar(50)

v		cabecab4_web hv3ex_template_styles
id : int unsigned
template : varchar(50)
client_id : tinyint unsigned
home : char(7)
title : varchar(255)
params : text

v		cabecab4_web hv3ex_updates
update_id : int
update_site_id : int
extension_id : int
categoryid : int
name : varchar(100)
description : text
element : varchar(100)
type : varchar(20)
folder : varchar(20)
client_id : tinyint
version : varchar(10)
data : text
detailsurl : text
infourl : text

v		cabecab4_web hv3ex_update_categories
categoryid : int
name : varchar(20)
description : text
parent : int
updatesite : int

v		cabecab4_web hv3ex_update_sites
update_site_id : int
name : varchar(100)
type : varchar(20)
location : text
enabled : int
last_check_timestamp : bigint

v		cabecab4_web hv3ex_update_sites_extensions
update_site_id : int
extension_id : int

v		cabecab4_web hv3ex_usergroups
id : int unsigned
parent_id : int unsigned
lft : int
rgt : int
title : varchar(100)

v		cabecab4_web hv3ex_users
id : int
name : varchar(255)
username : varchar(150)
email : varchar(100)
password : varchar(100)
usertype : varchar(25)
block : tinyint
sendEmail : tinyint
registerDate : datetime
lastvisitDate : datetime
activation : varchar(100)
params : text
lastResetTime : datetime
resetCount : int

v		cabecab4_web hv3ex_user_notes
id : int unsigned
user_id : int unsigned
catid : int unsigned
subject : varchar(100)
body : text
state : tinyint
checked_out : int unsigned
checked_out_time : datetime
created_user_id : int unsigned
created_time : datetime
modified_user_id : int unsigned
modified_time : datetime
review_time : datetime
publish_up : datetime
publish_down : datetime

v		cabecab4_web hv3ex_user_profiles
user_id : int
profile_key : varchar(100)
profile_value : varchar(255)
ordering : int

v		cabecab4_web hv3ex_user_usergroup_map
user_id : int unsigned
group_id : int unsigned

v		cabecab4_web hv3ex_viewlevels
id : int unsigned
title : varchar(100)
ordering : int
rules : varchar(5120)

v		cabecab4_web hv3ex_weblinks
id : int unsigned
catid : int
sid : int
title : varchar(250)
alias : varchar(255)
url : varchar(250)
description : text
date : datetime
hits : int
state : tinyint(1)
checked_out : int
checked_out_time : datetime
ordering : int
archived : tinyint(1)
approved : tinyint(1)
access : int
params : text
language : char(7)
created : datetime
created_by : int unsigned
created_by_alias : varchar(255)
modified : datetime
modified_by : int unsigned
metakey : text
metadesc : text
metadata : text
featured : tinyint unsigned
xreference : varchar(50)
publish_up : datetime
publish_down : datetime

Create relationship
FOREIGN KEY
on delete
on update