summaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
authorEvan Prodromou <evan@controlyourself.ca>2008-10-22 15:27:50 -0400
committerEvan Prodromou <evan@controlyourself.ca>2008-10-22 15:27:50 -0400
commitb26477d787481060e274f3a7007eaea2a6042062 (patch)
tree0499ff09f1cb27f71ec8d817e755f46e137328e5 /db
parent85b9e58e535d44f5973fe14f888dc19f25bcaddd (diff)
add an index to subscription token
darcs-hash:20081022192750-5ed1f-3265f9f4954cff431a0c276c16a98b9c22d8d40b.gz
Diffstat (limited to 'db')
-rw-r--r--db/laconica.sql3
1 files changed, 2 insertions, 1 deletions
diff --git a/db/laconica.sql b/db/laconica.sql
index f7813b95d..ad4ae6983 100644
--- a/db/laconica.sql
+++ b/db/laconica.sql
@@ -92,7 +92,8 @@ create table subscription (
constraint primary key (subscriber, subscribed),
index subscription_subscriber_idx (subscriber),
- index subscription_subscribed_idx (subscribed)
+ index subscription_subscribed_idx (subscribed),
+ index subscription_token_idx (token)
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin;
create table notice (