/*
Navicat MySQL Data Transfer

Source Server         : 127.0.0.1
Source Server Version : 50505
Source Host           : 127.0.0.1:3306
Source Database       : islamictunes

Target Server Type    : MYSQL
Target Server Version : 50505
File Encoding         : 65001

Date: 2017-09-23 18:44:50
*/


-- ----------------------------
-- Table structure for events
-- ----------------------------
CREATE TABLE `events` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `event_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `event_title` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `posting_time` datetime NOT NULL,
  `posting_by` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `event_image` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `event_start` datetime NOT NULL,
  `event_end` datetime NOT NULL,
  `event_description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `event_location` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of events
-- ----------------------------
INSERT INTO `events` VALUES ('1', '1', 'Halal Bihalal', '2017-09-15 00:00:00', 'Islamic-admin', 'halal.img', '2017-09-23 13:44:01', '2017-09-30 13:44:14', 'Halal Bil Halal di Festival Citylink Mall Bandung 21 July 2017 – Jemput hadir semua!', 'Citylink Mall Bandung 21 July 2017', '1');
INSERT INTO `events` VALUES ('2', '2', 'Show Byhaq', '2017-09-15 13:49:02', 'Mukhlis New Editor', 'jubli.img', '2017-09-17 13:51:02', '2017-09-24 13:51:10', 'Mau kenal sama BYHAQ NASHEED secara langsung. Jom petang ini..!\r\n\r\nBagi Sahabat Nasyeed yang berada di Terengganu, Malaysia. Sisihkan waktu anda petang ini 5 Mei 2017 bersama BYHAQ, dalam acara Sambutan 25 Tahun jubli Perak Darul Bayan.\r\n\r\nPasti hari anda akan tergantikan, insyaallah…', 'Citylink Mall Bandung 21 July 2017', '1');

-- ----------------------------
-- Table structure for master_genre
-- ----------------------------
CREATE TABLE `master_genre` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `genre_id` int(11) DEFAULT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of master_genre
-- ----------------------------
INSERT INTO `master_genre` VALUES ('1', '1', 'Adzan');
INSERT INTO `master_genre` VALUES ('2', '2', 'Audio');
INSERT INTO `master_genre` VALUES ('3', '3', 'Audiobook');
INSERT INTO `master_genre` VALUES ('4', '4', 'Doa');
INSERT INTO `master_genre` VALUES ('5', '5', 'Dzikir');
INSERT INTO `master_genre` VALUES ('6', '6', 'Indie');
INSERT INTO `master_genre` VALUES ('7', '7', 'Islamic Pop');
INSERT INTO `master_genre` VALUES ('8', '8', 'Acoustic');
INSERT INTO `master_genre` VALUES ('9', '9', 'Pop Relegi');
INSERT INTO `master_genre` VALUES ('10', '10', 'Street Busking');
INSERT INTO `master_genre` VALUES ('11', '11', 'Murottal');
INSERT INTO `master_genre` VALUES ('12', '12', 'Nasheed');
INSERT INTO `master_genre` VALUES ('13', '13', 'Qasidah');
INSERT INTO `master_genre` VALUES ('14', '14', 'Zikir Munajat');
INSERT INTO `master_genre` VALUES ('15', '15', 'Selawat');
INSERT INTO `master_genre` VALUES ('16', '16', 'Tausiyah');
INSERT INTO `master_genre` VALUES ('17', '17', 'Tilawah');
INSERT INTO `master_genre` VALUES ('18', '18', 'World');

-- ----------------------------
-- Table structure for migrations
-- ----------------------------
CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of migrations
-- ----------------------------
INSERT INTO `migrations` VALUES ('10', '2014_10_12_000000_create_users_table', '1');
INSERT INTO `migrations` VALUES ('11', '2017_09_03_113435_create_music_album_table', '1');
INSERT INTO `migrations` VALUES ('12', '2017_09_03_113536_create_music_table', '1');
INSERT INTO `migrations` VALUES ('13', '2017_09_03_113704_create_music_artist_table', '1');
INSERT INTO `migrations` VALUES ('14', '2017_09_03_113758_create_music_genre_table', '1');
INSERT INTO `migrations` VALUES ('15', '2017_09_03_113842_create_music_video_table', '1');
INSERT INTO `migrations` VALUES ('16', '2017_09_03_114706_create_playlist_favorite_table', '1');
INSERT INTO `migrations` VALUES ('17', '2017_09_03_114813_create_master_genre_table', '1');
INSERT INTO `migrations` VALUES ('18', '2017_09_03_115004_create_events_table', '1');

-- ----------------------------
-- Table structure for music
-- ----------------------------
CREATE TABLE `music` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `music_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `album` int(10) NOT NULL,
  `artist` int(10) NOT NULL,
  `genre_id` int(10) NOT NULL,
  `music_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `music_image` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` double NOT NULL,
  `music_source_url` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of music
-- ----------------------------
INSERT INTO `music` VALUES ('1', 'mus_0001', '1', '1', '1', 'Adzan - Islamic Tunes', '-', '40000', 'islamictunes.id/backend/public/assets/music/Adzan-IslamicTunes.mp3', '1');
INSERT INTO `music` VALUES ('2', 'mus_0002', '1', '1', '1', 'Adzan - IslamicTunes2', '-', '40000', 'islamictunes.id/backend/public/assets/music/Adzan-IslamicTunes2.mp3', '1');
INSERT INTO `music` VALUES ('3', 'mus_0003', '1', '1', '1', 'Adzan - IslamicTunes3', '-', '35000', 'islamictunes.id/backend/public/assets/music/Adzan-IslamicTunes3.mp3', '1');
INSERT INTO `music` VALUES ('4', 'mus_0004', '2', '2', '6', 'Ya Rosulallah', '-', '35000', 'islamictunes.id/backend/public/assets/music/Ya_Rasulalloh.mp3', '1');
INSERT INTO `music` VALUES ('5', 'mus_0005', '2', '2', '6', 'Sholatulloh', '-', '35000', 'islamictunes.id/backend/public/assets/music/Sholatulloh.mp3', '1');
INSERT INTO `music` VALUES ('6', 'mus_0006', '2', '2', '6', 'Maulidu Ahmad', '-', '35000', 'islamictunes.id/backend/public/assets/music/Maulidu_Ahmad.mp3', '1');
INSERT INTO `music` VALUES ('7', 'mus_0007', '2', '2', '6', 'Kaifa', '-', '30000', 'islamictunes.id/backend/public/assets/music/Kaifa.mp3', '1');
INSERT INTO `music` VALUES ('8', 'mus_0008', '2', '2', '6', 'Cinta_Suci', '-', '30000', 'islamictunes.id/backend/public/assets/music/Cinta_Suci.mp3', '1');

-- ----------------------------
-- Table structure for music_album
-- ----------------------------
CREATE TABLE `music_album` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `album_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `publish_date` datetime NOT NULL,
  `album_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `album_image` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `album_artist` int(10) NOT NULL,
  `album_description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` double NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of music_album
-- ----------------------------
INSERT INTO `music_album` VALUES ('1', 'al_00001', '2017-08-08 00:00:00', 'Adzan', 'islamictunes.id/backend/public/assets/image/album/adzan-300x300.png', '1', 'Adzan dari seluruh dunia', '450000', '1');
INSERT INTO `music_album` VALUES ('2', 'al_00002', '2017-09-23 18:07:36', 'Rekoso (Hidup Semakin Sulit)', 'islamictunes.id/backend/public/assets/image/album/Rekoso_Hidup_semakin_sulit_214x300.jpg', '2', ' #dakwah, #islamicmusic, Album, indonesia, Islamic song, motivasi, musik, muslim, muslimah, nasyid, qasidah, Selawat, solois relegi, Tausiyah, Tilawah, zikir', '450000', '1');

-- ----------------------------
-- Table structure for music_artist
-- ----------------------------
CREATE TABLE `music_artist` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `artist_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `register_time` datetime NOT NULL,
  `artist_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `artist_image` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `artist_website` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `artist_bio` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `artist_country` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of music_artist
-- ----------------------------
INSERT INTO `music_artist` VALUES ('1', 'ar_0001', '2017-08-10 00:00:00', 'Adzan', 'islamictunes.id/backend/public/assets/image/artist/adzan-300x300.png', '-', 'Adzan Madinah Adhan from Hawai by Abderrahim Ed Adzan Masjid al Haram Adzan by Mishari Rashid al ‘Afasy Adzan Turkey Adzan UEA Adzan Bosnia Adzan Malaysia Adzan Mesir Adzan Misyari Rasyid Adzan Subuh Abu Hazim Adzan Yusuf Islam Afghanistan', '-', '1');
INSERT INTO `music_artist` VALUES ('2', 'ar_0002', '2017-09-23 17:55:02', 'Fasabaqna Group', '-', '-', '-', '-', '1');

-- ----------------------------
-- Table structure for music_genre
-- ----------------------------
CREATE TABLE `music_genre` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `album` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `genre_id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of music_genre
-- ----------------------------
INSERT INTO `music_genre` VALUES ('1', '1', '1');
INSERT INTO `music_genre` VALUES ('2', '2', '6');
INSERT INTO `music_genre` VALUES ('3', '2', '12');
INSERT INTO `music_genre` VALUES ('4', '2', '13');
INSERT INTO `music_genre` VALUES ('5', '2', '15');

-- ----------------------------
-- Table structure for playlist_favorite
-- ----------------------------
CREATE TABLE `playlist_favorite` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `music` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of playlist_favorite
-- ----------------------------
INSERT INTO `playlist_favorite` VALUES ('1', '1', '2', '2017-09-22 12:25:00', '2017-09-22 12:25:00');
INSERT INTO `playlist_favorite` VALUES ('3', '1', '3', '2017-09-22 13:23:52', '2017-09-22 13:23:52');

-- ----------------------------
-- Table structure for videos
-- ----------------------------
CREATE TABLE `videos` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `video_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `posting_time` datetime NOT NULL,
  `posting_by` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `video_img` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `video_caption` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `video_embed_url` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of videos
-- ----------------------------
INSERT INTO `videos` VALUES ('1', '1', '2017-09-15 15:47:47', 'Mukhlis', 'video1.jpg', 'ini video 1', 'https://www.youtube.com/watch?v=Hb1AqNydJe4', '1');
INSERT INTO `videos` VALUES ('2', '2', '2017-09-15 15:49:09', 'Admin', 'video1.jpg', 'ini video 2', 'https://www.youtube.com/watch?v=oQsT63ISNQ0', '1');
INSERT INTO `videos` VALUES ('3', '3', '2017-09-15 16:05:59', 'Admin', 'video1.jpg', 'ini video 3', 'https://www.youtube.com/watch?v=BAkXCbb_pxk', '1');
