-- -- PostgreSQL database dump -- -- 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); 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; SET default_tablespace = ''; SET default_table_access_method = heap; -- -- 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: 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: 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); -- -- 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 \. -- -- 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 \. -- -- 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 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 \. -- -- 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 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 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 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 61 950 shop_order Get shoporders 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 \. -- -- 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 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 \. -- -- Data for Name: session; Type: TABLE DATA; Schema: auth; Owner: kivitendo -- COPY auth.session (id, ip_address, mtime, api_token) FROM stdin; 049eb585707d5119cb85bccf45306235 127.0.0.1 2023-12-16 23:51:12.472004 830702af4b422a4eb07bc0e03f9450f7 \. -- -- 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; 049eb585707d5119cb85bccf45306235 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: 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 -- SELECT pg_catalog.setval('auth.user_id_seq', 1, true); -- -- Name: clients 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 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 clients_name_key; Type: CONSTRAINT; Schema: auth; Owner: kivitendo -- ALTER TABLE ONLY auth.clients ADD CONSTRAINT clients_name_key UNIQUE (name); -- -- Name: clients clients_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo -- ALTER TABLE ONLY auth.clients ADD CONSTRAINT clients_pkey PRIMARY KEY (id); -- -- Name: clients_users 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 group_name_key; Type: CONSTRAINT; Schema: auth; Owner: kivitendo -- ALTER TABLE ONLY auth."group" ADD CONSTRAINT group_name_key UNIQUE (name); -- -- Name: group group_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo -- ALTER TABLE ONLY auth."group" ADD CONSTRAINT group_pkey PRIMARY KEY (id); -- -- Name: group_rights 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 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 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 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 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 session_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo -- ALTER TABLE ONLY auth.session ADD CONSTRAINT session_pkey PRIMARY KEY (id); -- -- Name: user_config 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 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 user_login_key; Type: CONSTRAINT; Schema: auth; Owner: kivitendo -- ALTER TABLE ONLY auth."user" ADD CONSTRAINT user_login_key UNIQUE (login); -- -- Name: user user_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo -- ALTER TABLE ONLY auth."user" ADD CONSTRAINT user_pkey PRIMARY KEY (id); -- -- Name: clients_groups 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 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 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 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 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_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_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_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 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_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; -- -- PostgreSQL database dump complete --