1 files changed, 10 insertions, 0 deletions
diff --git a/sql/mysql/ejabberd_router.sql b/sql/mysql/ejabberd_router.sql
new file mode 100644
index 000000000..031870dfc
--- /dev/null
+++ b/sql/mysql/ejabberd_router.sql
@@ -0,0 +1,10 @@
+CREATE TABLE route (
+    domain text NOT NULL,
+    server_host text NOT NULL,
+    node text NOT NULL,
+    pid text NOT NULL,
+    local_hint text NOT NULL
+) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+
+CREATE UNIQUE INDEX i_route ON route(domain(75), server_host(75), node(75), pid(75));
+CREATE INDEX i_route_domain ON route(domain(75));