From d45ad7bb6b21702260320e3973b3feab11e7124a Mon Sep 17 00:00:00 2001
From: Friendika <info@friendika.com>
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

