aboutsummaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
authorEvan Prodromou <evan@status.net>2011-04-26 13:02:12 -0400
committerEvan Prodromou <evan@status.net>2011-04-26 13:02:12 -0400
commit937521a1c6c488820f5db3361bc110f16712dc18 (patch)
tree32f9f6aae9c2b1470f441275988750dea967b566 /db
parent5b23b82b0dfa5d722afd1425a7a3043493ad0267 (diff)
downloadgnu-social-937521a1c6c488820f5db3361bc110f16712dc18.tar
gnu-social-937521a1c6c488820f5db3361bc110f16712dc18.zip
add an index for site tags
Diffstat (limited to 'db')
-rw-r--r--db/site.sql3
1 files changed, 2 insertions, 1 deletions
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;