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

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

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

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

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

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

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

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

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

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

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

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

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

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