SF.net SVN: ledger-smb:[3500] trunk/sql/upgrade/3497-schema-changes.sql

[..hidden..]

Revision: 3500
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3500&view=rev
Author:   einhverfr
Date:     2011-07-13 19:08:37 +0000 (Wed, 13 Jul 2011)

Log Message:
-----------
Correcting schema update script

Modified Paths:
--------------
    trunk/sql/upgrade/3497-schema-changes.sql

Modified: trunk/sql/upgrade/3497-schema-changes.sql
===================================================================
--- trunk/sql/upgrade/3497-schema-changes.sql	2011-07-13 04:41:00 UTC (rev 3499)
+++ trunk/sql/upgrade/3497-schema-changes.sql	2011-07-13 19:08:37 UTC (rev 3500)
@@ -1,6 +1,8 @@
-ALTER TABLE invoice ADD FOREIGN KEY trans_id REFERENCES transactions(id);
-ALTER TABLE invoice ADD FOREIGN KEY parts_id REFERENCES parts(id);
+ALTER TABLE invoice ADD FOREIGN KEY (trans_id) REFERENCES transactions(id);
+ALTER TABLE invoice ADD FOREIGN KEY (parts_id) REFERENCES parts(id);
 
-ALTER TABLE tax ADD FOREIGN KEY chart_id REFERENCES account(id);
-CREATE TRIGGER ap_audit_trail AFTER insert or update or delete ON ap;
+ALTER TABLE tax ADD FOREIGN KEY (chart_id) REFERENCES account(id);
+CREATE TRIGGER ap_audit_trail AFTER insert or update or delete ON ap
+FOR EACH ROW EXECUTE PROCEDURE gl_audit_trail_append();
 
+


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