Inhalt
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