Merge remote-tracking branch 'upstream/2022.09-rc' into quote-again

[friendica.git] / database.sql

diff --git a/database.sql b/database.sql
index 75d31f291e7051008a14a5e9ae209b92c7f46ef7..48de2fcaef848dce71d36db99948010eb6d9dc6c 100644 (file)
--- a/database.sql
+++ b/database.sql
@@ -639,6 +639,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',