Changeset 394 for branches/stable/cgi-bin/ipdb.psql

Timestamp:

02/19/10 13:10:34 (14 years ago)

Author:

Kris Deugau

Message:

/branches/stable

Basic support for network node references: Add, view, edit nodes and

referencess

Probably excludes a bunch of real use-cases for various reasons

File:

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

branches/stable/cgi-bin/ipdb.psql

@@ -212 +212 @@
 );
 
+-- 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
+);