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

jos_modules

Field Type Null Default
id  int(11) No   
title  text No   
content  text No   
ordering  int(11) No 
position  varchar(50) Yes  NULL 
checked_out  int(11) No 
checked_out_time  datetime No  0000-00-00 00:00:00 
published  tinyint(1) No 
module  varchar(50) Yes  NULL 
numnews  int(11) No 
access  tinyint(3) No 
showtitle  tinyint(3) No 
params  text No   
iscore  tinyint(4) No 
client_id  tinyint(4) No 
control  text No   


 Indexes :
Keyname Type Cardinality Field
PRIMARY PRIMARY 40 id
id_2 UNIQUE 40 id
id_3 UNIQUE 40 id
id_5 UNIQUE 40 id
published INDEX None published
access
newsfeeds INDEX None module
published
id INDEX None id
ordering INDEX None ordering
position INDEX None position
checked_out INDEX None checked_out
checked_out_time INDEX None checked_out_time
published_2 INDEX None published
module INDEX None module
numnews INDEX None numnews
access INDEX None access
showtitle INDEX None showtitle
iscore INDEX None iscore
client_id INDEX None client_id
checked_out_time_2 INDEX None checked_out_time
numnews_2 INDEX None numnews
client_id_2 INDEX None client_id
showtitle_2 INDEX None showtitle
ordering_2 INDEX None ordering
id_4 INDEX None id
checked_out_2 INDEX None checked_out
module_4 INDEX None module
published_3 INDEX None published
iscore_2 INDEX None iscore
access_2 INDEX None access
position_4 INDEX None position
client_id_3 INDEX None client_id
published_4 INDEX None published
id_6 INDEX None id
iscore_3 INDEX None iscore
showtitle_3 INDEX None showtitle
module_6 INDEX None module
numnews_3 INDEX None numnews
ordering_3 INDEX None ordering
checked_out_3 INDEX None checked_out
access_3 INDEX None access
position_6 INDEX None position
iscore_4 INDEX None iscore
checked_out_time_3 INDEX None checked_out_time
id_7 INDEX None id
title INDEX None title
content INDEX None content
position_2 INDEX None position
module_2 INDEX None module
params INDEX None params
control INDEX None control
content_2 INDEX None content
title_2 INDEX None title
params_2 INDEX None params
module_3 INDEX None module
position_3 INDEX None position
control_2 INDEX None control
control_3 INDEX None control
content_3 INDEX None content
module_5 INDEX None module
title_3 INDEX None title
position_5 INDEX None position
params_3 INDEX None params
position_7 INDEX None position
title_4 INDEX None title


 Space usage :
Type Usage
Data 6,608 Bytes
Index 4,096 Bytes
Total 10,704 Bytes
   Row Statistic :
Statements Value
Format dynamic
Rows 40
Row length ø 165
Row size  ø 268 Bytes
Next Autoindex 857,825
Creation Feb 19, 2018 at 08:34 PM
Last update Apr 19, 2024 at 01:08 AM
Last check Apr 19, 2024 at 01:08 AM