summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorDan Timoney <dt5972@att.com>2018-08-24 19:35:00 +0000
committerGerrit Code Review <gerrit@onap.org>2018-08-24 19:35:00 +0000
commit724551253283f7869d50a671e07d70004e46089f (patch)
tree00eed982ee4dc9657b998cc0f5bf85cb4d02f89b
parent86e80c04c95894e275363ac2a59c673f0444b225 (diff)
parent193bd8c4faff834c51c242dc353058413ceecba1 (diff)
Merge "Update SQL dump for IPAM tables"
Former-commit-id: 0b84e06308b58d0308f40755b112cd730132b569
-rw-r--r--installation/sdnc/src/main/resources/ipam.data.dump10
1 files changed, 5 insertions, 5 deletions
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