1 files changed, 14 insertions, 0 deletions
diff --git a/sql/sqlite/ejabberd_sm.sql b/sql/sqlite/ejabberd_sm.sql
new file mode 100644
index 000000000..2692548b5
--- /dev/null
+++ b/sql/sqlite/ejabberd_sm.sql
@@ -0,0 +1,14 @@
+CREATE TABLE sm (
+    usec bigint NOT NULL,
+    pid text NOT NULL,
+    node text NOT NULL,
+    username text NOT NULL,
+    server_host text NOT NULL,
+    resource text NOT NULL,
+    priority text NOT NULL,
+    info text NOT NULL
+);
+
+CREATE UNIQUE INDEX i_usec_pid ON sm(usec, pid);
+CREATE INDEX i_sm_node ON sm(node);
+CREATE INDEX i_sm_sh_username ON sm (server_host, username);