-- phpMyAdmin SQL Dump
-- version 4.2.7.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Jun 13, 2018 at 12:18 PM
-- Server version: 5.6.20
-- PHP Version: 5.5.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 utf8 */;

--
-- Database: `db_hr`
--

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

--
-- Table structure for table `tbl_attendance_pass`
--

CREATE TABLE IF NOT EXISTS `tbl_attendance_pass` (
`id` bigint(20) NOT NULL,
  `code` varchar(100) NOT NULL,
  `date` date NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `tbl_attendance_pass`
--

INSERT INTO `tbl_attendance_pass` (`id`, `code`, `date`) VALUES
(1, '4462', '2018-06-13');

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

--
-- Table structure for table `tbl_attendance_type`
--

CREATE TABLE IF NOT EXISTS `tbl_attendance_type` (
`id` bigint(20) NOT NULL,
  `type` varchar(100) NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `tbl_attendance_type`
--

INSERT INTO `tbl_attendance_type` (`id`, `type`) VALUES
(1, 'general'),
(2, 'holiday'),
(3, 'leave'),
(4, 'sunday');

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

--
-- Table structure for table `tbl_billing_term_detail`
--

CREATE TABLE IF NOT EXISTS `tbl_billing_term_detail` (
`id` bigint(20) NOT NULL,
  `bill_term_master_id` bigint(20) NOT NULL,
  `serial_no` bigint(20) NOT NULL,
  `terms` varchar(255) NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `tbl_billing_term_detail`
--

INSERT INTO `tbl_billing_term_detail` (`id`, `bill_term_master_id`, `serial_no`, `terms`) VALUES
(1, 1, 1, 'term of type 1'),
(2, 1, 2, 'second term of type 1'),
(3, 1, 3, 'third term of type 1'),
(4, 2, 1, 'first term of type 2'),
(5, 2, 2, 'second term for type 2'),
(6, 2, 3, 'third term of type 2'),
(7, 3, 1, 'First term of bill type '),
(8, 3, 2, 'Second term of bill type');

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

--
-- Table structure for table `tbl_billing_term_mstr`
--

CREATE TABLE IF NOT EXISTS `tbl_billing_term_mstr` (
`id` bigint(20) NOT NULL,
  `type_of_billing` varchar(255) NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `tbl_billing_term_mstr`
--

INSERT INTO `tbl_billing_term_mstr` (`id`, `type_of_billing`) VALUES
(1, 'type 1'),
(2, 'Type2'),
(3, 'bill type');

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

--
-- Table structure for table `tbl_department`
--

CREATE TABLE IF NOT EXISTS `tbl_department` (
`id` bigint(20) NOT NULL,
  `department` varchar(100) NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `tbl_department`
--

INSERT INTO `tbl_department` (`id`, `department`) VALUES
(1, 'IT'),
(2, 'CIVIL');

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

--
-- Table structure for table `tbl_designation`
--

CREATE TABLE IF NOT EXISTS `tbl_designation` (
`id` bigint(20) NOT NULL,
  `dept_id` bigint(20) NOT NULL,
  `designation` varchar(100) NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `tbl_designation`
--

INSERT INTO `tbl_designation` (`id`, `dept_id`, `designation`) VALUES
(1, 1, 'software testing'),
(2, 1, 'software developer');

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

--
-- Table structure for table `tbl_emp_attendance`
--

CREATE TABLE IF NOT EXISTS `tbl_emp_attendance` (
`id` bigint(20) NOT NULL,
  `emp_id` bigint(20) NOT NULL,
  `present_type_id` bigint(20) NOT NULL,
  `date_` date NOT NULL,
  `status` int(11) NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;

--
-- Dumping data for table `tbl_emp_attendance`
--

INSERT INTO `tbl_emp_attendance` (`id`, `emp_id`, `present_type_id`, `date_`, `status`) VALUES
(1, 2, 3, '2018-06-12', 1),
(3, 2, 3, '2018-06-14', 1),
(4, 2, 3, '2018-06-15', 1),
(5, 2, 4, '2018-06-03', 1),
(6, 2, 4, '2018-06-10', 1),
(7, 1, 4, '2018-06-03', 1),
(8, 1, 4, '2018-06-10', 1),
(9, 2, 1, '2018-06-11', 1),
(20, 1, 1, '2018-06-13', 1);

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

--
-- Table structure for table `tbl_emp_desg_dept`
--

CREATE TABLE IF NOT EXISTS `tbl_emp_desg_dept` (
`id` bigint(20) NOT NULL,
  `dept_id` bigint(20) NOT NULL,
  `desig_id` bigint(20) NOT NULL,
  `emp_id` bigint(20) NOT NULL,
  `leader_id` bigint(20) NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `tbl_emp_desg_dept`
--

INSERT INTO `tbl_emp_desg_dept` (`id`, `dept_id`, `desig_id`, `emp_id`, `leader_id`) VALUES
(1, 1, 2, 1, 0),
(2, 1, 2, 2, 1);

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

--
-- Table structure for table `tbl_emp_identity`
--

CREATE TABLE IF NOT EXISTS `tbl_emp_identity` (
`id` bigint(20) NOT NULL,
  `emp_id` bigint(20) NOT NULL,
  `identity_id` bigint(20) NOT NULL,
  `image` varchar(200) NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `tbl_emp_identity`
--

INSERT INTO `tbl_emp_identity` (`id`, `emp_id`, `identity_id`, `image`) VALUES
(1, 1, 1, 'EMP0072_666354920.png'),
(2, 1, 2, 'EMP0072_2079851331.png'),
(3, 2, 1, 'EMP0073_1267103245.png'),
(4, 2, 2, 'EMP0073_409832935.png');

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

--
-- Table structure for table `tbl_emp_master`
--

CREATE TABLE IF NOT EXISTS `tbl_emp_master` (
`id` bigint(20) NOT NULL,
  `emp_code` varchar(100) NOT NULL,
  `emp_name` varchar(100) NOT NULL,
  `dob` date NOT NULL,
  `aadhar_no` bigint(20) NOT NULL,
  `phone_no` double NOT NULL,
  `gender` varchar(11) NOT NULL,
  `father_name` varchar(100) NOT NULL,
  `mother_name` varchar(100) NOT NULL,
  `marital_status` varchar(10) NOT NULL,
  `p_address` varchar(100) NOT NULL,
  `c_address` varchar(100) NOT NULL,
  `date_of_join` date NOT NULL,
  `emp_terminate_date` date NOT NULL,
  `termination_remark` varchar(100) NOT NULL,
  `del_status` int(11) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `entry_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `tbl_emp_master`
--

INSERT INTO `tbl_emp_master` (`id`, `emp_code`, `emp_name`, `dob`, `aadhar_no`, `phone_no`, `gender`, `father_name`, `mother_name`, `marital_status`, `p_address`, `c_address`, `date_of_join`, `emp_terminate_date`, `termination_remark`, `del_status`, `user_id`, `entry_time`) VALUES
(1, 'EMP008', 'Amit', '2018-06-12', 455454, 7903234816, 'male', 'ffd', 'df', 'single', 'fdy', 'y nt', '2018-06-12', '0000-00-00', '', 0, 1, '2018-06-12 08:47:45'),
(2, 'EMP009', 'Tausif', '2018-06-12', 455454, 8603715065, 'male', 'ffd', 'Employee', 'single', 'ght', 'yru', '2018-06-12', '0000-00-00', '', 0, 1, '2018-06-12 08:50:00');

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

--
-- Table structure for table `tbl_emp_qualification`
--

CREATE TABLE IF NOT EXISTS `tbl_emp_qualification` (
`id` bigint(20) NOT NULL,
  `emp_id` bigint(20) NOT NULL,
  `course` varchar(100) NOT NULL,
  `univ_board` varchar(100) NOT NULL,
  `percentage` int(20) NOT NULL,
  `year_of_pass` int(20) NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `tbl_emp_qualification`
--

INSERT INTO `tbl_emp_qualification` (`id`, `emp_id`, `course`, `univ_board`, `percentage`, `year_of_pass`) VALUES
(1, 1, 'tyr', 'yt', 34, 13),
(2, 2, 'ytu', 'tyyu', 12, 210);

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

--
-- Table structure for table `tbl_emp_skill`
--

CREATE TABLE IF NOT EXISTS `tbl_emp_skill` (
`id` bigint(20) NOT NULL,
  `emp_id` bigint(20) NOT NULL,
  `skill` varchar(100) NOT NULL,
  `skill_level` varchar(10) NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `tbl_emp_skill`
--

INSERT INTO `tbl_emp_skill` (`id`, `emp_id`, `skill`, `skill_level`) VALUES
(1, 1, 'html', 'basic'),
(2, 2, 'html', 'intermedia');

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

--
-- Table structure for table `tbl_emp_work_exp`
--

CREATE TABLE IF NOT EXISTS `tbl_emp_work_exp` (
`id` bigint(20) NOT NULL,
  `emp_id` bigint(20) NOT NULL,
  `company` varchar(100) NOT NULL,
  `department` varchar(100) NOT NULL,
  `designation` varchar(100) NOT NULL,
  `date_join` date NOT NULL,
  `date_leave` date NOT NULL,
  `cntct_prson1_name` varchar(100) NOT NULL,
  `cntct_prson1_phone` double NOT NULL,
  `cntct_prson2_name` varchar(100) NOT NULL,
  `cntct_prson2_phone` double NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `tbl_emp_work_exp`
--

INSERT INTO `tbl_emp_work_exp` (`id`, `emp_id`, `company`, `department`, `designation`, `date_join`, `date_leave`, `cntct_prson1_name`, `cntct_prson1_phone`, `cntct_prson2_name`, `cntct_prson2_phone`) VALUES
(1, 1, 'tyy', 'gh', 'software testing', '2018-06-12', '2018-06-12', '', 0, '', 0),
(2, 2, 'ui', 'uy', 'uiy', '2018-06-12', '2018-06-12', '', 0, '', 0);

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

--
-- Table structure for table `tbl_holiday_mstr`
--

CREATE TABLE IF NOT EXISTS `tbl_holiday_mstr` (
`Id` bigint(20) NOT NULL,
  `holiday_name` varchar(255) NOT NULL,
  `date1` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `tbl_identity_master`
--

CREATE TABLE IF NOT EXISTS `tbl_identity_master` (
`id` bigint(20) NOT NULL,
  `identity_type` varchar(10) NOT NULL,
  `del_status` int(10) NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `tbl_identity_master`
--

INSERT INTO `tbl_identity_master` (`id`, `identity_type`, `del_status`) VALUES
(1, 'aadhar', 0),
(2, 'photo', 0);

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

--
-- Table structure for table `tbl_leave_detail`
--

CREATE TABLE IF NOT EXISTS `tbl_leave_detail` (
`id` bigint(20) NOT NULL,
  `emp_id` bigint(20) NOT NULL,
  `leave_type_id` bigint(20) NOT NULL,
  `leave_detail` varchar(100) NOT NULL,
  `leave_date` date NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `leave_request_id` bigint(20) NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `tbl_leave_detail`
--

INSERT INTO `tbl_leave_detail` (`id`, `emp_id`, `leave_type_id`, `leave_detail`, `leave_date`, `user_id`, `leave_request_id`) VALUES
(1, 2, 1, 'tuyt', '2018-06-12', 6, 1),
(2, 2, 1, 'tuyt', '2018-06-13', 6, 1),
(3, 2, 1, 'tuyt', '2018-06-14', 6, 1),
(4, 2, 1, 'tuyt', '2018-06-15', 6, 1);

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

--
-- Table structure for table `tbl_leave_request`
--

CREATE TABLE IF NOT EXISTS `tbl_leave_request` (
`id` bigint(20) NOT NULL,
  `emp_id` bigint(20) NOT NULL,
  `leave_detail` varchar(255) NOT NULL,
  `leave_type` varchar(255) NOT NULL,
  `from_date` date NOT NULL,
  `to_date` date NOT NULL,
  `request_to` varchar(255) NOT NULL,
  `leave_status` tinyint(4) NOT NULL,
  `remark` varchar(100) NOT NULL,
  `requested_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `tbl_leave_request`
--

INSERT INTO `tbl_leave_request` (`id`, `emp_id`, `leave_detail`, `leave_type`, `from_date`, `to_date`, `request_to`, `leave_status`, `remark`, `requested_time`) VALUES
(1, 2, 'tuyt', '1', '2018-06-12', '2018-06-15', '1', 1, '', '2018-06-12 08:58:58');

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

--
-- Table structure for table `tbl_leave_type`
--

CREATE TABLE IF NOT EXISTS `tbl_leave_type` (
`id` bigint(20) NOT NULL,
  `leave_type` varchar(100) NOT NULL,
  `num_of_day` int(10) NOT NULL,
  `time_to_give` varchar(100) NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `tbl_leave_type`
--

INSERT INTO `tbl_leave_type` (`id`, `leave_type`, `num_of_day`, `time_to_give`) VALUES
(1, 'cl', 5, 'once in month');

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

--
-- Table structure for table `tbl_loc_dtl`
--

CREATE TABLE IF NOT EXISTS `tbl_loc_dtl` (
`id` bigint(20) NOT NULL,
  `ent_dt` date NOT NULL,
  `emp_id` bigint(20) NOT NULL,
  `lat` varchar(100) NOT NULL,
  `lang` varchar(100) NOT NULL,
  `image` varchar(100) NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

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

--
-- Table structure for table `tbl_menu_mtr`
--

CREATE TABLE IF NOT EXISTS `tbl_menu_mtr` (
`id` int(11) NOT NULL,
  `menu_name` varchar(200) NOT NULL,
  `file_path` varchar(200) NOT NULL,
  `under_menu_id` int(100) NOT NULL,
  `menu_order` int(100) NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;

--
-- Dumping data for table `tbl_menu_mtr`
--

INSERT INTO `tbl_menu_mtr` (`id`, `menu_name`, `file_path`, `under_menu_id`, `menu_order`) VALUES
(1, 'Employee', '#', 0, 0),
(2, 'Add Employee', 'new_employee.php', 1, 1),
(3, 'Employee Details', 'employee_details.php', 1, 2),
(4, 'Terminate List', 'employee_terminate_list.php', 1, 3),
(5, 'Attendance', '#', 0, 2),
(6, 'Add Holidays', 'add_holidays.php', 5, 1),
(7, 'Attendance', 'add_attendance.php', 5, 2),
(8, 'Leave', '#', 0, 3),
(9, 'Leave Type', 'leave_types.php', 8, 1),
(10, 'Billing', '#', 0, 4),
(11, 'Workorder Detail', 'workorder_detail.php', 10, 1),
(12, 'Billing Terms', 'billing_terms.php', 10, 2),
(13, 'Send Leave Request', 'leave_request.php', 8, 2),
(14, 'Leave Requests', 'view_leave_request.php', 8, 3),
(15, 'Direct Leave', 'grant_leave.php', 8, 4),
(16, 'My Leave', 'my_leave.php', 8, 5),
(17, 'Add Attendance', 'make_attendance.php', 5, 3),
(18, 'Location', '#', 0, 7),
(19, 'Employee Location', 'employee_location.php', 18, 1);

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

--
-- Table structure for table `tbl_menu_permission`
--

CREATE TABLE IF NOT EXISTS `tbl_menu_permission` (
`id` int(11) NOT NULL,
  `menu_id` int(100) NOT NULL,
  `user_type_id` int(100) NOT NULL,
  `status` int(100) NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=45 ;

--
-- Dumping data for table `tbl_menu_permission`
--

INSERT INTO `tbl_menu_permission` (`id`, `menu_id`, `user_type_id`, `status`) VALUES
(1, 1, 1, 1),
(2, 2, 1, 1),
(3, 2, 2, 2),
(4, 3, 3, 2),
(5, 3, 1, 1),
(6, 4, 3, 2),
(7, 4, 1, 1),
(8, 5, 2, 2),
(9, 5, 3, 2),
(10, 5, 1, 1),
(11, 6, 1, 1),
(12, 7, 2, 2),
(13, 7, 1, 1),
(14, 4, 2, 2),
(15, 8, 2, 2),
(16, 8, 3, 2),
(17, 8, 1, 1),
(18, 9, 2, 2),
(19, 9, 3, 1),
(20, 9, 1, 1),
(21, 10, 2, 2),
(22, 10, 3, 2),
(23, 10, 1, 1),
(24, 11, 2, 2),
(25, 11, 3, 2),
(26, 11, 1, 1),
(27, 12, 2, 2),
(28, 12, 3, 2),
(29, 12, 1, 1),
(30, 1, 3, 1),
(31, 13, 2, 1),
(32, 13, 1, 1),
(33, 14, 2, 1),
(34, 14, 1, 1),
(35, 15, 2, 2),
(36, 15, 1, 1),
(37, 16, 2, 1),
(38, 16, 3, 1),
(39, 16, 1, 1),
(40, 17, 2, 1),
(41, 17, 3, 1),
(42, 17, 1, 1),
(43, 18, 1, 1),
(44, 19, 1, 1);

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

--
-- Table structure for table `tbl_profile_pic`
--

CREATE TABLE IF NOT EXISTS `tbl_profile_pic` (
`id` bigint(20) NOT NULL,
  `emp_id` bigint(20) NOT NULL,
  `image` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `tbl_user_mstr`
--

CREATE TABLE IF NOT EXISTS `tbl_user_mstr` (
`id` bigint(20) NOT NULL,
  `user_type_id` bigint(20) DEFAULT NULL,
  `dept_id` bigint(20) NOT NULL,
  `emp_id` bigint(20) NOT NULL,
  `name` varchar(100) NOT NULL,
  `phone` varchar(100) NOT NULL,
  `address` varchar(100) NOT NULL,
  `user_name` varchar(50) DEFAULT NULL,
  `password` varchar(50) DEFAULT NULL,
  `login_date` varchar(50) DEFAULT NULL,
  `login_time` varchar(50) DEFAULT NULL,
  `ip_address` varchar(50) DEFAULT NULL,
  `user_id` bigint(20) NOT NULL,
  `active_status` int(20) DEFAULT NULL,
  `stampdate` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `tbl_user_mstr`
--

INSERT INTO `tbl_user_mstr` (`id`, `user_type_id`, `dept_id`, `emp_id`, `name`, `phone`, `address`, `user_name`, `password`, `login_date`, `login_time`, `ip_address`, `user_id`, `active_status`, `stampdate`) VALUES
(1, 1, 0, 0, 'tausif', '8603715065', 'hgkhghh', 'admin', '1234', NULL, NULL, '::1', 1, 1, NULL),
(6, 2, 0, 1, '', '', '', 'EMP008', '123', NULL, NULL, '::1', 1, 1, NULL),
(7, 2, 0, 2, '', '', '', 'EMP009', '123', NULL, NULL, '::1', 1, 1, NULL);

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

--
-- Table structure for table `tbl_user_type`
--

CREATE TABLE IF NOT EXISTS `tbl_user_type` (
`id` bigint(20) NOT NULL,
  `user_type` varchar(30) DEFAULT NULL,
  `short_name` varchar(20) DEFAULT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `tbl_user_type`
--

INSERT INTO `tbl_user_type` (`id`, `user_type`, `short_name`) VALUES
(1, 'admin', NULL),
(2, 'employee', NULL),
(3, 'admin_', NULL);

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

--
-- Table structure for table `tbl_workorder_master`
--

CREATE TABLE IF NOT EXISTS `tbl_workorder_master` (
`id` bigint(20) NOT NULL,
  `workorder_no` varchar(255) NOT NULL,
  `workorder_detail` varchar(255) NOT NULL,
  `validity` date NOT NULL,
  `gst_no` varchar(255) NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `tbl_workorder_master`
--

INSERT INTO `tbl_workorder_master` (`id`, `workorder_no`, `workorder_detail`, `validity`, `gst_no`) VALUES
(1, '1234', 'workorder detail', '2018-04-05', 'io989');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `tbl_holiday_mstr`
--
ALTER TABLE `tbl_holiday_mstr`
 ADD PRIMARY KEY (`Id`);

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

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

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

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

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

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

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

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

--
-- Indexes for table `tbl_user_mstr`
--
ALTER TABLE `tbl_user_mstr`
 ADD PRIMARY KEY (`id`), ADD KEY `FK_tbl_user_type_` (`user_type_id`), ADD KEY `user_name` (`user_name`,`user_type_id`);

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `tbl_attendance_pass`
--
ALTER TABLE `tbl_attendance_pass`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `tbl_attendance_type`
--
ALTER TABLE `tbl_attendance_type`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `tbl_billing_term_detail`
--
ALTER TABLE `tbl_billing_term_detail`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT for table `tbl_billing_term_mstr`
--
ALTER TABLE `tbl_billing_term_mstr`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `tbl_department`
--
ALTER TABLE `tbl_department`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `tbl_designation`
--
ALTER TABLE `tbl_designation`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `tbl_emp_attendance`
--
ALTER TABLE `tbl_emp_attendance`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=21;
--
-- AUTO_INCREMENT for table `tbl_emp_desg_dept`
--
ALTER TABLE `tbl_emp_desg_dept`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `tbl_emp_identity`
--
ALTER TABLE `tbl_emp_identity`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `tbl_emp_master`
--
ALTER TABLE `tbl_emp_master`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `tbl_emp_qualification`
--
ALTER TABLE `tbl_emp_qualification`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `tbl_emp_skill`
--
ALTER TABLE `tbl_emp_skill`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `tbl_emp_work_exp`
--
ALTER TABLE `tbl_emp_work_exp`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `tbl_holiday_mstr`
--
ALTER TABLE `tbl_holiday_mstr`
MODIFY `Id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbl_identity_master`
--
ALTER TABLE `tbl_identity_master`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `tbl_leave_detail`
--
ALTER TABLE `tbl_leave_detail`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `tbl_leave_request`
--
ALTER TABLE `tbl_leave_request`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `tbl_leave_type`
--
ALTER TABLE `tbl_leave_type`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `tbl_loc_dtl`
--
ALTER TABLE `tbl_loc_dtl`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `tbl_menu_mtr`
--
ALTER TABLE `tbl_menu_mtr`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=20;
--
-- AUTO_INCREMENT for table `tbl_menu_permission`
--
ALTER TABLE `tbl_menu_permission`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=45;
--
-- AUTO_INCREMENT for table `tbl_profile_pic`
--
ALTER TABLE `tbl_profile_pic`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbl_user_mstr`
--
ALTER TABLE `tbl_user_mstr`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `tbl_user_type`
--
ALTER TABLE `tbl_user_type`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `tbl_workorder_master`
--
ALTER TABLE `tbl_workorder_master`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
/*!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 */;
