summaryrefslogtreecommitdiffstats
path: root/test/formats/sqldir/init.sql
diff options
context:
space:
mode:
Diffstat (limited to 'test/formats/sqldir/init.sql')
-rw-r--r--test/formats/sqldir/init.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/test/formats/sqldir/init.sql b/test/formats/sqldir/init.sql
new file mode 100644
index 0000000..4e17034
--- /dev/null
+++ b/test/formats/sqldir/init.sql
@@ -0,0 +1,5 @@
+
+CREATE VIEW web_status AS
+ SELECT group_concat(cs_uri_stem), sc_status FROM access_log group by sc_status;
+
+INSERT into lnav_view_filters VALUES ("log", 5, 0, "in", "regex", "credential status");