mia.omg.lol
A Wrapped / Replay like for teal.fm and rocksky.app (currently on hiatus)
1create index if not exists artist__gid_idx on artist (gid);
2
3create index if not exists artist_alias__artist_idx on artist_alias (artist);
4
5create index if not exists artist_credit_name__artist_credit_idx on artist_credit_name (artist_credit);
6create index if not exists artist_credit_name__artist_idx on artist_credit_name (artist_credit);
7
8create index if not exists artist_tag__tag_idx on artist_tag (tag);
9create index if not exists artist_tag__artist_idx on artist_tag (artist);
10
11create index if not exists genre__gid_idx on genre (gid);
12
13create index if not exists genre_alias__genre_idx on genre_alias (genre);
14
15create index if not exists isrc__recording_idx on isrc (recording);
16
17create index if not exists medium__gid_idx on medium (gid);
18create index if not exists medium__release_idx on medium ("release");
19
20create index if not exists recording__artist_credit_idx on recording (artist_credit);
21create index if not exists recording__gid_idx on recording (gid);
22
23create index if not exists recording_alias__recording_idx on recording_alias (recording);
24
25create index if not exists recording_tag__tag_idx on recording_tag (tag);
26create index if not exists recording_tag__recording_idx on recording_tag (recording);
27
28create index if not exists release__artist_credit_idx on "release" (artist_credit);
29create index if not exists release__gid_idx on "release" (gid);
30create index if not exists release__release_group_idx on "release" (release_group);
31
32create index if not exists release_alias__recording_idx on release_alias ("release");
33
34create index if not exists release_group__artist_credit_idx on release_group (artist_credit);
35create index if not exists release_group__gid_idx on release_group (gid);
36
37create index if not exists release_group_alias__release_group_idx on release_group_alias (release_group);
38
39create index if not exists release_group_tag__tag_idx on release_group_tag (tag);
40create index if not exists release_group_tag__release_group_idx on release_group_tag (release_group);
41
42create index if not exists release_tag__tag_idx on release_tag (tag);
43create index if not exists release_tag__release_idx on release_tag ("release");
44
45create index if not exists track__artist_credit_idx on track ("artist_credit");
46create index if not exists track__gid_idx on track (gid);
47create index if not exists track__medium_idx on track (medium);
48create index if not exists track__recording_idx on track (recording);