Initial commitHEADmaster

1 files changed, 10 insertions, 0 deletions

diff --git a/schema.sql b/schema.sql
new file mode 100644
index 0000000..eb74429
--- /dev/null
+++ b/schema.sql
@@ -0,0 +1,10 @@
+CREATE TABLE imports (id INTEGER PRIMARY KEY AUTOINCREMENT, 
+                      path TEXT,
+                      starttime TIMESTAMP DEFAULT CURRENT_TIMESTAMP, 
+                      endtime TIMESTAMP,
+                      count INTEGER,
+                      size INTEGER);
+CREATE TABLE paths (import_id INTEGER, path TEXT, type TEXT, mtime TIMESTAMP, size INTEGER);
+CREATE index idx1 ON paths(path);
+CREATE index idx2 ON paths(type);
+CREATE index idx3 ON imports(path);