-- --------------------------------------------------------
-- Server OS:                    Win64
-- HeidiSQL Version:             12.10.0.7000
-- --------------------------------------------------------



-- Dumping database structure for jamswipe
CREATE DATABASE IF NOT EXISTS `jamswipe` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */;
USE `jamswipe`;

-- Dumping structure for table jamswipe.albums
CREATE TABLE IF NOT EXISTS `albums` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(250) NOT NULL,
  `artist` int(11) NOT NULL,
  `genre` int(11) NOT NULL,
  `artworkPath` varchar(500) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_albums_artists` (`artist`),
  KEY `FK_albums_genres` (`genre`),
  CONSTRAINT `FK_albums_artists` FOREIGN KEY (`artist`) REFERENCES `artists` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_albums_genres` FOREIGN KEY (`genre`) REFERENCES `genres` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table jamswipe.albums: ~5 rows (approximately)
INSERT INTO `albums` (`id`, `title`, `artist`, `genre`, `artworkPath`) VALUES
	(1, 'This Is Harris Keller', 1, 4, 'assets/images/artwork/faceless.jpg'),
	(2, 'This Is Kevin MacLeod', 2, 2, 'assets/images/artwork/music.jpg'),
	(3, 'This Is Liborio Conti', 3, 3, 'assets/images/artwork/goofy.jpg'),
	(4, 'This Is Silent Partner', 4, 5, 'assets/images/artwork/falling.jpg'),
	(5, 'We Are StreamBeats Original', 5, 1, 'assets/images/artwork/anarchy.jpg');

-- Dumping structure for table jamswipe.artists
CREATE TABLE IF NOT EXISTS `artists` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table jamswipe.artists: ~5 rows (approximately)
INSERT INTO `artists` (`id`, `name`) VALUES
	(1, 'Harris Keller'),
	(2, 'Kevin MacLeod'),
	(3, 'Liborio Conti'),
	(4, 'Silent Partner'),
	(5, 'StreamBeats Originals');

-- Dumping structure for table jamswipe.genres
CREATE TABLE IF NOT EXISTS `genres` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table jamswipe.genres: ~5 rows (approximately)
INSERT INTO `genres` (`id`, `name`) VALUES
	(1, 'Rock'),
	(2, 'Pop'),
	(3, 'Reggae'),
	(4, 'Rap'),
	(5, 'Techno'),
	(6, 'Dance');

-- Dumping structure for table jamswipe.playlists
CREATE TABLE IF NOT EXISTS `playlists` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `owner` varchar(50) NOT NULL,
  `dateCreated` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table jamswipe.playlists: ~2 rows (approximately)
INSERT INTO `playlists` (`id`, `name`, `owner`, `dateCreated`) VALUES
	(8, ' bam', 'test123', '2025-02-04 00:00:00');

-- Dumping structure for table jamswipe.playlistsongs
CREATE TABLE IF NOT EXISTS `playlistsongs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `songId` int(11) NOT NULL,
  `playlistId` int(11) NOT NULL,
  `playlistOrder` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_playlistsongs_songs` (`songId`),
  KEY `FK_playlistsongs_playlists` (`playlistId`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table jamswipe.playlistsongs: ~5 rows (approximately)
INSERT INTO `playlistsongs` (`id`, `songId`, `playlistId`, `playlistOrder`) VALUES
	(10, 13, 8, 1),
	(11, 14, 8, 2),
	(12, 15, 8, 3),
	(13, 10, 8, 4),
	(14, 11, 8, 5);

-- Dumping structure for table jamswipe.songs
CREATE TABLE IF NOT EXISTS `songs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(250) NOT NULL,
  `artist` int(11) NOT NULL,
  `album` int(11) NOT NULL,
  `genre` int(11) NOT NULL,
  `duration` varchar(8) NOT NULL,
  `path` varchar(500) NOT NULL,
  `albumOrder` int(11) NOT NULL,
  `plays` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_songs_artists` (`artist`),
  KEY `FK_songs_albums` (`album`),
  KEY `FK_songs_genres` (`genre`),
  CONSTRAINT `FK_songs_albums` FOREIGN KEY (`album`) REFERENCES `albums` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK_songs_artists` FOREIGN KEY (`artist`) REFERENCES `artists` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK_songs_genres` FOREIGN KEY (`genre`) REFERENCES `genres` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table jamswipe.songs: ~15 rows (approximately)
INSERT INTO `songs` (`id`, `title`, `artist`, `album`, `genre`, `duration`, `path`, `albumOrder`, `plays`) VALUES
	(1, 'Fjord', 1, 1, 5, '2:17', 'assets/music/Harris Keller - Fjord.mp3', 1, 5),
	(2, 'Never Be The Same', 1, 1, 5, '3:48', 'assets/music/Harris Keller - Never Be The Same.mp3', 2, 4),
	(3, 'Wreck', 1, 1, 5, '3:17', 'assets/music/Harris Keller - Wreck.mp3', 3, 4),
	(4, 'Blippy Trance', 2, 2, 1, '2:00', 'assets/music/Kevin MacLeod - Blippy Trance.mp3', 1, 9),
	(5, 'Stompin At Midnight', 2, 2, 1, '1:57', 'assets/music/Kevin MacLeod - Stompin at Midnight.mp3', 2, 11),
	(6, 'Swing Machine', 2, 2, 1, '2:14', 'assets/music/Kevin MacLeod - Swing Machining.mp3', 3, 9),
	(7, 'You Found Me', 3, 3, 4, '3:39', 'assets/music/Liborio Conti - You Found Me.mp3', 1, 10),
	(8, 'Reggae', 3, 3, 4, '3:43', 'assets/music/Liborio Conti - Reggae.mp3', 2, 5),
	(9, 'Run Away', 3, 3, 4, '3:20', 'assets/music/Liborio Conti - Run Away.mp3', 3, 6),
	(10, 'Alright', 4, 4, 3, '2:22', 'assets/music/Silent Partner - Alright.mp3', 1, 5),
	(11, 'Back In Town', 4, 4, 3, '1:51', 'assets/music/Silent Partner - Back In Town.mp3', 2, 4),
	(12, 'Crispy', 4, 4, 3, '2:06', 'assets/music/Silent Partner - Crispy.mp3', 3, 4),
	(13, 'Demon', 5, 5, 2, '2:44', 'assets/music/StreamBeats Originals - Demon.mp3', 1, 9),
	(14, 'Kill It Anyway', 5, 5, 2, '2:48', 'assets/music/StreamBeats Originals - Kill It Anyway.mp3', 2, 11),
	(15, 'What If', 5, 5, 2, '3:33', 'assets/music/StreamBeats Originals - What If.mp3', 3, 8);

