1EDwcbNM

1-- MySQL dump 10.13  Distrib 5.7.24, for Linux (x86_64)
2--
3-- Host: localhost    Database: practice
4-- ------------------------------------------------------
5-- Server version	5.7.24-0ubuntu0.18.04.1
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Current Database: `practice`
20--
21
22CREATE DATABASE /*!32312 IF NOT EXISTS*/ `practice` /*!40100 DEFAULT CHARACTER SET latin1 */;
23
24USE `practice`;
25
26--
27-- Table structure for table `countries`
28--
29
30DROP TABLE IF EXISTS `countries`;
31/*!40101 SET @saved_cs_client     = @@character_set_client */;
32/*!40101 SET character_set_client = utf8 */;
33CREATE TABLE `countries` (
34  `COUNTRY_ID` varchar(2) DEFAULT NULL,
35  `COUNTRY_NAME` varchar(40) DEFAULT NULL,
36  `REGION_ID` decimal(10,0) DEFAULT NULL
37) ENGINE=InnoDB DEFAULT CHARSET=latin1;
38/*!40101 SET character_set_client = @saved_cs_client */;
39
40--
41-- Dumping data for table `countries`
42--
43
44LOCK TABLES `countries` WRITE;
45/*!40000 ALTER TABLE `countries` DISABLE KEYS */;
46/*!40000 ALTER TABLE `countries` ENABLE KEYS */;
47UNLOCK TABLES;
48
49--
50-- Table structure for table `dup_countries`
51--
52
53DROP TABLE IF EXISTS `dup_countries`;
54/*!40101 SET @saved_cs_client     = @@character_set_client */;
55/*!40101 SET character_set_client = utf8 */;
56CREATE TABLE `dup_countries` (
57  `COUNTRY_ID` varchar(2) DEFAULT NULL,
58  `COUNTRY_NAME` varchar(40) DEFAULT NULL,
59  `REGION_ID` decimal(10,0) DEFAULT NULL
60) ENGINE=InnoDB DEFAULT CHARSET=latin1;
61/*!40101 SET character_set_client = @saved_cs_client */;
62
63--
64-- Dumping data for table `dup_countries`
65--
66
67LOCK TABLES `dup_countries` WRITE;
68/*!40000 ALTER TABLE `dup_countries` DISABLE KEYS */;
69/*!40000 ALTER TABLE `dup_countries` ENABLE KEYS */;
70UNLOCK TABLES;
71
72--
73-- Table structure for table `job_histry`
74--
75
76DROP TABLE IF EXISTS `job_histry`;
77/*!40101 SET @saved_cs_client     = @@character_set_client */;
78/*!40101 SET character_set_client = utf8 */;
79CREATE TABLE `job_histry` (
80  `employee_id` int(11) NOT NULL,
81  `start_date` date NOT NULL,
82  `end_date` date DEFAULT NULL,
83  `job_id` int(11) NOT NULL,
84  `department_id` int(11) NOT NULL,
85  PRIMARY KEY (`employee_id`)
86) ENGINE=InnoDB DEFAULT CHARSET=latin1;
87/*!40101 SET character_set_client = @saved_cs_client */;
88
89--
90-- Dumping data for table `job_histry`
91--
92
93LOCK TABLES `job_histry` WRITE;
94/*!40000 ALTER TABLE `job_histry` DISABLE KEYS */;
95/*!40000 ALTER TABLE `job_histry` ENABLE KEYS */;
96UNLOCK TABLES;
97
98--
99-- Table structure for table `jobs`
100--
101
102DROP TABLE IF EXISTS `jobs`;
103/*!40101 SET @saved_cs_client     = @@character_set_client */;
104/*!40101 SET character_set_client = utf8 */;
105CREATE TABLE `jobs` (
106  `job_id` int(11) NOT NULL,
107  `job_title` varchar(15) DEFAULT NULL,
108  `min_salary` int(11) NOT NULL,
109  `max_salary` int(11) NOT NULL,
110  PRIMARY KEY (`job_id`)
111) ENGINE=InnoDB DEFAULT CHARSET=latin1;
112/*!40101 SET character_set_client = @saved_cs_client */;
113
114--
115-- Dumping data for table `jobs`
116--
117
118LOCK TABLES `jobs` WRITE;
119/*!40000 ALTER TABLE `jobs` DISABLE KEYS */;
120/*!40000 ALTER TABLE `jobs` ENABLE KEYS */;
121UNLOCK TABLES;
122
123--
124-- Table structure for table `ph_m_wcs_tours`
125--
126
127DROP TABLE IF EXISTS `ph_m_wcs_tours`;
128/*!40101 SET @saved_cs_client     = @@character_set_client */;
129/*!40101 SET character_set_client = utf8 */;
130CREATE TABLE `ph_m_wcs_tours` (
131  `id` int(11) NOT NULL,
132  `nom` varchar(15) NOT NULL,
133  `prenom` varchar(15) NOT NULL,
134  `adresse` varchar(30) NOT NULL,
135  PRIMARY KEY (`id`)
136) ENGINE=InnoDB DEFAULT CHARSET=latin1;
137/*!40101 SET character_set_client = @saved_cs_client */;
138
139--
140-- Dumping data for table `ph_m_wcs_tours`
141--
142
143LOCK TABLES `ph_m_wcs_tours` WRITE;
144/*!40000 ALTER TABLE `ph_m_wcs_tours` DISABLE KEYS */;
145INSERT INTO `ph_m_wcs_tours` VALUES (1,'Tessandier','Johann','dantoncu'),(2,'Begot','Jonathan','pastreloin'),(3,'Huet','Emilie','la'),(4,'Berruer','Valentin','ici'),(5,'Cordier','Benoit','parlaba'),(6,'Google','Mon copain','google.com'),(7,'Pester','Lorie','monenfancesouillee');
146/*!40000 ALTER TABLE `ph_m_wcs_tours` ENABLE KEYS */;
147UNLOCK TABLES;
148/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
149
150/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
151/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
152/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
153/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
154/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
155/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
156/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
157
158-- Dump completed on 2018-11-20 10:03:38