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

bak_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 15 id
id_2 UNIQUE 15 id
id_3 UNIQUE 15 id
id_5 UNIQUE 15 id
numnews_4 UNIQUE 15 numnews
module_2 UNIQUE None module
module_4 UNIQUE None module
module_9 UNIQUE None module
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
access_2 INDEX None access
published_3 INDEX None published
checked_out_2 INDEX None checked_out
client_id_2 INDEX None client_id
showtitle_2 INDEX None showtitle
module_6 INDEX None module
numnews_2 INDEX None numnews
id_4 INDEX None id
iscore_2 INDEX None iscore
ordering_2 INDEX None ordering
position_3 INDEX None position
checked_out_time_2 INDEX None checked_out_time
access_3 INDEX None access
checked_out_time_3 INDEX None checked_out_time
position_5 INDEX None position
checked_out_3 INDEX None checked_out
published_4 INDEX None published
numnews_3 INDEX None numnews
id_6 INDEX None id
client_id_3 INDEX None client_id
iscore_3 INDEX None iscore
showtitle_3 INDEX None showtitle
ordering_3 INDEX None ordering
module_8 INDEX None module
title INDEX None title
content INDEX None content
position_2 INDEX None position
module_3 INDEX None module
params INDEX None params
control INDEX None control
content_2 INDEX None content
control_2 INDEX None control
module_5 INDEX None module
title_2 INDEX None title
position_4 INDEX None position
params_2 INDEX None params
control_3 INDEX None control
params_3 INDEX None params
title_3 INDEX None title
module_7 INDEX None module
position_6 INDEX None position
content_3 INDEX None content


 Space usage :
Type Usage
Data 824 Bytes
Index 4,096 Bytes
Total 4,920 Bytes
   Row Statistic :
Statements Value
Format dynamic
Rows 15
Row length ø 54
Row size  ø 328 Bytes
Next Autoindex 16
Creation Oct 28, 2017 at 10:41 PM
Last update Apr 18, 2024 at 12:58 PM
Last check Apr 18, 2024 at 12:58 PM