Welcome to mirror list, hosted at ThFree Co, Russian Federation.

github.com/processone/ejabberd.git - Unnamed repository; edit this file 'description' to name the repository.
summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAlexey Shchepin <alexey@process-one.net>2015-03-18 18:46:46 +0300
committerChristophe Romain <christophe.romain@process-one.net>2015-03-20 12:40:25 +0300
commit0eb6b942fff9d7cf3b5046ea71825d0897277d06 (patch)
treece82807d83fefc9a740b2818a95766b59fab5363 /sql/pg.sql
parent6b67a66a1ba33f3dc4346f8fffd1f9535ce54d17 (diff)
Add a missed SQL index on privacy_list_data table
Diffstat (limited to 'sql/pg.sql')
-rw-r--r--sql/pg.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/sql/pg.sql b/sql/pg.sql
index f07712332..9df8ffd9f 100644
--- a/sql/pg.sql
+++ b/sql/pg.sql
@@ -161,6 +161,8 @@ CREATE TABLE privacy_list_data (
match_presence_out boolean NOT NULL
);
+CREATE INDEX i_privacy_list_data_id ON privacy_list_data USING btree (id);
+
CREATE TABLE private_storage (
username text NOT NULL,
namespace text NOT NULL,