1 files changed, 6 insertions, 4 deletions
diff --git a/docker/postgres/schema.sql b/docker/postgres/schema.sql
index 38ff863..c6e1323 100644
--- a/docker/postgres/schema.sql
+++ b/docker/postgres/schema.sql
@@ -25,7 +25,7 @@ SET default_table_access_method = heap;
 --
 
 CREATE TABLE public.log (
-    id integer NOT NULL,
+    id SERIAL PRIMARY KEY,
     "timestamp" date NOT NULL,
     username text NOT NULL,
     logtext text
@@ -39,13 +39,16 @@ ALTER TABLE public.log OWNER TO test;
 --
 
 CREATE TABLE public.scanner (
-    id integer NOT NULL,
+    id SERIAL PRIMARY KEY,
+    runner text DEFAULT '*',
     name character varying(128) NOT NULL,
     active boolean NOT NULL,
     "interval" integer DEFAULT 300 NOT NULL,
     starttime date,
     endtime date,
-    maxruns integer DEFAULT 1
+    maxruns integer DEFAULT 1,
+    hostname character varying(128) NOT NULL,
+    port integer NOT NULL
 );
 
 
@@ -94,4 +97,3 @@ ALTER TABLE ONLY public.scanner
 --
 -- PostgreSQL database dump complete
 --
-