 /*!40101 SET NAMES utf8 */;
 
 --
--- Database: `zend_tut1`
+-- Database: `edplayground`
 --
 
 -- --------------------------------------------------------
 
 --
--- Table structure for table `acl_roles`
+-- Table structure for table `category`
 --
 
-CREATE TABLE IF NOT EXISTS `acl_roles` (
+CREATE TABLE IF NOT EXISTS `category` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
-  `role` varchar(125) NOT NULL,
-  `resource` varchar(200) NOT NULL,
+  `category_name` varchar(175) NOT NULL,
   PRIMARY KEY (`id`)
-) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=75 ;
+) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
 
 --
--- Dumping data for table `acl_roles`
+-- Dumping data for table `category`
 --
 
-INSERT INTO `acl_roles` (`id`, `role`, `resource`) VALUES
-(10, 'guest', 'home'),
-(11, 'guest', 'profile'),
-(12, 'guest', 'auth'),
-(13, 'guest', 'index'),
-(14, 'employee', 'home'),
-(15, 'employee', 'profile'),
-(16, 'employee', 'view'),
-(17, 'employee', 'view-profile'),
-(18, 'employee', 'edit-profile'),
-(19, 'employee', 'edit'),
-(20, 'employee', 'settings'),
-(21, 'employee', 'settings'),
-(22, 'employee', 'upload-profile-picture'),
-(23, 'employee', 'change-password'),
-(24, 'employee', 'logout'),
-(25, 'employee', 'login'),
-(26, 'employee', 'auth'),
-(27, 'employee', 'index'),
-(28, 'admin', 'home'),
-(29, 'admin', 'profile'),
-(30, 'admin', 'view'),
-(31, 'admin', 'change-password'),
-(32, 'admin', 'employee'),
-(33, 'admin', 'pre-employment'),
-(34, 'admin', 'view-employee'),
-(35, 'admin', 'employee-memo'),
-(36, 'admin', 'employee-file'),
-(37, 'admin', 'download-employee-file'),
-(38, 'admin', 'delete-employee-file'),
-(39, 'admin', 'add-employee-file'),
-(40, 'admin', 'employee-memo'),
-(41, 'admin', 'add-employee-memo'),
-(42, 'admin', 'delete-employee-memo'),
-(43, 'admin', 'delete-employee-memo'),
-(44, 'admin', 'employee-quizzes'),
-(45, 'admin', 'edit-employee-quiz'),
-(46, 'admin', 'delete-employee-quiz'),
-(47, 'admin', 'employee-attendance'),
-(48, 'admin', 'view'),
-(49, 'admin', 'settings'),
-(50, 'admin', 'employee-evaluation'),
-(51, 'admin', 'edit-employee-evaluation'),
-(52, 'admin', 'view-candidate-profile'),
-(53, 'admin', 'employee-salary'),
-(54, 'admin', 'employee-clubs'),
-(55, 'admin', 'employee-points'),
-(56, 'admin', 'employee-feedback'),
-(57, 'admin', 'logout'),
-(58, 'admin', 'login'),
-(59, 'admin', 'authenticate'),
-(60, 'admin', 'index'),
-(61, 'admin', 'viewProfile'),
-(63, 'guest', 'profileLogout'),
-(64, 'admin', 'profileLogout'),
-(65, 'admin', 'hr'),
-(66, 'guest', 'hr'),
-(67, 'admin', 'accounting'),
-(68, 'guest', 'login'),
-(69, 'guest', 'authenticate'),
-(70, 'employee', 'viewProfile'),
-(71, 'employee', 'logout'),
-(72, 'employee', 'profileLogout'),
-(73, 'admin', 'edit'),
-(74, 'admin', 'upload-profile-picture');
+INSERT INTO `category` (`id`, `category_name`) VALUES
+(1, 'Rock'),
+(2, 'Progressive Rock'),
+(3, 'pop'),
+(4, 'musical');
 
 -- --------------------------------------------------------
 
 --
--- Table structure for table `album`
+-- Table structure for table `images`
 --
 
-CREATE TABLE IF NOT EXISTS `album` (
+CREATE TABLE IF NOT EXISTS `images` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
-  `artist` varchar(100) NOT NULL,
-  `title` varchar(100) NOT NULL,
-  `category_id` int(11) NOT NULL,
-  PRIMARY KEY (`id`),
-  UNIQUE KEY `artist` (`artist`)
-) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=27 ;
-
---
--- Dumping data for table `album`
---
-
-INSERT INTO `album` (`id`, `artist`, `title`, `category_id`) VALUES
-(4, 'jr', 'the chipmonks', 2),
-(9, 'nirvana', 'nevermind', 2),
-(20, 'mark lagman', 'patayin sa sindak ni barbara', 0),
-(21, 'ko', 'marlo', 0),
-(22, 'YYY', 'posi', 1),
-(23, '34WWWW', 'LALUNA', 2),
-(24, 'new at', 'new', 1),
-(25, 'Yano', 'SM', 2),
-(26, 'REM', 'Fire', 2);
-
--- --------------------------------------------------------
-
---
--- Table structure for table `categories`
---
-
-CREATE TABLE IF NOT EXISTS `categories` (
-  `id` int(11) NOT NULL AUTO_INCREMENT,
-  `category` varchar(25) NOT NULL,
-  PRIMARY KEY (`id`),
-  UNIQUE KEY `category` (`category`)
-) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
-
---
--- Dumping data for table `categories`
---
-
-INSERT INTO `categories` (`id`, `category`) VALUES
-(1, 'Rock'),
-(2, 'Sentimental');
-
--- --------------------------------------------------------
-
---
--- Table structure for table `employees`
---
-
-CREATE TABLE IF NOT EXISTS `employees` (
-  `id` int(11) NOT NULL AUTO_INCREMENT,
-  `users_id` int(11) NOT NULL,
-  `date_hired` date NOT NULL,
-  `status` int(1) NOT NULL,
-  PRIMARY KEY (`id`)
-) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
-
---
--- Dumping data for table `employees`
---
-
-INSERT INTO `employees` (`id`, `users_id`, `date_hired`, `status`) VALUES
-(1, 11, '2014-10-03', 1),
-(2, 13, '2014-10-23', 1),
-(3, 12, '2014-10-28', 1),
-(4, 14, '2014-10-28', 1),
-(5, 15, '2014-10-28', 1),
-(6, 16, '2014-10-28', 1),
-(7, 17, '2014-10-28', 1),
-(8, 20, '2014-11-11', 1),
-(9, 21, '2014-11-11', 1);
-
--- --------------------------------------------------------
-
---
--- Table structure for table `employee_evaluation`
---
-
-CREATE TABLE IF NOT EXISTS `employee_evaluation` (
-  `id` int(11) NOT NULL AUTO_INCREMENT,
-  `title` varchar(250) NOT NULL,
-  `notes` text,
-  `score` float DEFAULT '0',
-  `status` enum('pending','rejected','approved') NOT NULL DEFAULT 'pending',
-  `employee_id` int(11) NOT NULL COMMENT 'id of employee ',
-  `evaluated_by` int(11) NOT NULL COMMENT 'logged in user_id can be anyone with userid ',
-  `created` datetime NOT NULL,
-  `evaluation_due` date NOT NULL,
-  `modified` datetime NOT NULL,
-  PRIMARY KEY (`id`)
-) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;
-
---
--- Dumping data for table `employee_evaluation`
---
-
-INSERT INTO `employee_evaluation` (`id`, `title`, `notes`, `score`, `status`, `employee_id`, `evaluated_by`, `created`, `evaluation_due`, `modified`) VALUES
-(1, 'Evaluation1', '', 89.78, 'pending', 1, 1, '2014-10-23 02:53:00', '2014-10-09', '2014-10-23 02:59:00'),
-(2, 'Evaluation2XX', NULL, NULL, 'approved', 1, 0, '2014-10-02 00:00:00', '0000-00-00', '2014-10-24 16:14:07'),
-(3, 'Evaluation1', NULL, NULL, 'pending', 2, 0, '0000-00-00 00:00:00', '0000-00-00', '2014-10-27 15:01:27'),
-(4, 'asdsXXX', 'sd', NULL, 'pending', 2, 0, '0000-00-00 00:00:00', '0000-00-00', '2014-10-27 15:01:22'),
-(5, 'evaluation3', 'ed eval3', NULL, 'pending', 2, 0, '0000-00-00 00:00:00', '2014-10-11', '2014-10-24 18:11:09'),
-(6, 'Evaluation3', 'Marvin''s evaluation updated to Feb 2 2015', NULL, 'pending', 1, 0, '0000-00-00 00:00:00', '0000-00-00', '2014-10-27 14:55:03'),
-(7, 'ed final evaluation', 'this is edgar final evaluation', NULL, 'pending', 2, 0, '0000-00-00 00:00:00', '0000-00-00', '2014-10-27 15:01:18'),
-(8, 'final and last evaluation', 'this will be the final and last evaluation to becoming a CEO of the compay', NULL, 'pending', 1, 0, '0000-00-00 00:00:00', '0000-00-00', '2014-10-27 14:55:59'),
-(9, 'java OOp', 'wewe', NULL, 'pending', 3, 11, '2014-10-28 14:59:42', '0000-00-00', '2014-10-28 14:59:42'),
-(10, 'First evaluation', 'this is Niks first evaluation after job offer\r\n', NULL, 'pending', 5, 11, '2014-11-04 11:13:38', '0000-00-00', '2014-11-04 11:13:38');
-
--- --------------------------------------------------------
-
---
--- Table structure for table `employee_feedback`
---
-
-CREATE TABLE IF NOT EXISTS `employee_feedback` (
-  `id` int(11) NOT NULL AUTO_INCREMENT,
-  `feedback` text NOT NULL,
-  `create_date` datetime NOT NULL,
-  `from_user_id` int(11) NOT NULL,
-  `to_employee_id` int(11) NOT NULL,
-  `type` int(11) NOT NULL COMMENT 'type is 1 or 0 positive and negative',
-  PRIMARY KEY (`id`)
-) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;
-
---
--- Dumping data for table `employee_feedback`
---
-
-INSERT INTO `employee_feedback` (`id`, `feedback`, `create_date`, `from_user_id`, `to_employee_id`, `type`) VALUES
-(1, 'Marvin lifted the toilet seat ', '2014-11-07 02:12:09', 12, 1, 1),
-(2, 'Marvin fixed my computer problem for free', '2014-11-05 00:00:00', 12, 1, 1),
-(3, 'Marvin did some nice logo for my websites', '2014-11-07 05:08:10', 14, 1, 1),
-(4, 'Marvin hacked my computer ', '2014-11-07 03:06:15', 13, 1, 0),
-(5, 'Marvin introduced a bug on sms', '2014-11-07 00:00:00', 17, 1, 0),
-(6, 'Marvin did a good job on my website, i will def hire him again in the future. ', '2014-11-10 02:04:06', 13, 1, 1),
-(7, 'Great job on my websites ', '2014-11-10 00:00:00', 18, 1, 1),
-(8, 'On time delivery, quality output \r\nthis guy is a pro ', '2014-11-10 00:00:00', 19, 1, 1),
-(9, 'Edgar is a Superman!', '2014-11-10 00:00:00', 18, 2, 1),
-(10, 'Edgar shared some useful tools for managing linux server', '2014-11-10 01:01:03', 17, 2, 1);
-
--- --------------------------------------------------------
-
---
--- Table structure for table `employee_files`
---
-
-CREATE TABLE IF NOT EXISTS `employee_files` (
-  `id` int(11) NOT NULL AUTO_INCREMENT,
-  `file_type_id` varchar(3) NOT NULL,
-  `filename` varchar(175) NOT NULL,
-  `description` varchar(225) NOT NULL,
-  `added` datetime NOT NULL,
-  `employee_id` int(11) NOT NULL,
-  PRIMARY KEY (`id`)
-) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=60 ;
-
---
--- Dumping data for table `employee_files`
---
-
-INSERT INTO `employee_files` (`id`, `file_type_id`, `filename`, `description`, `added`, `employee_id`) VALUES
-(49, '2', 'userfile4_2_5422c873eb0a1.doc', 'resume', '2014-09-24 21:34:43', 4),
-(50, '3', 'userfile7_3_5422c88bb459e.doc', 'Jo', '2014-09-24 21:35:07', 7),
-(51, '2', 'userfile7_2_5422c894147c4.doc', 'res', '2014-09-24 21:35:16', 7),
-(53, '2', 'userfile8_2_5423c910d2400.doc', 'res', '2014-09-25 15:49:36', 8),
-(54, '2', 'userfile3_2_5424ed5c3892f.doc', 'resume', '2014-09-26 12:36:44', 3),
-(55, '1', 'userfile3_1_5424ed985f752.jpg', 'my gf', '2014-09-26 12:37:44', 3),
-(56, '1', 'userfile6_1_5424ee2ee4f7d.jpg', 'resume picture', '2014-09-26 12:40:14', 6),
-(57, '3', 'userfile5_3_542ce69f5e476.sss', 'j Lawrence Job Offer', '2014-10-02 13:46:07', 5),
-(59, '1', 'userfile1_1_5445f5a94ad3d.jpg', 'Brochur Sourcefit', '2014-10-21 13:56:57', 1);
-
--- --------------------------------------------------------
-
---
--- Table structure for table `employee_filetypes`
---
-
-CREATE TABLE IF NOT EXISTS `employee_filetypes` (
-  `id` int(11) NOT NULL AUTO_INCREMENT,
-  `file_type_name` varchar(75) NOT NULL,
-  PRIMARY KEY (`id`)
-) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
-
---
--- Dumping data for table `employee_filetypes`
---
-
-INSERT INTO `employee_filetypes` (`id`, `file_type_name`) VALUES
-(1, 'Picture'),
-(2, 'Resume'),
-(3, 'Job Offer'),
-(4, 'Contract');
-
--- --------------------------------------------------------
-
---
--- Table structure for table `employee_logins`
---
-
-CREATE TABLE IF NOT EXISTS `employee_logins` (
-  `id` int(11) NOT NULL AUTO_INCREMENT,
-  `employee_id` int(11) NOT NULL,
-  `log_type` int(11) NOT NULL COMMENT '1 for in 0 for out',
-  `time` datetime NOT NULL,
-  `ip_address` text NOT NULL COMMENT 'the machine IP address use to login and log out',
-  PRIMARY KEY (`id`)
-) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=23 ;
-
---
--- Dumping data for table `employee_logins`
---
-
-INSERT INTO `employee_logins` (`id`, `employee_id`, `log_type`, `time`, `ip_address`) VALUES
-(1, 1, 0, '2014-10-27 17:01:32', '192.168.4.167'),
-(2, 1, 0, '2014-10-27 18:07:25', '192.168.4.167'),
-(3, 1, 0, '2014-10-27 19:04:24', '192.168.4.167'),
-(4, 1, 0, '2014-10-27 19:23:25', '192.168.4.167'),
-(5, 1, 0, '2014-10-27 19:26:39', '192.168.4.167'),
-(6, 1, 0, '2014-10-28 14:46:22', '192.168.4.167'),
-(7, 1, 0, '2014-10-28 14:47:14', '192.168.4.167'),
-(8, 1, 0, '2014-10-28 14:48:40', '192.168.4.167'),
-(9, 1, 0, '2014-10-28 14:51:34', '192.168.4.167'),
-(10, 1, 0, '2014-10-28 14:53:16', '192.168.4.167'),
-(11, 1, 0, '2014-10-28 14:55:28', '192.168.4.167'),
-(12, 1, 0, '2014-10-28 14:56:12', '192.168.4.167'),
-(13, 1, 0, '2014-10-28 14:57:12', '192.168.4.167'),
-(14, 1, 0, '2014-10-28 15:07:01', '192.168.4.167'),
-(15, 2, 0, '2014-10-28 15:10:01', '192.168.4.167'),
-(16, 4, 0, '2014-10-28 15:13:24', '192.168.4.167'),
-(17, 5, 0, '2014-10-28 15:18:32', '192.168.4.167'),
-(18, 6, 0, '2014-10-28 15:26:02', '192.168.4.167'),
-(19, 1, 0, '2014-11-10 00:47:46', '192.168.4.167'),
-(20, 8, 0, '2014-11-10 22:31:58', '192.168.4.167'),
-(21, 4, 0, '2014-11-11 01:49:56', '192.168.4.167'),
-(22, 2, 0, '2014-11-11 02:09:50', '192.168.4.167');
-
--- --------------------------------------------------------
-
---
--- Table structure for table `employee_memo`
---
-
-CREATE TABLE IF NOT EXISTS `employee_memo` (
-  `id` int(11) NOT NULL AUTO_INCREMENT,
-  `title` varchar(125) NOT NULL,
-  `filename` varchar(125) NOT NULL,
-  `issue_date` datetime NOT NULL,
-  `issued_to` int(11) NOT NULL,
-  `issued_by` int(11) NOT NULL COMMENT 'user id',
-  PRIMARY KEY (`id`)
-) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
-
---
--- Dumping data for table `employee_memo`
---
-
-INSERT INTO `employee_memo` (`id`, `title`, `filename`, `issue_date`, `issued_to`, `issued_by`) VALUES
-(1, 'first written warning', 'memo_1_544613840ae41.pdf', '2014-10-21 16:04:20', 1, 11),
-(2, 'e', 'memo_3_544f3ec5add4f.ico', '2014-10-28 14:59:17', 3, 11);
-
--- --------------------------------------------------------
-
---
--- Table structure for table `employee_notification`
---
-
-CREATE TABLE IF NOT EXISTS `employee_notification` (
-  `id` int(11) NOT NULL AUTO_INCREMENT,
-  `title` varchar(175) NOT NULL,
-  `from` int(11) NOT NULL COMMENT 'employee_id',
-  `to` int(11) NOT NULL COMMENT 'employee_id',
-  `link` text NOT NULL,
-  `created` datetime NOT NULL,
+  `title` varchar(75) NOT NULL,
+  `desc` text NOT NULL,
+  `thumbnail` varchar(125) NOT NULL,
+  `image_file` varchar(125) NOT NULL,
+  `uploaded` datetime NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `employee_position`
---
-
-CREATE TABLE IF NOT EXISTS `employee_position` (
-  `id` int(11) NOT NULL AUTO_INCREMENT,
-  `employee_id` int(11) NOT NULL,
-  `position_id` int(11) NOT NULL,
-  `created` datetime NOT NULL,
-  PRIMARY KEY (`id`)
-) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
-
---
--- Dumping data for table `employee_position`
---
-
-INSERT INTO `employee_position` (`id`, `employee_id`, `position_id`, `created`) VALUES
-(1, 1, 1, '2014-10-23 00:00:00'),
-(2, 2, 1, '2014-10-24 00:00:00');
-
--- --------------------------------------------------------
-
---
--- Table structure for table `employee_quiz`
---
-
-CREATE TABLE IF NOT EXISTS `employee_quiz` (
-  `id` int(11) NOT NULL AUTO_INCREMENT,
-  `title` varchar(175) NOT NULL,
-  `score` float NOT NULL,
-  `employee_id` int(11) NOT NULL,
-  `created` datetime NOT NULL,
-  `modified` datetime NOT NULL,
-  PRIMARY KEY (`id`)
-) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
-
---
--- Dumping data for table `employee_quiz`
---
-
-INSERT INTO `employee_quiz` (`id`, `title`, `score`, `employee_id`, `created`, `modified`) VALUES
-(1, 'basic brain test', 100, 1, '2014-11-05 00:49:03', '2014-11-05 00:49:03'),
-(2, 'Java Object Oriented Programming Basic', 86, 1, '2014-11-10 22:03:09', '2014-11-10 22:03:09'),
-(4, 'reb', 90, 3, '2014-11-04 16:56:15', '2014-11-04 16:56:15'),
-(5, 'designs', 90, 3, '2014-11-04 16:56:23', '2014-11-04 16:56:23');
-
--- --------------------------------------------------------
-
---
--- Table structure for table `employee_salary`
---
-
-CREATE TABLE IF NOT EXISTS `employee_salary` (
-  `id` int(11) NOT NULL AUTO_INCREMENT,
-  `employee_id` int(11) NOT NULL,
-  `salary` float NOT NULL,
-  `created` datetime NOT NULL,
-  `modified` datetime NOT NULL,
-  PRIMARY KEY (`id`)
-) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
-
---
--- Dumping data for table `employee_salary`
---
-
-INSERT INTO `employee_salary` (`id`, `employee_id`, `salary`, `created`, `modified`) VALUES
-(1, 1, 28000, '2014-04-16 00:00:00', '2014-04-16 00:00:00'),
-(2, 1, 45000, '2014-10-23 00:00:00', '2014-10-23 00:00:00'),
-(3, 2, 45000, '2014-10-23 00:00:00', '2014-10-23 00:00:00');
-
--- --------------------------------------------------------
-
---
--- Table structure for table `gender`
---
-
-CREATE TABLE IF NOT EXISTS `gender` (
-  `id` int(11) NOT NULL AUTO_INCREMENT,
-  `gender` varchar(75) NOT NULL,
-  PRIMARY KEY (`id`)
-) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
-
---
--- Dumping data for table `gender`
---
-
-INSERT INTO `gender` (`id`, `gender`) VALUES
-(1, 'male'),
-(2, 'female');
-
--- --------------------------------------------------------
-
---
--- Table structure for table `points_matrix`
---
-
-CREATE TABLE IF NOT EXISTS `points_matrix` (
-  `id` int(11) NOT NULL AUTO_INCREMENT,
-  `point_name` varchar(175) NOT NULL,
-  `point` float NOT NULL,
-  `created` datetime NOT NULL,
-  PRIMARY KEY (`id`)
-) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
-
---
--- Dumping data for table `points_matrix`
---
-
-INSERT INTO `points_matrix` (`id`, `point_name`, `point`, `created`) VALUES
-(1, 'Perfect Attendance', 2, '2014-11-07 14:46:11'),
-(2, 'Less than 2 absences ', 1, '2014-11-07 14:46:11'),
-(3, 'Perfect System Logging ', 5, '2014-11-07 14:46:11'),
-(4, 'No Undertime', 1, '2014-11-07 14:46:11');
-
--- --------------------------------------------------------
-
---
--- Table structure for table `positions`
---
-
-CREATE TABLE IF NOT EXISTS `positions` (
-  `id` int(11) NOT NULL AUTO_INCREMENT,
-  `position_name` varchar(75) NOT NULL,
-  `added` datetime NOT NULL,
-  PRIMARY KEY (`id`)
-) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
-
---
--- Dumping data for table `positions`
---
-
-INSERT INTO `positions` (`id`, `position_name`, `added`) VALUES
-(1, 'PHP Developer', '2014-09-15 00:00:00'),
-(2, 'Sr. PHP Developer', '2014-09-15 00:00:00'),
-(3, 'President', '2014-09-15 00:00:00'),
-(4, 'Sr. IT Support ', '2014-09-15 00:00:00'),
-(5, 'Jr. IT Support', '2014-09-15 00:00:00'),
-(6, 'HR Head', '2014-09-15 00:00:00'),
-(7, 'HR Assistant', '2014-09-15 00:00:00'),
-(8, 'Call Center Agent', '2014-09-15 00:00:00');
 
 -- --------------------------------------------------------
 

(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');

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

--
-- Table structure for table `user_profile`
--

CREATE TABLE IF NOT EXISTS `user_profile` (
  `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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;

--
-- Dumping data for table `user_profile`
--

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');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

  `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`
