Skip to main content

Browse the archive

Revision 6064a316fd1350b520361ae2cf15cb7e992880ee authored by Antoine R. Dumont (@ardumont) on 03 April 2019, 09:28:34 UTC, committed by Antoine R. Dumont (@ardumont) on 03 April 2019, 13:06:02 UTC 
api.{client,server}: Remove dead code about entity
1 parent 907c4ad
Raw File
076.sql 
-- SWH DB schema upgrade
-- from_version: 75
-- to_version: 76
-- description: Add a metadata column for origin_visit

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

ALTER TABLE origin_visit
	ADD COLUMN metadata jsonb;

COMMENT ON COLUMN origin_visit.metadata IS 'Metadata associated with the visit';

CREATE OR REPLACE FUNCTION swh_visit_get(origin bigint) RETURNS origin_visit
    LANGUAGE sql STABLE
    AS $$
    select *
    from origin_visit
    where origin=origin
    order by date desc
$$;
back to top