X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=database.sql;h=175c48b8c3f88e4c069e3627703c44dedd2cac93;hb=e61ed419728999fcdaf8c79597b0490655e69867;hp=d1c73cc048f3f606932d629760f3f8145188cd47;hpb=6ca5668ac1508ca5170949898e186d923a98d973;p=friendica.git diff --git a/database.sql b/database.sql index d1c73cc048..175c48b8c3 100644 --- a/database.sql +++ b/database.sql @@ -1,6 +1,6 @@ -- ------------------------------------------ -- Friendica 2021.12-rc (Siberian Iris) --- DB_UPDATE_VERSION 1446 +-- DB_UPDATE_VERSION 1447 -- ------------------------------------------ @@ -824,7 +824,8 @@ CREATE TABLE IF NOT EXISTS `notification` ( `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`),