diff options
author | Evgeny Khramtsov <ekhramtsov@process-one.net> | 2019-02-27 13:06:17 +0300 |
---|---|---|
committer | Evgeny Khramtsov <ekhramtsov@process-one.net> | 2019-02-27 13:06:17 +0300 |
commit | 7511da0f266e61fa12c640bd418606baca4c78ed (patch) | |
tree | ec71e67a273928c7f162f3df3768b39338a373c4 /sql/mysql.new.sql | |
parent | Copy p1_time_compat:unique_timestamp() to misc and make use of it (diff) |
Add SQL schemas for MQTT tables
Diffstat (limited to 'sql/mysql.new.sql')
-rw-r--r-- | sql/mysql.new.sql | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/sql/mysql.new.sql b/sql/mysql.new.sql index 39df58c5..a10e21d9 100644 --- a/sql/mysql.new.sql +++ b/sql/mysql.new.sql @@ -480,3 +480,19 @@ CREATE TABLE mix_pam ( CREATE UNIQUE INDEX i_mix_pam ON mix_pam (username(191), server_host(191), channel(191), service(191)); CREATE INDEX i_mix_pam_us ON mix_pam (username(191), server_host(191)); + +CREATE TABLE mqtt_pub ( + username varchar(191) NOT NULL, + server_host varchar(191) NOT NULL, + resource varchar(191) NOT NULL, + topic text NOT NULL, + qos tinyint NOT NULL, + payload blob NOT NULL, + payload_format tinyint NOT NULL, + content_type text NOT NULL, + response_topic text NOT NULL, + correlation_data blob NOT NULL, + user_properties blob NOT NULL, + expiry int unsigned NOT NULL, + UNIQUE KEY i_mqtt_topic_server (topic(191), server_host) +); |