071.sql
No OneTemporary
Actions

Size

687 B

Subscribers

None

071.sql
View Options

	-- SWH DB schema upgrade
	-- from_version: 70
	-- to_version: 71
	-- description: Create indexes for object_ids.

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

	CREATE INDEX content_object_id_idx ON content USING btree (object_id);

	CREATE INDEX directory_object_id_idx ON directory USING btree (object_id);

	CREATE INDEX occurrence_history_object_id_idx ON occurrence_history USING btree (object_id);

	CREATE INDEX release_object_id_idx ON "release" USING btree (object_id);

	CREATE INDEX revision_object_id_idx ON revision USING btree (object_id);

	CREATE INDEX skipped_content_object_id_idx ON skipped_content USING btree (object_id);

File Metadata

Mime Type: text/plain
Expires: Sat, Jun 21, 5:20 PM (1 w, 4 d ago)
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 3281978

Event Timeline