SF.net SVN: ledger-smb:[2950] addons/1.3/templatetrans/trunk/sql/modules/ trans-tables.sql

[..hidden..]

Revision: 2950
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2950&view=rev
Author:   einhverfr
Date:     2010-03-07 05:25:47 +0000 (Sun, 07 Mar 2010)

Log Message:
-----------
Correcting syntax errors on table definitions

Modified Paths:
--------------
    addons/1.3/templatetrans/trunk/sql/modules/trans-tables.sql

Modified: addons/1.3/templatetrans/trunk/sql/modules/trans-tables.sql
===================================================================
--- addons/1.3/templatetrans/trunk/sql/modules/trans-tables.sql	2010-03-05 17:33:13 UTC (rev 2949)
+++ addons/1.3/templatetrans/trunk/sql/modules/trans-tables.sql	2010-03-07 05:25:47 UTC (rev 2950)
@@ -76,25 +76,25 @@
 PRIMARY KEY  (journal_id)
 );
 
--- CREATE TABLE order_line ( -- replaces invoice and order_item
---entry_id serial not null unique,
---parts_id int references parts(id),
---quantity numeric not null check (quantity <> 'NaN'),
---lot_price numeric not null check (quantity <> 'NaN'),
---allocated numeric not null check (allocated <> 'NaN' AND
---abs(allocated) < abs(quantity)),
---allocated_price numeric not null check(allocated_price <> 'NaN' AND
---abs(allocated_price) < abs(lot_price), -- tracking allocated prices
+CREATE TABLE order_line ( -- replaces invoice and order_item
+entry_id serial not null unique,
+parts_id int references parts(id),
+quantity numeric not null check (quantity <> 'NaN'),
+lot_price numeric not null check (quantity <> 'NaN'),
+allocated numeric not null check (allocated <> 'NaN' AND
+abs(allocated) < abs(quantity)),
+allocated_price numeric not null check(allocated_price <> 'NaN' AND
+abs(allocated_price) < abs(lot_price)), -- tracking allocated prices
                                        --separately so that we can handle 
                                        -- purchase quantities in intelligeable
                                        -- ways.
---lot_size numeric not null check (lot_size <> 'NaN'),
---lot_qty numeric not null check (lot_qtty <> 'NaN'),
---displayed_sku text not null,
---displayed_description text not null
---);
+lot_size numeric not null check (lot_size <> 'NaN'),
+lot_qty numeric not null check (lot_qty <> 'NaN'),
+displayed_sku text not null,
+displayed_description text not null
+);
 
---CREATE TABLE forex_order_line (
---entry_id int not null primary key references order_line(entry_id),
---fx_lot_price numeric not null ot null check (fx_lot_price <> 'NaN')
---);
+CREATE TABLE forex_order_line (
+entry_id int primary key references order_line(entry_id),
+fx_lot_price numeric not null not null check (fx_lot_price <> 'NaN')
+);


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