From ae38e07d4d700d294f668b14218d639339e373e0 Mon Sep 17 00:00:00 2001
From: Frank Brehm <frank.brehm@pixelpark.com>
Date: Tue, 16 Apr 2024 16:12:53 +0200
Subject: [PATCH] Adding db/postfix/postfix-pgsql-create-1.1.sql

---
 .gitignore                              |  1 +
 db/postfix/postfix-pgsql-create-1.1.sql | 42 +++++++++++++++++++++++++
 2 files changed, 43 insertions(+)
 create mode 100644 db/postfix/postfix-pgsql-create-1.1.sql

diff --git a/.gitignore b/.gitignore
index 65df378..b1ad2ec 100644
--- a/.gitignore
+++ b/.gitignore
@@ -22,5 +22,6 @@ dist/
 tmp/*
 venv/*
 etc/*.ini
+/*.ods
 get-from-addr-totals*.yaml
 get-from-addr-per-*.csv
diff --git a/db/postfix/postfix-pgsql-create-1.1.sql b/db/postfix/postfix-pgsql-create-1.1.sql
new file mode 100644
index 0000000..d8129c1
--- /dev/null
+++ b/db/postfix/postfix-pgsql-create-1.1.sql
@@ -0,0 +1,42 @@
+
+\set AUTOCOMMIT on
+
+--
+-- PostgreSQL database cluster dump
+--
+
+SET default_transaction_read_only = off;
+
+SET client_encoding = 'UTF8';
+SET standard_conforming_strings = on;
+
+\connect postfix
+
+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;
+
+CREATE TABLE public.mailhosts (
+    id          serial                 PRIMARY KEY,
+    hostname    character varying(64)  NOT NULL,
+    fqdn        character varying(255),
+    address     inet[],
+    description text
+);
+
+ALTER TABLE public.mailhosts OWNER TO postfix;
+
+CREATE INDEX mailhosts_hostname_idx ON public.mailhosts USING btree (hostname);
+CREATE INDEX mailhosts_fqdn_idx ON public.mailhosts USING btree (fqdn);
+
+
-- 
2.39.5