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


   Field  Type Collation Attributes Null Default Extra Action
   int(12)     No    auto_increment  Change Drop Primary Index Unique Fulltext
   int(12)     Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   char(2) latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   text latin1_swedish_ci   Yes  NULL    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
id_3 UNIQUE Edit Drop id
id_5 UNIQUE Edit Drop id
id_7 UNIQUE Edit Drop id
id_9 UNIQUE Edit Drop id
id_11 UNIQUE Edit Drop id
cat_2 UNIQUE None  Edit Drop cat
fieldname_2 UNIQUE None  Edit Drop fieldname
fieldtype_2 UNIQUE None  Edit Drop fieldtype
fieldname_5 UNIQUE None  Edit Drop fieldname
cat_4 UNIQUE None  Edit Drop cat
fieldtype_4 UNIQUE None  Edit Drop fieldtype
fieldtype_5 UNIQUE None  Edit Drop fieldtype
cat_5 UNIQUE None  Edit Drop cat
fieldname_9 UNIQUE None  Edit Drop fieldname
fieldname_12 UNIQUE None  Edit Drop fieldname
cat_8 UNIQUE None  Edit Drop cat
fieldtype_7 UNIQUE None  Edit Drop fieldtype
fieldname_15 UNIQUE None  Edit Drop fieldname
cat_10 UNIQUE None  Edit Drop cat
fieldtype_9 UNIQUE None  Edit Drop fieldtype
cat_12 UNIQUE None  Edit Drop cat
fieldname_17 UNIQUE None  Edit Drop fieldname
fieldtype_11 UNIQUE None  Edit Drop fieldtype
id INDEX None  Edit Drop id
cat INDEX None  Edit Drop cat
fieldname INDEX None  Edit Drop fieldname
fieldtype INDEX None  Edit Drop fieldtype
cat_3 INDEX None  Edit Drop cat
fieldname_6 INDEX None  Edit Drop fieldname
id_4 INDEX None  Edit Drop id
fieldtype_3 INDEX None  Edit Drop fieldtype
fieldname_8 INDEX None  Edit Drop fieldname
fieldtype_6 INDEX None  Edit Drop fieldtype
cat_6 INDEX None  Edit Drop cat
id_6 INDEX None  Edit Drop id
cat_7 INDEX None  Edit Drop cat
fieldname_10 INDEX None  Edit Drop fieldname
fieldtype_8 INDEX None  Edit Drop fieldtype
id_8 INDEX None  Edit Drop id
fieldname_13 INDEX None  Edit Drop fieldname
cat_9 INDEX None  Edit Drop cat
id_10 INDEX None  Edit Drop id
cat_11 INDEX None  Edit Drop cat
fieldname_16 INDEX None  Edit Drop fieldname
fieldtype_10 INDEX None  Edit Drop fieldtype
fieldtype_12 INDEX None  Edit Drop fieldtype
fieldname_3 FULLTEXT None  Edit Drop fieldname
fieldoptions FULLTEXT None  Edit Drop fieldoptions
fieldname_4 FULLTEXT None  Edit Drop fieldname
fieldoptions_2 FULLTEXT None  Edit Drop fieldoptions
fieldname_7 FULLTEXT None  Edit Drop fieldname
fieldoptions_3 FULLTEXT None  Edit Drop fieldoptions
fieldname_11 FULLTEXT None  Edit Drop fieldname
fieldoptions_4 FULLTEXT None  Edit Drop fieldoptions
fieldoptions_5 FULLTEXT None  Edit Drop fieldoptions
fieldname_14 FULLTEXT None  Edit Drop fieldname
fieldname_18 FULLTEXT None  Edit Drop fieldname
fieldoptions_6 FULLTEXT None  Edit Drop fieldoptions
Create an index on  columns  
 
Space usage: 
Type Usage
Data 0 Bytes
Index 3,072 Bytes
Total 3,072 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation latin1_swedish_ci
Rows 0
Next Autoindex 1
Creation Apr 21, 2018 at 09:46 AM
Last update Apr 21, 2018 at 09:46 AM
Last check Apr 21, 2018 at 09:46 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: