-- MySqlBackup.NET 2.0.4
-- Dump Time: 2024-09-12 15:59:45
-- --------------------------------------
-- 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=4 DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table aliasproduct
-- 

/*!40000 ALTER TABLE `aliasproduct` DISABLE KEYS */;
INSERT INTO `aliasproduct`(`id`,`aliasproduct`,`product`,`productid`,`created`,`updated`,`qa`,`administration`,`admin`,`qatime`,`administtime`,`admintime`,`userid`,`qaid`,`adminisid`,`adminid`,`deletestatus`,`apaprstatus`,`aprejstatus`,`aprtime`,`rejtime`) VALUES
(1,'CHLOROBUTANOL','CHLOROBUTANOL',1,'2024-08-10 12:45:56',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'39',NULL,NULL,NULL,'0','1','0','2024-08-10 16:45:02',NULL),
(2,'CHLORBUTOL','CHLOROBUTANOL',1,'2024-08-10 12:47:08',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'39',NULL,NULL,NULL,'0','1','0','2024-08-10 16:45:04',NULL),
(3,'NA','PROPYL GALLATE',4,'2024-09-12 15:26:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'39',NULL,NULL,NULL,'0','1','0','2024-09-12 15:26:53',NULL);
/*!40000 ALTER TABLE `aliasproduct` ENABLE KEYS */;

-- 
-- Definition of customer
-- 

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

-- 
-- Dumping data for table customer
-- 

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

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

-- 
-- Definition of dispatch
-- 

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

-- 
-- Dumping data for table dispatch
-- 

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

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

-- 
-- Definition of generateqr
-- 

DROP TABLE IF EXISTS `generateqr`;
CREATE TABLE IF NOT EXISTS `generateqr` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `presetid` varchar(255) DEFAULT '',
  `genid` varchar(255) DEFAULT '',
  `title` varchar(255) DEFAULT '',
  `aliasproductid` varchar(255) DEFAULT '',
  `name` varchar(255) DEFAULT '',
  `formula1` varchar(255) DEFAULT '',
  `batch` varchar(255) DEFAULT '',
  `molwt` varchar(255) DEFAULT '',
  `grosswt` varchar(255) DEFAULT '',
  `tarewt` varchar(255) DEFAULT '',
  `netwt` varchar(255) DEFAULT '',
  `mfgdate` date DEFAULT NULL,
  `expdate` date DEFAULT NULL,
  `userid` varchar(50) DEFAULT NULL,
  `manuid` varchar(255) DEFAULT '',
  `contfrom` varchar(255) DEFAULT '',
  `contto` varchar(255) DEFAULT '',
  `contno` varchar(255) DEFAULT '',
  `grade` varchar(255) DEFAULT '',
  `pack` varchar(255) DEFAULT '',
  `ncont` varchar(255) DEFAULT '',
  `qrqty` varchar(255) DEFAULT '',
  `totalqty` varchar(255) DEFAULT '',
  `dispatch` varchar(255) DEFAULT '0',
  `returnst` varchar(255) DEFAULT '0',
  `aprstatus` varchar(255) DEFAULT '0',
  `qrrejstatus` varchar(255) DEFAULT '0',
  `lotdisaprstatus` varchar(255) DEFAULT '0',
  `lotdisrejstatus` varchar(255) DEFAULT '0',
  `lotcreatedate` date DEFAULT NULL,
  `qraprtime` datetime DEFAULT NULL,
  `qrrejtime` datetime DEFAULT NULL,
  `storagecon` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 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/0824/001','','1','','','4','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','BP','25','20','','500','0','0','1','0','0','0','2024-08-11 00:00:00','2024-08-11 16:16:38',NULL,'In an air tight container');
/*!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=21 DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table generateqrsr
-- 

/*!40000 ALTER TABLE `generateqrsr` DISABLE KEYS */;
INSERT INTO `generateqrsr`(`id`,`contno`,`qrid`,`tarewt`,`grosswt`,`uninum`,`sscc`,`fdigit`,`preview`,`ssccrs`,`qrsrtqty`,`batchid`) VALUES
(1,'1/20','1','2.2','27.2','001','089061816400090011','0','0','0','25','4'),
(2,'2/20','1','2.2','27.2','002','089061816400090020','0','0','0','25','4'),
(3,'3/20','1','2.2','27.2','003','089061816400090039','0','0','0','25','4'),
(4,'4/20','1','2.2','27.2','004','089061816400090048','0','0','0','25','4'),
(5,'5/20','1','2.2','27.2','005','089061816400090057','0','0','0','25','4'),
(6,'6/20','1','2.2','27.2','006','089061816400090066','0','0','0','25','4'),
(7,'7/20','1','2.2','27.2','007','089061816400090075','0','0','0','25','4'),
(8,'8/20','1','2.2','27.2','008','089061816400090084','0','0','0','25','4'),
(9,'9/20','1','2.2','27.2','009','089061816400090093','0','0','0','25','4'),
(10,'10/20','1','2.2','27.2','010','089061816400090109','0','0','0','25','4'),
(11,'11/20','1','2.2','27.2','011','089061816400090118','0','0','0','25','4'),
(12,'12/20','1','2.2','27.2','012','089061816400090127','0','0','0','25','4'),
(13,'13/20','1','2.2','27.2','013','089061816400090136','0','0','0','25','4'),
(14,'14/20','1','2.2','27.2','014','089061816400090145','0','0','0','25','4'),
(15,'15/20','1','2.2','27.2','015','089061816400090154','0','0','0','25','4'),
(16,'16/20','1','2.2','27.2','016','089061816400090163','0','0','0','25','4'),
(17,'17/20','1','2.2','27.2','017','089061816400090172','0','0','0','25','4'),
(18,'18/20','1','2.2','27.2','018','089061816400090181','0','0','0','25','4'),
(19,'19/20','1','2.2','27.2','019','089061816400090190','0','0','0','25','4'),
(20,'20/20','1','2.2','27.2','020','089061816400090206','0','0','0','25','4');
/*!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=126 DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table logtable
-- 

/*!40000 ALTER TABLE `logtable` DISABLE KEYS */;
INSERT INTO `logtable`(`id`,`username`,`action`,`time`,`userid`,`tablename`) VALUES
(1,NULL,'User Logged In','2024-08-03 11:13:36','39','Login In'),
(2,NULL,'New Company Added','2024-08-03 11:21:56','39','Company Unit'),
(3,NULL,'User Logged In','2024-08-03 12:08:14','39','Login In'),
(4,NULL,'User Logged In','2024-08-03 12:40:03','36','Login In'),
(5,NULL,'Company Updated','2024-08-03 12:43:56','36','Company Unit'),
(6,NULL,'Company Unit Approved','2024-08-03 12:47:53','36','Approval'),
(7,NULL,'User Logged In','2024-08-03 12:50:13','39','Login In'),
(8,NULL,'New Product Added','2024-08-03 12:54:21','39','Product'),
(9,NULL,'New Product Added','2024-08-03 12:58:20','39','Product'),
(10,NULL,'User Logged In','2024-08-03 13:02:08','37','Login In'),
(11,NULL,'New Product Added','2024-08-03 13:04:29','39','Product'),
(12,NULL,'User Logged Out','2024-08-03 13:06:28','37','Log Out'),
(13,NULL,'New Product Added','2024-08-03 13:06:53','39','Product'),
(14,NULL,'New Product Added','2024-08-03 13:10:05','39','Product'),
(15,NULL,'New Product Added','2024-08-03 13:12:42','39','Product'),
(16,NULL,'Product Updated','2024-08-03 13:14:19','39','Product'),
(17,NULL,'User Logged In','2024-08-03 13:26:49','39','Login In'),
(18,NULL,'Product Updated','2024-08-03 13:27:27','39','Product'),
(19,NULL,'Product Updated','2024-08-03 13:28:14','39','Product'),
(20,NULL,'User Logged In','2024-08-03 13:37:47','39','Login In'),
(21,NULL,'User Logged In','2024-08-03 14:03:20','39','Login In'),
(22,NULL,'User Logged In','2024-08-03 15:16:31','39','Login In'),
(23,NULL,'User Logged In','2024-08-03 15:55:12','36','Login In'),
(24,NULL,'User Logged In','2024-08-03 15:58:31','39','Login In'),
(25,NULL,'User Logged In','2024-08-03 16:23:49','39','Login In'),
(26,NULL,'New Product Added','2024-08-03 16:29:29','39','Product'),
(27,NULL,'User Logged In','2024-08-03 16:31:57','37','Login In'),
(28,NULL,'Product Approved','2024-08-03 16:33:10','37','Approval'),
(29,NULL,'Product Approved','2024-08-03 16:33:41','37','Approval'),
(30,NULL,'Product Approved','2024-08-03 16:36:24','37','Approval'),
(31,NULL,'Product Approved','2024-08-03 16:38:19','37','Approval'),
(32,NULL,'Product Updated','2024-08-03 16:43:31','39','Product'),
(33,NULL,'User Logged Out','2024-08-03 16:43:34','37','Log Out'),
(34,NULL,'User Logged In','2024-08-03 18:22:59','36','Login In'),
(35,NULL,'User Logged In','2024-08-04 11:41:05','37','Login In'),
(36,NULL,'User Logged In','2024-08-04 12:39:57','39','Login In'),
(37,NULL,'User Logged In','2024-08-04 12:55:20','37','Login In'),
(38,NULL,'Product Approved','2024-08-04 12:59:43','37','Approval'),
(39,NULL,'Product Rejected','2024-08-04 13:03:26','37','Approval'),
(40,NULL,'Product Approved','2024-08-04 13:07:16','37','Approval'),
(41,NULL,'Product Updated','2024-08-04 13:08:22','39','Product'),
(42,NULL,'User Logged In','2024-08-04 14:31:37','37','Login In'),
(43,NULL,'Product Approved','2024-08-04 14:31:49','37','Approval'),
(44,NULL,'User Logged In','2024-08-06 12:05:10','39','Login In'),
(45,NULL,'Batch Added','2024-08-06 12:07:13','39','Batch'),
(46,NULL,'Batch Updated','2024-08-06 12:09:55','39','Batch'),
(47,NULL,'User Logged In','2024-08-07 11:54:04','39','Login In'),
(48,NULL,'Batch Added','2024-08-07 11:56:35','39','Batch'),
(49,NULL,'Batch Added','2024-08-07 11:58:02','39','Batch'),
(50,NULL,'Batch Updated','2024-08-07 12:00:21','39','Batch'),
(51,NULL,'Batch Updated','2024-08-07 12:00:29','39','Batch'),
(52,NULL,'User Logged In','2024-08-09 12:06:33','39','Login In'),
(53,NULL,'Batch Data Deleted','2024-08-09 12:06:48','39','Batch'),
(54,NULL,'Batch Data Deleted','2024-08-09 12:06:52','39','Batch'),
(55,NULL,'Batch Data Deleted','2024-08-09 12:06:55','39','Batch'),
(56,NULL,'Batch Added','2024-08-09 12:08:25','39','Batch'),
(57,NULL,'Batch Added','2024-08-09 12:09:18','39','Batch'),
(58,NULL,'Batch Added','2024-08-09 12:09:59','39','Batch'),
(59,NULL,'Batch Added','2024-08-09 12:10:43','39','Batch'),
(60,NULL,'Batch Added','2024-08-09 12:11:29','39','Batch'),
(61,NULL,'User Logged In','2024-08-09 16:11:09','37','Login In'),
(62,NULL,'Batch Delete Approved','2024-08-09 16:12:02','37','Approval'),
(63,NULL,'Batch Delete Approved','2024-08-09 16:12:31','37','Approval'),
(64,NULL,'Batch Delete Approved','2024-08-09 16:12:53','37','Approval'),
(65,NULL,'Batch Approved','2024-08-09 16:14:10','37','Approval'),
(66,NULL,'Batch Approved','2024-08-09 16:14:53','37','Approval'),
(67,NULL,'Batch Approved','2024-08-09 16:15:42','37','Approval'),
(68,NULL,'Batch Approved','2024-08-09 16:16:25','37','Approval'),
(69,NULL,'Batch Approved','2024-08-09 16:16:43','37','Approval'),
(70,NULL,'User Logged Out','2024-08-09 16:17:27','37','Log Out'),
(71,NULL,'User Logged In','2024-08-10 12:44:41','39','Login In'),
(72,NULL,'Alias Product Added','2024-08-10 12:45:56','39','Alias Product'),
(73,NULL,'Alias Product Added','2024-08-10 12:47:08','39','Alias Product'),
(74,NULL,'User Logged In','2024-08-10 13:44:57','39','Login In'),
(75,NULL,'User Logged In','2024-08-10 16:42:52','37','Login In'),
(76,NULL,'Alias Product Approved','2024-08-10 16:45:02','37','Approval'),
(77,NULL,'Alias Product Approved','2024-08-10 16:45:04','37','Approval'),
(78,NULL,'User Logged Out','2024-08-10 16:45:12','37','Log Out'),
(79,NULL,'User Logged In','2024-08-11 15:05:32','39','Login In'),
(80,NULL,'Storage Condition Added','2024-08-11 15:07:16','39','Storage Condition'),
(81,NULL,'User Logged In','2024-08-11 15:58:31','39','Login In'),
(82,NULL,'User Logged In','2024-08-11 16:11:03','37','Login In'),
(83,NULL,'Storage Condition Approved','2024-08-11 16:12:16','37','Storage Condition'),
(84,NULL,'User Logged Out','2024-08-11 16:12:23','37','Log Out'),
(85,NULL,'QR generated','2024-08-11 16:13:17','39','Generateqr'),
(86,NULL,'User Logged In','2024-08-11 16:15:33','37','Login In'),
(87,NULL,'Generateqr Approved','2024-08-11 16:16:38','37','Approval'),
(88,NULL,'User Logged Out','2024-08-11 16:16:53','37','Log Out'),
(89,NULL,'Single Print Had Taken','2024-08-11 16:17:02','39','generateqrsr'),
(90,NULL,'Single Print Had Taken','2024-08-11 16:17:30','39','generateqrsr'),
(91,NULL,'Single Print Had Taken','2024-08-11 16:18:25','39','generateqrsr'),
(92,NULL,'Single Print Had Taken','2024-08-11 16:18:42','39','generateqrsr'),
(93,NULL,'Single Print Had Taken','2024-08-11 16:34:49','39','generateqrsr'),
(94,NULL,'Storage Condition Edited','2024-08-11 16:39:25','39','Storage Condition'),
(95,NULL,'User Logged Out','2024-08-11 16:59:14','39','Log Out'),
(96,NULL,'User Logged In','2024-08-11 16:59:16','39','Login In'),
(97,NULL,'Single Print Had Taken','2024-08-11 16:59:36','39','generateqrsr'),
(98,NULL,'User Logged In','2024-08-11 17:08:32','36','Login In'),
(99,NULL,'Single Print Had Taken','2024-08-11 17:09:38','36','generateqrsr'),
(100,NULL,'Multiple Print Had Taken','2024-08-11 17:10:28','36','generateqrsr'),
(101,NULL,'User Logged In','2024-08-12 16:31:35','36','Login In'),
(102,NULL,'Single Print Had Taken','2024-08-12 16:32:15','36','generateqrsr'),
(103,NULL,'Multiple Print Had Taken','2024-08-12 16:32:28','36','generateqrsr'),
(104,NULL,'User Logged In','2024-09-11 18:17:13','36','Login In'),
(105,NULL,'User Logged Out','2024-09-11 18:17:36','36','Log Out'),
(106,NULL,'User Logged In','2024-09-12 13:27:33','39','Login In'),
(107,NULL,'User Logged In','2024-09-12 13:35:26','39','Login In'),
(108,NULL,'Batch Added','2024-09-12 13:39:19','39','Batch'),
(109,NULL,'Storage Condition Added','2024-09-12 13:57:45','39','Storage Condition'),
(110,NULL,'User Logged Out','2024-09-12 13:59:20','39','Log Out'),
(111,NULL,'User Logged In','2024-09-12 13:59:52','37','Login In'),
(112,NULL,'User Logged Out','2024-09-12 14:00:36','37','Log Out'),
(113,NULL,'User Logged In','2024-09-12 14:01:13','38','Login In'),
(114,NULL,'User Logged In','2024-09-12 14:08:27','36','Login In'),
(115,NULL,'User Logged In','2024-09-12 14:32:55','37','Login In'),
(116,NULL,'Batch Approved','2024-09-12 14:33:42','37','Approval'),
(117,NULL,'Storage Condition Approved','2024-09-12 14:34:44','37','Storage Condition'),
(118,NULL,'User Logged In','2024-09-12 15:24:34','39','Login In'),
(119,NULL,'Alias Product Added','2024-09-12 15:25:59','39','Alias Product'),
(120,NULL,'User Logged In','2024-09-12 15:26:43','37','Login In'),
(121,NULL,'Alias Product Approved','2024-09-12 15:26:53','37','Approval'),
(122,NULL,'User Logged Out','2024-09-12 15:36:28','37','Log Out'),
(123,NULL,'User Logged In','2024-09-12 15:36:46','39','Login In'),
(124,NULL,'User Logged In','2024-09-12 15:46:59','39','Login In'),
(125,NULL,'User Logged In','2024-09-12 15:59:40','36','Login In');
/*!40000 ALTER TABLE `logtable` ENABLE KEYS */;

-- 
-- Definition of manufacture
-- 

DROP TABLE IF EXISTS `manufacture`;
CREATE TABLE IF NOT EXISTS `manufacture` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `manu` varchar(255) DEFAULT '',
  `dis` varchar(255) DEFAULT '',
  `lic` varchar(255) DEFAULT '',
  `prefix` varchar(255) DEFAULT '',
  `add1` varchar(1000) DEFAULT '',
  `details` text,
  `add2` varchar(1000) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  `userid` varchar(50) DEFAULT NULL,
  `deletestatus` varchar(50) DEFAULT NULL,
  `manuaprstatus` varchar(50) DEFAULT NULL,
  `manrejstatus` varchar(50) DEFAULT NULL,
  `manuaprtime` datetime DEFAULT NULL,
  `manurejtime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table manufacture
-- 

/*!40000 ALTER TABLE `manufacture` DISABLE KEYS */;
INSERT INTO `manufacture`(`id`,`manu`,`dis`,`lic`,`prefix`,`add1`,`details`,`add2`,`created`,`updated`,`userid`,`deletestatus`,`manuaprstatus`,`manrejstatus`,`manuaprtime`,`manurejtime`) VALUES
(1,'LAXACHEM ORGANICS PVT LTD','LAXACHEM ORGANICS PVT LTD','(25) AMD/3/96','890618164','Plot No. D-2, MIDC',NULL,'AMRAVATI-444 607. (Maharashtra) INDIA ','2024-08-03 11:21:56','2024-08-03 12:43:57','36','0','1','0','2024-08-03 12:47:53',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=36 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
(2,'36','1','manufacture','1','0','2024-08-03 12:43:57','2024-08-03 12:47:53',NULL,NULL,'LAXACHEM ORGANICS PVT LTD','Edit','0','36'),
(4,'37','2','product','1','0','2024-08-03 12:58:20','2024-08-03 16:33:10',NULL,NULL,'DOCUSATE SODIUM','New Item','0','39'),
(7,'37','5','product','1','0','2024-08-03 13:10:06','2024-08-04 13:07:16',NULL,NULL,'Sodium salt of 4-Chloro-2-[(furan-2-ylmethyl)amino]5-sulfamoylbenzoic acid','New Item','0','39'),
(10,'37','1','product','1','0','2024-08-03 13:27:27','2024-08-03 16:33:41',NULL,NULL,'CHLOROBUTANOL','Edit','0','39'),
(11,'37','3','product','1','0','2024-08-03 13:28:14','2024-08-03 16:38:19',NULL,NULL,'DOCUSATE SODIUM 85%','Edit','0','39'),
(12,'37','7','product','1','0','2024-08-03 16:29:29','2024-08-03 16:36:24',NULL,NULL,'CHLOROBUTANOL','New Item','0','39'),
(13,'37','4','product','1','0','2024-08-03 16:43:31','2024-08-04 12:59:43',NULL,NULL,'PROPYL GALLATE','Edit','0','39'),
(14,'37','6','product','1','0','2024-08-04 13:08:23','2024-08-04 14:31:49',NULL,NULL,'FUROSEMIDE','Edit','0','39'),
(21,'37','1','pbatch','1','0','2024-08-09 12:06:49','2024-08-09 16:12:02',NULL,NULL,'CH-40724','Delete','1','39'),
(22,'37','2','pbatch','1','0','2024-08-09 12:06:52','2024-08-09 16:12:31',NULL,NULL,'CH-40624','Delete','1','39'),
(23,'37','3','pbatch','1','0','2024-08-09 12:06:55','2024-08-09 16:12:53',NULL,NULL,'CH-50624','Delete','1','39'),
(24,'37','4','pbatch','1','0','2024-08-09 12:08:25','2024-08-09 16:14:10',NULL,NULL,'CH-10824','New Item','0','39'),
(25,'37','5','pbatch','1','0','2024-08-09 12:09:19','2024-08-09 16:14:53',NULL,NULL,'CH-20824','New Item','0','39'),
(26,'37','6','pbatch','1','0','2024-08-09 12:10:00','2024-08-09 16:15:42',NULL,NULL,'CH-30824','New Item','0','39'),
(27,'37','7','pbatch','1','0','2024-08-09 12:10:44','2024-08-09 16:16:25',NULL,NULL,'CH-40824','New Item','0','39'),
(28,'37','8','pbatch','1','0','2024-08-09 12:11:30','2024-08-09 16:16:43',NULL,NULL,'CH-50824','New Item','0','39'),
(29,'37','1','addproduct','1','0','2024-08-10 12:45:56','2024-08-10 16:45:02',NULL,NULL,'CHLOROBUTANOL','New Item','0','39'),
(30,'37','2','addproduct','1','0','2024-08-10 12:47:08','2024-08-10 16:45:04',NULL,NULL,'CHLORBUTOL','New Item','0','39'),
(31,'37','1','storagecondition','1','0','2024-08-11 15:07:16','2024-08-11 16:12:16',NULL,NULL,'In an air tight container','New Item','0','39'),
(32,'37','1','generateqr','1','0','2024-08-11 16:13:18','2024-08-11 16:16:38',NULL,NULL,'LAX/0824/001','New Item',NULL,'39'),
(33,'37','9','pbatch','1','0','2024-09-12 13:39:20','2024-09-12 14:33:42',NULL,NULL,'PG-10824','New Item','0','39'),
(34,'37','2','storagecondition','1','0','2024-09-12 13:57:45','2024-09-12 14:34:44',NULL,NULL,'Store protect from light, in non-metallic container','New Item','0','39'),
(35,'37','3','addproduct','1','0','2024-09-12 15:26:00','2024-09-12 15:26:53',NULL,NULL,'NA','New Item','0','39');
/*!40000 ALTER TABLE `pagemaster` ENABLE KEYS */;

-- 
-- Definition of pbatch
-- 

DROP TABLE IF EXISTS `pbatch`;
CREATE TABLE IF NOT EXISTS `pbatch` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `batch` varchar(255) DEFAULT '',
  `product` varchar(255) DEFAULT '',
  `batchsize` varchar(255) DEFAULT '',
  `batchnumber` varchar(255) DEFAULT '',
  `mfgdate` date DEFAULT NULL,
  `expdate` date DEFAULT NULL,
  `weight` varchar(255) DEFAULT '',
  `remark` varchar(255) DEFAULT '',
  `pid` varchar(255) DEFAULT '',
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  `userid` varchar(50) DEFAULT NULL,
  `deletestatus` varchar(50) DEFAULT NULL,
  `bataprstatus` varchar(50) DEFAULT NULL,
  `batrejstatus` varchar(50) DEFAULT NULL,
  `bataprtime` datetime DEFAULT NULL,
  `batrejtime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table pbatch
-- 

/*!40000 ALTER TABLE `pbatch` DISABLE KEYS */;
INSERT INTO `pbatch`(`id`,`batch`,`product`,`batchsize`,`batchnumber`,`mfgdate`,`expdate`,`weight`,`remark`,`pid`,`created`,`updated`,`userid`,`deletestatus`,`bataprstatus`,`batrejstatus`,`bataprtime`,`batrejtime`) VALUES
(1,'CH-40724','1','500','NA','2024-07-01 00:00:00','2029-06-01 00:00:00','','','IP,BP,EP,USP','2024-08-07 12:00:22','2024-08-07 12:00:22','39','1','1','0','2024-08-09 16:12:02',NULL),
(2,'CH-40624','1','500','NA','2024-06-01 00:00:00','2029-05-01 00:00:00','','','IP,BP,EP,USP','2024-08-07 12:00:30','2024-08-07 12:00:30','39','1','1','0','2024-08-09 16:12:31',NULL),
(3,'CH-50624','1','500','NA','2024-06-01 00:00:00','2029-05-01 00:00:00','','','IP,BP,EP,USP','2024-08-07 11:58:02',NULL,'39','1','1','0','2024-08-09 16:12:53',NULL),
(4,'CH-10824','1','500','NA','2024-08-01 00:00:00','2029-07-01 00:00:00','','','IP,BP,EP,USP','2024-08-09 12:08:25',NULL,'39','0','1','0','2024-08-09 16:14:10',NULL),
(5,'CH-20824','1','500','NA','2024-08-01 00:00:00','2029-07-01 00:00:00','','','IP,BP,EP,USP','2024-08-09 12:09:18',NULL,'39','0','1','0','2024-08-09 16:14:53',NULL),
(6,'CH-30824','1','500','NA','2024-08-01 00:00:00','2029-07-01 00:00:00','','','IP,BP,EP,USP','2024-08-09 12:09:59',NULL,'39','0','1','0','2024-08-09 16:15:42',NULL),
(7,'CH-40824','1','500','NA','2024-08-01 00:00:00','2029-07-01 00:00:00','','','IP,BP,EP,USP','2024-08-09 12:10:43',NULL,'39','0','1','0','2024-08-09 16:16:25',NULL),
(8,'CH-50824','1','500','NA','2024-08-01 00:00:00','2029-07-01 00:00:00','','','IP,BP,EP,USP','2024-08-09 12:11:29',NULL,'39','0','1','0','2024-08-09 16:16:43',NULL),
(9,'PG-10824','4','500','NA','2024-08-01 00:00:00','2029-07-01 00:00:00','','','IP,BP,USP','2024-09-12 13:39:19',NULL,'39','0','1','0','2024-09-12 14:33:42',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=8 DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table product
-- 

/*!40000 ALTER TABLE `product` DISABLE KEYS */;
INSERT INTO `product`(`id`,`name`,`brand`,`gtin`,`manu`,`manutxt`,`scon`,`grade`,`subname`,`pack`,`uom`,`created`,`updated`,`userid`,`formula`,`molwt`,`deletestatus`,`prodaprstatus`,`prodrejstatus`,`prodaprtime`,`prodrejtime`) VALUES
(1,'CHLOROBUTANOL','NA','8906181640009','1','LAXACHEM ORGANICS PVT LTD','Preserve in air tight container','IP,BP,EP,USP','HEMIHYDRATE','5,10,15,20,25','KGS','2024-08-03 12:54:22','2024-08-03 13:27:27','39','C4H7Cl3O,1/2H2O','186.5','0','1','0','2024-08-03 16:33:41',NULL),
(2,'DOCUSATE SODIUM','NA','8906181640023','1','LAXACHEM ORGANICS PVT LTD','Preserve in well closed container','IP,BP,EP,USP','Dioctyl Sodium Sulfosuccinate','5,10,15,20,25','KGS','2024-08-03 12:58:20',NULL,'39','C20H37NaO7S','444.6','0','1','0','2024-08-03 16:33:10',NULL),
(3,'DOCUSATE SODIUM 85%','NA','8906181640030','1','LAXACHEM ORGANICS PVT LTD','Preserve in well closed container','USP','NA','5,10,15,20,25','KGS','2024-08-03 13:04:30','2024-08-03 13:28:14','39','NA','NA','0','1','0','2024-08-03 16:38:19',NULL),
(4,'PROPYL GALLATE','NA','8906181640047','1','LAXACHEM ORGANICS PVT LTD','Store protect from light, in non-metallic container','IP,BP,USP','NA','5,10,15,20,25','KGS','2024-08-03 13:06:54','2024-08-03 16:43:31','39','C10H12O5','212.2','0','1','0','2024-08-04 12:59:43',NULL),
(5,'Sodium salt of 4-Chloro-2-[(furan-2-ylmethyl)amino]5-sulfamoylbenzoic acid','NA','NA','1','LAXACHEM ORGANICS PVT LTD','NA','TECHNICAL','NA','5,10,15,20,25','KGS','2024-08-03 13:10:06',NULL,'39','C12H11CIN2O5S','330.7','0','1','0','2024-08-04 13:07:16',NULL),
(6,'FUROSEMIDE','NA','8906181640054','1','LAXACHEM ORGANICS PVT LTD','Store protect from moisture and light','IP,BP,EP,USP','NA','5,10,15,20,25','KGS','2024-08-03 13:12:43','2024-08-04 13:08:23','39','C12H11CIN2O5S','330.7','0','1','0','2024-08-04 14:31:49','2024-08-04 13:03:26'),
(7,'CHLOROBUTANOL','NA','8906181640016','1','LAXACHEM ORGANICS PVT LTD','In an air tight container','IP,BP,EP,USP','ANHYDROUS','5,10,15,20,25','KGS','2024-08-03 16:29:29',NULL,'39','C4H7Cl3O','177.5','0','1','0','2024-08-03 16:36:24',NULL);
/*!40000 ALTER TABLE `product` ENABLE KEYS */;

-- 
-- Definition of returnstock
-- 

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

-- 
-- Dumping data for table returnstock
-- 

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

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

-- 
-- Definition of returnstocknew
-- 

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

-- 
-- Dumping data for table returnstocknew
-- 

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

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

-- 
-- Definition of rolemaster
-- 

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

-- 
-- Dumping data for table rolemaster
-- 

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

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

-- 
-- Definition of storagecondition
-- 

DROP TABLE IF EXISTS `storagecondition`;
CREATE TABLE IF NOT EXISTS `storagecondition` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `product` varchar(255) NOT NULL,
  `productid` int(11) NOT NULL DEFAULT '0',
  `grade` varchar(50) NOT NULL,
  `scondition` varchar(255) DEFAULT NULL,
  `aliasscondition` varchar(255) DEFAULT NULL,
  `createdat` datetime DEFAULT NULL,
  `updatedat` datetime DEFAULT NULL,
  `userid` varchar(50) DEFAULT NULL,
  `deletestatus` varchar(50) DEFAULT '0',
  `strgaprstatus` varchar(50) DEFAULT '0',
  `strgrejstatus` varchar(50) DEFAULT '0',
  `strgaprtime` datetime DEFAULT NULL,
  `strgrejtime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table storagecondition
-- 

/*!40000 ALTER TABLE `storagecondition` DISABLE KEYS */;
INSERT INTO `storagecondition`(`id`,`product`,`productid`,`grade`,`scondition`,`aliasscondition`,`createdat`,`updatedat`,`userid`,`deletestatus`,`strgaprstatus`,`strgrejstatus`,`strgaprtime`,`strgrejtime`) VALUES
(1,'CHLOROBUTANOL',1,'BP',NULL,'In an air tight container','2024-08-11 15:07:16',NULL,'39','0','1','0','2024-08-11 16:12:16',NULL),
(2,'PROPYL GALLATE',4,'IP',NULL,'Store protect from light, in non-metallic container','2024-09-12 13:57:45',NULL,'39','0','1','0','2024-09-12 14:34: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-09-12 15:59:45
-- Total time: 0:0:0:0:234 (d:h:m:s:ms)
