SF.net SVN: ledger-smb:[2983] addons/1.3/assets/trunk/sql/modules/Assets. sql

[..hidden..]

Revision: 2983
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2983&view=rev
Author:   einhverfr
Date:     2010-04-13 22:02:17 +0000 (Tue, 13 Apr 2010)

Log Message:
-----------
Fixing typos that cause script to go haywire.....

Modified Paths:
--------------
    addons/1.3/assets/trunk/sql/modules/Assets.sql

Modified: addons/1.3/assets/trunk/sql/modules/Assets.sql
===================================================================
--- addons/1.3/assets/trunk/sql/modules/Assets.sql	2010-04-13 21:42:59 UTC (rev 2982)
+++ addons/1.3/assets/trunk/sql/modules/Assets.sql	2010-04-13 22:02:17 UTC (rev 2983)
@@ -526,7 +526,7 @@
      FROM asset_item ai
      JOIN asset_class ac ON (ai.asset_class = ac.id)
      JOIN asset_dep_method adm ON (adm.id = ac.dep_method)
-LEFT JOIN asset_report_line rl ON (ai.id = rl.asset_id),
+LEFT JOIN asset_report_line rl ON (ai.id = rl.asset_id)
 LEFT JOIN asset_report r on (rl.report_id = r.id)
  GROUP BY ai.id, ai.tag, ai.description, ai.start_depreciation, ai.purchase_date,
           adm.short_label, ai.usable_life, ai.purchase_value
@@ -534,8 +534,6 @@
  ORDER BY ai.id, ai.tag, ai.description;
 $$ language sql;
       
-$$ language sql;
-
 CREATE TYPE partial_disposal_line AS (
 id int,
 tag text,


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