|
7675.1231.1
by William Grant
Drop obsolete branchmergeproposal.review_diff column, and LFA/Person foreign keys from obsolete tables (so we can drop them live later). |
1 |
SET client_min_messages=ERROR; |
2 |
||
3 |
-- Remove Person FKs.
|
|
4 |
ALTER TABLE authtoken DROP CONSTRAINT authtoken__requester__fk; |
|
5 |
ALTER TABLE bounty DROP CONSTRAINT bounty_claimant_fk; |
|
6 |
ALTER TABLE bounty DROP CONSTRAINT bounty_owner_fk; |
|
7 |
ALTER TABLE bounty DROP CONSTRAINT bounty_reviewer_fk; |
|
8 |
ALTER TABLE bountysubscription DROP CONSTRAINT bountysubscription_person_fk; |
|
9 |
ALTER TABLE bugpackageinfestation DROP CONSTRAINT bugpackageinfestation_creator_fk; |
|
10 |
ALTER TABLE bugpackageinfestation DROP CONSTRAINT bugpackageinfestation_lastmodifiedby_fk; |
|
11 |
ALTER TABLE bugpackageinfestation DROP CONSTRAINT bugpackageinfestation_verifiedby_fk; |
|
12 |
ALTER TABLE bugproductinfestation DROP CONSTRAINT bugproductinfestation_creator_fk; |
|
13 |
ALTER TABLE bugproductinfestation DROP CONSTRAINT bugproductinfestation_lastmodifiedby_fk; |
|
14 |
ALTER TABLE bugproductinfestation DROP CONSTRAINT bugproductinfestation_verifiedby_fk; |
|
15 |
ALTER TABLE distrocomponentuploader DROP CONSTRAINT distrocomponentuploader_uploader_fk; |
|
16 |
ALTER TABLE mailinglistban DROP CONSTRAINT mailinglistban_banned_by_fkey; |
|
17 |
ALTER TABLE mailinglistban DROP CONSTRAINT mailinglistban_person_fkey; |
|
18 |
ALTER TABLE mentoringoffer DROP CONSTRAINT mentoringoffer_owner_fkey; |
|
19 |
ALTER TABLE mentoringoffer DROP CONSTRAINT mentoringoffer_team_fkey; |
|
20 |
ALTER TABLE packagebugsupervisor DROP CONSTRAINT packagebugsupervisor__bug_supervisor__fk; |
|
21 |
ALTER TABLE posubscription DROP CONSTRAINT "$1"; |
|
22 |
ALTER TABLE pushmirroraccess DROP CONSTRAINT "$1"; |
|
23 |
ALTER TABLE webserviceban DROP CONSTRAINT webserviceban_person_fkey; |
|
24 |
ALTER TABLE openidrpsummary DROP CONSTRAINT openidrpsummary_account_fkey; |
|
|
7675.1231.2
by William Grant
pocomment becomes the last member of the Condemned 36. |
25 |
ALTER TABLE pocomment DROP CONSTRAINT "$5"; |
|
7675.1231.1
by William Grant
Drop obsolete branchmergeproposal.review_diff column, and LFA/Person foreign keys from obsolete tables (so we can drop them live later). |
26 |
|
27 |
-- Remove LFA FKs.
|
|
28 |
ALTER TABLE shipitreport DROP CONSTRAINT "$1"; |
|
29 |
ALTER TABLE shippingrun DROP CONSTRAINT shippingrun_csvfile_fk; |
|
30 |
ALTER TABLE openidrpconfig DROP CONSTRAINT openidrpconfig__logo__fk; |
|
31 |
||
32 |
-- Unreference staticdiff.
|
|
33 |
ALTER TABLE branchmergeproposal DROP COLUMN review_diff; |
|
34 |
||
35 |
INSERT INTO LaunchpadDatabaseRevision VALUES (2208, 83, 1); |