diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/Pg-database.sql | 2 |
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); |