qVAT6ZgX

1-- --------------------------------------------------------
2-- Host:                         localhost
3-- Server version:               10.2.3-MariaDB-log - mariadb.org binary distribution
4-- Server OS:                    Win32
5-- HeidiSQL Version:             9.4.0.5125
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14-- Dumping structure for table guessthesong.artists
15CREATE TABLE IF NOT EXISTS `artists` (
16  `id` int(11) NOT NULL AUTO_INCREMENT,
17  `spotify_id` varchar(50) DEFAULT NULL,
18  `name` varchar(50) DEFAULT NULL,
19  PRIMARY KEY (`id`)
20) ENGINE=InnoDB AUTO_INCREMENT=544 DEFAULT CHARSET=latin1;
21
22-- Data exporting was unselected.
23-- Dumping structure for table guessthesong.artist_tracks
24CREATE TABLE IF NOT EXISTS `artist_tracks` (
25  `id` int(11) NOT NULL AUTO_INCREMENT,
26  `artist_id` int(11) NOT NULL,
27  `track_id` int(11) NOT NULL,
28  PRIMARY KEY (`id`),
29  KEY `FK_artist_tracks_artists` (`artist_id`),
30  KEY `FK_artist_tracks_tracks` (`track_id`),
31  CONSTRAINT `FK_artist_tracks_artists` FOREIGN KEY (`artist_id`) REFERENCES `artists` (`id`),
32  CONSTRAINT `FK_artist_tracks_tracks` FOREIGN KEY (`track_id`) REFERENCES `tracks` (`id`)
33) ENGINE=InnoDB AUTO_INCREMENT=211 DEFAULT CHARSET=latin1;
34
35-- Data exporting was unselected.
36-- Dumping structure for table guessthesong.tracks
37CREATE TABLE IF NOT EXISTS `tracks` (
38  `id` int(11) NOT NULL AUTO_INCREMENT,
39  `spotify_id` varchar(255) DEFAULT NULL,
40  `name` varchar(255) NOT NULL,
41  `explicit` tinyint(4) DEFAULT NULL,
42  `preview_url` varchar(255) DEFAULT NULL,
43  `artist_id` int(10) NOT NULL,
44  `image_url` varchar(255) DEFAULT NULL,
45  PRIMARY KEY (`id`),
46  UNIQUE KEY `spotify_id` (`spotify_id`),
47  KEY `FK_tracks_artists` (`artist_id`),
48  CONSTRAINT `FK_tracks_artists` FOREIGN KEY (`artist_id`) REFERENCES `artists` (`id`)
49) ENGINE=InnoDB AUTO_INCREMENT=846 DEFAULT CHARSET=latin1;
50
51-- Data exporting was unselected.
52/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
53/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
54/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;