-- phpMyAdmin SQL Dump -- version 4.0.10.18 -- https://www.phpmyadmin.net -- -- Host: localhost:3306 -- Generation Time: Oct 25, 2017 at 02:32 PM -- Server version: 5.5.55-38.8-log -- PHP Version: 5.6.30 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: `deepaoin_vigecocons` -- -- -------------------------------------------------------- -- -- Table structure for table `expense_level_details` -- CREATE TABLE IF NOT EXISTS `expense_level_details` ( `auto_number` int(11) NOT NULL AUTO_INCREMENT, `project_id` varchar(255) NOT NULL, `project_name` varchar(255) NOT NULL, `level_id` int(11) DEFAULT NULL, `expense_main` varchar(255) NOT NULL, `expense_sub` varchar(255) NOT NULL, `date` datetime NOT NULL, `amount` int(11) NOT NULL, `mode_of_payment` varchar(255) NOT NULL, `bank_name` varchar(255) NOT NULL, `ch_no` varchar(255) NOT NULL, `ch_date` varchar(255) NOT NULL, `tran_no` varchar(255) NOT NULL, `remarks` varchar(255) NOT NULL, `created` datetime NOT NULL, PRIMARY KEY (`auto_number`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ; -- -- Dumping data for table `expense_level_details` -- INSERT INTO `expense_level_details` (`auto_number`, `project_id`, `project_name`, `level_id`, `expense_main`, `expense_sub`, `date`, `amount`, `mode_of_payment`, `bank_name`, `ch_no`, `ch_date`, `tran_no`, `remarks`, `created`) VALUES (1, '5', 'ABCD', 58, '13', '18', '2015-03-28 00:00:00', 1000, 'cheque', 'a', 'b', ' c', '', 'hi', '2015-03-28 11:06:02'), (2, '5', 'ABCD', 59, '12', '17', '2015-03-28 00:00:00', 1000, 'online', 'a', '', '', '23 ', 'hi', '2015-03-28 11:07:34'), (4, '5', 'ABCD', 58, '11', '', '2015-03-28 00:00:00', 1000, 'cash', '', '', '', '', 'hi', '2015-03-28 11:29:24'), (5, '7', 'n.koil', 62, '14', '20', '2015-03-17 00:00:00', 1100, 'cash', '', '', '', '', 'req', '2015-03-29 13:41:47'), (6, '', 'aravindnagar', 62, '14', '21', '2015-03-29 00:00:00', 1200, 'cash', '', '', '', '', '', '2015-03-30 04:24:03'), (7, '7', 'n.koil', 64, '17', '24', '2015-03-30 00:00:00', 1500, 'cash', '', '', '', '', '', '2015-03-30 04:24:33'), (8, '', 'Aravindnagar', 62, '14', '20', '2015-04-08 00:00:00', 5000, 'cash', '', '', '', '', '', '2015-04-24 12:33:40'), (9, '', 'aravidnagar', 0, 'Select', '', '2015-02-05 00:00:00', 0, 'select', '', '', '', '', '', '2015-06-03 12:04:37'), (10, '7', 'n.koil', 0, 'Select', '', '1970-01-01 00:00:00', 0, 'select', '', '', '', '', '', '2015-06-19 09:35:30'); -- -------------------------------------------------------- -- -- Table structure for table `labour_details` -- CREATE TABLE IF NOT EXISTS `labour_details` ( `auto_number` int(11) NOT NULL AUTO_INCREMENT, `labour` varchar(255) NOT NULL, `ipaddress` varchar(255) NOT NULL, `created` datetime NOT NULL, PRIMARY KEY (`auto_number`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ; -- -- Dumping data for table `labour_details` -- INSERT INTO `labour_details` (`auto_number`, `labour`, `ipaddress`, `created`) VALUES (1, 'Mason', '', '0000-00-00 00:00:00'), (2, 'Man Muzdoor', '', '0000-00-00 00:00:00'), (3, 'Woman Muzdoor', '', '0000-00-00 00:00:00'), (4, 'Electrical', '', '0000-00-00 00:00:00'), (5, 'Plumber', '', '0000-00-00 00:00:00'), (6, 'Carpentar', '', '0000-00-00 00:00:00'), (7, 'Bar bendar', '', '0000-00-00 00:00:00'), (8, 'Tiles', '', '0000-00-00 00:00:00'), (9, 'Painter', '', '0000-00-00 00:00:00'); -- -------------------------------------------------------- -- -- Table structure for table `level_materials` -- CREATE TABLE IF NOT EXISTS `level_materials` ( `auto_number` int(11) NOT NULL AUTO_INCREMENT, `sublevel_id` int(11) NOT NULL, `material` varchar(255) NOT NULL, `quantity` varchar(255) NOT NULL, `created` datetime NOT NULL, PRIMARY KEY (`auto_number`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=209 ; -- -- Dumping data for table `level_materials` -- INSERT INTO `level_materials` (`auto_number`, `sublevel_id`, `material`, `quantity`, `created`) VALUES (107, 58, 'SAND', '20', '2015-03-27 13:41:18'), (108, 58, 'COINN', '20', '2015-03-27 13:41:18'), (111, 59, 'COINN', '30', '2015-03-27 13:41:18'), (112, 59, 'GOLT', '30', '2015-03-27 13:41:18'), (113, 60, 'SAND', '10', '2015-03-21 08:02:22'), (114, 61, 'SAND', '10', '2015-03-21 08:02:22'), (115, 58, 'JULLY', '50', '2015-03-27 13:41:18'), (116, 62, 'SAND', '10', '2015-03-29 12:42:26'), (117, 58, 'TAR', '20', '2015-03-27 13:41:18'), (118, 59, 'TAR', '50', '2015-03-27 13:41:18'), (119, 62, 'SAND', '400', '2015-03-28 17:18:29'), (120, 62, 'JULLY', '500', '2015-03-29 12:42:26'), (121, 63, 'SAND', '300', '2015-03-29 12:42:26'), (122, 63, 'JULLY', '500', '2015-03-29 12:42:26'), (123, 64, 'SAND', '500', '2015-03-29 12:42:26'), (124, 64, 'JULLY', '450', '2015-03-29 12:42:26'), (125, 62, 'STEEL', '1500', '2015-03-29 12:42:26'), (126, 62, 'CEMENT', '200', '2015-03-29 12:42:26'), (127, 63, 'STEEL', '300', '2015-03-29 12:42:26'), (128, 63, 'CEMENT', '400', '2015-03-29 12:42:26'), (129, 64, 'STEEL', '750', '2015-03-29 12:42:26'), (130, 64, 'CEMENT', '400', '2015-03-29 12:42:26'), (131, 64, 'WOOD', '60', '2015-03-29 12:42:26'), (132, 64, 'ELECTRICAL', '75000', '2015-03-29 12:42:26'), (133, 64, 'PLUMBING', '75000', '2015-03-29 12:42:26'), (134, 64, 'TILES', '1400', '2015-03-29 12:42:26'), (135, 65, 'SAND', '300', '2015-03-30 04:28:42'), (136, 65, 'STEEL', '550', '2015-03-30 04:28:42'), (137, 65, 'JULLY', '400', '2015-03-30 04:28:42'), (138, 65, 'CEMENT', '300', '2015-03-30 04:28:42'), (139, 65, 'ELECTRICAL', '6000', '2015-03-30 04:28:42'), (140, 66, 'SAND', '400', '2015-03-30 04:28:42'), (141, 66, 'STEEL', '500', '2015-03-30 04:28:42'), (142, 66, 'JULLY', '750', '2015-03-30 04:28:42'), (143, 66, 'CEMENT', '300', '2015-03-30 04:28:42'), (144, 67, 'SAND', '300', '2015-03-30 04:28:42'), (145, 67, 'STEEL', '600', '2015-03-30 04:28:42'), (146, 67, 'JULLY', '450', '2015-03-30 04:28:42'), (147, 67, 'CEMENT', '300', '2015-03-30 04:28:42'), (148, 67, 'ELECTRICAL', '4000', '2015-03-30 04:28:42'), (149, 68, 'SAND', '600', '2015-03-30 04:28:42'), (150, 68, 'STEEL', '250', '2015-03-30 04:28:42'), (151, 68, 'JULLY', '150', '2015-03-30 04:28:42'), (152, 68, 'CEMENT', '250', '2015-03-30 04:28:42'), (153, 68, 'WOOD', '55', '2015-03-30 04:28:42'), (154, 68, 'ELECTRICAL', '45000', '2015-03-30 04:28:42'), (155, 68, 'PLUMBING', '65000', '2015-03-30 04:28:42'), (156, 68, 'TILES', '1200', '2015-03-30 04:28:42'), (157, 69, 'SAND', '500', '2015-04-14 12:29:44'), (158, 69, 'STEEL', '750', '2015-04-14 12:29:44'), (159, 69, 'JULLY', '400', '2015-04-14 12:29:44'), (160, 69, 'CEMENT', '100', '2015-04-14 12:29:44'), (161, 70, 'SAND', '4500', '2015-04-14 12:29:44'), (162, 70, 'STEEL', '500', '2015-04-14 12:29:44'), (163, 70, 'JULLY', '400', '2015-04-14 12:29:44'), (164, 70, 'CEMENT', '150', '2015-04-14 12:29:44'), (165, 71, 'SAND', '400', '2015-04-14 12:29:44'), (166, 71, 'STEEL', '1200', '2015-04-14 12:29:44'), (167, 71, 'JULLY', '350', '2015-04-14 12:29:44'), (168, 71, 'CEMENT', '150', '2015-04-14 12:29:44'), (169, 71, 'ELECTRICAL', '5000', '2015-04-14 12:29:44'), (170, 72, 'SAND', '300', '2015-04-14 12:29:44'), (171, 72, 'STEEL', '1800', '2015-04-14 12:29:44'), (172, 72, 'JULLY', '500', '2015-04-14 12:29:44'), (173, 72, 'CEMENT', '200', '2015-04-14 12:29:44'), (174, 72, 'ELECTRICAL', '6000', '2015-04-14 12:29:44'), (175, 73, 'SAND', '400', '2015-04-14 12:29:44'), (176, 73, 'STEEL', '500', '2015-04-14 12:29:44'), (177, 73, 'JULLY', '350', '2015-04-14 12:29:44'), (178, 73, 'CEMENT', '250', '2015-04-14 12:29:44'), (179, 73, 'WOOD', '70', '2015-04-14 12:29:44'), (180, 73, 'ELECTRICAL', '25000', '2015-04-14 12:29:44'), (181, 73, 'PLUMBING', '30000', '2015-04-14 12:29:44'), (182, 73, 'TILES', '1400', '2015-04-14 12:29:44'), (183, 74, 'SAND', '600', '2015-05-26 13:03:10'), (184, 74, 'STEEL', '100', '2015-05-26 13:03:10'), (185, 74, 'JULLY', '100', '2015-05-26 13:03:10'), (186, 74, 'CEMENT', '200', '2015-05-26 13:03:10'), (187, 75, 'SAND', '500', '2015-05-26 13:03:10'), (188, 75, 'STEEL', '500', '2015-05-26 13:03:10'), (189, 75, 'JULLY', '600', '2015-05-26 13:03:10'), (190, 75, 'CEMENT', '600', '2015-05-26 13:03:10'), (191, 76, 'SAND', '500', '2015-05-26 13:03:10'), (192, 76, 'STEEL', '300', '2015-05-26 13:03:10'), (193, 76, 'JULLY', '20', '2015-05-26 13:03:10'), (194, 76, 'CEMENT', '100', '2015-05-26 13:03:10'), (195, 76, 'ELECTRICAL', '5000', '2015-05-26 13:03:10'), (196, 77, 'SAND', '450', '2015-05-26 13:03:10'), (197, 77, 'STEEL', '250', '2015-05-26 13:03:10'), (198, 77, 'ELECTRICAL', '5600', '2015-05-26 13:03:10'), (199, 78, 'SAND', '250', '2015-05-26 13:03:10'), (200, 78, 'STEEL', '100', '2015-05-26 13:03:10'), (201, 78, 'CEMENT', '300', '2015-05-26 13:03:10'), (202, 78, 'WOOD', '50', '2015-05-26 13:03:10'), (203, 78, 'ELECTRICAL', '25000', '2015-05-26 13:03:10'), (204, 78, 'PLUMBING', '30000', '2015-05-26 13:03:10'), (205, 78, 'TILES', '1300', '2015-05-26 13:03:10'), (206, 79, 'SAND', '560', '2015-06-11 08:09:57'), (207, 79, 'STEEL', '560', '2015-06-11 08:09:57'), (208, 79, 'JULLY', '', '2015-06-11 08:09:57'); -- -------------------------------------------------------- -- -- Table structure for table `master_category` -- CREATE TABLE IF NOT EXISTS `master_category` ( `auto_number` int(255) NOT NULL AUTO_INCREMENT, `categoryname` varchar(255) COLLATE latin1_general_ci NOT NULL, `status` varchar(255) COLLATE latin1_general_ci NOT NULL, `defaultstatus` varchar(255) COLLATE latin1_general_ci NOT NULL, `ipaddress` varchar(255) COLLATE latin1_general_ci NOT NULL, `updatetime` datetime NOT NULL, PRIMARY KEY (`auto_number`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=13 ; -- -- Dumping data for table `master_category` -- INSERT INTO `master_category` (`auto_number`, `categoryname`, `status`, `defaultstatus`, `ipaddress`, `updatetime`) VALUES (4, 'SAND', '', '', '::1', '2015-03-19 11:29:46'), (8, 'STEEL', '', '', '61.3.137.136', '2015-03-29 12:39:17'), (5, 'JULLY', '', '', '::1', '2015-03-19 11:29:53'), (7, 'CEMENT', '', '', '61.3.137.136', '2015-03-29 12:38:54'), (9, 'WOOD', '', '', '61.3.137.136', '2015-03-29 12:39:27'), (10, 'ELECTRICAL', '', '', '61.3.137.136', '2015-03-29 12:39:34'), (11, 'PLUMBING', '', '', '61.3.137.136', '2015-03-29 12:39:41'), (12, 'TILES', '', '', '61.3.137.136', '2015-03-29 12:39:47'); -- -------------------------------------------------------- -- -- Table structure for table `master_city` -- CREATE TABLE IF NOT EXISTS `master_city` ( `auto_number` int(255) NOT NULL AUTO_INCREMENT, `state` varchar(255) COLLATE latin1_general_ci DEFAULT NULL, `city` varchar(255) COLLATE latin1_general_ci DEFAULT NULL, `status` varchar(255) COLLATE latin1_general_ci NOT NULL, PRIMARY KEY (`auto_number`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1153 ; -- -- Dumping data for table `master_city` -- INSERT INTO `master_city` (`auto_number`, `state`, `city`, `status`) VALUES (1, '34', 'Achampet', ''), (2, '34', 'Addanki', ''), (3, '34', 'Adilabad', ''), (4, '34', 'Adoni', ''), (5, '34', 'Akividu', ''), (6, '34', 'Alur', ''), (7, '34', 'Amadalavalasa', ''), (8, '34', 'Amalapuram', ''), (9, '34', 'Anakapalli', ''), (10, '34', 'Anantapur', ''), (11, '34', 'Armoor', ''), (12, '34', 'Aspari', ''), (13, '34', 'Atmakur', ''), (14, '34', 'Bapatla', ''), (15, '34', 'Bhadrachalam', ''), (16, '34', 'Bhainsa', ''), (17, '34', 'Bheemunipatnam', ''), (18, '34', 'Bhimavaram', ''), (19, '34', 'Bhongir', ''), (20, '34', 'Bobbili', ''), (21, '34', 'Bodhan', ''), (22, '34', 'Chilakaluripet', ''), (23, '34', 'Chirala', ''), (24, '34', 'Chittoor', ''), (25, '34', 'Chityal', ''), (26, '34', 'Cuddapah', ''), (27, '34', 'Dharmavaram', ''), (28, '34', 'Dhone', ''), (29, '34', 'Eluru', ''), (30, '34', 'Gadwal', ''), (31, '34', 'Godavarikhani', ''), (32, '34', 'Gooty', ''), (33, '34', 'Gorantla', ''), (34, '34', 'Gudivada', ''), (35, '34', 'Gudur', ''), (36, '34', 'Guntakal', ''), (37, '34', 'Guntur', ''), (38, '34', 'Hanamkonda', ''), (39, '34', 'Hindupur', ''), (40, '34', 'Husnabad', ''), (41, '34', 'Huzur Nagar', ''), (42, '34', 'Hyderabad', ''), (43, '34', 'Ibrahimpatnam', ''), (44, '34', 'Ichapuram', ''), (45, '34', 'Jadcherla', ''), (46, '34', 'Jaggayapet', ''), (47, '34', 'Jagtial', ''), (48, '34', 'Jammalamadugu', ''), (49, '34', 'Jammikunta', ''), (50, '34', 'Jangareddygudem', ''), (51, '34', 'Kadiri', ''), (52, '34', 'Kaikaluru', ''), (53, '34', 'Kakinada', ''), (54, '34', 'Kalwakurthy', ''), (55, '34', 'Kalyandurg', ''), (56, '34', 'Kamareddy', ''), (57, '34', 'Kanigiri', ''), (58, '34', 'Karimnagar', ''), (59, '34', 'Kavali', ''), (60, '34', 'Kazipet', ''), (61, '34', 'Khammam', ''), (62, '34', 'Kodad', ''), (63, '34', 'Kodumur', ''), (64, '34', 'Koratla', ''), (65, '34', 'Kosigi', ''), (66, '34', 'Kothagudem', ''), (67, '34', 'Kuppam', ''), (68, '34', 'Kurnool', ''), (69, '34', 'Macherla', ''), (70, '34', 'Machilipatnam', ''), (71, '34', 'Madakasira', ''), (72, '34', 'Madanpalle', ''), (73, '34', 'Madhira', ''), (74, '34', 'Mahaboob Nagar', ''), (75, '34', 'Mahabubabad', ''), (76, '34', 'Mancherial', ''), (77, '34', 'Manapeta', ''), (78, '34', 'Manuguru', ''), (79, '34', 'Markapur', ''), (80, '34', 'Medchal', ''), (81, '34', 'Metpally', ''), (82, '34', 'Miryalguda', ''), (83, '34', 'Nagari', ''), (84, '34', 'Nagarjunasagar', ''), (85, '34', 'Nagarkurnool', ''), (86, '34', 'Naidupet', ''), (87, '34', 'Nakerekal', ''), (88, '34', 'Nalgonda', ''), (89, '34', 'Nanidkotkur', ''), (90, '34', 'Nandyal', ''), (91, '34', 'Narasannapeta', ''), (92, '34', 'Narasapuram', ''), (93, '34', 'Narasaraopet', ''), (94, '34', 'Narayanpet', ''), (95, '34', 'Narispatnam', ''), (96, '34', 'Nellore', ''), (97, '34', 'Neredcherla', ''), (98, '34', 'New Paloncha', ''), (99, '34', 'Nidadavole', ''), (100, '34', 'Nirmal', ''), (101, '34', 'Nizamabad', ''), (102, '34', 'Nuzuvid', ''), (103, '34', 'Ongole', ''), (104, '34', 'Palakolu', ''), (105, '34', 'Palamaner', ''), (106, '34', 'Palasa', ''), (107, '34', 'Pamidi', ''), (108, '34', 'Parvathipuram', ''), (109, '34', 'Pattikonda', ''), (110, '34', 'Peddapally', ''), (111, '34', 'Penukonda', ''), (112, '34', 'Piduguralla', ''), (113, '34', 'Piler', ''), (114, '34', 'Pithaapuram', ''), (115, '34', 'Podili', ''), (116, '34', 'Poonur', ''), (117, '34', 'Prodattur', ''), (118, '34', 'Punganur', ''), (119, '34', 'Puttaparthi', ''), (120, '34', 'Puttur', ''), (121, '34', 'Rajamundry', ''), (122, '34', 'Rajam', ''), (123, '34', 'Rajampet', ''), (124, '34', 'Ramachandrapuram', ''), (125, '34', 'Rayachotti', ''), (126, '34', 'Rayadurg', ''), (127, '34', 'Razole', ''), (128, '34', 'Sadasivpet', ''), (129, '34', 'Samalkot', ''), (130, '34', 'Sangareddy', ''), (131, '34', 'Sathupally', ''), (132, '34', 'Sattenapalli', ''), (133, '34', 'Shadnagar', ''), (134, '34', 'Secunderabad', ''), (135, '34', 'Siddipet', ''), (136, '34', 'Singarayakonda', ''), (137, '34', 'Sircilla', ''), (138, '34', 'Sirpur - Kagaznagar', ''), (139, '34', 'Sompeta', ''), (140, '34', 'Srikakulam', ''), (141, '34', 'Srikalahastri', ''), (142, '34', 'Sulurpet', ''), (143, '34', 'Suryapet', ''), (144, '34', 'Tadepalligudem', ''), (145, '34', 'Tadipatri', ''), (146, '34', 'Tandur', ''), (147, '34', 'Tanuku', ''), (148, '34', 'Tekkali', ''), (149, '34', 'Tenali', ''), (150, '34', 'Tirupathi', ''), (151, '34', 'Tuni', ''), (152, '34', 'Ulavapadu', ''), (153, '34', 'Veeraghattam', ''), (154, '34', 'Vijayawada', ''), (155, '34', 'Vikarabad', ''), (156, '34', 'Vinukonda', ''), (157, '34', 'Visakhapatnam', ''), (158, '34', 'Vizianagram', ''), (159, '34', 'Wanaparthy', ''), (160, '34', 'Warangal', ''), (161, '34', 'Wyra', ''), (162, '34', 'Yanam', ''), (163, '34', 'Yellamanchilli', ''), (164, '34', 'Yellandu', ''), (165, '34', 'Yemmiganur', ''), (166, '34', 'Yerraguntla', ''), (167, '34', 'Zaheerabad', ''), (168, 'ASSAM', 'Dhekiajuli', ''), (169, 'ASSAM', 'Dibrugarh', ''), (170, 'ASSAM', 'Digboi', ''), (171, 'ASSAM', 'Golaghaat', ''), (172, 'ASSAM', 'Guwahati', ''), (173, 'ASSAM', 'Hailakandi', ''), (174, 'ASSAM', 'Jorhat', ''), (175, 'ASSAM', 'Kumbhirgram', ''), (176, 'ASSAM', 'Lahoal', ''), (177, 'ASSAM', 'Makum', ''), (178, 'ASSAM', 'Mangaldoi', ''), (179, 'ASSAM', 'Margherita', ''), (180, 'ASSAM', 'Naharkatia', ''), (181, 'ASSAM', 'Nalbari', ''), (182, 'ASSAM', 'Namrup', ''), (183, 'ASSAM', 'Panchgram', ''), (184, 'ASSAM', 'Shivsagar', ''), (185, 'ASSAM', 'Silchar', ''), (186, 'ASSAM', 'Tengakhat', ''), (187, 'ASSAM', 'Tezpur', ''), (188, 'ASSAM', 'Tinsukia', ''), (189, 'BIHAR', 'Arrah', ''), (190, 'BIHAR', 'Baxur', ''), (191, 'BIHAR', 'Begusaria', ''), (192, 'BIHAR', 'Bettiah', ''), (193, 'BIHAR', 'Bhagalpur', ''), (194, 'BIHAR', 'Chapra', ''), (195, 'BIHAR', 'Danapore', ''), (196, 'BIHAR', 'Darbhanga', ''), (197, 'BIHAR', 'Gaya', ''), (198, 'BIHAR', 'Hazipur', ''), (199, 'BIHAR', 'Islampur', ''), (200, 'BIHAR', 'Jhajha/Jamui', ''), (201, 'BIHAR', 'Kathihar', ''), (202, 'BIHAR', 'Khagaria', ''), (203, 'BIHAR', 'Laheriasarai', ''), (204, 'BIHAR', 'Madhubani', ''), (205, 'BIHAR', 'Manhar', ''), (206, 'BIHAR', 'Munger', ''), (207, 'BIHAR', 'Mothihari', ''), (208, 'BIHAR', 'Muzaffarpur', ''), (209, 'BIHAR', 'Nawada', ''), (210, 'BIHAR', 'Patna', ''), (211, 'BIHAR', 'Purnea', ''), (212, 'BIHAR', 'Razual', ''), (213, 'BIHAR', 'Saharsha', ''), (214, 'BIHAR', 'Samastripur', ''), (215, 'BIHAR', 'Sasaram', ''), (216, 'BIHAR', 'Siwan', ''), (217, 'GUJARAT', 'Ahmedabad', ''), (218, 'GUJARAT', 'Ambaji', ''), (219, 'GUJARAT', 'Amreli', ''), (220, 'GUJARAT', 'Anand', ''), (221, 'GUJARAT', 'Anjar', ''), (222, 'GUJARAT', 'Anleshwara', ''), (223, 'GUJARAT', 'Balasinor', ''), (224, 'GUJARAT', 'Bansda', ''), (225, 'GUJARAT', 'Bardoli', ''), (226, 'GUJARAT', 'Baroda', ''), (227, 'GUJARAT', 'Bawla', ''), (228, 'GUJARAT', 'Becharaji', ''), (229, 'GUJARAT', 'Bhabhar', ''), (230, 'GUJARAT', 'Bhachau', ''), (231, 'GUJARAT', 'Bhanvad', ''), (232, 'GUJARAT', 'Bharuch', ''), (233, 'GUJARAT', 'Bhatia', ''), (234, 'GUJARAT', 'Bhavnagar', ''), (235, 'GUJARAT', 'Bhildi', ''), (236, 'GUJARAT', 'Bhuj', ''), (237, 'GUJARAT', 'Billimora', ''), (238, 'GUJARAT', 'Borsad', ''), (239, 'GUJARAT', 'Botad', ''), (240, 'GUJARAT', 'Chanasma', ''), (241, 'GUJARAT', 'Chhatral', ''), (242, 'GUJARAT', 'Dabhoi', ''), (243, 'GUJARAT', 'Dahod', ''), (244, 'GUJARAT', 'Daman', ''), (245, 'GUJARAT', 'Danta', ''), (246, 'GUJARAT', 'Deesa', ''), (247, 'GUJARAT', 'Dehgam', ''), (248, 'GUJARAT', 'Deodar', ''), (249, 'GUJARAT', 'Dhandhuka', ''), (250, 'GUJARAT', 'Dhangadra', ''), (251, 'GUJARAT', 'Dhoraji', ''), (252, 'GUJARAT', 'Diu', ''), (253, 'GUJARAT', 'Dwarka', ''), (254, 'GUJARAT', 'Fort Songadh', ''), (255, 'GUJARAT', 'Gandevi', ''), (256, 'GUJARAT', 'Gandhi Nagar', ''), (257, 'GUJARAT', 'Gandhidham', ''), (258, 'GUJARAT', 'Godhra', ''), (259, 'GUJARAT', 'Gondal', ''), (260, 'GUJARAT', 'Halol', ''), (261, 'GUJARAT', 'Harij', ''), (262, 'GUJARAT', 'Himmat Nagar', ''), (263, 'GUJARAT', 'Idar', ''), (264, 'GUJARAT', 'Jam Nagar', ''), (265, 'GUJARAT', 'Jafarabad', ''), (266, 'GUJARAT', 'Jam Khambaliya', ''), (267, 'GUJARAT', 'Jetpur', ''), (268, 'GUJARAT', 'Junagadh', ''), (269, 'GUJARAT', 'Kadi', ''), (270, 'GUJARAT', 'Kadodara', ''), (271, 'GUJARAT', 'Kalol', ''), (272, 'GUJARAT', 'Kamrej', ''), (273, 'GUJARAT', 'Kapadwanj', ''), (274, 'GUJARAT', 'Khambhat', ''), (275, 'GUJARAT', 'Khedbrahma', ''), (276, 'GUJARAT', 'Kim', ''), (277, 'GUJARAT', 'Kodinar', ''), (278, 'GUJARAT', 'Mahuva', ''), (279, 'GUJARAT', 'Mandvi', ''), (280, 'GUJARAT', 'Markapur', ''), (281, 'GUJARAT', 'Mathur', ''), (282, 'GUJARAT', 'Modasa', ''), (283, 'GUJARAT', 'Mundra', ''), (284, 'GUJARAT', 'Morbi', ''), (285, 'GUJARAT', 'Nabaranagpur', ''), (286, 'GUJARAT', 'Nadiad', ''), (287, 'GUJARAT', 'Nakhatrana', ''), (288, 'GUJARAT', 'Naliya Kutch', ''), (289, 'GUJARAT', 'Navasari', ''), (290, 'GUJARAT', 'Palanupur', ''), (291, 'GUJARAT', 'Patna', ''), (292, 'GUJARAT', 'Porbandar', ''), (293, 'GUJARAT', 'Palej', ''), (294, 'GUJARAT', 'Palitana', ''), (295, 'GUJARAT', 'Petlad', ''), (296, 'GUJARAT', 'Prantiz', ''), (297, 'GUJARAT', 'Rajkot', ''), (298, 'GUJARAT', 'Rhapar', ''), (299, 'GUJARAT', 'SKV Nagar', ''), (300, 'GUJARAT', 'Sachin', ''), (301, 'GUJARAT', 'Sadarkundla', ''), (302, 'GUJARAT', 'Salal', ''), (303, 'GUJARAT', 'Samakhiyali', ''), (304, 'GUJARAT', 'Sarigam', ''), (305, 'GUJARAT', 'Savarkundla', ''), (306, 'GUJARAT', 'Shamlaji', ''), (307, 'GUJARAT', 'Shihori', ''), (308, 'GUJARAT', 'Siddhpur', ''), (309, 'GUJARAT', 'Sihor', ''), (310, 'GUJARAT', 'Siivassa', ''), (311, 'GUJARAT', 'Sojat City', ''), (312, 'GUJARAT', 'Somnath', ''), (313, 'GUJARAT', 'Surat', ''), (314, 'GUJARAT', 'Surendra Nagar', ''), (315, 'GUJARAT', 'Talaja', ''), (316, 'GUJARAT', 'Talod', ''), (317, 'GUJARAT', 'Unjha', ''), (318, 'GUJARAT', 'Umbergaon', ''), (319, 'GUJARAT', 'Umreth', ''), (320, 'GUJARAT', 'Una', ''), (321, 'GUJARAT', 'Upleta', ''), (322, 'GUJARAT', 'Vadnagar', ''), (323, 'GUJARAT', 'Vallabh Vidhyanagar', ''), (324, 'GUJARAT', 'Valsad', ''), (325, 'GUJARAT', 'Vapi', ''), (326, 'GUJARAT', 'Veraval', ''), (327, 'GUJARAT', 'Vijapur', ''), (328, 'GUJARAT', 'Visnagar', ''), (329, 'GUJARAT', 'Vyara', ''), (330, 'GUJARAT', 'Waghodia', ''), (331, 'HIMACHAL PRADESH', 'Nangal', ''), (332, 'HIMACHAL PRADESH', 'Palampur', ''), (333, 'HIMACHAL PRADESH', 'Parwanoo', ''), (334, 'HIMACHAL PRADESH', 'Ropar', ''), (335, 'HIMACHAL PRADESH', 'Shimla', ''), (336, 'HIMACHAL PRADESH', 'Una', ''), (337, 'HARYANA', 'Ambala Cantt', ''), (338, 'HARYANA', 'Bahadurgarh', ''), (339, 'HARYANA', 'Bhibani', ''), (340, 'HARYANA', 'Dharuhera', ''), (341, 'HARYANA', 'Faridabad', ''), (342, 'HARYANA', 'Gurgaon', ''), (343, 'HARYANA', 'Hansi', ''), (344, 'HARYANA', 'Hissar', ''), (345, 'HARYANA', 'Jagadhri', ''), (346, 'HARYANA', 'Jhajjar', ''), (347, 'HARYANA', 'Jind', ''), (348, 'HARYANA', 'Kaithal', ''), (349, 'HARYANA', 'Karnal', ''), (350, 'HARYANA', 'Kurukshetra', ''), (351, 'HARYANA', 'Narnaul', ''), (352, 'HARYANA', 'Panipet', ''), (353, 'HARYANA', 'Rohtak', ''), (354, 'HARYANA', 'Sirsa', ''), (355, 'HARYANA', 'sonipat', ''), (356, 'HARYANA', 'Yanunanagar', ''), (357, 'JAMMU & KASHMIR', 'Jammu', ''), (358, 'JAMMU & KASHMIR', 'Srinagar', ''), (359, 'JHARKHAND', 'Bokaro', ''), (360, 'JHARKHAND', 'Chas', ''), (361, 'JHARKHAND', 'Cirkunda', ''), (362, 'JHARKHAND', 'Daltonganj', ''), (363, 'JHARKHAND', 'Deoghar', ''), (364, 'JHARKHAND', 'Dhanbad', ''), (365, 'JHARKHAND', 'Dumka', ''), (366, 'JHARKHAND', 'Giridih', ''), (367, 'JHARKHAND', 'Hazaribagh', ''), (368, 'JHARKHAND', 'Jamshedpur', ''), (369, 'JHARKHAND', 'Jhumir Tilaya', ''), (370, 'JHARKHAND', 'Madhupur', ''), (371, 'JHARKHAND', 'Phusro Bazar', ''), (372, 'JHARKHAND', 'Ramgarh', ''), (373, 'JHARKHAND', 'Ranchi', ''), (374, 'KARNATAKA', 'Ajjampura', ''), (375, 'KARNATAKA', 'Aland', ''), (376, 'KARNATAKA', 'Ankola ', ''), (377, 'KARNATAKA', 'Arkalgud', ''), (378, 'KARNATAKA', 'Arsikere', ''), (379, 'KARNATAKA', 'Athani', ''), (380, 'KARNATAKA', 'Aurad', ''), (381, 'KARNATAKA', 'BC Road', ''), (382, 'KARNATAKA', 'BR Project', ''), (383, 'KARNATAKA', 'Badami', ''), (384, 'KARNATAKA', 'Bagalkot', ''), (385, 'KARNATAKA', 'Bagepalli', ''), (386, 'KARNATAKA', 'Baikampady', ''), (387, 'KARNATAKA', 'Baithongal', ''), (388, 'KARNATAKA', 'Balehonnur', ''), (389, 'KARNATAKA', 'Bangalore', ''), (390, 'KARNATAKA', 'Bangarpet', ''), (391, 'KARNATAKA', 'Banhatti', ''), (392, 'KARNATAKA', 'Basavakalyan', ''), (393, 'KARNATAKA', 'Basavan Bagewadi', ''), (394, 'KARNATAKA', 'Belgaum', ''), (395, 'KARNATAKA', 'Bellary', ''), (396, 'KARNATAKA', 'Belthangady', ''), (397, 'KARNATAKA', 'Belur', ''), (398, 'KARNATAKA', 'Bhadravathi', ''), (399, 'KARNATAKA', 'Bhalki', ''), (400, 'KARNATAKA', 'Bhatkal', ''), (401, 'KARNATAKA', 'Bidadi', ''), (402, 'KARNATAKA', 'Bidar', ''), (403, 'KARNATAKA', 'Bilagi', ''), (404, 'KARNATAKA', 'Byadgi', ''), (405, 'KARNATAKA', 'Bhamrajnagar', ''), (406, 'KARNATAKA', 'Challakere', ''), (407, 'KARNATAKA', 'Channapatna', ''), (408, 'KARNATAKA', 'Chemmad', ''), (409, 'KARNATAKA', 'Chickballapur', ''), (410, 'KARNATAKA', 'Chickmagalur', ''), (411, 'KARNATAKA', 'Chicknayakanahalli', ''), (412, 'KARNATAKA', 'Chikodi', ''), (413, 'KARNATAKA', 'Chincholi', ''), (414, 'KARNATAKA', 'Chintamani', ''), (415, 'KARNATAKA', 'Chitradurga', ''), (416, 'KARNATAKA', 'Dadur', ''), (417, 'KARNATAKA', 'Dandeli', ''), (418, 'KARNATAKA', 'Davamgere', ''), (419, 'KARNATAKA', 'Dharwad', ''), (420, 'KARNATAKA', 'Doddaballapur', ''), (421, 'KARNATAKA', 'Gadag', ''), (422, 'KARNATAKA', 'Gajendragad', ''), (423, 'KARNATAKA', 'Gangavathi', ''), (424, 'KARNATAKA', 'Gauribidanur', ''), (425, 'KARNATAKA', 'Gokak', ''), (426, 'KARNATAKA', 'Gokaran', ''), (427, 'KARNATAKA', 'Gonikoppal', ''), (428, 'KARNATAKA', 'Gubbiu', ''), (429, 'KARNATAKA', 'Gulbarga', ''), (430, 'KARNATAKA', 'Guledagudda', ''), (431, 'KARNATAKA', 'Gundlupet', ''), (432, 'KARNATAKA', 'Hagari Bommanahalli', ''), (433, 'KARNATAKA', 'Hanagal', ''), (434, 'KARNATAKA', 'Harihar', ''), (435, 'KARNATAKA', 'Harapanhalli', ''), (436, 'KARNATAKA', 'Hassan', ''), (437, 'KARNATAKA', 'Haveri', ''), (438, 'KARNATAKA', 'Hebri', ''), (439, 'KARNATAKA', 'Hirekerur', ''), (440, 'KARNATAKA', 'Hiriyur', ''), (441, 'KARNATAKA', 'Holakere', ''), (442, 'KARNATAKA', 'Holenarasipur', ''), (443, 'KARNATAKA', 'Honnali', ''), (444, 'KARNATAKA', 'Honnavar', ''), (445, 'KARNATAKA', 'Hosadurga', ''), (446, 'KARNATAKA', 'Hosanagara', ''), (447, 'KARNATAKA', 'Hospet', ''), (448, 'KARNATAKA', 'Hubli', ''), (449, 'KARNATAKA', 'Huliyar', ''), (450, 'KARNATAKA', 'Humnabad', ''), (451, 'KARNATAKA', 'Hungud', ''), (452, 'KARNATAKA', 'Huvinahadagali', ''), (453, 'KARNATAKA', 'Ilkal', ''), (454, 'KARNATAKA', 'Indi', ''), (455, 'KARNATAKA', 'Jamkhandi', ''), (456, 'KARNATAKA', 'Jagalur', ''), (457, 'KARNATAKA', 'KGF', ''), (458, 'KARNATAKA', 'Kalasa', ''), (459, 'KARNATAKA', 'Kampli', ''), (460, 'KARNATAKA', 'Kanahosahalli', ''), (461, 'KARNATAKA', 'Kanakapura', ''), (462, 'KARNATAKA', 'Karkala', ''), (463, 'KARNATAKA', 'Kartagi', ''), (464, 'KARNATAKA', 'Karwar', ''), (465, 'KARNATAKA', 'Kolar', ''), (466, 'KARNATAKA', 'Koppa', ''), (467, 'KARNATAKA', 'Koppal', ''), (468, 'KARNATAKA', 'Koratagere', ''), (469, 'KARNATAKA', 'Krishnaraja Nagar', ''), (470, 'KARNATAKA', 'Krishnarajapete', ''), (471, 'KARNATAKA', 'Kudiligi', ''), (472, 'KARNATAKA', 'Kumta', ''), (473, 'KARNATAKA', 'Kundapura', ''), (474, 'KARNATAKA', 'Kunnigal', ''), (475, 'KARNATAKA', 'Kushal Nagar', ''), (476, 'KARNATAKA', 'Kushtagi', ''), (477, 'KARNATAKA', 'Lakshmeshwar', ''), (478, 'KARNATAKA', 'Lingsugar', ''), (479, 'KARNATAKA', 'Lonawala', ''), (480, 'KARNATAKA', 'Maddur', ''), (481, 'KARNATAKA', 'Madhugiri', ''), (482, 'KARNATAKA', 'Magadi', ''), (483, 'KARNATAKA', 'Mallapur', ''), (484, 'KARNATAKA', 'Malur', ''), (485, 'KARNATAKA', 'Mandya', ''), (486, 'KARNATAKA', 'Mangalore', ''), (487, 'KARNATAKA', 'manipal', ''), (488, 'KARNATAKA', 'Manvi', ''), (489, 'KARNATAKA', 'Molakalmuru', ''), (490, 'KARNATAKA', 'Moodbidri', ''), (491, 'KARNATAKA', 'Muddebihal', ''), (492, 'KARNATAKA', 'Mudhol', ''), (493, 'KARNATAKA', 'Mudigere', ''), (494, 'KARNATAKA', 'Mulbagal', ''), (495, 'KARNATAKA', 'Mulki', ''), (496, 'KARNATAKA', 'Mundargi', ''), (497, 'KARNATAKA', 'Mysore', ''), (498, 'KARNATAKA', 'Nagamangala', ''), (499, 'KARNATAKA', 'Nanjangud', ''), (500, 'KARNATAKA', 'Narasimharajapura', ''), (501, 'KARNATAKA', 'Nargund', ''), (502, 'KARNATAKA', 'Nelamangala', ''), (503, 'KARNATAKA', 'Nellyadi', ''), (504, 'KARNATAKA', 'Neyyattinkara', ''), (505, 'KARNATAKA', 'Nippani', ''), (506, 'KARNATAKA', 'Nyamati', ''), (507, 'KARNATAKA', 'Pavagada', ''), (508, 'KARNATAKA', 'Raichur', ''), (509, 'KARNATAKA', 'Ramanagaram', ''), (510, 'KARNATAKA', 'Ramdurg', ''), (511, 'KARNATAKA', 'Rajaji Nagar', ''), (512, 'KARNATAKA', 'Ranebennur', ''), (513, 'KARNATAKA', 'Sagar', ''), (514, 'KARNATAKA', 'Sakleshpur', ''), (515, 'KARNATAKA', 'Sandur', ''), (516, 'KARNATAKA', 'Sankeshwar', ''), (517, 'KARNATAKA', 'Saundatti', ''), (518, 'KARNATAKA', 'Savanur', ''), (519, 'KARNATAKA', 'Sawantwadi', ''), (520, 'KARNATAKA', 'Sedam', ''), (521, 'KARNATAKA', 'Shahabad', ''), (522, 'KARNATAKA', 'Shahapur', ''), (523, 'KARNATAKA', 'Shikaripur', ''), (524, 'KARNATAKA', 'Shimoga', ''), (525, 'KARNATAKA', 'Shravanabelagola', ''), (526, 'KARNATAKA', 'Siddapur', ''), (527, 'KARNATAKA', 'Siddapur (Kodagu)', ''), (528, 'KARNATAKA', 'Sidlaghatta', ''), (529, 'KARNATAKA', 'Sindgi', ''), (530, 'KARNATAKA', 'Sindhanur', ''), (531, 'KARNATAKA', 'Sira', ''), (532, 'KARNATAKA', 'Sirsi', ''), (533, 'KARNATAKA', 'Siruguppa', ''), (534, 'KARNATAKA', 'Somwarpet', ''), (535, 'KARNATAKA', 'Sorab', ''), (536, 'KARNATAKA', 'Sringeri', ''), (537, 'KARNATAKA', 'Srinivasapura', ''), (538, 'KARNATAKA', 'Srirangapatna', ''), (539, 'KARNATAKA', 'Sullia', ''), (540, 'KARNATAKA', 'Tarikere', ''), (541, 'KARNATAKA', 'Thirthahalli', ''), (542, 'KARNATAKA', 'Tiptur', ''), (543, 'KARNATAKA', 'Tumkur', ''), (544, 'KARNATAKA', 'Turuvakere', ''), (545, 'KARNATAKA', 'Udupi', ''), (546, 'KARNATAKA', 'Uppinangady', ''), (547, 'KARNATAKA', 'Virajpet', ''), (548, 'KARNATAKA', 'Vittal', ''), (549, 'KARNATAKA', 'Wadi', ''), (550, 'KARNATAKA', 'Yadagiri', ''), (551, 'KARNATAKA', 'Yelburga', ''), (552, 'KARNATAKA', 'Yellapur', ''), (553, 'KERALA', 'Adimally', ''), (554, 'KERALA', 'Adoor', ''), (555, 'KERALA', 'Alleppey', ''), (556, 'KERALA', 'Afzalpur', ''), (557, 'KERALA', 'Alwaye', ''), (558, 'KERALA', 'Angamally', ''), (559, 'KERALA', 'Attingal', ''), (560, 'KERALA', 'Chalakudi', ''), (561, 'KERALA', 'Chenganacherry', ''), (562, 'KERALA', 'Chengannur', ''), (563, 'KERALA', 'Cherpulachery', ''), (564, 'KERALA', 'Chingavanam', ''), (565, 'KERALA', 'Cochin', ''), (566, 'KERALA', 'Ernakulam', ''), (567, 'KERALA', 'Edappal', ''), (568, 'KERALA', 'Erattupetta', ''), (569, 'KERALA', 'Ettumanoor', ''), (570, 'KERALA', 'Guruvayoor', ''), (571, 'KERALA', 'Iritty', ''), (572, 'KERALA', 'Kalpetta', ''), (573, 'KERALA', 'Kanhangad', ''), (574, 'KERALA', 'Kanjirapally', ''), (575, 'KERALA', 'Kannur', ''), (576, 'KERALA', 'Karunagapally', ''), (577, 'KERALA', 'Kasaragode', ''), (578, 'KERALA', 'Kattappana', ''), (579, 'KERALA', 'Kayamkulam', ''), (580, 'KERALA', 'Kodungalur', ''), (581, 'KERALA', 'Kolencherry', ''), (582, 'KERALA', 'Kollam', ''), (583, 'KERALA', 'Kollegal', ''), (584, 'KERALA', 'Kondotty', ''), (585, 'KERALA', 'Koothattukulam', ''), (586, 'KERALA', 'Kothamangalam', ''), (587, 'KERALA', 'Kottakal', ''), (588, 'KERALA', 'Kottarakara', ''), (589, 'KERALA', 'Kottayam', ''), (590, 'KERALA', 'Kotturu', ''), (591, 'KERALA', 'Kozhikode', ''), (592, 'KERALA', 'Kumili', ''), (593, 'KERALA', 'Kunnamkulam', ''), (594, 'KERALA', 'Kuthuparamba', ''), (595, 'KERALA', 'Malappuram', ''), (596, 'KERALA', 'Mahe', ''), (597, 'KERALA', 'Manjeri', ''), (598, 'KERALA', 'Mannarghat', ''), (599, 'KERALA', 'Mavelikara', ''), (600, 'KERALA', 'Munnar', ''), (601, 'KERALA', 'Muvattupuzhaa', ''), (602, 'KERALA', 'N-Parru', ''), (603, 'KERALA', 'Nedumangad', ''), (604, 'KERALA', 'Nilambur', ''), (605, 'KERALA', 'Ottapalam', ''), (606, 'KERALA', 'Olavakkot', ''), (607, 'KERALA', 'Pala', ''), (608, 'KERALA', 'Palakkad', ''), (609, 'KERALA', 'Parappanangadi', ''), (610, 'KERALA', 'Pampady', ''), (611, 'KERALA', 'Pathananthitta', ''), (612, 'KERALA', 'Pattambi', ''), (613, 'KERALA', 'Payyanoor', ''), (614, 'KERALA', 'Perinthalmanna', ''), (615, 'KERALA', 'Perumbavoor', ''), (616, 'KERALA', 'Ponkunnam', ''), (617, 'KERALA', 'Ponnani', ''), (618, 'KERALA', 'Punalur', ''), (619, 'KERALA', 'Puthanathani', ''), (620, 'KERALA', 'Quilandy', ''), (621, 'KERALA', 'Ranny', ''), (622, 'KERALA', 'Taliparamba', ''), (623, 'KERALA', 'Tellicherry', ''), (624, 'KERALA', 'Sherthally', ''), (625, 'KERALA', 'Shornur', ''), (626, 'KERALA', 'Tenjipalam', ''), (627, 'KERALA', 'Thalyolaparambu', ''), (628, 'KERALA', 'Thiruvalla', ''), (629, 'KERALA', 'Thiruvananthapuram', ''), (630, 'KERALA', 'Thodupuzha', ''), (631, 'KERALA', 'Thrichur', ''), (632, 'KERALA', 'Thycaud', ''), (633, 'KERALA', 'Tirur', ''), (634, 'KERALA', 'Valancherry', ''), (635, 'KERALA', 'Vadagara', ''), (636, 'KERALA', 'Varkala', ''), (637, 'KERALA', 'Wadakkancherry', ''), (638, 'KERALA', 'Wandoor', ''), (639, 'MAHARASHTRA', 'Ahmednagar', ''), (640, 'MAHARASHTRA', 'Akluj', ''), (641, 'MAHARASHTRA', 'Akalkot', ''), (642, 'MAHARASHTRA', 'Akola', ''), (643, 'MAHARASHTRA', 'Alibag', ''), (644, 'MAHARASHTRA', 'Asangaon', ''), (645, 'MAHARASHTRA', 'Amravati', ''), (646, 'MAHARASHTRA', 'Aurangabad', ''), (647, 'MAHARASHTRA', 'Baramati', ''), (648, 'MAHARASHTRA', 'Beed', ''), (649, 'MAHARASHTRA', 'Barshi', ''), (650, 'MAHARASHTRA', 'Bhandara', ''), (651, 'MAHARASHTRA', 'Bhabani Nagar', ''), (652, 'MAHARASHTRA', 'Bhusawal', ''), (653, 'MAHARASHTRA', 'Bhiwandi', ''), (654, 'MAHARASHTRA', 'Bhayander', ''), (655, 'MAHARASHTRA', 'Chalisgaon', ''), (656, 'MAHARASHTRA', 'Chakan', ''), (657, 'MAHARASHTRA', 'Chalisgaon', ''), (658, 'MAHARASHTRA', 'Changrapur', ''), (659, 'MAHARASHTRA', 'Chiplun', ''), (660, 'MAHARASHTRA', 'Deolali', ''), (661, 'MAHARASHTRA', 'Dindori', ''), (662, 'MAHARASHTRA', 'Dhule', ''), (663, 'MAHARASHTRA', 'Dombivili', ''), (664, 'MAHARASHTRA', 'Gondia Hongoli', ''), (665, 'MAHARASHTRA', 'Ichalkaranji', ''), (666, 'MAHARASHTRA', 'Islampur', ''), (667, 'MAHARASHTRA', 'Irrinjalakuda', ''), (668, 'MAHARASHTRA', 'Jalgaon', ''), (669, 'MAHARASHTRA', 'Jalna', ''), (670, 'MAHARASHTRA', 'Jamkhed', ''), (671, 'MAHARASHTRA', 'Jaysingpur', ''), (672, 'MAHARASHTRA', 'Junnar', ''), (673, 'MAHARASHTRA', 'Karanja', ''), (674, 'MAHARASHTRA', 'Kem', ''), (675, 'MAHARASHTRA', 'Karad', ''), (676, 'MAHARASHTRA', 'Khamgaon', ''), (677, 'MAHARASHTRA', 'Khopoli', ''), (678, 'MAHARASHTRA', 'Kolhapur', ''), (679, 'MAHARASHTRA', 'Kolhar', ''), (680, 'MAHARASHTRA', 'Koregaon', ''), (681, 'MAHARASHTRA', 'Loni', ''), (682, 'MAHARASHTRA', 'Lonand', ''), (683, 'MAHARASHTRA', 'Latur', ''), (684, 'MAHARASHTRA', 'Mahod', ''), (685, 'MAHARASHTRA', 'Malegaon ', ''), (686, 'MAHARASHTRA', 'Malkapur', ''), (687, 'MAHARASHTRA', 'Manchar', ''), (688, 'MAHARASHTRA', 'Manmad', ''), (689, 'MAHARASHTRA', 'Miraj', ''), (690, 'MAHARASHTRA', 'Mohol', ''), (691, 'MAHARASHTRA', 'Mumbai - Kurla', ''), (692, 'MAHARASHTRA', 'Mumbai - Vileparle', ''), (693, 'MAHARASHTRA', 'Murtizapur', ''), (694, 'MAHARASHTRA', 'Nagpur', ''), (695, 'MAHARASHTRA', 'Nandurbar', ''), (696, 'MAHARASHTRA', 'Nanded', ''), (697, 'MAHARASHTRA', 'Nashik', ''), (698, 'MAHARASHTRA', 'Natepute', ''), (699, 'MAHARASHTRA', 'Navapur', ''), (700, 'MAHARASHTRA', 'Neera', ''), (701, 'MAHARASHTRA', 'Omerga', ''), (702, 'MAHARASHTRA', 'Osmanabad', ''), (703, 'MAHARASHTRA', 'Panchgani', ''), (704, 'MAHARASHTRA', 'Pandharpur', ''), (705, 'MAHARASHTRA', 'Parbhani', ''), (706, 'MAHARASHTRA', 'Pen Wadkhaad', ''), (707, 'MAHARASHTRA', 'Phaltan', ''), (708, 'MAHARASHTRA', 'Pune', ''), (709, 'MAHARASHTRA', 'Raigad (Panvel)', ''), (710, 'MAHARASHTRA', 'Rahuri', ''), (711, 'MAHARASHTRA', 'Ratnagiri', ''), (712, 'MAHARASHTRA', 'Roha', ''), (713, 'MAHARASHTRA', 'Sanaswadi', ''), (714, 'MAHARASHTRA', 'Sangli', ''), (715, 'MAHARASHTRA', 'Sangamner', ''), (716, 'MAHARASHTRA', 'Sawanswadi', ''), (717, 'MAHARASHTRA', 'Satara', ''), (718, 'MAHARASHTRA', 'Satpur', ''), (719, 'MAHARASHTRA', 'Shahada', ''), (720, 'MAHARASHTRA', 'Shevgaon', ''), (721, 'MAHARASHTRA', 'Shirdi', ''), (722, 'MAHARASHTRA', 'Shirpur', ''), (723, 'MAHARASHTRA', 'Shirval', ''), (724, 'MAHARASHTRA', 'Solapur', ''), (725, 'MAHARASHTRA', 'Supa', ''), (726, 'MAHARASHTRA', 'Sinnar', ''), (727, 'MAHARASHTRA', 'Shrirampur', ''), (728, 'MAHARASHTRA', 'Taloja (Kalamboli)', ''), (729, 'MAHARASHTRA', 'Tarapur', ''), (730, 'MAHARASHTRA', 'Thane', ''), (731, 'MAHARASHTRA', 'Tasgaon', ''), (732, 'MAHARASHTRA', 'Udgir', ''), (733, 'MAHARASHTRA', 'UmbrajVita', ''), (734, 'MAHARASHTRA', 'Wardah', ''), (735, 'MAHARASHTRA', 'Wagholi', ''), (736, 'MAHARASHTRA', 'Wai', ''), (737, 'MAHARASHTRA', 'Waluj', ''), (738, 'MAHARASHTRA', 'Washim', ''), (739, 'MAHARASHTRA', 'Yavatmal', ''), (740, 'MADHYA PRADESH', 'Balaghat', ''), (741, 'MADHYA PRADESH', 'Betual', ''), (742, 'MADHYA PRADESH', 'Bhikkamgaon', ''), (743, 'MADHYA PRADESH', 'Bhopal', ''), (744, 'MADHYA PRADESH', 'Bina', ''), (745, 'MADHYA PRADESH', 'Burthanpur', ''), (746, 'MADHYA PRADESH', 'Burhar', ''), (747, 'MADHYA PRADESH', 'Chhatarpur', ''), (748, 'MADHYA PRADESH', 'Chhindwara', ''), (749, 'MADHYA PRADESH', 'Damoh', ''), (750, 'MADHYA PRADESH', 'Dewas', ''), (751, 'MADHYA PRADESH', 'Dhamnod', ''), (752, 'MADHYA PRADESH', 'Dhanora', ''), (753, 'MADHYA PRADESH', 'Dhar', ''), (754, 'MADHYA PRADESH', 'Dhooma', ''), (755, 'MADHYA PRADESH', 'Ganjbasoda', ''), (756, 'MADHYA PRADESH', 'Gotegaon', ''), (757, 'MADHYA PRADESH', 'Guna', ''), (758, 'MADHYA PRADESH', 'Gwalior', ''), (759, 'MADHYA PRADESH', 'Hoshangabad', ''), (760, 'MADHYA PRADESH', 'Harda', ''), (761, 'MADHYA PRADESH', 'Itarsi', ''), (762, 'MADHYA PRADESH', 'Indore', ''), (763, 'MADHYA PRADESH', 'Jabalpur', ''), (764, 'MADHYA PRADESH', 'Jhabua', ''), (765, 'MADHYA PRADESH', 'Kahanikareli', ''), (766, 'MADHYA PRADESH', 'Katni', ''), (767, 'MADHYA PRADESH', 'Keolari', ''), (768, 'MADHYA PRADESH', 'Khandwa', ''), (769, 'MADHYA PRADESH', 'Khargone', ''), (770, 'MADHYA PRADESH', 'Lakhanadone', ''), (771, 'MADHYA PRADESH', 'Maihar', ''), (772, 'MADHYA PRADESH', 'Malanpur', ''), (773, 'MADHYA PRADESH', 'Mandla', ''), (774, 'MADHYA PRADESH', 'Mandsour', ''), (775, 'MADHYA PRADESH', 'Mhow', ''), (776, 'MADHYA PRADESH', 'Morena', ''), (777, 'MADHYA PRADESH', 'Nagda', ''), (778, 'MADHYA PRADESH', 'Narsinghpur', ''), (779, 'MADHYA PRADESH', 'Neemuch', ''), (780, 'MADHYA PRADESH', 'Pandurana', ''), (781, 'MADHYA PRADESH', 'Parasia', ''), (782, 'MADHYA PRADESH', 'Pithampur', ''), (783, 'MADHYA PRADESH', 'Rathlam', ''), (784, 'MADHYA PRADESH', 'Rewa', ''), (785, 'MADHYA PRADESH', 'Sagar ', ''), (786, 'MADHYA PRADESH', 'Sanawad', ''), (787, 'MADHYA PRADESH', 'Satna', ''), (788, 'MADHYA PRADESH', 'Sehore', ''), (789, 'MADHYA PRADESH', 'Seoni', ''), (790, 'MADHYA PRADESH', 'Shahdol', ''), (791, 'MADHYA PRADESH', 'Shivpuri', ''), (792, 'MADHYA PRADESH', 'Singrauli', ''), (793, 'MADHYA PRADESH', 'Sihora', ''), (794, 'MADHYA PRADESH', 'Tikamgarh', ''), (795, 'MADHYA PRADESH', 'Ujjain', ''), (796, 'MADHYA PRADESH', 'Vidisha', ''), (797, 'MANIPUR', 'Imphal', ''), (798, 'MEGHALAYA', 'Shilong', ''), (799, 'NAGALAND', 'Dimapur', ''), (800, 'ORISSA', 'Angul', ''), (801, 'ORISSA', 'Aska', ''), (802, 'ORISSA', 'Balasore', ''), (803, 'ORISSA', 'Baraut', ''), (804, 'ORISSA', 'Barbil', ''), (805, 'ORISSA', 'Bareilly', ''), (806, 'ORISSA', 'Bargar', ''), (807, 'ORISSA', 'Baripada', ''), (808, 'ORISSA', 'Berhampur', ''), (809, 'ORISSA', 'Bhadrak', ''), (810, 'ORISSA', 'Bolangir', ''), (811, 'ORISSA', 'Bhawanipatna', ''), (812, 'ORISSA', 'Bhubaneswar', ''), (813, 'ORISSA', 'Cuttack', ''), (814, 'ORISSA', 'Dhenkanal', ''), (815, 'ORISSA', 'Daranjodi', ''), (816, 'ORISSA', 'Jagatsingpur', ''), (817, 'ORISSA', 'Jajpur Road', ''), (818, 'ORISSA', 'Junagarh', ''), (819, 'ORISSA', 'Jeypore', ''), (820, 'ORISSA', 'Jharsuguda', ''), (821, 'ORISSA', 'Kalahandi', ''), (822, 'ORISSA', 'Kamakhya Nagar', ''), (823, 'ORISSA', 'Kania - NTPC', ''), (824, 'ORISSA', 'Kendrapara', ''), (825, 'ORISSA', 'Keonjhar', ''), (826, 'ORISSA', 'Koraput', ''), (827, 'ORISSA', 'Malkangiri', ''), (828, 'ORISSA', 'Nawarangapur', ''), (829, 'ORISSA', 'Nayagarh', ''), (830, 'ORISSA', 'Pradeep', ''), (831, 'ORISSA', 'Patnagarh', ''), (832, 'ORISSA', 'Pipli', ''), (833, 'ORISSA', 'Puri', ''), (834, 'ORISSA', 'Rourkela', ''), (835, 'ORISSA', 'Sambalpur', ''), (836, 'ORISSA', 'Sundargargh', ''), (837, 'ORISSA', 'Sonpur', ''), (838, 'ORISSA', 'Sunabeda', ''), (839, 'ORISSA', 'Talcher', ''), (840, 'ORISSA', 'Tangi', ''), (841, 'ORISSA', 'Titilagarh', ''), (842, 'PUNJAB', 'Amritsar', ''), (843, 'PUNJAB', 'Bathinda', ''), (844, 'PUNJAB', 'Batala', ''), (845, 'PUNJAB', 'Chandigarh', ''), (846, 'PUNJAB', 'Gururdaspur', ''), (847, 'PUNJAB', 'Hoshiarpur', ''), (848, 'PUNJAB', 'Jalandhar ', ''), (849, 'PUNJAB', 'Kapurthala', ''), (850, 'PUNJAB', 'Khanna', ''), (851, 'PUNJAB', 'Ludhiana', ''), (852, 'PUNJAB', 'Malerkotta', ''), (853, 'PUNJAB', 'Malout', ''), (854, 'PUNJAB', 'Mandi Gobindgarh', ''), (855, 'PUNJAB', 'Mohali', ''), (856, 'PUNJAB', 'Nabha', ''), (857, 'PUNJAB', 'Moga', ''), (858, 'PUNJAB', 'Pachkula', ''), (859, 'PUNJAB', 'Pathankot', ''), (860, 'PUNJAB', 'Patiala', ''), (861, 'PUNJAB', 'Phagwara', ''), (862, 'PUNJAB', 'Rajpura', ''), (863, 'PUNJAB', 'Rayagada', ''), (864, 'PUNJAB', 'Rayya', ''), (865, 'PUNJAB', 'Sirhind', ''), (866, 'PUNJAB', 'Zirakpur', ''), (867, 'RAJASTHAN', 'Ajmer', ''), (868, 'RAJASTHAN', 'Alwar', ''), (869, 'RAJASTHAN', 'Antah', ''), (870, 'RAJASTHAN', 'Balotra', ''), (871, 'RAJASTHAN', 'Banswara', ''), (872, 'RAJASTHAN', 'Baran', ''), (873, 'RAJASTHAN', 'Barmer', ''), (874, 'RAJASTHAN', 'Bharatpur', ''), (875, 'RAJASTHAN', 'Bhavani Mandi', ''), (876, 'RAJASTHAN', 'Bhilwara', ''), (877, 'RAJASTHAN', 'Bhinmal', ''), (878, 'RAJASTHAN', 'Bundi', ''), (879, 'RAJASTHAN', 'Bhiwadi', ''), (880, 'RAJASTHAN', 'Chhabra', ''), (881, 'RAJASTHAN', 'Chittorgarh', ''), (882, 'RAJASTHAN', 'Chhipa Board', ''), (883, 'RAJASTHAN', 'Deoli', ''), (884, 'RAJASTHAN', 'Dhaulpur', ''), (885, 'RAJASTHAN', 'Jaipur', ''), (886, 'RAJASTHAN', 'Jaisalmer', ''), (887, 'RAJASTHAN', 'Jalore', ''), (888, 'RAJASTHAN', 'Jhalawar', ''), (889, 'RAJASTHAN', 'Jhunjhumu', ''), (890, 'RAJASTHAN', 'Jodhpur', ''), (891, 'RAJASTHAN', 'Kankroli', ''), (892, 'RAJASTHAN', 'Kishangarh', ''), (893, 'RAJASTHAN', 'Kota', ''), (894, 'RAJASTHAN', 'Morak', ''), (895, 'RAJASTHAN', 'Palimarwar', ''), (896, 'RAJASTHAN', 'Pratapgarh', ''), (897, 'RAJASTHAN', 'Ramganjmandi', ''), (898, 'RAJASTHAN', 'Rawatbhata', ''), (899, 'RAJASTHAN', 'Sikar', ''), (900, 'RAJASTHAN', 'Sumerput', ''), (901, 'RAJASTHAN', 'Sri Ganganagar', ''), (902, 'RAJASTHAN', 'Udaipur', ''), (903, 'SIKKIM', 'Gangtok', ''), (904, '22', 'Ambasamuthram', ''), (905, '22', 'Arni', ''), (906, '22', 'Aruppukottai', ''), (907, '22', 'Attur', ''), (908, '22', 'Batlagundu', ''), (909, '22', 'Chengalpattu', ''), (910, '22', 'Chennai', ''), (911, '22', 'Chidambaram', ''), (912, '22', 'Coimbatore', ''), (913, '22', 'Coonoor', ''), (914, '22', 'Cuddalore', ''), (915, '22', 'Cumbum', ''), (916, '22', 'Dharapuram', ''), (917, '22', 'Dharmapuri', ''), (918, '22', 'Dindigul', ''), (919, '22', 'Erode', ''), (920, '22', 'Gobichettipalayam', ''), (921, '22', 'Gudalur', ''), (922, '22', 'Gudiyattam', ''), (923, '22', 'Gummidipoondi', ''), (924, '22', 'Hosur', ''), (925, '22', 'Kancheepuram', ''), (926, '22', 'Kallakurichi', ''), (927, '22', 'Kanniyakumari', ''), (928, '22', 'Karaikal', ''), (929, '22', 'Karaikudi', ''), (930, '22', 'Karur', ''), (931, '22', 'Kodaikanal', ''), (932, '22', 'Kotagiri', ''), (933, '22', 'Kovilpatti', ''), (934, '22', 'Krishnagiri', ''), (935, '22', 'Kulasekharam', ''), (936, '22', 'Kumbakonam', ''), (937, '22', 'Madurai', ''), (938, '22', 'Marthandam', ''), (939, '22', 'Mayiladuthurai', ''), (940, '22', 'Mettupalayam', ''), (941, '22', 'Mettur dam', ''), (942, '22', 'Nagapattinam', ''), (943, '22', 'Nagarcoil', ''), (944, '22', 'Namakkal', ''), (945, '22', 'Neyveli', ''), (946, '22', 'Ooty', ''), (947, '22', 'Palani', ''), (948, '22', 'Pennadam', ''), (949, '22', 'Paramakudi', ''), (950, '22', 'Pollachi', ''), (951, '22', 'Pondicherry', ''), (952, '22', 'Pudukkottai', ''), (953, '22', 'Rajapalayam', ''), (954, '22', 'Ramanathapuram', ''), (955, '22', 'Ranipet', ''), (956, '22', 'Salem', ''), (957, '22', 'Sankarankoil', ''), (958, '22', 'Sathyamaangalam', ''), (959, '22', 'Sattur', ''), (960, '22', 'Srivilliputhur', ''), (961, '22', 'Sivagangai', ''), (962, '22', 'Sivakasi', ''), (963, '22', 'Sriperumbudur', ''), (964, '22', 'Shrivaikuntam', ''), (965, '22', 'Tenkasi', ''), (966, '22', 'Thanjavur', ''), (967, '22', 'Theni', ''), (968, '22', 'Thirichengodu', ''), (969, '22', 'Thiruchendur', ''), (970, '22', 'Thirumangalam', ''), (971, '22', 'Trichy', ''), (972, '22', 'Tiruvallur', ''), (973, '22', 'Tiruvannamalai', ''), (974, '22', 'Thuckaly', ''), (975, '22', 'Tiruchendur', ''), (976, '22', 'Tuticorin', ''), (977, '22', 'Triunelveli', ''), (978, '22', 'Tirupur', ''), (979, '22', 'Udamalpet', ''), (980, '22', 'Vallioor', ''), (981, '22', 'Vaniyambadi', ''), (982, '22', 'Valparai', ''), (983, '22', 'Vellore', ''), (984, '22', 'Valathilulam', ''), (985, '22', 'Villupuram', ''), (986, '22', 'Virudhunagar', ''), (987, '22', 'Virudhachalam', ''), (988, 'TRIPURA', 'Agartala', ''), (989, 'TRIPURA', 'Amarpur', ''), (990, 'TRIPURA', 'Ambassa', ''), (991, 'TRIPURA', 'Belonia', ''), (992, 'TRIPURA', 'Bishalgarh', ''), (993, 'TRIPURA', 'Dharmannagar', ''), (994, 'TRIPURA', 'Jatabari', ''), (995, 'TRIPURA', 'Kailasahar', ''), (996, 'TRIPURA', 'Kamalpur', ''), (997, 'TRIPURA', 'Kanchanpur', ''), (998, 'TRIPURA', 'Khowai', ''), (999, 'TRIPURA', 'Kumarghat', ''), (1000, 'TRIPURA', 'Melaghar', ''), (1001, 'TRIPURA', 'Sabroom', ''), (1002, 'TRIPURA', 'Santir Bazar', ''), (1003, 'TRIPURA', 'Sonamura', ''), (1004, 'TRIPURA', 'Teliamura', ''), (1005, 'TRIPURA', 'Udaipur', ''), (1006, 'UTTAR PRADESH', 'Agra', ''), (1007, 'UTTAR PRADESH', 'Aligarh', ''), (1008, 'UTTAR PRADESH', 'Allahabad', ''), (1009, 'UTTAR PRADESH', 'Amethi', ''), (1010, 'UTTAR PRADESH', 'Amroha', ''), (1011, 'UTTAR PRADESH', 'Azamgarh', ''), (1012, 'UTTAR PRADESH', 'Ballia', ''), (1013, 'UTTAR PRADESH', 'Barabanki', ''), (1014, 'UTTAR PRADESH', 'Bijnore', ''), (1015, 'UTTAR PRADESH', 'Budaun', ''), (1016, 'UTTAR PRADESH', 'Bulandshahar', ''), (1017, 'UTTAR PRADESH', 'Chandauli', ''), (1018, 'UTTAR PRADESH', 'Chandausi', ''), (1019, 'UTTAR PRADESH', 'Etah', ''), (1020, 'UTTAR PRADESH', 'Faizabad', ''), (1021, 'UTTAR PRADESH', 'Ferozabad', ''), (1022, 'UTTAR PRADESH', 'Ghaziabad', ''), (1023, 'UTTAR PRADESH', 'Gorakhpur', ''), (1024, 'UTTAR PRADESH', 'Hardoi', ''), (1025, 'UTTAR PRADESH', 'Hathras', ''), (1026, 'UTTAR PRADESH', 'Jaunpur', ''), (1027, 'UTTAR PRADESH', 'Jhansi', ''), (1028, 'UTTAR PRADESH', 'Kanpur', ''), (1029, 'UTTAR PRADESH', 'Lucknow ', ''), (1030, 'UTTAR PRADESH', 'Mathura', ''), (1031, 'UTTAR PRADESH', 'Meerut', ''), (1032, 'UTTAR PRADESH', 'Mirzapur', ''), (1033, 'UTTAR PRADESH', 'Moradabad', ''), (1034, 'UTTAR PRADESH', 'Mughalsarai', ''), (1035, 'UTTAR PRADESH', 'Muzaffarnagar', ''), (1036, 'UTTARPRADESH', 'Noida', ''), (1037, 'UTTARPRADESH', 'Rampur', ''), (1038, 'UTTARPRADESH', 'Saharnpur', ''), (1039, 'UTTARPRADESH', 'Shahihbad', ''), (1040, 'UTTARPRADESH', 'Shamli', ''), (1041, 'UTTARPRADESH', 'Sherkot', ''), (1042, 'UTTARPRADESH', 'Sitapur', ''), (1043, 'UTTARPRADESH', 'Sultanpur', ''), (1044, 'UTTARPRADESH', 'Varanasi', ''), (1045, 'UTTRANCHAL', 'Dehradun', ''), (1046, 'UTTRANCHAL', 'Gazipur', ''), (1047, 'UTTRANCHAL', 'Haldwani', ''), (1048, 'UTTRANCHAL', 'Hardwar', ''), (1049, 'UTTRANCHAL', 'Hasanpur', ''), (1050, 'UTTRANCHAL', 'Kashipur', ''), (1051, 'UTTRANCHAL', 'Rishikesh', ''), (1052, 'UTTRANCHAL', 'Roorkee', ''), (1053, 'UTTRANCHAL', 'Rudrapur', ''), (1054, 'WEST BENGAL', 'Arambagh', ''), (1055, 'WEST BENGAL', 'Asansol', ''), (1056, 'WEST BENGAL', 'Bally', ''), (1057, 'WEST BENGAL', 'Bankura', ''), (1058, 'WEST BENGAL', 'Barasat', ''), (1059, 'WEST BENGAL', 'Barrackpore', ''), (1060, 'WEST BENGAL', 'Basirhat', ''), (1061, 'WEST BENGAL', 'Berhampur', ''), (1062, 'WEST BENGAL', 'Bolpur Santineketan', ''), (1063, 'WEST BENGAL', 'Bishnupur', ''), (1064, 'WEST BENGAL', 'Bihar Sharif', ''), (1065, 'WEST BENGAL', 'Bongaon', ''), (1066, 'WEST BENGAL', 'Burdwan', ''), (1067, 'WEST BENGAL', 'Chandan Nagar', ''), (1068, 'WEST BENGAL', 'Contai', ''), (1069, 'WEST BENGAL', 'Chanditala', ''), (1070, 'WEST BENGAL', 'Cooch Behar', ''), (1071, 'WEST BENGAL', 'Dankuni', ''), (1072, 'WEST BENGAL', 'Darjeeling', ''), (1073, 'WEST BENGAL', 'Diamond Harbour', ''), (1074, 'WEST BENGAL', 'Dhulyan', ''), (1075, 'WEST BENGAL', 'Disergarh', ''), (1076, 'WEST BENGAL', 'Durgapur', ''), (1077, 'WEST BENGAL', 'Egra', ''), (1078, 'WEST BENGAL', 'Farakka', ''), (1079, 'WEST BENGAL', 'Habra', ''), (1080, 'WEST BENGAL', 'Haldia', ''), (1081, 'WEST BENGAL', 'Hin Motor', ''), (1082, 'WEST BENGAL', 'Howrah', ''), (1083, 'WEST BENGAL', 'Jalpaiguri', ''), (1084, 'WEST BENGAL', 'Kalna', ''), (1085, 'WEST BENGAL', 'Kalyani', ''), (1086, 'WEST BENGAL', 'Katwa', ''), (1087, 'WEST BENGAL', 'Kolkatta', ''), (1088, 'WEST BENGAL', 'Konnagar', ''), (1089, 'WEST BENGAL', 'Krish Nagar', ''), (1090, 'WEST BENGAL', 'Kharagpur', ''), (1091, 'WEST BENGAL', 'Kankinara', ''), (1092, 'WEST BENGAL', 'Malda', ''), (1093, 'WEST BENGAL', 'Memari', ''), (1094, 'WEST BENGAL', 'Midnapore', ''), (1095, 'WEST BENGAL', 'Mogra', ''), (1096, 'WEST BENGAL', 'Morshidabad', ''), (1097, 'WEST BENGAL', 'Nabadwip', ''), (1098, 'WEST BENGAL', 'Navdeep', ''), (1099, 'WEST BENGAL', 'Panagarh', ''), (1100, 'WEST BENGAL', 'Pandaveshwar', ''), (1101, 'WEST BENGAL', 'Purulia', ''), (1102, 'WEST BENGAL', 'Rampurhat', ''), (1103, 'WEST BENGAL', 'Raghunathpur', ''), (1104, 'WEST BENGAL', 'Ranaghat', ''), (1105, 'WEST BENGAL', 'Raniganj', ''), (1106, 'WEST BENGAL', 'Rishra', ''), (1107, 'WEST BENGAL', 'Sainthia', ''), (1108, 'WEST BENGAL', 'Saibani', ''), (1109, 'WEST BENGAL', 'Santipur', ''), (1110, 'WEST BENGAL', 'Sheoraphully', ''), (1111, 'WEST BENGAL', 'Siliguri', ''), (1112, 'WEST BENGAL', 'Sodepour', ''), (1113, 'WEST BENGAL', 'suri', ''), (1114, 'WEST BENGAL', 'Tamluk', ''), (1115, 'WEST BENGAL', 'Tarakeshwar', ''), (1116, 'WEST BENGAL', 'Triveni', ''), (1117, 'CHATTISGARH', 'Ambikapur', ''), (1118, 'CHATTISGARH', 'Akaltara', ''), (1119, 'CHATTISGARH', 'Bilaspur', ''), (1120, 'CHATTISGARH', 'Bhilai', ''), (1121, 'CHATTISGARH', 'Bhatapara', ''), (1122, 'CHATTISGARH', 'Balod', ''), (1123, 'CHATTISGARH', 'Champa', ''), (1124, 'CHATTISGARH', 'Chuhi Khadan', ''), (1125, 'CHATTISGARH', 'Chourai', ''), (1126, 'CHATTISGARH', 'Dhamtari', ''), (1127, 'CHATTISGARH', 'Dongargarh', ''), (1128, 'CHATTISGARH', 'Dongargoan', ''), (1129, 'CHATTISGARH', 'Durg', ''), (1130, 'CHATTISGARH', 'Jagdalpur', ''), (1131, 'CHATTISGARH', 'Kawardha', ''), (1132, 'CHATTISGARH', 'Khairagarh', ''), (1133, 'CHATTISGARH', 'Korba', ''), (1134, 'CHATTISGARH', 'Mahasamund', ''), (1135, 'CHATTISGARH', 'Mungeli', ''), (1136, 'CHATTISGARH', 'Naila', ''), (1137, 'CHATTISGARH', 'Raigarh', ''), (1138, 'CHATTISGARH', 'Raipur', ''), (1139, 'CHATTISGARH', 'Rajnandgaon', ''), (1140, 'CHATTISGARH', 'Saraipalli', ''), (1141, 'CHATTISGARH', 'Tilda', ''), (1142, 'DELHI', 'Delhi', ''), (1143, 'GOA', 'Bicholim', ''), (1144, 'GOA', 'Curchorem', ''), (1145, 'GOA', 'Goa', ''), (1146, 'GOA', 'Mapusa', ''), (1147, 'GOA', 'Margoa', ''), (1148, 'GOA', 'Panjim', ''), (1149, 'GOA', 'Ponda', ''), (1150, 'GOA', 'Vasco', ''), (1151, 'GOA', 'Verna', ''), (1152, 'PONDICHERRY', 'Pondicherry', ''); -- -------------------------------------------------------- -- -- Table structure for table `master_company` -- CREATE TABLE IF NOT EXISTS `master_company` ( `auto_number` int(13) NOT NULL AUTO_INCREMENT, `companycode` varchar(255) COLLATE latin1_general_ci NOT NULL, `companyname` varchar(255) COLLATE latin1_general_ci NOT NULL, `address1` varchar(255) COLLATE latin1_general_ci NOT NULL, `address2` varchar(255) COLLATE latin1_general_ci NOT NULL, `area` varchar(255) COLLATE latin1_general_ci NOT NULL, `city` varchar(255) COLLATE latin1_general_ci NOT NULL, `state` varchar(255) COLLATE latin1_general_ci NOT NULL, `country` varchar(255) COLLATE latin1_general_ci NOT NULL, `pincode` varchar(255) COLLATE latin1_general_ci NOT NULL, `phonenumber1` varchar(255) COLLATE latin1_general_ci NOT NULL, `phonenumber2` varchar(255) COLLATE latin1_general_ci NOT NULL, `faxnumber1` varchar(255) COLLATE latin1_general_ci NOT NULL, `faxnumber2` varchar(255) COLLATE latin1_general_ci NOT NULL, `emailid1` varchar(255) COLLATE latin1_general_ci NOT NULL, `emailid2` varchar(255) COLLATE latin1_general_ci NOT NULL, `tinnumber` varchar(255) COLLATE latin1_general_ci NOT NULL, `cstnumber` varchar(255) COLLATE latin1_general_ci NOT NULL, `dateposted` varchar(255) COLLATE latin1_general_ci NOT NULL, `companystatus` varchar(255) COLLATE latin1_general_ci NOT NULL, `currencyname` varchar(255) COLLATE latin1_general_ci NOT NULL, `currencydecimalname` varchar(255) COLLATE latin1_general_ci NOT NULL, `currencycode` varchar(255) COLLATE latin1_general_ci NOT NULL, `stockmanagement` varchar(255) COLLATE latin1_general_ci NOT NULL, PRIMARY KEY (`auto_number`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=5 ; -- -- Dumping data for table `master_company` -- INSERT INTO `master_company` (`auto_number`, `companycode`, `companyname`, `address1`, `address2`, `area`, `city`, `state`, `country`, `pincode`, `phonenumber1`, `phonenumber2`, `faxnumber1`, `faxnumber2`, `emailid1`, `emailid2`, `tinnumber`, `cstnumber`, `dateposted`, `companystatus`, `currencyname`, `currencydecimalname`, `currencycode`, `stockmanagement`) VALUES (3, 'CPY03', 'Vignesh Engineering Construction Co.', 'no.38 first floor', 'Mothilala Street', 'Kumbakonam', '936', '22', 'India', '612001', '0435-2400829', '', '', '', 'vigeco.kumbakonam@gmail.com', '', '', '', '', 'Active', 'Rupees', 'Paisa', 'INR', ''); -- -------------------------------------------------------- -- -- Table structure for table `master_contractor` -- CREATE TABLE IF NOT EXISTS `master_contractor` ( `auto_number` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `code` varchar(255) NOT NULL, `details` text, `type` varchar(255) DEFAULT NULL, `qty` varchar(255) DEFAULT NULL, `work_details` varchar(255) DEFAULT NULL, `value` varchar(255) DEFAULT NULL, `duration` varchar(255) NOT NULL, `ipaddress` varchar(255) NOT NULL, `updatetime` datetime NOT NULL, `from_date` datetime NOT NULL, `to_date` datetime NOT NULL, PRIMARY KEY (`auto_number`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; -- -- Dumping data for table `master_contractor` -- INSERT INTO `master_contractor` (`auto_number`, `name`, `code`, `details`, `type`, `qty`, `work_details`, `value`, `duration`, `ipaddress`, `updatetime`, `from_date`, `to_date`) VALUES (1, 'prasaathsamsys', '43423', '', 'masonary work', '', '', '', '', '', '2015-04-21 22:33:25', '1970-01-01 00:00:00', '1970-01-01 00:00:00'), (2, 'prasaathsamsys', '43423443', '', 'carpendar work', 'fsafadsfdf', 'czxcz', '453453', '45', '127.0.0.1', '2015-04-21 22:36:42', '2015-04-21 00:00:00', '1970-01-01 00:00:00'), (3, 'Karthi', 'mason0001', '', 'masonary work', '650 ', 'brick work,', '25000', '1', '61.3.253.76', '2015-04-24 12:30:01', '2015-05-14 00:00:00', '1970-01-01 00:00:00'); -- -------------------------------------------------------- -- -- Table structure for table `master_customer` -- CREATE TABLE IF NOT EXISTS `master_customer` ( `auto_number` int(13) NOT NULL AUTO_INCREMENT, `customercode` varchar(255) COLLATE latin1_general_ci NOT NULL, `customername` varchar(255) COLLATE latin1_general_ci NOT NULL, `typeofcustomer` varchar(255) COLLATE latin1_general_ci NOT NULL, `address1` varchar(255) COLLATE latin1_general_ci NOT NULL, `address2` varchar(255) COLLATE latin1_general_ci NOT NULL, `area` varchar(255) COLLATE latin1_general_ci NOT NULL, `city` varchar(255) COLLATE latin1_general_ci NOT NULL, `state` varchar(255) COLLATE latin1_general_ci NOT NULL, `country` varchar(255) COLLATE latin1_general_ci NOT NULL, `pincode` varchar(255) COLLATE latin1_general_ci NOT NULL, `phonenumber1` varchar(255) COLLATE latin1_general_ci NOT NULL, `phonenumber2` varchar(255) COLLATE latin1_general_ci NOT NULL, `faxnumber` varchar(255) COLLATE latin1_general_ci NOT NULL, `mobilenumber` varchar(255) COLLATE latin1_general_ci NOT NULL, `emailid1` varchar(255) COLLATE latin1_general_ci NOT NULL, `emailid2` varchar(255) COLLATE latin1_general_ci NOT NULL, `tinnumber` varchar(255) COLLATE latin1_general_ci NOT NULL, `cstnumber` varchar(255) COLLATE latin1_general_ci NOT NULL, `openingbalance` decimal(13,2) NOT NULL, `remarks` varchar(255) COLLATE latin1_general_ci NOT NULL, `status` varchar(255) COLLATE latin1_general_ci NOT NULL, `dateposted` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `shipto` text COLLATE latin1_general_ci NOT NULL, `project_name` varchar(255) COLLATE latin1_general_ci NOT NULL, `project_id` int(11) NOT NULL, PRIMARY KEY (`auto_number`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=16 ; -- -- Dumping data for table `master_customer` -- INSERT INTO `master_customer` (`auto_number`, `customercode`, `customername`, `typeofcustomer`, `address1`, `address2`, `area`, `city`, `state`, `country`, `pincode`, `phonenumber1`, `phonenumber2`, `faxnumber`, `mobilenumber`, `emailid1`, `emailid2`, `tinnumber`, `cstnumber`, `openingbalance`, `remarks`, `status`, `dateposted`, `shipto`, `project_name`, `project_id`) VALUES (1, 'CST01', 'selvarani anand', '', '100 feet road ,coimbatore', '', ' coimbatore', '1', '1', 'India', '639001', '+911234567890', '+911234567890', '', '', 'gselvimsc@gmail.com', 'gselvimsc@gmail.com', '', '', '0.00', '', '', '2015-03-20 05:42:59', '', 'ABCD', 1), (2, 'CST02', 'selvarani anand', '', '100 feet road ,coimbatore', '', 'coimbatore ', '1', '1', 'India', '639001', '+911234567890', '+911234567890', '', '', 'gselvimsc@gmail.com', 'gselvimsc@gmail.com', '', '', '0.00', '', '', '2015-03-20 06:28:51', '', 'XYS', 2), (3, 'CST03', 'selvarani anand', '', '100 feet road ,coimbatore', '', 'coimbatore ', '1', '1', 'India', '639001', '+911234567890', '+911234567890', '', '', 'gselvimsc@gmail.com', 'gselvimsc@gmail.com', '', '', '0.00', '', '', '2015-03-20 07:49:22', '', 'ABCD', 3), (4, 'CST04', 'selvarani anand', '', '100 feet road ,coimbatore', '', ' ', '1', '1', 'India', '639001', '+911234567890', '+911234567890', '', '', 'gselvimsc@gmail.com', 'gselvimsc@gmail.com', '', '', '0.00', '', '', '2015-03-20 11:28:56', '', 'CONTROLE', 4), (5, 'CST05', 'selvarani anand', '', '100 feet road ,coimbatore', '', 'b ', '1', '1', 'India', '639001', '+911234567890', '+911234567890', '', '', 'gselvimsc@gmail.com', 'gselvimsc@gmail.com', '', '', '0.00', '', '', '2015-03-27 12:41:18', '', 'ABCD', 5), (6, 'CST06', 'selvarani', '', '100 feet road ,coimbatore', '', '', '1', '1', 'India', '639001', '+911234567890', '+911234567890', '', '', 'gselvimsc@gmail.com', 'gselvimsc@gmail.com', '', '', '0.00', '', '', '2015-03-21 07:02:23', '', 'CONTROLE', 6), (7, 'CST07', 'easwaramoorthy', '', 'n.koil', 'n.koil', 'n.koil ', '936', '22', 'India', '612001', '0000000000', '0000000000', '', '', '', '', '', '', '0.00', '', '', '2015-03-29 12:42:26', '', 'N.KOIL', 7), (8, 'CST08', 'easwaramoorthy', '', 'n.koil', 'n.koil', 'n.koil ', '936', '22', 'India', '612001', '0000000000', '0000000000', '', '', '', '', '', '', '0.00', '', '', '2015-03-29 12:42:26', '', 'N.KOIL', 7), (9, 'CST09', 'sekar', '', 'muthiyanagar', 'aravindnagar', 'karikulam ', '936', '22', 'india', '612001', '9688138045', '04352424829', '', '', '', '', '', '', '0.00', '', '', '2015-03-30 04:28:43', '', 'ARAVIND NAGAR', 8), (10, 'CST010', 'k.Prabaharan', '', 'kandiyur', 'kandiyur', 'Kudavasal ', '936', '22', 'India', '612501', '1234567892', '', '', '', '', '', '', '', '0.00', '', '', '2015-04-14 12:29:44', '', 'RESIDENTIAL BUILDING KANDIYUR', 9), (11, 'CST011', 'hh', '', 'kk', 'hgg', 'hj', '904', '22', '', '', '', '', '', '', '', '', '', '', '0.00', '', '', '2015-05-26 13:03:10', '', 'R.B', 10), (12, 'CST012', '', '', '', '', '', '1', '1', '', '', '', '', '', '', '', '', '', '', '0.00', '', '', '2015-06-11 08:09:59', '', 'RESIDINTIAL BUILDING', 11), (13, 'CST013', '', '', '', '', '', '1', '1', '', '', '', '', '', '', '', '', '', '', '0.00', '', '', '2015-06-16 07:57:49', '', '', 12), (14, 'CST014', '', '', '', '', '', '1', '1', '', '', '', '', '', '', '', '', '', '', '0.00', '', '', '2015-06-17 11:34:49', '', 'SCSC', 13), (15, 'CST015', '', '', '', '', '', '1', '1', '', '', '', '', '', '', '', '', '', '', '0.00', '', '', '2015-06-18 07:26:55', '', '', 14); -- -------------------------------------------------------- -- -- Table structure for table `master_employee` -- CREATE TABLE IF NOT EXISTS `master_employee` ( `auto_number` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `code` varchar(255) NOT NULL, `designation` text, `type` varchar(255) DEFAULT NULL, `qualification` varchar(255) DEFAULT NULL, `major` varchar(255) DEFAULT NULL, `join_date` datetime NOT NULL, PRIMARY KEY (`auto_number`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; -- -- Dumping data for table `master_employee` -- INSERT INTO `master_employee` (`auto_number`, `name`, `code`, `designation`, `type`, `qualification`, `major`, `join_date`) VALUES (1, 'prasaathsamsys', 'EMP012', 'dfsdfsd', 'Monthly', 'Diploma', 'dfsdfsd', '2015-04-15 00:00:00'), (2, 'Vijaya', 'EMP011', 'Managing Director', 'Monthly', 'Others', '', '2015-05-19 00:00:00'), (3, 'Rajaraman.G', 'EMP011', 'Business Development', 'Monthly', 'B.Sc', 'Maths', '2015-02-03 00:00:00'), (4, 'Murugamani.S', 'EMP011', 'Project Engineer', 'Monthly', 'B.E', 'Civil', '2015-05-06 00:00:00'); -- -------------------------------------------------------- -- -- Table structure for table `master_expensemain` -- CREATE TABLE IF NOT EXISTS `master_expensemain` ( `auto_number` int(255) NOT NULL AUTO_INCREMENT, `expensemainname` varchar(255) COLLATE latin1_general_ci NOT NULL, `status` varchar(255) COLLATE latin1_general_ci NOT NULL, `defaultstatus` varchar(255) COLLATE latin1_general_ci NOT NULL, `ipaddress` varchar(255) COLLATE latin1_general_ci NOT NULL, `updatetime` datetime NOT NULL, PRIMARY KEY (`auto_number`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=24 ; -- -- Dumping data for table `master_expensemain` -- INSERT INTO `master_expensemain` (`auto_number`, `expensemainname`, `status`, `defaultstatus`, `ipaddress`, `updatetime`) VALUES (14, 'MASONARY', '', '', '61.3.137.136', '2015-03-29 12:50:47'), (15, 'ELECTRICAL', '', '', '61.3.137.136', '2015-03-29 12:50:58'), (16, 'PLUMBING', '', '', '61.3.137.136', '2015-03-29 12:51:05'), (17, 'TILES', '', '', '61.3.137.136', '2015-03-29 12:51:11'), (18, 'CARBENDAR', '', '', '61.3.137.136', '2015-03-29 12:51:43'), (19, 'BARBENDAR', '', '', '61.3.137.136', '2015-03-29 12:51:51'), (20, 'WELDING', '', '', '61.3.137.136', '2015-03-29 12:52:00'), (21, 'OFFICE EXP', '', '', '61.3.137.136', '2015-03-29 13:09:59'), (22, 'MISCELENEOUS', '', '', '61.3.137.136', '2015-03-29 13:29:00'), (23, 'OVER HEAD EXP', '', '', '61.3.137.136', '2015-03-29 13:29:11'); -- -------------------------------------------------------- -- -- Table structure for table `master_expensesub` -- CREATE TABLE IF NOT EXISTS `master_expensesub` ( `auto_number` int(255) NOT NULL AUTO_INCREMENT, `expensemainanum` int(255) NOT NULL, `expensemainname` varchar(255) COLLATE latin1_general_ci NOT NULL, `expensesubname` varchar(255) COLLATE latin1_general_ci NOT NULL, `status` varchar(255) COLLATE latin1_general_ci NOT NULL, `defaultstatus` varchar(255) COLLATE latin1_general_ci NOT NULL, `ipaddress` varchar(255) COLLATE latin1_general_ci NOT NULL, `updatetime` datetime NOT NULL, PRIMARY KEY (`auto_number`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=41 ; -- -- Dumping data for table `master_expensesub` -- INSERT INTO `master_expensesub` (`auto_number`, `expensemainanum`, `expensemainname`, `expensesubname`, `status`, `defaultstatus`, `ipaddress`, `updatetime`) VALUES (30, 21, 'OFFICE EXP', 'STATIONARY', '', '', '61.3.137.136', '2015-03-29 13:10:52'), (31, 21, 'OFFICE EXP', 'BIKE DUE', '', '', '61.3.137.136', '2015-03-29 13:11:03'), (32, 21, 'OFFICE EXP', 'CAR DUE', '', '', '61.3.137.136', '2015-03-29 13:11:13'), (20, 14, 'MASONARY', 'MAN.MUZDUR', '', '', '61.3.137.136', '2015-03-29 12:54:11'), (21, 14, 'MASONARY', 'W.MAZDUR', '', '', '61.3.137.136', '2015-03-29 12:54:21'), (22, 15, 'ELECTRICAL', 'ELECTRICIAN', '', '', '61.3.137.136', '2015-03-29 12:54:36'), (23, 16, 'PLUMBING', 'PLUMBER', '', '', '61.3.137.136', '2015-03-29 12:54:45'), (24, 17, 'TILES', 'TILES LAYER', '', '', '61.3.137.136', '2015-03-29 12:55:13'), (25, 18, 'CARBENDAR', 'CARBENDAR', '', '', '61.3.137.136', '2015-03-29 12:55:28'), (26, 19, 'BARBENDAR', 'BARBENDAR', '', '', '61.3.137.136', '2015-03-29 12:55:40'), (27, 20, 'WELDING', 'WELDER', '', '', '61.3.137.136', '2015-03-29 12:55:49'), (28, 21, 'OFFICE EXP', 'STAFF SALARY', '', '', '61.3.137.136', '2015-03-29 13:10:27'), (29, 21, 'OFFICE EXP', 'TELE BILL', '', '', '61.3.137.136', '2015-03-29 13:10:41'), (19, 14, 'MASONARY', 'MASON', '', '', '61.3.137.136', '2015-03-29 12:52:38'), (33, 21, 'OFFICE EXP', 'BIKE REPAIR', '', '', '61.3.137.136', '2015-03-29 13:22:28'), (34, 21, 'OFFICE EXP', 'BIKE PETROL', '', '', '61.3.137.136', '2015-03-29 13:23:03'), (35, 21, 'OFFICE EXP', 'EB BILL', '', '', '61.3.137.136', '2015-03-29 13:27:15'), (36, 21, 'OFFICE EXP', 'BUILDING RENT', '', '', '61.3.137.136', '2015-03-29 13:27:30'), (37, 22, 'MISCELENEOUS', 'MASCELENEOUS', '', '', '61.3.137.136', '2015-03-29 13:29:36'), (38, 23, 'OVER HEAD EXP', 'TEA', '', '', '61.3.137.136', '2015-03-29 13:29:58'), (39, 23, 'OVER HEAD EXP', 'FOOD', '', '', '61.3.137.136', '2015-03-29 13:30:10'), (40, 23, 'OVER HEAD EXP', 'TIPS', '', '', '61.3.137.136', '2015-03-29 13:30:32'); -- -------------------------------------------------------- -- -- Table structure for table `master_item` -- CREATE TABLE IF NOT EXISTS `master_item` ( `auto_number` int(255) NOT NULL AUTO_INCREMENT, `itemcode` varchar(255) COLLATE latin1_general_ci NOT NULL, `itemname` varchar(255) COLLATE latin1_general_ci NOT NULL, `categoryname` varchar(255) COLLATE latin1_general_ci NOT NULL, `unitname_abbreviation` varchar(255) COLLATE latin1_general_ci NOT NULL, `rateperunit` decimal(12,2) NOT NULL, `expiryperiod` int(255) NOT NULL, `taxanum` int(255) NOT NULL, `taxname` varchar(255) COLLATE latin1_general_ci NOT NULL, `status` varchar(255) COLLATE latin1_general_ci NOT NULL, `ipaddress` varchar(255) COLLATE latin1_general_ci NOT NULL, `updatetime` datetime NOT NULL, `description` varchar(255) COLLATE latin1_general_ci NOT NULL, `purchaseprice` decimal(13,2) NOT NULL, PRIMARY KEY (`auto_number`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=13 ; -- -- Dumping data for table `master_item` -- INSERT INTO `master_item` (`auto_number`, `itemcode`, `itemname`, `categoryname`, `unitname_abbreviation`, `rateperunit`, `expiryperiod`, `taxanum`, `taxname`, `status`, `ipaddress`, `updatetime`, `description`, `purchaseprice`) VALUES (1, '897676765', 'GRD GOLD 25kg', 'GRT GOLD', 'KG', '1200.00', 0, 2, 'VAT @ 5.00 %', 'deleted', '::1', '2014-12-08 10:55:36', '', '900.00'), (2, '45454', 'LG Washing', 'WASHING MACHINE', 'NOS', '17000.00', 0, 2, 'VAT @ 5.00 %', 'deleted', '::1', '2014-12-15 17:17:13', '', '15000.00'), (3, '25240132', 'Core plate', 'PLATE', 'NOS', '1500.00', 0, 2, 'VAT @ 5.00 %', '', '::1', '2014-12-19 14:35:41', '', '1000.00'), (4, '8920000014', 'Lock nut', 'PALTE', 'KG', '900.00', 0, 2, 'VAT @ 5.00 %', '', '::1', '2014-12-19 15:12:49', '', '500.00'), (5, '765576', 'LG Friodge', 'FRIDGE', 'KG', '5000.00', 0, 2, 'VAT @ 5.00 %', '', '::1', '2014-12-19 16:25:16', '', '0.00'), (6, 'PRD0002', 'jewel', 'GOLD COIN', 'KG', '50.00', 0, 2, 'VAT @ 5.00 %', '', '::1', '2015-03-16 12:12:52', 'dfd', '45.00'), (8, '3455', 'ring', 'GOLT', 'KG', '700.00', 0, 8, 'VAT 15.0%', '', '::1', '2015-03-17 12:40:28', 'golt item ', '500.00'), (10, 'SSD', 'rtf', 'COINN', 'GMS', '0.00', 0, 8, 'VAT 15.0%', '', '::1', '2015-03-17 12:41:21', ' ds', '0.00'), (11, 'STEEL0001', '8mm', 'STEEL', 'KG', '0.00', 0, 0, '', '', '117.213.115.247', '2015-04-14 12:34:08', ' ', '0.00'), (12, '', '', '', '', '0.00', 0, 0, '', '', '182.74.38.166', '2015-06-11 09:02:50', ' ', '0.00'); -- -------------------------------------------------------- -- -- Table structure for table `master_level` -- CREATE TABLE IF NOT EXISTS `master_level` ( `auto_number` int(11) NOT NULL AUTO_INCREMENT, `project_id` int(11) DEFAULT NULL, `project_name` varchar(255) NOT NULL, `levels` int(11) NOT NULL, `created` datetime NOT NULL, PRIMARY KEY (`auto_number`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ; -- -- Dumping data for table `master_level` -- INSERT INTO `master_level` (`auto_number`, `project_id`, `project_name`, `levels`, `created`) VALUES (7, 7, 'N.KOIL', 3, '2015-03-29 12:42:26'), (8, 8, 'ARAVIND NAGAR', 4, '2015-03-30 04:28:42'), (9, 9, 'RESIDENTIAL BUILDING KANDIYUR', 5, '2015-04-14 12:29:44'), (10, 10, 'R.B', 5, '2015-05-26 13:03:10'), (11, 11, 'RESIDINTIAL BUILDING', 5, '2015-06-11 08:09:57'), (13, 13, 'SCSC', 0, '2015-06-17 11:34:47'), (14, 14, '', 0, '2015-06-18 07:26:54'); -- -------------------------------------------------------- -- -- Table structure for table `master_project` -- CREATE TABLE IF NOT EXISTS `master_project` ( `auto_number` int(11) NOT NULL AUTO_INCREMENT, `project_name` varchar(255) NOT NULL, `project_code` varchar(255) NOT NULL, `street` varchar(255) DEFAULT NULL, `area` varchar(255) DEFAULT NULL, `town_no` varchar(255) DEFAULT NULL, `panchayat` varchar(255) DEFAULT NULL, `village` varchar(255) DEFAULT NULL, `taluk` varchar(255) DEFAULT NULL, `district` varchar(255) DEFAULT NULL, `duration` varchar(255) NOT NULL, `no_of_floors` varchar(255) NOT NULL, `budget` varchar(255) NOT NULL, `ipaddress` varchar(255) NOT NULL, `updatetime` datetime NOT NULL, `from_date` datetime NOT NULL, `to_date` datetime NOT NULL, PRIMARY KEY (`auto_number`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ; -- -- Dumping data for table `master_project` -- INSERT INTO `master_project` (`auto_number`, `project_name`, `project_code`, `street`, `area`, `town_no`, `panchayat`, `village`, `taluk`, `district`, `duration`, `no_of_floors`, `budget`, `ipaddress`, `updatetime`, `from_date`, `to_date`) VALUES (7, 'N.KOIL', 'VP00008', 'kamlastreet ', 'n.koil ', '140 ', 'kovanoor ', 'n.koil ', 'kum ', 'tanjur ', '5 ', '1 ', '2000000 ', '61.3.137.136', '2015-03-29 12:42:26', '2015-03-01 00:00:00', '2015-01-08 00:00:00'), (8, 'ARAVIND NAGAR', 'VP00009', 'aravinnagar ', 'karikulam ', '145 ', 'ullur ', 'ammachathiram ', 'kumbakonam ', 'thanjavur ', '4', '2 ', '200000 ', '117.241.87.245', '2015-03-30 04:28:42', '2015-04-30 00:00:00', '2015-08-30 00:00:00'), (9, 'RESIDENTIAL BUILDING KANDIYUR', 'VP000010', 'Kandiyur ', 'Kudavasal ', '150 ', 'Kandiyur ', 'Kandiyur ', 'valaingaiman ', 'Thirivarur ', '5', '1', '2000000 ', '117.213.115.247', '2015-04-14 12:29:44', '2015-04-13 00:00:00', '2015-09-04 00:00:00'), (10, 'R.B', 'VP000011', 'fd', 'kum', 'rd34', 'papansam', 'kk', 'pap', 'tanj', '6', '1', '1000000', '117.221.204.219', '2015-05-26 13:03:10', '2015-06-01 00:00:00', '2015-01-12 00:00:00'), (11, 'RESIDINTIAL BUILDING', 'VP000012', '', '', '', '', '', '', '', '7', '5', '2500000', '182.74.38.166', '2015-06-11 08:09:57', '2015-06-01 00:00:00', '2016-01-01 00:00:00'), (13, 'SCSC', 'VP000014', 'ssss', 'wd', 'sx', 'x', 'sa', 'xa', 'sa', '2', '5', 's11111111111111', '182.74.38.166', '2015-06-17 11:34:47', '2015-01-01 00:00:00', '1970-01-01 00:00:00'), (14, '', 'VP000015', '', '', '', '', '', '', '', '', '2', '', '182.74.38.166', '2015-06-18 07:26:54', '1970-01-01 00:00:00', '1970-01-01 00:00:00'); -- -------------------------------------------------------- -- -- Table structure for table `master_state` -- CREATE TABLE IF NOT EXISTS `master_state` ( `auto_number` int(15) NOT NULL AUTO_INCREMENT, `state` varchar(100) COLLATE latin1_general_ci NOT NULL, `status` varchar(255) COLLATE latin1_general_ci NOT NULL, PRIMARY KEY (`auto_number`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=35 ; -- -- Dumping data for table `master_state` -- INSERT INTO `master_state` (`auto_number`, `state`, `status`) VALUES (1, 'Andaman & Nicobar', ''), (2, 'Haryana', ''), (3, 'Mizoram', ''), (4, 'Himachal Pradesh', ''), (5, 'Nagaland', ''), (6, 'Arunachal Pradesh', ''), (7, 'Jammu & Kashmir', ''), (8, 'Orissa', ''), (9, 'Assam', ''), (10, 'Jharkhand', ''), (11, 'Pondicherry', ''), (12, 'Bihar', ''), (13, 'Karnataka', ''), (14, 'Punjab', ''), (15, 'Chandigarh', ''), (16, 'Kerala', ''), (17, 'Rajasthan', ''), (18, 'Chhattisgarh', ''), (19, 'Lakshadweep', ''), (20, 'Dadra and Nagar', ''), (21, 'Madhya Pradesh', ''), (22, 'Tamil Nadu', ''), (23, 'Daman and Diu', ''), (24, 'Maharashtra', ''), (25, 'Tripura', ''), (26, 'Delhi', ''), (27, 'Manipur', ''), (28, 'Uttar Pradesh', ''), (29, 'Goa', ''), (30, 'Meghalaya', ''), (31, 'Uttaranchal', ''), (32, 'Gujarat', ''), (33, 'West Bengal', ''), (34, 'Andhra Pradesh', ''); -- -------------------------------------------------------- -- -- Table structure for table `master_sublevel` -- CREATE TABLE IF NOT EXISTS `master_sublevel` ( `auto_number` int(11) NOT NULL AUTO_INCREMENT, `level_name` varchar(255) NOT NULL, `estimation_cost` varchar(255) NOT NULL, `level_id` int(11) NOT NULL, `created` datetime NOT NULL, PRIMARY KEY (`auto_number`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=84 ; -- -- Dumping data for table `master_sublevel` -- INSERT INTO `master_sublevel` (`auto_number`, `level_name`, `estimation_cost`, `level_id`, `created`) VALUES (62, 'foundation', '300000', 7, '2015-03-29 12:42:26'), (63, 'bas', '300000', 7, '2015-03-29 12:42:26'), (64, 'finish', '500000', 7, '2015-03-29 12:42:26'), (65, 'gf-lintel', '300000', 8, '2015-03-30 04:28:42'), (66, 'gf-roof', '300000', 8, '2015-03-30 04:28:42'), (67, 'ff-lintel', '300000', 8, '2015-03-30 04:28:42'), (68, 'gf-ff-finish', '500000', 8, '2015-03-30 04:28:42'), (69, 'Foundation', '200000', 9, '2015-04-14 12:29:44'), (70, 'Basment', '300000', 9, '2015-04-14 12:29:44'), (71, 'Lintel', '300000', 9, '2015-04-14 12:29:44'), (72, 'Roof', '50000', 9, '2015-04-14 12:29:44'), (73, 'Finishin', '500000', 9, '2015-04-14 12:29:44'), (74, 'foun', '200000', 10, '2015-05-26 13:03:10'), (75, 'bas', '300000', 10, '2015-05-26 13:03:10'), (76, 'lin', '5000', 10, '2015-05-26 13:03:10'), (77, 'roof', '350000', 10, '2015-05-26 13:03:10'), (78, 'finish', '100000', 10, '2015-05-26 13:03:10'), (79, 'foundation level', '200000', 11, '2015-06-11 08:09:57'), (80, '', '', 11, '2015-06-11 08:09:57'), (81, '', '', 11, '2015-06-11 08:09:57'), (82, '', '', 11, '2015-06-11 08:09:57'), (83, '', '', 11, '2015-06-11 08:09:57'); -- -------------------------------------------------------- -- -- Table structure for table `master_supplier` -- CREATE TABLE IF NOT EXISTS `master_supplier` ( `auto_number` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `address` varchar(255) DEFAULT NULL, `area` varchar(255) DEFAULT NULL, `mobile_no` varchar(255) DEFAULT NULL, `alt_no` varchar(255) DEFAULT NULL, `tin_no` varchar(255) DEFAULT NULL, `cst_no` varchar(255) DEFAULT NULL, `balance` varchar(255) DEFAULT NULL, `ipaddress` varchar(255) NOT NULL, `updatetime` datetime NOT NULL, PRIMARY KEY (`auto_number`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; -- -- Dumping data for table `master_supplier` -- INSERT INTO `master_supplier` (`auto_number`, `name`, `address`, `area`, `mobile_no`, `alt_no`, `tin_no`, `cst_no`, `balance`, `ipaddress`, `updatetime`) VALUES (2, 'SRI LAKSHMI STEELS', '', '', '', '', '', '', '', '61.3.137.136', '2015-03-29 12:49:05'), (3, 'MANGALAM TRATERS', '', '', '', '', '', '', '', '61.3.137.136', '2015-03-29 12:49:20'), (4, 'ABI ELECTRICALS', '', '', '', '', '', '', '', '61.3.137.136', '2015-03-29 12:49:53'); -- -------------------------------------------------------- -- -- Table structure for table `master_tax` -- CREATE TABLE IF NOT EXISTS `master_tax` ( `auto_number` int(255) NOT NULL AUTO_INCREMENT, `taxname` varchar(255) COLLATE latin1_general_ci NOT NULL, `taxpercent` decimal(13,4) NOT NULL, `defaulttax` varchar(255) COLLATE latin1_general_ci NOT NULL, `status` varchar(255) COLLATE latin1_general_ci NOT NULL, `ipaddress` varchar(255) COLLATE latin1_general_ci NOT NULL, `updatetime` datetime NOT NULL, PRIMARY KEY (`auto_number`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=10 ; -- -- Dumping data for table `master_tax` -- INSERT INTO `master_tax` (`auto_number`, `taxname`, `taxpercent`, `defaulttax`, `status`, `ipaddress`, `updatetime`) VALUES (8, 'VAT 15.0%', '15.0000', 'default', '', '::1', '2015-03-14 12:07:46'), (9, 'VAT', '4.0000', 'default', '', '61.3.137.136', '2015-03-29 12:46:25'); -- -------------------------------------------------------- -- -- Table structure for table `master_taxsub` -- CREATE TABLE IF NOT EXISTS `master_taxsub` ( `auto_number` int(255) NOT NULL AUTO_INCREMENT, `taxparentanum` int(255) NOT NULL, `taxparentname` varchar(255) COLLATE latin1_general_ci NOT NULL, `taxsubname` varchar(255) COLLATE latin1_general_ci NOT NULL, `taxsubpercent` decimal(13,4) NOT NULL, `status` varchar(255) COLLATE latin1_general_ci NOT NULL, `ipaddress` varchar(255) COLLATE latin1_general_ci NOT NULL, `updatetime` datetime NOT NULL, PRIMARY KEY (`auto_number`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=3 ; -- -------------------------------------------------------- -- -- Table structure for table `master_units` -- CREATE TABLE IF NOT EXISTS `master_units` ( `auto_number` int(255) NOT NULL AUTO_INCREMENT, `unitname` varchar(255) COLLATE latin1_general_ci NOT NULL, `unitname_abbreviation` varchar(255) COLLATE latin1_general_ci NOT NULL, `status` varchar(255) COLLATE latin1_general_ci NOT NULL, `ipaddress` varchar(255) COLLATE latin1_general_ci NOT NULL, `updatetime` datetime NOT NULL, PRIMARY KEY (`auto_number`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=14 ; -- -- Dumping data for table `master_units` -- INSERT INTO `master_units` (`auto_number`, `unitname`, `unitname_abbreviation`, `status`, `ipaddress`, `updatetime`) VALUES (3, 'NUMBERS', 'NOS', '', '127.0.0.1', '2010-12-30 18:23:22'), (8, 'SETS', 'SET', 'deleted', '117.213.83.209', '2014-07-07 18:29:59'), (9, 'KILOGRAM', 'KG', '', '::1', '2014-08-26 13:55:13'), (10, 'GRAMS', 'GMS', 'deleted', '::1', '2014-09-21 12:23:06'), (11, 'PIECES', 'PS', 'deleted', '::1', '2014-09-21 12:23:13'), (12, 'MILLI', 'ML', '', '::1', '2015-03-17 12:31:35'); -- -------------------------------------------------------- -- -- Table structure for table `outward_entry` -- CREATE TABLE IF NOT EXISTS `outward_entry` ( `auto_increment` int(11) NOT NULL AUTO_INCREMENT, `project_name` varchar(255) NOT NULL, `work_details` varchar(255) DEFAULT NULL, `level` varchar(255) DEFAULT NULL, `work_quantity` varchar(255) DEFAULT NULL, `material_usage_details` varchar(255) DEFAULT NULL, `labours` int(255) DEFAULT NULL, `unit` varchar(255) DEFAULT NULL, `entry_date` datetime NOT NULL, `created` datetime NOT NULL, PRIMARY KEY (`auto_increment`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=25 ; -- -- Dumping data for table `outward_entry` -- INSERT INTO `outward_entry` (`auto_increment`, `project_name`, `work_details`, `level`, `work_quantity`, `material_usage_details`, `labours`, `unit`, `entry_date`, `created`) VALUES (14, 'ABCD', 'take', 'aa', '12', 'cs', 10, NULL, '2015-03-26 00:00:00', '2015-03-26 13:04:50'), (16, 'ABCD', 'take', '', '12', '', 0, '3', '2015-03-27 00:00:00', '2015-03-27 11:55:14'), (17, 'ABCD', 'cxc', '', 'xcx', '', 0, '3', '2015-03-27 00:00:00', '2015-03-27 13:58:01'), (18, 'CONTROLE', 'xz', '', 'xzx', '', 0, '3', '2015-03-27 00:00:00', '2015-03-27 14:17:17'), (19, 'ARAVIND NAGAR', 'brick work', '', '150', '', 0, '10', '2015-03-30 00:00:00', '2015-03-29 13:38:20'), (20, 'R.B', 'column brik work', '', '60', '', 0, '3', '2015-05-30 00:00:00', '2015-05-26 14:04:45'), (21, 'ARAVIND NAGAR', 'brikce wor', '', '450', '', 0, '8', '1970-01-01 00:00:00', '2015-06-16 07:45:55'), (22, 'n.koil', '', '', '', '', 0, 'Select', '1970-01-01 00:00:00', '2015-06-19 12:19:00'), (23, 'ARAVIND NAGAR', 'bricke work', '', '150', '', 0, '12', '1970-01-01 00:00:00', '2015-07-09 13:26:41'), (24, 'ARAVIND NAGAR', '', '', '', '', 0, 'Select', '1970-01-01 00:00:00', '2015-07-19 08:22:53'); -- -------------------------------------------------------- -- -- Table structure for table `outward_labour_details` -- CREATE TABLE IF NOT EXISTS `outward_labour_details` ( `auto_number` int(11) NOT NULL AUTO_INCREMENT, `labour` varchar(255) NOT NULL, `labour_id` int(11) DEFAULT NULL, `numbers` int(11) NOT NULL, `outward_entry_id` int(11) NOT NULL, PRIMARY KEY (`auto_number`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=35 ; -- -- Dumping data for table `outward_labour_details` -- INSERT INTO `outward_labour_details` (`auto_number`, `labour`, `labour_id`, `numbers`, `outward_entry_id`) VALUES (11, 'Mason', 1, 1, 14), (12, 'Man Muzdoor', 2, 2, 14), (13, 'Electrical', 4, 3, 14), (14, 'Bar bendar', 7, 2, 14), (15, 'Tiles', 8, 2, 14), (21, 'Mason', 1, 1, 16), (22, 'Painter', 9, 2, 16), (23, 'Mason', 1, 1, 17), (24, 'Mason', 1, 1, 18), (25, 'Man Muzdoor', 2, 2, 18), (26, 'Mason', 1, 2, 19), (27, 'Man Muzdoor', 2, 2, 19), (28, 'Woman Muzdoor', 3, 1, 19), (29, 'Mason', 1, 2, 21), (30, 'Man Muzdoor', 2, 3, 21), (31, 'Woman Muzdoor', 3, 3, 21), (32, 'Mason', 1, 3, 23), (33, 'Man Muzdoor', 2, 3, 23), (34, 'Woman Muzdoor', 3, 3, 23); -- -------------------------------------------------------- -- -- Table structure for table `outward_level_materials` -- CREATE TABLE IF NOT EXISTS `outward_level_materials` ( `auto_number` int(11) NOT NULL AUTO_INCREMENT, `material_id` int(11) NOT NULL, `material_name` varchar(255) NOT NULL, `quantity` int(11) NOT NULL, `created` datetime NOT NULL, `outward_entry_id` int(11) NOT NULL, PRIMARY KEY (`auto_number`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=37 ; -- -- Dumping data for table `outward_level_materials` -- INSERT INTO `outward_level_materials` (`auto_number`, `material_id`, `material_name`, `quantity`, `created`, `outward_entry_id`) VALUES (20, 107, 'SAND', 10, '2015-03-26 13:04:50', 14), (21, 111, 'COINN', 20, '2015-03-26 13:04:50', 14), (24, 107, 'SAND', 10, '2015-03-27 11:55:14', 16), (25, 111, 'COINN', 10, '2015-03-27 11:55:14', 16), (26, 108, 'COINN', 10, '2015-03-27 13:58:01', 17), (27, 113, 'SAND', 10, '2015-03-27 14:17:17', 18), (28, 114, 'SAND', 10, '2015-03-27 14:17:17', 18), (29, 140, 'SAND', 100, '2015-03-29 13:38:20', 19), (30, 141, '', 0, '2015-03-29 13:38:20', 19), (31, 183, 'SAND', 100, '2015-05-26 14:04:45', 20), (32, 186, 'CEMENT', 0, '2015-05-26 14:04:45', 20), (33, 138, 'CEMENT', 30, '2015-06-16 07:45:55', 21), (34, 0, '', 0, '2015-06-16 07:45:55', 21), (35, 138, 'CEMENT', 20, '2015-07-09 13:26:41', 23), (36, 0, 'CEMENT', 0, '2015-07-19 08:22:53', 24); -- -------------------------------------------------------- -- -- Table structure for table `project_floor_details` -- CREATE TABLE IF NOT EXISTS `project_floor_details` ( `auto_increment` int(11) NOT NULL AUTO_INCREMENT, `floor_name` varchar(255) DEFAULT NULL, `sqft` varchar(255) DEFAULT NULL, `project_id` int(11) DEFAULT NULL, `created` datetime NOT NULL, PRIMARY KEY (`auto_increment`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=30 ; -- -- Dumping data for table `project_floor_details` -- INSERT INTO `project_floor_details` (`auto_increment`, `floor_name`, `sqft`, `project_id`, `created`) VALUES (11, 'gf', '800', 7, '2015-03-29 12:42:26'), (12, 'gf', '850', 8, '2015-03-30 04:28:42'), (13, 'ff', '350', 8, '2015-03-30 04:28:42'), (14, 'GF', '950', 9, '2015-04-14 12:29:44'), (15, 'gf', '1200', 10, '2015-05-26 13:03:10'), (16, '', '', 11, '2015-06-11 08:09:57'), (17, '', '', 11, '2015-06-11 08:09:57'), (18, '', '', 11, '2015-06-11 08:09:57'), (19, '', '', 11, '2015-06-11 08:09:57'), (20, '', '', 11, '2015-06-11 08:09:57'), (23, '', '', 13, '2015-06-17 11:34:47'), (24, '', '', 13, '2015-06-17 11:34:47'), (25, '', '', 13, '2015-06-17 11:34:47'), (26, '', '', 13, '2015-06-17 11:34:47'), (27, '', '', 13, '2015-06-17 11:34:47'), (28, '', '', 14, '2015-06-18 07:26:54'), (29, '', '', 14, '2015-06-18 07:26:54'); -- -------------------------------------------------------- -- -- Table structure for table `purchase_entry` -- CREATE TABLE IF NOT EXISTS `purchase_entry` ( `auto_number` int(11) NOT NULL AUTO_INCREMENT, `project_name` varchar(255) DEFAULT NULL, `supplier_bill_no` varchar(255) DEFAULT NULL, `supplier_name` varchar(255) DEFAULT NULL, `bill_type` varchar(255) DEFAULT NULL, `bank_name` varchar(255) DEFAULT NULL, `ch_no` varchar(255) DEFAULT NULL, `ch_date` varchar(255) DEFAULT NULL, `tran_no` varchar(255) DEFAULT NULL, `remarks` varchar(255) DEFAULT NULL, `created` datetime DEFAULT NULL, `entry_date` datetime DEFAULT NULL, PRIMARY KEY (`auto_number`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ; -- -- Dumping data for table `purchase_entry` -- INSERT INTO `purchase_entry` (`auto_number`, `project_name`, `supplier_bill_no`, `supplier_name`, `bill_type`, `bank_name`, `ch_no`, `ch_date`, `tran_no`, `remarks`, `created`, `entry_date`) VALUES (1, 'ABCD', '123', '1', 'cash', '', '', '', '', 'xx', '2015-03-26 09:21:39', '2015-03-26 00:00:00'), (2, 'ABCD', '123', '1', 'cash', '', '', '', '', 'cxc', '2015-03-26 09:23:43', '2015-03-26 00:00:00'), (3, 'ABCD', '123', '1', 'cash', '', '', '', '', 'xcx', '2015-03-27 13:55:48', '2015-03-27 00:00:00'), (4, 'CONTROLE', '123', '1', 'cash', '', '', '', '', 'cxcx', '2015-03-27 14:16:36', '2015-03-27 00:00:00'), (5, 'N.KOIL', 'req-1', '3', 'cash', '', '', '', '', '', '2015-03-29 12:58:00', '2015-03-30 00:00:00'), (6, 'N.KOIL', 'req-2', '3', 'cash', '', '', '', '', '', '2015-03-29 12:59:12', '2015-03-30 00:00:00'), (7, 'N.KOIL', 'req-3', '2', 'cheque', 'IOB', '525006', '30/3/2015', '', '', '2015-03-29 13:02:05', '2015-03-30 00:00:00'), (8, 'ARAVIND NAGAR', 'req-008', '3', 'credit', '', '', '', '', '', '2015-03-29 13:32:03', '2015-03-30 00:00:00'), (9, 'N.KOIL', 'rew-009', '4', 'cash', '', '', '', '', '', '2015-03-29 13:33:14', '2015-03-31 00:00:00'), (10, 'RESIDENTIAL BUILDING KANDIYUR', 'req1', '3', 'cash', '', '', '', '', '', '2015-04-14 12:26:54', '1970-01-01 00:00:00'), (11, 'RESIDENTIAL BUILDING KANDIYUR', '1212', '2', 'cash', '', '', '', '', '', '2015-04-22 11:03:35', '2015-04-22 00:00:00'), (12, 'R.B', 'bill/23', '3', 'cash', '', '', '', '', 'vp116-R003', '2015-05-26 13:54:46', '2015-05-26 00:00:00'), (13, 'R.B', '54', 'Select', 'cash', '', '', '', '', '569', '2015-05-26 13:58:47', '2015-05-26 00:00:00'), (14, 'ARAVIND NAGAR', '', 'Select', 'select', '', '', '', '', '', '2015-06-11 08:22:49', '2016-12-12 00:00:00'); -- -------------------------------------------------------- -- -- Table structure for table `purchase_level_materials` -- CREATE TABLE IF NOT EXISTS `purchase_level_materials` ( `auto_number` int(11) NOT NULL AUTO_INCREMENT, `material_id` int(11) NOT NULL, `material_name` varchar(255) NOT NULL, `quantity` int(11) NOT NULL, `rate` int(11) NOT NULL, `tax` int(11) NOT NULL, `total` int(11) NOT NULL, `created` datetime NOT NULL, `purchase_entry_id` int(11) NOT NULL, PRIMARY KEY (`auto_number`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=25 ; -- -- Dumping data for table `purchase_level_materials` -- INSERT INTO `purchase_level_materials` (`auto_number`, `material_id`, `material_name`, `quantity`, `rate`, `tax`, `total`, `created`, `purchase_entry_id`) VALUES (1, 107, 'SAND', 20, 100, 15, 2300, '2015-03-26 09:21:39', 1), (2, 108, 'COINN', 20, 100, 15, 2300, '2015-03-26 09:21:39', 1), (3, 115, 'JULLY', 30, 100, 15, 3450, '2015-03-26 09:21:39', 1), (4, 111, 'COINN', 20, 100, 15, 2300, '2015-03-26 09:21:39', 1), (5, 115, 'JULLY', 20, 100, 15, 2300, '2015-03-26 09:23:43', 2), (7, 112, 'GOLT', 30, 100, 15, 3450, '2015-03-26 09:23:43', 2), (8, 111, 'COINN', 10, 100, 0, 1000, '2015-03-27 13:55:48', 3), (9, 113, 'SAND', 10, 100, 15, 1150, '2015-03-27 14:16:36', 4), (10, 114, 'SAND', 10, 100, 15, 1150, '2015-03-27 14:16:36', 4), (11, 116, 'SAND', 5, 18, 0, 90, '2015-03-29 12:58:00', 5), (12, 116, '', 0, 0, 0, 0, '2015-03-29 12:58:00', 5), (13, 120, 'JULLY', 50, 35, 0, 1750, '2015-03-29 12:59:12', 6), (14, 127, 'STEEL', 200, 52, 0, 10400, '2015-03-29 13:02:05', 7), (15, 140, 'SAND', 200, 18, 0, 3600, '2015-03-29 13:32:03', 8), (16, 131, 'wood', 25, 2400, 0, 60000, '2015-03-29 13:33:14', 9), (17, 0, '', 0, 0, 0, 0, '2015-03-29 13:33:14', 9), (18, 157, 'SAND', 400, 18, 0, 7200, '2015-04-14 12:26:54', 10), (19, 160, 'CEMENT', 20, 305, 0, 6100, '2015-04-22 11:03:35', 11), (20, 159, 'JULLY', 5, 1000, 0, 5000, '2015-04-22 11:03:35', 11), (21, 183, 'SAND', 200, 28, 0, 5600, '2015-05-26 13:54:46', 12), (22, 183, '', 0, 0, 0, 0, '2015-05-26 13:54:46', 12), (23, 190, 'CEMENT', 200, 390, 0, 78000, '2015-05-26 13:58:47', 13), (24, 138, 'CEMENT', 200, 390, 0, 78000, '2015-06-11 08:22:49', 14); -- -------------------------------------------------------- -- -- Table structure for table `tn_cash_inward` -- CREATE TABLE IF NOT EXISTS `tn_cash_inward` ( `auto_number` int(11) NOT NULL AUTO_INCREMENT, `date` datetime NOT NULL, `project_id` int(11) NOT NULL, `project_name` varchar(255) NOT NULL, `amount` int(255) NOT NULL, `mode_of_payment` varchar(255) NOT NULL, `bank_name` varchar(255) DEFAULT NULL, `ch_no` varchar(255) DEFAULT NULL, `ch_date` varchar(255) DEFAULT NULL, `transaction_no` varchar(255) DEFAULT NULL, `remarks` varchar(255) NOT NULL, `created` varchar(255) NOT NULL, PRIMARY KEY (`auto_number`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ; -- -- Dumping data for table `tn_cash_inward` -- INSERT INTO `tn_cash_inward` (`auto_number`, `date`, `project_id`, `project_name`, `amount`, `mode_of_payment`, `bank_name`, `ch_no`, `ch_date`, `transaction_no`, `remarks`, `created`) VALUES (3, '2015-03-30 00:00:00', 7, 'N.KOIL', 200000, 'cash', '', '', '', '', 'payment-1', '2015-03-29 12:56:26'), (5, '2015-03-24 00:00:00', 8, 'ARAVIND NAGAR', 200000, 'cash', '', '', '', '', '', '2015-03-30 04:27:33'), (6, '2015-04-14 00:00:00', 9, 'RESIDENTIAL BUILDING KANDIYUR', 500000, 'cash', '', '', '', '', 'Payment-1', '2015-04-14 12:24:29'), (7, '2015-05-31 00:00:00', 10, 'R.B', 200000, 'cash', '', '', '', '', 'vp116r-001', '2015-05-26 13:08:48'); -- -------------------------------------------------------- -- -- Table structure for table `user` -- CREATE TABLE IF NOT EXISTS `user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(255) DEFAULT NULL, `password` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `user` -- INSERT INTO `user` (`id`, `username`, `password`) VALUES (1, 'admin', 'admin'); /*!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 */;