2 -- PostgreSQL database dump
5 -- Dumped from database version 13.13 (Debian 13.13-0+deb11u1)
6 -- Dumped by pg_dump version 13.13 (Debian 13.13-0+deb11u1)
8 SET statement_timeout = 0;
10 SET idle_in_transaction_session_timeout = 0;
11 SET client_encoding = 'UTF8';
12 SET standard_conforming_strings = on;
13 SELECT pg_catalog.set_config('search_path', '', false);
14 SET check_function_bodies = false;
15 SET xmloption = content;
16 SET client_min_messages = warning;
17 SET row_security = off;
20 -- Name: auth; Type: SCHEMA; Schema: -; Owner: kivitendo
26 ALTER SCHEMA auth OWNER TO kivitendo;
28 SET default_tablespace = '';
30 SET default_table_access_method = heap;
33 -- Name: clients; Type: TABLE; Schema: auth; Owner: kivitendo
36 CREATE TABLE auth.clients (
40 dbport integer DEFAULT 5432 NOT NULL,
43 dbpasswd text NOT NULL,
44 is_default boolean DEFAULT false NOT NULL,
45 task_server_user_id integer
49 ALTER TABLE auth.clients OWNER TO kivitendo;
52 -- Name: clients_groups; Type: TABLE; Schema: auth; Owner: kivitendo
55 CREATE TABLE auth.clients_groups (
56 client_id integer NOT NULL,
57 group_id integer NOT NULL
61 ALTER TABLE auth.clients_groups OWNER TO kivitendo;
64 -- Name: clients_id_seq; Type: SEQUENCE; Schema: auth; Owner: kivitendo
67 CREATE SEQUENCE auth.clients_id_seq
75 ALTER TABLE auth.clients_id_seq OWNER TO kivitendo;
78 -- Name: clients_id_seq; Type: SEQUENCE OWNED BY; Schema: auth; Owner: kivitendo
81 ALTER SEQUENCE auth.clients_id_seq OWNED BY auth.clients.id;
85 -- Name: clients_users; Type: TABLE; Schema: auth; Owner: kivitendo
88 CREATE TABLE auth.clients_users (
89 client_id integer NOT NULL,
90 user_id integer NOT NULL
94 ALTER TABLE auth.clients_users OWNER TO kivitendo;
97 -- Name: group_id_seq; Type: SEQUENCE; Schema: auth; Owner: kivitendo
100 CREATE SEQUENCE auth.group_id_seq
108 ALTER TABLE auth.group_id_seq OWNER TO kivitendo;
111 -- Name: group; Type: TABLE; Schema: auth; Owner: kivitendo
114 CREATE TABLE auth."group" (
115 id integer DEFAULT nextval('auth.group_id_seq'::regclass) NOT NULL,
121 ALTER TABLE auth."group" OWNER TO kivitendo;
124 -- Name: group_rights; Type: TABLE; Schema: auth; Owner: kivitendo
127 CREATE TABLE auth.group_rights (
128 group_id integer NOT NULL,
129 "right" text NOT NULL,
130 granted boolean NOT NULL
134 ALTER TABLE auth.group_rights OWNER TO kivitendo;
137 -- Name: master_rights; Type: TABLE; Schema: auth; Owner: kivitendo
140 CREATE TABLE auth.master_rights (
142 "position" integer NOT NULL,
144 description text NOT NULL,
145 category boolean DEFAULT false NOT NULL
149 ALTER TABLE auth.master_rights OWNER TO kivitendo;
152 -- Name: master_rights_id_seq; Type: SEQUENCE; Schema: auth; Owner: kivitendo
155 CREATE SEQUENCE auth.master_rights_id_seq
163 ALTER TABLE auth.master_rights_id_seq OWNER TO kivitendo;
166 -- Name: master_rights_id_seq; Type: SEQUENCE OWNED BY; Schema: auth; Owner: kivitendo
169 ALTER SEQUENCE auth.master_rights_id_seq OWNED BY auth.master_rights.id;
173 -- Name: schema_info; Type: TABLE; Schema: auth; Owner: kivitendo
176 CREATE TABLE auth.schema_info (
179 itime timestamp without time zone DEFAULT now()
183 ALTER TABLE auth.schema_info OWNER TO kivitendo;
186 -- Name: session; Type: TABLE; Schema: auth; Owner: kivitendo
189 CREATE TABLE auth.session (
192 mtime timestamp without time zone,
197 ALTER TABLE auth.session OWNER TO kivitendo;
200 -- Name: session_content; Type: TABLE; Schema: auth; Owner: kivitendo
203 CREATE TABLE auth.session_content (
204 session_id text NOT NULL,
205 sess_key text NOT NULL,
211 ALTER TABLE auth.session_content OWNER TO kivitendo;
214 -- Name: user_id_seq; Type: SEQUENCE; Schema: auth; Owner: kivitendo
217 CREATE SEQUENCE auth.user_id_seq
225 ALTER TABLE auth.user_id_seq OWNER TO kivitendo;
228 -- Name: user; Type: TABLE; Schema: auth; Owner: kivitendo
231 CREATE TABLE auth."user" (
232 id integer DEFAULT nextval('auth.user_id_seq'::regclass) NOT NULL,
238 ALTER TABLE auth."user" OWNER TO kivitendo;
241 -- Name: user_config; Type: TABLE; Schema: auth; Owner: kivitendo
244 CREATE TABLE auth.user_config (
245 user_id integer NOT NULL,
246 cfg_key text NOT NULL,
251 ALTER TABLE auth.user_config OWNER TO kivitendo;
254 -- Name: user_group; Type: TABLE; Schema: auth; Owner: kivitendo
257 CREATE TABLE auth.user_group (
258 user_id integer NOT NULL,
259 group_id integer NOT NULL
263 ALTER TABLE auth.user_group OWNER TO kivitendo;
266 -- Name: clients id; Type: DEFAULT; Schema: auth; Owner: kivitendo
269 ALTER TABLE ONLY auth.clients ALTER COLUMN id SET DEFAULT nextval('auth.clients_id_seq'::regclass);
273 -- Name: master_rights id; Type: DEFAULT; Schema: auth; Owner: kivitendo
276 ALTER TABLE ONLY auth.master_rights ALTER COLUMN id SET DEFAULT nextval('auth.master_rights_id_seq'::regclass);
280 -- Data for Name: clients; Type: TABLE DATA; Schema: auth; Owner: kivitendo
283 COPY auth.clients (id, name, dbhost, dbport, dbname, dbuser, dbpasswd, is_default, task_server_user_id) FROM stdin;
284 1 firma localhost 5432 firma kivitendo kivitendo t \N
289 -- Data for Name: clients_groups; Type: TABLE DATA; Schema: auth; Owner: kivitendo
292 COPY auth.clients_groups (client_id, group_id) FROM stdin;
298 -- Data for Name: clients_users; Type: TABLE DATA; Schema: auth; Owner: kivitendo
301 COPY auth.clients_users (client_id, user_id) FROM stdin;
307 -- Data for Name: group; Type: TABLE DATA; Schema: auth; Owner: kivitendo
310 COPY auth."group" (id, name, description) FROM stdin;
311 1 Vollzugriff Vollzugriff
316 -- Data for Name: group_rights; Type: TABLE DATA; Schema: auth; Owner: kivitendo
319 COPY auth.group_rights (group_id, "right", granted) FROM stdin;
320 1 customer_vendor_edit t
321 1 customer_vendor_all_edit t
322 1 part_service_assembly_edit t
323 1 part_service_assembly_details t
327 1 project_edit_view_invoices_permission t
328 1 show_extra_record_tab_customer t
329 1 show_extra_record_tab_vendor t
330 1 requirement_spec_edit t
331 1 sales_quotation_edit t
334 1 sales_delivery_order_edit t
337 1 sales_letter_edit t
339 1 sales_edit_prices t
340 1 show_ar_transactions t
342 1 delivery_value_report t
343 1 sales_letter_report t
345 1 request_quotation_edit t
346 1 purchase_order_edit t
347 1 purchase_delivery_order_edit t
348 1 vendor_invoice_edit t
349 1 purchase_letter_edit t
350 1 purchase_all_edit t
351 1 purchase_edit_prices t
352 1 show_ap_transactions t
353 1 purchase_letter_report t
355 1 warehouse_contents t
356 1 warehouse_management t
365 1 advance_turnover_tax_return t
370 1 custom_data_export_designer t
373 1 email_employee_readall f
375 1 display_admin_link f
379 1 time_recording_show_all t
380 1 time_recording_edit_all t
382 1 request_quotation_view t
383 1 sales_invoice_view t
384 1 purchase_invoice_view t
385 1 sales_delivery_order_view t
386 1 purchase_delivery_order_view t
387 1 sales_quotation_view t
388 1 purchase_order_view t
394 -- Data for Name: master_rights; Type: TABLE DATA; Schema: auth; Owner: kivitendo
397 COPY auth.master_rights (id, "position", name, description, category) FROM stdin;
398 1 100 master_data Master Data t
399 2 200 customer_vendor_edit Create customers and vendors. Edit all vendors. Edit only customers where salesman equals employee (login) f
400 3 300 customer_vendor_all_edit Create customers and vendors. Edit all vendors. Edit all customers f
401 4 400 part_service_assembly_edit Create and edit parts, services, assemblies f
402 5 500 part_service_assembly_details Show details and reports of parts, services, assemblies f
403 6 600 project_edit Create and edit projects f
405 8 800 requirement_spec_edit Create and edit requirement specs f
406 9 900 sales_quotation_edit Create and edit sales quotations f
407 10 1000 sales_order_edit Create and edit sales orders f
408 11 1100 sales_delivery_order_edit Create and edit sales delivery orders f
409 12 1200 invoice_edit Create and edit invoices and credit notes f
410 13 1300 dunning_edit Create and edit dunnings f
411 14 1400 sales_letter_edit Edit sales letters f
412 15 1500 sales_all_edit View/edit all employees sales documents f
413 17 1700 show_ar_transactions Show AR transactions as part of AR invoice report f
414 18 1800 delivery_plan Show delivery plan f
415 19 1900 delivery_value_report Show delivery value report f
416 20 2000 sales_letter_report Show sales letters report f
418 22 2200 request_quotation_edit Create and edit RFQs f
419 23 2300 purchase_order_edit Create and edit purchase orders f
420 24 2400 purchase_delivery_order_edit Create and edit purchase delivery orders f
421 25 2500 vendor_invoice_edit Create and edit vendor invoices f
422 26 2600 show_ap_transactions Show AP transactions as part of AP invoice report f
423 27 2700 warehouse Warehouse management t
424 28 2800 warehouse_contents View warehouse content f
425 29 2900 warehouse_management Warehouse management f
426 30 3000 general_ledger_cash General ledger and cash t
427 32 3200 datev_export DATEV Export f
428 33 3300 cash Receipt, payment, reconciliation f
429 34 3400 bank_transaction Bank transactions f
430 35 3500 reports Reports t
431 36 3600 report All reports f
432 37 3700 advance_turnover_tax_return Advance turnover tax return f
433 38 3800 batch_printing_category Batch Printing t
434 39 3900 batch_printing Batch Printing f
435 31 3100 general_ledger AP/AR Aging & Journal f
436 16 1600 sales_edit_prices Edit prices and discount (if not used, textfield is ONLY set readonly) f
437 50 2050 import_ar Import AR from Scanner or Email f
438 52 2550 purchase_letter_edit Edit purchase letters f
439 53 2650 purchase_letter_report Show purchase letters report f
440 55 3130 gl_transactions General Ledger Transaction f
441 56 3150 ar_transactions AR Transactions f
442 57 3170 ap_transactions AP Transactions f
443 51 2680 import_ap Import AP from Scanner or Email f
444 58 550 assembly_edit Always edit assembly items (user can change/delete items even if assemblies are already produced) f
445 61 950 shop_order Get shoporders f
446 63 610 show_extra_record_tab_customer Show record tab in customer f
447 64 611 show_extra_record_tab_vendor Show record tab in vendor f
448 65 602 project_edit_view_invoices_permission Projects: edit the list of employees allowed to view invoices f
449 66 2560 purchase_all_edit View/edit all employees purchase documents f
450 67 2570 purchase_edit_prices Edit prices and discount (if not used, textfield is ONLY set readonly) f
451 40 5000 configuration Configuration t
452 41 5100 config Change kivitendo installation settings (most entries in the 'System' menu) f
453 42 5200 admin Client administration: configuration, editing templates, task server control, background jobs (remaining entries in the 'System' menu) f
454 43 5300 others Others t
455 44 5400 email_bcc May set the BCC field when sending emails f
456 69 4300 time_recording Create, edit and list time recordings f
457 46 5600 display_admin_link Show administration link f
458 47 6000 all_drafts_edit Edit all drafts f
459 70 4320 time_recording_show_all List time recordings of all staff members f
460 71 4340 time_recording_edit_all Edit time recordings of all staff members f
461 54 5750 record_links Linked Records f
462 59 5275 custom_data_export_designer Custom data export f
463 62 5250 edit_shop_config Create and edit webshops f
464 68 4000 productivity_category Productivity t
465 45 4100 productivity Productivity (TODO list, Follow-Ups) f
466 48 4200 email_journal E-Mail-Journal f
467 49 4250 email_employee_readall Read all employee e-mails f
468 60 580 shop_part_edit Create and edit shopparts f
469 72 5220 developer See various menu entries intended for developers f
470 73 560 assortment_edit Always edit assortment items (user can change/delete items even if assortments are already used) f
471 74 910 sales_quotation_view View sales quotations f
472 75 1010 sales_order_view View sales orders f
473 76 1110 sales_delivery_order_view View sales delivery orders f
474 77 1210 sales_invoice_view View sales invoices and credit notes f
475 78 2210 request_quotation_view View RFQs f
476 79 2310 purchase_order_view View purchase orders f
477 80 2410 purchase_delivery_order_view View purchase delivery orders f
478 81 2510 purchase_invoice_view View purchase invoices f
483 -- Data for Name: schema_info; Type: TABLE DATA; Schema: auth; Owner: kivitendo
486 COPY auth.schema_info (tag, login, itime) FROM stdin;
487 add_api_token admin 2018-11-30 19:52:50.606337
488 add_batch_printing_to_full_access admin 2018-11-30 19:52:50.612204
489 auth_schema_normalization_1 admin 2018-11-30 19:52:50.679835
490 password_hashing admin 2018-11-30 19:52:50.757564
491 remove_menustyle_v4 admin 2018-11-30 19:52:50.787919
492 remove_menustyle_xml admin 2018-11-30 19:52:50.79445
493 session_content_auto_restore admin 2018-11-30 19:52:50.799888
494 release_3_0_0 admin 2018-11-30 19:52:50.831311
495 clients admin 2018-11-30 19:52:50.877394
496 clients_webdav admin 2018-11-30 19:52:50.98643
497 foreign_key_constraints_on_delete admin 2018-11-30 19:52:50.993769
498 release_3_2_0 admin 2018-11-30 19:52:51.066536
499 add_master_rights admin 2018-11-30 19:52:51.076355
500 bank_transaction_rights admin 2018-11-30 19:52:51.158372
501 delivery_plan_rights admin 2018-11-30 19:52:51.184635
502 delivery_process_value admin 2018-11-30 19:52:51.192706
503 details_and_report_of_parts admin 2018-11-30 19:52:51.221993
504 productivity_rights admin 2018-11-30 19:52:51.232101
505 requirement_spec_rights admin 2018-11-30 19:52:51.255307
506 rights_for_showing_ar_and_ap_transactions admin 2018-11-30 19:52:51.262267
507 sales_letter_rights admin 2018-11-30 19:52:51.2917
508 release_3_3_0 admin 2018-11-30 19:52:51.296489
509 client_task_server admin 2018-11-30 19:52:51.304536
510 remove_insecurely_hashed_passwords admin 2018-11-30 19:52:51.33197
511 session_content_primary_key admin 2018-11-30 19:52:51.339007
512 release_3_4_0 admin 2018-11-30 19:52:51.368148
513 master_rights_position_gaps admin 2021-01-16 23:27:44.749094
514 all_drafts_edit admin 2021-01-16 23:27:44.847437
515 mail_journal_rights admin 2021-01-16 23:27:44.899515
516 other_file_sources admin 2021-01-16 23:27:44.931875
517 purchase_letter_rights admin 2021-01-16 23:27:44.946762
518 record_links_rights admin 2021-01-16 23:27:44.964905
519 split_transaction_rights admin 2021-01-16 23:27:44.984987
520 other_file_sources2 admin 2021-01-16 23:27:45.030195
521 rename_general_ledger_rights admin 2021-01-16 23:27:45.043693
522 release_3_5_0 admin 2021-01-16 23:27:45.066912
523 assembly_edit_right admin 2021-01-16 23:27:45.095898
524 custom_data_export_rights admin 2021-01-16 23:27:45.120899
525 webshop_api_rights admin 2021-01-16 23:27:45.140731
526 webshop_api_rights_2 admin 2021-01-16 23:27:45.167397
527 release_3_5_1 admin 2021-01-16 23:27:45.175067
528 release_3_5_2 admin 2021-01-16 23:27:45.183556
529 customer_vendor_record_extra_tab_rights admin 2021-01-16 23:27:45.189809
530 release_3_5_3 admin 2021-01-16 23:27:45.19872
531 rights_for_viewing_project_specific_invoices admin 2021-01-16 23:27:45.210894
532 release_3_5_4 admin 2021-01-16 23:27:45.21948
533 right_purchase_all_edit admin 2021-01-16 23:27:45.227773
534 rights_sales_purchase_edit_prices admin 2021-01-16 23:27:45.256678
535 master_rights_positions_fix admin 2021-01-16 23:27:45.267954
536 release_3_5_5 admin 2021-01-16 23:27:45.285413
537 release_3_5_6 admin 2021-01-16 23:27:45.313788
538 release_3_5_6_1 admin 2021-01-16 23:27:45.326867
539 right_productivity_as_category admin 2023-12-16 23:40:01.312572
540 right_time_recording admin 2023-12-16 23:40:01.391342
541 rights_time_recording_show_edit_all admin 2023-12-16 23:40:01.402884
542 release_3_5_7 admin 2023-12-16 23:40:01.417409
543 move_shop_part_edit_right admin 2023-12-16 23:40:01.422614
544 right_develop admin 2023-12-16 23:40:01.429334
545 right_assortment_edit admin 2023-12-16 23:40:01.43762
546 release_3_5_8 admin 2023-12-16 23:40:01.445316
547 convert_columns_to_html_for_sending_html_emails admin 2023-12-16 23:40:01.453269
548 release_3_6_0 admin 2023-12-16 23:40:01.460452
549 rights_view_docs admin 2023-12-16 23:40:01.466624
550 release_3_6_1 admin 2023-12-16 23:40:01.504979
555 -- Data for Name: session; Type: TABLE DATA; Schema: auth; Owner: kivitendo
558 COPY auth.session (id, ip_address, mtime, api_token) FROM stdin;
559 049eb585707d5119cb85bccf45306235 127.0.0.1 2023-12-16 23:51:12.472004 830702af4b422a4eb07bc0e03f9450f7
564 -- Data for Name: session_content; Type: TABLE DATA; Schema: auth; Owner: kivitendo
567 COPY auth.session_content (session_id, sess_key, sess_value, auto_restore) FROM stdin;
568 049eb585707d5119cb85bccf45306235 session_auth_status_root --- 0\n \N
573 -- Data for Name: user; Type: TABLE DATA; Schema: auth; Owner: kivitendo
576 COPY auth."user" (id, login, password) FROM stdin;
577 1 michael {PBKDF2}eb582ba54e6c4aefdf12345026c9e4eb8e:42f75af3ca486e0de3e9d6e655d1db0f0e8122b0040f3f64ac92ff683e89a1ed
582 -- Data for Name: user_config; Type: TABLE DATA; Schema: auth; Owner: kivitendo
585 COPY auth.user_config (user_id, cfg_key, cfg_value) FROM stdin;
586 1 mandatory_departments 0
588 1 numberformat 1.000,00
594 1 dateformat dd.mm.yy
595 1 stylesheet kivitendo.css
604 -- Data for Name: user_group; Type: TABLE DATA; Schema: auth; Owner: kivitendo
607 COPY auth.user_group (user_id, group_id) FROM stdin;
613 -- Name: clients_id_seq; Type: SEQUENCE SET; Schema: auth; Owner: kivitendo
616 SELECT pg_catalog.setval('auth.clients_id_seq', 1, true);
620 -- Name: group_id_seq; Type: SEQUENCE SET; Schema: auth; Owner: kivitendo
623 SELECT pg_catalog.setval('auth.group_id_seq', 1, true);
627 -- Name: master_rights_id_seq; Type: SEQUENCE SET; Schema: auth; Owner: kivitendo
630 SELECT pg_catalog.setval('auth.master_rights_id_seq', 81, true);
634 -- Name: user_id_seq; Type: SEQUENCE SET; Schema: auth; Owner: kivitendo
637 SELECT pg_catalog.setval('auth.user_id_seq', 1, true);
641 -- Name: clients clients_dbhost_dbport_dbname_key; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
644 ALTER TABLE ONLY auth.clients
645 ADD CONSTRAINT clients_dbhost_dbport_dbname_key UNIQUE (dbhost, dbport, dbname);
649 -- Name: clients_groups clients_groups_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
652 ALTER TABLE ONLY auth.clients_groups
653 ADD CONSTRAINT clients_groups_pkey PRIMARY KEY (client_id, group_id);
657 -- Name: clients clients_name_key; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
660 ALTER TABLE ONLY auth.clients
661 ADD CONSTRAINT clients_name_key UNIQUE (name);
665 -- Name: clients clients_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
668 ALTER TABLE ONLY auth.clients
669 ADD CONSTRAINT clients_pkey PRIMARY KEY (id);
673 -- Name: clients_users clients_users_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
676 ALTER TABLE ONLY auth.clients_users
677 ADD CONSTRAINT clients_users_pkey PRIMARY KEY (client_id, user_id);
681 -- Name: group group_name_key; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
684 ALTER TABLE ONLY auth."group"
685 ADD CONSTRAINT group_name_key UNIQUE (name);
689 -- Name: group group_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
692 ALTER TABLE ONLY auth."group"
693 ADD CONSTRAINT group_pkey PRIMARY KEY (id);
697 -- Name: group_rights group_rights_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
700 ALTER TABLE ONLY auth.group_rights
701 ADD CONSTRAINT group_rights_pkey PRIMARY KEY (group_id, "right");
705 -- Name: master_rights master_rights_name_key; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
708 ALTER TABLE ONLY auth.master_rights
709 ADD CONSTRAINT master_rights_name_key UNIQUE (name);
713 -- Name: master_rights master_rights_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
716 ALTER TABLE ONLY auth.master_rights
717 ADD CONSTRAINT master_rights_pkey PRIMARY KEY (id);
721 -- Name: schema_info schema_info_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
724 ALTER TABLE ONLY auth.schema_info
725 ADD CONSTRAINT schema_info_pkey PRIMARY KEY (tag);
729 -- Name: session_content session_content_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
732 ALTER TABLE ONLY auth.session_content
733 ADD CONSTRAINT session_content_pkey PRIMARY KEY (session_id, sess_key);
737 -- Name: session session_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
740 ALTER TABLE ONLY auth.session
741 ADD CONSTRAINT session_pkey PRIMARY KEY (id);
745 -- Name: user_config user_config_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
748 ALTER TABLE ONLY auth.user_config
749 ADD CONSTRAINT user_config_pkey PRIMARY KEY (user_id, cfg_key);
753 -- Name: user_group user_group_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
756 ALTER TABLE ONLY auth.user_group
757 ADD CONSTRAINT user_group_pkey PRIMARY KEY (user_id, group_id);
761 -- Name: user user_login_key; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
764 ALTER TABLE ONLY auth."user"
765 ADD CONSTRAINT user_login_key UNIQUE (login);
769 -- Name: user user_pkey; Type: CONSTRAINT; Schema: auth; Owner: kivitendo
772 ALTER TABLE ONLY auth."user"
773 ADD CONSTRAINT user_pkey PRIMARY KEY (id);
777 -- Name: clients_groups clients_groups_client_id_fkey; Type: FK CONSTRAINT; Schema: auth; Owner: kivitendo
780 ALTER TABLE ONLY auth.clients_groups
781 ADD CONSTRAINT clients_groups_client_id_fkey FOREIGN KEY (client_id) REFERENCES auth.clients(id) ON DELETE CASCADE;
785 -- Name: clients_groups clients_groups_group_id_fkey; Type: FK CONSTRAINT; Schema: auth; Owner: kivitendo
788 ALTER TABLE ONLY auth.clients_groups
789 ADD CONSTRAINT clients_groups_group_id_fkey FOREIGN KEY (group_id) REFERENCES auth."group"(id) ON DELETE CASCADE;
793 -- Name: clients clients_task_server_user_id_fkey; Type: FK CONSTRAINT; Schema: auth; Owner: kivitendo
796 ALTER TABLE ONLY auth.clients
797 ADD CONSTRAINT clients_task_server_user_id_fkey FOREIGN KEY (task_server_user_id) REFERENCES auth."user"(id);
801 -- Name: clients_users clients_users_client_id_fkey; Type: FK CONSTRAINT; Schema: auth; Owner: kivitendo
804 ALTER TABLE ONLY auth.clients_users
805 ADD CONSTRAINT clients_users_client_id_fkey FOREIGN KEY (client_id) REFERENCES auth.clients(id) ON DELETE CASCADE;
809 -- Name: clients_users clients_users_user_id_fkey; Type: FK CONSTRAINT; Schema: auth; Owner: kivitendo
812 ALTER TABLE ONLY auth.clients_users
813 ADD CONSTRAINT clients_users_user_id_fkey FOREIGN KEY (user_id) REFERENCES auth."user"(id) ON DELETE CASCADE;
817 -- Name: group_rights group_rights_group_id_fkey; Type: FK CONSTRAINT; Schema: auth; Owner: kivitendo
820 ALTER TABLE ONLY auth.group_rights
821 ADD CONSTRAINT group_rights_group_id_fkey FOREIGN KEY (group_id) REFERENCES auth."group"(id) ON DELETE CASCADE;
825 -- Name: session_content session_content_session_id_fkey; Type: FK CONSTRAINT; Schema: auth; Owner: kivitendo
828 ALTER TABLE ONLY auth.session_content
829 ADD CONSTRAINT session_content_session_id_fkey FOREIGN KEY (session_id) REFERENCES auth.session(id) ON DELETE CASCADE;
833 -- Name: user_config user_config_user_id_fkey; Type: FK CONSTRAINT; Schema: auth; Owner: kivitendo
836 ALTER TABLE ONLY auth.user_config
837 ADD CONSTRAINT user_config_user_id_fkey FOREIGN KEY (user_id) REFERENCES auth."user"(id) ON DELETE CASCADE;
841 -- Name: user_group user_group_group_id_fkey; Type: FK CONSTRAINT; Schema: auth; Owner: kivitendo
844 ALTER TABLE ONLY auth.user_group
845 ADD CONSTRAINT user_group_group_id_fkey FOREIGN KEY (group_id) REFERENCES auth."group"(id) ON DELETE CASCADE;
849 -- Name: user_group user_group_user_id_fkey; Type: FK CONSTRAINT; Schema: auth; Owner: kivitendo
852 ALTER TABLE ONLY auth.user_group
853 ADD CONSTRAINT user_group_user_id_fkey FOREIGN KEY (user_id) REFERENCES auth."user"(id) ON DELETE CASCADE;
857 -- PostgreSQL database dump complete