diff options
| author | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2007-07-16 18:43:55 +0000 |
|---|---|---|
| committer | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2007-07-16 18:43:55 +0000 |
| commit | bed3e5383fb0415a2418839c3be7dd8ae0eea46e (patch) | |
| tree | 1d1cf070def0a7130ddca7d62b40621f3713dd5a | |
| parent | 33011978ad667459add6b35890d92422b07d7983 (diff) | |
Adding foreign key to acc_trans.trans_id
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1406 4979c152-3d1c-0410-bac9-87ea11338e46
| -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 bcd6ce5d..deaf3f5a 100644 --- a/sql/Pg-database.sql +++ b/sql/Pg-database.sql @@ -368,7 +368,7 @@ projectnumber|1 \. -- */ CREATE TABLE acc_trans ( - trans_id int, + trans_id int NOT NULL REFERENCES transactions(id), chart_id int NOT NULL REFERENCES chart (id), amount NUMERIC, transdate date DEFAULT current_date, |