From 90dc8ea1e5566d430c8a871e076b11e37e1a1090 Mon Sep 17 00:00:00 2001
From: Holger Weiss <holger@zedat.fu-berlin.de>
Date: Tue, 26 Feb 2019 13:13:04 +0100
Subject: MySQL: Increase index prefix length for PEP nodes

For PEP nodes, the "host" column holds the user JID, where the first 20
characters may well not be unique.
---
 sql/mysql.new.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'sql/mysql.new.sql')

diff --git a/sql/mysql.new.sql b/sql/mysql.new.sql
index 65b6d1b78..39df58c55 100644
--- a/sql/mysql.new.sql
+++ b/sql/mysql.new.sql
@@ -242,7 +242,7 @@ CREATE TABLE pubsub_node (
   nodeid bigint auto_increment primary key
 ) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
 CREATE INDEX i_pubsub_node_parent ON pubsub_node(parent(120));
-CREATE UNIQUE INDEX i_pubsub_node_tuple ON pubsub_node(host(20), node(120));
+CREATE UNIQUE INDEX i_pubsub_node_tuple ON pubsub_node(host(71), node(120));
 
 CREATE TABLE pubsub_node_option (
   nodeid bigint,
-- 
cgit v1.2.3

