-- MySqlBackup.NET 2.0.4
-- Dump Time: 2024-10-15 17:37:32
-- --------------------------------------
-- 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=9 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,'0','1','0','2024-08-17 11:18:53',NULL),
(5,'DOCUSATE SODIUM','DOCUSATE SODIUM',2,'2024-09-18 09:45:19',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'39',NULL,NULL,NULL,'0','1','0','2024-09-18 09:45:25',NULL),
(6,'DOCUSATE SODIUM 85%','DOCUSATE SODIUM 85% POWDER',3,'2024-09-18 12:50:44','2024-10-02 13:04:21',NULL,NULL,NULL,NULL,NULL,NULL,'39',NULL,NULL,NULL,'0','1','0','2024-10-02 13:04:27',NULL),
(7,'-','PROPYL GALLATE',4,'2024-09-28 11:16:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'39',NULL,NULL,NULL,'0','1','0','2024-09-28 17:13:42',NULL),
(8,'Test 1 Alias','Test 1',8,'2024-10-07 15:43:21',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'36',NULL,NULL,NULL,'0','1','0','2024-10-07 15:43:24',NULL);
/*!40000 ALTER TABLE `aliasproduct` ENABLE KEYS */;

-- 
-- Definition of consumedstock
-- 

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

-- 
-- Dumping data for table consumedstock
-- 

/*!40000 ALTER TABLE `consumedstock` DISABLE KEYS */;
INSERT INTO `consumedstock`(`id`,`batch`,`comprodqty`,`productid`,`comprodid`,`conbatch`,`qty`,`date`) VALUES
(1,'5','201','1','1','4','20','2024-01-26 00:00:00');
/*!40000 ALTER TABLE `consumedstock` ENABLE KEYS */;

-- 
-- Definition of customer
-- 

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

-- 
-- Dumping data for table customer
-- 

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

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

-- 
-- Definition of discardedstock
-- 

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

-- 
-- Dumping data for table discardedstock
-- 

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

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

-- 
-- Definition of dispatch
-- 

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

-- 
-- Dumping data for table dispatch
-- 

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

/*!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=31 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','0','0','1','0','0','0','2024-08-11 00:00:00','2024-08-11 16:16:38',NULL,'In an air tight container',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,'2','LAX/0924/012','','5','','','12','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','BP','25','5','','125','0','0','1','0','0','0','2024-09-18 00:00:00','2024-09-18 09:47:11',NULL,'In an air tight container','5'),
(13,'2','LAX/0924/013','','5','','','12','','','','5','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','BP','5','1','','5','0','0','1','0','0','0','2024-09-18 00:00:00','2024-09-18 09:48:18',NULL,'In an air tight container','5'),
(14,'1','LAX/0924/014','','1','','','13','','','','25','2024-10-01 00:00:00','2029-09-01 00:00:00','39','0','','','','BP','25','20','','500','0','0','1','0','0','0','2024-09-19 00:00:00','2024-09-19 15:28:29',NULL,'In an air tight container','1'),
(15,'1','LAX/0924/015','','1','','','14','','','','25','2024-10-01 00:00:00','2029-09-01 00:00:00','39','0','','','','BP','25','20','','500','0','0','1','0','0','0','2024-09-19 00:00:00','2024-09-19 15:28:49',NULL,'In an air tight container','1'),
(16,'1','LAX/0924/016','','1','','','15','','','','25','2024-10-01 00:00:00','2029-09-01 00:00:00','39','0','','','','BP','25','20','','500','0','0','1','0','0','0','2024-09-19 00:00:00','2024-09-19 15:29:01',NULL,'In an air tight container','1'),
(17,'1','LAX/0924/017','','1','','','16','','','','25','2024-10-01 00:00:00','2029-09-01 00:00:00','39','0','','','','BP','25','20','','500','0','0','1','0','0','0','2024-09-19 00:00:00','2024-09-19 15:29:35',NULL,'In an air tight container','1'),
(18,'1','LAX/0924/018','','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-09-20 00:00:00','2024-09-20 16:17:28',NULL,'Preserve in tight container','4'),
(19,'1','LAX/0924/019','','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-09-20 00:00:00','2024-09-20 16:17:39',NULL,'Preserve in tight container','4'),
(20,'1','LAX/0924/020','','1','','','18','','','','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-09-20 00:00:00','2024-09-20 16:20:16',NULL,'Preserve in tight container','4'),
(21,'1','LAX/0924/021','','2','','','19','','','','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-09-22 00:00:00','2024-09-22 16:45:21',NULL,'Store protect from moisture at temperature not exceeding 30° C','2'),
(22,'1','LAX/0924/022','','2','','','19','','','','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-09-22 00:00:00','2024-09-24 12:08:47',NULL,'Store protect from moisture at temperature not exceeding 30° C','2'),
(23,'1','LAX/0924/023','','2','','','19','','','','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-09-27 00:00:00','2024-09-28 15:08:18',NULL,'Store protect from moisture at temperature not exceeding 30° C','2'),
(24,'1','LAX/0924/024','','2','','','19','','','','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-09-28 00:00:00','2024-09-28 15:08:52',NULL,'Store protect from moisture at temperature not exceeding 30° C','2'),
(25,'1','LAX/0924/025','','2','','','19','','','','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-09-28 00:00:00','2024-09-28 15:09:05',NULL,'Store protect from moisture at temperature not exceeding 30° C','2'),
(26,'2','LAX/0924/026','','5','','','21','','','','5','2024-10-01 00:00:00','2029-09-01 00:00:00','39','0','','','','USP','5','1','','5','0','0','1','0','0','0','2024-09-28 00:00:00','2024-09-28 17:13:59',NULL,'Preserve in well closed container','7'),
(27,'2','LAX/0924/027','','5','','','21','','','','5','2024-10-01 00:00:00','2029-09-01 00:00:00','39','0','','','','USP','5','1','','5','0','0','1','0','0','0','2024-09-28 00:00:00','2024-09-28 17:14:11',NULL,'Preserve in well closed container','7'),
(28,'1','LAX/0924/028','','1','','','20','','','','25','2024-10-01 00:00:00','2029-09-01 00:00:00','39','0','','','','BP','25','20','','500','0','0','1','0','0','0','2024-09-28 00:00:00','2024-09-28 17:14:25',NULL,'In an air tight container','1'),
(29,'3','LAX/1024/029','','6','','','17','','','','25','2024-07-01 00:00:00','2029-06-01 00:00:00','39','0','','','','TECHNICAL','25','1','','25','0','0','1','0','0','0','2024-10-02 00:00:00','2024-10-02 13:06:44',NULL,'Preserve in well closed container','8'),
(30,'8','LAX/1024/030','','8','','','22','','','','25','2024-11-01 00:00:00','2026-01-01 00:00:00','36','0','','','','In-House','25','2','','50','0','0','1','0','0','0','2024-10-07 00:00:00','2024-10-07 15:44:40',NULL,'Teest 1 In-House Grade','9');
/*!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=325 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'),
(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/5','12','2.2','27.2','001','089061816400230017','0','0','0','25','12'),
(149,'2/5','12','2.2','27.2','002','089061816400230026','0','0','0','25','12'),
(150,'3/5','12','2.2','27.2','003','089061816400230035','0','0','0','25','12'),
(151,'4/5','12','2.2','27.2','004','089061816400230044','0','0','0','25','12'),
(152,'5/5','12','2.2','27.2','005','089061816400230053','0','0','0','25','12'),
(153,'1/1','13','0.9','5.9','006','089061816400230062','0','0','0','5','12'),
(154,'1/20','14','2.2','27.2','121','089061816400091214','0','0','0','25','13'),
(155,'2/20','14','2.2','27.2','122','089061816400091223','0','0','0','25','13'),
(156,'3/20','14','2.2','27.2','123','089061816400091232','0','0','0','25','13'),
(157,'4/20','14','2.2','27.2','124','089061816400091241','0','0','0','25','13'),
(158,'5/20','14','2.2','27.2','125','089061816400091250','0','0','0','25','13'),
(159,'6/20','14','2.2','27.2','126','089061816400091269','0','0','0','25','13'),
(160,'7/20','14','2.2','27.2','127','089061816400091278','0','0','0','25','13'),
(161,'8/20','14','2.2','27.2','128','089061816400091287','0','0','0','25','13'),
(162,'9/20','14','2.2','27.2','129','089061816400091296','0','0','0','25','13'),
(163,'10/20','14','2.2','27.2','130','089061816400091302','0','0','0','25','13'),
(164,'11/20','14','2.2','27.2','131','089061816400091311','0','0','0','25','13'),
(165,'12/20','14','2.2','27.2','132','089061816400091320','0','0','0','25','13'),
(166,'13/20','14','2.2','27.2','133','089061816400091339','0','0','0','25','13'),
(167,'14/20','14','2.2','27.2','134','089061816400091348','0','0','0','25','13'),
(168,'15/20','14','2.2','27.2','135','089061816400091357','0','0','0','25','13'),
(169,'16/20','14','2.2','27.2','136','089061816400091366','0','0','0','25','13'),
(170,'17/20','14','2.2','27.2','137','089061816400091375','0','0','0','25','13'),
(171,'18/20','14','2.2','27.2','138','089061816400091384','0','0','0','25','13'),
(172,'19/20','14','2.2','27.2','139','089061816400091393','0','0','0','25','13'),
(173,'20/20','14','2.2','27.2','140','089061816400091409','0','0','0','25','13'),
(174,'1/20','15','2.2','27.2','141','089061816400091418','0','0','0','25','14'),
(175,'2/20','15','2.2','27.2','142','089061816400091427','0','0','0','25','14'),
(176,'3/20','15','2.2','27.2','143','089061816400091436','0','0','0','25','14'),
(177,'4/20','15','2.2','27.2','144','089061816400091445','0','0','0','25','14'),
(178,'5/20','15','2.2','27.2','145','089061816400091454','0','0','0','25','14'),
(179,'6/20','15','2.2','27.2','146','089061816400091463','0','0','0','25','14'),
(180,'7/20','15','2.2','27.2','147','089061816400091472','0','0','0','25','14'),
(181,'8/20','15','2.2','27.2','148','089061816400091481','0','0','0','25','14'),
(182,'9/20','15','2.2','27.2','149','089061816400091490','0','0','0','25','14'),
(183,'10/20','15','2.2','27.2','150','089061816400091506','0','0','0','25','14'),
(184,'11/20','15','2.2','27.2','151','089061816400091515','0','0','0','25','14'),
(185,'12/20','15','2.2','27.2','152','089061816400091524','0','0','0','25','14'),
(186,'13/20','15','2.2','27.2','153','089061816400091533','0','0','0','25','14'),
(187,'14/20','15','2.2','27.2','154','089061816400091542','0','0','0','25','14'),
(188,'15/20','15','2.2','27.2','155','089061816400091551','0','0','0','25','14'),
(189,'16/20','15','2.2','27.2','156','089061816400091560','0','0','0','25','14'),
(190,'17/20','15','2.2','27.2','157','089061816400091579','0','0','0','25','14'),
(191,'18/20','15','2.2','27.2','158','089061816400091588','0','0','0','25','14'),
(192,'19/20','15','2.2','27.2','159','089061816400091597','0','0','0','25','14'),
(193,'20/20','15','2.2','27.2','160','089061816400091603','0','0','0','25','14'),
(194,'1/20','16','2.2','27.2','161','089061816400091612','0','0','0','25','15'),
(195,'2/20','16','2.2','27.2','162','089061816400091621','0','0','0','25','15'),
(196,'3/20','16','2.2','27.2','163','089061816400091630','0','0','0','25','15'),
(197,'4/20','16','2.2','27.2','164','089061816400091649','0','0','0','25','15'),
(198,'5/20','16','2.2','27.2','165','089061816400091658','0','0','0','25','15'),
(199,'6/20','16','2.2','27.2','166','089061816400091667','0','0','0','25','15'),
(200,'7/20','16','2.2','27.2','167','089061816400091676','0','0','0','25','15'),
(201,'8/20','16','2.2','27.2','168','089061816400091685','0','0','0','25','15'),
(202,'9/20','16','2.2','27.2','169','089061816400091694','0','0','0','25','15'),
(203,'10/20','16','2.2','27.2','170','089061816400091700','0','0','0','25','15'),
(204,'11/20','16','2.2','27.2','171','089061816400091719','0','0','0','25','15'),
(205,'12/20','16','2.2','27.2','172','089061816400091728','0','0','0','25','15'),
(206,'13/20','16','2.2','27.2','173','089061816400091737','0','0','0','25','15'),
(207,'14/20','16','2.2','27.2','174','089061816400091746','0','0','0','25','15'),
(208,'15/20','16','2.2','27.2','175','089061816400091755','0','0','0','25','15'),
(209,'16/20','16','2.2','27.2','176','089061816400091764','0','0','0','25','15'),
(210,'17/20','16','2.2','27.2','177','089061816400091773','0','0','0','25','15'),
(211,'18/20','16','2.2','27.2','178','089061816400091782','0','0','0','25','15'),
(212,'19/20','16','2.2','27.2','179','089061816400091791','0','0','0','25','15'),
(213,'20/20','16','2.2','27.2','180','089061816400091807','0','0','0','25','15'),
(214,'1/20','17','2.2','27.2','181','089061816400091816','0','0','0','25','16'),
(215,'2/20','17','2.2','27.2','182','089061816400091825','0','0','0','25','16'),
(216,'3/20','17','2.2','27.2','183','089061816400091834','0','0','0','25','16'),
(217,'4/20','17','2.2','27.2','184','089061816400091843','0','0','0','25','16'),
(218,'5/20','17','2.2','27.2','185','089061816400091852','0','0','0','25','16'),
(219,'6/20','17','2.2','27.2','186','089061816400091861','0','0','0','25','16'),
(220,'7/20','17','2.2','27.2','187','089061816400091870','0','0','0','25','16'),
(221,'8/20','17','2.2','27.2','188','089061816400091889','0','0','0','25','16'),
(222,'9/20','17','2.2','27.2','189','089061816400091898','0','0','0','25','16'),
(223,'10/20','17','2.2','27.2','190','089061816400091904','0','0','0','25','16'),
(224,'11/20','17','2.2','27.2','191','089061816400091913','0','0','0','25','16'),
(225,'12/20','17','2.2','27.2','192','089061816400091922','0','0','0','25','16'),
(226,'13/20','17','2.2','27.2','193','089061816400091931','0','0','0','25','16'),
(227,'14/20','17','2.2','27.2','194','089061816400091940','0','0','0','25','16'),
(228,'15/20','17','2.2','27.2','195','089061816400091959','0','0','0','25','16'),
(229,'16/20','17','2.2','27.2','196','089061816400091968','0','0','0','25','16'),
(230,'17/20','17','2.2','27.2','197','089061816400091977','0','0','0','25','16'),
(231,'18/20','17','2.2','27.2','198','089061816400091986','0','0','0','25','16'),
(232,'19/20','17','2.2','27.2','199','089061816400091995','0','0','0','25','16'),
(233,'20/20','17','2.2','27.2','200','089061816400092000','0','0','0','25','16'),
(234,'1/20','18','2.2','27.2','201','089061816400092019','0','0','0','25','7'),
(235,'2/20','18','2.2','27.2','202','089061816400092028','0','0','0','25','7'),
(236,'3/20','18','2.2','27.2','203','089061816400092037','0','0','0','25','7'),
(237,'4/20','18','2.2','27.2','204','089061816400092046','0','0','0','25','7'),
(238,'5/20','18','2.2','27.2','205','089061816400092055','0','0','0','25','7'),
(239,'6/20','18','2.2','27.2','206','089061816400092064','0','0','0','25','7'),
(240,'7/20','18','2.2','27.2','207','089061816400092073','0','0','0','25','7'),
(241,'8/20','18','2.2','27.2','208','089061816400092082','0','0','0','25','7'),
(242,'9/20','18','2.2','27.2','209','089061816400092091','0','0','0','25','7'),
(243,'10/20','18','2.2','27.2','210','089061816400092107','0','0','0','25','7'),
(244,'11/20','18','2.2','27.2','211','089061816400092116','0','0','0','25','7'),
(245,'12/20','18','2.2','27.2','212','089061816400092125','0','0','0','25','7'),
(246,'13/20','18','2.2','27.2','213','089061816400092134','0','0','0','25','7'),
(247,'14/20','18','2.2','27.2','214','089061816400092143','0','0','0','25','7'),
(248,'15/20','18','2.2','27.2','215','089061816400092152','0','0','0','25','7'),
(249,'16/20','18','2.2','27.2','216','089061816400092161','0','0','0','25','7'),
(250,'17/20','18','2.2','27.2','217','089061816400092170','0','0','0','25','7'),
(251,'18/20','18','2.2','27.2','218','089061816400092189','0','0','0','25','7'),
(252,'19/20','18','2.2','27.2','219','089061816400092198','0','0','0','25','7'),
(253,'20/20','18','2.2','27.2','220','089061816400092204','0','0','0','25','7'),
(254,'1/20','19','2.2','27.2','221','089061816400092213','0','0','0','25','8'),
(255,'2/20','19','2.2','27.2','222','089061816400092222','0','0','0','25','8'),
(256,'3/20','19','2.2','27.2','223','089061816400092231','0','0','0','25','8'),
(257,'4/20','19','2.2','27.2','224','089061816400092240','0','0','0','25','8'),
(258,'5/20','19','2.2','27.2','225','089061816400092259','0','0','0','25','8'),
(259,'6/20','19','2.2','27.2','226','089061816400092268','0','0','0','25','8'),
(260,'7/20','19','2.2','27.2','227','089061816400092277','0','0','0','25','8'),
(261,'8/20','19','2.2','27.2','228','089061816400092286','0','0','0','25','8'),
(262,'9/20','19','2.2','27.2','229','089061816400092295','0','0','0','25','8'),
(263,'10/20','19','2.2','27.2','230','089061816400092301','0','0','0','25','8'),
(264,'11/20','19','2.2','27.2','231','089061816400092310','0','0','0','25','8'),
(265,'12/20','19','2.2','27.2','232','089061816400092329','0','0','0','25','8'),
(266,'13/20','19','2.2','27.2','233','089061816400092338','0','0','0','25','8'),
(267,'14/20','19','2.2','27.2','234','089061816400092347','0','0','0','25','8'),
(268,'15/20','19','2.2','27.2','235','089061816400092356','0','0','0','25','8'),
(269,'16/20','19','2.2','27.2','236','089061816400092365','0','0','0','25','8'),
(270,'17/20','19','2.2','27.2','237','089061816400092374','0','0','0','25','8'),
(271,'18/20','19','2.2','27.2','238','089061816400092383','0','0','0','25','8'),
(272,'19/20','19','2.2','27.2','239','089061816400092392','0','0','0','25','8'),
(273,'20/20','19','2.2','27.2','240','089061816400092408','0','0','0','25','8'),
(274,'1/20','20','2.2','27.2','241','089061816400092417','0','0','0','25','18'),
(275,'2/20','20','2.2','27.2','242','089061816400092426','0','0','0','25','18'),
(276,'3/20','20','2.2','27.2','243','089061816400092435','0','0','0','25','18'),
(277,'4/20','20','2.2','27.2','244','089061816400092444','0','0','0','25','18'),
(278,'5/20','20','2.2','27.2','245','089061816400092453','0','0','0','25','18'),
(279,'6/20','20','2.2','27.2','246','089061816400092462','0','0','0','25','18'),
(280,'7/20','20','2.2','27.2','247','089061816400092471','0','0','0','25','18'),
(281,'8/20','20','2.2','27.2','248','089061816400092480','0','0','0','25','18'),
(282,'9/20','20','2.2','27.2','249','089061816400092499','0','0','0','25','18'),
(283,'10/20','20','2.2','27.2','250','089061816400092505','0','0','0','25','18'),
(284,'11/20','20','2.2','27.2','251','089061816400092514','0','0','0','25','18'),
(285,'12/20','20','2.2','27.2','252','089061816400092523','0','0','0','25','18'),
(286,'13/20','20','2.2','27.2','253','089061816400092532','0','0','0','25','18'),
(287,'14/20','20','2.2','27.2','254','089061816400092541','0','0','0','25','18'),
(288,'15/20','20','2.2','27.2','255','089061816400092550','0','0','0','25','18'),
(289,'16/20','20','2.2','27.2','256','089061816400092569','0','0','0','25','18'),
(290,'17/20','20','2.2','27.2','257','089061816400092578','0','0','0','25','18'),
(291,'18/20','20','2.2','27.2','258','089061816400092587','0','0','0','25','18'),
(292,'19/20','20','2.2','27.2','259','089061816400092596','0','0','0','25','18'),
(293,'20/20','20','2.2','27.2','260','089061816400092602','0','0','0','25','18'),
(294,'1/1','21','2.8','27.8','261','089061816400092611','0','0','0','25','19'),
(295,'1/1','22','2.8','27.8','262','089061816400092620','0','0','0','25','19'),
(296,'1/1','23','2.8','27.8','263','089061816400092639','0','0','0','25','19'),
(297,'1/1','24','2.8','27.8','264','089061816400092648','0','0','0','25','19'),
(298,'1/2','25','2.8','27.8','265','089061816400092657','0','0','0','25','19'),
(299,'2/2','25','2.8','27.8','266','089061816400092666','0','0','0','25','19'),
(300,'1/1','26','0.25','5.25','007','089061816400230071','0','0','0','5','21'),
(301,'1/1','27','0.9','5.9','008','089061816400230080','0','0','0','5','21'),
(302,'1/20','28','2.2','27.2','267','089061816400092675','0','0','0','25','20'),
(303,'2/20','28','2.2','27.2','268','089061816400092684','0','0','0','25','20'),
(304,'3/20','28','2.2','27.2','269','089061816400092693','0','0','0','25','20'),
(305,'4/20','28','2.2','27.2','270','089061816400092709','0','0','0','25','20'),
(306,'5/20','28','2.2','27.2','271','089061816400092718','0','0','0','25','20'),
(307,'6/20','28','2.2','27.2','272','089061816400092727','0','0','0','25','20'),
(308,'7/20','28','2.2','27.2','273','089061816400092736','0','0','0','25','20'),
(309,'8/20','28','2.2','27.2','274','089061816400092745','0','0','0','25','20'),
(310,'9/20','28','2.2','27.2','275','089061816400092754','0','0','0','25','20'),
(311,'10/20','28','2.2','27.2','276','089061816400092763','0','0','0','25','20'),
(312,'11/20','28','2.2','27.2','277','089061816400092772','0','0','0','25','20'),
(313,'12/20','28','2.2','27.2','278','089061816400092781','0','0','0','25','20'),
(314,'13/20','28','2.2','27.2','279','089061816400092790','0','0','0','25','20'),
(315,'14/20','28','2.2','27.2','280','089061816400092806','0','0','0','25','20'),
(316,'15/20','28','2.2','27.2','281','089061816400092815','0','0','0','25','20'),
(317,'16/20','28','2.2','27.2','282','089061816400092824','0','0','0','25','20'),
(318,'17/20','28','2.2','27.2','283','089061816400092833','0','0','0','25','20'),
(319,'18/20','28','2.2','27.2','284','089061816400092842','0','0','0','25','20'),
(320,'19/20','28','2.2','27.2','285','089061816400092851','0','0','0','25','20'),
(321,'20/20','28','2.2','27.2','286','089061816400092860','0','0','0','25','20'),
(322,'1/1','29','2.2','27.2','001','089061816400300015','0','0','0','25','17'),
(323,'1/2','30','123.65','148.65','001','012345679910250015','0','0','0','25','22'),
(324,'2/2','30','123.65','148.65','002','012345679910250024','0','0','0','25','22');
/*!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=631 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 19:20:23','39','Login In'),
(312,NULL,'User Logged In','2024-09-18 09:42:03','39','Login In'),
(313,NULL,'User Logged In','2024-09-18 09:43:09','37','Login In'),
(314,NULL,'Batch Added','2024-09-18 09:44:13','39','Batch'),
(315,NULL,'Batch Approved','2024-09-18 09:44:25','37','Approval'),
(316,NULL,'Alias Product Added','2024-09-18 09:45:18','39','Alias Product'),
(317,NULL,'Alias Product Approved','2024-09-18 09:45:25','37','Approval'),
(318,NULL,'Storage Condition Added','2024-09-18 09:46:28','39','Storage Condition'),
(319,NULL,'Storage Condition Approved','2024-09-18 09:46:34','37','Storage Condition'),
(320,NULL,'QR generated','2024-09-18 09:47:05','39','Generateqr'),
(321,NULL,'Generateqr Approved','2024-09-18 09:47:11','37','Approval'),
(322,NULL,'QR generated','2024-09-18 09:48:10','39','Generateqr'),
(323,NULL,'Generateqr Approved','2024-09-18 09:48:18','37','Approval'),
(324,NULL,'Multiple Print Had Taken','2024-09-18 09:48:58','39','generateqrsr'),
(325,NULL,'Multiple Print Had Taken','2024-09-18 09:49:41','37','generateqrsr'),
(326,NULL,'Single Print Had Taken','2024-09-18 09:50:04','37','generateqrsr'),
(327,NULL,'User Logged In','2024-09-18 12:34:26','39','Login In'),
(328,NULL,'Batch Added','2024-09-18 12:35:22','39','Batch'),
(329,NULL,'Batch Added','2024-09-18 12:36:14','39','Batch'),
(330,NULL,'Batch Added','2024-09-18 12:37:14','39','Batch'),
(331,NULL,'User Logged In','2024-09-18 12:47:21','39','Login In'),
(332,NULL,'Batch Added','2024-09-18 12:48:14','39','Batch'),
(333,NULL,'Batch Added','2024-09-18 12:49:50','39','Batch'),
(334,NULL,'Alias Product Added','2024-09-18 12:50:43','39','Alias Product'),
(335,NULL,'Product Updated','2024-09-18 12:51:01','39','Product'),
(336,NULL,'User Logged In','2024-09-18 13:42:44','39','Login In'),
(337,NULL,'QR Deleted','2024-09-18 13:43:33','39','Generateqr'),
(338,NULL,'User Logged In','2024-09-18 14:05:52','37','Login In'),
(339,NULL,'Batch Approved','2024-09-18 14:06:25','37','Approval'),
(340,NULL,'Batch Approved','2024-09-18 14:06:46','37','Approval'),
(341,NULL,'Batch Approved','2024-09-18 14:07:08','37','Approval'),
(342,NULL,'Batch Approved','2024-09-18 14:07:20','37','Approval'),
(343,NULL,'Batch Approved','2024-09-18 14:07:40','37','Approval'),
(344,NULL,'Alias Product Approved','2024-09-18 14:08:13','37','Approval'),
(345,NULL,'Product Approved','2024-09-18 14:08:36','37','Approval'),
(346,NULL,'User Logged Out','2024-09-18 14:08:42','37','Log Out'),
(347,NULL,'User Logged In','2024-09-18 17:14:09','39','Login In'),
(348,NULL,'User Logged In','2024-09-19 12:17:06','39','Login In'),
(349,NULL,'QR generated','2024-09-19 12:17:58','39','Generateqr'),
(350,NULL,'QR generated','2024-09-19 12:18:41','39','Generateqr'),
(351,NULL,'QR generated','2024-09-19 12:19:11','39','Generateqr'),
(352,NULL,'QR generated','2024-09-19 12:19:57','39','Generateqr'),
(353,NULL,'User Logged In','2024-09-19 15:28:13','37','Login In'),
(354,NULL,'Generateqr Approved','2024-09-19 15:28:29','37','Approval'),
(355,NULL,'Generateqr Approved','2024-09-19 15:28:49','37','Approval'),
(356,NULL,'Generateqr Approved','2024-09-19 15:29:01','37','Approval'),
(357,NULL,'Generateqr Approved','2024-09-19 15:29:35','37','Approval'),
(358,NULL,'User Logged Out','2024-09-19 15:30:29','37','Log Out'),
(359,NULL,'User Logged In','2024-09-19 16:45:26','39','Login In'),
(360,NULL,'User Logged In','2024-09-19 17:42:00','36','Login In'),
(361,NULL,'User Logged In','2024-09-19 18:02:01','36','Login In'),
(362,NULL,'User Logged In','2024-09-19 18:03:06','36','Login In'),
(363,NULL,'User Logged In','2024-09-19 18:03:45','36','Login In'),
(364,NULL,'User Logged In','2024-09-19 18:05:11','36','Login In'),
(365,NULL,'User Logged In','2024-09-19 18:12:11','36','Login In'),
(366,NULL,'User Logged In','2024-09-19 18:22:57','36','Login In'),
(367,NULL,'User Logged In','2024-09-19 19:00:01','39','Login In'),
(368,NULL,'User Logged In','2024-09-19 19:00:28','39','Login In'),
(369,NULL,'Single Print Had Taken','2024-09-19 19:00:57','39','generateqrsr'),
(370,NULL,'Single Print Had Taken','2024-09-19 19:01:19','39','generateqrsr'),
(371,NULL,'Single Print Had Taken','2024-09-19 19:02:19','39','generateqrsr'),
(372,NULL,'Single Print Had Taken','2024-09-19 19:02:55','39','generateqrsr'),
(373,NULL,'Single Print Had Taken','2024-09-19 19:03:29','39','generateqrsr'),
(374,NULL,'Single Print Had Taken','2024-09-19 19:04:42','39','generateqrsr'),
(375,NULL,'Single Print Had Taken','2024-09-19 19:05:28','39','generateqrsr'),
(376,NULL,'Single Print Had Taken','2024-09-19 19:06:38','39','generateqrsr'),
(377,NULL,'Single Print Had Taken','2024-09-19 19:07:18','39','generateqrsr'),
(378,NULL,'Multiple Print Had Taken','2024-09-19 19:08:27','39','generateqrsr'),
(379,NULL,'Multiple Print Had Taken','2024-09-19 19:10:57','39','generateqrsr'),
(380,NULL,'Multiple Print Had Taken','2024-09-19 19:11:59','39','generateqrsr'),
(381,NULL,'Multiple Print Had Taken','2024-09-19 19:13:21','39','generateqrsr'),
(382,NULL,'Multiple Print Had Taken','2024-09-19 19:18:52','39','generateqrsr'),
(383,NULL,'User Logged In','2024-09-20 13:54:41','39','Login In'),
(384,NULL,'User Logged In','2024-09-20 15:58:50','39','Login In'),
(385,NULL,'QR generated','2024-09-20 16:01:03','39','Generateqr'),
(386,NULL,'QR generated','2024-09-20 16:03:07','39','Generateqr'),
(387,NULL,'Batch Added','2024-09-20 16:04:49','39','Batch'),
(388,NULL,'User Logged In','2024-09-20 16:17:06','37','Login In'),
(389,NULL,'Generateqr Approved','2024-09-20 16:17:28','37','Approval'),
(390,NULL,'Generateqr Approved','2024-09-20 16:17:39','37','Approval'),
(391,NULL,'Batch Approved','2024-09-20 16:18:06','37','Approval'),
(392,NULL,'User Logged Out','2024-09-20 16:18:14','37','Log Out'),
(393,NULL,'QR generated','2024-09-20 16:19:12','39','Generateqr'),
(394,NULL,'User Logged In','2024-09-20 16:19:47','37','Login In'),
(395,NULL,'Generateqr Approved','2024-09-20 16:20:16','37','Approval'),
(396,NULL,'Single Print Had Taken','2024-09-20 16:26:24','39','generateqrsr'),
(397,NULL,'Single Print Had Taken','2024-09-20 16:27:13','39','generateqrsr'),
(398,NULL,'Single Print Had Taken','2024-09-20 16:29:01','39','generateqrsr'),
(399,NULL,'Single Print Had Taken','2024-09-20 16:29:25','39','generateqrsr'),
(400,NULL,'User Logged In','2024-09-21 11:19:13','39','Login In'),
(401,NULL,'Batch Added','2024-09-21 11:20:39','39','Batch'),
(402,NULL,'User Logged In','2024-09-21 14:22:59','39','Login In'),
(403,NULL,'User Logged In','2024-09-21 14:57:43','37','Login In'),
(404,NULL,'Batch Approved','2024-09-21 14:59:08','37','Approval'),
(405,NULL,'User Logged In','2024-09-21 20:09:07','39','Login In'),
(406,NULL,'Single Print Had Taken','2024-09-21 20:09:50','39','generateqrsr'),
(407,NULL,'Single Print Had Taken','2024-09-21 20:10:27','39','generateqrsr'),
(408,NULL,'Single Print Had Taken','2024-09-21 20:10:43','39','generateqrsr'),
(409,NULL,'User Logged In','2024-09-21 20:11:34','39','Login In'),
(410,NULL,'Single Print Had Taken','2024-09-21 20:11:51','39','generateqrsr'),
(411,NULL,'Multiple Print Had Taken','2024-09-21 20:12:22','39','generateqrsr'),
(412,NULL,'Single Print Had Taken','2024-09-21 20:21:59','39','generateqrsr'),
(413,NULL,'Single Print Had Taken','2024-09-21 20:22:33','39','generateqrsr'),
(414,NULL,'Single Print Had Taken','2024-09-21 20:22:51','39','generateqrsr'),
(415,NULL,'Single Print Had Taken','2024-09-21 20:24:07','39','generateqrsr'),
(416,NULL,'Single Print Had Taken','2024-09-21 20:25:09','39','generateqrsr'),
(417,NULL,'Single Print Had Taken','2024-09-21 20:25:34','39','generateqrsr'),
(418,NULL,'Single Print Had Taken','2024-09-21 20:27:33','39','generateqrsr'),
(419,NULL,'Single Print Had Taken','2024-09-21 20:28:48','39','generateqrsr'),
(420,NULL,'Single Print Had Taken','2024-09-21 20:29:18','39','generateqrsr'),
(421,NULL,'Single Print Had Taken','2024-09-21 20:29:59','39','generateqrsr'),
(422,NULL,'Single Print Had Taken','2024-09-21 20:32:11','39','generateqrsr'),
(423,NULL,'User Logged In','2024-09-22 14:18:00','39','Login In'),
(424,NULL,'QR generated','2024-09-22 14:18:48','39','Generateqr'),
(425,NULL,'User Logged In','2024-09-22 16:03:39','39','Login In'),
(426,NULL,'User Logged In','2024-09-22 16:45:05','37','Login In'),
(427,NULL,'Generateqr Approved','2024-09-22 16:45:21','37','Approval'),
(428,NULL,'User Logged In','2024-09-22 18:07:16','39','Login In'),
(429,NULL,'User Logged In','2024-09-22 18:33:17','39','Login In'),
(430,NULL,'QR generated','2024-09-22 18:34:33','39','Generateqr'),
(431,NULL,'Single Print Had Taken','2024-09-22 18:37:39','39','generateqrsr'),
(432,NULL,'User Logged In','2024-09-22 18:39:05','39','Login In'),
(433,NULL,'Single Print Had Taken','2024-09-22 18:39:35','39','generateqrsr'),
(434,NULL,'User Logged In','2024-09-24 11:30:20','39','Login In'),
(435,NULL,'User Logged In','2024-09-24 12:00:09','39','Login In'),
(436,NULL,'User Logged In','2024-09-24 12:03:59','37','Login In'),
(437,NULL,'Single Print Had Taken','2024-09-24 12:04:54','37','generateqrsr'),
(438,NULL,'Single Print Had Taken','2024-09-24 12:05:27','37','generateqrsr'),
(439,NULL,'Single Print Had Taken','2024-09-24 12:05:58','37','generateqrsr'),
(440,NULL,'User Logged In','2024-09-24 12:07:38','37','Login In'),
(441,NULL,'Generateqr Approved','2024-09-24 12:08:47','37','Approval'),
(442,NULL,'User Logged In','2024-09-24 13:15:47','39','Login In'),
(443,NULL,'Single Print Had Taken','2024-09-24 13:16:08','39','generateqrsr'),
(444,NULL,'User Logged In','2024-09-24 15:30:50','36','Login In'),
(445,NULL,'User Logged In','2024-09-25 17:57:28','39','Login In'),
(446,NULL,'Single Print Had Taken','2024-09-25 17:58:31','39','generateqrsr'),
(447,NULL,'Single Print Had Taken','2024-09-25 17:59:12','39','generateqrsr'),
(448,NULL,'Single Print Had Taken','2024-09-25 17:59:42','39','generateqrsr'),
(449,NULL,'Single Print Had Taken','2024-09-25 18:00:21','39','generateqrsr'),
(450,NULL,'Single Print Had Taken','2024-09-25 18:00:47','39','generateqrsr'),
(451,NULL,'Single Print Had Taken','2024-09-25 18:01:11','39','generateqrsr'),
(452,NULL,'User Logged In','2024-09-26 12:42:29','36','Login In'),
(453,NULL,'User Logged In','2024-09-26 12:42:31','36','Login In'),
(454,NULL,'User Logged In','2024-09-26 18:48:19','36','Login In'),
(455,NULL,'User Logged In','2024-09-26 18:49:07','36','Login In'),
(456,NULL,'User Logged In','2024-09-26 19:00:33','36','Login In'),
(457,NULL,'User Logged In','2024-09-26 19:08:25','36','Login In'),
(458,NULL,'User Logged In','2024-09-26 19:14:52','36','Login In'),
(459,NULL,'User Logged In','2024-09-26 19:30:47','36','Login In'),
(460,NULL,'User Logged In','2024-09-26 20:11:32','39','Login In'),
(461,NULL,'Batch Added','2024-09-26 20:24:39','39','Batch'),
(462,NULL,'User Logged In','2024-09-26 20:36:33','39','Login In'),
(463,NULL,'User Logged In','2024-09-27 13:51:19','39','Login In'),
(464,NULL,'QR generated','2024-09-27 13:53:49','39','Generateqr'),
(465,NULL,'User Logged In','2024-09-27 16:30:57','39','Login In'),
(466,NULL,'User Logged In','2024-09-27 17:45:42','39','Login In'),
(467,NULL,'User Logged In','2024-09-27 17:47:09','37','Login In'),
(468,NULL,'User Logged In','2024-09-27 19:46:52','36','Login In'),
(469,NULL,'User Logged In','2024-09-27 20:01:46','36','Login In'),
(470,NULL,'User Logged In','2024-09-28 11:06:49','39','Login In'),
(471,NULL,'Batch Added','2024-09-28 11:12:45','39','Batch'),
(472,NULL,'QR generated','2024-09-28 11:14:17','39','Generateqr'),
(473,NULL,'QR generated','2024-09-28 11:15:44','39','Generateqr'),
(474,NULL,'Alias Product Added','2024-09-28 11:16:42','39','Alias Product'),
(475,NULL,'User Logged In','2024-09-28 11:57:03','39','Login In'),
(476,NULL,'User Logged In','2024-09-28 12:19:58','39','Login In'),
(477,NULL,'Storage Condition Added','2024-09-28 12:44:51','39','Storage Condition'),
(478,NULL,'User Logged In','2024-09-28 13:40:58','39','Login In'),
(479,NULL,'User Logged In','2024-09-28 15:06:28','37','Login In'),
(480,NULL,'Batch Approved','2024-09-28 15:08:05','37','Approval'),
(481,NULL,'Generateqr Approved','2024-09-28 15:08:18','37','Approval'),
(482,NULL,'Batch Approved','2024-09-28 15:08:38','37','Approval'),
(483,NULL,'Generateqr Approved','2024-09-28 15:08:52','37','Approval'),
(484,NULL,'Generateqr Approved','2024-09-28 15:09:05','37','Approval'),
(485,NULL,'Storage Condition Approved','2024-09-28 15:10:10','37','Storage Condition'),
(486,NULL,'User Logged Out','2024-09-28 15:10:30','37','Log Out'),
(487,NULL,'User Logged In','2024-09-28 15:12:48','39','Login In'),
(488,NULL,'User Logged In','2024-09-28 15:14:28','37','Login In'),
(489,NULL,'Storage Condition Added','2024-09-28 15:15:11','39','Storage Condition'),
(490,NULL,'Storage Condition Approved','2024-09-28 15:15:18','37','Storage Condition'),
(491,NULL,'QR generated','2024-09-28 15:16:10','39','Generateqr'),
(492,NULL,'QR generated','2024-09-28 15:16:37','39','Generateqr'),
(493,NULL,'QR generated','2024-09-28 15:17:07','39','Generateqr'),
(494,NULL,'User Logged Out','2024-09-28 15:19:01','37','Log Out'),
(495,NULL,'Multiple Print Had Taken','2024-09-28 15:22:01','39','generateqrsr'),
(496,NULL,'User Logged In','2024-09-28 15:23:24','39','Login In'),
(497,NULL,'Multiple Print Had Taken','2024-09-28 15:23:48','39','generateqrsr'),
(498,NULL,'Multiple Print Had Taken','2024-09-28 15:24:09','39','generateqrsr'),
(499,NULL,'Multiple Print Had Taken','2024-09-28 15:25:38','39','generateqrsr'),
(500,NULL,'User Logged In','2024-09-28 16:02:44','39','Login In'),
(501,NULL,'User Logged In','2024-09-28 16:22:12','39','Login In'),
(502,NULL,'User Logged In','2024-09-28 16:43:09','39','Login In'),
(503,NULL,'User Logged In','2024-09-28 17:12:57','39','Login In'),
(504,NULL,'User Logged In','2024-09-28 17:13:28','37','Login In'),
(505,NULL,'Alias Product Approved','2024-09-28 17:13:42','37','Approval'),
(506,NULL,'Generateqr Approved','2024-09-28 17:13:59','37','Approval'),
(507,NULL,'Generateqr Approved','2024-09-28 17:14:11','37','Approval'),
(508,NULL,'Generateqr Approved','2024-09-28 17:14:25','37','Approval'),
(509,NULL,'User Logged Out','2024-09-28 17:14:38','37','Log Out'),
(510,NULL,'User Logged In','2024-09-28 19:03:57','39','Login In'),
(511,NULL,'Multiple Print Had Taken','2024-09-28 19:05:10','39','generateqrsr'),
(512,NULL,'Single Print Had Taken','2024-09-28 19:05:40','39','generateqrsr'),
(513,NULL,'Single Print Had Taken','2024-09-28 19:06:15','39','generateqrsr'),
(514,NULL,'Single Print Had Taken','2024-09-28 19:06:51','39','generateqrsr'),
(515,NULL,'Single Print Had Taken','2024-09-28 19:07:18','39','generateqrsr'),
(516,NULL,'Single Print Had Taken','2024-09-28 19:08:28','39','generateqrsr'),
(517,NULL,'Single Print Had Taken','2024-09-28 19:09:00','39','generateqrsr'),
(518,NULL,'Multiple Print Had Taken','2024-09-28 19:10:08','39','generateqrsr'),
(519,NULL,'Single Print Had Taken','2024-09-28 19:13:34','39','generateqrsr'),
(520,NULL,'Single Print Had Taken','2024-09-28 19:14:10','39','generateqrsr'),
(521,NULL,'User Logged In','2024-09-29 11:55:22','39','Login In'),
(522,NULL,'User Logged In','2024-09-29 14:23:13','37','Login In'),
(523,NULL,'User Logged Out','2024-09-29 14:23:20','37','Log Out'),
(524,NULL,'User Logged In','2024-10-01 11:11:40','36','Login In'),
(525,NULL,'User Logged In','2024-10-01 11:33:49','36','Login In'),
(526,NULL,'User Logged In','2024-10-01 11:36:16','36','Login In'),
(527,NULL,'User Logged In','2024-10-01 11:44:46','36','Login In'),
(528,NULL,'User Logged In','2024-10-01 11:46:51','36','Login In'),
(529,NULL,'User Logged In','2024-10-01 11:57:10','36','Login In'),
(530,NULL,'User Logged In','2024-10-01 13:25:15','39','Login In'),
(531,NULL,'User Logged In','2024-10-01 16:58:05','36','Login In'),
(532,NULL,'User Logged In','2024-10-01 17:58:34','39','Login In'),
(533,NULL,'User Logged In','2024-10-01 17:59:24','39','Login In'),
(534,NULL,'User Logged In','2024-10-01 18:52:53','39','Login In'),
(535,NULL,'User Logged In','2024-10-02 12:54:27','39','Login In'),
(536,NULL,'Product Updated','2024-10-02 12:55:34','39','Product'),
(537,NULL,'User Logged In','2024-10-02 13:01:50','37','Login In'),
(538,NULL,'Product Approved','2024-10-02 13:02:12','37','Approval'),
(539,NULL,'Storage Condition Added','2024-10-02 13:03:32','39','Storage Condition'),
(540,NULL,'Storage Condition Approved','2024-10-02 13:03:40','37','Storage Condition'),
(541,NULL,'Alias Product Edited','2024-10-02 13:04:19','39','Alias Product'),
(542,NULL,'Alias Product Updated','2024-10-02 13:04:20','39','Alias Product'),
(543,NULL,'Alias Product Approved','2024-10-02 13:04:27','37','Approval'),
(544,NULL,'Product Updated','2024-10-02 13:05:39','39','Product'),
(545,NULL,'Product Approved','2024-10-02 13:05:46','37','Approval'),
(546,NULL,'Batch Updated','2024-10-02 13:06:01','39','Batch'),
(547,NULL,'Batch Approved','2024-10-02 13:06:07','37','Approval'),
(548,NULL,'QR generated','2024-10-02 13:06:36','39','Generateqr'),
(549,NULL,'Generateqr Approved','2024-10-02 13:06:44','37','Approval'),
(550,NULL,'Single Print Had Taken','2024-10-02 13:07:04','39','generateqrsr'),
(551,NULL,'Single Print Had Taken','2024-10-02 13:07:38','37','generateqrsr'),
(552,NULL,'Single Print Had Taken','2024-10-02 13:08:58','37','generateqrsr'),
(553,NULL,'Single Print Had Taken','2024-10-02 13:09:14','37','generateqrsr'),
(554,NULL,'Single Print Had Taken','2024-10-02 13:09:55','37','generateqrsr'),
(555,NULL,'User Logged In','2024-10-02 13:52:03','36','Login In'),
(556,NULL,'User Logged In','2024-10-02 16:11:24','36','Login In'),
(557,NULL,'User Logged In','2024-10-02 16:13:40','36','Login In'),
(558,NULL,'User Logged In','2024-10-02 16:50:49','36','Login In'),
(559,NULL,'User Logged In','2024-10-04 11:12:30','36','Login In'),
(560,NULL,'User Logged In','2024-10-04 12:01:46','36','Login In'),
(561,NULL,'User Logged In','2024-10-04 13:23:34','36','Login In'),
(562,NULL,'User Logged In','2024-10-04 13:30:54','36','Login In'),
(563,NULL,'User Logged In','2024-10-04 19:10:42','36','Login In'),
(564,NULL,'New User Added','2024-10-04 19:11:29','36','Rights Management'),
(565,NULL,'User Updated','2024-10-04 19:12:45','36','Rights Management'),
(566,NULL,'User Updated','2024-10-04 19:13:26','36','Rights Management'),
(567,NULL,'User Updated','2024-10-04 19:15:47','36','Rights Management'),
(568,NULL,'User Logged Out','2024-10-04 19:15:55','36','Log Out'),
(569,NULL,'User Logged In','2024-10-04 19:16:04','44','Login In'),
(570,NULL,'User Logged In','2024-10-05 10:24:43','39','Login In'),
(571,NULL,'Single Print Had Taken','2024-10-05 10:25:05','39','generateqrsr'),
(572,NULL,'Single Print Had Taken','2024-10-05 10:25:31','39','generateqrsr'),
(573,NULL,'User Logged In','2024-10-05 10:46:57','39','Login In'),
(574,NULL,'User Logged In','2024-10-05 15:08:59','36','Login In'),
(575,NULL,'User Logged In','2024-10-05 17:18:25','39','Login In'),
(576,NULL,'Single Print Had Taken','2024-10-05 17:19:01','39','generateqrsr'),
(577,NULL,'Single Print Had Taken','2024-10-05 17:19:17','39','generateqrsr'),
(578,NULL,'User Logged In','2024-10-06 13:26:18','39','Login In'),
(579,NULL,'Multiple Print Had Taken','2024-10-06 13:26:37','39','generateqrsr'),
(580,NULL,'User Logged In','2024-10-06 13:27:48','39','Login In'),
(581,NULL,'Multiple Print Had Taken','2024-10-06 13:28:26','39','generateqrsr'),
(582,NULL,'User Logged In','2024-10-07 10:46:51','36','Login In'),
(583,NULL,'User Updated','2024-10-07 10:49:18','36','Rights Management'),
(584,NULL,'User Logged Out','2024-10-07 10:49:27','36','Log Out'),
(585,NULL,'User Logged In','2024-10-07 10:49:33','36','Login In'),
(586,NULL,'User Logged In','2024-10-07 15:22:56','36','Login In'),
(587,NULL,'User Updated','2024-10-07 15:23:14','36','Rights Management'),
(588,NULL,'User Logged Out','2024-10-07 15:23:19','36','Log Out'),
(589,NULL,'User Logged In','2024-10-07 15:23:27','36','Login In'),
(590,NULL,'User Updated','2024-10-07 15:24:02','36','Rights Management'),
(591,NULL,'User Logged Out','2024-10-07 15:24:05','36','Log Out'),
(592,NULL,'User Logged In','2024-10-07 15:24:13','36','Login In'),
(593,NULL,'User Updated','2024-10-07 15:24:53','36','Rights Management'),
(594,NULL,'User Logged Out','2024-10-07 15:24:55','36','Log Out'),
(595,NULL,'User Logged In','2024-10-07 15:25:04','36','Login In'),
(596,NULL,'User Logged Out','2024-10-07 15:36:02','36','Log Out'),
(597,NULL,'User Logged In','2024-10-07 15:36:07','36','Login In'),
(598,NULL,'User Updated','2024-10-07 15:37:23','36','Rights Management'),
(599,NULL,'User Logged Out','2024-10-07 15:37:26','36','Log Out'),
(600,NULL,'User Logged In','2024-10-07 15:37:36','36','Login In'),
(601,NULL,'New Product Added','2024-10-07 15:42:16','36','Product'),
(602,NULL,'Product Approved','2024-10-07 15:42:22','36','Approval'),
(603,NULL,'Batch Added','2024-10-07 15:42:55','36','Batch'),
(604,NULL,'Batch Approved','2024-10-07 15:43:01','36','Approval'),
(605,NULL,'Alias Product Added','2024-10-07 15:43:20','36','Alias Product'),
(606,NULL,'Alias Product Approved','2024-10-07 15:43:24','36','Approval'),
(607,NULL,'Storage Condition Added','2024-10-07 15:43:47','36','Storage Condition'),
(608,NULL,'Storage Condition Approved','2024-10-07 15:43:57','36','Storage Condition'),
(609,NULL,'QR generated','2024-10-07 15:44:32','36','Generateqr'),
(610,NULL,'Generateqr Approved','2024-10-07 15:44:40','36','Approval'),
(611,NULL,'Single Print Had Taken','2024-10-07 15:45:03','36','generateqrsr'),
(612,NULL,'Multiple Print Had Taken','2024-10-07 15:45:31','36','generateqrsr'),
(613,NULL,'User Logged In','2024-10-07 20:23:22','39','Login In'),
(614,NULL,'User Logged In','2024-10-07 20:42:11','36','Login In'),
(615,NULL,'User Logged In','2024-10-08 13:48:30','39','Login In'),
(616,NULL,'Single Print Had Taken','2024-10-08 13:48:54','39','generateqrsr'),
(617,NULL,'User Logged In','2024-10-08 13:49:49','39','Login In'),
(618,NULL,'Single Print Had Taken','2024-10-08 13:50:07','39','generateqrsr'),
(619,NULL,'User Logged In','2024-10-09 20:28:23','36','Login In'),
(620,NULL,'User Logged In','2024-10-10 08:20:03','36','Login In'),
(621,NULL,'User Logged Out','2024-10-10 08:21:03','36','Log Out'),
(622,NULL,'User Logged In','2024-10-11 12:56:03','36','Login In'),
(623,NULL,'User Logged In','2024-10-14 11:27:45','36','Login In'),
(624,NULL,'User Logged In','2024-10-14 12:29:01','36','Login In'),
(625,NULL,'User Logged In','2024-10-14 13:33:10','36','Login In'),
(626,NULL,'User Logged In','2024-10-14 18:34:08','36','Login In'),
(627,NULL,'User Logged In','2024-10-14 19:16:42','36','Login In'),
(628,NULL,'User Logged In','2024-10-15 11:34:59','36','Login In'),
(629,NULL,'User Updated','2024-10-15 11:35:41','36','Rights Management'),
(630,NULL,'User Logged In','2024-10-15 17:29:29','36','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=98 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'),
(36,'37','2','storagecondition','1','0','2024-08-16 15:37:38','2024-08-16 17:10:45',NULL,NULL,'Store protect from moisture at temperature not exceeding 30° C','New Item','0','39'),
(37,'37','9','pbatch','1','0','2024-08-17 10:46:22','2024-08-17 11:13:51',NULL,NULL,'FR-10824','New Item','0','39'),
(38,'37','4','addproduct','1','0','2024-08-17 11:18:40','2024-08-17 11:18:53',NULL,NULL,'FUROSEMIDE','New Item','0','39'),
(39,'37','3','storagecondition','1','0','2024-08-17 11:19:33','2024-08-17 11:23:26',NULL,NULL,'Store protect from moisture and light','New Item','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'),
(47,'37','10','pbatch','1','0','2024-09-14 15:40:51','2024-09-14 15:55:52',NULL,NULL,'CH-20924','New Item','0','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,'37','12','pbatch','1','0','2024-09-18 09:44:13','2024-09-18 09:44:25',NULL,NULL,'DS-10824','New Item','0','39'),
(54,'37','5','addproduct','1','0','2024-09-18 09:45:19','2024-09-18 09:45:25',NULL,NULL,'DOCUSATE SODIUM','New Item','0','39'),
(55,'37','5','storagecondition','1','0','2024-09-18 09:46:28','2024-09-18 09:46:34',NULL,NULL,'In an air tight container','New Item','0','39'),
(56,'37','12','generateqr','1','0','2024-09-18 09:47:05','2024-09-18 09:47:11',NULL,NULL,'LAX/0924/012','New Item',NULL,'39'),
(57,'37','13','generateqr','1','0','2024-09-18 09:48:11','2024-09-18 09:48:18',NULL,NULL,'LAX/0924/013','New Item',NULL,'39'),
(58,'37','13','pbatch','1','0','2024-09-18 12:35:23','2024-09-18 14:06:25',NULL,NULL,'CH-10924','New Item','0','39'),
(59,'37','14','pbatch','1','0','2024-09-18 12:36:15','2024-09-18 14:06:46',NULL,NULL,'CH-30924','New Item','0','39'),
(60,'37','15','pbatch','1','0','2024-09-18 12:37:14','2024-09-18 14:07:08',NULL,NULL,'CH-40924','New Item','0','39'),
(61,'37','16','pbatch','1','0','2024-09-18 12:48:15','2024-09-18 14:07:20',NULL,NULL,'CH-50924','New Item','0','39'),
(65,'37','14','generateqr','1','0','2024-09-19 12:17:58','2024-09-19 15:28:29',NULL,NULL,'LAX/0924/014','New Item',NULL,'39'),
(66,'37','15','generateqr','1','0','2024-09-19 12:18:42','2024-09-19 15:28:49',NULL,NULL,'LAX/0924/015','New Item',NULL,'39'),
(67,'37','16','generateqr','1','0','2024-09-19 12:19:11','2024-09-19 15:29:01',NULL,NULL,'LAX/0924/016','New Item',NULL,'39'),
(68,'37','17','generateqr','1','0','2024-09-19 12:19:58','2024-09-19 15:29:35',NULL,NULL,'LAX/0924/017','New Item',NULL,'39'),
(69,'37','18','generateqr','1','0','2024-09-20 16:01:03','2024-09-20 16:17:28',NULL,NULL,'LAX/0924/018','New Item',NULL,'39'),
(70,'37','19','generateqr','1','0','2024-09-20 16:03:08','2024-09-20 16:17:39',NULL,NULL,'LAX/0924/019','New Item',NULL,'39'),
(71,'37','18','pbatch','1','0','2024-09-20 16:04:50','2024-09-20 16:18:06',NULL,NULL,'CH-70824','New Item','0','39'),
(72,'37','20','generateqr','1','0','2024-09-20 16:19:13','2024-09-20 16:20:16',NULL,NULL,'LAX/0924/020','New Item',NULL,'39'),
(73,'37','19','pbatch','1','0','2024-09-21 11:20:40','2024-09-21 14:59:08',NULL,NULL,'CH-80824','New Item','0','39'),
(74,'37','21','generateqr','1','0','2024-09-22 14:18:48','2024-09-22 16:45:21',NULL,NULL,'LAX/0924/021','New Item',NULL,'39'),
(75,'37','22','generateqr','1','0','2024-09-22 18:34:33','2024-09-24 12:08:47',NULL,NULL,'LAX/0924/022','New Item',NULL,'39'),
(76,'37','20','pbatch','1','0','2024-09-26 20:24:40','2024-09-28 15:08:05',NULL,NULL,'CH-70924','New Item','0','39'),
(77,'37','23','generateqr','1','0','2024-09-27 13:53:50','2024-09-28 15:08:18',NULL,NULL,'LAX/0924/023','New Item',NULL,'39'),
(78,'37','21','pbatch','1','0','2024-09-28 11:12:45','2024-09-28 15:08:38',NULL,NULL,'DS-20924','New Item','0','39'),
(79,'37','24','generateqr','1','0','2024-09-28 11:14:17','2024-09-28 15:08:52',NULL,NULL,'LAX/0924/024','New Item',NULL,'39'),
(80,'37','25','generateqr','1','0','2024-09-28 11:15:45','2024-09-28 15:09:05',NULL,NULL,'LAX/0924/025','New Item',NULL,'39'),
(81,'37','7','addproduct','1','0','2024-09-28 11:16:42','2024-09-28 17:13:42',NULL,NULL,'-','New Item','0','39'),
(82,'37','6','storagecondition','1','0','2024-09-28 12:44:51','2024-09-28 15:10:10',NULL,NULL,'Preserve in well closed container','New Item','0','39'),
(83,'37','7','storagecondition','1','0','2024-09-28 15:15:11','2024-09-28 15:15:18',NULL,NULL,'Preserve in well closed container','New Item','0','39'),
(84,'37','26','generateqr','1','0','2024-09-28 15:16:10','2024-09-28 17:13:59',NULL,NULL,'LAX/0924/026','New Item',NULL,'39'),
(85,'37','27','generateqr','1','0','2024-09-28 15:16:37','2024-09-28 17:14:11',NULL,NULL,'LAX/0924/027','New Item',NULL,'39'),
(86,'37','28','generateqr','1','0','2024-09-28 15:17:08','2024-09-28 17:14:25',NULL,NULL,'LAX/0924/028','New Item',NULL,'39'),
(88,'37','8','storagecondition','1','0','2024-10-02 13:03:32','2024-10-02 13:03:40',NULL,NULL,'Preserve in well closed container','New Item','0','39'),
(89,'37','6','addproduct','1','0','2024-10-02 13:04:21','2024-10-02 13:04:27',NULL,NULL,'DOCUSATE SODIUM 85%','Edit','0','39'),
(90,'37','3','product','1','0','2024-10-02 13:05:39','2024-10-02 13:05:46',NULL,NULL,'DOCUSATE SODIUM 85% POWDER','Edit','0','39'),
(91,'37','17','pbatch','1','0','2024-10-02 13:06:02','2024-10-02 13:06:07',NULL,NULL,'DP-10624','Edit','0','39'),
(92,'37','29','generateqr','1','0','2024-10-02 13:06:36','2024-10-02 13:06:44',NULL,NULL,'LAX/1024/029','New Item',NULL,'39'),
(93,'36','8','product','1','0','2024-10-07 15:42:17','2024-10-07 15:42:22',NULL,NULL,'Test 1','New Item','0','36'),
(94,'36','22','pbatch','1','0','2024-10-07 15:42:55','2024-10-07 15:43:01',NULL,NULL,'Test 1 batch','New Item','0','36'),
(95,'36','8','addproduct','1','0','2024-10-07 15:43:21','2024-10-07 15:43:24',NULL,NULL,'Test 1 Alias','New Item','0','36'),
(96,'36','9','storagecondition','1','0','2024-10-07 15:43:47','2024-10-07 15:43:57',NULL,NULL,'Teest 1 In-House Grade','New Item','0','36'),
(97,'36','30','generateqr','1','0','2024-10-07 15:44:32','2024-10-07 15:44:40',NULL,NULL,'LAX/1024/030','New Item',NULL,'36');
/*!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=23 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-09-14 15:40:50',NULL,'39','0','1','0','2024-09-14 15:55:52',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,'DS-10824','2','500','NA','2024-08-01 00:00:00','2029-07-01 00:00:00','','','IP,BP,EP,USP','2024-09-18 09:44:13',NULL,'39','0','1','0','2024-09-18 09:44:25',NULL),
(13,'CH-10924','1','500','NA','2024-09-01 00:00:00','2029-08-01 00:00:00','','','IP,BP,EP,USP','2024-09-18 12:35:22',NULL,'39','0','1','0','2024-09-18 14:06:25',NULL),
(14,'CH-30924','1','500','NA','2024-09-01 00:00:00','2029-08-01 00:00:00','','','IP,BP,EP,USP','2024-09-18 12:36:14',NULL,'39','0','1','0','2024-09-18 14:06:46',NULL),
(15,'CH-40924','1','500','NA','2024-09-01 00:00:00','2029-08-01 00:00:00','','','IP,BP,EP,USP','2024-09-18 12:37:14',NULL,'39','0','1','0','2024-09-18 14:07:08',NULL),
(16,'CH-50924','1','500','NA','2024-09-01 00:00:00','2029-08-01 00:00:00','','','IP,BP,EP,USP','2024-09-18 12:48:14',NULL,'39','0','1','0','2024-09-18 14:07:20',NULL),
(17,'DP-10624','3','500','NA','2024-06-01 00:00:00','2029-05-01 00:00:00','','','TECHNICAL','2024-10-02 13:06:02','2024-10-02 13:06:02','39','0','1','0','2024-10-02 13:06:07',NULL),
(18,'CH-70824','1','500','NA','2024-08-01 00:00:00','2029-07-01 00:00:00','','','IP,BP,EP,USP','2024-09-20 16:04:49',NULL,'39','0','1','0','2024-09-20 16:18:06',NULL),
(19,'CH-80824','1','500','NA','2024-08-01 00:00:00','2029-07-01 00:00:00','','','IP,BP,EP,USP','2024-09-21 11:20:39',NULL,'39','0','1','0','2024-09-21 14:59:08',NULL),
(20,'CH-70924','1','500','NA','2024-09-01 00:00:00','2029-08-01 00:00:00','','','IP,BP,EP,USP','2024-09-26 20:24:39',NULL,'39','0','1','0','2024-09-28 15:08:05',NULL),
(21,'DS-20924','2','500','NA','2024-09-01 00:00:00','2029-08-01 00:00:00','','','IP,BP,EP,USP','2024-09-28 11:12:45',NULL,'39','0','1','0','2024-09-28 15:08:38',NULL),
(22,'Test 1 batch','8','1000','','2024-10-01 00:00:00','2025-12-01 00:00:00','','','In-House','2024-10-07 15:42:55',NULL,'36','0','1','0','2024-10-07 15:43:01',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','TECHNICAL','NA','5,10,15,20,25','KGS','2024-08-03 13:04:30','2024-10-02 13:05:39','39','NA','NA','0','1','0','2024-10-02 13:05:46',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,'Test 1','','1234567991025','1','LAXACHEM ORGANICS PVT LTD','','In-House','Sub Test 1','25','KGS','2024-10-07 15:42:17',NULL,'36','HY6GY7','12.25','0','1','0','2024-10-07 15:42:22',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=10 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',NULL,'39','0','1','0','2024-08-16 17:10:45',NULL),
(3,'FUROSEMIDE',6,'IP',NULL,'Store protect from moisture and light','2024-08-17 11:19:32',NULL,'39','0','1','0','2024-08-17 11:23:26',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,'DOCUSATE SODIUM',2,'BP',NULL,'In an air tight container','2024-09-18 09:46:28',NULL,'39','0','1','0','2024-09-18 09:46:34',NULL),
(6,'DOCUSATE SODIUM 85% POWDER',3,'USP',NULL,'Preserve in well closed container','2024-09-28 12:44:50',NULL,'39','0','1','0','2024-09-28 15:10:10',NULL),
(7,'DOCUSATE SODIUM',2,'USP',NULL,'Preserve in well closed container','2024-09-28 15:15:11',NULL,'39','0','1','0','2024-09-28 15:15:18',NULL),
(8,'DOCUSATE SODIUM 85% POWDER',3,'TECHNICAL',NULL,'Preserve in well closed container','2024-10-02 13:03:32',NULL,'39','0','1','0','2024-10-02 13:03:40',NULL),
(9,'Test 1',8,'In-House',NULL,'Teest 1 In-House Grade','2024-10-07 15:43:47',NULL,'36','0','1','0','2024-10-07 15:43:57',NULL);
/*!40000 ALTER TABLE `storagecondition` ENABLE KEYS */;

-- 
-- Definition of userm
-- 

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

-- 
-- Dumping data for table userm
-- 

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