summaryrefslogtreecommitdiff
path: root/src/main/resources/db
diff options
context:
space:
mode:
authorPaul-Christian Volkmer2026-09-21 11:43:03 +0200
committerGitHub2026-09-21 11:43:03 +0200
commitd9961a9baccaff511662b1aa1de18bdd02f94f5e (patch)
treeb4d47b8eed6aaceebaead375e8265e5f245bff82 /src/main/resources/db
parentb0fb01d12fcadf86cabbe71b16cce60fb88b0ca4 (diff)
feat: add switch/routing to send dedicated data to nNGM (#322)
Diffstat (limited to 'src/main/resources/db')
-rw-r--r--src/main/resources/db/migration/mariadb/V0_18_0_1__Destination.sql2
-rw-r--r--src/main/resources/db/migration/postgresql/V0_18_0_1__Destination.sql2
2 files changed, 4 insertions, 0 deletions
diff --git a/src/main/resources/db/migration/mariadb/V0_18_0_1__Destination.sql b/src/main/resources/db/migration/mariadb/V0_18_0_1__Destination.sql
new file mode 100644
index 0000000..a65c016
--- /dev/null
+++ b/src/main/resources/db/migration/mariadb/V0_18_0_1__Destination.sql
@@ -0,0 +1,2 @@
+ALTER TABLE request ADD COLUMN destination varchar(16) DEFAULT 'UNKNOWN';
+UPDATE request SET destination = 'UNKNOWN';
diff --git a/src/main/resources/db/migration/postgresql/V0_18_0_1__Destination.sql b/src/main/resources/db/migration/postgresql/V0_18_0_1__Destination.sql
new file mode 100644
index 0000000..a65c016
--- /dev/null
+++ b/src/main/resources/db/migration/postgresql/V0_18_0_1__Destination.sql
@@ -0,0 +1,2 @@
+ALTER TABLE request ADD COLUMN destination varchar(16) DEFAULT 'UNKNOWN';
+UPDATE request SET destination = 'UNKNOWN';