--
-- Host: localhost    Database: gestion_demo
-- ------------------------------------------------------


--
-- Table structure for table `adherent_role_types`
--

CREATE TABLE `adherent_role_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `list_name` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `adherent_role_types`
--

INSERT INTO `adherent_role_types` VALUES (1,'Président','president'),(2,'Trésorier','tresorier'),(3,'Trésorier adjoint','tresorier'),(4,'Secrétaire','secretaire'),(5,'Secrétaire Adjoint','secretaire'),(6,'Développement','developpement'),(7,'Référent','referents');

--
-- Table structure for table `adherent_roles`
--

CREATE TABLE `adherent_roles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `adherent_id` int(11) NOT NULL,
  `adherent_role_type_id` int(11) NOT NULL,
  `ville_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `id_adherent` (`adherent_id`),
  KEY `id_adherent_role_type` (`adherent_role_type_id`),
  KEY `id_ville` (`ville_id`),
  CONSTRAINT `adherent_roles_ibfk_1` FOREIGN KEY (`adherent_id`) REFERENCES `adherents` (`id`) ON UPDATE CASCADE,
  CONSTRAINT `adherent_roles_ibfk_2` FOREIGN KEY (`adherent_role_type_id`) REFERENCES `adherent_role_types` (`id`) ON UPDATE CASCADE,
  CONSTRAINT `adherent_roles_ibfk_3` FOREIGN KEY (`ville_id`) REFERENCES `villes` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `adherent_roles`
--

INSERT INTO `adherent_roles` VALUES (1,350,6,NULL),(2,350,7,1);

--
-- Table structure for table `adherent_statuts`
--

CREATE TABLE `adherent_statuts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `title` (`title`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `adherent_statuts`
--

INSERT INTO `adherent_statuts` VALUES (2,'☐ Fiche ☐ Prélev'),(4,'☐ Fiche ☑ Prélev'),(3,'☑ Fiche ☐ Prélev'),(5,'☑ Fiche ☑ Prélev'),(7,'À relancer'),(8,'Bénévole sans service'),(6,'Incohérent'),(1,'Résilié');

--
-- Table structure for table `adherent_types`
--

CREATE TABLE `adherent_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `adherent_types`
--

INSERT INTO `adherent_types` VALUES (1,'Perso'),(2,'Pro'),(3,'Public'),(4,'Asso');

--
-- Table structure for table `adherents`
--

CREATE TABLE `adherents` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id = numéro ADT',
  `nom` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `prenom` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `raison` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `tel_mobile1` varchar(12) COLLATE utf8_unicode_ci DEFAULT NULL,
  `adherent_type_id` int(11) NOT NULL,
  `ville_id` int(11) NOT NULL,
  `adherent_statut_id` int(11) NOT NULL,
  `civilite_id` int(11) NOT NULL,
  `nom2` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `prenom2` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `mail1` varchar(48) COLLATE utf8_unicode_ci DEFAULT NULL,
  `mail2` varchar(48) COLLATE utf8_unicode_ci DEFAULT NULL,
  `adresse1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `adresse2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `tel_fixe1` varchar(12) COLLATE utf8_unicode_ci DEFAULT NULL,
  `tel_fixe2` varchar(12) COLLATE utf8_unicode_ci DEFAULT NULL,
  `tel_mobile2` varchar(12) COLLATE utf8_unicode_ci DEFAULT NULL,
  `num_adt_ttn` char(6) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Date de la première saisie de l''adhérent',
  `modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Date de la dernière modification de l''adhérent',
  `proprio` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `notes` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `ville` (`ville_id`),
  KEY `adherent_type_id` (`adherent_type_id`),
  KEY `civilite_id` (`civilite_id`),
  KEY `adherent_statut` (`adherent_statut_id`),
  CONSTRAINT `adherents_ibfk_1` FOREIGN KEY (`ville_id`) REFERENCES `villes` (`id`) ON UPDATE CASCADE,
  CONSTRAINT `adherents_ibfk_2` FOREIGN KEY (`adherent_type_id`) REFERENCES `adherent_types` (`id`) ON UPDATE CASCADE,
  CONSTRAINT `adherents_ibfk_3` FOREIGN KEY (`civilite_id`) REFERENCES `civilites` (`id`) ON UPDATE CASCADE,
  CONSTRAINT `adherents_ibfk_4` FOREIGN KEY (`adherent_statut_id`) REFERENCES `adherent_statuts` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=352 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Adhérents';

--
-- Dumping data for table `adherents`
--

INSERT INTO `adherents` VALUES (1,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 18:25:58','2016-06-16 18:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(2,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(3,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(4,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(5,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(6,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(7,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(8,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(9,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(10,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(11,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(12,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(13,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(14,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(15,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(16,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(17,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(18,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(19,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(20,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(21,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(22,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(23,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(24,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(25,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(26,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(27,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(28,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(29,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(30,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(31,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(32,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(33,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(34,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(35,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(36,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(37,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(38,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(39,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(40,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(41,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(42,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(43,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(44,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(45,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(46,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(47,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(48,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(49,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(50,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(51,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(52,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(53,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(54,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(55,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(56,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(57,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(58,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(59,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(60,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(61,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(62,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(63,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(64,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(65,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(66,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(67,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(68,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(69,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(70,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(71,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(72,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(73,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(74,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(75,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(76,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(77,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(78,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(79,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(80,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(81,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(82,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(83,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(84,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(85,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(86,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(87,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(88,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(89,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(90,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(91,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(92,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(93,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(94,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(95,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(96,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(97,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(98,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(99,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(100,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(101,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(102,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(103,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(104,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(105,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(106,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(107,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(108,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(109,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(110,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(111,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(112,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(113,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(114,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(115,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(116,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(117,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(118,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(119,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(120,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(121,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(122,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(123,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(124,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(125,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(126,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(127,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(128,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(129,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(130,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(131,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(132,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(133,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(134,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(135,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(136,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(137,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(138,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(139,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(140,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(141,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(142,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(143,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(144,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(145,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(146,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(147,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(148,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(149,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(150,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(151,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(152,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(153,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(154,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(155,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(156,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(157,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(158,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(159,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(160,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(161,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(162,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(163,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(164,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(165,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(166,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(167,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(168,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(169,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(170,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(171,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(172,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(173,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(174,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(175,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(176,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(177,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(178,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(179,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(180,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(181,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(182,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(183,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(184,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(185,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(186,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(187,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(188,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(189,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(190,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(191,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(192,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(193,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(194,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(195,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(196,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(197,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(198,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(199,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(200,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(201,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(202,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(203,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(204,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(205,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(206,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(207,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(208,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(209,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(210,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(211,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(212,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(213,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(214,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(215,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(216,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(217,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(218,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(219,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(220,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(221,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(222,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(223,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(224,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(225,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(226,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(227,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(228,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(229,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(230,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(231,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(232,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(233,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(234,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(235,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(236,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(237,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(238,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(239,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(240,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(241,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(242,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(243,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(244,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(245,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(246,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(247,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(248,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(249,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(250,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(251,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(252,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(253,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(254,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(255,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(256,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(257,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(258,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(259,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(260,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(261,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(262,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(263,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(264,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(265,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(266,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(267,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(268,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(269,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(270,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(271,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(272,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(273,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(274,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(275,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(276,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(277,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(278,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(279,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(280,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(281,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(282,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(283,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(284,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(285,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(286,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(287,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(288,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(289,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(290,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(291,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(292,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(293,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(294,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(295,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(296,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(297,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(298,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(299,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(300,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(301,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(302,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(303,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(304,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(305,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(306,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(307,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(308,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(309,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(310,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(311,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(312,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(313,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(314,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(315,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(316,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(317,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(318,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(319,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(320,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(321,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(322,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(323,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(324,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(325,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(326,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(327,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(328,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(329,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(330,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(331,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(332,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(333,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(334,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(335,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(336,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(337,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(338,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(339,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(340,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(341,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(342,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(343,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(344,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(345,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(346,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(347,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(348,'LOREM','Ipsum','Dolor sit amet','',1,1,5,1,'','','','','','','','','','','2016-06-16 16:25:58','2016-06-16 16:25:58','',' consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),(349,'DURAND','Albert','','',3,1,3,1,'','','','','','','','','','','2016-06-16 18:28:44','2016-06-16 18:28:44','',''),(350,'POUZENC','Ludovic','','0789123456',1,1,5,1,'','','example@domain.com','','1 place de la mairie','','0567891234','','','','2016-06-16 18:22:17','2016-06-16 18:27:37','','Les numéros de téléphones sont faux.');

--
-- Table structure for table `civilites`
--

CREATE TABLE `civilites` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `civilites`
--

INSERT INTO `civilites` VALUES (1,'M.'),(2,'Mme'),(3,'Melle');

--
-- Table structure for table `equipement_modeles`
--

CREATE TABLE `equipement_modeles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `constructeur` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `modele` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `profile` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL,
  `revision` varchar(8) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Modèles d''équipements';

--
-- Dumping data for table `equipement_modeles`
--

INSERT INTO `equipement_modeles` VALUES (1,'Mikrotik','RouterBoard 750UP','',''),(2,'TP-Link','TL-WR740ND v??','TLWR740','4'),(3,'TP-Link','TL-WR740ND v1-3','',''),(4,'TP-Link','TL-WR740ND v4','TLWR740','4'),(5,'TP-Link','TL-WR740ND v5.0','TLWR740','5'),(6,'TP-Link','TL-WR841ND v9','TLWR841','9'),(7,'TP-Link','TL-WR841ND v10','TLWR841','10'),(8,'TP-Link','TL-WR841ND v11','','11'),(10,'Ubiquiti','AirFiber 5X + AF-5G30-S45','',''),(11,'Ubiquiti','AirFiber 5X + Mars 25dBi','',''),(12,'Ubiquiti','NanoBeam M5 16','',''),(13,'Ubiquiti','NanoBeam M5 19','',''),(14,'Ubiquiti','NanoBridge M5 G22','',''),(15,'Ubiquiti','NanoBridge M5 G25','',''),(16,'Ubiquiti','Nanostation M5','',''),(17,'Ubiquiti','Nanostation M5 Loco','',''),(18,'Ubiquiti','PowerBeam M5 400','',''),(19,'Ubiquiti','Rocket M5','',''),(20,'Ubiquiti','ToughSwitch TS5','',''),(21,'Ubiquiti','ToughSwitch TS8','',''),(40,'Netonix','WS-6-MINI','',''),(41,'Mikrotik','RB2011UiAS-2HnD-IN',' ',' '),(42,'Ubiquiti','EdgeMax EdgeSwitch 24-Port 250W','',''),(43,'VM','Linux KVM','',''),(44,'Netonix','8 ports','',''),(45,'Ubiquiti','Nanostation M2 Loco','',''),(46,'TP-Link','TL-WR740ND v5.1','TLWR740','');

--
-- Table structure for table `equipement_modes`
--

CREATE TABLE `equipement_modes` (
  `id` char(8) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `equipement_modes`
--

INSERT INTO `equipement_modes` VALUES ('br-ap'),('br-sta'),('rt-main'),('rt-soho'),('rt-sta'),('switch');

--
-- Table structure for table `equipements`
--

CREATE TABLE `equipements` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uplink_id` int(11) DEFAULT NULL,
  `service_id` int(11) DEFAULT NULL,
  `mac` char(17) COLLATE utf8_unicode_ci NOT NULL,
  `hostname` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `equipement_modele_id` int(11) NOT NULL,
  `ipmgmt_id` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  `relais_id` int(11) DEFAULT NULL,
  `equipement_mode_id` char(8) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_achat` date DEFAULT NULL,
  `date_hs` date DEFAULT NULL,
  `notes` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mac` (`mac`),
  UNIQUE KEY `ipmgmt_id` (`ipmgmt_id`),
  KEY `relais_id` (`relais_id`),
  KEY `equipement_mode_id` (`equipement_mode_id`),
  KEY `equipement_modele_id` (`equipement_modele_id`),
  KEY `service_id` (`service_id`),
  KEY `uplink_id` (`uplink_id`),
  CONSTRAINT `equipements_ibfk_1` FOREIGN KEY (`equipement_modele_id`) REFERENCES `equipement_modeles` (`id`) ON UPDATE CASCADE,
  CONSTRAINT `equipements_ibfk_4` FOREIGN KEY (`service_id`) REFERENCES `services` (`id`),
  CONSTRAINT `equipements_ibfk_5` FOREIGN KEY (`relais_id`) REFERENCES `relais` (`id`) ON UPDATE CASCADE,
  CONSTRAINT `equipements_ibfk_6` FOREIGN KEY (`equipement_mode_id`) REFERENCES `equipement_modes` (`id`) ON UPDATE CASCADE,
  CONSTRAINT `equipements_ibfk_8` FOREIGN KEY (`uplink_id`) REFERENCES `equipements` (`id`) ON UPDATE CASCADE,
  CONSTRAINT `equipements_ibfk_9` FOREIGN KEY (`ipmgmt_id`) REFERENCES `ipmgmt` (`ip4`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Matériel en circulation';

--
-- Dumping data for table `equipements`
--

INSERT INTO `equipements` VALUES (1,NULL,NULL,'52:54:00:AA:57:C3','gw-albi',43,'172.16.0.1',NULL,'rt-main',NULL,NULL,NULL,''),(2,NULL,NULL,'00:AB:CD:EF:01:02','ALB_M_EST',16,'172.16.10.2',2,'br-ap','',NULL,NULL,''),(3,NULL,NULL,'00:AB:CD:EF:01:03','ALB_M_OUEST',16,'172.16.10.3',2,'br-ap','',NULL,NULL,''),(4,NULL,NULL,'00:AB:CD:EF:01:01','ALB_M_RX',11,'172.16.10.1',2,'br-sta','',NULL,NULL,''),(5,NULL,NULL,'00:AB:CD:EF:01:05','ALB_CA_SUD',16,'172.16.10.5',1,'br-ap','',NULL,NULL,''),(6,5,NULL,'00:AB:CD:EF:01:07','ADT_POUZENC',13,'172.16.10.7',NULL,'br-sta','',NULL,NULL,''),(7,3,NULL,'00:AB:CD:EF:01:10','ADT_DURAND_E',12,'172.16.10.10',NULL,'br-sta','',NULL,NULL,''),(8,7,3,'00:AB:CD:EF:02:02','rt-durand-e',5,'172.16.20.2',NULL,'rt-soho','',NULL,NULL,''),(9,12,2,'00:AB:CD:EF:02:04','rt-durand-m',8,'172.16.20.4',NULL,'rt-soho','',NULL,NULL,''),(10,6,5,'00:AB:CD:EF:02:05','rt-pouzenc',4,'172.16.20.5',NULL,'rt-soho','',NULL,NULL,''),(11,7,6,'00:AB:CD:EF:02:01','rt-durand-e2',6,'172.16.20.1',NULL,'rt-soho','',NULL,NULL,''),(12,2,NULL,'00:AB:CD:EF:01:09','ADT_DURAND_M',17,'172.16.10.9',NULL,'br-sta','',NULL,NULL,'');
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`gestion_demo`@`localhost`*/ /*!50003 TRIGGER `equipements_insert` BEFORE INSERT ON `equipements` FOR EACH ROW BEGIN
	
	SET NEW.ipmgmt_id = IF(NEW.ipmgmt_id = '', NULL, NEW.ipmgmt_id);
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`gestion_demo`@`localhost`*/ /*!50003 TRIGGER `equipements_update` BEFORE UPDATE ON `equipements` FOR EACH ROW BEGIN
	
	SET NEW.ipmgmt_id = IF(NEW.ipmgmt_id = '', NULL, NEW.ipmgmt_id);
END */;;
DELIMITER ;

--
-- Table structure for table `interesse_statuts`
--

CREATE TABLE `interesse_statuts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `title` (`title`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `interesse_statuts`
--

INSERT INTO `interesse_statuts` VALUES (5,'Abandon'),(4,'Artisan envoyé'),(2,'Éligible'),(1,'Néant'),(3,'Référent associé');

--
-- Table structure for table `interesses`
--

CREATE TABLE `interesses` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date_demande` date NOT NULL,
  `civilite_id` int(11) NOT NULL,
  `nom` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `prenom` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `raison` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ville_id` int(11) NOT NULL,
  `interesse_statut_id` int(11) NOT NULL,
  `telephone` varchar(12) COLLATE utf8_unicode_ci DEFAULT NULL,
  `mail` varchar(48) COLLATE utf8_unicode_ci DEFAULT NULL,
  `adresse1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `adresse2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `notes` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `civilite_id` (`civilite_id`),
  KEY `ville_id` (`ville_id`),
  KEY `interesse_statut_id` (`interesse_statut_id`),
  CONSTRAINT `interesses_ibfk_1` FOREIGN KEY (`civilite_id`) REFERENCES `civilites` (`id`) ON UPDATE CASCADE,
  CONSTRAINT `interesses_ibfk_2` FOREIGN KEY (`ville_id`) REFERENCES `villes` (`id`) ON UPDATE CASCADE,
  CONSTRAINT `interesses_ibfk_3` FOREIGN KEY (`interesse_statut_id`) REFERENCES `interesse_statuts` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `interesses`
--

INSERT INTO `interesses` VALUES (1,'2016-06-16',1,'DUPOND','Bénédicte','',1,2,'0567891234','','123 route de Carmaux','','');

--
-- Table structure for table `ipmgmt`
--

CREATE TABLE `ipmgmt` (
  `ip4` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`ip4`),
  UNIQUE KEY `ip` (`ip4`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ipmgmt`
--

INSERT INTO `ipmgmt` VALUES ('172.16.0.1'),('172.16.10.1'),('172.16.10.10'),('172.16.10.2'),('172.16.10.3'),('172.16.10.4'),('172.16.10.5'),('172.16.10.6'),('172.16.10.7'),('172.16.10.8'),('172.16.10.9'),('172.16.20.1'),('172.16.20.2'),('172.16.20.3'),('172.16.20.4'),('172.16.20.5'),('172.16.30.1'),('172.16.30.2'),('172.16.30.3'),('172.16.30.4'),('172.16.30.5');

--
-- Table structure for table `ippubliques`
--

CREATE TABLE `ippubliques` (
  `ip4` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `ip6` varchar(39) COLLATE utf8_unicode_ci DEFAULT NULL,
  `secteur_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`ip4`),
  UNIQUE KEY `ip6` (`ip6`),
  KEY `secteur_id` (`secteur_id`),
  CONSTRAINT `ippubliques_ibfk_1` FOREIGN KEY (`secteur_id`) REFERENCES `secteurs` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ippubliques`
--

INSERT INTO `ippubliques` VALUES ('203.0.113.1','2001:db8:71:1::',1),('203.0.113.10','2001:db8:71:a::',1),('203.0.113.100','2001:db8:71:64::',1),('203.0.113.101','2001:db8:71:65::',1),('203.0.113.102','2001:db8:71:66::',1),('203.0.113.103','2001:db8:71:67::',1),('203.0.113.104','2001:db8:71:68::',1),('203.0.113.105','2001:db8:71:69::',1),('203.0.113.106','2001:db8:71:6a::',1),('203.0.113.107','2001:db8:71:6b::',1),('203.0.113.108','2001:db8:71:6c::',1),('203.0.113.109','2001:db8:71:6d::',1),('203.0.113.11','2001:db8:71:b::',1),('203.0.113.110','2001:db8:71:6e::',1),('203.0.113.111','2001:db8:71:6f::',1),('203.0.113.112','2001:db8:71:70::',1),('203.0.113.113','2001:db8:71:71::',1),('203.0.113.114','2001:db8:71:72::',1),('203.0.113.115','2001:db8:71:73::',1),('203.0.113.116','2001:db8:71:74::',1),('203.0.113.117','2001:db8:71:75::',1),('203.0.113.118','2001:db8:71:76::',1),('203.0.113.119','2001:db8:71:77::',1),('203.0.113.12','2001:db8:71:c::',1),('203.0.113.120','2001:db8:71:78::',1),('203.0.113.121','2001:db8:71:79::',1),('203.0.113.122','2001:db8:71:7a::',1),('203.0.113.123','2001:db8:71:7b::',1),('203.0.113.124','2001:db8:71:7c::',1),('203.0.113.125','2001:db8:71:7d::',1),('203.0.113.126','2001:db8:71:7e::',1),('203.0.113.127','2001:db8:71:7f::',1),('203.0.113.128','2001:db8:71:80::',2),('203.0.113.129','2001:db8:71:81::',2),('203.0.113.13','2001:db8:71:d::',1),('203.0.113.130','2001:db8:71:82::',2),('203.0.113.131','2001:db8:71:83::',2),('203.0.113.132','2001:db8:71:84::',2),('203.0.113.133','2001:db8:71:85::',2),('203.0.113.134','2001:db8:71:86::',2),('203.0.113.135','2001:db8:71:87::',2),('203.0.113.136','2001:db8:71:88::',2),('203.0.113.137','2001:db8:71:89::',2),('203.0.113.138','2001:db8:71:8a::',2),('203.0.113.139','2001:db8:71:8b::',2),('203.0.113.14','2001:db8:71:e::',1),('203.0.113.140','2001:db8:71:8c::',2),('203.0.113.141','2001:db8:71:8d::',2),('203.0.113.142','2001:db8:71:8e::',2),('203.0.113.143','2001:db8:71:8f::',2),('203.0.113.144','2001:db8:71:90::',2),('203.0.113.145','2001:db8:71:91::',2),('203.0.113.146','2001:db8:71:92::',2),('203.0.113.147','2001:db8:71:93::',2),('203.0.113.148','2001:db8:71:94::',2),('203.0.113.149','2001:db8:71:95::',2),('203.0.113.15','2001:db8:71:f::',1),('203.0.113.150','2001:db8:71:96::',2),('203.0.113.151','2001:db8:71:97::',2),('203.0.113.152','2001:db8:71:98::',2),('203.0.113.153','2001:db8:71:99::',2),('203.0.113.154','2001:db8:71:9a::',2),('203.0.113.155','2001:db8:71:9b::',2),('203.0.113.156','2001:db8:71:9c::',2),('203.0.113.157','2001:db8:71:9d::',2),('203.0.113.158','2001:db8:71:9e::',2),('203.0.113.159','2001:db8:71:9f::',2),('203.0.113.16','2001:db8:71:10::',1),('203.0.113.160','2001:db8:71:a0::',2),('203.0.113.161','2001:db8:71:a1::',2),('203.0.113.162','2001:db8:71:a2::',2),('203.0.113.163','2001:db8:71:a3::',2),('203.0.113.164','2001:db8:71:a4::',2),('203.0.113.165','2001:db8:71:a5::',2),('203.0.113.166','2001:db8:71:a6::',2),('203.0.113.167','2001:db8:71:a7::',2),('203.0.113.168','2001:db8:71:a8::',2),('203.0.113.169','2001:db8:71:a9::',2),('203.0.113.17','2001:db8:71:11::',1),('203.0.113.170','2001:db8:71:aa::',2),('203.0.113.171','2001:db8:71:ab::',2),('203.0.113.172','2001:db8:71:ac::',2),('203.0.113.173','2001:db8:71:ad::',2),('203.0.113.174','2001:db8:71:ae::',2),('203.0.113.175','2001:db8:71:af::',2),('203.0.113.176','2001:db8:71:b0::',2),('203.0.113.177','2001:db8:71:b1::',2),('203.0.113.178','2001:db8:71:b2::',2),('203.0.113.179','2001:db8:71:b3::',2),('203.0.113.18','2001:db8:71:12::',1),('203.0.113.180','2001:db8:71:b4::',2),('203.0.113.181','2001:db8:71:b5::',2),('203.0.113.182','2001:db8:71:b6::',2),('203.0.113.183','2001:db8:71:b7::',2),('203.0.113.184','2001:db8:71:b8::',2),('203.0.113.185','2001:db8:71:b9::',2),('203.0.113.186','2001:db8:71:ba::',2),('203.0.113.187','2001:db8:71:bb::',2),('203.0.113.188','2001:db8:71:bc::',2),('203.0.113.189','2001:db8:71:bd::',2),('203.0.113.19','2001:db8:71:13::',1),('203.0.113.190','2001:db8:71:be::',2),('203.0.113.191','2001:db8:71:bf::',2),('203.0.113.192','2001:db8:71:c0::',2),('203.0.113.193','2001:db8:71:c1::',2),('203.0.113.194','2001:db8:71:c2::',2),('203.0.113.195','2001:db8:71:c3::',2),('203.0.113.196','2001:db8:71:c4::',2),('203.0.113.197','2001:db8:71:c5::',2),('203.0.113.198','2001:db8:71:c6::',2),('203.0.113.199','2001:db8:71:c7::',2),('203.0.113.2','2001:db8:71:2::',1),('203.0.113.20','2001:db8:71:14::',1),('203.0.113.200','2001:db8:71:c8::',2),('203.0.113.201','2001:db8:71:c9::',2),('203.0.113.202','2001:db8:71:ca::',2),('203.0.113.203','2001:db8:71:cb::',2),('203.0.113.204','2001:db8:71:cc::',2),('203.0.113.205','2001:db8:71:cd::',2),('203.0.113.206','2001:db8:71:ce::',2),('203.0.113.207','2001:db8:71:cf::',2),('203.0.113.208','2001:db8:71:d0::',2),('203.0.113.209','2001:db8:71:d1::',2),('203.0.113.21','2001:db8:71:15::',1),('203.0.113.210','2001:db8:71:d2::',2),('203.0.113.211','2001:db8:71:d3::',2),('203.0.113.212','2001:db8:71:d4::',2),('203.0.113.213','2001:db8:71:d5::',2),('203.0.113.214','2001:db8:71:d6::',2),('203.0.113.215','2001:db8:71:d7::',2),('203.0.113.216','2001:db8:71:d8::',2),('203.0.113.217','2001:db8:71:d9::',2),('203.0.113.218','2001:db8:71:da::',2),('203.0.113.219','2001:db8:71:db::',2),('203.0.113.22','2001:db8:71:16::',1),('203.0.113.220','2001:db8:71:dc::',2),('203.0.113.221','2001:db8:71:dd::',2),('203.0.113.222','2001:db8:71:de::',2),('203.0.113.223','2001:db8:71:df::',2),('203.0.113.224','2001:db8:71:e0::',2),('203.0.113.225','2001:db8:71:e1::',2),('203.0.113.226','2001:db8:71:e2::',2),('203.0.113.227','2001:db8:71:e3::',2),('203.0.113.228','2001:db8:71:e4::',2),('203.0.113.229','2001:db8:71:e5::',2),('203.0.113.23','2001:db8:71:17::',1),('203.0.113.230','2001:db8:71:e6::',2),('203.0.113.231','2001:db8:71:e7::',2),('203.0.113.232','2001:db8:71:e8::',2),('203.0.113.233','2001:db8:71:e9::',2),('203.0.113.234','2001:db8:71:ea::',2),('203.0.113.235','2001:db8:71:eb::',2),('203.0.113.236','2001:db8:71:ec::',2),('203.0.113.237','2001:db8:71:ed::',2),('203.0.113.238','2001:db8:71:ee::',2),('203.0.113.239','2001:db8:71:ef::',2),('203.0.113.24','2001:db8:71:18::',1),('203.0.113.240','2001:db8:71:f0::',2),('203.0.113.241','2001:db8:71:f1::',2),('203.0.113.242','2001:db8:71:f2::',2),('203.0.113.243','2001:db8:71:f3::',2),('203.0.113.244','2001:db8:71:f4::',2),('203.0.113.245','2001:db8:71:f5::',2),('203.0.113.246','2001:db8:71:f6::',2),('203.0.113.247','2001:db8:71:f7::',2),('203.0.113.248','2001:db8:71:f8::',2),('203.0.113.249','2001:db8:71:f9::',2),('203.0.113.25','2001:db8:71:19::',1),('203.0.113.250','2001:db8:71:fa::',2),('203.0.113.251','2001:db8:71:fb::',2),('203.0.113.252','2001:db8:71:fc::',2),('203.0.113.253','2001:db8:71:fd::',2),('203.0.113.254','2001:db8:71:fe::',2),('203.0.113.26','2001:db8:71:1a::',1),('203.0.113.27','2001:db8:71:1b::',1),('203.0.113.28','2001:db8:71:1c::',1),('203.0.113.29','2001:db8:71:1d::',1),('203.0.113.3','2001:db8:71:3::',1),('203.0.113.30','2001:db8:71:1e::',1),('203.0.113.31','2001:db8:71:1f::',1),('203.0.113.32','2001:db8:71:20::',1),('203.0.113.33','2001:db8:71:21::',1),('203.0.113.34','2001:db8:71:22::',1),('203.0.113.35','2001:db8:71:23::',1),('203.0.113.36','2001:db8:71:24::',1),('203.0.113.37','2001:db8:71:25::',1),('203.0.113.38','2001:db8:71:26::',1),('203.0.113.39','2001:db8:71:27::',1),('203.0.113.4','2001:db8:71:4::',1),('203.0.113.40','2001:db8:71:28::',1),('203.0.113.41','2001:db8:71:29::',1),('203.0.113.42','2001:db8:71:2a::',1),('203.0.113.43','2001:db8:71:2b::',1),('203.0.113.44','2001:db8:71:2c::',1),('203.0.113.45','2001:db8:71:2d::',1),('203.0.113.46','2001:db8:71:2e::',1),('203.0.113.47','2001:db8:71:2f::',1),('203.0.113.48','2001:db8:71:30::',1),('203.0.113.49','2001:db8:71:31::',1),('203.0.113.5','2001:db8:71:5::',1),('203.0.113.50','2001:db8:71:32::',1),('203.0.113.51','2001:db8:71:33::',1),('203.0.113.52','2001:db8:71:34::',1),('203.0.113.53','2001:db8:71:35::',1),('203.0.113.54','2001:db8:71:36::',1),('203.0.113.55','2001:db8:71:37::',1),('203.0.113.56','2001:db8:71:38::',1),('203.0.113.57','2001:db8:71:39::',1),('203.0.113.58','2001:db8:71:3a::',1),('203.0.113.59','2001:db8:71:3b::',1),('203.0.113.6','2001:db8:71:6::',1),('203.0.113.60','2001:db8:71:3c::',1),('203.0.113.61','2001:db8:71:3d::',1),('203.0.113.62','2001:db8:71:3e::',1),('203.0.113.63','2001:db8:71:3f::',1),('203.0.113.64','2001:db8:71:40::',1),('203.0.113.65','2001:db8:71:41::',1),('203.0.113.66','2001:db8:71:42::',1),('203.0.113.67','2001:db8:71:43::',1),('203.0.113.68','2001:db8:71:44::',1),('203.0.113.69','2001:db8:71:45::',1),('203.0.113.7','2001:db8:71:7::',1),('203.0.113.70','2001:db8:71:46::',1),('203.0.113.71','2001:db8:71:47::',1),('203.0.113.72','2001:db8:71:48::',1),('203.0.113.73','2001:db8:71:49::',1),('203.0.113.74','2001:db8:71:4a::',1),('203.0.113.75','2001:db8:71:4b::',1),('203.0.113.76','2001:db8:71:4c::',1),('203.0.113.77','2001:db8:71:4d::',1),('203.0.113.78','2001:db8:71:4e::',1),('203.0.113.79','2001:db8:71:4f::',1),('203.0.113.8','2001:db8:71:8::',1),('203.0.113.80','2001:db8:71:50::',1),('203.0.113.81','2001:db8:71:51::',1),('203.0.113.82','2001:db8:71:52::',1),('203.0.113.83','2001:db8:71:53::',1),('203.0.113.84','2001:db8:71:54::',1),('203.0.113.85','2001:db8:71:55::',1),('203.0.113.86','2001:db8:71:56::',1),('203.0.113.87','2001:db8:71:57::',1),('203.0.113.88','2001:db8:71:58::',1),('203.0.113.89','2001:db8:71:59::',1),('203.0.113.9','2001:db8:71:9::',1),('203.0.113.90','2001:db8:71:5a::',1),('203.0.113.91','2001:db8:71:5b::',1),('203.0.113.92','2001:db8:71:5c::',1),('203.0.113.93','2001:db8:71:5d::',1),('203.0.113.94','2001:db8:71:5e::',1),('203.0.113.95','2001:db8:71:5f::',1),('203.0.113.96','2001:db8:71:60::',1),('203.0.113.97','2001:db8:71:61::',1),('203.0.113.98','2001:db8:71:62::',1),('203.0.113.99','2001:db8:71:63::',1);

--
-- Table structure for table `periodicites`
--

CREATE TABLE `periodicites` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `periodicites`
--

INSERT INTO `periodicites` VALUES (1,'Mensuel'),(2,'Trimestriel'),(3,'Annuel');

--
-- Table structure for table `relais`
--

CREATE TABLE `relais` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `ville_id` int(11) NOT NULL,
  `secteur_id` int(11) NOT NULL,
  `gps_long` float(10,7) NOT NULL,
  `gps_lat` float(10,7) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `title` (`title`),
  KEY `ville_id` (`ville_id`),
  KEY `id_secteur` (`secteur_id`),
  CONSTRAINT `relais_ibfk_2` FOREIGN KEY (`secteur_id`) REFERENCES `secteurs` (`id`) ON UPDATE CASCADE,
  CONSTRAINT `relais_ibfk_3` FOREIGN KEY (`ville_id`) REFERENCES `villes` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `relais`
--

INSERT INTO `relais` VALUES (1,'Cathédrale',1,1,0.0000000,0.0000000),(2,'Mairie',1,2,0.0000000,0.0000000);

--
-- Table structure for table `secteurs`
--

CREATE TABLE `secteurs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `title` (`title`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Différents secteurs de déploiement';

--
-- Dumping data for table `secteurs`
--

INSERT INTO `secteurs` VALUES (1,'Albi Est'),(2,'Albi Ouest');

--
-- Table structure for table `service_statuts`
--

CREATE TABLE `service_statuts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `service_statuts`
--

INSERT INTO `service_statuts` VALUES (-1,'Inconnu'),(1,'Prévu'),(2,'Actif TTN'),(3,'Migré'),(4,'Actif CHD'),(5,'Suspendu'),(6,'Résilié');

--
-- Table structure for table `service_types`
--

CREATE TABLE `service_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `prix_base_ht` decimal(7,2) NOT NULL,
  `periodicite_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `periodicite_id` (`periodicite_id`),
  CONSTRAINT `service_types_ibfk_1` FOREIGN KEY (`periodicite_id`) REFERENCES `periodicites` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Services disponibles';

--
-- Dumping data for table `service_types`
--

INSERT INTO `service_types` VALUES (1,'Adhésion',20.00,3),(2,'Internet + matériel',28.00,1),(3,'Internet',25.00,1),(4,'Internet + relais',20.00,1);

--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `adherent_id` int(11) NOT NULL,
  `service_type_id` int(11) NOT NULL,
  `service_statut_id` int(11) NOT NULL,
  `ippublique_id` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  `prix_ht` decimal(7,2) DEFAULT NULL,
  `date_debut` datetime DEFAULT NULL,
  `date_fin` datetime DEFAULT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `lat` float(10,7) DEFAULT NULL,
  `lng` float(10,7) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `id_adherent` (`adherent_id`),
  KEY `id_type` (`service_type_id`),
  KEY `service_statut_id` (`service_statut_id`),
  KEY `ip4publique_id` (`ippublique_id`),
  CONSTRAINT `services_ibfk_1` FOREIGN KEY (`adherent_id`) REFERENCES `adherents` (`id`) ON UPDATE CASCADE,
  CONSTRAINT `services_ibfk_2` FOREIGN KEY (`service_type_id`) REFERENCES `service_types` (`id`) ON UPDATE CASCADE,
  CONSTRAINT `services_ibfk_4` FOREIGN KEY (`service_statut_id`) REFERENCES `service_statuts` (`id`) ON UPDATE CASCADE,
  CONSTRAINT `services_ibfk_5` FOREIGN KEY (`ippublique_id`) REFERENCES `ippubliques` (`ip4`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Services souscrits par les adhérents';

--
-- Dumping data for table `services`
--

INSERT INTO `services` VALUES (1,349,1,4,NULL,20.00,'2016-06-16 18:29:20',NULL,'','2016-06-16 18:29:20','2016-06-16 18:29:20',NULL,NULL),(2,349,3,4,'203.0.113.128',25.00,'2016-06-16 19:38:38',NULL,'Secrétariat de Mairie','2016-06-16 18:29:56','2016-06-16 19:38:38',NULL,NULL),(3,349,3,1,NULL,25.00,'2016-06-16 19:24:15',NULL,'Accès Ecole','2016-06-16 19:24:15','2016-06-16 19:24:15',NULL,NULL),(4,350,1,4,NULL,20.00,'2016-06-16 19:26:22',NULL,'','2016-06-16 19:26:22','2016-06-16 19:26:22',NULL,NULL),(5,350,2,1,NULL,28.00,'2016-06-16 19:26:27',NULL,'','2016-06-16 19:26:27','2016-06-16 19:26:27',NULL,NULL),(6,349,3,4,'203.0.113.129',25.00,'2016-06-16 19:38:59',NULL,'','2016-06-16 19:34:08','2016-06-16 19:38:59',NULL,NULL);

--
-- Temporary table structure for view `v_adt_sms`
--

/*!50001 DROP VIEW IF EXISTS `v_adt_sms`*/;
/*!50001 CREATE TABLE `v_adt_sms` (
  `id` tinyint NOT NULL,
  `tel_mobile1` tinyint NOT NULL,
  `tel_mobile2` tinyint NOT NULL,
  `tel_contact` tinyint NOT NULL,
  `mail_contact` tinyint NOT NULL,
  `relais` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `v_api_gen_conf`
--

/*!50001 DROP VIEW IF EXISTS `v_api_gen_conf`*/;
/*!50001 CREATE TABLE `v_api_gen_conf` (
  `do_conf` tinyint NOT NULL,
  `etat` tinyint NOT NULL,
  `svc_id` tinyint NOT NULL,
  `ip4_nexthop` tinyint NOT NULL,
  `ip4_public` tinyint NOT NULL,
  `ip6_nexthop` tinyint NOT NULL,
  `ip6_prefix` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `v_api_gen_firm`
--

/*!50001 DROP VIEW IF EXISTS `v_api_gen_firm`*/;
/*!50001 CREATE TABLE `v_api_gen_firm` (
  `ippublique_id` tinyint NOT NULL,
  `nom` tinyint NOT NULL,
  `prenom` tinyint NOT NULL,
  `raison` tinyint NOT NULL,
  `constructeur` tinyint NOT NULL,
  `modele` tinyint NOT NULL,
  `profile` tinyint NOT NULL,
  `revision` tinyint NOT NULL,
  `ip6prefix` tinyint NOT NULL,
  `ip4wan` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `v_relais`
--

/*!50001 DROP VIEW IF EXISTS `v_relais`*/;
/*!50001 CREATE TABLE `v_relais` (
  `relais_id` tinyint NOT NULL,
  `relais` tinyint NOT NULL,
  `secteur` tinyint NOT NULL,
  `nb_connectes` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `v_relais_detail`
--

/*!50001 DROP VIEW IF EXISTS `v_relais_detail`*/;
/*!50001 CREATE TABLE `v_relais_detail` (
  `relais` tinyint NOT NULL,
  `adt` tinyint NOT NULL,
  `adt_title` tinyint NOT NULL,
  `adherent_id` tinyint NOT NULL,
  `service_id` tinyint NOT NULL,
  `service` tinyint NOT NULL,
  `routeur_equipement_id` tinyint NOT NULL,
  `antenne1_equipement_id` tinyint NOT NULL,
  `antenne2_equipement_id` tinyint NOT NULL,
  `relais_id` tinyint NOT NULL,
  `relais_degre` tinyint NOT NULL,
  `secteur_id` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `v_secteurs`
--

/*!50001 DROP VIEW IF EXISTS `v_secteurs`*/;
/*!50001 CREATE TABLE `v_secteurs` (
  `id` tinyint NOT NULL,
  `secteur` tinyint NOT NULL,
  `nb_connectes` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `v_sympa_adherents`
--

/*!50001 DROP VIEW IF EXISTS `v_sympa_adherents`*/;
/*!50001 CREATE TABLE `v_sympa_adherents` (
  `mail` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `v_sympa_referents`
--

/*!50001 DROP VIEW IF EXISTS `v_sympa_referents`*/;
/*!50001 CREATE TABLE `v_sympa_referents` (
  `mail` tinyint NOT NULL,
  `village_list_name` tinyint NOT NULL,
  `sms_list_name` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `v_sympa_roles`
--

/*!50001 DROP VIEW IF EXISTS `v_sympa_roles`*/;
/*!50001 CREATE TABLE `v_sympa_roles` (
  `mail` tinyint NOT NULL,
  `list_name` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Table structure for table `villes`
--

CREATE TABLE `villes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `cp` char(5) COLLATE utf8_unicode_ci NOT NULL,
  `tel_contact` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `title` (`title`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `villes`
--

INSERT INTO `villes` VALUES (1,'ALBI','81000','-');

--
-- Dumping routines for database 'gestion_demo'
--
/*!50003 DROP FUNCTION IF EXISTS `CALC_WANIP6LL` */;
DELIMITER ;;
CREATE DEFINER=`gestion_demo`@`localhost` FUNCTION `CALC_WANIP6LL`(`ip6_prefix` VARCHAR(39) CHARSET utf8) RETURNS varchar(39) CHARSET utf8 COLLATE utf8_unicode_ci
    NO SQL
    DETERMINISTIC
BEGIN
    DECLARE len INT(11);
    SET len = LENGTH(ip6_prefix);
    
	RETURN IF(ip6_prefix REGEXP ':....:....::$',
              CONCAT('fe80::',RIGHT(LEFT(ip6_prefix,len-2),9)),
              NULL
             );
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `FREE_IP` */;
DELIMITER ;;
CREATE DEFINER=`gestion_demo`@`localhost` FUNCTION `FREE_IP`(`arg_service_id` INT(11)) RETURNS varchar(15) CHARSET utf8 COLLATE utf8_unicode_ci
    NO SQL
BEGIN

DECLARE res VARCHAR(15);

SELECT ip.ip4 INTO res
FROM ippubliques ip
LEFT JOIN services s ON (s.ippublique_id = ip.ip4)
WHERE s.id IS NULL
AND ip.secteur_id = (
  SELECT secteur_id FROM v_relais_detail
  WHERE service_id=arg_service_id
)
AND ip.secteur_id IS NOT NULL
ORDER BY INET_ATON(ip.ip4)
LIMIT 1;

RETURN res;
END ;;
DELIMITER ;

--
-- Final view structure for view `v_adt_sms`
--

/*!50001 DROP TABLE IF EXISTS `v_adt_sms`*/;
/*!50001 DROP VIEW IF EXISTS `v_adt_sms`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`gestion_demo`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v_adt_sms` AS select concat('CHD-',`a`.`id`) AS `id`,`a`.`tel_mobile1` AS `tel_mobile1`,`a`.`tel_mobile2` AS `tel_mobile2`,`v`.`tel_contact` AS `tel_contact`,concat(lcase(replace(`v`.`title`,' ','-')),'@chd.sx') AS `mail_contact`,`re`.`title` AS `relais` from (((((((`adherents` `a` left join `villes` `v` on((`v`.`id` = `a`.`ville_id`))) left join `services` `s` on((`s`.`adherent_id` = `a`.`id`))) left join `equipements` `rt` on((`rt`.`service_id` = `s`.`id`))) left join `equipements` `a1` on((`a1`.`id` = `rt`.`uplink_id`))) left join `equipements` `a2` on((`a2`.`id` = `a1`.`uplink_id`))) left join `relais` `re` on((`re`.`id` = coalesce(`rt`.`relais_id`,`a1`.`relais_id`,`a2`.`relais_id`)))) left join `secteurs` `sec` on((`sec`.`id` = `re`.`secteur_id`))) where ((`a`.`adherent_statut_id` <> 1) and (`s`.`service_type_id` in (2,3,4)) and (`s`.`service_statut_id` = 4)) */;

--
-- Final view structure for view `v_api_gen_conf`
--

/*!50001 DROP TABLE IF EXISTS `v_api_gen_conf`*/;
/*!50001 DROP VIEW IF EXISTS `v_api_gen_conf`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`gestion_demo`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v_api_gen_conf` AS select 'do_conf' AS `do_conf`,'actif' AS `etat`,concat('SER-',`s`.`id`) AS `svc_id`,`routeur`.`ipmgmt_id` AS `ip4_nexthop`,`ipp`.`ip4` AS `ip4_public`,`CALC_WANIP6LL`(`ipp`.`ip6`) AS `ip6_nexthop`,`ipp`.`ip6` AS `ip6_prefix` from ((((`services` `s` left join `service_types` `st` on((`st`.`id` = `s`.`service_type_id`))) left join `ippubliques` `ipp` on((`ipp`.`ip4` = `s`.`ippublique_id`))) left join `adherents` `a` on((`s`.`adherent_id` = `a`.`id`))) left join `equipements` `routeur` on(((`routeur`.`service_id` = `s`.`id`) and (`routeur`.`equipement_mode_id` in ('rt-soho','rt-sta'))))) where ((`s`.`service_type_id` in (2,3,4)) and (`s`.`service_statut_id` in (2,4)) and (`a`.`adherent_statut_id` <> 1)) */;

--
-- Final view structure for view `v_api_gen_firm`
--

/*!50001 DROP TABLE IF EXISTS `v_api_gen_firm`*/;
/*!50001 DROP VIEW IF EXISTS `v_api_gen_firm`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`gestion_demo`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v_api_gen_firm` AS select `s`.`ippublique_id` AS `ippublique_id`,`a`.`nom` AS `nom`,`a`.`prenom` AS `prenom`,`a`.`raison` AS `raison`,`em`.`constructeur` AS `constructeur`,`em`.`modele` AS `modele`,`em`.`profile` AS `profile`,`em`.`revision` AS `revision`,`ip`.`ip6` AS `ip6prefix`,`e`.`ipmgmt_id` AS `ip4wan` from ((((`services` `s` left join `adherents` `a` on((`a`.`id` = `s`.`adherent_id`))) left join `ippubliques` `ip` on((`ip`.`ip4` = `s`.`ippublique_id`))) left join `equipements` `e` on((`e`.`service_id` = `s`.`id`))) left join `equipement_modeles` `em` on((`em`.`id` = `e`.`equipement_modele_id`))) where ((`s`.`service_statut_id` = 4) and (`s`.`ippublique_id` is not null)) */;

--
-- Final view structure for view `v_relais`
--

/*!50001 DROP TABLE IF EXISTS `v_relais`*/;
/*!50001 DROP VIEW IF EXISTS `v_relais`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`gestion_demo`@`localhost` SQL SECURITY INVOKER */
/*!50001 VIEW `v_relais` AS select `v`.`relais_id` AS `relais_id`,`v`.`relais` AS `relais`,`s`.`title` AS `secteur`,count(0) AS `nb_connectes` from (`v_relais_detail` `v` left join `secteurs` `s` on((`v`.`secteur_id` = `s`.`id`))) group by `v`.`relais_id`,`v`.`relais`,`s`.`title` */;

--
-- Final view structure for view `v_relais_detail`
--

/*!50001 DROP TABLE IF EXISTS `v_relais_detail`*/;
/*!50001 DROP VIEW IF EXISTS `v_relais_detail`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`gestion_demo`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v_relais_detail` AS select `re`.`title` AS `relais`,concat('CHD-',`a`.`id`) AS `adt`,concat_ws(' ',nullif(`a`.`raison`,''),`a`.`nom`,`a`.`prenom`) AS `adt_title`,`a`.`id` AS `adherent_id`,`s`.`id` AS `service_id`,concat('SER-',`s`.`id`) AS `service`,`rt`.`id` AS `routeur_equipement_id`,`a1`.`id` AS `antenne1_equipement_id`,`a2`.`id` AS `antenne2_equipement_id`,`re`.`id` AS `relais_id`,(case when (`rt`.`relais_id` is not null) then 1 when (`a1`.`relais_id` is not null) then 2 when (`a2`.`relais_id` is not null) then 3 else NULL end) AS `relais_degre`,`sec`.`id` AS `secteur_id` from ((((((`adherents` `a` left join `services` `s` on((`s`.`adherent_id` = `a`.`id`))) left join `equipements` `rt` on((`rt`.`service_id` = `s`.`id`))) left join `equipements` `a1` on((`a1`.`id` = `rt`.`uplink_id`))) left join `equipements` `a2` on((`a2`.`id` = `a1`.`uplink_id`))) left join `relais` `re` on((`re`.`id` = coalesce(`rt`.`relais_id`,`a1`.`relais_id`,`a2`.`relais_id`)))) left join `secteurs` `sec` on((`sec`.`id` = `re`.`secteur_id`))) where ((`a`.`adherent_statut_id` <> 1) and (`s`.`service_type_id` in (2,3,4)) and (`s`.`service_statut_id` in (1,2,4))) order by 1 */;

--
-- Final view structure for view `v_secteurs`
--

/*!50001 DROP TABLE IF EXISTS `v_secteurs`*/;
/*!50001 DROP VIEW IF EXISTS `v_secteurs`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`gestion_demo`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v_secteurs` AS select `s`.`id` AS `id`,`s`.`title` AS `secteur`,count(0) AS `nb_connectes` from (`v_relais_detail` `v` left join `secteurs` `s` on((`v`.`secteur_id` = `s`.`id`))) group by `s`.`id`,`s`.`title` */;

--
-- Final view structure for view `v_sympa_adherents`
--

/*!50001 DROP TABLE IF EXISTS `v_sympa_adherents`*/;
/*!50001 DROP VIEW IF EXISTS `v_sympa_adherents`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`gestion_demo`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v_sympa_adherents` AS select distinct `a`.`mail1` AS `mail` from `adherents` `a` where ((length(`a`.`mail1`) > 5) and (`a`.`adherent_statut_id` <> 1)) */;

--
-- Final view structure for view `v_sympa_referents`
--

/*!50001 DROP TABLE IF EXISTS `v_sympa_referents`*/;
/*!50001 DROP VIEW IF EXISTS `v_sympa_referents`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`gestion_demo`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v_sympa_referents` AS select `a`.`mail1` AS `mail`,lcase(replace(`v`.`title`,' ','-')) AS `village_list_name`,`v`.`tel_contact` AS `sms_list_name` from ((`adherent_roles` `ar` left join `adherents` `a` on((`ar`.`adherent_id` = `a`.`id`))) left join `villes` `v` on((`ar`.`ville_id` = `v`.`id`))) where ((`ar`.`adherent_role_type_id` = 7) and (length(`a`.`mail1`) > 5)) */;

--
-- Final view structure for view `v_sympa_roles`
--

/*!50001 DROP TABLE IF EXISTS `v_sympa_roles`*/;
/*!50001 DROP VIEW IF EXISTS `v_sympa_roles`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`gestion_demo`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v_sympa_roles` AS select distinct `a`.`mail1` AS `mail`,`art`.`list_name` AS `list_name` from ((`adherent_roles` `ar` left join `adherents` `a` on((`ar`.`adherent_id` = `a`.`id`))) left join `adherent_role_types` `art` on((`ar`.`adherent_role_type_id` = `art`.`id`))) where (length(`a`.`mail1`) > 5) */;


