Make it possible to define 'sm_db_type' per virtual host

1 files changed, 14 insertions, 0 deletions

diff --git a/sql/lite.sql b/sql/lite.sql
index 5132c9172..0cf7ff414 100644
--- a/sql/lite.sql
+++ b/sql/lite.sql
@@ -296,3 +296,17 @@ CREATE TABLE archive_prefs (
     never text NOT NULL,
     created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
 );
+
+CREATE TABLE sm (
+    usec bigint NOT NULL,
+    pid text NOT NULL,
+    node text NOT NULL,
+    username text NOT NULL,
+    resource text NOT NULL,
+    priority text NOT NULL,
+    info text NOT NULL
+);
+
+CREATE UNIQUE INDEX i_sm_sid ON sm(usec, pid);
+CREATE INDEX i_sm_node ON sm(node);
+CREATE INDEX i_sm_username ON sm(username);