DROP DATABASE IF EXISTS Balaton;
CREATE DATABASE Balaton;
USE Balaton;
-- MySQL dump 10.13  Distrib 8.0.40, for Linux (x86_64)
--
-- Host: localhost    Database: Balaton
-- ------------------------------------------------------
-- Server version	8.0.40-0ubuntu0.20.04.1

/*!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 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!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' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `menetrend`
--

DROP TABLE IF EXISTS `menetrend`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `menetrend` (
  `jarat` varchar(255) DEFAULT NULL,
  `honnan` varchar(255) DEFAULT NULL,
  `hova` varchar(255) DEFAULT NULL,
  `indul` time DEFAULT NULL,
  `erkezik` time DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `menetrend`
--

LOCK TABLES `menetrend` WRITE;
/*!40000 ALTER TABLE `menetrend` DISABLE KEYS */;
INSERT INTO `menetrend` VALUES ('A1','Siófok','Balatonalmádi','09:30:00','10:30:00'),('A2','Balatonalmádi','Alsóörs','10:35:00','11:10:00'),('A2','Alsóörs','Csopak','11:10:00','11:40:00'),('A2','Csopak','Siófok','11:40:00','12:20:00'),('A3','Siófok','Csopak','16:00:00','16:45:00'),('A3','Csopak','Alsóörs','16:45:00','17:15:00'),('A3','Alsóörs','Balatonalmádi','17:15:00','17:45:00'),('A4','Balatonalmádi','Siófok','17:50:00','18:50:00'),('B1','Balatonboglár','Révfülöp','08:50:00','09:15:00'),('B2','Révfülöp','Balatonboglár','09:50:00','10:15:00'),('B3','Balatonboglár','Révfülöp','10:30:00','10:55:00'),('B4','Révfülöp','Balatonboglár','11:15:00','11:40:00'),('B5','Balatonboglár','Révfülöp','14:30:00','14:55:00'),('B6','Révfülöp','Balatonboglár','15:10:00','15:35:00'),('B7','Balatonboglár','Révfülöp','17:30:00','17:55:00'),('B8','Révfülöp','Balatonboglár','18:30:00','18:55:00'),('D1','Siófok','Balatonfüred','10:00:00','11:00:00'),('D1','Balatonfüred','Tihany','11:00:00','11:20:00'),('D2','Tihany','Balatonfüred','11:30:00','11:55:00'),('D2','Balatonfüred','Siófok','11:55:00','12:45:00'),('D3','Siófok','Balatonfüred','13:00:00','14:00:00'),('D3','Balatonfüred','Tihany','14:00:00','14:20:00'),('D4','Tihany','Balatonfüred','16:30:00','17:00:00'),('D4','Balatonfüred','Siófok','17:00:00','17:50:00'),('D5','Siófok','Balatonfüred','18:00:00','18:50:00'),('D6','Balatonfüred','Siófok','19:00:00','19:50:00'),('E1','Siófok','Balatonfüred','09:00:00','10:00:00'),('E1','Balatonfüred','Tihany','10:00:00','10:20:00'),('E2','Tihany','Balatonfüred','10:30:00','11:00:00'),('E2','Balatonfüred','Siófok','11:00:00','11:50:00'),('E3','Siófok','Balatonfüred','12:00:00','13:00:00'),('E3','Balatonfüred','Tihany','13:00:00','13:20:00'),('E4','Tihany','Balatonfüred','14:30:00','15:00:00'),('E4','Balatonfüred','Siófok','15:00:00','15:50:00'),('E5','Siófok','Balatonfüred','16:00:00','17:00:00'),('E5','Balatonfüred','Tihany','17:00:00','17:20:00'),('E6','Tihany','Balatonfüred','17:30:00','18:00:00'),('E6','Balatonfüred','Siófok','18:00:00','18:50:00'),('F1','Fonyód','Badacsony','08:15:00','08:45:00'),('F10','Badacsony','Fonyód','15:30:00','16:00:00'),('F11','Fonyód','Badacsony','16:15:00','16:45:00'),('F12','Badacsony','Fonyód','17:00:00','17:30:00'),('F13','Fonyód','Badacsony','17:45:00','18:15:00'),('F14','Badacsony','Fonyód','18:30:00','19:00:00'),('F2','Badacsony','Fonyód','09:00:00','09:30:00'),('F3','Fonyód','Badacsony','10:00:00','10:30:00'),('F4','Badacsony','Fonyód','10:45:00','11:15:00'),('F5','Fonyód','Badacsony','11:30:00','12:00:00'),('F6','Badacsony','Fonyód','12:15:00','12:45:00'),('F7','Fonyód','Badacsony','13:15:00','13:45:00'),('F8','Badacsony','Fonyód','14:00:00','14:30:00'),('F9','Fonyód','Badacsony','14:45:00','15:15:00'),('G1','Balatonföldvár','Balatonszemes','09:10:00','10:05:00'),('G1','Balatonszemes','Balatonlelle','10:05:00','10:45:00'),('G1','Balatonlelle','Balatonboglár','10:45:00','11:15:00'),('G1','Balatonboglár','Badacsony','11:15:00','12:00:00'),('G2','Badacsony','Balatonboglár','16:00:00','16:55:00'),('G2','Balatonboglár','Balatonlelle','16:55:00','17:25:00'),('G2','Balatonlelle','Balatonszemes','17:25:00','18:05:00'),('G2','Balatonszemes','Balatonföldvár','18:05:00','18:50:00'),('J1','Balatonkenese','Balatonalmádi','09:45:00','10:20:00'),('J1','Balatonalmádi','Alsóörs','10:20:00','10:55:00'),('J1','Alsóörs','Csopak','10:55:00','11:20:00'),('J1','Csopak','Balatonfüred','11:20:00','11:45:00'),('J1','Balatonfüred','Tihany','11:45:00','12:05:00'),('J2','Tihany','Balatonfüred','16:00:00','16:30:00'),('J2','Balatonfüred','Csopak','16:30:00','17:00:00'),('J2','Csopak','Alsóörs','17:00:00','17:30:00'),('J2','Alsóörs','Balatonalmádi','17:30:00','18:05:00'),('J2','Balatonalmádi','Balatonkenese','18:05:00','18:35:00'),('K1','Keszthely','Balatonmária','10:00:00','11:00:00'),('K1','Balatonmária','Balatongyörök','11:00:00','11:30:00'),('K1','Balatongyörök','Szigliget','11:30:00','12:15:00'),('K1','Szigliget','Badacsony','12:15:00','12:45:00'),('K2','Badacsony','Szigliget','16:00:00','16:35:00'),('K2','Szigliget','Balatongyörök','16:35:00','17:20:00'),('K2','Balatongyörök','Balatonmária','17:20:00','17:50:00'),('K2','Balatonmária','Keszthely','17:50:00','18:40:00'),('L1','Balatonföldvár','Tihanyrév','08:45:00','09:05:00'),('L1','Tihanyrév','Tihany','09:05:00','09:30:00'),('L1','Tihany','Balatonfüred','09:30:00','10:00:00'),('L1','Balatonfüred','Siófok','10:00:00','10:50:00'),('L2','Siófok','Tihany','11:00:00','11:50:00'),('L3','Tihany','Balatonfüred','13:00:00','13:30:00'),('L3','Balatonfüred','Siófok','13:30:00','14:20:00'),('L4','Siófok','Balatonfüred','15:00:00','16:00:00'),('L4','Balatonfüred','Tihany','16:00:00','16:30:00'),('L4','Tihany','Tihanyrév','16:30:00','16:50:00'),('L4','Tihanyrév','Balatonföldvár','16:50:00','17:05:00'),('M1','Balatonföldvár','Tihanyrév','10:30:00','10:50:00'),('M1','Tihanyrév','Tihany','10:50:00','11:05:00'),('M2','Tihany','Tihanyrév','12:15:00','12:35:00'),('M2','Tihanyrév','Balatonföldvár','12:35:00','12:50:00'),('M3','Balatonföldvár','Tihanyrév','13:05:00','13:25:00'),('M3','Tihanyrév','Tihany','13:25:00','13:40:00'),('M4','Tihany','Tihanyrév','14:30:00','14:50:00'),('M4','Tihanyrév','Balatonföldvár','14:50:00','15:05:00'),('M5','Balatonföldvár','Tihanyrév','15:20:00','15:40:00'),('M5','Tihanyrév','Tihany','15:40:00','15:55:00'),('M6','Tihany','Tihanyrév','17:30:00','17:50:00'),('M6','Tihanyrév','Balatonföldvár','17:50:00','18:05:00');
/*!40000 ALTER TABLE `menetrend` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2024-12-13  7:19:10
