From 93ecccb8fbac5e82c64fdace31efd47e1139bc06 Mon Sep 17 00:00:00 2001 From: Brenda Wallace 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(-) 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