X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/d9b9f30e2069206797d6154cfe6570677b071487..d5fa8afe0bfdcc2800994ec08778a500cf5a55ae:/Test/etc/auth.dump diff --git a/Test/etc/auth.dump b/Test/etc/auth.dump new file mode 100644 index 000000000..ffad8010a --- /dev/null +++ b/Test/etc/auth.dump @@ -0,0 +1,845 @@ +-- +-- 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 +-- +