From 4b0860e7debf0326fac0cc93fbfedd202bf2f6d1 Mon Sep 17 00:00:00 2001
From: Evgeniy Khramtsov <ekhramtsov@process-one.net>
Date: Fri, 19 Feb 2016 16:15:11 +0300
Subject: Make it possible to define 'sm_db_type' per virtual host

---
 sql/lite.sql | 14 ++++++++++++++
 1 file changed, 14 insertions(+)

(limited to 'sql/lite.sql')

diff --git a/sql/lite.sql b/sql/lite.sql
index 5132c917..0cf7ff41 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);
-- 
cgit v1.2.3

