-- 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=5 ;

--
-- 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-20 15:06:49', 0),
(3, 3, 1, '2018-07-20 14:57:56', '2018-07-20 15:06:32', 1),
(4, 4, 2, '2018-07-20 14:59:16', '2018-07-20 14:59:32', 1);

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

--
-- 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=3 ;

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

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

--
-- 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=2 ;

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

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

--
-- 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=4 ;

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

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

--
-- 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=3 ;

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

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

--
-- 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=2 ;

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

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

--
-- 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=1 ;

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

--
-- 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=3 ;

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

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

--
-- 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=1 ;

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

--
-- 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=6 ;

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

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

--
-- 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=2 ;

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

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

--
-- 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=1 ;

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

--
-- 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=1 ;

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

--
-- 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=2 ;

--
-- 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, 1, 'samsung', 's', '0', 'test ', 'Pick up/Drop off', '2018-07-20 19:28:29', '2018-07-20 20:22:22', '5', 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=9 ;

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

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

--
-- 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=4 ;

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

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

--
-- 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=1 ;

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

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

