SF.net SVN: ledger-smb:[3357] trunk/sql/upgrade/3356-fkeys.sql

[..hidden..]

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

Log Message:
-----------
Adding omitted db upgrade script

Added Paths:
-----------
    trunk/sql/upgrade/3356-fkeys.sql

Added: trunk/sql/upgrade/3356-fkeys.sql
===================================================================
--- trunk/sql/upgrade/3356-fkeys.sql	                        (rev 0)
+++ trunk/sql/upgrade/3356-fkeys.sql	2011-06-27 10:52:54 UTC (rev 3357)
@@ -0,0 +1,11 @@
+ALTER TABLE partscustomer ALTER COLUMN credit_id drop not null;
+
+ALTER TABLE partscustomer 
+ADD foreign key (pricegroup_id) references pricegroup(id);
+
+CREATE TABLE parts_translation () INHERITS (translation);
+ALTER TABLE parts_translation ADD foreign key (trans_id) REFERENCES parts(id);
+    
+CREATE TABLE project_translation () INHERITS (translation);
+ALTER TABLE project_translation 
+ADD foreign key (trans_id) REFERENCES project(id);


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