Changeset 280 for branches/privdata/cgi-bin/ipdb.psql

Timestamp:

09/16/05 17:21:57 (19 years ago)

Author:

Kris Deugau

Message:

/branches/privdata

Add support for editing/viewing "private"/restricted-access
data field for allocations and static IPs.

New ACL entry: s for systems/networking

SQL tabledefs updated.

File:

• branches/privdata/cgi-bin/ipdb.psql (modified) (2 diffs)

branches/privdata/cgi-bin/ipdb.psql

@@ -71 +71 @@
         "description" character varying(64) DEFAULT '' NOT NULL,
         "circuitid" character varying(128) DEFAULT '' NOT NULL,
+        "privdata" text DEFAULT '' NOT NULL,
         "newcustid" integer,
         "createstamp" timestamp DEFAULT now(),
@@ -92 +93 @@
         "createstamp" timestamp DEFAULT now(),
         "modifystamp" timestamp DEFAULT now(),
+        "privdata" text DEFAULT '' NOT NULL,
         "newcustid" integer
 );