125.sql
-- 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'
);
$$;