-- MySQL dump 10.13 Distrib 5.5.27, for Win32 (x86) -- -- Host: localhost Database: simatri -- ------------------------------------------------------ -- Server version 5.5.27 /*!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: `simatri` -- CREATE DATABASE /*!32312 IF NOT EXISTS*/ `simatri` /*!40100 DEFAULT CHARACTER SET latin1 */; USE `simatri`; -- -- Table structure for table `acudientes` -- DROP TABLE IF EXISTS `acudientes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `acudientes` ( `cedula_acu` char(10) NOT NULL, `nombre` char(50) NOT NULL, `telefono` char(10) NOT NULL, `email` char(50) DEFAULT NULL, PRIMARY KEY (`cedula_acu`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `acudientes` -- LOCK TABLES `acudientes` WRITE; /*!40000 ALTER TABLE `acudientes` DISABLE KEYS */; INSERT INTO `acudientes` VALUES ('acu01','Diana Lopez','3102441','dimace15@hotmail.com'),('acu02','ACEVEDO CARDONA ESTEBAN','5846069','estebacardona@gmail.com'),('acu03','AGUDELO MANCO DIANA PATRICIA','5882104','dianapatricia@gmail.com'),('acu04','ZPATA VALENCIA JORGE','5841998','jorgezapata@gmail.com'),('acu05','VELASQUEZ CANO JENNY ASTRID','2791469','jennyvelasquez@gmail.com'),('acu06','POSADA VASCO ANA','2868617','anaposada@gmail.com'),('acu07','ORTIZ PUERTA INDIRA','5841497','indiraortiz@gmail.com'),('acu08','QUINTERO MENESES ADRIANA MARIA','5840570','adrianaquintero@gmail.com'),('acu09','MONTOYA RIVERA EDILMA','3767289','edilmamontoya@gmail.com'),('acu10','LOPERA MONSALVE FERNANDO ALONSO','5709957','fernandolopera@gmail.com'),('acu11','HENAO RIOS DORA EMILSE','2866222','dorahenao@gmail.com'); /*!40000 ALTER TABLE `acudientes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `doc_mat` -- DROP TABLE IF EXISTS `doc_mat`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `doc_mat` ( `cdoc` char(10) NOT NULL, `cmat` char(10) NOT NULL, KEY `cdoc` (`cdoc`), KEY `cmat` (`cmat`), CONSTRAINT `doc_mat_ibfk_1` FOREIGN KEY (`cdoc`) REFERENCES `docentes` (`cdoc`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `doc_mat_ibfk_2` FOREIGN KEY (`cmat`) REFERENCES `materias` (`cmat`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `doc_mat` -- LOCK TABLES `doc_mat` WRITE; /*!40000 ALTER TABLE `doc_mat` DISABLE KEYS */; /*!40000 ALTER TABLE `doc_mat` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `docentes` -- DROP TABLE IF EXISTS `docentes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `docentes` ( `cdoc` char(10) NOT NULL, `nombre` char(50) NOT NULL, `telefono` char(10) NOT NULL, `email` char(50) NOT NULL, PRIMARY KEY (`cdoc`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `docentes` -- LOCK TABLES `docentes` WRITE; /*!40000 ALTER TABLE `docentes` DISABLE KEYS */; INSERT INTO `docentes` VALUES ('doc01','CIFUENTES MESA MYEIDY MARIA','2124578','myleidym.iearm@gmail.com'),('doc02','CUADRADO PEREZ ADRID JOSE','5421874','adrid.iearm@gmail.com'),('doc03','DUQUE RESTREPO ESTER LUCIA','2356894','esterl.iearm@gmail.com'),('doc04','GUIRALES MAURICIO','5412458','mauriciog.iearm@gmail.com'),('doc05','VERA DAZA MARIA ELENA','2541258','mariae.iearm@gmail.com'),('doc06','PALACIO TOMAS FELIPE','4512589','tomasf.iearm@gmail.com'),('doc07','MOSUERA OSORIO MARYETH','124578','maryeth.iearm@gmail.com'),('doc08','ARBOLEDA VARGAS MARIA OFELIA','326598','ofeliaa.iearm@gmail.com'),('doc09','MOSCOTE JARRON YANET MARIA','2121212','yanet.laloca@hotmail.com'); /*!40000 ALTER TABLE `docentes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `est_acu` -- DROP TABLE IF EXISTS `est_acu`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `est_acu` ( `cest` char(10) NOT NULL, `cedula_acu` char(10) NOT NULL, KEY `cest` (`cest`), KEY `cedula_acu` (`cedula_acu`), CONSTRAINT `est_acu_ibfk_1` FOREIGN KEY (`cest`) REFERENCES `estudiantes` (`cest`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `est_acu_ibfk_2` FOREIGN KEY (`cedula_acu`) REFERENCES `acudientes` (`cedula_acu`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `est_acu` -- LOCK TABLES `est_acu` WRITE; /*!40000 ALTER TABLE `est_acu` DISABLE KEYS */; /*!40000 ALTER TABLE `est_acu` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `est_mat` -- DROP TABLE IF EXISTS `est_mat`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `est_mat` ( `cest` char(10) NOT NULL, `cmat` char(10) NOT NULL, KEY `cest` (`cest`), KEY `cmat` (`cmat`), CONSTRAINT `est_mat_ibfk_1` FOREIGN KEY (`cest`) REFERENCES `estudiantes` (`cest`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `est_mat_ibfk_2` FOREIGN KEY (`cmat`) REFERENCES `materias` (`cmat`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `est_mat` -- LOCK TABLES `est_mat` WRITE; /*!40000 ALTER TABLE `est_mat` DISABLE KEYS */; /*!40000 ALTER TABLE `est_mat` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `estudiantes` -- DROP TABLE IF EXISTS `estudiantes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `estudiantes` ( `cest` char(10) NOT NULL, `nombre` char(50) NOT NULL, `direccion` char(50) NOT NULL, `telefono` char(10) NOT NULL, `email` char(50) DEFAULT NULL, PRIMARY KEY (`cest`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `estudiantes` -- LOCK TABLES `estudiantes` WRITE; /*!40000 ALTER TABLE `estudiantes` DISABLE KEYS */; INSERT INTO `estudiantes` VALUES ('Est01','ACEVEDO BURITICA JUAN ESTEBAN','Barrio la pradera','5846069','juanestebacardona@gmail.com'),('Est03','ZAPATA CAMPIÑO ISABEL','Barrio Aragon','5841998','zapataisabel@gmail.com'),('Est04','VALLE VELASQUEZ SOFIA','Barrio la pradera','2791469','sofiavelasquez@gmail.com'),('Est05','MORENO POSADA JUAN ALEJANDRO','Urbanizacion compartir','2868617','jumopo@remington.edu.co'),('Est06','LZATE ORTIZ JORGE MARIO','Urbanización ciudadela prado','5841497','marioalzae@gmail.com'),('Est07','ZAPATA QUINTERO JOSE MARIA','Barrio Sangabriel','5840570','josezapata@gmail.com'),('Est08','MNTOYA MONTOYA AEJANDRO','Barrio la pradera','3767289','alejandromontoya@gmail.com'),('Est09','LOPERA CARTAGENA LUISA FENANADA','Barrio el limonar 1','5709957','luisalopera@gmail.com'),('Est10','JARAMILLO HENAO JOSE LUIS','Barrio el limonar2','2866222','josearamillo@gmail.com'),('Est11','Milena Arboleda','Calle 11','2147852','mida@hotmail.com'); /*!40000 ALTER TABLE `estudiantes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `materias` -- DROP TABLE IF EXISTS `materias`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `materias` ( `cmat` char(10) NOT NULL, `materia` char(50) NOT NULL, PRIMARY KEY (`cmat`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `materias` -- LOCK TABLES `materias` WRITE; /*!40000 ALTER TABLE `materias` DISABLE KEYS */; INSERT INTO `materias` VALUES ('mat01','ESPAÑOL'),('mat02','LECTOESRITURA'),('mat03','MATEMATICAS'),('mat04','CIENCIAS NATURALES'),('mat05','INVESTIGACION'),('mat06','FISICA'),('mat07','FILOSOFIA'),('mat08','EDUCACION FISICA'),('mat09','BIOLOGIA'); /*!40000 ALTER TABLE `materias` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping routines for database 'simatri' -- /*!50003 DROP PROCEDURE IF EXISTS `consul_acu` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8 */ ; /*!50003 SET character_set_results = utf8 */ ; /*!50003 SET collation_connection = utf8_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = '' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 PROCEDURE `consul_acu`(in cedula char(10)) BEGIN select * from acudientes where cedula=cedula_acu; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `consul_doc` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8 */ ; /*!50003 SET character_set_results = utf8 */ ; /*!50003 SET collation_connection = utf8_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = '' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 PROCEDURE `consul_doc`(in codigo char(10)) BEGIN select * from docentes where codigo=cdoc; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `consul_est` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8 */ ; /*!50003 SET character_set_results = utf8 */ ; /*!50003 SET collation_connection = utf8_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = '' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 PROCEDURE `consul_est`(in carnet char(10)) BEGIN select * from estudiantes where carnet=cest; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `consul_mat` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8 */ ; /*!50003 SET character_set_results = utf8 */ ; /*!50003 SET collation_connection = utf8_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = '' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 PROCEDURE `consul_mat`(in codigo char(10)) BEGIN select * from materias where codigo=cmat; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `eliminar_acu` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8 */ ; /*!50003 SET character_set_results = utf8 */ ; /*!50003 SET collation_connection = utf8_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = '' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 PROCEDURE `eliminar_acu`(in cedula char(10)) BEGIN delete from acudientes where cedula=cedula_acu; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `eliminar_doc` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8 */ ; /*!50003 SET character_set_results = utf8 */ ; /*!50003 SET collation_connection = utf8_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = '' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 PROCEDURE `eliminar_doc`(in codigo char(10)) BEGIN delete from docentes where codigo=cdoc; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `eliminar_est` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8 */ ; /*!50003 SET character_set_results = utf8 */ ; /*!50003 SET collation_connection = utf8_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = '' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 PROCEDURE `eliminar_est`(in codigo char(10)) BEGIN delete from estudiantes where codigo=cest; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `eliminar_mat` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8 */ ; /*!50003 SET character_set_results = utf8 */ ; /*!50003 SET collation_connection = utf8_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = '' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 PROCEDURE `eliminar_mat`(in codigo char(10)) BEGIN delete from materias where codigo=cmat; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `inser_acu` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8 */ ; /*!50003 SET character_set_results = utf8 */ ; /*!50003 SET collation_connection = utf8_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = '' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 PROCEDURE `inser_acu`(in cedula_acu char(10), in nombre char(50), in telefono char(10), in email char(50)) BEGIN insert into acudientes values(cedula_acu,nombre,telefono,email); END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `inser_doc` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = cp850 */ ; /*!50003 SET character_set_results = cp850 */ ; /*!50003 SET collation_connection = cp850_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = '' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 PROCEDURE `inser_doc`(in cdoc char(10), in nombre char(50), in telefono char(10), in email char(50)) begin insert into docentes values(cdoc,nombre,telefono,email); end */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `inser_est` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8 */ ; /*!50003 SET character_set_results = utf8 */ ; /*!50003 SET collation_connection = utf8_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = '' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 PROCEDURE `inser_est`(in cest char(10), in nombre char(50), in direccion char(50), in telefono char(10), in email char(50)) BEGIN insert into estudiantes values(cest,nombre,direccion,telefono,email); END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `inser_mat` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = cp850 */ ; /*!50003 SET character_set_results = cp850 */ ; /*!50003 SET collation_connection = cp850_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = '' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 PROCEDURE `inser_mat`(in cmat char(10), in materia char(50)) begin insert into materias values(cmat,materia); end */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `listar_acu` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8 */ ; /*!50003 SET character_set_results = utf8 */ ; /*!50003 SET collation_connection = utf8_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = '' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 PROCEDURE `listar_acu`() BEGIN select * from acudientes; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `listar_doc` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8 */ ; /*!50003 SET character_set_results = utf8 */ ; /*!50003 SET collation_connection = utf8_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = '' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 PROCEDURE `listar_doc`() BEGIN select * from docentes; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `listar_est` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8 */ ; /*!50003 SET character_set_results = utf8 */ ; /*!50003 SET collation_connection = utf8_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = '' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 PROCEDURE `listar_est`() BEGIN select * from estudiantes; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `listar_mat` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8 */ ; /*!50003 SET character_set_results = utf8 */ ; /*!50003 SET collation_connection = utf8_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = '' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 PROCEDURE `listar_mat`() BEGIN select * from materias; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `modi_acu` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8 */ ; /*!50003 SET character_set_results = utf8 */ ; /*!50003 SET collation_connection = utf8_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = '' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 PROCEDURE `modi_acu`(in cedula char(10), in nom char(50), in tel char(10), in correo char(50)) BEGIN update acudientes set nombre=nom, telefono=tel, email=correo where cedula_acu=cedula; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `modi_doc` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8 */ ; /*!50003 SET character_set_results = utf8 */ ; /*!50003 SET collation_connection = utf8_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = '' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 PROCEDURE `modi_doc`(in cod char(10), in nom char(50), in tel char(10), in correo char(50)) BEGIN update docentes set nombre=nom, telefono=tel, email=correo where cdoc=cod; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `modi_est` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8 */ ; /*!50003 SET character_set_results = utf8 */ ; /*!50003 SET collation_connection = utf8_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = '' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 PROCEDURE `modi_est`(in cod char(10), in nom char(50), in dir char(50), in tel char(10), in correo char(50)) BEGIN update estudiantes set nombre=nom, direccion=dir, telefono=tel, email=correo where cest=cod; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `modi_mat` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8 */ ; /*!50003 SET character_set_results = utf8 */ ; /*!50003 SET collation_connection = utf8_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = '' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 PROCEDURE `modi_mat`(in cod char(10), in mat char(50)) BEGIN update materias set materia=mat where cmat=cod; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!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-08-26 19:25:54