bnmbertertertertertertertertertertertertertertertertertertertertdfg

hjkhhrtertererrrdfbdfbdfbdfbdfgdrtertertertrt bnmbertertertertertertertertertertertertertertertertertertertertdfg

CREATE TABLE `adminlogin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `loginid` varchar(150) NOT NULL,
  `pass` varchar(500) NOT NULL,
  `sts` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO adminlogin VALUES("1","admin","admin","1");

CREATE TABLE `attandance` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `jid` int(11) NOT NULL,
  `mid` int(11) NOT NULL,
  `presents` int(11) NOT NULL,
  `dates` varchar(100) NOT NULL,
  `sts` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `battas` (
  `ids` int(11) NOT NULL AUTO_INCREMENT,
  `jid` varchar(200) NOT NULL,
  `batta` varchar(50) NOT NULL,
  `exbatta` varchar(50) NOT NULL,
  `adnce` varchar(100) NOT NULL,
  `sts` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`ids`)
) ENGINE=InnoDB AUTO_INCREMENT=98 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO battas VALUES("1","yIhZwhwCfYmfNHBVRZyf","0","0","0","1");
INSERT INTO battas VALUES("2","viPlrLGqhBaCFpkYCaDc","0","0","0","1");
INSERT INTO battas VALUES("3","jzHtIyVSBEBgCjoDPQXR","0","0","0","1");
INSERT INTO battas VALUES("4","BwKFccwwoTtKUFnNpckx","0","0","0","1");
INSERT INTO battas VALUES("5","eFLFeIZIETXiRotxvIqx","0","0","0","1");
INSERT INTO battas VALUES("6","YWzVLVqexHyrUqbcGSyN","0","0","0","1");
INSERT INTO battas VALUES("7","rNhDxKKKMxmyycrFwGdM","0","0","0","1");
INSERT INTO battas VALUES("8","ZEZerARHkebkKPJOlBiD","0","0","0","1");
INSERT INTO battas VALUES("9","UBjGnHHQNBlEkjYFuvGj","0","0","0","1");
INSERT INTO battas VALUES("10","xOFmUYaQreBHliIobDOM","0","0","0","1");
INSERT INTO battas VALUES("11","MMkfxCeYxVVQYQfFAZpp","0","0","0","1");
INSERT INTO battas VALUES("12","KFaKlshCzMKYTwxLCSvb","0","0","0","1");
INSERT INTO battas VALUES("13","NvkPRIXBfXpHegRGmoQO","0","0","0","1");
INSERT INTO battas VALUES("14","NiUMajzEPXewWYymsuNn","0","0","0","1");
INSERT INTO battas VALUES("15","OwCmezKNnoybyhKTxKCN","0","0","0","1");
INSERT INTO battas VALUES("16","XymrVnlMLTlcqjrPuTAN","0","0","0","1");
INSERT INTO battas VALUES("17","KsweJfxlgfUPQJgVnAkW","0","0","0","1");
INSERT INTO battas VALUES("18","bxbPvBcpXvXzufcXKSzm","0","0","0","1");
INSERT INTO battas VALUES("19","NHoSboDycMCBAKmEFjVk","0","0","0","1");
INSERT INTO battas VALUES("20","LLJEYJBciMcEwgaJBVEZ","0","0","0","1");
INSERT INTO battas VALUES("21","JfNbaYBhaMAhvlVJokpk","2000","0","0","1");
INSERT INTO battas VALUES("22","zTFAJwBCsjouUwdPLDJf","0","0","0","1");
INSERT INTO battas VALUES("23","gjxwZjYdTkmODDcDRqVk","0","0","0","1");
INSERT INTO battas VALUES("24","SqYtTHPlHqEXMnYRoAEv","0","0","0","1");
INSERT INTO battas VALUES("25","iBCRKSZeLbqdXSDpDpoq","0","0","0","1");
INSERT INTO battas VALUES("26","lOfGWMrXnTChHFQmkPSd","0","0","0","1");
INSERT INTO battas VALUES("27","EzlYMGjFMvSWLDyhuYCc","0","0","0","1");
INSERT INTO battas VALUES("28","lmNtlSkGjObPYCmTIOfL","0","0","0","1");
INSERT INTO battas VALUES("29","zWAIkjrinHrPylsOLyKU","0","0","0","1");
INSERT INTO battas VALUES("30","etRLQigbsbJinjJozuIC","0","0","0","1");
INSERT INTO battas VALUES("31","OJUjEtfzJhYCvqHnsEUo","0","0","0","1");
INSERT INTO battas VALUES("32","hrzywLrvWIRTdyoPyxRs","0","0","0","1");
INSERT INTO battas VALUES("33","fGfdVzkvEOWtftdRHsZE","0","0","0","1");
INSERT INTO battas VALUES("34","ihjDavaOiMppxTDeTprY","0","0","0","1");
INSERT INTO battas VALUES("35","UsvnjOtQyiKGXvCEzaFC","0","0","0","1");
INSERT INTO battas VALUES("36","jeaskUrKrpUKKKYnanVT","0","0","0","1");
INSERT INTO battas VALUES("37","oghIwYpHRsBcqOfQJnZL","0","0","0","1");
INSERT INTO battas VALUES("38","sETFhlohzupvnhiKNDRn","0","0","0","1");
INSERT INTO battas VALUES("39","ldYwbJzugUkVLrmGqReg","0","0","0","1");
INSERT INTO battas VALUES("40","BtegyJVAaxWyTgmgvWwl","0","0","0","1");
INSERT INTO battas VALUES("41","sEMzRAYrYVEXkgoRkNml","0","0","0","1");
INSERT INTO battas VALUES("42","ZOxLdMxdIcyQlaMzYEMD","0","0","0","1");
INSERT INTO battas VALUES("43","zRGdietBeevwCXDQZHnn","0","0","0","1");
INSERT INTO battas VALUES("44","JZMUsEktgmghiACSvUNq","0","0","0","1");
INSERT INTO battas VALUES("45","fyTWTTLfoqzJbEQVsfhp","0","0","0","1");
INSERT INTO battas VALUES("46","rSaYXYOJvxSzJYTWMBle","0","0","0","1");
INSERT INTO battas VALUES("47","AtviTTORsExANYjTenqm","0","0","0","1");
INSERT INTO battas VALUES("48","kqMrimPPrYXyevRNTpQa","0","0","0","1");
INSERT INTO battas VALUES("49","ieIHUVqfofBSRsWjiuRA","0","0","0","1");
INSERT INTO battas VALUES("50","gOpOhMmjbXQrVYeLhRFI","2000","0","0","1");
INSERT INTO battas VALUES("51","UozTAgbAXXEwIwfIurXe","3000","0","0","1");
INSERT INTO battas VALUES("52","hUpEulgXgbpOXIeVFIoW","2000","0","0","1");
INSERT INTO battas VALUES("53","AlqKxJdQaHtkkcoLppqd","3000","0","0","1");
INSERT INTO battas VALUES("54","eUwzeFJoRTChYEzrwPmH","2000","0","0","1");
INSERT INTO battas VALUES("55","ZoLpUFsXyQyqLWGtrlcN","2000","0","0","1");
INSERT INTO battas VALUES("56","WMvdrlamRKbTDitkhhuV","2000","0","0","1");
INSERT INTO battas VALUES("57","PrSyzhnpiNqfFGMMlftx","2000","3000","0","1");
INSERT INTO battas VALUES("58","AGrYqJnGaHXmxsKQicYN","0","0","0","1");
INSERT INTO battas VALUES("59","LZObULGyHAtWbHTdlSwh","2000","0","0","1");
INSERT INTO battas VALUES("60","ogAFAHslvFOGabQgnUnH","2000","4000","0","1");
INSERT INTO battas VALUES("61","NQaEhZafMWzjICrfsMZB","0","0","0","1");
INSERT INTO battas VALUES("62","jVdJxMGGlmturGbUmjfm","0","0","0","1");
INSERT INTO battas VALUES("63","YPsFEOAbvOTGmQSRZfuv","2000","3000","0","1");
INSERT INTO battas VALUES("64","KcPjIpQjsFonPxAyIyqf","2000","0","0","1");
INSERT INTO battas VALUES("65","tWVMvrBjsuTJyoHXfzxr","0","0","0","1");
INSERT INTO battas VALUES("66","XosoFYeMJLUvoWfVvNcG","0","0","0","1");
INSERT INTO battas VALUES("67","HHrSkNmMlXuxkNuuiqTw","2000","0","0","1");
INSERT INTO battas VALUES("68","WntHsflqUNtdqunYmVeR","2000","0","0","1");
INSERT INTO battas VALUES("69","LAGjucyMgvIyNfFIAteQ","0","0","0","1");
INSERT INTO battas VALUES("70","WGjgLcLzgcPZfpVzxRsa","2000","0","0","1");
INSERT INTO battas VALUES("71","paobQmmNnGudtTTPwtlC","0","0","0","1");
INSERT INTO battas VALUES("72","EzklpFtgYYhzwKPathMV","2000","0","0","1");
INSERT INTO battas VALUES("73","gIIkEHnmuRDdEjdTYfrm","2000","0","0","1");
INSERT INTO battas VALUES("74","UHjaHZcXOQwLZWzbsGXa","2000","0","0","1");
INSERT INTO battas VALUES("75","yuQyWiygSPNqprqPLBmI","2000","2000","0","1");
INSERT INTO battas VALUES("76","yobrYkfryqrtWtfKmNYb","0","0","0","1");
INSERT INTO battas VALUES("77","mIiIaYQjPgiWUTdNWKnn","0","0","0","1");
INSERT INTO battas VALUES("78","WOqgNyryTsjJOhezrVIw","0","0","0","1");
INSERT INTO battas VALUES("79","UFFxCypvYAyCRCeoGMjy","2000","0","0","1");
INSERT INTO battas VALUES("80","HqvVVFMxjTFRAmKBoMWb","2000","0","65000","1");
INSERT INTO battas VALUES("81","BLkmbxevhXbtpDaMFVxG","0","0","0","1");
INSERT INTO battas VALUES("82","JLAChJbDfSmKVIzbhYYb","2000","0","0","1");
INSERT INTO battas VALUES("83","RZRAPmUtHlQSpOTlEPss","0","0","0","1");
INSERT INTO battas VALUES("84","DdAGcJJOiFieBlMjryYa","2000","0","0","1");
INSERT INTO battas VALUES("85","nixidcbpTVytXztoMJoV","2000","0","0","1");
INSERT INTO battas VALUES("86","uoxhaXEvKvfBlRzyzYmS","2000","0","0","1");
INSERT INTO battas VALUES("87","UrvSIypOJkLUdAGOpggA","0","0","0","1");
INSERT INTO battas VALUES("88","SWBfJyCSiMzIzUuAumtM","0","0","0","1");
INSERT INTO battas VALUES("89","HveCAKwEUgbYnYvCnSLg","0","0","0","1");
INSERT INTO battas VALUES("90","RvjXBihTjpNgIxEIeONw","2000","0","0","1");
INSERT INTO battas VALUES("91","eTTfxAOrBKOnYStVZJbv","0","0","0","1");
INSERT INTO battas VALUES("92","hXWzNyxBOUojhJrIdBAF","2000","0","0","1");
INSERT INTO battas VALUES("93","BykHRgTPYIIBdFuNcUBO","2000","0","0","1");
INSERT INTO battas VALUES("94","sexbCAFzXAyrkzTmlZNL","2000","0","0","1");
INSERT INTO battas VALUES("95","UYcZtdXUptgXbtvNQBFh","2000","0","0","1");
INSERT INTO battas VALUES("96","UUMndzaJmwghsWBXGoMi","0","3000","0","1");
INSERT INTO battas VALUES("97","IfwENafDROQMqlkEJZpF","0","0","0","1");

CREATE TABLE `bits` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mid` int(11) NOT NULL,
  `bit` varchar(150) NOT NULL,
  `numbr` varchar(200) NOT NULL,
  `date` varchar(50) NOT NULL,
  `sts` int(11) DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `bituse` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `jid` varchar(150) DEFAULT NULL,
  `bit` varchar(50) DEFAULT NULL,
  `bitno` varchar(100) DEFAULT NULL,
  `fetage` varchar(50) DEFAULT NULL,
  `mid` int(11) DEFAULT NULL,
  `sts` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=96 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO bituse VALUES("1","yIhZwhwCfYmfNHBVRZyf","","","54","1","1");
INSERT INTO bituse VALUES("2","viPlrLGqhBaCFpkYCaDc","","","62","1","1");
INSERT INTO bituse VALUES("3","jzHtIyVSBEBgCjoDPQXR","","","0","1","1");
INSERT INTO bituse VALUES("4","BwKFccwwoTtKUFnNpckx","","","56","1","1");
INSERT INTO bituse VALUES("5","eFLFeIZIETXiRotxvIqx","","","45","1","1");
INSERT INTO bituse VALUES("6","YWzVLVqexHyrUqbcGSyN","","","0","1","1");
INSERT INTO bituse VALUES("7","rNhDxKKKMxmyycrFwGdM","","","65","1","1");
INSERT INTO bituse VALUES("8","ZEZerARHkebkKPJOlBiD","","","56","1","1");
INSERT INTO bituse VALUES("9","UBjGnHHQNBlEkjYFuvGj","","","53","1","1");
INSERT INTO bituse VALUES("10","xOFmUYaQreBHliIobDOM","","","60","1","1");
INSERT INTO bituse VALUES("11","MMkfxCeYxVVQYQfFAZpp","","","54","1","1");
INSERT INTO bituse VALUES("12","KFaKlshCzMKYTwxLCSvb","","","0","1","1");
INSERT INTO bituse VALUES("13","NvkPRIXBfXpHegRGmoQO","","","50","1","1");
INSERT INTO bituse VALUES("14","NiUMajzEPXewWYymsuNn","","","55","1","1");
INSERT INTO bituse VALUES("15","OwCmezKNnoybyhKTxKCN","","","56","1","1");
INSERT INTO bituse VALUES("16","XymrVnlMLTlcqjrPuTAN","","","58","1","1");
INSERT INTO bituse VALUES("17","KsweJfxlgfUPQJgVnAkW","","","2502268","1","1");
INSERT INTO bituse VALUES("18","bxbPvBcpXvXzufcXKSzm","","","73","1","1");
INSERT INTO bituse VALUES("19","NHoSboDycMCBAKmEFjVk","","","51","1","1");
INSERT INTO bituse VALUES("20","LLJEYJBciMcEwgaJBVEZ","","","235","12","1");
INSERT INTO bituse VALUES("21","JfNbaYBhaMAhvlVJokpk","","","845","12","1");
INSERT INTO bituse VALUES("22","zTFAJwBCsjouUwdPLDJf","","","1045","12","1");
INSERT INTO bituse VALUES("23","gjxwZjYdTkmODDcDRqVk","","","460","12","1");
INSERT INTO bituse VALUES("24","SqYtTHPlHqEXMnYRoAEv","","","1440","12","1");
INSERT INTO bituse VALUES("25","iBCRKSZeLbqdXSDpDpoq","","","1630","12","1");
INSERT INTO bituse VALUES("26","lOfGWMrXnTChHFQmkPSd","","","1805","12","1");
INSERT INTO bituse VALUES("27","EzlYMGjFMvSWLDyhuYCc","","","2180","12","1");
INSERT INTO bituse VALUES("28","lmNtlSkGjObPYCmTIOfL","","","1390","12","1");
INSERT INTO bituse VALUES("29","zWAIkjrinHrPylsOLyKU","","","1320","12","1");
INSERT INTO bituse VALUES("30","etRLQigbsbJinjJozuIC","","","1390","12","1");
INSERT INTO bituse VALUES("31","OJUjEtfzJhYCvqHnsEUo","","","550","12","1");
INSERT INTO bituse VALUES("32","fGfdVzkvEOWtftdRHsZE","","","59","1","1");
INSERT INTO bituse VALUES("33","ihjDavaOiMppxTDeTprY","","","41","1","1");
INSERT INTO bituse VALUES("34","UsvnjOtQyiKGXvCEzaFC","","","48","1","1");
INSERT INTO bituse VALUES("35","jeaskUrKrpUKKKYnanVT","","","56","1","1");
INSERT INTO bituse VALUES("36","oghIwYpHRsBcqOfQJnZL","","","67","1","1");
INSERT INTO bituse VALUES("37","sETFhlohzupvnhiKNDRn","","","53","1","1");
INSERT INTO bituse VALUES("38","ldYwbJzugUkVLrmGqReg","","","1570","12","1");
INSERT INTO bituse VALUES("39","BtegyJVAaxWyTgmgvWwl","","","69","1","1");
INSERT INTO bituse VALUES("40","sEMzRAYrYVEXkgoRkNml","","","405","12","1");
INSERT INTO bituse VALUES("41","ZOxLdMxdIcyQlaMzYEMD","","","30","1","1");
INSERT INTO bituse VALUES("42","zRGdietBeevwCXDQZHnn","","","925","12","1");
INSERT INTO bituse VALUES("43","JZMUsEktgmghiACSvUNq","","","2580","12","1");
INSERT INTO bituse VALUES("44","fyTWTTLfoqzJbEQVsfhp","","","1970","12","1");
INSERT INTO bituse VALUES("45","rSaYXYOJvxSzJYTWMBle","","","2460","12","1");
INSERT INTO bituse VALUES("46","AtviTTORsExANYjTenqm","","","1105","12","1");
INSERT INTO bituse VALUES("47","kqMrimPPrYXyevRNTpQa","","","1635","12","1");
INSERT INTO bituse VALUES("48","ieIHUVqfofBSRsWjiuRA","","","740","12","1");
INSERT INTO bituse VALUES("49","gOpOhMmjbXQrVYeLhRFI","","","845","4","1");
INSERT INTO bituse VALUES("50","UozTAgbAXXEwIwfIurXe","","","760","4","1");
INSERT INTO bituse VALUES("51","AlqKxJdQaHtkkcoLppqd","","","805","4","1");
INSERT INTO bituse VALUES("52","eUwzeFJoRTChYEzrwPmH","","","1400","4","1");
INSERT INTO bituse VALUES("53","ZoLpUFsXyQyqLWGtrlcN","","","1100","4","1");
INSERT INTO bituse VALUES("54","WMvdrlamRKbTDitkhhuV","","","680","4","1");
INSERT INTO bituse VALUES("55","PrSyzhnpiNqfFGMMlftx","","","830","4","1");
INSERT INTO bituse VALUES("56","AGrYqJnGaHXmxsKQicYN","","","830","12","1");
INSERT INTO bituse VALUES("57","LZObULGyHAtWbHTdlSwh","","","650","4","1");
INSERT INTO bituse VALUES("58","ogAFAHslvFOGabQgnUnH","","","960","4","1");
INSERT INTO bituse VALUES("59","NQaEhZafMWzjICrfsMZB","","","1835","12","1");
INSERT INTO bituse VALUES("60","jVdJxMGGlmturGbUmjfm","","","2205","12","1");
INSERT INTO bituse VALUES("61","YPsFEOAbvOTGmQSRZfuv","","","1400","4","1");
INSERT INTO bituse VALUES("62","KcPjIpQjsFonPxAyIyqf","","","1750","4","1");
INSERT INTO bituse VALUES("63","tWVMvrBjsuTJyoHXfzxr","","","2595","12","1");
INSERT INTO bituse VALUES("64","XosoFYeMJLUvoWfVvNcG","","","390","12","1");
INSERT INTO bituse VALUES("65","HHrSkNmMlXuxkNuuiqTw","","","570","4","1");
INSERT INTO bituse VALUES("66","WntHsflqUNtdqunYmVeR","","","419","4","1");
INSERT INTO bituse VALUES("67","LAGjucyMgvIyNfFIAteQ","","","1300","12","1");
INSERT INTO bituse VALUES("68","WGjgLcLzgcPZfpVzxRsa","","","880","4","1");
INSERT INTO bituse VALUES("69","paobQmmNnGudtTTPwtlC","","","390","12","1");
INSERT INTO bituse VALUES("70","EzklpFtgYYhzwKPathMV","","","1200","4","1");
INSERT INTO bituse VALUES("71","gIIkEHnmuRDdEjdTYfrm","","","0","4","1");
INSERT INTO bituse VALUES("72","UHjaHZcXOQwLZWzbsGXa","","","1090","4","1");
INSERT INTO bituse VALUES("73","yuQyWiygSPNqprqPLBmI","","","1630","4","1");
INSERT INTO bituse VALUES("74","yobrYkfryqrtWtfKmNYb","","","1160","12","1");
INSERT INTO bituse VALUES("75","mIiIaYQjPgiWUTdNWKnn","","","0","12","1");
INSERT INTO bituse VALUES("76","WOqgNyryTsjJOhezrVIw","","","410","12","1");
INSERT INTO bituse VALUES("77","UFFxCypvYAyCRCeoGMjy","","","1540","4","1");
INSERT INTO bituse VALUES("78","HqvVVFMxjTFRAmKBoMWb","","","305","4","1");
INSERT INTO bituse VALUES("79","BLkmbxevhXbtpDaMFVxG","","","1140","12","1");
INSERT INTO bituse VALUES("80","JLAChJbDfSmKVIzbhYYb","","","670","4","1");
INSERT INTO bituse VALUES("81","RZRAPmUtHlQSpOTlEPss","","","2020","12","1");
INSERT INTO bituse VALUES("82","DdAGcJJOiFieBlMjryYa","","","515","4","1");
INSERT INTO bituse VALUES("83","nixidcbpTVytXztoMJoV","","","910","4","1");
INSERT INTO bituse VALUES("84","uoxhaXEvKvfBlRzyzYmS","","","755","4","1");
INSERT INTO bituse VALUES("85","UrvSIypOJkLUdAGOpggA","","","0","4","1");
INSERT INTO bituse VALUES("86","SWBfJyCSiMzIzUuAumtM","","","290","12","1");
INSERT INTO bituse VALUES("87","HveCAKwEUgbYnYvCnSLg","","","610","12","1");
INSERT INTO bituse VALUES("88","RvjXBihTjpNgIxEIeONw","","","1100","4","1");
INSERT INTO bituse VALUES("89","eTTfxAOrBKOnYStVZJbv","","","1580","12","1");
INSERT INTO bituse VALUES("90","hXWzNyxBOUojhJrIdBAF","","","1050","4","1");
INSERT INTO bituse VALUES("91","BykHRgTPYIIBdFuNcUBO","","","910","4","1");
INSERT INTO bituse VALUES("92","sexbCAFzXAyrkzTmlZNL","","","1200","4","1");
INSERT INTO bituse VALUES("93","UYcZtdXUptgXbtvNQBFh","","","1150","4","1");
INSERT INTO bituse VALUES("94","UUMndzaJmwghsWBXGoMi","","","1460","12","1");
INSERT INTO bituse VALUES("95","IfwENafDROQMqlkEJZpF","","","2450","12","1");

CREATE TABLE `bordata` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `jid` varchar(150) NOT NULL,
  `holenth` varchar(25) NOT NULL,
  `driller` varchar(50) NOT NULL,
  `waterrng` varchar(150) NOT NULL,
  `qry` varchar(150) NOT NULL,
  `cmpint` text NOT NULL,
  `custreponse` text NOT NULL,
  `sts` int(11) NOT NULL,
  `advnce` varchar(150) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=98 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO bordata VALUES("1","yIhZwhwCfYmfNHBVRZyf","430","Manju ","90.430","1.inch","No","Good","1","");
INSERT INTO bordata VALUES("2","viPlrLGqhBaCFpkYCaDc","100","Manju ","240.250","Full","115 loose mannu ","Very Good","1","");
INSERT INTO bordata VALUES("3","jzHtIyVSBEBgCjoDPQXR","160","Manju ","0","No","Colaps ","Good","1","");
INSERT INTO bordata VALUES("4","BwKFccwwoTtKUFnNpckx","60","Manju ","280.390","Full","Water 💧 not clear. ","Very Good","1","");
INSERT INTO bordata VALUES("5","eFLFeIZIETXiRotxvIqx","100","Manju ","250.600","Full ","No","Bad","1","");
INSERT INTO bordata VALUES("6","YWzVLVqexHyrUqbcGSyN","0","Nil","0","Nil","Nil","Very Good","1","");
INSERT INTO bordata VALUES("7","rNhDxKKKMxmyycrFwGdM","50","Manju ","280.490","1 inch ","No","Good","1","");
INSERT INTO bordata VALUES("8","ZEZerARHkebkKPJOlBiD","280","Manju ","0","Dry ","No","Very Good","1","");
INSERT INTO bordata VALUES("9","UBjGnHHQNBlEkjYFuvGj","60","Manju ","180","Full ","Bolders & water not cleared ","Good","1","");
INSERT INTO bordata VALUES("10","xOFmUYaQreBHliIobDOM","180","Manju ","420","Full ","No","Bad","1","");
INSERT INTO bordata VALUES("11","MMkfxCeYxVVQYQfFAZpp","60","Manju ","720","1.5","Gap big. 720feet.","Good","1","");
INSERT INTO bordata VALUES("12","KFaKlshCzMKYTwxLCSvb","80","Manju ","700","Full ","Rebore ","Good","1","");
INSERT INTO bordata VALUES("13","NvkPRIXBfXpHegRGmoQO","250","Manju ","435","1.inch","No","Good","1","");
INSERT INTO bordata VALUES("14","NiUMajzEPXewWYymsuNn","200","Manju ","320.450","Full ","No","Very Good","1","");
INSERT INTO bordata VALUES("15","OwCmezKNnoybyhKTxKCN","80","Manju ","260.360","Full ","No","Bad","1","");
INSERT INTO bordata VALUES("16","XymrVnlMLTlcqjrPuTAN","200","Manju ","0","Dry","No","Good","1","");
INSERT INTO bordata VALUES("17","KsweJfxlgfUPQJgVnAkW","250","Manju ","220.300","Full ","No","Very Good","1","");
INSERT INTO bordata VALUES("18","bxbPvBcpXvXzufcXKSzm","300","Manju ","270.280","Full ","270 bolders ","Good","1","");
INSERT INTO bordata VALUES("19","NHoSboDycMCBAKmEFjVk","300","Manju ","70.590","Full ","No","Good","1","");
INSERT INTO bordata VALUES("20","LLJEYJBciMcEwgaJBVEZ","100","Ajith","150","3inch +","No","Very Good","1","");
INSERT INTO bordata VALUES("21","JfNbaYBhaMAhvlVJokpk","100","Ajith","585.630","4inch +","No","Very Good","1","");
INSERT INTO bordata VALUES("22","zTFAJwBCsjouUwdPLDJf","100","Ajith","150","4inch ","No","Very Good","1","");
INSERT INTO bordata VALUES("23","gjxwZjYdTkmODDcDRqVk","30","Ajith","200","0.5 inch","No","Very Good","1","");
INSERT INTO bordata VALUES("24","SqYtTHPlHqEXMnYRoAEv","250","Ajith","885","1 inch","No","Very Good","1","");
INSERT INTO bordata VALUES("25","iBCRKSZeLbqdXSDpDpoq","50","Ajith","80","3inch+","No","Very Good","1","");
INSERT INTO bordata VALUES("26","lOfGWMrXnTChHFQmkPSd","50","Ajith","185","1inch+","No","Very Good","1","");
INSERT INTO bordata VALUES("27","EzlYMGjFMvSWLDyhuYCc","240","Ajith","275","5inch+","No","Very Good","1","");
INSERT INTO bordata VALUES("28","lmNtlSkGjObPYCmTIOfL","50","Ajith","290","4inch+","No","Very Good","1","");
INSERT INTO bordata VALUES("29","zWAIkjrinHrPylsOLyKU","50","Ajith","290","4inch+","No","Very Good","1","");
INSERT INTO bordata VALUES("30","etRLQigbsbJinjJozuIC","50","Ajith","105","3inch+","105feet bolder+watter.","Very Good","1","");
INSERT INTO bordata VALUES("31","OJUjEtfzJhYCvqHnsEUo","100","Rajendren","60","1inch+","No","Very Good","1","");
INSERT INTO bordata VALUES("32","hrzywLrvWIRTdyoPyxRs","100","Manju ","480","Full","No","Good","1","");
INSERT INTO bordata VALUES("33","fGfdVzkvEOWtftdRHsZE","100","Manju ","480","Full ","No","Good","1","");
INSERT INTO bordata VALUES("34","ihjDavaOiMppxTDeTprY","500","Manju ","90","1.5","No","Bad","1","");
INSERT INTO bordata VALUES("35","UsvnjOtQyiKGXvCEzaFC","400","Manju ","95","Avarege","Colaps ","Good","1","");
INSERT INTO bordata VALUES("36","jeaskUrKrpUKKKYnanVT","300","Vasu","90","1.5","No","Good","1","");
INSERT INTO bordata VALUES("37","oghIwYpHRsBcqOfQJnZL","100","Manju ","0","0","Gaps ","Very Good","1","");
INSERT INTO bordata VALUES("38","sETFhlohzupvnhiKNDRn","100","Vasu","265","Low","Loose mannu colaps. ","Very Good","1","");
INSERT INTO bordata VALUES("39","ldYwbJzugUkVLrmGqReg","100","Rajendren","540","0.5 - inch","No","Very Good","1","");
INSERT INTO bordata VALUES("40","BtegyJVAaxWyTgmgvWwl","100","Manju ","80.200","Full ","No","Very Good","1","");
INSERT INTO bordata VALUES("41","sEMzRAYrYVEXkgoRkNml","130","Ajith","315","3inch+","No","Very Good","1","");
INSERT INTO bordata VALUES("42","ZOxLdMxdIcyQlaMzYEMD","100","Vasu","0","No loose mannu ","Colaps ","Very Good","1","");
INSERT INTO bordata VALUES("43","zRGdietBeevwCXDQZHnn","50","Rajendren","480","2inch","No","Very Good","1","");
INSERT INTO bordata VALUES("44","JZMUsEktgmghiACSvUNq","200","Ajith","430","3inch+","No","Very Good","1","");
INSERT INTO bordata VALUES("45","fyTWTTLfoqzJbEQVsfhp","150","Rajendren","60","1.5 inch+","No","Very Good","1","");
INSERT INTO bordata VALUES("46","rSaYXYOJvxSzJYTWMBle","50","Ajith","435","1.5+","No","Very Good","1","");
INSERT INTO bordata VALUES("47","AtviTTORsExANYjTenqm","50","Rajendren","190","2inch","No","Very Good","1","");
INSERT INTO bordata VALUES("48","kqMrimPPrYXyevRNTpQa","300","Ajith","375","1.5 inch","No","Very Good","1","");
INSERT INTO bordata VALUES("49","ieIHUVqfofBSRsWjiuRA","50","Ajith","810","3inch","No","Very Good","1","");
INSERT INTO bordata VALUES("50","gOpOhMmjbXQrVYeLhRFI","150","Mani","750","1.5","No","Very Good","1","");
INSERT INTO bordata VALUES("51","UozTAgbAXXEwIwfIurXe","20","Mani","0","No","No","Very Good","1","");
INSERT INTO bordata VALUES("52","hUpEulgXgbpOXIeVFIoW","150","Mani","0","No","No","Very Good","1","");
INSERT INTO bordata VALUES("53","AlqKxJdQaHtkkcoLppqd","150","Mani","0","No","No","Very Good","1","");
INSERT INTO bordata VALUES("54","eUwzeFJoRTChYEzrwPmH","150","Mani","0","No","No","Very Good","1","");
INSERT INTO bordata VALUES("55","ZoLpUFsXyQyqLWGtrlcN","200","Mani","430","1.5","No","Very Good","1","");
INSERT INTO bordata VALUES("56","WMvdrlamRKbTDitkhhuV","150","Mani","150","3.0","No","Very Good","1","");
INSERT INTO bordata VALUES("57","PrSyzhnpiNqfFGMMlftx","150","Mani","650","2.5","No","Very Good","1","");
INSERT INTO bordata VALUES("58","AGrYqJnGaHXmxsKQicYN","150","Rajendren","540","1.7","No","Very Good","1","");
INSERT INTO bordata VALUES("59","LZObULGyHAtWbHTdlSwh","150","Mani","1.5","350","No","Very Good","1","");
INSERT INTO bordata VALUES("60","ogAFAHslvFOGabQgnUnH","1000","Mani","350","0.5","No","Very Good","1","");
INSERT INTO bordata VALUES("61","NQaEhZafMWzjICrfsMZB","140","Ajith","110","1inch","No","Very Good","1","");
INSERT INTO bordata VALUES("62","jVdJxMGGlmturGbUmjfm","140","Rajebdren","110","2inch","No","Very Good","1","");
INSERT INTO bordata VALUES("63","YPsFEOAbvOTGmQSRZfuv","1000","Mani","0","No","No","Very Good","1","");
INSERT INTO bordata VALUES("64","KcPjIpQjsFonPxAyIyqf","200","Mani","0","No","No","Very Good","1","");
INSERT INTO bordata VALUES("65","tWVMvrBjsuTJyoHXfzxr","50","Ajith","350","2.5 inch+","No","Very Good","1","");
INSERT INTO bordata VALUES("66","XosoFYeMJLUvoWfVvNcG","50","Rajendren","145.400","3inch +","No","Very Good","1","");
INSERT INTO bordata VALUES("67","HHrSkNmMlXuxkNuuiqTw","150","Saravanan","540","2.5","No","Very Good","1","");
INSERT INTO bordata VALUES("68","WntHsflqUNtdqunYmVeR","100","Mani","300","1.5","No","Very Good","1","");
INSERT INTO bordata VALUES("69","LAGjucyMgvIyNfFIAteQ","100","Ajith","350","1.2","No","Very Good","1","");
INSERT INTO bordata VALUES("70","WGjgLcLzgcPZfpVzxRsa","100","Saravanan","300","2.0","No","Very Good","1","");
INSERT INTO bordata VALUES("71","paobQmmNnGudtTTPwtlC","120","Rajendren","430","3inch +","2 borewell connection ","Very Good","1","");
INSERT INTO bordata VALUES("72","EzklpFtgYYhzwKPathMV","150","Mani","150","1","No","Very Good","1","");
INSERT INTO bordata VALUES("73","gIIkEHnmuRDdEjdTYfrm","100","Saravanan","2.5","Fule","No","Very Good","1","");
INSERT INTO bordata VALUES("74","UHjaHZcXOQwLZWzbsGXa","100","Saravanan","85","2.5","No","Very Good","1","");
INSERT INTO bordata VALUES("75","yuQyWiygSPNqprqPLBmI","250","Mani","80","2.5","Mo","Very Good","1","");
INSERT INTO bordata VALUES("76","yobrYkfryqrtWtfKmNYb","450","Ajith","420","1inch","Pvc pipe 20feet demege","Very Good","1","");
INSERT INTO bordata VALUES("77","mIiIaYQjPgiWUTdNWKnn","","Ajith","50","1.5 inch","Clearing","Very Good","1","");
INSERT INTO bordata VALUES("78","WOqgNyryTsjJOhezrVIw","120","Rajendren","155","1.5 inch","No","Very Good","1","");
INSERT INTO bordata VALUES("79","UFFxCypvYAyCRCeoGMjy","100","Saravanan","300","0.5","No","Very Good","1","");
INSERT INTO bordata VALUES("80","HqvVVFMxjTFRAmKBoMWb","100","Mani","200","3.0","No","Very Good","1","");
INSERT INTO bordata VALUES("81","BLkmbxevhXbtpDaMFVxG","120","Ajirh","715","3inch+","No","Very Good","1","");
INSERT INTO bordata VALUES("82","JLAChJbDfSmKVIzbhYYb","250","Saravanan","400","3.0","No","Very Good","1","");
INSERT INTO bordata VALUES("83","RZRAPmUtHlQSpOTlEPss","100","Rajendren","0","0","0","Very Good","1","");
INSERT INTO bordata VALUES("84","DdAGcJJOiFieBlMjryYa","100","Saravanan","90","2.5","No","Very Good","1","");
INSERT INTO bordata VALUES("85","nixidcbpTVytXztoMJoV","100","Saravanan","0.5","490","No","Very Good","1","");
INSERT INTO bordata VALUES("86","uoxhaXEvKvfBlRzyzYmS","150","Saravanan","800","2.0","No","Very Good","1","");
INSERT INTO bordata VALUES("87","UrvSIypOJkLUdAGOpggA","0","No","0","No","No","Very Good","1","");
INSERT INTO bordata VALUES("88","SWBfJyCSiMzIzUuAumtM","50","Rajendren","320","3inch +","No","Very Good","1","");
INSERT INTO bordata VALUES("89","HveCAKwEUgbYnYvCnSLg","50","Rajendren","220","3inch+","No","Very Good","1","");
INSERT INTO bordata VALUES("90","RvjXBihTjpNgIxEIeONw","100","Saravanan","600","2.5","No","Very Good","1","");
INSERT INTO bordata VALUES("91","eTTfxAOrBKOnYStVZJbv","130","Rajendren","360","2inch","No","Very Good","1","");
INSERT INTO bordata VALUES("92","hXWzNyxBOUojhJrIdBAF","150","Mani","300","1.5","No","Very Good","1","");
INSERT INTO bordata VALUES("93","BykHRgTPYIIBdFuNcUBO","200","Saravanan","0","No","No","Very Good","1","");
INSERT INTO bordata VALUES("94","sexbCAFzXAyrkzTmlZNL","150","Mani","175","3.0","No","Very Good","1","");
INSERT INTO bordata VALUES("95","UYcZtdXUptgXbtvNQBFh","150","Saravanan","200","2.5","No","Very Good","1","");
INSERT INTO bordata VALUES("96","UUMndzaJmwghsWBXGoMi","200","Rajenden","885","3inch+","No","Very Good","1","");
INSERT INTO bordata VALUES("97","IfwENafDROQMqlkEJZpF","50","Rajendren","0","0","0","Very Good","1","");

CREATE TABLE `customer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `jid` varchar(150) NOT NULL,
  `name` varchar(150) NOT NULL,
  `plce` varchar(250) NOT NULL,
  `cont` varchar(50) NOT NULL,
  `adress` varchar(1000) DEFAULT NULL,
  `pins` int(11) DEFAULT NULL,
  `sts` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=98 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO customer VALUES("1","yIhZwhwCfYmfNHBVRZyf","Biju Johon ","Ezhukumvayal ","9747097391","Ezhukumvayal ","685553","1");
INSERT INTO customer VALUES("2","viPlrLGqhBaCFpkYCaDc","Sudhakaran ","Koottar ","9656977043","Silpvilasam","685552","1");
INSERT INTO customer VALUES("3","jzHtIyVSBEBgCjoDPQXR","Sivakumar ","Ambalakkavala","9562804379","Mc bajjikkada","685514","1");
INSERT INTO customer VALUES("4","BwKFccwwoTtKUFnNpckx","Joy ","Mathayikkada","9656245215","Maruthukalam","685552","1");
INSERT INTO customer VALUES("5","eFLFeIZIETXiRotxvIqx","Joshi pk","Kattappana ","9447596852","Marchant association ","685508","1");
INSERT INTO customer VALUES("6","YWzVLVqexHyrUqbcGSyN","Old ","Nil","0","Nil","0","1");
INSERT INTO customer VALUES("7","rNhDxKKKMxmyycrFwGdM","Madhu ","Ezhukumvayal ","9447875961","Polachira ","685514","1");
INSERT INTO customer VALUES("8","ZEZerARHkebkKPJOlBiD","Reannychan","6th mail","9074260453","Poovakkulam","685509","1");
INSERT INTO customer VALUES("9","UBjGnHHQNBlEkjYFuvGj","Subash ","Earattayar ","9544362787","Agent ","685514","1");
INSERT INTO customer VALUES("10","xOFmUYaQreBHliIobDOM","Joshi","Thannimoodu ","7018902886","Madappattu","685553","1");
INSERT INTO customer VALUES("11","MMkfxCeYxVVQYQfFAZpp","Thomas gm","Thulasippara ","9249338629","Theagumpalliyil","685514","1");
INSERT INTO customer VALUES("12","KFaKlshCzMKYTwxLCSvb","Kmr ","Veallimala ","9249338629","Veallimala ","685515","1");
INSERT INTO customer VALUES("13","NvkPRIXBfXpHegRGmoQO","Sakthivel ","Anachal ","9497685390","Arun bavan ","685565","1");
INSERT INTO customer VALUES("14","NiUMajzEPXewWYymsuNn","Biju ","Kizhakkemattukatta","9961853721","Naduvileadathu","685507","1");
INSERT INTO customer VALUES("15","OwCmezKNnoybyhKTxKCN","Aneesh ","Tanalpadi","9961150575","Chealackal.","685514","1");
INSERT INTO customer VALUES("16","XymrVnlMLTlcqjrPuTAN","Geo","Pathnippara ","9947457611","Chakkalayil ","685553","1");
INSERT INTO customer VALUES("17","KsweJfxlgfUPQJgVnAkW","Saly","Earattayar ","9496526551","Thuruthippalliyil","685514","1");
INSERT INTO customer VALUES("18","bxbPvBcpXvXzufcXKSzm","Jorge ","Ezhukumvayal ","9947087856","Veallamkadavil","685553","1");
INSERT INTO customer VALUES("19","NHoSboDycMCBAKmEFjVk","Sunil","Kochuthovala ","9744990830","Valummeal ","6855514","1");
INSERT INTO customer VALUES("20","LLJEYJBciMcEwgaJBVEZ","Siju","Kattapana","9447200279","Kattapana","0","1");
INSERT INTO customer VALUES("21","JfNbaYBhaMAhvlVJokpk","Sharikbabee","Nedumkandam","7736858805","Nedumkandam","685553","1");
INSERT INTO customer VALUES("22","zTFAJwBCsjouUwdPLDJf","Joshy","Mariyapuram","9446069409","Mariyapuram","0","1");
INSERT INTO customer VALUES("23","gjxwZjYdTkmODDcDRqVk","Justin  thomas","Kattapana","8892103693","Kattapana","0","1");
INSERT INTO customer VALUES("24","SqYtTHPlHqEXMnYRoAEv","Antony","Kawnthy","9847212409","Kawnthy","0","1");
INSERT INTO customer VALUES("25","iBCRKSZeLbqdXSDpDpoq","Thomad","Upputhara","9497488595","Upputhara","0","1");
INSERT INTO customer VALUES("26","lOfGWMrXnTChHFQmkPSd","Rajan","Kallar","8281281937","Kallar","0","1");
INSERT INTO customer VALUES("27","EzlYMGjFMvSWLDyhuYCc","Ashok","Thookupalam","9447417341","Thookupalam","0","1");
INSERT INTO customer VALUES("28","lmNtlSkGjObPYCmTIOfL","Abbu","Thanimode","9961462852","Thanimode","0","1");
INSERT INTO customer VALUES("29","zWAIkjrinHrPylsOLyKU","Sinto","Thanimode","7774081396","Thanimode","0","1");
INSERT INTO customer VALUES("30","etRLQigbsbJinjJozuIC","Abbu","Thanimode","9961462852","Thanimode","0","1");
INSERT INTO customer VALUES("31","OJUjEtfzJhYCvqHnsEUo","Devasia joseph","Thangamani","9400795775","Thangamani","0","1");
INSERT INTO customer VALUES("32","hrzywLrvWIRTdyoPyxRs","Sabu","Valiyathovals ","7012570538","Podippara","68553","1");
INSERT INTO customer VALUES("33","fGfdVzkvEOWtftdRHsZE","Sabu ","Valiyathovals ","7012570538","Valiyathovals ","0","1");
INSERT INTO customer VALUES("34","ihjDavaOiMppxTDeTprY","Bala","Rajakkadu ","9840888630","Rajakkadu ","0","1");
INSERT INTO customer VALUES("35","UsvnjOtQyiKGXvCEzaFC","Mohanan.","Valiyathovals ","9947364026","Valiyathovals ","0","1");
INSERT INTO customer VALUES("36","jeaskUrKrpUKKKYnanVT","Nabeen","Neadumkandam ","7902636363","Neadumkandam ","0","1");
INSERT INTO customer VALUES("37","oghIwYpHRsBcqOfQJnZL","Chandys","Vattavada ","9447967530","Vattavada ","685615","1");
INSERT INTO customer VALUES("38","sETFhlohzupvnhiKNDRn","Chandys ","Vattavada","9447967531","Drizzle drops ","685516","1");
INSERT INTO customer VALUES("39","ldYwbJzugUkVLrmGqReg","Abraham","Kochuthovala","9447416893","Kochuthovala","0","1");
INSERT INTO customer VALUES("40","BtegyJVAaxWyTgmgvWwl","Jeasiriyo","Makulam","9961757525","Thugealeal","685565","1");
INSERT INTO customer VALUES("41","sEMzRAYrYVEXkgoRkNml","Ranjith","Vandamedu","9995039662","Vandamedu","0","1");
INSERT INTO customer VALUES("42","ZOxLdMxdIcyQlaMzYEMD","Jiji mathew ","Cheagalam","9400528316","Manoor","685565","1");
INSERT INTO customer VALUES("43","zRGdietBeevwCXDQZHnn","Jeganath","Vandamedu","8148570323","Vandamedu","0","1");
INSERT INTO customer VALUES("44","JZMUsEktgmghiACSvUNq","Pandiyan","Vandamedu","9446448517","Vandamedu","0","1");
INSERT INTO customer VALUES("45","fyTWTTLfoqzJbEQVsfhp","Jins","Pathuvalavu","9061876283","Pathuvalavu","0","1");
INSERT INTO customer VALUES("46","rSaYXYOJvxSzJYTWMBle","Sunoj","Vellayamkudy","8606543112","Vellayamkudy","0","1");
INSERT INTO customer VALUES("47","AtviTTORsExANYjTenqm","Shibin","8 th maile","6282787285","8 th maile","0","1");
INSERT INTO customer VALUES("48","kqMrimPPrYXyevRNTpQa","Biju","Chellar kovil","9207183434","Chellar kovil","0","1");
INSERT INTO customer VALUES("49","ieIHUVqfofBSRsWjiuRA","Jobe","Chakkakanam","8848334303","Chakkakanam","0","1");
INSERT INTO customer VALUES("50","gOpOhMmjbXQrVYeLhRFI","Sobana","Popara","7904828480","Popara","0","1");
INSERT INTO customer VALUES("51","UozTAgbAXXEwIwfIurXe","Siju","Paniyarankudi","9744882845","Paniyarankudi","0","1");
INSERT INTO customer VALUES("52","hUpEulgXgbpOXIeVFIoW","Tiju","Adimali","9562983627","Adimali","0","1");
INSERT INTO customer VALUES("53","AlqKxJdQaHtkkcoLppqd","Tiju","Adimali","9562983627","Adimali","0","1");
INSERT INTO customer VALUES("54","eUwzeFJoRTChYEzrwPmH","Tiju","Rajakumari","9562983627","Rajakumari","0","1");
INSERT INTO customer VALUES("55","ZoLpUFsXyQyqLWGtrlcN","Jemes","Maniyaramkudi","9447980229","Maniyaramkudi","0","1");
INSERT INTO customer VALUES("56","WMvdrlamRKbTDitkhhuV","Sajan","Uppukandam","8547124543","Uppukandam","0","1");
INSERT INTO customer VALUES("57","PrSyzhnpiNqfFGMMlftx","9656866297","Sakkakanam","9656866297","Sakkakanam","0","1");
INSERT INTO customer VALUES("58","AGrYqJnGaHXmxsKQicYN","Jekkap john","Pooversmount","9562009784","Pooversmount","0","1");
INSERT INTO customer VALUES("59","LZObULGyHAtWbHTdlSwh","9778002090","Chamanar","9778002090","Chamanar","0","1");
INSERT INTO customer VALUES("60","ogAFAHslvFOGabQgnUnH","Binoygorge","Nadimkandam","8547533572","Nadimkandam","0","1");
INSERT INTO customer VALUES("61","NQaEhZafMWzjICrfsMZB","Shamon","Kumly 1 th maile","8848903478","Kumly 1 th maile","0","1");
INSERT INTO customer VALUES("62","jVdJxMGGlmturGbUmjfm","Dileep","Kombaiyar","9947981110","Kombaiyar","0","1");
INSERT INTO customer VALUES("63","YPsFEOAbvOTGmQSRZfuv","Domiabragim","Nadumkandam","9447506631","Nadumkandam","0","1");
INSERT INTO customer VALUES("64","KcPjIpQjsFonPxAyIyqf","Tobypoul","Anachal","9447525920","Anachal","0","1");
INSERT INTO customer VALUES("65","tWVMvrBjsuTJyoHXfzxr","Radhakirshnan","Thookupalam","9495274332","Thookupalam","0","1");
INSERT INTO customer VALUES("66","XosoFYeMJLUvoWfVvNcG","Ajesh","Kozhimala","6282921827","Kozhimala","0","1");
INSERT INTO customer VALUES("67","HHrSkNmMlXuxkNuuiqTw","Madhu","Mondiyaruma","944785961","Mondiyaruma","0","1");
INSERT INTO customer VALUES("68","WntHsflqUNtdqunYmVeR","Niyas","Thukkupalam","7012702399","Thukkupalam","0","1");
INSERT INTO customer VALUES("69","LAGjucyMgvIyNfFIAteQ","Manoj","Santhigiram","9495254864","Santhigiram","0","1");
INSERT INTO customer VALUES("70","WGjgLcLzgcPZfpVzxRsa","Surase","8.mail","6238543611","8.mail","0","1");
INSERT INTO customer VALUES("71","paobQmmNnGudtTTPwtlC","Sinto","Sagara jn","9744182856","Sagara jn","0","1");
INSERT INTO customer VALUES("72","EzklpFtgYYhzwKPathMV","Asees.wattarssrvar","Mattukatta","6282151596","Mattukatta","0","1");
INSERT INTO customer VALUES("73","gIIkEHnmuRDdEjdTYfrm","Biju","Kattapana","8593055158","Kattapana","0","1");
INSERT INTO customer VALUES("74","UHjaHZcXOQwLZWzbsGXa","Manikandan","Mali","9677992007","Mali","0","1");
INSERT INTO customer VALUES("75","yuQyWiygSPNqprqPLBmI","Manikandan","Mali","9677992007","Mali","0","1");
INSERT INTO customer VALUES("76","yobrYkfryqrtWtfKmNYb","Ramesh","Rajakadu","9745350560","Rajakadu","0","1");
INSERT INTO customer VALUES("77","mIiIaYQjPgiWUTdNWKnn","Rejenamary","Poopara","9539521623","Poopara","0","1");
INSERT INTO customer VALUES("78","WOqgNyryTsjJOhezrVIw","Manis","Ambalakavala","9562736670","Ambalakavala","0","1");
INSERT INTO customer VALUES("79","UFFxCypvYAyCRCeoGMjy","Manikandan","Mali","9677992007","Mali","0","1");
INSERT INTO customer VALUES("80","HqvVVFMxjTFRAmKBoMWb","Shaji","Upputhorai","9497022486","Upputhorai","0","1");
INSERT INTO customer VALUES("81","BLkmbxevhXbtpDaMFVxG","Shaji","Idinjamalai","9400875022","Idinjamalai","0","1");
INSERT INTO customer VALUES("82","JLAChJbDfSmKVIzbhYYb","Jobi","Valavara","9400678991","Valavara","0","1");
INSERT INTO customer VALUES("83","RZRAPmUtHlQSpOTlEPss","Suresh","Ndm","9961149379","Ndm","0","1");
INSERT INTO customer VALUES("84","DdAGcJJOiFieBlMjryYa","Mobin","Kozhimala","9961811661","Kozhimala","0","1");
INSERT INTO customer VALUES("85","nixidcbpTVytXztoMJoV","Biju","Kattapana","8593055158","Kattapana","0","1");
INSERT INTO customer VALUES("86","uoxhaXEvKvfBlRzyzYmS","Madhu","Thukkupalam","9447875961","Thukkupalam","0","1");
INSERT INTO customer VALUES("87","UrvSIypOJkLUdAGOpggA","Biju","Kattapana","9495950168","Kattapana","0","1");
INSERT INTO customer VALUES("88","SWBfJyCSiMzIzUuAumtM","Binish","Thookupalam","0","Thookupalam","0","1");
INSERT INTO customer VALUES("89","HveCAKwEUgbYnYvCnSLg","Shaji","Ndm","9446225116","Ndm","0","1");
INSERT INTO customer VALUES("90","RvjXBihTjpNgIxEIeONw","Sathes","Valavodu","906119359","Valavodu","0","1");
INSERT INTO customer VALUES("91","eTTfxAOrBKOnYStVZJbv","Rajen","Rajakandam","9446336974","Rajakandam","0","1");
INSERT INTO customer VALUES("92","hXWzNyxBOUojhJrIdBAF","Ullas","Anakara","9447383755","Anakara","0","1");
INSERT INTO customer VALUES("93","BykHRgTPYIIBdFuNcUBO","Antoni","Kamachi","9744422175","Kamachi","0","1");
INSERT INTO customer VALUES("94","sexbCAFzXAyrkzTmlZNL","Gopalakrisnan","Nadumkandam","9446521921","Nadumkandam","0","1");
INSERT INTO customer VALUES("95","UYcZtdXUptgXbtvNQBFh","Chinnasodalai","Kallar","8606669602","Kallar","0","1");
INSERT INTO customer VALUES("96","UUMndzaJmwghsWBXGoMi","Manu","Thinkalkadu","9526861187","Thinkalkadu","0","1");
INSERT INTO customer VALUES("97","IfwENafDROQMqlkEJZpF","Vijoyan","Karimala","974458044","Karimala","0","1");

CREATE TABLE `custpayments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `jid` varchar(150) NOT NULL,
  `ttlamount` varchar(150) NOT NULL,
  `balance` varchar(150) NOT NULL,
  `sts` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=90 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO custpayments VALUES("1","yIhZwhwCfYmfNHBVRZyf","0","0","1");
INSERT INTO custpayments VALUES("2","viPlrLGqhBaCFpkYCaDc","0","0","1");
INSERT INTO custpayments VALUES("3","jzHtIyVSBEBgCjoDPQXR","0","0","1");
INSERT INTO custpayments VALUES("4","eFLFeIZIETXiRotxvIqx","0","0","1");
INSERT INTO custpayments VALUES("5","BwKFccwwoTtKUFnNpckx","0","0","1");
INSERT INTO custpayments VALUES("6","YWzVLVqexHyrUqbcGSyN","0","0","1");
INSERT INTO custpayments VALUES("7","rNhDxKKKMxmyycrFwGdM","0","0","1");
INSERT INTO custpayments VALUES("8","ZEZerARHkebkKPJOlBiD","0","0","1");
INSERT INTO custpayments VALUES("9","UBjGnHHQNBlEkjYFuvGj","0","0","1");
INSERT INTO custpayments VALUES("10","xOFmUYaQreBHliIobDOM","0","0","1");
INSERT INTO custpayments VALUES("11","MMkfxCeYxVVQYQfFAZpp","0","0","1");
INSERT INTO custpayments VALUES("12","KFaKlshCzMKYTwxLCSvb","0","0","1");
INSERT INTO custpayments VALUES("13","NvkPRIXBfXpHegRGmoQO","0","0","1");
INSERT INTO custpayments VALUES("14","NiUMajzEPXewWYymsuNn","0","0","1");
INSERT INTO custpayments VALUES("15","OwCmezKNnoybyhKTxKCN","0","0","1");
INSERT INTO custpayments VALUES("16","XymrVnlMLTlcqjrPuTAN","0","0","1");
INSERT INTO custpayments VALUES("17","KsweJfxlgfUPQJgVnAkW","0","0","1");
INSERT INTO custpayments VALUES("18","bxbPvBcpXvXzufcXKSzm","0","0","1");
INSERT INTO custpayments VALUES("19","NHoSboDycMCBAKmEFjVk","0","0","1");
INSERT INTO custpayments VALUES("20","LLJEYJBciMcEwgaJBVEZ","0","0","1");
INSERT INTO custpayments VALUES("21","JfNbaYBhaMAhvlVJokpk","2000","2000","1");
INSERT INTO custpayments VALUES("22","zTFAJwBCsjouUwdPLDJf","0","0","1");
INSERT INTO custpayments VALUES("23","gjxwZjYdTkmODDcDRqVk","0","0","1");
INSERT INTO custpayments VALUES("24","SqYtTHPlHqEXMnYRoAEv","0","0","1");
INSERT INTO custpayments VALUES("25","iBCRKSZeLbqdXSDpDpoq","0","0","1");
INSERT INTO custpayments VALUES("26","lOfGWMrXnTChHFQmkPSd","0","0","1");
INSERT INTO custpayments VALUES("27","EzlYMGjFMvSWLDyhuYCc","0","0","1");
INSERT INTO custpayments VALUES("28","zWAIkjrinHrPylsOLyKU","0","0","1");
INSERT INTO custpayments VALUES("29","OJUjEtfzJhYCvqHnsEUo","0","0","1");
INSERT INTO custpayments VALUES("30","etRLQigbsbJinjJozuIC","0","0","1");
INSERT INTO custpayments VALUES("31","fGfdVzkvEOWtftdRHsZE","0","0","1");
INSERT INTO custpayments VALUES("32","ihjDavaOiMppxTDeTprY","0","0","1");
INSERT INTO custpayments VALUES("33","oghIwYpHRsBcqOfQJnZL","0","0","1");
INSERT INTO custpayments VALUES("34","sETFhlohzupvnhiKNDRn","0","0","1");
INSERT INTO custpayments VALUES("35","ldYwbJzugUkVLrmGqReg","0","0","1");
INSERT INTO custpayments VALUES("36","BtegyJVAaxWyTgmgvWwl","0","0","1");
INSERT INTO custpayments VALUES("37","ZOxLdMxdIcyQlaMzYEMD","0","0","1");
INSERT INTO custpayments VALUES("38","sEMzRAYrYVEXkgoRkNml","0","0","1");
INSERT INTO custpayments VALUES("39","zRGdietBeevwCXDQZHnn","0","0","1");
INSERT INTO custpayments VALUES("40","JZMUsEktgmghiACSvUNq","0","0","1");
INSERT INTO custpayments VALUES("41","fyTWTTLfoqzJbEQVsfhp","0","0","1");
INSERT INTO custpayments VALUES("42","rSaYXYOJvxSzJYTWMBle","0","0","1");
INSERT INTO custpayments VALUES("43","jeaskUrKrpUKKKYnanVT","0","0","1");
INSERT INTO custpayments VALUES("44","UsvnjOtQyiKGXvCEzaFC","0","0","1");
INSERT INTO custpayments VALUES("45","AtviTTORsExANYjTenqm","0","0","1");
INSERT INTO custpayments VALUES("46","kqMrimPPrYXyevRNTpQa","0","0","1");
INSERT INTO custpayments VALUES("47","ieIHUVqfofBSRsWjiuRA","0","0","1");
INSERT INTO custpayments VALUES("48","gOpOhMmjbXQrVYeLhRFI","111850","111850","1");
INSERT INTO custpayments VALUES("49","UozTAgbAXXEwIwfIurXe","3000","3000","1");
INSERT INTO custpayments VALUES("50","AlqKxJdQaHtkkcoLppqd","3000","3000","1");
INSERT INTO custpayments VALUES("51","ZoLpUFsXyQyqLWGtrlcN","2000","2000","1");
INSERT INTO custpayments VALUES("52","WMvdrlamRKbTDitkhhuV","2000","2000","1");
INSERT INTO custpayments VALUES("53","PrSyzhnpiNqfFGMMlftx","5000","5000","1");
INSERT INTO custpayments VALUES("54","eUwzeFJoRTChYEzrwPmH","2000","2000","1");
INSERT INTO custpayments VALUES("55","LZObULGyHAtWbHTdlSwh","2000","2000","1");
INSERT INTO custpayments VALUES("56","AGrYqJnGaHXmxsKQicYN","0","0","1");
INSERT INTO custpayments VALUES("57","NQaEhZafMWzjICrfsMZB","0","0","1");
INSERT INTO custpayments VALUES("58","ogAFAHslvFOGabQgnUnH","6000","6000","1");
INSERT INTO custpayments VALUES("59","jVdJxMGGlmturGbUmjfm","0","0","1");
INSERT INTO custpayments VALUES("60","YPsFEOAbvOTGmQSRZfuv","5000","5000","1");
INSERT INTO custpayments VALUES("61","KcPjIpQjsFonPxAyIyqf","2000","2000","1");
INSERT INTO custpayments VALUES("62","tWVMvrBjsuTJyoHXfzxr","0","0","1");
INSERT INTO custpayments VALUES("63","HHrSkNmMlXuxkNuuiqTw","2000","2000","1");
INSERT INTO custpayments VALUES("64","XosoFYeMJLUvoWfVvNcG","0","0","1");
INSERT INTO custpayments VALUES("65","WntHsflqUNtdqunYmVeR","2000","2000","1");
INSERT INTO custpayments VALUES("66","WGjgLcLzgcPZfpVzxRsa","2000","2000","1");
INSERT INTO custpayments VALUES("67","LAGjucyMgvIyNfFIAteQ","0","0","1");
INSERT INTO custpayments VALUES("68","paobQmmNnGudtTTPwtlC","0","0","1");
INSERT INTO custpayments VALUES("69","EzklpFtgYYhzwKPathMV","2000","2000","1");
INSERT INTO custpayments VALUES("70","gIIkEHnmuRDdEjdTYfrm","20600","20600","1");
INSERT INTO custpayments VALUES("71","UHjaHZcXOQwLZWzbsGXa","2000","2000","1");
INSERT INTO custpayments VALUES("72","yuQyWiygSPNqprqPLBmI","4000","4000","1");
INSERT INTO custpayments VALUES("73","yobrYkfryqrtWtfKmNYb","0","0","1");
INSERT INTO custpayments VALUES("74","mIiIaYQjPgiWUTdNWKnn","0","0","1");
INSERT INTO custpayments VALUES("75","HqvVVFMxjTFRAmKBoMWb","2000","2000","1");
INSERT INTO custpayments VALUES("76","UFFxCypvYAyCRCeoGMjy","2000","2000","1");
INSERT INTO custpayments VALUES("77","WOqgNyryTsjJOhezrVIw","0","0","1");
INSERT INTO custpayments VALUES("78","BLkmbxevhXbtpDaMFVxG","0","0","1");
INSERT INTO custpayments VALUES("79","JLAChJbDfSmKVIzbhYYb","2000","2000","1");
INSERT INTO custpayments VALUES("80","RZRAPmUtHlQSpOTlEPss","0","0","1");
INSERT INTO custpayments VALUES("81","DdAGcJJOiFieBlMjryYa","2000","2000","1");
INSERT INTO custpayments VALUES("82","nixidcbpTVytXztoMJoV","2000","2000","1");
INSERT INTO custpayments VALUES("83","uoxhaXEvKvfBlRzyzYmS","2000","2000","1");
INSERT INTO custpayments VALUES("84","SWBfJyCSiMzIzUuAumtM","0","0","1");
INSERT INTO custpayments VALUES("85","HveCAKwEUgbYnYvCnSLg","0","0","1");
INSERT INTO custpayments VALUES("86","UrvSIypOJkLUdAGOpggA","0","0","1");
INSERT INTO custpayments VALUES("87","RvjXBihTjpNgIxEIeONw","2000","2000","1");
INSERT INTO custpayments VALUES("88","eTTfxAOrBKOnYStVZJbv","0","0","1");
INSERT INTO custpayments VALUES("89","hXWzNyxBOUojhJrIdBAF","2000","2000","1");

CREATE TABLE `device` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `model` varchar(250) NOT NULL,
  `uid` varchar(250) NOT NULL,
  `user` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE `disel` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `jid` varchar(50) NOT NULL,
  `forv` varchar(50) NOT NULL,
  `ltr` varchar(50) NOT NULL,
  `pump` varchar(400) NOT NULL,
  `paymode` varchar(50) NOT NULL,
  `billno` varchar(500) NOT NULL,
  `amt` varchar(50) NOT NULL,
  `sts` int(11) NOT NULL,
  `mid` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=382 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO disel VALUES("1","yIhZwhwCfYmfNHBVRZyf","COMPRROSSOR DIESEL","500","Eassar ","Credit","24231","47950","1","1");
INSERT INTO disel VALUES("2","yIhZwhwCfYmfNHBVRZyf","RIG LORRY DIESEL","26.07","Eassar ","Credit","24329","2500","1","1");
INSERT INTO disel VALUES("3","yIhZwhwCfYmfNHBVRZyf","SUPPORT LORRY DIESEL","26.07","Eassar ","Credit","2224","2500","1","1");
INSERT INTO disel VALUES("4","yIhZwhwCfYmfNHBVRZyf","BIKE PETROL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("5","viPlrLGqhBaCFpkYCaDc","COMPRROSSOR DIESEL","500","Bright fuels puliyanmala ","Credit","101655","47930","1","1");
INSERT INTO disel VALUES("6","viPlrLGqhBaCFpkYCaDc","RIG LORRY DIESEL","25","Bright fuels puliyanmala ","Credit","101656","2396","1","1");
INSERT INTO disel VALUES("7","viPlrLGqhBaCFpkYCaDc","SUPPORT LORRY DIESEL","25","Bright fuels puliyanmala ","Credit","101657","2396","1","1");
INSERT INTO disel VALUES("8","viPlrLGqhBaCFpkYCaDc","BIKE PETROL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("9","jzHtIyVSBEBgCjoDPQXR","COMPRROSSOR DIESEL","0"," No","Cash","No","0","1","1");
INSERT INTO disel VALUES("10","jzHtIyVSBEBgCjoDPQXR","RIG LORRY DIESEL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("11","jzHtIyVSBEBgCjoDPQXR","SUPPORT LORRY DIESEL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("12","jzHtIyVSBEBgCjoDPQXR","BIKE PETROL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("13","BwKFccwwoTtKUFnNpckx","COMPRROSSOR DIESEL","300","Eassar kattappana ","Credit","26243","28770","1","1");
INSERT INTO disel VALUES("14","BwKFccwwoTtKUFnNpckx","RIG LORRY DIESEL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("15","BwKFccwwoTtKUFnNpckx","SUPPORT LORRY DIESEL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("16","BwKFccwwoTtKUFnNpckx","BIKE PETROL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("17","eFLFeIZIETXiRotxvIqx","COMPRROSSOR DIESEL","300","Palackal pump kattappana ","Credit","4123","28810","1","1");
INSERT INTO disel VALUES("18","eFLFeIZIETXiRotxvIqx","RIG LORRY DIESEL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("19","eFLFeIZIETXiRotxvIqx","SUPPORT LORRY DIESEL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("20","eFLFeIZIETXiRotxvIqx","BIKE PETROL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("21","YWzVLVqexHyrUqbcGSyN","COMPRROSSOR DIESEL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("22","YWzVLVqexHyrUqbcGSyN","RIG LORRY DIESEL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("23","YWzVLVqexHyrUqbcGSyN","SUPPORT LORRY DIESEL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("24","YWzVLVqexHyrUqbcGSyN","BIKE PETROL","0","No","Cash","N","0","1","1");
INSERT INTO disel VALUES("25","rNhDxKKKMxmyycrFwGdM","COMPRROSSOR DIESEL","300","Eassar ","Credit","26902","28770","1","1");
INSERT INTO disel VALUES("26","rNhDxKKKMxmyycrFwGdM","RIG LORRY DIESEL","26","Eassar ","Credit","27196","2500","1","1");
INSERT INTO disel VALUES("27","rNhDxKKKMxmyycrFwGdM","SUPPORT LORRY DIESEL","26","Eassar ","Credit","26900","2500","1","1");
INSERT INTO disel VALUES("28","rNhDxKKKMxmyycrFwGdM","BIKE PETROL","500","Hp capital","Cash","962888","500","1","1");
INSERT INTO disel VALUES("29","ZEZerARHkebkKPJOlBiD","COMPRROSSOR DIESEL","300.200","Eassar  kattappana. & anakkara ","Cash","27244.&.861062","28770.20000","1","1");
INSERT INTO disel VALUES("30","ZEZerARHkebkKPJOlBiD","RIG LORRY DIESEL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("31","ZEZerARHkebkKPJOlBiD","SUPPORT LORRY DIESEL","26","Eassar ","Credit","27640","2500","1","1");
INSERT INTO disel VALUES("32","ZEZerARHkebkKPJOlBiD","BIKE PETROL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("33","UBjGnHHQNBlEkjYFuvGj","COMPRROSSOR DIESEL","100","Eassar ","Credit","28352","9590","1","1");
INSERT INTO disel VALUES("34","UBjGnHHQNBlEkjYFuvGj","RIG LORRY DIESEL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("35","UBjGnHHQNBlEkjYFuvGj","SUPPORT LORRY DIESEL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("36","UBjGnHHQNBlEkjYFuvGj","BIKE PETROL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("37","xOFmUYaQreBHliIobDOM","COMPRROSSOR DIESEL","730","Bright fuels puliyanmala ","Credit","04383","70038","1","1");
INSERT INTO disel VALUES("38","xOFmUYaQreBHliIobDOM","RIG LORRY DIESEL","48","Bright fuels puliyanmala ","Credit","04382","4632","1","1");
INSERT INTO disel VALUES("39","xOFmUYaQreBHliIobDOM","SUPPORT LORRY DIESEL","60","Bright fuels puliyanmala ","Credit","04567","5753","1","1");
INSERT INTO disel VALUES("40","xOFmUYaQreBHliIobDOM","BIKE PETROL","500","Eassar ","Cash","0","500","1","1");
INSERT INTO disel VALUES("41","MMkfxCeYxVVQYQfFAZpp","COMPRROSSOR DIESEL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("42","MMkfxCeYxVVQYQfFAZpp","RIG LORRY DIESEL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("43","MMkfxCeYxVVQYQfFAZpp","SUPPORT LORRY DIESEL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("44","MMkfxCeYxVVQYQfFAZpp","BIKE PETROL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("45","KFaKlshCzMKYTwxLCSvb","COMPRROSSOR DIESEL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("46","KFaKlshCzMKYTwxLCSvb","RIG LORRY DIESEL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("47","KFaKlshCzMKYTwxLCSvb","SUPPORT LORRY DIESEL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("48","KFaKlshCzMKYTwxLCSvb","BIKE PETROL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("49","NvkPRIXBfXpHegRGmoQO","COMPRROSSOR DIESEL","650","Bright fuels puliyanmala ","Credit","325292","62309","1","1");
INSERT INTO disel VALUES("50","NvkPRIXBfXpHegRGmoQO","RIG LORRY DIESEL","25","Bright fuels puliyanmala ","Credit","625263","2430","1","1");
INSERT INTO disel VALUES("51","NvkPRIXBfXpHegRGmoQO","SUPPORT LORRY DIESEL","20.59","Bright fuels puliyanmala ","Credit","325285","1973.25","1","1");
INSERT INTO disel VALUES("52","NvkPRIXBfXpHegRGmoQO","BIKE PETROL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("53","NiUMajzEPXewWYymsuNn","COMPRROSSOR DIESEL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("54","NiUMajzEPXewWYymsuNn","RIG LORRY DIESEL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("55","NiUMajzEPXewWYymsuNn","SUPPORT LORRY DIESEL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("56","NiUMajzEPXewWYymsuNn","BIKE PETROL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("57","OwCmezKNnoybyhKTxKCN","COMPRROSSOR DIESEL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("58","OwCmezKNnoybyhKTxKCN","RIG LORRY DIESEL","50","Eassar ","Credit","309332","4795","1","1");
INSERT INTO disel VALUES("59","OwCmezKNnoybyhKTxKCN","SUPPORT LORRY DIESEL","50","Eassar ","Credit","30934","4795","1","1");
INSERT INTO disel VALUES("60","OwCmezKNnoybyhKTxKCN","BIKE PETROL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("61","XymrVnlMLTlcqjrPuTAN","COMPRROSSOR DIESEL","700","Bright fuels puliyanmala ","Credit","301887","67102","1","1");
INSERT INTO disel VALUES("62","XymrVnlMLTlcqjrPuTAN","RIG LORRY DIESEL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("63","XymrVnlMLTlcqjrPuTAN","SUPPORT LORRY DIESEL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("64","XymrVnlMLTlcqjrPuTAN","BIKE PETROL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("65","KsweJfxlgfUPQJgVnAkW","COMPRROSSOR DIESEL","200","Eassar kattappana ","Credit","31492","19180","1","1");
INSERT INTO disel VALUES("66","KsweJfxlgfUPQJgVnAkW","RIG LORRY DIESEL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("67","KsweJfxlgfUPQJgVnAkW","SUPPORT LORRY DIESEL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("68","KsweJfxlgfUPQJgVnAkW","BIKE PETROL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("69","bxbPvBcpXvXzufcXKSzm","COMPRROSSOR DIESEL","300","Palackal pump kattappana ","Credit","3596","28804","1","1");
INSERT INTO disel VALUES("70","bxbPvBcpXvXzufcXKSzm","RIG LORRY DIESEL","25","Palackal pump kattappana ","Credit","3597","2448","1","1");
INSERT INTO disel VALUES("71","bxbPvBcpXvXzufcXKSzm","SUPPORT LORRY DIESEL","25","Palackal pump kattappana ","Credit","3598","2397","1","1");
INSERT INTO disel VALUES("72","bxbPvBcpXvXzufcXKSzm","BIKE PETROL","0"," No","Cash","No","0","1","1");
INSERT INTO disel VALUES("73","NHoSboDycMCBAKmEFjVk","COMPRROSSOR DIESEL","50","Palackal pump kattappana ","Cash","   5223.volvo room.170ltr. total.₹21107","4795","1","1");
INSERT INTO disel VALUES("74","NHoSboDycMCBAKmEFjVk","RIG LORRY DIESEL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("75","NHoSboDycMCBAKmEFjVk","SUPPORT LORRY DIESEL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("76","NHoSboDycMCBAKmEFjVk","BIKE PETROL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("77","LLJEYJBciMcEwgaJBVEZ","COMPRROSSOR DIESEL","500","Essar kattapana","Credit","10153","47950","1","12");
INSERT INTO disel VALUES("78","LLJEYJBciMcEwgaJBVEZ","RIG LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("79","LLJEYJBciMcEwgaJBVEZ","SUPPORT LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("80","LLJEYJBciMcEwgaJBVEZ","BIKE PETROL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("81","JfNbaYBhaMAhvlVJokpk","COMPRROSSOR DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("82","JfNbaYBhaMAhvlVJokpk","RIG LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("83","JfNbaYBhaMAhvlVJokpk","SUPPORT LORRY DIESEL","57.25","Essar kattapana","Credit","10171","5490.27","1","12");
INSERT INTO disel VALUES("84","JfNbaYBhaMAhvlVJokpk","BIKE PETROL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("85","zTFAJwBCsjouUwdPLDJf","COMPRROSSOR DIESEL","365.23","Puthampuayil thangamani","Cash","980882 biju phonepe paid","35000","1","12");
INSERT INTO disel VALUES("86","zTFAJwBCsjouUwdPLDJf","RIG LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("87","zTFAJwBCsjouUwdPLDJf","SUPPORT LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("88","zTFAJwBCsjouUwdPLDJf","BIKE PETROL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("89","gjxwZjYdTkmODDcDRqVk","COMPRROSSOR DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("90","gjxwZjYdTkmODDcDRqVk","RIG LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("91","gjxwZjYdTkmODDcDRqVk","SUPPORT LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("92","gjxwZjYdTkmODDcDRqVk","BIKE PETROL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("93","SqYtTHPlHqEXMnYRoAEv","COMPRROSSOR DIESEL","981.19","Bright fuels puliyanmala","Credit","3071","94056.87","1","12");
INSERT INTO disel VALUES("94","SqYtTHPlHqEXMnYRoAEv","RIG LORRY DIESEL","44.27","Bright fuels puliyanmala","Credit","3072","4243.32","1","12");
INSERT INTO disel VALUES("95","SqYtTHPlHqEXMnYRoAEv","SUPPORT LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("96","SqYtTHPlHqEXMnYRoAEv","BIKE PETROL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("97","iBCRKSZeLbqdXSDpDpoq","COMPRROSSOR DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("98","iBCRKSZeLbqdXSDpDpoq","RIG LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("99","iBCRKSZeLbqdXSDpDpoq","SUPPORT LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("100","iBCRKSZeLbqdXSDpDpoq","BIKE PETROL","1.87","0","Cash","1154","200","1","12");
INSERT INTO disel VALUES("101","lOfGWMrXnTChHFQmkPSd","COMPRROSSOR DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("102","lOfGWMrXnTChHFQmkPSd","RIG LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("103","lOfGWMrXnTChHFQmkPSd","SUPPORT LORRY DIESEL","55.6","Essar kattapana","Credit","10300","5280.25","1","12");
INSERT INTO disel VALUES("104","lOfGWMrXnTChHFQmkPSd","BIKE PETROL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("105","EzlYMGjFMvSWLDyhuYCc","COMPRROSSOR DIESEL","200","Kunnamputath•8/9/25 madhu. Thookupalam","Credit","9142","19296","1","12");
INSERT INTO disel VALUES("106","EzlYMGjFMvSWLDyhuYCc","RIG LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("107","EzlYMGjFMvSWLDyhuYCc","SUPPORT LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("108","EzlYMGjFMvSWLDyhuYCc","BIKE PETROL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("109","lmNtlSkGjObPYCmTIOfL","COMPRROSSOR DIESEL","207.30","Kunnampurath. (Madhu. 9/9/25)","Credit"," 9147","20000","1","12");
INSERT INTO disel VALUES("110","lmNtlSkGjObPYCmTIOfL","RIG LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("111","lmNtlSkGjObPYCmTIOfL","SUPPORT LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("112","lmNtlSkGjObPYCmTIOfL","BIKE PETROL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("113","zWAIkjrinHrPylsOLyKU","COMPRROSSOR DIESEL","207.30","Kunnampurath(. 9/9/25.madhu)","Credit","9147","20000","1","12");
INSERT INTO disel VALUES("114","zWAIkjrinHrPylsOLyKU","RIG LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("115","zWAIkjrinHrPylsOLyKU","SUPPORT LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("116","zWAIkjrinHrPylsOLyKU","BIKE PETROL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("117","etRLQigbsbJinjJozuIC","COMPRROSSOR DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("118","etRLQigbsbJinjJozuIC","RIG LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("119","etRLQigbsbJinjJozuIC","SUPPORT LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("120","etRLQigbsbJinjJozuIC","BIKE PETROL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("121","OJUjEtfzJhYCvqHnsEUo","COMPRROSSOR DIESEL"," 600","Essar kattapana","Credit","10360","57540","1","12");
INSERT INTO disel VALUES("122","OJUjEtfzJhYCvqHnsEUo","RIG LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("123","OJUjEtfzJhYCvqHnsEUo","SUPPORT LORRY DIESEL","0","0","Cash"," 0","0","1","12");
INSERT INTO disel VALUES("124","OJUjEtfzJhYCvqHnsEUo","BIKE PETROL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("125","hrzywLrvWIRTdyoPyxRs","COMPRROSSOR DIESEL","500","Eassar ","Credit","0","47950","1","1");
INSERT INTO disel VALUES("126","fGfdVzkvEOWtftdRHsZE","COMPRROSSOR DIESEL","500","Eassar ","Credit","0","47950","1","1");
INSERT INTO disel VALUES("127","fGfdVzkvEOWtftdRHsZE","RIG LORRY DIESEL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("128","fGfdVzkvEOWtftdRHsZE","SUPPORT LORRY DIESEL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("129","fGfdVzkvEOWtftdRHsZE","BIKE PETROL","200","No","Credit","No","200","1","1");
INSERT INTO disel VALUES("130","ihjDavaOiMppxTDeTprY","COMPRROSSOR DIESEL"," 384.93","Bright fuels puliyanmala ","Credit","0","36899.39","1","1");
INSERT INTO disel VALUES("131","ihjDavaOiMppxTDeTprY","RIG LORRY DIESEL","39","Puliyanmala ","Credit","37814","3452.40","1","1");
INSERT INTO disel VALUES("132","ihjDavaOiMppxTDeTprY","SUPPORT LORRY DIESEL","45","Bright fuels puliyanmala ","Credit","37813","4313.70","1","1");
INSERT INTO disel VALUES("133","ihjDavaOiMppxTDeTprY","BIKE PETROL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("134","UsvnjOtQyiKGXvCEzaFC","COMPRROSSOR DIESEL","500","Eassar ","Credit","37817","47950","1","1");
INSERT INTO disel VALUES("135","UsvnjOtQyiKGXvCEzaFC","RIG LORRY DIESEL","36","Eassar ","Credit","37814","3452","1","1");
INSERT INTO disel VALUES("136","UsvnjOtQyiKGXvCEzaFC","SUPPORT LORRY DIESEL","36.51","Eassar ","Credit","37813","3501","1","1");
INSERT INTO disel VALUES("137","UsvnjOtQyiKGXvCEzaFC","BIKE PETROL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("138","jeaskUrKrpUKKKYnanVT","COMPRROSSOR DIESEL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("139","jeaskUrKrpUKKKYnanVT","RIG LORRY DIESEL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("140","jeaskUrKrpUKKKYnanVT","SUPPORT LORRY DIESEL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("141","jeaskUrKrpUKKKYnanVT","BIKE PETROL","4.66","Eassar ","Cash","99009","500","1","1");
INSERT INTO disel VALUES("142","oghIwYpHRsBcqOfQJnZL","COMPRROSSOR DIESEL"," 707.50","Kv.nair hp. Neadumkandam ","Cash","353333","67870.47","1","1");
INSERT INTO disel VALUES("143","oghIwYpHRsBcqOfQJnZL","RIG LORRY DIESEL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("144","oghIwYpHRsBcqOfQJnZL","SUPPORT LORRY DIESEL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("145","oghIwYpHRsBcqOfQJnZL","BIKE PETROL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("146","sETFhlohzupvnhiKNDRn","COMPRROSSOR DIESEL","200","Eassar kattappana ","Credit","38519","19180","1","1");
INSERT INTO disel VALUES("147","sETFhlohzupvnhiKNDRn","RIG LORRY DIESEL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("148","sETFhlohzupvnhiKNDRn","SUPPORT LORRY DIESEL","0","No","Cash","Nno","0","1","1");
INSERT INTO disel VALUES("149","sETFhlohzupvnhiKNDRn","BIKE PETROL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("150","ldYwbJzugUkVLrmGqReg","COMPRROSSOR DIESEL","500","Essar kattapana","Credit","10371","47950","1","12");
INSERT INTO disel VALUES("151","ldYwbJzugUkVLrmGqReg","RIG LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("152","ldYwbJzugUkVLrmGqReg","SUPPORT LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("153","ldYwbJzugUkVLrmGqReg","BIKE PETROL","4.66","Essar ","Cash","92732","500","1","12");
INSERT INTO disel VALUES("154","BtegyJVAaxWyTgmgvWwl","COMPRROSSOR DIESEL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("155","BtegyJVAaxWyTgmgvWwl","RIG LORRY DIESEL","60","Barath petroleum. Munnar ","Cash","307528","5800","1","1");
INSERT INTO disel VALUES("156","BtegyJVAaxWyTgmgvWwl","SUPPORT LORRY DIESEL","41","Barath petroleum munnar ","Cash","10601","4000","1","1");
INSERT INTO disel VALUES("157","BtegyJVAaxWyTgmgvWwl","BIKE PETROL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("158","sEMzRAYrYVEXkgoRkNml","COMPRROSSOR DIESEL","500","Bright fuels puliyanmala","Credit","3098","47930","1","12");
INSERT INTO disel VALUES("159","sEMzRAYrYVEXkgoRkNml","RIG LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("160","sEMzRAYrYVEXkgoRkNml","SUPPORT LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("161","sEMzRAYrYVEXkgoRkNml","BIKE PETROL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("162","ZOxLdMxdIcyQlaMzYEMD","COMPRROSSOR DIESEL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("163","ZOxLdMxdIcyQlaMzYEMD","RIG LORRY DIESEL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("164","ZOxLdMxdIcyQlaMzYEMD","SUPPORT LORRY DIESEL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("165","ZOxLdMxdIcyQlaMzYEMD","BIKE PETROL","0","No","Cash","No","0","1","1");
INSERT INTO disel VALUES("166","zRGdietBeevwCXDQZHnn","COMPRROSSOR DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("167","zRGdietBeevwCXDQZHnn","RIG LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("168","zRGdietBeevwCXDQZHnn","SUPPORT LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("169","zRGdietBeevwCXDQZHnn","BIKE PETROL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("170","JZMUsEktgmghiACSvUNq","COMPRROSSOR DIESEL","521.59","Bright feuls. ","Cash","3092","50000","1","12");
INSERT INTO disel VALUES("171","JZMUsEktgmghiACSvUNq","RIG LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("172","JZMUsEktgmghiACSvUNq","SUPPORT LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("173","JZMUsEktgmghiACSvUNq","BIKE PETROL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("174","fyTWTTLfoqzJbEQVsfhp","COMPRROSSOR DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("175","fyTWTTLfoqzJbEQVsfhp","RIG LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("176","fyTWTTLfoqzJbEQVsfhp","SUPPORT LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("177","fyTWTTLfoqzJbEQVsfhp","BIKE PETROL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("178","rSaYXYOJvxSzJYTWMBle","COMPRROSSOR DIESEL","886.51","Essar kattapana","Credit","10454","85016.30","1","12");
INSERT INTO disel VALUES("179","rSaYXYOJvxSzJYTWMBle","RIG LORRY DIESEL","44.23","Essar kattapana","Credit","10452","4241.65","1","12");
INSERT INTO disel VALUES("180","rSaYXYOJvxSzJYTWMBle","SUPPORT LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("181","rSaYXYOJvxSzJYTWMBle","BIKE PETROL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("182","AtviTTORsExANYjTenqm","COMPRROSSOR DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("183","AtviTTORsExANYjTenqm","RIG LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("184","AtviTTORsExANYjTenqm","SUPPORT LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("185","AtviTTORsExANYjTenqm","BIKE PETROL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("186","kqMrimPPrYXyevRNTpQa","COMPRROSSOR DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("187","kqMrimPPrYXyevRNTpQa","RIG LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("188","kqMrimPPrYXyevRNTpQa","SUPPORT LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("189","kqMrimPPrYXyevRNTpQa","BIKE PETROL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("190","ieIHUVqfofBSRsWjiuRA","COMPRROSSOR DIESEL","300","Essar kattapana","Credit","10501","28770","1","12");
INSERT INTO disel VALUES("191","ieIHUVqfofBSRsWjiuRA","RIG LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("192","ieIHUVqfofBSRsWjiuRA","SUPPORT LORRY DIESEL","40.01","Essar kattapana","Credit","10503","3836","1","12");
INSERT INTO disel VALUES("193","ieIHUVqfofBSRsWjiuRA","BIKE PETROL","4.66","Essar kattapana","Cash","103426","500","1","12");
INSERT INTO disel VALUES("194","gOpOhMmjbXQrVYeLhRFI","COMPRROSSOR DIESEL","538","Essar","Credit","No","51627","1","4");
INSERT INTO disel VALUES("195","gOpOhMmjbXQrVYeLhRFI","RIG LORRY DIESEL","20","Essat","Credit","No","1931","1","4");
INSERT INTO disel VALUES("196","gOpOhMmjbXQrVYeLhRFI","SUPPORT LORRY DIESEL","52","Essar","Credit","No","5000","1","4");
INSERT INTO disel VALUES("197","gOpOhMmjbXQrVYeLhRFI","BIKE PETROL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("198","UozTAgbAXXEwIwfIurXe","COMPRROSSOR DIESEL","676","Adimali","Cash","No","65023","1","4");
INSERT INTO disel VALUES("199","UozTAgbAXXEwIwfIurXe","RIG LORRY DIESEL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("200","UozTAgbAXXEwIwfIurXe","SUPPORT LORRY DIESEL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("201","UozTAgbAXXEwIwfIurXe","BIKE PETROL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("202","AlqKxJdQaHtkkcoLppqd","COMPRROSSOR DIESEL","474","Adimali","Cash","No","45321","1","4");
INSERT INTO disel VALUES("203","AlqKxJdQaHtkkcoLppqd","RIG LORRY DIESEL","24.61","No","Cash","No","2355","1","4");
INSERT INTO disel VALUES("204","AlqKxJdQaHtkkcoLppqd","SUPPORT LORRY DIESEL","30","No","Cash","No","2900","1","4");
INSERT INTO disel VALUES("205","AlqKxJdQaHtkkcoLppqd","BIKE PETROL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("206","eUwzeFJoRTChYEzrwPmH","COMPRROSSOR DIESEL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("207","eUwzeFJoRTChYEzrwPmH","RIG LORRY DIESEL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("208","eUwzeFJoRTChYEzrwPmH","SUPPORT LORRY DIESEL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("209","eUwzeFJoRTChYEzrwPmH","BIKE PETROL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("210","ZoLpUFsXyQyqLWGtrlcN","COMPRROSSOR DIESEL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("211","ZoLpUFsXyQyqLWGtrlcN","RIG LORRY DIESEL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("212","ZoLpUFsXyQyqLWGtrlcN","SUPPORT LORRY DIESEL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("213","ZoLpUFsXyQyqLWGtrlcN","BIKE PETROL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("214","WMvdrlamRKbTDitkhhuV","COMPRROSSOR DIESEL","753","Essar","Credit","10528","72212","1","4");
INSERT INTO disel VALUES("215","WMvdrlamRKbTDitkhhuV","RIG LORRY DIESEL","42","Essar","Credit","10529","4028","1","4");
INSERT INTO disel VALUES("216","WMvdrlamRKbTDitkhhuV","SUPPORT LORRY DIESEL","39.40","Essar","Credit","10532","3778.46","1","4");
INSERT INTO disel VALUES("217","WMvdrlamRKbTDitkhhuV","BIKE PETROL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("218","PrSyzhnpiNqfFGMMlftx","COMPRROSSOR DIESEL","0","O","Cash","No","0","1","4");
INSERT INTO disel VALUES("219","PrSyzhnpiNqfFGMMlftx","RIG LORRY DIESEL","0","Nono","Cash","No","0","1","4");
INSERT INTO disel VALUES("220","PrSyzhnpiNqfFGMMlftx","SUPPORT LORRY DIESEL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("221","PrSyzhnpiNqfFGMMlftx","BIKE PETROL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("222","AGrYqJnGaHXmxsKQicYN","COMPRROSSOR DIESEL","889.77","Essar kattapana(19/9/25","Credit","10526","85328.94","1","12");
INSERT INTO disel VALUES("223","AGrYqJnGaHXmxsKQicYN","RIG LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("224","AGrYqJnGaHXmxsKQicYN","SUPPORT LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("225","AGrYqJnGaHXmxsKQicYN","BIKE PETROL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("226","LZObULGyHAtWbHTdlSwh","COMPRROSSOR DIESEL","590","Essar","Credit","No","56631","1","4");
INSERT INTO disel VALUES("227","LZObULGyHAtWbHTdlSwh","RIG LORRY DIESEL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("228","LZObULGyHAtWbHTdlSwh","SUPPORT LORRY DIESEL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("229","LZObULGyHAtWbHTdlSwh","BIKE PETROL","1000","Essar","Cash","No","1000","1","4");
INSERT INTO disel VALUES("230","ogAFAHslvFOGabQgnUnH","COMPRROSSOR DIESEL","511","Nadikandam","Cash","No","49056","1","4");
INSERT INTO disel VALUES("231","ogAFAHslvFOGabQgnUnH","RIG LORRY DIESEL","30.96","Nadukandam","Cash","No","2970","1","4");
INSERT INTO disel VALUES("232","ogAFAHslvFOGabQgnUnH","SUPPORT LORRY DIESEL","37.85","Nadukandam","Cash","No","3631","1","4");
INSERT INTO disel VALUES("233","ogAFAHslvFOGabQgnUnH","BIKE PETROL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("234","NQaEhZafMWzjICrfsMZB","COMPRROSSOR DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("235","NQaEhZafMWzjICrfsMZB","RIG LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("236","NQaEhZafMWzjICrfsMZB","SUPPORT LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("237","NQaEhZafMWzjICrfsMZB","BIKE PETROL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("238","jVdJxMGGlmturGbUmjfm","COMPRROSSOR DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("239","jVdJxMGGlmturGbUmjfm","RIG LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("240","jVdJxMGGlmturGbUmjfm","SUPPORT LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("241","jVdJxMGGlmturGbUmjfm","BIKE PETROL","9.33","Essar kattapana","Cash","98658","1001.57","1","12");
INSERT INTO disel VALUES("242","YPsFEOAbvOTGmQSRZfuv","COMPRROSSOR DIESEL","750","Nadumkandam","Cash","No","71955","1","4");
INSERT INTO disel VALUES("243","YPsFEOAbvOTGmQSRZfuv","RIG LORRY DIESEL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("244","YPsFEOAbvOTGmQSRZfuv","SUPPORT LORRY DIESEL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("245","YPsFEOAbvOTGmQSRZfuv","BIKE PETROL","1000","Nagumkandam","Cash","No","1000","1","4");
INSERT INTO disel VALUES("246","KcPjIpQjsFonPxAyIyqf","COMPRROSSOR DIESEL","520","Anachal","Cash","10365","50000","1","4");
INSERT INTO disel VALUES("247","KcPjIpQjsFonPxAyIyqf","RIG LORRY DIESEL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("248","KcPjIpQjsFonPxAyIyqf","SUPPORT LORRY DIESEL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("249","KcPjIpQjsFonPxAyIyqf","BIKE PETROL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("250","tWVMvrBjsuTJyoHXfzxr","COMPRROSSOR DIESEL","325","Kunnumpurath thookupalam","Credit","9192","31356","1","12");
INSERT INTO disel VALUES("251","tWVMvrBjsuTJyoHXfzxr","RIG LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("252","tWVMvrBjsuTJyoHXfzxr","SUPPORT LORRY DIESEL","25","Kunnumpurath thookupalam","Credit","9190","2412","1","12");
INSERT INTO disel VALUES("253","tWVMvrBjsuTJyoHXfzxr","BIKE PETROL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("254","XosoFYeMJLUvoWfVvNcG","COMPRROSSOR DIESEL","500","Essar kattapana","Credit","10731","47950","1","12");
INSERT INTO disel VALUES("255","XosoFYeMJLUvoWfVvNcG","RIG LORRY DIESEL","46.82","Essar kattapana","Credit","10733","4494.83","1","12");
INSERT INTO disel VALUES("256","XosoFYeMJLUvoWfVvNcG","SUPPORT LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("257","XosoFYeMJLUvoWfVvNcG","BIKE PETROL","0","0","Credit","0","0","1","12");
INSERT INTO disel VALUES("258","HHrSkNmMlXuxkNuuiqTw","COMPRROSSOR DIESEL","671","Essar","Credit","10740","64403.56","1","4");
INSERT INTO disel VALUES("259","HHrSkNmMlXuxkNuuiqTw","RIG LORRY DIESEL","51.10","Essat","Credit","10736","4900.49","1","4");
INSERT INTO disel VALUES("260","HHrSkNmMlXuxkNuuiqTw","SUPPORT LORRY DIESEL","59.34","Essar","Credit","10738","5690.70","1","4");
INSERT INTO disel VALUES("261","HHrSkNmMlXuxkNuuiqTw","BIKE PETROL","9.32","Essar","Cash","No","1000","1","4");
INSERT INTO disel VALUES("262","WntHsflqUNtdqunYmVeR","COMPRROSSOR DIESEL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("263","WntHsflqUNtdqunYmVeR","RIG LORRY DIESEL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("264","WntHsflqUNtdqunYmVeR","SUPPORT LORRY DIESEL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("265","WntHsflqUNtdqunYmVeR","BIKE PETROL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("266","LAGjucyMgvIyNfFIAteQ","COMPRROSSOR DIESEL","500","Kattapana autofules","Credit","4159","48068.46","1","12");
INSERT INTO disel VALUES("267","LAGjucyMgvIyNfFIAteQ","RIG LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("268","LAGjucyMgvIyNfFIAteQ","SUPPORT LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("269","LAGjucyMgvIyNfFIAteQ","BIKE PETROL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("270","WGjgLcLzgcPZfpVzxRsa","COMPRROSSOR DIESEL","558","Essar","Credit","No","53527","1","4");
INSERT INTO disel VALUES("271","WGjgLcLzgcPZfpVzxRsa","RIG LORRY DIESEL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("272","WGjgLcLzgcPZfpVzxRsa","SUPPORT LORRY DIESEL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("273","WGjgLcLzgcPZfpVzxRsa","BIKE PETROL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("274","paobQmmNnGudtTTPwtlC","COMPRROSSOR DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("275","paobQmmNnGudtTTPwtlC","RIG LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("276","paobQmmNnGudtTTPwtlC","SUPPORT LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("277","paobQmmNnGudtTTPwtlC","BIKE PETROL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("278","EzklpFtgYYhzwKPathMV","COMPRROSSOR DIESEL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("279","EzklpFtgYYhzwKPathMV","RIG LORRY DIESEL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("280","EzklpFtgYYhzwKPathMV","SUPPORT LORRY DIESEL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("281","EzklpFtgYYhzwKPathMV","BIKE PETROL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("282","gIIkEHnmuRDdEjdTYfrm","COMPRROSSOR DIESEL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("283","gIIkEHnmuRDdEjdTYfrm","RIG LORRY DIESEL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("284","gIIkEHnmuRDdEjdTYfrm","SUPPORT LORRY DIESEL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("285","gIIkEHnmuRDdEjdTYfrm","BIKE PETROL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("286","UHjaHZcXOQwLZWzbsGXa","COMPRROSSOR DIESEL","531.54","Essar","Credit","No","50974.60","1","4");
INSERT INTO disel VALUES("287","UHjaHZcXOQwLZWzbsGXa","RIG LORRY DIESEL","42.76","Essat","Credit","No","4100","1","4");
INSERT INTO disel VALUES("288","UHjaHZcXOQwLZWzbsGXa","SUPPORT LORRY DIESEL","50.16","Essar","Credit","No","4810","1","4");
INSERT INTO disel VALUES("289","UHjaHZcXOQwLZWzbsGXa","BIKE PETROL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("290","yuQyWiygSPNqprqPLBmI","COMPRROSSOR DIESEL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("291","yuQyWiygSPNqprqPLBmI","RIG LORRY DIESEL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("292","yuQyWiygSPNqprqPLBmI","SUPPORT LORRY DIESEL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("293","yuQyWiygSPNqprqPLBmI","BIKE PETROL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("294","yobrYkfryqrtWtfKmNYb","COMPRROSSOR DIESEL","1000","Bright fuels 8/10/25puliyanmala","Credit"," 3183","96060","1","12");
INSERT INTO disel VALUES("295","yobrYkfryqrtWtfKmNYb","RIG LORRY DIESEL","31.24","Bright fules 8/10/25 puliyanmala","Cash"," 3184","3000.97","1","12");
INSERT INTO disel VALUES("296","yobrYkfryqrtWtfKmNYb","SUPPORT LORRY DIESEL","41.27","Bright fules 8/10/25","Cash","  1498","3964.40","1","12");
INSERT INTO disel VALUES("297","yobrYkfryqrtWtfKmNYb","BIKE PETROL","0","0","Cash","   0","0","1","12");
INSERT INTO disel VALUES("298","mIiIaYQjPgiWUTdNWKnn","COMPRROSSOR DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("299","mIiIaYQjPgiWUTdNWKnn","RIG LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("300","mIiIaYQjPgiWUTdNWKnn","SUPPORT LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("301","mIiIaYQjPgiWUTdNWKnn","BIKE PETROL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("302","WOqgNyryTsjJOhezrVIw","COMPRROSSOR DIESEL","500","Essar kattapana","Credit","10916","47950","1","12");
INSERT INTO disel VALUES("303","WOqgNyryTsjJOhezrVIw","RIG LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("304","WOqgNyryTsjJOhezrVIw","SUPPORT LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("305","WOqgNyryTsjJOhezrVIw","BIKE PETROL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("306","UFFxCypvYAyCRCeoGMjy","COMPRROSSOR DIESEL","531.60","Essat","Credit","No","50980","1","4");
INSERT INTO disel VALUES("307","UFFxCypvYAyCRCeoGMjy","RIG LORRY DIESEL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("308","UFFxCypvYAyCRCeoGMjy","SUPPORT LORRY DIESEL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("309","UFFxCypvYAyCRCeoGMjy","BIKE PETROL","9.3","Essat","Cash","No","1000","1","4");
INSERT INTO disel VALUES("310","HqvVVFMxjTFRAmKBoMWb","COMPRROSSOR DIESEL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("311","HqvVVFMxjTFRAmKBoMWb","RIG LORRY DIESEL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("312","HqvVVFMxjTFRAmKBoMWb","SUPPORT LORRY DIESEL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("313","HqvVVFMxjTFRAmKBoMWb","BIKE PETROL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("314","BLkmbxevhXbtpDaMFVxG","COMPRROSSOR DIESEL","500","Essar kattapana","Credit","10966","47950","1","12");
INSERT INTO disel VALUES("315","BLkmbxevhXbtpDaMFVxG","RIG LORRY DIESEL","52.31","Essar kattapana","Credit","10965","5016.52","1","12");
INSERT INTO disel VALUES("316","BLkmbxevhXbtpDaMFVxG","SUPPORT LORRY DIESEL","43.96","Essar kattapana","Credit","10969","4215.76","1","12");
INSERT INTO disel VALUES("317","BLkmbxevhXbtpDaMFVxG","BIKE PETROL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("318","JLAChJbDfSmKVIzbhYYb","COMPRROSSOR DIESEL","500","Essat","Credit","No","47952","1","4");
INSERT INTO disel VALUES("319","JLAChJbDfSmKVIzbhYYb","RIG LORRY DIESEL","45.85","Essar","Credit","No","4684.71","1","4");
INSERT INTO disel VALUES("320","JLAChJbDfSmKVIzbhYYb","SUPPORT LORRY DIESEL","39.53","Essat","Credit","No","3790","1","4");
INSERT INTO disel VALUES("321","JLAChJbDfSmKVIzbhYYb","BIKE PETROL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("322","RZRAPmUtHlQSpOTlEPss","COMPRROSSOR DIESEL","200","Bright fuels 15/10/25puliyanmama","Credit","4502","19212","1","12");
INSERT INTO disel VALUES("323","RZRAPmUtHlQSpOTlEPss","RIG LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("324","RZRAPmUtHlQSpOTlEPss","SUPPORT LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("325","RZRAPmUtHlQSpOTlEPss","BIKE PETROL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("326","DdAGcJJOiFieBlMjryYa","COMPRROSSOR DIESEL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("327","DdAGcJJOiFieBlMjryYa","RIG LORRY DIESEL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("328","DdAGcJJOiFieBlMjryYa","SUPPORT LORRY DIESEL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("329","DdAGcJJOiFieBlMjryYa","BIKE PETROL","0","No","Credit","No","0","1","4");
INSERT INTO disel VALUES("330","nixidcbpTVytXztoMJoV","COMPRROSSOR DIESEL","300.500","Essar...kattapana.fules","Credit","11058...4391","28770","1","4");
INSERT INTO disel VALUES("331","nixidcbpTVytXztoMJoV","RIG LORRY DIESEL","500","Kattapana","Credit","4391","48064","1","4");
INSERT INTO disel VALUES("332","nixidcbpTVytXztoMJoV","SUPPORT LORRY DIESEL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("333","nixidcbpTVytXztoMJoV","BIKE PETROL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("334","uoxhaXEvKvfBlRzyzYmS","COMPRROSSOR DIESEL","300","Thukkupalam","Credit","No","28920","1","4");
INSERT INTO disel VALUES("335","uoxhaXEvKvfBlRzyzYmS","RIG LORRY DIESEL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("336","uoxhaXEvKvfBlRzyzYmS","SUPPORT LORRY DIESEL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("337","uoxhaXEvKvfBlRzyzYmS","BIKE PETROL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("338","UrvSIypOJkLUdAGOpggA","COMPRROSSOR DIESEL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("339","UrvSIypOJkLUdAGOpggA","RIG LORRY DIESEL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("340","UrvSIypOJkLUdAGOpggA","SUPPORT LORRY DIESEL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("341","UrvSIypOJkLUdAGOpggA","BIKE PETROL","4.9","Essar","Cash","No","500","1","4");
INSERT INTO disel VALUES("342","SWBfJyCSiMzIzUuAumtM","COMPRROSSOR DIESEL","500","Kunnampurath thookupalam. 24/10/25","Credit","9259","48200","1","12");
INSERT INTO disel VALUES("343","SWBfJyCSiMzIzUuAumtM","RIG LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("344","SWBfJyCSiMzIzUuAumtM","SUPPORT LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("345","SWBfJyCSiMzIzUuAumtM","BIKE PETROL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("346","HveCAKwEUgbYnYvCnSLg","COMPRROSSOR DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("347","HveCAKwEUgbYnYvCnSLg","RIG LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("348","HveCAKwEUgbYnYvCnSLg","SUPPORT LORRY DIESEL","0","0😛","Cash","0","0","1","12");
INSERT INTO disel VALUES("349","HveCAKwEUgbYnYvCnSLg","BIKE PETROL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("350","RvjXBihTjpNgIxEIeONw","COMPRROSSOR DIESEL","200","Essar","Credit","No","19180","1","4");
INSERT INTO disel VALUES("351","RvjXBihTjpNgIxEIeONw","RIG LORRY DIESEL","35","Essar","Credit","No","3357","1","4");
INSERT INTO disel VALUES("352","RvjXBihTjpNgIxEIeONw","SUPPORT LORRY DIESEL","40","Essat","Credit","No","3836","1","4");
INSERT INTO disel VALUES("353","RvjXBihTjpNgIxEIeONw","BIKE PETROL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("354","eTTfxAOrBKOnYStVZJbv","COMPRROSSOR DIESEL","450","Kunnampurath thookupalam26/10","Cash"," 9265","43380","1","12");
INSERT INTO disel VALUES("355","eTTfxAOrBKOnYStVZJbv","RIG LORRY DIESEL","25","Kunnampirath thokkupalam26/10","Credit","9267","2410","1","12");
INSERT INTO disel VALUES("356","eTTfxAOrBKOnYStVZJbv","SUPPORT LORRY DIESEL","25","Kunnampurath thokkupalam26/10","Credit","9266","2410","1","12");
INSERT INTO disel VALUES("357","eTTfxAOrBKOnYStVZJbv","BIKE PETROL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("358","hXWzNyxBOUojhJrIdBAF","COMPRROSSOR DIESEL","500","Essar","Credit","No","47952","1","4");
INSERT INTO disel VALUES("359","hXWzNyxBOUojhJrIdBAF","RIG LORRY DIESEL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("360","hXWzNyxBOUojhJrIdBAF","SUPPORT LORRY DIESEL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("361","hXWzNyxBOUojhJrIdBAF","BIKE PETROL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("362","BykHRgTPYIIBdFuNcUBO","COMPRROSSOR DIESEL","255","Essat","Credit","No","24529","1","4");
INSERT INTO disel VALUES("363","BykHRgTPYIIBdFuNcUBO","RIG LORRY DIESEL","40","Essat","Credit","No","3836","1","4");
INSERT INTO disel VALUES("364","BykHRgTPYIIBdFuNcUBO","SUPPORT LORRY DIESEL","46","Essat","Credit","No","4496","1","4");
INSERT INTO disel VALUES("365","BykHRgTPYIIBdFuNcUBO","BIKE PETROL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("366","sexbCAFzXAyrkzTmlZNL","COMPRROSSOR DIESEL","614","Essar","Credit","No","58885","1","4");
INSERT INTO disel VALUES("367","sexbCAFzXAyrkzTmlZNL","RIG LORRY DIESEL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("368","sexbCAFzXAyrkzTmlZNL","SUPPORT LORRY DIESEL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("369","sexbCAFzXAyrkzTmlZNL","BIKE PETROL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("370","UYcZtdXUptgXbtvNQBFh","COMPRROSSOR DIESEL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("371","UYcZtdXUptgXbtvNQBFh","RIG LORRY DIESEL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("372","UYcZtdXUptgXbtvNQBFh","SUPPORT LORRY DIESEL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("373","UYcZtdXUptgXbtvNQBFh","BIKE PETROL","0","No","Cash","No","0","1","4");
INSERT INTO disel VALUES("374","UUMndzaJmwghsWBXGoMi","COMPRROSSOR DIESEL","600","Kunnampurath 31/10/25","Credit","9885","57840","1","12");
INSERT INTO disel VALUES("375","UUMndzaJmwghsWBXGoMi","RIG LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("376","UUMndzaJmwghsWBXGoMi","SUPPORT LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("377","UUMndzaJmwghsWBXGoMi","BIKE PETROL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("378","IfwENafDROQMqlkEJZpF","COMPRROSSOR DIESEL","313.45","Rajakadu","Cash","659409","30000","1","12");
INSERT INTO disel VALUES("379","IfwENafDROQMqlkEJZpF","RIG LORRY DIESEL","41.80","Rajakadu","Cash","659413","4000","1","12");
INSERT INTO disel VALUES("380","IfwENafDROQMqlkEJZpF","SUPPORT LORRY DIESEL","0","0","Cash","0","0","1","12");
INSERT INTO disel VALUES("381","IfwENafDROQMqlkEJZpF","BIKE PETROL","0","0","Cash","0","0","1","12");

CREATE TABLE `dpeth` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `jobid` varchar(500) NOT NULL,
  `depth` varchar(50) NOT NULL,
  `rate` varchar(50) NOT NULL,
  `amount` varchar(50) NOT NULL,
  `sts` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=151 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO dpeth VALUES("1","yIhZwhwCfYmfNHBVRZyf","400","0","0","1");
INSERT INTO dpeth VALUES("2","yIhZwhwCfYmfNHBVRZyf","100","0","0","1");
INSERT INTO dpeth VALUES("3","yIhZwhwCfYmfNHBVRZyf","100","0","0","1");
INSERT INTO dpeth VALUES("4","yIhZwhwCfYmfNHBVRZyf","100","0","0","1");
INSERT INTO dpeth VALUES("5","viPlrLGqhBaCFpkYCaDc","280","0","0","1");
INSERT INTO dpeth VALUES("6","jzHtIyVSBEBgCjoDPQXR","70","0","0","1");
INSERT INTO dpeth VALUES("7","BwKFccwwoTtKUFnNpckx","390","0","0","1");
INSERT INTO dpeth VALUES("8","eFLFeIZIETXiRotxvIqx","400","0","0","1");
INSERT INTO dpeth VALUES("9","eFLFeIZIETXiRotxvIqx","100","0","0","1");
INSERT INTO dpeth VALUES("10","eFLFeIZIETXiRotxvIqx","100","0","0","1");
INSERT INTO dpeth VALUES("11","rNhDxKKKMxmyycrFwGdM","400","0","0","1");
INSERT INTO dpeth VALUES("12","rNhDxKKKMxmyycrFwGdM","100","0","0","1");
INSERT INTO dpeth VALUES("13","rNhDxKKKMxmyycrFwGdM","100","0","0","1");
INSERT INTO dpeth VALUES("14","rNhDxKKKMxmyycrFwGdM","60","0","0","1");
INSERT INTO dpeth VALUES("15","ZEZerARHkebkKPJOlBiD","400","0","0","1");
INSERT INTO dpeth VALUES("16","ZEZerARHkebkKPJOlBiD","100","0","0","1");
INSERT INTO dpeth VALUES("17","ZEZerARHkebkKPJOlBiD","100","0","0","1");
INSERT INTO dpeth VALUES("18","ZEZerARHkebkKPJOlBiD","100","0","0","1");
INSERT INTO dpeth VALUES("19","ZEZerARHkebkKPJOlBiD","100","0","0","1");
INSERT INTO dpeth VALUES("20","UBjGnHHQNBlEkjYFuvGj","200","0","0","1");
INSERT INTO dpeth VALUES("21","xOFmUYaQreBHliIobDOM","400","0","0","1");
INSERT INTO dpeth VALUES("22","xOFmUYaQreBHliIobDOM","25","0","0","1");
INSERT INTO dpeth VALUES("23","MMkfxCeYxVVQYQfFAZpp","400","0","0","1");
INSERT INTO dpeth VALUES("24","MMkfxCeYxVVQYQfFAZpp","100","0","0","1");
INSERT INTO dpeth VALUES("25","MMkfxCeYxVVQYQfFAZpp","100","0","0","1");
INSERT INTO dpeth VALUES("26","MMkfxCeYxVVQYQfFAZpp","100","0","0","1");
INSERT INTO dpeth VALUES("27","MMkfxCeYxVVQYQfFAZpp","20","0","0","1");
INSERT INTO dpeth VALUES("28","KFaKlshCzMKYTwxLCSvb","700","0","0","1");
INSERT INTO dpeth VALUES("29","NvkPRIXBfXpHegRGmoQO","400","0","0","1");
INSERT INTO dpeth VALUES("30","NvkPRIXBfXpHegRGmoQO","100","0","0","1");
INSERT INTO dpeth VALUES("31","NvkPRIXBfXpHegRGmoQO","100","0","0","1");
INSERT INTO dpeth VALUES("32","NvkPRIXBfXpHegRGmoQO","35","0","0","1");
INSERT INTO dpeth VALUES("33","NiUMajzEPXewWYymsuNn","400","0","0","1");
INSERT INTO dpeth VALUES("34","NiUMajzEPXewWYymsuNn","50","0","0","1");
INSERT INTO dpeth VALUES("35","OwCmezKNnoybyhKTxKCN","360","0","0","1");
INSERT INTO dpeth VALUES("36","XymrVnlMLTlcqjrPuTAN","400","0","0","1");
INSERT INTO dpeth VALUES("37","XymrVnlMLTlcqjrPuTAN","100","0","0","1");
INSERT INTO dpeth VALUES("38","XymrVnlMLTlcqjrPuTAN","100","0","0","1");
INSERT INTO dpeth VALUES("39","XymrVnlMLTlcqjrPuTAN","100","0","0","1");
INSERT INTO dpeth VALUES("40","XymrVnlMLTlcqjrPuTAN","100","0","0","1");
INSERT INTO dpeth VALUES("41","XymrVnlMLTlcqjrPuTAN","100","0","0","1");
INSERT INTO dpeth VALUES("42","XymrVnlMLTlcqjrPuTAN","100","0","0","1");
INSERT INTO dpeth VALUES("43","KsweJfxlgfUPQJgVnAkW","320","0","0","1");
INSERT INTO dpeth VALUES("44","bxbPvBcpXvXzufcXKSzm","285","0","0","1");
INSERT INTO dpeth VALUES("45","NHoSboDycMCBAKmEFjVk","400","0","0","1");
INSERT INTO dpeth VALUES("46","NHoSboDycMCBAKmEFjVk","100","0","0","1");
INSERT INTO dpeth VALUES("47","NHoSboDycMCBAKmEFjVk","100","0","0","1");
INSERT INTO dpeth VALUES("48","LLJEYJBciMcEwgaJBVEZ","255","0","0","1");
INSERT INTO dpeth VALUES("51","JfNbaYBhaMAhvlVJokpk","630","0","0","1");
INSERT INTO dpeth VALUES("52","zTFAJwBCsjouUwdPLDJf","260","0","0","1");
INSERT INTO dpeth VALUES("53","gjxwZjYdTkmODDcDRqVk","500","0","0","1");
INSERT INTO dpeth VALUES("54","SqYtTHPlHqEXMnYRoAEv","1000","0","0","1");
INSERT INTO dpeth VALUES("55","iBCRKSZeLbqdXSDpDpoq","250","0","0","1");
INSERT INTO dpeth VALUES("56","lOfGWMrXnTChHFQmkPSd","255","0","0","1");
INSERT INTO dpeth VALUES("57","EzlYMGjFMvSWLDyhuYCc","395","0","0","1");
INSERT INTO dpeth VALUES("59","lmNtlSkGjObPYCmTIOfL","295","0","0","1");
INSERT INTO dpeth VALUES("60","zWAIkjrinHrPylsOLyKU","295","0","0","1");
INSERT INTO dpeth VALUES("61","etRLQigbsbJinjJozuIC","200","0","0","1");
INSERT INTO dpeth VALUES("62","OJUjEtfzJhYCvqHnsEUo","600","0","0","1");
INSERT INTO dpeth VALUES("63","hrzywLrvWIRTdyoPyxRs","400","0","0","1");
INSERT INTO dpeth VALUES("64","hrzywLrvWIRTdyoPyxRs","80","0","0","1");
INSERT INTO dpeth VALUES("65","fGfdVzkvEOWtftdRHsZE","400","0","0","1");
INSERT INTO dpeth VALUES("66","fGfdVzkvEOWtftdRHsZE","80","0","0","1");
INSERT INTO dpeth VALUES("74","ihjDavaOiMppxTDeTprY","300","0","0","1");
INSERT INTO dpeth VALUES("75","ihjDavaOiMppxTDeTprY","100","0","0","1");
INSERT INTO dpeth VALUES("76","ihjDavaOiMppxTDeTprY","100","0","0","1");
INSERT INTO dpeth VALUES("77","ihjDavaOiMppxTDeTprY","100","0","0","1");
INSERT INTO dpeth VALUES("78","ihjDavaOiMppxTDeTprY","100","0","0","1");
INSERT INTO dpeth VALUES("79","ihjDavaOiMppxTDeTprY","100","0","0","1");
INSERT INTO dpeth VALUES("80","ihjDavaOiMppxTDeTprY","100","0","0","1");
INSERT INTO dpeth VALUES("81","ihjDavaOiMppxTDeTprY","100","0","0","1");
INSERT INTO dpeth VALUES("82","UsvnjOtQyiKGXvCEzaFC","200","0","0","1");
INSERT INTO dpeth VALUES("83","jeaskUrKrpUKKKYnanVT","400","0","0","1");
INSERT INTO dpeth VALUES("84","jeaskUrKrpUKKKYnanVT","100","0","0","1");
INSERT INTO dpeth VALUES("85","jeaskUrKrpUKKKYnanVT","100","0","0","1");
INSERT INTO dpeth VALUES("86","oghIwYpHRsBcqOfQJnZL","400","0","0","1");
INSERT INTO dpeth VALUES("87","oghIwYpHRsBcqOfQJnZL","40","0","0","1");
INSERT INTO dpeth VALUES("88","sETFhlohzupvnhiKNDRn","290","0","0","1");
INSERT INTO dpeth VALUES("89","ldYwbJzugUkVLrmGqReg","1040","0","0","1");
INSERT INTO dpeth VALUES("90","BtegyJVAaxWyTgmgvWwl","200","0","0","1");
INSERT INTO dpeth VALUES("91","sEMzRAYrYVEXkgoRkNml","465","0","0","1");
INSERT INTO dpeth VALUES("92","ZOxLdMxdIcyQlaMzYEMD","195","0","0","1");
INSERT INTO dpeth VALUES("93","zRGdietBeevwCXDQZHnn","600","0","0","1");
INSERT INTO dpeth VALUES("94","JZMUsEktgmghiACSvUNq","465","0","0","1");
INSERT INTO dpeth VALUES("95","fyTWTTLfoqzJbEQVsfhp","450","0","0","1");
INSERT INTO dpeth VALUES("97","rSaYXYOJvxSzJYTWMBle","500","0","0","1");
INSERT INTO dpeth VALUES("98","AtviTTORsExANYjTenqm","300","0","0","1");
INSERT INTO dpeth VALUES("99","kqMrimPPrYXyevRNTpQa","550","0","0","1");
INSERT INTO dpeth VALUES("100","ieIHUVqfofBSRsWjiuRA","810","0","0","1");
INSERT INTO dpeth VALUES("102","gOpOhMmjbXQrVYeLhRFI","845","130","109850","1");
INSERT INTO dpeth VALUES("103","UozTAgbAXXEwIwfIurXe","800","0","0","1");
INSERT INTO dpeth VALUES("104","hUpEulgXgbpOXIeVFIoW","120","0","0","1");
INSERT INTO dpeth VALUES("105","AlqKxJdQaHtkkcoLppqd","120","0","0","1");
INSERT INTO dpeth VALUES("106","eUwzeFJoRTChYEzrwPmH","600","0","0","1");
INSERT INTO dpeth VALUES("107","ZoLpUFsXyQyqLWGtrlcN","550","0","0","1");
INSERT INTO dpeth VALUES("108","WMvdrlamRKbTDitkhhuV","170","0","0","1");
INSERT INTO dpeth VALUES("109","PrSyzhnpiNqfFGMMlftx","700","0","0","1");
INSERT INTO dpeth VALUES("110","AGrYqJnGaHXmxsKQicYN","850","0","0","1");
INSERT INTO dpeth VALUES("111","LZObULGyHAtWbHTdlSwh","500","0","0","1");
INSERT INTO dpeth VALUES("112","LZObULGyHAtWbHTdlSwh","500","0","0","1");
INSERT INTO dpeth VALUES("113","ogAFAHslvFOGabQgnUnH","1000","0","0","1");
INSERT INTO dpeth VALUES("114","NQaEhZafMWzjICrfsMZB","250","0","0","1");
INSERT INTO dpeth VALUES("115","jVdJxMGGlmturGbUmjfm","400","0","0","1");
INSERT INTO dpeth VALUES("116","YPsFEOAbvOTGmQSRZfuv","1000","0","0","1");
INSERT INTO dpeth VALUES("117","YPsFEOAbvOTGmQSRZfuv","1000","0","0","1");
INSERT INTO dpeth VALUES("118","KcPjIpQjsFonPxAyIyqf","785","0","0","1");
INSERT INTO dpeth VALUES("119","tWVMvrBjsuTJyoHXfzxr","420","0","0","1");
INSERT INTO dpeth VALUES("120","XosoFYeMJLUvoWfVvNcG","450","0","0","1");
INSERT INTO dpeth VALUES("121","HHrSkNmMlXuxkNuuiqTw","600","0","0","1");
INSERT INTO dpeth VALUES("122","WntHsflqUNtdqunYmVeR","450","0","0","1");
INSERT INTO dpeth VALUES("123","LAGjucyMgvIyNfFIAteQ","950","0","0","1");
INSERT INTO dpeth VALUES("124","WGjgLcLzgcPZfpVzxRsa","350","0","0","1");
INSERT INTO dpeth VALUES("125","paobQmmNnGudtTTPwtlC","450","0","0","1");
INSERT INTO dpeth VALUES("126","EzklpFtgYYhzwKPathMV","525","0","0","1");
INSERT INTO dpeth VALUES("127","gIIkEHnmuRDdEjdTYfrm","310","60","18600","1");
INSERT INTO dpeth VALUES("128","UHjaHZcXOQwLZWzbsGXa","450","0","0","1");
INSERT INTO dpeth VALUES("129","yuQyWiygSPNqprqPLBmI","450","0","0","1");
INSERT INTO dpeth VALUES("130","yobrYkfryqrtWtfKmNYb","890","0","0","1");
INSERT INTO dpeth VALUES("131","mIiIaYQjPgiWUTdNWKnn","470","0","0","1");
INSERT INTO dpeth VALUES("132","WOqgNyryTsjJOhezrVIw","450","0","0","1");
INSERT INTO dpeth VALUES("133","UFFxCypvYAyCRCeoGMjy","540","0","0","1");
INSERT INTO dpeth VALUES("134","HqvVVFMxjTFRAmKBoMWb","350","0","0","1");
INSERT INTO dpeth VALUES("135","BLkmbxevhXbtpDaMFVxG","770","0","0","1");
INSERT INTO dpeth VALUES("136","JLAChJbDfSmKVIzbhYYb","725","0","0","1");
INSERT INTO dpeth VALUES("137","RZRAPmUtHlQSpOTlEPss","900","0","0","1");
INSERT INTO dpeth VALUES("138","DdAGcJJOiFieBlMjryYa","250","0","0","1");
INSERT INTO dpeth VALUES("139","nixidcbpTVytXztoMJoV","950","0","0","1");
INSERT INTO dpeth VALUES("140","uoxhaXEvKvfBlRzyzYmS","815","0","0","1");
INSERT INTO dpeth VALUES("141","SWBfJyCSiMzIzUuAumtM","350","0","0","1");
INSERT INTO dpeth VALUES("142","HveCAKwEUgbYnYvCnSLg","350","0","0","1");
INSERT INTO dpeth VALUES("143","RvjXBihTjpNgIxEIeONw","610","0","0","1");
INSERT INTO dpeth VALUES("144","eTTfxAOrBKOnYStVZJbv","550","0","0","1");
INSERT INTO dpeth VALUES("145","hXWzNyxBOUojhJrIdBAF","400","0","0","1");
INSERT INTO dpeth VALUES("146","BykHRgTPYIIBdFuNcUBO","1000","0","0","1");
INSERT INTO dpeth VALUES("147","sexbCAFzXAyrkzTmlZNL","350","0","0","1");
INSERT INTO dpeth VALUES("148","UYcZtdXUptgXbtvNQBFh","270","0","0","1");
INSERT INTO dpeth VALUES("149","UUMndzaJmwghsWBXGoMi","885","0","0","1");
INSERT INTO dpeth VALUES("150","IfwENafDROQMqlkEJZpF","900","0","0","1");

CREATE TABLE `employee` (
  `eid` int(11) NOT NULL AUTO_INCREMENT,
  `jid` varchar(50) NOT NULL,
  `name` varchar(50) NOT NULL,
  `mob` varchar(50) NOT NULL,
  `adres` varchar(50) NOT NULL,
  `mid` int(11) NOT NULL,
  `sts` int(11) NOT NULL,
  PRIMARY KEY (`eid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE `extra` (
  `ids` int(11) NOT NULL AUTO_INCREMENT,
  `mid` int(11) NOT NULL,
  `date` varchar(50) NOT NULL,
  `mess` varchar(50) NOT NULL,
  `batta` varchar(50) NOT NULL,
  `extrabatta` varchar(50) NOT NULL,
  `chattioil` varchar(50) NOT NULL,
  `moteroil` varchar(50) NOT NULL,
  `sts` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`ids`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `extrasitem` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mid` int(11) NOT NULL,
  `fors` varchar(250) NOT NULL,
  `amount` varchar(150) NOT NULL,
  `dates` varchar(150) NOT NULL,
  `month` varchar(150) NOT NULL,
  `yer` varchar(150) NOT NULL,
  `sts` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `hammer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mid` int(11) NOT NULL,
  `hammer` varchar(150) NOT NULL,
  `nos` varchar(50) NOT NULL,
  `date` varchar(50) NOT NULL,
  `sts` int(11) DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `hmmer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `jid` varchar(150) NOT NULL,
  `hamer` varchar(50) NOT NULL,
  `fetage` varchar(50) NOT NULL,
  `mid` int(11) NOT NULL,
  `sts` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=96 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO hmmer VALUES("1","yIhZwhwCfYmfNHBVRZyf","","4305","1","1");
INSERT INTO hmmer VALUES("2","viPlrLGqhBaCFpkYCaDc","","4505","1","1");
INSERT INTO hmmer VALUES("3","jzHtIyVSBEBgCjoDPQXR","","0","1","1");
INSERT INTO hmmer VALUES("4","BwKFccwwoTtKUFnNpckx","","4815","1","1");
INSERT INTO hmmer VALUES("5","eFLFeIZIETXiRotxvIqx","","5330","1","1");
INSERT INTO hmmer VALUES("6","YWzVLVqexHyrUqbcGSyN","","0","1","1");
INSERT INTO hmmer VALUES("7","rNhDxKKKMxmyycrFwGdM","","5980","1","1");
INSERT INTO hmmer VALUES("8","ZEZerARHkebkKPJOlBiD","","6650","1","1");
INSERT INTO hmmer VALUES("9","UBjGnHHQNBlEkjYFuvGj","","6670","1","1");
INSERT INTO hmmer VALUES("10","xOFmUYaQreBHliIobDOM","","7155","1","1");
INSERT INTO hmmer VALUES("11","MMkfxCeYxVVQYQfFAZpp","","7840","1","1");
INSERT INTO hmmer VALUES("12","KFaKlshCzMKYTwxLCSvb","","7840","1","1");
INSERT INTO hmmer VALUES("13","NvkPRIXBfXpHegRGmoQO","","8334","1","1");
INSERT INTO hmmer VALUES("14","NiUMajzEPXewWYymsuNn","","8794","1","1");
INSERT INTO hmmer VALUES("15","OwCmezKNnoybyhKTxKCN","","9114","1","1");
INSERT INTO hmmer VALUES("16","XymrVnlMLTlcqjrPuTAN","","10094","1","1");
INSERT INTO hmmer VALUES("17","KsweJfxlgfUPQJgVnAkW","","10394","1","1");
INSERT INTO hmmer VALUES("18","bxbPvBcpXvXzufcXKSzm","","10649","1","1");
INSERT INTO hmmer VALUES("19","NHoSboDycMCBAKmEFjVk","","11189","1","1");
INSERT INTO hmmer VALUES("20","LLJEYJBciMcEwgaJBVEZ","","235","12","1");
INSERT INTO hmmer VALUES("21","JfNbaYBhaMAhvlVJokpk","","845","12","1");
INSERT INTO hmmer VALUES("22","zTFAJwBCsjouUwdPLDJf","","1045","12","1");
INSERT INTO hmmer VALUES("23","gjxwZjYdTkmODDcDRqVk","","1505","12","1");
INSERT INTO hmmer VALUES("24","SqYtTHPlHqEXMnYRoAEv","","2485","12","1");
INSERT INTO hmmer VALUES("25","iBCRKSZeLbqdXSDpDpoq","","2675","12","1");
INSERT INTO hmmer VALUES("26","lOfGWMrXnTChHFQmkPSd","","2850","12","1");
INSERT INTO hmmer VALUES("27","EzlYMGjFMvSWLDyhuYCc","","3225","12","1");
INSERT INTO hmmer VALUES("28","lmNtlSkGjObPYCmTIOfL","","3570","12","1");
INSERT INTO hmmer VALUES("29","zWAIkjrinHrPylsOLyKU","","3500","12","1");
INSERT INTO hmmer VALUES("30","etRLQigbsbJinjJozuIC","","3570","12","1");
INSERT INTO hmmer VALUES("31","OJUjEtfzJhYCvqHnsEUo","","4120","12","1");
INSERT INTO hmmer VALUES("32","fGfdVzkvEOWtftdRHsZE","","11609","1","1");
INSERT INTO hmmer VALUES("33","ihjDavaOiMppxTDeTprY","","894","1","1");
INSERT INTO hmmer VALUES("34","UsvnjOtQyiKGXvCEzaFC","","1053","1","1");
INSERT INTO hmmer VALUES("35","jeaskUrKrpUKKKYnanVT","","1613","1","1");
INSERT INTO hmmer VALUES("36","oghIwYpHRsBcqOfQJnZL","","1913","1","1");
INSERT INTO hmmer VALUES("37","sETFhlohzupvnhiKNDRn","","1947","1","1");
INSERT INTO hmmer VALUES("38","ldYwbJzugUkVLrmGqReg","","5140","12","1");
INSERT INTO hmmer VALUES("39","BtegyJVAaxWyTgmgvWwl","","2127","1","1");
INSERT INTO hmmer VALUES("40","sEMzRAYrYVEXkgoRkNml","","5545","12","1");
INSERT INTO hmmer VALUES("41","ZOxLdMxdIcyQlaMzYEMD","","2217","1","1");
INSERT INTO hmmer VALUES("42","zRGdietBeevwCXDQZHnn","","6065","12","1");
INSERT INTO hmmer VALUES("43","JZMUsEktgmghiACSvUNq","","6445","12","1");
INSERT INTO hmmer VALUES("44","fyTWTTLfoqzJbEQVsfhp","","6850","12","1");
INSERT INTO hmmer VALUES("45","rSaYXYOJvxSzJYTWMBle","","7290","12","1");
INSERT INTO hmmer VALUES("46","AtviTTORsExANYjTenqm","","7510","12","1");
INSERT INTO hmmer VALUES("47","kqMrimPPrYXyevRNTpQa","","8040","12","1");
INSERT INTO hmmer VALUES("48","ieIHUVqfofBSRsWjiuRA","","8780","12","1");
INSERT INTO hmmer VALUES("49","gOpOhMmjbXQrVYeLhRFI","","0","4","1");
INSERT INTO hmmer VALUES("50","UozTAgbAXXEwIwfIurXe","","0","4","1");
INSERT INTO hmmer VALUES("51","AlqKxJdQaHtkkcoLppqd","","800","4","1");
INSERT INTO hmmer VALUES("52","eUwzeFJoRTChYEzrwPmH","","1400","4","1");
INSERT INTO hmmer VALUES("53","ZoLpUFsXyQyqLWGtrlcN","","2400","4","1");
INSERT INTO hmmer VALUES("54","WMvdrlamRKbTDitkhhuV","","9500","4","1");
INSERT INTO hmmer VALUES("55","PrSyzhnpiNqfFGMMlftx","","10100","4","1");
INSERT INTO hmmer VALUES("56","AGrYqJnGaHXmxsKQicYN","","9610","12","1");
INSERT INTO hmmer VALUES("57","LZObULGyHAtWbHTdlSwh","","10800","4","1");
INSERT INTO hmmer VALUES("58","ogAFAHslvFOGabQgnUnH","","11800","4","1");
INSERT INTO hmmer VALUES("59","NQaEhZafMWzjICrfsMZB","","9800","12","1");
INSERT INTO hmmer VALUES("60","jVdJxMGGlmturGbUmjfm","","10180","12","1");
INSERT INTO hmmer VALUES("61","YPsFEOAbvOTGmQSRZfuv","","11760","4","1");
INSERT INTO hmmer VALUES("62","KcPjIpQjsFonPxAyIyqf","","12500","4","1");
INSERT INTO hmmer VALUES("63","tWVMvrBjsuTJyoHXfzxr","","10570","12","1");
INSERT INTO hmmer VALUES("64","XosoFYeMJLUvoWfVvNcG","","390","12","1");
INSERT INTO hmmer VALUES("65","HHrSkNmMlXuxkNuuiqTw","","570","4","1");
INSERT INTO hmmer VALUES("66","WntHsflqUNtdqunYmVeR","","989","4","1");
INSERT INTO hmmer VALUES("67","LAGjucyMgvIyNfFIAteQ","","1300","12","1");
INSERT INTO hmmer VALUES("68","WGjgLcLzgcPZfpVzxRsa","","1290","4","1");
INSERT INTO hmmer VALUES("69","paobQmmNnGudtTTPwtlC","","1690","12","1");
INSERT INTO hmmer VALUES("70","EzklpFtgYYhzwKPathMV","","1800","4","1");
INSERT INTO hmmer VALUES("71","gIIkEHnmuRDdEjdTYfrm","","0","4","1");
INSERT INTO hmmer VALUES("72","UHjaHZcXOQwLZWzbsGXa","","2190","4","1");
INSERT INTO hmmer VALUES("73","yuQyWiygSPNqprqPLBmI","","2490","4","1");
INSERT INTO hmmer VALUES("74","yobrYkfryqrtWtfKmNYb","","2460","12","1");
INSERT INTO hmmer VALUES("75","mIiIaYQjPgiWUTdNWKnn","","0","12","1");
INSERT INTO hmmer VALUES("76","WOqgNyryTsjJOhezrVIw","","2870","12","1");
INSERT INTO hmmer VALUES("77","UFFxCypvYAyCRCeoGMjy","","2940","4","1");
INSERT INTO hmmer VALUES("78","HqvVVFMxjTFRAmKBoMWb","","3250","4","1");
INSERT INTO hmmer VALUES("79","BLkmbxevhXbtpDaMFVxG","","3600","12","1");
INSERT INTO hmmer VALUES("80","JLAChJbDfSmKVIzbhYYb","","3925","4","1");
INSERT INTO hmmer VALUES("81","RZRAPmUtHlQSpOTlEPss","","4460","12","1");
INSERT INTO hmmer VALUES("82","DdAGcJJOiFieBlMjryYa","","4110","4","1");
INSERT INTO hmmer VALUES("83","nixidcbpTVytXztoMJoV","","5020","4","1");
INSERT INTO hmmer VALUES("84","uoxhaXEvKvfBlRzyzYmS","","5750","4","1");
INSERT INTO hmmer VALUES("85","UrvSIypOJkLUdAGOpggA","","0","4","1");
INSERT INTO hmmer VALUES("86","SWBfJyCSiMzIzUuAumtM","","4750","12","1");
INSERT INTO hmmer VALUES("87","HveCAKwEUgbYnYvCnSLg","","5070","12","1");
INSERT INTO hmmer VALUES("88","RvjXBihTjpNgIxEIeONw","","6340","4","1");
INSERT INTO hmmer VALUES("89","eTTfxAOrBKOnYStVZJbv","","5510","12","1");
INSERT INTO hmmer VALUES("90","hXWzNyxBOUojhJrIdBAF","","6600","4","1");
INSERT INTO hmmer VALUES("91","BykHRgTPYIIBdFuNcUBO","","7800","4","1");
INSERT INTO hmmer VALUES("92","sexbCAFzXAyrkzTmlZNL","","8150","4","1");
INSERT INTO hmmer VALUES("93","UYcZtdXUptgXbtvNQBFh","","8400","4","1");
INSERT INTO hmmer VALUES("94","UUMndzaJmwghsWBXGoMi","","6360","12","1");
INSERT INTO hmmer VALUES("95","IfwENafDROQMqlkEJZpF","","7230","12","1");

CREATE TABLE `jobentry` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `jobid` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `mchid` int(11) DEFAULT NULL,
  `dates` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `months` varchar(11) DEFAULT NULL,
  `year` varchar(11) DEFAULT NULL,
  `sts` int(11) DEFAULT NULL,
  `times` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=121 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO jobentry VALUES("1","guBKAGYaFnCCCQzmDTzg","0","05/07/2025","07","2025","1","");
INSERT INTO jobentry VALUES("2","GjbGUHXxaBuudouIOJjE","1","10/07/2025","07","2025","1","");
INSERT INTO jobentry VALUES("3","QgPOeQBQtkuhYXewcXdW","1","10/07/2025","07","2025","1","");
INSERT INTO jobentry VALUES("4","yIhZwhwCfYmfNHBVRZyf","1","11/07/2025","07","2025","2","");
INSERT INTO jobentry VALUES("5","viPlrLGqhBaCFpkYCaDc","1","12/07/2025","07","2025","2","");
INSERT INTO jobentry VALUES("6","LkYgxYhgYQaaNUOfaRzk","1","14/07/2025","07","2025","1","");
INSERT INTO jobentry VALUES("7","BysCxwgOMtZzABCVXKyI","0","15/07/2025","07","2025","1","");
INSERT INTO jobentry VALUES("8","jzHtIyVSBEBgCjoDPQXR","1","18/07/2025","07","2025","2","");
INSERT INTO jobentry VALUES("9","BwKFccwwoTtKUFnNpckx","1","19/07/2025","07","2025","2","");
INSERT INTO jobentry VALUES("10","eFLFeIZIETXiRotxvIqx","1","21/07/2025","07","2025","2","");
INSERT INTO jobentry VALUES("11","YWzVLVqexHyrUqbcGSyN","1","23/07/2025","07","2025","2","");
INSERT INTO jobentry VALUES("12","rNhDxKKKMxmyycrFwGdM","1","23/07/2025","07","2025","2","");
INSERT INTO jobentry VALUES("13","ZEZerARHkebkKPJOlBiD","1","26/07/2025","07","2025","2","");
INSERT INTO jobentry VALUES("14","UBjGnHHQNBlEkjYFuvGj","1","29/07/2025","07","2025","2","");
INSERT INTO jobentry VALUES("15","xOFmUYaQreBHliIobDOM","1","31/07/2025","07","2025","2","");
INSERT INTO jobentry VALUES("16","MMkfxCeYxVVQYQfFAZpp","1","01/08/2025","08","2025","2","");
INSERT INTO jobentry VALUES("17","KFaKlshCzMKYTwxLCSvb","1","02/08/2025","08","2025","2","");
INSERT INTO jobentry VALUES("18","NvkPRIXBfXpHegRGmoQO","1","04/08/2025","08","2025","2","");
INSERT INTO jobentry VALUES("19","YuPREuEfvHuynxwotjal","1","04/08/2025","08","2025","1","");
INSERT INTO jobentry VALUES("20","NiUMajzEPXewWYymsuNn","1","05/08/2025","08","2025","2","");
INSERT INTO jobentry VALUES("21","OwCmezKNnoybyhKTxKCN","1","10/08/2025","08","2025","2","");
INSERT INTO jobentry VALUES("22","XymrVnlMLTlcqjrPuTAN","1","11/08/2025","08","2025","2","");
INSERT INTO jobentry VALUES("23","KsweJfxlgfUPQJgVnAkW","1","13/08/2025","08","2025","2","");
INSERT INTO jobentry VALUES("24","bxbPvBcpXvXzufcXKSzm","1","20/08/2025","08","2025","2","");
INSERT INTO jobentry VALUES("25","NHoSboDycMCBAKmEFjVk","1","25/08/2025","08","2025","2","");
INSERT INTO jobentry VALUES("26","KvByffpfeZPdxQppbgXL","1","27/08/2025","08","2025","1","");
INSERT INTO jobentry VALUES("27","LLJEYJBciMcEwgaJBVEZ","12","29/08/2025","08","2025","2","");
INSERT INTO jobentry VALUES("28","RaOaMRNXRmsloEESLHjZ","12","30/08/2025","08","2025","1","");
INSERT INTO jobentry VALUES("29","JfNbaYBhaMAhvlVJokpk","12","31/08/2025","08","2025","2","");
INSERT INTO jobentry VALUES("30","zTFAJwBCsjouUwdPLDJf","12","01/09/2025","09","2025","2","");
INSERT INTO jobentry VALUES("31","gjxwZjYdTkmODDcDRqVk","12","03/09/2025","09","2025","2","");
INSERT INTO jobentry VALUES("32","SqYtTHPlHqEXMnYRoAEv","12","04/09/2025","09","2025","2","");
INSERT INTO jobentry VALUES("33","iBCRKSZeLbqdXSDpDpoq","12","08/09/2025","09","2025","2","");
INSERT INTO jobentry VALUES("34","lOfGWMrXnTChHFQmkPSd","12","08/09/2025","09","2025","2","");
INSERT INTO jobentry VALUES("35","EzlYMGjFMvSWLDyhuYCc","12","09/09/2025","09","2025","2","");
INSERT INTO jobentry VALUES("36","lmNtlSkGjObPYCmTIOfL","12","11/09/2025","09","2025","1","");
INSERT INTO jobentry VALUES("37","zWAIkjrinHrPylsOLyKU","12","11/09/2025","09","2025","2","");
INSERT INTO jobentry VALUES("38","etRLQigbsbJinjJozuIC","12","11/09/2025","09","2025","2","");
INSERT INTO jobentry VALUES("39","OJUjEtfzJhYCvqHnsEUo","12","12/09/2025","09","2025","2","");
INSERT INTO jobentry VALUES("40","sDUtwEAIxZQpCgavKoYT","1","12/09/2025","09","2025","1","");
INSERT INTO jobentry VALUES("41","hrzywLrvWIRTdyoPyxRs","1","12/09/2025","09","2025","1","");
INSERT INTO jobentry VALUES("42","fGfdVzkvEOWtftdRHsZE","1","12/09/2025","09","2025","2","");
INSERT INTO jobentry VALUES("43","ihjDavaOiMppxTDeTprY","1","12/09/2025","09","2025","2","");
INSERT INTO jobentry VALUES("44","UsvnjOtQyiKGXvCEzaFC","1","12/09/2025","09","2025","2","");
INSERT INTO jobentry VALUES("45","jeaskUrKrpUKKKYnanVT","1","12/09/2025","09","2025","2","");
INSERT INTO jobentry VALUES("46","oghIwYpHRsBcqOfQJnZL","1","12/09/2025","09","2025","2","");
INSERT INTO jobentry VALUES("47","sETFhlohzupvnhiKNDRn","1","12/09/2025","09","2025","2","");
INSERT INTO jobentry VALUES("48","ldYwbJzugUkVLrmGqReg","12","13/09/2025","09","2025","2","");
INSERT INTO jobentry VALUES("49","BtegyJVAaxWyTgmgvWwl","1","13/09/2025","09","2025","2","");
INSERT INTO jobentry VALUES("50","sEMzRAYrYVEXkgoRkNml","12","13/09/2025","09","2025","2","");
INSERT INTO jobentry VALUES("51","ZOxLdMxdIcyQlaMzYEMD","1","14/09/2025","09","2025","2","");
INSERT INTO jobentry VALUES("52","zRGdietBeevwCXDQZHnn","12","15/09/2025","09","2025","2","");
INSERT INTO jobentry VALUES("53","JZMUsEktgmghiACSvUNq","12","15/09/2025","09","2025","2","");
INSERT INTO jobentry VALUES("54","fyTWTTLfoqzJbEQVsfhp","12","15/09/2025","09","2025","2","");
INSERT INTO jobentry VALUES("55","rSaYXYOJvxSzJYTWMBle","12","16/09/2025","09","2025","2","");
INSERT INTO jobentry VALUES("56","AtviTTORsExANYjTenqm","12","16/09/2025","09","2025","2","");
INSERT INTO jobentry VALUES("57","kqMrimPPrYXyevRNTpQa","12","17/09/2025","09","2025","2","");
INSERT INTO jobentry VALUES("58","ieIHUVqfofBSRsWjiuRA","12","19/09/2025","09","2025","2","");
INSERT INTO jobentry VALUES("59","gOpOhMmjbXQrVYeLhRFI","4","19/09/2025","09","2025","2","");
INSERT INTO jobentry VALUES("60","UozTAgbAXXEwIwfIurXe","4","19/09/2025","09","2025","2","");
INSERT INTO jobentry VALUES("61","hUpEulgXgbpOXIeVFIoW","4","19/09/2025","09","2025","1","");
INSERT INTO jobentry VALUES("62","AlqKxJdQaHtkkcoLppqd","4","19/09/2025","09","2025","2","");
INSERT INTO jobentry VALUES("63","eUwzeFJoRTChYEzrwPmH","4","19/09/2025","09","2025","2","");
INSERT INTO jobentry VALUES("64","ZoLpUFsXyQyqLWGtrlcN","4","19/09/2025","09","2025","2","");
INSERT INTO jobentry VALUES("65","WMvdrlamRKbTDitkhhuV","4","20/09/2025","09","2025","2","");
INSERT INTO jobentry VALUES("66","PrSyzhnpiNqfFGMMlftx","4","20/09/2025","09","2025","2","");
INSERT INTO jobentry VALUES("67","UURtUkTYLTmvxhOJegUS","12","20/09/2025","09","2025","1","");
INSERT INTO jobentry VALUES("68","AGrYqJnGaHXmxsKQicYN","12","20/09/2025","09","2025","2","");
INSERT INTO jobentry VALUES("69","LZObULGyHAtWbHTdlSwh","4","22/09/2025","09","2025","2","");
INSERT INTO jobentry VALUES("70","JwMEjtqRGOBVOHmzjTpx","4","22/09/2025","09","2025","1","");
INSERT INTO jobentry VALUES("71","ogAFAHslvFOGabQgnUnH","4","22/09/2025","09","2025","2","");
INSERT INTO jobentry VALUES("72","NQaEhZafMWzjICrfsMZB","12","22/09/2025","09","2025","2","");
INSERT INTO jobentry VALUES("73","jVdJxMGGlmturGbUmjfm","12","23/09/2025","09","2025","2","");
INSERT INTO jobentry VALUES("74","REzrWWidsERfYDLQZpJq","4","23/09/2025","09","2025","1","");
INSERT INTO jobentry VALUES("75","cyuHldECYsnAstcEzGmN","4","23/09/2025","09","2025","1","");
INSERT INTO jobentry VALUES("76","NSgKeztyQtFHPpASmTWS","4","23/09/2025","09","2025","1","");
INSERT INTO jobentry VALUES("77","YPsFEOAbvOTGmQSRZfuv","4","24/09/2025","09","2025","2","");
INSERT INTO jobentry VALUES("78","KcPjIpQjsFonPxAyIyqf","4","26/09/2025","09","2025","2","");
INSERT INTO jobentry VALUES("79","tWVMvrBjsuTJyoHXfzxr","12","26/09/2025","09","2025","2","");
INSERT INTO jobentry VALUES("80","XosoFYeMJLUvoWfVvNcG","12","03/10/2025","10","2025","2","");
INSERT INTO jobentry VALUES("81","HHrSkNmMlXuxkNuuiqTw","4","03/10/2025","10","2025","2","");
INSERT INTO jobentry VALUES("82","WntHsflqUNtdqunYmVeR","4","04/10/2025","10","2025","2","");
INSERT INTO jobentry VALUES("83","LAGjucyMgvIyNfFIAteQ","12","06/10/2025","10","2025","2","");
INSERT INTO jobentry VALUES("84","WGjgLcLzgcPZfpVzxRsa","4","06/10/2025","10","2025","2","");
INSERT INTO jobentry VALUES("85","paobQmmNnGudtTTPwtlC","12","07/10/2025","10","2025","2","");
INSERT INTO jobentry VALUES("86","EzklpFtgYYhzwKPathMV","4","08/10/2025","10","2025","2","");
INSERT INTO jobentry VALUES("87","gIIkEHnmuRDdEjdTYfrm","4","08/10/2025","10","2025","2","");
INSERT INTO jobentry VALUES("88","UHjaHZcXOQwLZWzbsGXa","4","09/10/2025","10","2025","2","");
INSERT INTO jobentry VALUES("89","yuQyWiygSPNqprqPLBmI","4","10/10/2025","10","2025","2","");
INSERT INTO jobentry VALUES("90","yobrYkfryqrtWtfKmNYb","12","10/10/2025","10","2025","2","");
INSERT INTO jobentry VALUES("91","mIiIaYQjPgiWUTdNWKnn","12","11/10/2025","10","2025","2","");
INSERT INTO jobentry VALUES("92","RgypHJOASWexlAxLdbWS","12","11/10/2025","10","2025","1","");
INSERT INTO jobentry VALUES("93","WOqgNyryTsjJOhezrVIw","12","11/10/2025","10","2025","2","");
INSERT INTO jobentry VALUES("94","UFFxCypvYAyCRCeoGMjy","4","11/10/2025","10","2025","2","");
INSERT INTO jobentry VALUES("95","sghQYvgjJkFoCfBxZcQx","4","12/10/2025","10","2025","1","");
INSERT INTO jobentry VALUES("96","HqvVVFMxjTFRAmKBoMWb","4","12/10/2025","10","2025","2","");
INSERT INTO jobentry VALUES("97","BLkmbxevhXbtpDaMFVxG","12","14/10/2025","10","2025","2","");
INSERT INTO jobentry VALUES("98","QAAAPeuoYBVAUdWASIUB","4","15/10/2025","10","2025","1","");
INSERT INTO jobentry VALUES("99","JLAChJbDfSmKVIzbhYYb","4","15/10/2025","10","2025","2","");
INSERT INTO jobentry VALUES("100","RZRAPmUtHlQSpOTlEPss","12","16/10/2025","10","2025","2","");
INSERT INTO jobentry VALUES("101","DdAGcJJOiFieBlMjryYa","4","18/10/2025","10","2025","2","");
INSERT INTO jobentry VALUES("102","qWnhOdPfAuzdtvOIIdmO","4","19/10/2025","10","2025","1","");
INSERT INTO jobentry VALUES("103","nixidcbpTVytXztoMJoV","4","19/10/2025","10","2025","2","");
INSERT INTO jobentry VALUES("104","uoxhaXEvKvfBlRzyzYmS","4","24/10/2025","10","2025","2","");
INSERT INTO jobentry VALUES("105","UrvSIypOJkLUdAGOpggA","4","24/10/2025","10","2025","2","");
INSERT INTO jobentry VALUES("106","XtxCewNyHinUWfpONYjk","4","24/10/2025","10","2025","1","");
INSERT INTO jobentry VALUES("107","SWBfJyCSiMzIzUuAumtM","12","25/10/2025","10","2025","2","");
INSERT INTO jobentry VALUES("108","HveCAKwEUgbYnYvCnSLg","12","25/10/2025","10","2025","2","");
INSERT INTO jobentry VALUES("109","RvjXBihTjpNgIxEIeONw","4","25/10/2025","10","2025","2","");
INSERT INTO jobentry VALUES("110","eTTfxAOrBKOnYStVZJbv","12","27/10/2025","10","2025","2","");
INSERT INTO jobentry VALUES("111","hXWzNyxBOUojhJrIdBAF","4","27/10/2025","10","2025","2","");
INSERT INTO jobentry VALUES("112","FZksOHfQGPUFghDgWnan","4","28/10/2025","10","2025","1","");
INSERT INTO jobentry VALUES("113","FLMPGwQHqwYMOnBQgBRC","4","28/10/2025","10","2025","1","");
INSERT INTO jobentry VALUES("114","BykHRgTPYIIBdFuNcUBO","4","01/11/2025","11","2025","2","");
INSERT INTO jobentry VALUES("115","wRNMyBvZgIQEIwoHMqaA","4","02/11/2025","11","2025","1","");
INSERT INTO jobentry VALUES("116","sexbCAFzXAyrkzTmlZNL","4","02/11/2025","11","2025","2","");
INSERT INTO jobentry VALUES("117","UYcZtdXUptgXbtvNQBFh","4","02/11/2025","11","2025","2","");
INSERT INTO jobentry VALUES("118","VIhBSIsjQETAuKCSfiFp","12","02/11/2025","11","2025","1","");
INSERT INTO jobentry VALUES("119","UUMndzaJmwghsWBXGoMi","12","02/11/2025","11","2025","2","");
INSERT INTO jobentry VALUES("120","IfwENafDROQMqlkEJZpF","12","02/11/2025","11","2025","2","");

CREATE TABLE `jobmain` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `jid` varchar(100) NOT NULL,
  `agency` varchar(100) NOT NULL,
  `workno` varchar(100) NOT NULL,
  `depth` varchar(100) NOT NULL,
  `pipone` varchar(10) DEFAULT NULL,
  `piptow` varchar(10) DEFAULT NULL,
  `piptree` varchar(10) DEFAULT NULL,
  `dates` varchar(100) NOT NULL,
  `sts` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=98 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO jobmain VALUES("1","yIhZwhwCfYmfNHBVRZyf","Biju ","1","700","80","","","2025-07-10","1");
INSERT INTO jobmain VALUES("2","viPlrLGqhBaCFpkYCaDc","Bobby ","2","280","80","","","2025-07-11","1");
INSERT INTO jobmain VALUES("3","jzHtIyVSBEBgCjoDPQXR","Sububiar gas","3","70","0","18","4","2025-07-16","1");
INSERT INTO jobmain VALUES("4","BwKFccwwoTtKUFnNpckx","Bobby ","4","390","80","12","","2025-07-19","1");
INSERT INTO jobmain VALUES("5","eFLFeIZIETXiRotxvIqx","Biju ","5","600","85","","","2025-07-20","1");
INSERT INTO jobmain VALUES("6","YWzVLVqexHyrUqbcGSyN","Old scrapped ","6","0","0","0","0","2025-07-21","1");
INSERT INTO jobmain VALUES("7","rNhDxKKKMxmyycrFwGdM","Madhu ","7","660","100","","","2025-07-22","1");
INSERT INTO jobmain VALUES("8","ZEZerARHkebkKPJOlBiD","Siju ","8","800","40","","","2025-07-24","1");
INSERT INTO jobmain VALUES("9","UBjGnHHQNBlEkjYFuvGj","Siju","9","200","80","20","","2025-07-28","1");
INSERT INTO jobmain VALUES("10","xOFmUYaQreBHliIobDOM","Bobby ","10","425","40","","","2025-07-30","1");
INSERT INTO jobmain VALUES("11","MMkfxCeYxVVQYQfFAZpp","Siju ","11","740","35","","","02-08-2025","1");
INSERT INTO jobmain VALUES("12","KFaKlshCzMKYTwxLCSvb","Siju ","12","700","0","0","0","2025-08-02","1");
INSERT INTO jobmain VALUES("13","NvkPRIXBfXpHegRGmoQO","Siju ","13","635","141","21","","2025-08-03","1");
INSERT INTO jobmain VALUES("14","NiUMajzEPXewWYymsuNn","Biju ","14","450","40","","","2025-08-05","1");
INSERT INTO jobmain VALUES("15","OwCmezKNnoybyhKTxKCN","Bobby ","15","360","40","15","","2025-08-09","1");
INSERT INTO jobmain VALUES("16","XymrVnlMLTlcqjrPuTAN","Siju ","16","1000","20","","","2025-08-10","1");
INSERT INTO jobmain VALUES("17","KsweJfxlgfUPQJgVnAkW","Bobby ","17","320","21","","","2025-08-12","1");
INSERT INTO jobmain VALUES("18","bxbPvBcpXvXzufcXKSzm","Biju ","18","285","30","","","2025-08-20","1");
INSERT INTO jobmain VALUES("19","NHoSboDycMCBAKmEFjVk","Biju ","19","600","40","","","2025-08-24","1");
INSERT INTO jobmain VALUES("20","LLJEYJBciMcEwgaJBVEZ","Siju office","1","255","20","","","2025-08-29","1");
INSERT INTO jobmain VALUES("21","JfNbaYBhaMAhvlVJokpk","Boby office","2","630","20","","","2025-08-30","1");
INSERT INTO jobmain VALUES("22","zTFAJwBCsjouUwdPLDJf","Bobin office","3","230","30","","","2025-09-01","1");
INSERT INTO jobmain VALUES("23","gjxwZjYdTkmODDcDRqVk","Biju offoce","4","500","40","13","","2025-09-03","1");
INSERT INTO jobmain VALUES("24","SqYtTHPlHqEXMnYRoAEv","Office bobin","5","1000","20","","","2025-09-03","1");
INSERT INTO jobmain VALUES("25","iBCRKSZeLbqdXSDpDpoq","Alex ( siju)","6","250","60","12","","2025-09-07","1");
INSERT INTO jobmain VALUES("26","lOfGWMrXnTChHFQmkPSd","Madhu (boby)","7","255","80","","","2025-09-08","1");
INSERT INTO jobmain VALUES("27","EzlYMGjFMvSWLDyhuYCc","Madhu (bobin)","8","395","20","","","2025-09-09","1");
INSERT INTO jobmain VALUES("28","lmNtlSkGjObPYCmTIOfL","Office (siju)","9","200","105","","","2025-09-11","1");
INSERT INTO jobmain VALUES("29","zWAIkjrinHrPylsOLyKU","Office (siju)","9","295","20","","","2025-09-11","1");
INSERT INTO jobmain VALUES("30","etRLQigbsbJinjJozuIC","Siju(office)","10","200","105","","","2025-09-10","1");
INSERT INTO jobmain VALUES("31","OJUjEtfzJhYCvqHnsEUo"," Office (bobin)","11","600","48","","","2025-09-11","1");
INSERT INTO jobmain VALUES("32","hrzywLrvWIRTdyoPyxRs","Biju ","20","480","60","14","","2025-09-04","1");
INSERT INTO jobmain VALUES("33","fGfdVzkvEOWtftdRHsZE","Biju ","20","480","60","14","","2025-09-04","1");
INSERT INTO jobmain VALUES("34","ihjDavaOiMppxTDeTprY","Bobby ","21","1000","106","12","","2025-09-06","1");
INSERT INTO jobmain VALUES("35","UsvnjOtQyiKGXvCEzaFC","Girish ","22","200","41","","","2025-09-09","1");
INSERT INTO jobmain VALUES("36","jeaskUrKrpUKKKYnanVT","Nabeen","23","600","40","","","2025-09-10","1");
INSERT INTO jobmain VALUES("37","oghIwYpHRsBcqOfQJnZL","Bobby ","24","440","140","","","2025-09-11","1");
INSERT INTO jobmain VALUES("38","sETFhlohzupvnhiKNDRn","Bobby ","25","290","256","","","2025-09-12","1");
INSERT INTO jobmain VALUES("39","ldYwbJzugUkVLrmGqReg","Office biju","12","1040","20","","","2025-09-12","1");
INSERT INTO jobmain VALUES("40","BtegyJVAaxWyTgmgvWwl","Bobby ","26","200","20","","","2025-09-13","1");
INSERT INTO jobmain VALUES("41","sEMzRAYrYVEXkgoRkNml","Office siju","13","465","60","","","2025-09-13","1");
INSERT INTO jobmain VALUES("42","ZOxLdMxdIcyQlaMzYEMD","Tiju","27","195","100","18","","2025-09-14","1");
INSERT INTO jobmain VALUES("43","zRGdietBeevwCXDQZHnn","Office siju","14","600","80","","","2025-09-14","1");
INSERT INTO jobmain VALUES("44","JZMUsEktgmghiACSvUNq","Office siju","15","465","60","","","2025-09-14","1");
INSERT INTO jobmain VALUES("45","fyTWTTLfoqzJbEQVsfhp","Office siju","16","450","46","","","2025-09-15","1");
INSERT INTO jobmain VALUES("46","rSaYXYOJvxSzJYTWMBle","Office biju","17","500","60","","","2025-09-15","1");
INSERT INTO jobmain VALUES("47","AtviTTORsExANYjTenqm","Office siju","18","300","25","","","2025-09-16","1");
INSERT INTO jobmain VALUES("48","kqMrimPPrYXyevRNTpQa","Ullas ( siju)","19","550","20","","","2025-09-16","1");
INSERT INTO jobmain VALUES("49","ieIHUVqfofBSRsWjiuRA","Akex (boby)","20","810","69","","","2025-09-18","1");
INSERT INTO jobmain VALUES("50","gOpOhMmjbXQrVYeLhRFI","Siju","1","845","40","","","2025-09-13","1");
INSERT INTO jobmain VALUES("51","UozTAgbAXXEwIwfIurXe","Siju","2","800","40","","","2025-09-19","1");
INSERT INTO jobmain VALUES("52","hUpEulgXgbpOXIeVFIoW","Tiju","3","120","0","","","2025-09-19","1");
INSERT INTO jobmain VALUES("53","AlqKxJdQaHtkkcoLppqd","Tiju","3","120","0","","","2025-09-19","1");
INSERT INTO jobmain VALUES("54","eUwzeFJoRTChYEzrwPmH","Siju","4","600","60","","","2025-09-19","1");
INSERT INTO jobmain VALUES("55","ZoLpUFsXyQyqLWGtrlcN","Siju","5","550","16","40","","2025-09-19","1");
INSERT INTO jobmain VALUES("56","WMvdrlamRKbTDitkhhuV","Biju","6","170","20","","","2025-09-20","1");
INSERT INTO jobmain VALUES("57","PrSyzhnpiNqfFGMMlftx","Alax","7","700","20","","","2025-09-20","1");
INSERT INTO jobmain VALUES("58","AGrYqJnGaHXmxsKQicYN","Alex(boby","21","850","20","","","2025-09-20","1");
INSERT INTO jobmain VALUES("59","LZObULGyHAtWbHTdlSwh","Bobin","8","500","60","","","2025-09-22","1");
INSERT INTO jobmain VALUES("60","ogAFAHslvFOGabQgnUnH","Anub","9","1000","40","","","2025-09-22","1");
INSERT INTO jobmain VALUES("61","NQaEhZafMWzjICrfsMZB","Ullas (siju)","22","250","48","13.5","","2025-09-22","1");
INSERT INTO jobmain VALUES("62","jVdJxMGGlmturGbUmjfm","Office siju","23","400","30","","","2025-09-23","1");
INSERT INTO jobmain VALUES("63","YPsFEOAbvOTGmQSRZfuv","Anub","10","1000","40","","","2025-09-24","1");
INSERT INTO jobmain VALUES("64","KcPjIpQjsFonPxAyIyqf","Tiju","11","785","100","","","2025-09-26","1");
INSERT INTO jobmain VALUES("65","tWVMvrBjsuTJyoHXfzxr","Madhu( boby)","24","420","30","","","2025-09-26","1");
INSERT INTO jobmain VALUES("66","XosoFYeMJLUvoWfVvNcG","Office biju","25","450","60","","","2025-10-02","1");
INSERT INTO jobmain VALUES("67","HHrSkNmMlXuxkNuuiqTw","Madhu","12","600","30","","","2025-10-03","1");
INSERT INTO jobmain VALUES("68","WntHsflqUNtdqunYmVeR","Siju","13","450","31","","","2025-10-04","1");
INSERT INTO jobmain VALUES("69","LAGjucyMgvIyNfFIAteQ","Alex siju","26","950","40","","","2025-10-05","1");
INSERT INTO jobmain VALUES("70","WGjgLcLzgcPZfpVzxRsa","Siju","14","350","40","","","2025-10-06","1");
INSERT INTO jobmain VALUES("71","paobQmmNnGudtTTPwtlC","Office boby","27","450","60","","","2025-10-07","1");
INSERT INTO jobmain VALUES("72","EzklpFtgYYhzwKPathMV","Biju","15","525","38","","","2025-10-08","1");
INSERT INTO jobmain VALUES("73","gIIkEHnmuRDdEjdTYfrm","Biju","16","310","3","","","2025-10-08","1");
INSERT INTO jobmain VALUES("74","UHjaHZcXOQwLZWzbsGXa","Biju","17","450","60","","","2025-10-09","1");
INSERT INTO jobmain VALUES("75","yuQyWiygSPNqprqPLBmI","Biju","18","450","24","62","","2025-10-10","1");
INSERT INTO jobmain VALUES("76","yobrYkfryqrtWtfKmNYb","Office boby","28","890","120","","","2025-10-10","1");
INSERT INTO jobmain VALUES("77","mIiIaYQjPgiWUTdNWKnn","Office boby","29","470","0","","","2025-10-10","1");
INSERT INTO jobmain VALUES("78","WOqgNyryTsjJOhezrVIw","Office boby","30","450","40","","","2025-10-11","1");
INSERT INTO jobmain VALUES("79","UFFxCypvYAyCRCeoGMjy","Boju","19","540","31","80","","2025-10-11","1");
INSERT INTO jobmain VALUES("80","HqvVVFMxjTFRAmKBoMWb","Bobin","20","350","45","11","","2025-10-13","1");
INSERT INTO jobmain VALUES("81","BLkmbxevhXbtpDaMFVxG","Office boby","31","770","40","","","2025-10-13","1");
INSERT INTO jobmain VALUES("82","JLAChJbDfSmKVIzbhYYb","Biju","21","725","55","","","2025-10-15","1");
INSERT INTO jobmain VALUES("83","RZRAPmUtHlQSpOTlEPss","Office boby","32","900","40","","","2025-10-15","1");
INSERT INTO jobmain VALUES("84","DdAGcJJOiFieBlMjryYa","Biju","22","250","40","","","2025-10-18","1");
INSERT INTO jobmain VALUES("85","nixidcbpTVytXztoMJoV","Biju","23","950","40","","","2025-10-19","1");
INSERT INTO jobmain VALUES("86","uoxhaXEvKvfBlRzyzYmS","Madhu","24","815","60","","","2025-10-24","1");
INSERT INTO jobmain VALUES("87","UrvSIypOJkLUdAGOpggA","Old.scarape","25","0","0","","","2025-10-24","1");
INSERT INTO jobmain VALUES("88","SWBfJyCSiMzIzUuAumtM","Madhu","33","350","60","","","2025-10-24","1");
INSERT INTO jobmain VALUES("89","HveCAKwEUgbYnYvCnSLg","Office boby","34","350","30","","","2025-10-24","1");
INSERT INTO jobmain VALUES("90","RvjXBihTjpNgIxEIeONw","Bobin","26","610","20","","","2025-10-25","1");
INSERT INTO jobmain VALUES("91","eTTfxAOrBKOnYStVZJbv","Manoj (siju)","35","550","111","","","2025-10-26","1");
INSERT INTO jobmain VALUES("92","hXWzNyxBOUojhJrIdBAF","Ullas","27","400","60","","","2025-10-27","1");
INSERT INTO jobmain VALUES("93","BykHRgTPYIIBdFuNcUBO","Biju","28","1000","90","","","2025-11-01","1");
INSERT INTO jobmain VALUES("94","sexbCAFzXAyrkzTmlZNL","Siju","29","350","30","","","2025-11-02","1");
INSERT INTO jobmain VALUES("95","UYcZtdXUptgXbtvNQBFh","Boju","30","270","40","20","","2025-11-02","1");
INSERT INTO jobmain VALUES("96","UUMndzaJmwghsWBXGoMi","Office boby","36","885","30","","","2025-11-01","1");
INSERT INTO jobmain VALUES("97","IfwENafDROQMqlkEJZpF","Office boby","37","900","30","","","2025-11-02","1");

CREATE TABLE `machine` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(250) NOT NULL,
  `mid` varchar(250) NOT NULL,
  `status` int(11) NOT NULL,
  `starttime` varchar(50) NOT NULL,
  `endtime` varchar(50) NOT NULL,
  `sts` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO machine VALUES("1","Volvo","JB-3168","1","08:00","23:00","1");
INSERT INTO machine VALUES("2","KM","MK4343","0","09:00","18:30","1");
INSERT INTO machine VALUES("3","Volvo","JB-3168","0","08:00","18:00","1");
INSERT INTO machine VALUES("4","DOOSAN ","JB-4662","1","07:00","20:00","1");
INSERT INTO machine VALUES("5","LG ","JB-5168","1","07:00","20:00","1");
INSERT INTO machine VALUES("6","JPR","N--JP","0","09:30","18:00","1");
INSERT INTO machine VALUES("7","JPR","N-JPR","1","09:30","18:00","1");
INSERT INTO machine VALUES("8","SJPR","S-JPR","1","08:00","22:00","1");
INSERT INTO machine VALUES("9","AIRWELLS","A-101","1","06:00","23:00","1");
INSERT INTO machine VALUES("10","JPR","AIRWELLS","1","06:00","23:00","1");
INSERT INTO machine VALUES("11","JPR","AIRWELL","1","06:00","23:00","1");
INSERT INTO machine VALUES("12","BOBCAT","BOBCAT","1","06:00","23:00","1");

CREATE TABLE `maintenance` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mid` int(11) NOT NULL,
  `date` varchar(50) NOT NULL,
  `workshop` varchar(1000) NOT NULL,
  `vno` varchar(50) NOT NULL,
  `complaint` varchar(1000) NOT NULL,
  `billno` varchar(50) NOT NULL,
  `amount` varchar(50) NOT NULL,
  `sts` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `moteon` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `jid` varchar(100) NOT NULL,
  `name` varchar(100) NOT NULL,
  `invoiceno` varchar(100) NOT NULL,
  `amount` varchar(100) NOT NULL,
  `sts` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `parts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `items` varchar(150) NOT NULL,
  `sts` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `partsentry` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mid` int(11) NOT NULL,
  `part` int(11) NOT NULL,
  `qty` int(11) NOT NULL,
  `dates` text NOT NULL,
  `sts` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `partsmachne` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mid` int(11) NOT NULL,
  `partid` int(11) NOT NULL,
  `qty` int(11) NOT NULL,
  `sts` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `partsuse` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mid` int(11) NOT NULL,
  `partid` int(11) NOT NULL,
  `used` varchar(150) NOT NULL,
  `date` varchar(150) NOT NULL,
  `mnth` int(11) NOT NULL,
  `yer` int(11) NOT NULL,
  `sts` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `payments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `jid` varchar(400) DEFAULT NULL,
  `dates` varchar(50) DEFAULT NULL,
  `amounts` varchar(100) DEFAULT NULL,
  `dis` varchar(500) NOT NULL,
  `pids` int(11) DEFAULT 0,
  `sts` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `pipes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pip` varchar(500) NOT NULL,
  `sts` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE `pipuse` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `jobid` varchar(500) NOT NULL,
  `pip` varchar(50) NOT NULL,
  `usrate` varchar(50) NOT NULL,
  `rate` varchar(50) NOT NULL,
  `amt` varchar(300) NOT NULL,
  `sts` int(11) NOT NULL,
  `mid` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE `ponitlogin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `loginid` varchar(150) NOT NULL,
  `passcode` varchar(150) NOT NULL,
  `sts` int(11) NOT NULL,
  `permision` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO ponitlogin VALUES("1","10001","jd2024","1","1");

CREATE TABLE `pvcstock` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mid` int(11) NOT NULL,
  `pvc` varchar(100) NOT NULL,
  `stock` varchar(100) NOT NULL,
  `sts` int(11) DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `quatation` (
  `ids` int(11) NOT NULL AUTO_INCREMENT,
  `qid` varchar(1000) DEFAULT NULL,
  `exid` int(11) NOT NULL,
  `sts` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`ids`)
) ENGINE=InnoDB AUTO_INCREMENT=303 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO quatation VALUES("1","Lxt0fg8mjOJEhmERexbS","0","1");
INSERT INTO quatation VALUES("2","ioqPfFh00rYuzAvCv0ER","0","1");
INSERT INTO quatation VALUES("3","7pYK2nqIXtSdFWzYAoNg","0","1");
INSERT INTO quatation VALUES("4","xLniUdzUlSpMnKoQ147C","0","1");
INSERT INTO quatation VALUES("5","2gaZQEXSAL42VWbLGYYn","0","1");
INSERT INTO quatation VALUES("6","YTaZPBVBnnxrlYPiLM9L","0","1");
INSERT INTO quatation VALUES("7","28WoVWdfRahr9XVaV4zV","0","1");
INSERT INTO quatation VALUES("8","zQFrEOrRB6jfyaoJdjUK","0","1");
INSERT INTO quatation VALUES("9","UZ2gEsGrBe9RWTYFwlVM","0","1");
INSERT INTO quatation VALUES("10","xZlsMDw98YwClM0FGStz","0","1");
INSERT INTO quatation VALUES("11","3V4gk9pnAMoWLmEE1un3","0","1");
INSERT INTO quatation VALUES("12","Qcmqubq4ZQHhYIJVUgkD","0","1");
INSERT INTO quatation VALUES("13","9QJhcSIHNYRe1y2bTxt4","0","1");
INSERT INTO quatation VALUES("14","uLtkRO6ibvpUdhFcpTYQ","0","1");
INSERT INTO quatation VALUES("15","Gn1hmHSrKseVM3VzuV3O","0","1");
INSERT INTO quatation VALUES("16","Uzdd3hCrjQw6UybO19fp","0","1");
INSERT INTO quatation VALUES("17","6TVeyrJCOg9RudX1NtTT","0","1");
INSERT INTO quatation VALUES("18","eRFpvLami8wFjCO0USUa","0","1");
INSERT INTO quatation VALUES("19","ZX2hy3ibJvTv6lqruvs4","0","1");
INSERT INTO quatation VALUES("20","f8H7WxqT4tPY2G9Kr7CJ","0","1");
INSERT INTO quatation VALUES("21","MTreF5ftnvswq3l8WIKO","0","1");
INSERT INTO quatation VALUES("22","SKMAVhu5CMybLDyt49cL","0","1");
INSERT INTO quatation VALUES("23","2Wm2kk2i7BWZghmy1JYe","0","1");
INSERT INTO quatation VALUES("24","HPRigNhYO5FHCxtk9F2D","0","1");
INSERT INTO quatation VALUES("25","0ADkNwMgrOso4h9FdIyl","0","1");
INSERT INTO quatation VALUES("26","iTZqoY2X3n6wJEDR7urS","0","1");
INSERT INTO quatation VALUES("27","ejIwUZJ7LyAoGypJKiLI","0","1");
INSERT INTO quatation VALUES("28","Kv28k3zRAyEN16HiBL9y","0","1");
INSERT INTO quatation VALUES("29","fVnQFhL2WTbw7OXa1hsw","0","1");
INSERT INTO quatation VALUES("30","PVtOv9zXrRfnCOZPNNcB","0","1");
INSERT INTO quatation VALUES("31","Mv60hyOMmCmyAb4zxhow","0","1");
INSERT INTO quatation VALUES("32","uOBtyWSCoOcYu3JZiT2C","0","1");
INSERT INTO quatation VALUES("33","mNwQRQMboZ58VXSAPVqk","0","1");
INSERT INTO quatation VALUES("34","DQ2UCRkuw54UO2EgW2DJ","0","1");
INSERT INTO quatation VALUES("35","WDTUY13CSvrbjMJ5HENI","0","1");
INSERT INTO quatation VALUES("36","o1PFAyPERwM6ODjO3WOs","0","1");
INSERT INTO quatation VALUES("37","e7GAmxI3wPSyPzMKfhMP","0","1");
INSERT INTO quatation VALUES("38","j1NMre6h0tJRDbQcVj3D","0","1");
INSERT INTO quatation VALUES("39","rEg5DygQ0qBWwPuk96nu","0","1");
INSERT INTO quatation VALUES("40","goobTPUah78I0VFmsQZc","0","1");
INSERT INTO quatation VALUES("41","ah9wwLsF4G9BLwY6BaSI","0","1");
INSERT INTO quatation VALUES("42","eQ5X50eCL1UUAGTqKCK3","0","1");
INSERT INTO quatation VALUES("43","mIBnoGIH65Z4hqodoe4M","0","1");
INSERT INTO quatation VALUES("44","RIrh3wDDawDU942RDJKF","0","1");
INSERT INTO quatation VALUES("45","RwGrC4OUxjrlT1VzzE3z","0","1");
INSERT INTO quatation VALUES("46","der2u62i7xPo5pig8DEs","0","1");
INSERT INTO quatation VALUES("47","b5eOmPRSHA3UCrrvCBKE","0","1");
INSERT INTO quatation VALUES("48","cAYtePU21mNYRZhYRHPJ","0","1");
INSERT INTO quatation VALUES("49","4GcmBZW4fKlJHV130keD","0","1");
INSERT INTO quatation VALUES("50","sjx9MJ14CaoWytfVYAlg","0","1");
INSERT INTO quatation VALUES("51","jo5MkLZULNQJBowrhclN","0","1");
INSERT INTO quatation VALUES("52","Tq2847prgFDwg8YtWUIJ","0","1");
INSERT INTO quatation VALUES("53","LsENcjSuEKVsxEPIz5mz","0","1");
INSERT INTO quatation VALUES("54","n4By4UNWTQy2Zm2EYRCJ","0","1");
INSERT INTO quatation VALUES("55","PaEYhOfZju9abHpY2Kuy","0","1");
INSERT INTO quatation VALUES("56","5LQlJBuTlxhCAoEGxCxl","0","1");
INSERT INTO quatation VALUES("57","LDXgfAtb8FunaYBToOvS","0","1");
INSERT INTO quatation VALUES("58","AvTkFYEZWhmRZaXbhovT","0","1");
INSERT INTO quatation VALUES("59","fVJX6v15du7CzffJ9RKz","0","1");
INSERT INTO quatation VALUES("60","aKiFORsY8ahpGEJw08qC","0","1");
INSERT INTO quatation VALUES("61","0tauc7acSaleTittyuPE","0","1");
INSERT INTO quatation VALUES("62","W1aAxI4OkFah8blzljRl","0","1");
INSERT INTO quatation VALUES("63","STBk7F6IjnR7u9pcTvNg","0","1");
INSERT INTO quatation VALUES("64","JOy3hT5NAOL6Z70Azqxm","0","1");
INSERT INTO quatation VALUES("65","UZOwOBpUfPzTZgT8R6hS","0","1");
INSERT INTO quatation VALUES("66","yu5V6ANj9mi4s71S1jgI","0","1");
INSERT INTO quatation VALUES("67","ecosSyjvNNVJRsbaYHmx","0","1");
INSERT INTO quatation VALUES("68","xiiVFBbPFKyce4C1nWiy","0","1");
INSERT INTO quatation VALUES("69","1cXJ368HiLqGvshe8O7q","0","1");
INSERT INTO quatation VALUES("70","Unqyxhl98WmYWbUWMMTu","0","1");
INSERT INTO quatation VALUES("71","I2bg9RdIdKMe6LyI2ONx","0","1");
INSERT INTO quatation VALUES("72","JQU4tIlSrtq3fV5Gdq0B","0","1");
INSERT INTO quatation VALUES("73","LgRc0Kr1CGsdTOIE4rJe","0","1");
INSERT INTO quatation VALUES("74","BDMcC5swyxa1lcNg93WG","0","1");
INSERT INTO quatation VALUES("75","kjKn4uQUj8tdWV4RUHjD","0","1");
INSERT INTO quatation VALUES("76","A5d01vyaJqkkPPJXDS1J","0","1");
INSERT INTO quatation VALUES("77","1z7Atjs4hTaQNR22ubNj","0","1");
INSERT INTO quatation VALUES("78","kDGGyfAasEre0rY9Dmst","0","1");
INSERT INTO quatation VALUES("79","kykEgE5apkYEWcEBOqwr","0","1");
INSERT INTO quatation VALUES("80","Pjjr77BGEE8tc8DaSbZu","0","1");
INSERT INTO quatation VALUES("81","Zyn3ShhOwB1kvflPCAjh","0","1");
INSERT INTO quatation VALUES("82","bOhcOg5Bsy6efpkjxUP8","0","1");
INSERT INTO quatation VALUES("83","8gh3OYNMjBPum9Pai22J","0","1");
INSERT INTO quatation VALUES("84","OvMiEWFjXQqniGb36RjN","0","1");
INSERT INTO quatation VALUES("85","Y7xYCahQo4ilSaNYBoMQ","0","1");
INSERT INTO quatation VALUES("86","qYIy560j7i52jORZQDhj","0","1");
INSERT INTO quatation VALUES("87","yoP5a7sXm5hYfM2e5ki8","0","1");
INSERT INTO quatation VALUES("88","pk72M5SpSgida2s4XJpC","0","1");
INSERT INTO quatation VALUES("89","aaN5mIsGEIJS68HaCGc6","0","1");
INSERT INTO quatation VALUES("90","0WcwFM1B0dFO1jV0wQkC","0","1");
INSERT INTO quatation VALUES("91","oIMszAM4dY3fOHMlMysM","0","1");
INSERT INTO quatation VALUES("92","u87ZoYfjHXMol1DMwDn3","0","1");
INSERT INTO quatation VALUES("93","OpfOtacZ55lvPIlC6dCR","0","1");
INSERT INTO quatation VALUES("94","2SjvHe1E0VZRN8vtwsrz","0","1");
INSERT INTO quatation VALUES("95","h1hXfT3MTcpbNF11E81b","0","1");
INSERT INTO quatation VALUES("96","KNTEL2fzAClxWPFRBp3w","0","1");
INSERT INTO quatation VALUES("97","IZXkdlFDsDqxXg1Ni4HB","0","1");
INSERT INTO quatation VALUES("98","O5Nbtk0uYjXEOfSZTj1k","0","1");
INSERT INTO quatation VALUES("99","mX3nMkDmSjXnXRpxK8wT","0","1");
INSERT INTO quatation VALUES("100","iEoyXh2ouBRNgA0zulAK","0","1");
INSERT INTO quatation VALUES("101","tI05McqwmiQH86K0UUGr","0","1");
INSERT INTO quatation VALUES("102","kx82Z1OTxYsc4hvIGYkb","0","1");
INSERT INTO quatation VALUES("103","5Vx6dseWGLh0LGDIEOJ2","0","1");
INSERT INTO quatation VALUES("104","BjRWKAuztAg2x4QQ09gS","0","1");
INSERT INTO quatation VALUES("105","3k6XSObeN28evEltbSFi","0","1");
INSERT INTO quatation VALUES("106","7r3pztbKGWcd4ZinrfUU","0","1");
INSERT INTO quatation VALUES("107","4ca2NUHsCOg1V04Hz4Jc","0","1");
INSERT INTO quatation VALUES("108","sibcEO56tS3973hfRFs1","0","1");
INSERT INTO quatation VALUES("109","Qc2VArozZUgv5SqRtI74","0","1");
INSERT INTO quatation VALUES("110","97HjZcxzwX0VgeXHVpvE","0","1");
INSERT INTO quatation VALUES("111","23G2IMlhfa1wh81Jaa1N","0","1");
INSERT INTO quatation VALUES("112","7al2YGe1rnfMquVCuNoN","0","1");
INSERT INTO quatation VALUES("113","tBNmYo9ULus6LX2JXaO4","0","1");
INSERT INTO quatation VALUES("114","SguE33VDruYwyXkhRpRD","0","1");
INSERT INTO quatation VALUES("115","30qbwmckGboTfe5TGDlB","0","1");
INSERT INTO quatation VALUES("116","oz6HpoeRTzCICmWQ3xGb","0","1");
INSERT INTO quatation VALUES("117","eqdh44l1boGLI7CeYHVD","0","1");
INSERT INTO quatation VALUES("118","Y7x7GsXGbNjxo9Sf6T40","0","1");
INSERT INTO quatation VALUES("119","mQkUPMyIHn1C04rv88yI","0","1");
INSERT INTO quatation VALUES("120","ac3ZV4AuzJGzerZAZOz9","0","1");
INSERT INTO quatation VALUES("121","RxTJWWc1FEr3kDOiSljl","0","1");
INSERT INTO quatation VALUES("122","5691HrrerEiiwURPFN0q","0","1");
INSERT INTO quatation VALUES("123","Y1LohPVqFxJzC4CFOsPm","0","1");
INSERT INTO quatation VALUES("124","eGQOYLu4o4XPLVtV5RH2","0","1");
INSERT INTO quatation VALUES("125","r7KGTnYmWyP2TIpBUdZC","0","1");
INSERT INTO quatation VALUES("126","DK1yNPalpGClzZEfV4WI","0","1");
INSERT INTO quatation VALUES("127","noDPft9VOP4wZIrHrQi2","0","1");
INSERT INTO quatation VALUES("128","bh12fstIkywThFnvTvfm","0","1");
INSERT INTO quatation VALUES("129","Lop1EgP4oVxtoBTe30vo","0","1");
INSERT INTO quatation VALUES("130","jztSSPLujiHVrF5uCqIc","0","1");
INSERT INTO quatation VALUES("131","mKPB3n3567wVK2IUUVvn","0","1");
INSERT INTO quatation VALUES("132","m5yuHk1RgwnyUYNrINJ0","0","1");
INSERT INTO quatation VALUES("133","pQIZPDOe2KR5PjbqytZR","0","1");
INSERT INTO quatation VALUES("134","OPL9vWcaOLMRd6oq2v07","0","1");
INSERT INTO quatation VALUES("135","fiC6IBx0FC6VNB4pi1e8","0","1");
INSERT INTO quatation VALUES("136","MC5ljpXkaXj5tLR6KlNr","0","1");
INSERT INTO quatation VALUES("137","8xNnIyTimevHOscaPQzk","0","1");
INSERT INTO quatation VALUES("138","vQvpdGJAowsr8eslV6HY","0","1");
INSERT INTO quatation VALUES("139","zvtv4VXiinOtz3sCkiM1","0","1");
INSERT INTO quatation VALUES("140","d5WbBbkWter9vsTKnOsJ","0","1");
INSERT INTO quatation VALUES("141","ADkdIy3TsKxdH81werph","0","1");
INSERT INTO quatation VALUES("142","VRYxNnuZL16bJb0HXh3a","0","1");
INSERT INTO quatation VALUES("143","JbvqxS5hhQ7Un2aZDrMB","0","1");
INSERT INTO quatation VALUES("144","QSKs8xmbGBH3OgEWi1Ar","0","1");
INSERT INTO quatation VALUES("145","UUrRpxAZdTqpb95IdmT8","0","1");
INSERT INTO quatation VALUES("146","Nzm3iW8aMN18Giihy8FW","0","1");
INSERT INTO quatation VALUES("147","lvqFhPfi99W7zsI4V4TX","0","1");
INSERT INTO quatation VALUES("148","8sQqqXTtojiLk2Y7Xfzq","0","1");
INSERT INTO quatation VALUES("149","JRzrT1FfMop8jY4cackZ","0","1");
INSERT INTO quatation VALUES("150","fTHa3HylZFYycPm9U4PW","0","1");
INSERT INTO quatation VALUES("151","ZJNcB7wTsh8Vkgoae2tQ","0","1");
INSERT INTO quatation VALUES("152","p4qkj6STAtvvIbD7OBWM","0","1");
INSERT INTO quatation VALUES("153","puizysjbincKTLtI7YwA","0","1");
INSERT INTO quatation VALUES("154","bYcG8j4xXonNDAQxJkWS","0","1");
INSERT INTO quatation VALUES("155","w1MIcfZxiwaktRtzBomL","0","1");
INSERT INTO quatation VALUES("156","SRT2oKRaAmYbMHqwTYBP","0","1");
INSERT INTO quatation VALUES("157","WRON4YELiNYxzIl9Bz1Y","0","1");
INSERT INTO quatation VALUES("158","Ux00XeKif8p2Ra9fAZi1","0","1");
INSERT INTO quatation VALUES("159","w4t9jMOKLDTg8gaNVBGz","0","1");
INSERT INTO quatation VALUES("160","jwgQgBIFkTQYVAVRQoVp","0","1");
INSERT INTO quatation VALUES("161","Ct0F0NCAI01xbYt8NpUO","0","1");
INSERT INTO quatation VALUES("162","UVaRndwCggvdVdTQURzw","0","1");
INSERT INTO quatation VALUES("163","it66A5L6Cg6ccuHNDFnb","0","1");
INSERT INTO quatation VALUES("164","miYAZNq5e1ruDA75r6uI","0","1");
INSERT INTO quatation VALUES("165","yPymeBs0CVgRBPyu0KPL","0","1");
INSERT INTO quatation VALUES("166","HlpP6BL4XSVWWuANeTiF","0","1");
INSERT INTO quatation VALUES("167","ceBshGB80KQoBNQ3cbqo","0","1");
INSERT INTO quatation VALUES("168","3u3DBvaeU4aUCDQSnSqZ","0","1");
INSERT INTO quatation VALUES("169","fhoZMQwb6D0U1RUaTNQn","0","1");
INSERT INTO quatation VALUES("170","yDNyUgOAP8sV8FwrYZMP","0","1");
INSERT INTO quatation VALUES("171","h9s6dpPNXyrTjGNMA6AV","0","1");
INSERT INTO quatation VALUES("172","pODdiVSBwhHtIbRxbpM0","0","1");
INSERT INTO quatation VALUES("173","h3TBNivZRRj2sN8Uy4Qv","0","1");
INSERT INTO quatation VALUES("174","GdprqTRWrJlub2oaR6qf","0","1");
INSERT INTO quatation VALUES("175","QTNcyqbcIwIL0xgjYjgA","0","1");
INSERT INTO quatation VALUES("176","HvLVq2aDSjWvmxc4SQyL","0","1");
INSERT INTO quatation VALUES("177","ur0ao3yBfC5ufg1wVrnP","0","1");
INSERT INTO quatation VALUES("178","JYCjBg6rmWejX9DMas0J","0","1");
INSERT INTO quatation VALUES("179","QAtFKOEOtDpblgty3xqK","0","1");
INSERT INTO quatation VALUES("180","LTZ9CX0RpsvJarOnKh1I","0","1");
INSERT INTO quatation VALUES("181","yc88L7aHbTMZUg6vE4BY","0","1");
INSERT INTO quatation VALUES("182","90FFOsMrLbcBJzmRAZ1t","0","1");
INSERT INTO quatation VALUES("183","n90JPD7kd0wvs9gpDCwo","0","1");
INSERT INTO quatation VALUES("184","9SbRvuNp7R0eDWiCX8eD","0","1");
INSERT INTO quatation VALUES("185","atq2YTL45ZooqdroTC4d","0","1");
INSERT INTO quatation VALUES("186","oKrA5J77hoC5l6UCD5F4","0","1");
INSERT INTO quatation VALUES("187","neOjTAdBZ9jtyOlMvcAg","0","1");
INSERT INTO quatation VALUES("188","xqnw2nLKjZ3P74gE4mvN","0","1");
INSERT INTO quatation VALUES("189","MPzV6EYXLFzkXUTKcsiq","0","1");
INSERT INTO quatation VALUES("190","bgkAvuCkGhHBRs8uAiDl","0","1");
INSERT INTO quatation VALUES("191","vqZoSjKAaX8tCwWvcXiQ","0","1");
INSERT INTO quatation VALUES("192","EWAjIGCv3pglklm3h7Tn","0","1");
INSERT INTO quatation VALUES("193","mqd7jzvwTerM3zFg1MIT","0","1");
INSERT INTO quatation VALUES("194","7GzS6rvuHSkoJUI227mA","0","1");
INSERT INTO quatation VALUES("195","ljWgniYeVoN5xaEGJfZ5","0","1");
INSERT INTO quatation VALUES("196","cG6wngldqZxC0Zy9jraU","0","1");
INSERT INTO quatation VALUES("197","BLTPHeLVxi9VXQCmvXnJ","0","1");
INSERT INTO quatation VALUES("198","sQNeadoCOZAKSUoAovpW","0","1");
INSERT INTO quatation VALUES("199","5iEEeC8Wk50tYX8bEKEu","0","1");
INSERT INTO quatation VALUES("200","ouOa1lHDyOZooJMmkXF4","0","1");
INSERT INTO quatation VALUES("201","bzgv7DbAWPc0tCMibzk7","0","1");
INSERT INTO quatation VALUES("202","ESIoqf5ZVZMzTsvu5CG8","0","1");
INSERT INTO quatation VALUES("203","DRAbTaVW7HwVQ9nkZHEW","0","1");
INSERT INTO quatation VALUES("204","aOlcqdu9fQSPBdRq7rxA","0","1");
INSERT INTO quatation VALUES("205","Lby3PNv521pV16K6Txj0","0","1");
INSERT INTO quatation VALUES("206","4QPn7RLkfJhzFg6UoLnq","0","1");
INSERT INTO quatation VALUES("207","5s9vA5vkFWrvXc3dH8J6","0","1");
INSERT INTO quatation VALUES("208","UQaiZjUB05H41dktQfDO","0","1");
INSERT INTO quatation VALUES("209","PU1XWQpOIoatIJeKYLBd","0","1");
INSERT INTO quatation VALUES("210","LA7oGxnoKjyvvgunzQKX","0","1");
INSERT INTO quatation VALUES("211","Tb8dlgeB0YhYqvR9c9EX","0","1");
INSERT INTO quatation VALUES("212","r7XNln1VOIqgn9RxnQ4L","0","1");
INSERT INTO quatation VALUES("213","VlkaTyX8vIHlew6J0uUw","0","1");
INSERT INTO quatation VALUES("214","fhh1Ojm9yWKWXBwQWW8y","0","1");
INSERT INTO quatation VALUES("215","FdcxoOovma3Y97lb3WHF","0","1");
INSERT INTO quatation VALUES("216","8D6AYeaT3RRzKgC9NLEu","0","1");
INSERT INTO quatation VALUES("217","OcmxutPkJzDME47ZRchD","0","1");
INSERT INTO quatation VALUES("218","xJ6foj9Y1WNL5TNxCqE1","0","1");
INSERT INTO quatation VALUES("219","9WYRjPgqwIsUf2qQ71nP","0","1");
INSERT INTO quatation VALUES("220","FEIsfbkKhIvrunQND3WQ","0","1");
INSERT INTO quatation VALUES("221","GSVaXNnztUvBxszIi8A5","0","1");
INSERT INTO quatation VALUES("222","SV8n7g8xpF0aWlMv2d40","0","1");
INSERT INTO quatation VALUES("223","3uL8yUlYZaMxFXUDYI2t","0","1");
INSERT INTO quatation VALUES("224","eGbYs53nnei9YCtm4EUW","0","1");
INSERT INTO quatation VALUES("225","DaBsZaCisSc7X5wDqpCj","0","1");
INSERT INTO quatation VALUES("226","XCHtangkrxGDyoIFwmpA","0","1");
INSERT INTO quatation VALUES("227","GH3WxOXPNWeIeTgO1ssv","0","1");
INSERT INTO quatation VALUES("228","eqiXU8rVvsmv2r3bKrtt","0","1");
INSERT INTO quatation VALUES("229","vfhbZmMIf3rAeXe122jF","0","1");
INSERT INTO quatation VALUES("230","1kPMBQbqfecu6xzLoxxj","0","1");
INSERT INTO quatation VALUES("231","fEh2qI6Fpy7jWkpxJNJL","0","1");
INSERT INTO quatation VALUES("232","giYNk1N9RunehKTPScmj","0","1");
INSERT INTO quatation VALUES("233","DfQ4sabOsn4YL4AMB532","0","1");
INSERT INTO quatation VALUES("234","YzEUSdciv8VaLCAbW3cF","0","1");
INSERT INTO quatation VALUES("235","lUIPZiuigVmpRKUcvRIg","0","1");
INSERT INTO quatation VALUES("236","iFiI2zdcGqOoN1mGxwUX","0","1");
INSERT INTO quatation VALUES("237","1DKxWgV5klTOf8mEHj0x","0","1");
INSERT INTO quatation VALUES("238","hYfcEYUDSHIe4dfFmcot","0","1");
INSERT INTO quatation VALUES("239","rZYz4qntS454uvcYbVT9","0","1");
INSERT INTO quatation VALUES("240","GTT00296X3hdBCAy2yoE","0","1");
INSERT INTO quatation VALUES("241","cedHZd2j3HdzcYunQoqj","0","1");
INSERT INTO quatation VALUES("242","swoaR32oN3gCNhzXncD1","0","1");
INSERT INTO quatation VALUES("243","qLolie41mfRg7RST0YMf","0","1");
INSERT INTO quatation VALUES("244","2ieaFUEV7DZ4apPPlu8X","0","1");
INSERT INTO quatation VALUES("245","nZ8kLOkBo7GgMU1Ryk6W","0","1");
INSERT INTO quatation VALUES("246","MwCvf92bIRFYlXR3sevY","0","1");
INSERT INTO quatation VALUES("247","X3vsK6ThkF4e7aB5pDFU","0","1");
INSERT INTO quatation VALUES("248","VIangkUhjFRgYNKeGYd6","0","1");
INSERT INTO quatation VALUES("249","JH83YJSohuoLSgdKRQbj","0","1");
INSERT INTO quatation VALUES("250","QPWAGLGWEPTpfpHjLzCn","0","1");
INSERT INTO quatation VALUES("251","9LdTZXn7ZfytcC6u2W6C","0","1");
INSERT INTO quatation VALUES("252","8tjwwDQKDtBq2MDFdKZo","0","1");
INSERT INTO quatation VALUES("253","VG9FnaSspzElvbnwJXlY","0","1");
INSERT INTO quatation VALUES("254","XgkGNJToZccDdbNuS07i","0","1");
INSERT INTO quatation VALUES("255","xuHj7Lb2zYLDiU1qPajn","0","1");
INSERT INTO quatation VALUES("256","06GqTwg7abM2QekxBkXB","0","1");
INSERT INTO quatation VALUES("257","uU8xyJklzwa2kJ1AYbIk","0","1");
INSERT INTO quatation VALUES("258","GDnLaY7iv5lFe9Gz2kDn","0","1");
INSERT INTO quatation VALUES("259","6LVd6hYB5PPGDJEmKmiq","0","1");
INSERT INTO quatation VALUES("260","yy5AiSW2Y3LocJLN9Dhf","0","1");
INSERT INTO quatation VALUES("261","iJxpNpCFXt1akpG7ksFO","0","1");
INSERT INTO quatation VALUES("262","Y1aTIsq1C2P1EENY9G1M","0","1");
INSERT INTO quatation VALUES("263","1s8Wsf3xSHJjWKgUXFOj","0","1");
INSERT INTO quatation VALUES("264","vFn5ZXC2TfTlRdSIa0FN","0","1");
INSERT INTO quatation VALUES("265","QxB4VKyz9lBBrkCZP1aI","0","1");
INSERT INTO quatation VALUES("266","UFiZQ31crEAzMi7wVMKw","0","1");
INSERT INTO quatation VALUES("267","tjiwgNIlkhmLuXf1Pm2R","0","1");
INSERT INTO quatation VALUES("268","66dNBIBT5jrXquaJ5UHN","0","1");
INSERT INTO quatation VALUES("269","l61jiKfc2j138rMXzKub","0","1");
INSERT INTO quatation VALUES("270","I1mzQ85jhX9o7PwzZDtQ","0","1");
INSERT INTO quatation VALUES("271","ceKzDjxruSiAMIXs1fjj","0","1");
INSERT INTO quatation VALUES("272","9MSoZ1EpNNeF1KJwvIJb","0","1");
INSERT INTO quatation VALUES("273","yeQoB5gCPtP1eg9MmDx6","0","1");
INSERT INTO quatation VALUES("274","OQMeXLkJqDSd4Q9hy6s8","0","1");
INSERT INTO quatation VALUES("275","H4BpNJCAVPt2epJyUUMf","0","1");
INSERT INTO quatation VALUES("276","iqHgHn5BYEZ5HHbqjIOf","0","1");
INSERT INTO quatation VALUES("277","9XdmrbISccsSEbsyXWFR","0","1");
INSERT INTO quatation VALUES("278","Wbhpd0RSjqDacWS9Fwxc","0","1");
INSERT INTO quatation VALUES("279","buoQ7w0ftRoVDN42f7fY","0","1");
INSERT INTO quatation VALUES("280","2xBIaI8v5xkmyTB4H6fW","0","1");
INSERT INTO quatation VALUES("281","Zd13tKkjUwu25eVzMdiy","0","1");
INSERT INTO quatation VALUES("282","euqETwSDfl19tMBWvtHj","0","1");
INSERT INTO quatation VALUES("283","llVXzGEXzvIpJijAVRvU","0","1");
INSERT INTO quatation VALUES("284","i98Cq3vJivLtUKgf9elF","0","1");
INSERT INTO quatation VALUES("285","gPOaaICoT1boLKo5oVEe","0","1");
INSERT INTO quatation VALUES("286","B5yWjxfPwQawEwTvNlHq","0","1");
INSERT INTO quatation VALUES("287","Pyujh3LXfvfR5Ue6hVhT","0","1");
INSERT INTO quatation VALUES("288","K4KLGpEPGIGpiTdsnhXQ","0","1");
INSERT INTO quatation VALUES("289","mGDqR1HoG1YJ5kAUp2xN","0","1");
INSERT INTO quatation VALUES("290","g8MjFqRQEXePkbzrrpPp","0","1");
INSERT INTO quatation VALUES("291","wvFlTmutn9yLczmzcsp9","0","1");
INSERT INTO quatation VALUES("292","Xe97P14KJ6dMxpnKPfy6","0","1");
INSERT INTO quatation VALUES("293","ttXcsrnxQCSmDtTnLhPH","0","1");
INSERT INTO quatation VALUES("294","pHWy5YD2EOUVzgnLdwIK","0","1");
INSERT INTO quatation VALUES("295","4HzYTDFJYxgvVnNYMHVg","0","1");
INSERT INTO quatation VALUES("296","HzNcRkL4q5k52FEntWlF","0","1");
INSERT INTO quatation VALUES("297","XYsGl9Oq72tGAbbyjEEK","0","1");
INSERT INTO quatation VALUES("298","xJgrkwl3XkygoT6TXSXi","0","1");
INSERT INTO quatation VALUES("299","e0gt9jTCLeBgrxOdjNGH","0","1");
INSERT INTO quatation VALUES("300","oUBDByVV0dmDgNNOZFGS","0","1");
INSERT INTO quatation VALUES("301","2Nd0mZNLKz2KHvJDqdW0","0","1");
INSERT INTO quatation VALUES("302","Iczwc59wY08p5WBqgv4j","0","1");

CREATE TABLE `rates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `qid` varchar(150) NOT NULL,
  `types` int(11) NOT NULL,
  `item` text DEFAULT NULL,
  `mesure` varchar(150) NOT NULL,
  `rates` varchar(150) NOT NULL,
  `sts` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE `returnnentry` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mid` int(11) NOT NULL,
  `pvc` varchar(50) NOT NULL,
  `nos` varchar(50) NOT NULL,
  `date` varchar(50) NOT NULL,
  `sts` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `stockentry` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mid` int(11) NOT NULL,
  `pvc` varchar(50) NOT NULL,
  `nos` varchar(50) NOT NULL,
  `date` varchar(50) NOT NULL,
  `sts` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `timedetals` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `jid` varchar(150) NOT NULL,
  `srpm` varchar(50) NOT NULL,
  `crpm` varchar(50) NOT NULL,
  `times` varchar(100) NOT NULL,
  `feetge` varchar(50) NOT NULL,
  `cdc` varchar(100) NOT NULL,
  `sts` int(11) NOT NULL,
  `mid` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=98 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO timedetals VALUES("1","yIhZwhwCfYmfNHBVRZyf","5475.6","5488.6","13","54","168","1","0");
INSERT INTO timedetals VALUES("2","viPlrLGqhBaCFpkYCaDc","5488.6","5493.1","4.5","62","506","1","0");
INSERT INTO timedetals VALUES("3","jzHtIyVSBEBgCjoDPQXR","5493.1","5497.8","4.699999999999818","15","395","1","0");
INSERT INTO timedetals VALUES("4","BwKFccwwoTtKUFnNpckx","5497.8","5504.8","7","56","452","1","0");
INSERT INTO timedetals VALUES("5","eFLFeIZIETXiRotxvIqx","5504.8","5518.1","13.300000000000182","45","295","1","0");
INSERT INTO timedetals VALUES("6","YWzVLVqexHyrUqbcGSyN","0","0","0nil","0","0","1","0");
INSERT INTO timedetals VALUES("7","rNhDxKKKMxmyycrFwGdM","5518.1","5528.2","10.099999999999454","65","211","1","0");
INSERT INTO timedetals VALUES("8","ZEZerARHkebkKPJOlBiD","5528.2","5542.3","14.100000000000364","57","234","1","0");
INSERT INTO timedetals VALUES("9","UBjGnHHQNBlEkjYFuvGj","5542.3","5546.1","3.800000000000182","53","216","1","0");
INSERT INTO timedetals VALUES("10","xOFmUYaQreBHliIobDOM","5546.1","5553.1","7","61","708","1","0");
INSERT INTO timedetals VALUES("11","MMkfxCeYxVVQYQfFAZpp","5553.1","5566.5","13.399999999999636","54","235","1","0");
INSERT INTO timedetals VALUES("12","KFaKlshCzMKYTwxLCSvb","5566.5","5569.3","2.800000000000182","250","158","1","0");
INSERT INTO timedetals VALUES("13","NvkPRIXBfXpHegRGmoQO","5569.3","5582.0","12.699999999999818","50","395","1","0");
INSERT INTO timedetals VALUES("14","NiUMajzEPXewWYymsuNn","5582.0","5590.1","8.100000000000364","56","128","1","0");
INSERT INTO timedetals VALUES("15","OwCmezKNnoybyhKTxKCN","5590.1","5596.5","6.399999999999636","56","165","1","0");
INSERT INTO timedetals VALUES("16","XymrVnlMLTlcqjrPuTAN","5596.5","5613.7","17.199999999999818","58","245","1","0");
INSERT INTO timedetals VALUES("17","KsweJfxlgfUPQJgVnAkW","5613.5","5618.7","5.199999999999818","62","290","1","0");
INSERT INTO timedetals VALUES("18","bxbPvBcpXvXzufcXKSzm","5618.7","5622.6","3.9000000000005457","73","468","1","0");
INSERT INTO timedetals VALUES("19","NHoSboDycMCBAKmEFjVk","5622.6","5634.4","11.799999999999272","51","105","1","0");
INSERT INTO timedetals VALUES("20","LLJEYJBciMcEwgaJBVEZ","954.8","959.4","4.600000000000023","55","571","1","0");
INSERT INTO timedetals VALUES("21","JfNbaYBhaMAhvlVJokpk","959.4","970.0","10.600000000000023","59","195","1","0");
INSERT INTO timedetals VALUES("22","zTFAJwBCsjouUwdPLDJf","970.0","975.2","5.2000000000000455","44","379","1","0");
INSERT INTO timedetals VALUES("23","gjxwZjYdTkmODDcDRqVk","975.2","982.0","6.7999999999999545","74","135","1","0");
INSERT INTO timedetals VALUES("24","SqYtTHPlHqEXMnYRoAEv","982.0","998.5","16.5","61","546","1","0");
INSERT INTO timedetals VALUES("25","iBCRKSZeLbqdXSDpDpoq","998.5","1001.5","3","83","423","1","0");
INSERT INTO timedetals VALUES("26","lOfGWMrXnTChHFQmkPSd","1001.5","1004.3","2.7999999999999545","91","310","1","0");
INSERT INTO timedetals VALUES("27","EzlYMGjFMvSWLDyhuYCc","1004.3","1009.8","5.5","72","286","1","0");
INSERT INTO timedetals VALUES("28","lmNtlSkGjObPYCmTIOfL","1009.8","1012.9","3.1000000000000227","65","346","1","0");
INSERT INTO timedetals VALUES("29","zWAIkjrinHrPylsOLyKU","1009.8","1012.9","3.1000000000000227","95","346","1","0");
INSERT INTO timedetals VALUES("30","etRLQigbsbJinjJozuIC","1012.9","1019.4","6.5","31","131","1","0");
INSERT INTO timedetals VALUES("31","OJUjEtfzJhYCvqHnsEUo","1019.4","1028.2","8.800000000000068","68","400","1","0");
INSERT INTO timedetals VALUES("32","hrzywLrvWIRTdyoPyxRs","5634.4","5642.5","8.100000000000364","59","0","1","0");
INSERT INTO timedetals VALUES("33","fGfdVzkvEOWtftdRHsZE","5634.4","5642.5","8.100000000000364","59","0","1","0");
INSERT INTO timedetals VALUES("34","ihjDavaOiMppxTDeTprY","5642.5","5666.4","23.899999999999636","42","0","1","0");
INSERT INTO timedetals VALUES("35","UsvnjOtQyiKGXvCEzaFC","5666.4","5670.5","4.100000000000364","49","590","1","0");
INSERT INTO timedetals VALUES("36","jeaskUrKrpUKKKYnanVT","5670.5","5681.2","10.699999999999818","56","224","1","0");
INSERT INTO timedetals VALUES("37","oghIwYpHRsBcqOfQJnZL","5681.2","5687.7","6.5","68","735","1","0");
INSERT INTO timedetals VALUES("38","sETFhlohzupvnhiKNDRn","5687.7","5693.1","5.400000000000546","54","765","1","0");
INSERT INTO timedetals VALUES("39","ldYwbJzugUkVLrmGqReg","1028.2","1046.5","18.299999999999955","57","266","1","0");
INSERT INTO timedetals VALUES("40","BtegyJVAaxWyTgmgvWwl","5693.1","5696.0","2.899999999999636","69","667","1","0");
INSERT INTO timedetals VALUES("41","sEMzRAYrYVEXkgoRkNml","1046.5","1053.5","7","66","497","1","0");
INSERT INTO timedetals VALUES("42","ZOxLdMxdIcyQlaMzYEMD","5696.0","5702.5","6.5","30","486","1","0");
INSERT INTO timedetals VALUES("43","zRGdietBeevwCXDQZHnn","1053.5","1062.7","9.200000000000045","65","149","1","0");
INSERT INTO timedetals VALUES("44","JZMUsEktgmghiACSvUNq","1062.7","1069.2","6.5","72","449","1","0");
INSERT INTO timedetals VALUES("45","fyTWTTLfoqzJbEQVsfhp","1069.2","1074.3","5.099999999999909","88","219","1","0");
INSERT INTO timedetals VALUES("46","rSaYXYOJvxSzJYTWMBle","1074.3","1082.6","8.299999999999955","60","826","1","0");
INSERT INTO timedetals VALUES("47","AtviTTORsExANYjTenqm","1082.6","1086.7","4.100000000000136","73","714","1","0");
INSERT INTO timedetals VALUES("48","kqMrimPPrYXyevRNTpQa","1086.7","1093.9","7.2000000000000455","76","396","1","0");
INSERT INTO timedetals VALUES("49","ieIHUVqfofBSRsWjiuRA","1093.9","1105.3","11.399999999999864","71","235","1","0");
INSERT INTO timedetals VALUES("50","gOpOhMmjbXQrVYeLhRFI","6954.3","6976.2","21.899999999999636","39","150","1","0");
INSERT INTO timedetals VALUES("51","UozTAgbAXXEwIwfIurXe","6976.2","6990.7","14.5","55","350","1","0");
INSERT INTO timedetals VALUES("52","hUpEulgXgbpOXIeVFIoW","6990.7","6993.6","2.9000000000005457","41","380","1","0");
INSERT INTO timedetals VALUES("53","AlqKxJdQaHtkkcoLppqd","6990.7","6993.6","2.9000000000005457","41","750","1","0");
INSERT INTO timedetals VALUES("54","eUwzeFJoRTChYEzrwPmH","6993.3","7003.2","9.899999999999636","61","470","1","0");
INSERT INTO timedetals VALUES("55","ZoLpUFsXyQyqLWGtrlcN","7003.2","7013.9","10.699999999999818","51","180","1","0");
INSERT INTO timedetals VALUES("56","WMvdrlamRKbTDitkhhuV","7013.9","7016.4","2.5","68","750","1","0");
INSERT INTO timedetals VALUES("57","PrSyzhnpiNqfFGMMlftx","7016.4","7029.6","13.200000000000728","53","250","1","0");
INSERT INTO timedetals VALUES("58","AGrYqJnGaHXmxsKQicYN","1105.3","1122.0","16.700000000000045","51","508","1","0");
INSERT INTO timedetals VALUES("59","LZObULGyHAtWbHTdlSwh","7029.6","7040.1","10.5","48","450","1","0");
INSERT INTO timedetals VALUES("60","ogAFAHslvFOGabQgnUnH","7040.1","7065.2","25.099999999999454","40","100","1","0");
INSERT INTO timedetals VALUES("61","NQaEhZafMWzjICrfsMZB","1122.0","1124.5","2.5","100","340","1","0");
INSERT INTO timedetals VALUES("62","jVdJxMGGlmturGbUmjfm","1124.5","1129.8","5.2999999999999545","75","144","1","0");
INSERT INTO timedetals VALUES("63","YPsFEOAbvOTGmQSRZfuv","7065.2","7084.2","19","53","200","1","0");
INSERT INTO timedetals VALUES("64","KcPjIpQjsFonPxAyIyqf","7084.2","7100.1","15.900000000000546","49","200","1","0");
INSERT INTO timedetals VALUES("65","tWVMvrBjsuTJyoHXfzxr","1129.8","1136.8","7","60","219","1","0");
INSERT INTO timedetals VALUES("66","XosoFYeMJLUvoWfVvNcG","1136.8","1142.8","6","75","417","1","0");
INSERT INTO timedetals VALUES("67","HHrSkNmMlXuxkNuuiqTw","7100.1","7109.2","9.099999999999454","66","500","1","0");
INSERT INTO timedetals VALUES("68","WntHsflqUNtdqunYmVeR","7109.2","7116.2","7","64","300","1","0");
INSERT INTO timedetals VALUES("69","LAGjucyMgvIyNfFIAteQ","1142.8","1158.7","15.900000000000091","60","344","1","0");
INSERT INTO timedetals VALUES("70","WGjgLcLzgcPZfpVzxRsa","7116.2","7121.6","5.400000000000546","65","650","1","0");
INSERT INTO timedetals VALUES("71","paobQmmNnGudtTTPwtlC","1158.7","1164.9","6.2000000000000455","73","106","1","0");
INSERT INTO timedetals VALUES("72","EzklpFtgYYhzwKPathMV","7121.6","7131","9.399999999999636","56","350","1","0");
INSERT INTO timedetals VALUES("73","gIIkEHnmuRDdEjdTYfrm","7131.0","7132.3","1.300000000000182","238","300","1","0");
INSERT INTO timedetals VALUES("74","UHjaHZcXOQwLZWzbsGXa","7132.3","7139.7","7.399999999999636","61","600","1","0");
INSERT INTO timedetals VALUES("75","yuQyWiygSPNqprqPLBmI","7139.7","7147.5","7.800000000000182","58","300","1","0");
INSERT INTO timedetals VALUES("76","yobrYkfryqrtWtfKmNYb","1164.9","1193.4","28.5","31","155","1","0");
INSERT INTO timedetals VALUES("77","mIiIaYQjPgiWUTdNWKnn","1193.4","1195.0","1.599999999999909","294","86","1","0");
INSERT INTO timedetals VALUES("78","WOqgNyryTsjJOhezrVIw","1195.0","1200.6","5.599999999999909","80","381","1","0");
INSERT INTO timedetals VALUES("79","UFFxCypvYAyCRCeoGMjy","7147.5","7156.9","9.399999999999636","57","520","1","0");
INSERT INTO timedetals VALUES("80","HqvVVFMxjTFRAmKBoMWb","7156.9","7162.6","5.700000000000728","61","350","1","0");
INSERT INTO timedetals VALUES("81","BLkmbxevhXbtpDaMFVxG","1200.6","1210.9","10.300000000000182","75","480","1","0");
INSERT INTO timedetals VALUES("82","JLAChJbDfSmKVIzbhYYb","7162.6","7176.2","13.599999999999454","53","380","1","0");
INSERT INTO timedetals VALUES("83","RZRAPmUtHlQSpOTlEPss","1210.9","1223.5","12.599999999999909","71","199","1","0");
INSERT INTO timedetals VALUES("84","DdAGcJJOiFieBlMjryYa","7176.2","7180.1","3.9000000000005457","64","240","1","0");
INSERT INTO timedetals VALUES("85","nixidcbpTVytXztoMJoV","7180.1","7201.3","21.199999999999818","45","350","1","0");
INSERT INTO timedetals VALUES("86","uoxhaXEvKvfBlRzyzYmS","7201.3","7215.4","14.099999999999454","58","300","1","0");
INSERT INTO timedetals VALUES("87","UrvSIypOJkLUdAGOpggA","7215.4","7215.4","0","0","300","1","0");
INSERT INTO timedetals VALUES("88","SWBfJyCSiMzIzUuAumtM","1223.5","1228.0","4.5","78","488","1","0");
INSERT INTO timedetals VALUES("89","HveCAKwEUgbYnYvCnSLg","1228.0","1233.2","5.2000000000000455","67","308","1","0");
INSERT INTO timedetals VALUES("90","RvjXBihTjpNgIxEIeONw","7215.4","7224.3","8.900000000000546","69","300","1","0");
INSERT INTO timedetals VALUES("91","eTTfxAOrBKOnYStVZJbv","1233.2","1248.8","15.599999999999909","35","282","1","0");
INSERT INTO timedetals VALUES("92","hXWzNyxBOUojhJrIdBAF","7224.3","7231.0","6.699999999999818","60","550","1","0");
INSERT INTO timedetals VALUES("93","BykHRgTPYIIBdFuNcUBO","7231.0","7248.7","17.699999999999818","56","200","1","0");
INSERT INTO timedetals VALUES("94","sexbCAFzXAyrkzTmlZNL","7248.7","7254.2","5.5","64","600","1","0");
INSERT INTO timedetals VALUES("95","UYcZtdXUptgXbtvNQBFh","7254.2","7257.7","3.5","77","500","1","0");
INSERT INTO timedetals VALUES("96","UUMndzaJmwghsWBXGoMi","1248.8","1263.5","14.700000000000045","60","312","1","0");
INSERT INTO timedetals VALUES("97","IfwENafDROQMqlkEJZpF","1263.5","1275.7","12.200000000000045","74","192","1","0");

CREATE TABLE `token` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `token` text NOT NULL,
  `sts` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO token VALUES("1","ek2UVP3gQYeA6LSgD_swFe:APA91bGOFxnqw1UQu_dx85Gf2x9koWLpWg_dR8pyh3wPCJrzWTpHvqC7gORgan1xVqRNQqgMdVOSIpDhYJhdPTUFQOmcQld4bw4mkhKl8xiIblWRJjg07o1eiqgoqggYtr9J5o-K8-G0","1");
INSERT INTO token VALUES("2","ek2UVP3gQYeA6LSgD_swFe:APA91bGOFxnqw1UQu_dx85Gf2x9koWLpWg_dR8pyh3wPCJrzWTpHvqC7gORgan1xVqRNQqgMdVOSIpDhYJhdPTUFQOmcQld4bw4mkhKl8xiIblWRJjg07o1eiqgoqggYtr9J5o-K8-G0","1");
INSERT INTO token VALUES("3","ek2UVP3gQYeA6LSgD_swFe:APA91bGOFxnqw1UQu_dx85Gf2x9koWLpWg_dR8pyh3wPCJrzWTpHvqC7gORgan1xVqRNQqgMdVOSIpDhYJhdPTUFQOmcQld4bw4mkhKl8xiIblWRJjg07o1eiqgoqggYtr9J5o-K8-G0","1");
INSERT INTO token VALUES("4","dPr2Wfj2T3Ky17kYCCkOe5:APA91bGfa7a7tScxSE93zq1ZQlwDtW4E-n-4M6IYBP7uUwW1mcyr28TIaMOfulpYC86xICut7YiFFgmSu9FBngoE1J2KyGIRmBrv-6BioKh09tR3KuLcE-8","1");
INSERT INTO token VALUES("5","ek2UVP3gQYeA6LSgD_swFe:APA91bGOFxnqw1UQu_dx85Gf2x9koWLpWg_dR8pyh3wPCJrzWTpHvqC7gORgan1xVqRNQqgMdVOSIpDhYJhdPTUFQOmcQld4bw4mkhKl8xiIblWRJjg07o1eiqgoqggYtr9J5o-K8-G0","1");
INSERT INTO token VALUES("6","ek2UVP3gQYeA6LSgD_swFe:APA91bGOFxnqw1UQu_dx85Gf2x9koWLpWg_dR8pyh3wPCJrzWTpHvqC7gORgan1xVqRNQqgMdVOSIpDhYJhdPTUFQOmcQld4bw4mkhKl8xiIblWRJjg07o1eiqgoqggYtr9J5o-K8-G0","1");
INSERT INTO token VALUES("7","ek2UVP3gQYeA6LSgD_swFe:APA91bGOFxnqw1UQu_dx85Gf2x9koWLpWg_dR8pyh3wPCJrzWTpHvqC7gORgan1xVqRNQqgMdVOSIpDhYJhdPTUFQOmcQld4bw4mkhKl8xiIblWRJjg07o1eiqgoqggYtr9J5o-K8-G0","1");
INSERT INTO token VALUES("8","ek2UVP3gQYeA6LSgD_swFe:APA91bGOFxnqw1UQu_dx85Gf2x9koWLpWg_dR8pyh3wPCJrzWTpHvqC7gORgan1xVqRNQqgMdVOSIpDhYJhdPTUFQOmcQld4bw4mkhKl8xiIblWRJjg07o1eiqgoqggYtr9J5o-K8-G0","1");

CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mid` int(11) NOT NULL,
  `loginid` varchar(150) NOT NULL,
  `passcode` varchar(150) NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO user VALUES("7","4","10002","10000","1");
INSERT INTO user VALUES("11","7","10004","N-0170","1");
INSERT INTO user VALUES("12","5","10003","L-0167","1");
INSERT INTO user VALUES("13","8","S101","J-0170","1");
INSERT INTO user VALUES("16","1","volvo","volvo31","1");
INSERT INTO user VALUES("17","11","A202","A2220","1");
INSERT INTO user VALUES("18","12","B-101","B-0169","1");

CREATE TABLE `vcode` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `codes` varchar(100) NOT NULL,
  `sts` int(11) DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO vcode VALUES("1","4157","1");

CREATE TABLE `verifieduser` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL,
  `dkeys` varchar(150) NOT NULL,
  `device` varchar(200) NOT NULL,
  `ativests` int(11) NOT NULL,
  `sts` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO verifieduser VALUES("3","6","82cd64cac3a28b4fb27a32d32c2ca15c","Realme RMX3085","1","1");
INSERT INTO verifieduser VALUES("4","6","ef99bbb9dacf09c9ad0e2b0c4fce3078","Vivo V2109","1","1");
INSERT INTO verifieduser VALUES("5","6","ea2e05d1bb23eeca7c491154b64ab4d5","Realme RMX3085","1","1");
INSERT INTO verifieduser VALUES("6","6","47370c4b74684e75db3b4777d8e0d540","Realme RMX3085","1","1");
INSERT INTO verifieduser VALUES("7","7","3b77c9a5ad2ca231da2953803ae82143","Realme RMX3085","1","1");
INSERT INTO verifieduser VALUES("8","6","b775fcd397ab6ca02d75b6da3d5e7a4d","Realme RMX3085","1","1");
INSERT INTO verifieduser VALUES("9","7","cba830db972b351a8bf98cac99b5371f","OPPO CPH2387","1","1");
INSERT INTO verifieduser VALUES("10","7","bc38d8ddc380b919a0f7fe137abda10d","OPPO CPH2681","1","1");
INSERT INTO verifieduser VALUES("11","10","158646102e01b21fc2f4f87e74b6da62","Vivo 1816","1","1");
INSERT INTO verifieduser VALUES("12","11","4ea52f3ba0e615eeb67dff23cae9e396","Vivo 1816","1","1");
INSERT INTO verifieduser VALUES("13","11","b0ece40226f2927e3b70f3b26f2cf3e6","Realme RMX3085","0","1");
INSERT INTO verifieduser VALUES("14","12","b0ece40226f2927e3b70f3b26f2cf3e6","Realme RMX3085","0","1");
INSERT INTO verifieduser VALUES("15","6","1d926f2fcccd9306d4c63d4f8243e604","Realme RMX3085","0","1");
INSERT INTO verifieduser VALUES("16","6","7e5992aca7c312656776d615db85854f","Samsung SM-E145F","1","1");
INSERT INTO verifieduser VALUES("17","12","00f77df877700c48038f938aa18ec5b2","Samsung SM-E145F","1","1");
INSERT INTO verifieduser VALUES("18","6","679e99f047c9b6a896d0e8f2d40d98a0","Samsung SM-E145F","1","1");
INSERT INTO verifieduser VALUES("19","12","fe4a6f49a381d3efbfd63001de99ad1e","Samsung SM-A736B","0","1");
INSERT INTO verifieduser VALUES("20","12","","","1","1");
INSERT INTO verifieduser VALUES("21","11","a387621b0f124f9d068d9ca3729fa1d2","Vivo V2311","1","1");
INSERT INTO verifieduser VALUES("22","13","a387621b0f124f9d068d9ca3729fa1d2","Vivo V2311","1","1");
INSERT INTO verifieduser VALUES("23","7","5b59121467195b4f91889685cb299939","OPPO CPH2681","1","1");
INSERT INTO verifieduser VALUES("24","13","e42fda1b6a06553a4d07afeb1ad5e463","Vivo V2311","1","1");
INSERT INTO verifieduser VALUES("25","13","1d926f2fcccd9306d4c63d4f8243e604","Realme RMX3085","1","1");
INSERT INTO verifieduser VALUES("26","6","d9376e98639b29d4753230d3c337297c","Samsung SM-E145F","1","1");
INSERT INTO verifieduser VALUES("27","13","f696831affffb78f2e375472aae5cfb4","Vivo V2311","1","1");
INSERT INTO verifieduser VALUES("28","16","93126ccb9af6bf981f1e654727c4f4ec","Samsung SM-E145F","1","1");
INSERT INTO verifieduser VALUES("29","17","f696831affffb78f2e375472aae5cfb4","Vivo V2311","1","1");
INSERT INTO verifieduser VALUES("30","11","f696831affffb78f2e375472aae5cfb4","Vivo V2311","1","1");
INSERT INTO verifieduser VALUES("31","18","b8001318bed2124d924d41c10c242846","Samsung SM-E156B","1","1");
INSERT INTO verifieduser VALUES("32","18","6794aa9065ce0dabbf17b3ede909ff24","Xiaomi 24066PC95I","1","1");
INSERT INTO verifieduser VALUES("33","13","b8001318bed2124d924d41c10c242846","Samsung SM-E156B","1","1");
INSERT INTO verifieduser VALUES("34","17","b8001318bed2124d924d41c10c242846","Samsung SM-E156B","1","1");
INSERT INTO verifieduser VALUES("35","13","aaca71b1efa3a451d061ebba1716099c","OPPO CPH2579","1","1");
INSERT INTO verifieduser VALUES("36","11","aaca71b1efa3a451d061ebba1716099c","OPPO CPH2579","1","1");
INSERT INTO verifieduser VALUES("37","11","b8001318bed2124d924d41c10c242846","Samsung SM-E156B","1","1");
INSERT INTO verifieduser VALUES("38","11","5a00a37727412ffd9753a7c51c3946c7","Vivo V2339","1","1");
INSERT INTO verifieduser VALUES("39","17","5a00a37727412ffd9753a7c51c3946c7","Vivo V2339","1","1");
INSERT INTO verifieduser VALUES("40","13","5a00a37727412ffd9753a7c51c3946c7","Vivo V2339","1","1");
INSERT INTO verifieduser VALUES("41","11","","","0","1");
INSERT INTO verifieduser VALUES("42","7","2e7efbcba9051a429190f0c0cf991f54","Samsung SM-A236E","1","1");
INSERT INTO verifieduser VALUES("43","17","","","0","1");
INSERT INTO verifieduser VALUES("44","7","cea25220251a184ab1abddb22bf2c4d3","OPPO CPH2681","1","1");