SF.net SVN: ledger-smb:[3354] trunk/sql/upgrade/3353-add-assembly-fkeys.sql

[..hidden..]

Revision: 3354
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3354&view=rev
Author:   einhverfr
Date:     2011-06-27 08:09:27 +0000 (Mon, 27 Jun 2011)

Log Message:
-----------
Adding new foregn keys as upgrade script

Added Paths:
-----------
    trunk/sql/upgrade/3353-add-assembly-fkeys.sql

Added: trunk/sql/upgrade/3353-add-assembly-fkeys.sql
===================================================================
--- trunk/sql/upgrade/3353-add-assembly-fkeys.sql	                        (rev 0)
+++ trunk/sql/upgrade/3353-add-assembly-fkeys.sql	2011-06-27 08:09:27 UTC (rev 3354)
@@ -0,0 +1,2 @@
+ALTER TABLE assembly ADD foreign key (id) REFERENCES parts(id);
+ALTER TABLE assembly ADD foreign key (parts_id) REFERENCES parts(id);


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