mysql.puroparty.com
puroparty
photopost_users
| Server: mysql.puroparty.com
|
Database: puroparty
|
Table: photopost_users
|
| Field | Type | Null | Default |
|---|---|---|---|
| userid | int(25) | No | |
| usergroupid | int(5) | No | 0 |
| username | varchar(30) | No | |
| password | varchar(50) | No | |
| 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 | 0 |
| posts | int(20) | No | 0 |
| 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 | 0 |
| views | int(10) | No | 0 |
| cellphone | varchar(255) | Yes | NULL |
| 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 | ||
| 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 | |
| INDEX | None | |||
| 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 | ||
| 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 :
|
Row Statistic :
|
|||||||||||||||||||||||||||||||