Merge ~cjwatson/launchpad:db-oci-recipe-build-build-request into launchpad:db-devel

[Colin Watson]

Add OCIRecipeBuild.build_request column

This is useful in order to be able to trace builds back to the build request that produced them. It's precisely analogous to SnapBuild.build_request (see DB patch 2209-83-4).

[William Grant (wgrant)]

review: Approve (db)

[William Grant (wgrant)]

This needs an index.

d70c0fd... by Colin Watson on 2020-04-28

Index OCIRecipeBuild (build_request)

[William Grant (wgrant)]

review: Approve (db)

diff --git a/database/schema/patch-2210-15-1.sql b/database/schema/patch-2210-15-1.sql
new file mode 100644
index 0000000..86197e1
--- /dev/null
+++ b/database/schema/patch-2210-15-1.sql
@@ -0,0 +1,12 @@
+-- Copyright 2020 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 OCIRecipeBuild ADD COLUMN build_request integer REFERENCES job;
+
+COMMENT ON COLUMN OCIRecipeBuild.build_request IS 'The build request that caused this build to be created.';
+
+CREATE INDEX ocirecipebuild__build_request__idx ON OCIRecipeBuild (build_request);
+
+INSERT INTO LaunchpadDatabaseRevision VALUES (2210, 15, 1);