-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version 5.0.27-community-nt
/*!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 */;
/*!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' */;
--
-- Create schema teleasistencia
--
CREATE DATABASE IF NOT EXISTS teleasistencia;
USE teleasistencia;
--
-- Definition of table `ambulancias`
--
DROP TABLE IF EXISTS `ambulancias`;
CREATE TABLE `ambulancias` (
`codigo` int(10) unsigned NOT NULL auto_increment,
`MSISDN` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`codigo`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `ambulancias`
--
/*!40000 ALTER TABLE `ambulancias` DISABLE KEYS */;
INSERT INTO `ambulancias` (`codigo`,`MSISDN`) VALUES
(1,180111111111),
(2,180222222222);
/*!40000 ALTER TABLE `ambulancias` ENABLE KEYS */;
--
-- Definition of table `cuidadores`
--
DROP TABLE IF EXISTS `cuidadores`;
CREATE TABLE `cuidadores` (
`id_cuidador` int(8) unsigned NOT NULL,
`MSISDN` bigint(20) unsigned NOT NULL,
`nombre` varchar(20) NOT NULL,
`apellido1` varchar(20) NOT NULL,
`apellido2` varchar(20) NOT NULL,
PRIMARY KEY (`id_cuidador`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `cuidadores`
--
/*!40000 ALTER TABLE `cuidadores` DISABLE KEYS */;
INSERT INTO `cuidadores` (`id_cuidador`,`MSISDN`,`nombre`,`apellido1`,`apellido2`) VALUES
(12345678,170222222222,'Antonio','Alcantara','Moral'),
(29644735,170333333333,'Manuel','Chica','Moral'),
(45892500,170444444444,'Manuel','Quesada','Armenteros'),
(58912307,170555555555,'Juan','Pancorbo','Hernandez'),
(67834133,170666666666,'David','De La Rosa','Blanca'),
(77351012,170111111111,'Rafael','Fernandez','Lopez'),
(89431733,170777777777,'Pedro Jose','Cañada','Arevalo');
/*!40000 ALTER TABLE `cuidadores` ENABLE KEYS */;
--
-- Definition of table `estadopacloc`
--
DROP TABLE IF EXISTS `estadopacloc`;
CREATE TABLE `estadopacloc` (
`MSISDN` bigint(20) unsigned NOT NULL,
`estadoLoc` int(10) unsigned NOT NULL,
PRIMARY KEY (`MSISDN`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `estadopacloc`
--
/*!40000 ALTER TABLE `estadopacloc` DISABLE KEYS */;
INSERT INTO `estadopacloc` (`MSISDN`,`estadoLoc`) VALUES
(150111111111,1),
(150222222222,1),
(150333333333,1),
(150444444444,1);
/*!40000 ALTER TABLE `estadopacloc` ENABLE KEYS */;
--
-- Definition of table `pacientes`
--
DROP TABLE IF EXISTS `pacientes`;
CREATE TABLE `pacientes` (
`id_paciente` int(8) unsigned NOT NULL COMMENT 'dni',
`MSISDN` bigint(20) unsigned NOT NULL COMMENT 'numero de abonado',
`nombre` varchar(20) NOT NULL,
`apellido1` varchar(20) NOT NULL,
`apellido2` varchar(20) NOT NULL,
`id_cuidador` int(8) unsigned NOT NULL,
`longitud` double default NULL,
`latitud` double default NULL,
PRIMARY KEY (`id_paciente`),
KEY `FK_cuidadores` (`id_cuidador`),
CONSTRAINT `FK_cuidadores` FOREIGN KEY (`id_cuidador`) REFERENCES `cuidadores` (`id_cuidador`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `pacientes`
--
/*!40000 ALTER TABLE `pacientes` DISABLE KEYS */;
INSERT INTO `pacientes` (`id_paciente`,`MSISDN`,`nombre`,`apellido1`,`apellido2`,`id_cuidador`,`longitud`,`latitud`) VALUES
(10000000,150100000000,'Maria Dolores','Eliche','Luque',77351012,NULL,NULL),
(11111111,150111111111,'Fernando','Parras','Vizcaino',77351012,-5.98466,37.38911),
(20000000,150200000000,'Manuel','Parras','Linde',77351012,NULL,NULL),
(22222222,150222222222,'Carmen','Linde','xxxxxxxx',12345678,-5.97153,37.39874),
(30000000,150300000000,'Ana','Arroyo','Moral',77351012,NULL,NULL),
(33333333,150333333333,'Antonia','Luque','Capiscol',29644735,-5.9281,37.383808),
(44444444,150444444444,'Manuel','Eliche','Sanchez',29644735,-5.95931,37.37933),
(55555555,150555555555,'Luis Carlos','Camacho','Mateo',77351012,NULL,NULL),
(66666666,150666666666,'Antonio','Cea','Roldán',77351012,NULL,NULL),
(77777777,150777777777,'Carlos','Gutierrez','Carrasco',77351012,NULL,NULL),
(88888888,150888888888,'Rafael','Sillero','Acosta',77351012,NULL,NULL),
(99999999,150999999999,'Sara','Parras','Eliche',77351012,NULL,NULL);
/*!40000 ALTER TABLE `pacientes` ENABLE KEYS */;
--
-- Definition of table `servicios_contratados`
--
DROP TABLE IF EXISTS `servicios_contratados`;
CREATE TABLE `servicios_contratados` (
`codigo` int(10) unsigned NOT NULL auto_increment,
`id_paciente` int(8) unsigned NOT NULL,
`cod_alarma` int(3) unsigned NOT NULL,
PRIMARY KEY (`codigo`),
KEY `FK_servicios_contratados_1` (`id_paciente`),
CONSTRAINT `FK_servicios_contratados_1` FOREIGN KEY (`id_paciente`) REFERENCES `pacientes` (`id_paciente`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `servicios_contratados`
--
/*!40000 ALTER TABLE `servicios_contratados` DISABLE KEYS */;
INSERT INTO `servicios_contratados` (`codigo`,`id_paciente`,`cod_alarma`) VALUES
(1,11111111,1),
(2,11111111,2),
(3,22222222,2),
(4,33333333,2),
(5,44444444,2),
(6,33333333,1),
(7,22222222,1);
/*!40000 ALTER TABLE `servicios_contratados` ENABLE KEYS */;
/*!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 */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
e-REdING. Biblioteca de la Escuela Superior de Ingenieros de Sevilla.
