diff options
| author |   Rob Daugherty <rd472p@att.com> | 2018-08-30 14:26:55 -0400 |
|---|---|---|
| committer | Rob Daugherty <rd472p@att.com> | 2018-08-30 14:30:01 -0400 |
| commit | add0df04cc24deae1f16a215dffa32393ed586ca (patch) | |
| tree | 14f0cecd915eb2d5ffafa46dc27080181c71c564 /adapters/mso-catalog-db-adapter/src/main/resources/db/migration/V4.7__CreateTableControllerSelectionRefence.sql | |
| parent | 1ff9c3d426e0a67bef180a324d8e77962a7e72c1 (diff) | |
Create a Reference Table for Controller Selection
Also: Modify Alacarte Reference Data
This commit consolidates changes from three abandoned commits:
https://gerrit.onap.org/r/60959
https://gerrit.onap.org/r/60953
https://gerrit.onap.org/r/60397
Change-Id: I295a79cb05ca742ae5743892397e75c7c228bde3
Issue-ID: SO-763
Issue-ID: SO-676
Signed-off-by: Rob Daugherty <rd472p@att.com>
Diffstat (limited to 'adapters/mso-catalog-db-adapter/src/main/resources/db/migration/V4.7__CreateTableControllerSelectionRefence.sql')
| -rw-r--r-- | adapters/mso-catalog-db-adapter/src/main/resources/db/migration/V4.7__CreateTableControllerSelectionRefence.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/adapters/mso-catalog-db-adapter/src/main/resources/db/migration/V4.7__CreateTableControllerSelectionRefence.sql b/adapters/mso-catalog-db-adapter/src/main/resources/db/migration/V4.7__CreateTableControllerSelectionRefence.sql new file mode 100644 index 0000000000..dbeba53acc --- /dev/null +++ b/adapters/mso-catalog-db-adapter/src/main/resources/db/migration/V4.7__CreateTableControllerSelectionRefence.sql @@ -0,0 +1,8 @@ +use catalogdb; + +CREATE TABLE IF NOT EXISTS `controller_selection_reference` ( + `VNF_TYPE` VARCHAR(50) NOT NULL, + `CONTROLLER_NAME` VARCHAR(100) NOT NULL, + `ACTION_CATEGORY` VARCHAR(15) NOT NULL, + PRIMARY KEY (`VNF_TYPE`, `CONTROLLER_NAME`, `ACTION_CATEGORY`) + ) ENGINE = InnoDB DEFAULT CHARSET=latin1; |