summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorDavid Stilwell <stilwelld@att.com>2018-09-20 19:18:00 +0000
committerGerrit Code Review <gerrit@onap.org>2018-09-20 19:18:00 +0000
commita0c0c7389da1a783b162e3223b7e5d7dd0d30031 (patch)
treeb48336ccd110bd2639ddf0fe34afb43943eb880b
parentcb6ceadfa348e8df932d89d04194f9a29b4c27c1 (diff)
parent4b406a62a55f95d656ac1bfff4862ad175104cb5 (diff)
Merge "Table schema fixes"
Former-commit-id: 3ba9a345c366f865fa70dd89dfbb5325009b5cce
-rw-r--r--installation/sdnc/src/main/resources/sdnctl.dump13
1 files changed, 13 insertions, 0 deletions
diff --git a/installation/sdnc/src/main/resources/sdnctl.dump b/installation/sdnc/src/main/resources/sdnctl.dump
index 9949c88c..04a9ad73 100644
--- a/installation/sdnc/src/main/resources/sdnctl.dump
+++ b/installation/sdnc/src/main/resources/sdnctl.dump
@@ -989,6 +989,9 @@ DROP TABLE IF EXISTS `GENERIC_RESOURCE_NAME`;
CREATE TABLE `GENERIC_RESOURCE_NAME` (
`type` varchar(50) NOT NULL,
`name` varchar(255) NOT NULL,
+ `prefix` varchar(255) NULL,
+ `name_index` int(11) NULL,
+ `content_id` varchar(255) NULL,
PRIMARY KEY (`type`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -3295,6 +3298,16 @@ CREATE TABLE `DHCP_MAP` (
PRIMARY KEY (`mac_addr`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+DROP TABLE IF EXISTS `RESOURCE_GROUP_TO_TARGET_NODE_MAPPING`;
+CREATE TABLE `RESOURCE_GROUP_TO_TARGET_NODE_MAPPING` (
+ `group_uuid` varchar(255) NOT NULL,
+ `parent_uuid` varchar(255) NOT NULL,
+ `target_node_uuid` varchar(255) NOT NULL,
+ `target_type` varchar(255) NULL,
+ `table_name` varchar(255) NULL,
+ PRIMARY KEY (`group_uuid`, `parent_uuid`, `target_node_uuid`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;