Add full index on namespaces for type and id and remove partial index

See merge request gitlab-org/gitlab!71845