(5794,32,2,'2017-04-14 08:00:00','2017-04-14 09:00:00'),(5795,84,2,'2017-04-14 09:30:00','2017-04-14 10:30:00'),(5796,589,2,'2017-04-14 10:30:00','2017-04-14 11:30:00'),(5797,43,2,'2017-04-14 11:30:00','2017-04-14 12:30:00'),(5798,838,2,'2017-04-14 14:00:00','2017-04-14 15:00:00'),(5799,197,7,'2017-04-12 07:00:00','2017-04-12 08:00:00'),(5800,4188,7,'2017-04-12 08:00:00','2017-04-12 09:00:00'),(5801,1932,7,'2017-04-12 10:00:00','2017-04-12 11:00:00'),(5802,1936,7,'2017-04-12 11:00:00','2017-04-12 12:00:00'),(5803,1071,7,'2017-04-12 12:00:00','2017-04-12 13:00:00'),(5804,1070,7,'2017-04-12 14:00:00','2017-04-12 15:00:00'),(5805,4236,7,'2017-04-12 09:00:00','2017-04-12 10:00:00'),(5806,1422,7,'2017-04-13 11:30:00','2017-04-13 12:30:00'),(5807,496,7,'2017-04-14 08:00:00','2017-04-14 09:00:00'),(5808,1073,7,'2017-04-14 10:00:00','2017-04-14 11:00:00'),(5809,195,7,'2017-04-14 11:00:00','2017-04-14 12:00:00'),(5810,3207,7,'2017-04-14 14:00:00','2017-04-14 15:00:00'),(5811,4237,7,'2017-04-14 16:00:00','2017-04-14 17:00:00'),(5812,3109,8,'2017-04-06 08:00:00','2017-04-06 09:00:00'),(5813,3111,8,'2017-04-06 10:00:00','2017-04-06 11:00:00'),(5814,1109,8,'2017-04-06 11:00:00','2017-04-06 12:00:00'),(5815,2718,8,'2017-04-06 13:30:00','2017-04-06 14:30:00'),(5816,982,8,'2017-04-06 16:00:00','2017-04-06 17:00:00'),(5817,152,8,'2017-04-07 09:00:00','2017-04-07 10:00:00'),(5818,2902,8,'2017-04-07 10:00:00','2017-04-07 11:00:00'),(5819,100,8,'2017-04-07 11:00:00','2017-04-07 12:00:00'),(5820,2680,8,'2017-04-07 13:30:00','2017-04-07 14:30:00'),(5821,2656,8,'2017-04-07 15:00:00','2017-04-07 16:00:00'),(5822,2398,8,'2017-04-07 16:00:00','2017-04-07 17:00:00'),(5823,1770,8,'2017-04-13 09:00:00','2017-04-13 10:00:00'),(5824,3933,8,'2017-04-13 10:00:00','2017-04-13 11:00:00'),(5825,1771,8,'2017-04-13 11:30:00','2017-04-13 12:30:00'),(5826,1596,8,'2017-04-13 13:30:00','2017-04-13 14:30:00'),(5827,3232,8,'2017-04-13 17:30:00','2017-04-13 18:30:00'),(5828,3097,8,'2017-04-13 18:30:00','2017-04-13 19:30:00'),(5829,3643,8,'2017-04-14 09:00:00','2017-04-14 10:00:00'),(5830,2862,8,'2017-04-14 10:00:00','2017-04-14 11:00:00'),(5831,1741,8,'2017-04-14 11:00:00','2017-04-14 12:00:00'),(5832,4235,8,'2017-04-14 12:00:00','2017-04-14 13:00:00'),(5833,12,7,'2017-04-20 11:30:00','2017-04-20 12:30:00'),(5834,434,7,'2017-04-21 11:00:00','2017-04-21 12:00:00'),(5835,3324,3,'2017-04-20 09:00:00','2017-04-20 10:00:00'),(5836,3828,3,'2017-04-20 11:00:00','2017-04-20 12:00:00'),(5837,4225,3,'2017-04-20 11:30:00','2017-04-20 12:30:00'),(5838,1541,3,'2017-04-20 14:00:00','2017-04-20 15:00:00'),(5841,4242,3,'2017-04-20 17:00:00','2017-04-20 18:00:00'),(5842,73,3,'2017-04-20 17:30:00','2017-04-20 18:30:00'),(5844,4243,3,'2017-04-21 10:00:00','2017-04-21 11:00:00'),(5845,4244,3,'2017-04-21 11:00:00','2017-04-21 12:00:00'),(5848,3067,3,'2017-04-21 16:00:00','2017-04-21 17:00:00'),(5850,3828,3,'2017-04-20 10:30:00','2017-04-20 11:30:00'),(5853,4241,3,'2017-04-20 16:00:00','2017-04-20 17:00:00'),(5854,3721,3,'2017-04-20 16:30:00','2017-04-20 17:30:00'),(5856,73,3,'2017-04-20 18:00:00','2017-04-20 19:00:00'),(5857,3788,3,'2017-04-21 09:00:00','2017-04-21 10:00:00'),(5860,1717,3,'2017-04-21 12:00:00','2017-04-21 13:00:00'),(5861,4245,3,'2017-04-21 14:00:00','2017-04-21 15:00:00'),(5863,1871,3,'2017-04-26 09:00:00','2017-04-26 10:00:00'),(5864,4266,3,'2017-04-26 11:00:00','2017-04-26 12:00:00'),(5865,52,3,'2017-04-26 11:30:00','2017-04-26 12:30:00'),(5866,3286,3,'2017-04-26 12:00:00','2017-04-26 13:00:00'),(5867,3309,3,'2017-04-26 13:00:00','2017-04-26 14:00:00'),(5868,4267,3,'2017-04-26 15:30:00','2017-04-26 16:30:00'),(5869,4214,3,'2017-04-26 14:30:00','2017-04-26 15:30:00'),(5870,926,3,'2017-04-26 17:00:00','2017-04-26 18:00:00'),(5871,4268,3,'2017-04-27 08:30:00','2017-04-27 09:30:00'),(5872,3381,3,'2017-04-27 10:00:00','2017-04-27 11:00:00'),(5873,3421,3,'2017-04-27 11:00:00','2017-04-27 12:00:00'),(5874,4216,3,'2017-04-27 12:00:00','2017-04-27 13:00:00'),(5875,4215,3,'2017-04-27 14:00:00','2017-04-27 15:00:00'),(5876,4269,3,'2017-04-27 15:00:00','2017-04-27 16:00:00'),(5877,1862,3,'2017-04-27 17:30:00','2017-04-27 18:30:00'),(5878,3410,3,'2017-04-28 09:00:00','2017-04-28 10:00:00'),(5879,3409,3,'2017-04-28 10:00:00','2017-04-28 11:00:00'),(5880,49,3,'2017-04-28 13:00:00','2017-04-28 14:00:00'),(5881,3884,3,'2017-04-28 15:00:00','2017-04-28 16:00:00'),(5882,47,3,'2017-04-28 16:00:00','2017-04-28 17:00:00'),(5883,2692,6,'2017-04-03 08:00:00','2017-04-03 09:00:00'),(5884,383,6,'2017-04-03 10:00:00','2017-04-03 11:00:00'),(5885,4202,6,'2017-04-03 11:00:00','2017-04-03 12:00:00'),(5886,1051,6,'2017-04-03 14:00:00','2017-04-03 15:00:00'),(5887,4204,6,'2017-04-03 15:00:00','2017-04-03 16:00:00'),(5888,4205,6,'2017-04-03 17:00:00','2017-04-03 18:00:00'),(5889,2879,6,'2017-04-04 08:00:00','2017-04-04 09:00:00'),(5890,1119,6,'2017-04-04 11:00:00','2017-04-04 12:00:00'),(5891,997,6,'2017-04-04 14:00:00','2017-04-04 15:00:00'),(5892,4206,6,'2017-04-04 17:00:00','2017-04-04 18:00:00'),(5893,1455,6,'2017-04-04 18:00:00','2017-04-04 19:00:00'),(5894,377,6,'2017-04-05 08:00:00','2017-04-05 09:00:00'),(5895,380,6,'2017-04-05 09:00:00','2017-04-05 10:00:00'),(5896,1243,6,'2017-04-05 10:00:00','2017-04-05 11:00:00'),(5897,1052,6,'2017-04-05 11:00:00','2017-04-05 12:00:00'),(5898,2005,6,'2017-04-05 14:00:00','2017-04-05 15:00:00'),(5899,4211,6,'2017-04-05 16:00:00','2017-04-05 17:00:00'),(5900,4201,6,'2017-04-05 18:00:00','2017-04-05 19:00:00'),(5901,4099,6,'2017-04-06 07:30:00','2017-04-06 08:30:00'),(5902,960,6,'2017-04-06 09:00:00','2017-04-06 10:00:00'),(5903,4200,6,'2017-04-06 11:00:00','2017-04-06 12:00:00'),(5904,3184,6,'2017-04-06 14:00:00','2017-04-06 15:00:00'),(5905,1527,6,'2017-04-06 15:30:00','2017-04-06 16:30:00'),(5906,1123,6,'2017-04-06 17:00:00','2017-04-06 18:00:00'),(5907,957,6,'2017-04-07 08:00:00','2017-04-07 09:00:00'),(5908,3183,6,'2017-04-07 09:00:00','2017-04-07 10:00:00'),(5909,4212,6,'2017-04-07 13:00:00','2017-04-07 14:00:00'),(5910,1054,6,'2017-04-07 15:00:00','2017-04-07 16:00:00'),(5911,4213,6,'2017-04-07 17:00:00','2017-04-07 18:00:00'),(5912,1114,6,'2017-04-18 08:00:00','2017-04-18 09:00:00'),(5913,1115,6,'2017-04-18 11:00:00','2017-04-18 12:00:00'),(5914,1006,6,'2017-04-18 14:00:00','2017-04-18 15:00:00'),(5915,4261,6,'2017-04-18 15:30:00','2017-04-18 16:30:00'),(5916,4022,6,'2017-04-18 17:00:00','2017-04-18 18:00:00'),(5917,383,6,'2017-04-19 08:00:00','2017-04-19 09:00:00'),(5918,2491,6,'2017-04-19 11:00:00','2017-04-19 12:00:00'),(5919,2005,6,'2017-04-19 14:00:00','2017-04-19 15:00:00'),(5920,3295,6,'2017-04-19 18:00:00','2017-04-19 19:00:00'),(5922,3092,6,'2017-04-20 08:00:00','2017-04-20 09:00:00'),(5923,3549,6,'2017-04-20 09:00:00','2017-04-20 10:00:00'),(5924,561,6,'2017-04-20 11:00:00','2017-04-20 12:00:00'),(5925,1345,6,'2017-04-20 14:00:00','2017-04-20 15:00:00'),(5926,2689,6,'2017-04-20 16:00:00','2017-04-20 17:00:00'),(5927,567,6,'2017-04-20 17:00:00','2017-04-20 18:00:00'),(5928,3869,6,'2017-04-21 08:00:00','2017-04-21 09:00:00'),(5929,3718,6,'2017-04-21 10:00:00','2017-04-21 11:00:00'),(5930,3348,6,'2017-04-21 14:00:00','2017-04-21 15:00:00'),(5931,407,6,'2017-04-21 15:30:00','2017-04-21 16:30:00'),(5932,339,6,'2017-04-21 17:00:00','2017-04-21 18:00:00'),(5933,3041,6,'2017-04-21 19:00:00','2017-04-21 20:00:00'),(5934,111,7,'2017-04-26 09:00:00','2017-04-26 10:00:00'),(5935,60,7,'2017-04-26 10:00:00','2017-04-26 11:00:00'),(5936,2273,7,'2017-04-26 11:00:00','2017-04-26 12:00:00'),(5937,389,7,'2017-04-26 14:00:00','2017-04-26 15:00:00'),(5938,2831,7,'2017-04-27 10:00:00','2017-04-27 11:00:00'),(5939,61,7,'2017-04-28 09:00:00','2017-04-28 10:00:00'),(5940,547,7,'2017-04-28 10:00:00','2017-04-28 11:00:00'),(5941,413,7,'2017-04-28 11:00:00','2017-04-28 12:00:00'),(5942,62,7,'2017-04-28 13:00:00','2017-04-28 14:00:00'),(5943,2549,2,'2017-04-23 09:00:00','2017-04-23 10:00:00'),(5944,1834,2,'2017-04-23 10:00:00','2017-04-23 11:00:00'),(5945,1600,2,'2017-04-23 11:00:00','2017-04-23 12:00:00'),(5946,4067,2,'2017-04-23 12:00:00','2017-04-23 13:00:00'),(5947,4181,2,'2017-04-23 14:00:00','2017-04-23 15:00:00'),(5948,4030,2,'2017-04-23 15:00:00','2017-04-23 16:00:00'),(5949,4169,2,'2017-04-23 16:00:00','2017-04-23 17:00:00'),(5950,4164,2,'2017-04-23 17:00:00','2017-04-23 18:00:00'),(5951,2549,2,'2017-04-24 08:00:00','2017-04-24 09:00:00'),(5952,1834,2,'2017-04-24 09:00:00','2017-04-24 10:00:00'),(5953,1600,2,'2017-04-24 10:00:00','2017-04-24 11:00:00'),(5954,4067,2,'2017-04-24 11:00:00','2017-04-24 12:00:00'),(5955,4181,2,'2017-04-24 14:00:00','2017-04-24 15:00:00'),(5956,4030,2,'2017-04-24 15:00:00','2017-04-24 16:00:00'),(5957,4169,2,'2017-04-24 16:00:00','2017-04-24 17:00:00'),(5958,4164,2,'2017-04-24 17:00:00','2017-04-24 18:00:00'),(5959,3679,2,'2017-04-25 09:00:00','2017-04-25 10:00:00'),(5960,2574,2,'2017-04-25 10:00:00','2017-04-25 11:00:00'),(5961,2572,2,'2017-04-25 11:00:00','2017-04-25 12:00:00'),(5962,4253,2,'2017-04-25 12:00:00','2017-04-25 13:00:00'),(5963,4254,2,'2017-04-25 14:00:00','2017-04-25 15:00:00'),(5964,3271,2,'2017-04-25 16:00:00','2017-04-25 17:00:00'),(5965,3361,2,'2017-04-25 17:00:00','2017-04-25 18:00:00'),(5966,3290,2,'2017-04-25 18:00:00','2017-04-25 19:00:00'),(5967,3362,2,'2017-04-26 09:00:00','2017-04-26 10:00:00'),(5968,2928,2,'2017-04-26 10:00:00','2017-04-26 11:00:00'),(5969,4256,2,'2017-04-26 11:00:00','2017-04-26 12:00:00'),(5970,2359,2,'2017-04-26 12:00:00','2017-04-26 13:00:00'),(5971,2564,2,'2017-04-26 14:00:00','2017-04-26 15:00:00'),(5972,2644,2,'2017-04-26 15:00:00','2017-04-26 16:00:00'),(5973,4257,2,'2017-04-26 16:00:00','2017-04-26 17:00:00'),(5974,2917,2,'2017-04-26 17:00:00','2017-04-26 18:00:00'),(5975,3556,2,'2017-04-26 18:00:00','2017-04-26 19:00:00'),(5976,4246,2,'2017-04-27 09:00:00','2017-04-27 10:00:00'),(5977,4247,2,'2017-04-27 10:00:00','2017-04-27 11:00:00'),(5978,4248,2,'2017-04-27 11:00:00','2017-04-27 12:00:00'),(5979,4249,2,'2017-04-27 12:00:00','2017-04-27 13:00:00'),(5980,4250,2,'2017-04-27 13:30:00','2017-04-27 14:30:00'),(5981,4281,2,'2017-04-27 14:30:00','2017-04-27 15:30:00'),(5982,4252,2,'2017-04-27 15:30:00','2017-04-27 16:30:00'),(5983,3124,2,'2017-04-28 09:00:00','2017-04-28 10:00:00'),(5984,3123,2,'2017-04-28 10:00:00','2017-04-28 11:00:00'),(5985,4259,2,'2017-04-28 11:00:00','2017-04-28 12:00:00'),(5986,4258,2,'2017-04-28 14:00:00','2017-04-28 15:00:00'),(5987,4260,2,'2017-04-28 15:00:00','2017-04-28 16:00:00'),(5988,75,2,'2017-05-04 10:00:00','2017-05-04 11:00:00'),(5989,30,2,'2017-05-04 09:00:00','2017-05-04 10:00:00'),(5990,634,2,'2017-05-04 11:30:00','2017-05-04 12:30:00'),(5991,43,2,'2017-05-04 13:30:00','2017-05-04 14:30:00'),(5992,83,2,'2017-05-04 15:30:00','2017-05-04 16:30:00'),(5993,2211,2,'2017-05-04 13:00:00','2017-05-04 14:00:00'),(5994,236,2,'2017-05-05 09:00:00','2017-05-05 10:00:00'),(5995,94,2,'2017-05-05 10:00:00','2017-05-05 11:00:00'),(5996,95,2,'2017-05-05 11:00:00','2017-05-05 12:00:00'),(5997,728,2,'2017-05-05 13:00:00','2017-05-05 14:00:00'),(5998,3571,2,'2017-05-05 14:00:00','2017-05-05 15:00:00'),(5999,4282,2,'2017-05-05 15:00:00','2017-05-05 16:00:00'),(6000,4283,2,'2017-05-05 16:00:00','2017-05-05 17:00:00'),(6001,3573,3,'2017-05-04 09:00:00','2017-05-04 10:00:00'),(6002,4284,3,'2017-05-04 10:00:00','2017-05-04 11:00:00'),(6003,4285,3,'2017-05-04 11:00:00','2017-05-04 12:00:00'),(6004,4109,3,'2017-05-04 14:00:00','2017-05-04 15:00:00'),(6005,2887,3,'2017-05-04 15:00:00','2017-05-04 16:00:00'),(6006,4245,3,'2017-05-04 18:00:00','2017-05-04 19:00:00'),(6007,3956,3,'2017-05-05 09:00:00','2017-05-05 10:00:00'),(6008,4244,3,'2017-05-05 10:00:00','2017-05-05 11:00:00'),(6009,859,3,'2017-05-05 11:30:00','2017-05-05 12:30:00'),(6010,4243,3,'2017-05-05 12:30:00','2017-05-05 13:30:00'),(6011,3067,3,'2017-05-05 14:00:00','2017-05-05 15:00:00'),(6012,4277,3,'2017-05-05 15:00:00','2017-05-05 16:00:00'),(6013,4286,3,'2017-05-05 16:00:00','2017-05-05 17:00:00'),(6014,1770,8,'2017-05-04 09:00:00','2017-05-04 10:00:00'),(6015,3892,8,'2017-05-04 12:00:00','2017-05-04 13:00:00'),(6016,3933,8,'2017-05-04 14:30:00','2017-05-04 15:30:00'),(6017,2423,8,'2017-05-05 11:30:00','2017-05-05 12:30:00'),(6018,163,8,'2017-05-05 14:00:00','2017-05-05 15:00:00'),(6019,2908,8,'2017-05-05 15:30:00','2017-05-05 16:30:00'),(6020,1611,7,'2017-05-03 11:00:00','2017-05-03 12:00:00'),(6021,1223,7,'2017-05-03 12:00:00','2017-05-03 13:00:00'),(6022,61,7,'2017-05-04 09:00:00','2017-05-04 10:00:00'),(6023,390,7,'2017-05-04 10:00:00','2017-05-04 11:00:00'),(6024,391,7,'2017-05-04 11:00:00','2017-05-04 12:00:00'),(6025,389,7,'2017-05-04 12:00:00','2017-05-04 13:00:00'),(6026,547,7,'2017-05-04 13:00:00','2017-05-04 14:00:00'),(6027,413,7,'2017-05-04 14:00:00','2017-05-04 15:00:00'),(6028,62,7,'2017-05-04 15:00:00','2017-05-04 16:00:00'),(6029,990,7,'2017-05-04 17:00:00','2017-05-04 18:00:00'),(6030,4287,7,'2017-05-03 13:00:00','2017-05-03 14:00:00'),(6031,4288,7,'2017-05-03 14:00:00','2017-05-03 15:00:00'),(6032,4289,7,'2017-05-04 16:00:00','2017-05-04 17:00:00');

--
-- Table structure for table `NumeroTelephone`
--

CREATE TABLE `NumeroTelephone` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `client_id` int(11) NOT NULL,
  `designation` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `numero` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_C0ECCE2D19EB6921` (`client_id`),
  CONSTRAINT `FK_C0ECCE2D19EB6921` FOREIGN KEY (`client_id`) REFERENCES `Client` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `NumeroTelephone`
--


--
-- Table structure for table `migration_versions`
--

CREATE TABLE `migration_versions` (
  `version` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `migration_versions`
--

INSERT INTO `migration_versions` VALUES ('20160626175053'),('20160705231417'),('20160705235149'),('20160726222141');


