create index if not exists artist__gid_idx on artist (gid);

create index if not exists artist_alias__artist_idx on artist_alias (artist);

create index if not exists artist_credit_name__artist_credit_idx on artist_credit_name (artist_credit);
create index if not exists artist_credit_name__artist_idx on artist_credit_name (artist_credit);

create index if not exists artist_tag__tag_idx on artist_tag (tag);
create index if not exists artist_tag__artist_idx on artist_tag (artist);

create index if not exists genre__gid_idx on genre (gid);

create index if not exists genre_alias__genre_idx on genre_alias (genre);

create index if not exists isrc__recording_idx on isrc (recording);

create index if not exists medium__gid_idx on medium (gid);
create index if not exists medium__release_idx on medium ("release");

create index if not exists recording__artist_credit_idx on recording (artist_credit);
create index if not exists recording__gid_idx on recording (gid);

create index if not exists recording_alias__recording_idx on recording_alias (recording);

create index if not exists recording_tag__tag_idx on recording_tag (tag);
create index if not exists recording_tag__recording_idx on recording_tag (recording);

create index if not exists release__artist_credit_idx on "release" (artist_credit);
create index if not exists release__gid_idx on "release" (gid);
create index if not exists release__release_group_idx on "release" (release_group);

create index if not exists release_alias__recording_idx on release_alias ("release");

create index if not exists release_group__artist_credit_idx on release_group (artist_credit);
create index if not exists release_group__gid_idx on release_group (gid);

create index if not exists release_group_alias__release_group_idx on release_group_alias (release_group);

create index if not exists release_group_tag__tag_idx on release_group_tag (tag);
create index if not exists release_group_tag__release_group_idx on release_group_tag (release_group);

create index if not exists release_tag__tag_idx on release_tag (tag);
create index if not exists release_tag__release_idx on release_tag ("release");

create index if not exists track__artist_credit_idx on track ("artist_credit");
create index if not exists track__gid_idx on track (gid);
create index if not exists track__medium_idx on track (medium);
create index if not exists track__recording_idx on track (recording);