diff options
| author | tetragon <tetragon@4979c152-3d1c-0410-bac9-87ea11338e46> | 2007-10-31 22:52:03 +0000 |
|---|---|---|
| committer | tetragon <tetragon@4979c152-3d1c-0410-bac9-87ea11338e46> | 2007-10-31 22:52:03 +0000 |
| commit | 83ee58d1a333549b4dfc4177d095017e8f155a5c (patch) | |
| tree | 2c8bfc52a2f45221c75b872403a1feea24002584 | |
| parent | dbf1efaa612d24c3f3520a75de0155ca698b8673 (diff) | |
Converting the two left-over float4 fields to numeric
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1832 4979c152-3d1c-0410-bac9-87ea11338e46
| -rw-r--r-- | sql/Pg-database.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/sql/Pg-database.sql b/sql/Pg-database.sql index 813591e2..2e5252c4 100644 --- a/sql/Pg-database.sql +++ b/sql/Pg-database.sql @@ -382,7 +382,7 @@ CREATE TABLE invoice ( allocated integer, sellprice NUMERIC, fxsellprice NUMERIC, - discount float4, -- jd: check into this + discount numeric, assemblyitem bool DEFAULT 'f', unit varchar(5), project_id int, @@ -550,7 +550,7 @@ CREATE TABLE parts ( makemodel bool DEFAULT 'f', assembly bool DEFAULT 'f', alternate bool DEFAULT 'f', - rop float4, -- jd: what is this + rop numeric, -- SC: ReOrder Point inventory_accno_id int, income_accno_id int, expense_accno_id int, |