No OneTemporary
Actions

Size

1 KB

Subscribers

None

View Options

	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;