[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



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.