-- MySQL dump 10.16  Distrib 10.1.32-MariaDB, for Win32 (AMD64)
--
-- Host: localhost    Database: fluenterp1
-- ------------------------------------------------------
-- 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 `mc_capacity_master`
--

DROP TABLE IF EXISTS `mc_capacity_master`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mc_capacity_master` (
  `recnum` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `mc_id` varchar(45) DEFAULT NULL,
  `mc_name` varchar(45) DEFAULT NULL,
  `avail_capacity` float DEFAULT '0',
  `mc_series` varchar(45) DEFAULT NULL,
  `create_date` date DEFAULT '0000-00-00',
  `modified_date` date DEFAULT '0000-00-00',
  `created_by` varchar(65) DEFAULT NULL,
  `modified_by` varchar(65) DEFAULT NULL,
  `month` varchar(65) DEFAULT NULL,
  `year` varchar(65) DEFAULT NULL,
  `shift` int(11) NOT NULL,
  `units` varchar(50) NOT NULL,
  `siteid` varchar(45) DEFAULT NULL,
  `status` varchar(50) DEFAULT NULL,
  `oe` int(11) DEFAULT NULL,
  PRIMARY KEY (`recnum`)
) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mc_capacity_master`
--

LOCK TABLES `mc_capacity_master` WRITE;
/*!40000 ALTER TABLE `mc_capacity_master` DISABLE KEYS */;
INSERT INTO `mc_capacity_master` VALUES (1,'Slim3n-4AHS-1','Slim3n-4AHS-1',680,'Slim3n-4AHS-1','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(2,'Slim3n-4AHS-2','Slim3n-4AHS-2',680,'Slim3n-4AHS-2','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(3,'slim3n-5AHS-1','slim3n-5AHS-1',680,'slim3n-5AHS-1','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(4,'i700-1','i700-1',680,'i700-1','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(5,'DX 200-2','DX 200-2',680,'DX 200-2','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(6,'MakinoF5-3','MakinoF5-3',680,'MakinoF5-3','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(7,'QT100S-1','QT100S-1',680,'QT100S-1','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(8,'MakinoF5-1','MakinoF5-1',680,'MakinoF5-1','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(9,'HAASVF2SS-1','HAASVF2SS-1',680,'HAASVF2SS-1','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(10,'A51nx-1','A51nx-1',680,'A51nx-1','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(12,'VMC 70L','VMC 70L',680,'VMC 70L','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(13,'PS105-02','PS105-02',680,'PS105-02','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(14,'PS105-01','PS105-01',680,'PS105-01','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(15,'DX 200-1','DX 200-1',680,'DX 200-1','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(16,'HMC 440','HMC 440',680,'HMC 440','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(17,'HASSVF2SS','HASSVF2SS',680,'HASSVF2SS','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(18,'ST20','ST20',680,'ST20','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(19,'i700-3','i700-3',680,'i700-3','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(20,'HAAS VM6','HAAS VM6',680,'HAAS VM6','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(21,'UNIPRO 5000-1','UNIPRO 5000-1',680,'UNIPRO 5000-1','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(22,'LMW LX20T-1','LMW LX20T-1',680,'LMW LX20T-1','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(23,'ST20Y1','ST20Y1',680,'ST20Y1','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(24,'ST20Y','ST20Y',680,'ST20Y','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(25,'VM2-3','VM2-3',680,'VM2-3','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(26,'HASS VR11','HASS VR11',680,'HASS VR11','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(27,'BMV 60-1','BMV 60-1',680,'BMV 60-1','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(28,'QT100S-3','QT100S-3',680,'QT100S-3','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(29,'QT100S-5','QT100S-5',680,'QT100S-5','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(30,'Slim3n-4AHS-3','Slim3n-4AHS-3',680,'Slim3n-4AHS-3','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(31,'SLIM 3N-4AHS-3','SLIM 3N-4AHS-3',680,'SLIM 3N-4AHS-3','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(32,'MakinoF5-2','MakinoF5-2',680,'MakinoF5-2','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(33,'BMV 45-1','BMV 45-1',680,'BMV 45-1','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(34,'Slim3n-5AHS-2','Slim3n-5AHS-2',680,'Slim3n-5AHS-2','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(35,'HAASVF2SS-2','HAASVF2SS-2',680,'HAASVF2SS-2','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(36,'MakinoF3-1','MakinoF3-1',680,'MakinoF3-1','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(37,'DX 200-3','DX 200-3',680,'DX 200-3','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(38,'DX 200','DX 200',680,'DX 200','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(39,'MAKINO SLIM-1','MAKINO SLIM-1',680,'MAKINO SLIM-1','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(40,'BMV 45-2','BMV 45-2',680,'BMV 45-2','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(41,'QT100S-2','QT100S-2',680,'QT100S-2','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(42,'MV-02','MV-02',680,'MV-02','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(43,'QT100S-4','QT100S-4',680,'QT100S-4','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(44,'MakinoF5-4','MakinoF5-4',680,'MakinoF5-4','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(45,'200MY-01','200MY-01',680,'200MY-01','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(46,'100MY-01','100MY-01',680,'100MY-01','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(47,'MV-03','MV-03',680,'MV-03','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(48,'i700-5','i700-5',680,'i700-5','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(49,'a51nx-05','a51nx-05',680,'a51nx-05','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(50,'AC-1','AC-1',680,'AC-1','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(51,'a51nx-01','a51nx-01',680,'a51nx-01','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(52,'a51nx-02','a51nx-02',680,'a51nx-02','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(54,'i700-2','i700-2',680,'i700-2','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(55,'i700-4','i700-4',680,'i700-4','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(56,'DX200-4','DX200-4',680,'DX200-4','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(57,'MAKINO SLIM-2','MAKINO SLIM-2',680,'MAKINO SLIM-2','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(58,'VM2-2','VM2-2',680,'VM2-2','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(60,'DMG 360L','DMG 360L',680,'DMG 360L','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(61,'Slim3n-4AHS-4','Slim3n-4AHS-4',680,'Slim3n-4AHS-4','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(62,'VM-2','VM-2',680,'VM-2','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(63,'BMV 60-2','BMV 60-2',680,'BMV 60-2','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(64,'DX200-3','DX200-3',680,'DX200-3','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(65,'MV-04','MV-04',680,'MV-04','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(66,'a51nx-03','a51nx-03',680,'a51nx-03','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(67,'200MY-02','200MY-02',680,'200MY-02','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(68,'100MY-02','100MY-02',680,'100MY-02','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(69,'MV-01','MV-01',680,'MV-01','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(70,'a51nx-04','a51nx-04',680,'a51nx-04','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(71,'AC-2','AC-2',680,'AC-2','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(72,'VM2-1','VM2-1',680,'VM2-1','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85),(74,'MakinoF5-5','MakinoF5-5',680,'MakinoF5-5','2018-10-04','0000-00-00','Sales',NULL,NULL,NULL,2,'hrs','FSI','Active',85);
/*!40000 ALTER TABLE `mc_capacity_master` 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-11-20 18:03:22
