JxtNsgtS

1-- phpMyAdmin SQL Dump
2-- version 4.2.11
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Erstellungszeit: 12. Mrz 2015 um 15:26
7-- Server Version: 5.6.21
8-- PHP-Version: 5.6.3
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Datenbank: `test`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Tabellenstruktur für Tabelle `personen`
27--
28
29CREATE TABLE IF NOT EXISTS `personen` (
30  `ID` int(20) NOT NULL,
31  `Name` varchar(128) NOT NULL,
32  `Vorname` varchar(128) NOT NULL,
33  `LetzterBesuch` date NOT NULL,
34  `PersonenTyp` varchar(20) NOT NULL
35) ENGINE=InnoDB DEFAULT CHARSET=latin1;
36
37--
38-- Daten für Tabelle `personen`
39--
40
41INSERT INTO `personen` (`ID`, `Name`, `Vorname`, `LetzterBesuch`, `PersonenTyp`) VALUES
42(1, 'Drechsler', 'Heinz', '2015-03-02', 'Patient'),
43(2, 'Müller', 'Peter', '2000-01-10', 'Mitarbeiter'),
44(3, 'Lüders', 'Fritz', '2015-02-09', 'patient'),
45(4, 'Ziehzahn', 'Hans', '1999-12-12', 'mitarbeiter');
46
47/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
48/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
49/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;