1
=== added file 'database/schema/patch-2209-41-4.sql'
2
--- database/schema/patch-2209-41-4.sql	1970-01-01 00:00:00 +0000
3
+++ database/schema/patch-2209-41-4.sql	2013-02-07 05:09:24 +0000
4
@@ -0,0 +1,54 @@
5
1
-- Copyright 2013 Canonical Ltd.  This software is licensed under the
6
2
-- GNU Affero General Public License version 3 (see the file LICENSE).
7
3
8
4
SET client_min_messages=ERROR;
9
5
10
6
-- Distribution:+builds
11
7
CREATE INDEX binarypackagebuild__distro__status__date_finished__id__idx
12
8
    ON binarypackagebuild (distribution, status, date_finished DESC, id)
13
9
    WHERE is_distro_archive;
14
10
CREATE INDEX binarypackagebuild__distro__status__id__idx
15
11
    ON binarypackagebuild (distribution, status, id)
16
12
    WHERE is_distro_archive;
17
13
CREATE INDEX binarypackagebuild__distro__id__idx
18
14
    ON binarypackagebuild (distribution, id)
19
15
    WHERE is_distro_archive;
20
16
21
17
-- DistroSeries:+builds
22
18
CREATE INDEX binarypackagebuild__ds__status__date_finished__id__idx
23
19
    ON binarypackagebuild (distro_series, status, date_finished DESC, id)
24
20
    WHERE is_distro_archive;
25
21
CREATE INDEX binarypackagebuild__ds__status__id__idx
26
22
    ON binarypackagebuild (distro_series, status, id)
27
23
    WHERE is_distro_archive;
28
24
CREATE INDEX binarypackagebuild__ds__id__idx
29
25
    ON binarypackagebuild (distro_series, id)
30
26
    WHERE is_distro_archive;
31
27
32
28
-- DistroArchSeries:+builds
33
29
CREATE INDEX binarypackagebuild__das__status__date_finished__id__2__idx
34
30
    ON binarypackagebuild (distro_arch_series, status, date_finished DESC, id)
35
31
    WHERE is_distro_archive;
36
32
CREATE INDEX binarypackagebuild__das__status__id__2__idx
37
33
    ON binarypackagebuild (distro_arch_series, status, id)
38
34
    WHERE is_distro_archive;
39
35
CREATE INDEX binarypackagebuild__das__id__2__idx
40
36
    ON binarypackagebuild (distro_arch_series, id)
41
37
    WHERE is_distro_archive;
42
38
43
39
-- BinaryPackageBuild.estimateDuration, and general (archive, DAS) queries.
44
40
CREATE INDEX binarypackagebuild__archive__das__spn__status__finished__idx
45
41
    ON binarypackagebuild (archive, distro_arch_series, source_package_name,
46
42
                           status, date_finished, id);
47
43
48
44
-- General queries by SPN.
49
45
CREATE INDEX binarypackagebuild__source_package_name__idx
50
46
    ON binarypackagebuild (source_package_name);
51
47
52
48
-- And grabbing BPRs/SPRs by (name, version).
53
49
CREATE INDEX binarypackagerelease__binarypackagename__version__idx
54
50
    ON binarypackagerelease (binarypackagename, version);
55
51
CREATE INDEX sourcepackagerelease__sourcepackagename__version__idx
56
52
    ON sourcepackagerelease (sourcepackagename, version);
57
53
58
54
INSERT INTO LaunchpadDatabaseRevision VALUES (2209, 41, 4);
Reviewer	Review Type	Date Requested	Status
William Grant	db		Approve on 2013-02-07
Review via email: mp+147018@code.launchpad.net