· 11 years ago · Oct 01, 2015, 11:48 AM
1-- phpMyAdmin SQL Dump
2-- version 4.4.14
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Erstellungszeit: 01. Okt 2015 um 13:44
7-- Server-Version: 5.6.26
8-- PHP-Version: 5.5.28
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 utf8mb4 */;
18
19--
20-- Datenbank: `gaestebuch`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Tabellenstruktur für Tabelle `eintraege`
27--
28
29CREATE TABLE IF NOT EXISTS `eintraege` (
30 `id` int(11) unsigned NOT NULL,
31 `datum` datetime NOT NULL,
32 `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
33 `email` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
34 `nachricht` text COLLATE utf8_unicode_ci NOT NULL,
35 `Date_1` date NOT NULL,
36 `DATE-2` date NOT NULL
37) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
38
39--
40-- Daten für Tabelle `eintraege`
41--
42
43INSERT INTO `eintraege` (`id`, `datum`, `name`, `email`, `nachricht`, `Date_1`, `DATE-2`) VALUES
44(12, '2015-09-21 11:12:42', 'Andre', 'pharahos-gold3@hotmail.com', 'mittwoch', '0000-00-00', '0000-00-00'),
45(13, '2015-09-21 13:49:05', 'dd', 'pharahos-gold3@hotmail.com', '', '0000-00-00', '0000-00-00'),
46(14, '2015-09-21 13:49:05', 'dd', 'pharahos-gold3@hotmail.com', '', '0000-00-00', '0000-00-00'),
47(15, '2015-09-21 14:05:31', 'derda', 'pharahos-gold3@hotmail.com', '', '0000-00-00', '0000-00-00'),
48(16, '2015-09-21 14:05:31', 'derda', 'pharahos-gold3@hotmail.com', '', '0000-00-00', '0000-00-00'),
49(17, '2015-09-21 14:07:46', 'Andre', 'pharahos-gold3@hotmail.com', '', '0000-00-00', '0000-00-00'),
50(19, '2015-09-21 16:24:01', '<br /><b>Notice</b>: Undefined variable: formData', '<br /><b>Notice</b>: Undefined variable: formData', '<?phpecho $formData[''nachricht'']', '0000-00-00', '0000-00-00'),
51(21, '2015-09-21 18:25:31', 'dd', 'pharahos-gold3@hotmail.com', '<?phpecho $formData[''nachricht'']', '0000-00-00', '0000-00-00'),
52(22, '2015-09-21 18:27:39', 'dd', 'pharahos-gold3@hotmail.com', '<?phpecho $formData[''nachricht'']', '0000-00-00', '0000-00-00'),
53(23, '2015-09-21 18:30:11', 'dd', 'pharahos-gold3@hotmail.com', '<?phpecho $formData[''nachricht'']', '0000-00-00', '0000-00-00'),
54(26, '2015-09-21 18:31:29', 'derda', 'Hotmail@live', '', '0000-00-00', '0000-00-00'),
55(27, '2015-09-21 18:31:47', 'ff', 'pharahos-gold3@hotmail.com', '', '0000-00-00', '0000-00-00'),
56(28, '2015-09-21 19:02:26', '', '', '', '0000-00-00', '0000-00-00'),
57(29, '2015-09-21 19:02:28', '', '', '', '0000-00-00', '0000-00-00'),
58(30, '2015-09-21 19:02:29', '', '', '', '0000-00-00', '0000-00-00'),
59(31, '2015-09-21 19:17:30', '', '', '', '0000-00-00', '0000-00-00'),
60(32, '2015-09-21 19:22:58', '', '', '', '0000-00-00', '0000-00-00'),
61(33, '2015-09-21 19:23:54', '', '', '', '0000-00-00', '0000-00-00'),
62(34, '2015-09-21 19:24:06', 'j', '', '', '0000-00-00', '0000-00-00'),
63(35, '2015-09-21 19:24:09', '', '', '', '0000-00-00', '0000-00-00'),
64(36, '2015-09-21 19:25:48', 'k', '', '', '0000-00-00', '0000-00-00'),
65(37, '2015-09-21 19:25:50', '', '', '', '0000-00-00', '0000-00-00'),
66(38, '2015-09-21 19:27:06', '', 'jjjlö', '', '0000-00-00', '0000-00-00'),
67(39, '2015-09-21 19:27:08', '', '', '', '0000-00-00', '0000-00-00'),
68(40, '2015-09-21 19:34:16', '', '', '', '0000-00-00', '0000-00-00'),
69(41, '2015-09-21 19:36:59', '', '', '', '0000-00-00', '0000-00-00'),
70(42, '2015-09-21 19:37:14', 'gg', '', '', '0000-00-00', '0000-00-00'),
71(43, '2015-09-21 19:45:18', '', '', '', '0000-00-00', '0000-00-00'),
72(44, '2015-09-21 19:51:49', '', '', '', '0000-00-00', '0000-00-00'),
73(45, '2015-09-21 19:51:55', '', '', '', '0000-00-00', '0000-00-00'),
74(46, '2015-09-21 19:51:59', '', '', '', '0000-00-00', '0000-00-00'),
75(47, '2015-09-21 19:53:04', '', '', '', '0000-00-00', '0000-00-00'),
76(48, '2015-09-21 20:08:09', 'hh', 'ggg', 'ggg', '0000-00-00', '0000-00-00'),
77(49, '2015-09-22 11:57:34', 'ich', 'bin', 'nacht', '0000-00-00', '0000-00-00'),
78(50, '2015-09-22 12:01:50', 'dddd', 'gg', 'rrr', '0000-00-00', '0000-00-00'),
79(51, '2015-09-23 11:18:32', '', '', '', '0000-00-00', '0000-00-00'),
80(52, '2015-09-23 11:19:49', '', '', '', '0000-00-00', '0000-00-00'),
81(53, '2015-09-24 11:08:25', 'b', 'gggg@sss', 'neu', '0000-00-00', '0000-00-00'),
82(55, '2015-09-27 18:57:07', 'And', 'mail2', 'qwwwwwwwwwwwwrtt\r\nasdfghjkqwerttzuiooil\r\nrfsdzhdfkjutiuiuoztuozutitzurtecrrwrwrtretwetewtrewterzer', '0000-00-00', '0000-00-00'),
83(56, '2015-09-28 13:19:34', 'g', 'q', 'hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh', '0000-00-00', '0000-00-00'),
84(59, '2015-09-29 15:09:35', 'd', 'f@d', 'a', '0000-00-00', '0000-00-00');
85
86--
87-- Indizes der exportierten Tabellen
88--
89
90--
91-- Indizes für die Tabelle `eintraege`
92--
93ALTER TABLE `eintraege`
94 ADD PRIMARY KEY (`id`);
95
96--
97-- AUTO_INCREMENT für exportierte Tabellen
98--
99
100--
101-- AUTO_INCREMENT für Tabelle `eintraege`
102--
103ALTER TABLE `eintraege`
104 MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=60;
105/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
106/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
107/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;