-- MySqlBackup.NET 2.0.4
-- Dump Time: 2024-07-31 17:04:37
-- --------------------------------------
-- 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=21 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,'Dioctyl Sodium Sulfosuccinate','DOCUSATE SODIUM',1,'2024-07-10 15:58:41',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'39',NULL,NULL,NULL,'0','1','0','2024-07-10 16:08:07',NULL),
(2,'    ','DOCUSATE SODIUM 85% POWDER',2,'2024-07-10 15:59:09',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'39',NULL,NULL,NULL,'0','1','0','2024-07-10 16:08:16',NULL),
(3,' ','PROPYL GALLATE ',3,'2024-07-10 16:00:03',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'39',NULL,NULL,NULL,'0','1','0','2024-07-10 16:08:25',NULL),
(4,'HEMIHYDRATE','CHLOROBUTANOL',4,'2024-07-11 13:31:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'39',NULL,NULL,NULL,'0','1','0','2024-07-11 13:32:11',NULL),
(5,'CHLORBUTOL','CHLOROBUTANOL',4,'2024-07-11 13:55:55',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'39',NULL,NULL,NULL,'0','1','0','2024-07-11 13:56:06',NULL),
(6,'CHLORBUTOL','CHLOROBUTANOL',4,'2024-07-11 14:06:36',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'39',NULL,NULL,NULL,'0','1','0','2024-07-11 14:06:44',NULL),
(7,'DOCUSATE SODIUM 85% POWDER\t','DOCUSATE SODIUM 85% POWDER',2,'2024-07-17 11:27:52',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'39',NULL,NULL,NULL,'0','1','0','2024-07-17 11:28:00',NULL),
(8,'DOCUSATE SODIUM 85%','DOCUSATE SODIUM 85% POWDER',5,'2024-07-17 11:33:02',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'39',NULL,NULL,NULL,'0','1','0','2024-07-17 11:33:07',NULL),
(9,'Sodium salt of 4-Chloro-2-[(furan-2-ylmethyl)amino]5-sulfamoylbenzoic acid','Sodium salt of 4-Chloro-2-[(furan-2-ylmethyl)amino]5-sulfamoylbenzoic acid',6,'2024-07-19 18:18:19',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'39',NULL,NULL,NULL,'0','1','0','2024-07-19 18:18:25',NULL),
(10,'Sodium salt of 4-Chloro-2-[(furan-2-ylmethyl)amino]5-sulfamoylbenzoic acid\t','Sodium salt of 4-Chloro-2-[(furan-2-ylmethyl)amino]5-sulfamoylbenzoic acid',6,'2024-07-24 17:08:58',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'39',NULL,NULL,NULL,'0','1','0','2024-07-24 17:09:03',NULL),
(11,'LAXA PA ALIAS','LAXA PA',7,'2024-07-25 12:30:05',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'36',NULL,NULL,NULL,'0','1','0','2024-07-25 12:30:12',NULL),
(12,'CHLORBUTOL','CHLOROBUTANOL.',8,'2024-07-27 13:35:23',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'39',NULL,NULL,NULL,'0','1','0','2024-07-27 13:35:28',NULL),
(13,'CHLORBUTOL','CHLOROBUTANOL.',8,'2024-07-27 13:42:07',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'39',NULL,NULL,NULL,'0','1','0','2024-07-27 13:42:12',NULL),
(14,'HEMIHYDRATE','CHLOROBUTANOL.',8,'2024-07-27 13:45:04',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'39',NULL,NULL,NULL,'0','1','0','2024-07-27 13:45:09',NULL),
(15,'CHLORBUTOL','CHLOROBUTANOL..',9,'2024-07-27 13:50:43',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'39',NULL,NULL,NULL,'0','1','0','2024-07-27 13:50:48',NULL),
(16,'PROPYL GALLATE','PROPYL GALLATE',10,'2024-07-27 13:57:54',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'39',NULL,NULL,NULL,'0','1','0','2024-07-27 13:58:00',NULL),
(17,'PROPYL ALIAS','Propyl Gallate 1',11,'2024-07-29 12:55:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'36',NULL,NULL,NULL,'0','1','0','2024-07-29 12:56:06',NULL),
(18,'CHLORBUTOL','CHLOROBUTANOL,',14,'2024-07-30 18:27:04',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'39',NULL,NULL,NULL,'0','1','0','2024-07-30 18:27:11',NULL),
(19,'N/A','Sodium salt of 4-Chloro-2-[(furan-2-ylmethyl)amino]5-sulfamoylbenzoic acid\t',16,'2024-07-30 18:38:08',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'39',NULL,NULL,NULL,'0','1','0','2024-07-30 18:38:23',NULL),
(20,'Sodium salt of 4-Chloro-2-[(furan-2-ylmethyl)amino]5-sulfamoylbenzoic acid','Sodium salt of 4-Chloro-2-[(furan-2-ylmethyl)amino]5-sulfamoylbenzoic acid',17,'2024-07-30 18:42:10',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'39',NULL,NULL,NULL,'0','1','0','2024-07-30 18:42:15',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 AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table customer
-- 

/*!40000 ALTER TABLE `customer` DISABLE KEYS */;
INSERT INTO `customer`(`id`,`custname`,`gstin`,`custadd`,`custphone`,`custemail`,`created`,`updated`,`custdrug`,`consiadd`,`consiname`,`consiemail`,`consiphone`,`consigst`,`considrug`,`displayname`,`type`,`userid`,`deletestatus`,`custaprstatus`,`custrejstatus`,`custaprtime`,`custrejtime`) VALUES
(1,'DUBROW LLC','   ','15 North Mill Street Nyack NY','0',' ','2024-07-10 16:22:58',NULL,'    ','','','','','','','DUBROW LLC','Customer','39','0','1','0','2024-07-11 13:30:45',NULL),
(2,'Festiva Pharma','24CGYPP8214M1ZJ','G4, ZANKHANA APP, VALSADPARDI,','9033667967','sales@festivapharma.com','2024-07-11 13:27:38',NULL,'GJ-VAL-126718 , GJ-VAL-126719','','','','','','','Festiva Pharma','Customer','39','0','1','0','2024-07-11 13:30:41',NULL);
/*!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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table dispatch
-- 

/*!40000 ALTER TABLE `dispatch` DISABLE KEYS */;
INSERT INTO `dispatch`(`id`,`lotno`,`distype`,`dod`,`bob`,`dob`,`customer`,`invoice`,`created`,`updated`,`userid`,`deletestatus`,`disaprstatus`,`disrejstatus`,`disaprtime`,`disrejtime`) VALUES
(1,'6','Local','2024-07-11 00:00:00','784596865','2024-07-11 00:00:00','2','23','2024-07-11 14:22:28',NULL,'39','0','1','0','2024-07-11 14:23:17',NULL);
/*!40000 ALTER TABLE `dispatch` ENABLE KEYS */;

-- 
-- Definition of generateqr
-- 

DROP TABLE IF EXISTS `generateqr`;
CREATE TABLE IF NOT EXISTS `generateqr` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `presetid` varchar(255) DEFAULT '',
  `genid` varchar(255) DEFAULT '',
  `title` varchar(255) DEFAULT '',
  `aliasproductid` varchar(255) DEFAULT '',
  `name` varchar(255) DEFAULT '',
  `formula1` varchar(255) DEFAULT '',
  `batch` varchar(255) DEFAULT '',
  `molwt` varchar(255) DEFAULT '',
  `grosswt` varchar(255) DEFAULT '',
  `tarewt` varchar(255) DEFAULT '',
  `netwt` varchar(255) DEFAULT '',
  `mfgdate` date DEFAULT NULL,
  `expdate` date DEFAULT NULL,
  `userid` varchar(50) DEFAULT NULL,
  `manuid` varchar(255) DEFAULT '',
  `contfrom` varchar(255) DEFAULT '',
  `contto` varchar(255) DEFAULT '',
  `contno` varchar(255) DEFAULT '',
  `grade` varchar(255) DEFAULT '',
  `pack` varchar(255) DEFAULT '',
  `ncont` varchar(255) DEFAULT '',
  `qrqty` varchar(255) DEFAULT '',
  `totalqty` varchar(255) DEFAULT '',
  `dispatch` varchar(255) DEFAULT '0',
  `returnst` varchar(255) DEFAULT '0',
  `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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 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`) VALUES
(1,'1','LAX/0724/001','','1','','','2','','','','25','2024-08-01 00:00:00','2029-07-01 00:00:00','39','0','','','','IP','25','3','','75','0','0','1','0','0','0','2024-07-10 00:00:00','2024-07-11 11:58:49',NULL,'Store protect from moisture.'),
(2,'3','LAX/0724/002','','3','','','1','','','','25','2024-08-01 00:00:00','2029-07-01 00:00:00','39','0','','','','IP','25','1','','25','0','0','1','0','0','0','2024-07-10 00:00:00','2024-07-11 11:59:00',NULL,'Store protect from light, in non-metallic container'),
(3,'2','LAX/0724/003','','2','','','3','','','','5','2024-07-01 00:00:00','2029-06-01 00:00:00','39','0','','','','USP','5','4','','20','0','0','1','0','0','0','2024-07-10 00:00:00','2024-07-11 11:59:14',NULL,'Preserve in well closed container'),
(4,'4','LAX/0724/004','','4','','','4','','','','25','2024-08-01 00:00:00','2029-07-01 00:00:00','39','0','','','','BP','25','3','','75','0','0','1','0','0','0','2024-07-11 00:00:00','2024-07-11 13:34:08',NULL,'Store protect from moisture at temperature not exceeding 30° C'),
(5,'4','LAX/0724/005','','5','','','4','','','','25','2024-08-01 00:00:00','2029-07-01 00:00:00','39','0','','','','BP','25','1','','25','0','0','1','0','0','0','2024-07-11 00:00:00','2024-07-11 13:57:14',NULL,'Store protect from moisture at temperature not exceeding 30° C'),
(6,'4','LAX/0724/006','','5','','','4','','','','25','2024-08-01 00:00:00','2029-07-01 00:00:00','39','0','','','','IP','25','3','','75','1','1','1','0','1','0','2024-07-11 00:00:00','2024-07-11 14:08:35',NULL,'Store protect from moisture at temperature not exceeding 30° C'),
(7,'4','LAX/0724/007','','5','','','4','','','','20','2024-08-01 00:00:00','2029-07-01 00:00:00','39','0','','','','BP','20','1','','20','0','0','1','0','0','0','2024-07-11 00:00:00','2024-07-11 16:37:01',NULL,'Preserve in well closed container'),
(8,'4','LAX/0724/008','','5','','','4','','','','5','2024-08-01 00:00:00','2029-07-01 00:00:00','39','0','','','','BP','5','2','','10','0','0','1','0','0','0','2024-07-11 00:00:00','2024-07-11 16:40:35',NULL,'Preserve in well closed container                                                   '),
(9,'2','LAX/0724/009','','2','','','3','','','','25','2024-07-01 00:00:00','2029-06-01 00:00:00','39','0','','','','USP','25','1','','25','0','0','1','0','0','0','2024-07-11 00:00:00','2024-07-11 17:53:25',NULL,'Preserve in well closed container'),
(10,'2','LAX/0724/010','','2','','','3','','','','25','2024-07-01 00:00:00','2029-06-01 00:00:00','39','0','','','','USP','25','1','','25','0','0','1','0','0','0','2024-07-11 00:00:00','2024-07-11 17:54:15',NULL,'Preserve in well closed container'),
(11,'2','LAX/0724/011','','7','','','5','','','','25','2024-08-01 00:00:00','2029-07-01 00:00:00','39','0','','','','USP','25','2','','50','0','0','1','0','0','0','2024-07-17 00:00:00','2024-07-17 11:29:16',NULL,'Preserve in well closed container'),
(12,'5','LAX/0724/012','','8','','','6','','','','25','2024-08-01 00:00:00','2029-07-01 00:00:00','39','0','','','','USP','25','2','','50','0','0','1','0','0','0','2024-07-17 00:00:00','2024-07-17 11:34:14',NULL,'Preserve in well closed container'),
(13,'6','LAX/0724/013','','9','','','7','','','','25','2024-06-01 00:00:00','2029-05-01 00:00:00','39','0','','','','IP','25','1','','25','0','0','1','0','0','0','2024-07-19 00:00:00','2024-07-19 18:20:32',NULL,'-'),
(14,'6','LAX/0724/014','','9','','','7','','','','25','2024-06-01 00:00:00','2029-05-01 00:00:00','39','0','','','','IP','25','2','','50','0','0','1','0','0','0','2024-07-24 00:00:00','2024-07-24 16:50:18',NULL,'-'),
(15,'6','LAX/0724/015','','9','','','8','','','','25','2024-08-01 00:00:00','2029-07-01 00:00:00','39','0','','','','IP','25','3','','75','0','0','1','0','0','0','2024-07-24 00:00:00','2024-07-24 17:10:28',NULL,'NA'),
(16,'7','LAX/0724/016','','11','','','9','','','','15','2024-08-01 00:00:00','2027-07-01 00:00:00','36','0','','','','TECHNICAL','15','5','','75','0','0','1','0','0','0','2024-07-25 00:00:00','2024-07-25 12:32:01',NULL,'LAXA PA TECHNCAL GRADE STORAGE CONDITION'),
(17,'7','LAX/0724/017','','11','','','9','','','','25','2024-08-01 00:00:00','2027-07-01 00:00:00','36','0','','','','IP','25','2','','50','0','0','1','0','0','0','2024-07-25 00:00:00','2024-07-25 12:33:42',NULL,'LAXA PA IP GRADE STORAGE CONDITION '),
(18,'7','LAX/0724/018','','11','','','9','','','','25','2024-08-01 00:00:00','2027-07-01 00:00:00','36','0','','','','TECHNICAL','25','3','','75','0','0','1','0','0','0','2024-07-27 00:00:00','2024-07-27 11:22:07',NULL,'LAXA PA TECHNCAL GRADE STORAGE CONDITION'),
(19,'8','LAX/0724/019','','12','','','10','','','','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-07-27 00:00:00','2024-07-27 13:43:14',NULL,'Store protect from moisture at temperature not exceeding 30° C'),
(20,'8','LAX/0724/020','','14','','','10','','','','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-07-27 00:00:00','2024-07-27 13:45:54',NULL,'Store protect from moisture at temperature not exceeding 30° C'),
(21,'9','LAX/0724/021','','15','','','11','','','','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-07-27 00:00:00','2024-07-27 13:51:58',NULL,'Store protect from moisture at temperature not exceeding 30° C..'),
(22,'10','LAX/0724/022','','16','','','12','','','','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-07-27 00:00:00','2024-07-27 13:59:26',NULL,'Store protect from light, in non-metallic container'),
(23,'11','LAX/0724/023','','17','','','13','','','','15','2024-08-01 00:00:00','2026-07-01 00:00:00','36','0','','','','TECHNICAL','15','3','','45','0','0','1','0','0','0','2024-07-29 00:00:00','2024-07-29 12:56:37',NULL,'STORAGE CONDITION IS NOT AVAILABLE FOR THIS GRADE'),
(24,'14','LAX/0724/024','','18','','','14','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','25','3','','75','0','0','1','0','0','0','2024-07-30 00:00:00','2024-07-30 18:28:48',NULL,'Store protect from light, in non-metallic container'),
(25,'16','LAX/0724/025','','19','','','15','','','','25','2024-09-01 00:00:00','2029-07-01 00:00:00','39','0','','','','TECHNICAL','25','4','','100','0','0','1','0','0','0','2024-07-30 00:00:00','2024-07-30 18:39:44',NULL,'N/A'),
(26,'17','LAX/0724/026','','20','','','16','','','','25','2024-02-01 00:00:00','2029-01-01 00:00:00','39','0','','','','TECHNICAL','25','3','','75','0','0','1','0','0','0','2024-07-30 00:00:00','2024-07-30 18:45:02',NULL,'N/A');
/*!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=60 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/1','1','3.3','28.3','001','089061816400230017','0','0','0','25','2'),
(2,'1/1','2','3.3','28.3','001','089061816400470013','0','0','0','25','1'),
(3,'1/4','3','0.25','5.25','001','089061816400300015','0','0','0','5','3'),
(4,'2/4','3','0.25','5.25','002','089061816400300024','0','0','0','5','3'),
(5,'3/4','3','0.25','5.25','003','089061816400300033','0','0','0','5','3'),
(6,'4/4','3','0.25','5.25','004','089061816400300042','0','0','0','5','3'),
(7,'1/3','4','2.8','27.8','001','089061816400090011','0','0','0','25','4'),
(8,'2/3','4','2.8','27.8','002','089061816400090020','0','0','0','25','4'),
(9,'3/3','4','2.8','27.8','003','089061816400090039','0','0','0','25','4'),
(10,'1/1','5','2.8','27.8','004','089061816400090048','0','0','0','25','4'),
(11,'1/3','6','2.8','27.8','005','089061816400090057','0','0','1','25','4'),
(12,'2/3','6','2.8','27.8','006','089061816400090066','0','0','1','25','4'),
(13,'3/3','6','2.8','27.8','007','089061816400090075','0','0','0','25','4'),
(14,'1/1','7','3.3','23.3','008','089061816400090084','0','0','0','20','4'),
(15,'1/2','8','0.25','5.25','009','089061816400090093','0','0','0','5','4'),
(16,'2/2','8','0.25','5.25','010','089061816400090109','0','0','0','5','4'),
(17,'1/1','9','3.3','28.3','005','089061816400300051','0','0','0','25','3'),
(18,'1/1','10','2.8','27.8','006','089061816400300060','0','0','0','25','3'),
(19,'1/2','11','28.3','53.3','007','089061816400300079','0','0','0','25','5'),
(20,'2/2','11','28.3','53.3','008','089061816400300088','0','0','0','25','5'),
(21,'1/2','12','28.3','53.3','001','089061816400300015','0','0','0','25','6'),
(22,'2/2','12','28.3','53.3','002','089061816400300024','0','0','0','25','6'),
(23,'1/1','13','4.25','29.25','001','0-001NaN','0','0','0','25','7'),
(24,'1/2','14','4.25','29.25','002','0-002NaN','0','0','0','25','7'),
(25,'2/2','14','4.25','29.25','003','0-003NaN','0','0','0','25','7'),
(26,'1/3','15','2.25','27.25','004','0NA004NaN','0','0','0','25','8'),
(27,'2/3','15','2.25','27.25','005','0NA005NaN','0','0','0','25','8'),
(28,'3/3','15','2.25','27.25','006','0NA006NaN','0','0','0','25','8'),
(29,'1/5','16','152.25','167.25','001','012552447250012','0','0','0','15','9'),
(30,'2/5','16','152.25','167.25','002','012552447250029','0','0','0','15','9'),
(31,'3/5','16','152.25','167.25','003','012552447250036','0','0','0','15','9'),
(32,'4/5','16','152.25','167.25','004','012552447250043','0','0','0','15','9'),
(33,'5/5','16','152.25','167.25','005','012552447250050','0','0','0','15','9'),
(34,'1/2','17','120.58','145.57999999999998','006','012552447250067','0','0','0','25','9'),
(35,'2/2','17','120.58','145.57999999999998','007','012552447250074','0','0','0','25','9'),
(36,'1/3','18','12.025','37.025','008','012552447250081','0','0','0','25','9'),
(37,'2/3','18','12.025','37.025','009','012552447250098','0','0','0','25','9'),
(38,'3/3','18','12.025','37.025','010','012552447250104','0','0','0','25','9'),
(39,'1/2','19','2.8','27.8','001','089061816400090011','0','0','0','25','10'),
(40,'2/2','19','2.8','27.8','002','089061816400090020','0','0','0','25','10'),
(41,'1/2','20','2.8','27.8','003','089061816400090039','0','0','0','25','10'),
(42,'2/2','20','2.8','27.8','004','089061816400090048','0','0','0','25','10'),
(43,'1/2','21','2.8','27.8','001','089061816400090011','0','1','0','25','11'),
(44,'2/2','21','2.8','27.8','002','089061816400090020','0','0','0','25','11'),
(45,'1/2','22','4.25','29.25','001','089061816400470013','0','0','0','25','12'),
(46,'2/2','22','4.25','29.25','002','089061816400470022','0','0','0','25','12'),
(47,'1/3','23','120.5','135.5','001','0549986520015','0','0','0','15','13'),
(48,'2/3','23','120.5','135.5','002','0549986520022','0','0','0','15','13'),
(49,'3/3','23','120.5','135.5','003','0549986520039','0','0','0','15','13'),
(50,'1/3','24','2.8','27.8','001','089061816400090011','0','0','0','25','14'),
(51,'2/3','24','2.8','27.8','002','089061816400090020','0','0','0','25','14'),
(52,'3/3','24','2.8','27.8','003','089061816400090039','0','0','0','25','14'),
(53,'1/4','25','4.25','29.25','001','0N/A001NaN','0','0','0','25','15'),
(54,'2/4','25','4.25','29.25','002','0N/A002NaN','0','0','0','25','15'),
(55,'3/4','25','4.25','29.25','003','0N/A003NaN','0','0','0','25','15'),
(56,'4/4','25','4.25','29.25','004','0N/A004NaN','0','0','0','25','15'),
(57,'1/3','26','4.25','29.25','001','0N/A001NaN','0','0','0','25','16'),
(58,'2/3','26','4.25','29.25','002','0N/A002NaN','0','0','0','25','16'),
(59,'3/3','26','4.25','29.25','003','0N/A003NaN','0','0','0','25','16');
/*!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=416 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-07-10 12:30:40','36','Login In'),
(2,NULL,'User Logged In','2024-07-10 12:34:48','39','Login In'),
(3,NULL,'New Product Added','2024-07-10 12:41:04','39','Product'),
(4,NULL,'New Product Added','2024-07-10 12:46:44','39','Product'),
(5,NULL,'New Product Added','2024-07-10 12:50:15','39','Product'),
(6,NULL,'Company Deleted','2024-07-10 12:52:39','39','Company Unit'),
(7,NULL,'Company Deleted','2024-07-10 12:52:42','39','Company Unit'),
(8,NULL,'Company Deleted','2024-07-10 12:52:45','39','Company Unit'),
(9,NULL,'Company Deleted','2024-07-10 12:52:47','39','Company Unit'),
(10,NULL,'User Logged In','2024-07-10 15:12:57','39','Login In'),
(11,NULL,'User Logged In','2024-07-10 15:18:12','37','Login In'),
(12,NULL,'Product Approved','2024-07-10 15:18:46','37','Approval'),
(13,NULL,'Product Approved','2024-07-10 15:19:25','37','Approval'),
(14,NULL,'Product Approved','2024-07-10 15:19:40','37','Approval'),
(15,NULL,'Product Approved','2024-07-10 15:19:59','37','Approval'),
(16,NULL,'Product Approved','2024-07-10 15:20:22','37','Approval'),
(17,NULL,'Product Approved','2024-07-10 15:20:27','37','Approval'),
(18,NULL,'Product Approved','2024-07-10 15:20:36','37','Approval'),
(19,NULL,'Company Unit Delete Approved','2024-07-10 15:20:56','37','Approval'),
(20,NULL,'Company Unit Delete Approved','2024-07-10 15:21:08','37','Approval'),
(21,NULL,'Company Unit Delete Approved','2024-07-10 15:21:31','37','Approval'),
(22,NULL,'Batch Added','2024-07-10 15:22:53','39','Batch'),
(23,NULL,'Company Unit Delete Approved','2024-07-10 15:24:19','37','Approval'),
(24,NULL,'Batch Added','2024-07-10 15:24:30','39','Batch'),
(25,NULL,'User Logged Out','2024-07-10 15:25:36','37','Log Out'),
(26,NULL,'Batch Added','2024-07-10 15:25:35','39','Batch'),
(27,NULL,'User Logged In','2024-07-10 15:28:02','38','Login In'),
(28,NULL,'User Logged In','2024-07-10 15:28:18','39','Login In'),
(29,NULL,'User Logged Out','2024-07-10 15:30:41','39','Log Out'),
(30,NULL,'User Logged In','2024-07-10 15:30:43','39','Login In'),
(31,NULL,'User Logged Out','2024-07-10 15:30:50','39','Log Out'),
(32,NULL,'Company Deleted','2024-07-10 15:31:54','39','Company Unit'),
(33,NULL,'New Company Added','2024-07-10 15:31:59','39','Company Unit'),
(34,NULL,'User Logged In','2024-07-10 15:55:38','37','Login In'),
(35,NULL,'Batch Approved','2024-07-10 15:56:14','37','Approval'),
(36,NULL,'Batch Approved','2024-07-10 15:56:26','37','Approval'),
(37,NULL,'Batch Approved','2024-07-10 15:56:37','37','Approval'),
(38,NULL,'User Logged Out','2024-07-10 15:56:45','39','Log Out'),
(39,NULL,'User Logged In','2024-07-10 15:56:47','39','Login In'),
(40,NULL,'Company Unit Delete Approved','2024-07-10 15:56:49','37','Approval'),
(41,NULL,'Company Unit Approved','2024-07-10 15:56:57','37','Approval'),
(42,NULL,'Company Unit Approved','2024-07-10 15:57:09','37','Approval'),
(43,NULL,'User Logged Out','2024-07-10 15:57:22','37','Log Out'),
(44,NULL,'Alias Product Added','2024-07-10 15:58:41','39','Alias Product'),
(45,NULL,'Alias Product Added','2024-07-10 15:59:09','39','Alias Product'),
(46,NULL,'Alias Product Added','2024-07-10 16:00:03','39','Alias Product'),
(47,NULL,'User Logged Out','2024-07-10 16:03:45','39','Log Out'),
(48,NULL,'User Logged In','2024-07-10 16:03:47','39','Login In'),
(49,NULL,'User Logged In','2024-07-10 16:07:40','37','Login In'),
(50,NULL,'Alias Product Approved','2024-07-10 16:08:07','37','Approval'),
(51,NULL,'Alias Product Approved','2024-07-10 16:08:16','37','Approval'),
(52,NULL,'Alias Product Approved','2024-07-10 16:08:25','37','Approval'),
(53,NULL,'User Logged Out','2024-07-10 16:08:41','37','Log Out'),
(54,NULL,'Storage Condition Added','2024-07-10 16:15:55','39','Storage Condition'),
(55,NULL,'Storage Condition Added','2024-07-10 16:16:39','39','Storage Condition'),
(56,NULL,'Storage Condition Added','2024-07-10 16:17:10','39','Storage Condition'),
(57,NULL,'Customer Added','2024-07-10 16:22:57','39','Customer'),
(58,NULL,'Storage Condition Edited','2024-07-10 16:32:57','39','Storage Condition'),
(59,NULL,'User Logged Out','2024-07-10 16:50:29','39','Log Out'),
(60,NULL,'User Logged In','2024-07-10 16:50:31','39','Login In'),
(61,NULL,'User Logged In','2024-07-10 16:54:48','37','Login In'),
(62,NULL,'Storage Condition Approved','2024-07-10 16:55:40','37','Storage Condition'),
(63,NULL,'Storage Condition Approved','2024-07-10 16:55:47','37','Storage Condition'),
(64,NULL,'Storage Condition Approved','2024-07-10 16:58:23','37','Storage Condition'),
(65,NULL,'QR generated','2024-07-10 17:04:14','39','Generateqr'),
(66,NULL,'QR generated','2024-07-10 17:06:45','39','Generateqr'),
(67,NULL,'QR generated','2024-07-10 17:07:56','39','Generateqr'),
(68,NULL,'User Logged In','2024-07-11 11:58:26','37','Login In'),
(69,NULL,'Generateqr Approved','2024-07-11 11:58:49','37','Approval'),
(70,NULL,'Generateqr Approved','2024-07-11 11:59:00','37','Approval'),
(71,NULL,'Generateqr Approved','2024-07-11 11:59:14','37','Approval'),
(72,NULL,'User Logged Out','2024-07-11 11:59:26','37','Log Out'),
(73,NULL,'User Logged In','2024-07-11 12:09:16','39','Login In'),
(74,NULL,'Single Print Had Taken','2024-07-11 12:10:10','39','generateqrsr'),
(75,NULL,'Single Print Had Taken','2024-07-11 12:10:50','39','generateqrsr'),
(76,NULL,'Single Print Had Taken','2024-07-11 12:12:03','39','generateqrsr'),
(77,NULL,'Single Print Had Taken','2024-07-11 12:13:57','39','generateqrsr'),
(78,NULL,'User Logged In','2024-07-11 12:29:21','39','Login In'),
(79,NULL,'Single Print Had Taken','2024-07-11 12:35:05','39','generateqrsr'),
(80,NULL,'User Logged In','2024-07-11 13:11:29','37','Login In'),
(81,NULL,'User Logged In','2024-07-11 13:18:33','39','Login In'),
(82,NULL,'User Logged In','2024-07-11 13:20:27','37','Login In'),
(83,NULL,'New Product Added','2024-07-11 13:23:19','39','Product'),
(84,NULL,'Product Approved','2024-07-11 13:23:41','37','Approval'),
(85,NULL,'User Logged In','2024-07-11 13:24:30','37','Login In'),
(86,NULL,'Batch Added','2024-07-11 13:24:33','39','Batch'),
(87,NULL,'Batch Approved','2024-07-11 13:24:47','37','Approval'),
(88,NULL,'User Logged Out','2024-07-11 13:25:57','37','Log Out'),
(89,NULL,'Customer Added','2024-07-11 13:27:38','39','Customer'),
(90,NULL,'User Logged In','2024-07-11 13:30:30','38','Login In'),
(91,NULL,'Customer Approved','2024-07-11 13:30:41','38','Approval'),
(92,NULL,'Customer Approved','2024-07-11 13:30:45','38','Approval'),
(93,NULL,'Alias Product Added','2024-07-11 13:31:50','39','Alias Product'),
(94,NULL,'Alias Product Approved','2024-07-11 13:32:11','37','Approval'),
(95,NULL,'Storage Condition Added','2024-07-11 13:32:47','39','Storage Condition'),
(96,NULL,'Storage Condition Approved','2024-07-11 13:33:10','37','Storage Condition'),
(97,NULL,'QR generated','2024-07-11 13:33:55','39','Generateqr'),
(98,NULL,'Generateqr Approved','2024-07-11 13:34:08','37','Approval'),
(99,NULL,'Multiple Print Had Taken','2024-07-11 13:34:29','39','generateqrsr'),
(100,NULL,'Single Print Had Taken','2024-07-11 13:35:11','39','generateqrsr'),
(101,NULL,'Alias Product Added','2024-07-11 13:55:54','39','Alias Product'),
(102,NULL,'Alias Product Approved','2024-07-11 13:56:06','37','Approval'),
(103,NULL,'QR generated','2024-07-11 13:57:02','39','Generateqr'),
(104,NULL,'Generateqr Approved','2024-07-11 13:57:14','37','Approval'),
(105,NULL,'Single Print Had Taken','2024-07-11 13:57:56','39','generateqrsr'),
(106,NULL,'Product Updated','2024-07-11 14:04:37','39','Product'),
(107,NULL,'Product Approved','2024-07-11 14:04:50','37','Approval'),
(108,NULL,'Batch Updated','2024-07-11 14:05:54','39','Batch'),
(109,NULL,'Batch Approved','2024-07-11 14:06:03','37','Approval'),
(110,NULL,'Alias Product Added','2024-07-11 14:06:35','39','Alias Product'),
(111,NULL,'Alias Product Approved','2024-07-11 14:06:44','37','Approval'),
(112,NULL,'Storage Condition Added','2024-07-11 14:07:42','39','Storage Condition'),
(113,NULL,'Storage Condition Approved','2024-07-11 14:07:48','37','Storage Condition'),
(114,NULL,'QR generated','2024-07-11 14:08:24','39','Generateqr'),
(115,NULL,'Generateqr Approved','2024-07-11 14:08:35','37','Approval'),
(116,NULL,'Multiple Print Had Taken','2024-07-11 14:08:48','39','generateqrsr'),
(117,NULL,'Lot Dispatched','2024-07-11 14:22:28','39','Dispatch'),
(118,NULL,'User Logged In','2024-07-11 14:23:08','38','Login In'),
(119,NULL,'Dispatch Approved','2024-07-11 14:23:17','38','Approval'),
(120,NULL,'Stock Returned','2024-07-11 14:25:36','39','Return Stocks'),
(121,NULL,'Returnstock Approved','2024-07-11 14:26:14','38','Approval'),
(122,NULL,'User Logged Out','2024-07-11 14:32:18','38','Log Out'),
(123,NULL,'User Logged In','2024-07-11 16:27:17','39','Login In'),
(124,NULL,'Storage Condition Added','2024-07-11 16:35:12','39','Storage Condition'),
(125,NULL,'User Logged In','2024-07-11 16:35:38','37','Login In'),
(126,NULL,'Storage Condition Approved','2024-07-11 16:35:57','37','Storage Condition'),
(127,NULL,'QR generated','2024-07-11 16:36:48','39','Generateqr'),
(128,NULL,'Generateqr Approved','2024-07-11 16:37:01','37','Approval'),
(129,NULL,'Single Print Had Taken','2024-07-11 16:37:19','39','generateqrsr'),
(130,NULL,'Storage Condition Edited','2024-07-11 16:39:23','39','Storage Condition'),
(131,NULL,'Storage Condition Updated','2024-07-11 16:39:31','39','Storage Condition'),
(132,NULL,'Storage Condition Approved','2024-07-11 16:39:42','37','Storage Condition'),
(133,NULL,'QR generated','2024-07-11 16:40:23','39','Generateqr'),
(134,NULL,'Generateqr Approved','2024-07-11 16:40:35','37','Approval'),
(135,NULL,'Multiple Print Had Taken','2024-07-11 16:40:50','39','generateqrsr'),
(136,NULL,'User Logged Out','2024-07-11 16:43:27','39','Log Out'),
(137,NULL,'User Logged In','2024-07-11 16:44:53','39','Login In'),
(138,NULL,'User Logged In','2024-07-11 17:19:16','36','Login In'),
(139,NULL,'Single Print Had Taken','2024-07-11 17:20:19','36','generateqrsr'),
(140,NULL,'Multiple Print Had Taken','2024-07-11 17:20:50','36','generateqrsr'),
(141,NULL,'User Logged In','2024-07-11 17:24:49','36','Login In'),
(142,NULL,'Single Print Had Taken','2024-07-11 17:25:22','36','generateqrsr'),
(143,NULL,'User Logged In','2024-07-11 17:32:34','39','Login In'),
(144,NULL,'Single Print Had Taken','2024-07-11 17:33:09','39','generateqrsr'),
(145,NULL,'QR generated','2024-07-11 17:45:44','39','Generateqr'),
(146,NULL,'User Logged In','2024-07-11 17:53:16','37','Login In'),
(147,NULL,'Generateqr Approved','2024-07-11 17:53:25','37','Approval'),
(148,NULL,'QR generated','2024-07-11 17:54:05','39','Generateqr'),
(149,NULL,'Generateqr Approved','2024-07-11 17:54:15','37','Approval'),
(150,NULL,'Single Print Had Taken','2024-07-11 17:54:41','39','generateqrsr'),
(151,NULL,'User Logged In','2024-07-11 18:26:07','36','Login In'),
(152,NULL,'User Logged In','2024-07-12 11:12:51','36','Login In'),
(153,NULL,'Single Print Had Taken','2024-07-12 11:13:16','36','generateqrsr'),
(154,NULL,'User Logged In','2024-07-12 17:26:18','39','Login In'),
(155,NULL,'Single Print Had Taken','2024-07-12 17:27:10','39','generateqrsr'),
(156,NULL,'Multiple Print Had Taken','2024-07-12 17:27:42','39','generateqrsr'),
(157,NULL,'Single Print Had Taken','2024-07-12 17:29:34','39','generateqrsr'),
(158,NULL,'Multiple Print Had Taken','2024-07-12 17:30:42','39','generateqrsr'),
(159,NULL,'User Logged In','2024-07-17 11:09:31','39','Login In'),
(160,NULL,'Single Print Had Taken','2024-07-17 11:09:59','39','generateqrsr'),
(161,NULL,'Single Print Had Taken','2024-07-17 11:10:39','39','generateqrsr'),
(162,NULL,'User Logged Out','2024-07-17 11:23:31','39','Log Out'),
(163,NULL,'User Logged In','2024-07-17 11:23:42','39','Login In'),
(164,NULL,'User Logged In','2024-07-17 11:24:27','37','Login In'),
(165,NULL,'New Product Added','2024-07-17 11:26:15','39','Product'),
(166,NULL,'Product Approved','2024-07-17 11:26:24','37','Approval'),
(167,NULL,'Batch Added','2024-07-17 11:27:14','39','Batch'),
(168,NULL,'Batch Approved','2024-07-17 11:27:22','37','Approval'),
(169,NULL,'Alias Product Added','2024-07-17 11:27:52','39','Alias Product'),
(170,NULL,'Alias Product Approved','2024-07-17 11:28:00','37','Approval'),
(171,NULL,'Storage Condition Added','2024-07-17 11:28:21','39','Storage Condition'),
(172,NULL,'Storage Condition Approved','2024-07-17 11:28:26','37','Storage Condition'),
(173,NULL,'QR generated','2024-07-17 11:29:08','39','Generateqr'),
(174,NULL,'Generateqr Approved','2024-07-17 11:29:16','37','Approval'),
(175,NULL,'Single Print Had Taken','2024-07-17 11:29:30','39','generateqrsr'),
(176,NULL,'Product Deleted','2024-07-17 11:30:29','39','Product'),
(177,NULL,'Product Delete Request Approved','2024-07-17 11:30:37','37','Approval'),
(178,NULL,'Single Print Had Taken','2024-07-17 11:30:51','39','generateqrsr'),
(179,NULL,'Batch Added','2024-07-17 11:32:29','39','Batch'),
(180,NULL,'Batch Approved','2024-07-17 11:32:34','37','Approval'),
(181,NULL,'Alias Product Added','2024-07-17 11:33:01','39','Alias Product'),
(182,NULL,'Alias Product Approved','2024-07-17 11:33:07','37','Approval'),
(183,NULL,'Storage Condition Added','2024-07-17 11:33:25','39','Storage Condition'),
(184,NULL,'Storage Condition Approved','2024-07-17 11:33:31','37','Storage Condition'),
(185,NULL,'QR generated','2024-07-17 11:34:08','39','Generateqr'),
(186,NULL,'Generateqr Approved','2024-07-17 11:34:14','37','Approval'),
(187,NULL,'Multiple Print Had Taken','2024-07-17 11:34:33','39','generateqrsr'),
(188,NULL,'Multiple Print Had Taken','2024-07-17 11:35:01','39','generateqrsr'),
(189,NULL,'User Logged In','2024-07-19 18:09:25','39','Login In'),
(190,NULL,'User Logged In','2024-07-19 18:12:41','37','Login In'),
(191,NULL,'New Product Added','2024-07-19 18:15:58','39','Product'),
(192,NULL,'Product Approved','2024-07-19 18:16:13','37','Approval'),
(193,NULL,'Batch Added','2024-07-19 18:17:39','39','Batch'),
(194,NULL,'Batch Approved','2024-07-19 18:17:49','37','Approval'),
(195,NULL,'Alias Product Added','2024-07-19 18:18:19','39','Alias Product'),
(196,NULL,'Alias Product Approved','2024-07-19 18:18:25','37','Approval'),
(197,NULL,'Storage Condition Added','2024-07-19 18:19:17','39','Storage Condition'),
(198,NULL,'Storage Condition Approved','2024-07-19 18:19:24','37','Storage Condition'),
(199,NULL,'QR generated','2024-07-19 18:20:22','39','Generateqr'),
(200,NULL,'Generateqr Approved','2024-07-19 18:20:32','37','Approval'),
(201,NULL,'Multiple Print Had Taken','2024-07-19 18:20:48','39','generateqrsr'),
(202,NULL,'Single Print Had Taken','2024-07-19 18:22:36','39','generateqrsr'),
(203,NULL,'Single Print Had Taken','2024-07-19 18:23:44','39','generateqrsr'),
(204,NULL,'User Logged In','2024-07-23 11:37:03','36','Login In'),
(205,NULL,'Single Print Had Taken','2024-07-23 11:38:20','36','generateqrsr'),
(206,NULL,'User Logged In','2024-07-23 11:42:39','36','Login In'),
(207,NULL,'Single Print Had Taken','2024-07-23 11:42:55','36','generateqrsr'),
(208,NULL,'Single Print Had Taken','2024-07-23 11:43:12','36','generateqrsr'),
(209,NULL,'Single Print Had Taken','2024-07-23 11:49:55','36','generateqrsr'),
(210,NULL,'Multiple Print Had Taken','2024-07-23 11:50:11','36','generateqrsr'),
(211,NULL,'User Logged In','2024-07-23 18:54:48','39','Login In'),
(212,NULL,'Single Print Had Taken','2024-07-23 18:57:20','39','generateqrsr'),
(213,NULL,'Single Print Had Taken','2024-07-23 19:04:13','39','generateqrsr'),
(214,NULL,'Single Print Had Taken','2024-07-23 19:05:01','39','generateqrsr'),
(215,NULL,'User Logged In','2024-07-23 19:26:34','36','Login In'),
(216,NULL,'Alias Product Edited','2024-07-23 19:34:42','36','Alias Product'),
(217,NULL,'Product Updated','2024-07-23 19:35:39','36','Product'),
(218,NULL,'User Logged In','2024-07-23 19:38:41','38','Login In'),
(219,NULL,'User Logged Out','2024-07-23 19:39:28','38','Log Out'),
(220,NULL,'User Logged In','2024-07-23 19:39:42','37','Login In'),
(221,NULL,'User Logged In','2024-07-24 10:13:12','39','Login In'),
(222,NULL,'User Logged In','2024-07-24 16:45:51','39','Login In'),
(223,NULL,'Product Updated','2024-07-24 16:46:43','39','Product'),
(224,NULL,'User Logged In','2024-07-24 16:47:40','37','Login In'),
(225,NULL,'Product Approved','2024-07-24 16:47:52','37','Approval'),
(226,NULL,'QR generated','2024-07-24 16:50:08','39','Generateqr'),
(227,NULL,'Generateqr Approved','2024-07-24 16:50:18','37','Approval'),
(228,NULL,'Single Print Had Taken','2024-07-24 16:50:39','39','generateqrsr'),
(229,NULL,'Single Print Had Taken','2024-07-24 16:51:21','39','generateqrsr'),
(230,NULL,'Single Print Had Taken','2024-07-24 16:51:38','39','generateqrsr'),
(231,NULL,'Product Updated','2024-07-24 17:07:17','39','Product'),
(232,NULL,'Product Approved','2024-07-24 17:07:27','37','Approval'),
(233,NULL,'Batch Added','2024-07-24 17:08:23','39','Batch'),
(234,NULL,'Batch Approved','2024-07-24 17:08:30','37','Approval'),
(235,NULL,'Alias Product Added','2024-07-24 17:08:58','39','Alias Product'),
(236,NULL,'Alias Product Approved','2024-07-24 17:09:03','37','Approval'),
(237,NULL,'Storage Condition Added','2024-07-24 17:09:28','39','Storage Condition'),
(238,NULL,'Storage Condition Approved','2024-07-24 17:09:32','37','Storage Condition'),
(239,NULL,'QR generated','2024-07-24 17:10:21','39','Generateqr'),
(240,NULL,'Generateqr Approved','2024-07-24 17:10:28','37','Approval'),
(241,NULL,'Single Print Had Taken','2024-07-24 17:10:42','39','generateqrsr'),
(242,NULL,'Single Print Had Taken','2024-07-24 17:11:02','39','generateqrsr'),
(243,NULL,'User Logged In','2024-07-25 12:10:07','36','Login In'),
(244,NULL,'Single Print Had Taken','2024-07-25 12:10:29','36','generateqrsr'),
(245,NULL,'Multiple Print Had Taken','2024-07-25 12:10:58','36','generateqrsr'),
(246,NULL,'User Logged In','2024-07-25 12:27:53','36','Login In'),
(247,NULL,'New Product Added','2024-07-25 12:29:06','36','Product'),
(248,NULL,'Product Approved','2024-07-25 12:29:16','36','Approval'),
(249,NULL,'Batch Added','2024-07-25 12:29:41','36','Batch'),
(250,NULL,'Batch Approved','2024-07-25 12:29:50','36','Approval'),
(251,NULL,'Alias Product Added','2024-07-25 12:30:04','36','Alias Product'),
(252,NULL,'Alias Product Approved','2024-07-25 12:30:12','36','Approval'),
(253,NULL,'Storage Condition Added','2024-07-25 12:30:31','36','Storage Condition'),
(254,NULL,'Storage Condition Added','2024-07-25 12:30:50','36','Storage Condition'),
(255,NULL,'Storage Condition Added','2024-07-25 12:31:08','36','Storage Condition'),
(256,NULL,'Storage Condition Approved','2024-07-25 12:31:13','36','Storage Condition'),
(257,NULL,'Storage Condition Approved','2024-07-25 12:31:15','36','Storage Condition'),
(258,NULL,'Storage Condition Approved','2024-07-25 12:31:17','36','Storage Condition'),
(259,NULL,'QR generated','2024-07-25 12:31:53','36','Generateqr'),
(260,NULL,'Generateqr Approved','2024-07-25 12:32:01','36','Approval'),
(261,NULL,'Single Print Had Taken','2024-07-25 12:32:35','36','generateqrsr'),
(262,NULL,'Multiple Print Had Taken','2024-07-25 12:33:01','36','generateqrsr'),
(263,NULL,'QR generated','2024-07-25 12:33:32','36','Generateqr'),
(264,NULL,'Generateqr Approved','2024-07-25 12:33:42','36','Approval'),
(265,NULL,'Single Print Had Taken','2024-07-25 12:34:07','36','generateqrsr'),
(266,NULL,'Multiple Print Had Taken','2024-07-25 12:34:28','36','generateqrsr'),
(267,NULL,'Single Print Had Taken','2024-07-25 12:38:00','36','generateqrsr'),
(268,NULL,'Multiple Print Had Taken','2024-07-25 12:39:51','36','generateqrsr'),
(269,NULL,'Single Print Had Taken','2024-07-25 12:40:12','36','generateqrsr'),
(270,NULL,'Single Print Had Taken','2024-07-25 12:40:40','36','generateqrsr'),
(271,NULL,'User Logged In','2024-07-25 13:24:55','36','Login In'),
(272,NULL,'Single Print Had Taken','2024-07-25 13:25:51','36','generateqrsr'),
(273,NULL,'Single Print Had Taken','2024-07-25 13:27:07','36','generateqrsr'),
(274,NULL,'Multiple Print Had Taken','2024-07-25 13:27:25','36','generateqrsr'),
(275,NULL,'User Logged In','2024-07-27 11:20:42','36','Login In'),
(276,NULL,'QR generated','2024-07-27 11:21:48','36','Generateqr'),
(277,NULL,'Generateqr Approved','2024-07-27 11:22:07','36','Approval'),
(278,NULL,'Single Print Had Taken','2024-07-27 11:22:27','36','generateqrsr'),
(279,NULL,'Multiple Print Had Taken','2024-07-27 11:22:47','36','generateqrsr'),
(280,NULL,'User Logged In','2024-07-27 13:21:31','36','Login In'),
(281,NULL,'Product Updated','2024-07-27 13:24:56','36','Product'),
(282,NULL,'Product Updated','2024-07-27 13:25:47','36','Product'),
(283,NULL,'Product Approved','2024-07-27 13:28:32','36','Approval'),
(284,NULL,'Product Approved','2024-07-27 13:28:34','36','Approval'),
(285,NULL,'User Logged In','2024-07-27 13:30:40','39','Login In'),
(286,NULL,'New Product Added','2024-07-27 13:32:22','39','Product'),
(287,NULL,'User Logged In','2024-07-27 13:33:14','37','Login In'),
(288,NULL,'Product Approved','2024-07-27 13:33:21','37','Approval'),
(289,NULL,'Batch Added','2024-07-27 13:34:43','39','Batch'),
(290,NULL,'Batch Approved','2024-07-27 13:34:51','37','Approval'),
(291,NULL,'Alias Product Added','2024-07-27 13:35:23','39','Alias Product'),
(292,NULL,'Alias Product Approved','2024-07-27 13:35:28','37','Approval'),
(293,NULL,'Storage Condition Added','2024-07-27 13:35:54','39','Storage Condition'),
(294,NULL,'Storage Condition Approved','2024-07-27 13:35:59','37','Storage Condition'),
(295,NULL,'Storage Condition Added','2024-07-27 13:37:05','39','Storage Condition'),
(296,NULL,'Storage Condition Approved','2024-07-27 13:37:09','37','Storage Condition'),
(297,NULL,'Storage Condition Added','2024-07-27 13:39:06','39','Storage Condition'),
(298,NULL,'Storage Condition Approved','2024-07-27 13:39:12','37','Storage Condition'),
(299,NULL,'Product Updated','2024-07-27 13:40:15','39','Product'),
(300,NULL,'Product Approved','2024-07-27 13:40:26','37','Approval'),
(301,NULL,'Batch Updated','2024-07-27 13:41:13','39','Batch'),
(302,NULL,'Batch Approved','2024-07-27 13:41:21','37','Approval'),
(303,NULL,'Alias Product Added','2024-07-27 13:42:07','39','Alias Product'),
(304,NULL,'Alias Product Approved','2024-07-27 13:42:12','37','Approval'),
(305,NULL,'Storage Condition Added','2024-07-27 13:42:28','39','Storage Condition'),
(306,NULL,'Storage Condition Approved','2024-07-27 13:42:33','37','Storage Condition'),
(307,NULL,'QR generated','2024-07-27 13:43:06','39','Generateqr'),
(308,NULL,'Generateqr Approved','2024-07-27 13:43:14','37','Approval'),
(309,NULL,'Product Updated','2024-07-27 13:44:19','39','Product'),
(310,NULL,'Product Approved','2024-07-27 13:44:26','37','Approval'),
(311,NULL,'Batch Updated','2024-07-27 13:44:42','39','Batch'),
(312,NULL,'Batch Approved','2024-07-27 13:44:47','37','Approval'),
(313,NULL,'Alias Product Added','2024-07-27 13:45:04','39','Alias Product'),
(314,NULL,'Alias Product Approved','2024-07-27 13:45:09','37','Approval'),
(315,NULL,'QR generated','2024-07-27 13:45:47','39','Generateqr'),
(316,NULL,'Generateqr Approved','2024-07-27 13:45:54','37','Approval'),
(317,NULL,'New Product Added','2024-07-27 13:48:39','39','Product'),
(318,NULL,'Product Approved','2024-07-27 13:48:48','37','Approval'),
(319,NULL,'Batch Added','2024-07-27 13:50:15','39','Batch'),
(320,NULL,'Batch Approved','2024-07-27 13:50:22','37','Approval'),
(321,NULL,'Alias Product Added','2024-07-27 13:50:42','39','Alias Product'),
(322,NULL,'Alias Product Approved','2024-07-27 13:50:48','37','Approval'),
(323,NULL,'Storage Condition Added','2024-07-27 13:51:07','39','Storage Condition'),
(324,NULL,'Storage Condition Approved','2024-07-27 13:51:11','37','Storage Condition'),
(325,NULL,'QR generated','2024-07-27 13:51:49','39','Generateqr'),
(326,NULL,'Generateqr Approved','2024-07-27 13:51:58','37','Approval'),
(327,NULL,'Multiple Print Had Taken','2024-07-27 13:52:11','39','generateqrsr'),
(328,NULL,'New Product Added','2024-07-27 13:55:08','39','Product'),
(329,NULL,'Storage Condition Added','2024-07-27 13:56:16','39','Storage Condition'),
(330,NULL,'Storage Condition Approved','2024-07-27 13:56:21','37','Storage Condition'),
(331,NULL,'Product Approved','2024-07-27 13:56:23','37','Approval'),
(332,NULL,'Batch Added','2024-07-27 13:57:20','39','Batch'),
(333,NULL,'Batch Approved','2024-07-27 13:57:26','37','Approval'),
(334,NULL,'Alias Product Added','2024-07-27 13:57:54','39','Alias Product'),
(335,NULL,'Alias Product Approved','2024-07-27 13:58:00','37','Approval'),
(336,NULL,'Storage Condition Added','2024-07-27 13:58:43','39','Storage Condition'),
(337,NULL,'Storage Condition Approved','2024-07-27 13:58:51','37','Storage Condition'),
(338,NULL,'QR generated','2024-07-27 13:59:21','39','Generateqr'),
(339,NULL,'Generateqr Approved','2024-07-27 13:59:26','37','Approval'),
(340,NULL,'Multiple Print Had Taken','2024-07-27 13:59:47','39','generateqrsr'),
(341,NULL,'User Logged In','2024-07-29 11:26:57','36','Login In'),
(342,NULL,'User Logged In','2024-07-29 12:53:34','36','Login In'),
(343,NULL,'New Product Added','2024-07-29 12:54:30','36','Product'),
(344,NULL,'Product Approved','2024-07-29 12:54:39','36','Approval'),
(345,NULL,'Batch Added','2024-07-29 12:55:09','36','Batch'),
(346,NULL,'Batch Approved','2024-07-29 12:55:16','36','Approval'),
(347,NULL,'Alias Product Added','2024-07-29 12:55:30','36','Alias Product'),
(348,NULL,'Storage Condition Added','2024-07-29 12:55:58','36','Storage Condition'),
(349,NULL,'Storage Condition Approved','2024-07-29 12:56:04','36','Storage Condition'),
(350,NULL,'Alias Product Approved','2024-07-29 12:56:06','36','Approval'),
(351,NULL,'QR generated','2024-07-29 12:56:31','36','Generateqr'),
(352,NULL,'Generateqr Approved','2024-07-29 12:56:37','36','Approval'),
(353,NULL,'Single Print Had Taken','2024-07-29 12:56:50','36','generateqrsr'),
(354,NULL,'Multiple Print Had Taken','2024-07-29 12:57:09','36','generateqrsr'),
(355,NULL,'User Logged In','2024-07-29 13:00:42','36','Login In'),
(356,NULL,'User Logged In','2024-07-29 14:50:33','36','Login In'),
(357,NULL,'User Logged In','2024-07-29 14:52:54','36','Login In'),
(358,NULL,'User Logged In','2024-07-29 15:51:30','36','Login In'),
(359,NULL,'User Logged In','2024-07-30 11:28:08','36','Login In'),
(360,NULL,'New Product Added','2024-07-30 11:30:54','36','Product'),
(361,NULL,'User Logged In','2024-07-30 16:21:05','36','Login In'),
(362,NULL,'Product Approved','2024-07-30 16:21:40','36','Approval'),
(363,NULL,'Product Updated','2024-07-30 16:22:10','36','Product'),
(364,NULL,'Product Approved','2024-07-30 16:22:20','36','Approval'),
(365,NULL,'New Product Added','2024-07-30 16:33:36','36','Product'),
(366,NULL,'Product Updated','2024-07-30 16:33:52','36','Product'),
(367,NULL,'Product Deleted','2024-07-30 16:33:59','36','Product'),
(368,NULL,'Product Delete Request Approved','2024-07-30 16:34:07','36','Approval'),
(369,NULL,'User Logged In','2024-07-30 17:29:44','36','Login In'),
(370,NULL,'User Logged In','2024-07-30 18:21:33','39','Login In'),
(371,NULL,'User Logged In','2024-07-30 18:22:25','37','Login In'),
(372,NULL,'New Product Added','2024-07-30 18:25:03','39','Product'),
(373,NULL,'Product Approved','2024-07-30 18:25:13','37','Approval'),
(374,NULL,'Batch Added','2024-07-30 18:26:39','39','Batch'),
(375,NULL,'Batch Approved','2024-07-30 18:26:45','37','Approval'),
(376,NULL,'Alias Product Added','2024-07-30 18:27:04','39','Alias Product'),
(377,NULL,'Alias Product Approved','2024-07-30 18:27:11','37','Approval'),
(378,NULL,'Storage Condition Added','2024-07-30 18:27:35','39','Storage Condition'),
(379,NULL,'Storage Condition Approved','2024-07-30 18:27:39','37','Storage Condition'),
(380,NULL,'QR generated','2024-07-30 18:28:38','39','Generateqr'),
(381,NULL,'Generateqr Approved','2024-07-30 18:28:48','37','Approval'),
(382,NULL,'Single Print Had Taken','2024-07-30 18:29:10','39','generateqrsr'),
(383,NULL,'New Product Added','2024-07-30 18:34:39','39','Product'),
(384,NULL,'Product Approved','2024-07-30 18:35:03','37','Approval'),
(385,NULL,'New Product Added','2024-07-30 18:36:44','39','Product'),
(386,NULL,'Product Approved','2024-07-30 18:36:51','37','Approval'),
(387,NULL,'Batch Added','2024-07-30 18:37:46','39','Batch'),
(388,NULL,'Batch Approved','2024-07-30 18:37:54','37','Approval'),
(389,NULL,'Alias Product Added','2024-07-30 18:38:08','39','Alias Product'),
(390,NULL,'Alias Product Approved','2024-07-30 18:38:23','37','Approval'),
(391,NULL,'Storage Condition Added','2024-07-30 18:38:55','39','Storage Condition'),
(392,NULL,'Storage Condition Approved','2024-07-30 18:39:02','37','Storage Condition'),
(393,NULL,'QR generated','2024-07-30 18:39:31','39','Generateqr'),
(394,NULL,'Generateqr Approved','2024-07-30 18:39:44','37','Approval'),
(395,NULL,'New Product Added','2024-07-30 18:41:28','39','Product'),
(396,NULL,'Product Approved','2024-07-30 18:41:36','37','Approval'),
(397,NULL,'Alias Product Added','2024-07-30 18:42:09','39','Alias Product'),
(398,NULL,'Alias Product Approved','2024-07-30 18:42:15','37','Approval'),
(399,NULL,'Batch Added','2024-07-30 18:43:08','39','Batch'),
(400,NULL,'Batch Approved','2024-07-30 18:43:13','37','Approval'),
(401,NULL,'Storage Condition Added','2024-07-30 18:43:39','39','Storage Condition'),
(402,NULL,'Storage Condition Approved','2024-07-30 18:43:44','37','Storage Condition'),
(403,NULL,'QR generated','2024-07-30 18:44:48','39','Generateqr'),
(404,NULL,'Generateqr Approved','2024-07-30 18:45:02','37','Approval'),
(405,NULL,'Single Print Had Taken','2024-07-30 18:45:18','39','generateqrsr'),
(406,NULL,'Single Print Had Taken','2024-07-30 18:45:55','39','generateqrsr'),
(407,NULL,'User Logged In','2024-07-30 19:15:09','36','Login In'),
(408,NULL,'User Logged In','2024-07-30 19:20:45','36','Login In'),
(409,NULL,'User Logged In','2024-07-31 11:57:28','36','Login In'),
(410,NULL,'User Logged In','2024-07-31 11:59:40','36','Login In'),
(411,NULL,'Single Print Had Taken','2024-07-31 12:13:18','36','generateqrsr'),
(412,NULL,'Single Print Had Taken','2024-07-31 12:20:09','36','generateqrsr'),
(413,NULL,'User Logged In','2024-07-31 12:43:37','36','Login In'),
(414,NULL,'User Logged In','2024-07-31 15:22:24','36','Login In'),
(415,NULL,'User Logged In','2024-07-31 17:04:03','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=7 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','Drug Lic. No. (25) AMD/3/96','27AAACL2799Q1ZO','Plot No. D-2, MIDC',NULL,'AMRAVATI-444 607. (Maharashtra)','2024-07-10 12:32:21',NULL,'39','1','1','0','2024-07-10 15:20:56',NULL),
(2,'LAXACHEM ORGANICS PVT LTD','LAXACHEM ORGANICS PVT LTD','Drug Lic. No. (25) AMD/3/96','27AAACL2799Q1ZO','Plot No. D-2, MIDC',NULL,'AMRAVATI-444 607. (Maharashtra)','2024-07-10 12:32:26',NULL,'39','1','1','0','2024-07-10 15:21:08',NULL),
(3,'LAXACHEM ORGANICS PVT LTD','LAXACHEM ORGANICS PVT LTD','Drug Lic. No. (25) AMD/3/96','27AAACL2799Q1ZO','Plot No. D-2, MIDC',NULL,'AMRAVATI-444 607. (Maharashtra)','2024-07-10 12:33:08',NULL,'39','1','1','0','2024-07-10 15:21:31',NULL),
(4,'LAXACHEM ORGANICS PVT LTD','LAXACHEM ORGANICS PVT LTD','Drug Lic. No. (25) AMD/3/96','27AAACL2799Q1ZO','Plot No. D-2, MIDC',NULL,'AMRAVATI-444 607. (Maharashtra)','2024-07-10 12:33:33',NULL,'39','1','1','0','2024-07-10 15:24:19',NULL),
(5,'LAXACHEM ORGANICS PVT LTD','LAXACHEM ORGANICS PVT LTD','Drug Lic. No. (25) AMD/3/96','27AAACL2799Q1ZO','Plot No. D-2, MIDC',NULL,'AMRAVATI-444 607. (Maharashtra)','2024-07-10 12:33:41',NULL,'39','1','1','0','2024-07-10 15:56:49',NULL),
(6,'LAXACHEM ORGANICS PVT LTD\t','LAXACHEM ORGANICS PVT LTD','Drug Lic. No. (25) AMD/3/96','27AAACL2799Q1ZO','Plot No. D-2, MIDC',NULL,'\tAMRAVATI-444 607. (Maharashtra)','2024-07-10 15:32:00',NULL,'39','0','1','0','2024-07-10 15:57:09',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=130 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','1','manufacture','1','0','2024-07-10 12:52:40','2024-07-10 15:20:56',NULL,NULL,'LAXACHEM ORGANICS PVT LTD','Delete','1','39'),
(5,'37','2','manufacture','1','0','2024-07-10 12:52:43','2024-07-10 15:21:08',NULL,NULL,'LAXACHEM ORGANICS PVT LTD','Delete','1','39'),
(6,'37','3','manufacture','1','0','2024-07-10 12:52:45','2024-07-10 15:21:31',NULL,NULL,'LAXACHEM ORGANICS PVT LTD','Delete','1','39'),
(7,'37','4','manufacture','1','0','2024-07-10 12:52:47','2024-07-10 15:24:19',NULL,NULL,'LAXACHEM ORGANICS PVT LTD','Delete','1','39'),
(8,'37','1','pbatch','1','0','2024-07-10 15:22:54','2024-07-10 15:56:14',NULL,NULL,'PG-10724','New Item','0',NULL),
(9,'37','2','pbatch','1','0','2024-07-10 15:24:31','2024-07-10 15:56:25',NULL,NULL,'DS-30724','New Item','0',NULL),
(10,'37','3','pbatch','1','0','2024-07-10 15:25:36','2024-07-10 15:56:37',NULL,NULL,'DP-10624','New Item','0',NULL),
(11,'37','5','manufacture','1','0','2024-07-10 15:31:55','2024-07-10 15:56:48',NULL,NULL,'LAXACHEM ORGANICS PVT LTD','Delete','1','39'),
(12,'37','6','manufacture','1','0','2024-07-10 15:32:00','2024-07-10 15:57:09',NULL,NULL,'LAXACHEM ORGANICS PVT LTD\t','New Item','0','39'),
(13,'37','1','addproduct','1','0','2024-07-10 15:58:41','2024-07-10 16:08:07',NULL,NULL,'Dioctyl Sodium Sulfosuccinate','New Item','0','39'),
(14,'37','2','addproduct','1','0','2024-07-10 15:59:09','2024-07-10 16:08:16',NULL,NULL,'    ','New Item','0','39'),
(15,'37','3','addproduct','1','0','2024-07-10 16:00:03','2024-07-10 16:08:25',NULL,NULL,' ','New Item','0','39'),
(16,'37','1','storagecondition','1','0','2024-07-10 16:15:55','2024-07-10 16:55:40',NULL,NULL,'Store protect from moisture.','New Item','0','39'),
(17,'37','2','storagecondition','1','0','2024-07-10 16:16:39','2024-07-10 16:55:47',NULL,NULL,'Preserve in well closed container','New Item','0','39'),
(18,'37','3','storagecondition','1','0','2024-07-10 16:17:10','2024-07-10 16:58:23',NULL,NULL,'Store protect from light, in non-metallic container','New Item','0','39'),
(19,'38','1','customer','1','0','2024-07-10 16:22:58','2024-07-11 13:30:45',NULL,NULL,'DUBROW LLC','New Item','0','39'),
(20,'37','1','generateqr','1','0','2024-07-10 17:04:15','2024-07-11 11:58:49',NULL,NULL,'LAX/0724/001','New Item',NULL,'39'),
(21,'37','2','generateqr','1','0','2024-07-10 17:06:45','2024-07-11 11:59:00',NULL,NULL,'LAX/0724/002','New Item',NULL,'39'),
(22,'37','3','generateqr','1','0','2024-07-10 17:07:56','2024-07-11 11:59:14',NULL,NULL,'LAX/0724/003','New Item',NULL,'39'),
(25,'38','2','customer','1','0','2024-07-11 13:27:38','2024-07-11 13:30:41',NULL,NULL,'Festiva Pharma','New Item','0','39'),
(26,'37','4','addproduct','1','0','2024-07-11 13:31:51','2024-07-11 13:32:11',NULL,NULL,'HEMIHYDRATE','New Item','0','39'),
(27,'37','4','storagecondition','1','0','2024-07-11 13:32:47','2024-07-11 13:33:10',NULL,NULL,'Store protect from moisture at temperature not exceeding 30° C','New Item','0','39'),
(28,'37','4','generateqr','1','0','2024-07-11 13:33:56','2024-07-11 13:34:08',NULL,NULL,'LAX/0724/004','New Item',NULL,'39'),
(29,'37','5','addproduct','1','0','2024-07-11 13:55:55','2024-07-11 13:56:06',NULL,NULL,'CHLORBUTOL','New Item','0','39'),
(30,'37','5','generateqr','1','0','2024-07-11 13:57:03','2024-07-11 13:57:14',NULL,NULL,'LAX/0724/005','New Item',NULL,'39'),
(31,'37','4','product','1','0','2024-07-11 14:04:38','2024-07-11 14:04:50',NULL,NULL,'CHLOROBUTANOL','Edit','0','39'),
(32,'37','4','pbatch','1','0','2024-07-11 14:05:54','2024-07-11 14:06:03',NULL,NULL,'CH-10724','Edit','0','39'),
(33,'37','6','addproduct','1','0','2024-07-11 14:06:36','2024-07-11 14:06:44',NULL,NULL,'CHLORBUTOL','New Item','0','39'),
(34,'37','5','storagecondition','1','0','2024-07-11 14:07:42','2024-07-11 14:07:48',NULL,NULL,'Store protect from moisture at temperature not exceeding 30° C','New Item','0','39'),
(35,'37','6','generateqr','1','0','2024-07-11 14:08:24','2024-07-11 14:08:35',NULL,NULL,'LAX/0724/006','New Item',NULL,'39'),
(36,'38','1','dispatch','1','0','2024-07-11 14:22:28','2024-07-11 14:23:17',NULL,NULL,'LAX/0724/006','New Item','0','39'),
(37,'38','1','returnstock','1','0','2024-07-11 14:25:37','2024-07-11 14:26:14',NULL,NULL,'LAX/0724/006','New Item','0','39'),
(39,'37','7','generateqr','1','0','2024-07-11 16:36:48','2024-07-11 16:37:01',NULL,NULL,'LAX/0724/007','New Item',NULL,'39'),
(40,'37','6','storagecondition','1','0','2024-07-11 16:39:31','2024-07-11 16:39:42',NULL,NULL,'Preserve in well closed container                                                   ','Edit','0','39'),
(41,'37','8','generateqr','1','0','2024-07-11 16:40:24','2024-07-11 16:40:35',NULL,NULL,'LAX/0724/008','New Item',NULL,'39'),
(42,'37','9','generateqr','1','0','2024-07-11 17:45:44','2024-07-11 17:53:25',NULL,NULL,'LAX/0724/009','New Item',NULL,'39'),
(43,'37','10','generateqr','1','0','2024-07-11 17:54:05','2024-07-11 17:54:15',NULL,NULL,'LAX/0724/010','New Item',NULL,'39'),
(44,'37','5','product','1','0','2024-07-17 11:26:15','2024-07-17 11:26:24',NULL,NULL,'DOCUSATE SODIUM 85% POWDER','New Item','0','39'),
(45,'37','5','pbatch','1','0','2024-07-17 11:27:15','2024-07-17 11:27:22',NULL,NULL,'DP-20724','New Item','0','39'),
(46,'37','7','addproduct','1','0','2024-07-17 11:27:52','2024-07-17 11:28:00',NULL,NULL,'DOCUSATE SODIUM 85% POWDER\t','New Item','0','39'),
(47,'37','7','storagecondition','1','0','2024-07-17 11:28:21','2024-07-17 11:28:26',NULL,NULL,'Preserve in well closed container','New Item','0','39'),
(48,'37','11','generateqr','1','0','2024-07-17 11:29:08','2024-07-17 11:29:16',NULL,NULL,'LAX/0724/011','New Item',NULL,'39'),
(49,'37','2','product','1','0','2024-07-17 11:30:29','2024-07-17 11:30:37',NULL,NULL,'DOCUSATE SODIUM 85% POWDER','Delete','1','39'),
(50,'37','6','pbatch','1','0','2024-07-17 11:32:29','2024-07-17 11:32:34',NULL,NULL,'DP-30724','New Item','0','39'),
(51,'37','8','addproduct','1','0','2024-07-17 11:33:02','2024-07-17 11:33:07',NULL,NULL,'DOCUSATE SODIUM 85%','New Item','0','39'),
(52,'37','8','storagecondition','1','0','2024-07-17 11:33:25','2024-07-17 11:33:31',NULL,NULL,'Preserve in well closed container','New Item','0','39'),
(53,'37','12','generateqr','1','0','2024-07-17 11:34:09','2024-07-17 11:34:14',NULL,NULL,'LAX/0724/012','New Item',NULL,'39'),
(55,'37','7','pbatch','1','0','2024-07-19 18:17:39','2024-07-19 18:17:49',NULL,NULL,'FRT-20524','New Item','0','39'),
(56,'37','9','addproduct','1','0','2024-07-19 18:18:19','2024-07-19 18:18:25',NULL,NULL,'Sodium salt of 4-Chloro-2-[(furan-2-ylmethyl)amino]5-sulfamoylbenzoic acid','New Item','0','39'),
(57,'37','9','storagecondition','1','0','2024-07-19 18:19:17','2024-07-19 18:19:24',NULL,NULL,'-','New Item','0','39'),
(58,'37','13','generateqr','1','0','2024-07-19 18:20:22','2024-07-19 18:20:32',NULL,NULL,'LAX/0724/013','New Item',NULL,'39'),
(61,'37','14','generateqr','1','0','2024-07-24 16:50:08','2024-07-24 16:50:18',NULL,NULL,'LAX/0724/014','New Item',NULL,'39'),
(62,'37','6','product','1','0','2024-07-24 17:07:17','2024-07-24 17:07:27',NULL,NULL,'Sodium salt of 4-Chloro-2-[(furan-2-ylmethyl)amino]5-sulfamoylbenzoic acid','Edit','0','39'),
(63,'37','8','pbatch','1','0','2024-07-24 17:08:24','2024-07-24 17:08:30',NULL,NULL,'FRT-10724','New Item','0','39'),
(64,'37','10','addproduct','1','0','2024-07-24 17:08:58','2024-07-24 17:09:03',NULL,NULL,'Sodium salt of 4-Chloro-2-[(furan-2-ylmethyl)amino]5-sulfamoylbenzoic acid\t','New Item','0','39'),
(65,'37','10','storagecondition','1','0','2024-07-24 17:09:28','2024-07-24 17:09:32',NULL,NULL,'NA','New Item','0','39'),
(66,'37','15','generateqr','1','0','2024-07-24 17:10:22','2024-07-24 17:10:28',NULL,NULL,'LAX/0724/015','New Item',NULL,'39'),
(67,'36','7','product','1','0','2024-07-25 12:29:07','2024-07-25 12:29:16',NULL,NULL,'LAXA PA','New Item','0','36'),
(68,'36','9','pbatch','1','0','2024-07-25 12:29:41','2024-07-25 12:29:50',NULL,NULL,'LAXA PA B1','New Item','0','36'),
(69,'36','11','addproduct','1','0','2024-07-25 12:30:05','2024-07-25 12:30:12',NULL,NULL,'LAXA PA ALIAS','New Item','0','36'),
(70,'36','11','storagecondition','1','0','2024-07-25 12:30:31','2024-07-25 12:31:17',NULL,NULL,'LAXA PA IP GRADE STORAGE CONDITION ','New Item','0','36'),
(71,'36','12','storagecondition','1','0','2024-07-25 12:30:50','2024-07-25 12:31:15',NULL,NULL,'LAXA PA BP GRADE STORAGE CONDITION','New Item','0','36'),
(72,'36','13','storagecondition','1','0','2024-07-25 12:31:08','2024-07-25 12:31:13',NULL,NULL,'LAXA PA TECHNCAL GRADE STORAGE CONDITION','New Item','0','36'),
(73,'36','16','generateqr','1','0','2024-07-25 12:31:53','2024-07-25 12:32:01',NULL,NULL,'LAX/0724/016','New Item',NULL,'36'),
(74,'36','17','generateqr','1','0','2024-07-25 12:33:33','2024-07-25 12:33:42',NULL,NULL,'LAX/0724/017','New Item',NULL,'36'),
(75,'36','18','generateqr','1','0','2024-07-27 11:21:48','2024-07-27 11:22:07',NULL,NULL,'LAX/0724/018','New Item',NULL,'36'),
(76,'36','3','product','1','0','2024-07-27 13:24:56','2024-07-27 13:28:34',NULL,NULL,'PROPYL GALLATE ','Edit','0','36'),
(77,'36','1','product','1','0','2024-07-27 13:25:47','2024-07-27 13:28:32',NULL,NULL,'DOCUSATE SODIUM','Edit','0','36'),
(80,'37','12','addproduct','1','0','2024-07-27 13:35:23','2024-07-27 13:35:28',NULL,NULL,'CHLORBUTOL','New Item','0','39'),
(81,'37','14','storagecondition','1','0','2024-07-27 13:35:54','2024-07-27 13:35:59',NULL,NULL,'Store protect from moisture at temperature not exceeding 30° C','New Item','0','39'),
(82,'37','15','storagecondition','1','0','2024-07-27 13:37:05','2024-07-27 13:37:09',NULL,NULL,'Store protect from moisture at temperature not exceeding 30° C','New Item','0','39'),
(83,'37','16','storagecondition','1','0','2024-07-27 13:39:06','2024-07-27 13:39:12',NULL,NULL,'Store protect from moisture at temperature not exceeding 30° C','New Item','0','39'),
(86,'37','13','addproduct','1','0','2024-07-27 13:42:07','2024-07-27 13:42:12',NULL,NULL,'CHLORBUTOL','New Item','0','39'),
(87,'37','17','storagecondition','1','0','2024-07-27 13:42:28','2024-07-27 13:42:33',NULL,NULL,'Store protect from moisture at temperature not exceeding 30° C','New Item','0','39'),
(88,'37','19','generateqr','1','0','2024-07-27 13:43:06','2024-07-27 13:43:14',NULL,NULL,'LAX/0724/019','New Item',NULL,'39'),
(89,'37','8','product','1','0','2024-07-27 13:44:19','2024-07-27 13:44:26',NULL,NULL,'CHLOROBUTANOL.','Edit','0','39'),
(90,'37','10','pbatch','1','0','2024-07-27 13:44:43','2024-07-27 13:44:47',NULL,NULL,'CH-10824','Edit','0','39'),
(91,'37','14','addproduct','1','0','2024-07-27 13:45:04','2024-07-27 13:45:09',NULL,NULL,'HEMIHYDRATE','New Item','0','39'),
(92,'37','20','generateqr','1','0','2024-07-27 13:45:48','2024-07-27 13:45:54',NULL,NULL,'LAX/0724/020','New Item',NULL,'39'),
(93,'37','9','product','1','0','2024-07-27 13:48:40','2024-07-27 13:48:48',NULL,NULL,'CHLOROBUTANOL..','New Item','0','39'),
(94,'37','11','pbatch','1','0','2024-07-27 13:50:16','2024-07-27 13:50:22',NULL,NULL,'CH-20824','New Item','0','39'),
(95,'37','15','addproduct','1','0','2024-07-27 13:50:43','2024-07-27 13:50:48',NULL,NULL,'CHLORBUTOL','New Item','0','39'),
(96,'37','18','storagecondition','1','0','2024-07-27 13:51:07','2024-07-27 13:51:11',NULL,NULL,'Store protect from moisture at temperature not exceeding 30° C..','New Item','0','39'),
(97,'37','21','generateqr','1','0','2024-07-27 13:51:50','2024-07-27 13:51:58',NULL,NULL,'LAX/0724/021','New Item',NULL,'39'),
(98,'37','10','product','1','0','2024-07-27 13:55:09','2024-07-27 13:56:23',NULL,NULL,'PROPYL GALLATE','New Item','0','39'),
(99,'37','19','storagecondition','1','0','2024-07-27 13:56:16','2024-07-27 13:56:21',NULL,NULL,'Store protect from light, in non-metallic container','New Item','0','39'),
(100,'37','12','pbatch','1','0','2024-07-27 13:57:20','2024-07-27 13:57:26',NULL,NULL,'PG-20824','New Item','0','39'),
(101,'37','16','addproduct','1','0','2024-07-27 13:57:54','2024-07-27 13:58:00',NULL,NULL,'PROPYL GALLATE','New Item','0','39'),
(102,'37','20','storagecondition','1','0','2024-07-27 13:58:43','2024-07-27 13:58:51',NULL,NULL,'Store protect from light, in non-metallic container','New Item','0','39'),
(103,'37','22','generateqr','1','0','2024-07-27 13:59:21','2024-07-27 13:59:26',NULL,NULL,'LAX/0724/022','New Item',NULL,'39'),
(104,'36','11','product','1','0','2024-07-29 12:54:30','2024-07-29 12:54:39',NULL,NULL,'Propyl Gallate 1','New Item','0','36'),
(105,'36','13','pbatch','1','0','2024-07-29 12:55:10','2024-07-29 12:55:16',NULL,NULL,'PPB1','New Item','0','36'),
(106,'36','17','addproduct','1','0','2024-07-29 12:55:31','2024-07-29 12:56:06',NULL,NULL,'PROPYL ALIAS','New Item','0','36'),
(107,'36','21','storagecondition','1','0','2024-07-29 12:55:58','2024-07-29 12:56:04',NULL,NULL,'STORAGE CONDITION IS NOT AVAILABLE FOR THIS GRADE','New Item','0','36'),
(108,'36','23','generateqr','1','0','2024-07-29 12:56:31','2024-07-29 12:56:37',NULL,NULL,'LAX/0724/023','New Item',NULL,'36'),
(110,'36','12','product','1','0','2024-07-30 16:22:11','2024-07-30 16:22:20',NULL,NULL,'test','Edit','0','36'),
(113,'36','13','product','1','0','2024-07-30 16:33:59','2024-07-30 16:34:07',NULL,NULL,'test1','Delete','1','36'),
(114,'37','14','product','1','0','2024-07-30 18:25:03','2024-07-30 18:25:13',NULL,NULL,'CHLOROBUTANOL,','New Item','0','39'),
(115,'37','14','pbatch','1','0','2024-07-30 18:26:40','2024-07-30 18:26:45',NULL,NULL,'CH-10824','New Item','0','39'),
(116,'37','18','addproduct','1','0','2024-07-30 18:27:04','2024-07-30 18:27:11',NULL,NULL,'CHLORBUTOL','New Item','0','39'),
(117,'37','22','storagecondition','1','0','2024-07-30 18:27:35','2024-07-30 18:27:39',NULL,NULL,'Store protect from light, in non-metallic container','New Item','0','39'),
(118,'37','24','generateqr','1','0','2024-07-30 18:28:39','2024-07-30 18:28:48',NULL,NULL,'LAX/0724/024','New Item',NULL,'39'),
(119,'37','15','product','1','0','2024-07-30 18:34:39','2024-07-30 18:35:03',NULL,NULL,'PROPYL GALLATE','New Item','0','39'),
(120,'37','16','product','1','0','2024-07-30 18:36:44','2024-07-30 18:36:51',NULL,NULL,'Sodium salt of 4-Chloro-2-[(furan-2-ylmethyl)amino]5-sulfamoylbenzoic acid\t','New Item','0','39'),
(121,'37','15','pbatch','1','0','2024-07-30 18:37:46','2024-07-30 18:37:54',NULL,NULL,'FRT-10824','New Item','0','39'),
(122,'37','19','addproduct','1','0','2024-07-30 18:38:08','2024-07-30 18:38:23',NULL,NULL,'N/A','New Item','0','39'),
(123,'37','23','storagecondition','1','0','2024-07-30 18:38:55','2024-07-30 18:39:02',NULL,NULL,'N/A','New Item','0','39'),
(124,'37','25','generateqr','1','0','2024-07-30 18:39:32','2024-07-30 18:39:44',NULL,NULL,'LAX/0724/025','New Item',NULL,'39'),
(125,'37','17','product','1','0','2024-07-30 18:41:28','2024-07-30 18:41:36',NULL,NULL,'Sodium salt of 4-Chloro-2-[(furan-2-ylmethyl)amino]5-sulfamoylbenzoic acid','New Item','0','39'),
(126,'37','20','addproduct','1','0','2024-07-30 18:42:10','2024-07-30 18:42:15',NULL,NULL,'Sodium salt of 4-Chloro-2-[(furan-2-ylmethyl)amino]5-sulfamoylbenzoic acid','New Item','0','39'),
(127,'37','16','pbatch','1','0','2024-07-30 18:43:08','2024-07-30 18:43:13',NULL,NULL,'FRT-10124','New Item','0','39'),
(128,'37','24','storagecondition','1','0','2024-07-30 18:43:39','2024-07-30 18:43:44',NULL,NULL,'N/A','New Item','0','39'),
(129,'37','26','generateqr','1','0','2024-07-30 18:44:49','2024-07-30 18:45:02',NULL,NULL,'LAX/0724/026','New Item',NULL,'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=17 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,'PG-10724','3','500','','2024-07-01 00:00:00','2029-06-01 00:00:00','','','IP,BP','2024-07-10 15:22:53',NULL,'39','0','1','0','2024-07-10 15:56:14',NULL),
(2,'DS-30724','1','500','','2024-07-01 00:00:00','2029-06-01 00:00:00','','','IP,BP,EP,USP','2024-07-10 15:24:30',NULL,'39','0','1','0','2024-07-10 15:56:26',NULL),
(3,'DP-10624','2','500','','2024-06-01 00:00:00','2029-05-01 00:00:00','','','USP','2024-07-10 15:25:35',NULL,'39','0','1','0','2024-07-10 15:56:37',NULL),
(4,'CH-10724','4','500','','2024-07-01 00:00:00','2029-06-01 00:00:00','','','IP,BP,EP,USP','2024-07-11 14:05:54','2024-07-11 14:05:54','39','0','1','0','2024-07-11 14:06:03',NULL),
(5,'DP-20724','2','500','','2024-07-01 00:00:00','2029-06-01 00:00:00','','','USP','2024-07-17 11:27:14',NULL,'39','0','1','0','2024-07-17 11:27:22',NULL),
(6,'DP-30724','5','500','','2024-07-01 00:00:00','2029-06-01 00:00:00','','','USP','2024-07-17 11:32:29',NULL,'39','0','1','0','2024-07-17 11:32:34',NULL),
(7,'FRT-20524','6','400','','2024-05-01 00:00:00','2029-04-01 00:00:00','','','IP','2024-07-19 18:17:39',NULL,'39','0','1','0','2024-07-19 18:17:49',NULL),
(8,'FRT-10724','6','240','','2024-07-01 00:00:00','2029-06-01 00:00:00','','','IP','2024-07-24 17:08:23',NULL,'39','0','1','0','2024-07-24 17:08:30',NULL),
(9,'LAXA PA B1','7','1000','','2024-07-01 00:00:00','2027-06-01 00:00:00','','','IP,BP','2024-07-25 12:29:41',NULL,'36','0','1','0','2024-07-25 12:29:50',NULL),
(10,'CH-10824','8','500','','2024-08-01 00:00:00','2029-07-01 00:00:00','','','IP,BP,EP,USP','2024-07-27 13:44:43','2024-07-27 13:44:43','39','0','1','0','2024-07-27 13:44:47',NULL),
(11,'CH-20824','9','500','','2024-08-01 00:00:00','2029-07-01 00:00:00','','','IP,BP,EP,USP','2024-07-27 13:50:15',NULL,'39','0','1','0','2024-07-27 13:50:22',NULL),
(12,'PG-20824','10','500','','2024-08-01 00:00:00','2029-07-01 00:00:00','','','IP,BP','2024-07-27 13:57:20',NULL,'39','0','1','0','2024-07-27 13:57:26',NULL),
(13,'PPB1','11','1500','','2024-07-01 00:00:00','2026-06-01 00:00:00','','','TECHNICAL','2024-07-29 12:55:09',NULL,'36','0','1','0','2024-07-29 12:55:16',NULL),
(14,'CH-10824','14','500','','2024-08-01 00:00:00','2029-07-01 00:00:00','','','IP,BP,EP,USP','2024-07-30 18:26:39',NULL,'39','0','1','0','2024-07-30 18:26:45',NULL),
(15,'FRT-10824','16','240','','2024-08-01 00:00:00','2029-06-01 00:00:00','','','TECHNICAL','2024-07-30 18:37:46',NULL,'39','0','1','0','2024-07-30 18:37:54',NULL),
(16,'FRT-10124','17','240','','2024-01-01 00:00:00','2028-12-01 00:00:00','','','TECHNICAL','2024-07-30 18:43:07',NULL,'39','0','1','0','2024-07-30 18:43:13',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=18 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,'DOCUSATE SODIUM','','8906181640023','','','In an air tight container','IP,BP,EP,USP','DS','5,10,15,20,25',NULL,'2024-07-10 12:41:05','2024-07-27 13:25:47','36','C20H37NaO7S','444.6','0','1','0','2024-07-27 13:28:32',NULL),
(2,'DOCUSATE SODIUM 85% POWDER','','8906181640030','','','Preserve in well closed container','USP','DP','5,10,15,20,25','KG','2024-07-10 12:46:44',NULL,'39','   ','   ','1','1','0','2024-07-17 11:30:37',NULL),
(3,'PROPYL GALLATE ','','8906181640047','','','Store protect from light, in non-metallic container','IP,BP','PG','1,5,10,15,20,25',NULL,'2024-07-10 12:50:16','2024-07-27 13:24:56','36','C10H12O5','212.2','0','1','0','2024-07-27 13:28:34',NULL),
(4,'CHLOROBUTANOL','','8906181640009','6','LAXACHEM ORGANICS PVT LTD','Store protect from moisture at temperature not exceeding 30° C','IP,BP,EP,USP','HEMIHYDRATE','5,10,15,20,25','KGS','2024-07-11 13:23:20','2024-07-11 14:04:38','39','C4H7CL3O,1/2H2O','186.5','0','1','0','2024-07-11 14:04:50',NULL),
(5,'DOCUSATE SODIUM 85% POWDER','','8906181640030','6','LAXACHEM ORGANICS PVT LTD','Preserve in well closed container','USP','1234567994','5,10,15,20,25','KGS','2024-07-17 11:26:15',NULL,'39','123456789','213.8','0','1','0','2024-07-17 11:26:24',NULL),
(6,'Sodium salt of 4-Chloro-2-[(furan-2-ylmethyl)amino]5-sulfamoylbenzoic acid','','NA','6','LAXACHEM ORGANICS PVT LTD','NA','IP','NA','5,10,15,20,25','KGS','2024-07-19 18:15:58','2024-07-24 17:07:17','39','C20H11CIN2O5S','330.7','0','1','0','2024-07-24 17:07:27',NULL),
(7,'LAXA PA','','1255244725','6','LAXACHEM ORGANICS PVT LTD','','IP,BP','NA','12,15,25','KGS','2024-07-25 12:29:07',NULL,'36','H5F6H7','12.05','0','1','0','2024-07-25 12:29:16',NULL),
(8,'CHLOROBUTANOL.','','8906181640009','6','LAXACHEM ORGANICS PVT LTD','Store protect from moisture at temperature not exceeding 30° C','IP,BP,EP,USP','CH','5,10,15,20,25','KGS','2024-07-27 13:32:23','2024-07-27 13:44:19','39','C4H7CL3O,1/2H2O','186.5','0','1','0','2024-07-27 13:44:26',NULL),
(9,'CHLOROBUTANOL..','','8906181640009','6','LAXACHEM ORGANICS PVT LTD','Store protect from moisture at temperature not exceeding 30° C','IP,BP,EP,USP','HEMIHYDRATE','5,10,15,20,25','KGS','2024-07-27 13:48:40',NULL,'39','C4H7CL3O,1/2H2O','186.5','0','1','0','2024-07-27 13:48:48',NULL),
(10,'PROPYL GALLATE','','8906181640047','6','LAXACHEM ORGANICS PVT LTD','Store protect from light, in non-metallic container','IP,BP','-','5,10,15,20,25','KGS','2024-07-27 13:55:09',NULL,'39','C10H12O5','212.2','0','1','0','2024-07-27 13:56:23',NULL),
(11,'Propyl Gallate 1','','54998652','6','LAXACHEM ORGANICS PVT LTD','','TECHNICAL','PP1','15','KGS','2024-07-29 12:54:30',NULL,'36','H4G8D7','152.25','0','1','0','2024-07-29 12:54:39',NULL),
(12,'test','NOT GIVEN','1234','6','LAXACHEM ORGANICS PVT LTD','','IP','NA','7','KGS','2024-07-30 11:30:54','2024-07-30 16:22:11','36','147','111','0','1','0','2024-07-30 16:22:20',NULL),
(13,'test1','not igven','45465215648','6','LAXACHEM ORGANICS PVT LTD','','BP','test1 sub','15,12','KGS','2024-07-30 16:33:37','2024-07-30 16:33:53','36','h7j8j7','20.25','1','1','0','2024-07-30 16:34:07',NULL),
(14,'CHLOROBUTANOL,','','8906181640009','6','LAXACHEM ORGANICS PVT LTD','Store protect from moisture at temperature not exceeding 30° C','IP,BP,EP,USP','HEMIHYDRATE','5,10,15,20,25','KGS','2024-07-30 18:25:03',NULL,'39','C4H7CL3O,1/2H2O','186.5','0','1','0','2024-07-30 18:25:13',NULL),
(15,'PROPYL GALLATE','','N/A','6','LAXACHEM ORGANICS PVT LTD','Store protect from light, in non-metallic container','TECHNICAL','N/A','5,10,15,20,25','KGS','2024-07-30 18:34:39',NULL,'39','C10H12O5','212.2','0','1','0','2024-07-30 18:35:03',NULL),
(16,'Sodium salt of 4-Chloro-2-[(furan-2-ylmethyl)amino]5-sulfamoylbenzoic acid\t','','N/A','6','LAXACHEM ORGANICS PVT LTD','N/A','TECHNICAL','N/A','5,10,15,20,25','KGS','2024-07-30 18:36:44',NULL,'39','C20H11CIN2O5S','212.2','0','1','0','2024-07-30 18:36:51',NULL),
(17,'Sodium salt of 4-Chloro-2-[(furan-2-ylmethyl)amino]5-sulfamoylbenzoic acid','','N/A','6','LAXACHEM ORGANICS PVT LTD','N/A','TECHNICAL','N/A','5,10,15,20,25','KGS','2024-07-30 18:41:28',NULL,'39','C20H11CIN2O5S','212.2','0','1','0','2024-07-30 18:41:36',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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table returnstock
-- 

/*!40000 ALTER TABLE `returnstock` DISABLE KEYS */;
INSERT INTO `returnstock`(`id`,`lotno`,`remark`,`dor`,`created`,`updated`,`userid`,`status`,`deletestatus`,`rtime`,`retaprstatus`,`retrejstatus`,`retaprtime`,`retrejtime`) VALUES
(1,'6','YELLOW MATERIAL','2024-07-09 00:00:00','2024-07-11 14:25:36',NULL,'39','0','0','2024-07-11 14:25:36','1','0','2024-07-11 14:26:14',NULL);
/*!40000 ALTER TABLE `returnstock` ENABLE KEYS */;

-- 
-- Definition of returnstocknew
-- 

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

-- 
-- Dumping data for table returnstocknew
-- 

/*!40000 ALTER TABLE `returnstocknew` DISABLE KEYS */;
INSERT INTO `returnstocknew`(`id`,`lotid`,`ssccno`,`tarewt`,`netwt`,`grosswt`,`created`,`userid`,`updated`,`contno`,`rntime`) VALUES
(1,'6','089061816400090066','2.8','25','27.8',NULL,NULL,NULL,'2/3','2024-07-11 14:25:37'),
(2,'6','089061816400090057','2.8','25','27.8',NULL,NULL,NULL,'1/3','2024-07-11 14:25:37');
/*!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=25 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,'DOCUSATE SODIUM',1,'IP',NULL,'Store protect from moisture.','2024-07-10 16:15:54',NULL,'39','0','1','0','2024-07-10 16:55:40',NULL),
(2,'DOCUSATE SODIUM 85% POWDER',2,'USP',NULL,'Preserve in well closed container','2024-07-10 16:16:39',NULL,'39','0','1','0','2024-07-10 16:55:47',NULL),
(3,'PROPYL GALLATE ',3,'IP',NULL,'Store protect from light, in non-metallic container','2024-07-10 16:17:09',NULL,'39','0','1','0','2024-07-10 16:58:23',NULL),
(4,'CHLOROBUTANOL',4,'BP',NULL,'Store protect from moisture at temperature not exceeding 30° C','2024-07-11 13:32:46',NULL,'39','0','1','0','2024-07-11 13:33:10',NULL),
(5,'CHLOROBUTANOL',4,'IP',NULL,'Store protect from moisture at temperature not exceeding 30° C','2024-07-11 14:07:41',NULL,'39','0','1','0','2024-07-11 14:07:48',NULL),
(6,'CHLOROBUTANOL',4,'BP',NULL,'Preserve in well closed container                                                   ','2024-07-11 16:35:12','2024-07-11 16:39:31','39','0','1','0','2024-07-11 16:39:42',NULL),
(7,'DOCUSATE SODIUM 85% POWDER',2,'USP',NULL,'Preserve in well closed container','2024-07-17 11:28:20',NULL,'39','0','1','0','2024-07-17 11:28:26',NULL),
(8,'DOCUSATE SODIUM 85% POWDER',5,'USP',NULL,'Preserve in well closed container','2024-07-17 11:33:25',NULL,'39','0','1','0','2024-07-17 11:33:31',NULL),
(9,'Sodium salt of 4-Chloro-2-[(furan-2-ylmethyl)amino]5-sulfamoylbenzoic acid',6,'IP',NULL,'-','2024-07-19 18:19:17',NULL,'39','0','1','0','2024-07-19 18:19:24',NULL),
(10,'Sodium salt of 4-Chloro-2-[(furan-2-ylmethyl)amino]5-sulfamoylbenzoic acid',6,'IP',NULL,'NA','2024-07-24 17:09:28',NULL,'39','0','1','0','2024-07-24 17:09:32',NULL),
(11,'LAXA PA',7,'IP',NULL,'LAXA PA IP GRADE STORAGE CONDITION ','2024-07-25 12:30:31',NULL,'36','0','1','0','2024-07-25 12:31:17',NULL),
(12,'LAXA PA',7,'BP',NULL,'LAXA PA BP GRADE STORAGE CONDITION','2024-07-25 12:30:50',NULL,'36','0','1','0','2024-07-25 12:31:15',NULL),
(13,'LAXA PA',7,'TECHNICAL',NULL,'LAXA PA TECHNCAL GRADE STORAGE CONDITION','2024-07-25 12:31:08',NULL,'36','0','1','0','2024-07-25 12:31:13',NULL),
(14,'CHLOROBUTANOL.',8,'IP',NULL,'Store protect from moisture at temperature not exceeding 30° C','2024-07-27 13:35:53',NULL,'39','0','1','0','2024-07-27 13:35:59',NULL),
(15,'CHLOROBUTANOL.',8,'IP',NULL,'Store protect from moisture at temperature not exceeding 30° C','2024-07-27 13:37:04',NULL,'39','0','1','0','2024-07-27 13:37:09',NULL),
(16,'CHLOROBUTANOL.',8,'IP',NULL,'Store protect from moisture at temperature not exceeding 30° C','2024-07-27 13:39:06',NULL,'39','0','1','0','2024-07-27 13:39:12',NULL),
(17,'CHLOROBUTANOL.',8,'IP',NULL,'Store protect from moisture at temperature not exceeding 30° C','2024-07-27 13:42:28',NULL,'39','0','1','0','2024-07-27 13:42:33',NULL),
(18,'CHLOROBUTANOL..',9,'IP',NULL,'Store protect from moisture at temperature not exceeding 30° C..','2024-07-27 13:51:06',NULL,'39','0','1','0','2024-07-27 13:51:11',NULL),
(19,'PROPYL GALLATE ',3,'IP',NULL,'Store protect from light, in non-metallic container','2024-07-27 13:56:16',NULL,'39','0','1','0','2024-07-27 13:56:21',NULL),
(20,'PROPYL GALLATE',10,'IP',NULL,'Store protect from light, in non-metallic container','2024-07-27 13:58:43',NULL,'39','0','1','0','2024-07-27 13:58:51',NULL),
(21,'Propyl Gallate 1',11,'TECHNICAL',NULL,'STORAGE CONDITION IS NOT AVAILABLE FOR THIS GRADE','2024-07-29 12:55:57',NULL,'36','0','1','0','2024-07-29 12:56:04',NULL),
(22,'CHLOROBUTANOL,',14,'IP',NULL,'Store protect from light, in non-metallic container','2024-07-30 18:27:34',NULL,'39','0','1','0','2024-07-30 18:27:39',NULL),
(23,'Sodium salt of 4-Chloro-2-[(furan-2-ylmethyl)amino]5-sulfamoylbenzoic acid\t',16,'TECHNICAL',NULL,'N/A','2024-07-30 18:38:55',NULL,'39','0','1','0','2024-07-30 18:39:02',NULL),
(24,'Sodium salt of 4-Chloro-2-[(furan-2-ylmethyl)amino]5-sulfamoylbenzoic acid',17,'TECHNICAL',NULL,'N/A','2024-07-30 18:43:38',NULL,'39','0','1','0','2024-07-30 18:43:44',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-07-31 17:04:37
-- Total time: 0:0:0:0:249 (d:h:m:s:ms)
