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

   Field  Type Collation Attributes Null Default Extra Action
   int(5)     No    auto_increment  Change Drop Primary Index Unique Fulltext
   varchar(50) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   smallint(3)     No    Change Drop Primary Index Unique Fulltext
   smallint(3)     No    Change Drop Primary Index Unique Fulltext
   smallint(3)     No    Change Drop Primary Index Unique Fulltext
   smallint(3)     No    Change Drop Primary Index Unique Fulltext
   int(10)     Yes  NULL    Change Drop Primary Index Unique Fulltext
   int(10)     Yes  NULL    Change Drop Primary Index Unique Fulltext
   int(5)     No    Change Drop Primary Index Unique Fulltext
   int(3)     No    Change Drop Primary Index Unique Fulltext
   int(3)     No    Change Drop Primary Index Unique Fulltext
   int(3)     No    Change Drop Primary Index Unique Fulltext
   int(3)     No    Change Drop Primary Index Unique Fulltext
   int(3)     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 groupid
groupid_2 UNIQUE Edit Drop groupid
groupname_2 UNIQUE Edit Drop groupname
groupid_3 UNIQUE Edit Drop groupid
groupname_6 UNIQUE Edit Drop groupname
groupid_5 UNIQUE Edit Drop groupid
groupname_9 UNIQUE Edit Drop groupname
groupid_7 UNIQUE Edit Drop groupid
modaccess_4 UNIQUE Edit Drop modaccess
groupid INDEX None  Edit Drop groupid
groupname INDEX None  Edit Drop groupname
cpaccess INDEX None  Edit Drop cpaccess
modaccess INDEX None  Edit Drop modaccess
uploads INDEX None  Edit Drop uploads
comments INDEX None  Edit Drop comments
diskspace INDEX None  Edit Drop diskspace
uploadsize INDEX None  Edit Drop uploadsize
uplimit INDEX None  Edit Drop uplimit
editpho INDEX None  Edit Drop editpho
editposts INDEX None  Edit Drop editposts
useralbums INDEX None  Edit Drop useralbums
reqmod INDEX None  Edit Drop reqmod
canassign INDEX None  Edit Drop canassign
groupname_4 INDEX None  Edit Drop groupname
uplimit_2 INDEX None  Edit Drop uplimit
diskspace_2 INDEX None  Edit Drop diskspace
uploadsize_2 INDEX None  Edit Drop uploadsize
cpaccess_2 INDEX None  Edit Drop cpaccess
uploads_2 INDEX None  Edit Drop uploads
editpho_2 INDEX None  Edit Drop editpho
useralbums_2 INDEX None  Edit Drop useralbums
comments_2 INDEX None  Edit Drop comments
canassign_2 INDEX None  Edit Drop canassign
modaccess_2 INDEX None  Edit Drop modaccess
groupid_4 INDEX None  Edit Drop groupid
editposts_2 INDEX None  Edit Drop editposts
reqmod_2 INDEX None  Edit Drop reqmod
uplimit_3 INDEX None  Edit Drop uplimit
diskspace_3 INDEX None  Edit Drop diskspace
editpho_3 INDEX None  Edit Drop editpho
uploads_3 INDEX None  Edit Drop uploads
uploadsize_3 INDEX None  Edit Drop uploadsize
cpaccess_3 INDEX None  Edit Drop cpaccess
useralbums_3 INDEX None  Edit Drop useralbums
groupname_8 INDEX None  Edit Drop groupname
editposts_3 INDEX None  Edit Drop editposts
reqmod_3 INDEX None  Edit Drop reqmod
modaccess_3 INDEX None  Edit Drop modaccess
groupid_6 INDEX None  Edit Drop groupid
canassign_3 INDEX None  Edit Drop canassign
comments_3 INDEX None  Edit Drop comments
uplimit_4 INDEX None  Edit Drop uplimit
diskspace_4 INDEX None  Edit Drop diskspace
cpaccess_4 INDEX None  Edit Drop cpaccess
editpho_4 INDEX None  Edit Drop editpho
uploads_4 INDEX None  Edit Drop uploads
uploadsize_4 INDEX None  Edit Drop uploadsize
editposts_4 INDEX None  Edit Drop editposts
useralbums_4 INDEX None  Edit Drop useralbums
groupname_11 INDEX None  Edit Drop groupname
groupname_3 FULLTEXT None  Edit Drop groupname
groupname_5 FULLTEXT None  Edit Drop groupname
groupname_7 FULLTEXT None  Edit Drop groupname
groupname_10 FULLTEXT None  Edit Drop groupname
Create an index on  columns  
 
Space usage: 
Type Usage
Data 148 Bytes
Index 4,096 Bytes
Total 4,244 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation latin1_swedish_ci
Rows 5
Row length ø 29
Row size  ø 849 Bytes
Next Autoindex 6
Creation Mar 21, 2018 at 08:38 PM
Last update Mar 21, 2018 at 08:38 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: