-- MySQL dump 10.16  Distrib 10.1.32-MariaDB, for Win32 (AMD64)
--
-- Host: localhost    Database: fluenterp_cap
-- ------------------------------------------------------
-- Server version	10.1.32-MariaDB

/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!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 */;

--
-- Table structure for table `master_data`
--

DROP TABLE IF EXISTS `master_data`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `master_data` (
  `recnum` int(11) DEFAULT NULL,
  `partname` varchar(50) DEFAULT NULL,
  `wonum` varchar(30) DEFAULT NULL,
  `customer` varchar(50) DEFAULT NULL,
  `partnum` varchar(50) DEFAULT NULL,
  `RM_by_CIM` varchar(10) DEFAULT NULL,
  `project` varchar(255) DEFAULT NULL,
  `attachments` varchar(255) DEFAULT NULL,
  `RM_by_customer` varchar(10) DEFAULT NULL,
  `CIM_refnum` varchar(30) DEFAULT NULL,
  `drg_issue` varchar(255) DEFAULT NULL,
  `rm_type` varchar(255) DEFAULT NULL,
  `rm_spec` varchar(255) DEFAULT NULL,
  `rm_dim1` varchar(60) DEFAULT NULL,
  `rm_dim2` varchar(60) DEFAULT NULL,
  `rm_dim3` varchar(60) DEFAULT NULL,
  `mps_rev` varchar(20) DEFAULT NULL,
  `mps_num` varchar(20) DEFAULT NULL,
  `drawing_num` varchar(20) DEFAULT NULL,
  `cos` varchar(255) DEFAULT NULL,
  `condition` text,
  `maxruling` varchar(60) DEFAULT NULL,
  `grainflow` varchar(60) DEFAULT NULL,
  `machine_name` varchar(45) DEFAULT NULL,
  `revstat` char(30) DEFAULT NULL,
  `secondary_partname` varchar(50) DEFAULT NULL,
  `type` varchar(25) DEFAULT NULL,
  `status` char(20) DEFAULT NULL,
  `cos_iss_date` varchar(255) DEFAULT NULL,
  `remarks` varchar(255) DEFAULT NULL,
  `modified_date` date DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `treat` varchar(50) DEFAULT NULL,
  `eng_app_by` varchar(45) DEFAULT NULL,
  `eng_app_date` date DEFAULT NULL,
  `eng_app` varchar(45) DEFAULT NULL,
  `siteid` varchar(45) DEFAULT NULL,
  `partlist` varchar(255) DEFAULT NULL,
  `adcn` varchar(255) DEFAULT NULL,
  `edoc` varchar(255) DEFAULT NULL,
  `class` varchar(255) DEFAULT NULL,
  `sop` varchar(255) DEFAULT NULL,
  `model_iss` varchar(255) DEFAULT NULL,
  `mbq` int(11) DEFAULT '0',
  KEY `custname` (`customer`),
  KEY `mcrn` (`CIM_refnum`),
  KEY `ind_masterdata_partnum` (`partnum`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `master_data`
--

LOCK TABLES `master_data` WRITE;
/*!40000 ALTER TABLE `master_data` DISABLE KEYS */;
INSERT INTO `master_data` VALUES (7047,'sss',NULL,'A2','121','','','A','','prn1','A','RMT 1','RMS 2','50','20','30','1213','123','','A','','1','1','','Active','','Non Assembly','Active',NULL,'','2016-11-06','2016-08-23','Untreated','bmandyam','2016-08-23','yes','FSI',NULL,NULL,NULL,NULL,NULL,NULL,0);
INSERT INTO `master_data` VALUES (7048,'ssss',NULL,'ssds','3434','','','b','','prn2','b','','','','','','','12343','','b','test','','','','Active','','Non Assembly','Active',NULL,'','2017-08-10','2016-09-28','Untreated','bmandyam','2016-09-28','yes','FSI',NULL,NULL,NULL,NULL,NULL,NULL,0);
INSERT INTO `master_data` VALUES (7049,'dsds',NULL,'adsd','3434','','','c','yes','prn3','c','','','','','','00','233','','c','test','','','','Active','','Non Assembly','Active',NULL,'','2016-11-06','2016-09-28','Untreated','bmandyam','2016-09-28','yes','FSI',NULL,NULL,NULL,NULL,NULL,NULL,0);
INSERT INTO `master_data` VALUES (7050,'rdgfd',NULL,'dfgdf','435','','','s','','prn4','s','','','','','','','test122','','s','test','','','','Active','','Non Assembly','Active',NULL,'','2017-11-24','2016-09-28','Treated','bmandyam','2016-09-28','yes','FSI',NULL,NULL,NULL,NULL,NULL,NULL,0);
INSERT INTO `master_data` VALUES (7051,'sddsd',NULL,'dsf','324','','','s','sdfs','prn5','b','','','','','','','222','','a','test','','','','Obsolete','','Non Assembly','Active',NULL,'','2016-11-06','2016-09-28','Untreated','bmandyam','2016-09-28','yes','FSI',NULL,NULL,NULL,NULL,NULL,NULL,0);
INSERT INTO `master_data` VALUES (7052,'sssss',NULL,'dddd','54543','','','g','sccc','prn6','g','RMT 6','','','','','66','324','','g','test','','','','Active','','Non Assembly','Active',NULL,'','2016-11-06','2016-09-30','Treated','bman','2016-09-30','yes','FSI',NULL,NULL,NULL,NULL,NULL,NULL,0);
INSERT INTO `master_data` VALUES (7053,'fddd',NULL,'','34344','','','g','','prn7','g','RMT 7','RMS 7','','','','','3434','','g','','','','','Active','','Non Assembly','Active',NULL,'','2016-11-06','2016-10-12','Treated','bmandyam','2016-10-12','yes','FSI',NULL,NULL,NULL,NULL,NULL,NULL,0);
INSERT INTO `master_data` VALUES (7054,'24354',NULL,'sdsd','2343','','','dd','','prn8','dd','','','','','','123','2342','dd','dd','','','','','Active','','Non Assembly','Active',NULL,'','2016-10-18','2016-10-18','Treated','bmandyam','2016-10-18','yes','FSI',NULL,NULL,NULL,NULL,NULL,NULL,0);
INSERT INTO `master_data` VALUES (7055,'asd',NULL,'sdsd','132','','','C','','prn9','C','','','','','','','','','C','','','','','Active','','Non Assembly','Active',NULL,'','2018-05-16','2016-10-20','Untreated','bman','2016-10-20','yes','FSI',NULL,NULL,NULL,NULL,NULL,NULL,0);
INSERT INTO `master_data` VALUES (7056,'dsf',NULL,'ssss','3243','','','','','prn10','','','','','','','','','','','','','','','Active','','Kit','Active',NULL,'','2016-11-11','2016-11-11','Assembly','bmandyam','2016-11-11','yes','FSI',NULL,NULL,NULL,NULL,NULL,NULL,0);
INSERT INTO `master_data` VALUES (7057,'prn-name',NULL,'fluentsoft','prn-001','rm host','AIRBUS','at','rm cust','PRN-001','drgi','rmt','rms','100','50','50','00','MPS/51-036','drg','cos','hjfdhjfd','1','1','','Active','','Non Assembly','Active',NULL,'','2018-04-07','2017-08-08','Treated','bmandyam','2017-08-08','yes','FSI',NULL,NULL,NULL,NULL,NULL,NULL,0);
INSERT INTO `master_data` VALUES (7058,'fluent part',NULL,'karthick','flu 00 100','','','A','','flu-001','A','','','','','','00','flu-mps-001','A','A','','','','','Active','','Non Assembly','Active',NULL,'','2017-12-05','2017-12-05','Untreated','bmandyam','2017-12-05','yes','FSI',NULL,NULL,NULL,NULL,NULL,NULL,0);
INSERT INTO `master_data` VALUES (7059,'partname',NULL,'karthick','flu-boi-001','','','A','','flu-assy-001','A','A','A','','','','00','boi-mps-00','','A','fsgasfg','','','','Active','','Assembly','Active',NULL,'','2017-12-05','2017-12-05','Assembly','bmandyam','2017-12-05','yes','FSI',NULL,NULL,NULL,NULL,NULL,NULL,0);
INSERT INTO `master_data` VALUES (7060,'partname',NULL,'karthick','flu-boi-001','','','A','','flu-boi-001','A','A','A','','','','00','boi-001','A','','','','','','Active','','Assembly','Active',NULL,'','0000-00-00','2017-12-05','Assembly','','0000-00-00','','FSI',NULL,NULL,NULL,NULL,NULL,NULL,0);
INSERT INTO `master_data` VALUES (7068,'awawee',NULL,'ACCORD SOFTWARE & SYSTEMS ( P ) Ltd','EWQe','yes','','','','PP-1','zsf','','','10','20','30','12','1','12','','sdfsff','','','cccc','Active','Aad','Assembly','Active',NULL,'','2018-07-31','2018-07-31','Treated','bmandyam','2018-07-31','yes',NULL,'','','','','','',0);
INSERT INTO `master_data` VALUES (7069,'supportplate-1',NULL,'ACCORD SOFTWARE & SYSTEMS ( P ) Ltd','12345','yes','','','','51-001','sdfsdf','sdfsdfdf','asdfsdafdasf','10','20','30','22','2','d1','','','','','','Active','','','Active',NULL,'','2018-07-31','2018-07-31','Treated','bmandyam','2018-07-31','yes','FSI','','','','','','',0);
INSERT INTO `master_data` VALUES (7070,'zdxfdf',NULL,'ACCORD SOFTWARE & SYSTEMS ( P ) Ltd','afasdfasdf','yes','','','','51-003','asdfasdf','zdsfdsafasdf','asdfasdf','10','20','20','33','3','asdf','','','','','','Active','','','Active',NULL,'','2018-07-31','2018-07-31','Treated','bmandyam','2018-07-31','yes','FSI','','','','','','',0);
INSERT INTO `master_data` VALUES (7071,'zdfsadfasdf',NULL,'ACCORD SOFTWARE & SYSTEMS ( P ) Ltd','adsfadsf','yes','','','','51-005','sdfsf','aseraer','asdsd','10','20','20','44','4','123456','','','','','','Active','','Assembly','Active',NULL,'','2018-07-31','2018-07-31','Treated','bmandyam','2018-07-31','yes','FSI','','','','','','',100);
INSERT INTO `master_data` VALUES (7072,'zxdsdf',NULL,'ACCORD SOFTWARE & SYSTEMS ( P ) Ltd','asdfadsf','yes','','','','51-006','','sfdasdf','asdasd','10','10','10','55','5','d5','','','','','','Active','','Assembly','Active',NULL,'','2018-07-31','2018-07-31','Treated','bmandyam','2018-07-31','yes','FSI','','','','','','',0);
INSERT INTO `master_data` VALUES (7073,'szdfasdf',NULL,'ACCORD SOFTWARE & SYSTEMS ( P ) Ltd','asdfasdf','Yes','','','','51-013','','zdfsdfds','','10','10','10','77','7','d7','','','','','','Active','','Assembly','Active',NULL,'','2018-07-31','2018-07-31','Treated','bmandyam','2018-07-31','yes','FSI','','','','','','',0);
INSERT INTO `master_data` VALUES (7074,'zsdfsdf',NULL,'ACCORD SOFTWARE & SYSTEMS ( P ) Ltd','adsfadsf','yes','','','','51-014','','sdfasdf','sdfsf','20','20','20','88','8','d4','','','','','','Active','','Assembly','Active',NULL,'','2018-07-31','2018-07-31','Treated','bmandyam','2018-07-31','yes','FSI','','','','','','',0);
INSERT INTO `master_data` VALUES (7075,'sdfasdf',NULL,'','adsfadsf','yes','','','','51-015','sdsad','asdfasdf','sdfadsf','10','10','30','99','9','d5','','','','','','Active','','Assembly','Active',NULL,'','2018-07-31','2018-07-31','Treated','bmandyam','2018-07-31','yes','FSI','','','','','','',0);
INSERT INTO `master_data` VALUES (7076,'zdfsdf',NULL,'AJANA TECHNOLOGY SOLUTIONS PVT LTD','asfaer','yes','','','','51-095','ewr','ewewerwer','werwerewr','20','20','20','122','12','d5','','','','','','Active','zdsdf','Assembly','Active',NULL,'','2018-07-31','2018-07-31','Treated','bmandyam','2018-07-31','yes','FSI','','','','','','',0);
INSERT INTO `master_data` VALUES (7077,'sdfsdf',NULL,'AJANA TECHNOLOGY SOLUTIONS PVT LTD','asdfadsf','yes','','qwe','','51-097','qweqwe','sdfadsfasd','wqeqw','30','30','30','133','33','d9','','','','','','Active','','Assembly','Active',NULL,'','2018-07-31','2018-07-31','Treated','bmandyam','2018-07-31','yes','FSI','','','','','','',0);
INSERT INTO `master_data` VALUES (7078,'SDFSDAF',NULL,'AJANA TECHNOLOGY SOLUTIONS PVT LTD','Q23DS','YES','ZDFSDF','ASDF','','51-099','ASDF','SFSDF3','SDFASF','10','20','30','144','44','D2','','','','SDFSDF','','Active','','Assembly','Active',NULL,'','2018-07-31','2018-07-31','Untreated','bmandyam','2018-07-31','yes','FSI','','','','','','',0);
INSERT INTO `master_data` VALUES (7079,'zasrserwer',NULL,'AJANA TECHNOLOGY SOLUTIONS PVT LTD','w4dsfsdf','yes','','','','51-100','sdfsdf','sdfsdfsdf','sdfsdf','20','30','10','155','55','d44','','','','sdf','','Active','ewer','Assembly','Active',NULL,'','2018-07-31','2018-07-31','Treated','bmandyam','2018-07-31','yes','FSI','','','','','','',0);
INSERT INTO `master_data` VALUES (7080,'saeraewr',NULL,'ACCORD SOFTWARE & SYSTEMS ( P ) Ltd','w34srw43','yes','','','','51-110','','sdfadsfasd','zdfsdf','20','10','20','133','33','d77','','','','','','Active','sdrwersd','Assembly','Active',NULL,'','2018-07-31','2018-07-31','Treated','bmandyam','2018-07-31','yes','FSI','','','','','','',0);
INSERT INTO `master_data` VALUES (7081,'asfawrwr',NULL,'ACCORD SOFTWARE & SYSTEMS ( P ) Ltd','wewrqr','yes','','','','51-111','','safsf','dfsadf','10','30','30','111','11','d1','','','','','','Active','sdfsdf','Assembly','Active',NULL,'','2018-07-31','2018-07-31','Treated','bmandyam','2018-07-31','yes','FSI','','','','','','',0);
INSERT INTO `master_data` VALUES (7082,'zsda',NULL,'ACCORD SOFTWARE & SYSTEMS ( P ) Ltd','sdsafsa','yes','','','','51-112','','sdfsdafsdf','dffdssf','20','40','20','1222','12','d66','','','','','','Active','asad','Assembly','Active',NULL,'','2018-07-31','2018-07-31','Treated','bmandyam','2018-07-31','yes','FSI','','','','','','',0);
INSERT INTO `master_data` VALUES (7083,'zsdfqwxscxcvxcv',NULL,'ACCORD SOFTWARE & SYSTEMS ( P ) Ltd','zxdszdfdsf23424','yes','','','','51-113','','ASwer','sdfsdf','20','10','40','199','19','d88','','','','','','Active','','Assembly','Active',NULL,'','2018-07-31','2018-07-31','Untreated','bmandyam','2018-07-31','yes','FSI','','','','','','',0);
INSERT INTO `master_data` VALUES (7084,'r3usdfujsdar',NULL,'ACCORD SOFTWARE & SYSTEMS ( P ) Ltd','as7w34s','yes','','','','51-124','sadfhser','awerwer','arwerwer','20','30','40','1990','199','d455','','','','','','Active','','Assembly','Active',NULL,'','2018-08-03','2018-07-31','Treated','bmandyam','2018-07-31','yes','FSI','','','','','','',110);
INSERT INTO `master_data` VALUES (7085,'sdfsaf',NULL,'ACCORD SOFTWARE & SYSTEMS ( P ) Ltd','sdfsdf','yes','','','','51-125','','asdad','sfewarwer','20','40','30','899','89','d34','','','','','','Active','','Assembly','Active',NULL,'','2018-07-31','2018-07-31','Treated','bmandyam','2018-07-31','yes','FSI','','','','','','',0);
INSERT INTO `master_data` VALUES (7086,'zdfwqe',NULL,'ACCORD SOFTWARE & SYSTEMS ( P ) Ltd','asdw34','yes','','','','51-126','sfsdfsd','sfdsf','saf','40','10','30','777','77','d09','','','','','','Active','','Assembly','Active',NULL,'','2018-07-31','2018-07-31','Treated','bmandyam','2018-07-31','yes','FSI','','','','','','',0);
/*!40000 ALTER TABLE `master_data` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!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 2018-09-18 11:08:55
