summaryrefslogtreecommitdiff
path: root/db/laconica.sql
diff options
context:
space:
mode:
authorEvan Prodromou <evan@prodromou.name>2008-06-18 03:04:30 -0400
committerEvan Prodromou <evan@prodromou.name>2008-06-18 03:04:30 -0400
commitce64e38804bdc5563d1de5bfc6a75c78c42e6250 (patch)
treee25392c869d0ae23fd5c74ceda7e0b63a8523c8b /db/laconica.sql
parent0299b6f2caa5b3b956c9e00a17d6cf3c72966396 (diff)
user_id in user_openid should not be unique
darcs-hash:20080618070430-84dde-403d695209ab88f2d0c4e54da333698c6fe5883a.gz
Diffstat (limited to 'db/laconica.sql')
-rw-r--r--db/laconica.sql6
1 files changed, 4 insertions, 2 deletions
diff --git a/db/laconica.sql b/db/laconica.sql
index 004448299..03e823d50 100644
--- a/db/laconica.sql
+++ b/db/laconica.sql
@@ -119,9 +119,11 @@ create table nonce (
create table user_openid (
canonical varchar(255) primary key comment 'Canonical true URL',
display varchar(255) not null unique key comment 'URL for viewing, may be different from canonical',
- user_id integer not null unique key comment 'user owning this URL' references user (id),
+ user_id integer not null comment 'user owning this URL' references user (id),
created datetime not null comment 'date this record was created',
- modified timestamp comment 'date this record was modified'
+ modified timestamp comment 'date this record was modified',
+
+ index user_openid_user_id_idx (user_id)
) ENGINE=InnoDB;
/* These are used by JanRain OpenID library */