diff options
| -rw-r--r-- | sql/mysql.new.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/sql/mysql.new.sql b/sql/mysql.new.sql index de37fadb7..c155794ee 100644 --- a/sql/mysql.new.sql +++ b/sql/mysql.new.sql @@ -422,7 +422,7 @@ CREATE TABLE carboncopy ( PRIMARY KEY (server_host(191), username(191), resource(191)) ) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -CREATE INDEX i_carboncopy_sh_user ON carboncopy (server_host, username(75)); +CREATE INDEX i_carboncopy_sh_user ON carboncopy (server_host(191), username(75)); CREATE TABLE proxy65 ( sid text NOT NULL, @@ -446,4 +446,4 @@ CREATE TABLE push_session ( PRIMARY KEY (server_host(191), username(191), timestamp) ); -CREATE UNIQUE INDEX i_push_session_susn ON push_session (server_host, username(191), service(191), node(191)); +CREATE UNIQUE INDEX i_push_session_susn ON push_session (server_host(191), username(191), service(191), node(191)); |