-- MySqlBackup.NET 2.0.4
-- Dump Time: 2024-10-01 17:58:22
-- --------------------------------------
-- 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=6 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,'A Alias','A',8,'2024-09-17 15:08:41',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'36',NULL,NULL,NULL,'0','1','0','2024-09-17 15:08:48',NULL);
/*!40000 ALTER TABLE `aliasproduct` ENABLE KEYS */;

-- 
-- Definition of customer
-- 

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

-- 
-- Dumping data for table customer
-- 

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

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

-- 
-- Definition of dispatch
-- 

DROP TABLE IF EXISTS `dispatch`;
CREATE TABLE IF NOT EXISTS `dispatch` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lotno` varchar(255) DEFAULT '',
  `distype` varchar(255) DEFAULT '',
  `dod` date DEFAULT NULL,
  `bob` varchar(255) DEFAULT '',
  `dob` date DEFAULT NULL,
  `customer` varchar(255) DEFAULT NULL,
  `invoice` varchar(255) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  `userid` varchar(50) DEFAULT NULL,
  `deletestatus` varchar(50) DEFAULT NULL,
  `disaprstatus` varchar(50) DEFAULT NULL,
  `disrejstatus` varchar(50) DEFAULT NULL,
  `disaprtime` datetime DEFAULT NULL,
  `disrejtime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB 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=13 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),
(2,'6','LAX/0824/002','','4','','','9','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','25','8','','200','0','0','1','0','0','0','2024-08-17 00:00:00','2024-08-17 11:28:08',NULL,'Store protect from moisture and light',NULL),
(3,'1','LAX/0824/003','','2','','','5','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','25','12','','300','0','0','1','0','0','0','2024-08-17 00:00:00','2024-08-17 13:24:01',NULL,'Store protect from moisture at temperature not exceeding 30° C',NULL),
(4,'1','LAX/0824/004','','2','','','5','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','25','2','','50','0','0','1','0','0','0','2024-08-21 00:00:00','2024-08-21 11:49:27',NULL,'Store protect from moisture at temperature not exceeding 30° C',NULL),
(5,'1','LAX/0824/005','','2','','','5','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','25','1','','25','0','0','1','0','0','0','2024-08-21 00:00:00','2024-08-21 11:49:45',NULL,'Store protect from moisture at temperature not exceeding 30° C',NULL),
(6,'1','LAX/0824/006','','1','','','6','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','BP,USP','25','20','','500','0','0','1','0','0','0','2024-08-24 00:00:00','2024-08-24 15:54:41',NULL,'Preserve in tight container',NULL),
(7,'1','LAX/0924/007','','2','','','5','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','25','4','','100','0','0','1','0','0','0','2024-09-14 00:00:00','2024-09-14 15:55:28',NULL,'Store protect from moisture at temperature not exceeding 30° C','2'),
(8,'1','LAX/0924/008','','2','','','5','','','','5','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','5','1','','5','0','0','1','0','0','0','2024-09-14 00:00:00','2024-09-14 15:56:17',NULL,'Store protect from moisture at temperature not exceeding 30° C','2'),
(10,'1','LAX/0924/009','','2','','','11','','','','5','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','5','40','','200','0','0','1','0','0','0','2024-09-14 00:00:00','2024-09-14 17:43:26',NULL,'Store protect from moisture at temperature not exceeding 30° C','2'),
(11,'1','LAX/0924/011','','2','','','10','','','','25','2024-10-01 00:00:00','2029-09-01 00:00:00','39','0','','','','IP','25','20','','500','0','0','1','0','0','0','2024-09-14 00:00:00','2024-09-14 17:48:47',NULL,'Store protect from moisture at temperature not exceeding 30° C','2'),
(12,'8','LAX/0924/012','','5','','','12','','','','5','2024-10-01 00:00:00','2026-07-01 00:00:00','36','0','','','','IP','5','4','','20','0','0','1','0','0','0','2024-09-17 00:00:00','2024-09-17 15:10:00',NULL,'A IP STORAGE','5');
/*!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=152 DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table generateqrsr
-- 

/*!40000 ALTER TABLE `generateqrsr` DISABLE KEYS */;
INSERT INTO `generateqrsr`(`id`,`contno`,`qrid`,`tarewt`,`grosswt`,`uninum`,`sscc`,`fdigit`,`preview`,`ssccrs`,`qrsrtqty`,`batchid`) VALUES
(1,'1/20','1','2.2','27.2','001','089061816400090011','0','0','0','25','4'),
(2,'2/20','1','2.2','27.2','002','089061816400090020','0','0','0','25','4'),
(3,'3/20','1','2.2','27.2','003','089061816400090039','0','0','0','25','4'),
(4,'4/20','1','2.2','27.2','004','089061816400090048','0','0','0','25','4'),
(5,'5/20','1','2.2','27.2','005','089061816400090057','0','0','0','25','4'),
(6,'6/20','1','2.2','27.2','006','089061816400090066','0','0','0','25','4'),
(7,'7/20','1','2.2','27.2','007','089061816400090075','0','0','0','25','4'),
(8,'8/20','1','2.2','27.2','008','089061816400090084','0','0','0','25','4'),
(9,'9/20','1','2.2','27.2','009','089061816400090093','0','0','0','25','4'),
(10,'10/20','1','2.2','27.2','010','089061816400090109','0','0','0','25','4'),
(11,'11/20','1','2.2','27.2','011','089061816400090118','0','0','0','25','4'),
(12,'12/20','1','2.2','27.2','012','089061816400090127','0','0','0','25','4'),
(13,'13/20','1','2.2','27.2','013','089061816400090136','0','0','0','25','4'),
(14,'14/20','1','2.2','27.2','014','089061816400090145','0','0','0','25','4'),
(15,'15/20','1','2.2','27.2','015','089061816400090154','0','0','0','25','4'),
(16,'16/20','1','2.2','27.2','016','089061816400090163','0','0','0','25','4'),
(17,'17/20','1','2.2','27.2','017','089061816400090172','0','0','0','25','4'),
(18,'18/20','1','2.2','27.2','018','089061816400090181','0','0','0','25','4'),
(19,'19/20','1','2.2','27.2','019','089061816400090190','0','0','0','25','4'),
(20,'20/20','1','2.2','27.2','020','089061816400090206','0','0','0','25','4'),
(21,'1/8','2','4.25','29.25','001','089061816400540011','0','0','0','25','9'),
(22,'2/8','2','4.25','29.25','002','089061816400540020','0','0','0','25','9'),
(23,'3/8','2','4.25','29.25','003','089061816400540039','0','0','0','25','9'),
(24,'4/8','2','4.25','29.25','004','089061816400540048','0','0','0','25','9'),
(25,'5/8','2','4.25','29.25','005','089061816400540057','0','0','0','25','9'),
(26,'6/8','2','4.25','29.25','006','089061816400540066','0','0','0','25','9'),
(27,'7/8','2','4.25','29.25','007','089061816400540075','0','0','0','25','9'),
(28,'8/8','2','4.25','29.25','008','089061816400540084','0','0','0','25','9'),
(29,'1/12','3','2.8','27.8','021','089061816400090215','0','0','0','25','5'),
(30,'2/12','3','2.8','27.8','022','089061816400090224','0','0','0','25','5'),
(31,'3/12','3','2.8','27.8','023','089061816400090233','0','0','0','25','5'),
(32,'4/12','3','2.8','27.8','024','089061816400090242','0','0','0','25','5'),
(33,'5/12','3','2.8','27.8','025','089061816400090251','0','0','0','25','5'),
(34,'6/12','3','2.8','27.8','026','089061816400090260','0','0','0','25','5'),
(35,'7/12','3','2.8','27.8','027','089061816400090279','0','0','0','25','5'),
(36,'8/12','3','2.8','27.8','028','089061816400090288','0','0','0','25','5'),
(37,'9/12','3','2.8','27.8','029','089061816400090297','0','0','0','25','5'),
(38,'10/12','3','2.8','27.8','030','089061816400090303','0','0','0','25','5'),
(39,'11/12','3','2.8','27.8','031','089061816400090312','0','0','0','25','5'),
(40,'12/12','3','2.8','27.8','032','089061816400090321','0','0','0','25','5'),
(41,'1/2','4','2.8','27.8','033','089061816400090330','0','0','0','25','5'),
(42,'2/2','4','2.8','27.8','034','089061816400090349','0','0','0','25','5'),
(43,'1/1','5','2.8','27.8','035','089061816400090358','0','0','0','25','5'),
(44,'1/20','6','2.2','27.2','036','089061816400090367','0','0','0','25','6'),
(45,'2/20','6','2.2','27.2','037','089061816400090376','0','0','0','25','6'),
(46,'3/20','6','2.2','27.2','038','089061816400090385','0','0','0','25','6'),
(47,'4/20','6','2.2','27.2','039','089061816400090394','0','0','0','25','6'),
(48,'5/20','6','2.2','27.2','040','089061816400090400','0','0','0','25','6'),
(49,'6/20','6','2.2','27.2','041','089061816400090419','0','0','0','25','6'),
(50,'7/20','6','2.2','27.2','042','089061816400090428','0','0','0','25','6'),
(51,'8/20','6','2.2','27.2','043','089061816400090437','0','0','0','25','6'),
(52,'9/20','6','2.2','27.2','044','089061816400090446','0','0','0','25','6'),
(53,'10/20','6','2.2','27.2','045','089061816400090455','0','0','0','25','6'),
(54,'11/20','6','2.2','27.2','046','089061816400090464','0','0','0','25','6'),
(55,'12/20','6','2.2','27.2','047','089061816400090473','0','0','0','25','6'),
(56,'13/20','6','2.2','27.2','048','089061816400090482','0','0','0','25','6'),
(57,'14/20','6','2.2','27.2','049','089061816400090491','0','0','0','25','6'),
(58,'15/20','6','2.2','27.2','050','089061816400090507','0','0','0','25','6'),
(59,'16/20','6','2.2','27.2','051','089061816400090516','0','0','0','25','6'),
(60,'17/20','6','2.2','27.2','052','089061816400090525','0','0','0','25','6'),
(61,'18/20','6','2.2','27.2','053','089061816400090534','0','0','0','25','6'),
(62,'19/20','6','2.2','27.2','054','089061816400090543','0','0','0','25','6'),
(63,'20/20','6','2.2','27.2','055','089061816400090552','0','0','0','25','6'),
(64,'1/4','7','2.8','27.8','056','089061816400090561','0','0','0','25','5'),
(65,'2/4','7','2.8','27.8','057','089061816400090570','0','0','0','25','5'),
(66,'3/4','7','2.8','27.8','058','089061816400090589','0','0','0','25','5'),
(67,'4/4','7','2.8','27.8','059','089061816400090598','0','0','0','25','5'),
(68,'1/1','8','0.25','5.25','060','089061816400090604','0','0','0','5','5'),
(88,'1/40','10','0.25','5.25','061','089061816400090613','0','0','0','5','11'),
(89,'2/40','10','0.25','5.25','062','089061816400090622','0','0','0','5','11'),
(90,'3/40','10','0.25','5.25','063','089061816400090631','0','0','0','5','11'),
(91,'4/40','10','0.25','5.25','064','089061816400090640','0','0','0','5','11'),
(92,'5/40','10','0.25','5.25','065','089061816400090659','0','0','0','5','11'),
(93,'6/40','10','0.25','5.25','066','089061816400090668','0','0','0','5','11'),
(94,'7/40','10','0.25','5.25','067','089061816400090677','0','0','0','5','11'),
(95,'8/40','10','0.25','5.25','068','089061816400090686','0','0','0','5','11'),
(96,'9/40','10','0.25','5.25','069','089061816400090695','0','0','0','5','11'),
(97,'10/40','10','0.25','5.25','070','089061816400090701','0','0','0','5','11'),
(98,'11/40','10','0.25','5.25','071','089061816400090710','0','0','0','5','11'),
(99,'12/40','10','0.25','5.25','072','089061816400090729','0','0','0','5','11'),
(100,'13/40','10','0.25','5.25','073','089061816400090738','0','0','0','5','11'),
(101,'14/40','10','0.25','5.25','074','089061816400090747','0','0','0','5','11'),
(102,'15/40','10','0.25','5.25','075','089061816400090756','0','0','0','5','11'),
(103,'16/40','10','0.25','5.25','076','089061816400090765','0','0','0','5','11'),
(104,'17/40','10','0.25','5.25','077','089061816400090774','0','0','0','5','11'),
(105,'18/40','10','0.25','5.25','078','089061816400090783','0','0','0','5','11'),
(106,'19/40','10','0.25','5.25','079','089061816400090792','0','0','0','5','11'),
(107,'20/40','10','0.25','5.25','080','089061816400090808','0','0','0','5','11'),
(108,'21/40','10','0.25','5.25','081','089061816400090817','0','0','0','5','11'),
(109,'22/40','10','0.25','5.25','082','089061816400090826','0','0','0','5','11'),
(110,'23/40','10','0.25','5.25','083','089061816400090835','0','0','0','5','11'),
(111,'24/40','10','0.25','5.25','084','089061816400090844','0','0','0','5','11'),
(112,'25/40','10','0.25','5.25','085','089061816400090853','0','0','0','5','11'),
(113,'26/40','10','0.25','5.25','086','089061816400090862','0','0','0','5','11'),
(114,'27/40','10','0.25','5.25','087','089061816400090871','0','0','0','5','11'),
(115,'28/40','10','0.25','5.25','088','089061816400090880','0','0','0','5','11'),
(116,'29/40','10','0.25','5.25','089','089061816400090899','0','0','0','5','11'),
(117,'30/40','10','0.25','5.25','090','089061816400090905','0','0','0','5','11'),
(118,'31/40','10','0.25','5.25','091','089061816400090914','0','0','0','5','11'),
(119,'32/40','10','0.25','5.25','092','089061816400090923','0','0','0','5','11'),
(120,'33/40','10','0.25','5.25','093','089061816400090932','0','0','0','5','11'),
(121,'34/40','10','0.25','5.25','094','089061816400090941','0','0','0','5','11'),
(122,'35/40','10','0.25','5.25','095','089061816400090950','0','0','0','5','11'),
(123,'36/40','10','0.25','5.25','096','089061816400090969','0','0','0','5','11'),
(124,'37/40','10','0.25','5.25','097','089061816400090978','0','0','0','5','11'),
(125,'38/40','10','0.25','5.25','098','089061816400090987','0','0','0','5','11'),
(126,'39/40','10','0.25','5.25','099','089061816400090996','0','0','0','5','11'),
(127,'40/40','10','0.25','5.25','100','089061816400091001','0','0','0','5','11'),
(128,'1/20','11','2.8','27.8','101','089061816400091010','0','0','0','25','10'),
(129,'2/20','11','2.8','27.8','102','089061816400091029','0','0','0','25','10'),
(130,'3/20','11','2.8','27.8','103','089061816400091038','0','0','0','25','10'),
(131,'4/20','11','2.8','27.8','104','089061816400091047','0','0','0','25','10'),
(132,'5/20','11','2.8','27.8','105','089061816400091056','0','0','0','25','10'),
(133,'6/20','11','2.8','27.8','106','089061816400091065','0','0','0','25','10'),
(134,'7/20','11','2.8','27.8','107','089061816400091074','0','0','0','25','10'),
(135,'8/20','11','2.8','27.8','108','089061816400091083','0','0','0','25','10'),
(136,'9/20','11','2.8','27.8','109','089061816400091092','0','0','0','25','10'),
(137,'10/20','11','2.8','27.8','110','089061816400091108','0','0','0','25','10'),
(138,'11/20','11','2.8','27.8','111','089061816400091117','0','0','0','25','10'),
(139,'12/20','11','2.8','27.8','112','089061816400091126','0','0','0','25','10'),
(140,'13/20','11','2.8','27.8','113','089061816400091135','0','0','0','25','10'),
(141,'14/20','11','2.8','27.8','114','089061816400091144','0','0','0','25','10'),
(142,'15/20','11','2.8','27.8','115','089061816400091153','0','0','0','25','10'),
(143,'16/20','11','2.8','27.8','116','089061816400091162','0','0','0','25','10'),
(144,'17/20','11','2.8','27.8','117','089061816400091171','0','0','0','25','10'),
(145,'18/20','11','2.8','27.8','118','089061816400091180','0','0','0','25','10'),
(146,'19/20','11','2.8','27.8','119','089061816400091199','0','0','0','25','10'),
(147,'20/20','11','2.8','27.8','120','089061816400091205','0','0','0','25','10'),
(148,'1/4','12','12.25','17.25','001','0123456780019','0','0','0','5','12'),
(149,'2/4','12','12.25','17.25','002','0123456780026','0','0','0','5','12'),
(150,'3/4','12','12.25','17.25','003','0123456780033','0','0','0','5','12'),
(151,'4/4','12','12.25','17.25','004','0123456780040','0','0','0','5','12');
/*!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=335 DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table logtable
-- 

/*!40000 ALTER TABLE `logtable` DISABLE KEYS */;
INSERT INTO `logtable`(`id`,`username`,`action`,`time`,`userid`,`tablename`) VALUES
(1,NULL,'User Logged In','2024-08-03 11:13:36','39','Login In'),
(2,NULL,'New Company Added','2024-08-03 11:21:56','39','Company Unit'),
(3,NULL,'User Logged In','2024-08-03 12:08:14','39','Login In'),
(4,NULL,'User Logged In','2024-08-03 12:40:03','36','Login In'),
(5,NULL,'Company Updated','2024-08-03 12:43:56','36','Company Unit'),
(6,NULL,'Company Unit Approved','2024-08-03 12:47:53','36','Approval'),
(7,NULL,'User Logged In','2024-08-03 12:50:13','39','Login In'),
(8,NULL,'New Product Added','2024-08-03 12:54:21','39','Product'),
(9,NULL,'New Product Added','2024-08-03 12:58:20','39','Product'),
(10,NULL,'User Logged In','2024-08-03 13:02:08','37','Login In'),
(11,NULL,'New Product Added','2024-08-03 13:04:29','39','Product'),
(12,NULL,'User Logged Out','2024-08-03 13:06:28','37','Log Out'),
(13,NULL,'New Product Added','2024-08-03 13:06:53','39','Product'),
(14,NULL,'New Product Added','2024-08-03 13:10:05','39','Product'),
(15,NULL,'New Product Added','2024-08-03 13:12:42','39','Product'),
(16,NULL,'Product Updated','2024-08-03 13:14:19','39','Product'),
(17,NULL,'User Logged In','2024-08-03 13:26:49','39','Login In'),
(18,NULL,'Product Updated','2024-08-03 13:27:27','39','Product'),
(19,NULL,'Product Updated','2024-08-03 13:28:14','39','Product'),
(20,NULL,'User Logged In','2024-08-03 13:37:47','39','Login In'),
(21,NULL,'User Logged In','2024-08-03 14:03:20','39','Login In'),
(22,NULL,'User Logged In','2024-08-03 15:16:31','39','Login In'),
(23,NULL,'User Logged In','2024-08-03 15:55:12','36','Login In'),
(24,NULL,'User Logged In','2024-08-03 15:58:31','39','Login In'),
(25,NULL,'User Logged In','2024-08-03 16:23:49','39','Login In'),
(26,NULL,'New Product Added','2024-08-03 16:29:29','39','Product'),
(27,NULL,'User Logged In','2024-08-03 16:31:57','37','Login In'),
(28,NULL,'Product Approved','2024-08-03 16:33:10','37','Approval'),
(29,NULL,'Product Approved','2024-08-03 16:33:41','37','Approval'),
(30,NULL,'Product Approved','2024-08-03 16:36:24','37','Approval'),
(31,NULL,'Product Approved','2024-08-03 16:38:19','37','Approval'),
(32,NULL,'Product Updated','2024-08-03 16:43:31','39','Product'),
(33,NULL,'User Logged Out','2024-08-03 16:43:34','37','Log Out'),
(34,NULL,'User Logged In','2024-08-03 18:22:59','36','Login In'),
(35,NULL,'User Logged In','2024-08-04 11:41:05','37','Login In'),
(36,NULL,'User Logged In','2024-08-04 12:39:57','39','Login In'),
(37,NULL,'User Logged In','2024-08-04 12:55:20','37','Login In'),
(38,NULL,'Product Approved','2024-08-04 12:59:43','37','Approval'),
(39,NULL,'Product Rejected','2024-08-04 13:03:26','37','Approval'),
(40,NULL,'Product Approved','2024-08-04 13:07:16','37','Approval'),
(41,NULL,'Product Updated','2024-08-04 13:08:22','39','Product'),
(42,NULL,'User Logged In','2024-08-04 14:31:37','37','Login In'),
(43,NULL,'Product Approved','2024-08-04 14:31:49','37','Approval'),
(44,NULL,'User Logged In','2024-08-06 12:05:10','39','Login In'),
(45,NULL,'Batch Added','2024-08-06 12:07:13','39','Batch'),
(46,NULL,'Batch Updated','2024-08-06 12:09:55','39','Batch'),
(47,NULL,'User Logged In','2024-08-07 11:54:04','39','Login In'),
(48,NULL,'Batch Added','2024-08-07 11:56:35','39','Batch'),
(49,NULL,'Batch Added','2024-08-07 11:58:02','39','Batch'),
(50,NULL,'Batch Updated','2024-08-07 12:00:21','39','Batch'),
(51,NULL,'Batch Updated','2024-08-07 12:00:29','39','Batch'),
(52,NULL,'User Logged In','2024-08-09 12:06:33','39','Login In'),
(53,NULL,'Batch Data Deleted','2024-08-09 12:06:48','39','Batch'),
(54,NULL,'Batch Data Deleted','2024-08-09 12:06:52','39','Batch'),
(55,NULL,'Batch Data Deleted','2024-08-09 12:06:55','39','Batch'),
(56,NULL,'Batch Added','2024-08-09 12:08:25','39','Batch'),
(57,NULL,'Batch Added','2024-08-09 12:09:18','39','Batch'),
(58,NULL,'Batch Added','2024-08-09 12:09:59','39','Batch'),
(59,NULL,'Batch Added','2024-08-09 12:10:43','39','Batch'),
(60,NULL,'Batch Added','2024-08-09 12:11:29','39','Batch'),
(61,NULL,'User Logged In','2024-08-09 16:11:09','37','Login In'),
(62,NULL,'Batch Delete Approved','2024-08-09 16:12:02','37','Approval'),
(63,NULL,'Batch Delete Approved','2024-08-09 16:12:31','37','Approval'),
(64,NULL,'Batch Delete Approved','2024-08-09 16:12:53','37','Approval'),
(65,NULL,'Batch Approved','2024-08-09 16:14:10','37','Approval'),
(66,NULL,'Batch Approved','2024-08-09 16:14:53','37','Approval'),
(67,NULL,'Batch Approved','2024-08-09 16:15:42','37','Approval'),
(68,NULL,'Batch Approved','2024-08-09 16:16:25','37','Approval'),
(69,NULL,'Batch Approved','2024-08-09 16:16:43','37','Approval'),
(70,NULL,'User Logged Out','2024-08-09 16:17:27','37','Log Out'),
(71,NULL,'User Logged In','2024-08-10 12:44:41','39','Login In'),
(72,NULL,'Alias Product Added','2024-08-10 12:45:56','39','Alias Product'),
(73,NULL,'Alias Product Added','2024-08-10 12:47:08','39','Alias Product'),
(74,NULL,'User Logged In','2024-08-10 13:44:57','39','Login In'),
(75,NULL,'User Logged In','2024-08-10 16:42:52','37','Login In'),
(76,NULL,'Alias Product Approved','2024-08-10 16:45:02','37','Approval'),
(77,NULL,'Alias Product Approved','2024-08-10 16:45:04','37','Approval'),
(78,NULL,'User Logged Out','2024-08-10 16:45:12','37','Log Out'),
(79,NULL,'User Logged In','2024-08-11 15:05:32','39','Login In'),
(80,NULL,'Storage Condition Added','2024-08-11 15:07:16','39','Storage Condition'),
(81,NULL,'User Logged In','2024-08-11 15:58:31','39','Login In'),
(82,NULL,'User Logged In','2024-08-11 16:11:03','37','Login In'),
(83,NULL,'Storage Condition Approved','2024-08-11 16:12:16','37','Storage Condition'),
(84,NULL,'User Logged Out','2024-08-11 16:12:23','37','Log Out'),
(85,NULL,'QR generated','2024-08-11 16:13:17','39','Generateqr'),
(86,NULL,'User Logged In','2024-08-11 16:15:33','37','Login In'),
(87,NULL,'Generateqr Approved','2024-08-11 16:16:38','37','Approval'),
(88,NULL,'User Logged Out','2024-08-11 16:16:53','37','Log Out'),
(89,NULL,'Single Print Had Taken','2024-08-11 16:17:02','39','generateqrsr'),
(90,NULL,'Single Print Had Taken','2024-08-11 16:17:30','39','generateqrsr'),
(91,NULL,'Single Print Had Taken','2024-08-11 16:18:25','39','generateqrsr'),
(92,NULL,'Single Print Had Taken','2024-08-11 16:18:42','39','generateqrsr'),
(93,NULL,'Single Print Had Taken','2024-08-11 16:34:49','39','generateqrsr'),
(94,NULL,'Storage Condition Edited','2024-08-11 16:39:25','39','Storage Condition'),
(95,NULL,'User Logged Out','2024-08-11 16:59:14','39','Log Out'),
(96,NULL,'User Logged In','2024-08-11 16:59:16','39','Login In'),
(97,NULL,'Single Print Had Taken','2024-08-11 16:59:36','39','generateqrsr'),
(98,NULL,'User Logged In','2024-08-11 17:08:32','36','Login In'),
(99,NULL,'Single Print Had Taken','2024-08-11 17:09:38','36','generateqrsr'),
(100,NULL,'Multiple Print Had Taken','2024-08-11 17:10:28','36','generateqrsr'),
(101,NULL,'User Logged In','2024-08-12 16:31:35','36','Login In'),
(102,NULL,'Single Print Had Taken','2024-08-12 16:32:15','36','generateqrsr'),
(103,NULL,'Multiple Print Had Taken','2024-08-12 16:32:28','36','generateqrsr'),
(104,NULL,'Single Print Had Taken','2024-08-12 16:51:50','36','generateqrsr'),
(105,NULL,'Single Print Had Taken','2024-08-12 16:55:45','36','generateqrsr'),
(106,NULL,'Multiple Print Had Taken','2024-08-12 16:55:59','36','generateqrsr'),
(107,NULL,'User Logged In','2024-08-14 11:51:23','39','Login In'),
(108,NULL,'Single Print Had Taken','2024-08-14 11:51:41','39','generateqrsr'),
(109,NULL,'Single Print Had Taken','2024-08-14 11:51:43','39','generateqrsr'),
(110,NULL,'User Logged In','2024-08-14 13:30:45','39','Login In'),
(111,NULL,'User Logged In','2024-08-14 19:40:44','39','Login In'),
(112,NULL,'Alias Product Added','2024-08-14 19:41:56','39','Alias Product'),
(113,NULL,'User Logged In','2024-08-14 19:42:35','37','Login In'),
(114,NULL,'Alias Product Approved','2024-08-14 19:42:48','37','Approval'),
(115,NULL,'Single Print Had Taken','2024-08-14 19:46:11','39','generateqrsr'),
(116,NULL,'Single Print Had Taken','2024-08-14 19:46:31','39','generateqrsr'),
(117,NULL,'Single Print Had Taken','2024-08-14 19:47:06','39','generateqrsr'),
(118,NULL,'Single Print Had Taken','2024-08-14 19:47:21','39','generateqrsr'),
(119,NULL,'Single Print Had Taken','2024-08-14 19:47:43','39','generateqrsr'),
(120,NULL,'Single Print Had Taken','2024-08-14 20:02:36','39','generateqrsr'),
(121,NULL,'Single Print Had Taken','2024-08-14 20:02:55','39','generateqrsr'),
(122,NULL,'Single Print Had Taken','2024-08-14 20:05:33','39','generateqrsr'),
(123,NULL,'Single Print Had Taken','2024-08-14 20:05:57','39','generateqrsr'),
(124,NULL,'Single Print Had Taken','2024-08-14 20:07:11','39','generateqrsr'),
(125,NULL,'Single Print Had Taken','2024-08-14 20:07:26','39','generateqrsr'),
(126,NULL,'Single Print Had Taken','2024-08-14 20:08:38','39','generateqrsr'),
(127,NULL,'Single Print Had Taken','2024-08-14 20:12:57','39','generateqrsr'),
(128,NULL,'Single Print Had Taken','2024-08-14 20:13:14','39','generateqrsr'),
(129,NULL,'Multiple Print Had Taken','2024-08-14 20:17:36','39','generateqrsr'),
(130,NULL,'User Logged In','2024-08-16 14:54:59','39','Login In'),
(131,NULL,'Company Updated','2024-08-16 14:56:29','39','Company Unit'),
(132,NULL,'Single Print Had Taken','2024-08-16 14:57:47','39','generateqrsr'),
(133,NULL,'Single Print Had Taken','2024-08-16 14:58:29','39','generateqrsr'),
(134,NULL,'Single Print Had Taken','2024-08-16 15:02:11','39','generateqrsr'),
(135,NULL,'Single Print Had Taken','2024-08-16 15:02:24','39','generateqrsr'),
(136,NULL,'User Logged In','2024-08-16 15:29:11','36','Login In'),
(137,NULL,'Single Print Had Taken','2024-08-16 15:30:00','36','generateqrsr'),
(138,NULL,'Multiple Print Had Taken','2024-08-16 15:31:44','36','generateqrsr'),
(139,NULL,'User Logged In','2024-08-16 15:36:22','39','Login In'),
(140,NULL,'Storage Condition Added','2024-08-16 15:37:38','39','Storage Condition'),
(141,NULL,'Single Print Had Taken','2024-08-16 16:01:39','39','generateqrsr'),
(142,NULL,'Multiple Print Had Taken','2024-08-16 16:09:05','39','generateqrsr'),
(143,NULL,'Multiple Print Had Taken','2024-08-16 16:09:05','39','generateqrsr'),
(144,NULL,'Single Print Had Taken','2024-08-16 16:09:24','39','generateqrsr'),
(145,NULL,'Single Print Had Taken','2024-08-16 16:09:42','39','generateqrsr'),
(146,NULL,'Single Print Had Taken','2024-08-16 16:11:20','39','generateqrsr'),
(147,NULL,'Multiple Print Had Taken','2024-08-16 16:11:55','39','generateqrsr'),
(148,NULL,'Single Print Had Taken','2024-08-16 16:12:35','39','generateqrsr'),
(149,NULL,'Multiple Print Had Taken','2024-08-16 16:12:55','39','generateqrsr'),
(150,NULL,'Multiple Print Had Taken','2024-08-16 16:13:52','39','generateqrsr'),
(151,NULL,'Multiple Print Had Taken','2024-08-16 16:15:00','39','generateqrsr'),
(152,NULL,'Single Print Had Taken','2024-08-16 16:16:42','39','generateqrsr'),
(153,NULL,'Single Print Had Taken','2024-08-16 16:18:40','39','generateqrsr'),
(154,NULL,'Single Print Had Taken','2024-08-16 16:22:53','39','generateqrsr'),
(155,NULL,'Single Print Had Taken','2024-08-16 16:24:05','39','generateqrsr'),
(156,NULL,'User Logged In','2024-08-16 16:38:23','39','Login In'),
(157,NULL,'Single Print Had Taken','2024-08-16 16:38:59','39','generateqrsr'),
(158,NULL,'Single Print Had Taken','2024-08-16 16:39:46','39','generateqrsr'),
(159,NULL,'Single Print Had Taken','2024-08-16 16:40:28','39','generateqrsr'),
(160,NULL,'Single Print Had Taken','2024-08-16 16:40:56','39','generateqrsr'),
(161,NULL,'Multiple Print Had Taken','2024-08-16 16:42:00','39','generateqrsr'),
(162,NULL,'User Logged In','2024-08-16 17:04:12','39','Login In'),
(163,NULL,'User Logged In','2024-08-16 17:08:38','37','Login In'),
(164,NULL,'Company Unit Approved','2024-08-16 17:09:25','37','Approval'),
(165,NULL,'Storage Condition Approved','2024-08-16 17:10:45','37','Storage Condition'),
(166,NULL,'User Logged Out','2024-08-16 17:10:52','37','Log Out'),
(167,NULL,'User Logged In','2024-08-16 17:49:39','39','Login In'),
(168,NULL,'Single Print Had Taken','2024-08-16 17:49:58','39','generateqrsr'),
(169,NULL,'Single Print Had Taken','2024-08-16 17:51:03','39','generateqrsr'),
(170,NULL,'Multiple Print Had Taken','2024-08-16 17:52:07','39','generateqrsr'),
(171,NULL,'Single Print Had Taken','2024-08-16 17:52:50','39','generateqrsr'),
(172,NULL,'User Logged In','2024-08-16 17:54:23','39','Login In'),
(173,NULL,'Single Print Had Taken','2024-08-16 17:54:36','39','generateqrsr'),
(174,NULL,'Single Print Had Taken','2024-08-16 17:54:51','39','generateqrsr'),
(175,NULL,'Single Print Had Taken','2024-08-16 17:55:19','39','generateqrsr'),
(176,NULL,'Single Print Had Taken','2024-08-16 17:55:35','39','generateqrsr'),
(177,NULL,'Single Print Had Taken','2024-08-16 17:55:52','39','generateqrsr'),
(178,NULL,'Single Print Had Taken','2024-08-16 17:56:12','39','generateqrsr'),
(179,NULL,'Single Print Had Taken','2024-08-16 17:56:36','39','generateqrsr'),
(180,NULL,'Single Print Had Taken','2024-08-16 17:57:10','39','generateqrsr'),
(181,NULL,'Single Print Had Taken','2024-08-16 17:57:21','39','generateqrsr'),
(182,NULL,'Single Print Had Taken','2024-08-16 17:57:32','39','generateqrsr'),
(183,NULL,'Single Print Had Taken','2024-08-16 17:57:43','39','generateqrsr'),
(184,NULL,'Single Print Had Taken','2024-08-16 17:57:56','39','generateqrsr'),
(185,NULL,'Single Print Had Taken','2024-08-16 17:58:09','39','generateqrsr'),
(186,NULL,'Single Print Had Taken','2024-08-16 17:58:25','39','generateqrsr'),
(187,NULL,'Single Print Had Taken','2024-08-16 17:58:44','39','generateqrsr'),
(188,NULL,'Single Print Had Taken','2024-08-16 17:59:05','39','generateqrsr'),
(189,NULL,'Single Print Had Taken','2024-08-16 17:59:32','39','generateqrsr'),
(190,NULL,'Single Print Had Taken','2024-08-16 17:59:46','39','generateqrsr'),
(191,NULL,'Single Print Had Taken','2024-08-16 18:00:05','39','generateqrsr'),
(192,NULL,'Single Print Had Taken','2024-08-16 18:00:37','39','generateqrsr'),
(193,NULL,'Single Print Had Taken','2024-08-16 18:00:56','39','generateqrsr'),
(194,NULL,'Single Print Had Taken','2024-08-16 18:01:44','39','generateqrsr'),
(195,NULL,'User Logged In','2024-08-16 18:24:52','39','Login In'),
(196,NULL,'User Logged In','2024-08-17 10:40:35','39','Login In'),
(197,NULL,'Batch Added','2024-08-17 10:46:21','39','Batch'),
(198,NULL,'User Logged In','2024-08-17 11:12:01','39','Login In'),
(199,NULL,'User Logged In','2024-08-17 11:12:39','37','Login In'),
(200,NULL,'Batch Approved','2024-08-17 11:13:51','37','Approval'),
(201,NULL,'Alias Product Delete Approved','2024-08-17 11:16:53','37','Approval'),
(202,NULL,'Alias Product Added','2024-08-17 11:18:39','39','Alias Product'),
(203,NULL,'Alias Product Approved','2024-08-17 11:18:53','37','Approval'),
(204,NULL,'Storage Condition Added','2024-08-17 11:19:33','39','Storage Condition'),
(205,NULL,'Storage Condition Approved','2024-08-17 11:23:26','37','Storage Condition'),
(206,NULL,'QR generated','2024-08-17 11:25:29','39','Generateqr'),
(207,NULL,'User Logged In','2024-08-17 11:26:10','37','Login In'),
(208,NULL,'Generateqr Approved','2024-08-17 11:28:08','37','Approval'),
(209,NULL,'Single Print Had Taken','2024-08-17 11:28:31','39','generateqrsr'),
(210,NULL,'Single Print Had Taken','2024-08-17 11:47:00','39','generateqrsr'),
(211,NULL,'Single Print Had Taken','2024-08-17 11:47:20','39','generateqrsr'),
(212,NULL,'User Logged In','2024-08-17 12:07:49','39','Login In'),
(213,NULL,'QR generated','2024-08-17 12:10:06','39','Generateqr'),
(214,NULL,'User Logged In','2024-08-17 13:23:35','37','Login In'),
(215,NULL,'Generateqr Approved','2024-08-17 13:24:01','37','Approval'),
(216,NULL,'User Logged In','2024-08-17 13:55:53','39','Login In'),
(217,NULL,'Single Print Had Taken','2024-08-17 13:59:18','39','generateqrsr'),
(218,NULL,'Multiple Print Had Taken','2024-08-17 14:01:05','39','generateqrsr'),
(219,NULL,'User Logged In','2024-08-17 14:24:38','39','Login In'),
(220,NULL,'Single Print Had Taken','2024-08-17 14:24:50','39','generateqrsr'),
(221,NULL,'Single Print Had Taken','2024-08-17 14:25:27','39','generateqrsr'),
(222,NULL,'Single Print Had Taken','2024-08-17 14:25:44','39','generateqrsr'),
(223,NULL,'Single Print Had Taken','2024-08-17 14:26:03','39','generateqrsr'),
(224,NULL,'Single Print Had Taken','2024-08-17 14:26:14','39','generateqrsr'),
(225,NULL,'Single Print Had Taken','2024-08-17 14:26:25','39','generateqrsr'),
(226,NULL,'Single Print Had Taken','2024-08-17 14:26:56','39','generateqrsr'),
(227,NULL,'Single Print Had Taken','2024-08-17 14:27:26','39','generateqrsr'),
(228,NULL,'Single Print Had Taken','2024-08-17 14:27:39','39','generateqrsr'),
(229,NULL,'Single Print Had Taken','2024-08-17 14:27:49','39','generateqrsr'),
(230,NULL,'Single Print Had Taken','2024-08-17 14:28:04','39','generateqrsr'),
(231,NULL,'Single Print Had Taken','2024-08-17 14:28:25','39','generateqrsr'),
(232,NULL,'Single Print Had Taken','2024-08-17 14:28:46','39','generateqrsr'),
(233,NULL,'Single Print Had Taken','2024-08-17 14:28:58','39','generateqrsr'),
(234,NULL,'User Logged In','2024-08-21 11:32:09','39','Login In'),
(235,NULL,'QR generated','2024-08-21 11:33:58','39','Generateqr'),
(236,NULL,'QR generated','2024-08-21 11:34:37','39','Generateqr'),
(237,NULL,'User Logged In','2024-08-21 11:49:01','37','Login In'),
(238,NULL,'Generateqr Approved','2024-08-21 11:49:27','37','Approval'),
(239,NULL,'Generateqr Approved','2024-08-21 11:49:46','37','Approval'),
(240,NULL,'User Logged Out','2024-08-21 11:49:49','37','Log Out'),
(241,NULL,'Single Print Had Taken','2024-08-21 11:52:04','39','generateqrsr'),
(242,NULL,'Multiple Print Had Taken','2024-08-21 11:53:07','39','generateqrsr'),
(243,NULL,'Single Print Had Taken','2024-08-21 11:54:54','39','generateqrsr'),
(244,NULL,'Single Print Had Taken','2024-08-21 11:55:31','39','generateqrsr'),
(245,NULL,'Single Print Had Taken','2024-08-21 11:55:41','39','generateqrsr'),
(246,NULL,'User Logged In','2024-08-21 18:32:38','36','Login In'),
(247,NULL,'User Logged In','2024-08-21 18:39:20','36','Login In'),
(248,NULL,'User Logged In','2024-08-21 19:11:29','36','Login In'),
(249,NULL,'User Logged Out','2024-08-21 19:11:34','36','Log Out'),
(250,NULL,'User Logged In','2024-08-22 18:52:08','39','Login In'),
(251,NULL,'User Logged In','2024-08-23 15:04:52','39','Login In'),
(252,NULL,'Storage Condition Added','2024-08-23 15:07:55','39','Storage Condition'),
(253,NULL,'User Logged In','2024-08-24 15:03:41','39','Login In'),
(254,NULL,'User Logged In','2024-08-24 15:05:21','37','Login In'),
(255,NULL,'Storage Condition Approved','2024-08-24 15:08:14','37','Storage Condition'),
(256,NULL,'User Logged In','2024-08-24 15:21:41','37','Login In'),
(257,NULL,'Storage Condition Approved','2024-08-24 15:21:47','37','Storage Condition'),
(258,NULL,'QR generated','2024-08-24 15:28:16','39','Generateqr'),
(259,NULL,'User Logged In','2024-08-24 15:29:21','37','Login In'),
(260,NULL,'Generateqr Approved','2024-08-24 15:29:48','37','Approval'),
(261,NULL,'User Logged Out','2024-08-24 15:37:56','39','Log Out'),
(262,NULL,'User Logged In','2024-08-24 15:37:57','39','Login In'),
(263,NULL,'Single Print Had Taken','2024-08-24 15:43:14','39','generateqrsr'),
(264,NULL,'User Logged In','2024-08-24 15:53:24','37','Login In'),
(265,NULL,'Generateqr Approved','2024-08-24 15:53:43','37','Approval'),
(266,NULL,'User Logged Out','2024-08-24 15:53:50','37','Log Out'),
(267,NULL,'User Logged In','2024-08-24 15:54:24','37','Login In'),
(268,NULL,'Generateqr Approved','2024-08-24 15:54:41','37','Approval'),
(269,NULL,'User Logged Out','2024-08-24 15:54:45','39','Log Out'),
(270,NULL,'User Logged In','2024-08-24 15:54:47','39','Login In'),
(271,NULL,'User Logged Out','2024-08-24 15:54:58','37','Log Out'),
(272,NULL,'User Logged In','2024-08-24 15:55:18','37','Login In'),
(273,NULL,'Single Print Had Taken','2024-08-24 15:55:18','39','generateqrsr'),
(274,NULL,'User Logged Out','2024-08-24 15:55:28','37','Log Out'),
(275,NULL,'Single Print Had Taken','2024-08-24 15:55:37','39','generateqrsr'),
(276,NULL,'Single Print Had Taken','2024-08-24 15:55:58','39','generateqrsr'),
(277,NULL,'User Logged In','2024-08-24 16:52:50','37','Login In'),
(278,NULL,'User Logged Out','2024-08-24 16:53:34','37','Log Out'),
(279,NULL,'User Logged In','2024-08-24 16:53:36','36','Login In'),
(280,NULL,'User Logged In','2024-09-14 13:15:36','39','Login In'),
(281,NULL,'QR generated','2024-09-14 13:26:24','39','Generateqr'),
(282,NULL,'User Logged In','2024-09-14 15:35:20','39','Login In'),
(283,NULL,'Batch Added','2024-09-14 15:40:50','39','Batch'),
(284,NULL,'QR generated','2024-09-14 15:42:06','39','Generateqr'),
(285,NULL,'Batch Added','2024-09-14 15:52:14','39','Batch'),
(286,NULL,'User Logged In','2024-09-14 15:53:37','37','Login In'),
(287,NULL,'Generateqr Approved','2024-09-14 15:55:28','37','Approval'),
(288,NULL,'Batch Approved','2024-09-14 15:55:52','37','Approval'),
(289,NULL,'Generateqr Approved','2024-09-14 15:56:17','37','Approval'),
(290,NULL,'Batch Approved','2024-09-14 15:56:58','37','Approval'),
(291,NULL,'User Logged Out','2024-09-14 15:58:44','37','Log Out'),
(292,NULL,'QR generated','2024-09-14 15:59:00','39','Generateqr'),
(293,NULL,'User Logged In','2024-09-14 15:59:07','37','Login In'),
(294,NULL,'Generateqr Approved','2024-09-14 15:59:55','37','Approval'),
(295,NULL,'User Logged Out','2024-09-14 16:00:14','37','Log Out'),
(296,NULL,'User Logged In','2024-09-14 16:48:28','39','Login In'),
(297,NULL,'QR Deleted','2024-09-14 17:36:38','39','Generateqr'),
(298,NULL,'Multiple Print Had Taken','2024-09-14 17:37:05','39','generateqrsr'),
(299,NULL,'User Logged In','2024-09-14 17:38:11','39','Login In'),
(300,NULL,'Multiple Print Had Taken','2024-09-14 17:38:42','39','generateqrsr'),
(301,NULL,'QR generated','2024-09-14 17:42:43','39','Generateqr'),
(302,NULL,'User Logged In','2024-09-14 17:43:09','37','Login In'),
(303,NULL,'Generateqr Approved','2024-09-14 17:43:26','37','Approval'),
(304,NULL,'Multiple Print Had Taken','2024-09-14 17:44:18','39','generateqrsr'),
(305,NULL,'QR generated','2024-09-14 17:48:34','39','Generateqr'),
(306,NULL,'Generateqr Approved','2024-09-14 17:48:47','37','Approval'),
(307,NULL,'Multiple Print Had Taken','2024-09-14 17:49:01','39','generateqrsr'),
(308,NULL,'User Logged In','2024-09-14 18:09:46','39','Login In'),
(309,NULL,'Multiple Print Had Taken','2024-09-14 18:09:57','39','generateqrsr'),
(310,NULL,'User Logged In','2024-09-17 12:56:35','39','Login In'),
(311,NULL,'User Logged In','2024-09-17 14:50:18','36','Login In'),
(312,NULL,'Single Print Had Taken','2024-09-17 15:02:48','36','generateqrsr'),
(313,NULL,'Multiple Print Had Taken','2024-09-17 15:03:10','36','generateqrsr'),
(314,NULL,'New Product Added','2024-09-17 15:07:20','36','Product'),
(315,NULL,'Product Approved','2024-09-17 15:07:44','36','Approval'),
(316,NULL,'Batch Added','2024-09-17 15:08:16','36','Batch'),
(317,NULL,'Batch Approved','2024-09-17 15:08:25','36','Approval'),
(318,NULL,'Alias Product Added','2024-09-17 15:08:41','36','Alias Product'),
(319,NULL,'Alias Product Approved','2024-09-17 15:08:48','36','Approval'),
(320,NULL,'Storage Condition Added','2024-09-17 15:09:13','36','Storage Condition'),
(321,NULL,'Storage Condition Approved','2024-09-17 15:09:21','36','Storage Condition'),
(322,NULL,'QR generated','2024-09-17 15:09:48','36','Generateqr'),
(323,NULL,'Generateqr Approved','2024-09-17 15:10:00','36','Approval'),
(324,NULL,'Single Print Had Taken','2024-09-17 15:10:44','36','generateqrsr'),
(325,NULL,'User Logged In','2024-09-17 15:32:45','36','Login In'),
(326,NULL,'User Logged In','2024-09-18 19:16:18','36','Login In'),
(327,NULL,'User Logged In','2024-09-20 18:40:27','36','Login In'),
(328,NULL,'User Logged In','2024-09-27 13:39:59','39','Login In'),
(329,NULL,'Batch Added','2024-09-27 13:42:25','39','Batch'),
(330,NULL,'User Logged In','2024-09-27 16:33:06','37','Login In'),
(331,NULL,'Batch Approved','2024-09-27 16:34:59','37','Approval'),
(332,NULL,'User Logged Out','2024-09-27 16:35:44','37','Log Out'),
(333,NULL,'User Logged In','2024-10-01 11:56:51','36','Login In'),
(334,NULL,'User Logged In','2024-10-01 17:58:09','39','Login In');
/*!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=59 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'),
(11,'37','3','product','1','0','2024-08-03 13:28:14','2024-08-03 16:38:19',NULL,NULL,'DOCUSATE SODIUM 85%','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,'36','8','product','1','0','2024-09-17 15:07:20','2024-09-17 15:07:44',NULL,NULL,'A','New Item','0','36'),
(54,'36','12','pbatch','1','0','2024-09-17 15:08:16','2024-09-17 15:08:25',NULL,NULL,'A Batch','New Item','0','36'),
(55,'36','5','addproduct','1','0','2024-09-17 15:08:41','2024-09-17 15:08:48',NULL,NULL,'A Alias','New Item','0','36'),
(56,'36','5','storagecondition','1','0','2024-09-17 15:09:13','2024-09-17 15:09:21',NULL,NULL,'A IP STORAGE','New Item','0','36'),
(57,'36','12','generateqr','1','0','2024-09-17 15:09:48','2024-09-17 15:10:00',NULL,NULL,'LAX/0924/012','New Item',NULL,'36'),
(58,'37','13','pbatch','1','0','2024-09-27 13:42:26','2024-09-27 16:34:59',NULL,NULL,'DS-20924','New Item','0','39');
/*!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=14 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,'A Batch','8','20','ABATCHI','2024-09-01 00:00:00','2026-06-01 00:00:00','','','IP','2024-09-17 15:08:16',NULL,'36','0','1','0','2024-09-17 15:08:25',NULL),
(13,'DS-20924','2','500','NA','2024-09-01 00:00:00','2029-08-01 00:00:00','','','IP,BP,EP,USP','2024-09-27 13:42:25',NULL,'39','0','1','0','2024-09-27 16:34:59',NULL);
/*!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%','NA','8906181640030','1','LAXACHEM ORGANICS PVT LTD','Preserve in well closed container','USP','NA','5,10,15,20,25','KGS','2024-08-03 13:04:30','2024-08-03 13:28:14','39','NA','NA','0','1','0','2024-08-03 16:38:19',NULL),
(4,'PROPYL GALLATE','NA','8906181640047','1','LAXACHEM ORGANICS PVT LTD','Store protect from light, in non-metallic container','IP,BP,USP','NA','5,10,15,20,25','KGS','2024-08-03 13:06:54','2024-08-03 16:43:31','39','C10H12O5','212.2','0','1','0','2024-08-04 12:59:43',NULL),
(5,'Sodium salt of 4-Chloro-2-[(furan-2-ylmethyl)amino]5-sulfamoylbenzoic acid','NA','NA','1','LAXACHEM ORGANICS PVT LTD','NA','TECHNICAL','NA','5,10,15,20,25','KGS','2024-08-03 13:10:06',NULL,'39','C12H11CIN2O5S','330.7','0','1','0','2024-08-04 13:07:16',NULL),
(6,'FUROSEMIDE','NA','8906181640054','1','LAXACHEM ORGANICS PVT LTD','Store protect from moisture and light','IP,BP,EP,USP','NA','5,10,15,20,25','KGS','2024-08-03 13:12:43','2024-08-04 13:08:23','39','C12H11CIN2O5S','330.7','0','1','0','2024-08-04 14:31:49','2024-08-04 13:03:26'),
(7,'CHLOROBUTANOL','NA','8906181640016','1','LAXACHEM ORGANICS PVT LTD','In an air tight container','IP,BP,EP,USP','ANHYDROUS','5,10,15,20,25','KGS','2024-08-03 16:29:29',NULL,'39','C4H7Cl3O','177.5','0','1','0','2024-08-03 16:36:24',NULL),
(8,'A','NA','12345678','1','LAXACHEM ORGANICS PVT LTD','NA','IP','Sub A','5','KGS','2024-09-17 15:07:20',NULL,'36','H2G4T5','224','0','1','0','2024-09-17 15:07:44',NULL);
/*!40000 ALTER TABLE `product` ENABLE KEYS */;

-- 
-- Definition of returnstock
-- 

DROP TABLE IF EXISTS `returnstock`;
CREATE TABLE IF NOT EXISTS `returnstock` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lotno` varchar(255) DEFAULT '',
  `remark` varchar(255) DEFAULT '',
  `dor` date DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  `userid` varchar(50) DEFAULT NULL,
  `status` varchar(50) DEFAULT '0',
  `deletestatus` varchar(50) DEFAULT '0',
  `rtime` varchar(50) DEFAULT NULL,
  `retaprstatus` varchar(50) DEFAULT NULL,
  `retrejstatus` varchar(50) DEFAULT NULL,
  `retaprtime` datetime DEFAULT NULL,
  `retrejtime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table returnstock
-- 

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

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

-- 
-- Definition of returnstocknew
-- 

DROP TABLE IF EXISTS `returnstocknew`;
CREATE TABLE IF NOT EXISTS `returnstocknew` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lotid` varchar(50) DEFAULT NULL,
  `ssccno` varchar(50) DEFAULT NULL,
  `tarewt` varchar(50) DEFAULT NULL,
  `netwt` varchar(50) DEFAULT NULL,
  `grosswt` varchar(50) DEFAULT NULL,
  `created` varchar(50) DEFAULT NULL,
  `userid` varchar(50) DEFAULT NULL,
  `updated` varchar(50) DEFAULT NULL,
  `contno` varchar(50) DEFAULT NULL,
  `rntime` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table returnstocknew
-- 

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

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

-- 
-- Definition of rolemaster
-- 

DROP TABLE IF EXISTS `rolemaster`;
CREATE TABLE IF NOT EXISTS `rolemaster` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) DEFAULT NULL,
  `password` varchar(50) DEFAULT NULL,
  `role` varchar(50) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table rolemaster
-- 

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

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

-- 
-- Definition of storagecondition
-- 

DROP TABLE IF EXISTS `storagecondition`;
CREATE TABLE IF NOT EXISTS `storagecondition` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `product` varchar(255) NOT NULL,
  `productid` int(11) NOT NULL DEFAULT '0',
  `grade` varchar(50) NOT NULL,
  `scondition` varchar(255) DEFAULT NULL,
  `aliasscondition` varchar(255) DEFAULT NULL,
  `createdat` datetime DEFAULT NULL,
  `updatedat` datetime DEFAULT NULL,
  `userid` varchar(50) DEFAULT NULL,
  `deletestatus` varchar(50) DEFAULT '0',
  `strgaprstatus` varchar(50) DEFAULT '0',
  `strgrejstatus` varchar(50) DEFAULT '0',
  `strgaprtime` datetime DEFAULT NULL,
  `strgrejtime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 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,'A',8,'IP',NULL,'A IP STORAGE','2024-09-17 15:09:12',NULL,'36','0','1','0','2024-09-17 15:09:21',NULL);
/*!40000 ALTER TABLE `storagecondition` ENABLE KEYS */;

-- 
-- Definition of userm
-- 

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

-- 
-- Dumping data for table userm
-- 

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

-- 
-- Definition of userrolemapping
-- 

DROP TABLE IF EXISTS `userrolemapping`;
CREATE TABLE IF NOT EXISTS `userrolemapping` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Userid` int(11) NOT NULL DEFAULT '0',
  `adminroleid` varchar(50) NOT NULL DEFAULT '0',
  `adnimistratorroleid` varchar(50) NOT NULL DEFAULT '0',
  `qualityroleid` varchar(50) NOT NULL DEFAULT '0',
  `companyunit` varchar(50) NOT NULL DEFAULT '0',
  `companyid` varchar(50) NOT NULL DEFAULT '0',
  `adminstatus` bit(1) DEFAULT NULL,
  `administratorstatus` bit(1) DEFAULT NULL,
  `qualityarrusarnacestatus` bit(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table userrolemapping
-- 

/*!40000 ALTER TABLE `userrolemapping` DISABLE KEYS */;
INSERT INTO `userrolemapping`(`id`,`Userid`,`adminroleid`,`adnimistratorroleid`,`qualityroleid`,`companyunit`,`companyid`,`adminstatus`,`administratorstatus`,`qualityarrusarnacestatus`) VALUES
(1,3,'1','1','2','CRUD','22',0,NULL,NULL);
/*!40000 ALTER TABLE `userrolemapping` ENABLE KEYS */;


/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;


-- Dump completed on 2024-10-01 17:58:22
-- Total time: 0:0:0:0:546 (d:h:m:s:ms)
