-- ------------------------------------------
--- Friendica 2021.09-dev (Siberian Iris)
--- DB_UPDATE_VERSION 1428
+-- Friendica 2021.12-dev (Siberian Iris)
+-- DB_UPDATE_VERSION 1435
-- ------------------------------------------
`uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Owner User id',
`created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '',
`updated` datetime DEFAULT '0001-01-01 00:00:00' COMMENT 'Date of last contact update',
- `self` boolean NOT NULL DEFAULT '0' COMMENT '1 if the contact is the user him/her self',
- `remote_self` boolean NOT NULL DEFAULT '0' COMMENT '',
- `rel` tinyint unsigned NOT NULL DEFAULT 0 COMMENT 'The kind of the relation between the user and the contact',
- `duplex` boolean NOT NULL DEFAULT '0' COMMENT '',
`network` char(4) NOT NULL DEFAULT '' COMMENT 'Network of the contact',
- `protocol` char(4) NOT NULL DEFAULT '' COMMENT 'Protocol of the contact',
`name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Name that this contact is known by',
`nick` varchar(255) NOT NULL DEFAULT '' COMMENT 'Nick- and user name of the contact',
`location` varchar(255) DEFAULT '' COMMENT '',
`about` text COMMENT '',
`keywords` text COMMENT 'public keywords (interests) of the contact',
- `gender` varchar(32) NOT NULL DEFAULT '' COMMENT 'Deprecated',
- `xmpp` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `attag` varchar(255) NOT NULL DEFAULT '' COMMENT '',
+ `xmpp` varchar(255) NOT NULL DEFAULT '' COMMENT 'XMPP address',
+ `matrix` varchar(255) NOT NULL DEFAULT '' COMMENT 'Matrix address',
`avatar` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `photo` varchar(255) DEFAULT '' COMMENT 'Link to the profile photo of the contact',
- `thumb` varchar(255) DEFAULT '' COMMENT 'Link to the profile photo (thumb size)',
- `micro` varchar(255) DEFAULT '' COMMENT 'Link to the profile photo (micro size)',
`header` varchar(255) COMMENT 'Header picture',
- `site-pubkey` text COMMENT '',
- `issued-id` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `dfrn-id` varchar(255) NOT NULL DEFAULT '' COMMENT '',
`url` varchar(255) NOT NULL DEFAULT '' COMMENT '',
`nurl` varchar(255) NOT NULL DEFAULT '' COMMENT '',
`uri-id` int unsigned COMMENT 'Id of the item-uri table entry that contains the contact url',
`pubkey` text COMMENT 'RSA public key 4096 bit',
`prvkey` text COMMENT 'RSA private key 4096 bit',
`batch` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `request` varchar(255) COMMENT '',
`notify` varchar(255) COMMENT '',
`poll` varchar(255) COMMENT '',
- `confirm` varchar(255) COMMENT '',
`subscribe` varchar(255) COMMENT '',
- `poco` varchar(255) COMMENT '',
- `aes_allow` boolean NOT NULL DEFAULT '0' COMMENT '',
- `ret-aes` boolean NOT NULL DEFAULT '0' COMMENT '',
- `usehub` boolean NOT NULL DEFAULT '0' COMMENT '',
- `subhub` boolean NOT NULL DEFAULT '0' COMMENT '',
- `hub-verify` varchar(255) NOT NULL DEFAULT '' COMMENT '',
`last-update` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Date of the last try to update the contact info',
`success_update` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Date of the last successful contact update',
`failure_update` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Date of the last failed update',
`failed` boolean COMMENT 'Connection failed',
- `name-date` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '',
- `uri-date` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '',
- `avatar-date` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '',
`term-date` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '',
`last-item` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'date of the last post',
`last-discovery` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'date of the last follower discovery',
- `priority` tinyint unsigned NOT NULL DEFAULT 0 COMMENT '',
`blocked` boolean NOT NULL DEFAULT '1' COMMENT 'Node-wide block status',
`block_reason` text COMMENT 'Node-wide block reason',
`readonly` boolean NOT NULL DEFAULT '0' COMMENT 'posts of the contact are readonly',
- `writable` boolean NOT NULL DEFAULT '0' COMMENT '',
- `forum` boolean NOT NULL DEFAULT '0' COMMENT 'contact is a forum',
- `prv` boolean NOT NULL DEFAULT '0' COMMENT 'contact is a private group',
- `contact-type` tinyint NOT NULL DEFAULT 0 COMMENT '',
- `manually-approve` boolean COMMENT '',
- `hidden` boolean NOT NULL DEFAULT '0' COMMENT '',
+ `contact-type` tinyint NOT NULL DEFAULT 0 COMMENT 'Person, organisation, news, community, relay',
+ `manually-approve` boolean COMMENT 'Contact requests have to be approved manually',
`archive` boolean NOT NULL DEFAULT '0' COMMENT '',
- `pending` boolean NOT NULL DEFAULT '1' COMMENT '',
- `deleted` boolean NOT NULL DEFAULT '0' COMMENT 'Contact has been deleted',
- `rating` tinyint NOT NULL DEFAULT 0 COMMENT '',
`unsearchable` boolean NOT NULL DEFAULT '0' COMMENT 'Contact prefers to not be searchable',
`sensitive` boolean NOT NULL DEFAULT '0' COMMENT 'Contact posts sensitive content',
`baseurl` varchar(255) DEFAULT '' COMMENT 'baseurl of the contact',
`gsid` int unsigned COMMENT 'Global Server ID',
+ `bd` date NOT NULL DEFAULT '0001-01-01' COMMENT '',
`reason` text COMMENT '',
- `closeness` tinyint unsigned NOT NULL DEFAULT 99 COMMENT '',
+ `self` boolean NOT NULL DEFAULT '0' COMMENT '1 if the contact is the user him/her self',
+ `remote_self` boolean NOT NULL DEFAULT '0' COMMENT '',
+ `rel` tinyint unsigned NOT NULL DEFAULT 0 COMMENT 'The kind of the relation between the user and the contact',
+ `protocol` char(4) NOT NULL DEFAULT '' COMMENT 'Protocol of the contact',
+ `subhub` boolean NOT NULL DEFAULT '0' COMMENT '',
+ `hub-verify` varchar(255) NOT NULL DEFAULT '' COMMENT '',
+ `rating` tinyint NOT NULL DEFAULT 0 COMMENT 'Automatically detected feed poll frequency',
+ `priority` tinyint unsigned NOT NULL DEFAULT 0 COMMENT 'Feed poll priority',
+ `attag` varchar(255) NOT NULL DEFAULT '' COMMENT '',
+ `hidden` boolean NOT NULL DEFAULT '0' COMMENT '',
+ `pending` boolean NOT NULL DEFAULT '1' COMMENT 'Contact request is pending',
+ `deleted` boolean NOT NULL DEFAULT '0' COMMENT 'Contact has been deleted',
`info` mediumtext COMMENT '',
- `profile-id` int unsigned COMMENT 'Deprecated',
- `bdyear` varchar(4) NOT NULL DEFAULT '' COMMENT '',
- `bd` date NOT NULL DEFAULT '0001-01-01' COMMENT '',
`notify_new_posts` boolean NOT NULL DEFAULT '0' COMMENT '',
`fetch_further_information` tinyint unsigned NOT NULL DEFAULT 0 COMMENT '',
`ffi_keyword_denylist` text COMMENT '',
+ `photo` varchar(255) DEFAULT '' COMMENT 'Link to the profile photo of the contact',
+ `thumb` varchar(255) DEFAULT '' COMMENT 'Link to the profile photo (thumb size)',
+ `micro` varchar(255) DEFAULT '' COMMENT 'Link to the profile photo (micro size)',
+ `name-date` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '',
+ `uri-date` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '',
+ `avatar-date` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '',
+ `request` varchar(255) COMMENT '',
+ `confirm` varchar(255) COMMENT '',
+ `poco` varchar(255) COMMENT '',
+ `writable` boolean NOT NULL DEFAULT '0' COMMENT '',
+ `forum` boolean NOT NULL DEFAULT '0' COMMENT 'contact is a forum. Deprecated, use \'contact-type\' = \'community\' and \'manually-approve\' = false instead',
+ `prv` boolean NOT NULL DEFAULT '0' COMMENT 'contact is a private group. Deprecated, use \'contact-type\' = \'community\' and \'manually-approve\' = true instead',
+ `bdyear` varchar(4) NOT NULL DEFAULT '' COMMENT '',
+ `site-pubkey` text COMMENT 'Deprecated',
+ `gender` varchar(32) NOT NULL DEFAULT '' COMMENT 'Deprecated',
+ `duplex` boolean NOT NULL DEFAULT '0' COMMENT 'Deprecated',
+ `issued-id` varchar(255) NOT NULL DEFAULT '' COMMENT 'Deprecated',
+ `dfrn-id` varchar(255) NOT NULL DEFAULT '' COMMENT 'Deprecated',
+ `aes_allow` boolean NOT NULL DEFAULT '0' COMMENT 'Deprecated',
+ `ret-aes` boolean NOT NULL DEFAULT '0' COMMENT 'Deprecated',
+ `usehub` boolean NOT NULL DEFAULT '0' COMMENT 'Deprecated',
+ `closeness` tinyint unsigned NOT NULL DEFAULT 99 COMMENT 'Deprecated',
+ `profile-id` int unsigned COMMENT 'Deprecated',
PRIMARY KEY(`id`),
INDEX `uid_name` (`uid`,`name`(190)),
INDEX `self_uid` (`self`,`uid`),
INDEX `nurl_uid` (`nurl`(128),`uid`),
INDEX `nick_uid` (`nick`(128),`uid`),
INDEX `attag_uid` (`attag`(96),`uid`),
- INDEX `dfrn-id` (`dfrn-id`(64)),
- INDEX `issued-id` (`issued-id`(64)),
INDEX `network_uid_lastupdate` (`network`,`uid`,`last-update`),
INDEX `uid_network_self_lastupdate` (`uid`,`network`,`self`,`last-update`),
INDEX `uid_lastitem` (`uid`,`last-item`),
INDEX `url` (`url`)
) DEFAULT COLLATE utf8mb4_general_ci COMMENT='tags and mentions';
---
--- TABLE clients
---
-CREATE TABLE IF NOT EXISTS `clients` (
- `client_id` varchar(20) NOT NULL COMMENT '',
- `pw` varchar(20) NOT NULL DEFAULT '' COMMENT '',
- `redirect_uri` varchar(200) NOT NULL DEFAULT '' COMMENT '',
- `name` text COMMENT '',
- `icon` text COMMENT '',
- `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'User id',
- PRIMARY KEY(`client_id`),
- INDEX `uid` (`uid`),
- FOREIGN KEY (`uid`) REFERENCES `user` (`uid`) ON UPDATE RESTRICT ON DELETE CASCADE
-) DEFAULT COLLATE utf8mb4_general_ci COMMENT='OAuth usage';
-
--
-- TABLE permissionset
--
`nick` varchar(255) NOT NULL DEFAULT '' COMMENT '',
`name` varchar(255) COMMENT '',
`about` text COMMENT '',
+ `xmpp` varchar(255) COMMENT 'XMPP address',
+ `matrix` varchar(255) COMMENT 'Matrix address',
`photo` varchar(255) COMMENT '',
`header` varchar(255) COMMENT 'Header picture',
`addr` varchar(255) COMMENT '',
FOREIGN KEY (`uid`) REFERENCES `user` (`uid`) ON UPDATE RESTRICT ON DELETE CASCADE
) DEFAULT COLLATE utf8mb4_general_ci COMMENT='file attachments';
---
--- TABLE auth_codes
---
-CREATE TABLE IF NOT EXISTS `auth_codes` (
- `id` varchar(40) NOT NULL COMMENT '',
- `client_id` varchar(20) NOT NULL DEFAULT '' COMMENT '',
- `redirect_uri` varchar(200) NOT NULL DEFAULT '' COMMENT '',
- `expires` int NOT NULL DEFAULT 0 COMMENT '',
- `scope` varchar(250) NOT NULL DEFAULT '' COMMENT '',
- PRIMARY KEY(`id`),
- INDEX `client_id` (`client_id`),
- FOREIGN KEY (`client_id`) REFERENCES `clients` (`client_id`) ON UPDATE RESTRICT ON DELETE CASCADE
-) DEFAULT COLLATE utf8mb4_general_ci COMMENT='OAuth usage';
-
--
-- TABLE cache
--
INDEX `k_expires` (`k`,`expires`)
) DEFAULT COLLATE utf8mb4_general_ci COMMENT='Stores temporary data';
---
--- TABLE challenge
---
-CREATE TABLE IF NOT EXISTS `challenge` (
- `id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID',
- `challenge` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `dfrn-id` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `expire` int unsigned NOT NULL DEFAULT 0 COMMENT '',
- `type` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `last_update` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- PRIMARY KEY(`id`),
- INDEX `expire` (`expire`)
-) DEFAULT COLLATE utf8mb4_general_ci COMMENT='';
-
--
-- TABLE config
--
INDEX `received` (`received`)
) DEFAULT COLLATE utf8mb4_general_ci COMMENT='Raw data and structure information for messages';
+--
+-- TABLE workerqueue
+--
+CREATE TABLE IF NOT EXISTS `workerqueue` (
+ `id` int unsigned NOT NULL auto_increment COMMENT 'Auto incremented worker task id',
+ `command` varchar(100) COMMENT 'Task command',
+ `parameter` mediumtext COMMENT 'Task parameter',
+ `priority` tinyint unsigned NOT NULL DEFAULT 0 COMMENT 'Task priority',
+ `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Creation date',
+ `pid` int unsigned NOT NULL DEFAULT 0 COMMENT 'Process id of the worker',
+ `executed` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Execution date',
+ `next_try` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Next retrial date',
+ `retrial` tinyint NOT NULL DEFAULT 0 COMMENT 'Retrial counter',
+ `done` boolean NOT NULL DEFAULT '0' COMMENT 'Marked 1 when the task was done - will be deleted later',
+ PRIMARY KEY(`id`),
+ INDEX `command` (`command`),
+ INDEX `done_command_parameter` (`done`,`command`,`parameter`(64)),
+ INDEX `done_executed` (`done`,`executed`),
+ INDEX `done_priority_retrial_created` (`done`,`priority`,`retrial`,`created`),
+ INDEX `done_priority_next_try` (`done`,`priority`,`next_try`),
+ INDEX `done_pid_next_try` (`done`,`pid`,`next_try`),
+ INDEX `done_pid_retrial` (`done`,`pid`,`retrial`),
+ INDEX `done_pid_priority_created` (`done`,`pid`,`priority`,`created`)
+) DEFAULT COLLATE utf8mb4_general_ci COMMENT='Background tasks queue entries';
+
--
-- TABLE delayed-post
--
`uri` varchar(255) COMMENT 'URI of the post that will be distributed later',
`uid` mediumint unsigned COMMENT 'Owner User id',
`delayed` datetime COMMENT 'delay time',
+ `wid` int unsigned COMMENT 'Workerqueue id',
PRIMARY KEY(`id`),
UNIQUE INDEX `uid_uri` (`uid`,`uri`(190)),
- FOREIGN KEY (`uid`) REFERENCES `user` (`uid`) ON UPDATE RESTRICT ON DELETE CASCADE
+ INDEX `wid` (`wid`),
+ FOREIGN KEY (`uid`) REFERENCES `user` (`uid`) ON UPDATE RESTRICT ON DELETE CASCADE,
+ FOREIGN KEY (`wid`) REFERENCES `workerqueue` (`id`) ON UPDATE RESTRICT ON DELETE CASCADE
) DEFAULT COLLATE utf8mb4_general_ci COMMENT='Posts that are about to be distributed at a later time';
--
`education` text COMMENT 'Deprecated',
`contact` text COMMENT 'Deprecated',
`homepage` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `xmpp` varchar(255) NOT NULL DEFAULT '' COMMENT '',
+ `xmpp` varchar(255) NOT NULL DEFAULT '' COMMENT 'XMPP address',
+ `matrix` varchar(255) NOT NULL DEFAULT '' COMMENT 'Matrix address',
`photo` varchar(255) NOT NULL DEFAULT '' COMMENT '',
`thumb` varchar(255) NOT NULL DEFAULT '' COMMENT '',
`publish` boolean NOT NULL DEFAULT '0' COMMENT 'publish default profile in local directory',
FOREIGN KEY (`uid`) REFERENCES `user` (`uid`) ON UPDATE RESTRICT ON DELETE CASCADE
) DEFAULT COLLATE utf8mb4_general_ci COMMENT='user profiles data';
---
--- TABLE profile_check
---
-CREATE TABLE IF NOT EXISTS `profile_check` (
- `id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID',
- `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'User id',
- `cid` int unsigned NOT NULL DEFAULT 0 COMMENT 'contact.id',
- `dfrn_id` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `sec` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `expire` int unsigned NOT NULL DEFAULT 0 COMMENT '',
- PRIMARY KEY(`id`),
- INDEX `uid` (`uid`),
- INDEX `cid` (`cid`),
- FOREIGN KEY (`uid`) REFERENCES `user` (`uid`) ON UPDATE RESTRICT ON DELETE CASCADE,
- FOREIGN KEY (`cid`) REFERENCES `contact` (`id`) ON UPDATE RESTRICT ON DELETE CASCADE
-) DEFAULT COLLATE utf8mb4_general_ci COMMENT='DFRN remote auth use';
-
--
-- TABLE profile_field
--
) DEFAULT COLLATE utf8mb4_general_ci COMMENT='Data stored by Database storage backend';
--
--- TABLE tokens
+-- TABLE subscription
--
-CREATE TABLE IF NOT EXISTS `tokens` (
- `id` varchar(40) NOT NULL COMMENT '',
- `secret` text COMMENT '',
- `client_id` varchar(20) NOT NULL DEFAULT '',
- `expires` int NOT NULL DEFAULT 0 COMMENT '',
- `scope` varchar(200) NOT NULL DEFAULT '' COMMENT '',
- `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'User id',
+CREATE TABLE IF NOT EXISTS `subscription` (
+ `id` int unsigned NOT NULL auto_increment COMMENT 'Auto incremented image data id',
+ `application-id` int unsigned NOT NULL COMMENT '',
+ `uid` mediumint unsigned NOT NULL COMMENT 'Owner User id',
+ `endpoint` varchar(511) COMMENT 'Endpoint URL',
+ `pubkey` varchar(127) COMMENT 'User agent public key',
+ `secret` varchar(32) COMMENT 'Auth secret',
+ `follow` boolean COMMENT '',
+ `favourite` boolean COMMENT '',
+ `reblog` boolean COMMENT '',
+ `mention` boolean COMMENT '',
+ `poll` boolean COMMENT '',
+ `follow_request` boolean COMMENT '',
+ `status` boolean COMMENT '',
PRIMARY KEY(`id`),
- INDEX `client_id` (`client_id`),
- INDEX `uid` (`uid`),
- FOREIGN KEY (`client_id`) REFERENCES `clients` (`client_id`) ON UPDATE RESTRICT ON DELETE CASCADE,
+ UNIQUE INDEX `application-id_uid` (`application-id`,`uid`),
+ INDEX `uid_application-id` (`uid`,`application-id`),
+ FOREIGN KEY (`application-id`) REFERENCES `application` (`id`) ON UPDATE RESTRICT ON DELETE CASCADE,
FOREIGN KEY (`uid`) REFERENCES `user` (`uid`) ON UPDATE RESTRICT ON DELETE CASCADE
-) DEFAULT COLLATE utf8mb4_general_ci COMMENT='OAuth usage';
+) DEFAULT COLLATE utf8mb4_general_ci COMMENT='Push Subscription for the API';
--
-- TABLE userd
CREATE TABLE IF NOT EXISTS `user-contact` (
`cid` int unsigned NOT NULL DEFAULT 0 COMMENT 'Contact id of the linked public contact',
`uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'User id',
+ `uri-id` int unsigned COMMENT 'Id of the item-uri table entry that contains the contact url',
`blocked` boolean COMMENT 'Contact is completely blocked for this user',
`ignored` boolean COMMENT 'Posts from this contact are ignored',
`collapsed` boolean COMMENT 'Posts from this contact are collapsed',
+ `pending` boolean COMMENT '',
+ `rel` tinyint unsigned COMMENT 'The kind of the relation between the user and the contact',
+ `info` mediumtext COMMENT '',
+ `notify_new_posts` boolean COMMENT '',
+ `remote_self` boolean COMMENT '',
+ `fetch_further_information` tinyint unsigned COMMENT '',
+ `ffi_keyword_denylist` text COMMENT '',
+ `subhub` boolean COMMENT '',
+ `hub-verify` varchar(255) COMMENT '',
+ `protocol` char(4) COMMENT 'Protocol of the contact',
+ `rating` tinyint COMMENT 'Automatically detected feed poll frequency',
+ `priority` tinyint unsigned COMMENT 'Feed poll priority',
PRIMARY KEY(`uid`,`cid`),
INDEX `cid` (`cid`),
+ UNIQUE INDEX `uri-id_uid` (`uri-id`,`uid`),
FOREIGN KEY (`cid`) REFERENCES `contact` (`id`) ON UPDATE RESTRICT ON DELETE CASCADE,
- FOREIGN KEY (`uid`) REFERENCES `user` (`uid`) ON UPDATE RESTRICT ON DELETE CASCADE
+ FOREIGN KEY (`uid`) REFERENCES `user` (`uid`) ON UPDATE RESTRICT ON DELETE CASCADE,
+ FOREIGN KEY (`uri-id`) REFERENCES `item-uri` (`id`) ON UPDATE RESTRICT ON DELETE CASCADE
) DEFAULT COLLATE utf8mb4_general_ci COMMENT='User specific public contact data';
--
PRIMARY KEY(`key`)
) ENGINE=MEMORY DEFAULT COLLATE utf8mb4_general_ci COMMENT='Inter process communication between the frontend and the worker';
---
--- TABLE workerqueue
---
-CREATE TABLE IF NOT EXISTS `workerqueue` (
- `id` int unsigned NOT NULL auto_increment COMMENT 'Auto incremented worker task id',
- `command` varchar(100) COMMENT 'Task command',
- `parameter` mediumtext COMMENT 'Task parameter',
- `priority` tinyint unsigned NOT NULL DEFAULT 0 COMMENT 'Task priority',
- `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Creation date',
- `pid` int unsigned NOT NULL DEFAULT 0 COMMENT 'Process id of the worker',
- `executed` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Execution date',
- `next_try` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Next retrial date',
- `retrial` tinyint NOT NULL DEFAULT 0 COMMENT 'Retrial counter',
- `done` boolean NOT NULL DEFAULT '0' COMMENT 'Marked 1 when the task was done - will be deleted later',
- PRIMARY KEY(`id`),
- INDEX `command` (`command`),
- INDEX `done_command_parameter` (`done`,`command`,`parameter`(64)),
- INDEX `done_executed` (`done`,`executed`),
- INDEX `done_priority_retrial_created` (`done`,`priority`,`retrial`,`created`),
- INDEX `done_priority_next_try` (`done`,`priority`,`next_try`),
- INDEX `done_pid_next_try` (`done`,`pid`,`next_try`),
- INDEX `done_pid_retrial` (`done`,`pid`,`retrial`),
- INDEX `done_pid_priority_created` (`done`,`pid`,`priority`,`created`)
-) DEFAULT COLLATE utf8mb4_general_ci COMMENT='Background tasks queue entries';
-
--
-- VIEW application-view
--
`contact`.`uri-date` AS `uri-date`,
`contact`.`avatar-date` AS `avatar-date`,
`contact`.`thumb` AS `thumb`,
- `contact`.`dfrn-id` AS `dfrn-id`,
`post-user`.`author-id` AS `author-id`,
`author`.`url` AS `author-link`,
`author`.`addr` AS `author-addr`,
`contact`.`uri-date` AS `uri-date`,
`contact`.`avatar-date` AS `avatar-date`,
`contact`.`thumb` AS `thumb`,
- `contact`.`dfrn-id` AS `dfrn-id`,
`post-thread-user`.`author-id` AS `author-id`,
`author`.`url` AS `author-link`,
`author`.`addr` AS `author-addr`,
`author`.`uri-date` AS `uri-date`,
`author`.`avatar-date` AS `avatar-date`,
`author`.`thumb` AS `thumb`,
- `author`.`dfrn-id` AS `dfrn-id`,
`post`.`author-id` AS `author-id`,
`author`.`url` AS `author-link`,
`author`.`addr` AS `author-addr`,
`author`.`uri-date` AS `uri-date`,
`author`.`avatar-date` AS `avatar-date`,
`author`.`thumb` AS `thumb`,
- `author`.`dfrn-id` AS `dfrn-id`,
`post-thread`.`author-id` AS `author-id`,
`author`.`url` AS `author-link`,
`author`.`addr` AS `author-addr`,
`contact`.`self` AS `self`,
`contact`.`remote_self` AS `remote_self`,
`contact`.`rel` AS `rel`,
- `contact`.`duplex` AS `duplex`,
`contact`.`network` AS `network`,
`contact`.`protocol` AS `protocol`,
`contact`.`name` AS `name`,
`contact`.`location` AS `location`,
`contact`.`about` AS `about`,
`contact`.`keywords` AS `keywords`,
- `contact`.`gender` AS `gender`,
`contact`.`xmpp` AS `xmpp`,
+ `contact`.`matrix` AS `matrix`,
`contact`.`attag` AS `attag`,
`contact`.`avatar` AS `avatar`,
`contact`.`photo` AS `photo`,
`contact`.`thumb` AS `thumb`,
`contact`.`micro` AS `micro`,
`contact`.`header` AS `header`,
- `contact`.`site-pubkey` AS `site-pubkey`,
- `contact`.`issued-id` AS `issued-id`,
- `contact`.`dfrn-id` AS `dfrn-id`,
`contact`.`url` AS `url`,
`contact`.`nurl` AS `nurl`,
`contact`.`uri-id` AS `uri-id`,
`contact`.`poll` AS `poll`,
`contact`.`confirm` AS `confirm`,
`contact`.`poco` AS `poco`,
- `contact`.`aes_allow` AS `aes_allow`,
- `contact`.`ret-aes` AS `ret-aes`,
- `contact`.`usehub` AS `usehub`,
`contact`.`subhub` AS `subhub`,
`contact`.`hub-verify` AS `hub-verify`,
`contact`.`last-update` AS `last-update`,
`contact`.`sensitive` AS `sensitive`,
`contact`.`baseurl` AS `baseurl`,
`contact`.`reason` AS `reason`,
- `contact`.`closeness` AS `closeness`,
`contact`.`info` AS `info`,
- `contact`.`profile-id` AS `profile-id`,
`contact`.`bdyear` AS `bdyear`,
`contact`.`bd` AS `bd`,
`contact`.`notify_new_posts` AS `notify_new_posts`,
`contact`.`about` AS `about`,
`contact`.`keywords` AS `keywords`,
`contact`.`xmpp` AS `xmpp`,
+ `contact`.`matrix` AS `matrix`,
`contact`.`avatar` AS `avatar`,
`contact`.`photo` AS `photo`,
`contact`.`thumb` AS `thumb`,
DROP VIEW IF EXISTS `account-user-view`;
CREATE VIEW `account-user-view` AS SELECT
`ucontact`.`id` AS `id`,
+ `contact`.`id` AS `pid`,
`ucontact`.`uid` AS `uid`,
`contact`.`url` AS `url`,
`contact`.`nurl` AS `nurl`,
`contact`.`about` AS `about`,
`contact`.`keywords` AS `keywords`,
`contact`.`xmpp` AS `xmpp`,
+ `contact`.`matrix` AS `matrix`,
`contact`.`avatar` AS `avatar`,
`contact`.`photo` AS `photo`,
`contact`.`thumb` AS `thumb`,
`contact`.`network` AS `network`,
`ucontact`.`protocol` AS `protocol`,
`contact`.`location` AS `location`,
- `contact`.`attag` AS `attag`,
+ `ucontact`.`attag` AS `attag`,
`contact`.`pubkey` AS `pubkey`,
`contact`.`prvkey` AS `prvkey`,
`contact`.`subscribe` AS `subscribe`,
`contact`.`sensitive` AS `sensitive`,
`contact`.`baseurl` AS `baseurl`,
`contact`.`gsid` AS `gsid`,
- `contact`.`info` AS `info`,
+ `ucontact`.`info` AS `info`,
`contact`.`bdyear` AS `bdyear`,
`contact`.`bd` AS `bd`,
`contact`.`poco` AS `poco`,
`ucontact`.`subhub` AS `subhub`,
`ucontact`.`hub-verify` AS `hub-verify`,
`ucontact`.`reason` AS `reason`,
- `ucontact`.`duplex` AS `dfrn-duplex`,
- `ucontact`.`ret-aes` AS `dfrn-ret-aes`,
- `ucontact`.`site-pubkey` AS `dfrn-site-pubkey`,
- `ucontact`.`issued-id` AS `dfrn-issued-id`,
- `ucontact`.`dfrn-id` AS `dfrn-id`,
- `ucontact`.`aes_allow` AS `dfrn-aes_allow`,
`contact`.`request` AS `dfrn-request`,
`contact`.`notify` AS `dfrn-notify`,
`contact`.`poll` AS `dfrn-poll`,
projects / friendica.git / blobdiff