aboutsummaryrefslogtreecommitdiffstats
path: root/adapters/mso-requests-db-adapter/src/main/resources/db
diff options
context:
space:
mode:
authorMnushkin, Dmitry <dmitry.mnushkin@att.com>2019-06-14 14:46:49 -0400
committerBenjamin, Max (mb388a) <mb388a@us.att.com>2019-06-14 14:46:55 -0400
commitd98610d6f7a9f369cd8181bea2c5b2b7af6e6944 (patch)
tree45b7365a275e5a993750854ff538557dc529364e /adapters/mso-requests-db-adapter/src/main/resources/db
parente29b04bca6367c14fdbd403bbd275e6c8c10fa60 (diff)
add is_data_internal column to request db
add is_data_internal column to request processing data Use Boolean type in java bean to be mapped by hibernate Change-Id: I40a96f80114e02a2ced17efb47e45718dfd2ee7c Issue-ID: SO-2023 Signed-off-by: Benjamin, Max (mb388a) <mb388a@us.att.com>
Diffstat (limited to 'adapters/mso-requests-db-adapter/src/main/resources/db')
-rw-r--r--adapters/mso-requests-db-adapter/src/main/resources/db/migration/V5.10__Add_Column_IS_DATA_INTERNAL.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/adapters/mso-requests-db-adapter/src/main/resources/db/migration/V5.10__Add_Column_IS_DATA_INTERNAL.sql b/adapters/mso-requests-db-adapter/src/main/resources/db/migration/V5.10__Add_Column_IS_DATA_INTERNAL.sql
new file mode 100644
index 0000000000..2196d11e07
--- /dev/null
+++ b/adapters/mso-requests-db-adapter/src/main/resources/db/migration/V5.10__Add_Column_IS_DATA_INTERNAL.sql
@@ -0,0 +1,3 @@
+use requestdb;
+
+ALTER TABLE request_processing_data ADD COLUMN IF NOT EXISTS IS_DATA_INTERNAL TINYINT NOT NULL DEFAULT '0'; \ No newline at end of file