X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=database.sql;h=010b64542a8e276ff95d1224f3dd0524077740dc;hb=e5c24f33f0c3c51a153a23612fed88be660d0de0;hp=e1ca686d47896547e0b58a196f1dbcedb826fda9;hpb=da658cbf1dc1b2e53b6c9c47d56d89aaa6587ab1;p=friendica.git

diff --git a/database.sql b/database.sql
index e1ca686d47..010b64542a 100644
--- a/database.sql
+++ b/database.sql
@@ -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',
@@ -1007,20 +1008,6 @@ CREATE TABLE IF NOT EXISTS `openwebauth-token` (
 	FOREIGN KEY (`uid`) REFERENCES `user` (`uid`) ON UPDATE RESTRICT ON DELETE CASCADE
 ) DEFAULT COLLATE utf8mb4_general_ci COMMENT='Store OpenWebAuth token to verify contacts';
 
---
--- TABLE pagecache
---
-CREATE TABLE IF NOT EXISTS `pagecache` (
-	`page` varbinary(255) NOT NULL COMMENT 'Page',
-	`uri-id` int unsigned COMMENT 'Id of the item-uri table that contains the uri the page belongs to',
-	`content` mediumtext COMMENT 'Page content',
-	`fetched` datetime COMMENT 'date when the page had been fetched',
-	 PRIMARY KEY(`page`),
-	 INDEX `fetched` (`fetched`),
-	 INDEX `uri-id` (`uri-id`),
-	FOREIGN KEY (`uri-id`) REFERENCES `item-uri` (`id`) ON UPDATE RESTRICT ON DELETE CASCADE
-) DEFAULT COLLATE utf8mb4_general_ci COMMENT='Stores temporary data';
-
 --
 -- TABLE parsed_url
 --