SF.net SVN: ledger-smb:[5128] branches/1.3/sql/upgrade

[..hidden..]

Revision: 5128
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=5128&view=rev
Author:   einhverfr
Date:     2012-09-22 09:06:52 +0000 (Sat, 22 Sep 2012)
Log Message:
-----------
Correcting error updating with multiple email addresses per customer or vendor

Modified Paths:
--------------
    branches/1.3/sql/upgrade/1.2-1.3-manual.sql
    branches/1.3/sql/upgrade/1.2-1.3.sql

Modified: branches/1.3/sql/upgrade/1.2-1.3-manual.sql
===================================================================
--- branches/1.3/sql/upgrade/1.2-1.3-manual.sql	2012-09-06 09:50:34 UTC (rev 5127)
+++ branches/1.3/sql/upgrade/1.2-1.3-manual.sql	2012-09-22 09:06:52 UTC (rev 5128)
@@ -128,13 +128,13 @@
        and v.email ~ '[[:alnum:]_]'::text 
 group by v.credit_id, v.email
 UNION
-select v.credit_id, 12, v.cc, 'Carbon Copy email address' as description 
+select v.credit_id, 13, v.cc, 'Carbon Copy email address' as description 
 from lsmb12.vendor v 
 where v.company_id is not null and v.cc is not null 
       and v.cc ~ '[[:alnum:]_]'::text 
 group by v.credit_id, v.cc
 UNION 
-select v.credit_id, 12, v.bcc, 'Blind Carbon Copy email address' as description 
+select v.credit_id, 14, v.bcc, 'Blind Carbon Copy email address' as description 
 from lsmb12.vendor v 
 where v.company_id is not null and v.bcc is not null 
        and v.bcc ~ '[[:alnum:]_]'::text 
@@ -160,13 +160,13 @@
        and v.email ~ '[[:alnum:]_]'::text 
 group by v.credit_id, v.email
 UNION
-select v.credit_id, 12, v.cc, 'Carbon Copy email address' as description 
+select v.credit_id, 13, v.cc, 'Carbon Copy email address' as description 
 from lsmb12.customer v 
 where v.company_id is not null and v.cc is not null 
       and v.cc ~ '[[:alnum:]_]'::text 
 group by v.credit_id, v.cc
 UNION 
-select v.credit_id, 12, v.bcc, 'Blind Carbon Copy email address' as description 
+select v.credit_id, 14, v.bcc, 'Blind Carbon Copy email address' as description 
 from lsmb12.customer v 
 where v.company_id is not null and v.bcc is not null 
        and v.bcc ~ '[[:alnum:]_]'::text 

Modified: branches/1.3/sql/upgrade/1.2-1.3.sql
===================================================================
--- branches/1.3/sql/upgrade/1.2-1.3.sql	2012-09-06 09:50:34 UTC (rev 5127)
+++ branches/1.3/sql/upgrade/1.2-1.3.sql	2012-09-22 09:06:52 UTC (rev 5128)
@@ -106,13 +106,13 @@
        and v.email ~ '[[:alnum:]_]'::text 
 group by v.credit_id, v.email
 UNION
-select v.credit_id, 12, v.cc, 'Carbon Copy email address' as description 
+select v.credit_id, 13, v.cc, 'Carbon Copy email address' as description 
 from lsmb12.vendor v 
 where v.company_id is not null and v.cc is not null 
       and v.cc ~ '[[:alnum:]_]'::text 
 group by v.credit_id, v.cc
 UNION 
-select v.credit_id, 12, v.bcc, 'Blind Carbon Copy email address' as description 
+select v.credit_id, 14, v.bcc, 'Blind Carbon Copy email address' as description 
 from lsmb12.vendor v 
 where v.company_id is not null and v.bcc is not null 
        and v.bcc ~ '[[:alnum:]_]'::text 
@@ -138,13 +138,13 @@
        and v.email ~ '[[:alnum:]_]'::text 
 group by v.credit_id, v.email
 UNION
-select v.credit_id, 12, v.cc, 'Carbon Copy email address' as description 
+select v.credit_id, 13, v.cc, 'Carbon Copy email address' as description 
 from lsmb12.customer v 
 where v.company_id is not null and v.cc is not null 
       and v.cc ~ '[[:alnum:]_]'::text 
 group by v.credit_id, v.cc
 UNION 
-select v.credit_id, 12, v.bcc, 'Blind Carbon Copy email address' as description 
+select v.credit_id, 14, v.bcc, 'Blind Carbon Copy email address' as description 
 from lsmb12.customer v 
 where v.company_id is not null and v.bcc is not null 
        and v.bcc ~ '[[:alnum:]_]'::text 

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