diff options
author | Eric Leblond <eric@regit.org> | 2012-08-01 11:27:14 +0000 |
---|---|---|
committer | Pablo Neira Ayuso <pablo@netfilter.org> | 2012-08-03 11:25:31 +0200 |
commit | 008b9b5a2d1242df0d88e4ff2eed2e7918852767 (patch) | |
tree | 685cf86585f41a58cbd014f6ef114407cd580f6a /doc | |
parent | d9377e7ba22ec13a0c73785f86e5bcc869d1051f (diff) |
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 <mr.dash.four@googlemail.com>
Signed-off-by: Eric Leblond <eric@regit.org>
Signed-off-by: Pablo Neira Ayuso <pablo@netfilter.org>
Diffstat (limited to 'doc')
-rw-r--r-- | doc/pgsql-ulogd2.sql | 2 |
1 files changed, 1 insertions, 1 deletions
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); |