2u1nFskN

1--
2-- Script was generated by Devart dbForge Studio for MySQL, Version 7.4.201.0
3-- Product home page: http://www.devart.com/dbforge/mysql/studio
4-- Script date 2018. 10. 17. 8:11:15
5-- Server version: 5.5.5-10.1.33-MariaDB
6-- Client version: 4.1
7--
8
9-- 
10-- Disable foreign keys
11-- 
12/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
13
14-- 
15-- Set SQL mode
16-- 
17/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
18
19-- 
20-- Set character set the client will use to send SQL statements to the server
21--
22SET NAMES 'utf8';
23
24--
25-- Set default database
26--
27USE autokolcsonzo;
28
29--
30-- Drop table `rendeles`
31--
32DROP TABLE IF EXISTS rendeles;
33
34--
35-- Drop table `ugyfelek`
36--
37DROP TABLE IF EXISTS ugyfelek;
38
39--
40-- Drop table `autok`
41--
42DROP TABLE IF EXISTS autok;
43
44--
45-- Drop table `tipusok`
46--
47DROP TABLE IF EXISTS tipusok;
48
49--
50-- Drop table `auto_csop`
51--
52DROP TABLE IF EXISTS auto_csop;
53
54--
55-- Drop table `alkalmazott`
56--
57DROP TABLE IF EXISTS alkalmazott;
58
59--
60-- Drop table `reszleg`
61--
62DROP TABLE IF EXISTS reszleg;
63
64--
65-- Set default database
66--
67USE autokolcsonzo;
68
69--
70-- Create table `reszleg`
71--
72CREATE TABLE reszleg (
73  reszleg_kod CHAR(2) NOT NULL,
74  reszleg_nev VARCHAR(20) DEFAULT NULL,
75  reszleg_cim VARCHAR(15) DEFAULT NULL,
76  PRIMARY KEY (reszleg_kod)
77)
78ENGINE = INNODB,
79AVG_ROW_LENGTH = 2730,
80CHARACTER SET utf8,
81COLLATE utf8_hungarian_ci;
82
83--
84-- Create table `alkalmazott`
85--
86CREATE TABLE alkalmazott (
87  alk_kod CHAR(4) NOT NULL,
88  alk_nev VARCHAR(20) DEFAULT NULL,
89  beosztas VARCHAR(16) DEFAULT NULL,
90  belepes DATE DEFAULT NULL,
91  fizetes INT(6) DEFAULT NULL,
92  premium INT(6) DEFAULT NULL,
93  reszleg_kod CHAR(2) NOT NULL,
94  PRIMARY KEY (alk_kod)
95)
96ENGINE = INNODB,
97AVG_ROW_LENGTH = 1260,
98CHARACTER SET utf8,
99COLLATE utf8_hungarian_ci;
100
101--
102-- Create foreign key
103--
104ALTER TABLE alkalmazott 
105  ADD CONSTRAINT reszleg_kod FOREIGN KEY (reszleg_kod)
106    REFERENCES reszleg(reszleg_kod);
107
108--
109-- Create table `auto_csop`
110--
111CREATE TABLE auto_csop (
112  auto_csop_nev VARCHAR(6) NOT NULL,
113  km_dij INT(3) DEFAULT NULL,
114  napi_dij INT(5) DEFAULT NULL,
115  PRIMARY KEY (auto_csop_nev)
116)
117ENGINE = INNODB,
118AVG_ROW_LENGTH = 5461,
119CHARACTER SET utf8,
120COLLATE utf8_hungarian_ci;
121
122--
123-- Create table `tipusok`
124--
125CREATE TABLE tipusok (
126  tipus_nev VARCHAR(15) NOT NULL,
127  auto_csop_nev VARCHAR(6) DEFAULT NULL,
128  leiras VARCHAR(30) DEFAULT NULL,
129  szerviz_km INT(5) DEFAULT NULL,
130  PRIMARY KEY (tipus_nev)
131)
132ENGINE = INNODB,
133AVG_ROW_LENGTH = 1365,
134CHARACTER SET utf8,
135COLLATE utf8_hungarian_ci;
136
137--
138-- Create foreign key
139--
140ALTER TABLE tipusok 
141  ADD CONSTRAINT tipus_auto_csop FOREIGN KEY (auto_csop_nev)
142    REFERENCES auto_csop(auto_csop_nev);
143
144--
145-- Create table `autok`
146--
147CREATE TABLE autok (
148  rendszam CHAR(7) NOT NULL,
149  tipus_nev VARCHAR(15) DEFAULT NULL,
150  auto_csop_nev VARCHAR(6) DEFAULT NULL,
151  vasarlas_datuma DATE DEFAULT NULL,
152  ar INT(10) DEFAULT NULL,
153  futott_km INT(6) DEFAULT NULL,
154  ut_szerviz INT(6) DEFAULT NULL,
155  allapot CHAR(1) DEFAULT NULL,
156  reszleg CHAR(2) DEFAULT NULL,
157  PRIMARY KEY (rendszam)
158)
159ENGINE = INNODB,
160AVG_ROW_LENGTH = 862,
161CHARACTER SET utf8,
162COLLATE utf8_hungarian_ci;
163
164--
165-- Create foreign key
166--
167ALTER TABLE autok 
168  ADD CONSTRAINT autok_auto_csop FOREIGN KEY (auto_csop_nev)
169    REFERENCES auto_csop(auto_csop_nev);
170
171--
172-- Create foreign key
173--
174ALTER TABLE autok 
175  ADD CONSTRAINT autok_reszleg_kod FOREIGN KEY (reszleg)
176    REFERENCES reszleg(reszleg_kod);
177
178--
179-- Create table `ugyfelek`
180--
181CREATE TABLE ugyfelek (
182  ugyfel_szam CHAR(3) NOT NULL,
183  ugyfel_nev VARCHAR(20) DEFAULT NULL,
184  cim VARCHAR(15) DEFAULT NULL,
185  varos VARCHAR(10) DEFAULT NULL,
186  orszag VARCHAR(10) DEFAULT NULL,
187  iranyito_szam VARCHAR(6) DEFAULT NULL,
188  megbizott VARCHAR(15) DEFAULT NULL,
189  fizetesi_mod CHAR(1) DEFAULT NULL,
190  PRIMARY KEY (ugyfel_szam)
191)
192ENGINE = INNODB,
193AVG_ROW_LENGTH = 1820,
194CHARACTER SET utf8,
195COLLATE utf8_hungarian_ci;
196
197--
198-- Create table `rendeles`
199--
200CREATE TABLE rendeles (
201  rendeles_szam CHAR(5) NOT NULL,
202  ugyfel_szam CHAR(3) DEFAULT NULL,
203  rendeles_datum DATE DEFAULT NULL,
204  rendelo_szemely VARCHAR(12) DEFAULT NULL,
205  kolcson_kezdete DATE DEFAULT NULL,
206  napok INT(3) DEFAULT NULL,
207  rendszam CHAR(7) DEFAULT NULL,
208  tipus_nev VARCHAR(15) DEFAULT NULL,
209  km_kezdet INT(6) DEFAULT NULL,
210  km_veg INT(6) DEFAULT NULL,
211  kolcson_dij INT(8) DEFAULT NULL,
212  fizetve CHAR(1) DEFAULT NULL,
213  PRIMARY KEY (rendeles_szam)
214)
215ENGINE = INNODB,
216AVG_ROW_LENGTH = 1365,
217CHARACTER SET utf8,
218COLLATE utf8_hungarian_ci;
219
220--
221-- Create foreign key
222--
223ALTER TABLE rendeles 
224  ADD CONSTRAINT rendszam FOREIGN KEY (rendszam)
225    REFERENCES autok(rendszam);
226
227--
228-- Create foreign key
229--
230ALTER TABLE rendeles 
231  ADD CONSTRAINT ugyfel_szam FOREIGN KEY (ugyfel_szam)
232    REFERENCES ugyfelek(ugyfel_szam);
233
234-- 
235-- Dumping data for table reszleg
236--
237INSERT INTO reszleg VALUES
238('10', 'Kozpont', 'Budapest'),
239('20', 'Auto-Renault', 'Budapest'),
240('30', 'Auto', 'Gyor'),
241('40', 'Luxus-Auto', 'Budapest'),
242('50', 'Auto', 'Debrecen'),
243('60', 'Teherauto', 'Budapest');
244
245-- 
246-- Dumping data for table auto_csop
247--
248INSERT INTO auto_csop VALUES
249('EXTRA', 120, 7500),
250('LUXUS', 300, 15000),
251('NORMAL', 80, 5000);
252
253-- 
254-- Dumping data for table ugyfelek
255--
256INSERT INTO ugyfelek VALUES
257('342', 'Molnar Peter', 'Hilton PRK. 1.', 'New York', 'USA', '49928', 'Hilton', 'A'),
258('343', 'Papp Robert', 'Piac u. 10.', 'Debrecen', 'Magyar', '4027', 'Pinter Attila', 'K'),
259('344', 'Abel Anett', 'Weisz STR. 5.', 'Becs', 'Ausztria', '20800', 'Hilton', 'K'),
260('345', 'Tibor Smith', 'Lignoun 15.', 'Parizs', 'Francia', '140010', 'Hotel CIVIS', 'K'),
261('346', 'Papp Agnes', 'Vezer u. 19.', 'Debrecen', 'Magyar', '4032', NULL, 'A'),
262('347', 'Biro KAtalin', 'Tessedik u. 6.', 'Debrecen', 'Magyar', '4032', NULL, 'A'),
263('348', 'Kiss Viktoria', 'Fo u. 8.', 'Budapest', 'Magyar', '1221', 'Nagy Tiborne', 'K'),
264('349', 'Ligeti Viktoria', 'Kiraly u. 88.', 'Budapest', 'Magyar', '1239', NULL, 'A'),
265('350', 'Toth Karolyne', 'Domb u. 6.', 'Budapest', 'Magyar', '1260', NULL, 'A');
266
267-- 
268-- Dumping data for table autok
269--
270INSERT INTO autok VALUES
271('ABC-021', 'Skoda LX', 'NORMAL', '1993-10-01', 827000, 123212, 120509, 'F', '30'),
272('ABC-022', 'Skoda CL', 'NORMAL', '1993-10-01', 917000, 97081, 95317, 'S', '30'),
273('ABC-123', 'Opel Astra', 'EXTRA', '1993-10-11', 1239000, 101978, 93710, 'A', '30'),
274('ABR-047', 'Ford Escort', 'EXTRA', '1993-01-02', 1300000, 151003, 141410, 'F', '30'),
275('ABR-115', 'Renault 19', 'EXTRA', '1993-01-02', 1200000, 145097, 139600, 'X', '20'),
276('BAH-115', 'Opel Vectra', 'LUXUS', '1993-10-11', 3977000, 51007, 49620, 'A', '50'),
277('CBN-001', 'W Vento CL', 'EXTRA', '1994-01-02', 1999000, 152311, 150600, 'F', '60'),
278('CBN-301', 'Opel Corsa', 'NORMAL', '1993-12-01', 917000, 28001, 25444, 'A', '60'),
279('CBN-302', 'Opel Astra', 'EXTRA', '1993-12-01', 1239000, 87111, 80001, 'S', '60'),
280('CDB-115', 'Renault Twingo', 'NORMAL', '1994-01-03', 955000, 8307, NULL, 'S', '20'),
281('CDD-115', 'Ford Escort', 'EXTRA', '1994-01-02', 1400000, 15901, 15501, 'A', '30'),
282('CDE-324', 'Renault Nevada', 'EXTRA', '1993-06-01', 2473000, 42040, 15901, 'F', '20'),
283('CIC-321', 'W Vento CL', 'EXTRA', '1993-11-01', 1650000, 100021, 83701, 'F', '60'),
284('COD-705', 'W Vento CL', 'EXTRA', '1993-11-01', 1650000, 91970, 79600, 'S', '60'),
285('DCD-324', 'Renault Laguma', 'EXTRA', '1994-01-02', 2346000, 41061, 28861, 'A', '20'),
286('DHV-123', 'Renault Laguma', 'EXTRA', '1993-06-05', 2346000, 73621, 53600, 'A', '20'),
287('PDP-101', 'Renault Espace', 'LUXUS', '1994-01-02', 3530000, 7911, NULL, 'S', '20'),
288('PHD-100', 'Renault 19', 'EXTRA', '1993-06-30', 1329000, 161441, 140507, 'X', '20'),
289('PHD-610', 'Renault Nevada', 'EXTRA', '1993-07-20', 2473000, 39066, 30009, 'F', '20');
290
291-- 
292-- Dumping data for table tipusok
293--
294INSERT INTO tipusok VALUES
295('Ford Escort', 'EXTRA', 'CL 1.8 DSL 5-A', 15000),
296('Opel Astra', 'EXTRA', 'CL 1.6 I 5-A', 10000),
297('Opel Corsa', 'NORMAL', 'CITY 1.2 I 3-A', 10000),
298('Opel Vectra', 'LUXUS', 'Turbo 2.0 I 4-A', 10000),
299('Renault 19', 'EXTRA', 'RL 1.4 L KAT 5-A', 5000),
300('Renault Espace', 'LUXUS', 'RN DT 2.1 L KAT', 15000),
301('Renault Laguma', 'EXTRA', 'RT 2.0 L KAT 5-A', 15000),
302('Renault Nevada', 'EXTRA', 'RTD 2.1 L KAT 5-A', 75000),
303('Renault Twingo', 'NORMAL', '1.2 L KAT 3-A', 75000),
304('Skoda CL', 'NORMAL', 'Favorit 1.3 L KAT Comfort Line', 5000),
305('Skoda LX', 'NORMAL', 'Favorit 1.3 KAT', 5000),
306('W Vento CL', 'EXTRA', 'TD 1.9 L KAT', 15000);
307
308-- 
309-- Dumping data for table rendeles
310--
311INSERT INTO rendeles VALUES
312('12334', '348', '1993-12-01', 'Nagy Tiborne', '1994-02-01', 5, 'ABC-123', 'Opel Astra', 5308, 101978, 558600, 'I'),
313('12335', '342', '1994-02-02', 'Hotel CIVIS', '1994-03-05', 2, 'ABR-115', 'Renault 19', 144102, 145097, 134400, 'I'),
314('12336', '342', '1994-02-02', 'Hotel CIVIS', '1994-02-02', 21, 'PHD-100', 'Renault 19', 50871, 151441, 225900, 'I'),
315('12337', '344', '1994-03-30', 'Hilton', '1994-04-05', 30, 'ABR-047', 'Ford Escort', 141413, 151003, 1375800, 'N'),
316('12338', '343', '1994-03-30', 'Matav Ig.', '1994-04-05', 5, 'ABC-123', 'Opel Astra', 101978, 104965, 395940, 'N'),
317('12339', '348', '1994-04-02', 'APEH Ig.', '1994-04-10', 1, 'BAH-115', 'Opel Vectra', 50609, 51007, 55260, 'N'),
318('12340', '345', '1994-02-03', 'Hotel CIVIS', '1994-05-01', 5, 'ABR-047', 'Ford Escort', 151003, NULL, NULL, 'I'),
319('12341', '349', '1994-04-04', 'Ibusz Ig.', '1994-05-01', 10, 'ABC-123', 'W Vento CL', 52311, NULL, NULL, 'I'),
320('12342', '344', '1994-04-04', 'Hilton.', '1994-05-02', 5, 'PHD-610', 'Renault Nevada', 39066, NULL, NULL, 'I'),
321('12343', '348', '1994-04-04', 'Nagy Tiborne', '1994-04-10', 7, 'CDE-324', 'Renault Nevada', 42040, NULL, NULL, 'N'),
322('12344', '343', '1994-04-20', 'Koos Tibor', '1994-05-03', 10, 'ABC-123', 'Skoda LX', 23212, NULL, NULL, 'N'),
323('12345', '342', '1994-04-21', 'Hilton', '1994-05-03', 3, 'CIC-321', 'W Vento CL', 100021, NULL, NULL, 'I');
324
325-- 
326-- Dumping data for table alkalmazott
327--
328INSERT INTO alkalmazott VALUES
329('1234', 'Kovacs', 'Elado', '1992-12-10', 13000, 4000, '20'),
330('1235', 'Molnar', 'Szerelo', '1992-12-18', 18000, NULL, '30'),
331('1236', 'Csikos', 'Elado', '1992-12-10', 13250, 5000, '30'),
332('1237', 'Toth', 'Vizsgabiztos', '1993-03-12', 20000, NULL, '20'),
333('1238', 'Nemeth', 'Telephelyvezeto', '1993-11-28', 29000, 14000, '30'),
334('1239', 'Szabo', 'Igazgato', '1992-05-01', 54000, 75000, '10'),
335('1240', 'Balogh', 'Szerelo', '1992-06-09', 22000, 5000, '50'),
336('1244', 'Kiraly', 'Vizsgabiztos', '1993-08-04', 21000, 8000, '20'),
337('1245', 'Herczeg', 'Elado', '1993-11-12', 11000, 6000, '20'),
338('1246', 'Bognar', 'Elado', '1992-10-08', 13000, 6000, '50'),
339('1247', 'Halasz', 'Szerelo', '1999-05-10', 21000, 7000, '60'),
340('1248', 'Horvat', 'Telephelyvezeto', '1993-12-09', 25000, 12000, '60'),
341('1249', 'Kiss', 'Elado', '1993-12-23', 12500, 9500, '20');
342
343-- 
344-- Restore previous SQL mode
345-- 
346/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
347
348-- 
349-- Enable foreign keys
350-- 
351/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;