From 300d8cd96f107bb962cf807005784c96197baa1f Mon Sep 17 00:00:00 2001 From: linuxpoet Date: Thu, 7 Jun 2007 01:38:03 +0000 Subject: fixed default of current_date to now() git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1259 4979c152-3d1c-0410-bac9-87ea11338e46 --- sql/Pg-database.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'sql') diff --git a/sql/Pg-database.sql b/sql/Pg-database.sql index 28bff22d..51589212 100644 --- a/sql/Pg-database.sql +++ b/sql/Pg-database.sql @@ -198,7 +198,7 @@ CREATE UNIQUE INDEX note_class_idx ON note_class(lower(class)); CREATE TABLE note (id serial primary key, note_class integer not null references note_class(id), note text not null, vector tsvector not null, - created timestamp not null default current_date); + created timestamp not null default now()); CREATE TABLE entity_note() INHERITS (note); ALTER TABLE entity_note ADD CHECK (id = 1); -- cgit v1.2.3