summaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
Diffstat (limited to 'db')
-rw-r--r--db/statusnet_pg.sql4
1 files changed, 1 insertions, 3 deletions
diff --git a/db/statusnet_pg.sql b/db/statusnet_pg.sql
index 9cb8a944f..020bfd967 100644
--- a/db/statusnet_pg.sql
+++ b/db/statusnet_pg.sql
@@ -1,4 +1,3 @@
-BEGIN;
/* local and remote users have profiles */
create sequence profile_seq;
create table profile (
@@ -137,7 +136,7 @@ create table notice (
lon decimal(10,7) /* comment 'longitude'*/ ,
location_id integer /* comment 'location id if possible'*/ ,
location_ns integer /* comment 'namespace for location'*/ ,
- repeat_of integer /* comment 'notice this is a repeat of' */ references notice (id)
+ repeat_of integer /* comment 'notice this is a repeat of' */ references notice (id) ,
/* FULLTEXT(content) */
);
@@ -590,4 +589,3 @@ create table login_token (
primary key (user_id)
);
-COMMIT;