-- phpMyAdmin SQL Dump -- version 4.0.4 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jul 21, 2018 at 05:55 AM -- 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=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 `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=2 ; -- -- 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'); -- -------------------------------------------------------- -- -- 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); -- -------------------------------------------------------- -- -- 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=2 ; -- -- 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); /*!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 */;