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

Timestamp:

01/02/15 17:26:32 (9 years ago)

Author:

Kris Deugau

Message:

/trunk

Minimally update search tool for new database layout. Still needs a major rewrite.

File:

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

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

@@ -32 +32 @@
 -- probably need some more indexes
 
+-- Need some additional fields to support search output.  Might arguably
+-- move pool IPs into the allocations table;  we'll see.
+DROP VIEW searchme;
+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
+    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
+    FROM poolips;
+
 -- Relabel a few types to match the new structure
 UPDATE alloctypes SET listname='Routing aggregation', dispname='Routing aggregation' WHERE type='rm';