mysql> select * from ipallocations where port_id='ae22c84b-22a9-4618-b046-1eb61379bcea';
+--------------------------------------+---------------+--------------------------------------+--------------------------------------+
| port_id | ip_address | subnet_id | network_id |
+--------------------------------------+---------------+--------------------------------------+--------------------------------------+
| ae22c84b-22a9-4618-b046-1eb61379bcea | 172.20.59.132 | 3b040206-4adc-487e-9b9b-177b93374fdb | af6ef793-5430-4fa9-a2ea-6751d721e00b |
+--------------------------------------+---------------+--------------------------------------+--------------------------------------+
1 row in set (0.00 sec)
mysql> update ipallocations set ip_address='172.20.59.132' where port_id='ae22c84b-22a9-4618-b046-1eb61379bcea';
+--------------------------------------+--------+-------------------+--------------------------------------------------------------------------------------+
| id | name | mac_address | fixed_ips |
+--------------------------------------+--------+-------------------+--------------------------------------------------------------------------------------+
| 1cecaa46-8122-46e7-bd16-698e2fa43efe | | fa:16:3e:c3:fd:69 | {"subnet_id": "3b040206-4adc-487e-9b9b-177b93374fdb", "ip_address": "172.20.59.131"} |
| 29b851cd-cdee-407d-a75a-d0bc7e3346d1 | | fa:16:3e:dc:e8:af | {"subnet_id": "3b040206-4adc-487e-9b9b-177b93374fdb", "ip_address": "172.20.59.134"} |
| 61e30821-972a-4a83-a3ab-e53802d457ef | | fa:16:3e:53:ba:fc | {"subnet_id": "3b040206-4adc-487e-9b9b-177b93374fdb", "ip_address": "172.20.59.133"} |
| 87462fba-ffce-4544-9bec-413c382baeda | | fa:16:3e:5b:0b:9a | {"subnet_id": "3b040206-4adc-487e-9b9b-177b93374fdb", "ip_address": "172.20.59.135"} |
| a7aaaac1-0473-4c72-822f-2370d7d164b4 | port-1 | fa:16:3e:14:c4:49 | {"subnet_id": "3b040206-4adc-487e-9b9b-177b93374fdb", "ip_ad