From 4b0860e7debf0326fac0cc93fbfedd202bf2f6d1 Mon Sep 17 00:00:00 2001 From: Evgeniy Khramtsov 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