From b26477d787481060e274f3a7007eaea2a6042062 Mon Sep 17 00:00:00 2001
From: Evan Prodromou <evan@controlyourself.ca>
Date: Wed, 22 Oct 2008 15:27:50 -0400
Subject: add an index to subscription token

darcs-hash:20081022192750-5ed1f-3265f9f4954cff431a0c276c16a98b9c22d8d40b.gz
---
 db/laconica.sql | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'db/laconica.sql')

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 (
-- 
cgit v1.2.3-54-g00ecf

