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 +
 1 file changed, 1 insertion(+)
 create mode 100644 data/schema/7.sql

(limited to '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);
-- 
cgit v1.2.3

