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

[..hidden..]

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

Log Message:
-----------
Adding the fixes for the primary key on the recurring email and print tables

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

Added: branches/1.2/sql/fixes/recurring_pkey_duplicate.sql
===================================================================
--- branches/1.2/sql/fixes/recurring_pkey_duplicate.sql	                        (rev 0)
+++ branches/1.2/sql/fixes/recurring_pkey_duplicate.sql	2007-11-29 18:24:09 UTC (rev 1918)
@@ -0,0 +1,9 @@
+-- SC: Corrects the primary key constraints on the recurringemail and print
+--     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.
+
+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);


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