From 00257f37f7a030f1a93dc3dd67686c9fc10fafe0 Mon Sep 17 00:00:00 2001
From: "Merkel, Jeff" <jeff.merkel@att.com>
Date: Fri, 18 Oct 2019 10:56:10 -0400
Subject: - Update ResourceInput column length and check

- Update ResourceInput column length and check for existing vnfc's.

Issue-ID: SO-2462
Signed-off-by: Benjamin, Max (mb388a) <mb388a@att.com>
Change-Id: I0b0168453d3c20bb6d88a33ec82788f449bf3593
---
 .../db/migration/V7.3__UpdateVnfcCustResourceInputLength.sql          | 4 ++++
 1 file changed, 4 insertions(+)
 create mode 100644 adapters/mso-catalog-db-adapter/src/main/resources/db/migration/V7.3__UpdateVnfcCustResourceInputLength.sql

(limited to 'adapters/mso-catalog-db-adapter/src/main/resources/db/migration/V7.3__UpdateVnfcCustResourceInputLength.sql')

diff --git a/adapters/mso-catalog-db-adapter/src/main/resources/db/migration/V7.3__UpdateVnfcCustResourceInputLength.sql b/adapters/mso-catalog-db-adapter/src/main/resources/db/migration/V7.3__UpdateVnfcCustResourceInputLength.sql
new file mode 100644
index 0000000000..66c01538f7
--- /dev/null
+++ b/adapters/mso-catalog-db-adapter/src/main/resources/db/migration/V7.3__UpdateVnfcCustResourceInputLength.sql
@@ -0,0 +1,4 @@
+use catalogdb;
+
+ALTER TABLE vnfc_customization
+  MODIFY IF EXISTS RESOURCE_INPUT varchar(20000);
\ No newline at end of file
-- 
cgit 1.2.3-korg

