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

[..hidden..]

Revision: 3138
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3138&view=rev
Author:   einhverfr
Date:     2011-05-17 21:35:43 +0000 (Tue, 17 May 2011)

Log Message:
-----------
User creation fix.  Thanks Erik Huelsmann

Modified Paths:
--------------
    trunk/sql/modules/admin.sql

Modified: trunk/sql/modules/admin.sql
===================================================================
--- trunk/sql/modules/admin.sql	2011-05-15 17:42:54 UTC (rev 3137)
+++ trunk/sql/modules/admin.sql	2011-05-17 21:35:43 UTC (rev 3138)
@@ -358,6 +358,10 @@
             
             insert into user_preference (id) values (v_user_id);
 
+            select * from entity_employee where entity_id = in_entity_id;
+            IF NOT FOUND THEN
+                select into entity_employee (entity_id) values (in_entity_id);
+            END IF;
             -- Finally, issue the create user statement
             
             return v_user_id ;


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