· 8 years ago · Jul 11, 2018, 11:16 AM
1-- --------------------------------------------------------
2-- Host: 127.0.0.1
3-- Server version: 5.1.61-0ubuntu0.10.04.1 - (Ubuntu)
4-- Server OS: debian-linux-gnu
5-- HeidiSQL version: 7.0.0.4053
6-- Date/time: 2012-03-20 20:19:54
7-- --------------------------------------------------------
8
9/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
10/*!40101 SET NAMES utf8 */;
11/*!40014 SET FOREIGN_KEY_CHECKS=0 */;
12
13-- Dumping database structure for game_shop
14DROP DATABASE IF EXISTS `game_shop`;
15CREATE DATABASE IF NOT EXISTS `game_shop` /*!40100 DEFAULT CHARACTER SET latin1 */;
16USE `game_shop`;
17
18
19-- Dumping structure for table game_shop.artikel
20CREATE TABLE IF NOT EXISTS `artikel` (
21 `ANR` int(8) NOT NULL AUTO_INCREMENT,
22 `GNR` int(8) NOT NULL,
23 `Preis` decimal(8,2) NOT NULL,
24 `Bestand` int(8) NOT NULL,
25 `Platform` varchar(200) NOT NULL,
26 PRIMARY KEY (`ANR`),
27 KEY `GNR` (`GNR`)
28) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=latin1;
29
30-- Dumping data for table game_shop.artikel: 0 rows
31DELETE FROM `artikel`;
32/*!40000 ALTER TABLE `artikel` DISABLE KEYS */;
33INSERT INTO `artikel` (`ANR`, `GNR`, `Preis`, `Bestand`, `Platform`) VALUES
34 (1, 1, 59.99, 2, 'xbox'),
35 (2, 2, 39.99, 1, 'xbox'),
36 (3, 3, 39.99, 3, 'xbox'),
37 (4, 4, 29.99, 6, 'xbox'),
38 (5, 5, 39.99, 2, 'xbox'),
39 (6, 5, 29.99, 3, 'ps3'),
40 (7, 6, 39.99, 2, 'ps3'),
41 (8, 7, 19.99, 4, 'ps3'),
42 (9, 8, 9.99, 6, 'ps3'),
43 (10, 9, 19.99, 3, 'ps3'),
44 (11, 2, 39.99, 5, 'ps3'),
45 (12, 3, 59.99, 1, 'ps3'),
46 (13, 10, 29.99, 0, 'wii'),
47 (14, 11, 19.99, 4, 'wii'),
48 (15, 12, 39.99, 5, 'wii'),
49 (16, 13, 10.99, 8, 'wii'),
50 (17, 2, 39.99, 6, 'wii'),
51 (18, 3, 39.99, 25, 'wii'),
52 (19, 1, 59.99, 6, 'wii');
53/*!40000 ALTER TABLE `artikel` ENABLE KEYS */;
54
55
56-- Dumping structure for table game_shop.games
57CREATE TABLE IF NOT EXISTS `games` (
58 `GNR` int(8) NOT NULL AUTO_INCREMENT,
59 `Name` varchar(200) NOT NULL,
60 `Genre` varchar(200) NOT NULL,
61 PRIMARY KEY (`GNR`)
62) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
63
64-- Dumping data for table game_shop.games: 13 rows
65DELETE FROM `games`;
66/*!40000 ALTER TABLE `games` DISABLE KEYS */;
67INSERT INTO `games` (`GNR`, `Name`, `Genre`) VALUES
68 (1, 'Assasins Creed', 'action'),
69 (2, 'Call of Duty 1', 'shooter'),
70 (3, 'Call of Duty 2', 'shooter'),
71 (4, 'Final Fantasy', 'RPG'),
72 (5, 'Blur', 'racing'),
73 (6, 'Split Second', 'racing'),
74 (7, 'Modnation Racers', 'racing'),
75 (8, 'Little Big Planet', 'platformer'),
76 (9, 'Little Big Planet 2', 'platformer'),
77 (10, 'Bass Hunter', 'sport'),
78 (11, 'Wii Sport', 'sport'),
79 (12, 'Wii Fit', 'sport'),
80 (13, 'Trackmania', 'racing');
81/*!40000 ALTER TABLE `games` ENABLE KEYS */;
82
83
84-- Dumping structure for table game_shop.kunden
85CREATE TABLE IF NOT EXISTS `kunden` (
86 `KID` int(8) NOT NULL AUTO_INCREMENT,
87 `Name` varchar(30) NOT NULL,
88 `Vorname` varchar(30) NOT NULL,
89 `PLZ` varchar(10) NOT NULL,
90 `Addresse` varchar(50) NOT NULL,
91 PRIMARY KEY (`KID`)
92) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
93
94-- Dumping data for table game_shop.kunden: 10 rows
95DELETE FROM `kunden`;
96/*!40000 ALTER TABLE `kunden` DISABLE KEYS */;
97INSERT INTO `kunden` (`KID`, `Name`, `Vorname`, `PLZ`, `Addresse`) VALUES
98 (1, 'Mustermann', 'Max', '26789', 'Blütenweg 33'),
99 (2, 'Maßlig', 'Jan', '26789', 'Rosenweg 12'),
100 (3, 'Plum', 'Elke', '52334', 'Hauptstraße 4'),
101 (4, 'Meier', 'Detlef', '52351', 'Moorweg 80'),
102 (5, 'Meier', 'Dieter', '32351', 'Lilienweg 54'),
103 (6, 'Ritter', 'Sascha', '2223', 'Luftstraße 35'),
104 (7, 'Terveer', 'Horst', '55223', 'Daimlerstraße 88'),
105 (8, 'Harms', 'Horst', '26789', 'Rostweg 12'),
106 (9, 'Nano', 'Sina', '67342', 'Kolonistenweg 12'),
107 (10, 'Fünfter', 'Pascal', '2223', 'Moorweg 80');
108/*!40000 ALTER TABLE `kunden` ENABLE KEYS */;
109/*!40014 SET FOREIGN_KEY_CHECKS=1 */;
110/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;