-- http://www.phpmyadmin.net
--
-- Erstellungszeit: 02. Feb 2018 um 20:35
-- Server-Version: 5.7.19
-- PHP-Version: 5.6.32




-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `category`
--

CREATE TABLE `category` (
  `id` int(10) UNSIGNED NOT NULL,
  `category_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `category_desc` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `category_slug` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `citytransport`
--

CREATE TABLE `citytransport` (
  `ID` int(11) NOT NULL,
  `Anrede` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Vorname` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Nachname` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Adresse` text COLLATE latin1_general_ci NOT NULL,
  `Telefon` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Sonstiges` text COLLATE latin1_general_ci NOT NULL,
  `Email` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Mailversand` varchar(4) COLLATE latin1_general_ci NOT NULL,
  `WeitereEmpfaenger` text COLLATE latin1_general_ci NOT NULL,
  `Besichtigungstermin` date NOT NULL,
  `Besichtigungstermin2` date NOT NULL,
  `Besichtigungstermin3` date NOT NULL,
  `Zeit` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Zeit2` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Zeit3` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Bemerkung` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `BemerkungOption` tinyint(1) NOT NULL,
  `Umzug` varchar(2) COLLATE latin1_general_ci NOT NULL,
  `Objekt` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `AdresseAuszug` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `EtageAuszug` varchar(20) COLLATE latin1_general_ci NOT NULL,
  `LiftAuszug` varchar(20) COLLATE latin1_general_ci NOT NULL,
  `AdresseEinzug` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `EtageEinzug` varchar(20) COLLATE latin1_general_ci NOT NULL,
  `LiftEinzug` varchar(20) COLLATE latin1_general_ci NOT NULL,
  `Tarif` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Umzugstermin` date NOT NULL,
  `Aufwand` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Aufwand2` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Arbeitsbeginn` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Anfahrt` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `AnfahrtDistanz` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Rueckfahrt` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `RueckfahrtDistanz` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Zusatzkosten` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Zusatzkosten2` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Zahlungsbedingung` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Kosten` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Kosten2` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `maxKosten` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Kostendach` varchar(2) COLLATE latin1_general_ci NOT NULL,
  `Pauschal` varchar(2) COLLATE latin1_general_ci NOT NULL,
  `Spesen` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Promotionen` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Abbau` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Aufbau` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Einpacken` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Auspacken` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Einpackservice` varchar(2) COLLATE latin1_general_ci NOT NULL,
  `Auspackservice` varchar(2) COLLATE latin1_general_ci NOT NULL,
  `Reinigung` varchar(2) COLLATE latin1_general_ci NOT NULL,
  `Verpackungsmaterial` varchar(2) COLLATE latin1_general_ci NOT NULL,
  `Lagerung` varchar(2) COLLATE latin1_general_ci NOT NULL,
  `Entsorgung` varchar(2) COLLATE latin1_general_ci NOT NULL,
  `Code` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `Datum` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Offertentyp` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `Offerte` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `Status` tinyint(1) NOT NULL,
  `Rechnung` tinyint(1) NOT NULL,
  `Besichtigung` int(11) NOT NULL,
  `Quittung` tinyint(1) NOT NULL,
  `Umsatzliste` int(11) NOT NULL,
  `Bestaetigung` tinyint(4) NOT NULL,
  `BestaetigungValues` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `AuftragBestLID` int(11) NOT NULL,
  `MailNachfrage1` tinyint(2) NOT NULL,
  `MailNachfrage2` tinyint(2) NOT NULL,
  `MailBewertung1` tinyint(2) NOT NULL,
  `MailBewertung2` tinyint(2) NOT NULL,
  `MailVorbereitung1` tinyint(2) NOT NULL,
  `MailVorbereitung2` tinyint(2) NOT NULL,
  `MailVorbereitung3` tinyint(2) NOT NULL,
  `MailVorbereitung4` tinyint(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Daten für Tabelle `citytransport`
--

INSERT INTO `citytransport` (`ID`, `Anrede`, `Vorname`, `Nachname`, `Adresse`, `Telefon`, `Sonstiges`, `Email`, `Mailversand`, `WeitereEmpfaenger`, `Besichtigungstermin`, `Besichtigungstermin2`, `Besichtigungstermin3`, `Zeit`, `Zeit2`, `Zeit3`, `Bemerkung`, `BemerkungOption`, `Umzug`, `Objekt`, `AdresseAuszug`, `EtageAuszug`, `LiftAuszug`, `AdresseEinzug`, `EtageEinzug`, `LiftEinzug`, `Tarif`, `Umzugstermin`, `Aufwand`, `Aufwand2`, `Arbeitsbeginn`, `Anfahrt`, `AnfahrtDistanz`, `Rueckfahrt`, `RueckfahrtDistanz`, `Zusatzkosten`, `Zusatzkosten2`, `Zahlungsbedingung`, `Kosten`, `Kosten2`, `maxKosten`, `Kostendach`, `Pauschal`, `Spesen`, `Promotionen`, `Abbau`, `Aufbau`, `Einpacken`, `Auspacken`, `Einpackservice`, `Auspackservice`, `Reinigung`, `Verpackungsmaterial`, `Lagerung`, `Entsorgung`, `Code`, `Datum`, `Offertentyp`, `Offerte`, `Status`, `Rechnung`, `Besichtigung`, `Quittung`, `Umsatzliste`, `Bestaetigung`, `BestaetigungValues`, `AuftragBestLID`, `MailNachfrage1`, `MailNachfrage2`, `MailBewertung1`, `MailBewertung2`, `MailVorbereitung1`, `MailVorbereitung2`, `MailVorbereitung3`, `MailVorbereitung4`) VALUES
(143, 'Herr', 'Babrak', 'Rahimi', 'Usterstrasse 18\r\n8620 Wetzikon', '076328498', '', 'info@umzugszentrale.ch', 'ja', '', '0000-00-00', '0000-00-00', '0000-00-00', '', '', '', '', 0, 'ja', '5 1/2 Zimmer-Wohnung', 'Usterstrasse 18 8620 Wetzikon', 'EFH', 'Ja', 'Usterstrasse 18 8620 Wetzikon', 'UG', 'Ja', '2 MA für CHF 200.-/ h', '2018-02-16', '3.0 h', '6.0 h', '08:00 Uhr', '5.5 h', '-', '', '', '–', '–', '', 'CHF 1700.-', '2300.-', 'CHF 2645.-', '', '', '', '-', 'Umzugszentrale', '', '', '', '', '', 'ja', '', '', '', '0a945d798da1e5c', '2018-01-23 10:10:33', 'Wohnung', '', 1, 0, 66, 0, 0, 0, '', 0, 1, 1, 1, 1, 0, 1, 0, 0),
(144, 'Herr', 'Babrak', 'Rahimi', 'Usterstrasse 18\r\n8620 Wetzikon', '0763284989', '2 Schrank, Bett, Kommode, viel Velos,', 'info@umzugszentrale.ch', 'ja', '', '0000-00-00', '0000-00-00', '0000-00-00', '', '', '', '', 0, 'ja', '5 1/2 Zimmer Einfamilienhaus', 'Usterstrasse 18, 8620 Wetzikon', 'EFH', 'Nein', 'Bahnhofstrasse 18, 8620 Wetzikon', '2', 'Ja', '2 MA mit 1 LW für CHF 160.-/h', '2018-03-31', '7.0 h', '8.0 h', '08:00 Uhr', 'keine', '-', '', '', '–', '–', '', 'CHF 1120.-', '1280.-', 'CHF 1472.-', '', '', '', '-', 'Umzugszentrale', '', '', '', '', '', 'ja', '', '', '', '7783be6e5876e08', '2018-01-23 13:11:20', 'Wohnung', '', 1, 0, 67, 0, 0, 0, '', 0, 0, 1, 0, 0, 0, 1, 0, 0),
(145, 'Herr', 'Markus', 'Vogt', 'Witikonerstrasse 37\r\n8032 Zürich', '0792534955', '', 'markus_vogt@outlook.com', 'ja', '', '2018-01-26', '2018-01-29', '2018-01-31', '13:30 - 18:30', '8:00', '8:00 - 18:30', '', 0, 'ja', '1 1/2 Zimmer-Wohnung', 'Witikonerstrasse 37, 8032 Zürich', '5', 'Ja', 'Egghölzlistrasse 45, 3015 Bern', '2', 'Nein', '2 MA mit 1 LW für CHF 160.-/h', '2018-03-26', '3.0 h', '5.0 h', '08:00 Uhr', '1.0 h', '-', '', '', '–', '–', '', 'CHF 640.-', '960.-', 'CHF 1104.-', '', '', '', '-', 'Umzugszentrale', '', '', '', '', '', 'ja', '', '', '', '0991a8995fabd45', '2018-01-23 14:19:59', 'Email', '', 1, 0, 0, 0, 0, 0, '', 0, 0, 1, 0, 0, 0, 0, 0, 0),
(146, 'Herr', 'René', 'Urech', 'Lindenstrasse 1\r\n8302 Kloten', '0792486506', '', 'ren.ure@outlook.com', 'ja', '', '0000-00-00', '0000-00-00', '0000-00-00', '', '', '', '', 0, '', '-', '', '–', 'Ja', '', '–', 'Ja', '1 Packer für CHF 60.-/h.', '0000-00-00', '3.0 h', '', '08:00 Uhr', 'keine', '-', '', '', '–', '–', '', 'CHF 180.-', '', 'CHF 207.-', '', '', '', '-', 'Umzugszentrale', '', '', '', '', '', 'ja', '', '', '', '40adb1d5192aa9a', '2018-01-23 14:29:09', 'Wohnung', '', 1, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0),
(147, 'Frau', 'Christina', 'Schwob', 'Rombachstrasse 31\r\n5734 Aarau', '0796068977', '', 'chregeschwob@hotmail.com', 'ja', '', '0000-00-00', '0000-00-00', '0000-00-00', '', '', '', 'Wir haben einen Mindestaufwand von drei Stunden. Wir rechnen danach in viertel Stundentakt ab.', 0, 'ja', '-', 'Rombachstrasse 31, 5734 Aarau', '3', 'Nein', 'Titlisstrasse 11, 5743 Reinach', '–', 'Nein', '3 MA mit 1 LW für CHF 190.-/ h', '2018-01-26', '3.0 h', '', '08:00 Uhr', '0.5 h', '-', '', '', 'Klavier CHF 250.–', '–', '', 'CHF 915.-', '', 'CHF 1052.-', '', '', '', '-', 'Umzugszentrale', '', '', '', '', '', '', '', '', '', '884e8ac7d727ef0', '2018-01-23 14:39:56', 'Wohnung', '', 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0),
(148, 'Frau', 'Franziska', 'Ernst', 'Weitersehen 40\r\n5722 Gränichen', '0766032249', '', 'engel230607@aol.com', 'ja', '', '0000-00-00', '0000-00-00', '0000-00-00', '', '', '', '', 0, 'ja', '1 Zimmer-Wohnung', 'Weitersehen 40, 5722 Gränichen', 'EG', 'Nein', 'Brotkorbstrasse 8, 4332 Stein AG', '4', 'Nein', '2 MA mit 1 LW für CHF 150.-/h', '2018-01-27', '3.0 h', '4.0 h', '08:00 Uhr', 'keine', '-', '', '', '–', '–', '', 'CHF 450.-', '600.-', 'CHF 690.-', '', '', '', '-', 'Umzugszentrale', '', '', '', '', '', '', '', '', '', '2dff182ce6a2329', '2018-01-23 14:46:38', 'Wohnung', '', 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0),
(149, 'Frau', 'Svenja', '.', 'Gustav Zeiler-Ring 9\r\n5600 Lenzburg', '0791028477', '', 'svenja.c.albrecht@gmail.com', 'ja', '', '2018-01-26', '2018-01-29', '2018-01-31', '13:00 - 13:30', '13:30 - 18:00', '8:30 - 18:00', '', 0, 'ja', '1 Zimmer-Wohnung', 'Gustav Zeiler-Ring 9, 5600 Lenzburg', '1', 'Nein', 'Alte Spinnerei 8, 5210 Windisch', '2', 'Nein', '2 MA mit 1 LW für CHF 160.-/h', '2018-03-27', '3.0 h', '4.0 h', '08:00 Uhr', 'keine', '-', '', '', '–', '–', '', 'CHF 480.-', '640.-', 'CHF 736.-', '', '', '', '-', 'Umzugszentrale', '', '', '', '', '', 'ja', '', '', '', '34596dbbd69bf13', '2018-01-23 14:53:20', 'Email', '', 1, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0),
(150, 'Herr', 'Hüseyin', 'Bektas', 'Bağlar Mah. Türbe Cad. bilrlik evler', '05366658122', '', 'bektas_hueseyin@hotmail.com', 'ja', '', '0000-00-00', '0000-00-00', '0000-00-00', '', '', '', '', 0, '', '1 1/2 Zimmer Einfamilienhaus', 'Bağlar Mah. Türbe Cad. bilrlik evler', '–', 'Ja', '', '–', 'Ja', '', '2018-01-31', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '7feb4fbadeeca3d', '2018-01-23 19:32:41', '', '', 2, 0, 68, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0),
(151, 'Herr', 'Max', 'Muster', 'Musterstraße', '12345678', '', 'tb@vbnl.net', 'ja', '', '0000-00-00', '0000-00-00', '0000-00-00', '', '', '', '', 0, '', '-', '', '–', 'Ja', '', '–', 'Ja', '', '2018-01-26', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'c03df0c18e5b92c', '2018-01-23 19:35:33', '', '', 2, 0, 69, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0),
(152, 'Herr', 'Max', 'Muster', 'Musterstraße', '12345678', '', 'tb@vbnl.net', 'ja', '', '0000-00-00', '0000-00-00', '0000-00-00', '', '', '', '', 0, '', '-', '', '–', 'Ja', '', '–', 'Ja', '', '2018-01-26', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '59f8754e7ccc4cb', '2018-01-23 19:55:52', '', '', 2, 0, 90, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0),
(153, 'Herr', 'Hüseyin', 'Bektas', 'Bağlar Mah. Türbe Cad. bilrlik evler', '05366658122', '', 'bektas_hueseyin@hotmail.com', 'ja', '', '0000-00-00', '0000-00-00', '0000-00-00', '', '', '', '', 0, '', '1 1/2 Zimmer Einfamilienhaus', 'Bağlar Mah. Türbe Cad. bilrlik evler', 'EG', 'Ja', 'Bağlar Mah. Türbe Cad. bilrlik evler', '6', 'Ja', '', '2018-01-30', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '13ade88f0523f26', '2018-01-23 19:58:16', '', '', 2, 0, 91, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0),
(154, 'Herr', 'Hüseyin', 'Bektas', 'Bağlar Mah. Türbe Cad. bilrlik evler', '05366658122', '', 'bektas_hueseyin@hotmail.com', 'ja', '', '0000-00-00', '0000-00-00', '0000-00-00', '', '', '', '', 0, '', '1 Zimmer Einfamilienhaus', 'Bağlar Mah. Türbe Cad. bilrlik evler', '–', 'Ja', '', '–', 'Ja', '', '2018-01-29', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'c71fbb11dd21cc3', '2018-01-23 19:59:14', '', '', 2, 0, 92, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0),
(155, 'Herr', 'Hüseyin', 'Bektas', 'Bağlar Mah. Türbe Cad. bilrlik evler', '05366658122', '', 'bektas_hueseyin@hotmail.com', 'ja', '', '2018-01-24', '2018-01-25', '2018-01-26', '21:00', '14:00', '21:00', 'bemerkung umzug', 0, 'ja', '2 Zimmer-Wohnung', 'Bağlar Mah. Türbe Cad. bilrlik evler', 'UG', 'Ja', 'Bağlar Mah. Türbe Cad. bilrlik evler', 'EFH', 'Ja', '1 Packer für CHF 60.-/h.', '2018-01-27', '3.0 h', '1.0 h', '08:00 Uhr', '2.0 h', '-', '', '', 'Spesen CHF 40.–', 'Spesen CHF 80.–', '', 'CHF 336.-', '', 'CHF 386.-', 'Ja', '', '', '20% Rabatt AMOS IT Suisse', 'Umzugszentrale', '', '', '', 'ja', '', 'ja', 'ja', '', 'ja', 'f0a9d220d6185b9', '2018-01-23 20:05:38', 'Wohnung', '', 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0),
(156, 'Frau', 'Hüseyin', 'Bektas', 'Bağlar Mah. Türbe Cad. bilrlik evler', '05366658122', '', 'bektas_hueseyin@hotmail.com', 'ja', '', '0000-00-00', '0000-00-00', '0000-00-00', '', '', '', '', 0, '', '2 1/2 Zimmer Einfamilienhaus', 'Bağlar Mah. Türbe Cad. bilrlik evler', '5-6', 'Ja', 'Bağlar Mah. Türbe Cad. bilrlik evler', '7', 'Ja', '', '2018-01-29', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '9584833a6a35140', '2018-01-23 20:16:50', '', '', 2, 0, 93, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0),
(157, 'Herr', 'Babrak', 'Rahimi', 'Usterstrasse 18\r\n8620 Wallisellen', '0763284989', '', 'babrak@gmx.ch', 'ja', '', '2018-01-25', '2018-01-26', '2018-01-27', '08:00 - 12:00', '10:00-12:00', '14:00-18:00', '', 0, 'ja', '7 Zimmer-Wohnung', 'Usterstrasse 18 8620 Wallisellen', 'Hochparterre', 'Ja', 'Usterstrasse 18 8620 Wetzikon', '1-3', 'Ja', '2 MA mit 1 LW für CHF 170.-/h', '2018-04-28', '6.0 h', '8.0 h', '08:00 Uhr', 'keine', '-', '', '', '–', '–', '', 'CHF 1020.-', '1360.-', 'CHF 1564.-', '', '', '', '-', 'Umzugszentrale', '', '', '', '', '', '', '', '', '', 'daa840ea66ac7a2', '2018-01-24 09:38:04', 'Email', '', 1, 0, 94, 0, 0, 0, '', 4, 0, 1, 1, 0, 1, 1, 1, 0),
(158, 'Herr', 'Gustavo', 'Sanz', 'Radarstrasse\r\n3013 Bern', '0795417062', '', 'gustavo.sanz@swisscom.com', 'ja', '', '0000-00-00', '0000-00-00', '0000-00-00', '', '', '', '', 0, 'ja', '3 1/2 Zimmer-Wohnung', 'Radarstrasse, 3013 Bern', '3', 'Ja', 'Akazienweg 1, 3072 Ostermundingen', 'Parterre', 'Ja', '3 MA mit 1 LW für CHF 250.-/ h', '2018-01-31', '5.0 h', '6.0 h', '08:00 Uhr', '2.0 h', '-', '', '', '–', '–', '', 'CHF 1400.-', '1600.-', 'CHF 1840.-', '', '', '', '20%', 'Umzugszentrale', '', '', '', '', '', 'ja', '', '', '', '30feb3708681455', '2018-01-24 10:15:51', 'Email', '', 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0),
(159, 'Frau', 'Rosalinda', 'Zhang', 'Gartenstrasse 28\r\n5400 Baden', '0762392866', '', 'rosalinda629@yahoo.com', 'ja', '', '0000-00-00', '0000-00-00', '0000-00-00', '', '', '', '', 0, 'ja', '2 Zimmer-Wohnung', 'Gartenstrasse 28, 5400 Baden', '3', 'Ja', 'Winkelweg 1, 5426 Lengnau', '1', 'Nein', '2 MA mit 1 LW für CHF 160.-/h', '2018-01-27', '4.0 h', '5.0 h', '08:00 Uhr', 'keine', '-', '', '', '–', '–', '', 'CHF 640.-', '800.-', 'CHF 920.-', '', '', '', '-', 'Umzugszentrale', '', '', '', '', '', 'ja', '', '', '', '8c07e7ec586459c', '2018-01-24 10:22:14', 'Email', '', 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0),
(160, 'Frau', 'Ersin', 'Rahimi', 'Usterstrasse 18\r\n8620 Wetzikon', '0765234878', '', 'esasmaz_04@hotmail.com', 'ja', '', '0000-00-00', '0000-00-00', '0000-00-00', '', '', '', '', 0, '', '-', '', '–', 'Ja', '', '–', 'Ja', '1 Packer für CHF 60.-/h.', '0000-00-00', '3.0 h', '', '08:00 Uhr', 'keine', '-', '', '', '–', '–', '', 'CHF 180.-', '', 'CHF 207.-', '', '', '', '-', 'Umzugszentrale', '', '', '', '', '', 'ja', '', '', '', '6272a5de1478c8e', '2018-01-24 10:51:36', 'Email', '', 1, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0),
(161, 'Herr', 'Davide', 'Audino', 'Bürenstrasse 15\r\n3007 Bern', '0795748345', '', 'davide.audino@swisscom.com', 'ja', '', '0000-00-00', '0000-00-00', '0000-00-00', '', '', '', '', 0, 'ja', '2 Zimmer-Wohnung', 'Bürenstrasse 15\r\n3007 Bern', '2', 'Ja', 'Weingartstrasse 26\r\n3014 Bern', '2', 'Ja', '3 MA mit 1 LW für CHF 250.-/ h', '2018-04-03', '4.0 h', '5.0 h', '08:00 Uhr', '2.0 h', '-', '', '', '–', '–', '', 'CHF 1200.-', '1400.-', 'CHF 1610.-', '', '', '', '20%', 'Umzugszentrale', '', '', '', '', '', 'ja', '', '', '', 'ce1f5f5bd5d4d95', '2018-01-24 12:32:43', 'Email', '', 1, 0, 0, 0, 0, 0, '', 0, 0, 1, 0, 0, 0, 0, 0, 0),
(162, 'Herr', 'Davide', 'Audino', 'Bürenstrasse 15\r\n3007 Bern', '0765748345', '', 'rick.rosendo@gmail.com', 'ja', '', '2018-01-25', '2018-01-26', '2018-01-29', '08:00 - 14:00', '08:00 - 14:00', '08:00 - 14:00', 'kunde wünscht bodenschutz', 0, 'ja', '2 Zimmer-Wohnung', 'Bürenstrasse 15\r\n3007 Bern', '1', 'Nein', 'Weingartenstrassse 26\r\n3014 Bern', '2', 'Nein', '2 MA mit 1 LW für CHF 200.-/h', '2018-04-03', '4.0 h', '5.0 h', '08:00 Uhr', 'keine', '-', '', '', '–', '–', '', 'CHF 640.-', '800.-', 'CHF 920.-', '', '', '', '20%', 'Umzugszentrale', '', '', '', '', '', 'ja', '', '', '', '455fa2dbe4d7a4e', '2018-01-24 15:28:02', 'Email', '', 1, 0, 0, 0, 0, 1, 'Umzug <strong>CHF 640.-  bis  800.-</strong>, Umzugsreinigung <strong>CHF 690.-</strong>', 0, 0, 1, 0, 0, 0, 1, 0, 0),
(163, 'Frau', 'Babrak', 'Rahimi', 'Lerzenstrasse 24\r\n8953 Dietikon', '0848 000 048', 'Schrank, Bett, viel Velos.', 'info@umzugszentrale.ch', 'ja', '', '0000-00-00', '0000-00-00', '0000-00-00', '', '', '', 'Wichtig: Vitrine', 0, 'ja', '2 Büroräume', 'Lerzenstrasse 24 8953 Dietikon', '1', 'Ja', 'Bahnhofstrase 10 8953 Dietikon', 'EG', 'Ja', '2 MA mit 1 LW für CHF 200.-/h', '2018-06-29', '4.0 h', '5.0 h', '08:00 Uhr', 'keine', '-', '', '', '–', '–', '', 'CHF 800.-', '1000.-', 'CHF 1150.-', '', '', '', '-', 'Umzugszentrale', '', '', '', '', '', 'ja', '', '', '', 'b4b838f6fd77346', '2018-01-25 10:36:45', 'Wohnung', '', 1, 1, 95, 0, 0, 1, 'Umzug <strong>CHF 800.-  bis  1000.-</strong>, Umzugsreinigung <strong>CHF 790.-</strong>', 5, 1, 1, 1, 1, 1, 1, 1, 1),
(164, 'Herr', 'Samuele', 'Calabro', 'Grabenstrasse\r\n8952 Schlieren', '0767468495', '', 'calabro.samuele@gmail.com', 'ja', '', '2018-01-26', '2018-01-29', '2018-01-30', '13:00', '12:00 - 18:00', '8:00 - 18:00', '', 0, 'ja', '3 1/2 Zimmer-Wohnung', 'Grabenstrasse, 8952 Schlieren', '2', 'Ja', 'Parkweg 6, 8952 Schlieren', '2', 'Ja', '3 MA mit 1 LW für CHF 190.-/ h', '0000-00-00', '5.0 h', '6.0 h', '08:00 Uhr', 'keine', '-', '', '', '–', '–', '', 'CHF 950.-', '1140.-', 'CHF 1311.-', '', '', '', '-', 'Umzugszentrale', '', '', '', '', '', 'ja', '', '', '', 'a69b54a8b1c876c', '2018-01-25 11:51:14', 'Email', '', 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0),
(165, 'Herr', 'Wyn', 'Whomsley', 'Dörflistrasse 1A\r\nCH-8903 Birmensdorf', '+41 76 816 21 23', '', 'wyn.whomsley@icloud.com', 'ja', '', '2018-01-26', '2018-01-29', '2018-01-30', '14.00-16:00', '08:00-14:00', '14:00-18:00', '', 0, 'ja', '3 1/2 Zimmer-Wohnung', 'Dörflistrasse 1A\r\nCH-8903 Birmensdorf', '2', 'Nein', 'Stallikonerstrasse\r\nCH-8903 Birmensdorf', '2', 'Nein', '2 MA mit 1 LW für CHF 160.-/h', '2018-02-23', '4.0 h', '5.0 h', '08:00 Uhr', 'keine', '-', '', '', '–', '–', '', 'CHF 640.-', '800.-', 'CHF 920.-', '', '', '', '-', 'Umzugszentrale', '', '', '', '', '', 'ja', '', '', '', 'd6074feb3b16a1b', '2018-01-25 17:00:24', 'Email', '', 1, 0, 0, 0, 0, 0, '', 0, 0, 1, 0, 0, 0, 0, 0, 0),
(166, 'Frau', 'Milan', 'Siljanov', 'Pflanzschulstrasse 36\r\n8004 Zürich', '00491755106535', '', 'siljanov@bluemail.ch', 'ja', '', '0000-00-00', '0000-00-00', '0000-00-00', '10:00-12.00', '14:00-18:00', '09:00-18:00', '', 0, 'ja', '2 Zimmer-Wohnung', 'Pflanzschulstrasse 36 / \r\n8004 Zürich', '4', 'Nein', 'Rosenbuschstrasse 36 /\r\n80538 München', 'Parterre', 'Ja', '2 MA mit 1 LW für CHF 160.-/h', '2018-02-15', '7.0 h', '8.0 h', '08:00 Uhr', '3.0 h', '-', '', '', '–', '–', '', 'CHF 1600.-', '1760.-', 'CHF 2024.-', '', '', '', '-', 'Umzugszentrale', '', '', '', '', '', 'ja', '', '', '', 'b9d4ccc4df2bc32', '2018-01-29 07:27:18', 'Email', '', 1, 0, 0, 0, 0, 2, 'Umzug <strong>CHF 1600.-  bis  1760.-</strong>', 0, 0, 0, 0, 0, 0, 0, 0, 0),
(167, 'Herr', 'Bleton', 'Salihu', 'Im Cholplatz 38 / \r\n8180 Bülach', '076 340 17 23', '', 'bleton.salihu@hotmail.com', 'ja', '', '0000-00-00', '0000-00-00', '0000-00-00', '', '', '', '', 0, 'ja', '3 1/2 Zimmer-Wohnung', 'Im Cholplatz 38 / 8180 Bülach', '2', 'Ja', 'Lerzenstrasse 24 / 8953 Dietikon', '1', 'Ja', '3 MA mit 1 LW für CHF 250.-/ h', '2018-02-08', '5.0 h', '6.0 h', '08:00 Uhr', 'keine', '-', '', '', '–', '–', '', 'CHF 1250.-', '1500.-', 'CHF 1725.-', '', '', '', '-', 'Umzugszentrale', '', '', '', '', '', 'ja', '', '', '', '67819413d3ae422', '2018-01-29 08:08:34', 'Wohnung', '', 0, 1, 96, 0, 0, 1, 'Umzug <strong>CHF 1250.-  bis  1500.-</strong>, Umzugsreinigung <strong>CHF 690.-</strong>', 0, 0, 0, 0, 0, 0, 0, 0, 0),
(168, 'Herr', 'Ivo', 'Schillig', 'Chrüzweg 9 \r\n5603 Staufen', '076 475 16 60', '', 'i.schillig@gmx.ch', 'ja', '', '2018-01-30', '2018-01-31', '2018-02-01', '10:00 - 12:00', '09:00 - 13:00', '13:00 - 18:00', '', 0, 'ja', '3 1/2 Zimmer-Wohnung', 'Chrüzweg 9 /\r\n5603 Staufen', '2', 'Ja', 'Schweizistrasse /\r\n5102 Rupperswil', 'EG', 'Ja', '3 MA mit 1 LW für CHF 190.-/ h', '2018-04-21', '4.0 h', '6.0 h', '08:00 Uhr', 'keine', '-', '', '', '–', '–', '', 'CHF 760.-', '1140.-', 'CHF 1311.-', '', '', '', '-', 'Umzugszentrale', '', '', '', '', '', 'ja', '', '', '', '5a80c057b429f4a', '2018-01-29 09:33:52', 'Email', '', 1, 0, 0, 0, 0, 0, '', 0, 0, 1, 0, 0, 0, 0, 0, 0),
(169, 'Herr', 'Philippe', 'Zürcher', 'Obere Bönigstrasse 36\r\n3800 Interlaken', '079 915 94 47', '', 'philippe.zuercher1@swisscom.com', 'ja', '', '0000-00-00', '0000-00-00', '0000-00-00', '14:00 - 16:00', '15:00 - 18:00', '', '', 0, 'ja', '3 1/2 Zimmer-Wohnung', 'Obere Bönigstrasse 36 /\r\n3800 Interlaken', '1', 'Nein', 'Nesslerenweg 88 /\r\n3084 Wabern', '1', 'Ja', '3 MA mit 1 LW für CHF 250.-/ h', '2018-03-27', '4.0 h', '6.0 h', '08:00 Uhr', '1.5 h', '-', '', '', '–', '–', '', 'CHF 1100.-', '1500.-', 'CHF 1725.-', '', '', '', '20%', 'Umzugszentrale', '', '', '', '', '', 'ja', '', '', '', '67c36ec338b5aac', '2018-01-29 09:43:55', 'Email', '', 1, 0, 0, 0, 0, 1, 'Umzug <strong>CHF 1100.-  bis  1500.-</strong>, Umzugsreinigung <strong>CHF 890.-</strong>', 9, 0, 0, 0, 0, 0, 0, 0, 0),
(170, 'Frau', 'Laura', 'Bader', 'Waldaustrasse 31\r\n8606 Nänikon', '079 226 56 95', '', 'laura-bader@outlook.com', 'nein', '', '0000-00-00', '0000-00-00', '0000-00-00', '10:00 - 12:00', '', '', 'Grundsätzlich ist keine Besichtigung nötig, ausser sie wünschen eine.', 0, 'ja', '1 Zimmer-Wohnung', 'Waldaustrasse 31 /\r\n8606 Nänikon', '2', 'Ja', 'Rotbuchstrasse 40 / \r\n8600 Dübendorf', '4', 'Ja', '2 MA mit 1 LW für CHF 150.-/h', '2018-02-03', '3.0 h', '', '08:00 Uhr', 'keine', '-', '', '', '–', '–', '', 'CHF 450.-', '', 'CHF 518.-', '', '', '', '-', 'Kunde', '', '', '', '', '', 'ja', '', '', '', '488cb7a1af9c538', '2018-01-29 12:32:16', 'Email', '', 1, 0, 0, 0, 0, 0, '', 7, 0, 0, 0, 0, 0, 0, 0, 0),
(171, 'Frau', 'Kerstin', 'Rey', 'Birchstrasse 111/ \r\n8050 Zürich', '079 328 28 05', 'Bücherregal\r\nSofa\r\nTisch\r\n4Stühle\r\nSideboard\r\nKaste\r\nSchrank\r\n2 Komode\r\nBett\r\nRegal', 'kerstin.rey@sunrise.ch', 'ja', '', '0000-00-00', '0000-00-00', '0000-00-00', '', '', '', '', 0, 'ja', '2 Zimmer-Wohnung', 'Birchstrasse 111 / 8050 Zürich', 'Parterre', 'Ja', 'Oberwiesenstrssse 44 / 8050 Zürich', 'EFH', 'Nein', '2 MA mit 1 LW für CHF 200.-/h', '2018-02-22', '4.0 h', '5.0 h', '08:00 Uhr', 'keine', '-', '', '', '–', '–', '', 'CHF 640.-', '800.-', 'CHF 920.-', '', '', '', '20%', 'Umzugszentrale', '', '', '', '', '', 'ja', '', '', '', '7a4eb9d48f2c88c', '2018-01-30 16:21:29', 'Wohnung', '', 0, 0, 97, 0, 0, 2, 'Umzug <strong>CHF 640.-  bis  800.-</strong>', 8, 0, 0, 0, 0, 0, 0, 0, 0),
(172, 'Herr', 'Beat', 'Berchtold', 'Kosmetik und Fusspflegstudio\r\n8154 Oberglatt', '043 244 73 61', '', 'Beat.Berchtold@suissetec.ch', 'ja', '', '2018-01-30', '0000-00-00', '0000-00-00', '10:00 - 12:00', '', '', 'Bezüglich den Klebern auf den Boden: Dies muss unser Reinigungsexperte vor Ort prüfen, wie wir das am besten wegkriegen.\r\nDaten noch abzuklären.', 0, 'ja', '1 Büroräume', '8154 Oberglatt', '–', 'Ja', '8154 Oberglatt', '–', 'Ja', '2 MA mit 1 LW für CHF 200.-/h', '2018-03-26', '3.0 h', '', '08:00 Uhr', 'keine', '-', '', '', '–', '–', '', 'CHF 480.-', '', 'CHF 552.-', '', '', '', '20%', 'Umzugszentrale', '', '', '', '', '', '', '', '', '', '27245571c39e6d5', '2018-01-29 14:11:58', 'Email', '', 1, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0),
(173, 'Herr', 'Beat', 'Berchtold', 'Kosmetik und Fusspflegstudio\r\n8154 Oberglatt', '043 244 73 61', '', 'Beat.Berchtold@suissetec.ch', 'ja', '', '2018-01-30', '0000-00-00', '0000-00-00', '10:00 - 12:00', '', '', 'Bezüglich den Klebern auf den Boden: Dies muss unser Reinigungsexperte vor Ort prüfen, wie wir das am besten wegkriegen.\r\nDaten noch abzuklären.', 0, 'ja', '1 Büroräume', '8154 Oberglatt', '–', 'Ja', '8154 Oberglatt', '–', 'Ja', '2 MA mit 1 LW für CHF 200.-/h', '2018-03-26', '3.0 h', '', '08:00 Uhr', 'keine', '-', '', '', '–', '–', '', 'CHF 480.-', '', 'CHF 552.-', '', '', '', '20%', 'Umzugszentrale', '', '', '', '', '', '', '', '', '', 'a5f6b832b7d21a1', '2018-01-29 14:12:12', 'Email', '', 1, 0, 0, 0, 0, 0, '', 0, 0, 1, 0, 0, 0, 0, 0, 0),
(174, 'Frau', 'Barbara', 'Kloz', 'Murstrasse 4\r\n8193 Eglisau', '079 108 86 60', '', 'barbara.kloz@swiss.com', 'ja', '', '0000-00-00', '0000-00-00', '0000-00-00', '', '', '', 'Zusätzliche Abholung von einem Tisch und sechs Stühlen an der Quentlistrasse 59, 8193 Eglisau', 0, 'ja', '-', 'Murstrasse 4 /\r\n8193 Eglisau', 'UG', 'Ja', 'Geerenstrasse 14 /\r\n8302 Kloten', '2', 'Ja', '2 MA mit 1 LW für CHF 200.-/h', '2018-02-17', '3.0 h', '4.0 h', '08:00 Uhr', 'keine', '-', '', '', '–', '–', '', 'CHF 480.-', '640.-', 'CHF 736.-', '', '', '', '20%', 'Umzugszentrale', '', '', '', '', '', '', '', '', '', '07cd9f3a9de5730', '2018-01-29 16:45:53', 'Email', '', 1, 0, 0, 0, 0, 1, 'Umzug <strong>CHF 480.-  bis  640.-</strong>', 6, 0, 0, 0, 0, 0, 0, 0, 0),
(175, 'Frau', 'Martina', 'Schwager', 'Sportstrasse 9\r\n5430 Wettingen', '+41 76 317 09 57', '', 'martina.schwager@sunrise.ch', 'ja', '', '2018-02-01', '2018-02-02', '2018-02-05', '10:00 - 12:00', '10:00 - 18:00', '14:00 - 16:00', '', 0, 'ja', '3 1/2 Zimmer-Wohnung', 'Sportstrasse 9 /\r\n5430 Wettingen', '1', 'Nein', 'Kirchgasse / \r\n5200 Brugg', '1', 'Nein', '3 MA mit 1 LW für CHF 190.-/ h', '2018-03-12', '4.0 h', '5.0 h', '08:00 Uhr', 'keine', '-', '', '', '–', '–', '', 'CHF 760.-', '950.-', 'CHF 1093.-', '', '', '', '-', 'Kunde', '', '', '', '', '', 'ja', '', '', '', 'd0225e51b68aa8c', '2018-01-30 12:15:35', 'Email', '', 1, 0, 0, 0, 0, 0, '', 0, 0, 1, 0, 0, 0, 0, 0, 0),
(176, 'Herr', 'Christian', 'Grohotolsky', 'Zürichstrasse 71c\r\n8134 Adliswil', '+41 44 332 06 05', '', 'christian.grohotolsky@credit-suisse.com', 'ja', '', '2018-02-01', '2018-02-02', '2018-02-05', '10:00 - 12:00', '10:00 - 18:00', '12:00 - 18:30', 'Umzugsdatum noch zu vereinbaren', 0, 'ja', '4 1/2 Zimmer-Wohnung', 'Zürichstrasse 71c /\r\n8134 Adliswil', '2', 'Ja', '8904 Aesch', '1', 'Ja', '4 MA mit 2 LW für CHF 350.-/ h', '2018-06-20', '6.0 h', '8.0 h', '08:00 Uhr', 'keine', '-', '', '', '–', '–', '', 'CHF 1680.-', '2240.-', 'CHF 2576.-', '', '', '', '20% Rabatt CS', 'Umzugszentrale', '', '', '', '', '', 'ja', '', '', '', '13f65f4f1c4737a', '2018-01-30 12:59:36', 'Email', '', 1, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0),
(177, 'Frau', 'Silvia', 'Klein', 'Blickensdorferstr. 11\r\n6312 Steinhausen', '076 430 22 83', 'Regal\r\nTvmöbel\r\nEcksofa\r\nPflanze\r\nSalontisch\r\nLounge\r\nTisch\r\n7Stühle\r\nBett\r\nGrill\r\nSchrank\r\nKommode\r\nBabybett\r\nStubewage\r\nWickeltisch\r\nSpigel\r\nBild', 's_klein@hotmail.com', 'ja', '', '0000-00-00', '0000-00-00', '0000-00-00', '', '', '', '', 0, 'ja', '3 1/2 Zimmer-Wohnung', 'Blickensdorferstr. 11 / 6312 Steinhausen', '3', 'Ja', 'Suhrstoffi 5 / 6343 Rotkreuz', 'EG', 'Ja', '3 MA mit 1 LW für CHF 260.-/ h', '2018-03-02', '5.0 h', '6.0 h', '08:00 Uhr', 'keine', '-', '', '', '–', '–', '', 'CHF 1040.-', '1248.-', 'CHF 1435.-', '', '', '', '20% Rabatt Credit Suisse', 'Umzugszentrale', '', '', '', '', '', 'ja', '', '', '', 'c80d35b09f169b0', '2018-02-01 09:32:27', 'Wohnung', '', 1, 0, 98, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0),
(178, 'Frau', 'Ursula', 'Bünter', 'Zelglistrasse 7\r\n5622 Waltenschwil', '056 534 01 68', '', 'ursula.buenter@bluewin.ch', 'ja', '', '2018-02-02', '2018-02-05', '2018-02-06', '10:00 - 12:00', '10:00 - 18:00', '14:00 - 16:00', 'Umzugsdatum noch zu vereinbaren', 0, 'ja', '4 1/2 Zimmer-Wohnung', 'Zelglistrasse 7 /\r\n5622 Waltenschwil', '1', 'Ja', 'Klosterfeldstrasse 22 /\r\n5630 Muri', '2', 'Ja', '4 MA mit 2 LW für CHF 350.-/ h', '2018-03-05', '6.0 h', '8.0 h', '08:00 Uhr', 'keine', '-', '', '', '–', '–', '', 'CHF 1680.-', '2240.-', 'CHF 2576.-', '', '', '', '20%', 'Umzugszentrale', '', '', '', '', '', '', '', '', '', 'cecba08ddb95253', '2018-01-31 14:47:09', 'Email', '', 1, 0, 0, 0, 0, 0, '', 0, 0, 1, 0, 0, 0, 0, 0, 0),
(179, 'Herr', 'Christoph', 'Widmer', 'Hertistrasse 8, Golfpark A\r\n7270 Davos Platz', '079 500 16 34', '', 'chriswidmer@sunrise.ch', 'ja', 'christoph.widmer2@swisscom.com', '0000-00-00', '0000-00-00', '0000-00-00', '', '', '', 'Umzugsdaten noch zu vereinbaren - \r\nVerpackungsmaterial können Sie bequem über unseren Zügelshop bestellen. \r\nDie 20 % Rabatt wurden im Preis berücksichtigt.\r\n---\r\nAm 1. Tag: Einpacken und Laden in Davos + fahrt zu unserem Sitz nach Dietikon \r\nAm 2. T', 0, 'ja', '2 1/2 Zimmer-Wohnung', 'Hertistrasse 8, Golfpark A /\r\n7270 Davos Platz', '2', 'Nein', 'Schlossgasse 24 /\r\n5600 Lenzburg', '4', 'Ja', '2 MA mit 1 LW für CHF 160.-/h', '2018-09-17', '5.0 h', '6.0 h', '08:00 Uhr', '2.0 h', '-', '', '', '–', '–', '', 'CHF 1120.-', '1280.-', 'CHF 1472.-', '', '', '', '-', 'Umzugszentrale', '', '', '', 'ja', '', 'ja', '', '', '', '9587f024ec38265', '2018-01-31 16:17:58', 'Email', '', 1, 0, 0, 0, 0, 0, '', 0, 0, 1, 0, 0, 0, 0, 0, 0),
(180, 'Herr', 'Chloé', 'Damm', 'Kirchenfeldmatt 12\r\n5630 Muri AG', '0799599751', '', 'chloe.damm@swisscom.com', 'ja', '', '2018-02-02', '2018-02-05', '2018-02-06', '10:00 - 12:00', '10:00 - 18:00', '14:00 - 16:00', '', 0, 'ja', '4 1/2 Zimmer-Wohnung', 'Kirchenfeldmatt 12 /\r\n5630 Muri AG', '1', 'Ja', 'Nesslerenweg 88 /\r\n3084 Wabern', '1', 'Ja', '4 MA mit 2 LW für CHF 350.-/ h', '2018-02-28', '6.0 h', '8.0 h', '08:00 Uhr', '1.5 h', '-', '', '', '–', '–', '', 'CHF 2100.-', '2660.-', 'CHF 3059.-', '', '', '', '20% Rabatt Swisscom', 'Umzugszentrale', '', '', '', '', '', 'ja', '', '', '', 'c058c8f340007d2', '2018-01-31 16:25:04', 'Email', '', 1, 0, 0, 0, 0, 0, '', 0, 0, 1, 0, 0, 0, 0, 0, 0),
(181, 'Herr', 'Hüseyin', 'Bektas', 'Bağlar Mah. Türbe Cad. bilrlik evler', '123456789', '', 'bektas_hueseyin@hotmail.com', 'ja', '', '2018-02-01', '2018-02-02', '2018-02-03', '21:00', '20:00', '21:00', '', 0, 'ja', '4 1/2 Zimmer-Wohnung', '', '–', 'Ja', '', '–', 'Ja', '1 Packer für CHF 60.-/h.', '2018-02-10', '3.0 h', '', '08:00 Uhr', 'keine', '-', '', '', '–', '–', '', 'CHF 180.-', '', 'CHF 207.-', '', '', '', '-', 'Umzugszentrale', '', '', '', '', '', '', '', '', '', 'c4c53483349585c', '2018-01-31 18:06:27', 'Wohnung', '', 1, 0, 0, 0, 0, 1, 'Umzug <strong>CHF 180.-</strong>', 0, 0, 0, 1, 1, 0, 0, 0, 0),
(182, 'Frau', 'Christine', 'Lehmann', 'Langäcker 28\r\n5430 Wettingen', '+41 79 381 73 03', '', 'chre@gmx.ch', 'ja', '', '2018-02-05', '2018-02-06', '2018-02-07', '10:00 - 12:00', '10:00 - 18:00', '14:00 - 16:00', '', 0, 'ja', '4 1/2 Zimmer-Wohnung', 'Langäcker 28 /\r\n5430 Wettingen', 'EG', 'Nein', 'Langäcker 18 /\r\n5430 Wettingen', '3', 'Nein', '4 MA mit 2 LW für CHF 260.-/ h', '2018-03-15', '6.0 h', '8.0 h', '08:00 Uhr', 'keine', '-', '', '', '–', '–', '', 'CHF 1560.-', '2080.-', 'CHF 2392.-', '', '', '', '-', 'Umzugszentrale', '', '', '', '', '', 'ja', '', '', '', 'ff6c554c6c4514a', '2018-02-01 15:09:21', 'Email', '', 1, 0, 0, 0, 0, 0, '', 0, 0, 1, 0, 0, 0, 0, 0, 0),
(183, '', 'Johni', 'Bi', 'Lerzenstrasse 24\r\n8953 Dietikon', '0848000048', '', 'info@umzugszentrale.ch', 'ja', '', '0000-00-00', '0000-00-00', '0000-00-00', '', '', '', '', 0, 'ja', '2 Büroräume', 'Lerzenstrasse 24 8953 Dietikon', '1', 'Ja', 'Industriestrasse 44 8304 Wallisellen', '3', 'Ja', '3 MA mit 1 LW für CHF 260.-/ h', '2018-05-26', '6.5 h', '7.0 h', '08:00 Uhr', '4.5 h', '-', '', '', '–', '–', '', 'CHF 2860.-', '2990.-', 'CHF 3438.-', '', '', '', '-', 'Umzugszentrale', '', '', '', '', '', 'ja', '', '', '', 'aa2e22c1984ac86', '2018-02-01 16:12:14', 'Wohnung', '', 1, 0, 99, 0, 0, 0, '', 0, 1, 1, 0, 0, 0, 0, 0, 0),
(184, 'Herr', 'Milan', 'Siljanov', 'Pflanzschulstrasse 36\r\n8004 Zürich', '00491755106535', '', 'siljanov@bluemail.ch', 'ja', '', '0000-00-00', '0000-00-00', '0000-00-00', '', '', '', '', 0, 'ja', '2 Zimmer-Wohnung', 'Pflanzschulstrasse 36 /\r\n8004 Zürich', '4', 'Nein', 'Rosenbuschstrasse 36 /\r\n80538 München', 'Parterre', 'Ja', '2 MA mit 1 LW für CHF 160.-/h', '2018-02-15', '3.0 h', '4.0 h', '08:00 Uhr', '8.0 h', '-', '', '', '–', '–', '', 'CHF 1760.-', '1920.-', 'CHF 2208.-', '', '', '', '-', 'Umzugszentrale', '', '', '', '', '', '', '', '', '', '10aa3df73d8ae00', '2018-02-02 09:13:02', 'Wohnung', '', 1, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0),
(185, 'Herr', 'Hüseyin', 'Bektas', 'Bağlar Mah. Türbe Cad. bilrlik evler', 'dsadsadsadsa', '', 'bektas_hueseyin@hotmail.com', 'ja', '', '0000-00-00', '0000-00-00', '0000-00-00', '', '', '', '', 0, 'ja', '2 Zimmer-Wohnung', '', '–', 'Ja', '', '–', 'Ja', '1 Packer für CHF 60.-/h.', '2018-02-15', '3.0 h', '', '08:00 Uhr', 'keine', '-', '', '', '–', '–', '', 'CHF 180.-', '', 'CHF 207.-', '', '', '', '-', 'Umzugszentrale', '', '', '', '', '', '', '', '', '', 'd5894b776e10207', '2018-02-02 12:18:15', 'Wohnung2', '', 1, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0),
(186, 'Herr', 'Hüseyin', 'Bektas', 'Bağlar Mah. Türbe Cad. bilrlik evler', '0900666666', '', 'bektas_hueseyin@hotmail.com', 'ja', '', '0000-00-00', '0000-00-00', '0000-00-00', '', '', '', '', 0, 'ja', '-', '', '–', 'Ja', '', '–', 'Ja', '1 Packer für CHF 60.-/h.', '2018-02-14', '3.0 h', '', '08:00 Uhr', 'keine', '-', '', '', '–', '–', '', 'CHF 180.-', '', 'CHF 207.-', '', '', '', '-', 'Umzugszentrale', '', '', '', '', '', '', '', '', '', '48821a9b67bfa1d', '2018-02-02 12:26:09', 'Wohnung2', '', 1, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0),
(187, 'Herr', 'David', 'Anderson', 'Rütistrasse 49\r\n8645 Jona', '+41 76 720 13 36', '', 'thwain@me.com', 'ja', '', '0000-00-00', '0000-00-00', '0000-00-00', '', '', '', '', 0, '', '4 1/2 Zimmer-Wohnung', 'Rütistrasse 49 / 8645 Jona', '–', 'Ja', 'Meierhofstrasse / Rapperswil-Jona - noch zu bestätigen/to be confirmed', '–', 'Ja', '', '2018-04-03', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'cd3524c4a655c6b', '2018-02-02 16:42:17', '', '', 2, 0, 100, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0);

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `citytransport_auspackservice`
--

CREATE TABLE `citytransport_auspackservice` (
  `ID` int(11) NOT NULL,
  `OAs_Objekt` varchar(255) NOT NULL,
  `OAs_Auspacktarif` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `OAs_Auspackdauer` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `OAs_Packdatum` date NOT NULL,
  `OAs_Arbeitsbeginn` varchar(255) NOT NULL,
  `OAs_Anfahrt` varchar(255) NOT NULL,
  `OAs_AnfahrtDistanz` varchar(255) NOT NULL,
  `OAs_Rueckfahrt` varchar(255) NOT NULL,
  `OAs_RueckfahrtDistanz` varchar(255) NOT NULL,
  `OAs_Kostendach` varchar(2) NOT NULL,
  `OAs_Pauschal` varchar(2) NOT NULL,
  `OAs_maxKosten` varchar(255) NOT NULL,
  `OAs_Total` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Daten für Tabelle `citytransport_auspackservice`
--

INSERT INTO `citytransport_auspackservice` (`ID`, `OAs_Objekt`, `OAs_Auspacktarif`, `OAs_Auspackdauer`, `OAs_Packdatum`, `OAs_Arbeitsbeginn`, `OAs_Anfahrt`, `OAs_AnfahrtDistanz`, `OAs_Rueckfahrt`, `OAs_RueckfahrtDistanz`, `OAs_Kostendach`, `OAs_Pauschal`, `OAs_maxKosten`, `OAs_Total`) VALUES
(143, '', '', '', '0000-00-00', '', '', '', '', '', '', '', '', ''),
(144, '', '', '', '0000-00-00', '', '', '', '', '', '', '', '', ''),
(145, '', '', '', '0000-00-00', '', '', '', '', '', '', '', '', ''),
(146, '', '', '', '0000-00-00', '', '', '', '', '', '', '', '', ''),
(147, '', '', '', '0000-00-00', '', '', '', '', '', '', '', '', ''),
(148, '', '', '', '0000-00-00', '', '', '', '', '', '', '', '', ''),
(149, '', '', '', '0000-00-00', '', '', '', '', '', '', '', '', ''),
(155, '', '', '', '0000-00-00', '', '', '', '', '', '', '', '', ''),
(157, '', '', '', '0000-00-00', '', '', '', '', '', '', '', '', ''),
(158, '', '', '', '0000-00-00', '', '', '', '', '', '', '', '', ''),
(159, '', '', '', '0000-00-00', '', '', '', '', '', '', '', '', ''),
(160, '', '', '', '0000-00-00', '', '', '', '', '', '', '', '', ''),
(161, '', '', '', '0000-00-00', '', '', '', '', '', '', '', '', ''),
(162, '', '', '', '0000-00-00', '', '', '', '', '', '', '', '', ''),
(163, '', '', '', '0000-00-00', '', '', '', '', '', '', '', '', ''),
(164, '', '', '', '0000-00-00', '', '', '', '', '', '', '', '', ''),
(165, '', '', '', '0000-00-00', '', '', '', '', '', '', '', '', ''),
(166, '', '', '', '0000-00-00', '', '', '', '', '', '', '', '', ''),
(167, '', '', '', '0000-00-00', '', '', '', '', '', '', '', '', ''),
(168, '', '', '', '0000-00-00', '', '', '', '', '', '', '', '', ''),
(169, '', '', '', '0000-00-00', '', '', '', '', '', '', '', '', ''),
(170, '', '', '', '0000-00-00', '', '', '', '', '', '', '', '', ''),
(171, '', '', '', '0000-00-00', '', '', '', '', '', '', '', '', ''),
(172, '', '', '', '0000-00-00', '', '', '', '', '', '', '', '', ''),
(173, '', '', '', '0000-00-00', '', '', '', '', '', '', '', '', ''),
(174, '', '', '', '0000-00-00', '', '', '', '', '', '', '', '', ''),
(175, '', '', '', '0000-00-00', '', '', '', '', '', '', '', '', ''),
(176, '', '', '', '0000-00-00', '', '', '', '', '', '', '', '', ''),
(177, '', '', '', '0000-00-00', '', '', '', '', '', '', '', '', ''),
(178, '', '', '', '0000-00-00', '', '', '', '', '', '', '', '', ''),
(179, '', '', '', '0000-00-00', '', '', '', '', '', '', '', '', ''),
(180, '', '', '', '0000-00-00', '', '', '', '', '', '', '', '', ''),
(181, '', '', '', '0000-00-00', '', '', '', '', '', '', '', '', ''),
(182, '', '', '', '0000-00-00', '', '', '', '', '', '', '', '', ''),
(183, '', '', '', '0000-00-00', '', '', '', '', '', '', '', '', ''),
(184, '', '', '', '0000-00-00', '', '', '', '', '', '', '', '', ''),
(185, '', '', '', '0000-00-00', '', '', '', '', '', '', '', '', ''),
(186, '', '', '', '0000-00-00', '', '', '', '', '', '', '', '', '');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `citytransport_besichtigung`
--

CREATE TABLE `citytransport_besichtigung` (
  `ID` int(11) NOT NULL,
  `Anrede` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Vorname` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Nachname` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Adresse` text CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Telefon` varchar(255) NOT NULL,
  `Email` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Mailversand` varchar(4) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Besichtigungstermin` date NOT NULL,
  `Zeit` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Aufmerksam` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Daten für Tabelle `citytransport_besichtigung`
--

INSERT INTO `citytransport_besichtigung` (`ID`, `Anrede`, `Vorname`, `Nachname`, `Adresse`, `Telefon`, `Email`, `Mailversand`, `Besichtigungstermin`, `Zeit`, `Aufmerksam`) VALUES
(100, 'Herr', 'David', 'Anderson', 'Rütistrasse 49\r\n8645 Jona', '+41 76 720 13 36', 'thwain@me.com', 'ja', '2018-02-05', '09:00', ''),
(99, '', 'Johni', 'Bi', 'Lerzenstrasse 24\r\n8953 Dietikon', '0848000048', 'info@umzugszentrale.ch', 'ja', '2018-02-02', '08:30', ''),
(98, 'Frau', 'Silvia', 'Klein', 'Blickensdorferstr. 11\r\n6312 Steinhausen', '076 430 22 83', 's_klein@hotmail.com', 'ja', '2018-02-01', '10:00', ''),
(97, 'Frau', 'Kerstin', 'Rey', 'Birchstrasse / \r\n8050 Zürich', '079 328 28 05', 'kerstin.rey@sunrise.ch', 'ja', '2018-01-30', '17:00', ''),
(96, 'Herr', 'Bleton', 'Salihu', 'Im Cholplatz 38 / \r\n8180 Bülach', '076 340 17 23', 'bleton.salihu@hotmail.com', 'ja', '2018-01-31', '08:00', ''),
(95, 'Frau', 'Babrak', 'Rahimi', 'Lerzenstrasse 24\r\n8953 Dietikon', '0848 000 048', 'info@umzugszentrale.ch', 'ja', '2018-01-26', '08:30', ''),
(94, 'Herr', 'Babrak', 'Rahimi', 'Usterstrasse 18\r\n8620 Wallisellen', '0763284989', 'babrak@gmx.ch', 'ja', '2018-01-25', '08:30', ''),
(93, 'Frau', 'Hüseyin', 'Bektas', 'Bağlar Mah. Türbe Cad. bilrlik evler', '05366658122', 'bektas_hueseyin@hotmail.com', 'ja', '2018-01-31', '21:00', ''),
(92, 'Herr', 'Hüseyin', 'Bektas', 'Bağlar Mah. Türbe Cad. bilrlik evler', '05366658122', 'bektas_hueseyin@hotmail.com', 'ja', '2018-01-31', '12:30', ''),
(91, 'Herr', 'Hüseyin', 'Bektas', 'Bağlar Mah. Türbe Cad. bilrlik evler', '05366658122', 'bektas_hueseyin@hotmail.com', 'ja', '2018-01-31', '11:11', ''),
(90, 'Herr', 'Max', 'Muster', 'Musterstraße', '12345678', 'tb@vbnl.net', 'ja', '2018-01-31', '12:12', ''),
(89, 'Herr', 'Max', 'Muster', 'Musterstraße', '12345678', 'tb@vbnl.net', 'ja', '2018-01-31', '12:12', ''),
(88, 'Herr', 'Max', 'Muster', 'Musterstraße', '12345678', 'tb@vbnl.net', 'ja', '2018-01-31', '12:12', ''),
(87, 'Herr', 'Max', 'Muster', 'Musterstraße', '12345678', 'tb@vbnl.net', 'ja', '2018-01-31', '12:12', ''),
(86, 'Herr', 'Max', 'Muster', 'Musterstraße', '12345678', 'tb@vbnl.net', 'ja', '2018-01-31', '12:12', ''),
(85, 'Herr', 'Max', 'Muster', 'Musterstraße', '12345678', 'tb@vbnl.net', 'ja', '2018-01-31', '12:12', ''),
(84, 'Herr', 'Max', 'Muster', 'Musterstraße', '12345678', 'tb@vbnl.net', 'ja', '2018-01-31', '12:12', ''),
(83, 'Herr', 'Max', 'Muster', 'Musterstraße', '12345678', 'tb@vbnl.net', 'ja', '2018-01-31', '12:12', ''),
(81, 'Herr', 'Max', 'Muster', 'Musterstraße', '12345678', 'tb@vbnl.net', 'ja', '2018-01-31', '12:12', ''),
(82, 'Herr', 'Max', 'Muster', 'Musterstraße', '12345678', 'tb@vbnl.net', 'ja', '2018-01-31', '12:12', ''),
(80, 'Herr', 'Max', 'Muster', 'Musterstraße', '12345678', 'tb@vbnl.net', 'ja', '2018-01-31', '12:12', ''),
(79, 'Herr', 'Max', 'Muster', 'Musterstraße', '12345678', 'tb@vbnl.net', 'ja', '2018-01-31', '12:12', ''),
(78, 'Herr', 'Max', 'Muster', 'Musterstraße', '12345678', 'tb@vbnl.net', 'ja', '2018-01-31', '12:12', ''),
(77, 'Herr', 'Max', 'Muster', 'Musterstraße', '12345678', 'tb@vbnl.net', 'ja', '2018-01-31', '12:12', ''),
(76, 'Herr', 'Max', 'Muster', 'Musterstraße', '12345678', 'tb@vbnl.net', 'ja', '2018-01-31', '12:12', ''),
(75, 'Herr', 'Max', 'Muster', 'Musterstraße', '12345678', 'tb@vbnl.net', 'ja', '2018-01-31', '12:12', ''),
(74, 'Herr', 'Max', 'Muster', 'Musterstraße', '12345678', 'tb@vbnl.net', 'ja', '2018-01-31', '12:12', ''),
(73, 'Herr', 'Max', 'Muster', 'Musterstraße', '12345678', 'tb@vbnl.net', 'ja', '2018-01-31', '12:12', ''),
(71, 'Herr', 'Max', 'Muster', 'Musterstraße', '12345678', 'tb@vbnl.net', 'ja', '2018-01-31', '12:12', ''),
(72, 'Herr', 'Max', 'Muster', 'Musterstraße', '12345678', 'tb@vbnl.net', 'ja', '2018-01-31', '12:12', ''),
(70, 'Herr', 'Max', 'Muster', 'Musterstraße', '12345678', 'tb@vbnl.net', 'ja', '2018-01-31', '12:12', ''),
(69, 'Herr', 'Max', 'Muster', 'Musterstraße', '12345678', 'tb@vbnl.net', 'ja', '2018-01-31', '12:12', ''),
(68, 'Herr', 'Hüseyin', 'Bektas', 'Bağlar Mah. Türbe Cad. bilrlik evler', '05366658122', 'bektas_hueseyin@hotmail.com', 'ja', '2018-01-30', '21:00', ''),
(67, 'Herr', 'Babrak', 'Rahimi', 'Usterstrasse 18\r\n8620 Wetzikon', '0763284989', 'info@umzugszentrale.ch', 'ja', '2018-01-24', '10:00', ''),
(66, 'Herr', 'Babrak', 'Rahimi', 'Usterstrasse 18\r\n8620 Wetzikon', '076328498', 'babrak@gmx.ch', 'ja', '2018-01-24', '10:00', '');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `citytransport_bestaetigung`
--

CREATE TABLE `citytransport_bestaetigung` (
  `ID` int(11) NOT NULL,
  `Anrede` varchar(255) NOT NULL,
  `Vorname` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Nachname` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Adresse` text NOT NULL,
  `Telefon` varchar(255) NOT NULL,
  `Email` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Mailversand` varchar(4) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Umzugstermin` date NOT NULL,
  `ZeitU` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `DauerU` varchar(255) NOT NULL,
  `UmsatzU` varchar(255) NOT NULL,
  `MitarbeiterU` varchar(255) NOT NULL,
  `MAKostenU` varchar(255) NOT NULL,
  `DieselU` varchar(255) NOT NULL,
  `Packentermin` date NOT NULL,
  `ZeitP` varchar(255) NOT NULL,
  `DauerP` varchar(255) NOT NULL,
  `UmsatzP` varchar(255) NOT NULL,
  `MitarbeiterP` varchar(255) NOT NULL,
  `MAKostenP` varchar(255) NOT NULL,
  `DieselP` varchar(255) NOT NULL,
  `Auspacktermin` date NOT NULL,
  `ZeitA` varchar(255) NOT NULL,
  `DauerA` varchar(255) NOT NULL,
  `UmsatzA` varchar(255) NOT NULL,
  `MitarbeiterA` varchar(255) NOT NULL,
  `MAKostenA` varchar(255) NOT NULL,
  `DieselA` varchar(255) NOT NULL,
  `Reinigungtermin` date NOT NULL,
  `ZeitR` varchar(255) NOT NULL,
  `DauerR` varchar(255) NOT NULL,
  `UmsatzR` varchar(255) NOT NULL,
  `MitarbeiterR` varchar(255) NOT NULL,
  `MAKostenR` varchar(255) NOT NULL,
  `DieselR` varchar(255) NOT NULL,
  `Lagerungtermin` date NOT NULL,
  `ZeitL` varchar(255) NOT NULL,
  `DauerL` varchar(255) NOT NULL,
  `UmsatzL` varchar(255) NOT NULL,
  `MitarbeiterL` varchar(255) NOT NULL,
  `MAKostenL` varchar(255) NOT NULL,
  `DieselL` varchar(255) NOT NULL,
  `Entsorgungtermin` date NOT NULL,
  `ZeitE` varchar(255) NOT NULL,
  `DauerE` varchar(255) NOT NULL,
  `UmsatzE` varchar(255) NOT NULL,
  `MitarbeiterE` varchar(255) NOT NULL,
  `MAKostenE` varchar(255) NOT NULL,
  `DieselE` varchar(255) NOT NULL,
  `Sonstiges` text NOT NULL,
  `Datum` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Daten für Tabelle `citytransport_bestaetigung`
--

INSERT INTO `citytransport_bestaetigung` (`ID`, `Anrede`, `Vorname`, `Nachname`, `Adresse`, `Telefon`, `Email`, `Mailversand`, `Umzugstermin`, `ZeitU`, `DauerU`, `UmsatzU`, `MitarbeiterU`, `MAKostenU`, `DieselU`, `Packentermin`, `ZeitP`, `DauerP`, `UmsatzP`, `MitarbeiterP`, `MAKostenP`, `DieselP`, `Auspacktermin`, `ZeitA`, `DauerA`, `UmsatzA`, `MitarbeiterA`, `MAKostenA`, `DieselA`, `Reinigungtermin`, `ZeitR`, `DauerR`, `UmsatzR`, `MitarbeiterR`, `MAKostenR`, `DieselR`, `Lagerungtermin`, `ZeitL`, `DauerL`, `UmsatzL`, `MitarbeiterL`, `MAKostenL`, `DieselL`, `Entsorgungtermin`, `ZeitE`, `DauerE`, `UmsatzE`, `MitarbeiterE`, `MAKostenE`, `DieselE`, `Sonstiges`, `Datum`) VALUES
(7, 'Frau', 'Laura', 'Bader', 'Waldaustrasse 31\r\n8606 Nänikon', '079 226 56 95', 'laura-bader@outlook.com', 'ja', '2018-02-03', '08:00', '', '', '', '', '', '0000-00-00', '', '', '', '', '', '', '0000-00-00', '', '', '', '', '', '', '0000-00-00', '', '', '', '', '', '', '0000-00-00', '', '', '', '', '', '', '0000-00-00', '', '', '', '', '', '', '', '2018-01-30 12:37:08'),
(8, 'Frau', 'Kerstin', 'Rey', 'Birchstrasse 111/ \r\n8050 Zürich', '079 328 28 05', 'kerstin.rey@sunrise.ch', 'ja', '2018-02-22', '08:00', '', '', '', '', '', '0000-00-00', '', '', '', '', '', '', '0000-00-00', '', '', '', '', '', '', '0000-00-00', '', '', '', '', '', '', '0000-00-00', '', '', '', '', '', '', '0000-00-00', '', '', '', '', '', '', '', '2018-01-31 07:26:02'),
(9, 'Herr', 'Philippe', 'Zürcher', 'Obere Bönigstrasse 36\r\n3800 Interlaken', '079 915 94 47', 'philippe.zuercher1@swisscom.com', 'ja', '2018-03-27', '08:00', '', '', '', '', '', '0000-00-00', '', '', '', '', '', '', '0000-00-00', '', '', '', '', '', '', '2018-03-29', '16:30', '', '', '', '', '', '0000-00-00', '', '', '', '', '', '', '0000-00-00', '', '', '', '', '', '', '', '2018-02-02 07:56:24'),
(6, 'Frau', 'Barbara', 'Kloz', 'Murstrasse 4\r\n8193 Eglisau', '079 108 86 60', 'barbara.kloz@swiss.com', 'ja', '2018-02-17', '08:00', '', '', '', '', '', '0000-00-00', '', '', '', '', '', '', '0000-00-00', '', '', '', '', '', '', '0000-00-00', '', '', '', '', '', '', '0000-00-00', '', '', '', '', '', '', '0000-00-00', '', '', '', '', '', '', '', '2018-01-30 08:52:39'),
(10, 'Herr', 'Philippe', 'Zürcher', 'Obere Bönigstrasse 36 / 3800 Interlaken', '079 915 94 47', 'philippe.zuercher1@swisscom.com', 'ja', '2018-03-27', '08:00', '', '', '', '', '', '0000-00-00', '', '', '', '', '', '', '0000-00-00', '', '', '', '', '', '', '2018-03-29', '08:00', '', '', '', '', '', '0000-00-00', '', '', '', '', '', '', '0000-00-00', '', '', '', '', '', '', '', '2018-02-02 12:06:20');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `citytransport_bestaetigung_160830`
--

CREATE TABLE `citytransport_bestaetigung_160830` (
  `ID` int(11) NOT NULL,
  `Vorname` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Nachname` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Email` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Mailversand` varchar(4) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Umzugstermin` date NOT NULL,
  `ZeitU` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Packentermin` date NOT NULL,
  `ZeitP` varchar(255) NOT NULL,
  `Auspacktermin` date NOT NULL,
  `ZeitA` varchar(255) NOT NULL,
  `Reinigungtermin` date NOT NULL,
  `ZeitR` varchar(255) NOT NULL,
  `Lagerungtermin` date NOT NULL,
  `ZeitL` varchar(255) NOT NULL,
  `Entsorgungtermin` date NOT NULL,
  `ZeitE` varchar(255) NOT NULL,
  `Sonstiges` text NOT NULL,
  `Datum` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `citytransport_brocki`
--

CREATE TABLE `citytransport_brocki` (
  `ID` int(11) NOT NULL,
  `Vorname` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Name` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Adresse` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Tel` varchar(11) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Email` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Betreff` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Beschrieb` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Preis` varchar(30) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Bildlink` text CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `citytransport_entsorgung`
--

CREATE TABLE `citytransport_entsorgung` (
  `ID` int(11) NOT NULL,
  `OEn_Termin` date NOT NULL,
  `OEn_Arbeitsbeging` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OEn_Adresse` text COLLATE latin1_general_ci NOT NULL,
  `OEn_Etage` varchar(20) COLLATE latin1_general_ci NOT NULL,
  `OEn_Lift` varchar(20) COLLATE latin1_general_ci NOT NULL,
  `OEn_Angebot` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OEn_Anfahrt` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OEn_Rueckfahrt` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OEn_Aufwand` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OEn_Aufwand2` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OEn_Volumen` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OEn_Volumen2` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OEn_Zusatzkosten` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OEn_Zusatzkosten2` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OEn_Spesen` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OEn_Bemerkungen` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OEn_BemerkungOption` tinyint(1) NOT NULL,
  `OEn_Pauschalpreis` tinyint(1) NOT NULL,
  `OEn_Total` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OEn_Promotionen` varchar(255) COLLATE latin1_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Daten für Tabelle `citytransport_entsorgung`
--

INSERT INTO `citytransport_entsorgung` (`ID`, `OEn_Termin`, `OEn_Arbeitsbeging`, `OEn_Adresse`, `OEn_Etage`, `OEn_Lift`, `OEn_Angebot`, `OEn_Anfahrt`, `OEn_Rueckfahrt`, `OEn_Aufwand`, `OEn_Aufwand2`, `OEn_Volumen`, `OEn_Volumen2`, `OEn_Zusatzkosten`, `OEn_Zusatzkosten2`, `OEn_Spesen`, `OEn_Bemerkungen`, `OEn_BemerkungOption`, `OEn_Pauschalpreis`, `OEn_Total`, `OEn_Promotionen`) VALUES
(143, '0000-00-00', '08:00 Uhr', '', '', '', '', '', '', '', '', '-', '-', '–', '–', '', '', 0, 0, '', '-'),
(144, '0000-00-00', '08:00 Uhr', '', '', '', '', '', '', '', '', '-', '-', '–', '–', '', '', 0, 0, '', '-'),
(145, '0000-00-00', '08:00 Uhr', '', '', '', '', '', '', '', '', '-', '-', '–', '–', '', '', 0, 0, '', '-'),
(146, '0000-00-00', '08:00 Uhr', '', '', '', '', '', '', '', '', '-', '-', '–', '–', '', '', 0, 0, '', '-'),
(147, '0000-00-00', '08:00 Uhr', '', '', '', '', '', '', '', '', '-', '-', '–', '–', '', '', 0, 0, '', '-'),
(148, '0000-00-00', '08:00 Uhr', '', '', '', '', '', '', '', '', '-', '-', '–', '–', '', '', 0, 0, '', '-'),
(149, '0000-00-00', '08:00 Uhr', '', '', '', '', '', '', '', '', '-', '-', '–', '–', '', '', 0, 0, '', '-'),
(150, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', ''),
(151, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', ''),
(152, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', ''),
(153, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', ''),
(154, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', ''),
(155, '2018-01-27', '08:00 Uhr', '', '', '', '', '', '', '', '', 'bis 4 m3 CHF 200.–', 'bis 10 m3 CHF 600.–', 'Spesen CHF 140.–', 'Spesen CHF 100.–', '', 'bemerkung entsorgung', 1, 0, '', '20% Rabatt AXA'),
(156, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', ''),
(157, '0000-00-00', '08:00 Uhr', '', '', '', '', '', '', '', '', '-', '-', '–', '–', '', '', 0, 0, '', '-'),
(158, '0000-00-00', '08:00 Uhr', '', '', '', '', '', '', '', '', '-', '-', '–', '–', '', '', 0, 0, '', '-'),
(159, '0000-00-00', '08:00 Uhr', '', '', '', '', '', '', '', '', '-', '-', '–', '–', '', '', 0, 0, '', '-'),
(160, '0000-00-00', '08:00 Uhr', '', '', '', '', '', '', '', '', '-', '-', '–', '–', '', '', 0, 0, '', '-'),
(161, '0000-00-00', '08:00 Uhr', '', '', '', '', '', '', '', '', '-', '-', '–', '–', '', '', 0, 0, '', '-'),
(162, '0000-00-00', '08:00 Uhr', '', '', '', '', '', '', '', '', '-', '-', '–', '–', '', '', 0, 0, '', '-'),
(163, '0000-00-00', '08:00 Uhr', '', '', '', '', '', '', '', '', '-', '-', '–', '–', '', '', 0, 0, '', '-'),
(164, '0000-00-00', '08:00 Uhr', '', '', '', '', '', '', '', '', '-', '-', '–', '–', '', '', 0, 0, '', '-'),
(165, '0000-00-00', '08:00 Uhr', '', '', '', '', '', '', '', '', '-', '-', '–', '–', '', '', 0, 0, '', '-'),
(166, '0000-00-00', '08:00 Uhr', '', '', '', '', '', '', '', '', '-', '-', '–', '–', '', '', 0, 0, '', '-'),
(167, '0000-00-00', '08:00 Uhr', '', '', '', '', '', '', '', '', '-', '-', '–', '–', '', '', 0, 0, '', '-'),
(168, '0000-00-00', '08:00 Uhr', '', '', '', '', '', '', '', '', '-', '-', '–', '–', '', '', 0, 0, '', '-'),
(169, '0000-00-00', '08:00 Uhr', '', '', '', '', '', '', '', '', '-', '-', '–', '–', '', '', 0, 0, '', '-'),
(170, '0000-00-00', '08:00 Uhr', '', '', '', '', '', '', '', '', '-', '-', '–', '–', '', '', 0, 0, '', '-'),
(171, '0000-00-00', '08:00 Uhr', '', '', '', '', '', '', '', '', '-', '-', '–', '–', '', '', 0, 0, '', '-'),
(172, '0000-00-00', '08:00 Uhr', '', '', '', '', '', '', '', '', '-', '-', '–', '–', '', '', 0, 0, '', '-'),
(173, '0000-00-00', '08:00 Uhr', '', '', '', '', '', '', '', '', '-', '-', '–', '–', '', '', 0, 0, '', '-'),
(174, '0000-00-00', '08:00 Uhr', '', '', '', '', '', '', '', '', '-', '-', '–', '–', '', '', 0, 0, '', '-'),
(175, '0000-00-00', '08:00 Uhr', '', '', '', '', '', '', '', '', '-', '-', '–', '–', '', '', 0, 0, '', '-'),
(176, '0000-00-00', '08:00 Uhr', '', '', '', '', '', '', '', '', '-', '-', '–', '–', '', '', 0, 0, '', '-'),
(177, '0000-00-00', '08:00 Uhr', '', '', '', '', '', '', '', '', '-', '-', '–', '–', '', '', 0, 0, '', '-'),
(178, '0000-00-00', '08:00 Uhr', '', '', '', '', '', '', '', '', '-', '-', '–', '–', '', '', 0, 0, '', '-'),
(179, '0000-00-00', '08:00 Uhr', '', '', '', '', '', '', '', '', '-', '-', '–', '–', '', '', 0, 0, '', '-'),
(180, '0000-00-00', '08:00 Uhr', '', '', '', '', '', '', '', '', '-', '-', '–', '–', '', '', 0, 0, '', '-'),
(181, '0000-00-00', '08:00 Uhr', '', '', '', '', '', '', '', '', '-', '-', '–', '–', '', '', 0, 0, '', '-'),
(182, '0000-00-00', '08:00 Uhr', '', '', '', '', '', '', '', '', '-', '-', '–', '–', '', '', 0, 0, '', '-'),
(183, '0000-00-00', '08:00 Uhr', '', '', '', '', '', '', '', '', '-', '-', '–', '–', '', '', 0, 0, '', '-'),
(184, '0000-00-00', '08:00 Uhr', '', '', '', '', '', '', '', '', '-', '-', '–', '–', '', '', 0, 0, '', '-'),
(185, '0000-00-00', '08:00 Uhr', '', '', '', '', '', '', '', '', '-', '-', '–', '–', '', '', 0, 0, '', '-'),
(186, '0000-00-00', '08:00 Uhr', '', '', '', '', '', '', '', '', '-', '-', '–', '–', '', '', 0, 0, '', '-'),
(187, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', '');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `citytransport_lagerung`
--

CREATE TABLE `citytransport_lagerung` (
  `ID` int(11) NOT NULL,
  `OLa_Termin` date NOT NULL,
  `OLa_Arbeitsbeging` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OLa_Adresse` text COLLATE latin1_general_ci NOT NULL,
  `OLa_Etage` varchar(20) COLLATE latin1_general_ci NOT NULL,
  `OLa_Lift` varchar(20) COLLATE latin1_general_ci NOT NULL,
  `OLa_Angebot` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OLa_Anfahrt` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OLa_Rueckfahrt` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OLa_Aufwand` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OLa_Aufwand2` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OLa_Volumen` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OLa_Volumen2` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OLa_Zusatzkosten` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OLa_Zusatzkosten2` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OLa_Spesen` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OLa_Bemerkungen` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OLa_BemerkungOption` tinyint(1) NOT NULL,
  `OLa_Pauschalpreis` tinyint(1) NOT NULL,
  `OLa_Total` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OLa_Promotionen` varchar(255) COLLATE latin1_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Daten für Tabelle `citytransport_lagerung`
--

INSERT INTO `citytransport_lagerung` (`ID`, `OLa_Termin`, `OLa_Arbeitsbeging`, `OLa_Adresse`, `OLa_Etage`, `OLa_Lift`, `OLa_Angebot`, `OLa_Anfahrt`, `OLa_Rueckfahrt`, `OLa_Aufwand`, `OLa_Aufwand2`, `OLa_Volumen`, `OLa_Volumen2`, `OLa_Zusatzkosten`, `OLa_Zusatzkosten2`, `OLa_Spesen`, `OLa_Bemerkungen`, `OLa_BemerkungOption`, `OLa_Pauschalpreis`, `OLa_Total`, `OLa_Promotionen`) VALUES
(143, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', ''),
(144, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', ''),
(145, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', ''),
(146, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', ''),
(147, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', ''),
(148, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', ''),
(149, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', ''),
(150, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', ''),
(151, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', ''),
(152, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', ''),
(153, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', ''),
(154, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', ''),
(155, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', ''),
(156, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', ''),
(157, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', ''),
(158, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', ''),
(159, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', ''),
(160, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', ''),
(161, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', ''),
(162, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', ''),
(163, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', ''),
(164, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', ''),
(165, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', ''),
(166, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', ''),
(167, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', ''),
(168, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', ''),
(169, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', ''),
(170, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', ''),
(171, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', ''),
(172, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', ''),
(173, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', ''),
(174, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', ''),
(175, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', ''),
(176, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', ''),
(177, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', ''),
(178, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', ''),
(179, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', ''),
(180, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', ''),
(181, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', ''),
(182, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', ''),
(183, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', ''),
(184, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', ''),
(185, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', ''),
(186, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', ''),
(187, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', '');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `citytransport_lohnabrechnung`
--

CREATE TABLE `citytransport_lohnabrechnung` (
  `id` int(11) NOT NULL,
  `Name` varchar(255) NOT NULL,
  `Vorname` varchar(255) NOT NULL,
  `Versicherung_Nr` varchar(255) NOT NULL,
  `Auszahlungsdatum` varchar(255) NOT NULL,
  `Monat` varchar(100) NOT NULL,
  `Einsatz` double NOT NULL,
  `Betrag` varchar(255) NOT NULL,
  `AHV_Abzug` varchar(255) NOT NULL,
  `ALV_Abzug` varchar(255) NOT NULL,
  `UVG_Abzug` varchar(255) NOT NULL,
  `personal_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `citytransport_mitarbeiter`
--

CREATE TABLE `citytransport_mitarbeiter` (
  `ID` int(11) NOT NULL,
  `Anrede` varchar(255) NOT NULL,
  `Vorname` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Nachname` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Adresse` text NOT NULL,
  `Telefon` varchar(255) NOT NULL,
  `Email` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Mailversand` varchar(4) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Lohnart` varchar(255) NOT NULL,
  `AHVNummer` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `citytransport_monatlohn`
--

CREATE TABLE `citytransport_monatlohn` (
  `ID` int(20) NOT NULL,
  `Mitarbeiter_ID` int(11) NOT NULL,
  `Arbeitgeber` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Arbeitnehmer` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Eingetragen` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Ort` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Lohnabrechnung` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `AHVNummer` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Grundlohn` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Familienzulagen` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Ahv_iv_eo` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `ahv_prozent_von` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `ahv_prozent_ergebniss` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `alv_prozent_von` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `alv_prozent_ergebniss` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `NBU` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `nbu_prozent_von` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `nbu_prozent_ergebniss` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Steuerabzug` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Steuerabzug_prozent_von` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Steuerabzug_prozent_ergebniss` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Weitere` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Weiterekosten` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Weitere2` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Weitere2kosten` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `totalabzuge` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Nettolohn` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Spesen` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Spesenkosten` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `totalauszahlung` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Uberweisung` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Konto` varchar(255) COLLATE latin1_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `citytransport_packservice`
--

CREATE TABLE `citytransport_packservice` (
  `ID` int(11) NOT NULL,
  `OPs_Objekt` varchar(255) NOT NULL,
  `OPs_Einpacktarif` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `OPs_Einpackdauer` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `OPs_Packdatum` date NOT NULL,
  `OPs_Arbeitsbeginn` varchar(255) NOT NULL,
  `OPs_Anfahrt` varchar(255) NOT NULL,
  `OPs_AnfahrtDistanz` varchar(255) NOT NULL,
  `OPs_AnAbfahrtDistanz` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `OPs_Rueckfahrt` varchar(255) NOT NULL,
  `OPs_RueckfahrtDistanz` varchar(255) NOT NULL,
  `OPs_Kostendach` varchar(2) NOT NULL,
  `OPs_Pauschal` varchar(2) NOT NULL,
  `OPs_maxKosten` varchar(255) NOT NULL,
  `OPs_Total` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Daten für Tabelle `citytransport_packservice`
--

INSERT INTO `citytransport_packservice` (`ID`, `OPs_Objekt`, `OPs_Einpacktarif`, `OPs_Einpackdauer`, `OPs_Packdatum`, `OPs_Arbeitsbeginn`, `OPs_Anfahrt`, `OPs_AnfahrtDistanz`, `OPs_AnAbfahrtDistanz`, `OPs_Rueckfahrt`, `OPs_RueckfahrtDistanz`, `OPs_Kostendach`, `OPs_Pauschal`, `OPs_maxKosten`, `OPs_Total`) VALUES
(143, '5 1/2 Zimmer-Wohnung', '2 MA für CHF 160.–/ h', '0.5 h', '0000-00-00', '08:00 Uhr', '', '-', 'keine', '', '', '', '', 'CHF 92.-', 'CHF 80.-'),
(144, '5 1/2 Zimmer Einfamilienhaus', '2 MA für CHF 150.–/ h', '0.5 h', '0000-00-00', '08:00 Uhr', '', '-', 'keine', '', '', '', '', 'CHF 86.-', 'CHF 75.-'),
(145, '-', '2 MA für CHF 150.–/ h', '0.5 h', '0000-00-00', '08:00 Uhr', '', '-', 'keine', '', '', '', '', 'CHF 86.-', 'CHF 75.-'),
(146, '-', '2 MA für CHF 150.–/ h', '0.5 h', '0000-00-00', '08:00 Uhr', '', '-', 'keine', '', '', '', '', 'CHF 86.-', 'CHF 75.-'),
(147, '-', '2 MA für CHF 150.–/ h', '0.5 h', '0000-00-00', '08:00 Uhr', '', '-', 'keine', '', '', '', '', 'CHF 86.-', 'CHF 75.-'),
(148, '-', '2 MA für CHF 150.–/ h', '0.5 h', '0000-00-00', '08:00 Uhr', '', '-', 'keine', '', '', '', '', 'CHF 86.-', 'CHF 75.-'),
(149, '-', '2 MA für CHF 150.–/ h', '0.5 h', '0000-00-00', '08:00 Uhr', '', '-', 'keine', '', '', '', '', 'CHF 86.-', 'CHF 75.-'),
(155, '2 1/2 Zimmer-Wohnung', '2 MA für CHF 150.–/ h', '4.5 h', '2018-01-25', '16:00 Uhr', '', 'ca. 30m', 'Ein-Auspackservice', '', '', 'Ja', '', 'CHF 776.-', 'CHF 675.-'),
(157, '7 Zimmer-Wohnung', '2 MA für CHF 150.–/ h', '0.5 h', '0000-00-00', '08:00 Uhr', '', '-', 'keine', '', '', '', '', 'CHF 86.-', 'CHF 75.-'),
(158, '-', '2 MA für CHF 150.–/ h', '0.5 h', '0000-00-00', '08:00 Uhr', '', '-', 'keine', '', '', '', '', 'CHF 86.-', 'CHF 75.-'),
(159, '-', '2 MA für CHF 150.–/ h', '0.5 h', '0000-00-00', '08:00 Uhr', '', '-', 'keine', '', '', '', '', 'CHF 86.-', 'CHF 75.-'),
(160, '-', '2 MA für CHF 150.–/ h', '0.5 h', '0000-00-00', '08:00 Uhr', '', '-', 'keine', '', '', '', '', 'CHF 86.-', 'CHF 75.-'),
(161, '-', '2 MA für CHF 150.–/ h', '0.5 h', '0000-00-00', '08:00 Uhr', '', '-', 'keine', '', '', '', '', 'CHF 86.-', 'CHF 75.-'),
(162, '-', '2 MA für CHF 150.–/ h', '0.5 h', '0000-00-00', '08:00 Uhr', '', '-', 'keine', '', '', '', '', 'CHF 86.-', 'CHF 75.-'),
(163, '2 Büroräume', '2 MA für CHF 150.–/ h', '0.5 h', '0000-00-00', '08:00 Uhr', '', '-', 'keine', '', '', '', '', 'CHF 86.-', 'CHF 75.-'),
(164, '-', '2 MA für CHF 150.–/ h', '0.5 h', '0000-00-00', '08:00 Uhr', '', '-', 'keine', '', '', '', '', 'CHF 86.-', 'CHF 75.-'),
(165, '-', '2 MA für CHF 150.–/ h', '0.5 h', '0000-00-00', '08:00 Uhr', '', '-', 'keine', '', '', '', '', 'CHF 86.-', 'CHF 75.-'),
(166, '2 Zimmer-Wohnung', '2 MA für CHF 150.–/ h', '0.5 h', '0000-00-00', '08:00 Uhr', '', '-', 'keine', '', '', '', '', 'CHF 86.-', 'CHF 75.-'),
(167, '3 1/2 Zimmer-Wohnung', '2 MA für CHF 150.–/ h', '0.5 h', '0000-00-00', '08:00 Uhr', '', '-', 'keine', '', '', '', '', 'CHF 86.-', 'CHF 75.-'),
(168, '-', '2 MA für CHF 150.–/ h', '0.5 h', '0000-00-00', '08:00 Uhr', '', '-', 'keine', '', '', '', '', 'CHF 86.-', 'CHF 75.-'),
(169, '3 1/2 Zimmer-Wohnung', '2 MA für CHF 150.–/ h', '0.5 h', '0000-00-00', '08:00 Uhr', '', '-', 'keine', '', '', '', '', 'CHF 86.-', 'CHF 75.-'),
(170, '1 Zimmer-Wohnung', '2 MA für CHF 150.–/ h', '0.5 h', '0000-00-00', '08:00 Uhr', '', '-', 'keine', '', '', '', '', 'CHF 86.-', 'CHF 75.-'),
(171, '2 Zimmer-Wohnung', '2 MA für CHF 150.–/ h', '0.5 h', '0000-00-00', '08:00 Uhr', '', '-', 'keine', '', '', '', '', 'CHF 86.-', 'CHF 75.-'),
(172, '-', '2 MA für CHF 150.–/ h', '0.5 h', '0000-00-00', '08:00 Uhr', '', '-', 'keine', '', '', '', '', 'CHF 86.-', 'CHF 75.-'),
(173, '-', '2 MA für CHF 150.–/ h', '0.5 h', '0000-00-00', '08:00 Uhr', '', '-', 'keine', '', '', '', '', 'CHF 86.-', 'CHF 75.-'),
(174, '-', '2 MA für CHF 150.–/ h', '0.5 h', '0000-00-00', '08:00 Uhr', '', '-', 'keine', '', '', '', '', 'CHF 86.-', 'CHF 75.-'),
(175, '-', '2 MA für CHF 150.–/ h', '0.5 h', '0000-00-00', '08:00 Uhr', '', '-', 'keine', '', '', '', '', 'CHF 86.-', 'CHF 75.-'),
(176, '-', '2 MA für CHF 150.–/ h', '0.5 h', '0000-00-00', '08:00 Uhr', '', '-', 'keine', '', '', '', '', 'CHF 86.-', 'CHF 75.-'),
(177, '3 1/2 Zimmer-Wohnung', '2 MA für CHF 160.–/ h', '0.5 h', '0000-00-00', '08:00 Uhr', '', '-', 'keine', '', '', '', '', 'CHF 92.-', 'CHF 80.-'),
(178, '-', '2 MA für CHF 150.–/ h', '0.5 h', '0000-00-00', '08:00 Uhr', '', '-', 'keine', '', '', '', '', 'CHF 86.-', 'CHF 75.-'),
(179, '2 1/2 Zimmer-Wohnung', '2 MA für CHF 160.–/ h', '3.0 h', '0000-00-00', '08:00 Uhr', '', '-', 'Ein-Auspackservice', '', '', '', '', 'CHF 552.-', 'CHF 480.-'),
(180, '-', '2 MA für CHF 160.–/ h', '0.5 h', '0000-00-00', '08:00 Uhr', '', '-', 'keine', '', '', '', '', 'CHF 92.-', 'CHF 80.-'),
(181, '-', '2 MA für CHF 150.–/ h', '0.5 h', '0000-00-00', '08:00 Uhr', '', '-', 'keine', '', '', '', '', 'CHF 86.-', 'CHF 75.-'),
(182, '-', '2 MA für CHF 160.–/ h', '0.5 h', '0000-00-00', '08:00 Uhr', '', '-', 'keine', '', '', '', '', 'CHF 92.-', 'CHF 80.-'),
(183, '2 Büroräume', '2 MA für CHF 160.–/ h', '0.5 h', '0000-00-00', '08:00 Uhr', '', '-', 'keine', '', '', '', '', 'CHF 92.-', 'CHF 80.-'),
(184, '-', '2 MA für CHF 160.–/ h', '0.5 h', '0000-00-00', '08:00 Uhr', '', '-', 'keine', '', '', '', '', 'CHF 92.-', 'CHF 80.-'),
(185, '-', '2 MA für CHF 160.–/ h', '0.5 h', '0000-00-00', '08:00 Uhr', '', '-', 'keine', '', '', '', '', 'CHF 92.-', 'CHF 80.-'),
(186, '-', '2 MA für CHF 160.–/ h', '0.5 h', '0000-00-00', '08:00 Uhr', '', '-', 'keine', '', '', '', '', 'CHF 92.-', 'CHF 80.-');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `citytransport_personal`
--

CREATE TABLE `citytransport_personal` (
  `id` int(11) NOT NULL,
  `Vorname` varchar(255) NOT NULL,
  `Nachname` varchar(255) NOT NULL,
  `Versicherung_Nr` varchar(255) NOT NULL,
  `Vertrag` mediumblob,
  `Vertrag_Dateiname` varchar(50) NOT NULL,
  `Vertrag2` mediumblob,
  `Vertrag2_Dateiname` varchar(255) NOT NULL,
  `ID_Upload` mediumblob,
  `ID_Upload_Dateiname` varchar(50) NOT NULL,
  `ID_Upload2` mediumblob,
  `ID_Upload2_Dateiname` varchar(255) NOT NULL,
  `Fahrzeugausweis` mediumblob,
  `Fahrzeugausweis_Dateiname` varchar(50) NOT NULL,
  `Fahrzeugausweis2` mediumblob,
  `Fahrzeugausweis2_Dateiname` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `citytransport_quittung`
--

CREATE TABLE `citytransport_quittung` (
  `ID` int(11) NOT NULL,
  `Anrede` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Vorname` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Nachname` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Adresse` text CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Sonstiges` text CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Email` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `UmzugBox` tinyint(1) NOT NULL,
  `EinAuspackBox` tinyint(1) NOT NULL,
  `ReinigungBox` tinyint(1) NOT NULL,
  `EntsorgungBox` tinyint(1) NOT NULL,
  `LagerungBox` tinyint(1) NOT NULL,
  `UmzugAufwand` varchar(255) NOT NULL,
  `UmzugKosten` varchar(255) NOT NULL,
  `EinAuspackAufwand` varchar(255) NOT NULL,
  `EntsorgungAufwand` varchar(255) NOT NULL,
  `LagerungAufwand` varchar(255) NOT NULL,
  `AdresseAuszug` varchar(255) NOT NULL,
  `AdresseEinzug` varchar(255) NOT NULL,
  `Tarif` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Packen` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Montage` varchar(255) NOT NULL,
  `Reinigung` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Lagerung` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Entsorgung` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Verpackung` varchar(255) NOT NULL,
  `Aufwand` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Anfahrt` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Zusatzkosten` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Zusatzkosten2` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Kosten` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Code` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `OffertenID` int(11) NOT NULL,
  `Datum` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Status` tinyint(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `citytransport_rechnung`
--

CREATE TABLE `citytransport_rechnung` (
  `ID` int(11) NOT NULL,
  `Anrede` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Vorname` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Nachname` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Adresse` text CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Sonstiges` text CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Email` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Mailversand` varchar(4) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Tarif` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Packen` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Montage` varchar(255) NOT NULL,
  `Reinigung` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Lagerung` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `HinweisLagerung` varchar(255) NOT NULL,
  `Entsorgung` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Verpackung` varchar(255) NOT NULL,
  `Aufwand` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Anfahrt` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Zusatzkosten` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Zusatzkosten2` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `AnzahlungBar` varchar(255) NOT NULL,
  `Rabatt` varchar(255) NOT NULL,
  `Kosten` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `Code` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `OffertenID` int(11) NOT NULL,
  `Datum` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Status` tinyint(1) NOT NULL,
  `Bezahlt` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Daten für Tabelle `citytransport_rechnung`
--

INSERT INTO `citytransport_rechnung` (`ID`, `Anrede`, `Vorname`, `Nachname`, `Adresse`, `Sonstiges`, `Email`, `Mailversand`, `Tarif`, `Packen`, `Montage`, `Reinigung`, `Lagerung`, `HinweisLagerung`, `Entsorgung`, `Verpackung`, `Aufwand`, `Anfahrt`, `Zusatzkosten`, `Zusatzkosten2`, `AnzahlungBar`, `Rabatt`, `Kosten`, `Code`, `OffertenID`, `Datum`, `Status`, `Bezahlt`) VALUES
(15, 'Herr', 'Bleton', 'Salihu', 'Im Cholplatz 38 / \r\n8180 Bülach', '', 'bleton.salihu@hotmail.com', 'ja', '3 MA mit 1 LW für CHF 250.-/ h', '', '1500.00', '690.00', '', '', '', '', '', 'keine', '–', '–', '', '', 'CHF 2190.00.-', '67819413d3ae422', 167, '2018-01-29 08:20:07', 0, 0),
(14, 'Frau', 'Babrak', 'Rahimi', 'Lerzenstrasse 24\r\n8953 Dietikon', 'Schrank, Bett, viel Velos.', 'info@umzugszentrale.ch', 'ja', '2 MA mit 1 LW für CHF 200.-/h', '', '1290.00', '890.00', '', '', '', '', '', 'keine', '–', '–', '', '', 'CHF 2180.00.-', 'b4b838f6fd77346', 163, '2018-01-25 10:45:52', 0, 0),
(13, 'Frau', 'Hüseyin', 'Bektas', 'Bağlar Mah. Türbe Cad. bilrlik evler', 'Bağlar Mah. Türbe Cad. bilrlik evler', 'bektas_hueseyin@hotmail.com', 'ja', '1 Packer für CHF 60.-/h.', '22.00', '22.00', '22.00', '22.00', '', '22.00', '22.00', '', 'keine', 'Klavier CHF 550.–', 'Spesen CHF 140.–', '', '22.00', 'CHF 800.00.-', 'XReX92784642156caf9', 0, '2018-01-23 20:06:30', 0, 0);

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `citytransport_reinigung`
--

CREATE TABLE `citytransport_reinigung` (
  `ID` int(11) NOT NULL,
  `ORe_Objekt` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `ORe_Reinigungstermin` date NOT NULL,
  `ORe_Abgabetermin` date NOT NULL,
  `ORe_Kueche` tinyint(1) NOT NULL,
  `ORe_Bad` tinyint(1) NOT NULL,
  `ORe_Storen` tinyint(1) NOT NULL,
  `ORe_Fenster` tinyint(1) NOT NULL,
  `ORe_Tueren` tinyint(1) NOT NULL,
  `ORe_Heizung` tinyint(1) NOT NULL,
  `ORe_Boden` tinyint(1) NOT NULL,
  `ORe_Schrank` tinyint(1) NOT NULL,
  `ORe_Wand` tinyint(1) NOT NULL,
  `ORe_Terasse` tinyint(1) NOT NULL,
  `ORe_Keller` tinyint(1) NOT NULL,
  `ORe_Bemerkungen` text COLLATE latin1_general_ci NOT NULL,
  `ORe_BemerkungOption` tinyint(1) NOT NULL,
  `ORe_Zusatzleistungen` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `ORe_Zusatzleistungen2` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `ORe_Pauschalpreis` tinyint(1) NOT NULL,
  `ORe_Total` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `ORe_Promotionen` varchar(255) COLLATE latin1_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Daten für Tabelle `citytransport_reinigung`
--

INSERT INTO `citytransport_reinigung` (`ID`, `ORe_Objekt`, `ORe_Reinigungstermin`, `ORe_Abgabetermin`, `ORe_Kueche`, `ORe_Bad`, `ORe_Storen`, `ORe_Fenster`, `ORe_Tueren`, `ORe_Heizung`, `ORe_Boden`, `ORe_Schrank`, `ORe_Wand`, `ORe_Terasse`, `ORe_Keller`, `ORe_Bemerkungen`, `ORe_BemerkungOption`, `ORe_Zusatzleistungen`, `ORe_Zusatzleistungen2`, `ORe_Pauschalpreis`, `ORe_Total`, `ORe_Promotionen`) VALUES
(143, '5 1/2 Zimmer-Wohnung', '0000-00-00', '0000-00-00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 1, '890', '-'),
(144, '5 1/2 Zimmer Einfamilienhaus', '0000-00-00', '0000-00-00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 1, '1290', '-'),
(145, '1 1/2 Zimmer-Wohnung', '0000-00-00', '0000-00-00', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 1, '690', '-'),
(146, '2 1/2 Zimmer-Wohnung', '2018-04-09', '2018-04-09', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, '-Wintergarten mit diversen Fenster nur Innenreinigung\r\n-Vorgarten mit diversen Fenster nur Innenreinigung\r\n-Terrasse', 1, '', '', 1, '890', '20%'),
(147, '-', '0000-00-00', '0000-00-00', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 1, '', '-'),
(148, '-', '0000-00-00', '0000-00-00', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 1, '', '-'),
(149, '1 Zimmer-Wohnung', '2018-03-27', '2018-03-28', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 1, '690', '-'),
(150, '', '0000-00-00', '0000-00-00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 0, '', ''),
(151, '', '0000-00-00', '0000-00-00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 0, '', ''),
(152, '', '0000-00-00', '0000-00-00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 0, '', ''),
(153, '', '0000-00-00', '0000-00-00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 0, '', ''),
(154, '', '0000-00-00', '0000-00-00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 0, '', ''),
(155, '2 Zimmer-Wohnung', '2018-01-29', '2018-01-25', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'bemerkung reinigung', 1, 'Shampoonieren', 'Hochdruckreinigung', 1, '250', '20% Rabatt CS'),
(156, '', '0000-00-00', '0000-00-00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 0, '', ''),
(157, '7 Zimmer-Wohnung', '0000-00-00', '0000-00-00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 1, '', '-'),
(158, '3 1/2 Zimmer-Wohnung', '0000-00-00', '0000-00-00', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 1, '990', '20%'),
(159, '2 Zimmer-Wohnung', '0000-00-00', '0000-00-00', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 1, '690', '-'),
(160, '3 1/2 Zimmer-Wohnung', '0000-00-00', '0000-00-00', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 1, '1090', '-'),
(161, '2 Zimmer-Wohnung', '0000-00-00', '0000-00-00', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 1, '990', '20%'),
(162, '2 Zimmer-Wohnung', '2018-04-04', '2018-04-04', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 1, '690', '20%'),
(163, '2 Büroräume', '0000-00-00', '0000-00-00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 1, '790', '-'),
(164, '3 1/2 Zimmer-Wohnung', '0000-00-00', '0000-00-00', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 1, '990', '-'),
(165, '3 1/2 Zimmer-Wohnung', '0000-00-00', '0000-00-00', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 1, '790', '-'),
(166, '2 1/2 Zimmer-Wohnung', '0000-00-00', '0000-00-00', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 1, '690', '-'),
(167, '3 1/2 Zimmer-Wohnung', '0000-00-00', '0000-00-00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 1, '690', '-'),
(168, '-', '0000-00-00', '0000-00-00', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 1, '890', '-'),
(169, '3 1/2 Zimmer-Wohnung', '2018-04-02', '2018-04-03', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 1, '890', '20%'),
(170, '1 Zimmer-Wohnung', '0000-00-00', '0000-00-00', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 1, '590', '-'),
(171, '2 Zimmer-Wohnung', '2018-02-28', '2018-02-28', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 1, '690', '20%'),
(172, '-', '0000-00-00', '0000-00-00', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 1, '', '-'),
(173, '-', '0000-00-00', '0000-00-00', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 1, '', '-'),
(174, '-', '0000-00-00', '0000-00-00', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 1, '', '-'),
(175, '3 1/2 Zimmer-Wohnung', '0000-00-00', '0000-00-00', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 1, '890', '-'),
(176, '4 1/2 Zimmer-Wohnung', '0000-00-00', '0000-00-00', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 1, '1090', '20% Rabatt CS'),
(177, '4 1/2 Zimmer-Wohnung', '2018-03-28', '2018-03-30', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 1, '1090', '20% Rabatt CS'),
(178, '4 1/2 Zimmer-Wohnung', '0000-00-00', '0000-00-00', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 1, '1090', '20%'),
(179, '2 1/2 Zimmer-Wohnung', '2018-09-17', '0000-00-00', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Reinigungsdatum noch zu vereinbaren \r\n Aufwand für die Reinigung wäre wie für eine 3 Zi.-Wohnung, da grosse Garage ebenfalls gereinigt werden muss.', 0, '', '', 1, '990', '20%'),
(180, '4 1/2 Zimmer-Wohnung', '0000-00-00', '0000-00-00', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 1, '1090', '20%'),
(181, '-', '0000-00-00', '0000-00-00', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 1, '', '-'),
(182, '4 1/2 Zimmer-Wohnung', '0000-00-00', '0000-00-00', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 1, '1090', '-'),
(183, '2 Büroräume', '0000-00-00', '0000-00-00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 1, '890', '-'),
(184, '-', '0000-00-00', '0000-00-00', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 1, '', '-'),
(185, '-', '0000-00-00', '0000-00-00', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 1, '', '-'),
(186, '-', '0000-00-00', '0000-00-00', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 1, '', '-'),
(187, '', '0000-00-00', '0000-00-00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 0, '', '');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `citytransport_sicher_160223`
--

CREATE TABLE `citytransport_sicher_160223` (
  `ID` int(11) NOT NULL,
  `Anrede` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Vorname` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Nachname` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Adresse` text COLLATE latin1_general_ci NOT NULL,
  `Telefon` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Sonstiges` text COLLATE latin1_general_ci NOT NULL,
  `Email` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Mailversand` varchar(4) COLLATE latin1_general_ci NOT NULL,
  `WeitereEmpfaenger` text COLLATE latin1_general_ci NOT NULL,
  `Besichtigungstermin` date NOT NULL,
  `Besichtigungstermin2` date NOT NULL,
  `Besichtigungstermin3` date NOT NULL,
  `Zeit` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Zeit2` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Zeit3` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Bemerkung` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `BemerkungOption` tinyint(1) NOT NULL,
  `Umzug` varchar(2) COLLATE latin1_general_ci NOT NULL,
  `Objekt` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `AdresseAuszug` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `EtageAuszug` varchar(20) COLLATE latin1_general_ci NOT NULL,
  `LiftAuszug` varchar(20) COLLATE latin1_general_ci NOT NULL,
  `AdresseEinzug` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `EtageEinzug` varchar(20) COLLATE latin1_general_ci NOT NULL,
  `LiftEinzug` varchar(20) COLLATE latin1_general_ci NOT NULL,
  `Tarif` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Umzugstermin` date NOT NULL,
  `Aufwand` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Aufwand2` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Arbeitsbeginn` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Anfahrt` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `AnfahrtDistanz` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Rueckfahrt` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `RueckfahrtDistanz` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Zusatzkosten` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Zusatzkosten2` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Zahlungsbedingung` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Kosten` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Kosten2` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `maxKosten` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Kostendach` varchar(2) COLLATE latin1_general_ci NOT NULL,
  `Pauschal` varchar(2) COLLATE latin1_general_ci NOT NULL,
  `Spesen` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Promotionen` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Abbau` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Aufbau` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Einpacken` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Auspacken` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Einpackservice` varchar(2) COLLATE latin1_general_ci NOT NULL,
  `Auspackservice` varchar(2) COLLATE latin1_general_ci NOT NULL,
  `Reinigung` varchar(2) COLLATE latin1_general_ci NOT NULL,
  `Verpackungsmaterial` varchar(2) COLLATE latin1_general_ci NOT NULL,
  `Lagerung` varchar(2) COLLATE latin1_general_ci NOT NULL,
  `Entsorgung` varchar(2) COLLATE latin1_general_ci NOT NULL,
  `Code` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `Datum` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Offertentyp` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `Offerte` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `Status` tinyint(1) NOT NULL,
  `Rechnung` tinyint(1) NOT NULL,
  `Besichtigung` int(11) NOT NULL,
  `Quittung` tinyint(1) NOT NULL,
  `Umsatzliste` int(11) NOT NULL,
  `Bestaetigung` tinyint(4) NOT NULL,
  `BestaetigungValues` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `MailNachfrage1` tinyint(2) NOT NULL,
  `MailNachfrage2` tinyint(2) NOT NULL,
  `MailBewertung1` tinyint(2) NOT NULL,
  `MailBewertung2` tinyint(2) NOT NULL,
  `MailVorbereitung1` tinyint(2) NOT NULL,
  `MailVorbereitung2` tinyint(2) NOT NULL,
  `MailVorbereitung3` tinyint(2) NOT NULL,
  `MailVorbereitung4` tinyint(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `citytransport_smsworkers`
--

CREATE TABLE `citytransport_smsworkers` (
  `ID` int(11) NOT NULL,
  `customer` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `comments` text CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `workernumber` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `selectworkers` text CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `SelectedWorkersSMS` text NOT NULL,
  `transportnumber` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `transporter` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `numberRE` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `selectRE` text CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `RecruitedEmployeesSMS` text NOT NULL,
  `datework` date NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `citytransport_stundenlohn`
--

CREATE TABLE `citytransport_stundenlohn` (
  `ID` int(20) NOT NULL,
  `Mitarbeiter_ID` int(11) NOT NULL,
  `Arbeitgeber` text COLLATE latin1_general_ci NOT NULL,
  `Arbeitnehmer` text COLLATE latin1_general_ci NOT NULL,
  `Eingetragen` date NOT NULL,
  `Ort` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Lohnabrechnung` date NOT NULL,
  `AHVNummer` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Grundlohn` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Stunden` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Bruttolohn` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Ferienzuschlag` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Prozent_von` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `ferienzuschlag_ergebniss` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Familienzulagen` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Ahv_iv_eo` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `ahv_prozent_von` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `ahv_prozent_ergebniss` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `alv_prozent_von` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `alv_prozent_ergebniss` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `NBU` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `nbu_prozent_von` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `nbu_prozent_ergebniss` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Steuerabzug` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Steuerabzug_prozent_von` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Steuerabzug_prozent_ergebniss` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Weitere` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Weiterekosten` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Weitere2` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Weitere2kosten` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `totalabzuge` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Nettolohn` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Spesen` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Spesenkosten` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `totalauszahlung` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `Uberweisung` date NOT NULL,
  `Konto` varchar(255) COLLATE latin1_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `citytransport_umsatz`
--

CREATE TABLE `citytransport_umsatz` (
  `id` int(11) NOT NULL,
  `Kunde` varchar(255) NOT NULL,
  `Bezeichnung` varchar(255) NOT NULL,
  `Datum` date NOT NULL,
  `Monat` varchar(100) NOT NULL,
  `Jahr` varchar(100) NOT NULL,
  `Auftrags_Nr` varchar(255) NOT NULL,
  `Stunden` float NOT NULL,
  `Umsatz` varchar(255) NOT NULL,
  `AllgemeineKostenBez` varchar(255) NOT NULL,
  `AllgemeineKostenVal` varchar(255) NOT NULL,
  `Zahlungen` tinyint(1) NOT NULL,
  `Bezahlt` tinyint(1) NOT NULL,
  `Zahlungserinnerung` date NOT NULL,
  `Mahnung1` date NOT NULL,
  `Mahnung2` date NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `citytransport_umsatz_personal`
--

CREATE TABLE `citytransport_umsatz_personal` (
  `id` int(11) NOT NULL,
  `umsatz_id` int(11) NOT NULL,
  `personal_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `citytransport_umzugsgut_items`
--

CREATE TABLE `citytransport_umzugsgut_items` (
  `id` int(11) UNSIGNED NOT NULL,
  `section` char(3) NOT NULL DEFAULT 'wz',
  `text` varchar(255) NOT NULL DEFAULT '',
  `cbm` decimal(5,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Daten für Tabelle `citytransport_umzugsgut_items`
--

INSERT INTO `citytransport_umzugsgut_items` (`id`, `section`, `text`, `cbm`) VALUES
(1, 'wz', 'Wohnz.-Schrank, je angef. m', '1.00'),
(2, 'wz', 'Anbauwand je angef. m', '1.00'),
(3, 'wz', 'Vitrine (Glasschrank)', '1.10'),
(4, 'wz', 'Bücherregal, je angef. m', '0.40'),
(5, 'wz', 'Sideboard, groß', '1.20'),
(6, 'wz', 'Sideboard, klein', '0.60'),
(7, 'wz', 'Sofa, Couch, je Sitz', '0.40'),
(8, 'wz', 'Tisch, bis 1,2 m', '0.60'),
(9, 'wz', 'Tisch, über 1,2 m', '0.80'),
(10, 'wz', 'Sessel, mit Armlehnen', '0.80'),
(11, 'wz', 'Sessel, ohne Armlehnen', '0.60'),
(12, 'wz', 'Sekretär', '1.20'),
(13, 'wz', 'Standuhr', '0.40'),
(14, 'wz', 'Stuhl', '0.20'),
(15, 'wz', 'Teewagen', '0.40'),
(16, 'wz', 'Musikschrank', '0.40'),
(17, 'wz', 'Fernseherschrank', '0.50'),
(18, 'wz', 'Fernseher', '0.40'),
(19, 'wz', 'Buffet mit Aufsatz', '1.80'),
(20, 'wz', 'Buffet ohne Aufsatz', '1.50'),
(21, 'wz', 'Teppich', '0.30'),
(22, 'wz', 'Flügel', '2.00'),
(23, 'wz', 'Klavier', '1.50'),
(24, 'wz', 'Stehlampe', '0.20'),
(25, 'wz', 'Bilder bis 0,8 m', '0.10'),
(26, 'wz', 'Bilder über 0,8 m', '0.20'),
(27, 'wz', 'Umzugskarton ca.', '0.10'),
(28, 'ez', 'Buffet mit Aufsatz', '1.80'),
(29, 'ez', 'Buffet ohne Aufsatz', '1.50'),
(30, 'ez', 'Vitrine (Glasschrank)', '1.10'),
(31, 'ez', 'Tisch, bis 1,2 m', '0.60'),
(32, 'ez', 'Tisch, über 1,2 m', '0.80'),
(33, 'ez', 'Stehlampe', '0.20'),
(34, 'ez', 'Bilder bis 0,8 m', '0.10'),
(35, 'ez', 'Bilder über 0,8 m', '0.20'),
(36, 'ez', 'Stuhl', '0.20'),
(37, 'ez', 'Eckbank, je Sitz', '0.20'),
(38, 'ez', 'Teppich', '0.30'),
(39, 'ez', 'Nähmaschine', '0.20'),
(40, 'ez', 'Sideboard', '0.80'),
(41, 'ez', 'Umzugskarton ca.', '0.10'),
(42, 'sz', 'Einzelbett', '1.00'),
(43, 'sz', 'Doppelbett', '2.00'),
(44, 'sz', 'Franz. Bett , komplett', '1.50'),
(45, 'sz', 'Bettumbau', '0.40'),
(46, 'sz', 'Frisierkommode', '0.60'),
(47, 'sz', 'Kommode', '0.70'),
(48, 'sz', 'Bettzeug, je Betteinheit', '0.30'),
(49, 'sz', 'Wäschetruhe', '0.30'),
(50, 'sz', 'Säcke mit...', '0.10'),
(51, 'sz', 'Nachttisch', '0.20'),
(52, 'sz', 'Stuhl, Hocker', '0.20'),
(53, 'sz', 'Spiegel über 0,8 m', '0.20'),
(54, 'sz', 'Schrank nicht zerlegbar, 2 Tür', '1.60'),
(55, 'sz', 'Schrank zerlegbar, je angef. m', '0.80'),
(56, 'sz', 'Bilder bis 0,8 m', '0.10'),
(57, 'sz', 'Bilder über 0,8 m', '0.20'),
(58, 'sz', 'Teppich', '0.30'),
(59, 'sz', 'Umzugskarton ca.', '0.10'),
(60, 'az', 'Schreibtisch bis 1,6 m', '1.20'),
(61, 'az', 'Schreibtisch über 1,6 m', '1.70'),
(62, 'az', 'Schreibtischcontainer', '0.30'),
(63, 'az', 'Schreibtischstuhl', '0.30'),
(64, 'az', 'Aktenschrank je angef. m', '0.80'),
(65, 'az', 'Bücherregal je angef. m', '0.40'),
(66, 'az', 'Sessel mit Armlehnen', '0.80'),
(67, 'az', 'Computer, Anlage komplett', '0.50'),
(68, 'az', 'Schreibmaschine', '0.10'),
(69, 'az', 'Tisch bis 1,0 m', '0.50'),
(70, 'az', 'Tisch über 1,0 m', '0.80'),
(71, 'az', 'Stehlampe', '0.20'),
(72, 'az', 'Winkelkombination', '1.50'),
(73, 'az', 'Tischkopierer', '0.50'),
(74, 'az', 'Teppich', '0.30'),
(75, 'az', 'Bilder bis 0,8 m', '0.10'),
(76, 'az', 'Bilder über 0,8 m', '0.20'),
(77, 'az', 'Umzugskarton ca.', '0.10'),
(78, 'kz', 'Anbauwand je angef. m', '0.80'),
(79, 'kz', 'Schrank nicht zerlegbar, 2 Tür', '1.60'),
(80, 'kz', 'Schrank zerlegbar, je angef. m', '0.80'),
(81, 'kz', 'Schreibtisch', '1.20'),
(82, 'kz', 'Stuhl , Hocker', '0.20'),
(83, 'kz', 'Kommode', '0.70'),
(84, 'kz', 'Tisch bis 1,0 m', '0.50'),
(85, 'kz', 'Tisch über 1,0 m', '0.80'),
(86, 'kz', 'Einzelbett komplett', '1.00'),
(87, 'kz', 'Kinderbett komplett', '0.60'),
(88, 'kz', 'Etagenbett', '1.60'),
(89, 'kz', 'Bettzeug, je Betteinheit', '0.30'),
(90, 'kz', 'Laufgitter', '0.20'),
(91, 'kz', 'Nachttisch', '0.20'),
(92, 'kz', 'Stehlampe', '0.20'),
(93, 'kz', 'Spielzeugkiste', '0.30'),
(94, 'kz', 'Teppich', '0.30'),
(95, 'kz', 'Bilder bis 0,8 m', '0.10'),
(96, 'kz', 'Bilder über 0,8 m', '0.20'),
(97, 'kz', 'Umzugskarton ca.', '0.10'),
(98, 'ku', 'Hängeschrank, je Tür', '0.40'),
(99, 'ku', 'Unterschrank, je Tür', '0.40'),
(100, 'ku', 'Arbeitsplatte, je angef. m', '0.10'),
(101, 'ku', 'Besenschrank', '0.60'),
(102, 'ku', 'Buffet', '1.20'),
(103, 'ku', 'Buffet mit Aufsatz', '1.80'),
(104, 'ku', 'Eckbank, je Sitz', '0.20'),
(105, 'ku', 'Tisch bis 1,0 m', '0.50'),
(106, 'ku', 'Tisch über 1,0 m', '0.80'),
(107, 'ku', 'Stuhl', '0.20'),
(108, 'ku', 'Geschirrspülmaschine', '0.50'),
(109, 'ku', 'Herd', '0.50'),
(110, 'ku', 'Kühlschrank/Truhe bis 120 l', '0.50'),
(111, 'ku', 'Kühlschrank/Truhe über 120 l', '1.50'),
(112, 'ku', 'Waschmaschine', '0.50'),
(113, 'ku', 'Trockner', '0.50'),
(114, 'ku', 'Mikrowelle', '0.10'),
(115, 'ku', 'Bilder bis 0,8 m', '0.10'),
(116, 'ku', 'Bilder über 0,8 m', '0.20'),
(117, 'ku', 'Umzugskarton ca.', '0.10'),
(118, 'fb', 'Garderobe', '0.40'),
(119, 'fb', 'Schuhschrank', '0.40'),
(120, 'fb', 'Spiegel', '0.20'),
(121, 'fb', 'Truhe/Kommode', '0.70'),
(122, 'fb', 'Toilettenschrank', '0.30'),
(123, 'fb', 'Wäschekorb', '0.20'),
(124, 'fb', 'Stuhl/Hocker', '0.20'),
(125, 'fb', 'Teppich', '0.30'),
(126, 'fb', 'Bügelbrett', '0.10'),
(127, 'fb', 'Umzugskarton ca.', '0.10'),
(128, 'kz2', 'Anbauwand je angef. m', '0.80'),
(129, 'kz2', 'Schrank nicht zerlegbar, 2 Tür', '1.60'),
(130, 'kz2', 'Schrank zerlegbar, je angef. m', '0.80'),
(131, 'kz2', 'Schreibtisch', '1.20'),
(132, 'kz2', 'Stuhl , Hocker', '0.20'),
(133, 'kz2', 'Kommode', '0.70'),
(134, 'kz2', 'Tisch bis 1,0 m', '0.50'),
(135, 'kz2', 'Tisch über 1,0 m', '0.80'),
(136, 'kz2', 'Einzelbett komplett', '1.00'),
(137, 'kz2', 'Kinderbett komplett', '0.60'),
(138, 'kz2', 'Etagenbett', '1.60'),
(139, 'kz2', 'Bettzeug, je Betteinheit', '0.30'),
(140, 'kz2', 'Laufgitter', '0.20'),
(141, 'kz2', 'Nachttisch', '0.20'),
(142, 'kz2', 'Stehlampe', '0.20'),
(143, 'kz2', 'Spielzeugkiste', '0.30'),
(144, 'kz2', 'Teppich', '0.30'),
(145, 'kz2', 'Bilder bis 0,8 m', '0.10'),
(146, 'kz2', 'Bilder über 0,8 m', '0.20'),
(147, 'kz2', 'Umzugskarton ca.', '0.10'),
(148, 'kz3', 'Anbauwand je angef. m', '0.80'),
(149, 'kz3', 'Schrank nicht zerlegbar, 2 Tür', '1.60'),
(150, 'kz3', 'Schrank zerlegbar, je angef. m', '0.80'),
(151, 'kz3', 'Schreibtisch', '1.20'),
(152, 'kz3', 'Stuhl , Hocker', '0.20'),
(153, 'kz3', 'Kommode', '0.70'),
(154, 'kz3', 'Tisch bis 1,0 m', '0.50'),
(155, 'kz3', 'Tisch über 1,0 m', '0.80'),
(156, 'kz3', 'Einzelbett komplett', '1.00'),
(157, 'kz3', 'Kinderbett komplett', '0.60'),
(158, 'kz3', 'Etagenbett', '1.60'),
(159, 'kz3', 'Bettzeug, je Betteinheit', '0.30'),
(160, 'kz3', 'Laufgitter', '0.20'),
(161, 'kz3', 'Nachttisch', '0.20'),
(162, 'kz3', 'Stehlampe', '0.20'),
(163, 'kz3', 'Spielzeugkiste', '0.30'),
(164, 'kz3', 'Teppich', '0.30'),
(165, 'kz3', 'Bilder bis 0,8 m', '0.10'),
(166, 'kz3', 'Bilder über 0,8 m', '0.20'),
(167, 'kz3', 'Umzugskarton ca.', '0.10'),
(168, 'kl', 'Fahrrad / Moped', '0.11'),
(169, 'kl', 'Dreirad / Kinderrad', '0.12'),
(170, 'kl', 'Bu?gelbrett', '0.13'),
(171, 'kl', 'Staubsauger', '0.14'),
(172, 'kl', 'Regal, zerlegbar, je angef. M', '0.15'),
(173, 'kl', 'Koffer', '0.16'),
(174, 'kl', 'Klapptisch / Klappstuhl', '0.17'),
(175, 'kl', 'Kinderwagen', '0.18'),
(176, 'kl', 'Leiter, je angef. m', '0.19'),
(177, 'kl', 'Werkbank, zerlegbar', '0.20'),
(178, 'kl', 'Werkzeugschrank', '0.21'),
(179, 'kl', 'Werkzeugkoffer', '0.22'),
(180, 'kl', 'Sonnenschirm', '0.23'),
(181, 'kl', 'Blumenku?bel / Kasten', '0.24'),
(182, 'kl', 'Ski', '0.25'),
(183, 'kl', 'Schlitten', '0.26'),
(184, 'kl', 'Umzugskarton ca.', '0.27');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `citytransport_umzugsgut_list_items`
--

CREATE TABLE `citytransport_umzugsgut_list_items` (
  `offerte_id` int(11) NOT NULL,
  `item_id` int(11) NOT NULL,
  `pieces` int(11) DEFAULT NULL,
  `montage` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Daten für Tabelle `citytransport_umzugsgut_list_items`
--

INSERT INTO `citytransport_umzugsgut_list_items` (`offerte_id`, `item_id`, `pieces`, `montage`) VALUES
(1474, 1, 3, 1),
(1474, 2, 1, 1),
(1547, 1, 1, 1),
(1547, 2, 1, 1),
(1547, 3, 1, 1),
(1547, 4, 1, 1),
(1547, 5, 1, 0),
(1591, 1, 1, 0),
(1591, 2, 1, 1),
(1591, 3, 1, 1),
(1591, 45, 1, 1),
(1591, 46, 1, 1),
(1591, 47, 1, 1),
(1591, 83, 1, 1),
(1591, 84, 1, 0),
(1591, 85, 1, 0);

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `citytransport_umzugskosten`
--

CREATE TABLE `citytransport_umzugskosten` (
  `ID` int(11) NOT NULL,
  `UmzugDatum` varchar(7) NOT NULL,
  `Beschrieb1` varchar(255) NOT NULL,
  `Kosten1` varchar(255) NOT NULL,
  `Beschrieb2` varchar(255) NOT NULL,
  `Kosten3` varchar(255) NOT NULL,
  `Beschrieb4` varchar(255) NOT NULL,
  `Kosten5` varchar(255) NOT NULL,
  `Beschrieb6` varchar(255) NOT NULL,
  `Kosten7` varchar(255) NOT NULL,
  `Beschrieb8` varchar(255) NOT NULL,
  `Kosten9` varchar(255) NOT NULL,
  `Beschrieb10` varchar(255) NOT NULL,
  `Kosten2` varchar(255) NOT NULL,
  `Beschrieb3` varchar(255) NOT NULL,
  `Kosten4` varchar(255) NOT NULL,
  `Beschrieb5` varchar(255) NOT NULL,
  `Kosten6` varchar(255) NOT NULL,
  `Beschrieb7` varchar(255) NOT NULL,
  `Kosten8` varchar(255) NOT NULL,
  `Beschrieb9` varchar(255) NOT NULL,
  `Kosten10` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `citytransport_verpackungsmaterial`
--

CREATE TABLE `citytransport_verpackungsmaterial` (
  `ID` int(11) NOT NULL,
  `OVe_Termin` date NOT NULL,
  `OVe_Bucherkarton` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_Bucherkarton_Menge` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_Ordnerkarton` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_Ordnerkarton_Menge` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_Geschirrkarton` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_Geschirrkarton_Menge` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_GeschirrkartonEinlagen` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_GeschirrkartonEinlagen_Menge` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_Kleiderboxen` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_Kleiderboxen_Menge` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_Luftpolsterfolie` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_Luftpolsterfolie_Menge` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_Seidenpapier` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_Seidenpapier_Menge` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_Etikette` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_Etikette_Menge` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_1ZimmerSet` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_1ZimmerSet_Menge` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_2ZimmerSet` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_2ZimmerSet_Menge` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_3ZimmerSet` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_3ZimmerSet_Menge` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_4ZimmerSet` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_4ZimmerSet_Menge` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_5ZimmerSet` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_5ZimmerSet_Menge` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_6ZimmerSet` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_6ZimmerSet_Menge` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_4HausSet` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_4HausSet_Menge` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_5HausSet` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_5HausSet_Menge` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_6HausSet` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_6HausSet_Menge` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_Luftfolie` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_Luftfolie_Menge` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_Stretchfolie` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_Stretchfolie_Menge` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_Umzugskisten` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_Umzugskisten_Menge` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_Matratzenhulle` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_Matratzenhulle_Menge` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_Weinkarton` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_Weinkarton_Menge` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_Lieferung` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_Rabatt` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_BemerkungOption` tinyint(1) NOT NULL,
  `OVe_Bemerkungen` text COLLATE latin1_general_ci NOT NULL,
  `OVe_Pauschalpreis` tinyint(1) NOT NULL,
  `OVe_Total` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_Promotionen` varchar(255) COLLATE latin1_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Daten für Tabelle `citytransport_verpackungsmaterial`
--

INSERT INTO `citytransport_verpackungsmaterial` (`ID`, `OVe_Termin`, `OVe_Bucherkarton`, `OVe_Bucherkarton_Menge`, `OVe_Ordnerkarton`, `OVe_Ordnerkarton_Menge`, `OVe_Geschirrkarton`, `OVe_Geschirrkarton_Menge`, `OVe_GeschirrkartonEinlagen`, `OVe_GeschirrkartonEinlagen_Menge`, `OVe_Kleiderboxen`, `OVe_Kleiderboxen_Menge`, `OVe_Luftpolsterfolie`, `OVe_Luftpolsterfolie_Menge`, `OVe_Seidenpapier`, `OVe_Seidenpapier_Menge`, `OVe_Etikette`, `OVe_Etikette_Menge`, `OVe_1ZimmerSet`, `OVe_1ZimmerSet_Menge`, `OVe_2ZimmerSet`, `OVe_2ZimmerSet_Menge`, `OVe_3ZimmerSet`, `OVe_3ZimmerSet_Menge`, `OVe_4ZimmerSet`, `OVe_4ZimmerSet_Menge`, `OVe_5ZimmerSet`, `OVe_5ZimmerSet_Menge`, `OVe_6ZimmerSet`, `OVe_6ZimmerSet_Menge`, `OVe_4HausSet`, `OVe_4HausSet_Menge`, `OVe_5HausSet`, `OVe_5HausSet_Menge`, `OVe_6HausSet`, `OVe_6HausSet_Menge`, `OVe_Luftfolie`, `OVe_Luftfolie_Menge`, `OVe_Stretchfolie`, `OVe_Stretchfolie_Menge`, `OVe_Umzugskisten`, `OVe_Umzugskisten_Menge`, `OVe_Matratzenhulle`, `OVe_Matratzenhulle_Menge`, `OVe_Weinkarton`, `OVe_Weinkarton_Menge`, `OVe_Lieferung`, `OVe_Rabatt`, `OVe_BemerkungOption`, `OVe_Bemerkungen`, `OVe_Pauschalpreis`, `OVe_Total`, `OVe_Promotionen`) VALUES
(143, '0000-00-00', '0', '', '', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '', '', 0, '', 1, 'CHF 0.-', '-'),
(144, '0000-00-00', '0', '', '', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '', '', 0, '', 1, 'CHF 0.-', '-'),
(145, '0000-00-00', '0', '', '', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '', '', 0, '', 1, 'CHF 0.-', '-'),
(146, '0000-00-00', '0', '', '', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '', '', 0, '', 1, 'CHF 0.-', '-'),
(147, '0000-00-00', '0', '', '', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '', '', 0, '', 1, 'CHF 0.-', '-'),
(148, '0000-00-00', '0', '', '', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '', '', 0, '', 1, 'CHF 0.-', '-'),
(149, '0000-00-00', '0', '', '', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '', '', 0, '', 1, 'CHF 0.-', '-'),
(150, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, '', 0, '', ''),
(151, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, '', 0, '', ''),
(152, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, '', 0, '', ''),
(153, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, '', 0, '', ''),
(154, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, '', 0, '', ''),
(155, '2018-01-28', '2.90', '2', '', '', '5.90', '2', '6.90', '2', '9.50', '2', '5.50', '2', '4.50', '2', '0.10', '2', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '4.50', '2', '10.50', '2', '0', '', '5.50', '2', '5.50', '2', '22', '222', 1, 'bemerkung verpackung', 1, 'CHF -227.-', 'CHF 150.– Rabatt'),
(156, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, '', 0, '', ''),
(157, '0000-00-00', '0', '', '', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '', '', 0, '', 1, 'CHF 0.-', '-'),
(158, '0000-00-00', '0', '', '', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '', '', 0, '', 1, 'CHF 0.-', '-'),
(159, '0000-00-00', '0', '', '', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '', '', 0, '', 1, 'CHF 0.-', '-'),
(160, '0000-00-00', '0', '', '', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '', '', 0, '', 1, 'CHF 0.-', '-'),
(161, '0000-00-00', '0', '', '', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '', '', 0, '', 1, 'CHF 0.-', '-'),
(162, '0000-00-00', '0', '', '', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '', '', 0, '', 1, 'CHF 0.-', '-'),
(163, '0000-00-00', '0', '', '', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '', '', 0, '', 1, 'CHF 0.-', '-'),
(164, '0000-00-00', '0', '', '', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '', '', 0, '', 1, 'CHF 0.-', '-'),
(165, '0000-00-00', '0', '', '', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '', '', 0, '', 1, 'CHF 0.-', '-'),
(166, '0000-00-00', '0', '', '', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '', '', 0, '', 1, 'CHF 0.-', '-'),
(167, '0000-00-00', '0', '', '', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '', '', 0, '', 1, 'CHF 0.-', '-'),
(168, '0000-00-00', '0', '', '', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '', '', 0, '', 1, 'CHF 0.-', '-'),
(169, '0000-00-00', '0', '', '', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '', '', 0, '', 1, 'CHF 0.-', '-'),
(170, '0000-00-00', '0', '', '', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '', '', 0, '', 1, 'CHF 0.-', '-'),
(171, '0000-00-00', '0', '', '', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '', '', 0, '', 1, 'CHF 0.-', '-'),
(172, '0000-00-00', '0', '', '', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '', '', 0, '', 1, 'CHF 0.-', '-'),
(173, '0000-00-00', '0', '', '', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '', '', 0, '', 1, 'CHF 0.-', '-'),
(174, '0000-00-00', '0', '', '', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '', '', 0, '', 1, 'CHF 0.-', '-'),
(175, '0000-00-00', '0', '', '', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '', '', 0, '', 1, 'CHF 0.-', '-'),
(176, '0000-00-00', '0', '', '', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '', '', 0, '', 1, 'CHF 0.-', '-'),
(177, '0000-00-00', '0', '', '', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '', '', 0, '', 1, 'CHF 0.-', '-'),
(178, '0000-00-00', '0', '', '', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '', '', 0, '', 1, 'CHF 0.-', '-'),
(179, '0000-00-00', '0', '', '', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '', '', 0, '', 1, 'CHF 0.-', '-'),
(180, '0000-00-00', '0', '', '', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '', '', 0, '', 1, 'CHF 0.-', '-'),
(181, '0000-00-00', '0', '', '', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '', '', 0, '', 1, 'CHF 0.-', '-'),
(182, '0000-00-00', '0', '', '', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '', '', 0, '', 1, 'CHF 0.-', '-'),
(183, '0000-00-00', '0', '', '', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '', '', 0, '', 1, 'CHF 0.-', '-'),
(184, '0000-00-00', '0', '', '', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '', '', 0, '', 1, 'CHF 0.-', '-'),
(185, '0000-00-00', '0', '', '', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '', '', 0, '', 1, 'CHF 0.-', '-'),
(186, '0000-00-00', '0', '', '', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '', '', 0, '', 1, 'CHF 0.-', '-'),
(187, '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, '', 0, '', '');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `citytransport_verpackungsmaterial_160309`
--

CREATE TABLE `citytransport_verpackungsmaterial_160309` (
  `ID` int(11) NOT NULL,
  `OVe_Termin` date NOT NULL,
  `OVe_Bucherkarton` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_Bucherkarton_Menge` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_Ordnerkarton` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_Ordnerkarton_Menge` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_Geschirrkarton` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_Geschirrkarton_Menge` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_GeschirrkartonEinlagen` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_GeschirrkartonEinlagen_Menge` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_Kleiderboxen` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_Kleiderboxen_Menge` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_Luftpolsterfolie` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_Luftpolsterfolie_Menge` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_Seidenpapier` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_Seidenpapier_Menge` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_Lieferung` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_Rabatt` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_BemerkungOption` tinyint(1) NOT NULL,
  `OVe_Bemerkungen` text COLLATE latin1_general_ci NOT NULL,
  `OVe_Pauschalpreis` tinyint(1) NOT NULL,
  `OVe_Total` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `OVe_Promotionen` varchar(255) COLLATE latin1_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `contact`
--

CREATE TABLE `contact` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `message` text COLLATE utf8mb4_unicode_ci,
  `replyMessage` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `content`
--

CREATE TABLE `content` (
  `id` int(10) UNSIGNED NOT NULL,
  `contentTypeId` int(10) UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` text COLLATE utf8mb4_unicode_ci,
  `status` int(11) NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Daten für Tabelle `content`
--

INSERT INTO `content` (`id`, `contentTypeId`, `title`, `slug`, `content`, `status`, `created_at`, `updated_at`) VALUES
(1, 5, 'test page', 'test-page', '<p>Content Added&nbsp;</p>', 1, '2017-09-13 08:07:51', '2017-09-18 08:57:44'),
(2, 6, 'asdf', 'asdf', '<p>Test Content</p>', 0, '2017-09-20 11:10:49', '2017-09-25 08:34:10');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `contenttype`
--

CREATE TABLE `contenttype` (
  `id` int(10) UNSIGNED NOT NULL,
  `contentType` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Daten für Tabelle `contenttype`
--

INSERT INTO `contenttype` (`id`, `contentType`, `slug`, `status`, `created_at`, `updated_at`) VALUES
(5, 'General', 'home-1', 0, '2017-09-04 13:33:49', '2017-09-18 10:39:11'),
(6, 'Business Solutions', 'business-solutions', 1, '2017-09-07 07:20:33', '2017-09-07 07:21:44');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `emailtemplates`
--

CREATE TABLE `emailtemplates` (
  `id` int(10) UNSIGNED NOT NULL,
  `constant` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subject` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` text COLLATE utf8mb4_unicode_ci,
  `message` text COLLATE utf8mb4_unicode_ci,
  `status` int(11) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Daten für Tabelle `emailtemplates`
--

INSERT INTO `emailtemplates` (`id`, `constant`, `subject`, `slug`, `message`, `status`, `created_at`, `updated_at`) VALUES
(1, 'CONATACT_US', 'User Contact Us', 'template', '<table border="0" cellpadding="0" cellspacing="0" style="background-color:#ffffff; margin:0 auto 0; width:550px">\r\n	<tbody>\r\n		<tr>\r\n			<td>\r\n			<table border="0" cellpadding="0" cellspacing="0" style="background-color:#444444; padding:10px; width:100%">\r\n				<tbody>\r\n					<tr>\r\n						<td>\r\n						<div class="logo" style="color:#ffffff; float:left; font-size:40px"><a class="navbar-brand" href="###SITE_URL###" style="font-size: 13px;" title="###SITE_NM###"><span style="color:#333333"><img alt="###SITE_NM###" src="###SITE_LOGO_URL###" style="width:100px" /> </span></a></div>\r\n						</td>\r\n					</tr>\r\n				</tbody>\r\n			</table>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td>\r\n			<div style="color:#444444; font-size:22px; padding-left:10px"><span style="color:#333333; font-size:13px">Hello ###greetings###!</span></div>\r\n\r\n			<div style="float:left; line-height:20px; padding-left:10px; width:98%">\r\n			<p><span style="color:#222222; font-family:arial,sans-serif"><span style="font-size:12.8px">Thank you for contacting ###SITE_NM###.</span></span></p>\r\n\r\n			<p><span style="color:#333333"><span style="font-size:13px">&nbsp;We will give you reply as soon as possible for your feedback.</span></span></p>\r\n\r\n			<p><span style="color:#333333"><span style="font-size:13px">&nbsp;Your message details are as follows:</span></span></p>\r\n\r\n			<p>###message###</p>\r\n\r\n			<p><span style="color:#333333"><span style="font-size:13px">&nbsp;</span></span></p>\r\n\r\n			<div style="color:#595959; font-size:15px"><span style="color:#333333"><span style="font-size:13px">&nbsp;</span></span></div>\r\n			</div>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td>\r\n			<table border="0" cellpadding="0" cellspacing="0" style="background-color:#222222; padding:10px; width:100%">\r\n				<tbody>\r\n					<tr>\r\n						<td>\r\n						<div style="color:#ffffff; float:left; font-size:15px; padding:8px 15px"><span style="color:#ffffff"><span style="font-size:13px">Copyright &copy; ###YEAR### ###SITE_NM###, All Rights Reserved.</span></span></div>\r\n						</td>\r\n					</tr>\r\n				</tbody>\r\n			</table>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>', 1, '2017-09-21 11:05:48', '2017-09-21 12:00:06');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `faq`
--

CREATE TABLE `faq` (
  `id` int(10) UNSIGNED NOT NULL,
  `faqCatId` int(10) UNSIGNED NOT NULL,
  `question` text COLLATE utf8mb4_unicode_ci,
  `answer` text COLLATE utf8mb4_unicode_ci,
  `slug` text COLLATE utf8mb4_unicode_ci,
  `status` int(11) NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Daten für Tabelle `faq`
--

INSERT INTO `faq` (`id`, `faqCatId`, `question`, `answer`, `slug`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 'How do I refund my payment', '<p>You have to follow this steps.</p>', 'how-do-i-refund-my-payment', 1, '2017-09-18 12:55:59', '2017-09-18 13:21:52'),
(6, 1, 'asdf', '<p>sdf</p>', 'asdf', 0, '2017-09-18 13:22:47', '2017-09-18 13:23:10');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `faqcategory`
--

CREATE TABLE `faqcategory` (
  `id` int(10) UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Daten für Tabelle `faqcategory`
--

INSERT INTO `faqcategory` (`id`, `title`, `slug`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Payment Refund', 'home', 1, '2017-09-18 08:57:04', '2017-09-18 12:17:39'),
(3, 'About Site', 'about-site', 1, '2017-09-18 12:41:35', '2017-09-18 12:41:44');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `Mailcontent_Zueri`
--

CREATE TABLE `Mailcontent_Zueri` (
  `ID` int(11) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `content` text NOT NULL,
  `text` text NOT NULL,
  `date` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Daten für Tabelle `Mailcontent_Zueri`
--

INSERT INTO `Mailcontent_Zueri` (`ID`, `subject`, `content`, `text`, `date`) VALUES
(4, 'Exklusive Mitarbeiter - Angebote | Züri Transport AG', '<meta content="text/html; charset=UTF-8" http-equiv="Content-Type" />\r\n<title></title>\r\n<style type="text/css">\r\nbody, p {\r\n	color: #000;\r\n	background-color: #FFFFFF;\r\n	color: #000;\r\n	line-height: 22px;\r\n	font-family: Arial, Helvetica, sans-serif;\r\n	font-size: 15px;\r\n	font-weight: 300;\r\n}\r\n\r\na {\r\n	color: #000099;\r\n	text-decoration: none;\r\n}\r\na:focus,\r\na:active,\r\na:hover {\r\n	text-decoration: underline;\r\n}\r\n\r\n#Logo {\r\n	width: 800px;\r\n	margin-bottom:15px;\r\n	margin-top:5px;\r\n	}\r\n	\r\n#content {\r\n	width: 760px;\r\n	border: 1px solid #CCC;\r\n	padding: 18px;\r\n	\r\n	}\r\n\r\ndiv.exampleboxshadow {\r\n	-moz-box-shadow: 5px 5px 5px #CCC;\r\n	-webkit-box-shadow: 5px 5px 5px #CCC;\r\n	box-shadow: 5px 5px 5px #CCC;\r\n	\r\n	}\r\n\r\n\r\n.klein {\r\n	font-size: 10px;\r\n	}\r\n	\r\n	\r\n	h1 {\r\n	color: #000099;\r\n	font-size: 20px;\r\n	text-decoration: none;\r\n	font-weight: normal;\r\n	text-transform: uppercase;\r\n	letter-spacing: 1px;\r\n	word-spacing: 1px;\r\n	line-height: 30px;\r\n}\r\n\r\nh2 {\r\n	color: #000;\r\n	background-color: #FFFFFF;\r\n	color: #000;\r\n	line-height: 22px;\r\n	font-family: Arial, Helvetica, sans-serif;\r\n	font-size: 15px;\r\n	font-weight: bold;\r\n}</style>\r\n<p class="klein">\r\n	Falls Sie den Newsletter nicht richtig lesen k&ouml;nnen oder den Newsletter <strong>ausdrucken</strong> m&ouml;chten, klicken Sie bitte <a href="[%NL_LINK%]" target="_blank">hier</a></p>\r\n<div class="exampleboxshadow" id="Logo">\r\n	<a href="http://www.züritransport.ch"><img border="0" src="http://zueritransport.eofferte.ch/images/bg_header.png" width="760" /></a></div>\r\n<div class="exampleboxshadow" id="content">\r\n	<table border="0" cellpadding="0" cellspacing="0" width="760">\r\n		<tbody>\r\n			<tr>\r\n				<td valign="top" width="760">\r\n					<div>\r\n						<span style="font-size: 12.8px;">Sehr geehrte Damen und Herren&nbsp;</span></div>\r\n					<p>\r\n						<span style="font-size: 12.8px;">Das Umzugsunternehmen Z&uuml;ri Transport AG besteht seit dem Jahr 1963. Seit &uuml;ber&nbsp;</span><span style="font-size: 12.8px;">50 Jahren steht unser Name f&uuml;r professionelle und g&uuml;nstige Umz&uuml;ge in der&nbsp;</span><span style="font-size: 12.8px;">Schweiz f&uuml;r Privat und das Gewerbe.</span><br style="font-size: 12.8px;" />\r\n						<br style="font-size: 12.8px;" />\r\n						<span style="font-size: 12.8px;">Der Service der Umzugsfirma Z&uuml;ri Transport beginnt mit der kostenlosen&nbsp;</span><span style="font-size: 12.8px;">Besichtigung eines Hauses, Wohnung oder Betriebsst&auml;tte und schliesst&nbsp;</span><span style="font-size: 12.8px;">mit der Endreinigung der alten Immobilie ab &ndash; Abnahmegarantie&nbsp;</span><span style="font-size: 12.8px;">inklusive.</span></p>\r\n					<div>\r\n						<div>\r\n							<span style="font-size: 12.6667px;">Ihre Mitarbeiter profitieren von</span><span style="font-size: 12.6667px;">&nbsp;einem durchgehenden Rabatt &nbsp;</span><span style="font-size: 12.6667px;">von 20% auf Umz&uuml;ge, Reinigungen, Lagerungen und Entsorgung.&nbsp;</span></div>\r\n						<div>\r\n							<span style="font-size: 12.8px;">Bitte leiten Sie diese Email an den Zust&auml;ndigen weiter. Wir freuen uns auf Ihr Feedback.</span></div>\r\n						<div>\r\n							<div>\r\n								&nbsp;</div>\r\n							<div>\r\n								<div dir="ltr">\r\n									<div dir="ltr">\r\n										<div dir="ltr">\r\n											<div dir="ltr">\r\n												<div dir="ltr">\r\n													<div dir="ltr">\r\n														<div dir="ltr">\r\n															<div dir="ltr">\r\n																<div dir="ltr">\r\n																	<div dir="ltr">\r\n																		<div dir="ltr">\r\n																			<div dir="ltr">\r\n																				<div dir="ltr">\r\n																					<div dir="ltr">\r\n																						<div dir="ltr">\r\n																							<div dir="ltr">\r\n																								<div dir="ltr">\r\n																									<div dir="ltr">\r\n																										<div dir="ltr">\r\n																											<div dir="ltr">\r\n																												<div dir="ltr">\r\n																													<div dir="ltr">\r\n																														<div dir="ltr">\r\n																															<div dir="ltr">\r\n																																<div dir="ltr">\r\n																																	<div dir="ltr">\r\n																																		<div dir="ltr">\r\n																																			<div dir="ltr">\r\n																																				<div style="color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: small; line-height: normal;">\r\n																																					PS: Zurzeit profitieren Namhaften Unternehmen von unserem Angebot,&nbsp;</div>\r\n																																				<div style="color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: small; line-height: normal;">\r\n																																					Credit Suisse und AXA Winterthur und viele weitere Unternehmen.</div>\r\n																																				<div style="color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: small; line-height: normal;">\r\n																																					&nbsp;</div>\r\n																																				<div style="color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: small; line-height: normal;">\r\n																																					Freundliche Gr&uuml;sse</div>\r\n																																				<div style="color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: small; line-height: normal;">\r\n																																					Fabian Sch&ouml;n</div>\r\n																																			</div>\r\n																																		</div>\r\n																																	</div>\r\n																																</div>\r\n																															</div>\r\n																														</div>\r\n																													</div>\r\n																												</div>\r\n																											</div>\r\n																										</div>\r\n																									</div>\r\n																								</div>\r\n																							</div>\r\n																						</div>\r\n																					</div>\r\n																				</div>\r\n																			</div>\r\n																		</div>\r\n																	</div>\r\n																</div>\r\n															</div>\r\n														</div>\r\n													</div>\r\n												</div>\r\n											</div>\r\n										</div>\r\n									</div>\r\n								</div>\r\n							</div>\r\n						</div>\r\n					</div>\r\n				</td>\r\n			</tr>\r\n		</tbody>\r\n	</table>\r\n</div>\r\n<div class="exampleboxshadow" id="content">\r\n	<table border="0" cellpadding="0" cellspacing="0" width="760">\r\n		<tbody>\r\n			<tr>\r\n				<td valign="top" width="760">\r\n					<h1>\r\n						<img alt="" src="http://www.xn--zritransport-dlb.ch/wp-content/uploads/2016/04/Mitarbeiterangebot-Züri-Transport-AG.jpg" style="width: 750px; height: 530px;" /></h1>\r\n					<p>\r\n						&nbsp;</p>\r\n				</td>\r\n			</tr>\r\n		</tbody>\r\n	</table>\r\n</div>\r\n<br />\r\n<div class="exampleboxshadow" id="content">\r\n	<div>\r\n		<div style="color: rgb(34, 34, 34); font-family: arial, sans-serif; line-height: normal; font-size: small;">\r\n			<table border="0" cellpadding="0" cellspacing="0" style="font-family: Arial; font-size: 13.3333px;">\r\n				<tbody>\r\n					<tr style="margin-bottom: 0px; font-size: 10pt; margin-top: 0px;">\r\n						<td style="font-family: arial, sans-serif; margin: 0px; font-size: 10pt; border-right-color: rgb(227, 227, 227); border-right-style: solid; padding-right: 20px;" valign="top">\r\n							<table border="0" cellpadding="0" cellspacing="0">\r\n								<tbody>\r\n									<tr style="margin-bottom: 0px; font-size: 10pt; margin-top: 0px;">\r\n										<td style="margin: 0px;">\r\n											<font face="arial, helvetica, sans-serif"><span style="font-size: 10pt;"><img class="CToWUd a6T" height="118" src="https://ci3.googleusercontent.com/proxy/ev8lqsCUAlOi_7SZMrrrjqIBUH7Mi49J13Fh1DkSacwFdLBGrsWBY3D9cFLqSvxdRU8d3IjY4GS8l7h3YURvjUu87hNF1HjSXN6u8KPhaMkGntCla33Uhn38OqwtcMw7ZQxT7qiQbP8AieEh=s0-d-e1-ft#http://www.xn--zritransport-dlb.ch/wp-content/uploads/2016/02/zueritransport_logo_.png" style="cursor: pointer; outline: 0px;" tabindex="0" width="200" /></span><br />\r\n											<br />\r\n											<span style="line-height: 15px;"><font size="2">Z&uuml;ri Transport AG<br style="margin-bottom: 0px; margin-top: 0px;" />\r\n											Riedm&uuml;hlestrasse 1<br style="margin-bottom: 0px; margin-top: 0px;" />\r\n											CH-8306 Br&uuml;ttisellen</font></span></font></td>\r\n									</tr>\r\n									<tr style="margin-bottom: 0px; font-size: 10pt; margin-top: 0px;">\r\n										<td style="margin: 0px; font-size: 10pt; padding-top: 26px;">\r\n											&nbsp;</td>\r\n									</tr>\r\n								</tbody>\r\n							</table>\r\n						</td>\r\n						<td style="font-family: arial, sans-serif; margin: 0px; border-right-color: rgb(227, 227, 227); border-right-style: solid; padding-left: 20px; padding-right: 20px;" valign="top">\r\n							<br />\r\n							<b>Fabian Sch&ouml;n</b><br />\r\n							<table border="0" cellpadding="0" cellspacing="0">\r\n								<tbody>\r\n									<tr style="margin-bottom: 0px; font-size: 10pt; margin-top: 0px;">\r\n										<td style="margin: 0px; font-size: 10pt;">\r\n											<br style="margin-bottom: 0px; margin-top: 0px;" />\r\n											<span style="line-height: 15px;"><font face="arial, helvetica, sans-serif" size="2">&nbsp;<br />\r\n											<br />\r\n											<br />\r\n											<br />\r\n											<br />\r\n											<br style="margin-bottom: 0px; margin-top: 0px;" />\r\n											Tel 044 500 21 02<br style="margin-bottom: 0px; margin-top: 0px;" />\r\n											<a href="mailto:bektas_hueseyin@hotmail.com" style="color: rgb(17, 85, 204);" target="_blank">bektas_hueseyin@hotmail.com</a><br />\r\n											<a href="http://www.zueritransport.ch/" style="color: rgb(17, 85, 204);" target="_blank">www.zueritransport.ch</a></font></span></td>\r\n									</tr>\r\n								</tbody>\r\n							</table>\r\n						</td>\r\n						<td style="font-family: arial, sans-serif; margin: 0px; font-size: 10pt; padding-left: 20px;" valign="top" width="280">\r\n							<br />\r\n							<font face="arial, helvetica, sans-serif"><a href="https://www.facebook.com/zueritransportag" style="color: rgb(17, 85, 204);" target="_blank"><img class="CToWUd" height="38" src="https://ci4.googleusercontent.com/proxy/oQoMK7QGbcm58ERo0u0UDN6iSXU0vEU9dlMxGKIvQ_Uqhfe3vE8u55Eh59AoJHAeI3KrVDZIOaL0xCHqm6L2uTfwBNCYEGWKBj4aNRvmRo2QYOPS4wAQqNZ6VCDalXCDyZafZ1MlkNpFMYRhj3CNNweMSppgM0c=s0-d-e1-ft#http://www.xn--zritransport-dlb.ch/wp-content/uploads/2016/02/facebook-zu%CC%88ritransport-ag.jpg" style="margin-right: 0px;" width="41" /></a>&nbsp;&nbsp;<br />\r\n							<br />\r\n							&nbsp;<a href="https://plus.google.com/u/1/114961103895028926848/posts" style="color: rgb(17, 85, 204);" target="_blank"><img class="CToWUd" height="36" src="https://ci5.googleusercontent.com/proxy/TWhn5N3XLSMkn7gfNZfdKH95lM4MiFofqxwHXcTSyR7qrJ7HBYtzVmZmjs2Sr-CDhKkJTiG1qVWQi25GEf-mZDFVkAiHl1Z4-6bhKW6pG4uthGOLh4DZUvB1SVcKiqBmvjR7meWSGEOaDSw9j9DGIa7NpdXpEVnYlQ=s0-d-e1-ft#http://www.xn--zritransport-dlb.ch/wp-content/uploads/2016/02/googleplus-zu%CC%88ritransport-ag.jpg" style="margin-right: 0px;" width="39" /></a><br />\r\n							<br />\r\n							&nbsp;<a href="https://www.youtube.com/channel/UC5J104O3mi-dHrNMDWrcAeQ" style="color: rgb(17, 85, 204);" target="_blank"><img class="CToWUd" height="38" src="https://ci6.googleusercontent.com/proxy/f85KtFf6wSk0B1mrDQGZ3eFHFDSUZuHkiyJE26MRg9Klp4o3JkGh7pj242s-5J2_YWUyJc4FVBD2GtAD7ZdvjxpGhatGvUJdH_8Otfl9YiACQSvGoX6QAOTnFMVwfxZx3NM035PtEq09uee7bfzIsuSm30vTvQ=s0-d-e1-ft#http://www.xn--zritransport-dlb.ch/wp-content/uploads/2016/02/youtube-zu%CC%88ritransport-ag.jpg" style="margin-right: 0px;" width="42" /></a></font><br />\r\n							&nbsp;</td>\r\n					</tr>\r\n				</tbody>\r\n			</table>\r\n		</div>\r\n		<div style="color: rgb(34, 34, 34); font-family: arial, sans-serif; line-height: normal; font-size: small;">\r\n			&nbsp;</div>\r\n		<div style="color: rgb(34, 34, 34); font-family: arial, sans-serif; line-height: normal; font-size: small;">\r\n			<a href="http://www.xn--zritransport-dlb.ch/" style="color: rgb(17, 85, 204);" target="_blank"><img class="CToWUd" height="56" src="https://ci4.googleusercontent.com/proxy/TkU27AnO8Z_tlJ7ydGf5FlBTy7V8VdWEnUYDhXElM0JP905YjHyaKjGiru99HY1Yk1eKvfU3VVUijr2F-TPBCDHgj16fci2L1sEt0EG5n_Pbdz_E2SN3YOhxGX3OMCOF56lAqsMXacFK85s=s0-d-e1-ft#http://www.xn--zritransport-dlb.ch/wp-content/uploads/2016/03/umzugsparter-Kopie.jpeg" width="420" /></a></div>\r\n		<table border="0" cellpadding="0" cellspacing="0" width="760">\r\n			<tbody>\r\n			</tbody>\r\n		</table>\r\n	</div>\r\n</div>\r\n<p class="klein">\r\n	Sie erhalten diesen Newsletter weil wir Sie Kunden, Bekannte oder Freunde von uns sind oder Sie mein Xing-, LinkedIn- oder Facebook-Kontakt sind.<br />\r\n	Falls Sie den Newsletter nicht mehr w&uuml;nschen, k&ouml;nnen Sie sich vom Newsletter <a href="mailto:bektas_hueseyin@hotmail.com?subject=Newsletter%20abmelden" target="_blank">abmelden</a><a href="mailto:bektas_hueseyin@hotmail.com?subject=Abmelden">.</a></p>\r\n<p class="klein">\r\n	&copy; Z&uuml;ri Transport AG 2016</p>', 'Falls Sie den Newsletter nicht richtig lesen können, klicken Sie hier: \r\n [%NL_LINK%]\r\n\r\nSehr geehrte Damen und Herren \r\nDas Umzugsunternehmen Züri Transport AG besteht seit dem Jahr 1963. Seit über 50 Jahren steht unser Name für professionelle und günstige Umzüge in der Schweiz für Privat und das Gewerbe.\r\n\r\nDer Service der Umzugsfirma Züri Transport beginnt mit der kostenlosen Besichtigung eines Hauses, Wohnung oder Betriebsstätte und schliesst mit der Endreinigung der alten Immobilie ab – Abnahmegarantie inklusive.\r\n\r\nIhre Mitarbeiter profitieren von einem durchgehenden Rabatt  von 20% auf Umzüge, Reinigungen, Lagerungen und Entsorgung. \r\nBitte leiten Sie diese Email an den Zuständigen weiter. Wir freuen uns auf Ihr Feedback.\r\n\r\nPS: Zurzeit profitieren Namhaften Unternehmen von unserem Angebot, \r\nCredit Suisse und AXA Winterthur und viele weitere Unternehmen.\r\n\r\nFreundliche Grüsse\r\nFabian Schön', '2016-04-14 10:01:33'),
(5, 'TEST', '<meta content="text/html; charset=UTF-8" http-equiv="Content-Type" />\r\n<title></title>\r\n<style type="text/css">\r\nbody, p {\r\n	color: #000;\r\n	background-color: #FFFFFF;\r\n	color: #000;\r\n	line-height: 22px;\r\n	font-family: Arial, Helvetica, sans-serif;\r\n	font-size: 15px;\r\n	font-weight: 300;\r\n}\r\n\r\na {\r\n	color: #000099;\r\n	text-decoration: none;\r\n}\r\na:focus,\r\na:active,\r\na:hover {\r\n	text-decoration: underline;\r\n}\r\n\r\n#Logo {\r\n	width: 800px;\r\n	margin-bottom:15px;\r\n	margin-top:5px;\r\n	}\r\n	\r\n#content {\r\n	width: 760px;\r\n	border: 1px solid #CCC;\r\n	padding: 18px;\r\n	\r\n	}\r\n\r\ndiv.exampleboxshadow {\r\n	-moz-box-shadow: 5px 5px 5px #CCC;\r\n	-webkit-box-shadow: 5px 5px 5px #CCC;\r\n	box-shadow: 5px 5px 5px #CCC;\r\n	\r\n	}\r\n\r\n\r\n.klein {\r\n	font-size: 10px;\r\n	}\r\n	\r\n	\r\n	h1 {\r\n	color: #000099;\r\n	font-size: 20px;\r\n	text-decoration: none;\r\n	font-weight: normal;\r\n	text-transform: uppercase;\r\n	letter-spacing: 1px;\r\n	word-spacing: 1px;\r\n	line-height: 30px;\r\n}\r\n\r\nh2 {\r\n	color: #000;\r\n	background-color: #FFFFFF;\r\n	color: #000;\r\n	line-height: 22px;\r\n	font-family: Arial, Helvetica, sans-serif;\r\n	font-size: 15px;\r\n	font-weight: bold;\r\n}</style>\r\n<p class="klein">\r\n	Falls Sie den Newsletter nicht richtig lesen k&ouml;nnen oder den Newsletter <strong>ausdrucken</strong> m&ouml;chten, klicken Sie bitte <a href="[%NL_LINK%]" target="_blank">hier</a></p>\r\n<div class="exampleboxshadow" id="Logo">\r\n	<a href="http://www.citytransport.ch"><img border="0" src="http://zueritransport.eofferte.ch/images/bg_header.png" width="760" /></a></div>\r\n<div class="exampleboxshadow" id="content">\r\n	<div>\r\n		<table border="0" cellpadding="0" cellspacing="0" width="760">\r\n			<tbody>\r\n				<tr>\r\n					<td valign="top" width="760">\r\n						<p>\r\n							Sehr geehrte Damen und Herren</p>\r\n						<p>\r\n							Unsere Referenzenliste wird stets erneuert und f&uuml;r Sie aktualisiert. Wir stehen Ihnen jederzeit f&uuml;r Fragen und Anregungen gerne zur Verf&uuml;gung.</p>\r\n						<p>\r\n							Unsere beste Referenz sind zufriedene Kunden. Diese b&uuml;rgen mit Ihrem Namen f&uuml;r die gute Qualit&auml;t der City Transport GmbH.</p>\r\n						<p>\r\n							<img height="101" src="http://www.kramer-fashion.ch/newsletter/htmlmail/html/images/Unterschrift-Thomas_neu.jpg" width="300" /></p>\r\n						<p>\r\n							Mit freundlichen Gr&uuml;ssen Babrak Rahimi</p>\r\n					</td>\r\n				</tr>\r\n			</tbody>\r\n		</table>\r\n	</div>\r\n</div>\r\n<br />\r\n<div class="exampleboxshadow" id="content">\r\n	<div>\r\n		<table border="0" cellpadding="0" cellspacing="0" width="760">\r\n			<tbody>\r\n				<tr>\r\n					<td valign="top" width="760">\r\n						<h1>\r\n							<a href="http://www.citytransport.ch/umzug/"><img border="0" height="292" src="http://www.citytransport.ch/wp-content/uploads/2013/02/Umzug1.jpg" width="611" /></a></h1>\r\n						<p>\r\n							Wir wollen Ihren <strong>Umzug</strong> f&uuml;r Sie so stressfrei und angenehm wie m&ouml;glich erledigen. Dazu bieten wir Ihnen einen pers&ouml;nlichen und engagierten Service, mit geschultem und freundlichem Personal. Inbegriffen ist nat&uuml;rlich auch das entsprechende <strong>Schutzmaterial</strong>.</p>\r\n						<h3>\r\n							<a href="http://www.citytransport.ch/privatumzug/" title="Privatumzug">&gt;&gt; Privatumzug</a></h3>\r\n						<h3>\r\n							<a href="http://www.citytransport.ch/seniorenumzug/" title="Seniorenumzug">&gt;&gt; Seniorenumzug</a></h3>\r\n						<h3>\r\n							<a href="http://www.citytransport.ch/geschaeftsumzug/">&gt;&gt; Gesch&auml;ftsumzug</a></h3>\r\n						<p>\r\n							Haben Sie noch Fragen zu unserem <strong>Umzugsservice</strong>, oder wollen Sie gleich einen kostenlosen Besichtigungstermin vereinbaren?</p>\r\n						<h2>\r\n							Fordern Sie jetzt eine kostenlose Offerte an!</h2>\r\n					</td>\r\n				</tr>\r\n			</tbody>\r\n		</table>\r\n	</div>\r\n</div>\r\n<br />\r\n<div class="exampleboxshadow" id="content">\r\n	<div>\r\n		<table border="0" cellpadding="0" cellspacing="0" width="760">\r\n			<tbody>\r\n				<tr>\r\n					<td valign="top" width="760">\r\n						<h1>\r\n							<a href="http://www.citytransport.ch/reinigung/"><img border="0" height="292" src="http://www.citytransport.ch/wp-content/uploads/2013/02/Reinigung-mit-Abgabegarantie.jpg" width="611" /></a></h1>\r\n						<p>\r\n							Wir wollen Ihren <strong>Umzug</strong> f&uuml;r Sie so stressfrei und angenehm wie m&ouml;glich erledigen. Dazu bieten wir Ihnen einen pers&ouml;nlichen und engagierten Service, mit geschultem und freundlichem Personal. Inbegriffen ist nat&uuml;rlich auch das entsprechende <strong>Schutzmaterial</strong>.</p>\r\n						<h3>\r\n							<a href="http://www.citytransport.ch/privatumzug/" title="Privatumzug">&gt;&gt; Privatumzug</a></h3>\r\n						<h3>\r\n							<a href="http://www.citytransport.ch/seniorenumzug/" title="Seniorenumzug">&gt;&gt; Seniorenumzug</a></h3>\r\n						<h3>\r\n							<a href="http://www.citytransport.ch/geschaeftsumzug/">&gt;&gt; Gesch&auml;ftsumzug</a></h3>\r\n						<p>\r\n							Haben Sie noch Fragen zu unserem <strong>Umzugsservice</strong>, oder wollen Sie gleich einen kostenlosen Besichtigungstermin vereinbaren?</p>\r\n						<h2>\r\n							Fordern Sie jetzt eine kostenlose Offerte an!</h2>\r\n					</td>\r\n				</tr>\r\n			</tbody>\r\n		</table>\r\n	</div>\r\n</div>\r\n<br />\r\n<div class="exampleboxshadow" id="content">\r\n	<div>\r\n		<table border="0" cellpadding="0" cellspacing="0" width="760">\r\n			<tbody>\r\n				<tr>\r\n					<td valign="top" width="760">\r\n						<h1>\r\n							<a href="http://www.citytransport.ch/umzug/"><img border="0" height="292" src="http://www.citytransport.ch/wp-content/uploads/2013/02/Umzug1.jpg" width="611" /></a></h1>\r\n						<p>\r\n							Wir wollen Ihren <strong>Umzug</strong> f&uuml;r Sie so stressfrei und angenehm wie m&ouml;glich erledigen. Dazu bieten wir Ihnen einen pers&ouml;nlichen und engagierten Service, mit geschultem und freundlichem Personal. Inbegriffen ist nat&uuml;rlich auch das entsprechende <strong>Schutzmaterial</strong>.</p>\r\n						<h3>\r\n							<a href="http://www.citytransport.ch/privatumzug/" title="Privatumzug">&gt;&gt; Privatumzug</a></h3>\r\n						<h3>\r\n							<a href="http://www.citytransport.ch/seniorenumzug/" title="Seniorenumzug">&gt;&gt; Seniorenumzug</a></h3>\r\n						<h3>\r\n							<a href="http://www.citytransport.ch/geschaeftsumzug/">&gt;&gt; Gesch&auml;ftsumzug</a></h3>\r\n						<p>\r\n							Haben Sie noch Fragen zu unserem <strong>Umzugsservice</strong>, oder wollen Sie gleich einen kostenlosen Besichtigungstermin vereinbaren?</p>\r\n						<h2>\r\n							Fordern Sie jetzt eine kostenlose Offerte an!</h2>\r\n					</td>\r\n				</tr>\r\n			</tbody>\r\n		</table>\r\n	</div>\r\n</div>\r\n<br />\r\n<div class="exampleboxshadow" id="content">\r\n	<div>\r\n		<table border="0" cellpadding="0" cellspacing="0" width="760">\r\n			<tbody>\r\n			</tbody>\r\n		</table>\r\n		<table border="0" cellpadding="0" cellspacing="0" style="font-family: Arial; font-size: 13.3333px;">\r\n			<tbody>\r\n				<tr style="margin-bottom: 0px; font-size: 10pt; margin-top: 0px;">\r\n					<td style="font-family: arial, sans-serif; margin: 0px; font-size: 10pt; border-right-color: rgb(227, 227, 227); border-right-style: solid; padding-right: 20px;" valign="top">\r\n						<table border="0" cellpadding="0" cellspacing="0">\r\n							<tbody>\r\n								<tr style="margin-bottom: 0px; font-size: 10pt; margin-top: 0px;">\r\n									<td style="margin: 0px;">\r\n										<font face="arial, helvetica, sans-serif"><span style="font-size: 10pt;"><img class="CToWUd a6T" height="118" src="https://ci3.googleusercontent.com/proxy/ev8lqsCUAlOi_7SZMrrrjqIBUH7Mi49J13Fh1DkSacwFdLBGrsWBY3D9cFLqSvxdRU8d3IjY4GS8l7h3YURvjUu87hNF1HjSXN6u8KPhaMkGntCla33Uhn38OqwtcMw7ZQxT7qiQbP8AieEh=s0-d-e1-ft#http://www.xn--zritransport-dlb.ch/wp-content/uploads/2016/02/zueritransport_logo_.png" style="cursor: pointer; outline: 0px;" tabindex="0" width="200" /></span><br />\r\n										<br />\r\n										<span style="line-height: 15px;"><font size="2">Z&uuml;ri Transport AG<br style="margin-bottom: 0px; margin-top: 0px;" />\r\n										Riedm&uuml;hlestrasse 1<br style="margin-bottom: 0px; margin-top: 0px;" />\r\n										CH-8306 Br&uuml;ttisellen</font></span></font></td>\r\n								</tr>\r\n								<tr style="margin-bottom: 0px; font-size: 10pt; margin-top: 0px;">\r\n									<td style="margin: 0px; font-size: 10pt; padding-top: 26px;">\r\n										&nbsp;</td>\r\n								</tr>\r\n							</tbody>\r\n						</table>\r\n					</td>\r\n					<td style="font-family: arial, sans-serif; margin: 0px; border-right-color: rgb(227, 227, 227); border-right-style: solid; padding-left: 20px; padding-right: 20px;" valign="top">\r\n						<br />\r\n						<b>Fabian Sch&ouml;n</b><br />\r\n						<table border="0" cellpadding="0" cellspacing="0">\r\n							<tbody>\r\n								<tr style="margin-bottom: 0px; font-size: 10pt; margin-top: 0px;">\r\n									<td style="margin: 0px; font-size: 10pt;">\r\n										<br style="margin-bottom: 0px; margin-top: 0px;" />\r\n										<span style="line-height: 15px;"><font face="arial, helvetica, sans-serif" size="2">&nbsp;<br />\r\n										<br />\r\n										<br />\r\n										<br />\r\n										<br />\r\n										<br style="margin-bottom: 0px; margin-top: 0px;" />\r\n										Tel 044 500 21 02<br style="margin-bottom: 0px; margin-top: 0px;" />\r\n										<a href="mailto:bektas_hueseyin@hotmail.com" style="color: rgb(17, 85, 204);" target="_blank">bektas_hueseyin@hotmail.com</a><br />\r\n										<a href="http://www.zueritransport.ch/" style="color: rgb(17, 85, 204);" target="_blank">www.zueritransport.ch</a></font></span></td>\r\n								</tr>\r\n							</tbody>\r\n						</table>\r\n					</td>\r\n					<td style="font-family: arial, sans-serif; margin: 0px; font-size: 10pt; padding-left: 20px;" valign="top" width="280">\r\n						<br />\r\n						<font face="arial, helvetica, sans-serif"><a href="https://www.facebook.com/zueritransportag" style="color: rgb(17, 85, 204);" target="_blank"><img class="CToWUd" height="38" src="https://ci4.googleusercontent.com/proxy/oQoMK7QGbcm58ERo0u0UDN6iSXU0vEU9dlMxGKIvQ_Uqhfe3vE8u55Eh59AoJHAeI3KrVDZIOaL0xCHqm6L2uTfwBNCYEGWKBj4aNRvmRo2QYOPS4wAQqNZ6VCDalXCDyZafZ1MlkNpFMYRhj3CNNweMSppgM0c=s0-d-e1-ft#http://www.xn--zritransport-dlb.ch/wp-content/uploads/2016/02/facebook-zu%CC%88ritransport-ag.jpg" style="margin-right: 0px;" width="41" /></a>&nbsp;&nbsp;<br />\r\n						<br />\r\n						&nbsp;<a href="https://plus.google.com/u/1/114961103895028926848/posts" style="color: rgb(17, 85, 204);" target="_blank"><img class="CToWUd" height="36" src="https://ci5.googleusercontent.com/proxy/TWhn5N3XLSMkn7gfNZfdKH95lM4MiFofqxwHXcTSyR7qrJ7HBYtzVmZmjs2Sr-CDhKkJTiG1qVWQi25GEf-mZDFVkAiHl1Z4-6bhKW6pG4uthGOLh4DZUvB1SVcKiqBmvjR7meWSGEOaDSw9j9DGIa7NpdXpEVnYlQ=s0-d-e1-ft#http://www.xn--zritransport-dlb.ch/wp-content/uploads/2016/02/googleplus-zu%CC%88ritransport-ag.jpg" style="margin-right: 0px;" width="39" /></a><br />\r\n						<br />\r\n						&nbsp;<a href="https://www.youtube.com/channel/UC5J104O3mi-dHrNMDWrcAeQ" style="color: rgb(17, 85, 204);" target="_blank"><img class="CToWUd" height="38" src="https://ci6.googleusercontent.com/proxy/f85KtFf6wSk0B1mrDQGZ3eFHFDSUZuHkiyJE26MRg9Klp4o3JkGh7pj242s-5J2_YWUyJc4FVBD2GtAD7ZdvjxpGhatGvUJdH_8Otfl9YiACQSvGoX6QAOTnFMVwfxZx3NM035PtEq09uee7bfzIsuSm30vTvQ=s0-d-e1-ft#http://www.xn--zritransport-dlb.ch/wp-content/uploads/2016/02/youtube-zu%CC%88ritransport-ag.jpg" style="margin-right: 0px;" width="42" /></a></font><br />\r\n						&nbsp;</td>\r\n				</tr>\r\n			</tbody>\r\n		</table>\r\n		<div style="color: rgb(34, 34, 34); font-family: arial, sans-serif; line-height: normal; font-size: small;">\r\n			&nbsp;</div>\r\n		<div style="color: rgb(34, 34, 34); font-family: arial, sans-serif; line-height: normal; font-size: small;">\r\n			<a href="http://www.xn--zritransport-dlb.ch/" style="color: rgb(17, 85, 204);" target="_blank"><img class="CToWUd" height="56" src="https://ci4.googleusercontent.com/proxy/TkU27AnO8Z_tlJ7ydGf5FlBTy7V8VdWEnUYDhXElM0JP905YjHyaKjGiru99HY1Yk1eKvfU3VVUijr2F-TPBCDHgj16fci2L1sEt0EG5n_Pbdz_E2SN3YOhxGX3OMCOF56lAqsMXacFK85s=s0-d-e1-ft#http://www.xn--zritransport-dlb.ch/wp-content/uploads/2016/03/umzugsparter-Kopie.jpeg" width="420" /></a></div>\r\n		<table border="0" cellpadding="0" cellspacing="0" width="760">\r\n			<tbody>\r\n			</tbody>\r\n		</table>\r\n	</div>\r\n</div>\r\n<p class="klein">\r\n	Sie erhalten diesen Newsletter weil wir Sie Kunden, Bekannte oder Freunde von uns sind oder Sie mein Xing-, LinkedIn- oder Facebook-Kontakt sind.<br />\r\n	Falls Sie den Newsletter nicht mehr w&uuml;nschen, k&ouml;nnen Sie sich vom Newsletter <a href="mailto:bektas_hueseyin@hotmail.com?subject=Newsletter abmelden" target="_blank">abmelden</a>.</p>\r\n<p class="klein">\r\n	&copy; Z&uuml;ri Transport 2016</p>', 'Falls Sie den Newsletter nicht richtig lesen können, klicken Sie hier: \r\n [%NL_LINK%]', '2016-04-13 04:56:55'),
(6, '10% Rabatt auf deinen Umzug - Züri Transport AG', '<meta content="text/html; charset=UTF-8" http-equiv="Content-Type" />\r\n<title></title>\r\n<style type="text/css">\r\nbody, p {\r\n	color: #000;\r\n	background-color: #FFFFFF;\r\n	color: #000;\r\n	line-height: 22px;\r\n	font-family: Arial, Helvetica, sans-serif;\r\n	font-size: 15px;\r\n	font-weight: 300;\r\n}\r\n\r\na {\r\n	color: #000099;\r\n	text-decoration: none;\r\n}\r\na:focus,\r\na:active,\r\na:hover {\r\n	text-decoration: underline;\r\n}\r\n\r\n#Logo {\r\n	width: 800px;\r\n	margin-bottom:15px;\r\n	margin-top:5px;\r\n	}\r\n	\r\n#content {\r\n	width: 760px;\r\n	border: 1px solid #CCC;\r\n	padding: 18px;\r\n	\r\n	}\r\n\r\ndiv.exampleboxshadow {\r\n	-moz-box-shadow: 5px 5px 5px #CCC;\r\n	-webkit-box-shadow: 5px 5px 5px #CCC;\r\n	box-shadow: 5px 5px 5px #CCC;\r\n	\r\n	}\r\n\r\n\r\n.klein {\r\n	font-size: 10px;\r\n	}\r\n	\r\n	\r\n	h1 {\r\n	color: #000099;\r\n	font-size: 20px;\r\n	text-decoration: none;\r\n	font-weight: normal;\r\n	text-transform: uppercase;\r\n	letter-spacing: 1px;\r\n	word-spacing: 1px;\r\n	line-height: 30px;\r\n}\r\n\r\nh2 {\r\n	color: #000;\r\n	background-color: #FFFFFF;\r\n	color: #000;\r\n	line-height: 22px;\r\n	font-family: Arial, Helvetica, sans-serif;\r\n	font-size: 15px;\r\n	font-weight: bold;\r\n}</style>\r\n<p class="klein">\r\n	Falls Sie den Newsletter nicht richtig lesen k&ouml;nnen oder den Newsletter <strong>ausdrucken</strong> m&ouml;chten, klicken Sie bitte <a href="[%NL_LINK%]" target="_blank">hier</a></p>\r\n<div class="exampleboxshadow" id="Logo">\r\n	<a href="http://www.züritransport.ch"><img border="0" src="http://zueritransport.eofferte.ch/images/bg_header.png" width="760" /></a></div>\r\n<div class="exampleboxshadow" id="content">\r\n	<table border="0" cellpadding="0" cellspacing="0" width="760">\r\n		<tbody>\r\n			<tr>\r\n				<td valign="top" width="760">\r\n					<div>\r\n						<span style="font-size:12px;"><span style="font-family:arial,helvetica,sans-serif;">Sehr geehrte Damen und Herren&nbsp;</span></span></div>\r\n					<div>\r\n						&nbsp;</div>\r\n					<div>\r\n						<span style="font-size:12px;"><span style="font-family:arial,helvetica,sans-serif;">Das Umzugsunternehmen Z&uuml;ri Transport AG besteht seit dem Jahr 1963. Seit &uuml;ber&nbsp;50 Jahren steht unser Name f&uuml;r professionelle und g&uuml;nstige Umz&uuml;ge in der&nbsp;Schweiz f&uuml;r Privat und das Gewerbe.</span></span></div>\r\n					<div>\r\n						&nbsp;</div>\r\n					<div>\r\n						<span style="font-size:12px;"><span style="font-family:arial,helvetica,sans-serif;">Der Service der Umzugsfirma Z&uuml;ri Transport beginnt mit der kostenlosen&nbsp;Besichtigung eines Hauses, Wohnung oder Betriebsst&auml;tte und schliesst&nbsp;mit der Endreinigung der alten Immobilie ab &ndash; Abnahmegarantie&nbsp;inklusive.</span></span></div>\r\n					<div>\r\n						&nbsp;</div>\r\n					<div>\r\n						<div>\r\n							<strong><span style="font-size:12px;"><span style="font-family:arial,helvetica,sans-serif;">Profitieren Sie von 10% Rabatt auf Umz&uuml;ge, Reinigungen, Lagerungen und Entsorgung bis 31.12.2016</span></span></strong></div>\r\n						<div>\r\n							<span style="font-size:12px;"><span style="font-family:arial,helvetica,sans-serif;"><strong>(Kennwort: News2016)&nbsp;</strong></span></span></div>\r\n						<div>\r\n							&nbsp;</div>\r\n						<div>\r\n							<span style="font-size:12px;"><span style="font-family:arial,helvetica,sans-serif;">Mach jetzt deine Anfrage online.&nbsp;</span></span></div>\r\n						<div>\r\n							<div>\r\n								<div dir="ltr">\r\n									<div dir="ltr">\r\n										<div dir="ltr">\r\n											<div dir="ltr">\r\n												<div dir="ltr">\r\n													<div dir="ltr">\r\n														<div dir="ltr">\r\n															<div dir="ltr">\r\n																<div dir="ltr">\r\n																	<div dir="ltr">\r\n																		<div dir="ltr">\r\n																			<div dir="ltr">\r\n																				<div dir="ltr">\r\n																					<div dir="ltr">\r\n																						<div dir="ltr">\r\n																							<div dir="ltr">\r\n																								<div dir="ltr">\r\n																									<div dir="ltr">\r\n																										<div dir="ltr">\r\n																											<div dir="ltr">\r\n																												<div dir="ltr">\r\n																													<div dir="ltr">\r\n																														<div dir="ltr">\r\n																															<div dir="ltr">\r\n																																<div dir="ltr">\r\n																																	<div dir="ltr">\r\n																																		<div dir="ltr">\r\n																																			<div dir="ltr">\r\n																																				<div style="color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: small; line-height: normal;">\r\n																																					&nbsp;</div>\r\n																																				<div style="color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: small; line-height: normal;">\r\n																																					Freundliche Gr&uuml;sse</div>\r\n																																				<div style="color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: small; line-height: normal;">\r\n																																					Fabian Sch&ouml;n</div>\r\n																																			</div>\r\n																																		</div>\r\n																																	</div>\r\n																																</div>\r\n																															</div>\r\n																														</div>\r\n																													</div>\r\n																												</div>\r\n																											</div>\r\n																										</div>\r\n																									</div>\r\n																								</div>\r\n																							</div>\r\n																						</div>\r\n																					</div>\r\n																				</div>\r\n																			</div>\r\n																		</div>\r\n																	</div>\r\n																</div>\r\n															</div>\r\n														</div>\r\n													</div>\r\n												</div>\r\n											</div>\r\n										</div>\r\n									</div>\r\n								</div>\r\n							</div>\r\n						</div>\r\n					</div>\r\n				</td>\r\n			</tr>\r\n		</tbody>\r\n	</table>\r\n</div>\r\n<div class="exampleboxshadow" id="content">\r\n	<table border="0" cellpadding="0" cellspacing="0" width="760">\r\n		<tbody>\r\n			<tr>\r\n				<td valign="top" width="760">\r\n					<h1>\r\n						<img alt="" src="http://www.xn--zritransport-dlb.ch/wp-content/uploads/2016/04/Mitarbeiterangebot-Züri-Transport-AG.jpg" style="width: 750px; height: 530px;" /></h1>\r\n					<p>\r\n						&nbsp;</p>\r\n				</td>\r\n			</tr>\r\n		</tbody>\r\n	</table>\r\n</div>\r\n<br />\r\n<div class="exampleboxshadow" id="content">\r\n	<div>\r\n		<div style="color: rgb(34, 34, 34); font-family: arial, sans-serif; line-height: normal; font-size: small;">\r\n			<table border="0" cellpadding="0" cellspacing="0" style="font-family: Arial; font-size: 13.3333px;">\r\n				<tbody>\r\n					<tr style="margin-bottom: 0px; font-size: 10pt; margin-top: 0px;">\r\n						<td style="font-family: arial, sans-serif; margin: 0px; font-size: 10pt; border-right-color: rgb(227, 227, 227); border-right-style: solid; padding-right: 20px;" valign="top">\r\n							<table border="0" cellpadding="0" cellspacing="0">\r\n								<tbody>\r\n									<tr style="margin-bottom: 0px; font-size: 10pt; margin-top: 0px;">\r\n										<td style="margin: 0px;">\r\n											<font face="arial, helvetica, sans-serif"><span style="font-size: 10pt;"><img class="CToWUd a6T" height="118" src="https://ci3.googleusercontent.com/proxy/ev8lqsCUAlOi_7SZMrrrjqIBUH7Mi49J13Fh1DkSacwFdLBGrsWBY3D9cFLqSvxdRU8d3IjY4GS8l7h3YURvjUu87hNF1HjSXN6u8KPhaMkGntCla33Uhn38OqwtcMw7ZQxT7qiQbP8AieEh=s0-d-e1-ft#http://www.xn--zritransport-dlb.ch/wp-content/uploads/2016/02/zueritransport_logo_.png" style="cursor: pointer; outline: 0px;" tabindex="0" width="200" /></span><br />\r\n											<br />\r\n											<span style="line-height: 15px;"><font size="2">Z&uuml;ri Transport AG<br style="margin-bottom: 0px; margin-top: 0px;" />\r\n											Riedm&uuml;hlestrasse 1<br style="margin-bottom: 0px; margin-top: 0px;" />\r\n											CH-8306 Br&uuml;ttisellen</font></span></font></td>\r\n									</tr>\r\n									<tr style="margin-bottom: 0px; font-size: 10pt; margin-top: 0px;">\r\n										<td style="margin: 0px; font-size: 10pt; padding-top: 26px;">\r\n											&nbsp;</td>\r\n									</tr>\r\n								</tbody>\r\n							</table>\r\n						</td>\r\n						<td style="font-family: arial, sans-serif; margin: 0px; border-right-color: rgb(227, 227, 227); border-right-style: solid; padding-left: 20px; padding-right: 20px;" valign="top">\r\n							<br />\r\n							<b>Fabian Sch&ouml;n</b><br />\r\n							<table border="0" cellpadding="0" cellspacing="0">\r\n								<tbody>\r\n									<tr style="margin-bottom: 0px; font-size: 10pt; margin-top: 0px;">\r\n										<td style="margin: 0px; font-size: 10pt;">\r\n											<br style="margin-bottom: 0px; margin-top: 0px;" />\r\n											<span style="line-height: 15px;"><font face="arial, helvetica, sans-serif" size="2">&nbsp;<br />\r\n											<br />\r\n											<br />\r\n											<br />\r\n											<br />\r\n											<br style="margin-bottom: 0px; margin-top: 0px;" />\r\n											Tel 044 500 21 02<br style="margin-bottom: 0px; margin-top: 0px;" />\r\n											<a href="mailto:bektas_hueseyin@hotmail.com" style="color: rgb(17, 85, 204);" target="_blank">bektas_hueseyin@hotmail.com</a><br />\r\n											<a href="http://www.zueritransport.ch/" style="color: rgb(17, 85, 204);" target="_blank">www.zueritransport.ch</a></font></span></td>\r\n									</tr>\r\n								</tbody>\r\n							</table>\r\n						</td>\r\n						<td style="font-family: arial, sans-serif; margin: 0px; font-size: 10pt; padding-left: 20px;" valign="top" width="280">\r\n							<br />\r\n							<font face="arial, helvetica, sans-serif"><a href="https://www.facebook.com/zueritransportag" style="color: rgb(17, 85, 204);" target="_blank"><img class="CToWUd" height="38" src="https://ci4.googleusercontent.com/proxy/oQoMK7QGbcm58ERo0u0UDN6iSXU0vEU9dlMxGKIvQ_Uqhfe3vE8u55Eh59AoJHAeI3KrVDZIOaL0xCHqm6L2uTfwBNCYEGWKBj4aNRvmRo2QYOPS4wAQqNZ6VCDalXCDyZafZ1MlkNpFMYRhj3CNNweMSppgM0c=s0-d-e1-ft#http://www.xn--zritransport-dlb.ch/wp-content/uploads/2016/02/facebook-zu%CC%88ritransport-ag.jpg" style="margin-right: 0px;" width="41" /></a>&nbsp;&nbsp;<br />\r\n							<br />\r\n							&nbsp;<a href="https://plus.google.com/u/1/114961103895028926848/posts" style="color: rgb(17, 85, 204);" target="_blank"><img class="CToWUd" height="36" src="https://ci5.googleusercontent.com/proxy/TWhn5N3XLSMkn7gfNZfdKH95lM4MiFofqxwHXcTSyR7qrJ7HBYtzVmZmjs2Sr-CDhKkJTiG1qVWQi25GEf-mZDFVkAiHl1Z4-6bhKW6pG4uthGOLh4DZUvB1SVcKiqBmvjR7meWSGEOaDSw9j9DGIa7NpdXpEVnYlQ=s0-d-e1-ft#http://www.xn--zritransport-dlb.ch/wp-content/uploads/2016/02/googleplus-zu%CC%88ritransport-ag.jpg" style="margin-right: 0px;" width="39" /></a><br />\r\n							<br />\r\n							&nbsp;<a href="https://www.youtube.com/channel/UC5J104O3mi-dHrNMDWrcAeQ" style="color: rgb(17, 85, 204);" target="_blank"><img class="CToWUd" height="38" src="https://ci6.googleusercontent.com/proxy/f85KtFf6wSk0B1mrDQGZ3eFHFDSUZuHkiyJE26MRg9Klp4o3JkGh7pj242s-5J2_YWUyJc4FVBD2GtAD7ZdvjxpGhatGvUJdH_8Otfl9YiACQSvGoX6QAOTnFMVwfxZx3NM035PtEq09uee7bfzIsuSm30vTvQ=s0-d-e1-ft#http://www.xn--zritransport-dlb.ch/wp-content/uploads/2016/02/youtube-zu%CC%88ritransport-ag.jpg" style="margin-right: 0px;" width="42" /></a></font><br />\r\n							&nbsp;</td>\r\n					</tr>\r\n				</tbody>\r\n			</table>\r\n		</div>\r\n		<div style="color: rgb(34, 34, 34); font-family: arial, sans-serif; line-height: normal; font-size: small;">\r\n			&nbsp;</div>\r\n		<div style="color: rgb(34, 34, 34); font-family: arial, sans-serif; line-height: normal; font-size: small;">\r\n			<a href="http://www.xn--zritransport-dlb.ch/" style="color: rgb(17, 85, 204);" target="_blank"><img class="CToWUd" height="56" src="https://ci4.googleusercontent.com/proxy/TkU27AnO8Z_tlJ7ydGf5FlBTy7V8VdWEnUYDhXElM0JP905YjHyaKjGiru99HY1Yk1eKvfU3VVUijr2F-TPBCDHgj16fci2L1sEt0EG5n_Pbdz_E2SN3YOhxGX3OMCOF56lAqsMXacFK85s=s0-d-e1-ft#http://www.xn--zritransport-dlb.ch/wp-content/uploads/2016/03/umzugsparter-Kopie.jpeg" width="420" /></a></div>\r\n		<table border="0" cellpadding="0" cellspacing="0" width="760">\r\n			<tbody>\r\n			</tbody>\r\n		</table>\r\n	</div>\r\n</div>\r\n<p class="klein">\r\n	Sie erhalten diesen Newsletter weil wir Sie Kunden, Bekannte oder Freunde von uns sind oder Sie mein Xing-, LinkedIn- oder Facebook-Kontakt sind.<br />\r\n	Falls Sie den Newsletter nicht mehr w&uuml;nschen, k&ouml;nnen Sie sich vom Newsletter <a href="mailto:bektas_hueseyin@hotmail.com?subject=Newsletter%20abmelden" target="_blank">abmelden</a><a href="mailto:bektas_hueseyin@hotmail.com?subject=Abmelden">.</a></p>\r\n<p class="klein">\r\n	&copy; Z&uuml;ri Transport AG 2016</p>', 'Falls Sie den Newsletter nicht richtig lesen können, klicken Sie hier: \r\n [%NL_LINK%]\r\n\r\nSehr geehrte Damen und Herren \r\n\r\nDas Umzugsunternehmen Züri Transport AG besteht seit dem Jahr 1963. Seit über 50 Jahren steht unser Name für professionelle und günstige Umzüge in der Schweiz für Privat und das Gewerbe.\r\n\r\nDer Service der Umzugsfirma Züri Transport beginnt mit der kostenlosen Besichtigung eines Hauses, Wohnung oder Betriebsstätte und schliesst mit der Endreinigung der alten Immobilie ab – Abnahmegarantie inklusive.\r\n\r\nProfitieren Sie von 10% Rabatt auf Umzüge, Reinigungen, Lagerungen und Entsorgung bis 31.12.2016\r\n(Kennwort: News2016) \r\n\r\nMach jetzt deine Anfrage online. \r\n\r\nFreundliche Grüsse\r\nFabian Schön', '2016-04-14 10:03:23');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Daten für Tabelle `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2017_04_23_121132_create_admins_table', 1),
(5, '2017_08_27_134256_create_category_table', 2),
(6, '2017_09_01_120833_create_content_type_table', 3),
(8, '2017_09_07_125616_create_content_table', 4),
(9, '2017_09_14_182302_create_faqCategory_table', 5),
(10, '2017_09_14_182544_create_faq_table', 6),
(11, '2017_09_20_130741_create_siteSetting_table', 7),
(12, '2017_09_20_170500_create_emailTemplate_table', 8),
(13, '2017_09_24_132452_alter_admin_table', 9),
(14, '2017_10_01_160339_create_contact_table', 10);

--
-- Indizes für die Tabelle `category`
--
ALTER TABLE `category`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `citytransport`
--
ALTER TABLE `citytransport`
  ADD PRIMARY KEY (`ID`);

--
-- Indizes für die Tabelle `citytransport_auspackservice`
--
ALTER TABLE `citytransport_auspackservice`
  ADD PRIMARY KEY (`ID`);

--
-- Indizes für die Tabelle `citytransport_besichtigung`
--
ALTER TABLE `citytransport_besichtigung`
  ADD PRIMARY KEY (`ID`);

--
-- Indizes für die Tabelle `citytransport_bestaetigung`
--
ALTER TABLE `citytransport_bestaetigung`
  ADD PRIMARY KEY (`ID`);

--
-- Indizes für die Tabelle `citytransport_bestaetigung_160830`
--
ALTER TABLE `citytransport_bestaetigung_160830`
  ADD PRIMARY KEY (`ID`);

--
-- Indizes für die Tabelle `citytransport_brocki`
--
ALTER TABLE `citytransport_brocki`
  ADD PRIMARY KEY (`ID`);

--
-- Indizes für die Tabelle `citytransport_entsorgung`
--
ALTER TABLE `citytransport_entsorgung`
  ADD PRIMARY KEY (`ID`);

--
-- Indizes für die Tabelle `citytransport_lagerung`
--
ALTER TABLE `citytransport_lagerung`
  ADD PRIMARY KEY (`ID`);

--
-- Indizes für die Tabelle `citytransport_lohnabrechnung`
--
ALTER TABLE `citytransport_lohnabrechnung`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `citytransport_mitarbeiter`
--
ALTER TABLE `citytransport_mitarbeiter`
  ADD PRIMARY KEY (`ID`);

--
-- Indizes für die Tabelle `citytransport_monatlohn`
--
ALTER TABLE `citytransport_monatlohn`
  ADD PRIMARY KEY (`ID`),
  ADD UNIQUE KEY `ID` (`ID`);

--
-- Indizes für die Tabelle `citytransport_packservice`
--
ALTER TABLE `citytransport_packservice`
  ADD PRIMARY KEY (`ID`);

--
-- Indizes für die Tabelle `citytransport_personal`
--
ALTER TABLE `citytransport_personal`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `citytransport_quittung`
--
ALTER TABLE `citytransport_quittung`
  ADD PRIMARY KEY (`ID`);

--
-- Indizes für die Tabelle `citytransport_rechnung`
--
ALTER TABLE `citytransport_rechnung`
  ADD PRIMARY KEY (`ID`);

--
-- Indizes für die Tabelle `citytransport_reinigung`
--
ALTER TABLE `citytransport_reinigung`
  ADD PRIMARY KEY (`ID`);

--
-- Indizes für die Tabelle `citytransport_sicher_160223`
--
ALTER TABLE `citytransport_sicher_160223`
  ADD PRIMARY KEY (`ID`);

--
-- Indizes für die Tabelle `citytransport_smsworkers`
--
ALTER TABLE `citytransport_smsworkers`
  ADD PRIMARY KEY (`ID`);

--
-- Indizes für die Tabelle `citytransport_stundenlohn`
--
ALTER TABLE `citytransport_stundenlohn`
  ADD PRIMARY KEY (`ID`),
  ADD UNIQUE KEY `ID` (`ID`);

--
-- Indizes für die Tabelle `citytransport_umsatz`
--
ALTER TABLE `citytransport_umsatz`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `citytransport_umsatz_personal`
--
ALTER TABLE `citytransport_umsatz_personal`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `umsatz_personal` (`umsatz_id`,`personal_id`);

--
-- Indizes für die Tabelle `citytransport_umzugsgut_items`
--
ALTER TABLE `citytransport_umzugsgut_items`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `citytransport_umzugsgut_list_items`
--
ALTER TABLE `citytransport_umzugsgut_list_items`
  ADD PRIMARY KEY (`offerte_id`,`item_id`);

--
-- Indizes für die Tabelle `citytransport_umzugskosten`
--
ALTER TABLE `citytransport_umzugskosten`
  ADD PRIMARY KEY (`ID`),
  ADD UNIQUE KEY `UmzugDatum` (`UmzugDatum`);

--
-- Indizes für die Tabelle `citytransport_verpackungsmaterial`
--
ALTER TABLE `citytransport_verpackungsmaterial`
  ADD PRIMARY KEY (`ID`);

--
-- Indizes für die Tabelle `citytransport_verpackungsmaterial_160309`
--
ALTER TABLE `citytransport_verpackungsmaterial_160309`
  ADD PRIMARY KEY (`ID`);

--
-- Indizes für die Tabelle `contact`
--
ALTER TABLE `contact`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `content`
--
ALTER TABLE `content`
  ADD PRIMARY KEY (`id`),
  ADD KEY `content_contenttypeid_foreign` (`contentTypeId`);

--
-- Indizes für die Tabelle `contenttype`
--
ALTER TABLE `contenttype`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `emailtemplates`
--
ALTER TABLE `emailtemplates`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `faq`
--
ALTER TABLE `faq`
  ADD PRIMARY KEY (`id`),
  ADD KEY `faq_faqcatid_foreign` (`faqCatId`);

--
-- Indizes für die Tabelle `faqcategory`
--
ALTER TABLE `faqcategory`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `Mailcontent_Zueri`
--
ALTER TABLE `Mailcontent_Zueri`
  ADD PRIMARY KEY (`ID`);

--
-- Indizes für die Tabelle `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);
--
-- AUTO_INCREMENT für Tabelle `category`
--
ALTER TABLE `category`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT für Tabelle `citytransport`
--
ALTER TABLE `citytransport`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=188;
--
-- AUTO_INCREMENT für Tabelle `citytransport_auspackservice`
--
ALTER TABLE `citytransport_auspackservice`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=187;
--
-- AUTO_INCREMENT für Tabelle `citytransport_besichtigung`
--
ALTER TABLE `citytransport_besichtigung`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=101;
--
-- AUTO_INCREMENT für Tabelle `citytransport_bestaetigung`
--
ALTER TABLE `citytransport_bestaetigung`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT für Tabelle `citytransport_bestaetigung_160830`
--
ALTER TABLE `citytransport_bestaetigung_160830`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT für Tabelle `citytransport_brocki`
--
ALTER TABLE `citytransport_brocki`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT für Tabelle `citytransport_entsorgung`
--
ALTER TABLE `citytransport_entsorgung`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=188;
--
-- AUTO_INCREMENT für Tabelle `citytransport_lagerung`
--
ALTER TABLE `citytransport_lagerung`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=188;
--
-- AUTO_INCREMENT für Tabelle `citytransport_lohnabrechnung`
--
ALTER TABLE `citytransport_lohnabrechnung`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT für Tabelle `citytransport_mitarbeiter`
--
ALTER TABLE `citytransport_mitarbeiter`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT für Tabelle `citytransport_monatlohn`
--
ALTER TABLE `citytransport_monatlohn`
  MODIFY `ID` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
--
-- AUTO_INCREMENT für Tabelle `citytransport_packservice`
--
ALTER TABLE `citytransport_packservice`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=187;
--
-- AUTO_INCREMENT für Tabelle `citytransport_personal`
--
ALTER TABLE `citytransport_personal`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT für Tabelle `citytransport_quittung`
--
ALTER TABLE `citytransport_quittung`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT für Tabelle `citytransport_rechnung`
--
ALTER TABLE `citytransport_rechnung`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
--
-- AUTO_INCREMENT für Tabelle `citytransport_reinigung`
--
ALTER TABLE `citytransport_reinigung`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=188;
--
-- AUTO_INCREMENT für Tabelle `citytransport_sicher_160223`
--
ALTER TABLE `citytransport_sicher_160223`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT für Tabelle `citytransport_smsworkers`
--
ALTER TABLE `citytransport_smsworkers`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT für Tabelle `citytransport_stundenlohn`
--
ALTER TABLE `citytransport_stundenlohn`
  MODIFY `ID` int(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT für Tabelle `citytransport_umsatz`
--
ALTER TABLE `citytransport_umsatz`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT für Tabelle `citytransport_umsatz_personal`
--
ALTER TABLE `citytransport_umsatz_personal`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT für Tabelle `citytransport_umzugsgut_items`
--
ALTER TABLE `citytransport_umzugsgut_items`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=185;
--
-- AUTO_INCREMENT für Tabelle `citytransport_umzugskosten`
--
ALTER TABLE `citytransport_umzugskosten`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT für Tabelle `citytransport_verpackungsmaterial`
--
ALTER TABLE `citytransport_verpackungsmaterial`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=188;
--
-- AUTO_INCREMENT für Tabelle `citytransport_verpackungsmaterial_160309`
--
ALTER TABLE `citytransport_verpackungsmaterial_160309`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT für Tabelle `contact`
--
ALTER TABLE `contact`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT für Tabelle `content`
--
ALTER TABLE `content`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT für Tabelle `contenttype`
--
ALTER TABLE `contenttype`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT für Tabelle `emailtemplates`
--
ALTER TABLE `emailtemplates`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT für Tabelle `faq`
--
ALTER TABLE `faq`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT für Tabelle `faqcategory`
--
ALTER TABLE `faqcategory`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT für Tabelle `Mailcontent_Zueri`
--
ALTER TABLE `Mailcontent_Zueri`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT für Tabelle `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;
--
-- Constraints der exportierten Tabellen
--

--
-- Constraints der Tabelle `content`
--
ALTER TABLE `content`
  ADD CONSTRAINT `content_contenttypeid_foreign` FOREIGN KEY (`contentTypeId`) REFERENCES `contenttype` (`id`);

--
-- Constraints der Tabelle `faq`
--
ALTER TABLE `faq`
  ADD CONSTRAINT `faq_faqcatid_foreign` FOREIGN KEY (`faqCatId`) REFERENCES `faq` (`id`);

