-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `videos_live`
--

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

--
-- Table structure for table `categorys`
--

CREATE TABLE `categorys` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `categorys`
--

INSERT INTO `categorys` (`id`, `name`, `logo`, `created_at`, `updated_at`) VALUES
(1, 'Love - Romantic', 'https://cdn.shopify.com/s/files/1/1061/1924/files/Crying_Emoji_Icon.png', NULL, NULL),
(2, 'Sad', 'https://cdn.shopify.com/s/files/1/1061/1924/files/Crying_Emoji_Icon.png', NULL, NULL),
(3, 'Dance - Party', 'https://cdn.shopify.com/s/files/1/1061/1924/files/Crying_Emoji_Icon.png', NULL, NULL),
(4, 'Funny', 'https://cdn.shopify.com/s/files/1/1061/1924/files/Crying_Emoji_Icon.png', NULL, NULL),
(5, 'Festival', 'https://cdn.shopify.com/s/files/1/1061/1924/files/Crying_Emoji_Icon.png', NULL, NULL),
(6, 'Inspiration', 'https://cdn.shopify.com/s/files/1/1061/1924/files/Crying_Emoji_Icon.png', NULL, NULL),
(7, 'Dialogue', 'https://cdn.shopify.com/s/files/1/1061/1924/files/Crying_Emoji_Icon.png', NULL, NULL),
(8, 'Emotinal', 'https://cdn.shopify.com/s/files/1/1061/1924/files/Crying_Emoji_Icon.png', NULL, NULL),
(9, 'Sufi', 'https://cdn.shopify.com/s/files/1/1061/1924/files/Crying_Emoji_Icon.png', NULL, NULL),
(10, 'Greetings', 'https://cdn.shopify.com/s/files/1/1061/1924/files/Crying_Emoji_Icon.png', NULL, NULL),
(11, 'Devotional', 'https://cdn.shopify.com/s/files/1/1061/1924/files/Crying_Emoji_Icon.png', NULL, NULL),
(12, 'Other', 'https://cdn.shopify.com/s/files/1/1061/1924/files/Crying_Emoji_Icon.png', NULL, NULL);

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

--
-- Table structure for table `languages`
--

CREATE TABLE `languages` (
  `id` int(11) NOT NULL,
  `value` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `languages`
--

INSERT INTO `languages` (`id`, `value`, `created_at`, `updated_at`) VALUES
(1, 'Hindi', '2018-07-05 18:30:00', NULL),
(2, 'Punjabi', '2018-07-05 18:30:00', NULL),
(3, 'English', '2018-07-05 18:30:00', NULL),
(4, 'Gujarati', '2018-07-05 18:30:00', NULL),
(5, 'Marathi', '2018-07-05 18:30:00', NULL),
(6, 'Tamil', '2018-07-05 18:30:00', NULL),
(7, 'Kannada', '2018-07-05 18:30:00', NULL),
(8, 'Telugu', '2018-07-05 18:30:00', NULL),
(9, 'Bhojpuri', '2018-07-05 18:30:00', NULL),
(10, 'Haryanvi', '2018-07-05 18:30:00', NULL);

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1);

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

--
-- Table structure for table `notification_register`
--

CREATE TABLE `notification_register` (
  `id` int(11) NOT NULL,
  `register_id` varchar(255) DEFAULT NULL,
  `device_id` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `notification_register`
--

INSERT INTO `notification_register` (`id`, `register_id`, `device_id`, `created_at`, `updated_at`) VALUES
(5, '7ecc013a-23ca-4cac-ba6c-8bcec8776b8e', '5fc28d837acf02c3', '2018-09-16 14:40:31', '2018-09-16 14:40:31');

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

--
-- Table structure for table `videos`
--

CREATE TABLE `videos` (
  `id` int(11) NOT NULL,
  `thumbnail` varchar(255) DEFAULT NULL,
  `path` varchar(255) DEFAULT NULL,
  `size` varchar(255) DEFAULT NULL,
  `view` int(11) DEFAULT '0',
  `category_id` int(11) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `language` varchar(255) DEFAULT NULL,
  `language_id` int(11) DEFAULT NULL,
  `video_of_day` tinyint(1) DEFAULT '0',
  `username` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `status` int(2) DEFAULT '0',
  `notification` tinyint(4) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `videos`
--

INSERT INTO `videos` (`id`, `thumbnail`, `path`, `size`, `view`, `category_id`, `title`, `language`, `language_id`, `video_of_day`, `username`, `email`, `status`, `notification`, `created_at`, `updated_at`) VALUES
(21, 'Ganesh-Chaturthi-HD-Images-Wallpapers-Free-Download-9.jpg', 'videoplayback(1).mp4', '1.36 MB', 0, 11, 'GaneshJI Stuti', 'Gujarati', 4, 0, 'Jones', 'Jones@gmail.com', 1, 1, '2018-09-15 01:15:37', '2018-09-15 01:15:42'),
(25, 'Screenshot_2018-09-12-23-39-54-283_com.mxtech.videoplayer.ad.png', 'statusdashboardHeartEnglishSong-WhatsappStatus-systemstatusdashboard-MTRomentic.mp4', '2.08 MB', 0, 1, 'Heart Bits', 'English', 3, 0, 'Jones', 'jones@gmail.com', 1, 1, '2018-09-16 14:41:34', '2018-09-16 14:55:24');

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

--
-- Table structure for table `viewlike`
--

CREATE TABLE `viewlike` (
  `id` int(11) NOT NULL,
  `video_id` int(11) NOT NULL,
  `phone_id` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

