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

1 files changed, 1 insertions, 1 deletions

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);