Page Menu
Home
Software Heritage
Search
Configure Global Search
Log In
Files
F9124550
181.sql
No One
Temporary
Actions
View File
Edit File
Delete File
View Transforms
Subscribe
Mute Notifications
Award Token
Flag For Later
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
Details
Attached
Mime Type
text/plain
Expires
Sat, Jun 21, 7:15 PM (2 w, 3 d ago)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
3299265
Attached To
rDSTO Storage manager
Event Timeline
Log In to Comment