File: /home/barbeatleanalyti/public_html/beatleanalytics.com/sql_file/beatle.sql
-- phpMyAdmin SQL Dump
-- version 4.6.6deb5
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Oct 17, 2020 at 08:31 PM
-- Server version: 5.7.29-0ubuntu0.18.04.1
-- PHP Version: 7.2.24-0ubuntu0.18.04.4
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 utf8mb4 */;
--
-- Database: `beatle`
--
-- --------------------------------------------------------
--
-- Table structure for table `beatle_blog`
--
CREATE TABLE `beatle_blog` (
`id` bigint(11) NOT NULL,
`created_by` int(11) NOT NULL,
`blog_title` varchar(255) NOT NULL,
`blog_image` varchar(255) NOT NULL,
`blog_description` text NOT NULL,
`blog_video_link` varchar(255) NOT NULL,
`blog_start_date` datetime NOT NULL,
`blog_terms` int(11) NOT NULL,
`status` int(11) NOT NULL,
`created_date` datetime NOT NULL,
`updated_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `beatle_blog`
--
INSERT INTO `beatle_blog` (`id`, `created_by`, `blog_title`, `blog_image`, `blog_description`, `blog_video_link`, `blog_start_date`, `blog_terms`, `status`, `created_date`, `updated_date`) VALUES
(1, 1, 'sdf sdf sdfghjhfmhgh hjgfg dfh', '1602405890_blogImage.jpg', '<p>as dfasdfasfd agfdhffasg dffffsgnfffdsdgffdsg</p><p>Fortnite season 4 is right around the corner, and the anticipation is\r\n at an all-time high. Fortnite is a free to play battle royale game that\r\n has taken the gaming world by surprise. Fortnite keeps the players \r\nengaged by updating their game from time to time and releasing new and \r\nexciting content quite frequently. According to the teases and the comic\r\n book paper trail left by Fortnite, it seems like season 4 is going to \r\nbe a Marvel-themed one, and the Fortnite season 4 win umbrella looks \r\nlike it\'s straight out of a Marvel Movie too.\r\n\r\n</p>', 'as dfasdfasd ddfdgf', '2020-10-12 13:44:00', 0, 0, '2020-10-11 14:14:50', '2020-10-11 14:37:26'),
(2, 1, 'sd fgsdgfgfd', '1602580421_blogImage.jpg', '<p> sdfgsdfg<br></p>', 'as dfasdfasd', '2020-10-11 13:43:00', 0, 0, '2020-10-13 14:43:41', '0000-00-00 00:00:00'),
(3, 1, 'ankit', '1602580461_blogImage.jpg', '<p>test<br></p>', 'as dfasdfasd ddfdgf', '2020-10-15 13:44:00', 0, 0, '2020-10-13 14:44:21', '0000-00-00 00:00:00'),
(4, 1, 'test', '1602587587_blogImage.jpg', '<p>sdf sdfgdfgf<br></p>', 'as dfasdfasd', '2043-11-13 00:00:00', 0, 3, '2020-10-13 16:43:16', '2020-10-13 16:43:22');
-- --------------------------------------------------------
--
-- Table structure for table `beatle_comment`
--
CREATE TABLE `beatle_comment` (
`id` bigint(11) NOT NULL,
`blog_id` int(11) NOT NULL,
`user_comment_id` int(11) NOT NULL,
`blog_comment` text NOT NULL,
`created_date` datetime NOT NULL,
`updated_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `beatle_comment`
--
INSERT INTO `beatle_comment` (`id`, `blog_id`, `user_comment_id`, `blog_comment`, `created_date`, `updated_date`) VALUES
(1, 1, 45, 'sdfsfsdf', '2020-10-17 15:31:58', '0000-00-00 00:00:00'),
(2, 1, 45, 'dfgsdfgfdg', '2020-10-17 15:32:50', '0000-00-00 00:00:00'),
(3, 1, 45, 'sfdsfgdfgfgfgfgf', '2020-10-17 15:35:20', '0000-00-00 00:00:00'),
(4, 1, 45, 'dfgfdg', '2020-10-17 15:36:36', '0000-00-00 00:00:00'),
(5, 1, 45, 'sfsdfsdf', '2020-10-17 15:37:30', '0000-00-00 00:00:00'),
(6, 1, 47, 'asdasdas', '2020-10-17 15:39:37', '0000-00-00 00:00:00'),
(7, 2, 45, 'sdfsdf', '2020-10-17 16:47:06', '0000-00-00 00:00:00'),
(8, 2, 45, 'asfdasd', '2020-10-17 19:29:18', '0000-00-00 00:00:00'),
(9, 2, 48, 'sdfsadfsaf', '2020-10-17 19:32:24', '0000-00-00 00:00:00'),
(10, 2, 48, 'sdfds', '2020-10-17 19:32:44', '0000-00-00 00:00:00'),
(11, 2, 48, 'sdfds', '2020-10-17 19:38:43', '0000-00-00 00:00:00'),
(12, 2, 48, 'sdsdf', '2020-10-17 19:39:09', '0000-00-00 00:00:00'),
(13, 2, 48, 'sdsdf', '2020-10-17 19:39:45', '0000-00-00 00:00:00'),
(14, 2, 48, 'sdsdf', '2020-10-17 19:40:59', '0000-00-00 00:00:00'),
(15, 2, 48, 'sdsdf', '2020-10-17 19:41:22', '0000-00-00 00:00:00'),
(16, 2, 48, 'sdsdf', '2020-10-17 19:41:31', '0000-00-00 00:00:00');
-- --------------------------------------------------------
--
-- Table structure for table `beatle_news`
--
CREATE TABLE `beatle_news` (
`id` bigint(11) NOT NULL,
`created_by` int(11) NOT NULL,
`news_title` varchar(255) NOT NULL,
`news_image` varchar(255) NOT NULL,
`news_description` text NOT NULL,
`news_video_link` varchar(255) NOT NULL,
`news_start_time` datetime NOT NULL,
`news_terms` int(11) NOT NULL,
`status` int(11) NOT NULL,
`created_date` datetime NOT NULL,
`updated_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `beatle_news`
--
INSERT INTO `beatle_news` (`id`, `created_by`, `news_title`, `news_image`, `news_description`, `news_video_link`, `news_start_time`, `news_terms`, `status`, `created_date`, `updated_date`) VALUES
(1, 0, 'test', '1602398405_newsImage.jpg', '<div class=\"blog-d-content\">\r\n <h4>Fortnite Season 4 Victory Umbrella looks straight-up fire, check it out right now </h4>\r\n <p>Fortnite season 4 is right around the \r\ncorner, and the anticipation is at an all-time high. Fortnite is a free \r\nto play battle royale game that has taken the gaming world by surprise. \r\nFortnite keeps the players engaged by updating their game from time to \r\ntime and releasing new and exciting content quite frequently. According \r\nto the teases and the comic book paper trail left by Fortnite, it seems \r\nlike season 4 is going to be a Marvel-themed one, and the Fortnite \r\nseason 4 win umbrella looks like it\'s straight out of a Marvel Movie \r\ntoo.\r\n\r\n</p>\r\n <p>Fortnite\'s victory umbrellas are gliders \r\nplayers can use to get around the map. These victory umbrellas can be \r\nunlocked only in the best way possible, by achieving victory royale in \r\nany of the multiplayer modes. Fortnite launches a new victory umbrella \r\nfor every season-themed according to the season, and the veterans keep \r\nthese as a collection for boasting purposes. The Fortnite season 4 win \r\numbrella, called the \'Mighty Marvel Brella,\' is a glossy dark purplish \r\numbrella with a fire red lined pattern and electrified on the top.\r\n\r\n</p>\r\n <blockquote>\r\n <p>\r\n This was a very cool looking \r\numbrella with a red dragon spread across the top, which looked quite \r\nnice while gliding through the map.\r\n\r\n\r\n </p>\r\n </blockquote>\r\n \r\n <p>Ascqetur rsidicfulus mus donefc quamaem felis, ultriciddedes nec, pefflsl tesquwdfe eu, pr etiu\r\n qui fa cadaiis sem. Cum socadaiis nato qfuae pent ibaus et magnsfis dis parturient mon tes,\r\n nascqetur rsidi icfulus mus. Ibaus et magnsfis dis parturient te.</p>\r\n \r\n \r\n </div>\r\n <p><br></p>\r\n <p>Curabitur vel tincidunt dui. Duis \r\nvestibulum eget velit sit amet aliquet. Curabitur vitae cursus ex. \r\nAliquam pulvinar \r\n vulputate ullamcorper. Maecenas luctus in \r\neros et aliquet. Cras auctor luctus nisl a consectetur. Morbi hendrerit \r\nnisi nunc, quis\r\n egestas nibh consectetur nec. Aliquam vel \r\nlorem enim. Vestibulum ante ipsum primis in faucibus orci luctus et \r\nultrices posuere \r\n cubilia Curae; Nunc placerat, enim quis \r\nvarius luctus, enim arcu tincidunt purus, in vulputate tortor mi a \r\ntortor. Praesent porta \r\n ornare fermentum. Praesent sed ligula at \r\nante tempor posuere a at lorem.\r\n </p>', 'https://www.youtube.com/watch?v=KtnAVJyphf8&list=RDnsR3AlZbjZM&index=3', '2020-10-15 09:47:00', 0, 2, '2020-10-13 16:44:00', '2020-10-13 16:44:08'),
(2, 0, 'test rts edr ts', '1602389832_newsImage.jpg', '<p>asdf asfa sdfasdfas dvfadsf fva d</p><p>asd fa</p><p>sdf</p><p>a sdf</p><p>asdf<br></p>', 'terst', '2020-10-08 21:47:00', 0, 0, '2020-10-11 09:47:12', '2020-10-11 09:48:57'),
(3, 1, 'test rts edr ts', '1602579693_newsImage.jpg', '<p>dsgsdfgdfgd<br></p>', 'https://www.youtube.com/watch?v=PlIoHp6v3LI&list=RDnsR3AlZbjZM&index=2', '0003-08-21 00:00:00', 0, 0, '2020-10-13 14:31:33', '0000-00-00 00:00:00'),
(4, 1, 'Committed to provide security to family of Hathras victim, U.P. govt tells Supreme Court', '1602670705_newsImage.jpg', '<pre><div class=\"hidden-xs\" style=\"-webkit-font-smoothing: antialiased; color: rgb(80, 80, 80); font-family: \"><h2 class=\"intro\" style=\"-webkit-font-smoothing: antialiased; margin: 18px 30px 10px; padding: 0px; font-size: 18px; line-height: 25px; border-bottom: 0px; color: rgb(19, 59, 90); width: 600px; outline: 0px !important;\">In an affidavit, State details security arrangements made for victim’s family members</h2></div><div id=\"content-body-14269002-32851452\" class=\"paywall\" style=\"-webkit-font-smoothing: antialiased; color: rgb(80, 80, 80); font-family: \"><p style=\"-webkit-font-smoothing: antialiased; font-family: TundraWeb, serif; margin-right: 30px; margin-bottom: 10px; margin-left: 30px; padding: 5px 0px 10px; font-size: 18px; line-height: 26px; color: rgb(40, 40, 40); width: 600px; outline: 0px !important;\">The Uttar Pradesh government has said it is “committed” to provide “complete security” to the family of the <a href=\"https://www.thehindu.com/news/national/other-states/dalit-girl-gang-raped-by-upper-caste-men-in-up/article32689718.ece\" title=\"\" style=\"font-weight: 600; -webkit-font-smoothing: antialiased; outline: 0px; color: rgb(59, 89, 153); transition: color 450ms ease-in-out 0s, background-color 450ms ease-in-out 0s; cursor: pointer;\">19-year-old Dalit girl who was allegedly raped </a>and murdered in Hathras.</p><p style=\"-webkit-font-smoothing: antialiased; font-family: TundraWeb, serif; margin-right: 30px; margin-bottom: 10px; margin-left: 30px; padding: 5px 0px 10px; font-size: 18px; line-height: 26px; color: rgb(40, 40, 40); width: 600px; outline: 0px !important;\">In an affidavit, the State government detailed the security arrangements made for the victim’s family members. It said there will be “no intrusion to the privacy of the victim’s family/witnesses and that they are free to move and meet the people they want”.</p></div></pre>', ' https://www.thehindu.com/news/national/committed-to-provide-security-to-family-of-hathras-victim-up-govt-tells-supreme-court/article32851452.ece', '0003-08-21 12:00:00', 0, 0, '2020-10-14 15:48:25', '0000-00-00 00:00:00');
-- --------------------------------------------------------
--
-- Table structure for table `beatle_users`
--
CREATE TABLE `beatle_users` (
`user_id` bigint(11) NOT NULL,
`username` varchar(255) NOT NULL,
`user_password` varchar(255) NOT NULL,
`first_name` varchar(255) NOT NULL,
`last_name` varchar(255) NOT NULL,
`user_email` varchar(255) NOT NULL,
`user_image` varchar(255) NOT NULL,
`user_type` int(11) NOT NULL,
`user_verification_code` varchar(100) NOT NULL,
`user_verification_status` int(11) NOT NULL,
`created_date` datetime NOT NULL,
`updated_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `beatle_users`
--
INSERT INTO `beatle_users` (`user_id`, `username`, `user_password`, `first_name`, `last_name`, `user_email`, `user_image`, `user_type`, `user_verification_code`, `user_verification_status`, `created_date`, `updated_date`) VALUES
(1, 'admin', 'e6e061838856bf47e1de730719fb2609', 'ankit', 'sharma', '', '', 1, '', 0, '2020-10-13 00:00:00', '2020-10-13 00:00:00'),
(47, 'sristy', '', '', '', 'sristy.money@gmail.com', '', 0, 'COMM677', 0, '2020-10-17 15:02:15', '0000-00-00 00:00:00'),
(48, 'ds', '', '', '', 'ankit@beatlebuddy.com', '', 0, 'COMM163', 1, '2020-10-17 19:30:44', '0000-00-00 00:00:00'),
(49, 'dfs', '', '', '', 'test@gmail.com', '', 0, 'COMM455', 0, '2020-10-17 19:42:21', '0000-00-00 00:00:00');
--
-- Indexes for dumped tables
--
--
-- Indexes for table `beatle_blog`
--
ALTER TABLE `beatle_blog`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `beatle_comment`
--
ALTER TABLE `beatle_comment`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `beatle_news`
--
ALTER TABLE `beatle_news`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `beatle_users`
--
ALTER TABLE `beatle_users`
ADD PRIMARY KEY (`user_id`),
ADD KEY `user_email` (`user_email`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `beatle_blog`
--
ALTER TABLE `beatle_blog`
MODIFY `id` bigint(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `beatle_comment`
--
ALTER TABLE `beatle_comment`
MODIFY `id` bigint(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
--
-- AUTO_INCREMENT for table `beatle_news`
--
ALTER TABLE `beatle_news`
MODIFY `id` bigint(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `beatle_users`
--
ALTER TABLE `beatle_users`
MODIFY `user_id` bigint(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=50;
/*!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 */;