diff options
| author | Brenda Wallace <shiny@cpan.org> | 2009-06-25 22:00:55 +1200 |
|---|---|---|
| committer | Brenda Wallace <shiny@cpan.org> | 2009-06-25 22:00:55 +1200 |
| commit | 2456baa3bce590e516c27c97344ae83edc5f0b66 (patch) | |
| tree | 580101d6fc241dc6c930be7604b653158d5b3b6a | |
| parent | 72df5c9eb4941eb0770758862e065940e05f2abc (diff) | |
added missing conversation id to notices
| -rw-r--r-- | db/laconica_pg.sql | 3 |
1 files changed, 2 insertions, 1 deletions
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) */
|