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

--
-- Table structure for table `album`
--

CREATE TABLE `album` (
  `id` int(11) NOT NULL,
  `album_name` varchar(255) NOT NULL,
  `album_image` varchar(255) DEFAULT NULL,
  `artist_ids` varchar(255) DEFAULT NULL,
  `status` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `album`
--

INSERT INTO `album` (`id`, `album_name`, `album_image`, `artist_ids`, `status`) VALUES
(1, 'Bhediya', 'upload/images/album/Bhediya.jpg', '5,19', 1),
(2, 'Brahmastra', 'upload/images/album/Brahmastra.jpg', '5,19,16', 1),
(3, 'Damn You\\\'ve Got Me Saying', 'upload/images/album/Damn-You-ve-Got-Me-Saying.jpg', '7', 1),
(4, 'Dhokha', 'upload/images/album/Dhokha-Round-D.jpg', '5,21', 1),
(5, 'Dreamers Music', 'upload/images/album/Dreamers-Music-from-the-FIFA-World-Cup-Qatar.jpg', '4,9', 1),
(6, 'Drishyam 2', 'upload/images/album/Drishyam-2.jpg', '3,21', 1),
(7, 'Elevation', 'upload/images/album/ELEVATION.jpg', '2,12', 1),
(8, 'Faith in the Future', 'upload/images/album/Faith-In-The-Future.jpg', '1', 1),
(9, 'Jhakaas Remakes', 'upload/images/album/JhakaasRemakes.jpg', '3,16,17,18,19,22,10,8,11', 1),
(10, 'Just A Kiss', 'upload/images/album/Just-A-Kiss-Muah.jpg', '1,12', 1),
(11, 'Kantara', 'upload/images/album/Kantara-Hindi.jpg', '6,18,21', 1),
(12, 'Laal Singh Chaddha', 'upload/images/album/Laal-Singh-Chaddha.jpg', '5,21,19,18,16', 1),
(13, 'Midnights', 'upload/images/album/Midnights.jpg', '12', 1),
(14, 'Never Let You Go', 'upload/images/album/Never-Let-You-Go.jpg', '2,1,12', 1),
(15, 'Nightbird', 'upload/images/album/Nightbird.jpg', '1,12,4,7,9', 1),
(16, 'Thank God', 'upload/images/album/Thank-God.jpg', '17,22,20', 1),
(17, 'Vikram Vedha', 'upload/images/album/Vikram-Vedha.jpg', '3,16,13,15,11', 1);

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

--
-- Table structure for table `analytics`
--

CREATE TABLE `analytics` (
  `id` bigint(20) NOT NULL,
  `user_ip` varchar(255) DEFAULT NULL,
  `country_code` varchar(3) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `operating_system` varchar(255) DEFAULT NULL,
  `browser` varchar(255) DEFAULT NULL,
  `date` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `app_ads`
--

CREATE TABLE `app_ads` (
  `id` int(11) NOT NULL,
  `ads_name` varchar(255) DEFAULT NULL,
  `ads_info` text DEFAULT NULL,
  `status` int(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `app_ads`
--

INSERT INTO `app_ads` (`id`, `ads_name`, `ads_info`, `status`) VALUES
(1, 'Admob', '{\"publisher_id\":\"pub-3940256099942544\",\"banner_on_off\":\"1\",\"banner_id\":\"ca-app-pub-3940256099942544\\/6300978111\",\"interstitial_on_off\":\"1\",\"interstitial_id\":\"ca-app-pub-3940256099942544\\/1033173712\",\"interstitial_clicks\":\"5\",\"native_on_off\":\"1\",\"native_id\":\"ca-app-pub-3940256099942544\\/2247696110\",\"native_position\":\"3\",\"open_ads_on_off\":\"1\",\"open_ads_id\":\"test\",\"reward_video_ads_on_off\":\"0\",\"reward_video_ads_id\":\"\"}', 0),
(2, 'StartApp', '{\"publisher_id\":\"203601319\",\"banner_on_off\":\"1\",\"banner_id\":\"\",\"interstitial_on_off\":\"1\",\"interstitial_id\":\"\",\"interstitial_clicks\":\"5\",\"native_on_off\":\"1\",\"native_id\":\"\",\"native_position\":\"3\",\"open_ads_on_off\":\"0\",\"reward_video_ads_on_off\":\"0\"}', 0),
(3, 'Facebook', '{\"publisher_id\":\"\",\"banner_on_off\":\"1\",\"banner_id\":\"fbid\",\"interstitial_on_off\":\"1\",\"interstitial_id\":\"fid\",\"interstitial_clicks\":\"5\",\"native_on_off\":\"1\",\"native_id\":\"da\",\"native_position\":\"2\",\"open_ads_on_off\":\"0\",\"open_ads_id\":\"\"}', 0),
(4, 'AppLovins MAX', '{\"publisher_id\":\"\",\"banner_on_off\":\"1\",\"banner_id\":\"3221a2640039c8a8\",\"interstitial_on_off\":\"1\",\"interstitial_id\":\"06b9bf27824eb7f6\",\"interstitial_clicks\":\"5\",\"native_on_off\":\"1\",\"native_id\":\"06b9bf27824eb7f6\",\"native_position\":\"3\"}', 0),
(5, 'Wortise', '{\"publisher_id\":\"c2f94dbb-e29a-4a95-bbf9-fbf860c428b3\",\"banner_on_off\":\"1\",\"banner_id\":\"acbb8bfe-be23-4252-a173-3bbc0d8dfb8a\",\"interstitial_on_off\":\"1\",\"interstitial_id\":\"70f3bdd5-4cd1-4943-a34d-9d23ba25542d\",\"interstitial_clicks\":\"5\",\"native_on_off\":\"1\",\"native_id\":\"f78f3300-dc1b-4ece-b85b-2bc5ecbca8bb\",\"native_position\":\"6\"}', 0),
(6, 'Unity Ads', '{\"publisher_id\":\"Unity Ads\",\"banner_on_off\":\"0\",\"banner_id\":\"\",\"interstitial_on_off\":\"0\",\"interstitial_id\":\"\",\"interstitial_clicks\":\"5\"}', 0);

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

--
-- Table structure for table `artists`
--

CREATE TABLE `artists` (
  `id` int(11) NOT NULL,
  `artist_name` varchar(255) NOT NULL,
  `artist_image` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `artists`
--

INSERT INTO `artists` (`id`, `artist_name`, `artist_image`) VALUES
(1, 'Adele', 'upload/images/artists/Adele.jpg'),
(2, 'Justin Bieber', 'upload/images/artists/Justin_Bieber.jpg'),
(3, 'Ammy Virk', 'upload/images/artists/Ammy_Virk.jpg'),
(4, 'Ariana Grande', 'upload/images/artists/Ariana_Grande.jpg'),
(5, 'Arijit Singh', 'upload/images/artists/Arijit_Singh.jpg'),
(6, 'Badshah', 'upload/images/artists/Badshah.jpg'),
(7, 'David Bowie', 'upload/images/artists/David_Bowie.jpg'),
(8, 'Diljit Dosanjh', 'upload/images/artists/Diljit_Dosanjh.jpg'),
(9, 'Ed Sheeran', 'upload/images/artists/Ed_Sheeran.jpg'),
(10, 'Guru Randhawa', 'upload/images/artists/Guru_Randhawa.jpg'),
(11, 'Jassi Gill', 'upload/images/artists/Jassi_Gill.jpg'),
(12, 'Katy Perry', 'upload/images/artists/Katy_Perry.jpg'),
(13, 'KK Singer', 'upload/images/artists/KK_Singer.jpg'),
(14, 'Kumar Sanu', 'upload/images/artists/Kumar_Sanu.jpg'),
(15, 'Lata Mangeshkar', 'upload/images/artists/Lata_Mangeshkar.jpg'),
(16, 'Miss Pooja', 'upload/images/artists/Miss_Pooja.jpg'),
(17, 'Neha Kakkar', 'upload/images/artists/Neha_Kakkar.jpg'),
(18, 'Nimrat Khaira', 'upload/images/artists/Nimrat_Khaira.jpg'),
(19, 'Shreya Ghoshal', 'upload/images/artists/Shreya_Ghoshal.jpg'),
(20, 'Sidhu Moose Wala', 'upload/images/artists/Sidhu_Moose_Wala.jpg'),
(21, 'Sonu Nigam', 'upload/images/artists/Sonu_Nigam.jpg'),
(22, 'Honey Singh', 'upload/images/artists/Yo_Yo_Honey_Singh.jpg');

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` int(11) NOT NULL,
  `category_name` varchar(255) NOT NULL,
  `category_image` varchar(255) DEFAULT NULL,
  `status` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `category_name`, `category_image`, `status`) VALUES
(2, 'Hindi', 'upload/images/category/Hindi_Song.png', 1),
(3, 'English', 'upload/images/category/English_Song.png', 1),
(4, 'Punjabi', 'upload/images/category/Punjabi_Song.png', 1),
(5, 'Gujarati', 'upload/images/category/Gujarati_Song.png', 1),
(6, 'Marathi', 'upload/images/category/Marathi_Song.png', 1);

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

--
-- Table structure for table `favourite`
--

CREATE TABLE `favourite` (
  `id` bigint(20) NOT NULL,
  `user_id` int(11) NOT NULL,
  `post_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `home_sections`
--

CREATE TABLE `home_sections` (
  `id` int(11) NOT NULL,
  `section_name` varchar(255) NOT NULL,
  `section_type` varchar(255) DEFAULT NULL,
  `post_ids` text DEFAULT NULL,
  `status` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `home_sections`
--

INSERT INTO `home_sections` (`id`, `section_name`, `section_type`, `post_ids`, `status`) VALUES
(1, 'Popular Category', 'category', '2,3,4,5', 1),
(2, 'Weekly Top', 'song', '2,4,8,10,14', 1),
(3, 'Best Playlist', 'playlist', '9,7,5,1,8', 1),
(4, 'Top Artist', 'artist', '5,19,20,12,10', 1),
(5, 'Top Albums', 'album', '1,2,15,17,12,16', 1);

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

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` int(11) NOT NULL,
  `page_title` varchar(500) NOT NULL,
  `page_slug` varchar(500) NOT NULL,
  `page_content` text NOT NULL,
  `page_order` int(3) DEFAULT NULL,
  `status` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` (`id`, `page_title`, `page_slug`, `page_content`, `page_order`, `status`) VALUES
(1, 'About Us', 'about-us', '<p>Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \\\"de Finibus Bonorum et Malorum\\\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \\\"Lorem ipsum dolor sit amet..\\\", comes from a line in section 1.10.32.</p>', 1, 1),
(2, 'Terms Of Use', 'terms-of-use', '<p><strong>Use of this site is provided by Demos subject to the following Terms and Conditions:</strong><br />1. Your use constitutes acceptance of these Terms and Conditions as at the date of your first use of the site.<br />2. Demos reserves the rights to change these Terms and Conditions at any time by posting changes online. Your continued use of this site after changes are posted constitutes your acceptance of this agreement as modified.<br />3. You agree to use this site only for lawful purposes, and in a manner which does not infringe the rights, or restrict, or inhibit the use and enjoyment of the site by any third party.<br />4. This site and the information, names, images, pictures, logos regarding or relating to Demos are provided &ldquo;as is&rdquo; without any representation or endorsement made and without warranty of any kind whether express or implied. In no event will Demos be liable for any damages including, without limitation, indirect or consequential damages, or any damages whatsoever arising from the use or in connection with such use or loss of use of the site, whether in contract or in negligence.<br />5. Demos does not warrant that the functions contained in the material contained in this site will be uninterrupted or error free, that defects will be corrected, or that this site or the server that makes it available are free of viruses or bugs or represents the full functionality, accuracy and reliability of the materials.<br />6. Copyright restrictions: please refer to our Creative Commons license terms governing the use of material on this site.<br />7. Demos takes no responsibility for the content of external Internet Sites.<br />8. Any communication or material that you transmit to, or post on, any public area of the site including any data, questions, comments, suggestions, or the like, is, and will be treated as, non-confidential and non-proprietary information.<br />9. If there is any conflict between these Terms and Conditions and rules and/or specific terms of use appearing on this site relating to specific material then the latter shall prevail.<br />10. These terms and conditions shall be governed and construed in accordance with the laws of England and Wales. Any disputes shall be subject to the exclusive jurisdiction of the Courts of England and Wales.<br />11. If these Terms and Conditions are not accepted in full, the use of this site must be terminated immediately.</p>', 2, 1),
(3, 'Privacy Policy', 'privacy-policy', '<h4><strong>Privacy Policy of&nbsp;<span class=\\\"highlight preview_company_name\\\">Company Name</span></strong></h4>\r\n<p><span class=\\\"highlight preview_company_name\\\">Company Name</span>&nbsp;operates the&nbsp;<span class=\\\"highlight preview_website_name\\\">Website Name</span>&nbsp;website, which provides the SERVICE.</p>\r\n<p>This page is used to inform website visitors regarding our policies with the collection, use, and disclosure of Personal Information if anyone decided to use our Service, the&nbsp;<span class=\\\"highlight preview_website_name\\\">Website Name</span>&nbsp;website.</p>\r\n<p>If you choose to use our Service, then you agree to the collection and use of information in relation with this policy. The Personal Information that we collect are used for providing and improving the Service. We will not use or share your information with anyone except as described in this Privacy Policy.</p>\r\n<p>The terms used in this Privacy Policy have the same meanings as in our Terms and Conditions, which is accessible at&nbsp;<span class=\\\"highlight preview_website_url\\\">Website URL</span>, unless otherwise defined in this Privacy Policy.</p>\r\n<h4><strong>Information Collection and Use</strong></h4>\r\n<p>For a better experience while using our Service, we may require you to provide us with certain personally identifiable information, including but not limited to your name, phone number, and postal address. The information that we collect will be used to contact or identify you.</p>\r\n<h4><strong>Log Data</strong></h4>\r\n<p>We want to inform you that whenever you visit our Service, we collect information that your browser sends to us that is called Log Data. This Log Data may include information such as your computer\\\'s Internet Protocol (&ldquo;IP&rdquo;) address, browser version, pages of our Service that you visit, the time and date of your visit, the time spent on those pages, and other statistics.</p>\r\n<h4><strong>Cookies</strong></h4>\r\n<p>Cookies are files with small amount of data that is commonly used an anonymous unique identifier. These are sent to your browser from the website that you visit and are stored on your computer\\\'s hard drive.</p>\r\n<p>Our website uses these &ldquo;cookies&rdquo; to collection information and to improve our Service. You have the option to either accept or refuse these cookies, and know when a cookie is being sent to your computer. If you choose to refuse our cookies, you may not be able to use some portions of our Service.</p>\r\n<h4><strong>Service Providers</strong></h4>\r\n<p>We may employ third-party companies and individuals due to the following reasons:</p>\r\n<ul>\r\n<li>To facilitate our Service</li>\r\n<li>To provide the Service on our behalf</li>\r\n<li>To perform Service-related services or</li>\r\n<li>To assist us in analyzing how our Service is used.</li>\r\n</ul>\r\n<p>We want to inform our Service users that these third parties have access to your Personal Information. The reason is to perform the tasks assigned to them on our behalf. However, they are obligated not to disclose or use the information for any other purpose.</p>\r\n<h4><strong>Security</strong></h4>\r\n<p>We value your trust in providing us your Personal Information, thus we are striving to use commercially acceptable means of protecting it. But remember that no method of transmission over the internet, or method of electronic storage is 100% secure and reliable, and we cannot guarantee its absolute security.</p>\r\n<h4><strong>Links to Other Sites</strong></h4>\r\n<p>Our Service may contain links to other sites. If you click on a third-party link, you will be directed to that site. Note that these external sites are not operated by us. Therefore, we strongly advise you to review the Privacy Policy of these websites. We have no control over, and assume no responsibility for the content, privacy policies, or practices of any third-party sites or services.</p>\r\n<p>Children\\\'s Privacy</p>\r\n<p>Our Services do not address anyone under the age of 13. We do not knowingly collect personal identifiable information from children under 13. In the case we discover that a child under 13 has provided us with personal information, we immediately delete this from our servers. If you are a parent or guardian and you are aware that your child has provided us with personal information, please contact us so that we will be able to do necessary actions.</p>\r\n<h4><strong>Changes to This Privacy Policy</strong></h4>\r\n<p>We may update our Privacy Policy from time to time. Thus, we advise you to review this page periodically for any changes. We will notify you of any changes by posting the new Privacy Policy on this page. These changes are effective immediately, after they are posted on this page.</p>\r\n<h4><strong>Contact Us</strong></h4>\r\n<p>If you have any questions or suggestions about our Privacy Policy, do not hesitate to contact us.</p>', 3, 1);

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

--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `id` int(11) NOT NULL,
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `payment_gateway`
--

CREATE TABLE `payment_gateway` (
  `id` int(11) NOT NULL,
  `gateway_name` varchar(255) NOT NULL,
  `gateway_info` text DEFAULT NULL,
  `status` int(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `payment_gateway`
--

INSERT INTO `payment_gateway` (`id`, `gateway_name`, `gateway_info`, `status`) VALUES
(1, 'Paypal', '{\"mode\":\"sandbox\",\"braintree_merchant_id\":null,\"braintree_public_key\":null,\"braintree_private_key\":null,\"braintree_merchant_account_id\":null}', 0),
(2, 'Stripe', '{\"stripe_secret_key\":null,\"stripe_publishable_key\":null}', 0),
(3, 'Razorpay', '{\"razorpay_key\":null,\"razorpay_secret\":null}', 0),
(4, 'Paystack', '{\"paystack_secret_key\":null,\"paystack_public_key\":null}', 0),
(5, 'PayUMoney', '{\"mode\":\"sandbox\",\"payu_merchant_id\":null,\"payu_key\":null,\"payu_salt\":null}', 0),
(6, 'Flutterwave', '{\"flutterwave_public_key\":null,\"flutterwave_secret_key\":null,\"flutterwave_encryption_key\":null}', 0),
(7, 'CinetPay', '', 0),
(8, 'Bank Transfer', '', 0),
(9, 'Instamojo', '', 0);

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

--
-- Table structure for table `playlist`
--

CREATE TABLE `playlist` (
  `id` int(11) NOT NULL,
  `playlist_name` text NOT NULL,
  `playlist_image` varchar(255) DEFAULT NULL,
  `songs_ids` text DEFAULT NULL,
  `status` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `playlist`
--

INSERT INTO `playlist` (`id`, `playlist_name`, `playlist_image`, `songs_ids`, `status`) VALUES
(1, '90s Duets Hindi Songs', 'upload/images/playlist/90sDuetsHindiSongs.jpg', '1,2,5,8,15,19,20,21', 1),
(2, '90s King Kumar Sanu', 'upload/images/playlist/90sKingKumarSanu.jpg', '1,5,8,16,25,26', 1),
(3, 'Any Where with Rita Ora', 'upload/images/playlist/AnywherewithRitaOra.jpg', '9,12,24,23', 1),
(4, 'Absolute Classic Rock', 'upload/images/playlist/AbsoluteClassicRock.jpg', '1,28,29,25,20,21', 1),
(5, 'Best Of Romance Hindi', 'upload/images/playlist/BestOfRomanceHindi.jpg', '1,30,20,25,14,19,4,7,8', 1),
(6, 'Best Of Romance Retro Hindi', 'upload/images/playlist/BestOfRomance-RetroHindi.jpg', '4,28,25,20,29,21', 1),
(7, 'Now Playing Pop', 'upload/images/playlist/NowPlayingPop.jpg', '6,24,23,17', 1),
(8, 'Punjabse Bollywood', 'upload/images/playlist/PunjabseBollywood.jpg', '8,28,29,26,18', 1),
(9, 'Best Of Arijit Singh', 'upload/images/playlist/Let_sPlayBestOfArijitSingh.jpg', '1,20,19,11,8,7,4', 1);

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

--
-- Table structure for table `post_ratings`
--

CREATE TABLE `post_ratings` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `post_id` int(11) NOT NULL,
  `rate` int(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `post_views`
--

CREATE TABLE `post_views` (
  `id` bigint(20) NOT NULL,
  `post_id` int(11) NOT NULL,
  `post_type` varchar(255) NOT NULL,
  `post_views` int(11) NOT NULL DEFAULT 0,
  `post_download` int(11) NOT NULL DEFAULT 0,
  `date` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `reports`
--

CREATE TABLE `reports` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `post_id` int(11) NOT NULL,
  `message` varchar(255) NOT NULL,
  `date` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int(10) UNSIGNED NOT NULL,
  `time_zone` varchar(255) NOT NULL DEFAULT 'UTC',
  `currency_code` varchar(255) NOT NULL DEFAULT 'USD',
  `default_language` varchar(255) NOT NULL DEFAULT 'en',
  `admin_logo` varchar(255) DEFAULT NULL,
  `app_name` varchar(255) NOT NULL,
  `app_email` varchar(255) NOT NULL,
  `app_logo` varchar(255) NOT NULL,
  `app_company` varchar(255) DEFAULT NULL,
  `app_website` varchar(255) DEFAULT NULL,
  `app_contact` varchar(255) DEFAULT NULL,
  `app_version` varchar(255) DEFAULT NULL,
  `smtp_host` varchar(255) DEFAULT NULL,
  `smtp_port` varchar(255) DEFAULT NULL,
  `smtp_email` varchar(255) DEFAULT NULL,
  `smtp_password` varchar(255) DEFAULT NULL,
  `smtp_encryption` varchar(255) DEFAULT NULL,
  `facebook_link` varchar(255) NOT NULL,
  `twitter_link` varchar(255) DEFAULT NULL,
  `instagram_link` varchar(255) DEFAULT NULL,
  `youtube_link` varchar(255) DEFAULT NULL,
  `google_play_link` varchar(255) DEFAULT NULL,
  `apple_store_link` varchar(255) DEFAULT NULL,
  `onesignal_app_id` varchar(255) DEFAULT NULL,
  `onesignal_rest_key` varchar(255) DEFAULT NULL,
  `app_update_hide_show` varchar(255) NOT NULL DEFAULT 'true',
  `app_update_version_code` varchar(255) DEFAULT NULL,
  `app_update_desc` varchar(255) DEFAULT NULL,
  `app_update_link` varchar(255) DEFAULT NULL,
  `app_update_cancel_option` varchar(255) NOT NULL DEFAULT 'true',
  `song_download` varchar(10) NOT NULL DEFAULT 'false',
  `pagination_limit` int(3) NOT NULL DEFAULT 10,
  `subscription_on_off` varchar(255) NOT NULL DEFAULT 'false',
  `envato_buyer_name` varchar(255) DEFAULT NULL,
  `envato_purchase_code` varchar(255) DEFAULT NULL,
  `app_package_name` varchar(255) DEFAULT NULL,
  `netsocks_on_off` varchar(255) NOT NULL DEFAULT 'on',
  `netsocks_publisher_key` varchar(255) DEFAULT NULL,
  `netsocks_consent` varchar(255) NOT NULL DEFAULT 'off'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `time_zone`, `currency_code`, `default_language`, `admin_logo`, `app_name`, `app_email`, `app_logo`, `app_company`, `app_website`, `app_contact`, `app_version`, `smtp_host`, `smtp_port`, `smtp_email`, `smtp_password`, `smtp_encryption`, `facebook_link`, `twitter_link`, `instagram_link`, `youtube_link`, `google_play_link`, `apple_store_link`, `onesignal_app_id`, `onesignal_rest_key`, `app_update_hide_show`, `app_update_version_code`, `app_update_desc`, `app_update_link`, `app_update_cancel_option`, `song_download`, `pagination_limit`, `subscription_on_off`, `envato_buyer_name`, `envato_purchase_code`, `app_package_name`, `netsocks_on_off`, `netsocks_publisher_key`, `netsocks_consent`) VALUES
(1, 'Asia/Kolkata', 'USD', 'es', 'upload/images/online_mp3_logo_1.png', 'Online MP3', 'info@viavilab.com', 'upload/app_icon.png', 'Viavi Webtech', 'www.viaviweb.com', '+91 9227777522', '1.0.0', '', '465', '', '', 'SSL', 'https://facebook.com', 'https://twitter.com', 'https://instagram.com', 'https://youtube.com', '#gp', '#ap', '', '', 'false', '1.1', 'Please update new app', 'https://google.com', 'true', 'false', 10, 'false', '', '', 'com.vpapps.onlinemp3', 'on', '0E2723F4-A102-42DC-9602-AD8F7312767A', 'off');

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

--
-- Table structure for table `slider`
--

CREATE TABLE `slider` (
  `id` int(11) NOT NULL,
  `slider_title` varchar(500) NOT NULL,
  `slider_image` varchar(255) NOT NULL,
  `slider_info` varchar(255) DEFAULT NULL,
  `songs_ids` text DEFAULT NULL,
  `status` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `slider`
--

INSERT INTO `slider` (`id`, `slider_title`, `slider_image`, `slider_info`, `songs_ids`, `status`) VALUES
(1, 'Romantic Top 40', 'upload/images/slider/charts_RomanticTop40.jpg', 'Best Romantic Songs', '1,4,7,11,8,19', 1),
(2, 'Trending Today', 'upload/images/slider/charts_TrendingToday.jpg', 'Top Trending Song for Today', '1,4,5,8,19', 1),
(3, 'Hindi Chartbusters', 'upload/images/slider/charts_HindiChartbusters.jpg', 'Hindi Chartbusters', '2,26,27,29,28,11', 1),
(4, 'Slow Romantic Hindi', 'upload/images/slider/Slow_Romantic_Hindi.jpg', 'Slow Romantic Hindi Songs', '4,25,20,14,30', 1),
(5, 'New Releases Punjabi', 'upload/images/slider/New_Releases_Panjabi.jpg', 'New Releases Punjabi', '2,27,28,18,16', 1),
(6, 'New Releases Hindi', 'upload/images/slider/New_Releases_Hindi.jpg', 'New Releases Hindi Songs 2022', '1,27,29,28,15,10,3,4,5,2', 1);

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

--
-- Table structure for table `songs`
--

CREATE TABLE `songs` (
  `id` int(11) NOT NULL,
  `cat_id` int(11) NOT NULL,
  `album_id` int(11) DEFAULT NULL,
  `artist_ids` varchar(255) DEFAULT NULL,
  `song_title` varchar(500) NOT NULL,
  `song_image` varchar(255) DEFAULT NULL,
  `song_info` text DEFAULT NULL,
  `song_lyrics` text DEFAULT NULL,
  `song_type` varchar(255) DEFAULT NULL,
  `song_url` varchar(255) DEFAULT NULL,
  `status` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `songs`
--

INSERT INTO `songs` (`id`, `cat_id`, `album_id`, `artist_ids`, `song_title`, `song_image`, `song_info`, `song_lyrics`, `song_type`, `song_url`, `status`) VALUES
(1, 2, 1, '5', 'Apna Bana Le', 'upload/images/songs/Bhediya.jpg', '<p>Bhediya &nbsp;by Sachin-Jigar, Arijit Singh</p>', '<p>Tu Mera Koyi Na<br />Hoke Bhi Kuchh Laage<br />Tu Mera Koyi Na<br />Hoke Bhi Kuchh Laage</p>', 'local', 'upload/files/test1.mp3', 1),
(2, 2, 1, '5,21', 'Thumkeshwari', 'upload/images/songs/Bhediya.jpg', '<p>Bhediya &nbsp;by Sachin-Jigar, Rashmeet Kaur, Ash King, Divya Kumar</p>', '<p>Curvy kamariyaa teri, haay re, meri jaan le gayi, oe</p>\r\n<p>Ban ke bijuriya giri, haay re, pareshaan kar gayi, oe</p>\r\n<p>Curvy kamariyaa teri, haay re, meri jaan le gayi, oe</p>\r\n<p>O-ri, gori, sun ri, sun ri, sun ri</p>', 'server_url', 'http://www.viaviweb.in/envato/cc/demo/mp3/file_example_MP3_5MG.mp3', 1),
(3, 2, 1, '6,22', 'Jungle Mein Kaand', 'upload/images/songs/Bhediya.jpg', '<p>Bhediya &nbsp;by Sachin-Jigar, Vishal Dadlani, Sukhwinder Singh, Siddharth Basrur</p>', '<p>Hey Hey Marte Hain<br />Hum Roz Marte Hain<br />Jeena Hai Jeena Hai<br />Jeena Hai Aaj Ki Raat</p>', 'local', 'upload/files/test2.mp3', 1),
(4, 2, 2, '5', 'Kesariya', 'upload/images/songs/Brahmastra.jpg', '<p>Brahmastra (Original Motion Picture Soundtrack) &nbsp;by Pritam, Arijit Singh, Amitabh Bhattacharya</p>', '<p>mujko itana bataae koyi<br />kaise tujhse dil naa lagaae koyi?</p>', 'local', 'upload/files/test2.mp3', 1),
(5, 2, 2, '5', 'Deva Deva', 'upload/images/songs/Brahmastra.jpg', '<p>Brahmastra (Original Motion Picture Soundtrack) &nbsp;by Pritam, Arijit Singh, Amitabh Bhattacharya</p>', '<p>chingaariyaan ye jo mere seene mein hain dafan<br />inako zaraa deke haea ban jaaoon main agan</p>', 'local', 'upload/files/test1.mp3', 1),
(6, 3, 3, '7', 'Damn (You\\\'ve Got Me Saying)', 'upload/images/songs/Damn-You-ve-Got-Me-Saying.jpg', '<p>Artists: David Guetta, Galantis, MNEK<br />Released: 2022<br />Album: Damn (You&rsquo;ve Got Me Saying)</p>', '<div class=\\\"ujudUb\\\">Let me explain it<br aria-hidden=\\\"true\\\" />When I did you wrong<br aria-hidden=\\\"true\\\" />I didn\\\'t know I\\\'d feel this regret<br aria-hidden=\\\"true\\\" />But it drives me crazy<br aria-hidden=\\\"true\\\" />To see you move on<br aria-hidden=\\\"true\\\" />While I lay alone in my bed</div>\r\n<div class=\\\"ujudUb\\\">If I could rewind<br aria-hidden=\\\"true\\\" />Take a step back in time<br aria-hidden=\\\"true\\\" />I would never do you like that<br aria-hidden=\\\"true\\\" />I made a mistake<br aria-hidden=\\\"true\\\" />So now it\\\'s too late<br aria-hidden=\\\"true\\\" />And there ain\\\'t no way I\\\'m getting you back</div>', 'local', 'upload/files/test2.mp3', 1),
(7, 2, 4, '5', 'Tu Banke Hawa', 'upload/images/songs/Dhokha-Round-D.jpg', '<p>Dhokha Round D Corner &nbsp;by Jubin Nautiyal</p>', '<p>dil di main ki kahaan? hoiya kamla jia</p>\r\n<p>tu banake hawa aayi aa, tu mithi-mithi gallan laayi aa</p>', 'local', 'upload/files/test1.mp3', 1),
(8, 2, 4, '5,19,14', 'Mahi Mera Dil', 'upload/images/songs/Dhokha-Round-D.jpg', '<p>Dhokha Round D Corner &nbsp;by Arijit Singh, Tulsi Kumar, Tanishk Bagchi, Kumaar</p>', '<p>beparwah hai maahi mera<br />puchhe naa mera haal ve<br />kisi gal da vi jawaab naa deve<br />मेरे रोते रहे सवाल वे</p>', 'local', 'upload/files/test3.mp3', 1),
(9, 3, 5, '4,9', 'Dreamers Music', 'upload/images/songs/Dreamers-Music-from-the-FIFA-World-Cup-Qatar.jpg', '<p>Dreamers Music</p>', '', 'local', 'upload/files/test3.mp3', 1),
(10, 2, 6, '3,20', 'Sahi Galat', 'upload/images/songs/Drishyam-2.jpg', '<p>Drishyam 2 &nbsp;by Amitabh Bhattacharya, King, Devi Sri Prasad</p>', '<p>तू जहाँ से देखता है, मैं ग़लत हूँ, तू सही<br />देख मेरी नज़रों से, ग़लत, मैं कुछ ग़लत नहीं<br />करना है जो करके ही रहूँगा मैंने तय किया<br />ग़लत को भी सही तरह से करने का निश्चय किया</p>', 'local', 'upload/files/test2.mp3', 1),
(11, 2, 6, '13,22', 'Saath Hum Rahein', 'upload/images/songs/Drishyam-2.jpg', '<p>Drishyam 2 &nbsp;by Amitabh Bhattacharya, Devi Sri Prasad, Jubin Nautiyal</p>', '<p>Jale Jab Sooraj<br />Tab Sath Hum Rahein<br />Dhale Jab Chanda<br />Tab Sath Hum Rahein</p>', 'local', 'upload/files/test3.mp3', 1),
(12, 3, 7, '1,7', 'SIMPLY THE BEST', 'upload/images/songs/ELEVATION.jpg', '<p>ELEVATION &nbsp;by Black Eyed Peas, Anitta, El Alfa ft. Anitta &amp; El Alfa</p>', '', 'local', 'upload/files/test2.mp3', 1),
(13, 3, 8, '9', 'The Greatest', 'upload/images/songs/Faith-In-The-Future.jpg', '<p>Faith In The Future (Deluxe) &nbsp;by Louis Tomlinson</p>', '', 'local', 'upload/files/test1.mp3', 1),
(14, 2, 9, '16,17', 'Manike (From \\\"Thank God\\\")', 'upload/images/songs/JhakaasRemakes.jpg', '<p>Manike (From \\\"Thank God\\\") &nbsp;by Yohani, Jubin Nautiyal, Tanishk Bagchi, Surya Ragunaathan</p>', '<p>haay, ye meri aankhen<br />raat-bhar karen baathen teri, ye teri<br />aaen jo teri yaaden<br />ruk-ruk chalem saansein meri, ye meri</p>', 'local', 'upload/files/test2.mp3', 1),
(15, 2, 9, '13,18', 'Bhool Bhulaiyaa 2 Title Track', 'upload/images/songs/JhakaasRemakes.jpg', '<p>Bhool Bhulaiyaa 2 Title Track (From \\\"Bhool Bhulaiyaa 2\\\") &nbsp;by Pritam, Tanishk Bagchi, Neeraj</p>', '', 'local', 'upload/files/test1.mp3', 1),
(16, 2, 9, '6,18,19,17', 'Tip Tip (From \\\"Sooryavanshi\\\")', 'upload/images/songs/JhakaasRemakes.jpg', '<p>Tip Tip (From \\\"Sooryavanshi\\\") &nbsp;by Udit Narayan, Alka Yagnik, Tanishk Bagchi, Viju Shah</p>', '', 'local', 'upload/files/test3.mp3', 1),
(17, 3, 10, '12', 'Just A Kiss (Muah)', 'upload/images/songs/Just-A-Kiss-Muah.jpg', '<p>Just A Kiss (Muah) &nbsp;by Enisa</p>', '', 'local', 'upload/files/test3.mp3', 1),
(18, 2, 11, '18,21', 'Singara Siriye', 'upload/images/songs/Kantara-Hindi.jpg', '<p>Kantara &nbsp;by B. Ajaneesh Loknath, Vijay Prakash, Ananya Bhat, Nagraj Panar Valtur</p>', '', 'local', 'upload/files/test1.mp3', 1),
(19, 2, 12, '5', 'Phir Na Aisi Raat Aayegi', 'upload/images/songs/Laal-Singh-Chaddha.jpg', '<p>Laal Singh Chaddha &nbsp;by Pritam, Arijit Singh, Amitabh Bhattacharya</p>', '<p>phir naa aisee raat aaegee<br />yoon hamein jo saath laaegi<br />phir naa aisee raat aaegee<br />yoon hamein jo saath laaegi</p>', 'local', 'upload/files/test3.mp3', 1),
(20, 2, 12, '5,13', 'Kahani', 'upload/images/songs/Laal-Singh-Chaddha.jpg', '<p>Laal Singh Chaddha &nbsp;by Pritam, Mohan Kannan, Amitabh Bhattacharya</p>', '<p>pam-paa-raa-raa-raa-ram</p>\r\n<p>pam-paa-raa-raa-raa-ram</p>', 'local', 'upload/files/test2.mp3', 1),
(21, 2, 12, '5,18', 'Tere Hawaale', 'upload/images/songs/Laal-Singh-Chaddha.jpg', '<p>Laal Singh Chaddha &nbsp;by Pritam, Arijit Singh, Shilpa Rao</p>', '<p>Mainu Chadeya Ishq Mein Rang Tera<br />Ik Ho Gaya Ang Mera Ang Tera<br />Rab Mileya Jad Mileya<br />Maahi Mainu Sang Tera</p>', 'local', 'upload/files/test3.mp3', 1),
(22, 3, 13, '12', 'Lavender Haze', 'upload/images/songs/Midnights.jpg', '<p>Midnights &nbsp;by Taylor Swift</p>', '', 'local', 'upload/files/test1.mp3', 1),
(23, 3, 14, '2', 'Never Let You Go', 'upload/images/songs/Never-Let-You-Go.jpg', '<p>My World 2.0 &nbsp;by Justin Bieber</p>', '', 'local', 'upload/files/test2.mp3', 1),
(24, 3, 15, '1', 'Nightbird', 'upload/images/songs/Nightbird.jpg', '<p>Nightbird &nbsp;by DJ Snake</p>', '', 'local', 'upload/files/test2.mp3', 1),
(25, 2, 16, '11,10', 'Dil De Diya', 'upload/images/songs/Thank-God.jpg', '<p>Thank God &nbsp;by Rochak Kohli, Anand Raaj Anand, Rashmi Virag, Sameer</p>', '<p>rukh zindagi ne mod liya kaisa?<br />hamne sochaa nahin tha kabhi aisa<br />rukh zindagi ne mod liya kaisa?<br />hamne sochaa nahin tha kabhi aisa</p>', 'local', 'upload/files/test1.mp3', 1),
(26, 2, 16, '5,22', 'Thank God', 'upload/images/songs/Thank-God.jpg', '<p>Thank God &nbsp;by Rochak Kohli, Arijit Singh, Eklavya</p>', '<p>Ye Pyari Subah Tumhari<br />Naye Naye Phool Layi Hai<br />Thank God<br />Khoye Khoye Panchi Raaton Ke<br />Kahin Se Ye Dhundh Layi Hai</p>', 'local', 'upload/files/test3.mp3', 1),
(27, 2, 17, '8,22,10', 'Alcoholia', 'upload/images/songs/Vikram-Vedha.jpg', '<p>Vikram Vedha &nbsp;by Vishal-Sheykhar, Snigdhajit Bhowmik, Ananya Chakraborty</p>', '', 'local', 'upload/files/test2.mp3', 1),
(28, 2, 17, '3,21', 'Bande', 'upload/images/songs/Vikram-Vedha.jpg', '<p>Vikram Vedha &nbsp;by Vishal-Sheykhar, Snigdhajit Bhowmik, Ananya Chakraborty</p>', '<p>bande, kaalaa kya, safed kya, ki donon mein hai bhed kya<br />ye khwaah-makhaah nazar kee bhool hai<br />bande, bhale-bure mein farq kya, hai swarg kya, hai nark kya<br />ye paap-punya saba fizool hain</p>', 'local', 'upload/files/test3.mp3', 1),
(29, 2, 17, '3,14,21,18', 'Yaara', 'upload/images/songs/Vikram-Vedha.jpg', '<p>Vikram Vedha &nbsp;by Armaan Malik</p>', '', 'local', 'upload/files/test1.mp3', 1),
(30, 2, 17, '19,21,17,16', 'Oo Saahiba', 'upload/images/songs/Vikram-Vedha.jpg', '<p>Vikram Vedha &nbsp;by Vishal-Sheykhar, Sheykhar Ravjiani</p>', '<p>सौदेबाज़ियाँ ये दिल की हैं मुश्किल भरी<br />सौदेबाज़ियाँ ये दिल की हैं मुश्किल भरी<br />भा गई मगर तेरी जादूगरी</p>', 'local', 'upload/files/test3.mp3', 1);

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

--
-- Table structure for table `subscription_plan`
--

CREATE TABLE `subscription_plan` (
  `id` int(11) NOT NULL,
  `plan_name` varchar(255) NOT NULL,
  `plan_days` int(11) NOT NULL,
  `plan_duration` varchar(255) NOT NULL,
  `plan_duration_type` varchar(255) NOT NULL,
  `plan_price` decimal(11,2) NOT NULL,
  `plan_device_limit` int(3) NOT NULL DEFAULT 1,
  `ads_on_off` int(1) NOT NULL DEFAULT 0,
  `download_on_off` int(1) NOT NULL DEFAULT 0,
  `status` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `subscription_plan`
--

INSERT INTO `subscription_plan` (`id`, `plan_name`, `plan_days`, `plan_duration`, `plan_duration_type`, `plan_price`, `plan_device_limit`, `ads_on_off`, `download_on_off`, `status`) VALUES
(1, 'Free Plan', 7, '7', '1', 0.00, 1, 1, 0, 1),
(2, 'Basic Plan', 30, '1', '30', 9.00, 1, 0, 0, 1),
(3, 'Premium Plan', 180, '6', '30', 49.00, 2, 0, 0, 1),
(4, 'Platinum Plan', 365, '1', '365', 99.00, 2, 0, 0, 1);

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

--
-- Table structure for table `suggestion`
--

CREATE TABLE `suggestion` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `message` varchar(255) DEFAULT NULL,
  `date` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `transaction`
--

CREATE TABLE `transaction` (
  `id` bigint(20) NOT NULL,
  `user_id` int(11) NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `plan_id` int(11) DEFAULT NULL,
  `rent_id` int(11) DEFAULT NULL,
  `gateway` varchar(255) NOT NULL,
  `payment_amount` varchar(255) NOT NULL,
  `payment_id` varchar(255) NOT NULL,
  `date` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `usertype` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'User',
  `social_login_type` varchar(255) DEFAULT NULL,
  `google_id` varchar(255) DEFAULT NULL,
  `facebook_id` varchar(255) DEFAULT NULL,
  `name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `email` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `password` varchar(255) NOT NULL,
  `phone` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `user_address` varchar(500) DEFAULT NULL,
  `user_image` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `plan_id` int(2) DEFAULT NULL,
  `start_date` int(11) DEFAULT NULL,
  `exp_date` int(11) DEFAULT NULL,
  `plan_amount` float(11,2) DEFAULT NULL,
  `status` int(1) NOT NULL DEFAULT 1,
  `confirmation_code` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `remember_token` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `session_id` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `usertype`, `social_login_type`, `google_id`, `facebook_id`, `name`, `email`, `password`, `phone`, `user_address`, `user_image`, `plan_id`, `start_date`, `exp_date`, `plan_amount`, `status`, `confirmation_code`, `remember_token`, `session_id`, `created_at`, `updated_at`) VALUES
(1, 'Admin', NULL, NULL, NULL, 'Viavi Webtech', 'admin@admin.com', '$2y$10$EMeDkbAwIXJd7fAX0pWF2OZCHmKuGMwtD3ZUjg9HEOMvkaVl.5Xvm', '9227777522', NULL, 'viavi-webtech-1f2416ecff3faba4159de6b399477081-b.jpg', NULL, NULL, NULL, NULL, 1, NULL, 'MbNBAqTLdxswfESBSw1hHaJ9TXNPaU0TCZtY1BvGifl1iQswjwokqmtIHqFD', 'iXL5Efee1FhfiXQzxPTe2PzEfFqU3seM3b6TzvU7', '2020-03-11 06:16:45', '2022-11-28 10:59:27');

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

--
-- Table structure for table `users_device_history`
--

CREATE TABLE `users_device_history` (
  `id` bigint(20) NOT NULL,
  `user_id` int(11) NOT NULL,
  `user_device_name` varchar(255) NOT NULL,
  `user_session_name` varchar(255) NOT NULL,
  `date_time` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `album`
--
ALTER TABLE `album`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `analytics`
--
ALTER TABLE `analytics`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `app_ads`
--
ALTER TABLE `app_ads`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `artists`
--
ALTER TABLE `artists`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `favourite`
--
ALTER TABLE `favourite`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `home_sections`
--
ALTER TABLE `home_sections`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `pages`
--
ALTER TABLE `pages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
  ADD PRIMARY KEY (`id`),
  ADD KEY `password_resets_email_index` (`email`),
  ADD KEY `password_resets_token_index` (`token`);

--
-- Indexes for table `payment_gateway`
--
ALTER TABLE `payment_gateway`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `playlist`
--
ALTER TABLE `playlist`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `post_ratings`
--
ALTER TABLE `post_ratings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `post_views`
--
ALTER TABLE `post_views`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `reports`
--
ALTER TABLE `reports`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `slider`
--
ALTER TABLE `slider`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `songs`
--
ALTER TABLE `songs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `subscription_plan`
--
ALTER TABLE `subscription_plan`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `suggestion`
--
ALTER TABLE `suggestion`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `transaction`
--
ALTER TABLE `transaction`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users_device_history`
--
ALTER TABLE `users_device_history`
  ADD PRIMARY KEY (`id`),
  ADD KEY `userid` (`user_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `album`
--
ALTER TABLE `album`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `analytics`
--
ALTER TABLE `analytics`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `app_ads`
--
ALTER TABLE `app_ads`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `artists`
--
ALTER TABLE `artists`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `favourite`
--
ALTER TABLE `favourite`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `home_sections`
--
ALTER TABLE `home_sections`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `pages`
--
ALTER TABLE `pages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `password_resets`
--
ALTER TABLE `password_resets`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `payment_gateway`
--
ALTER TABLE `payment_gateway`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `playlist`
--
ALTER TABLE `playlist`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `post_ratings`
--
ALTER TABLE `post_ratings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `post_views`
--
ALTER TABLE `post_views`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `reports`
--
ALTER TABLE `reports`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `slider`
--
ALTER TABLE `slider`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `songs`
--
ALTER TABLE `songs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT for table `subscription_plan`
--
ALTER TABLE `subscription_plan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `suggestion`
--
ALTER TABLE `suggestion`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `transaction`
--
ALTER TABLE `transaction`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `users_device_history`
--
ALTER TABLE `users_device_history`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
 
