-- phpMyAdmin SQL Dump -- version 3.4.11.1deb2+deb7u6 -- http://www.phpmyadmin.net -- -- Host: wp337.webpack.hosteurope.de -- Erstellungszeit: 10. Jan 2017 um 20:21 -- Server Version: 5.6.34 -- PHP-Version: 5.4.45-0+deb7u5 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: `db12230963-7` -- -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `adressen` -- CREATE TABLE IF NOT EXISTS `adressen` ( `adr_id` int(15) unsigned NOT NULL AUTO_INCREMENT, `anrede` varchar(20) COLLATE utf8_unicode_ci NOT NULL, `vorname` varchar(30) COLLATE utf8_unicode_ci NOT NULL, `nachname` varchar(30) COLLATE utf8_unicode_ci NOT NULL, `plz` int(6) NOT NULL, `ort` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `strasse` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `web1` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `mail1` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `web2` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `mail2` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `geburtstag` varchar(15) COLLATE utf8_unicode_ci NOT NULL, `telefon1` varchar(20) COLLATE utf8_unicode_ci NOT NULL, `handy1` varchar(20) COLLATE utf8_unicode_ci NOT NULL, `abteilung` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `beruf` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `branche` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `fax` varchar(20) COLLATE utf8_unicode_ci NOT NULL, `filter_id` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1', `urgend_id` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1', `user_sperre` varchar(1) COLLATE utf8_unicode_ci NOT NULL, `user_id` int(15) NOT NULL, `infos` text COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`adr_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=34 ; -- -- Daten für Tabelle `adressen` -- INSERT INTO `adressen` (`adr_id`, `anrede`, `vorname`, `nachname`, `plz`, `ort`, `strasse`, `web1`, `mail1`, `web2`, `mail2`, `geburtstag`, `telefon1`, `handy1`, `abteilung`, `beruf`, `branche`, `fax`, `filter_id`, `urgend_id`, `user_sperre`, `user_id`, `infos`) VALUES (1, 'Herr', 'Samuel', 'Andermatt', 0, '-', '-', '', '', '', '', '', '', '', '', '', '', '', '1', '1', '0', 1, ''), (2, 'Herr', 'Ali', 'Araytac', 0, '-', '-', '', '', '', '', '', '', '', '', '', '', '', '1', '1', '0', 1, ''), (3, 'Herr', 'Lukas', 'Breunig', 5400, 'Baden', 'Mäderstrasse 15', '', 'lbreunig@hispeed.ch', '', '', '12.08.1981', '', '078 690 48 02', '', '', '1 Kiste Weisswein', '', '1', '2', '0', 1, ''), (4, 'Herr', 'Gerry', 'Brönnimann', 8951, 'Fahrweid', 'Querstrasse 6', '', 'igex@gmx.ch', '', '', '11.10.1980', '', '078 880 18 60', '', '', '1 Harass Bier', '', '1', '2', '0', 1, ''), (5, 'Herr', 'Nicola', 'Bürgi', 5423, 'Freienwil', 'alte Ehrendingerstr. 235', '', 'de-muck@gmx.ch', '', '', '14.06.1980', '', '076 768 89 79', '', '', '', '', '1', '1', '0', 1, ''), (6, 'Herr', 'Marco', 'Cleopazzo', 5312, 'Döttingen', 'Badstrasse 28a', '', 'cleopazzo@tele2.ch', '', 'cleopazzo@giroflex.ch', '29.09.1981', '', '079 682 35 74', '', 'Stv. Leiter IT/SAP', 'En Zwickel und mini weltberüehmti Apfelweihe', '', '1', '2', '0', 1, ''), (7, 'Frau', 'Carmen', 'Emmenegger', 5400, 'Baden', 'Mäderstr. 17', '', 'c.em@gmx.ch', '', '', '29.08.1981', '', '076 523 49 29', '', '', 'Tomaten-Mozzarella-Salat', '', '1', '2', '0', 1, ''), (8, 'Frau', 'Nicole', 'Erne', 5430, 'Wettingen', 'Schartenstrasse 86', '', 'erne@swissonline.ch', '', '', '26.09.1981', '', '078 617 25 35', '', '', 'komme später und bringe drum Kuchen', '', '1', '2', '0', 1, ''), (9, 'Frau', 'Irma', 'Gadient', 0, '-', '-', '', 'irmagadient@bluemail.ch', '', '', '23.08.1981', '', '079 579 48 47', '', '', '', '', '1', '1', '0', 1, ''), (10, 'Herr', 'Beat', 'Geier', 8967, 'Widen', 'Thurnweidstr. 6', '', '', '', '', '25.10.1980', '', '', '', '', '', '', '1', '1', '0', 1, ''), (11, 'Herr', 'Christian', 'Glinz', 5452, 'Oberrohrdorf', 'Buacherstr. 8', '', 'christian.glinz@gmx.ch', '', '', '09.11.1981', '', '078 845 67 97', '', '', '', '', '1', '1', '0', 1, ''), (12, 'Frau', 'Sarah', 'Huber', 5443, 'Niederrohrdorf', 'Oberdorfstr. 21a', '', '', '', '', '13.08.1980', '', '079 639 94 78', '', '', '', '', '1', '1', '0', 1, ''), (13, 'Herr', 'Sandro', 'Imbach', 5300, 'Turgi', 'Bahnhofstrasse 18', '', 's.imbach@imbach-engineering.ch', '', '', '15.07.1981', '062 212 02 81', '079 749 38 26', '', '', 'kann leider nicht (Ferien)', '', '1', '2', '0', 1, ''), (14, 'Herr', 'Philipp', 'Knecht', 5400, 'Baden', 'Wettingerstrasse 34', '', 'kniesch@hotmail.com', '', '', '08.08.1981', '', '076 346 39 19', '', '', 'Bauernbrot', '', '1', '2', '0', 1, ''), (15, 'Frau', 'Corinne', 'Kohler', 4058, 'Basel', 'Riehenteichstr. 58', '', 'Corinne.Kohler@stud.unibas.ch', '', '', '02.03.1981', '', '', '', '', '', '', '1', '1', '0', 1, ''), (16, 'Herr', 'Adrian', 'Kramer', 5430, 'Wettingen', 'Kirchstrasse 4', '', 'adikramer@hotmail.com', '', '', '08.07.1981', '', '078 788 11 08', '', '', 'Fässli Müllerbräu oder Lägerenbräu in Flaschen und', '', '1', '2', '0', 1, ''), (17, 'Frau', 'Sonja', 'Merwar', 3014, 'Bern', 'Jägerweg 2', '', 'sonja@merwar.ch ', '', '', '31.03.1981', '', '076 420 02 13', '', '', 'Tabouleh & Bun Tschlin', '', '1', '2', '0', 1, ''), (18, 'Herr', 'Maurice', 'Mühlemann', 5304, 'Endingen', 'Buckstr. 26a', '', 'maurice_muehlemann@hotmail.com', '', '', '12.05.1981', '', '079 721 61 85', '', '', '', '', '1', '1', '0', 1, ''), (19, 'Frau', 'Amy', 'Müller', 8048, 'Zürich', 'Zwischenbächen 6', '', 'amycmueller@gmail.com', '', 'a.mueller@goodnews.ch', '09.03.1980', '', '076 583 45 15', '', 'Assistant Booking & Settlement', '', '', '1', '2', '0', 1, ''), (20, 'Herr', 'Andreas', 'Müller', 8353, 'Elgg', 'Winterthurerstrasse 3', '', 'andmue@gmx.ch', '', '', '06.02.1981', '', '079 461 96 29', '', '', 'Schoggikuchen', '', '1', '2', '0', 1, ''), (21, 'Frau', 'Raphaela', 'Nöthiger', 5400, 'Baden', 'Schönaustrasse 17', '', 'raphaelabcn@hotmail.com', '', '', '', '', '078 621 95 35', '', '', '', '', '1', '2', '0', 1, ''), (22, 'Frau', 'Nicola', 'Neth', 5400, 'Baden', 'Schönaustrasse 17', '', 'nicola.neth@bluemail.ch', '', '', '02.08.1981', '', '076 433 02 17', '', '', '', '', '1', '2', '0', 1, ''), (23, 'Herr', 'Adrian', 'Rüegger', 1205, 'Genf', 'Bd de Saint Georges 46', '', 'ruegger@gmail.com', '', '', '13.06.1981', '', '', '', '', 'Rotwein', '', '1', '2', '0', 1, ''), (24, 'Herr', 'Gregor', 'Schweri', 0, '-', '-', '', 'gregorschweri@gmx.net', '', '', '', '', '076 414 82 62', '', '', '', '', '1', '1', '0', 1, ''), (25, 'Herr', 'Andreas', 'Stöckli', 5313, 'Klingnau', 'Rottrotteweg 26', '', 'manitotch@yahoo.de', '', '', '10.06.1980', '', '078 751 70 62', '', '', '', '', '1', '1', '0', 1, ''), (26, 'Herr', 'Dilip', 'Vimalassery', 5400, 'Baden', 'Kreuzweg 21', '', 'dilip@gmx.ch', '', '', '12.04.1981', '', '076 579 48 47', '', '', 'Reissalat', '', '1', '2', '0', 1, ''), (27, 'Herr', 'Adrian', 'Walker', 5454, 'Bellikon', 'Bösmattweg 9', '', 'adiwalker@hotmail.com', '', '', '23.09.1981', '', '078 662 60 97', '', '', '', '', '1', '1', '0', 1, ''), (28, 'Frau', 'Marion', 'Wild', 8902, 'Urdorf', 'Schönenwerdstr 7', '', 'wildm@bluewin.ch', '', '', '31.07.1981', '', '079 774 65 35', '', '', 'grüner Salat', '', '1', '2', '0', 1, ''), (29, 'Herr', 'Andreas', 'Bugmann', 0, '-', '-', '', '', '', '', '', '', '', '', '', '', '', '1', '1', '0', 1, ''), (30, 'Frau', 'Bettina', 'Gysel', 0, '-', '-', '', '', '', '', '', '', '', '', '', '', '', '1', '1', '0', 1, ''), (31, 'Frau', 'Daniela', 'Woweries', 0, '-', '-', '', '', '', '', '', '', '', '', '', '', '', '1', '1', '0', 1, ''), (32, 'neu! 2011', 'Corinne', 'Kohler', 0, '8004', 'Rotwandstrasse 65', '', 'corinne.kohler@getlost.ch', '', '', '', '', '', '', '', '', '', '1', '1', '0', 1, ''), (33, ':-) noch nen Versuch', 'Corinne', 'Kohler', 8004, 'Zürich', 'Rotwandstrasse 65', '', 'corinne.kohler@getlost.ch', '', '', '', '', '', '', '', '', '', '1', '1', '0', 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 */;