-- 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 */;
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="es">
	<head>
            <title>e-REdING. Biblioteca de la Escuela Superior de Ingenieros de Sevilla.</title>

                <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<meta name="description" content="Buscador de proyectos ETSI" />
<meta name="author" content="Daniel Callejo"/>
<meta name="author" content="Federico L&oacute;pez"/>
<meta name="author" content="Juli&aacute;n P&eacute;rez"/>
<meta name="author" content="Jos&eacute; Mar&iacute;a Vidal Vidal"/>
<base href="https://biblus.us.es/bibing/proyectos/" /><link rel="shortcut icon" href="./favicon.ico" />
<link rel="stylesheet" href="./publico/css/estructura.css" type="text/css" />
<link rel="stylesheet" href="./publico/css/bootstrap.css" type="text/css" media="screen"/>
<link rel="stylesheet" href="./publico/css/enlaces-capas.css" type="text/css"  />
<link rel="stylesheet" href="./publico/css/pestanas.css" type="text/css"  /> 
<link rel="stylesheet" href="./publico/css/formularios.css" type="text/css" />
<link rel="stylesheet" href="./publico/css/lightbox.css" type="text/css"  />
<link rel="stylesheet" href="./publico/css/autocompleter.css" type="text/css"  />
<link rel="stylesheet" href="./publico/css/resultados.css" type="text/css"  />
<link rel="stylesheet" href="./publico/css/milista.css" type="text/css"  />
<link rel="stylesheet" href="./publico/css/explorador.css" type="text/css"  />
<link rel="stylesheet" href="./publico/css/ultimos.css" type="text/css"  />
<link rel="stylesheet" href="./publico/css/contactar.css" type="text/css"  />
<!-- <link rel="stylesheet" href="./css/print.css" type="text/css" media="print" /> -->
<script src="./publico/javascript/jquery-1.9.1.min.js" type="text/javascript"></script>
<script src="./publico/javascript/bootstrap.js" type="text/javascript"></script>

<script src="./publico/javascript/mootools-1.2.4-core.js" type="text/javascript"></script>
<script src="./publico/javascript/mootools-1-1.2.4.2-more.js" type="text/javascript"></script>
<script src="./publico/javascript/targetbl.js" type="text/javascript"></script>
<script src="./publico/javascript/mensajes.js" type="text/javascript"></script>
<script src="./publico/javascript/form.js" type="text/javascript"></script>
<script src="./publico/javascript/autocompleter/Observer.js" type="text/javascript"></script>
<script src="./publico/javascript/autocompleter/Autocompleter.js" type="text/javascript"></script>
<script src="./publico/javascript/autocompleter/Autocompleter.Request.js" type="text/javascript"></script>
<script src="./publico/javascript/domready.js" type="text/javascript"></script>

<!-- Google tag (gtag.js) -->
<script async src="https://www.googletagmanager.com/gtag/js?id=G-2HP38G406P"></script>
<script>
  window.dataLayer = window.dataLayer || [];
  function gtag(){dataLayer.push(arguments);}
  gtag('js', new Date());

  gtag('config', 'G-2HP38G406P');
</script>



<script type="text/javascript">
function seleccionar_todo(){
   for (i=0;i<document.formulario_marcados.elements.length;i++)
      if(document.formulario_marcados.elements[i].type == "checkbox")
         document.formulario_marcados.elements[i].checked=1
}
function deseleccionar_todo(){
   for (i=0;i<document.formulario_marcados.elements.length;i++)
      if(document.formulario_marcados.elements[i].type == "checkbox")
         document.formulario_marcados.elements[i].checked=0
} 
</script>
	</head>
    <body style="min-width: 960px; background-color: #e2e2e2; height: 100%">	
		<a name="arriba"></a>
<div>
<div id="header">
    <table id="Tabla_01" height="105" border="0" cellpadding="0" cellspacing="0">
    <tr>
        <td>
            <img src="./publico/imagenes/cabecera/banner_new2_01.jpg" width="3" height="105" alt="">
        </td>
        <td>
            <img src="./publico/imagenes/cabecera/banner_new2_02.jpg" width="100" height="105" alt="">
        </td>
        <td width="100%" align="right"  style="min-width: 613px; background-repeat: no-repeat; background-position: top right; font-size: medium; font-weight: bold; color: white;">
            <table width="100%" height="105" border="0">
                <tr>
                    <td style=" vertical-align: top; width: 547px">
                        <!-- <a style="text-decoration: none" href="./"><img src="./publico/imagenes/cabecera/banner_new2_03.jpg"alt=""></a> -->
                        <a style="text-decoration: none" href="https://biblus.us.es/bibing/proyectos/"><img src="./publico/imagenes/cabecera/banner_new2_03.jpg"alt=""></a>
                     </td>
                     <td  background="./publico/imagenes/cabecera/banner_new2_04.jpg" style="background-repeat: no-repeat; background-color: #c6d4e8;"><br><br><br>
                         &nbsp;
                        </td>
                    </tr>
             </table>
        </td>
    </tr>
    <tr style="border-top: 1px solid #ffffff;">
        <td colspan="3" id="menu_sup" style="font-size: small; text-align: right; background-color: #9c1f2f; vertical-align: bottom">
                                     

                                <a href="https://biblus.us.es/bibing/proyectos/" class="enlace " style=" color: #ffffff">Inicio&nbsp;&nbsp;|</a>
                                <a href="https://biblus.us.es/bibing/proyectos/acerca/" style=" color: #ffffff" class="enlace ">&nbsp;&nbsp;Acerca de&nbsp;&nbsp;|</a>
                                
                                <a href="https://biblus.us.es/bibing/proyectos/contactar/" style=" color: #ffffff" class="enlace ">&nbsp;&nbsp;Contactar&nbsp;&nbsp;</a>
                         <!--       <a href="https://biblus.us.es/bibing/proyectos/ayuda/" style=" color: #ffffff" class="enlace  ">&nbsp;&nbsp;Ayuda&nbsp;&nbsp;|</a> -->
                                <!-- <form id="idioma" class=""  method="post" action="">
                                <div class="inline" style="color: white">
                                <input type="submit" class="tipo_letra " style=" color: #ffffff"name="idioma" value="Castellanossss" />&nbsp;&nbsp;
                                </div>	
                                </form> -->

                                </td>

    </tr>
    </table>
</div>
<br><br>
<div class="colmask rightmenu">
<div class="panel panel-default" style="margin:20px">
            <div class="panel-heading"><h4>SERVICIO DE COCHE COMPARTIDO BASADO EN EL IMS</h4><h5 style="color:grey"><span class="glyphicon glyphicon-user""></span> : <b>Crespo Grávalos, Fernando</b><br><span class="glyphicon glyphicon-book""></span>  :<b> Ingenier&iacute;a Telecomunicación</b></h5></div><div class="panel-body"><div class="contenido_proyecto"><div class="titulo2_explorador">Contenido del proyecto:</div><div class="ruta"><a href="abreproy/12078">Directorio ra&iacute;z</a>&nbsp;&nbsp;>&nbsp;&nbsp;<a href="abreproy/12078/direccion/pfc%252F">pfc</a>&nbsp;&nbsp;>&nbsp;&nbsp;<a href="abreproy/12078/direccion/pfc%252FSW%252F">SW</a>&nbsp;&nbsp;>&nbsp;&nbsp;<a href="abreproy/12078/direccion/pfc%252FSW%252Fcarpooldb.sql%252F">carpooldb.sql</a></div><div class="listing"></div></div></div></div>
</div>
</div>

        
	</body>
 
 
<!-- Inicio Google Analytics -->
<!--
	<script type="text/javascript">
		var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
		document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
	</script>
	
	<script type="text/javascript">
		try {
		var pageTracker = _gat._getTracker("UA-7789620-1");
		pageTracker._trackPageview();
	} 
		catch(err) {}
	</script>
-->
<!-- Fin Google Analytics -->

</html>

