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

   Field  Type Collation Attributes Null Default Extra Action
   int(12)     No    auto_increment  Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   mediumint(4)     No  9999    Change Drop Primary Index Unique Fulltext
   varchar(4) latin1_swedish_ci   No  yes    Change Drop Primary Index Unique Fulltext
   int(5)     No    Change Drop Primary Index Unique Fulltext
   varchar(200) latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(200) latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(200) latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(5) latin1_swedish_ci   No  no    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
   text latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   text latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   int(12)     No    Change Drop Primary Index Unique Fulltext
   int(11)   UNSIGNED Yes  NULL    Change Drop Primary Index Unique Fulltext
   int(11)   UNSIGNED Yes  NULL    Change Drop Primary Index Unique Fulltext
   int(11)   UNSIGNED Yes    Change Drop Primary Index Unique Fulltext
   int(11)   UNSIGNED Yes    Change Drop Primary Index Unique Fulltext
   varchar(24) latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(4) latin1_swedish_ci   No    Change Drop Primary Index Unique Fulltext
   varchar(32) latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   int(2)   UNSIGNED Yes    Change Drop Primary Index Unique Fulltext
   varchar(6) latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(250) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   int(2)     No    Change Drop Primary Index Unique Fulltext
   varchar(250) latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(250) latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(250) latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(250) latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(250) latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(250) latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   int(15)     No    Change Drop Primary Index Unique Fulltext
   int(12)     No    Change Drop Primary Index Unique Fulltext
   char(3) latin1_swedish_ci   No  no    Change Drop Primary Index Unique Fulltext
   varchar(32) latin1_swedish_ci   No    Change Drop Primary Index Unique Fulltext
   char(3) latin1_swedish_ci   No  no    Change Drop Primary Index Unique Fulltext
   varchar(128) latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   text latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   text latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   int(3)     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
   smallint(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
catname_2 UNIQUE Edit Drop catname
sortorder_2 UNIQUE Edit Drop sortorder
description_2 UNIQUE None  Edit Drop description
header_2 UNIQUE None  Edit Drop header
footer_2 UNIQUE None  Edit Drop footer
headtags_2 UNIQUE None  Edit Drop headtags
ugnoview_2 UNIQUE None  Edit Drop ugnoview
ugnoupload_2 UNIQUE None  Edit Drop ugnoupload
ugnopost_2 UNIQUE None  Edit Drop ugnopost
ugnovote_2 UNIQUE None  Edit Drop ugnovote
ugnoanno_2 UNIQUE None  Edit Drop ugnoanno
photos_2 UNIQUE None  Edit Drop photos
password_2 UNIQUE None  Edit Drop password
theme_2 UNIQUE None  Edit Drop theme
catdepth_2 UNIQUE None  Edit Drop catdepth
parent INDEX None  Edit Drop parent
id INDEX None  Edit Drop id
catname INDEX None  Edit Drop catname
description INDEX None  Edit Drop description
catorder INDEX None  Edit Drop catorder
thumbs INDEX None  Edit Drop thumbs
parent_2 INDEX None  Edit Drop parent
header INDEX None  Edit Drop header
footer INDEX None  Edit Drop footer
headtags INDEX None  Edit Drop headtags
private INDEX None  Edit Drop private
ugnoview INDEX None  Edit Drop ugnoview
ugnoupload INDEX None  Edit Drop ugnoupload
ugnopost INDEX None  Edit Drop ugnopost
ugnovote INDEX None  Edit Drop ugnovote
ugnoanno INDEX None  Edit Drop ugnoanno
subalbum INDEX None  Edit Drop subalbum
lastpost INDEX None  Edit Drop lastpost
lastphoto INDEX None  Edit Drop lastphoto
photos INDEX None  Edit Drop photos
posts INDEX None  Edit Drop posts
password INDEX None  Edit Drop password
cattype INDEX None  Edit Drop cattype
theme INDEX None  Edit Drop theme
thumbtype INDEX None  Edit Drop thumbtype
catdepth INDEX None  Edit Drop catdepth
watermark INDEX None  Edit Drop watermark
sortorder INDEX None  Edit Drop sortorder
catname_3 FULLTEXT None  Edit Drop catname
description_3 FULLTEXT None  Edit Drop description
thumbs_2 FULLTEXT None  Edit Drop thumbs
header_3 FULLTEXT None  Edit Drop header
footer_3 FULLTEXT None  Edit Drop footer
headtags_3 FULLTEXT None  Edit Drop headtags
private_2 FULLTEXT None  Edit Drop private
ugnoview_3 FULLTEXT None  Edit Drop ugnoview
ugnoupload_3 FULLTEXT None  Edit Drop ugnoupload
ugnopost_3 FULLTEXT None  Edit Drop ugnopost
ugnovote_3 FULLTEXT None  Edit Drop ugnovote
ugnoanno_3 FULLTEXT None  Edit Drop ugnoanno
children FULLTEXT None  Edit Drop children
albums FULLTEXT None  Edit Drop albums
password_3 FULLTEXT None  Edit Drop password
cattype_2 FULLTEXT None  Edit Drop cattype
theme_3 FULLTEXT None  Edit Drop theme
catdepth_3 FULLTEXT None  Edit Drop catdepth
watermark_2 FULLTEXT None  Edit Drop watermark
Create an index on  columns  
 
Space usage: 
Type Usage
Data 324 Bytes
Index 4,096 Bytes
Total 4,420 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation latin1_swedish_ci
Rows 3
Row length ø 108
Row size  ø 1,473 Bytes
Next Autoindex 501
Creation Oct 09, 2017 at 01:47 AM
Last update Oct 09, 2017 at 01:47 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: