From d45ad7bb6b21702260320e3973b3feab11e7124a Mon Sep 17 00:00:00 2001 From: Friendika Date: Wed, 27 Apr 2011 04:24:00 -0700 Subject: suppress duplicate FB posts (incoming after posted locally) --- database.sql | 2 ++ 1 file changed, 2 insertions(+) (limited to 'database.sql') diff --git a/database.sql b/database.sql index 84bb42ff3..c15a9ad9c 100644 --- a/database.sql +++ b/database.sql @@ -166,6 +166,7 @@ CREATE TABLE IF NOT EXISTS `item` ( `gravity` tinyint(1) NOT NULL DEFAULT '0', `parent` int(10) unsigned NOT NULL DEFAULT '0', `parent-uri` char(255) NOT NULL, + `extid` char(255) NOT NULL, `thr-parent` char(255) NOT NULL, `created` datetime NOT NULL, `edited` datetime NOT NULL, @@ -208,6 +209,7 @@ CREATE TABLE IF NOT EXISTS `item` ( KEY `wall` (`wall`), KEY `parent` (`parent`), KEY `parent-uri` (`parent-uri`), + KEY `extid` (`extid`), KEY `created` (`created`), KEY `edited` (`edited`), KEY `visible` (`visible`), -- cgit v1.2.3