Changeset 864 for trunk/cgi-bin/ipdb.psql

Timestamp:

04/29/16 13:25:18 (9 years ago)

Author:

Kris Deugau

Message:

/trunk

Refine initial database creation script based on correct-in-production
2.7-3.0 upgrade. Still arguably some things wrong with GRANTs, but those
are more artifacts of legacy dumps.

File:

• trunk/cgi-bin/ipdb.psql (modified) (5 diffs)

trunk/cgi-bin/ipdb.psql

@@ -9 +9 @@
     location varchar(4) DEFAULT '' NOT NULL
 );
+
+COPY vrfs (vrf, comment, location) FROM stdin;
+DEFAULT Initial default VRF     
+\.
 
 ALTER TABLE ONLY vrfs
@@ -34 +38 @@
     parent_id integer DEFAULT 0 NOT NULL,
     master_id integer DEFAULT 0 NOT NULL,
+    backup_id integer DEFAULT 0 NOT NULL,
     id serial NOT NULL
 );
@@ -75 +80 @@
 CREATE TABLE dnsavail (
     "zone" cidr PRIMARY KEY,
-    "location" varchar(2) DEFAULT '',
+    "location" varchar(4) DEFAULT '',
     parent_alloc integer NOT NULL
+);
+
+-- Store backup fields in a separate table
+CREATE TABLE backuplist (
+    backup_id serial NOT NULL,
+    bkbrand text,
+    bkmodel text,
+    bktype text,
+    bkport integer,
+    bksrc text,
+    bkuser text,
+    bkvpass text,
+    bkepass text,
+    bkip inet
 );
 
@@ -136 +155 @@
     parent_id integer DEFAULT 0 NOT NULL,
     master_id integer DEFAULT 0 NOT NULL,
+    backup_id integer DEFAULT 0 NOT NULL,
     id serial NOT NULL,
     CONSTRAINT poolips_available_check CHECK (((available = 'y'::bpchar) OR (available = 'n'::bpchar)))
@@ -148 +168 @@
     SELECT allocations.cidr, allocations.custid, allocations."type", allocations.city,
       allocations.description, allocations.notes, allocations.circuitid, allocations.vrf,
-      allocations.vlan, allocations.id, allocations.parent_id, 'n' AS available
+      allocations.vlan, allocations.id, allocations.parent_id, allocations.master_id, 'n' AS available
     FROM allocations
   UNION
     SELECT poolips.ip AS cidr, poolips.custid, poolips."type", poolips.city,
       poolips.description, poolips.notes, poolips.circuitid, poolips.vrf,
-      poolips.vlan, poolips.id, poolips.parent_id, poolips.available
+      poolips.vlan, poolips.id, poolips.parent_id, poolips.master_id, poolips.available
     FROM poolips;