· 6 years ago · Jun 09, 2019, 12:18 PM
1██████╗ ███████╗███╗ ███╗ ██████╗ ███╗ ██╗███████╗ █████╗ ██████╗
2██╔══██╗██╔════╝████╗ ████║██╔═══██╗████╗ ██║██╔════╝██╔══██╗██╔══██╗
3██║ ██║█████╗ ██╔████╔██║██║ ██║██╔██╗ ██║███████╗███████║██║ ██║
4██║ ██║██╔══╝ ██║╚██╔╝██║██║ ██║██║╚██╗██║╚════██║██╔══██║██║ ██║
5██████╔╝███████╗██║ ╚═╝ ██║╚██████╔╝██║ ╚████║███████║██║ ██║██████╔╝
6╚═════╝ ╚══════╝╚═╝ ╚═╝ ╚═════╝ ╚═╝ ╚═══╝╚══════╝╚═╝ ╚═╝╚═════╝
7
8I am DemonSad <3
9
10Target : https://xp-dev.com ( Hosting Privada Empresarial )
11
12Greetings: TioSan, Angel, Cloudmore, NedLock
13
14-- ------------------------------------------------------------------------------------------------
15"Um Brinde A Todos Alidados Que Ficaram Junto Ao Meu Crescimento!"
16---------------------------------------------------------------------------------------------------
17/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
18/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
19/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
20/*!40101 SET NAMES utf8 */;
21
22/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
23/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
24/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
25
26
27--
28-- Create schema hhsproject_fly
29--
30
31CREATE DATABASE IF NOT EXISTS hhsproject_fly;
32USE hhsproject_fly;
33
34--
35-- Definition of table `airport`
36--
37
38DROP TABLE IF EXISTS `airport`;
39CREATE TABLE `airport` (
40 `name` varchar(50) NOT NULL,
41 `city` varchar(50) NOT NULL,
42 `country` varchar(50) NOT NULL,
43 `code` varchar(5) default NULL,
44 PRIMARY KEY (`name`),
45 KEY `code` (`code`)
46) ENGINE=MyISAM DEFAULT CHARSET=latin1;
47
48--
49-- Dumping data for table `airport`
50--
51
52/*!40000 ALTER TABLE `airport` DISABLE KEYS */;
53INSERT INTO `airport` (`name`,`city`,`country`,`code`) VALUES
54 ('Schiphol','Amsterdam','Netherlands','AMS'),
55 ('Orly','Paris','France','ORY');
56/*!40000 ALTER TABLE `airport` ENABLE KEYS */;
57
58
59--
60-- Definition of table `flight`
61--
62
63DROP TABLE IF EXISTS `flight`;
64CREATE TABLE `flight` (
65 `number` int(11) NOT NULL,
66 `airportNameFrom` varchar(50) NOT NULL,
67 `airportNameDestination` varchar(50) NOT NULL,
68 `pilotNumber` int(11) NOT NULL,
69 `copilotNumber` int(11) NOT NULL,
70 `Date` varchar(10) NOT NULL,
71 `planeNumber` int(11) NOT NULL,
72 PRIMARY KEY (`number`),
73 KEY `fk_airport_name` (`airportNameFrom`),
74 KEY `fk_airport_name_Destination` (`airportNameDestination`),
75 KEY `fk_pilot_number` (`pilotNumber`),
76 KEY `fk_coPilot_number` (`copilotNumber`),
77 KEY `fk_plane_number` (`planeNumber`)
78) ENGINE=MyISAM DEFAULT CHARSET=latin1;
79
80--
81-- Dumping data for table `flight`
82--
83
84/*!40000 ALTER TABLE `flight` DISABLE KEYS */;
85INSERT INTO `flight` (`number`,`airportNameFrom`,`airportNameDestination`,`pilotNumber`,`copilotNumber`,`Date`,`planeNumber`) VALUES
86 (1,'Orly','Schiphol',2,1,'01-02-2010',1337),
87 (124,'Schiphol','Orly',1,2,'30-01-2010',1337),
88 (2,'Orly','Schiphol',2,1,'23-03-2010',1337),
89 (34567,'Schiphol','Orly',1,2,'24-03-2010',1234);
90/*!40000 ALTER TABLE `flight` ENABLE KEYS */;
91
92
93--
94-- Definition of table `flightstaff`
95--
96
97DROP TABLE IF EXISTS `flightstaff`;
98CREATE TABLE `flightstaff` (
99 `flightNumber` int(11) NOT NULL,
100 `staffNumber` int(11) NOT NULL,
101 PRIMARY KEY (`flightNumber`,`staffNumber`),
102 KEY `fk_staff_id` (`staffNumber`)
103) ENGINE=MyISAM DEFAULT CHARSET=latin1;
104
105--
106-- Dumping data for table `flightstaff`
107--
108
109/*!40000 ALTER TABLE `flightstaff` DISABLE KEYS */;
110INSERT INTO `flightstaff` (`flightNumber`,`staffNumber`) VALUES
111 (124,5),
112 (124,7);
113/*!40000 ALTER TABLE `flightstaff` ENABLE KEYS */;
114
115
116--
117-- Definition of table `flightstops`
118--
119
120DROP TABLE IF EXISTS `flightstops`;
121CREATE TABLE `flightstops` (
122 `flight` int(11) NOT NULL,
123 `airport` int(11) NOT NULL,
124 PRIMARY KEY (`flight`,`airport`)
125) ENGINE=MyISAM DEFAULT CHARSET=latin1;
126
127--
128-- Dumping data for table `flightstops`
129--
130
131/*!40000 ALTER TABLE `flightstops` DISABLE KEYS */;
132/*!40000 ALTER TABLE `flightstops` ENABLE KEYS */;
133
134
135--
136-- Definition of table `plane`
137--
138
139DROP TABLE IF EXISTS `plane`;
140CREATE TABLE `plane` (
141 `capacity` tinyint(3) unsigned NOT NULL,
142 `number` int(11) NOT NULL,
143 `type` varchar(50) NOT NULL,
144 PRIMARY KEY (`number`)
145) ENGINE=MyISAM DEFAULT CHARSET=latin1;
146
147--
148-- Dumping data for table `plane`
149--
150
151/*!40000 ALTER TABLE `plane` DISABLE KEYS */;
152INSERT INTO `plane` (`capacity`,`number`,`type`) VALUES
153 (255,1337,'Boing 757'),
154 (250,1234,'Boing 747');
155/*!40000 ALTER TABLE `plane` ENABLE KEYS */;
156
157
158--
159-- Definition of table `staff`
160--
161
162DROP TABLE IF EXISTS `staff`;
163CREATE TABLE `staff` (
164 `number` int(11) NOT NULL,
165 `type` varchar(25) default NULL,
166 `name` varchar(50) default NULL,
167 PRIMARY KEY (`number`)
168) ENGINE=MyISAM DEFAULT CHARSET=latin1;
169
170--
171-- Dumping data for table `staff`
172--
173
174/*!40000 ALTER TABLE `staff` DISABLE KEYS */;
175INSERT INTO `staff` (`number`,`type`,`name`) VALUES
176 (7,'Stewardess','Elles'),
177 (5,'Stewardess','Maaike'),
178 (3,'Stewardess','Mieke'),
179 (2,'Pilot','Klaas Fransen'),
180 (21,'Pilot','Vincent'),
181 (1,'Pilot','Henk Jansen');
182/*!40000 ALTER TABLE `staff` ENABLE KEYS */;
183
184
185
186
187/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
188/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
189/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
190/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
191/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
192/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
193/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;