· 7 years ago · Oct 11, 2018, 10:46 AM
1-- phpMyAdmin SQL Dump
2-- version 4.8.0
3-- https://www.phpmyadmin.net/
4--
5-- Host: mysql
6-- Generation Time: Oct 11, 2018 at 12:43 PM
7-- Server version: 10.1.31-MariaDB
8-- PHP Version: 7.2.9
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET AUTOCOMMIT = 0;
12START TRANSACTION;
13SET time_zone = "+00:00";
14
15
16/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19/*!40101 SET NAMES utf8mb4 */;
20
21--
22-- Database: `Count`
23--
24CREATE DATABASE IF NOT EXISTS `Count` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
25USE `Count`;
26
27-- --------------------------------------------------------
28
29--
30-- Table structure for table `count`
31--
32
33CREATE TABLE `count` (
34 `id` int(11) NOT NULL,
35 `count` int(11) DEFAULT NULL
36) ENGINE=InnoDB DEFAULT CHARSET=latin1;
37
38--
39-- Dumping data for table `count`
40--
41
42INSERT INTO `count` (`id`, `count`) VALUES
43(1, 0);
44
45--
46-- Indexes for dumped tables
47--
48
49--
50-- Indexes for table `count`
51--
52ALTER TABLE `count`
53 ADD PRIMARY KEY (`id`);
54
55--
56-- AUTO_INCREMENT for dumped tables
57--
58
59--
60-- AUTO_INCREMENT for table `count`
61--
62ALTER TABLE `count`
63 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
64--
65-- Database: `ifa_12_autovermietung`
66--
67CREATE DATABASE IF NOT EXISTS `ifa_12_autovermietung` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
68USE `ifa_12_autovermietung`;
69
70-- --------------------------------------------------------
71
72--
73-- Table structure for table `Auftrag`
74--
75
76CREATE TABLE `Auftrag` (
77 `au_id` int(11) NOT NULL,
78 `ku_id` int(11) NOT NULL,
79 `fz_id` int(11) NOT NULL,
80 `datum` date NOT NULL
81) ENGINE=InnoDB DEFAULT CHARSET=latin1;
82
83-- --------------------------------------------------------
84
85--
86-- Table structure for table `Auftragsposten`
87--
88
89CREATE TABLE `Auftragsposten` (
90 `ap_id` int(11) NOT NULL,
91 `au_id` int(11) NOT NULL,
92 `fz_id` int(11) NOT NULL,
93 `kmgefahren` int(11) NOT NULL,
94 `von` datetime NOT NULL,
95 `bis` datetime NOT NULL
96) ENGINE=InnoDB DEFAULT CHARSET=latin1;
97
98-- --------------------------------------------------------
99
100--
101-- Table structure for table `Fahrzeugart`
102--
103
104CREATE TABLE `Fahrzeugart` (
105 `fa_id` int(11) NOT NULL,
106 `beschreibung` varchar(30) NOT NULL,
107 `pauschalpreis` decimal(10,2) NOT NULL,
108 `kmpreis` decimal(10,2) NOT NULL
109) ENGINE=InnoDB DEFAULT CHARSET=latin1;
110
111--
112-- Dumping data for table `Fahrzeugart`
113--
114
115INSERT INTO `Fahrzeugart` (`fa_id`, `beschreibung`, `pauschalpreis`, `kmpreis`) VALUES
116(1, 'Transporter', '100.00', '0.60'),
117(2, 'Kleinwagen', '50.00', '0.30'),
118(5, 'Limusine', '125.00', '0.00'),
119(6, 'Fahrrad', '25.00', '0.00'),
120(7, 'LKW', '150.00', '0.60'),
121(8, 'Bobbycar', '1000.00', '12.00');
122
123-- --------------------------------------------------------
124
125--
126-- Table structure for table `Fahrzeuge`
127--
128
129CREATE TABLE `Fahrzeuge` (
130 `fz_id` int(11) NOT NULL,
131 `fa_id` int(11) NOT NULL,
132 `bezeichnung` varchar(30) NOT NULL,
133 `kfz-daten` varchar(100) NOT NULL,
134 `kmstand` int(11) NOT NULL
135) ENGINE=InnoDB DEFAULT CHARSET=latin1;
136
137--
138-- Dumping data for table `Fahrzeuge`
139--
140
141INSERT INTO `Fahrzeuge` (`fz_id`, `fa_id`, `bezeichnung`, `kfz-daten`, `kmstand`) VALUES
142(1, 1, 'Mellzeddes', 'CO-CK-69', 45667),
143(2, 2, 'Tojodda', 'FU-RZ-77', 10002),
144(3, 8, 'Bobsn', 'BOBBI', 5050),
145(4, 7, 'BMW LKW 1', 'CULI', 66666),
146(5, 5, 'BMZ i8', 'STRONKER', 1818),
147(23, 1, 'Trabser Trabbi 900PS', '17', 16);
148
149-- --------------------------------------------------------
150
151--
152-- Table structure for table `Kunde`
153--
154
155CREATE TABLE `Kunde` (
156 `ku_id` int(11) NOT NULL,
157 `vorname` varchar(30) NOT NULL,
158 `nachname` varchar(30) NOT NULL
159) ENGINE=InnoDB DEFAULT CHARSET=latin1;
160
161--
162-- Dumping data for table `Kunde`
163--
164
165INSERT INTO `Kunde` (`ku_id`, `vorname`, `nachname`) VALUES
166(1, 'Reiner', 'Wahnsinn'),
167(2, 'Bobby McBob', 'Bobbinson'),
168(3, 'Chuck', 'Norris'),
169(4, 'Michael', 'Meiers');
170
171--
172-- Indexes for dumped tables
173--
174
175--
176-- Indexes for table `Auftrag`
177--
178ALTER TABLE `Auftrag`
179 ADD PRIMARY KEY (`au_id`),
180 ADD KEY `ku_id` (`ku_id`),
181 ADD KEY `fa_id` (`fz_id`);
182
183--
184-- Indexes for table `Auftragsposten`
185--
186ALTER TABLE `Auftragsposten`
187 ADD PRIMARY KEY (`ap_id`),
188 ADD KEY `a_id` (`au_id`),
189 ADD KEY `fz_id` (`fz_id`);
190
191--
192-- Indexes for table `Fahrzeugart`
193--
194ALTER TABLE `Fahrzeugart`
195 ADD PRIMARY KEY (`fa_id`);
196
197--
198-- Indexes for table `Fahrzeuge`
199--
200ALTER TABLE `Fahrzeuge`
201 ADD PRIMARY KEY (`fz_id`),
202 ADD KEY `fa_id` (`fa_id`);
203
204--
205-- Indexes for table `Kunde`
206--
207ALTER TABLE `Kunde`
208 ADD PRIMARY KEY (`ku_id`);
209
210--
211-- AUTO_INCREMENT for dumped tables
212--
213
214--
215-- AUTO_INCREMENT for table `Auftrag`
216--
217ALTER TABLE `Auftrag`
218 MODIFY `au_id` int(11) NOT NULL AUTO_INCREMENT;
219
220--
221-- AUTO_INCREMENT for table `Auftragsposten`
222--
223ALTER TABLE `Auftragsposten`
224 MODIFY `ap_id` int(11) NOT NULL AUTO_INCREMENT;
225
226--
227-- AUTO_INCREMENT for table `Fahrzeugart`
228--
229ALTER TABLE `Fahrzeugart`
230 MODIFY `fa_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
231
232--
233-- AUTO_INCREMENT for table `Fahrzeuge`
234--
235ALTER TABLE `Fahrzeuge`
236 MODIFY `fz_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
237
238--
239-- AUTO_INCREMENT for table `Kunde`
240--
241ALTER TABLE `Kunde`
242 MODIFY `ku_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
243
244--
245-- Constraints for dumped tables
246--
247
248--
249-- Constraints for table `Auftrag`
250--
251ALTER TABLE `Auftrag`
252 ADD CONSTRAINT `Auftrag_ibfk_1` FOREIGN KEY (`ku_id`) REFERENCES `Kunde` (`ku_id`);
253
254--
255-- Constraints for table `Auftragsposten`
256--
257ALTER TABLE `Auftragsposten`
258 ADD CONSTRAINT `Auftragsposten_ibfk_1` FOREIGN KEY (`au_id`) REFERENCES `Auftrag` (`au_id`),
259 ADD CONSTRAINT `Auftragsposten_ibfk_2` FOREIGN KEY (`fz_id`) REFERENCES `Fahrzeuge` (`fz_id`);
260
261--
262-- Constraints for table `Fahrzeuge`
263--
264ALTER TABLE `Fahrzeuge`
265 ADD CONSTRAINT `Fahrzeuge_ibfk_1` FOREIGN KEY (`fa_id`) REFERENCES `Fahrzeugart` (`fa_id`);
266COMMIT;
267
268/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
269/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
270/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;