errdb_noerr_231008.sql

--
-- PostgreSQL database dump
--

-- Dumped from database version 16.0
-- Dumped by pg_dump version 16.0

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;

--
-- Name: archiv; Type: SCHEMA; Schema: -; Owner: postgres
--

CREATE SCHEMA archiv;


ALTER SCHEMA archiv OWNER TO postgres;

--
-- Name: fn_or_followup_insert(); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION public.fn_or_followup_insert() RETURNS trigger
    LANGUAGE plpgsql
    AS $$
begin
insert into or_followup_archiv values (NEW.*);
return NULL;
end;
$$;


ALTER FUNCTION public.fn_or_followup_insert() OWNER TO postgres;

SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- Name: or_followup; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.or_followup (
    id_of integer NOT NULL,
    of_season smallint NOT NULL,
    of_pr1_fac_netto numeric(8,2) DEFAULT 0.00,
    of_pr1_fac_netusd numeric(8,2) DEFAULT 0.00,
    of_pr2_fac_netto numeric(8,2) DEFAULT 0,
    of_pr2_fac_netusd numeric(8,2) DEFAULT 0,
    of_pr1_our_netto numeric(8,4) DEFAULT 0.00,
    of_pr1_our_netusd numeric(8,4) DEFAULT 0.00,
    of_pr2_our_netto numeric(8,4) DEFAULT 0,
    of_pr2_our_netusd numeric(8,4) DEFAULT 0,
    CONSTRAINT ck_of_new CHECK ((of_season >= 36)) NO INHERIT
)
WITH (fillfactor='60');


ALTER TABLE public.or_followup OWNER TO postgres;

--
-- Name: or_followup_archiv; Type: TABLE; Schema: archiv; Owner: postgres
--

CREATE TABLE archiv.or_followup_archiv (
    CONSTRAINT ck_of_old CHECK ((of_season < 36)) NO INHERIT
)
INHERITS (public.or_followup);


ALTER TABLE archiv.or_followup_archiv OWNER TO postgres;

--
-- Name: or_followup_archiv of_pr1_fac_netto; Type: DEFAULT; Schema: archiv; Owner: postgres
--

ALTER TABLE ONLY archiv.or_followup_archiv ALTER COLUMN of_pr1_fac_netto SET DEFAULT 0.00;


--
-- Name: or_followup_archiv of_pr1_fac_netusd; Type: DEFAULT; Schema: archiv; Owner: postgres
--

ALTER TABLE ONLY archiv.or_followup_archiv ALTER COLUMN of_pr1_fac_netusd SET DEFAULT 0.00;


--
-- Name: or_followup_archiv of_pr2_fac_netto; Type: DEFAULT; Schema: archiv; Owner: postgres
--

ALTER TABLE ONLY archiv.or_followup_archiv ALTER COLUMN of_pr2_fac_netto SET DEFAULT 0;


--
-- Name: or_followup_archiv of_pr2_fac_netusd; Type: DEFAULT; Schema: archiv; Owner: postgres
--

ALTER TABLE ONLY archiv.or_followup_archiv ALTER COLUMN of_pr2_fac_netusd SET DEFAULT 0;


--
-- Name: or_followup_archiv of_pr1_our_netto; Type: DEFAULT; Schema: archiv; Owner: postgres
--

ALTER TABLE ONLY archiv.or_followup_archiv ALTER COLUMN of_pr1_our_netto SET DEFAULT 0.00;


--
-- Name: or_followup_archiv of_pr1_our_netusd; Type: DEFAULT; Schema: archiv; Owner: postgres
--

ALTER TABLE ONLY archiv.or_followup_archiv ALTER COLUMN of_pr1_our_netusd SET DEFAULT 0.00;


--
-- Name: or_followup_archiv of_pr2_our_netto; Type: DEFAULT; Schema: archiv; Owner: postgres
--

ALTER TABLE ONLY archiv.or_followup_archiv ALTER COLUMN of_pr2_our_netto SET DEFAULT 0;


--
-- Name: or_followup_archiv of_pr2_our_netusd; Type: DEFAULT; Schema: archiv; Owner: postgres
--

ALTER TABLE ONLY archiv.or_followup_archiv ALTER COLUMN of_pr2_our_netusd SET DEFAULT 0;


--
-- Data for Name: or_followup_archiv; Type: TABLE DATA; Schema: archiv; Owner: postgres
--

COPY archiv.or_followup_archiv (id_of, of_season, of_pr1_fac_netto, of_pr1_fac_netusd, of_pr2_fac_netto, of_pr2_fac_netusd, of_pr1_our_netto, of_pr1_our_netusd, of_pr2_our_netto, of_pr2_our_netusd) FROM stdin;
77812	35	6.93	6.93	0.00	0.00	6.8880	6.8880	0.0000	0.0000
\.


--
-- Data for Name: or_followup; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.or_followup (id_of, of_season, of_pr1_fac_netto, of_pr1_fac_netusd, of_pr2_fac_netto, of_pr2_fac_netusd, of_pr1_our_netto, of_pr1_our_netusd, of_pr2_our_netto, of_pr2_our_netusd) FROM stdin;
\.


--
-- Name: or_followup tr_or_followup_insert; Type: TRIGGER; Schema: public; Owner: postgres
--

CREATE TRIGGER tr_or_followup_insert BEFORE INSERT ON public.or_followup FOR EACH ROW WHEN ((new.of_season < 36)) EXECUTE FUNCTION public.fn_or_followup_insert();


--
-- PostgreSQL database dump complete
--