Changeset 865

Timestamp:

04/29/16 17:14:46 (10 years ago)

Author:

Kris Deugau

Message:

/trunk

Further refine new install and 2.7-3.0 upgrade SQL to support multiple
copies of the same reverse zone in different VRFs that use different
DNS views. See #41.

Location:

trunk/cgi-bin

Files:

• ipdb-2.7-3.0.sql (modified) (1 diff)
• ipdb.psql (modified) (1 diff)

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

@@ -8 +8 @@
 -- Flag table for deciding if we can usefully do rDNS RPC calls.
 CREATE TABLE dnsavail (
-    "zone" cidr PRIMARY KEY,
+    "zone" cidr,
     "location" varchar(4) DEFAULT '',
     parent_alloc integer NOT NULL
 );
+
+ALTER TABLE ONLY dnsavail
+    ADD CONSTRAINT dnsavail_pkey PRIMARY KEY ("zone",parent_alloc);
 
 -- Store backup fields in a separate table

trunk/cgi-bin/ipdb.psql

@@ -79 +79 @@
 -- Flag table for deciding if we can usefully do rDNS RPC calls.
 CREATE TABLE dnsavail (
-    "zone" cidr PRIMARY KEY,
+    "zone" cidr,
     "location" varchar(4) DEFAULT '',
     parent_alloc integer NOT NULL
 );
+
+ALTER TABLE ONLY dnsavail
+    ADD CONSTRAINT dnsavail_pkey PRIMARY KEY ("zone",parent_alloc);
 
 -- Store backup fields in a separate table