From 46928964ef2b469a8c3f9eb997591ead0e6ea093 Mon Sep 17 00:00:00 2001
From: Paul-Christian Volkmer
Date: Tue, 25 Jul 2023 16:48:45 +0200
Subject: Add postgres migration file and configuration for postgres

---
 src/main/resources/db/migration/mariadb/V0_1_0__Init.sql | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'src/main/resources/db/migration/mariadb')

diff --git a/src/main/resources/db/migration/mariadb/V0_1_0__Init.sql b/src/main/resources/db/migration/mariadb/V0_1_0__Init.sql
index 0683195..38a3d5f 100644
--- a/src/main/resources/db/migration/mariadb/V0_1_0__Init.sql
+++ b/src/main/resources/db/migration/mariadb/V0_1_0__Init.sql
@@ -1,8 +1,9 @@
 CREATE TABLE IF NOT EXISTS request
 (
     id           int auto_increment primary key,
-    uuid         varchar(255)                     not null,
+    uuid         varchar(255)                     not null unique,
     patient_id   varchar(255)                     not null,
+    pid          varchar(255)                     not null,
     fingerprint  varchar(255)                     not null,
     status       varchar(16)                      not null,
     processed_at datetime default utc_timestamp() not null
-- 
cgit v1.2.3