new upstream release (3.3.0); modify package compatibility for Stretch

[ossec-hids.git] / src / analysisd / schemas / md5_ignore_sqlite3.schema

diff --git a/src/analysisd/schemas/md5_ignore_sqlite3.schema b/src/analysisd/schemas/md5_ignore_sqlite3.schema
new file mode 100644 (file)
index 0000000..5245f7f
--- /dev/null
+++ b/src/analysisd/schemas/md5_ignore_sqlite3.schema
@@ -0,0 +1,6 @@
+CREATE TABLE files (
+    md5sum VARCHAR(32),
+    file VARCHAR(256),
+    time DATETIME
+);
+CREATE UNIQUE INDEX files_idx ON files(md5sum);