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

Timestamp:

05/10/10 17:33:13 (14 years ago)

Author:

Kris Deugau

Message:

/trunk

Merge basic node-tracking from r393:396 into trunk. See #13.

File:

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

trunk/cgi-bin/ipdb.psql

@@ -213 +213 @@
         "auto" character(1) DEFAULT 'y'
 );
+
+-- Network nodes - allows finding customers affected by a broken <x> quickly
+CREATE TABLE noderef (
+    block inet NOT NULL PRIMARY KEY,
+    node_id integer
+);
+
+CREATE TABLE nodes (
+    node_id serial NOT NULL PRIMARY KEY,
+    node_type character varying(2),
+    node_name character varying(40),
+    node_ip inet
+);