diff options
| author |   Chuanyu Chen <chenchuanyu@huawei.com> | 2020-01-06 01:31:49 +0000 |
|---|---|---|
| committer |   Gerrit Code Review <gerrit@onap.org> | 2020-01-06 01:31:49 +0000 |
| commit | 04e0f4e870c7e45a3a1f8f2c56a758bf3a635c2e (patch) | |
| tree | a21acd19c0e03629c9addd49b7c125ccb94fffe1 /adapters/mso-requests-db-adapter/src | |
| parent | eff76af0a3eb5fd9acd974fd4054815536b0c9cb (diff) | |
| parent | cd30f0cb0f6fe465d13a97e55359bd6bea158f08 (diff) | |
Merge "SO API to support custom PNF workflow"
Diffstat (limited to 'adapters/mso-requests-db-adapter/src')
| -rw-r--r-- | adapters/mso-requests-db-adapter/src/main/resources/db/migration/V7.2__Add_PNF_Column_Infra_Requests_archive_tables.sql | 4 |
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 |