 (16, 'lenaheadey', 'secret123', 'lenaheadey@gmail.com', 'employee'),
 (17, 'isaachempstead', 'secret123', 'isaachempstead@gmail.com', 'manager'),
 (18, 'client1', 'secret123', 'client1.e62014@gmail.com', 'client'),
-(19, 'client2', 'secret123', 'client2.e62014@gmail.com', 'client'),
-(20, 'admin', 'admin', 'admin@sourcefit.com', 'admin'),
-(21, 'employee', 'employee', 'employee@sourcefit.com', 'employee');
+(19, 'client2', 'secret123', 'client2.e62014@gmail.com', 'client');
 
 -- --------------------------------------------------------
 
 --
--- Table structure for table `user_profile`
+-- Table structure for table `video`
 --
 
-CREATE TABLE IF NOT EXISTS `user_profile` (
+CREATE TABLE IF NOT EXISTS `video` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
-  `users_id` int(11) NOT NULL,
-  `firstname` varchar(75) NOT NULL,
-  `lastname` varchar(75) NOT NULL,
-  `middle` varchar(75) NOT NULL,
-  `birthdate` date NOT NULL,
-  `gender_id` int(3) NOT NULL,
-  `address` varchar(150) NOT NULL,
-  `landline` varchar(50) NOT NULL,
-  `cellphone` varchar(50) NOT NULL,
-  `about` text NOT NULL,
-  `created` date NOT NULL,
-  `last_modified` datetime NOT NULL,
-  `profile_pic_url` text NOT NULL,
+  `title` varchar(175) DEFAULT NULL,
+  `desc` text,
+  `category_id` varchar(3) DEFAULT NULL,
+  `runtime` varchar(50) DEFAULT NULL,
+  `embed_code` text,
+  `video_src` varchar(500) DEFAULT NULL,
+  `video_path` text,
+  `thumbnail` varchar(255) DEFAULT NULL,
+  `uploaded` datetime DEFAULT NULL,
+  `modified` datetime DEFAULT NULL,
+  `views` int(11) DEFAULT '0',
+  `likes` int(11) DEFAULT '0',
+  `dislikes` int(11) DEFAULT '0',
+  `publish` tinyint(1) DEFAULT '0',
   PRIMARY KEY (`id`)
-) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;
+) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
 
 --
--- Dumping data for table `user_profile`
+-- Dumping data for table `video`
 --
 
-INSERT INTO `user_profile` (`id`, `users_id`, `firstname`, `lastname`, `middle`, `birthdate`, `gender_id`, `address`, `landline`, `cellphone`, `about`, `created`, `last_modified`, `profile_pic_url`) VALUES
-(10, 11, 'Marvin', 'Manguiat', 'U', '1981-07-07', 1, '#64 dela rosa st. makati city', '123456', '901223221', 'Programming since 2006, i can handle medium to large complex system.', '0000-00-00', '2014-10-03 12:30:48', '/img/avatar/user11.png'),
-(11, 12, 'Jayson', 'Salillas', 'x', '1981-07-08', 1, 'Bulacan Philippines', '36985212', '09178858475', 'I''m Jason Salillias, From Bulacan MM.', '0000-00-00', '2014-10-27 19:30:34', '/img/avatar/user12.png'),
-(12, 13, 'Edgar', 'Delacruz', 'Pugi', '1900-04-27', 1, 'sfdsfdf', '435454545', '23434343434', 'ed', '0000-00-00', '2014-10-03 12:36:18', '/img/avatar/user13.png'),
-(13, 14, 'Peter ', 'Dinklage', 'M', '1969-10-15', 1, 'Morristown, New Jersey', '4512125', '09198852124', ' Emmy Award and Golden Globe winner', '2014-10-28', '2014-10-28 00:00:00', '/img/avatar/user14.png'),
-(14, 15, 'Nikolaj', 'Waldau', 'Coster', '1970-07-27', 1, 'Rudkøbing, Denmark', '5623251', '09184547', 'Danish actor, producer, and screenwriter. He attended Statens Teaterskole in Copenhagen in 1993. In the United States, he played Detective John Amsterdam on the short-lived Fox television series New Amsterdam, as well as appearing as Frank Pike in the 2009 Fox television film Virtuality, originally intended as a pilot. Since April 2011, he became known to a broad audience by playing the role of Jaime Lannister in the HBO series Game of Thrones', '0000-00-00', '2014-10-28 15:13:19', '/img/avatar/user15.png'),
-(15, 16, 'Lena', 'Headey', 'M', '1973-10-03', 2, 'Hamilton, Bermuda', '5625214', '0919852514', 'British actress, she was born in Bermuda, to parents from Yorkshire, England, where she was also raised. She is the daughter of Sue and John Headey, a police officer. Headey is best known for her appearances in The Brothers Grimm (2005), Possession (2002), and The Remains of the Day (1993). Headey stars as Queen Gorgo, a heroic Spartan woman in the period film 300 (2006), by director Zack Snyder.', '0000-00-00', '2014-10-28 15:18:20', '/img/avatar/user16.png'),
-(16, 17, 'Isaac', 'Wright', 'Hempstead', '1999-04-09', 1, 'England, UK', '5623528', '09184517', 'Isaac Hempstead-Wright is an English actor. He began his professional acting career at the age of eleven, Hempstead-Wright is best known for his role as Bran Stark on the HBO series Game of Thrones, which earned him a Young Artist Award nomination as Best Young Supporting Actor in a TV Series', '0000-00-00', '2014-10-28 15:25:58', '/img/avatar/user17.png'),
-(17, 18, 'Brad', 'Hunter', 'c', '0000-00-00', 0, '', '', '', '', '0000-00-00', '0000-00-00 00:00:00', ''),
-(18, 19, 'Karen', 'Capaciti', '', '0000-00-00', 0, '', '', '', '', '0000-00-00', '0000-00-00 00:00:00', ''),
-(19, 20, 'admin', 'admin', 'a', '1983-12-06', 1, 'w', '45454545', '45454545', 'w', '0000-00-00', '2014-11-10 22:28:42', '/img/avatar/user20.png'),
-(20, 21, 'employee', 'employee', 'e', '2000-11-30', 2, 'employee', '3453435434', '34343434', 'employee', '0000-00-00', '2014-11-10 22:31:54', '/img/avatar/user21.png');
+INSERT INTO `video` (`id`, `title`, `desc`, `category_id`, `runtime`, `embed_code`, `video_src`, `video_path`, `thumbnail`, `uploaded`, `modified`, `views`, `likes`, `dislikes`, `publish`) VALUES
+(1, 'Paul Gilbert', 'Paul Gilbert & Freddie Nelson - Let It Be (LIVE)', '3', '20:10', NULL, 'http://173.45.66.115/serv/serv.php?id=1', '/videos/2014/10/video_1.mp4', '/img/thumbnails/vids/2014/10/sample320x200.png', '2014-10-28 10:24:11', '2014-09-23 00:00:00', 1060, 12, 10, 1),
+(2, 'Paul red guitar', 'Paul playing red ibanez', '4', '30:41', NULL, 'http://173.45.66.115/serv/serv.php?id=2', '/videos/2014/10/video_2.mp4', '/img/thumbnails/vids/2014/10/sample320x200.png', '2014-02-02 04:10:11', '2014-10-20 00:00:00', 100, 15, 6, 1),
+(3, 'Paul Gilbert', 'Far Beyond The Sun played by Yngwie Malmsteen', '4', '6:00', NULL, '/videos/2014/10/video_1.mp4', '', '/img/thumbnails/vids/2014/10/sample320x200-1.png', '2014-09-28 04:10:11', '0000-00-00 00:00:00', 108, 0, 0, 1),
+(4, 'YNGWIE MALMSTEEN Live [HD] Black Star', 'YNGWIE MALMSTEEN Live [HD] Black Star', '3', '10:46', NULL, '/videos/2014/10/video_1.mp4', '', '/img/thumbnails/vids/2014/10/sample320x200-1.png', '2014-10-20 00:00:00', '2014-10-20 00:00:00', 77, 6, 3, 1),
+(5, 'Steve Vai Tender Surrender full HD', '2009 Where the Wild Things Are DVD', '3', '4:39', NULL, '/videos/2014/10/video_4.mp4', '', '/img/thumbnails/vids/2014/10/sample320x200-3.png', '2014-10-22 00:00:00', '2014-10-20 00:00:00', 15, 0, 0, 1),
+(6, 'Joe Satriani - Always With Me, Always With You (Live 2006)', 'Joe Satriani - Always With Me, Always', '3', '12:50', NULL, 'http://173.45.66.115/serv/serv.php?id=1', '/videos/2014/10/video_1.mp4', '/img/thumbnails/vids/2014/10/sample320x200-2.png', '2014-10-24 04:14:17', '2014-10-20 00:00:00', 133, 1, 0, 1);
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `video_category`
+--
+
+CREATE TABLE IF NOT EXISTS `video_category` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `video_id` int(11) NOT NULL,
+  `category_id` int(11) NOT NULL,
+  `date` datetime NOT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
+
+--
+-- Dumping data for table `video_category`
+--
+
+INSERT INTO `video_category` (`id`, `video_id`, `category_id`, `date`) VALUES
+(1, 1, 1, '2014-10-21 00:00:00'),
+(2, 1, 2, '2014-10-21 00:00:00'),
+(3, 1, 4, '2014-10-08 00:00:00');
 
 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Nov 11, 2014 at 11:17 PM
-- Server version: 5.5.38-0ubuntu0.14.04.1-log
-- PHP Version: 5.5.9-1ubuntu4.4


  `role` varchar(150) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;

--
-- Dumping data for table `users`
