SF.net SVN: ledger-smb: [1832] trunk/sql/Pg-database.sql

[..hidden..]

Revision: 1832
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=1832&view=rev
Author:   tetragon
Date:     2007-10-31 15:52:03 -0700 (Wed, 31 Oct 2007)

Log Message:
-----------
Converting the two left-over float4 fields to numeric

Modified Paths:
--------------
    trunk/sql/Pg-database.sql

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2007-10-31 22:07:32 UTC (rev 1831)
+++ trunk/sql/Pg-database.sql	2007-10-31 22:52:03 UTC (rev 1832)
@@ -382,7 +382,7 @@
   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 @@
   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,


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.