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=48 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");

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=47 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");

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=48 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","");

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=48 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");

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=45 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");

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=186 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","Cash","10360","0","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");

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=99 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");

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=47 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");

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=57 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","");

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=48 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");

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=212 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");

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=48 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");

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=7 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");

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","D-0169","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","7830","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=44 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");