-- MySqlBackup.NET 2.0.4 -- Dump Time: 2024-04-22 18:48:11 -- -------------------------------------- -- Server version 5.7.14-log 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, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=52 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`) VALUES (15,'duco4','DUCOSATE SODIUM',17,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (17,'DUSOSATE SODIUM 12','DUCOSATE SODIUM',18,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (18,'Ducosate Sodium 1234','DUCOSATE SODIUM',18,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (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), (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), (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), (22,'Ducosate Sodium 12','Ducosate Sodium',23,'2024-03-27 11:49:22',NULL,'0',NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL), (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), (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), (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), (26,'duco alpha','Ducosate Sodium',23,'2024-04-02 16:26:22',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL), (27,'duco alpha','Ducosate Sodium',23,'2024-04-02 16:27:27',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL), (28,'Ducomtdr aserdutilicia','Ducosate Sodium',23,'2024-04-03 11:42:20',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL), (29,'aserdity lucocium sulphonacii','Ducosate Sodium',23,'2024-04-03 11:43:37',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL), (30,'alpha Beta','Ducosate Sodium',23,'2024-04-03 11:51:58',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL), (31,'Beta Alpha','Ducosate Sodium',23,'2024-04-03 11:53:27',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL), (32,'AlphaBegta22','Ducosate Sodium',23,'2024-04-03 11:59:47',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL), (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), (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), (35,'dfbfgngfjghj','Ducosate Sodium',23,'2024-04-03 12:53:17',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL), (36,'ASDFRETTFFD','Ducosate Sodium',23,'2024-04-03 13:09:36',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL), (37,'ASDFRETTFFD','Ducosate Sodium',23,'2024-04-03 13:09:44',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL), (38,'dfshrgjhgk','Ducosate Sodium',23,'2024-04-03 13:23:50',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL), (39,'safsdfbgffgjghk','Ducosate Sodium',23,'2024-04-03 13:24:59',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL), (40,'Alpha Nine','Ducodine Alphaa Nine',24,'2024-04-03 14:23:14',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL), (41,'asdrewacolatemenia','Ducodine Alphaa Nine',24,'2024-04-03 16:28:49',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL), (42,'Alpha 10','Ducodine Alphaa Nine',24,'2024-04-03 16:31:19',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL), (43,'alpha 112','Ducodine Alphaa Nine',24,'2024-04-03 17:05:05',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL), (44,'alpha12','Ducodine Alphaa Nine',24,'2024-04-03 17:08:48',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL), (45,'laxapro','LaxachemProject',26,'2024-04-08 15:38:02',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL), (46,'AliasZAPS','ZapsMaster',30,'2024-04-10 13:28:35',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'27',NULL,NULL,NULL), (47,'APSHREENETRA','ShreeNetra',31,'2024-04-10 15:15:22',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'28',NULL,NULL,NULL), (48,'NICOALPHA','NicotinAlpha',32,'2024-04-12 17:59:36',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL), (49,'ZEEAlias','ZeLight',40,'2024-04-14 17:05:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL), (50,'ZEE123','ZeLight',40,'2024-04-16 12:32:08',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'30',NULL,NULL,NULL), (51,'HP ALIAS','Hello Phones',43,'2024-04-16 18:24:45',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'11',NULL,NULL,NULL); /*!40000 ALTER TABLE `aliasproduct` ENABLE KEYS */; -- -- Definition of customer -- DROP TABLE IF EXISTS `customer`; CREATE TABLE IF NOT EXISTS `customer` ( `id` int(11) NOT NULL AUTO_INCREMENT, `custname` varchar(255) DEFAULT '', `gstin` varchar(255) DEFAULT '', `custadd` varchar(255) DEFAULT '', `custphone` varchar(255) DEFAULT '', `custemail` varchar(255) DEFAULT '', `created` datetime DEFAULT NULL, `updated` datetime DEFAULT NULL, `custdrug` varchar(255) DEFAULT '', `consiadd` varchar(255) DEFAULT '', `consiname` varchar(255) DEFAULT '', `consiemail` varchar(255) DEFAULT '', `consiphone` varchar(255) DEFAULT '', `consigst` varchar(255) DEFAULT '', `considrug` varchar(255) DEFAULT '', `displayname` varchar(255) DEFAULT '', `type` varchar(255) DEFAULT '', `userid` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=26 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`) VALUES (17,'VAIBHAV','GSTIN1001','NAGPUR','985285285','VAIBHAV@GMAIL.COM',NULL,NULL,'DGFF111','','','','','','','VBHV','Customer','3'), (18,'Mohd Waseem','Gstin0000','Amravati','9898989898','sdfsdfds@gmail.com',NULL,NULL,'dg11112','','','','','','','waseem','Customer','3'), (19,'Sharique Sir','GSTIN122','Amravati','874521478','shariques@gmail.com','2024-04-03 14:13:03',NULL,'dg1234','','','','','','','no name','Customer',NULL), (20,'Pratik Mohod','P1234','Amravati ','8797987987','Pmohod@gmail.com','2024-04-04 12:36:43',NULL,'PG234','','','','','','','Pratik','Customer',NULL), (21,'Chandan Saraf','ch123','Amravati','79885887','chandan@gmail.com','2024-04-04 12:40:18',NULL,'ch4566','','','','','','','chandan','Customer',NULL), (22,'Sahl Khan','GSTIN1111','Amravai','9856985692','sahil@gamil.com','2024-04-08 12:07:38',NULL,'DG1234','','','','','','','Sahil','Customer','3'), (23,'Pratik Mohod','PGTIN','Amravati','9856985698','pratikm@gmail.com','2024-04-08 15:37:33',NULL,'DG124`','','','','','','','Pratik','Customer',NULL), (24,'Vivek Gedam','VGSTIN','Amravati','9874663214','vivek@gmail.com','2024-04-10 13:28:19',NULL,'VDG1021','','','','','','','Vivek','Customer',NULL), (25,'Mayuri','GSTINM','Amravati','5498989787','mayuri@gmail.com','2024-04-10 15:15:04',NULL,'DGMAYURI','','','','','','','Mayuri','Customer','3'); /*!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, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=19 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`) VALUES (10,'8','Export','2023-12-12 00:00:00','12','2023-12-12 00:00:00',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), (12,'34','Export','2024-03-18 00:00:00','1234','2024-03-18 00:00:00','16',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), (14,'32','Export','2024-03-18 00:00:00','12321','2024-03-18 00:00:00','16',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), (16,'35','Export','2024-03-20 00:00:00','12321','2024-03-20 00:00:00','16',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), (18,'30','Export','2024-03-21 00:00:00','BILL1100','2024-03-21 00:00:00','16','INV1100',NULL,NULL,NULL); /*!40000 ALTER TABLE `dispatch` ENABLE KEYS */; -- -- Definition of generateqr -- DROP TABLE IF EXISTS `generateqr`; CREATE TABLE IF NOT EXISTS `generateqr` ( `id` int(11) NOT NULL AUTO_INCREMENT, `presetid` varchar(255) DEFAULT '', `genid` varchar(255) DEFAULT '', `title` varchar(255) DEFAULT '', `aliasproductid` varchar(255) DEFAULT '', `name` varchar(255) DEFAULT '', `formula1` varchar(255) DEFAULT '', `batch` varchar(255) DEFAULT '', `molwt` varchar(255) DEFAULT '', `grosswt` varchar(255) DEFAULT '', `tarewt` varchar(255) DEFAULT '', `netwt` varchar(255) DEFAULT '', `mfgdate` date DEFAULT NULL, `expdate` date DEFAULT NULL, `userid` varchar(50) DEFAULT NULL, `manuid` varchar(255) DEFAULT '', `contfrom` varchar(255) DEFAULT '', `contto` varchar(255) DEFAULT '', `contno` varchar(255) DEFAULT '', `grade` varchar(255) DEFAULT '', `pack` varchar(255) DEFAULT '', `ncont` varchar(255) DEFAULT '', `qrqty` varchar(255) DEFAULT '', `totalqty` varchar(255) DEFAULT '', `dispatch` varchar(255) DEFAULT '0', `returnst` varchar(255) DEFAULT '0', `lotcreatedate` date DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=50 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','0','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','0','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','0','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','0','0','2024-04-16 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, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=264 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`) VALUES (7,'0','0','','','00000000',NULL,'0','0'), (8,'1/21','3','2112','',NULL,'00012345678000000011','0','0'), (9,'2/21','3','2112','',NULL,'00012345678000000020','0','0'), (10,'3/21','3','2112','',NULL,'00012345678000000031','0','0'), (11,'4/21','3','2112','',NULL,'00012345678000000042','0','0'), (12,'5/21','3','2112','',NULL,'00012345678000000053','0','0'), (13,'6/21','3','2112','',NULL,'00012345678000000064','0','0'), (14,'7/21','3','2112','',NULL,'00012345678000000075','0','0'), (15,'8/21','3','2112','',NULL,'00012345678000000084','0','0'), (16,'9/21','3','2112','',NULL,'00012345678000000093','0','0'), (17,'10/21','3','2112','',NULL,'00012345678000000101','0','0'), (18,'11/21','3','2112','',NULL,'00012345678000000112','0','0'), (19,'12/21','3','2112','',NULL,'00012345678000000123','0','0'), (20,'13/21','3','2112','',NULL,'00012345678000000134','0','0'), (21,'14/21','3','2112','',NULL,'00012345678000000145','0','0'), (22,'15/21','3','2112','',NULL,'00012345678000000154','0','0'), (23,'16/21','3','2112','',NULL,'00012345678000000163','0','0'), (24,'17/21','3','2112','',NULL,'00012345678000000172','0','0'), (25,'18/21','3','2112','',NULL,'00012345678000000181','0','0'), (26,'19/21','3','2112','',NULL,'00012345678000000190','0','0'), (27,'20/21','3','2112','',NULL,'00012345678000000204','0','0'), (28,'21/21','3','2112','','00000000','00012345678000000215','0','0'), (29,'1/2','4','','','00000001','00012345678000000011','0','0'), (30,'2/2','4','','','00000002','00012345678000000020','0','0'), (31,'1/23','5','33','66','00000003','000123456783000000034','0','0'), (32,'2/23','5','33','66','00000004','000123456783000000041','0','0'), (33,'3/23','5','33','66','00000005','000123456783000000052','0','0'), (34,'4/23','5','33','66','00000006','000123456783000000065','0','0'), (35,'5/23','5','33','66','00000007','000123456783000000072','0','0'), (36,'6/23','5','33','66','00000008','000123456783000000081','0','0'), (37,'7/23','5','33','66','00000009','000123456783000000094','0','0'), (38,'8/23','5','33','66','00000010','000123456783000000102','0','0'), (39,'9/23','5','33','66','00000011','000123456783000000111','0','0'), (40,'10/23','5','33','66','00000012','000123456783000000124','0','0'), (41,'11/23','5','33','66','00000013','000123456783000000133','0','0'), (42,'12/23','5','33','66','00000014','000123456783000000140','0','0'), (43,'13/23','5','33','66','00000015','000123456783000000153','0','0'), (44,'14/23','5','33','66','00000016','000123456783000000164','0','0'), (45,'15/23','5','33','66','00000017','000123456783000000171','0','0'), (46,'16/23','5','33','66','00000018','000123456783000000182','0','0'), (47,'17/23','5','33','66','00000019','000123456783000000195','0','0'), (48,'18/23','5','33','66','00000020','000123456783000000201','0','0'), (49,'19/23','5','33','66','00000021','000123456783000000212','0','0'), (50,'20/23','5','33','66','00000022','000123456783000000225','0','0'), (51,'21/23','5','33','66','00000023','000123456783000000232','0','0'), (52,'22/23','5','33','66','00000024','000123456783000000241','0','0'), (53,'23/23','5','33','66','00000025','000123456783000000254','0','0'), (54,'1/3','6','33','66','00000026','00012345678000000260','0','0'), (55,'2/3','6','33','66','00000027','00012345678000000271','0','0'), (56,'3/3','6','33','66','00000028','00012345678000000282','0','0'), (57,'1/23','7','22','44','00000029','00012345678000000293','0','0'), (58,'2/23','7','22','44','00000030','00012345678000000303','0','0'), (59,'3/23','7','22','44','00000031','00012345678000000312','0','0'), (60,'4/23','7','22','44','00000032','00012345678000000321','0','0'), (61,'5/23','7','22','44','00000033','00012345678000000330','0','0'), (62,'6/23','7','22','44','00000034','00012345678000000341','0','0'), (63,'7/23','7','22','44','00000035','00012345678000000352','0','0'), (64,'8/23','7','22','44','00000036','00012345678000000363','0','0'), (65,'9/23','7','22','44','00000037','00012345678000000374','0','0'), (66,'10/23','7','22','44','00000038','00012345678000000385','0','0'), (67,'11/23','7','22','44','00000039','00012345678000000394','0','0'), (68,'12/23','7','22','44','00000040','00012345678000000400','0','0'), (69,'13/23','7','22','44','00000041','00012345678000000411','0','0'), (70,'14/23','7','22','44','00000042','00012345678000000422','0','0'), (71,'15/23','7','22','44','00000043','00012345678000000433','0','0'), (72,'16/23','7','22','44','00000044','00012345678000000444','0','0'), (73,'17/23','7','22','44','00000045','00012345678000000455','0','0'), (74,'18/23','7','22','44','00000046','00012345678000000464','0','0'), (75,'19/23','7','22','44','00000047','00012345678000000473','0','0'), (76,'20/23','7','22','44','00000048','00012345678000000482','0','0'), (77,'21/23','7','22','44','00000049','00012345678000000491','0','0'), (78,'22/23','7','22','44','00000050','00012345678000000503','0','0'), (79,'23/23','7','22','44','00000051','00012345678000000514','0','0'), (80,'1/10','8','10','20','00000052','00012345678000000525','0','0'), (81,'2/10','8','10','20','00000053','00012345678000000534','0','0'), (82,'3/10','8','10','20','00000054','00012345678000000543','0','0'), (83,'4/10','8','10','20','00000055','00012345678000000552','0','0'), (84,'5/10','8','10','20','00000056','00012345678000000561','0','0'), (85,'6/10','8','10','20','00000057','00012345678000000570','0','0'), (86,'7/10','8','10','20','00000058','00012345678000000581','0','0'), (87,'8/10','8','10','20','00000059','00012345678000000592','0','0'), (88,'9/10','8','10','20','00000060','00012345678000000604','0','0'), (89,'10/10','8','10','20','00000061','00012345678000000613','0','0'), (90,'1/12','9','10','30','00000062','000000000620','0','0'), (91,'2/12','9','10','30','00000063','000000000631','0','0'), (92,'3/12','9','10','30','00000064','000000000642','0','0'), (93,'4/12','9','10','30','00000065','000000000653','0','0'), (94,'5/12','9','10','30','00000066','000000000664','0','0'), (95,'6/12','9','10','30','00000067','000000000675','0','0'), (96,'7/12','9','10','30','00000068','000000000684','0','0'), (97,'8/12','9','10','30','00000069','000000000693','0','0'), (98,'9/12','9','10','30','00000070','000000000701','0','0'), (99,'10/12','9','10','30','00000071','000000000712','0','0'), (100,'11/12','9','10','30','00000072','000000000723','0','0'), (101,'12/12','9','10','30','00000073','000000000734','0','0'), (102,'1/5','10','10','20','00000074','000000000745','0','0'), (103,'2/5','10','10','20','00000075','000000000754','0','0'), (104,'3/5','10','10','20','00000076','000000000763','0','0'), (105,'4/5','10','10','20','00000077','000000000772','0','0'), (106,'5/5','10','10','20','00000078','000000000781','0','0'), (107,'1/5','12','45','55','00000079','000000000790','0','0'), (108,'1/5','12','45','55','00000079','000000000790','0','0'), (109,'2/5','12','45','55','00000080','000000000806','0','0'), (110,'2/5','12','45','55','00000080','000000000806','0','0'), (111,'3/5','12','45','55','00000081','000000000815','0','0'), (112,'3/5','12','45','55','00000081','000000000815','0','0'), (113,'4/5','12','45','55','00000082','000000000824','0','0'), (114,'4/5','12','45','55','00000082','000000000824','0','0'), (115,'5/5','12','45','55','00000083','000000000833','0','0'), (116,'5/5','12','45','55','00000083','000000000833','0','0'), (117,'1/5','13','45','55','00000079','000000000790','0','0'), (118,'2/5','13','45','55','00000080','000000000806','0','0'), (119,'3/5','13','45','55','00000081','000000000815','0','0'), (120,'4/5','13','45','55','00000082','000000000824','0','0'), (121,'5/5','13','45','55','00000083','000000000833','0','0'), (122,'1/5','14','10','20','00000084','000000000842','0','0'), (123,'2/5','14','10','20','00000085','000000000851','0','0'), (124,'3/5','14','10','20','00000086','000000000860','0','0'), (125,'4/5','14','10','20','00000087','000000000879','0','0'), (126,'5/5','14','10','20','00000088','000000000888','0','0'), (127,'1/5','15','35','50','00000089','000000000897','0','0'), (128,'2/5','15','35','50','00000090','000000000903','0','0'), (129,'3/5','15','35','50','00000091','000000000912','0','0'), (130,'4/5','15','35','50','00000092','000000000921','0','0'), (131,'5/5','15','35','50','00000093','000000000930','0','0'), (132,'1/5','16','10','20','00000094','000000000949','0','0'), (133,'2/5','16','10','20','00000095','000000000958','0','0'), (134,'3/5','16','10','20','00000096','000000000967','0','0'), (135,'4/5','16','10','20','00000097','000000000976','0','0'), (136,'5/5','16','10','20','00000098','000000000985','0','0'), (137,'1/3','17','45','55','00000099','000000000994','0','0'), (138,'2/3','17','45','55','00000100','000000001009','0','0'), (139,'3/3','17','45','55','00000101','000000001018','0','0'), (140,'1/5','18','42','52','00000102','000000001027','0','0'), (141,'2/5','18','42','52','00000103','000000001036','0','0'), (142,'3/5','18','42','52','00000104','000000001045','0','0'), (143,'4/5','18','42','52','00000105','000000001054','0','0'), (144,'5/5','18','42','52','00000106','000000001063','0','0'), (145,'2/5','19','45','60','00000108','000000001081','0','0'), (146,'3/5','19','45','60','00000109','000000001090','0','0'), (147,'4/5','19','45','60','00000110','000000001106','0','0'), (148,'5/5','19','45','60','00000111','000000001115','0','0'), (149,'1/5','20','16','28','00000112','000000001124','0','0'), (150,'2/5','20','16','28','00000113','000000001133','0','0'), (151,'3/5','20','16','28','00000114','000000001142','0','0'), (152,'4/5','20','16','28','00000115','000000001151','0','0'), (153,'5/5','20','16','28','00000116','000000001160','0','0'), (154,'1/3','21','120','132','00000117','000000001179','0','0'), (155,'2/3','21','120','132','00000118','000000001188','0','0'), (156,'3/3','21','120','132','00000119','000000001197','0','0'), (157,'1/3','22','120','138','00000120','000000001203','0','0'), (158,'2/3','22','120','138','00000121','000000001212','0','0'), (159,'3/3','22','120','138','00000122','000000001221','0','0'), (160,'1/2','23','120','138','00000123','000000001230','0','0'), (161,'2/2','23','120','138','00000124','000000001249','0','0'), (162,'1/3','24','111','129','00000125','000000001258','0','0'), (163,'2/3','24','111','129','00000126','000000001267','0','0'), (164,'3/3','24','111','129','00000127','000000001276','0','0'), (165,'1/3','25','120','132','00000128','000000001285','0','0'), (166,'2/3','25','120','132','00000129','000000001294','0','0'), (167,'3/3','25','120','132','00000130','000000001300','0','0'), (168,'1/3','26','102','114','00000131','000000001319','0','0'), (169,'2/3','26','102','114','00000132','000000001328','0','0'), (170,'3/3','26','102','114','00000133','000000001337','0','0'), (171,'1/3','27','102','114','00000134','000000001346','0','0'), (172,'2/3','27','102','114','00000135','000000001355','0','0'), (173,'3/3','27','102','114','00000136','000000001364','0','0'), (174,'1/3','28','102','114','00000137','000000001373','0','0'), (175,'2/3','28','102','114','00000138','000000001382','0','0'), (176,'3/3','28','102','114','00000139','000000001391','0','0'), (177,'1/4','29','545','563','00000140','000000001407','0','0'), (178,'2/4','29','545','563','00000141','000000001416','0','0'), (179,'3/4','29','545','563','00000142','000000001425','0','0'), (180,'4/4','29','545','563','00000143','000000001434','0','0'), (181,'2/3','30','34','46','00000145','000000001452','0','0'), (182,'3/3','30','34','46','00000146','000000001461','0','0'), (183,'1/5','31','120','138','00000147','000000001470','0','0'), (184,'2/5','31','120','138','00000148','000000001489','0','0'), (185,'3/5','31','120','138','00000149','000000001498','0','0'), (186,'4/5','31','120','138','00000150','000000001504','0','0'), (187,'5/5','31','120','138','00000151','000000001513','0','0'), (188,'1/3','32','132','150','00000152','000000001522','0','0'), (189,'2/3','32','132','150','00000153','000000001531','0','0'), (190,'3/3','32','132','150','00000154','000000001540','0','0'), (191,'1/3','33','333','351','00000155','000000001559','0','0'), (192,'2/3','33','333','351','00000156','000000001568','0','0'), (193,'3/3','33','333','351','00000157','000000001577','0','0'), (194,'1/2','34','222','234','00000158','000000001586','0','0'), (195,'2/2','34','222','234','00000159','000000001595','0','0'), (196,'1/3','35','123','141','00000160','000000001601','0','0'), (197,'2/3','35','123','141','00000161','000000001610','0','0'), (198,'3/3','35','123','141','00000162','000000001629','0','0'), (199,'1/5','36','125.2','137.2','00000163','000000001638','0','0'), (200,'2/5','36','125.2','137.2','00000164','000000001647','0','0'), (201,'3/5','36','125.2','137.2','00000165','000000001656','0','0'), (202,'4/5','36','125.2','137.2','00000166','000000001665','0','0'), (203,'5/5','36','125.2','137.2','00000167','000000001674','0','0'), (204,'1/3','37','120','240','00000168','000000001683','0','0'), (205,'2/3','37','120','240','00000169','000000001692','0','0'), (206,'3/3','37','120','240','00000170','000000001708','0','0'), (207,'1/3','38','120','132','00000171','000000001717','0','0'), (208,'2/3','38','120','132','00000172','000000001726','0','0'), (209,'3/3','38','120','132','00000173','000000001735','0','0'), (210,'1/2','39','180','198','00000174','000000001744','0','0'), (211,'2/2','39','180','198','00000175','000000001753','0','0'), (212,'1/3','40','156','276','00000176','000000001762','0','0'), (213,'2/3','40','156','276','00000177','000000001771','0','0'), (214,'3/3','40','156','276','00000178','000000001780','0','0'), (215,'1/3','41','200','212','00000179','000000001799','0','0'), (216,'2/3','41','200','212','00000180','000000001805','0','0'), (217,'3/3','41','200','212','00000181','000000001814','0','0'), (218,'1/3','42','150','162','00000182','000000001823','0','0'), (219,'2/3','42','150','162','00000183','000000001832','0','0'), (220,'3/3','42','150','162','00000184','000000001841','0','0'), (221,'1/3','43','5','17','00000185','000000001850','0','0'), (222,'2/3','43','5','17','00000186','000000001869','0','0'), (223,'3/3','43','5','17','000','000000001878','0','0'), (224,'1/3','44','1580','1700','001','0478965230013','0','0'), (225,'2/3','44','1580','1700','002','0478965230020','0','0'), (226,'3/3','44','1580','1700','003','0478965230037','0','0'), (227,'1/5','45','152','272','004','0478965230044','0','0'), (228,'2/5','45','152','272','005','0478965230051','0','0'), (229,'3/5','45','152','272','006','0478965230068','0','0'), (230,'4/5','45','152','272','007','0478965230075','0','0'), (231,'5/5','45','152','272','008','0478965230082','0','0'), (232,'1/8','46','158','278','001','0478965230013','0','0'), (233,'2/8','46','158','278','002','0478965230020','0','0'), (234,'3/8','46','158','278','003','0478965230037','0','0'), (235,'4/8','46','158','278','004','0478965230044','0','0'), (236,'5/8','46','158','278','005','0478965230051','0','0'), (237,'6/8','46','158','278','006','0478965230068','0','0'), (238,'7/8','46','158','278','007','0478965230075','0','0'), (239,'8/8','46','158','278','008','0478965230082','0','0'), (240,'1/9','47','150','270','009','0478965230099','0','0'), (241,'2/9','47','150','270','010','0478965230105','0','0'), (242,'3/9','47','150','270','011','0478965230112','0','0'), (243,'4/9','47','150','270','012','0478965230129','0','0'), (244,'5/9','47','150','270','013','0478965230136','0','0'), (245,'6/9','47','150','270','014','0478965230143','0','0'), (246,'7/9','47','150','270','015','0478965230150','0','0'), (247,'8/9','47','150','270','016','0478965230167','0','0'), (248,'9/9','47','150','270','017','0478965230174','0','0'), (249,'1/10','48','1450','2300','001','085485550015','0','0'), (250,'2/10','48','1450','2300','002','085485550024','0','0'), (251,'3/10','48','1450','2300','003','085485550033','0','0'), (252,'4/10','48','1450','2300','004','085485550042','0','0'), (253,'5/10','48','1450','2300','005','085485550051','0','0'), (254,'6/10','48','1450','2300','006','085485550060','0','0'), (255,'7/10','48','1450','2300','007','085485550079','0','0'), (256,'8/10','48','1450','2300','008','085485550088','0','0'), (257,'9/10','48','1450','2300','009','085485550097','0','0'), (258,'10/10','48','1450','2300','010','085485550103','0','0'), (259,'1/5','49','520','1370','011','085485550112','0','0'), (260,'2/5','49','520','1370','012','085485550121','0','0'), (261,'3/5','49','520','1370','013','085485550130','0','0'), (262,'4/5','49','520','1370','014','085485550149','0','0'), (263,'5/5','49','520','1370','015','085485550158','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=646 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'); /*!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, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=37 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`) 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'), (29,'WebMedia India','WebMedia','DGWEB','GTINWEB','Railway Station',NULL,'Amravati','2024-04-08 15:27:22',NULL,NULL), (30,'ZapsTravel','Zaps','DGZT1230','GTIN1001','Hyderabad',NULL,'Hyderabad','2024-04-10 12:16:06',NULL,'3'), (31,'WEB MEDIA INDIA 2','Web Media','DGWB','GTINWB','Railway Station ',NULL,'Amravati','2024-04-10 15:11:12',NULL,NULL), (32,'Zeeshan Co Ltd','Zeeshan Ltd','DGAMTZC','123654987','Amravati',NULL,'Amravati','2024-04-14 16:55:14',NULL,'29'), (33,'Web Media Amravati Ltd','Web Media Amravati Ltd','GDWEB1122','333333','Railway Station',NULL,'Amravati','2024-04-16 18:10:00',NULL,'3'), (34,'Web Media India Ltd','Web Media India Ltd','GDWEB111','555555','Railway Station ',NULL,'Amravati','2024-04-16 18:22:25',NULL,'11'), (35,'ABC','ABC','DG','43334','XYZ',NULL,'ZXY','2024-04-17 13:07:54',NULL,'28'), (36,'A','E','D','F','B',NULL,'C','2024-04-17 13:28:09',NULL,'11'); /*!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, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=205 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`) VALUES (1,'3','32','addproduct','1','2024-04-03 11:59:47',NULL,NULL,NULL,NULL), (2,'11','32','addproduct','1','2024-04-03 11:59:47',NULL,NULL,NULL,NULL), (3,'3','38','addproduct','1','2024-04-03 13:23:50',NULL,NULL,NULL,NULL), (4,'11','38','addproduct','1','2024-04-03 13:23:50',NULL,NULL,NULL,NULL), (5,'4','38','addproduct','1','2024-04-03 13:23:50',NULL,NULL,NULL,NULL), (6,'17','38','addproduct','1','2024-04-03 13:23:51',NULL,NULL,NULL,NULL), (7,'21','38','addproduct','1','2024-04-03 13:23:51',NULL,NULL,NULL,NULL), (8,'3','39','addproduct','1','2024-04-03 13:24:59',NULL,'Quality i not upto the mark',NULL,NULL), (9,'11','39','addproduct','1','2024-04-03 13:24:59',NULL,NULL,NULL,NULL), (10,'4','39','addproduct','1','2024-04-03 13:24:59',NULL,NULL,NULL,NULL), (11,'17','39','addproduct','1','2024-04-03 13:24:59',NULL,NULL,NULL,NULL), (12,'21','39','addproduct','1','2024-04-03 13:24:59',NULL,NULL,NULL,NULL), (13,'','24','addproduct','1','2024-04-03 13:30:47',NULL,NULL,NULL,NULL), (14,'','24','addproduct','1','2024-04-03 13:30:47',NULL,NULL,NULL,NULL), (15,'','24','addproduct','1','2024-04-03 13:30:47',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), (17,'11','24','product','1','2024-04-03 14:11:11',NULL,NULL,NULL,NULL), (18,'4','24','product','1','2024-04-03 14:11:11',NULL,NULL,NULL,NULL), (19,'17','24','product','1','2024-04-03 14:11:11',NULL,NULL,NULL,NULL), (20,'21','24','product','1','2024-04-03 14:11:11',NULL,NULL,NULL,NULL), (21,'','37','pbatch','1','2024-04-03 14:12:07',NULL,NULL,NULL,NULL), (22,'','37','pbatch','0','2024-04-03 14:12:07',NULL,NULL,NULL,NULL), (23,'17','37','pbatch','0','2024-04-03 14:12:07',NULL,NULL,NULL,NULL), (24,'21','37','pbatch','0','2024-04-03 14:12:07',NULL,NULL,NULL,NULL), (25,'','19','customer','1','2024-04-03 14:13:03',NULL,NULL,NULL,NULL), (26,'','19','customer','0','2024-04-03 14:13:03',NULL,NULL,NULL,NULL), (27,'','19','customer','0','2024-04-03 14:13:03',NULL,NULL,NULL,NULL), (28,'3','40','addproduct','1','2024-04-03 14:23:14','2024-04-08 14:53:27',NULL,NULL,NULL), (29,'11','40','addproduct','1','2024-04-03 14:23:14',NULL,NULL,NULL,NULL), (30,'4','40','addproduct','1','2024-04-03 14:23:14',NULL,NULL,NULL,NULL), (31,'17','40','addproduct','0','2024-04-03 14:23:14',NULL,NULL,NULL,NULL), (32,'21','40','addproduct','1','2024-04-03 14:23:14',NULL,NULL,NULL,NULL), (33,'','42','addproduct','1','2024-04-03 16:31:19',NULL,NULL,NULL,NULL), (34,'','42','addproduct','1','2024-04-03 16:31:19',NULL,NULL,NULL,NULL), (35,'','42','addproduct','1','2024-04-03 16:31:19',NULL,NULL,NULL,NULL), (36,'','43','addproduct','1','2024-04-03 17:05:05',NULL,NULL,NULL,NULL), (37,'','43','addproduct','1','2024-04-03 17:05:05',NULL,NULL,NULL,NULL), (38,'','43','addproduct','1','2024-04-03 17:05:05',NULL,NULL,NULL,NULL), (39,'1','44','addproduct','1','2024-04-03 17:10:21',NULL,NULL,NULL,NULL), (40,'2','44','addproduct','1','2024-04-03 17:10:36',NULL,NULL,NULL,NULL), (41,'1','44','addproduct','1','2024-04-03 17:10:53',NULL,NULL,NULL,NULL), (42,'2','44','addproduct','1','2024-04-03 17:10:59',NULL,NULL,NULL,NULL), (43,'2','44','addproduct','1','2024-04-03 17:11:14',NULL,NULL,NULL,NULL), (44,'1','25','manufacture','1','2024-04-04 12:33:49',NULL,'',NULL,NULL), (45,'2','25','manufacture','0','2024-04-04 12:33:49',NULL,NULL,NULL,NULL), (46,'1','25','manufacture','0','2024-04-04 12:33:49',NULL,'',NULL,NULL), (47,'2','25','manufacture','0','2024-04-04 12:33:49',NULL,NULL,NULL,NULL), (48,'2','25','manufacture','0','2024-04-04 12:33:49',NULL,NULL,NULL,NULL), (52,'','21','customer','1','2024-04-04 12:40:18',NULL,NULL,NULL,NULL), (53,'','21','customer','0','2024-04-04 12:40:18',NULL,NULL,NULL,NULL), (54,'','21','customer','0','2024-04-04 12:40:18',NULL,NULL,NULL,NULL), (55,'','42','generateqr','1','2024-04-08 12:03:14',NULL,NULL,NULL,'LAX/0424/042'), (56,'','42','generateqr','0','2024-04-08 12:03:14',NULL,NULL,NULL,'LAX/0424/042'), (57,'','42','generateqr','0','2024-04-08 12:03:14',NULL,NULL,NULL,'LAX/0424/042'), (58,'11','22','customer','1','2024-04-08 12:08:50','2024-04-08 14:35:54',NULL,NULL,'Sahl Khan'), (59,'4','22','customer','0','2024-04-08 12:09:42',NULL,NULL,NULL,'Sahl Khan'), (60,'17','22','customer','0','2024-04-08 12:09:52',NULL,NULL,NULL,'Sahl Khan'), (64,'','27','manufacture','1','2024-04-08 15:07:30',NULL,NULL,NULL,'WebMedia India'), (65,'','27','manufacture','0','2024-04-08 15:07:30',NULL,NULL,NULL,'WebMedia India'), (66,'','27','manufacture','0','2024-04-08 15:07:30',NULL,NULL,NULL,'WebMedia India'), (67,'3','28','manufacture','1','2024-04-08 15:16:30','2024-04-08 15:17:52',NULL,NULL,'WebMedia India'), (68,'24','28','manufacture','0','2024-04-08 15:17:07',NULL,NULL,NULL,'WebMedia India'), (69,'17','28','manufacture','0','2024-04-08 15:17:10',NULL,NULL,NULL,'WebMedia India'), (70,'3','29','manufacture','1','2024-04-08 15:27:22',NULL,NULL,NULL,'WebMedia India'), (71,'24','29','manufacture','0','2024-04-08 15:27:22',NULL,NULL,NULL,'WebMedia India'), (72,'17','29','manufacture','0','2024-04-08 15:27:22',NULL,NULL,NULL,'WebMedia India'), (73,'','25','product','1','2024-04-08 15:28:49',NULL,NULL,NULL,'LaxacemProject'), (74,'','25','product','0','2024-04-08 15:28:49',NULL,NULL,NULL,'LaxacemProject'), (75,'','25','product','0','2024-04-08 15:28:49',NULL,NULL,NULL,'LaxacemProject'), (76,'3','26','product','1','2024-04-08 15:31:47',NULL,NULL,NULL,'LaxachemProject'), (77,'3','26','product','0','2024-04-08 15:32:53',NULL,NULL,NULL,'LaxachemProject'), (78,'','26','product','0','2024-04-08 15:33:45',NULL,NULL,NULL,'LaxachemProject'), (79,'','26','product','0','2024-04-08 15:33:59',NULL,NULL,NULL,'LaxachemProject'), (80,'3','38','pbatch','1','2024-04-08 15:36:20',NULL,NULL,NULL,'LAXAP01'), (81,'','38','pbatch','0','2024-04-08 15:36:20',NULL,NULL,NULL,'LAXAP01'), (82,'','38','pbatch','0','2024-04-08 15:36:20',NULL,NULL,NULL,'LAXAP01'), (83,'3','23','customer','1','2024-04-08 15:37:33',NULL,NULL,NULL,'Pratik Mohod'), (84,'','23','customer','0','2024-04-08 15:37:33',NULL,NULL,NULL,'Pratik Mohod'), (85,'','23','customer','0','2024-04-08 15:37:33',NULL,NULL,NULL,'Pratik Mohod'), (86,'3','45','addproduct','1','2024-04-08 15:38:02',NULL,NULL,NULL,'laxapro'), (87,'','45','addproduct','1','2024-04-08 15:38:02',NULL,NULL,NULL,'laxapro'), (88,'','45','addproduct','1','2024-04-08 15:38:02',NULL,NULL,NULL,'laxapro'), (89,'3','27','product','1','2024-04-08 15:39:17',NULL,NULL,NULL,'CofeeSofil'), (90,'3','27','product','0','2024-04-08 15:39:17',NULL,NULL,NULL,'CofeeSofil'), (91,'','27','product','0','2024-04-08 15:39:17',NULL,NULL,NULL,'CofeeSofil'), (92,'','27','product','0','2024-04-08 15:39:17',NULL,NULL,NULL,'CofeeSofil'), (93,'','28','product','1','2024-04-09 14:24:47',NULL,NULL,NULL,'Keyboard'), (94,'','28','product','0','2024-04-09 14:24:47',NULL,NULL,NULL,'Keyboard'), (95,'','28','product','0','2024-04-09 14:24:47',NULL,NULL,NULL,'Keyboard'), (96,'3','30','manufacture','1','2024-04-10 12:16:06','2024-04-10 13:25:55',NULL,NULL,'ZapsTravel'), (97,'','30','manufacture','0','2024-04-10 12:16:06',NULL,NULL,NULL,'ZapsTravel'), (98,'','30','manufacture','0','2024-04-10 12:16:06',NULL,NULL,NULL,'ZapsTravel'), (99,'','29','product','0','2024-04-10 12:17:41',NULL,NULL,NULL,'TravelBus'), (100,'','29','product','0','2024-04-10 12:17:41',NULL,NULL,NULL,'TravelBus'), (101,'','29','product','0','2024-04-10 12:17:41',NULL,NULL,NULL,'TravelBus'), (102,'3','30','product','1','2024-04-10 12:21:23','2024-04-10 13:26:04',NULL,NULL,'ZapsMaster'), (103,'3','30','product','1','2024-04-10 12:21:23','2024-04-10 13:25:59',NULL,NULL,'ZapsMaster'), (104,'','30','product','0','2024-04-10 12:21:23',NULL,NULL,NULL,'ZapsMaster'), (105,'','30','product','0','2024-04-10 12:21:23',NULL,NULL,NULL,'ZapsMaster'), (106,'3','39','pbatch','0','2024-04-10 13:26:51',NULL,NULL,NULL,'ZAPSBATCH'), (107,'','39','pbatch','0','2024-04-10 13:26:51',NULL,NULL,NULL,'ZAPSBATCH'), (108,'','39','pbatch','0','2024-04-10 13:26:51',NULL,NULL,NULL,'ZAPSBATCH'), (109,'3','24','customer','0','2024-04-10 13:28:19',NULL,NULL,NULL,'Vivek Gedam'), (110,'','24','customer','0','2024-04-10 13:28:19',NULL,NULL,NULL,'Vivek Gedam'), (111,'','24','customer','0','2024-04-10 13:28:19',NULL,NULL,NULL,'Vivek Gedam'), (112,'3','46','addproduct','1','2024-04-10 13:28:35',NULL,NULL,NULL,'AliasZAPS'), (113,'','46','addproduct','1','2024-04-10 13:28:35',NULL,NULL,NULL,'AliasZAPS'), (114,'','46','addproduct','1','2024-04-10 13:28:35',NULL,NULL,NULL,'AliasZAPS'), (115,'3','31','manufacture','1','2024-04-10 15:11:12','2024-04-10 15:13:13',NULL,NULL,'WEB MEDIA INDIA 2'), (116,'','31','manufacture','0','2024-04-10 15:11:12',NULL,NULL,NULL,'WEB MEDIA INDIA 2'), (117,'','31','manufacture','0','2024-04-10 15:11:12',NULL,NULL,NULL,'WEB MEDIA INDIA 2'), (118,'3','31','product','0','2024-04-10 15:12:11',NULL,NULL,NULL,'ShreeNetra'), (119,'3','31','product','1','2024-04-10 15:12:11','2024-04-10 15:13:07',NULL,NULL,'ShreeNetra'), (120,'','31','product','0','2024-04-10 15:12:11',NULL,NULL,NULL,'ShreeNetra'), (121,'','31','product','0','2024-04-10 15:12:11',NULL,NULL,NULL,'ShreeNetra'), (122,'3','40','pbatch','0','2024-04-10 15:14:18',NULL,NULL,NULL,'SHREEB01'), (123,'','40','pbatch','0','2024-04-10 15:14:18',NULL,NULL,NULL,'SHREEB01'), (124,'','40','pbatch','0','2024-04-10 15:14:18',NULL,NULL,NULL,'SHREEB01'), (125,'3','25','customer','0','2024-04-10 15:15:04',NULL,NULL,NULL,'Mayuri'), (126,'','25','customer','0','2024-04-10 15:15:04',NULL,NULL,NULL,'Mayuri'), (127,'','25','customer','0','2024-04-10 15:15:04',NULL,NULL,NULL,'Mayuri'), (128,'3','47','addproduct','0','2024-04-10 15:15:22',NULL,NULL,NULL,'APSHREENETRA'), (129,'','47','addproduct','0','2024-04-10 15:15:22',NULL,NULL,NULL,'APSHREENETRA'), (130,'','47','addproduct','0','2024-04-10 15:15:22',NULL,NULL,NULL,'APSHREENETRA'), (131,'','41','pbatch','1','2024-04-12 16:06:27',NULL,NULL,NULL,'ALPHA1001'), (132,'','41','pbatch','1','2024-04-12 16:06:27',NULL,NULL,NULL,'ALPHA1001'), (133,'','41','pbatch','1','2024-04-12 16:06:27',NULL,NULL,NULL,'ALPHA1001'), (134,'','43','generateqr','0','2024-04-12 16:11:14',NULL,NULL,NULL,'LAX/0424/043'), (135,'','43','generateqr','0','2024-04-12 16:11:14',NULL,NULL,NULL,'LAX/0424/043'), (136,'','43','generateqr','0','2024-04-12 16:11:14',NULL,NULL,NULL,'LAX/0424/043'), (137,'3','32','product','1','2024-04-12 17:55:42','2024-04-12 17:57:15',NULL,NULL,'NicotinAlpha'), (138,'3','32','product','1','2024-04-12 17:55:42','2024-04-12 17:56:14',NULL,NULL,'NicotinAlpha'), (139,'','32','product','1','2024-04-12 17:55:42',NULL,NULL,NULL,'NicotinAlpha'), (140,'','32','product','1','2024-04-12 17:55:42',NULL,NULL,NULL,'NicotinAlpha'), (141,'3','48','addproduct','1','2024-04-12 17:59:36','2024-04-12 17:59:49',NULL,NULL,'NICOALPHA'), (142,'','48','addproduct','0','2024-04-12 17:59:36',NULL,NULL,NULL,'NICOALPHA'), (143,'','48','addproduct','0','2024-04-12 17:59:36',NULL,NULL,NULL,'NICOALPHA'), (144,'3','42','pbatch','1','2024-04-12 18:11:08','2024-04-12 18:11:22',NULL,NULL,'NICOALPHAB'), (145,'','42','pbatch','1','2024-04-12 18:11:08',NULL,NULL,NULL,'NICOALPHAB'), (146,'','42','pbatch','1','2024-04-12 18:11:08',NULL,NULL,NULL,'NICOALPHAB'), (155,'3','35','product','0','2024-04-14 15:37:01',NULL,NULL,NULL,'Headphones'), (156,'3','35','product','0','2024-04-14 15:37:01',NULL,NULL,NULL,'Headphones'), (157,'','35','product','0','2024-04-14 15:37:01',NULL,NULL,NULL,'Headphones'), (158,'','35','product','0','2024-04-14 15:37:01',NULL,NULL,NULL,'Headphones'), (160,'3','36','product','0','2024-04-14 16:40:55',NULL,NULL,NULL,'ZeroTIn'), (161,'','36','product','0','2024-04-14 16:40:55',NULL,NULL,NULL,'ZeroTIn'), (162,'','36','product','0','2024-04-14 16:40:55',NULL,NULL,NULL,'ZeroTIn'), (163,'3','37','product','0','2024-04-14 16:45:51',NULL,NULL,NULL,'Zerotin Alpha'), (164,'3','37','product','0','2024-04-14 16:45:51',NULL,NULL,NULL,'Zerotin Alpha'), (165,'','37','product','0','2024-04-14 16:45:51',NULL,NULL,NULL,'Zerotin Alpha'), (166,'','37','product','0','2024-04-14 16:45:51',NULL,NULL,NULL,'Zerotin Alpha'), (167,'3','38','product','0','2024-04-14 16:48:03',NULL,NULL,NULL,'A'), (168,'3','38','product','0','2024-04-14 16:48:09',NULL,NULL,NULL,'A'), (169,'3','39','product','0','2024-04-14 16:51:57',NULL,NULL,NULL,'a'), (170,'3','39','product','0','2024-04-14 16:52:00',NULL,NULL,NULL,'a'), (171,'3','32','manufacture','1','2024-04-14 16:55:14','2024-04-14 16:56:50',NULL,NULL,'Zeeshan Co Ltd'), (172,'','32','manufacture','0','2024-04-14 16:55:14',NULL,NULL,NULL,'Zeeshan Co Ltd'), (173,'','32','manufacture','0','2024-04-14 16:55:14',NULL,NULL,NULL,'Zeeshan Co Ltd'), (174,'3','40','product','1','2024-04-14 16:56:06','2024-04-14 16:57:04',NULL,NULL,'ZeLight'), (175,'3','40','product','1','2024-04-14 16:56:06','2024-04-14 16:59:03',NULL,NULL,'ZeLight'), (176,'3','43','pbatch','0','2024-04-14 17:00:11',NULL,NULL,NULL,'ZELIGHTB'), (177,'','43','pbatch','0','2024-04-14 17:00:11',NULL,NULL,NULL,'ZELIGHTB'), (178,'','43','pbatch','0','2024-04-14 17:00:11',NULL,NULL,NULL,'ZELIGHTB'), (179,'3','49','addproduct','0','2024-04-14 17:05:42',NULL,NULL,NULL,'ZEEAlias'), (180,'3','41','product','0','2024-04-15 11:03:00',NULL,NULL,NULL,'Gemini'), (181,'3','45','pbatch','1','2024-04-16 12:30:59','2024-04-16 12:31:28',NULL,NULL,'ZEBATCH!'), (182,'3','50','addproduct','1','2024-04-16 12:32:08','2024-04-16 12:32:33',NULL,NULL,'ZEE123'), (183,'11','46','generateqr','0','2024-04-16 17:50:10',NULL,NULL,NULL,'LAX/0424/046'), (184,'11','46','generateqr','0','2024-04-16 17:50:10',NULL,NULL,NULL,'LAX/0424/046'), (185,'11','47','generateqr','0','2024-04-16 17:54:44',NULL,NULL,NULL,'LAX/0424/047'), (186,'11','47','generateqr','0','2024-04-16 17:54:44',NULL,NULL,NULL,'LAX/0424/047'), (187,'26','33','manufacture','0','2024-04-16 18:10:00',NULL,NULL,NULL,'Web Media Amravati Ltd'), (188,'3','33','manufacture','1','2024-04-16 18:10:00','2024-04-16 18:10:17',NULL,NULL,'Web Media Amravati Ltd'), (189,'24','33','manufacture','0','2024-04-16 18:10:00',NULL,NULL,NULL,'Web Media Amravati Ltd'), (190,'4','33','manufacture','0','2024-04-16 18:10:00',NULL,NULL,NULL,'Web Media Amravati Ltd'), (191,'17','33','manufacture','0','2024-04-16 18:10:00',NULL,NULL,NULL,'Web Media Amravati Ltd'), (192,'26','42','product','0','2024-04-16 18:11:10',NULL,NULL,NULL,'Hello Phones'), (193,'11','34','manufacture','1','2024-04-16 18:22:25','2024-04-16 18:22:39',NULL,NULL,'Web Media India Ltd'), (194,'11','43','product','1','2024-04-16 18:23:32','2024-04-16 18:23:39',NULL,NULL,'Hello Phones'), (195,'11','46','pbatch','1','2024-04-16 18:24:16','2024-04-16 18:24:22',NULL,NULL,'HBATCH'), (196,'11','51','addproduct','1','2024-04-16 18:24:45','2024-04-16 18:25:01',NULL,NULL,'HP ALIAS'), (197,'11','48','generateqr','1','2024-04-16 18:25:27','2024-04-16 18:26:24',NULL,NULL,'LAX/0424/048'), (198,'11','48','generateqr','1','2024-04-16 18:25:27','2024-04-16 18:26:28',NULL,NULL,'LAX/0424/048'), (199,'11','49','generateqr','-1','2024-04-16 18:27:34',NULL,'Wrong Lot Number','2024-04-17 13:56:54','LAX/0424/049'), (200,'11','49','generateqr','-1','2024-04-16 18:27:34',NULL,'Wrong Lot','2024-04-17 13:56:00','LAX/0424/049'), (201,'26','35','manufacture','0','2024-04-17 13:07:54',NULL,NULL,NULL,'ABC'), (202,'4','35','manufacture','0','2024-04-17 13:07:54',NULL,NULL,NULL,'ABC'), (203,'17','35','manufacture','0','2024-04-17 13:07:54',NULL,NULL,NULL,'ABC'), (204,'11','36','manufacture','0','2024-04-17 13:28:09',NULL,NULL,NULL,'A'); /*!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, 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`) VALUES (1,'1234','2','2334','442','2023-10-16 00:00:00','2023-10-16 00:00:00','','','BP',NULL,NULL,'3'), (3,'fada','2','1313','131313','2023-10-16 00:00:00','2023-10-16 00:00:00','','','IP',NULL,NULL,NULL), (4,'scff','2','dgdg','133131','2023-10-16 00:00:00','2023-10-16 00:00:00','','','BP',NULL,NULL,NULL), (5,'113','2','13','313','1333-12-03 00:00:00','2023-10-16 00:00:00','','','BP',NULL,NULL,NULL), (6,'0303','2','3030','30303','2023-03-03 00:00:00','3033-03-16 00:00:00','','','IP',NULL,NULL,NULL), (7,'zgg','2','116','1616','2023-11-16 00:00:00','2023-10-16 00:00:00','','','BP',NULL,NULL,'3'), (8,'fafssa','6','agagadg','agagag','2023-12-01 00:00:00','2023-09-01 00:00:00','','','BP,EP',NULL,NULL,NULL), (9,'0303','2','3030','30303','2023-03-01 00:00:00','3033-03-01 00:00:00','','','IP,BP',NULL,NULL,NULL), (10,'fafssa','6','agagadg','agagag','2023-12-01 00:00:00','2023-09-01 00:00:00','','','IP,BP,EP',NULL,NULL,NULL), (11,'123','7','123','123','2023-11-01 00:00:00','2023-11-01 00:00:00','','','IP,BP',NULL,NULL,NULL), (12,'1313133','8','1313','11313','2024-01-01 00:00:00','2023-12-01 00:00:00','','','',NULL,NULL,NULL), (13,'1313','8','113','11313','2023-12-01 00:00:00','2023-12-01 00:00:00','','','EP',NULL,NULL,NULL), (14,'33','8','3','333','2023-12-01 00:00:00','2023-12-01 00:00:00','','','IP,BP',NULL,NULL,NULL), (15,'fsgs','7','shdsh','sdhdsd','2023-12-01 00:00:00','2023-12-01 00:00:00','','','IP,BP',NULL,NULL,'3'), (16,'gsd','2','dshds','dhdshds','2023-12-01 00:00:00','2023-12-01 00:00:00','','','USP',NULL,NULL,NULL), (18,'gd','4','dsgsg','dhdshsh','2024-02-01 00:00:00','2025-07-01 00:00:00','','','BP',NULL,NULL,NULL), (19,'rr','12','rqr','rqrqr','2023-12-01 00:00:00','2024-12-01 00:00:00','','','BP',NULL,NULL,NULL), (20,'B1111','13','10','IB1010','2024-03-01 00:00:00','2024-12-01 00:00:00','','','BP',NULL,NULL,NULL), (21,'B10010','14','12','BI10010','2024-03-01 00:00:00','2024-12-01 00:00:00','','','EP',NULL,NULL,NULL), (22,'B12345','15','10','IB12345','2024-01-01 00:00:00','2024-12-01 00:00:00','','','EP',NULL,NULL,NULL), (23,'B101896','15','12','IB101896','2024-02-01 00:00:00','2024-09-01 00:00:00','','','EP',NULL,NULL,'3'), (24,'BATCH01','17','12','IBATCH01','2024-02-01 00:00:00','2024-09-01 00:00:00','','','BP,USP',NULL,NULL,NULL), (25,'BATCH0002','18','18','IBATCH0002','2024-01-01 00:00:00','2024-05-01 00:00:00','','','IP,BP,EP,USP',NULL,NULL,NULL), (26,'Batch1010','18','10','Ibatch1010','2024-01-01 00:00:00','2024-10-01 00:00:00','','','BP',NULL,NULL,NULL), (27,'Batch1010','18','10','Ibatch1010','2024-01-01 00:00:00','2024-10-01 00:00:00','','','BP',NULL,NULL,NULL), (28,'Batch1010','18','10','Ibatch1010','2024-01-01 00:00:00','2024-10-01 00:00:00','','','BP',NULL,NULL,'3'), (29,'Batch1010','18','10','Ibatch1010','2024-01-01 00:00:00','2024-10-01 00:00:00','','','BP',NULL,NULL,NULL), (30,'Batch1010','18','10','Ibatch1010','2024-01-01 00:00:00','2024-10-01 00:00:00','','','BP',NULL,NULL,NULL), (31,'Batch1010','18','10','Ibatch1010','2024-01-01 00:00:00','2024-10-01 00:00:00','','','BP',NULL,NULL,NULL), (32,'b1111','18','10','ib1111','2024-01-01 00:00:00','2024-06-01 00:00:00','','','BP',NULL,NULL,NULL), (33,'b11111','18','10','ib1111','2024-01-01 00:00:00','2024-06-01 00:00:00','','','IP',NULL,NULL,NULL), (34,'Batch10101','18','18','IBATCH','2024-01-01 00:00:00','2024-05-01 00:00:00','','','IP,BP,EP,USP',NULL,NULL,NULL), (35,'Batch10111','18','12','ib10000','2024-01-01 00:00:00','2024-10-01 00:00:00','','','IP,BP',NULL,NULL,NULL), (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'), (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), (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), (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), (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'), (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'), (42,'NICOALPHAB','32','150','INICOALPHAB','2024-01-01 00:00:00','2024-05-01 00:00:00','','','USP','2024-04-12 18:11:08',NULL,'3'), (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'), (44,'ZEEBATCH','40','4150','IZEEBATCH','2024-01-01 00:00:00','2024-09-01 00:00:00','','','EP','2024-04-16 15:28:03','2024-04-16 15:28:03','3'), (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'), (46,'HBATCH','43','850','IBATCH','2024-01-01 00:00:00','2024-06-01 00:00:00','','','USP','2024-04-16 18:24:15',NULL,'11'); /*!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, 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`) 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'), (5,'sddgg','dgag','adgag','14','','gagagga','IP,EP,USP','','gag','agaga',NULL,NULL,NULL,NULL,NULL), (6,'sddgg','dgag','adgag','0','','gagagga','IP,BP,EP,USP','','IP,BP,EP,USP','dgsdgsd',NULL,NULL,NULL,NULL,NULL), (7,'tin','dummy','1313','15','','12','BP,EP,USP','','10,15,20',NULL,NULL,NULL,'3',NULL,NULL), (8,'feqfe','egeq','geqgeq','15,17','','fshfsh','BP,EP','','10,25,30','KG',NULL,NULL,NULL,NULL,NULL), (9,'gsfgsh','ffddj','jdfjdj','17','','fshfsh','BP','','2342','LTR',NULL,NULL,NULL,NULL,NULL), (10,'IC/1123/002','hfshs','ffsfs','15','','fjsjsfj','BP,EP','','faaf','KG',NULL,NULL,NULL,NULL,NULL), (11,'dhdh','hdh','ddh','15,17','12345678,agagad','hdf','IP,BP','','120','LTR',NULL,NULL,'3',NULL,NULL), (13,'TUSQXC','REFRILL','GTIN0011','19','LAXAM','KEEP IN DRY PLACES','BP','TQ','10','KG',NULL,NULL,NULL,NULL,NULL), (14,'COFIL','LAXACHEMICALS','GTIN02222','20','LAXACHEMICALS','KEEP IN COOL PLACES','EP','','15','KG',NULL,NULL,NULL,NULL,NULL), (15,'TULIP C','LAXACHEM','GTIN11214','15','12345678','KEEP IN COOL PLACES','EP','HYDEROSULPHATE','10','LTR',NULL,NULL,NULL,NULL,NULL), (16,'Chemchlo','laxachemm','GTIN9999','20','LAXACHEMICALS','NA','EP','Chem','12','KG',NULL,NULL,NULL,NULL,NULL), (17,'DUCOSATE SODIUM','Laxachem','GTIN120120','21','LAXACHEM','KEEP AWAY FROM CHILD','BP,USP','Dioclyle Sodium Sulfosuccinate','12','KG',NULL,NULL,NULL,NULL,NULL), (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), (19,'Suffocillicitate Drugnile Alpha ','Serum Institute','Gtin11000','23','Serum Institute','Keep In dry Places','IP','Suffocilliciate','12','KG',NULL,NULL,'3',NULL,NULL), (20,'Suffocillicitate Drugnile Alpha ','Serum Institute','Gtin11000','23','Serum Institute','Keep In dry Places','IP','Suffocilliciate','12','KG',NULL,NULL,NULL,NULL,NULL), (21,'Suffocillicitate Drugnile Alpha ','Serum Institute','Gtin11000','23','Serum Institute','Keep In dry Places','IP','Suffocilliciate','12','KG',NULL,NULL,NULL,NULL,NULL), (22,'Suffocicilate','fdsfdf','fdsfdsgf','22','LAXACHEM ORGANICS PVT. LTD.','dsdgdfg','EP','asddasf','33','KG',NULL,NULL,'3',NULL,NULL), (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'), (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'), (26,'LaxachemProject','WebMedia','GTINWEB','29','WebMedia','NA','USP','LaxaProject','12','KG','2024-04-08 15:31:22',NULL,'3','DOTNET','12'), (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'), (28,'Keyboard','Sony','SONYGTIN','29','WebMedia','NA','EP','QWERTR','12','KG','2024-04-09 14:24:47',NULL,NULL,'qwertr','120'), (29,'TravelBus','ZapTravel','GTINZAPS','30','Zaps','NA','EP','Bus','120','KG','2024-04-10 12:17:41',NULL,NULL,'NA','NA'), (30,'ZapsMaster','Zaps','ZAPSGTIN','30','Zaps','NA','EP','Master','12','KG','2024-04-10 12:21:23',NULL,'3','NA','NA'), (31,'ShreeNetra','Shree','SHREEGTIN','31','Web Media','NA','EP','NETRALAYA','152','KG','2024-04-10 15:12:11',NULL,NULL,'FORMULA','MOLWT'), (32,'NicotinAlpha','LAXA','1234567891254','22','LAXACHEM ORGANICS PVT. LTD.','NA','USP','Nicotin','125','KG','2024-04-12 17:55:42',NULL,'3','NA','NS'), (35,'Headphones','Zebronics','789654123','30','Zaps','Na','EP','Earphones','120','KG','2024-04-14 15:37:01',NULL,'3','NA','NA'), (36,'ZeroTIn','NOT DEFINED','123654','30','Zaps','NA','EP','Zerotin','120','KG','2024-04-14 16:37:44',NULL,'3','NA','NA'), (37,'Zerotin Alpha','LAXA','785412','30','Zaps','NA','BP','Z Alpha ','120','KG','2024-04-14 16:45:21',NULL,'3','NA','NA'), (40,'ZeLight','Zeshan LTD','47896523','32','Zeeshan Ltd','NA','EP','Light','120','KG','2024-04-14 16:56:06',NULL,'29','NA','NA'), (41,'Gemini','LAXA','758458','30','Zaps','NA','USP','Gemini','152','KG','2024-04-15 11:03:00',NULL,'30','NA','NA'), (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'), (43,'Hello Phones','Web Media India Ltd','8548555','33','Web Media Amravati Ltd','NA','USP','Hello','850','KG','2024-04-16 18:23:32',NULL,'11','NA','NA'); /*!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, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8; -- -- Dumping data for table returnstock -- /*!40000 ALTER TABLE `returnstock` DISABLE KEYS */; INSERT INTO `returnstock`(`id`,`lotno`,`remark`,`dor`,`created`,`updated`,`userid`) VALUES (17,'35','fgdfg','2024-03-22 00:00:00','2024-03-22 15:04:37','2024-03-22 15:04:37',NULL), (18,'34','','0001-01-01 00:00:00','2024-03-22 15:19:04','2024-03-22 15:19:04',NULL); /*!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, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 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`) VALUES (1,'34','000000001595','222','12','234','',NULL,'','2/2'); /*!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=32 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 (4,'admin1','1234','manufacturelocations,products,customer,generate,dispatch,batch,user,report','create,read','','','',NULL,NULL,'','create','','','','','','','','','','administration',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,'Pratik',NULL,NULL,NULL), (11,'admin2','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','11','11','','11','11','11','11','','','','','','','','','','','','','','','','','','','','','','','Ashmira','Show','Show','28,27,11'), (17,'admin3','2345','manufacturelocations,products','','','','',NULL,NULL,'','create','','','','','','','','','','quality assurance',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,'Mayuri',NULL,NULL,NULL), (24,'admin11','1234','','delete','edit','read','',NULL,NULL,'','','','','create','','','','','','','Administration','','11','','','','','11','',NULL,NULL,'','4','','','24','','',NULL,NULL,'','21','','','','17','17','',NULL,NULL,'Waseem',NULL,NULL,NULL), (25,'subhda1','1235','','create,read','create,read','create,read','',NULL,NULL,'','create','','create,read','create,read','','','','','','','User','3','3','','','3','3','3,3','',NULL,NULL,'','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,'Subhda Radke','Hide',NULL,NULL), (26,'kapil1','123','','create','create','create','',NULL,NULL,'','create','','create','create','','','','','','','Admin','11,3','3','30,11','30','11,3','3','3','26','11','','','','','24,4','','','','','','','','','','','','','','','',' kapil','Hide','Hide',NULL), (27,'ptik','1234','','create','create','create','',NULL,NULL,'','create','','create','create','','','','','','create','User','3','26','','26','3','3','26,3','',NULL,NULL,'','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,'Pratik Mohod ','Hide','Show',NULL), (28,'csaraf','1234','','create','create','create','',NULL,NULL,'','create','','create','create','','','','','','','Administration','','','','','26','30','30','','','','','','','4','','24','','','','','','','','17','17','17','','','','Chetan Saraf','Hide','Hide','30,28,27'), (29,'zshan','1234','','create','create','create','',NULL,NULL,'','','','create','create','','','','','','','User','3','3','','11','3','3','3','','','3','','','','24','4','24','','','','','','','','17','17','17','','','','Zeshan','Hide','Hide',NULL), (30,'skhan','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','3','3','','3','3','3','3','3','','','','','','','','','','','','','','','','','','','','','','Sohel Khan','Hide','Hide',NULL), (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); /*!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-04-22 18:48:12 -- Total time: 0:0:0:0:111 (d:h:m:s:ms)