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

[..hidden..]

Revision: 3841
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3841&view=rev
Author:   einhverfr
Date:     2011-10-12 12:16:08 +0000 (Wed, 12 Oct 2011)
Log Message:
-----------
Correcting minor bug with employee names in upgrade script

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	2011-10-12 06:00:00 UTC (rev 3840)
+++ branches/1.3/sql/upgrade/1.2-1.3-manual.sql	2011-10-12 12:16:08 UTC (rev 3841)
@@ -370,8 +370,8 @@
 
 ALTER TABLE lsmb12.employee ADD entity_id int;
 
-INSERT INTO entity(control_code, entity_class, country_id)
-select 'E-' || employeenumber, 3,
+INSERT INTO entity(control_code, entity_class, name, country_id)
+select 'E-' || employeenumber, 3, name, 
         (select id from country where lower(short_name) = :default_country)
 FROM lsmb12.employee;
 

Modified: branches/1.3/sql/upgrade/1.2-1.3.sql
===================================================================
--- branches/1.3/sql/upgrade/1.2-1.3.sql	2011-10-12 06:00:00 UTC (rev 3840)
+++ branches/1.3/sql/upgrade/1.2-1.3.sql	2011-10-12 12:16:08 UTC (rev 3841)
@@ -368,8 +368,8 @@
 
 ALTER TABLE lsmb12.employee ADD entity_id int;
 
-INSERT INTO entity(control_code, entity_class, country_id)
-select 'E-' || employeenumber, 3,
+INSERT INTO entity(control_code, entity_class, name, country_id)
+select 'E-' || employeenumber, 3, name,
         (select id from country where lower(short_name) = :default_country)
 FROM lsmb12.employee;
 

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