Random SQL stuff for handling scanners.

New API endpoint for scanners.

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

 --

-