From 937521a1c6c488820f5db3361bc110f16712dc18 Mon Sep 17 00:00:00 2001
From: Evan Prodromou <evan@status.net>
Date: Tue, 26 Apr 2011 13:02:12 -0400
Subject: [PATCH] add an index for site tags
---
db/site.sql | 3 ++-
1 file changed, 2 insertions(+), 1 deletion(-)
diff --git a/db/site.sql b/db/site.sql
index f87995b943..c630a83d52 100644
--- a/db/site.sql
+++ b/db/site.sql
@@ -28,6 +28,7 @@ create table status_network_tag (
tag varchar(64) comment 'tag name',
created datetime not null comment 'date the record was created',
- constraint primary key (site_id, tag)
+ constraint primary key (site_id, tag),
+ index status_network_tag_tag_idx (tag)
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci;
--
2.39.5