From 7298078077d27380255ad5eb42a30876a4babede Mon Sep 17 00:00:00 2001
From: Paul-Christian Volkmer
Date: Thu, 11 Jun 2026 08:11:11 +0200
Subject: feat: count follow-ups to update submission type (#297)

This is done in addition to the check by date.
The submission type will be set to "followup" if:

* It is not an initial submission
* There are follow-ups in submission content
* The date or the count is less than the last successful submission

In the database, existing requests will be initialized with
followup_count = -1.---
 src/main/resources/db/migration/mariadb/V0_16_1_1__FollowUpCount.sql    | 2 ++
 src/main/resources/db/migration/postgresql/V0_16_1_1__FollowUpCount.sql | 2 ++
 2 files changed, 4 insertions(+)
 create mode 100644 src/main/resources/db/migration/mariadb/V0_16_1_1__FollowUpCount.sql
 create mode 100644 src/main/resources/db/migration/postgresql/V0_16_1_1__FollowUpCount.sql

(limited to 'src/main/resources')

diff --git a/src/main/resources/db/migration/mariadb/V0_16_1_1__FollowUpCount.sql b/src/main/resources/db/migration/mariadb/V0_16_1_1__FollowUpCount.sql
new file mode 100644
index 0000000..a0a1fda
--- /dev/null
+++ b/src/main/resources/db/migration/mariadb/V0_16_1_1__FollowUpCount.sql
@@ -0,0 +1,2 @@
+ALTER TABLE request ADD COLUMN followup_count int DEFAULT 0;
+UPDATE request SET followup_count = -1;
\ No newline at end of file
diff --git a/src/main/resources/db/migration/postgresql/V0_16_1_1__FollowUpCount.sql b/src/main/resources/db/migration/postgresql/V0_16_1_1__FollowUpCount.sql
new file mode 100644
index 0000000..a0a1fda
--- /dev/null
+++ b/src/main/resources/db/migration/postgresql/V0_16_1_1__FollowUpCount.sql
@@ -0,0 +1,2 @@
+ALTER TABLE request ADD COLUMN followup_count int DEFAULT 0;
+UPDATE request SET followup_count = -1;
\ No newline at end of file
-- 
cgit v1.2.3