X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=doc%2Fdatabase%2Fdb_mailacct.md;h=59f34250ce901b126e221e110a1f4875b98e4020;hb=6354d7c81da4ef440131374f67620633ca4feef1;hp=0fb9a43f6eeaa971eb19651e6b0dbb8a274c6cca;hpb=fd30df7300d9de5b2316b86ccc38053cec69dfe1;p=friendica.git diff --git a/doc/database/db_mailacct.md b/doc/database/db_mailacct.md index 0fb9a43f6e..59f34250ce 100644 --- a/doc/database/db_mailacct.md +++ b/doc/database/db_mailacct.md @@ -1,21 +1,40 @@ Table mailacct =========== + Mail account data for fetching mails -| Field | Description | Type | Null | Key | Default | Extra | -| ------------ | ------------- | ------------------ | ---- | --- | ------------------- | -------------- | -| id | sequential ID | int unsigned | NO | PRI | NULL | auto_increment | -| uid | User id | mediumint unsigned | NO | | 0 | | -| server | | varchar(255) | NO | | | | -| port | | smallint unsigned | NO | | 0 | | -| ssltype | | varchar(16) | NO | | | | -| mailbox | | varchar(255) | NO | | | | -| user | | varchar(255) | NO | | | | -| pass | | text | YES | | NULL | | -| reply_to | | varchar(255) | NO | | | | -| action | | tinyint unsigned | NO | | 0 | | -| movetofolder | | varchar(255) | NO | | | | -| pubmail | | boolean | NO | | 0 | | -| last_check | | datetime | NO | | 0001-01-01 00:00:00 | | +Fields +------ + +| Field | Description | Type | Null | Key | Default | Extra | +| ------------ | ------------- | ------------------ | ---- | --- | ------------------- | -------------- | +| id | sequential ID | int unsigned | NO | PRI | NULL | auto_increment | +| uid | User id | mediumint unsigned | NO | | 0 | | +| server | | varchar(255) | NO | | | | +| port | | smallint unsigned | NO | | 0 | | +| ssltype | | varchar(16) | NO | | | | +| mailbox | | varchar(255) | NO | | | | +| user | | varchar(255) | NO | | | | +| pass | | text | YES | | NULL | | +| reply_to | | varchar(255) | NO | | | | +| action | | tinyint unsigned | NO | | 0 | | +| movetofolder | | varchar(255) | NO | | | | +| pubmail | | boolean | NO | | 0 | | +| last_check | | datetime | NO | | 0001-01-01 00:00:00 | | + +Indexes +------------ + +| Name | Fields | +| ------- | ------ | +| PRIMARY | id | +| uid | uid | + +Foreign Keys +------------ + +| Field | Target Table | Target Field | +|-------|--------------|--------------| +| uid | [user](help/database/db_user) | uid | Return to [database documentation](help/database)