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

   Field  Type Collation Attributes Null Default Extra Action
   int(10)     No    auto_increment  Change Drop Primary Index Unique Fulltext
   varchar(50) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   int(8)     No    Change Drop Primary Index Unique Fulltext
   int(11)     No    Change Drop Primary Index Unique Fulltext
   int(12)     No    Change Drop Primary Index Unique Fulltext
   int(12)     No    Change Drop Primary Index Unique Fulltext
   int(15)     No    Change Drop Primary Index Unique Fulltext
   varchar(75) latin1_swedish_ci   Yes      Change Drop Primary Index Unique Fulltext
   text latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(150) latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(100) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   smallint(6)     Yes  NULL    Change Drop Primary Index Unique Fulltext
   smallint(4)     Yes  NULL    Change Drop Primary Index Unique Fulltext
   int(10)     Yes    Change Drop Primary Index Unique Fulltext
   int(10)     No    Change Drop Primary Index Unique Fulltext
   int(12)     Yes    Change Drop Primary Index Unique Fulltext
   smallint(6)     Yes    Change Drop Primary Index Unique Fulltext
   mediumint(9)     Yes    Change Drop Primary Index Unique Fulltext
   tinyint(2)     No    Change Drop Primary Index Unique Fulltext
   int(15)     No    Change Drop Primary Index Unique Fulltext
   float(12,2)     No  0.00    Change Drop Primary Index Unique Fulltext
   varchar(5) latin1_swedish_ci   No  no    Change Drop Primary Index Unique Fulltext
   varchar(5) latin1_swedish_ci   No  yes    Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   int(5)     No  99999    Change Drop Primary Index Unique Fulltext
   varchar(32) latin1_swedish_ci   Yes    Change Drop Primary Index Unique Fulltext
   int(8)     No    Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   int(8)     No    Change Drop Primary Index Unique Fulltext
   int(1)     No    Change Drop Primary Index Unique Fulltext
   int(1)     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
date_2 UNIQUE Edit Drop date
bigimage_3 UNIQUE Edit Drop bigimage
lastpost_2 UNIQUE Edit Drop lastpost
title_2 UNIQUE None  Edit Drop title
filesize_2 UNIQUE None  Edit Drop filesize
lastposter_2 UNIQUE None  Edit Drop lastposter
userid INDEX None  Edit Drop userid
cat INDEX None  Edit Drop cat
bigimage INDEX None  Edit Drop bigimage
cat
id INDEX None  Edit Drop id
user INDEX None  Edit Drop user
userid_2 INDEX None  Edit Drop userid
cat_2 INDEX None  Edit Drop cat
storeid INDEX None  Edit Drop storeid
storecat INDEX None  Edit Drop storecat
date INDEX None  Edit Drop date
title INDEX None  Edit Drop title
keywords INDEX None  Edit Drop keywords
bigimage_2 INDEX None  Edit Drop bigimage
width INDEX None  Edit Drop width
height INDEX None  Edit Drop height
filesize INDEX None  Edit Drop filesize
views INDEX None  Edit Drop views
medwidth INDEX None  Edit Drop medwidth
medheight INDEX None  Edit Drop medheight
medsize INDEX None  Edit Drop medsize
approved INDEX None  Edit Drop approved
lastpost INDEX None  Edit Drop lastpost
rating INDEX None  Edit Drop rating
watermarked INDEX None  Edit Drop watermarked
allowprint INDEX None  Edit Drop allowprint
extra1 INDEX None  Edit Drop extra1
extra2 INDEX None  Edit Drop extra2
extra3 INDEX None  Edit Drop extra3
extra4 INDEX None  Edit Drop extra4
extra5 INDEX None  Edit Drop extra5
extra6 INDEX None  Edit Drop extra6
disporder INDEX None  Edit Drop disporder
ipaddress INDEX None  Edit Drop ipaddress
numcom INDEX None  Edit Drop numcom
lastposter INDEX None  Edit Drop lastposter
lastpid INDEX None  Edit Drop lastpid
allowrate INDEX None  Edit Drop allowrate
allowcoms INDEX None  Edit Drop allowcoms
lastposter_4 INDEX None  Edit Drop lastposter
lastpost_3 INDEX None  Edit Drop lastpost
approved_2 INDEX None  Edit Drop approved
user_2 FULLTEXT None  Edit Drop user
title_3 FULLTEXT None  Edit Drop title
description FULLTEXT None  Edit Drop description
keywords_2 FULLTEXT None  Edit Drop keywords
bigimage_4 FULLTEXT None  Edit Drop bigimage
watermarked_2 FULLTEXT None  Edit Drop watermarked
allowprint_2 FULLTEXT None  Edit Drop allowprint
extra1_2 FULLTEXT None  Edit Drop extra1
extra2_2 FULLTEXT None  Edit Drop extra2
extra3_2 FULLTEXT None  Edit Drop extra3
extra4_2 FULLTEXT None  Edit Drop extra4
extra5_2 FULLTEXT None  Edit Drop extra5
extra6_2 FULLTEXT None  Edit Drop extra6
ipaddress_2 FULLTEXT None  Edit Drop ipaddress
lastposter_3 FULLTEXT None  Edit Drop lastposter
Create an index on  columns  
 
Space usage: 
Type Usage
Data 628 Bytes
Index 4,096 Bytes
Total 4,724 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation latin1_swedish_ci
Rows 5
Row length ø 125
Row size  ø 945 Bytes
Next Autoindex 6
Creation Oct 16, 2017 at 10:00 PM
Last update Oct 16, 2017 at 10:00 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: