-- http://www.phpmyadmin.net
--




--
-- Database: `inspire_it_solutions`
--
CREATE DATABASE IF NOT EXISTS `inspire_it_solutions` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `inspire_it_solutions`;

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

--
-- Table structure for table `android_version_kill_switch`
--

CREATE TABLE IF NOT EXISTS `android_version_kill_switch` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `avks_fVersionCode` float NOT NULL,
  `avks_iUpdatestatus` int(1) NOT NULL COMMENT '1-force update,2-soft update',
  `avks_dCreatedDate` datetime NOT NULL,
  `avks_dUpdatedDate` datetime NOT NULL,
  `del_i` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `android_version_kill_switch`
--

INSERT INTO `android_version_kill_switch` (`id`, `avks_fVersionCode`, `avks_iUpdatestatus`, `avks_dCreatedDate`, `avks_dUpdatedDate`, `del_i`) VALUES
(1, 1, 2, '2018-07-20 13:30:00', '2018-07-20 13:30:00', 0),
(2, 2, 1, '2018-07-20 14:52:49', '2018-07-21 15:22:02', 0),
(3, 3, 2, '2018-07-20 14:57:56', '2018-07-21 15:23:53', 0),
(4, 4, 2, '2018-07-20 14:59:16', '2018-07-20 14:59:32', 0),
(5, 5, 1, '2018-07-21 15:23:16', '2018-07-21 15:23:16', 1),
(6, 5, 1, '2018-07-21 15:26:31', '2018-07-21 15:26:31', 0);

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

--
-- Table structure for table `annual_service_booking_mst`
--

CREATE TABLE IF NOT EXISTS `annual_service_booking_mst` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `asbm_iSubscriptionId` int(10) NOT NULL,
  `asbm_iAssignId` int(10) NOT NULL,
  `asbm_vDescription` varchar(255) NOT NULL,
  `asbm_vStatus_id` int(5) NOT NULL,
  `asbm_tCreatedDate` datetime NOT NULL,
  `asbm_dUpdatedDate` datetime NOT NULL,
  `del_i` int(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `annual_service_booking_mst`
--

INSERT INTO `annual_service_booking_mst` (`id`, `asbm_iSubscriptionId`, `asbm_iAssignId`, `asbm_vDescription`, `asbm_vStatus_id`, `asbm_tCreatedDate`, `asbm_dUpdatedDate`, `del_i`) VALUES
(1, 1, 2, ' ', 1, '2018-07-20 19:31:13', '2018-07-20 19:31:13', 0),
(2, 1, 1, 'test', 5, '2018-07-20 19:32:00', '2018-07-20 20:28:51', 0),
(3, 2, 1, 'keyboard problem ', 1, '2018-07-21 12:57:16', '2018-07-21 12:57:16', 0),
(4, 2, 3, 'display problem ', 3, '2018-07-21 12:57:33', '2018-07-21 15:02:56', 0),
(5, 2, 2, 'OS Crashed', 3, '2018-07-21 12:59:05', '2018-07-21 14:31:22', 0);

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

--
-- Table structure for table `annual_service_mst`
--

CREATE TABLE IF NOT EXISTS `annual_service_mst` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `asm_vName` varchar(100) NOT NULL,
  `asm_dCreatedDate` datetime NOT NULL,
  `asm_dUpdatedDate` datetime NOT NULL,
  `del_i` int(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `annual_service_mst`
--

INSERT INTO `annual_service_mst` (`id`, `asm_vName`, `asm_dCreatedDate`, `asm_dUpdatedDate`, `del_i`) VALUES
(1, 'ALC', '2018-07-05 18:07:39', '2018-07-05 18:07:39', 0),
(2, 'AMC', '2018-07-05 18:07:58', '2018-07-05 18:07:58', 0);

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

--
-- Table structure for table `annual_service_subscription_master`
--

CREATE TABLE IF NOT EXISTS `annual_service_subscription_master` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `assm_iCustomerId` int(10) NOT NULL,
  `assm_iAnnualSeviceId` int(10) NOT NULL,
  `assm_iAnnualSeviceTypeId` int(10) NOT NULL,
  `assm_iValidityYears` int(10) NOT NULL,
  `assm_iAmount` int(10) NOT NULL,
  `assm_dStartDate` date NOT NULL,
  `assm_dEndDate` date NOT NULL,
  `assm_iQuantity` int(10) NOT NULL,
  `assm_iTotalPrice` int(10) NOT NULL,
  `assm_vDescription` text NOT NULL,
  `assm_vPdfFile` varchar(100) NOT NULL,
  `assm_dCreatedDate` datetime NOT NULL,
  `assm_dUpdatedDate` datetime NOT NULL,
  `del_i` int(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `annual_service_subscription_master`
--

INSERT INTO `annual_service_subscription_master` (`id`, `assm_iCustomerId`, `assm_iAnnualSeviceId`, `assm_iAnnualSeviceTypeId`, `assm_iValidityYears`, `assm_iAmount`, `assm_dStartDate`, `assm_dEndDate`, `assm_iQuantity`, `assm_iTotalPrice`, `assm_vDescription`, `assm_vPdfFile`, `assm_dCreatedDate`, `assm_dUpdatedDate`, `del_i`) VALUES
(1, 1, 1, 4, 1, 3000, '2018-07-14', '2018-07-14', 2, 6000, ' test', '', '2018-07-20 19:30:43', '2018-07-20 19:30:43', 0),
(2, 2, 2, 1, 2, 2200, '2018-07-27', '2019-07-27', 15, 33000, 'test ', '189964_77803_LoanApplicationForm.pdf', '2018-07-21 12:48:11', '2018-07-21 14:27:55', 0);

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

--
-- Table structure for table `annual_service_type_mst`
--

CREATE TABLE IF NOT EXISTS `annual_service_type_mst` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `astm_iAnnualSeviceId` int(10) NOT NULL,
  `astm_vServiceName` varchar(100) NOT NULL,
  `astm_iPrice` int(10) NOT NULL,
  `astm_vImage` varchar(100) NOT NULL,
  `astm_dCreatedDate` datetime NOT NULL,
  `astm_dUpdatedDate` datetime NOT NULL,
  `del_i` int(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `annual_service_type_mst`
--

INSERT INTO `annual_service_type_mst` (`id`, `astm_iAnnualSeviceId`, `astm_vServiceName`, `astm_iPrice`, `astm_vImage`, `astm_dCreatedDate`, `astm_dUpdatedDate`, `del_i`) VALUES
(1, 2, 'Laptop', 1100, '5b526b24f0e9f5b6e9674d1458a444895471.png', '2018-07-20 18:07:47', '2018-07-20 18:24:34', 0),
(2, 2, 'Printers', 600, 'a7c1a9a3c48e3b88d80e4a882382f461842.png', '2018-07-20 18:25:03', '2018-07-20 18:25:03', 0),
(3, 2, 'Desktop', 1000, '96ce76fcc4dda1d3db2a8cf1eaf5e787823.png', '2018-07-20 18:25:30', '2018-07-20 19:15:49', 0),
(4, 1, 'OS installation', 3000, 'e994e292e17c80cb4f62d57d6e36f3411434.png', '2018-07-20 18:27:59', '2018-07-20 18:29:56', 0),
(5, 1, 'Hardware', 10000, '35d288b7befaa1aa81d036f63018206f2005.png', '2018-07-20 18:30:30', '2018-07-20 18:30:30', 0);

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

--
-- Table structure for table `app_user_details`
--

CREATE TABLE IF NOT EXISTS `app_user_details` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `aud_vDeviceId` varchar(200) NOT NULL,
  `aud_vOs_type` varchar(100) NOT NULL,
  `aud_vOs_version` varchar(100) NOT NULL,
  `aud_vFcmId` varchar(700) NOT NULL,
  `aud_iUserId` int(10) NOT NULL,
  `aud_tCreateddate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `aud_dUpdatedDate` datetime NOT NULL,
  `del_i` int(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `app_user_details`
--

INSERT INTO `app_user_details` (`id`, `aud_vDeviceId`, `aud_vOs_type`, `aud_vOs_version`, `aud_vFcmId`, `aud_iUserId`, `aud_tCreateddate`, `aud_dUpdatedDate`, `del_i`) VALUES
(1, 'd1f4e17053d3c20b', '', '', 'dZ5HhHCAZ2Y:APA91bEJmIiWG9c6XfGnnegNR8rXhHXx6-MCDUVYoc-s-rwW5PZrycKCaRLeuoHpVye-4tIsIBNLkopimbdTL8SBbq7JdhgSFk1I3Ry1uvxFB1Kgp9YD1QiY0iTKYDHdzjLLjY7Bah9U', 0, '2018-07-20 13:01:29', '2018-07-20 18:31:29', 0);

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

--
-- Table structure for table `area`
--

CREATE TABLE IF NOT EXISTS `area` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `a_vDescription` varchar(100) NOT NULL,
  `a_tCreatedDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `a_dUpdatedDate` datetime NOT NULL,
  `del_i` int(4) NOT NULL,
  `visible` int(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=302 ;

--
-- Dumping data for table `area`
--

INSERT INTO `area` (`id`, `a_vDescription`, `a_tCreatedDate`, `a_dUpdatedDate`, `del_i`, `visible`) VALUES
(1, 'Adambakkam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(2, 'Adyar', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(3, 'Alandur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(4, 'Alwarpet', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(5, 'Alwarthirunagar', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(6, 'Ambattur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(7, 'Aminjikarai', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(8, 'Anakaputhur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(9, 'Anna Nagar', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(10, 'Annanur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(11, 'Arumbakkam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(12, 'Ashok Nagar', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(13, 'Avadi', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(14, 'Ayanavaram', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(15, 'Besant Nagar', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(16, 'Basin Bridge', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(17, 'Chepauk', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(18, 'Chetput', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(19, 'Chintadripet', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(20, 'Chitlapakkam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(21, 'Choolai', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(22, 'Choolaimedu', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(23, 'Chrompet', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(24, 'Egmore', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(25, 'Ekkaduthangal', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(26, 'Ennore', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(27, 'Foreshore Estate', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(28, 'Fort St. George', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(29, 'George Town', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(30, 'Gopalapuram', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(31, 'Government Estate', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(32, 'Guindy', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(33, 'IIT Madras', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(34, 'Injambakkam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(35, 'ICF', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(36, 'Iyyapanthangal', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(37, 'Jafferkhanpet', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(38, 'Karapakkam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(39, 'Kattivakkam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(40, 'Kazhipattur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(41, 'K.K. Nagar', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(42, 'Keelkattalai', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(43, 'Kelambakkam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(44, 'Kilpauk', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(45, 'Kodambakkam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(46, 'Kodungaiyur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(47, 'Kolathur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(48, 'Korattur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(49, 'Korukkupet', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(50, 'Kottivakkam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(51, 'Kotturpuram', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(52, 'Kottur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(53, 'Kovalam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(54, 'Kovilambakkam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(55, 'Koyambedu', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(56, 'Kundrathur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(57, 'Madhavaram', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(58, 'Madhavaram Milk Colony', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(59, 'Madipakkam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(60, 'Madambakkam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(61, 'Maduravoyal', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(62, 'Manali', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(63, 'Manali New Town', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(64, 'Manapakkam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(65, 'Mandaveli', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(66, 'Mangadu', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(67, 'Mannadi', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(68, 'Mathur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(69, 'Medavakkam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(70, 'Meenambakkam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(71, 'Minjur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(72, 'Mogappair', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(73, 'MKB Nagar', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(74, 'Mount Road', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(75, 'Moolakadai', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(76, 'Moulivakkam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(77, 'Mugalivakkam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(78, 'Mudichur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(79, 'Mylapore', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(80, 'Nandanam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(81, 'Nanganallur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(82, 'Navalur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(83, 'Neelankarai', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(84, 'Nemilichery', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(85, 'Nesapakkam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(86, 'Nolambur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(87, 'Noombal', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(88, 'Nungambakkam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(89, 'Ottery', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(90, 'Padi', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(91, 'Pakkam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(92, 'Palavakkam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(93, 'Pallavaram', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(94, 'Pallikaranai', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(95, 'Pammal', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(96, 'Park Town', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(97, 'Parry''s Corner', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(98, 'Pattabiram', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(99, 'Pattaravakkam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(100, 'Pazhavanthangal', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(101, 'Peerkankaranai', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(102, 'Perambur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(103, 'Peravallur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(104, 'Perumbakkam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(105, 'Perungalathur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(106, 'Perungudi', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(107, 'Pozhichalur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(108, 'Poonamallee', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(109, 'Porur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(110, 'Pudupet', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(111, 'Purasaiwalkam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(112, 'Puthagaram', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(113, 'Puzhal', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(114, 'Puzhuthivakkam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(115, 'Raj Bhavan', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(116, 'Ramavaram', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(117, 'Red Hills', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(118, 'Royapettah', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(119, 'Royapuram', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(120, 'Saidapet', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(121, 'Saligramam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(122, 'Santhome', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(123, 'Sembakkam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(124, 'Selaiyur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(125, 'Shenoy Nagar', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(126, 'Sholavaram', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(127, 'Sholinganallur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(128, 'Sithalapakkam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(129, 'Sowcarpet', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(130, 'St.Thomas Mount', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(131, 'Tambaram', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(132, 'Teynampet', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(133, 'Tharamani', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(134, 'T. Nagar', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(135, 'Thirumangalam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(136, 'Thirumullaivoyal', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(137, 'Thiruneermalai', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(138, 'Thiruninravur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(139, 'Thiruvanmiyur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(140, 'Tiruverkadu', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(141, 'Thiruvotriyur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(142, 'Tirusulam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(143, 'Tiruvallikeni', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(144, 'Tondiarpet', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(145, 'United India Colony', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(146, 'Vandalur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(147, 'Vadapalani', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(148, 'Valasaravakkam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(149, 'Vallalar Nagar', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(150, 'Vanagaram', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(151, 'Velachery', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(152, 'Villivakkam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(153, 'Virugambakkam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(154, 'Vyasarpadi', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(155, 'Washermanpet', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(156, 'West Mambalam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(157, 'Peelamedu', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(158, 'Thudiyalur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(159, 'Ondipudur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(160, 'Vedapatti', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(161, 'Mettupalayam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(162, 'Vadavalli', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(163, 'Saravanampatti', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(164, 'Kovaipudur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(165, 'Thudiyalur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(166, 'Pollachi', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(167, 'Sulur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(168, 'Singanallur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(169, 'Kinathukadavu', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(170, 'Periyanaickenpalayam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(171, 'Malumichampatti', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(172, 'Kovilpalayam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(173, 'Alandurai', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(174, 'Aliyar Nagar', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(175, 'Amaravathi Nagar', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(176, 'Ambarampalayam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(177, 'Anamalai', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(178, 'Angalakurichi', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(179, 'Anuparpalayam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(180, 'Chettipalayam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(181, 'Chikkarasampalayam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(182, 'Chinna Negamam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(183, 'Coimbatore Aerodrome', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(184, 'Coimbatore Central Bus Station', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(185, 'Coimbatore Collectorate', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(186, 'Coimbatore Courts', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(187, 'Coimbatore Industrial Estate', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(188, 'Coimbatore North', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(189, 'Coimbatore R.S. (Railway Station)', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(190, 'Coimbatore Race Course', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(191, 'Commercial Tax Office', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(192, 'Devangapet', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(193, 'Devanur Pudur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(194, 'Eripalayam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(195, 'Ganapathy', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(196, 'Gandhi Market', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(197, 'Gandhi Nagar-Coimbatore', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(198, 'Jallipatti', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(199, 'Gnanambika Mills', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(200, 'Muthugoundenpudur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(201, 'N G M College', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(202, 'Ukadam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(203, 'Nanda Nagar', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(204, 'Jothipuram', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(205, 'Kadamparai Dam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(206, 'Kaniyur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(207, 'Karamadai', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(208, 'Katoor MTP', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(209, 'Kinathukadavu', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(210, 'Kovaipudur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(211, 'Kovilpalayam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(212, 'Krishnaswamy Nagar', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(213, 'Kunniyamuthur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(214, 'Kurichikottai', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(215, 'Kurudampalayam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(216, 'Lawley Road', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(217, 'Madathukulam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(218, 'Mahadevapuram', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(219, 'Mahalingapuram', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(220, 'Malayandipattinam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(221, 'Marapettai', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(222, 'Maruthamalai', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(223, 'Mettupalayam East', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(224, 'Vaiyampalayam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(225, 'Valliamkadu', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(226, 'Nanjundapuram', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(227, 'Narasimhanaickenpalyam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(228, 'Neelikonampalayam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(229, 'Negamam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(230, 'NGGO Colony', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(231, 'Ondipudur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(232, 'Othakalmandapam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(233, 'Pannimade', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(234, 'Pappanaicken Pudur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(235, 'Pappanaickenpalayam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(236, 'Pappanaickenpalayam West', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(237, 'Peelamedu', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(238, 'Peelamedu East', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(239, 'Perianaickenpalayam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(240, 'Pollachi', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(241, 'Pollachi Bazaar', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(242, 'Pulankinar', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(243, 'Puliyakulam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(244, 'Ram Nagar-Coimbatore', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(245, 'Ramanamudalipudur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(246, 'Ramanathapuram', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(247, 'Ranganatha Puram', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(248, 'Ratnapuri', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(249, 'Redfields', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(250, 'Saibaba Mission', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(251, 'Sarcarsamakulam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(252, 'Government College Of Technology', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(253, 'Gomangalam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(254, 'Gudimangalam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(255, 'Irugur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(256, 'Iyerpadi', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(257, 'Sethurmadai', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(258, 'Sholayar', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(259, 'Sidhapudur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(260, 'Singanallur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(261, 'Sulur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(262, 'Somandurai', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(263, 'Sowripalayam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(264, 'Sri Ramakrishna Vidyalaya', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(265, 'Sukravar Pettai', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(266, 'Sundaraperumalkoil', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(267, 'T. Kottampatti', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(268, 'Tadiyalur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(269, 'Tatabad East', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(270, 'Tatabad', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(271, 'Telungupalayam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(272, 'Thadagam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(273, 'Thekkampatti', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(274, 'Thondamuthur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(275, 'Udumalpet Bazar', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(276, 'Udumalaipettai', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(277, 'Uppilipalayam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(278, 'Zamin Muthur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(279, 'Waterfalls Estate', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(280, 'Vettaikaranpudur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(281, 'Vellalore C.B.E', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(282, 'Velandipalayam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(283, 'Valparai', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(284, 'Venkatesa Oil Mills', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(285, 'Valavadi', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(286, 'Vadasithur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(287, 'Uthukuli Zamin', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(288, 'Chinniampalayam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(289, 'Neelambur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(290, 'Pillur Dam', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(291, 'Selvapuram', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(292, 'Sirukundra', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(293, 'Thirumurthinagar', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(294, 'Coimbatore Bazar', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(295, 'Coimbatore Central', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(296, 'Karamalai Bazar', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(297, 'Kavundampalyam Colony', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(298, 'Kuppakonanpudur', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(299, 'Madukkarai', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(300, 'Madukkarai Kasba', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1),
(301, 'Mettupalayam Bazaar', '2018-04-13 04:53:32', '0000-00-00 00:00:00', 0, 1);

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

--
-- Table structure for table `brand_mst`
--

CREATE TABLE IF NOT EXISTS `brand_mst` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `bm_vBrandName` varchar(100) NOT NULL,
  `bm_tCreatedDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `bm_dUpdatedDate` datetime NOT NULL,
  `del_i` int(4) NOT NULL,
  `visible` int(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `brand_mst`
--

INSERT INTO `brand_mst` (`id`, `bm_vBrandName`, `bm_tCreatedDate`, `bm_dUpdatedDate`, `del_i`, `visible`) VALUES
(1, 'Acer', '2018-07-20 13:47:14', '2018-07-20 19:17:14', 0, 1),
(2, 'Hp', '2018-07-20 13:47:23', '2018-07-20 19:17:23', 0, 1),
(3, 'Lenovo', '2018-07-20 13:47:29', '2018-07-20 19:17:29', 0, 1),
(4, 'Dell', '2018-07-21 06:19:00', '2018-07-21 11:49:00', 0, 1),
(5, 'Samsung', '2018-07-21 06:19:12', '2018-07-21 11:49:12', 0, 1),
(6, 'Apple', '2018-07-21 06:19:19', '2018-07-21 11:49:19', 0, 1),
(7, 'Wipro', '2018-07-21 06:19:44', '2018-07-21 11:49:44', 0, 1),
(8, 'HCL', '2018-07-21 06:20:14', '2018-07-21 11:50:14', 0, 1);

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

--
-- Table structure for table `category_mst`
--

CREATE TABLE IF NOT EXISTS `category_mst` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `cm_vCategoryName` varchar(100) NOT NULL,
  `cm_tCreatedDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `cm_dUpdatedDate` datetime NOT NULL,
  `del_i` int(4) NOT NULL,
  `visible` int(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `category_mst`
--

INSERT INTO `category_mst` (`id`, `cm_vCategoryName`, `cm_tCreatedDate`, `cm_dUpdatedDate`, `del_i`, `visible`) VALUES
(1, 'Hardware', '2018-07-20 13:46:20', '2018-07-20 19:16:54', 0, 1),
(2, 'Software', '2018-07-20 13:46:38', '2018-07-20 19:16:38', 0, 1),
(3, 'Maintainance', '2018-07-21 06:18:34', '2018-07-21 11:48:34', 0, 1);

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

--
-- Table structure for table `customer_mst`
--

CREATE TABLE IF NOT EXISTS `customer_mst` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `cm_vCustomerName` varchar(100) NOT NULL,
  `cm_vEmailId` varchar(100) NOT NULL,
  `cm_vMobileNo` varchar(20) NOT NULL,
  `cm_vAddress` varchar(100) NOT NULL,
  `cm_iAreaId` int(10) NOT NULL,
  `cm_dCreatedDate` datetime NOT NULL,
  `cm_dUpdatedDate` datetime NOT NULL,
  `del_i` int(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `customer_mst`
--

INSERT INTO `customer_mst` (`id`, `cm_vCustomerName`, `cm_vEmailId`, `cm_vMobileNo`, `cm_vAddress`, `cm_iAreaId`, `cm_dCreatedDate`, `cm_dUpdatedDate`, `del_i`) VALUES
(1, 'santhana', 'santhana.creatah@gmail.com', '9994989441', 'chennai', 151, '2018-07-20 19:21:08', '2018-07-20 19:21:08', 0),
(2, 'ragu', 'raguk2020@gmail.com', '8438102466', 'housing  board', 13, '2018-07-21 12:18:15', '2018-07-21 14:20:32', 0),
(3, 'Sahul', 'sahul@gmail.com', '9442645220', 'housing board, avadi ', 13, '2018-07-21 14:20:10', '2018-07-21 14:20:10', 0);

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

--
-- Table structure for table `customer_service_mst`
--

CREATE TABLE IF NOT EXISTS `customer_service_mst` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `cm_iUserId` int(10) NOT NULL,
  `cm_iServiceId` int(10) NOT NULL,
  `cm_iServiceTypeId` int(10) NOT NULL,
  `cm_vBrand` varchar(50) NOT NULL,
  `cm_vModel` varchar(50) NOT NULL,
  `cm_vSerialNo` varchar(50) NOT NULL,
  `cm_vDescription` varchar(255) NOT NULL,
  `cm_dPreferredDateTime` datetime NOT NULL,
  `cm_vEnagementType` varchar(50) NOT NULL,
  `cm_tCreatedDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `cm_dUpdatedDate` datetime NOT NULL,
  `del_i` int(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

--
-- Dumping data for table `customer_service_mst`
--

INSERT INTO `customer_service_mst` (`id`, `cm_iUserId`, `cm_iServiceId`, `cm_iServiceTypeId`, `cm_vBrand`, `cm_vModel`, `cm_vSerialNo`, `cm_vDescription`, `cm_dPreferredDateTime`, `cm_vEnagementType`, `cm_tCreatedDate`, `cm_dUpdatedDate`, `del_i`) VALUES
(2, 2, 3, 6, 'hp', 's5', '69573323193491', 'touch problem', '2018-07-24 09:45:00', 'Instore Appt', '2018-07-21 07:26:11', '2018-07-21 12:56:11', 0),
(3, 2, 2, 1, 'acer', '123', '0', 'test', '2018-07-22 10:40:00', 'Onsite/Door Step', '2018-07-21 07:45:56', '2018-07-21 13:15:56', 0),
(4, 2, 2, 1, 'acer', '123', '0', 'test', '2018-07-22 10:40:00', 'Onsite/Door Step', '2018-07-21 07:45:56', '2018-07-21 13:15:56', 0),
(5, 2, 2, 1, 'acer', '123', '0', 'test', '2018-07-22 10:40:00', 'Onsite/Door Step', '2018-07-21 07:45:59', '2018-07-21 13:15:59', 0);

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

--
-- Table structure for table `employee_app_details`
--

CREATE TABLE IF NOT EXISTS `employee_app_details` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `ead_vDeviceId` varchar(200) NOT NULL,
  `ead_vOs_type` varchar(100) NOT NULL,
  `ead_vOs_version` varchar(100) NOT NULL,
  `ead_vFcmId` varchar(200) NOT NULL,
  `ead_iEmployeeId` int(10) NOT NULL,
  `ead_tCreateddate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `ead_dUpdatedDate` datetime NOT NULL,
  `del_i` int(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `employee_app_details`
--

INSERT INTO `employee_app_details` (`id`, `ead_vDeviceId`, `ead_vOs_type`, `ead_vOs_version`, `ead_vFcmId`, `ead_iEmployeeId`, `ead_tCreateddate`, `ead_dUpdatedDate`, `del_i`) VALUES
(1, 'd1f4e17053d3c20b', '', '', 'fm4vhwEWoaE:APA91bGHw2ORTLNb8nxyIaEOdIdawAfv7m6Gkww5ShqSrezgTmF4H-TPzRSTeXwcfv7G4cmQgzZz_pZlV4rpt5GMTreNt_dSvcUbTVWW-et5Bw2nIBxUb-wFhC5aE02yDlIHOdW02goR', 0, '2018-07-20 13:49:12', '2018-07-20 19:19:12', 0),
(2, 'f3bf8b1e8bb2a985', '', '', 'fJ1QAe-AgCw:APA91bF1aXJ4-YXrFbTNKnREwicUKJBKBAVwBNpy-LUguLdllBkiGy-XxXLmthy75dlXjtkrA9XpP2t8DMjlKzxrlObyRKQfwaVIkDUMsXBhYDS37YSuYPv-7kJqzZX5jSAEO1alEIbp', 0, '2018-07-20 12:34:54', '2018-07-20 18:04:54', 0),
(3, '334a0d38fb7ae835', '', '', 'fwtK8wZDlFU:APA91bFs0pQGjuC39ieBOq0EtaC-KsjTlRpKmnW4TF1Jq5e4oFl-eZsLbrxA2U--H2lBFB72WYVCWafZfU0tIhbeC2u2CWQgGJM6ckTSF2CkRialXv0iuATqGy9bjtG4j-ZHKW-5cVL8', 0, '2018-07-21 09:09:22', '2018-07-21 14:39:22', 0);

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

--
-- Table structure for table `employee_location`
--

CREATE TABLE IF NOT EXISTS `employee_location` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `el_iEmpId` int(11) NOT NULL,
  `el_dLatitude` double NOT NULL,
  `el_dLongitude` double NOT NULL,
  `el_dDate` date NOT NULL,
  `el_Time` time NOT NULL,
  `el_CreatedDate` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP,
  `del_i` int(5) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=64 ;

--
-- Dumping data for table `employee_location`
--

INSERT INTO `employee_location` (`id`, `el_iEmpId`, `el_dLatitude`, `el_dLongitude`, `el_dDate`, `el_Time`, `el_CreatedDate`, `del_i`) VALUES
(1, 3, 13.09708, 80.2537731, '2018-07-21', '14:40:09', '2018-07-21 14:40:09', 0),
(2, 3, 13.09708, 80.2537731, '2018-07-21', '14:40:18', '2018-07-21 14:40:23', 0),
(3, 3, 13.09708, 80.2537731, '2018-07-21', '14:40:29', '2018-07-21 14:40:34', 0),
(4, 3, 13.09708, 80.2537731, '2018-07-21', '14:40:40', '2018-07-21 14:40:45', 0),
(5, 3, 13.09708, 80.2537731, '2018-07-21', '14:40:50', '2018-07-21 14:40:55', 0),
(6, 3, 13.09708, 80.2537731, '2018-07-21', '14:41:00', '2018-07-21 14:41:05', 0),
(7, 3, 13.09708, 80.2537731, '2018-07-21', '14:41:10', '2018-07-21 14:41:15', 0),
(8, 3, 13.09708, 80.2537731, '2018-07-21', '14:41:20', '2018-07-21 14:41:25', 0),
(9, 3, 13.09708, 80.2537731, '2018-07-21', '14:41:46', '2018-07-21 14:41:51', 0),
(10, 3, 13.09708, 80.2537731, '2018-07-21', '14:42:06', '2018-07-21 14:42:11', 0),
(11, 3, 13.09708, 80.2537731, '2018-07-21', '14:42:18', '2018-07-21 14:42:18', 0),
(12, 3, 13.09708, 80.2537731, '2018-07-21', '14:42:27', '2018-07-21 14:42:32', 0),
(13, 3, 13.09708, 80.2537731, '2018-07-21', '14:42:38', '2018-07-21 14:42:43', 0),
(14, 3, 13.09708, 80.2537731, '2018-07-21', '14:42:49', '2018-07-21 14:42:49', 0),
(15, 3, 13.09708, 80.2537731, '2018-07-21', '14:42:59', '2018-07-21 14:42:59', 0),
(16, 3, 13.09708, 80.2537731, '2018-07-21', '14:43:08', '2018-07-21 14:43:09', 0),
(17, 3, 13.0971954, 80.2539171, '2018-07-21', '14:43:18', '2018-07-21 14:43:24', 0),
(18, 3, 13.09708, 80.2537731, '2018-07-21', '14:43:38', '2018-07-21 14:43:43', 0),
(19, 3, 13.09708, 80.2537731, '2018-07-21', '14:43:48', '2018-07-21 14:43:53', 0),
(20, 3, 13.09708, 80.2537731, '2018-07-21', '14:43:58', '2018-07-21 14:44:03', 0),
(21, 3, 13.09708, 80.2537731, '2018-07-21', '14:44:08', '2018-07-21 14:44:13', 0),
(22, 3, 13.09708, 80.2537731, '2018-07-21', '14:44:17', '2018-07-21 14:44:18', 0),
(23, 3, 13.09708, 80.2537731, '2018-07-21', '14:44:54', '2018-07-21 14:45:00', 0),
(24, 3, 13.09708, 80.2537731, '2018-07-21', '14:46:48', '2018-07-21 14:46:53', 0),
(25, 3, 13.09708, 80.2537731, '2018-07-21', '14:48:26', '2018-07-21 14:48:31', 0),
(26, 3, 13.09708, 80.2537731, '2018-07-21', '14:48:46', '2018-07-21 14:48:51', 0),
(27, 3, 13.09708, 80.2537731, '2018-07-21', '14:48:56', '2018-07-21 14:49:01', 0),
(28, 3, 13.09708, 80.2537731, '2018-07-21', '14:49:06', '2018-07-21 14:49:11', 0),
(29, 3, 13.09708, 80.2537731, '2018-07-21', '14:49:17', '2018-07-21 14:49:22', 0),
(30, 3, 13.09708, 80.2537731, '2018-07-21', '14:49:27', '2018-07-21 14:49:32', 0),
(31, 3, 13.09708, 80.2537731, '2018-07-21', '14:49:37', '2018-07-21 14:49:42', 0),
(32, 3, 13.0977018, 80.2535638, '2018-07-21', '14:49:47', '2018-07-21 14:49:52', 0),
(33, 3, 13.09708, 80.2537731, '2018-07-21', '14:49:57', '2018-07-21 14:50:02', 0),
(34, 3, 13.09708, 80.2537731, '2018-07-21', '14:50:08', '2018-07-21 14:50:13', 0),
(35, 3, 13.09708, 80.2537731, '2018-07-21', '14:51:57', '2018-07-21 14:52:03', 0),
(36, 3, 13.09708, 80.2537731, '2018-07-21', '14:52:29', '2018-07-21 14:52:35', 0),
(37, 3, 13.09708, 80.2537731, '2018-07-21', '14:52:34', '2018-07-21 14:52:39', 0),
(38, 3, 13.09708, 80.2537731, '2018-07-21', '14:52:44', '2018-07-21 14:52:49', 0),
(39, 3, 13.09708, 80.2537731, '2018-07-21', '14:52:54', '2018-07-21 14:52:59', 0),
(40, 3, 13.09708, 80.2537731, '2018-07-21', '14:53:05', '2018-07-21 14:53:10', 0),
(41, 3, 13.0977018, 80.2535638, '2018-07-21', '14:53:15', '2018-07-21 14:53:20', 0),
(42, 3, 13.09708, 80.2537731, '2018-07-21', '14:53:26', '2018-07-21 14:53:31', 0),
(43, 3, 13.09708, 80.2537731, '2018-07-21', '14:53:39', '2018-07-21 14:53:44', 0),
(44, 3, 13.09708, 80.2537731, '2018-07-21', '14:53:49', '2018-07-21 14:53:54', 0),
(45, 3, 13.09708, 80.2537731, '2018-07-21', '14:53:59', '2018-07-21 14:54:04', 0),
(46, 3, 13.09708, 80.2537731, '2018-07-21', '14:54:11', '2018-07-21 14:54:16', 0),
(47, 3, 13.09708, 80.2537731, '2018-07-21', '14:54:20', '2018-07-21 14:54:21', 0),
(48, 3, 13.0977018, 80.2535638, '2018-07-21', '14:54:30', '2018-07-21 14:54:35', 0),
(49, 3, 13.09708, 80.2537731, '2018-07-21', '14:54:41', '2018-07-21 14:54:46', 0),
(50, 3, 13.09708, 80.2537731, '2018-07-21', '14:54:51', '2018-07-21 14:54:56', 0),
(51, 3, 13.09708, 80.2537731, '2018-07-21', '14:55:04', '2018-07-21 14:55:10', 0),
(52, 3, 13.0971901, 80.2538816, '2018-07-21', '14:55:29', '2018-07-21 14:55:34', 0),
(53, 3, 13.09708, 80.2537731, '2018-07-21', '14:55:50', '2018-07-21 14:55:55', 0),
(54, 3, 13.09708, 80.2537731, '2018-07-21', '14:56:00', '2018-07-21 14:56:00', 0),
(55, 3, 13.09708, 80.2537731, '2018-07-21', '14:56:11', '2018-07-21 14:56:16', 0),
(56, 3, 13.09708, 80.2537731, '2018-07-21', '14:56:21', '2018-07-21 14:56:26', 0),
(57, 3, 13.09708, 80.2537731, '2018-07-21', '14:56:31', '2018-07-21 14:56:36', 0),
(58, 3, 13.09708, 80.2537731, '2018-07-21', '14:56:42', '2018-07-21 14:56:47', 0),
(59, 3, 13.09708, 80.2537731, '2018-07-21', '14:56:52', '2018-07-21 14:56:57', 0),
(60, 3, 13.09708, 80.2537731, '2018-07-21', '14:57:02', '2018-07-21 14:57:07', 0),
(61, 3, 13.09708, 80.2537731, '2018-07-21', '14:57:13', '2018-07-21 14:57:18', 0),
(62, 3, 13.09708, 80.2537731, '2018-07-21', '14:57:23', '2018-07-21 14:57:28', 0),
(63, 3, 13.09708, 80.2537731, '2018-07-21', '14:57:33', '2018-07-21 14:57:38', 0);

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

--
-- Table structure for table `employee_menu_items`
--

CREATE TABLE IF NOT EXISTS `employee_menu_items` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `emt_iEmployeeId` int(10) NOT NULL,
  `emt_iMenuId` int(10) NOT NULL,
  `emt_dCreatedDate` datetime NOT NULL,
  `emt_dUpdatedDate` datetime NOT NULL,
  `del_i` int(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

--
-- Dumping data for table `employee_menu_items`
--

INSERT INTO `employee_menu_items` (`id`, `emt_iEmployeeId`, `emt_iMenuId`, `emt_dCreatedDate`, `emt_dUpdatedDate`, `del_i`) VALUES
(1, 1, 1, '2018-07-20 19:14:51', '2018-07-20 19:14:51', 0),
(2, 1, 2, '2018-07-20 19:14:51', '2018-07-20 19:14:51', 0),
(3, 1, 3, '2018-07-20 19:14:51', '2018-07-20 19:14:51', 0),
(4, 1, 5, '2018-07-20 19:14:51', '2018-07-20 19:14:51', 0),
(5, 1, 8, '2018-07-20 19:14:51', '2018-07-20 19:14:51', 0),
(6, 2, 1, '2018-07-21 11:53:39', '2018-07-21 11:53:39', 0),
(7, 2, 2, '2018-07-21 11:53:39', '2018-07-21 11:53:39', 0),
(8, 2, 3, '2018-07-21 11:53:39', '2018-07-21 11:53:39', 0),
(9, 2, 5, '2018-07-21 11:53:39', '2018-07-21 11:53:39', 0),
(10, 3, 1, '2018-07-21 11:56:13', '2018-07-21 11:56:13', 0),
(11, 3, 2, '2018-07-21 11:56:13', '2018-07-21 11:56:13', 0),
(12, 3, 3, '2018-07-21 11:56:13', '2018-07-21 11:56:13', 0),
(13, 3, 5, '2018-07-21 11:56:13', '2018-07-21 11:56:13', 0);

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

--
-- Table structure for table `enquiry_mst`
--

CREATE TABLE IF NOT EXISTS `enquiry_mst` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `em_vType` varchar(20) NOT NULL,
  `em_iCustomerId` int(10) NOT NULL,
  `em_iProductId` int(10) NOT NULL,
  `em_iCategoryId` int(10) NOT NULL,
  `em_iServiceId` int(11) NOT NULL,
  `em_vDescription` varchar(200) NOT NULL,
  `em_iCount` int(11) NOT NULL,
  `em_iStatus` int(4) NOT NULL COMMENT '0-Open,1-Closed',
  `em_tCreatedDate` datetime NOT NULL,
  `em_dUpdatedDate` datetime NOT NULL,
  `del_i` int(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

--
-- Dumping data for table `enquiry_mst`
--

INSERT INTO `enquiry_mst` (`id`, `em_vType`, `em_iCustomerId`, `em_iProductId`, `em_iCategoryId`, `em_iServiceId`, `em_vDescription`, `em_iCount`, `em_iStatus`, `em_tCreatedDate`, `em_dUpdatedDate`, `del_i`) VALUES
(1, 'service_support', 1, 0, 1, 0, 'test', 5, 0, '2018-07-20 19:31:27', '2018-07-20 19:31:27', 0),
(2, 'product', 2, 9, 0, 0, 'I want that product ', 0, 0, '2018-07-21 12:24:14', '2018-07-21 12:24:14', 0),
(3, 'product', 2, 5, 0, 0, 'what is this ', 0, 0, '2018-07-21 12:25:29', '2018-07-21 12:25:29', 0),
(4, 'product', 2, 7, 0, 0, 'omg', 0, 1, '2018-07-21 12:25:56', '2018-07-21 12:25:56', 0),
(5, 'general', 2, 0, 1, 0, 'urgent ', 0, 0, '2018-07-21 12:29:00', '2018-07-21 12:29:00', 0),
(6, 'service_support', 2, 0, 1, 2, 'maintain', 10, 0, '2018-07-21 12:30:38', '2018-07-21 12:30:38', 0),
(7, 'service_support', 2, 0, 1, 3, 'maintaining ', 25, 0, '2018-07-21 12:31:22', '2018-07-21 12:31:22', 0),
(8, 'general', 2, 0, 2, 0, 'antivirus ', 0, 0, '2018-07-21 12:32:10', '2018-07-21 12:32:10', 0),
(9, 'general', 2, 0, 1, 0, 'monitor', 0, 0, '2018-07-21 12:32:58', '2018-07-21 12:32:58', 0);

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

--
-- Table structure for table `ios_version_kill_switch`
--

CREATE TABLE IF NOT EXISTS `ios_version_kill_switch` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `ivks_fVersionCode` float NOT NULL,
  `ivks_iUpdatestatus` int(3) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `logger`
--

CREATE TABLE IF NOT EXISTS `logger` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` text NOT NULL,
  `ip` text NOT NULL,
  `message` text NOT NULL,
  `type` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;



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

--
-- Table structure for table `menu_mst`
--

CREATE TABLE IF NOT EXISTS `menu_mst` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `mm_vMenuName` varchar(100) NOT NULL,
  `mm_vLink` varchar(100) NOT NULL,
  `mm_vImage` varchar(100) NOT NULL,
  `mm_dCreatedDate` datetime NOT NULL,
  `mm_dUpdatedDate` datetime NOT NULL,
  `del_i` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

--
-- Dumping data for table `menu_mst`
--

INSERT INTO `menu_mst` (`id`, `mm_vMenuName`, `mm_vLink`, `mm_vImage`, `mm_dCreatedDate`, `mm_dUpdatedDate`, `del_i`) VALUES
(1, 'Service Booking', 'customer_service.php', 'dealer.png', '2018-06-21 00:00:00', '2018-06-21 00:00:00', 0),
(2, 'App Booking', 'user_booking_list.php', 'support.png', '2018-06-21 00:00:00', '2018-06-21 00:00:00', 0),
(3, 'Annual Service Booking', 'annual_service_booking.php', 'annual.png', '2018-06-21 00:00:00', '2018-06-21 00:00:00', 0),
(5, 'Enquiry', '', 'enquiry.png', '2018-06-21 00:00:00', '2018-06-21 00:00:00', 0),
(6, 'Master', '', 'master1.png', '2018-06-21 00:00:00', '2018-06-21 00:00:00', 0),
(7, 'Mobile App(CMS)', '', 'mobileapp.png', '2018-06-21 00:00:00', '2018-06-21 00:00:00', 0),
(8, 'Customers', 'customer.php', 'customer.png', '2018-06-21 00:00:00', '2018-06-21 00:00:00', 0),
(9, 'Annual Customer Master', 'amc.php', 'amc.png', '2018-06-21 00:00:00', '2018-06-21 00:00:00', 0),
(10, 'Completed Service Booking', 'completed_customer_service.php', 'complete_service_booking.png', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0);

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

--
-- Table structure for table `mobile_template`
--

CREATE TABLE IF NOT EXISTS `mobile_template` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mt_vTemplateName` varchar(350) NOT NULL,
  `mt_vMobText1` varchar(250) NOT NULL,
  `mt_vMobText2` varchar(100) NOT NULL,
  `mt_vMobText3` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=ascii AUTO_INCREMENT=2 ;

--
-- Dumping data for table `mobile_template`
--

INSERT INTO `mobile_template` (`id`, `mt_vTemplateName`, `mt_vMobText1`, `mt_vMobText2`, `mt_vMobText3`) VALUES
(1, 'Mobile Verification', 'Please enter this OTP', 'to verify your mobile no.', '');

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

--
-- Table structure for table `notification_mst`
--

CREATE TABLE IF NOT EXISTS `notification_mst` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `nm_vMessage` varchar(100) NOT NULL,
  `nm_tCreatedDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `del_i` int(2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `notification_mst`
--

INSERT INTO `notification_mst` (`id`, `nm_vMessage`, `nm_tCreatedDate`, `del_i`) VALUES
(1, ' hiii', '2018-07-21 09:50:53', 0),
(2, ' 1234567890', '2018-07-21 10:11:27', 0);

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

--
-- Table structure for table `service_booking_mst`
--

CREATE TABLE IF NOT EXISTS `service_booking_mst` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `sm_iCustomerId` int(10) NOT NULL,
  `sm_iServiceId` int(10) NOT NULL,
  `sm_iServiceTypeId` int(10) NOT NULL,
  `sm_iAssignedEmpId` int(10) NOT NULL,
  `sm_vBrand` varchar(50) NOT NULL,
  `sm_vModel` varchar(50) NOT NULL,
  `sm_vSerialNo` varchar(50) NOT NULL,
  `sm_vDescription` varchar(255) NOT NULL,
  `sm_vEnagementType` varchar(50) NOT NULL,
  `sm_dCreatedDate` datetime NOT NULL,
  `sm_dUpdatedDate` datetime NOT NULL,
  `sm_vStatus` varchar(50) NOT NULL,
  `del_i` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

--
-- Dumping data for table `service_booking_mst`
--

INSERT INTO `service_booking_mst` (`id`, `sm_iCustomerId`, `sm_iServiceId`, `sm_iServiceTypeId`, `sm_iAssignedEmpId`, `sm_vBrand`, `sm_vModel`, `sm_vSerialNo`, `sm_vDescription`, `sm_vEnagementType`, `sm_dCreatedDate`, `sm_dUpdatedDate`, `sm_vStatus`, `del_i`) VALUES
(1, 1, 2, 3, 3, 'samsung', 's', '2225', 'test ', 'Pick up/Drop off', '2018-07-20 19:28:29', '2018-07-21 14:42:14', '3', 0),
(2, 1, 2, 4, 2, 'Aser', 'XhtMl23', '1100121021', ' change the new os', 'Pick up/Drop off', '2018-07-21 12:11:31', '2018-07-21 15:06:52', '5', 0),
(3, 2, 3, 6, 3, 'HP', 'New model', '122123145319655', 'key board problem ', 'Pick up/Drop off', '2018-07-21 12:26:27', '2018-07-21 12:26:27', '1', 0),
(4, 2, 2, 1, 3, 'acer', '123', '0', 'test ', 'Onsite/Door Step', '2018-07-21 13:48:38', '2018-07-21 13:48:38', '1', 0),
(5, 2, 2, 1, 3, 'acer', '123', '0', 'test ', 'Onsite/Door Step', '2018-07-21 13:49:04', '2018-07-21 13:49:04', '1', 0),
(6, 2, 2, 1, 1, 'acer', '123', '0', 'test ', 'Onsite/Door Step', '2018-07-21 13:49:13', '2018-07-21 13:49:13', '1', 0),
(7, 2, 2, 1, 3, 'acer', '123', '0', 'test ', 'Onsite/Door Step', '2018-07-21 13:49:21', '2018-07-21 14:43:04', '3', 0),
(8, 2, 2, 1, 3, 'acer', '123', '0', 'test ', 'Onsite/Door Step', '2018-07-21 13:49:29', '2018-07-21 14:42:44', '3', 0),
(9, 2, 2, 1, 2, 'acer', '123', '246545', 'test ', 'Onsite/Door Step', '2018-07-21 13:52:39', '2018-07-21 15:08:28', '2', 0),
(10, 2, 2, 1, 2, 'acer', '123', '0', 'test  ', 'Instore Appt', '2018-07-21 13:52:50', '2018-07-21 15:06:34', '3', 0);

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

--
-- Table structure for table `service_mst`
--

CREATE TABLE IF NOT EXISTS `service_mst` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `sm_vServiceName` varchar(100) NOT NULL,
  `sm_vImageName` varchar(100) NOT NULL,
  `sm_tCreatedDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `sm_dUpdatedDate` date NOT NULL,
  `del_i` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `service_mst`
--

INSERT INTO `service_mst` (`id`, `sm_vServiceName`, `sm_vImageName`, `sm_tCreatedDate`, `sm_dUpdatedDate`, `del_i`) VALUES
(1, 'CCTV', '3b2645418d6b1601b1b89891584dd7156501.png', '2018-06-20 14:58:33', '2018-07-20', 0),
(2, 'Desktop', '7d9a0d8c982694dc87fa87d7e470cde09172.png', '2018-06-20 14:58:45', '2018-06-20', 0),
(3, 'Laptop', '02dc57df00b879328f2c95931ecd1e804763.png', '2018-06-20 14:58:56', '2018-06-20', 0),
(4, 'Mobile', 'cc39c20b4bc9498a260a8f786f83f35d4844.png', '2018-06-20 14:59:14', '2018-06-20', 0),
(5, 'Networking', 'ccfd8d3b0c14477309c66dec4eb412105965.png', '2018-06-20 14:59:25', '2018-06-20', 0),
(6, 'Printers', 'bec70aba8e9aefec8b7139b103ff25d21466.png', '2018-06-20 14:59:36', '2018-06-20', 0),
(7, 'Server', '7edcd526f2e191b1c0c32c7e294eb1833437.png', '2018-06-20 14:59:45', '2018-06-20', 0),
(8, 'Tablet', 'e439e73047527acb8b737b65a75c019a9138.png', '2018-06-20 15:00:07', '2018-06-20', 0);

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

--
-- Table structure for table `service_status_comments`
--

CREATE TABLE IF NOT EXISTS `service_status_comments` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `ssc_iServiceBookingId` int(10) NOT NULL,
  `ssc_iEmpId` int(10) NOT NULL,
  `ssc_iStatusId` int(10) NOT NULL,
  `ssc_vComments` varchar(300) NOT NULL,
  `ssc_vServiceType` varchar(50) NOT NULL,
  `ssc_dCreatedDate` datetime NOT NULL,
  `del_i` int(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=60 ;

--
-- Dumping data for table `service_status_comments`
--

INSERT INTO `service_status_comments` (`id`, `ssc_iServiceBookingId`, `ssc_iEmpId`, `ssc_iStatusId`, `ssc_vComments`, `ssc_vServiceType`, `ssc_dCreatedDate`, `del_i`) VALUES
(1, 1, 1, 1, 'App Service Created Date: 20-07-2018 Admin Converted App service to New Service', 'general_service', '2018-07-20 19:28:30', 0),
(2, 1, 1, 1, 'Admin Assigned to Prakash', 'general_service', '2018-07-20 19:28:38', 0),
(3, 1, 1, 1, 'Admin Added New Service ', 'annual_service', '2018-07-20 19:31:13', 0),
(4, 2, 1, 1, 'Admin Assigned to Prakash', 'annual_service', '2018-07-20 19:32:34', 0),
(5, 1, 1, 1, 'test', 'general_service', '2018-07-20 19:32:55', 0),
(6, 1, 1, 2, 'test\n', 'general_service', '2018-07-20 19:33:06', 0),
(7, 2, 1, 1, 'new comments', 'annual_service', '2018-07-20 19:33:44', 0),
(8, 2, 1, 3, 'done', 'annual_service', '2018-07-20 19:33:55', 0),
(9, 2, 1, 1, 'Admin Added New Service ', 'general_service', '2018-07-21 12:11:31', 0),
(10, 2, 1, 1, 'Admin Assigned to Sarath', 'general_service', '2018-07-21 12:11:45', 0),
(11, 3, 1, 1, 'App Service Created Date: 21-07-2018 Admin Converted App service to New Service', 'general_service', '2018-07-21 12:26:27', 0),
(12, 1, 1, 1, 'Admin Assigned to Sarath', 'annual_service', '2018-07-21 12:46:00', 0),
(13, 4, 1, 1, 'Admin Assigned to Aleem', 'annual_service', '2018-07-21 12:59:26', 0),
(14, 5, 1, 1, 'Admin Assigned to Sarath', 'annual_service', '2018-07-21 12:59:27', 0),
(15, 5, 1, 1, 'Admin Assigned to Aleem', 'annual_service', '2018-07-21 12:59:32', 0),
(16, 5, 1, 1, 'Admin Assigned to Sarath', 'annual_service', '2018-07-21 12:59:36', 0),
(17, 3, 1, 1, 'Admin Assigned to Prakash', 'annual_service', '2018-07-21 12:59:40', 0),
(18, 5, 1, 1, 'ok fine', 'annual_service', '2018-07-21 13:00:38', 0),
(19, 5, 1, 1, 'hello', 'annual_service', '2018-07-21 13:02:46', 0),
(20, 5, 1, 1, 'hiii', 'annual_service', '2018-07-21 13:03:21', 0),
(21, 5, 1, 1, 'Admin Updated Status for Open.. testing complete', 'annual_service', '2018-07-21 13:06:52', 0),
(22, 5, 1, 1, 'Admin Added New Service ', 'annual_service', '2018-07-21 13:07:11', 0),
(23, 4, 1, 1, 'App Service Created Date: 21-07-2018 Admin Converted App service to New Service', 'general_service', '2018-07-21 13:48:38', 0),
(24, 5, 1, 1, 'App Service Created Date: 21-07-2018 Admin Converted App service to New Service', 'general_service', '2018-07-21 13:49:04', 0),
(25, 6, 1, 1, 'App Service Created Date: 21-07-2018 Admin Converted App service to New Service', 'general_service', '2018-07-21 13:49:13', 0),
(26, 7, 1, 1, 'App Service Created Date: 21-07-2018 Admin Converted App service to New Service', 'general_service', '2018-07-21 13:49:21', 0),
(27, 8, 1, 1, 'App Service Created Date: 21-07-2018 Admin Converted App service to New Service', 'general_service', '2018-07-21 13:49:29', 0),
(28, 9, 1, 1, 'App Service Created Date: 21-07-2018 Admin Converted App service to New Service', 'general_service', '2018-07-21 13:52:39', 0),
(29, 10, 1, 1, 'App Service Created Date: 21-07-2018 Admin Converted App service to New Service', 'general_service', '2018-07-21 13:52:50', 0),
(30, 10, 1, 1, 'Admin Assigned to Sarath', 'general_service', '2018-07-21 13:53:03', 0),
(31, 9, 1, 1, 'Admin Assigned to Sarath', 'general_service', '2018-07-21 13:53:07', 0),
(32, 10, 2, 1, 'hi', 'general_service', '2018-07-21 13:54:41', 0),
(33, 2, 2, 3, 'it''s completely alright ', 'general_service', '2018-07-21 13:55:37', 0),
(34, 9, 1, 1, 'Admin Assigned to Sarath', 'general_service', '2018-07-21 13:55:58', 0),
(35, 10, 2, 1, '\\/'';,ol;''\\', 'general_service', '2018-07-21 14:00:09', 1),
(36, 10, 1, 1, 'hiiii', 'general_service', '2018-07-21 14:03:49', 0),
(37, 5, 1, 1, 'testing', 'annual_service', '2018-07-21 14:14:25', 0),
(38, 5, 1, 1, 'Admin Added New Service ', 'annual_service', '2018-07-21 14:16:28', 0),
(39, 2, 1, 1, 'Service Reopened by Admin', 'general_service', '2018-07-21 14:28:56', 0),
(40, 10, 2, 3, 'successfully completed', 'general_service', '2018-07-21 14:30:39', 0),
(41, 10, 1, 1, 'Service Reopened by Admin', 'general_service', '2018-07-21 14:32:45', 0),
(42, 10, 1, 1, 'Admin Assigned to Sarath', 'general_service', '2018-07-21 14:33:01', 0),
(43, 2, 1, 1, 'Admin Assigned to Sarath', 'general_service', '2018-07-21 14:33:06', 0),
(44, 7, 1, 1, 'Admin Assigned to Aleem', 'general_service', '2018-07-21 14:41:33', 0),
(45, 4, 1, 1, 'Admin Assigned to Aleem', 'general_service', '2018-07-21 14:41:39', 0),
(46, 1, 1, 5, 'Admin Assigned to Aleem', 'general_service', '2018-07-21 14:41:44', 0),
(47, 3, 2, 1, 'ooi', 'general_service', '2018-07-21 14:48:01', 0),
(48, 10, 2, 1, 'hhii', 'general_service', '2018-07-21 14:50:56', 0),
(49, 10, 2, 1, 'hii', 'general_service', '2018-07-21 14:51:21', 0),
(50, 10, 2, 3, 'complete', 'general_service', '2018-07-21 15:06:34', 0),
(51, 9, 1, 2, 'test', 'general_service', '2018-07-21 18:19:11', 0),
(52, 9, 1, 2, 'vc', 'general_service', '2018-07-21 18:22:16', 0),
(53, 9, 1, 2, 'sdb', 'general_service', '2018-07-21 18:23:21', 0),
(54, 3, 1, 1, 'test', 'annual_service', '2018-07-21 18:25:47', 0),
(55, 2, 1, 5, 'ssdfadsgfdhf', 'annual_service', '2018-07-21 18:29:57', 0),
(56, 2, 1, 0, 'sdafdsgfd', 'annual_service', '2018-07-21 18:30:01', 0),
(57, 2, 1, 0, 'SADSFD', 'annual_service', '2018-07-21 18:30:05', 0),
(58, 2, 1, 5, 'SDFGHJ', 'annual_service', '2018-07-21 18:31:24', 0),
(59, 2, 1, 5, 'SAD', 'annual_service', '2018-07-21 18:32:13', 0);

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

--
-- Table structure for table `service_support_category_mst`
--

CREATE TABLE IF NOT EXISTS `service_support_category_mst` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `scm_vServiceCategoryName` varchar(100) NOT NULL,
  `scm_vDescription` text NOT NULL,
  `scm_dCreatedDate` datetime NOT NULL,
  `scm_dUpdatedDate` datetime NOT NULL,
  `del_i` int(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `service_support_category_mst`
--

INSERT INTO `service_support_category_mst` (`id`, `scm_vServiceCategoryName`, `scm_vDescription`, `scm_dCreatedDate`, `scm_dUpdatedDate`, `del_i`) VALUES
(1, 'Networking', 'Networking', '2018-06-20 20:31:06', '2018-07-20 13:14:06', 0),
(2, 'Laptop', 'Hardware ', '2018-07-07 16:48:22', '2018-07-07 20:02:01', 0);

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

--
-- Table structure for table `service_support_mst`
--

CREATE TABLE IF NOT EXISTS `service_support_mst` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `ssm_iCategoryId` int(10) NOT NULL,
  `ssm_vServiceName` varchar(100) NOT NULL,
  `ssm_vImageName` varchar(100) NOT NULL,
  `ssm_Amount` int(10) NOT NULL,
  `ssm_dCreatedDate` datetime NOT NULL,
  `ssm_dUpdatedDate` datetime NOT NULL,
  `del_i` int(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `service_support_mst`
--

INSERT INTO `service_support_mst` (`id`, `ssm_iCategoryId`, `ssm_vServiceName`, `ssm_vImageName`, `ssm_Amount`, `ssm_dCreatedDate`, `ssm_dUpdatedDate`, `del_i`) VALUES
(1, 1, 'Bullets', 'bb854784135a6c7aeafa49b1487a493b3901.png', 1000, '2018-06-20 20:31:53', '2018-06-20 20:31:53', 0),
(2, 1, 'CCTV', 'bb979a31c35614fbe625ab362f3db7174302.png', 2000, '2018-06-20 20:32:09', '2018-06-20 20:32:09', 0),
(3, 1, 'Desktop', '67444507bcd3e1ccf9f5652881506b333503.png', 3000, '2018-06-20 20:32:22', '2018-06-20 20:32:22', 0),
(4, 1, 'Networking', '4fefdbdf5dd09fafab63c88f75cf26c75134.png', 4000, '2018-06-20 20:32:35', '2018-06-20 20:32:35', 0),
(5, 1, 'Printers', 'fbc225deb5798960f0cfb7686ccf07df5995.png', 5000, '2018-06-20 20:32:50', '2018-06-20 20:32:50', 0),
(6, 1, 'Server', '8bd57acd985ef9e9cc74ed1f0386f7c91276.png', 6000, '2018-06-20 20:33:04', '2018-06-20 20:33:04', 0),
(8, 2, 'laptop service', '', 2000, '2018-07-20 19:18:19', '2018-07-20 19:18:19', 0);

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

--
-- Table structure for table `service_type_mst`
--

CREATE TABLE IF NOT EXISTS `service_type_mst` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `stm_iServiceId` int(10) NOT NULL,
  `stm_vServiceTypeName` varchar(100) NOT NULL,
  `stm_tCreatedDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `stm_dUpdatedDate` date NOT NULL,
  `del_i` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;

--
-- Dumping data for table `service_type_mst`
--

INSERT INTO `service_type_mst` (`id`, `stm_iServiceId`, `stm_vServiceTypeName`, `stm_tCreatedDate`, `stm_dUpdatedDate`, `del_i`) VALUES
(1, 1, 'Projectors', '2018-07-20 13:40:25', '2018-07-20', 0),
(2, 1, 'Camera Views', '2018-07-20 13:40:36', '2018-07-20', 0),
(3, 2, 'Desktop service', '2018-07-20 13:43:29', '2018-07-20', 0),
(4, 2, 'OS Installation', '2018-07-21 06:04:12', '2018-07-21', 0),
(5, 3, 'OS Installation', '2018-07-21 06:05:18', '2018-07-21', 0),
(6, 3, 'Hardware', '2018-07-21 06:05:33', '2018-07-21', 0),
(7, 3, 'Software', '2018-07-21 06:05:45', '2018-07-21', 0),
(8, 4, 'Update OS version', '2018-07-21 06:06:44', '2018-07-21', 0),
(9, 4, 'Touch and Display', '2018-07-21 06:09:06', '2018-07-21', 0),
(10, 4, 'Basic service', '2018-07-21 06:11:31', '2018-07-21', 0),
(11, 4, 'Keypad', '2018-07-21 06:12:06', '2018-07-21', 0),
(12, 5, 'Server maintain', '2018-07-21 06:13:11', '2018-07-21', 0),
(13, 6, 'Tonner', '2018-07-21 06:14:19', '2018-07-21', 0),
(14, 6, 'Scanner', '2018-07-21 06:15:35', '2018-07-21', 0),
(15, 7, 'Maintainance', '2018-07-21 06:16:22', '2018-07-21', 0),
(16, 7, 'Server Crashes', '2018-07-21 06:16:43', '2018-07-21', 0),
(17, 8, 'Update version', '2018-07-21 06:17:19', '2018-07-21', 0),
(18, 8, 'Display and Touch', '2018-07-21 06:17:39', '2018-07-21', 0),
(19, 8, 'Basic service', '2018-07-21 06:17:55', '2018-07-21', 0);

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

--
-- Table structure for table `status_mst`
--

CREATE TABLE IF NOT EXISTS `status_mst` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `sm_vStatusName` varchar(20) NOT NULL,
  `sm_dCreatedDate` datetime NOT NULL,
  `del_i` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `status_mst`
--

INSERT INTO `status_mst` (`id`, `sm_vStatusName`, `sm_dCreatedDate`, `del_i`) VALUES
(1, 'Open', '2018-06-22 00:00:00', 0),
(2, 'Progress', '2018-06-14 00:00:00', 0),
(3, 'Completed', '2018-06-06 00:00:00', 0),
(5, 'Pending', '2018-07-18 00:00:00', 0);

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

--
-- Table structure for table `stock_images`
--

CREATE TABLE IF NOT EXISTS `stock_images` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `si_iStockId` int(10) NOT NULL,
  `si_vImageName` varchar(100) NOT NULL,
  `si_tCreatedDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `del_i` int(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

--
-- Dumping data for table `stock_images`
--

INSERT INTO `stock_images` (`id`, `si_iStockId`, `si_vImageName`, `si_tCreatedDate`, `del_i`) VALUES
(1, 1, '2b090f6f698c291ac6a54b2275ebb24c7931.jpeg', '2018-07-21 06:28:51', 0),
(2, 2, 'ae645c980aeddec636ca87b8cb9c72f89092.jpeg', '2018-07-21 06:29:38', 0),
(3, 3, 'b4c9f8b5eedbe2685da9bd9252b65a478803.jpeg', '2018-07-21 06:30:40', 0),
(4, 4, '6e545f2a4472e55d572ca19418054963794.jpeg', '2018-07-21 06:31:03', 0),
(5, 5, '2e042aecee599f6e077d7998000ca1d77875.jpeg', '2018-07-21 06:31:58', 0),
(6, 6, 'd04274f62600d6f4521764659feeefad8546.jpeg', '2018-07-21 06:32:22', 0),
(7, 7, '12c0db9653a500d5a33732ea508df0a77767.jpeg', '2018-07-21 06:32:52', 0),
(8, 8, '27b099e63dac27c8a32cc55a2b2fa4699608.jpeg', '2018-07-21 06:34:36', 0),
(9, 9, 'f80d720047b71e7a2b3410da67b33a377619.jpeg', '2018-07-21 06:35:28', 0),
(10, 10, '046fe8a6cf3c058a4f30277fb41b201297010.jpeg', '2018-07-21 06:36:01', 0),
(11, 11, '631aef273ff1381894646ee2348f7fa790111.jpeg', '2018-07-21 06:36:26', 0);

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

--
-- Table structure for table `stock_mst`
--

CREATE TABLE IF NOT EXISTS `stock_mst` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `sm_iCategoryId` int(10) NOT NULL,
  `sm_iBrandId` int(10) NOT NULL,
  `sm_vTitle` varchar(100) NOT NULL,
  `sm_iPrice` int(10) NOT NULL,
  `sm_vDescription` text NOT NULL,
  `sm_tCreatedDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `sm_dUpdatedDate` datetime NOT NULL,
  `del_i` int(4) NOT NULL,
  `visible` int(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

--
-- Dumping data for table `stock_mst`
--

INSERT INTO `stock_mst` (`id`, `sm_iCategoryId`, `sm_iBrandId`, `sm_vTitle`, `sm_iPrice`, `sm_vDescription`, `sm_tCreatedDate`, `sm_dUpdatedDate`, `del_i`, `visible`) VALUES
(1, 1, 2, 'Laptop', 25000, 'Nice Laptop', '2018-07-21 06:28:51', '2018-07-21 11:58:51', 0, 1),
(2, 2, 1, 'Antivirus', 1000, ' K7 antivirus', '2018-07-21 06:29:38', '2018-07-21 11:59:38', 0, 1),
(3, 2, 2, 'Antivirus', 1000, ' K7 antiviruse', '2018-07-21 06:30:39', '2018-07-21 12:00:39', 0, 1),
(4, 2, 4, 'Antivirus', 1000, ' K7 antiviruse', '2018-07-21 06:31:02', '2018-07-21 12:01:02', 0, 1),
(5, 1, 1, 'USB port', 2000, 'WOW', '2018-07-21 06:31:57', '2018-07-21 12:01:57', 0, 1),
(6, 1, 1, 'Keyboard', 5000, ' Nice', '2018-07-21 06:32:21', '2018-07-21 12:02:21', 0, 1),
(7, 1, 1, 'Mouse', 500, 'Super', '2018-07-21 06:32:52', '2018-07-21 12:02:52', 0, 1),
(8, 2, 1, 'Windows 10 OS', 2500, ' Orginal OS', '2018-07-21 06:34:36', '2018-07-21 12:04:36', 0, 1),
(9, 2, 2, 'Antivirus', 1000, ' K7 antiviruse', '2018-07-21 06:35:28', '2018-07-21 12:05:28', 0, 1),
(10, 2, 2, 'Windows 10 OS', 2500, ' Original OS', '2018-07-21 06:36:01', '2018-07-21 12:06:01', 0, 1),
(11, 1, 2, 'Mouse', 500, ' NICE', '2018-07-21 06:36:26', '2018-07-21 12:06:26', 0, 1);

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

--
-- Table structure for table `sub_menu_mst`
--

CREATE TABLE IF NOT EXISTS `sub_menu_mst` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `smm_iMenuId` int(10) NOT NULL,
  `smm_vSubMenuName` varchar(100) NOT NULL,
  `smm_vLink` varchar(100) NOT NULL,
  `smm_vImage` varchar(100) NOT NULL,
  `smm_dCreatedDate` datetime NOT NULL,
  `smm_dUpdatedDate` datetime NOT NULL,
  `del_i` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

--
-- Dumping data for table `sub_menu_mst`
--

INSERT INTO `sub_menu_mst` (`id`, `smm_iMenuId`, `smm_vSubMenuName`, `smm_vLink`, `smm_vImage`, `smm_dCreatedDate`, `smm_dUpdatedDate`, `del_i`) VALUES
(1, 5, 'General', 'general.php', 'general.png', '2018-06-21 00:00:00', '2018-06-21 00:00:00', 0),
(2, 5, 'Product', 'product.php', 'user.png', '2018-06-21 00:00:00', '2018-06-21 00:00:00', 0),
(3, 5, 'Service Support', 'service_support.php', 'tracking.png', '2018-06-21 00:00:00', '2018-06-21 00:00:00', 0),
(4, 6, 'Stock Master', 'stock.php', 'sales_request.png', '2018-06-21 00:00:00', '2018-06-21 00:00:00', 0),
(5, 6, 'Service Master', 'service.php', 'user.png', '2018-06-21 00:00:00', '2018-06-21 00:00:00', 0),
(6, 6, 'Employee Master', 'employee.php', 'emp_master.png', '2018-06-21 00:00:00', '2018-06-21 00:00:00', 0),
(7, 6, 'Annual Master', 'annual_service.php', 'master.png', '2018-06-21 00:00:00', '2018-06-21 00:00:00', 0),
(8, 7, 'Service Support Master', 'service_category.php', 'tracking.png', '2018-06-21 00:00:00', '2018-06-21 00:00:00', 0),
(9, 7, 'Android VER MGMT', 'version.php', 'user.png', '2018-06-21 00:00:00', '2018-06-21 00:00:00', 0),
(10, 7, 'IOS VER MGMT', ' #', 'ios.png', '2018-06-21 00:00:00', '2018-06-21 00:00:00', 0),
(11, 7, 'Notification', 'notification_ae.php', 'notify.png', '2018-06-21 00:00:00', '2018-06-21 00:00:00', 0),
(12, 6, 'Category ', 'category.php', 'categorie.png', '2018-06-21 00:00:00', '2018-06-21 00:00:00', 0),
(13, 6, 'Brand', 'brand.php', 'brand.png', '2018-06-21 00:00:00', '2018-06-21 00:00:00', 0);

