--
-- 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 SERIAL PRIMARY KEY,
    "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 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,
    hostname character varying(128) NOT NULL,
    port integer NOT NULL
);


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
--
