Merge ~twom/launchpad:db-oci-recipe-build-path into launchpad:db-devel

[Tom Wardill]

Add OCIRecipe.build_path

[Colin Watson (cjwatson)]

I'm OK with this, but get a second review from William on general principles.

OCIRecipe has 11 rows on staging, so rewriting the table shouldn't be a problem.

review: Approve (db)

[William Grant (wgrant)]

review: Approve (db)

diff --git a/database/schema/patch-2210-20-0.sql b/database/schema/patch-2210-20-0.sql
new file mode 100644
index 0000000..e1e812d
--- /dev/null
+++ b/database/schema/patch-2210-20-0.sql
@@ -0,0 +1,10 @@
+-- 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 OCIRecipe ADD COLUMN build_path text DEFAULT '.' NOT NULL;
+
+COMMENT ON COLUMN OCIRecipe.build_path IS 'Directory to use for build context and OCIRecipe.build_file location.';
+
+INSERT INTO LaunchpadDatabaseRevision VALUES (2210, 20, 0);