-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathkontakt.sql
79 lines (69 loc) · 5.42 KB
/
kontakt.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
-- phpMyAdmin SQL Dump
-- version 4.1.6
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Erstellungszeit: 13. Jun 2014 um 23:26
-- Server Version: 5.6.16
-- PHP-Version: 5.5.9
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Datenbank: `cmdb`
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `kontakt`
--
CREATE TABLE IF NOT EXISTS `kontakt` (
`cId` int(11) NOT NULL AUTO_INCREMENT,
`cCrtDate` date NOT NULL,
`cCrtUser` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`cUpdtDate` date NOT NULL,
`cUpdtUser` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`cVName` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`cNName` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`cCompany` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`cCity` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`cBirthDay` date NOT NULL,
`cMail` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`cPhone` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`cVersion` int(11) NOT NULL,
PRIMARY KEY (`cId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
--
-- Daten für Tabelle `kontakt`
--
INSERT INTO `kontakt` (`cId`, `cCrtDate`, `cCrtUser`, `cUpdtDate`, `cUpdtUser`, `cVName`, `cNName`, `cCompany`, `cCity`, `cBirthDay`, `cMail`, `cPhone`, `cVersion`) VALUES
(1, '2012-01-08', 'admin', '2012-01-08', 'admin', 'Barack', 'Obama', 'US State', 'Hawai', '1956-01-08', '[email protected]', '0800666666', '1'),
(2, '2012-03-08', 'admin', '2013-11-07', 'user', 'Helmut', 'Schmidt', 'Kanzleramt', 'Kalk', '1945-01-08', '[email protected]', '0175632546', '1'),
(3, '2014-03-08', 'admin', '2014-01-01', 'admin', 'Willi', 'Brandt', 'Kanzleramt', 'Brunsbuettel', '1914-01-08', '[email protected]', '02115469875', '1'),
(4, '2013-11-21', 'user', '2013-12-24', 'user', 'Helmut', 'Kohl', 'Kanzleramt', 'Rostock', '1948-01-08', '[email protected]', '072365963', '1'),
(5, '2013-11-21', 'admin', '2012-05-09', 'admin', 'Balboa', 'Rocky', 'Box', 'Arena', '1980-01-08', '[email protected]', '01025665998', '1'),
(6, '2013-11-21', 'user', '2012-08-08', 'admin', 'Bill', 'Clinton', 'US State', 'Hawana', '1961-01-08', '[email protected]', '110', '1'),
(7, '2013-11-21', 'admin', '2014-02-08', 'admin', 'Georg W.', 'Bush', 'US State', 'Teheran', '1983-01-08', '[email protected]', '112', '1'),
(8, '2013-11-21', 'admin', '2014-02-08', 'admin', 'Gustav', 'Heinemann', 'SAP', 'Waldorf', '1978-04-27', '[email protected]', '06532566584', '1'),
(9, '2013-11-21', 'admin', '2014-02-08', 'admin', 'Peter', 'Silie', 'Salat GmbH', 'Beet', '1985-11-23', '[email protected]', '01253658965', '1'),
(10, '2014-07-09', 'admin', '2014-07-09', 'admin', 'Klara', 'Korn', 'Bar&Co KG.', 'Bottrop', '1956-03-05', '[email protected]', '0863256329', '1'),
(11, '2014-07-09', 'admin', '2014-07-09', 'admin', 'Anne', 'Theke', 'Kneipen Tour AG', 'Gelsenkirchen', '1967-07-04', '[email protected]', '032648654', '1'),
(12, '2014-07-09', 'admin', '2014-07-09', 'admin', 'Irmgard', 'Patton', 'Bayer AG', 'Wuppertal', '1988-09-26', '[email protected]', '202 / 33331731', '1'),
(13, '2014-07-09', 'admin', '2014-07-09', 'admin', 'Olaf', 'Hempel', 'Bayer AG', 'Leverkusen', '1967-01-13', '[email protected]', '0214 36598754', '1'),
(14, '2014-07-09', 'admin', '2014-07-09', 'admin', 'Marvin', 'Deininger', 'IBM', 'New York', '1932-05-25', '[email protected]', '0236590565564', '1'),
(15, '2014-07-09', 'admin', '2014-07-09', 'admin', 'Reiner', 'Zufall', 'Lotto AG', 'Zugspitze', '1912-12-12', '[email protected]', '021212121', '1'),
(16, '2014-07-09', 'admin', '2014-07-09', 'admin', 'Mohammed', 'Ali', 'NBO', 'Sacramento', '1935-04-03', '[email protected]', '283473434', '1'),
(17, '2014-07-09', 'admin', '2014-07-09', 'admin', 'Maria', 'Cron', 'Mumm', 'Oppenheim', '1977-05-03', '[email protected]', '034287364', '1'),
(18, '2014-07-09', 'admin', '2014-07-09', 'admin', 'Chuck', 'Norris', 'US State', 'Boston', '1956-04-23', '[email protected]', '054564564', '1'),
(19, '2014-07-09', 'admin', '2014-07-09', 'admin', 'Bruce', 'Lee', 'US State', 'Boston', '1957-06-07', '[email protected]', '394839401', '1'),
(20, '2014-07-09', 'admin', '2014-07-09', 'admin', 'Mahatma', 'Gandhi', 'Buckingham Palace', 'England', '1868-03-27', '[email protected]', '049848', '1'),
(21, '2014-07-09', 'admin', '2014-07-09', 'admin', 'Papst', 'Franziskus', 'Vatikan AG', 'Vatikan', '1936-09-17', '[email protected]', '666', '1'),
(22, '2014-07-09', 'admin', '2014-07-09', 'admin', 'Angela', 'Merkel', 'Kanzleramt', 'Berlin', '1956-07-05', '[email protected]', '0123456789', '1'),
(23, '2014-07-09', 'admin', '2014-07-09', 'admin', 'Wladimir', 'Putin', 'KGB AG', 'Moskau', '1956-06-06', '[email protected]', '999', '1'),
(24, '2014-07-09', 'admin', '2014-07-09', 'admin', 'Bill', 'Gates', 'Microsoft', 'Redmond', '1955-08-08', '[email protected]', '0101101101010', '1'),
(25, '2014-07-09', 'admin', '2014-07-09', 'admin', 'Edward', 'Snowden', 'NSA', 'Moskau', '1983-09-11', '[email protected]', '342890', '1');
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;