From 670bec1c5bd6008f97315afd04921f907b36c016 Mon Sep 17 00:00:00 2001 From: "Bonkur, Venkat (vb8416)" Date: Thu, 1 Aug 2019 23:30:05 -0400 Subject: Add SO Increase Action_category column width MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit 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) Change-Id: Ia5c813bfabfc95d4502c7ade4413672c64ad8ada --- .../V6.1__AlterColumnActionCategoryControllerSelectionCategory.sql | 3 +++ 1 file changed, 3 insertions(+) create mode 100644 adapters/mso-catalog-db-adapter/src/main/resources/db/migration/V6.1__AlterColumnActionCategoryControllerSelectionCategory.sql (limited to 'adapters/mso-catalog-db-adapter/src/main/resources') 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; -- cgit 1.2.3-korg