diff options
| author |   Timoney, Dan (dt5972) <dt5972@att.com> | 2018-09-20 13:20:29 -0400 |
|---|---|---|
| committer | Timoney, Dan (dt5972) <dt5972@att.com> | 2018-09-20 13:47:40 -0400 |
| commit | 4b406a62a55f95d656ac1bfff4862ad175104cb5 (patch) | |
| tree | 12bbb38d68b9d767996b536b80ac8df506ccbddb /installation | |
| parent | 7426db8cebd3fa564c0e2f8373476e34bbc67afa (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.dump | 13 |
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 */; |