From 83ee58d1a333549b4dfc4177d095017e8f155a5c Mon Sep 17 00:00:00 2001 From: tetragon Date: Wed, 31 Oct 2007 22:52:03 +0000 Subject: 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 --- sql/Pg-database.sql | 4 ++-- 1 file 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, -- cgit v1.2.3