From 193bd8c4faff834c51c242dc353058413ceecba1 Mon Sep 17 00:00:00 2001 From: Alexis de Talhouët Date: Fri, 24 Aug 2018 09:02:47 -0400 Subject: Update SQL dump for IPAM tables MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit - Fixes typos - Change status column type from Integer to varchar Change-Id: Ibf15233597fc459d43273688f42deb9538a18d51 Issue-ID: CCSDK-463 Signed-off-by: Alexis de Talhouët Former-commit-id: 8412046772d505f6216e5331c5febc74b3186189 --- installation/sdnc/src/main/resources/ipam.data.dump | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) (limited to 'installation') diff --git a/installation/sdnc/src/main/resources/ipam.data.dump b/installation/sdnc/src/main/resources/ipam.data.dump index 911b9674..ededc73b 100644 --- a/installation/sdnc/src/main/resources/ipam.data.dump +++ b/installation/sdnc/src/main/resources/ipam.data.dump @@ -28,7 +28,7 @@ CREATE TABLE `IPAM_IP_POOL` ( `prefix_id` int(2) DEFAULT NULL, `prefix` varchar(255) DEFAULT NULL, `address_family` int(1) DEFAULT NULL, - `prefix_status` int(1) DEFAULT NULL, + `prefix_status` varchar(255) DEFAULT NULL, `description` varchar(255) DEFAULT NULL, PRIMARY KEY (`ipam_pool_uuid`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1; @@ -40,7 +40,7 @@ CREATE TABLE `IPAM_IP_POOL` ( LOCK TABLES `IPAM_IP_POOL` WRITE; /*!40000 ALTER TABLE `IPAM_IP_POOL` DISABLE KEYS */; -INSERT INTO `IPAM_IP_POOL` VALUES (1,'2018-08-17 20:15:12',3,'10.0.0.0/8',4,1,'IP Pool for ONAP - general purpose'),(2,'2018-08-17 20:19:29',2,'192.168.10.0/24',4,1,'IP Pool for unprotected network - vFW use case'),(4,'2018-08-17 20:20:08',1,'192.168.20.0/24',4,1,'IP Pool for protected network - vFW use case'); +INSERT INTO `IPAM_IP_POOL` VALUES (1,'2018-08-17 20:15:12',3,'10.0.0.0/8',4,'ACTIVE','IP Pool for ONAP - general purpose'),(2,'2018-08-17 20:19:29',2,'192.168.10.0/24',4,'ACTIVE','IP Pool for unprotected network - vFW use case'),(3,'2018-08-17 20:20:08',1,'192.168.20.0/24',4,'ACTIVE','IP Pool for protected network - vFW use case'); /*!40000 ALTER TABLE `IPAM_IP_POOL` ENABLE KEYS */; UNLOCK TABLES; @@ -58,10 +58,10 @@ CREATE TABLE `IPAM_IP_ASSIGNEMENT` ( `vf_module_id` varchar(255) DEFAULT NULL, `prefix_id` varchar(255) DEFAULT NULL, `ip_address_id` varchar(255) DEFAULT NULL, - `ip_adress` varchar(255) DEFAULT NULL, + `ip_address` varchar(255) DEFAULT NULL, `ip_address_type` varchar(255) DEFAULT NULL, `ip_status` varchar(255) DEFAULT NULL, - `ip_response` varchar(255) DEFAULT NULL, + `ip_response_json` varchar(255) DEFAULT NULL, PRIMARY KEY (`ipam_ip_uuid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; @@ -84,4 +84,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2018-08-17 20:24:31 \ No newline at end of file +-- Dump completed on 2018-08-24 13:02:09 \ No newline at end of file -- cgit 1.2.3-korg