# Restoring Component db lost all indexes, Nexus oss 3.22.0

**URL:** https://community.sonatype.com/t/restoring-component-db-lost-all-indexes-nexus-oss-3-22-0/4767
**Category:** Sonatype Nexus Repository
**Tags:** nexus-repository
**Created:** [August 23, 2020, 4:55pm UTC](https://community.sonatype.com/t/restoring-component-db-lost-all-indexes-nexus-oss-3-22-0/4767 "2020-08-23T16:55:49Z")
**Posts on this page:** 1
**Showing post:** 4

<div class="post-metadata">

### Author: ![my.ravisoni](https://avatars.discourse-cdn.com/v4/letter/m/8491ac/32.png) [@my.ravisoni](https://community.sonatype.com/u/my.ravisoni)
#### Post date: [August 25, 2020, 5:00pm UTC](https://community.sonatype.com/t/restoring-component-db-lost-all-indexes-nexus-oss-3-22-0/4767/4 "2020-08-25T17:00:52Z")

</div>

Belows are OrientDB create index command to restore index in database

create index asset\_bucket\_component\_name\_idx on asset (bucket, component, name)UNIQUE  
create index asset\_bucket\_name\_idx on asset (bucket, name) NOTUNIQUE  
create index asset\_component\_idx on asset (component collate default) NOTUNIQUE  
create index asset\_name\_ci\_idx on asset (name collate ci) NOTUNIQUE  
create index browse\_node\_asset\_id\_idx on browse\_node (asset\_id collate default) UNIQUE  
create index browse\_node\_component\_id\_idx on browse\_node (component\_id collate default) NOTUNIQUE  
create index browse\_node\_repository\_name\_parent\_path\_name\_idx on browse\_node (repository\_name, parent\_path, name) UNIQUE  
create index bucket\_repository\_name\_idx on bucket (repository\_name collate default) UNIQUE  
create index component\_bucket\_group\_name\_version\_idx on component (bucket, group, name, version) UNIQUE  
create index component\_bucket\_name\_version\_idx on component (bucket, name, version) NOTUNIQUE  
create index component\_ci\_name\_ci\_idx on component (ci\_name collate ci) NOTUNIQUE  
create index component\_group\_name\_version\_ci\_idx on component (group, name,version) NOTUNIQUE  
create index docker\_foreign\_layers\_digest\_idx on docker\_foreign\_layers (digest collate default) UNIQUE  
create index OFunction.name on OFunction (name collate default) UNIQUE\_HASH\_INDEX  
create index ORole.name on ORole (name collate ci) UNIQUE  
create index OUser.name on OUser (name collate ci) UNIQUE  
create index statushealthcheck\_node\_id\_idx on statushealthcheck (node\_id collate ci) UNIQUE

---

_[View the full topic](https://community.sonatype.com/t/restoring-component-db-lost-all-indexes-nexus-oss-3-22-0/4767)._