From 56c2cc72b9e4f65d94edab5f4c58633322dc43f8 Mon Sep 17 00:00:00 2001
From: Silvio Rhatto <rhatto@riseup.net>
Date: Sat, 5 Dec 2020 17:07:09 -0300
Subject: Fix: create an index at sc_bookmarks2tags table

This index increases the performance of queries that selects
tags from a given bookmark.
---
 data/schema/7.sql | 1 +
 data/tables.sql   | 2 ++
 2 files changed, 3 insertions(+)
 create mode 100644 data/schema/7.sql

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);
+
 -- --------------------------------------------------------
 
 -- 
-- 
cgit v1.2.3