diff options
| author | Paul-Christian Volkmer | 2023-08-01 08:39:30 +0200 |
|---|---|---|
| committer | Paul-Christian Volkmer | 2023-08-01 08:39:30 +0200 |
| commit | 4f7f5e4d89c39f9779f9af4663cf97cecc8eefd7 (patch) | |
| tree | 329f4706c2143ad9fb3f0e402a8fc45b92631fc9 /src/main/resources/db | |
| parent | a1e56f159685d178666e0ef272c43960054d5264 (diff) | |
Add request type to be saved with each request
Diffstat (limited to 'src/main/resources/db')
| -rw-r--r-- | src/main/resources/db/migration/mariadb/V0_1_1__RequestType.sql | 2 | ||||
| -rw-r--r-- | src/main/resources/db/migration/postgresql/V0_1_1__RequestType.sql | 2 |
2 files changed, 4 insertions, 0 deletions
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 |