Changeset 657


Ignore:
Timestamp:
Dec 18, 2014, 5:48:15 PM (7 years ago)
Author:
Kris Deugau
Message:

/trunk

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

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/cgi-bin/ipdb.psql

    r656 r657  
    3737CREATE TABLE "masterblocks" (
    3838        "cidr" cidr DEFAULT '255.255.255.255/32' NOT NULL PRIMARY KEY,
    39         "ctime" timestamp DEFAULT now(),
    40         "mtime" timestamp DEFAULT now(),
     39        "ctime" timestamp with time zone DEFAULT now(),
     40        "mtime" timestamp with time zone DEFAULT now(),
    4141        "rwhois" character(1) DEFAULT 'n' NOT NULL
    4242);
     
    4949        "maskbits" integer DEFAULT 128,
    5050        "city" character varying(30) DEFAULT '',
    51         "ctime" timestamp DEFAULT now()
     51        "ctime" timestamp with time zone DEFAULT now()
    5252);
    5353
     
    7777        "privdata" text DEFAULT '' NOT NULL,
    7878        "custid" character varying(16) DEFAULT '',
    79         "createstamp" timestamp DEFAULT now(),
    80         "modifystamp" timestamp DEFAULT now(),
     79        "createstamp" timestamp with time zone DEFAULT now(),
     80        "modifystamp" timestamp with time zone DEFAULT now(),
    8181        CHECK (((available = 'y'::bpchar) OR (available = 'n'::bpchar)))
    8282);
     
    9393        "maskbits" integer DEFAULT 128,
    9494        "circuitid" character varying(128) DEFAULT '',
    95         "createstamp" timestamp DEFAULT now(),
    96         "modifystamp" timestamp DEFAULT now(),
     95        "createstamp" timestamp with time zone DEFAULT now(),
     96        "modifystamp" timestamp with time zone DEFAULT now(),
    9797        "privdata" text DEFAULT '' NOT NULL,
    9898        "custid" character varying(16) DEFAULT '',
Note: See TracChangeset for help on using the changeset viewer.