--- a/schema/gemma.sql	Tue Jan 08 12:34:29 2019 +0100
+++ b/schema/gemma.sql	Tue Jan 08 13:35:44 2019 +0100
@@ -590,11 +590,13 @@
 );
 
 CREATE TABLE waterway.imports (
-    id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
-    state waterway.import_state NOT NULL DEFAULT 'queued',
-    enqueued timestamp NOT NULL DEFAULT now(),
-    kind  varchar NOT NULL,
-    username varchar NOT NULL
+    id        int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
+    state     waterway.import_state NOT NULL DEFAULT 'queued',
+    kind      varchar   NOT NULL,
+    enqueued  timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+    due       timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+    trys_left int,
+    username  varchar   NOT NULL
         REFERENCES internal.user_profiles(username)
             ON DELETE CASCADE
             ON UPDATE CASCADE,
@@ -602,10 +604,10 @@
         REFERENCES internal.user_profiles(username)
             ON DELETE SET NULL
             ON UPDATE CASCADE,
-    send_email boolean NOT NULL DEFAULT false,
+    send_email  boolean NOT NULL DEFAULT false,
     auto_accept boolean NOT NULL DEFAULT false,
-    data TEXT,
-    summary TEXT
+    data        TEXT,
+    summary     TEXT
 );
 
 CREATE INDEX enqueued_idx ON waterway.imports(enqueued, state);