From 2456baa3bce590e516c27c97344ae83edc5f0b66 Mon Sep 17 00:00:00 2001
From: Brenda Wallace <shiny@cpan.org>
Date: Thu, 25 Jun 2009 22:00:55 +1200
Subject: added missing conversation id to notices

---
 db/laconica_pg.sql | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'db/laconica_pg.sql')

diff --git a/db/laconica_pg.sql b/db/laconica_pg.sql
index 622242bdf..f8362ae93 100644
--- a/db/laconica_pg.sql
+++ b/db/laconica_pg.sql
@@ -116,7 +116,8 @@ create table notice (
     modified timestamp /* comment 'date this record was modified' */,
     reply_to integer /* comment 'notice replied to (usually a guess)' */ references notice (id) ,
     is_local integer default 0 /* comment 'notice was generated by a user' */,
-    source varchar(32) /* comment 'source of comment, like "web", "im", or "clientname"' */
+    source varchar(32) /* comment 'source of comment, like "web", "im", or "clientname"' */,
+    conversation integer /*id of root notice in this conversation' */ references notice (id)
 
 
 /*    FULLTEXT(content) */
-- 
cgit v1.2.3-54-g00ecf

