(5005,61,7,'2017-01-12 08:30:00','2017-01-12 09:30:00'),(5006,413,7,'2017-01-12 11:00:00','2017-01-12 12:00:00'),(5007,111,7,'2017-01-12 13:00:00','2017-01-12 14:00:00'),(5008,113,7,'2017-01-12 14:00:00','2017-01-12 15:00:00'),(5009,1422,7,'2017-01-13 14:00:00','2017-01-13 15:00:00'),(5010,1061,7,'2017-01-13 15:00:00','2017-01-13 16:00:00'),(5011,1611,7,'2017-01-13 16:00:00','2017-01-13 17:00:00'),(5012,1225,7,'2017-01-13 17:00:00','2017-01-13 18:00:00'),(5013,3329,3,'2017-01-18 09:00:00','2017-01-18 10:00:00'),(5014,309,3,'2017-01-18 10:30:00','2017-01-18 11:30:00'),(5015,308,3,'2017-01-18 11:30:00','2017-01-18 12:30:00'),(5016,3171,3,'2017-01-18 13:00:00','2017-01-18 14:00:00'),(5017,2887,3,'2017-01-18 15:00:00','2017-01-18 16:00:00'),(5018,3719,3,'2017-01-18 17:00:00','2017-01-18 18:00:00'),(5019,3720,3,'2017-01-19 08:00:00','2017-01-19 09:00:00'),(5020,3573,3,'2017-01-19 09:00:00','2017-01-19 10:00:00'),(5021,3721,3,'2017-01-19 10:30:00','2017-01-19 11:30:00'),(5022,3223,3,'2017-01-19 13:30:00','2017-01-19 14:30:00'),(5023,3222,3,'2017-01-19 15:00:00','2017-01-19 16:00:00'),(5024,3230,3,'2017-01-19 17:00:00','2017-01-19 18:00:00'),(5025,3467,3,'2017-01-20 09:00:00','2017-01-20 10:00:00'),(5026,2013,3,'2017-01-20 11:00:00','2017-01-20 12:00:00'),(5027,3190,3,'2017-01-20 12:00:00','2017-01-20 13:00:00'),(5028,1269,3,'2017-01-20 15:00:00','2017-01-20 16:00:00'),(5029,1270,3,'2017-01-20 16:00:00','2017-01-20 17:00:00'),(5030,3722,3,'2017-01-19 16:00:00','2017-01-19 17:00:00'),(5031,3723,3,'2017-01-20 14:30:00','2017-01-20 15:30:00'),(5032,3740,7,'2017-01-18 08:00:00','2017-01-18 09:00:00'),(5033,986,7,'2017-01-18 09:00:00','2017-01-18 10:00:00'),(5034,985,7,'2017-01-18 10:00:00','2017-01-18 11:00:00'),(5035,1983,7,'2017-01-18 11:00:00','2017-01-18 12:00:00'),(5036,988,7,'2017-01-18 12:00:00','2017-01-18 13:00:00'),(5037,813,7,'2017-01-18 14:00:00','2017-01-18 15:00:00'),(5038,3724,7,'2017-01-18 15:00:00','2017-01-18 16:00:00'),(5039,3764,7,'2017-01-18 16:00:00','2017-01-18 17:00:00'),(5040,3763,7,'2017-01-18 17:00:00','2017-01-18 18:00:00'),(5041,3107,7,'2017-01-19 13:00:00','2017-01-19 14:00:00'),(5042,882,7,'2017-01-19 14:00:00','2017-01-19 15:00:00'),(5043,24,7,'2017-01-19 15:00:00','2017-01-19 16:00:00'),(5044,1978,7,'2017-01-19 16:00:00','2017-01-19 17:00:00'),(5045,236,2,'2017-01-25 09:00:00','2017-01-25 10:00:00'),(5046,1149,2,'2017-01-25 11:00:00','2017-01-25 12:00:00'),(5047,1187,2,'2017-01-26 09:00:00','2017-01-26 10:00:00'),(5048,883,2,'2017-01-26 10:00:00','2017-01-26 11:00:00'),(5049,634,2,'2017-01-26 12:00:00','2017-01-26 13:00:00'),(5050,84,2,'2017-01-26 13:30:00','2017-01-26 14:30:00'),(5051,42,2,'2017-01-26 15:00:00','2017-01-26 16:00:00'),(5052,2153,2,'2017-01-27 08:00:00','2017-01-27 09:00:00'),(5053,730,2,'2017-01-27 09:00:00','2017-01-27 10:00:00'),(5054,267,2,'2017-01-27 12:00:00','2017-01-27 13:00:00'),(5055,3770,2,'2017-01-27 10:00:00','2017-01-27 11:00:00'),(5056,3769,2,'2017-01-27 11:00:00','2017-01-27 12:00:00'),(5057,1939,7,'2017-01-25 08:00:00','2017-01-25 09:00:00'),(5058,92,7,'2017-01-25 09:00:00','2017-01-25 10:00:00'),(5059,3773,7,'2017-01-25 10:00:00','2017-01-25 11:00:00'),(5060,3309,7,'2017-01-25 11:00:00','2017-01-25 12:00:00'),(5061,3152,7,'2017-01-25 12:00:00','2017-01-25 13:00:00'),(5062,880,7,'2017-01-25 14:00:00','2017-01-25 15:00:00'),(5063,1422,7,'2017-01-26 11:00:00','2017-01-26 12:00:00'),(5064,631,7,'2017-01-26 12:00:00','2017-01-26 13:00:00'),(5065,3776,7,'2017-01-26 13:00:00','2017-01-26 14:00:00'),(5066,629,7,'2017-01-26 14:00:00','2017-01-26 15:00:00'),(5067,627,7,'2017-01-26 15:00:00','2017-01-26 16:00:00'),(5068,3778,7,'2017-01-26 16:00:00','2017-01-26 17:00:00'),(5069,3780,7,'2017-01-26 17:00:00','2017-01-26 18:00:00'),(5070,496,7,'2017-01-26 18:00:00','2017-01-26 19:00:00'),(5071,446,7,'2017-01-27 08:00:00','2017-01-27 09:00:00'),(5072,443,7,'2017-01-27 09:00:00','2017-01-27 10:00:00'),(5073,1801,7,'2017-01-27 10:00:00','2017-01-27 11:00:00'),(5074,2472,7,'2017-01-27 11:00:00','2017-01-27 12:00:00'),(5075,476,3,'2017-01-25 09:00:00','2017-01-25 10:00:00'),(5076,3781,3,'2017-01-25 10:30:00','2017-01-25 11:30:00'),(5077,3311,3,'2017-01-25 12:00:00','2017-01-25 13:00:00'),(5078,3190,3,'2017-01-25 13:00:00','2017-01-25 14:00:00'),(5079,3782,3,'2017-01-25 15:00:00','2017-01-25 16:00:00'),(5080,3138,3,'2017-01-25 16:30:00','2017-01-25 17:30:00'),(5081,3779,3,'2017-01-26 08:30:00','2017-01-26 09:30:00'),(5082,3222,3,'2017-01-26 09:30:00','2017-01-26 10:30:00'),(5083,3719,3,'2017-01-26 10:30:00','2017-01-26 11:30:00'),(5084,3223,3,'2017-01-26 11:00:00','2017-01-26 12:00:00'),(5085,3784,3,'2017-01-26 11:30:00','2017-01-26 12:30:00'),(5086,3785,3,'2017-01-26 14:00:00','2017-01-26 15:00:00'),(5087,3786,3,'2017-01-26 15:00:00','2017-01-26 16:00:00'),(5088,3787,3,'2017-01-26 16:00:00','2017-01-26 17:00:00'),(5089,3721,3,'2017-01-26 17:00:00','2017-01-26 18:00:00'),(5090,1260,3,'2017-01-26 18:00:00','2017-01-26 19:00:00'),(5091,3788,3,'2017-01-27 10:00:00','2017-01-27 11:00:00'),(5092,307,3,'2017-01-27 11:00:00','2017-01-27 12:00:00'),(5093,3329,3,'2017-01-27 14:00:00','2017-01-27 15:00:00'),(5094,1626,3,'2017-01-27 15:00:00','2017-01-27 16:00:00'),(5095,3869,6,'2017-01-11 07:00:00','2017-01-11 08:00:00'),(5098,3870,6,'2017-01-11 08:00:00','2017-01-11 09:00:00'),(5099,3564,6,'2017-01-11 11:00:00','2017-01-11 12:00:00'),(5100,3557,6,'2017-01-11 13:00:00','2017-01-11 14:00:00'),(5101,3871,6,'2017-01-11 15:00:00','2017-01-11 16:00:00'),(5102,405,6,'2017-01-12 08:00:00','2017-01-12 09:00:00'),(5103,45,6,'2017-01-12 09:00:00','2017-01-12 10:00:00'),(5104,3872,6,'2017-01-12 11:00:00','2017-01-12 12:00:00'),(5105,3718,6,'2017-01-12 13:00:00','2017-01-12 14:00:00'),(5106,3873,6,'2017-01-12 15:00:00','2017-01-12 16:00:00'),(5107,3874,6,'2017-01-12 17:00:00','2017-01-12 18:00:00'),(5108,335,6,'2017-01-12 19:00:00','2017-01-12 20:00:00'),(5109,3875,6,'2017-01-13 08:00:00','2017-01-13 09:00:00'),(5110,177,6,'2017-01-13 09:00:00','2017-01-13 10:00:00'),(5111,2228,6,'2017-01-13 11:00:00','2017-01-13 12:00:00'),(5112,1195,6,'2017-01-13 12:30:00','2017-01-13 13:30:00'),(5113,3755,6,'2017-01-23 08:00:00','2017-01-23 09:00:00'),(5114,1835,6,'2017-01-23 09:00:00','2017-01-23 10:00:00'),(5115,3756,6,'2017-01-23 10:00:00','2017-01-23 11:00:00'),(5116,3757,6,'2017-01-23 11:00:00','2017-01-23 12:00:00'),(5117,3758,6,'2017-01-23 14:00:00','2017-01-23 15:00:00'),(5118,3759,6,'2017-01-23 15:00:00','2017-01-23 16:00:00'),(5119,3760,6,'2017-01-23 16:00:00','2017-01-23 17:00:00'),(5120,3512,6,'2017-01-23 17:00:00','2017-01-23 18:00:00'),(5121,3762,6,'2017-01-24 08:00:00','2017-01-24 09:00:00'),(5122,3834,6,'2017-01-24 09:00:00','2017-01-24 10:00:00'),(5123,3836,6,'2017-01-24 10:00:00','2017-01-24 11:00:00'),(5124,3838,6,'2017-01-24 11:00:00','2017-01-24 12:00:00'),(5125,3839,6,'2017-01-24 14:00:00','2017-01-24 15:00:00'),(5126,3840,6,'2017-01-24 15:00:00','2017-01-24 16:00:00'),(5127,3841,6,'2017-01-24 16:00:00','2017-01-24 17:00:00'),(5128,3842,6,'2017-01-24 17:00:00','2017-01-24 18:00:00'),(5129,3844,6,'2017-01-24 18:00:00','2017-01-24 19:00:00'),(5130,1591,6,'2017-01-25 08:00:00','2017-01-25 09:00:00'),(5131,3845,6,'2017-01-25 09:00:00','2017-01-25 10:00:00'),(5132,3847,6,'2017-01-25 10:00:00','2017-01-25 11:00:00'),(5133,3848,6,'2017-01-25 11:00:00','2017-01-25 12:00:00'),(5134,3849,6,'2017-01-25 14:00:00','2017-01-25 15:00:00'),(5136,3760,6,'2017-01-25 16:00:00','2017-01-25 17:00:00'),(5137,3852,6,'2017-01-25 17:00:00','2017-01-25 18:00:00'),(5138,3853,6,'2017-01-25 18:00:00','2017-01-25 19:00:00'),(5139,3854,6,'2017-01-26 08:00:00','2017-01-26 09:00:00'),(5140,3856,6,'2017-01-26 09:00:00','2017-01-26 10:00:00'),(5141,1599,6,'2017-01-26 10:00:00','2017-01-26 11:00:00'),(5142,3859,6,'2017-01-26 11:00:00','2017-01-26 12:00:00'),(5144,3862,6,'2017-01-26 14:00:00','2017-01-26 15:00:00'),(5145,3863,6,'2017-01-26 15:00:00','2017-01-26 16:00:00'),(5147,3867,6,'2017-01-26 18:00:00','2017-01-26 19:00:00'),(5148,2550,6,'2017-01-27 08:00:00','2017-01-27 09:00:00'),(5149,3868,6,'2017-01-27 09:00:00','2017-01-27 10:00:00'),(5150,1600,6,'2017-01-27 10:00:00','2017-01-27 11:00:00'),(5151,1875,6,'2017-01-27 11:00:00','2017-01-27 12:00:00'),(5152,142,8,'2017-01-26 10:00:00','2017-01-26 11:00:00'),(5153,2449,8,'2017-01-26 11:00:00','2017-01-26 12:00:00'),(5154,41,8,'2017-01-26 13:30:00','2017-01-26 14:30:00'),(5155,1078,8,'2017-01-26 15:00:00','2017-01-26 16:00:00'),(5156,1741,8,'2017-01-26 17:00:00','2017-01-26 18:00:00'),(5157,1770,8,'2017-01-27 08:30:00','2017-01-27 09:30:00'),(5158,3077,8,'2017-01-27 09:30:00','2017-01-27 10:30:00'),(5159,3096,8,'2017-01-27 10:30:00','2017-01-27 11:30:00'),(5160,2023,8,'2017-01-27 11:30:00','2017-01-27 12:30:00'),(5161,3798,8,'2017-01-27 13:00:00','2017-01-27 14:00:00'),(5162,849,8,'2017-01-27 15:00:00','2017-01-27 16:00:00'),(5163,851,8,'2017-01-27 16:00:00','2017-01-27 17:00:00'),(5164,476,2,'2017-02-01 09:00:00','2017-02-01 10:00:00'),(5165,2478,2,'2017-02-01 11:00:00','2017-02-01 12:00:00'),(5166,3463,2,'2017-02-01 12:00:00','2017-02-01 13:00:00'),(5167,3111,2,'2017-02-01 13:00:00','2017-02-01 14:00:00'),(5168,2768,2,'2017-02-01 14:00:00','2017-02-01 15:00:00'),(5169,1615,2,'2017-02-01 15:00:00','2017-02-01 16:00:00'),(5170,3418,2,'2017-02-01 16:00:00','2017-02-01 17:00:00'),(5171,236,2,'2017-02-01 17:00:00','2017-02-01 18:00:00'),(5172,2034,2,'2017-02-02 08:00:00','2017-02-02 09:00:00'),(5173,2215,2,'2017-02-02 09:00:00','2017-02-02 10:00:00'),(5174,83,2,'2017-02-02 11:30:00','2017-02-02 12:30:00'),(5175,42,2,'2017-02-02 14:00:00','2017-02-02 15:00:00'),(5176,3877,2,'2017-02-02 17:00:00','2017-02-02 18:00:00'),(5177,2837,3,'2017-02-01 08:30:00','2017-02-01 09:30:00'),(5178,2226,3,'2017-02-01 10:30:00','2017-02-01 11:30:00'),(5179,3381,3,'2017-02-01 13:30:00','2017-02-01 14:30:00'),(5180,3882,3,'2017-02-01 15:00:00','2017-02-01 16:00:00'),(5181,3410,3,'2017-02-02 08:00:00','2017-02-02 09:00:00'),(5182,3203,3,'2017-02-02 11:00:00','2017-02-02 12:00:00'),(5183,3383,3,'2017-02-02 12:00:00','2017-02-02 13:00:00'),(5184,3883,3,'2017-02-02 15:00:00','2017-02-02 16:00:00'),(5185,3884,3,'2017-02-02 17:00:00','2017-02-02 18:00:00'),(5186,3204,3,'2017-02-03 09:00:00','2017-02-03 10:00:00'),(5187,3640,3,'2017-02-03 10:00:00','2017-02-03 11:00:00'),(5188,47,3,'2017-02-03 11:00:00','2017-02-03 12:00:00'),(5189,3885,3,'2017-02-03 16:00:00','2017-02-03 17:00:00'),(5190,3648,3,'2017-02-03 15:30:00','2017-02-03 16:30:00'),(5191,3886,3,'2017-02-01 16:00:00','2017-02-01 17:00:00'),(5192,3481,8,'2017-02-01 17:00:00','2017-02-01 18:00:00'),(5194,2381,8,'2017-02-02 10:00:00','2017-02-02 11:00:00'),(5195,2372,8,'2017-02-02 11:00:00','2017-02-02 12:00:00'),(5196,99,8,'2017-02-02 14:00:00','2017-02-02 15:00:00'),(5197,2413,8,'2017-02-02 17:00:00','2017-02-02 18:00:00'),(5198,1596,8,'2017-02-03 09:00:00','2017-02-03 10:00:00'),(5199,3095,8,'2017-02-03 14:00:00','2017-02-03 15:00:00'),(5200,3887,3,'2017-02-03 14:00:00','2017-02-03 15:00:00'),(5201,2664,8,'2017-02-02 15:00:00','2017-02-02 16:00:00'),(5202,3889,8,'2017-02-02 08:30:00','2017-02-02 09:30:00'),(5203,3891,8,'2017-02-01 07:00:00','2017-02-01 08:00:00'),(5204,3890,8,'2017-02-03 10:00:00','2017-02-03 11:00:00'),(5205,3892,8,'2017-02-03 11:30:00','2017-02-03 12:30:00'),(5206,3928,2,'2017-02-07 14:00:00','2017-02-07 15:00:00'),(5207,3929,2,'2017-02-07 15:00:00','2017-02-07 16:00:00'),(5208,3930,2,'2017-02-07 16:00:00','2017-02-07 17:00:00'),(5209,1380,2,'2017-02-08 09:00:00','2017-02-08 10:00:00'),(5210,3421,2,'2017-02-08 11:00:00','2017-02-08 12:00:00'),(5211,1862,2,'2017-02-08 14:00:00','2017-02-08 15:00:00'),(5212,3340,2,'2017-02-08 16:00:00','2017-02-08 17:00:00'),(5213,3931,2,'2017-02-08 18:30:00','2017-02-08 19:30:00'),(5214,3283,2,'2017-02-09 11:00:00','2017-02-09 12:00:00'),(5215,2719,2,'2017-02-09 17:00:00','2017-02-09 18:00:00'),(5216,663,2,'2017-02-10 10:00:00','2017-02-10 11:00:00'),(5217,924,2,'2017-02-10 11:00:00','2017-02-10 12:00:00'),(5218,2837,2,'2017-02-10 12:30:00','2017-02-10 13:30:00'),(5219,3335,2,'2017-02-10 14:00:00','2017-02-10 15:00:00'),(5220,3203,2,'2017-02-08 17:00:00','2017-02-08 18:00:00'),(5221,3204,2,'2017-02-08 19:30:00','2017-02-08 20:30:00'),(5222,925,2,'2017-02-09 10:00:00','2017-02-09 11:00:00'),(5223,28,7,'2017-02-01 08:00:00','2017-02-01 09:00:00'),(5224,1041,7,'2017-02-01 09:00:00','2017-02-01 10:00:00'),(5225,3438,7,'2017-02-01 10:00:00','2017-02-01 11:00:00'),(5226,1422,7,'2017-02-01 11:00:00','2017-02-01 12:00:00'),(5227,22,7,'2017-02-01 12:00:00','2017-02-01 13:00:00'),(5228,2273,7,'2017-02-02 09:00:00','2017-02-02 10:00:00'),(5229,748,7,'2017-02-02 10:00:00','2017-02-02 11:00:00'),(5230,78,7,'2017-02-02 11:00:00','2017-02-02 12:00:00'),(5231,114,7,'2017-02-02 12:00:00','2017-02-02 13:00:00'),(5232,3626,7,'2017-02-02 13:00:00','2017-02-02 14:00:00'),(5233,61,7,'2017-02-02 15:00:00','2017-02-02 16:00:00'),(5234,2599,7,'2017-02-03 08:00:00','2017-02-03 09:00:00'),(5235,3208,7,'2017-02-03 09:30:00','2017-02-03 10:30:00'),(5236,2209,7,'2017-02-03 10:30:00','2017-02-03 11:30:00'),(5237,1170,7,'2017-02-03 11:30:00','2017-02-03 12:30:00'),(5238,641,7,'2017-02-03 12:30:00','2017-02-03 13:30:00'),(5239,3302,7,'2017-02-03 13:30:00','2017-02-03 14:30:00'),(5240,490,7,'2017-02-03 19:00:00','2017-02-03 20:00:00'),(5241,3954,3,'2017-02-08 09:00:00','2017-02-08 10:00:00'),(5243,977,3,'2017-02-08 11:00:00','2017-02-08 12:00:00'),(5244,7,3,'2017-02-08 13:30:00','2017-02-08 14:30:00'),(5245,2478,3,'2017-02-08 14:00:00','2017-02-08 15:00:00'),(5246,2029,3,'2017-02-08 15:00:00','2017-02-08 16:00:00'),(5247,1547,3,'2017-02-08 17:00:00','2017-02-08 18:00:00'),(5248,1201,3,'2017-02-09 09:00:00','2017-02-09 10:00:00'),(5249,3955,3,'2017-02-09 10:00:00','2017-02-09 11:00:00'),(5250,3785,3,'2017-02-09 11:00:00','2017-02-09 12:00:00'),(5251,1204,3,'2017-02-09 12:00:00','2017-02-09 13:00:00'),(5252,3956,3,'2017-02-09 14:00:00','2017-02-09 15:00:00'),(5253,309,3,'2017-02-09 15:00:00','2017-02-09 16:00:00'),(5254,307,3,'2017-02-09 16:00:00','2017-02-09 17:00:00'),(5255,3230,3,'2017-02-09 17:00:00','2017-02-09 18:00:00'),(5256,1146,3,'2017-02-10 08:30:00','2017-02-10 09:30:00'),(5257,3467,3,'2017-02-10 10:00:00','2017-02-10 11:00:00'),(5258,475,3,'2017-02-10 11:30:00','2017-02-10 12:30:00'),(5259,3190,3,'2017-02-10 14:00:00','2017-02-10 15:00:00'),(5260,1149,3,'2017-02-10 15:30:00','2017-02-10 16:30:00'),(5261,476,3,'2017-02-10 16:30:00','2017-02-10 17:30:00'),(5262,1620,7,'2017-02-08 11:00:00','2017-02-08 12:00:00'),(5263,3990,7,'2017-02-08 12:00:00','2017-02-08 13:00:00'),(5264,879,7,'2017-02-08 13:00:00','2017-02-08 14:00:00'),(5265,3776,7,'2017-02-08 14:00:00','2017-02-08 15:00:00'),(5266,1062,7,'2017-02-08 15:00:00','2017-02-08 16:00:00'),(5267,1225,7,'2017-02-08 16:00:00','2017-02-08 17:00:00'),(5268,939,7,'2017-02-09 09:30:00','2017-02-09 10:30:00'),(5269,27,7,'2017-02-09 08:30:00','2017-02-09 09:30:00'),(5270,945,7,'2017-02-09 11:30:00','2017-02-09 12:30:00'),(5271,102,7,'2017-02-09 16:00:00','2017-02-09 17:00:00'),(5272,3991,7,'2017-02-09 10:30:00','2017-02-09 11:30:00'),(5273,4048,3,'2017-02-15 09:00:00','2017-02-15 10:00:00'),(5274,3955,3,'2017-02-15 09:00:00','2017-02-15 10:00:00'),(5275,4049,3,'2017-02-15 10:00:00','2017-02-15 11:00:00'),(5276,615,3,'2017-02-15 11:00:00','2017-02-15 12:00:00'),(5277,1260,3,'2017-02-15 12:00:00','2017-02-15 13:00:00'),(5278,1265,3,'2017-02-15 13:00:00','2017-02-15 14:00:00'),(5279,4050,3,'2017-02-15 14:00:00','2017-02-15 15:00:00'),(5280,4051,3,'2017-02-15 17:30:00','2017-02-15 18:30:00'),(5281,4052,3,'2017-02-15 18:00:00','2017-02-15 19:00:00'),(5282,1204,3,'2017-02-15 15:00:00','2017-02-15 16:00:00'),(5283,1734,3,'2017-02-16 08:30:00','2017-02-16 09:30:00'),(5284,3448,3,'2017-02-16 10:00:00','2017-02-16 11:00:00'),(5285,1737,3,'2017-02-16 11:30:00','2017-02-16 12:30:00'),(5286,4053,3,'2017-02-16 13:00:00','2017-02-16 14:00:00'),(5287,4012,3,'2017-02-16 14:00:00','2017-02-16 15:00:00'),(5288,7,3,'2017-02-16 15:00:00','2017-02-16 16:00:00'),(5289,2029,3,'2017-02-16 16:00:00','2017-02-16 17:00:00'),(5290,3954,3,'2017-02-16 17:00:00','2017-02-16 18:00:00'),(5291,4023,2,'2017-02-20 11:00:00','2017-02-20 12:00:00'),(5292,2625,2,'2017-02-20 14:00:00','2017-02-20 15:00:00'),(5293,2574,2,'2017-02-20 15:00:00','2017-02-20 16:00:00'),(5294,3679,2,'2017-02-20 16:00:00','2017-02-20 17:00:00'),(5295,4025,2,'2017-02-21 08:00:00','2017-02-21 09:00:00'),(5296,4055,2,'2017-02-21 09:00:00','2017-02-21 10:00:00'),(5297,4026,2,'2017-02-21 10:00:00','2017-02-21 11:00:00'),(5298,4028,2,'2017-02-21 12:00:00','2017-02-21 13:00:00'),(5299,4029,2,'2017-02-21 13:30:00','2017-02-21 14:30:00'),(5300,4056,2,'2017-02-21 14:30:00','2017-02-21 15:30:00'),(5301,4057,2,'2017-02-21 16:30:00','2017-02-21 17:30:00'),(5302,3675,2,'2017-02-20 17:00:00','2017-02-20 18:00:00'),(5303,3765,2,'2017-02-20 18:00:00','2017-02-20 19:00:00'),(5304,4030,2,'2017-02-22 08:00:00','2017-02-22 09:00:00'),(5305,4031,2,'2017-02-22 09:00:00','2017-02-22 10:00:00'),(5306,4032,2,'2017-02-22 10:00:00','2017-02-22 11:00:00'),(5307,4054,2,'2017-02-22 11:30:00','2017-02-22 12:30:00'),(5308,3669,2,'2017-02-22 12:30:00','2017-02-22 13:30:00'),(5309,4033,2,'2017-02-22 14:00:00','2017-02-22 15:00:00'),(5310,2355,2,'2017-02-22 15:00:00','2017-02-22 16:00:00'),(5311,3365,2,'2017-02-22 17:00:00','2017-02-22 18:00:00'),(5312,2348,2,'2017-02-22 18:00:00','2017-02-22 19:00:00'),(5313,3361,2,'2017-02-23 08:00:00','2017-02-23 09:00:00'),(5314,3290,2,'2017-02-23 09:00:00','2017-02-23 10:00:00'),(5315,4034,2,'2017-02-23 10:00:00','2017-02-23 11:00:00'),(5316,4035,2,'2017-02-23 11:00:00','2017-02-23 12:00:00'),(5317,4036,2,'2017-02-23 12:00:00','2017-02-23 13:00:00'),(5318,3271,2,'2017-02-23 14:00:00','2017-02-23 15:00:00'),(5319,4037,2,'2017-02-23 15:00:00','2017-02-23 16:00:00'),(5320,4039,2,'2017-02-23 16:00:00','2017-02-23 17:00:00'),(5321,4038,2,'2017-02-23 17:00:00','2017-02-23 18:00:00'),(5322,3133,2,'2017-02-23 18:00:00','2017-02-23 19:00:00'),(5323,3136,2,'2017-02-23 19:00:00','2017-02-23 20:00:00'),(5324,3657,2,'2017-02-23 20:00:00','2017-02-23 21:00:00'),(5325,4040,2,'2017-02-24 08:00:00','2017-02-24 09:00:00'),(5326,4041,2,'2017-02-24 09:00:00','2017-02-24 10:00:00'),(5327,4042,2,'2017-02-24 10:00:00','2017-02-24 11:00:00'),(5328,4043,2,'2017-02-24 11:00:00','2017-02-24 12:00:00'),(5329,4044,2,'2017-02-24 12:00:00','2017-02-24 13:00:00'),(5330,3660,2,'2017-02-24 13:00:00','2017-02-24 14:00:00'),(5331,4058,2,'2017-02-21 11:00:00','2017-02-21 12:00:00'),(5332,4059,2,'2017-02-21 17:30:00','2017-02-21 18:30:00'),(5333,4063,7,'2017-02-15 08:00:00','2017-02-15 09:00:00'),(5334,813,7,'2017-02-15 09:00:00','2017-02-15 10:00:00'),(5335,2780,7,'2017-02-15 10:00:00','2017-02-15 11:00:00'),(5336,991,7,'2017-02-15 11:00:00','2017-02-15 12:00:00'),(5337,113,7,'2017-02-15 12:00:00','2017-02-15 13:00:00'),(5338,413,7,'2017-02-15 13:00:00','2017-02-15 14:00:00'),(5339,4064,7,'2017-02-15 14:00:00','2017-02-15 15:00:00'),(5340,108,7,'2017-02-16 08:00:00','2017-02-16 09:00:00'),(5341,2271,7,'2017-02-16 09:00:00','2017-02-16 10:00:00'),(5342,3430,7,'2017-02-16 10:00:00','2017-02-16 11:00:00'),(5343,106,7,'2017-02-16 11:00:00','2017-02-16 12:00:00'),(5344,948,7,'2017-02-16 12:00:00','2017-02-16 13:00:00'),(5345,752,7,'2017-02-16 14:00:00','2017-02-16 15:00:00'),(5346,4077,3,'2017-02-22 09:00:00','2017-02-22 10:00:00'),(5347,2532,3,'2017-02-22 10:00:00','2017-02-22 11:00:00'),(5348,2109,3,'2017-02-22 11:00:00','2017-02-22 12:00:00'),(5349,4078,3,'2017-02-22 12:00:00','2017-02-22 13:00:00'),(5350,4079,3,'2017-02-22 14:00:00','2017-02-22 15:00:00'),(5351,4065,3,'2017-02-23 08:00:00','2017-02-23 09:00:00'),(5352,4066,3,'2017-02-23 09:30:00','2017-02-23 10:30:00'),(5353,4067,3,'2017-02-23 10:30:00','2017-02-23 11:30:00'),(5354,1600,3,'2017-02-23 11:30:00','2017-02-23 12:30:00'),(5355,1875,3,'2017-02-23 12:00:00','2017-02-23 13:00:00'),(5356,4068,3,'2017-02-23 13:00:00','2017-02-23 14:00:00'),(5357,4069,3,'2017-02-23 14:00:00','2017-02-23 15:00:00'),(5358,4070,3,'2017-02-23 15:00:00','2017-02-23 16:00:00'),(5359,4071,3,'2017-02-23 16:00:00','2017-02-23 17:00:00'),(5360,4072,3,'2017-02-23 17:00:00','2017-02-23 18:00:00'),(5361,2569,3,'2017-02-23 18:00:00','2017-02-23 19:00:00'),(5362,4073,3,'2017-02-24 09:00:00','2017-02-24 10:00:00'),(5363,3896,3,'2017-02-24 10:00:00','2017-02-24 11:00:00'),(5364,4074,3,'2017-02-24 11:00:00','2017-02-24 12:00:00'),(5365,2551,3,'2017-02-24 12:30:00','2017-02-24 13:30:00'),(5366,2549,3,'2017-02-24 13:30:00','2017-02-24 14:30:00'),(5367,3893,3,'2017-02-24 14:00:00','2017-02-24 15:00:00'),(5368,4075,3,'2017-02-24 15:00:00','2017-02-24 16:00:00'),(5369,4076,3,'2017-02-24 16:00:00','2017-02-24 17:00:00'),(5370,3757,3,'2017-02-24 17:00:00','2017-02-24 18:00:00'),(5371,1591,3,'2017-02-24 18:00:00','2017-02-24 19:00:00'),(5372,3388,7,'2017-02-23 08:00:00','2017-02-23 09:00:00'),(5373,3428,7,'2017-02-23 09:00:00','2017-02-23 10:00:00'),(5374,3387,7,'2017-02-23 10:00:00','2017-02-23 11:00:00'),(5375,3123,7,'2017-02-23 11:00:00','2017-02-23 12:00:00'),(5376,329,7,'2017-02-24 11:00:00','2017-02-24 12:00:00'),(5377,939,7,'2017-02-22 10:00:00','2017-02-22 11:00:00'),(5379,3856,6,'2017-02-06 08:00:00','2017-02-06 09:00:00'),(5380,3878,6,'2017-02-06 09:00:00','2017-02-06 10:00:00'),(5381,3858,6,'2017-02-06 10:00:00','2017-02-06 11:00:00'),(5382,1957,6,'2017-02-06 11:00:00','2017-02-06 12:00:00'),(5383,3879,6,'2017-02-06 14:00:00','2017-02-06 15:00:00'),(5384,1834,6,'2017-02-06 16:00:00','2017-02-06 17:00:00'),(5385,3888,6,'2017-02-06 17:00:00','2017-02-06 18:00:00'),(5386,1594,6,'2017-02-06 18:00:00','2017-02-06 19:00:00'),(5387,3893,6,'2017-02-07 08:00:00','2017-02-07 09:00:00'),(5388,3880,6,'2017-02-07 10:00:00','2017-02-07 11:00:00'),(5389,3881,6,'2017-02-07 14:00:00','2017-02-07 15:00:00'),(5390,3838,6,'2017-02-07 15:00:00','2017-02-07 16:00:00'),(5391,1591,6,'2017-02-07 17:00:00','2017-02-07 18:00:00'),(5392,2549,6,'2017-02-07 18:00:00','2017-02-07 19:00:00'),(5393,2569,6,'2017-02-08 08:00:00','2017-02-08 09:00:00'),(5394,1598,6,'2017-02-08 10:00:00','2017-02-08 11:00:00'),(5395,1832,6,'2017-02-08 11:00:00','2017-02-08 12:00:00'),(5396,1875,6,'2017-02-08 14:00:00','2017-02-08 15:00:00'),(5397,3912,6,'2017-02-08 16:00:00','2017-02-08 17:00:00'),(5398,3900,6,'2017-02-08 18:00:00','2017-02-08 19:00:00'),(5399,1337,6,'2017-02-09 08:00:00','2017-02-09 09:00:00'),(5400,3852,6,'2017-02-09 10:00:00','2017-02-09 11:00:00'),(5401,3762,6,'2017-02-09 11:00:00','2017-02-09 12:00:00'),(5402,3910,6,'2017-02-09 13:00:00','2017-02-09 14:00:00'),(5403,3916,6,'2017-02-09 15:00:00','2017-02-09 16:00:00'),(5404,3906,6,'2017-02-09 17:00:00','2017-02-09 18:00:00'),(5405,3895,6,'2017-02-10 08:00:00','2017-02-10 09:00:00'),(5406,3894,6,'2017-02-10 09:00:00','2017-02-10 10:00:00'),(5407,3896,6,'2017-02-10 10:00:00','2017-02-10 11:00:00'),(5408,3897,6,'2017-02-10 11:00:00','2017-02-10 12:00:00'),(5409,3911,6,'2017-02-10 14:00:00','2017-02-10 15:00:00'),(5410,561,6,'2017-02-22 14:00:00','2017-02-22 15:00:00'),(5411,1337,6,'2017-02-22 15:00:00','2017-02-22 16:00:00'),(5412,566,6,'2017-02-22 16:00:00','2017-02-22 17:00:00'),(5413,4080,6,'2017-02-22 17:00:00','2017-02-22 18:00:00'),(5414,349,6,'2017-02-23 08:00:00','2017-02-23 09:00:00'),(5415,1002,6,'2017-02-23 09:00:00','2017-02-23 10:00:00'),(5416,1005,6,'2017-02-23 10:00:00','2017-02-23 11:00:00'),(5417,1051,6,'2017-02-23 11:00:00','2017-02-23 12:00:00'),(5419,442,6,'2017-02-23 14:00:00','2017-02-23 15:00:00'),(5420,3250,6,'2017-02-23 17:00:00','2017-02-23 18:00:00'),(5421,386,6,'2017-02-24 08:00:00','2017-02-24 09:00:00'),(5422,558,6,'2017-02-24 09:30:00','2017-02-24 10:30:00'),(5423,2878,6,'2017-02-15 11:00:00','2017-02-15 12:00:00'),(5424,2712,6,'2017-02-15 08:00:00','2017-02-15 09:00:00'),(5425,410,6,'2017-02-15 10:00:00','2017-02-15 11:00:00'),(5427,2702,6,'2017-02-15 14:00:00','2017-02-15 15:00:00'),(5428,1337,6,'2017-02-15 16:00:00','2017-02-15 17:00:00'),(5429,3049,6,'2017-02-15 18:00:00','2017-02-15 19:00:00'),(5430,277,6,'2017-02-16 08:00:00','2017-02-16 09:00:00'),(5432,4061,6,'2017-02-16 11:00:00','2017-02-16 12:00:00'),(5433,2155,6,'2017-02-16 14:00:00','2017-02-16 15:00:00'),(5434,278,6,'2017-02-16 16:00:00','2017-02-16 17:00:00'),(5435,1051,6,'2017-02-17 08:00:00','2017-02-17 09:00:00'),(5436,3051,6,'2017-02-17 09:00:00','2017-02-17 10:00:00'),(5437,3968,6,'2017-02-17 11:00:00','2017-02-17 12:00:00'),(5438,561,6,'2017-02-17 13:00:00','2017-02-17 14:00:00'),(5439,3250,6,'2017-02-17 14:00:00','2017-02-17 15:00:00'),(5440,4081,6,'2017-02-17 16:00:00','2017-02-17 17:00:00'),(5441,567,6,'2017-02-17 19:00:00','2017-02-17 20:00:00'),(5442,901,6,'2017-02-24 11:00:00','2017-02-24 12:00:00'),(5443,3039,6,'2017-02-24 13:00:00','2017-02-24 14:00:00'),(5444,3025,6,'2017-02-24 14:00:00','2017-02-24 15:00:00'),(5445,4022,6,'2017-02-24 16:00:00','2017-02-24 17:00:00'),(5446,3954,8,'2017-02-08 09:00:00','2017-02-08 10:00:00'),(5447,3664,8,'2017-02-08 10:00:00','2017-02-08 11:00:00'),(5448,977,8,'2017-02-08 11:30:00','2017-02-08 12:30:00'),(5449,7,8,'2017-02-08 13:30:00','2017-02-08 14:30:00'),(5450,2029,8,'2017-02-08 15:00:00','2017-02-08 16:00:00'),(5451,1547,8,'2017-02-08 16:00:00','2017-02-08 17:00:00'),(5452,521,8,'2017-02-09 07:30:00','2017-02-09 08:30:00'),(5453,1698,8,'2017-02-09 08:30:00','2017-02-09 09:30:00'),(5454,2425,8,'2017-02-09 10:30:00','2017-02-09 11:30:00'),(5455,3889,8,'2017-02-09 11:30:00','2017-02-09 12:30:00'),(5456,99,8,'2017-02-09 14:00:00','2017-02-09 15:00:00'),(5457,721,2,'2017-03-01 08:30:00','2017-03-01 09:30:00'),(5458,2155,2,'2017-03-01 09:30:00','2017-03-01 10:30:00'),(5459,4061,2,'2017-03-01 10:30:00','2017-03-01 11:30:00'),(5460,2736,2,'2017-03-01 11:30:00','2017-03-01 12:30:00'),(5461,3006,2,'2017-03-01 13:30:00','2017-03-01 14:30:00'),(5462,770,2,'2017-03-02 08:00:00','2017-03-02 09:00:00'),(5463,2017,2,'2017-03-02 09:30:00','2017-03-02 10:30:00'),(5464,3403,2,'2017-03-02 11:00:00','2017-03-02 12:00:00'),(5465,3877,2,'2017-03-02 14:00:00','2017-03-02 15:00:00'),(5466,2734,2,'2017-03-02 15:00:00','2017-03-02 16:00:00'),(5467,186,2,'2017-03-02 16:00:00','2017-03-02 17:00:00'),(5468,262,2,'2017-03-03 09:00:00','2017-03-03 10:00:00'),(5469,2466,2,'2017-03-03 10:00:00','2017-03-03 11:00:00'),(5470,1199,2,'2017-03-03 11:00:00','2017-03-03 12:00:00'),(5471,2601,2,'2017-03-03 12:00:00','2017-03-03 13:00:00'),(5472,1195,2,'2017-03-03 14:00:00','2017-03-03 15:00:00'),(5473,1593,8,'2017-03-02 09:00:00','2017-03-02 10:00:00'),(5474,4085,8,'2017-03-02 11:00:00','2017-03-02 12:00:00'),(5475,4087,8,'2017-03-02 14:00:00','2017-03-02 15:00:00'),(5476,3165,8,'2017-03-02 15:00:00','2017-03-02 16:00:00'),(5477,4090,8,'2017-03-02 16:30:00','2017-03-02 17:30:00'),(5478,3109,3,'2017-03-01 08:00:00','2017-03-01 09:00:00'),(5479,1109,3,'2017-03-01 10:00:00','2017-03-01 11:00:00'),(5480,1126,3,'2017-03-01 11:30:00','2017-03-01 12:30:00'),(5481,1269,3,'2017-03-01 13:30:00','2017-03-01 14:30:00'),(5482,2718,3,'2017-03-01 15:30:00','2017-03-01 16:30:00'),(5483,980,3,'2017-03-01 17:00:00','2017-03-01 18:00:00'),(5484,4086,3,'2017-03-02 09:00:00','2017-03-02 10:00:00'),(5485,1502,3,'2017-03-02 10:00:00','2017-03-02 11:00:00'),(5486,4088,3,'2017-03-02 11:00:00','2017-03-02 12:00:00'),(5487,4089,3,'2017-03-02 14:00:00','2017-03-02 15:00:00'),(5488,1500,3,'2017-03-02 15:00:00','2017-03-02 16:00:00'),(5489,615,3,'2017-03-02 16:00:00','2017-03-02 17:00:00'),(5490,4091,3,'2017-03-02 17:00:00','2017-03-02 18:00:00'),(5491,4051,3,'2017-03-02 18:00:00','2017-03-02 19:00:00'),(5492,486,3,'2017-03-03 14:30:00','2017-03-03 15:30:00'),(5493,4092,3,'2017-03-03 15:30:00','2017-03-03 16:30:00'),(5494,4093,3,'2017-03-03 16:30:00','2017-03-03 17:30:00'),(5495,4094,3,'2017-03-03 17:30:00','2017-03-03 18:30:00'),(5496,3109,8,'2017-03-01 07:30:00','2017-03-01 08:30:00'),(5497,1109,8,'2017-03-01 10:00:00','2017-03-01 11:00:00'),(5498,1126,8,'2017-03-01 11:30:00','2017-03-01 12:30:00'),(5499,1269,8,'2017-03-01 13:30:00','2017-03-01 14:30:00'),(5500,2718,8,'2017-03-01 15:30:00','2017-03-01 16:30:00'),(5501,980,8,'2017-03-01 17:00:00','2017-03-01 18:00:00'),(5502,541,8,'2017-03-02 17:30:00','2017-03-02 18:30:00'),(5503,3437,7,'2017-02-28 16:30:00','2017-02-28 17:30:00'),(5504,2476,7,'2017-02-28 17:30:00','2017-02-28 18:30:00'),(5505,4096,7,'2017-03-02 08:00:00','2017-03-02 09:00:00'),(5506,4095,7,'2017-03-02 09:00:00','2017-03-02 10:00:00'),(5507,244,7,'2017-03-02 10:00:00','2017-03-02 11:00:00'),(5508,446,7,'2017-03-03 08:00:00','2017-03-03 09:00:00'),(5509,2235,7,'2017-03-03 11:30:00','2017-03-03 12:30:00'),(5510,650,7,'2017-03-03 14:00:00','2017-03-03 15:00:00'),(5511,496,7,'2017-03-03 17:00:00','2017-03-03 18:00:00'),(5512,3928,7,'2017-03-02 11:00:00','2017-03-02 12: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 `Rib`
--

CREATE TABLE `Rib` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom_banque` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `domiciliation` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `code_agence` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `code_guichet` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `numero_compte` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cle_rib` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `bic` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `iban` varchar(255) 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 `Rib`
--

INSERT INTO `Rib` VALUES (1,'BNP PARIBAS','BNP PARIBAS - MONTAUBAN AV PAR','30004','02606','00010036576','97','BNPAFRPPTLS','FR76 3000 4026 0600 0100 3657 697'),(2,'LCL','LCL - MONTAUBAN FUTUROPOLE','30002','04063','0000070445W','77','CRLYFRPP','FR06 3000 2040 6300 0007 0445 W77'),(3,'CREDIT AGRICOLE','CREDIT AGRICOLE - ALBIAS','11206','20161','00271964951','37','AGRIFRPP812','FR76 1120 6201 6100 2719 6495 137');

--
-- Table structure for table `fos_user`
--

CREATE TABLE `fos_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `username_canonical` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email_canonical` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  `salt` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `last_login` datetime DEFAULT NULL,
  `locked` tinyint(1) NOT NULL,
  `expired` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL,
  `confirmation_token` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `password_requested_at` datetime DEFAULT NULL,
  `roles` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  `credentials_expired` tinyint(1) NOT NULL,
  `credentials_expire_at` datetime DEFAULT NULL,
  `prenom` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `nom` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `num_vendeur` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `secteurs` longtext COLLATE utf8_unicode_ci COMMENT '(DC2Type:array)',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_957A647992FC23A8` (`username_canonical`),
  UNIQUE KEY `UNIQ_957A6479A0D96FBF` (`email_canonical`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `fos_user`
--

INSERT INTO `fos_user` VALUES (1,'ED-COLLECTIVITES','ed-collectivites','edcollectivites@gmail.com','edcollectivites@gmail.com',1,'jwovskqvp2oo080kkw00kgwg4osoww0','uNJQaUc2UUgPiwqNPbPzbd+nqT0A9dctLHMjASXjyZhNun07nHn6yAt+sTA5f+ywRay1GjyMP+zoh9NoQpXvtg==','2017-03-03 10:36:11',0,0,NULL,NULL,NULL,'a:1:{i:0;s:16:\"ROLE_SUPER_ADMIN\";}',0,NULL,'Thomas','Andrieux','28','a:1:{i:0;s:2:\"00\";}'),(2,'K-valmary','k-valmary','edckvalmary@gmail.com','edckvalmary@gmail.com',1,'kuhvi8299k0gwowoosowccs80kwgwc0','d+9txXWsgCx930WO/TvsjOEIRVNrxaK5V/Z9TsOBp9Gn8GhmXiF+naUlXC2sr006mJEIkRvbr0K5To3gbiQI3A==','2017-02-28 09:55:22',0,0,NULL,NULL,NULL,'a:0:{}',0,NULL,'Kévin','Valmary','37','a:87:{i:0;s:2:\"09\";i:1;i:11;i:2;i:12;i:4;i:48;i:6;i:31;i:7;i:32;i:8;i:46;i:9;i:47;i:10;i:81;i:11;i:82;i:13;i:30;i:16;s:2:\"01\";i:17;s:2:\"02\";i:18;s:2:\"03\";i:19;s:2:\"08\";i:5;i:10;i:20;i:14;i:21;i:18;i:23;i:21;i:24;i:22;i:25;i:23;i:26;i:25;i:27;i:27;i:28;i:28;i:29;i:29;i:30;i:35;i:31;i:36;i:32;i:37;i:33;i:38;i:34;i:39;i:35;i:41;i:36;i:42;i:37;i:44;i:38;i:45;i:39;i:49;i:40;i:50;i:41;i:51;i:42;i:52;i:43;i:53;i:44;i:54;i:45;i:55;i:46;i:56;i:47;i:57;i:48;i:58;i:49;i:59;i:50;i:60;i:51;i:61;i:52;i:62;i:53;i:67;i:54;i:68;i:55;i:69;i:56;i:70;i:57;i:71;i:58;i:72;i:59;i:73;i:60;i:74;i:61;i:75;i:62;i:76;i:63;i:77;i:64;i:78;i:65;i:79;i:66;i:80;i:67;i:85;i:70;i:88;i:71;i:89;i:72;i:90;i:73;i:91;i:74;i:92;i:75;i:93;i:76;i:94;i:77;i:95;i:82;i:86;i:84;s:2:\"04\";i:85;s:2:\"06\";i:12;i:15;i:86;i:19;i:87;i:34;i:88;i:63;i:89;i:64;i:90;i:65;i:91;i:66;i:92;i:87;i:93;i:13;i:94;i:17;i:95;i:16;i:96;i:24;i:97;i:83;}'),(3,'Q-beil','q-beil','edc.qbeil@gmail.com','edc.qbeil@gmail.com',1,'7jyt4y6xqs08kk8ocokgsgwgw04goc4','m74ZlxmAFJv1KPxhtRtD9jSZfAwm1AfFha2g2nTqD4t4wgcY24tdVH/dQgfqO1ggl+ctc47P8bHDACKtg4C77Q==','2017-02-28 14:13:26',0,0,NULL,NULL,NULL,'a:0:{}',0,NULL,'Quentin','Beil','39','a:82:{i:3;i:31;i:4;i:32;i:6;i:46;i:7;i:47;i:8;i:81;i:9;i:82;i:10;s:2:\"04\";i:11;i:64;i:12;i:65;i:1;s:2:\"06\";i:14;i:66;i:15;i:38;i:16;i:73;i:17;i:74;i:18;s:2:\"01\";i:19;s:2:\"02\";i:2;s:2:\"03\";i:5;s:2:\"08\";i:20;i:10;i:21;i:14;i:23;i:18;i:24;i:21;i:25;i:22;i:26;i:23;i:27;i:25;i:28;i:27;i:29;i:28;i:30;i:29;i:31;i:35;i:32;i:36;i:33;i:37;i:34;i:39;i:35;i:41;i:36;i:42;i:38;i:44;i:39;i:45;i:40;i:49;i:41;i:50;i:42;i:51;i:43;i:52;i:44;i:53;i:45;i:54;i:46;i:55;i:47;i:56;i:48;i:57;i:49;i:58;i:50;i:59;i:51;i:60;i:52;i:61;i:53;i:62;i:55;i:67;i:56;i:68;i:57;i:69;i:58;i:70;i:59;i:71;i:60;i:72;i:61;i:75;i:62;i:76;i:63;i:77;i:64;i:78;i:65;i:79;i:66;i:80;i:67;i:85;i:70;i:88;i:71;i:89;i:72;i:90;i:73;i:91;i:74;i:92;i:75;i:93;i:76;i:94;i:77;i:95;i:82;i:15;i:13;i:19;i:84;i:86;i:85;i:63;i:86;i:87;i:88;i:83;i:89;s:2:\"09\";i:90;i:11;i:91;i:12;i:92;i:30;i:93;i:48;}'),(4,'JC-labeuche','jc-labeuche','jc.labeuche.edc@outlook.fr','jc.labeuche.edc@outlook.fr',1,'5iuhzte41ew4c8wo4okowowogs40k8c','galylURd8WXCYdZEey9YbIzg02xHeOHWjOorCrytMcr26vOn5RQ56ddtBN4INMdD05Gms7hLMGFEMhL5kXM3AA==','2017-02-17 08:33:45',0,0,NULL,NULL,NULL,'a:0:{}',0,NULL,'jean-charles','Labeuche','29','a:96:{i:0;s:2:\"01\";i:1;s:2:\"02\";i:2;s:2:\"03\";i:3;s:2:\"04\";i:4;s:2:\"05\";i:5;s:2:\"06\";i:6;s:2:\"07\";i:7;s:2:\"08\";i:8;s:2:\"09\";i:9;i:10;i:10;i:11;i:11;i:12;i:12;i:13;i:13;i:14;i:14;i:15;i:15;i:16;i:16;i:17;i:17;i:18;i:18;i:19;i:19;i:20;i:20;i:21;i:21;i:22;i:22;i:23;i:23;i:24;i:24;i:25;i:25;i:26;i:26;i:27;i:27;i:28;i:28;i:29;i:29;i:30;i:30;i:31;i:31;i:32;i:32;i:33;i:33;i:34;i:34;i:35;i:35;i:36;i:36;i:37;i:37;i:38;i:38;i:39;i:39;i:40;i:40;i:41;i:41;i:42;i:42;i:43;i:43;i:44;i:44;i:45;i:45;i:46;i:46;i:47;i:47;i:48;i:48;i:49;i:49;i:50;i:50;i:51;i:51;i:52;i:52;i:53;i:53;i:54;i:54;i:55;i:55;i:56;i:56;i:57;i:57;i:58;i:58;i:59;i:59;i:60;i:60;i:61;i:61;i:62;i:62;i:63;i:63;i:64;i:64;i:65;i:65;i:66;i:66;i:67;i:67;i:68;i:68;i:69;i:69;i:70;i:70;i:71;i:71;i:72;i:72;i:73;i:73;i:74;i:74;i:75;i:75;i:76;i:76;i:77;i:77;i:78;i:78;i:79;i:79;i:80;i:80;i:81;i:81;i:82;i:82;i:83;i:83;i:84;i:84;i:85;i:85;i:86;i:86;i:87;i:87;i:88;i:88;i:89;i:89;i:90;i:90;i:91;i:91;i:92;i:92;i:93;i:93;i:94;i:94;i:95;i:95;i:97;}'),(6,'D-ejarque','d-ejarque','edc.dejarque@gmail.com','edc.dejarque@gmail.com',1,'sylx5cqa8zk0k40cowkkscockcwkc4o','FRfaqu6DhSzicog7DgKzBHmsyZOToeRKQyRQdAqOcEOfzERR4tMjojDK2j0qYpIo8vT2OtTDCluexe3UvrvYdw==','2017-03-01 09:59:57',0,0,NULL,NULL,NULL,'a:0:{}',0,NULL,'Davy','Ejarque','46','a:72:{i:1;i:16;i:2;i:17;i:3;i:24;i:4;i:31;i:5;i:32;i:6;i:33;i:7;i:40;i:8;i:46;i:9;i:47;i:10;i:81;i:11;i:82;i:12;i:27;i:13;s:2:\"01\";i:14;s:2:\"02\";i:15;s:2:\"03\";i:16;s:2:\"08\";i:17;i:10;i:18;i:14;i:20;i:18;i:22;i:21;i:23;i:22;i:24;i:23;i:25;i:25;i:26;i:28;i:27;i:29;i:28;i:35;i:29;i:36;i:30;i:37;i:31;i:38;i:32;i:39;i:33;i:41;i:34;i:42;i:36;i:44;i:37;i:45;i:38;i:49;i:39;i:50;i:40;i:51;i:41;i:52;i:42;i:53;i:43;i:54;i:44;i:55;i:45;i:56;i:46;i:57;i:47;i:58;i:48;i:59;i:49;i:60;i:50;i:61;i:51;i:62;i:53;i:67;i:54;i:68;i:55;i:69;i:56;i:70;i:57;i:71;i:58;i:72;i:59;i:73;i:60;i:74;i:61;i:75;i:62;i:76;i:63;i:77;i:64;i:78;i:65;i:79;i:66;i:80;i:67;i:85;i:70;i:88;i:71;i:89;i:72;i:90;i:73;i:91;i:74;i:92;i:75;i:93;i:76;i:94;i:77;i:95;i:78;i:86;}'),(7,'JP-colonna','jp-colonna','edc.jpcolonna@gmail.com','edc.jpcolonna@gmail.com',1,'100mg3p3mrb448osgwksg000k0g8cww','TOJAHUP5YB0Y4n1NHydhW9OW4IRVtwDnUjrSsBma7mWkX4eXjSa298pk73HlRqHIJ1GKgVgVR65hExWMJaCuBQ==','2017-03-02 15:56:19',0,0,NULL,NULL,NULL,'a:0:{}',0,NULL,'Jean-philippe','Colonna','44','a:74:{i:0;s:2:\"05\";i:1;s:2:\"07\";i:3;i:13;i:4;i:26;i:5;i:31;i:6;i:32;i:7;i:46;i:8;i:47;i:9;i:81;i:10;i:82;i:11;i:83;i:12;i:84;i:14;i:43;i:15;s:2:\"01\";i:16;s:2:\"02\";i:17;s:2:\"03\";i:18;s:2:\"08\";i:19;i:10;i:20;i:14;i:21;i:18;i:23;i:21;i:24;i:22;i:25;i:23;i:26;i:25;i:27;i:27;i:28;i:28;i:29;i:29;i:30;i:35;i:31;i:36;i:32;i:37;i:33;i:38;i:34;i:39;i:35;i:41;i:36;i:42;i:37;i:44;i:38;i:45;i:39;i:49;i:40;i:50;i:41;i:51;i:42;i:52;i:43;i:53;i:44;i:54;i:45;i:55;i:46;i:56;i:47;i:57;i:48;i:58;i:49;i:59;i:50;i:60;i:51;i:61;i:52;i:62;i:54;i:67;i:55;i:68;i:56;i:69;i:57;i:70;i:58;i:71;i:59;i:72;i:60;i:73;i:61;i:74;i:62;i:75;i:63;i:76;i:64;i:77;i:65;i:78;i:66;i:79;i:67;i:80;i:68;i:85;i:71;i:88;i:72;i:89;i:73;i:90;i:74;i:91;i:75;i:92;i:76;i:93;i:77;i:94;i:78;i:95;i:70;i:86;}'),(8,'C-beil','c-beil','edc.cbeil@gmail.com','edc.cbeil@gmail.com',1,'idbiu2tawxwgsc44gw0w88w4gkowkwg','FwAdNfESM9ec5A/OpBY4usNQVM+QuZwp+nQIlrQfKfoK2FP3JoJXJrxCUst65e6O1WdmmZpvOjqy1nnl5pSWIQ==','2017-02-28 17:18:37',0,0,NULL,NULL,NULL,'a:0:{}',0,NULL,'Clément','Beil','45','a:82:{i:1;i:31;i:2;i:32;i:3;i:46;i:4;i:47;i:5;i:81;i:6;i:82;i:7;s:2:\"01\";i:8;s:2:\"02\";i:9;s:2:\"03\";i:10;s:2:\"08\";i:11;i:10;i:12;i:14;i:13;i:15;i:14;i:18;i:15;i:19;i:16;i:21;i:17;i:22;i:18;i:23;i:19;i:25;i:20;i:27;i:21;i:28;i:22;i:29;i:23;i:35;i:24;i:36;i:25;i:37;i:26;i:38;i:27;i:39;i:28;i:41;i:29;i:42;i:31;i:44;i:32;i:45;i:33;i:49;i:34;i:50;i:35;i:51;i:36;i:52;i:37;i:53;i:38;i:54;i:39;i:55;i:40;i:56;i:41;i:57;i:42;i:58;i:43;i:59;i:44;i:60;i:45;i:61;i:46;i:62;i:47;i:63;i:48;i:67;i:49;i:68;i:50;i:69;i:51;i:70;i:52;i:71;i:53;i:72;i:54;i:73;i:55;i:74;i:56;i:75;i:57;i:76;i:58;i:77;i:59;i:78;i:60;i:79;i:61;i:80;i:62;i:85;i:63;i:86;i:64;i:87;i:65;i:88;i:66;i:89;i:67;i:90;i:68;i:91;i:69;i:92;i:70;i:93;i:71;i:94;i:72;i:95;i:78;s:2:\"04\";i:79;s:2:\"06\";i:80;i:64;i:81;i:65;i:82;i:66;i:83;i:34;i:84;s:2:\"09\";i:85;i:11;i:86;i:12;i:87;i:30;i:88;i:48;}'),(9,'jsalmon','jsalmon','jsalmon.edc@gmail.com','jsalmon.edc@gmail.com',1,'7zhdnhb5oqkgcsoc88gwcoswcwsokg0','57dImuMS97Nsa5GFdNLDOXSSP5n4kHbYdu+JuIZ3MzMOl/9e46JXjZtsaX0t1GmOes8JLREtxiUHUYxC60yXeQ==','2017-03-01 09:16:27',0,0,NULL,NULL,NULL,'a:0:{}',0,NULL,'Jean-baptiste','Salmon','0','a:96:{i:0;s:2:\"01\";i:1;s:2:\"02\";i:2;s:2:\"03\";i:3;s:2:\"04\";i:4;s:2:\"05\";i:5;s:2:\"06\";i:6;s:2:\"07\";i:7;s:2:\"08\";i:8;s:2:\"09\";i:9;i:10;i:10;i:11;i:11;i:12;i:12;i:13;i:13;i:14;i:14;i:15;i:15;i:16;i:16;i:17;i:17;i:18;i:18;i:19;i:19;i:20;i:20;i:21;i:21;i:22;i:22;i:23;i:23;i:24;i:24;i:25;i:25;i:26;i:26;i:27;i:27;i:28;i:28;i:29;i:29;i:30;i:30;i:31;i:31;i:32;i:32;i:33;i:33;i:34;i:34;i:35;i:35;i:36;i:36;i:37;i:37;i:38;i:38;i:39;i:39;i:40;i:40;i:41;i:41;i:42;i:42;i:43;i:43;i:44;i:44;i:45;i:45;i:46;i:46;i:47;i:47;i:48;i:48;i:49;i:49;i:50;i:50;i:51;i:51;i:52;i:52;i:53;i:53;i:54;i:54;i:55;i:55;i:56;i:56;i:57;i:57;i:58;i:58;i:59;i:59;i:60;i:60;i:61;i:61;i:62;i:62;i:63;i:63;i:64;i:64;i:65;i:65;i:66;i:66;i:67;i:67;i:68;i:68;i:69;i:69;i:70;i:70;i:71;i:71;i:72;i:72;i:73;i:73;i:74;i:74;i:75;i:75;i:76;i:76;i:77;i:77;i:78;i:78;i:79;i:79;i:80;i:80;i:81;i:81;i:82;i:82;i:83;i:83;i:84;i:84;i:85;i:85;i:86;i:86;i:87;i:87;i:88;i:88;i:89;i:89;i:90;i:90;i:91;i:91;i:92;i:92;i:93;i:93;i:94;i:94;i:95;i:95;i:97;}');

--
-- 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');


