From 2456baa3bce590e516c27c97344ae83edc5f0b66 Mon Sep 17 00:00:00 2001 From: Brenda Wallace Date: Thu, 25 Jun 2009 22:00:55 +1200 Subject: [PATCH] added missing conversation id to notices --- db/laconica_pg.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/db/laconica_pg.sql b/db/laconica_pg.sql index 622242bdf6..f8362ae935 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) */ -- 2.39.5