-- MySqlBackup.NET 2.0.4
-- Dump Time: 2024-10-16 13:47:35
-- --------------------------------------
-- Server version 8.0.16 MySQL Community Server - GPL


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


-- 
-- Definition of aliasproduct
-- 

DROP TABLE IF EXISTS `aliasproduct`;
CREATE TABLE IF NOT EXISTS `aliasproduct` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `aliasproduct` varchar(255) DEFAULT NULL,
  `product` varchar(255) DEFAULT NULL,
  `productid` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  `qa` varchar(50) DEFAULT NULL,
  `administration` varchar(50) DEFAULT NULL,
  `admin` varchar(50) DEFAULT NULL,
  `qatime` datetime DEFAULT NULL,
  `administtime` datetime DEFAULT NULL,
  `admintime` datetime DEFAULT NULL,
  `userid` varchar(50) DEFAULT NULL,
  `qaid` varchar(50) DEFAULT NULL,
  `adminisid` varchar(50) DEFAULT NULL,
  `adminid` varchar(50) DEFAULT NULL,
  `deletestatus` varchar(50) DEFAULT NULL,
  `apaprstatus` varchar(50) DEFAULT NULL,
  `aprejstatus` varchar(50) DEFAULT NULL,
  `aprtime` datetime DEFAULT NULL,
  `rejtime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table aliasproduct
-- 

/*!40000 ALTER TABLE `aliasproduct` DISABLE KEYS */;
INSERT INTO `aliasproduct`(`id`,`aliasproduct`,`product`,`productid`,`created`,`updated`,`qa`,`administration`,`admin`,`qatime`,`administtime`,`admintime`,`userid`,`qaid`,`adminisid`,`adminid`,`deletestatus`,`apaprstatus`,`aprejstatus`,`aprtime`,`rejtime`) VALUES
(1,'CHLOROBUTANOL','CHLOROBUTANOL',1,'2024-08-10 12:45:56',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'39',NULL,NULL,NULL,'0','1','0','2024-08-10 16:45:02',NULL),
(2,'CHLORBUTOL','CHLOROBUTANOL',1,'2024-08-10 12:47:08',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'39',NULL,NULL,NULL,'0','1','0','2024-08-10 16:45:04',NULL),
(3,'CHLORBUTOL (IND. USE ONLY)','CHLOROBUTANOL',1,'2024-08-14 19:41:56',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'39',NULL,NULL,NULL,'1','1','0','2024-08-17 11:16:53',NULL),
(4,'FUROSEMIDE','FUROSEMIDE',6,'2024-08-17 11:18:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'39',NULL,NULL,NULL,'1','1','0','2024-10-04 14:15:34',NULL),
(5,'A Alias','A',8,'2024-09-17 15:08:41',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'36',NULL,NULL,NULL,'0','1','0','2024-09-17 15:08:48',NULL),
(6,'DOCUSATE SODIUM','DOCUSATE SODIUM',2,'2024-10-04 11:00:09',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'39',NULL,NULL,NULL,'0','1','0','2024-10-04 11:01:25',NULL),
(7,'PROPYL GALLATE','PROPYL GALLATE',4,'2024-10-04 11:24:01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'39',NULL,NULL,NULL,'0','1','0','2024-10-04 14:15:02',NULL);
/*!40000 ALTER TABLE `aliasproduct` ENABLE KEYS */;

-- 
-- Definition of consumedstock
-- 

DROP TABLE IF EXISTS `consumedstock`;
CREATE TABLE IF NOT EXISTS `consumedstock` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `batch` varchar(50) DEFAULT NULL,
  `comprodqty` varchar(50) DEFAULT NULL,
  `productid` varchar(50) DEFAULT NULL,
  `comprodid` varchar(50) DEFAULT NULL,
  `conbatch` varchar(50) DEFAULT NULL,
  `qty` varchar(50) DEFAULT NULL,
  `date` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table consumedstock
-- 

/*!40000 ALTER TABLE `consumedstock` DISABLE KEYS */;

/*!40000 ALTER TABLE `consumedstock` ENABLE KEYS */;

-- 
-- Definition of customer
-- 

DROP TABLE IF EXISTS `customer`;
CREATE TABLE IF NOT EXISTS `customer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `custname` varchar(255) DEFAULT '',
  `gstin` varchar(255) DEFAULT '',
  `custadd` varchar(255) DEFAULT '',
  `custphone` varchar(255) DEFAULT '',
  `custemail` varchar(255) DEFAULT '',
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  `custdrug` varchar(255) DEFAULT '',
  `consiadd` varchar(255) DEFAULT '',
  `consiname` varchar(255) DEFAULT '',
  `consiemail` varchar(255) DEFAULT '',
  `consiphone` varchar(255) DEFAULT '',
  `consigst` varchar(255) DEFAULT '',
  `considrug` varchar(255) DEFAULT '',
  `displayname` varchar(255) DEFAULT '',
  `type` varchar(255) DEFAULT '',
  `userid` varchar(50) DEFAULT NULL,
  `deletestatus` varchar(50) DEFAULT NULL,
  `custaprstatus` varchar(50) DEFAULT NULL,
  `custrejstatus` varchar(50) DEFAULT NULL,
  `custaprtime` datetime DEFAULT NULL,
  `custrejtime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table customer
-- 

/*!40000 ALTER TABLE `customer` DISABLE KEYS */;
INSERT INTO `customer`(`id`,`custname`,`gstin`,`custadd`,`custphone`,`custemail`,`created`,`updated`,`custdrug`,`consiadd`,`consiname`,`consiemail`,`consiphone`,`consigst`,`considrug`,`displayname`,`type`,`userid`,`deletestatus`,`custaprstatus`,`custrejstatus`,`custaprtime`,`custrejtime`) VALUES
(1,'ISIS PHARMACEUTICALS AND CHEMICAL WORK','NA','25/1-3, SECTOR 12-C, NORTH KARACHI INDUSTRIAL AREA, KARACHI, PAKISTAN','00','NA','2024-10-04 11:54:02','2024-10-04 12:51:31','NA','','','','','','','ISIS PHARMACEUTICALS AND CHEMICAL WORK','Customer','39','0','1','0','2024-10-04 16:15:02',NULL),
(2,'VISHNU AGENCIES','27AAAFV1634M1Z0','129, HINDUSTAN KOHINOOR COMPLEX, L.B.S. MARG, VIKHROLI (W), MUMBAI - 400 083','9820138604','info@laxachem.com','2024-10-04 11:57:57',NULL,'-','','','','','','','VISHNU AGENCIES','Customer','39','0','1','0','2024-10-04 16:16:23',NULL),
(3,'SHITAL CHEMICALS','24ACZPP0208N1Z4','2 HIND ESTATE , B/H SUBHMANGAL ROADWAYS , NR SIGNATURE-II , SARKHEJ - SANAND CHAR RASTA SARKHEJ AHMEDABAD - 382210','48962223','''Shital Chemicals'' <shitalchemicals85@yahoo.in>','2024-10-04 12:01:17',NULL,'-','','','','','','','SHITAL CHEMICALS','Customer','39','0','1','0','2024-10-04 16:16:20',NULL),
(4,'Coastal Medicare Pvt.Ltd.','37AACCC7990G1ZC','RS. NO. 9 / 2 , 5 , RAMCHANDRAPURAM SURAMAPALL Vijaywada,Krishna (Dist) SURAMAPALL - 521212','00','''cmd -'' <cmd@vanguardgroup.in>','2024-10-04 12:02:54',NULL,'-','','','','','','','Coastal Medicare Pvt.Ltd.','Customer','39','0','1','0','2024-10-04 16:16:18',NULL),
(5,'CURETECH SKINCARE','02AAFFC6027J1ZR','PLOT NO 32,33 & 34, PHASE - IV, BHATOLI KALAN, BADDI - 173205','01795275143','''Shivam Thakur'' <coordinator.rm.csc@gmail.com>','2024-10-04 12:04:18',NULL,'-','','','','','','','CURETECH SKINCARE','Customer','39','0','1','0','2024-10-04 16:16:15',NULL),
(6,'DERREN HEALTHCARE PVT. LTD.','24AAGCD8975Q1ZQ','PLOT NO. 33,35/P & 36/P, XCELON IND. PARK BEHIND INTAS PHARMACEUTICALS LTD. SARKHEJ - BAVLA HIGHWAY, VILLAGE VASAN CHANCHARWADI TALUKA - SANAND, DIST. AHMEDABAD - 382213','7926840045','''DERREN ACCOUNTS'' <accounts@derren.healthcare>','2024-10-04 12:05:53',NULL,'-','','','','','','','DERREN HEALTHCARE PVT. LTD.','Customer','39','0','1','0','2024-10-04 16:16:13',NULL),
(7,'ANUSHA ASSOCIATES','27AGFPM6892B1Z8','23-YUSUF MANSION , 16-18 DARYASTHAN STREET, VADGADI , MANDVI , MUMBAI-400003','8433889099','sales@anusha.co.in','2024-10-04 12:07:20',NULL,'-','','','','','','','ANUSHA ASSOCIATES','Customer','39','0','1','0','2024-10-04 16:16:11',NULL),
(8,'ANOD PHARMA PVT.LTD.','09AACCA0228K1ZV','E-20 INDUSTRIAL AREA, PANKI SITE NO.- 1 KANPUR - 208022.','9794420569','shobhadwivedi@anod.in','2024-10-04 12:08:48',NULL,'-','','','','','','','ANOD PHARMA PVT.LTD.','Customer','39','0','1','0','2024-10-04 16:15:30',NULL),
(9,'WENDT-CHEMIE','NA','WENDT-CHEMIE VERTRIEBSGESELLSCHAFT MBH & CO.KG WANDSBEKER ALLEE 72 D-22041 HAMBURG','00','-','2024-10-04 12:10:58',NULL,'-','','','','','','','WENDT-CHEMIE','Customer','39','0','1','0','2024-10-04 16:16:08',NULL),
(10,'KHYATI HEALTHCARE PVT. LTD.','27AAICK3762E1ZH','58, JUHU SUPREME SHOPPING CENTRE, GULMOHAR CROSS ROAD NO. 9, JVPD SCHEM JUHU MUMBAI - 400049','9082948572','''Purchase KHPL'' <purchase@khpl.co>','2024-10-04 12:12:31',NULL,'-','','','','','','','KHYATI HEALTHCARE PVT. LTD.','Customer','39','0','1','0','2024-10-04 16:15:28',NULL),
(11,'NITIN LIFESCIENCES LTD Unit- I','02AACCN0725G1Z3','RAMPUR GHAT ROAD, PAONTA SAHIB, DISTT. SIRMOUR (H.P) - 173025','9992113865','''Ravi Sharma'' <purchase@nitinlifesciences.com>','2024-10-04 12:14:30',NULL,'-','','','','','','','NITIN LIFESCIENCES LTD Unit- I','Customer','39','0','1','0','2024-10-04 16:16:06',NULL),
(12,'TAMMAN TITOE PHARMA PVT. LTD.','33AABCT9235A1ZQ','56-57 , SIDCO PHARMACEUTICAL COMPLEX ALATHUR CHENGALPATTU DISTRICT THIRUPORUR - 603110','9080945532','admin1@tammantitoepharma.in','2024-10-04 12:16:27',NULL,'-','','','','','','','TAMMAN TITOE PHARMA PVT. LTD.','Customer','39','0','1','0','2024-10-04 16:15:25',NULL),
(13,'NATIONAL LABORATORIES UNIT-II','02AACFN3342E2ZX','VILLAGE -MANPURA OFF BADDI NALAGARH HIGHWAY DIST SOLAN MANPURA BADDI-174101','01795236924','National Laboratories <purchase@nationallabs.in>','2024-10-04 12:19:08',NULL,'MNB/16/925 & MB/16/926','','','','','','','NATIONAL LABORATORIES UNIT-II','Customer','39','0','1','0','2024-10-04 16:16:03',NULL),
(14,'FDC LIMITED, JOGESHWARI,CORP','27AAACF0253H1Z0','142-148,S.V.ROAD,JOGESHWARI (W), MUMBAI - 400102','91','sandeep.naik@fdcindia.com','2024-10-04 12:20:57',NULL,'123-A, 72-A,1796-A, 1642-A','','','','','','','FDC LIMITED, JOGESHWARI,CORP','Customer','39','0','1','0','2024-10-04 16:15:20',NULL),
(15,'ELKO ORGANIZATION (PVT) LTD.','NA','PLOT NO. 27 & 28 , SECTOR 12-B NORTH KARACHI INDUSTRIAL AREA, KARACHI PAKISTAN','00','-','2024-10-04 12:24:16',NULL,'-','','','','','','','ELKO ORGANIZATION (PVT) LTD.','Customer','39','0','1','0','2024-10-04 16:15:16',NULL),
(16,'STAR LABORATORIES (PVT) LTD.','na','23 KM, MULTAN ROAD, (CHUNG) LAHORE - 53800, PAKISTAN','00','-','2024-10-04 12:25:05',NULL,'-','','','','','','','STAR LABORATORIES (PVT) LTD.','Customer','39','0','1','0','2024-10-04 16:15:58',NULL),
(17,'LAWRENCE PHARMA PVT. LTD.','NA','193, CIRCULAR ROAD,2ND FLOOR BILAL MARKET CHOWK NEW ANARKALI LAHORE','00','-','2024-10-04 12:28:17',NULL,'-','','','','','','','LAWRENCE PHARMA PVT. LTD.','Customer','39','0','1','0','2024-10-04 16:15:13',NULL),
(18,'S D FINE-CHEM LTD.','27AAACS5421L1ZA','E-27/28, MIDC, TARAPUR INDUSTRIAL AREA, PALGHAR, B-ROAD , BOISAR - 401506','24814444','purcor1@sdfine.com ','2024-10-04 12:34:32',NULL,'-','','','','','','','S D FINE-CHEM LTD.','Customer','39','0','1','0','2024-10-04 16:15:52',NULL),
(19,'GEMINI EXPORTS','27AAAFG3731E1ZU','A-704, MARATHON FUTUREX, 7TH FLOOR, MAFATLAL MILL COMPOUND, N.M JOSHI MARG, LOWER PAREL, MUMBAI - 400013','9321294824','''Vijay'' <vijay@geminiexports.in>','2024-10-04 12:39:13',NULL,'20B ZONE. MH-MZ2-397910','','','','','','','GEMINI EXPORTS','Customer','39','0','1','0','2024-10-04 16:15:11',NULL),
(20,'AKUMS DRUGS & PHARMACEUTICALS LTD','05AAECA7090B1Z2','PLOT NO.47, SECTOR 6A, I.I.E. SIDCUL, RANIPUR HARIDWAR - 249403','01334239947','''Raman Kapoor'' <epayments@akums.net>','2024-10-04 12:41:12',NULL,'-','','','','','','','AKUMS DRUGS & PHARMACEUTICALS LTD','Customer','39','0','1','0','2024-10-04 16:15:55',NULL),
(21,'VCARE MEDICINES','27AEKPB3528C1ZX','UNIT C/13 , 1 ST FLOOR , SHREERAM IND. ESTATE G.D. AMBEKAR ROAD WADALA (W) ,','9820899844','''vcare medicines'' <vcaremedicines@gmail.com>','2024-10-04 12:43:04',NULL,'-','','','','','','','VCARE MEDICINES','Customer','39','0','1','0','2024-10-04 16:15:06',NULL),
(22,'OCTAVIUS PHARMA PVT. LTD.','24AAACO8145P1Z1','407/A, 4TH FLR, PRIMATE HOUSE OPP. MOTHER MILK PALACE NR. JUDGES BUNGLOWS CROSS ROAD, BODAKDEV, AHMEDABAD - 380015','9099932526','purchase@octaviuspharma.com','2024-10-04 12:45:03',NULL,'-','','','','','','','OCTAVIUS PHARMA PVT. LTD.','Customer','39','0','1','0','2024-10-04 16:15:39',NULL);
/*!40000 ALTER TABLE `customer` ENABLE KEYS */;

-- 
-- Definition of discardedstock
-- 

DROP TABLE IF EXISTS `discardedstock`;
CREATE TABLE IF NOT EXISTS `discardedstock` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `product` varchar(50) DEFAULT NULL,
  `batch` varchar(50) DEFAULT NULL,
  `quantity` varchar(50) DEFAULT NULL,
  `date` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table discardedstock
-- 

/*!40000 ALTER TABLE `discardedstock` DISABLE KEYS */;

/*!40000 ALTER TABLE `discardedstock` ENABLE KEYS */;

-- 
-- Definition of dispatch
-- 

DROP TABLE IF EXISTS `dispatch`;
CREATE TABLE IF NOT EXISTS `dispatch` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lotno` varchar(255) DEFAULT '',
  `distype` varchar(255) DEFAULT '',
  `dod` date DEFAULT NULL,
  `bob` varchar(255) DEFAULT '',
  `dob` date DEFAULT NULL,
  `customer` varchar(255) DEFAULT NULL,
  `invoice` varchar(255) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  `userid` varchar(50) DEFAULT NULL,
  `deletestatus` varchar(50) DEFAULT NULL,
  `disaprstatus` varchar(50) DEFAULT NULL,
  `disrejstatus` varchar(50) DEFAULT NULL,
  `disaprtime` datetime DEFAULT NULL,
  `disrejtime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table dispatch
-- 

/*!40000 ALTER TABLE `dispatch` DISABLE KEYS */;
INSERT INTO `dispatch`(`id`,`lotno`,`distype`,`dod`,`bob`,`dob`,`customer`,`invoice`,`created`,`updated`,`userid`,`deletestatus`,`disaprstatus`,`disrejstatus`,`disaprtime`,`disrejtime`) VALUES
(1,'1','Export','2024-08-18 00:00:00','237','2024-08-18 00:00:00','1','EXP 20','2024-10-05 11:01:47',NULL,'39','0','1','0','2024-10-16 12:31:52',NULL),
(2,'3','Local','2024-10-18 00:00:00','SPECIAL TRUCK','2024-10-18 00:00:00','2','130','2024-10-16 12:11:22',NULL,'39','0','1','0','2024-10-16 12:31:57',NULL),
(3,'5','Local','2024-08-21 00:00:00','24128023','2024-08-22 00:00:00','3','133','2024-10-16 12:13:57',NULL,'39','0','1','0','2024-10-16 12:31:54',NULL),
(4,'4','Local','2024-08-21 00:00:00','24128022','2024-08-22 00:00:00','4','134','2024-10-16 12:15:47',NULL,'39','0','1','0','2024-10-16 12:31:59',NULL),
(5,'8','Local','2024-08-23 00:00:00','CM560034963IN','2024-08-24 00:00:00','5','137','2024-10-16 12:17:34',NULL,'39','0','1','0','2024-10-16 12:32:04',NULL),
(6,'15','Local','2024-08-23 00:00:00','274210005862','2024-08-23 00:00:00','6','139','2024-10-16 12:19:49',NULL,'39','0','1','0','2024-10-16 12:32:02',NULL),
(7,'7','Local','2024-09-17 00:00:00','767699111','2024-09-17 00:00:00','7','155','2024-10-16 12:21:59',NULL,'39','0','1','0','2024-10-16 12:32:06',NULL),
(8,'14','Local','2024-09-08 00:00:00','274210005975','2024-09-09 00:00:00','8','150','2024-10-16 12:23:58',NULL,'39','0','1','0','2024-10-16 12:32:09',NULL),
(9,'13','Local','2024-09-17 00:00:00','SPECIAL TRUCK','2024-09-17 00:00:00','2','157','2024-10-16 12:25:50',NULL,'39','0','1','0','2024-10-16 12:32:11',NULL),
(10,'6','Export','2024-09-20 00:00:00','SPECIAL TRUCK','2024-09-20 00:00:00','9','EXP/26/2024-25','2024-10-16 12:40:03','2024-10-16 12:48:38','39','0','0','0',NULL,NULL),
(11,'16','Export','2024-09-20 00:00:00','SPECIAL TRUCK','2024-09-20 00:00:00','9','EXP/26/2024-25','2024-10-16 12:49:41',NULL,'39','0','0','0',NULL,NULL),
(12,'17','Local','2024-09-20 00:00:00','SPECIAL TRUCK','2024-09-20 00:00:00','9','\tEXP/26/2024-25','2024-10-16 12:50:21',NULL,'39','0','0','0',NULL,NULL),
(13,'33','Export','2024-09-20 00:00:00','SPECIAL TRUCK','2024-09-20 00:00:00','9','EXP/26/2024-25','2024-10-16 12:53:33',NULL,'39','0','0','0',NULL,NULL),
(14,'18','Export','2024-09-07 00:00:00','BLRB007573','2024-09-20 00:00:00','15','EXP/22/2024-25','2024-10-16 13:00:17',NULL,'39','0','0','0',NULL,NULL),
(15,'10','Local','2024-09-17 00:00:00','24128090','2024-09-17 00:00:00','2','157','2024-10-16 13:02:34',NULL,'39','0','0','0',NULL,NULL),
(16,'39','Local','2024-09-10 00:00:00','767698444','2024-09-10 00:00:00','11','152','2024-10-16 13:34:14',NULL,'39','0','0','0',NULL,NULL),
(17,'34','Local','2024-09-18 00:00:00','910108865','2024-09-19 00:00:00','12','158','2024-10-16 13:35:44',NULL,'39','0','0','0',NULL,NULL),
(18,'35','Local','2024-09-24 00:00:00','767699763','2024-09-24 00:00:00','13','159','2024-10-16 13:37:35',NULL,'39','0','0','0',NULL,NULL),
(19,'36','Local','2024-09-24 00:00:00','767699774','2024-09-24 00:00:00','14','160','2024-10-16 13:38:51',NULL,'39','0','0','0',NULL,NULL);
/*!40000 ALTER TABLE `dispatch` ENABLE KEYS */;

-- 
-- Definition of generateqr
-- 

DROP TABLE IF EXISTS `generateqr`;
CREATE TABLE IF NOT EXISTS `generateqr` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `presetid` varchar(255) DEFAULT '',
  `genid` varchar(255) DEFAULT '',
  `title` varchar(255) DEFAULT '',
  `aliasproductid` varchar(255) DEFAULT '',
  `name` varchar(255) DEFAULT '',
  `formula1` varchar(255) DEFAULT '',
  `batch` varchar(255) DEFAULT '',
  `molwt` varchar(255) DEFAULT '',
  `grosswt` varchar(255) DEFAULT '',
  `tarewt` varchar(255) DEFAULT '',
  `netwt` varchar(255) DEFAULT '',
  `mfgdate` date DEFAULT NULL,
  `expdate` date DEFAULT NULL,
  `userid` varchar(50) DEFAULT NULL,
  `manuid` varchar(255) DEFAULT '',
  `contfrom` varchar(255) DEFAULT '',
  `contto` varchar(255) DEFAULT '',
  `contno` varchar(255) DEFAULT '',
  `grade` varchar(255) DEFAULT '',
  `pack` varchar(255) DEFAULT '',
  `ncont` varchar(255) DEFAULT '',
  `qrqty` varchar(255) DEFAULT '',
  `totalqty` varchar(255) DEFAULT '',
  `dispatch` varchar(255) DEFAULT '0',
  `returnst` varchar(255) DEFAULT '0',
  `aprstatus` varchar(255) DEFAULT '0',
  `qrrejstatus` varchar(255) DEFAULT '0',
  `lotdisaprstatus` varchar(255) DEFAULT '0',
  `lotdisrejstatus` varchar(255) DEFAULT '0',
  `lotcreatedate` date DEFAULT NULL,
  `qraprtime` datetime DEFAULT NULL,
  `qrrejtime` datetime DEFAULT NULL,
  `storagecon` varchar(255) DEFAULT NULL,
  `storageconid` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table generateqr
-- 

/*!40000 ALTER TABLE `generateqr` DISABLE KEYS */;
INSERT INTO `generateqr`(`id`,`presetid`,`genid`,`title`,`aliasproductid`,`name`,`formula1`,`batch`,`molwt`,`grosswt`,`tarewt`,`netwt`,`mfgdate`,`expdate`,`userid`,`manuid`,`contfrom`,`contto`,`contno`,`grade`,`pack`,`ncont`,`qrqty`,`totalqty`,`dispatch`,`returnst`,`aprstatus`,`qrrejstatus`,`lotdisaprstatus`,`lotdisrejstatus`,`lotcreatedate`,`qraprtime`,`qrrejtime`,`storagecon`,`storageconid`) VALUES
(1,'1','LAX/0824/001','','1','','','4','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','BP','25','20','','500','1','0','1','0','1','0','2024-08-11 00:00:00','2024-08-11 16:16:38',NULL,'In an air tight container',NULL),
(2,'6','LAX/0824/002','','4','','','9','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','25','8','','200','0','0','1','0','0','0','2024-08-17 00:00:00','2024-08-17 11:28:08',NULL,'Store protect from moisture and light',NULL),
(3,'1','LAX/0824/003','','2','','','5','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','25','12','','300','1','0','1','0','1','0','2024-08-17 00:00:00','2024-08-17 13:24:01',NULL,'Store protect from moisture at temperature not exceeding 30° C',NULL),
(4,'1','LAX/0824/004','','2','','','5','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','25','2','','50','1','0','1','0','1','0','2024-08-21 00:00:00','2024-08-21 11:49:27',NULL,'Store protect from moisture at temperature not exceeding 30° C',NULL),
(5,'1','LAX/0824/005','','2','','','5','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','25','1','','25','1','0','1','0','1','0','2024-08-21 00:00:00','2024-08-21 11:49:45',NULL,'Store protect from moisture at temperature not exceeding 30° C',NULL),
(6,'1','LAX/0824/006','','1','','','6','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','BP,USP','25','20','','500','0','0','1','0','0','0','2024-08-24 00:00:00','2024-08-24 15:54:41',NULL,'Preserve in tight container',NULL),
(7,'1','LAX/0924/007','','2','','','5','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','25','4','','100','1','0','1','0','1','0','2024-09-14 00:00:00','2024-09-14 15:55:28',NULL,'Store protect from moisture at temperature not exceeding 30° C','2'),
(8,'1','LAX/0924/008','','2','','','5','','','','5','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','5','1','','5','1','0','1','0','1','0','2024-09-14 00:00:00','2024-09-14 15:56:17',NULL,'Store protect from moisture at temperature not exceeding 30° C','2'),
(10,'1','LAX/0924/009','','2','','','11','','','','5','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','5','40','','200','1','0','1','0','0','0','2024-09-14 00:00:00','2024-09-14 17:43:26',NULL,'Store protect from moisture at temperature not exceeding 30° C','2'),
(11,'1','LAX/0924/011','','2','','','10','','','','25','2024-10-01 00:00:00','2029-09-01 00:00:00','39','0','','','','IP','25','20','','500','0','0','1','0','0','0','2024-09-14 00:00:00','2024-09-14 17:48:47',NULL,'Store protect from moisture at temperature not exceeding 30° C','2'),
(12,'8','LAX/0924/012','','5','','','12','','','','5','2024-10-01 00:00:00','2026-07-01 00:00:00','36','0','','','','IP','5','4','','20','0','0','1','0','0','0','2024-09-17 00:00:00','2024-09-17 15:10:00',NULL,'A IP STORAGE','5'),
(13,'1','LAX/1024/013','','2','','','5','','','','5','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','5','1','','5','1','0','1','0','1','0','2024-10-03 00:00:00','2024-10-04 14:08:00',NULL,'Store protect from moisture at temperature not exceeding 30° C','2'),
(14,'1','LAX/1024/014','','2','','','5','','','','5','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','5','2','','10','1','0','1','0','1','0','2024-10-03 00:00:00','2024-10-04 14:35:47',NULL,'Store protect from moisture at temperature not exceeding 30° C','2'),
(15,'1','LAX/1024/015','','2','','','5','','','','5','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','5','1','','5','1','0','1','0','1','0','2024-10-03 00:00:00','2024-10-04 14:35:25',NULL,'Store protect from moisture at temperature not exceeding 30° C','2'),
(16,'1','LAX/1024/016','','1','','','7','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','BP,USP','25','20','','500','1','0','1','0','0','0','2024-10-03 00:00:00','2024-10-04 14:35:07',NULL,'Preserve in tight container','4'),
(17,'1','LAX/1024/017','','1','','','8','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','BP,USP','25','20','','500','1','0','1','0','0','0','2024-10-03 00:00:00','2024-10-04 14:34:35',NULL,'Preserve in tight container','4'),
(18,'1','LAX/1024/018','','1','','','11','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','BP','25','12','','300','1','0','1','0','0','0','2024-10-03 00:00:00','2024-10-04 14:34:10',NULL,'In an air tight container','1'),
(20,'2','LAX/1024/020','','6','','','24','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','25','1','','25','0','0','1','0','0','0','2024-10-04 00:00:00','2024-10-05 11:53:21',NULL,'Store protect from moisture','8'),
(22,'2','LAX/1024/022','','6','','','13','','','','25','2024-10-01 00:00:00','2029-09-01 00:00:00','39','0','','','','USP','25','1','','25','0','0','1','0','0','0','2024-10-05 00:00:00','2024-10-05 11:52:45',NULL,'Preserve in well closed container','11'),
(24,'1','LAX/1024/023','','2','','','35','','','','25','2024-10-01 00:00:00','2029-09-01 00:00:00','39','0','','','','IP','25','12','','300','0','0','1','0','0','0','2024-10-05 00:00:00','2024-10-05 12:03:41',NULL,'Store protect from moisture at temperature not exceeding 30° C','2'),
(26,'2','LAX/1024/025','','6','','','13','','','','25','2024-10-01 00:00:00','2029-09-01 00:00:00','39','0','','','','USP','25','1','','25','0','0','1','0','0','0','2024-10-05 00:00:00','2024-10-05 18:08:30',NULL,'Preserve in well closed container','11'),
(27,'2','LAX/1024/027','','6','','','24','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','BP','25','1','','25','0','0','1','0','0','0','2024-10-08 00:00:00','2024-10-08 14:04:37',NULL,'In an air tight container','9'),
(28,'1','LAX/1024/028','','1','','','16','','','','5','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','BP','5','1','','5','0','0','1','0','0','0','2024-10-08 00:00:00','2024-10-08 17:07:55',NULL,'In an air tight container','1'),
(29,'2','LAX/1024/029','','6','','','24','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','25','2','','50','0','0','1','0','0','0','2024-10-09 00:00:00','2024-10-09 17:20:55',NULL,'Store protect from moisture','8'),
(30,'2','LAX/1024/030','','6','','','24','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','25','1','','25','0','0','1','0','0','0','2024-10-09 00:00:00','2024-10-09 18:08:36',NULL,'Store protect from moisture','8'),
(31,'2','LAX/1024/031','','6','','','13','','','','5','2024-10-01 00:00:00','2029-09-01 00:00:00','39','0','','','','USP','5','1','','5','0','0','1','0','0','0','2024-10-15 00:00:00','2024-10-15 12:03:20',NULL,'Preserve in well closed container','11'),
(32,'2','LAX/1024/032','','6','','','13','','','','25','2024-10-01 00:00:00','2029-09-01 00:00:00','39','0','','','','USP','25','9','','225','0','0','1','0','0','0','2024-10-15 00:00:00','2024-10-15 12:03:31',NULL,'Preserve in well closed container','11'),
(33,'1','LAX/1024/033','','1','','','15','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','BP,USP','25','20','','500','1','0','1','0','0','0','2024-10-16 00:00:00','2024-10-16 12:52:16',NULL,'Preserve in tight container','4'),
(34,'1','LAX/1024/034','','2','','','16','','','','5','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','5','2','','10','1','0','1','0','0','0','2024-10-16 00:00:00','2024-10-16 13:27:23',NULL,'Store protect from moisture at temperature not exceeding 30°C','2'),
(35,'1','LAX/1024/035','','2','','','16','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','25','1','','25','1','0','1','0','0','0','2024-10-16 00:00:00','2024-10-16 13:27:29',NULL,'Store protect from moisture at temperature not exceeding 30°C','2'),
(36,'1','LAX/1024/036','','2','','','16','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','25','1','','25','1','0','1','0','0','0','2024-10-16 00:00:00','2024-10-16 13:27:25',NULL,'Store protect from moisture at temperature not exceeding 30°C','2'),
(37,'1','LAX/1024/037','','2','','','16','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','25','1','','25','0','0','1','0','0','0','2024-10-16 00:00:00','2024-10-16 13:27:30',NULL,'Store protect from moisture at temperature not exceeding 30°C','2'),
(38,'1','LAX/1024/038','','2','','','16','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','25','2','','50','0','0','1','0','0','0','2024-10-16 00:00:00','2024-10-16 13:27:32',NULL,'Store protect from moisture at temperature not exceeding 30°C','2'),
(39,'1','LAX/1024/039','','1','','','16','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','BP','25','14','','350','1','0','1','0','0','0','2024-10-16 00:00:00','2024-10-16 13:30:57',NULL,'In an air tight container','1'),
(40,'1','LAX/1024/040','','1','','','17','','','','25','2024-10-01 00:00:00','2029-09-01 00:00:00','39','0','','','','BP','25','20','','500','0','0','1','0','0','0','2024-10-16 00:00:00','2024-10-16 13:46:12',NULL,'In an air tight container','1'),
(41,'1','LAX/1024/041','','1','','','19','','','','25','2024-10-01 00:00:00','2029-09-01 00:00:00','39','0','','','','BP','25','20','','500','0','0','1','0','0','0','2024-10-16 00:00:00','2024-10-16 13:46:14',NULL,'In an air tight container','1'),
(42,'1','LAX/1024/042','','1','','','20','','','','25','2024-10-01 00:00:00','2029-09-01 00:00:00','39','0','','','','BP','25','20','','500','0','0','1','0','0','0','2024-10-16 00:00:00','2024-10-16 13:46:15',NULL,'In an air tight container','1'),
(43,'1','LAX/1024/043','','1','','','21','','','','25','2024-10-01 00:00:00','2029-09-01 00:00:00','39','0','','','','BP','25','20','','500','0','0','1','0','0','0','2024-10-16 00:00:00','2024-10-16 13:46:17',NULL,'In an air tight container','1'),
(44,'1','LAX/1024/044','','1','','','23','','','','25','2024-10-01 00:00:00','2029-09-01 00:00:00','39','0','','','','BP','25','20','','500','0','0','1','0','0','0','2024-10-16 00:00:00','2024-10-16 13:46:18',NULL,'In an air tight container','1');
/*!40000 ALTER TABLE `generateqr` ENABLE KEYS */;

-- 
-- Definition of generateqrsr
-- 

DROP TABLE IF EXISTS `generateqrsr`;
CREATE TABLE IF NOT EXISTS `generateqrsr` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `contno` varchar(1000) DEFAULT '',
  `qrid` varchar(1000) DEFAULT '',
  `tarewt` varchar(1000) DEFAULT '',
  `grosswt` varchar(1000) DEFAULT '',
  `uninum` text,
  `sscc` text,
  `fdigit` varchar(50) DEFAULT NULL,
  `preview` varchar(50) DEFAULT NULL,
  `ssccrs` varchar(50) DEFAULT '0',
  `qrsrtqty` varchar(50) DEFAULT '0',
  `batchid` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=440 DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table generateqrsr
-- 

/*!40000 ALTER TABLE `generateqrsr` DISABLE KEYS */;
INSERT INTO `generateqrsr`(`id`,`contno`,`qrid`,`tarewt`,`grosswt`,`uninum`,`sscc`,`fdigit`,`preview`,`ssccrs`,`qrsrtqty`,`batchid`) VALUES
(1,'1/20','1','2.2','27.2','001','089061816400090011','0','0','0','25','4'),
(2,'2/20','1','2.2','27.2','002','089061816400090020','0','0','0','25','4'),
(3,'3/20','1','2.2','27.2','003','089061816400090039','0','0','0','25','4'),
(4,'4/20','1','2.2','27.2','004','089061816400090048','0','0','0','25','4'),
(5,'5/20','1','2.2','27.2','005','089061816400090057','0','0','0','25','4'),
(6,'6/20','1','2.2','27.2','006','089061816400090066','0','0','0','25','4'),
(7,'7/20','1','2.2','27.2','007','089061816400090075','0','0','0','25','4'),
(8,'8/20','1','2.2','27.2','008','089061816400090084','0','0','0','25','4'),
(9,'9/20','1','2.2','27.2','009','089061816400090093','0','0','0','25','4'),
(10,'10/20','1','2.2','27.2','010','089061816400090109','0','0','0','25','4'),
(11,'11/20','1','2.2','27.2','011','089061816400090118','0','0','0','25','4'),
(12,'12/20','1','2.2','27.2','012','089061816400090127','0','0','0','25','4'),
(13,'13/20','1','2.2','27.2','013','089061816400090136','0','0','0','25','4'),
(14,'14/20','1','2.2','27.2','014','089061816400090145','0','0','0','25','4'),
(15,'15/20','1','2.2','27.2','015','089061816400090154','0','0','0','25','4'),
(16,'16/20','1','2.2','27.2','016','089061816400090163','0','0','0','25','4'),
(17,'17/20','1','2.2','27.2','017','089061816400090172','0','0','0','25','4'),
(18,'18/20','1','2.2','27.2','018','089061816400090181','0','0','0','25','4'),
(19,'19/20','1','2.2','27.2','019','089061816400090190','0','0','0','25','4'),
(20,'20/20','1','2.2','27.2','020','089061816400090206','0','0','0','25','4'),
(21,'1/8','2','4.25','29.25','001','089061816400540011','0','0','0','25','9'),
(22,'2/8','2','4.25','29.25','002','089061816400540020','0','0','0','25','9'),
(23,'3/8','2','4.25','29.25','003','089061816400540039','0','0','0','25','9'),
(24,'4/8','2','4.25','29.25','004','089061816400540048','0','0','0','25','9'),
(25,'5/8','2','4.25','29.25','005','089061816400540057','0','0','0','25','9'),
(26,'6/8','2','4.25','29.25','006','089061816400540066','0','0','0','25','9'),
(27,'7/8','2','4.25','29.25','007','089061816400540075','0','0','0','25','9'),
(28,'8/8','2','4.25','29.25','008','089061816400540084','0','0','0','25','9'),
(29,'1/12','3','2.8','27.8','021','089061816400090215','0','0','0','25','5'),
(30,'2/12','3','2.8','27.8','022','089061816400090224','0','0','0','25','5'),
(31,'3/12','3','2.8','27.8','023','089061816400090233','0','0','0','25','5'),
(32,'4/12','3','2.8','27.8','024','089061816400090242','0','0','0','25','5'),
(33,'5/12','3','2.8','27.8','025','089061816400090251','0','0','0','25','5'),
(34,'6/12','3','2.8','27.8','026','089061816400090260','0','0','0','25','5'),
(35,'7/12','3','2.8','27.8','027','089061816400090279','0','0','0','25','5'),
(36,'8/12','3','2.8','27.8','028','089061816400090288','0','0','0','25','5'),
(37,'9/12','3','2.8','27.8','029','089061816400090297','0','0','0','25','5'),
(38,'10/12','3','2.8','27.8','030','089061816400090303','0','0','0','25','5'),
(39,'11/12','3','2.8','27.8','031','089061816400090312','0','0','0','25','5'),
(40,'12/12','3','2.8','27.8','032','089061816400090321','0','0','0','25','5'),
(41,'1/2','4','2.8','27.8','033','089061816400090330','0','0','0','25','5'),
(42,'2/2','4','2.8','27.8','034','089061816400090349','0','0','0','25','5'),
(43,'1/1','5','2.8','27.8','035','089061816400090358','0','0','0','25','5'),
(44,'1/20','6','2.2','27.2','036','089061816400090367','0','0','0','25','6'),
(45,'2/20','6','2.2','27.2','037','089061816400090376','0','0','0','25','6'),
(46,'3/20','6','2.2','27.2','038','089061816400090385','0','0','0','25','6'),
(47,'4/20','6','2.2','27.2','039','089061816400090394','0','0','0','25','6'),
(48,'5/20','6','2.2','27.2','040','089061816400090400','0','0','0','25','6'),
(49,'6/20','6','2.2','27.2','041','089061816400090419','0','0','0','25','6'),
(50,'7/20','6','2.2','27.2','042','089061816400090428','0','0','0','25','6'),
(51,'8/20','6','2.2','27.2','043','089061816400090437','0','0','0','25','6'),
(52,'9/20','6','2.2','27.2','044','089061816400090446','0','0','0','25','6'),
(53,'10/20','6','2.2','27.2','045','089061816400090455','0','0','0','25','6'),
(54,'11/20','6','2.2','27.2','046','089061816400090464','0','0','0','25','6'),
(55,'12/20','6','2.2','27.2','047','089061816400090473','0','0','0','25','6'),
(56,'13/20','6','2.2','27.2','048','089061816400090482','0','0','0','25','6'),
(57,'14/20','6','2.2','27.2','049','089061816400090491','0','0','0','25','6'),
(58,'15/20','6','2.2','27.2','050','089061816400090507','0','0','0','25','6'),
(59,'16/20','6','2.2','27.2','051','089061816400090516','0','0','0','25','6'),
(60,'17/20','6','2.2','27.2','052','089061816400090525','0','0','0','25','6'),
(61,'18/20','6','2.2','27.2','053','089061816400090534','0','0','0','25','6'),
(62,'19/20','6','2.2','27.2','054','089061816400090543','0','0','0','25','6'),
(63,'20/20','6','2.2','27.2','055','089061816400090552','0','0','0','25','6'),
(64,'1/4','7','2.8','27.8','056','089061816400090561','0','0','0','25','5'),
(65,'2/4','7','2.8','27.8','057','089061816400090570','0','0','0','25','5'),
(66,'3/4','7','2.8','27.8','058','089061816400090589','0','0','0','25','5'),
(67,'4/4','7','2.8','27.8','059','089061816400090598','0','0','0','25','5'),
(68,'1/1','8','0.25','5.25','060','089061816400090604','0','0','0','5','5'),
(88,'1/40','10','0.25','5.25','061','089061816400090613','0','0','0','5','11'),
(89,'2/40','10','0.25','5.25','062','089061816400090622','0','0','0','5','11'),
(90,'3/40','10','0.25','5.25','063','089061816400090631','0','0','0','5','11'),
(91,'4/40','10','0.25','5.25','064','089061816400090640','0','0','0','5','11'),
(92,'5/40','10','0.25','5.25','065','089061816400090659','0','0','0','5','11'),
(93,'6/40','10','0.25','5.25','066','089061816400090668','0','0','0','5','11'),
(94,'7/40','10','0.25','5.25','067','089061816400090677','0','0','0','5','11'),
(95,'8/40','10','0.25','5.25','068','089061816400090686','0','0','0','5','11'),
(96,'9/40','10','0.25','5.25','069','089061816400090695','0','0','0','5','11'),
(97,'10/40','10','0.25','5.25','070','089061816400090701','0','0','0','5','11'),
(98,'11/40','10','0.25','5.25','071','089061816400090710','0','0','0','5','11'),
(99,'12/40','10','0.25','5.25','072','089061816400090729','0','0','0','5','11'),
(100,'13/40','10','0.25','5.25','073','089061816400090738','0','0','0','5','11'),
(101,'14/40','10','0.25','5.25','074','089061816400090747','0','0','0','5','11'),
(102,'15/40','10','0.25','5.25','075','089061816400090756','0','0','0','5','11'),
(103,'16/40','10','0.25','5.25','076','089061816400090765','0','0','0','5','11'),
(104,'17/40','10','0.25','5.25','077','089061816400090774','0','0','0','5','11'),
(105,'18/40','10','0.25','5.25','078','089061816400090783','0','0','0','5','11'),
(106,'19/40','10','0.25','5.25','079','089061816400090792','0','0','0','5','11'),
(107,'20/40','10','0.25','5.25','080','089061816400090808','0','0','0','5','11'),
(108,'21/40','10','0.25','5.25','081','089061816400090817','0','0','0','5','11'),
(109,'22/40','10','0.25','5.25','082','089061816400090826','0','0','0','5','11'),
(110,'23/40','10','0.25','5.25','083','089061816400090835','0','0','0','5','11'),
(111,'24/40','10','0.25','5.25','084','089061816400090844','0','0','0','5','11'),
(112,'25/40','10','0.25','5.25','085','089061816400090853','0','0','0','5','11'),
(113,'26/40','10','0.25','5.25','086','089061816400090862','0','0','0','5','11'),
(114,'27/40','10','0.25','5.25','087','089061816400090871','0','0','0','5','11'),
(115,'28/40','10','0.25','5.25','088','089061816400090880','0','0','0','5','11'),
(116,'29/40','10','0.25','5.25','089','089061816400090899','0','0','0','5','11'),
(117,'30/40','10','0.25','5.25','090','089061816400090905','0','0','0','5','11'),
(118,'31/40','10','0.25','5.25','091','089061816400090914','0','0','0','5','11'),
(119,'32/40','10','0.25','5.25','092','089061816400090923','0','0','0','5','11'),
(120,'33/40','10','0.25','5.25','093','089061816400090932','0','0','0','5','11'),
(121,'34/40','10','0.25','5.25','094','089061816400090941','0','0','0','5','11'),
(122,'35/40','10','0.25','5.25','095','089061816400090950','0','0','0','5','11'),
(123,'36/40','10','0.25','5.25','096','089061816400090969','0','0','0','5','11'),
(124,'37/40','10','0.25','5.25','097','089061816400090978','0','0','0','5','11'),
(125,'38/40','10','0.25','5.25','098','089061816400090987','0','0','0','5','11'),
(126,'39/40','10','0.25','5.25','099','089061816400090996','0','0','0','5','11'),
(127,'40/40','10','0.25','5.25','100','089061816400091001','0','0','0','5','11'),
(128,'1/20','11','2.8','27.8','101','089061816400091010','0','0','0','25','10'),
(129,'2/20','11','2.8','27.8','102','089061816400091029','0','0','0','25','10'),
(130,'3/20','11','2.8','27.8','103','089061816400091038','0','0','0','25','10'),
(131,'4/20','11','2.8','27.8','104','089061816400091047','0','0','0','25','10'),
(132,'5/20','11','2.8','27.8','105','089061816400091056','0','0','0','25','10'),
(133,'6/20','11','2.8','27.8','106','089061816400091065','0','0','0','25','10'),
(134,'7/20','11','2.8','27.8','107','089061816400091074','0','0','0','25','10'),
(135,'8/20','11','2.8','27.8','108','089061816400091083','0','0','0','25','10'),
(136,'9/20','11','2.8','27.8','109','089061816400091092','0','0','0','25','10'),
(137,'10/20','11','2.8','27.8','110','089061816400091108','0','0','0','25','10'),
(138,'11/20','11','2.8','27.8','111','089061816400091117','0','0','0','25','10'),
(139,'12/20','11','2.8','27.8','112','089061816400091126','0','0','0','25','10'),
(140,'13/20','11','2.8','27.8','113','089061816400091135','0','0','0','25','10'),
(141,'14/20','11','2.8','27.8','114','089061816400091144','0','0','0','25','10'),
(142,'15/20','11','2.8','27.8','115','089061816400091153','0','0','0','25','10'),
(143,'16/20','11','2.8','27.8','116','089061816400091162','0','0','0','25','10'),
(144,'17/20','11','2.8','27.8','117','089061816400091171','0','0','0','25','10'),
(145,'18/20','11','2.8','27.8','118','089061816400091180','0','0','0','25','10'),
(146,'19/20','11','2.8','27.8','119','089061816400091199','0','0','0','25','10'),
(147,'20/20','11','2.8','27.8','120','089061816400091205','0','0','0','25','10'),
(148,'1/4','12','12.25','17.25','001','0123456780019','0','0','0','5','12'),
(149,'2/4','12','12.25','17.25','002','0123456780026','0','0','0','5','12'),
(150,'3/4','12','12.25','17.25','003','0123456780033','0','0','0','5','12'),
(151,'4/4','12','12.25','17.25','004','0123456780040','0','0','0','5','12'),
(152,'1/1','13','0.25','5.25','121','089061816400091214','0','0','0','5','5'),
(153,'1/2','14','0.25','5.25','122','089061816400091223','0','0','0','5','5'),
(154,'2/2','14','0.25','5.25','123','089061816400091232','0','0','0','5','5'),
(155,'1/1','15','0.25','5.25','124','089061816400091241','0','0','0','5','5'),
(156,'1/20','16','2.2','27.2','125','089061816400091250','0','0','0','25','7'),
(157,'2/20','16','2.2','27.2','126','089061816400091269','0','0','0','25','7'),
(158,'3/20','16','2.2','27.2','127','089061816400091278','0','0','0','25','7'),
(159,'4/20','16','2.2','27.2','128','089061816400091287','0','0','0','25','7'),
(160,'5/20','16','2.2','27.2','129','089061816400091296','0','0','0','25','7'),
(161,'6/20','16','2.2','27.2','130','089061816400091302','0','0','0','25','7'),
(162,'7/20','16','2.2','27.2','131','089061816400091311','0','0','0','25','7'),
(163,'8/20','16','2.2','27.2','132','089061816400091320','0','0','0','25','7'),
(164,'9/20','16','2.2','27.2','133','089061816400091339','0','0','0','25','7'),
(165,'10/20','16','2.2','27.2','134','089061816400091348','0','0','0','25','7'),
(166,'11/20','16','2.2','27.2','135','089061816400091357','0','0','0','25','7'),
(167,'12/20','16','2.2','27.2','136','089061816400091366','0','0','0','25','7'),
(168,'13/20','16','2.2','27.2','137','089061816400091375','0','0','0','25','7'),
(169,'14/20','16','2.2','27.2','138','089061816400091384','0','0','0','25','7'),
(170,'15/20','16','2.2','27.2','139','089061816400091393','0','0','0','25','7'),
(171,'16/20','16','2.2','27.2','140','089061816400091409','0','0','0','25','7'),
(172,'17/20','16','2.2','27.2','141','089061816400091418','0','0','0','25','7'),
(173,'18/20','16','2.2','27.2','142','089061816400091427','0','0','0','25','7'),
(174,'19/20','16','2.2','27.2','143','089061816400091436','0','0','0','25','7'),
(175,'20/20','16','2.2','27.2','144','089061816400091445','0','0','0','25','7'),
(176,'1/20','17','2.2','27.2','145','089061816400091454','0','0','0','25','8'),
(177,'2/20','17','2.2','27.2','146','089061816400091463','0','0','0','25','8'),
(178,'3/20','17','2.2','27.2','147','089061816400091472','0','0','0','25','8'),
(179,'4/20','17','2.2','27.2','148','089061816400091481','0','0','0','25','8'),
(180,'5/20','17','2.2','27.2','149','089061816400091490','0','0','0','25','8'),
(181,'6/20','17','2.2','27.2','150','089061816400091506','0','0','0','25','8'),
(182,'7/20','17','2.2','27.2','151','089061816400091515','0','0','0','25','8'),
(183,'8/20','17','2.2','27.2','152','089061816400091524','0','0','0','25','8'),
(184,'9/20','17','2.2','27.2','153','089061816400091533','0','0','0','25','8'),
(185,'10/20','17','2.2','27.2','154','089061816400091542','0','0','0','25','8'),
(186,'11/20','17','2.2','27.2','155','089061816400091551','0','0','0','25','8'),
(187,'12/20','17','2.2','27.2','156','089061816400091560','0','0','0','25','8'),
(188,'13/20','17','2.2','27.2','157','089061816400091579','0','0','0','25','8'),
(189,'14/20','17','2.2','27.2','158','089061816400091588','0','0','0','25','8'),
(190,'15/20','17','2.2','27.2','159','089061816400091597','0','0','0','25','8'),
(191,'16/20','17','2.2','27.2','160','089061816400091603','0','0','0','25','8'),
(192,'17/20','17','2.2','27.2','161','089061816400091612','0','0','0','25','8'),
(193,'18/20','17','2.2','27.2','162','089061816400091621','0','0','0','25','8'),
(194,'19/20','17','2.2','27.2','163','089061816400091630','0','0','0','25','8'),
(195,'20/20','17','2.2','27.2','164','089061816400091649','0','0','0','25','8'),
(196,'1/12','18','2.2','27.2','165','089061816400091658','0','0','0','25','11'),
(197,'2/12','18','2.2','27.2','166','089061816400091667','0','0','0','25','11'),
(198,'3/12','18','2.2','27.2','167','089061816400091676','0','0','0','25','11'),
(199,'4/12','18','2.2','27.2','168','089061816400091685','0','0','0','25','11'),
(200,'5/12','18','2.2','27.2','169','089061816400091694','0','0','0','25','11'),
(201,'6/12','18','2.2','27.2','170','089061816400091700','0','0','0','25','11'),
(202,'7/12','18','2.2','27.2','171','089061816400091719','0','0','0','25','11'),
(203,'8/12','18','2.2','27.2','172','089061816400091728','0','0','0','25','11'),
(204,'9/12','18','2.2','27.2','173','089061816400091737','0','0','0','25','11'),
(205,'10/12','18','2.2','27.2','174','089061816400091746','0','0','0','25','11'),
(206,'11/12','18','2.2','27.2','175','089061816400091755','0','0','0','25','11'),
(207,'12/12','18','2.2','27.2','176','089061816400091764','0','0','0','25','11'),
(248,'1/1','20','3.3','28.3','001','089061816400230017','0','0','0','25','24'),
(269,'1/1','22','3.3','28.3','002','089061816400230026','0','0','0','25','13'),
(270,'1/12','24','2.8','27.8','237','089061816400092374','0','0','0','25','35'),
(271,'2/12','24','2.8','27.8','238','089061816400092383','0','0','0','25','35'),
(272,'3/12','24','2.8','27.8','239','089061816400092392','0','0','0','25','35'),
(273,'4/12','24','2.8','27.8','240','089061816400092408','0','0','0','25','35'),
(274,'5/12','24','2.8','27.8','241','089061816400092417','0','0','0','25','35'),
(275,'6/12','24','2.8','27.8','242','089061816400092426','0','0','0','25','35'),
(276,'7/12','24','2.8','27.8','243','089061816400092435','0','0','0','25','35'),
(277,'8/12','24','2.8','27.8','244','089061816400092444','0','0','0','25','35'),
(278,'9/12','24','2.8','27.8','245','089061816400092453','0','0','0','25','35'),
(279,'10/12','24','2.8','27.8','246','089061816400092462','0','0','0','25','35'),
(280,'11/12','24','2.8','27.8','247','089061816400092471','0','0','0','25','35'),
(281,'12/12','24','2.8','27.8','248','089061816400092480','0','0','0','25','35'),
(283,'1/1','26','3.3','28.3','003','089061816400230035','0','0','0','25','13'),
(284,'1/1','27','3.3','28.3','004','089061816400230044','0','0','0','25','24'),
(285,'1/1','28','0.9','5.9','249','089061816400092499','0','0','0','5','16'),
(286,'1/2','29','3.3','28.3','005','089061816400230053','0','0','0','25','24'),
(287,'2/2','29','3.3','28.3','006','089061816400230062','0','0','0','25','24'),
(288,'1/1','30','3.3','28.3','007','089061816400230071','0','0','0','25','24'),
(289,'1/1','31','0.25','5.25','008','089061816400230080','0','0','0','5','13'),
(290,'1/9','32','3.3','28.3','009','089061816400230099','0','0','0','25','13'),
(291,'2/9','32','3.3','28.3','010','089061816400230105','0','0','0','25','13'),
(292,'3/9','32','3.3','28.3','011','089061816400230114','0','0','0','25','13'),
(293,'4/9','32','3.3','28.3','012','089061816400230123','0','0','0','25','13'),
(294,'5/9','32','3.3','28.3','013','089061816400230132','0','0','0','25','13'),
(295,'6/9','32','3.3','28.3','014','089061816400230141','0','0','0','25','13'),
(296,'7/9','32','3.3','28.3','015','089061816400230150','0','0','0','25','13'),
(297,'8/9','32','3.3','28.3','016','089061816400230169','0','0','0','25','13'),
(298,'9/9','32','3.3','28.3','017','089061816400230178','0','0','0','25','13'),
(299,'1/20','33','2.2','27.2','250','089061816400092505','0','0','0','25','15'),
(300,'2/20','33','2.2','27.2','251','089061816400092514','0','0','0','25','15'),
(301,'3/20','33','2.2','27.2','252','089061816400092523','0','0','0','25','15'),
(302,'4/20','33','2.2','27.2','253','089061816400092532','0','0','0','25','15'),
(303,'5/20','33','2.2','27.2','254','089061816400092541','0','0','0','25','15'),
(304,'6/20','33','2.2','27.2','255','089061816400092550','0','0','0','25','15'),
(305,'7/20','33','2.2','27.2','256','089061816400092569','0','0','0','25','15'),
(306,'8/20','33','2.2','27.2','257','089061816400092578','0','0','0','25','15'),
(307,'9/20','33','2.2','27.2','258','089061816400092587','0','0','0','25','15'),
(308,'10/20','33','2.2','27.2','259','089061816400092596','0','0','0','25','15'),
(309,'11/20','33','2.2','27.2','260','089061816400092602','0','0','0','25','15'),
(310,'12/20','33','2.2','27.2','261','089061816400092611','0','0','0','25','15'),
(311,'13/20','33','2.2','27.2','262','089061816400092620','0','0','0','25','15'),
(312,'14/20','33','2.2','27.2','263','089061816400092639','0','0','0','25','15'),
(313,'15/20','33','2.2','27.2','264','089061816400092648','0','0','0','25','15'),
(314,'16/20','33','2.2','27.2','265','089061816400092657','0','0','0','25','15'),
(315,'17/20','33','2.2','27.2','266','089061816400092666','0','0','0','25','15'),
(316,'18/20','33','2.2','27.2','267','089061816400092675','0','0','0','25','15'),
(317,'19/20','33','2.2','27.2','268','089061816400092684','0','0','0','25','15'),
(318,'20/20','33','2.2','27.2','269','089061816400092693','0','0','0','25','15'),
(319,'1/2','34','0.25','5.25','270','089061816400092709','0','0','0','5','16'),
(320,'2/2','34','0.25','5.25','271','089061816400092718','0','0','0','5','16'),
(321,'1/1','35','2.8','27.8','272','089061816400092727','0','0','0','25','16'),
(322,'1/1','36','2.8','27.8','273','089061816400092736','0','0','0','25','16'),
(323,'1/1','37','2.8','27.8','274','089061816400092745','0','0','0','25','16'),
(324,'1/2','38','2.8','27.8','275','089061816400092754','0','0','0','25','16'),
(325,'2/2','38','2.8','27.8','276','089061816400092763','0','0','0','25','16'),
(326,'1/14','39','2.8','27.8','277','089061816400092772','0','0','0','25','16'),
(327,'2/14','39','2.8','27.8','278','089061816400092781','0','0','0','25','16'),
(328,'3/14','39','2.8','27.8','279','089061816400092790','0','0','0','25','16'),
(329,'4/14','39','2.8','27.8','280','089061816400092806','0','0','0','25','16'),
(330,'5/14','39','2.8','27.8','281','089061816400092815','0','0','0','25','16'),
(331,'6/14','39','2.8','27.8','282','089061816400092824','0','0','0','25','16'),
(332,'7/14','39','2.8','27.8','283','089061816400092833','0','0','0','25','16'),
(333,'8/14','39','2.8','27.8','284','089061816400092842','0','0','0','25','16'),
(334,'9/14','39','2.8','27.8','285','089061816400092851','0','0','0','25','16'),
(335,'10/14','39','2.8','27.8','286','089061816400092860','0','0','0','25','16'),
(336,'11/14','39','2.8','27.8','287','089061816400092879','0','0','0','25','16'),
(337,'12/14','39','2.8','27.8','288','089061816400092888','0','0','0','25','16'),
(338,'13/14','39','2.8','27.8','289','089061816400092897','0','0','0','25','16'),
(339,'14/14','39','2.8','27.8','290','089061816400092903','0','0','0','25','16'),
(340,'1/20','40','2.2','27.2','291','089061816400092912','0','0','0','25','17'),
(341,'2/20','40','2.2','27.2','292','089061816400092921','0','0','0','25','17'),
(342,'3/20','40','2.2','27.2','293','089061816400092930','0','0','0','25','17'),
(343,'4/20','40','2.2','27.2','294','089061816400092949','0','0','0','25','17'),
(344,'5/20','40','2.2','27.2','295','089061816400092958','0','0','0','25','17'),
(345,'6/20','40','2.2','27.2','296','089061816400092967','0','0','0','25','17'),
(346,'7/20','40','2.2','27.2','297','089061816400092976','0','0','0','25','17'),
(347,'8/20','40','2.2','27.2','298','089061816400092985','0','0','0','25','17'),
(348,'9/20','40','2.2','27.2','299','089061816400092994','0','0','0','25','17'),
(349,'10/20','40','2.2','27.2','300','089061816400093009','0','0','0','25','17'),
(350,'11/20','40','2.2','27.2','301','089061816400093018','0','0','0','25','17'),
(351,'12/20','40','2.2','27.2','302','089061816400093027','0','0','0','25','17'),
(352,'13/20','40','2.2','27.2','303','089061816400093036','0','0','0','25','17'),
(353,'14/20','40','2.2','27.2','304','089061816400093045','0','0','0','25','17'),
(354,'15/20','40','2.2','27.2','305','089061816400093054','0','0','0','25','17'),
(355,'16/20','40','2.2','27.2','306','089061816400093063','0','0','0','25','17'),
(356,'17/20','40','2.2','27.2','307','089061816400093072','0','0','0','25','17'),
(357,'18/20','40','2.2','27.2','308','089061816400093081','0','0','0','25','17'),
(358,'19/20','40','2.2','27.2','309','089061816400093090','0','0','0','25','17'),
(359,'20/20','40','2.2','27.2','310','089061816400093106','0','0','0','25','17'),
(360,'1/20','41','2.2','27.2','311','089061816400093115','0','0','0','25','19'),
(361,'2/20','41','2.2','27.2','312','089061816400093124','0','0','0','25','19'),
(362,'3/20','41','2.2','27.2','313','089061816400093133','0','0','0','25','19'),
(363,'4/20','41','2.2','27.2','314','089061816400093142','0','0','0','25','19'),
(364,'5/20','41','2.2','27.2','315','089061816400093151','0','0','0','25','19'),
(365,'6/20','41','2.2','27.2','316','089061816400093160','0','0','0','25','19'),
(366,'7/20','41','2.2','27.2','317','089061816400093179','0','0','0','25','19'),
(367,'8/20','41','2.2','27.2','318','089061816400093188','0','0','0','25','19'),
(368,'9/20','41','2.2','27.2','319','089061816400093197','0','0','0','25','19'),
(369,'10/20','41','2.2','27.2','320','089061816400093203','0','0','0','25','19'),
(370,'11/20','41','2.2','27.2','321','089061816400093212','0','0','0','25','19'),
(371,'12/20','41','2.2','27.2','322','089061816400093221','0','0','0','25','19'),
(372,'13/20','41','2.2','27.2','323','089061816400093230','0','0','0','25','19'),
(373,'14/20','41','2.2','27.2','324','089061816400093249','0','0','0','25','19'),
(374,'15/20','41','2.2','27.2','325','089061816400093258','0','0','0','25','19'),
(375,'16/20','41','2.2','27.2','326','089061816400093267','0','0','0','25','19'),
(376,'17/20','41','2.2','27.2','327','089061816400093276','0','0','0','25','19'),
(377,'18/20','41','2.2','27.2','328','089061816400093285','0','0','0','25','19'),
(378,'19/20','41','2.2','27.2','329','089061816400093294','0','0','0','25','19'),
(379,'20/20','41','2.2','27.2','330','089061816400093300','0','0','0','25','19'),
(380,'1/20','42','2.2','27.2','331','089061816400093319','0','0','0','25','20'),
(381,'2/20','42','2.2','27.2','332','089061816400093328','0','0','0','25','20'),
(382,'3/20','42','2.2','27.2','333','089061816400093337','0','0','0','25','20'),
(383,'4/20','42','2.2','27.2','334','089061816400093346','0','0','0','25','20'),
(384,'5/20','42','2.2','27.2','335','089061816400093355','0','0','0','25','20'),
(385,'6/20','42','2.2','27.2','336','089061816400093364','0','0','0','25','20'),
(386,'7/20','42','2.2','27.2','337','089061816400093373','0','0','0','25','20'),
(387,'8/20','42','2.2','27.2','338','089061816400093382','0','0','0','25','20'),
(388,'9/20','42','2.2','27.2','339','089061816400093391','0','0','0','25','20'),
(389,'10/20','42','2.2','27.2','340','089061816400093407','0','0','0','25','20'),
(390,'11/20','42','2.2','27.2','341','089061816400093416','0','0','0','25','20'),
(391,'12/20','42','2.2','27.2','342','089061816400093425','0','0','0','25','20'),
(392,'13/20','42','2.2','27.2','343','089061816400093434','0','0','0','25','20'),
(393,'14/20','42','2.2','27.2','344','089061816400093443','0','0','0','25','20'),
(394,'15/20','42','2.2','27.2','345','089061816400093452','0','0','0','25','20'),
(395,'16/20','42','2.2','27.2','346','089061816400093461','0','0','0','25','20'),
(396,'17/20','42','2.2','27.2','347','089061816400093470','0','0','0','25','20'),
(397,'18/20','42','2.2','27.2','348','089061816400093489','0','0','0','25','20'),
(398,'19/20','42','2.2','27.2','349','089061816400093498','0','0','0','25','20'),
(399,'20/20','42','2.2','27.2','350','089061816400093504','0','0','0','25','20'),
(400,'1/20','43','2.2','27.2','351','089061816400093513','0','0','0','25','21'),
(401,'2/20','43','2.2','27.2','352','089061816400093522','0','0','0','25','21'),
(402,'3/20','43','2.2','27.2','353','089061816400093531','0','0','0','25','21'),
(403,'4/20','43','2.2','27.2','354','089061816400093540','0','0','0','25','21'),
(404,'5/20','43','2.2','27.2','355','089061816400093559','0','0','0','25','21'),
(405,'6/20','43','2.2','27.2','356','089061816400093568','0','0','0','25','21'),
(406,'7/20','43','2.2','27.2','357','089061816400093577','0','0','0','25','21'),
(407,'8/20','43','2.2','27.2','358','089061816400093586','0','0','0','25','21'),
(408,'9/20','43','2.2','27.2','359','089061816400093595','0','0','0','25','21'),
(409,'10/20','43','2.2','27.2','360','089061816400093601','0','0','0','25','21'),
(410,'11/20','43','2.2','27.2','361','089061816400093610','0','0','0','25','21'),
(411,'12/20','43','2.2','27.2','362','089061816400093629','0','0','0','25','21'),
(412,'13/20','43','2.2','27.2','363','089061816400093638','0','0','0','25','21'),
(413,'14/20','43','2.2','27.2','364','089061816400093647','0','0','0','25','21'),
(414,'15/20','43','2.2','27.2','365','089061816400093656','0','0','0','25','21'),
(415,'16/20','43','2.2','27.2','366','089061816400093665','0','0','0','25','21'),
(416,'17/20','43','2.2','27.2','367','089061816400093674','0','0','0','25','21'),
(417,'18/20','43','2.2','27.2','368','089061816400093683','0','0','0','25','21'),
(418,'19/20','43','2.2','27.2','369','089061816400093692','0','0','0','25','21'),
(419,'20/20','43','2.2','27.2','370','089061816400093708','0','0','0','25','21'),
(420,'1/20','44','2.2','27.2','371','089061816400093717','0','0','0','25','23'),
(421,'2/20','44','2.2','27.2','372','089061816400093726','0','0','0','25','23'),
(422,'3/20','44','2.2','27.2','373','089061816400093735','0','0','0','25','23'),
(423,'4/20','44','2.2','27.2','374','089061816400093744','0','0','0','25','23'),
(424,'5/20','44','2.2','27.2','375','089061816400093753','0','0','0','25','23'),
(425,'6/20','44','2.2','27.2','376','089061816400093762','0','0','0','25','23'),
(426,'7/20','44','2.2','27.2','377','089061816400093771','0','0','0','25','23'),
(427,'8/20','44','2.2','27.2','378','089061816400093780','0','0','0','25','23'),
(428,'9/20','44','2.2','27.2','379','089061816400093799','0','0','0','25','23'),
(429,'10/20','44','2.2','27.2','380','089061816400093805','0','0','0','25','23'),
(430,'11/20','44','2.2','27.2','381','089061816400093814','0','0','0','25','23'),
(431,'12/20','44','2.2','27.2','382','089061816400093823','0','0','0','25','23'),
(432,'13/20','44','2.2','27.2','383','089061816400093832','0','0','0','25','23'),
(433,'14/20','44','2.2','27.2','384','089061816400093841','0','0','0','25','23'),
(434,'15/20','44','2.2','27.2','385','089061816400093850','0','0','0','25','23'),
(435,'16/20','44','2.2','27.2','386','089061816400093869','0','0','0','25','23'),
(436,'17/20','44','2.2','27.2','387','089061816400093878','0','0','0','25','23'),
(437,'18/20','44','2.2','27.2','388','089061816400093887','0','0','0','25','23'),
(438,'19/20','44','2.2','27.2','389','089061816400093896','0','0','0','25','23'),
(439,'20/20','44','2.2','27.2','390','089061816400093902','0','0','0','25','23');
/*!40000 ALTER TABLE `generateqrsr` ENABLE KEYS */;

-- 
-- Definition of logtable
-- 

DROP TABLE IF EXISTS `logtable`;
CREATE TABLE IF NOT EXISTS `logtable` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) DEFAULT NULL,
  `action` varchar(1000) DEFAULT NULL,
  `time` datetime DEFAULT NULL,
  `userid` varchar(50) DEFAULT NULL,
  `tablename` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=665 DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table logtable
-- 

/*!40000 ALTER TABLE `logtable` DISABLE KEYS */;
INSERT INTO `logtable`(`id`,`username`,`action`,`time`,`userid`,`tablename`) VALUES
(1,NULL,'User Logged In','2024-08-03 11:13:36','39','Login In'),
(2,NULL,'New Company Added','2024-08-03 11:21:56','39','Company Unit'),
(3,NULL,'User Logged In','2024-08-03 12:08:14','39','Login In'),
(4,NULL,'User Logged In','2024-08-03 12:40:03','36','Login In'),
(5,NULL,'Company Updated','2024-08-03 12:43:56','36','Company Unit'),
(6,NULL,'Company Unit Approved','2024-08-03 12:47:53','36','Approval'),
(7,NULL,'User Logged In','2024-08-03 12:50:13','39','Login In'),
(8,NULL,'New Product Added','2024-08-03 12:54:21','39','Product'),
(9,NULL,'New Product Added','2024-08-03 12:58:20','39','Product'),
(10,NULL,'User Logged In','2024-08-03 13:02:08','37','Login In'),
(11,NULL,'New Product Added','2024-08-03 13:04:29','39','Product'),
(12,NULL,'User Logged Out','2024-08-03 13:06:28','37','Log Out'),
(13,NULL,'New Product Added','2024-08-03 13:06:53','39','Product'),
(14,NULL,'New Product Added','2024-08-03 13:10:05','39','Product'),
(15,NULL,'New Product Added','2024-08-03 13:12:42','39','Product'),
(16,NULL,'Product Updated','2024-08-03 13:14:19','39','Product'),
(17,NULL,'User Logged In','2024-08-03 13:26:49','39','Login In'),
(18,NULL,'Product Updated','2024-08-03 13:27:27','39','Product'),
(19,NULL,'Product Updated','2024-08-03 13:28:14','39','Product'),
(20,NULL,'User Logged In','2024-08-03 13:37:47','39','Login In'),
(21,NULL,'User Logged In','2024-08-03 14:03:20','39','Login In'),
(22,NULL,'User Logged In','2024-08-03 15:16:31','39','Login In'),
(23,NULL,'User Logged In','2024-08-03 15:55:12','36','Login In'),
(24,NULL,'User Logged In','2024-08-03 15:58:31','39','Login In'),
(25,NULL,'User Logged In','2024-08-03 16:23:49','39','Login In'),
(26,NULL,'New Product Added','2024-08-03 16:29:29','39','Product'),
(27,NULL,'User Logged In','2024-08-03 16:31:57','37','Login In'),
(28,NULL,'Product Approved','2024-08-03 16:33:10','37','Approval'),
(29,NULL,'Product Approved','2024-08-03 16:33:41','37','Approval'),
(30,NULL,'Product Approved','2024-08-03 16:36:24','37','Approval'),
(31,NULL,'Product Approved','2024-08-03 16:38:19','37','Approval'),
(32,NULL,'Product Updated','2024-08-03 16:43:31','39','Product'),
(33,NULL,'User Logged Out','2024-08-03 16:43:34','37','Log Out'),
(34,NULL,'User Logged In','2024-08-03 18:22:59','36','Login In'),
(35,NULL,'User Logged In','2024-08-04 11:41:05','37','Login In'),
(36,NULL,'User Logged In','2024-08-04 12:39:57','39','Login In'),
(37,NULL,'User Logged In','2024-08-04 12:55:20','37','Login In'),
(38,NULL,'Product Approved','2024-08-04 12:59:43','37','Approval'),
(39,NULL,'Product Rejected','2024-08-04 13:03:26','37','Approval'),
(40,NULL,'Product Approved','2024-08-04 13:07:16','37','Approval'),
(41,NULL,'Product Updated','2024-08-04 13:08:22','39','Product'),
(42,NULL,'User Logged In','2024-08-04 14:31:37','37','Login In'),
(43,NULL,'Product Approved','2024-08-04 14:31:49','37','Approval'),
(44,NULL,'User Logged In','2024-08-06 12:05:10','39','Login In'),
(45,NULL,'Batch Added','2024-08-06 12:07:13','39','Batch'),
(46,NULL,'Batch Updated','2024-08-06 12:09:55','39','Batch'),
(47,NULL,'User Logged In','2024-08-07 11:54:04','39','Login In'),
(48,NULL,'Batch Added','2024-08-07 11:56:35','39','Batch'),
(49,NULL,'Batch Added','2024-08-07 11:58:02','39','Batch'),
(50,NULL,'Batch Updated','2024-08-07 12:00:21','39','Batch'),
(51,NULL,'Batch Updated','2024-08-07 12:00:29','39','Batch'),
(52,NULL,'User Logged In','2024-08-09 12:06:33','39','Login In'),
(53,NULL,'Batch Data Deleted','2024-08-09 12:06:48','39','Batch'),
(54,NULL,'Batch Data Deleted','2024-08-09 12:06:52','39','Batch'),
(55,NULL,'Batch Data Deleted','2024-08-09 12:06:55','39','Batch'),
(56,NULL,'Batch Added','2024-08-09 12:08:25','39','Batch'),
(57,NULL,'Batch Added','2024-08-09 12:09:18','39','Batch'),
(58,NULL,'Batch Added','2024-08-09 12:09:59','39','Batch'),
(59,NULL,'Batch Added','2024-08-09 12:10:43','39','Batch'),
(60,NULL,'Batch Added','2024-08-09 12:11:29','39','Batch'),
(61,NULL,'User Logged In','2024-08-09 16:11:09','37','Login In'),
(62,NULL,'Batch Delete Approved','2024-08-09 16:12:02','37','Approval'),
(63,NULL,'Batch Delete Approved','2024-08-09 16:12:31','37','Approval'),
(64,NULL,'Batch Delete Approved','2024-08-09 16:12:53','37','Approval'),
(65,NULL,'Batch Approved','2024-08-09 16:14:10','37','Approval'),
(66,NULL,'Batch Approved','2024-08-09 16:14:53','37','Approval'),
(67,NULL,'Batch Approved','2024-08-09 16:15:42','37','Approval'),
(68,NULL,'Batch Approved','2024-08-09 16:16:25','37','Approval'),
(69,NULL,'Batch Approved','2024-08-09 16:16:43','37','Approval'),
(70,NULL,'User Logged Out','2024-08-09 16:17:27','37','Log Out'),
(71,NULL,'User Logged In','2024-08-10 12:44:41','39','Login In'),
(72,NULL,'Alias Product Added','2024-08-10 12:45:56','39','Alias Product'),
(73,NULL,'Alias Product Added','2024-08-10 12:47:08','39','Alias Product'),
(74,NULL,'User Logged In','2024-08-10 13:44:57','39','Login In'),
(75,NULL,'User Logged In','2024-08-10 16:42:52','37','Login In'),
(76,NULL,'Alias Product Approved','2024-08-10 16:45:02','37','Approval'),
(77,NULL,'Alias Product Approved','2024-08-10 16:45:04','37','Approval'),
(78,NULL,'User Logged Out','2024-08-10 16:45:12','37','Log Out'),
(79,NULL,'User Logged In','2024-08-11 15:05:32','39','Login In'),
(80,NULL,'Storage Condition Added','2024-08-11 15:07:16','39','Storage Condition'),
(81,NULL,'User Logged In','2024-08-11 15:58:31','39','Login In'),
(82,NULL,'User Logged In','2024-08-11 16:11:03','37','Login In'),
(83,NULL,'Storage Condition Approved','2024-08-11 16:12:16','37','Storage Condition'),
(84,NULL,'User Logged Out','2024-08-11 16:12:23','37','Log Out'),
(85,NULL,'QR generated','2024-08-11 16:13:17','39','Generateqr'),
(86,NULL,'User Logged In','2024-08-11 16:15:33','37','Login In'),
(87,NULL,'Generateqr Approved','2024-08-11 16:16:38','37','Approval'),
(88,NULL,'User Logged Out','2024-08-11 16:16:53','37','Log Out'),
(89,NULL,'Single Print Had Taken','2024-08-11 16:17:02','39','generateqrsr'),
(90,NULL,'Single Print Had Taken','2024-08-11 16:17:30','39','generateqrsr'),
(91,NULL,'Single Print Had Taken','2024-08-11 16:18:25','39','generateqrsr'),
(92,NULL,'Single Print Had Taken','2024-08-11 16:18:42','39','generateqrsr'),
(93,NULL,'Single Print Had Taken','2024-08-11 16:34:49','39','generateqrsr'),
(94,NULL,'Storage Condition Edited','2024-08-11 16:39:25','39','Storage Condition'),
(95,NULL,'User Logged Out','2024-08-11 16:59:14','39','Log Out'),
(96,NULL,'User Logged In','2024-08-11 16:59:16','39','Login In'),
(97,NULL,'Single Print Had Taken','2024-08-11 16:59:36','39','generateqrsr'),
(98,NULL,'User Logged In','2024-08-11 17:08:32','36','Login In'),
(99,NULL,'Single Print Had Taken','2024-08-11 17:09:38','36','generateqrsr'),
(100,NULL,'Multiple Print Had Taken','2024-08-11 17:10:28','36','generateqrsr'),
(101,NULL,'User Logged In','2024-08-12 16:31:35','36','Login In'),
(102,NULL,'Single Print Had Taken','2024-08-12 16:32:15','36','generateqrsr'),
(103,NULL,'Multiple Print Had Taken','2024-08-12 16:32:28','36','generateqrsr'),
(104,NULL,'Single Print Had Taken','2024-08-12 16:51:50','36','generateqrsr'),
(105,NULL,'Single Print Had Taken','2024-08-12 16:55:45','36','generateqrsr'),
(106,NULL,'Multiple Print Had Taken','2024-08-12 16:55:59','36','generateqrsr'),
(107,NULL,'User Logged In','2024-08-14 11:51:23','39','Login In'),
(108,NULL,'Single Print Had Taken','2024-08-14 11:51:41','39','generateqrsr'),
(109,NULL,'Single Print Had Taken','2024-08-14 11:51:43','39','generateqrsr'),
(110,NULL,'User Logged In','2024-08-14 13:30:45','39','Login In'),
(111,NULL,'User Logged In','2024-08-14 19:40:44','39','Login In'),
(112,NULL,'Alias Product Added','2024-08-14 19:41:56','39','Alias Product'),
(113,NULL,'User Logged In','2024-08-14 19:42:35','37','Login In'),
(114,NULL,'Alias Product Approved','2024-08-14 19:42:48','37','Approval'),
(115,NULL,'Single Print Had Taken','2024-08-14 19:46:11','39','generateqrsr'),
(116,NULL,'Single Print Had Taken','2024-08-14 19:46:31','39','generateqrsr'),
(117,NULL,'Single Print Had Taken','2024-08-14 19:47:06','39','generateqrsr'),
(118,NULL,'Single Print Had Taken','2024-08-14 19:47:21','39','generateqrsr'),
(119,NULL,'Single Print Had Taken','2024-08-14 19:47:43','39','generateqrsr'),
(120,NULL,'Single Print Had Taken','2024-08-14 20:02:36','39','generateqrsr'),
(121,NULL,'Single Print Had Taken','2024-08-14 20:02:55','39','generateqrsr'),
(122,NULL,'Single Print Had Taken','2024-08-14 20:05:33','39','generateqrsr'),
(123,NULL,'Single Print Had Taken','2024-08-14 20:05:57','39','generateqrsr'),
(124,NULL,'Single Print Had Taken','2024-08-14 20:07:11','39','generateqrsr'),
(125,NULL,'Single Print Had Taken','2024-08-14 20:07:26','39','generateqrsr'),
(126,NULL,'Single Print Had Taken','2024-08-14 20:08:38','39','generateqrsr'),
(127,NULL,'Single Print Had Taken','2024-08-14 20:12:57','39','generateqrsr'),
(128,NULL,'Single Print Had Taken','2024-08-14 20:13:14','39','generateqrsr'),
(129,NULL,'Multiple Print Had Taken','2024-08-14 20:17:36','39','generateqrsr'),
(130,NULL,'User Logged In','2024-08-16 14:54:59','39','Login In'),
(131,NULL,'Company Updated','2024-08-16 14:56:29','39','Company Unit'),
(132,NULL,'Single Print Had Taken','2024-08-16 14:57:47','39','generateqrsr'),
(133,NULL,'Single Print Had Taken','2024-08-16 14:58:29','39','generateqrsr'),
(134,NULL,'Single Print Had Taken','2024-08-16 15:02:11','39','generateqrsr'),
(135,NULL,'Single Print Had Taken','2024-08-16 15:02:24','39','generateqrsr'),
(136,NULL,'User Logged In','2024-08-16 15:29:11','36','Login In'),
(137,NULL,'Single Print Had Taken','2024-08-16 15:30:00','36','generateqrsr'),
(138,NULL,'Multiple Print Had Taken','2024-08-16 15:31:44','36','generateqrsr'),
(139,NULL,'User Logged In','2024-08-16 15:36:22','39','Login In'),
(140,NULL,'Storage Condition Added','2024-08-16 15:37:38','39','Storage Condition'),
(141,NULL,'Single Print Had Taken','2024-08-16 16:01:39','39','generateqrsr'),
(142,NULL,'Multiple Print Had Taken','2024-08-16 16:09:05','39','generateqrsr'),
(143,NULL,'Multiple Print Had Taken','2024-08-16 16:09:05','39','generateqrsr'),
(144,NULL,'Single Print Had Taken','2024-08-16 16:09:24','39','generateqrsr'),
(145,NULL,'Single Print Had Taken','2024-08-16 16:09:42','39','generateqrsr'),
(146,NULL,'Single Print Had Taken','2024-08-16 16:11:20','39','generateqrsr'),
(147,NULL,'Multiple Print Had Taken','2024-08-16 16:11:55','39','generateqrsr'),
(148,NULL,'Single Print Had Taken','2024-08-16 16:12:35','39','generateqrsr'),
(149,NULL,'Multiple Print Had Taken','2024-08-16 16:12:55','39','generateqrsr'),
(150,NULL,'Multiple Print Had Taken','2024-08-16 16:13:52','39','generateqrsr'),
(151,NULL,'Multiple Print Had Taken','2024-08-16 16:15:00','39','generateqrsr'),
(152,NULL,'Single Print Had Taken','2024-08-16 16:16:42','39','generateqrsr'),
(153,NULL,'Single Print Had Taken','2024-08-16 16:18:40','39','generateqrsr'),
(154,NULL,'Single Print Had Taken','2024-08-16 16:22:53','39','generateqrsr'),
(155,NULL,'Single Print Had Taken','2024-08-16 16:24:05','39','generateqrsr'),
(156,NULL,'User Logged In','2024-08-16 16:38:23','39','Login In'),
(157,NULL,'Single Print Had Taken','2024-08-16 16:38:59','39','generateqrsr'),
(158,NULL,'Single Print Had Taken','2024-08-16 16:39:46','39','generateqrsr'),
(159,NULL,'Single Print Had Taken','2024-08-16 16:40:28','39','generateqrsr'),
(160,NULL,'Single Print Had Taken','2024-08-16 16:40:56','39','generateqrsr'),
(161,NULL,'Multiple Print Had Taken','2024-08-16 16:42:00','39','generateqrsr'),
(162,NULL,'User Logged In','2024-08-16 17:04:12','39','Login In'),
(163,NULL,'User Logged In','2024-08-16 17:08:38','37','Login In'),
(164,NULL,'Company Unit Approved','2024-08-16 17:09:25','37','Approval'),
(165,NULL,'Storage Condition Approved','2024-08-16 17:10:45','37','Storage Condition'),
(166,NULL,'User Logged Out','2024-08-16 17:10:52','37','Log Out'),
(167,NULL,'User Logged In','2024-08-16 17:49:39','39','Login In'),
(168,NULL,'Single Print Had Taken','2024-08-16 17:49:58','39','generateqrsr'),
(169,NULL,'Single Print Had Taken','2024-08-16 17:51:03','39','generateqrsr'),
(170,NULL,'Multiple Print Had Taken','2024-08-16 17:52:07','39','generateqrsr'),
(171,NULL,'Single Print Had Taken','2024-08-16 17:52:50','39','generateqrsr'),
(172,NULL,'User Logged In','2024-08-16 17:54:23','39','Login In'),
(173,NULL,'Single Print Had Taken','2024-08-16 17:54:36','39','generateqrsr'),
(174,NULL,'Single Print Had Taken','2024-08-16 17:54:51','39','generateqrsr'),
(175,NULL,'Single Print Had Taken','2024-08-16 17:55:19','39','generateqrsr'),
(176,NULL,'Single Print Had Taken','2024-08-16 17:55:35','39','generateqrsr'),
(177,NULL,'Single Print Had Taken','2024-08-16 17:55:52','39','generateqrsr'),
(178,NULL,'Single Print Had Taken','2024-08-16 17:56:12','39','generateqrsr'),
(179,NULL,'Single Print Had Taken','2024-08-16 17:56:36','39','generateqrsr'),
(180,NULL,'Single Print Had Taken','2024-08-16 17:57:10','39','generateqrsr'),
(181,NULL,'Single Print Had Taken','2024-08-16 17:57:21','39','generateqrsr'),
(182,NULL,'Single Print Had Taken','2024-08-16 17:57:32','39','generateqrsr'),
(183,NULL,'Single Print Had Taken','2024-08-16 17:57:43','39','generateqrsr'),
(184,NULL,'Single Print Had Taken','2024-08-16 17:57:56','39','generateqrsr'),
(185,NULL,'Single Print Had Taken','2024-08-16 17:58:09','39','generateqrsr'),
(186,NULL,'Single Print Had Taken','2024-08-16 17:58:25','39','generateqrsr'),
(187,NULL,'Single Print Had Taken','2024-08-16 17:58:44','39','generateqrsr'),
(188,NULL,'Single Print Had Taken','2024-08-16 17:59:05','39','generateqrsr'),
(189,NULL,'Single Print Had Taken','2024-08-16 17:59:32','39','generateqrsr'),
(190,NULL,'Single Print Had Taken','2024-08-16 17:59:46','39','generateqrsr'),
(191,NULL,'Single Print Had Taken','2024-08-16 18:00:05','39','generateqrsr'),
(192,NULL,'Single Print Had Taken','2024-08-16 18:00:37','39','generateqrsr'),
(193,NULL,'Single Print Had Taken','2024-08-16 18:00:56','39','generateqrsr'),
(194,NULL,'Single Print Had Taken','2024-08-16 18:01:44','39','generateqrsr'),
(195,NULL,'User Logged In','2024-08-16 18:24:52','39','Login In'),
(196,NULL,'User Logged In','2024-08-17 10:40:35','39','Login In'),
(197,NULL,'Batch Added','2024-08-17 10:46:21','39','Batch'),
(198,NULL,'User Logged In','2024-08-17 11:12:01','39','Login In'),
(199,NULL,'User Logged In','2024-08-17 11:12:39','37','Login In'),
(200,NULL,'Batch Approved','2024-08-17 11:13:51','37','Approval'),
(201,NULL,'Alias Product Delete Approved','2024-08-17 11:16:53','37','Approval'),
(202,NULL,'Alias Product Added','2024-08-17 11:18:39','39','Alias Product'),
(203,NULL,'Alias Product Approved','2024-08-17 11:18:53','37','Approval'),
(204,NULL,'Storage Condition Added','2024-08-17 11:19:33','39','Storage Condition'),
(205,NULL,'Storage Condition Approved','2024-08-17 11:23:26','37','Storage Condition'),
(206,NULL,'QR generated','2024-08-17 11:25:29','39','Generateqr'),
(207,NULL,'User Logged In','2024-08-17 11:26:10','37','Login In'),
(208,NULL,'Generateqr Approved','2024-08-17 11:28:08','37','Approval'),
(209,NULL,'Single Print Had Taken','2024-08-17 11:28:31','39','generateqrsr'),
(210,NULL,'Single Print Had Taken','2024-08-17 11:47:00','39','generateqrsr'),
(211,NULL,'Single Print Had Taken','2024-08-17 11:47:20','39','generateqrsr'),
(212,NULL,'User Logged In','2024-08-17 12:07:49','39','Login In'),
(213,NULL,'QR generated','2024-08-17 12:10:06','39','Generateqr'),
(214,NULL,'User Logged In','2024-08-17 13:23:35','37','Login In'),
(215,NULL,'Generateqr Approved','2024-08-17 13:24:01','37','Approval'),
(216,NULL,'User Logged In','2024-08-17 13:55:53','39','Login In'),
(217,NULL,'Single Print Had Taken','2024-08-17 13:59:18','39','generateqrsr'),
(218,NULL,'Multiple Print Had Taken','2024-08-17 14:01:05','39','generateqrsr'),
(219,NULL,'User Logged In','2024-08-17 14:24:38','39','Login In'),
(220,NULL,'Single Print Had Taken','2024-08-17 14:24:50','39','generateqrsr'),
(221,NULL,'Single Print Had Taken','2024-08-17 14:25:27','39','generateqrsr'),
(222,NULL,'Single Print Had Taken','2024-08-17 14:25:44','39','generateqrsr'),
(223,NULL,'Single Print Had Taken','2024-08-17 14:26:03','39','generateqrsr'),
(224,NULL,'Single Print Had Taken','2024-08-17 14:26:14','39','generateqrsr'),
(225,NULL,'Single Print Had Taken','2024-08-17 14:26:25','39','generateqrsr'),
(226,NULL,'Single Print Had Taken','2024-08-17 14:26:56','39','generateqrsr'),
(227,NULL,'Single Print Had Taken','2024-08-17 14:27:26','39','generateqrsr'),
(228,NULL,'Single Print Had Taken','2024-08-17 14:27:39','39','generateqrsr'),
(229,NULL,'Single Print Had Taken','2024-08-17 14:27:49','39','generateqrsr'),
(230,NULL,'Single Print Had Taken','2024-08-17 14:28:04','39','generateqrsr'),
(231,NULL,'Single Print Had Taken','2024-08-17 14:28:25','39','generateqrsr'),
(232,NULL,'Single Print Had Taken','2024-08-17 14:28:46','39','generateqrsr'),
(233,NULL,'Single Print Had Taken','2024-08-17 14:28:58','39','generateqrsr'),
(234,NULL,'User Logged In','2024-08-21 11:32:09','39','Login In'),
(235,NULL,'QR generated','2024-08-21 11:33:58','39','Generateqr'),
(236,NULL,'QR generated','2024-08-21 11:34:37','39','Generateqr'),
(237,NULL,'User Logged In','2024-08-21 11:49:01','37','Login In'),
(238,NULL,'Generateqr Approved','2024-08-21 11:49:27','37','Approval'),
(239,NULL,'Generateqr Approved','2024-08-21 11:49:46','37','Approval'),
(240,NULL,'User Logged Out','2024-08-21 11:49:49','37','Log Out'),
(241,NULL,'Single Print Had Taken','2024-08-21 11:52:04','39','generateqrsr'),
(242,NULL,'Multiple Print Had Taken','2024-08-21 11:53:07','39','generateqrsr'),
(243,NULL,'Single Print Had Taken','2024-08-21 11:54:54','39','generateqrsr'),
(244,NULL,'Single Print Had Taken','2024-08-21 11:55:31','39','generateqrsr'),
(245,NULL,'Single Print Had Taken','2024-08-21 11:55:41','39','generateqrsr'),
(246,NULL,'User Logged In','2024-08-21 18:32:38','36','Login In'),
(247,NULL,'User Logged In','2024-08-21 18:39:20','36','Login In'),
(248,NULL,'User Logged In','2024-08-21 19:11:29','36','Login In'),
(249,NULL,'User Logged Out','2024-08-21 19:11:34','36','Log Out'),
(250,NULL,'User Logged In','2024-08-22 18:52:08','39','Login In'),
(251,NULL,'User Logged In','2024-08-23 15:04:52','39','Login In'),
(252,NULL,'Storage Condition Added','2024-08-23 15:07:55','39','Storage Condition'),
(253,NULL,'User Logged In','2024-08-24 15:03:41','39','Login In'),
(254,NULL,'User Logged In','2024-08-24 15:05:21','37','Login In'),
(255,NULL,'Storage Condition Approved','2024-08-24 15:08:14','37','Storage Condition'),
(256,NULL,'User Logged In','2024-08-24 15:21:41','37','Login In'),
(257,NULL,'Storage Condition Approved','2024-08-24 15:21:47','37','Storage Condition'),
(258,NULL,'QR generated','2024-08-24 15:28:16','39','Generateqr'),
(259,NULL,'User Logged In','2024-08-24 15:29:21','37','Login In'),
(260,NULL,'Generateqr Approved','2024-08-24 15:29:48','37','Approval'),
(261,NULL,'User Logged Out','2024-08-24 15:37:56','39','Log Out'),
(262,NULL,'User Logged In','2024-08-24 15:37:57','39','Login In'),
(263,NULL,'Single Print Had Taken','2024-08-24 15:43:14','39','generateqrsr'),
(264,NULL,'User Logged In','2024-08-24 15:53:24','37','Login In'),
(265,NULL,'Generateqr Approved','2024-08-24 15:53:43','37','Approval'),
(266,NULL,'User Logged Out','2024-08-24 15:53:50','37','Log Out'),
(267,NULL,'User Logged In','2024-08-24 15:54:24','37','Login In'),
(268,NULL,'Generateqr Approved','2024-08-24 15:54:41','37','Approval'),
(269,NULL,'User Logged Out','2024-08-24 15:54:45','39','Log Out'),
(270,NULL,'User Logged In','2024-08-24 15:54:47','39','Login In'),
(271,NULL,'User Logged Out','2024-08-24 15:54:58','37','Log Out'),
(272,NULL,'User Logged In','2024-08-24 15:55:18','37','Login In'),
(273,NULL,'Single Print Had Taken','2024-08-24 15:55:18','39','generateqrsr'),
(274,NULL,'User Logged Out','2024-08-24 15:55:28','37','Log Out'),
(275,NULL,'Single Print Had Taken','2024-08-24 15:55:37','39','generateqrsr'),
(276,NULL,'Single Print Had Taken','2024-08-24 15:55:58','39','generateqrsr'),
(277,NULL,'User Logged In','2024-08-24 16:52:50','37','Login In'),
(278,NULL,'User Logged Out','2024-08-24 16:53:34','37','Log Out'),
(279,NULL,'User Logged In','2024-08-24 16:53:36','36','Login In'),
(280,NULL,'User Logged In','2024-09-14 13:15:36','39','Login In'),
(281,NULL,'QR generated','2024-09-14 13:26:24','39','Generateqr'),
(282,NULL,'User Logged In','2024-09-14 15:35:20','39','Login In'),
(283,NULL,'Batch Added','2024-09-14 15:40:50','39','Batch'),
(284,NULL,'QR generated','2024-09-14 15:42:06','39','Generateqr'),
(285,NULL,'Batch Added','2024-09-14 15:52:14','39','Batch'),
(286,NULL,'User Logged In','2024-09-14 15:53:37','37','Login In'),
(287,NULL,'Generateqr Approved','2024-09-14 15:55:28','37','Approval'),
(288,NULL,'Batch Approved','2024-09-14 15:55:52','37','Approval'),
(289,NULL,'Generateqr Approved','2024-09-14 15:56:17','37','Approval'),
(290,NULL,'Batch Approved','2024-09-14 15:56:58','37','Approval'),
(291,NULL,'User Logged Out','2024-09-14 15:58:44','37','Log Out'),
(292,NULL,'QR generated','2024-09-14 15:59:00','39','Generateqr'),
(293,NULL,'User Logged In','2024-09-14 15:59:07','37','Login In'),
(294,NULL,'Generateqr Approved','2024-09-14 15:59:55','37','Approval'),
(295,NULL,'User Logged Out','2024-09-14 16:00:14','37','Log Out'),
(296,NULL,'User Logged In','2024-09-14 16:48:28','39','Login In'),
(297,NULL,'QR Deleted','2024-09-14 17:36:38','39','Generateqr'),
(298,NULL,'Multiple Print Had Taken','2024-09-14 17:37:05','39','generateqrsr'),
(299,NULL,'User Logged In','2024-09-14 17:38:11','39','Login In'),
(300,NULL,'Multiple Print Had Taken','2024-09-14 17:38:42','39','generateqrsr'),
(301,NULL,'QR generated','2024-09-14 17:42:43','39','Generateqr'),
(302,NULL,'User Logged In','2024-09-14 17:43:09','37','Login In'),
(303,NULL,'Generateqr Approved','2024-09-14 17:43:26','37','Approval'),
(304,NULL,'Multiple Print Had Taken','2024-09-14 17:44:18','39','generateqrsr'),
(305,NULL,'QR generated','2024-09-14 17:48:34','39','Generateqr'),
(306,NULL,'Generateqr Approved','2024-09-14 17:48:47','37','Approval'),
(307,NULL,'Multiple Print Had Taken','2024-09-14 17:49:01','39','generateqrsr'),
(308,NULL,'User Logged In','2024-09-14 18:09:46','39','Login In'),
(309,NULL,'Multiple Print Had Taken','2024-09-14 18:09:57','39','generateqrsr'),
(310,NULL,'User Logged In','2024-09-17 12:56:35','39','Login In'),
(311,NULL,'User Logged In','2024-09-17 14:50:18','36','Login In'),
(312,NULL,'Single Print Had Taken','2024-09-17 15:02:48','36','generateqrsr'),
(313,NULL,'Multiple Print Had Taken','2024-09-17 15:03:10','36','generateqrsr'),
(314,NULL,'New Product Added','2024-09-17 15:07:20','36','Product'),
(315,NULL,'Product Approved','2024-09-17 15:07:44','36','Approval'),
(316,NULL,'Batch Added','2024-09-17 15:08:16','36','Batch'),
(317,NULL,'Batch Approved','2024-09-17 15:08:25','36','Approval'),
(318,NULL,'Alias Product Added','2024-09-17 15:08:41','36','Alias Product'),
(319,NULL,'Alias Product Approved','2024-09-17 15:08:48','36','Approval'),
(320,NULL,'Storage Condition Added','2024-09-17 15:09:13','36','Storage Condition'),
(321,NULL,'Storage Condition Approved','2024-09-17 15:09:21','36','Storage Condition'),
(322,NULL,'QR generated','2024-09-17 15:09:48','36','Generateqr'),
(323,NULL,'Generateqr Approved','2024-09-17 15:10:00','36','Approval'),
(324,NULL,'Single Print Had Taken','2024-09-17 15:10:44','36','generateqrsr'),
(325,NULL,'User Logged In','2024-09-17 15:32:45','36','Login In'),
(326,NULL,'User Logged In','2024-09-18 19:16:18','36','Login In'),
(327,NULL,'User Logged In','2024-09-20 18:40:27','36','Login In'),
(328,NULL,'User Logged In','2024-09-27 13:39:59','39','Login In'),
(329,NULL,'Batch Added','2024-09-27 13:42:25','39','Batch'),
(330,NULL,'User Logged In','2024-09-27 16:33:06','37','Login In'),
(331,NULL,'Batch Approved','2024-09-27 16:34:59','37','Approval'),
(332,NULL,'User Logged Out','2024-09-27 16:35:44','37','Log Out'),
(333,NULL,'User Logged In','2024-10-01 11:56:51','36','Login In'),
(334,NULL,'User Logged In','2024-10-01 17:58:09','39','Login In'),
(335,NULL,'User Logged In','2024-10-02 13:44:12','36','Login In'),
(336,NULL,'User Logged In','2024-10-03 18:30:16','39','Login In'),
(337,NULL,'QR generated','2024-10-03 18:33:00','39','Generateqr'),
(338,NULL,'QR generated','2024-10-03 18:34:20','39','Generateqr'),
(339,NULL,'QR generated','2024-10-03 18:34:51','39','Generateqr'),
(340,NULL,'QR generated','2024-10-03 18:36:08','39','Generateqr'),
(341,NULL,'QR generated','2024-10-03 18:36:49','39','Generateqr'),
(342,NULL,'Batch Added','2024-10-03 18:38:17','39','Batch'),
(343,NULL,'Batch Added','2024-10-03 18:39:16','39','Batch'),
(344,NULL,'Batch Added','2024-10-03 18:41:45','39','Batch'),
(345,NULL,'QR generated','2024-10-03 18:43:38','39','Generateqr'),
(346,NULL,'QR generated','2024-10-03 18:44:24','39','Generateqr'),
(347,NULL,'Batch Added','2024-10-03 18:45:30','39','Batch'),
(348,NULL,'Batch Added','2024-10-03 18:46:08','39','Batch'),
(349,NULL,'Batch Data Deleted','2024-10-03 18:46:37','39','Batch'),
(350,NULL,'Batch Updated','2024-10-03 18:47:42','39','Batch'),
(351,NULL,'Batch Added','2024-10-03 18:50:09','39','Batch'),
(352,NULL,'Batch Added','2024-10-03 18:50:51','39','Batch'),
(353,NULL,'Batch Added','2024-10-03 18:51:56','39','Batch'),
(354,NULL,'Batch Added','2024-10-03 18:52:40','39','Batch'),
(355,NULL,'Batch Added','2024-10-03 18:53:14','39','Batch'),
(356,NULL,'User Logged In','2024-10-04 10:57:44','39','Login In'),
(357,NULL,'Alias Product Added','2024-10-04 11:00:08','39','Alias Product'),
(358,NULL,'User Logged In','2024-10-04 11:00:44','37','Login In'),
(359,NULL,'Alias Product Approved','2024-10-04 11:01:25','37','Approval'),
(360,NULL,'Batch Added','2024-10-04 11:03:16','39','Batch'),
(361,NULL,'Batch Approved','2024-10-04 11:03:38','37','Approval'),
(362,NULL,'Batch Added','2024-10-04 11:09:35','39','Batch'),
(363,NULL,'Batch Updated','2024-10-04 11:09:52','39','Batch'),
(364,NULL,'Batch Added','2024-10-04 11:10:33','39','Batch'),
(365,NULL,'Batch Added','2024-10-04 11:11:15','39','Batch'),
(366,NULL,'Batch Added','2024-10-04 11:11:52','39','Batch'),
(367,NULL,'Batch Added','2024-10-04 11:13:35','39','Batch'),
(368,NULL,'Batch Added','2024-10-04 11:15:22','39','Batch'),
(369,NULL,'Batch Added','2024-10-04 11:17:26','39','Batch'),
(370,NULL,'Batch Added','2024-10-04 11:18:08','39','Batch'),
(371,NULL,'Batch Added','2024-10-04 11:18:40','39','Batch'),
(372,NULL,'Batch Data Deleted','2024-10-04 11:21:02','39','Batch'),
(373,NULL,'Product Updated','2024-10-04 11:22:54','39','Product'),
(374,NULL,'Alias Product Added','2024-10-04 11:24:01','39','Alias Product'),
(375,NULL,'Storage Condition Edited','2024-10-04 11:24:55','39','Storage Condition'),
(376,NULL,'Storage Condition Added','2024-10-04 11:25:59','39','Storage Condition'),
(377,NULL,'Storage Condition Deleted','2024-10-04 11:26:15','39','Storage Condition'),
(378,NULL,'Storage Condition Added','2024-10-04 11:26:40','39','Storage Condition'),
(379,NULL,'Storage Condition Added','2024-10-04 11:27:45','39','Storage Condition'),
(380,NULL,'Storage Condition Added','2024-10-04 11:28:15','39','Storage Condition'),
(381,NULL,'Storage Condition Added','2024-10-04 11:28:49','39','Storage Condition'),
(382,NULL,'Storage Condition Added','2024-10-04 11:29:17','39','Storage Condition'),
(383,NULL,'Customer Added','2024-10-04 11:54:02','39','Customer'),
(384,NULL,'Customer Added','2024-10-04 11:57:57','39','Customer'),
(385,NULL,'Customer Added','2024-10-04 12:01:16','39','Customer'),
(386,NULL,'Customer Added','2024-10-04 12:02:54','39','Customer'),
(387,NULL,'Customer Added','2024-10-04 12:04:18','39','Customer'),
(388,NULL,'Customer Added','2024-10-04 12:05:53','39','Customer'),
(389,NULL,'Customer Added','2024-10-04 12:07:19','39','Customer'),
(390,NULL,'Customer Added','2024-10-04 12:08:47','39','Customer'),
(391,NULL,'Customer Added','2024-10-04 12:10:58','39','Customer'),
(392,NULL,'Customer Added','2024-10-04 12:12:31','39','Customer'),
(393,NULL,'Customer Added','2024-10-04 12:14:29','39','Customer'),
(394,NULL,'Customer Added','2024-10-04 12:16:26','39','Customer'),
(395,NULL,'Customer Added','2024-10-04 12:19:07','39','Customer'),
(396,NULL,'Customer Added','2024-10-04 12:20:57','39','Customer'),
(397,NULL,'Customer Added','2024-10-04 12:24:16','39','Customer'),
(398,NULL,'Customer Added','2024-10-04 12:25:04','39','Customer'),
(399,NULL,'Customer Added','2024-10-04 12:28:17','39','Customer'),
(400,NULL,'Customer Added','2024-10-04 12:34:31','39','Customer'),
(401,NULL,'Customer Added','2024-10-04 12:39:13','39','Customer'),
(402,NULL,'Customer Added','2024-10-04 12:41:12','39','Customer'),
(403,NULL,'Customer Added','2024-10-04 12:43:03','39','Customer'),
(404,NULL,'Customer Added','2024-10-04 12:45:02','39','Customer'),
(405,NULL,'User Logged In','2024-10-04 12:46:36','37','Login In'),
(406,NULL,'Product Approved','2024-10-04 12:46:53','37','Approval'),
(407,NULL,'Batch Added','2024-10-04 12:48:01','39','Batch'),
(408,NULL,'Batch Data Deleted','2024-10-04 12:48:10','39','Batch'),
(409,NULL,'Customer Updated','2024-10-04 12:51:30','39','Customer'),
(410,NULL,'User Logged In','2024-10-04 14:05:48','37','Login In'),
(411,NULL,'Generateqr Approved','2024-10-04 14:08:00','37','Approval'),
(412,NULL,'Batch Delete Approved','2024-10-04 14:08:38','37','Approval'),
(413,NULL,'Storage Condition Approved','2024-10-04 14:08:58','37','Storage Condition'),
(414,NULL,'Storage Condition Approved','2024-10-04 14:09:52','37','Storage Condition'),
(415,NULL,'Storage Condition Approved','2024-10-04 14:10:10','37','Storage Condition'),
(416,NULL,'Storage Condition Approved','2024-10-04 14:10:27','37','Storage Condition'),
(417,NULL,'Storage Condition Rejected','2024-10-04 14:13:34','37','Approval'),
(418,NULL,'Storage Condition Approved','2024-10-04 14:14:35','37','Storage Condition'),
(419,NULL,'Alias Product Approved','2024-10-04 14:15:02','37','Approval'),
(420,NULL,'Alias Product Delete Approved','2024-10-04 14:15:34','37','Approval'),
(421,NULL,'User Logged In','2024-10-04 14:19:13','39','Login In'),
(422,NULL,'Batch Delete Rejected','2024-10-04 14:20:08','37','Approval'),
(423,NULL,'Batch Delete Rejected','2024-10-04 14:20:31','37','Approval'),
(424,NULL,'Batch Approved','2024-10-04 14:21:11','37','Approval'),
(425,NULL,'Batch Approved','2024-10-04 14:21:31','37','Approval'),
(426,NULL,'Batch Approved','2024-10-04 14:22:14','37','Approval'),
(427,NULL,'Batch Approved','2024-10-04 14:22:37','37','Approval'),
(428,NULL,'Batch Approved','2024-10-04 14:23:31','37','Approval'),
(429,NULL,'Batch Approved','2024-10-04 14:24:13','37','Approval'),
(430,NULL,'Batch Approved','2024-10-04 14:25:05','37','Approval'),
(431,NULL,'Batch Approved','2024-10-04 14:25:44','37','Approval'),
(432,NULL,'Batch Approved','2024-10-04 14:26:12','37','Approval'),
(433,NULL,'Batch Approved','2024-10-04 14:26:43','37','Approval'),
(434,NULL,'Batch Approved','2024-10-04 14:27:02','37','Approval'),
(435,NULL,'Batch Approved','2024-10-04 14:27:30','37','Approval'),
(436,NULL,'Batch Approved','2024-10-04 14:27:37','37','Approval'),
(437,NULL,'Batch Approved','2024-10-04 14:27:56','37','Approval'),
(438,NULL,'Storage Condition Edited','2024-10-04 14:28:09','39','Storage Condition'),
(439,NULL,'Storage Condition Updated','2024-10-04 14:28:14','39','Storage Condition'),
(440,NULL,'Batch Approved','2024-10-04 14:29:08','37','Approval'),
(441,NULL,'Storage Condition Approved','2024-10-04 14:29:39','37','Storage Condition'),
(442,NULL,'Batch Approved','2024-10-04 14:30:12','37','Approval'),
(443,NULL,'Batch Approved','2024-10-04 14:30:45','37','Approval'),
(444,NULL,'Batch Delete Approved','2024-10-04 14:31:03','37','Approval'),
(445,NULL,'Batch Approved','2024-10-04 14:31:51','37','Approval'),
(446,NULL,'Batch Approved','2024-10-04 14:32:16','37','Approval'),
(447,NULL,'Batch Approved','2024-10-04 14:32:35','37','Approval'),
(448,NULL,'Batch Approved','2024-10-04 14:33:05','37','Approval'),
(449,NULL,'Generateqr Approved','2024-10-04 14:33:49','37','Approval'),
(450,NULL,'Generateqr Approved','2024-10-04 14:34:10','37','Approval'),
(451,NULL,'Generateqr Approved','2024-10-04 14:34:35','37','Approval'),
(452,NULL,'Generateqr Approved','2024-10-04 14:35:07','37','Approval'),
(453,NULL,'Generateqr Approved','2024-10-04 14:35:25','37','Approval'),
(454,NULL,'Generateqr Approved','2024-10-04 14:35:47','37','Approval'),
(455,NULL,'Storage Condition Delete Approved','2024-10-04 14:50:58','37','Storage Condition'),
(456,NULL,'User Logged Out','2024-10-04 14:51:45','37','Log Out'),
(457,NULL,'User Logged In','2024-10-04 15:11:58','39','Login In'),
(458,NULL,'QR generated','2024-10-04 15:17:18','39','Generateqr'),
(459,NULL,'User Logged In','2024-10-04 16:05:24','38','Login In'),
(460,NULL,'User Logged In','2024-10-04 16:07:14','39','Login In'),
(461,NULL,'Customer Approved','2024-10-04 16:15:02','38','Approval'),
(462,NULL,'Customer Approved','2024-10-04 16:15:06','38','Approval'),
(463,NULL,'Customer Approved','2024-10-04 16:15:11','38','Approval'),
(464,NULL,'Customer Approved','2024-10-04 16:15:13','38','Approval'),
(465,NULL,'Customer Approved','2024-10-04 16:15:16','38','Approval'),
(466,NULL,'Customer Approved','2024-10-04 16:15:20','38','Approval'),
(467,NULL,'Customer Approved','2024-10-04 16:15:25','38','Approval'),
(468,NULL,'Customer Approved','2024-10-04 16:15:28','38','Approval'),
(469,NULL,'Customer Approved','2024-10-04 16:15:30','38','Approval'),
(470,NULL,'Customer Approved','2024-10-04 16:15:39','38','Approval'),
(471,NULL,'Customer Approved','2024-10-04 16:15:52','38','Approval'),
(472,NULL,'Customer Approved','2024-10-04 16:15:55','38','Approval'),
(473,NULL,'Customer Approved','2024-10-04 16:15:58','38','Approval'),
(474,NULL,'Customer Approved','2024-10-04 16:16:03','38','Approval'),
(475,NULL,'Customer Approved','2024-10-04 16:16:06','38','Approval'),
(476,NULL,'Customer Approved','2024-10-04 16:16:08','38','Approval'),
(477,NULL,'Customer Approved','2024-10-04 16:16:11','38','Approval'),
(478,NULL,'Customer Approved','2024-10-04 16:16:13','38','Approval'),
(479,NULL,'Customer Approved','2024-10-04 16:16:15','38','Approval'),
(480,NULL,'Customer Approved','2024-10-04 16:16:18','38','Approval'),
(481,NULL,'Customer Approved','2024-10-04 16:16:20','38','Approval'),
(482,NULL,'Customer Approved','2024-10-04 16:16:23','38','Approval'),
(483,NULL,'User Logged In','2024-10-04 19:22:09','39','Login In'),
(484,NULL,'QR generated','2024-10-04 19:27:54','39','Generateqr'),
(485,NULL,'User Logged In','2024-10-05 10:47:38','39','Login In'),
(486,NULL,'QR generated','2024-10-05 10:58:02','39','Generateqr'),
(487,NULL,'Lot Dispatched','2024-10-05 11:01:47','39','Dispatch'),
(488,NULL,'User Logged Out','2024-10-05 11:09:00','39','Log Out'),
(489,NULL,'User Logged In','2024-10-05 11:09:01','39','Login In'),
(490,NULL,'Batch Updated','2024-10-05 11:10:08','39','Batch'),
(491,NULL,'User Logged In','2024-10-05 11:10:45','37','Login In'),
(492,NULL,'Batch Approved','2024-10-05 11:10:54','37','Approval'),
(493,NULL,'QR generated','2024-10-05 11:12:01','39','Generateqr'),
(494,NULL,'User Logged In','2024-10-05 11:19:15','39','Login In'),
(495,NULL,'User Logged In','2024-10-05 11:51:15','37','Login In'),
(496,NULL,'Generateqr Approved','2024-10-05 11:52:17','37','Approval'),
(497,NULL,'Generateqr Approved','2024-10-05 11:52:45','37','Approval'),
(498,NULL,'Generateqr Approved','2024-10-05 11:53:02','37','Approval'),
(499,NULL,'Generateqr Approved','2024-10-05 11:53:21','37','Approval'),
(500,NULL,'User Logged Out','2024-10-05 11:53:32','37','Log Out'),
(501,NULL,'User Logged In','2024-10-05 11:55:49','39','Login In'),
(502,NULL,'QR Deleted','2024-10-05 11:56:18','39','Generateqr'),
(503,NULL,'Batch Added','2024-10-05 11:57:49','39','Batch'),
(504,NULL,'User Logged Out','2024-10-05 11:58:04','39','Log Out'),
(505,NULL,'User Logged In','2024-10-05 11:58:25','37','Login In'),
(506,NULL,'Batch Approved','2024-10-05 11:58:32','37','Approval'),
(507,NULL,'Batch Data Deleted','2024-10-05 11:59:02','39','Batch'),
(508,NULL,'Batch Delete Approved','2024-10-05 11:59:28','37','Approval'),
(509,NULL,'User Logged Out','2024-10-05 12:01:05','37','Log Out'),
(510,NULL,'User Logged In','2024-10-05 12:01:07','39','Login In'),
(511,NULL,'User Logged In','2024-10-05 12:01:50','39','Login In'),
(512,NULL,'User Logged In','2024-10-05 12:02:24','39','Login In'),
(513,NULL,'QR generated','2024-10-05 12:03:03','39','Generateqr'),
(514,NULL,'User Logged Out','2024-10-05 12:03:18','39','Log Out'),
(515,NULL,'User Logged In','2024-10-05 12:03:31','37','Login In'),
(516,NULL,'Generateqr Approved','2024-10-05 12:03:41','37','Approval'),
(517,NULL,'User Logged Out','2024-10-05 12:04:03','37','Log Out'),
(518,NULL,'Multiple Print Had Taken','2024-10-05 12:04:14','37','generateqrsr'),
(519,NULL,'User Logged In','2024-10-05 12:58:33','39','Login In'),
(520,NULL,'Storage Condition Edited','2024-10-05 12:58:56','39','Storage Condition'),
(521,NULL,'Storage Condition Updated','2024-10-05 12:59:05','39','Storage Condition'),
(522,NULL,'User Logged Out','2024-10-05 12:59:19','39','Log Out'),
(523,NULL,'User Logged In','2024-10-05 12:59:34','37','Login In'),
(524,NULL,'Storage Condition Approved','2024-10-05 12:59:39','37','Storage Condition'),
(525,NULL,'User Logged Out','2024-10-05 13:02:07','37','Log Out'),
(526,NULL,'User Logged In','2024-10-05 13:02:09','39','Login In'),
(527,NULL,'Storage Condition Edited','2024-10-05 13:02:18','39','Storage Condition'),
(528,NULL,'User Logged In','2024-10-05 13:31:04','39','Login In'),
(529,NULL,'QR generated','2024-10-05 13:31:44','39','Generateqr'),
(530,NULL,'QR Deleted','2024-10-05 13:32:04','39','Generateqr'),
(531,NULL,'Single Print Had Taken','2024-10-05 13:32:23','39','generateqrsr'),
(532,NULL,'Single Print Had Taken','2024-10-05 13:33:19','39','generateqrsr'),
(533,NULL,'User Logged In','2024-10-05 15:40:28','39','Login In'),
(534,NULL,'QR generated','2024-10-05 15:41:11','39','Generateqr'),
(535,NULL,'User Logged In','2024-10-05 17:17:42','39','Login In'),
(536,NULL,'User Logged In','2024-10-05 18:02:29','39','Login In'),
(537,NULL,'User Logged In','2024-10-05 18:08:15','37','Login In'),
(538,NULL,'Generateqr Approved','2024-10-05 18:08:30','37','Approval'),
(539,NULL,'Generateqr Approved','2024-10-05 18:08:39','37','Approval'),
(540,NULL,'User Logged Out','2024-10-05 18:08:44','37','Log Out'),
(541,NULL,'User Logged In','2024-10-06 18:24:46','37','Login In'),
(542,NULL,'User Logged Out','2024-10-06 18:25:48','37','Log Out'),
(543,NULL,'User Logged In','2024-10-07 15:54:09','39','Login In'),
(544,NULL,'User Logged In','2024-10-08 10:44:41','39','Login In'),
(545,NULL,'Single Print Had Taken','2024-10-08 10:45:15','39','generateqrsr'),
(546,NULL,'User Logged In','2024-10-08 10:47:00','39','Login In'),
(547,NULL,'Single Print Had Taken','2024-10-08 10:47:21','39','generateqrsr'),
(548,NULL,'User Logged In','2024-10-08 14:03:32','39','Login In'),
(549,NULL,'QR generated','2024-10-08 14:04:04','39','Generateqr'),
(550,NULL,'User Logged Out','2024-10-08 14:04:19','39','Log Out'),
(551,NULL,'User Logged In','2024-10-08 14:04:31','37','Login In'),
(552,NULL,'Generateqr Approved','2024-10-08 14:04:37','37','Approval'),
(553,NULL,'User Logged Out','2024-10-08 14:04:40','37','Log Out'),
(554,NULL,'User Logged In','2024-10-08 14:04:46','39','Login In'),
(555,NULL,'Single Print Had Taken','2024-10-08 14:05:46','39','generateqrsr'),
(556,NULL,'User Logged In','2024-10-08 14:06:10','39','Login In'),
(557,NULL,'Single Print Had Taken','2024-10-08 14:06:26','39','generateqrsr'),
(558,NULL,'Single Print Had Taken','2024-10-08 14:06:54','39','generateqrsr'),
(559,NULL,'User Logged In','2024-10-08 17:06:14','39','Login In'),
(560,NULL,'QR generated','2024-10-08 17:07:11','39','Generateqr'),
(561,NULL,'User Logged In','2024-10-08 17:07:48','37','Login In'),
(562,NULL,'Generateqr Approved','2024-10-08 17:07:55','37','Approval'),
(563,NULL,'Single Print Had Taken','2024-10-08 17:09:19','39','generateqrsr'),
(564,NULL,'Single Print Had Taken','2024-10-08 17:09:40','39','generateqrsr'),
(565,NULL,'User Logged In','2024-10-09 17:01:57','39','Login In'),
(566,NULL,'QR generated','2024-10-09 17:02:58','39','Generateqr'),
(567,NULL,'User Logged In','2024-10-09 17:20:19','37','Login In'),
(568,NULL,'Generateqr Approved','2024-10-09 17:20:55','37','Approval'),
(569,NULL,'User Logged Out','2024-10-09 17:21:35','37','Log Out'),
(570,NULL,'Multiple Print Had Taken','2024-10-09 17:21:41','39','generateqrsr'),
(571,NULL,'User Logged In','2024-10-09 18:06:55','39','Login In'),
(572,NULL,'QR generated','2024-10-09 18:07:59','39','Generateqr'),
(573,NULL,'User Logged Out','2024-10-09 18:08:14','39','Log Out'),
(574,NULL,'User Logged In','2024-10-09 18:08:31','37','Login In'),
(575,NULL,'Generateqr Approved','2024-10-09 18:08:36','37','Approval'),
(576,NULL,'Single Print Had Taken','2024-10-09 18:08:53','37','generateqrsr'),
(577,NULL,'User Logged In','2024-10-09 18:46:00','37','Login In'),
(578,NULL,'User Logged In','2024-10-10 10:22:23','39','Login In'),
(579,NULL,'Single Print Had Taken','2024-10-10 10:22:39','39','generateqrsr'),
(580,NULL,'Single Print Had Taken','2024-10-10 10:23:03','39','generateqrsr'),
(581,NULL,'User Logged In','2024-10-14 12:30:38','36','Login In'),
(582,NULL,'User Logged In','2024-10-14 13:30:02','36','Login In'),
(583,NULL,'User Updated','2024-10-14 13:30:41','36','Rights Management'),
(584,NULL,'User Logged Out','2024-10-14 13:30:47','36','Log Out'),
(585,NULL,'User Logged In','2024-10-14 13:30:53','36','Login In'),
(586,NULL,'User Logged In','2024-10-15 11:29:25','39','Login In'),
(587,NULL,'User Logged In','2024-10-15 11:39:45','36','Login In'),
(588,NULL,'User Logged In','2024-10-15 11:52:07','39','Login In'),
(589,NULL,'QR generated','2024-10-15 11:53:23','39','Generateqr'),
(590,NULL,'QR generated','2024-10-15 11:54:16','39','Generateqr'),
(591,NULL,'User Logged In','2024-10-15 12:03:04','37','Login In'),
(592,NULL,'Generateqr Approved','2024-10-15 12:03:20','37','Approval'),
(593,NULL,'Generateqr Approved','2024-10-15 12:03:31','37','Approval'),
(594,NULL,'User Logged Out','2024-10-15 12:03:37','37','Log Out'),
(595,NULL,'Single Print Had Taken','2024-10-15 12:29:13','39','generateqrsr'),
(596,NULL,'Multiple Print Had Taken','2024-10-15 12:33:26','39','generateqrsr'),
(597,NULL,'User Logged In','2024-10-15 16:44:08','39','Login In'),
(598,NULL,'User Logged In','2024-10-15 19:41:57','36','Login In'),
(599,NULL,'User Logged In','2024-10-16 11:05:38','39','Login In'),
(600,NULL,'Single Print Had Taken','2024-10-16 11:06:01','39','generateqrsr'),
(601,NULL,'User Logged In','2024-10-16 12:06:13','39','Login In'),
(602,NULL,'Lot Dispatched','2024-10-16 12:11:22','39','Dispatch'),
(603,NULL,'Lot Dispatched','2024-10-16 12:13:57','39','Dispatch'),
(604,NULL,'Lot Dispatched','2024-10-16 12:15:46','39','Dispatch'),
(605,NULL,'Lot Dispatched','2024-10-16 12:17:34','39','Dispatch'),
(606,NULL,'Lot Dispatched','2024-10-16 12:19:48','39','Dispatch'),
(607,NULL,'Lot Dispatched','2024-10-16 12:21:59','39','Dispatch'),
(608,NULL,'Lot Dispatched','2024-10-16 12:23:58','39','Dispatch'),
(609,NULL,'Lot Dispatched','2024-10-16 12:25:50','39','Dispatch'),
(610,NULL,'User Logged Out','2024-10-16 12:30:56','39','Log Out'),
(611,NULL,'User Logged In','2024-10-16 12:31:31','38','Login In'),
(612,NULL,'Dispatch Approved','2024-10-16 12:31:52','38','Approval'),
(613,NULL,'Dispatch Approved','2024-10-16 12:31:54','38','Approval'),
(614,NULL,'Dispatch Approved','2024-10-16 12:31:57','38','Approval'),
(615,NULL,'Dispatch Approved','2024-10-16 12:31:59','38','Approval'),
(616,NULL,'Dispatch Approved','2024-10-16 12:32:02','38','Approval'),
(617,NULL,'Dispatch Approved','2024-10-16 12:32:04','38','Approval'),
(618,NULL,'Dispatch Approved','2024-10-16 12:32:06','38','Approval'),
(619,NULL,'Dispatch Approved','2024-10-16 12:32:09','38','Approval'),
(620,NULL,'Dispatch Approved','2024-10-16 12:32:11','38','Approval'),
(621,NULL,'User Logged Out','2024-10-16 12:37:17','38','Log Out'),
(622,NULL,'User Logged In','2024-10-16 12:37:21','39','Login In'),
(623,NULL,'Lot Dispatched','2024-10-16 12:40:03','39','Dispatch'),
(624,NULL,'Lot Dispatched Deleted','2024-10-16 12:46:58','39','Dispatch'),
(625,NULL,'Lot Dispatched Data Updated','2024-10-16 12:48:37','39','Dispatch'),
(626,NULL,'Lot Dispatched','2024-10-16 12:49:40','39','Dispatch'),
(627,NULL,'Lot Dispatched','2024-10-16 12:50:21','39','Dispatch'),
(628,NULL,'QR generated','2024-10-16 12:51:22','39','Generateqr'),
(629,NULL,'User Logged In','2024-10-16 12:52:01','37','Login In'),
(630,NULL,'Generateqr Approved','2024-10-16 12:52:16','37','Approval'),
(631,NULL,'Lot Dispatched','2024-10-16 12:53:33','39','Dispatch'),
(632,NULL,'Lot Dispatched','2024-10-16 13:00:16','39','Dispatch'),
(633,NULL,'QR Deleted','2024-10-16 13:00:42','39','Generateqr'),
(634,NULL,'Lot Dispatched','2024-10-16 13:02:33','39','Dispatch'),
(635,NULL,'QR generated','2024-10-16 13:22:49','39','Generateqr'),
(636,NULL,'QR generated','2024-10-16 13:23:33','39','Generateqr'),
(637,NULL,'QR generated','2024-10-16 13:24:04','39','Generateqr'),
(638,NULL,'QR generated','2024-10-16 13:24:52','39','Generateqr'),
(639,NULL,'QR generated','2024-10-16 13:25:32','39','Generateqr'),
(640,NULL,'User Logged Out','2024-10-16 13:26:51','39','Log Out'),
(641,NULL,'User Logged In','2024-10-16 13:27:07','37','Login In'),
(642,NULL,'Generateqr Approved','2024-10-16 13:27:23','37','Approval'),
(643,NULL,'Generateqr Approved','2024-10-16 13:27:25','37','Approval'),
(644,NULL,'Generateqr Approved','2024-10-16 13:27:29','37','Approval'),
(645,NULL,'Generateqr Approved','2024-10-16 13:27:30','37','Approval'),
(646,NULL,'Generateqr Approved','2024-10-16 13:27:32','37','Approval'),
(647,NULL,'User Logged In','2024-10-16 13:27:40','39','Login In'),
(648,NULL,'QR generated','2024-10-16 13:30:50','39','Generateqr'),
(649,NULL,'Generateqr Approved','2024-10-16 13:30:57','37','Approval'),
(650,NULL,'Lot Dispatched','2024-10-16 13:34:14','39','Dispatch'),
(651,NULL,'Lot Dispatched','2024-10-16 13:35:44','39','Dispatch'),
(652,NULL,'Lot Dispatched','2024-10-16 13:37:35','39','Dispatch'),
(653,NULL,'Lot Dispatched','2024-10-16 13:38:50','39','Dispatch'),
(654,NULL,'QR generated','2024-10-16 13:41:57','39','Generateqr'),
(655,NULL,'QR generated','2024-10-16 13:42:26','39','Generateqr'),
(656,NULL,'QR generated','2024-10-16 13:42:56','39','Generateqr'),
(657,NULL,'QR generated','2024-10-16 13:43:29','39','Generateqr'),
(658,NULL,'QR Deleted','2024-10-16 13:44:30','39','Generateqr'),
(659,NULL,'QR generated','2024-10-16 13:45:25','39','Generateqr'),
(660,NULL,'Generateqr Approved','2024-10-16 13:46:12','37','Approval'),
(661,NULL,'Generateqr Approved','2024-10-16 13:46:14','37','Approval'),
(662,NULL,'Generateqr Approved','2024-10-16 13:46:15','37','Approval'),
(663,NULL,'Generateqr Approved','2024-10-16 13:46:17','37','Approval'),
(664,NULL,'Generateqr Approved','2024-10-16 13:46:18','37','Approval');
/*!40000 ALTER TABLE `logtable` ENABLE KEYS */;

-- 
-- Definition of manufacture
-- 

DROP TABLE IF EXISTS `manufacture`;
CREATE TABLE IF NOT EXISTS `manufacture` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `manu` varchar(255) DEFAULT '',
  `dis` varchar(255) DEFAULT '',
  `lic` varchar(255) DEFAULT '',
  `prefix` varchar(255) DEFAULT '',
  `add1` varchar(1000) DEFAULT '',
  `details` text,
  `add2` varchar(1000) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  `userid` varchar(50) DEFAULT NULL,
  `deletestatus` varchar(50) DEFAULT NULL,
  `manuaprstatus` varchar(50) DEFAULT NULL,
  `manrejstatus` varchar(50) DEFAULT NULL,
  `manuaprtime` datetime DEFAULT NULL,
  `manurejtime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table manufacture
-- 

/*!40000 ALTER TABLE `manufacture` DISABLE KEYS */;
INSERT INTO `manufacture`(`id`,`manu`,`dis`,`lic`,`prefix`,`add1`,`details`,`add2`,`created`,`updated`,`userid`,`deletestatus`,`manuaprstatus`,`manrejstatus`,`manuaprtime`,`manurejtime`) VALUES
(1,'LAXACHEM ORGANICS PVT. LTD.','LAXACHEM ORGANICS PVT LTD','(25) AMD/3/96','890618164','Plot No. D-2, MIDC',NULL,'AMRAVATI-444 607. (Maharashtra) INDIA ','2024-08-03 11:21:56','2024-08-16 14:56:29','39','0','1','0','2024-08-16 17:09:25',NULL);
/*!40000 ALTER TABLE `manufacture` ENABLE KEYS */;

-- 
-- Definition of pagemaster
-- 

DROP TABLE IF EXISTS `pagemaster`;
CREATE TABLE IF NOT EXISTS `pagemaster` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `roleid` varchar(50) NOT NULL DEFAULT '0',
  `pageid` varchar(50) NOT NULL DEFAULT '0',
  `pagename` varchar(50) NOT NULL DEFAULT '0',
  `status` varchar(50) NOT NULL DEFAULT '0',
  `rejstatus` varchar(50) NOT NULL DEFAULT '0',
  `createdat` datetime NOT NULL,
  `approvedat` datetime DEFAULT NULL,
  `rejremark` varchar(150) DEFAULT NULL,
  `rejectedat` datetime DEFAULT NULL,
  `itemname` varchar(500) DEFAULT NULL,
  `purpose` varchar(500) DEFAULT NULL,
  `deletestatus` varchar(500) DEFAULT NULL,
  `userid` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=177 DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table pagemaster
-- 

/*!40000 ALTER TABLE `pagemaster` DISABLE KEYS */;
INSERT INTO `pagemaster`(`id`,`roleid`,`pageid`,`pagename`,`status`,`rejstatus`,`createdat`,`approvedat`,`rejremark`,`rejectedat`,`itemname`,`purpose`,`deletestatus`,`userid`) VALUES
(4,'37','2','product','1','0','2024-08-03 12:58:20','2024-08-03 16:33:10',NULL,NULL,'DOCUSATE SODIUM','New Item','0','39'),
(7,'37','5','product','1','0','2024-08-03 13:10:06','2024-08-04 13:07:16',NULL,NULL,'Sodium salt of 4-Chloro-2-[(furan-2-ylmethyl)amino]5-sulfamoylbenzoic acid','New Item','0','39'),
(10,'37','1','product','1','0','2024-08-03 13:27:27','2024-08-03 16:33:41',NULL,NULL,'CHLOROBUTANOL','Edit','0','39'),
(12,'37','7','product','1','0','2024-08-03 16:29:29','2024-08-03 16:36:24',NULL,NULL,'CHLOROBUTANOL','New Item','0','39'),
(13,'37','4','product','1','0','2024-08-03 16:43:31','2024-08-04 12:59:43',NULL,NULL,'PROPYL GALLATE','Edit','0','39'),
(14,'37','6','product','1','0','2024-08-04 13:08:23','2024-08-04 14:31:49',NULL,NULL,'FUROSEMIDE','Edit','0','39'),
(21,'37','1','pbatch','1','0','2024-08-09 12:06:49','2024-08-09 16:12:02',NULL,NULL,'CH-40724','Delete','1','39'),
(22,'37','2','pbatch','1','0','2024-08-09 12:06:52','2024-08-09 16:12:31',NULL,NULL,'CH-40624','Delete','1','39'),
(23,'37','3','pbatch','1','0','2024-08-09 12:06:55','2024-08-09 16:12:53',NULL,NULL,'CH-50624','Delete','1','39'),
(24,'37','4','pbatch','1','0','2024-08-09 12:08:25','2024-08-09 16:14:10',NULL,NULL,'CH-10824','New Item','0','39'),
(25,'37','5','pbatch','1','0','2024-08-09 12:09:19','2024-08-09 16:14:53',NULL,NULL,'CH-20824','New Item','0','39'),
(26,'37','6','pbatch','1','0','2024-08-09 12:10:00','2024-08-09 16:15:42',NULL,NULL,'CH-30824','New Item','0','39'),
(27,'37','7','pbatch','1','0','2024-08-09 12:10:44','2024-08-09 16:16:25',NULL,NULL,'CH-40824','New Item','0','39'),
(28,'37','8','pbatch','1','0','2024-08-09 12:11:30','2024-08-09 16:16:43',NULL,NULL,'CH-50824','New Item','0','39'),
(29,'37','1','addproduct','1','0','2024-08-10 12:45:56','2024-08-10 16:45:02',NULL,NULL,'CHLOROBUTANOL','New Item','0','39'),
(30,'37','2','addproduct','1','0','2024-08-10 12:47:08','2024-08-10 16:45:04',NULL,NULL,'CHLORBUTOL','New Item','0','39'),
(31,'37','1','storagecondition','1','0','2024-08-11 15:07:16','2024-08-11 16:12:16',NULL,NULL,'In an air tight container','New Item','0','39'),
(32,'37','1','generateqr','1','0','2024-08-11 16:13:18','2024-08-11 16:16:38',NULL,NULL,'LAX/0824/001','New Item',NULL,'39'),
(34,'37','3','addproduct','1','0','2024-08-14 19:44:19','2024-08-17 11:16:53',NULL,NULL,'CHLORBUTOL (IND. USE ONLY)','Delete','1','39'),
(35,'37','1','manufacture','1','0','2024-08-16 14:56:29','2024-08-16 17:09:25',NULL,NULL,'LAXACHEM ORGANICS PVT. LTD.','Edit','0','39'),
(40,'37','2','generateqr','1','0','2024-08-17 11:25:30','2024-08-17 11:28:08',NULL,NULL,'LAX/0824/002','New Item',NULL,'39'),
(41,'37','3','generateqr','1','0','2024-08-17 12:10:07','2024-08-17 13:24:01',NULL,NULL,'LAX/0824/003','New Item',NULL,'39'),
(42,'37','4','generateqr','1','0','2024-08-21 11:33:59','2024-08-21 11:49:27',NULL,NULL,'LAX/0824/004','New Item',NULL,'39'),
(43,'37','5','generateqr','1','0','2024-08-21 11:34:37','2024-08-21 11:49:45',NULL,NULL,'LAX/0824/005','New Item',NULL,'39'),
(44,'37','4','storagecondition','1','0','2024-08-23 15:07:55','2024-08-24 15:21:47',NULL,NULL,'Preserve in tight container','New Item','0','39'),
(45,'37','6','generateqr','1','0','2024-08-24 15:28:16','2024-08-24 15:54:41',NULL,NULL,'LAX/0824/006','New Item',NULL,'39'),
(46,'37','7','generateqr','1','0','2024-09-14 13:26:24','2024-09-14 15:55:28',NULL,NULL,'LAX/0924/007','New Item',NULL,'39'),
(48,'37','8','generateqr','1','0','2024-09-14 15:42:06','2024-09-14 15:56:17',NULL,NULL,'LAX/0924/008','New Item',NULL,'39'),
(49,'37','11','pbatch','1','0','2024-09-14 15:52:15','2024-09-14 15:56:58',NULL,NULL,'CH-90824','New Item','0','39'),
(50,'37','9','generateqr','1','0','2024-09-14 15:59:01','2024-09-14 15:59:55',NULL,NULL,'LAX/0924/009','New Item',NULL,'39'),
(51,'37','10','generateqr','1','0','2024-09-14 17:42:44','2024-09-14 17:43:26',NULL,NULL,'LAX/0924/009','New Item',NULL,'39'),
(52,'37','11','generateqr','1','0','2024-09-14 17:48:35','2024-09-14 17:48:47',NULL,NULL,'LAX/0924/011','New Item',NULL,'39'),
(53,'36','8','product','1','0','2024-09-17 15:07:20','2024-09-17 15:07:44',NULL,NULL,'A','New Item','0','36'),
(54,'36','12','pbatch','1','0','2024-09-17 15:08:16','2024-09-17 15:08:25',NULL,NULL,'A Batch','New Item','0','36'),
(55,'36','5','addproduct','1','0','2024-09-17 15:08:41','2024-09-17 15:08:48',NULL,NULL,'A Alias','New Item','0','36'),
(56,'36','5','storagecondition','1','0','2024-09-17 15:09:13','2024-09-17 15:09:21',NULL,NULL,'A IP STORAGE','New Item','0','36'),
(57,'36','12','generateqr','1','0','2024-09-17 15:09:48','2024-09-17 15:10:00',NULL,NULL,'LAX/0924/012','New Item',NULL,'36'),
(58,'37','13','pbatch','1','0','2024-09-27 13:42:26','2024-09-27 16:34:59',NULL,NULL,'DS-20924','New Item','0','39'),
(59,'37','13','generateqr','1','0','2024-10-03 18:33:01','2024-10-04 14:08:00',NULL,NULL,'LAX/1024/013','New Item',NULL,'39'),
(60,'37','14','generateqr','1','0','2024-10-03 18:34:21','2024-10-04 14:35:47',NULL,NULL,'LAX/1024/014','New Item',NULL,'39'),
(61,'37','15','generateqr','1','0','2024-10-03 18:34:51','2024-10-04 14:35:25',NULL,NULL,'LAX/1024/015','New Item',NULL,'39'),
(62,'37','16','generateqr','1','0','2024-10-03 18:36:09','2024-10-04 14:35:07',NULL,NULL,'LAX/1024/016','New Item',NULL,'39'),
(63,'37','17','generateqr','1','0','2024-10-03 18:36:49','2024-10-04 14:34:35',NULL,NULL,'LAX/1024/017','New Item',NULL,'39'),
(64,'37','14','pbatch','1','0','2024-10-03 18:38:18','2024-10-04 14:33:05',NULL,NULL,'CH-60824','New Item','0','39'),
(65,'37','15','pbatch','1','0','2024-10-03 18:39:17','2024-10-04 14:32:35',NULL,NULL,'CH-70824','New Item','0','39'),
(66,'37','16','pbatch','1','0','2024-10-03 18:41:46','2024-10-04 14:32:16',NULL,NULL,'CH-80824','New Item','0','39'),
(67,'37','18','generateqr','1','0','2024-10-03 18:43:38','2024-10-04 14:34:10',NULL,NULL,'LAX/1024/018','New Item',NULL,'39'),
(68,'37','19','generateqr','1','0','2024-10-03 18:44:24','2024-10-04 14:33:49',NULL,NULL,'LAX/1024/019','New Item',NULL,'39'),
(69,'37','17','pbatch','1','0','2024-10-03 18:45:31','2024-10-04 14:31:51',NULL,NULL,'CH-10924','New Item','0','39'),
(71,'37','18','pbatch','1','0','2024-10-03 18:46:37','2024-10-04 14:31:03',NULL,NULL,'CH-20924','Delete','1','39'),
(72,'37','10','pbatch','1','0','2024-10-03 18:47:43','2024-10-04 14:30:45',NULL,NULL,'CH-20924','Edit','0','39'),
(73,'37','19','pbatch','1','0','2024-10-03 18:50:09','2024-10-04 14:30:12',NULL,NULL,'CH-30924','New Item','0','39'),
(74,'37','20','pbatch','1','0','2024-10-03 18:50:51','2024-10-04 14:29:08',NULL,NULL,'CH-40924','New Item','0','39'),
(75,'37','21','pbatch','1','0','2024-10-03 18:51:56','2024-10-04 14:27:56',NULL,NULL,'CH-50924','New Item','0','39'),
(77,'37','23','pbatch','1','0','2024-10-03 18:53:14','2024-10-04 14:27:37',NULL,NULL,'CH-70924','New Item','0','39'),
(78,'37','6','addproduct','1','0','2024-10-04 11:00:09','2024-10-04 11:01:25',NULL,NULL,'DOCUSATE SODIUM','New Item','0','39'),
(79,'37','24','pbatch','1','0','2024-10-04 11:03:16','2024-10-04 11:03:38',NULL,NULL,'DS-20824','New Item','0','39'),
(81,'37','25','pbatch','1','0','2024-10-04 11:09:53','2024-10-04 14:26:12',NULL,NULL,'CH-80924','Edit','0','39'),
(82,'37','26','pbatch','1','0','2024-10-04 11:10:33','2024-10-04 14:25:44',NULL,NULL,'CH-90924','New Item','0','39'),
(83,'37','27','pbatch','1','0','2024-10-04 11:11:15','2024-10-04 14:25:05',NULL,NULL,'CH-100924','New Item','0','39'),
(84,'37','28','pbatch','1','0','2024-10-04 11:11:52','2024-10-04 14:24:13',NULL,NULL,'CH-110924','New Item','0','39'),
(85,'37','29','pbatch','1','0','2024-10-04 11:13:36','2024-10-04 14:23:31',NULL,NULL,'DS-10824','New Item','0','39'),
(86,'37','30','pbatch','1','0','2024-10-04 11:15:22','2024-10-04 14:22:37',NULL,NULL,'DS-10924','New Item','0','39'),
(87,'37','31','pbatch','1','0','2024-10-04 11:17:27','2024-10-04 14:22:14',NULL,NULL,'DS-11024','New Item','0','39'),
(88,'37','32','pbatch','1','0','2024-10-04 11:18:08','2024-10-04 14:21:31',NULL,NULL,'DS-21024','New Item','0','39'),
(89,'37','33','pbatch','1','0','2024-10-04 11:18:41','2024-10-04 14:21:11',NULL,NULL,'DS-31024','New Item','0','39'),
(90,'37','9','pbatch','0','1','2024-10-04 11:21:03',NULL,'Retest date is wrong, not 5 years please write 2 years after mfg. date.','2024-10-04 14:20:31','FR-10824','Delete','-1','39'),
(91,'37','4','addproduct','1','0','2024-10-04 11:21:59','2024-10-04 14:15:34',NULL,NULL,'FUROSEMIDE','Delete','1','39'),
(92,'37','3','product','1','0','2024-10-04 11:22:55','2024-10-04 12:46:53',NULL,NULL,'DOCUSATE SODIUM 85% POWDER','Edit','0','39'),
(93,'37','7','addproduct','1','0','2024-10-04 11:24:01','2024-10-04 14:15:02',NULL,NULL,'PROPYL GALLATE','New Item','0','39'),
(94,'37','6','storagecondition','1','0','2024-10-04 11:25:59','2024-10-04 14:14:35',NULL,NULL,'In an air tight container','New Item','0','39'),
(95,'37','3','storagecondition','1','0','2024-10-04 11:26:16','2024-10-04 14:50:58',NULL,NULL,'','Delete','1','39'),
(97,'37','8','storagecondition','1','0','2024-10-04 11:27:45','2024-10-04 14:10:27',NULL,NULL,'Store protect from moisture','New Item','0','39'),
(98,'37','9','storagecondition','1','0','2024-10-04 11:28:15','2024-10-04 14:10:10',NULL,NULL,'In an air tight container','New Item','0','39'),
(99,'37','10','storagecondition','1','0','2024-10-04 11:28:49','2024-10-04 14:09:52',NULL,NULL,'In an air tight container','New Item','0','39'),
(100,'37','11','storagecondition','1','0','2024-10-04 11:29:17','2024-10-04 14:08:58',NULL,NULL,'Preserve in well closed container','New Item','0','39'),
(102,'38','2','customer','1','0','2024-10-04 11:57:57','2024-10-04 16:16:23',NULL,NULL,'VISHNU AGENCIES','New Item','0','39'),
(103,'38','3','customer','1','0','2024-10-04 12:01:17','2024-10-04 16:16:20',NULL,NULL,'SHITAL CHEMICALS','New Item','0','39'),
(104,'38','4','customer','1','0','2024-10-04 12:02:54','2024-10-04 16:16:18',NULL,NULL,'Coastal Medicare Pvt.Ltd.','New Item','0','39'),
(105,'38','5','customer','1','0','2024-10-04 12:04:18','2024-10-04 16:16:15',NULL,NULL,'CURETECH SKINCARE','New Item','0','39'),
(106,'38','6','customer','1','0','2024-10-04 12:05:53','2024-10-04 16:16:13',NULL,NULL,'DERREN HEALTHCARE PVT. LTD.','New Item','0','39'),
(107,'38','7','customer','1','0','2024-10-04 12:07:20','2024-10-04 16:16:11',NULL,NULL,'ANUSHA ASSOCIATES','New Item','0','39'),
(108,'38','8','customer','1','0','2024-10-04 12:08:48','2024-10-04 16:15:30',NULL,NULL,'ANOD PHARMA PVT.LTD.','New Item','0','39'),
(109,'38','9','customer','1','0','2024-10-04 12:10:58','2024-10-04 16:16:08',NULL,NULL,'WENDT-CHEMIE','New Item','0','39'),
(110,'38','10','customer','1','0','2024-10-04 12:12:31','2024-10-04 16:15:28',NULL,NULL,'KHYATI HEALTHCARE PVT. LTD.','New Item','0','39'),
(111,'38','11','customer','1','0','2024-10-04 12:14:30','2024-10-04 16:16:06',NULL,NULL,'NITIN LIFESCIENCES LTD Unit- I','New Item','0','39'),
(112,'38','12','customer','1','0','2024-10-04 12:16:27','2024-10-04 16:15:25',NULL,NULL,'TAMMAN TITOE PHARMA PVT. LTD.','New Item','0','39'),
(113,'38','13','customer','1','0','2024-10-04 12:19:08','2024-10-04 16:16:03',NULL,NULL,'NATIONAL LABORATORIES UNIT-II','New Item','0','39'),
(114,'38','14','customer','1','0','2024-10-04 12:20:57','2024-10-04 16:15:20',NULL,NULL,'FDC LIMITED, JOGESHWARI,CORP','New Item','0','39'),
(115,'38','15','customer','1','0','2024-10-04 12:24:16','2024-10-04 16:15:16',NULL,NULL,'ELKO ORGANIZATION (PVT) LTD.','New Item','0','39'),
(116,'38','16','customer','1','0','2024-10-04 12:25:05','2024-10-04 16:15:58',NULL,NULL,'STAR LABORATORIES (PVT) LTD.','New Item','0','39'),
(117,'38','17','customer','1','0','2024-10-04 12:28:17','2024-10-04 16:15:13',NULL,NULL,'LAWRENCE PHARMA PVT. LTD.','New Item','0','39'),
(118,'38','18','customer','1','0','2024-10-04 12:34:32','2024-10-04 16:15:52',NULL,NULL,'S D FINE-CHEM LTD.','New Item','0','39'),
(119,'38','19','customer','1','0','2024-10-04 12:39:13','2024-10-04 16:15:11',NULL,NULL,'GEMINI EXPORTS','New Item','0','39'),
(120,'38','20','customer','1','0','2024-10-04 12:41:12','2024-10-04 16:15:55',NULL,NULL,'AKUMS DRUGS & PHARMACEUTICALS LTD','New Item','0','39'),
(121,'38','21','customer','1','0','2024-10-04 12:43:04','2024-10-04 16:15:06',NULL,NULL,'VCARE MEDICINES','New Item','0','39'),
(122,'38','22','customer','1','0','2024-10-04 12:45:03','2024-10-04 16:15:39',NULL,NULL,'OCTAVIUS PHARMA PVT. LTD.','New Item','0','39'),
(124,'37','34','pbatch','1','0','2024-10-04 12:48:10','2024-10-04 14:08:38',NULL,NULL,'DP-10924','Delete','1','39'),
(125,'38','1','customer','1','0','2024-10-04 12:51:31','2024-10-04 16:15:02',NULL,NULL,'ISIS PHARMACEUTICALS AND CHEMICAL WORK','Edit','0','39'),
(126,'37','7','storagecondition','1','0','2024-10-04 14:28:15','2024-10-04 14:29:39',NULL,NULL,'In an air tight container','Edit','0','39'),
(127,'37','20','generateqr','1','0','2024-10-04 15:17:19','2024-10-05 11:53:21',NULL,NULL,'LAX/1024/020','New Item',NULL,'39'),
(128,'37','21','generateqr','1','0','2024-10-04 19:27:54','2024-10-05 11:53:02',NULL,NULL,'LAX/1024/021','New Item',NULL,'39'),
(129,'37','22','generateqr','1','0','2024-10-05 10:58:02','2024-10-05 11:52:45',NULL,NULL,'LAX/1024/022','New Item',NULL,'39'),
(130,'38','1','dispatch','1','0','2024-10-05 11:01:47','2024-10-16 12:31:52',NULL,NULL,'LAX/0824/001','New Item','0','39'),
(132,'37','23','generateqr','1','0','2024-10-05 11:12:02','2024-10-05 11:52:17',NULL,NULL,'LAX/1024/023','New Item',NULL,'39'),
(133,'37','35','pbatch','1','0','2024-10-05 11:57:49','2024-10-05 11:58:32',NULL,NULL,'CH-60924','New Item','0','39'),
(134,'37','22','pbatch','1','0','2024-10-05 11:59:02','2024-10-05 11:59:28',NULL,NULL,'CH-60924','Delete','1','39'),
(135,'37','24','generateqr','1','0','2024-10-05 12:03:04','2024-10-05 12:03:41',NULL,NULL,'LAX/1024/023','New Item',NULL,'39'),
(136,'37','2','storagecondition','1','0','2024-10-05 12:59:05','2024-10-05 12:59:39',NULL,NULL,'Store protect from moisture at temperature not exceeding 30°C','Edit','0','39'),
(137,'37','25','generateqr','1','0','2024-10-05 13:31:44','2024-10-05 18:08:39',NULL,NULL,'LAX/1024/025','New Item',NULL,'39'),
(138,'37','26','generateqr','1','0','2024-10-05 15:41:11','2024-10-05 18:08:30',NULL,NULL,'LAX/1024/025','New Item',NULL,'39'),
(139,'37','27','generateqr','1','0','2024-10-08 14:04:04','2024-10-08 14:04:37',NULL,NULL,'LAX/1024/027','New Item',NULL,'39'),
(140,'37','28','generateqr','1','0','2024-10-08 17:07:11','2024-10-08 17:07:55',NULL,NULL,'LAX/1024/028','New Item',NULL,'39'),
(141,'37','29','generateqr','1','0','2024-10-09 17:02:59','2024-10-09 17:20:55',NULL,NULL,'LAX/1024/029','New Item',NULL,'39'),
(142,'37','30','generateqr','1','0','2024-10-09 18:08:00','2024-10-09 18:08:36',NULL,NULL,'LAX/1024/030','New Item',NULL,'39'),
(143,'37','31','generateqr','1','0','2024-10-15 11:53:23','2024-10-15 12:03:20',NULL,NULL,'LAX/1024/031','New Item',NULL,'39'),
(144,'37','32','generateqr','1','0','2024-10-15 11:54:16','2024-10-15 12:03:31',NULL,NULL,'LAX/1024/032','New Item',NULL,'39'),
(145,'38','2','dispatch','1','0','2024-10-16 12:11:22','2024-10-16 12:31:57',NULL,NULL,'LAX/0824/003','New Item','0','39'),
(146,'38','3','dispatch','1','0','2024-10-16 12:13:57','2024-10-16 12:31:54',NULL,NULL,'LAX/0824/005','New Item','0','39'),
(147,'38','4','dispatch','1','0','2024-10-16 12:15:47','2024-10-16 12:31:59',NULL,NULL,'LAX/0824/004','New Item','0','39'),
(148,'38','5','dispatch','1','0','2024-10-16 12:17:34','2024-10-16 12:32:04',NULL,NULL,'LAX/0924/008','New Item','0','39'),
(149,'38','6','dispatch','1','0','2024-10-16 12:19:49','2024-10-16 12:32:02',NULL,NULL,'LAX/1024/015','New Item','0','39'),
(150,'38','7','dispatch','1','0','2024-10-16 12:21:59','2024-10-16 12:32:06',NULL,NULL,'LAX/0924/007','New Item','0','39'),
(151,'38','8','dispatch','1','0','2024-10-16 12:23:58','2024-10-16 12:32:09',NULL,NULL,'LAX/1024/014','New Item','0','39'),
(152,'38','9','dispatch','1','0','2024-10-16 12:25:50','2024-10-16 12:32:11',NULL,NULL,'LAX/1024/013','New Item','0','39'),
(155,'38','10','dispatch','0','0','2024-10-16 12:48:38',NULL,NULL,NULL,'LAX/0824/006','Edit','0','39'),
(156,'38','11','dispatch','0','0','2024-10-16 12:49:41',NULL,NULL,NULL,'LAX/1024/016','New Item','0','39'),
(157,'38','12','dispatch','0','0','2024-10-16 12:50:21',NULL,NULL,NULL,'LAX/1024/017','New Item','0','39'),
(158,'37','33','generateqr','1','0','2024-10-16 12:51:23','2024-10-16 12:52:16',NULL,NULL,'LAX/1024/033','New Item',NULL,'39'),
(159,'38','13','dispatch','0','0','2024-10-16 12:53:33',NULL,NULL,NULL,'LAX/1024/033','New Item','0','39'),
(160,'38','14','dispatch','0','0','2024-10-16 13:00:17',NULL,NULL,NULL,'LAX/1024/018','New Item','0','39'),
(161,'38','15','dispatch','0','0','2024-10-16 13:02:34',NULL,NULL,NULL,'LAX/0924/009','New Item','0','39'),
(162,'37','34','generateqr','1','0','2024-10-16 13:22:49','2024-10-16 13:27:23',NULL,NULL,'LAX/1024/034','New Item',NULL,'39'),
(163,'37','35','generateqr','1','0','2024-10-16 13:23:33','2024-10-16 13:27:29',NULL,NULL,'LAX/1024/035','New Item',NULL,'39'),
(164,'37','36','generateqr','1','0','2024-10-16 13:24:05','2024-10-16 13:27:25',NULL,NULL,'LAX/1024/036','New Item',NULL,'39'),
(165,'37','37','generateqr','1','0','2024-10-16 13:24:52','2024-10-16 13:27:30',NULL,NULL,'LAX/1024/037','New Item',NULL,'39'),
(166,'37','38','generateqr','1','0','2024-10-16 13:25:32','2024-10-16 13:27:32',NULL,NULL,'LAX/1024/038','New Item',NULL,'39'),
(167,'37','39','generateqr','1','0','2024-10-16 13:30:50','2024-10-16 13:30:57',NULL,NULL,'LAX/1024/039','New Item',NULL,'39'),
(168,'38','16','dispatch','0','0','2024-10-16 13:34:14',NULL,NULL,NULL,'LAX/1024/039','New Item','0','39'),
(169,'38','17','dispatch','0','0','2024-10-16 13:35:44',NULL,NULL,NULL,'LAX/1024/034','New Item','0','39'),
(170,'38','18','dispatch','0','0','2024-10-16 13:37:35',NULL,NULL,NULL,'LAX/1024/035','New Item','0','39'),
(171,'38','19','dispatch','0','0','2024-10-16 13:38:51',NULL,NULL,NULL,'LAX/1024/036','New Item','0','39'),
(172,'37','40','generateqr','1','0','2024-10-16 13:41:57','2024-10-16 13:46:12',NULL,NULL,'LAX/1024/040','New Item',NULL,'39'),
(173,'37','41','generateqr','1','0','2024-10-16 13:42:27','2024-10-16 13:46:14',NULL,NULL,'LAX/1024/041','New Item',NULL,'39'),
(174,'37','42','generateqr','1','0','2024-10-16 13:42:56','2024-10-16 13:46:15',NULL,NULL,'LAX/1024/042','New Item',NULL,'39'),
(175,'37','43','generateqr','1','0','2024-10-16 13:43:29','2024-10-16 13:46:17',NULL,NULL,'LAX/1024/043','New Item',NULL,'39'),
(176,'37','44','generateqr','1','0','2024-10-16 13:45:26','2024-10-16 13:46:18',NULL,NULL,'LAX/1024/044','New Item',NULL,'39');
/*!40000 ALTER TABLE `pagemaster` ENABLE KEYS */;

-- 
-- Definition of pbatch
-- 

DROP TABLE IF EXISTS `pbatch`;
CREATE TABLE IF NOT EXISTS `pbatch` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `batch` varchar(255) DEFAULT '',
  `product` varchar(255) DEFAULT '',
  `batchsize` varchar(255) DEFAULT '',
  `batchnumber` varchar(255) DEFAULT '',
  `mfgdate` date DEFAULT NULL,
  `expdate` date DEFAULT NULL,
  `weight` varchar(255) DEFAULT '',
  `remark` varchar(255) DEFAULT '',
  `pid` varchar(255) DEFAULT '',
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  `userid` varchar(50) DEFAULT NULL,
  `deletestatus` varchar(50) DEFAULT NULL,
  `bataprstatus` varchar(50) DEFAULT NULL,
  `batrejstatus` varchar(50) DEFAULT NULL,
  `bataprtime` datetime DEFAULT NULL,
  `batrejtime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table pbatch
-- 

/*!40000 ALTER TABLE `pbatch` DISABLE KEYS */;
INSERT INTO `pbatch`(`id`,`batch`,`product`,`batchsize`,`batchnumber`,`mfgdate`,`expdate`,`weight`,`remark`,`pid`,`created`,`updated`,`userid`,`deletestatus`,`bataprstatus`,`batrejstatus`,`bataprtime`,`batrejtime`) VALUES
(1,'CH-40724','1','500','NA','2024-07-01 00:00:00','2029-06-01 00:00:00','','','IP,BP,EP,USP','2024-08-07 12:00:22','2024-08-07 12:00:22','39','1','1','0','2024-08-09 16:12:02',NULL),
(2,'CH-40624','1','500','NA','2024-06-01 00:00:00','2029-05-01 00:00:00','','','IP,BP,EP,USP','2024-08-07 12:00:30','2024-08-07 12:00:30','39','1','1','0','2024-08-09 16:12:31',NULL),
(3,'CH-50624','1','500','NA','2024-06-01 00:00:00','2029-05-01 00:00:00','','','IP,BP,EP,USP','2024-08-07 11:58:02',NULL,'39','1','1','0','2024-08-09 16:12:53',NULL),
(4,'CH-10824','1','500','NA','2024-08-01 00:00:00','2029-07-01 00:00:00','','','IP,BP,EP,USP','2024-08-09 12:08:25',NULL,'39','0','1','0','2024-08-09 16:14:10',NULL),
(5,'CH-20824','1','500','NA','2024-08-01 00:00:00','2029-07-01 00:00:00','','','IP,BP,EP,USP','2024-08-09 12:09:18',NULL,'39','0','1','0','2024-08-09 16:14:53',NULL),
(6,'CH-30824','1','500','NA','2024-08-01 00:00:00','2029-07-01 00:00:00','','','IP,BP,EP,USP','2024-08-09 12:09:59',NULL,'39','0','1','0','2024-08-09 16:15:42',NULL),
(7,'CH-40824','1','500','NA','2024-08-01 00:00:00','2029-07-01 00:00:00','','','IP,BP,EP,USP','2024-08-09 12:10:43',NULL,'39','0','1','0','2024-08-09 16:16:25',NULL),
(8,'CH-50824','1','500','NA','2024-08-01 00:00:00','2029-07-01 00:00:00','','','IP,BP,EP,USP','2024-08-09 12:11:29',NULL,'39','0','1','0','2024-08-09 16:16:43',NULL),
(9,'FR-10824','6','400','NA','2024-08-01 00:00:00','2029-07-01 00:00:00','','','IP,BP','2024-08-17 10:46:21',NULL,'39','0','1','0','2024-08-17 11:13:51',NULL),
(10,'CH-20924','1','500','NA','2024-09-01 00:00:00','2029-08-01 00:00:00','','','IP,BP,EP,USP','2024-10-03 18:47:43','2024-10-03 18:47:43','39','0','1','0','2024-10-04 14:30:45',NULL),
(11,'CH-90824','1','500','NA','2024-08-01 00:00:00','2029-07-01 00:00:00','','','IP,BP,EP,USP','2024-09-14 15:52:14',NULL,'39','0','1','0','2024-09-14 15:56:58',NULL),
(12,'A Batch','8','20','ABATCHI','2024-09-01 00:00:00','2026-06-01 00:00:00','','','IP','2024-09-17 15:08:16',NULL,'36','0','1','0','2024-09-17 15:08:25',NULL),
(13,'DS-20924','2','500','NA','2024-09-01 00:00:00','2029-08-01 00:00:00','','','IP,BP,EP,USP','2024-09-27 13:42:25',NULL,'39','0','1','0','2024-09-27 16:34:59',NULL),
(14,'CH-60824','1','500','NA','2024-08-01 00:00:00','2029-07-01 00:00:00','','','IP,BP,EP,USP','2024-10-03 18:38:17',NULL,'39','0','1','0','2024-10-04 14:33:05',NULL),
(15,'CH-70824','1','500','NA','2024-08-01 00:00:00','2029-07-01 00:00:00','','','IP,BP,EP,USP','2024-10-03 18:39:16',NULL,'39','0','1','0','2024-10-04 14:32:35',NULL),
(16,'CH-80824','1','500','NA','2024-08-01 00:00:00','2029-07-01 00:00:00','','','IP,BP,EP,USP','2024-10-03 18:41:45',NULL,'39','0','1','0','2024-10-04 14:32:16',NULL),
(17,'CH-10924','1','500','NA','2024-09-01 00:00:00','2029-08-01 00:00:00','','','IP,BP,EP,USP','2024-10-03 18:45:30',NULL,'39','0','1','0','2024-10-04 14:31:51',NULL),
(18,'CH-20924','1','500','NA','2024-09-01 00:00:00','2029-08-01 00:00:00','','','IP,BP,EP,USP','2024-10-03 18:46:08',NULL,'39','1','1','0','2024-10-04 14:31:03',NULL),
(19,'CH-30924','1','500','NA','2024-09-01 00:00:00','2029-08-01 00:00:00','','','IP,BP,EP,USP','2024-10-03 18:50:09',NULL,'39','0','1','0','2024-10-04 14:30:12',NULL),
(20,'CH-40924','1','500','NA','2024-09-01 00:00:00','2029-08-01 00:00:00','','','IP,BP,EP,USP','2024-10-03 18:50:51',NULL,'39','0','1','0','2024-10-04 14:29:08',NULL),
(21,'CH-50924','1','500','NA','2024-09-01 00:00:00','2029-08-01 00:00:00','','','IP,BP,EP,USP','2024-10-03 18:51:56',NULL,'39','0','1','0','2024-10-04 14:27:56',NULL),
(22,'CH-60924','1','500','NA','2024-09-01 00:00:00','2029-08-01 00:00:00','','','IP,BP,EP,USP','2024-10-05 11:10:09','2024-10-05 11:10:09','39','1','1','0','2024-10-05 11:59:28',NULL),
(23,'CH-70924','1','500','NA','2024-09-01 00:00:00','2029-08-01 00:00:00','','','IP,BP,EP,USP','2024-10-03 18:53:14',NULL,'39','0','1','0','2024-10-04 14:27:37',NULL),
(24,'DS-20824','2','500','NA','2024-08-01 00:00:00','2029-07-01 00:00:00','','','IP,BP,EP,USP','2024-10-04 11:03:16',NULL,'39','0','1','0','2024-10-04 11:03:38',NULL),
(25,'CH-80924','1','500','NA','2024-09-01 00:00:00','2029-08-01 00:00:00','','','IP,BP,EP,USP','2024-10-04 11:09:53','2024-10-04 11:09:53','39','0','1','0','2024-10-04 14:26:12',NULL),
(26,'CH-90924','1','500','NA','2024-09-01 00:00:00','2029-08-01 00:00:00','','','IP,BP,EP,USP','2024-10-04 11:10:33',NULL,'39','0','1','0','2024-10-04 14:25:44',NULL),
(27,'CH-100924','1','500','NA','2024-09-01 00:00:00','2029-08-01 00:00:00','','','IP,BP,EP,USP','2024-10-04 11:11:15',NULL,'39','0','1','0','2024-10-04 14:25:05',NULL),
(28,'CH-110924','1','500','NA','2024-09-01 00:00:00','2029-08-01 00:00:00','','','IP,BP,EP,USP','2024-10-04 11:11:52',NULL,'39','0','1','0','2024-10-04 14:24:13',NULL),
(29,'DS-10824','2','500','NA','2024-08-01 00:00:00','2029-07-01 00:00:00','','','IP,BP,EP,USP','2024-10-04 11:13:35',NULL,'39','0','1','0','2024-10-04 14:23:31',NULL),
(30,'DS-10924','2','500','NA','2024-09-01 00:00:00','2029-08-01 00:00:00','','','IP,BP,EP,USP','2024-10-04 11:15:22',NULL,'39','0','1','0','2024-10-04 14:22:37',NULL),
(31,'DS-11024','2','500','NA','2024-10-01 00:00:00','2029-09-01 00:00:00','','','IP,BP,EP,USP','2024-10-04 11:17:26',NULL,'39','0','1','0','2024-10-04 14:22:14',NULL),
(32,'DS-21024','2','500','NA','2024-10-01 00:00:00','2029-09-01 00:00:00','','','IP,BP,EP,USP','2024-10-04 11:18:08',NULL,'39','0','1','0','2024-10-04 14:21:31',NULL),
(33,'DS-31024','2','500','NA','2024-10-01 00:00:00','2029-09-01 00:00:00','','','IP,BP,EP,USP','2024-10-04 11:18:40',NULL,'39','0','1','0','2024-10-04 14:21:11',NULL),
(34,'DP-10924','3','500','NA','2024-09-01 00:00:00','2029-08-01 00:00:00','','','USP','2024-10-04 12:48:00',NULL,'39','1','1','0','2024-10-04 14:08:38',NULL),
(35,'CH-60924','1','500','NA','2024-09-01 00:00:00','2029-08-01 00:00:00','','','IP,BP,EP,USP','2024-10-05 11:57:49',NULL,'39','0','1','0','2024-10-05 11:58:32',NULL);
/*!40000 ALTER TABLE `pbatch` ENABLE KEYS */;

-- 
-- Definition of preset
-- 

DROP TABLE IF EXISTS `preset`;
CREATE TABLE IF NOT EXISTS `preset` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT '',
  `name` varchar(255) DEFAULT '',
  `formula` varchar(255) DEFAULT '',
  `batch` varchar(255) DEFAULT '',
  `molwt` varchar(255) DEFAULT '',
  `tarewt` varchar(255) DEFAULT '',
  `grosswt` varchar(255) DEFAULT '',
  `netwt` varchar(255) DEFAULT '',
  `gtin` varchar(255) DEFAULT '',
  `manufact` varchar(255) DEFAULT '',
  `storag` varchar(255) DEFAULT '',
  `grade` varchar(255) DEFAULT '',
  `uom` varchar(255) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table preset
-- 

/*!40000 ALTER TABLE `preset` DISABLE KEYS */;

/*!40000 ALTER TABLE `preset` ENABLE KEYS */;

-- 
-- Definition of product
-- 

DROP TABLE IF EXISTS `product`;
CREATE TABLE IF NOT EXISTS `product` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT '',
  `brand` varchar(255) DEFAULT '',
  `gtin` varchar(255) DEFAULT '',
  `manu` varchar(255) DEFAULT '',
  `manutxt` varchar(255) DEFAULT '',
  `scon` varchar(255) DEFAULT '',
  `grade` varchar(255) DEFAULT '',
  `subname` varchar(255) DEFAULT '',
  `pack` varchar(255) DEFAULT '',
  `uom` varchar(255) DEFAULT '',
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  `userid` varchar(50) DEFAULT NULL,
  `formula` varchar(255) DEFAULT NULL,
  `molwt` varchar(255) DEFAULT NULL,
  `deletestatus` varchar(255) DEFAULT NULL,
  `prodaprstatus` varchar(255) DEFAULT NULL,
  `prodrejstatus` varchar(255) DEFAULT NULL,
  `prodaprtime` datetime DEFAULT NULL,
  `prodrejtime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table product
-- 

/*!40000 ALTER TABLE `product` DISABLE KEYS */;
INSERT INTO `product`(`id`,`name`,`brand`,`gtin`,`manu`,`manutxt`,`scon`,`grade`,`subname`,`pack`,`uom`,`created`,`updated`,`userid`,`formula`,`molwt`,`deletestatus`,`prodaprstatus`,`prodrejstatus`,`prodaprtime`,`prodrejtime`) VALUES
(1,'CHLOROBUTANOL','NA','8906181640009','1','LAXACHEM ORGANICS PVT LTD','Preserve in air tight container','IP,BP,EP,USP','HEMIHYDRATE','5,10,15,20,25','KGS','2024-08-03 12:54:22','2024-08-03 13:27:27','39','C4H7Cl3O,1/2H2O','186.5','0','1','0','2024-08-03 16:33:41',NULL),
(2,'DOCUSATE SODIUM','NA','8906181640023','1','LAXACHEM ORGANICS PVT LTD','Preserve in well closed container','IP,BP,EP,USP','Dioctyl Sodium Sulfosuccinate','5,10,15,20,25','KGS','2024-08-03 12:58:20',NULL,'39','C20H37NaO7S','444.6','0','1','0','2024-08-03 16:33:10',NULL),
(3,'DOCUSATE SODIUM 85% POWDER','NA','8906181640030','1','LAXACHEM ORGANICS PVT LTD','Preserve in well closed container','USP','NA','5,10,15,20,25','KGS','2024-08-03 13:04:30','2024-10-04 11:22:55','39','NA','NA','0','1','0','2024-10-04 12:46:53',NULL),
(4,'PROPYL GALLATE','NA','8906181640047','1','LAXACHEM ORGANICS PVT LTD','Store protect from light, in non-metallic container','IP,BP,USP','NA','5,10,15,20,25','KGS','2024-08-03 13:06:54','2024-08-03 16:43:31','39','C10H12O5','212.2','0','1','0','2024-08-04 12:59:43',NULL),
(5,'Sodium salt of 4-Chloro-2-[(furan-2-ylmethyl)amino]5-sulfamoylbenzoic acid','NA','NA','1','LAXACHEM ORGANICS PVT LTD','NA','TECHNICAL','NA','5,10,15,20,25','KGS','2024-08-03 13:10:06',NULL,'39','C12H11CIN2O5S','330.7','0','1','0','2024-08-04 13:07:16',NULL),
(6,'FUROSEMIDE','NA','8906181640054','1','LAXACHEM ORGANICS PVT LTD','Store protect from moisture and light','IP,BP,EP,USP','NA','5,10,15,20,25','KGS','2024-08-03 13:12:43','2024-08-04 13:08:23','39','C12H11CIN2O5S','330.7','0','1','0','2024-08-04 14:31:49','2024-08-04 13:03:26'),
(7,'CHLOROBUTANOL','NA','8906181640016','1','LAXACHEM ORGANICS PVT LTD','In an air tight container','IP,BP,EP,USP','ANHYDROUS','5,10,15,20,25','KGS','2024-08-03 16:29:29',NULL,'39','C4H7Cl3O','177.5','0','1','0','2024-08-03 16:36:24',NULL),
(8,'A','NA','12345678','1','LAXACHEM ORGANICS PVT LTD','NA','IP','Sub A','5','KGS','2024-09-17 15:07:20',NULL,'36','H2G4T5','224','0','1','0','2024-09-17 15:07:44',NULL);
/*!40000 ALTER TABLE `product` ENABLE KEYS */;

-- 
-- Definition of returnstock
-- 

DROP TABLE IF EXISTS `returnstock`;
CREATE TABLE IF NOT EXISTS `returnstock` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lotno` varchar(255) DEFAULT '',
  `remark` varchar(255) DEFAULT '',
  `dor` date DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  `userid` varchar(50) DEFAULT NULL,
  `status` varchar(50) DEFAULT '0',
  `deletestatus` varchar(50) DEFAULT '0',
  `rtime` varchar(50) DEFAULT NULL,
  `retaprstatus` varchar(50) DEFAULT NULL,
  `retrejstatus` varchar(50) DEFAULT NULL,
  `retaprtime` datetime DEFAULT NULL,
  `retrejtime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table returnstock
-- 

/*!40000 ALTER TABLE `returnstock` DISABLE KEYS */;

/*!40000 ALTER TABLE `returnstock` ENABLE KEYS */;

-- 
-- Definition of returnstocknew
-- 

DROP TABLE IF EXISTS `returnstocknew`;
CREATE TABLE IF NOT EXISTS `returnstocknew` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lotid` varchar(50) DEFAULT NULL,
  `ssccno` varchar(50) DEFAULT NULL,
  `tarewt` varchar(50) DEFAULT NULL,
  `netwt` varchar(50) DEFAULT NULL,
  `grosswt` varchar(50) DEFAULT NULL,
  `created` varchar(50) DEFAULT NULL,
  `userid` varchar(50) DEFAULT NULL,
  `updated` varchar(50) DEFAULT NULL,
  `contno` varchar(50) DEFAULT NULL,
  `rntime` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table returnstocknew
-- 

/*!40000 ALTER TABLE `returnstocknew` DISABLE KEYS */;

/*!40000 ALTER TABLE `returnstocknew` ENABLE KEYS */;

-- 
-- Definition of rolemaster
-- 

DROP TABLE IF EXISTS `rolemaster`;
CREATE TABLE IF NOT EXISTS `rolemaster` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) DEFAULT NULL,
  `password` varchar(50) DEFAULT NULL,
  `role` varchar(50) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table rolemaster
-- 

/*!40000 ALTER TABLE `rolemaster` DISABLE KEYS */;

/*!40000 ALTER TABLE `rolemaster` ENABLE KEYS */;

-- 
-- Definition of storagecondition
-- 

DROP TABLE IF EXISTS `storagecondition`;
CREATE TABLE IF NOT EXISTS `storagecondition` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `product` varchar(255) NOT NULL,
  `productid` int(11) NOT NULL DEFAULT '0',
  `grade` varchar(50) NOT NULL,
  `scondition` varchar(255) DEFAULT NULL,
  `aliasscondition` varchar(255) DEFAULT NULL,
  `createdat` datetime DEFAULT NULL,
  `updatedat` datetime DEFAULT NULL,
  `userid` varchar(50) DEFAULT NULL,
  `deletestatus` varchar(50) DEFAULT '0',
  `strgaprstatus` varchar(50) DEFAULT '0',
  `strgrejstatus` varchar(50) DEFAULT '0',
  `strgaprtime` datetime DEFAULT NULL,
  `strgrejtime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table storagecondition
-- 

/*!40000 ALTER TABLE `storagecondition` DISABLE KEYS */;
INSERT INTO `storagecondition`(`id`,`product`,`productid`,`grade`,`scondition`,`aliasscondition`,`createdat`,`updatedat`,`userid`,`deletestatus`,`strgaprstatus`,`strgrejstatus`,`strgaprtime`,`strgrejtime`) VALUES
(1,'CHLOROBUTANOL',1,'BP',NULL,'In an air tight container','2024-08-11 15:07:16',NULL,'39','0','1','0','2024-08-11 16:12:16',NULL),
(2,'CHLOROBUTANOL',1,'IP',NULL,'Store protect from moisture at temperature not exceeding 30°C','2024-08-16 15:37:38','2024-10-05 12:59:05','39','0','1','0','2024-10-05 12:59:39',NULL),
(3,'FUROSEMIDE',6,'IP',NULL,'Store protect from moisture and light','2024-08-17 11:19:32',NULL,'39','1','1','0','2024-10-04 14:50:58',NULL),
(4,'CHLOROBUTANOL',1,'USP',NULL,'Preserve in tight container','2024-08-23 15:07:55',NULL,'39','0','1','0','2024-08-24 15:21:47',NULL),
(5,'A',8,'IP',NULL,'A IP STORAGE','2024-09-17 15:09:12',NULL,'36','0','1','0','2024-09-17 15:09:21',NULL),
(6,'CHLOROBUTANOL',1,'EP',NULL,'In an air tight container','2024-10-04 11:25:59',NULL,'39','0','1','0','2024-10-04 14:14:35',NULL),
(7,'CHLOROBUTANOL',1,'TECHNICAL',NULL,'In an air tight container','2024-10-04 11:26:40','2024-10-04 14:28:14','39','0','1','0','2024-10-04 14:29:39','2024-10-04 14:13:34'),
(8,'DOCUSATE SODIUM',2,'IP',NULL,'Store protect from moisture','2024-10-04 11:27:44',NULL,'39','0','1','0','2024-10-04 14:10:27',NULL),
(9,'DOCUSATE SODIUM',2,'BP',NULL,'In an air tight container','2024-10-04 11:28:14',NULL,'39','0','1','0','2024-10-04 14:10:10',NULL),
(10,'DOCUSATE SODIUM',2,'EP',NULL,'In an air tight container','2024-10-04 11:28:48',NULL,'39','0','1','0','2024-10-04 14:09:52',NULL),
(11,'DOCUSATE SODIUM',2,'USP',NULL,'Preserve in well closed container','2024-10-04 11:29:17',NULL,'39','0','1','0','2024-10-04 14:08:58',NULL);
/*!40000 ALTER TABLE `storagecondition` ENABLE KEYS */;

-- 
-- Definition of userm
-- 

DROP TABLE IF EXISTS `userm`;
CREATE TABLE IF NOT EXISTS `userm` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) DEFAULT '',
  `password` varchar(50) DEFAULT '',
  `rights` varchar(500) DEFAULT '',
  `addproduct` varchar(100) DEFAULT '',
  `scondition` varchar(100) DEFAULT '',
  `batch` varchar(100) DEFAULT '',
  `customerr` varchar(100) DEFAULT '',
  `dispatch` varchar(100) DEFAULT '',
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  `dispatchreport` varchar(100) DEFAULT '',
  `generateqr` varchar(100) DEFAULT '',
  `logreport` varchar(100) DEFAULT '',
  `manufact` varchar(100) DEFAULT '',
  `products` varchar(100) DEFAULT '',
  `returnstocks` varchar(100) DEFAULT '',
  `rsreport` varchar(100) DEFAULT '',
  `ssccreport` varchar(100) DEFAULT '',
  `stocks` varchar(100) DEFAULT '',
  `generateqradministration` varchar(100) DEFAULT '',
  `userm` varchar(100) DEFAULT '',
  `role` varchar(50) DEFAULT NULL,
  `aliasproductadmin` varchar(50) DEFAULT NULL,
  `customeradmin` varchar(50) DEFAULT NULL,
  `dispatchadmin` varchar(50) DEFAULT NULL,
  `generateqradmin` varchar(50) DEFAULT NULL,
  `manufactureadmin` varchar(50) DEFAULT NULL,
  `pbatchadmin` varchar(50) DEFAULT NULL,
  `productadmin` varchar(50) DEFAULT NULL,
  `returnstockadmin` varchar(50) DEFAULT NULL,
  `stockadmin` varchar(50) DEFAULT NULL,
  `usermadmin` varchar(50) DEFAULT NULL,
  `sconditionadmin` varchar(50) DEFAULT NULL,
  `aliasproductadministration` varchar(50) DEFAULT NULL,
  `customeradministration` varchar(50) DEFAULT NULL,
  `dispatchadministration` varchar(50) DEFAULT NULL,
  `manufactureadministration` varchar(50) DEFAULT NULL,
  `pbatchadministration` varchar(50) DEFAULT NULL,
  `productadministration` varchar(50) DEFAULT NULL,
  `returnstockadministration` varchar(50) DEFAULT NULL,
  `stockadministration` varchar(50) DEFAULT NULL,
  `usermadministration` varchar(50) DEFAULT NULL,
  `sconditionadministration` varchar(50) DEFAULT NULL,
  `aliasproductqa` varchar(50) DEFAULT NULL,
  `customerqa` varchar(50) DEFAULT NULL,
  `dispatchqa` varchar(50) DEFAULT NULL,
  `generateqrqa` varchar(50) DEFAULT NULL,
  `manufactureqa` varchar(50) DEFAULT NULL,
  `pbatchqa` varchar(50) DEFAULT NULL,
  `productqa` varchar(50) DEFAULT NULL,
  `returnstockqa` varchar(50) DEFAULT NULL,
  `stockqa` varchar(50) DEFAULT NULL,
  `usermqa` varchar(50) DEFAULT NULL,
  `sconditionqa` varchar(50) DEFAULT NULL,
  `name` varchar(50) DEFAULT NULL,
  `approval` varchar(50) DEFAULT NULL,
  `reports` varchar(50) DEFAULT NULL,
  `subuser` varchar(255) DEFAULT NULL,
  `stockconversion` varchar(255) DEFAULT NULL,
  `stockdiscard` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table userm
-- 

/*!40000 ALTER TABLE `userm` DISABLE KEYS */;
INSERT INTO `userm`(`id`,`username`,`password`,`rights`,`addproduct`,`scondition`,`batch`,`customerr`,`dispatch`,`created`,`updated`,`dispatchreport`,`generateqr`,`logreport`,`manufact`,`products`,`returnstocks`,`rsreport`,`ssccreport`,`stocks`,`generateqradministration`,`userm`,`role`,`aliasproductadmin`,`customeradmin`,`dispatchadmin`,`generateqradmin`,`manufactureadmin`,`pbatchadmin`,`productadmin`,`returnstockadmin`,`stockadmin`,`usermadmin`,`sconditionadmin`,`aliasproductadministration`,`customeradministration`,`dispatchadministration`,`manufactureadministration`,`pbatchadministration`,`productadministration`,`returnstockadministration`,`stockadministration`,`usermadministration`,`sconditionadministration`,`aliasproductqa`,`customerqa`,`dispatchqa`,`generateqrqa`,`manufactureqa`,`pbatchqa`,`productqa`,`returnstockqa`,`stockqa`,`usermqa`,`sconditionqa`,`name`,`approval`,`reports`,`subuser`,`stockconversion`,`stockdiscard`) VALUES
(36,'demoadmin','1234','','create,read,edit,delete','create,read,edit,delete','create,read,edit,delete','create,read,edit,delete','create,read,edit,delete',NULL,NULL,'','create,read,preview,print','','create,read,edit,delete','create,read,edit,delete','create,read,edit,delete','','','create,read,edit,delete','','create,read,edit,delete','Admin','36','36','36','36','36','36','36','36','36','36','36','','','','','','','','','','','','','','','','','','','','','','Demo Admin','Show','Show','39,38,37,36','create,read,delete','create,read,delete'),
(37,'qa-neha','qalopl#1','','read','','read','read','read',NULL,NULL,'','read,preview','','read','read','read','','','read','','','Quality Assurance','','','','','','','','','','',NULL,'','','','','','','','','',NULL,'','','','','','','','','','',NULL,'QA Neha','Show','Show','',NULL,NULL),
(38,'office-mukesh','officelopl#1','','create,read','create,read','create,read','create,read','create,read',NULL,NULL,'','read,preview','','create,read','create,read','create,read','','','create,read','38','','Administration','36','36','36','36','36','36','36','36','36','','36','38','38','38','38','38','38','38','38','','38','37','37','37','37','37','37','37','37','37','','37','OFFICE Mukesh','Show','Show','',NULL,NULL),
(39,'user-faisal','userlopl#1','','create,read,edit,delete','create,read,edit,delete','create,read,edit,delete','create,read,edit,delete','create,read,edit,delete',NULL,NULL,'','create,read,preview,print','','create,read,edit,delete','create,read,edit,delete','create,read,edit,delete','','','create,read,edit,delete','','','User','','','','','','','','','','','','','38','38','','','','38','','','','37','','','37','37','37','37','','','','37','USER Faisal','Show','Show','',NULL,NULL);
/*!40000 ALTER TABLE `userm` ENABLE KEYS */;

-- 
-- Definition of userrolemapping
-- 

DROP TABLE IF EXISTS `userrolemapping`;
CREATE TABLE IF NOT EXISTS `userrolemapping` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Userid` int(11) NOT NULL DEFAULT '0',
  `adminroleid` varchar(50) NOT NULL DEFAULT '0',
  `adnimistratorroleid` varchar(50) NOT NULL DEFAULT '0',
  `qualityroleid` varchar(50) NOT NULL DEFAULT '0',
  `companyunit` varchar(50) NOT NULL DEFAULT '0',
  `companyid` varchar(50) NOT NULL DEFAULT '0',
  `adminstatus` bit(1) DEFAULT NULL,
  `administratorstatus` bit(1) DEFAULT NULL,
  `qualityarrusarnacestatus` bit(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table userrolemapping
-- 

/*!40000 ALTER TABLE `userrolemapping` DISABLE KEYS */;
INSERT INTO `userrolemapping`(`id`,`Userid`,`adminroleid`,`adnimistratorroleid`,`qualityroleid`,`companyunit`,`companyid`,`adminstatus`,`administratorstatus`,`qualityarrusarnacestatus`) VALUES
(1,3,'1','1','2','CRUD','22',0,NULL,NULL);
/*!40000 ALTER TABLE `userrolemapping` ENABLE KEYS */;


/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;


-- Dump completed on 2024-10-16 13:47:35
-- Total time: 0:0:0:0:296 (d:h:m:s:ms)
