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

Timestamp:

04/06/05 17:06:28 (19 years ago)

Author:

Kris Deugau

Message:

/trunk

Updated SQL tabledefs with timestamps for master block, routed

block, allocation, and static IP "creation" times; also
allocation and static IP modification times.

Updated db2rwhois.pl with timestamp support and a little code cleanup.

File:

• trunk/cgi-bin/ipdb.psql (modified) (3 diffs)

trunk/cgi-bin/ipdb.psql

@@ -70 +70 @@
         "circuitid" character varying(128) DEFAULT '' NOT NULL,
         "newcustid" integer,
+        "createstamp" timestamp DEFAULT now(),
+        "modifystamp" timestamp DEFAULT now(),
         CHECK (((available = 'y'::bpchar) OR (available = 'n'::bpchar)))
 );
@@ -86 +88 @@
         "maskbits" integer DEFAULT 128,
         "circuitid" character varying(128) DEFAULT '',
+        "createstamp" timestamp DEFAULT now(),
+        "modifystamp" timestamp DEFAULT now(),
         "newcustid" integer
 );
@@ -182 +186 @@
 pr      Dynamic-route DSL netblock      Dynamic-route DSL       203     
 \.
+
+--
+-- Trigger and matching function to update modifystamp on allocations, poolips
+--
+CREATE FUNCTION up_modtime () RETURNS OPAQUE AS '
+    BEGIN
+        NEW.modifystamp := ''now'';
+        RETURN NEW;
+    END;
+' LANGUAGE 'plpgsql';
+
+CREATE TRIGGER up_modtime BEFORE UPDATE ON allocations
+    FOR EACH ROW EXECUTE PROCEDURE up_modtime();
+
+CREATE TRIGGER up_modtime BEFORE UPDATE ON poolips
+    FOR EACH ROW EXECUTE PROCEDURE up_modtime();