[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
SF.net SVN: ledger-smb: [138] trunk/sql/Pg-upgrade-2.6.18-2.6.19.sql
- Subject: SF.net SVN: ledger-smb: [138] trunk/sql/Pg-upgrade-2.6.18-2.6.19.sql
- From: ..hidden..
- Date: Sat, 23 Sep 2006 19:11:10 -0700
Revision: 138
http://svn.sourceforge.net/ledger-smb/?rev=138&view=rev
Author: einhverfr
Date: 2006-09-23 19:11:06 -0700 (Sat, 23 Sep 2006)
Log Message:
-----------
Started the next db upgrade file. So far, I have set acc_trans.trans_id as a foreign key.
Added Paths:
-----------
trunk/sql/Pg-upgrade-2.6.18-2.6.19.sql
Added: trunk/sql/Pg-upgrade-2.6.18-2.6.19.sql
===================================================================
--- trunk/sql/Pg-upgrade-2.6.18-2.6.19.sql (rev 0)
+++ trunk/sql/Pg-upgrade-2.6.18-2.6.19.sql 2006-09-24 02:11:06 UTC (rev 138)
@@ -0,0 +1 @@
+ALTER TABLE acc_trans ADD FOREIGN KEY trans_id REFERENCES transactions (id);
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.