diff options
| author | phejman <przemek@slepykorzen.pl> | 2018-02-05 12:33:59 +0100 |
|---|---|---|
| committer | phejman <przemek@slepykorzen.pl> | 2018-02-05 12:33:59 +0100 |
| commit | bef7d1ba6628669d1bd36ee90414ab0b54c55714 (patch) | |
| tree | 13b525ed42b0d4ad960852db8789dd3aceb93412 /sql | |
| parent | Improve log message when module startup has failed (diff) | |
Fix MySQL error server_host used in key specification without a key length
Diffstat (limited to 'sql')
| -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)); |