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

jos_weblinks

Field Type Null Default
id  int(11) No   
catid  int(11) No 
sid  int(11) No 
title  varchar(250) No   
alias  varchar(255) No   
url  varchar(250) No   
description  text No   
date  datetime No  0000-00-00 00:00:00 
hits  int(11) No 
published  tinyint(1) No 
checked_out  int(11) No 
checked_out_time  datetime No  0000-00-00 00:00:00 
ordering  int(11) No 
archived  tinyint(1) No 
approved  tinyint(1) No 
params  text No   


 Indexes :
Keyname Type Cardinality Field
PRIMARY PRIMARY 6 id
id_2 UNIQUE 6 id
title_2 UNIQUE 6 title
alias_2 UNIQUE 6 alias
url_2 UNIQUE 6 url
ordering_2 UNIQUE 6 ordering
id_3 UNIQUE 6 id
url_5 UNIQUE 6 url
ordering_4 UNIQUE 6 ordering
title_6 UNIQUE 6 title
alias_4 UNIQUE 6 alias
id_5 UNIQUE 6 id
url_7 UNIQUE 6 url
ordering_6 UNIQUE 6 ordering
alias_8 UNIQUE 6 alias
title_8 UNIQUE 6 title
catid INDEX None catid
published
archived
id INDEX None id
catid_2 INDEX None catid
sid INDEX None sid
title INDEX None title
alias INDEX None alias
url INDEX None url
date INDEX None date
hits INDEX None hits
published INDEX None published
checked_out INDEX None checked_out
checked_out_time INDEX None checked_out_time
ordering INDEX None ordering
archived INDEX None archived
approved INDEX None approved
ordering_3 INDEX None ordering
checked_out_2 INDEX None checked_out
catid_3 INDEX None catid
url_4 INDEX None url
published_2 INDEX None published
title_4 INDEX None title
checked_out_time_2 INDEX None checked_out_time
alias_5 INDEX None alias
id_4 INDEX None id
approved_2 INDEX None approved
date_2 INDEX None date
hits_2 INDEX None hits
archived_2 INDEX None archived
sid_2 INDEX None sid
ordering_5 INDEX None ordering
catid_4 INDEX None catid
alias_9 INDEX None alias
id_6 INDEX None id
approved_3 INDEX None approved
title_3 INDEX None title
alias_3 INDEX None alias
url_3 INDEX None url
description INDEX None description
params INDEX None params
title_5 INDEX None title
params_2 INDEX None params
url_6 INDEX None url
description_2 INDEX None description
alias_6 INDEX None alias
alias_7 INDEX None alias
title_7 INDEX None title
description_3 INDEX None description
url_8 INDEX None url


 Space usage :
Type Usage
Data 784 Bytes
Index 4,096 Bytes
Total 4,880 Bytes
   Row Statistic :
Statements Value
Format dynamic
Rows 6
Row length ø 130
Row size  ø 813 Bytes
Next Autoindex 7
Creation Dec 15, 2017 at 06:52 PM
Last update Jun 18, 2018 at 08:10 AM
Last check Jun 18, 2018 at 08:10 AM