diff options
| author | Friendika <info@friendika.com> | 2011-04-27 04:24:00 -0700 |
|---|---|---|
| committer | Friendika <info@friendika.com> | 2011-04-27 04:24:00 -0700 |
| commit | d45ad7bb6b21702260320e3973b3feab11e7124a (patch) | |
| tree | 08ca1916e09ce382ddf8006a1aa88b53f1850821 /database.sql | |
| parent | 61f7b3d754188c6cce75cee4c6c110e8e4e60de0 (diff) | |
| download | volse-hubzilla-d45ad7bb6b21702260320e3973b3feab11e7124a.tar.gz volse-hubzilla-d45ad7bb6b21702260320e3973b3feab11e7124a.tar.bz2 volse-hubzilla-d45ad7bb6b21702260320e3973b3feab11e7124a.zip | |
suppress duplicate FB posts (incoming after posted locally)
Diffstat (limited to 'database.sql')
| -rw-r--r-- | database.sql | 2 |
1 files changed, 2 insertions, 0 deletions
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`), |