summaryrefslogtreecommitdiff
path: root/db/laconica_pg.sql
diff options
context:
space:
mode:
authorCiaranG <ciaran@ciarang.com>2008-09-24 07:35:50 -0400
committerCiaranG <ciaran@ciarang.com>2008-09-24 07:35:50 -0400
commitca4f358362e065a250f6b636fb847927219b95d1 (patch)
tree6b5177d862bb13f1555ab2ed8afdbd9c73f94cce /db/laconica_pg.sql
parentcfc8a47bf11d4427d0a06d746691cfc92c696837 (diff)
PostgreSQL: Corrections to the two new table definitions
darcs-hash:20080924113550-f6e2c-8791d68684424ef028049ee9ed95b3853dd8f770.gz
Diffstat (limited to 'db/laconica_pg.sql')
-rw-r--r--db/laconica_pg.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/db/laconica_pg.sql b/db/laconica_pg.sql
index b7ef57d27..24ba0a99a 100644
--- a/db/laconica_pg.sql
+++ b/db/laconica_pg.sql
@@ -290,7 +290,7 @@ create index foreign_subscription_subscribed_idx on foreign_subscription using b
create table invitation (
code varchar(32) not null primary key /* comment 'random code for an invitation' */,
- user_id int not null /* comment 'who sent the invitation' */ references user (id),
+ user_id int not null /* comment 'who sent the invitation' */ references "user" (id),
address varchar(255) not null /* comment 'invitation sent to' */,
address_type varchar(8) not null /* comment 'address type ("email", "jabber", "sms") '*/,
created timestamp not null /* comment 'date this record was created' */
@@ -302,7 +302,7 @@ create index invitation_user_id_idx on invitation using btree(user_id);
create table message (
id serial primary key /* comment 'unique identifier' */,
- uri varchar(255) unique key /* comment 'universally unique identifier' */,
+ uri varchar(255) unique /* comment 'universally unique identifier' */,
from_profile integer not null /* comment 'who the message is from' */ references profile (id),
to_profile integer not null /* comment 'who the message is to' */ references profile (id),
content varchar(140) /* comment 'message content' */,