mirror of
https://github.com/complexcaresolutions/cms.c2sgmbh.git
synced 2026-03-17 22:04:10 +00:00
Martin Porwoll
d18e58de40
Jobs: - Add consentRetentionJob.ts for GDPR consent cleanup - Add scheduler.ts for background job scheduling Backups: - Add database backup files for recovery Migration backups: - Archive old migration files for reference 🤖 Generated with [Claude Code](https://claude.com/claude-code) Co-Authored-By: Claude <noreply@anthropic.com>
288 lines
16 KiB
SQL
288 lines
16 KiB
SQL
perl: warning: Setting locale failed.
|
|
perl: warning: Please check that your locale settings:
|
|
LANGUAGE = (unset),
|
|
LC_ALL = (unset),
|
|
LC_CTYPE = (unset),
|
|
LC_NUMERIC = (unset),
|
|
LC_COLLATE = (unset),
|
|
LC_TIME = (unset),
|
|
LC_MESSAGES = (unset),
|
|
LC_MONETARY = (unset),
|
|
LC_ADDRESS = (unset),
|
|
LC_IDENTIFICATION = (unset),
|
|
LC_MEASUREMENT = (unset),
|
|
LC_PAPER = (unset),
|
|
LC_TELEPHONE = (unset),
|
|
LC_NAME = (unset),
|
|
LANG = "en_US.UTF-8"
|
|
are supported and installed on your system.
|
|
perl: warning: Falling back to the standard locale ("C").
|
|
--
|
|
-- PostgreSQL database dump
|
|
--
|
|
|
|
|
|
-- Dumped from database version 17.6 (Debian 17.6-0+deb13u1)
|
|
-- Dumped by pg_dump version 17.6 (Debian 17.6-0+deb13u1)
|
|
|
|
SET statement_timeout = 0;
|
|
SET lock_timeout = 0;
|
|
SET idle_in_transaction_session_timeout = 0;
|
|
SET transaction_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;
|
|
|
|
--
|
|
-- Data for Name: tenants; Type: TABLE DATA; Schema: public; Owner: payload
|
|
--
|
|
|
|
INSERT INTO public.tenants (id, name, slug, updated_at, created_at) VALUES (1, 'porwoll.de', 'porwoll', '2025-11-26 20:33:47.509+00', '2025-11-26 20:33:47.508+00');
|
|
INSERT INTO public.tenants (id, name, slug, updated_at, created_at) VALUES (5, 'gunshin.de', 'gunshin', '2025-11-26 20:52:12.512+00', '2025-11-26 20:48:19.022+00');
|
|
INSERT INTO public.tenants (id, name, slug, updated_at, created_at) VALUES (4, 'complexcaresolutions.de', 'c2s', '2025-11-26 20:52:27.533+00', '2025-11-26 20:44:51.215+00');
|
|
INSERT INTO public.tenants (id, name, slug, updated_at, created_at) VALUES (6, 'zweitmein.ng', 'zweitmeinung', '2025-11-26 22:10:55.937+00', '2025-11-26 22:08:11.071+00');
|
|
|
|
|
|
--
|
|
-- Data for Name: categories; Type: TABLE DATA; Schema: public; Owner: payload
|
|
--
|
|
|
|
INSERT INTO public.categories (id, tenant_id, name, slug, description, updated_at, created_at) VALUES (1, 1, 'Whistleblowing', 'whistleblowing', 'Artikel zum Thema Whistleblowing und Zytoskandal', '2025-11-27 10:01:53.601+00', '2025-11-27 10:01:53.601+00');
|
|
INSERT INTO public.categories (id, tenant_id, name, slug, description, updated_at, created_at) VALUES (2, 1, 'Unternehmer', 'unternehmer', 'Artikel über unternehmerische Aktivitäten', '2025-11-27 10:02:09.569+00', '2025-11-27 10:02:09.569+00');
|
|
|
|
|
|
--
|
|
-- Data for Name: cookie_configurations; Type: TABLE DATA; Schema: public; Owner: payload
|
|
--
|
|
|
|
|
|
|
|
--
|
|
-- Data for Name: cookie_configurations_enabled_categories; Type: TABLE DATA; Schema: public; Owner: payload
|
|
--
|
|
|
|
|
|
|
|
--
|
|
-- Data for Name: cookie_inventory; Type: TABLE DATA; Schema: public; Owner: payload
|
|
--
|
|
|
|
|
|
|
|
--
|
|
-- Data for Name: media; Type: TABLE DATA; Schema: public; Owner: payload
|
|
--
|
|
|
|
INSERT INTO public.media (id, alt, updated_at, created_at, url, thumbnail_u_r_l, filename, mime_type, filesize, width, height, focal_x, focal_y, tenant_id) VALUES (1, 'Favicon Porwoll', '2025-11-27 09:58:48.629+00', '2025-11-27 09:58:48.629+00', NULL, NULL, 'Favicon-270x270.jpg', 'image/jpeg', 12068, 270, 270, 50, 50, 1);
|
|
INSERT INTO public.media (id, alt, updated_at, created_at, url, thumbnail_u_r_l, filename, mime_type, filesize, width, height, focal_x, focal_y, tenant_id) VALUES (2, 'gunshin Holding UG Logo', '2025-11-27 10:20:21.25+00', '2025-11-27 10:20:21.25+00', NULL, NULL, 'gunshin-logo-1168x487-1.webp', 'image/webp', 29586, 1168, 487, 50, 50, 1);
|
|
INSERT INTO public.media (id, alt, updated_at, created_at, url, thumbnail_u_r_l, filename, mime_type, filesize, width, height, focal_x, focal_y, tenant_id) VALUES (3, 'Martin Porwoll - Portrait', '2025-11-27 10:20:55.311+00', '2025-11-27 10:20:55.311+00', NULL, NULL, 'martin-porwoll-frontal-1-1168x768-1.jpeg', 'image/jpeg', 40379, 714, 768, 50, 50, 1);
|
|
INSERT INTO public.media (id, alt, updated_at, created_at, url, thumbnail_u_r_l, filename, mime_type, filesize, width, height, focal_x, focal_y, tenant_id) VALUES (4, 'Martin Porwoll - Portrait', '2025-11-27 10:21:07.637+00', '2025-11-27 10:21:07.637+00', NULL, NULL, 'martin-porwoll-frontal-1-1168x768-1.webp', 'image/webp', 5650, 714, 768, 50, 50, 1);
|
|
INSERT INTO public.media (id, alt, updated_at, created_at, url, thumbnail_u_r_l, filename, mime_type, filesize, width, height, focal_x, focal_y, tenant_id) VALUES (5, 'Abstrakte Darstellung von Vision und Innovation', '2025-11-27 10:22:04.816+00', '2025-11-27 10:22:04.816+00', NULL, NULL, 'adobestock-432768272kopie-2576x2050-1-scaled.webp', 'image/webp', 95954, 2560, 2037, 50, 50, 1);
|
|
INSERT INTO public.media (id, alt, updated_at, created_at, url, thumbnail_u_r_l, filename, mime_type, filesize, width, height, focal_x, focal_y, tenant_id) VALUES (6, 'Team-Erfolg und Zusammenarbeit', '2025-11-27 10:24:47.406+00', '2025-11-27 10:24:47.406+00', NULL, NULL, 'Erfolg_und_Zusammenarbeit.webp', 'image/webp', 133848, 2560, 1706, 50, 50, 1);
|
|
INSERT INTO public.media (id, alt, updated_at, created_at, url, thumbnail_u_r_l, filename, mime_type, filesize, width, height, focal_x, focal_y, tenant_id) VALUES (7, 'porwoll.de Favicon', '2025-11-27 12:44:07.743+00', '2025-11-27 12:44:07.743+00', NULL, NULL, 'favicon.jpg', 'image/jpeg', 12068, 270, 270, 50, 50, 1);
|
|
|
|
|
|
--
|
|
-- Data for Name: navigation; Type: TABLE DATA; Schema: public; Owner: payload
|
|
--
|
|
|
|
INSERT INTO public.navigation (id, updated_at, created_at) VALUES (1, '2025-11-27 12:46:01.591+00', '2025-11-27 12:46:01.591+00');
|
|
|
|
|
|
--
|
|
-- Data for Name: navigation_footer_menu; Type: TABLE DATA; Schema: public; Owner: payload
|
|
--
|
|
|
|
INSERT INTO public.navigation_footer_menu (_order, _parent_id, id, label, link_type, page_id, url) VALUES (1, 1, '69284809b6871dae2fda6e82', 'Impressum', 'page', 9, NULL);
|
|
INSERT INTO public.navigation_footer_menu (_order, _parent_id, id, label, link_type, page_id, url) VALUES (2, 1, '69284809b6871dae2fda6e83', 'Datenschutzerklärung', 'page', 10, NULL);
|
|
|
|
|
|
--
|
|
-- Data for Name: navigation_main_menu; Type: TABLE DATA; Schema: public; Owner: payload
|
|
--
|
|
|
|
INSERT INTO public.navigation_main_menu (_order, _parent_id, id, label, type, page_id, url, open_in_new_tab) VALUES (1, 1, '69284809b6871dae2fda6e7c', 'Whistleblowing', 'submenu', NULL, NULL, false);
|
|
INSERT INTO public.navigation_main_menu (_order, _parent_id, id, label, type, page_id, url, open_in_new_tab) VALUES (2, 1, '69284809b6871dae2fda6e7f', 'Unternehmer', 'submenu', NULL, NULL, false);
|
|
INSERT INTO public.navigation_main_menu (_order, _parent_id, id, label, type, page_id, url, open_in_new_tab) VALUES (3, 1, '69284809b6871dae2fda6e80', 'Mensch', 'page', 2, NULL, false);
|
|
INSERT INTO public.navigation_main_menu (_order, _parent_id, id, label, type, page_id, url, open_in_new_tab) VALUES (4, 1, '69284809b6871dae2fda6e81', 'Kontakt', 'page', 3, NULL, false);
|
|
|
|
|
|
--
|
|
-- Data for Name: navigation_main_menu_submenu; Type: TABLE DATA; Schema: public; Owner: payload
|
|
--
|
|
|
|
INSERT INTO public.navigation_main_menu_submenu (_order, _parent_id, id, label, link_type, page_id, url) VALUES (1, '69284809b6871dae2fda6e7c', '69284809b6871dae2fda6e7a', 'Zytoskandal', 'page', 5, NULL);
|
|
INSERT INTO public.navigation_main_menu_submenu (_order, _parent_id, id, label, link_type, page_id, url) VALUES (2, '69284809b6871dae2fda6e7c', '69284809b6871dae2fda6e7b', 'Whistleblowing', 'page', 4, NULL);
|
|
INSERT INTO public.navigation_main_menu_submenu (_order, _parent_id, id, label, link_type, page_id, url) VALUES (1, '69284809b6871dae2fda6e7f', '69284809b6871dae2fda6e7d', 'gunshin Holding UG', 'page', 6, NULL);
|
|
INSERT INTO public.navigation_main_menu_submenu (_order, _parent_id, id, label, link_type, page_id, url) VALUES (2, '69284809b6871dae2fda6e7f', '69284809b6871dae2fda6e7e', 'complex care solutions GmbH', 'page', 7, NULL);
|
|
|
|
|
|
--
|
|
-- Data for Name: payload_migrations; Type: TABLE DATA; Schema: public; Owner: payload
|
|
--
|
|
|
|
INSERT INTO public.payload_migrations (id, name, batch, updated_at, created_at) VALUES (1, '20251126_163428', 1, '2025-11-26 16:34:42.547+00', '2025-11-26 16:34:42.546+00');
|
|
INSERT INTO public.payload_migrations (id, name, batch, updated_at, created_at) VALUES (2, '20251126_200521', 2, '2025-11-26 20:05:36.195+00', '2025-11-26 20:05:36.194+00');
|
|
INSERT INTO public.payload_migrations (id, name, batch, updated_at, created_at) VALUES (3, '20251127_081206', 3, '2025-11-27 08:12:14.944+00', '2025-11-27 08:12:14.943+00');
|
|
INSERT INTO public.payload_migrations (id, name, batch, updated_at, created_at) VALUES (4, '20251127_085124', 4, '2025-11-27 08:51:33.23+00', '2025-11-27 08:51:33.229+00');
|
|
INSERT INTO public.payload_migrations (id, name, batch, updated_at, created_at) VALUES (6, '20251127_224713', 5, '2025-11-27 22:49:33.705+00', '2025-11-27 22:49:33.704+00');
|
|
INSERT INTO public.payload_migrations (id, name, batch, updated_at, created_at) VALUES (7, '20251128_142608', 6, '2025-11-28 14:28:27.621+00', '2025-11-28 14:28:27.62+00');
|
|
INSERT INTO public.payload_migrations (id, name, batch, updated_at, created_at) VALUES (5, 'dev', -1, '2025-11-28 14:36:30.472+00', '2025-11-27 12:44:07.275+00');
|
|
|
|
|
|
--
|
|
-- Data for Name: privacy_policy_settings; Type: TABLE DATA; Schema: public; Owner: payload
|
|
--
|
|
|
|
|
|
|
|
--
|
|
-- Data for Name: site_settings; Type: TABLE DATA; Schema: public; Owner: payload
|
|
--
|
|
|
|
INSERT INTO public.site_settings (id, site_name, site_tagline, logo_id, favicon_id, contact_email, contact_phone, contact_address, footer_copyright_text, footer_show_social_links, seo_default_meta_title, seo_default_meta_description, seo_default_og_image_id, updated_at, created_at) VALUES (1, 'porwoll.de', 'Die Webseite von Martin Porwoll', NULL, 1, 'info@porwoll.de', '0800 80 44 100', 'Hans-Böckler-Str. 19
|
|
46236 Bottrop', 'Martin Porwoll', true, 'porwoll.de | Die Webseite von Martin Porwoll', 'Martin Porwoll - Whistleblower, Unternehmer, Mensch. Engagiert für Patientenwohl und Transparenz im Gesundheitswesen.', NULL, '2025-11-27 12:44:07.394+00', '2025-11-27 09:56:52.613+00');
|
|
|
|
|
|
--
|
|
-- Data for Name: social_links; Type: TABLE DATA; Schema: public; Owner: payload
|
|
--
|
|
|
|
INSERT INTO public.social_links (id, tenant_id, platform, url, is_active, updated_at, created_at) VALUES (1, 1, 'facebook', 'https://www.facebook.com/martinporwoll', true, '2025-11-27 09:59:41.9+00', '2025-11-27 09:59:41.9+00');
|
|
INSERT INTO public.social_links (id, tenant_id, platform, url, is_active, updated_at, created_at) VALUES (2, 1, 'instagram', 'https://www.instagram.com/martinporwoll', true, '2025-11-27 10:00:16.947+00', '2025-11-27 10:00:16.947+00');
|
|
INSERT INTO public.social_links (id, tenant_id, platform, url, is_active, updated_at, created_at) VALUES (3, 1, 'youtube', 'https://www.youtube.com/@martinporwoll', true, '2025-11-27 10:00:29.623+00', '2025-11-27 10:00:29.623+00');
|
|
INSERT INTO public.social_links (id, tenant_id, platform, url, is_active, updated_at, created_at) VALUES (4, 1, 'linkedin', 'https://www.linkedin.com/in/martinporwoll', true, '2025-11-27 10:00:41.713+00', '2025-11-27 10:00:41.713+00');
|
|
INSERT INTO public.social_links (id, tenant_id, platform, url, is_active, updated_at, created_at) VALUES (5, 1, 'x', 'https://x.com/martinporwoll', true, '2025-11-27 12:44:07.422+00', '2025-11-27 12:44:07.422+00');
|
|
|
|
|
|
--
|
|
-- Data for Name: tenants_domains; Type: TABLE DATA; Schema: public; Owner: payload
|
|
--
|
|
|
|
INSERT INTO public.tenants_domains (_order, _parent_id, id, domain) VALUES (1, 1, '692763ff981e6105458e2df7', 'porwoll.de');
|
|
INSERT INTO public.tenants_domains (_order, _parent_id, id, domain) VALUES (2, 1, '69276406981e6105458e2df8', 'www.porwoll.de');
|
|
INSERT INTO public.tenants_domains (_order, _parent_id, id, domain) VALUES (1, 5, '6927676fd263874f0453e3e6', 'gunshin.de');
|
|
INSERT INTO public.tenants_domains (_order, _parent_id, id, domain) VALUES (2, 5, '69276776d263874f0453e3e7', 'www.gunshin.de');
|
|
INSERT INTO public.tenants_domains (_order, _parent_id, id, domain) VALUES (1, 4, '69276697de1f95ad5e22dfb1', 'complexcaresolutions.de');
|
|
INSERT INTO public.tenants_domains (_order, _parent_id, id, domain) VALUES (2, 4, '692766a1de1f95ad5e22dfb2', 'www.complexcaresolutions.de');
|
|
INSERT INTO public.tenants_domains (_order, _parent_id, id, domain) VALUES (1, 6, '69277ac36e43b25d0271266f', 'zweitmeinu.ng');
|
|
INSERT INTO public.tenants_domains (_order, _parent_id, id, domain) VALUES (2, 6, '69277ad26e43b25d02712670', 'www.zweitmeinu.ng');
|
|
|
|
|
|
--
|
|
-- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: payload
|
|
--
|
|
|
|
INSERT INTO public.users (id, updated_at, created_at, email, reset_password_token, reset_password_expiration, salt, hash, login_attempts, lock_until) VALUES (1, '2025-11-26 16:40:22.979+00', '2025-11-26 16:40:22.978+00', 'martin.porwoll@complexcaresolutions.de', NULL, NULL, '44198dfdd90fadbff9a9e16caa36b43b051199ad213c7569ec15ec5ede60fbe4', '8acc6fb009b517a1427ff1e0f279dec5beabd349f18a61498244c9f74c2d240ebfb297abfa0296fa0c2962123c61eb47e0aaee3d1dc454f24c73c4e4b50a4f335e997e14848ee00f6c32a88d5e413dca1be5159dfad07b3b4f7579031ac814df274eda55fc037ffe659dee591f9f0c3a50a37e7eba69d6e20618094a46df3ac2b8c94701fab5834f5483f63af1390b7c54c6b6757edbc7e253e838f9c7e5e32415e7d38e5048f8b023894d027acfd1b8fddbc849ebf397336b029c00c11e69cc3dcba29888b083a25bdab24716a5132198ea97359e2c7054efa2f342814365e2dcbaf84c46a6bfc7e56557d16c38417f97ff14ea4e64037c5a5e4898aec64ea427f61a072ea34ed24ba863049a2b9918d330b0574c9294c269132e91841177c109c0bdc8e25d7d59d769af398c84b08e2c3c31c6cb3f8b108b7d70c94b62cf021f389dafc321e2167bb5553249fd64e3e980874fff9de9f6c2753090054edd515d1c39106fb7c27ceba255f37aab44f00ec1db22425d2fe84f1728358266b7ef19454bc021cf9f7c09b105debecc57c1c4b2a9e90fd4ced6320e2e9886252d5e00ef99ca158a79dd28b4edcb59c72b5d2475d91e5985be8d8277e541ba17a4524890c8544e75d1f30cbb5f4f87c2204b68862d9a98cad93f134c82b42d03bb9c5fb952c7d579fa2fe3c5a009bd7cbfc84f834ccf9b8e91e4afe7af4691d01e8b', 0, NULL);
|
|
|
|
|
|
--
|
|
-- Data for Name: users_sessions; Type: TABLE DATA; Schema: public; Owner: payload
|
|
--
|
|
|
|
INSERT INTO public.users_sessions (_order, _parent_id, id, created_at, expires_at) VALUES (1, 1, '21fc0ad0-a771-4714-b5bb-3f341462d4b7', '2025-11-29 13:33:39.705+00', '2025-11-29 15:33:39.705+00');
|
|
|
|
|
|
--
|
|
-- Data for Name: users_tenants; Type: TABLE DATA; Schema: public; Owner: payload
|
|
--
|
|
|
|
INSERT INTO public.users_tenants (_order, _parent_id, id, tenant_id) VALUES (1, 1, '1', 1);
|
|
INSERT INTO public.users_tenants (_order, _parent_id, id, tenant_id) VALUES (2, 1, '2', 4);
|
|
INSERT INTO public.users_tenants (_order, _parent_id, id, tenant_id) VALUES (3, 1, '3', 5);
|
|
INSERT INTO public.users_tenants (_order, _parent_id, id, tenant_id) VALUES (4, 1, '4', 6);
|
|
|
|
|
|
--
|
|
-- Name: categories_id_seq; Type: SEQUENCE SET; Schema: public; Owner: payload
|
|
--
|
|
|
|
SELECT pg_catalog.setval('public.categories_id_seq', 2, true);
|
|
|
|
|
|
--
|
|
-- Name: cookie_configurations_enabled_categories_id_seq; Type: SEQUENCE SET; Schema: public; Owner: payload
|
|
--
|
|
|
|
SELECT pg_catalog.setval('public.cookie_configurations_enabled_categories_id_seq', 1, false);
|
|
|
|
|
|
--
|
|
-- Name: cookie_configurations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: payload
|
|
--
|
|
|
|
SELECT pg_catalog.setval('public.cookie_configurations_id_seq', 1, false);
|
|
|
|
|
|
--
|
|
-- Name: cookie_inventory_id_seq; Type: SEQUENCE SET; Schema: public; Owner: payload
|
|
--
|
|
|
|
SELECT pg_catalog.setval('public.cookie_inventory_id_seq', 1, false);
|
|
|
|
|
|
--
|
|
-- Name: media_id_seq; Type: SEQUENCE SET; Schema: public; Owner: payload
|
|
--
|
|
|
|
SELECT pg_catalog.setval('public.media_id_seq', 7, true);
|
|
|
|
|
|
--
|
|
-- Name: navigation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: payload
|
|
--
|
|
|
|
SELECT pg_catalog.setval('public.navigation_id_seq', 1, true);
|
|
|
|
|
|
--
|
|
-- Name: payload_migrations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: payload
|
|
--
|
|
|
|
SELECT pg_catalog.setval('public.payload_migrations_id_seq', 7, true);
|
|
|
|
|
|
--
|
|
-- Name: privacy_policy_settings_id_seq; Type: SEQUENCE SET; Schema: public; Owner: payload
|
|
--
|
|
|
|
SELECT pg_catalog.setval('public.privacy_policy_settings_id_seq', 1, false);
|
|
|
|
|
|
--
|
|
-- Name: site_settings_id_seq; Type: SEQUENCE SET; Schema: public; Owner: payload
|
|
--
|
|
|
|
SELECT pg_catalog.setval('public.site_settings_id_seq', 1, true);
|
|
|
|
|
|
--
|
|
-- Name: social_links_id_seq; Type: SEQUENCE SET; Schema: public; Owner: payload
|
|
--
|
|
|
|
SELECT pg_catalog.setval('public.social_links_id_seq', 5, true);
|
|
|
|
|
|
--
|
|
-- Name: tenants_id_seq; Type: SEQUENCE SET; Schema: public; Owner: payload
|
|
--
|
|
|
|
SELECT pg_catalog.setval('public.tenants_id_seq', 6, true);
|
|
|
|
|
|
--
|
|
-- Name: users_id_seq; Type: SEQUENCE SET; Schema: public; Owner: payload
|
|
--
|
|
|
|
SELECT pg_catalog.setval('public.users_id_seq', 1, true);
|
|
|
|
|
|
--
|
|
-- PostgreSQL database dump complete
|
|
--
|
|
|
|
|