X-Git-Url: https://gerrit.onap.org/r/gitweb?a=blobdiff_plain;f=installation%2Fsdnc%2Fsrc%2Fmain%2Fresources%2Fipam.data.dump;h=3aa8c62521bc916448263e1d01c57da801753ea1;hb=483c147b7f641fd5992bf726dacc1e58cce629e7;hp=911b9674ee32671e802f8e549cbd15c8b8c3af1c;hpb=0ba4bf39c08efa83c1be2e47001bae487ec7ea67;p=sdnc%2Foam.git

diff --git a/installation/sdnc/src/main/resources/ipam.data.dump b/installation/sdnc/src/main/resources/ipam.data.dump
index 911b9674..3aa8c625 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.101.0/24',4,'ACTIVE','management'),(2,'2018-08-17 20:19:29',2,'192.168.10.0/24',4,'ACTIVE','private1'),(3,'2018-08-17 20:20:08',1,'192.168.20.0/24',4,'ACTIVE','private2');
 /*!40000 ALTER TABLE `IPAM_IP_POOL` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -57,11 +57,12 @@ CREATE TABLE `IPAM_IP_ASSIGNEMENT` (
   `service_instance_id` varchar(255) DEFAULT NULL,
   `vf_module_id` varchar(255) DEFAULT NULL,
   `prefix_id` varchar(255) DEFAULT NULL,
+  `external_key` 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` TEXT DEFAULT NULL,
   PRIMARY KEY (`ipam_ip_uuid`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -84,4 +85,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