m5uMnR5H

1CREATE DATABASE  IF NOT EXISTS `travelsys` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */;
2USE `travelsys`;
3-- MySQL dump 10.13  Distrib 8.0.13, for Win64 (x86_64)
4--
5-- Host: localhost    Database: travelsys
6-- ------------------------------------------------------
7-- Server version	8.0.13
8
9/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
10/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
11/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
12 SET NAMES utf8 ;
13/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
14/*!40103 SET TIME_ZONE='+00:00' */;
15/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
16/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
17/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
18/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
19
20--
21-- Table structure for table `client`
22--
23
24DROP TABLE IF EXISTS `client`;
25/*!40101 SET @saved_cs_client     = @@character_set_client */;
26 SET character_set_client = utf8mb4 ;
27CREATE TABLE `client` (
28  `id` int(11) NOT NULL AUTO_INCREMENT,
29  `name` varchar(85) NOT NULL,
30  `age` int(11) NOT NULL,
31  PRIMARY KEY (`id`)
32) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
33/*!40101 SET character_set_client = @saved_cs_client */;
34
35--
36-- Dumping data for table `client`
37--
38
39LOCK TABLES `client` WRITE;
40/*!40000 ALTER TABLE `client` DISABLE KEYS */;
41INSERT INTO `client` VALUES (1,'balbino',37),(2,'claudia',31),(3,'alan',23),(4,'frank',25);
42/*!40000 ALTER TABLE `client` ENABLE KEYS */;
43UNLOCK TABLES;
44
45--
46-- Table structure for table `country`
47--
48
49DROP TABLE IF EXISTS `country`;
50/*!40101 SET @saved_cs_client     = @@character_set_client */;
51 SET character_set_client = utf8mb4 ;
52CREATE TABLE `country` (
53  `id` int(11) NOT NULL AUTO_INCREMENT,
54  `name` varchar(85) NOT NULL,
55  `code` varchar(2) NOT NULL,
56  PRIMARY KEY (`id`)
57) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
58/*!40101 SET character_set_client = @saved_cs_client */;
59
60--
61-- Dumping data for table `country`
62--
63
64LOCK TABLES `country` WRITE;
65/*!40000 ALTER TABLE `country` DISABLE KEYS */;
66INSERT INTO `country` VALUES (1,'el salvador','sv'),(2,'guatemala','gt'),(3,'colombia','co'),(4,'brazil','br'),(5,'estados unidos','us');
67/*!40000 ALTER TABLE `country` ENABLE KEYS */;
68UNLOCK TABLES;
69
70--
71-- Table structure for table `meal`
72--
73
74DROP TABLE IF EXISTS `meal`;
75/*!40101 SET @saved_cs_client     = @@character_set_client */;
76 SET character_set_client = utf8mb4 ;
77CREATE TABLE `meal` (
78  `id` int(11) NOT NULL AUTO_INCREMENT,
79  `name` varchar(85) NOT NULL,
80  `description` varchar(200) NOT NULL,
81  PRIMARY KEY (`id`)
82) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
83/*!40101 SET character_set_client = @saved_cs_client */;
84
85--
86-- Dumping data for table `meal`
87--
88
89LOCK TABLES `meal` WRITE;
90/*!40000 ALTER TABLE `meal` DISABLE KEYS */;
91INSERT INTO `meal` VALUES (1,'burger','burger'),(2,'lasagna','lasagna'),(3,'fish','fish'),(4,'tacos','tacos'),(5,'veggies','veggies');
92/*!40000 ALTER TABLE `meal` ENABLE KEYS */;
93UNLOCK TABLES;
94
95--
96-- Table structure for table `trip`
97--
98
99DROP TABLE IF EXISTS `trip`;
100/*!40101 SET @saved_cs_client     = @@character_set_client */;
101 SET character_set_client = utf8mb4 ;
102CREATE TABLE `trip` (
103  `id` int(11) NOT NULL AUTO_INCREMENT,
104  `idclient` int(11) NOT NULL,
105  `idcountryfrom` int(11) NOT NULL,
106  `idcountrydestination` int(11) NOT NULL,
107  `idmeal` int(11) NOT NULL,
108  `cost` decimal(12,2) NOT NULL DEFAULT '0.00',
109  PRIMARY KEY (`id`)
110) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
111/*!40101 SET character_set_client = @saved_cs_client */;
112
113--
114-- Dumping data for table `trip`
115--
116
117LOCK TABLES `trip` WRITE;
118/*!40000 ALTER TABLE `trip` DISABLE KEYS */;
119INSERT INTO `trip` VALUES (1,1,1,2,1,12.50);
120/*!40000 ALTER TABLE `trip` ENABLE KEYS */;
121UNLOCK TABLES;
122/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
123
124/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
125/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
126/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
127/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
128/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
129/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
130/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
131
132-- Dump completed on 2019-03-29 16:49:42