From 9d72acbb816c6040b608c63f18b8dbb169ceb2c3 Mon Sep 17 00:00:00 2001
From: Kristofer Hallin <kristofer@sunet.se>
Date: Thu, 7 Apr 2022 14:12:06 +0200
Subject: Added PostgreSQL.

---
 docker/postgres/schema.sql | 97 ++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 97 insertions(+)
 create mode 100644 docker/postgres/schema.sql

(limited to 'docker/postgres/schema.sql')

diff --git a/docker/postgres/schema.sql b/docker/postgres/schema.sql
new file mode 100644
index 0000000..38ff863
--- /dev/null
+++ b/docker/postgres/schema.sql
@@ -0,0 +1,97 @@
+--
+-- PostgreSQL database dump
+--
+
+-- Dumped from database version 14.2 (Debian 14.2-1.pgdg110+1)
+-- Dumped by pg_dump version 14.2 (Debian 14.2-1.pgdg110+1)
+
+SET statement_timeout = 0;
+SET lock_timeout = 0;
+SET idle_in_transaction_session_timeout = 0;
+SET client_encoding = 'UTF8';
+SET standard_conforming_strings = on;
+SELECT pg_catalog.set_config('search_path', '', false);
+SET check_function_bodies = false;
+SET xmloption = content;
+SET client_min_messages = warning;
+SET row_security = off;
+
+SET default_tablespace = '';
+
+SET default_table_access_method = heap;
+
+--
+-- Name: log; Type: TABLE; Schema: public; Owner: test
+--
+
+CREATE TABLE public.log (
+    id integer NOT NULL,
+    "timestamp" date NOT NULL,
+    username text NOT NULL,
+    logtext text
+);
+
+
+ALTER TABLE public.log OWNER TO test;
+
+--
+-- Name: scanner; Type: TABLE; Schema: public; Owner: test
+--
+
+CREATE TABLE public.scanner (
+    id integer NOT NULL,
+    name character varying(128) NOT NULL,
+    active boolean NOT NULL,
+    "interval" integer DEFAULT 300 NOT NULL,
+    starttime date,
+    endtime date,
+    maxruns integer DEFAULT 1
+);
+
+
+ALTER TABLE public.scanner OWNER TO test;
+
+--
+-- Data for Name: log; Type: TABLE DATA; Schema: public; Owner: test
+--
+
+COPY public.log (id, "timestamp", username, logtext) FROM stdin;
+\.
+
+
+--
+-- Data for Name: scanner; Type: TABLE DATA; Schema: public; Owner: test
+--
+
+COPY public.scanner (id, name, active, "interval", starttime, endtime, maxruns) FROM stdin;
+\.
+
+
+--
+-- Name: log log_pkey; Type: CONSTRAINT; Schema: public; Owner: test
+--
+
+ALTER TABLE ONLY public.log
+    ADD CONSTRAINT log_pkey PRIMARY KEY (id);
+
+
+--
+-- Name: scanner scanner_name_key; Type: CONSTRAINT; Schema: public; Owner: test
+--
+
+ALTER TABLE ONLY public.scanner
+    ADD CONSTRAINT scanner_name_key UNIQUE (name);
+
+
+--
+-- Name: scanner scanner_pkey; Type: CONSTRAINT; Schema: public; Owner: test
+--
+
+ALTER TABLE ONLY public.scanner
+    ADD CONSTRAINT scanner_pkey PRIMARY KEY (id);
+
+
+--
+-- PostgreSQL database dump complete
+--
+
-- 
cgit v1.1