F9BzQC22

1/*DROP DATABASE IF EXISTS spotify_stats;*/
2CREATE DATABASE IF NOT EXISTS spotify_stats;
3USE spotify_stats;
4CREATE TABLE `spotify_history` (
5  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
6  `track_id` varchar(50) NOT NULL,
7  `track_type` varchar(50) NOT NULL,
8  `track_name` varchar(255) NOT NULL,
9  `track_duration_ms` int(11) NOT NULL,
10  `track_explicit` boolean NOT NULL,
11  `track_played_at` bigint unique NOT NULL,
12  `track_artists` text NOT NULL,
13  `track_album_id` varchar(50) NOT NULL,
14  PRIMARY KEY (`id`)
15) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
16
17CREATE TABLE `spotify_albums` (
18  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
19  `album_id` varchar(50) unique NOT NULL,
20  `album_artists` text NOT NULL,
21  `album_images` text NOT NULL,
22  `album_name` varchar(255) NOT NULL,
23  `album_type` varchar(255) NOT NULL,
24  PRIMARY KEY (`id`)
25) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
26
27CREATE TABLE `spotify_artists` (
28  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
29  `artist_id` varchar(50) unique NOT NULL,
30  `artist_name` varchar(255) NOT NULL,
31  PRIMARY KEY (`id`)
32) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;