summaryrefslogtreecommitdiffstats
path: root/adapters/mso-catalog-db-adapter/src/main/resources/db
diff options
context:
space:
mode:
authorBonkur, Venkat (vb8416) <vb8416@att.com>2019-08-01 23:30:05 -0400
committerBonkur, Venkat (vb8416) <vb8416@att.com>2019-08-01 23:36:42 -0400
commit670bec1c5bd6008f97315afd04921f907b36c016 (patch)
treef0e245c38f6b9beb2eb7a775ccf888b219de67eb /adapters/mso-catalog-db-adapter/src/main/resources/db
parent15c7bc833ae91ed2590370dd001d5361149aef9a (diff)
Add SO Increase Action_category column width
Action_category column width in Controller_selection_category table is increased to accommodate activity categories like DistributeTrafficCheck which are longer than the column width. Issue-ID: SO-2185 Signed-off-by: Bonkur, Venkat (vb8416) <vb8416@att.com> Change-Id: Ia5c813bfabfc95d4502c7ade4413672c64ad8ada
Diffstat (limited to 'adapters/mso-catalog-db-adapter/src/main/resources/db')
-rw-r--r--adapters/mso-catalog-db-adapter/src/main/resources/db/migration/V6.1__AlterColumnActionCategoryControllerSelectionCategory.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/adapters/mso-catalog-db-adapter/src/main/resources/db/migration/V6.1__AlterColumnActionCategoryControllerSelectionCategory.sql b/adapters/mso-catalog-db-adapter/src/main/resources/db/migration/V6.1__AlterColumnActionCategoryControllerSelectionCategory.sql
new file mode 100644
index 0000000000..6f61b830f2
--- /dev/null
+++ b/adapters/mso-catalog-db-adapter/src/main/resources/db/migration/V6.1__AlterColumnActionCategoryControllerSelectionCategory.sql
@@ -0,0 +1,3 @@
+USE catalogdb;
+
+ALTER TABLE controller_selection_reference MODIFY ACTION_CATEGORY VARCHAR(50) NOT NULL;