workplan.sql

--
-- Script was generated by Devart dbForge Studio for MySQL, Version 6.3.337.0
-- Product home page: http://www.devart.com/dbforge/mysql/studio
-- Script date 12/1/2016 11:56:31 AM
-- Server version: 5.5.40-0+wheezy1
-- Client version: 4.1
--


-- 
-- Disable foreign keys
-- 
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

-- 
-- Set SQL mode
-- 
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

-- 
-- Set character set the client will use to send SQL statements to the server
--
SET NAMES 'utf8';

-- 
-- Set default database
--
USE WP20_OUT;

--
-- Definition for table department
--
DROP TABLE IF EXISTS department;
CREATE TABLE department (
  DEPT_ID INT(11) NOT NULL AUTO_INCREMENT,
  DEPARTMENT VARCHAR(20) NOT NULL,
  MANAGER INT(11) NOT NULL,
  DIRECTOR INT(11) NOT NULL,
  LOCATION VARCHAR(50) NOT NULL,
  PHONE_NO CHAR(20) NOT NULL,
  PRIMARY KEY (DEPT_ID)
)
ENGINE = MYISAM
AUTO_INCREMENT = 20
AVG_ROW_LENGTH = 50
CHARACTER SET latin1
COLLATE latin1_swedish_ci;

--
-- Definition for table field_names
--
DROP TABLE IF EXISTS field_names;
CREATE TABLE field_names (
  id INT(11) NOT NULL AUTO_INCREMENT,
  time_type VARCHAR(50) NOT NULL,
  priority_name VARCHAR(50) NOT NULL,
  public_engagement VARCHAR(50) NOT NULL,
  level_of_service VARCHAR(50) NOT NULL,
  user_defined1 VARCHAR(100) NOT NULL,
  PRIMARY KEY (id)
)
ENGINE = INNODB
AUTO_INCREMENT = 28
AVG_ROW_LENGTH = 321
CHARACTER SET latin1
COLLATE latin1_swedish_ci;

--
-- Definition for table pay_period
--
DROP TABLE IF EXISTS pay_period;
CREATE TABLE pay_period (
  pay_period_id INT(11) NOT NULL AUTO_INCREMENT,
  year INT(4) NOT NULL,
  pay_period_number INT(11) NOT NULL,
  start_date DATETIME NOT NULL,
  end_date DATETIME NOT NULL,
  PRIMARY KEY (pay_period_id)
)
ENGINE = INNODB
AUTO_INCREMENT = 82
AVG_ROW_LENGTH = 204
CHARACTER SET latin1
COLLATE latin1_swedish_ci;

--
-- Definition for table Priority
--
DROP TABLE IF EXISTS Priority;
CREATE TABLE Priority (
  id INT(11) NOT NULL AUTO_INCREMENT,
  Name VARCHAR(50) DEFAULT NULL,
  PRIMARY KEY (id)
)
ENGINE = INNODB
AUTO_INCREMENT = 33
AVG_ROW_LENGTH = 2730
CHARACTER SET latin1
COLLATE latin1_swedish_ci;

--
-- Definition for table program
--
DROP TABLE IF EXISTS program;
CREATE TABLE program (
  program_id INT(11) NOT NULL AUTO_INCREMENT,
  program_name VARCHAR(50) DEFAULT NULL,
  year VARCHAR(4) DEFAULT NULL,
  multi VARCHAR(4) NOT NULL DEFAULT '0',
  description VARCHAR(200) NOT NULL,
  lead VARCHAR(100) DEFAULT NULL,
  date_start DATE DEFAULT NULL,
  date_end DATE DEFAULT NULL,
  progress INT(11) NOT NULL DEFAULT 0,
  notes TEXT DEFAULT NULL,
  PRIMARY KEY (program_id)
)
ENGINE = INNODB
AUTO_INCREMENT = 8
AVG_ROW_LENGTH = 5461
CHARACTER SET utf8
COLLATE utf8_unicode_ci;

--
-- Definition for table project
--
DROP TABLE IF EXISTS project;
CREATE TABLE project (
  project_id INT(11) NOT NULL AUTO_INCREMENT,
  programm_id INT(11) DEFAULT NULL,
  project_name VARCHAR(200) DEFAULT NULL,
  date_start DATE DEFAULT NULL,
  date_end DATE DEFAULT NULL,
  approved_budget INT(11) DEFAULT NULL,
  notes TEXT NOT NULL,
  priority VARCHAR(100) DEFAULT NULL,
  lead VARCHAR(50) DEFAULT NULL,
  level_of_service VARCHAR(55) NOT NULL,
  multi_year VARCHAR(10) NOT NULL DEFAULT '0',
  public_engagement VARCHAR(100) NOT NULL,
  year VARCHAR(4) NOT NULL,
  approved VARCHAR(10) NOT NULL DEFAULT '0',
  progress VARCHAR(11) NOT NULL,
  staff_id INT(11) NOT NULL,
  dept_id INT(11) NOT NULL,
  budget_spent INT(11) NOT NULL,
  admin_flag INT(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (project_id),
  CONSTRAINT fk_project_program FOREIGN KEY (programm_id)
    REFERENCES program(program_id) ON DELETE RESTRICT ON UPDATE RESTRICT
)
ENGINE = INNODB
AUTO_INCREMENT = 219
AVG_ROW_LENGTH = 4096
CHARACTER SET utf8
COLLATE utf8_unicode_ci;

--
-- Definition for table staff
--
DROP TABLE IF EXISTS staff;
CREATE TABLE staff (
  staff_id INT(11) NOT NULL AUTO_INCREMENT,
  username VARCHAR(100) NOT NULL,
  email VARCHAR(100) NOT NULL,
  picture VARCHAR(100) NOT NULL,
  password VARCHAR(255) NOT NULL,
  dept_id INT(11) NOT NULL,
  `position` VARCHAR(50) NOT NULL,
  emp_number VARCHAR(20) NOT NULL,
  PRIMARY KEY (staff_id),
  UNIQUE INDEX UK_staff_username (username)
)
ENGINE = INNODB
AUTO_INCREMENT = 33
AVG_ROW_LENGTH = 8192
CHARACTER SET utf8
COLLATE utf8_unicode_ci;

--
-- Definition for table task
--
DROP TABLE IF EXISTS task;
CREATE TABLE task (
  task_id INT(11) NOT NULL AUTO_INCREMENT,
  project_id INT(11) DEFAULT NULL,
  assigned_to VARCHAR(50) DEFAULT NULL,
  date_start DATE DEFAULT NULL,
  date_end DATE DEFAULT NULL,
  task_name VARCHAR(200) DEFAULT NULL,
  notes TEXT NOT NULL,
  hrs DECIMAL(10, 0) DEFAULT NULL,
  wo VARCHAR(30) DEFAULT NULL,
  staff_id INT(11) DEFAULT NULL,
  PRIMARY KEY (task_id),
  INDEX FK_task_staff_username (assigned_to),
  CONSTRAINT fk_task_project FOREIGN KEY (project_id)
    REFERENCES project(project_id) ON DELETE RESTRICT ON UPDATE RESTRICT
)
ENGINE = INNODB
AUTO_INCREMENT = 516
AVG_ROW_LENGTH = 4096
CHARACTER SET utf8
COLLATE utf8_unicode_ci;

--
-- Definition for table task_names
--
DROP TABLE IF EXISTS task_names;
CREATE TABLE task_names (
  id INT(11) NOT NULL AUTO_INCREMENT,
  Name VARCHAR(100) DEFAULT NULL,
  PRIMARY KEY (id)
)
ENGINE = INNODB
AUTO_INCREMENT = 497
AVG_ROW_LENGTH = 4096
CHARACTER SET latin1
COLLATE latin1_swedish_ci;

--
-- Definition for table timesheet
--
DROP TABLE IF EXISTS timesheet;
CREATE TABLE timesheet (
  timesheet_id INT(11) NOT NULL AUTO_INCREMENT,
  name VARCHAR(100) DEFAULT NULL,
  task_id INT(11) DEFAULT NULL,
  hours VARCHAR(20) DEFAULT NULL,
  notes TEXT NOT NULL,
  time_type VARCHAR(50) DEFAULT NULL,
  date DATE NOT NULL,
  staff_id INT(11) NOT NULL,
  PRIMARY KEY (timesheet_id),
  INDEX fk_timesheet_staff (staff_id),
  INDEX fk_timesheet_task (task_id),
  CONSTRAINT FK_timesheet_task_task_id FOREIGN KEY (task_id)
    REFERENCES task(task_id) ON DELETE RESTRICT ON UPDATE RESTRICT
)
ENGINE = INNODB
AUTO_INCREMENT = 13286
AVG_ROW_LENGTH = 48
CHARACTER SET utf8
COLLATE utf8_unicode_ci;

--
-- Definition for table timetype
--
DROP TABLE IF EXISTS timetype;
CREATE TABLE timetype (
  id INT(11) NOT NULL AUTO_INCREMENT,
  type VARCHAR(50) DEFAULT NULL,
  description VARCHAR(255) DEFAULT NULL,
  PRIMARY KEY (id)
)
ENGINE = MYISAM
AUTO_INCREMENT = 7
AVG_ROW_LENGTH = 21
CHARACTER SET utf8
COLLATE utf8_unicode_ci;

--
-- Definition for table user_permissions
--
DROP TABLE IF EXISTS user_permissions;
CREATE TABLE user_permissions (
  user_id INT(11) DEFAULT NULL,
  page_name VARCHAR(500) DEFAULT NULL,
  perm_name VARCHAR(6) DEFAULT NULL
)
ENGINE = MYISAM
AVG_ROW_LENGTH = 28
CHARACTER SET latin1
COLLATE latin1_swedish_ci;

--
-- Definition for view ProjectView
--
DROP VIEW IF EXISTS ProjectView CASCADE;
CREATE OR REPLACE 
	DEFINER = 'root'@'%'
VIEW ProjectView
AS
	select `p`.`project_id` AS `project_id`,`m`.`program_name` AS `project_type`,`p`.`project_name` AS `project_name`,`p`.`date_start` AS `date_start`,`p`.`date_end` AS `date_end`,`p`.`year` AS `year`,'' AS `Objective`,`p`.`priority` AS `priority`,`s`.`username` AS `project_lead`,`p`.`approved_budget` AS `approved_budget`,`p`.`budget_spent` AS `budget_spent`,`p`.`multi_year` AS `multi_year`,`p`.`public_engagement` AS `public_engagement`,`p`.`level_of_service` AS `level_of_service`,`p`.`approved` AS `approved_by_cao`,ifnull(`p`.`progress`,0) AS `progress`,`d`.`DEPARTMENT` AS `DEPARTMENT`,ifnull(sum(`i`.`hours`),0) AS `total_hours`,ifnull(sum(`t`.`hrs`),0) AS `assigned_hours`,(1 - ifnull(`p`.`progress`,0)) AS `assigned_progress` from (((((`project` `p` left join `program` `m` on((`p`.`programm_id` = `m`.`program_id`))) left join `staff` `s` on((`p`.`lead` = `s`.`staff_id`))) left join `department` `d` on((`p`.`dept_id` = `d`.`DEPT_ID`))) left join `task` `t` on((`t`.`project_id` = `p`.`project_id`))) left join `timesheet` `i` on((`t`.`task_id` = `i`.`task_id`))) group by `p`.`project_id`;

--
-- Definition for view taskview
--
DROP VIEW IF EXISTS taskview CASCADE;
CREATE OR REPLACE 
	DEFINER = 'root'@'%'
VIEW taskview
AS
	select `task`.`task_id` AS `task_id`,`task`.`project_id` AS `project_id`,`task`.`assigned_to` AS `assigned_to`,`task`.`date_start` AS `date_start`,`task`.`date_end` AS `date_end`,`task`.`task_name` AS `task_name`,`task`.`notes` AS `notes`,`task`.`hrs` AS `hrs`,`task`.`wo` AS `wo`,`task`.`staff_id` AS `staff_id`,concat(`project`.`project_name`,': ',`task`.`task_name`) AS `Task`,`staff`.`username` AS `Assigned` from ((`task` left join `project` on((`task`.`project_id` = `project`.`project_id`))) left join `staff` on((`task`.`assigned_to` = `staff`.`staff_id`)));

-- 
-- Dumping data for table department
--
INSERT INTO department VALUES
(14, 'Finance', 0, 0, '', ''),
(15, 'Recreation', 0, 0, '', ''),
(16, 'Public Works', 0, 0, '', ''),
(17, 'Engineering', 0, 0, '', ''),
(18, 'Fire Department', 0, 0, '', ''),
(19, 'HR', 0, 0, '', '');

-- 
-- Dumping data for table field_names
--

-- Table WP20_OUT.field_names does not contain any data (it is empty)

-- 
-- Dumping data for table pay_period
--
INSERT INTO pay_period VALUES
(27, 2016, 1, '2016-01-03 00:00:00', '2016-01-16 23:59:59'),
(29, 2016, 2, '2016-01-17 00:00:00', '2016-01-30 23:59:59'),
(30, 2016, 3, '2016-01-31 00:00:00', '2016-02-13 23:59:59'),
(31, 2016, 4, '2016-02-14 00:00:00', '2016-02-27 23:59:59'),
(32, 2016, 5, '2016-02-28 00:00:00', '2016-03-12 23:59:59'),
(33, 2016, 6, '2016-03-13 00:00:00', '2016-03-26 23:59:59'),
(34, 2016, 7, '2016-03-27 00:00:00', '2016-04-09 23:59:59'),
(35, 2016, 8, '2016-04-10 00:00:00', '2016-04-23 23:59:59'),
(36, 2016, 9, '2016-04-24 00:00:00', '2016-05-07 23:59:59'),
(37, 2016, 10, '2016-05-08 00:00:00', '2016-05-21 23:59:59'),
(38, 2016, 11, '2016-05-22 00:00:00', '2016-06-04 23:59:59'),
(39, 2016, 12, '2016-06-05 00:00:00', '2016-06-18 23:59:59'),
(40, 2016, 13, '2016-06-19 00:00:00', '2016-07-02 23:59:59'),
(41, 2016, 14, '2016-07-03 00:00:00', '2016-07-16 23:59:59'),
(42, 2016, 15, '2016-07-17 00:00:00', '2016-07-30 23:59:59'),
(43, 2016, 16, '2016-07-31 00:00:00', '2016-08-13 23:59:59'),
(44, 2016, 17, '2016-08-14 00:00:00', '2016-08-27 23:59:59'),
(45, 2016, 18, '2016-08-28 00:00:00', '2016-09-10 23:59:59'),
(46, 2016, 19, '2016-09-11 00:00:00', '2016-09-24 23:59:59'),
(47, 2016, 20, '2016-09-25 00:00:00', '2016-10-08 23:59:59'),
(48, 2016, 21, '2016-10-09 00:00:00', '2016-10-22 23:59:59'),
(49, 2016, 22, '2016-10-23 00:00:00', '2016-11-05 23:59:59'),
(50, 2016, 23, '2016-11-06 00:00:00', '2016-11-19 23:59:59'),
(51, 2016, 24, '2016-11-20 00:00:00', '2016-12-03 23:59:59'),
(52, 2016, 25, '2016-12-04 00:00:00', '2016-12-17 23:59:59'),
(53, 2016, 26, '2016-12-18 00:00:00', '2016-12-31 23:59:59'),
(54, 2017, 1, '2017-01-01 00:00:00', '2017-01-14 23:59:59'),
(55, 2017, 2, '2017-01-15 00:00:00', '2017-01-28 23:59:59'),
(56, 2017, 3, '2017-01-29 00:00:00', '2017-02-11 23:59:59'),
(57, 2017, 4, '2017-02-12 00:00:00', '2017-02-25 23:59:59'),
(58, 2017, 5, '2017-02-26 00:00:00', '2017-03-11 23:59:59'),
(59, 2017, 6, '2017-03-12 00:00:00', '2017-03-25 23:59:59'),
(60, 2017, 7, '2017-03-26 00:00:00', '2017-04-08 23:59:59'),
(61, 2017, 8, '2017-04-09 00:00:00', '2017-04-22 23:59:59'),
(62, 2017, 9, '2017-04-23 00:00:00', '2017-05-06 23:59:59'),
(63, 2017, 10, '2017-05-07 00:00:00', '2017-05-20 23:59:59'),
(64, 2017, 11, '2017-05-21 00:00:00', '2017-06-03 23:59:59'),
(65, 2017, 12, '2017-06-04 00:00:00', '2017-06-17 23:59:59'),
(66, 2017, 13, '2017-06-18 00:00:00', '2017-07-01 23:59:59'),
(67, 2017, 14, '2017-07-02 00:00:00', '2017-07-15 23:59:59'),
(68, 2017, 15, '2017-07-16 00:00:00', '2017-07-29 23:59:59'),
(69, 2017, 16, '2017-07-30 00:00:00', '2017-08-12 23:59:59'),
(70, 2017, 17, '2017-08-13 00:00:00', '2017-08-26 23:59:59'),
(71, 2017, 18, '2017-08-27 00:00:00', '2017-09-09 23:59:59'),
(72, 2017, 19, '2017-09-10 00:00:00', '2017-09-23 23:59:59'),
(73, 2017, 20, '2017-09-24 00:00:00', '2017-10-07 23:59:59'),
(74, 2017, 21, '2017-10-08 00:00:00', '2017-10-21 23:59:59'),
(75, 2017, 22, '2017-10-22 00:00:00', '2017-11-04 23:59:59'),
(76, 2017, 23, '2017-11-05 00:00:00', '2017-11-18 23:59:59'),
(77, 2017, 24, '2017-11-19 00:00:00', '2017-12-02 23:59:59'),
(78, 2017, 25, '2017-12-03 00:00:00', '2017-12-16 23:59:59'),
(79, 2017, 26, '2017-12-17 00:00:00', '2017-12-30 23:59:59'),
(80, 2018, 1, '2017-12-31 00:00:00', '2018-01-13 23:59:59'),
(81, 2018, 2, '2018-01-14 00:00:00', '2018-01-27 23:59:59');

-- 
-- Dumping data for table Priority
--
INSERT INTO Priority VALUES
(11, 'Priority #1 - WorkPlan'),
(12, 'Priority # 2 -Water Meters'),
(13, 'Priority # 3 - E Commerce'),
(14, 'Priority # 4 - Document Management'),
(17, 'Statutory Flexible'),
(18, 'Existing Service - Own'),
(19, 'Existing Service - Shared'),
(20, 'Zinger'),
(32, 'Statutory Absolute');

-- 
-- Dumping data for table program
--
INSERT INTO program VALUES
(4, 'GIS Services', '2016', '0', '', 'Manager Two', '2016-01-01', '2016-12-31', 0, NULL),
(5, 'IT Services TEST', '2016', '1', '', 'Manager One', '2016-01-01', '2016-12-31', 0, NULL),
(6, 'Corporate Projects', NULL, '1', '', 'Manager One', '2016-01-01', '2016-12-31', 0, NULL),
(7, 'Common Administration', NULL, '1', '', 'Manager One', '2016-01-01', '2016-07-04', 0, NULL);

-- 
-- Dumping data for table project
--
INSERT INTO project VALUES
(56, 4, 'City Limits Boundary Extension', '2016-01-01', '2016-12-31', 25000, 'Staff to fill in', 'Existing Service - Shared', '31', 'New Level Of Service/Asset(s)', '0', '0 - No Public Engagement (CAO Authorization Only)', '2016', '0', '0.7', 31, 4, 10000, 0),
(57, 6, 'Website redesign', '2016-01-01', '2016-12-31', 80000, '', 'Existing Service - Shared', '32', 'Upgrade Level Of Service', '0', '1 - Inform', '2016', '0', '0.6', 32, 7, 75000, 0),
(58, 5, 'PC Replacement', '2016-01-01', '2016-12-31', 50000, '', 'Existing Service - Shared', '31', 'Maintain existing Level Of Service', '1', '0 - No Public Engagement (CAO Authorization Only)', '2016', '0', '0.40', 31, 7, 10000, 0),
(59, 5, 'Server replacement', '2016-01-01', '2016-12-31', 50000, '', 'Existing Service - Shared', '32', 'Maintain existing Level Of Service', '1', '0 - No Public Engagement (CAO Authorization Only)', '2016', '0', '0.7', 32, 7, 0, 0),
(61, 6, 'Document Management', '2016-01-01', '2016-12-31', 25000, '', 'Existing Service - Own', '31', 'Upgrade Level Of Service', '1', '0 - No Public Engagement (CAO Authorization Only)', '2016', '0', '0.20', 31, 6, 5000, 0),
(68, 6, 'Asset Management', '2016-01-01', '2016-12-31', 30000, '', 'Existing Service - Shared', '32', 'Upgrade Level Of Service', '1', '0 - No Public Engagement (CAO Authorization Only)', '2016', '0', '0', 32, 6, 0, 0),
(75, 7, 'Common Office Admin', '2016-01-01', '2016-12-31', 0, 'common catch all for office duties.\r\ncommon catch all for office duties.\r\ncommon catch all for office duties...\r\ncommon catch all for office duties\r\ncommon catch all for office dutiescommon catch all for office dutiescommon catch all for office dutiescommon catch all for office dutiescommon catch all for office dutiescommon catch all for office dutiescommon catch all for office duties', 'Existing Service - Own', '31', 'Maintain existing Level Of Service', '0', '0 - No Public Engagement (CAO Authorization Only)', '2016', '0', '0', 31, 4, 0, 0);

-- 
-- Dumping data for table staff
--
INSERT INTO staff VALUES
(1, 'admin', 'admin@domain.org', 'images/small_admin.png', '8c6976e5b5410415bde908bd4dee15dfb167a9c873fc4bb8a81f6f2ab448a918', 0, '', ''),
(31, 'Manager One', 'manager1@domain.org', 'images/small_generic_female.jpg', '380f9771d2df8566ce2bd5b8ed772b0bb74fd6457fb803ab2d267c394d89c750', 14, '', ''),
(32, 'Manager Two', 'manager2@domain.org', 'images/small_generic_male.jpg', '9d05b6092d975b0884c6ba7fadb283ced03da9822ebbd13cc6b6d1855a6495ec', 15, '', '');

-- 
-- Dumping data for table task
--
INSERT INTO task VALUES
(179, 56, '31', '2016-01-01', '2016-12-31', 'Zoning Changes', 'setup fields', 24, NULL, 31),
(181, 59, '32', '2016-01-01', '2016-12-31', 'General Office Task', 'TESTING', 7, NULL, 32),
(182, 59, '32', '2016-01-01', '2016-12-31', 'PC Rollout or Build', '', 7, NULL, 32),
(183, 61, '31', '2016-01-01', '2016-12-31', 'Initiating Process', 'Testing', 7, NULL, 31),
(184, 56, '31', '2016-01-01', '2016-12-31', 'Closing Process', 'TEST', 7, NULL, 31),
(189, 58, '31', '2016-01-01', '2016-12-31', 'Budget', 'test', 21, NULL, 31),
(190, 68, '32', '2016-01-01', '2016-12-31', 'PC Rollout or Build', 'The moon is a balloon and then some...', 21, NULL, 32),
(193, 75, '31', '2016-01-01', '2016-12-31', 'General Office Task', '', 21, NULL, 31);

-- 
-- Dumping data for table task_names
--
INSERT INTO task_names VALUES
(73, 'Zoning Changes'),
(75, 'Server Maintenance or Build'),
(76, 'Network Maintenance'),
(77, 'PC Rollout or Build'),
(78, 'Project Mangement'),
(80, 'RFP Preperation'),
(84, 'General Office Task'),
(96, 'Software Development'),
(100, 'Zinger '),
(107, 'Planning Process'),
(108, 'Executing Process'),
(109, 'Initiating Process'),
(110, 'Monitoring and Controlling Process'),
(111, 'Closing Process'),
(117, 'Budget'),
(118, 'Project Planning'),
(119, 'Workplan Documentation & Training');

-- 
-- Dumping data for table timesheet
--
INSERT INTO timesheet VALUES
(13278, 'manager one', 179, '7', '', NULL, '2016-11-24', 31),
(13279, 'manager one', 183, '7', '', NULL, '2016-11-24', 31),
(13280, 'manager one', 184, '7', '', NULL, '2016-11-24', 31),
(13281, 'manager one', 189, '7', '', NULL, '2016-11-24', 31),
(13282, 'manager one', 193, '7', '', NULL, '2016-11-24', 31),
(13283, 'manager two', 181, '7', '', NULL, '2016-11-24', 32),
(13284, 'manager two', 182, '7', '', NULL, '2016-11-24', 32),
(13285, 'manager two', 190, '7', '', NULL, '2016-11-24', 32);

-- 
-- Dumping data for table timetype
--
INSERT INTO timetype VALUES
(1, 'Vacation', 'Vacation'),
(2, 'Overtime', 'Overtime'),
(3, 'Regular Time', 'Regular Daily time'),
(4, '1NSALF', 'Non Union Salary full time'),
(5, '2NSTAT', 'Non Union Stat Holiday'),
(6, '2NTRN', 'Non Union Training');

-- 
-- Dumping data for table user_permissions
--
INSERT INTO user_permissions VALUES
(1, '', 'SELECT'),
(1, '', 'UPDATE'),
(1, '', 'INSERT'),
(1, '', 'DELETE'),
(1, '', 'ADMIN'),
(31, 'Dashboard', 'SELECT'),
(31, 'Hours per Project by user', 'SELECT'),
(31, 'timesheet', 'INSERT'),
(31, 'timesheet', 'UPDATE'),
(31, 'timesheet', 'SELECT'),
(31, 'ProjectView', 'SELECT'),
(31, 'Allocated Hrs by Priority', 'SELECT'),
(31, 'Project by Approved Budget', 'SELECT'),
(31, 'Project Time Line', 'SELECT'),
(31, 'Total hrs Estimated Hrs', 'SELECT'),
(31, 'Total Allocated Hrs', 'SELECT'),
(31, 'Actual Hours', 'SELECT'),
(31, 'Hours per project', 'SELECT'),
(31, 'total allocated hours small', 'SELECT'),
(31, 'actuall hours versus allocated hours small', 'SELECT'),
(31, 'project by approved budget small', 'SELECT'),
(31, 'allocated hours by priority small', 'SELECT'),
(31, 'actual hours small', 'SELECT'),
(31, 'hours per project small', 'SELECT'),
(31, 'project timeline small', 'SELECT'),
(31, 'department_projects', 'SELECT'),
(31, 'department_projects', 'UPDATE'),
(31, 'department_projects', 'INSERT'),
(31, 'department_projects', 'DELETE'),
(31, 'department_projects.task', 'SELECT'),
(31, 'department_projects.project', 'SELECT'),
(32, 'Dashboard', 'SELECT'),
(32, 'Hours per Project by user', 'SELECT'),
(32, 'task.timesheet', 'UPDATE'),
(32, 'task.timesheet', 'SELECT'),
(32, 'project_timeline_detail', 'SELECT'),
(32, 'Allocated Hrs by Priority', 'SELECT'),
(32, 'Project by Approved Budget', 'SELECT'),
(32, 'Project Time Line', 'SELECT'),
(32, 'Total hrs Estimated Hrs', 'SELECT'),
(32, 'Total Allocated Hrs', 'SELECT'),
(32, 'Actual Hours', 'SELECT'),
(32, 'Hours per project', 'SELECT'),
(32, 'Pay Period', 'SELECT'),
(32, 'total allocated hours small', 'SELECT'),
(32, 'actuall hours versus allocated hours small', 'SELECT'),
(32, 'project by approved budget small', 'SELECT'),
(32, 'allocated hours by priority small', 'SELECT'),
(32, 'actual hours small', 'SELECT'),
(32, 'hours per project small', 'SELECT'),
(32, 'project timeline small', 'SELECT'),
(32, 'department_projects', 'SELECT'),
(32, 'department_projects', 'UPDATE'),
(32, 'department_projects', 'INSERT'),
(32, 'department_projects', 'DELETE'),
(32, 'department_projects.task', 'SELECT'),
(32, 'department_projects.task', 'UPDATE'),
(32, 'department_projects.task', 'INSERT'),
(32, 'department_projects.task', 'DELETE'),
(32, 'department_projects.project', 'SELECT'),
(32, 'department_projects.project', 'UPDATE'),
(32, 'department_projects.project', 'INSERT'),
(32, 'department_projects.project', 'DELETE'),
(31, 'project', 'SELECT'),
(31, 'project', 'UPDATE'),
(31, 'project', 'INSERT'),
(31, 'project', 'DELETE'),
(31, 'project.task', 'SELECT'),
(31, 'project.project_timeline_detail', 'SELECT'),
(31, 'project.ProjectView', 'SELECT'),
(31, 'task', 'SELECT'),
(31, 'task', 'UPDATE'),
(31, 'task', 'INSERT'),
(31, 'task', 'DELETE'),
(31, 'task.timesheet', 'SELECT'),
(31, 'task.timesheet', 'UPDATE'),
(31, 'task.timesheet', 'INSERT'),
(31, 'task.timesheet', 'DELETE'),
(31, 'project_timeline_detail', 'SELECT'),
(31, 'View Pay Period', 'SELECT'),
(31, 'Multiple Time Entry', 'SELECT'),
(31, 'Multiple Time Entry', 'UPDATE'),
(31, 'Multiple Time Entry', 'INSERT'),
(31, 'Multiple Time Entry', 'DELETE'),
(32, 'project', 'SELECT'),
(32, 'project', 'UPDATE'),
(32, 'project', 'INSERT'),
(32, 'project', 'DELETE'),
(32, 'project.task', 'SELECT'),
(32, 'project.task', 'UPDATE'),
(32, 'project.task', 'INSERT'),
(32, 'project.task', 'DELETE'),
(32, 'project.ProjectView', 'SELECT'),
(32, 'project.project_timeline_detail', 'SELECT'),
(32, 'task', 'SELECT'),
(32, 'task', 'UPDATE'),
(32, 'task', 'INSERT'),
(32, 'task', 'DELETE'),
(32, 'task.timesheet', 'INSERT'),
(32, 'task.timesheet', 'DELETE'),
(32, 'View Pay Period', 'SELECT'),
(32, 'Multiple Time Entry', 'SELECT'),
(32, 'Multiple Time Entry', 'UPDATE'),
(32, 'Multiple Time Entry', 'INSERT'),
(32, 'Multiple Time Entry', 'DELETE'),
(31, 'project.task', 'UPDATE'),
(31, 'project.task', 'INSERT'),
(31, 'project.task', 'DELETE'),
(31, 'timesheet', 'DELETE');

-- 
-- Restore previous SQL mode
-- 
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

-- 
-- Enable foreign keys
-- 
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;