-- phpMyAdmin SQL Dump -- version 4.8.3 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Aug 12, 2021 at 08:08 AM -- Server version: 10.1.35-MariaDB -- PHP Version: 7.2.9 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; 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 */; -- -- Database: `rental` -- -- -------------------------------------------------------- -- -- Table structure for table `details_login` -- CREATE TABLE `details_login` ( `auto_number` int(255) NOT NULL, `username` varchar(255) COLLATE latin1_general_ci NOT NULL, `logintime` datetime NOT NULL, `logouttime` datetime NOT NULL, `sessionid` varchar(255) COLLATE latin1_general_ci NOT NULL, `openingcash` decimal(13,2) NOT NULL, `closingcash` decimal(13,2) NOT NULL, `sales` decimal(13,2) NOT NULL, `expenses` decimal(13,2) NOT NULL, `deposit` decimal(13,2) NOT NULL, `withdrawal` decimal(13,2) NOT NULL, `cashmrc` decimal(13,2) NOT NULL, `salesreturn` decimal(13,2) NOT NULL, `customercollection` decimal(13,2) NOT NULL, `supplierpayment` decimal(13,2) NOT NULL, `useropeningcash` decimal(13,2) NOT NULL, `userclosingcash` decimal(13,2) NOT NULL, `usersales` decimal(13,2) NOT NULL, `userexpenses` decimal(13,2) NOT NULL, `userdeposit` decimal(13,2) NOT NULL, `userwithdrawal` decimal(13,2) NOT NULL, `usercashmrc` decimal(13,2) NOT NULL, `usersalesreturn` decimal(13,2) NOT NULL, `usercustomercollection` decimal(13,2) NOT NULL, `usersupplierpayment` decimal(13,2) NOT NULL, `remarks` text COLLATE latin1_general_ci NOT NULL, `rs1000` int(255) NOT NULL, `rs500` int(255) NOT NULL, `rs100` int(255) NOT NULL, `rs50` int(255) NOT NULL, `rs20` int(255) NOT NULL, `rs10` int(255) NOT NULL, `rs5` int(255) NOT NULL, `rs2` int(255) NOT NULL, `rs1` int(255) NOT NULL, `rscoins` decimal(13,2) NOT NULL, `denominationtotal` decimal(13,2) NOT NULL, `lastupdate` datetime NOT NULL, `lastupdateipaddress` varchar(255) COLLATE latin1_general_ci NOT NULL, `lastupdateusername` varchar(255) COLLATE latin1_general_ci NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; -- -- Dumping data for table `details_login` -- INSERT INTO `details_login` (`auto_number`, `username`, `logintime`, `logouttime`, `sessionid`, `openingcash`, `closingcash`, `sales`, `expenses`, `deposit`, `withdrawal`, `cashmrc`, `salesreturn`, `customercollection`, `supplierpayment`, `useropeningcash`, `userclosingcash`, `usersales`, `userexpenses`, `userdeposit`, `userwithdrawal`, `usercashmrc`, `usersalesreturn`, `usercustomercollection`, `usersupplierpayment`, `remarks`, `rs1000`, `rs500`, `rs100`, `rs50`, `rs20`, `rs10`, `rs5`, `rs2`, `rs1`, `rscoins`, `denominationtotal`, `lastupdate`, `lastupdateipaddress`, `lastupdateusername`) VALUES (1, 'admin', '2016-02-01 12:01:46', '2016-02-01 12:13:37', '2d338f13b189005013d7f2bc227e20ca', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, '0.00', '0.00', '2016-02-01 12:01:46', '127.0.0.1', 'admin'), (2, 'admin', '2016-03-06 06:01:51', '2016-03-06 06:06:13', '75d019f1c77d53d97abb29ffbe7d9cc0', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, '0.00', '0.00', '2016-03-06 06:01:51', '127.0.0.1', 'admin'), (3, 'admin', '2016-03-06 09:02:01', '0000-00-00 00:00:00', '6ed8b43dd47fa250db9aa92deb322a63', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, '0.00', '0.00', '2016-03-06 09:02:01', '127.0.0.1', 'admin'), (4, 'admin', '2016-03-17 08:01:12', '2016-03-17 08:29:14', '74392d1c151e823eb5a0ae535a7fc08d', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, '0.00', '0.00', '2016-03-17 08:01:12', '127.0.0.1', 'admin'), (5, 'admin', '2016-12-07 11:21:59', '0000-00-00 00:00:00', '5474ccc32921d6805d57d43b656da201', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, '0.00', '0.00', '2016-12-07 11:21:59', '127.0.0.1', 'admin'), (6, 'admin', '2016-12-28 12:21:09', '0000-00-00 00:00:00', '1f365d9e7d032368fb63d1928bef25a1', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, '0.00', '0.00', '2016-12-28 12:21:09', '127.0.0.1', 'admin'), (7, 'admin', '2016-12-28 15:41:32', '2016-12-28 15:42:53', 'ce17fb1827afaf0d8d3edd25b06d73e5', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, '0.00', '0.00', '2016-12-28 15:41:32', '127.0.0.1', 'admin'), (8, 'admin', '2016-12-28 17:47:47', '2016-12-28 17:54:56', '5ddc8e5e086421e53f8fe901ff2493b9', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, '0.00', '0.00', '2016-12-28 17:47:47', '127.0.0.1', 'admin'), (9, 'admin', '2017-02-14 11:02:24', '0000-00-00 00:00:00', '2b37da5ef3423e9846c1789068530151', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, '0.00', '0.00', '2017-02-14 11:02:24', '127.0.0.1', 'admin'), (10, 'admin', '2017-02-14 11:05:35', '0000-00-00 00:00:00', '831a3d963e8a5e8fe673241d4bc4cbbf', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, '0.00', '0.00', '2017-02-14 11:05:35', '127.0.0.1', 'admin'), (11, 'admin', '2017-02-14 14:03:57', '0000-00-00 00:00:00', 'ddbc4642c0c4c1e4ea1a03d09fbac6c9', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, '0.00', '0.00', '2017-02-14 14:03:57', '127.0.0.1', 'admin'), (12, 'admin', '2017-09-09 11:03:52', '0000-00-00 00:00:00', '53aed02157facb0ecd3f83072d2e7a31', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, '0.00', '0.00', '2017-09-09 11:03:52', '127.0.0.1', 'admin'), (13, 'admin', '2017-12-06 17:34:03', '2017-12-06 17:47:20', '7eb89cee2dde05024663506d38183279', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, '0.00', '0.00', '2017-12-06 17:34:03', '127.0.0.1', 'admin'), (14, 'admin', '2018-10-30 11:13:16', '2018-10-30 11:21:19', 'ed95751c1d12cbb6f3e6f15e16d92cac', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, '0.00', '0.00', '2018-10-30 11:13:16', '127.0.0.1', 'admin'), (15, 'admin', '2018-11-26 10:10:37', '2018-11-26 10:18:24', '324895e95460c935be1c138d676d97b2', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, '0.00', '0.00', '2018-11-26 10:10:37', '127.0.0.1', 'admin'); -- -------------------------------------------------------- -- -- Table structure for table `login_restriction` -- CREATE TABLE `login_restriction` ( `auto_number` int(255) NOT NULL, `username` varchar(255) COLLATE latin1_general_ci NOT NULL, `logintime` datetime NOT NULL, `logouttime` datetime NOT NULL, `sessionid` varchar(255) COLLATE latin1_general_ci NOT NULL, `lastupdate` datetime NOT NULL, `lastupdateipaddress` varchar(255) COLLATE latin1_general_ci NOT NULL, `lastupdateusername` varchar(255) COLLATE latin1_general_ci NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; -- -- Dumping data for table `login_restriction` -- INSERT INTO `login_restriction` (`auto_number`, `username`, `logintime`, `logouttime`, `sessionid`, `lastupdate`, `lastupdateipaddress`, `lastupdateusername`) VALUES (166, 'sundar', '2014-07-08 22:52:50', '0000-00-00 00:00:00', 'd0a6aace2a576192f98974a19854867c', '2014-07-08 22:52:50', '223.187.40.222', 'sundar'), (160, 'user', '2014-07-08 22:25:13', '0000-00-00 00:00:00', 'cc19dc85664f8d0f103e56c27fa441db', '2014-07-08 22:25:13', '223.187.40.222', 'user'), (1278, 'admin', '2018-11-26 10:10:37', '0000-00-00 00:00:00', '324895e95460c935be1c138d676d97b2', '2018-11-26 10:10:37', '127.0.0.1', 'admin'); -- -------------------------------------------------------- -- -- Table structure for table `master_area` -- -- Error reading structure for table rental.master_area: #1932 - Table 'rental.master_area' doesn't exist in engine -- Error reading data for table rental.master_area: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FROM `rental`.`master_area`' at line 1 -- -------------------------------------------------------- -- -- Table structure for table `master_city` -- CREATE TABLE `master_city` ( `auto_number` int(255) NOT NULL, `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 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; -- -- 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 `master_company` ( `auto_number` int(13) NOT NULL, `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 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; -- -- 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 (5, 'CPY00000002', 'Power Tools', '', '', 'St. Thomas Mount', 'Chennai', '', 'India', '600039', '9884844055', '9176222020', '', '', 'toolroom2000@gmail.com', '', '', '', '2014-07-06 23:04:44', 'Active', 'Rupees', 'Paise', 'INR', ''); -- -------------------------------------------------------- -- -- Table structure for table `master_customer` -- CREATE TABLE `master_customer` ( `auto_number` int(13) NOT NULL, `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, `current_balance` float NOT NULL, `firstname` varchar(110) COLLATE latin1_general_ci NOT NULL, `lastname` varchar(110) COLLATE latin1_general_ci NOT NULL, `referencename` varchar(110) COLLATE latin1_general_ci NOT NULL, `referenceaddress` text COLLATE latin1_general_ci NOT NULL, `referencephonenumber1` varchar(20) COLLATE latin1_general_ci NOT NULL, `referencephonenumber2` varchar(20) COLLATE latin1_general_ci NOT NULL, `get_proof` int(1) NOT NULL, `photo` varchar(255) COLLATE latin1_general_ci NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; -- -- 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`, `current_balance`, `firstname`, `lastname`, `referencename`, `referenceaddress`, `referencephonenumber1`, `referencephonenumber2`, `get_proof`, `photo`) VALUES (1, 'CST00000001', 'aaaaa ', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0.00', '', '', '2017-02-14 08:29:02', '', 0, 'aaaaa', '', '', '', '', '', 0, 'photos/1487060942.png'), (2, 'CST00000002', 'aaaaa ', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0.00', '', '', '2017-02-14 08:34:10', '', 0, 'aaaaa', '', '', '', '', '', 0, 'photos/1487061250.png'); -- -------------------------------------------------------- -- -- Table structure for table `master_edition` -- CREATE TABLE `master_edition` ( `auto_number` int(255) NOT NULL, `productcode` varchar(255) COLLATE latin1_general_ci NOT NULL, `edition` varchar(255) COLLATE latin1_general_ci NOT NULL, `allowed` int(255) NOT NULL, `status` varchar(255) COLLATE latin1_general_ci NOT NULL, `updatedate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `users` int(255) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; -- -- Dumping data for table `master_edition` -- INSERT INTO `master_edition` (`auto_number`, `productcode`, `edition`, `allowed`, `status`, `updatedate`, `users`) VALUES (3, '0325144820142508', 'FREE', 30000, 'ACTIVE', '2014-03-18 03:27:47', 10), (4, '0325144820142508', 'FREE', 30000, '', '2014-03-18 03:27:20', 10); -- -------------------------------------------------------- -- -- Table structure for table `master_employee` -- CREATE TABLE `master_employee` ( `auto_number` int(255) NOT NULL, `employeecode` varchar(255) COLLATE latin1_general_ci NOT NULL, `employeename` varchar(255) COLLATE latin1_general_ci NOT NULL, `username` varchar(255) COLLATE latin1_general_ci NOT NULL, `password` varchar(255) COLLATE latin1_general_ci NOT NULL, `status` varchar(255) COLLATE latin1_general_ci NOT NULL, `lastupdate` datetime NOT NULL, `lastupdateusername` varchar(255) COLLATE latin1_general_ci NOT NULL, `lastupdateipaddress` varchar(255) COLLATE latin1_general_ci NOT NULL, `expired_date` date NOT NULL, `license` varchar(255) COLLATE latin1_general_ci NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; -- -- Dumping data for table `master_employee` -- INSERT INTO `master_employee` (`auto_number`, `employeecode`, `employeename`, `username`, `password`, `status`, `lastupdate`, `lastupdateusername`, `lastupdateipaddress`, `expired_date`, `license`) VALUES (1, 'EMP00000001', 'ADMINISTRATOR', 'admin', 'admin', 'Active', '2013-01-12 15:08:10', 'admin', '192.168.1.15', '2016-08-02', '1234567890'); -- -------------------------------------------------------- -- -- Table structure for table `master_employeerights` -- CREATE TABLE `master_employeerights` ( `auto_number` int(255) NOT NULL, `employeecode` varchar(255) COLLATE latin1_general_ci NOT NULL, `username` varchar(255) COLLATE latin1_general_ci NOT NULL, `mainmenuid` varchar(255) COLLATE latin1_general_ci NOT NULL, `submenuid` varchar(255) COLLATE latin1_general_ci NOT NULL, `lastupdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `lastupdateipaddress` varchar(255) COLLATE latin1_general_ci NOT NULL, `lastupdateusername` varchar(255) COLLATE latin1_general_ci NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; -- -- Dumping data for table `master_employeerights` -- INSERT INTO `master_employeerights` (`auto_number`, `employeecode`, `username`, `mainmenuid`, `submenuid`, `lastupdate`, `lastupdateipaddress`, `lastupdateusername`) VALUES (1864, 'EMP00000001', 'admin', '', 'SM132', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1863, 'EMP00000001', 'admin', '', 'SM129', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1862, 'EMP00000001', 'admin', '', 'SM128', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1861, 'EMP00000001', 'admin', '', 'SM127', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1860, 'EMP00000001', 'admin', '', 'SM126', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1859, 'EMP00000001', 'admin', '', 'SM125', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1858, 'EMP00000001', 'admin', '', 'SM124', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1857, 'EMP00000001', 'admin', '', 'SM123', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1856, 'EMP00000001', 'admin', '', 'SM114', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1855, 'EMP00000001', 'admin', '', 'SM112', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1854, 'EMP00000001', 'admin', '', 'SM111', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1853, 'EMP00000001', 'admin', '', 'SM110', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1852, 'EMP00000001', 'admin', '', 'SM109', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1851, 'EMP00000001', 'admin', '', 'SM108', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1850, 'EMP00000001', 'admin', '', 'SM107', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1849, 'EMP00000001', 'admin', '', 'SM106', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1848, 'EMP00000001', 'admin', '', 'SM105', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1847, 'EMP00000001', 'admin', '', 'SM104', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1846, 'EMP00000001', 'admin', '', 'SM103', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1845, 'EMP00000001', 'admin', '', 'SM102', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1844, 'EMP00000001', 'admin', '', 'SM101', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1843, 'EMP00000001', 'admin', '', 'SM099', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1842, 'EMP00000001', 'admin', '', 'SM096', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1841, 'EMP00000001', 'admin', '', 'SM095', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1840, 'EMP00000001', 'admin', '', 'SM094', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1839, 'EMP00000001', 'admin', '', 'SM093', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1838, 'EMP00000001', 'admin', '', 'SM092', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1837, 'EMP00000001', 'admin', '', 'SM091', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1836, 'EMP00000001', 'admin', '', 'SM090', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1835, 'EMP00000001', 'admin', '', 'SM089', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1834, 'EMP00000001', 'admin', '', 'SM088', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1833, 'EMP00000001', 'admin', '', 'SM087', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1832, 'EMP00000001', 'admin', '', 'SM086', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1831, 'EMP00000001', 'admin', '', 'SM085', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1830, 'EMP00000001', 'admin', '', 'SM084', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1829, 'EMP00000001', 'admin', '', 'SM083', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1828, 'EMP00000001', 'admin', '', 'SM082', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1827, 'EMP00000001', 'admin', '', 'SM078', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1826, 'EMP00000001', 'admin', '', 'SM070', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1825, 'EMP00000001', 'admin', '', 'SM069', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1824, 'EMP00000001', 'admin', '', 'SM043', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1823, 'EMP00000001', 'admin', '', 'SM042', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1822, 'EMP00000001', 'admin', '', 'SM043', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1821, 'EMP00000001', 'admin', '', 'SM042', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1820, 'EMP00000001', 'admin', '', 'SM041', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1819, 'EMP00000001', 'admin', '', 'SM040', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1818, 'EMP00000001', 'admin', '', 'SM039', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1817, 'EMP00000001', 'admin', '', 'SM056', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1816, 'EMP00000001', 'admin', '', 'SM055', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1815, 'EMP00000001', 'admin', '', 'SM081', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1814, 'EMP00000001', 'admin', '', 'SM080', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1813, 'EMP00000001', 'admin', '', 'SM036', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1812, 'EMP00000001', 'admin', '', 'SM035', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1811, 'EMP00000001', 'admin', '', 'SM067', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1810, 'EMP00000001', 'admin', '', 'SM067', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1809, 'EMP00000001', 'admin', '', 'SM038', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1808, 'EMP00000001', 'admin', '', 'SM066', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1807, 'EMP00000001', 'admin', '', 'SM060', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1806, 'EMP00000001', 'admin', '', 'SM056', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1805, 'EMP00000001', 'admin', '', 'SM079', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1804, 'EMP00000001', 'admin', '', 'SM075', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1803, 'EMP00000001', 'admin', '', 'SM023', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1802, 'EMP00000001', 'admin', '', 'SM079', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1801, 'EMP00000001', 'admin', '', 'SM078', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1800, 'EMP00000001', 'admin', '', 'SM024', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1799, 'EMP00000001', 'admin', '', 'SM056', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1798, 'EMP00000001', 'admin', '', 'SM034', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1797, 'EMP00000001', 'admin', '', 'SM068', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1796, 'EMP00000001', 'admin', '', 'SM077', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1795, 'EMP00000001', 'admin', '', 'SM033', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1794, 'EMP00000001', 'admin', '', 'SM074', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1793, 'EMP00000001', 'admin', '', 'SM068', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1792, 'EMP00000001', 'admin', '', 'SM027', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1791, 'EMP00000001', 'admin', '', 'SM032', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1790, 'EMP00000001', 'admin', '', 'SM037', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1789, 'EMP00000001', 'admin', '', 'SM026', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1788, 'EMP00000001', 'admin', '', 'SM076', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1787, 'EMP00000001', 'admin', '', 'SM071', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1786, 'EMP00000001', 'admin', '', 'SM075', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1785, 'EMP00000001', 'admin', '', 'SM023', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1784, 'EMP00000001', 'admin', '', 'SM022', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1783, 'EMP00000001', 'admin', '', 'SM021', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1782, 'EMP00000001', 'admin', '', 'SM002', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1781, 'EMP00000001', 'admin', '', 'SM074', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1780, 'EMP00000001', 'admin', '', 'SM073', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1779, 'EMP00000001', 'admin', '', 'SM072', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1778, 'EMP00000001', 'admin', '', 'SM067', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1777, 'EMP00000001', 'admin', '', 'SM066', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1776, 'EMP00000001', 'admin', '', 'SM058', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1775, 'EMP00000001', 'admin', '', 'SM055', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1774, 'EMP00000001', 'admin', '', 'SM031', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1773, 'EMP00000001', 'admin', '', 'SM018', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1772, 'EMP00000001', 'admin', '', 'SM017', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1771, 'EMP00000001', 'admin', '', 'SM010', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1770, 'EMP00000001', 'admin', '', 'SM009', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1769, 'EMP00000001', 'admin', '', 'SM004', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1764, 'EMP00000001', 'admin', 'MM000', '', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1765, 'EMP00000001', 'admin', 'MM009', '', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1766, 'EMP00000001', 'admin', 'MM010', '', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1767, 'EMP00000001', 'admin', '', 'SM001', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1768, 'EMP00000001', 'admin', '', 'SM003', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1763, 'EMP00000001', 'admin', 'MM008', '', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1762, 'EMP00000001', 'admin', 'MM007', '', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1761, 'EMP00000001', 'admin', 'MM006', '', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1760, 'EMP00000001', 'admin', 'MM004', '', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1759, 'EMP00000001', 'admin', 'MM003', '', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1758, 'EMP00000001', 'admin', 'MM001', '', '2013-01-12 09:38:10', '192.168.1.15', 'admin'), (1999, 'EMP00000003', 'user2', '', 'SM017', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (1998, 'EMP00000003', 'user2', '', 'SM013', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (1997, 'EMP00000003', 'user2', '', 'SM012', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (1996, 'EMP00000003', 'user2', '', 'SM010', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (1995, 'EMP00000003', 'user2', '', 'SM009', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (1994, 'EMP00000003', 'user2', '', 'SM004', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (1993, 'EMP00000003', 'user2', '', 'SM003', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (1992, 'EMP00000003', 'user2', '', 'SM001', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (1991, 'EMP00000003', 'user2', 'MM011', '', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (1990, 'EMP00000003', 'user2', 'MM005', '', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (1989, 'EMP00000003', 'user2', 'MM002', '', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (1988, 'EMP00000003', 'user2', 'MM010', '', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (1987, 'EMP00000003', 'user2', 'MM009', '', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (1986, 'EMP00000003', 'user2', 'MM000', '', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (1985, 'EMP00000003', 'user2', 'MM008', '', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (1984, 'EMP00000003', 'user2', 'MM007', '', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (1983, 'EMP00000003', 'user2', 'MM006', '', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (1982, 'EMP00000003', 'user2', 'MM004', '', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (1981, 'EMP00000003', 'user2', 'MM003', '', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (1980, 'EMP00000003', 'user2', 'MM001', '', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2756, 'EMP00000002', 'user', '', 'SM056', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2755, 'EMP00000002', 'user', '', 'SM079', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2754, 'EMP00000002', 'user', '', 'SM075', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2753, 'EMP00000002', 'user', '', 'SM079', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2752, 'EMP00000002', 'user', '', 'SM078', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2751, 'EMP00000002', 'user', '', 'SM024', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2750, 'EMP00000002', 'user', '', 'SM056', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2749, 'EMP00000002', 'user', '', 'SM034', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2748, 'EMP00000002', 'user', '', 'SM068', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2747, 'EMP00000002', 'user', '', 'SM077', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2746, 'EMP00000002', 'user', '', 'SM033', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2745, 'EMP00000002', 'user', '', 'SM074', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2744, 'EMP00000002', 'user', '', 'SM068', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2743, 'EMP00000002', 'user', '', 'SM027', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2742, 'EMP00000002', 'user', '', 'SM032', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2741, 'EMP00000002', 'user', '', 'SM037', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2740, 'EMP00000002', 'user', '', 'SM026', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2739, 'EMP00000002', 'user', '', 'SM076', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2738, 'EMP00000002', 'user', '', 'SM071', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2737, 'EMP00000002', 'user', '', 'SM075', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2736, 'EMP00000002', 'user', '', 'SM023', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2735, 'EMP00000002', 'user', '', 'SM022', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2734, 'EMP00000002', 'user', '', 'SM021', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2733, 'EMP00000002', 'user', '', 'SM002', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2732, 'EMP00000002', 'user', '', 'SM074', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2731, 'EMP00000002', 'user', '', 'SM073', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2730, 'EMP00000002', 'user', '', 'SM072', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2729, 'EMP00000002', 'user', '', 'SM067', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2728, 'EMP00000002', 'user', '', 'SM066', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2727, 'EMP00000002', 'user', '', 'SM058', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2726, 'EMP00000002', 'user', '', 'SM055', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2725, 'EMP00000002', 'user', '', 'SM031', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2724, 'EMP00000002', 'user', '', 'SM018', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2723, 'EMP00000002', 'user', '', 'SM017', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2722, 'EMP00000002', 'user', '', 'SM010', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2721, 'EMP00000002', 'user', '', 'SM009', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2720, 'EMP00000002', 'user', '', 'SM004', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2719, 'EMP00000002', 'user', '', 'SM003', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2718, 'EMP00000002', 'user', '', 'SM001', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2717, 'EMP00000002', 'user', 'MM012', '', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2716, 'EMP00000002', 'user', 'MM010', '', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2715, 'EMP00000002', 'user', 'MM009', '', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2714, 'EMP00000002', 'user', 'MM000', '', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2713, 'EMP00000002', 'user', 'MM008', '', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2712, 'EMP00000002', 'user', 'MM007', '', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2711, 'EMP00000002', 'user', 'MM006', '', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2710, 'EMP00000002', 'user', 'MM004', '', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2709, 'EMP00000002', 'user', 'MM003', '', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2708, 'EMP00000002', 'user', 'MM001', '', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (1865, 'EMP00000001', 'admin', 'MM011', '', '2013-05-02 14:16:39', '', ''), (1866, 'EMP00000001', 'admin', '', 'SM130', '2013-05-02 14:18:23', '', ''), (1867, 'EMP00000001', 'admin', '', 'SM133', '2013-05-02 14:18:23', '', ''), (1868, 'EMP00000001', 'admin', '', 'SM134', '2013-05-13 09:53:09', '', ''), (1869, 'EMP00000001', 'admin', '', 'SM135', '2013-05-13 09:52:17', '', ''), (1870, 'EMP00000001', 'admin', '', 'SM136', '2013-05-13 11:01:03', '', ''), (1871, 'EMP00000001', 'admin', '', 'SM137', '2013-05-13 11:01:03', '', ''), (1879, 'EMP00000001', 'admin', '', 'SM141', '2013-05-14 09:56:52', '', ''), (1878, 'EMP00000001', 'admin', '', 'SM140', '2013-05-14 09:56:52', '', ''), (1877, 'EMP00000001', 'admin', '', 'SM139', '2013-05-14 09:48:42', '', ''), (1876, 'EMP00000001', 'admin', '', 'SM138', '2013-05-14 09:48:42', '', ''), (1880, 'EMP00000001', 'admin', '', 'SM142', '2013-05-15 08:26:00', '', ''), (1881, 'EMP00000001', 'admin', '', 'SM143', '2013-05-15 08:26:00', '', ''), (2000, 'EMP00000003', 'user2', '', 'SM018', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2001, 'EMP00000003', 'user2', '', 'SM020', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2002, 'EMP00000003', 'user2', '', 'SM031', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2003, 'EMP00000003', 'user2', '', 'SM055', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2004, 'EMP00000003', 'user2', '', 'SM058', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2005, 'EMP00000003', 'user2', '', 'SM066', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2006, 'EMP00000003', 'user2', '', 'SM067', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2007, 'EMP00000003', 'user2', '', 'SM072', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2008, 'EMP00000003', 'user2', '', 'SM073', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2009, 'EMP00000003', 'user2', '', 'SM074', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2010, 'EMP00000003', 'user2', '', 'SM002', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2011, 'EMP00000003', 'user2', '', 'SM021', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2012, 'EMP00000003', 'user2', '', 'SM022', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2013, 'EMP00000003', 'user2', '', 'SM023', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2014, 'EMP00000003', 'user2', '', 'SM075', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2015, 'EMP00000003', 'user2', '', 'SM071', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2016, 'EMP00000003', 'user2', '', 'SM076', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2017, 'EMP00000003', 'user2', '', 'SM026', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2018, 'EMP00000003', 'user2', '', 'SM037', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2019, 'EMP00000003', 'user2', '', 'SM032', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2020, 'EMP00000003', 'user2', '', 'SM027', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2021, 'EMP00000003', 'user2', '', 'SM068', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2022, 'EMP00000003', 'user2', '', 'SM074', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2023, 'EMP00000003', 'user2', '', 'SM033', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2024, 'EMP00000003', 'user2', '', 'SM077', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2025, 'EMP00000003', 'user2', '', 'SM068', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2026, 'EMP00000003', 'user2', '', 'SM075', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2027, 'EMP00000003', 'user2', '', 'SM034', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2028, 'EMP00000003', 'user2', '', 'SM056', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2029, 'EMP00000003', 'user2', '', 'SM024', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2030, 'EMP00000003', 'user2', '', 'SM078', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2031, 'EMP00000003', 'user2', '', 'SM079', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2032, 'EMP00000003', 'user2', '', 'SM023', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2033, 'EMP00000003', 'user2', '', 'SM075', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2034, 'EMP00000003', 'user2', '', 'SM079', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2035, 'EMP00000003', 'user2', '', 'SM056', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2036, 'EMP00000003', 'user2', '', 'SM060', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2037, 'EMP00000003', 'user2', '', 'SM066', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2038, 'EMP00000003', 'user2', '', 'SM038', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2039, 'EMP00000003', 'user2', '', 'SM067', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2040, 'EMP00000003', 'user2', '', 'SM067', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2041, 'EMP00000003', 'user2', '', 'SM035', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2042, 'EMP00000003', 'user2', '', 'SM036', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2043, 'EMP00000003', 'user2', '', 'SM080', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2044, 'EMP00000003', 'user2', '', 'SM081', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2045, 'EMP00000003', 'user2', '', 'SM055', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2046, 'EMP00000003', 'user2', '', 'SM056', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2047, 'EMP00000003', 'user2', '', 'SM039', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2048, 'EMP00000003', 'user2', '', 'SM040', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2049, 'EMP00000003', 'user2', '', 'SM041', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2050, 'EMP00000003', 'user2', '', 'SM042', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2051, 'EMP00000003', 'user2', '', 'SM043', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2052, 'EMP00000003', 'user2', '', 'SM042', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2053, 'EMP00000003', 'user2', '', 'SM043', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2054, 'EMP00000003', 'user2', '', 'SM069', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2055, 'EMP00000003', 'user2', '', 'SM070', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2056, 'EMP00000003', 'user2', '', 'SM078', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2057, 'EMP00000003', 'user2', '', 'SM082', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2058, 'EMP00000003', 'user2', '', 'SM083', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2059, 'EMP00000003', 'user2', '', 'SM084', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2060, 'EMP00000003', 'user2', '', 'SM085', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2061, 'EMP00000003', 'user2', '', 'SM086', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2062, 'EMP00000003', 'user2', '', 'SM087', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2063, 'EMP00000003', 'user2', '', 'SM088', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2064, 'EMP00000003', 'user2', '', 'SM089', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2065, 'EMP00000003', 'user2', '', 'SM090', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2066, 'EMP00000003', 'user2', '', 'SM091', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2067, 'EMP00000003', 'user2', '', 'SM092', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2068, 'EMP00000003', 'user2', '', 'SM093', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2069, 'EMP00000003', 'user2', '', 'SM094', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2070, 'EMP00000003', 'user2', '', 'SM095', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2071, 'EMP00000003', 'user2', '', 'SM096', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2072, 'EMP00000003', 'user2', '', 'SM099', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2073, 'EMP00000003', 'user2', '', 'SM101', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2074, 'EMP00000003', 'user2', '', 'SM102', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2075, 'EMP00000003', 'user2', '', 'SM103', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2076, 'EMP00000003', 'user2', '', 'SM104', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2077, 'EMP00000003', 'user2', '', 'SM105', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2078, 'EMP00000003', 'user2', '', 'SM106', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2079, 'EMP00000003', 'user2', '', 'SM107', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2080, 'EMP00000003', 'user2', '', 'SM108', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2081, 'EMP00000003', 'user2', '', 'SM109', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2082, 'EMP00000003', 'user2', '', 'SM110', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2083, 'EMP00000003', 'user2', '', 'SM111', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2084, 'EMP00000003', 'user2', '', 'SM112', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2085, 'EMP00000003', 'user2', '', 'SM114', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2086, 'EMP00000003', 'user2', '', 'SM115', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2087, 'EMP00000003', 'user2', '', 'SM116', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2088, 'EMP00000003', 'user2', '', 'SM117', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2089, 'EMP00000003', 'user2', '', 'SM118', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2090, 'EMP00000003', 'user2', '', 'SM119', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2091, 'EMP00000003', 'user2', '', 'SM120', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2092, 'EMP00000003', 'user2', '', 'SM121', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2093, 'EMP00000003', 'user2', '', 'SM122', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2094, 'EMP00000003', 'user2', '', 'SM123', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2095, 'EMP00000003', 'user2', '', 'SM124', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2096, 'EMP00000003', 'user2', '', 'SM125', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2097, 'EMP00000003', 'user2', '', 'SM126', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2098, 'EMP00000003', 'user2', '', 'SM127', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2099, 'EMP00000003', 'user2', '', 'SM128', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2100, 'EMP00000003', 'user2', '', 'SM129', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2101, 'EMP00000003', 'user2', '', 'SM130', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2102, 'EMP00000003', 'user2', '', 'SM131', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2103, 'EMP00000003', 'user2', '', 'SM132', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2104, 'EMP00000003', 'user2', '', 'SM133', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2105, 'EMP00000003', 'user2', '', 'SM134', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2106, 'EMP00000003', 'user2', '', 'SM135', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2107, 'EMP00000003', 'user2', '', 'SM136', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2108, 'EMP00000003', 'user2', '', 'SM137', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2109, 'EMP00000003', 'user2', '', 'SM138', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2110, 'EMP00000003', 'user2', '', 'SM139', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2111, 'EMP00000003', 'user2', '', 'SM140', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2112, 'EMP00000003', 'user2', '', 'SM141', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2113, 'EMP00000003', 'user2', '', 'SM142', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2114, 'EMP00000003', 'user2', '', 'SM143', '2013-05-18 09:17:02', '192.168.1.15', 'admin'), (2115, 'EMP00000001', 'admin', '', 'SM134', '2013-05-23 06:25:00', '', ''), (2116, 'EMP00000001', 'admin', '', 'SM135', '2013-05-23 06:25:00', '', ''), (2117, 'EMP00000001', 'admin', '', 'SM136', '2013-05-23 06:25:00', '', ''), (2118, 'EMP00000001', 'admin', '', 'SM137', '2013-05-23 06:25:00', '', ''), (2119, 'EMP00000001', 'admin', '', 'SM138', '2013-05-23 06:25:00', '', ''), (2120, 'EMP00000001', 'admin', '', 'SM139', '2013-05-23 06:25:00', '', ''), (2121, 'EMP00000001', 'admin', '', 'SM140', '2013-05-23 06:25:00', '', ''), (2122, 'EMP00000001', 'admin', '', 'SM141', '2013-05-23 06:25:00', '', ''), (2123, 'EMP00000001', 'admin', '', 'SM142', '2013-05-23 06:25:00', '', ''), (2124, 'EMP00000001', 'admin', '', 'SM143', '2013-05-23 06:25:00', '', ''), (2125, 'EMP00000001', 'admin', '', 'SM144', '2013-05-23 06:25:00', '', ''), (2126, 'EMP00000001', 'admin', '', 'SM145', '2013-05-23 06:25:00', '', ''), (2127, 'EMP00000001', 'admin', '', 'SM146', '2013-05-23 06:25:00', '', ''), (2128, 'EMP00000001', 'admin', '', 'SM147', '2013-05-23 06:25:00', '', ''), (2129, 'EMP00000001', 'admin', '', 'SM142', '2013-05-24 06:23:48', '', ''), (2130, 'EMP00000001', 'admin', '', 'SM143', '2013-05-24 06:23:48', '', ''), (2131, 'EMP00000001', 'admin', '', 'SM144', '2013-05-24 06:23:48', '', ''), (2132, 'EMP00000001', 'admin', '', 'SM145', '2013-05-24 06:23:48', '', ''), (2133, 'EMP00000001', 'admin', '', 'SM146', '2013-05-24 06:23:48', '', ''), (2134, 'EMP00000001', 'admin', '', 'SM147', '2013-05-24 06:23:48', '', ''), (2135, 'EMP00000001', 'admin', '', 'SM148', '2013-06-07 11:10:21', '', ''), (2136, 'EMP00000001', 'admin', '', 'SM149', '2013-06-20 12:37:55', '', ''), (2137, 'EMP00000001', 'admin', '', 'SM150', '2013-06-21 13:01:50', '', ''), (2138, 'EMP00000001', 'admin', '', 'SM151', '2013-06-22 06:16:29', '', ''), (2139, 'EMP00000001', 'admin', '', 'SM152', '2013-06-22 07:11:41', '', ''), (2140, 'EMP00000001', 'admin', '', 'SM153', '2013-06-22 07:42:36', '', ''), (2141, 'EMP00000001', 'admin', 'MM012', '', '2013-07-02 05:02:47', '', ''), (2142, 'EMP00000001', 'admin', '', 'SM154', '2013-07-02 05:11:25', '', ''), (2143, 'EMP00000001', 'admin', '', 'SM155', '2013-07-02 05:19:05', '', ''), (2144, 'EMP00000001', 'admin', '', 'SM156', '2013-07-02 05:25:27', '', ''), (2145, 'EMP00000001', 'admin', '', 'SM157', '2013-07-02 05:47:10', '', ''), (2146, 'EMP00000001', 'admin', '', 'SM158', '2013-07-02 05:53:34', '', ''), (2147, 'EMP00000001', 'admin', '', 'SM159', '2013-07-02 06:34:40', '', ''), (2148, 'EMP00000001', 'admin', '', 'SM160', '2013-07-02 13:38:09', '', ''), (2149, 'EMP00000001', 'admin', '', 'SM161', '2013-07-03 12:40:13', '', ''), (2150, 'EMP00000001', 'admin', '', 'SM162', '2013-07-03 13:37:46', '', ''), (2151, 'EMP00000001', 'admin', '', 'SM163', '2013-07-03 13:41:26', '', ''), (2152, 'EMP00000001', 'admin', '', 'SM164', '2013-07-03 13:46:45', '', ''), (2153, 'EMP00000001', 'admin', '', 'SM165', '2013-07-04 06:46:40', '', ''), (2154, 'EMP00000001', 'admin', '', 'SM166', '2013-07-04 07:24:55', '', ''), (2155, 'EMP00000001', 'admin', '', 'SM167', '2013-07-10 12:03:11', '', ''), (2707, 'EMP00000003', 'sundar', '', 'SM081', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2706, 'EMP00000003', 'sundar', '', 'SM167', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2705, 'EMP00000003', 'sundar', '', 'SM153', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2704, 'EMP00000003', 'sundar', '', 'SM152', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2703, 'EMP00000003', 'sundar', '', 'SM151', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2702, 'EMP00000003', 'sundar', '', 'SM150', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2701, 'EMP00000003', 'sundar', '', 'SM149', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2700, 'EMP00000003', 'sundar', '', 'SM148', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2699, 'EMP00000003', 'sundar', '', 'SM147', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2698, 'EMP00000003', 'sundar', '', 'SM146', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2697, 'EMP00000003', 'sundar', '', 'SM145', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2696, 'EMP00000003', 'sundar', '', 'SM144', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2695, 'EMP00000003', 'sundar', '', 'SM143', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2694, 'EMP00000003', 'sundar', '', 'SM142', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2693, 'EMP00000003', 'sundar', '', 'SM143', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2692, 'EMP00000003', 'sundar', '', 'SM142', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2691, 'EMP00000003', 'sundar', '', 'SM141', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2690, 'EMP00000003', 'sundar', '', 'SM140', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2689, 'EMP00000003', 'sundar', '', 'SM139', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2688, 'EMP00000003', 'sundar', '', 'SM138', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2687, 'EMP00000003', 'sundar', '', 'SM137', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2686, 'EMP00000003', 'sundar', '', 'SM136', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2685, 'EMP00000003', 'sundar', '', 'SM135', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2684, 'EMP00000003', 'sundar', '', 'SM134', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2683, 'EMP00000003', 'sundar', '', 'SM133', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2682, 'EMP00000003', 'sundar', '', 'SM132', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2681, 'EMP00000003', 'sundar', '', 'SM131', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2680, 'EMP00000003', 'sundar', '', 'SM130', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2679, 'EMP00000003', 'sundar', '', 'SM129', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2678, 'EMP00000003', 'sundar', '', 'SM128', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2677, 'EMP00000003', 'sundar', '', 'SM127', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2676, 'EMP00000003', 'sundar', '', 'SM126', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2675, 'EMP00000003', 'sundar', '', 'SM125', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2674, 'EMP00000003', 'sundar', '', 'SM124', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2673, 'EMP00000003', 'sundar', '', 'SM123', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2672, 'EMP00000003', 'sundar', '', 'SM122', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2671, 'EMP00000003', 'sundar', '', 'SM121', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2670, 'EMP00000003', 'sundar', '', 'SM120', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2669, 'EMP00000003', 'sundar', '', 'SM119', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2668, 'EMP00000003', 'sundar', '', 'SM118', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2667, 'EMP00000003', 'sundar', '', 'SM117', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2666, 'EMP00000003', 'sundar', '', 'SM116', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2665, 'EMP00000003', 'sundar', '', 'SM115', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2664, 'EMP00000003', 'sundar', '', 'SM114', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2663, 'EMP00000003', 'sundar', '', 'SM112', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2662, 'EMP00000003', 'sundar', '', 'SM110', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2661, 'EMP00000003', 'sundar', '', 'SM109', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2660, 'EMP00000003', 'sundar', '', 'SM107', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2659, 'EMP00000003', 'sundar', '', 'SM106', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2658, 'EMP00000003', 'sundar', '', 'SM103', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2657, 'EMP00000003', 'sundar', '', 'SM102', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2656, 'EMP00000003', 'sundar', '', 'SM101', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2655, 'EMP00000003', 'sundar', '', 'SM099', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2654, 'EMP00000003', 'sundar', '', 'SM096', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2653, 'EMP00000003', 'sundar', '', 'SM095', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2652, 'EMP00000003', 'sundar', '', 'SM094', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2651, 'EMP00000003', 'sundar', '', 'SM093', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2650, 'EMP00000003', 'sundar', '', 'SM092', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2649, 'EMP00000003', 'sundar', '', 'SM091', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2648, 'EMP00000003', 'sundar', '', 'SM090', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2647, 'EMP00000003', 'sundar', '', 'SM089', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2646, 'EMP00000003', 'sundar', '', 'SM088', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2645, 'EMP00000003', 'sundar', '', 'SM087', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2644, 'EMP00000003', 'sundar', '', 'SM086', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2643, 'EMP00000003', 'sundar', '', 'SM085', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2642, 'EMP00000003', 'sundar', '', 'SM084', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2641, 'EMP00000003', 'sundar', '', 'SM083', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2640, 'EMP00000003', 'sundar', '', 'SM082', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2639, 'EMP00000003', 'sundar', '', 'SM078', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2638, 'EMP00000003', 'sundar', '', 'SM070', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2637, 'EMP00000003', 'sundar', '', 'SM069', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2636, 'EMP00000003', 'sundar', '', 'SM043', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2635, 'EMP00000003', 'sundar', '', 'SM042', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2634, 'EMP00000003', 'sundar', '', 'SM043', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2633, 'EMP00000003', 'sundar', '', 'SM042', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2632, 'EMP00000003', 'sundar', '', 'SM041', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2631, 'EMP00000003', 'sundar', '', 'SM040', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2630, 'EMP00000003', 'sundar', '', 'SM039', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2629, 'EMP00000003', 'sundar', '', 'SM056', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2628, 'EMP00000003', 'sundar', '', 'SM055', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2627, 'EMP00000003', 'sundar', '', 'SM081', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2626, 'EMP00000003', 'sundar', '', 'SM080', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2625, 'EMP00000003', 'sundar', '', 'SM067', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2624, 'EMP00000003', 'sundar', '', 'SM067', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2623, 'EMP00000003', 'sundar', '', 'SM038', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2622, 'EMP00000003', 'sundar', '', 'SM066', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2621, 'EMP00000003', 'sundar', '', 'SM060', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2620, 'EMP00000003', 'sundar', '', 'SM056', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2619, 'EMP00000003', 'sundar', '', 'SM079', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2618, 'EMP00000003', 'sundar', '', 'SM075', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2617, 'EMP00000003', 'sundar', '', 'SM079', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2616, 'EMP00000003', 'sundar', '', 'SM078', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2615, 'EMP00000003', 'sundar', '', 'SM024', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2614, 'EMP00000003', 'sundar', '', 'SM056', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2613, 'EMP00000003', 'sundar', '', 'SM068', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2612, 'EMP00000003', 'sundar', '', 'SM077', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2611, 'EMP00000003', 'sundar', '', 'SM074', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2610, 'EMP00000003', 'sundar', '', 'SM068', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2609, 'EMP00000003', 'sundar', '', 'SM027', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2608, 'EMP00000003', 'sundar', '', 'SM032', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2607, 'EMP00000003', 'sundar', '', 'SM037', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2606, 'EMP00000003', 'sundar', '', 'SM026', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2605, 'EMP00000003', 'sundar', '', 'SM076', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2604, 'EMP00000003', 'sundar', '', 'SM071', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2603, 'EMP00000003', 'sundar', '', 'SM075', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2602, 'EMP00000003', 'sundar', '', 'SM023', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2601, 'EMP00000003', 'sundar', '', 'SM022', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2600, 'EMP00000003', 'sundar', '', 'SM021', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2599, 'EMP00000003', 'sundar', '', 'SM002', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2598, 'EMP00000003', 'sundar', '', 'SM074', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2597, 'EMP00000003', 'sundar', '', 'SM073', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2596, 'EMP00000003', 'sundar', '', 'SM072', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2595, 'EMP00000003', 'sundar', '', 'SM067', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2594, 'EMP00000003', 'sundar', '', 'SM066', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2593, 'EMP00000003', 'sundar', '', 'SM058', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2592, 'EMP00000003', 'sundar', '', 'SM055', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2591, 'EMP00000003', 'sundar', '', 'SM031', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2590, 'EMP00000003', 'sundar', '', 'SM020', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2589, 'EMP00000003', 'sundar', '', 'SM018', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2588, 'EMP00000003', 'sundar', '', 'SM017', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2587, 'EMP00000003', 'sundar', '', 'SM013', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2586, 'EMP00000003', 'sundar', '', 'SM012', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2585, 'EMP00000003', 'sundar', '', 'SM010', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2584, 'EMP00000003', 'sundar', '', 'SM009', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2583, 'EMP00000003', 'sundar', '', 'SM004', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2582, 'EMP00000003', 'sundar', '', 'SM003', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2581, 'EMP00000003', 'sundar', '', 'SM001', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2580, 'EMP00000003', 'sundar', 'MM000', '', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2579, 'EMP00000003', 'sundar', 'MM008', '', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2578, 'EMP00000003', 'sundar', 'MM003', '', '2014-04-25 17:40:21', '127.0.0.1', 'admin'), (2757, 'EMP00000002', 'user', '', 'SM060', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2758, 'EMP00000002', 'user', '', 'SM066', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2759, 'EMP00000002', 'user', '', 'SM038', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2760, 'EMP00000002', 'user', '', 'SM067', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2761, 'EMP00000002', 'user', '', 'SM067', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2762, 'EMP00000002', 'user', '', 'SM035', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2763, 'EMP00000002', 'user', '', 'SM036', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2764, 'EMP00000002', 'user', '', 'SM080', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2765, 'EMP00000002', 'user', '', 'SM081', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2766, 'EMP00000002', 'user', '', 'SM055', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2767, 'EMP00000002', 'user', '', 'SM056', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2768, 'EMP00000002', 'user', '', 'SM039', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2769, 'EMP00000002', 'user', '', 'SM040', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2770, 'EMP00000002', 'user', '', 'SM041', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2771, 'EMP00000002', 'user', '', 'SM042', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2772, 'EMP00000002', 'user', '', 'SM043', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2773, 'EMP00000002', 'user', '', 'SM042', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2774, 'EMP00000002', 'user', '', 'SM043', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2775, 'EMP00000002', 'user', '', 'SM069', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2776, 'EMP00000002', 'user', '', 'SM070', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2777, 'EMP00000002', 'user', '', 'SM078', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2778, 'EMP00000002', 'user', '', 'SM082', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2779, 'EMP00000002', 'user', '', 'SM083', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2780, 'EMP00000002', 'user', '', 'SM084', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2781, 'EMP00000002', 'user', '', 'SM085', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2782, 'EMP00000002', 'user', '', 'SM086', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2783, 'EMP00000002', 'user', '', 'SM087', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2784, 'EMP00000002', 'user', '', 'SM088', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2785, 'EMP00000002', 'user', '', 'SM089', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2786, 'EMP00000002', 'user', '', 'SM090', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2787, 'EMP00000002', 'user', '', 'SM091', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2788, 'EMP00000002', 'user', '', 'SM092', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2789, 'EMP00000002', 'user', '', 'SM093', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2790, 'EMP00000002', 'user', '', 'SM094', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2791, 'EMP00000002', 'user', '', 'SM095', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2792, 'EMP00000002', 'user', '', 'SM096', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2793, 'EMP00000002', 'user', '', 'SM099', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2794, 'EMP00000002', 'user', '', 'SM101', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2795, 'EMP00000002', 'user', '', 'SM102', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2796, 'EMP00000002', 'user', '', 'SM103', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2797, 'EMP00000002', 'user', '', 'SM104', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2798, 'EMP00000002', 'user', '', 'SM105', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2799, 'EMP00000002', 'user', '', 'SM106', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2800, 'EMP00000002', 'user', '', 'SM107', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2801, 'EMP00000002', 'user', '', 'SM108', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2802, 'EMP00000002', 'user', '', 'SM109', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2803, 'EMP00000002', 'user', '', 'SM110', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2804, 'EMP00000002', 'user', '', 'SM111', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2805, 'EMP00000002', 'user', '', 'SM112', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2806, 'EMP00000002', 'user', '', 'SM114', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2807, 'EMP00000002', 'user', '', 'SM123', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2808, 'EMP00000002', 'user', '', 'SM124', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2809, 'EMP00000002', 'user', '', 'SM125', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2810, 'EMP00000002', 'user', '', 'SM126', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2811, 'EMP00000002', 'user', '', 'SM127', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2812, 'EMP00000002', 'user', '', 'SM151', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2813, 'EMP00000002', 'user', '', 'SM152', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2814, 'EMP00000002', 'user', '', 'SM154', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2815, 'EMP00000002', 'user', '', 'SM155', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2816, 'EMP00000002', 'user', '', 'SM156', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2817, 'EMP00000002', 'user', '', 'SM157', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2818, 'EMP00000002', 'user', '', 'SM081', '2014-07-10 04:37:08', '27.61.121.117', 'admin'), (2819, 'EMP00000001', 'admin', '', 'SM168', '2014-07-21 20:31:08', '', 'admin'), (2820, 'EMP00000001', 'admin', '', 'SM169', '2014-07-21 20:31:08', '', 'admin'); -- -------------------------------------------------------- -- -- Table structure for table `master_item` -- CREATE TABLE `master_item` ( `auto_number` int(255) NOT NULL, `itemcode` varchar(255) COLLATE latin1_general_ci NOT NULL, `itemname` varchar(255) COLLATE latin1_general_ci NOT NULL, `rateperunit` decimal(12,2) NOT NULL, `status` varchar(255) COLLATE latin1_general_ci NOT NULL, `description` varchar(255) COLLATE latin1_general_ci NOT NULL, `volume` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; -- -- Dumping data for table `master_item` -- INSERT INTO `master_item` (`auto_number`, `itemcode`, `itemname`, `rateperunit`, `status`, `description`, `volume`) VALUES (26, '26', 'Wire Green', '0.00', '', '', 5), (27, '27', 'Cable', '0.00', '', '', 3), (24, '24', 'Compressor', '0.00', '', '', 4), (23, '23', 'Tile Cutter', '0.00', '', '', 5), (22, '22', 'Wood Cutter', '0.00', '', '', 5), (21, '21', 'Screw Drill', '0.00', '', '', 8), (20, '20', 'Dry Cutter', '0.00', '', '', 14), (19, '19', 'Welding Machine', '0.00', '', '', 13), (18, '18', 'Demolition Hammer', '0.00', '', '', 10), (17, '17', 'Cutt off Saw', '0.00', '', '', 9), (16, '16', 'Drilling Machine', '0.00', '', '', 16), (25, '25', 'Jig Saw', '0.00', '', '', 1), (28, '28', '8mm', '0.00', '', '', 8), (29, '29', '6mm', '0.00', '', '', 8), (30, '30', '10mm', '0.00', '', '', 5), (31, '31', '12mm', '0.00', '', '', 5), (32, '32', '14mm', '0.00', '', '', 5), (33, '33', '16mm', '0.00', '', '', 5), (34, '34', 'Long bit', '0.00', '', '', 5), (35, '35', '100\' Wall cutter', '0.00', '', '', 50), (36, '36', 'wire black', '0.00', '', '', 4), (37, '37', 'Check &Key', '0.00', '', '', 5), (38, '38', 'Wire Red', '0.00', '', '', 4), (39, '39', '90\' Wall cutting blade', '0.00', '', '', 50), (40, '40', '120\'Wall cutting blade', '0.00', '', '', 50), (41, '41', '120\' Wheel', '0.00', '', '', 50), (42, '42', '1\' mm Wheel', '0.00', '', '', 50), (43, '43', 'Wire yellow', '0.00', '', '', 3), (44, '44', 'HEAT GUN', '0.00', '', '', 1), (45, '45', 'MIXER', '0.00', '', '', 2), (46, '46', 'Grinding wheel', '0.00', '', '', 50), (47, '47', '120 wood blade', '0.00', '', '', 20), (48, '48', '13mm', '0.00', '', '', 5), (49, '', 'WIRE BLUE', '0.00', '', '', 3), (50, '', 'Demolishing Machine', '500.00', '', '', 10), (51, '', 'Welding Machine', '100.00', '', '', 5); -- -------------------------------------------------------- -- -- Table structure for table `master_menumain` -- CREATE TABLE `master_menumain` ( `auto_number` int(255) NOT NULL, `mainmenuid` varchar(255) COLLATE latin1_general_ci NOT NULL, `mainmenuorder` decimal(13,2) NOT NULL, `mainmenutext` varchar(255) COLLATE latin1_general_ci NOT NULL, `mainmenulink` text COLLATE latin1_general_ci NOT NULL, `status` varchar(255) COLLATE latin1_general_ci NOT NULL, `datetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; -- -- Dumping data for table `master_menumain` -- INSERT INTO `master_menumain` (`auto_number`, `mainmenuid`, `mainmenuorder`, `mainmenutext`, `mainmenulink`, `status`, `datetime`) VALUES (1, 'MM001', '1.00', 'Masters', '#', '', '2013-07-02 05:03:21'), (3, 'MM003', '3.00', 'Rental', '#', '', '2014-08-09 08:51:23'), (6, 'MM006', '6.00', 'Reports', '#', '', '2013-07-02 05:03:37'), (8, 'MM008', '8.00', 'Logout', 'logout1.php', '', '2013-07-02 05:05:00'), (9, 'MM000', '0.00', 'Home', '#', '', '2013-07-02 05:04:09'); -- -------------------------------------------------------- -- -- Table structure for table `master_menumain1` -- CREATE TABLE `master_menumain1` ( `auto_number` int(255) NOT NULL, `mainmenuid` varchar(255) COLLATE latin1_general_ci NOT NULL, `mainmenuorder` decimal(13,2) NOT NULL, `mainmenutext` varchar(255) COLLATE latin1_general_ci NOT NULL, `mainmenulink` text COLLATE latin1_general_ci NOT NULL, `status` varchar(255) COLLATE latin1_general_ci NOT NULL, `datetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; -- -- Dumping data for table `master_menumain1` -- INSERT INTO `master_menumain1` (`auto_number`, `mainmenuid`, `mainmenuorder`, `mainmenutext`, `mainmenulink`, `status`, `datetime`) VALUES (1, 'MM001', '1.00', 'Masters', 'menupage1.php?mainmenuid=MM001', '', '2013-11-09 06:21:44'), (3, 'MM003', '3.00', 'Sales', 'menupage1.php?mainmenuid=MM003', '', '2013-11-09 06:22:15'), (4, 'MM004', '4.00', 'Transaction', 'menupage1.php?mainmenuid=MM004', '', '2013-11-09 06:22:25'), (6, 'MM006', '6.00', 'Reports', 'menupage1.php?mainmenuid=MM006', '', '2013-11-09 06:22:38'), (7, 'MM007', '7.00', 'Settings', 'menupage1.php?mainmenuid=MM007', '', '2013-11-09 06:22:45'), (8, 'MM008', '8.00', 'Logout', 'logout1.php', '', '2013-07-02 05:05:00'), (9, 'MM000', '0.00', 'Home', 'mainmenu1.php', '', '2013-11-09 06:23:13'), (10, 'MM009', '3.50', 'Purchase', 'menupage1.php?mainmenuid=MM009', '', '2013-11-09 06:23:20'), (11, 'MM010', '4.50', 'Stock', 'menupage1.php?mainmenuid=MM010', '', '2013-11-09 06:23:28'), (12, 'MM002', '6.50', 'Production', 'menupage1.php?mainmenuid=MM002', '', '2014-03-21 16:51:23'), (13, 'MM005', '6.60', 'Approval', 'menupage1.php?mainmenuid=MM005', '', '2014-03-21 16:51:30'), (14, 'MM011', '7.50', 'Utility', 'menupage1.php?mainmenuid=MM011', '', '2013-11-09 06:23:55'), (15, 'MM012', '6.50', 'Leads', 'menupage1.php?mainmenuid=MM012', '', '2013-11-09 06:24:02'); -- -------------------------------------------------------- -- -- Table structure for table `master_menusub` -- CREATE TABLE `master_menusub` ( `auto_number` int(255) NOT NULL, `mainmenuid` varchar(255) COLLATE latin1_general_ci NOT NULL, `submenuid` varchar(255) COLLATE latin1_general_ci NOT NULL, `submenuorder` int(255) NOT NULL, `submenutext` varchar(255) COLLATE latin1_general_ci NOT NULL, `submenulink` text COLLATE latin1_general_ci NOT NULL, `status` varchar(255) COLLATE latin1_general_ci NOT NULL, `datetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; -- -- Dumping data for table `master_menusub` -- INSERT INTO `master_menusub` (`auto_number`, `mainmenuid`, `submenuid`, `submenuorder`, `submenutext`, `submenulink`, `status`, `datetime`) VALUES (9, 'MM001', 'SM009', 9, 'Item', 'additem1.php', '', '2014-08-07 18:56:47'), (10, 'MM001', 'SM010', 10, 'Customer', 'addcustomer1.php', '', '2011-03-03 19:26:45'), (31, 'MM003', 'SM031', 31, 'Rental Entry', 'sales1.php', '', '2014-08-07 19:04:49'), (106, 'MM006', 'SM056', 56, 'Stock report', 'stockreport1.php', '', '2014-08-08 20:02:06'), (107, 'MM006', 'SM060', 60, 'Stock report by rental', 'stockreportbyrental.php', '', '2014-08-08 20:02:42'), (108, 'MM006', 'SM066', 66, 'Customer wise Report', 'customerwisereport.php', '', '2014-08-08 20:03:25'), (110, 'MM006', 'SM067', 67, 'Pending Amount Report ', 'pendingamountreport.php', '', '2014-08-08 20:04:00'), (226, 'MM000', 'SM084', 84, 'Home', 'mainmenu1.php', '', '2014-08-07 18:56:02'), (227, 'MM003', 'SM068', 68, 'Edit Bill', 'salesbillreport.php', '', '2014-09-26 16:26:58'), (228, 'MM003', 'SM069', 69, 'Balance Entry', 'balance_entry.php', '', '2014-09-26 16:27:10'), (229, 'MM006', 'SM055', 55, 'Item Pending Report', 'returndatereport.php', '', '2014-12-30 04:34:34'), (230, 'MM006', 'SM070', 70, 'Return Date Report', 'returnreport.php', '', '2014-12-30 04:37:11'), (231, 'MM006', 'SM071', 71, 'Completed', 'customerwisereport_completed.php', '', '2015-04-28 02:47:23'), (104, 'MM006', 'SM058', 58, 'Pending', 'customerwisereport_pending.php', '', '2015-04-28 02:40:41'); -- -------------------------------------------------------- -- -- Table structure for table `master_printer` -- CREATE TABLE `master_printer` ( `auto_number` int(255) NOT NULL, `papersize` 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` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; -- -- Dumping data for table `master_printer` -- INSERT INTO `master_printer` (`auto_number`, `papersize`, `status`, `defaultstatus`, `ipaddress`, `updatetime`) VALUES (1, '40 Column Paper', '', '', '', '2014-07-06 14:22:05'), (2, 'A4 Sheet Paper', '', 'default', '', '2014-07-06 14:22:05'), (3, 'A5 Sheet Paper', '', '', '', '2013-02-18 06:23:44'); -- -------------------------------------------------------- -- -- Table structure for table `master_roundoff` -- CREATE TABLE `master_roundoff` ( `auto_number` int(255) NOT NULL, `roundoff` 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` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; -- -- Dumping data for table `master_roundoff` -- INSERT INTO `master_roundoff` (`auto_number`, `roundoff`, `status`, `defaultstatus`, `ipaddress`, `updatetime`) VALUES (1, 'NO ROUND OFF', '', '', '', '2014-05-03 09:07:23'), (2, 'NEAREST TEN PAISE', '', '', '', '2012-11-15 07:41:04'), (3, 'NEAREST FIFTY PAISE', '', '', '', '2013-01-02 10:58:42'), (4, 'NEAREST ONE RUPEE', '', 'default', '', '2014-05-03 09:07:23'), (5, 'NEAREST FIVE RUPEES', '', '', '', '2012-01-01 00:53:51'), (6, 'NEAREST TEN RUPEES', '', '', '', '2012-01-02 21:31:12'); -- -------------------------------------------------------- -- -- Table structure for table `master_sales` -- CREATE TABLE `master_sales` ( `auto_number` int(255) NOT NULL, `companyanum` int(255) NOT NULL, `billnumber` int(255) NOT NULL, `billnumberprefix` varchar(255) COLLATE latin1_general_ci NOT NULL, `billnumberpostfix` varchar(255) COLLATE latin1_general_ci NOT NULL, `billdate` datetime NOT NULL, `customertype` varchar(255) COLLATE latin1_general_ci NOT NULL, `subtotal` decimal(13,2) NOT NULL, `customercode` varchar(255) COLLATE latin1_general_ci NOT NULL, `customername` varchar(255) COLLATE latin1_general_ci NOT NULL, `address` varchar(255) COLLATE latin1_general_ci NOT NULL, `location` 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, `pincode` varchar(255) COLLATE latin1_general_ci NOT NULL, `phone` varchar(255) COLLATE latin1_general_ci NOT NULL, `email` 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, `delivery` decimal(13,2) NOT NULL, `packaging` decimal(13,2) NOT NULL, `roundoff` decimal(13,2) NOT NULL, `totalamount` decimal(13,2) NOT NULL, `totalquantity` decimal(13,2) NOT NULL, `billtype` varchar(255) COLLATE latin1_general_ci NOT NULL, `cash` decimal(13,2) NOT NULL, `credit` decimal(13,2) NOT NULL, `online` decimal(13,2) NOT NULL, `creditcard` decimal(13,2) NOT NULL, `creditcardname` varchar(255) COLLATE latin1_general_ci NOT NULL, `creditcardnumber` varchar(255) COLLATE latin1_general_ci NOT NULL, `creditcardbankname` varchar(255) COLLATE latin1_general_ci NOT NULL, `remarks` text COLLATE latin1_general_ci NOT NULL, `footerline1` varchar(255) COLLATE latin1_general_ci NOT NULL, `footerline2` varchar(255) COLLATE latin1_general_ci NOT NULL, `footerline3` varchar(255) COLLATE latin1_general_ci NOT NULL, `footerline4` varchar(255) COLLATE latin1_general_ci NOT NULL, `footerline5` varchar(255) COLLATE latin1_general_ci NOT NULL, `footerline6` varchar(255) COLLATE latin1_general_ci NOT NULL, `username` varchar(255) COLLATE latin1_general_ci NOT NULL, `subtotaldiscountrupees` decimal(13,2) NOT NULL, `subtotaldiscountpercent` decimal(13,2) NOT NULL, `subtotaldiscounttotal` decimal(13,2) NOT NULL, `subtotalafterdiscount` decimal(13,2) NOT NULL, `subtotalaftertax` decimal(13,2) NOT NULL, `deliverymode` varchar(255) COLLATE latin1_general_ci NOT NULL, `recordstatus` varchar(255) COLLATE latin1_general_ci NOT NULL, `lastupdate` datetime NOT NULL, `ipaddress` varchar(255) COLLATE latin1_general_ci NOT NULL, `cashgivenbycustomer` decimal(13,2) NOT NULL, `cashgiventocustomer` decimal(13,2) NOT NULL, `approvalstatus` varchar(255) COLLATE latin1_general_ci NOT NULL, `deliveryaddress` text COLLATE latin1_general_ci NOT NULL, `financialyear` year(4) NOT NULL, `subtotalamountdiscountpercent` decimal(13,2) NOT NULL, `subtotalamountdiscountamount` decimal(13,2) NOT NULL, `subtotalaftercombinediscount` decimal(13,2) NOT NULL, `subtotaldiscountpercentapply1` decimal(13,2) NOT NULL, `subtotaldiscountamountapply1` decimal(13,2) NOT NULL, `subtotaldiscountamountonlyapply1` decimal(13,2) NOT NULL, `subtotaldiscountamountonlyapply2` decimal(13,6) NOT NULL, `creditdays` int(255) NOT NULL, `creditdaysstatus` varchar(255) COLLATE latin1_general_ci NOT NULL, `sales_type` varchar(50) COLLATE latin1_general_ci NOT NULL, `invoice_no` varchar(50) COLLATE latin1_general_ci NOT NULL, `salesman` int(11) NOT NULL, `area` int(11) NOT NULL, `credit_adjust` float NOT NULL, `debit_adjust` float NOT NULL, `advance` float NOT NULL, `pending` float NOT NULL, `notes` text COLLATE latin1_general_ci NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; -- -- Dumping data for table `master_sales` -- INSERT INTO `master_sales` (`auto_number`, `companyanum`, `billnumber`, `billnumberprefix`, `billnumberpostfix`, `billdate`, `customertype`, `subtotal`, `customercode`, `customername`, `address`, `location`, `city`, `state`, `pincode`, `phone`, `email`, `tinnumber`, `cstnumber`, `delivery`, `packaging`, `roundoff`, `totalamount`, `totalquantity`, `billtype`, `cash`, `credit`, `online`, `creditcard`, `creditcardname`, `creditcardnumber`, `creditcardbankname`, `remarks`, `footerline1`, `footerline2`, `footerline3`, `footerline4`, `footerline5`, `footerline6`, `username`, `subtotaldiscountrupees`, `subtotaldiscountpercent`, `subtotaldiscounttotal`, `subtotalafterdiscount`, `subtotalaftertax`, `deliverymode`, `recordstatus`, `lastupdate`, `ipaddress`, `cashgivenbycustomer`, `cashgiventocustomer`, `approvalstatus`, `deliveryaddress`, `financialyear`, `subtotalamountdiscountpercent`, `subtotalamountdiscountamount`, `subtotalaftercombinediscount`, `subtotaldiscountpercentapply1`, `subtotaldiscountamountapply1`, `subtotaldiscountamountonlyapply1`, `subtotaldiscountamountonlyapply2`, `creditdays`, `creditdaysstatus`, `sales_type`, `invoice_no`, `salesman`, `area`, `credit_adjust`, `debit_adjust`, `advance`, `pending`, `notes`) VALUES (1, 5, 1, '', '', '2016-02-01 11:32:24', '', '0.00', 'CST00000001', '', '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', '0.00', '0.00', '', '0.00', '0.00', '0.00', '0.00', '', '', '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', '0.00', '0.00', '', '', '0000-00-00 00:00:00', '', '0.00', '0.00', '', '', 2016, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.000000', 0, '', '', 'MCP/14-15/0001', 0, 0, 0, 0, 400, 0, ''), (2, 5, 2, '', '', '2016-02-01 12:05:09', '', '0.00', 'CST00000001', '', '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', '0.00', '0.00', '', '0.00', '0.00', '0.00', '0.00', '', '', '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', '0.00', '0.00', '', '', '0000-00-00 00:00:00', '', '0.00', '0.00', '', '', 2016, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.000000', 0, '', '', 'MCP/14-15/0002', 0, 0, 0, 0, 200, 0, ''), (3, 5, 3, '', '', '2016-03-06 06:02:59', '', '0.00', 'CST00000001', '', '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', '0.00', '0.00', '', '0.00', '0.00', '0.00', '0.00', '', '', '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', '0.00', '0.00', '', '', '0000-00-00 00:00:00', '', '0.00', '0.00', '', '', 2016, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.000000', 0, '', '', 'MCP/14-15/0003', 0, 0, 0, 0, 100, 0, ''), (4, 5, 4, '', '', '2016-03-06 09:04:57', '', '0.00', 'CST00000001', '', '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', '0.00', '0.00', '', '0.00', '0.00', '0.00', '0.00', '', '', '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', '0.00', '0.00', '', '', '0000-00-00 00:00:00', '', '0.00', '0.00', '', '', 2016, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.000000', 0, '', '', 'MCP/14-15/0004', 0, 0, 0, 0, 150, 0, ''), (5, 5, 5, '', '', '2016-03-06 09:10:59', '', '0.00', 'CST00000002', '', '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', '0.00', '0.00', '', '0.00', '0.00', '0.00', '0.00', '', '', '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', '0.00', '0.00', '', '', '0000-00-00 00:00:00', '', '0.00', '0.00', '', '', 2016, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.000000', 0, '', '', 'MCP/14-15/0005', 0, 0, 0, 0, 0, 0, ''), (6, 5, 6, '', '', '2016-03-17 08:02:13', '', '0.00', 'CST00000002', '', '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', '0.00', '0.00', '', '0.00', '0.00', '0.00', '0.00', '', '', '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', '0.00', '0.00', '', 'DELETED', '0000-00-00 00:00:00', '', '0.00', '0.00', '', '', 2016, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.000000', 0, '', '', 'MCP/14-15/0006', 0, 0, 0, 0, 0, 0, ''), (7, 5, 6, '', '', '2016-03-17 08:06:21', '', '0.00', 'CST00000002', '', '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', '0.00', '0.00', '', '0.00', '0.00', '0.00', '0.00', '', '', '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', '0.00', '0.00', '', '', '0000-00-00 00:00:00', '', '0.00', '0.00', '', '', 2016, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.000000', 0, '', '', 'MCP/14-15/0006', 0, 0, 0, 0, 0, 0, ''), (8, 5, 7, '', '', '2016-03-17 08:16:47', '', '0.00', 'CST00000001', '', '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', '0.00', '0.00', '', '0.00', '0.00', '0.00', '0.00', '', '', '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', '0.00', '0.00', '', '', '0000-00-00 00:00:00', '', '0.00', '0.00', '', '', 2016, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.000000', 0, '', '', 'MCP/14-15/0007', 0, 0, 0, 0, 0, 0, ''), (9, 5, 8, '', '', '2016-03-17 08:21:15', '', '0.00', 'CST00000002', '', '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', '0.00', '0.00', '', '0.00', '0.00', '0.00', '0.00', '', '', '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', '0.00', '0.00', '', '', '0000-00-00 00:00:00', '', '0.00', '0.00', '', '', 2016, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.000000', 0, '', '', 'MCP/14-15/0008', 0, 0, 0, 0, 0, 0, ''), (10, 5, 9, '', '', '2016-03-17 08:23:54', '', '0.00', 'CST00000001', '', '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', '0.00', '0.00', '', '0.00', '0.00', '0.00', '0.00', '', '', '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', '0.00', '0.00', '', '', '0000-00-00 00:00:00', '', '0.00', '0.00', '', '', 2016, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.000000', 0, '', '', 'MCP/14-15/0009', 0, 0, 0, 0, 0, 0, ''), (11, 5, 10, '', '', '2016-12-28 03:42:24', '', '0.00', 'CST00000002', '', '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', '0.00', '0.00', '', '0.00', '0.00', '0.00', '0.00', '', '', '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', '0.00', '0.00', '', '', '0000-00-00 00:00:00', '', '0.00', '0.00', '', '', 2016, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.000000', 0, '', '', 'MCP/14-15/0010', 0, 0, 0, 0, 0, 0, ''), (12, 5, 11, '', '', '2016-12-28 05:49:33', '', '0.00', 'CST00000002', '', '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', '0.00', '0.00', '', '0.00', '0.00', '0.00', '0.00', '', '', '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', '0.00', '0.00', '', '', '0000-00-00 00:00:00', '', '0.00', '0.00', '', '', 2016, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.000000', 0, '', '', 'MCP/14-15/0011', 0, 0, 0, 0, 0, 0, ''), (13, 5, 12, '', '', '2018-11-26 10:12:56', '', '0.00', 'CST00000001', '', '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', '0.00', '0.00', '', '0.00', '0.00', '0.00', '0.00', '', '', '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', '0.00', '0.00', '', '', '0000-00-00 00:00:00', '', '0.00', '0.00', '', '', 2018, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.000000', 0, '', '', 'MCP/14-15/0012', 0, 0, 0, 0, 250, 0, ''); -- -------------------------------------------------------- -- -- Table structure for table `master_settings` -- CREATE TABLE `master_settings` ( `auto_number` int(255) NOT NULL, `companyanum` int(255) NOT NULL, `companycode` varchar(255) COLLATE latin1_general_ci NOT NULL, `modulename` varchar(255) COLLATE latin1_general_ci NOT NULL, `submodulename` varchar(255) COLLATE latin1_general_ci NOT NULL, `settingsname` varchar(255) COLLATE latin1_general_ci NOT NULL, `settingsvalue` varchar(255) COLLATE latin1_general_ci NOT NULL, `defaultvalue` 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, `username` varchar(255) COLLATE latin1_general_ci NOT NULL, `updatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; -- -- Dumping data for table `master_settings` -- INSERT INTO `master_settings` (`auto_number`, `companyanum`, `companycode`, `modulename`, `submodulename`, `settingsname`, `settingsvalue`, `defaultvalue`, `status`, `ipaddress`, `username`, `updatetime`) VALUES (1, 1, 'CPY00000001', 'SALES', '', 'SALES_ENTRY_STOCK_ALERT', 'HIDE ALERT', '', '', '127.0.0.1', 'admin', '2014-04-25 06:53:54'), (2, 1, 'CPY00000001', 'SALES', '', 'SALES_TAX_CALCULATE', 'FORWARD CALCULATE', '', '', '', '', '2014-03-17 10:43:20'), (3, 1, 'CPY00000001', 'PURCHASE', '', 'PURCHASE_TAX_CALCULATE', 'FORWARD CALCULATE', '', '', '', '', '2014-03-17 10:43:20'), (4, 1, 'CPY00000001', 'PRINTOUT', '', 'ITEM_CODE_PRINTOUT', 'SHOW ITEM CODE', '', '', '', '', '2014-03-17 10:43:20'), (5, 1, 'CPY00000001', 'STOCK', '', 'SALES_STOCK_UPDATE', 'SALES WITHOUT STOCK UPDATE', '', '', '', '', '2014-03-17 10:43:20'), (6, 1, 'CPY00000001', 'STOCK', '', 'PURCHASE_STOCK_UPDATE', 'PURCHASE WITHOUT STOCK UPDATE', '', '', '', '', '2014-03-17 10:43:20'), (7, 1, 'CPY00000001', 'STOCK', '', 'DC_STOCK_UPDATE', 'DC WITH STOCK UPDATE', '', '', '', '', '2014-03-17 10:43:20'), (8, 1, 'CPY00000001', 'SETTINGS', '', 'CURRENT_FINANCIAL_YEAR', '2014', '', '', '127.0.0.1', 'admin', '2014-03-21 12:35:01'), (9, 1, 'CPY00000001', 'SETTINGS', '', 'ITEM_PRICE_SETTING', 'GET PRICE FROM ITEM MASTER ENTRY', '', '', '', '', '2014-03-17 10:43:20'), (10, 1, 'CPY00000001', 'SETTINGS', '', 'SHOW_COLUMN_RATE', 'SHOW COLUMN RATE', '', '', '127.0.0.1', 'admin', '2014-03-17 12:46:46'), (11, 1, 'CPY00000001', 'SETTINGS', '', 'SHOW_COLUMN_QUANTITY', 'SHOW COLUMN QUANTITY', '', '', '127.0.0.1', 'admin', '2014-03-17 12:46:46'), (12, 1, 'CPY00000001', 'SETTINGS', '', 'SHOW_COLUMN_UNIT', 'SHOW COLUMN UNIT', '', '', '127.0.0.1', 'admin', '2014-03-17 12:46:46'), (13, 1, 'CPY00000001', 'SETTINGS', '', 'SHOW_COLUMN_TAX', 'SHOW COLUMN TAX', '', '', '127.0.0.1', 'admin', '2014-03-17 12:46:46'), (14, 1, 'CPY00000001', 'SETTINGS', '', 'SHOW_COLUMN_DISCOUNT', 'SHOW COLUMN DISCOUNT', '', '', '127.0.0.1', 'admin', '2014-03-17 12:46:46'), (15, 1, 'CPY00000001', 'SALES', '', 'PHONE_NUMBER_SALES_PRINT_SETTING', 'SHOW PHONE NUMBER ON SALES PRINTOUT', '', '', '127.0.0.1', 'admin', '2014-03-17 12:46:28'), (16, 1, 'CPY00000001', 'SALES', '', 'AMOUNT_IN_WORDS_SALES_PRINT_SETTING', 'SALES AMOUNT IN WORDS AS NORMAL TEXT', '', '', '', '', '2014-03-17 10:43:20'), (17, 1, 'CPY00000001', 'SETTINGS', '', 'SAME_ITEM_CODE_MULTIPLE_TIMES_SETTING', 'DENY SAME ITEM CODE MULTIPLE TIMES', '', '', '', '', '2014-03-17 10:43:20'), (18, 2, 'CPY00000002', 'SALES', '', 'SALES_ENTRY_STOCK_ALERT', 'HIDE ALERT', '', '', '', '', '2014-03-24 17:03:43'), (19, 2, 'CPY00000002', 'SALES', '', 'SALES_TAX_CALCULATE', 'FORWARD CALCULATE', '', '', '', '', '2014-03-24 17:03:43'), (20, 2, 'CPY00000002', 'PURCHASE', '', 'PURCHASE_TAX_CALCULATE', 'FORWARD CALCULATE', '', '', '', '', '2014-03-24 17:03:43'), (21, 2, 'CPY00000002', 'PRINTOUT', '', 'ITEM_CODE_PRINTOUT', 'SHOW ITEM CODE', '', '', '', '', '2014-03-24 17:03:43'), (22, 2, 'CPY00000002', 'STOCK', '', 'SALES_STOCK_UPDATE', 'SALES WITHOUT STOCK UPDATE', '', '', '', '', '2014-03-24 17:03:43'), (23, 2, 'CPY00000002', 'STOCK', '', 'PURCHASE_STOCK_UPDATE', 'PURCHASE WITHOUT STOCK UPDATE', '', '', '', '', '2014-03-24 17:03:43'), (24, 2, 'CPY00000002', 'STOCK', '', 'DC_STOCK_UPDATE', 'DC WITH STOCK UPDATE', '', '', '', '', '2014-03-24 17:03:43'), (25, 2, 'CPY00000002', 'SETTINGS', '', 'CURRENT_FINANCIAL_YEAR', '2013', '', '', '', '', '2014-03-24 17:03:43'), (26, 2, 'CPY00000002', 'SETTINGS', '', 'ITEM_PRICE_SETTING', 'GET PRICE FROM ITEM MASTER ENTRY', '', '', '', '', '2014-03-24 17:03:43'), (27, 2, 'CPY00000002', 'SETTINGS', '', 'SHOW_COLUMN_RATE', 'SHOW COLUMN RATE', '', '', '', '', '2014-03-24 17:03:43'), (28, 2, 'CPY00000002', 'SETTINGS', '', 'SHOW_COLUMN_QUANTITY', 'SHOW COLUMN QUANTITY', '', '', '', '', '2014-03-24 17:03:43'), (29, 2, 'CPY00000002', 'SETTINGS', '', 'SHOW_COLUMN_UNIT', 'SHOW COLUMN UNIT', '', '', '', '', '2014-03-24 17:03:43'), (30, 2, 'CPY00000002', 'SETTINGS', '', 'SHOW_COLUMN_TAX', 'SHOW COLUMN TAX', '', '', '', '', '2014-03-24 17:03:43'), (31, 2, 'CPY00000002', 'SETTINGS', '', 'SHOW_COLUMN_DISCOUNT', 'HIDE COLUMN DISCOUNT', '', '', '', '', '2014-03-24 17:03:43'), (32, 2, 'CPY00000002', 'SALES', '', 'PHONE_NUMBER_SALES_PRINT_SETTING', 'HIDE PHONE NUMBER ON SALES PRINTOUT', '', '', '', '', '2014-03-24 17:03:43'), (33, 2, 'CPY00000002', 'SALES', '', 'AMOUNT_IN_WORDS_SALES_PRINT_SETTING', 'SALES AMOUNT IN WORDS AS NORMAL TEXT', '', '', '', '', '2014-03-24 17:03:43'), (34, 2, 'CPY00000002', 'SETTINGS', '', 'SAME_ITEM_CODE_MULTIPLE_TIMES_SETTING', 'DENY SAME ITEM CODE MULTIPLE TIMES', '', '', '', '', '2014-03-24 17:03:43'), (35, 3, 'CPY00000002', 'SALES', '', 'SALES_ENTRY_STOCK_ALERT', 'HIDE ALERT', '', '', '', '', '2014-04-21 06:27:43'), (36, 3, 'CPY00000002', 'SALES', '', 'SALES_TAX_CALCULATE', 'FORWARD CALCULATE', '', '', '', '', '2014-04-21 06:27:43'), (37, 3, 'CPY00000002', 'PURCHASE', '', 'PURCHASE_TAX_CALCULATE', 'FORWARD CALCULATE', '', '', '', '', '2014-04-21 06:27:43'), (38, 3, 'CPY00000002', 'PRINTOUT', '', 'ITEM_CODE_PRINTOUT', 'SHOW ITEM CODE', '', '', '', '', '2014-04-21 06:27:43'), (39, 3, 'CPY00000002', 'STOCK', '', 'SALES_STOCK_UPDATE', 'SALES WITHOUT STOCK UPDATE', '', '', '', '', '2014-04-21 06:27:43'), (40, 3, 'CPY00000002', 'STOCK', '', 'PURCHASE_STOCK_UPDATE', 'PURCHASE WITHOUT STOCK UPDATE', '', '', '', '', '2014-04-21 06:27:43'), (41, 3, 'CPY00000002', 'STOCK', '', 'DC_STOCK_UPDATE', 'DC WITH STOCK UPDATE', '', '', '', '', '2014-04-21 06:27:43'), (42, 3, 'CPY00000002', 'SETTINGS', '', 'CURRENT_FINANCIAL_YEAR', '2013', '', '', '', '', '2014-04-21 06:27:43'), (43, 3, 'CPY00000002', 'SETTINGS', '', 'ITEM_PRICE_SETTING', 'GET PRICE FROM ITEM MASTER ENTRY', '', '', '', '', '2014-04-21 06:27:43'), (44, 3, 'CPY00000002', 'SETTINGS', '', 'SHOW_COLUMN_RATE', 'SHOW COLUMN RATE', '', '', '', '', '2014-04-21 06:27:43'), (45, 3, 'CPY00000002', 'SETTINGS', '', 'SHOW_COLUMN_QUANTITY', 'SHOW COLUMN QUANTITY', '', '', '', '', '2014-04-21 06:27:43'), (46, 3, 'CPY00000002', 'SETTINGS', '', 'SHOW_COLUMN_UNIT', 'SHOW COLUMN UNIT', '', '', '', '', '2014-04-21 06:27:43'), (47, 3, 'CPY00000002', 'SETTINGS', '', 'SHOW_COLUMN_TAX', 'SHOW COLUMN TAX', '', '', '', '', '2014-04-21 06:27:43'), (48, 3, 'CPY00000002', 'SETTINGS', '', 'SHOW_COLUMN_DISCOUNT', 'HIDE COLUMN DISCOUNT', '', '', '', '', '2014-04-21 06:27:43'), (49, 3, 'CPY00000002', 'SALES', '', 'PHONE_NUMBER_SALES_PRINT_SETTING', 'HIDE PHONE NUMBER ON SALES PRINTOUT', '', '', '', '', '2014-04-21 06:27:43'), (50, 3, 'CPY00000002', 'SALES', '', 'AMOUNT_IN_WORDS_SALES_PRINT_SETTING', 'SALES AMOUNT IN WORDS AS NORMAL TEXT', '', '', '', '', '2014-04-21 06:27:43'), (51, 3, 'CPY00000002', 'SETTINGS', '', 'SAME_ITEM_CODE_MULTIPLE_TIMES_SETTING', 'DENY SAME ITEM CODE MULTIPLE TIMES', '', '', '', '', '2014-04-21 06:27:43'), (52, 4, 'CPY00000002', 'SALES', '', 'SALES_ENTRY_STOCK_ALERT', 'HIDE ALERT', '', '', '', '', '2014-05-03 08:37:41'), (53, 4, 'CPY00000002', 'SALES', '', 'SALES_TAX_CALCULATE', 'FORWARD CALCULATE', '', '', '', '', '2014-05-03 08:37:41'), (54, 4, 'CPY00000002', 'PURCHASE', '', 'PURCHASE_TAX_CALCULATE', 'FORWARD CALCULATE', '', '', '', '', '2014-05-03 08:37:41'), (55, 4, 'CPY00000002', 'PRINTOUT', '', 'ITEM_CODE_PRINTOUT', 'SHOW ITEM CODE', '', '', '', '', '2014-05-03 08:37:41'), (56, 4, 'CPY00000002', 'STOCK', '', 'SALES_STOCK_UPDATE', 'SALES WITHOUT STOCK UPDATE', '', '', '', '', '2014-05-03 08:37:41'), (57, 4, 'CPY00000002', 'STOCK', '', 'PURCHASE_STOCK_UPDATE', 'PURCHASE WITHOUT STOCK UPDATE', '', '', '', '', '2014-05-03 08:37:41'), (58, 4, 'CPY00000002', 'STOCK', '', 'DC_STOCK_UPDATE', 'DC WITH STOCK UPDATE', '', '', '', '', '2014-05-03 08:37:41'), (59, 4, 'CPY00000002', 'SETTINGS', '', 'CURRENT_FINANCIAL_YEAR', '2013', '', '', '', '', '2014-05-03 08:37:41'), (60, 4, 'CPY00000002', 'SETTINGS', '', 'ITEM_PRICE_SETTING', 'GET PRICE FROM ITEM MASTER ENTRY', '', '', '', '', '2014-05-03 08:37:41'), (61, 4, 'CPY00000002', 'SETTINGS', '', 'SHOW_COLUMN_RATE', 'SHOW COLUMN RATE', '', '', '', '', '2014-05-03 08:37:41'), (62, 4, 'CPY00000002', 'SETTINGS', '', 'SHOW_COLUMN_QUANTITY', 'SHOW COLUMN QUANTITY', '', '', '', '', '2014-05-03 08:37:41'), (63, 4, 'CPY00000002', 'SETTINGS', '', 'SHOW_COLUMN_UNIT', 'SHOW COLUMN UNIT', '', '', '', '', '2014-05-03 08:37:41'), (64, 4, 'CPY00000002', 'SETTINGS', '', 'SHOW_COLUMN_TAX', 'SHOW COLUMN TAX', '', '', '', '', '2014-05-03 08:37:41'), (65, 4, 'CPY00000002', 'SETTINGS', '', 'SHOW_COLUMN_DISCOUNT', 'HIDE COLUMN DISCOUNT', '', '', '', '', '2014-05-03 08:37:41'), (66, 4, 'CPY00000002', 'SALES', '', 'PHONE_NUMBER_SALES_PRINT_SETTING', 'HIDE PHONE NUMBER ON SALES PRINTOUT', '', '', '', '', '2014-05-03 08:37:41'), (67, 4, 'CPY00000002', 'SALES', '', 'AMOUNT_IN_WORDS_SALES_PRINT_SETTING', 'SALES AMOUNT IN WORDS AS NORMAL TEXT', '', '', '', '', '2014-05-03 08:37:41'), (68, 4, 'CPY00000002', 'SETTINGS', '', 'SAME_ITEM_CODE_MULTIPLE_TIMES_SETTING', 'DENY SAME ITEM CODE MULTIPLE TIMES', '', '', '', '', '2014-05-03 08:37:41'), (69, 5, 'CPY00000002', 'SALES', '', 'SALES_ENTRY_STOCK_ALERT', 'HIDE ALERT', '', '', '', '', '2014-07-06 17:34:44'), (70, 5, 'CPY00000002', 'SALES', '', 'SALES_TAX_CALCULATE', 'FORWARD CALCULATE', '', '', '', '', '2014-07-06 17:34:44'), (71, 5, 'CPY00000002', 'PURCHASE', '', 'PURCHASE_TAX_CALCULATE', 'FORWARD CALCULATE', '', '', '', '', '2014-07-06 17:34:44'), (72, 5, 'CPY00000002', 'PRINTOUT', '', 'ITEM_CODE_PRINTOUT', 'SHOW ITEM CODE', '', '', '', '', '2014-07-06 17:34:44'), (73, 5, 'CPY00000002', 'STOCK', '', 'SALES_STOCK_UPDATE', 'SALES WITHOUT STOCK UPDATE', '', '', '', '', '2014-07-06 17:34:44'), (74, 5, 'CPY00000002', 'STOCK', '', 'PURCHASE_STOCK_UPDATE', 'PURCHASE WITHOUT STOCK UPDATE', '', '', '', '', '2014-07-06 17:34:44'), (75, 5, 'CPY00000002', 'STOCK', '', 'DC_STOCK_UPDATE', 'DC WITH STOCK UPDATE', '', '', '', '', '2014-07-06 17:34:44'), (76, 5, 'CPY00000002', 'SETTINGS', '', 'CURRENT_FINANCIAL_YEAR', '2014', '', '', '122.164.205.36', 'admin', '2014-07-16 20:10:43'), (77, 5, 'CPY00000002', 'SETTINGS', '', 'ITEM_PRICE_SETTING', 'GET PRICE FROM ITEM MASTER ENTRY', '', '', '', '', '2014-07-06 17:34:44'), (78, 5, 'CPY00000002', 'SETTINGS', '', 'SHOW_COLUMN_RATE', 'SHOW COLUMN RATE', '', '', '', '', '2014-07-06 17:34:44'), (79, 5, 'CPY00000002', 'SETTINGS', '', 'SHOW_COLUMN_QUANTITY', 'SHOW COLUMN QUANTITY', '', '', '', '', '2014-07-06 17:34:44'), (80, 5, 'CPY00000002', 'SETTINGS', '', 'SHOW_COLUMN_UNIT', 'SHOW COLUMN UNIT', '', '', '', '', '2014-07-06 17:34:44'), (81, 5, 'CPY00000002', 'SETTINGS', '', 'SHOW_COLUMN_TAX', 'SHOW COLUMN TAX', '', '', '', '', '2014-07-06 17:34:44'), (82, 5, 'CPY00000002', 'SETTINGS', '', 'SHOW_COLUMN_DISCOUNT', 'HIDE COLUMN DISCOUNT', '', '', '', '', '2014-07-06 17:34:44'), (83, 5, 'CPY00000002', 'SALES', '', 'PHONE_NUMBER_SALES_PRINT_SETTING', 'HIDE PHONE NUMBER ON SALES PRINTOUT', '', '', '', '', '2014-07-06 17:34:44'), (84, 5, 'CPY00000002', 'SALES', '', 'AMOUNT_IN_WORDS_SALES_PRINT_SETTING', 'SALES AMOUNT IN WORDS AS NORMAL TEXT', '', '', '', '', '2014-07-06 17:34:44'), (85, 5, 'CPY00000002', 'SETTINGS', '', 'SAME_ITEM_CODE_MULTIPLE_TIMES_SETTING', 'DENY SAME ITEM CODE MULTIPLE TIMES', '', '', '', '', '2014-07-06 17:34:44'); -- -------------------------------------------------------- -- -- Table structure for table `master_state` -- CREATE TABLE `master_state` ( `auto_number` int(15) NOT NULL, `state` varchar(100) COLLATE latin1_general_ci NOT NULL, `status` varchar(255) COLLATE latin1_general_ci NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; -- -- 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_tax` -- CREATE TABLE `master_tax` ( `auto_number` int(255) NOT NULL, `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 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; -- -- Dumping data for table `master_tax` -- INSERT INTO `master_tax` (`auto_number`, `taxname`, `taxpercent`, `defaulttax`, `status`, `ipaddress`, `updatetime`) VALUES (1, 'TAX', '0.0000', 'default', '', '192.168.1.15', '2013-02-18 11:09:38'); -- -------------------------------------------------------- -- -- Table structure for table `master_taxsub` -- CREATE TABLE `master_taxsub` ( `auto_number` int(255) NOT NULL, `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 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `sales_details` -- CREATE TABLE `sales_details` ( `auto_number` int(255) NOT NULL, `bill_autonumber` int(255) NOT NULL, `companyanum` int(255) NOT NULL, `billnumber` int(255) NOT NULL, `itemanum` int(255) NOT NULL, `itemcode` varchar(255) COLLATE latin1_general_ci NOT NULL, `itemname` text COLLATE latin1_general_ci NOT NULL, `itemdescription` text COLLATE latin1_general_ci NOT NULL, `unit_abbreviation` varchar(255) COLLATE latin1_general_ci NOT NULL, `rate` decimal(13,2) NOT NULL, `quantity` decimal(13,4) NOT NULL, `subtotal` decimal(13,2) NOT NULL, `free` varchar(255) COLLATE latin1_general_ci NOT NULL, `itemtaxpercentage` decimal(13,4) NOT NULL, `itemtaxamount` decimal(13,2) NOT NULL, `discountpercentage` decimal(13,2) NOT NULL, `discountrupees` decimal(13,2) NOT NULL, `openingstock` int(255) NOT NULL, `closingstock` int(255) NOT NULL, `totalamount` decimal(13,2) NOT NULL, `discountamount` decimal(13,2) NOT NULL, `recordstatus` varchar(255) COLLATE latin1_general_ci NOT NULL, `username` varchar(255) COLLATE latin1_general_ci NOT NULL, `ipaddress` varchar(255) COLLATE latin1_general_ci NOT NULL, `entrydate` date NOT NULL, `financialyear` year(4) NOT NULL, `freequantity` int(11) NOT NULL, `totalquantity` int(11) NOT NULL, `item_returned` int(1) NOT NULL, `customercode` varchar(50) COLLATE latin1_general_ci NOT NULL, `returned_date` datetime NOT NULL, `notes` text COLLATE latin1_general_ci NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; -- -- Dumping data for table `sales_details` -- INSERT INTO `sales_details` (`auto_number`, `bill_autonumber`, `companyanum`, `billnumber`, `itemanum`, `itemcode`, `itemname`, `itemdescription`, `unit_abbreviation`, `rate`, `quantity`, `subtotal`, `free`, `itemtaxpercentage`, `itemtaxamount`, `discountpercentage`, `discountrupees`, `openingstock`, `closingstock`, `totalamount`, `discountamount`, `recordstatus`, `username`, `ipaddress`, `entrydate`, `financialyear`, `freequantity`, `totalquantity`, `item_returned`, `customercode`, `returned_date`, `notes`) VALUES (1, 1, 5, 1, 47, '47', '120 wood blade', '', '', '0.00', '1.0000', '0.00', '', '0.0000', '0.00', '0.00', '0.00', 0, 0, '0.00', '0.00', '', 'admin', '127.0.0.1', '2016-02-01', 2016, 0, 6, 1, 'CST00000001', '2016-02-01 11:33:05', ''), (2, 1, 5, 1, 31, '31', '12mm', '', '', '0.00', '1.0000', '0.00', '', '0.0000', '0.00', '0.00', '0.00', 0, 0, '0.00', '0.00', '', 'admin', '127.0.0.1', '2016-02-01', 2016, 0, 5, 0, 'CST00000001', '0000-00-00 00:00:00', ''), (3, 2, 5, 2, 50, '50', 'Demolishing Machine', '', '', '0.00', '1.0000', '0.00', '', '0.0000', '0.00', '0.00', '0.00', 0, 0, '0.00', '0.00', '', 'admin', '127.0.0.1', '2016-02-01', 2016, 0, 3, 1, 'CST00000001', '2016-02-01 12:06:23', ''), (4, 2, 5, 2, 24, '24', 'Compressor', '', '', '0.00', '1.0000', '0.00', '', '0.0000', '0.00', '0.00', '0.00', 0, 0, '0.00', '0.00', '', 'admin', '127.0.0.1', '2016-02-01', 2016, 0, 1, 0, 'CST00000001', '0000-00-00 00:00:00', ''), (5, 3, 5, 3, 50, '50', 'Demolishing Machine', '', '', '0.00', '1.0000', '0.00', '', '0.0000', '0.00', '0.00', '0.00', 0, 0, '0.00', '0.00', '', 'admin', '127.0.0.1', '2016-03-06', 2016, 0, 2, 0, 'CST00000001', '0000-00-00 00:00:00', ''), (6, 3, 5, 3, 17, '17', 'Cutt off Saw', '', '', '0.00', '1.0000', '0.00', '', '0.0000', '0.00', '0.00', '0.00', 0, 0, '0.00', '0.00', '', 'admin', '127.0.0.1', '2016-03-06', 2016, 0, 1, 1, 'CST00000001', '2016-03-06 06:05:50', ''), (7, 4, 5, 4, 51, '51', 'Welding Machine', '', '', '0.00', '1.0000', '0.00', '', '0.0000', '0.00', '0.00', '0.00', 0, 0, '0.00', '0.00', '', 'admin', '127.0.0.1', '2016-03-06', 2016, 0, 2, 1, 'CST00000001', '2016-03-06 09:06:51', ''), (8, 4, 5, 4, 47, '47', '120 wood blade', '', '', '0.00', '1.0000', '0.00', '', '0.0000', '0.00', '0.00', '0.00', 0, 0, '0.00', '0.00', '', 'admin', '127.0.0.1', '2016-03-06', 2016, 0, 1, 0, 'CST00000001', '0000-00-00 00:00:00', ''), (9, 4, 5, 4, 25, '25', 'Jig Saw', '', '', '0.00', '1.0000', '0.00', '', '0.0000', '0.00', '0.00', '0.00', 0, 0, '0.00', '0.00', '', 'admin', '127.0.0.1', '2016-03-06', 2016, 0, 1, 0, 'CST00000001', '0000-00-00 00:00:00', ''), (10, 5, 5, 5, 17, '17', 'Cutt off Saw', '', '', '0.00', '1.0000', '0.00', '', '0.0000', '0.00', '0.00', '0.00', 0, 0, '0.00', '0.00', '', 'admin', '127.0.0.1', '2016-03-06', 2016, 0, 1, 0, 'CST00000002', '0000-00-00 00:00:00', ''), (11, 5, 5, 5, 50, '50', 'Demolishing Machine', '', '', '0.00', '1.0000', '0.00', '', '0.0000', '0.00', '0.00', '0.00', 0, 0, '0.00', '0.00', '', 'admin', '127.0.0.1', '2016-03-06', 2016, 0, 1, 0, 'CST00000002', '0000-00-00 00:00:00', ''), (12, 6, 5, 6, 17, '17', 'Cutt off Saw', '', '', '0.00', '1.0000', '0.00', '', '0.0000', '0.00', '0.00', '0.00', 0, 0, '0.00', '0.00', 'DELETED', 'admin', '127.0.0.1', '2016-03-17', 2016, 0, 2, 0, 'CST00000002', '0000-00-00 00:00:00', ''), (13, 6, 5, 6, 50, '50', 'Demolishing Machine', '', '', '0.00', '1.0000', '0.00', '', '0.0000', '0.00', '0.00', '0.00', 0, 0, '0.00', '0.00', 'DELETED', 'admin', '127.0.0.1', '2016-03-17', 2016, 0, 1, 0, 'CST00000002', '0000-00-00 00:00:00', ''), (14, 7, 5, 6, 50, '50', 'Demolishing Machine', '', '', '0.00', '1.0000', '0.00', '', '0.0000', '0.00', '0.00', '0.00', 0, 0, '0.00', '0.00', '', 'admin', '127.0.0.1', '2016-03-17', 2016, 0, 1, 0, 'CST00000002', '0000-00-00 00:00:00', ''), (15, 8, 5, 7, 24, '24', 'Compressor', '', '', '0.00', '1.0000', '0.00', '', '0.0000', '0.00', '0.00', '0.00', 0, 0, '0.00', '0.00', '', 'admin', '127.0.0.1', '2016-03-17', 2016, 0, 1, 0, 'CST00000001', '0000-00-00 00:00:00', ''), (16, 9, 5, 8, 40, '40', '120\'Wall cutting blade', '', '', '0.00', '1.0000', '0.00', '', '0.0000', '0.00', '0.00', '0.00', 0, 0, '0.00', '0.00', '', 'admin', '127.0.0.1', '2016-03-17', 2016, 0, 10, 0, 'CST00000002', '0000-00-00 00:00:00', ''), (17, 9, 5, 8, 19, '19', 'Welding Machine', '', '', '0.00', '1.0000', '0.00', '', '0.0000', '0.00', '0.00', '0.00', 0, 0, '0.00', '0.00', '', 'admin', '127.0.0.1', '2016-03-17', 2016, 0, 5, 0, 'CST00000002', '0000-00-00 00:00:00', ''), (18, 10, 5, 9, 17, '17', 'Cutt off Saw', '', '', '50.00', '1.0000', '50.00', '', '0.0000', '0.00', '0.00', '0.00', 0, 0, '0.00', '0.00', '', 'admin', '127.0.0.1', '2016-03-17', 2016, 0, 2, 0, 'CST00000001', '0000-00-00 00:00:00', ''), (19, 11, 5, 10, 16, '16', 'Drilling Machine', '', '', '100.00', '1.0000', '100.00', '', '0.0000', '0.00', '0.00', '0.00', 0, 0, '0.00', '0.00', '', 'admin', '127.0.0.1', '2016-12-28', 2016, 0, 5, 1, 'CST00000002', '2016-12-28 17:51:35', ''), (20, 12, 5, 11, 19, '19', 'Welding Machine', '', '', '100.00', '1.0000', '100.00', '', '0.0000', '0.00', '0.00', '0.00', 0, 0, '0.00', '0.00', '', 'admin', '127.0.0.1', '2016-12-28', 2016, 0, 2, 1, 'CST00000002', '2016-12-28 17:51:35', ''), (21, 12, 5, 11, 47, '47', '120 wood blade', '', '', '150.00', '1.0000', '150.00', '', '0.0000', '0.00', '0.00', '0.00', 0, 0, '0.00', '0.00', '', 'admin', '127.0.0.1', '2016-12-28', 2016, 0, 3, 1, 'CST00000002', '2016-12-28 17:51:35', ''), (22, 13, 5, 12, 40, '40', '120\'Wall cutting blade', '', '', '1.00', '1.0000', '1.00', '', '0.0000', '0.00', '0.00', '0.00', 0, 0, '0.00', '0.00', '', 'admin', '127.0.0.1', '2018-11-26', 2018, 0, 1, 1, 'CST00000001', '2018-11-26 10:13:59', ''), (23, 13, 5, 12, 39, '39', '90\' Wall cutting blade', '', '', '0.00', '1.0000', '0.00', '', '0.0000', '0.00', '0.00', '0.00', 0, 0, '0.00', '0.00', '', 'admin', '127.0.0.1', '2018-11-26', 2018, 0, 1, 0, 'CST00000001', '0000-00-00 00:00:00', ''); -- -------------------------------------------------------- -- -- Table structure for table `sales_tax` -- CREATE TABLE `sales_tax` ( `auto_number` int(255) NOT NULL, `bill_autonumber` int(255) NOT NULL, `billnumber` int(255) NOT NULL, `billdate` datetime NOT NULL, `itemanum` int(255) NOT NULL, `itemcode` varchar(255) COLLATE latin1_general_ci NOT NULL, `itemname` varchar(255) COLLATE latin1_general_ci NOT NULL, `itemrate` decimal(13,2) NOT NULL, `itemquantity` decimal(13,2) NOT NULL, `amountbeforetax` decimal(13,2) NOT NULL, `taxtype` varchar(255) COLLATE latin1_general_ci NOT NULL, `tax_autonumber` int(255) NOT NULL, `taxname` varchar(255) COLLATE latin1_general_ci NOT NULL, `taxpercent` decimal(13,4) NOT NULL, `taxamount` decimal(13,2) NOT NULL, `amountaftertax` decimal(13,2) NOT NULL, `ipaddress` varchar(255) COLLATE latin1_general_ci NOT NULL, `updatedate` datetime NOT NULL, `recordstatus` varchar(255) COLLATE latin1_general_ci NOT NULL, `companyanum` int(255) NOT NULL, `companyname` varchar(255) COLLATE latin1_general_ci NOT NULL, `financialyear` year(4) NOT NULL, `sales_type` varchar(50) COLLATE latin1_general_ci NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; -- -- Dumping data for table `sales_tax` -- INSERT INTO `sales_tax` (`auto_number`, `bill_autonumber`, `billnumber`, `billdate`, `itemanum`, `itemcode`, `itemname`, `itemrate`, `itemquantity`, `amountbeforetax`, `taxtype`, `tax_autonumber`, `taxname`, `taxpercent`, `taxamount`, `amountaftertax`, `ipaddress`, `updatedate`, `recordstatus`, `companyanum`, `companyname`, `financialyear`, `sales_type`) VALUES (1, 1, 1, '2016-02-26 00:00:00', 1, '112', 'Business Card', '3.00', '1000.00', '3000.00', 'main', 2, 'VAT @ 5.00 %', '5.0000', '150.00', '0.00', '127.0.0.1', '2016-02-26 15:10:33', '', 5, 'Smart Jet Solution', 2014, ''); -- -------------------------------------------------------- -- -- Table structure for table `settings_bill` -- CREATE TABLE `settings_bill` ( `auto_number` int(255) NOT NULL, `f1` text COLLATE latin1_general_ci NOT NULL, `f2` text COLLATE latin1_general_ci NOT NULL, `f3` text COLLATE latin1_general_ci NOT NULL, `f4` text COLLATE latin1_general_ci NOT NULL, `f5` text COLLATE latin1_general_ci NOT NULL, `f6` text COLLATE latin1_general_ci NOT NULL, `f7` text COLLATE latin1_general_ci NOT NULL, `f8` text COLLATE latin1_general_ci NOT NULL, `f9` text COLLATE latin1_general_ci NOT NULL, `f10` text COLLATE latin1_general_ci NOT NULL, `f11` text COLLATE latin1_general_ci NOT NULL, `f12` text COLLATE latin1_general_ci NOT NULL, `f13` text COLLATE latin1_general_ci NOT NULL, `f14` text COLLATE latin1_general_ci NOT NULL, `f15` text COLLATE latin1_general_ci NOT NULL, `f16` text COLLATE latin1_general_ci NOT NULL, `f17` text COLLATE latin1_general_ci NOT NULL, `f18` text COLLATE latin1_general_ci NOT NULL, `f19` text COLLATE latin1_general_ci NOT NULL, `f20` text COLLATE latin1_general_ci NOT NULL, `f21` text COLLATE latin1_general_ci NOT NULL, `f22` text COLLATE latin1_general_ci NOT NULL, `f23` text COLLATE latin1_general_ci NOT NULL, `f24` text COLLATE latin1_general_ci NOT NULL, `f25` text COLLATE latin1_general_ci NOT NULL, `f26` text COLLATE latin1_general_ci NOT NULL, `f27` text COLLATE latin1_general_ci NOT NULL, `f28` text COLLATE latin1_general_ci NOT NULL, `f29` text COLLATE latin1_general_ci NOT NULL, `f30` varchar(255) COLLATE latin1_general_ci NOT NULL, `f31` varchar(255) COLLATE latin1_general_ci NOT NULL, `f32` varchar(255) COLLATE latin1_general_ci NOT NULL, `f9size` int(255) NOT NULL, `f27size` int(255) NOT NULL, `f28size` int(255) NOT NULL, `f9color` varchar(255) COLLATE latin1_general_ci NOT NULL, `f10color` varchar(255) COLLATE latin1_general_ci NOT NULL, `f25color` varchar(255) COLLATE latin1_general_ci NOT NULL, `updatedby` varchar(255) COLLATE latin1_general_ci NOT NULL, `ipaddress` varchar(255) COLLATE latin1_general_ci NOT NULL, `updatedate` datetime NOT NULL, `companyanum` int(255) NOT NULL, `companyname` varchar(255) COLLATE latin1_general_ci NOT NULL, `companylogo` text COLLATE latin1_general_ci NOT NULL, `showlogo` varchar(255) COLLATE latin1_general_ci NOT NULL, `letterheadprinting` varchar(255) COLLATE latin1_general_ci NOT NULL, `billnumberprefix` varchar(255) COLLATE latin1_general_ci NOT NULL, `billnumberpostfix` varchar(255) COLLATE latin1_general_ci NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; -- -- Dumping data for table `settings_bill` -- INSERT INTO `settings_bill` (`auto_number`, `f1`, `f2`, `f3`, `f4`, `f5`, `f6`, `f7`, `f8`, `f9`, `f10`, `f11`, `f12`, `f13`, `f14`, `f15`, `f16`, `f17`, `f18`, `f19`, `f20`, `f21`, `f22`, `f23`, `f24`, `f25`, `f26`, `f27`, `f28`, `f29`, `f30`, `f31`, `f32`, `f9size`, `f27size`, `f28size`, `f9color`, `f10color`, `f25color`, `updatedby`, `ipaddress`, `updatedate`, `companyanum`, `companyname`, `companylogo`, `showlogo`, `letterheadprinting`, `billnumberprefix`, `billnumberpostfix`) VALUES (1, 'Original Copy', 'SSI NO:', 'I.E.CODE:', 'TIN NO:', 'CST NO:', 'Tele Fax No:', 'Phone No:', 'Email:', 'SMART JET SOLUTION', '201/54, Nehruji IInd Street, Kamaraj Nagar', 'Vyasarpadi, Chennai - 600039.', '9962159241, 9094558197', 'Bill To:', 'M/s.', 'INV NO.:', 'DATE:', 'Party TIN NO:', 'Your Order No:', 'Despatched To:', 'Party CST NO:', 'Sent Through :', 'L R / R R No.:', '', '1. Interest will be charged at 30% PA. if the Bill is not paid withing 30 days. \r\n2. All claims for shortage, loss, delay or damage should be preferred against carriers only. \r\n3. Every care is taken in Packing the goods and our responsibility ceases as soon as the goods leave our godown. \r\n4. Goods once sold will not be taken back. ', 'For SMART JET SOLUTION', 'Authorised Sign', 'SRI GANESHAYA NAMAHA', 'INVOICE', 'Packaging Charges', 'Delivery Charges', 'Your TIN No.', 'Your CST No.', 5, 3, 2, '', '', '', 'admin', '::1', '2014-07-06 20:11:02', 1, 'KOKA Technology', '', 'SHOW LOGO', '', '', ''), (2, 'Original Copy', 'SSI NO:', 'I.E.CODE:', 'TIN NO:', 'CST NO:', 'Tele Fax No:', 'Phone No:', 'Email:', 'Company Name Here', 'Address Line 1', 'Address Line 2', 'Address Line 3', 'Consignee,', 'M/s.', 'INV NO.:', 'DATE:', 'Party TIN NO:', 'Your Order No:', 'Despatched To:', 'Party CST NO:', 'Sent Through :', 'L R / R R No.:', '', '1. Interest will be charged at 30% PA. if the Bill is not paid withing 30 days. \r\n2. All claims for shortage, loss, delay or damage should be preferred against carriers only. \r\n3. Every care is taken in Packing the goods and our responsibility ceases as soon as the goods leave our godown. \r\n4. Goods once sold will not be taken back. ', 'For Company Name', 'Authorised Sign', 'SRI GANESHAYA NAMAHA', 'INVOICE', 'Packaging Charges', 'Delivery Charges', 'Your TIN No.', 'Your CST No.', 5, 2, 2, '', '', '', 'sundar', '127.0.0.1', '2014-04-21 12:03:37', 3, 'Sri Venkateshwara Enterprises', '', 'HIDE LOGO', '', '', ''), (3, 'Original Copy', 'SSI NO:', 'I.E.CODE:', 'TIN NO:', 'CST NO:', 'Tele Fax No:', 'Phone No:', 'Email:', 'Company Name Here', 'Address Line 1', 'Address Line 2', 'Address Line 3', 'Consignee,', 'M/s.', 'INV NO.:', 'DATE:', 'Party TIN NO:', 'Your Order No:', 'Despatched To:', 'Party CST NO:', 'Sent Through :', 'L R / R R No.:', '', '1. Interest will be charged at 30% PA. if the Bill is not paid withing 30 days. \r\n2. All claims for shortage, loss, delay or damage should be preferred against carriers only. \r\n3. Every care is taken in Packing the goods and our responsibility ceases as soon as the goods leave our godown. \r\n4. Goods once sold will not be taken back. ', 'For Company Name', 'Authorised Sign', 'SRI GANESHAYA NAMAHA', 'INVOICE', 'Packaging Charges', 'Delivery Charges', 'Your TIN No.', 'Your CST No.', 5, 2, 2, '', '', '', 'admin', '127.0.0.1', '2014-05-03 14:07:56', 4, 'Textiles', '', 'HIDE LOGO', '', '', ''), (4, 'Original Copy', 'SSI NO:', 'I.E.CODE:', 'TIN NO:', 'CST NO:', 'Tele Fax No:', 'Phone No:', 'Email:', 'SMART JET SOLUTION', 'Old No:201,New No.54,Nehruji IInd Street,', 'Kamaraj Nagar,Vyasarpadi, Chennai - 600039.', '9962159241, 9094558197', 'Bill To:', 'M/s.', 'Invoice No: ', 'Invoice Date: ', 'Party TIN NO:', 'Order No:', 'Docket No: ', 'Party CST NO:', 'Order Date :', 'Road Permit No: ', 'CST No.1209361 Dt:02.05.2013', '1. Interest @ 24% p.a will be charged on overdue unpaid bills.\r\n2. No-claims are entertained unless brought to our notice within three \r\n days of receipt of goods.\r\n3. All payments by A/C payees cheque or drafts only, payable at Chennai.\r\n4. Payment as per terms agreed.\r\n5. Goods once sold cannot be returned or exchange.\r\n6. All claims and disputes are subject to Chennai Jurisdiction.', 'For SMART JET SOLUTION', 'Authorised Signatory', 'SRI GANESHAYA NAMAHA', 'INVOICE', 'Packaging Charges', 'Delivery Charges', 'Email: smartjetsolution@gmail.com', 'TIN No.33911045251', 5, 2, 2, '', '', '', 'admin', '223.187.6.107', '2014-07-15 21:54:35', 5, 'Smart Jet Solution', '', 'SHOW LOGO', '', '', ''); -- -- Indexes for dumped tables -- -- -- Indexes for table `details_login` -- ALTER TABLE `details_login` ADD PRIMARY KEY (`auto_number`); -- -- Indexes for table `login_restriction` -- ALTER TABLE `login_restriction` ADD PRIMARY KEY (`auto_number`); -- -- Indexes for table `master_city` -- ALTER TABLE `master_city` ADD PRIMARY KEY (`auto_number`); -- -- Indexes for table `master_company` -- ALTER TABLE `master_company` ADD PRIMARY KEY (`auto_number`); -- -- Indexes for table `master_customer` -- ALTER TABLE `master_customer` ADD PRIMARY KEY (`auto_number`); -- -- Indexes for table `master_edition` -- ALTER TABLE `master_edition` ADD PRIMARY KEY (`auto_number`); -- -- Indexes for table `master_employee` -- ALTER TABLE `master_employee` ADD PRIMARY KEY (`auto_number`); -- -- Indexes for table `master_employeerights` -- ALTER TABLE `master_employeerights` ADD PRIMARY KEY (`auto_number`); -- -- Indexes for table `master_item` -- ALTER TABLE `master_item` ADD PRIMARY KEY (`auto_number`); -- -- Indexes for table `master_menumain` -- ALTER TABLE `master_menumain` ADD PRIMARY KEY (`auto_number`); -- -- Indexes for table `master_menumain1` -- ALTER TABLE `master_menumain1` ADD PRIMARY KEY (`auto_number`); -- -- Indexes for table `master_menusub` -- ALTER TABLE `master_menusub` ADD PRIMARY KEY (`auto_number`); -- -- Indexes for table `master_printer` -- ALTER TABLE `master_printer` ADD PRIMARY KEY (`auto_number`); -- -- Indexes for table `master_roundoff` -- ALTER TABLE `master_roundoff` ADD PRIMARY KEY (`auto_number`); -- -- Indexes for table `master_sales` -- ALTER TABLE `master_sales` ADD PRIMARY KEY (`auto_number`); -- -- Indexes for table `master_settings` -- ALTER TABLE `master_settings` ADD PRIMARY KEY (`auto_number`); -- -- Indexes for table `master_state` -- ALTER TABLE `master_state` ADD PRIMARY KEY (`auto_number`); -- -- Indexes for table `master_tax` -- ALTER TABLE `master_tax` ADD PRIMARY KEY (`auto_number`); -- -- Indexes for table `master_taxsub` -- ALTER TABLE `master_taxsub` ADD PRIMARY KEY (`auto_number`); -- -- Indexes for table `sales_details` -- ALTER TABLE `sales_details` ADD PRIMARY KEY (`auto_number`); -- -- Indexes for table `sales_tax` -- ALTER TABLE `sales_tax` ADD PRIMARY KEY (`auto_number`); -- -- Indexes for table `settings_bill` -- ALTER TABLE `settings_bill` ADD PRIMARY KEY (`auto_number`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `details_login` -- ALTER TABLE `details_login` MODIFY `auto_number` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16; -- -- AUTO_INCREMENT for table `login_restriction` -- ALTER TABLE `login_restriction` MODIFY `auto_number` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1279; -- -- AUTO_INCREMENT for table `master_city` -- ALTER TABLE `master_city` MODIFY `auto_number` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1153; -- -- AUTO_INCREMENT for table `master_company` -- ALTER TABLE `master_company` MODIFY `auto_number` int(13) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `master_customer` -- ALTER TABLE `master_customer` MODIFY `auto_number` int(13) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `master_edition` -- ALTER TABLE `master_edition` MODIFY `auto_number` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `master_employee` -- ALTER TABLE `master_employee` MODIFY `auto_number` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `master_employeerights` -- ALTER TABLE `master_employeerights` MODIFY `auto_number` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2821; -- -- AUTO_INCREMENT for table `master_item` -- ALTER TABLE `master_item` MODIFY `auto_number` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=52; -- -- AUTO_INCREMENT for table `master_menumain` -- ALTER TABLE `master_menumain` MODIFY `auto_number` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16; -- -- AUTO_INCREMENT for table `master_menumain1` -- ALTER TABLE `master_menumain1` MODIFY `auto_number` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17; -- -- AUTO_INCREMENT for table `master_menusub` -- ALTER TABLE `master_menusub` MODIFY `auto_number` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=232; -- -- AUTO_INCREMENT for table `master_printer` -- ALTER TABLE `master_printer` MODIFY `auto_number` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `master_roundoff` -- ALTER TABLE `master_roundoff` MODIFY `auto_number` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `master_sales` -- ALTER TABLE `master_sales` MODIFY `auto_number` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; -- -- AUTO_INCREMENT for table `master_settings` -- ALTER TABLE `master_settings` MODIFY `auto_number` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=86; -- -- AUTO_INCREMENT for table `master_state` -- ALTER TABLE `master_state` MODIFY `auto_number` int(15) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35; -- -- AUTO_INCREMENT for table `master_tax` -- ALTER TABLE `master_tax` MODIFY `auto_number` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `master_taxsub` -- ALTER TABLE `master_taxsub` MODIFY `auto_number` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `sales_details` -- ALTER TABLE `sales_details` MODIFY `auto_number` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24; -- -- AUTO_INCREMENT for table `sales_tax` -- ALTER TABLE `sales_tax` MODIFY `auto_number` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `settings_bill` -- ALTER TABLE `settings_bill` MODIFY `auto_number` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; COMMIT; /*!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 */;