summaryrefslogtreecommitdiffstats
path: root/installation
diff options
context:
space:
mode:
authorTimoney, Dan (dt5972) <dt5972@att.com>2018-09-20 13:20:29 -0400
committerTimoney, Dan (dt5972) <dt5972@att.com>2018-09-20 13:47:40 -0400
commit4b406a62a55f95d656ac1bfff4862ad175104cb5 (patch)
tree12bbb38d68b9d767996b536b80ac8df506ccbddb /installation
parent7426db8cebd3fa564c0e2f8373476e34bbc67afa (diff)
Table schema fixes
Added 3 new fields to GENERIC_RESOURCE_NAME Added missing table RESOURCE_GROUP_TO_TARGET_NODE_MAPPING Change-Id: I0c5899c705be78e00a592e656fd0b6ffc3e3fc12 Issue-ID: SDNC-463 Issue-ID: SDNC-451 Signed-off-by: Timoney, Dan (dt5972) <dt5972@att.com> Former-commit-id: bd11a71a915467d5bb6153ec161ee64388cf2bfb
Diffstat (limited to 'installation')
-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 */;