-- phpMyAdmin SQL Dump -- version 4.0.4 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jul 21, 2018 at 01:21 PM -- Server version: 5.6.12-log -- PHP Version: 5.4.16 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `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 `admin` -- CREATE TABLE IF NOT EXISTS `admin` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` text NOT NULL, `pass` text NOT NULL, `email` varchar(40) NOT NULL, `sms_username` varchar(100) NOT NULL, `sms_api_key` varchar(200) NOT NULL, `sms_sender_id` varchar(100) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; -- -- Dumping data for table `admin` -- INSERT INTO `admin` (`id`, `name`, `pass`, `email`, `sms_username`, `sms_api_key`, `sms_sender_id`) VALUES (1, 'admin', '5baa61e4c9b93f3f0682250b6cf8331b7ee68fd8', 'admin@gmail.com', 'inspireitsolutions', 'J4SSwvPZnF3eWGb8wrga', 'INSITS'); -- -------------------------------------------------------- -- -- 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 `employee_mst` -- CREATE TABLE IF NOT EXISTS `employee_mst` ( `id` int(10) NOT NULL AUTO_INCREMENT, `emp_name` varchar(20) NOT NULL, `phone_no` varchar(20) NOT NULL, `email_id` varchar(35) NOT NULL, `designation` varchar(20) NOT NULL, `address` varchar(100) NOT NULL, `qualification` varchar(7) NOT NULL, `experience` int(5) NOT NULL, `skill` varchar(100) NOT NULL, `photo` varchar(100) NOT NULL, `password` varchar(15) NOT NULL, `visible` int(11) NOT NULL, `del_i` int(11) NOT NULL, `em_dCreatedDate` datetime NOT NULL, `em_dUpdatedDate` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; -- -- Dumping data for table `employee_mst` -- INSERT INTO `employee_mst` (`id`, `emp_name`, `phone_no`, `email_id`, `designation`, `address`, `qualification`, `experience`, `skill`, `photo`, `password`, `visible`, `del_i`, `em_dCreatedDate`, `em_dUpdatedDate`) VALUES (1, 'Prakash', '9789058185', 'test@gmail.com', 'Developer', 'Chennai ', 'MCA', 2, 'PHP ', 'e9340c577a8de39242be8a5db5ca81737911.jpeg', '123456', 1, 0, '2018-07-20 19:14:50', '2018-07-20 19:14:50'), (2, 'Sarath', '8438102466', 'sarath@gmail.com', 'Manager', 'housing board, avadi market ', 'MCA', 3, 'Software and Hardware', '2e00eb5cebcce73ee5c280cd5bfa18116170.jpeg', '1234567890', 1, 0, '2018-07-21 11:53:39', '2018-07-21 15:32:27'), (3, 'Aleem', '9442645220', 'aleem@gmail.com', 'Asst. Manager', ' housing board,avadi market,avadi', 'MCA', 3, 'Hardware and Software', '96bb137dc11ba1ce8d5bc352b3bb91f27833.jpeg', '123456', 1, 0, '2018-07-21 11:56:13', '2018-07-21 11:56:13'); -- -------------------------------------------------------- -- -- 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 ; -- -- Dumping data for table `logger` -- INSERT INTO `logger` (`id`, `date`, `ip`, `message`, `type`) VALUES (1, '1500616954', '192.168.1.11', 'Login:admin,password', 2), (2, '1500625687', '192.168.1.11', 'Login:admin,password', 2), (3, '1500625710', '192.168.1.11', 'Login:sarath@gmail.com,123456', 2), (4, '1500631024', '192.168.1.11', 'Login:admin,password', 2), (5, '1500631192', '192.168.1.11', 'Login:admin,password', 2), (6, '1500631198', '192.168.1.11', 'Login:admin1,password', 2), (7, '1500631208', '192.168.1.11', 'Login:admin1,123456', 2), (8, '1500631256', '192.168.1.11', 'Login:admin,123456', 2), (9, '1500631266', '192.168.1.11', 'Login:admin,password', 2), (10, '1500631368', '192.168.1.11', 'Login:sarath@gmail.com,123456', 2), (11, '1500631386', '192.168.1.11', 'Login:sarath@gmail.com,123421q34', 2), (12, '1500631407', '192.168.1.11', 'Login:sarath@gmail.com,1234567890', 2), (13, '1500631869', '192.168.1.11', 'Login:admin,password', 2), (14, '1500635974', '192.168.1.4', 'Login:admin,password', 2); -- -------------------------------------------------------- -- -- 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); -- -------------------------------------------------------- -- -- Table structure for table `user_mst` -- CREATE TABLE IF NOT EXISTS `user_mst` ( `id` int(10) NOT NULL AUTO_INCREMENT, `um_iCustomerId` int(10) NOT NULL, `um_vUserType` varchar(40) NOT NULL, `um_vPassword` varchar(100) NOT NULL, `um_iMobileOtp` int(20) NOT NULL, `um_iMobileVerification` int(4) NOT NULL COMMENT '1-Verified,0-Not verified', `um_tCreatedDate` datetime NOT NULL, `um_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 `user_mst` -- INSERT INTO `user_mst` (`id`, `um_iCustomerId`, `um_vUserType`, `um_vPassword`, `um_iMobileOtp`, `um_iMobileVerification`, `um_tCreatedDate`, `um_dUpdatedDate`, `del_i`) VALUES (1, 1, 'General', '12345', 8147, 1, '2018-07-20 19:21:08', '2018-07-20 19:22:23', 0), (2, 2, 'General', '123456', 9321, 1, '2018-07-21 12:18:15', '2018-07-21 12:18:54', 0); /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;