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