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

Timestamp:

02/06/15 17:42:26 (9 years ago)

Author:

Kris Deugau

Message:

/trunk

Expose VRF field, and add a similar VLAN field (see #10).

File:

• trunk/cgi-bin/ipdb-2.7-3.0.sql (modified) (3 diffs)

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

@@ -9 +9 @@
 
 ALTER TABLE allocations ADD COLUMN vrf text NOT NULL DEFAULT '';
+ALTER TABLE allocations ADD COLUMN vlan text NOT NULL DEFAULT '';
 ALTER TABLE allocations ADD COLUMN rdns text NOT NULL DEFAULT '';
 ALTER TABLE allocations ADD COLUMN parent_id integer NOT NULL DEFAULT 0;
@@ -23 +24 @@
 
 ALTER TABLE poolips ADD COLUMN vrf text NOT NULL DEFAULT '';
+ALTER TABLE poolips ADD COLUMN vlan text NOT NULL DEFAULT '';
 ALTER TABLE poolips ADD COLUMN rdns text NOT NULL DEFAULT '';
 ALTER TABLE poolips ADD COLUMN parent_id integer NOT NULL DEFAULT 0;
@@ -37 +39 @@
 CREATE VIEW "searchme" AS
     SELECT allocations.cidr, allocations.custid, allocations."type", allocations.city, 
-      allocations.description, allocations.notes, allocations.circuitid, allocations.id,
-      allocations.parent_id, 'n' AS available
+      allocations.description, allocations.notes, allocations.circuitid, allocations.vrf,
+      allocations.vlan, allocations.id, allocations.parent_id, 'n' AS available
     FROM allocations
   UNION
     SELECT poolips.ip, poolips.custid, poolips.type, poolips.city,
-      poolips.description, poolips.notes, poolips.circuitid, poolips.id,
-      poolips.parent_id, poolips.available
+      poolips.description, poolips.notes, poolips.circuitid, poolips.vrf,
+      poolips.vlan, poolips.id, poolips.parent_id, poolips.available
     FROM poolips;