135.sql
No OneTemporary
Actions

Size

447 B

Subscribers

None

135.sql
View Options

	-- SWH DB schema upgrade
	-- from_version: 134
	-- to_version: 135
	-- description: Add an index on origin.url, drop the index on (origin.type, origin.url)

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

	create extension if not exists pg_trgm;

	drop index origin_type_url_idx;
	create index concurrently on origin using gin (url gin_trgm_ops);
	create index concurrently on origin using hash (url);