Differential D8888 Diff 32071 swh/indexer/sql/upgrades/137.sql

Changeset View

Standalone View

				-- 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 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 index content_language_pkey;

				drop table content_language;
				drop table content_ctags;
				ardumontUnsubmitted Not Done Inline Actions @olasd @zack shall we drop those tables once and for all (and no longer look back)? ardumont: @olasd @zack shall we drop those tables once and for all (and no longer look back)?
				olasdUnsubmitted Not Done Inline Actions The `content_ctags` table is empty in prod. The `content_language` table is, er, full of creative data that doesn't really have any relationship to reality. I think they're best gone. olasd: The `content_ctags` table is empty in prod. The `content_language` table is, er, full of…
				ardumontUnsubmitted Not Done Inline Actions Fine then! I should have checked their data indeed prior to me pinging you. Memory served me badly this time, i remembered it was just not empty... ardumont: Fine then! I should have checked their data indeed prior to me pinging you. Memory served me…

				drop type languages;
				drop type ctags_languages;
				drop type content_ctags_signature;