From 7511da0f266e61fa12c640bd418606baca4c78ed Mon Sep 17 00:00:00 2001 From: Evgeny Khramtsov Date: Wed, 27 Feb 2019 13:06:17 +0300 Subject: Add SQL schemas for MQTT tables --- sql/lite.new.sql | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) (limited to 'sql/lite.new.sql') diff --git a/sql/lite.new.sql b/sql/lite.new.sql index ab229c6b..7264e58c 100644 --- a/sql/lite.new.sql +++ b/sql/lite.new.sql @@ -464,3 +464,20 @@ CREATE TABLE mix_pam ( CREATE UNIQUE INDEX i_mix_pam ON mix_pam (username, server_host, channel, service); CREATE INDEX i_mix_pam_us ON mix_pam (username, server_host); + +CREATE TABLE mqtt_pub ( + username text NOT NULL, + server_host text NOT NULL, + resource text NOT NULL, + topic text NOT NULL, + qos smallint NOT NULL, + payload blob NOT NULL, + payload_format smallint NOT NULL, + content_type text NOT NULL, + response_topic text NOT NULL, + correlation_data blob NOT NULL, + user_properties blob NOT NULL, + expiry bigint NOT NULL +); + +CREATE UNIQUE INDEX i_mqtt_topic_server ON mqtt_pub (topic, server_host); -- cgit v1.2.3