Changeset 804 for trunk/cgi-bin

Timestamp:

12/31/15 10:49:55 (9 years ago)

Author:

Kris Deugau

Message:

/trunk

Add VRF table to initial tabledef

File:

• trunk/cgi-bin/ipdb.psql (modified) (1 diff)

trunk/cgi-bin/ipdb.psql

@@ -2 +2 @@
 -- CREATE FUNCTION "plpgsql_call_handler" () RETURNS language_handler AS '$libdir/plpgsql' LANGUAGE C;
 -- CREATE TRUSTED LANGUAGE "plpgsql" HANDLER "plpgsql_call_handler";
+
+-- Table for VRF list
+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);
 
 -- Table for tracking active netblock assignments and containers.