diff --git a/swh/indexer/sql/upgrades/137.sql b/swh/indexer/sql/upgrades/137.sql index a7d69f1..152ae0e 100644 --- a/swh/indexer/sql/upgrades/137.sql +++ b/swh/indexer/sql/upgrades/137.sql @@ -1,23 +1,19 @@ -- SWH Indexer DB schema upgrade -- from_version: 136 -- to_version: 137 -- description: Drop content_language and content_ctags tables and related functions -insert into dbversion(version, release, description) - values(137, now(), 'Work In Progress'); +drop function if exists swh_content_language_add; +drop function if exists swh_mktemp_content_language(); +drop function if exists swh_mktemp_content_ctags(); +drop function if exists swh_content_ctags_add(); +drop function if exists swh_content_ctags_search; -drop function swh_content_language_add; -drop function swh_mktemp_content_language(); -drop function swh_mktemp_content_ctags(); -drop function swh_content_ctags_add(); -drop function swh_content_ctags_search; +drop type if exists content_ctags_signature; -drop index content_language_pkey; +drop table if exists content_language; +drop table if exists content_ctags; -drop table content_language; -drop table content_ctags; - -drop type languages; -drop type ctags_languages; -drop type content_ctags_signature; +drop type if exists languages; +drop type if exists ctags_languages;