/*
SQLyog Community Edition- MySQL GUI v6.05
Host - 5.0.24a-community-nt-log : Database - directorios
*********************************************************************
Server version : 5.0.24a-community-nt-log
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

create database if not exists `directorios`;

USE `directorios`;

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

/*Table structure for table `admin` */

DROP TABLE IF EXISTS `admin`;

CREATE TABLE `admin` (
  `cod_admin` decimal(3,0) NOT NULL default '0',
  `usuario` varchar(10) NOT NULL default '',
  `clave` varchar(10) NOT NULL default '',
  PRIMARY KEY  (`cod_admin`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `admin` */

insert  into `admin`(`cod_admin`,`usuario`,`clave`) values ('1','juan','apache');

/*Table structure for table `correo` */

DROP TABLE IF EXISTS `correo`;

CREATE TABLE `correo` (
  `cod_correo` decimal(10,0) NOT NULL default '0',
  `correo` varchar(50) NOT NULL default '',
  `cod_persona` decimal(10,0) NOT NULL,
  PRIMARY KEY  (`cod_correo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `correo` */

insert  into `correo`(`cod_correo`,`correo`,`cod_persona`) values ('1','correo@uni.com','0'),('5','ines@gmail.com','12'),('6','arroba@g.com','0'),('10','yoli@hotmail.com','15'),('12','jjesus@heaven.com','13'),('13','lalos@g.com','14'),('14','yoyo@hotmail.com','16');

/*Table structure for table `correos` */

DROP TABLE IF EXISTS `correos`;

/*!50001 DROP VIEW IF EXISTS `correos` */;
/*!50001 DROP TABLE IF EXISTS `correos` */;

/*!50001 CREATE TABLE `correos` (
  `cod_correo` decimal(10,0) NOT NULL default '0',
  `correo` varchar(50) NOT NULL default '',
  `cod_persona` decimal(10,0) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 */;

/*Table structure for table `datospersona` */

DROP TABLE IF EXISTS `datospersona`;

/*!50001 DROP VIEW IF EXISTS `datospersona` */;
/*!50001 DROP TABLE IF EXISTS `datospersona` */;

/*!50001 CREATE TABLE `datospersona` (
  `cod_persona` decimal(10,0) NOT NULL default '0',
  `nombre` varchar(50) NOT NULL default '',
  `apellido` varchar(50) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8 */;

/*Table structure for table `dependencia` */

DROP TABLE IF EXISTS `dependencia`;

CREATE TABLE `dependencia` (
  `cod_dependencia` decimal(10,0) NOT NULL default '0',
  `dependencia` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`cod_dependencia`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `dependencia` */

insert  into `dependencia`(`cod_dependencia`,`dependencia`) values ('1','Estudios'),('2','Sala'),('3','Bienestar'),('4','Facultad de Ingenieria'),('5','Planeacion'),('6','casita vieja');

/*Table structure for table `dependencias` */

DROP TABLE IF EXISTS `dependencias`;

/*!50001 DROP VIEW IF EXISTS `dependencias` */;
/*!50001 DROP TABLE IF EXISTS `dependencias` */;

/*!50001 CREATE TABLE `dependencias` (
  `cod_dependencia` decimal(10,0) NOT NULL default '0',
  `dependencia` varchar(50) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8 */;

/*Table structure for table `extension` */

DROP TABLE IF EXISTS `extension`;

CREATE TABLE `extension` (
  `cod_extension` decimal(10,0) NOT NULL,
  `extension` decimal(4,0) NOT NULL,
  PRIMARY KEY  (`cod_extension`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

/*Data for the table `extension` */

insert  into `extension`(`cod_extension`,`extension`) values ('1','123'),('2','254'),('3','456'),('4','786'),('5','594'),('6','982'),('7','300');

/*Table structure for table `extensiones` */

DROP TABLE IF EXISTS `extensiones`;

/*!50001 DROP VIEW IF EXISTS `extensiones` */;
/*!50001 DROP TABLE IF EXISTS `extensiones` */;

/*!50001 CREATE TABLE `extensiones` (
  `cod_extension` decimal(10,0) NOT NULL,
  `extension` decimal(4,0) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 */;

/*Table structure for table `extensionesxpersona` */

DROP TABLE IF EXISTS `extensionesxpersona`;

/*!50001 DROP VIEW IF EXISTS `extensionesxpersona` */;
/*!50001 DROP TABLE IF EXISTS `extensionesxpersona` */;

/*!50001 CREATE TABLE `extensionesxpersona` (
  `cod` decimal(10,0) NOT NULL,
  `extension` decimal(4,0) NOT NULL,
  `persona` decimal(10,0) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 */;

/*Table structure for table `maxcodcorreo` */

DROP TABLE IF EXISTS `maxcodcorreo`;

/*!50001 DROP VIEW IF EXISTS `maxcodcorreo` */;
/*!50001 DROP TABLE IF EXISTS `maxcodcorreo` */;

/*!50001 CREATE TABLE `maxcodcorreo` (
  `codcorreo` decimal(11,0) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 */;

/*Table structure for table `maxcoddependencia` */

DROP TABLE IF EXISTS `maxcoddependencia`;

/*!50001 DROP VIEW IF EXISTS `maxcoddependencia` */;
/*!50001 DROP TABLE IF EXISTS `maxcoddependencia` */;

/*!50001 CREATE TABLE `maxcoddependencia` (
  `cod` decimal(11,0) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 */;

/*Table structure for table `maxcodextension` */

DROP TABLE IF EXISTS `maxcodextension`;

/*!50001 DROP VIEW IF EXISTS `maxcodextension` */;
/*!50001 DROP TABLE IF EXISTS `maxcodextension` */;

/*!50001 CREATE TABLE `maxcodextension` (
  `cod` decimal(11,0) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 */;

/*Table structure for table `maxcodigo` */

DROP TABLE IF EXISTS `maxcodigo`;

/*!50001 DROP VIEW IF EXISTS `maxcodigo` */;
/*!50001 DROP TABLE IF EXISTS `maxcodigo` */;

/*!50001 CREATE TABLE `maxcodigo` (
  `cod` decimal(11,0) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 */;

/*Table structure for table `maxcodtelefono` */

DROP TABLE IF EXISTS `maxcodtelefono`;

/*!50001 DROP VIEW IF EXISTS `maxcodtelefono` */;
/*!50001 DROP TABLE IF EXISTS `maxcodtelefono` */;

/*!50001 CREATE TABLE `maxcodtelefono` (
  `cod` decimal(11,0) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 */;

/*Table structure for table `namedependencia` */

DROP TABLE IF EXISTS `namedependencia`;

/*!50001 DROP VIEW IF EXISTS `namedependencia` */;
/*!50001 DROP TABLE IF EXISTS `namedependencia` */;

/*!50001 CREATE TABLE `namedependencia` (
  `dependencia` varchar(50) NOT NULL default '',
  `cod_persona` decimal(10,0) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 */;

/*Table structure for table `persona` */

DROP TABLE IF EXISTS `persona`;

CREATE TABLE `persona` (
  `cod_persona` decimal(10,0) NOT NULL default '0',
  `nombre` varchar(50) NOT NULL default '',
  `apellido` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`cod_persona`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `persona` */

insert  into `persona`(`cod_persona`,`nombre`,`apellido`) values ('11','Juan Carlos Julio Jairo','Leon'),('12','Ines','Jimenez'),('13','Juan','Jesus'),('14','Lalos','Ques'),('15','Yolima del Pilar','Jimenez Carrillo'),('16','Yolima','Jimenez');

/*Table structure for table `personaxdependencia` */

DROP TABLE IF EXISTS `personaxdependencia`;

CREATE TABLE `personaxdependencia` (
  `cod_persona` decimal(10,0) NOT NULL default '0',
  `cod_dependencia` decimal(10,0) NOT NULL default '0',
  PRIMARY KEY  (`cod_persona`),
  KEY `foreign` (`cod_persona`),
  KEY `foreign2` (`cod_dependencia`),
  CONSTRAINT `personaxdependencia_ibfk_1` FOREIGN KEY (`cod_persona`) REFERENCES `persona` (`cod_persona`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `personaxdependencia_ibfk_2` FOREIGN KEY (`cod_dependencia`) REFERENCES `dependencia` (`cod_dependencia`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `personaxdependencia` */

insert  into `personaxdependencia`(`cod_persona`,`cod_dependencia`) values ('11','1'),('12','1'),('13','1'),('15','5'),('16','6');

/*Table structure for table `personaxextension` */

DROP TABLE IF EXISTS `personaxextension`;

CREATE TABLE `personaxextension` (
  `cod_persona` decimal(10,0) NOT NULL,
  `cod_extension` decimal(10,0) NOT NULL,
  PRIMARY KEY  (`cod_persona`,`cod_extension`),
  KEY `cod_extension` (`cod_extension`),
  CONSTRAINT `FK_personaxextension` FOREIGN KEY (`cod_persona`) REFERENCES `persona` (`cod_persona`),
  CONSTRAINT `FK_personaxextension2` FOREIGN KEY (`cod_extension`) REFERENCES `extension` (`cod_extension`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

/*Data for the table `personaxextension` */

insert  into `personaxextension`(`cod_persona`,`cod_extension`) values ('11','1'),('13','2'),('12','3'),('15','3'),('14','4'),('15','5'),('15','6'),('16','7');

/*Table structure for table `sessions` */

DROP TABLE IF EXISTS `sessions`;

CREATE TABLE `sessions` (
  `session_id` varchar(100) NOT NULL default '',
  `session_data` text NOT NULL,
  `expires` int(11) NOT NULL default '0',
  `ip` varchar(12) NOT NULL,
  PRIMARY KEY  (`session_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `sessions` */

insert  into `sessions`(`session_id`,`session_data`,`expires`,`ip`) values ('','',0,'');

/*Table structure for table `telefono` */

DROP TABLE IF EXISTS `telefono`;

CREATE TABLE `telefono` (
  `cod_telefono` decimal(10,0) NOT NULL default '0',
  `telefono` varchar(12) NOT NULL default '',
  `cod_dependencia` decimal(10,0) NOT NULL,
  PRIMARY KEY  (`cod_telefono`),
  KEY `telefono` (`cod_dependencia`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `telefono` */

insert  into `telefono`(`cod_telefono`,`telefono`,`cod_dependencia`) values ('1','5781917','1'),('2','3157255659','3'),('3','3103446622','0'),('4','3156407982','5'),('5','5753763','0'),('6','5781937','0'),('7','567890','6');

/*Table structure for table `telefonos` */

DROP TABLE IF EXISTS `telefonos`;

/*!50001 DROP VIEW IF EXISTS `telefonos` */;
/*!50001 DROP TABLE IF EXISTS `telefonos` */;

/*!50001 CREATE TABLE `telefonos` (
  `cod_telefono` decimal(10,0) NOT NULL default '0',
  `telefono` varchar(12) NOT NULL default '',
  `cod_dependencia` decimal(10,0) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 */;

/*View structure for view correos */

/*!50001 DROP TABLE IF EXISTS `correos` */;
/*!50001 DROP VIEW IF EXISTS `correos` */;

/*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `correos` AS (select `correo`.`cod_correo` AS `cod_correo`,`correo`.`correo` AS `correo`,`correo`.`cod_persona` AS `cod_persona` from `correo`) */;

/*View structure for view datospersona */

/*!50001 DROP TABLE IF EXISTS `datospersona` */;
/*!50001 DROP VIEW IF EXISTS `datospersona` */;

/*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `datospersona` AS (select `persona`.`cod_persona` AS `cod_persona`,`persona`.`nombre` AS `nombre`,`persona`.`apellido` AS `apellido` from `persona`) */;

/*View structure for view dependencias */

/*!50001 DROP TABLE IF EXISTS `dependencias` */;
/*!50001 DROP VIEW IF EXISTS `dependencias` */;

/*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `dependencias` AS (select `dependencia`.`cod_dependencia` AS `cod_dependencia`,`dependencia`.`dependencia` AS `dependencia` from `dependencia`) */;

/*View structure for view extensiones */

/*!50001 DROP TABLE IF EXISTS `extensiones` */;
/*!50001 DROP VIEW IF EXISTS `extensiones` */;

/*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `extensiones` AS (select `extension`.`cod_extension` AS `cod_extension`,`extension`.`extension` AS `extension` from `extension`) */;

/*View structure for view extensionesxpersona */

/*!50001 DROP TABLE IF EXISTS `extensionesxpersona` */;
/*!50001 DROP VIEW IF EXISTS `extensionesxpersona` */;

/*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `extensionesxpersona` AS (select `e`.`cod_extension` AS `cod`,`e`.`extension` AS `extension`,`p`.`cod_persona` AS `persona` from ((`extension` `e` join `persona` `p`) join `personaxextension` `pxe`) where ((`e`.`cod_extension` = `pxe`.`cod_extension`) and (`p`.`cod_persona` = `pxe`.`cod_persona`))) */;

/*View structure for view maxcodcorreo */

/*!50001 DROP TABLE IF EXISTS `maxcodcorreo` */;
/*!50001 DROP VIEW IF EXISTS `maxcodcorreo` */;

/*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `maxcodcorreo` AS (select max((`correo`.`cod_correo` + 1)) AS `codcorreo` from `correo`) */;

/*View structure for view maxcoddependencia */

/*!50001 DROP TABLE IF EXISTS `maxcoddependencia` */;
/*!50001 DROP VIEW IF EXISTS `maxcoddependencia` */;

/*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `maxcoddependencia` AS (select max((`dependencia`.`cod_dependencia` + 1)) AS `cod` from `dependencia`) */;

/*View structure for view maxcodextension */

/*!50001 DROP TABLE IF EXISTS `maxcodextension` */;
/*!50001 DROP VIEW IF EXISTS `maxcodextension` */;

/*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `maxcodextension` AS (select max((`extension`.`cod_extension` + 1)) AS `cod` from `extension`) */;

/*View structure for view maxcodigo */

/*!50001 DROP TABLE IF EXISTS `maxcodigo` */;
/*!50001 DROP VIEW IF EXISTS `maxcodigo` */;

/*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `maxcodigo` AS (select max((`persona`.`cod_persona` + 1)) AS `cod` from `persona`) */;

/*View structure for view maxcodtelefono */

/*!50001 DROP TABLE IF EXISTS `maxcodtelefono` */;
/*!50001 DROP VIEW IF EXISTS `maxcodtelefono` */;

/*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `maxcodtelefono` AS (select max((`telefono`.`cod_telefono` + 1)) AS `cod` from `telefono`) */;

/*View structure for view namedependencia */

/*!50001 DROP TABLE IF EXISTS `namedependencia` */;
/*!50001 DROP VIEW IF EXISTS `namedependencia` */;

/*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `namedependencia` AS (select `d`.`dependencia` AS `dependencia`,`pxd`.`cod_persona` AS `cod_persona` from (`personaxdependencia` `pxd` join `dependencia` `d`) where (`pxd`.`cod_dependencia` = `d`.`cod_dependencia`)) */;

/*View structure for view telefonos */

/*!50001 DROP TABLE IF EXISTS `telefonos` */;
/*!50001 DROP VIEW IF EXISTS `telefonos` */;

/*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `telefonos` AS (select `telefono`.`cod_telefono` AS `cod_telefono`,`telefono`.`telefono` AS `telefono`,`telefono`.`cod_dependencia` AS `cod_dependencia` from `telefono`) */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;