-- 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 */;
