--- a/schema/gemma.sql	Mon Oct 22 11:24:25 2018 +0200
+++ b/schema/gemma.sql	Mon Oct 22 13:03:38 2018 +0200
@@ -500,6 +500,31 @@
         CHECK(measure_type = 'minimum guaranteed'
             OR value_lifetime IS NOT NULL)
     )
+
+    --
+    -- Import queue and respective logging
+    --
+    CREATE TYPE import_state AS ENUM ('queued', 'running', 'successful', 'failed')
+
+    CREATE TABLE imports (
+        id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
+        state import_state NOT NULL DEFAULT 'queued',
+        enqueued timestamp NOT NULL DEFAULT now(),
+        kind  varchar NOT NULL,
+        username varchar NOT NULL
+            REFERENCES internal.user_profiles(username)
+                ON DELETE CASCADE ON UPDATE CASCADE,
+        data TEXT
+    )
+
+    CREATE TYPE log_type AS ENUM ('info', 'warn', 'error')
+
+    CREATE TABLE import_logs (
+        import_id int NOT NULL REFERENCES imports(id),
+        time timestamp NOT NULL DEFAULT now(),
+        kind log_type NOT NULL DEFAULT 'info',
+        msg TEXT NOT NULL
+    )
 ;
 
 COMMIT;