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
|
-- Copyright 2009 Canonical Ltd. This software is licensed under the
-- GNU Affero General Public License version 3 (see the file LICENSE).
SET client_min_messages=ERROR;
-- Another schema patch required for the Soyuz buildd generalisation, see
-- https://dev.launchpad.net/Soyuz/Specs/BuilddGeneralisation for details.
-- Bug #505725.
-- Changes needed to the `BuildQueue` table.
-- The 'processor' and the 'virtualized' columns will enable us to formulate
-- more straightforward queries for finding candidate jobs when builders
-- become idle.
ALTER TABLE ONLY buildqueue ADD COLUMN processor integer;
ALTER TABLE ONLY buildqueue ADD COLUMN virtualized boolean;
-- Replicate the processor/require_virtualized values of the (binary) builds
-- associated with the existing BuildQueue records.
UPDATE BuildQueue
SET processor = Build.processor, virtualized = Archive.require_virtualized
FROM Archive, Build, BuildPackageJob
WHERE
BuildPackageJob.job = BuildQueue.job
AND BuildPackageJob.build = Build.id
AND Build.archive = Archive.id;
CREATE INDEX buildqueue__processor__virtualized__idx ON buildqueue USING btree (processor, virtualized) WHERE (processor IS NOT NULL);
INSERT INTO LaunchpadDatabaseRevision VALUES (2207, 24, 0);
|