diff options
| -rw-r--r-- | db/statusnet_pg.sql | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/db/statusnet_pg.sql b/db/statusnet_pg.sql index 020bfd967..9cb8a944f 100644 --- a/db/statusnet_pg.sql +++ b/db/statusnet_pg.sql @@ -1,3 +1,4 @@ +BEGIN; /* local and remote users have profiles */ create sequence profile_seq; create table profile ( @@ -136,7 +137,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) */ ); @@ -589,3 +590,4 @@ create table login_token ( primary key (user_id) ); +COMMIT; |