Merge ~jugmac00/launchpad:signedcodeofconduct-cant-be-null into launchpad:db-devel

[Jürgen Gmach]

signedcodeofconduct.affirmed can`t be NULL anymore

[Colin Watson (cjwatson)]

Ioana has already claimed this patch number (in https://bazaar.launchpad.net/~launchpad/+junk/dbpatches/view/head:/allocated.txt) for RevisionStatus{Report,Artifact}. Please use 2210-34-1 instead, since this is following on directly from the addition of this column in 2210-34-0 and no later patch touches SignedCodeOfConduct. I've allocated this patch number for you.

review: Needs Fixing (db)

[Jürgen Gmach (jugmac00)]

Thank you for the review!

Thanks for the reference to https://bazaar.launchpad.net/~launchpad/+junk/dbpatches/view/head:/allocated.txt - it makes sense to claim a number in advance.

Also, thank you for explaining how to use the number scheme - now it makes sense on how to use it.

I also updated the header and the footer.

[Colin Watson (cjwatson)]

Needs a second DB review from William, but LGTM.

review: Approve (db)

[William Grant (wgrant)]

review: Approve (db)

diff --git a/database/schema/patch-2210-34-1.sql b/database/schema/patch-2210-34-1.sql
new file mode 100644
index 0000000..1816936
--- /dev/null
+++ b/database/schema/patch-2210-34-1.sql
@@ -0,0 +1,8 @@
+-- Copyright 2021 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 signedcodeofconduct ALTER COLUMN affirmed SET NOT NULL;
+
+INSERT INTO LaunchpadDatabaseRevision VALUES (2210, 34, 1);