-- phpMyAdmin SQL Dump
-- version 4.1.14
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Oct 27, 2014 at 05:31 PM
-- Server version: 5.6.17
-- PHP Version: 5.5.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `ci_music`
--

-- --------------------------------------------------------

--
-- Table structure for table `music_admin_notify`
--

CREATE TABLE IF NOT EXISTS `music_admin_notify` (
  `set_notify_id` int(10) NOT NULL AUTO_INCREMENT,
  `set_notify_content` text COLLATE utf8_unicode_ci NOT NULL,
  `set_notify_datecreat` int(20) NOT NULL,
  PRIMARY KEY (`set_notify_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `music_admin_notify`
--

INSERT INTO `music_admin_notify` (`set_notify_id`, `set_notify_content`, `set_notify_datecreat`) VALUES
(1, 'Welcome to CI Music PersianScript', 1412667006);

-- --------------------------------------------------------

--
-- Table structure for table `music_album`
--

CREATE TABLE IF NOT EXISTS `music_album` (
  `al_id` int(10) NOT NULL AUTO_INCREMENT,
  `al_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `al_keyword` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `al_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `al_description` text COLLATE utf8_unicode_ci NOT NULL,
  `al_image` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `al_content` text COLLATE utf8_unicode_ci NOT NULL,
  `al_views` int(10) NOT NULL DEFAULT '0',
  `al_date_create` int(20) NOT NULL,
  `al_date_update` int(20) NOT NULL,
  PRIMARY KEY (`al_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Album - Update v1.1' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `music_category`
--

CREATE TABLE IF NOT EXISTS `music_category` (
  `cat_id` int(10) NOT NULL AUTO_INCREMENT,
  `cat_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cat_keyword` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cat_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cat_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cat_tag` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cat_img` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cat_type` tinyint(1) NOT NULL,
  PRIMARY KEY (`cat_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Category Music' AUTO_INCREMENT=4 ;

--
-- Dumping data for table `music_category`
--

INSERT INTO `music_category` (`cat_id`, `cat_name`, `cat_keyword`, `cat_description`, `cat_url`, `cat_tag`, `cat_img`, `cat_type`) VALUES
(1, 'Audio', 'Audio', 'Audio', 'Audio', '2', 'Audio.jpg', 1),
(2, 'Video', 'video', 'video', 'video', '1', 'Audio.jpg', 2);

-- --------------------------------------------------------

--
-- Table structure for table `music_ci_sessions`
--

CREATE TABLE IF NOT EXISTS `music_ci_sessions` (
  `session_id` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `ip_address` varchar(45) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `user_agent` varchar(120) COLLATE utf8_unicode_ci NOT NULL,
  `last_activity` int(10) unsigned NOT NULL DEFAULT '0',
  `user_data` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`session_id`),
  KEY `last_activity_idx` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `music_ci_sessions`
--

INSERT INTO `music_ci_sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`, `user_data`) VALUES
('4de948f3f890d326615d413a4a43bdb2', '::1', 'Mozilla/5.0 (Windows NT 6.3; WOW64; rv:34.0) Gecko/20100101 Firefox/34.0', 1414423404, ''),
('8eabb558f8f0f691ceb702ae95bd4b74', '::1', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/38.0.2125.104 Safari/537.36', 1414427257, 'a:7:{s:9:"user_data";s:0:"";s:8:"identity";s:15:"admin@admin.com";s:8:"username";s:5:"admin";s:5:"email";s:15:"admin@admin.com";s:7:"user_id";s:1:"1";s:14:"old_last_login";s:10:"1414420510";s:11:"admin_login";b:1;}'),
('bbf719080e18d0fd2e7bbeb4ecbea7ab', '::1', 'Mozilla/5.0 (Windows NT 6.3; WOW64; rv:34.0) Gecko/20100101 Firefox/34.0', 1414423404, '');

-- --------------------------------------------------------

--
-- Table structure for table `music_comment`
--

CREATE TABLE IF NOT EXISTS `music_comment` (
  `cm_id` int(10) NOT NULL AUTO_INCREMENT,
  `cm_type` int(1) NOT NULL,
  `cm_uid` int(10) NOT NULL,
  `cm_to` int(10) NOT NULL,
  `cm_text` text COLLATE utf8_unicode_ci NOT NULL,
  `cm_datecreat` int(20) NOT NULL,
  PRIMARY KEY (`cm_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Comment' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `music_follow`
--

CREATE TABLE IF NOT EXISTS `music_follow` (
  `fo_id` int(10) NOT NULL AUTO_INCREMENT,
  `u_id` int(10) NOT NULL,
  `u_following` int(10) NOT NULL,
  PRIMARY KEY (`fo_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Follow' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `music_friend`
--

CREATE TABLE IF NOT EXISTS `music_friend` (
  `fr_id` int(10) NOT NULL AUTO_INCREMENT,
  `u_id` int(10) NOT NULL,
  `u_fr` text COLLATE utf8_unicode_ci NOT NULL,
  `fr_status` int(1) NOT NULL,
  PRIMARY KEY (`fr_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='friend' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `music_groups`
--

CREATE TABLE IF NOT EXISTS `music_groups` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL,
  `description` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `music_groups`
--

INSERT INTO `music_groups` (`id`, `name`, `description`) VALUES
(1, 'admin', 'Administrator'),
(2, 'members', 'General User');

-- --------------------------------------------------------

--
-- Table structure for table `music_like_song`
--

CREATE TABLE IF NOT EXISTS `music_like_song` (
  `l_id` int(10) NOT NULL AUTO_INCREMENT,
  `u_like` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`l_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Like Song' AUTO_INCREMENT=21 ;

--
-- Dumping data for table `music_like_song`
--

INSERT INTO `music_like_song` (`l_id`, `u_like`) VALUES
(1, '0'),
(2, '0'),
(3, '0'),
(4, '0'),
(5, '0'),
(6, '0'),
(7, '0'),
(8, '0'),
(9, '0'),
(10, '0'),
(11, '0'),
(12, '0'),
(13, '0'),
(14, '0'),
(15, '0'),
(16, '0'),
(17, '0'),
(18, '0'),
(19, '0'),
(20, '0');

-- --------------------------------------------------------

--
-- Table structure for table `music_login_attempts`
--

CREATE TABLE IF NOT EXISTS `music_login_attempts` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `ip_address` varchar(15) NOT NULL,
  `login` varchar(100) NOT NULL,
  `time` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `music_lyrics_song`
--

CREATE TABLE IF NOT EXISTS `music_lyrics_song` (
  `ly_id` int(10) NOT NULL AUTO_INCREMENT,
  `u_id` int(10) NOT NULL,
  `ly_text` text COLLATE utf8_unicode_ci NOT NULL,
  `ly_date_creat` int(20) NOT NULL,
  `ly_date_update` int(20) NOT NULL,
  PRIMARY KEY (`ly_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Lyrics Song' AUTO_INCREMENT=21 ;

--
-- Dumping data for table `music_lyrics_song`
--

INSERT INTO `music_lyrics_song` (`ly_id`, `u_id`, `ly_text`, `ly_date_creat`, `ly_date_update`) VALUES
(1, 1, '', 1412661135, 1412661135),
(2, 1, '', 1412661471, 1412661471),
(3, 1, '', 1412661895, 1412661895),
(4, 1, '', 1412662292, 1412662292),
(5, 1, '', 1412662548, 1412662548),
(6, 1, '', 1412662738, 1412662738),
(7, 1, '', 1412662930, 1412662930),
(8, 1, '', 1412663136, 1412663136),
(9, 1, '', 1412663269, 1412663269),
(10, 1, '', 1412663421, 1412663421),
(11, 1, '', 1412663553, 1412663553),
(12, 1, '', 1412663719, 1412663719),
(13, 1, '', 1412663960, 1412664258),
(14, 1, '', 1412664509, 1412664509),
(15, 1, '', 1412664769, 1412664769),
(16, 1, '', 1412664936, 1412665640),
(17, 1, '', 1412665068, 1412665068),
(18, 1, '', 1412665150, 1412665150),
(19, 1, '', 1412665347, 1412665347),
(20, 1, '', 1412665483, 1414312859);

-- --------------------------------------------------------

--
-- Table structure for table `music_notify`
--

CREATE TABLE IF NOT EXISTS `music_notify` (
  `n_id` int(10) NOT NULL AUTO_INCREMENT,
  `n_from` int(10) NOT NULL,
  `n_to` int(10) NOT NULL,
  `n_messages` text COLLATE utf8_unicode_ci NOT NULL,
  `n_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `n_datecreat` int(20) NOT NULL,
  `n_type` int(1) NOT NULL,
  `n_status` int(1) NOT NULL,
  PRIMARY KEY (`n_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Notify User' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `music_playlist`
--

CREATE TABLE IF NOT EXISTS `music_playlist` (
  `pl_id` int(10) NOT NULL AUTO_INCREMENT,
  `pl_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `pl_keyword` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `pl_img` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `pl_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `pl_views` int(10) NOT NULL DEFAULT '0',
  `pl_views_week` int(10) NOT NULL DEFAULT '0',
  `pl_views_month` int(10) NOT NULL DEFAULT '0',
  `pl_views_year` int(10) NOT NULL DEFAULT '0',
  `u_id` int(10) NOT NULL,
  `s_id` text COLLATE utf8_unicode_ci,
  `pl_datecreat` int(20) DEFAULT NULL,
  PRIMARY KEY (`pl_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Playlist For User' AUTO_INCREMENT=3 ;

--
-- Dumping data for table `music_playlist`
--

INSERT INTO `music_playlist` (`pl_id`, `pl_name`, `pl_keyword`, `pl_img`, `pl_url`, `pl_views`, `pl_views_week`, `pl_views_month`, `pl_views_year`, `u_id`, `s_id`, `pl_datecreat`) VALUES
(1, 'Playlist 01', 'playlist 01', '500x_ultimate-music-playlist1.jpg', 'Playlist-01', 102, 102, 102, 102, 1, 'a:7:{i:0;i:12;i:1;i:11;i:2;i:8;i:3;i:4;i:4;i:3;i:5;i:2;i:6;i:1;}', 1412667112),
(2, 'Playlist 2', 'playlist 2', 'Dose-of-My-Playlist.jpg', 'Playlist-2', 23, 23, 23, 23, 1, 'a:2:{i:0;i:6;i:1;i:5;}', 1412667166);

-- --------------------------------------------------------

--
-- Table structure for table `music_rating_song`
--

CREATE TABLE IF NOT EXISTS `music_rating_song` (
  `r_id` int(10) NOT NULL AUTO_INCREMENT,
  `r_1` int(10) NOT NULL,
  `r_2` int(10) NOT NULL,
  `r_3` int(10) NOT NULL,
  `r_4` int(10) NOT NULL,
  `r_5` int(10) NOT NULL,
  PRIMARY KEY (`r_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Rating Song' AUTO_INCREMENT=21 ;

--
-- Dumping data for table `music_rating_song`
--

INSERT INTO `music_rating_song` (`r_id`, `r_1`, `r_2`, `r_3`, `r_4`, `r_5`) VALUES
(1, 0, 0, 0, 0, 0),
(2, 0, 0, 0, 0, 0),
(3, 0, 0, 0, 0, 0),
(4, 0, 0, 0, 0, 0),
(5, 0, 0, 0, 0, 0),
(6, 0, 0, 0, 0, 0),
(7, 0, 0, 0, 0, 0),
(8, 0, 0, 0, 0, 0),
(9, 0, 0, 0, 0, 0),
(10, 0, 0, 0, 0, 0),
(11, 0, 0, 0, 0, 0),
(12, 0, 0, 0, 0, 0),
(13, 0, 0, 0, 0, 0),
(14, 0, 0, 0, 0, 0),
(15, 0, 0, 0, 0, 0),
(16, 0, 0, 0, 0, 0),
(17, 0, 0, 0, 0, 0),
(18, 0, 0, 0, 0, 0),
(19, 0, 0, 0, 0, 0),
(20, 0, 0, 0, 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `music_settings`
--

CREATE TABLE IF NOT EXISTS `music_settings` (
  `set_id` int(10) NOT NULL AUTO_INCREMENT,
  `set_title_home` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `set_description_home` varchar(2555) COLLATE utf8_unicode_ci NOT NULL,
  `set_title_song` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `set_description_song` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `set_title_category` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `set_description_category` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `set_title_playlist` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `set_description_playlist` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `set_title_profile` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `set_description_profile` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `set_title_singer` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `set_description_singer` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `set_title_tags` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `set_description_tags` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `set_analytics` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`set_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `music_settings`
--

INSERT INTO `music_settings` (`set_id`, `set_title_home`, `set_description_home`, `set_title_song`, `set_description_song`, `set_title_category`, `set_description_category`, `set_title_playlist`, `set_description_playlist`, `set_title_profile`, `set_description_profile`, `set_title_singer`, `set_description_singer`, `set_title_tags`, `set_description_tags`, `set_analytics`) VALUES
(1, 'My Website', 'Description my website', 'Listen {song-name}', 'Bạn đang nghe bài hát {song-name}', 'Views all {category-name}', 'Description {category-name}', 'Listen playlist {playlist-name}', 'Descript playlist {playlist-name}', 'Information {profile-name}', 'Descriptions {profile-name}', 'Information {singer-name}', 'Information Description {singer-name}', 'Title tags {tags-name}', 'Description tags {tags-name}', '<script>Google</script>');

-- --------------------------------------------------------

--
-- Table structure for table `music_singer_song`
--

CREATE TABLE IF NOT EXISTS `music_singer_song` (
  `si_id` int(10) NOT NULL AUTO_INCREMENT,
  `si_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `si_keyword` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `si_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `si_img` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `si_birthday` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `si_description` text CHARACTER SET ucs2 COLLATE ucs2_unicode_ci NOT NULL,
  PRIMARY KEY (`si_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Singer Song' AUTO_INCREMENT=17 ;

--
-- Dumping data for table `music_singer_song`
--

INSERT INTO `music_singer_song` (`si_id`, `si_name`, `si_keyword`, `si_url`, `si_img`, `si_birthday`, `si_description`) VALUES
(1, 'Cool', 'cool', 'Cool', 'Cool.jpg', '1990-12-20', 'Cool'),
(2, 'CeLine Dion', 'celine dion', 'CeLine-Dion', 'CeLine-Dion.jpg', '1968-3-3', 'CeLine Dion'),
(3, 'Michael Jackson', 'michael jackson', 'Michael-Jackson', 'Michael-Jackson.jpg', '1958', 'Michael Jackson'),
(4, 'Gerard Hugh Sayer', 'gerard hugh sayer', 'Gerard-Hugh-Sayer', 'Gerard-Hugh-Sayer.jpg', '21/05', 'Gerard Hugh Sayer'),
(5, 'Michael Learns To Rock', 'michael learns to rock', 'Michael-Learns-To-Rock', 'Michael-Learns-To-Rock.jpg', 'not', 'Michael Learns To Rock'),
(6, 'Westlife', 'westlife', 'Westlife', 'Westlife.jpg', 'Not', 'Westlife'),
(7, 'M2M', 'm2m', 'M2M', 'M2M.jpg', 'Not', 'M2M'),
(8, 'Glenn Medeiros', 'glenn medeiros', 'Glenn-Medeiros', 'Glenn-Medeiros.jpg', 'Not', 'Glenn Medeiros'),
(9, 'Shayne Ward', 'shayne ward', 'Shayne-Ward', 'Shayne-Ward.jpg', 'not', 'Shayne Ward'),
(10, 'Taylor Swift', 'taylor swift', 'Taylor-Swift', 'Taylor-Swift.jpg', 'Not', 'Taylor Swift'),
(11, 'Backstreet Boys', 'backstreet boys', 'Backstreet-Boys', 'Backstreet-Boys.PNG', 'not', 'Backstreet Boys'),
(12, 'Kelly Chan', 'kelly chan', 'Kelly-Chan', 'Kelly-Chan.jpg', 'not', 'Kelly Chan'),
(13, 'Gangnam Style', 'gangnam style', 'Gangnam-Style', 'Gangnam-Style.jpg', 'not', 'Gangnam Style'),
(14, '李玉刚', '李玉刚', 'china-singer', '55_091130153306_2.jpg', 'not', '李玉刚'),
(15, 'Justin Bieber', 'justin bieber', 'Justin-Bieber', 'Justin-Bieber.jpg', 'not', 'Justin Bieber'),
(16, 'Modern Talking', 'modern talking', 'Modern-Talking', 'Modern_Talking.jpg', 'Not', 'Modern Talking');

-- --------------------------------------------------------

--
-- Table structure for table `music_song`
--

CREATE TABLE IF NOT EXISTS `music_song` (
  `s_id` int(10) NOT NULL AUTO_INCREMENT,
  `cat_id` int(10) NOT NULL,
  `u_id` int(10) NOT NULL,
  `si_id` int(10) NOT NULL,
  `r_id` int(10) NOT NULL,
  `v_id` int(10) NOT NULL,
  `l_id` int(10) NOT NULL,
  `ly_id` int(10) NOT NULL,
  `s_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `s_download` int(10) NOT NULL DEFAULT '0',
  `s_keyword` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `s_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `s_link` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `s_tags` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `s_img` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `s_type` int(1) NOT NULL,
  `s_date_creat` int(20) NOT NULL,
  `s_date_update` int(20) NOT NULL,
  PRIMARY KEY (`s_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Main Song' AUTO_INCREMENT=21 ;

--
-- Dumping data for table `music_song`
--

INSERT INTO `music_song` (`s_id`, `cat_id`, `u_id`, `si_id`, `r_id`, `v_id`, `l_id`, `ly_id`, `s_name`, `s_download`, `s_keyword`, `s_url`, `s_link`, `s_tags`, `s_img`, `s_type`, `s_date_creat`, `s_date_update`) VALUES
(1, 1, 1, 1, 1, 1, 1, 1, 'Aloha', 0, 'aloha', 'Aloha', 'welcometo.mp3', '1', 'Aloha.jpg', 1, 1412661135, 1412661135),
(2, 1, 1, 2, 2, 2, 2, 2, 'My Heart wiLL Go On (Titanic)', 1, 'my heart will go on (titanic)', 'My-Heart-wiLL-Go-On-Titanic', 'welcometo.mp3', '3', 'My-Heart-wiLL-Go-On-Titanic1.jpg', 1, 1412661471, 1412661471),
(3, 1, 1, 3, 3, 3, 3, 3, 'Heal the world', 0, 'heal the world', 'Heal-the-world', 'welcometo.mp3', '4', 'Heal-the-world.jpg', 1, 1412661895, 1412661895),
(4, 1, 1, 4, 4, 4, 4, 4, 'More Than I Can Say', 0, 'more than i can say', 'More-Than-I-Can-Say', 'welcometo.mp3', '5', 'More-Than-I-Can-Say.jpg', 1, 1412662292, 1412662292),
(5, 1, 1, 5, 5, 5, 5, 5, 'Take Me To Your Heart', 0, 'take me to your heart', 'Take-Me-To-Your-Heart', 'welcometo.mp3', '6', 'Take-Me-To-Your-Heart.jpg', 1, 1412662548, 1412662548),
(6, 1, 1, 6, 6, 6, 6, 6, 'My Love', 0, 'my love', 'My-Love', 'welcometo.mp3', '7', 'My-Love.jpg', 1, 1412662738, 1412662738),
(7, 1, 1, 7, 7, 7, 7, 7, 'The Day You Went Away', 0, 'the day you went away', 'The-Day-You-Went-Away', 'welcometo.mp3', '8,9,2', 'The-Day-You-Went-Away.jpg', 1, 1412662930, 1412662930),
(8, 1, 1, 8, 8, 8, 8, 8, 'Nothing''s Gonna Change My Love', 0, 'nothing''s gonna change my love', 'Nothings-Gonna-Change-My-Love', 'welcometo.mp3', '10,11,2', 'Nothings-Gonna-Change-My-Love.jpg', 1, 1412663136, 1412663136),
(9, 1, 1, 9, 9, 9, 9, 9, 'No Promises', 0, 'no promises', 'No-Promises', 'welcometo.mp3', '12,13,2', 'No-Promises.jpg', 1, 1412663269, 1412663269),
(10, 1, 1, 10, 10, 10, 10, 10, 'You Belong With Me', 0, 'you belong with me', 'You-Belong-With-Me', 'welcometo.mp3', '14,15', 'You-Belong-With-Me.jpg', 1, 1412663421, 1412663421),
(11, 1, 1, 11, 11, 11, 11, 11, 'As Long As You Love Me', 1, 'as long as you love me', 'As-Long-As-You-Love-Me', 'welcometo.mp3', '16,17', 'As-Long-As-You-Love-Me.PNG', 1, 1412663553, 1412663553),
(12, 1, 1, 12, 12, 12, 12, 12, 'Love Paradise', 1, 'love paradise', 'Love-Paradise', 'welcometo.mp3', '18,19', 'Love-Paradise.jpg', 1, 1412663719, 1412663719),
(13, 2, 1, 13, 13, 13, 13, 13, 'PSY (ft. HYUNA) 오빤 딱 내 스타일', 0, 'psy (ft. hyuna) 오빤 딱 내 스타일', 'PSY-ft-HYUNA', 'https://www.youtube.com/watch?v=wcLNteez3c4', '20,21', 'PSY-ft-HYUNA.jpg', 2, 1412663960, 1412664258),
(14, 2, 1, 8, 14, 14, 14, 14, 'More Than I Can Say', 0, 'more than i can say', 'More-Than-I-Can-Say', 'https://www.youtube.com/watch?v=dGKnSdikqjw', '5,22,23', 'More-Than-I-Can-Say1.jpg', 2, 1412664509, 1412664509),
(15, 2, 1, 14, 15, 15, 15, 15, 'Woman love (China)', 0, 'woman love (china)', 'Woman-love-China', 'https://www.youtube.com/watch?v=fEobh2Hr7Lc', '24,25', 'Woman-love-China.jpg', 2, 1412664769, 1412664769),
(16, 2, 1, 15, 16, 16, 16, 16, 'Baby ft. Ludacris', 0, 'baby ft. ludacris', 'Baby-ft-Ludacris', 'https://www.youtube.com/watch?v=fEobh2Hr7Lc', '26,27', 'Baby-ft-Ludacris.jpg', 2, 1412664936, 1412665640),
(17, 2, 1, 15, 17, 17, 17, 17, 'Justin Bieber', 0, 'justin bieber', 'Justin-Bieber', 'https://www.youtube.com/watch?v=fEobh2Hr7Lc', '26,17', 'Justin-Bieber.jpg', 2, 1412665068, 1412665068),
(18, 2, 1, 11, 18, 18, 18, 18, 'I Want It That Way', 0, 'i want it that way', 'I-Want-It-That-Way', 'https://www.youtube.com/watch?v=fEobh2Hr7Lc', '16,28', 'I-Want-It-That-Way.jpg', 2, 1412665150, 1412665150),
(19, 2, 1, 16, 19, 19, 19, 19, 'Modern Talking - Kapcsolat koncert 1998 ', 0, 'modern talking - kapcsolat koncert 1998 ', 'Modern-Talking-Kapcsolat-koncert-1998', 'https://www.youtube.com/watch?v=CtUUooQLRic', '29,30', 'Modern-Talking-Kapcsolat-koncert-1998.jpg', 2, 1412665347, 1412665347),
(20, 2, 1, 3, 20, 20, 20, 20, 'Heal The World', 0, 'heal the world', 'Heal-The-World', 'https://www.youtube.com/watch?v=PC49th-Jf0s', '4,31,22', 'Heal-The-World.jpg', 2, 1412665483, 1414312859);

-- --------------------------------------------------------

--
-- Table structure for table `music_tag_song`
--

CREATE TABLE IF NOT EXISTS `music_tag_song` (
  `t_id` int(10) NOT NULL AUTO_INCREMENT,
  `t_tags` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`t_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Song Tags' AUTO_INCREMENT=32 ;

--
-- Dumping data for table `music_tag_song`
--

INSERT INTO `music_tag_song` (`t_id`, `t_tags`) VALUES
(1, 'Cool'),
(2, 'Audio'),
(3, 'CeLine Dion'),
(4, 'Michael Jackson'),
(5, 'Gerard Hugh Sayer'),
(6, 'Michael Learns To Rock'),
(7, 'Westlife'),
(8, 'M2M'),
(9, 'The Day You Went Away'),
(10, 'Glenn Medeiros'),
(11, 'Nothing''s Gonna Change My Love'),
(12, 'Shayne Ward'),
(13, 'No Promises'),
(14, 'Taylor Swift'),
(15, 'You Belong With Me'),
(16, 'Backstreet Boys'),
(17, 'As Long As You Love Me'),
(18, 'Kelly Chan'),
(19, 'Love Paradise'),
(20, 'Gangnam Style'),
(21, 'PSY (ft. HYUNA) '),
(22, 'video '),
(23, 'More Than I Can Say'),
(24, '玉刚'),
(25, 'Woman love (China)'),
(26, 'Justin Bieber'),
(27, 'Baby ft. Ludacris'),
(28, 'I Want It That Way'),
(29, 'Modern Talking'),
(30, 'Kapcsolat koncert 1998 '),
(31, 'Heal The World');

-- --------------------------------------------------------

--
-- Table structure for table `music_users`
--

CREATE TABLE IF NOT EXISTS `music_users` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `ip_address` varchar(15) NOT NULL,
  `username` varchar(100) NOT NULL,
  `password` varchar(255) NOT NULL,
  `salt` varchar(255) DEFAULT NULL,
  `email` varchar(100) NOT NULL,
  `activation_code` varchar(40) DEFAULT NULL,
  `forgotten_password_code` varchar(40) DEFAULT NULL,
  `forgotten_password_time` int(11) unsigned DEFAULT NULL,
  `remember_code` varchar(40) DEFAULT NULL,
  `created_on` int(11) unsigned NOT NULL,
  `last_login` int(11) unsigned DEFAULT NULL,
  `active` tinyint(1) unsigned DEFAULT NULL,
  `first_name` varchar(50) DEFAULT NULL,
  `last_name` varchar(50) DEFAULT NULL,
  `company` varchar(100) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `avatar` varchar(255) DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `sex` int(1) DEFAULT NULL,
  `about` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `music_users`
--

INSERT INTO `music_users` (`id`, `ip_address`, `username`, `password`, `salt`, `email`, `activation_code`, `forgotten_password_code`, `forgotten_password_time`, `remember_code`, `created_on`, `last_login`, `active`, `first_name`, `last_name`, `company`, `phone`, `avatar`, `address`, `sex`, `about`) VALUES
(1, '127.0.0.1', 'admin', '$2y$08$mMxjuklHX1j8WBetZ23/uuWSYCtfd3088RZ/XEAIP3G0QEKoxK8je', '', 'admin@admin.com', '', NULL, NULL, 'yQkq6CKaDtoxFx.27skWiu', 1268889823, 1414425567, 1, 'Admin', 'Note', 'ADMIN', '1689865227', '', 'Address', 1, 'PHP Coder');

-- --------------------------------------------------------

--
-- Table structure for table `music_users_groups`
--

CREATE TABLE IF NOT EXISTS `music_users_groups` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) unsigned NOT NULL,
  `group_id` mediumint(8) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uc_users_groups` (`user_id`,`group_id`),
  KEY `fk_users_groups_users1_idx` (`user_id`),
  KEY `fk_users_groups_groups1_idx` (`group_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `music_users_groups`
--

INSERT INTO `music_users_groups` (`id`, `user_id`, `group_id`) VALUES
(2, 1, 1);

-- --------------------------------------------------------

--
-- Table structure for table `music_views_song`
--

CREATE TABLE IF NOT EXISTS `music_views_song` (
  `v_id` int(10) NOT NULL AUTO_INCREMENT,
  `v_views` int(10) NOT NULL,
  `v_views_week` int(10) NOT NULL,
  `v_views_month` int(10) NOT NULL,
  `v_views_year` int(10) NOT NULL,
  PRIMARY KEY (`v_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Views Song' AUTO_INCREMENT=21 ;

--
-- Dumping data for table `music_views_song`
--

INSERT INTO `music_views_song` (`v_id`, `v_views`, `v_views_week`, `v_views_month`, `v_views_year`) VALUES
(1, 101, 101, 101, 101),
(2, 100, 100, 100, 100),
(3, 214, 214, 214, 214),
(4, 217, 217, 217, 217),
(5, 37, 37, 37, 37),
(6, 37, 37, 37, 37),
(7, 3, 3, 3, 3),
(8, 216, 216, 216, 216),
(9, 123, 123, 123, 123),
(10, 34, 34, 34, 34),
(11, 200, 200, 200, 200),
(12, 553, 553, 553, 553),
(13, 7, 7, 7, 7),
(14, 3, 3, 3, 3),
(15, 7, 7, 7, 7),
(16, 10, 10, 10, 10),
(17, 7, 7, 7, 7),
(18, 7, 7, 7, 7),
(19, 8, 8, 8, 8),
(20, 139, 139, 139, 139);

--
-- Constraints for dumped tables
--

--
-- Constraints for table `music_users_groups`
--
ALTER TABLE `music_users_groups`
  ADD CONSTRAINT `fk_users_groups_groups1` FOREIGN KEY (`group_id`) REFERENCES `music_groups` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_users_groups_users1` FOREIGN KEY (`user_id`) REFERENCES `music_users` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
