-- MySQL dump 10.13  Distrib 5.5.28, for Win32 (x86)
--
-- Host: localhost    Database: empresa
-- ------------------------------------------------------
-- Server version	5.5.28

/*!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 `departamento`
--

DROP TABLE IF EXISTS `departamento`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `departamento` (
  `id_dept` char(4) NOT NULL,
  `nombre` varchar(40) NOT NULL,
  PRIMARY KEY (`id_dept`),
  UNIQUE KEY `nombre` (`nombre`),
  KEY `id_dept` (`id_dept`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `departamento`
--

LOCK TABLES `departamento` WRITE;
/*!40000 ALTER TABLE `departamento` DISABLE KEYS */;
INSERT INTO `departamento` VALUES ('VENT','VENTAS'),('COMP','COMPRAS'),('GERE','GERENCIA'),('FINA','FINANZAS'),('ADMI','ADMINISTRACION'),('RECH','RECURSOS HUMANOS'),('RECM','RECURSOS MATERIALES'),('MERC','MERCADOTECNIA');
/*!40000 ALTER TABLE `departamento` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dept_emp`
--

DROP TABLE IF EXISTS `dept_emp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dept_emp` (
  `id_emp` int(11) NOT NULL,
  `id_dept` char(4) NOT NULL,
  PRIMARY KEY (`id_emp`,`id_dept`),
  KEY `id_emp` (`id_emp`),
  KEY `id_dept` (`id_dept`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dept_emp`
--

LOCK TABLES `dept_emp` WRITE;
/*!40000 ALTER TABLE `dept_emp` DISABLE KEYS */;
INSERT INTO `dept_emp` VALUES (1,'VENT'),(2,'VENT'),(3,'COMP'),(4,'COMP'),(5,'GERE'),(6,'GERE'),(7,'FINA'),(8,'FINA'),(9,'ADMI'),(10,'ADMI'),(11,'RECH'),(12,'RECH'),(13,'RECM'),(14,'RECM'),(15,'MERC'),(16,'MERC'),(17,'FINA'),(18,'COMP'),(19,'VENT'),(20,'ADMI');
/*!40000 ALTER TABLE `dept_emp` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dept_manager`
--

DROP TABLE IF EXISTS `dept_manager`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dept_manager` (
  `id_dept` char(4) NOT NULL,
  `id_emp` int(11) NOT NULL,
  `fecha_inicio` date NOT NULL,
  `fecha_fin` date DEFAULT NULL,
  PRIMARY KEY (`id_emp`,`id_dept`),
  KEY `id_emp` (`id_emp`),
  KEY `id_dept` (`id_dept`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dept_manager`
--

LOCK TABLES `dept_manager` WRITE;
/*!40000 ALTER TABLE `dept_manager` DISABLE KEYS */;
INSERT INTO `dept_manager` VALUES ('VENT',2,'2011-01-01','2011-12-01'),('VENT',1,'2011-12-02',NULL),('COMP',4,'2012-01-01',NULL),('GERE',5,'2011-01-01',NULL),('FINA',17,'2011-01-01','2011-12-01'),('FINA',7,'2011-12-02',NULL),('ADMI',20,'2012-01-01',NULL),('RECH',11,'2011-01-01',NULL),('RECM',14,'2011-12-02',NULL),('MERC',15,'2012-01-01',NULL);
/*!40000 ALTER TABLE `dept_manager` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ejemplo`
--

DROP TABLE IF EXISTS `ejemplo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ejemplo` (
  `indice` int(11) NOT NULL AUTO_INCREMENT,
  `valor` varchar(100) DEFAULT 'numero',
  PRIMARY KEY (`indice`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ejemplo`
--

LOCK TABLES `ejemplo` WRITE;
/*!40000 ALTER TABLE `ejemplo` DISABLE KEYS */;
INSERT INTO `ejemplo` VALUES (6,'seis'),(7,'siete'),(8,'ocho'),(9,'nueve'),(10,'diez'),(11,'once'),(12,'doce'),(13,'trece'),(14,'catorce'),(15,'quince'),(16,'dieciseis'),(17,'diecisiete'),(18,'dieciocho'),(19,'diecinueve'),(20,'veinte');
/*!40000 ALTER TABLE `ejemplo` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `empleado`
--

DROP TABLE IF EXISTS `empleado`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `empleado` (
  `id_emp` int(11) NOT NULL AUTO_INCREMENT,
  `fecha_nac` date NOT NULL,
  `nombre` varchar(50) NOT NULL,
  `ap_pat` varchar(150) NOT NULL,
  `ap_mat` varchar(150) DEFAULT NULL,
  `sexo` enum('M','F') NOT NULL,
  `fecha_contratacion` date NOT NULL,
  PRIMARY KEY (`id_emp`),
  KEY `id_emp` (`id_emp`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `empleado`
--

LOCK TABLES `empleado` WRITE;
/*!40000 ALTER TABLE `empleado` DISABLE KEYS */;
INSERT INTO `empleado` VALUES (1,'1987-06-23','Ivan','Garcia','Banos','M','2012-01-01'),(2,'1988-07-23','Ilse','Garcia','Hernandez','F','2011-01-01'),(3,'1988-08-23','Fernanda','Mendez','Chavez','F','2012-01-01'),(4,'1989-09-23','Mariana','Perez','Gonzalez','F','2012-01-01'),(5,'1980-10-23','Armando','Perez','Hernandez','M','2011-01-01'),(6,'1980-10-03','Julio','Sanchez','Hernandez','M','2011-02-01'),(7,'1987-06-23','Armando','Ortega','Garcia','M','2012-01-01'),(8,'1988-07-23','Karla','Marquez','Hernandez','F','2011-01-01'),(9,'1988-08-23','Maria','Morales','Chavez','F','2012-01-01'),(10,'1989-09-23','Mariano','Perez','Gonzalez','M','2012-01-01'),(11,'1980-10-23','Adrian','Peralta','Cortes','M','2011-01-01'),(12,'1980-10-03','Joaquin','Del Valle','Marcelo','M','2011-02-01'),(13,'1987-06-23','Cristobal','Dasco','Plaz','M','2012-01-01'),(14,'1988-07-23','Francisca','Marcos','Fernandez','F','2011-01-01'),(15,'1988-08-23','Alejandra','Chavez','Gonzalez','F','2012-01-01'),(16,'1989-09-23','Lucila','Barajas','Mendez','F','2012-01-01'),(17,'1980-10-23','Daniel','Cipriano','Franco','M','2011-01-01'),(18,'1980-10-03','Andres','Flats','Mora','M','2011-02-01'),(19,'1987-06-23','Ivan','Larios','Cornejo','M','2012-01-01'),(20,'1988-07-23','Ariadna','Garcia','Flores','F','2011-01-01');
/*!40000 ALTER TABLE `empleado` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `puesto`
--

DROP TABLE IF EXISTS `puesto`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `puesto` (
  `id_emp` int(11) NOT NULL,
  `puesto` varchar(50) NOT NULL,
  `fecha_inicio` date NOT NULL,
  `fecha_fin` date DEFAULT NULL,
  PRIMARY KEY (`id_emp`,`fecha_inicio`),
  KEY `id_emp` (`id_emp`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `puesto`
--

LOCK TABLES `puesto` WRITE;
/*!40000 ALTER TABLE `puesto` DISABLE KEYS */;
INSERT INTO `puesto` VALUES (1,'Desarrollador SR.','2012-01-01',NULL),(3,'Desarrollador JR.','2012-01-01',NULL),(2,'Analista de Sistemas A.','2011-02-01',NULL),(4,'Analista de Sistemas B.','2012-01-01',NULL),(5,'Tecnico programador.','2011-01-01',NULL),(6,'Administrador.','2011-02-01',NULL),(7,'Desarrollador SR.','2012-01-01',NULL),(8,'Desarrollador JR.','2012-01-01',NULL),(9,'Gerente General.','2011-02-01',NULL),(10,'Director General.','2012-01-01',NULL),(11,'Subdirector.','2011-01-01',NULL),(12,'Gerente de Administracion.','2011-02-01',NULL),(13,'Gerente de Ventas.','2012-01-01',NULL),(14,'Operador Mecánico 1.','2012-01-01',NULL),(15,'Analista de Sistemas A.','2011-02-01',NULL),(16,'Operador Mecánico 2.','2012-01-01',NULL),(17,'Becario A.','2011-01-01',NULL),(18,'Becario B.','2011-02-01',NULL),(19,'Desarrollador SR.','2012-01-01',NULL),(20,'Desarrollador JR.','2012-01-01',NULL);
/*!40000 ALTER TABLE `puesto` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `salario`
--

DROP TABLE IF EXISTS `salario`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `salario` (
  `id_emp` int(11) NOT NULL,
  `salario` int(11) NOT NULL,
  `fecha_inicio` date NOT NULL,
  `fecha_fin` date DEFAULT NULL,
  PRIMARY KEY (`id_emp`,`fecha_inicio`),
  KEY `id_emp` (`id_emp`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `salario`
--

LOCK TABLES `salario` WRITE;
/*!40000 ALTER TABLE `salario` DISABLE KEYS */;
INSERT INTO `salario` VALUES (1,20000,'2012-01-01','2012-03-30'),(2,20000,'2011-01-01','2011-12-01'),(1,35000,'2012-04-01',NULL),(2,30000,'2012-01-01',NULL),(3,20000,'2012-01-01',NULL),(4,10000,'2012-01-01',NULL),(5,10000,'2011-01-01',NULL),(6,8000,'2011-02-01','2011-04-30'),(6,14500,'2011-05-01',NULL),(7,20000,'2012-01-01','2012-03-30'),(8,20000,'2011-01-01','2011-12-01'),(7,35000,'2012-04-01',NULL),(8,30000,'2012-01-01',NULL),(9,20000,'2012-01-01',NULL),(10,10000,'2012-01-01',NULL),(11,10000,'2011-01-01',NULL),(12,8000,'2011-02-01','2011-04-30'),(12,14500,'2011-05-01',NULL),(13,20000,'2012-01-01','2012-03-30'),(14,20000,'2011-01-01','2011-12-01'),(13,35000,'2012-04-01',NULL),(14,30000,'2012-01-01',NULL),(15,20000,'2012-01-01',NULL),(16,10000,'2012-01-01',NULL),(17,10000,'2011-01-01',NULL),(18,8000,'2011-02-01','2011-04-30'),(18,14500,'2011-05-01',NULL),(19,20000,'2012-01-01','2012-03-30'),(20,20000,'2011-01-01','2011-12-01'),(19,35000,'2012-04-01',NULL),(20,30000,'2012-01-01',NULL);
/*!40000 ALTER TABLE `salario` 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 2013-03-16 13:20:19