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

[..hidden..]

Revision: 3805
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3805&view=rev
Author:   einhverfr
Date:     2011-10-07 19:24:39 +0000 (Fri, 07 Oct 2011)
Log Message:
-----------
Correcting install bug reported and patched by Louis

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-07 19:03:27 UTC (rev 3804)
+++ branches/1.3/sql/upgrade/1.2-1.3-manual.sql	2011-10-07 19:24:39 UTC (rev 3805)
@@ -576,7 +576,7 @@
 INSERT INTO audittrail(trans_id, tablename, reference, formname, action,
             transdate, person_id, entry_id)
      SELECT trans_id, tablename, reference, formname, action,
-            transdate, p.id, entry_id
+            transdate, p.entity_id, entry_id
        FROM lsmb12.audittrail a
        JOIN lsmb12.employee e ON a.employee_id = e.id
        JOIN person p on e.entity_id = p.entity_id;

Modified: branches/1.3/sql/upgrade/1.2-1.3.sql
===================================================================
--- branches/1.3/sql/upgrade/1.2-1.3.sql	2011-10-07 19:03:27 UTC (rev 3804)
+++ branches/1.3/sql/upgrade/1.2-1.3.sql	2011-10-07 19:24:39 UTC (rev 3805)
@@ -574,7 +574,7 @@
 INSERT INTO audittrail(trans_id, tablename, reference, formname, action,
             transdate, person_id, entry_id)
      SELECT trans_id, tablename, reference, formname, action,
-            transdate, p.id, entry_id
+            transdate, p.entity_id, entry_id
        FROM lsmb12.audittrail a
        JOIN lsmb12.employee e ON a.employee_id = e.id
        JOIN person p on e.entity_id = p.entity_id;

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