SF.net SVN: ledger-smb:[6295] trunk/sql/upgrade/1.3-1.4.sql

[..hidden..]

Revision: 6295
          http://sourceforge.net/p/ledger-smb/code/6295
Author:   tshvr
Date:     2013-11-18 14:09:40 +0000 (Mon, 18 Nov 2013)
Log Message:
-----------
disable trigger on acc_trans for load,check 1.3 audittrail for person_id

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

Modified: trunk/sql/upgrade/1.3-1.4.sql
===================================================================
--- trunk/sql/upgrade/1.3-1.4.sql	2013-11-18 11:28:36 UTC (rev 6294)
+++ trunk/sql/upgrade/1.3-1.4.sql	2013-11-18 14:09:40 UTC (rev 6295)
@@ -292,6 +292,8 @@
 
 INSERT INTO voucher SELECT * FROM lsmb13.voucher;
 
+ALTER TABLE acc_trans DISABLE TRIGGER ALL;
+
 INSERT INTO acc_trans (
  trans_id,
  chart_id,
@@ -324,6 +326,8 @@
  entry_id 
    FROM lsmb13.acc_trans;
 
+ALTER TABLE acc_trans enable TRIGGER ALL;
+
 INSERT INTO invoice (
  id,
  trans_id,
@@ -520,6 +524,8 @@
 INSERT INTO yearend SELECT * FROM lsmb13.yearend;
 INSERT INTO partsvendor SELECT * FROM lsmb13.partsvendor;
 INSERT INTO partscustomer SELECT * FROM lsmb13.partscustomer;
+
+update lsmb13.audittrail set person_id=(select id from lsmb13.person where last_name='Admin') where person_id not in (select id from lsmb13.person) ;
 INSERT INTO audittrail SELECT * FROM lsmb13.audittrail;
 INSERT INTO translation SELECT * FROM lsmb13.translation;
 INSERT INTO parts_translation SELECT * FROM lsmb13.parts_translation;

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


------------------------------------------------------------------------------
DreamFactory - Open Source REST & JSON Services for HTML5 & Native Apps
OAuth, Users, Roles, SQL, NoSQL, BLOB Storage and External API Access
Free app hosting. Or install the open source package on any LAMP server.
Sign up and see examples for AngularJS, jQuery, Sencha Touch and Native!
http://pubads.g.doubleclick.net/gampad/clk?id=63469471&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits