-- MySqlBackup.NET 2.0.4
-- Dump Time: 2024-05-23 15:08:08
-- --------------------------------------
-- 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=2 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,'Cofil Alpha Alias1','Effi Cofil Alpha',1,'2024-05-23 15:00:10',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'34',NULL,NULL,NULL,'0','1',NULL,'2024-05-23 15:00:18',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=2 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,'Mohammad Waseem ','85472312','Amravati','8408070659','Waseem@gmail.com','2024-05-23 14:59:40',NULL,'85214796','','','','','','','Waseem','Customer','34','0','1',NULL,'2024-05-23 14:59:49',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,'1','Export','2024-05-23 00:00:00','2222','2024-05-23 00:00:00','1','1111','2024-05-23 15:01:30',NULL,'34','0','1',NULL,'2024-05-23 15:01:49',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,
  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`) VALUES
(1,'1','LAX/0524/001','','1','','','1','','','','20','2024-03-01 00:00:00','2024-12-01 00:00:00','34','0','','','','IP,BP','20','9','','180','1','1','1','0','1','0','2024-05-23 00:00:00','2024-05-23 15:01:13',NULL);
/*!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=10 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/9','1','150','170','001','078541258520014','0','1','1','20','1'),
(2,'2/9','1','150','170','002','078541258520021','0','1','1','20','1'),
(3,'3/9','1','150','170','003','078541258520038','0','0','1','20','1'),
(4,'4/9','1','150','170','004','078541258520045','0','0','1','20','1'),
(5,'5/9','1','150','170','005','078541258520052','0','0','1','20','1'),
(6,'6/9','1','150','170','006','078541258520069','0','0','1','20','1'),
(7,'7/9','1','150','170','007','078541258520076','0','0','1','20','1'),
(8,'8/9','1','150','170','008','078541258520083','0','0','1','20','1'),
(9,'9/9','1','150','170','009','078541258520090','0','0','1','20','1');
/*!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=10 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,'New Company Added','2024-05-23 14:56:20','34','Company Unit'),
(2,NULL,'New Product Added','2024-05-23 14:57:36','34','Product'),
(3,NULL,'Batch Added','2024-05-23 14:58:41','34','Batch'),
(4,NULL,'Customer Added','2024-05-23 14:59:40','34','Customer'),
(5,NULL,'Alias Product Added','2024-05-23 15:00:10','34','Alias Product'),
(6,NULL,'QR generated','2024-05-23 15:01:02','34','Generateqr'),
(7,NULL,'Lot Added','2024-05-23 15:01:30','34','Dispatch'),
(8,NULL,'Single Print Had Taken','2024-05-23 15:05:24','34','generateqrsr'),
(9,NULL,'Single Print Had Taken','2024-05-23 15:05:51','34','generateqrsr');
/*!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 Pvt Ltd','Laxachem','8547855','48756322','Dastur Nagar ',NULL,'Amravati','2024-05-23 14:56:21',NULL,'34','0','1',NULL,'2024-05-23 14:56:39',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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 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`) VALUES
(1,'34','1','manufacture','1','0','2024-05-23 14:56:21','2024-05-23 14:56:39',NULL,NULL,'Laxachem Pvt Ltd','New Item','0'),
(2,'34','1','product','1','0','2024-05-23 14:57:37','2024-05-23 14:57:55',NULL,NULL,'Effi Cofil Alpha','New Item','0'),
(3,'34','1','pbatch','1','0','2024-05-23 14:58:42','2024-05-23 14:58:56',NULL,NULL,'Cofil Alpha Batch1','New Item','0'),
(4,'34','1','customer','1','0','2024-05-23 14:59:40','2024-05-23 14:59:49',NULL,NULL,'Mohammad Waseem ','New Item','0'),
(5,'34','1','addproduct','1','0','2024-05-23 15:00:10','2024-05-23 15:00:18',NULL,NULL,'Cofil Alpha Alias1','New Item','0'),
(6,'34','1','generateqr','1','0','2024-05-23 15:01:02','2024-05-23 15:01:13',NULL,NULL,'LAX/0524/001',NULL,NULL),
(7,'34','1','dispatch','1','0','2024-05-23 15:01:30','2024-05-23 15:01:49',NULL,NULL,'LAX/0524/001','New Item','0'),
(8,'34','1','returnstock','1','0','2024-05-23 15:02:29','2024-05-23 15:02:38',NULL,NULL,'LAX/0524/001','New Item','0');
/*!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=2 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,'Cofil Alpha Batch1','1','200','Cofil Alpha IBatch1','2024-02-01 00:00:00','2024-11-01 00:00:00','','','IP,BP','2024-05-23 14:58:41',NULL,'34','0','1',NULL,'2024-05-23 14:58:56',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=2 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,'Effi Cofil Alpha','Laxachem','7854125852','1','Laxachem','Keep In Cool And Dry Places','IP,BP,EP','Cofil Alpha','20','KG','2024-05-23 14:57:37',NULL,'34','G6H7F5','150','0','1',NULL,'2024-05-23 14:57:55',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,'1','','2024-05-23 00:00:00','2024-05-23 15:02:28',NULL,'34','0','0','2024-05-23 15:02:28','1',NULL,'2024-05-23 15:02:38',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=10 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,'1','078541258520038','150','20','170',NULL,NULL,NULL,'3/9','2024-05-23 15:02:28'),
(2,'1','078541258520069','150','20','170',NULL,NULL,NULL,'6/9','2024-05-23 15:02:28'),
(3,'1','078541258520076','150','20','170',NULL,NULL,NULL,'7/9','2024-05-23 15:02:28'),
(4,'1','078541258520083','150','20','170',NULL,NULL,NULL,'8/9','2024-05-23 15:02:28'),
(5,'1','078541258520090','150','20','170',NULL,NULL,NULL,'9/9','2024-05-23 15:02:28'),
(6,'1','078541258520045','150','20','170',NULL,NULL,NULL,'4/9','2024-05-23 15:02:29'),
(7,'1','078541258520014','150','20','170',NULL,NULL,NULL,'1/9','2024-05-23 15:02:29'),
(8,'1','078541258520052','150','20','170',NULL,NULL,NULL,'5/9','2024-05-23 15:02:30'),
(9,'1','078541258520021','150','20','170',NULL,NULL,NULL,'2/9','2024-05-23 15:02:30');
/*!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 userm
-- 

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

-- 
-- Dumping data for table userm
-- 

/*!40000 ALTER TABLE `userm` DISABLE KEYS */;
INSERT INTO `userm`(`id`,`username`,`password`,`rights`,`addproduct`,`batch`,`customerr`,`dispatch`,`created`,`updated`,`dispatchreport`,`generateqr`,`logreport`,`manufact`,`products`,`returnstocks`,`rsreport`,`ssccreport`,`stocks`,`generateqradministration`,`userm`,`role`,`aliasproductadmin`,`customeradmin`,`dispatchadmin`,`generateqradmin`,`manufactureadmin`,`pbatchadmin`,`productadmin`,`returnstockadmin`,`stockadmin`,`usermadmin`,`aliasproductadministration`,`customeradministration`,`dispatchadministration`,`manufactureadministration`,`pbatchadministration`,`productadministration`,`returnstockadministration`,`stockadministration`,`usermadministration`,`aliasproductqa`,`customerqa`,`dispatchqa`,`generateqrqa`,`manufactureqa`,`pbatchqa`,`productqa`,`returnstockqa`,`stockqa`,`usermqa`,`name`,`approval`,`reports`,`subuser`) VALUES
(31,'xyz','1234','manufacturelocations,products,batch,stocks,usermanagem','','','','','2024-04-22 16:27:34','2024-04-22 16:27:34','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(33,'pratik1','1234','','create,read,edit,delete','create,read,edit,delete','create,read,edit,delete','',NULL,NULL,'','','','create,read,edit,delete','create,read,edit,delete','','','','','','','Admin','33','33','','','33','33','33','','','','','','','','','','','','','','','','','','','','','','','Pratik','Hide','Hide',''),
(34,'waseem1','1234','','create,read,edit,delete','create,read,edit,delete','create,read,edit,delete','create,read,edit,delete',NULL,NULL,'','create,read,preview,print','','create,read,edit,delete','create,read,edit,delete','create,read,edit,delete','','','create,read,edit,delete','','create,read,edit,delete','Admin','34','34','34','34','34','34','34','34','','','','','','','','','','','','','','','','','','','','','','Waseem','Show','Show','34'),
(35,'kapil1','1234','','create,read,edit,delete','','','',NULL,NULL,'','create,read,preview,print','','','','','','','','','','Admin','34','','','34','','','','','','','','','','','','','','','','','','','','','','','','','','Kapil','Hide','Hide','');
/*!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-05-23 15:08:09
-- Total time: 0:0:0:0:225 (d:h:m:s:ms)