mysql> select * from IP_Addresses
-> ;
+----+--------------+-----------------+--------+--------------------+-------------------+-------+-------+--------+---------------+
| id | ip_address | mask | iface | ssl_certificate_id | default_domain_id | ftps | main | status | serviceNodeId |
+----+--------------+-----------------+--------+--------------------+-------------------+-------+-------+--------+---------------+
| 1 | 72.10.37.143 | 255.255.255.255 | venet0 | 17 | 95 | false | true | 0 | 1 |
| 2 | 72.10.39.59 | 255.255.255.255 | venet0 | 15 | 96 | false | false | 0 | 1 |
| 5 | 72.10.37.139 | 255.255.255.255 | venet0 | 14 | 0 | false | false | 0 | 1 |
+----+--------------+-----------------+--------+--------------------+-------------------+-------+-------+--------+---------------+
3 rows in set (0.00 sec)
mysql> select * from ip_pool;
+----+---------------+--------+
| id | ip_address_id | type |
+----+---------------+--------+
| 1 | 1 | shared |
| 1 | 2 | shared |
| 1 | 4 | shared |
| 1 | 5 | shared |
| 2 | 1 | shared |
| 3 | 1 | shared |
| 4 | 1 | shared |
| 5 | 1 | shared |
| 8 | 5 | shared |
| 11 | 1 | shared |
| 13 | 1 | shared |
| 14 | 1 | shared |
| 25 | 1 | shared |
| 37 | 1 | shared |
| 38 | 1 | shared |
| 41 | 1 | shared |
| 63 | 1 | shared |
| 64 | 1 | shared |
| 65 | 1 | shared |
+----+---------------+--------+
19 rows in set (0.00 sec)
mysql> select * from IpAddressesCollections;
+----------------+-------------+
| ipCollectionId | ipAddressId |
+----------------+-------------+
| 1 | 1 |
| 26 | 1 |
| 42 | 1 |
| 43 | 1 |
| 63 | 5 |
| 64 | 5 |
| 82 | 5 |
| 83 | 5 |
| 86 | 5 |
| 87 | 5 |
| 93 | 1 |
| 94 | 1 |
| 95 | 1 |
| 96 | 1 |
| 97 | 1 |
| 98 | 1 |
| 102 | 1 |
| 103 | 1 |
| 106 | 5 |
| 107 | 5 |
| 126 | 5 |
| 127 | 5 |
| 128 | 1 |
| 129 | 1 |
| 130 | 1 |
| 131 | 1 |
| 156 | 1 |
| 157 | 1 |
| 183 | 1 |
| 184 | 1 |
| 187 | 1 |
| 188 | 1 |
| 189 | 1 |
| 190 | 1 |
| 191 | 2 |
| 192 | 2 |
| 197 | 1 |
| 198 | 1 |
| 241 | 1 |
| 242 | 1 |
| 243 | 1 |
| 244 | 1 |
| 245 | 1 |
| 246 | 1 |
+----------------+-------------+
44 rows in set (0.00 sec)