diff options
| author | Holger Weiss <holger@zedat.fu-berlin.de> | 2019-02-26 13:13:04 +0100 |
|---|---|---|
| committer | Holger Weiss <holger@zedat.fu-berlin.de> | 2019-02-26 13:13:04 +0100 |
| commit | 90dc8ea1e5566d430c8a871e076b11e37e1a1090 (patch) | |
| tree | 7a24730c32e0daed966bb7ba70d6ca08b81760fa | |
| parent | Update mqtree (diff) | |
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.
| -rw-r--r-- | sql/mysql.new.sql | 2 | ||||
| -rw-r--r-- | sql/mysql.sql | 2 |
2 files changed, 2 insertions, 2 deletions
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, diff --git a/sql/mysql.sql b/sql/mysql.sql index 2dc02bf69..0e3c826ef 100644 --- a/sql/mysql.sql +++ b/sql/mysql.sql @@ -219,7 +219,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, |