|
7675.1237.1
by William Grant
Drop the tables. |
1 |
SET client_min_messages=ERROR; |
2 |
||
3 |
-- Remove interdependencies. upgrade.py drops replicated tables in
|
|
4 |
-- undefined order.
|
|
5 |
ALTER TABLE bountymessage DROP CONSTRAINT bountymessage_bounty_fk; |
|
6 |
ALTER TABLE bountymessage DROP CONSTRAINT bountymessage_message_fk; |
|
7 |
ALTER TABLE bountysubscription DROP CONSTRAINT bountysubscription_bounty_fk; |
|
8 |
ALTER TABLE distributionbounty DROP CONSTRAINT distributionbounty_bounty_fk; |
|
9 |
ALTER TABLE productbounty DROP CONSTRAINT productbounty_bounty_fk; |
|
10 |
ALTER TABLE projectbounty DROP CONSTRAINT projectbounty_bounty_fk; |
|
11 |
ALTER TABLE requestedcds DROP CONSTRAINT requestedcds_request_fk; |
|
12 |
ALTER TABLE shipitsurveyresult DROP CONSTRAINT shipitsurveyresult_answer_fkey; |
|
13 |
ALTER TABLE shipitsurveyresult DROP CONSTRAINT shipitsurveyresult_question_fkey; |
|
14 |
ALTER TABLE shipitsurveyresult DROP CONSTRAINT shipitsurveyresult_survey_fkey; |
|
15 |
ALTER TABLE shipment DROP CONSTRAINT shipment_shippingrun_fk; |
|
16 |
ALTER TABLE shippingrequest DROP CONSTRAINT shippingrequest_shipment_fk; |
|
17 |
||
18 |
-- And now actually dispose of all the tables.
|
|
|
7675.1237.3
by William Grant
Can't directly drop with slony, so move to todrop instead. |
19 |
ALTER TABLE authtoken SET SCHEMA todrop; |
20 |
ALTER TABLE bounty SET SCHEMA todrop; |
|
21 |
ALTER TABLE bountymessage SET SCHEMA todrop; |
|
22 |
ALTER TABLE bountysubscription SET SCHEMA todrop; |
|
23 |
ALTER TABLE bugpackageinfestation SET SCHEMA todrop; |
|
24 |
ALTER TABLE bugproductinfestation SET SCHEMA todrop; |
|
25 |
ALTER TABLE distributionbounty SET SCHEMA todrop; |
|
26 |
ALTER TABLE distrocomponentuploader SET SCHEMA todrop; |
|
27 |
ALTER TABLE mailinglistban SET SCHEMA todrop; |
|
28 |
ALTER TABLE mentoringoffer SET SCHEMA todrop; |
|
29 |
ALTER TABLE openidassociation SET SCHEMA todrop; |
|
30 |
ALTER TABLE packagebugsupervisor SET SCHEMA todrop; |
|
31 |
ALTER TABLE packageselection SET SCHEMA todrop; |
|
32 |
ALTER TABLE posubscription SET SCHEMA todrop; |
|
33 |
ALTER TABLE productbounty SET SCHEMA todrop; |
|
34 |
ALTER TABLE productcvsmodule SET SCHEMA todrop; |
|
35 |
ALTER TABLE productseriescodeimport SET SCHEMA todrop; |
|
36 |
ALTER TABLE productsvnmodule SET SCHEMA todrop; |
|
37 |
ALTER TABLE projectbounty SET SCHEMA todrop; |
|
38 |
ALTER TABLE projectrelationship SET SCHEMA todrop; |
|
39 |
ALTER TABLE pushmirroraccess SET SCHEMA todrop; |
|
40 |
ALTER TABLE requestedcds SET SCHEMA todrop; |
|
41 |
ALTER TABLE shipitreport SET SCHEMA todrop; |
|
42 |
ALTER TABLE shipitsurvey SET SCHEMA todrop; |
|
43 |
ALTER TABLE shipitsurveyanswer SET SCHEMA todrop; |
|
44 |
ALTER TABLE shipitsurveyquestion SET SCHEMA todrop; |
|
45 |
ALTER TABLE shipitsurveyresult SET SCHEMA todrop; |
|
46 |
ALTER TABLE shipment SET SCHEMA todrop; |
|
47 |
ALTER TABLE shippingrequest SET SCHEMA todrop; |
|
48 |
ALTER TABLE shippingrun SET SCHEMA todrop; |
|
49 |
ALTER TABLE standardshipitrequest SET SCHEMA todrop; |
|
50 |
ALTER TABLE webserviceban SET SCHEMA todrop; |
|
51 |
ALTER TABLE openidrpconfig SET SCHEMA todrop; |
|
52 |
ALTER TABLE openidrpsummary SET SCHEMA todrop; |
|
53 |
ALTER TABLE staticdiff SET SCHEMA todrop; |
|
|
7675.1237.7
by William Grant
Take out POComment too. |
54 |
ALTER TABLE pocomment SET SCHEMA todrop; |
|
7675.1237.1
by William Grant
Drop the tables. |
55 |
|
56 |
INSERT INTO LaunchpadDatabaseRevision VALUES (2208, 83, 2); |