aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorBadlop <badlop@process-one.net>2022-01-26 16:58:01 +0100
committerBadlop <badlop@process-one.net>2022-02-03 18:21:49 +0100
commit3b30d5b0ed9613634b39fae23ddd3001b875b8fe (patch)
tree2c0e05fdb5bc2a200c498c21eb9112bf56a1ad92 /sql
parentNew "make relive" similar to "ejabberdctl live" without installing (diff)
Fix support for MSSQL testing
Diffstat (limited to 'sql')
-rw-r--r--sql/mssql.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/mssql.sql b/sql/mssql.sql
index f8b65edc4..dfd9da2f1 100644
--- a/sql/mssql.sql
+++ b/sql/mssql.sql
@@ -546,7 +546,7 @@ WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW
CREATE UNIQUE INDEX [i_push_ut] ON [push_session] (username, timestamp)
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON);
-CREATE TABLE [dbo].[mqtt_pub](
+CREATE TABLE [dbo].[mqtt_pub] (
[username] [varchar](191) NOT NULL,
[server_host] [varchar](191) NOT NULL,
[resource] [varchar](191) NOT NULL,