SF.net SVN: ledger-smb: [1919] branches/1.2/sql/fixes/ recurring_pkey_duplicate.sql

[..hidden..]

Revision: 1919
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=1919&view=rev
Author:   tetragon
Date:     2007-11-29 12:07:09 -0800 (Thu, 29 Nov 2007)

Log Message:
-----------
Add in the changes for the status table

Modified Paths:
--------------
    branches/1.2/sql/fixes/recurring_pkey_duplicate.sql

Modified: branches/1.2/sql/fixes/recurring_pkey_duplicate.sql
===================================================================
--- branches/1.2/sql/fixes/recurring_pkey_duplicate.sql	2007-11-29 18:24:09 UTC (rev 1918)
+++ branches/1.2/sql/fixes/recurring_pkey_duplicate.sql	2007-11-29 20:07:09 UTC (rev 1919)
@@ -2,8 +2,12 @@
 --     tables.  The original primary keys are too restrictive and go against
 --     how the application works in that they don't allow for printing or
 --     emailing multiple forms as part of a recurring transaction.
+--
+--     Related adjustments also are made to the status table.
 
 ALTER TABLE recurringemail DROP CONSTRAINT recurringemail_pkey;
 ALTER TABLE recurringemail ADD PRIMARY KEY (id, formname);
 ALTER TABLE recurringprint DROP CONSTRAINT recurringprint_pkey;
 ALTER TABLE recurringprint ADD PRIMARY KEY (id, formname);
+ALTER TABLE status DROP CONSTRAINT status_pkey;
+ALTER TABLE status ADD PRIMARY KEY (trans_id, formname);


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