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




--
-- Database: `craneblue`
--

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

--
-- Table structure for table `account_bannertb`
--

CREATE TABLE `account_bannertb` (
  `id` int(11) NOT NULL,
  `account_id` int(11) NOT NULL,
  `image_url` text NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `account_bannertb`
--

INSERT INTO `account_bannertb` (`id`, `account_id`, `image_url`, `date`, `time`) VALUES
(20, 2, '5201.jpg', '2017-08-02', '16:02:18'),
(22, 1, '13829.jpg', '2017-08-03', '08:16:40'),
(25, 3, '10564.jpg', '2017-09-03', '08:09:16');

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

--
-- Table structure for table `channeltb`
--

CREATE TABLE `channeltb` (
  `id` int(11) NOT NULL,
  `user_acc_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `image_url` text NOT NULL,
  `description` varchar(255) NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `channeltb`
--

INSERT INTO `channeltb` (`id`, `user_acc_id`, `name`, `image_url`, `description`, `date`, `time`) VALUES
(12, 2, 'best edu-tainment', '', 'entertainment', '0000-00-00', '00:00:00'),
(13, 2, 'vicent kats', '', 'sport', '0000-00-00', '00:00:00'),
(14, 1, 'dora channel', '', 'gaming', '0000-00-00', '00:00:00'),
(15, 1, 'dora 2 channel', '', 'supper sport', '0000-00-00', '00:00:00'),
(16, 2, 'Game', '', 'Gaming', '0000-00-00', '00:00:00'),
(17, 1, 'Kvt spt', '', 'All about spot', '0000-00-00', '00:00:00'),
(19, 2, 'Kvt Sport', '', 'All About Sports', '2017-08-03', '15:05:37'),
(20, 2, 'Dance Hall', '', 'All About Dance Hall music.', '2017-08-03', '15:09:06'),
(21, 1, 'Vicent', '', 'Best videos ever', '2017-08-05', '09:55:57'),
(22, 3, 'Radio new 2017', '', 'all yes', '2017-09-03', '08:09:38'),
(23, 1, 'jtkt', '25035.jpg', 'ititit', '2018-09-12', '17:01:17');

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

--
-- Table structure for table `channel_bannertb`
--

CREATE TABLE `channel_bannertb` (
  `id` int(11) NOT NULL,
  `user_acc_id` int(11) NOT NULL,
  `channel_id` int(11) NOT NULL,
  `image_url` varchar(255) NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `channel_bannertb`
--

INSERT INTO `channel_bannertb` (`id`, `user_acc_id`, `channel_id`, `image_url`, `date`, `time`) VALUES
(2, 2, 13, '19231.jpg', '0000-00-00', '00:00:00'),
(3, 2, 16, '12676.jpg', '0000-00-00', '00:00:00'),
(6, 1, 14, '31918.jpg', '0000-00-00', '00:00:00'),
(9, 1, 15, '19023.jpg', '0000-00-00', '00:00:00'),
(12, 1, 17, '26856.jpg', '0000-00-00', '00:00:00'),
(14, 2, 12, '26799.jpg', '2017-08-03', '14:24:03'),
(17, 2, 19, '12193.jpg', '2017-08-03', '15:06:53'),
(18, 3, 22, '31277.jpg', '2017-09-03', '08:10:20');

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

--
-- Table structure for table `channel_profiletb`
--

CREATE TABLE `channel_profiletb` (
  `id` int(11) NOT NULL,
  `user_acc_id` int(11) NOT NULL,
  `channel_id` int(11) NOT NULL,
  `image_name` varchar(255) NOT NULL,
  `image_url` text NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `channel_profiletb`
--

INSERT INTO `channel_profiletb` (`id`, `user_acc_id`, `channel_id`, `image_name`, `image_url`, `date`, `time`) VALUES
(55, 2, 13, '13', '26750.jpg', '0000-00-00', '00:00:00'),
(57, 1, 14, 'd', '8703.jpg', '0000-00-00', '00:00:00'),
(59, 2, 16, 'bn', '24347.jpg', '0000-00-00', '00:00:00'),
(61, 1, 15, 'yh', '28927.jpg', '0000-00-00', '00:00:00'),
(62, 1, 17, 'k', '7776.jpg', '0000-00-00', '00:00:00'),
(65, 2, 12, '10 ich.jpg', '11649.jpg', '2017-08-03', '13:40:58'),
(66, 2, 19, 'smile2.jpg', '1478.jpg', '2017-08-03', '15:09:52'),
(67, 1, 21, 'tincy 2.jpg', '27705.jpg', '2017-08-05', '09:56:34'),
(68, 3, 22, '20776703_2214538595541579_4516753530384387525_o.jpg', '27490.jpg', '2017-09-03', '08:10:31');

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

--
-- Table structure for table `craneblue_videostb`
--

CREATE TABLE `craneblue_videostb` (
  `id` int(11) NOT NULL,
  `channel_id` int(11) NOT NULL,
  `viso` varchar(255) NOT NULL,
  `video_owner_id` int(11) NOT NULL,
  `video_name` varchar(255) NOT NULL,
  `video_url` varchar(255) NOT NULL,
  `thumb_image_url` text NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `craneblue_videostb`
--

INSERT INTO `craneblue_videostb` (`id`, `channel_id`, `viso`, `video_owner_id`, `video_name`, `video_url`, `thumb_image_url`, `date`, `time`) VALUES
(82, 12, 'fc490ca45c00b1249bbe3554a4fdf6fb', 2, 'Aidah by Bobi Wine @2016', '10436.mp4', '', '0000-00-00', '00:00:00'),
(83, 13, '3295c76acbf4caaed33c36b1b5fc2cb1', 2, 'Malaika Angela Kalule 2015-craneblue', '5567.mp4', '', '0000-00-00', '00:00:00'),
(84, 12, '735b90b4568125ed6c3f678819b6e058', 2, 'Byagana by and Weasel ft Ziza Bafana-crane blue', '13547.mp4', '', '0000-00-00', '00:00:00'),
(85, 13, 'a3f390d88e4c41f2747bfa2f1b5f87db', 2, 'Nsika by Carol Nantongo 2015 -CraneBlue.', '10100.mp4', '', '0000-00-00', '00:00:00'),
(86, 15, '14bfa6bb14875e45bba028a21ed38046', 1, 'obupangisa Dax Kartel ugandan music-craneblue', '3346.mp4', '', '0000-00-00', '00:00:00'),
(87, 14, '7cbbc409ec990f19c78c75bd1e06f215', 1, 'Ability By  Radio & Weasel ft Rabadaba-Craneblue.mp4', '15547.mp4', '', '0000-00-00', '00:00:00'),
(88, 14, 'e2c420d928d4bf8ce0ff2ec19b371514', 1, 'Mwana Gwe by King Saha Ugandan music - craneblue.mp4', '23860.mp4', '', '0000-00-00', '00:00:00'),
(89, 15, '32bb90e8976aab5298d5da10fe66f21d', 1, 'Burn dem by Bobi Wine uganadn music -craneblue.mp4', '11686.mp4', '', '0000-00-00', '00:00:00'),
(90, 14, 'd2ddea18f00665ce8623e36bd4e3c7c5', 1, 'Nkwatako Sheeba Kalungi ugandan music - craneblue.mp4', '18213.mp4', '', '0000-00-00', '00:00:00'),
(91, 17, 'd09bf41544a3365a46c9077ebb5e35c3', 1, 'Kabite craneblue.mp4', '23293.mp4', '', '2017-04-07', '15:02:49'),
(92, 19, 'fbd7939d674997cdb4692d34de8633c4', 2, 'Good life new2017', '770.mp4', '', '2017-08-03', '15:51:07'),
(93, 22, '28dd2c7955ce926456240b2ff0100bde', 3, 'Aidah by bobi wine', '17651.mp4', '', '2017-09-03', '08:11:00'),
(96, 21, 'f033ab37c30201f73f142449d037028d', 1, 'Kyerenga H.E Bobi Wine 2018 -craneblue.mp4', '6418.mp4', '', '2018-08-28', '16:49:16'),
(97, 21, '43ec517d68b6edd3015b3edc9a11367b', 1, 'Nakeesa Rmx Last video of Radio -craneblue New Ugan', '13024.mp4', '', '2018-08-28', '17:53:23'),
(98, 21, '9778d5d219c5080b9a6a17bef029331c', 1, 'Kyerenga H.E Bobi Wine 2018 -craneblue.mp4', '14603.mp4', '', '2018-08-28', '17:57:58'),
(99, 21, 'fe9fc289c3ff0af142b6d3bead98a923', 1, 'Kyerenga H.E Bobi Wine 2018 -craneblue.mp4', '30232.mp4', '17915', '2018-08-29', '11:38:53'),
(100, 21, '68d30a9594728bc39aa24be94b319d21', 1, 'Nakeesa Rmx Last video of Radio -craneblue New Ugan', '32639.mp4', '2.jpg', '2018-08-29', '11:43:40'),
(101, 21, '3ef815416f775098fe977004015c6193', 1, 'Kyerenga H.E Bobi Wine 2018 -craneblue.mp4', '15538.mp4', '2.jpg', '2018-08-29', '11:52:30'),
(102, 21, '93db85ed909c13838ff95ccfa94cebd9', 1, 'Kyerenga H.E Bobi Wine 2018 -craneblue.mp4', '3446.mp4', '18449', '2018-08-29', '12:15:42'),
(103, 21, 'c7e1249ffc03eb9ded908c236bd1996d', 1, 'Kyerenga H.E Bobi Wine 2018 -craneblue.mp4', '9132.mp4', '7519', '2018-08-29', '12:18:14'),
(104, 21, '2a38a4a9316c49e5a833517c45d31070', 1, 'Kyerenga H.E Bobi Wine 2018 -craneblue.mp4', '2818.mp4', '21581', '2018-08-29', '12:20:49'),
(105, 21, '7647966b7343c29048673252e490f736', 1, 'Kyerenga H.E Bobi Wine 2018 -craneblue.mp4', '12411.mp4', '12298', '2018-08-29', '12:32:49'),
(106, 21, '8613985ec49eb8f757ae6439e879bb2a', 1, 'Nakeesa Rmx Last video of Radio -craneblue New Ugan', '21432.mp4', '5659', '2018-08-29', '12:42:11'),
(107, 21, '54229abfcfa5649e7003b83dd4755294', 1, 'Kyerenga H.E Bobi Wine 2018 -craneblue.mp4', '30449.mp4', '20120', '2018-08-29', '12:50:27'),
(108, 21, '92cc227532d17e56e07902b254dfad10', 1, 'Kyerenga H.E Bobi Wine 2018 -craneblue.mp4', '9233.mp4', '31800', '2018-08-29', '12:55:41'),
(109, 21, '98dce83da57b0395e163467c9dae521b', 1, 'Kyerenga H.E Bobi Wine 2018 -craneblue.mp4', '11667.mp4', '11670.jpg', '2018-08-29', '13:21:50'),
(110, 21, 'f4b9ec30ad9f68f89b29639786cb62ef', 1, 'Nakeesa Rmx Last video of Radio -craneblue New Ugan', '22871.mp4', '17110', '2018-08-29', '13:39:28'),
(111, 21, '812b4ba287f5ee0bc9d43bbf5bbe87fb', 1, 'Nakeesa Rmx Last video of Radio -craneblue New Ugan', '13769.mp4', '25040', '2018-08-29', '13:43:24'),
(112, 21, '26657d5ff9020d2abefe558796b99584', 1, 'Kyerenga H.E Bobi Wine 2018 -craneblue.mp4', '13299.mp4', '13922', '2018-08-29', '13:44:54'),
(113, 21, 'e2ef524fbf3d9fe611d5a8e90fefdc9c', 1, 'Nakeesa Rmx Last video of Radio -craneblue New Ugan', '7031.mp4', '7032.jpg', '2018-08-29', '13:50:04'),
(114, 21, 'ed3d2c21991e3bef5e069713af9fa6ca', 1, 'Kyerenga H.E Bobi Wine 2018 -craneblue.mp4', '14968.mp4', '14969.jpg', '2018-08-29', '13:51:33'),
(115, 21, 'ac627ab1ccbdb62ec96e702f07f6425b', 1, 'Nakeesa Rmx Last video of Radio -craneblue New Ugan', '26697.mp4', '26701.jpg', '2018-08-29', '14:06:33'),
(116, 21, 'f899139df5e1059396431415e770c6dd', 1, 'Nakeesa Rmx Last video of Radio -craneblue New Ugan', '24412.mp4', '24414.jpg', '2018-08-29', '14:12:32'),
(117, 21, '38b3eff8baf56627478ec76a704e9b52', 1, 'Nakeesa Rmx Last video of Radio -craneblue New Ugan', '18031.mp4', '18036.jpg', '2018-08-29', '14:17:34'),
(118, 21, 'ec8956637a99787bd197eacd77acce5e', 1, 'Vinka - Chips N Ketchup (Official HD Video) Ugandan-craneblue', '28749.mp4', '28750.jpg', '2018-08-29', '15:42:56'),
(119, 21, '6974ce5ac660610b44d9b9fed0ff9548', 1, 'Sheebah - Mummy yo - craneblue', '30739.mp4', '30466', '2018-08-29', '15:47:33'),
(120, 21, 'c9e1074f5b3f9fc8ea15d152add07294', 1, 'Kangume - Gravity Omutujju[Official Video] - craneblue', '17849.mp4', '30744.jpg', '2018-08-29', '15:53:14'),
(121, 21, '65b9eea6e1cc6bb9f0cd2a47751a186f', 1, 'Malaika - Vinka -craneblue', '31071.mp4', '31071.jpg', '2018-08-29', '16:05:01'),
(122, 17, 'f0935e4cd5920aa6c7c996a5ee53a70f', 1, 'Kyerenga H.E Bobi Wine 2018 -craneblue.mp4', '10599.mp4', '10604.jpg', '2018-08-29', '16:09:31'),
(123, 21, 'a97da629b098b75c294dffdc3e463904', 1, 'VINKA - Only Love You -craneblue', '17147.mp4', '31882', '2018-08-29', '16:19:35'),
(124, 15, 'a3c65c2974270fd093ee8a9bf8ae7d0b', 1, 'irene Ntale - Miss Kateteyi ( Official Video ) 2018 -craneblue', '21650.mp4', '21654.jpg', '2018-08-29', '16:24:54'),
(125, 14, '2723d092b63885e0d7c260cc007e8b9d', 1, 'Nakeesa Rmx Last video of Radio -craneblue New Ugan', '30833.mp4', '30838.jpg', '2018-08-29', '16:37:50'),
(126, 21, '5f93f983524def3dca464469d2cf9f3e', 1, 'Fantasy - (Jory Boy Type) Reggaeton Instrumental Free', '26108.mp4', '17151.jpg', '2018-08-29', '16:56:32'),
(127, 15, '698d51a19d8a121ce581499d7b701668', 1, 'Gratis Reggaeton Romantico Instrumental (Diamante & Kya-craneblue', '9662.mp4', '9663.jpg', '2018-09-01', '09:43:09'),
(128, 15, '7f6ffaa6bb0b408017b62254211691b5', 1, 'Actress - Sensual ✘ Rap Instrumental ( Prod_Danny E.B ) - craneblue', '2904.mp4', '2909.jpg', '2018-09-01', '09:46:03'),
(129, 15, '73278a4a86960eeb576a8fd4c9ec6997', 1, 'Beautiful smoke  Reggae Instrumental (Prod _ Danny E.B) -craneblue', '22621.mp4', '22623.jpg', '2018-09-01', '10:00:44'),
(130, 17, '5fd0b37cd7dbbb00f97ba6ce92bf5add', 1, 'Donde Estas Inspiring Kevin Reggaeton Instrum Prod Dan-craneblue', '28828.mp4', '28828.jpg', '2018-09-01', '10:10:52'),
(131, 17, '2b44928ae11fb9384c4cf38708677c48', 1, 'Ewa Sonnet I R&B - Music Video (Polish Song).mp4 - cranebue', '10151.mp4', '10153.jpg', '2018-09-01', '10:15:07'),
(132, 21, 'c45147dee729311ef5b5c3003946c48f', 1, 'Enrique Iglesias - SUBEME LA RADIO ft. Descemer Bue craneblue', '16580.mp4', '16580.jpg', '2018-09-08', '10:59:23'),
(133, 21, 'eb160de1de89d9058fcb0b968dbbbd68', 1, 'Kyerenga H.E Bobi Wine 2018 -craneblue.mp4', '9520.mp4', '9524.jpg', '2018-09-08', '15:09:41'),
(134, 21, '5ef059938ba799aaa845e1c2e8a762bd', 1, 'mark angle', '14126.mp4', '14127.jpg', '2018-09-08', '15:22:13'),
(137, 21, '4c56ff4ce4aaf9573aa5dff913df997a', 1, 'phonex club', '626.AVI', '630.jpg', '2018-09-09', '12:10:24'),
(138, 21, 'a0a080f42e6f13b3a2df133f073095dd', 1, 'Bambi By Jidenna-craneblue', '998.mp4', '1000.jpg', '2018-09-09', '12:18:52'),
(139, 21, '202cb962ac59075b964b07152d234b70', 1, 'school tym', '14212.mp4', '14214.jpg', '2018-09-13', '16:56:56'),
(140, 21, 'c8ffe9a587b126f152ed3d89a146b445', 1, 'Real life ', '954.mp4', '957.jpg', '2018-09-13', '17:03:10');

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

--
-- Table structure for table `crane_commenttb`
--

CREATE TABLE `crane_commenttb` (
  `id` int(11) NOT NULL,
  `video_id` int(11) NOT NULL,
  `comment` varchar(255) NOT NULL,
  `comm_by_id` int(11) NOT NULL,
  `channel_id` varchar(255) NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `crane_commenttb`
--

INSERT INTO `crane_commenttb` (`id`, `video_id`, `comment`, `comm_by_id`, `channel_id`, `date`, `time`) VALUES
(11, 84, 'good talent', 1, '12', '2018-08-31', '12:31:43'),
(12, 121, 'This is a hit song', 1, '21', '2018-08-31', '12:41:57'),
(13, 86, 'point taken', 1, '15', '2018-08-31', '13:01:44'),
(14, 124, 'Nice dude', 1, '15', '2018-08-31', '13:04:25'),
(15, 82, 'Nice hit big up', 1, '12', '2018-08-31', '13:06:53'),
(16, 130, 'nice tone', 1, '17', '2018-09-03', '10:53:44'),
(17, 118, 'Good  work  gal', 2, '21', '2018-09-03', '10:54:51'),
(18, 118, 'Keep it up ', 2, '21', '2018-09-03', '10:55:23'),
(19, 118, 'The way you  smile  eeeee nice  composition nyabo Big up', 2, '21', '2018-09-03', '10:57:00'),
(20, 118, 'Ono sulako Di eno', 2, '21', '2018-09-03', '10:57:28'),
(21, 118, 'this the song wuu', 1, '21', '2018-09-03', '11:07:47'),
(22, 118, 'welldone nyaboo', 1, '21', '2018-09-03', '11:08:20'),
(23, 118, 'the tht jj tuy uyin tuy utiy it  rit rt iti iurt r9t bery ery ery yeu ua lfgl svdu ydfu ue', 1, '21', '2018-09-03', '11:13:35'),
(24, 125, 'Big up', 1, '14', '2018-09-05', '12:16:46'),
(25, 115, 'Mukama abisobola', 1, '21', '2018-09-12', '16:32:43'),
(26, 140, 'Rip King Music', 1, '21', '2018-09-13', '17:04:14'),
(27, 85, 'Come on', 2, '13', '2018-09-18', '09:43:57');

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

--
-- Table structure for table `crane_profiletb`
--

CREATE TABLE `crane_profiletb` (
  `id` int(11) NOT NULL,
  `profile_own_id` int(11) NOT NULL,
  `image_url` text NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `crane_profiletb`
--

INSERT INTO `crane_profiletb` (`id`, `profile_own_id`, `image_url`, `date`, `time`) VALUES
(3, 1, '22490.jpg', '2017-08-03', '09:38:13'),
(5, 2, '17128.jpg', '2017-08-03', '09:40:24'),
(6, 3, '7270.jpg', '2017-09-03', '08:08:36');

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

--
-- Table structure for table `liketb`
--

CREATE TABLE `liketb` (
  `id` int(11) NOT NULL,
  `video_id` int(11) NOT NULL,
  `liked_by` int(11) NOT NULL,
  `channel_id` varchar(255) NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `liketb`
--

INSERT INTO `liketb` (`id`, `video_id`, `liked_by`, `channel_id`, `date`, `time`) VALUES
(27, 82, 1, '', '2017-03-31', '14:28:38'),
(28, 91, 1, '', '2017-03-31', '15:12:11'),
(29, 85, 1, '', '2017-04-07', '12:39:17'),
(30, 83, 1, '', '2017-04-07', '13:17:42'),
(31, 88, 1, '', '2017-04-15', '15:00:59'),
(32, 91, 2, '', '2017-09-03', '08:03:02'),
(33, 93, 3, '', '2017-09-03', '08:11:22'),
(34, 86, 1, '15', '2018-08-31', '14:18:41'),
(35, 113, 1, '21', '2018-08-31', '14:20:52'),
(36, 96, 1, '21', '2018-08-31', '14:22:30'),
(37, 118, 1, '21', '2018-08-31', '14:42:18'),
(38, 115, 1, '21', '2018-08-31', '14:45:39'),
(39, 104, 1, '21', '2018-08-31', '14:51:34'),
(42, 101, 1, '21', '2018-08-31', '15:29:21'),
(44, 112, 1, '21', '2018-08-31', '15:34:44'),
(45, 128, 1, '15', '2018-09-01', '09:47:42'),
(46, 116, 1, '21', '2018-09-01', '20:02:02'),
(48, 128, 2, '15', '2018-09-03', '10:12:49'),
(54, 132, 2, '21', '2018-09-16', '15:09:32'),
(56, 134, 2, '21', '2018-09-16', '15:23:40'),
(57, 82, 2, '12', '2018-09-16', '15:28:19'),
(58, 103, 2, '21', '2018-09-16', '15:31:37'),
(60, 138, 2, '21', '2018-09-16', '15:38:53');

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

--
-- Table structure for table `security_video`
--

CREATE TABLE `security_video` (
  `id` int(11) NOT NULL,
  `security_id` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `security_video`
--

INSERT INTO `security_video` (`id`, `security_id`) VALUES
(124, '21');

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

--
-- Table structure for table `sub_friends`
--

CREATE TABLE `sub_friends` (
  `id` int(11) NOT NULL,
  `my_id` int(11) NOT NULL,
  `userz_id` int(11) NOT NULL,
  `channel_id` int(11) NOT NULL,
  `video_id` int(11) NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sub_friends`
--

INSERT INTO `sub_friends` (`id`, `my_id`, `userz_id`, `channel_id`, `video_id`, `date`, `time`) VALUES
(137, 1, 2, 12, 82, '2017-04-16', '14:32:12'),
(138, 2, 2, 12, 82, '2017-04-16', '14:48:31'),
(140, 3, 2, 12, 82, '2017-04-16', '15:04:36'),
(141, 3, 1, 15, 86, '2017-04-16', '15:46:06'),
(150, 2, 1, 15, 89, '2017-04-16', '16:30:01'),
(151, 1, 2, 13, 83, '2017-04-17', '14:55:24'),
(152, 2, 1, 17, 91, '2017-07-23', '09:24:53');

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

--
-- Table structure for table `tmp_thumbnailtb`
--

CREATE TABLE `tmp_thumbnailtb` (
  `id` int(11) NOT NULL,
  `channel_id` varchar(255) NOT NULL,
  `user_id` varchar(255) NOT NULL,
  `thumb_image` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `unliketb`
--

CREATE TABLE `unliketb` (
  `id` int(11) NOT NULL,
  `video_id` int(11) NOT NULL,
  `unlike_by` int(11) NOT NULL,
  `channel_id` varchar(255) NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `unliketb`
--

INSERT INTO `unliketb` (`id`, `video_id`, `unlike_by`, `channel_id`, `date`, `time`) VALUES
(45, 85, 2, '', '0000-00-00', '00:00:00'),
(46, 83, 2, '', '0000-00-00', '00:00:00'),
(47, 84, 2, '', '0000-00-00', '00:00:00'),
(48, 86, 2, '', '0000-00-00', '00:00:00'),
(49, 92, 2, '', '2017-09-03', '08:03:51'),
(50, 86, 1, '15', '2018-08-31', '14:19:42'),
(51, 113, 1, '21', '2018-08-31', '14:20:58'),
(52, 96, 1, '21', '2018-08-31', '14:22:34'),
(54, 118, 1, '21', '2018-08-31', '14:42:23'),
(56, 130, 1, '17', '2018-09-03', '15:58:47'),
(57, 123, 2, '21', '2018-09-09', '11:42:38'),
(63, 133, 2, '21', '2018-09-16', '14:28:58');

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

--
-- Table structure for table `user_accounttb`
--

CREATE TABLE `user_accounttb` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_accounttb`
--

INSERT INTO `user_accounttb` (`id`, `name`, `email`, `password`, `date`, `time`) VALUES
(1, 'dora', 'dora@kvt.com', '1234', '0000-00-00', '00:00:00'),
(2, 'tom', 'tom@kvt.com', '1234', '0000-00-00', '00:00:00'),
(3, 'roy', 'roy@kvt.com', '1234', '0000-00-00', '00:00:00');

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

--
-- Table structure for table `viewerstb`
--

CREATE TABLE `viewerstb` (
  `id` int(11) NOT NULL,
  `video_id` int(11) NOT NULL,
  `owner_video_id` int(11) NOT NULL,
  `channel_id` int(11) NOT NULL,
  `viewer_ip` varchar(255) NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `viewerstb`
--

INSERT INTO `viewerstb` (`id`, `video_id`, `owner_video_id`, `channel_id`, `viewer_ip`, `date`, `time`) VALUES
(131, 88, 1, 14, '::1', '0000-00-00', '00:00:00'),
(132, 87, 1, 14, '::1', '0000-00-00', '00:00:00'),
(133, 86, 1, 15, '::1', '0000-00-00', '00:00:00'),
(134, 85, 2, 13, '::1', '0000-00-00', '00:00:00'),
(135, 83, 2, 13, '::1', '0000-00-00', '00:00:00'),
(136, 84, 2, 12, '::1', '0000-00-00', '00:00:00'),
(137, 82, 2, 12, '::1', '0000-00-00', '00:00:00'),
(138, 90, 1, 14, '::1', '0000-00-00', '00:00:00'),
(139, 91, 1, 17, '::1', '0000-00-00', '00:00:00'),
(140, 82, 2, 12, '192.168.1.64', '0000-00-00', '00:00:00'),
(141, 85, 2, 13, '192.168.1.64', '0000-00-00', '00:00:00'),
(142, 87, 1, 14, '192.168.1.64', '0000-00-00', '00:00:00'),
(143, 89, 1, 15, '192.168.1.64', '0000-00-00', '00:00:00'),
(144, 89, 1, 15, '::1', '0000-00-00', '00:00:00'),
(145, 85, 2, 13, '192.168.1.74', '0000-00-00', '00:00:00'),
(146, 86, 1, 15, '192.168.1.64', '0000-00-00', '00:00:00'),
(147, 83, 2, 13, '192.168.1.64', '0000-00-00', '00:00:00'),
(148, 85, 2, 13, '192.168.1.109', '0000-00-00', '00:00:00'),
(149, 82, 2, 12, '192.168.1.68', '0000-00-00', '00:00:00'),
(150, 84, 2, 12, '192.168.1.68', '0000-00-00', '00:00:00'),
(151, 88, 1, 14, '192.168.1.68', '0000-00-00', '00:00:00'),
(152, 83, 2, 13, '192.168.1.68', '0000-00-00', '00:00:00'),
(153, 87, 1, 14, '192.168.1.68', '0000-00-00', '00:00:00'),
(154, 85, 2, 13, '192.168.1.68', '0000-00-00', '00:00:00'),
(155, 86, 1, 15, '192.168.1.68', '0000-00-00', '00:00:00'),
(156, 87, 1, 14, '192.168.1.65', '2017-04-15', '14:59:31'),
(157, 88, 1, 14, '192.168.1.65', '2017-04-15', '15:00:36'),
(158, 85, 2, 13, '192.168.1.31', '2017-07-22', '20:55:03'),
(159, 87, 1, 14, '192.168.1.31', '2017-07-22', '20:57:28'),
(160, 92, 2, 19, '::1', '2017-08-03', '15:52:02'),
(161, 93, 3, 22, '::1', '2017-09-03', '08:11:12'),
(162, 113, 1, 21, '::1', '2018-08-29', '14:34:17'),
(163, 124, 1, 15, '::1', '2018-08-29', '16:28:01'),
(164, 125, 1, 14, '::1', '2018-08-29', '17:01:12'),
(165, 115, 1, 21, '::1', '2018-08-30', '11:40:00'),
(166, 97, 1, 21, '::1', '2018-08-31', '08:59:58'),
(167, 126, 1, 21, '::1', '2018-08-31', '09:13:23'),
(168, 104, 1, 21, '::1', '2018-08-31', '14:48:17'),
(169, 112, 1, 21, '::1', '2018-08-31', '15:32:22'),
(170, 128, 1, 15, '::1', '2018-09-01', '09:47:26'),
(171, 127, 1, 15, '::1', '2018-09-01', '09:51:41'),
(172, 107, 1, 21, '192.168.100.4', '2018-09-01', '19:42:38'),
(173, 116, 1, 21, '::1', '2018-09-01', '19:57:42'),
(174, 127, 1, 15, '192.168.100.22', '2018-09-02', '11:14:49'),
(175, 113, 1, 21, '192.168.100.3', '2018-09-02', '12:01:32'),
(176, 120, 1, 21, '192.168.100.22', '2018-09-02', '12:01:43'),
(177, 130, 1, 17, '192.168.100.3', '2018-09-02', '17:51:32'),
(178, 91, 1, 17, '192.168.100.3', '2018-09-03', '09:17:48'),
(179, 113, 1, 21, '192.168.100.22', '2018-09-03', '09:20:52'),
(180, 124, 1, 15, '192.168.100.3', '2018-09-03', '09:36:04'),
(181, 82, 2, 12, '192.168.100.22', '2018-09-03', '09:52:53'),
(182, 86, 1, 15, '192.168.100.22', '2018-09-03', '10:07:49'),
(183, 112, 1, 21, '192.168.100.3', '2018-09-03', '10:12:10'),
(184, 118, 1, 21, '192.168.100.22', '2018-09-03', '10:15:19'),
(185, 118, 1, 21, '::1', '2018-09-03', '11:09:27'),
(186, 118, 1, 21, '192.168.100.3', '2018-09-03', '11:15:59'),
(187, 127, 1, 15, '192.168.100.3', '2018-09-03', '11:46:24'),
(188, 90, 1, 14, '192.168.100.22', '2018-09-03', '12:16:19'),
(189, 126, 1, 21, '192.168.100.22', '2018-09-04', '13:41:33'),
(190, 88, 1, 14, '192.168.100.3', '2018-09-04', '13:44:10'),
(191, 120, 1, 21, '192.168.100.3', '2018-09-06', '09:29:44'),
(192, 93, 3, 22, '192.168.100.22', '2018-09-06', '09:34:17'),
(193, 92, 2, 19, '192.168.100.22', '2018-09-06', '10:27:22'),
(194, 128, 1, 15, '192.168.100.3', '2018-09-06', '10:39:32'),
(195, 122, 1, 17, '192.168.100.22', '2018-09-06', '11:57:31'),
(196, 128, 1, 15, '192.168.100.22', '2018-09-06', '12:05:05'),
(197, 97, 1, 21, '192.168.100.3', '2018-09-06', '13:44:55'),
(198, 125, 1, 14, '192.168.100.22', '2018-09-06', '14:52:49'),
(199, 121, 1, 21, '192.168.100.22', '2018-09-06', '15:18:49'),
(200, 132, 1, 21, '::1', '2018-09-08', '11:02:21'),
(201, 134, 1, 21, '192.168.100.3', '2018-09-08', '15:23:13'),
(202, 132, 1, 21, '192.168.100.22', '2018-09-09', '09:10:43'),
(203, 134, 1, 21, '192.168.100.22', '2018-09-09', '10:30:50'),
(204, 119, 1, 21, '192.168.100.22', '2018-09-09', '10:35:43'),
(205, 117, 1, 21, '192.168.100.3', '2018-09-09', '10:40:04'),
(206, 138, 1, 21, '::1', '2018-09-09', '12:22:12'),
(207, 138, 1, 21, '192.168.100.22', '2018-09-10', '09:55:53'),
(208, 134, 1, 21, '::1', '2018-09-10', '15:39:18'),
(209, 139, 1, 21, '192.168.100.22', '2018-09-13', '16:58:12'),
(210, 140, 1, 21, '192.168.100.22', '2018-09-13', '17:06:17'),
(211, 139, 1, 21, '::1', '2018-09-14', '12:05:44'),
(212, 133, 1, 21, '192.168.100.22', '2018-09-14', '12:11:41'),
(213, 117, 1, 21, '::1', '2018-09-14', '12:17:44'),
(214, 129, 1, 15, '::1', '2018-09-14', '12:55:31'),
(215, 83, 2, 13, '192.168.100.3', '2018-09-14', '15:56:40'),
(216, 101, 1, 21, '192.168.100.22', '2018-09-14', '17:28:02'),
(217, 103, 1, 21, '192.168.100.22', '2018-09-16', '15:34:13'),
(218, 110, 1, 21, '192.168.100.22', '2018-09-16', '15:37:21'),
(219, 100, 1, 21, '192.168.100.22', '2018-09-17', '11:15:22'),
(220, 133, 1, 21, '::1', '2018-09-17', '14:08:40'),
(221, 85, 2, 13, '192.168.100.22', '2018-09-18', '10:18:57'),
(222, 85, 2, 13, '192.168.100.3', '2018-09-28', '12:20:20'),
(223, 140, 1, 21, '192.168.100.3', '2018-09-29', '11:07:33'),
(224, 138, 1, 21, '192.168.100.3', '2018-09-29', '11:30:55'),
(225, 133, 1, 21, '192.168.100.3', '2018-09-29', '16:26:14'),
(226, 121, 1, 21, '192.168.100.3', '2018-09-29', '16:29:44'),
(227, 106, 1, 21, '192.168.100.3', '2018-09-30', '09:09:43'),
(228, 100, 1, 21, '192.168.100.3', '2018-09-30', '11:19:35');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `account_bannertb`
--
ALTER TABLE `account_bannertb`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;
--
-- AUTO_INCREMENT for table `channeltb`
--
ALTER TABLE `channeltb`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;
--
-- AUTO_INCREMENT for table `channel_bannertb`
--
ALTER TABLE `channel_bannertb`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;
--
-- AUTO_INCREMENT for table `channel_profiletb`
--
ALTER TABLE `channel_profiletb`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=69;
--
-- AUTO_INCREMENT for table `craneblue_videostb`
--
ALTER TABLE `craneblue_videostb`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=141;
--
-- AUTO_INCREMENT for table `crane_commenttb`
--
ALTER TABLE `crane_commenttb`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;
--
-- AUTO_INCREMENT for table `crane_profiletb`
--
ALTER TABLE `crane_profiletb`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `liketb`
--
ALTER TABLE `liketb`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=61;
--
-- AUTO_INCREMENT for table `security_video`
--
ALTER TABLE `security_video`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=125;
--
-- AUTO_INCREMENT for table `sub_friends`
--
ALTER TABLE `sub_friends`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=153;
--
-- AUTO_INCREMENT for table `tmp_thumbnailtb`
--
ALTER TABLE `tmp_thumbnailtb`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `unliketb`
--
ALTER TABLE `unliketb`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=64;
--
-- AUTO_INCREMENT for table `user_accounttb`
--
ALTER TABLE `user_accounttb`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `viewerstb`
--
ALTER TABLE `viewerstb`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=229;
