Skip to main content

Browse the archive

Revision 41d3930928779059438466dd94a6e7ad368dc64f authored by Jenkins for Software Heritage on 16 May 2019, 12:09:03 UTC, committed by Jenkins for Software Heritage on 16 May 2019, 12:09:03 UTC 
New upstream version 0.0.140
2 parent s e9c9dd7 + 02134a7
Raw File
061.sql 
-- SWH DB schema upgrade
-- from_version: 60
-- to_version: 61
-- description: Drop temporary tables related to entities on commit

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

CREATE OR REPLACE FUNCTION swh_mktemp_entity_history() RETURNS void
    LANGUAGE sql
    AS $$
    create temporary table tmp_entity_history (
        like entity_history including defaults) on commit drop;
    alter table tmp_entity_history drop column id;
$$;

CREATE OR REPLACE FUNCTION swh_mktemp_entity_lister() RETURNS void
    LANGUAGE sql
    AS $$
    create temporary table tmp_entity_lister (
        id bigint,
        lister uuid,
	lister_metadata jsonb
    ) on commit drop;
$$;
back to top