daily pastebin goal
41%
SHARE
TWEET

Untitled

a guest Jan 11th, 2019 59 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. USE spotify_stats;
  2. CREATE TABLE `spotify_history` (
  3.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  4.   `track_id` varchar(50) NOT NULL,
  5.   `track_type` varchar(50) NOT NULL,
  6.   `track_name` varchar(255) NOT NULL,
  7.   `track_duration_ms` int(11) NOT NULL,
  8.   `track_explicit` boolean NOT NULL,
  9.   `track_played_at` bigint unique NOT NULL,
  10.      `track_history_id` varchar(50) NOT NULL,
  11.   `track_album_id` varchar(50) NOT NULL,
  12.   PRIMARY KEY (`id`)
  13. ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  14.  
  15. CREATE TABLE `spotify_albums` (
  16.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  17.   `album_id` varchar(50) unique NOT NULL,
  18.   `album_artists` text NOT NULL,
  19.   `album_images` text NOT NULL,
  20.   `album_name` varchar(255) NOT NULL,
  21.   `album_type` varchar(255) NOT NULL,
  22.   PRIMARY KEY (`id`)
  23. ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  24.  
  25. CREATE TABLE `spotify_artists` (
  26.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  27.   `artist_id` varchar(50) unique NOT NULL,
  28.   `artist_name` varchar(255) NOT NULL,
  29.   PRIMARY KEY (`id`)
  30. ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  31.  
  32.     CREATE TABLE `spotify_history_ids` (
  33.       `id` int(10) unsigned unique NOT NULL AUTO_INCREMENT,
  34.       `history_id` varchar(50) NOT NULL,
  35.       `track_artists` varchar(255) NOT NULL,
  36.       PRIMARY KEY (`id`)
  37.     ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top