aboutsummaryrefslogtreecommitdiffstats
path: root/adapters/mso-requests-db-adapter
diff options
context:
space:
mode:
authorChuanyu Chen <chenchuanyu@huawei.com>2020-01-06 01:31:49 +0000
committerGerrit Code Review <gerrit@onap.org>2020-01-06 01:31:49 +0000
commit04e0f4e870c7e45a3a1f8f2c56a758bf3a635c2e (patch)
treea21acd19c0e03629c9addd49b7c125ccb94fffe1 /adapters/mso-requests-db-adapter
parenteff76af0a3eb5fd9acd974fd4054815536b0c9cb (diff)
parentcd30f0cb0f6fe465d13a97e55359bd6bea158f08 (diff)
Merge "SO API to support custom PNF workflow"
Diffstat (limited to 'adapters/mso-requests-db-adapter')
-rw-r--r--adapters/mso-requests-db-adapter/src/main/resources/db/migration/V7.2__Add_PNF_Column_Infra_Requests_archive_tables.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/adapters/mso-requests-db-adapter/src/main/resources/db/migration/V7.2__Add_PNF_Column_Infra_Requests_archive_tables.sql b/adapters/mso-requests-db-adapter/src/main/resources/db/migration/V7.2__Add_PNF_Column_Infra_Requests_archive_tables.sql
new file mode 100644
index 0000000000..dbdc925dae
--- /dev/null
+++ b/adapters/mso-requests-db-adapter/src/main/resources/db/migration/V7.2__Add_PNF_Column_Infra_Requests_archive_tables.sql
@@ -0,0 +1,4 @@
+use requestdb;
+
+ALTER TABLE infra_active_requests ADD COLUMN IF NOT EXISTS PNF_ID varchar(45);
+ALTER TABLE archived_infra_requests ADD COLUMN IF NOT EXISTS PNF_ID varchar(45); \ No newline at end of file