-- phpMyAdmin SQL Dump
-- version 3.2.0.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 16, 2017 at 02:12 PM
-- Server version: 5.1.36
-- PHP Version: 5.3.0

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!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: `arka_ims`
--

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

--
-- Table structure for table `arka_employee_master`
--

CREATE TABLE IF NOT EXISTS `arka_employee_master` (
  `sl_no` int(11) NOT NULL AUTO_INCREMENT,
  `company_name` varchar(50) NOT NULL,
  `company_code` varchar(50) NOT NULL,
  `salutation` varchar(6) NOT NULL,
  `emp_first_name` varchar(50) NOT NULL,
  `emp_last_name` varchar(50) NOT NULL,
  `emp_id` varchar(20) NOT NULL,
  `emp_type` varchar(25) NOT NULL,
  `d_o_b` date NOT NULL,
  `sex` varchar(7) NOT NULL,
  `designation` varchar(50) NOT NULL,
  `salary` double(11,2) NOT NULL,
  `department` varchar(50) NOT NULL,
  `mobile` varchar(13) NOT NULL,
  `mobile_1` varchar(13) NOT NULL,
  `mobile_2` varchar(13) NOT NULL,
  `personal_mail` varchar(50) NOT NULL,
  `company_mail` varchar(50) NOT NULL,
  `address1` varchar(255) NOT NULL,
  `address2` varchar(255) NOT NULL,
  `area` varchar(50) NOT NULL,
  `pincode` int(6) NOT NULL,
  `area_code` int(11) NOT NULL,
  `phone_no` int(11) NOT NULL,
  `extension` int(11) NOT NULL,
  `area_code1` int(11) NOT NULL,
  `phone1` int(11) NOT NULL,
  `extension1` int(11) NOT NULL,
  `joining_date` date NOT NULL,
  `father_name` varchar(50) NOT NULL,
  `mother_name` varchar(50) NOT NULL,
  `residence_mobile` int(15) NOT NULL,
  `no_of_year_exp` varchar(50) NOT NULL,
  `qualification` varchar(50) NOT NULL,
  `image` varchar(255) NOT NULL,
  `created_by` varchar(50) NOT NULL,
  `created_date` date NOT NULL,
  `created_time` time NOT NULL,
  `timestamp_value` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `remarks` longtext NOT NULL,
  `status` tinyint(1) NOT NULL,
  PRIMARY KEY (`sl_no`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `arka_employee_master`
--

INSERT INTO `arka_employee_master` (`sl_no`, `company_name`, `company_code`, `salutation`, `emp_first_name`, `emp_last_name`, `emp_id`, `emp_type`, `d_o_b`, `sex`, `designation`, `salary`, `department`, `mobile`, `mobile_1`, `mobile_2`, `personal_mail`, `company_mail`, `address1`, `address2`, `area`, `pincode`, `area_code`, `phone_no`, `extension`, `area_code1`, `phone1`, `extension1`, `joining_date`, `father_name`, `mother_name`, `residence_mobile`, `no_of_year_exp`, `qualification`, `image`, `created_by`, `created_date`, `created_time`, `timestamp_value`, `remarks`, `status`) VALUES
(1, 'Asian Engineering', '101', 'Mr', 'Ram', 'Arka', 'EMP1001', '', '2016-08-01', 'Male', 'Developer', 0.00, 'Sales', '8698678698', '', '', 'kjhlkhk@GMAIL.COM', 'ram@arkagroup.co.in', 'tfrytrfjhgfjf', 'hfgjfhgf', 'hgfhgfhjgf', 586575, 0, 0, 0, 0, 0, 0, '2009-08-07', 'Test data', 'Test Data', 2147483647, '10', 'MSC', '', 'suresh', '2016-08-02', '04:03:14', '2016-08-02 16:05:47', '', 1),
(2, 'ARKA AUTOMAATIONS LTD', '102', 'Mr', 'SIVARAJA', 'G', 'EMP1002', '', '1992-04-11', 'male', '', 0.00, '', '9884422461', '', '', 'sivaraja@arkagroup.co.in', '', 'ekkatuthangal', '', 'guindy', 600032, 0, 0, 0, 0, 0, 0, '2016-04-11', 'DURAI', 'THANGAM', 0, '15', 'PHD', '', 'suresh', '2017-04-11', '17:54:14', '2017-04-11 17:54:17', '', 1);
