SF.net SVN: ledger-smb: [1128] branches/1.2/sql/legacy/Pg-upgrade-2.6.18-2. 6.19.sql

[..hidden..]

Revision: 1128
          http://svn.sourceforge.net/ledger-smb/?rev=1128&view=rev
Author:   einhverfr
Date:     2007-05-06 10:05:27 -0700 (Sun, 06 May 2007)

Log Message:
-----------
Removing the tax primary key from the upgrade script

Modified Paths:
--------------
    branches/1.2/sql/legacy/Pg-upgrade-2.6.18-2.6.19.sql

Modified: branches/1.2/sql/legacy/Pg-upgrade-2.6.18-2.6.19.sql
===================================================================
--- branches/1.2/sql/legacy/Pg-upgrade-2.6.18-2.6.19.sql	2007-05-06 07:14:28 UTC (rev 1127)
+++ branches/1.2/sql/legacy/Pg-upgrade-2.6.18-2.6.19.sql	2007-05-06 17:05:27 UTC (rev 1128)
@@ -61,8 +61,12 @@
 
 ALTER TABLE status ADD PRIMARY KEY (trans_id);
 
-ALTER TABLE tax ADD PRIMARY KEY (chart_id);
-ALTER TABLE tax ADD FOREIGN KEY (chart_id) REFERENCES chart (id);
+-- Removing the primary key below since this is not quite the best way
+-- do this.  The tax table could have multiple rows per chart_id.
+-- We need a better fix for 1.3 (perhaps changing date to timestamp and
+-- and defaulting to infinity.
+-- ALTER TABLE tax ADD PRIMARY KEY (chart_id);
+-- ALTER TABLE tax ADD FOREIGN KEY (chart_id) REFERENCES chart (id);
 
 ALTER TABLE translation ADD PRIMARY KEY (trans_id, language_code);
 


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