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

   Field  Type Collation Attributes Null Default Extra Action
   int(11)     No    auto_increment  Change Drop Primary Index Unique Fulltext
   text utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   text utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   int(11)     No    Change Drop Primary Index Unique Fulltext
   varchar(50) utf8_general_ci   Yes  NULL    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
   tinyint(1)     No    Change Drop Primary Index Unique Fulltext
   varchar(50) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   int(11)     No    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
   tinyint(4)     No    Change Drop Primary Index Unique Fulltext
   tinyint(4)     No    Change Drop Primary Index Unique Fulltext
   text utf8_general_ci   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 40  Edit Drop id
id_2 UNIQUE 40  Edit Drop id
id_3 UNIQUE 40  Edit Drop id
id_5 UNIQUE 40  Edit Drop id
published INDEX None  Edit Drop published
access
newsfeeds INDEX None  Edit Drop module
published
id INDEX None  Edit Drop id
ordering INDEX None  Edit Drop ordering
position INDEX None  Edit Drop position
checked_out INDEX None  Edit Drop checked_out
checked_out_time INDEX None  Edit Drop checked_out_time
published_2 INDEX None  Edit Drop published
module INDEX None  Edit Drop module
numnews INDEX None  Edit Drop numnews
access INDEX None  Edit Drop access
showtitle INDEX None  Edit Drop showtitle
iscore INDEX None  Edit Drop iscore
client_id INDEX None  Edit Drop client_id
checked_out_time_2 INDEX None  Edit Drop checked_out_time
numnews_2 INDEX None  Edit Drop numnews
client_id_2 INDEX None  Edit Drop client_id
showtitle_2 INDEX None  Edit Drop showtitle
ordering_2 INDEX None  Edit Drop ordering
id_4 INDEX None  Edit Drop id
checked_out_2 INDEX None  Edit Drop checked_out
module_4 INDEX None  Edit Drop module
published_3 INDEX None  Edit Drop published
iscore_2 INDEX None  Edit Drop iscore
access_2 INDEX None  Edit Drop access
position_4 INDEX None  Edit Drop position
client_id_3 INDEX None  Edit Drop client_id
published_4 INDEX None  Edit Drop published
id_6 INDEX None  Edit Drop id
iscore_3 INDEX None  Edit Drop iscore
showtitle_3 INDEX None  Edit Drop showtitle
module_6 INDEX None  Edit Drop module
numnews_3 INDEX None  Edit Drop numnews
ordering_3 INDEX None  Edit Drop ordering
checked_out_3 INDEX None  Edit Drop checked_out
access_3 INDEX None  Edit Drop access
position_6 INDEX None  Edit Drop position
iscore_4 INDEX None  Edit Drop iscore
checked_out_time_3 INDEX None  Edit Drop checked_out_time
id_7 INDEX None  Edit Drop id
title FULLTEXT None  Edit Drop title
content FULLTEXT None  Edit Drop content
position_2 FULLTEXT None  Edit Drop position
module_2 FULLTEXT None  Edit Drop module
params FULLTEXT None  Edit Drop params
control FULLTEXT None  Edit Drop control
content_2 FULLTEXT None  Edit Drop content
title_2 FULLTEXT None  Edit Drop title
params_2 FULLTEXT None  Edit Drop params
module_3 FULLTEXT None  Edit Drop module
position_3 FULLTEXT None  Edit Drop position
control_2 FULLTEXT None  Edit Drop control
control_3 FULLTEXT None  Edit Drop control
content_3 FULLTEXT None  Edit Drop content
module_5 FULLTEXT None  Edit Drop module
title_3 FULLTEXT None  Edit Drop title
position_5 FULLTEXT None  Edit Drop position
params_3 FULLTEXT None  Edit Drop params
position_7 FULLTEXT None  Edit Drop position
title_4 FULLTEXT None  Edit Drop title
Create an index on  columns  
 
Space usage: 
Type Usage
Data 6,608 Bytes
Index 4,096 Bytes
Total 10,704 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation utf8_general_ci
Rows 40
Row length ø 165
Row size  ø 268 Bytes
Next Autoindex 857,825
Creation Feb 19, 2018 at 08:34 PM
Last update Jun 08, 2018 at 07:25 AM
Last check Jun 13, 2018 at 03:49 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: