SF.net SVN: ledger-smb:[5968] trunk/sql/modules

[..hidden..]

Revision: 5968
          http://sourceforge.net/p/ledger-smb/code/5968
Author:   einhverfr
Date:     2013-08-24 10:47:49 +0000 (Sat, 24 Aug 2013)
Log Message:
-----------
fixing some database stored procedure load issues, there are still too many warnings that need to be addressed

Modified Paths:
--------------
    trunk/sql/modules/Fixes.sql
    trunk/sql/modules/Goods.sql
    trunk/sql/modules/PNL.sql

Modified: trunk/sql/modules/Fixes.sql
===================================================================
--- trunk/sql/modules/Fixes.sql	2013-08-24 10:35:06 UTC (rev 5967)
+++ trunk/sql/modules/Fixes.sql	2013-08-24 10:47:49 UTC (rev 5968)
@@ -111,7 +111,7 @@
 
 BEGIN;
 
-ALTER TABLE payrol_deduction_class ADD stored_proc_name name not null;
+ALTER TABLE payroll_deduction_class ADD stored_proc_name name not null;
 
 COMMIT;
 

Modified: trunk/sql/modules/Goods.sql
===================================================================
--- trunk/sql/modules/Goods.sql	2013-08-24 10:35:06 UTC (rev 5967)
+++ trunk/sql/modules/Goods.sql	2013-08-24 10:47:49 UTC (rev 5968)
@@ -173,6 +173,7 @@
 
 --- INVENTORY ADJUSTMENT LOGIC
 
+DROP TYPE part_at_date IF EXISTS;
 CREATE TYPE part_at_date AS (
   parts_id int,
   partnumber text,

Modified: trunk/sql/modules/PNL.sql
===================================================================
--- trunk/sql/modules/PNL.sql	2013-08-24 10:35:06 UTC (rev 5967)
+++ trunk/sql/modules/PNL.sql	2013-08-24 10:47:49 UTC (rev 5968)
@@ -55,7 +55,7 @@
           AND l.description = 'IC_expense'
           AND ($4 is null or $4 = '{}' OR in_tree($4, bu_ids))
  GROUP BY a.id, a.accno, a.description, a.category, ah.id, ah.accno,
-          ah.description
+          ah.description, at.path
     UNION
    SELECT a.id, a.accno, a.description, a.category, ah.id, ah.accno,
           ah.description, 
@@ -77,7 +77,7 @@
           AND ar.approved
           AND ($4 is null or $4 = '{}' OR in_tree($4, bu_ids))
  GROUP BY a.id, a.accno, a.description, a.category, ah.id, ah.accno,
-          ah.description
+          ah.description, at.path
 $$ language SQL;
 
 
@@ -123,7 +123,7 @@
                                    HAVING max(trans_id) = gl.id))
               )
  GROUP BY a.id, a.accno, a.description, a.category, 
-          ah.id, ah.accno, ah.description
+          ah.id, ah.accno, ah.description, at.path
  ORDER BY a.category DESC, a.accno ASC;
 $$ LANGUAGE SQL;
 
@@ -173,7 +173,7 @@
                                    HAVING max(trans_id) = gl.id))
               )
  GROUP BY a.id, a.accno, a.description, a.category, 
-          ah.id, ah.accno, ah.description
+          ah.id, ah.accno, ah.description, at.path
  ORDER BY a.category DESC, a.accno ASC;
 $$ LANGUAGE SQL;
 
@@ -214,7 +214,7 @@
           AND ($3 IS NULL OR ac.transdate <= $3)
           AND a.category IN ('I', 'E')
  GROUP BY a.id, a.accno, a.description, a.category, 
-          ah.id, ah.accno, ah.description
+          ah.id, ah.accno, ah.description, at.path
  ORDER BY a.category DESC, a.accno ASC;
 $$ LANGUAGE SQL;
 
@@ -229,7 +229,7 @@
   JOIN account_heading_tree at ON a.heading = at.id
  WHERE ac.approved AND ac.trans_id = $1 AND a.category IN ('I', 'E')
  GROUP BY a.id, a.accno, a.description, a.category, 
-          ah.id, ah.accno, ah.description
+          ah.id, ah.accno, ah.description, at.path
  ORDER BY a.category DESC, a.accno ASC;
 $$ LANGUAGE SQL;
 

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


------------------------------------------------------------------------------
Introducing Performance Central, a new site from SourceForge and 
AppDynamics. Performance Central is your source for news, insights, 
analysis and resources for efficient Application Performance Management. 
Visit us today!
http://pubads.g.doubleclick.net/gampad/clk?id=48897511&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits