-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathAssegtur.sql
671 lines (584 loc) · 72.4 KB
/
Assegtur.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
-- MySQL dump 10.13 Distrib 5.7.30, for Linux (x86_64)
--
-- Host: 127.0.0.1 Database: assegtur
-- ------------------------------------------------------
-- Server version 5.7.30-0ubuntu0.18.04.1
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `aboutus`
--
DROP TABLE IF EXISTS `aboutus`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `aboutus` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`entitle` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`trtitle` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`frtitle` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`entext` text COLLATE utf8mb4_unicode_ci NOT NULL,
`frtext` text COLLATE utf8mb4_unicode_ci NOT NULL,
`trtext` text COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `aboutus`
--
LOCK TABLES `aboutus` WRITE;
/*!40000 ALTER TABLE `aboutus` DISABLE KEYS */;
INSERT INTO `aboutus` VALUES (1,'About us','Hakkımızda','A propos de nous','<p><span style=\"font-family:Times New Roman,Times,serif\">Our young association is growing a little more each day. To become a member, simply register by filling out the form below and we will be happy to welcome you among us.</span></p>','<p><span style=\"font-family:Times New Roman,Times,serif\"><span style=\"color:#4a4a4a\"><span style=\"font-size:medium\"><span style=\"background-color:#ffffff\">Notre jeune association grandit un peu plus chaque jour. Pour en devenir membre, il vous suffit de vous inscrire en remplissant le formulaire ci-dessous et nous serons râvis de vous accueillir parmi nous.</span></span></span></span></p>','<p><span style=\"font-family:Times New Roman,Times,serif\">Genç derneğimiz her geçen gün biraz daha büyüyor. Üye olmak için aşağıdaki formu doldurarak kayıt olmanız yeterli, sizi aramızda görmekten memnuniyet duyarız.</span></p>','2020-04-06 13:52:45','2020-04-06 13:52:45');
/*!40000 ALTER TABLE `aboutus` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `activities`
--
DROP TABLE IF EXISTS `activities`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `activities` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`entitle` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`trtitle` varchar(191) CHARACTER SET utf8 NOT NULL,
`frtitle` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
`ensummary` text COLLATE utf8mb4_unicode_ci NOT NULL,
`trsummary` text CHARACTER SET utf8 NOT NULL,
`frsummary` text COLLATE utf8mb4_unicode_ci NOT NULL,
`images` text COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `activities`
--
LOCK TABLES `activities` WRITE;
/*!40000 ALTER TABLE `activities` DISABLE KEYS */;
INSERT INTO `activities` VALUES (4,'ASSEGTUR reception at the Embassy of Guinea','gine büyükelçiliği ASSEGTUR ile buluştu','Réception De l\'ASSEGTUR à l\'ambassade de la Guinée','reception-ambassade','1590118515.jpeg','1','<p>We were warmly received by the Embassy of Guinea in Turkey. During this meeting we discussed on the question of students and also of our projects in synergy of action. After a very tense and productive debate, the executive office of ASSEGTUR took the return ticket in order to further reformulate our ambitions in the interest of all Guinean students in Turkey.</p>','<p>Gine Büyükelçiliği tarafından sıcak bir şekilde karşılandık. Bu toplantıda öğrenciler ve eylem sinerjisi konusundaki projelerimiz hakkında konuştuk. Çok gergin ve verimli bir tartışmadan sonra, ASSEGTUR yönetim ofisi, Türkiye'deki tüm Gine öğrencilerinin ilgisine yönelik hırslarımızı daha da geliştirmek için dönüş biletini aldı.</p>','<p>Nous avons été reçu par l'ambassade de la Guinée en Turquie de façon chaleureuse. Au cours de cette rencontre nous avons discuté sur la question des étudiants et aussi de nos projets en synergie d'action. Après un débat très tendu et productif, le bureau exécutif de l'ASSEGTUR a pris le billet de retour afin de reformuler encore nos ambitions dans l'intérêt de tous les étudiants guinéens en Turquie.</p>','abassade_1590118516.jpeg','2020-05-22 00:35:16','2020-05-22 00:35:16'),(5,'Visit to the Albayrak company','Albayrak şirketini ziyareti','Visite au sein de la société Albayrak','albayrak-visit','1590121753.jpeg','1','<p>This Monday July 29, 2019, a friendship visit within the Turkish company Albayarak and it was an opportunity for me as president to meet my compatriots former Guinean students in Turkey who work there ... Thank you very much for the welcome and I will come back soon for the continuation of our friendly discussions.</p>','<p>29 Temmuz 2019 Pazartesi günü, Türk firması Albayarak içinde bir dostluk ziyareti oldu ve cumhurbaşkanı olarak orada çalışan Türkiye'deki eski Gine öğrencilerimle tanışmak benim için bir fırsattı ... Karşılama için çok teşekkür ederim ve geleceğim dostane tartışmalarımızın devamı için yakında.</p>','<p>Ce lundi 29 juillet 2019 , une visite d'amitié au sein de la société Turque Albayarak et c'était une opportunité pour moi en tant que président de rencontrer mes compatriotes anciens étudiants guinéens en Turquie qui y travaillent... Merci beaucoup pour l'accueil et je reviendrai bientôt pour la suite de nos discussions amicales.</p>','251_1590118874.jpeg , 25_1590118874.jpeg','2020-05-22 00:41:14','2020-05-22 00:41:14'),(7,'The Guinean Student Forum','Gineli Öğrenciler Forumu','Le Forum De L\'étudiant Guinéen','forum-slug','1590121706.jpeg','1','<p>The Guinean student forum which took place on February 2, 2020 is the very first forum organized by ASSEGTUR and aimed to bring Guineans and Turkish companies together around the same table in order to be able to discuss various subjects and varied and to bring the Guinean student closer to these so-called companies to allow him to gain experience and discover the work provided by the different businessmen who were present that day.</p>\r\n\r\n<p>The forum which was sponsored by YTB (Türkiye Bursları) was a memorable and enjoyable event for us Guineans who also had the chance to find our compatriots in great shape, to have been able to exchange and discuss with them in an atmosphere of fraternity and solidarity...</p>','<p>2 Şubat 2020'de düzenlenen Gineli öğrenciler forumu, ASSEGTUR tarafından düzenlenen ve çeşitli konuları tartışabilmek ve Gine öğrencisini getirmek için Gine ve Türk şirketlerini aynı masa etrafında bir araya getirmeyi amaçlayan ilk forumdur. o sözde şirketlere yakınlaşarak, tecrübe kazanmasına ve o gün hazır bulunan farklı iş adamları tarafından sağlanan çalışmaları keşfetmesine olanak sağladı.</p>\r\n\r\n<p>YTB (Türkiye Bursları) sponsorluğunda gerçekleşen forum, yurttaşlarımızı çok formda bulma, onlarla kardeşlik ve dayanışma atmosferinde görüşme ve tartışma fırsatı bulan Guineans için unutulmaz ve keyifli bir etkinlikti. ...</p>','<p>Le forum de l'etudiant guinén qui eu lieu le 2 Février 2020 est le tout premier forum organisé par l'ASSEGTUR et avait pour but de reunir les guinéens et les entreprises turques autour d'une même table afin de pouvoir discuter de sujets divers et variés et de rapprocher l'étudiant guinéen a ces dites entreprises pour lui permettre d'acquérir de l'experience et de découvrir le travail fourni par les differents hommes D'affaires qui était présents ce jour.</p>\r\n\r\n<p>Le forum qui était sponsorisé par YTB(Türkiye Bursları) était un évenement marquant et jouissif pour nous guinéns qui avont aussi eu la chance de retrouver nos compatriotes en pleine forme, d'avoir pu echanger et discuter avec eux dans une atmosphère de fraternité et de solidarité...</p>','wp-2014-08-milky-way-1023340_1280_1590121706.jpg , 84598021_1356711897833155_3500777329859231744_o_1590121706.jpg , 84442665_1356710607833284_401225274877804544_o_1590121706.jpg , 84355651_1356712004499811_283482311280820224_o_1590121707.jpg , 84344719_1356711784499833_2954032051822526464_o_1590121707.jpg , 84298511_1356711554499856_5867871718084706304_o_1590121707.jpg , 84143531_1356711227833222_2919786864527278080_o_1590121707.jpg , 83990847_1356710404499971_5374608717142556672_o_1590121707.jpg , 83907093_1356711644499847_3399031087920316416_o_1590121707.jpg , 83882080_1356710514499960_4082151181151895552_o_1590121707.jpg , 83770376_1356709994500012_7840573080723259392_o_1590121707.jpg , 83707429_1356711457833199_8958786864416817152_o_1590121707.jpg , 83290100_1356710131166665_5088126813587111936_o_1590121707.jpg , 83245580_1356709574500054_1151502211189047296_o_1590121708.jpg','2020-05-22 01:28:28','2020-05-22 01:28:28');
/*!40000 ALTER TABLE `activities` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `activities_and_gallery`
--
DROP TABLE IF EXISTS `activities_and_gallery`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `activities_and_gallery` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`subtitle` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`body` text COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `activities_and_gallery`
--
LOCK TABLES `activities_and_gallery` WRITE;
/*!40000 ALTER TABLE `activities_and_gallery` DISABLE KEYS */;
/*!40000 ALTER TABLE `activities_and_gallery` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `articles`
--
DROP TABLE IF EXISTS `articles`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `articles` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`author` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`frtitle` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`entitle` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`trtitle` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`file` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`enbody` text COLLATE utf8mb4_unicode_ci NOT NULL,
`trbody` text COLLATE utf8mb4_unicode_ci NOT NULL,
`frbody` text COLLATE utf8mb4_unicode_ci NOT NULL,
`image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`language` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `articles`
--
LOCK TABLES `articles` WRITE;
/*!40000 ALTER TABLE `articles` DISABLE KEYS */;
INSERT INTO `articles` VALUES (5,'Ibrahima CHERIF','ANALYSE POLITIQUE DE LA PANDEMİE CORONAVIRUS (COVID-19)','POLITICAL ANALYSIS OF THE CORONAVIRUS PANDEMIC (COVID-19)','SALGINI KÖRONA SİYASET ANALİZİ','Analyse Politique COVİD-19.pdf','<p>The Coronavirus or COVID-2019 pandemic has become a global debate. Everyone interprets according to the evolution of things, there is the political, religious and ecological and scientific angel. This is why a political analysis deserves its place to define and explain the interpretations and justifications on Covid-2019.</p>','<p>Coronavirus veya COVID-2019 pandemisi küresel bir tartışma haline geldi. Herkes olayların evrimine göre yorum yapar, siyasi, dini ve ekolojik ve bilimsel melek vardır. Bu nedenle politik bir analiz, Covid-2019'daki yorumları ve gerekçeleri tanımlamak ve açıklamak için yerini hak ediyor.</p>','<p>La pandémie Coronavirus ou COVID-2019 est devenue un débat mondial. Chacun interprète selon l'évolution des choses, il y a l'ange politique, religieux et écologique et scientifique. C'est pourquoi une analyse politique mérite sa place pour définir et expliquer les interprétations et justifications sur Covid-2019.</p>',NULL,'2020-05-12 10:55:09','2020-05-12 10:55:09','Français'),(6,'Moussa SIDIBE','Géologie, géochimie et origine des dépôts de bauxite dans la région de Kindia (Guinée, Afrique de l\'Ouest)','Geology, Geochemistry and Origin of Bauxite Deposits in Kindia (Guinea, West Africa) Region','Kindia (Gine, Batı Afrika) bölgesindeki boksit yataklarının jeolojisi, jeokimyası ve kökeni','THESE1.pdf','<p>Debele and Balaya bauxite plateaus are plateaus on the Ordovician and Silurian formations in the southern parts of the Guinean Paleozoic Bove Basin in the eastern part of the West African Kraton. These plateaus belong to the Kindia bauxite provinces. Previous studies in the area have revealed the presence of two types of bauxites on these two plateaus: lateritic bauxites and re-accumulating sedimentary bauxites. Although the reprocessing characteristics of these sedimentary bauxites are quite clear, their original relationship with the lateritic bauxite and Silurian formations is discussed. To contribute to this geological problem, petrographic, mineralogical and geochemical investigations were carried out on different types of bauxites found in the Balaya and Debele plateaus.</p>','<p>Debele ve Balaya boksit platoları, Batı Afrika Kraton’unun doğu kısmındaki Gine Paleozoyik Bove Havzası’nın güney kısımlarında bulunan Ordovisyen ve Silüriyen formasyonların üzerinde yer alan platolardır. Bu platolar Kindia boksit provensine aittir. Bölgede yapılan önceki çalışmalar, bu iki platolar üzerindeki boksitlerin iki tipinin varlığını ortaya çıkarmıştır: yerinde oluşan lateritik boksitler ve yeniden biriken sedimanter boksitler. Her ne kadar bu sedimanter boksitlerin yeniden işleme karakterleri oldukça net olsa da, çevresindeki lateritik boksitler ve Silüriyen formasyonlar ile olan kökensel ilişkisi tartışılmaktadır. Bu jeolojik soruna katkıda bulunmak için, Balaya ve Debele platolarında bulunan farklı türdeki boksitler üzerinde petrografik, mineralojik ve jeokimyasal incelemeleri yapılmıştır.</p>','<p>Les plateaux de bauxite Debele et Balaya sont des plateaux des formations ordovicienne et silurienne dans les parties méridionales du bassin du Paléozoïque guinéen dans la partie orientale du Kraton ouest-africain. Ces plateaux appartiennent aux provinces de bauxite de Kindia. Des études antérieures dans la région ont révélé la présence de deux types de bauxites sur ces deux plateaux: la bauxite latéritique et la bauxite sédimentaire à ré-accumulation. Bien que les caractéristiques de retraitement de ces bauxites sédimentaires soient assez claires, leur relation d'origine avec la bauxite latéritique et les formations siluriennes est discutée. Pour contribuer à ce problème géologique, des recherches pétrographiques, minéralogiques et géochimiques ont été menées sur différents types de bauxites trouvés dans les plateaux de Balaya et Debele.</p>',NULL,'2020-05-12 13:42:18','2020-05-12 13:42:18','Türkçe'),(7,'ANTOINE TAMABA MILLIMONO','ANALYSE DE LA RELATION BILATERALE ENTRE LA TURQUIE ET LA GUINEE:POLITIQUE DIPLOMATIQUE ET LA DIMENSION ECONOMIQUE','ANALYSIS OF BILATERAL BETWEEN TURKEY AND GUINEA: POLITICAL -DIPLOMATIC AND ECONOMIC DIMENSIONS','TÜRKİYE VE GİNE ARASINDA İKİLİ ANALİZ: SİYASİ-DİPLOMATİK VE EKONOMİK BOYUTLAR','THESE2.pdf','<p>Guinea Republic of Turkey in the past eight years has significantly developed multi-dimensional relations. The Republic of Guinea "Look-East" policy and the Republic of Turkey "Africa Initiative" policy-oriented and this relationship, the peculiar dynamics, has led to the development and impact. However, there is still a lack of research on these relationships. Therefore, this thesis, with an emphasis on current political and economic cooperation between the two countries aims to analyze the Turkey-Guinea relations.</p>','<p>Türkiye ile Gine Cumhuriyeti arasında son sekiz yılda önemli ölçüde gelişen çok boyutlu ilişkiler vardır. Gine Cumhuriyeti’nin “Doğuya-Bak” politikası ve Türkiye Cumhuriyeti’nin “Afrika’ya Açılım” politikası ile yönlendirilen bu ilişki, kendine has dinamiklere, gelişim yollarına ve etkilere sahiptir. Ancak, hala bu ilişkiler hakkında araştırma eksikliği vardır. Bu nedenle bu tez, iki ülke arasındaki mevcut siyasi ve ekonomik işbirliğine vurgu yaparak Türkiye-Gine ilişkilerini analiz etmeyi amaçlamaktadır</p>','<p>La République de Guinée de Turquie au cours des huit dernières années a développé de manière significative des relations multidimensionnelles. La politique "Look-East" de la République de Guinée et la "Initiative Afrique" de la République de Turquie sont orientées vers la politique et cette relation, la dynamique particulière, a conduit au développement et à l'impact. Cependant, il y a encore un manque de recherche sur ces relations. Par conséquent, cette thèse, mettant l'accent sur la coopération politique et économique actuelle entre les deux pays, vise à analyser les relations Turquie-Guinée.</p>',NULL,'2020-05-27 12:40:23','2020-05-27 12:40:23','English');
/*!40000 ALTER TABLE `articles` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `articles_departments`
--
DROP TABLE IF EXISTS `articles_departments`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `articles_departments` (
`articles_id` int(10) unsigned NOT NULL,
`departments_id` int(10) unsigned NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
KEY `articles_departments_articles_id_index` (`articles_id`),
KEY `articles_departments_departments_id_index` (`departments_id`),
CONSTRAINT `articles_departments_articles_id_foreign` FOREIGN KEY (`articles_id`) REFERENCES `articles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `articles_departments`
--
LOCK TABLES `articles_departments` WRITE;
/*!40000 ALTER TABLE `articles_departments` DISABLE KEYS */;
INSERT INTO `articles_departments` VALUES (5,2,NULL,NULL),(6,3,NULL,NULL),(7,2,NULL,NULL);
/*!40000 ALTER TABLE `articles_departments` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `boardmembers`
--
DROP TABLE IF EXISTS `boardmembers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `boardmembers` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`entitle` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`trtitle` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`frtitle` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`facebook` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`twitter` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`instagram` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `boardmembers`
--
LOCK TABLES `boardmembers` WRITE;
/*!40000 ALTER TABLE `boardmembers` DISABLE KEYS */;
INSERT INTO `boardmembers` VALUES (2,'Ibrahima Cherif','President','Başkan','Président','[email protected]','https://www.facebook.com/ibrahimacher',NULL,NULL,'1588184858.jpg','2020-04-29 15:27:38','2020-04-29 15:27:38'),(3,'Mamadou Saidou Barry','Vice-President','Başkan yardımcı','Vice-Président','[email protected]','https://www.facebook.com/fofana.salioubailo',NULL,NULL,'1590592518.jpeg','2020-05-22 01:54:04','2020-05-22 01:54:04'),(4,'Saliou Bailo Fofana','Vice-President','Başkan yardımcı','Vice-Président','[email protected]',NULL,NULL,NULL,'1590592567.jpg','2020-05-22 01:56:17','2020-05-22 01:56:17'),(5,'Alain Fangamou','Treasurer','veznedar','Trésorier','[email protected]','https://www.facebook.com/alain.fangamou.92',NULL,NULL,'1590123490.jpg','2020-05-22 01:58:10','2020-05-22 01:58:10'),(6,'Amadou Sara Diallo','Treasurer','veznedar','Trésorier','[email protected]','https://www.facebook.com/amadoutchakodiallo',NULL,NULL,'1590123556.jpg','2020-05-22 01:59:16','2020-05-22 01:59:16'),(7,'Elhadj Alhassane Diallo','Syndicate','Sendika','Syndicat','[email protected]',NULL,NULL,NULL,'1590123720.jpeg','2020-05-22 02:02:00','2020-05-22 02:02:00'),(8,'Mariama Dalanda Diallo','Organisation','organizasyon','Organisation','[email protected]',NULL,NULL,NULL,'1590123814.jpg','2020-05-22 02:03:34','2020-05-22 02:03:34'),(9,'Laye Mamadi Cissé','General Secretariat','Genel Sekreterlik','Secrétariat Général','[email protected]',NULL,NULL,NULL,'1590123866.jpg','2020-05-22 02:04:26','2020-05-22 02:04:26'),(10,'Abdoulaye Cherif Haidara','Organization','organizasyon','Organisation','[email protected]','https://www.facebook.com/profile.php?id=100004721864617&ref=br_rs',NULL,NULL,'1590124043.jpg','2020-05-22 02:07:23','2020-05-22 02:07:23'),(11,'Francis Doré','Organization','organizasyon','Organisation','[email protected]','https://www.facebook.com/francis.dore.71',NULL,NULL,'1590124110.jpg','2020-05-22 02:08:30','2020-05-22 02:08:30'),(12,'Ouessou Diaby','Communication','İletişim','Communication','[email protected]','https://www.facebook.com/ouessou.diaby.3',NULL,NULL,'1590124208.jpg','2020-05-22 02:10:08','2020-05-22 02:10:08'),(13,'Mohamed Lamine Cherif','Communication','İletişim','Communication','[email protected]','https://www.facebook.com/profile.php?id=100004000170275&ref=br_rs',NULL,NULL,'1590124274.jpg','2020-05-22 02:11:14','2020-05-22 02:11:14'),(14,'Alimou Diallo','Scientific Unit (IT)','Bilimsel Birim (BT)','Cellule Scientifique (Informatique)','[email protected]','https://www.facebook.com/alimou.diallo.526',NULL,NULL,'1590124416.jpg','2020-05-22 02:13:36','2020-05-22 02:13:36'),(15,'Mamadi Sanoh','Scientific Unit (Research)','Bilimsel Birim (Araştırma)','Cellule Scientifique (Recherche)','[email protected]','https://www.facebook.com/mamadimbalou',NULL,NULL,'1590124527.jpg','2020-05-22 02:15:27','2020-05-22 02:15:27');
/*!40000 ALTER TABLE `boardmembers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `departments`
--
DROP TABLE IF EXISTS `departments`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `departments` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`frname` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`trname` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`enname` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `departments`
--
LOCK TABLES `departments` WRITE;
/*!40000 ALTER TABLE `departments` DISABLE KEYS */;
INSERT INTO `departments` VALUES (1,'Ingenierie Informatique','Bilgisayar Mühendisliği','Computer Engineering','BM','2020-04-06 14:01:48','2020-04-06 14:01:48'),(2,'sciences politiques et administration publique','siyaset bilimi ve kamu yönetimi','political science and public administration','socio','2020-04-29 15:32:42','2020-05-12 10:44:31'),(3,'Géologie','Jeoloji Mühendisliği Anabilim dalı','Geological Engineering','geologie','2020-05-12 11:20:50','2020-05-12 11:20:50');
/*!40000 ALTER TABLE `departments` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `departments_faculties`
--
DROP TABLE IF EXISTS `departments_faculties`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `departments_faculties` (
`departments_id` int(10) unsigned NOT NULL,
`faculties_id` int(10) unsigned NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
KEY `departments_faculties_departments_id_index` (`departments_id`),
KEY `departments_faculties_faculties_id_index` (`faculties_id`),
CONSTRAINT `departments_faculties_departments_id_foreign` FOREIGN KEY (`departments_id`) REFERENCES `departments` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `departments_faculties`
--
LOCK TABLES `departments_faculties` WRITE;
/*!40000 ALTER TABLE `departments_faculties` DISABLE KEYS */;
INSERT INTO `departments_faculties` VALUES (1,1,NULL,NULL),(2,5,NULL,NULL),(3,1,NULL,NULL);
/*!40000 ALTER TABLE `departments_faculties` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `faculties`
--
DROP TABLE IF EXISTS `faculties`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `faculties` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`frname` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`trname` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`enname` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `faculties`
--
LOCK TABLES `faculties` WRITE;
/*!40000 ALTER TABLE `faculties` DISABLE KEYS */;
INSERT INTO `faculties` VALUES (1,'Faculté d\'ingénierie','Mühendislik fakültesi','Engineering faculty','MF','2020-04-06 13:59:07','2020-04-06 14:01:14'),(5,'Faculté de sciences politiques','siyaset bilimi fakültesi','Faculty of political science','ss','2020-04-29 15:31:19','2020-06-01 10:38:28');
/*!40000 ALTER TABLE `faculties` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `histories`
--
DROP TABLE IF EXISTS `histories`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `histories` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`entitle` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`trtitle` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`frtitle` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`entext` text COLLATE utf8mb4_unicode_ci NOT NULL,
`trtext` text COLLATE utf8mb4_unicode_ci NOT NULL,
`frtext` text COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `histories`
--
LOCK TABLES `histories` WRITE;
/*!40000 ALTER TABLE `histories` DISABLE KEYS */;
INSERT INTO `histories` VALUES (1,'Our Hıstory','Tariğimiz','Notre Hıstoıre','<p><span style=\"font-family:Times New Roman,Times,serif\">Association of Guinean Students in Turkey under the acronym "ASSEGTUR" was created in 2010 by Guinean students living in Turkey for the first time. First, it was founded by 11 Guinean students in the first place, at the moment there were not enough Guinean students in Turkey. Because the 4 first arrivals have welcomed the other 7 new people, causing a feeling of solidarity and fraternity between them. This feeling of being Guinean in the same country, like other associations, allowed the creation of an association of Guinean scholars in Turkey. Suddenly, the magnitude spending this spirit focused on scholarship recipients only, since the number becomes important on all sides, which will give birth to the ASSEGTUR (Association of Guinean Students in Turkey. So, the headquarters of the ASSEGTUR is established in the city where the president resides. It can be transferred to another address by decision of the General Assembly if this transfer proves necessary. The headquarters of ASSEGTUR is established in the city where the president resides. may be transferred to another address upon decision of the General Assembly if this transfer proves necessary.</span></p>','<p><span style=\"font-family:Times New Roman,Times,serif\">"ASSEGTUR" kısaltması altında Türkiye'de Gineliler Öğrenci Derneği 2010 yılında Türkiye'de yaşayan Gine öğrencileri tarafından ilk kez kuruldu. Birincisi, ilk olarak 11 Gine öğrencisi tarafından kuruldu, şu anda Türkiye'de yeterli Gine öğrencisi yoktu. Çünkü ilk 4 gelen diğer 7 yeni insanı karşıladı ve aralarında bir dayanışma ve kardeşlik hissi yarattı. Aynı ülkede, bu dernek olma duygusu, diğer dernekler gibi, Türkiye'de bir Gine akademisyeni derneği kurulmasını sağlamıştır. Aniden, bu ruhu harcayan büyüklük sadece burs alanlara odaklandı, çünkü sayı her tarafta önemli hale geliyor ve bu da ASSEGTUR'u (Türkiye Gine Öğrenci Derneği) doğuracak. Başkanın ikamet ettiği şehirde kurulmuş olup, bu devir gerekliyse Genel Kurul kararı ile başka bir adrese devredilebilir.GEGEGUR'un genel merkezi başkanın ikamet ettiği şehirde kurulur. bu devir gerekliyse Genel Kurul kararı ile başka bir adrese devredilebilir.</span></p>','<p><span style=\"font-family:Times New Roman,Times,serif\"><span style=\"font-size:medium\">Association Des Etudiants Guineens En Turquie sous l’acronyme ‘’ASSEGTUR’’ a été créée en 2010 par les étudiants guinéens vivants en Turquie pour la premiere fois. D’abord, elle a été fondée par 11 étudiants guinéens en prémier lieu,en ce moment il n’y avait pas assez d’étudiant guinéen en Turquie. Du fait que les 4 prémiers arrivants ont accuielli les 7 autres nouvellles personnes occasionant un sentiment de solidarité et de fraternité entre eux. Ce sentiment d’etre guinéen dans le meme pays a l’image des autres associations, a permit la création d’une association des boursiers guinéens en Turquie. Du coup, l’ampleur dépensant cet esprit concentré sur les boursiers uniquement, vu que le nombre devient important a tout bord, qui donnera naissance a l’ASSEGTUR(Association des étudiants guinéens en Turquie.Donc,le siège social de l’ASSEGTUR est établi dans la ville où réside le président. Il peut être transféré à une autre adresse sur décision de l’Assemblée Générale si ce transfert s’avère nécessaire. Le siège social de l’ASSEGTUR est établi dans la ville où réside le président. Il peut être transféré à une autre adresse sur décision de l’Assemblée Générale si ce transfert s’avère nécessaire.</span></span></p>','2020-04-06 13:51:50','2020-04-06 13:51:50');
/*!40000 ALTER TABLE `histories` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `migrations`
--
DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `migrations` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`batch` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `migrations`
--
LOCK TABLES `migrations` WRITE;
/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_resets_table',1),(3,'2017_12_22_071606_create_mitions_table',1),(4,'2017_12_22_071606_create_plan_table',1),(5,'2017_12_22_071625_create_vitions_table',1),(6,'2017_12_22_091139_create_news_table',1),(7,'2018_02_03_131433_create_aboutus_table',1),(8,'2018_02_03_131433_create_activities_and_gallery_table',1),(9,'2018_02_03_131433_create_departments_table',1),(10,'2018_02_03_131433_create_faculties_table',1),(11,'2018_02_13_143401_create_activities_table',1),(12,'2018_02_23_141539_create_registrations_table',1),(13,'2018_03_02_090502_create_settings_table',1),(14,'2018_03_03_181426_create_histories_table',1),(15,'2018_03_03_204511_create_boardmembers_table',1),(16,'2018_03_04_073203_create_articles_table',1),(17,'2018_03_19_165137_create_slider1_table',1),(18,'2018_03_19_165137_create_sliderimages_table',1),(19,'2018_05_03_131433_create_departments_faculties_table',1),(20,'2018_06_03_131433_create_articles_departments_table',1);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `mitions`
--
DROP TABLE IF EXISTS `mitions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mitions` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`entitle` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`trtitle` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`frtitle` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`entext` text COLLATE utf8mb4_unicode_ci NOT NULL,
`trtext` text COLLATE utf8mb4_unicode_ci NOT NULL,
`frtext` text COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mitions`
--
LOCK TABLES `mitions` WRITE;
/*!40000 ALTER TABLE `mitions` DISABLE KEYS */;
INSERT INTO `mitions` VALUES (1,'Our Mıssıon','Misyonumuz','Notre Mıssıon','<p>❖ To strengthen the bonds of solidarity, friendship and mutual aid between its members.</p>\r\n\r\n<p>❖ To facilitate and coordinate relations on the one hand between its members, and on the other hand, between its members and the Guinean authorities.</p>\r\n\r\n<p>❖ Ensure good integration of Guinean students.</p>\r\n\r\n<p>❖ To defend, by legal and democratic means, the moral and material interests of all of its members.</p>\r\n\r\n<p>❖ To maintain relationships with other entities and associations working for the same purpose.</p>','<p>❖<span style=\"font-family:Times New Roman,Times,serif\">Üyeleri arasındaki dayanışma, dostluk ve karşılıklı yardım bağlarını güçlendirmek.</span></p>\r\n\r\n<p>❖<span style=\"font-family:Times New Roman,Times,serif\">Bir yandan üyeleri arasında, diğer yandan üyeleri ile Gine makamları arasındaki ilişkileri kolaylaştırmak ve koordine etmek.</span></p>\r\n\r\n<p>❖<span style=\"font-family:Times New Roman,Times,serif\">Gine öğrencilerinin iyi entegrasyonunu sağlamak.</span></p>\r\n\r\n<p>❖<span style=\"font-family:Times New Roman,Times,serif\">Yasal ve demokratik olarak savunmak, tüm üyelerinin ahlaki ve maddi çıkarlarını ifade eder.</span></p>\r\n\r\n<p>❖<span style=\"font-family:Times New Roman,Times,serif\">Aynı amaçla çalışan diğer kurum ve derneklerle ilişkileri sürdürmek.</span></p>','<p> <span style=\"font-family:Times New Roman,Times,serif\">❖ </span>De renforcer les liens de solidarité, d’amitié et d’entraide entre ses membres. </p>\r\n\r\n<p>❖ De faciliter et de coordonner les relations d’une part entre ses membres, d’autre part, entre ses membres et les autorités guinéennes. </p>\r\n\r\n<p>❖ D’assurer une bonne intégration des étudiants guinéens.</p>\r\n\r\n<p>❖ De défendre par des moyens légaux et démocratiques les intérêts moraux et matériels de l’ensemble de ses membres. </p>\r\n\r\n<p>❖ D’entretenir des relations avec d’autres entités et associations œuvrant dans le même but.</p>','2020-04-06 13:53:23','2020-04-06 13:53:23');
/*!40000 ALTER TABLE `mitions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `news`
--
DROP TABLE IF EXISTS `news`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `news` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`entitle` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`trtitle` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`frtitle` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`enbody` text COLLATE utf8mb4_unicode_ci NOT NULL,
`trbody` text COLLATE utf8mb4_unicode_ci NOT NULL,
`frbody` text COLLATE utf8mb4_unicode_ci NOT NULL,
`image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `news`
--
LOCK TABLES `news` WRITE;
/*!40000 ALTER TABLE `news` DISABLE KEYS */;
INSERT INTO `news` VALUES (9,'Solidarity Chain','Destek Kampanyası','Chaine De Solidarité','solidarite','<p>The solidarity chain set up by ASSEGTUR in order to come to the aid of our Guinean brothers who are currently in difficult situations linked to the CORONAVİRUS pandemic. At this time of confinement, we must together set up this mechanism of rapid assistance to these eager people. This is why, under the initiative of the president and his executive office, have drawn up a plan to get to the bottom of the effects of this dirty disease.</p>','<p>CORONAVİRUS pandemisine bağlı zor durumda olan Gine kardeşlerimizin yardımına gelmek için ASSEGTUR tarafından kurulan dayanışma zinciri. Bu hapsetme zamanında, bu istekli insanlara bu hızlı yardım mekanizmasını birlikte kurmalıyız. Bu nedenle, başkan ve yürütme ofisinin inisiyatifiyle, bu kirli hastalığın etkilerinin altına inmek için bir plan hazırladı.</p>','<p>La chaine de solidarité mise en place par l'ASSEGTUR afin de venir au secours de nos frères guinéens qui sont actuellement dans des situations difficiles liées à la pandémie CORONAVİRUS. En ce moment de confinement, nous devons ensemble mettre en place ce méchanisme d'aide rapide à ces personnes désireuses. C'est pourquoi sous l'initiative du preésident et son bureau éxécutif ont élaboré un plan permettant de toucher jusqu'au bout aux effets de cette sale maladie.</p>','1589286832.jpeg','2020-05-12 09:33:52','2020-05-12 09:33:52'),(10,'Awareness against CORONAVIRUS','CORONAVİRUS\'a karşı farkındalık','Sensibilisation contre le CORONAVIRUS','covid-aw','<p>The fight against the coronavirus continues in the world and it is a disease which must really be taken seriously. ASSEGTUR encourages all its members to take all the necessary precautions in order to protect themselves and our loved ones.</p>\r\n\r\n<p>Here are some guidelines to follow to prevent the spread of this deadly virus as much as possible:</p>\r\n\r\n<p>1- Wash your hands regularly: Before putting on a mask, wash your hands with a hydroalcoholic solution.</p>\r\n\r\n<p>2- Cover the nose and mouth: Apply the mask so as to cover the nose and mouth and please adjust it as well as possible on your face</p>\r\n\r\n<p>3- Do not touch the mask: When wearing a mask, avoid touching it without good reason.</p>\r\n\r\n<p>4- Do not reuse: When it gets wet, replace it with a new mask and do not reuse single-use masks.</p>\r\n\r\n<p>5- Throw the mask in a trash can.</p>','<p>Koronavirüs ile mücadele dünyada devam ediyor ve gerçekten ciddiye alınması gereken bir hastalık. ASSEGTUR tüm üyelerini kendilerini ve sevdiklerimizi korumak için gerekli tüm tedbirleri almaya teşvik eder.</p>\r\n\r\n<p>Bu ölümcül virüsün mümkün olduğunca yayılmasını önlemek için izlenmesi gereken bazı yönergeler:</p>\r\n\r\n<p>1- Ellerinizi düzenli olarak yıkayın: Bir maske takmadan önce ellerinizi hidroalkolik bir solüsyonla yıkayın.</p>\r\n\r\n<p>2- Burun ve ağzı örtün: Maskeyi burun ve ağzı kaplayacak şekilde uygulayın ve lütfen yüzünüzde mümkün olduğunca ayarlayın.</p>\r\n\r\n<p>3- Maskeye dokunmayın: Maske takarken, iyi bir sebep olmadan dokunmaktan kaçının.</p>\r\n\r\n<p>4- Tekrar kullanmayın: Islandığında, yeni bir maske ile değiştirin ve tek kullanımlık maskeleri tekrar kullanmayın.</p>\r\n\r\n<p>5- Maskeyi bir çöp kutusuna atın.</p>','<p>La lutte contre le coronavirus continue dans le monde et c'est une maladie qu'il faut réellement prendre au sérieux, l'ASSEGTUR encourage tous ses membres à prendre toutes les précautions nécessaires afin de se protéger et de protéger nos proches.</p>\r\n\r\n<p>Voici quelques consignes à respecter pour évùter au maximum la propagation de ce virus mortel:</p>\r\n\r\n<p>1- Se laver les mains régulièrement: Avant de mettre un masque se laver les mains avec une solution hydroalcoolique.</p>\r\n\r\n<p>2- Recouvrir le nez et la bouche: Appliquer le masque de façon a recouvrir le nez et la bouche et veuillez à l'ajuster au mieux sur votre visage</p>\r\n\r\n<p>3- Ne pas toucher le masque: Lorsque l'on porte un masque, éviter de le toucher sans raison valable.</p>\r\n\r\n<p>4- Ne pas réutiliser: Lorsqu'il s'humidifie, le remplacer par un nouveau masque et ne pas réutliser des masques à usage unique.</p>\r\n\r\n<p>5- Jeter le masque dans une poubelle.</p>','1589290014.jpeg','2020-05-12 10:26:55','2020-05-12 10:26:55'),(11,'Transport fee refund by YTB','YTB tarafından ödemeler','Remboursement des transports par YTB','ytb-refund','<p>Good morning all,<br />\r\nWe would like to inform you that the transaction for the payment of round trip transportation during the forum has been successfully carried out for everyone without exception. We thank each of you for the patience and the confidence especially placed in us the members of the executive office. This delay was linked to anomalies in registrations by certain members on the one hand and on the other hand the slowness of the procedure. But the most important thing is the payment at the end. Then, I take advantage on behalf of the executive office to ask your forgiveness directly or indirectly for the words of the misplaced words. And I again renew my ambition to serve you for the satisfaction of all. Thank you so much that God helps us to realize our dreams and above all take care of yourself.<br />\r\nPresident Ibrahima Chérif</p>','<p>Herkese merhaba,<br />\r\nForum sırasında gidiş-dönüş ulaşım ücretinin istisnasız herkes için başarıyla gerçekleştirildiğini size bildirmek isteriz. İcra dairesi üyelerinin özellikle bize gösterdiği sabır ve güven için her birinize teşekkür ederiz. Bu gecikme, bir yandan bazı üyelerin kayıtlarında anormalliklerle, diğer yandan da prosedürün yavaşlığı ile bağlantılıdır. Ancak en önemli şey, sondaki ödeme. Daha sonra affedilmenizi yanlış yere yerleştirilmiş kelimelerin sözlerini doğrudan veya dolaylı olarak sormak için yürütme ofisi adına yararlanırım. Ve yine herkesin memnuniyeti için size hizmet etme tutkumu yenileyiyorum. Çok teşekkür ederim, Tanrı rüyalarımızı gerçekleştirmemize yardım eder ve her şeyden önce kendinize iyi bakar.<br />\r\nBaşkan Ibrahima Chérif</p>','<p>Bonjour à tous,<br />\r\nNous tenons à vous informer que l'opération du paiement des transports aller et retour lors du forum, a été effectuée avec succès pour tout le monde sans exception. Nous remercions chacun de vous pour la patience et la confiance surtout placées en nous les membres du bureau exécutif. Ce retard était lié à des anomalies d'enregistrements par certains membres d'une part et d'autre part la lenteur de la procédure. Mais le plus important c'est le paiement à la fin. Ensuite, je profite au nom du bureau exécutif pour vous demander pardon directement ou indirectement aux tires des mots mal placés. Et je renouvelle encore mon ambition de vous servir pour la satisfaction de tous. Merci beaucoup que Dieu nous aide à réaliser nos rêves et surtout prenez soin de vous.<br />\r\nPrésident Ibrahima Chérif</p>','1589290198.jpeg','2020-05-12 10:29:58','2020-05-12 10:29:58');
/*!40000 ALTER TABLE `news` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `password_resets`
--
DROP TABLE IF EXISTS `password_resets`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `password_resets` (
`email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `password_resets`
--
LOCK TABLES `password_resets` WRITE;
/*!40000 ALTER TABLE `password_resets` DISABLE KEYS */;
INSERT INTO `password_resets` VALUES ('[email protected]','$2y$10$Iq5u8tROYrS7bWq3K53K7eLBsNkHckapVcG.htodExukPt03tKyQu','2020-05-14 23:01:50');
/*!40000 ALTER TABLE `password_resets` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `plan`
--
DROP TABLE IF EXISTS `plan`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `plan` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`entitle` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`trtitle` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`frtitle` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`entext` text COLLATE utf8mb4_unicode_ci NOT NULL,
`trtext` text COLLATE utf8mb4_unicode_ci NOT NULL,
`frtext` text COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `plan`
--
LOCK TABLES `plan` WRITE;
/*!40000 ALTER TABLE `plan` DISABLE KEYS */;
INSERT INTO `plan` VALUES (1,'Our Plan','Planımız','Notre Plan','<p style=\"text-align:center\"><span style=\"font-family:Times New Roman,Times,serif\">Science being the very essence of our student association, we have a platform for exchanging our study projects, theses and articles, many who stand out through the qualities of their projects.</span></p>\r\n\r\n<ul>\r\n <li style=\"text-align:center\"><strong><span style=\"font-family:Times New Roman,Times,serif\">Culture and Sport:</span></strong></li>\r\n</ul>\r\n\r\n<p style=\"text-align:center\"><span style=\"font-family:Times New Roman,Times,serif\">Sport being a factor of union and celebration, Assegtur through its scientific and sporting cultural cell organizes reunion matches to conclude its general assemblies in joy.</span></p>\r\n\r\n<p style=\"text-align:center\"><span style=\"font-family:Times New Roman,Times,serif\">At each meeting, we organize cultural activities to experience the warmth of the fold.</span></p>\r\n\r\n<p style=\"text-align:center\"><br />\r\n<span style=\"font-family:Times New Roman,Times,serif\">To represent Guinean culture in international events such as: International Students Gathering. Also, we are interested in the motivation of our Guinean students participating in cultural events or cultural exhibitions.</span></p>\r\n\r\n<ul>\r\n <li style=\"text-align:center\"><strong><span style=\"font-family:Times New Roman,Times,serif\">Training:</span></strong></li>\r\n</ul>\r\n\r\n<p style=\"text-align:center\"><span style=\"font-family:Times New Roman,Times,serif\">At ASSSEGTUR, the quest for knowledge is at the center of our priorities, which is why we plan to organize conferences by inviting enlightened personalities in various fields in order to share their knowledge with us.</span></p>\r\n\r\n<ul>\r\n <li style=\"text-align:center\"><strong><span style=\"font-family:Times New Roman,Times,serif\">Home</span></strong></li>\r\n</ul>\r\n\r\n<p style=\"text-align:center\"><span style=\"font-family:Times New Roman,Times,serif\">Each year, we are used to helping new students and guiding them from their applications for Turkish scholarships, preparing them for the service until receiving them here in Turkey and finishing their university registrations.</span></p>\r\n\r\n<ul>\r\n <li style=\"text-align:center\"><strong><span style=\"font-family:Times New Roman,Times,serif\">Picnic</span></strong></li>\r\n</ul>\r\n\r\n<p style=\"text-align:center\"><span style=\"font-family:Times New Roman,Times,serif\">Each of our first activity is holiday or picnic colors, an opportunity to meet and introduce newcomers to others in order to create an energy of friendship between the members.</span></p>\r\n\r\n<ul>\r\n <li style=\"text-align:center\"><strong><span style=\"font-family:Times New Roman,Times,serif\">Independence day:</span></strong></li>\r\n</ul>\r\n\r\n<p style=\"text-align:center\"> </p>\r\n\r\n<ul>\r\n <li style=\"text-align:center\"><strong><span style=\"font-family:Times New Roman,Times,serif\">General Assembly:</span></strong></li>\r\n</ul>\r\n\r\n<p style=\"text-align:center\"><span style=\"font-family:Times New Roman,Times,serif\">Guinean students living in Turkey meet each other to have a good time of sharing and enthusiasm. This meeting aims to strengthen the bonds of friendship and solidarity between Guinean students living in Turkey, hence the name General Assembly is still an important moment for ASSEGTUR to come together in a massive way for elections, training, cultural and sporting events, making major decisions for the future of our association.</span></p>','<p style=\"text-align:center\"><span style=\"font-family:Times New Roman,Times,serif\">Öğrenci derneğimizin özü olan bilim, çalışma projelerimizi, tezlerimizi ve makalelerimizi paylaşmak için bir platformumuz var, birçoğu projelerinin nitelikleri ile öne çıkıyor.</span></p>\r\n\r\n<ul>\r\n <li style=\"text-align:center\"><strong><span style=\"font-family:Times New Roman,Times,serif\">Kültür ve Spor:</span></strong></li>\r\n</ul>\r\n\r\n<p style=\"text-align:center\"><span style=\"font-family:Times New Roman,Times,serif\">Birlik ve kutlama faktörü olan spor, bilimsel ve sportif kültürel hücresi aracılığıyla genel toplantılarını neşeyle sonuçlandırmak için yeniden birleşme maçları düzenliyor.</span></p>\r\n\r\n<p style=\"text-align:center\"><span style=\"font-family:Times New Roman,Times,serif\">Her toplantıda kat sıcaklığını yaşamak için kültürel etkinlikler düzenliyoruz.</span></p>\r\n\r\n<p style=\"text-align:center\"><br />\r\n<span style=\"font-family:Times New Roman,Times,serif\">Gine kültürünü aşağıdaki gibi uluslararası etkinliklerde temsil etmek: Uluslararası Öğrenci Buluşması. Ayrıca, kültürel etkinliklere veya kültürel sergilere katılan Gine öğrencilerimizin motivasyonu ile ilgileniyoruz.</span></p>\r\n\r\n<ul>\r\n <li style=\"text-align:center\"><strong><span style=\"font-family:Times New Roman,Times,serif\">Eğitim:</span></strong></li>\r\n</ul>\r\n\r\n<p style=\"text-align:center\"><span style=\"font-family:Times New Roman,Times,serif\">ASSSEGTUR'da bilgi arayışı önceliklerimizin merkezindedir, bu yüzden bilgisini bizimle paylaşmak için çeşitli alanlarda aydınlanmış kişilikleri davet ederek konferanslar düzenlemeyi planlıyoruz.</span></p>\r\n\r\n<ul>\r\n <li style=\"text-align:center\"><strong><span style=\"font-family:Times New Roman,Times,serif\">Ev</span></strong></li>\r\n</ul>\r\n\r\n<p style=\"text-align:center\"><span style=\"font-family:Times New Roman,Times,serif\">Her yıl yeni öğrencilere yardım etmeye ve Türk bursu için başvurularından rehberlik etmeye, onları Türkiye'de bulana kadar hizmete hazırlamaya ve üniversite kayıtlarını bitirmeye alışkınız.</span></p>\r\n\r\n<ul>\r\n <li style=\"text-align:center\"><strong><span style=\"font-family:Times New Roman,Times,serif\">Piknik</span></strong></li>\r\n</ul>\r\n\r\n<p style=\"text-align:center\"><span style=\"font-family:Times New Roman,Times,serif\">İlk faaliyetlerimizin her biri tatil veya piknik renkleri, üyeler arasında bir dostluk enerjisi yaratmak için yeni gelenlerle tanışma ve tanışma fırsatı.</span></p>\r\n\r\n<ul>\r\n <li style=\"text-align:center\"><strong><span style=\"font-family:Times New Roman,Times,serif\">Bağımsızlık Günü:</span></strong></li>\r\n</ul>\r\n\r\n<p style=\"text-align:center\"> </p>\r\n\r\n<ul>\r\n <li style=\"text-align:center\"><strong><span style=\"font-family:Times New Roman,Times,serif\">Genel Kurul:</span></strong></li>\r\n</ul>\r\n\r\n<p style=\"text-align:center\"><span style=\"font-family:Times New Roman,Times,serif\">Türkiye'de yaşayan Gine öğrencileri, iyi bir paylaşım ve coşku zamanına sahip olmak için birbirleriyle buluşuyor.Bu toplantı, Türkiye'de yaşayan Gine öğrencileri arasındaki dostluk ve dayanışma bağlarını ve dolayısıyla Genel Kurul adını güçlendirmeyi amaçlıyor. ASSEGTUR'un seçimler, eğitim, kültürel ve sportif etkinlikler için muazzam bir şekilde bir araya gelmesi ve derneğimizin geleceği için önemli kararlar alması için önemli bir andır.</span></p>','<p style=\"text-align: center;\">La science etant l'essence même de notre association estudiantine, nous avons une plateforme d’échange de nos projets d’études, des theses et des articles, nombreux sont ceux qui se distinguent à travers les qualités de leurs projets.</p>\r\n\r\n<ul>\r\n <li style=\"text-align: center;\"><strong>Culture et Sport:</strong></li>\r\n</ul>\r\n\r\n<p style=\"text-align: center;\">Le Sport etant un facteur d'union et de célébration, Assegtur à travers sa cellule culturelle scientifique et sportive organise des matchs de retrouvailles pour conclure ses assemblées générales dans la joie.</p>\r\n\r\n<p style=\"text-align: center;\">A chaque assemblée, nous organisons des activités culturelles pour vivre la chaleur du bercail.</p>\r\n\r\n<p style=\"text-align: center;\"><br />\r\n </p>\r\n\r\n<p style=\"text-align: center;\">Pour représenter la culture guinéenne dans les événements internationaux comme : International Students Gathering. Aussi, nous sommes intéressés à la motivation de nos étudiants guinéens participant a des événements culturels ou expositions culturelle.</p>\r\n\r\n<ul>\r\n <li>\r\n <p style=\"text-align: center;\"><strong>Formation:</strong></p>\r\n </li>\r\n</ul>\r\n\r\n<p style=\"text-align: center;\">A l'ASSEGTUR, la quête du savoir est au centre de nos priorités, c'est pourquoi nous envisageons organiser des conférences en invitant des personnalités éclairées dans divers domaines afin de partager leurs connaissances avec nous.</p>\r\n\r\n<ul>\r\n <li>\r\n <p style=\"text-align: center;\"><strong>Accueil</strong></p>\r\n </li>\r\n</ul>\r\n\r\n<p style=\"text-align: center;\">Chaque année, nous sommes habitués à aider les nouveaux étudiants et les guider depuis leurs applications pour les bourses d'études turques , de les préparer à l'entervue jusqu'à les recevoir ici en Turquie et en finissant leurs inscriptions à l'université.</p>\r\n\r\n<ul>\r\n <li>\r\n <p style=\"text-align: center;\"><strong>Pique-Nique</strong></p>\r\n </li>\r\n</ul>\r\n\r\n<p style=\"text-align: center;\">Chaque notre premiere activité c’est les couleurs vacances ou pique-nique,une occassion de se retrouver et presenter les nouveaux venus autres afın de creer une energie d’amitié entre les membres.</p>\r\n\r\n<ul>\r\n <li style=\"text-align: center;\"><strong>Fete d’independance:</strong></li>\r\n</ul>\r\n\r\n<p style=\"text-align: center;\"> </p>\r\n\r\n<ul>\r\n <li>\r\n <p style=\"text-align: center;\"><strong>Assemblee Generale:</strong></p>\r\n </li>\r\n</ul>\r\n\r\n<p style=\"text-align: center;\">Les étudiants guinéens résidant en Turquie se retrouvent chaque pour passer des bons moments de partage et d'enthousiasme.Cette rencontre a pour but la renforcement des liens d'amitié et de solidarité entre les étudiant guinéens vivant en Turquie d’ou le nom Assemblée génerale est un moment important encore pour l’ASSEGTUR de se retrouver ensemble de façon masive pour les elections, les formations, évenements culturels et sportifs,la prise des grandes decisions pour l’avenir de notre association.</p>','2020-04-06 13:54:09','2020-04-06 13:54:09');
/*!40000 ALTER TABLE `plan` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `registrations`
--
DROP TABLE IF EXISTS `registrations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `registrations` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`firstname` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`gender` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`level` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`institution` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`department` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`city` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `registrations`
--
LOCK TABLES `registrations` WRITE;
/*!40000 ALTER TABLE `registrations` DISABLE KEYS */;
INSERT INTO `registrations` VALUES (13,'İbrahima Sory camara','Kız','Konya selçuklu Bosna-Hersek osmanlı stüdyo','Lise','Konya teknik üniversitesi','Bilgisayar mühendisliği','200','[email protected]','0','2020-04-12 17:50:54','2020-04-12 17:50:54',''),(15,'cherif','Erkek','konya','Yüksek Lisans','selçuk','sociologie','656','[email protected]','0','2020-05-12 10:27:53','2020-05-12 10:27:53','');
/*!40000 ALTER TABLE `registrations` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `settings`
--
DROP TABLE IF EXISTS `settings`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `settings` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`description` text COLLATE utf8mb4_unicode_ci,
`keywords` text COLLATE utf8mb4_unicode_ci,
`facebook` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`instagram` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`twitter` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`youtube` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`googleplus` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`phoneone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`phonetwo` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`emailone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`emailtwo` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`address` text COLLATE utf8mb4_unicode_ci,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `settings`
--
LOCK TABLES `settings` WRITE;
/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
INSERT INTO `settings` VALUES (1,'Türkiye\'deki Gineli Öğrenciler Birliği resmi sitesi','Assegtur, Turkey, guineans in Turkey, Türkiye\'deki Gineli Öğrenciler Birliği, gineliler, afros, Türkiye Gine birliği, gineli dernekleri, guineans in turkey, africans in Turkey, beautiful Guinea, association des guineens, student association, students associoation in turkey, assegtur website, best students association, study in turkey, afrıkalılar,gineliler','https://www.facebook.com/groups/124016280989833/',NULL,NULL,NULL,NULL,'+90 553 169 4187',NULL,'[email protected]',NULL,'Turquie',NULL,NULL);
/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `slider1`
--
DROP TABLE IF EXISTS `slider1`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `slider1` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`entitle` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`trtitle` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`frtitle` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `slider1`
--
LOCK TABLES `slider1` WRITE;
/*!40000 ALTER TABLE `slider1` DISABLE KEYS */;
INSERT INTO `slider1` VALUES (0,'Association of Guinean Students in Turkey','Türkiye\'deki Gineliler Öğrenci birliği','Association Des Etudiants Guineens En Turquie','WhatsApp Image 2020-05-27 at 18.51.44.jpeg','2020-03-30 21:00:00','2020-05-27 12:53:09');
/*!40000 ALTER TABLE `slider1` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sliderimages`
--
DROP TABLE IF EXISTS `sliderimages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sliderimages` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`entitle` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`trtitle` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`frtitle` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sliderimages`
--
LOCK TABLES `sliderimages` WRITE;
/*!40000 ALTER TABLE `sliderimages` DISABLE KEYS */;
INSERT INTO `sliderimages` VALUES (30,'Businessmen At The Forum','Forumda İş Adamları','Hommes D\'affaires Lors Du Forum','WhatsApp Image 2020-05-06 at 00.24.09.jpeg','2020-05-12 08:34:27','2020-05-12 08:34:27'),(31,'Guinean Students Forum','Gineliler Öğrenci Forumu','Forum De L\'étudiant Guinéen','WhatsApp Image 2020-05-06 at 00.23.56.jpeg','2020-05-12 08:37:32','2020-05-12 08:37:32'),(32,'The President, The Representative Of YTB and The Consul','Başkan, YTB Temsilcisi ve Konsolos','Le Président, Le Representant De YTB et Le Consul','WhatsApp Image 2020-05-06 at 00.24.04.jpeg','2020-05-12 08:40:07','2020-05-12 08:40:07'),(33,'Association of Guinean Students in Turkey','Türkiye\'deki Gineliler Öğrenci birliği','Association Des Etudiants Guineens En Turquie','Background.png','2020-05-27 12:55:15','2020-05-27 12:55:15');
/*!40000 ALTER TABLE `sliderimages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'unsignedInteger','[email protected]','$2y$10$TTNPMQSSc1kjNZE6gzcPeeq7XL/7iYIdh8NBY6bIkrd6KXtk5Cbk.','mc7gCPVceagw5RdLRucJXezIJ31BzDoKVFdqBKu77JBXa0MADKhnxaQUvuK7','2020-01-08 22:15:44','2020-01-08 22:15:44'),(2,'lol','[email protected]','$2y$10$gLVdZwVXvQhJvxlOX6HHy.zZpfv0GIpYQU8Hy6jPqfegx1zZul9h2',NULL,'2020-05-17 21:41:09','2020-05-17 21:41:09');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `vitions`
--
DROP TABLE IF EXISTS `vitions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vitions` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`entitle` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`trtitle` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`frtitle` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`entext` text COLLATE utf8mb4_unicode_ci NOT NULL,
`trtext` text COLLATE utf8mb4_unicode_ci NOT NULL,
`frtext` text COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `vitions`
--
LOCK TABLES `vitions` WRITE;
/*!40000 ALTER TABLE `vitions` DISABLE KEYS */;
INSERT INTO `vitions` VALUES (1,'Our Vısıon','Visyonumuz','Notre Vısıon','<p>Create an academic and cultural atmosphere conducive to the intellectual development of its members;</p>\r\n\r\n<p>The Association will be able to cover the whole of Turkey through antennas in all the cities where Guinean students are present.</p>\r\n\r\n<p>A massive and voluntary membership,</p>\r\n\r\n<p>To participate in meetings, in General Assemblies.</p>','<p><span style=\"font-family:Times New Roman,Times,serif\">Üyelerinin entelektüel gelişimlerine elverişli akademik ve kültürel bir atmosfer yaratmak;</span></p>\r\n\r\n<p><span style=\"font-family:Times New Roman,Times,serif\">Dernek, Gine öğrencilerinin bulunduğu tüm şehirlerdeki antenler aracılığıyla tüm Türkiye'yi kapsayabilecektir.</span></p>\r\n\r\n<p><span style=\"font-family:Times New Roman,Times,serif\">Büyük ve gönüllü üyelik,</span></p>\r\n\r\n<p><span style=\"font-family:Times New Roman,Times,serif\">Genel Kurul toplantılarına katılmak.</span></p>','<p><span style=\"font-family:Times New Roman,Times,serif\"><span style=\"font-size:medium\">Créer une atmosphère académique et culturelle propice à l’épanouissement intellectuel de </span></span><span style=\"font-family:Times New Roman,Times,serif\"><span style=\"font-size:medium\">ses</span></span><span style=\"font-family:Times New Roman,Times,serif\"><span style=\"font-size:medium\"> membres</span></span></p>\r\n\r\n<p><span style=\"font-family:Times New Roman,Times,serif\"><span style=\"font-size:medium\">L’Association pourra couvrir toute la Turquie à travers des antennes dans toutes les villes où se trouvent des étudiants guinéens.</span></span></p>\r\n\r\n<p><span style=\"font-family:Times New Roman,Times,serif\"><span style=\"font-size:medium\">Une adhesion massive et volontaire,</span></span></p>\r\n\r\n<p><span style=\"font-family:Times New Roman,Times,serif\"><span style=\"color:#000000\"><span style=\"font-size:medium\">De participer aux réunions, aux Assemblées Générales.</span></span></span></p>','2020-04-06 13:54:53','2020-04-06 13:54:53');
/*!40000 ALTER TABLE `vitions` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2020-06-01 18:18:02