Differential D7937 Diff 28596 swh/indexer/sql/upgrades/134.sql

Changeset View

Standalone View

				-- SWH Indexer DB schema upgrade
				-- from_version: 133
				-- to_version: 134
				-- description: replace revision_intrinsic_metadata with directory_intrinsic_metadata
				-- and origin_intrinsic_metadata.from_revision with origin_intrinsic_metadata.from_directory
				-- This migration works by dropping both tables and reindexing from scratch.

				insert into dbversion(version, release, description)
				values(134, now(), 'Work In Progress');

				drop table origin_intrinsic_metadata;
				drop table revision_intrinsic_metadata;
				drop function swh_revision_intrinsic_metadata_add;
				drop function swh_mktemp_revision_intrinsic_metadata;

				\ir '../30-schema.sql'
				\ir '../50-func.sql'
				\ir '../60-indexes.sql'
				ardumontUnsubmitted Not Done Inline Actions good idea providing those are idempotent (i have some doubt regarding schema and higher doubts about indexes). ardumont: good idea providing those are idempotent (i have some doubt regarding schema and higher doubts…