-- MySQL dump 10.13  Distrib 5.5.30, for Win32 (x86)
--
-- Host: localhost    Database: reporte
-- ------------------------------------------------------
-- Server version	5.5.16

/*!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 */;

--
-- Current Database: `reporte`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `reporte` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `reporte`;

--
-- Table structure for table `alumcar`
--

DROP TABLE IF EXISTS `alumcar`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `alumcar` (
  `codestu` char(3) NOT NULL,
  `codcarre` char(3) NOT NULL,
  KEY `codestu` (`codestu`),
  KEY `codcarre` (`codcarre`),
  CONSTRAINT `alumcar_ibfk_1` FOREIGN KEY (`codestu`) REFERENCES `alumno` (`codestu`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `alumcar_ibfk_2` FOREIGN KEY (`codcarre`) REFERENCES `carrera` (`codcarre`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `alumcar`
--

LOCK TABLES `alumcar` WRITE;
/*!40000 ALTER TABLE `alumcar` DISABLE KEYS */;
INSERT INTO `alumcar` VALUES ('001','002'),('003','005'),('005','001'),('001','005');
/*!40000 ALTER TABLE `alumcar` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `alumno`
--

DROP TABLE IF EXISTS `alumno`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `alumno` (
  `codestu` char(3) NOT NULL,
  `nombre` char(60) NOT NULL,
  `direccion` char(50) NOT NULL,
  `telefono` char(10) NOT NULL,
  PRIMARY KEY (`codestu`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `alumno`
--

LOCK TABLES `alumno` WRITE;
/*!40000 ALTER TABLE `alumno` DISABLE KEYS */;
INSERT INTO `alumno` VALUES ('001','Juan Tobon','Cra 59','2335698'),('002','Mario Gonzales','Cra 89','6325984'),('003','Federico Aguilar','Cra 26','4569782'),('004','Angel Cuadrado','Cra 44','6398521'),('005','Catalina Escobar','Cra 78','4652300'),('006','Paulina Borja','Cra 45','4599632');
/*!40000 ALTER TABLE `alumno` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `carrera`
--

DROP TABLE IF EXISTS `carrera`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `carrera` (
  `codcarre` char(3) NOT NULL,
  `carrera` char(30) NOT NULL,
  PRIMARY KEY (`codcarre`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `carrera`
--

LOCK TABLES `carrera` WRITE;
/*!40000 ALTER TABLE `carrera` DISABLE KEYS */;
INSERT INTO `carrera` VALUES ('001','Ingenieria de Sistemas'),('002','Contaduria'),('003','Economia'),('004','Derecho'),('005','Ingenieria Agropecuaria'),('006','Agronomia'),('007','Ciencias de la salud'),('008','Veterinaria');
/*!40000 ALTER TABLE `carrera` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `matricula`
--

DROP TABLE IF EXISTS `matricula`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `matricula` (
  `codmatri` char(3) NOT NULL,
  `codestu` char(3) NOT NULL,
  `codcarre` char(3) NOT NULL,
  `codprofe` char(3) NOT NULL,
  `valorsemestre` double unsigned NOT NULL,
  PRIMARY KEY (`codmatri`),
  KEY `codestu` (`codestu`),
  CONSTRAINT `matricula_ibfk_1` FOREIGN KEY (`codestu`) REFERENCES `alumno` (`codestu`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `matricula`
--

LOCK TABLES `matricula` WRITE;
/*!40000 ALTER TABLE `matricula` DISABLE KEYS */;
INSERT INTO `matricula` VALUES ('001','003','004','004',1800000),('002','001','008','003',3500000),('003','004','007','006',2800000),('004','002','007','006',1950000),('005','005','004','001',1800000),('006','003','008','003',3500000);
/*!40000 ALTER TABLE `matricula` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `profcar`
--

DROP TABLE IF EXISTS `profcar`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `profcar` (
  `codprofe` char(3) NOT NULL,
  `codcarre` char(3) NOT NULL,
  KEY `codprofe` (`codprofe`),
  KEY `codcarre` (`codcarre`),
  CONSTRAINT `profcar_ibfk_1` FOREIGN KEY (`codprofe`) REFERENCES `profesor` (`codprofe`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `profcar_ibfk_2` FOREIGN KEY (`codcarre`) REFERENCES `carrera` (`codcarre`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `profcar`
--

LOCK TABLES `profcar` WRITE;
/*!40000 ALTER TABLE `profcar` DISABLE KEYS */;
INSERT INTO `profcar` VALUES ('005','003'),('002','006'),('005','005'),('003','008'),('005','001'),('004','002'),('003','001'),('004','004'),('001','004'),('006','007');
/*!40000 ALTER TABLE `profcar` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `profesor`
--

DROP TABLE IF EXISTS `profesor`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `profesor` (
  `codprofe` char(3) NOT NULL,
  `nombre` char(60) NOT NULL,
  `direccion` char(50) NOT NULL,
  `telefono` char(10) NOT NULL,
  PRIMARY KEY (`codprofe`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `profesor`
--

LOCK TABLES `profesor` WRITE;
/*!40000 ALTER TABLE `profesor` DISABLE KEYS */;
INSERT INTO `profesor` VALUES ('001','Pablo Juan Gutierrez','cra 45-96','2569856'),('002','Enrique Saltamontes','cra 25-63','2365914'),('003','Portacio Cartagena','cra 36-01','4596321'),('004','Federico Aguilar','cra 56-41','7895624'),('005','Alberto Cifuentes','cra 20-30','7895002'),('006','Pascual Bravo','cra 56-41','5698741');
/*!40000 ALTER TABLE `profesor` 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-04-25  0:06:50