Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- USE spotify_stats;
- CREATE TABLE `spotify_history` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `track_id` varchar(50) NOT NULL,
- `track_type` varchar(50) NOT NULL,
- `track_name` varchar(255) NOT NULL,
- `track_duration_ms` int(11) NOT NULL,
- `track_explicit` boolean NOT NULL,
- `track_played_at` bigint unique NOT NULL,
- `track_history_id` varchar(50) NOT NULL,
- `track_album_id` varchar(50) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
- CREATE TABLE `spotify_albums` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `album_id` varchar(50) unique NOT NULL,
- `album_artists` text NOT NULL,
- `album_images` text NOT NULL,
- `album_name` varchar(255) NOT NULL,
- `album_type` varchar(255) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
- CREATE TABLE `spotify_artists` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `artist_id` varchar(50) unique NOT NULL,
- `artist_name` varchar(255) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
- CREATE TABLE `spotify_history_ids` (
- `id` int(10) unsigned unique NOT NULL AUTO_INCREMENT,
- `history_id` varchar(50) NOT NULL,
- `track_artists` varchar(255) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement