diff options
| author | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2006-10-21 05:30:50 +0000 |
|---|---|---|
| committer | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2006-10-21 05:30:50 +0000 |
| commit | 66cfba2b600db93db64378a582c5bfebf1d66a6c (patch) | |
| tree | 9474501b37eeca73bb58547410d471fc0578fdec /sql | |
| parent | 350810c40185af41e75b53fe90fc12afe137047c (diff) | |
Modified parsing to return undef on empty string.
Modified CT to use 0 credit limit if none provided.
Added On Hand column to invoices.
Dropped foreign key constrant on acc_trans.trans_id due to limitations in current API (will be in a future version).
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@250 4979c152-3d1c-0410-bac9-87ea11338e46
Diffstat (limited to 'sql')
| -rwxr-xr-x | sql/Pg-tables.sql | 2 | ||||
| -rw-r--r-- | sql/Pg-upgrade-2.6.18-2.6.19.sql | 2 |
2 files changed, 1 insertions, 3 deletions
diff --git a/sql/Pg-tables.sql b/sql/Pg-tables.sql index 32dffb9a..59e60248 100755 --- a/sql/Pg-tables.sql +++ b/sql/Pg-tables.sql @@ -78,7 +78,7 @@ CREATE TABLE defaults ( ); -- CREATE TABLE acc_trans ( - trans_id int REFERENCES transactions(id), + trans_id int, chart_id int NOT NULL REFERENCES chart (id), amount NUMERIC, transdate date DEFAULT current_date, diff --git a/sql/Pg-upgrade-2.6.18-2.6.19.sql b/sql/Pg-upgrade-2.6.18-2.6.19.sql index d8e304f3..b60aadac 100644 --- a/sql/Pg-upgrade-2.6.18-2.6.19.sql +++ b/sql/Pg-upgrade-2.6.18-2.6.19.sql @@ -1,5 +1,3 @@ -ALTER TABLE acc_trans ADD FOREIGN KEY (trans_id) REFERENCES transactions (id); - ALTER TABLE ap ADD PRIMARY KEY (id); ALTER TABLE ar ADD PRIMARY KEY (id); |