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


   Field  Type Collation Attributes Null Default Extra Action
   int(25)     No    auto_increment  Change Drop Primary Index Unique Fulltext
   varchar(100) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(100) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(150) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   text latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   int(25)     No    Change Drop Primary Index Unique Fulltext
   int(25)     No    Change Drop Primary Index Unique Fulltext
   varchar(12) latin1_swedish_ci   No  #696969    Change Drop Primary Index Unique Fulltext
   varchar(12) latin1_swedish_ci   No  #000000    Change Drop Primary Index Unique Fulltext
   varchar(12) latin1_swedish_ci   No  #FFFFFF    Change Drop Primary Index Unique Fulltext
   varchar(32) latin1_swedish_ci   No  arial    Change Drop Primary Index Unique Fulltext
   varchar(24) latin1_swedish_ci   No  tobottom    Change Drop Primary Index Unique Fulltext
   int(15)     No    Change Drop Primary Index Unique Fulltext
   int(15)     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
fromname_2 UNIQUE Edit Drop fromname
toname_2 UNIQUE Edit Drop toname
subject_2 UNIQUE Edit Drop subject
photoid_2 UNIQUE Edit Drop photoid
date_2 UNIQUE Edit Drop date
backcolor_2 UNIQUE Edit Drop backcolor
bordcolor_2 UNIQUE Edit Drop bordcolor
fontcolor_2 UNIQUE Edit Drop fontcolor
pickfont_2 UNIQUE Edit Drop pickfont
layout_2 UNIQUE Edit Drop layout
returnr_2 UNIQUE Edit Drop returnr
readdate_2 UNIQUE Edit Drop readdate
photoid_3 UNIQUE Edit Drop photoid
readdate_4 UNIQUE Edit Drop readdate
pickfont_5 UNIQUE Edit Drop pickfont
layout_6 UNIQUE Edit Drop layout
fromname_5 UNIQUE Edit Drop fromname
backcolor_6 UNIQUE Edit Drop backcolor
id_4 UNIQUE Edit Drop id
date_4 UNIQUE Edit Drop date
toname_5 UNIQUE Edit Drop toname
id INDEX None  Edit Drop id
fromname INDEX None  Edit Drop fromname
toname INDEX None  Edit Drop toname
subject INDEX None  Edit Drop subject
photoid INDEX None  Edit Drop photoid
date INDEX None  Edit Drop date
backcolor INDEX None  Edit Drop backcolor
bordcolor INDEX None  Edit Drop bordcolor
fontcolor INDEX None  Edit Drop fontcolor
pickfont INDEX None  Edit Drop pickfont
layout INDEX None  Edit Drop layout
returnr INDEX None  Edit Drop returnr
readdate INDEX None  Edit Drop readdate
returnr_3 INDEX None  Edit Drop returnr
id_3 INDEX None  Edit Drop id
fromname_4 INDEX None  Edit Drop fromname
readdate_3 INDEX None  Edit Drop readdate
date_3 INDEX None  Edit Drop date
fontcolor_4 INDEX None  Edit Drop fontcolor
layout_5 INDEX None  Edit Drop layout
backcolor_4 INDEX None  Edit Drop backcolor
toname_4 INDEX None  Edit Drop toname
photoid_4 INDEX None  Edit Drop photoid
subject_5 INDEX None  Edit Drop subject
bordcolor_5 INDEX None  Edit Drop bordcolor
fromname_3 FULLTEXT None  Edit Drop fromname
toname_3 FULLTEXT None  Edit Drop toname
subject_3 FULLTEXT None  Edit Drop subject
message FULLTEXT None  Edit Drop message
backcolor_3 FULLTEXT None  Edit Drop backcolor
bordcolor_3 FULLTEXT None  Edit Drop bordcolor
fontcolor_3 FULLTEXT None  Edit Drop fontcolor
pickfont_3 FULLTEXT None  Edit Drop pickfont
layout_3 FULLTEXT None  Edit Drop layout
pickfont_4 FULLTEXT None  Edit Drop pickfont
layout_4 FULLTEXT None  Edit Drop layout
subject_4 FULLTEXT None  Edit Drop subject
fontcolor_5 FULLTEXT None  Edit Drop fontcolor
bordcolor_4 FULLTEXT None  Edit Drop bordcolor
backcolor_5 FULLTEXT None  Edit Drop backcolor
message_2 FULLTEXT None  Edit Drop message
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 Oct 23, 2017 at 04:03 AM
Last update Oct 23, 2017 at 04:03 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: