Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: bak_contentbak_content
StructureStructure BrowseBrowse SQLSQL SearchSearch InsertInsert ExportExport OperationsOperations EmptyEmpty DropDrop

   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  0    Change Drop Primary Index Unique Fulltext
   int(11)   UNSIGNED No  0    Change Drop Primary Index Unique Fulltext
   int(11)   UNSIGNED No  0    Change Drop Primary Index Unique Fulltext
   int(11)   UNSIGNED No  0    Change Drop Primary Index Unique Fulltext
   datetime     No  0000-00-00 00:00:00    Change Drop Primary Index Unique Fulltext
   int(11)   UNSIGNED No  0    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  0    Change Drop Primary Index Unique Fulltext
   int(11)   UNSIGNED No  0    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  1    Change Drop Primary Index Unique Fulltext
   int(11)   UNSIGNED No  0    Change Drop Primary Index Unique Fulltext
   int(11)     No  0    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  0    Change Drop Primary Index Unique Fulltext
   int(11)   UNSIGNED No  0    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: 
StructureStructure BrowseBrowse SQLSQL SearchSearch InsertInsert ExportExport OperationsOperations EmptyEmpty DropDrop

Indexes: Documentation
Keyname Type Cardinality Action Field
PRIMARY PRIMARY 0  Edit Drop id
id_2 UNIQUE 0  Edit Drop id
title_2 UNIQUE 0  Edit Drop title
alias_2 UNIQUE 0  Edit Drop alias
title_alias_2 UNIQUE 0  Edit Drop title_alias
state_2 UNIQUE 0  Edit Drop state
sectionid_2 UNIQUE 0  Edit Drop sectionid
mask_2 UNIQUE 0  Edit Drop mask
catid_2 UNIQUE 0  Edit Drop catid
created_2 UNIQUE 0  Edit Drop created
created_by_2 UNIQUE 0  Edit Drop created_by
created_by_alias_2 UNIQUE 0  Edit Drop created_by_alias
modified_2 UNIQUE 0  Edit Drop modified
modified_by_2 UNIQUE 0  Edit Drop modified_by
checked_out_2 UNIQUE 0  Edit Drop checked_out
checked_out_time_2 UNIQUE 0  Edit Drop checked_out_time
publish_up_2 UNIQUE 0  Edit Drop publish_up
publish_down_2 UNIQUE 0  Edit Drop publish_down
version_2 UNIQUE 0  Edit Drop version
parentid_2 UNIQUE 0  Edit Drop parentid
ordering_2 UNIQUE 0  Edit Drop ordering
access_2 UNIQUE 0  Edit Drop access
hits_2 UNIQUE 0  Edit Drop hits
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
state_3 INDEX None  Edit Drop state
title_3 FULLTEXT None  Edit Drop title
alias_3 FULLTEXT None  Edit Drop alias
title_alias_3 FULLTEXT None  Edit Drop title_alias
introtext FULLTEXT None  Edit Drop introtext
fulltext FULLTEXT None  Edit Drop fulltext
created_by_alias_3 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
Create an index on  columns  
 
Space usage: 
Type Usage
Data 0 Bytes
Index 4,096 Bytes
Total 4,096 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation utf8_general_ci
Rows 0
Next Autoindex 1
Creation Oct 16, 2017 at 06:23 PM
Last update Mar 26, 2018 at 03:25 AM
Last check Mar 13, 2024 at 07:25 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: