From 2700e8117485ea4909678700c84ed232a89af3a8 Mon Sep 17 00:00:00 2001
From: "Boslet, Cory" <cory.boslet@att.com>
Date: Thu, 10 Oct 2019 17:33:54 -0400
Subject: Add column to catalog db

Add column to catalog db for fabric support
on cloud regions

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

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

diff --git a/adapters/mso-catalog-db-adapter/src/main/resources/db/migration/V7.1__UpdatedCloudSiteTable.sql b/adapters/mso-catalog-db-adapter/src/main/resources/db/migration/V7.1__UpdatedCloudSiteTable.sql
new file mode 100644
index 0000000000..ea0af2315c
--- /dev/null
+++ b/adapters/mso-catalog-db-adapter/src/main/resources/db/migration/V7.1__UpdatedCloudSiteTable.sql
@@ -0,0 +1,5 @@
+use catalogdb;
+
+ALTER TABLE cloud_sites
+    ADD COLUMN IF NOT EXISTS SUPPORT_FABRIC bit(1)
+    NOT NULL DEFAULT 1
-- 
cgit 1.2.3-korg

