summaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
Diffstat (limited to 'db')
-rw-r--r--db/statusnet_pg.sql11
1 files 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;