Contents
| Field | Description | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|---|
| id | int(11) | NO | PRI | NULL | auto_increment | |
| profile_guid | char(64) | NO | MUL | |||
| aid | int(10) unsigned | NO | MUL | 0 | ||
| uid | int(11) | NO | MUL | NULL | ||
| profile_name | char(255) | NO | NULL | |||
| is_default | tinyint(1) | NO | MUL | 0 | ||
| hide_friends | tinyint(1) | NO | MUL | 0 | ||
| fullname | char(255) | NO | NULL | |||
| pdesc | char(255) | NO | NULL | |||
| chandesc | text | NO | NULL | |||
| dob | char(32) | NO | 0000-00-00 | |||
| dob_tz | char(255) | NO | UTC | |||
| address | char(255) | NO | NULL | |||
| locality | char(255) | NO | MUL | NULL | ||
| region | char(255) | NO | NULL | |||
| postal_code | char(32) | NO | MUL | NULL | ||
| country_name | char(255) | NO | MUL | NULL | ||
| hometown | char(255) | NO | MUL | NULL | ||
| gender | char(32) | NO | MUL | NULL | ||
| marital | char(255) | NO | MUL | NULL | ||
| partner | text | NO | NULL | |||
| howlong | datetime | NO | 0000-00-00 00:00:00 | |||
| sexual | char(255) | NO | MUL | NULL | ||
| politic | char(255) | NO | NULL | |||
| religion | char(255) | NO | NULL | |||
| keywords | text | NO | NULL | |||
| likes | text | NO | NULL | |||
| dislikes | text | NO | NULL | |||
| about | text | NO | NULL | |||
| summary | char(255) | NO | NULL | |||
| music | text | NO | NULL | |||
| book | text | NO | NULL | |||
| tv | text | NO | NULL | |||
| film | text | NO | NULL | |||
| interest | text | NO | NULL | |||
| romance | text | NO | NULL | |||
| employment | text | NO | NULL | |||
| education | text | NO | NULL | |||
| contact | text | NO | NULL | |||
| channels | text | NO | NULL | |||
| homepage | char(255) | NO | NULL | |||
| photo | char(255) | NO | NULL | |||
| thumb | char(255) | NO | NULL | |||
| publish | tinyint(1) | NO | MUL | 0 |
Return to database documentation