X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=doc%2Fdatabase%2Fdb_profile.md;h=aa0e36066f1d89ce7f2bea3fcda9240e22c85cfd;hb=31db9dbef7f6a4f98a6c29d15493bcffb0c39929;hp=6b9689d12451e130e32a3b293f989d504316af53;hpb=353dddaf15ce36d66b8edb9edc59e07b2a5f3c9b;p=friendica.git diff --git a/doc/database/db_profile.md b/doc/database/db_profile.md index 6b9689d124..aa0e36066f 100644 --- a/doc/database/db_profile.md +++ b/doc/database/db_profile.md @@ -1,48 +1,50 @@ Table profile -============= +=========== +user profiles data -| Field | Description | Type | Null | Key | Default | Extra | -|--------------|-----------------------------------------------|--------------|------|-----|---------------------|----------------| -| id | sequential ID | int(11) | NO | PRI | NULL | auto_increment | -| uid | user.id of the owner of this data | int(11) | NO | | 0 | | -| profile-name | Name of the profile | varchar(255) | NO | | | | -| is-default | Mark this profile as default profile | tinyint(1) | NO | | 0 | | -| hide-friends | Hide friend list from viewers of this profile | tinyint(1) | NO | | 0 | | -| name | | varchar(255) | NO | | | | -| pdesc | Title or description | varchar(255) | NO | | | | -| dob | Day of birth | varchar(32) | NO | | 0001-01-01 | | -| address | | varchar(255) | NO | | | | -| locality | | varchar(255) | NO | | | | -| region | | varchar(255) | NO | | | | -| postal-code | | varchar(32) | NO | | | | -| country-name | | varchar(255) | NO | | | | -| hometown | Deprecated | varchar(255) | NO | MUL | | | -| gender | Deprecated | varchar(32) | NO | | | | -| marital | Deprecated | varchar(255) | NO | | | | -| with | Deprecated | text | NO | | NULL | | -| howlong | Deprecated | datetime | NO | | 0001-01-01 00:00:00 | | -| sexual | Deprecated | varchar(255) | NO | | | | -| politic | Deprecated | varchar(255) | NO | | | | -| religion | Deprecated | varchar(255) | NO | | | | -| pub_keywords | | text | NO | | NULL | | -| prv_keywords | | text | NO | | NULL | | -| likes | Deprecated | text | NO | | NULL | | -| dislikes | Deprecated | text | NO | | NULL | | -| about | Deprecated | text | NO | | NULL | | -| summary | Deprecated | varchar(255) | NO | | | | -| music | Deprecated | text | NO | | NULL | | -| book | Deprecated | text | NO | | NULL | | -| tv | Deprecated | text | NO | | NULL | | -| film | Deprecated | text | NO | | NULL | | -| interest | Deprecated | text | NO | | NULL | | -| romance | Deprecated | text | NO | | NULL | | -| work | Deprecated | text | NO | | NULL | | -| education | Deprecated | text | NO | | NULL | | -| contact | Deprecated | text | NO | | NULL | | -| homepage | | varchar(255) | NO | | | | -| photo | | varchar(255) | NO | | | | -| thumb | | varchar(255) | NO | | | | -| publish | publish default profile in local directory | tinyint(1) | NO | | 0 | | -| net-publish | publish profile in global directory | tinyint(1) | NO | | 0 | | +| Field | Description | Type | Null | Key | Default | Extra | +| ----- | ----------- | ---- | ---- | --- | ------- | ----- | +| id | sequential ID | int unsigned | YES | PRI | NULL | auto_increment | +| uid | Owner User id | mediumint unsigned | YES | | 0 | | +| profile-name | Deprecated | varchar(255) | NO | | NULL | | +| is-default | Deprecated | boolean | NO | | NULL | | +| hide-friends | Hide friend list from viewers of this profile | boolean | YES | | 0 | | +| name | | varchar(255) | YES | | | | +| pdesc | Deprecated | varchar(255) | NO | | NULL | | +| dob | Day of birth | varchar(32) | YES | | 0000-00-00 | | +| address | | varchar(255) | YES | | | | +| locality | | varchar(255) | YES | | | | +| region | | varchar(255) | YES | | | | +| postal-code | | varchar(32) | YES | | | | +| country-name | | varchar(255) | YES | | | | +| hometown | Deprecated | varchar(255) | NO | | NULL | | +| gender | Deprecated | varchar(32) | NO | | NULL | | +| marital | Deprecated | varchar(255) | NO | | NULL | | +| with | Deprecated | text | NO | | NULL | | +| howlong | Deprecated | datetime | NO | | NULL | | +| sexual | Deprecated | varchar(255) | NO | | NULL | | +| politic | Deprecated | varchar(255) | NO | | NULL | | +| religion | Deprecated | varchar(255) | NO | | NULL | | +| pub_keywords | | text | NO | | NULL | | +| prv_keywords | | text | NO | | NULL | | +| likes | Deprecated | text | NO | | NULL | | +| dislikes | Deprecated | text | NO | | NULL | | +| about | Profile description | text | NO | | NULL | | +| summary | Deprecated | varchar(255) | NO | | NULL | | +| music | Deprecated | text | NO | | NULL | | +| book | Deprecated | text | NO | | NULL | | +| tv | Deprecated | text | NO | | NULL | | +| film | Deprecated | text | NO | | NULL | | +| interest | Deprecated | text | NO | | NULL | | +| romance | Deprecated | text | NO | | NULL | | +| work | Deprecated | text | NO | | NULL | | +| education | Deprecated | text | NO | | NULL | | +| contact | Deprecated | text | NO | | NULL | | +| homepage | | varchar(255) | YES | | | | +| xmpp | | varchar(255) | YES | | | | +| photo | | varchar(255) | YES | | | | +| thumb | | varchar(255) | YES | | | | +| publish | publish default profile in local directory | boolean | YES | | 0 | | +| net-publish | publish profile in global directory | boolean | YES | | 0 | | Return to [database documentation](help/database)