diff options
Diffstat (limited to 'sql/Pg-database.sql')
| -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, |