181.sql
No OneTemporary
Actions

Size

661 B

Subscribers

None

181.sql
View Options

	-- SWH DB schema upgrade
	-- from_version: 180
	-- to_version: 181
	-- description: add *_raw_manifest_not_null indexes

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

	-- copied from 60-indexes.sql
	select swh_get_dbflavor() = 'default' as dbflavor_default \gset

	\if :dbflavor_default
	create index concurrently directory_raw_manifest_not_null on directory(id) where raw_manifest is not null;
	create index concurrently revision_raw_manifest_not_null on revision(id) where raw_manifest is not null;
	create index concurrently release_raw_manifest_not_null on release(id) where raw_manifest is not null;
	\endif

File Metadata

Mime Type: text/plain
Expires: Sat, Jun 21, 7:15 PM (2 w, 5 d ago)
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 3299265

Event Timeline