Changeset 824 for trunk/cgi-bin/ipdb-2.7-3.0.sql

Timestamp:

03/31/16 18:00:41 (9 years ago)

Author:

Kris Deugau

Message:

/trunk

SQL update script update for updated search; includes master_id
in the searchme view

File:

• trunk/cgi-bin/ipdb-2.7-3.0.sql (modified) (1 diff)

trunk/cgi-bin/ipdb-2.7-3.0.sql

@@ -82 +82 @@
     SELECT allocations.cidr, allocations.custid, allocations."type", allocations.city, 
       allocations.description, allocations.notes, allocations.circuitid, allocations.vrf,
-      allocations.vlan, allocations.id, allocations.parent_id, 'n' AS available
+      allocations.vlan, allocations.id, allocations.parent_id, allocations.master_id, 'n' AS available
     FROM allocations
   UNION
     SELECT poolips.ip, poolips.custid, poolips.type, poolips.city,
       poolips.description, poolips.notes, poolips.circuitid, poolips.vrf,
-      poolips.vlan, poolips.id, poolips.parent_id, poolips.available
+      poolips.vlan, poolips.id, poolips.parent_id, poolips.master_id, poolips.available
     FROM poolips;