From 93ecccb8fbac5e82c64fdace31efd47e1139bc06 Mon Sep 17 00:00:00 2001
From: Brenda Wallace <shiny@cpan.org>
Date: Thu, 26 Nov 2009 20:17:32 +1300
Subject: added missing columns in notice table

---
 db/statusnet_pg.sql | 11 ++++++++---
 1 file changed, 8 insertions(+), 3 deletions(-)

(limited to 'db/statusnet_pg.sql')

diff --git a/db/statusnet_pg.sql b/db/statusnet_pg.sql
index 927925753..39f66a1fa 100644
--- a/db/statusnet_pg.sql
+++ b/db/statusnet_pg.sql
@@ -1,4 +1,5 @@
 /* local and remote users have profiles */
+BEGIN;
 
 create sequence profile_seq;
 create table profile (
@@ -132,11 +133,14 @@ create table notice (
     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"' */,
-    conversation integer /*id of root notice in this conversation' */ references notice (id)
-
-
+    conversation integer /*id of root notice in this conversation' */ references notice (id),
+    lat decimal(10,7) /* comment 'latitude'*/ ,
+    lon decimal(10,7) /* comment 'longitude'*/ ,
+    location_id integer /* comment 'location id if possible'*/ ,
+    location_ns integer /* comment 'namespace for location'*/
 /*    FULLTEXT(content) */
 );
+
 create index notice_profile_id_idx on notice using btree(profile_id,created,id);
 create index notice_created_idx on notice using btree(created);
 
@@ -579,3 +583,4 @@ create table login_token (
     primary key (user_id)
 );
 
+ROLLBACK;
-- 
cgit v1.2.3-54-g00ecf

