SF.net SVN: ledger-smb:[6088] trunk

[..hidden..]

Revision: 6088
          http://sourceforge.net/p/ledger-smb/code/6088
Author:   einhverfr
Date:     2013-09-27 08:03:06 +0000 (Fri, 27 Sep 2013)
Log Message:
-----------
Fixing errors on employee screen after upgrade, bug 868

Modified Paths:
--------------
    trunk/sql/upgrade/1.3-1.4.sql

Added Paths:
-----------
    trunk/UI/lib/Tabular.js

Added: trunk/UI/lib/Tabular.js
===================================================================
Modified: trunk/sql/upgrade/1.3-1.4.sql
===================================================================
--- trunk/sql/upgrade/1.3-1.4.sql	2013-09-26 11:39:33 UTC (rev 6087)
+++ trunk/sql/upgrade/1.3-1.4.sql	2013-09-27 08:03:06 UTC (rev 6088)
@@ -108,6 +108,13 @@
 
 INSERT INTO person SELECT * FROM lsmb13.person;
 INSERT INTO entity_employee SELECT * FROM lsmb13.entity_employee;
+UPDATE entity_employee 
+   SET ssn = 'invalid-' || entity_id::text
+ WHERE ssn = '' or ssn is null;
+UPDATE entity_employee 
+   SET employeenumber = 'invalid-' || entity_id::text
+ WHERE employeenumber = '' or employeenumber is null;
+
 INSERT INTO person_to_company SELECT * FROM lsmb13.person_to_company;
 INSERT INTO entity_other_name SELECT * FROM lsmb13.entity_other_name;
 INSERT INTO entity_to_contact 

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


------------------------------------------------------------------------------
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from 
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60133471&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits