-- phpMyAdmin SQL Dump
-- version 4.1.14
-- http://www.phpmyadmin.net
--
-- Client : 127.0.0.1
-- Généré le : Mer 07 Janvier 2017 à 12:09
-- Version du serveur : 5.6.17
-- Version de PHP : 5.5.12
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Base de données : `covoiturag_db`
--
CREATE SCHEMA IF NOT EXISTS `covoiturag_db` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
USE `covoiturag_db` ;
-- -----------------------------------------------------
-- Création utilisateur
-- -----------------------------------------------------
GRANT ALL ON `covoiturag_db`.* to 'username'@'localhost' identified by 'password';
-- --------------------------------------------------------
--
-- Structure de la table `badges`
--
CREATE TABLE IF NOT EXISTS `badges` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(90) DEFAULT NULL,
`picture` varchar(90) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structure de la table `comments`
--
CREATE TABLE IF NOT EXISTS `comments` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`author_fk` int(11) DEFAULT NULL,
`ride_fk` int(11) NOT NULL,
`date` datetime DEFAULT NULL,
`comment` text,
PRIMARY KEY (`id`),
KEY `fk_comments_users1_idx` (`author_fk`),
KEY `fk_comments_rides1_idx` (`ride_fk`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structure de la table `holidays`
--
CREATE TABLE IF NOT EXISTS `holidays` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(45) DEFAULT NULL,
`begin` date DEFAULT NULL,
`end` date DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structure de la table `registrations`
--
CREATE TABLE IF NOT EXISTS `registrations` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_fk` int(11) NOT NULL,
`ride_fk` int(11) NOT NULL,
`date` date DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `fk_users_has_rides_rides1_idx` (`ride_fk`),
KEY `fk_users_has_rides_users1_idx` (`user_fk`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=501 ;
--
-- Contenu de la table `registrations`
--
INSERT INTO `registrations` (`id`, `user_fk`, `ride_fk`, `date`) VALUES
(1, 10, 107, '2017-03-05'),
(2, 76, 199, '2017-03-02'),
(3, 1, 53, '2017-03-02'),
(4, 44, 103, '2017-03-05'),
(5, 51, 163, '2017-03-05'),
(6, 97, 98, '2017-03-02'),
(7, 78, 5, '2017-03-04'),
(8, 45, 179, '2017-03-05'),
(9, 94, 18, '2017-03-03'),
(10, 100, 23, '2017-03-04'),
(11, 96, 86, '2017-03-03'),
(12, 38, 17, '2017-03-02'),
(13, 18, 114, '2017-03-04'),
(14, 57, 26, '2017-03-04'),
(15, 101, 139, '2017-03-02'),
(16, 43, 75, '2017-03-03'),
(17, 73, 99, '2017-03-03'),
(18, 97, 181, '2017-03-02'),
(19, 58, 30, '2017-03-04'),
(20, 83, 117, '2017-03-03'),
(21, 8, 79, '2017-03-03'),
(22, 38, 148, '2017-03-02'),
(23, 101, 134, '2017-03-03'),
(24, 29, 101, '2017-03-02'),
(25, 6, 148, '2017-03-04'),
(26, 39, 190, '2017-03-04'),
(27, 58, 149, '2017-03-04'),
(28, 33, 31, '2017-03-03'),
(29, 53, 156, '2017-03-05'),
(30, 8, 118, '2017-03-04'),
(31, 30, 147, '2017-03-03'),
(32, 95, 185, '2017-03-02'),
(33, 72, 131, '2017-03-02'),
(34, 24, 50, '2017-03-02'),
(35, 42, 190, '2017-03-04'),
(36, 77, 60, '2017-03-02'),
(37, 36, 29, '2017-03-05'),
(38, 73, 200, '2017-03-04'),
(39, 7, 25, '2017-03-04'),
(40, 79, 34, '2017-03-04'),
(41, 72, 74, '2017-03-03'),
(42, 93, 44, '2017-03-05'),
(43, 37, 110, '2017-03-04'),
(44, 88, 180, '2017-03-02'),
(45, 84, 83, '2017-03-03'),
(46, 6, 55, '2017-03-02'),
(47, 14, 125, '2017-03-05'),
(48, 86, 16, '2017-03-04'),
(49, 28, 176, '2017-03-03'),
(50, 54, 72, '2017-03-03'),
(51, 45, 26, '2017-03-05'),
(52, 15, 138, '2017-03-05'),
(53, 91, 32, '2017-03-04'),
(54, 4, 121, '2017-03-04'),
(55, 9, 10, '2017-03-02'),
(56, 20, 133, '2017-03-03'),
(57, 72, 183, '2017-03-03'),
(58, 47, 155, '2017-03-05'),
(59, 65, 93, '2017-03-02'),
(60, 5, 39, '2017-03-02'),
(61, 57, 195, '2017-03-05'),
(62, 60, 128, '2017-03-02'),
(63, 86, 56, '2017-03-04'),
(64, 59, 68, '2017-03-03'),
(65, 48, 98, '2017-03-05'),
(66, 26, 73, '2017-03-05'),
(67, 4, 111, '2017-03-04'),
(68, 8, 82, '2017-03-03'),
(69, 56, 187, '2017-03-05'),
(70, 7, 167, '2017-03-03'),
(71, 94, 23, '2017-03-03'),
(72, 38, 13, '2017-03-04'),
(73, 78, 5, '2017-03-05'),
(74, 47, 150, '2017-03-05'),
(75, 93, 176, '2017-03-02'),
(76, 77, 132, '2017-03-03'),
(77, 58, 1, '2017-03-04'),
(78, 73, 13, '2017-03-05'),
(79, 33, 200, '2017-03-05'),
(80, 69, 188, '2017-03-04'),
(81, 73, 116, '2017-03-03'),
(82, 4, 111, '2017-03-03'),
(83, 58, 169, '2017-03-05'),
(84, 33, 91, '2017-03-03'),
(85, 43, 32, '2017-03-05'),
(86, 29, 97, '2017-03-05'),
(87, 9, 137, '2017-03-02'),
(88, 68, 16, '2017-03-03'),
(89, 98, 53, '2017-03-03'),
(90, 60, 153, '2017-03-04'),
(91, 81, 163, '2017-03-03'),
(92, 63, 118, '2017-03-05'),
(93, 84, 47, '2017-03-03'),
(94, 21, 157, '2017-03-05'),
(95, 91, 87, '2017-03-02'),
(96, 89, 41, '2017-03-04'),
(97, 73, 9, '2017-03-03'),
(98, 87, 20, '2017-03-05'),
(99, 10, 1, '2017-03-02'),
(100, 65, 115, '2017-03-04'),
(101, 99, 7, '2017-03-05'),
(102, 97, 156, '2017-03-04'),
(103, 23, 175, '2017-03-05'),
(104, 20, 32, '2017-03-03'),
(105, 77, 48, '2017-03-03'),
(106, 95, 11, '2017-03-04'),
(107, 47, 146, '2017-03-03'),
(108, 44, 171, '2017-03-04'),
(109, 5, 84, '2017-03-05'),
(110, 86, 103, '2017-03-03'),
(111, 40, 191, '2017-03-04'),
(112, 31, 5, '2017-03-03'),
(113, 48, 111, '2017-03-04'),
(114, 40, 42, '2017-03-05'),
(115, 89, 160, '2017-03-04'),
(116, 74, 124, '2017-03-02'),
(117, 56, 200, '2017-03-02'),
(118, 29, 150, '2017-03-04'),
(119, 40, 122, '2017-03-05'),
(120, 64, 182, '2017-03-02'),
(121, 100, 170, '2017-03-04'),
(122, 57, 154, '2017-03-04'),
(123, 102, 62, '2017-03-03'),
(124, 72, 18, '2017-03-03'),
(125, 63, 41, '2017-03-05'),
(126, 63, 62, '2017-03-03'),
(127, 92, 86, '2017-03-02'),
(128, 95, 77, '2017-03-02'),
(129, 30, 182, '2017-03-04'),
(130, 19, 77, '2017-03-04'),
(131, 102, 27, '2017-03-02'),
(132, 102, 72, '2017-03-02'),
(133, 46, 16, '2017-03-02'),
(134, 26, 74, '2017-03-05'),
(135, 43, 200, '2017-03-02'),
(136, 13, 194, '2017-03-02'),
(137, 22, 62, '2017-03-04'),
(138, 101, 50, '2017-03-05'),
(139, 38, 174, '2017-03-03'),
(140, 12, 119, '2017-03-04'),
(141, 28, 68, '2017-03-05'),
(142, 67, 22, '2017-03-05'),
(143, 62, 23, '2017-03-04'),
(144, 97, 4, '2017-03-03'),
(145, 9, 4, '2017-03-02'),
(146, 90, 19, '2017-03-05'),
(147, 1, 37, '2017-03-02'),
(148, 15, 99, '2017-03-05'),
(149, 70, 187, '2017-03-03'),
(150, 76, 12, '2017-03-04'),
(151, 95, 112, '2017-03-02'),
(152, 61, 199, '2017-03-05'),
(153, 27, 83, '2017-03-05'),
(154, 92, 95, '2017-03-03'),
(155, 85, 115, '2017-03-03'),
(156, 80, 200, '2017-03-05'),
(157, 99, 4, '2017-03-03'),
(158, 59, 103, '2017-03-02'),
(159, 70, 51, '2017-03-05'),
(160, 2, 106, '2017-03-02'),
(161, 80, 166, '2017-03-04'),
(162, 69, 80, '2017-03-02'),
(163, 5, 187, '2017-03-02'),
(164, 68, 84, '2017-03-04'),
(165, 1, 110, '2017-03-05'),
(166, 14, 188, '2017-03-05'),
(167, 81, 148, '2017-03-03'),
(168, 27, 133, '2017-03-02'),
(169, 70, 56, '2017-03-04'),
(170, 54, 98, '2017-03-03'),
(171, 5, 171, '2017-03-05'),
(172, 22, 190, '2017-03-05'),
(173, 84, 95, '2017-03-05'),
(174, 24, 57, '2017-03-04'),
(175, 45, 106, '2017-03-04'),
(176, 81, 186, '2017-03-05'),
(177, 29, 184, '2017-03-02'),
(178, 21, 77, '2017-03-02'),
(179, 101, 27, '2017-03-04'),
(180, 10, 199, '2017-03-03'),
(181, 47, 200, '2017-03-04'),
(182, 16, 118, '2017-03-04'),
(183, 69, 183, '2017-03-04'),
(184, 47, 70, '2017-03-02'),
(185, 71, 95, '2017-03-05'),
(186, 64, 6, '2017-03-05'),
(187, 41, 134, '2017-03-04'),
(188, 76, 148, '2017-03-05'),
(189, 62, 30, '2017-03-04'),
(190, 47, 25, '2017-03-04'),
(191, 11, 92, '2017-03-04'),
(192, 50, 51, '2017-03-04'),
(193, 6, 116, '2017-03-03'),
(194, 8, 173, '2017-03-03'),
(195, 92, 162, '2017-03-03'),
(196, 21, 77, '2017-03-03'),
(197, 23, 13, '2017-03-05'),
(198, 82, 112, '2017-03-02'),
(199, 98, 160, '2017-03-04'),
(200, 71, 163, '2017-03-03'),
(201, 40, 162, '2017-03-03'),
(202, 2, 196, '2017-03-05'),
(203, 67, 192, '2017-03-02'),
(204, 90, 192, '2017-03-05'),
(205, 45, 163, '2017-03-05'),
(206, 16, 47, '2017-03-05'),
(207, 37, 172, '2017-03-02'),
(208, 59, 185, '2017-03-03'),
(209, 56, 130, '2017-03-02'),
(210, 87, 32, '2017-03-05'),
(211, 94, 143, '2017-03-05'),
(212, 92, 185, '2017-03-04'),
(213, 53, 93, '2017-03-02'),
(214, 23, 178, '2017-03-04'),
(215, 41, 172, '2017-03-04'),
(216, 94, 11, '2017-03-04'),
(217, 44, 167, '2017-03-03'),
(218, 87, 60, '2017-03-05'),
(219, 95, 154, '2017-03-02'),
(220, 32, 2, '2017-03-02'),
(221, 73, 180, '2017-03-05'),
(222, 76, 146, '2017-03-02'),
(223, 45, 119, '2017-03-02'),
(224, 98, 30, '2017-03-02'),
(225, 62, 16, '2017-03-05'),
(226, 7, 163, '2017-03-03'),
(227, 93, 138, '2017-03-05'),
(228, 42, 34, '2017-03-03'),
(229, 90, 38, '2017-03-05'),
(230, 6, 185, '2017-03-05'),
(231, 35, 145, '2017-03-03'),
(232, 2, 138, '2017-03-03'),
(233, 11, 158, '2017-03-04'),
(234, 35, 18, '2017-03-05'),
(235, 7, 23, '2017-03-04'),
(236, 88, 193, '2017-03-05'),
(237, 11, 67, '2017-03-02'),
(238, 30, 98, '2017-03-05'),
(239, 7, 77, '2017-03-04'),
(240, 62, 154, '2017-03-05'),
(241, 81, 74, '2017-03-05'),
(242, 96, 198, '2017-03-03'),
(243, 101, 27, '2017-03-05'),
(244, 7, 178, '2017-03-04'),
(245, 90, 11, '2017-03-02'),
(246, 60, 90, '2017-03-03'),
(247, 89, 111, '2017-03-03'),
(248, 38, 51, '2017-03-03'),
(249, 26, 199, '2017-03-05'),
(250, 8, 82, '2017-03-02'),
(251, 15, 154, '2017-03-02'),
(252, 79, 150, '2017-03-04'),
(253, 25, 5, '2017-03-03'),
(254, 88, 54, '2017-03-03'),
(255, 4, 178, '2017-03-04'),
(256, 26, 101, '2017-03-02'),
(257, 25, 140, '2017-03-02'),
(258, 67, 157, '2017-03-02'),
(259, 30, 170, '2017-03-04'),
(260, 34, 5, '2017-03-02'),
(261, 96, 93, '2017-03-03'),
(262, 1, 161, '2017-03-02'),
(263, 97, 14, '2017-03-02'),
(264, 78, 93, '2017-03-02'),
(265, 70, 39, '2017-03-04'),
(266, 70, 193, '2017-03-05'),
(267, 36, 181, '2017-03-02'),
(268, 47, 52, '2017-03-03'),
(269, 4, 136, '2017-03-05'),
(270, 44, 23, '2017-03-03'),
(271, 18, 153, '2017-03-04'),
(272, 95, 133, '2017-03-04'),
(273, 42, 107, '2017-03-05'),
(274, 35, 65, '2017-03-02'),
(275, 69, 164, '2017-03-02'),
(276, 8, 35, '2017-03-02'),
(277, 72, 51, '2017-03-03'),
(278, 12, 115, '2017-03-04'),
(279, 74, 182, '2017-03-02'),
(280, 75, 186, '2017-03-02'),
(281, 84, 9, '2017-03-04'),
(282, 5, 63, '2017-03-04'),
(283, 66, 67, '2017-03-02'),
(284, 68, 20, '2017-03-05'),
(285, 24, 181, '2017-03-04'),
(286, 70, 88, '2017-03-05'),
(287, 92, 117, '2017-03-04'),
(288, 9, 107, '2017-03-04'),
(289, 52, 73, '2017-03-03'),
(290, 32, 17, '2017-03-05'),
(291, 1, 89, '2017-03-05'),
(292, 68, 184, '2017-03-04'),
(293, 7, 155, '2017-03-02'),
(294, 25, 128, '2017-03-04'),
(295, 6, 153, '2017-03-04'),
(296, 75, 5, '2017-03-02'),
(297, 77, 178, '2017-03-03'),
(298, 64, 22, '2017-03-05'),
(299, 91, 200, '2017-03-03'),
(300, 51, 196, '2017-03-02'),
(301, 21, 8, '2017-03-05'),
(302, 15, 120, '2017-03-04'),
(303, 56, 192, '2017-03-04'),
(304, 61, 112, '2017-03-03'),
(305, 67, 26, '2017-03-05'),
(306, 73, 30, '2017-03-04'),
(307, 12, 5, '2017-03-03'),
(308, 68, 18, '2017-03-04'),
(309, 57, 115, '2017-03-03'),
(310, 60, 127, '2017-03-04'),
(311, 60, 193, '2017-03-02'),
(312, 50, 177, '2017-03-05'),
(313, 11, 107, '2017-03-03'),
(314, 11, 37, '2017-03-03'),
(315, 43, 82, '2017-03-04'),
(316, 61, 90, '2017-03-03'),
(317, 67, 13, '2017-03-04'),
(318, 100, 183, '2017-03-04'),
(319, 60, 146, '2017-03-05'),
(320, 69, 46, '2017-03-04'),
(321, 21, 17, '2017-03-02'),
(322, 61, 59, '2017-03-05'),
(323, 73, 122, '2017-03-04'),
(324, 98, 90, '2017-03-05'),
(325, 10, 197, '2017-03-04'),
(326, 66, 101, '2017-03-03'),
(327, 61, 103, '2017-03-05'),
(328, 4, 148, '2017-03-05'),
(329, 86, 169, '2017-03-05'),
(330, 65, 90, '2017-03-05'),
(331, 81, 126, '2017-03-03'),
(332, 55, 30, '2017-03-02'),
(333, 44, 130, '2017-03-03'),
(334, 38, 80, '2017-03-02'),
(335, 90, 26, '2017-03-02'),
(336, 75, 154, '2017-03-05'),
(337, 48, 172, '2017-03-03'),
(338, 12, 38, '2017-03-02'),
(339, 16, 193, '2017-03-04'),
(340, 80, 59, '2017-03-05'),
(341, 44, 6, '2017-03-03'),
(342, 76, 93, '2017-03-04'),
(343, 53, 115, '2017-03-02'),
(344, 50, 179, '2017-03-04'),
(345, 37, 96, '2017-03-05'),
(346, 26, 89, '2017-03-05'),
(347, 43, 156, '2017-03-03'),
(348, 7, 194, '2017-03-03'),
(349, 58, 167, '2017-03-03'),
(350, 90, 95, '2017-03-04'),
(351, 71, 2, '2017-03-04'),
(352, 35, 69, '2017-03-02'),
(353, 73, 49, '2017-03-04'),
(354, 95, 172, '2017-03-04'),
(355, 72, 59, '2017-03-03'),
(356, 21, 36, '2017-03-05'),
(357, 59, 23, '2017-03-03'),
(358, 26, 109, '2017-03-05'),
(359, 8, 132, '2017-03-05'),
(360, 60, 114, '2017-03-03'),
(361, 55, 110, '2017-03-02'),
(362, 102, 104, '2017-03-05'),
(363, 53, 91, '2017-03-04'),
(364, 21, 35, '2017-03-05'),
(365, 77, 155, '2017-03-03'),
(366, 45, 4, '2017-03-02'),
(367, 44, 34, '2017-03-02'),
(368, 35, 70, '2017-03-03'),
(369, 25, 180, '2017-03-03'),
(370, 3, 112, '2017-03-03'),
(371, 74, 59, '2017-03-03'),
(372, 95, 181, '2017-03-02'),
(373, 19, 154, '2017-03-03'),
(374, 75, 186, '2017-03-05'),
(375, 99, 98, '2017-03-03'),
(376, 67, 100, '2017-03-05'),
(377, 101, 163, '2017-03-05'),
(378, 50, 17, '2017-03-05'),
(379, 53, 130, '2017-03-04'),
(380, 65, 6, '2017-03-05'),
(381, 2, 194, '2017-03-04'),
(382, 82, 137, '2017-03-03'),
(383, 6, 118, '2017-03-05'),
(384, 100, 179, '2017-03-04'),
(385, 17, 96, '2017-03-04'),
(386, 70, 129, '2017-03-02'),
(387, 76, 187, '2017-03-04'),
(388, 26, 105, '2017-03-03'),
(389, 88, 35, '2017-03-04'),
(390, 7, 144, '2017-03-03'),
(391, 56, 37, '2017-03-05'),
(392, 55, 170, '2017-03-04'),
(393, 33, 156, '2017-03-05'),
(394, 71, 115, '2017-03-02'),
(395, 96, 19, '2017-03-03'),
(396, 61, 87, '2017-03-04'),
(397, 42, 32, '2017-03-02'),
(398, 13, 43, '2017-03-02'),
(399, 57, 97, '2017-03-03'),
(400, 25, 41, '2017-03-02'),
(401, 84, 143, '2017-03-03'),
(402, 36, 180, '2017-03-04'),
(403, 26, 111, '2017-03-02'),
(404, 58, 124, '2017-03-02'),
(405, 40, 160, '2017-03-05'),
(406, 63, 79, '2017-03-05'),
(407, 100, 10, '2017-03-02'),
(408, 10, 103, '2017-03-03'),
(409, 31, 57, '2017-03-05'),
(410, 65, 198, '2017-03-04'),
(411, 80, 148, '2017-03-03'),
(412, 36, 86, '2017-03-05'),
(413, 22, 72, '2017-03-04'),
(414, 9, 81, '2017-03-03'),
(415, 37, 53, '2017-03-05'),
(416, 61, 90, '2017-03-05'),
(417, 6, 132, '2017-03-03'),
(418, 98, 118, '2017-03-03'),
(419, 29, 92, '2017-03-02'),
(420, 10, 49, '2017-03-02'),
(421, 47, 56, '2017-03-04'),
(422, 7, 175, '2017-03-04'),
(423, 67, 194, '2017-03-04'),
(424, 51, 44, '2017-03-03'),
(425, 61, 112, '2017-03-02'),
(426, 88, 174, '2017-03-05'),
(427, 53, 10, '2017-03-03'),
(428, 70, 32, '2017-03-04'),
(429, 16, 153, '2017-03-05'),
(430, 46, 45, '2017-03-04'),
(431, 54, 53, '2017-03-04'),
(432, 81, 101, '2017-03-02'),
(433, 15, 104, '2017-03-05'),
(434, 24, 124, '2017-03-04'),
(435, 16, 8, '2017-03-03'),
(436, 53, 176, '2017-03-04'),
(437, 72, 84, '2017-03-05'),
(438, 29, 119, '2017-03-02'),
(439, 27, 94, '2017-03-03'),
(440, 25, 31, '2017-03-05'),
(441, 97, 70, '2017-03-05'),
(442, 54, 169, '2017-03-02'),
(443, 98, 141, '2017-03-04'),
(444, 45, 120, '2017-03-02'),
(445, 22, 31, '2017-03-02'),
(446, 48, 21, '2017-03-03'),
(447, 71, 41, '2017-03-05'),
(448, 101, 185, '2017-03-04'),
(449, 88, 164, '2017-03-04'),
(450, 93, 132, '2017-03-05'),
(451, 42, 191, '2017-03-02'),
(452, 100, 89, '2017-03-03'),
(453, 59, 128, '2017-03-05'),
(454, 83, 183, '2017-03-05'),
(455, 73, 163, '2017-03-03'),
(456, 46, 178, '2017-03-02'),
(457, 69, 111, '2017-03-04'),
(458, 44, 175, '2017-03-05'),
(459, 51, 25, '2017-03-02'),
(460, 80, 111, '2017-03-05'),
(461, 101, 48, '2017-03-05'),
(462, 56, 115, '2017-03-03'),
(463, 59, 74, '2017-03-03'),
(464, 51, 41, '2017-03-05'),
(465, 95, 135, '2017-03-03'),
(466, 4, 137, '2017-03-03'),
(467, 10, 162, '2017-03-03'),
(468, 38, 147, '2017-03-02'),
(469, 31, 1, '2017-03-03'),
(470, 36, 69, '2017-03-02'),
(471, 91, 52, '2017-03-05'),
(472, 90, 124, '2017-03-04'),
(473, 68, 37, '2017-03-02'),
(474, 91, 168, '2017-03-03'),
(475, 3, 42, '2017-03-04'),
(476, 53, 95, '2017-03-05'),
(477, 55, 65, '2017-03-04'),
(478, 1, 128, '2017-03-02'),
(479, 45, 25, '2017-03-05'),
(480, 99, 142, '2017-03-02'),
(481, 64, 168, '2017-03-03'),
(482, 102, 32, '2017-03-03'),
(483, 101, 180, '2017-03-05'),
(484, 27, 18, '2017-03-04'),
(485, 68, 87, '2017-03-05'),
(486, 27, 143, '2017-03-04'),
(487, 100, 82, '2017-03-03'),
(488, 49, 70, '2017-03-04'),
(489, 44, 93, '2017-03-02'),
(490, 1, 61, '2017-03-05'),
(491, 16, 36, '2017-03-02'),
(492, 39, 9, '2017-03-04'),
(493, 32, 131, '2017-03-04'),
(494, 15, 102, '2017-03-02'),
(495, 6, 62, '2017-03-03'),
(496, 98, 123, '2017-03-02'),
(497, 86, 172, '2017-03-02'),
(498, 79, 73, '2017-03-03'),
(499, 31, 91, '2017-03-04'),
(500, 60, 50, '2017-03-03');
-- --------------------------------------------------------
--
-- Structure de la table `ridebadges`
--
CREATE TABLE IF NOT EXISTS `ridebadges` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ride_fk` int(11) NOT NULL,
`badge_fk` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `fk_rides_has_badges_badges1_idx` (`badge_fk`),
KEY `fk_rides_has_badges_rides1_idx` (`ride_fk`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structure de la table `rides`
--
CREATE TABLE IF NOT EXISTS `rides` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`driver_fk` int(11) NOT NULL,
`departuretown_fk` int(11) NOT NULL,
`arrivaltown_fk` int(11) NOT NULL,
`description` text,
`departure` datetime DEFAULT NULL,
`arrival` datetime DEFAULT NULL,
`seats` int(11) DEFAULT NULL,
`startDate` datetime DEFAULT NULL,
`endDate` datetime DEFAULT NULL,
`monday` tinyint(1) DEFAULT NULL,
`tuesday` tinyint(1) DEFAULT NULL,
`wednesday` tinyint(1) DEFAULT NULL,
`thursday` tinyint(1) DEFAULT NULL,
`friday` tinyint(1) DEFAULT NULL,
`saturday` tinyint(1) DEFAULT NULL,
`sunday` tinyint(1) DEFAULT NULL,
`visibility` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `fk_rides_towns1_idx` (`departuretown_fk`),
KEY `fk_rides_towns2_idx` (`arrivaltown_fk`),
KEY `fk_rides_users1_idx` (`driver_fk`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=201 ;
--
-- Contenu de la table `rides`
--
INSERT INTO `rides` (`id`, `driver_fk`, `departuretown_fk`, `arrivaltown_fk`, `description`, `departure`, `arrival`, `seats`, `startDate`, `endDate`, `monday`, `tuesday`, `wednesday`, `thursday`, `friday`, `saturday`, `sunday`, `visibility`) VALUES
(1, 78, 1610, 2016, 'luctus ut, pellentesque eget, dictum placerat, augue. Sed molestie. Sed', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 4, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 0, 1, 1, 0, 0, 1),
(2, 51, 1655, 320, 'sit amet ante. Vivamus non lorem vitae odio sagittis semper.', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 3, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 1, 1, 0, 0, 1, 1, 1),
(3, 48, 625, 2120, 'nunc interdum feugiat. Sed nec metus facilisis lorem tristique aliquet.', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 4, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 0, 0, 0, 0, 0, 1, 1),
(4, 79, 681, 543, 'erat, eget tincidunt dui augue eu tellus. Phasellus elit pede,', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 4, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 1, 0, 1, 0, 0, 1),
(5, 91, 1738, 2148, 'purus. Duis elementum, dui quis accumsan convallis, ante lectus convallis', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 0, 1, 0, 1, 0, 1),
(6, 22, 1074, 85, 'Aliquam erat volutpat. Nulla facilisis. Suspendisse commodo tincidunt nibh. Phasellus', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 1, 0, 1, 1, 0, 1),
(7, 48, 1887, 1432, 'ipsum sodales purus, in molestie tortor nibh sit amet orci.', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 3, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 1, 1, 0, 1, 1, 1),
(8, 1, 1724, 1397, 'fermentum risus, at fringilla purus mauris a nunc. In at', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 1, 1, 0, 1, 1, 0, 1),
(9, 66, 1414, 1763, 'eget, volutpat ornare, facilisis eget, ipsum. Donec sollicitudin adipiscing ligula.', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 0, 0, 1, 1, 1, 1),
(10, 93, 1744, 2132, 'Maecenas libero est, congue a, aliquet vel, vulputate eu, odio.', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 1, 1, 0, 0, 1, 1, 1),
(11, 90, 1096, 2174, 'hendrerit neque. In ornare sagittis felis. Donec tempor, est ac', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 3, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 1, 0, 0, 1, 0, 1),
(12, 38, 1427, 491, 'Suspendisse aliquet molestie tellus. Aenean egestas hendrerit neque. In ornare', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 1, 1, 0, 0, 1, 1),
(13, 8, 1741, 9, 'Vivamus rhoncus. Donec est. Nunc ullamcorper, velit in aliquet lobortis,', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 0, 0, 0, 0, 0, 1),
(14, 14, 1881, 786, 'Donec vitae erat vel pede blandit congue. In scelerisque scelerisque', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 0, 0, 1, 1, 0, 1, 1),
(15, 57, 309, 1589, 'euismod est arcu ac orci. Ut semper pretium neque. Morbi', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 0, 0, 1, 1, 1, 1),
(16, 42, 1578, 1442, 'In condimentum. Donec at arcu. Vestibulum ante ipsum primis in', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 3, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 0, 0, 1, 0, 0, 1),
(17, 94, 1871, 611, 'sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 0, 1, 1, 1, 1, 1, 1),
(18, 80, 1256, 1483, 'ultricies sem magna nec quam. Curabitur vel lectus. Cum sociis', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 4, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 1, 0, 0, 1, 0, 1),
(19, 87, 1529, 1407, 'gravida sit amet, dapibus id, blandit at, nisi. Cum sociis', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 1, 0, 0, 1, 0, 1),
(20, 81, 813, 1615, 'fames ac turpis egestas. Aliquam fringilla cursus purus. Nullam scelerisque', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 4, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 1, 0, 1, 1, 1, 1),
(21, 66, 348, 1047, 'accumsan neque et nunc. Quisque ornare tortor at risus. Nunc', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 0, 1, 0, 1, 0, 0, 1),
(22, 80, 1325, 524, 'Nulla eu neque pellentesque massa lobortis ultrices. Vivamus rhoncus. Donec', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 3, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 1, 1, 1, 0, 0, 1),
(23, 40, 1737, 1189, 'ut odio vel est tempor bibendum. Donec felis orci, adipiscing', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 0, 1, 0, 0, 0, 0, 1),
(24, 74, 119, 1968, 'Nunc mauris sapien, cursus in, hendrerit consectetuer, cursus et, magna.', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 4, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 0, 1, 1, 1, 1, 1, 1),
(25, 93, 148, 1690, 'arcu. Vestibulum ut eros non enim commodo hendrerit. Donec porttitor', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 4, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 1, 1, 1, 0, 1, 1, 1),
(26, 70, 328, 966, 'non, bibendum sed, est. Nunc laoreet lectus quis massa. Mauris', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 4, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 1, 1, 0, 0, 0, 0, 1),
(27, 34, 1568, 495, 'non leo. Vivamus nibh dolor, nonummy ac, feugiat non, lobortis', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 3, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 0, 1, 1, 0, 0, 0, 1),
(28, 23, 1753, 2135, 'magna. Praesent interdum ligula eu enim. Etiam imperdiet dictum magna.', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 1, 0, 0, 1, 0, 0, 1),
(29, 25, 503, 124, 'Mauris molestie pharetra nibh. Aliquam ornare, libero at auctor ullamcorper,', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 3, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 1, 0, 1, 1, 0, 1),
(30, 1, 1079, 1966, 'Phasellus elit pede, malesuada vel, venenatis vel, faucibus id, libero.', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 1, 0, 0, 0, 0, 1),
(31, 86, 2013, 859, 'elit. Etiam laoreet, libero et tristique pellentesque, tellus sem mollis', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 1, 1, 0, 1, 0, 1),
(32, 21, 34, 853, 'Fusce mi lorem, vehicula et, rutrum eu, ultrices sit amet,', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 1, 0, 0, 1, 1, 0, 1),
(33, 61, 1956, 1185, 'ipsum porta elit, a feugiat tellus lorem eu metus. In', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 1, 1, 1, 1, 0, 1, 1),
(34, 64, 1063, 1206, 'a mi fringilla mi lacinia mattis. Integer eu lacus. Quisque', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 1, 0, 1, 1, 0, 1),
(35, 53, 292, 1340, 'pharetra, felis eget varius ultrices, mauris ipsum porta elit, a', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 0, 1, 0, 0, 1, 1, 1),
(36, 22, 1237, 1226, 'ornare. In faucibus. Morbi vehicula. Pellentesque tincidunt tempus risus. Donec', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 1, 1, 1, 1, 0, 0, 1),
(37, 82, 640, 1936, 'nibh vulputate mauris sagittis placerat. Cras dictum ultricies ligula. Nullam', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 1, 1, 1, 1, 1, 1),
(38, 26, 1512, 1498, 'nonummy ipsum non arcu. Vivamus sit amet risus. Donec egestas.', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 0, 0, 0, 0, 1, 1, 1),
(39, 89, 2220, 720, 'lectus, a sollicitudin orci sem eget massa. Suspendisse eleifend. Cras', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 1, 1, 0, 1, 1, 1),
(40, 36, 1441, 281, 'ac urna. Ut tincidunt vehicula risus. Nulla eget metus eu', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 3, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 0, 1, 1, 1, 1, 1),
(41, 11, 274, 314, 'tristique aliquet. Phasellus fermentum convallis ligula. Donec luctus aliquet odio.', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 0, 1, 0, 1, 1, 1),
(42, 96, 1911, 1998, 'pulvinar arcu et pede. Nunc sed orci lobortis augue scelerisque', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 3, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 1, 1, 1, 1, 0, 1, 1),
(43, 26, 1146, 1026, 'laoreet posuere, enim nisl elementum purus, accumsan interdum libero dui', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 4, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 1, 1, 1, 0, 0, 1, 1),
(44, 24, 677, 1111, 'imperdiet dictum magna. Ut tincidunt orci quis lectus. Nullam suscipit,', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 1, 0, 0, 1, 0, 1),
(45, 81, 1244, 2218, 'felis, adipiscing fringilla, porttitor vulputate, posuere vulputate, lacus. Cras interdum.', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 0, 0, 0, 1, 0, 1, 1),
(46, 15, 1272, 96, 'eleifend egestas. Sed pharetra, felis eget varius ultrices, mauris ipsum', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 0, 0, 0, 0, 0, 1),
(47, 97, 1745, 2185, 'ullamcorper, velit in aliquet lobortis, nisi nibh lacinia orci, consectetuer', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 0, 1, 1, 0, 1, 0, 1),
(48, 95, 148, 1547, 'enim consequat purus. Maecenas libero est, congue a, aliquet vel,', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 4, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 0, 1, 0, 0, 0, 1, 1),
(49, 79, 708, 1664, 'sit amet metus. Aliquam erat volutpat. Nulla facilisis. Suspendisse commodo', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 3, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 1, 1, 0, 1, 0, 1),
(50, 58, 2243, 1649, 'faucibus lectus, a sollicitudin orci sem eget massa. Suspendisse eleifend.', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 3, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 1, 1, 0, 0, 0, 1),
(51, 64, 1307, 1196, 'mauris ipsum porta elit, a feugiat tellus lorem eu metus.', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 0, 0, 0, 0, 1, 1),
(52, 60, 890, 1897, 'ut erat. Sed nunc est, mollis non, cursus non, egestas', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 3, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 1, 0, 1, 0, 0, 1, 1),
(53, 92, 2048, 87, 'dolor dapibus gravida. Aliquam tincidunt, nunc ac mattis ornare, lectus', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 0, 1, 1, 1, 1, 0, 1),
(54, 93, 1986, 1409, 'ut dolor dapibus gravida. Aliquam tincidunt, nunc ac mattis ornare,', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 3, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 0, 1, 1, 0, 1, 1),
(55, 64, 2166, 2111, 'lorem ipsum sodales purus, in molestie tortor nibh sit amet', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 4, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 1, 1, 1, 0, 0, 1, 1),
(56, 23, 1764, 1100, 'rutrum eu, ultrices sit amet, risus. Donec nibh enim, gravida', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 1, 1, 1, 1, 0, 1),
(57, 34, 486, 1703, 'Cras dictum ultricies ligula. Nullam enim. Sed nulla ante, iaculis', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 0, 1, 1, 1, 1, 0, 1),
(58, 16, 1180, 1893, 'Vivamus molestie dapibus ligula. Aliquam erat volutpat. Nulla dignissim. Maecenas', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 3, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 1, 0, 1, 1, 1, 1),
(59, 67, 1579, 1814, 'lorem ac risus. Morbi metus. Vivamus euismod urna. Nullam lobortis', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 1, 0, 0, 1, 1, 0, 1),
(60, 47, 1623, 2037, 'viverra. Donec tempus, lorem fringilla ornare placerat, orci lacus vestibulum', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 0, 0, 1, 0, 0, 1),
(61, 40, 492, 1321, 'tristique pharetra. Quisque ac libero nec ligula consectetuer rhoncus. Nullam', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 1, 0, 1, 0, 0, 1),
(62, 55, 1432, 2286, 'Cum sociis natoque penatibus et magnis dis parturient montes, nascetur', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 3, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 0, 0, 1, 0, 0, 1, 1),
(63, 15, 1789, 548, 'adipiscing elit. Etiam laoreet, libero et tristique pellentesque, tellus sem', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 3, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 0, 1, 1, 1, 0, 0, 1),
(64, 47, 920, 1637, 'massa non ante bibendum ullamcorper. Duis cursus, diam at pretium', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 0, 0, 0, 1, 0, 1),
(65, 38, 1579, 204, 'mattis velit justo nec ante. Maecenas mi felis, adipiscing fringilla,', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 1, 1, 0, 1, 1, 0, 1),
(66, 30, 2188, 773, 'rhoncus. Nullam velit dui, semper et, lacinia vitae, sodales at,', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 3, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 1, 1, 0, 1, 1, 0, 1),
(67, 65, 1708, 1238, 'sollicitudin adipiscing ligula. Aenean gravida nunc sed pede. Cum sociis', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 4, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 0, 1, 0, 0, 1, 1),
(68, 47, 851, 2147, 'elit, pellentesque a, facilisis non, bibendum sed, est. Nunc laoreet', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 4, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 0, 1, 1, 1, 1, 1, 1),
(69, 20, 1372, 2004, 'non enim. Mauris quis turpis vitae purus gravida sagittis. Duis', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 0, 0, 1, 1, 0, 1),
(70, 43, 1635, 64, 'sodales at, velit. Pellentesque ultricies dignissim lacus. Aliquam rutrum lorem', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 4, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 1, 0, 1, 0, 0, 1),
(71, 85, 2010, 176, 'ornare. In faucibus. Morbi vehicula. Pellentesque tincidunt tempus risus. Donec', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 1, 1, 1, 0, 0, 1),
(72, 11, 550, 493, 'tempor, est ac mattis semper, dui lectus rutrum urna, nec', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 0, 0, 1, 1, 1, 1),
(73, 10, 1055, 10, 'Nunc lectus pede, ultrices a, auctor non, feugiat nec, diam.', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 0, 0, 1, 0, 0, 1),
(74, 90, 1394, 81, 'Ut nec urna et arcu imperdiet ullamcorper. Duis at lacus.', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 1, 0, 1, 0, 0, 1),
(75, 46, 838, 1245, 'cursus. Integer mollis. Integer tincidunt aliquam arcu. Aliquam ultrices iaculis', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 4, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 1, 0, 1, 1, 1, 1),
(76, 29, 1105, 1733, 'dictum. Phasellus in felis. Nulla tempor augue ac ipsum. Phasellus', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 0, 1, 0, 0, 0, 1),
(77, 15, 2183, 1509, 'dictum augue malesuada malesuada. Integer id magna et ipsum cursus', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 1, 0, 0, 1, 0, 1),
(78, 76, 1940, 2075, 'nec, euismod in, dolor. Fusce feugiat. Lorem ipsum dolor sit', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 3, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 1, 1, 1, 1, 1, 1, 1),
(79, 92, 403, 2087, 'est, congue a, aliquet vel, vulputate eu, odio. Phasellus at', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 4, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 0, 1, 1, 0, 1, 1),
(80, 65, 984, 368, 'Phasellus dapibus quam quis diam. Pellentesque habitant morbi tristique senectus', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 1, 1, 1, 1, 0, 1),
(81, 63, 1559, 2060, 'tempus risus. Donec egestas. Duis ac arcu. Nunc mauris. Morbi', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 0, 0, 1, 0, 0, 1),
(82, 27, 1006, 1553, 'ac arcu. Nunc mauris. Morbi non sapien molestie orci tincidunt', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 3, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 0, 0, 1, 0, 1, 1),
(83, 8, 1635, 1219, 'iaculis odio. Nam interdum enim non nisi. Aenean eget metus.', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 4, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 1, 0, 0, 1, 0, 0, 1),
(84, 54, 32, 1768, 'nulla. Integer urna. Vivamus molestie dapibus ligula. Aliquam erat volutpat.', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 3, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 0, 1, 0, 0, 0, 1, 1),
(85, 50, 1966, 622, 'at sem molestie sodales. Mauris blandit enim consequat purus. Maecenas', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 0, 1, 0, 1, 1, 1),
(86, 33, 990, 1014, 'neque. Nullam ut nisi a odio semper cursus. Integer mollis.', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 0, 1, 1, 0, 1, 1),
(87, 17, 857, 1059, 'Cum sociis natoque penatibus et magnis dis parturient montes, nascetur', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 0, 0, 0, 1, 0, 1),
(88, 51, 481, 60, 'amet, consectetuer adipiscing elit. Etiam laoreet, libero et tristique pellentesque,', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 0, 0, 1, 0, 0, 0, 1),
(89, 85, 1101, 601, 'Ut sagittis lobortis mauris. Suspendisse aliquet molestie tellus. Aenean egestas', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 0, 1, 1, 0, 0, 1),
(90, 100, 1658, 192, 'risus. Nunc ac sem ut dolor dapibus gravida. Aliquam tincidunt,', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 3, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 1, 0, 1, 1, 1, 1),
(91, 96, 366, 1371, 'vel lectus. Cum sociis natoque penatibus et magnis dis parturient', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 1, 0, 0, 1, 1, 1),
(92, 57, 486, 1482, 'sit amet lorem semper auctor. Mauris vel turpis. Aliquam adipiscing', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 1, 0, 1, 0, 0, 0, 1),
(93, 63, 941, 2147, 'libero et tristique pellentesque, tellus sem mollis dui, in sodales', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 4, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 1, 1, 0, 1, 0, 1),
(94, 59, 920, 835, 'vestibulum massa rutrum magna. Cras convallis convallis dolor. Quisque tincidunt', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 3, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 0, 1, 0, 0, 1, 1),
(95, 86, 1160, 2205, 'diam. Pellentesque habitant morbi tristique senectus et netus et malesuada', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 4, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 0, 0, 0, 1, 0, 1),
(96, 8, 745, 2022, 'tempus non, lacinia at, iaculis quis, pede. Praesent eu dui.', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 0, 0, 0, 1, 1, 1, 1),
(97, 25, 991, 2104, 'netus et malesuada fames ac turpis egestas. Aliquam fringilla cursus', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 4, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 0, 0, 0, 0, 1, 0, 1),
(98, 75, 2150, 1122, 'Ut tincidunt orci quis lectus. Nullam suscipit, est ac facilisis', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 0, 1, 0, 1, 0, 1),
(99, 16, 596, 287, 'nascetur ridiculus mus. Proin vel arcu eu odio tristique pharetra.', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 0, 0, 1, 1, 1, 0, 1),
(100, 37, 598, 1311, 'Fusce feugiat. Lorem ipsum dolor sit amet, consectetuer adipiscing elit.', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 1, 0, 1, 0, 1, 1, 1),
(101, 93, 1703, 650, 'mi fringilla mi lacinia mattis. Integer eu lacus. Quisque imperdiet,', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 1, 0, 0, 0, 0, 1),
(102, 84, 996, 1882, 'placerat velit. Quisque varius. Nam porttitor scelerisque neque. Nullam nisl.', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 1, 1, 0, 0, 1, 1),
(103, 57, 283, 62, 'accumsan laoreet ipsum. Curabitur consequat, lectus sit amet luctus vulputate,', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 0, 0, 0, 0, 0, 1, 1),
(104, 62, 428, 1185, 'tempus non, lacinia at, iaculis quis, pede. Praesent eu dui.', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 4, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 1, 0, 0, 1, 0, 0, 1),
(105, 46, 1869, 434, 'eu tellus. Phasellus elit pede, malesuada vel, venenatis vel, faucibus', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 4, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 1, 0, 1, 0, 0, 1),
(106, 6, 1666, 1709, 'leo. Cras vehicula aliquet libero. Integer in magna. Phasellus dolor', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 1, 1, 0, 1, 1, 0, 1),
(107, 83, 1479, 1245, 'morbi tristique senectus et netus et malesuada fames ac turpis', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 3, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 1, 1, 1, 0, 1, 1),
(108, 92, 1581, 1834, 'amet, dapibus id, blandit at, nisi. Cum sociis natoque penatibus', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 1, 0, 0, 1, 1, 1),
(109, 86, 905, 1863, 'interdum feugiat. Sed nec metus facilisis lorem tristique aliquet. Phasellus', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 1, 1, 1, 1, 1, 0, 1),
(110, 24, 1038, 281, 'non enim. Mauris quis turpis vitae purus gravida sagittis. Duis', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 1, 0, 0, 1, 1, 1),
(111, 94, 1136, 253, 'nec metus facilisis lorem tristique aliquet. Phasellus fermentum convallis ligula.', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 0, 0, 0, 1, 1, 1, 1),
(112, 38, 1470, 458, 'nunc sit amet metus. Aliquam erat volutpat. Nulla facilisis. Suspendisse', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 3, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 1, 1, 1, 1, 1, 1, 1),
(113, 38, 2185, 605, 'sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 3, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 1, 0, 1, 1, 1, 1, 1),
(114, 82, 1700, 762, 'consequat dolor vitae dolor. Donec fringilla. Donec feugiat metus sit', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 3, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 1, 0, 0, 1, 1, 1),
(115, 21, 397, 1455, 'malesuada ut, sem. Nulla interdum. Curabitur dictum. Phasellus in felis.', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 1, 0, 0, 1, 1, 1, 1),
(116, 74, 1887, 967, 'Nunc mauris sapien, cursus in, hendrerit consectetuer, cursus et, magna.', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 0, 0, 0, 1, 0, 1),
(117, 89, 1020, 1444, 'nec metus facilisis lorem tristique aliquet. Phasellus fermentum convallis ligula.', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 4, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 0, 1, 0, 1, 0, 0, 1),
(118, 13, 1774, 1971, 'Aliquam nisl. Nulla eu neque pellentesque massa lobortis ultrices. Vivamus', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 3, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 0, 0, 0, 0, 1, 1),
(119, 23, 1095, 1417, 'eu tellus eu augue porttitor interdum. Sed auctor odio a', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 3, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 0, 1, 0, 0, 1, 1, 1),
(120, 80, 1800, 824, 'quis, pede. Praesent eu dui. Cum sociis natoque penatibus et', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 0, 0, 1, 0, 1, 1),
(121, 71, 1104, 630, 'dolor dapibus gravida. Aliquam tincidunt, nunc ac mattis ornare, lectus', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 3, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 0, 0, 1, 0, 1, 1),
(122, 49, 32, 987, 'in faucibus orci luctus et ultrices posuere cubilia Curae; Phasellus', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 4, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 1, 1, 0, 1, 1, 1),
(123, 66, 1286, 2065, 'sed dictum eleifend, nunc risus varius orci, in consequat enim', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 3, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 1, 1, 1, 1, 0, 1, 1),
(124, 100, 929, 1264, 'et, rutrum non, hendrerit id, ante. Nunc mauris sapien, cursus', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 0, 1, 1, 1, 0, 1),
(125, 89, 1354, 1687, 'Vivamus nibh dolor, nonummy ac, feugiat non, lobortis quis, pede.', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 1, 1, 1, 0, 1, 0, 1),
(126, 32, 1257, 1478, 'at risus. Nunc ac sem ut dolor dapibus gravida. Aliquam', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 4, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 0, 0, 1, 0, 1, 1),
(127, 16, 1981, 631, 'fringilla, porttitor vulputate, posuere vulputate, lacus. Cras interdum. Nunc sollicitudin', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 3, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 1, 1, 1, 1, 1, 1),
(128, 76, 1601, 438, 'libero. Proin mi. Aliquam gravida mauris ut mi. Duis risus', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 0, 1, 0, 1, 0, 0, 1),
(129, 44, 2072, 2180, 'consequat, lectus sit amet luctus vulputate, nisi sem semper erat,', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 4, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 0, 0, 1, 1, 0, 1),
(130, 52, 457, 530, 'dictum eleifend, nunc risus varius orci, in consequat enim diam', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 0, 0, 1, 1, 1, 1),
(131, 42, 2144, 458, 'ac tellus. Suspendisse sed dolor. Fusce mi lorem, vehicula et,', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 0, 0, 1, 0, 1, 1, 1),
(132, 34, 493, 682, 'consequat nec, mollis vitae, posuere at, velit. Cras lorem lorem,', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 0, 0, 0, 0, 1, 1, 1),
(133, 4, 944, 1808, 'libero. Integer in magna. Phasellus dolor elit, pellentesque a, facilisis', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 3, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 1, 1, 1, 1, 1, 0, 1),
(134, 23, 1396, 1142, 'aliquet, metus urna convallis erat, eget tincidunt dui augue eu', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 1, 1, 1, 0, 1, 1),
(135, 60, 88, 101, 'rhoncus. Nullam velit dui, semper et, lacinia vitae, sodales at,', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 0, 0, 1, 1, 0, 1, 1),
(136, 22, 510, 1298, 'Aliquam adipiscing lobortis risus. In mi pede, nonummy ut, molestie', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 1, 0, 0, 0, 0, 1),
(137, 14, 1277, 809, 'ipsum. Curabitur consequat, lectus sit amet luctus vulputate, nisi sem', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 1, 0, 0, 1, 0, 0, 1),
(138, 63, 445, 1408, 'Duis at lacus. Quisque purus sapien, gravida non, sollicitudin a,', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 1, 0, 0, 1, 0, 1),
(139, 21, 45, 705, 'lectus. Nullam suscipit, est ac facilisis facilisis, magna tellus faucibus', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 3, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 0, 1, 0, 0, 0, 1),
(140, 38, 545, 1098, 'Curabitur egestas nunc sed libero. Proin sed turpis nec mauris', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 4, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 0, 0, 1, 1, 0, 1),
(141, 61, 2233, 231, 'vel, faucibus id, libero. Donec consectetuer mauris id sapien. Cras', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 1, 1, 1, 0, 1, 0, 1),
(142, 53, 1468, 2252, 'massa. Suspendisse eleifend. Cras sed leo. Cras vehicula aliquet libero.', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 0, 0, 1, 0, 0, 1),
(143, 87, 1711, 405, 'Integer sem elit, pharetra ut, pharetra sed, hendrerit a, arcu.', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 3, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 1, 1, 1, 0, 0, 0, 1),
(144, 20, 1452, 1158, 'a, arcu. Sed et libero. Proin mi. Aliquam gravida mauris', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 4, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 1, 0, 1, 0, 0, 0, 1),
(145, 28, 426, 697, 'ut quam vel sapien imperdiet ornare. In faucibus. Morbi vehicula.', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 0, 0, 0, 1, 0, 1),
(146, 93, 201, 2212, 'urna suscipit nonummy. Fusce fermentum fermentum arcu. Vestibulum ante ipsum', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 4, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 0, 1, 0, 1, 0, 0, 1),
(147, 2, 2283, 239, 'velit eget laoreet posuere, enim nisl elementum purus, accumsan interdum', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 1, 0, 0, 0, 0, 1),
(148, 57, 1708, 789, 'ac libero nec ligula consectetuer rhoncus. Nullam velit dui, semper', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 3, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 1, 1, 1, 1, 1, 1),
(149, 65, 1367, 415, 'tristique ac, eleifend vitae, erat. Vivamus nisi. Mauris nulla. Integer', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 1, 1, 1, 1, 0, 1),
(150, 54, 1591, 2071, 'Vivamus euismod urna. Nullam lobortis quam a felis ullamcorper viverra.', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 3, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 0, 1, 0, 0, 0, 0, 1),
(151, 53, 1717, 309, 'sagittis felis. Donec tempor, est ac mattis semper, dui lectus', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 4, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 0, 0, 0, 0, 0, 1),
(152, 50, 417, 1596, 'Cum sociis natoque penatibus et magnis dis parturient montes, nascetur', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 1, 1, 1, 0, 0, 1),
(153, 60, 568, 294, 'non, vestibulum nec, euismod in, dolor. Fusce feugiat. Lorem ipsum', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 1, 1, 0, 1, 0, 1),
(154, 75, 1385, 2193, 'euismod mauris eu elit. Nulla facilisi. Sed neque. Sed eget', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 3, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 1, 1, 0, 1, 0, 1),
(155, 46, 1003, 2098, 'Quisque imperdiet, erat nonummy ultricies ornare, elit elit fermentum risus,', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 3, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 0, 0, 1, 1, 0, 0, 1),
(156, 92, 1933, 1307, 'velit eget laoreet posuere, enim nisl elementum purus, accumsan interdum', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 4, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 0, 0, 1, 1, 1, 1, 1),
(157, 89, 2068, 481, 'erat. Vivamus nisi. Mauris nulla. Integer urna. Vivamus molestie dapibus', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 3, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 1, 0, 0, 1, 1, 1, 1),
(158, 24, 2195, 1172, 'fringilla cursus purus. Nullam scelerisque neque sed sem egestas blandit.', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 3, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 1, 1, 1, 1, 1, 1),
(159, 79, 2097, 459, 'elit, dictum eu, eleifend nec, malesuada ut, sem. Nulla interdum.', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 0, 0, 1, 1, 1, 1),
(160, 45, 1215, 1344, 'Sed molestie. Sed id risus quis diam luctus lobortis. Class', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 3, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 0, 0, 0, 1, 1, 1),
(161, 27, 375, 2180, 'Pellentesque ultricies dignissim lacus. Aliquam rutrum lorem ac risus. Morbi', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 4, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 0, 1, 0, 1, 0, 0, 1),
(162, 73, 1831, 2084, 'nonummy ultricies ornare, elit elit fermentum risus, at fringilla purus', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 0, 0, 0, 0, 1, 1, 1),
(163, 18, 1527, 1716, 'Integer urna. Vivamus molestie dapibus ligula. Aliquam erat volutpat. Nulla', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 0, 0, 0, 1, 1, 1, 1),
(164, 72, 294, 1717, 'vitae diam. Proin dolor. Nulla semper tellus id nunc interdum', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 0, 0, 1, 0, 0, 1, 1),
(165, 95, 1149, 1776, 'orci lacus vestibulum lorem, sit amet ultricies sem magna nec', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 4, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 1, 1, 0, 1, 0, 1),
(166, 87, 2218, 819, 'Sed eu eros. Nam consequat dolor vitae dolor. Donec fringilla.', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 4, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 0, 0, 0, 1, 0, 1),
(167, 33, 588, 861, 'eleifend non, dapibus rutrum, justo. Praesent luctus. Curabitur egestas nunc', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 3, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 0, 1, 1, 1, 1, 1, 1),
(168, 52, 669, 193, 'dui lectus rutrum urna, nec luctus felis purus ac tellus.', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 4, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 1, 1, 1, 1, 0, 1),
(169, 16, 2249, 1899, 'velit. Quisque varius. Nam porttitor scelerisque neque. Nullam nisl. Maecenas', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 1, 0, 0, 0, 1, 1, 1),
(170, 71, 1707, 2016, 'egestas a, scelerisque sed, sapien. Nunc pulvinar arcu et pede.', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 0, 1, 0, 0, 0, 1),
(171, 51, 770, 616, 'senectus et netus et malesuada fames ac turpis egestas. Aliquam', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 4, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 1, 0, 1, 0, 0, 1),
(172, 96, 1734, 1389, 'imperdiet nec, leo. Morbi neque tellus, imperdiet non, vestibulum nec,', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 0, 1, 1, 0, 1, 1, 1),
(173, 87, 128, 1919, 'at, velit. Pellentesque ultricies dignissim lacus. Aliquam rutrum lorem ac', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 3, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 1, 0, 0, 1, 0, 1),
(174, 32, 1825, 506, 'est ac mattis semper, dui lectus rutrum urna, nec luctus', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 1, 1, 1, 0, 0, 0, 1),
(175, 38, 540, 1923, 'mi tempor lorem, eget mollis lectus pede et risus. Quisque', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 4, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 0, 1, 0, 1, 0, 1, 1),
(176, 34, 290, 783, 'dictum eu, placerat eget, venenatis a, magna. Lorem ipsum dolor', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 3, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 1, 1, 1, 1, 1, 1),
(177, 41, 1914, 173, 'eu tellus eu augue porttitor interdum. Sed auctor odio a', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 4, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 1, 1, 0, 1, 0, 1, 1),
(178, 71, 367, 1024, 'scelerisque neque sed sem egestas blandit. Nam nulla magna, malesuada', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 4, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 1, 0, 1, 1, 0, 0, 1),
(179, 5, 558, 892, 'lacus. Etiam bibendum fermentum metus. Aenean sed pede nec ante', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 4, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 0, 1, 1, 1, 1, 1),
(180, 49, 1993, 2295, 'lobortis ultrices. Vivamus rhoncus. Donec est. Nunc ullamcorper, velit in', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 4, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 1, 0, 0, 1, 0, 1),
(181, 17, 1526, 836, 'varius. Nam porttitor scelerisque neque. Nullam nisl. Maecenas malesuada fringilla', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 0, 1, 0, 1, 0, 0, 1),
(182, 46, 1414, 1407, 'aliquam iaculis, lacus pede sagittis augue, eu tempor erat neque', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 3, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 1, 1, 0, 1, 0, 1, 1),
(183, 48, 1504, 478, 'purus. Nullam scelerisque neque sed sem egestas blandit. Nam nulla', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 4, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 0, 0, 0, 1, 0, 1),
(184, 12, 1474, 492, 'Nullam scelerisque neque sed sem egestas blandit. Nam nulla magna,', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 0, 1, 0, 1, 0, 1),
(185, 55, 193, 576, 'a, arcu. Sed et libero. Proin mi. Aliquam gravida mauris', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 3, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 0, 1, 0, 0, 0, 0, 1),
(186, 29, 1921, 1429, 'nec urna suscipit nonummy. Fusce fermentum fermentum arcu. Vestibulum ante', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 3, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 1, 1, 0, 1, 1, 0, 1),
(187, 69, 2165, 477, 'egestas a, dui. Cras pellentesque. Sed dictum. Proin eget odio.', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 1, 1, 1, 1, 0, 0, 1),
(188, 90, 1223, 629, 'lacus. Ut nec urna et arcu imperdiet ullamcorper. Duis at', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 3, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 0, 1, 0, 0, 1, 1),
(189, 43, 753, 1941, 'sed pede nec ante blandit viverra. Donec tempus, lorem fringilla', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 4, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 0, 0, 1, 1, 1, 1),
(190, 73, 938, 1422, 'aptent taciti sociosqu ad litora torquent per conubia nostra, per', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 1, 0, 0, 1, 0, 1, 1),
(191, 76, 1448, 1786, 'mauris ipsum porta elit, a feugiat tellus lorem eu metus.', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 4, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 0, 0, 1, 0, 1, 1, 1),
(192, 80, 728, 1609, 'urna, nec luctus felis purus ac tellus. Suspendisse sed dolor.', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 0, 1, 1, 1, 1, 0, 1),
(193, 47, 1008, 1620, 'lacinia vitae, sodales at, velit. Pellentesque ultricies dignissim lacus. Aliquam', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 3, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 0, 1, 0, 0, 1, 1, 1),
(194, 22, 2291, 1423, 'erat volutpat. Nulla dignissim. Maecenas ornare egestas ligula. Nullam feugiat', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 1, 0, 1, 0, 0, 0, 1),
(195, 90, 1531, 1496, 'Nunc mauris. Morbi non sapien molestie orci tincidunt adipiscing. Mauris', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 0, 0, 1, 1, 0, 1, 1),
(196, 61, 269, 2104, 'Sed id risus quis diam luctus lobortis. Class aptent taciti', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 0, 0, 0, 0, 1, 1),
(197, 14, 2157, 131, 'Fusce aliquam, enim nec tempus scelerisque, lorem ipsum sodales purus,', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 1, 1, 1, 0, 0, 0, 1),
(198, 64, 831, 1349, 'arcu ac orci. Ut semper pretium neque. Morbi quis urna.', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 2, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 0, 0, 1, 1, 0, 0, 1, 1),
(199, 99, 1017, 1748, 'lorem fringilla ornare placerat, orci lacus vestibulum lorem, sit amet', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 1, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 0, 0, 1, 1, 1, 0, 1),
(200, 79, 1960, 2031, 'rutrum urna, nec luctus felis purus ac tellus. Suspendisse sed', '1970-01-01 18:00:00', '1970-01-01 17:00:00', 4, '2017-03-02 00:00:00', '2017-03-30 00:00:00', 1, 0, 1, 1, 1, 0, 0, 1);
-- --------------------------------------------------------
--
-- Structure de la table `towns`
--
CREATE TABLE IF NOT EXISTS `towns` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(45) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2353 ;
--
-- Contenu de la table `towns`
--
INSERT INTO `towns` (`id`, `name`) VALUES
(1, 'Aeugst am Albis'),
(2, 'Affoltern am Albis'),
(3, 'Bonstetten'),
(4, 'Hausen am Albis'),
(5, 'Hedingen'),
(6, 'Kappel am Albis'),
(7, 'Knonau'),
(8, 'Maschwanden'),
(9, 'Mettmenstetten'),
(10, 'Obfelden'),
(11, 'Ottenbach'),
(12, 'Rifferswil'),
(13, 'Stallikon'),
(14, 'Wettswil am Albis'),
(15, 'Adlikon'),
(16, 'Benken (ZH)'),
(17, 'Berg am Irchel'),
(18, 'Buch am Irchel'),
(19, 'Dachsen'),
(20, 'Dorf'),
(21, 'Feuerthalen'),
(22, 'Flaach'),
(23, 'Flurlingen'),
(24, 'Andelfingen'),
(25, 'Henggart'),
(26, 'Humlikon'),
(27, 'Kleinandelfingen'),
(28, 'Laufen-Uhwiesen'),
(29, 'Marthalen'),
(30, 'Oberstammheim'),
(31, 'Ossingen'),
(32, 'Rheinau'),
(33, 'Thalheim an der Thur'),
(34, 'Trüllikon'),
(35, 'Truttikon'),
(36, 'Unterstammheim'),
(37, 'Volken'),
(38, 'Waltalingen'),
(39, 'Bachenbülach'),
(40, 'Bassersdorf'),
(41, 'Bülach'),
(42, 'Dietlikon'),
(43, 'Eglisau'),
(44, 'Embrach'),
(45, 'Freienstein-Teufen'),
(46, 'Glattfelden'),
(47, 'Hochfelden'),
(48, 'Höri'),
(49, 'Hüntwangen'),
(50, 'Kloten'),
(51, 'Lufingen'),
(52, 'Nürensdorf'),
(53, 'Oberembrach'),
(54, 'Opfikon'),
(55, 'Rafz'),
(56, 'Rorbas'),
(57, 'Wallisellen'),
(58, 'Wasterkingen'),
(59, 'Wil (ZH)'),
(60, 'Winkel'),
(61, 'Bachs'),
(62, 'Boppelsen'),
(63, 'Buchs (ZH)'),
(64, 'Dällikon'),
(65, 'Dänikon'),
(66, 'Dielsdorf'),
(67, 'Hüttikon'),
(68, 'Neerach'),
(69, 'Niederglatt'),
(70, 'Niederhasli'),
(71, 'Niederweningen'),
(72, 'Oberglatt'),
(73, 'Oberweningen'),
(74, 'Otelfingen'),
(75, 'Regensberg'),
(76, 'Regensdorf'),
(77, 'Rümlang'),
(78, 'Schleinikon'),
(79, 'Schöfflisdorf'),
(80, 'Stadel'),
(81, 'Steinmaur'),
(82, 'Weiach'),
(83, 'Bäretswil'),
(84, 'Bubikon'),
(85, 'Dürnten'),
(86, 'Fischenthal'),
(87, 'Gossau (ZH)'),
(88, 'Grüningen'),
(89, 'Hinwil'),
(90, 'Rüti (ZH)'),
(91, 'Seegräben'),
(92, 'Wald (ZH)'),
(93, 'Wetzikon (ZH)'),
(94, 'Adliswil'),
(95, 'Hirzel'),
(96, 'Horgen'),
(97, 'Hütten'),
(98, 'Kilchberg (ZH)'),
(99, 'Langnau am Albis'),
(100, 'Oberrieden'),
(101, 'Richterswil'),
(102, 'Rüschlikon'),
(103, 'Schönenberg (ZH)'),
(104, 'Thalwil'),
(105, 'Wädenswil'),
(106, 'Erlenbach (ZH)'),
(107, 'Herrliberg'),
(108, 'Hombrechtikon'),
(109, 'Küsnacht (ZH)'),
(110, 'Männedorf'),
(111, 'Meilen'),
(112, 'Oetwil am See'),
(113, 'Stäfa'),
(114, 'Uetikon am See'),
(115, 'Zumikon'),
(116, 'Zollikon'),
(117, 'Bauma'),
(118, 'Fehraltorf'),
(119, 'Hittnau'),
(120, 'Illnau-Effretikon'),
(121, 'Kyburg'),
(122, 'Lindau'),
(123, 'Pfäffikon'),
(124, 'Russikon'),
(125, 'Sternenberg'),
(126, 'Weisslingen'),
(127, 'Wila'),
(128, 'Wildberg'),
(129, 'Dübendorf'),
(130, 'Egg'),
(131, 'Fällanden'),
(132, 'Greifensee'),
(133, 'Maur'),
(134, 'Mönchaltorf'),
(135, 'Schwerzenbach'),
(136, 'Uster'),
(137, 'Volketswil'),
(138, 'Wangen-Brüttisellen'),
(139, 'Altikon'),
(140, 'Brütten'),
(141, 'Dägerlen'),
(142, 'Dättlikon'),
(143, 'Dinhard'),
(144, 'Elgg'),
(145, 'Ellikon an der Thur'),
(146, 'Elsau'),
(147, 'Hagenbuch'),
(148, 'Hettlingen'),
(149, 'Hofstetten (ZH)'),
(150, 'Neftenbach'),
(151, 'Pfungen'),
(152, 'Rickenbach (ZH)'),
(153, 'Schlatt (ZH)'),
(154, 'Seuzach'),
(155, 'Turbenthal'),
(156, 'Winterthur'),
(157, 'Zell (ZH)'),
(158, 'Aesch (ZH)'),
(159, 'Birmensdorf (ZH)'),
(160, 'Dietikon'),
(161, 'Geroldswil'),
(162, 'Oberengstringen'),
(163, 'Oetwil an der Limmat'),
(164, 'Schlieren'),
(165, 'Uitikon'),
(166, 'Unterengstringen'),
(167, 'Urdorf'),
(168, 'Weiningen (ZH)'),
(169, 'Zürich'),
(170, 'Wiesendangen'),
(171, 'Aarberg'),
(172, 'Bargen (BE)'),
(173, 'Grossaffoltern'),
(174, 'Kallnach'),
(175, 'Kappelen'),
(176, 'Lyss'),
(177, 'Meikirch'),
(178, 'Radelfingen'),
(179, 'Rapperswil (BE)'),
(180, 'Schüpfen'),
(181, 'Seedorf (BE)'),
(182, 'Aarwangen'),
(183, 'Auswil'),
(184, 'Bannwil'),
(185, 'Bleienbach'),
(186, 'Busswil bei Melchnau'),
(187, 'Gondiswil'),
(188, 'Langenthal'),
(189, 'Lotzwil'),
(190, 'Madiswil'),
(191, 'Melchnau'),
(192, 'Obersteckholz'),
(193, 'Oeschenbach'),
(194, 'Reisiswil'),
(195, 'Roggwil (BE)'),
(196, 'Rohrbach'),
(197, 'Rohrbachgraben'),
(198, 'Rütschelen'),
(199, 'Schwarzhäusern'),
(200, 'Thunstetten'),
(201, 'Ursenbach'),
(202, 'Wynau'),
(203, 'Bern'),
(204, 'Bolligen'),
(205, 'Bremgarten bei Bern'),
(206, 'Kirchlindach'),
(207, 'Köniz'),
(208, 'Muri bei Bern'),
(209, 'Oberbalm'),
(210, 'Stettlen'),
(211, 'Vechigen'),
(212, 'Wohlen bei Bern'),
(213, 'Zollikofen'),
(214, 'Ittigen'),
(215, 'Ostermundigen'),
(216, 'Biel/Bienne'),
(217, 'Evilard'),
(218, 'Arch'),
(219, 'Büetigen'),
(220, 'Büren an der Aare'),
(221, 'Diessbach bei Büren'),
(222, 'Dotzigen'),
(223, 'Lengnau (BE)'),
(224, 'Leuzigen'),
(225, 'Meienried'),
(226, 'Meinisberg'),
(227, 'Oberwil bei Büren'),
(228, 'Pieterlen'),
(229, 'Rüti bei Büren'),
(230, 'Wengi'),
(231, 'Aefligen'),
(232, 'Alchenstorf'),
(233, 'Bäriswil'),
(234, 'Burgdorf'),
(235, 'Ersigen'),
(236, 'Hasle bei Burgdorf'),
(237, 'Heimiswil'),
(238, 'Hellsau'),
(239, 'Hindelbank'),
(240, 'Höchstetten'),
(241, 'Kernenried'),
(242, 'Kirchberg (BE)'),
(243, 'Koppigen'),
(244, 'Krauchthal'),
(245, 'Lyssach'),
(246, 'Mötschwil'),
(247, 'Niederösch'),
(248, 'Oberburg'),
(249, 'Oberösch'),
(250, 'Rüdtligen-Alchenflüh'),
(251, 'Rumendingen'),
(252, 'Rüti bei Lyssach'),
(253, 'Willadingen'),
(254, 'Wynigen'),
(255, 'Corgémont'),
(256, 'Cormoret'),
(257, 'Cortébert'),
(258, 'Courtelary'),
(259, 'La Ferrière'),
(260, 'La Heutte'),
(261, 'Mont-Tramelan'),
(262, 'Orvin'),
(263, 'Péry'),
(264, 'Renan (BE)'),
(265, 'Romont (BE)'),
(266, 'Saint-Imier'),
(267, 'Sonceboz-Sombeval'),
(268, 'Sonvilier'),
(269, 'Tramelan'),
(270, 'Villeret'),
(271, 'Sauge'),
(272, 'Brüttelen'),
(273, 'Erlach'),
(274, 'Finsterhennen'),
(275, 'Gals'),
(276, 'Gampelen'),
(277, 'Ins'),
(278, 'Lüscherz'),
(279, 'Müntschemier'),
(280, 'Siselen'),
(281, 'Treiten'),
(282, 'Tschugg'),
(283, 'Vinelz'),
(284, 'Bangerten'),
(285, 'Bätterkinden'),
(286, 'Deisswil bei Münchenbuchsee'),
(287, 'Diemerswil'),
(288, 'Fraubrunnen'),
(289, 'Jegenstorf'),
(290, 'Iffwil'),
(291, 'Mattstetten'),
(292, 'Moosseedorf'),
(293, 'Münchenbuchsee'),
(294, 'Urtenen-Schönbühl'),
(295, 'Utzenstorf'),
(296, 'Wiggiswil'),
(297, 'Wiler bei Utzenstorf'),
(298, 'Zielebach'),
(299, 'Zuzwil (BE)'),
(300, 'Adelboden'),
(301, 'Aeschi bei Spiez'),
(302, 'Frutigen'),
(303, 'Kandergrund'),
(304, 'Kandersteg'),
(305, 'Krattigen'),
(306, 'Reichenbach im Kandertal'),
(307, 'Beatenberg'),
(308, 'Bönigen'),
(309, 'Brienz (BE)'),
(310, 'Brienzwiler'),
(311, 'Därligen'),
(312, 'Grindelwald'),
(313, 'Gsteigwiler'),
(314, 'Gündlischwand'),
(315, 'Habkern'),
(316, 'Hofstetten bei Brienz'),
(317, 'Interlaken'),
(318, 'Iseltwald'),
(319, 'Lauterbrunnen'),
(320, 'Leissigen'),
(321, 'Lütschental'),
(322, 'Matten bei Interlaken'),
(323, 'Niederried bei Interlaken'),
(324, 'Oberried am Brienzersee'),
(325, 'Ringgenberg (BE)'),
(326, 'Saxeten'),
(327, 'Schwanden bei Brienz'),
(328, 'Unterseen'),
(329, 'Wilderswil'),
(330, 'Arni (BE)'),
(331, 'Biglen'),
(332, 'Bowil'),
(333, 'Brenzikofen'),
(334, 'Freimettigen'),
(335, 'Grosshöchstetten'),
(336, 'Häutligen'),
(337, 'Herbligen'),
(338, 'Kiesen'),
(339, 'Konolfingen'),
(340, 'Landiswil'),
(341, 'Linden'),
(342, 'Mirchel'),
(343, 'Münsingen'),
(344, 'Niederhünigen'),
(345, 'Oberdiessbach'),
(346, 'Oberthal'),
(347, 'Oppligen'),
(348, 'Rubigen'),
(349, 'Schlosswil'),
(350, 'Tägertschi'),
(351, 'Walkringen'),
(352, 'Worb'),
(353, 'Zäziwil'),
(354, 'Oberhünigen'),
(355, 'Allmendingen'),
(356, 'Wichtrach'),
(357, 'Clavaleyres'),
(358, 'Ferenbalm'),
(359, 'Frauenkappelen'),
(360, 'Golaten'),
(361, 'Gurbrü'),
(362, 'Kriechenwil'),
(363, 'Laupen'),
(364, 'Mühleberg'),
(365, 'Münchenwiler'),
(366, 'Neuenegg'),
(367, 'Wileroltigen'),
(368, 'Belprahon'),
(369, 'Bévilard'),
(370, 'Champoz'),
(371, 'Châtelat'),
(372, 'Corcelles (BE)'),
(373, 'Court'),
(374, 'Crémines'),
(375, 'Eschert'),
(376, 'Grandval'),
(377, 'Loveresse'),
(378, 'Malleray'),
(379, 'Monible'),
(380, 'Moutier'),
(381, 'Perrefitte'),
(382, 'Pontenet'),
(383, 'Reconvilier'),
(384, 'Roches (BE)'),
(385, 'Saicourt'),
(386, 'Saules (BE)'),
(387, 'Schelten'),
(388, 'Seehof'),
(389, 'Sornetan'),
(390, 'Sorvilier'),
(391, 'Souboz'),
(392, 'Tavannes'),
(393, 'Rebévelier'),
(394, 'La Neuveville'),
(395, 'Nods'),
(396, 'Plateau de Diesse'),
(397, 'Aegerten'),
(398, 'Bellmund'),
(399, 'Brügg'),
(400, 'Bühl'),
(401, 'Epsach'),
(402, 'Hagneck'),
(403, 'Hermrigen'),
(404, 'Jens'),
(405, 'Ipsach'),
(406, 'Ligerz'),
(407, 'Merzligen'),
(408, 'Mörigen'),
(409, 'Nidau'),
(410, 'Orpund'),
(411, 'Port'),
(412, 'Safnern'),
(413, 'Scheuren'),
(414, 'Schwadernau'),
(415, 'Studen (BE)'),
(416, 'Sutz-Lattrigen'),
(417, 'Täuffelen'),
(418, 'Walperswil'),
(419, 'Worben'),
(420, 'Twann-Tüscherz'),
(421, 'Därstetten'),
(422, 'Diemtigen'),
(423, 'Erlenbach im Simmental'),
(424, 'Oberwil im Simmental'),
(425, 'Reutigen'),
(426, 'Spiez'),
(427, 'Wimmis'),
(428, 'Stocken-Höfen'),
(429, 'Guttannen'),
(430, 'Hasliberg'),
(431, 'Innertkirchen'),
(432, 'Meiringen'),
(433, 'Schattenhalb'),
(434, 'Boltigen'),
(435, 'Lenk'),
(436, 'St. Stephan'),
(437, 'Zweisimmen'),
(438, 'Gsteig'),
(439, 'Lauenen'),
(440, 'Saanen'),
(441, 'Guggisberg'),
(442, 'Rüschegg'),
(443, 'Schwarzenburg'),
(444, 'Belp'),
(445, 'Burgistein'),
(446, 'Gelterfingen'),
(447, 'Gerzensee'),
(448, 'Gurzelen'),
(449, 'Jaberg'),
(450, 'Kaufdorf'),
(451, 'Kehrsatz'),
(452, 'Kirchdorf (BE)'),
(453, 'Kirchenthurnen'),
(454, 'Lohnstorf'),
(455, 'Mühledorf (BE)'),
(456, 'Mühlethurnen'),
(457, 'Niedermuhlern'),
(458, 'Noflen'),
(459, 'Riggisberg'),
(460, 'Rüeggisberg'),
(461, 'Rümligen'),
(462, 'Seftigen'),
(463, 'Toffen'),
(464, 'Uttigen'),
(465, 'Wattenwil'),
(466, 'Wald (BE)'),
(467, 'Eggiwil'),
(468, 'Langnau im Emmental'),
(469, 'Lauperswil'),
(470, 'Röthenbach im Emmental'),
(471, 'Rüderswil'),
(472, 'Schangnau'),
(473, 'Signau'),
(474, 'Trub'),
(475, 'Trubschachen'),
(476, 'Amsoldingen'),
(477, 'Blumenstein'),
(478, 'Buchholterberg'),
(479, 'Eriz'),
(480, 'Fahrni'),
(481, 'Heiligenschwendi'),
(482, 'Heimberg'),
(483, 'Hilterfingen'),
(484, 'Homberg'),
(485, 'Horrenbach-Buchen'),
(486, 'Oberhofen am Thunersee'),
(487, 'Oberlangenegg'),
(488, 'Pohlern'),
(489, 'Schwendibach'),
(490, 'Sigriswil'),
(491, 'Steffisburg'),
(492, 'Teuffenthal (BE)'),
(493, 'Thierachern'),
(494, 'Thun'),
(495, 'Uebeschi'),
(496, 'Uetendorf'),
(497, 'Unterlangenegg'),
(498, 'Wachseldorn'),
(499, 'Zwieselberg'),
(500, 'Forst-Längenbühl'),
(501, 'Affoltern im Emmental'),
(502, 'Dürrenroth'),
(503, 'Eriswil'),
(504, 'Huttwil'),
(505, 'Lützelflüh'),
(506, 'Rüegsau'),
(507, 'Sumiswald'),
(508, 'Trachselwald'),
(509, 'Walterswil (BE)'),
(510, 'Wyssachen'),
(511, 'Attiswil'),
(512, 'Berken'),
(513, 'Bettenhausen'),
(514, 'Farnern'),
(515, 'Graben'),
(516, 'Heimenhausen'),
(517, 'Hermiswil'),
(518, 'Herzogenbuchsee'),
(519, 'Inkwil'),
(520, 'Niederbipp'),
(521, 'Niederönz'),
(522, 'Oberbipp'),
(523, 'Ochlenberg'),
(524, 'Rumisberg'),
(525, 'Seeberg'),
(526, 'Thörigen'),
(527, 'Walliswil bei Niederbipp'),
(528, 'Walliswil bei Wangen'),
(529, 'Wangen an der Aare'),
(530, 'Wangenried'),
(531, 'Wiedlisbach'),
(532, 'Wolfisberg'),
(533, 'Doppleschwand'),
(534, 'Entlebuch'),
(535, 'Flühli'),
(536, 'Hasle (LU)'),
(537, 'Romoos'),
(538, 'Schüpfheim'),
(539, 'Werthenstein'),
(540, 'Escholzmatt-Marbach'),
(541, 'Aesch (LU)'),
(542, 'Altwis'),
(543, 'Ballwil'),
(544, 'Emmen'),
(545, 'Ermensee'),
(546, 'Eschenbach (LU)'),
(547, 'Hitzkirch'),
(548, 'Hochdorf'),
(549, 'Hohenrain'),
(550, 'Inwil'),
(551, 'Rain'),
(552, 'Römerswil'),
(553, 'Rothenburg'),
(554, 'Schongau'),
(555, 'Adligenswil'),
(556, 'Buchrain'),
(557, 'Dierikon'),
(558, 'Ebikon'),
(559, 'Gisikon'),
(560, 'Greppen'),
(561, 'Honau'),
(562, 'Horw'),
(563, 'Kriens'),
(564, 'Luzern'),
(565, 'Malters'),
(566, 'Meggen'),
(567, 'Meierskappel'),
(568, 'Root'),
(569, 'Schwarzenberg'),
(570, 'Udligenswil'),
(571, 'Vitznau'),
(572, 'Weggis'),
(573, 'Beromünster'),
(574, 'Büron'),
(575, 'Buttisholz'),
(576, 'Eich'),
(577, 'Geuensee'),
(578, 'Grosswangen'),
(579, 'Hildisrieden'),
(580, 'Knutwil'),
(581, 'Mauensee'),
(582, 'Neuenkirch'),
(583, 'Nottwil'),
(584, 'Oberkirch'),
(585, 'Rickenbach (LU)'),
(586, 'Ruswil'),
(587, 'Schenkon'),
(588, 'Schlierbach'),
(589, 'Sempach'),
(590, 'Sursee'),
(591, 'Triengen'),
(592, 'Wolhusen'),
(593, 'Alberswil'),
(594, 'Altbüron'),
(595, 'Altishofen'),
(596, 'Dagmersellen'),
(597, 'Ebersecken'),
(598, 'Egolzwil'),
(599, 'Ettiswil'),
(600, 'Fischbach'),
(601, 'Gettnau'),
(602, 'Grossdietwil'),
(603, 'Hergiswil bei Willisau'),
(604, 'Luthern'),
(605, 'Menznau'),
(606, 'Nebikon'),
(607, 'Pfaffnau'),
(608, 'Reiden'),
(609, 'Roggliswil'),
(610, 'Schötz'),
(611, 'Ufhusen'),
(612, 'Wauwil'),
(613, 'Wikon'),
(614, 'Zell (LU)'),
(615, 'Willisau'),
(616, 'Altdorf (UR)'),
(617, 'Andermatt'),
(618, 'Attinghausen'),
(619, 'Bauen'),
(620, 'Bürglen (UR)'),
(621, 'Erstfeld'),
(622, 'Flüelen'),
(623, 'Göschenen'),
(624, 'Gurtnellen'),
(625, 'Hospental'),
(626, 'Isenthal'),
(627, 'Realp'),
(628, 'Schattdorf'),
(629, 'Seedorf (UR)'),
(630, 'Seelisberg'),
(631, 'Silenen'),
(632, 'Sisikon'),
(633, 'Spiringen'),
(634, 'Unterschächen'),
(635, 'Wassen'),
(636, 'Einsiedeln'),
(637, 'Gersau'),
(638, 'Feusisberg'),
(639, 'Freienbach'),
(640, 'Wollerau'),
(641, 'Küssnacht (SZ)'),
(642, 'Altendorf'),
(643, 'Galgenen'),
(644, 'Innerthal'),
(645, 'Lachen'),
(646, 'Reichenburg'),
(647, 'Schübelbach'),
(648, 'Tuggen'),
(649, 'Vorderthal'),
(650, 'Wangen (SZ)'),
(651, 'Alpthal'),
(652, 'Arth'),
(653, 'Illgau'),
(654, 'Ingenbohl'),
(655, 'Lauerz'),
(656, 'Morschach'),
(657, 'Muotathal'),
(658, 'Oberiberg'),
(659, 'Riemenstalden'),
(660, 'Rothenthurm'),
(661, 'Sattel'),
(662, 'Schwyz'),
(663, 'Steinen'),
(664, 'Steinerberg'),
(665, 'Unteriberg'),
(666, 'Alpnach'),
(667, 'Engelberg'),
(668, 'Giswil'),
(669, 'Kerns'),
(670, 'Lungern'),
(671, 'Sachseln'),
(672, 'Sarnen'),
(673, 'Beckenried'),
(674, 'Buochs'),
(675, 'Dallenwil'),
(676, 'Emmetten'),
(677, 'Ennetbürgen'),
(678, 'Ennetmoos'),
(679, 'Hergiswil (NW)'),
(680, 'Oberdorf (NW)'),
(681, 'Stans'),
(682, 'Stansstad'),
(683, 'Wolfenschiessen'),
(684, 'Glarus Nord'),
(685, 'Glarus Süd'),
(686, 'Glarus'),
(687, 'Baar'),
(688, 'Cham'),
(689, 'Hünenberg'),
(690, 'Menzingen'),
(691, 'Neuheim'),
(692, 'Oberägeri'),
(693, 'Risch'),
(694, 'Steinhausen'),
(695, 'Unterägeri'),
(696, 'Walchwil'),
(697, 'Zug'),
(698, 'Bussy (FR)'),
(699, 'Châbles'),
(700, 'Châtillon (FR)'),
(701, 'Cheiry'),
(702, 'Cheyres'),
(703, 'Cugy (FR)'),
(704, 'Domdidier'),
(705, 'Dompierre (FR)'),
(706, 'Estavayer-le-Lac'),
(707, 'Fétigny'),
(708, 'Gletterens'),
(709, 'Léchelles'),
(710, 'Lully (FR)'),
(711, 'Ménières'),
(712, 'Montagny (FR)'),
(713, 'Morens (FR)'),
(714, 'Murist'),
(715, 'Nuvilly'),
(716, 'Prévondavaux'),
(717, 'Rueyres-les-Prés'),
(718, 'Russy'),
(719, 'Saint-Aubin (FR)'),
(720, 'Sévaz'),
(721, 'Surpierre'),
(722, 'Vallon'),
(723, 'Villeneuve (FR)'),
(724, 'Vuissens'),
(725, 'Les Montets'),
(726, 'Delley-Portalban'),
(727, 'Vernay'),
(728, 'Auboranges'),
(729, 'Billens-Hennens'),
(730, 'Chapelle (Glâne)'),
(731, 'Le Châtelard'),
(732, 'Châtonnaye'),
(733, 'Ecublens (FR)'),
(734, 'Grangettes'),
(735, 'Massonnens'),
(736, 'Mézières (FR)'),
(737, 'Montet (Glâne)'),
(738, 'Romont (FR)'),
(739, 'Rue'),
(740, 'Siviriez'),
(741, 'Ursy'),
(742, 'Villaz-Saint-Pierre'),
(743, 'Vuisternens-devant-Romont'),
(744, 'Villorsonnens'),
(745, 'Torny'),
(746, 'La Folliaz'),
(747, 'Haut-Intyamon'),
(748, 'Pont-en-Ogoz'),
(749, 'Botterens'),
(750, 'Broc'),
(751, 'Bulle'),
(752, 'Châtel-sur-Montsalvens'),
(753, 'Corbières'),
(754, 'Crésuz'),
(755, 'Echarlens'),
(756, 'Grandvillard'),
(757, 'Gruyères'),
(758, 'Hauteville'),
(759, 'Jaun'),
(760, 'Marsens'),
(761, 'Morlon'),
(762, 'Le Pâquier (FR)'),
(763, 'Pont-la-Ville'),
(764, 'Riaz'),
(765, 'La Roche'),
(766, 'Sâles'),
(767, 'Sorens'),
(768, 'Vaulruz'),
(769, 'Vuadens'),
(770, 'Bas-Intyamon'),
(771, 'Val-de-Charmey'),
(772, 'Arconciel'),
(773, 'Autafond'),
(774, 'Autigny'),
(775, 'Avry'),
(776, 'Belfaux'),
(777, 'Chénens'),
(778, 'Chésopelloz'),
(779, 'Corminboeuf'),
(780, 'Corpataux-Magnedens'),
(781, 'Corserey'),
(782, 'Cottens (FR)'),
(783, 'Ependes (FR)'),
(784, 'Farvagny'),
(785, 'Ferpicloz'),
(786, 'Fribourg'),
(787, 'Givisiez'),
(788, 'Granges-Paccot'),
(789, 'Grolley'),
(790, 'Marly'),
(791, 'Matran'),
(792, 'Neyruz (FR)'),
(793, 'Noréaz'),
(794, 'Pierrafortscha'),
(795, 'Ponthaux'),
(796, 'Le Mouret'),
(797, 'Prez-vers-Noréaz'),
(798, 'Rossens (FR)'),
(799, 'Le Glèbe'),
(800, 'Senèdes'),
(801, 'Treyvaux'),
(802, 'Villars-sur-Glâne'),
(803, 'Villarsel-sur-Marly'),
(804, 'Vuisternens-en-Ogoz'),
(805, 'Hauterive (FR)'),
(806, 'La Brillaz'),
(807, 'La Sonnaz'),
(808, 'Barberêche'),
(809, 'Courgevaux'),
(810, 'Courlevon'),
(811, 'Courtepin'),
(812, 'Cressier (FR)'),
(813, 'Fräschels'),
(814, 'Galmiz'),
(815, 'Gempenach'),
(816, 'Greng'),
(817, 'Gurmels'),
(818, 'Jeuss'),
(819, 'Kerzers'),
(820, 'Kleinbösingen'),
(821, 'Lurtigen'),
(822, 'Meyriez'),
(823, 'Misery-Courtion'),
(824, 'Muntelier'),
(825, 'Murten'),
(826, 'Ried bei Kerzers'),
(827, 'Salvenach'),
(828, 'Ulmiz'),
(829, 'Villarepos'),
(830, 'Bas-Vully'),
(831, 'Haut-Vully'),
(832, 'Wallenried'),
(833, 'Alterswil'),
(834, 'Brünisried'),
(835, 'Düdingen'),
(836, 'Giffers'),
(837, 'Bösingen'),
(838, 'Heitenried'),
(839, 'Oberschrot'),
(840, 'Plaffeien'),
(841, 'Plasselb'),
(842, 'Rechthalten'),
(843, 'St. Antoni'),
(844, 'St. Silvester'),
(845, 'St. Ursen'),
(846, 'Schmitten (FR)'),
(847, 'Tafers'),
(848, 'Tentlingen'),
(849, 'Ueberstorf'),
(850, 'Wünnewil-Flamatt'),
(851, 'Zumholz'),
(852, 'Attalens'),
(853, 'Bossonnens'),
(854, 'Châtel-Saint-Denis'),
(855, 'Granges (Veveyse)'),
(856, 'Remaufens'),
(857, 'Saint-Martin (FR)'),
(858, 'Semsales'),
(859, 'Le Flon'),
(860, 'La Verrerie'),
(861, 'Egerkingen'),
(862, 'Härkingen'),
(863, 'Kestenholz'),
(864, 'Neuendorf'),
(865, 'Niederbuchsiten'),
(866, 'Oberbuchsiten'),
(867, 'Oensingen'),
(868, 'Wolfwil'),
(869, 'Aedermannsdorf'),
(870, 'Balsthal'),
(871, 'Gänsbrunnen'),
(872, 'Herbetswil'),
(873, 'Holderbank (SO)'),
(874, 'Laupersdorf'),
(875, 'Matzendorf'),
(876, 'Mümliswil-Ramiswil'),
(877, 'Welschenrohr'),
(878, 'Biezwil'),
(879, 'Lüterkofen-Ichertswil'),
(880, 'Lüterswil-Gächliwil'),
(881, 'Messen'),
(882, 'Schnottwil'),
(883, 'Unterramsern'),
(884, 'Lüsslingen-Nennigkofen'),
(885, 'Buchegg'),
(886, 'Bättwil'),
(887, 'Büren (SO)'),
(888, 'Dornach'),
(889, 'Gempen'),
(890, 'Hochwald'),
(891, 'Hofstetten-Flüh'),
(892, 'Metzerlen-Mariastein'),
(893, 'Nuglar-St. Pantaleon'),
(894, 'Rodersdorf'),
(895, 'Seewen'),
(896, 'Witterswil'),
(897, 'Hauenstein-Ifenthal'),
(898, 'Kienberg'),
(899, 'Lostorf'),
(900, 'Niedergösgen'),
(901, 'Obergösgen'),
(902, 'Rohr (SO)'),
(903, 'Stüsslingen'),
(904, 'Trimbach'),
(905, 'Winznau'),
(906, 'Wisen (SO)'),
(907, 'Erlinsbach (SO)'),
(908, 'Aeschi (SO)'),
(909, 'Biberist'),
(910, 'Bolken'),
(911, 'Deitingen'),
(912, 'Derendingen'),
(913, 'Etziken'),
(914, 'Gerlafingen'),
(915, 'Halten'),
(916, 'Horriwil'),
(917, 'Hüniken'),
(918, 'Kriegstetten'),
(919, 'Lohn-Ammannsegg'),
(920, 'Luterbach'),
(921, 'Obergerlafingen'),
(922, 'Oekingen'),
(923, 'Recherswil'),
(924, 'Subingen'),
(925, 'Zuchwil'),
(926, 'Drei Höfe'),
(927, 'Balm bei Günsberg'),
(928, 'Bellach'),
(929, 'Bettlach'),
(930, 'Feldbrunnen-St. Niklaus'),
(931, 'Flumenthal'),
(932, 'Grenchen'),
(933, 'Günsberg'),
(934, 'Hubersdorf'),
(935, 'Kammersrohr'),
(936, 'Langendorf'),
(937, 'Lommiswil'),
(938, 'Oberdorf (SO)'),
(939, 'Riedholz'),
(940, 'Rüttenen'),
(941, 'Selzach'),
(942, 'Boningen'),
(943, 'Däniken'),
(944, 'Dulliken'),
(945, 'Eppenberg-Wöschnau'),
(946, 'Fulenbach'),
(947, 'Gretzenbach'),
(948, 'Gunzgen'),
(949, 'Hägendorf'),
(950, 'Kappel (SO)'),
(951, 'Olten'),
(952, 'Rickenbach (SO)'),
(953, 'Schönenwerd'),
(954, 'Starrkirch-Wil'),
(955, 'Walterswil (SO)'),
(956, 'Wangen bei Olten'),
(957, 'Solothurn'),
(958, 'Bärschwil'),
(959, 'Beinwil (SO)'),
(960, 'Breitenbach'),
(961, 'Büsserach'),
(962, 'Erschwil'),
(963, 'Fehren'),
(964, 'Grindel'),
(965, 'Himmelried'),
(966, 'Kleinlützel'),
(967, 'Meltingen'),
(968, 'Nunningen'),
(969, 'Zullwil'),
(970, 'Basel'),
(971, 'Bettingen'),
(972, 'Riehen'),
(973, 'Aesch (BL)'),
(974, 'Allschwil'),
(975, 'Arlesheim'),
(976, 'Biel-Benken'),
(977, 'Binningen'),
(978, 'Birsfelden'),
(979, 'Bottmingen'),
(980, 'Ettingen'),
(981, 'Münchenstein'),
(982, 'Muttenz'),
(983, 'Oberwil (BL)'),
(984, 'Pfeffingen'),
(985, 'Reinach (BL)'),
(986, 'Schönenbuch'),
(987, 'Therwil'),
(988, 'Blauen'),
(989, 'Brislach'),
(990, 'Burg im Leimental'),
(991, 'Dittingen'),
(992, 'Duggingen'),
(993, 'Grellingen'),
(994, 'Laufen'),
(995, 'Liesberg'),
(996, 'Nenzlingen'),
(997, 'Roggenburg'),
(998, 'Röschenz'),
(999, 'Wahlen'),
(1000, 'Zwingen'),
(1001, 'Arisdorf'),
(1002, 'Augst'),
(1003, 'Bubendorf'),
(1004, 'Frenkendorf'),
(1005, 'Füllinsdorf'),
(1006, 'Giebenach'),
(1007, 'Hersberg'),
(1008, 'Lausen'),
(1009, 'Liestal'),
(1010, 'Lupsingen'),
(1011, 'Pratteln'),
(1012, 'Ramlinsburg'),
(1013, 'Seltisberg'),
(1014, 'Ziefen'),
(1015, 'Anwil'),
(1016, 'Böckten'),
(1017, 'Buckten'),
(1018, 'Buus'),
(1019, 'Diepflingen'),
(1020, 'Gelterkinden'),
(1021, 'Häfelfingen'),
(1022, 'Hemmiken'),
(1023, 'Itingen'),
(1024, 'Känerkinden'),
(1025, 'Kilchberg (BL)'),
(1026, 'Läufelfingen'),
(1027, 'Maisprach'),
(1028, 'Nusshof'),
(1029, 'Oltingen'),
(1030, 'Ormalingen'),
(1031, 'Rickenbach (BL)'),
(1032, 'Rothenfluh'),
(1033, 'Rümlingen'),
(1034, 'Rünenberg'),
(1035, 'Sissach'),
(1036, 'Tecknau'),
(1037, 'Tenniken'),
(1038, 'Thürnen'),
(1039, 'Wenslingen'),
(1040, 'Wintersingen'),
(1041, 'Wittinsburg'),
(1042, 'Zeglingen'),
(1043, 'Zunzgen'),
(1044, 'Arboldswil'),
(1045, 'Bennwil'),
(1046, 'Bretzwil'),
(1047, 'Diegten'),
(1048, 'Eptingen'),
(1049, 'Hölstein'),
(1050, 'Lampenberg'),
(1051, 'Langenbruck'),
(1052, 'Lauwil'),
(1053, 'Liedertswil'),
(1054, 'Niederdorf'),
(1055, 'Oberdorf (BL)'),
(1056, 'Reigoldswil'),
(1057, 'Titterten'),
(1058, 'Waldenburg'),
(1059, 'Gächlingen'),
(1060, 'Löhningen'),
(1061, 'Neunkirch'),
(1062, 'Büttenhardt'),
(1063, 'Dörflingen'),
(1064, 'Lohn (SH)'),
(1065, 'Stetten (SH)'),
(1066, 'Thayngen'),
(1067, 'Bargen (SH)'),
(1068, 'Beringen'),
(1069, 'Buchberg'),
(1070, 'Merishausen'),
(1071, 'Neuhausen am Rheinfall'),
(1072, 'Rüdlingen'),
(1073, 'Schaffhausen'),
(1074, 'Beggingen'),
(1075, 'Schleitheim'),
(1076, 'Siblingen'),
(1077, 'Buch (SH)'),
(1078, 'Hemishofen'),
(1079, 'Ramsen'),
(1080, 'Stein am Rhein'),
(1081, 'Hallau'),
(1082, 'Oberhallau'),
(1083, 'Trasadingen'),
(1084, 'Wilchingen'),
(1085, 'Herisau'),
(1086, 'Hundwil'),
(1087, 'Schönengrund'),
(1088, 'Schwellbrunn'),
(1089, 'Stein (AR)'),
(1090, 'Urnäsch'),
(1091, 'Waldstatt'),
(1092, 'Bühler'),
(1093, 'Gais'),
(1094, 'Speicher'),
(1095, 'Teufen (AR)'),
(1096, 'Trogen'),
(1097, 'Grub (AR)'),
(1098, 'Heiden'),
(1099, 'Lutzenberg'),
(1100, 'Rehetobel'),
(1101, 'Reute (AR)'),
(1102, 'Wald (AR)'),
(1103, 'Walzenhausen'),
(1104, 'Wolfhalden'),
(1105, 'Appenzell'),
(1106, 'Gonten'),
(1107, 'Rüte'),
(1108, 'Schlatt-Haslen'),
(1109, 'Schwende'),
(1110, 'Oberegg'),
(1111, 'Häggenschwil'),
(1112, 'Muolen'),
(1113, 'St. Gallen'),
(1114, 'Wittenbach'),
(1115, 'Berg (SG)'),
(1116, 'Eggersriet'),
(1117, 'Goldach'),
(1118, 'Mörschwil'),
(1119, 'Rorschach'),
(1120, 'Rorschacherberg'),
(1121, 'Steinach'),
(1122, 'Tübach'),
(1123, 'Untereggen'),
(1124, 'Au (SG)'),
(1125, 'Balgach'),
(1126, 'Berneck'),
(1127, 'Diepoldsau'),
(1128, 'Rheineck'),
(1129, 'St. Margrethen'),
(1130, 'Thal'),
(1131, 'Widnau'),
(1132, 'Altstätten'),
(1133, 'Eichberg'),
(1134, 'Marbach (SG)'),
(1135, 'Oberriet (SG)'),
(1136, 'Rebstein'),
(1137, 'Rüthi (SG)'),
(1138, 'Buchs (SG)'),
(1139, 'Gams'),
(1140, 'Grabs'),
(1141, 'Sennwald'),
(1142, 'Sevelen'),
(1143, 'Wartau'),
(1144, 'Bad Ragaz'),
(1145, 'Flums'),
(1146, 'Mels'),
(1147, 'Pfäfers'),
(1148, 'Quarten'),
(1149, 'Sargans'),
(1150, 'Vilters-Wangs'),
(1151, 'Walenstadt'),
(1152, 'Amden'),
(1153, 'Benken (SG)'),
(1154, 'Kaltbrunn'),
(1155, 'Schänis'),
(1156, 'Weesen'),
(1157, 'Schmerikon'),
(1158, 'Uznach'),
(1159, 'Rapperswil-Jona'),
(1160, 'Gommiswald'),
(1161, 'Eschenbach (SG)'),
(1162, 'Ebnat-Kappel'),
(1163, 'Wildhaus-Alt St. Johann'),
(1164, 'Nesslau'),
(1165, 'Hemberg'),
(1166, 'Lichtensteig'),
(1167, 'Oberhelfenschwil'),
(1168, 'Neckertal'),
(1169, 'Wattwil'),
(1170, 'Kirchberg (SG)'),
(1171, 'Lütisburg'),
(1172, 'Mosnang'),
(1173, 'Bütschwil-Ganterschwil'),
(1174, 'Degersheim'),
(1175, 'Flawil'),
(1176, 'Jonschwil'),
(1177, 'Oberuzwil'),
(1178, 'Uzwil'),
(1179, 'Niederbüren'),
(1180, 'Niederhelfenschwil'),
(1181, 'Oberbüren'),
(1182, 'Zuzwil (SG)'),
(1183, 'Wil (SG)'),
(1184, 'Andwil (SG)'),
(1185, 'Gaiserwald'),
(1186, 'Gossau (SG)'),
(1187, 'Waldkirch'),
(1188, 'Alvaschein'),
(1189, 'Mon'),
(1190, 'Mutten'),
(1191, 'Stierva'),
(1192, 'Tiefencastel'),
(1193, 'Vaz/Obervaz'),
(1194, 'Alvaneu'),
(1195, 'Brienz/Brinzauls'),
(1196, 'Lantsch/Lenz'),
(1197, 'Schmitten (GR)'),
(1198, 'Surava'),
(1199, 'Bergün/Bravuogn'),
(1200, 'Filisur'),
(1201, 'Bivio'),
(1202, 'Cunter'),
(1203, 'Marmorera'),
(1204, 'Mulegns'),
(1205, 'Riom-Parsonz'),
(1206, 'Salouf'),
(1207, 'Savognin'),
(1208, 'Sur'),
(1209, 'Tinizong-Rona'),
(1210, 'Brusio'),
(1211, 'Poschiavo'),
(1212, 'Falera'),
(1213, 'Laax'),
(1214, 'Sagogn'),
(1215, 'Schluein'),
(1216, 'St. Martin'),
(1217, 'Vals'),
(1218, 'Andiast'),
(1219, 'Obersaxen'),
(1220, 'Waltensburg/Vuorz'),
(1221, 'Mundaun'),
(1222, 'Lumnezia'),
(1223, 'Ilanz/Glion'),
(1224, 'Almens'),
(1225, 'Fürstenau'),
(1226, 'Paspels'),
(1227, 'Pratval'),
(1228, 'Rodels'),
(1229, 'Rothenbrunnen'),
(1230, 'Scharans'),
(1231, 'Sils im Domleschg'),
(1232, 'Cazis'),
(1233, 'Flerden'),
(1234, 'Masein'),
(1235, 'Thusis'),
(1236, 'Tschappina'),
(1237, 'Urmein'),
(1238, 'Tomils'),
(1239, 'Safiental'),
(1240, 'Avers'),
(1241, 'Hinterrhein'),
(1242, 'Nufenen'),
(1243, 'Splügen'),
(1244, 'Sufers'),
(1245, 'Andeer'),
(1246, 'Casti-Wergenstein'),
(1247, 'Donat'),
(1248, 'Lohn (GR)'),
(1249, 'Mathon'),
(1250, 'Rongellen'),
(1251, 'Zillis-Reischen'),
(1252, 'Ferrera'),
(1253, 'Bonaduz'),
(1254, 'Domat/Ems'),
(1255, 'Rhäzüns'),
(1256, 'Felsberg'),
(1257, 'Flims'),
(1258, 'Tamins'),
(1259, 'Trin'),
(1260, 'Ardez'),
(1261, 'Guarda'),
(1262, 'Lavin'),
(1263, 'Susch'),
(1264, 'Tarasp'),
(1265, 'Zernez'),
(1266, 'Samnaun'),
(1267, 'Ftan'),
(1268, 'Scuol'),
(1269, 'Sent'),
(1270, 'Valsot'),
(1271, 'Bever'),
(1272, 'Celerina/Schlarigna'),
(1273, 'Madulain'),
(1274, 'Pontresina'),
(1275, 'La Punt-Chamues-ch'),
(1276, 'Samedan'),
(1277, 'St. Moritz'),
(1278, 'S-chanf'),
(1279, 'Sils im Engadin/Segl'),
(1280, 'Silvaplana'),
(1281, 'Zuoz'),
(1282, 'Bregaglia'),
(1283, 'Arvigo'),
(1284, 'Braggio'),
(1285, 'Buseno'),
(1286, 'Castaneda'),
(1287, 'Cauco'),
(1288, 'Rossa'),
(1289, 'Santa Maria in Calanca'),
(1290, 'Selma'),
(1291, 'Lostallo'),
(1292, 'Mesocco'),
(1293, 'Soazza'),
(1294, 'Cama'),
(1295, 'Grono'),
(1296, 'Leggia'),
(1297, 'Roveredo (GR)'),
(1298, 'San Vittore'),
(1299, 'Verdabbio'),
(1300, 'Val Müstair'),
(1301, 'Davos'),
(1302, 'Fideris'),
(1303, 'Furna'),
(1304, 'Jenaz'),
(1305, 'Klosters-Serneus'),
(1306, 'Conters im Prättigau'),
(1307, 'Küblis'),
(1308, 'Saas'),
(1309, 'Luzein'),
(1310, 'St. Antönien'),
(1311, 'Chur'),
(1312, 'Churwalden'),
(1313, 'Arosa'),
(1314, 'Maladers'),
(1315, 'Tschiertschen-Praden'),
(1316, 'Haldenstein'),
(1317, 'Trimmis'),
(1318, 'Untervaz'),
(1319, 'Zizers'),
(1320, 'Fläsch'),
(1321, 'Jenins'),
(1322, 'Maienfeld'),
(1323, 'Malans'),
(1324, 'Landquart'),
(1325, 'Grüsch'),
(1326, 'Schiers'),
(1327, 'Seewis im Prättigau'),
(1328, 'Breil/Brigels'),
(1329, 'Disentis/Mustér'),
(1330, 'Medel (Lucmagn)'),
(1331, 'Sumvitg'),
(1332, 'Tujetsch'),
(1333, 'Trun'),
(1334, 'Aarau'),
(1335, 'Biberstein'),
(1336, 'Buchs (AG)'),
(1337, 'Densbüren'),
(1338, 'Erlinsbach (AG)'),
(1339, 'Gränichen'),
(1340, 'Hirschthal'),
(1341, 'Küttigen'),
(1342, 'Muhen'),
(1343, 'Oberentfelden'),
(1344, 'Suhr'),
(1345, 'Unterentfelden'),
(1346, 'Baden'),
(1347, 'Bellikon'),
(1348, 'Bergdietikon'),
(1349, 'Birmenstorf (AG)'),
(1350, 'Ennetbaden'),
(1351, 'Fislisbach'),
(1352, 'Freienwil'),
(1353, 'Gebenstorf'),
(1354, 'Killwangen'),
(1355, 'Künten'),
(1356, 'Mägenwil'),
(1357, 'Mellingen'),
(1358, 'Neuenhof'),
(1359, 'Niederrohrdorf'),
(1360, 'Oberrohrdorf'),
(1361, 'Obersiggenthal'),
(1362, 'Remetschwil'),
(1363, 'Spreitenbach'),
(1364, 'Stetten (AG)'),
(1365, 'Turgi'),
(1366, 'Untersiggenthal'),
(1367, 'Wettingen'),
(1368, 'Wohlenschwil'),
(1369, 'Würenlingen'),
(1370, 'Würenlos'),
(1371, 'Ehrendingen'),
(1372, 'Arni (AG)'),
(1373, 'Berikon'),
(1374, 'Bremgarten (AG)'),
(1375, 'Büttikon'),
(1376, 'Dottikon'),
(1377, 'Eggenwil'),
(1378, 'Fischbach-Göslikon'),
(1379, 'Hägglingen'),
(1380, 'Jonen'),
(1381, 'Niederwil (AG)'),
(1382, 'Oberlunkhofen'),
(1383, 'Oberwil-Lieli'),
(1384, 'Rudolfstetten-Friedlisberg'),
(1385, 'Sarmenstorf'),
(1386, 'Tägerig'),
(1387, 'Uezwil'),
(1388, 'Unterlunkhofen'),
(1389, 'Villmergen'),
(1390, 'Widen'),
(1391, 'Wohlen (AG)'),
(1392, 'Zufikon'),
(1393, 'Islisberg'),
(1394, 'Auenstein'),
(1395, 'Birr'),
(1396, 'Birrhard'),
(1397, 'Bözen'),
(1398, 'Brugg'),
(1399, 'Effingen'),
(1400, 'Elfingen'),
(1401, 'Habsburg'),
(1402, 'Hausen (AG)'),
(1403, 'Lupfig'),
(1404, 'Mandach'),
(1405, 'Mönthal'),
(1406, 'Mülligen'),
(1407, 'Remigen'),
(1408, 'Riniken'),
(1409, 'Rüfenach'),
(1410, 'Scherz'),
(1411, 'Schinznach-Bad'),
(1412, 'Thalheim (AG)'),
(1413, 'Veltheim (AG)'),
(1414, 'Villigen'),
(1415, 'Villnachern'),
(1416, 'Windisch'),
(1417, 'Bözberg'),
(1418, 'Schinznach'),
(1419, 'Beinwil am See'),
(1420, 'Birrwil'),
(1421, 'Burg (AG)'),
(1422, 'Dürrenäsch'),
(1423, 'Gontenschwil'),
(1424, 'Holziken'),
(1425, 'Leimbach (AG)'),
(1426, 'Leutwil'),
(1427, 'Menziken'),
(1428, 'Oberkulm'),
(1429, 'Reinach (AG)'),
(1430, 'Schlossrued'),
(1431, 'Schmiedrued'),
(1432, 'Schöftland'),
(1433, 'Teufenthal (AG)'),
(1434, 'Unterkulm'),
(1435, 'Zetzwil'),
(1436, 'Eiken'),
(1437, 'Frick'),
(1438, 'Gansingen'),
(1439, 'Gipf-Oberfrick'),
(1440, 'Herznach'),
(1441, 'Hornussen'),
(1442, 'Kaisten'),
(1443, 'Laufenburg'),
(1444, 'Münchwilen (AG)'),
(1445, 'Oberhof'),
(1446, 'Oeschgen'),
(1447, 'Schwaderloch'),
(1448, 'Sisseln'),
(1449, 'Ueken'),
(1450, 'Wittnau'),
(1451, 'Wölflinswil'),
(1452, 'Zeihen'),
(1453, 'Mettauertal'),
(1454, 'Ammerswil'),
(1455, 'Boniswil'),
(1456, 'Brunegg'),
(1457, 'Dintikon'),
(1458, 'Egliswil'),
(1459, 'Fahrwangen'),
(1460, 'Hallwil'),
(1461, 'Hendschiken'),
(1462, 'Holderbank (AG)'),
(1463, 'Hunzenschwil'),
(1464, 'Lenzburg'),
(1465, 'Meisterschwanden'),
(1466, 'Möriken-Wildegg'),
(1467, 'Niederlenz'),
(1468, 'Othmarsingen'),
(1469, 'Rupperswil'),
(1470, 'Schafisheim'),
(1471, 'Seengen'),
(1472, 'Seon'),
(1473, 'Staufen'),
(1474, 'Abtwil'),
(1475, 'Aristau'),
(1476, 'Auw'),
(1477, 'Beinwil (Freiamt)'),
(1478, 'Besenbüren'),
(1479, 'Bettwil'),
(1480, 'Boswil'),
(1481, 'Bünzen'),
(1482, 'Buttwil'),
(1483, 'Dietwil'),
(1484, 'Geltwil'),
(1485, 'Kallern'),
(1486, 'Merenschwand'),
(1487, 'Mühlau'),
(1488, 'Muri (AG)'),
(1489, 'Oberrüti'),
(1490, 'Rottenschwil'),
(1491, 'Sins'),
(1492, 'Waltenschwil'),
(1493, 'Hellikon'),
(1494, 'Kaiseraugst'),
(1495, 'Magden'),
(1496, 'Möhlin'),
(1497, 'Mumpf'),
(1498, 'Obermumpf'),
(1499, 'Olsberg'),
(1500, 'Rheinfelden'),
(1501, 'Schupfart'),
(1502, 'Stein (AG)'),
(1503, 'Wallbach'),
(1504, 'Wegenstetten'),
(1505, 'Zeiningen'),
(1506, 'Zuzgen'),
(1507, 'Aarburg'),
(1508, 'Attelwil'),
(1509, 'Bottenwil'),
(1510, 'Brittnau'),
(1511, 'Kirchleerau'),
(1512, 'Kölliken'),
(1513, 'Moosleerau'),
(1514, 'Murgenthal'),
(1515, 'Oftringen'),
(1516, 'Reitnau'),
(1517, 'Rothrist'),
(1518, 'Safenwil'),
(1519, 'Staffelbach'),
(1520, 'Strengelbach'),
(1521, 'Uerkheim'),
(1522, 'Vordemwald'),
(1523, 'Wiliberg'),
(1524, 'Zofingen'),
(1525, 'Baldingen'),
(1526, 'Böbikon'),
(1527, 'Böttstein'),
(1528, 'Döttingen'),
(1529, 'Endingen'),
(1530, 'Fisibach'),
(1531, 'Full-Reuenthal'),
(1532, 'Kaiserstuhl'),
(1533, 'Klingnau'),
(1534, 'Koblenz'),
(1535, 'Leibstadt'),
(1536, 'Lengnau (AG)'),
(1537, 'Leuggern'),
(1538, 'Mellikon'),
(1539, 'Rekingen (AG)'),
(1540, 'Rietheim'),
(1541, 'Rümikon'),
(1542, 'Schneisingen'),
(1543, 'Siglistorf'),
(1544, 'Tegerfelden'),
(1545, 'Wislikofen'),
(1546, 'Bad Zurzach'),
(1547, 'Arbon'),
(1548, 'Dozwil'),
(1549, 'Egnach'),
(1550, 'Hefenhofen'),
(1551, 'Horn'),
(1552, 'Kesswil'),
(1553, 'Roggwil (TG)'),
(1554, 'Romanshorn'),
(1555, 'Salmsach'),
(1556, 'Sommeri'),
(1557, 'Uttwil'),
(1558, 'Amriswil'),
(1559, 'Bischofszell'),
(1560, 'Erlen'),
(1561, 'Hauptwil-Gottshaus'),
(1562, 'Hohentannen'),
(1563, 'Kradolf-Schönenberg'),
(1564, 'Sulgen'),
(1565, 'Zihlschlacht-Sitterdorf'),
(1566, 'Basadingen-Schlattingen'),
(1567, 'Diessenhofen'),
(1568, 'Schlatt (TG)'),
(1569, 'Aadorf'),
(1570, 'Felben-Wellhausen'),
(1571, 'Frauenfeld'),
(1572, 'Gachnang'),
(1573, 'Hüttlingen'),
(1574, 'Matzingen'),
(1575, 'Neunforn'),
(1576, 'Stettfurt'),
(1577, 'Thundorf'),
(1578, 'Uesslingen-Buch'),
(1579, 'Warth-Weiningen'),
(1580, 'Altnau'),
(1581, 'Bottighofen'),
(1582, 'Ermatingen'),
(1583, 'Gottlieben'),
(1584, 'Güttingen'),
(1585, 'Kemmental'),
(1586, 'Kreuzlingen'),
(1587, 'Langrickenbach'),
(1588, 'Lengwil'),
(1589, 'Münsterlingen'),
(1590, 'Tägerwilen'),
(1591, 'Wäldi'),
(1592, 'Affeltrangen'),
(1593, 'Bettwiesen'),
(1594, 'Bichelsee-Balterswil'),
(1595, 'Braunau'),
(1596, 'Eschlikon'),
(1597, 'Fischingen'),
(1598, 'Lommis'),
(1599, 'Münchwilen (TG)'),
(1600, 'Rickenbach (TG)'),
(1601, 'Schönholzerswilen'),
(1602, 'Sirnach'),
(1603, 'Tobel-Tägerschen'),
(1604, 'Wängi'),
(1605, 'Wilen (TG)'),
(1606, 'Wuppenau'),
(1607, 'Berlingen'),
(1608, 'Eschenz'),
(1609, 'Herdern'),
(1610, 'Homburg'),
(1611, 'Hüttwilen'),
(1612, 'Mammern'),
(1613, 'Müllheim'),
(1614, 'Pfyn'),
(1615, 'Raperswilen'),
(1616, 'Salenstein'),
(1617, 'Steckborn'),
(1618, 'Wagenhausen'),
(1619, 'Amlikon-Bissegg'),
(1620, 'Berg (TG)'),
(1621, 'Birwinken'),
(1622, 'Bürglen (TG)'),
(1623, 'Bussnang'),
(1624, 'Märstetten'),
(1625, 'Weinfelden'),
(1626, 'Wigoltingen'),
(1627, 'Arbedo-Castione'),
(1628, 'Bellinzona'),
(1629, 'Cadenazzo'),
(1630, 'Camorino'),
(1631, 'Giubiasco'),
(1632, 'Gnosca'),
(1633, 'Gorduno'),
(1634, 'Gudo'),
(1635, 'Isone'),
(1636, 'Lumino'),
(1637, 'Moleno'),
(1638, 'Monte Carasso'),
(1639, 'Pianezzo'),
(1640, 'Preonzo'),
(1641, 'Sant''Antonino'),
(1642, 'Sant''Antonio'),
(1643, 'Sementina'),
(1644, 'Acquarossa'),
(1645, 'Blenio'),
(1646, 'Serravalle'),
(1647, 'Airolo'),
(1648, 'Bedretto'),
(1649, 'Bodio'),
(1650, 'Dalpe'),
(1651, 'Faido'),
(1652, 'Giornico'),
(1653, 'Personico'),
(1654, 'Pollegio'),
(1655, 'Prato (Leventina)'),
(1656, 'Quinto'),
(1657, 'Sobrio'),
(1658, 'Ascona'),
(1659, 'Brione (Verzasca)'),
(1660, 'Brione sopra Minusio'),
(1661, 'Brissago'),
(1662, 'Corippo'),
(1663, 'Frasco'),
(1664, 'Gordola'),
(1665, 'Gresso'),
(1666, 'Lavertezzo'),
(1667, 'Locarno'),
(1668, 'Losone'),
(1669, 'Mergoscia'),
(1670, 'Minusio'),
(1671, 'Mosogno'),
(1672, 'Muralto'),
(1673, 'Orselina'),
(1674, 'Ronco sopra Ascona'),
(1675, 'Sonogno'),
(1676, 'Tenero-Contra'),
(1677, 'Vergeletto'),
(1678, 'Vogorno'),
(1679, 'Onsernone'),
(1680, 'Isorno'),
(1681, 'Cugnasco-Gerra'),
(1682, 'Agno'),
(1683, 'Aranno'),
(1684, 'Arogno'),
(1685, 'Astano'),
(1686, 'Bedano'),
(1687, 'Bedigliora'),
(1688, 'Bioggio'),
(1689, 'Bissone'),
(1690, 'Brusino Arsizio'),
(1691, 'Cademario'),
(1692, 'Cadempino'),
(1693, 'Canobbio'),
(1694, 'Caslano'),
(1695, 'Comano'),
(1696, 'Croglio'),
(1697, 'Cureglia'),
(1698, 'Curio'),
(1699, 'Grancia'),
(1700, 'Gravesano'),
(1701, 'Lamone'),
(1702, 'Lugano'),
(1703, 'Magliaso'),
(1704, 'Manno'),
(1705, 'Maroggia'),
(1706, 'Massagno'),
(1707, 'Melano'),
(1708, 'Melide'),
(1709, 'Mezzovico-Vira'),
(1710, 'Miglieglia'),
(1711, 'Monteggio'),
(1712, 'Morcote'),
(1713, 'Muzzano'),
(1714, 'Neggio'),
(1715, 'Novaggio'),
(1716, 'Origlio'),
(1717, 'Paradiso'),
(1718, 'Ponte Capriasca'),
(1719, 'Ponte Tresa'),
(1720, 'Porza'),
(1721, 'Pura'),
(1722, 'Rovio'),
(1723, 'Savosa'),
(1724, 'Sessa'),
(1725, 'Sorengo'),
(1726, 'Capriasca'),
(1727, 'Torricella-Taverne'),
(1728, 'Vernate'),
(1729, 'Vezia'),
(1730, 'Vico Morcote'),
(1731, 'Collina d''Oro'),
(1732, 'Alto Malcantone'),
(1733, 'Monteceneri'),
(1734, 'Balerna'),
(1735, 'Castel San Pietro'),
(1736, 'Chiasso'),
(1737, 'Coldrerio'),
(1738, 'Mendrisio'),
(1739, 'Morbio Inferiore'),
(1740, 'Novazzano'),
(1741, 'Riva San Vitale'),
(1742, 'Stabio'),
(1743, 'Vacallo'),
(1744, 'Breggia'),
(1745, 'Biasca'),
(1746, 'Claro'),
(1747, 'Cresciano'),
(1748, 'Iragna'),
(1749, 'Lodrino'),
(1750, 'Osogna'),
(1751, 'Bosco/Gurin'),
(1752, 'Campo (Vallemaggia)'),
(1753, 'Cerentino'),
(1754, 'Cevio'),
(1755, 'Linescio'),
(1756, 'Maggia'),
(1757, 'Lavizzara'),
(1758, 'Avegno Gordevio'),
(1759, 'Terre di Pedemonte'),
(1760, 'Centovalli'),
(1761, 'Gambarogno'),
(1762, 'Aigle'),
(1763, 'Bex'),
(1764, 'Chessel'),
(1765, 'Corbeyrier'),
(1766, 'Gryon'),
(1767, 'Lavey-Morcles'),
(1768, 'Leysin'),
(1769, 'Noville'),
(1770, 'Ollon'),
(1771, 'Ormont-Dessous'),
(1772, 'Ormont-Dessus'),
(1773, 'Rennaz'),
(1774, 'Roche (VD)'),
(1775, 'Villeneuve (VD)'),
(1776, 'Yvorne'),
(1777, 'Apples'),
(1778, 'Aubonne'),
(1779, 'Ballens'),
(1780, 'Berolle'),
(1781, 'Bière'),
(1782, 'Bougy-Villars'),
(1783, 'Féchy'),
(1784, 'Gimel'),
(1785, 'Longirod'),
(1786, 'Marchissy'),
(1787, 'Mollens (VD)'),
(1788, 'Montherod'),
(1789, 'Saint-George'),
(1790, 'Saint-Livres'),
(1791, 'Saint-Oyens'),
(1792, 'Saubraz'),
(1793, 'Avenches'),
(1794, 'Cudrefin'),
(1795, 'Faoug'),
(1796, 'Vully-les-Lacs'),
(1797, 'Bettens'),
(1798, 'Bournens'),
(1799, 'Boussens'),
(1800, 'La Chaux (Cossonay)'),
(1801, 'Chavannes-le-Veyron'),
(1802, 'Chevilly'),
(1803, 'Cossonay'),
(1804, 'Cottens (VD)'),
(1805, 'Cuarnens'),
(1806, 'Daillens'),
(1807, 'Dizy'),
(1808, 'Eclépens'),
(1809, 'Ferreyres'),
(1810, 'Gollion'),
(1811, 'Grancy'),
(1812, 'L''Isle'),
(1813, 'Lussery-Villars'),
(1814, 'Mauraz'),
(1815, 'Mex (VD)'),
(1816, 'Moiry'),
(1817, 'Mont-la-Ville'),
(1818, 'Montricher'),
(1819, 'Orny'),
(1820, 'Pampigny'),
(1821, 'Penthalaz'),
(1822, 'Penthaz'),
(1823, 'Pompaples'),
(1824, 'La Sarraz'),
(1825, 'Senarclens'),
(1826, 'Sévery'),
(1827, 'Sullens'),
(1828, 'Vufflens-la-Ville'),
(1829, 'Assens'),
(1830, 'Bercher'),
(1831, 'Bioley-Orjulaz'),
(1832, 'Bottens'),
(1833, 'Bretigny-sur-Morrens'),
(1834, 'Cugy (VD)'),
(1835, 'Echallens'),
(1836, 'Essertines-sur-Yverdon'),
(1837, 'Etagnières'),
(1838, 'Fey'),
(1839, 'Froideville'),
(1840, 'Morrens (VD)'),
(1841, 'Oulens-sous-Echallens'),
(1842, 'Pailly'),
(1843, 'Penthéréaz'),
(1844, 'Poliez-Pittet'),
(1845, 'Rueyres'),
(1846, 'Saint-Barthélemy (VD)'),
(1847, 'Villars-le-Terroir'),
(1848, 'Vuarrens'),
(1849, 'Montilliez'),
(1850, 'Goumoëns'),
(1851, 'Bonvillars'),
(1852, 'Bullet'),
(1853, 'Champagne'),
(1854, 'Concise'),
(1855, 'Corcelles-près-Concise'),
(1856, 'Fiez'),
(1857, 'Fontaines-sur-Grandson'),
(1858, 'Giez'),
(1859, 'Grandevent'),
(1860, 'Grandson'),
(1861, 'Mauborget'),
(1862, 'Mutrux'),
(1863, 'Novalles'),
(1864, 'Onnens (VD)'),
(1865, 'Provence'),
(1866, 'Sainte-Croix'),
(1867, 'Tévenon'),
(1868, 'Belmont-sur-Lausanne'),
(1869, 'Cheseaux-sur-Lausanne'),
(1870, 'Crissier'),
(1871, 'Epalinges'),
(1872, 'Jouxtens-Mézery'),
(1873, 'Lausanne'),
(1874, 'Le Mont-sur-Lausanne'),
(1875, 'Paudex'),
(1876, 'Prilly'),
(1877, 'Pully'),
(1878, 'Renens (VD)'),
(1879, 'Romanel-sur-Lausanne'),
(1880, 'Chexbres'),
(1881, 'Forel (Lavaux)'),
(1882, 'Lutry'),
(1883, 'Puidoux'),
(1884, 'Rivaz'),
(1885, 'Saint-Saphorin (Lavaux)'),
(1886, 'Savigny'),
(1887, 'Bourg-en-Lavaux'),
(1888, 'Aclens'),
(1889, 'Bremblens'),
(1890, 'Buchillon'),
(1891, 'Bussigny-près-Lausanne'),
(1892, 'Bussy-Chardonney'),
(1893, 'Chavannes-près-Renens'),
(1894, 'Chigny'),
(1895, 'Clarmont'),
(1896, 'Denens'),
(1897, 'Denges'),
(1898, 'Echandens'),
(1899, 'Echichens'),
(1900, 'Ecublens (VD)'),
(1901, 'Etoy'),
(1902, 'Lavigny'),
(1903, 'Lonay'),
(1904, 'Lully (VD)'),
(1905, 'Lussy-sur-Morges'),
(1906, 'Morges'),
(1907, 'Préverenges'),
(1908, 'Reverolle'),
(1909, 'Romanel-sur-Morges'),
(1910, 'Saint-Prex'),
(1911, 'Saint-Sulpice (VD)'),
(1912, 'Tolochenaz'),
(1913, 'Vaux-sur-Morges'),
(1914, 'Villars-Sainte-Croix'),
(1915, 'Villars-sous-Yens'),
(1916, 'Vufflens-le-Château'),
(1917, 'Vullierens'),
(1918, 'Yens'),
(1919, 'Boulens'),
(1920, 'Brenles'),
(1921, 'Bussy-sur-Moudon'),
(1922, 'Chavannes-sur-Moudon'),
(1923, 'Chesalles-sur-Moudon'),
(1924, 'Cremin'),
(1925, 'Curtilles'),
(1926, 'Dompierre (VD)'),
(1927, 'Forel-sur-Lucens'),
(1928, 'Hermenches'),
(1929, 'Lovatens'),
(1930, 'Lucens'),
(1931, 'Moudon'),
(1932, 'Ogens'),
(1933, 'Prévonloup'),
(1934, 'Rossenges'),
(1935, 'Sarzens'),
(1936, 'Syens'),
(1937, 'Villars-le-Comte'),
(1938, 'Vucherens'),
(1939, 'Montanaire'),
(1940, 'Arnex-sur-Nyon'),
(1941, 'Arzier'),
(1942, 'Bassins'),
(1943, 'Begnins'),
(1944, 'Bogis-Bossey'),
(1945, 'Borex'),
(1946, 'Chavannes-de-Bogis'),
(1947, 'Chavannes-des-Bois'),
(1948, 'Chéserex'),
(1949, 'Coinsins'),
(1950, 'Commugny'),
(1951, 'Coppet'),
(1952, 'Crans-près-Céligny'),
(1953, 'Crassier'),
(1954, 'Duillier'),
(1955, 'Eysins'),
(1956, 'Founex'),
(1957, 'Genolier'),
(1958, 'Gingins'),
(1959, 'Givrins'),
(1960, 'Gland'),
(1961, 'Grens'),
(1962, 'Mies'),
(1963, 'Nyon'),
(1964, 'Prangins'),
(1965, 'La Rippe'),
(1966, 'Saint-Cergue'),
(1967, 'Signy-Avenex'),
(1968, 'Tannay'),
(1969, 'Trélex'),
(1970, 'Le Vaud'),
(1971, 'Vich'),
(1972, 'L''Abergement'),
(1973, 'Agiez'),
(1974, 'Arnex-sur-Orbe'),
(1975, 'Ballaigues'),
(1976, 'Baulmes'),
(1977, 'Bavois'),
(1978, 'Bofflens'),
(1979, 'Bretonnières'),
(1980, 'Chavornay'),
(1981, 'Les Clées'),
(1982, 'Corcelles-sur-Chavornay'),
(1983, 'Croy'),
(1984, 'Juriens'),
(1985, 'Lignerolle'),
(1986, 'Montcherand'),
(1987, 'Orbe'),
(1988, 'La Praz'),
(1989, 'Premier'),
(1990, 'Rances'),
(1991, 'Romainmôtier-Envy'),
(1992, 'Sergey'),
(1993, 'Valeyres-sous-Rances'),
(1994, 'Vallorbe'),
(1995, 'Vaulion'),
(1996, 'Vuiteboeuf'),
(1997, 'Carrouge (VD)'),
(1998, 'Corcelles-le-Jorat'),
(1999, 'Essertes'),
(2000, 'Ferlens (VD)'),
(2001, 'Maracon'),
(2002, 'Mézières (VD)'),
(2003, 'Montpreveyres'),
(2004, 'Ropraz'),
(2005, 'Servion'),
(2006, 'Vulliens'),
(2007, 'Jorat-Menthue'),
(2008, 'Oron'),
(2009, 'Champtauroz'),
(2010, 'Chevroux'),
(2011, 'Corcelles-près-Payerne'),
(2012, 'Grandcour'),
(2013, 'Henniez'),
(2014, 'Missy'),
(2015, 'Payerne'),
(2016, 'Trey'),
(2017, 'Treytorrens (Payerne)'),
(2018, 'Villarzel'),
(2019, 'Valbroye'),
(2020, 'Château-d''Oex'),
(2021, 'Rossinière'),
(2022, 'Rougemont'),
(2023, 'Allaman'),
(2024, 'Bursinel'),
(2025, 'Bursins'),
(2026, 'Burtigny'),
(2027, 'Dully'),
(2028, 'Essertines-sur-Rolle'),
(2029, 'Gilly'),
(2030, 'Luins'),
(2031, 'Mont-sur-Rolle'),
(2032, 'Perroy'),
(2033, 'Rolle'),
(2034, 'Tartegnin'),
(2035, 'Vinzel'),
(2036, 'L''Abbaye'),
(2037, 'Le Chenit'),
(2038, 'Le Lieu'),
(2039, 'Blonay'),
(2040, 'Chardonne'),
(2041, 'Corseaux'),
(2042, 'Corsier-sur-Vevey'),
(2043, 'Jongny'),
(2044, 'Montreux'),
(2045, 'Saint-Légier-La Chiésaz'),
(2046, 'La Tour-de-Peilz'),
(2047, 'Vevey'),
(2048, 'Veytaux'),
(2049, 'Belmont-sur-Yverdon'),
(2050, 'Bioley-Magnoux'),
(2051, 'Chamblon'),
(2052, 'Champvent'),
(2053, 'Chavannes-le-Chêne'),
(2054, 'Chêne-Pâquier'),
(2055, 'Cheseaux-Noréaz'),
(2056, 'Cronay'),
(2057, 'Cuarny'),
(2058, 'Démoret'),
(2059, 'Donneloye'),
(2060, 'Ependes (VD)'),
(2061, 'Essert-Pittet'),
(2062, 'Mathod'),
(2063, 'Molondin'),
(2064, 'Montagny-près-Yverdon'),
(2065, 'Oppens'),
(2066, 'Orges'),
(2067, 'Orzens'),
(2068, 'Pomy'),
(2069, 'Rovray'),
(2070, 'Suchy'),
(2071, 'Suscévaz'),
(2072, 'Treycovagnes'),
(2073, 'Ursins'),
(2074, 'Valeyres-sous-Montagny'),
(2075, 'Valeyres-sous-Ursins'),
(2076, 'Villars-Epeney'),
(2077, 'Vugelles-La Mothe'),
(2078, 'Yverdon-les-Bains'),
(2079, 'Yvonand'),
(2080, 'Brig-Glis'),
(2081, 'Eggerberg'),
(2082, 'Naters'),
(2083, 'Ried-Brig'),
(2084, 'Simplon'),
(2085, 'Termen'),
(2086, 'Zwischbergen'),
(2087, 'Ardon'),
(2088, 'Chamoson'),
(2089, 'Conthey'),
(2090, 'Nendaz'),
(2091, 'Vétroz'),
(2092, 'Bagnes'),
(2093, 'Bourg-Saint-Pierre'),
(2094, 'Liddes'),
(2095, 'Orsières'),
(2096, 'Sembrancher'),
(2097, 'Vollèges'),
(2098, 'Bellwald'),
(2099, 'Binn'),
(2100, 'Blitzingen'),
(2101, 'Ernen'),
(2102, 'Fiesch'),
(2103, 'Fieschertal'),
(2104, 'Lax'),
(2105, 'Niederwald'),
(2106, 'Grafschaft'),
(2107, 'Münster-Geschinen'),
(2108, 'Reckingen-Gluringen'),
(2109, 'Obergoms'),
(2110, 'Les Agettes'),
(2111, 'Ayent'),
(2112, 'Evolène'),
(2113, 'Hérémence'),
(2114, 'Saint-Martin (VS)'),
(2115, 'Vex'),
(2116, 'Mont-Noble'),
(2117, 'Agarn'),
(2118, 'Albinen'),
(2119, 'Ergisch'),
(2120, 'Inden'),
(2121, 'Leuk'),
(2122, 'Leukerbad'),
(2123, 'Oberems'),
(2124, 'Salgesch'),
(2125, 'Varen'),
(2126, 'Guttet-Feschel'),
(2127, 'Gampel-Bratsch'),
(2128, 'Turtmann-Unterems'),
(2129, 'Bovernier'),
(2130, 'Charrat'),
(2131, 'Fully'),
(2132, 'Isérables'),
(2133, 'Leytron'),
(2134, 'Martigny'),
(2135, 'Martigny-Combe'),
(2136, 'Riddes'),
(2137, 'Saillon'),
(2138, 'Saxon'),
(2139, 'Trient'),
(2140, 'Champéry'),
(2141, 'Collombey-Muraz'),
(2142, 'Monthey'),
(2143, 'Port-Valais'),
(2144, 'Saint-Gingolph'),
(2145, 'Troistorrents'),
(2146, 'Val-d''Illiez'),
(2147, 'Vionnaz'),
(2148, 'Vouvry'),
(2149, 'Bister'),
(2150, 'Bitsch'),
(2151, 'Grengiols'),
(2152, 'Riederalp'),
(2153, 'Ausserberg'),
(2154, 'Blatten'),
(2155, 'Bürchen'),
(2156, 'Eischoll'),
(2157, 'Ferden'),
(2158, 'Kippel'),
(2159, 'Niedergesteln'),
(2160, 'Raron'),
(2161, 'Unterbäch'),
(2162, 'Wiler (Lötschen)'),
(2163, 'Mörel-Filet'),
(2164, 'Steg-Hohtenn'),
(2165, 'Bettmeralp'),
(2166, 'Collonges'),
(2167, 'Dorénaz'),
(2168, 'Evionnaz'),
(2169, 'Finhaut'),
(2170, 'Massongex'),
(2171, 'Saint-Maurice'),
(2172, 'Salvan'),
(2173, 'Vernayaz'),
(2174, 'Vérossaz'),
(2175, 'Chalais'),
(2176, 'Chermignon'),
(2177, 'Chippis'),
(2178, 'Grône'),
(2179, 'Icogne'),
(2180, 'Lens'),
(2181, 'Miège'),
(2182, 'Mollens (VS)'),
(2183, 'Montana'),
(2184, 'Randogne'),
(2185, 'Saint-Léonard'),
(2186, 'Sierre'),
(2187, 'Venthône'),
(2188, 'Veyras'),
(2189, 'Anniviers'),
(2190, 'Arbaz'),
(2191, 'Grimisuat'),
(2192, 'Savièse'),
(2193, 'Sion'),
(2194, 'Veysonnaz'),
(2195, 'Baltschieder'),
(2196, 'Eisten'),
(2197, 'Embd'),
(2198, 'Grächen'),
(2199, 'Lalden'),
(2200, 'Randa'),
(2201, 'Saas-Almagell'),
(2202, 'Saas-Balen'),
(2203, 'Saas-Fee'),
(2204, 'Saas-Grund'),
(2205, 'St. Niklaus'),
(2206, 'Stalden (VS)'),
(2207, 'Staldenried'),
(2208, 'Täsch'),
(2209, 'Törbel'),
(2210, 'Visp'),
(2211, 'Visperterminen'),
(2212, 'Zeneggen'),
(2213, 'Zermatt'),
(2214, 'Bevaix'),
(2215, 'Boudry'),
(2216, 'Brot-Dessous'),
(2217, 'Corcelles-Cormondrèche'),
(2218, 'Cortaillod'),
(2219, 'Fresens'),
(2220, 'Gorgier'),
(2221, 'Montalchez'),
(2222, 'Peseux'),
(2223, 'Rochefort'),
(2224, 'Saint-Aubin-Sauges'),
(2225, 'Vaumarcus'),
(2226, 'Milvignes'),
(2227, 'La Chaux-de-Fonds'),
(2228, 'Les Planchettes'),
(2229, 'La Sagne'),
(2230, 'Les Brenets'),
(2231, 'La Brévine'),
(2232, 'Brot-Plamboz'),
(2233, 'Le Cerneux-Péquignot'),
(2234, 'La Chaux-du-Milieu'),
(2235, 'Le Locle'),
(2236, 'Les Ponts-de-Martel'),
(2237, 'Cornaux'),
(2238, 'Cressier (NE)'),
(2239, 'Enges'),
(2240, 'Hauterive (NE)'),
(2241, 'Le Landeron'),
(2242, 'Lignières'),
(2243, 'Neuchâtel'),
(2244, 'Saint-Blaise'),
(2245, 'La Tène'),
(2246, 'Valangin'),
(2247, 'Val-de-Ruz'),
(2248, 'La Côte-aux-Fées'),
(2249, 'Les Verrières'),
(2250, 'Val-de-Travers'),
(2251, 'Aire-la-Ville'),
(2252, 'Anières'),
(2253, 'Avully'),
(2254, 'Avusy'),
(2255, 'Bardonnex'),
(2256, 'Bellevue'),
(2257, 'Bernex'),
(2258, 'Carouge (GE)'),
(2259, 'Cartigny'),
(2260, 'Céligny'),
(2261, 'Chancy'),
(2262, 'Chêne-Bougeries'),
(2263, 'Chêne-Bourg'),
(2264, 'Choulex'),
(2265, 'Collex-Bossy'),
(2266, 'Collonge-Bellerive'),
(2267, 'Cologny'),
(2268, 'Confignon'),
(2269, 'Corsier (GE)'),
(2270, 'Dardagny'),
(2271, 'Genève'),
(2272, 'Genthod'),
(2273, 'Le Grand-Saconnex'),
(2274, 'Gy'),
(2275, 'Hermance'),
(2276, 'Jussy'),
(2277, 'Laconnex'),
(2278, 'Lancy'),
(2279, 'Meinier'),
(2280, 'Meyrin'),
(2281, 'Onex'),
(2282, 'Perly-Certoux'),
(2283, 'Plan-les-Ouates'),
(2284, 'Pregny-Chambésy'),
(2285, 'Presinge'),
(2286, 'Puplinge'),
(2287, 'Russin'),
(2288, 'Satigny'),
(2289, 'Soral'),
(2290, 'Thônex'),
(2291, 'Troinex'),
(2292, 'Vandoeuvres'),
(2293, 'Vernier'),
(2294, 'Versoix'),
(2295, 'Veyrier'),
(2296, 'Boécourt'),
(2297, 'Bourrignon'),
(2298, 'Châtillon (JU)'),
(2299, 'Corban'),
(2300, 'Courchapoix'),
(2301, 'Courrendlin'),
(2302, 'Courroux'),
(2303, 'Courtételle'),
(2304, 'Delémont'),
(2305, 'Develier'),
(2306, 'Ederswiler'),
(2307, 'Mervelier'),
(2308, 'Mettembert'),
(2309, 'Movelier'),
(2310, 'Pleigne'),
(2311, 'Rebeuvelier'),
(2312, 'Rossemaison'),
(2313, 'Saulcy'),
(2314, 'Soyhières'),
(2315, 'Vellerat'),
(2316, 'Haute-Sorne'),
(2317, 'Val Terbi'),
(2318, 'Le Bémont (JU)'),
(2319, 'Les Bois'),
(2320, 'Les Breuleux'),
(2321, 'La Chaux-des-Breuleux'),
(2322, 'Les Enfers'),
(2323, 'Les Genevez (JU)'),
(2324, 'Lajoux (JU)'),
(2325, 'Montfaucon'),
(2326, 'Muriaux'),
(2327, 'Le Noirmont'),
(2328, 'Saignelégier'),
(2329, 'Saint-Brais'),
(2330, 'Soubey'),
(2331, 'Alle'),
(2332, 'Beurnevésin'),
(2333, 'Boncourt'),
(2334, 'Bonfol'),
(2335, 'Bure'),
(2336, 'Coeuve'),
(2337, 'Cornol'),
(2338, 'Courchavon'),
(2339, 'Courgenay'),
(2340, 'Courtedoux'),
(2341, 'Damphreux'),
(2342, 'Fahy'),
(2343, 'Fontenais'),
(2344, 'Grandfontaine'),
(2345, 'Lugnez'),
(2346, 'Porrentruy'),
(2347, 'Rocourt'),
(2348, 'Vendlincourt'),
(2349, 'Basse-Allaine'),
(2350, 'Clos du Doubs'),
(2351, 'Haute-Ajoie'),
(2352, 'La Baroche');
-- --------------------------------------------------------
--
-- Structure de la table `users`
--
CREATE TABLE IF NOT EXISTS `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`cpnvId` varchar(45) DEFAULT NULL,
`firstname` varchar(80) DEFAULT NULL,
`lastname` varchar(80) DEFAULT NULL,
`email` varchar(60) DEFAULT NULL,
`telephone` varchar(45) DEFAULT NULL,
`hideEmail` int(11) DEFAULT NULL,
`hideTelephone` int(11) DEFAULT NULL,
`notifInscription` int(11) DEFAULT NULL,
`notifDeleteRide` int(11) DEFAULT NULL,
`notifModification` int(11) DEFAULT NULL,
`notifComment` int(11) DEFAULT NULL,
`blacklisted` int(11) DEFAULT NULL,
`admin` int(11) DEFAULT NULL,
`token` varchar(255) DEFAULT NULL,
`validbefore` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `token` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=103 ;
--
-- Contenu de la table `users`
--
INSERT INTO `users` (`id`, `cpnvId`, `firstname`, `lastname`, `email`, `telephone`, `hideEmail`, `hideTelephone`, `notifInscription`, `notifComment`, `notifDeleteRide`, `notifModification`, `blacklisted`, `admin`, `token`, `validbefore`) VALUES
(1, 'axel_piaget', 'Axel', 'Piaget', 'axel.piaget@cpnv.ch', '0797007845', 0, 0, 1, 1, 1, 1, 1, 0, 'asdf', '2017-02-07 11:46:54'),
(2, 'elliott_chiaradia', 'Elliott', 'Chiaradia', 'elliott.chiaradia@cpnv.ch', '0797007666', 0, 0, 1, 1, 1, 1, 0, 0, 'bbbb', '2017-03-02 00:00:00'),
(3, 'ADW89XDL2LD', 'Guinevere', 'Diaz', 'ipsum@arcu.edu', '08 98 83 83 30', 0, 0, 1, 0, 1, 0, 1, 0, 'COZ55VNE7DS', '2017-03-02 00:00:00'),
(4, 'ZSU29EVG6LS', 'Shoshana', 'Callahan', 'ac.turpis.egestas@ac.edu', '07 92 05 18 87', 1, 1, 0, 1, 0, 0, 0, 0, 'OHI87ETL4AK', '2017-05-25 00:00:00'),
(5, 'AGY20GHE5IA', 'Kelsey', 'Frye', 'consequat.enim.diam@Maurisblanditenim.org', '08 38 62 40 59', 0, 0, 1, 0, 1, 1, 0, 0, 'RRO19BQD9KY', '2017-01-06 00:00:00'),
(6, 'LMY06FBV2SQ', 'Shellie', 'David', 'eu.elit@dui.ca', '03 26 81 22 91', 0, 0, 0, 1, 1, 1, 0, 0, 'XJJ88JOS1VG', '2017-10-12 00:00:00'),
(7, 'LTG35QBX6WF', 'Amity', 'Holcomb', 'sollicitudin@tempor.com', '06 41 88 09 64', 0, 1, 0, 1, 0, 0, 0, 0, 'VCW35PKH5KY', '2017-04-24 00:00:00'),
(8, 'FVY17IGE8PI', 'Dacey', 'Vasquez', 'tellus.eu.augue@tempor.net', '08 92 66 53 76', 0, 1, 1, 1, 0, 1, 0, 1, 'MAO30TFI3KR', '2017-11-20 00:00:00'),
(9, 'BSG05JQU6KO', 'Vielka', 'Ward', 'Quisque@dictumeu.org', '08 59 10 52 51', 0, 0, 1, 0, 0, 1, 0, 1, 'LRZ96LPH8EY', '2017-11-13 00:00:00'),
(10, 'IEH77CIP8JS', 'Cyrus', 'Browning', 'id@Donec.edu', '01 14 48 46 88', 1, 0, 0, 0, 1, 0, 0, 0, 'BTY35ZEC6UN', '2017-02-21 00:00:00'),
(11, 'USM40IFH9XY', 'Portia', 'West', 'In.condimentum@pellentesquetellussem.co.uk', '04 92 62 96 11', 1, 1, 0, 0, 1, 1, 0, 0, 'QHT34OPQ1MJ', '2017-05-11 00:00:00'),
(12, 'THM41AJR3NH', 'Wynter', 'Lara', 'augue.eu@etrisus.net', '06 07 57 69 21', 0, 1, 0, 0, 0, 0, 0, 0, 'RZP16YED7QN', '2017-03-28 00:00:00'),
(13, 'LUR90ZOM3FL', 'Montana', 'Graham', 'ultricies.ornare.elit@congueelit.org', '06 29 48 48 36', 1, 1, 0, 1, 0, 1, 0, 0, 'MFQ70SGQ6SR', '2017-08-02 00:00:00'),
(14, 'NQI41MAE1CZ', 'Elliott', 'Parrish', 'vel.faucibus@molestie.ca', '06 06 57 14 00', 0, 0, 0, 0, 1, 0, 0, 0, 'XBT86HUE3RZ', '2017-05-24 00:00:00'),
(15, 'GWU01PAH2BR', 'Olivia', 'Meadows', 'dictum@nonnisiAenean.edu', '05 64 08 56 13', 0, 1, 1, 0, 0, 0, 0, 0, 'EGA39OQL2OT', '2017-08-18 00:00:00'),
(16, 'FHD87ICJ4TP', 'Ivory', 'Shepherd', 'mauris.erat.eget@placerataugue.net', '06 12 44 24 84', 0, 1, 1, 0, 1, 0, 0, 1, 'EVQ41UHX9WB', '2017-12-09 00:00:00'),
(17, 'JXB25SHN0XE', 'Adam', 'Stout', 'aliquet.vel@nisisemsemper.net', '04 14 93 49 78', 0, 1, 0, 1, 0, 1, 0, 1, 'SSW45ASG8PK', '2017-08-19 00:00:00'),
(18, 'FBW10CGY4TL', 'Nola', 'Morales', 'Cum.sociis@primisinfaucibus.net', '03 95 38 43 73', 0, 0, 1, 1, 0, 1, 0, 1, 'RUI42GQT7JH', '2017-12-16 00:00:00'),
(19, 'WOO17WSI1VP', 'Sharon', 'Miller', 'magna.a@id.net', '05 74 16 08 81', 0, 1, 0, 1, 1, 1, 1, 0, 'LQW32WMZ8SC', '2017-03-14 00:00:00'),
(20, 'VGB40WRF3SV', 'Madonna', 'Ellison', 'ipsum.ac@adipiscingnonluctus.org', '08 40 14 55 23', 1, 0, 1, 1, 0, 0, 0, 0, 'GCM11BGC6IT', '2017-03-19 00:00:00'),
(21, 'DFX55EMU6GI', 'Pandora', 'Santana', 'ac.facilisis@temporbibendumDonec.net', '06 10 74 20 60', 0, 1, 1, 0, 0, 1, 0, 1, 'FAT57EGM2PV', '2017-01-18 00:00:00'),
(22, 'XCB56TVZ6AS', 'Kirestin', 'Lang', 'arcu@etmagnisdis.edu', '03 59 03 75 86', 1, 0, 0, 1, 1, 0, 0, 0, 'SXG95XPS5AA', '2017-02-19 00:00:00'),
(23, 'TFT27ITB8NN', 'Gil', 'Roman', 'ante.Maecenas@elitpedemalesuada.ca', '05 36 14 63 55', 1, 0, 0, 1, 0, 1, 0, 1, 'UFY33EAK5IW', '2017-11-25 00:00:00'),
(24, 'IBU42URN6FN', 'Ashton', 'Rollins', 'Duis.at@dignissimpharetraNam.net', '05 38 09 36 97', 0, 1, 0, 0, 1, 1, 0, 1, 'SZQ66ZXP5ZS', '2017-02-21 00:00:00'),
(25, 'VUW06HYM1WZ', 'Angelica', 'Webb', 'risus.Donec@ultriciesornareelit.ca', '05 69 53 11 48', 1, 0, 0, 1, 1, 0, 0, 0, 'KIJ32BWP4NB', '2017-08-03 00:00:00'),
(26, 'UPA72VCP9AV', 'Fallon', 'Bowen', 'metus.Aenean@Ut.co.uk', '04 53 11 95 55', 0, 1, 0, 0, 0, 0, 1, 1, 'NXJ84UTC4VX', '2017-09-12 00:00:00'),
(27, 'BII36CYH5IE', 'Rinah', 'Stephenson', 'Nunc.mauris@tellusjusto.ca', '02 10 22 57 75', 0, 0, 1, 0, 0, 1, 0, 0, 'JAN31NZL1JR', '2017-12-22 00:00:00'),
(28, 'ALH16YZG8ZJ', 'Francesca', 'Potter', 'velit.Cras@adipiscing.org', '06 84 49 36 85', 0, 0, 1, 1, 1, 0, 0, 1, 'CCS69RPU3MC', '2017-12-04 00:00:00'),
(29, 'RGZ79ZFX8TA', 'Dolan', 'Chaney', 'ultrices.Vivamus.rhoncus@justofaucibuslectus.org', '09 95 67 64 53', 1, 0, 1, 0, 1, 1, 0, 0, 'VNX86VHA7CO', '2017-11-15 00:00:00'),
(30, 'QIK72JYE7AC', 'Fitzgerald', 'Rodriguez', 'ante.Nunc@nonummy.com', '05 61 76 80 66', 0, 1, 1, 1, 0, 1, 0, 1, 'MEW74DMV6JI', '2017-08-29 00:00:00'),
(31, 'VPJ08DPI7TL', 'Brynn', 'Mendez', 'sit.amet.lorem@adipiscing.org', '06 94 75 53 64', 1, 0, 0, 0, 1, 0, 0, 0, 'FEO61HRW2WW', '2017-05-30 00:00:00'),
(32, 'LKB41JIU9RE', 'Luke', 'Boyd', 'lacinia@pharetra.edu', '01 33 61 59 21', 1, 0, 1, 1, 1, 0, 0, 0, 'SXL12IBA7GA', '2017-01-21 00:00:00'),
(33, 'VXV08PET0NA', 'Lionel', 'Woodard', 'sit.amet.massa@Proin.ca', '02 30 75 23 10', 1, 1, 0, 1, 0, 1, 0, 0, 'PIK65PAF9ZV', '2017-06-29 00:00:00'),
(34, 'QJQ63XYQ2ZK', 'Ferdinand', 'Burgess', 'natoque.penatibus.et@netuset.edu', '07 36 80 53 68', 0, 0, 0, 0, 1, 1, 0, 0, 'BRN19CGY2KB', '2017-08-07 00:00:00'),
(35, 'XKG63AVE1JR', 'Brittany', 'Burks', 'at.libero@atauctorullamcorper.org', '04 88 63 42 49', 0, 0, 0, 1, 1, 0, 0, 1, 'TSG56QWD3JK', '2017-02-25 00:00:00'),
(36, 'REW51NQL5TD', 'Laith', 'Roy', 'in@vitaesemperegestas.org', '05 35 50 00 60', 0, 0, 1, 1, 1, 0, 0, 0, 'LTQ93ECH3TT', '2017-02-02 00:00:00'),
(37, 'PNC28LSL6VV', 'Lance', 'Haley', 'aliquam@odiotristiquepharetra.net', '04 47 12 14 21', 0, 1, 1, 0, 1, 1, 0, 1, 'MDG85AXW1VB', '2017-11-06 00:00:00'),
(38, 'GZW15STF4HB', 'Teagan', 'Hernandez', 'dui@rhoncusNullam.net', '02 93 81 58 05', 0, 1, 1, 0, 0, 0, 0, 0, 'ZWM44CJO7EF', '2017-04-02 00:00:00'),
(39, 'XVP35EYR0GV', 'Hayley', 'Landry', 'erat.semper@aptenttaciti.com', '03 99 86 57 55', 1, 0, 0, 1, 0, 1, 0, 1, 'LAE62BVJ0ZR', '2017-05-30 00:00:00'),
(40, 'FWN62LJX9QS', 'Irene', 'Beach', 'tincidunt@erategetipsum.co.uk', '02 61 31 02 53', 0, 1, 0, 0, 1, 0, 0, 0, 'WQS80SHP8LK', '2017-12-07 00:00:00'),
(41, 'AOL91IFE0PB', 'Austin', 'Morin', 'et.malesuada.fames@Proinmi.edu', '09 41 32 90 50', 0, 0, 1, 1, 0, 1, 0, 0, 'PAY00HYZ4PM', '2017-08-24 00:00:00'),
(42, 'TSL73ITC7AX', 'Azalia', 'Anthony', 'volutpat@tinciduntnunc.co.uk', '04 32 76 26 31', 1, 1, 0, 0, 1, 1, 0, 1, 'KIL85UDO6BA', '2017-01-29 00:00:00'),
(43, 'ILF45ARG2FU', 'Alan', 'Oneill', 'euismod.urna@disparturientmontes.co.uk', '01 08 85 30 06', 0, 1, 0, 0, 1, 1, 0, 1, 'TNU41KGY7TM', '2017-01-15 00:00:00'),
(44, 'WNT36BAS2BX', 'Dalton', 'Boone', 'lorem@aaliquetvel.com', '03 43 74 51 28', 0, 0, 0, 0, 1, 0, 1, 0, 'CRS09QMY5HI', '2017-08-31 00:00:00'),
(45, 'TJH98CLN0XL', 'Quinn', 'Callahan', 'vestibulum@vulputaterisusa.edu', '05 12 80 40 02', 1, 0, 1, 0, 1, 0, 0, 0, 'TGD04VZA0PL', '2017-02-02 00:00:00'),
(46, 'TMY58DVR1DM', 'Jade', 'Mcneil', 'diam.dictum@Donecegestas.ca', '06 50 24 99 07', 0, 0, 0, 1, 1, 0, 0, 0, 'BKN40ZIC9DF', '2017-07-24 00:00:00'),
(47, 'LRW02PWF8UC', 'Hiram', 'Gordon', 'ac.tellus@quam.org', '03 94 85 95 61', 1, 1, 1, 0, 0, 0, 1, 0, 'JLH01JTF1CJ', '2017-12-17 00:00:00'),
(48, 'NKE69GIT3SF', 'Maggie', 'Odom', 'Nullam.feugiat.placerat@in.co.uk', '01 46 72 44 87', 0, 1, 0, 0, 1, 0, 0, 1, 'YCP20ZQJ6LU', '2017-11-07 00:00:00'),
(49, 'CNR19VLM1NH', 'Tamekah', 'Hester', 'metus.eu@turpisAliquam.com', '05 03 66 00 21', 0, 1, 1, 0, 0, 1, 0, 1, 'BIA76VQN0RX', '2017-09-13 00:00:00'),
(50, 'GYU68RPQ0DT', 'Porter', 'Barnett', 'adipiscing@enim.edu', '02 35 20 93 13', 0, 0, 1, 1, 1, 1, 0, 1, 'XJT99XAF8RM', '2017-07-01 00:00:00'),
(51, 'EPU76AED9NW', 'Jescie', 'Solis', 'varius.Nam.porttitor@nonummy.org', '01 14 22 70 44', 1, 1, 1, 1, 1, 1, 0, 0, 'GAJ72TIE8BU', '2017-10-09 00:00:00'),
(52, 'XKO65XPF5OP', 'Yoshio', 'Stokes', 'massa.Integer.vitae@blandit.co.uk', '03 44 08 53 74', 0, 1, 0, 1, 1, 1, 0, 1, 'QAS20PDP3VW', '2017-11-22 00:00:00'),
(53, 'JIE35JCQ9ST', 'Quyn', 'Silva', 'justo.nec@velpedeblandit.ca', '04 75 99 80 35', 1, 0, 0, 0, 1, 1, 0, 0, 'JTJ44XMO4WJ', '2017-03-02 00:00:00'),
(54, 'RDF97IAP4CF', 'Reagan', 'Cervantes', 'sapien.Cras@loremac.edu', '05 04 79 66 92', 0, 0, 1, 0, 1, 1, 0, 0, 'OIV79ZRS6EL', '2017-06-02 00:00:00'),
(55, 'MLY97MCD3MR', 'Eve', 'Hurley', 'Donec@vehicula.org', '05 83 99 87 89', 0, 0, 1, 1, 0, 1, 0, 0, 'CEJ82YUB7SZ', '2017-08-21 00:00:00'),
(56, 'APX62FRV5ZW', 'Dominique', 'Evans', 'facilisis@telluseuaugue.ca', '05 51 25 82 88', 1, 1, 1, 1, 0, 1, 0, 1, 'CFN08EPB1YW', '2017-03-01 00:00:00'),
(57, 'LXV11NAC2KJ', 'Morgan', 'Jacobs', 'hendrerit.a@dignissimtempor.org', '08 06 41 21 72', 0, 0, 1, 1, 0, 1, 0, 0, 'XIV66AZJ5KL', '2017-11-26 00:00:00'),
(58, 'CPN36GFA3OC', 'MacKenzie', 'Harrison', 'molestie.dapibus@augueporttitor.net', '08 58 21 58 85', 0, 1, 1, 0, 0, 0, 0, 0, 'QRX46FJR8AQ', '2017-01-12 00:00:00'),
(59, 'EYF94CUR7NY', 'Brianna', 'Wilkerson', 'tempus@duinec.co.uk', '04 78 81 22 17', 1, 0, 1, 0, 0, 0, 0, 1, 'WQZ36UDP7HJ', '2017-03-26 00:00:00'),
(60, 'KBO13GKT6BX', 'Ezekiel', 'Ryan', 'amet.dapibus@Innec.ca', '08 75 51 18 44', 0, 1, 0, 0, 1, 0, 0, 1, 'FNX58ZCU0WQ', '2017-05-23 00:00:00'),
(61, 'XMH18HYA8IM', 'Kasper', 'Craig', 'Morbi.neque.tellus@iaculislacus.co.uk', '08 76 53 79 62', 0, 1, 1, 0, 1, 0, 0, 0, 'TVK32TDP6FE', '2017-05-19 00:00:00'),
(62, 'QAS86GQH1EP', 'Dorothy', 'Conley', 'adipiscing@maurisrhoncus.edu', '04 78 83 21 81', 0, 0, 0, 0, 0, 0, 0, 0, 'XPX44CBI1CB', '2017-06-28 00:00:00'),
(63, 'WOG82IHD8GX', 'Sylvester', 'Walsh', 'sem.mollis@sit.edu', '06 29 09 83 70', 0, 1, 1, 1, 1, 0, 0, 1, 'FYN24LRR3LP', '2017-09-28 00:00:00'),
(64, 'LCK79SAM6AN', 'Katell', 'Patel', 'eros.Proin@dolorsit.ca', '05 07 55 15 56', 1, 0, 1, 0, 1, 1, 0, 0, 'MMP78MVO9NX', '2017-11-30 00:00:00'),
(65, 'HRU80TER8YT', 'Charity', 'Dejesus', 'turpis@tristique.com', '02 58 62 39 44', 1, 0, 1, 1, 1, 0, 0, 1, 'OFX86MNK5EK', '2017-10-25 00:00:00'),
(66, 'DWN06YXN6ZM', 'Adam', 'Pitts', 'Ut.semper@ametluctus.ca', '07 11 49 23 55', 0, 0, 0, 1, 1, 1, 0, 1, 'KOE24JEO6YF', '2017-02-21 00:00:00'),
(67, 'IVI60ZKG1PJ', 'Whitney', 'Benson', 'Integer.in.magna@fringilla.co.uk', '04 41 23 65 47', 0, 0, 0, 0, 0, 0, 0, 0, 'YIT08NNS9CL', '2017-05-23 00:00:00'),
(68, 'ZEA35BBA1YB', 'Astra', 'Fitzgerald', 'vitae.dolor.Donec@Quisque.ca', '06 29 02 61 88', 1, 1, 0, 1, 1, 1, 0, 1, 'BBC43TXZ0GC', '2017-10-10 00:00:00'),
(69, 'SHH99CDC4GB', 'Lilah', 'Harrell', 'pharetra.nibh@faucibusMorbi.com', '02 05 92 22 15', 0, 0, 0, 1, 1, 0, 0, 1, 'ZEL10JKT2BC', '2017-12-25 00:00:00'),
(70, 'VMA09QZO3NS', 'Rhonda', 'Copeland', 'Proin.non@leoMorbi.ca', '01 50 74 11 20', 1, 1, 1, 1, 1, 1, 0, 0, 'BFR09HXF6JZ', '2017-03-25 00:00:00'),
(71, 'EAF05ITD0MR', 'Noel', 'Beach', 'lacus@Vestibulumanteipsum.ca', '07 04 84 21 90', 1, 0, 1, 1, 0, 1, 0, 0, 'XCD04WUZ5MB', '2017-08-22 00:00:00'),
(72, 'MLK03UEO9AT', 'Deanna', 'Kirby', 'amet@nondui.net', '01 62 34 80 58', 0, 1, 0, 1, 0, 0, 1, 0, 'GNN59MFM9FX', '2017-03-17 00:00:00'),
(73, 'ASE02GMK6OL', 'Regan', 'Murray', 'magna@ligulatortor.net', '08 23 68 49 14', 0, 1, 0, 1, 1, 1, 0, 0, 'FQU64VSA2YN', '2017-04-24 00:00:00'),
(74, 'ARD97LZI4JW', 'Eliana', 'Hughes', 'eu@mattissemperdui.co.uk', '09 88 54 70 60', 0, 0, 1, 1, 1, 1, 0, 1, 'WIC52KAV2VO', '2017-01-21 00:00:00'),
(75, 'LAN44SCO2ML', 'Micah', 'Ratliff', 'accumsan.neque.et@idblandit.org', '01 79 24 30 56', 0, 0, 0, 0, 1, 1, 0, 0, 'TMR86GJO0MD', '2017-05-16 00:00:00'),
(76, 'EJF97HTX2BB', 'Timon', 'Crosby', 'dui@etnetuset.edu', '03 30 65 18 72', 1, 0, 1, 0, 1, 1, 1, 1, 'QWW33HCZ6GD', '2017-05-09 00:00:00'),
(77, 'NWD61RXE9FG', 'Grady', 'Mason', 'lacus@consequatlectus.edu', '02 57 52 53 80', 1, 1, 0, 1, 0, 1, 0, 0, 'KIY32HCS0LG', '2017-10-22 00:00:00'),
(78, 'VNN92TDF3YX', 'Yvonne', 'Pitts', 'tempor@arcu.net', '04 69 15 56 83', 0, 0, 1, 0, 0, 1, 0, 0, 'VTB76LGJ2LQ', '2017-07-26 00:00:00'),
(79, 'YWG05KJS7XS', 'Joy', 'Burks', 'lorem.ac.risus@lacusQuisquepurus.net', '09 29 54 34 34', 0, 1, 0, 1, 1, 0, 0, 0, 'ZYG85FTG8BL', '2017-10-28 00:00:00'),
(80, 'RYN21LYY2ZU', 'Kylie', 'Baker', 'nec.ligula@Aenean.net', '06 62 51 63 29', 0, 0, 0, 0, 1, 0, 0, 1, 'RRI80XLR9JU', '2017-02-24 00:00:00'),
(81, 'DOF33FMW7BB', 'Lareina', 'Molina', 'sem.eget@lobortisnisi.com', '05 95 69 30 14', 0, 0, 0, 0, 0, 0, 0, 1, 'RTT56YAI2ZJ', '2017-02-04 00:00:00'),
(82, 'XLP04QZA1GQ', 'Eric', 'Riggs', 'gravida.sit.amet@acmattis.co.uk', '04 83 40 27 60', 0, 1, 0, 0, 1, 1, 0, 1, 'JOP62LXP9BN', '2017-10-06 00:00:00'),
(83, 'CCP34FZS4SU', 'Ronan', 'England', 'iaculis@MaurismagnaDuis.com', '04 47 02 07 64', 0, 1, 1, 0, 0, 1, 0, 0, 'TZY71OCI5TO', '2017-07-28 00:00:00'),
(84, 'XJA84KNR0HS', 'Darrel', 'Jones', 'nisi.sem.semper@Sed.net', '09 64 28 33 57', 0, 1, 1, 1, 1, 0, 1, 0, 'PPG66FYL0AT', '2017-06-24 00:00:00'),
(85, 'TAI20HBH5JN', 'Mohammad', 'Greene', 'commodo.auctor.velit@nullaIn.edu', '01 79 30 89 69', 1, 0, 0, 0, 1, 1, 0, 0, 'TVS63JGT3HO', '2017-11-20 00:00:00'),
(86, 'HKK09TPA4XI', 'Wylie', 'Decker', 'Nullam.suscipit@diamvel.ca', '05 08 60 47 68', 0, 1, 1, 1, 1, 0, 0, 0, 'LXR47CLJ9XC', '2017-04-29 00:00:00'),
(87, 'CZX89WJV7UE', 'Mollie', 'Ingram', 'Sed@blanditcongueIn.org', '07 22 51 23 58', 0, 0, 0, 1, 0, 1, 1, 0, 'JDV04FNC3UT', '2017-07-11 00:00:00'),
(88, 'IXG68SMY1JO', 'Hamilton', 'Chavez', 'imperdiet.erat@liberoduinec.com', '05 20 46 13 86', 1, 0, 0, 1, 0, 0, 0, 1, 'YDP98SMX5SM', '2017-04-24 00:00:00'),
(89, 'LIU59IVO3YK', 'Kenyon', 'William', 'et.ultrices.posuere@sapienNuncpulvinar.edu', '05 49 94 84 08', 1, 1, 1, 0, 0, 0, 0, 1, 'DRW46BVY9KL', '2017-10-08 00:00:00'),
(90, 'THO20OQN2QR', 'Harriet', 'Walters', 'sollicitudin.a@nondapibus.com', '01 00 26 76 49', 0, 1, 0, 1, 0, 1, 0, 1, 'UXQ96HAA8WB', '2017-02-10 00:00:00'),
(91, 'AXL29QSL5JM', 'Meredith', 'Ballard', 'dolor@elitCurabitursed.edu', '04 23 68 19 77', 0, 1, 0, 1, 1, 1, 0, 1, 'GCV21SRX8AP', '2017-04-20 00:00:00'),
(92, 'XTI78TNN8VO', 'Anthony', 'Hayes', 'non@sedorcilobortis.com', '06 94 77 86 59', 1, 1, 1, 0, 0, 1, 1, 0, 'QXX94BUO2RP', '2017-04-13 00:00:00'),
(93, 'KYH09KSC9LU', 'Athena', 'Porter', 'sem.vitae.aliquam@metusAliquamerat.edu', '04 66 50 79 30', 1, 0, 1, 1, 0, 1, 0, 1, 'ZMZ94UWA0FG', '2017-12-02 00:00:00'),
(94, 'JJC15SZE7BE', 'Nissim', 'Mcmahon', 'eget.odio@diam.net', '05 39 05 36 12', 1, 0, 1, 1, 1, 0, 0, 0, 'FTN23FJJ9AY', '2017-06-06 00:00:00'),
(95, 'SVC94KHQ3WU', 'Maia', 'Martin', 'massa.Quisque.porttitor@magnaPraesentinterdum.com', '07 77 67 79 00', 1, 1, 1, 0, 1, 1, 0, 0, 'QCV97GIO2ES', '2017-11-02 00:00:00'),
(96, 'XRG74LDE6NX', 'Constance', 'Lindsay', 'nibh.Phasellus.nulla@justoeu.edu', '01 08 19 70 79', 1, 0, 0, 0, 0, 1, 0, 1, 'TQV06CAU0RX', '2017-09-30 00:00:00'),
(97, 'MZX99GXY7IL', 'Kelsie', 'Tanner', 'eget.lacus.Mauris@commodo.org', '01 83 05 33 14', 0, 0, 0, 0, 1, 1, 0, 1, 'LOD89WVE5NO', '2017-06-22 00:00:00'),
(98, 'AUS38GID8KK', 'Carter', 'Young', 'molestie@sempererat.org', '07 32 44 87 32', 1, 0, 0, 0, 1, 1, 0, 1, 'ZLI87BXI2MV', '2017-07-21 00:00:00'),
(99, 'APP24WFT7YK', 'Daquan', 'Mccarthy', 'mollis@ultricesa.net', '01 76 71 19 28', 0, 0, 0, 0, 1, 0, 0, 1, 'XAD06TZL5BU', '2017-02-14 00:00:00'),
(100, 'WRX84WQR3VL', 'Raymond', 'Beck', 'orci@elit.org', '08 55 12 74 82', 0, 0, 0, 1, 0, 1, 0, 0, 'EFH70XWX7FV', '2017-11-22 00:00:00'),
(101, 'NUA53PRC6BG', 'Quamar', 'Curtis', 'tempus.eu.ligula@Craslorem.org', '02 48 52 09 26', 0, 0, 0, 1, 0, 1, 0, 1, 'RTJ14CVE1OO', '2017-01-08 00:00:00'),
(102, 'EQC05QOY4SB', 'Zachery', 'Chapman', 'aliquam.adipiscing.lacus@rutrumnon.com', '06 65 36 83 15', 0, 0, 1, 1, 0, 0, 0, 1, 'DDO67VXW1QY', '2017-09-22 00:00:00');
-- --------------------------------------------------------
--
-- Structure de la table `votes`
--
CREATE TABLE IF NOT EXISTS `votes` (
`id` int(11) NOT NULL,
`passenger_fk` int(11) NOT NULL,
`targetuser_fk` int(11) NOT NULL,
`vote` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `fk_votes_registrations1_idx` (`passenger_fk`),
KEY `fk_votes_users1_idx` (`targetuser_fk`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Contraintes pour les tables exportées
--
--
-- Contraintes pour la table `comments`
--
ALTER TABLE `comments`
ADD CONSTRAINT `fk_comments_rides1` FOREIGN KEY (`ride_fk`) REFERENCES `rides` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_comments_users1` FOREIGN KEY (`author_fk`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
--
-- Contraintes pour la table `registrations`
--
ALTER TABLE `registrations`
ADD CONSTRAINT `fk_users_has_rides_rides1` FOREIGN KEY (`ride_fk`) REFERENCES `rides` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_users_has_rides_users1` FOREIGN KEY (`user_fk`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
--
-- Contraintes pour la table `ridebadges`
--
ALTER TABLE `ridebadges`
ADD CONSTRAINT `fk_rides_has_badges_badges1` FOREIGN KEY (`badge_fk`) REFERENCES `badges` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_rides_has_badges_rides1` FOREIGN KEY (`ride_fk`) REFERENCES `rides` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
--
-- Contraintes pour la table `rides`
--
ALTER TABLE `rides`
ADD CONSTRAINT `fk_rides_towns1` FOREIGN KEY (`departuretown_fk`) REFERENCES `towns` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_rides_towns2` FOREIGN KEY (`arrivaltown_fk`) REFERENCES `towns` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_rides_users1` FOREIGN KEY (`driver_fk`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
--
-- Contraintes pour la table `votes`
--
ALTER TABLE `votes`
ADD CONSTRAINT `fk_votes_registrations1` FOREIGN KEY (`passenger_fk`) REFERENCES `registrations` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_votes_users1` FOREIGN KEY (`targetuser_fk`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
Download
