X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=database.sql;h=010b64542a8e276ff95d1224f3dd0524077740dc;hb=e5c24f33f0c3c51a153a23612fed88be660d0de0;hp=b76a4e0206005444354908fe7b2a978652fc39ae;hpb=934a3a6721ee40b8d658dc8a38a530642283bf47;p=friendica.git diff --git a/database.sql b/database.sql index b76a4e0206..010b64542a 100644 --- a/database.sql +++ b/database.sql @@ -1,6 +1,6 @@ -- ------------------------------------------ -- Friendica 2022.09-rc (Giant Rhubarb) --- DB_UPDATE_VERSION 1482 +-- DB_UPDATE_VERSION 1483 -- ------------------------------------------ @@ -625,6 +625,7 @@ CREATE TABLE IF NOT EXISTS `fcontact` ( `network` char(4) NOT NULL DEFAULT '' COMMENT '', `alias` varbinary(383) NOT NULL DEFAULT '' COMMENT '', `pubkey` text COMMENT '', + `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' 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',