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

photopost_users

Field Type Null Default
userid  int(25) No   
usergroupid  int(5) No 
username  varchar(30) No   
password  varchar(50) No   
email  varchar(75) No   
homepage  varchar(100) Yes  NULL 
icq  varchar(50) Yes  NULL 
aim  varchar(30) Yes  NULL 
yahoo  varchar(30) Yes  NULL 
joindate  int(25) No 
posts  int(20) No 
birthday  date No  0000-00-00 
ipaddress  varchar(18) Yes  NULL 
location  varchar(100) Yes  NULL 
interests  varchar(250) Yes  NULL 
occupation  varchar(250) Yes  NULL 
bio  varchar(250) Yes  NULL 
site  varchar(30) Yes  NULL 
offset  smallint(2) No 
views  int(10) No 
cellphone  varchar(255) Yes  NULL 


 Indexes :
Keyname Type Cardinality Field
PRIMARY PRIMARY 1 userid
userid_2 UNIQUE 1 userid
usergroupid_2 UNIQUE 1 usergroupid
username_2 UNIQUE 1 username
password_2 UNIQUE 1 password
email_2 UNIQUE 1 email
joindate_2 UNIQUE 1 joindate
posts_2 UNIQUE 1 posts
birthday_2 UNIQUE 1 birthday
offset_2 UNIQUE 1 offset
views_2 UNIQUE 1 views
password_4 UNIQUE 1 password
homepage_2 UNIQUE None homepage
icq_2 UNIQUE None icq
aim_2 UNIQUE None aim
yahoo_2 UNIQUE None yahoo
ipaddress_2 UNIQUE None ipaddress
location_2 UNIQUE None location
interests_2 UNIQUE None interests
occupation_2 UNIQUE None occupation
bio_2 UNIQUE None bio
site_2 UNIQUE None site
cellphone_2 UNIQUE None cellphone
homepage_4 UNIQUE None homepage
interests_4 UNIQUE None interests
userid INDEX None userid
usergroupid INDEX None usergroupid
username INDEX None username
password INDEX None password
email INDEX None email
homepage INDEX None homepage
icq INDEX None icq
aim INDEX None aim
yahoo INDEX None yahoo
joindate INDEX None joindate
posts INDEX None posts
birthday INDEX None birthday
ipaddress INDEX None ipaddress
location INDEX None location
interests INDEX None interests
occupation INDEX None occupation
bio INDEX None bio
site INDEX None site
offset INDEX None offset
views INDEX None views
cellphone INDEX None cellphone
site_4 INDEX None site
homepage_5 INDEX None homepage
username_3 INDEX None username
password_3 INDEX None password
email_3 INDEX None email
homepage_3 INDEX None homepage
icq_3 INDEX None icq
aim_3 INDEX None aim
yahoo_3 INDEX None yahoo
ipaddress_3 INDEX None ipaddress
location_3 INDEX None location
interests_3 INDEX None interests
occupation_3 INDEX None occupation
bio_3 INDEX None bio
site_3 INDEX None site
cellphone_3 INDEX None cellphone
username_4 INDEX None username
bio_4 INDEX None bio


 Space usage :
Type Usage
Data 104 Bytes
Index 4,096 Bytes
Total 4,200 Bytes
   Row Statistic :
Statements Value
Format dynamic
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