summaryrefslogtreecommitdiffstats
path: root/cps-ri/src/main/resources/changelog/db/changes/17-add-index-to-schema-set-yang-resources.yaml
diff options
context:
space:
mode:
authorSourabh Sourabh <sourabh.sourabh@est.tech>2023-03-08 09:52:59 +0000
committerGerrit Code Review <gerrit@onap.org>2023-03-08 09:52:59 +0000
commitd23fc75c8d3aa485da9e914e730a5583630126ec (patch)
tree089591f409b949cd6af63e2c742cfaeb41dd1b3d /cps-ri/src/main/resources/changelog/db/changes/17-add-index-to-schema-set-yang-resources.yaml
parent47185766eb42439067e152bcc99465eb8f1b5f33 (diff)
parent38d3064bcb92ed175f2e3b83b10b12c822dfe811 (diff)
Merge "Add index to schema_set_yang_resources table"
Diffstat (limited to 'cps-ri/src/main/resources/changelog/db/changes/17-add-index-to-schema-set-yang-resources.yaml')
-rw-r--r--cps-ri/src/main/resources/changelog/db/changes/17-add-index-to-schema-set-yang-resources.yaml15
1 files changed, 15 insertions, 0 deletions
diff --git a/cps-ri/src/main/resources/changelog/db/changes/17-add-index-to-schema-set-yang-resources.yaml b/cps-ri/src/main/resources/changelog/db/changes/17-add-index-to-schema-set-yang-resources.yaml
new file mode 100644
index 0000000000..bc16725109
--- /dev/null
+++ b/cps-ri/src/main/resources/changelog/db/changes/17-add-index-to-schema-set-yang-resources.yaml
@@ -0,0 +1,15 @@
+databaseChangeLog:
+ - changeSet:
+ author: cps
+ id: 17
+ changes:
+ - createIndex:
+ columns:
+ - column:
+ name: schema_set_id
+ indexName: FKI_SCHEMA_SET_YANG_RESOURCES_SCHEMA_SET_ID_FK
+ tableName: schema_set_yang_resources
+ rollback:
+ - dropIndex:
+ indexName: FKI_SCHEMA_SET_YANG_RESOURCES_SCHEMA_SET_ID_FK
+ tableName: schema_set_yang_resources