X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=Test%2Fetc%2Fauth.dump;h=1f3ed9ccbca141407c00ee2f6577c823ccc1ead1;hb=ff159a4d47b9a2d10744dcfc23da2c63605c8a32;hp=ffad8010acdf29a2730266ba2c0c898b290fccd3;hpb=b74d1c197c8365b14587838d999244274de12884;p=kivitendo-erp.git diff --git a/Test/etc/auth.dump b/Test/etc/auth.dump index ffad8010a..1f3ed9ccb 100644 --- a/Test/etc/auth.dump +++ b/Test/etc/auth.dump @@ -2,11 +2,12 @@ -- 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); @@ -24,23 +25,9 @@ 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; +SET default_table_access_method = heap; -- -- Name: clients; Type: TABLE; Schema: auth; Owner: kivitendo @@ -276,14 +263,14 @@ CREATE TABLE auth.user_group ( 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); @@ -307,13 +294,6 @@ COPY auth.clients_groups (client_id, group_id) FROM stdin; \. --- --- 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 -- @@ -332,13 +312,6 @@ COPY auth."group" (id, name, description) FROM stdin; \. --- --- 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 -- @@ -402,6 +375,18 @@ COPY auth.group_rights (group_id, "right", granted) FROM stdin; 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 \. @@ -447,46 +432,53 @@ COPY auth.master_rights (id, "position", name, description, category) FROM stdin 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 -- @@ -544,6 +536,18 @@ 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 +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 \. @@ -552,8 +556,7 @@ release_3_5_6_1 admin 2021-01-16 23:27:45.326867 -- 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 \. @@ -562,7 +565,7 @@ f3f4f06687f44fadd001940ee2c76122 127.0.0.1 2021-01-18 19:39:08.564014 3f1fef3555 -- 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 \. @@ -606,6 +609,27 @@ COPY auth.user_group (user_id, group_id) FROM stdin; \. +-- +-- 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 -- @@ -614,7 +638,7 @@ SELECT pg_catalog.setval('auth.user_id_seq', 1, true); -- --- 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 @@ -622,7 +646,7 @@ 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 @@ -630,7 +654,7 @@ 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 @@ -638,7 +662,7 @@ 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 @@ -646,7 +670,7 @@ 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 @@ -654,7 +678,7 @@ 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" @@ -662,7 +686,7 @@ 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" @@ -670,7 +694,7 @@ 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 @@ -678,7 +702,7 @@ 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 @@ -686,7 +710,7 @@ 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 @@ -694,7 +718,7 @@ 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 @@ -702,7 +726,7 @@ 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 @@ -710,7 +734,7 @@ 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 @@ -718,7 +742,7 @@ 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 @@ -726,7 +750,7 @@ 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 @@ -734,7 +758,7 @@ 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" @@ -742,7 +766,7 @@ 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" @@ -750,7 +774,7 @@ 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 @@ -758,7 +782,7 @@ 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 @@ -766,7 +790,7 @@ 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 @@ -774,7 +798,7 @@ 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 @@ -782,7 +806,7 @@ 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 @@ -790,7 +814,7 @@ 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 @@ -798,7 +822,7 @@ 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 @@ -806,7 +830,7 @@ 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 @@ -814,7 +838,7 @@ 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 @@ -822,23 +846,13 @@ 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 --