-- MySqlBackup.NET 2.0.4 -- Dump Time: 2024-10-15 17:37:32 -- -------------------------------------- -- Server version 8.0.16 MySQL Community Server - GPL /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Definition of aliasproduct -- DROP TABLE IF EXISTS `aliasproduct`; CREATE TABLE IF NOT EXISTS `aliasproduct` ( `id` int(11) NOT NULL AUTO_INCREMENT, `aliasproduct` varchar(255) DEFAULT NULL, `product` varchar(255) DEFAULT NULL, `productid` int(11) DEFAULT NULL, `created` datetime DEFAULT NULL, `updated` datetime DEFAULT NULL, `qa` varchar(50) DEFAULT NULL, `administration` varchar(50) DEFAULT NULL, `admin` varchar(50) DEFAULT NULL, `qatime` datetime DEFAULT NULL, `administtime` datetime DEFAULT NULL, `admintime` datetime DEFAULT NULL, `userid` varchar(50) DEFAULT NULL, `qaid` varchar(50) DEFAULT NULL, `adminisid` varchar(50) DEFAULT NULL, `adminid` varchar(50) DEFAULT NULL, `deletestatus` varchar(50) DEFAULT NULL, `apaprstatus` varchar(50) DEFAULT NULL, `aprejstatus` varchar(50) DEFAULT NULL, `aprtime` datetime DEFAULT NULL, `rejtime` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8; -- -- Dumping data for table aliasproduct -- /*!40000 ALTER TABLE `aliasproduct` DISABLE KEYS */; INSERT INTO `aliasproduct`(`id`,`aliasproduct`,`product`,`productid`,`created`,`updated`,`qa`,`administration`,`admin`,`qatime`,`administtime`,`admintime`,`userid`,`qaid`,`adminisid`,`adminid`,`deletestatus`,`apaprstatus`,`aprejstatus`,`aprtime`,`rejtime`) VALUES (1,'CHLOROBUTANOL','CHLOROBUTANOL',1,'2024-08-10 12:45:56',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'39',NULL,NULL,NULL,'0','1','0','2024-08-10 16:45:02',NULL), (2,'CHLORBUTOL','CHLOROBUTANOL',1,'2024-08-10 12:47:08',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'39',NULL,NULL,NULL,'0','1','0','2024-08-10 16:45:04',NULL), (3,'CHLORBUTOL (IND. USE ONLY)','CHLOROBUTANOL',1,'2024-08-14 19:41:56',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'39',NULL,NULL,NULL,'1','1','0','2024-08-17 11:16:53',NULL), (4,'FUROSEMIDE','FUROSEMIDE',6,'2024-08-17 11:18:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'39',NULL,NULL,NULL,'0','1','0','2024-08-17 11:18:53',NULL), (5,'DOCUSATE SODIUM','DOCUSATE SODIUM',2,'2024-09-18 09:45:19',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'39',NULL,NULL,NULL,'0','1','0','2024-09-18 09:45:25',NULL), (6,'DOCUSATE SODIUM 85%','DOCUSATE SODIUM 85% POWDER',3,'2024-09-18 12:50:44','2024-10-02 13:04:21',NULL,NULL,NULL,NULL,NULL,NULL,'39',NULL,NULL,NULL,'0','1','0','2024-10-02 13:04:27',NULL), (7,'-','PROPYL GALLATE',4,'2024-09-28 11:16:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'39',NULL,NULL,NULL,'0','1','0','2024-09-28 17:13:42',NULL), (8,'Test 1 Alias','Test 1',8,'2024-10-07 15:43:21',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'36',NULL,NULL,NULL,'0','1','0','2024-10-07 15:43:24',NULL); /*!40000 ALTER TABLE `aliasproduct` ENABLE KEYS */; -- -- Definition of consumedstock -- DROP TABLE IF EXISTS `consumedstock`; CREATE TABLE IF NOT EXISTS `consumedstock` ( `id` int(11) NOT NULL AUTO_INCREMENT, `batch` varchar(50) DEFAULT NULL, `comprodqty` varchar(50) DEFAULT NULL, `productid` varchar(50) DEFAULT NULL, `comprodid` varchar(50) DEFAULT NULL, `conbatch` varchar(50) DEFAULT NULL, `qty` varchar(50) DEFAULT NULL, `date` date DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- -- Dumping data for table consumedstock -- /*!40000 ALTER TABLE `consumedstock` DISABLE KEYS */; INSERT INTO `consumedstock`(`id`,`batch`,`comprodqty`,`productid`,`comprodid`,`conbatch`,`qty`,`date`) VALUES (1,'5','201','1','1','4','20','2024-01-26 00:00:00'); /*!40000 ALTER TABLE `consumedstock` ENABLE KEYS */; -- -- Definition of customer -- DROP TABLE IF EXISTS `customer`; CREATE TABLE IF NOT EXISTS `customer` ( `id` int(11) NOT NULL AUTO_INCREMENT, `custname` varchar(255) DEFAULT '', `gstin` varchar(255) DEFAULT '', `custadd` varchar(255) DEFAULT '', `custphone` varchar(255) DEFAULT '', `custemail` varchar(255) DEFAULT '', `created` datetime DEFAULT NULL, `updated` datetime DEFAULT NULL, `custdrug` varchar(255) DEFAULT '', `consiadd` varchar(255) DEFAULT '', `consiname` varchar(255) DEFAULT '', `consiemail` varchar(255) DEFAULT '', `consiphone` varchar(255) DEFAULT '', `consigst` varchar(255) DEFAULT '', `considrug` varchar(255) DEFAULT '', `displayname` varchar(255) DEFAULT '', `type` varchar(255) DEFAULT '', `userid` varchar(50) DEFAULT NULL, `deletestatus` varchar(50) DEFAULT NULL, `custaprstatus` varchar(50) DEFAULT NULL, `custrejstatus` varchar(50) DEFAULT NULL, `custaprtime` datetime DEFAULT NULL, `custrejtime` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table customer -- /*!40000 ALTER TABLE `customer` DISABLE KEYS */; /*!40000 ALTER TABLE `customer` ENABLE KEYS */; -- -- Definition of discardedstock -- DROP TABLE IF EXISTS `discardedstock`; CREATE TABLE IF NOT EXISTS `discardedstock` ( `id` int(11) NOT NULL AUTO_INCREMENT, `product` varchar(50) DEFAULT NULL, `batch` varchar(50) DEFAULT NULL, `quantity` varchar(50) DEFAULT NULL, `date` date DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- -- Dumping data for table discardedstock -- /*!40000 ALTER TABLE `discardedstock` DISABLE KEYS */; /*!40000 ALTER TABLE `discardedstock` ENABLE KEYS */; -- -- Definition of dispatch -- DROP TABLE IF EXISTS `dispatch`; CREATE TABLE IF NOT EXISTS `dispatch` ( `id` int(11) NOT NULL AUTO_INCREMENT, `lotno` varchar(255) DEFAULT '', `distype` varchar(255) DEFAULT '', `dod` date DEFAULT NULL, `bob` varchar(255) DEFAULT '', `dob` date DEFAULT NULL, `customer` varchar(255) DEFAULT NULL, `invoice` varchar(255) DEFAULT NULL, `created` datetime DEFAULT NULL, `updated` datetime DEFAULT NULL, `userid` varchar(50) DEFAULT NULL, `deletestatus` varchar(50) DEFAULT NULL, `disaprstatus` varchar(50) DEFAULT NULL, `disrejstatus` varchar(50) DEFAULT NULL, `disaprtime` datetime DEFAULT NULL, `disrejtime` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table dispatch -- /*!40000 ALTER TABLE `dispatch` DISABLE KEYS */; /*!40000 ALTER TABLE `dispatch` ENABLE KEYS */; -- -- Definition of generateqr -- DROP TABLE IF EXISTS `generateqr`; CREATE TABLE IF NOT EXISTS `generateqr` ( `id` int(11) NOT NULL AUTO_INCREMENT, `presetid` varchar(255) DEFAULT '', `genid` varchar(255) DEFAULT '', `title` varchar(255) DEFAULT '', `aliasproductid` varchar(255) DEFAULT '', `name` varchar(255) DEFAULT '', `formula1` varchar(255) DEFAULT '', `batch` varchar(255) DEFAULT '', `molwt` varchar(255) DEFAULT '', `grosswt` varchar(255) DEFAULT '', `tarewt` varchar(255) DEFAULT '', `netwt` varchar(255) DEFAULT '', `mfgdate` date DEFAULT NULL, `expdate` date DEFAULT NULL, `userid` varchar(50) DEFAULT NULL, `manuid` varchar(255) DEFAULT '', `contfrom` varchar(255) DEFAULT '', `contto` varchar(255) DEFAULT '', `contno` varchar(255) DEFAULT '', `grade` varchar(255) DEFAULT '', `pack` varchar(255) DEFAULT '', `ncont` varchar(255) DEFAULT '', `qrqty` varchar(255) DEFAULT '', `totalqty` varchar(255) DEFAULT '', `dispatch` varchar(255) DEFAULT '0', `returnst` varchar(255) DEFAULT '0', `aprstatus` varchar(255) DEFAULT '0', `qrrejstatus` varchar(255) DEFAULT '0', `lotdisaprstatus` varchar(255) DEFAULT '0', `lotdisrejstatus` varchar(255) DEFAULT '0', `lotcreatedate` date DEFAULT NULL, `qraprtime` datetime DEFAULT NULL, `qrrejtime` datetime DEFAULT NULL, `storagecon` varchar(255) DEFAULT NULL, `storageconid` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8; -- -- Dumping data for table generateqr -- /*!40000 ALTER TABLE `generateqr` DISABLE KEYS */; INSERT INTO `generateqr`(`id`,`presetid`,`genid`,`title`,`aliasproductid`,`name`,`formula1`,`batch`,`molwt`,`grosswt`,`tarewt`,`netwt`,`mfgdate`,`expdate`,`userid`,`manuid`,`contfrom`,`contto`,`contno`,`grade`,`pack`,`ncont`,`qrqty`,`totalqty`,`dispatch`,`returnst`,`aprstatus`,`qrrejstatus`,`lotdisaprstatus`,`lotdisrejstatus`,`lotcreatedate`,`qraprtime`,`qrrejtime`,`storagecon`,`storageconid`) VALUES (1,'1','LAX/0824/001','','1','','','4','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','BP','25','20','','500','0','0','1','0','0','0','2024-08-11 00:00:00','2024-08-11 16:16:38',NULL,'In an air tight container',NULL), (3,'1','LAX/0824/003','','2','','','5','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','25','12','','300','0','0','1','0','0','0','2024-08-17 00:00:00','2024-08-17 13:24:01',NULL,'Store protect from moisture at temperature not exceeding 30° C',NULL), (4,'1','LAX/0824/004','','2','','','5','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','25','2','','50','0','0','1','0','0','0','2024-08-21 00:00:00','2024-08-21 11:49:27',NULL,'Store protect from moisture at temperature not exceeding 30° C',NULL), (5,'1','LAX/0824/005','','2','','','5','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','25','1','','25','0','0','1','0','0','0','2024-08-21 00:00:00','2024-08-21 11:49:45',NULL,'Store protect from moisture at temperature not exceeding 30° C',NULL), (6,'1','LAX/0824/006','','1','','','6','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','BP,USP','25','20','','500','0','0','1','0','0','0','2024-08-24 00:00:00','2024-08-24 15:54:41',NULL,'Preserve in tight container',NULL), (7,'1','LAX/0924/007','','2','','','5','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','25','4','','100','0','0','1','0','0','0','2024-09-14 00:00:00','2024-09-14 15:55:28',NULL,'Store protect from moisture at temperature not exceeding 30° C','2'), (8,'1','LAX/0924/008','','2','','','5','','','','5','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','5','1','','5','0','0','1','0','0','0','2024-09-14 00:00:00','2024-09-14 15:56:17',NULL,'Store protect from moisture at temperature not exceeding 30° C','2'), (10,'1','LAX/0924/009','','2','','','11','','','','5','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','5','40','','200','0','0','1','0','0','0','2024-09-14 00:00:00','2024-09-14 17:43:26',NULL,'Store protect from moisture at temperature not exceeding 30° C','2'), (11,'1','LAX/0924/011','','2','','','10','','','','25','2024-10-01 00:00:00','2029-09-01 00:00:00','39','0','','','','IP','25','20','','500','0','0','1','0','0','0','2024-09-14 00:00:00','2024-09-14 17:48:47',NULL,'Store protect from moisture at temperature not exceeding 30° C','2'), (12,'2','LAX/0924/012','','5','','','12','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','BP','25','5','','125','0','0','1','0','0','0','2024-09-18 00:00:00','2024-09-18 09:47:11',NULL,'In an air tight container','5'), (13,'2','LAX/0924/013','','5','','','12','','','','5','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','BP','5','1','','5','0','0','1','0','0','0','2024-09-18 00:00:00','2024-09-18 09:48:18',NULL,'In an air tight container','5'), (14,'1','LAX/0924/014','','1','','','13','','','','25','2024-10-01 00:00:00','2029-09-01 00:00:00','39','0','','','','BP','25','20','','500','0','0','1','0','0','0','2024-09-19 00:00:00','2024-09-19 15:28:29',NULL,'In an air tight container','1'), (15,'1','LAX/0924/015','','1','','','14','','','','25','2024-10-01 00:00:00','2029-09-01 00:00:00','39','0','','','','BP','25','20','','500','0','0','1','0','0','0','2024-09-19 00:00:00','2024-09-19 15:28:49',NULL,'In an air tight container','1'), (16,'1','LAX/0924/016','','1','','','15','','','','25','2024-10-01 00:00:00','2029-09-01 00:00:00','39','0','','','','BP','25','20','','500','0','0','1','0','0','0','2024-09-19 00:00:00','2024-09-19 15:29:01',NULL,'In an air tight container','1'), (17,'1','LAX/0924/017','','1','','','16','','','','25','2024-10-01 00:00:00','2029-09-01 00:00:00','39','0','','','','BP','25','20','','500','0','0','1','0','0','0','2024-09-19 00:00:00','2024-09-19 15:29:35',NULL,'In an air tight container','1'), (18,'1','LAX/0924/018','','1','','','7','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','BP,USP','25','20','','500','0','0','1','0','0','0','2024-09-20 00:00:00','2024-09-20 16:17:28',NULL,'Preserve in tight container','4'), (19,'1','LAX/0924/019','','1','','','8','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','BP,USP','25','20','','500','0','0','1','0','0','0','2024-09-20 00:00:00','2024-09-20 16:17:39',NULL,'Preserve in tight container','4'), (20,'1','LAX/0924/020','','1','','','18','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','BP,USP','25','20','','500','0','0','1','0','0','0','2024-09-20 00:00:00','2024-09-20 16:20:16',NULL,'Preserve in tight container','4'), (21,'1','LAX/0924/021','','2','','','19','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','25','1','','25','0','0','1','0','0','0','2024-09-22 00:00:00','2024-09-22 16:45:21',NULL,'Store protect from moisture at temperature not exceeding 30° C','2'), (22,'1','LAX/0924/022','','2','','','19','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','25','1','','25','0','0','1','0','0','0','2024-09-22 00:00:00','2024-09-24 12:08:47',NULL,'Store protect from moisture at temperature not exceeding 30° C','2'), (23,'1','LAX/0924/023','','2','','','19','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','25','1','','25','0','0','1','0','0','0','2024-09-27 00:00:00','2024-09-28 15:08:18',NULL,'Store protect from moisture at temperature not exceeding 30° C','2'), (24,'1','LAX/0924/024','','2','','','19','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','25','1','','25','0','0','1','0','0','0','2024-09-28 00:00:00','2024-09-28 15:08:52',NULL,'Store protect from moisture at temperature not exceeding 30° C','2'), (25,'1','LAX/0924/025','','2','','','19','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','25','2','','50','0','0','1','0','0','0','2024-09-28 00:00:00','2024-09-28 15:09:05',NULL,'Store protect from moisture at temperature not exceeding 30° C','2'), (26,'2','LAX/0924/026','','5','','','21','','','','5','2024-10-01 00:00:00','2029-09-01 00:00:00','39','0','','','','USP','5','1','','5','0','0','1','0','0','0','2024-09-28 00:00:00','2024-09-28 17:13:59',NULL,'Preserve in well closed container','7'), (27,'2','LAX/0924/027','','5','','','21','','','','5','2024-10-01 00:00:00','2029-09-01 00:00:00','39','0','','','','USP','5','1','','5','0','0','1','0','0','0','2024-09-28 00:00:00','2024-09-28 17:14:11',NULL,'Preserve in well closed container','7'), (28,'1','LAX/0924/028','','1','','','20','','','','25','2024-10-01 00:00:00','2029-09-01 00:00:00','39','0','','','','BP','25','20','','500','0','0','1','0','0','0','2024-09-28 00:00:00','2024-09-28 17:14:25',NULL,'In an air tight container','1'), (29,'3','LAX/1024/029','','6','','','17','','','','25','2024-07-01 00:00:00','2029-06-01 00:00:00','39','0','','','','TECHNICAL','25','1','','25','0','0','1','0','0','0','2024-10-02 00:00:00','2024-10-02 13:06:44',NULL,'Preserve in well closed container','8'), (30,'8','LAX/1024/030','','8','','','22','','','','25','2024-11-01 00:00:00','2026-01-01 00:00:00','36','0','','','','In-House','25','2','','50','0','0','1','0','0','0','2024-10-07 00:00:00','2024-10-07 15:44:40',NULL,'Teest 1 In-House Grade','9'); /*!40000 ALTER TABLE `generateqr` ENABLE KEYS */; -- -- Definition of generateqrsr -- DROP TABLE IF EXISTS `generateqrsr`; CREATE TABLE IF NOT EXISTS `generateqrsr` ( `id` int(11) NOT NULL AUTO_INCREMENT, `contno` varchar(1000) DEFAULT '', `qrid` varchar(1000) DEFAULT '', `tarewt` varchar(1000) DEFAULT '', `grosswt` varchar(1000) DEFAULT '', `uninum` text, `sscc` text, `fdigit` varchar(50) DEFAULT NULL, `preview` varchar(50) DEFAULT NULL, `ssccrs` varchar(50) DEFAULT '0', `qrsrtqty` varchar(50) DEFAULT '0', `batchid` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=325 DEFAULT CHARSET=utf8; -- -- Dumping data for table generateqrsr -- /*!40000 ALTER TABLE `generateqrsr` DISABLE KEYS */; INSERT INTO `generateqrsr`(`id`,`contno`,`qrid`,`tarewt`,`grosswt`,`uninum`,`sscc`,`fdigit`,`preview`,`ssccrs`,`qrsrtqty`,`batchid`) VALUES (1,'1/20','1','2.2','27.2','001','089061816400090011','0','0','0','25','4'), (2,'2/20','1','2.2','27.2','002','089061816400090020','0','0','0','25','4'), (3,'3/20','1','2.2','27.2','003','089061816400090039','0','0','0','25','4'), (4,'4/20','1','2.2','27.2','004','089061816400090048','0','0','0','25','4'), (5,'5/20','1','2.2','27.2','005','089061816400090057','0','0','0','25','4'), (6,'6/20','1','2.2','27.2','006','089061816400090066','0','0','0','25','4'), (7,'7/20','1','2.2','27.2','007','089061816400090075','0','0','0','25','4'), (8,'8/20','1','2.2','27.2','008','089061816400090084','0','0','0','25','4'), (9,'9/20','1','2.2','27.2','009','089061816400090093','0','0','0','25','4'), (10,'10/20','1','2.2','27.2','010','089061816400090109','0','0','0','25','4'), (11,'11/20','1','2.2','27.2','011','089061816400090118','0','0','0','25','4'), (12,'12/20','1','2.2','27.2','012','089061816400090127','0','0','0','25','4'), (13,'13/20','1','2.2','27.2','013','089061816400090136','0','0','0','25','4'), (14,'14/20','1','2.2','27.2','014','089061816400090145','0','0','0','25','4'), (15,'15/20','1','2.2','27.2','015','089061816400090154','0','0','0','25','4'), (16,'16/20','1','2.2','27.2','016','089061816400090163','0','0','0','25','4'), (17,'17/20','1','2.2','27.2','017','089061816400090172','0','0','0','25','4'), (18,'18/20','1','2.2','27.2','018','089061816400090181','0','0','0','25','4'), (19,'19/20','1','2.2','27.2','019','089061816400090190','0','0','0','25','4'), (20,'20/20','1','2.2','27.2','020','089061816400090206','0','0','0','25','4'), (29,'1/12','3','2.8','27.8','021','089061816400090215','0','0','0','25','5'), (30,'2/12','3','2.8','27.8','022','089061816400090224','0','0','0','25','5'), (31,'3/12','3','2.8','27.8','023','089061816400090233','0','0','0','25','5'), (32,'4/12','3','2.8','27.8','024','089061816400090242','0','0','0','25','5'), (33,'5/12','3','2.8','27.8','025','089061816400090251','0','0','0','25','5'), (34,'6/12','3','2.8','27.8','026','089061816400090260','0','0','0','25','5'), (35,'7/12','3','2.8','27.8','027','089061816400090279','0','0','0','25','5'), (36,'8/12','3','2.8','27.8','028','089061816400090288','0','0','0','25','5'), (37,'9/12','3','2.8','27.8','029','089061816400090297','0','0','0','25','5'), (38,'10/12','3','2.8','27.8','030','089061816400090303','0','0','0','25','5'), (39,'11/12','3','2.8','27.8','031','089061816400090312','0','0','0','25','5'), (40,'12/12','3','2.8','27.8','032','089061816400090321','0','0','0','25','5'), (41,'1/2','4','2.8','27.8','033','089061816400090330','0','0','0','25','5'), (42,'2/2','4','2.8','27.8','034','089061816400090349','0','0','0','25','5'), (43,'1/1','5','2.8','27.8','035','089061816400090358','0','0','0','25','5'), (44,'1/20','6','2.2','27.2','036','089061816400090367','0','0','0','25','6'), (45,'2/20','6','2.2','27.2','037','089061816400090376','0','0','0','25','6'), (46,'3/20','6','2.2','27.2','038','089061816400090385','0','0','0','25','6'), (47,'4/20','6','2.2','27.2','039','089061816400090394','0','0','0','25','6'), (48,'5/20','6','2.2','27.2','040','089061816400090400','0','0','0','25','6'), (49,'6/20','6','2.2','27.2','041','089061816400090419','0','0','0','25','6'), (50,'7/20','6','2.2','27.2','042','089061816400090428','0','0','0','25','6'), (51,'8/20','6','2.2','27.2','043','089061816400090437','0','0','0','25','6'), (52,'9/20','6','2.2','27.2','044','089061816400090446','0','0','0','25','6'), (53,'10/20','6','2.2','27.2','045','089061816400090455','0','0','0','25','6'), (54,'11/20','6','2.2','27.2','046','089061816400090464','0','0','0','25','6'), (55,'12/20','6','2.2','27.2','047','089061816400090473','0','0','0','25','6'), (56,'13/20','6','2.2','27.2','048','089061816400090482','0','0','0','25','6'), (57,'14/20','6','2.2','27.2','049','089061816400090491','0','0','0','25','6'), (58,'15/20','6','2.2','27.2','050','089061816400090507','0','0','0','25','6'), (59,'16/20','6','2.2','27.2','051','089061816400090516','0','0','0','25','6'), (60,'17/20','6','2.2','27.2','052','089061816400090525','0','0','0','25','6'), (61,'18/20','6','2.2','27.2','053','089061816400090534','0','0','0','25','6'), (62,'19/20','6','2.2','27.2','054','089061816400090543','0','0','0','25','6'), (63,'20/20','6','2.2','27.2','055','089061816400090552','0','0','0','25','6'), (64,'1/4','7','2.8','27.8','056','089061816400090561','0','0','0','25','5'), (65,'2/4','7','2.8','27.8','057','089061816400090570','0','0','0','25','5'), (66,'3/4','7','2.8','27.8','058','089061816400090589','0','0','0','25','5'), (67,'4/4','7','2.8','27.8','059','089061816400090598','0','0','0','25','5'), (68,'1/1','8','0.25','5.25','060','089061816400090604','0','0','0','5','5'), (88,'1/40','10','0.25','5.25','061','089061816400090613','0','0','0','5','11'), (89,'2/40','10','0.25','5.25','062','089061816400090622','0','0','0','5','11'), (90,'3/40','10','0.25','5.25','063','089061816400090631','0','0','0','5','11'), (91,'4/40','10','0.25','5.25','064','089061816400090640','0','0','0','5','11'), (92,'5/40','10','0.25','5.25','065','089061816400090659','0','0','0','5','11'), (93,'6/40','10','0.25','5.25','066','089061816400090668','0','0','0','5','11'), (94,'7/40','10','0.25','5.25','067','089061816400090677','0','0','0','5','11'), (95,'8/40','10','0.25','5.25','068','089061816400090686','0','0','0','5','11'), (96,'9/40','10','0.25','5.25','069','089061816400090695','0','0','0','5','11'), (97,'10/40','10','0.25','5.25','070','089061816400090701','0','0','0','5','11'), (98,'11/40','10','0.25','5.25','071','089061816400090710','0','0','0','5','11'), (99,'12/40','10','0.25','5.25','072','089061816400090729','0','0','0','5','11'), (100,'13/40','10','0.25','5.25','073','089061816400090738','0','0','0','5','11'), (101,'14/40','10','0.25','5.25','074','089061816400090747','0','0','0','5','11'), (102,'15/40','10','0.25','5.25','075','089061816400090756','0','0','0','5','11'), (103,'16/40','10','0.25','5.25','076','089061816400090765','0','0','0','5','11'), (104,'17/40','10','0.25','5.25','077','089061816400090774','0','0','0','5','11'), (105,'18/40','10','0.25','5.25','078','089061816400090783','0','0','0','5','11'), (106,'19/40','10','0.25','5.25','079','089061816400090792','0','0','0','5','11'), (107,'20/40','10','0.25','5.25','080','089061816400090808','0','0','0','5','11'), (108,'21/40','10','0.25','5.25','081','089061816400090817','0','0','0','5','11'), (109,'22/40','10','0.25','5.25','082','089061816400090826','0','0','0','5','11'), (110,'23/40','10','0.25','5.25','083','089061816400090835','0','0','0','5','11'), (111,'24/40','10','0.25','5.25','084','089061816400090844','0','0','0','5','11'), (112,'25/40','10','0.25','5.25','085','089061816400090853','0','0','0','5','11'), (113,'26/40','10','0.25','5.25','086','089061816400090862','0','0','0','5','11'), (114,'27/40','10','0.25','5.25','087','089061816400090871','0','0','0','5','11'), (115,'28/40','10','0.25','5.25','088','089061816400090880','0','0','0','5','11'), (116,'29/40','10','0.25','5.25','089','089061816400090899','0','0','0','5','11'), (117,'30/40','10','0.25','5.25','090','089061816400090905','0','0','0','5','11'), (118,'31/40','10','0.25','5.25','091','089061816400090914','0','0','0','5','11'), (119,'32/40','10','0.25','5.25','092','089061816400090923','0','0','0','5','11'), (120,'33/40','10','0.25','5.25','093','089061816400090932','0','0','0','5','11'), (121,'34/40','10','0.25','5.25','094','089061816400090941','0','0','0','5','11'), (122,'35/40','10','0.25','5.25','095','089061816400090950','0','0','0','5','11'), (123,'36/40','10','0.25','5.25','096','089061816400090969','0','0','0','5','11'), (124,'37/40','10','0.25','5.25','097','089061816400090978','0','0','0','5','11'), (125,'38/40','10','0.25','5.25','098','089061816400090987','0','0','0','5','11'), (126,'39/40','10','0.25','5.25','099','089061816400090996','0','0','0','5','11'), (127,'40/40','10','0.25','5.25','100','089061816400091001','0','0','0','5','11'), (128,'1/20','11','2.8','27.8','101','089061816400091010','0','0','0','25','10'), (129,'2/20','11','2.8','27.8','102','089061816400091029','0','0','0','25','10'), (130,'3/20','11','2.8','27.8','103','089061816400091038','0','0','0','25','10'), (131,'4/20','11','2.8','27.8','104','089061816400091047','0','0','0','25','10'), (132,'5/20','11','2.8','27.8','105','089061816400091056','0','0','0','25','10'), (133,'6/20','11','2.8','27.8','106','089061816400091065','0','0','0','25','10'), (134,'7/20','11','2.8','27.8','107','089061816400091074','0','0','0','25','10'), (135,'8/20','11','2.8','27.8','108','089061816400091083','0','0','0','25','10'), (136,'9/20','11','2.8','27.8','109','089061816400091092','0','0','0','25','10'), (137,'10/20','11','2.8','27.8','110','089061816400091108','0','0','0','25','10'), (138,'11/20','11','2.8','27.8','111','089061816400091117','0','0','0','25','10'), (139,'12/20','11','2.8','27.8','112','089061816400091126','0','0','0','25','10'), (140,'13/20','11','2.8','27.8','113','089061816400091135','0','0','0','25','10'), (141,'14/20','11','2.8','27.8','114','089061816400091144','0','0','0','25','10'), (142,'15/20','11','2.8','27.8','115','089061816400091153','0','0','0','25','10'), (143,'16/20','11','2.8','27.8','116','089061816400091162','0','0','0','25','10'), (144,'17/20','11','2.8','27.8','117','089061816400091171','0','0','0','25','10'), (145,'18/20','11','2.8','27.8','118','089061816400091180','0','0','0','25','10'), (146,'19/20','11','2.8','27.8','119','089061816400091199','0','0','0','25','10'), (147,'20/20','11','2.8','27.8','120','089061816400091205','0','0','0','25','10'), (148,'1/5','12','2.2','27.2','001','089061816400230017','0','0','0','25','12'), (149,'2/5','12','2.2','27.2','002','089061816400230026','0','0','0','25','12'), (150,'3/5','12','2.2','27.2','003','089061816400230035','0','0','0','25','12'), (151,'4/5','12','2.2','27.2','004','089061816400230044','0','0','0','25','12'), (152,'5/5','12','2.2','27.2','005','089061816400230053','0','0','0','25','12'), (153,'1/1','13','0.9','5.9','006','089061816400230062','0','0','0','5','12'), (154,'1/20','14','2.2','27.2','121','089061816400091214','0','0','0','25','13'), (155,'2/20','14','2.2','27.2','122','089061816400091223','0','0','0','25','13'), (156,'3/20','14','2.2','27.2','123','089061816400091232','0','0','0','25','13'), (157,'4/20','14','2.2','27.2','124','089061816400091241','0','0','0','25','13'), (158,'5/20','14','2.2','27.2','125','089061816400091250','0','0','0','25','13'), (159,'6/20','14','2.2','27.2','126','089061816400091269','0','0','0','25','13'), (160,'7/20','14','2.2','27.2','127','089061816400091278','0','0','0','25','13'), (161,'8/20','14','2.2','27.2','128','089061816400091287','0','0','0','25','13'), (162,'9/20','14','2.2','27.2','129','089061816400091296','0','0','0','25','13'), (163,'10/20','14','2.2','27.2','130','089061816400091302','0','0','0','25','13'), (164,'11/20','14','2.2','27.2','131','089061816400091311','0','0','0','25','13'), (165,'12/20','14','2.2','27.2','132','089061816400091320','0','0','0','25','13'), (166,'13/20','14','2.2','27.2','133','089061816400091339','0','0','0','25','13'), (167,'14/20','14','2.2','27.2','134','089061816400091348','0','0','0','25','13'), (168,'15/20','14','2.2','27.2','135','089061816400091357','0','0','0','25','13'), (169,'16/20','14','2.2','27.2','136','089061816400091366','0','0','0','25','13'), (170,'17/20','14','2.2','27.2','137','089061816400091375','0','0','0','25','13'), (171,'18/20','14','2.2','27.2','138','089061816400091384','0','0','0','25','13'), (172,'19/20','14','2.2','27.2','139','089061816400091393','0','0','0','25','13'), (173,'20/20','14','2.2','27.2','140','089061816400091409','0','0','0','25','13'), (174,'1/20','15','2.2','27.2','141','089061816400091418','0','0','0','25','14'), (175,'2/20','15','2.2','27.2','142','089061816400091427','0','0','0','25','14'), (176,'3/20','15','2.2','27.2','143','089061816400091436','0','0','0','25','14'), (177,'4/20','15','2.2','27.2','144','089061816400091445','0','0','0','25','14'), (178,'5/20','15','2.2','27.2','145','089061816400091454','0','0','0','25','14'), (179,'6/20','15','2.2','27.2','146','089061816400091463','0','0','0','25','14'), (180,'7/20','15','2.2','27.2','147','089061816400091472','0','0','0','25','14'), (181,'8/20','15','2.2','27.2','148','089061816400091481','0','0','0','25','14'), (182,'9/20','15','2.2','27.2','149','089061816400091490','0','0','0','25','14'), (183,'10/20','15','2.2','27.2','150','089061816400091506','0','0','0','25','14'), (184,'11/20','15','2.2','27.2','151','089061816400091515','0','0','0','25','14'), (185,'12/20','15','2.2','27.2','152','089061816400091524','0','0','0','25','14'), (186,'13/20','15','2.2','27.2','153','089061816400091533','0','0','0','25','14'), (187,'14/20','15','2.2','27.2','154','089061816400091542','0','0','0','25','14'), (188,'15/20','15','2.2','27.2','155','089061816400091551','0','0','0','25','14'), (189,'16/20','15','2.2','27.2','156','089061816400091560','0','0','0','25','14'), (190,'17/20','15','2.2','27.2','157','089061816400091579','0','0','0','25','14'), (191,'18/20','15','2.2','27.2','158','089061816400091588','0','0','0','25','14'), (192,'19/20','15','2.2','27.2','159','089061816400091597','0','0','0','25','14'), (193,'20/20','15','2.2','27.2','160','089061816400091603','0','0','0','25','14'), (194,'1/20','16','2.2','27.2','161','089061816400091612','0','0','0','25','15'), (195,'2/20','16','2.2','27.2','162','089061816400091621','0','0','0','25','15'), (196,'3/20','16','2.2','27.2','163','089061816400091630','0','0','0','25','15'), (197,'4/20','16','2.2','27.2','164','089061816400091649','0','0','0','25','15'), (198,'5/20','16','2.2','27.2','165','089061816400091658','0','0','0','25','15'), (199,'6/20','16','2.2','27.2','166','089061816400091667','0','0','0','25','15'), (200,'7/20','16','2.2','27.2','167','089061816400091676','0','0','0','25','15'), (201,'8/20','16','2.2','27.2','168','089061816400091685','0','0','0','25','15'), (202,'9/20','16','2.2','27.2','169','089061816400091694','0','0','0','25','15'), (203,'10/20','16','2.2','27.2','170','089061816400091700','0','0','0','25','15'), (204,'11/20','16','2.2','27.2','171','089061816400091719','0','0','0','25','15'), (205,'12/20','16','2.2','27.2','172','089061816400091728','0','0','0','25','15'), (206,'13/20','16','2.2','27.2','173','089061816400091737','0','0','0','25','15'), (207,'14/20','16','2.2','27.2','174','089061816400091746','0','0','0','25','15'), (208,'15/20','16','2.2','27.2','175','089061816400091755','0','0','0','25','15'), (209,'16/20','16','2.2','27.2','176','089061816400091764','0','0','0','25','15'), (210,'17/20','16','2.2','27.2','177','089061816400091773','0','0','0','25','15'), (211,'18/20','16','2.2','27.2','178','089061816400091782','0','0','0','25','15'), (212,'19/20','16','2.2','27.2','179','089061816400091791','0','0','0','25','15'), (213,'20/20','16','2.2','27.2','180','089061816400091807','0','0','0','25','15'), (214,'1/20','17','2.2','27.2','181','089061816400091816','0','0','0','25','16'), (215,'2/20','17','2.2','27.2','182','089061816400091825','0','0','0','25','16'), (216,'3/20','17','2.2','27.2','183','089061816400091834','0','0','0','25','16'), (217,'4/20','17','2.2','27.2','184','089061816400091843','0','0','0','25','16'), (218,'5/20','17','2.2','27.2','185','089061816400091852','0','0','0','25','16'), (219,'6/20','17','2.2','27.2','186','089061816400091861','0','0','0','25','16'), (220,'7/20','17','2.2','27.2','187','089061816400091870','0','0','0','25','16'), (221,'8/20','17','2.2','27.2','188','089061816400091889','0','0','0','25','16'), (222,'9/20','17','2.2','27.2','189','089061816400091898','0','0','0','25','16'), (223,'10/20','17','2.2','27.2','190','089061816400091904','0','0','0','25','16'), (224,'11/20','17','2.2','27.2','191','089061816400091913','0','0','0','25','16'), (225,'12/20','17','2.2','27.2','192','089061816400091922','0','0','0','25','16'), (226,'13/20','17','2.2','27.2','193','089061816400091931','0','0','0','25','16'), (227,'14/20','17','2.2','27.2','194','089061816400091940','0','0','0','25','16'), (228,'15/20','17','2.2','27.2','195','089061816400091959','0','0','0','25','16'), (229,'16/20','17','2.2','27.2','196','089061816400091968','0','0','0','25','16'), (230,'17/20','17','2.2','27.2','197','089061816400091977','0','0','0','25','16'), (231,'18/20','17','2.2','27.2','198','089061816400091986','0','0','0','25','16'), (232,'19/20','17','2.2','27.2','199','089061816400091995','0','0','0','25','16'), (233,'20/20','17','2.2','27.2','200','089061816400092000','0','0','0','25','16'), (234,'1/20','18','2.2','27.2','201','089061816400092019','0','0','0','25','7'), (235,'2/20','18','2.2','27.2','202','089061816400092028','0','0','0','25','7'), (236,'3/20','18','2.2','27.2','203','089061816400092037','0','0','0','25','7'), (237,'4/20','18','2.2','27.2','204','089061816400092046','0','0','0','25','7'), (238,'5/20','18','2.2','27.2','205','089061816400092055','0','0','0','25','7'), (239,'6/20','18','2.2','27.2','206','089061816400092064','0','0','0','25','7'), (240,'7/20','18','2.2','27.2','207','089061816400092073','0','0','0','25','7'), (241,'8/20','18','2.2','27.2','208','089061816400092082','0','0','0','25','7'), (242,'9/20','18','2.2','27.2','209','089061816400092091','0','0','0','25','7'), (243,'10/20','18','2.2','27.2','210','089061816400092107','0','0','0','25','7'), (244,'11/20','18','2.2','27.2','211','089061816400092116','0','0','0','25','7'), (245,'12/20','18','2.2','27.2','212','089061816400092125','0','0','0','25','7'), (246,'13/20','18','2.2','27.2','213','089061816400092134','0','0','0','25','7'), (247,'14/20','18','2.2','27.2','214','089061816400092143','0','0','0','25','7'), (248,'15/20','18','2.2','27.2','215','089061816400092152','0','0','0','25','7'), (249,'16/20','18','2.2','27.2','216','089061816400092161','0','0','0','25','7'), (250,'17/20','18','2.2','27.2','217','089061816400092170','0','0','0','25','7'), (251,'18/20','18','2.2','27.2','218','089061816400092189','0','0','0','25','7'), (252,'19/20','18','2.2','27.2','219','089061816400092198','0','0','0','25','7'), (253,'20/20','18','2.2','27.2','220','089061816400092204','0','0','0','25','7'), (254,'1/20','19','2.2','27.2','221','089061816400092213','0','0','0','25','8'), (255,'2/20','19','2.2','27.2','222','089061816400092222','0','0','0','25','8'), (256,'3/20','19','2.2','27.2','223','089061816400092231','0','0','0','25','8'), (257,'4/20','19','2.2','27.2','224','089061816400092240','0','0','0','25','8'), (258,'5/20','19','2.2','27.2','225','089061816400092259','0','0','0','25','8'), (259,'6/20','19','2.2','27.2','226','089061816400092268','0','0','0','25','8'), (260,'7/20','19','2.2','27.2','227','089061816400092277','0','0','0','25','8'), (261,'8/20','19','2.2','27.2','228','089061816400092286','0','0','0','25','8'), (262,'9/20','19','2.2','27.2','229','089061816400092295','0','0','0','25','8'), (263,'10/20','19','2.2','27.2','230','089061816400092301','0','0','0','25','8'), (264,'11/20','19','2.2','27.2','231','089061816400092310','0','0','0','25','8'), (265,'12/20','19','2.2','27.2','232','089061816400092329','0','0','0','25','8'), (266,'13/20','19','2.2','27.2','233','089061816400092338','0','0','0','25','8'), (267,'14/20','19','2.2','27.2','234','089061816400092347','0','0','0','25','8'), (268,'15/20','19','2.2','27.2','235','089061816400092356','0','0','0','25','8'), (269,'16/20','19','2.2','27.2','236','089061816400092365','0','0','0','25','8'), (270,'17/20','19','2.2','27.2','237','089061816400092374','0','0','0','25','8'), (271,'18/20','19','2.2','27.2','238','089061816400092383','0','0','0','25','8'), (272,'19/20','19','2.2','27.2','239','089061816400092392','0','0','0','25','8'), (273,'20/20','19','2.2','27.2','240','089061816400092408','0','0','0','25','8'), (274,'1/20','20','2.2','27.2','241','089061816400092417','0','0','0','25','18'), (275,'2/20','20','2.2','27.2','242','089061816400092426','0','0','0','25','18'), (276,'3/20','20','2.2','27.2','243','089061816400092435','0','0','0','25','18'), (277,'4/20','20','2.2','27.2','244','089061816400092444','0','0','0','25','18'), (278,'5/20','20','2.2','27.2','245','089061816400092453','0','0','0','25','18'), (279,'6/20','20','2.2','27.2','246','089061816400092462','0','0','0','25','18'), (280,'7/20','20','2.2','27.2','247','089061816400092471','0','0','0','25','18'), (281,'8/20','20','2.2','27.2','248','089061816400092480','0','0','0','25','18'), (282,'9/20','20','2.2','27.2','249','089061816400092499','0','0','0','25','18'), (283,'10/20','20','2.2','27.2','250','089061816400092505','0','0','0','25','18'), (284,'11/20','20','2.2','27.2','251','089061816400092514','0','0','0','25','18'), (285,'12/20','20','2.2','27.2','252','089061816400092523','0','0','0','25','18'), (286,'13/20','20','2.2','27.2','253','089061816400092532','0','0','0','25','18'), (287,'14/20','20','2.2','27.2','254','089061816400092541','0','0','0','25','18'), (288,'15/20','20','2.2','27.2','255','089061816400092550','0','0','0','25','18'), (289,'16/20','20','2.2','27.2','256','089061816400092569','0','0','0','25','18'), (290,'17/20','20','2.2','27.2','257','089061816400092578','0','0','0','25','18'), (291,'18/20','20','2.2','27.2','258','089061816400092587','0','0','0','25','18'), (292,'19/20','20','2.2','27.2','259','089061816400092596','0','0','0','25','18'), (293,'20/20','20','2.2','27.2','260','089061816400092602','0','0','0','25','18'), (294,'1/1','21','2.8','27.8','261','089061816400092611','0','0','0','25','19'), (295,'1/1','22','2.8','27.8','262','089061816400092620','0','0','0','25','19'), (296,'1/1','23','2.8','27.8','263','089061816400092639','0','0','0','25','19'), (297,'1/1','24','2.8','27.8','264','089061816400092648','0','0','0','25','19'), (298,'1/2','25','2.8','27.8','265','089061816400092657','0','0','0','25','19'), (299,'2/2','25','2.8','27.8','266','089061816400092666','0','0','0','25','19'), (300,'1/1','26','0.25','5.25','007','089061816400230071','0','0','0','5','21'), (301,'1/1','27','0.9','5.9','008','089061816400230080','0','0','0','5','21'), (302,'1/20','28','2.2','27.2','267','089061816400092675','0','0','0','25','20'), (303,'2/20','28','2.2','27.2','268','089061816400092684','0','0','0','25','20'), (304,'3/20','28','2.2','27.2','269','089061816400092693','0','0','0','25','20'), (305,'4/20','28','2.2','27.2','270','089061816400092709','0','0','0','25','20'), (306,'5/20','28','2.2','27.2','271','089061816400092718','0','0','0','25','20'), (307,'6/20','28','2.2','27.2','272','089061816400092727','0','0','0','25','20'), (308,'7/20','28','2.2','27.2','273','089061816400092736','0','0','0','25','20'), (309,'8/20','28','2.2','27.2','274','089061816400092745','0','0','0','25','20'), (310,'9/20','28','2.2','27.2','275','089061816400092754','0','0','0','25','20'), (311,'10/20','28','2.2','27.2','276','089061816400092763','0','0','0','25','20'), (312,'11/20','28','2.2','27.2','277','089061816400092772','0','0','0','25','20'), (313,'12/20','28','2.2','27.2','278','089061816400092781','0','0','0','25','20'), (314,'13/20','28','2.2','27.2','279','089061816400092790','0','0','0','25','20'), (315,'14/20','28','2.2','27.2','280','089061816400092806','0','0','0','25','20'), (316,'15/20','28','2.2','27.2','281','089061816400092815','0','0','0','25','20'), (317,'16/20','28','2.2','27.2','282','089061816400092824','0','0','0','25','20'), (318,'17/20','28','2.2','27.2','283','089061816400092833','0','0','0','25','20'), (319,'18/20','28','2.2','27.2','284','089061816400092842','0','0','0','25','20'), (320,'19/20','28','2.2','27.2','285','089061816400092851','0','0','0','25','20'), (321,'20/20','28','2.2','27.2','286','089061816400092860','0','0','0','25','20'), (322,'1/1','29','2.2','27.2','001','089061816400300015','0','0','0','25','17'), (323,'1/2','30','123.65','148.65','001','012345679910250015','0','0','0','25','22'), (324,'2/2','30','123.65','148.65','002','012345679910250024','0','0','0','25','22'); /*!40000 ALTER TABLE `generateqrsr` ENABLE KEYS */; -- -- Definition of logtable -- DROP TABLE IF EXISTS `logtable`; CREATE TABLE IF NOT EXISTS `logtable` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(255) DEFAULT NULL, `action` varchar(1000) DEFAULT NULL, `time` datetime DEFAULT NULL, `userid` varchar(50) DEFAULT NULL, `tablename` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=631 DEFAULT CHARSET=utf8; -- -- Dumping data for table logtable -- /*!40000 ALTER TABLE `logtable` DISABLE KEYS */; INSERT INTO `logtable`(`id`,`username`,`action`,`time`,`userid`,`tablename`) VALUES (1,NULL,'User Logged In','2024-08-03 11:13:36','39','Login In'), (2,NULL,'New Company Added','2024-08-03 11:21:56','39','Company Unit'), (3,NULL,'User Logged In','2024-08-03 12:08:14','39','Login In'), (4,NULL,'User Logged In','2024-08-03 12:40:03','36','Login In'), (5,NULL,'Company Updated','2024-08-03 12:43:56','36','Company Unit'), (6,NULL,'Company Unit Approved','2024-08-03 12:47:53','36','Approval'), (7,NULL,'User Logged In','2024-08-03 12:50:13','39','Login In'), (8,NULL,'New Product Added','2024-08-03 12:54:21','39','Product'), (9,NULL,'New Product Added','2024-08-03 12:58:20','39','Product'), (10,NULL,'User Logged In','2024-08-03 13:02:08','37','Login In'), (11,NULL,'New Product Added','2024-08-03 13:04:29','39','Product'), (12,NULL,'User Logged Out','2024-08-03 13:06:28','37','Log Out'), (13,NULL,'New Product Added','2024-08-03 13:06:53','39','Product'), (14,NULL,'New Product Added','2024-08-03 13:10:05','39','Product'), (15,NULL,'New Product Added','2024-08-03 13:12:42','39','Product'), (16,NULL,'Product Updated','2024-08-03 13:14:19','39','Product'), (17,NULL,'User Logged In','2024-08-03 13:26:49','39','Login In'), (18,NULL,'Product Updated','2024-08-03 13:27:27','39','Product'), (19,NULL,'Product Updated','2024-08-03 13:28:14','39','Product'), (20,NULL,'User Logged In','2024-08-03 13:37:47','39','Login In'), (21,NULL,'User Logged In','2024-08-03 14:03:20','39','Login In'), (22,NULL,'User Logged In','2024-08-03 15:16:31','39','Login In'), (23,NULL,'User Logged In','2024-08-03 15:55:12','36','Login In'), (24,NULL,'User Logged In','2024-08-03 15:58:31','39','Login In'), (25,NULL,'User Logged In','2024-08-03 16:23:49','39','Login In'), (26,NULL,'New Product Added','2024-08-03 16:29:29','39','Product'), (27,NULL,'User Logged In','2024-08-03 16:31:57','37','Login In'), (28,NULL,'Product Approved','2024-08-03 16:33:10','37','Approval'), (29,NULL,'Product Approved','2024-08-03 16:33:41','37','Approval'), (30,NULL,'Product Approved','2024-08-03 16:36:24','37','Approval'), (31,NULL,'Product Approved','2024-08-03 16:38:19','37','Approval'), (32,NULL,'Product Updated','2024-08-03 16:43:31','39','Product'), (33,NULL,'User Logged Out','2024-08-03 16:43:34','37','Log Out'), (34,NULL,'User Logged In','2024-08-03 18:22:59','36','Login In'), (35,NULL,'User Logged In','2024-08-04 11:41:05','37','Login In'), (36,NULL,'User Logged In','2024-08-04 12:39:57','39','Login In'), (37,NULL,'User Logged In','2024-08-04 12:55:20','37','Login In'), (38,NULL,'Product Approved','2024-08-04 12:59:43','37','Approval'), (39,NULL,'Product Rejected','2024-08-04 13:03:26','37','Approval'), (40,NULL,'Product Approved','2024-08-04 13:07:16','37','Approval'), (41,NULL,'Product Updated','2024-08-04 13:08:22','39','Product'), (42,NULL,'User Logged In','2024-08-04 14:31:37','37','Login In'), (43,NULL,'Product Approved','2024-08-04 14:31:49','37','Approval'), (44,NULL,'User Logged In','2024-08-06 12:05:10','39','Login In'), (45,NULL,'Batch Added','2024-08-06 12:07:13','39','Batch'), (46,NULL,'Batch Updated','2024-08-06 12:09:55','39','Batch'), (47,NULL,'User Logged In','2024-08-07 11:54:04','39','Login In'), (48,NULL,'Batch Added','2024-08-07 11:56:35','39','Batch'), (49,NULL,'Batch Added','2024-08-07 11:58:02','39','Batch'), (50,NULL,'Batch Updated','2024-08-07 12:00:21','39','Batch'), (51,NULL,'Batch Updated','2024-08-07 12:00:29','39','Batch'), (52,NULL,'User Logged In','2024-08-09 12:06:33','39','Login In'), (53,NULL,'Batch Data Deleted','2024-08-09 12:06:48','39','Batch'), (54,NULL,'Batch Data Deleted','2024-08-09 12:06:52','39','Batch'), (55,NULL,'Batch Data Deleted','2024-08-09 12:06:55','39','Batch'), (56,NULL,'Batch Added','2024-08-09 12:08:25','39','Batch'), (57,NULL,'Batch Added','2024-08-09 12:09:18','39','Batch'), (58,NULL,'Batch Added','2024-08-09 12:09:59','39','Batch'), (59,NULL,'Batch Added','2024-08-09 12:10:43','39','Batch'), (60,NULL,'Batch Added','2024-08-09 12:11:29','39','Batch'), (61,NULL,'User Logged In','2024-08-09 16:11:09','37','Login In'), (62,NULL,'Batch Delete Approved','2024-08-09 16:12:02','37','Approval'), (63,NULL,'Batch Delete Approved','2024-08-09 16:12:31','37','Approval'), (64,NULL,'Batch Delete Approved','2024-08-09 16:12:53','37','Approval'), (65,NULL,'Batch Approved','2024-08-09 16:14:10','37','Approval'), (66,NULL,'Batch Approved','2024-08-09 16:14:53','37','Approval'), (67,NULL,'Batch Approved','2024-08-09 16:15:42','37','Approval'), (68,NULL,'Batch Approved','2024-08-09 16:16:25','37','Approval'), (69,NULL,'Batch Approved','2024-08-09 16:16:43','37','Approval'), (70,NULL,'User Logged Out','2024-08-09 16:17:27','37','Log Out'), (71,NULL,'User Logged In','2024-08-10 12:44:41','39','Login In'), (72,NULL,'Alias Product Added','2024-08-10 12:45:56','39','Alias Product'), (73,NULL,'Alias Product Added','2024-08-10 12:47:08','39','Alias Product'), (74,NULL,'User Logged In','2024-08-10 13:44:57','39','Login In'), (75,NULL,'User Logged In','2024-08-10 16:42:52','37','Login In'), (76,NULL,'Alias Product Approved','2024-08-10 16:45:02','37','Approval'), (77,NULL,'Alias Product Approved','2024-08-10 16:45:04','37','Approval'), (78,NULL,'User Logged Out','2024-08-10 16:45:12','37','Log Out'), (79,NULL,'User Logged In','2024-08-11 15:05:32','39','Login In'), (80,NULL,'Storage Condition Added','2024-08-11 15:07:16','39','Storage Condition'), (81,NULL,'User Logged In','2024-08-11 15:58:31','39','Login In'), (82,NULL,'User Logged In','2024-08-11 16:11:03','37','Login In'), (83,NULL,'Storage Condition Approved','2024-08-11 16:12:16','37','Storage Condition'), (84,NULL,'User Logged Out','2024-08-11 16:12:23','37','Log Out'), (85,NULL,'QR generated','2024-08-11 16:13:17','39','Generateqr'), (86,NULL,'User Logged In','2024-08-11 16:15:33','37','Login In'), (87,NULL,'Generateqr Approved','2024-08-11 16:16:38','37','Approval'), (88,NULL,'User Logged Out','2024-08-11 16:16:53','37','Log Out'), (89,NULL,'Single Print Had Taken','2024-08-11 16:17:02','39','generateqrsr'), (90,NULL,'Single Print Had Taken','2024-08-11 16:17:30','39','generateqrsr'), (91,NULL,'Single Print Had Taken','2024-08-11 16:18:25','39','generateqrsr'), (92,NULL,'Single Print Had Taken','2024-08-11 16:18:42','39','generateqrsr'), (93,NULL,'Single Print Had Taken','2024-08-11 16:34:49','39','generateqrsr'), (94,NULL,'Storage Condition Edited','2024-08-11 16:39:25','39','Storage Condition'), (95,NULL,'User Logged Out','2024-08-11 16:59:14','39','Log Out'), (96,NULL,'User Logged In','2024-08-11 16:59:16','39','Login In'), (97,NULL,'Single Print Had Taken','2024-08-11 16:59:36','39','generateqrsr'), (98,NULL,'User Logged In','2024-08-11 17:08:32','36','Login In'), (99,NULL,'Single Print Had Taken','2024-08-11 17:09:38','36','generateqrsr'), (100,NULL,'Multiple Print Had Taken','2024-08-11 17:10:28','36','generateqrsr'), (101,NULL,'User Logged In','2024-08-12 16:31:35','36','Login In'), (102,NULL,'Single Print Had Taken','2024-08-12 16:32:15','36','generateqrsr'), (103,NULL,'Multiple Print Had Taken','2024-08-12 16:32:28','36','generateqrsr'), (104,NULL,'Single Print Had Taken','2024-08-12 16:51:50','36','generateqrsr'), (105,NULL,'Single Print Had Taken','2024-08-12 16:55:45','36','generateqrsr'), (106,NULL,'Multiple Print Had Taken','2024-08-12 16:55:59','36','generateqrsr'), (107,NULL,'User Logged In','2024-08-14 11:51:23','39','Login In'), (108,NULL,'Single Print Had Taken','2024-08-14 11:51:41','39','generateqrsr'), (109,NULL,'Single Print Had Taken','2024-08-14 11:51:43','39','generateqrsr'), (110,NULL,'User Logged In','2024-08-14 13:30:45','39','Login In'), (111,NULL,'User Logged In','2024-08-14 19:40:44','39','Login In'), (112,NULL,'Alias Product Added','2024-08-14 19:41:56','39','Alias Product'), (113,NULL,'User Logged In','2024-08-14 19:42:35','37','Login In'), (114,NULL,'Alias Product Approved','2024-08-14 19:42:48','37','Approval'), (115,NULL,'Single Print Had Taken','2024-08-14 19:46:11','39','generateqrsr'), (116,NULL,'Single Print Had Taken','2024-08-14 19:46:31','39','generateqrsr'), (117,NULL,'Single Print Had Taken','2024-08-14 19:47:06','39','generateqrsr'), (118,NULL,'Single Print Had Taken','2024-08-14 19:47:21','39','generateqrsr'), (119,NULL,'Single Print Had Taken','2024-08-14 19:47:43','39','generateqrsr'), (120,NULL,'Single Print Had Taken','2024-08-14 20:02:36','39','generateqrsr'), (121,NULL,'Single Print Had Taken','2024-08-14 20:02:55','39','generateqrsr'), (122,NULL,'Single Print Had Taken','2024-08-14 20:05:33','39','generateqrsr'), (123,NULL,'Single Print Had Taken','2024-08-14 20:05:57','39','generateqrsr'), (124,NULL,'Single Print Had Taken','2024-08-14 20:07:11','39','generateqrsr'), (125,NULL,'Single Print Had Taken','2024-08-14 20:07:26','39','generateqrsr'), (126,NULL,'Single Print Had Taken','2024-08-14 20:08:38','39','generateqrsr'), (127,NULL,'Single Print Had Taken','2024-08-14 20:12:57','39','generateqrsr'), (128,NULL,'Single Print Had Taken','2024-08-14 20:13:14','39','generateqrsr'), (129,NULL,'Multiple Print Had Taken','2024-08-14 20:17:36','39','generateqrsr'), (130,NULL,'User Logged In','2024-08-16 14:54:59','39','Login In'), (131,NULL,'Company Updated','2024-08-16 14:56:29','39','Company Unit'), (132,NULL,'Single Print Had Taken','2024-08-16 14:57:47','39','generateqrsr'), (133,NULL,'Single Print Had Taken','2024-08-16 14:58:29','39','generateqrsr'), (134,NULL,'Single Print Had Taken','2024-08-16 15:02:11','39','generateqrsr'), (135,NULL,'Single Print Had Taken','2024-08-16 15:02:24','39','generateqrsr'), (136,NULL,'User Logged In','2024-08-16 15:29:11','36','Login In'), (137,NULL,'Single Print Had Taken','2024-08-16 15:30:00','36','generateqrsr'), (138,NULL,'Multiple Print Had Taken','2024-08-16 15:31:44','36','generateqrsr'), (139,NULL,'User Logged In','2024-08-16 15:36:22','39','Login In'), (140,NULL,'Storage Condition Added','2024-08-16 15:37:38','39','Storage Condition'), (141,NULL,'Single Print Had Taken','2024-08-16 16:01:39','39','generateqrsr'), (142,NULL,'Multiple Print Had Taken','2024-08-16 16:09:05','39','generateqrsr'), (143,NULL,'Multiple Print Had Taken','2024-08-16 16:09:05','39','generateqrsr'), (144,NULL,'Single Print Had Taken','2024-08-16 16:09:24','39','generateqrsr'), (145,NULL,'Single Print Had Taken','2024-08-16 16:09:42','39','generateqrsr'), (146,NULL,'Single Print Had Taken','2024-08-16 16:11:20','39','generateqrsr'), (147,NULL,'Multiple Print Had Taken','2024-08-16 16:11:55','39','generateqrsr'), (148,NULL,'Single Print Had Taken','2024-08-16 16:12:35','39','generateqrsr'), (149,NULL,'Multiple Print Had Taken','2024-08-16 16:12:55','39','generateqrsr'), (150,NULL,'Multiple Print Had Taken','2024-08-16 16:13:52','39','generateqrsr'), (151,NULL,'Multiple Print Had Taken','2024-08-16 16:15:00','39','generateqrsr'), (152,NULL,'Single Print Had Taken','2024-08-16 16:16:42','39','generateqrsr'), (153,NULL,'Single Print Had Taken','2024-08-16 16:18:40','39','generateqrsr'), (154,NULL,'Single Print Had Taken','2024-08-16 16:22:53','39','generateqrsr'), (155,NULL,'Single Print Had Taken','2024-08-16 16:24:05','39','generateqrsr'), (156,NULL,'User Logged In','2024-08-16 16:38:23','39','Login In'), (157,NULL,'Single Print Had Taken','2024-08-16 16:38:59','39','generateqrsr'), (158,NULL,'Single Print Had Taken','2024-08-16 16:39:46','39','generateqrsr'), (159,NULL,'Single Print Had Taken','2024-08-16 16:40:28','39','generateqrsr'), (160,NULL,'Single Print Had Taken','2024-08-16 16:40:56','39','generateqrsr'), (161,NULL,'Multiple Print Had Taken','2024-08-16 16:42:00','39','generateqrsr'), (162,NULL,'User Logged In','2024-08-16 17:04:12','39','Login In'), (163,NULL,'User Logged In','2024-08-16 17:08:38','37','Login In'), (164,NULL,'Company Unit Approved','2024-08-16 17:09:25','37','Approval'), (165,NULL,'Storage Condition Approved','2024-08-16 17:10:45','37','Storage Condition'), (166,NULL,'User Logged Out','2024-08-16 17:10:52','37','Log Out'), (167,NULL,'User Logged In','2024-08-16 17:49:39','39','Login In'), (168,NULL,'Single Print Had Taken','2024-08-16 17:49:58','39','generateqrsr'), (169,NULL,'Single Print Had Taken','2024-08-16 17:51:03','39','generateqrsr'), (170,NULL,'Multiple Print Had Taken','2024-08-16 17:52:07','39','generateqrsr'), (171,NULL,'Single Print Had Taken','2024-08-16 17:52:50','39','generateqrsr'), (172,NULL,'User Logged In','2024-08-16 17:54:23','39','Login In'), (173,NULL,'Single Print Had Taken','2024-08-16 17:54:36','39','generateqrsr'), (174,NULL,'Single Print Had Taken','2024-08-16 17:54:51','39','generateqrsr'), (175,NULL,'Single Print Had Taken','2024-08-16 17:55:19','39','generateqrsr'), (176,NULL,'Single Print Had Taken','2024-08-16 17:55:35','39','generateqrsr'), (177,NULL,'Single Print Had Taken','2024-08-16 17:55:52','39','generateqrsr'), (178,NULL,'Single Print Had Taken','2024-08-16 17:56:12','39','generateqrsr'), (179,NULL,'Single Print Had Taken','2024-08-16 17:56:36','39','generateqrsr'), (180,NULL,'Single Print Had Taken','2024-08-16 17:57:10','39','generateqrsr'), (181,NULL,'Single Print Had Taken','2024-08-16 17:57:21','39','generateqrsr'), (182,NULL,'Single Print Had Taken','2024-08-16 17:57:32','39','generateqrsr'), (183,NULL,'Single Print Had Taken','2024-08-16 17:57:43','39','generateqrsr'), (184,NULL,'Single Print Had Taken','2024-08-16 17:57:56','39','generateqrsr'), (185,NULL,'Single Print Had Taken','2024-08-16 17:58:09','39','generateqrsr'), (186,NULL,'Single Print Had Taken','2024-08-16 17:58:25','39','generateqrsr'), (187,NULL,'Single Print Had Taken','2024-08-16 17:58:44','39','generateqrsr'), (188,NULL,'Single Print Had Taken','2024-08-16 17:59:05','39','generateqrsr'), (189,NULL,'Single Print Had Taken','2024-08-16 17:59:32','39','generateqrsr'), (190,NULL,'Single Print Had Taken','2024-08-16 17:59:46','39','generateqrsr'), (191,NULL,'Single Print Had Taken','2024-08-16 18:00:05','39','generateqrsr'), (192,NULL,'Single Print Had Taken','2024-08-16 18:00:37','39','generateqrsr'), (193,NULL,'Single Print Had Taken','2024-08-16 18:00:56','39','generateqrsr'), (194,NULL,'Single Print Had Taken','2024-08-16 18:01:44','39','generateqrsr'), (195,NULL,'User Logged In','2024-08-16 18:24:52','39','Login In'), (196,NULL,'User Logged In','2024-08-17 10:40:35','39','Login In'), (197,NULL,'Batch Added','2024-08-17 10:46:21','39','Batch'), (198,NULL,'User Logged In','2024-08-17 11:12:01','39','Login In'), (199,NULL,'User Logged In','2024-08-17 11:12:39','37','Login In'), (200,NULL,'Batch Approved','2024-08-17 11:13:51','37','Approval'), (201,NULL,'Alias Product Delete Approved','2024-08-17 11:16:53','37','Approval'), (202,NULL,'Alias Product Added','2024-08-17 11:18:39','39','Alias Product'), (203,NULL,'Alias Product Approved','2024-08-17 11:18:53','37','Approval'), (204,NULL,'Storage Condition Added','2024-08-17 11:19:33','39','Storage Condition'), (205,NULL,'Storage Condition Approved','2024-08-17 11:23:26','37','Storage Condition'), (206,NULL,'QR generated','2024-08-17 11:25:29','39','Generateqr'), (207,NULL,'User Logged In','2024-08-17 11:26:10','37','Login In'), (208,NULL,'Generateqr Approved','2024-08-17 11:28:08','37','Approval'), (209,NULL,'Single Print Had Taken','2024-08-17 11:28:31','39','generateqrsr'), (210,NULL,'Single Print Had Taken','2024-08-17 11:47:00','39','generateqrsr'), (211,NULL,'Single Print Had Taken','2024-08-17 11:47:20','39','generateqrsr'), (212,NULL,'User Logged In','2024-08-17 12:07:49','39','Login In'), (213,NULL,'QR generated','2024-08-17 12:10:06','39','Generateqr'), (214,NULL,'User Logged In','2024-08-17 13:23:35','37','Login In'), (215,NULL,'Generateqr Approved','2024-08-17 13:24:01','37','Approval'), (216,NULL,'User Logged In','2024-08-17 13:55:53','39','Login In'), (217,NULL,'Single Print Had Taken','2024-08-17 13:59:18','39','generateqrsr'), (218,NULL,'Multiple Print Had Taken','2024-08-17 14:01:05','39','generateqrsr'), (219,NULL,'User Logged In','2024-08-17 14:24:38','39','Login In'), (220,NULL,'Single Print Had Taken','2024-08-17 14:24:50','39','generateqrsr'), (221,NULL,'Single Print Had Taken','2024-08-17 14:25:27','39','generateqrsr'), (222,NULL,'Single Print Had Taken','2024-08-17 14:25:44','39','generateqrsr'), (223,NULL,'Single Print Had Taken','2024-08-17 14:26:03','39','generateqrsr'), (224,NULL,'Single Print Had Taken','2024-08-17 14:26:14','39','generateqrsr'), (225,NULL,'Single Print Had Taken','2024-08-17 14:26:25','39','generateqrsr'), (226,NULL,'Single Print Had Taken','2024-08-17 14:26:56','39','generateqrsr'), (227,NULL,'Single Print Had Taken','2024-08-17 14:27:26','39','generateqrsr'), (228,NULL,'Single Print Had Taken','2024-08-17 14:27:39','39','generateqrsr'), (229,NULL,'Single Print Had Taken','2024-08-17 14:27:49','39','generateqrsr'), (230,NULL,'Single Print Had Taken','2024-08-17 14:28:04','39','generateqrsr'), (231,NULL,'Single Print Had Taken','2024-08-17 14:28:25','39','generateqrsr'), (232,NULL,'Single Print Had Taken','2024-08-17 14:28:46','39','generateqrsr'), (233,NULL,'Single Print Had Taken','2024-08-17 14:28:58','39','generateqrsr'), (234,NULL,'User Logged In','2024-08-21 11:32:09','39','Login In'), (235,NULL,'QR generated','2024-08-21 11:33:58','39','Generateqr'), (236,NULL,'QR generated','2024-08-21 11:34:37','39','Generateqr'), (237,NULL,'User Logged In','2024-08-21 11:49:01','37','Login In'), (238,NULL,'Generateqr Approved','2024-08-21 11:49:27','37','Approval'), (239,NULL,'Generateqr Approved','2024-08-21 11:49:46','37','Approval'), (240,NULL,'User Logged Out','2024-08-21 11:49:49','37','Log Out'), (241,NULL,'Single Print Had Taken','2024-08-21 11:52:04','39','generateqrsr'), (242,NULL,'Multiple Print Had Taken','2024-08-21 11:53:07','39','generateqrsr'), (243,NULL,'Single Print Had Taken','2024-08-21 11:54:54','39','generateqrsr'), (244,NULL,'Single Print Had Taken','2024-08-21 11:55:31','39','generateqrsr'), (245,NULL,'Single Print Had Taken','2024-08-21 11:55:41','39','generateqrsr'), (246,NULL,'User Logged In','2024-08-21 18:32:38','36','Login In'), (247,NULL,'User Logged In','2024-08-21 18:39:20','36','Login In'), (248,NULL,'User Logged In','2024-08-21 19:11:29','36','Login In'), (249,NULL,'User Logged Out','2024-08-21 19:11:34','36','Log Out'), (250,NULL,'User Logged In','2024-08-22 18:52:08','39','Login In'), (251,NULL,'User Logged In','2024-08-23 15:04:52','39','Login In'), (252,NULL,'Storage Condition Added','2024-08-23 15:07:55','39','Storage Condition'), (253,NULL,'User Logged In','2024-08-24 15:03:41','39','Login In'), (254,NULL,'User Logged In','2024-08-24 15:05:21','37','Login In'), (255,NULL,'Storage Condition Approved','2024-08-24 15:08:14','37','Storage Condition'), (256,NULL,'User Logged In','2024-08-24 15:21:41','37','Login In'), (257,NULL,'Storage Condition Approved','2024-08-24 15:21:47','37','Storage Condition'), (258,NULL,'QR generated','2024-08-24 15:28:16','39','Generateqr'), (259,NULL,'User Logged In','2024-08-24 15:29:21','37','Login In'), (260,NULL,'Generateqr Approved','2024-08-24 15:29:48','37','Approval'), (261,NULL,'User Logged Out','2024-08-24 15:37:56','39','Log Out'), (262,NULL,'User Logged In','2024-08-24 15:37:57','39','Login In'), (263,NULL,'Single Print Had Taken','2024-08-24 15:43:14','39','generateqrsr'), (264,NULL,'User Logged In','2024-08-24 15:53:24','37','Login In'), (265,NULL,'Generateqr Approved','2024-08-24 15:53:43','37','Approval'), (266,NULL,'User Logged Out','2024-08-24 15:53:50','37','Log Out'), (267,NULL,'User Logged In','2024-08-24 15:54:24','37','Login In'), (268,NULL,'Generateqr Approved','2024-08-24 15:54:41','37','Approval'), (269,NULL,'User Logged Out','2024-08-24 15:54:45','39','Log Out'), (270,NULL,'User Logged In','2024-08-24 15:54:47','39','Login In'), (271,NULL,'User Logged Out','2024-08-24 15:54:58','37','Log Out'), (272,NULL,'User Logged In','2024-08-24 15:55:18','37','Login In'), (273,NULL,'Single Print Had Taken','2024-08-24 15:55:18','39','generateqrsr'), (274,NULL,'User Logged Out','2024-08-24 15:55:28','37','Log Out'), (275,NULL,'Single Print Had Taken','2024-08-24 15:55:37','39','generateqrsr'), (276,NULL,'Single Print Had Taken','2024-08-24 15:55:58','39','generateqrsr'), (277,NULL,'User Logged In','2024-08-24 16:52:50','37','Login In'), (278,NULL,'User Logged Out','2024-08-24 16:53:34','37','Log Out'), (279,NULL,'User Logged In','2024-08-24 16:53:36','36','Login In'), (280,NULL,'User Logged In','2024-09-14 13:15:36','39','Login In'), (281,NULL,'QR generated','2024-09-14 13:26:24','39','Generateqr'), (282,NULL,'User Logged In','2024-09-14 15:35:20','39','Login In'), (283,NULL,'Batch Added','2024-09-14 15:40:50','39','Batch'), (284,NULL,'QR generated','2024-09-14 15:42:06','39','Generateqr'), (285,NULL,'Batch Added','2024-09-14 15:52:14','39','Batch'), (286,NULL,'User Logged In','2024-09-14 15:53:37','37','Login In'), (287,NULL,'Generateqr Approved','2024-09-14 15:55:28','37','Approval'), (288,NULL,'Batch Approved','2024-09-14 15:55:52','37','Approval'), (289,NULL,'Generateqr Approved','2024-09-14 15:56:17','37','Approval'), (290,NULL,'Batch Approved','2024-09-14 15:56:58','37','Approval'), (291,NULL,'User Logged Out','2024-09-14 15:58:44','37','Log Out'), (292,NULL,'QR generated','2024-09-14 15:59:00','39','Generateqr'), (293,NULL,'User Logged In','2024-09-14 15:59:07','37','Login In'), (294,NULL,'Generateqr Approved','2024-09-14 15:59:55','37','Approval'), (295,NULL,'User Logged Out','2024-09-14 16:00:14','37','Log Out'), (296,NULL,'User Logged In','2024-09-14 16:48:28','39','Login In'), (297,NULL,'QR Deleted','2024-09-14 17:36:38','39','Generateqr'), (298,NULL,'Multiple Print Had Taken','2024-09-14 17:37:05','39','generateqrsr'), (299,NULL,'User Logged In','2024-09-14 17:38:11','39','Login In'), (300,NULL,'Multiple Print Had Taken','2024-09-14 17:38:42','39','generateqrsr'), (301,NULL,'QR generated','2024-09-14 17:42:43','39','Generateqr'), (302,NULL,'User Logged In','2024-09-14 17:43:09','37','Login In'), (303,NULL,'Generateqr Approved','2024-09-14 17:43:26','37','Approval'), (304,NULL,'Multiple Print Had Taken','2024-09-14 17:44:18','39','generateqrsr'), (305,NULL,'QR generated','2024-09-14 17:48:34','39','Generateqr'), (306,NULL,'Generateqr Approved','2024-09-14 17:48:47','37','Approval'), (307,NULL,'Multiple Print Had Taken','2024-09-14 17:49:01','39','generateqrsr'), (308,NULL,'User Logged In','2024-09-14 18:09:46','39','Login In'), (309,NULL,'Multiple Print Had Taken','2024-09-14 18:09:57','39','generateqrsr'), (310,NULL,'User Logged In','2024-09-17 12:56:35','39','Login In'), (311,NULL,'User Logged In','2024-09-17 19:20:23','39','Login In'), (312,NULL,'User Logged In','2024-09-18 09:42:03','39','Login In'), (313,NULL,'User Logged In','2024-09-18 09:43:09','37','Login In'), (314,NULL,'Batch Added','2024-09-18 09:44:13','39','Batch'), (315,NULL,'Batch Approved','2024-09-18 09:44:25','37','Approval'), (316,NULL,'Alias Product Added','2024-09-18 09:45:18','39','Alias Product'), (317,NULL,'Alias Product Approved','2024-09-18 09:45:25','37','Approval'), (318,NULL,'Storage Condition Added','2024-09-18 09:46:28','39','Storage Condition'), (319,NULL,'Storage Condition Approved','2024-09-18 09:46:34','37','Storage Condition'), (320,NULL,'QR generated','2024-09-18 09:47:05','39','Generateqr'), (321,NULL,'Generateqr Approved','2024-09-18 09:47:11','37','Approval'), (322,NULL,'QR generated','2024-09-18 09:48:10','39','Generateqr'), (323,NULL,'Generateqr Approved','2024-09-18 09:48:18','37','Approval'), (324,NULL,'Multiple Print Had Taken','2024-09-18 09:48:58','39','generateqrsr'), (325,NULL,'Multiple Print Had Taken','2024-09-18 09:49:41','37','generateqrsr'), (326,NULL,'Single Print Had Taken','2024-09-18 09:50:04','37','generateqrsr'), (327,NULL,'User Logged In','2024-09-18 12:34:26','39','Login In'), (328,NULL,'Batch Added','2024-09-18 12:35:22','39','Batch'), (329,NULL,'Batch Added','2024-09-18 12:36:14','39','Batch'), (330,NULL,'Batch Added','2024-09-18 12:37:14','39','Batch'), (331,NULL,'User Logged In','2024-09-18 12:47:21','39','Login In'), (332,NULL,'Batch Added','2024-09-18 12:48:14','39','Batch'), (333,NULL,'Batch Added','2024-09-18 12:49:50','39','Batch'), (334,NULL,'Alias Product Added','2024-09-18 12:50:43','39','Alias Product'), (335,NULL,'Product Updated','2024-09-18 12:51:01','39','Product'), (336,NULL,'User Logged In','2024-09-18 13:42:44','39','Login In'), (337,NULL,'QR Deleted','2024-09-18 13:43:33','39','Generateqr'), (338,NULL,'User Logged In','2024-09-18 14:05:52','37','Login In'), (339,NULL,'Batch Approved','2024-09-18 14:06:25','37','Approval'), (340,NULL,'Batch Approved','2024-09-18 14:06:46','37','Approval'), (341,NULL,'Batch Approved','2024-09-18 14:07:08','37','Approval'), (342,NULL,'Batch Approved','2024-09-18 14:07:20','37','Approval'), (343,NULL,'Batch Approved','2024-09-18 14:07:40','37','Approval'), (344,NULL,'Alias Product Approved','2024-09-18 14:08:13','37','Approval'), (345,NULL,'Product Approved','2024-09-18 14:08:36','37','Approval'), (346,NULL,'User Logged Out','2024-09-18 14:08:42','37','Log Out'), (347,NULL,'User Logged In','2024-09-18 17:14:09','39','Login In'), (348,NULL,'User Logged In','2024-09-19 12:17:06','39','Login In'), (349,NULL,'QR generated','2024-09-19 12:17:58','39','Generateqr'), (350,NULL,'QR generated','2024-09-19 12:18:41','39','Generateqr'), (351,NULL,'QR generated','2024-09-19 12:19:11','39','Generateqr'), (352,NULL,'QR generated','2024-09-19 12:19:57','39','Generateqr'), (353,NULL,'User Logged In','2024-09-19 15:28:13','37','Login In'), (354,NULL,'Generateqr Approved','2024-09-19 15:28:29','37','Approval'), (355,NULL,'Generateqr Approved','2024-09-19 15:28:49','37','Approval'), (356,NULL,'Generateqr Approved','2024-09-19 15:29:01','37','Approval'), (357,NULL,'Generateqr Approved','2024-09-19 15:29:35','37','Approval'), (358,NULL,'User Logged Out','2024-09-19 15:30:29','37','Log Out'), (359,NULL,'User Logged In','2024-09-19 16:45:26','39','Login In'), (360,NULL,'User Logged In','2024-09-19 17:42:00','36','Login In'), (361,NULL,'User Logged In','2024-09-19 18:02:01','36','Login In'), (362,NULL,'User Logged In','2024-09-19 18:03:06','36','Login In'), (363,NULL,'User Logged In','2024-09-19 18:03:45','36','Login In'), (364,NULL,'User Logged In','2024-09-19 18:05:11','36','Login In'), (365,NULL,'User Logged In','2024-09-19 18:12:11','36','Login In'), (366,NULL,'User Logged In','2024-09-19 18:22:57','36','Login In'), (367,NULL,'User Logged In','2024-09-19 19:00:01','39','Login In'), (368,NULL,'User Logged In','2024-09-19 19:00:28','39','Login In'), (369,NULL,'Single Print Had Taken','2024-09-19 19:00:57','39','generateqrsr'), (370,NULL,'Single Print Had Taken','2024-09-19 19:01:19','39','generateqrsr'), (371,NULL,'Single Print Had Taken','2024-09-19 19:02:19','39','generateqrsr'), (372,NULL,'Single Print Had Taken','2024-09-19 19:02:55','39','generateqrsr'), (373,NULL,'Single Print Had Taken','2024-09-19 19:03:29','39','generateqrsr'), (374,NULL,'Single Print Had Taken','2024-09-19 19:04:42','39','generateqrsr'), (375,NULL,'Single Print Had Taken','2024-09-19 19:05:28','39','generateqrsr'), (376,NULL,'Single Print Had Taken','2024-09-19 19:06:38','39','generateqrsr'), (377,NULL,'Single Print Had Taken','2024-09-19 19:07:18','39','generateqrsr'), (378,NULL,'Multiple Print Had Taken','2024-09-19 19:08:27','39','generateqrsr'), (379,NULL,'Multiple Print Had Taken','2024-09-19 19:10:57','39','generateqrsr'), (380,NULL,'Multiple Print Had Taken','2024-09-19 19:11:59','39','generateqrsr'), (381,NULL,'Multiple Print Had Taken','2024-09-19 19:13:21','39','generateqrsr'), (382,NULL,'Multiple Print Had Taken','2024-09-19 19:18:52','39','generateqrsr'), (383,NULL,'User Logged In','2024-09-20 13:54:41','39','Login In'), (384,NULL,'User Logged In','2024-09-20 15:58:50','39','Login In'), (385,NULL,'QR generated','2024-09-20 16:01:03','39','Generateqr'), (386,NULL,'QR generated','2024-09-20 16:03:07','39','Generateqr'), (387,NULL,'Batch Added','2024-09-20 16:04:49','39','Batch'), (388,NULL,'User Logged In','2024-09-20 16:17:06','37','Login In'), (389,NULL,'Generateqr Approved','2024-09-20 16:17:28','37','Approval'), (390,NULL,'Generateqr Approved','2024-09-20 16:17:39','37','Approval'), (391,NULL,'Batch Approved','2024-09-20 16:18:06','37','Approval'), (392,NULL,'User Logged Out','2024-09-20 16:18:14','37','Log Out'), (393,NULL,'QR generated','2024-09-20 16:19:12','39','Generateqr'), (394,NULL,'User Logged In','2024-09-20 16:19:47','37','Login In'), (395,NULL,'Generateqr Approved','2024-09-20 16:20:16','37','Approval'), (396,NULL,'Single Print Had Taken','2024-09-20 16:26:24','39','generateqrsr'), (397,NULL,'Single Print Had Taken','2024-09-20 16:27:13','39','generateqrsr'), (398,NULL,'Single Print Had Taken','2024-09-20 16:29:01','39','generateqrsr'), (399,NULL,'Single Print Had Taken','2024-09-20 16:29:25','39','generateqrsr'), (400,NULL,'User Logged In','2024-09-21 11:19:13','39','Login In'), (401,NULL,'Batch Added','2024-09-21 11:20:39','39','Batch'), (402,NULL,'User Logged In','2024-09-21 14:22:59','39','Login In'), (403,NULL,'User Logged In','2024-09-21 14:57:43','37','Login In'), (404,NULL,'Batch Approved','2024-09-21 14:59:08','37','Approval'), (405,NULL,'User Logged In','2024-09-21 20:09:07','39','Login In'), (406,NULL,'Single Print Had Taken','2024-09-21 20:09:50','39','generateqrsr'), (407,NULL,'Single Print Had Taken','2024-09-21 20:10:27','39','generateqrsr'), (408,NULL,'Single Print Had Taken','2024-09-21 20:10:43','39','generateqrsr'), (409,NULL,'User Logged In','2024-09-21 20:11:34','39','Login In'), (410,NULL,'Single Print Had Taken','2024-09-21 20:11:51','39','generateqrsr'), (411,NULL,'Multiple Print Had Taken','2024-09-21 20:12:22','39','generateqrsr'), (412,NULL,'Single Print Had Taken','2024-09-21 20:21:59','39','generateqrsr'), (413,NULL,'Single Print Had Taken','2024-09-21 20:22:33','39','generateqrsr'), (414,NULL,'Single Print Had Taken','2024-09-21 20:22:51','39','generateqrsr'), (415,NULL,'Single Print Had Taken','2024-09-21 20:24:07','39','generateqrsr'), (416,NULL,'Single Print Had Taken','2024-09-21 20:25:09','39','generateqrsr'), (417,NULL,'Single Print Had Taken','2024-09-21 20:25:34','39','generateqrsr'), (418,NULL,'Single Print Had Taken','2024-09-21 20:27:33','39','generateqrsr'), (419,NULL,'Single Print Had Taken','2024-09-21 20:28:48','39','generateqrsr'), (420,NULL,'Single Print Had Taken','2024-09-21 20:29:18','39','generateqrsr'), (421,NULL,'Single Print Had Taken','2024-09-21 20:29:59','39','generateqrsr'), (422,NULL,'Single Print Had Taken','2024-09-21 20:32:11','39','generateqrsr'), (423,NULL,'User Logged In','2024-09-22 14:18:00','39','Login In'), (424,NULL,'QR generated','2024-09-22 14:18:48','39','Generateqr'), (425,NULL,'User Logged In','2024-09-22 16:03:39','39','Login In'), (426,NULL,'User Logged In','2024-09-22 16:45:05','37','Login In'), (427,NULL,'Generateqr Approved','2024-09-22 16:45:21','37','Approval'), (428,NULL,'User Logged In','2024-09-22 18:07:16','39','Login In'), (429,NULL,'User Logged In','2024-09-22 18:33:17','39','Login In'), (430,NULL,'QR generated','2024-09-22 18:34:33','39','Generateqr'), (431,NULL,'Single Print Had Taken','2024-09-22 18:37:39','39','generateqrsr'), (432,NULL,'User Logged In','2024-09-22 18:39:05','39','Login In'), (433,NULL,'Single Print Had Taken','2024-09-22 18:39:35','39','generateqrsr'), (434,NULL,'User Logged In','2024-09-24 11:30:20','39','Login In'), (435,NULL,'User Logged In','2024-09-24 12:00:09','39','Login In'), (436,NULL,'User Logged In','2024-09-24 12:03:59','37','Login In'), (437,NULL,'Single Print Had Taken','2024-09-24 12:04:54','37','generateqrsr'), (438,NULL,'Single Print Had Taken','2024-09-24 12:05:27','37','generateqrsr'), (439,NULL,'Single Print Had Taken','2024-09-24 12:05:58','37','generateqrsr'), (440,NULL,'User Logged In','2024-09-24 12:07:38','37','Login In'), (441,NULL,'Generateqr Approved','2024-09-24 12:08:47','37','Approval'), (442,NULL,'User Logged In','2024-09-24 13:15:47','39','Login In'), (443,NULL,'Single Print Had Taken','2024-09-24 13:16:08','39','generateqrsr'), (444,NULL,'User Logged In','2024-09-24 15:30:50','36','Login In'), (445,NULL,'User Logged In','2024-09-25 17:57:28','39','Login In'), (446,NULL,'Single Print Had Taken','2024-09-25 17:58:31','39','generateqrsr'), (447,NULL,'Single Print Had Taken','2024-09-25 17:59:12','39','generateqrsr'), (448,NULL,'Single Print Had Taken','2024-09-25 17:59:42','39','generateqrsr'), (449,NULL,'Single Print Had Taken','2024-09-25 18:00:21','39','generateqrsr'), (450,NULL,'Single Print Had Taken','2024-09-25 18:00:47','39','generateqrsr'), (451,NULL,'Single Print Had Taken','2024-09-25 18:01:11','39','generateqrsr'), (452,NULL,'User Logged In','2024-09-26 12:42:29','36','Login In'), (453,NULL,'User Logged In','2024-09-26 12:42:31','36','Login In'), (454,NULL,'User Logged In','2024-09-26 18:48:19','36','Login In'), (455,NULL,'User Logged In','2024-09-26 18:49:07','36','Login In'), (456,NULL,'User Logged In','2024-09-26 19:00:33','36','Login In'), (457,NULL,'User Logged In','2024-09-26 19:08:25','36','Login In'), (458,NULL,'User Logged In','2024-09-26 19:14:52','36','Login In'), (459,NULL,'User Logged In','2024-09-26 19:30:47','36','Login In'), (460,NULL,'User Logged In','2024-09-26 20:11:32','39','Login In'), (461,NULL,'Batch Added','2024-09-26 20:24:39','39','Batch'), (462,NULL,'User Logged In','2024-09-26 20:36:33','39','Login In'), (463,NULL,'User Logged In','2024-09-27 13:51:19','39','Login In'), (464,NULL,'QR generated','2024-09-27 13:53:49','39','Generateqr'), (465,NULL,'User Logged In','2024-09-27 16:30:57','39','Login In'), (466,NULL,'User Logged In','2024-09-27 17:45:42','39','Login In'), (467,NULL,'User Logged In','2024-09-27 17:47:09','37','Login In'), (468,NULL,'User Logged In','2024-09-27 19:46:52','36','Login In'), (469,NULL,'User Logged In','2024-09-27 20:01:46','36','Login In'), (470,NULL,'User Logged In','2024-09-28 11:06:49','39','Login In'), (471,NULL,'Batch Added','2024-09-28 11:12:45','39','Batch'), (472,NULL,'QR generated','2024-09-28 11:14:17','39','Generateqr'), (473,NULL,'QR generated','2024-09-28 11:15:44','39','Generateqr'), (474,NULL,'Alias Product Added','2024-09-28 11:16:42','39','Alias Product'), (475,NULL,'User Logged In','2024-09-28 11:57:03','39','Login In'), (476,NULL,'User Logged In','2024-09-28 12:19:58','39','Login In'), (477,NULL,'Storage Condition Added','2024-09-28 12:44:51','39','Storage Condition'), (478,NULL,'User Logged In','2024-09-28 13:40:58','39','Login In'), (479,NULL,'User Logged In','2024-09-28 15:06:28','37','Login In'), (480,NULL,'Batch Approved','2024-09-28 15:08:05','37','Approval'), (481,NULL,'Generateqr Approved','2024-09-28 15:08:18','37','Approval'), (482,NULL,'Batch Approved','2024-09-28 15:08:38','37','Approval'), (483,NULL,'Generateqr Approved','2024-09-28 15:08:52','37','Approval'), (484,NULL,'Generateqr Approved','2024-09-28 15:09:05','37','Approval'), (485,NULL,'Storage Condition Approved','2024-09-28 15:10:10','37','Storage Condition'), (486,NULL,'User Logged Out','2024-09-28 15:10:30','37','Log Out'), (487,NULL,'User Logged In','2024-09-28 15:12:48','39','Login In'), (488,NULL,'User Logged In','2024-09-28 15:14:28','37','Login In'), (489,NULL,'Storage Condition Added','2024-09-28 15:15:11','39','Storage Condition'), (490,NULL,'Storage Condition Approved','2024-09-28 15:15:18','37','Storage Condition'), (491,NULL,'QR generated','2024-09-28 15:16:10','39','Generateqr'), (492,NULL,'QR generated','2024-09-28 15:16:37','39','Generateqr'), (493,NULL,'QR generated','2024-09-28 15:17:07','39','Generateqr'), (494,NULL,'User Logged Out','2024-09-28 15:19:01','37','Log Out'), (495,NULL,'Multiple Print Had Taken','2024-09-28 15:22:01','39','generateqrsr'), (496,NULL,'User Logged In','2024-09-28 15:23:24','39','Login In'), (497,NULL,'Multiple Print Had Taken','2024-09-28 15:23:48','39','generateqrsr'), (498,NULL,'Multiple Print Had Taken','2024-09-28 15:24:09','39','generateqrsr'), (499,NULL,'Multiple Print Had Taken','2024-09-28 15:25:38','39','generateqrsr'), (500,NULL,'User Logged In','2024-09-28 16:02:44','39','Login In'), (501,NULL,'User Logged In','2024-09-28 16:22:12','39','Login In'), (502,NULL,'User Logged In','2024-09-28 16:43:09','39','Login In'), (503,NULL,'User Logged In','2024-09-28 17:12:57','39','Login In'), (504,NULL,'User Logged In','2024-09-28 17:13:28','37','Login In'), (505,NULL,'Alias Product Approved','2024-09-28 17:13:42','37','Approval'), (506,NULL,'Generateqr Approved','2024-09-28 17:13:59','37','Approval'), (507,NULL,'Generateqr Approved','2024-09-28 17:14:11','37','Approval'), (508,NULL,'Generateqr Approved','2024-09-28 17:14:25','37','Approval'), (509,NULL,'User Logged Out','2024-09-28 17:14:38','37','Log Out'), (510,NULL,'User Logged In','2024-09-28 19:03:57','39','Login In'), (511,NULL,'Multiple Print Had Taken','2024-09-28 19:05:10','39','generateqrsr'), (512,NULL,'Single Print Had Taken','2024-09-28 19:05:40','39','generateqrsr'), (513,NULL,'Single Print Had Taken','2024-09-28 19:06:15','39','generateqrsr'), (514,NULL,'Single Print Had Taken','2024-09-28 19:06:51','39','generateqrsr'), (515,NULL,'Single Print Had Taken','2024-09-28 19:07:18','39','generateqrsr'), (516,NULL,'Single Print Had Taken','2024-09-28 19:08:28','39','generateqrsr'), (517,NULL,'Single Print Had Taken','2024-09-28 19:09:00','39','generateqrsr'), (518,NULL,'Multiple Print Had Taken','2024-09-28 19:10:08','39','generateqrsr'), (519,NULL,'Single Print Had Taken','2024-09-28 19:13:34','39','generateqrsr'), (520,NULL,'Single Print Had Taken','2024-09-28 19:14:10','39','generateqrsr'), (521,NULL,'User Logged In','2024-09-29 11:55:22','39','Login In'), (522,NULL,'User Logged In','2024-09-29 14:23:13','37','Login In'), (523,NULL,'User Logged Out','2024-09-29 14:23:20','37','Log Out'), (524,NULL,'User Logged In','2024-10-01 11:11:40','36','Login In'), (525,NULL,'User Logged In','2024-10-01 11:33:49','36','Login In'), (526,NULL,'User Logged In','2024-10-01 11:36:16','36','Login In'), (527,NULL,'User Logged In','2024-10-01 11:44:46','36','Login In'), (528,NULL,'User Logged In','2024-10-01 11:46:51','36','Login In'), (529,NULL,'User Logged In','2024-10-01 11:57:10','36','Login In'), (530,NULL,'User Logged In','2024-10-01 13:25:15','39','Login In'), (531,NULL,'User Logged In','2024-10-01 16:58:05','36','Login In'), (532,NULL,'User Logged In','2024-10-01 17:58:34','39','Login In'), (533,NULL,'User Logged In','2024-10-01 17:59:24','39','Login In'), (534,NULL,'User Logged In','2024-10-01 18:52:53','39','Login In'), (535,NULL,'User Logged In','2024-10-02 12:54:27','39','Login In'), (536,NULL,'Product Updated','2024-10-02 12:55:34','39','Product'), (537,NULL,'User Logged In','2024-10-02 13:01:50','37','Login In'), (538,NULL,'Product Approved','2024-10-02 13:02:12','37','Approval'), (539,NULL,'Storage Condition Added','2024-10-02 13:03:32','39','Storage Condition'), (540,NULL,'Storage Condition Approved','2024-10-02 13:03:40','37','Storage Condition'), (541,NULL,'Alias Product Edited','2024-10-02 13:04:19','39','Alias Product'), (542,NULL,'Alias Product Updated','2024-10-02 13:04:20','39','Alias Product'), (543,NULL,'Alias Product Approved','2024-10-02 13:04:27','37','Approval'), (544,NULL,'Product Updated','2024-10-02 13:05:39','39','Product'), (545,NULL,'Product Approved','2024-10-02 13:05:46','37','Approval'), (546,NULL,'Batch Updated','2024-10-02 13:06:01','39','Batch'), (547,NULL,'Batch Approved','2024-10-02 13:06:07','37','Approval'), (548,NULL,'QR generated','2024-10-02 13:06:36','39','Generateqr'), (549,NULL,'Generateqr Approved','2024-10-02 13:06:44','37','Approval'), (550,NULL,'Single Print Had Taken','2024-10-02 13:07:04','39','generateqrsr'), (551,NULL,'Single Print Had Taken','2024-10-02 13:07:38','37','generateqrsr'), (552,NULL,'Single Print Had Taken','2024-10-02 13:08:58','37','generateqrsr'), (553,NULL,'Single Print Had Taken','2024-10-02 13:09:14','37','generateqrsr'), (554,NULL,'Single Print Had Taken','2024-10-02 13:09:55','37','generateqrsr'), (555,NULL,'User Logged In','2024-10-02 13:52:03','36','Login In'), (556,NULL,'User Logged In','2024-10-02 16:11:24','36','Login In'), (557,NULL,'User Logged In','2024-10-02 16:13:40','36','Login In'), (558,NULL,'User Logged In','2024-10-02 16:50:49','36','Login In'), (559,NULL,'User Logged In','2024-10-04 11:12:30','36','Login In'), (560,NULL,'User Logged In','2024-10-04 12:01:46','36','Login In'), (561,NULL,'User Logged In','2024-10-04 13:23:34','36','Login In'), (562,NULL,'User Logged In','2024-10-04 13:30:54','36','Login In'), (563,NULL,'User Logged In','2024-10-04 19:10:42','36','Login In'), (564,NULL,'New User Added','2024-10-04 19:11:29','36','Rights Management'), (565,NULL,'User Updated','2024-10-04 19:12:45','36','Rights Management'), (566,NULL,'User Updated','2024-10-04 19:13:26','36','Rights Management'), (567,NULL,'User Updated','2024-10-04 19:15:47','36','Rights Management'), (568,NULL,'User Logged Out','2024-10-04 19:15:55','36','Log Out'), (569,NULL,'User Logged In','2024-10-04 19:16:04','44','Login In'), (570,NULL,'User Logged In','2024-10-05 10:24:43','39','Login In'), (571,NULL,'Single Print Had Taken','2024-10-05 10:25:05','39','generateqrsr'), (572,NULL,'Single Print Had Taken','2024-10-05 10:25:31','39','generateqrsr'), (573,NULL,'User Logged In','2024-10-05 10:46:57','39','Login In'), (574,NULL,'User Logged In','2024-10-05 15:08:59','36','Login In'), (575,NULL,'User Logged In','2024-10-05 17:18:25','39','Login In'), (576,NULL,'Single Print Had Taken','2024-10-05 17:19:01','39','generateqrsr'), (577,NULL,'Single Print Had Taken','2024-10-05 17:19:17','39','generateqrsr'), (578,NULL,'User Logged In','2024-10-06 13:26:18','39','Login In'), (579,NULL,'Multiple Print Had Taken','2024-10-06 13:26:37','39','generateqrsr'), (580,NULL,'User Logged In','2024-10-06 13:27:48','39','Login In'), (581,NULL,'Multiple Print Had Taken','2024-10-06 13:28:26','39','generateqrsr'), (582,NULL,'User Logged In','2024-10-07 10:46:51','36','Login In'), (583,NULL,'User Updated','2024-10-07 10:49:18','36','Rights Management'), (584,NULL,'User Logged Out','2024-10-07 10:49:27','36','Log Out'), (585,NULL,'User Logged In','2024-10-07 10:49:33','36','Login In'), (586,NULL,'User Logged In','2024-10-07 15:22:56','36','Login In'), (587,NULL,'User Updated','2024-10-07 15:23:14','36','Rights Management'), (588,NULL,'User Logged Out','2024-10-07 15:23:19','36','Log Out'), (589,NULL,'User Logged In','2024-10-07 15:23:27','36','Login In'), (590,NULL,'User Updated','2024-10-07 15:24:02','36','Rights Management'), (591,NULL,'User Logged Out','2024-10-07 15:24:05','36','Log Out'), (592,NULL,'User Logged In','2024-10-07 15:24:13','36','Login In'), (593,NULL,'User Updated','2024-10-07 15:24:53','36','Rights Management'), (594,NULL,'User Logged Out','2024-10-07 15:24:55','36','Log Out'), (595,NULL,'User Logged In','2024-10-07 15:25:04','36','Login In'), (596,NULL,'User Logged Out','2024-10-07 15:36:02','36','Log Out'), (597,NULL,'User Logged In','2024-10-07 15:36:07','36','Login In'), (598,NULL,'User Updated','2024-10-07 15:37:23','36','Rights Management'), (599,NULL,'User Logged Out','2024-10-07 15:37:26','36','Log Out'), (600,NULL,'User Logged In','2024-10-07 15:37:36','36','Login In'), (601,NULL,'New Product Added','2024-10-07 15:42:16','36','Product'), (602,NULL,'Product Approved','2024-10-07 15:42:22','36','Approval'), (603,NULL,'Batch Added','2024-10-07 15:42:55','36','Batch'), (604,NULL,'Batch Approved','2024-10-07 15:43:01','36','Approval'), (605,NULL,'Alias Product Added','2024-10-07 15:43:20','36','Alias Product'), (606,NULL,'Alias Product Approved','2024-10-07 15:43:24','36','Approval'), (607,NULL,'Storage Condition Added','2024-10-07 15:43:47','36','Storage Condition'), (608,NULL,'Storage Condition Approved','2024-10-07 15:43:57','36','Storage Condition'), (609,NULL,'QR generated','2024-10-07 15:44:32','36','Generateqr'), (610,NULL,'Generateqr Approved','2024-10-07 15:44:40','36','Approval'), (611,NULL,'Single Print Had Taken','2024-10-07 15:45:03','36','generateqrsr'), (612,NULL,'Multiple Print Had Taken','2024-10-07 15:45:31','36','generateqrsr'), (613,NULL,'User Logged In','2024-10-07 20:23:22','39','Login In'), (614,NULL,'User Logged In','2024-10-07 20:42:11','36','Login In'), (615,NULL,'User Logged In','2024-10-08 13:48:30','39','Login In'), (616,NULL,'Single Print Had Taken','2024-10-08 13:48:54','39','generateqrsr'), (617,NULL,'User Logged In','2024-10-08 13:49:49','39','Login In'), (618,NULL,'Single Print Had Taken','2024-10-08 13:50:07','39','generateqrsr'), (619,NULL,'User Logged In','2024-10-09 20:28:23','36','Login In'), (620,NULL,'User Logged In','2024-10-10 08:20:03','36','Login In'), (621,NULL,'User Logged Out','2024-10-10 08:21:03','36','Log Out'), (622,NULL,'User Logged In','2024-10-11 12:56:03','36','Login In'), (623,NULL,'User Logged In','2024-10-14 11:27:45','36','Login In'), (624,NULL,'User Logged In','2024-10-14 12:29:01','36','Login In'), (625,NULL,'User Logged In','2024-10-14 13:33:10','36','Login In'), (626,NULL,'User Logged In','2024-10-14 18:34:08','36','Login In'), (627,NULL,'User Logged In','2024-10-14 19:16:42','36','Login In'), (628,NULL,'User Logged In','2024-10-15 11:34:59','36','Login In'), (629,NULL,'User Updated','2024-10-15 11:35:41','36','Rights Management'), (630,NULL,'User Logged In','2024-10-15 17:29:29','36','Login In'); /*!40000 ALTER TABLE `logtable` ENABLE KEYS */; -- -- Definition of manufacture -- DROP TABLE IF EXISTS `manufacture`; CREATE TABLE IF NOT EXISTS `manufacture` ( `id` int(11) NOT NULL AUTO_INCREMENT, `manu` varchar(255) DEFAULT '', `dis` varchar(255) DEFAULT '', `lic` varchar(255) DEFAULT '', `prefix` varchar(255) DEFAULT '', `add1` varchar(1000) DEFAULT '', `details` text, `add2` varchar(1000) DEFAULT NULL, `created` datetime DEFAULT NULL, `updated` datetime DEFAULT NULL, `userid` varchar(50) DEFAULT NULL, `deletestatus` varchar(50) DEFAULT NULL, `manuaprstatus` varchar(50) DEFAULT NULL, `manrejstatus` varchar(50) DEFAULT NULL, `manuaprtime` datetime DEFAULT NULL, `manurejtime` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- -- Dumping data for table manufacture -- /*!40000 ALTER TABLE `manufacture` DISABLE KEYS */; INSERT INTO `manufacture`(`id`,`manu`,`dis`,`lic`,`prefix`,`add1`,`details`,`add2`,`created`,`updated`,`userid`,`deletestatus`,`manuaprstatus`,`manrejstatus`,`manuaprtime`,`manurejtime`) VALUES (1,'LAXACHEM ORGANICS PVT. LTD.','LAXACHEM ORGANICS PVT LTD','(25) AMD/3/96','890618164','Plot No. D-2, MIDC',NULL,'AMRAVATI-444 607. (Maharashtra) INDIA ','2024-08-03 11:21:56','2024-08-16 14:56:29','39','0','1','0','2024-08-16 17:09:25',NULL); /*!40000 ALTER TABLE `manufacture` ENABLE KEYS */; -- -- Definition of pagemaster -- DROP TABLE IF EXISTS `pagemaster`; CREATE TABLE IF NOT EXISTS `pagemaster` ( `id` int(11) NOT NULL AUTO_INCREMENT, `roleid` varchar(50) NOT NULL DEFAULT '0', `pageid` varchar(50) NOT NULL DEFAULT '0', `pagename` varchar(50) NOT NULL DEFAULT '0', `status` varchar(50) NOT NULL DEFAULT '0', `rejstatus` varchar(50) NOT NULL DEFAULT '0', `createdat` datetime NOT NULL, `approvedat` datetime DEFAULT NULL, `rejremark` varchar(150) DEFAULT NULL, `rejectedat` datetime DEFAULT NULL, `itemname` varchar(500) DEFAULT NULL, `purpose` varchar(500) DEFAULT NULL, `deletestatus` varchar(500) DEFAULT NULL, `userid` varchar(500) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=98 DEFAULT CHARSET=utf8; -- -- Dumping data for table pagemaster -- /*!40000 ALTER TABLE `pagemaster` DISABLE KEYS */; INSERT INTO `pagemaster`(`id`,`roleid`,`pageid`,`pagename`,`status`,`rejstatus`,`createdat`,`approvedat`,`rejremark`,`rejectedat`,`itemname`,`purpose`,`deletestatus`,`userid`) VALUES (4,'37','2','product','1','0','2024-08-03 12:58:20','2024-08-03 16:33:10',NULL,NULL,'DOCUSATE SODIUM','New Item','0','39'), (7,'37','5','product','1','0','2024-08-03 13:10:06','2024-08-04 13:07:16',NULL,NULL,'Sodium salt of 4-Chloro-2-[(furan-2-ylmethyl)amino]5-sulfamoylbenzoic acid','New Item','0','39'), (10,'37','1','product','1','0','2024-08-03 13:27:27','2024-08-03 16:33:41',NULL,NULL,'CHLOROBUTANOL','Edit','0','39'), (12,'37','7','product','1','0','2024-08-03 16:29:29','2024-08-03 16:36:24',NULL,NULL,'CHLOROBUTANOL','New Item','0','39'), (13,'37','4','product','1','0','2024-08-03 16:43:31','2024-08-04 12:59:43',NULL,NULL,'PROPYL GALLATE','Edit','0','39'), (14,'37','6','product','1','0','2024-08-04 13:08:23','2024-08-04 14:31:49',NULL,NULL,'FUROSEMIDE','Edit','0','39'), (21,'37','1','pbatch','1','0','2024-08-09 12:06:49','2024-08-09 16:12:02',NULL,NULL,'CH-40724','Delete','1','39'), (22,'37','2','pbatch','1','0','2024-08-09 12:06:52','2024-08-09 16:12:31',NULL,NULL,'CH-40624','Delete','1','39'), (23,'37','3','pbatch','1','0','2024-08-09 12:06:55','2024-08-09 16:12:53',NULL,NULL,'CH-50624','Delete','1','39'), (24,'37','4','pbatch','1','0','2024-08-09 12:08:25','2024-08-09 16:14:10',NULL,NULL,'CH-10824','New Item','0','39'), (25,'37','5','pbatch','1','0','2024-08-09 12:09:19','2024-08-09 16:14:53',NULL,NULL,'CH-20824','New Item','0','39'), (26,'37','6','pbatch','1','0','2024-08-09 12:10:00','2024-08-09 16:15:42',NULL,NULL,'CH-30824','New Item','0','39'), (27,'37','7','pbatch','1','0','2024-08-09 12:10:44','2024-08-09 16:16:25',NULL,NULL,'CH-40824','New Item','0','39'), (28,'37','8','pbatch','1','0','2024-08-09 12:11:30','2024-08-09 16:16:43',NULL,NULL,'CH-50824','New Item','0','39'), (29,'37','1','addproduct','1','0','2024-08-10 12:45:56','2024-08-10 16:45:02',NULL,NULL,'CHLOROBUTANOL','New Item','0','39'), (30,'37','2','addproduct','1','0','2024-08-10 12:47:08','2024-08-10 16:45:04',NULL,NULL,'CHLORBUTOL','New Item','0','39'), (31,'37','1','storagecondition','1','0','2024-08-11 15:07:16','2024-08-11 16:12:16',NULL,NULL,'In an air tight container','New Item','0','39'), (32,'37','1','generateqr','1','0','2024-08-11 16:13:18','2024-08-11 16:16:38',NULL,NULL,'LAX/0824/001','New Item',NULL,'39'), (34,'37','3','addproduct','1','0','2024-08-14 19:44:19','2024-08-17 11:16:53',NULL,NULL,'CHLORBUTOL (IND. USE ONLY)','Delete','1','39'), (35,'37','1','manufacture','1','0','2024-08-16 14:56:29','2024-08-16 17:09:25',NULL,NULL,'LAXACHEM ORGANICS PVT. LTD.','Edit','0','39'), (36,'37','2','storagecondition','1','0','2024-08-16 15:37:38','2024-08-16 17:10:45',NULL,NULL,'Store protect from moisture at temperature not exceeding 30° C','New Item','0','39'), (37,'37','9','pbatch','1','0','2024-08-17 10:46:22','2024-08-17 11:13:51',NULL,NULL,'FR-10824','New Item','0','39'), (38,'37','4','addproduct','1','0','2024-08-17 11:18:40','2024-08-17 11:18:53',NULL,NULL,'FUROSEMIDE','New Item','0','39'), (39,'37','3','storagecondition','1','0','2024-08-17 11:19:33','2024-08-17 11:23:26',NULL,NULL,'Store protect from moisture and light','New Item','0','39'), (40,'37','2','generateqr','1','0','2024-08-17 11:25:30','2024-08-17 11:28:08',NULL,NULL,'LAX/0824/002','New Item',NULL,'39'), (41,'37','3','generateqr','1','0','2024-08-17 12:10:07','2024-08-17 13:24:01',NULL,NULL,'LAX/0824/003','New Item',NULL,'39'), (42,'37','4','generateqr','1','0','2024-08-21 11:33:59','2024-08-21 11:49:27',NULL,NULL,'LAX/0824/004','New Item',NULL,'39'), (43,'37','5','generateqr','1','0','2024-08-21 11:34:37','2024-08-21 11:49:45',NULL,NULL,'LAX/0824/005','New Item',NULL,'39'), (44,'37','4','storagecondition','1','0','2024-08-23 15:07:55','2024-08-24 15:21:47',NULL,NULL,'Preserve in tight container','New Item','0','39'), (45,'37','6','generateqr','1','0','2024-08-24 15:28:16','2024-08-24 15:54:41',NULL,NULL,'LAX/0824/006','New Item',NULL,'39'), (46,'37','7','generateqr','1','0','2024-09-14 13:26:24','2024-09-14 15:55:28',NULL,NULL,'LAX/0924/007','New Item',NULL,'39'), (47,'37','10','pbatch','1','0','2024-09-14 15:40:51','2024-09-14 15:55:52',NULL,NULL,'CH-20924','New Item','0','39'), (48,'37','8','generateqr','1','0','2024-09-14 15:42:06','2024-09-14 15:56:17',NULL,NULL,'LAX/0924/008','New Item',NULL,'39'), (49,'37','11','pbatch','1','0','2024-09-14 15:52:15','2024-09-14 15:56:58',NULL,NULL,'CH-90824','New Item','0','39'), (50,'37','9','generateqr','1','0','2024-09-14 15:59:01','2024-09-14 15:59:55',NULL,NULL,'LAX/0924/009','New Item',NULL,'39'), (51,'37','10','generateqr','1','0','2024-09-14 17:42:44','2024-09-14 17:43:26',NULL,NULL,'LAX/0924/009','New Item',NULL,'39'), (52,'37','11','generateqr','1','0','2024-09-14 17:48:35','2024-09-14 17:48:47',NULL,NULL,'LAX/0924/011','New Item',NULL,'39'), (53,'37','12','pbatch','1','0','2024-09-18 09:44:13','2024-09-18 09:44:25',NULL,NULL,'DS-10824','New Item','0','39'), (54,'37','5','addproduct','1','0','2024-09-18 09:45:19','2024-09-18 09:45:25',NULL,NULL,'DOCUSATE SODIUM','New Item','0','39'), (55,'37','5','storagecondition','1','0','2024-09-18 09:46:28','2024-09-18 09:46:34',NULL,NULL,'In an air tight container','New Item','0','39'), (56,'37','12','generateqr','1','0','2024-09-18 09:47:05','2024-09-18 09:47:11',NULL,NULL,'LAX/0924/012','New Item',NULL,'39'), (57,'37','13','generateqr','1','0','2024-09-18 09:48:11','2024-09-18 09:48:18',NULL,NULL,'LAX/0924/013','New Item',NULL,'39'), (58,'37','13','pbatch','1','0','2024-09-18 12:35:23','2024-09-18 14:06:25',NULL,NULL,'CH-10924','New Item','0','39'), (59,'37','14','pbatch','1','0','2024-09-18 12:36:15','2024-09-18 14:06:46',NULL,NULL,'CH-30924','New Item','0','39'), (60,'37','15','pbatch','1','0','2024-09-18 12:37:14','2024-09-18 14:07:08',NULL,NULL,'CH-40924','New Item','0','39'), (61,'37','16','pbatch','1','0','2024-09-18 12:48:15','2024-09-18 14:07:20',NULL,NULL,'CH-50924','New Item','0','39'), (65,'37','14','generateqr','1','0','2024-09-19 12:17:58','2024-09-19 15:28:29',NULL,NULL,'LAX/0924/014','New Item',NULL,'39'), (66,'37','15','generateqr','1','0','2024-09-19 12:18:42','2024-09-19 15:28:49',NULL,NULL,'LAX/0924/015','New Item',NULL,'39'), (67,'37','16','generateqr','1','0','2024-09-19 12:19:11','2024-09-19 15:29:01',NULL,NULL,'LAX/0924/016','New Item',NULL,'39'), (68,'37','17','generateqr','1','0','2024-09-19 12:19:58','2024-09-19 15:29:35',NULL,NULL,'LAX/0924/017','New Item',NULL,'39'), (69,'37','18','generateqr','1','0','2024-09-20 16:01:03','2024-09-20 16:17:28',NULL,NULL,'LAX/0924/018','New Item',NULL,'39'), (70,'37','19','generateqr','1','0','2024-09-20 16:03:08','2024-09-20 16:17:39',NULL,NULL,'LAX/0924/019','New Item',NULL,'39'), (71,'37','18','pbatch','1','0','2024-09-20 16:04:50','2024-09-20 16:18:06',NULL,NULL,'CH-70824','New Item','0','39'), (72,'37','20','generateqr','1','0','2024-09-20 16:19:13','2024-09-20 16:20:16',NULL,NULL,'LAX/0924/020','New Item',NULL,'39'), (73,'37','19','pbatch','1','0','2024-09-21 11:20:40','2024-09-21 14:59:08',NULL,NULL,'CH-80824','New Item','0','39'), (74,'37','21','generateqr','1','0','2024-09-22 14:18:48','2024-09-22 16:45:21',NULL,NULL,'LAX/0924/021','New Item',NULL,'39'), (75,'37','22','generateqr','1','0','2024-09-22 18:34:33','2024-09-24 12:08:47',NULL,NULL,'LAX/0924/022','New Item',NULL,'39'), (76,'37','20','pbatch','1','0','2024-09-26 20:24:40','2024-09-28 15:08:05',NULL,NULL,'CH-70924','New Item','0','39'), (77,'37','23','generateqr','1','0','2024-09-27 13:53:50','2024-09-28 15:08:18',NULL,NULL,'LAX/0924/023','New Item',NULL,'39'), (78,'37','21','pbatch','1','0','2024-09-28 11:12:45','2024-09-28 15:08:38',NULL,NULL,'DS-20924','New Item','0','39'), (79,'37','24','generateqr','1','0','2024-09-28 11:14:17','2024-09-28 15:08:52',NULL,NULL,'LAX/0924/024','New Item',NULL,'39'), (80,'37','25','generateqr','1','0','2024-09-28 11:15:45','2024-09-28 15:09:05',NULL,NULL,'LAX/0924/025','New Item',NULL,'39'), (81,'37','7','addproduct','1','0','2024-09-28 11:16:42','2024-09-28 17:13:42',NULL,NULL,'-','New Item','0','39'), (82,'37','6','storagecondition','1','0','2024-09-28 12:44:51','2024-09-28 15:10:10',NULL,NULL,'Preserve in well closed container','New Item','0','39'), (83,'37','7','storagecondition','1','0','2024-09-28 15:15:11','2024-09-28 15:15:18',NULL,NULL,'Preserve in well closed container','New Item','0','39'), (84,'37','26','generateqr','1','0','2024-09-28 15:16:10','2024-09-28 17:13:59',NULL,NULL,'LAX/0924/026','New Item',NULL,'39'), (85,'37','27','generateqr','1','0','2024-09-28 15:16:37','2024-09-28 17:14:11',NULL,NULL,'LAX/0924/027','New Item',NULL,'39'), (86,'37','28','generateqr','1','0','2024-09-28 15:17:08','2024-09-28 17:14:25',NULL,NULL,'LAX/0924/028','New Item',NULL,'39'), (88,'37','8','storagecondition','1','0','2024-10-02 13:03:32','2024-10-02 13:03:40',NULL,NULL,'Preserve in well closed container','New Item','0','39'), (89,'37','6','addproduct','1','0','2024-10-02 13:04:21','2024-10-02 13:04:27',NULL,NULL,'DOCUSATE SODIUM 85%','Edit','0','39'), (90,'37','3','product','1','0','2024-10-02 13:05:39','2024-10-02 13:05:46',NULL,NULL,'DOCUSATE SODIUM 85% POWDER','Edit','0','39'), (91,'37','17','pbatch','1','0','2024-10-02 13:06:02','2024-10-02 13:06:07',NULL,NULL,'DP-10624','Edit','0','39'), (92,'37','29','generateqr','1','0','2024-10-02 13:06:36','2024-10-02 13:06:44',NULL,NULL,'LAX/1024/029','New Item',NULL,'39'), (93,'36','8','product','1','0','2024-10-07 15:42:17','2024-10-07 15:42:22',NULL,NULL,'Test 1','New Item','0','36'), (94,'36','22','pbatch','1','0','2024-10-07 15:42:55','2024-10-07 15:43:01',NULL,NULL,'Test 1 batch','New Item','0','36'), (95,'36','8','addproduct','1','0','2024-10-07 15:43:21','2024-10-07 15:43:24',NULL,NULL,'Test 1 Alias','New Item','0','36'), (96,'36','9','storagecondition','1','0','2024-10-07 15:43:47','2024-10-07 15:43:57',NULL,NULL,'Teest 1 In-House Grade','New Item','0','36'), (97,'36','30','generateqr','1','0','2024-10-07 15:44:32','2024-10-07 15:44:40',NULL,NULL,'LAX/1024/030','New Item',NULL,'36'); /*!40000 ALTER TABLE `pagemaster` ENABLE KEYS */; -- -- Definition of pbatch -- DROP TABLE IF EXISTS `pbatch`; CREATE TABLE IF NOT EXISTS `pbatch` ( `id` int(11) NOT NULL AUTO_INCREMENT, `batch` varchar(255) DEFAULT '', `product` varchar(255) DEFAULT '', `batchsize` varchar(255) DEFAULT '', `batchnumber` varchar(255) DEFAULT '', `mfgdate` date DEFAULT NULL, `expdate` date DEFAULT NULL, `weight` varchar(255) DEFAULT '', `remark` varchar(255) DEFAULT '', `pid` varchar(255) DEFAULT '', `created` datetime DEFAULT NULL, `updated` datetime DEFAULT NULL, `userid` varchar(50) DEFAULT NULL, `deletestatus` varchar(50) DEFAULT NULL, `bataprstatus` varchar(50) DEFAULT NULL, `batrejstatus` varchar(50) DEFAULT NULL, `bataprtime` datetime DEFAULT NULL, `batrejtime` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8; -- -- Dumping data for table pbatch -- /*!40000 ALTER TABLE `pbatch` DISABLE KEYS */; INSERT INTO `pbatch`(`id`,`batch`,`product`,`batchsize`,`batchnumber`,`mfgdate`,`expdate`,`weight`,`remark`,`pid`,`created`,`updated`,`userid`,`deletestatus`,`bataprstatus`,`batrejstatus`,`bataprtime`,`batrejtime`) VALUES (1,'CH-40724','1','500','NA','2024-07-01 00:00:00','2029-06-01 00:00:00','','','IP,BP,EP,USP','2024-08-07 12:00:22','2024-08-07 12:00:22','39','1','1','0','2024-08-09 16:12:02',NULL), (2,'CH-40624','1','500','NA','2024-06-01 00:00:00','2029-05-01 00:00:00','','','IP,BP,EP,USP','2024-08-07 12:00:30','2024-08-07 12:00:30','39','1','1','0','2024-08-09 16:12:31',NULL), (3,'CH-50624','1','500','NA','2024-06-01 00:00:00','2029-05-01 00:00:00','','','IP,BP,EP,USP','2024-08-07 11:58:02',NULL,'39','1','1','0','2024-08-09 16:12:53',NULL), (4,'CH-10824','1','500','NA','2024-08-01 00:00:00','2029-07-01 00:00:00','','','IP,BP,EP,USP','2024-08-09 12:08:25',NULL,'39','0','1','0','2024-08-09 16:14:10',NULL), (5,'CH-20824','1','500','NA','2024-08-01 00:00:00','2029-07-01 00:00:00','','','IP,BP,EP,USP','2024-08-09 12:09:18',NULL,'39','0','1','0','2024-08-09 16:14:53',NULL), (6,'CH-30824','1','500','NA','2024-08-01 00:00:00','2029-07-01 00:00:00','','','IP,BP,EP,USP','2024-08-09 12:09:59',NULL,'39','0','1','0','2024-08-09 16:15:42',NULL), (7,'CH-40824','1','500','NA','2024-08-01 00:00:00','2029-07-01 00:00:00','','','IP,BP,EP,USP','2024-08-09 12:10:43',NULL,'39','0','1','0','2024-08-09 16:16:25',NULL), (8,'CH-50824','1','500','NA','2024-08-01 00:00:00','2029-07-01 00:00:00','','','IP,BP,EP,USP','2024-08-09 12:11:29',NULL,'39','0','1','0','2024-08-09 16:16:43',NULL), (9,'FR-10824','6','400','NA','2024-08-01 00:00:00','2029-07-01 00:00:00','','','IP,BP','2024-08-17 10:46:21',NULL,'39','0','1','0','2024-08-17 11:13:51',NULL), (10,'CH-20924','1','500','NA','2024-09-01 00:00:00','2029-08-01 00:00:00','','','IP,BP,EP,USP','2024-09-14 15:40:50',NULL,'39','0','1','0','2024-09-14 15:55:52',NULL), (11,'CH-90824','1','500','NA','2024-08-01 00:00:00','2029-07-01 00:00:00','','','IP,BP,EP,USP','2024-09-14 15:52:14',NULL,'39','0','1','0','2024-09-14 15:56:58',NULL), (12,'DS-10824','2','500','NA','2024-08-01 00:00:00','2029-07-01 00:00:00','','','IP,BP,EP,USP','2024-09-18 09:44:13',NULL,'39','0','1','0','2024-09-18 09:44:25',NULL), (13,'CH-10924','1','500','NA','2024-09-01 00:00:00','2029-08-01 00:00:00','','','IP,BP,EP,USP','2024-09-18 12:35:22',NULL,'39','0','1','0','2024-09-18 14:06:25',NULL), (14,'CH-30924','1','500','NA','2024-09-01 00:00:00','2029-08-01 00:00:00','','','IP,BP,EP,USP','2024-09-18 12:36:14',NULL,'39','0','1','0','2024-09-18 14:06:46',NULL), (15,'CH-40924','1','500','NA','2024-09-01 00:00:00','2029-08-01 00:00:00','','','IP,BP,EP,USP','2024-09-18 12:37:14',NULL,'39','0','1','0','2024-09-18 14:07:08',NULL), (16,'CH-50924','1','500','NA','2024-09-01 00:00:00','2029-08-01 00:00:00','','','IP,BP,EP,USP','2024-09-18 12:48:14',NULL,'39','0','1','0','2024-09-18 14:07:20',NULL), (17,'DP-10624','3','500','NA','2024-06-01 00:00:00','2029-05-01 00:00:00','','','TECHNICAL','2024-10-02 13:06:02','2024-10-02 13:06:02','39','0','1','0','2024-10-02 13:06:07',NULL), (18,'CH-70824','1','500','NA','2024-08-01 00:00:00','2029-07-01 00:00:00','','','IP,BP,EP,USP','2024-09-20 16:04:49',NULL,'39','0','1','0','2024-09-20 16:18:06',NULL), (19,'CH-80824','1','500','NA','2024-08-01 00:00:00','2029-07-01 00:00:00','','','IP,BP,EP,USP','2024-09-21 11:20:39',NULL,'39','0','1','0','2024-09-21 14:59:08',NULL), (20,'CH-70924','1','500','NA','2024-09-01 00:00:00','2029-08-01 00:00:00','','','IP,BP,EP,USP','2024-09-26 20:24:39',NULL,'39','0','1','0','2024-09-28 15:08:05',NULL), (21,'DS-20924','2','500','NA','2024-09-01 00:00:00','2029-08-01 00:00:00','','','IP,BP,EP,USP','2024-09-28 11:12:45',NULL,'39','0','1','0','2024-09-28 15:08:38',NULL), (22,'Test 1 batch','8','1000','','2024-10-01 00:00:00','2025-12-01 00:00:00','','','In-House','2024-10-07 15:42:55',NULL,'36','0','1','0','2024-10-07 15:43:01',NULL); /*!40000 ALTER TABLE `pbatch` ENABLE KEYS */; -- -- Definition of preset -- DROP TABLE IF EXISTS `preset`; CREATE TABLE IF NOT EXISTS `preset` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) DEFAULT '', `name` varchar(255) DEFAULT '', `formula` varchar(255) DEFAULT '', `batch` varchar(255) DEFAULT '', `molwt` varchar(255) DEFAULT '', `tarewt` varchar(255) DEFAULT '', `grosswt` varchar(255) DEFAULT '', `netwt` varchar(255) DEFAULT '', `gtin` varchar(255) DEFAULT '', `manufact` varchar(255) DEFAULT '', `storag` varchar(255) DEFAULT '', `grade` varchar(255) DEFAULT '', `uom` varchar(255) DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table preset -- /*!40000 ALTER TABLE `preset` DISABLE KEYS */; /*!40000 ALTER TABLE `preset` ENABLE KEYS */; -- -- Definition of product -- DROP TABLE IF EXISTS `product`; CREATE TABLE IF NOT EXISTS `product` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT '', `brand` varchar(255) DEFAULT '', `gtin` varchar(255) DEFAULT '', `manu` varchar(255) DEFAULT '', `manutxt` varchar(255) DEFAULT '', `scon` varchar(255) DEFAULT '', `grade` varchar(255) DEFAULT '', `subname` varchar(255) DEFAULT '', `pack` varchar(255) DEFAULT '', `uom` varchar(255) DEFAULT '', `created` datetime DEFAULT NULL, `updated` datetime DEFAULT NULL, `userid` varchar(50) DEFAULT NULL, `formula` varchar(255) DEFAULT NULL, `molwt` varchar(255) DEFAULT NULL, `deletestatus` varchar(255) DEFAULT NULL, `prodaprstatus` varchar(255) DEFAULT NULL, `prodrejstatus` varchar(255) DEFAULT NULL, `prodaprtime` datetime DEFAULT NULL, `prodrejtime` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8; -- -- Dumping data for table product -- /*!40000 ALTER TABLE `product` DISABLE KEYS */; INSERT INTO `product`(`id`,`name`,`brand`,`gtin`,`manu`,`manutxt`,`scon`,`grade`,`subname`,`pack`,`uom`,`created`,`updated`,`userid`,`formula`,`molwt`,`deletestatus`,`prodaprstatus`,`prodrejstatus`,`prodaprtime`,`prodrejtime`) VALUES (1,'CHLOROBUTANOL','NA','8906181640009','1','LAXACHEM ORGANICS PVT LTD','Preserve in air tight container','IP,BP,EP,USP','HEMIHYDRATE','5,10,15,20,25','KGS','2024-08-03 12:54:22','2024-08-03 13:27:27','39','C4H7Cl3O,1/2H2O','186.5','0','1','0','2024-08-03 16:33:41',NULL), (2,'DOCUSATE SODIUM','NA','8906181640023','1','LAXACHEM ORGANICS PVT LTD','Preserve in well closed container','IP,BP,EP,USP','Dioctyl Sodium Sulfosuccinate','5,10,15,20,25','KGS','2024-08-03 12:58:20',NULL,'39','C20H37NaO7S','444.6','0','1','0','2024-08-03 16:33:10',NULL), (3,'DOCUSATE SODIUM 85% POWDER','NA','8906181640030','1','LAXACHEM ORGANICS PVT LTD','Preserve in well closed container','TECHNICAL','NA','5,10,15,20,25','KGS','2024-08-03 13:04:30','2024-10-02 13:05:39','39','NA','NA','0','1','0','2024-10-02 13:05:46',NULL), (4,'PROPYL GALLATE','NA','8906181640047','1','LAXACHEM ORGANICS PVT LTD','Store protect from light, in non-metallic container','IP,BP,USP','NA','5,10,15,20,25','KGS','2024-08-03 13:06:54','2024-08-03 16:43:31','39','C10H12O5','212.2','0','1','0','2024-08-04 12:59:43',NULL), (5,'Sodium salt of 4-Chloro-2-[(furan-2-ylmethyl)amino]5-sulfamoylbenzoic acid','NA','NA','1','LAXACHEM ORGANICS PVT LTD','NA','TECHNICAL','NA','5,10,15,20,25','KGS','2024-08-03 13:10:06',NULL,'39','C12H11CIN2O5S','330.7','0','1','0','2024-08-04 13:07:16',NULL), (6,'FUROSEMIDE','NA','8906181640054','1','LAXACHEM ORGANICS PVT LTD','Store protect from moisture and light','IP,BP,EP,USP','NA','5,10,15,20,25','KGS','2024-08-03 13:12:43','2024-08-04 13:08:23','39','C12H11CIN2O5S','330.7','0','1','0','2024-08-04 14:31:49','2024-08-04 13:03:26'), (7,'CHLOROBUTANOL','NA','8906181640016','1','LAXACHEM ORGANICS PVT LTD','In an air tight container','IP,BP,EP,USP','ANHYDROUS','5,10,15,20,25','KGS','2024-08-03 16:29:29',NULL,'39','C4H7Cl3O','177.5','0','1','0','2024-08-03 16:36:24',NULL), (8,'Test 1','','1234567991025','1','LAXACHEM ORGANICS PVT LTD','','In-House','Sub Test 1','25','KGS','2024-10-07 15:42:17',NULL,'36','HY6GY7','12.25','0','1','0','2024-10-07 15:42:22',NULL); /*!40000 ALTER TABLE `product` ENABLE KEYS */; -- -- Definition of returnstock -- DROP TABLE IF EXISTS `returnstock`; CREATE TABLE IF NOT EXISTS `returnstock` ( `id` int(11) NOT NULL AUTO_INCREMENT, `lotno` varchar(255) DEFAULT '', `remark` varchar(255) DEFAULT '', `dor` date DEFAULT NULL, `created` datetime DEFAULT NULL, `updated` datetime DEFAULT NULL, `userid` varchar(50) DEFAULT NULL, `status` varchar(50) DEFAULT '0', `deletestatus` varchar(50) DEFAULT '0', `rtime` varchar(50) DEFAULT NULL, `retaprstatus` varchar(50) DEFAULT NULL, `retrejstatus` varchar(50) DEFAULT NULL, `retaprtime` datetime DEFAULT NULL, `retrejtime` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table returnstock -- /*!40000 ALTER TABLE `returnstock` DISABLE KEYS */; /*!40000 ALTER TABLE `returnstock` ENABLE KEYS */; -- -- Definition of returnstocknew -- DROP TABLE IF EXISTS `returnstocknew`; CREATE TABLE IF NOT EXISTS `returnstocknew` ( `id` int(11) NOT NULL AUTO_INCREMENT, `lotid` varchar(50) DEFAULT NULL, `ssccno` varchar(50) DEFAULT NULL, `tarewt` varchar(50) DEFAULT NULL, `netwt` varchar(50) DEFAULT NULL, `grosswt` varchar(50) DEFAULT NULL, `created` varchar(50) DEFAULT NULL, `userid` varchar(50) DEFAULT NULL, `updated` varchar(50) DEFAULT NULL, `contno` varchar(50) DEFAULT NULL, `rntime` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table returnstocknew -- /*!40000 ALTER TABLE `returnstocknew` DISABLE KEYS */; /*!40000 ALTER TABLE `returnstocknew` ENABLE KEYS */; -- -- Definition of rolemaster -- DROP TABLE IF EXISTS `rolemaster`; CREATE TABLE IF NOT EXISTS `rolemaster` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(50) DEFAULT NULL, `password` varchar(50) DEFAULT NULL, `role` varchar(50) DEFAULT NULL, `created` datetime DEFAULT NULL, `updated` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table rolemaster -- /*!40000 ALTER TABLE `rolemaster` DISABLE KEYS */; /*!40000 ALTER TABLE `rolemaster` ENABLE KEYS */; -- -- Definition of storagecondition -- DROP TABLE IF EXISTS `storagecondition`; CREATE TABLE IF NOT EXISTS `storagecondition` ( `id` int(11) NOT NULL AUTO_INCREMENT, `product` varchar(255) NOT NULL, `productid` int(11) NOT NULL DEFAULT '0', `grade` varchar(50) NOT NULL, `scondition` varchar(255) DEFAULT NULL, `aliasscondition` varchar(255) DEFAULT NULL, `createdat` datetime DEFAULT NULL, `updatedat` datetime DEFAULT NULL, `userid` varchar(50) DEFAULT NULL, `deletestatus` varchar(50) DEFAULT '0', `strgaprstatus` varchar(50) DEFAULT '0', `strgrejstatus` varchar(50) DEFAULT '0', `strgaprtime` datetime DEFAULT NULL, `strgrejtime` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8; -- -- Dumping data for table storagecondition -- /*!40000 ALTER TABLE `storagecondition` DISABLE KEYS */; INSERT INTO `storagecondition`(`id`,`product`,`productid`,`grade`,`scondition`,`aliasscondition`,`createdat`,`updatedat`,`userid`,`deletestatus`,`strgaprstatus`,`strgrejstatus`,`strgaprtime`,`strgrejtime`) VALUES (1,'CHLOROBUTANOL',1,'BP',NULL,'In an air tight container','2024-08-11 15:07:16',NULL,'39','0','1','0','2024-08-11 16:12:16',NULL), (2,'CHLOROBUTANOL',1,'IP',NULL,'Store protect from moisture at temperature not exceeding 30° C','2024-08-16 15:37:38',NULL,'39','0','1','0','2024-08-16 17:10:45',NULL), (3,'FUROSEMIDE',6,'IP',NULL,'Store protect from moisture and light','2024-08-17 11:19:32',NULL,'39','0','1','0','2024-08-17 11:23:26',NULL), (4,'CHLOROBUTANOL',1,'USP',NULL,'Preserve in tight container','2024-08-23 15:07:55',NULL,'39','0','1','0','2024-08-24 15:21:47',NULL), (5,'DOCUSATE SODIUM',2,'BP',NULL,'In an air tight container','2024-09-18 09:46:28',NULL,'39','0','1','0','2024-09-18 09:46:34',NULL), (6,'DOCUSATE SODIUM 85% POWDER',3,'USP',NULL,'Preserve in well closed container','2024-09-28 12:44:50',NULL,'39','0','1','0','2024-09-28 15:10:10',NULL), (7,'DOCUSATE SODIUM',2,'USP',NULL,'Preserve in well closed container','2024-09-28 15:15:11',NULL,'39','0','1','0','2024-09-28 15:15:18',NULL), (8,'DOCUSATE SODIUM 85% POWDER',3,'TECHNICAL',NULL,'Preserve in well closed container','2024-10-02 13:03:32',NULL,'39','0','1','0','2024-10-02 13:03:40',NULL), (9,'Test 1',8,'In-House',NULL,'Teest 1 In-House Grade','2024-10-07 15:43:47',NULL,'36','0','1','0','2024-10-07 15:43:57',NULL); /*!40000 ALTER TABLE `storagecondition` ENABLE KEYS */; -- -- Definition of userm -- DROP TABLE IF EXISTS `userm`; CREATE TABLE IF NOT EXISTS `userm` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(50) DEFAULT '', `password` varchar(50) DEFAULT '', `rights` varchar(500) DEFAULT '', `addproduct` varchar(100) DEFAULT '', `scondition` varchar(100) DEFAULT '', `batch` varchar(100) DEFAULT '', `customerr` varchar(100) DEFAULT '', `dispatch` varchar(100) DEFAULT '', `created` datetime DEFAULT NULL, `updated` datetime DEFAULT NULL, `dispatchreport` varchar(100) DEFAULT '', `generateqr` varchar(100) DEFAULT '', `logreport` varchar(100) DEFAULT '', `manufact` varchar(100) DEFAULT '', `products` varchar(100) DEFAULT '', `returnstocks` varchar(100) DEFAULT '', `rsreport` varchar(100) DEFAULT '', `ssccreport` varchar(100) DEFAULT '', `stocks` varchar(100) DEFAULT '', `generateqradministration` varchar(100) DEFAULT '', `userm` varchar(100) DEFAULT '', `role` varchar(50) DEFAULT NULL, `aliasproductadmin` varchar(50) DEFAULT NULL, `customeradmin` varchar(50) DEFAULT NULL, `dispatchadmin` varchar(50) DEFAULT NULL, `generateqradmin` varchar(50) DEFAULT NULL, `manufactureadmin` varchar(50) DEFAULT NULL, `pbatchadmin` varchar(50) DEFAULT NULL, `productadmin` varchar(50) DEFAULT NULL, `returnstockadmin` varchar(50) DEFAULT NULL, `stockadmin` varchar(50) DEFAULT NULL, `usermadmin` varchar(50) DEFAULT NULL, `sconditionadmin` varchar(50) DEFAULT NULL, `aliasproductadministration` varchar(50) DEFAULT NULL, `customeradministration` varchar(50) DEFAULT NULL, `dispatchadministration` varchar(50) DEFAULT NULL, `manufactureadministration` varchar(50) DEFAULT NULL, `pbatchadministration` varchar(50) DEFAULT NULL, `productadministration` varchar(50) DEFAULT NULL, `returnstockadministration` varchar(50) DEFAULT NULL, `stockadministration` varchar(50) DEFAULT NULL, `usermadministration` varchar(50) DEFAULT NULL, `sconditionadministration` varchar(50) DEFAULT NULL, `aliasproductqa` varchar(50) DEFAULT NULL, `customerqa` varchar(50) DEFAULT NULL, `dispatchqa` varchar(50) DEFAULT NULL, `generateqrqa` varchar(50) DEFAULT NULL, `manufactureqa` varchar(50) DEFAULT NULL, `pbatchqa` varchar(50) DEFAULT NULL, `productqa` varchar(50) DEFAULT NULL, `returnstockqa` varchar(50) DEFAULT NULL, `stockqa` varchar(50) DEFAULT NULL, `usermqa` varchar(50) DEFAULT NULL, `sconditionqa` varchar(50) DEFAULT NULL, `name` varchar(50) DEFAULT NULL, `approval` varchar(50) DEFAULT NULL, `reports` varchar(50) DEFAULT NULL, `subuser` varchar(255) DEFAULT NULL, `stockconversion` varchar(255) DEFAULT NULL, `stockdiscard` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=latin1; -- -- Dumping data for table userm -- /*!40000 ALTER TABLE `userm` DISABLE KEYS */; INSERT INTO `userm`(`id`,`username`,`password`,`rights`,`addproduct`,`scondition`,`batch`,`customerr`,`dispatch`,`created`,`updated`,`dispatchreport`,`generateqr`,`logreport`,`manufact`,`products`,`returnstocks`,`rsreport`,`ssccreport`,`stocks`,`generateqradministration`,`userm`,`role`,`aliasproductadmin`,`customeradmin`,`dispatchadmin`,`generateqradmin`,`manufactureadmin`,`pbatchadmin`,`productadmin`,`returnstockadmin`,`stockadmin`,`usermadmin`,`sconditionadmin`,`aliasproductadministration`,`customeradministration`,`dispatchadministration`,`manufactureadministration`,`pbatchadministration`,`productadministration`,`returnstockadministration`,`stockadministration`,`usermadministration`,`sconditionadministration`,`aliasproductqa`,`customerqa`,`dispatchqa`,`generateqrqa`,`manufactureqa`,`pbatchqa`,`productqa`,`returnstockqa`,`stockqa`,`usermqa`,`sconditionqa`,`name`,`approval`,`reports`,`subuser`,`stockconversion`,`stockdiscard`) VALUES (36,'demoadmin','1234','','create,read,edit,delete','create,read,edit,delete','create,read,edit,delete','create,read,edit,delete','create,read,edit,delete',NULL,NULL,'','create,read,preview,print','','create,read,edit,delete','create,read,edit,delete','create,read,edit,delete','','','create,read,edit,delete','','create,read,edit,delete','Admin','36','36','36','36','36','36','36','36','36','36','36','','','','','','','','','','','','','','','','','','','','','','Demo Admin','Show','Show','','create,read,delete','create,read,delete'), (37,'qa-neha','qalopl#1','','read','','read','read','read',NULL,NULL,'','read,preview','','read','read','read','','','read','','','Quality Assurance','','','','','','','','','','',NULL,'','','','','','','','','',NULL,'','','','','','','','','','',NULL,'QA Neha','Show','Show','',NULL,NULL), (38,'office-mukesh','officelopl#1','','create,read','create,read','create,read','create,read','create,read',NULL,NULL,'','read,preview','','create,read','create,read','create,read','','','create,read','38','','Administration','36','36','36','36','36','36','36','36','36','','36','38','38','38','38','38','38','38','38','','38','37','37','37','37','37','37','37','37','37','','37','OFFICE Mukesh','Show','Show','',NULL,NULL), (39,'user-faisal','userlopl#1','','create,read,edit,delete','create,read,edit,delete','create,read,edit,delete','create,read,edit,delete','create,read,edit,delete',NULL,NULL,'','create,read,preview,print','','create,read,edit,delete','create,read,edit,delete','create,read,edit,delete','','','create,read,edit,delete','','','User','','','','','','','','','','','','','38','38','','','','38','','','','37','','','37','37','37','37','','','','37','USER Faisal','Show','Show','',NULL,NULL), (44,'testuser','1234','','create,read,edit,delete','create,read,edit,delete','create,read,edit,delete','create,read,edit,delete','create,read,edit,delete',NULL,NULL,'','create,read,preview,print','','create,read,edit,delete','create,read,edit,delete','create,read,edit,delete','','','create,read,edit,delete','','create,read,edit,delete','Admin','44','44','44','44','44','44','44','44','44','44','44','','','','','','','','','','','','','','','','','','','','','','testuser','Show','Show','','create,read','create,read'); /*!40000 ALTER TABLE `userm` ENABLE KEYS */; -- -- Definition of userrolemapping -- DROP TABLE IF EXISTS `userrolemapping`; CREATE TABLE IF NOT EXISTS `userrolemapping` ( `id` int(11) NOT NULL AUTO_INCREMENT, `Userid` int(11) NOT NULL DEFAULT '0', `adminroleid` varchar(50) NOT NULL DEFAULT '0', `adnimistratorroleid` varchar(50) NOT NULL DEFAULT '0', `qualityroleid` varchar(50) NOT NULL DEFAULT '0', `companyunit` varchar(50) NOT NULL DEFAULT '0', `companyid` varchar(50) NOT NULL DEFAULT '0', `adminstatus` bit(1) DEFAULT NULL, `administratorstatus` bit(1) DEFAULT NULL, `qualityarrusarnacestatus` bit(1) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- -- Dumping data for table userrolemapping -- /*!40000 ALTER TABLE `userrolemapping` DISABLE KEYS */; INSERT INTO `userrolemapping`(`id`,`Userid`,`adminroleid`,`adnimistratorroleid`,`qualityroleid`,`companyunit`,`companyid`,`adminstatus`,`administratorstatus`,`qualityarrusarnacestatus`) VALUES (1,3,'1','1','2','CRUD','22',0,NULL,NULL); /*!40000 ALTER TABLE `userrolemapping` ENABLE KEYS */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2024-10-15 17:37:32 -- Total time: 0:0:0:0:531 (d:h:m:s:ms)