blob: 9c30a0c778e9c07b89a06b90cdf07a1c37e05e43 (
plain)
- -- 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);
|