Changeset 219 for trunk/cgi-bin

Timestamp:

04/06/05 17:08:15 (20 years ago)

Author:

Kris Deugau

Message:

/trunk

Missed some tabledef changes in r218

File:

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

trunk/cgi-bin/ipdb.psql

@@ -23 +23 @@
 
 CREATE TABLE "masterblocks" (
-        "cidr" cidr DEFAULT '255.255.255.255/32' NOT NULL PRIMARY KEY
+        "cidr" cidr DEFAULT '255.255.255.255/32' NOT NULL PRIMARY KEY,
+        "ctime" timestamp DEFAULT now()
 );
 
@@ -33 +34 @@
         "cidr" cidr DEFAULT '255.255.255.255/32' NOT NULL PRIMARY KEY,
         "maskbits" integer DEFAULT 128,
-        "city" character varying(30) DEFAULT ''
+        "city" character varying(30) DEFAULT '',
+        "ctime" timestamp DEFAULT now()
 );