|
-- -------------------------------------------------------- |
|
-- Host: 127.0.0.1 |
|
-- Versión del servidor: 10.4.24-MariaDB - mariadb.org binary distribution |
|
-- SO del servidor: Win64 |
|
-- HeidiSQL Versión: 11.3.0.6295 |
|
-- -------------------------------------------------------- |
|
|
|
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; |
|
/*!40101 SET NAMES utf8 */; |
|
/*!50503 SET NAMES utf8mb4 */; |
|
/*!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' */; |
|
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; |
|
|
|
|
|
-- Volcando estructura de base de datos para cercanias |
|
CREATE DATABASE IF NOT EXISTS `cercanias` /*!40100 DEFAULT CHARACTER SET utf8mb4 */; |
|
USE `cercanias`; |
|
|
|
-- Volcando estructura para tabla cercanias.api_status |
|
CREATE TABLE IF NOT EXISTS `api_status` ( |
|
`api_status_id` tinyint(4) NOT NULL DEFAULT 0, |
|
`status_code` tinyint(4) DEFAULT NULL, |
|
`ctime` timestamp NULL DEFAULT current_timestamp(), |
|
`utime` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), |
|
PRIMARY KEY (`api_status_id`) |
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='0 NO-DATA\r\n1 AVAILABLE\r\n2 UPDATING'; |
|
|
|
-- La exportación de datos fue deseleccionada. |
|
|
|
-- Volcando estructura para tabla cercanias.calendar |
|
CREATE TABLE IF NOT EXISTS `calendar` ( |
|
`service_id` varchar(10) NOT NULL, |
|
`monday` bit(1) NOT NULL, |
|
`tuesday` bit(1) NOT NULL, |
|
`wednesday` bit(1) NOT NULL, |
|
`thursday` bit(1) NOT NULL, |
|
`friday` bit(1) NOT NULL, |
|
`saturday` bit(1) NOT NULL, |
|
`sunday` bit(1) NOT NULL, |
|
`start_date` date NOT NULL, |
|
`end_date` date NOT NULL, |
|
PRIMARY KEY (`service_id`) |
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; |
|
|
|
-- La exportación de datos fue deseleccionada. |
|
|
|
-- Volcando estructura para tabla cercanias.regions |
|
CREATE TABLE IF NOT EXISTS `regions` ( |
|
`region_id` varchar(10) NOT NULL, |
|
`shortName` varchar(20) DEFAULT NULL, |
|
`longName` varchar(40) DEFAULT NULL, |
|
PRIMARY KEY (`region_id`) |
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; |
|
|
|
-- La exportación de datos fue deseleccionada. |
|
|
|
-- Volcando estructura para tabla cercanias.routes |
|
CREATE TABLE IF NOT EXISTS `routes` ( |
|
`route_id` varchar(10) NOT NULL, |
|
`route_short_name` varchar(8) NOT NULL, |
|
`route_long_name` varchar(80) NOT NULL, |
|
`route_type` tinyint(4) NOT NULL DEFAULT 0, |
|
`route_color` varchar(8) NOT NULL DEFAULT '0', |
|
`route_text_color` varchar(8) NOT NULL DEFAULT '0', |
|
`region_id` varchar(10) NOT NULL DEFAULT '0', |
|
`active` bit(1) NOT NULL DEFAULT b'0', |
|
PRIMARY KEY (`route_id`), |
|
KEY `region_id` (`region_id`) |
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='route_id\r\nroute_short_name\r\nroute_long_name\r\nroute_type\r\nroute_color\r\nroute_text_color \n'; |
|
|
|
-- La exportación de datos fue deseleccionada. |
|
|
|
-- Volcando estructura para tabla cercanias.stops |
|
CREATE TABLE IF NOT EXISTS `stops` ( |
|
`stop_id` varchar(10) NOT NULL DEFAULT '', |
|
`stop_name` varchar(80) NOT NULL, |
|
`stop_lat` decimal(11,7) NOT NULL DEFAULT 0.0000000, |
|
`stop_lon` decimal(11,7) NOT NULL DEFAULT 0.0000000, |
|
PRIMARY KEY (`stop_id`) |
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; |
|
|
|
-- La exportación de datos fue deseleccionada. |
|
|
|
-- Volcando estructura para tabla cercanias.stop_times |
|
CREATE TABLE IF NOT EXISTS `stop_times` ( |
|
`trip_id` varchar(20) NOT NULL, |
|
`arrival_time` time NOT NULL, |
|
`departure_time` time NOT NULL, |
|
`stop_id` varchar(10) NOT NULL, |
|
`stop_sequence` smallint(6) NOT NULL DEFAULT 0, |
|
KEY `trip_id` (`trip_id`), |
|
KEY `stop_id` (`stop_id`) |
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; |
|
|
|
-- La exportación de datos fue deseleccionada. |
|
|
|
-- Volcando estructura para tabla cercanias.trips |
|
CREATE TABLE IF NOT EXISTS `trips` ( |
|
`route_id` varchar(10) NOT NULL, |
|
`service_id` varchar(10) NOT NULL, |
|
`trip_id` varchar(20) NOT NULL, |
|
`trip_headsign` varchar(40) DEFAULT NULL, |
|
PRIMARY KEY (`trip_id`), |
|
KEY `route_id` (`route_id`), |
|
KEY `service_id` (`service_id`) |
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; |
|
|
|
-- La exportación de datos fue deseleccionada. |
|
|
|
-- Volcando estructura para tabla cercanias.xrequests |
|
CREATE TABLE IF NOT EXISTS `xrequests` ( |
|
`id` int(11) NOT NULL AUTO_INCREMENT, |
|
`originip` varchar(45) NOT NULL DEFAULT '', |
|
`ts` timestamp NOT NULL DEFAULT current_timestamp(), |
|
PRIMARY KEY (`id`), |
|
KEY `ts` (`ts`), |
|
KEY `originip` (`originip`) |
|
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='Requests from remote IPs'; |
|
|
|
-- La exportación de datos fue deseleccionada. |
|
|
|
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */; |
|
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */; |
|
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; |
|
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */; |