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

   Field  Type Collation Attributes Null Default Extra Action
   int(25)     No    auto_increment  Change Drop Primary Index Unique Fulltext
   int(5)     No    Change Drop Primary Index Unique Fulltext
   varchar(30) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(50) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(75) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(100) latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(50) latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(30) latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(30) latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   int(25)     No    Change Drop Primary Index Unique Fulltext
   int(20)     No    Change Drop Primary Index Unique Fulltext
   date     No  0000-00-00    Change Drop Primary Index Unique Fulltext
   varchar(18) latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(100) 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(30) latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   smallint(2)     No    Change Drop Primary Index Unique Fulltext
   int(10)     No    Change Drop Primary Index Unique Fulltext
   varchar(255) 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 userid
userid_2 UNIQUE Edit Drop userid
usergroupid_2 UNIQUE Edit Drop usergroupid
username_2 UNIQUE Edit Drop username
password_2 UNIQUE Edit Drop password
email_2 UNIQUE Edit Drop email
joindate_2 UNIQUE Edit Drop joindate
posts_2 UNIQUE Edit Drop posts
birthday_2 UNIQUE Edit Drop birthday
offset_2 UNIQUE Edit Drop offset
views_2 UNIQUE Edit Drop views
password_4 UNIQUE Edit Drop password
homepage_2 UNIQUE None  Edit Drop homepage
icq_2 UNIQUE None  Edit Drop icq
aim_2 UNIQUE None  Edit Drop aim
yahoo_2 UNIQUE None  Edit Drop yahoo
ipaddress_2 UNIQUE None  Edit Drop ipaddress
location_2 UNIQUE None  Edit Drop location
interests_2 UNIQUE None  Edit Drop interests
occupation_2 UNIQUE None  Edit Drop occupation
bio_2 UNIQUE None  Edit Drop bio
site_2 UNIQUE None  Edit Drop site
cellphone_2 UNIQUE None  Edit Drop cellphone
homepage_4 UNIQUE None  Edit Drop homepage
interests_4 UNIQUE None  Edit Drop interests
userid INDEX None  Edit Drop userid
usergroupid INDEX None  Edit Drop usergroupid
username INDEX None  Edit Drop username
password INDEX None  Edit Drop password
email INDEX None  Edit Drop email
homepage INDEX None  Edit Drop homepage
icq INDEX None  Edit Drop icq
aim INDEX None  Edit Drop aim
yahoo INDEX None  Edit Drop yahoo
joindate INDEX None  Edit Drop joindate
posts INDEX None  Edit Drop posts
birthday INDEX None  Edit Drop birthday
ipaddress INDEX None  Edit Drop ipaddress
location INDEX None  Edit Drop location
interests INDEX None  Edit Drop interests
occupation INDEX None  Edit Drop occupation
bio INDEX None  Edit Drop bio
site INDEX None  Edit Drop site
offset INDEX None  Edit Drop offset
views INDEX None  Edit Drop views
cellphone INDEX None  Edit Drop cellphone
site_4 INDEX None  Edit Drop site
homepage_5 INDEX None  Edit Drop homepage
username_3 FULLTEXT None  Edit Drop username
password_3 FULLTEXT None  Edit Drop password
email_3 FULLTEXT None  Edit Drop email
homepage_3 FULLTEXT None  Edit Drop homepage
icq_3 FULLTEXT None  Edit Drop icq
aim_3 FULLTEXT None  Edit Drop aim
yahoo_3 FULLTEXT None  Edit Drop yahoo
ipaddress_3 FULLTEXT None  Edit Drop ipaddress
location_3 FULLTEXT None  Edit Drop location
interests_3 FULLTEXT None  Edit Drop interests
occupation_3 FULLTEXT None  Edit Drop occupation
bio_3 FULLTEXT None  Edit Drop bio
site_3 FULLTEXT None  Edit Drop site
cellphone_3 FULLTEXT None  Edit Drop cellphone
username_4 FULLTEXT None  Edit Drop username
bio_4 FULLTEXT None  Edit Drop bio
Create an index on  columns  
 
Space usage: 
Type Usage
Data 104 Bytes
Index 4,096 Bytes
Total 4,200 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation latin1_swedish_ci
Rows 1
Row length ø 104
Row size  ø 4,200 Bytes
Next Autoindex 2
Creation Oct 17, 2017 at 06:46 PM
Last update Oct 17, 2017 at 06:46 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: