diff options
| author | Paul-Christian Volkmer | 2026-03-10 09:01:58 +0100 |
|---|---|---|
| committer | GitHub | 2026-03-10 08:01:58 +0000 |
| commit | 1a0011765fa2d34f7d0075f463beb9e614ec8812 (patch) | |
| tree | fb55eb32700d21c3ab6da5b1e68c07a7e21e4014 /src/main/resources/db | |
| parent | 48f6124e2cc27476dba8ebfb398c1b4ad8875164 (diff) | |
feat: request update audit (#258)
This adds the date and username when a request gets updated.
If the request gets updated by an async Kafka response, "SYSTEM" will be used as username.
Diffstat (limited to 'src/main/resources/db')
| -rw-r--r-- | src/main/resources/db/migration/mariadb/V0_15_0_2__UpdatedAtBy.sql | 2 | ||||
| -rw-r--r-- | src/main/resources/db/migration/postgresql/V0_15_0_2__UpdatedAtBy.sql | 2 |
2 files changed, 4 insertions, 0 deletions
diff --git a/src/main/resources/db/migration/mariadb/V0_15_0_2__UpdatedAtBy.sql b/src/main/resources/db/migration/mariadb/V0_15_0_2__UpdatedAtBy.sql new file mode 100644 index 0000000..2005c4f --- /dev/null +++ b/src/main/resources/db/migration/mariadb/V0_15_0_2__UpdatedAtBy.sql @@ -0,0 +1,2 @@ +ALTER TABLE request ADD COLUMN updated_at datetime; +ALTER TABLE request ADD COLUMN updated_by varchar(255);
\ No newline at end of file diff --git a/src/main/resources/db/migration/postgresql/V0_15_0_2__UpdatedAtBy.sql b/src/main/resources/db/migration/postgresql/V0_15_0_2__UpdatedAtBy.sql new file mode 100644 index 0000000..ed5c807 --- /dev/null +++ b/src/main/resources/db/migration/postgresql/V0_15_0_2__UpdatedAtBy.sql @@ -0,0 +1,2 @@ +ALTER TABLE request ADD COLUMN updated_at timestamp with time zone; +ALTER TABLE request ADD COLUMN updated_by varchar(255);
\ No newline at end of file |