-- phpMyAdmin SQL Dump
-- version 3.4.5
-- http://www.phpmyadmin.net
--
-- Servidor: localhost
-- Tiempo de generación: 16-09-2012 a las 11:40:35
-- Versión del servidor: 5.5.16
-- Versión de PHP: 5.3.8
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!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 */;
--
-- Base de datos: `carpooldb`
--
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `carpool`
--
CREATE TABLE IF NOT EXISTS `carpool` (
`ref_number` varchar(8) NOT NULL,
`uri_d` varchar(60) NOT NULL,
`uri_p` varchar(60) NOT NULL,
`nickD` varchar(20) NOT NULL,
`nickP` varchar(20) NOT NULL,
`origin` varchar(45) NOT NULL,
`destination` varchar(45) NOT NULL,
`pick_up_site` varchar(100) NOT NULL,
`date` date NOT NULL,
`time` time NOT NULL,
`aimed_arrival_time` time NOT NULL,
`pick_up_time` time DEFAULT NULL,
`carplate` varchar(7) NOT NULL,
`cost` int(11) NOT NULL,
`smoke` enum('SI','NO') NOT NULL,
`location_subscription` enum('true','false') NOT NULL DEFAULT 'false',
`started` enum('true','false') NOT NULL DEFAULT 'false',
`passenger_picked_up` enum('true','false') NOT NULL DEFAULT 'false',
`finished` enum('true','false') NOT NULL DEFAULT 'false',
PRIMARY KEY (`uri_d`,`uri_p`,`origin`,`destination`,`date`,`time`),
KEY `fk_CARPOOL_MATCHED1` (`ref_number`),
KEY `uri_p` (`uri_p`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `driverbid`
--
CREATE TABLE IF NOT EXISTS `driverbid` (
`id_offer` varchar(8) NOT NULL,
`d_origin` varchar(45) NOT NULL,
`d_dest` varchar(45) NOT NULL,
`d_date` date NOT NULL,
`d_time` time NOT NULL,
`aimed_arrival_time` time NOT NULL,
`offer_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`d_cost` int(11) NOT NULL,
`d_rep_req` enum('ANY','BEGINNER','AMATEUR','PROFESSIONAL','ADVANCED','EXPERT') NOT NULL,
`n_seats` int(11) NOT NULL,
`n_luggage` int(11) NOT NULL,
`uri` varchar(60) NOT NULL,
`carplate` varchar(7) NOT NULL,
`smoke` enum('YES','NO') NOT NULL,
PRIMARY KEY (`d_origin`,`d_dest`,`d_date`,`d_time`,`uri`,`carplate`),
UNIQUE KEY `id_offer_UNIQUE` (`id_offer`),
UNIQUE KEY `d_origin` (`d_origin`,`d_dest`,`d_date`,`d_time`,`uri`),
KEY `fk_DRIVERBID_USER1` (`uri`),
KEY `carplate` (`carplate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Volcado de datos para la tabla `driverbid`
--
INSERT INTO `driverbid` (`id_offer`, `d_origin`, `d_dest`, `d_date`, `d_time`, `aimed_arrival_time`, `offer_date`, `d_cost`, `d_rep_req`, `n_seats`, `n_luggage`, `uri`, `carplate`, `smoke`) VALUES
('a011a2e3', 'Huelva', 'Sevilla', '2012-12-13', '18:30:00', '19:45:00', '2012-09-16 09:38:24', 10, 'ANY', 1, 4, 'sip:user@ericsson.com', '1111AAC', 'NO');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `matched`
--
CREATE TABLE IF NOT EXISTS `matched` (
`id_matched` varchar(8) NOT NULL,
`id_offer` varchar(8) NOT NULL,
`id_request` varchar(8) NOT NULL,
`driver_agree` enum('true','false') DEFAULT 'false',
`passenger_agree` enum('true','false') DEFAULT 'false',
`pick_up_time` time NOT NULL DEFAULT '00:00:00',
PRIMARY KEY (`id_matched`,`id_offer`,`id_request`),
KEY `id_request` (`id_offer`),
KEY `id_offer` (`id_request`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Volcado de datos para la tabla `matched`
--
INSERT INTO `matched` (`id_matched`, `id_offer`, `id_request`, `driver_agree`, `passenger_agree`, `pick_up_time`) VALUES
('6a1a77db', 'a011a2e3', '213a854b', 'false', 'false', '00:00:00');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `operators`
--
CREATE TABLE IF NOT EXISTS `operators` (
`cell_ID` varchar(20) NOT NULL,
`location` varchar(100) NOT NULL,
PRIMARY KEY (`cell_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Volcado de datos para la tabla `operators`
--
INSERT INTO `operators` (`cell_ID`, `location`) VALUES
('1-B5CA4356', 'Avenida Jose Leon Carranza 23, Cadiz'),
('1-B5HU3197', 'Calle Marina 27, Huelva'),
('1-B5HU3198', 'Avenida Plateros 1, Huelva'),
('1-B5SE2198', 'Avenida de los Descubrimientos Escuela de Ingenieros, Sevilla');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `owns_car`
--
CREATE TABLE IF NOT EXISTS `owns_car` (
`carplate` varchar(7) NOT NULL,
`vendor` varchar(10) NOT NULL,
`model` varchar(10) NOT NULL,
`color` varchar(20) NOT NULL,
`purch_date` date DEFAULT NULL,
`USER_uri` varchar(60) NOT NULL,
PRIMARY KEY (`carplate`,`USER_uri`),
UNIQUE KEY `carplate` (`carplate`),
KEY `fk_OWNS_CAR_USER` (`USER_uri`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Volcado de datos para la tabla `owns_car`
--
INSERT INTO `owns_car` (`carplate`, `vendor`, `model`, `color`, `purch_date`, `USER_uri`) VALUES
('1002FBL', 'PEUGEOT', '207', 'Gris', '2007-05-23', 'sip:fer@ericsson.com'),
('1111AAC', 'Volkswagen', 'Polo', 'Blue', '2010-04-06', 'sip:user@ericsson.com'),
('4231CBA', 'Hyundai', 'i30', 'Blanco', '2012-03-24', 'sip:jvt@ericsson.com'),
('5678DEF', 'Ford', 'Galaxy', 'Gris', '2009-03-27', 'sip:jvt@ericsson.com'),
('9471GTK', 'FIAT', 'Punto', 'Azul', '2010-02-18', 'sip:fer@ericsson.com');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `passengerbid`
--
CREATE TABLE IF NOT EXISTS `passengerbid` (
`id_request` varchar(8) NOT NULL,
`p_origin` varchar(45) NOT NULL,
`p_dest` varchar(45) NOT NULL,
`pick_up_site` varchar(100) NOT NULL,
`p_date_min` date NOT NULL,
`p_date_max` date NOT NULL,
`p_time_min` time NOT NULL,
`p_time_max` time NOT NULL,
`luggage` int(11) NOT NULL,
`p_cost` int(11) NOT NULL,
`p_rep_req` enum('BEGINNER','AMATEUR','PROFESSIONAL','EXPERT','ANY','ADVANCED') NOT NULL,
`req_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`USER_uri` varchar(60) NOT NULL,
`smoke` enum('SI','NO') NOT NULL,
PRIMARY KEY (`p_origin`,`p_dest`,`p_date_min`,`p_date_max`,`p_time_min`,`p_time_max`,`USER_uri`),
UNIQUE KEY `id_request_UNIQUE` (`id_request`),
KEY `fk_PASSENGERBID_USER1` (`USER_uri`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Volcado de datos para la tabla `passengerbid`
--
INSERT INTO `passengerbid` (`id_request`, `p_origin`, `p_dest`, `pick_up_site`, `p_date_min`, `p_date_max`, `p_time_min`, `p_time_max`, `luggage`, `p_cost`, `p_rep_req`, `req_date`, `USER_uri`, `smoke`) VALUES
('213a854b', 'Huelva', 'Sevilla', 'Gasolinera Trigueros', '2012-11-30', '2012-12-28', '17:30:00', '19:00:00', 1, 30, 'ANY', '2012-09-16 09:38:44', 'sip:isa@ericsson.com', 'NO');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `user`
--
CREATE TABLE IF NOT EXISTS `user` (
`photo` blob,
`uri` varchar(60) NOT NULL,
`nick` varchar(20) NOT NULL,
`country` varchar(45) NOT NULL,
`lang` enum('en','es') NOT NULL,
`sex` enum('M','F') NOT NULL,
`smoker` enum('YES','NO') NOT NULL,
`reputation` enum('BEGINNER','AMATEUR','PROFESSIONAL','EXPERT','ANY','ADVANCED') NOT NULL,
`twitter_ID` varchar(20) NOT NULL DEFAULT 'No defined',
`travels` int(11) NOT NULL,
`last_score` int(11) DEFAULT NULL,
`total_score` int(255) NOT NULL DEFAULT '0',
PRIMARY KEY (`uri`,`nick`),
UNIQUE KEY `nick` (`nick`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Volcado de datos para la tabla `user`
--
INSERT INTO `user` (`photo`, `uri`, `nick`, `country`, `lang`, `sex`, `smoker`, `reputation`, `twitter_ID`, `travels`, `last_score`, `total_score`) VALUES
(NULL, 'sip:alice@ericsson.com', 'alice', 'SPAIN', 'en', 'F', 'NO', 'EXPERT', '@alice1234', 3, 8, 34),
(NULL, 'sip:bob@ericsson.com', 'bobby', 'Spain', 'en', 'M', 'NO', 'BEGINNER', 'No defined', 0, 0, 0),
(NULL, 'sip:coco@ericsson.com', 'coco', 'SPAIN', 'en', 'M', 'NO', 'EXPERT', '', 10, 8, 104),
(0x89504e470d0a1a0a0000000d494844520000002d0000002d08060000003a1ae29a0000001974455874536f6674776172650041646f626520496d616765526561647971c9653c00000cc04944415478dabc59096c1ce515fee6d8d9c35eaf8fc4f145ec38ce7dc74d2202498194042a4a891aa0698b50281444512b7ad0aa152d42156d25aa8aa82a1295a8d4d286482d0189504268b87292388921899390d8f17dec6677bdd7dc337dffecac996e9cb34e377a99d9f1cc3fdffffeefbdf7bd7f39dbb6c1711cfe878ff761def3dd7bdd2e32788e57fd1127002cef9ae031de3301cb05681699553489eb077ae9d2a5387cf830e7026200c5e6e6e6a64020b058108495644b69f52274bdca34cd213a8f19867154d3b4037d7d7dfb755d97e96f1a994e665c0b78ee1ae8c1793c2b2d58b06013017d4014c5656c1c3a079d439224e758b8a6aa6a6e686868872ccb6f757676be4dcf32f0ea38e0af0b68de5d21ffc2850b9ff6f97c3f601348a7d30c983396dfef475d5d1deaebeb412b809292126702a9540a1d1d1dd9582cb6e5cc9933bfa31518a567732e78c3a58d3dd1f42878d93773e6cc5504f8495a6e81402097cb81e880821392c924d8449a9a9a9c0723918833093a96b4b5b53d4c9368eeededfdc5e8e868b73baee2bee3b2c0af0534a3853f180c3e665996c8bc47c01d3a30b00cb4f3669ac0e0e0a0e361ef3506beb5b5157bf7eebdada1a1c1ca64323f66d73dbcb6261ab4e3e5f2f2f22a9ee76f6560e988b2b2320710a3c2aa55abd0dc3c1d3dbdbd686f3f8af3b1f3c46911aaa621944ad34486402b848a8a4ab63a5f6a696979e2d4a953cf1705277729e0e2557a9999585555b598bcea6780195f9927d9041e7df45184c36578ebcd37901a8da3c4cf235053058326148f8e204e4f0bf48cdf4793a02c92ca643b4693c9633466882ce3ae2237d19c763c4dd9a0910dce969e7d18e0458b166160701889b6dd78e82b4b30a7b91e3e51405a5630124b239ac838ce2b2b0da0baa214afbffbf1a96737efdf4a170718dd5c2cfcf502cd9e09140fce68bb6fff3e3cf3c81aac5931973c494149ffa670a59839b5dae1bb6959d0748368a162dd4df3eb9edd3c56888aabe765415c75f620fee6bc839b143a1da7cf624a2480a97595044c234ae8b04c0386a143d3544a878a633a9ddb9681d250a0b4b17e72d00d3cd313849868d0ce8722beabe012cbb2890a35689c12467d75184149806598e0c8abb898d916441efc92b94d951ed0e69556c66bd11e76341aeda9a9a91921bc75f35b6af0e4375683e77828b4f4124f34200fe70b56d1fb6d2b8fd1362170365f37b9bca4a88cdb5702fc6a413b5ea1fcaccbb2b2b7a23cbc61f9dc06d45451c5a3522d50e08904dab20d5a426e9c4a6b8d19ddce47c2c1d02554e084d1c376f3a89648c4775076b0ca4212645985a2a830298b80007f4e05a209799799f79a73344d2ee013254f95e5c791b41302bac03d8dca6f673a933b984ce52cdb0d38cb3060129f5900da4401870e6396ff6e5becef2605aa618da6b3ea2534f884d0a3b074ac6a5181d392d1d8f9b762c9cc172cca0686c53bd4a0da41fcb6f358e80b638823aa6de65c8b2665389cd734ddea1b8ea7ff1f4d80e5d2837928974c248e0e8c244eab9a3e87a340d4789bb8cd04531eb42d508a20d4ec9f4589dc20d006ad844eab222b8af1e1a1d3bd455ac3be5e29cf7475829c93e5e183c7bab60ec752699299cc7b948b751874d499513631c858c564e65ca71ccececff5c7468662a319d70905598aeb1588964b1126e23327cf741f3874fcdc072c1019608534b5a26ace3903aea9ba3399b1a37bbe6dd79136578e7a1b01f37af588b6c7db0aa5bfec502c798ea93856cb6df89c822351fa330cdee95ae016219da8a1d18a7cfad940dfb67fb79fa0cbd9a226c0ba1ea02f48bcb72c9f1b59b9b0e9c60ce9891ca7a1221ca20c4180759e242825639e1bab2b3a713a95cea99bfff6de7ba4415274395d047ac22be27f35b3b7cfe7c2f7de73cfbd4b962c7f3a797eb8344add8b61e5534569c84f529027cf52f6e039474cb1d49c4c6595175eddfdde8163dd7d2e58c55d31af97b989a88805ef3adb03cf7c0d15b7cf47eb8cfa8a6f4d9a727c83396da178baf68bb08eed819c893a4196ca589048330b3c19890c2651690ef6fb074f9e556c7ff6b1b5c106ced231604ccfbef1fea901776c9fc7dbd6a582f2728dad17b0b4ed49ccbc755ee9cf23b5ad1bd070170d4d8e3aff21d0b80ee9d09d889dd98f64ff7164b20abd9dda2cce07c92fa1321c4050d0c1093e542e5c0ff1b35f1ba1e15d62b2eedbe73ae5869dffdcfee1d6e736bfdae1a18a7ea9ad05f10a3ccceef1bdff14562c6f8efc3e38e3c145a85d4d3ea16c2590ac1627035dff42789a84e08a4d88f47f0ab9f730f4f4805325fd12d1c34cc31223a89cb30e65f50b88c9cb44c44ea03c52dfb4b42cfb48f3d767ad6c96e63ff7f0f3b45cf90ea6409b71d3e0e5e8e12cdbdbdf43eb8d532b5f96666d6a42b805e83f44bea01812483a841b8049eb8093af43b403a89cf108b4c9d3a124fb61a5fb29f008432082a6e6d974efb4fca894bb2193f1619a401ce5d14fe66d9c9d789edfc43df3d09fed5d7447ca759a3a1e70f1325db7f4a707d1f2c51b822f4ad3ee6b82bf1ee8f998fc90ccb72a6c9cf31453e5cd40492bb0fb37f46419a496fb2185aba91958801777f6634fb785ef8835b8730e798055069926acfbf3c7cedd40a20b21cbaebd7f9ef05cef5dc60f7ff926f67a80aac5f95bbc549628f5a3fcee16e129b1fecbf3cc92e9b0bb0fd3a2d18ba864e7d9c6d202a5da743bb8f246a2410dec1d3fa2ce7731b88a59f8a84bc51ff765a9641be84b28688c346151431066b4871ed3c00d9da600fe804516132ca45dccaac797e1576fb6e3f183bd38e9e1b4e6dd0fe12f9155fc7f598f75216eea46b37231d49ee3d0522968b20d2d6740cdea7993d9b901a5ff2c54a5046a5a82b2e3274e2210498bf81c3dc2e1bed60acca90d3883abe78e4389a7a0f69e867c5e819c522127e998b411c8a2e1b76bf17dba6d125999db8f0a1e675ee0e9022d7c1501d42caf0dfdd4aa5dcdabf128ccf888e361ce9197645ec9c9241cf3ba233fab607ffa11a4d67771d3f43bf0c286067cd29bc303cb2b2111786819647b3be9991270ea59d2239ec567699ec8b02882d54facc09d7f38806d6e26d13d626d5c7a30612ebd7c07ee154a5a661aa15a683ded6efdd3f39ad8febcd773568cce2d2d072b1387991aa6fe9064c9cecda89a710766958bd8b2751827274bb8615915d4337ba02408a9188091eecec3f1645c967d49e9fad6d6e3fe1739ec316d87d3aa677bd8128bbcccbe8b65122a6a04df2633320bd9fe6e9819dddd26c883b59d6e24ef5d53cd12d8048ce4304c45ceeb67229d7164372ae31d683b33195bfeda89293501ac21d099b6ed48c772b0796a14485c5d200ce87b8ee6bca8148d1b67e1b6574ee235579c29058f8bc51b31ccbe3b1bb7948726356966005ab4d79d7e1eac6dbade65dd4a2a0e2d3e403526970f11374298dcb04772e87fed25b4893f03223eec3d9146ef20659d231f219ba03178e5a27d0a7b9d9f837f5a005410f08e9bbbd32e758d624f33d042ad80bb0db19ad7068769d9f341ebf0d8ca5757334b4114eb8799cb504b683a60b9a2810cd94474e73b3852b391c22980239f19f8f8ef5b30bbb313b99cfbfa71e423e7820e3af91c1177cb4c72b139ad9958b4852b960828abb6305fb5829c319acd03a5002309ea74207a3a0165b88fa8a038835fcc5b065d577abae14beca4f8bf855a2c1503db5f416d3ae5d495f19e1bdb2c149c7a6e1c89e2a80b56f46690e240b45696a1a53a102a97299d599ce580651d3453ca7a6a94009387493b7397691f341a3ea06431dd24ad5fb91e3767ff81eaf85124cdfc84c6054cff91be62a0ed97fa7168fb08da8a7eb7b9a0b838e9ae2d8dfef621f9504bf2e81a544c11f97084848e083d93426e780036751e57d2ef706e473989ef46a571d65e9edac5858817696e7c0e4bf958b0872d64b6c671e89d51ecb32fa2b70b2aafc06796ccab0853edfa30beb93684af564ac22494463845ce41975d4a5ce14720d0e7cbeacc44c554b5297ad4cfc98a50a0546127937956b3a07599c81e96d1b5338b7652b6fdf4272a0c18f458d2ed74742f68c619b64d55413685d92401f36e0e60ed521f66d508888479840c3b3f6dcb1e5ff072451ee4ad7cdd619a83193dc704ad9ea1fcdb6340eed031d26ba0ff84862eba75d4cd14711774d4b58447fd99c5a0fd2e70b631584d36999d93baac9dca630e4da2b18e47c5741e25551c4294967cf4806479225fc8bb43a7a2601291ac940d852de16913eaa08d6cd6423a6d2349153b19b330e42ebd5268945d8f265de0ec38ea7a78ac8ff4822e1417063ccc7edb212bf7688052d78204225cc2a1926e2e21e0213b2f79c6b61c351b324d8425439da44a863958cdbfd8f46c1914da2cd903b8908fd39eef72514b667b3b17cef38b2b031e74bd1e766d0cb4276f7ad3113fce5683e9d9ffb33c80758f87158fa7bda6787e87f1fec27b81f6f0fe1c667af637d2aeda2a98e49a589c438b9eb7c6f979d90b5cbb8879f7412e68bbfe23c000b8cdcdc7de437a780000000049454e44ae426082, 'sip:fer@ericsson.com', 'fercres85', 'SPAIN', 'en', 'M', 'NO', 'ADVANCED', '@FerCrespoGrav', 9, 8, 0),
(NULL, 'sip:isa@ericsson.com', 'isa.rodrig', 'SPAIN', 'en', 'F', 'NO', 'ADVANCED', '@IsamRico', 8, 8, 0),
(NULL, 'sip:jvt@ericsson.com', 'Juanma Vozmediano', 'SPAIN', 'en', 'M', 'NO', 'ADVANCED', '', 8, 8, 0),
(NULL, 'sip:paula@ericsson.com', 'pcgravalos', 'SPAIN', 'en', 'F', 'NO', 'ADVANCED', '', 8, 8, 0),
(NULL, 'sip:user@ericsson.com', 'usuario', 'Spain', 'es', 'M', 'NO', 'BEGINNER', 'No defined', 0, 0, 0);
--
-- Restricciones para tablas volcadas
--
--
-- Filtros para la tabla `carpool`
--
ALTER TABLE `carpool`
ADD CONSTRAINT `carpool_ibfk_1` FOREIGN KEY (`uri_d`) REFERENCES `driverbid` (`uri`) ON DELETE CASCADE ON UPDATE NO ACTION,
ADD CONSTRAINT `carpool_ibfk_2` FOREIGN KEY (`uri_p`) REFERENCES `passengerbid` (`USER_uri`) ON DELETE CASCADE ON UPDATE NO ACTION;
--
-- Filtros para la tabla `driverbid`
--
ALTER TABLE `driverbid`
ADD CONSTRAINT `driverbid_ibfk_1` FOREIGN KEY (`carplate`) REFERENCES `owns_car` (`carplate`) ON DELETE CASCADE ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_DRIVERBID_USER1` FOREIGN KEY (`uri`) REFERENCES `user` (`uri`) ON DELETE CASCADE ON UPDATE NO ACTION;
--
-- Filtros para la tabla `matched`
--
ALTER TABLE `matched`
ADD CONSTRAINT `matched_ibfk_1` FOREIGN KEY (`id_offer`) REFERENCES `driverbid` (`id_offer`) ON DELETE CASCADE,
ADD CONSTRAINT `matched_ibfk_2` FOREIGN KEY (`id_request`) REFERENCES `passengerbid` (`id_request`) ON DELETE CASCADE;
--
-- Filtros para la tabla `owns_car`
--
ALTER TABLE `owns_car`
ADD CONSTRAINT `owns_car_ibfk_1` FOREIGN KEY (`USER_uri`) REFERENCES `user` (`uri`) ON DELETE CASCADE ON UPDATE NO ACTION;
--
-- Filtros para la tabla `passengerbid`
--
ALTER TABLE `passengerbid`
ADD CONSTRAINT `fk_PASSENGERBID_USER1` FOREIGN KEY (`USER_uri`) REFERENCES `user` (`uri`) ON DELETE NO ACTION ON UPDATE NO ACTION;
/*!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 */;
e-REdING. Biblioteca de la Escuela Superior de Ingenieros de Sevilla.
