Changeset 762

Timestamp:

07/29/15 13:10:53 (9 years ago)

Author:

Kris Deugau

Message:

/trunk

Update 2.7 -> 3.0 SQL upgrade script

File:

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

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

@@ -5 +5 @@
 -- has run, IPDB v2.7 and older will NOT be able to properly manipulate
 -- the data!
+
+-- Flag table for deciding if we can usefully do rDNS RPC calls.
+CREATE TABLE dnsavail (
+    "zone" cidr PRIMARY KEY,
+    "location" varchar(2) DEFAULT '',
+    parent_alloc integer NOT NULL
+);
 
 -- Master and routed blocks now live in the allocations table.
@@ -15 +22 @@
 ALTER TABLE allocations DROP CONSTRAINT allocations_pkey;
 ALTER TABLE allocations ADD COLUMN id serial PRIMARY KEY;
+CREATE UNIQUE INDEX allocations_skey ON allocations (cidr,vrf,type);
 
 ALTER TABLE freeblocks ADD COLUMN vrf text NOT NULL DEFAULT '';
 ALTER TABLE freeblocks ADD COLUMN parent_id integer NOT NULL DEFAULT 0;
 ALTER TABLE freeblocks ADD COLUMN master_id integer NOT NULL DEFAULT 0;
+ALTER TABLE freeblocks ADD COLUMN reserve_for integer NOT NULL DEFAULT 0;
 ALTER TABLE freeblocks DROP CONSTRAINT freeblocks_pkey;
 ALTER TABLE freeblocks ADD CONSTRAINT freeblocks_pkey PRIMARY KEY ("cidr","parent_id");