SF.net SVN: ledger-smb:[3995] branches/1.3/sql/upgrade/1. 2-pre-upgrade-checks.sql

[..hidden..]

Revision: 3995
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3995&view=rev
Author:   tshvr
Date:     2011-11-13 18:33:31 +0000 (Sun, 13 Nov 2011)
Log Message:
-----------
add more checks

Modified Paths:
--------------
    branches/1.3/sql/upgrade/1.2-pre-upgrade-checks.sql

Modified: branches/1.3/sql/upgrade/1.2-pre-upgrade-checks.sql
===================================================================
--- branches/1.3/sql/upgrade/1.2-pre-upgrade-checks.sql	2011-11-13 17:15:18 UTC (rev 3994)
+++ branches/1.3/sql/upgrade/1.2-pre-upgrade-checks.sql	2011-11-13 18:33:31 UTC (rev 3995)
@@ -1,3 +1,6 @@
+--tshvr use lsmb12 if 1.2 db public schema has already been renamed to lsmb12
+SET search_path = lsmb12, public, pg_catalog;
+
 SELECT count(*), customernumber from customer
 GROUP BY customernumber
 HAVING count(*) > 1;
@@ -20,4 +23,9 @@
 
 SELECT invnumber, count(*) from ar
 group by invnumber having count(*) > 1;
+SELECT invnumber, count(*) from ap group by invnumber having count(*) > 1;
 
+SELECT trans_id,count(trans_id) FROM acc_trans where trans_id not in (select id from ap union select id from ar union select id from gl) group by trans_id;
+SELECT trans_id,count(trans_id) FROM invoice where trans_id not in (select id from ap union select id from ar union select id from gl) group by trans_id;
+
+select setting_key,value from defaults where setting_key='curr';

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