From 4f7f5e4d89c39f9779f9af4663cf97cecc8eefd7 Mon Sep 17 00:00:00 2001
From: Paul-Christian Volkmer
Date: Tue, 1 Aug 2023 08:39:30 +0200
Subject: Add request type to be saved with each request

---
 src/main/resources/db/migration/mariadb/V0_1_1__RequestType.sql    | 2 ++
 src/main/resources/db/migration/postgresql/V0_1_1__RequestType.sql | 2 ++
 2 files changed, 4 insertions(+)
 create mode 100644 src/main/resources/db/migration/mariadb/V0_1_1__RequestType.sql
 create mode 100644 src/main/resources/db/migration/postgresql/V0_1_1__RequestType.sql

(limited to 'src/main/resources')

diff --git a/src/main/resources/db/migration/mariadb/V0_1_1__RequestType.sql b/src/main/resources/db/migration/mariadb/V0_1_1__RequestType.sql
new file mode 100644
index 0000000..9cc9ab2
--- /dev/null
+++ b/src/main/resources/db/migration/mariadb/V0_1_1__RequestType.sql
@@ -0,0 +1,2 @@
+ALTER TABLE request ADD COLUMN type varchar(16) not null;
+UPDATE request SET type = 'MTB_FILE';
\ No newline at end of file
diff --git a/src/main/resources/db/migration/postgresql/V0_1_1__RequestType.sql b/src/main/resources/db/migration/postgresql/V0_1_1__RequestType.sql
new file mode 100644
index 0000000..9cc9ab2
--- /dev/null
+++ b/src/main/resources/db/migration/postgresql/V0_1_1__RequestType.sql
@@ -0,0 +1,2 @@
+ALTER TABLE request ADD COLUMN type varchar(16) not null;
+UPDATE request SET type = 'MTB_FILE';
\ No newline at end of file
-- 
cgit v1.2.3