Merge ~pappacena/launchpad:snap-pillar-db-indexes into launchpad:db-devel

[Thiago F. Pappacena]

Snap privacy indexes and CHECK constraint validation

[William Grant (wgrant)]

review: Approve (db)

Unmerged commits

c8875c6... by Thiago F. Pappacena on 2021-02-19

Snap privacy indexes and CHECK constraint validation

a44145f... by Thiago F. Pappacena on 2021-02-19

Skipping personmerge sanity checks on SnapSubscription (while we dont have this entity in place)

bcdb89b... by Thiago F. Pappacena on 2021-02-19

Minor adjustments, and moving large index/constraint creation to another patch

0510967... by Thiago F. Pappacena on 2021-02-12

Fixing ambiguity in snap_denorm_access

08fb5e5... by Thiago F. Pappacena on 2021-02-12

Adding Snap.information_type column

9c49e1b... by Thiago F. Pappacena on 2021-02-09

Adding SnapSubscription model

f2abd3c... by Thiago F. Pappacena on 2021-02-04

Adding access_policy and access_grants caches to Snap table

ea33cf9... by Thiago F. Pappacena on 2021-02-03

Adding Snap.project for private Snaps' optional pillars

diff --git a/database/schema/patch-2210-26-2.sql b/database/schema/patch-2210-26-2.sql
new file mode 100644
index 0000000..ab6e0a3
--- /dev/null
+++ b/database/schema/patch-2210-26-2.sql
@@ -0,0 +1,14 @@
+-- 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;
+
+CREATE INDEX snap__project__idx ON Snap(project) WHERE project IS NOT NULL;
+
+CREATE UNIQUE INDEX accessartifact__snap__key
+    ON AccessArtifact(snap) WHERE snap IS NOT NULL;
+
+ALTER TABLE AccessArtifact VALIDATE CONSTRAINT has_artifact;
+
+
+INSERT INTO LaunchpadDatabaseRevision VALUES (2210, 26, 2);