Revision 6ef7a9288aaec82eb0c49e4991266b3dbb13e5a6 authored by Jenkins for Software Heritage on 07 August 2020, 10:49:28 UTC, committed by Jenkins for Software Heritage on 07 August 2020, 10:49:28 UTC
1 parent 5e10f66
Raw File
144.sql
-- SWH DB schema upgrade
-- from_version: 143
-- to_version: 144
-- description: add index on sha1(origin.url)

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

create index concurrently on origin using btree(digest(url, 'sha1'));

back to top