Changeset 657 for trunk

Timestamp:

12/18/14 17:48:15 (9 years ago)

Author:

Kris Deugau

Message:

/trunk

Initial SQL cleanup continued; timestamp sematics got mangled and lost somewhere.

File:

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

trunk/cgi-bin/ipdb.psql

@@ -37 +37 @@
 CREATE TABLE "masterblocks" (
         "cidr" cidr DEFAULT '255.255.255.255/32' NOT NULL PRIMARY KEY,
-        "ctime" timestamp DEFAULT now(),
-        "mtime" timestamp DEFAULT now(),
+        "ctime" timestamp with time zone DEFAULT now(),
+        "mtime" timestamp with time zone DEFAULT now(),
         "rwhois" character(1) DEFAULT 'n' NOT NULL
 );
@@ -49 +49 @@
         "maskbits" integer DEFAULT 128,
         "city" character varying(30) DEFAULT '',
-        "ctime" timestamp DEFAULT now()
+        "ctime" timestamp with time zone DEFAULT now()
 );
 
@@ -77 +77 @@
         "privdata" text DEFAULT '' NOT NULL,
         "custid" character varying(16) DEFAULT '',
-        "createstamp" timestamp DEFAULT now(),
-        "modifystamp" timestamp DEFAULT now(),
+        "createstamp" timestamp with time zone DEFAULT now(),
+        "modifystamp" timestamp with time zone DEFAULT now(),
         CHECK (((available = 'y'::bpchar) OR (available = 'n'::bpchar)))
 );
@@ -93 +93 @@
         "maskbits" integer DEFAULT 128,
         "circuitid" character varying(128) DEFAULT '',
-        "createstamp" timestamp DEFAULT now(),
-        "modifystamp" timestamp DEFAULT now(),
+        "createstamp" timestamp with time zone DEFAULT now(),
+        "modifystamp" timestamp with time zone DEFAULT now(),
         "privdata" text DEFAULT '' NOT NULL,
         "custid" character varying(16) DEFAULT '',