Changeset 779 for trunk

Timestamp:

10/07/15 17:58:42 (9 years ago)

Author:

Kris Deugau

Message:

/trunk

Begin adding configuration backup fields with the tabledef and link to
the allocations/poolips tables. See #52.

Also note an index for composite key that may not be useful

File:

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

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

@@ -13 +13 @@
 );
 
+-- 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,
+    ip inet
+);
+
 -- Master and routed blocks now live in the allocations table.
 
@@ -20 +34 @@
 ALTER TABLE allocations ADD COLUMN parent_id integer NOT NULL DEFAULT 0;
 ALTER TABLE allocations ADD COLUMN master_id integer NOT NULL DEFAULT 0;
+ALTER TABLE allocations ADD COLUMN backup_id integer NOT NULL DEFAULT 0;
 ALTER TABLE allocations DROP CONSTRAINT allocations_pkey;
 ALTER TABLE allocations ADD COLUMN id serial PRIMARY KEY;
+-- not certain this is right
 CREATE UNIQUE INDEX allocations_skey ON allocations (cidr,vrf,type);
 
@@ -37 +53 @@
 ALTER TABLE poolips ADD COLUMN parent_id integer NOT NULL DEFAULT 0;
 ALTER TABLE poolips ADD COLUMN master_id integer NOT NULL DEFAULT 0;
+ALTER TABLE poolips ADD COLUMN backup_id integer NOT NULL DEFAULT 0;
 ALTER TABLE poolips DROP CONSTRAINT poolips_pkey;
 ALTER TABLE poolips ADD COLUMN id serial;