aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorAbinoam P. Marques Jr <abinoam@gmail.com>2012-02-25 12:33:08 -0800
committerAbinoam P. Marques Jr <abinoam@gmail.com>2012-02-25 16:59:42 -0800
commit3d37a688c71102e8a4b1f4c8ba3d16c0a698c49c (patch)
tree28500041d91479a5aac09e2aad6398092eaa0b1e
parent2c7da5d0de29cd7010bd6a34c0b6cfb79fe24466 (diff)
downloadvolse-hubzilla-3d37a688c71102e8a4b1f4c8ba3d16c0a698c49c.tar.gz
volse-hubzilla-3d37a688c71102e8a4b1f4c8ba3d16c0a698c49c.tar.bz2
volse-hubzilla-3d37a688c71102e8a4b1f4c8ba3d16c0a698c49c.zip
Added notify-threads to database.sql.
-rwxr-xr-xdatabase.sql26
1 files changed, 26 insertions, 0 deletions
diff --git a/database.sql b/database.sql
index f4199cb55..9ad96ca77 100755
--- a/database.sql
+++ b/database.sql
@@ -810,5 +810,31 @@ INDEX ( `uid` )
) ENGINE = MyISAM DEFAULT CHARSET=utf8;
+--
+-- Table structure for table `notify-threads`
+--
+-- notify-id: notify.id of the first notification of this thread
+-- master-parent-item: item.id of the parent item
+-- parent-item: item.id of the imediate parent (only for multi-thread)
+-- not used yet.
+-- receiver-uid: user.uid of the receiver of this notification.
+--
+-- If we query for a master-parent-item and receiver-uid...
+-- * Returns 1 item: this is not the parent notification,
+-- so just "follow" the thread (references to this notification)
+-- * Returns no item: this is the first notification related to
+-- this parent item. So, create the record and use the message-id
+-- header.
+
+
+CREATE TABLE IF NOT EXISTS `notify-threads` (
+`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
+`notify-id` INT NOT NULL,
+`master-parent-item` INT( 10 ) unsigned NOT NULL DEFAULT '0',
+`parent-item` INT( 10 ) unsigned NOT NULL DEFAULT '0',
+`receiver-uid` INT NOT NULL,
+INDEX ( `master-parent-item` ),
+INDEX ( `receiver-uid` )
+) ENGINE = MyISAM DEFAULT CHARSET=utf8;