-- ------------------------------------------
--- Friendica 2021.12-dev (Siberian Iris)
--- DB_UPDATE_VERSION 1440
+-- Friendica 2021.12-rc (Siberian Iris)
+-- DB_UPDATE_VERSION 1449
-- ------------------------------------------
`alias` varchar(255) NOT NULL DEFAULT '' COMMENT '',
`pubkey` text COMMENT '',
`updated` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '',
+ `interacting_count` int unsigned DEFAULT 0 COMMENT 'Number of contacts this contact interactes with',
+ `interacted_count` int unsigned DEFAULT 0 COMMENT 'Number of contacts that interacted with this contact',
+ `post_count` int unsigned DEFAULT 0 COMMENT 'Number of posts and comments',
PRIMARY KEY(`id`),
INDEX `addr` (`addr`(32)),
UNIQUE INDEX `url` (`url`(190)),
UNIQUE INDEX `hook_file_function` (`hook`,`file`,`function`)
) DEFAULT COLLATE utf8mb4_general_ci COMMENT='addon hook registry';
---
--- TABLE host
---
-CREATE TABLE IF NOT EXISTS `host` (
- `id` tinyint unsigned NOT NULL auto_increment COMMENT 'sequential ID',
- `name` varchar(128) NOT NULL DEFAULT '' COMMENT 'The hostname',
- PRIMARY KEY(`id`),
- UNIQUE INDEX `name` (`name`)
-) DEFAULT COLLATE utf8mb4_general_ci COMMENT='Hostname';
-
--
-- TABLE inbox-status
--
`contact-id` int unsigned NOT NULL DEFAULT 0 COMMENT '',
`suggest-cid` int unsigned COMMENT 'Suggested contact',
`knowyou` boolean NOT NULL DEFAULT '0' COMMENT '',
- `duplex` boolean NOT NULL DEFAULT '0' COMMENT '',
+ `duplex` boolean NOT NULL DEFAULT '0' COMMENT 'deprecated',
`note` text COMMENT '',
`hash` varchar(255) NOT NULL DEFAULT '' COMMENT '',
`datetime` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '',
- `blocked` boolean NOT NULL DEFAULT '1' COMMENT '',
+ `blocked` boolean NOT NULL DEFAULT '0' COMMENT 'deprecated',
`ignore` boolean NOT NULL DEFAULT '0' COMMENT '',
PRIMARY KEY(`id`),
INDEX `contact-id` (`contact-id`),
+ INDEX `suggest-cid` (`suggest-cid`),
INDEX `uid` (`uid`),
FOREIGN KEY (`uid`) REFERENCES `user` (`uid`) ON UPDATE RESTRICT ON DELETE CASCADE,
FOREIGN KEY (`contact-id`) REFERENCES `contact` (`id`) ON UPDATE RESTRICT ON DELETE CASCADE,
`target-uri-id` int unsigned COMMENT 'Item-uri id of the related post',
`parent-uri-id` int unsigned COMMENT 'Item-uri id of the parent of the related post',
`created` datetime COMMENT '',
- `seen` boolean DEFAULT '0' COMMENT '',
+ `seen` boolean DEFAULT '0' COMMENT 'Seen on the desktop',
+ `dismissed` boolean DEFAULT '0' COMMENT 'Dismissed via the API',
PRIMARY KEY(`id`),
UNIQUE INDEX `uid_vid_type_actor-id_target-uri-id` (`uid`,`vid`,`type`,`actor-id`,`target-uri-id`),
INDEX `vid` (`vid`),
-- TABLE process
--
CREATE TABLE IF NOT EXISTS `process` (
- `pid` int unsigned NOT NULL COMMENT '',
+ `pid` int unsigned NOT NULL COMMENT 'The ID of the process',
+ `hostname` varchar(32) NOT NULL COMMENT 'The name of the host the process is ran on',
`command` varbinary(32) NOT NULL DEFAULT '' COMMENT '',
`created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '',
- PRIMARY KEY(`pid`),
+ PRIMARY KEY(`pid`,`hostname`),
INDEX `command` (`command`)
) DEFAULT COLLATE utf8mb4_general_ci COMMENT='Currently running system processes';
`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',
+ `hidden` boolean COMMENT 'This contact is hidden from the others',
`pending` boolean COMMENT '',
`rel` tinyint unsigned COMMENT 'The kind of the relation between the user and the contact',
`info` mediumtext COMMENT '',
`post-content`.`title` AS `title`,
`post-content`.`content-warning` AS `content-warning`,
`post-content`.`raw-body` AS `raw-body`,
- `post-content`.`body` AS `body`,
+ IFNULL (`post-content`.`body`, '') AS `body`,
`post-content`.`rendered-hash` AS `rendered-hash`,
`post-content`.`rendered-html` AS `rendered-html`,
`post-content`.`language` AS `language`,
`parent-post`.`author-id` AS `parent-author-id`,
`parent-post-author`.`url` AS `parent-author-link`,
`parent-post-author`.`name` AS `parent-author-name`,
+ `parent-post-author`.`nick` AS `parent-author-nick`,
`parent-post-author`.`network` AS `parent-author-network`,
`parent-post-author`.`blocked` AS `parent-author-blocked`,
`parent-post-author`.`hidden` AS `parent-author-hidden`
-- VIEW profile_field-view
--
DROP VIEW IF EXISTS `profile_field-view`;
-CREATE VIEW `profile_field-view` AS SELECT
- `profile_field`.`id` AS `id`,
- `profile_field`.`uid` AS `uid`,
- `profile_field`.`label` AS `label`,
- `profile_field`.`value` AS `value`,
- `profile_field`.`order` AS `order`,
- `profile_field`.`psid` AS `psid`,
- `permissionset`.`allow_cid` AS `allow_cid`,
- `permissionset`.`allow_gid` AS `allow_gid`,
- `permissionset`.`deny_cid` AS `deny_cid`,
- `permissionset`.`deny_gid` AS `deny_gid`,
- `profile_field`.`created` AS `created`,
- `profile_field`.`edited` AS `edited`
- FROM `profile_field`
- INNER JOIN `permissionset` ON `permissionset`.`id` = `profile_field`.`psid`;
+CREATE VIEW `profile_field-view` AS SELECT
+ `profile_field`.`id` AS `id`,
+ `profile_field`.`uid` AS `uid`,
+ `profile_field`.`label` AS `label`,
+ `profile_field`.`value` AS `value`,
+ `profile_field`.`order` AS `order`,
+ `profile_field`.`psid` AS `psid`,
+ `permissionset`.`allow_cid` AS `allow_cid`,
+ `permissionset`.`allow_gid` AS `allow_gid`,
+ `permissionset`.`deny_cid` AS `deny_cid`,
+ `permissionset`.`deny_gid` AS `deny_gid`,
+ `profile_field`.`created` AS `created`,
+ `profile_field`.`edited` AS `edited`
+ FROM `profile_field`
+ INNER JOIN `permissionset` ON `permissionset`.`id` = `profile_field`.`psid`;
projects / friendica.git / blobdiff