Changeset 807

Timestamp:

03/08/16 13:05:06 (9 years ago)

Author:

Kris Deugau

Message:

/trunk

Roll up SQL definition updates

• extend length of description field on allocations and poolips
• create VRF table

Location:

trunk/cgi-bin

Files:

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

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

@@ -26 +26 @@
     bkip inet
 );
+
+-- VRFs are now the apex entity
+CREATE TABLE vrfs (
+    vrf varchar(32) DEFAULT '' NOT NULL,
+    comment text DEFAULT '' NOT NULL,
+    location varchar(4) DEFAULT '' NOT NULL
+);
+
+ALTER TABLE ONLY vrfs
+    ADD CONSTRAINT vrfs_pkey PRIMARY KEY (vrf);
+
+-- need a default VRF to stuff everything into to start with
+INSERT INTO vrfs (vrf,comment) VALUES ('DEFAULT','Initial default VRF');
 
 -- Master and routed blocks now live in the allocations table.

trunk/cgi-bin/ipdb.psql

@@ -20 +20 @@
     "type" character(2) DEFAULT ''::bpchar,
     city character varying(30) DEFAULT ''::character varying,
-    description character varying(64) DEFAULT ''::character varying,
+    description character varying(128) DEFAULT ''::character varying,
     notes text DEFAULT ''::text,
     maskbits integer DEFAULT 128,
@@ -125 +125 @@
     available character(1) DEFAULT 'y'::bpchar NOT NULL,
     notes text DEFAULT ''::text NOT NULL,
-    description character varying(64) DEFAULT ''::character varying NOT NULL,
+    description character varying(128) DEFAULT ''::character varying NOT NULL,
     circuitid character varying(128) DEFAULT ''::character varying NOT NULL,
     privdata text DEFAULT ''::text NOT NULL,