diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/Pg-database.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/sql/Pg-database.sql b/sql/Pg-database.sql index 3d2d3f75..102b9255 100644 --- a/sql/Pg-database.sql +++ b/sql/Pg-database.sql @@ -364,6 +364,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 now(), + created_by text DEFAULT SESSION_USER; ref_key integer not null); CREATE TABLE entity_note(entity_id int references entity(id)) INHERITS (note); |