[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

Revision: 6717
Author:   tshvr
Date:     2014-01-31 10:11:26 +0000 (Fri, 31 Jan 2014)
Log Message:
correcting sql syntax errors

Modified Paths:

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 @@
 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);

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.
Ledger-smb-commits mailing list