-- PostgreSQL database dump
--
--- Dumped from database version 9.5.24
--- Dumped by pg_dump version 9.5.24
+-- Dumped from database version 13.13 (Debian 13.13-0+deb11u1)
+-- Dumped by pg_dump version 13.13 (Debian 13.13-0+deb11u1)
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);
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;
+SET default_table_access_method = heap;
--
-- Name: clients; Type: TABLE; Schema: auth; Owner: kivitendo
ALTER TABLE auth.user_group OWNER TO kivitendo;
--
--- Name: id; Type: DEFAULT; Schema: auth; Owner: kivitendo
+-- Name: clients 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
+-- Name: master_rights 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);
\.
---
--- 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
--
\.
---
--- 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
--
1 display_admin_link f
1 record_links f
1 all_drafts_edit f
+1 time_recording t
+1 time_recording_show_all t
+1 time_recording_edit_all t
+1 assortment_edit t
+1 request_quotation_view t
+1 sales_invoice_view t
+1 purchase_invoice_view t
+1 sales_delivery_order_view t
+1 purchase_delivery_order_view t
+1 sales_quotation_view t
+1 purchase_order_view t
+1 sales_order_view t
\.
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
+40 5000 configuration Configuration t
+41 5100 config Change kivitendo installation settings (most entries in the 'System' menu) f
+42 5200 admin Client administration: configuration, editing templates, task server control, background jobs (remaining entries in the 'System' menu) f
+43 5300 others Others t
+44 5400 email_bcc May set the BCC field when sending emails f
+69 4300 time_recording Create, edit and list time recordings f
+46 5600 display_admin_link Show administration link f
+47 6000 all_drafts_edit Edit all drafts f
+70 4320 time_recording_show_all List time recordings of all staff members f
+71 4340 time_recording_edit_all Edit time recordings of all staff members f
+54 5750 record_links Linked Records f
+59 5275 custom_data_export_designer Custom data export f
+62 5250 edit_shop_config Create and edit webshops f
+68 4000 productivity_category Productivity t
+45 4100 productivity Productivity (TODO list, Follow-Ups) f
+48 4200 email_journal E-Mail-Journal f
+49 4250 email_employee_readall Read all employee e-mails f
+60 580 shop_part_edit Create and edit shopparts f
+72 5220 developer See various menu entries intended for developers f
+73 560 assortment_edit Always edit assortment items (user can change/delete items even if assortments are already used) f
+74 910 sales_quotation_view View sales quotations f
+75 1010 sales_order_view View sales orders f
+76 1110 sales_delivery_order_view View sales delivery orders f
+77 1210 sales_invoice_view View sales invoices and credit notes f
+78 2210 request_quotation_view View RFQs f
+79 2310 purchase_order_view View purchase orders f
+80 2410 purchase_delivery_order_view View purchase delivery orders f
+81 2510 purchase_invoice_view View purchase invoices 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
--
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
+right_productivity_as_category admin 2023-12-16 23:40:01.312572
+right_time_recording admin 2023-12-16 23:40:01.391342
+rights_time_recording_show_edit_all admin 2023-12-16 23:40:01.402884
+release_3_5_7 admin 2023-12-16 23:40:01.417409
+move_shop_part_edit_right admin 2023-12-16 23:40:01.422614
+right_develop admin 2023-12-16 23:40:01.429334
+right_assortment_edit admin 2023-12-16 23:40:01.43762
+release_3_5_8 admin 2023-12-16 23:40:01.445316
+convert_columns_to_html_for_sending_html_emails admin 2023-12-16 23:40:01.453269
+release_3_6_0 admin 2023-12-16 23:40:01.460452
+rights_view_docs admin 2023-12-16 23:40:01.466624
+release_3_6_1 admin 2023-12-16 23:40:01.504979
\.
--
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
+049eb585707d5119cb85bccf45306235 127.0.0.1 2023-12-16 23:51:12.472004 830702af4b422a4eb07bc0e03f9450f7
\.
--
COPY auth.session_content (session_id, sess_key, sess_value, auto_restore) FROM stdin;
-f3f4f06687f44fadd001940ee2c76122 session_auth_status_root --- 0\n \N
+049eb585707d5119cb85bccf45306235 session_auth_status_root --- 0\n \N
\.
\.
+--
+-- Name: clients_id_seq; Type: SEQUENCE SET; Schema: auth; Owner: kivitendo
+--
+
+SELECT pg_catalog.setval('auth.clients_id_seq', 1, true);
+
+
+--
+-- Name: group_id_seq; Type: SEQUENCE SET; Schema: auth; Owner: kivitendo
+--
+
+SELECT pg_catalog.setval('auth.group_id_seq', 1, true);
+
+
+--
+-- Name: master_rights_id_seq; Type: SEQUENCE SET; Schema: auth; Owner: kivitendo
+--
+
+SELECT pg_catalog.setval('auth.master_rights_id_seq', 81, true);
+
+
--
-- Name: user_id_seq; Type: SEQUENCE SET; Schema: auth; Owner: kivitendo
--
--
--- Name: clients_dbhost_dbport_dbname_key; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
+-- Name: clients clients_dbhost_dbport_dbname_key; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
--
ALTER TABLE ONLY auth.clients
--
--- Name: clients_groups_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
+-- Name: clients_groups clients_groups_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
--
ALTER TABLE ONLY auth.clients_groups
--
--- Name: clients_name_key; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
+-- Name: clients clients_name_key; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
--
ALTER TABLE ONLY auth.clients
--
--- Name: clients_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
+-- Name: clients clients_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
--
ALTER TABLE ONLY auth.clients
--
--- Name: clients_users_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
+-- Name: clients_users clients_users_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
--
ALTER TABLE ONLY auth.clients_users
--
--- Name: group_name_key; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
+-- Name: group group_name_key; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
--
ALTER TABLE ONLY auth."group"
--
--- Name: group_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
+-- Name: group group_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
--
ALTER TABLE ONLY auth."group"
--
--- Name: group_rights_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
+-- Name: group_rights group_rights_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
--
ALTER TABLE ONLY auth.group_rights
--
--- Name: master_rights_name_key; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
+-- Name: master_rights master_rights_name_key; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
--
ALTER TABLE ONLY auth.master_rights
--
--- Name: master_rights_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
+-- Name: master_rights master_rights_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
--
ALTER TABLE ONLY auth.master_rights
--
--- Name: schema_info_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
+-- Name: schema_info schema_info_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
--
ALTER TABLE ONLY auth.schema_info
--
--- Name: session_content_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
+-- Name: session_content session_content_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
--
ALTER TABLE ONLY auth.session_content
--
--- Name: session_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
+-- Name: session session_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
--
ALTER TABLE ONLY auth.session
--
--- Name: user_config_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
+-- Name: user_config user_config_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
--
ALTER TABLE ONLY auth.user_config
--
--- Name: user_group_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
+-- Name: user_group user_group_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
--
ALTER TABLE ONLY auth.user_group
--
--- Name: user_login_key; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
+-- Name: user user_login_key; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
--
ALTER TABLE ONLY auth."user"
--
--- Name: user_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
+-- Name: user user_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
--
ALTER TABLE ONLY auth."user"
--
--- Name: clients_groups_client_id_fkey; Type: FK CONSTRAINT; Schema: auth; Owner: kivitendo
+-- Name: clients_groups clients_groups_client_id_fkey; Type: FK CONSTRAINT; Schema: auth; Owner: kivitendo
--
ALTER TABLE ONLY auth.clients_groups
--
--- Name: clients_groups_group_id_fkey; Type: FK CONSTRAINT; Schema: auth; Owner: kivitendo
+-- Name: clients_groups clients_groups_group_id_fkey; Type: FK CONSTRAINT; Schema: auth; Owner: kivitendo
--
ALTER TABLE ONLY auth.clients_groups
--
--- Name: clients_task_server_user_id_fkey; Type: FK CONSTRAINT; Schema: auth; Owner: kivitendo
+-- Name: clients clients_task_server_user_id_fkey; Type: FK CONSTRAINT; Schema: auth; Owner: kivitendo
--
ALTER TABLE ONLY auth.clients
--
--- Name: clients_users_client_id_fkey; Type: FK CONSTRAINT; Schema: auth; Owner: kivitendo
+-- Name: clients_users clients_users_client_id_fkey; Type: FK CONSTRAINT; Schema: auth; Owner: kivitendo
--
ALTER TABLE ONLY auth.clients_users
--
--- Name: clients_users_user_id_fkey; Type: FK CONSTRAINT; Schema: auth; Owner: kivitendo
+-- Name: clients_users clients_users_user_id_fkey; Type: FK CONSTRAINT; Schema: auth; Owner: kivitendo
--
ALTER TABLE ONLY auth.clients_users
--
--- Name: group_rights_group_id_fkey; Type: FK CONSTRAINT; Schema: auth; Owner: kivitendo
+-- Name: group_rights group_rights_group_id_fkey; Type: FK CONSTRAINT; Schema: auth; Owner: kivitendo
--
ALTER TABLE ONLY auth.group_rights
--
--- Name: session_content_session_id_fkey; Type: FK CONSTRAINT; Schema: auth; Owner: kivitendo
+-- Name: session_content session_content_session_id_fkey; Type: FK CONSTRAINT; Schema: auth; Owner: kivitendo
--
ALTER TABLE ONLY auth.session_content
--
--- Name: user_config_user_id_fkey; Type: FK CONSTRAINT; Schema: auth; Owner: kivitendo
+-- Name: user_config user_config_user_id_fkey; Type: FK CONSTRAINT; Schema: auth; Owner: kivitendo
--
ALTER TABLE ONLY auth.user_config
--
--- Name: user_group_group_id_fkey; Type: FK CONSTRAINT; Schema: auth; Owner: kivitendo
+-- Name: user_group user_group_group_id_fkey; Type: FK CONSTRAINT; Schema: auth; Owner: kivitendo
--
ALTER TABLE ONLY auth.user_group
--
--- Name: user_group_user_id_fkey; Type: FK CONSTRAINT; Schema: auth; Owner: kivitendo
+-- Name: user_group 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
--