diff --git a/sql/upgrades/111.sql b/sql/upgrades/111.sql
new file mode 100644
index 00000000..65f927a9
--- /dev/null
+++ b/sql/upgrades/111.sql
@@ -0,0 +1,29 @@
+-- SWH DB schema upgrade
+-- from_version: 110
+-- to_version: 111
+-- description: Drop tables related to content provenance
+
+insert into dbversion(version, release, description)
+      values(111, now(), 'Work In Progress');
+
+DROP FUNCTION swh_cache_content_get(target sha1_git);
+
+DROP FUNCTION swh_cache_content_get_all();
+
+DROP FUNCTION swh_cache_content_revision_add();
+
+DROP FUNCTION swh_cache_revision_origin_add(origin_id bigint, visit_id bigint);
+
+DROP FUNCTION swh_content_find_provenance(content_id sha1_git);
+
+DROP FUNCTION swh_revision_from_target(target sha1_git, target_type object_type);
+
+DROP TABLE cache_content_revision;
+
+DROP TABLE cache_content_revision_processed;
+
+DROP TABLE cache_revision_origin;
+
+DROP TYPE cache_content_signature;
+
+DROP TYPE content_provenance;