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

   Field  Type Collation Attributes Null Default Extra Action
   int(11)     No    Change Drop Primary Index Unique Fulltext
   int(11)     No    auto_increment  Change Drop Primary Index Unique Fulltext
   text utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   text utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(200) utf8_general_ci   Yes  NULL    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  3600    Change Drop Primary Index Unique Fulltext
   tinyint(3)   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)     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 Edit Drop id
id_2 UNIQUE Edit Drop id
alias_2 UNIQUE Edit Drop alias
ordering_2 UNIQUE Edit Drop ordering
ordering_3 UNIQUE Edit Drop ordering
alias_5 UNIQUE Edit Drop alias
id_4 UNIQUE Edit Drop id
id_6 UNIQUE Edit Drop id
alias_8 UNIQUE Edit Drop alias
ordering_6 UNIQUE Edit Drop ordering
checked_out_time_4 UNIQUE Edit Drop checked_out_time
published INDEX None  Edit Drop published
catid INDEX None  Edit Drop catid
catid_2 INDEX None  Edit Drop catid
id INDEX None  Edit Drop id
alias INDEX None  Edit Drop alias
filename INDEX None  Edit Drop filename
published_2 INDEX None  Edit Drop published
numarticles INDEX None  Edit Drop numarticles
cache_time INDEX None  Edit Drop cache_time
checked_out INDEX None  Edit Drop checked_out
checked_out_time INDEX None  Edit Drop checked_out_time
ordering INDEX None  Edit Drop ordering
rtl INDEX None  Edit Drop rtl
catid_3 INDEX None  Edit Drop catid
alias_4 INDEX None  Edit Drop alias
checked_out_time_2 INDEX None  Edit Drop checked_out_time
checked_out_2 INDEX None  Edit Drop checked_out
published_3 INDEX None  Edit Drop published
rtl_2 INDEX None  Edit Drop rtl
cache_time_2 INDEX None  Edit Drop cache_time
numarticles_2 INDEX None  Edit Drop numarticles
id_3 INDEX None  Edit Drop id
ordering_4 INDEX None  Edit Drop ordering
filename_4 INDEX None  Edit Drop filename
rtl_3 INDEX None  Edit Drop rtl
ordering_5 INDEX None  Edit Drop ordering
catid_4 INDEX None  Edit Drop catid
id_5 INDEX None  Edit Drop id
published_4 INDEX None  Edit Drop published
cache_time_3 INDEX None  Edit Drop cache_time
checked_out_time_3 INDEX None  Edit Drop checked_out_time
alias_7 INDEX None  Edit Drop alias
checked_out_3 INDEX None  Edit Drop checked_out
numarticles_3 INDEX None  Edit Drop numarticles
filename_6 INDEX None  Edit Drop filename
id_7 INDEX None  Edit Drop id
published_5 INDEX None  Edit Drop published
catid_5 INDEX None  Edit Drop catid
name FULLTEXT None  Edit Drop name
alias_3 FULLTEXT None  Edit Drop alias
link FULLTEXT None  Edit Drop link
filename_2 FULLTEXT None  Edit Drop filename
link_2 FULLTEXT None  Edit Drop link
name_2 FULLTEXT None  Edit Drop name
filename_3 FULLTEXT None  Edit Drop filename
alias_6 FULLTEXT None  Edit Drop alias
link_3 FULLTEXT None  Edit Drop link
name_3 FULLTEXT None  Edit Drop name
filename_5 FULLTEXT None  Edit Drop filename
alias_9 FULLTEXT None  Edit Drop alias
link_4 FULLTEXT None  Edit Drop link
link_5 FULLTEXT None  Edit Drop link
name_4 FULLTEXT None  Edit Drop name
Create an index on  columns  
 
Space usage: 
Type Usage
Data 1,104 Bytes
Index 4,096 Bytes
Total 5,200 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation utf8_general_ci
Rows 8
Row length ø 138
Row size  ø 650 Bytes
Next Autoindex 9
Creation Feb 24, 2018 at 08:02 AM
Last update Mar 26, 2018 at 02:50 PM
Last check Mar 26, 2018 at 11:34 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: