Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: bak_sectionsbak_sections
MySQL returned an empty result set (i.e. zero rows). (Query took 0.0003 sec)
SQL-query: 
SELECT *
FROM `bak_sections`
LIMIT 0 , 30
 [Edit] [Explain SQL] [Create PHP Code] [Refresh]


   Field  Type Collation Attributes Null Default Extra Action
   int(11)     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
   text utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(50) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(30) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   text utf8_general_ci   No      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
   datetime     No  0000-00-00 00:00:00    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
   int(11)     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 Edit Drop id
id_2 UNIQUE Edit Drop id
title_2 UNIQUE Edit Drop title
name_2 UNIQUE Edit Drop name
alias_2 UNIQUE Edit Drop alias
scope_2 UNIQUE Edit Drop scope
image_position_2 UNIQUE Edit Drop image_position
published_2 UNIQUE Edit Drop published
checked_out_2 UNIQUE Edit Drop checked_out
checked_out_time_2 UNIQUE Edit Drop checked_out_time
ordering_2 UNIQUE Edit Drop ordering
access_2 UNIQUE Edit Drop access
count_2 UNIQUE Edit Drop count
checked_out_3 UNIQUE Edit Drop checked_out
alias_5 UNIQUE Edit Drop alias
count_4 UNIQUE Edit Drop count
access_4 UNIQUE Edit Drop access
ordering_4 UNIQUE Edit Drop ordering
published_4 UNIQUE Edit Drop published
scope_6 UNIQUE Edit Drop scope
checked_out_time_4 UNIQUE Edit Drop checked_out_time
name_6 UNIQUE Edit Drop name
image_position_6 UNIQUE Edit Drop image_position
title_6 UNIQUE Edit Drop title
idx_scope INDEX None  Edit Drop scope
id INDEX None  Edit Drop id
title INDEX None  Edit Drop title
name INDEX None  Edit Drop name
alias INDEX None  Edit Drop alias
scope INDEX None  Edit Drop scope
image_position INDEX None  Edit Drop image_position
published INDEX None  Edit Drop published
checked_out INDEX None  Edit Drop checked_out
checked_out_time INDEX None  Edit Drop checked_out_time
ordering INDEX None  Edit Drop ordering
access INDEX None  Edit Drop access
count INDEX None  Edit Drop count
count_3 INDEX None  Edit Drop count
access_3 INDEX None  Edit Drop access
ordering_3 INDEX None  Edit Drop ordering
title_4 INDEX None  Edit Drop title
checked_out_time_3 INDEX None  Edit Drop checked_out_time
scope_5 INDEX None  Edit Drop scope
id_3 INDEX None  Edit Drop id
checked_out_4 INDEX None  Edit Drop checked_out
alias_6 INDEX None  Edit Drop alias
published_3 INDEX None  Edit Drop published
image_position_5 INDEX None  Edit Drop image_position
name_5 INDEX None  Edit Drop name
title_3 FULLTEXT None  Edit Drop title
name_3 FULLTEXT None  Edit Drop name
alias_3 FULLTEXT None  Edit Drop alias
image FULLTEXT None  Edit Drop image
scope_3 FULLTEXT None  Edit Drop scope
image_position_3 FULLTEXT None  Edit Drop image_position
description FULLTEXT None  Edit Drop description
params FULLTEXT None  Edit Drop params
alias_4 FULLTEXT None  Edit Drop alias
params_2 FULLTEXT None  Edit Drop params
scope_4 FULLTEXT None  Edit Drop scope
description_2 FULLTEXT None  Edit Drop description
name_4 FULLTEXT None  Edit Drop name
title_5 FULLTEXT None  Edit Drop title
image_position_4 FULLTEXT None  Edit Drop image_position
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 23, 2017 at 11:18 AM
Last update Oct 23, 2017 at 11:18 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: