summaryrefslogtreecommitdiffstats
path: root/mso-api-handlers/mso-requests-db-repositories/src/test/resources/schema.sql
diff options
context:
space:
mode:
authorBenjamin, Max (mb388a) <mb388a@us.att.com>2018-11-10 12:29:48 -0500
committerRob Daugherty <rd472p@att.com>2018-11-14 20:55:18 +0000
commit7feaa94e569653066c7ebff3dda3218869797f39 (patch)
treefc0416b5485c10bb9d87e2996a774090753bf116 /mso-api-handlers/mso-requests-db-repositories/src/test/resources/schema.sql
parentbe24ada950e9f41a6034b472fc5502b285a510d5 (diff)
Added groupInstanceId and groupInstanceName column
Updated schema.sql to include new columns Added groupInstanceId and groupInstanceName columns Change-Id: I6dab9acea9bb4954c8b113034d70f01bbd9437db Issue-ID: SO-1206 Signed-off-by: Benjamin, Max (mb388a) <mb388a@us.att.com>
Diffstat (limited to 'mso-api-handlers/mso-requests-db-repositories/src/test/resources/schema.sql')
-rw-r--r--mso-api-handlers/mso-requests-db-repositories/src/test/resources/schema.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/mso-api-handlers/mso-requests-db-repositories/src/test/resources/schema.sql b/mso-api-handlers/mso-requests-db-repositories/src/test/resources/schema.sql
index 57d765f4e5..bf9a9e1dfe 100644
--- a/mso-api-handlers/mso-requests-db-repositories/src/test/resources/schema.sql
+++ b/mso-api-handlers/mso-requests-db-repositories/src/test/resources/schema.sql
@@ -93,6 +93,8 @@ CREATE CACHED TABLE PUBLIC.INFRA_ACTIVE_REQUESTS(
CONFIGURATION_NAME VARCHAR SELECTIVITY 2,
OPERATIONAL_ENV_ID VARCHAR SELECTIVITY 1,
OPERATIONAL_ENV_NAME VARCHAR SELECTIVITY 1,
+ INSTANCE_GROUP_ID VARCHAR SELECTIVITY 1,
+ INSTANCE_GROUP_NAME VARCHAR SELECTIVITY 1,
REQUEST_URL VARCHAR SELECTIVITY 1
);
@@ -153,6 +155,8 @@ CREATE CACHED TABLE PUBLIC.ARCHIVED_INFRA_REQUESTS(
CONFIGURATION_NAME VARCHAR SELECTIVITY 2,
OPERATIONAL_ENV_ID VARCHAR SELECTIVITY 1,
OPERATIONAL_ENV_NAME VARCHAR SELECTIVITY 1,
+ INSTANCE_GROUP_ID VARCHAR SELECTIVITY 1,
+ INSTANCE_GROUP_NAME VARCHAR SELECTIVITY 1,
REQUEST_URL VARCHAR SELECTIVITY 1
);