1 files changed, 10 insertions, 0 deletions
diff --git a/sql/pgsql/ejabberd_router.sql b/sql/pgsql/ejabberd_router.sql
new file mode 100644
index 000000000..d6f1778b6
--- /dev/null
+++ b/sql/pgsql/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
+);
+
+CREATE UNIQUE INDEX i_route ON route (domain, server_host, node, pid);
+CREATE INDEX i_route_domain ON route (domain);