1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
|
-- Copyright 2010 Canonical Ltd. This software is licensed under the
-- GNU Affero General Public License version 3 (see the file LICENSE).
SET client_min_messages=ERROR;
alter table archivepermission drop constraint archivepermission__archive__fk;
ALTER TABLE ONLY archivepermission ADD CONSTRAINT archivepermission__archive__fk FOREIGN KEY (archive) REFERENCES archive(id) on delete cascade;
alter table build drop constraint build__archive__fk;
ALTER TABLE ONLY build ADD CONSTRAINT build__archive__fk FOREIGN KEY (archive) REFERENCES archive(id) on delete cascade;
alter table distributionsourcepackagecache drop constraint distributionsourcepackagecache__archive__fk;
ALTER TABLE ONLY distributionsourcepackagecache
ADD CONSTRAINT distributionsourcepackagecache__archive__fk FOREIGN KEY (archive) REFERENCES archive(id) on delete cascade;
alter table distroseriespackagecache drop constraint distroseriespackagecache__archive__fk;
alter table distroseriespackagecache
add constraint distroseriespackagecache__archive__fk FOREIGN KEY (archive) REFERENCES archive(id) on delete cascade;
alter table packageupload drop constraint packageupload__archive__fk;
ALTER TABLE ONLY packageupload
ADD CONSTRAINT packageupload__archive__fk FOREIGN KEY (archive) REFERENCES archive(id) on delete cascade;
alter table binarypackagepublishinghistory drop constraint securebinarypackagepublishinghistory__archive__fk;
ALTER TABLE ONLY binarypackagepublishinghistory
ADD CONSTRAINT securebinarypackagepublishinghistory__archive__fk FOREIGN KEY (archive) REFERENCES archive(id) on delete cascade;
alter table sourcepackagepublishinghistory drop constraint securesourcepackagepublishinghistory__archive__fk;
alter table sourcepackagepublishinghistory ADD CONSTRAINT sourcepackagepublishinghistory__archive__fk FOREIGN KEY (archive) REFERENCES archive(id) on delete cascade;
alter table binarypackagerelease drop constraint binarypackagerelease_build_fk;
ALTER TABLE ONLY binarypackagerelease
ADD CONSTRAINT binarypackagerelease__build__fk FOREIGN KEY (build) REFERENCES build(id) on delete cascade;
alter table packageuploadsource drop constraint packageuploadsource__packageupload__fk;
ALTER TABLE ONLY packageuploadsource
ADD CONSTRAINT packageuploadsource__packageupload__fk FOREIGN KEY (packageupload) REFERENCES packageupload(id) on delete cascade;
alter table packageuploadbuild drop constraint packageuploadbuild_packageupload_fk;
ALTER TABLE ONLY packageuploadbuild
ADD CONSTRAINT packageuploadbuild__packageupload__fk FOREIGN KEY (packageupload) REFERENCES packageupload(id) on delete cascade;
alter table sourcepackagereleasefile drop constraint "$1";
ALTER TABLE ONLY sourcepackagereleasefile
ADD CONSTRAINT "$1" FOREIGN KEY (sourcepackagerelease) REFERENCES sourcepackagerelease(id) on delete cascade;
alter table binarypackagefile drop constraint binarypackagefile_binarypackagerelease_fk;
ALTER TABLE ONLY binarypackagefile
ADD CONSTRAINT binarypackagefile_binarypackagerelease_fk FOREIGN KEY (binarypackagerelease) REFERENCES binarypackagerelease(id) on delete cascade;
alter table binarypackagereleasedownloadcount drop constraint binarypackagereleasedownloadcount_archive_fkey;
alter table binarypackagereleasedownloadcount
add constraint binarypackagereleasedownloadcount_archive_fkey FOREIGN KEY (archive) REFERENCES archive(id) on delete cascade;
alter table sourcepackagerecipebuild drop constraint sourcepackagerecipebuild_archive_fkey;
alter table sourcepackagerecipebuild
add constraint sourcepackagerecipebuild__archive__fk FOREIGN KEY (archive) REFERENCES archive(id) on delete cascade;
alter table archivearch drop constraint archivearch__archive__fk;
alter table archivearch
add constraint archivearch__archive__fk FOREIGN KEY (archive) REFERENCES archive(id) on delete cascade;
alter table archiveauthtoken drop constraint archiveauthtoken_archive_fkey;
alter table archiveauthtoken
add constraint archiveauthtoken__archive__fk FOREIGN KEY (archive) REFERENCES archive(id) on delete cascade;
alter table archivedependency drop constraint archivedependency_archive_fkey;
alter table archivedependency
add constraint archivedependency__archive__fk FOREIGN KEY (archive) REFERENCES archive(id) on delete cascade;
alter table archivedependency drop constraint archivedependency_dependency_fkey;
alter table archivedependency add
constraint archivedependency__dependency__fk FOREIGN KEY (archive) REFERENCES archive(id) on delete cascade;
alter table archivesubscriber drop constraint archivesubscriber_archive_fkey;
alter table archivesubscriber
add constraint archivesubscriber__archive__fk FOREIGN KEY (archive) REFERENCES archive(id) on delete cascade;
alter table packagecopyrequest drop constraint packagecopyrequest__sourcearchive__fk;
alter table packagecopyrequest
add constraint packagecopyrequest__sourcearchive__fk FOREIGN KEY (source_archive) REFERENCES archive(id) on delete cascade;
alter table packagecopyrequest drop constraint packagecopyrequest__targetarchive__fk;
alter table packagecopyrequest
add constraint packagecopyrequest__targetarchive__fk FOREIGN KEY (target_archive) REFERENCES archive(id) on delete cascade;
-- If the upload_archive is deleted but the SPR was copied to a different
-- archive, then we allow this to be null to signify the original archive
-- was removed.
alter table sourcepackagerelease alter upload_archive drop not null;
INSERT INTO LaunchpadDatabaseRevision VALUES (2207, 41, 0);
|