SF.net SVN: ledger-smb:[6717] trunk/sql/modules/Fixes.sql

[..hidden..]

Revision: 6717
          http://sourceforge.net/p/ledger-smb/code/6717
Author:   tshvr
Date:     2014-01-31 10:11:26 +0000 (Fri, 31 Jan 2014)
Log Message:
-----------
correcting sql syntax errors

Modified Paths:
--------------
    trunk/sql/modules/Fixes.sql

Modified: trunk/sql/modules/Fixes.sql
===================================================================
--- trunk/sql/modules/Fixes.sql	2014-01-30 21:42:39 UTC (rev 6716)
+++ trunk/sql/modules/Fixes.sql	2014-01-31 10:11:26 UTC (rev 6717)
@@ -114,10 +114,10 @@
 BEGIN;
 
 ALTER TABLE asset_report DROP CONSTRAINT "asset_report_gl_id_fkey";
-ALTER TABLE asset_report ADD FOREIGN KEY gl_id REFERENCES gl(id);
+ALTER TABLE asset_report ADD  CONSTRAINT "asset_report_gl_id_fkey" FOREIGN KEY (gl_id) REFERENCES gl(id);
 
 ALTER TABLE file_order_to_tx DROP CONSTRAINT "file_order_to_tx_ref_key_fkey";
-ALTER TABLE file_order_to_tx ADD FOREIGN KEY ref_key REFERENCES gl(id);
+ALTER TABLE file_order_to_tx ADD CONSTRAINT "file_order_to_tx_ref_key_fkey" FOREIGN KEY (ref_key) REFERENCES gl(id);
 
 COMMIT;
 

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


------------------------------------------------------------------------------
WatchGuard Dimension instantly turns raw network data into actionable 
security intelligence. It gives you real-time visual feedback on key
security issues and trends.  Skip the complicated setup - simply import
a virtual appliance and go from zero to informed in seconds.
http://pubads.g.doubleclick.net/gampad/clk?id=123612991&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits