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

   Field  Type Collation Attributes Null Default Extra Action
   int(11)   UNSIGNED No    auto_increment  Change Drop Primary Index Unique Fulltext
   varchar(255) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   mediumtext utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   mediumtext utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   tinyint(3)     No    Change Drop Primary Index Unique Fulltext
   int(11)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   int(11)   UNSIGNED No    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
   int(11)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   varchar(255) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   datetime     No  0000-00-00 00:00:00    Change Drop Primary Index Unique Fulltext
   int(11)   UNSIGNED No    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
   datetime     No  0000-00-00 00:00:00    Change Drop Primary Index Unique Fulltext
   datetime     No  0000-00-00 00:00:00    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
   text utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   int(11)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   int(11)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   int(11)     No    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)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   int(11)   UNSIGNED 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 43  Edit Drop id
id_2 UNIQUE 43  Edit Drop id
title_2 UNIQUE 43  Edit Drop title
alias_2 UNIQUE 43  Edit Drop alias
modified_2 UNIQUE 43  Edit Drop modified
idx_section INDEX None  Edit Drop sectionid
idx_access INDEX None  Edit Drop access
idx_checkout INDEX None  Edit Drop checked_out
idx_state INDEX None  Edit Drop state
idx_catid INDEX None  Edit Drop catid
idx_createdby INDEX None  Edit Drop created_by
id INDEX None  Edit Drop id
title INDEX None  Edit Drop title
alias INDEX None  Edit Drop alias
title_alias INDEX None  Edit Drop title_alias
state INDEX None  Edit Drop state
sectionid INDEX None  Edit Drop sectionid
mask INDEX None  Edit Drop mask
catid INDEX None  Edit Drop catid
created INDEX None  Edit Drop created
created_by INDEX None  Edit Drop created_by
created_by_alias INDEX None  Edit Drop created_by_alias
modified INDEX None  Edit Drop modified
modified_by INDEX None  Edit Drop modified_by
checked_out INDEX None  Edit Drop checked_out
checked_out_time INDEX None  Edit Drop checked_out_time
publish_up INDEX None  Edit Drop publish_up
publish_down INDEX None  Edit Drop publish_down
version INDEX None  Edit Drop version
parentid INDEX None  Edit Drop parentid
ordering INDEX None  Edit Drop ordering
access INDEX None  Edit Drop access
hits INDEX None  Edit Drop hits
hits_2 INDEX None  Edit Drop hits
title_alias_3 INDEX None  Edit Drop title_alias
catid_2 INDEX None  Edit Drop catid
alias_4 INDEX None  Edit Drop alias
checked_out_time_2 INDEX None  Edit Drop checked_out_time
parentid_2 INDEX None  Edit Drop parentid
access_2 INDEX None  Edit Drop access
created_2 INDEX None  Edit Drop created
mask_2 INDEX None  Edit Drop mask
state_2 INDEX None  Edit Drop state
created_by_2 INDEX None  Edit Drop created_by
ordering_2 INDEX None  Edit Drop ordering
title_3 FULLTEXT None  Edit Drop title
alias_3 FULLTEXT None  Edit Drop alias
title_alias_2 FULLTEXT None  Edit Drop title_alias
introtext FULLTEXT None  Edit Drop introtext
fulltext FULLTEXT None  Edit Drop fulltext
created_by_alias_2 FULLTEXT None  Edit Drop created_by_alias
images FULLTEXT None  Edit Drop images
urls FULLTEXT None  Edit Drop urls
attribs FULLTEXT None  Edit Drop attribs
metakey FULLTEXT None  Edit Drop metakey
metadesc FULLTEXT None  Edit Drop metadesc
metadata FULLTEXT None  Edit Drop metadata
attribs_2 FULLTEXT None  Edit Drop attribs
fulltext_2 FULLTEXT None  Edit Drop fulltext
created_by_alias_3 FULLTEXT None  Edit Drop created_by_alias
title_alias_4 FULLTEXT None  Edit Drop title_alias
title_4 FULLTEXT None  Edit Drop title
metadesc_2 FULLTEXT None  Edit Drop metadesc
metakey_2 FULLTEXT None  Edit Drop metakey
Create an index on  columns  
 
Space usage: 
Type Usage
Data 65,924 Bytes
Index 4,096 Bytes
Total 70,020 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation utf8_general_ci
Rows 43
Row length ø 1,533
Row size  ø 1,628 Bytes
Next Autoindex 44
Creation Oct 20, 2017 at 08:35 AM
Last update May 21, 2018 at 04:12 PM
Last check May 16, 2018 at 09:43 AM

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: