diff options
| -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, |