From c35ff0c6e06c1ada4b55d1b97eea8b73c6295278 Mon Sep 17 00:00:00 2001 From: "Ole B. Rosentreter" Date: Fri, 5 Jun 2026 23:10:36 +0200 Subject: [PATCH] new articles --- db/articles/001_index.sql | 2 +- db/articles/002_kontakt.sql | 2 +- db/articles/003_blog.sql | 2 +- db/articles/003_impressum.sql | 2 +- db/articles/004_datenschutz.sql | 2 +- db/articles/005_agb.sql | 2 +- db/articles/080_tools.sql | 2 +- db/articles/081_swim.sql | 2 +- db/articles/082_roadtokona.sql | 2 +- db/articles/100_blog_warum-einen-coach.sql | 2 +- db/articles/101_blog_gesundheit.sql | 2 +- db/articles/102_blog_mittwochs-faengt-die-woche-an.sql | 2 +- db/articles/103_blog_mein-coaching-ansatz.sql | 2 +- db/articles/104_blog_grenzen-wofur-ich-nicht-da-bin.sql | 2 +- db/articles/105_blog_ziele-setzen-aber-richtig.sql | 2 +- db/articles/106_blog_wenn-du-krank-bist.sql | 2 +- .../107_blog_was-nicht-auf-strava-ist-ist-nicht-passiert.sql | 2 +- db/articles/108_blog_laufschuhe-kann-man-zu-viele-haben.sql | 2 +- ...g_bahn-knigge-die-ungeschriebenen-gesetze-auf-der-bahn.sql | 2 +- db/articles/110_blog_warm-up-vor-einem-laufwettkampf.sql | 2 +- db/articles/111_blog_saisonplanung-wie-geht-man-vor.sql | 2 +- db/articles/112_blog_fairplay-beim-coaching.sql | 2 +- db/articles/113_blog_was-kostet-personal-coaching.sql | 2 +- db/articles/114_blog_dein-trainingsplan.sql | 2 +- db/articles/115_blog_welche-rolle-hast-du.sql | 2 +- db/articles/116_blog_wie-legen-wir-los-wie-lauft-das-ab.sql | 2 +- .../117_blog_wie-funktioniert-individuelles-coaching.sql | 2 +- .../118_blog_wie-ich-mit-athleten-und-athletinnen-arbeite.sql | 2 +- db/articles/119_blog_about_me.sql | 2 +- db/articles/120_blog_raceday-und-bloss-nichts-vergessen.sql | 2 +- ...chmale-grat-zwischen-verballern-und-doch-nur-95prozent.sql | 2 +- db/articles/122_blog_athletiktraining.sql | 2 +- .../123_blog_kraft-vs-kraftausdauer-vs-k3-vs-dicker-gang.sql | 2 +- .../124_blog_fettstoffwechsel_fettverbrennung_fatmax.sql | 2 +- db/articles/125_blog_bikefitting.sql | 2 +- .../126_blog_aero-gadgets_spielzeug-oder-gamechanger.sql | 2 +- ...g_carboloading-muskelglykogen-leberglykogen-blutzucker.sql | 2 +- db/articles/128_blog_gibt-es-alternativen-zu-teuren-gels.sql | 2 +- db/articles/700_camps.sql | 2 +- db/articles/701_camps_2026_cesenatico.sql | 4 ++-- db/articles/702_seminar_202405_radtechnik.sql | 4 ++-- db/articles/703_seminar_202609_laufseminar.sql | 4 ++-- db/articles/900_coaching.sql | 2 +- db/articles/901_personal-coaching.sql | 2 +- db/articles/910_athleten.sql | 2 +- db/articles/950_standard-plaene.sql | 2 +- db/articles/960_langdistanz.sql | 2 +- db/articles/970_mitteldistanz.sql | 2 +- db/articles/980_kurzdistanz.sql | 2 +- 49 files changed, 52 insertions(+), 52 deletions(-) diff --git a/db/articles/001_index.sql b/db/articles/001_index.sql index d716247..08e766f 100644 --- a/db/articles/001_index.sql +++ b/db/articles/001_index.sql @@ -41,7 +41,7 @@ NULL, -- card_media_id, NULL, NULL, -- meta_title, meta_desc NULL, -- canonical_url 'published', -- status -NULL, NULL, '2024-10-01', '2024-10-01'); +'2024-10-01', NULL, '2024-10-01', '2024-10-01'); -- ============================================================ diff --git a/db/articles/002_kontakt.sql b/db/articles/002_kontakt.sql index 5f07080..0be1149 100644 --- a/db/articles/002_kontakt.sql +++ b/db/articles/002_kontakt.sql @@ -20,4 +20,4 @@ NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, 'published', -NULL, NULL, '2024-10-01', '2024-10-01'); +'2024-10-01', NULL, '2024-10-01', '2024-10-01'); diff --git a/db/articles/003_blog.sql b/db/articles/003_blog.sql index cab9f11..13589bf 100644 --- a/db/articles/003_blog.sql +++ b/db/articles/003_blog.sql @@ -20,4 +20,4 @@ INSERT INTO :"schema".page_content VALUES (DEFAULT, (SELECT id FROM :"sche '', NULL, NULL, NULL, NULL, NULL, NULL, 'published', -NULL, NULL, '2024-10-01', '2024-10-01'); +'2024-10-01', NULL, '2024-10-01', '2024-10-01'); diff --git a/db/articles/003_impressum.sql b/db/articles/003_impressum.sql index 8bdee3c..4223981 100644 --- a/db/articles/003_impressum.sql +++ b/db/articles/003_impressum.sql @@ -20,4 +20,4 @@ Quelle: [http://www.e-recht24.de](http://www.e-recht24.de/impressum-generator.ht '', NULL, NULL, NULL, NULL, NULL, NULL, 'published', -NULL, NULL, '2024-10-01', '2024-10-01'); +'2024-10-01', NULL, '2024-10-01', '2024-10-01'); diff --git a/db/articles/004_datenschutz.sql b/db/articles/004_datenschutz.sql index b2f5908..b8841a8 100644 --- a/db/articles/004_datenschutz.sql +++ b/db/articles/004_datenschutz.sql @@ -142,4 +142,4 @@ Die Datenschutzerklärung wurde mit dem [Datenschutzerklärungs-Generator der ac '', NULL, NULL, NULL, NULL, NULL, NULL, 'published', -NULL, NULL, '2024-10-01', '2024-10-01'); +'2024-10-01', NULL, '2024-10-01', '2024-10-01'); diff --git a/db/articles/005_agb.sql b/db/articles/005_agb.sql index ceaf49d..f6daec0 100644 --- a/db/articles/005_agb.sql +++ b/db/articles/005_agb.sql @@ -96,4 +96,4 @@ NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, 'published', -NULL, NULL, '2024-10-01', '2024-10-01'); +'2024-10-01', NULL, '2024-10-01', '2024-10-01'); diff --git a/db/articles/080_tools.sql b/db/articles/080_tools.sql index e04d1c7..87ae4d3 100644 --- a/db/articles/080_tools.sql +++ b/db/articles/080_tools.sql @@ -20,5 +20,5 @@ INSERT INTO :"schema".page_content VALUES (DEFAULT, (SELECT id FROM :"sche '', NULL, NULL, NULL, NULL, NULL, NULL, 'published', -NULL, NULL, '2024-10-01', '2024-10-01'); +'2024-10-01', NULL, '2024-10-01', '2024-10-01'); diff --git a/db/articles/081_swim.sql b/db/articles/081_swim.sql index 6740927..fe8dcf7 100644 --- a/db/articles/081_swim.sql +++ b/db/articles/081_swim.sql @@ -22,5 +22,5 @@ INSERT INTO :"schema".page_content VALUES (DEFAULT, (SELECT id FROM :"schema".pa '', NULL, NULL, NULL, NULL, NULL, 'swim.triathlon-coaching.com', 'published', -NULL, NULL, '2024-10-01', '2024-10-01'); +'2024-10-01', NULL, '2024-10-01', '2024-10-01'); diff --git a/db/articles/082_roadtokona.sql b/db/articles/082_roadtokona.sql index c15fc1f..8318a0a 100644 --- a/db/articles/082_roadtokona.sql +++ b/db/articles/082_roadtokona.sql @@ -22,4 +22,4 @@ INSERT INTO :"schema".page_content VALUES (DEFAULT, (SELECT id FROM :"schema".pa '', NULL, NULL, NULL, NULL, NULL, 'roadtokona.triathlon-coaching.com', 'published', -NULL, NULL, '2024-10-01', '2024-10-01'); +'2024-10-01', NULL, '2024-10-01', '2024-10-01'); diff --git a/db/articles/100_blog_warum-einen-coach.sql b/db/articles/100_blog_warum-einen-coach.sql index 54cf393..12559a0 100644 --- a/db/articles/100_blog_warum-einen-coach.sql +++ b/db/articles/100_blog_warum-einen-coach.sql @@ -77,7 +77,7 @@ Er hat das Coaches-Eye - das hat selbst eine KI nicht.', '', NULL, NULL, NULL, NULL, NULL, NULL, 'published', -NULL, NULL, '2024-10-01', '2024-10-01'); +'2024-10-01', NULL, '2024-10-01', '2024-10-01'); INSERT INTO :"schema".content_pages VALUES ((SELECT id FROM :"schema".pages WHERE slug='blog/warum-einen-coach'), (SELECT id FROM :"schema".categories WHERE slug='coaching')); diff --git a/db/articles/101_blog_gesundheit.sql b/db/articles/101_blog_gesundheit.sql index 3bb2f70..7d26a3a 100644 --- a/db/articles/101_blog_gesundheit.sql +++ b/db/articles/101_blog_gesundheit.sql @@ -21,7 +21,7 @@ Und [während des Trainings](https://www.triathlon-coaching.com/blog/wenn-du-kra '', NULL, NULL, NULL, NULL, NULL, NULL, 'published', -NULL, NULL, '2024-10-01', '2024-10-01'); +'2024-10-01', NULL, '2024-10-01', '2024-10-01'); INSERT INTO :"schema".content_pages VALUES ((SELECT id FROM :"schema".pages WHERE slug='blog/gesundheit'), (SELECT id FROM :"schema".categories WHERE slug='coaching')); diff --git a/db/articles/102_blog_mittwochs-faengt-die-woche-an.sql b/db/articles/102_blog_mittwochs-faengt-die-woche-an.sql index 400a342..52d2881 100644 --- a/db/articles/102_blog_mittwochs-faengt-die-woche-an.sql +++ b/db/articles/102_blog_mittwochs-faengt-die-woche-an.sql @@ -22,7 +22,7 @@ Und deshalb hat es sich als praktisch und sinnvoll erwiesen immer von Mittwoch b '', NULL, NULL, NULL, NULL, NULL, NULL, 'published', -NULL, NULL, '2024-10-01', '2024-10-01'); +'2024-10-01', NULL, '2024-10-01', '2024-10-01'); INSERT INTO :"schema".content_pages VALUES ((SELECT id FROM :"schema".pages WHERE slug='blog/mittwochs-faengt-die-woche-an'), (SELECT id FROM :"schema".categories WHERE slug='coaching')); diff --git a/db/articles/103_blog_mein-coaching-ansatz.sql b/db/articles/103_blog_mein-coaching-ansatz.sql index d76f428..86ab26a 100644 --- a/db/articles/103_blog_mein-coaching-ansatz.sql +++ b/db/articles/103_blog_mein-coaching-ansatz.sql @@ -31,7 +31,7 @@ Oder man hat jemand, der sich damit auskennt und man kann sich auf das Wesentlic '', NULL, NULL, NULL, NULL, NULL, NULL, 'published', -NULL, NULL, '2024-10-01', '2024-10-01'); +'2024-10-01', NULL, '2024-10-01', '2024-10-01'); INSERT INTO :"schema".content_pages VALUES ((SELECT id FROM :"schema".pages WHERE slug='blog/mein-coaching-ansatz'), (SELECT id FROM :"schema".categories WHERE slug='coaching')); diff --git a/db/articles/104_blog_grenzen-wofur-ich-nicht-da-bin.sql b/db/articles/104_blog_grenzen-wofur-ich-nicht-da-bin.sql index bda9c74..835a076 100644 --- a/db/articles/104_blog_grenzen-wofur-ich-nicht-da-bin.sql +++ b/db/articles/104_blog_grenzen-wofur-ich-nicht-da-bin.sql @@ -38,7 +38,7 @@ Allerdings: **DU** musst wollen. '', NULL, NULL, NULL, NULL, NULL, NULL, 'published', -NULL, NULL, '2024-10-01', '2024-10-01'); +'2024-10-01', NULL, '2024-10-01', '2024-10-01'); INSERT INTO :"schema".content_pages VALUES ((SELECT id FROM :"schema".pages WHERE slug='blog/grenzen-wofur-ich-nicht-da-bin'), (SELECT id FROM :"schema".categories WHERE slug='coaching')); diff --git a/db/articles/105_blog_ziele-setzen-aber-richtig.sql b/db/articles/105_blog_ziele-setzen-aber-richtig.sql index d350827..28790ab 100644 --- a/db/articles/105_blog_ziele-setzen-aber-richtig.sql +++ b/db/articles/105_blog_ziele-setzen-aber-richtig.sql @@ -71,7 +71,7 @@ Auch für die Motivation ist es förderlich und eigentlich unabdingbar, sich von '', NULL, NULL, NULL, NULL, NULL, NULL, 'published', -NULL, NULL, '2024-10-01', '2025-09-27'); +'2025-09-27', NULL, '2024-10-01', '2025-09-27'); INSERT INTO :"schema".content_pages VALUES ((SELECT id FROM :"schema".pages WHERE slug='blog/ziele-setzen-aber-richtig'), (SELECT id FROM :"schema".categories WHERE slug='blog')); diff --git a/db/articles/106_blog_wenn-du-krank-bist.sql b/db/articles/106_blog_wenn-du-krank-bist.sql index 99d3303..c455473 100644 --- a/db/articles/106_blog_wenn-du-krank-bist.sql +++ b/db/articles/106_blog_wenn-du-krank-bist.sql @@ -29,7 +29,7 @@ Ich möchte nicht, dass Du den Gedanken entwickelst, durch das Gefühl „für n '', NULL, NULL, NULL, NULL, NULL, NULL, 'published', -NULL, NULL, '2024-10-01', '2024-10-01'); +'2024-10-01', NULL, '2024-10-01', '2024-10-01'); INSERT INTO :"schema".content_pages VALUES ((SELECT id FROM :"schema".pages WHERE slug='blog/wenn-du-krank-bist'), (SELECT id FROM :"schema".categories WHERE slug='angebot')); diff --git a/db/articles/107_blog_was-nicht-auf-strava-ist-ist-nicht-passiert.sql b/db/articles/107_blog_was-nicht-auf-strava-ist-ist-nicht-passiert.sql index 51080bc..1b10167 100644 --- a/db/articles/107_blog_was-nicht-auf-strava-ist-ist-nicht-passiert.sql +++ b/db/articles/107_blog_was-nicht-auf-strava-ist-ist-nicht-passiert.sql @@ -29,7 +29,7 @@ Voller Fokus auf die Trainingseinheit statt Posing und Siege statt Segmente ;-) '', NULL, NULL, NULL, NULL, NULL, NULL, 'published', -NULL, NULL, '2024-10-01', '2024-12-17'); +'2024-12-17', NULL, '2024-10-01', '2024-12-17'); INSERT INTO :"schema".content_pages VALUES ((SELECT id FROM :"schema".pages WHERE slug='blog/was-nicht-auf-strava-ist-ist-nicht-passiert'), (SELECT id FROM :"schema".categories WHERE slug='blog')); diff --git a/db/articles/108_blog_laufschuhe-kann-man-zu-viele-haben.sql b/db/articles/108_blog_laufschuhe-kann-man-zu-viele-haben.sql index ac3f6b6..af8bacd 100644 --- a/db/articles/108_blog_laufschuhe-kann-man-zu-viele-haben.sql +++ b/db/articles/108_blog_laufschuhe-kann-man-zu-viele-haben.sql @@ -74,7 +74,7 @@ Guckt der Versender zu, wenn Du den Schuh auf dem Laufband testet? '', NULL, NULL, NULL, NULL, NULL, NULL, 'published', -NULL, NULL, '2024-10-01', '2025-08-01'); +'2025-08-01', NULL, '2024-10-01', '2025-08-01'); INSERT INTO :"schema".content_pages VALUES ((SELECT id FROM :"schema".pages WHERE slug='blog/laufschuhe-kann-man-zu-viele-haben'), (SELECT id FROM :"schema".categories WHERE slug='blog')); diff --git a/db/articles/109_blog_bahn-knigge-die-ungeschriebenen-gesetze-auf-der-bahn.sql b/db/articles/109_blog_bahn-knigge-die-ungeschriebenen-gesetze-auf-der-bahn.sql index fc967df..1819a34 100644 --- a/db/articles/109_blog_bahn-knigge-die-ungeschriebenen-gesetze-auf-der-bahn.sql +++ b/db/articles/109_blog_bahn-knigge-die-ungeschriebenen-gesetze-auf-der-bahn.sql @@ -68,7 +68,7 @@ Das ist Triathleten in etwa so fremd, wie einem Beckenschwimmer, der beim Triath '', NULL, NULL, NULL, NULL, NULL, NULL, 'published', -NULL, NULL, '2024-10-01', '2025-06-07'); +'2025-06-07', NULL, '2024-10-01', '2025-06-07'); INSERT INTO :"schema".content_pages VALUES ((SELECT id FROM :"schema".pages WHERE slug='blog/bahn-knigge-die-ungeschriebenen-gesetze-auf-der-bahn'), (SELECT id FROM :"schema".categories WHERE slug='blog')); diff --git a/db/articles/110_blog_warm-up-vor-einem-laufwettkampf.sql b/db/articles/110_blog_warm-up-vor-einem-laufwettkampf.sql index d7faa92..6f2397b 100644 --- a/db/articles/110_blog_warm-up-vor-einem-laufwettkampf.sql +++ b/db/articles/110_blog_warm-up-vor-einem-laufwettkampf.sql @@ -52,7 +52,7 @@ Oder wenn es zu ungemütlich ist, zu Hause 30min locker auf der Rolle ausfahren '', NULL, NULL, NULL, NULL, NULL, NULL, 'published', -NULL, NULL, '2024-10-01', '2025-02-05'); +'2025-02-05', NULL, '2024-10-01', '2025-02-05'); INSERT INTO :"schema".content_pages VALUES ((SELECT id FROM :"schema".pages WHERE slug='blog/warm-up-vor-einem-laufwettkampf'), (SELECT id FROM :"schema".categories WHERE slug='blog')); diff --git a/db/articles/111_blog_saisonplanung-wie-geht-man-vor.sql b/db/articles/111_blog_saisonplanung-wie-geht-man-vor.sql index 8b30d15..c9fc3b1 100644 --- a/db/articles/111_blog_saisonplanung-wie-geht-man-vor.sql +++ b/db/articles/111_blog_saisonplanung-wie-geht-man-vor.sql @@ -41,7 +41,7 @@ Saisonplanung ist vor allem auch eine ehrliche Auseinandersetzung mit sich selbs '', NULL, NULL, NULL, NULL, NULL, NULL, 'published', -NULL, NULL, '2024-10-01', '2025-10-11'); +'2025-10-11', NULL, '2024-10-01', '2025-10-11'); INSERT INTO :"schema".content_pages VALUES ((SELECT id FROM :"schema".pages WHERE slug='blog/saisonplanung-wie-geht-man-vor'), (SELECT id FROM :"schema".categories WHERE slug='blog')); diff --git a/db/articles/112_blog_fairplay-beim-coaching.sql b/db/articles/112_blog_fairplay-beim-coaching.sql index e21ed30..7d00e09 100644 --- a/db/articles/112_blog_fairplay-beim-coaching.sql +++ b/db/articles/112_blog_fairplay-beim-coaching.sql @@ -33,7 +33,7 @@ Ach so, wenn es Dir bei mir gefällt und Du wirbst jemanden, der wenigstens 3 Mo '', NULL, NULL, NULL, NULL, NULL, NULL, 'published', -NULL, NULL, '2024-10-01', '2024-10-01'); +'2024-10-01', NULL, '2024-10-01', '2024-10-01'); INSERT INTO :"schema".content_pages VALUES ((SELECT id FROM :"schema".pages WHERE slug='blog/fairplay-beim-coaching'), (SELECT id FROM :"schema".categories WHERE slug='angebot')); diff --git a/db/articles/113_blog_was-kostet-personal-coaching.sql b/db/articles/113_blog_was-kostet-personal-coaching.sql index 499c48c..5979bdf 100644 --- a/db/articles/113_blog_was-kostet-personal-coaching.sql +++ b/db/articles/113_blog_was-kostet-personal-coaching.sql @@ -30,7 +30,7 @@ Coaching in einer Einzelsportart sind 10 Euro weniger, also **30 Euro / Woche in '', NULL, NULL, NULL, NULL, NULL, NULL, 'published', -NULL, NULL, '2024-10-01', '2024-10-01'); +'2024-10-01', NULL, '2024-10-01', '2024-10-01'); INSERT INTO :"schema".content_pages VALUES ((SELECT id FROM :"schema".pages WHERE slug='blog/was-kostet-personal-coaching'), (SELECT id FROM :"schema".categories WHERE slug='angebot')); diff --git a/db/articles/114_blog_dein-trainingsplan.sql b/db/articles/114_blog_dein-trainingsplan.sql index eaeb730..be20eba 100644 --- a/db/articles/114_blog_dein-trainingsplan.sql +++ b/db/articles/114_blog_dein-trainingsplan.sql @@ -28,7 +28,7 @@ Das ist selbst bei Profis, die das ganze Jahr überall auf der Welt ihre Zelte a '', NULL, NULL, NULL, NULL, NULL, NULL, 'published', -NULL, NULL, '2024-10-01', '2024-10-01'); +'2024-10-01', NULL, '2024-10-01', '2024-10-01'); INSERT INTO :"schema".content_pages VALUES ((SELECT id FROM :"schema".pages WHERE slug='blog/dein-trainingsplan'), (SELECT id FROM :"schema".categories WHERE slug='angebot')); diff --git a/db/articles/115_blog_welche-rolle-hast-du.sql b/db/articles/115_blog_welche-rolle-hast-du.sql index 8935547..c47e333 100644 --- a/db/articles/115_blog_welche-rolle-hast-du.sql +++ b/db/articles/115_blog_welche-rolle-hast-du.sql @@ -51,7 +51,7 @@ Je höher Dein Ziel ist, je mehr mehr wirst Du einbringen müssen ...', '', NULL, NULL, NULL, NULL, NULL, NULL, 'published', -NULL, NULL, '2024-10-01', '2024-10-01'); +'2024-10-01', NULL, '2024-10-01', '2024-10-01'); INSERT INTO :"schema".content_pages VALUES ((SELECT id FROM :"schema".pages WHERE slug='blog/welche-rolle-ahleten-haben'), (SELECT id FROM :"schema".categories WHERE slug='coaching')); diff --git a/db/articles/116_blog_wie-legen-wir-los-wie-lauft-das-ab.sql b/db/articles/116_blog_wie-legen-wir-los-wie-lauft-das-ab.sql index 2d2fe86..8c653ed 100644 --- a/db/articles/116_blog_wie-legen-wir-los-wie-lauft-das-ab.sql +++ b/db/articles/116_blog_wie-legen-wir-los-wie-lauft-das-ab.sql @@ -45,7 +45,7 @@ Ach ja: Wer dopt, fliegt raus. Achtkantig.', '', NULL, NULL, NULL, NULL, NULL, NULL, 'published', -NULL, NULL, '2024-10-01', '2024-10-01'); +'2024-10-01', NULL, '2024-10-01', '2024-10-01'); INSERT INTO :"schema".content_pages VALUES ((SELECT id FROM :"schema".pages WHERE slug='blog/wie-legen-wir-mit-dem-training-los'), (SELECT id FROM :"schema".categories WHERE slug='angebot')); diff --git a/db/articles/117_blog_wie-funktioniert-individuelles-coaching.sql b/db/articles/117_blog_wie-funktioniert-individuelles-coaching.sql index d14d072..75375ba 100644 --- a/db/articles/117_blog_wie-funktioniert-individuelles-coaching.sql +++ b/db/articles/117_blog_wie-funktioniert-individuelles-coaching.sql @@ -31,7 +31,7 @@ Auch wenn die moderne Technik eine tolle Unterstützung darstellt – das persö '', NULL, NULL, NULL, NULL, NULL, NULL, 'published', -NULL, NULL, '2024-10-01', '2024-10-01'); +'2024-10-01', NULL, '2024-10-01', '2024-10-01'); INSERT INTO :"schema".content_pages VALUES ((SELECT id FROM :"schema".pages WHERE slug='blog/wie-funktioniert-individuelles-coaching'), (SELECT id FROM :"schema".categories WHERE slug='coaching')); diff --git a/db/articles/118_blog_wie-ich-mit-athleten-und-athletinnen-arbeite.sql b/db/articles/118_blog_wie-ich-mit-athleten-und-athletinnen-arbeite.sql index 2387b36..bdd9af9 100644 --- a/db/articles/118_blog_wie-ich-mit-athleten-und-athletinnen-arbeite.sql +++ b/db/articles/118_blog_wie-ich-mit-athleten-und-athletinnen-arbeite.sql @@ -36,7 +36,7 @@ Als Coach finde ich die Zahlen äußerst hilfreich, um zu erkennen, wie gut der '', NULL, NULL, NULL, NULL, NULL, NULL, 'published', -NULL, NULL, '2024-10-01', '2024-10-01'); +'2024-10-01', NULL, '2024-10-01', '2024-10-01'); INSERT INTO :"schema".content_pages VALUES ((SELECT id FROM :"schema".pages WHERE slug='blog/wie-ich-mit-athleten-und-athletinnen-arbeite'), (SELECT id FROM :"schema".categories WHERE slug='coaching')); diff --git a/db/articles/119_blog_about_me.sql b/db/articles/119_blog_about_me.sql index d37b255..ec8256d 100644 --- a/db/articles/119_blog_about_me.sql +++ b/db/articles/119_blog_about_me.sql @@ -91,7 +91,7 @@ Ironman Europe in Roth – seitdem darf ich mich Ironman nennen. NRW-Liga, Lakta Lizensierter Trainer des Deutschen Triathlon Union – die offizielle Bestätigung eines langen Wegs aus Erfahrung, Leidenschaft und Sportwissenschaft.', NULL, NULL, NULL, NULL, NULL, NULL, 'published', -NULL, NULL, '2024-10-01', '2024-10-01'); +'2024-10-01', NULL, '2024-10-01', '2024-10-01'); INSERT INTO :"schema".content_pages VALUES ((SELECT id FROM :"schema".pages WHERE slug='blog/about-me'), (SELECT id FROM :"schema".categories WHERE slug='blog')); diff --git a/db/articles/120_blog_raceday-und-bloss-nichts-vergessen.sql b/db/articles/120_blog_raceday-und-bloss-nichts-vergessen.sql index 1ef89fd..1970b2b 100644 --- a/db/articles/120_blog_raceday-und-bloss-nichts-vergessen.sql +++ b/db/articles/120_blog_raceday-und-bloss-nichts-vergessen.sql @@ -100,7 +100,7 @@ Meine Liste – ohne Anspruch auf Vollständigkeit: '', NULL, NULL, NULL, NULL, NULL, NULL, 'published', -NULL, NULL, '2024-10-01', '2025-07-01'); +'2025-07-01', NULL, '2024-10-01', '2025-07-01'); INSERT INTO :"schema".content_pages VALUES ((SELECT id FROM :"schema".pages WHERE slug='blog/raceday-und-bloss-nichts-vergessen'), (SELECT id FROM :"schema".categories WHERE slug='blog')); diff --git a/db/articles/121_blog_in-peace-with_pace-der-schmale-grat-zwischen-verballern-und-doch-nur-95prozent.sql b/db/articles/121_blog_in-peace-with_pace-der-schmale-grat-zwischen-verballern-und-doch-nur-95prozent.sql index a67c0d4..3a890f0 100644 --- a/db/articles/121_blog_in-peace-with_pace-der-schmale-grat-zwischen-verballern-und-doch-nur-95prozent.sql +++ b/db/articles/121_blog_in-peace-with_pace-der-schmale-grat-zwischen-verballern-und-doch-nur-95prozent.sql @@ -18,7 +18,7 @@ sisu-training.de/wp-content/uploads/2019/05/wie_fuehlst_du_dich-01.jpg '', NULL, NULL, NULL, NULL, NULL, NULL, 'draft', -NULL, NULL, '2024-10-01', '2024-10-01'); +'2024-10-01', NULL, '2024-10-01', '2024-10-01'); INSERT INTO :"schema".content_pages VALUES ((SELECT id FROM :"schema".pages WHERE slug='blog/in-peace-with_pace-der-schmale-grat-zwischen-verballern-und-doch-nur-95prozent'), (SELECT id FROM :"schema".categories WHERE slug='blog')); diff --git a/db/articles/122_blog_athletiktraining.sql b/db/articles/122_blog_athletiktraining.sql index 0fa17f1..b91b5ab 100644 --- a/db/articles/122_blog_athletiktraining.sql +++ b/db/articles/122_blog_athletiktraining.sql @@ -25,7 +25,7 @@ Jedoch wenn der Körper beim Schwimmen wie ein Lappen im Wasser liegt anstelle w '', NULL, NULL, NULL, NULL, NULL, NULL, 'draft', -NULL, NULL, '2024-10-01', '2024-10-01'); +'2024-10-01', NULL, '2024-10-01', '2024-10-01'); INSERT INTO :"schema".content_pages VALUES ((SELECT id FROM :"schema".pages WHERE slug='blog/athletiktraining'), (SELECT id FROM :"schema".categories WHERE slug='blog')); diff --git a/db/articles/123_blog_kraft-vs-kraftausdauer-vs-k3-vs-dicker-gang.sql b/db/articles/123_blog_kraft-vs-kraftausdauer-vs-k3-vs-dicker-gang.sql index c37e440..9850d62 100644 --- a/db/articles/123_blog_kraft-vs-kraftausdauer-vs-k3-vs-dicker-gang.sql +++ b/db/articles/123_blog_kraft-vs-kraftausdauer-vs-k3-vs-dicker-gang.sql @@ -182,7 +182,7 @@ Ergänzend praxisorientiert: '', NULL, NULL, NULL, NULL, NULL, NULL, 'published', -NULL, NULL, '2024-10-01', '2026-05-03'); +'2026-05-03', NULL, '2024-10-01', '2026-05-03'); INSERT INTO :"schema".content_pages VALUES ((SELECT id FROM :"schema".pages WHERE slug='blog/kraft-vs-kraftausdauer-vs-k3-vs-dicker-gang'), (SELECT id FROM :"schema".categories WHERE slug='blog')); diff --git a/db/articles/124_blog_fettstoffwechsel_fettverbrennung_fatmax.sql b/db/articles/124_blog_fettstoffwechsel_fettverbrennung_fatmax.sql index 2be16f9..04bce40 100644 --- a/db/articles/124_blog_fettstoffwechsel_fettverbrennung_fatmax.sql +++ b/db/articles/124_blog_fettstoffwechsel_fettverbrennung_fatmax.sql @@ -178,7 +178,7 @@ Die Fettverbrennung ist kein statischer Zustand, sondern das Ergebnis eines **me '', NULL, NULL, NULL, NULL, NULL, NULL, 'published', -NULL, NULL, '2024-10-01', '2026-05-05'); +'2026-05-05', NULL, '2024-10-01', '2026-05-05'); INSERT INTO :"schema".content_pages VALUES ((SELECT id FROM :"schema".pages WHERE slug='blog/fettstoffwechsel_fettverbrennung_fatmax'), (SELECT id FROM :"schema".categories WHERE slug='blog')); diff --git a/db/articles/125_blog_bikefitting.sql b/db/articles/125_blog_bikefitting.sql index 08e40da..4ce9938 100644 --- a/db/articles/125_blog_bikefitting.sql +++ b/db/articles/125_blog_bikefitting.sql @@ -193,7 +193,7 @@ Bikefitting ist kein Luxus, sondern ein zentraler Baustein für jeden ambitionie '', NULL, NULL, NULL, NULL, NULL, NULL, 'published', -NULL, NULL, '2024-10-01', '2026-05-03'); +'2026-05-03', NULL, '2024-10-01', '2026-05-03'); INSERT INTO :"schema".content_pages VALUES ((SELECT id FROM :"schema".pages WHERE slug='blog/bikefitting'), (SELECT id FROM :"schema".categories WHERE slug='blog')); diff --git a/db/articles/126_blog_aero-gadgets_spielzeug-oder-gamechanger.sql b/db/articles/126_blog_aero-gadgets_spielzeug-oder-gamechanger.sql index e60c7b5..b700d33 100644 --- a/db/articles/126_blog_aero-gadgets_spielzeug-oder-gamechanger.sql +++ b/db/articles/126_blog_aero-gadgets_spielzeug-oder-gamechanger.sql @@ -467,7 +467,7 @@ Gerade auf der Mittel- und Langdistanz kann das am Ende der Unterschied sein zwi '', NULL, NULL, NULL, NULL, NULL, NULL, 'published', -NULL, NULL, '2024-10-01', '2026-05-03'); +'2026-05-03', NULL, '2024-10-01', '2026-05-03'); INSERT INTO :"schema".content_pages VALUES ((SELECT id FROM :"schema".pages WHERE slug='blog/aero-gadgets_spielzeug-oder-gamechanger'), (SELECT id FROM :"schema".categories WHERE slug='blog')); diff --git a/db/articles/127_blog_carboloading-muskelglykogen-leberglykogen-blutzucker.sql b/db/articles/127_blog_carboloading-muskelglykogen-leberglykogen-blutzucker.sql index 2f3ac48..798d697 100644 --- a/db/articles/127_blog_carboloading-muskelglykogen-leberglykogen-blutzucker.sql +++ b/db/articles/127_blog_carboloading-muskelglykogen-leberglykogen-blutzucker.sql @@ -124,7 +124,7 @@ Auswahl '', NULL, NULL, NULL, NULL, NULL, NULL, 'published', -NULL, NULL, '2024-10-01', '2026-04-28'); +'2026-04-28', NULL, '2024-10-01', '2026-04-28'); INSERT INTO :"schema".content_pages VALUES ((SELECT id FROM :"schema".pages WHERE slug='blog/carboloading-muskelglykogen-leberglykogen-blutzucker'), (SELECT id FROM :"schema".categories WHERE slug='blog')); diff --git a/db/articles/128_blog_gibt-es-alternativen-zu-teuren-gels.sql b/db/articles/128_blog_gibt-es-alternativen-zu-teuren-gels.sql index 83509b8..0c08e2d 100644 --- a/db/articles/128_blog_gibt-es-alternativen-zu-teuren-gels.sql +++ b/db/articles/128_blog_gibt-es-alternativen-zu-teuren-gels.sql @@ -133,7 +133,7 @@ Im Training kannst du optimieren - '', NULL, NULL, NULL, NULL, NULL, NULL, 'published', -NULL, NULL, '2024-10-01', '2026-05-07'); +'2026-05-07', NULL, '2024-10-01', '2026-05-07'); INSERT INTO :"schema".content_pages VALUES ((SELECT id FROM :"schema".pages WHERE slug='blog/gibt-es-alternativen-zu-teuren-gels'), (SELECT id FROM :"schema".categories WHERE slug='blog')); diff --git a/db/articles/700_camps.sql b/db/articles/700_camps.sql index 26572a4..4eea61a 100644 --- a/db/articles/700_camps.sql +++ b/db/articles/700_camps.sql @@ -20,4 +20,4 @@ NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, 'published', -NULL, NULL, '2024-10-01', '2024-10-01'); +'2024-10-01', NULL, '2024-10-01', '2024-10-01'); diff --git a/db/articles/701_camps_2026_cesenatico.sql b/db/articles/701_camps_2026_cesenatico.sql index dabccf1..71d4021 100644 --- a/db/articles/701_camps_2026_cesenatico.sql +++ b/db/articles/701_camps_2026_cesenatico.sql @@ -5,7 +5,7 @@ SET search_path TO :"schema"; INSERT INTO :"schema".pages VALUES (DEFAULT, 'camps/2026/cesenatico', (SELECT id FROM :"schema".pages WHERE slug='camps'), 'event', -0, true, NULL, NULL, NULL, now(), now()); +0, true, NULL, NULL, NULL, '2024-10-01', '2024-10-01'); INSERT INTO :"schema".page_content VALUES (DEFAULT, (SELECT id FROM :"schema".pages WHERE slug='camps/2026/cesenatico'), 1, NULL, 'Trainingslager Cesenatico 2026', @@ -16,7 +16,7 @@ NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, 'published', -NULL, NULL, now(), now()); +'2024-10-01', NULL, '2024-10-01', '2024-10-01'); INSERT INTO :"schema".events VALUES ( diff --git a/db/articles/702_seminar_202405_radtechnik.sql b/db/articles/702_seminar_202405_radtechnik.sql index 80afdb3..932f97d 100644 --- a/db/articles/702_seminar_202405_radtechnik.sql +++ b/db/articles/702_seminar_202405_radtechnik.sql @@ -5,7 +5,7 @@ SET search_path TO :"schema"; INSERT INTO :"schema".pages VALUES (DEFAULT, 'camps/2024/05/radtechnik', (SELECT id FROM :"schema".pages WHERE slug='camps'), 'event', -0, true, NULL, NULL, NULL, now(), now()); +0, true, NULL, NULL, NULL, '2024-10-01', '2024-10-01'); INSERT INTO :"schema".page_content VALUES (DEFAULT, (SELECT id FROM :"schema".pages WHERE slug='camps/2024/05/radtechnik'), 1, NULL, 'Radtechnik Seminar 2024', @@ -16,7 +16,7 @@ NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, 'published', -NULL, NULL, now(), now()); +'2024-10-01', NULL, '2024-10-01', '2024-10-01'); INSERT INTO :"schema".events VALUES ( diff --git a/db/articles/703_seminar_202609_laufseminar.sql b/db/articles/703_seminar_202609_laufseminar.sql index 0ed80cf..b9828a3 100644 --- a/db/articles/703_seminar_202609_laufseminar.sql +++ b/db/articles/703_seminar_202609_laufseminar.sql @@ -5,7 +5,7 @@ SET search_path TO :"schema"; INSERT INTO :"schema".pages VALUES (DEFAULT, 'camps/2026/09/besser_laufen', (SELECT id FROM :"schema".pages WHERE slug='camps'), 'event', -0, true, NULL, NULL, NULL, now(), now()); +0, true, NULL, NULL, NULL, '2024-10-01', '2024-10-01'); INSERT INTO :"schema".page_content VALUES (DEFAULT, (SELECT id FROM :"schema".pages WHERE slug='camps/2026/09/besser_laufen'), 1, NULL, 'Besser Laufen! September 2026', @@ -16,7 +16,7 @@ NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, 'published', -NULL, NULL, now(), now()); +'2024-10-01', NULL, '2024-10-01', '2024-10-01'); INSERT INTO :"schema".events VALUES ( diff --git a/db/articles/900_coaching.sql b/db/articles/900_coaching.sql index 024b1e0..dbb77f3 100644 --- a/db/articles/900_coaching.sql +++ b/db/articles/900_coaching.sql @@ -22,4 +22,4 @@ INSERT INTO :"schema".page_content VALUES (DEFAULT, (SELECT id FROM :"sche '', NULL, NULL, NULL, NULL, NULL, NULL, 'published', -NULL, NULL, '2024-10-01', '2024-10-01'); +'2024-10-01', NULL, '2024-10-01', '2024-10-01'); diff --git a/db/articles/901_personal-coaching.sql b/db/articles/901_personal-coaching.sql index ee9cd02..fd15785 100644 --- a/db/articles/901_personal-coaching.sql +++ b/db/articles/901_personal-coaching.sql @@ -23,4 +23,4 @@ INSERT INTO :"schema".page_content VALUES (DEFAULT, (SELECT id FROM :"sche '', NULL, NULL, NULL, NULL, NULL, NULL, 'published', -NULL, NULL, '2024-10-01', '2024-10-01'); +'2024-10-01', NULL, '2024-10-01', '2024-10-01'); diff --git a/db/articles/910_athleten.sql b/db/articles/910_athleten.sql index 149b210..e955533 100644 --- a/db/articles/910_athleten.sql +++ b/db/articles/910_athleten.sql @@ -21,5 +21,5 @@ INSERT INTO :"schema".page_content VALUES (DEFAULT, (SELECT id FROM :"sche '', NULL, NULL, NULL, NULL, NULL, NULL, 'published', -NULL, NULL, '2024-10-01', '2024-10-01'); +'2024-10-01', NULL, '2024-10-01', '2024-10-01'); diff --git a/db/articles/950_standard-plaene.sql b/db/articles/950_standard-plaene.sql index b8df7bd..2957251 100644 --- a/db/articles/950_standard-plaene.sql +++ b/db/articles/950_standard-plaene.sql @@ -63,4 +63,4 @@ Und es kann auch schneller oder langsamer werden, abhängig von Wetter, Strecken '', NULL, NULL, NULL, NULL, NULL, NULL, 'published', -NULL, NULL, '2024-10-01', '2024-10-01'); +'2024-10-01', NULL, '2024-10-01', '2024-10-01'); diff --git a/db/articles/960_langdistanz.sql b/db/articles/960_langdistanz.sql index 5051aa8..1422e9d 100644 --- a/db/articles/960_langdistanz.sql +++ b/db/articles/960_langdistanz.sql @@ -66,7 +66,7 @@ Zielzeit unter 8:45 (m) / 9:30 (w) '', NULL, NULL, NULL, NULL, NULL, NULL, 'published', -NULL, NULL, '2024-10-01', '2024-10-01'); +'2024-10-01', NULL, '2024-10-01', '2024-10-01'); -- ============================================================ diff --git a/db/articles/970_mitteldistanz.sql b/db/articles/970_mitteldistanz.sql index a3ab280..a9f6f06 100644 --- a/db/articles/970_mitteldistanz.sql +++ b/db/articles/970_mitteldistanz.sql @@ -68,7 +68,7 @@ Zielzeit unter 4:15 (m) / 4:45 (w) '', NULL, NULL, NULL, NULL, NULL, NULL, 'published', -NULL, NULL, '2024-10-01', '2024-10-01'); +'2024-10-01', NULL, '2024-10-01', '2024-10-01'); -- ============================================================ -- 2. hero_style auf 'carousel' setzen diff --git a/db/articles/980_kurzdistanz.sql b/db/articles/980_kurzdistanz.sql index 9622b2b..1f4b346 100644 --- a/db/articles/980_kurzdistanz.sql +++ b/db/articles/980_kurzdistanz.sql @@ -58,7 +58,7 @@ Zielzeit unter 2:10 (m) / 2:25 (w) '', NULL, NULL, NULL, NULL, NULL, NULL, 'published', -NULL, NULL, '2024-10-01', '2024-10-01'); +'2024-10-01', NULL, '2024-10-01', '2024-10-01'); INSERT INTO content_media VALUES ( (SELECT id FROM :"schema".page_content WHERE page_id = (SELECT id FROM pages WHERE slug = 'kurzdistanz')), -- 2.39.5