-- MySqlBackup.NET 2.0.4
-- Dump Time: 2024-05-14 15:44:08
-- --------------------------------------
-- 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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=53 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`) VALUES
(15,'duco4','DUCOSATE SODIUM',17,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0'),
(17,'DUSOSATE SODIUM 12','DUCOSATE SODIUM',18,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0'),
(18,'Ducosate Sodium 1234','DUCOSATE SODIUM',18,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0'),
(19,'Ducom','DUCOSATE SODIUM',18,'2024-03-21 14:53:39','2024-03-21 14:53:39','0',NULL,NULL,NULL,NULL,NULL,'2',NULL,NULL,NULL,'0'),
(20,'sdfdsg','DUCOSATE SODIUM',18,'2024-03-21 15:03:08','2024-03-21 15:03:08','1',NULL,NULL,'2024-03-28 17:08:39',NULL,NULL,'3',NULL,NULL,NULL,'0'),
(21,'Tulip Contras','TULIP C',15,'2024-03-25 15:22:34','2024-03-25 15:22:43','1',NULL,NULL,'2024-03-28 17:08:52',NULL,NULL,'3',NULL,NULL,NULL,'0'),
(22,'Ducosate Sodium 12','Ducosate Sodium',23,'2024-03-27 11:49:22',NULL,'0',NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL,'0'),
(23,'ducosate radium alpha z','Ducosate Sodium',23,'2024-04-02 16:23:12',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL,'0'),
(24,'ducosate radium alpha z','Ducosate Sodium',23,'2024-04-02 16:23:39',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL,'0'),
(25,'ducosate radium alpha z','Ducosate Sodium',23,'2024-04-02 16:24:43',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL,'0'),
(26,'duco alpha','Ducosate Sodium',23,'2024-04-02 16:26:22',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL,'0'),
(27,'duco alpha','Ducosate Sodium',23,'2024-04-02 16:27:27',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL,'0'),
(28,'Ducomtdr aserdutilicia','Ducosate Sodium',23,'2024-04-03 11:42:20',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL,'0'),
(29,'aserdity lucocium sulphonacii','Ducosate Sodium',23,'2024-04-03 11:43:37',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL,'0'),
(30,'alpha Beta','Ducosate Sodium',23,'2024-04-03 11:51:58',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL,'0'),
(31,'Beta Alpha','Ducosate Sodium',23,'2024-04-03 11:53:27',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL,'0'),
(32,'AlphaBegta22','Ducosate Sodium',23,'2024-04-03 11:59:47',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL,'0'),
(33,'beta two one alpha','Ducosate Sodium',23,'2024-04-03 12:50:19',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL,'0'),
(34,'beta two one alpha','Ducosate Sodium',23,'2024-04-03 12:50:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL,'0'),
(35,'dfbfgngfjghj','Ducosate Sodium',23,'2024-04-03 12:53:17',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL,'0'),
(36,'ASDFRETTFFD','Ducosate Sodium',23,'2024-04-03 13:09:36',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL,'0'),
(37,'ASDFRETTFFD','Ducosate Sodium',23,'2024-04-03 13:09:44',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL,'0'),
(38,'dfshrgjhgk','Ducosate Sodium',23,'2024-04-03 13:23:50',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL,'0'),
(39,'safsdfbgffgjghk','Ducosate Sodium',23,'2024-04-03 13:24:59',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL,'0'),
(40,'Alpha Nine','Ducodine Alphaa Nine',24,'2024-04-03 14:23:14',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL,'0'),
(41,'asdrewacolatemenia','Ducodine Alphaa Nine',24,'2024-04-03 16:28:49',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL,'0'),
(42,'Alpha 10','Ducodine Alphaa Nine',24,'2024-04-03 16:31:19',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL,'0'),
(43,'alpha 112','Ducodine Alphaa Nine',24,'2024-04-03 17:05:05',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL,'0'),
(44,'alpha12','Ducodine Alphaa Nine',24,'2024-04-03 17:08:48',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL,'0'),
(45,'laxapro','LaxachemProject',26,'2024-04-08 15:38:02',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL,'0'),
(46,'AliasZAPS','ZapsMaster',30,'2024-04-10 13:28:35',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'27',NULL,NULL,NULL,'0'),
(47,'APSHREENETRA','ShreeNetra',31,'2024-04-10 15:15:22',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'28',NULL,NULL,NULL,'0'),
(48,'NICOALPHA','NicotinAlpha',32,'2024-04-12 17:59:36',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL,'0'),
(49,'ZEEAlias11','ZeLight',40,'2024-04-14 17:05:42','2024-04-30 15:08:09',NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL,'-1'),
(50,'ZEE123457','ZeLight',40,'2024-04-16 12:32:08','2024-04-30 15:00:55',NULL,NULL,NULL,NULL,NULL,NULL,'30',NULL,NULL,NULL,'-1'),
(51,'HP ALIAS122','Hello Phones',43,'2024-04-16 18:24:45','2024-04-30 18:34:12',NULL,NULL,NULL,NULL,NULL,NULL,'11',NULL,NULL,NULL,'-1'),
(52,'NICOVIBHGY1','NicotinAlpha',32,'2024-05-01 16:33:54','2024-05-01 16:35:56',NULL,NULL,NULL,NULL,NULL,NULL,'35',NULL,NULL,NULL,'-1');
/*!40000 ALTER TABLE `aliasproduct` ENABLE KEYS */;

-- 
-- Definition of customer
-- 

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

-- 
-- Dumping data for table customer
-- 

/*!40000 ALTER TABLE `customer` DISABLE KEYS */;
INSERT INTO `customer`(`id`,`custname`,`gstin`,`custadd`,`custphone`,`custemail`,`created`,`updated`,`custdrug`,`consiadd`,`consiname`,`consiemail`,`consiphone`,`consigst`,`considrug`,`displayname`,`type`,`userid`,`deletestatus`) VALUES
(17,'VAIBHAV','GSTIN1001','NAGPUR','985285285','VAIBHAV@GMAIL.COM',NULL,NULL,'DGFF111','','','','','','','VBHV','Customer','3','0'),
(18,'Mohd Waseem','Gstin0000','Amravati','9898989898','sdfsdfds@gmail.com',NULL,NULL,'dg11112','','','','','','','waseem','Customer','3','0'),
(19,'Sharique Sir','GSTIN122','Amravati','874521478','shariques@gmail.com','2024-04-03 14:13:03',NULL,'dg1234','','','','','','','no name','Customer',NULL,'0'),
(20,'Pratik Mohod','P1234','Amravati ','8797987987','Pmohod@gmail.com','2024-04-04 12:36:43',NULL,'PG234','','','','','','','Pratik','Customer',NULL,'-1'),
(21,'Chandan Saraf','ch123','Amravati','79885887','chandan@gmail.com','2024-04-04 12:40:18',NULL,'ch4566','','','','','','','chandan','Customer',NULL,'0'),
(22,'Sahl Khan','GSTIN1111','Amravai','9856985692','sahil@gamil.com','2024-04-08 12:07:38',NULL,'DG1234','','','','','','','Sahil','Customer','3','0'),
(23,'Pratik Mohod','PGTIN','Amravati','9856985698','pratikm@gmail.com','2024-04-08 15:37:33',NULL,'DG124`','','','','','','','Pratik','Customer',NULL,'0'),
(24,'Vivek Gedam','VGSTIN','Amravati','9874663214','vivek@gmail.com','2024-04-10 13:28:19',NULL,'VDG1021','','','','','','','Vivek','Customer',NULL,'0'),
(26,'a','s','d','5','g','2024-05-01 14:23:24',NULL,'f','','','','','','','r','Customer','34','-1');
/*!40000 ALTER TABLE `customer` ENABLE KEYS */;

-- 
-- Definition of dispatch
-- 

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

-- 
-- Dumping data for table dispatch
-- 

/*!40000 ALTER TABLE `dispatch` DISABLE KEYS */;
INSERT INTO `dispatch`(`id`,`lotno`,`distype`,`dod`,`bob`,`dob`,`customer`,`invoice`,`created`,`updated`,`userid`,`deletestatus`) VALUES
(10,'8','Export','2023-12-12 00:00:00','12','2023-12-12 00:00:00',NULL,NULL,NULL,NULL,NULL,NULL),
(11,'9','Export','2024-02-28 00:00:00','1001','2024-02-28 00:00:00','16',NULL,NULL,NULL,NULL,NULL),
(12,'34','Export','2024-03-18 00:00:00','1234','2024-03-18 00:00:00','16',NULL,NULL,NULL,NULL,NULL),
(13,'33','Export','2024-03-18 00:00:00','1122','2024-03-18 00:00:00','16',NULL,NULL,NULL,NULL,NULL),
(14,'32','Export','2024-03-18 00:00:00','12321','2024-03-18 00:00:00','16',NULL,NULL,NULL,NULL,NULL),
(15,'31','Export','2024-03-18 00:00:00','2225','2024-03-18 00:00:00','16',NULL,NULL,NULL,NULL,NULL),
(16,'35','Export','2024-03-20 00:00:00','12321','2024-03-20 00:00:00','16',NULL,NULL,NULL,NULL,NULL),
(17,'36','Export','2024-03-20 00:00:00','121212','2024-03-20 00:00:00','16',NULL,NULL,NULL,NULL,NULL),
(18,'30','Export','2024-03-21 00:00:00','BILL1100','2024-03-21 00:00:00','16','INV1100',NULL,NULL,NULL,NULL),
(19,'48','Export','0001-01-01 00:00:00','1254','0001-01-01 00:00:00','18','11113','2024-05-10 10:54:00','2024-05-13 17:46:45',NULL,'0'),
(20,'20','Export','2024-05-21 00:00:00','258','2024-05-09 00:00:00','18','1205514','2024-05-10 11:29:40','2024-05-13 17:57:32','34','0'),
(21,'47','Export','2024-05-16 00:00:00','7854','2024-05-16 00:00:00','18','1586','2024-05-10 11:40:03','2024-05-13 18:02:52','34','0'),
(22,'LAX/0424/049','Export','2024-05-10 00:00:00','445','2024-05-10 00:00:00','20','3333','2024-05-10 12:33:52',NULL,'34','0'),
(23,'LAX/0424/049','Export','2024-05-10 00:00:00','445','2024-05-10 00:00:00','20','3333','2024-05-10 12:34:06',NULL,'34','0'),
(26,'49','Export','2024-05-10 00:00:00','4433','2024-05-10 00:00:00','18','334455','2024-05-10 13:05:32',NULL,'34','0'),
(27,'48','Export','0001-01-01 00:00:00','1254','0001-01-01 00:00:00','18','11113','2024-05-13 17:46:45',NULL,'34','0'),
(28,'21','Export','2024-05-15 00:00:00','258','2024-05-16 00:00:00','18','120055','2024-05-13 17:50:30',NULL,'34','-1');
/*!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',
  `lotcreatedate` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=51 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`,`lotcreatedate`) VALUES
(1,'3','','fafa','','faa','faaf','fasfafa','dvsv','fsgfsg','sfgg','sgs','2023-09-11 00:00:00','2023-09-12 00:00:00',NULL,'8','12','13','','','','','','','0','0',NULL),
(3,'2','','fdsg','','','2212','0','','','','2112','2023-10-17 00:00:00','2023-10-17 00:00:00','3','13','','','','IP','12','21','','','0','0',NULL),
(4,'3','','v','','','131','0','','','','12','2023-10-17 00:00:00','2023-10-17 00:00:00','3','14','','','','BP','1','2','','','0','0',NULL),
(5,'3','LAX/1123/005','v','','','233','0','','','','33','2023-11-01 00:00:00','2023-11-01 00:00:00','3','14','','','','BP','12','23','','','0','0',NULL),
(6,'6','LAX/1123/006','sddgg','','','33','0','','','','33','2023-11-01 00:00:00','2023-11-01 00:00:00','3','15','','','','EP','BP','3','','','0','0',NULL),
(7,'6','LAX/1123/007','sddgg','','','22','fafssa','','','','22','2023-11-01 00:00:00','2023-11-01 00:00:00','3','15','','','','BP','BP','23','','','0','0',NULL),
(8,'2','LAX/1223/008','','','','10','fada','','','','10','2023-12-01 00:00:00','2024-03-01 00:00:00','3','15','','','','USP','shsh','10','','100','1','0',NULL),
(9,'12','LAX/1223/009','','','','22','rr','','','','20','2023-12-01 00:00:00','2024-12-01 00:00:00','3','17','','','','BP','10','12','','240','1','0',NULL),
(10,'13','LAX/0224/010','','','','','20','','','','10','2024-03-01 00:00:00','0001-01-01 00:00:00',NULL,'0','','','','BP','10','5','','50','0','0',NULL),
(11,'13','LAX/0224/011','','','','','20','','','','10','2024-03-01 00:00:00','0001-01-01 00:00:00',NULL,'0','','','','BP','10','5','','50','0','0',NULL),
(12,'13','LAX/0224/011','','','','','20','','','','10','2024-03-01 00:00:00','0001-01-01 00:00:00',NULL,'0','','','','BP','10','5','','50','0','0',NULL),
(13,'13','LAX/0224/011','','','','','20','','','','10','2024-03-01 00:00:00','0001-01-01 00:00:00','3','0','','','','BP','10','5','','50','0','0',NULL),
(14,'13','LAX/0224/014','','','','','20','','','','10','2024-03-01 00:00:00','0001-01-01 00:00:00','3','0','','','','BP','10','5','','50','0','0',NULL),
(15,'14','LAX/0224/015','','','','','21','','','','15','2024-03-01 00:00:00','0001-01-01 00:00:00','3','0','','','','EP','15','5','','75','0','0',NULL),
(16,'15','LAX/0324/016','','','','','22','','','','10','2024-01-01 00:00:00','0001-01-01 00:00:00',NULL,'0','','','','EP','10','5','','50','0','0',NULL),
(17,'15','LAX/0324/017','','','','','23','','','','10','2024-02-01 00:00:00','0001-01-01 00:00:00','3','0','','','','EP','10','3','','30','0','0',NULL),
(18,'15','LAX/0324/018','','','','','22','','','','10','2024-01-01 00:00:00','0001-01-01 00:00:00',NULL,NULL,'','','','EP','10','5','','50','0','0',NULL),
(19,'14','LAX/0324/019','','','','','21','','','','15','2024-03-01 00:00:00','0001-01-01 00:00:00','3',NULL,'','','','EP','15','5','','75','0','0',NULL),
(20,'17','LAX/0324/020','','','','','24','','','','12','2024-02-01 00:00:00','0001-01-01 00:00:00',NULL,'0','','','','BP,USP','12','5','','60','0','0',NULL),
(21,'17','LAX/0324/021','','6','','','24','','','','12','2024-02-01 00:00:00','0001-01-01 00:00:00','3','0','','','','BP,USP','12','3','','36','0','0',NULL),
(22,'18','LAX/0324/022','','7','','','25','','','','18','2024-01-01 00:00:00','2024-05-01 00:00:00',NULL,'0','','','','IP,BP,EP,USP','18','3','','54','0','0',NULL),
(23,'18','LAX/0324/023','','7','','','25','','','','18','2024-01-01 00:00:00','2024-05-01 00:00:00','3','0','','','','BP','18','2','','36','0','0',NULL),
(24,'18','LAX/0324/024','','7','','','25','','','','18','2024-01-01 00:00:00','2024-05-01 00:00:00','3','0','','','','BP','18','3','','54','0','0',NULL),
(25,'17','LAX/0324/025','','6','','','24','','','','12','2024-02-01 00:00:00','0001-01-01 00:00:00',NULL,'0','','','','BP,USP','12','3','','36','0','0',NULL),
(26,'17','LAX/0324/026','','6','','','24','','','','12','2024-02-01 00:00:00','0001-01-01 00:00:00','3','0','','','','BP','12','3','','36','0','0',NULL),
(27,'17','LAX/0324/027','','6','','','24','','','','12','2024-02-01 00:00:00','0001-01-01 00:00:00',NULL,'0','','','','USP','12','3','','36','0','0',NULL),
(28,'17','LAX/0324/028','','6','','','24','','','','12','2024-02-01 00:00:00','0001-01-01 00:00:00','3','0','','','','BP','12','3','','36','0','0',NULL),
(29,'18','LAX/0324/029','','7','','','25','','','','18','2024-01-01 00:00:00','2024-05-01 00:00:00',NULL,'0','','','','IP','18','4','','72','0','0',NULL),
(30,'17','LAX/0324/030','','6','','','24','','','','12','2024-02-01 00:00:00','0001-01-01 00:00:00','3','0','','','','BP,USP','12','3','','36','1','0','2024-03-11 00:00:00'),
(31,'18','LAX/0324/031','','17','','','34','','','','18','2024-01-01 00:00:00','2024-05-01 00:00:00',NULL,'0','','','','IP,BP,EP,USP','18','5','','90','1','0','2024-03-14 00:00:00'),
(32,'18','LAX/0324/032','','17','','','34','','','','18','2024-01-01 00:00:00','2024-05-01 00:00:00',NULL,'0','','','','EP','18','3','','54','1','0','2024-03-16 00:00:00'),
(33,'18','LAX/0324/033','','17','','','34','','','','18','2024-02-01 00:00:00','2024-06-01 00:00:00',NULL,'0','','','','EP','18','3','','54','1','0','2024-03-16 00:00:00'),
(34,'17','LAX/0324/034','','16','','','24','','','','12','2024-03-01 00:00:00','2024-10-01 00:00:00',NULL,'0','','','','BP','12','2','','24','1','1','2024-03-16 00:00:00'),
(35,'18','LAX/0324/035','','18','','','35','','','','18','2024-02-01 00:00:00','2024-11-01 00:00:00',NULL,'0','','','','IP,BP','18','3','','54','1','0','2024-03-19 00:00:00'),
(36,'17','LAX/0324/036','','15','','','24','','','','12','2024-03-01 00:00:00','2024-10-01 00:00:00',NULL,'0','','','','BP,USP','12','5','','60','1','1','2024-03-20 00:00:00'),
(37,'23','LAX/0324/037','','22','','','36','','','','120','2024-02-01 00:00:00','2024-07-01 00:00:00',NULL,'0','','','','IP,BP','120','3','','360','0','0','2024-03-27 00:00:00'),
(38,'17','LAX/0324/038','','15','','','24','','','','12','2024-03-01 00:00:00','2024-10-01 00:00:00','3','0','','','','BP,USP','12','3','','36','0','0','2024-03-29 00:00:00'),
(39,'18','LAX/0324/039','','17','','','25','','','','18','2024-02-01 00:00:00','2024-06-01 00:00:00','3','0','','','','IP,BP','18','2','','36','0','0','2024-03-29 00:00:00'),
(40,'23','LAX/0324/040','','22','','','36','','','','120','2024-02-01 00:00:00','2024-07-01 00:00:00','3','0','','','','IP','120','3','','360','0','0','2024-03-29 00:00:00'),
(41,'24','LAX/0424/041','','40','','','37','','','','12','2024-02-01 00:00:00','2024-11-01 00:00:00','3','0','','','','BP','12','3','','36','0','0','2024-04-03 00:00:00'),
(42,'24','LAX/0424/042','','41','','','37','','','','12','2024-02-01 00:00:00','2024-11-01 00:00:00','3','0','','','','BP','12','3','','36','0','0','2024-04-08 00:00:00'),
(43,'24','LAX/0424/043','','44','','','41','','','','12','2024-02-01 00:00:00','2024-06-01 00:00:00','3','0','','','','BP','12','3','','36','0','0','2024-04-12 00:00:00'),
(44,'40','LAX/0424/044','','49','','','44','','','','120','2024-02-01 00:00:00','2024-07-01 00:00:00','3','0','','','','EP','120','3','','360','0','0','2024-04-16 00:00:00'),
(45,'40','LAX/0424/045','','50','','','45','','','','120','2024-02-01 00:00:00','2024-07-01 00:00:00','3','0','','','','EP','120','5','','600','0','0','2024-04-16 00:00:00'),
(46,'40','LAX/0424/046','','50','','','45','','','','120','2024-02-01 00:00:00','2024-07-01 00:00:00','3','0','','','','EP','120','8','','960','0','0','2024-04-16 00:00:00'),
(47,'40','LAX/0424/047','','50','','','45','','','','120','2024-02-01 00:00:00','2024-07-01 00:00:00','3','0','','','','EP','120','9','','1080','0','0','2024-04-16 00:00:00'),
(48,'43','LAX/0424/048','','51','','','46','','','','850','2024-02-01 00:00:00','2024-07-01 00:00:00','11','0','','','','USP','850','10','','8500','1','0','2024-04-16 00:00:00'),
(49,'43','LAX/0424/049','','51','','','46','','','','850','2024-02-01 00:00:00','2024-07-01 00:00:00','11','0','','','','USP','850','5','','4250','1','0','2024-04-16 00:00:00'),
(50,'43','LAX/0524/050','','51','','','46','','','','850','2024-02-01 00:00:00','2024-07-01 00:00:00','34','0','','','','USP','850','5','','4250','0','0','2024-05-14 00:00:00');
/*!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',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=269 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`) VALUES
(7,'0','0','','','00000000',NULL,'0','0','0'),
(8,'1/21','3','2112','',NULL,'00012345678000000011','0','0','0'),
(9,'2/21','3','2112','',NULL,'00012345678000000020','0','0','0'),
(10,'3/21','3','2112','',NULL,'00012345678000000031','0','0','0'),
(11,'4/21','3','2112','',NULL,'00012345678000000042','0','0','0'),
(12,'5/21','3','2112','',NULL,'00012345678000000053','0','0','0'),
(13,'6/21','3','2112','',NULL,'00012345678000000064','0','0','0'),
(14,'7/21','3','2112','',NULL,'00012345678000000075','0','0','0'),
(15,'8/21','3','2112','',NULL,'00012345678000000084','0','0','0'),
(16,'9/21','3','2112','',NULL,'00012345678000000093','0','0','0'),
(17,'10/21','3','2112','',NULL,'00012345678000000101','0','0','0'),
(18,'11/21','3','2112','',NULL,'00012345678000000112','0','0','0'),
(19,'12/21','3','2112','',NULL,'00012345678000000123','0','0','0'),
(20,'13/21','3','2112','',NULL,'00012345678000000134','0','0','0'),
(21,'14/21','3','2112','',NULL,'00012345678000000145','0','0','0'),
(22,'15/21','3','2112','',NULL,'00012345678000000154','0','0','0'),
(23,'16/21','3','2112','',NULL,'00012345678000000163','0','0','0'),
(24,'17/21','3','2112','',NULL,'00012345678000000172','0','0','0'),
(25,'18/21','3','2112','',NULL,'00012345678000000181','0','0','0'),
(26,'19/21','3','2112','',NULL,'00012345678000000190','0','0','0'),
(27,'20/21','3','2112','',NULL,'00012345678000000204','0','0','0'),
(28,'21/21','3','2112','','00000000','00012345678000000215','0','0','0'),
(29,'1/2','4','','','00000001','00012345678000000011','0','0','0'),
(30,'2/2','4','','','00000002','00012345678000000020','0','0','0'),
(31,'1/23','5','33','66','00000003','000123456783000000034','0','0','0'),
(32,'2/23','5','33','66','00000004','000123456783000000041','0','0','0'),
(33,'3/23','5','33','66','00000005','000123456783000000052','0','0','0'),
(34,'4/23','5','33','66','00000006','000123456783000000065','0','0','0'),
(35,'5/23','5','33','66','00000007','000123456783000000072','0','0','0'),
(36,'6/23','5','33','66','00000008','000123456783000000081','0','0','0'),
(37,'7/23','5','33','66','00000009','000123456783000000094','0','0','0'),
(38,'8/23','5','33','66','00000010','000123456783000000102','0','0','0'),
(39,'9/23','5','33','66','00000011','000123456783000000111','0','0','0'),
(40,'10/23','5','33','66','00000012','000123456783000000124','0','0','0'),
(41,'11/23','5','33','66','00000013','000123456783000000133','0','0','0'),
(42,'12/23','5','33','66','00000014','000123456783000000140','0','0','0'),
(43,'13/23','5','33','66','00000015','000123456783000000153','0','0','0'),
(44,'14/23','5','33','66','00000016','000123456783000000164','0','0','0'),
(45,'15/23','5','33','66','00000017','000123456783000000171','0','0','0'),
(46,'16/23','5','33','66','00000018','000123456783000000182','0','0','0'),
(47,'17/23','5','33','66','00000019','000123456783000000195','0','0','0'),
(48,'18/23','5','33','66','00000020','000123456783000000201','0','0','0'),
(49,'19/23','5','33','66','00000021','000123456783000000212','0','0','0'),
(50,'20/23','5','33','66','00000022','000123456783000000225','0','0','0'),
(51,'21/23','5','33','66','00000023','000123456783000000232','0','0','0'),
(52,'22/23','5','33','66','00000024','000123456783000000241','0','0','0'),
(53,'23/23','5','33','66','00000025','000123456783000000254','0','0','0'),
(54,'1/3','6','33','66','00000026','00012345678000000260','0','0','0'),
(55,'2/3','6','33','66','00000027','00012345678000000271','0','0','0'),
(56,'3/3','6','33','66','00000028','00012345678000000282','0','0','0'),
(57,'1/23','7','22','44','00000029','00012345678000000293','0','0','0'),
(58,'2/23','7','22','44','00000030','00012345678000000303','0','0','0'),
(59,'3/23','7','22','44','00000031','00012345678000000312','0','0','0'),
(60,'4/23','7','22','44','00000032','00012345678000000321','0','0','0'),
(61,'5/23','7','22','44','00000033','00012345678000000330','0','0','0'),
(62,'6/23','7','22','44','00000034','00012345678000000341','0','0','0'),
(63,'7/23','7','22','44','00000035','00012345678000000352','0','0','0'),
(64,'8/23','7','22','44','00000036','00012345678000000363','0','0','0'),
(65,'9/23','7','22','44','00000037','00012345678000000374','0','0','0'),
(66,'10/23','7','22','44','00000038','00012345678000000385','0','0','0'),
(67,'11/23','7','22','44','00000039','00012345678000000394','0','0','0'),
(68,'12/23','7','22','44','00000040','00012345678000000400','0','0','0'),
(69,'13/23','7','22','44','00000041','00012345678000000411','0','0','0'),
(70,'14/23','7','22','44','00000042','00012345678000000422','0','0','0'),
(71,'15/23','7','22','44','00000043','00012345678000000433','0','0','0'),
(72,'16/23','7','22','44','00000044','00012345678000000444','0','0','0'),
(73,'17/23','7','22','44','00000045','00012345678000000455','0','0','0'),
(74,'18/23','7','22','44','00000046','00012345678000000464','0','0','0'),
(75,'19/23','7','22','44','00000047','00012345678000000473','0','0','0'),
(76,'20/23','7','22','44','00000048','00012345678000000482','0','0','0'),
(77,'21/23','7','22','44','00000049','00012345678000000491','0','0','0'),
(78,'22/23','7','22','44','00000050','00012345678000000503','0','0','0'),
(79,'23/23','7','22','44','00000051','00012345678000000514','0','0','0'),
(80,'1/10','8','10','20','00000052','00012345678000000525','0','0','0'),
(81,'2/10','8','10','20','00000053','00012345678000000534','0','0','0'),
(82,'3/10','8','10','20','00000054','00012345678000000543','0','0','0'),
(83,'4/10','8','10','20','00000055','00012345678000000552','0','0','0'),
(84,'5/10','8','10','20','00000056','00012345678000000561','0','0','0'),
(85,'6/10','8','10','20','00000057','00012345678000000570','0','0','0'),
(86,'7/10','8','10','20','00000058','00012345678000000581','0','0','0'),
(87,'8/10','8','10','20','00000059','00012345678000000592','0','0','0'),
(88,'9/10','8','10','20','00000060','00012345678000000604','0','0','0'),
(89,'10/10','8','10','20','00000061','00012345678000000613','0','0','0'),
(90,'1/12','9','10','30','00000062','000000000620','0','0','0'),
(91,'2/12','9','10','30','00000063','000000000631','0','0','0'),
(92,'3/12','9','10','30','00000064','000000000642','0','0','0'),
(93,'4/12','9','10','30','00000065','000000000653','0','0','0'),
(94,'5/12','9','10','30','00000066','000000000664','0','0','0'),
(95,'6/12','9','10','30','00000067','000000000675','0','0','0'),
(96,'7/12','9','10','30','00000068','000000000684','0','0','0'),
(97,'8/12','9','10','30','00000069','000000000693','0','0','0'),
(98,'9/12','9','10','30','00000070','000000000701','0','0','0'),
(99,'10/12','9','10','30','00000071','000000000712','0','0','0'),
(100,'11/12','9','10','30','00000072','000000000723','0','0','0'),
(101,'12/12','9','10','30','00000073','000000000734','0','0','0'),
(102,'1/5','10','10','20','00000074','000000000745','0','0','0'),
(103,'2/5','10','10','20','00000075','000000000754','0','0','0'),
(104,'3/5','10','10','20','00000076','000000000763','0','0','0'),
(105,'4/5','10','10','20','00000077','000000000772','0','0','0'),
(106,'5/5','10','10','20','00000078','000000000781','0','0','0'),
(107,'1/5','12','45','55','00000079','000000000790','0','0','0'),
(108,'1/5','12','45','55','00000079','000000000790','0','0','0'),
(109,'2/5','12','45','55','00000080','000000000806','0','0','0'),
(110,'2/5','12','45','55','00000080','000000000806','0','0','0'),
(111,'3/5','12','45','55','00000081','000000000815','0','0','0'),
(112,'3/5','12','45','55','00000081','000000000815','0','0','0'),
(113,'4/5','12','45','55','00000082','000000000824','0','0','0'),
(114,'4/5','12','45','55','00000082','000000000824','0','0','0'),
(115,'5/5','12','45','55','00000083','000000000833','0','0','0'),
(116,'5/5','12','45','55','00000083','000000000833','0','0','0'),
(117,'1/5','13','45','55','00000079','000000000790','0','0','0'),
(118,'2/5','13','45','55','00000080','000000000806','0','0','0'),
(119,'3/5','13','45','55','00000081','000000000815','0','0','0'),
(120,'4/5','13','45','55','00000082','000000000824','0','0','0'),
(121,'5/5','13','45','55','00000083','000000000833','0','0','0'),
(122,'1/5','14','10','20','00000084','000000000842','0','0','0'),
(123,'2/5','14','10','20','00000085','000000000851','0','0','0'),
(124,'3/5','14','10','20','00000086','000000000860','0','0','0'),
(125,'4/5','14','10','20','00000087','000000000879','0','0','0'),
(126,'5/5','14','10','20','00000088','000000000888','0','0','0'),
(127,'1/5','15','35','50','00000089','000000000897','0','0','0'),
(128,'2/5','15','35','50','00000090','000000000903','0','0','0'),
(129,'3/5','15','35','50','00000091','000000000912','0','0','0'),
(130,'4/5','15','35','50','00000092','000000000921','0','0','0'),
(131,'5/5','15','35','50','00000093','000000000930','0','0','0'),
(132,'1/5','16','10','20','00000094','000000000949','0','0','0'),
(133,'2/5','16','10','20','00000095','000000000958','0','0','0'),
(134,'3/5','16','10','20','00000096','000000000967','0','0','0'),
(135,'4/5','16','10','20','00000097','000000000976','0','0','0'),
(136,'5/5','16','10','20','00000098','000000000985','0','0','0'),
(137,'1/3','17','45','55','00000099','000000000994','0','0','0'),
(138,'2/3','17','45','55','00000100','000000001009','0','0','0'),
(139,'3/3','17','45','55','00000101','000000001018','0','0','0'),
(140,'1/5','18','42','52','00000102','000000001027','0','0','0'),
(141,'2/5','18','42','52','00000103','000000001036','0','0','0'),
(142,'3/5','18','42','52','00000104','000000001045','0','0','0'),
(143,'4/5','18','42','52','00000105','000000001054','0','0','0'),
(144,'5/5','18','42','52','00000106','000000001063','0','0','0'),
(145,'2/5','19','45','60','00000108','000000001081','0','0','0'),
(146,'3/5','19','45','60','00000109','000000001090','0','0','0'),
(147,'4/5','19','45','60','00000110','000000001106','0','0','0'),
(148,'5/5','19','45','60','00000111','000000001115','0','0','0'),
(149,'1/5','20','16','28','00000112','000000001124','0','0','0'),
(150,'2/5','20','16','28','00000113','000000001133','0','0','0'),
(151,'3/5','20','16','28','00000114','000000001142','0','0','0'),
(152,'4/5','20','16','28','00000115','000000001151','0','0','0'),
(153,'5/5','20','16','28','00000116','000000001160','0','0','0'),
(154,'1/3','21','120','132','00000117','000000001179','0','0','0'),
(155,'2/3','21','120','132','00000118','000000001188','0','0','0'),
(156,'3/3','21','120','132','00000119','000000001197','0','0','0'),
(157,'1/3','22','120','138','00000120','000000001203','0','0','0'),
(158,'2/3','22','120','138','00000121','000000001212','0','0','0'),
(159,'3/3','22','120','138','00000122','000000001221','0','0','0'),
(160,'1/2','23','120','138','00000123','000000001230','0','0','0'),
(161,'2/2','23','120','138','00000124','000000001249','0','0','0'),
(162,'1/3','24','111','129','00000125','000000001258','0','0','0'),
(163,'2/3','24','111','129','00000126','000000001267','0','0','0'),
(164,'3/3','24','111','129','00000127','000000001276','0','0','0'),
(165,'1/3','25','120','132','00000128','000000001285','0','0','0'),
(166,'2/3','25','120','132','00000129','000000001294','0','0','0'),
(167,'3/3','25','120','132','00000130','000000001300','0','0','0'),
(168,'1/3','26','102','114','00000131','000000001319','0','0','0'),
(169,'2/3','26','102','114','00000132','000000001328','0','0','0'),
(170,'3/3','26','102','114','00000133','000000001337','0','0','0'),
(171,'1/3','27','102','114','00000134','000000001346','0','0','0'),
(172,'2/3','27','102','114','00000135','000000001355','0','0','0'),
(173,'3/3','27','102','114','00000136','000000001364','0','0','0'),
(174,'1/3','28','102','114','00000137','000000001373','0','0','0'),
(175,'2/3','28','102','114','00000138','000000001382','0','0','0'),
(176,'3/3','28','102','114','00000139','000000001391','0','0','0'),
(177,'1/4','29','545','563','00000140','000000001407','0','0','0'),
(178,'2/4','29','545','563','00000141','000000001416','0','0','0'),
(179,'3/4','29','545','563','00000142','000000001425','0','0','0'),
(180,'4/4','29','545','563','00000143','000000001434','0','0','0'),
(181,'2/3','30','34','46','00000145','000000001452','0','0','0'),
(182,'3/3','30','34','46','00000146','000000001461','0','0','0'),
(183,'1/5','31','120','138','00000147','000000001470','0','0','0'),
(184,'2/5','31','120','138','00000148','000000001489','0','0','0'),
(185,'3/5','31','120','138','00000149','000000001498','0','0','0'),
(186,'4/5','31','120','138','00000150','000000001504','0','0','0'),
(187,'5/5','31','120','138','00000151','000000001513','0','0','0'),
(188,'1/3','32','132','150','00000152','000000001522','0','0','0'),
(189,'2/3','32','132','150','00000153','000000001531','0','0','0'),
(190,'3/3','32','132','150','00000154','000000001540','0','0','0'),
(191,'1/3','33','333','351','00000155','000000001559','0','0','0'),
(192,'2/3','33','333','351','00000156','000000001568','0','0','0'),
(193,'3/3','33','333','351','00000157','000000001577','0','0','0'),
(194,'1/2','34','222','234','00000158','000000001586','0','0','1'),
(195,'2/2','34','222','234','00000159','000000001595','0','0','0'),
(196,'1/3','35','123','141','00000160','000000001601','0','0','0'),
(197,'2/3','35','123','141','00000161','000000001610','0','0','0'),
(198,'3/3','35','123','141','00000162','000000001629','0','0','0'),
(199,'1/5','36','125.2','137.2','00000163','000000001638','0','0','1'),
(200,'2/5','36','125.2','137.2','00000164','000000001647','0','0','1'),
(201,'3/5','36','125.2','137.2','00000165','000000001656','0','0','1'),
(202,'4/5','36','125.2','137.2','00000166','000000001665','0','0','1'),
(203,'5/5','36','125.2','137.2','00000167','000000001674','0','0','1'),
(204,'1/3','37','120','240','00000168','000000001683','0','0','0'),
(205,'2/3','37','120','240','00000169','000000001692','0','0','0'),
(206,'3/3','37','120','240','00000170','000000001708','0','0','0'),
(207,'1/3','38','120','132','00000171','000000001717','0','0','0'),
(208,'2/3','38','120','132','00000172','000000001726','0','0','0'),
(209,'3/3','38','120','132','00000173','000000001735','0','0','0'),
(210,'1/2','39','180','198','00000174','000000001744','0','0','0'),
(211,'2/2','39','180','198','00000175','000000001753','0','0','0'),
(212,'1/3','40','156','276','00000176','000000001762','0','0','0'),
(213,'2/3','40','156','276','00000177','000000001771','0','0','0'),
(214,'3/3','40','156','276','00000178','000000001780','0','0','0'),
(215,'1/3','41','200','212','00000179','000000001799','0','0','0'),
(216,'2/3','41','200','212','00000180','000000001805','0','0','0'),
(217,'3/3','41','200','212','00000181','000000001814','0','0','0'),
(218,'1/3','42','150','162','00000182','000000001823','0','0','0'),
(219,'2/3','42','150','162','00000183','000000001832','0','0','0'),
(220,'3/3','42','150','162','00000184','000000001841','0','0','0'),
(221,'1/3','43','5','17','00000185','000000001850','0','0','0'),
(222,'2/3','43','5','17','00000186','000000001869','0','0','0'),
(223,'3/3','43','5','17','000','000000001878','0','0','0'),
(224,'1/3','44','1580','1700','001','0478965230013','0','0','0'),
(225,'2/3','44','1580','1700','002','0478965230020','0','0','0'),
(226,'3/3','44','1580','1700','003','0478965230037','0','0','0'),
(227,'1/5','45','152','272','004','0478965230044','0','0','0'),
(228,'2/5','45','152','272','005','0478965230051','0','0','0'),
(229,'3/5','45','152','272','006','0478965230068','0','0','0'),
(230,'4/5','45','152','272','007','0478965230075','0','0','0'),
(231,'5/5','45','152','272','008','0478965230082','0','0','0'),
(232,'1/8','46','158','278','001','0478965230013','0','0','0'),
(233,'2/8','46','158','278','002','0478965230020','0','0','0'),
(234,'3/8','46','158','278','003','0478965230037','0','0','0'),
(235,'4/8','46','158','278','004','0478965230044','0','0','0'),
(236,'5/8','46','158','278','005','0478965230051','0','0','0'),
(237,'6/8','46','158','278','006','0478965230068','0','0','0'),
(238,'7/8','46','158','278','007','0478965230075','0','0','0'),
(239,'8/8','46','158','278','008','0478965230082','0','0','0'),
(240,'1/9','47','150','270','009','0478965230099','0','0','0'),
(241,'2/9','47','150','270','010','0478965230105','0','0','0'),
(242,'3/9','47','150','270','011','0478965230112','0','0','0'),
(243,'4/9','47','150','270','012','0478965230129','0','0','0'),
(244,'5/9','47','150','270','013','0478965230136','0','0','0'),
(245,'6/9','47','150','270','014','0478965230143','0','0','0'),
(246,'7/9','47','150','270','015','0478965230150','0','0','0'),
(247,'8/9','47','150','270','016','0478965230167','0','0','0'),
(248,'9/9','47','150','270','017','0478965230174','0','0','0'),
(249,'1/10','48','1450','2300','001','085485550015','0','0','0'),
(250,'2/10','48','1450','2300','002','085485550024','0','0','0'),
(251,'3/10','48','1450','2300','003','085485550033','0','0','0'),
(252,'4/10','48','1450','2300','004','085485550042','0','0','0'),
(253,'5/10','48','1450','2300','005','085485550051','0','0','0'),
(254,'6/10','48','1450','2300','006','085485550060','0','0','0'),
(255,'7/10','48','1450','2300','007','085485550079','0','0','0'),
(256,'8/10','48','1450','2300','008','085485550088','0','0','0'),
(257,'9/10','48','1450','2300','009','085485550097','0','0','0'),
(258,'10/10','48','1450','2300','010','085485550103','0','0','0'),
(259,'1/5','49','520','1370','011','085485550112','0','0','0'),
(260,'2/5','49','520','1370','012','085485550121','0','0','0'),
(261,'3/5','49','520','1370','013','085485550130','0','0','0'),
(262,'4/5','49','520','1370','014','085485550149','0','0','0'),
(263,'5/5','49','520','1370','015','085485550158','0','0','0'),
(264,'1/5','50','150','1000','016','085485550167','0','0','0'),
(265,'2/5','50','150','1000','017','085485550176','0','0','0'),
(266,'3/5','50','150','1000','018','085485550185','0','0','0'),
(267,'4/5','50','150','1000','019','085485550194','0','0','0'),
(268,'5/5','50','150','1000','020','085485550200','0','0','0');
/*!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=713 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,'QR generated',NULL,'3',NULL),
(2,NULL,'QR generated','2024-03-07 17:07:21','3',NULL),
(3,NULL,'Alias Product Added','2024-03-07 17:22:18','3',NULL),
(4,NULL,'Alias Product Edited','2024-03-07 17:24:04','3',NULL),
(5,NULL,'Alias Product Updated','2024-03-07 17:24:12','3',NULL),
(6,NULL,'Batch Added','2024-03-07 17:40:27','3','pbatch'),
(7,NULL,'Customer Added','2024-03-07 17:50:47','3','customer'),
(8,NULL,'Customer Updated','2024-03-07 17:51:13','3','customer'),
(9,NULL,'New Company Added','2024-03-07 18:32:49','3','manufacture'),
(10,NULL,'Company Updated','2024-03-07 18:33:02','3','manufacture'),
(11,NULL,'Company Deleted','2024-03-07 18:33:23','3','manufacture'),
(12,NULL,'New Product Added','2024-03-07 18:37:40','3','product'),
(13,NULL,'Product Updated','2024-03-07 18:37:50','3','product'),
(14,NULL,'Product Deleted','2024-03-07 18:37:55','3','product'),
(15,NULL,'Batch Data Deleted','2024-03-07 18:39:09','3','pbatch'),
(16,NULL,'Customer Updated','2024-03-07 18:39:46','3','customer'),
(17,NULL,'Customer Deleted','2024-03-07 18:39:53','3','customer'),
(18,NULL,'Alias Product Added','2024-03-07 18:40:19','3','AliasProduct'),
(19,NULL,'Alias Product Edited','2024-03-07 18:40:22','3','AliasProduct'),
(20,NULL,'Alias Product Updated','2024-03-07 18:40:25','3','AliasProduct'),
(21,NULL,'Single Print Had Taken','2024-03-07 18:41:46','3','generateqrsr'),
(22,NULL,'Multiple Print Had Taken','2024-03-07 18:42:01','3','generateqrsr'),
(23,NULL,'New User Added','2024-03-08 11:25:42','3','userm'),
(24,NULL,'User Data And Rights Updated','2024-03-08 11:26:19','3','userm'),
(25,NULL,'User Deleted','2024-03-08 11:26:24','3','userm'),
(26,NULL,'QR generated','2024-03-08 11:33:21','3','generateqrsr'),
(27,NULL,'Single Print Had Taken','2024-03-08 11:33:54','3','generateqrsr'),
(28,NULL,'Multiple Print Had Taken','2024-03-08 11:34:01','3','generateqrsr'),
(29,NULL,'User Data And Rights Updated','2024-03-08 12:04:06','3','userm'),
(30,NULL,'Product Deleted','2024-03-08 12:45:27','3','product'),
(31,NULL,'Product Updated','2024-03-08 12:45:59','3','product'),
(32,NULL,'Multiple Print Had Taken','2024-03-08 15:04:05','3','generateqrsr'),
(33,NULL,'Single Print Had Taken','2024-03-08 15:04:26','3','generateqrsr'),
(34,NULL,'Single Print Had Taken','2024-03-08 15:04:38','3','generateqrsr'),
(35,NULL,'Single Print Had Taken','2024-03-08 15:04:47','3','generateqrsr'),
(36,NULL,'Single Print Had Taken','2024-03-08 15:04:57','3','generateqrsr'),
(37,NULL,'Multiple Print Had Taken','2024-03-08 15:05:05','3','generateqrsr'),
(38,NULL,'Single Print Had Taken','2024-03-08 15:06:38','3','generateqrsr'),
(39,NULL,'Multiple Print Had Taken','2024-03-08 15:06:47','3','generateqrsr'),
(40,NULL,'Single Print Had Taken','2024-03-08 15:07:12','3','generateqrsr'),
(41,NULL,'Multiple Print Had Taken','2024-03-08 15:07:22','3','generateqrsr'),
(42,NULL,'Multiple Print Had Taken','2024-03-08 15:09:22','3','generateqrsr'),
(43,NULL,'Multiple Print Had Taken','2024-03-08 15:10:13','3','generateqrsr'),
(44,NULL,'Multiple Print Had Taken','2024-03-08 15:11:00','3','generateqrsr'),
(45,NULL,'Multiple Print Had Taken','2024-03-08 15:12:16','3','generateqrsr'),
(46,NULL,'Multiple Print Had Taken','2024-03-08 15:14:44','3','generateqrsr'),
(47,NULL,'Multiple Print Had Taken','2024-03-08 15:16:54','3','generateqrsr'),
(48,NULL,'Single Print Had Taken','2024-03-08 16:10:00','3','generateqrsr'),
(49,NULL,'Multiple Print Had Taken','2024-03-08 16:10:28','3','generateqrsr'),
(50,NULL,'Multiple Print Had Taken','2024-03-08 16:15:51','3','generateqrsr'),
(51,NULL,'Multiple Print Had Taken','2024-03-08 16:16:38','3','generateqrsr'),
(52,NULL,'Multiple Print Had Taken','2024-03-08 16:17:11','3','generateqrsr'),
(53,NULL,'Multiple Print Had Taken','2024-03-08 17:13:17','3','generateqrsr'),
(54,NULL,'Multiple Print Had Taken','2024-03-08 17:16:04','3','generateqrsr'),
(55,NULL,'Multiple Print Had Taken','2024-03-08 17:17:55','3','generateqrsr'),
(56,NULL,'Multiple Print Had Taken','2024-03-08 17:19:27','3','generateqrsr'),
(57,NULL,'Multiple Print Had Taken','2024-03-08 17:19:52','3','generateqrsr'),
(58,NULL,'Multiple Print Had Taken','2024-03-08 17:21:18','3','generateqrsr'),
(59,NULL,'Multiple Print Had Taken','2024-03-08 17:21:31','3','generateqrsr'),
(60,NULL,'Multiple Print Had Taken','2024-03-08 17:30:19','3','generateqrsr'),
(61,NULL,'Multiple Print Had Taken','2024-03-08 17:31:54','3','generateqrsr'),
(62,NULL,'Multiple Print Had Taken','2024-03-08 17:32:46','3','generateqrsr'),
(63,NULL,'Multiple Print Had Taken','2024-03-08 17:46:44','3','generateqrsr'),
(64,NULL,'Multiple Print Had Taken','2024-03-08 17:48:02','3','generateqrsr'),
(65,NULL,'Multiple Print Had Taken','2024-03-08 17:50:06','3','generateqrsr'),
(66,NULL,'Multiple Print Had Taken','2024-03-08 17:55:40','3','generateqrsr'),
(67,NULL,'Multiple Print Had Taken','2024-03-08 18:02:53','3','generateqrsr'),
(68,NULL,'Multiple Print Had Taken','2024-03-08 18:04:20','3','generateqrsr'),
(69,NULL,'Multiple Print Had Taken','2024-03-08 18:05:39','3','generateqrsr'),
(70,NULL,'Multiple Print Had Taken','2024-03-08 18:06:33','3','generateqrsr'),
(71,NULL,'Multiple Print Had Taken','2024-03-08 18:09:07','3','generateqrsr'),
(72,NULL,'Multiple Print Had Taken','2024-03-08 18:09:15','3','generateqrsr'),
(73,NULL,'Multiple Print Had Taken','2024-03-08 18:09:40','3','generateqrsr'),
(74,NULL,'Multiple Print Had Taken','2024-03-08 18:09:50','3','generateqrsr'),
(75,NULL,'Multiple Print Had Taken','2024-03-08 18:09:57','3','generateqrsr'),
(76,NULL,'Multiple Print Had Taken','2024-03-08 18:09:57','3','generateqrsr'),
(77,NULL,'Multiple Print Had Taken','2024-03-08 18:09:58','3','generateqrsr'),
(78,NULL,'Multiple Print Had Taken','2024-03-08 18:09:58','3','generateqrsr'),
(79,NULL,'Multiple Print Had Taken','2024-03-08 18:09:58','3','generateqrsr'),
(80,NULL,'Multiple Print Had Taken','2024-03-08 18:09:58','3','generateqrsr'),
(81,NULL,'Multiple Print Had Taken','2024-03-08 18:09:59','3','generateqrsr'),
(82,NULL,'Multiple Print Had Taken','2024-03-08 18:09:59','3','generateqrsr'),
(83,NULL,'Multiple Print Had Taken','2024-03-08 18:11:00','3','generateqrsr'),
(84,NULL,'Multiple Print Had Taken','2024-03-08 18:11:09','3','generateqrsr'),
(85,NULL,'Multiple Print Had Taken','2024-03-08 18:11:10','3','generateqrsr'),
(86,NULL,'Multiple Print Had Taken','2024-03-08 18:11:11','3','generateqrsr'),
(87,NULL,'Multiple Print Had Taken','2024-03-08 18:11:11','3','generateqrsr'),
(88,NULL,'Multiple Print Had Taken','2024-03-08 18:11:11','3','generateqrsr'),
(89,NULL,'Multiple Print Had Taken','2024-03-08 18:11:11','3','generateqrsr'),
(90,NULL,'Multiple Print Had Taken','2024-03-08 18:11:12','3','generateqrsr'),
(91,NULL,'Multiple Print Had Taken','2024-03-08 18:11:12','3','generateqrsr'),
(92,NULL,'Multiple Print Had Taken','2024-03-08 18:11:12','3','generateqrsr'),
(93,NULL,'Multiple Print Had Taken','2024-03-08 18:11:13','3','generateqrsr'),
(94,NULL,'Multiple Print Had Taken','2024-03-08 18:11:13','3','generateqrsr'),
(95,NULL,'Multiple Print Had Taken','2024-03-08 18:11:23','3','generateqrsr'),
(96,NULL,'Multiple Print Had Taken','2024-03-08 18:12:06','3','generateqrsr'),
(97,NULL,'Multiple Print Had Taken','2024-03-08 18:15:42','3','generateqrsr'),
(98,NULL,'Multiple Print Had Taken','2024-03-08 18:15:47','3','generateqrsr'),
(99,NULL,'Multiple Print Had Taken','2024-03-08 18:15:53','3','generateqrsr'),
(100,NULL,'Multiple Print Had Taken','2024-03-08 18:17:32','3','generateqrsr'),
(101,NULL,'Multiple Print Had Taken','2024-03-08 18:19:01','3','generateqrsr'),
(102,NULL,'Single Print Had Taken','2024-03-08 18:26:37','3','generateqrsr'),
(103,NULL,'Single Print Had Taken','2024-03-08 18:26:51','3','generateqrsr'),
(104,NULL,'Single Print Had Taken','2024-03-08 18:33:01','3','generateqrsr'),
(105,NULL,'Single Print Had Taken','2024-03-08 18:34:33','3','generateqrsr'),
(106,NULL,'Single Print Had Taken','2024-03-08 18:36:03','3','generateqrsr'),
(107,NULL,'Single Print Had Taken','2024-03-08 18:36:56','3','generateqrsr'),
(108,NULL,'Single Print Had Taken','2024-03-08 18:38:01','3','generateqrsr'),
(109,NULL,'Single Print Had Taken','2024-03-08 18:39:00','3','generateqrsr'),
(110,NULL,'Single Print Had Taken','2024-03-08 18:40:08','3','generateqrsr'),
(111,NULL,'Single Print Had Taken','2024-03-08 18:40:59','3','generateqrsr'),
(112,NULL,'Single Print Had Taken','2024-03-08 18:42:03','3','generateqrsr'),
(113,NULL,'Single Print Had Taken','2024-03-08 21:08:01','3','generateqrsr'),
(114,NULL,'Single Print Had Taken','2024-03-08 22:28:45','3','generateqrsr'),
(115,NULL,'Single Print Had Taken','2024-03-08 22:29:02','3','generateqrsr'),
(116,NULL,'Single Print Had Taken','2024-03-08 22:30:15','3','generateqrsr'),
(117,NULL,'Single Print Had Taken','2024-03-08 22:32:33','3','generateqrsr'),
(118,NULL,'Single Print Had Taken','2024-03-08 22:33:08','3','generateqrsr'),
(119,NULL,'Single Print Had Taken','2024-03-08 22:34:00','3','generateqrsr'),
(120,NULL,'Single Print Had Taken','2024-03-08 22:34:38','3','generateqrsr'),
(121,NULL,'Single Print Had Taken','2024-03-08 22:37:19','3','generateqrsr'),
(122,NULL,'Multiple Print Had Taken','2024-03-08 22:37:44','3','generateqrsr'),
(123,NULL,'Single Print Had Taken','2024-03-08 22:38:28','3','generateqrsr'),
(124,NULL,'Multiple Print Had Taken','2024-03-08 22:41:16','3','generateqrsr'),
(125,NULL,'Multiple Print Had Taken','2024-03-08 22:42:12','3','generateqrsr'),
(126,NULL,'Single Print Had Taken','2024-03-08 22:49:44','3','generateqrsr'),
(127,NULL,'Single Print Had Taken','2024-03-08 22:49:57','3','generateqrsr'),
(128,NULL,'Single Print Had Taken','2024-03-08 22:51:57','3','generateqrsr'),
(129,NULL,'Single Print Had Taken','2024-03-08 22:57:35','3','generateqrsr'),
(130,NULL,'Multiple Print Had Taken','2024-03-08 22:57:54','3','generateqrsr'),
(131,NULL,'Single Print Had Taken','2024-03-09 18:55:03','3','generateqrsr'),
(132,NULL,'Multiple Print Had Taken','2024-03-09 18:55:15','3','generateqrsr'),
(133,NULL,'Single Print Had Taken','2024-03-09 19:38:53','3','generateqrsr'),
(134,NULL,'Single Print Had Taken','2024-03-09 19:40:48','3','generateqrsr'),
(135,NULL,'Single Print Had Taken','2024-03-11 10:26:35','3','generateqrsr'),
(136,NULL,'Single Print Had Taken','2024-03-11 10:26:58','3','generateqrsr'),
(137,NULL,'Single Print Had Taken','2024-03-11 10:27:20','3','generateqrsr'),
(138,NULL,'Single Print Had Taken','2024-03-11 11:13:45','3','generateqrsr'),
(139,NULL,'Multiple Print Had Taken','2024-03-11 11:15:56','3','generateqrsr'),
(140,NULL,'Single Print Had Taken','2024-03-11 11:17:39','3','generateqrsr'),
(141,NULL,'Single Print Had Taken','2024-03-11 11:19:32','3','generateqrsr'),
(142,NULL,'Single Print Had Taken','2024-03-11 11:20:52','3','generateqrsr'),
(143,NULL,'Single Print Had Taken','2024-03-11 11:21:18','3','generateqrsr'),
(144,NULL,'Single Print Had Taken','2024-03-11 11:21:27','3','generateqrsr'),
(145,NULL,'Single Print Had Taken','2024-03-11 11:21:41','3','generateqrsr'),
(146,NULL,'Single Print Had Taken','2024-03-11 11:23:01','3','generateqrsr'),
(147,NULL,'User Data And Rights Updated','2024-03-11 11:47:23','3','userm'),
(148,NULL,'QR generated','2024-03-11 15:29:12','3','generateqrsr'),
(149,NULL,'QR generated','2024-03-11 15:41:04','3','generateqrsr'),
(150,NULL,'Single Print Had Taken','2024-03-12 11:01:32','3','generateqrsr'),
(151,NULL,'Alias Product Added','2024-03-13 16:53:00','3','AliasProduct'),
(152,NULL,'Alias Product Added','2024-03-13 16:54:36','3','AliasProduct'),
(153,NULL,'Alias Product Edited','2024-03-13 17:02:28','3','AliasProduct'),
(154,NULL,'Alias Product Updated','2024-03-13 17:02:38','3','AliasProduct'),
(155,NULL,'Alias Product Edited','2024-03-13 17:06:35','3','AliasProduct'),
(156,NULL,'Alias Product Updated','2024-03-13 17:06:40','3','AliasProduct'),
(157,NULL,'Alias Product Added','2024-03-14 11:34:57','3','AliasProduct'),
(158,NULL,'Alias Product Edited','2024-03-14 11:35:28','3','AliasProduct'),
(159,NULL,'Alias Product Added','2024-03-14 11:39:39','3','AliasProduct'),
(160,NULL,'Alias Product Added','2024-03-14 11:39:47','3','AliasProduct'),
(161,NULL,'Alias Product Added','2024-03-14 11:39:54','3','AliasProduct'),
(162,NULL,'Alias Product Edited','2024-03-14 11:47:44','3','AliasProduct'),
(163,NULL,'Alias Product Edited','2024-03-14 11:50:24','3','AliasProduct'),
(164,NULL,'Alias Product Edited','2024-03-14 11:51:01','3','AliasProduct'),
(165,NULL,'Alias Product Updated','2024-03-14 11:51:08','3','AliasProduct'),
(166,NULL,'Alias Product Added','2024-03-14 11:52:55','3','AliasProduct'),
(167,NULL,'Alias Product Edited','2024-03-14 11:53:30','3','AliasProduct'),
(168,NULL,'Alias Product Updated','2024-03-14 11:53:34','3','AliasProduct'),
(169,NULL,'Alias Product Edited','2024-03-14 11:54:58','3','AliasProduct'),
(170,NULL,'Alias Product Updated','2024-03-14 11:55:03','3','AliasProduct'),
(171,NULL,'Alias Product Edited','2024-03-14 12:02:19','3','AliasProduct'),
(172,NULL,'Alias Product Updated','2024-03-14 12:02:23','3','AliasProduct'),
(173,NULL,'Single Print Had Taken','2024-03-14 13:40:42','3','generateqrsr'),
(174,NULL,'Single Print Had Taken','2024-03-14 13:41:01','3','generateqrsr'),
(175,NULL,'Single Print Had Taken','2024-03-14 13:41:18','3','generateqrsr'),
(176,NULL,'Single Print Had Taken','2024-03-14 13:41:58','3','generateqrsr'),
(177,NULL,'Batch Added','2024-03-14 14:43:16','3','pbatch'),
(178,NULL,'Alias Product Added','2024-03-14 14:44:49','3','AliasProduct'),
(179,NULL,'QR generated','2024-03-14 14:45:29','3','generateqrsr'),
(180,NULL,'Single Print Had Taken','2024-03-14 14:45:38','3','generateqrsr'),
(181,NULL,'Multiple Print Had Taken','2024-03-14 14:46:13','3','generateqrsr'),
(182,NULL,'Single Print Had Taken','2024-03-14 14:54:37','3','generateqrsr'),
(183,NULL,'Single Print Had Taken','2024-03-14 14:58:09','3','generateqrsr'),
(184,NULL,'Single Print Had Taken','2024-03-14 14:58:52','3','generateqrsr'),
(185,NULL,'Single Print Had Taken','2024-03-14 15:00:19','3','generateqrsr'),
(186,NULL,'Single Print Had Taken','2024-03-14 15:01:15','3','generateqrsr'),
(187,NULL,'Single Print Had Taken','2024-03-14 15:03:00','3','generateqrsr'),
(188,NULL,'Single Print Had Taken','2024-03-14 15:04:00','3','generateqrsr'),
(189,NULL,'Single Print Had Taken','2024-03-14 15:05:38','3','generateqrsr'),
(190,NULL,'Single Print Had Taken','2024-03-14 15:09:32','3','generateqrsr'),
(191,NULL,'Single Print Had Taken','2024-03-14 15:10:45','3','generateqrsr'),
(192,NULL,'Single Print Had Taken','2024-03-14 15:11:28','3','generateqrsr'),
(193,NULL,'Single Print Had Taken','2024-03-14 15:13:44','3','generateqrsr'),
(194,NULL,'Single Print Had Taken','2024-03-14 15:15:07','3','generateqrsr'),
(195,NULL,'Single Print Had Taken','2024-03-14 15:15:55','3','generateqrsr'),
(196,NULL,'Single Print Had Taken','2024-03-14 15:16:24','3','generateqrsr'),
(197,NULL,'Single Print Had Taken','2024-03-14 15:17:25','3','generateqrsr'),
(198,NULL,'Single Print Had Taken','2024-03-14 15:18:26','3','generateqrsr'),
(199,NULL,'Single Print Had Taken','2024-03-14 15:19:37','3','generateqrsr'),
(200,NULL,'Single Print Had Taken','2024-03-14 15:20:58','3','generateqrsr'),
(201,NULL,'Single Print Had Taken','2024-03-14 15:21:29','3','generateqrsr'),
(202,NULL,'Single Print Had Taken','2024-03-14 15:22:04','3','generateqrsr'),
(203,NULL,'Single Print Had Taken','2024-03-14 15:23:29','3','generateqrsr'),
(204,NULL,'Single Print Had Taken','2024-03-14 15:24:24','3','generateqrsr'),
(205,NULL,'Single Print Had Taken','2024-03-14 15:25:13','3','generateqrsr'),
(206,NULL,'Single Print Had Taken','2024-03-14 15:26:35','3','generateqrsr'),
(207,NULL,'Single Print Had Taken','2024-03-14 15:27:44','3','generateqrsr'),
(208,NULL,'Single Print Had Taken','2024-03-14 15:29:24','3','generateqrsr'),
(209,NULL,'Single Print Had Taken','2024-03-14 15:30:12','3','generateqrsr'),
(210,NULL,'Single Print Had Taken','2024-03-14 15:30:51','3','generateqrsr'),
(211,NULL,'Single Print Had Taken','2024-03-14 15:32:32','3','generateqrsr'),
(212,NULL,'Single Print Had Taken','2024-03-14 15:33:35','3','generateqrsr'),
(213,NULL,'Single Print Had Taken','2024-03-14 15:34:26','3','generateqrsr'),
(214,NULL,'Single Print Had Taken','2024-03-14 15:35:49','3','generateqrsr'),
(215,NULL,'Single Print Had Taken','2024-03-14 15:36:40','3','generateqrsr'),
(216,NULL,'Single Print Had Taken','2024-03-14 15:37:15','3','generateqrsr'),
(217,NULL,'Single Print Had Taken','2024-03-14 15:37:40','3','generateqrsr'),
(218,NULL,'Single Print Had Taken','2024-03-14 15:38:25','3','generateqrsr'),
(219,NULL,'Single Print Had Taken','2024-03-14 15:38:53','3','generateqrsr'),
(220,NULL,'Single Print Had Taken','2024-03-14 15:39:26','3','generateqrsr'),
(221,NULL,'Single Print Had Taken','2024-03-14 15:41:03','3','generateqrsr'),
(222,NULL,'Single Print Had Taken','2024-03-14 15:41:46','3','generateqrsr'),
(223,NULL,'Single Print Had Taken','2024-03-14 15:42:48','3','generateqrsr'),
(224,NULL,'Single Print Had Taken','2024-03-14 15:43:33','3','generateqrsr'),
(225,NULL,'Single Print Had Taken','2024-03-14 15:44:54','3','generateqrsr'),
(226,NULL,'Single Print Had Taken','2024-03-14 15:57:47','3','generateqrsr'),
(227,NULL,'Single Print Had Taken','2024-03-14 15:58:48','3','generateqrsr'),
(228,NULL,'Single Print Had Taken','2024-03-14 15:59:26','3','generateqrsr'),
(229,NULL,'Single Print Had Taken','2024-03-14 16:01:27','3','generateqrsr'),
(230,NULL,'Single Print Had Taken','2024-03-14 16:03:07','3','generateqrsr'),
(231,NULL,'Single Print Had Taken','2024-03-14 16:03:33','3','generateqrsr'),
(232,NULL,'Single Print Had Taken','2024-03-14 16:19:51','3','generateqrsr'),
(233,NULL,'Single Print Had Taken','2024-03-14 16:20:47','3','generateqrsr'),
(234,NULL,'Single Print Had Taken','2024-03-14 16:21:27','3','generateqrsr'),
(235,NULL,'Single Print Had Taken','2024-03-14 16:22:06','3','generateqrsr'),
(236,NULL,'Single Print Had Taken','2024-03-14 16:25:22','3','generateqrsr'),
(237,NULL,'Single Print Had Taken','2024-03-14 16:26:00','3','generateqrsr'),
(238,NULL,'Single Print Had Taken','2024-03-14 16:26:26','3','generateqrsr'),
(239,NULL,'Single Print Had Taken','2024-03-14 16:26:51','3','generateqrsr'),
(240,NULL,'Single Print Had Taken','2024-03-14 16:27:21','3','generateqrsr'),
(241,NULL,'Single Print Had Taken','2024-03-14 16:27:45','3','generateqrsr'),
(242,NULL,'Single Print Had Taken','2024-03-14 16:28:08','3','generateqrsr'),
(243,NULL,'Single Print Had Taken','2024-03-14 16:28:35','3','generateqrsr'),
(244,NULL,'Single Print Had Taken','2024-03-14 16:29:28','3','generateqrsr'),
(245,NULL,'Single Print Had Taken','2024-03-14 16:30:04','3','generateqrsr'),
(246,NULL,'Single Print Had Taken','2024-03-14 16:31:13','3','generateqrsr'),
(247,NULL,'Single Print Had Taken','2024-03-14 16:31:51','3','generateqrsr'),
(248,NULL,'Single Print Had Taken','2024-03-14 16:32:27','3','generateqrsr'),
(249,NULL,'Single Print Had Taken','2024-03-14 16:34:38','3','generateqrsr'),
(250,NULL,'Single Print Had Taken','2024-03-14 16:35:56','3','generateqrsr'),
(251,NULL,'Single Print Had Taken','2024-03-14 16:41:10','3','generateqrsr'),
(252,NULL,'Single Print Had Taken','2024-03-14 16:42:36','3','generateqrsr'),
(253,NULL,'Single Print Had Taken','2024-03-14 16:43:24','3','generateqrsr'),
(254,NULL,'Single Print Had Taken','2024-03-14 16:46:53','3','generateqrsr'),
(255,NULL,'Single Print Had Taken','2024-03-14 16:52:03','3','generateqrsr'),
(256,NULL,'Single Print Had Taken','2024-03-14 16:52:36','3','generateqrsr'),
(257,NULL,'Single Print Had Taken','2024-03-14 16:54:39','3','generateqrsr'),
(258,NULL,'Single Print Had Taken','2024-03-14 16:57:57','3','generateqrsr'),
(259,NULL,'Single Print Had Taken','2024-03-14 16:58:23','3','generateqrsr'),
(260,NULL,'Single Print Had Taken','2024-03-14 17:16:22','3','generateqrsr'),
(261,NULL,'Single Print Had Taken','2024-03-14 17:17:02','3','generateqrsr'),
(262,NULL,'Single Print Had Taken','2024-03-14 17:24:29','3','generateqrsr'),
(263,NULL,'Single Print Had Taken','2024-03-14 17:25:51','3','generateqrsr'),
(264,NULL,'Single Print Had Taken','2024-03-14 17:27:30','3','generateqrsr'),
(265,NULL,'Single Print Had Taken','2024-03-15 11:10:24','3','generateqrsr'),
(266,NULL,'Multiple Print Had Taken','2024-03-15 11:10:52','3','generateqrsr'),
(267,NULL,'Multiple Print Had Taken','2024-03-15 11:55:39','3','generateqrsr'),
(268,NULL,'Single Print Had Taken','2024-03-15 11:58:43','3','generateqrsr'),
(269,NULL,'Single Print Had Taken','2024-03-15 12:01:00','3','generateqrsr'),
(270,NULL,'Single Print Had Taken','2024-03-15 12:01:34','3','generateqrsr'),
(271,NULL,'Single Print Had Taken','2024-03-15 12:01:55','3','generateqrsr'),
(272,NULL,'Single Print Had Taken','2024-03-15 12:03:35','3','generateqrsr'),
(273,NULL,'Single Print Had Taken','2024-03-15 12:04:02','3','generateqrsr'),
(274,NULL,'Single Print Had Taken','2024-03-15 12:04:58','3','generateqrsr'),
(275,NULL,'Single Print Had Taken','2024-03-15 12:05:51','3','generateqrsr'),
(276,NULL,'Multiple Print Had Taken','2024-03-15 12:06:34','3','generateqrsr'),
(277,NULL,'Single Print Had Taken','2024-03-15 12:06:45','3','generateqrsr'),
(278,NULL,'Single Print Had Taken','2024-03-15 12:07:07','3','generateqrsr'),
(279,NULL,'Single Print Had Taken','2024-03-15 12:07:32','3','generateqrsr'),
(280,NULL,'Single Print Had Taken','2024-03-15 12:08:11','3','generateqrsr'),
(281,NULL,'Single Print Had Taken','2024-03-15 12:08:29','3','generateqrsr'),
(282,NULL,'Single Print Had Taken','2024-03-15 12:09:11','3','generateqrsr'),
(283,NULL,'Single Print Had Taken','2024-03-15 12:09:34','3','generateqrsr'),
(284,NULL,'Single Print Had Taken','2024-03-15 12:10:20','3','generateqrsr'),
(285,NULL,'Single Print Had Taken','2024-03-15 12:11:33','3','generateqrsr'),
(286,NULL,'Single Print Had Taken','2024-03-15 16:13:05','3','generateqrsr'),
(287,NULL,'QR generated','2024-03-16 14:55:16','3','generateqrsr'),
(288,NULL,'Single Print Had Taken','2024-03-16 14:55:32','3','generateqrsr'),
(289,NULL,'Multiple Print Had Taken','2024-03-16 14:55:41','3','generateqrsr'),
(290,NULL,'QR generated','2024-03-16 15:10:22','3','generateqrsr'),
(291,NULL,'Single Print Had Taken','2024-03-16 15:10:40','3','generateqrsr'),
(292,NULL,'Single Print Had Taken','2024-03-16 15:10:49','3','generateqrsr'),
(293,NULL,'Multiple Print Had Taken','2024-03-16 15:10:55','3','generateqrsr'),
(294,NULL,'QR generated','2024-03-16 15:12:30','3','generateqrsr'),
(295,NULL,'Single Print Had Taken','2024-03-16 15:12:36','3','generateqrsr'),
(296,NULL,'Multiple Print Had Taken','2024-03-16 15:12:52','3','generateqrsr'),
(297,NULL,'Company Updated','2024-03-17 11:25:08','3','manufacture'),
(298,NULL,'Company Updated','2024-03-17 11:26:56','3','manufacture'),
(299,NULL,'Product Updated','2024-03-17 11:56:47','3','product'),
(300,NULL,'Product Deleted','2024-03-17 14:43:21','3','product'),
(301,NULL,'Batch Data Deleted','2024-03-17 14:54:24','3','pbatch'),
(302,NULL,'Customer Updated','2024-03-17 15:11:58','3','customer'),
(303,NULL,'User Data And Rights Updated','2024-03-17 17:05:53','3','userm'),
(304,NULL,'User Data And Rights Updated','2024-03-17 17:06:53','3','userm'),
(305,NULL,'User Data And Rights Updated','2024-03-18 10:30:23','3','userm'),
(306,NULL,'Single Print Had Taken','2024-03-18 11:32:25','3','generateqrsr'),
(307,NULL,'Multiple Print Had Taken','2024-03-18 11:32:47','3','generateqrsr'),
(308,NULL,'Single Print Had Taken','2024-03-18 11:36:59','3','generateqrsr'),
(309,NULL,'Single Print Had Taken','2024-03-18 11:37:27','3','generateqrsr'),
(310,NULL,'Single Print Had Taken','2024-03-18 11:37:55','3','generateqrsr'),
(311,NULL,'Single Print Had Taken','2024-03-18 11:39:25','3','generateqrsr'),
(312,NULL,'Single Print Had Taken','2024-03-18 11:44:13','3','generateqrsr'),
(313,NULL,'Single Print Had Taken','2024-03-18 11:48:00','3','generateqrsr'),
(314,NULL,'Single Print Had Taken','2024-03-18 11:54:21','3','generateqrsr'),
(315,NULL,'Single Print Had Taken','2024-03-18 12:05:55','3','generateqrsr'),
(316,NULL,'Single Print Had Taken','2024-03-18 12:13:41','3','generateqrsr'),
(317,NULL,'Single Print Had Taken','2024-03-18 12:14:32','3','generateqrsr'),
(318,NULL,'New User Added','2024-03-18 12:17:43','3','userm'),
(319,NULL,'Lot Added','2024-03-18 12:20:58','3','dispatch'),
(320,NULL,'Lot Added','2024-03-18 12:22:08','3','dispatch'),
(321,NULL,'Lot Added','2024-03-18 16:21:48','3','dispatch'),
(322,NULL,'Lot Added','2024-03-18 16:23:51','3','dispatch'),
(323,NULL,'Batch Added','2024-03-19 11:44:10','3','pbatch'),
(324,NULL,'Alias Product Added','2024-03-19 11:44:41','3','AliasProduct'),
(325,NULL,'QR generated','2024-03-19 11:45:23','3','generateqrsr'),
(326,NULL,'Single Print Had Taken','2024-03-19 11:45:29','3','generateqrsr'),
(327,NULL,'Single Print Had Taken','2024-03-19 11:45:57','3','generateqrsr'),
(328,NULL,'Single Print Had Taken','2024-03-20 15:01:46','3','generateqrsr'),
(329,NULL,'Multiple Print Had Taken','2024-03-20 15:01:56','3','generateqrsr'),
(330,NULL,'Lot Added','2024-03-20 15:33:37','3','dispatch'),
(331,NULL,'QR generated','2024-03-20 15:40:17','3','generateqrsr'),
(332,NULL,'Lot Added','2024-03-20 15:40:34','3','dispatch'),
(333,NULL,'Single Print Had Taken','2024-03-21 10:35:18','3','generateqrsr'),
(334,NULL,'Single Print Had Taken','2024-03-21 10:36:08','3','generateqrsr'),
(335,NULL,'Single Print Had Taken','2024-03-21 10:36:42','3','generateqrsr'),
(336,NULL,'Single Print Had Taken','2024-03-21 10:37:34','3','generateqrsr'),
(337,NULL,'Single Print Had Taken','2024-03-21 10:39:09','3','generateqrsr'),
(338,NULL,'Single Print Had Taken','2024-03-21 10:39:38','3','generateqrsr'),
(339,NULL,'Single Print Had Taken','2024-03-21 10:40:43','3','generateqrsr'),
(340,NULL,'Single Print Had Taken','2024-03-21 10:41:14','3','generateqrsr'),
(341,NULL,'Single Print Had Taken','2024-03-21 10:42:07','3','generateqrsr'),
(342,NULL,'Single Print Had Taken','2024-03-21 10:42:53','3','generateqrsr'),
(343,NULL,'Single Print Had Taken','2024-03-21 10:44:16','3','generateqrsr'),
(344,NULL,'Single Print Had Taken','2024-03-21 10:44:40','3','generateqrsr'),
(345,NULL,'Single Print Had Taken','2024-03-21 10:45:05','3','generateqrsr'),
(346,NULL,'Single Print Had Taken','2024-03-21 10:45:58','3','generateqrsr'),
(347,NULL,'Single Print Had Taken','2024-03-21 10:47:15','3','generateqrsr'),
(348,NULL,'Single Print Had Taken','2024-03-21 10:48:25','3','generateqrsr'),
(349,NULL,'Single Print Had Taken','2024-03-21 10:50:14','3','generateqrsr'),
(350,NULL,'Single Print Had Taken','2024-03-21 10:50:57','3','generateqrsr'),
(351,NULL,'Single Print Had Taken','2024-03-21 10:51:36','3','generateqrsr'),
(352,NULL,'Single Print Had Taken','2024-03-21 10:52:06','3','generateqrsr'),
(353,NULL,'Single Print Had Taken','2024-03-21 10:52:35','3','generateqrsr'),
(354,NULL,'Single Print Had Taken','2024-03-21 10:53:03','3','generateqrsr'),
(355,NULL,'Single Print Had Taken','2024-03-21 10:54:11','3','generateqrsr'),
(356,NULL,'Single Print Had Taken','2024-03-21 10:54:36','3','generateqrsr'),
(357,NULL,'Single Print Had Taken','2024-03-21 10:55:06','3','generateqrsr'),
(358,NULL,'Single Print Had Taken','2024-03-21 10:55:35','3','generateqrsr'),
(359,NULL,'Single Print Had Taken','2024-03-21 10:56:13','3','generateqrsr'),
(360,NULL,'Single Print Had Taken','2024-03-21 10:56:37','3','generateqrsr'),
(361,NULL,'Lot Added','2024-03-21 11:15:23','3','dispatch'),
(362,NULL,'Single Print Had Taken','2024-03-21 11:26:09','3','generateqrsr'),
(363,NULL,'Single Print Had Taken','2024-03-21 11:26:33','3','generateqrsr'),
(364,NULL,'Single Print Had Taken','2024-03-21 11:27:18','3','generateqrsr'),
(365,NULL,'Single Print Had Taken','2024-03-21 11:28:26','3','generateqrsr'),
(366,NULL,'Single Print Had Taken','2024-03-21 11:34:25','3','generateqrsr'),
(367,NULL,'Single Print Had Taken','2024-03-21 11:36:52','3','generateqrsr'),
(368,NULL,'Single Print Had Taken','2024-03-21 11:43:17','3','generateqrsr'),
(369,NULL,'Single Print Had Taken','2024-03-21 11:43:45','3','generateqrsr'),
(370,NULL,'Single Print Had Taken','2024-03-21 11:45:42','3','generateqrsr'),
(371,NULL,'Single Print Had Taken','2024-03-21 11:49:14','3','generateqrsr'),
(372,NULL,'Single Print Had Taken','2024-03-21 11:50:03','3','generateqrsr'),
(373,NULL,'Single Print Had Taken','2024-03-21 11:50:45','3','generateqrsr'),
(374,NULL,'Single Print Had Taken','2024-03-21 11:51:09','3','generateqrsr'),
(375,NULL,'Single Print Had Taken','2024-03-21 11:52:42','3','generateqrsr'),
(376,NULL,'Single Print Had Taken','2024-03-21 11:53:03','3','generateqrsr'),
(377,NULL,'Single Print Had Taken','2024-03-21 11:53:28','3','generateqrsr'),
(378,NULL,'Single Print Had Taken','2024-03-21 11:53:48','3','generateqrsr'),
(379,NULL,'Single Print Had Taken','2024-03-21 11:54:45','3','generateqrsr'),
(380,NULL,'Single Print Had Taken','2024-03-21 11:55:40','3','generateqrsr'),
(381,NULL,'Single Print Had Taken','2024-03-21 11:56:03','3','generateqrsr'),
(382,NULL,'Single Print Had Taken','2024-03-21 11:57:26','3','generateqrsr'),
(383,NULL,'Single Print Had Taken','2024-03-21 11:57:50','3','generateqrsr'),
(384,NULL,'Single Print Had Taken','2024-03-21 11:58:02','3','generateqrsr'),
(385,NULL,'Single Print Had Taken','2024-03-21 11:58:31','3','generateqrsr'),
(386,NULL,'Single Print Had Taken','2024-03-21 11:59:09','3','generateqrsr'),
(387,NULL,'Single Print Had Taken','2024-03-21 11:59:44','3','generateqrsr'),
(388,NULL,'Single Print Had Taken','2024-03-21 12:01:02','3','generateqrsr'),
(389,NULL,'Single Print Had Taken','2024-03-21 12:02:37','3','generateqrsr'),
(390,NULL,'Single Print Had Taken','2024-03-21 12:05:47','3','generateqrsr'),
(391,NULL,'Single Print Had Taken','2024-03-21 12:07:32','3','generateqrsr'),
(392,NULL,'Single Print Had Taken','2024-03-21 12:08:16','3','generateqrsr'),
(393,NULL,'Single Print Had Taken','2024-03-21 12:09:28','3','generateqrsr'),
(394,NULL,'Single Print Had Taken','2024-03-21 12:11:30','3','generateqrsr'),
(395,NULL,'Single Print Had Taken','2024-03-21 12:13:25','3','generateqrsr'),
(396,NULL,'Single Print Had Taken','2024-03-21 12:13:30','3','generateqrsr'),
(397,NULL,'Single Print Had Taken','2024-03-21 12:13:30','3','generateqrsr'),
(398,NULL,'Single Print Had Taken','2024-03-21 12:17:28','3','generateqrsr'),
(399,NULL,'Single Print Had Taken','2024-03-21 12:18:20','3','generateqrsr'),
(400,NULL,'Single Print Had Taken','2024-03-21 12:19:11','3','generateqrsr'),
(401,NULL,'Single Print Had Taken','2024-03-21 12:20:02','3','generateqrsr'),
(402,NULL,'Single Print Had Taken','2024-03-21 12:20:45','3','generateqrsr'),
(403,NULL,'Single Print Had Taken','2024-03-21 12:23:23','3','generateqrsr'),
(404,NULL,'Single Print Had Taken','2024-03-21 12:24:06','3','generateqrsr'),
(405,NULL,'Single Print Had Taken','2024-03-21 12:26:21','3','generateqrsr'),
(406,NULL,'Single Print Had Taken','2024-03-21 12:27:45','3','generateqrsr'),
(407,NULL,'Single Print Had Taken','2024-03-21 12:33:56','3','generateqrsr'),
(408,NULL,'Alias Product Added','2024-03-21 14:53:38','3','Alias Product'),
(409,NULL,'Alias Product Added','2024-03-21 15:03:07','3','Alias Product'),
(410,NULL,'Single Print Had Taken','2024-03-21 16:15:01','3','generateqrsr'),
(411,NULL,'Single Print Had Taken','2024-03-21 16:16:26','3','generateqrsr'),
(412,NULL,'Single Print Had Taken','2024-03-21 16:17:50','3','generateqrsr'),
(413,NULL,'Single Print Had Taken','2024-03-21 16:18:27','3','generateqrsr'),
(414,NULL,'Single Print Had Taken','2024-03-21 16:19:11','3','generateqrsr'),
(415,NULL,'Single Print Had Taken','2024-03-21 16:19:43','3','generateqrsr'),
(416,NULL,'Single Print Had Taken','2024-03-21 16:20:20','3','generateqrsr'),
(417,NULL,'Single Print Had Taken','2024-03-21 16:20:42','3','generateqrsr'),
(418,NULL,'Single Print Had Taken','2024-03-21 16:21:24','3','generateqrsr'),
(419,NULL,'Single Print Had Taken','2024-03-21 16:21:57','3','generateqrsr'),
(420,NULL,'Single Print Had Taken','2024-03-21 16:22:57','3','generateqrsr'),
(421,NULL,'Single Print Had Taken','2024-03-21 16:23:37','3','generateqrsr'),
(422,NULL,'Single Print Had Taken','2024-03-21 16:24:46','3','generateqrsr'),
(423,NULL,'Single Print Had Taken','2024-03-22 14:29:02','3','generateqrsr'),
(424,NULL,'Single Print Had Taken','2024-03-22 14:29:12','3','generateqrsr'),
(425,NULL,'Multiple Print Had Taken','2024-03-22 14:29:23','3','generateqrsr'),
(426,NULL,'Single Print Had Taken','2024-03-22 16:04:23','3','generateqrsr'),
(427,NULL,'Single Print Had Taken','2024-03-23 11:22:52','3','generateqrsr'),
(428,NULL,'Multiple Print Had Taken','2024-03-23 11:23:00','3','generateqrsr'),
(429,NULL,'Single Print Had Taken','2024-03-23 11:23:45','3','generateqrsr'),
(430,NULL,'Multiple Print Had Taken','2024-03-23 11:24:14','3','generateqrsr'),
(431,NULL,'Multiple Print Had Taken','2024-03-23 11:24:36','3','generateqrsr'),
(432,NULL,'Single Print Had Taken','2024-03-23 11:25:16','3','generateqrsr'),
(433,NULL,'Single Print Had Taken','2024-03-23 11:25:59','3','generateqrsr'),
(434,NULL,'Single Print Had Taken','2024-03-23 11:26:55','3','generateqrsr'),
(435,NULL,'Single Print Had Taken','2024-03-23 11:28:11','3','generateqrsr'),
(436,NULL,'Single Print Had Taken','2024-03-23 11:29:01','3','generateqrsr'),
(437,NULL,'Single Print Had Taken','2024-03-23 11:32:00','3','generateqrsr'),
(438,NULL,'Single Print Had Taken','2024-03-23 11:32:38','3','generateqrsr'),
(439,NULL,'Single Print Had Taken','2024-03-23 11:33:25','3','generateqrsr'),
(440,NULL,'Single Print Had Taken','2024-03-23 11:34:43','3','generateqrsr'),
(441,NULL,'Single Print Had Taken','2024-03-23 11:35:46','3','generateqrsr'),
(442,NULL,'Single Print Had Taken','2024-03-23 11:39:42','3','generateqrsr'),
(443,NULL,'Single Print Had Taken','2024-03-23 11:41:37','3','generateqrsr'),
(444,NULL,'Single Print Had Taken','2024-03-23 12:17:39','3','generateqrsr'),
(445,NULL,'Multiple Print Had Taken','2024-03-23 12:22:39','3','generateqrsr'),
(446,NULL,'Single Print Had Taken','2024-03-24 12:02:44','3','generateqrsr'),
(447,NULL,'Single Print Had Taken','2024-03-25 15:06:42','3','generateqrsr'),
(448,NULL,'Single Print Had Taken','2024-03-25 15:09:15','3','generateqrsr'),
(449,NULL,'Single Print Had Taken','2024-03-25 15:10:42','3','generateqrsr'),
(450,NULL,'Single Print Had Taken','2024-03-25 15:12:44','3','generateqrsr'),
(451,NULL,'Single Print Had Taken','2024-03-25 15:13:10','3','generateqrsr'),
(452,NULL,'Single Print Had Taken','2024-03-25 15:13:35','3','generateqrsr'),
(453,NULL,'Single Print Had Taken','2024-03-25 15:13:56','3','generateqrsr'),
(454,NULL,'Single Print Had Taken','2024-03-25 15:14:16','3','generateqrsr'),
(455,NULL,'Single Print Had Taken','2024-03-25 15:14:36','3','generateqrsr'),
(456,NULL,'Single Print Had Taken','2024-03-25 15:14:57','3','generateqrsr'),
(457,NULL,'Single Print Had Taken','2024-03-25 15:16:13','3','generateqrsr'),
(458,NULL,'Single Print Had Taken','2024-03-25 15:16:36','3','generateqrsr'),
(459,NULL,'Alias Product Added','2024-03-25 15:22:33','3','Alias Product'),
(460,NULL,'Alias Product Edited','2024-03-25 15:22:39','3','Alias Product'),
(461,NULL,'Alias Product Updated','2024-03-25 15:22:43','3','Alias Product'),
(462,NULL,'Multiple Print Had Taken','2024-03-26 10:58:03','3','generateqrsr'),
(463,NULL,'Multiple Print Had Taken','2024-03-26 10:58:45','3','generateqrsr'),
(464,NULL,'Multiple Print Had Taken','2024-03-26 11:02:28','3','generateqrsr'),
(465,NULL,'Multiple Print Had Taken','2024-03-26 11:03:08','3','generateqrsr'),
(466,NULL,'Multiple Print Had Taken','2024-03-26 11:04:12','3','generateqrsr'),
(467,NULL,'Multiple Print Had Taken','2024-03-26 11:05:22','3','generateqrsr'),
(468,NULL,'Multiple Print Had Taken','2024-03-26 11:05:42','3','generateqrsr'),
(469,NULL,'Multiple Print Had Taken','2024-03-26 11:06:19','3','generateqrsr'),
(470,NULL,'Multiple Print Had Taken','2024-03-26 11:06:28','3','generateqrsr'),
(471,NULL,'Multiple Print Had Taken','2024-03-26 11:08:05','3','generateqrsr'),
(472,NULL,'Multiple Print Had Taken','2024-03-26 11:08:57','3','generateqrsr'),
(473,NULL,'Multiple Print Had Taken','2024-03-26 11:14:22','3','generateqrsr'),
(474,NULL,'Single Print Had Taken','2024-03-26 12:04:48','3','generateqrsr'),
(475,NULL,'Single Print Had Taken','2024-03-26 12:05:56','3','generateqrsr'),
(476,NULL,'Single Print Had Taken','2024-03-26 12:07:30','3','generateqrsr'),
(477,NULL,'Single Print Had Taken','2024-03-26 12:08:11','3','generateqrsr'),
(478,NULL,'Single Print Had Taken','2024-03-26 12:31:40','3','generateqrsr'),
(479,NULL,'Multiple Print Had Taken','2024-03-26 12:31:48','3','generateqrsr'),
(480,NULL,'Single Print Had Taken','2024-03-26 13:32:42','3','generateqrsr'),
(481,NULL,'Single Print Had Taken','2024-03-26 13:35:47','3','generateqrsr'),
(482,NULL,'Single Print Had Taken','2024-03-26 13:38:13','3','generateqrsr'),
(483,NULL,'Single Print Had Taken','2024-03-26 13:38:35','3','generateqrsr'),
(484,NULL,'Multiple Print Had Taken','2024-03-26 13:38:42','3','generateqrsr'),
(485,NULL,'Single Print Had Taken','2024-03-26 13:39:12','3','generateqrsr'),
(486,NULL,'Single Print Had Taken','2024-03-26 13:40:03','3','generateqrsr'),
(487,NULL,'Single Print Had Taken','2024-03-26 13:41:09','3','generateqrsr'),
(488,NULL,'Single Print Had Taken','2024-03-26 13:41:50','3','generateqrsr'),
(489,NULL,'Single Print Had Taken','2024-03-26 13:43:52','3','generateqrsr'),
(490,NULL,'Single Print Had Taken','2024-03-26 13:44:45','3','generateqrsr'),
(491,NULL,'Single Print Had Taken','2024-03-26 15:21:46','3','generateqrsr'),
(492,NULL,'Single Print Had Taken','2024-03-26 15:22:56','3','generateqrsr'),
(493,NULL,'Single Print Had Taken','2024-03-26 15:24:07','3','generateqrsr'),
(494,NULL,'Single Print Had Taken','2024-03-26 15:25:00','3','generateqrsr'),
(495,NULL,'Single Print Had Taken','2024-03-26 15:25:47','3','generateqrsr'),
(496,NULL,'Single Print Had Taken','2024-03-27 11:11:50','3','generateqrsr'),
(497,NULL,'Multiple Print Had Taken','2024-03-27 11:12:16','3','generateqrsr'),
(498,NULL,'Multiple Print Had Taken','2024-03-27 11:13:15','3','generateqrsr'),
(499,NULL,'Single Print Had Taken','2024-03-27 11:21:40','3','generateqrsr'),
(500,NULL,'Single Print Had Taken','2024-03-27 11:29:52','3','generateqrsr'),
(501,NULL,'Single Print Had Taken','2024-03-27 11:38:46','3','generateqrsr'),
(502,NULL,'Single Print Had Taken','2024-03-27 11:41:04','3','generateqrsr'),
(503,NULL,'Single Print Had Taken','2024-03-27 11:43:03','3','generateqrsr'),
(504,NULL,'New Product Added','2024-03-27 11:45:06','3','Product'),
(505,NULL,'Batch Added','2024-03-27 11:48:59','3','Batch'),
(506,NULL,'Alias Product Added','2024-03-27 11:49:21','3','Alias Product'),
(507,NULL,'QR generated','2024-03-27 11:50:06','3','Generateqr'),
(508,NULL,'Single Print Had Taken','2024-03-27 11:50:14','3','generateqrsr'),
(509,NULL,'Single Print Had Taken','2024-03-27 11:52:03','3','generateqrsr'),
(510,NULL,'Single Print Had Taken','2024-03-27 11:52:32','3','generateqrsr'),
(511,NULL,'Single Print Had Taken','2024-03-27 11:55:20','3','generateqrsr'),
(512,NULL,'Single Print Had Taken','2024-03-27 11:57:02','3','generateqrsr'),
(513,NULL,'Single Print Had Taken','2024-03-27 11:57:42','3','generateqrsr'),
(514,NULL,'Single Print Had Taken','2024-03-27 11:58:04','3','generateqrsr'),
(515,NULL,'Single Print Had Taken','2024-03-27 11:58:50','3','generateqrsr'),
(516,NULL,'Single Print Had Taken','2024-03-27 11:59:20','3','generateqrsr'),
(517,NULL,'Single Print Had Taken','2024-03-27 11:59:49','3','generateqrsr'),
(518,NULL,'Single Print Had Taken','2024-03-27 12:00:47','3','generateqrsr'),
(519,NULL,'Single Print Had Taken','2024-03-27 12:01:08','3','generateqrsr'),
(520,NULL,'Single Print Had Taken','2024-03-27 12:01:59','3','generateqrsr'),
(521,NULL,'Multiple Print Had Taken','2024-03-27 12:03:06','3','generateqrsr'),
(522,NULL,'Multiple Print Had Taken','2024-03-27 12:28:06','3','generateqrsr'),
(523,NULL,'Single Print Had Taken','2024-03-27 12:28:17','3','generateqrsr'),
(524,NULL,'User Data And Rights Updated','2024-03-27 12:37:42','3','userm'),
(525,NULL,'User Data And Rights Updated','2024-03-27 12:44:53','3','userm'),
(526,NULL,'User Data And Rights Updated','2024-03-27 12:46:00','3','userm'),
(527,NULL,'User Deleted','2024-03-27 15:00:22','3','userm'),
(528,NULL,'User Deleted','2024-03-27 15:27:40','3','userm'),
(529,NULL,'User Deleted','2024-03-28 11:25:44','3','userm'),
(530,NULL,'QR generated','2024-03-29 12:15:54','3','Generateqr'),
(531,NULL,'QR generated','2024-03-29 12:20:05','3','Generateqr'),
(532,NULL,'Single Print Had Taken','2024-03-29 12:20:24','3','generateqrsr'),
(533,NULL,'QR generated','2024-03-29 12:21:40','3','Generateqr'),
(534,NULL,'Single Print Had Taken','2024-03-29 12:22:06','3','generateqrsr'),
(535,NULL,'Multiple Print Had Taken','2024-03-29 12:22:34','3','generateqrsr'),
(536,NULL,'Single Print Had Taken','2024-03-29 16:07:07','3','generateqrsr'),
(537,NULL,'Single Print Had Taken','2024-03-29 16:13:05','3','generateqrsr'),
(538,NULL,'Multiple Print Had Taken','2024-03-29 16:13:21','3','generateqrsr'),
(539,NULL,'Single Print Had Taken','2024-03-29 16:29:41','3','generateqrsr'),
(540,NULL,'Single Print Had Taken','2024-04-01 13:18:38','3','generateqrsr'),
(541,NULL,'Multiple Print Had Taken','2024-04-01 13:18:53','3','generateqrsr'),
(542,NULL,'Multiple Print Had Taken','2024-04-01 13:32:36','3','generateqrsr'),
(543,NULL,'Single Print Had Taken','2024-04-01 13:36:53','3','generateqrsr'),
(544,NULL,'Multiple Print Had Taken','2024-04-01 13:47:48','3','generateqrsr'),
(545,NULL,'Alias Product Added','2024-04-02 16:27:26','3','Alias Product'),
(546,NULL,'Alias Product Added','2024-04-03 11:43:36','3','Alias Product'),
(547,NULL,'Alias Product Added','2024-04-03 11:51:58','3','Alias Product'),
(548,NULL,'Alias Product Added','2024-04-03 11:58:57','3','Alias Product'),
(549,NULL,'Alias Product Added','2024-04-03 11:59:47','3','Alias Product'),
(550,NULL,'Alias Product Added','2024-04-03 13:23:50','3','Alias Product'),
(551,NULL,'Alias Product Added','2024-04-03 13:24:59','3','Alias Product'),
(552,NULL,'New Company Added','2024-04-03 13:30:47','3','Company Unit'),
(553,NULL,'New Product Added','2024-04-03 14:11:10','3','Product'),
(554,NULL,'Batch Added','2024-04-03 14:12:07','3','Batch'),
(555,NULL,'Customer Added','2024-04-03 14:13:02','3','Customer'),
(556,NULL,'Single Print Had Taken','2024-04-03 14:22:27','3','generateqrsr'),
(557,NULL,'Multiple Print Had Taken','2024-04-03 14:22:33','3','generateqrsr'),
(558,NULL,'Alias Product Added','2024-04-03 14:23:14','3','Alias Product'),
(559,NULL,'QR generated','2024-04-03 14:23:52','3','Generateqr'),
(560,NULL,'Single Print Had Taken','2024-04-03 14:24:05','3','generateqrsr'),
(561,NULL,'Multiple Print Had Taken','2024-04-03 14:24:23','3','generateqrsr'),
(562,NULL,'Single Print Had Taken','2024-04-03 14:24:34','3','generateqrsr'),
(563,NULL,'Alias Product Added','2024-04-03 16:31:19','3','Alias Product'),
(564,NULL,'Alias Product Added','2024-04-03 17:05:05','3','Alias Product'),
(565,NULL,'Alias Product Added','2024-04-03 17:11:28','3','Alias Product'),
(566,NULL,'New Company Added','2024-04-04 12:33:49','3','Company Unit'),
(567,NULL,'Customer Added','2024-04-04 12:36:42','3','Customer'),
(568,NULL,'Customer Added','2024-04-04 12:40:18','3','Customer'),
(569,NULL,'Customer Deleted','2024-04-04 12:41:33','3','Customer'),
(570,NULL,'Product Updated','2024-04-05 15:42:51','3','Product'),
(571,NULL,'QR generated','2024-04-08 12:03:14','3','Generateqr'),
(572,NULL,'Customer Added','2024-04-08 12:10:04','3','Customer'),
(573,NULL,'Company Deleted','2024-04-08 15:02:31','3','Company Unit'),
(574,NULL,'Company Deleted','2024-04-08 15:02:35','3','Company Unit'),
(575,NULL,'Company Deleted','2024-04-08 15:02:39','3','Company Unit'),
(576,NULL,'Company Deleted','2024-04-08 15:02:43','3','Company Unit'),
(577,NULL,'Company Deleted','2024-04-08 15:02:47','3','Company Unit'),
(578,NULL,'Company Deleted','2024-04-08 15:02:51','3','Company Unit'),
(579,NULL,'Company Deleted','2024-04-08 15:02:55','3','Company Unit'),
(580,NULL,'Company Deleted','2024-04-08 15:02:58','3','Company Unit'),
(581,NULL,'New Company Added','2024-04-08 15:03:43','3','Company Unit'),
(582,NULL,'Company Deleted','2024-04-08 15:06:43','3','Company Unit'),
(583,NULL,'New Company Added','2024-04-08 15:07:29','3','Company Unit'),
(584,NULL,'Company Deleted','2024-04-08 15:13:55','3','Company Unit'),
(585,NULL,'New Company Added','2024-04-08 15:17:14','3','Company Unit'),
(586,NULL,'Company Deleted','2024-04-08 15:26:36','3','Company Unit'),
(587,NULL,'New Company Added','2024-04-08 15:27:21','3','Company Unit'),
(588,NULL,'New Product Added','2024-04-08 15:28:49','3','Product'),
(589,NULL,'Product Deleted','2024-04-08 15:30:31','3','Product'),
(590,NULL,'New Product Added','2024-04-08 15:34:05','3','Product'),
(591,NULL,'Batch Added','2024-04-08 15:36:20','3','Batch'),
(592,NULL,'Customer Added','2024-04-08 15:37:32','3','Customer'),
(593,NULL,'Alias Product Added','2024-04-08 15:38:01','3','Alias Product'),
(594,NULL,'New Product Added','2024-04-08 15:39:17','3','Product'),
(595,NULL,'New Product Added','2024-04-09 14:24:46','3','Product'),
(596,NULL,'New Company Added','2024-04-10 12:16:06','26','Company Unit'),
(597,NULL,'New Product Added','2024-04-10 12:17:41','3','Product'),
(598,NULL,'New Product Added','2024-04-10 12:21:22','26','Product'),
(599,NULL,'Batch Added','2024-04-10 13:26:50','27','Batch'),
(600,NULL,'Customer Added','2024-04-10 13:28:19','27','Customer'),
(601,NULL,'Alias Product Added','2024-04-10 13:28:34','27','Alias Product'),
(602,NULL,'New Company Added','2024-04-10 15:11:12','28','Company Unit'),
(603,NULL,'New Product Added','2024-04-10 15:12:10','28','Product'),
(604,NULL,'Batch Added','2024-04-10 15:14:17','28','Batch'),
(605,NULL,'Customer Added','2024-04-10 15:15:03','28','Customer'),
(606,NULL,'Alias Product Added','2024-04-10 15:15:22','28','Alias Product'),
(607,NULL,'Single Print Had Taken','2024-04-10 15:39:47','3','generateqrsr'),
(608,NULL,'Batch Added','2024-04-12 16:06:27','3','Batch'),
(609,NULL,'QR generated','2024-04-12 16:11:14','3','Generateqr'),
(610,NULL,'New Product Added','2024-04-12 17:55:42','3','Product'),
(611,NULL,'Alias Product Added','2024-04-12 17:59:36','3','Alias Product'),
(612,NULL,'Batch Added','2024-04-12 18:11:08','3','Batch'),
(613,NULL,'New Product Added','2024-04-14 15:12:35','3','Product'),
(614,NULL,'New Product Added','2024-04-14 15:34:21','3','Product'),
(615,NULL,'New Product Added','2024-04-14 15:37:00','3','Product'),
(616,NULL,'New Product Added','2024-04-14 16:40:55','3','Product'),
(617,NULL,'New Product Added','2024-04-14 16:45:51','3','Product'),
(618,NULL,'New Product Added','2024-04-14 16:52:15','3','Product'),
(619,NULL,'New Company Added','2024-04-14 16:55:14','29','Company Unit'),
(620,NULL,'New Product Added','2024-04-14 16:56:05','29','Product'),
(621,NULL,'Batch Added','2024-04-14 17:00:11','29','Batch'),
(622,NULL,'Alias Product Added','2024-04-14 17:05:41','3','Alias Product'),
(623,NULL,'New Product Added','2024-04-15 11:02:59','30','Product'),
(624,NULL,'Product Deleted','2024-04-15 14:54:13','3','Product'),
(625,NULL,'Product Deleted','2024-04-15 14:54:17','3','Product'),
(626,NULL,'Batch Added','2024-04-16 12:28:00','3','Batch'),
(627,NULL,'Batch Added','2024-04-16 12:30:59','30','Batch'),
(628,NULL,'Alias Product Added','2024-04-16 12:32:07','30','Alias Product'),
(629,NULL,'QR generated','2024-04-16 13:09:20','3','Generateqr'),
(630,NULL,'QR generated','2024-04-16 13:10:07','3','Generateqr'),
(631,NULL,'Batch Updated','2024-04-16 15:28:03','3','Batch'),
(632,NULL,'Batch Updated','2024-04-16 15:28:44','3','Batch'),
(633,NULL,'QR generated','2024-04-16 17:50:10','3','Generateqr'),
(634,NULL,'QR generated','2024-04-16 17:54:43','3','Generateqr'),
(635,NULL,'New Company Added','2024-04-16 18:09:59','3','Company Unit'),
(636,NULL,'New Product Added','2024-04-16 18:11:09','3','Product'),
(637,NULL,'New Company Added','2024-04-16 18:22:25','11','Company Unit'),
(638,NULL,'New Product Added','2024-04-16 18:23:31','11','Product'),
(639,NULL,'Batch Added','2024-04-16 18:24:15','11','Batch'),
(640,NULL,'Alias Product Added','2024-04-16 18:24:44','11','Alias Product'),
(641,NULL,'QR generated','2024-04-16 18:25:26','11','Generateqr'),
(642,NULL,'QR generated','2024-04-16 18:27:34','11','Generateqr'),
(643,NULL,'New Company Added','2024-04-17 13:07:54','28','Company Unit'),
(644,NULL,'New Company Added','2024-04-17 13:28:09','11','Company Unit'),
(645,NULL,'New User Added','2024-04-22 16:27:34','11','userm'),
(646,NULL,'Alias Product Edited','2024-04-30 10:52:56','11','Alias Product'),
(647,NULL,'Alias Product Edited','2024-04-30 14:54:48','34','Alias Product'),
(648,NULL,'Alias Product Updated','2024-04-30 14:55:02','34','Alias Product'),
(649,NULL,'Alias Product Edited','2024-04-30 14:55:53','34','Alias Product'),
(650,NULL,'Alias Product Updated','2024-04-30 14:55:59','34','Alias Product'),
(651,NULL,'Alias Product Edited','2024-04-30 14:56:48','34','Alias Product'),
(652,NULL,'Alias Product Updated','2024-04-30 14:56:52','34','Alias Product'),
(653,NULL,'Alias Product Edited','2024-04-30 15:00:43','34','Alias Product'),
(654,NULL,'Alias Product Updated','2024-04-30 15:00:46','34','Alias Product'),
(655,NULL,'Alias Product Edited','2024-04-30 15:00:50','34','Alias Product'),
(656,NULL,'Alias Product Updated','2024-04-30 15:00:54','34','Alias Product'),
(657,NULL,'Alias Product Edited','2024-04-30 15:07:58','34','Alias Product'),
(658,NULL,'Alias Product Updated','2024-04-30 15:08:09','34','Alias Product'),
(659,NULL,'Company Updated','2024-04-30 15:43:23','34','Company Unit'),
(660,NULL,'Company Updated','2024-04-30 15:44:49','34','Company Unit'),
(661,NULL,'Company Updated','2024-04-30 15:45:58','34','Company Unit'),
(662,NULL,'Company Updated','2024-04-30 15:49:12','34','Company Unit'),
(663,NULL,'Product Updated','2024-04-30 15:55:35','34','Product'),
(664,NULL,'Batch Updated','2024-04-30 16:01:11','34','Batch'),
(665,NULL,'Batch Updated','2024-04-30 16:01:59','34','Batch'),
(666,NULL,'Batch Updated','2024-04-30 16:02:51','34','Batch'),
(667,NULL,'Batch Updated','2024-04-30 16:03:41','34','Batch'),
(668,NULL,'Batch Updated','2024-04-30 16:04:11','34','Batch'),
(669,NULL,'Customer Updated','2024-04-30 16:12:53','34','Customer'),
(670,NULL,'Customer Deleted','2024-04-30 17:29:47','34','Customer'),
(671,NULL,'Alias Product Edited','2024-04-30 18:34:06','34','Alias Product'),
(672,NULL,'Alias Product Updated','2024-04-30 18:34:11','34','Alias Product'),
(673,NULL,'New Company Added','2024-05-01 12:12:18','34','Company Unit'),
(674,NULL,'New Company Added','2024-05-01 12:16:07','34','Company Unit'),
(675,NULL,'Company Deleted','2024-05-01 12:28:45','34','Company Unit'),
(676,NULL,'Company Deleted','2024-05-01 12:29:21','34','Company Unit'),
(677,NULL,'New Company Added','2024-05-01 12:29:45','34','Company Unit'),
(678,NULL,'Company Deleted','2024-05-01 12:30:19','34','Company Unit'),
(679,NULL,'Company Deleted','2024-05-01 12:40:20','34','Company Unit'),
(680,NULL,'Company Deleted','2024-05-01 12:40:26','34','Company Unit'),
(681,NULL,'Product Deleted','2024-05-01 13:12:15','34','Product'),
(682,NULL,'Product Deleted','2024-05-01 13:13:52','34','Product'),
(683,NULL,'Batch Data Deleted','2024-05-01 13:26:47','34','Batch'),
(684,NULL,'Batch Data Deleted','2024-05-01 13:27:35','34','Batch'),
(685,NULL,'Customer Deleted','2024-05-01 14:19:01','34','Customer'),
(686,NULL,'Customer Added','2024-05-01 14:23:23','34','Customer'),
(687,NULL,'Customer Deleted','2024-05-01 14:23:49','34','Customer'),
(688,NULL,'Company Deleted','2024-05-01 16:28:48','34','Company Unit'),
(689,NULL,'Alias Product Added','2024-05-01 16:33:53','35','Alias Product'),
(690,NULL,'Alias Product Edited','2024-05-01 16:35:50','35','Alias Product'),
(691,NULL,'Alias Product Updated','2024-05-01 16:35:56','35','Alias Product'),
(692,NULL,'Lot Added','2024-05-10 10:54:00','34','Dispatch'),
(693,NULL,'Lot Added','2024-05-10 11:29:40','34','Dispatch'),
(694,NULL,'Lot Added','2024-05-10 11:40:03','34','Dispatch'),
(695,NULL,'Lot Added','2024-05-10 12:35:47','34','Dispatch'),
(696,NULL,'Lot Added','2024-05-10 13:03:02','34','Dispatch'),
(697,NULL,'Lot Added','2024-05-10 13:05:31','34','Dispatch'),
(698,NULL,'Single Print Had Taken','2024-05-13 16:57:50','34','generateqrsr'),
(699,NULL,'Lot Data Updated','2024-05-13 17:46:44','34','Dispatch'),
(700,NULL,'Lot Added','2024-05-13 17:46:45','34','Dispatch'),
(701,NULL,'Lot Data Updated','2024-05-13 17:50:29','34','Dispatch'),
(702,NULL,'Lot Added','2024-05-13 17:50:29','34','Dispatch'),
(703,NULL,'Lot Data Updated','2024-05-13 17:54:08','34','Dispatch'),
(704,NULL,'Lot Data Updated','2024-05-13 17:57:32','34','Dispatch'),
(705,NULL,'Lot Data Updated','2024-05-13 18:00:21','34','Dispatch'),
(706,NULL,'Lot Data Updated','2024-05-13 18:02:51','34','Dispatch'),
(707,NULL,'Lot Added','2024-05-13 18:11:31','34','Dispatch'),
(708,NULL,'Lot Data Updated','2024-05-13 18:18:27','34','Dispatch'),
(709,NULL,'Lot Data Updated','2024-05-13 18:22:14','34','Dispatch'),
(710,NULL,'Lot Deleted','2024-05-13 18:22:46','34','Dispatch'),
(711,NULL,'Lot Deleted','2024-05-13 18:37:04','34','Dispatch'),
(712,NULL,'QR generated','2024-05-14 15:36:19','34','Generateqr');
/*!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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=40 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`) VALUES
(22,'LAXACHEM ORGANICS PVT. LTD.','LAXACHEM ORGANICS PVT. LTD.','(25) AMD/3/96','GTIN1000','Plot No. D-2, MIDC',NULL,'AMRAVATI-444607. (Maharashtra) INDIA',NULL,NULL,'3','0'),
(29,'WebMedia India','WebMedia','DGWEB','GTINWEB','Railway Station',NULL,'Amravati','2024-04-08 15:27:22',NULL,NULL,'0'),
(30,'ZapsTravel','Zaps','DGZT1230','GTIN1001','Hyderabad',NULL,'Hyderabad','2024-04-10 12:16:06',NULL,'3','0'),
(31,'WEB MEDIA INDIA 2','Web Media','DGWB','GTINWB','Railway Station ',NULL,'Amravati','2024-04-10 15:11:12',NULL,NULL,'0'),
(32,'Zeeshan Co Ltd','Zeeshan Ltd','DGAMTZC','123654987','Amravati',NULL,'Amravati','2024-04-14 16:55:14',NULL,'29','0'),
(33,'Web Media Amravati Ltd','Web Media Amravati Ltd','GDWEB1122','333333','Railway Station',NULL,'Amravati','2024-04-16 18:10:00',NULL,'3','0'),
(34,'Web Media India Ltd','Web Media India Ltd','GDWEB12','555555','Railway Station 13',NULL,'Railway Station 13','2024-04-16 18:22:25','2024-04-30 15:49:12','11','0'),
(35,'ABC','ABC','DG','43334','XYZ',NULL,'ZXY','2024-04-17 13:07:54',NULL,'28','-1'),
(36,'A','E','D','F','B',NULL,'C','2024-04-17 13:28:09',NULL,'11','-1'),
(37,'ASDF','FFGF','SDF','dDDd','SDF',NULL,'DFG','2024-05-01 12:12:19',NULL,'34','-1'),
(38,'RTR','RT','DFG','FGG','REE',NULL,'RRE','2024-05-01 12:16:07',NULL,'34','-1'),
(39,'asdf','fdgdfgf','dfgdf','fdgdf','dsdfg',NULL,'dfgfd','2024-05-01 12:29:46',NULL,'34','-1');
/*!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',
  `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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=233 DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table pagemaster
-- 

/*!40000 ALTER TABLE `pagemaster` DISABLE KEYS */;
INSERT INTO `pagemaster`(`id`,`roleid`,`pageid`,`pagename`,`status`,`createdat`,`approvedat`,`rejremark`,`rejectedat`,`itemname`,`purpose`,`deletestatus`) VALUES
(1,'3','32','addproduct','1','2024-04-03 11:59:47',NULL,NULL,NULL,NULL,NULL,NULL),
(2,'11','32','addproduct','1','2024-04-03 11:59:47',NULL,NULL,NULL,NULL,NULL,NULL),
(3,'3','38','addproduct','1','2024-04-03 13:23:50',NULL,NULL,NULL,NULL,NULL,NULL),
(4,'11','38','addproduct','1','2024-04-03 13:23:50',NULL,NULL,NULL,NULL,NULL,NULL),
(5,'4','38','addproduct','1','2024-04-03 13:23:50',NULL,NULL,NULL,NULL,NULL,NULL),
(6,'17','38','addproduct','1','2024-04-03 13:23:51',NULL,NULL,NULL,NULL,NULL,NULL),
(7,'21','38','addproduct','1','2024-04-03 13:23:51',NULL,NULL,NULL,NULL,NULL,NULL),
(8,'3','39','addproduct','1','2024-04-03 13:24:59',NULL,'Quality i not upto the mark',NULL,NULL,NULL,NULL),
(9,'11','39','addproduct','1','2024-04-03 13:24:59',NULL,NULL,NULL,NULL,NULL,NULL),
(10,'4','39','addproduct','1','2024-04-03 13:24:59',NULL,NULL,NULL,NULL,NULL,NULL),
(11,'17','39','addproduct','1','2024-04-03 13:24:59',NULL,NULL,NULL,NULL,NULL,NULL),
(12,'21','39','addproduct','1','2024-04-03 13:24:59',NULL,NULL,NULL,NULL,NULL,NULL),
(13,'','24','addproduct','1','2024-04-03 13:30:47',NULL,NULL,NULL,NULL,NULL,NULL),
(14,'','24','addproduct','1','2024-04-03 13:30:47',NULL,NULL,NULL,NULL,NULL,NULL),
(15,'','24','addproduct','1','2024-04-03 13:30:47',NULL,NULL,NULL,NULL,NULL,NULL),
(16,'3','24','product','-1','2024-04-03 14:11:11','2024-04-08 14:51:30','Not Available','2024-04-08 14:59:25',NULL,NULL,NULL),
(17,'11','24','product','1','2024-04-03 14:11:11',NULL,NULL,NULL,NULL,NULL,NULL),
(18,'4','24','product','1','2024-04-03 14:11:11',NULL,NULL,NULL,NULL,NULL,NULL),
(19,'17','24','product','1','2024-04-03 14:11:11',NULL,NULL,NULL,NULL,NULL,NULL),
(20,'21','24','product','1','2024-04-03 14:11:11',NULL,NULL,NULL,NULL,NULL,NULL),
(21,'','37','pbatch','1','2024-04-03 14:12:07',NULL,NULL,NULL,NULL,NULL,NULL),
(22,'','37','pbatch','0','2024-04-03 14:12:07',NULL,NULL,NULL,NULL,NULL,NULL),
(23,'17','37','pbatch','0','2024-04-03 14:12:07',NULL,NULL,NULL,NULL,NULL,NULL),
(24,'21','37','pbatch','0','2024-04-03 14:12:07',NULL,NULL,NULL,NULL,NULL,NULL),
(25,'','19','customer','1','2024-04-03 14:13:03',NULL,NULL,NULL,NULL,NULL,NULL),
(26,'','19','customer','0','2024-04-03 14:13:03',NULL,NULL,NULL,NULL,NULL,NULL),
(27,'','19','customer','0','2024-04-03 14:13:03',NULL,NULL,NULL,NULL,NULL,NULL),
(28,'3','40','addproduct','1','2024-04-03 14:23:14','2024-04-08 14:53:27',NULL,NULL,NULL,NULL,NULL),
(29,'11','40','addproduct','1','2024-04-03 14:23:14',NULL,NULL,NULL,NULL,NULL,NULL),
(30,'4','40','addproduct','1','2024-04-03 14:23:14',NULL,NULL,NULL,NULL,NULL,NULL),
(31,'17','40','addproduct','0','2024-04-03 14:23:14',NULL,NULL,NULL,NULL,NULL,NULL),
(32,'21','40','addproduct','1','2024-04-03 14:23:14',NULL,NULL,NULL,NULL,NULL,NULL),
(33,'','42','addproduct','1','2024-04-03 16:31:19',NULL,NULL,NULL,NULL,NULL,NULL),
(34,'','42','addproduct','1','2024-04-03 16:31:19',NULL,NULL,NULL,NULL,NULL,NULL),
(35,'','42','addproduct','1','2024-04-03 16:31:19',NULL,NULL,NULL,NULL,NULL,NULL),
(36,'','43','addproduct','1','2024-04-03 17:05:05',NULL,NULL,NULL,NULL,NULL,NULL),
(37,'','43','addproduct','1','2024-04-03 17:05:05',NULL,NULL,NULL,NULL,NULL,NULL),
(38,'','43','addproduct','1','2024-04-03 17:05:05',NULL,NULL,NULL,NULL,NULL,NULL),
(39,'1','44','addproduct','1','2024-04-03 17:10:21',NULL,NULL,NULL,NULL,NULL,NULL),
(40,'2','44','addproduct','1','2024-04-03 17:10:36',NULL,NULL,NULL,NULL,NULL,NULL),
(41,'1','44','addproduct','1','2024-04-03 17:10:53',NULL,NULL,NULL,NULL,NULL,NULL),
(42,'2','44','addproduct','1','2024-04-03 17:10:59',NULL,NULL,NULL,NULL,NULL,NULL),
(43,'2','44','addproduct','1','2024-04-03 17:11:14',NULL,NULL,NULL,NULL,NULL,NULL),
(44,'1','25','manufacture','1','2024-04-04 12:33:49',NULL,'',NULL,NULL,NULL,NULL),
(45,'2','25','manufacture','0','2024-04-04 12:33:49',NULL,NULL,NULL,NULL,NULL,NULL),
(46,'1','25','manufacture','0','2024-04-04 12:33:49',NULL,'',NULL,NULL,NULL,NULL),
(47,'2','25','manufacture','0','2024-04-04 12:33:49',NULL,NULL,NULL,NULL,NULL,NULL),
(48,'2','25','manufacture','0','2024-04-04 12:33:49',NULL,NULL,NULL,NULL,NULL,NULL),
(52,'','21','customer','1','2024-04-04 12:40:18',NULL,NULL,NULL,NULL,NULL,NULL),
(53,'','21','customer','0','2024-04-04 12:40:18',NULL,NULL,NULL,NULL,NULL,NULL),
(54,'','21','customer','0','2024-04-04 12:40:18',NULL,NULL,NULL,NULL,NULL,NULL),
(55,'','42','generateqr','1','2024-04-08 12:03:14',NULL,NULL,NULL,'LAX/0424/042',NULL,NULL),
(56,'','42','generateqr','0','2024-04-08 12:03:14',NULL,NULL,NULL,'LAX/0424/042',NULL,NULL),
(57,'','42','generateqr','0','2024-04-08 12:03:14',NULL,NULL,NULL,'LAX/0424/042',NULL,NULL),
(58,'11','22','customer','1','2024-04-08 12:08:50','2024-04-08 14:35:54',NULL,NULL,'Sahl Khan',NULL,NULL),
(59,'4','22','customer','0','2024-04-08 12:09:42',NULL,NULL,NULL,'Sahl Khan',NULL,NULL),
(60,'17','22','customer','0','2024-04-08 12:09:52',NULL,NULL,NULL,'Sahl Khan',NULL,NULL),
(64,'','27','manufacture','1','2024-04-08 15:07:30',NULL,NULL,NULL,'WebMedia India',NULL,NULL),
(65,'','27','manufacture','0','2024-04-08 15:07:30',NULL,NULL,NULL,'WebMedia India',NULL,NULL),
(66,'','27','manufacture','0','2024-04-08 15:07:30',NULL,NULL,NULL,'WebMedia India',NULL,NULL),
(67,'3','28','manufacture','1','2024-04-08 15:16:30','2024-04-08 15:17:52',NULL,NULL,'WebMedia India',NULL,NULL),
(68,'24','28','manufacture','0','2024-04-08 15:17:07',NULL,NULL,NULL,'WebMedia India',NULL,NULL),
(69,'17','28','manufacture','0','2024-04-08 15:17:10',NULL,NULL,NULL,'WebMedia India',NULL,NULL),
(70,'3','29','manufacture','1','2024-04-08 15:27:22',NULL,NULL,NULL,'WebMedia India',NULL,NULL),
(71,'24','29','manufacture','0','2024-04-08 15:27:22',NULL,NULL,NULL,'WebMedia India',NULL,NULL),
(72,'17','29','manufacture','0','2024-04-08 15:27:22',NULL,NULL,NULL,'WebMedia India',NULL,NULL),
(73,'','25','product','1','2024-04-08 15:28:49',NULL,NULL,NULL,'LaxacemProject',NULL,NULL),
(74,'','25','product','0','2024-04-08 15:28:49',NULL,NULL,NULL,'LaxacemProject',NULL,NULL),
(75,'','25','product','0','2024-04-08 15:28:49',NULL,NULL,NULL,'LaxacemProject',NULL,NULL),
(76,'3','26','product','1','2024-04-08 15:31:47',NULL,NULL,NULL,'LaxachemProject',NULL,NULL),
(77,'3','26','product','0','2024-04-08 15:32:53',NULL,NULL,NULL,'LaxachemProject',NULL,NULL),
(78,'','26','product','0','2024-04-08 15:33:45',NULL,NULL,NULL,'LaxachemProject',NULL,NULL),
(79,'','26','product','0','2024-04-08 15:33:59',NULL,NULL,NULL,'LaxachemProject',NULL,NULL),
(80,'3','38','pbatch','1','2024-04-08 15:36:20',NULL,NULL,NULL,'LAXAP01',NULL,NULL),
(81,'','38','pbatch','0','2024-04-08 15:36:20',NULL,NULL,NULL,'LAXAP01',NULL,NULL),
(82,'','38','pbatch','0','2024-04-08 15:36:20',NULL,NULL,NULL,'LAXAP01',NULL,NULL),
(83,'3','23','customer','1','2024-04-08 15:37:33',NULL,NULL,NULL,'Pratik Mohod',NULL,NULL),
(84,'','23','customer','0','2024-04-08 15:37:33',NULL,NULL,NULL,'Pratik Mohod',NULL,NULL),
(85,'','23','customer','0','2024-04-08 15:37:33',NULL,NULL,NULL,'Pratik Mohod',NULL,NULL),
(86,'3','45','addproduct','1','2024-04-08 15:38:02',NULL,NULL,NULL,'laxapro',NULL,NULL),
(87,'','45','addproduct','1','2024-04-08 15:38:02',NULL,NULL,NULL,'laxapro',NULL,NULL),
(88,'','45','addproduct','1','2024-04-08 15:38:02',NULL,NULL,NULL,'laxapro',NULL,NULL),
(89,'3','27','product','1','2024-04-08 15:39:17',NULL,NULL,NULL,'CofeeSofil',NULL,NULL),
(90,'3','27','product','0','2024-04-08 15:39:17',NULL,NULL,NULL,'CofeeSofil',NULL,NULL),
(91,'','27','product','0','2024-04-08 15:39:17',NULL,NULL,NULL,'CofeeSofil',NULL,NULL),
(92,'','27','product','0','2024-04-08 15:39:17',NULL,NULL,NULL,'CofeeSofil',NULL,NULL),
(93,'','28','product','1','2024-04-09 14:24:47',NULL,NULL,NULL,'Keyboard',NULL,NULL),
(94,'','28','product','0','2024-04-09 14:24:47',NULL,NULL,NULL,'Keyboard',NULL,NULL),
(95,'','28','product','0','2024-04-09 14:24:47',NULL,NULL,NULL,'Keyboard',NULL,NULL),
(96,'3','30','manufacture','1','2024-04-10 12:16:06','2024-04-10 13:25:55',NULL,NULL,'ZapsTravel',NULL,NULL),
(97,'','30','manufacture','0','2024-04-10 12:16:06',NULL,NULL,NULL,'ZapsTravel',NULL,NULL),
(98,'','30','manufacture','0','2024-04-10 12:16:06',NULL,NULL,NULL,'ZapsTravel',NULL,NULL),
(99,'','29','product','0','2024-04-10 12:17:41',NULL,NULL,NULL,'TravelBus',NULL,NULL),
(100,'','29','product','0','2024-04-10 12:17:41',NULL,NULL,NULL,'TravelBus',NULL,NULL),
(101,'','29','product','0','2024-04-10 12:17:41',NULL,NULL,NULL,'TravelBus',NULL,NULL),
(102,'3','30','product','1','2024-04-10 12:21:23','2024-04-10 13:26:04',NULL,NULL,'ZapsMaster',NULL,NULL),
(103,'3','30','product','1','2024-04-10 12:21:23','2024-04-10 13:25:59',NULL,NULL,'ZapsMaster',NULL,NULL),
(104,'','30','product','0','2024-04-10 12:21:23',NULL,NULL,NULL,'ZapsMaster',NULL,NULL),
(105,'','30','product','0','2024-04-10 12:21:23',NULL,NULL,NULL,'ZapsMaster',NULL,NULL),
(106,'3','39','pbatch','0','2024-04-10 13:26:51',NULL,NULL,NULL,'ZAPSBATCH',NULL,NULL),
(107,'','39','pbatch','0','2024-04-10 13:26:51',NULL,NULL,NULL,'ZAPSBATCH',NULL,NULL),
(108,'','39','pbatch','0','2024-04-10 13:26:51',NULL,NULL,NULL,'ZAPSBATCH',NULL,NULL),
(109,'3','24','customer','0','2024-04-10 13:28:19',NULL,NULL,NULL,'Vivek Gedam',NULL,NULL),
(110,'','24','customer','0','2024-04-10 13:28:19',NULL,NULL,NULL,'Vivek Gedam',NULL,NULL),
(111,'','24','customer','0','2024-04-10 13:28:19',NULL,NULL,NULL,'Vivek Gedam',NULL,NULL),
(112,'3','46','addproduct','1','2024-04-10 13:28:35',NULL,NULL,NULL,'AliasZAPS',NULL,NULL),
(113,'','46','addproduct','1','2024-04-10 13:28:35',NULL,NULL,NULL,'AliasZAPS',NULL,NULL),
(114,'','46','addproduct','1','2024-04-10 13:28:35',NULL,NULL,NULL,'AliasZAPS',NULL,NULL),
(115,'3','31','manufacture','1','2024-04-10 15:11:12','2024-04-10 15:13:13',NULL,NULL,'WEB MEDIA INDIA 2',NULL,NULL),
(116,'','31','manufacture','0','2024-04-10 15:11:12',NULL,NULL,NULL,'WEB MEDIA INDIA 2',NULL,NULL),
(117,'','31','manufacture','0','2024-04-10 15:11:12',NULL,NULL,NULL,'WEB MEDIA INDIA 2',NULL,NULL),
(118,'3','31','product','0','2024-04-10 15:12:11',NULL,NULL,NULL,'ShreeNetra',NULL,NULL),
(119,'3','31','product','1','2024-04-10 15:12:11','2024-04-10 15:13:07',NULL,NULL,'ShreeNetra',NULL,NULL),
(120,'','31','product','0','2024-04-10 15:12:11',NULL,NULL,NULL,'ShreeNetra',NULL,NULL),
(121,'','31','product','0','2024-04-10 15:12:11',NULL,NULL,NULL,'ShreeNetra',NULL,NULL),
(122,'3','40','pbatch','0','2024-04-10 15:14:18',NULL,NULL,NULL,'SHREEB01',NULL,NULL),
(123,'','40','pbatch','0','2024-04-10 15:14:18',NULL,NULL,NULL,'SHREEB01',NULL,NULL),
(124,'','40','pbatch','0','2024-04-10 15:14:18',NULL,NULL,NULL,'SHREEB01',NULL,NULL),
(125,'34','25','customer','1','2024-04-30 16:12:53','2024-04-30 16:13:15',NULL,NULL,'Mayuri 123','Edit',NULL),
(126,'34','25','customer','1','2024-04-30 16:12:53','2024-04-30 16:13:17',NULL,NULL,'Mayuri 123','Edit',NULL),
(127,'34','25','customer','1','2024-04-30 16:12:53','2024-04-30 16:13:21',NULL,NULL,'Mayuri 123','Edit',NULL),
(128,'3','47','addproduct','0','2024-04-10 15:15:22',NULL,NULL,NULL,'APSHREENETRA',NULL,NULL),
(129,'','47','addproduct','0','2024-04-10 15:15:22',NULL,NULL,NULL,'APSHREENETRA',NULL,NULL),
(130,'','47','addproduct','0','2024-04-10 15:15:22',NULL,NULL,NULL,'APSHREENETRA',NULL,NULL),
(131,'','41','pbatch','1','2024-04-12 16:06:27',NULL,NULL,NULL,'ALPHA1001',NULL,NULL),
(132,'','41','pbatch','1','2024-04-12 16:06:27',NULL,NULL,NULL,'ALPHA1001',NULL,NULL),
(133,'','41','pbatch','1','2024-04-12 16:06:27',NULL,NULL,NULL,'ALPHA1001',NULL,NULL),
(134,'','43','generateqr','0','2024-04-12 16:11:14',NULL,NULL,NULL,'LAX/0424/043',NULL,NULL),
(135,'','43','generateqr','0','2024-04-12 16:11:14',NULL,NULL,NULL,'LAX/0424/043',NULL,NULL),
(136,'','43','generateqr','0','2024-04-12 16:11:14',NULL,NULL,NULL,'LAX/0424/043',NULL,NULL),
(137,'3','32','product','1','2024-04-12 17:55:42','2024-04-12 17:57:15',NULL,NULL,'NicotinAlpha',NULL,NULL),
(138,'3','32','product','1','2024-04-12 17:55:42','2024-04-12 17:56:14',NULL,NULL,'NicotinAlpha',NULL,NULL),
(139,'','32','product','1','2024-04-12 17:55:42',NULL,NULL,NULL,'NicotinAlpha',NULL,NULL),
(140,'','32','product','1','2024-04-12 17:55:42',NULL,NULL,NULL,'NicotinAlpha',NULL,NULL),
(141,'3','48','addproduct','1','2024-04-12 17:59:36','2024-04-12 17:59:49',NULL,NULL,'NICOALPHA',NULL,NULL),
(142,'','48','addproduct','0','2024-04-12 17:59:36',NULL,NULL,NULL,'NICOALPHA',NULL,NULL),
(143,'','48','addproduct','0','2024-04-12 17:59:36',NULL,NULL,NULL,'NICOALPHA',NULL,NULL),
(144,'34','42','pbatch','1','2024-04-30 16:04:12','2024-04-30 16:04:34',NULL,NULL,'NICOALPHAB','Edit',NULL),
(145,'34','42','pbatch','1','2024-04-30 16:04:12','2024-04-30 16:04:37',NULL,NULL,'NICOALPHAB','Edit',NULL),
(146,'34','42','pbatch','1','2024-04-30 16:04:12','2024-04-30 16:04:39',NULL,NULL,'NICOALPHAB','Edit',NULL),
(155,'3','35','product','0','2024-04-14 15:37:01',NULL,NULL,NULL,'Headphones',NULL,NULL),
(156,'3','35','product','0','2024-04-14 15:37:01',NULL,NULL,NULL,'Headphones',NULL,NULL),
(157,'','35','product','0','2024-04-14 15:37:01',NULL,NULL,NULL,'Headphones',NULL,NULL),
(158,'','35','product','0','2024-04-14 15:37:01',NULL,NULL,NULL,'Headphones',NULL,NULL),
(160,'3','36','product','0','2024-04-14 16:40:55',NULL,NULL,NULL,'ZeroTIn',NULL,NULL),
(161,'','36','product','0','2024-04-14 16:40:55',NULL,NULL,NULL,'ZeroTIn',NULL,NULL),
(162,'','36','product','0','2024-04-14 16:40:55',NULL,NULL,NULL,'ZeroTIn',NULL,NULL),
(163,'3','37','product','0','2024-04-14 16:45:51',NULL,NULL,NULL,'Zerotin Alpha',NULL,NULL),
(164,'3','37','product','0','2024-04-14 16:45:51',NULL,NULL,NULL,'Zerotin Alpha',NULL,NULL),
(165,'','37','product','0','2024-04-14 16:45:51',NULL,NULL,NULL,'Zerotin Alpha',NULL,NULL),
(166,'','37','product','0','2024-04-14 16:45:51',NULL,NULL,NULL,'Zerotin Alpha',NULL,NULL),
(167,'3','38','product','0','2024-04-14 16:48:03',NULL,NULL,NULL,'A',NULL,NULL),
(168,'3','38','product','0','2024-04-14 16:48:09',NULL,NULL,NULL,'A',NULL,NULL),
(169,'3','39','product','0','2024-04-14 16:51:57',NULL,NULL,NULL,'a',NULL,NULL),
(170,'3','39','product','0','2024-04-14 16:52:00',NULL,NULL,NULL,'a',NULL,NULL),
(171,'3','32','manufacture','1','2024-04-14 16:55:14','2024-04-14 16:56:50',NULL,NULL,'Zeeshan Co Ltd',NULL,NULL),
(172,'','32','manufacture','0','2024-04-14 16:55:14',NULL,NULL,NULL,'Zeeshan Co Ltd',NULL,NULL),
(173,'','32','manufacture','0','2024-04-14 16:55:14',NULL,NULL,NULL,'Zeeshan Co Ltd',NULL,NULL),
(174,'34','40','product','1','2024-04-14 16:56:06','2024-05-01 13:14:12',NULL,NULL,'ZeLight','Delete','1'),
(175,'34','40','product','1','2024-04-14 16:56:06','2024-05-01 13:14:14',NULL,NULL,'ZeLight','Delete','1'),
(176,'3','43','pbatch','0','2024-04-14 17:00:11',NULL,NULL,NULL,'ZELIGHTB',NULL,NULL),
(177,'','43','pbatch','0','2024-04-14 17:00:11',NULL,NULL,NULL,'ZELIGHTB',NULL,NULL),
(178,'','43','pbatch','0','2024-04-14 17:00:11',NULL,NULL,NULL,'ZELIGHTB',NULL,NULL),
(179,'34','49','addproduct','1','2024-04-30 15:08:09','2024-04-30 18:53:49',NULL,NULL,'ZeLight','Delete','1'),
(180,'3','41','product','0','2024-04-15 11:03:00',NULL,NULL,NULL,'Gemini',NULL,NULL),
(181,'34','45','pbatch','1','2024-04-16 12:30:59','2024-05-01 13:27:53',NULL,NULL,'ZEBATCH!','Delete','1'),
(182,'34','50','addproduct','1','2024-04-30 15:00:55','2024-04-30 18:49:49',NULL,NULL,'ZeLight','Delete','1'),
(183,'11','46','generateqr','0','2024-04-16 17:50:10',NULL,NULL,NULL,'LAX/0424/046',NULL,NULL),
(184,'11','46','generateqr','0','2024-04-16 17:50:10',NULL,NULL,NULL,'LAX/0424/046',NULL,NULL),
(185,'11','47','generateqr','0','2024-04-16 17:54:44',NULL,NULL,NULL,'LAX/0424/047',NULL,NULL),
(186,'11','47','generateqr','0','2024-04-16 17:54:44',NULL,NULL,NULL,'LAX/0424/047',NULL,NULL),
(187,'26','33','manufacture','0','2024-04-16 18:10:00',NULL,NULL,NULL,'Web Media Amravati Ltd',NULL,NULL),
(188,'3','33','manufacture','1','2024-04-16 18:10:00','2024-04-16 18:10:17',NULL,NULL,'Web Media Amravati Ltd',NULL,NULL),
(189,'24','33','manufacture','0','2024-04-16 18:10:00',NULL,NULL,NULL,'Web Media Amravati Ltd',NULL,NULL),
(190,'4','33','manufacture','0','2024-04-16 18:10:00',NULL,NULL,NULL,'Web Media Amravati Ltd',NULL,NULL),
(191,'17','33','manufacture','0','2024-04-16 18:10:00',NULL,NULL,NULL,'Web Media Amravati Ltd',NULL,NULL),
(192,'26','42','product','0','2024-04-16 18:11:10',NULL,NULL,NULL,'Hello Phones',NULL,NULL),
(193,'34','34','manufacture','1','2024-04-30 15:49:12','2024-04-30 15:49:41',NULL,NULL,'Web Media India Ltd','Edit',NULL),
(194,'34','43','product','1','2024-04-30 15:55:36','2024-05-01 13:12:35',NULL,NULL,'Hello Phones','Delete','1'),
(195,'34','46','pbatch','1','2024-04-30 16:01:12','2024-05-01 13:27:04',NULL,NULL,'HBATCH','Delete','1'),
(196,'34','51','addproduct','1','2024-04-30 18:34:12','2024-04-30 18:49:08',NULL,NULL,'Hello Phones','Delete','1'),
(197,'11','48','generateqr','1','2024-04-16 18:25:27','2024-04-16 18:26:24',NULL,NULL,'LAX/0424/048',NULL,NULL),
(198,'11','48','generateqr','1','2024-04-16 18:25:27','2024-04-16 18:26:28',NULL,NULL,'LAX/0424/048',NULL,NULL),
(199,'11','49','generateqr','-1','2024-04-16 18:27:34',NULL,'Wrong Lot Number','2024-04-17 13:56:54','LAX/0424/049',NULL,NULL),
(200,'11','49','generateqr','-1','2024-04-16 18:27:34',NULL,'Wrong Lot','2024-04-17 13:56:00','LAX/0424/049',NULL,NULL),
(201,'34','35','manufacture','1','2024-04-17 13:07:54','2024-05-01 16:29:04',NULL,NULL,'ABC','Delete','1'),
(202,'34','35','manufacture','1','2024-04-17 13:07:54','2024-05-01 16:29:07',NULL,NULL,'ABC','Delete','1'),
(203,'34','35','manufacture','1','2024-04-17 13:07:54','2024-05-01 16:29:09',NULL,NULL,'ABC','Delete','1'),
(204,'34','36','manufacture','1','2024-04-17 13:28:09','2024-05-01 12:40:48',NULL,NULL,'A','Delete','1'),
(205,'34','51','addproduct','1','2024-04-30 18:34:12','2024-04-30 18:49:10',NULL,NULL,'Hello Phones','Delete','1'),
(206,'34','51','addproduct','1','2024-04-30 18:34:12','2024-04-30 18:49:12',NULL,NULL,'Hello Phones','Delete','1'),
(207,'34','50','addproduct','1','2024-04-30 15:00:55','2024-04-30 18:49:52',NULL,NULL,'ZeLight','Delete','1'),
(208,'34','49','addproduct','1','2024-04-30 15:08:09','2024-04-30 18:53:51',NULL,NULL,'ZeLight','Delete','1'),
(209,'34','39','manufacture','1','2024-05-01 12:29:46','2024-05-01 12:30:43',NULL,NULL,'asdf','Delete','1'),
(210,'34','26','customer','1','2024-05-01 14:23:24','2024-05-01 14:24:03',NULL,NULL,'a','Delete','1'),
(211,'34','52','addproduct','0','2024-05-01 16:35:56','2024-05-01 16:36:28',NULL,NULL,'NicotinAlpha','Delete','-1'),
(215,'34','26','dispatch','1','2024-05-10 13:05:32','2024-05-10 14:27:38',NULL,NULL,'LAX/0424/049','New Item','1'),
(218,'34','1','returnstock','1','2024-05-10 18:15:19','2024-05-13 10:43:49',NULL,NULL,'LAX/0324/036','New Item','1'),
(219,'34','27','dispatch','0','2024-05-13 17:46:45',NULL,NULL,NULL,'LAX/0424/048','New Item','0'),
(220,'34','28','dispatch','1','2024-05-13 17:50:30','2024-05-13 18:38:18',NULL,NULL,'LAX/0324/021','Delete','1'),
(221,'34','29','dispatch','0','2024-05-13 18:22:14','2024-05-13 18:22:36',NULL,NULL,'LAX/0324/016','Delete','-1'),
(222,'34','2','returnstock','1','2024-05-14 11:11:37','2024-05-14 13:24:55',NULL,NULL,'LAX/0324/036','New Item','1'),
(223,'34','3','returnstock','1','2024-05-14 11:11:52','2024-05-14 13:24:50',NULL,NULL,'LAX/0324/036','New Item','1'),
(224,'34','4','returnstock','1','2024-05-14 11:59:17','2024-05-14 13:24:46',NULL,NULL,'LAX/0324/034','New Item','1'),
(225,'34','5','returnstock','1','2024-05-14 11:59:54','2024-05-14 13:24:41',NULL,NULL,'LAX/0324/034','New Item','1'),
(226,'34','6','returnstock','1','2024-05-14 12:24:35','2024-05-14 13:24:38',NULL,NULL,'LAX/0324/034','New Item','1'),
(227,'34','7','returnstock','1','2024-05-14 12:31:39','2024-05-14 13:24:36',NULL,NULL,'LAX/0324/034','New Item','1'),
(228,'34','8','returnstock','1','2024-05-14 12:42:48','2024-05-14 13:24:30',NULL,NULL,'LAX/0324/034','New Item','1'),
(229,'34','9','returnstock','1','2024-05-14 12:44:34','2024-05-14 13:25:13',NULL,NULL,'LAX/0324/034','New Item','1'),
(230,'34','10','returnstock','1','2024-05-14 12:48:56','2024-05-14 13:25:10',NULL,NULL,'LAX/0324/034','New Item','1'),
(231,'34','11','returnstock','1','2024-05-14 13:18:21','2024-05-14 13:25:09',NULL,NULL,'LAX/0324/034','New Item','1'),
(232,'34','12','returnstock','1','2024-05-14 13:20:19','2024-05-14 13:25:06',NULL,NULL,'LAX/0324/034','New Item','1');
/*!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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 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`) VALUES
(1,'1234','2','2334','442','2023-10-16 00:00:00','2023-10-16 00:00:00','','','BP',NULL,NULL,'3','0'),
(3,'fada','2','1313','131313','2023-10-16 00:00:00','2023-10-16 00:00:00','','','IP',NULL,NULL,NULL,'0'),
(4,'scff','2','dgdg','133131','2023-10-16 00:00:00','2023-10-16 00:00:00','','','BP',NULL,NULL,NULL,'0'),
(5,'113','2','13','313','1333-12-03 00:00:00','2023-10-16 00:00:00','','','BP',NULL,NULL,NULL,'0'),
(6,'0303','2','3030','30303','2023-03-03 00:00:00','3033-03-16 00:00:00','','','IP',NULL,NULL,NULL,'0'),
(7,'zgg','2','116','1616','2023-11-16 00:00:00','2023-10-16 00:00:00','','','BP',NULL,NULL,'3','0'),
(8,'fafssa','6','agagadg','agagag','2023-12-01 00:00:00','2023-09-01 00:00:00','','','BP,EP',NULL,NULL,NULL,'0'),
(9,'0303','2','3030','30303','2023-03-01 00:00:00','3033-03-01 00:00:00','','','IP,BP',NULL,NULL,NULL,'0'),
(10,'fafssa','6','agagadg','agagag','2023-12-01 00:00:00','2023-09-01 00:00:00','','','IP,BP,EP',NULL,NULL,NULL,'0'),
(11,'123','7','123','123','2023-11-01 00:00:00','2023-11-01 00:00:00','','','IP,BP',NULL,NULL,NULL,'0'),
(12,'1313133','8','1313','11313','2024-01-01 00:00:00','2023-12-01 00:00:00','','','',NULL,NULL,NULL,'0'),
(13,'1313','8','113','11313','2023-12-01 00:00:00','2023-12-01 00:00:00','','','EP',NULL,NULL,NULL,'0'),
(14,'33','8','3','333','2023-12-01 00:00:00','2023-12-01 00:00:00','','','IP,BP',NULL,NULL,NULL,'0'),
(15,'fsgs','7','shdsh','sdhdsd','2023-12-01 00:00:00','2023-12-01 00:00:00','','','IP,BP',NULL,NULL,'3','0'),
(16,'gsd','2','dshds','dhdshds','2023-12-01 00:00:00','2023-12-01 00:00:00','','','USP',NULL,NULL,NULL,'0'),
(18,'gd','4','dsgsg','dhdshsh','2024-02-01 00:00:00','2025-07-01 00:00:00','','','BP',NULL,NULL,NULL,'0'),
(19,'rr','12','rqr','rqrqr','2023-12-01 00:00:00','2024-12-01 00:00:00','','','BP',NULL,NULL,NULL,'0'),
(20,'B1111','13','10','IB1010','2024-03-01 00:00:00','2024-12-01 00:00:00','','','BP',NULL,NULL,NULL,'0'),
(21,'B10010','14','12','BI10010','2024-03-01 00:00:00','2024-12-01 00:00:00','','','EP',NULL,NULL,NULL,'0'),
(22,'B12345','15','10','IB12345','2024-01-01 00:00:00','2024-12-01 00:00:00','','','EP',NULL,NULL,NULL,'0'),
(23,'B101896','15','12','IB101896','2024-02-01 00:00:00','2024-09-01 00:00:00','','','EP',NULL,NULL,'3','0'),
(24,'BATCH01','17','12','IBATCH01','2024-02-01 00:00:00','2024-09-01 00:00:00','','','BP,USP',NULL,NULL,NULL,'0'),
(25,'BATCH0002','18','18','IBATCH0002','2024-01-01 00:00:00','2024-05-01 00:00:00','','','IP,BP,EP,USP',NULL,NULL,NULL,'0'),
(26,'Batch1010','18','10','Ibatch1010','2024-01-01 00:00:00','2024-10-01 00:00:00','','','BP',NULL,NULL,NULL,'0'),
(27,'Batch1010','18','10','Ibatch1010','2024-01-01 00:00:00','2024-10-01 00:00:00','','','BP',NULL,NULL,NULL,'0'),
(28,'Batch1010','18','10','Ibatch1010','2024-01-01 00:00:00','2024-10-01 00:00:00','','','BP',NULL,NULL,'3','0'),
(29,'Batch1010','18','10','Ibatch1010','2024-01-01 00:00:00','2024-10-01 00:00:00','','','BP',NULL,NULL,NULL,'0'),
(30,'Batch1010','18','10','Ibatch1010','2024-01-01 00:00:00','2024-10-01 00:00:00','','','BP',NULL,NULL,NULL,'0'),
(31,'Batch1010','18','10','Ibatch1010','2024-01-01 00:00:00','2024-10-01 00:00:00','','','BP',NULL,NULL,NULL,'0'),
(32,'b1111','18','10','ib1111','2024-01-01 00:00:00','2024-06-01 00:00:00','','','BP',NULL,NULL,NULL,'0'),
(33,'b11111','18','10','ib1111','2024-01-01 00:00:00','2024-06-01 00:00:00','','','IP',NULL,NULL,NULL,'0'),
(34,'Batch10101','18','18','IBATCH','2024-01-01 00:00:00','2024-05-01 00:00:00','','','IP,BP,EP,USP',NULL,NULL,NULL,'0'),
(35,'Batch10111','18','12','ib10000','2024-01-01 00:00:00','2024-10-01 00:00:00','','','IP,BP',NULL,NULL,NULL,'0'),
(36,'batch67','23','1000','ibatch67','2024-01-01 00:00:00','2024-06-01 00:00:00','','','IP,BP','2024-03-27 11:48:59',NULL,'3','0'),
(37,'Alpha 9','24','12','IAlpha','2024-01-01 00:00:00','2024-10-01 00:00:00','','','BP','2024-04-03 14:12:07',NULL,NULL,'0'),
(38,'LAXAP01','26','120','ILAXAP01','2024-01-01 00:00:00','2024-10-01 00:00:00','','','USP','2024-04-08 15:36:20',NULL,NULL,'0'),
(39,'ZAPSBATCH','30','125','IZAPSBACH','2024-01-01 00:00:00','2024-06-01 00:00:00','','','EP','2024-04-10 13:26:50',NULL,NULL,'0'),
(40,'SHREEB01','31','12','ISHREEB01','2024-01-01 00:00:00','2024-06-01 00:00:00','','','EP','2024-04-10 15:14:17',NULL,'3','0'),
(41,'ALPHA1001','24','15200','IALPHA1001','2024-01-01 00:00:00','2024-05-01 00:00:00','','','BP','2024-04-16 15:28:44','2024-04-16 15:28:44','3','0'),
(42,'NICOALPHAB','32','154','INICOALPHAB','2024-01-01 00:00:00','2024-05-01 00:00:00','','','USP','2024-04-30 16:04:12','2024-04-30 16:04:12','3','0'),
(43,'ZELIGHTB','40','158','IZELIGHTB','2024-01-01 00:00:00','2024-05-01 00:00:00','','','EP','2024-04-14 17:00:11',NULL,'29','0'),
(44,'ZEEBATCH','40','130','IZEEBATCH','2024-01-01 00:00:00','2024-09-01 00:00:00','','','EP','2024-04-30 16:03:42','2024-04-30 16:03:42','3','0'),
(45,'ZEBATCH!','40','150','IZEEBATCH!','2024-01-01 00:00:00','2024-06-01 00:00:00','','','EP','2024-04-16 12:30:59',NULL,'30','-1'),
(46,'HBATCH','43','120','IBATCH','2024-01-01 00:00:00','2024-06-01 00:00:00','','','USP','2024-04-30 16:01:12','2024-04-30 16:01:12','11','-1');
/*!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 AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table preset
-- 

/*!40000 ALTER TABLE `preset` DISABLE KEYS */;
INSERT INTO `preset`(`id`,`title`,`name`,`formula`,`batch`,`molwt`,`tarewt`,`grosswt`,`netwt`,`gtin`,`manufact`,`storag`,`grade`,`uom`) VALUES
(5,'dfd','zddzf','zdfzf','zdfdzff','','','','','','','','',''),
(6,'cvzdv','bsb','bsbs','bsbs','1','2','3','4','','','','','');
/*!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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=44 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`) VALUES
(3,'Valga','dvs','dvvd','22','LAXACHEM ORGANICS PVT. LTD.','qwwe','IP','Valu','12',NULL,NULL,'2024-04-05 15:42:52','3','H3CN5','15','0'),
(5,'sddgg','dgag','adgag','14','','gagagga','IP,EP,USP','','gag','agaga',NULL,NULL,NULL,NULL,NULL,'0'),
(6,'sddgg','dgag','adgag','0','','gagagga','IP,BP,EP,USP','','IP,BP,EP,USP','dgsdgsd',NULL,NULL,NULL,NULL,NULL,'0'),
(7,'tin','dummy','1313','15','','12','BP,EP,USP','','10,15,20',NULL,NULL,NULL,'3',NULL,NULL,'0'),
(8,'feqfe','egeq','geqgeq','15,17','','fshfsh','BP,EP','','10,25,30','KG',NULL,NULL,NULL,NULL,NULL,'0'),
(9,'gsfgsh','ffddj','jdfjdj','17','','fshfsh','BP','','2342','LTR',NULL,NULL,NULL,NULL,NULL,'0'),
(10,'IC/1123/002','hfshs','ffsfs','15','','fjsjsfj','BP,EP','','faaf','KG',NULL,NULL,NULL,NULL,NULL,'0'),
(11,'dhdh','hdh','ddh','15,17','12345678,agagad','hdf','IP,BP','','120','LTR',NULL,NULL,'3',NULL,NULL,'0'),
(13,'TUSQXC','REFRILL','GTIN0011','19','LAXAM','KEEP IN DRY PLACES','BP','TQ','10','KG',NULL,NULL,NULL,NULL,NULL,'0'),
(14,'COFIL','LAXACHEMICALS','GTIN02222','20','LAXACHEMICALS','KEEP IN COOL PLACES','EP','','15','KG',NULL,NULL,NULL,NULL,NULL,'0'),
(15,'TULIP C','LAXACHEM','GTIN11214','15','12345678','KEEP IN COOL PLACES','EP','HYDEROSULPHATE','10','LTR',NULL,NULL,NULL,NULL,NULL,'0'),
(16,'Chemchlo','laxachemm','GTIN9999','20','LAXACHEMICALS','NA','EP','Chem','12','KG',NULL,NULL,NULL,NULL,NULL,'0'),
(17,'DUCOSATE SODIUM','Laxachem','GTIN120120','21','LAXACHEM','KEEP AWAY FROM CHILD','BP,USP','Dioclyle Sodium Sulfosuccinate','12','KG',NULL,NULL,NULL,NULL,NULL,'0'),
(18,'DUCOSATE SODIUM','LAXACHEM ORGANICS PVT. LTD.','GTIN11000','22','LAXACHEM ORGANICS PVT. LTD.','kKEEP IN COOL PLACES','IP,BP,EP,USP','Dioctyle Sodium Sulfosuccinate','18','KG',NULL,NULL,NULL,NULL,NULL,'0'),
(19,'Suffocillicitate Drugnile Alpha ','Serum Institute','Gtin11000','23','Serum Institute','Keep In dry Places','IP','Suffocilliciate','12','KG',NULL,NULL,'3',NULL,NULL,'0'),
(20,'Suffocillicitate Drugnile Alpha ','Serum Institute','Gtin11000','23','Serum Institute','Keep In dry Places','IP','Suffocilliciate','12','KG',NULL,NULL,NULL,NULL,NULL,'0'),
(21,'Suffocillicitate Drugnile Alpha ','Serum Institute','Gtin11000','23','Serum Institute','Keep In dry Places','IP','Suffocilliciate','12','KG',NULL,NULL,NULL,NULL,NULL,'0'),
(22,'Suffocicilate','fdsfdf','fdsfdsgf','22','LAXACHEM ORGANICS PVT. LTD.','dsdgdfg','EP','asddasf','33','KG',NULL,NULL,'3',NULL,NULL,'0'),
(23,'Ducosate Sodium','LaxaChem','GTIN0101000','22','LAXACHEM ORGANICS PVT. LTD.','Keep this product in cool and dry places and also keep this product away from children','IP,BP','Dioctyle Sodium Sulfosccinate','120','KG','2024-03-27 11:45:06',NULL,NULL,'CH3SD1F','100','0'),
(24,'Ducodine Alphaa Nine','WebMedia','GTIN001','22','LAXACHEM ORGANICS PVT. LTD.','Keep In Cool Places','BP','Duconine Alpha','12','KG','2024-04-03 14:11:11',NULL,NULL,'HC4H55','123','0'),
(26,'LaxachemProject','WebMedia','GTINWEB','29','WebMedia','NA','USP','LaxaProject','12','KG','2024-04-08 15:31:22',NULL,'3','DOTNET','12','0'),
(27,'CofeeSofil','LaxaChem','GTIN001','22','LAXACHEM ORGANICS PVT. LTD.','NA','IP,EP','Cofee','458','KG','2024-04-08 15:39:10',NULL,NULL,'HG1S2','123','0'),
(28,'Keyboard','Sony','SONYGTIN','29','WebMedia','NA','EP','QWERTR','12','KG','2024-04-09 14:24:47',NULL,NULL,'qwertr','120','0'),
(29,'TravelBus','ZapTravel','GTINZAPS','30','Zaps','NA','EP','Bus','120','KG','2024-04-10 12:17:41',NULL,NULL,'NA','NA','0'),
(30,'ZapsMaster','Zaps','ZAPSGTIN','30','Zaps','NA','EP','Master','12','KG','2024-04-10 12:21:23',NULL,'3','NA','NA','0'),
(31,'ShreeNetra','Shree','SHREEGTIN','31','Web Media','NA','EP','NETRALAYA','152','KG','2024-04-10 15:12:11',NULL,NULL,'FORMULA','MOLWT','0'),
(32,'NicotinAlpha','LAXA','1234567891254','22','LAXACHEM ORGANICS PVT. LTD.','NA','USP','Nicotin','125','KG','2024-04-12 17:55:42',NULL,'3','NA','NS','0'),
(35,'Headphones','Zebronics','789654123','30','Zaps','Na','EP','Earphones','120','KG','2024-04-14 15:37:01',NULL,'3','NA','NA','0'),
(36,'ZeroTIn','NOT DEFINED','123654','30','Zaps','NA','EP','Zerotin','120','KG','2024-04-14 16:37:44',NULL,'3','NA','NA','0'),
(37,'Zerotin Alpha','LAXA','785412','30','Zaps','NA','BP','Z Alpha ','120','KG','2024-04-14 16:45:21',NULL,'3','NA','NA','0'),
(40,'ZeLight','Zeshan LTD','47896523','32','Zeeshan Ltd','NA','EP','Light','120','KG','2024-04-14 16:56:06',NULL,'29','NA','NA','-1'),
(41,'Gemini','LAXA','758458','30','Zaps','NA','USP','Gemini','152','KG','2024-04-15 11:03:00',NULL,'30','NA','NA','0'),
(42,'Hello Phones','Web Media','5248521478','33','Web Media Amravati Ltd','MA','EP','Hello Phones','780','KG','2024-04-16 18:11:10',NULL,'3','NA','NA','0'),
(43,'Hello Phones','Web Media India Ltd','8548555','33','Web Media Amravati Ltd','Keep In Cool Places','USP','Hello','850','KG','2024-04-16 18:23:32','2024-04-30 15:55:36','11','NA','NA','-1');
/*!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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table returnstock
-- 

/*!40000 ALTER TABLE `returnstock` DISABLE KEYS */;
INSERT INTO `returnstock`(`id`,`lotno`,`remark`,`dor`,`created`,`updated`,`userid`,`status`,`deletestatus`,`rtime`) VALUES
(1,'36','','2024-05-24 00:00:00','2024-05-10 00:00:00','2024-05-10 00:00:00','34','0','0','2024-05-10 18:15:18'),
(2,'36','','2024-05-14 00:00:00','2024-05-14 00:00:00','2024-05-14 00:00:00','34','0','0','2024-05-14 11:11:36'),
(3,'36','','2024-05-14 00:00:00','2024-05-14 00:00:00','2024-05-14 00:00:00','34','0','0','2024-05-14 11:11:51'),
(12,'34','','2024-05-14 00:00:00','2024-05-14 00:00:00','2024-05-14 00:00:00','34','0','0','2024-05-14 13:20:18');
/*!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 AUTO_INCREMENT=32 DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table returnstocknew
-- 

/*!40000 ALTER TABLE `returnstocknew` DISABLE KEYS */;
INSERT INTO `returnstocknew`(`id`,`lotid`,`ssccno`,`tarewt`,`netwt`,`grosswt`,`created`,`userid`,`updated`,`contno`,`rntime`) VALUES
(1,'36','000000001638','125.2','12','137.2',NULL,NULL,NULL,'1/5','2024-05-10 18:15:19'),
(2,'36','000000001656','125.2','12','137.2',NULL,NULL,NULL,'3/5','2024-05-10 18:15:20'),
(3,'36','000000001647','125.2','12','137.2',NULL,NULL,NULL,'2/5','2024-05-10 18:15:20'),
(4,'36','000000001665','125.2','12','137.2',NULL,NULL,NULL,'4/5','2024-05-14 11:11:37'),
(5,'36','000000001674','125.2','12','137.2',NULL,NULL,NULL,'5/5','2024-05-14 11:11:52'),
(31,'34','000000001586','222','12','234',NULL,NULL,NULL,'1/2','2024-05-14 13:20:25');
/*!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 AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table rolemaster
-- 

/*!40000 ALTER TABLE `rolemaster` DISABLE KEYS */;
INSERT INTO `rolemaster`(`id`,`username`,`password`,`role`,`created`,`updated`) VALUES
(1,'admin','1234','Administration,Admin','2024-04-03 14:42:42',NULL),
(2,'admin1','1234','Quality Assurer,Administration,Admin','2024-04-03 14:54:58',NULL);
/*!40000 ALTER TABLE `rolemaster` 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 '',
  `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,
  `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,
  `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,
  `name` varchar(50) DEFAULT NULL,
  `approval` varchar(50) DEFAULT NULL,
  `reports` varchar(50) DEFAULT NULL,
  `subuser` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table userm
-- 

/*!40000 ALTER TABLE `userm` DISABLE KEYS */;
INSERT INTO `userm`(`id`,`username`,`password`,`rights`,`addproduct`,`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`,`aliasproductadministration`,`customeradministration`,`dispatchadministration`,`manufactureadministration`,`pbatchadministration`,`productadministration`,`returnstockadministration`,`stockadministration`,`usermadministration`,`aliasproductqa`,`customerqa`,`dispatchqa`,`generateqrqa`,`manufactureqa`,`pbatchqa`,`productqa`,`returnstockqa`,`stockqa`,`usermqa`,`name`,`approval`,`reports`,`subuser`) VALUES
(31,'xyz','1234','manufacturelocations,products,batch,stocks,usermanagem','','','','','2024-04-22 16:27:34','2024-04-22 16:27:34','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(33,'pratik1','1234','','create,read,edit,delete','create,read,edit,delete','create,read,edit,delete','',NULL,NULL,'','','','create,read,edit,delete','create,read,edit,delete','','','','','','','Admin','33','33','','','33','33','33','','','','','','','','','','','','','','','','','','','','','','','Pratik','Hide','Hide',''),
(34,'waseem1','1234','','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','34','34','34','34','34','34','34','34','','','','','','','','','','','','','','','','','','','','','','Waseem','Show','Show',''),
(35,'kapil1','1234','','create,read,edit,delete','','','',NULL,NULL,'','','','','','','','','','','','Admin','34','','','','','','','','','','','','','','','','','','','','','','','','','','','','','Kapil','Hide','Hide','');
/*!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-05-14 15:44:08
-- Total time: 0:0:0:0:230 (d:h:m:s:ms)
