aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--data/schema/7.sql1
-rw-r--r--data/tables.sql2
2 files changed, 3 insertions, 0 deletions
diff --git a/data/schema/7.sql b/data/schema/7.sql
new file mode 100644
index 0000000..28694fa
--- /dev/null
+++ b/data/schema/7.sql
@@ -0,0 +1 @@
+CREATE INDEX sc_bookmarks2tags_index ON sc_bookmarks2tags(tag);
diff --git a/data/tables.sql b/data/tables.sql
index de1bb8d..86779c2 100644
--- a/data/tables.sql
+++ b/data/tables.sql
@@ -59,6 +59,8 @@ CREATE TABLE `sc_bookmarks2tags` (
KEY `sc_bookmarks2tags_bId` (`bId`)
) CHARACTER SET utf8 COLLATE utf8_general_ci ;
+CREATE INDEX sc_bookmarks2tags_index ON sc_bookmarks2tags(tag);
+
-- --------------------------------------------------------
--