participant-integration-api: Further improvements to migrations.

digital-asset · Aug 18, 2021 · c7a74a0 · c7a74a0
1 parent 82002a7
commit c7a74a0
Show file tree

Hide file tree

Showing 3 changed files with 2 additions and 8 deletions.
diff --git a/...n-api/src/main/resources/db/migration/h2database-appendonly/V1__Append_only_schema.sha256 b/...n-api/src/main/resources/db/migration/h2database-appendonly/V1__Append_only_schema.sha256
@@ -1 +1 @@
-2c67203c14e8cd9a316f8a2787be30cf13ecb9eedcafa49876b8f9b63b99bc71
+d5d135c634d971cd4a4b67d81bb28da4a0ea01c94070675b24b990ffcf285321
diff --git a/...tion-api/src/main/resources/db/migration/h2database-appendonly/V1__Append_only_schema.sql b/...tion-api/src/main/resources/db/migration/h2database-appendonly/V1__Append_only_schema.sql
@@ -132,7 +132,7 @@ CREATE TABLE participant_command_completions (
     -- keep them for parity with old data in other databases.
     rejection_status_code INTEGER,
     rejection_status_message VARCHAR,
-    rejection_status BLOB
+    rejection_status BYTEA
 );
 
 CREATE INDEX participant_command_completion_offset_application_idx ON participant_command_completions (completion_offset, application_id);
@@ -327,9 +327,6 @@ CREATE INDEX participant_events_consuming_exercise_tree_event_witnesses_idx ON p
 -- lookup by contract id
 CREATE INDEX participant_events_consuming_exercise_contract_id_idx ON participant_events_consuming_exercise (contract_id);
 
---  Copyright (c) 2021 Digital Asset (Switzerland) GmbH and/or its affiliates. All rights reserved.
---  SPDX-License-Identifier: Apache-2.0
-
 ---------------------------------------------------------------------------------------------------
 -- Events table: non-consuming exercise
 ---------------------------------------------------------------------------------------------------

diff --git a/...egration-api/src/main/resources/db/migration/oracle-appendonly/V1__Append_only_schema.sql b/...egration-api/src/main/resources/db/migration/oracle-appendonly/V1__Append_only_schema.sql
@@ -387,9 +387,6 @@ CREATE TABLE participant_events_non_consuming_exercise (
 -- offset index: used to translate to sequential_id
 CREATE INDEX participant_events_non_consuming_exercise_event_offset ON participant_events_non_consuming_exercise(event_offset);
 
---  Copyright (c) 2021 Digital Asset (Switzerland) GmbH and/or its affiliates. All rights reserved.
---  SPDX-License-Identifier: Apache-2.0
-
 -- sequential_id index for paging
 CREATE INDEX participant_events_non_consuming_exercise_event_sequential_id ON participant_events_non_consuming_exercise(event_sequential_id);
Original file line number	Diff line number	Diff line change
		@@ -1 +1 @@
		2c67203c14e8cd9a316f8a2787be30cf13ecb9eedcafa49876b8f9b63b99bc71
		d5d135c634d971cd4a4b67d81bb28da4a0ea01c94070675b24b990ffcf285321