| Server IP : 127.0.0.1 / Your IP : 216.73.216.48 Web Server : Apache/2.4.58 (Win64) OpenSSL/3.1.3 PHP/8.2.12 System : Windows NT DESKTOP-3H4FHQJ 10.0 build 19045 (Windows 10) AMD64 User : win 10 ( 0) PHP Version : 8.2.12 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : D:/xamppkk/htdocs-coblaa/developer/banner_img/ |
Upload File : |
-- phpMyAdmin SQL Dump -- version 4.6.5.2 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: May 23, 2019 at 03:44 PM -- Server version: 10.1.21-MariaDB -- PHP Version: 7.0.15 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: `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; /*!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 */;