-- MySqlBackup.NET 2.0.4
-- Dump Time: 2024-10-07 15:55:21
-- --------------------------------------
-- 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 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 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=2 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','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=27 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','0','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','0','0','1','0','0','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','0','0','1','0','0','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','0','0','1','0','0','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','0','0','1','0','0','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','0','0','1','0','0','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','0','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','0','0','1','0','0','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','0','0','1','0','0','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','0','0','1','0','0','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','0','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','0','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','0','0','1','0','0','0','2024-10-03 00:00:00','2024-10-04 14:34:10',NULL,'In an air tight container','1'),
(19,'1','LAX/1024/019','','2','','','11','','','','5','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','5','40','','200','0','0','1','0','0','0','2024-10-03 00:00:00','2024-10-04 14:33:49',NULL,'Store protect from moisture at temperature not exceeding 30° C','2'),
(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'),
(21,'1','LAX/1024/021','','2','','','22','','','','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-10-04 00:00:00','2024-10-05 11:53:02',NULL,'Store protect from moisture at temperature not exceeding 30° C','2'),
(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');
/*!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=284 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'),
(208,'1/40','19','0.25','5.25','177','089061816400091773','0','0','0','5','11'),
(209,'2/40','19','0.25','5.25','178','089061816400091782','0','0','0','5','11'),
(210,'3/40','19','0.25','5.25','179','089061816400091791','0','0','0','5','11'),
(211,'4/40','19','0.25','5.25','180','089061816400091807','0','0','0','5','11'),
(212,'5/40','19','0.25','5.25','181','089061816400091816','0','0','0','5','11'),
(213,'6/40','19','0.25','5.25','182','089061816400091825','0','0','0','5','11'),
(214,'7/40','19','0.25','5.25','183','089061816400091834','0','0','0','5','11'),
(215,'8/40','19','0.25','5.25','184','089061816400091843','0','0','0','5','11'),
(216,'9/40','19','0.25','5.25','185','089061816400091852','0','0','0','5','11'),
(217,'10/40','19','0.25','5.25','186','089061816400091861','0','0','0','5','11'),
(218,'11/40','19','0.25','5.25','187','089061816400091870','0','0','0','5','11'),
(219,'12/40','19','0.25','5.25','188','089061816400091889','0','0','0','5','11'),
(220,'13/40','19','0.25','5.25','189','089061816400091898','0','0','0','5','11'),
(221,'14/40','19','0.25','5.25','190','089061816400091904','0','0','0','5','11'),
(222,'15/40','19','0.25','5.25','191','089061816400091913','0','0','0','5','11'),
(223,'16/40','19','0.25','5.25','192','089061816400091922','0','0','0','5','11'),
(224,'17/40','19','0.25','5.25','193','089061816400091931','0','0','0','5','11'),
(225,'18/40','19','0.25','5.25','194','089061816400091940','0','0','0','5','11'),
(226,'19/40','19','0.25','5.25','195','089061816400091959','0','0','0','5','11'),
(227,'20/40','19','0.25','5.25','196','089061816400091968','0','0','0','5','11'),
(228,'21/40','19','0.25','5.25','197','089061816400091977','0','0','0','5','11'),
(229,'22/40','19','0.25','5.25','198','089061816400091986','0','0','0','5','11'),
(230,'23/40','19','0.25','5.25','199','089061816400091995','0','0','0','5','11'),
(231,'24/40','19','0.25','5.25','200','089061816400092000','0','0','0','5','11'),
(232,'25/40','19','0.25','5.25','201','089061816400092019','0','0','0','5','11'),
(233,'26/40','19','0.25','5.25','202','089061816400092028','0','0','0','5','11'),
(234,'27/40','19','0.25','5.25','203','089061816400092037','0','0','0','5','11'),
(235,'28/40','19','0.25','5.25','204','089061816400092046','0','0','0','5','11'),
(236,'29/40','19','0.25','5.25','205','089061816400092055','0','0','0','5','11'),
(237,'30/40','19','0.25','5.25','206','089061816400092064','0','0','0','5','11'),
(238,'31/40','19','0.25','5.25','207','089061816400092073','0','0','0','5','11'),
(239,'32/40','19','0.25','5.25','208','089061816400092082','0','0','0','5','11'),
(240,'33/40','19','0.25','5.25','209','089061816400092091','0','0','0','5','11'),
(241,'34/40','19','0.25','5.25','210','089061816400092107','0','0','0','5','11'),
(242,'35/40','19','0.25','5.25','211','089061816400092116','0','0','0','5','11'),
(243,'36/40','19','0.25','5.25','212','089061816400092125','0','0','0','5','11'),
(244,'37/40','19','0.25','5.25','213','089061816400092134','0','0','0','5','11'),
(245,'38/40','19','0.25','5.25','214','089061816400092143','0','0','0','5','11'),
(246,'39/40','19','0.25','5.25','215','089061816400092152','0','0','0','5','11'),
(247,'40/40','19','0.25','5.25','216','089061816400092161','0','0','0','5','11'),
(248,'1/1','20','3.3','28.3','001','089061816400230017','0','0','0','25','24'),
(249,'1/20','21','2.8','27.8','217','089061816400092170','0','0','0','25','22'),
(250,'2/20','21','2.8','27.8','218','089061816400092189','0','0','0','25','22'),
(251,'3/20','21','2.8','27.8','219','089061816400092198','0','0','0','25','22'),
(252,'4/20','21','2.8','27.8','220','089061816400092204','0','0','0','25','22'),
(253,'5/20','21','2.8','27.8','221','089061816400092213','0','0','0','25','22'),
(254,'6/20','21','2.8','27.8','222','089061816400092222','0','0','0','25','22'),
(255,'7/20','21','2.8','27.8','223','089061816400092231','0','0','0','25','22'),
(256,'8/20','21','2.8','27.8','224','089061816400092240','0','0','0','25','22'),
(257,'9/20','21','2.8','27.8','225','089061816400092259','0','0','0','25','22'),
(258,'10/20','21','2.8','27.8','226','089061816400092268','0','0','0','25','22'),
(259,'11/20','21','2.8','27.8','227','089061816400092277','0','0','0','25','22'),
(260,'12/20','21','2.8','27.8','228','089061816400092286','0','0','0','25','22'),
(261,'13/20','21','2.8','27.8','229','089061816400092295','0','0','0','25','22'),
(262,'14/20','21','2.8','27.8','230','089061816400092301','0','0','0','25','22'),
(263,'15/20','21','2.8','27.8','231','089061816400092310','0','0','0','25','22'),
(264,'16/20','21','2.8','27.8','232','089061816400092329','0','0','0','25','22'),
(265,'17/20','21','2.8','27.8','233','089061816400092338','0','0','0','25','22'),
(266,'18/20','21','2.8','27.8','234','089061816400092347','0','0','0','25','22'),
(267,'19/20','21','2.8','27.8','235','089061816400092356','0','0','0','25','22'),
(268,'20/20','21','2.8','27.8','236','089061816400092365','0','0','0','25','22'),
(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');
/*!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=544 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');
/*!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=139 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','0','0','2024-10-05 11:01:47',NULL,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');
/*!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,
  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`) 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'),
(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',''),
(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',''),
(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','');
/*!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-07 15:55:22
-- Total time: 0:0:0:0:797 (d:h:m:s:ms)