--- /dev/null
+--
+-- PostgreSQL database dump
+--
+
+-- Dumped from database version 9.5.24
+-- Dumped by pg_dump version 9.5.24
+
+SET statement_timeout = 0;
+SET lock_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: auth; Type: SCHEMA; Schema: -; Owner: kivitendo
+--
+
+CREATE SCHEMA auth;
+
+
+ALTER SCHEMA auth OWNER TO kivitendo;
+
+--
+-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
+--
+
+CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
+
+
+--
+-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
+--
+
+COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
+
+
+SET default_tablespace = '';
+
+SET default_with_oids = false;
+
+--
+-- Name: clients; Type: TABLE; Schema: auth; Owner: kivitendo
+--
+
+CREATE TABLE auth.clients (
+ id integer NOT NULL,
+ name text NOT NULL,
+ dbhost text NOT NULL,
+ dbport integer DEFAULT 5432 NOT NULL,
+ dbname text NOT NULL,
+ dbuser text NOT NULL,
+ dbpasswd text NOT NULL,
+ is_default boolean DEFAULT false NOT NULL,
+ task_server_user_id integer
+);
+
+
+ALTER TABLE auth.clients OWNER TO kivitendo;
+
+--
+-- Name: clients_groups; Type: TABLE; Schema: auth; Owner: kivitendo
+--
+
+CREATE TABLE auth.clients_groups (
+ client_id integer NOT NULL,
+ group_id integer NOT NULL
+);
+
+
+ALTER TABLE auth.clients_groups OWNER TO kivitendo;
+
+--
+-- Name: clients_id_seq; Type: SEQUENCE; Schema: auth; Owner: kivitendo
+--
+
+CREATE SEQUENCE auth.clients_id_seq
+ START WITH 1
+ INCREMENT BY 1
+ NO MINVALUE
+ NO MAXVALUE
+ CACHE 1;
+
+
+ALTER TABLE auth.clients_id_seq OWNER TO kivitendo;
+
+--
+-- Name: clients_id_seq; Type: SEQUENCE OWNED BY; Schema: auth; Owner: kivitendo
+--
+
+ALTER SEQUENCE auth.clients_id_seq OWNED BY auth.clients.id;
+
+
+--
+-- Name: clients_users; Type: TABLE; Schema: auth; Owner: kivitendo
+--
+
+CREATE TABLE auth.clients_users (
+ client_id integer NOT NULL,
+ user_id integer NOT NULL
+);
+
+
+ALTER TABLE auth.clients_users OWNER TO kivitendo;
+
+--
+-- Name: group_id_seq; Type: SEQUENCE; Schema: auth; Owner: kivitendo
+--
+
+CREATE SEQUENCE auth.group_id_seq
+ START WITH 1
+ INCREMENT BY 1
+ NO MINVALUE
+ NO MAXVALUE
+ CACHE 1;
+
+
+ALTER TABLE auth.group_id_seq OWNER TO kivitendo;
+
+--
+-- Name: group; Type: TABLE; Schema: auth; Owner: kivitendo
+--
+
+CREATE TABLE auth."group" (
+ id integer DEFAULT nextval('auth.group_id_seq'::regclass) NOT NULL,
+ name text NOT NULL,
+ description text
+);
+
+
+ALTER TABLE auth."group" OWNER TO kivitendo;
+
+--
+-- Name: group_rights; Type: TABLE; Schema: auth; Owner: kivitendo
+--
+
+CREATE TABLE auth.group_rights (
+ group_id integer NOT NULL,
+ "right" text NOT NULL,
+ granted boolean NOT NULL
+);
+
+
+ALTER TABLE auth.group_rights OWNER TO kivitendo;
+
+--
+-- Name: master_rights; Type: TABLE; Schema: auth; Owner: kivitendo
+--
+
+CREATE TABLE auth.master_rights (
+ id integer NOT NULL,
+ "position" integer NOT NULL,
+ name text NOT NULL,
+ description text NOT NULL,
+ category boolean DEFAULT false NOT NULL
+);
+
+
+ALTER TABLE auth.master_rights OWNER TO kivitendo;
+
+--
+-- Name: master_rights_id_seq; Type: SEQUENCE; Schema: auth; Owner: kivitendo
+--
+
+CREATE SEQUENCE auth.master_rights_id_seq
+ START WITH 1
+ INCREMENT BY 1
+ NO MINVALUE
+ NO MAXVALUE
+ CACHE 1;
+
+
+ALTER TABLE auth.master_rights_id_seq OWNER TO kivitendo;
+
+--
+-- Name: master_rights_id_seq; Type: SEQUENCE OWNED BY; Schema: auth; Owner: kivitendo
+--
+
+ALTER SEQUENCE auth.master_rights_id_seq OWNED BY auth.master_rights.id;
+
+
+--
+-- Name: schema_info; Type: TABLE; Schema: auth; Owner: kivitendo
+--
+
+CREATE TABLE auth.schema_info (
+ tag text NOT NULL,
+ login text,
+ itime timestamp without time zone DEFAULT now()
+);
+
+
+ALTER TABLE auth.schema_info OWNER TO kivitendo;
+
+--
+-- Name: session; Type: TABLE; Schema: auth; Owner: kivitendo
+--
+
+CREATE TABLE auth.session (
+ id text NOT NULL,
+ ip_address inet,
+ mtime timestamp without time zone,
+ api_token text
+);
+
+
+ALTER TABLE auth.session OWNER TO kivitendo;
+
+--
+-- Name: session_content; Type: TABLE; Schema: auth; Owner: kivitendo
+--
+
+CREATE TABLE auth.session_content (
+ session_id text NOT NULL,
+ sess_key text NOT NULL,
+ sess_value text,
+ auto_restore boolean
+);
+
+
+ALTER TABLE auth.session_content OWNER TO kivitendo;
+
+--
+-- Name: user_id_seq; Type: SEQUENCE; Schema: auth; Owner: kivitendo
+--
+
+CREATE SEQUENCE auth.user_id_seq
+ START WITH 1
+ INCREMENT BY 1
+ NO MINVALUE
+ NO MAXVALUE
+ CACHE 1;
+
+
+ALTER TABLE auth.user_id_seq OWNER TO kivitendo;
+
+--
+-- Name: user; Type: TABLE; Schema: auth; Owner: kivitendo
+--
+
+CREATE TABLE auth."user" (
+ id integer DEFAULT nextval('auth.user_id_seq'::regclass) NOT NULL,
+ login text NOT NULL,
+ password text
+);
+
+
+ALTER TABLE auth."user" OWNER TO kivitendo;
+
+--
+-- Name: user_config; Type: TABLE; Schema: auth; Owner: kivitendo
+--
+
+CREATE TABLE auth.user_config (
+ user_id integer NOT NULL,
+ cfg_key text NOT NULL,
+ cfg_value text
+);
+
+
+ALTER TABLE auth.user_config OWNER TO kivitendo;
+
+--
+-- Name: user_group; Type: TABLE; Schema: auth; Owner: kivitendo
+--
+
+CREATE TABLE auth.user_group (
+ user_id integer NOT NULL,
+ group_id integer NOT NULL
+);
+
+
+ALTER TABLE auth.user_group OWNER TO kivitendo;
+
+--
+-- Name: id; Type: DEFAULT; Schema: auth; Owner: kivitendo
+--
+
+ALTER TABLE ONLY auth.clients ALTER COLUMN id SET DEFAULT nextval('auth.clients_id_seq'::regclass);
+
+
+--
+-- Name: id; Type: DEFAULT; Schema: auth; Owner: kivitendo
+--
+
+ALTER TABLE ONLY auth.master_rights ALTER COLUMN id SET DEFAULT nextval('auth.master_rights_id_seq'::regclass);
+
+
+--
+-- Data for Name: clients; Type: TABLE DATA; Schema: auth; Owner: kivitendo
+--
+
+COPY auth.clients (id, name, dbhost, dbport, dbname, dbuser, dbpasswd, is_default, task_server_user_id) FROM stdin;
+1 firma localhost 5432 firma kivitendo kivitendo t \N
+\.
+
+
+--
+-- Data for Name: clients_groups; Type: TABLE DATA; Schema: auth; Owner: kivitendo
+--
+
+COPY auth.clients_groups (client_id, group_id) FROM stdin;
+1 1
+\.
+
+
+--
+-- Name: clients_id_seq; Type: SEQUENCE SET; Schema: auth; Owner: kivitendo
+--
+
+SELECT pg_catalog.setval('auth.clients_id_seq', 1, true);
+
+
+--
+-- Data for Name: clients_users; Type: TABLE DATA; Schema: auth; Owner: kivitendo
+--
+
+COPY auth.clients_users (client_id, user_id) FROM stdin;
+1 1
+\.
+
+
+--
+-- Data for Name: group; Type: TABLE DATA; Schema: auth; Owner: kivitendo
+--
+
+COPY auth."group" (id, name, description) FROM stdin;
+1 Vollzugriff Vollzugriff
+\.
+
+
+--
+-- Name: group_id_seq; Type: SEQUENCE SET; Schema: auth; Owner: kivitendo
+--
+
+SELECT pg_catalog.setval('auth.group_id_seq', 1, true);
+
+
+--
+-- Data for Name: group_rights; Type: TABLE DATA; Schema: auth; Owner: kivitendo
+--
+
+COPY auth.group_rights (group_id, "right", granted) FROM stdin;
+1 customer_vendor_edit t
+1 customer_vendor_all_edit t
+1 part_service_assembly_edit t
+1 part_service_assembly_details t
+1 shop_part_edit t
+1 assembly_edit t
+1 project_edit t
+1 project_edit_view_invoices_permission t
+1 show_extra_record_tab_customer t
+1 show_extra_record_tab_vendor t
+1 requirement_spec_edit t
+1 sales_quotation_edit t
+1 shop_order t
+1 sales_order_edit t
+1 sales_delivery_order_edit t
+1 invoice_edit t
+1 dunning_edit t
+1 sales_letter_edit t
+1 sales_all_edit t
+1 sales_edit_prices t
+1 show_ar_transactions t
+1 delivery_plan t
+1 delivery_value_report t
+1 sales_letter_report t
+1 import_ar t
+1 request_quotation_edit t
+1 purchase_order_edit t
+1 purchase_delivery_order_edit t
+1 vendor_invoice_edit t
+1 purchase_letter_edit t
+1 purchase_all_edit t
+1 purchase_edit_prices t
+1 show_ap_transactions t
+1 purchase_letter_report t
+1 import_ap t
+1 warehouse_contents t
+1 warehouse_management t
+1 general_ledger t
+1 gl_transactions t
+1 ar_transactions t
+1 ap_transactions t
+1 datev_export t
+1 cash t
+1 bank_transaction t
+1 report t
+1 advance_turnover_tax_return t
+1 batch_printing f
+1 config t
+1 admin t
+1 edit_shop_config t
+1 custom_data_export_designer t
+1 email_bcc f
+1 email_journal f
+1 email_employee_readall f
+1 productivity f
+1 display_admin_link f
+1 record_links f
+1 all_drafts_edit f
+\.
+
+
+--
+-- Data for Name: master_rights; Type: TABLE DATA; Schema: auth; Owner: kivitendo
+--
+
+COPY auth.master_rights (id, "position", name, description, category) FROM stdin;
+1 100 master_data Master Data t
+2 200 customer_vendor_edit Create customers and vendors. Edit all vendors. Edit only customers where salesman equals employee (login) f
+3 300 customer_vendor_all_edit Create customers and vendors. Edit all vendors. Edit all customers f
+4 400 part_service_assembly_edit Create and edit parts, services, assemblies f
+5 500 part_service_assembly_details Show details and reports of parts, services, assemblies f
+6 600 project_edit Create and edit projects f
+7 700 ar AR t
+8 800 requirement_spec_edit Create and edit requirement specs f
+9 900 sales_quotation_edit Create and edit sales quotations f
+10 1000 sales_order_edit Create and edit sales orders f
+11 1100 sales_delivery_order_edit Create and edit sales delivery orders f
+12 1200 invoice_edit Create and edit invoices and credit notes f
+13 1300 dunning_edit Create and edit dunnings f
+14 1400 sales_letter_edit Edit sales letters f
+15 1500 sales_all_edit View/edit all employees sales documents f
+17 1700 show_ar_transactions Show AR transactions as part of AR invoice report f
+18 1800 delivery_plan Show delivery plan f
+19 1900 delivery_value_report Show delivery value report f
+20 2000 sales_letter_report Show sales letters report f
+21 2100 ap AP t
+22 2200 request_quotation_edit Create and edit RFQs f
+23 2300 purchase_order_edit Create and edit purchase orders f
+24 2400 purchase_delivery_order_edit Create and edit purchase delivery orders f
+25 2500 vendor_invoice_edit Create and edit vendor invoices f
+26 2600 show_ap_transactions Show AP transactions as part of AP invoice report f
+27 2700 warehouse Warehouse management t
+28 2800 warehouse_contents View warehouse content f
+29 2900 warehouse_management Warehouse management f
+30 3000 general_ledger_cash General ledger and cash t
+32 3200 datev_export DATEV Export f
+33 3300 cash Receipt, payment, reconciliation f
+34 3400 bank_transaction Bank transactions f
+35 3500 reports Reports t
+36 3600 report All reports f
+37 3700 advance_turnover_tax_return Advance turnover tax return f
+38 3800 batch_printing_category Batch Printing t
+39 3900 batch_printing Batch Printing f
+40 4000 configuration Configuration t
+41 4100 config Change kivitendo installation settings (most entries in the 'System' menu) f
+42 4200 admin Client administration: configuration, editing templates, task server control, background jobs (remaining entries in the 'System' menu) f
+43 4300 others Others t
+44 4400 email_bcc May set the BCC field when sending emails f
+45 4500 productivity Productivity f
+46 4600 display_admin_link Show administration link f
+31 3100 general_ledger AP/AR Aging & Journal f
+16 1600 sales_edit_prices Edit prices and discount (if not used, textfield is ONLY set readonly) f
+47 5000 all_drafts_edit Edit all drafts f
+48 4450 email_journal E-Mail-Journal f
+49 4480 email_employee_readall Read all employee e-mails f
+50 2050 import_ar Import AR from Scanner or Email f
+52 2550 purchase_letter_edit Edit purchase letters f
+53 2650 purchase_letter_report Show purchase letters report f
+54 4750 record_links Linked Records f
+55 3130 gl_transactions General Ledger Transaction f
+56 3150 ar_transactions AR Transactions f
+57 3170 ap_transactions AP Transactions f
+51 2680 import_ap Import AP from Scanner or Email f
+58 550 assembly_edit Always edit assembly items (user can change/delete items even if assemblies are already produced) f
+59 4275 custom_data_export_designer Custom data export f
+60 550 shop_part_edit Create and edit shopparts f
+61 950 shop_order Get shoporders f
+62 4250 edit_shop_config Create and edit webshops f
+63 610 show_extra_record_tab_customer Show record tab in customer f
+64 611 show_extra_record_tab_vendor Show record tab in vendor f
+65 602 project_edit_view_invoices_permission Projects: edit the list of employees allowed to view invoices f
+66 2560 purchase_all_edit View/edit all employees purchase documents f
+67 2570 purchase_edit_prices Edit prices and discount (if not used, textfield is ONLY set readonly) f
+\.
+
+
+--
+-- Name: master_rights_id_seq; Type: SEQUENCE SET; Schema: auth; Owner: kivitendo
+--
+
+SELECT pg_catalog.setval('auth.master_rights_id_seq', 67, true);
+
+
+--
+-- Data for Name: schema_info; Type: TABLE DATA; Schema: auth; Owner: kivitendo
+--
+
+COPY auth.schema_info (tag, login, itime) FROM stdin;
+add_api_token admin 2018-11-30 19:52:50.606337
+add_batch_printing_to_full_access admin 2018-11-30 19:52:50.612204
+auth_schema_normalization_1 admin 2018-11-30 19:52:50.679835
+password_hashing admin 2018-11-30 19:52:50.757564
+remove_menustyle_v4 admin 2018-11-30 19:52:50.787919
+remove_menustyle_xml admin 2018-11-30 19:52:50.79445
+session_content_auto_restore admin 2018-11-30 19:52:50.799888
+release_3_0_0 admin 2018-11-30 19:52:50.831311
+clients admin 2018-11-30 19:52:50.877394
+clients_webdav admin 2018-11-30 19:52:50.98643
+foreign_key_constraints_on_delete admin 2018-11-30 19:52:50.993769
+release_3_2_0 admin 2018-11-30 19:52:51.066536
+add_master_rights admin 2018-11-30 19:52:51.076355
+bank_transaction_rights admin 2018-11-30 19:52:51.158372
+delivery_plan_rights admin 2018-11-30 19:52:51.184635
+delivery_process_value admin 2018-11-30 19:52:51.192706
+details_and_report_of_parts admin 2018-11-30 19:52:51.221993
+productivity_rights admin 2018-11-30 19:52:51.232101
+requirement_spec_rights admin 2018-11-30 19:52:51.255307
+rights_for_showing_ar_and_ap_transactions admin 2018-11-30 19:52:51.262267
+sales_letter_rights admin 2018-11-30 19:52:51.2917
+release_3_3_0 admin 2018-11-30 19:52:51.296489
+client_task_server admin 2018-11-30 19:52:51.304536
+remove_insecurely_hashed_passwords admin 2018-11-30 19:52:51.33197
+session_content_primary_key admin 2018-11-30 19:52:51.339007
+release_3_4_0 admin 2018-11-30 19:52:51.368148
+master_rights_position_gaps admin 2021-01-16 23:27:44.749094
+all_drafts_edit admin 2021-01-16 23:27:44.847437
+mail_journal_rights admin 2021-01-16 23:27:44.899515
+other_file_sources admin 2021-01-16 23:27:44.931875
+purchase_letter_rights admin 2021-01-16 23:27:44.946762
+record_links_rights admin 2021-01-16 23:27:44.964905
+split_transaction_rights admin 2021-01-16 23:27:44.984987
+other_file_sources2 admin 2021-01-16 23:27:45.030195
+rename_general_ledger_rights admin 2021-01-16 23:27:45.043693
+release_3_5_0 admin 2021-01-16 23:27:45.066912
+assembly_edit_right admin 2021-01-16 23:27:45.095898
+custom_data_export_rights admin 2021-01-16 23:27:45.120899
+webshop_api_rights admin 2021-01-16 23:27:45.140731
+webshop_api_rights_2 admin 2021-01-16 23:27:45.167397
+release_3_5_1 admin 2021-01-16 23:27:45.175067
+release_3_5_2 admin 2021-01-16 23:27:45.183556
+customer_vendor_record_extra_tab_rights admin 2021-01-16 23:27:45.189809
+release_3_5_3 admin 2021-01-16 23:27:45.19872
+rights_for_viewing_project_specific_invoices admin 2021-01-16 23:27:45.210894
+release_3_5_4 admin 2021-01-16 23:27:45.21948
+right_purchase_all_edit admin 2021-01-16 23:27:45.227773
+rights_sales_purchase_edit_prices admin 2021-01-16 23:27:45.256678
+master_rights_positions_fix admin 2021-01-16 23:27:45.267954
+release_3_5_5 admin 2021-01-16 23:27:45.285413
+release_3_5_6 admin 2021-01-16 23:27:45.313788
+release_3_5_6_1 admin 2021-01-16 23:27:45.326867
+\.
+
+
+--
+-- Data for Name: session; Type: TABLE DATA; Schema: auth; Owner: kivitendo
+--
+
+COPY auth.session (id, ip_address, mtime, api_token) FROM stdin;
+83d0f1038e65220b0c18c4a63a465649 127.0.0.1 2021-01-18 17:31:47.701129 73636e3d5f9ad1db2546b6dc3027b6ea
+f3f4f06687f44fadd001940ee2c76122 127.0.0.1 2021-01-18 19:39:08.564014 3f1fef3555e6eebe6c9248558e7b791f
+\.
+
+
+--
+-- Data for Name: session_content; Type: TABLE DATA; Schema: auth; Owner: kivitendo
+--
+
+COPY auth.session_content (session_id, sess_key, sess_value, auto_restore) FROM stdin;
+f3f4f06687f44fadd001940ee2c76122 session_auth_status_root --- 0\n \N
+\.
+
+
+--
+-- Data for Name: user; Type: TABLE DATA; Schema: auth; Owner: kivitendo
+--
+
+COPY auth."user" (id, login, password) FROM stdin;
+1 michael {PBKDF2}eb582ba54e6c4aefdf12345026c9e4eb8e:42f75af3ca486e0de3e9d6e655d1db0f0e8122b0040f3f64ac92ff683e89a1ed
+\.
+
+
+--
+-- Data for Name: user_config; Type: TABLE DATA; Schema: auth; Owner: kivitendo
+--
+
+COPY auth.user_config (user_id, cfg_key, cfg_value) FROM stdin;
+1 mandatory_departments 0
+1 signature
+1 numberformat 1.000,00
+1 countrycode de
+1 tel
+1 menustyle neu
+1 vclimit 200
+1 phone_extension
+1 dateformat dd.mm.yy
+1 stylesheet kivitendo.css
+1 name michael
+1 email
+1 phone_password
+1 fax
+\.
+
+
+--
+-- Data for Name: user_group; Type: TABLE DATA; Schema: auth; Owner: kivitendo
+--
+
+COPY auth.user_group (user_id, group_id) FROM stdin;
+1 1
+\.
+
+
+--
+-- Name: user_id_seq; Type: SEQUENCE SET; Schema: auth; Owner: kivitendo
+--
+
+SELECT pg_catalog.setval('auth.user_id_seq', 1, true);
+
+
+--
+-- Name: clients_dbhost_dbport_dbname_key; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
+--
+
+ALTER TABLE ONLY auth.clients
+ ADD CONSTRAINT clients_dbhost_dbport_dbname_key UNIQUE (dbhost, dbport, dbname);
+
+
+--
+-- Name: clients_groups_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
+--
+
+ALTER TABLE ONLY auth.clients_groups
+ ADD CONSTRAINT clients_groups_pkey PRIMARY KEY (client_id, group_id);
+
+
+--
+-- Name: clients_name_key; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
+--
+
+ALTER TABLE ONLY auth.clients
+ ADD CONSTRAINT clients_name_key UNIQUE (name);
+
+
+--
+-- Name: clients_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
+--
+
+ALTER TABLE ONLY auth.clients
+ ADD CONSTRAINT clients_pkey PRIMARY KEY (id);
+
+
+--
+-- Name: clients_users_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
+--
+
+ALTER TABLE ONLY auth.clients_users
+ ADD CONSTRAINT clients_users_pkey PRIMARY KEY (client_id, user_id);
+
+
+--
+-- Name: group_name_key; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
+--
+
+ALTER TABLE ONLY auth."group"
+ ADD CONSTRAINT group_name_key UNIQUE (name);
+
+
+--
+-- Name: group_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
+--
+
+ALTER TABLE ONLY auth."group"
+ ADD CONSTRAINT group_pkey PRIMARY KEY (id);
+
+
+--
+-- Name: group_rights_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
+--
+
+ALTER TABLE ONLY auth.group_rights
+ ADD CONSTRAINT group_rights_pkey PRIMARY KEY (group_id, "right");
+
+
+--
+-- Name: master_rights_name_key; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
+--
+
+ALTER TABLE ONLY auth.master_rights
+ ADD CONSTRAINT master_rights_name_key UNIQUE (name);
+
+
+--
+-- Name: master_rights_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
+--
+
+ALTER TABLE ONLY auth.master_rights
+ ADD CONSTRAINT master_rights_pkey PRIMARY KEY (id);
+
+
+--
+-- Name: schema_info_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
+--
+
+ALTER TABLE ONLY auth.schema_info
+ ADD CONSTRAINT schema_info_pkey PRIMARY KEY (tag);
+
+
+--
+-- Name: session_content_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
+--
+
+ALTER TABLE ONLY auth.session_content
+ ADD CONSTRAINT session_content_pkey PRIMARY KEY (session_id, sess_key);
+
+
+--
+-- Name: session_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
+--
+
+ALTER TABLE ONLY auth.session
+ ADD CONSTRAINT session_pkey PRIMARY KEY (id);
+
+
+--
+-- Name: user_config_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
+--
+
+ALTER TABLE ONLY auth.user_config
+ ADD CONSTRAINT user_config_pkey PRIMARY KEY (user_id, cfg_key);
+
+
+--
+-- Name: user_group_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
+--
+
+ALTER TABLE ONLY auth.user_group
+ ADD CONSTRAINT user_group_pkey PRIMARY KEY (user_id, group_id);
+
+
+--
+-- Name: user_login_key; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
+--
+
+ALTER TABLE ONLY auth."user"
+ ADD CONSTRAINT user_login_key UNIQUE (login);
+
+
+--
+-- Name: user_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
+--
+
+ALTER TABLE ONLY auth."user"
+ ADD CONSTRAINT user_pkey PRIMARY KEY (id);
+
+
+--
+-- Name: clients_groups_client_id_fkey; Type: FK CONSTRAINT; Schema: auth; Owner: kivitendo
+--
+
+ALTER TABLE ONLY auth.clients_groups
+ ADD CONSTRAINT clients_groups_client_id_fkey FOREIGN KEY (client_id) REFERENCES auth.clients(id) ON DELETE CASCADE;
+
+
+--
+-- Name: clients_groups_group_id_fkey; Type: FK CONSTRAINT; Schema: auth; Owner: kivitendo
+--
+
+ALTER TABLE ONLY auth.clients_groups
+ ADD CONSTRAINT clients_groups_group_id_fkey FOREIGN KEY (group_id) REFERENCES auth."group"(id) ON DELETE CASCADE;
+
+
+--
+-- Name: clients_task_server_user_id_fkey; Type: FK CONSTRAINT; Schema: auth; Owner: kivitendo
+--
+
+ALTER TABLE ONLY auth.clients
+ ADD CONSTRAINT clients_task_server_user_id_fkey FOREIGN KEY (task_server_user_id) REFERENCES auth."user"(id);
+
+
+--
+-- Name: clients_users_client_id_fkey; Type: FK CONSTRAINT; Schema: auth; Owner: kivitendo
+--
+
+ALTER TABLE ONLY auth.clients_users
+ ADD CONSTRAINT clients_users_client_id_fkey FOREIGN KEY (client_id) REFERENCES auth.clients(id) ON DELETE CASCADE;
+
+
+--
+-- Name: clients_users_user_id_fkey; Type: FK CONSTRAINT; Schema: auth; Owner: kivitendo
+--
+
+ALTER TABLE ONLY auth.clients_users
+ ADD CONSTRAINT clients_users_user_id_fkey FOREIGN KEY (user_id) REFERENCES auth."user"(id) ON DELETE CASCADE;
+
+
+--
+-- Name: group_rights_group_id_fkey; Type: FK CONSTRAINT; Schema: auth; Owner: kivitendo
+--
+
+ALTER TABLE ONLY auth.group_rights
+ ADD CONSTRAINT group_rights_group_id_fkey FOREIGN KEY (group_id) REFERENCES auth."group"(id) ON DELETE CASCADE;
+
+
+--
+-- Name: session_content_session_id_fkey; Type: FK CONSTRAINT; Schema: auth; Owner: kivitendo
+--
+
+ALTER TABLE ONLY auth.session_content
+ ADD CONSTRAINT session_content_session_id_fkey FOREIGN KEY (session_id) REFERENCES auth.session(id) ON DELETE CASCADE;
+
+
+--
+-- Name: user_config_user_id_fkey; Type: FK CONSTRAINT; Schema: auth; Owner: kivitendo
+--
+
+ALTER TABLE ONLY auth.user_config
+ ADD CONSTRAINT user_config_user_id_fkey FOREIGN KEY (user_id) REFERENCES auth."user"(id) ON DELETE CASCADE;
+
+
+--
+-- Name: user_group_group_id_fkey; Type: FK CONSTRAINT; Schema: auth; Owner: kivitendo
+--
+
+ALTER TABLE ONLY auth.user_group
+ ADD CONSTRAINT user_group_group_id_fkey FOREIGN KEY (group_id) REFERENCES auth."group"(id) ON DELETE CASCADE;
+
+
+--
+-- Name: user_group_user_id_fkey; Type: FK CONSTRAINT; Schema: auth; Owner: kivitendo
+--
+
+ALTER TABLE ONLY auth.user_group
+ ADD CONSTRAINT user_group_user_id_fkey FOREIGN KEY (user_id) REFERENCES auth."user"(id) ON DELETE CASCADE;
+
+
+--
+-- Name: SCHEMA public; Type: ACL; Schema: -; Owner: postgres
+--
+
+REVOKE ALL ON SCHEMA public FROM PUBLIC;
+REVOKE ALL ON SCHEMA public FROM postgres;
+GRANT ALL ON SCHEMA public TO postgres;
+GRANT ALL ON SCHEMA public TO PUBLIC;
+
+
+--
+-- PostgreSQL database dump complete
+--
+