diff options
| author | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2008-08-19 22:49:39 +0000 |
|---|---|---|
| committer | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2008-08-19 22:49:39 +0000 |
| commit | 8febc823cc4048735469e58c574bcb4d92c3cfc7 (patch) | |
| tree | d26c3d38439f819b08cc05774d77a85c1611aec7 /sql | |
| parent | a0f9f5cb278cf4283cd3fd3635a36c97b7de9bdd (diff) | |
Enhancements to notes and entity management:
* Default workflow only allows addresses connected to entity_credit_accounts
* Default workflow only allows contact info conntected to entity_credit_accounts
* Notes now display the Pgsql user that created them
* Notes are now displayed with linebreaks properly showing up.
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2282 4979c152-3d1c-0410-bac9-87ea11338e46
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); |