request-bot/drizzle/0003_catalog_metadata_enrichment.sql at f4ea58dd16a2ce1c496a162d98a7744327ab1013 · Jamesllllllllll/request-bot · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
-- Custom SQL migration file, put your code below! --
ALTER TABLE `catalog_songs`
ADD COLUMN `artist_id` integer;

ALTER TABLE `catalog_songs`
ADD COLUMN `author_id` integer;

ALTER TABLE `catalog_songs`
ADD COLUMN `grouped_project_id` integer;

ALTER TABLE `catalog_songs`
ADD COLUMN `tags_json` text;

ALTER TABLE `catalog_songs`
ADD COLUMN `genres_json` text;

ALTER TABLE `catalog_songs`
ADD COLUMN `subgenres_json` text;

ALTER TABLE `catalog_songs`
ADD COLUMN `lead_tuning_id` integer;

ALTER TABLE `catalog_songs`
ADD COLUMN `rhythm_tuning_id` integer;

ALTER TABLE `catalog_songs`
ADD COLUMN `bass_tuning_id` integer;

ALTER TABLE `catalog_songs`
ADD COLUMN `alt_lead_tuning_id` integer;

ALTER TABLE `catalog_songs`
ADD COLUMN `alt_rhythm_tuning_id` integer;

ALTER TABLE `catalog_songs`
ADD COLUMN `alt_bass_tuning_id` integer;

ALTER TABLE `catalog_songs`
ADD COLUMN `bonus_lead_tuning_id` integer;

ALTER TABLE `catalog_songs`
ADD COLUMN `bonus_rhythm_tuning_id` integer;

ALTER TABLE `catalog_songs`
ADD COLUMN `bonus_bass_tuning_id` integer;

CREATE INDEX `catalog_songs_artist_id_idx` ON `catalog_songs` (`artist_id`);
CREATE INDEX `catalog_songs_author_id_idx` ON `catalog_songs` (`author_id`);