Changeset 792 for trunk/cgi-bin

Timestamp:

12/16/15 17:40:11 (10 years ago)

Author:

Kris Deugau

Message:

/trunk

Tweak 2.7->3.0 SQL update to extend the description field on poolips
and allocations per request

File:

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

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

@@ -63 +63 @@
 -- move pool IPs into the allocations table;  we'll see.
 DROP VIEW searchme;
+-- do these here, because we can't do them while the view is defined
+ALTER TABLE allocations ALTER COLUMN description TYPE varchar(128);
+ALTER TABLE poolips ALTER COLUMN description TYPE varchar(128);
 CREATE VIEW "searchme" AS
     SELECT allocations.cidr, allocations.custid, allocations."type", allocations.city,