diff options
| -rw-r--r-- | sql/mysql.new.sql | 4 | ||||
| -rw-r--r-- | sql/mysql.sql | 4 |
2 files changed, 4 insertions, 4 deletions
diff --git a/sql/mysql.new.sql b/sql/mysql.new.sql index b7aa7c47e..b29a003eb 100644 --- a/sql/mysql.new.sql +++ b/sql/mysql.new.sql @@ -430,7 +430,7 @@ CREATE TABLE push_session ( node text NOT NULL, xml text NOT NULL, PRIMARY KEY (server_host(191), username(191), timestamp) -); +) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; CREATE UNIQUE INDEX i_push_session_susn ON push_session (server_host(191), username(191), service(191), node(191)); @@ -502,4 +502,4 @@ CREATE TABLE mqtt_pub ( user_properties blob NOT NULL, expiry int unsigned NOT NULL, UNIQUE KEY i_mqtt_topic_server (topic(191), server_host) -); +) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; diff --git a/sql/mysql.sql b/sql/mysql.sql index 0da45da98..9583aeb2d 100644 --- a/sql/mysql.sql +++ b/sql/mysql.sql @@ -398,7 +398,7 @@ CREATE TABLE push_session ( service text NOT NULL, node text NOT NULL, xml text NOT NULL -); +) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; CREATE UNIQUE INDEX i_push_usn ON push_session (username(191), service(191), node(191)); CREATE UNIQUE INDEX i_push_ut ON push_session (username(191), timestamp); @@ -469,4 +469,4 @@ CREATE TABLE mqtt_pub ( user_properties blob NOT NULL, expiry int unsigned NOT NULL, UNIQUE KEY i_mqtt_topic (topic(191)) -); +) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; |