From 008b9b5a2d1242df0d88e4ff2eed2e7918852767 Mon Sep 17 00:00:00 2001 From: Eric Leblond Date: Wed, 1 Aug 2012 11:27:14 +0000 Subject: pgsql schema: fix timestamp default value Set timestamp default value to now() not now which is the time at table creation. Reported-by: Mr Dash Four Signed-off-by: Eric Leblond Signed-off-by: Pablo Neira Ayuso --- doc/pgsql-ulogd2.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/doc/pgsql-ulogd2.sql b/doc/pgsql-ulogd2.sql index 0fc2b45..dc954ed 100644 --- a/doc/pgsql-ulogd2.sql +++ b/doc/pgsql-ulogd2.sql @@ -62,7 +62,7 @@ CREATE TABLE ulog2 ( ip_fragoff smallint default NULL, label smallint default NULL, mac_id bigint default NULL, - timestamp timestamp NOT NULL default 'now' + timestamp timestamp NOT NULL default now() ) WITH (OIDS=FALSE); CREATE INDEX ulog2_oob_family ON ulog2(oob_family); -- cgit v1.2.3