125.sql
No OneTemporary
Actions

Size

1 KB

Subscribers

None

125.sql
View Options

	-- SWH DB schema upgrade
	-- from_version: 124
	-- to_version: 125
	-- description: Drop useless entity tables

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

	DROP FUNCTION swh_entity_from_tmp_entity_lister();

	DROP FUNCTION swh_entity_get(entity_uuid uuid);

	DROP FUNCTION swh_entity_history_add();

	DROP FUNCTION swh_mktemp_entity_history();

	DROP FUNCTION swh_mktemp_entity_lister();

	DROP FUNCTION swh_update_entity_from_entity_history() cascade;

	ALTER TABLE origin
	DROP COLUMN lister,
	DROP COLUMN project;

	DROP TABLE list_history;

	DROP TABLE listable_entity;

	DROP TABLE entity_equivalence;

	DROP TABLE entity;

	DROP TABLE entity_history;

	DROP TYPE entity_id;

	DROP TYPE entity_type;

	CREATE OR REPLACE FUNCTION swh_stat_counters() RETURNS SETOF public.counter
	LANGUAGE sql STABLE
	AS $$
	select object_type as label, value as value
	from object_counts
	where object_type in (
	'content',
	'directory',
	'directory_entry_dir',
	'directory_entry_file',
	'directory_entry_rev',
	'occurrence_history',
	'origin',
	'origin_visit',
	'person',
	'release',
	'revision',
	'revision_history',
	'skipped_content',
	'snapshot'
	);
	$$;