Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: jos_menujos_menu

   Field  Type Collation Attributes Null Default Extra Action
   int(11)     No    auto_increment  Change Drop Primary Index Unique Fulltext
   varchar(75) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(255) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(255) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   text utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(50) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   tinyint(1)     No    Change Drop Primary Index Unique Fulltext
   int(11)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   int(11)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   int(11)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   datetime     No  0000-00-00 00:00:00    Change Drop Primary Index Unique Fulltext
   int(11)     No    Change Drop Primary Index Unique Fulltext
   tinyint(4)     Yes    Change Drop Primary Index Unique Fulltext
   tinyint(3)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   tinyint(3)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   text utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   int(11)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   int(11)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   int(1)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
With selected: Check All  /  Uncheck All     With selected:  

Print viewPrint view    Propose table structurePropose table structureDocumentation
Add new fieldAdd new field: 


Indexes: Documentation
Keyname Type Cardinality Action Field
PRIMARY PRIMARY 29  Edit Drop id
id_2 UNIQUE 29  Edit Drop id
alias_2 UNIQUE 29  Edit Drop alias
id_4 UNIQUE 29  Edit Drop id
alias_4 UNIQUE 29  Edit Drop alias
name_2 UNIQUE None  Edit Drop name
name_5 UNIQUE None  Edit Drop name
componentid INDEX None  Edit Drop componentid
menutype
published
access
menutype INDEX None  Edit Drop menutype
id INDEX None  Edit Drop id
menutype_2 INDEX None  Edit Drop menutype
name INDEX None  Edit Drop name
alias INDEX None  Edit Drop alias
type INDEX None  Edit Drop type
published INDEX None  Edit Drop published
parent INDEX None  Edit Drop parent
componentid_2 INDEX None  Edit Drop componentid
sublevel INDEX None  Edit Drop sublevel
ordering INDEX None  Edit Drop ordering
checked_out INDEX None  Edit Drop checked_out
checked_out_time INDEX None  Edit Drop checked_out_time
pollid INDEX None  Edit Drop pollid
browserNav INDEX None  Edit Drop browserNav
access INDEX None  Edit Drop access
utaccess INDEX None  Edit Drop utaccess
lft INDEX None  Edit Drop lft
rgt INDEX None  Edit Drop rgt
home INDEX None  Edit Drop home
id_3 INDEX None  Edit Drop id
utaccess_2 INDEX None  Edit Drop utaccess
name_4 INDEX None  Edit Drop name
access_2 INDEX None  Edit Drop access
home_2 INDEX None  Edit Drop home
menutype_4 INDEX None  Edit Drop menutype
checked_out_time_2 INDEX None  Edit Drop checked_out_time
lft_2 INDEX None  Edit Drop lft
pollid_2 INDEX None  Edit Drop pollid
componentid_3 INDEX None  Edit Drop componentid
ordering_2 INDEX None  Edit Drop ordering
sublevel_2 INDEX None  Edit Drop sublevel
browserNav_2 INDEX None  Edit Drop browserNav
type_3 INDEX None  Edit Drop type
parent_2 INDEX None  Edit Drop parent
published_2 INDEX None  Edit Drop published
rgt_2 INDEX None  Edit Drop rgt
alias_6 INDEX None  Edit Drop alias
checked_out_2 INDEX None  Edit Drop checked_out
checked_out_time_3 INDEX None  Edit Drop checked_out_time
lft_3 INDEX None  Edit Drop lft
access_3 INDEX None  Edit Drop access
menutype_3 FULLTEXT None  Edit Drop menutype
name_3 FULLTEXT None  Edit Drop name
alias_3 FULLTEXT None  Edit Drop alias
link FULLTEXT None  Edit Drop link
type_2 FULLTEXT None  Edit Drop type
params FULLTEXT None  Edit Drop params
link_2 FULLTEXT None  Edit Drop link
menutype_5 FULLTEXT None  Edit Drop menutype
params_2 FULLTEXT None  Edit Drop params
name_6 FULLTEXT None  Edit Drop name
alias_5 FULLTEXT None  Edit Drop alias
type_4 FULLTEXT None  Edit Drop type
alias_7 FULLTEXT None  Edit Drop alias
link_3 FULLTEXT None  Edit Drop link
Create an index on  columns  
 
Space usage: 
Type Usage
Data 11,564 Bytes
Index 4,096 Bytes
Total 15,660 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation utf8_general_ci
Rows 29
Row length ø 398
Row size  ø 540 Bytes
Next Autoindex 53
Creation Dec 11, 2017 at 11:26 PM
Last update May 20, 2018 at 02:07 PM
Last check May 23, 2018 at 06:40 PM

Run SQL query/queries on database puropartyDocumentation     Fields: 
Or Location of the textfile: 
 Location of the textfile: 
   (Max: 2,048KB)
  Compression:
                
Character set of the file: