Changeset 807 for trunk/cgi-bin/ipdb-2.7-3.0.sql

Timestamp:

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

Author:

Kris Deugau

Message:

/trunk

Roll up SQL definition updates

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

File:

• trunk/cgi-bin/ipdb-2.7-3.0.sql (modified) (1 diff)

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.