· 4 years ago · Jan 31, 2021, 07:46 PM
1-- --------------------------------------------------------
2-- Host: 5.9.19.47
3-- Server version: 5.7.29 - MySQL Community Server (GPL)
4-- Server OS: Linux
5-- HeidiSQL Version: 10.3.0.5771
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14
15-- Dumping database structure for formsuob_newenuob_en
16CREATE DATABASE IF NOT EXISTS `formsuob_newenuob_en` /*!40100 DEFAULT CHARACTER SET latin1 */;
17USE `formsuob_newenuob_en`;
18
19-- Dumping structure for table formsuob_newenuob_en.academic_calendar
20CREATE TABLE IF NOT EXISTS `academic_calendar` (
21 `id` int(11) NOT NULL AUTO_INCREMENT,
22 `event` text NOT NULL,
23 `event_date` datetime NOT NULL,
24 PRIMARY KEY (`id`)
25) ENGINE=InnoDB DEFAULT CHARSET=utf8;
26
27-- Data exporting was unselected.
28
29-- Dumping structure for table formsuob_newenuob_en.academic_levels
30CREATE TABLE IF NOT EXISTS `academic_levels` (
31 `id` int(11) NOT NULL AUTO_INCREMENT,
32 `title` varchar(50) NOT NULL,
33 `title_ar` varchar(50) NOT NULL,
34 PRIMARY KEY (`id`)
35) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
36
37-- Data exporting was unselected.
38
39-- Dumping structure for table formsuob_newenuob_en.academic_programs
40CREATE TABLE IF NOT EXISTS `academic_programs` (
41 `id` int(11) NOT NULL AUTO_INCREMENT,
42 `title` varchar(255) NOT NULL,
43 `dept_id` int(11) NOT NULL,
44 `description` text NOT NULL,
45 `level_id` int(11) NOT NULL,
46 `title_ar` varchar(250) NOT NULL,
47 `description_ar` text NOT NULL,
48 PRIMARY KEY (`id`)
49) ENGINE=InnoDB DEFAULT CHARSET=utf8;
50
51-- Data exporting was unselected.
52
53-- Dumping structure for table formsuob_newenuob_en.admissions
54CREATE TABLE IF NOT EXISTS `admissions` (
55 `id` int(11) NOT NULL AUTO_INCREMENT,
56 `name` varchar(100) DEFAULT NULL,
57 `ename` tinyint(4) DEFAULT NULL,
58 `college_id` tinyint(4) DEFAULT NULL,
59 PRIMARY KEY (`id`)
60) ENGINE=MyISAM DEFAULT CHARSET=latin1;
61
62-- Data exporting was unselected.
63
64-- Dumping structure for table formsuob_newenuob_en.cafeterias
65CREATE TABLE IF NOT EXISTS `cafeterias` (
66 `id` int(11) NOT NULL AUTO_INCREMENT,
67 `name` varchar(200) NOT NULL,
68 `location` varchar(200) NOT NULL,
69 `food_types` text NOT NULL,
70 `college_id` int(11) NOT NULL,
71 `contact` text NOT NULL,
72 `ename` varchar(200) NOT NULL,
73 `location_ar` varchar(200) NOT NULL,
74 `food_types_ar` text NOT NULL,
75 `contact_ar` text NOT NULL,
76 PRIMARY KEY (`id`)
77) ENGINE=InnoDB DEFAULT CHARSET=utf8;
78
79-- Data exporting was unselected.
80
81-- Dumping structure for table formsuob_newenuob_en.categories
82CREATE TABLE IF NOT EXISTS `categories` (
83 `id` int(100) unsigned NOT NULL AUTO_INCREMENT,
84 `parent_id` int(10) unsigned DEFAULT NULL,
85 `order` int(11) NOT NULL DEFAULT '1',
86 `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
87 `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
88 `college_id` int(11) NOT NULL,
89 `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
90 `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
91 PRIMARY KEY (`id`),
92 UNIQUE KEY `categories_slug_unique` (`slug`),
93 KEY `categories_parent_id_foreign` (`parent_id`),
94 CONSTRAINT `categories_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
95) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
96
97-- Data exporting was unselected.
98
99-- Dumping structure for table formsuob_newenuob_en.certificates
100CREATE TABLE IF NOT EXISTS `certificates` (
101 `id` int(11) NOT NULL AUTO_INCREMENT,
102 `name` varchar(50) CHARACTER SET utf8 NOT NULL,
103 `ename` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
104 `abbrev` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
105 PRIMARY KEY (`id`)
106) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
107
108-- Data exporting was unselected.
109
110-- Dumping structure for table formsuob_newenuob_en.colleges
111CREATE TABLE IF NOT EXISTS `colleges` (
112 `id` int(11) NOT NULL AUTO_INCREMENT,
113 `name` varchar(100) DEFAULT NULL,
114 `ename` varchar(50) DEFAULT NULL,
115 `study_years` tinyint(4) DEFAULT NULL,
116 `center` tinyint(1) DEFAULT NULL,
117 `description` text,
118 `history` text,
119 `vision` text,
120 `mission` text,
121 `objectives` text,
122 `dean_message` text,
123 `address` varchar(200) DEFAULT NULL,
124 `phone` varchar(50) DEFAULT NULL,
125 `email` varchar(100) DEFAULT NULL,
126 `map` text,
127 `dean_name` text,
128 `parking_info` text,
129 `parking_map` varchar(100) DEFAULT NULL,
130 `emergency_phone` varchar(20) DEFAULT NULL,
131 `photo` varchar(50) DEFAULT NULL,
132 `logo` varchar(50) DEFAULT NULL,
133 `visiting_info` varchar(255) DEFAULT NULL,
134 `description_ar` text,
135 `history_ar` text,
136 `mission_ar` text,
137 `address_ar` text,
138 `dean_name_ar` text,
139 `dean_message_ar` text,
140 `objectives_ar` text,
141 `vision_ar` text,
142 `ar` text,
143 PRIMARY KEY (`id`)
144) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8;
145
146-- Data exporting was unselected.
147
148-- Dumping structure for table formsuob_newenuob_en.college_research
149CREATE TABLE IF NOT EXISTS `college_research` (
150 `id` int(11) NOT NULL AUTO_INCREMENT,
151 `college_id` int(11) NOT NULL,
152 `description` text NOT NULL,
153 `no_centers` int(11) NOT NULL,
154 `no_labs` int(11) NOT NULL,
155 `no_hindex_10` int(11) NOT NULL,
156 `no_scopus` int(11) NOT NULL,
157 `no_projects` int(11) NOT NULL,
158 `no_medals` int(11) NOT NULL,
159 `no_patents` int(11) NOT NULL,
160 `no_best_papers` int(11) NOT NULL,
161 `photo` varchar(50) NOT NULL,
162 PRIMARY KEY (`id`)
163) ENGINE=InnoDB DEFAULT CHARSET=utf8;
164
165-- Data exporting was unselected.
166
167-- Dumping structure for table formsuob_newenuob_en.contracts
168CREATE TABLE IF NOT EXISTS `contracts` (
169 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
170 `place` longtext COLLATE utf8mb4_unicode_ci,
171 `periods` enum('المرة الأولى','لايوجد','المرة الثانية') COLLATE utf8mb4_unicode_ci DEFAULT 'لايوجد',
172 `start_date` date DEFAULT NULL,
173 `taken_place` longtext COLLATE utf8mb4_unicode_ci,
174 `created_at` timestamp NULL DEFAULT NULL,
175 `updated_at` timestamp NULL DEFAULT NULL,
176 `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
177 `type` enum('1','3','2') COLLATE utf8mb4_unicode_ci DEFAULT '3',
178 `description` text COLLATE utf8mb4_unicode_ci,
179 PRIMARY KEY (`id`)
180) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
181
182-- Data exporting was unselected.
183
184-- Dumping structure for table formsuob_newenuob_en.courses
185CREATE TABLE IF NOT EXISTS `courses` (
186 `id` int(11) NOT NULL AUTO_INCREMENT,
187 `program_id` int(11) NOT NULL,
188 `course_name` varchar(255) NOT NULL,
189 `course_code` varchar(10) NOT NULL,
190 `course_level_id` int(11) NOT NULL,
191 `course_description` text NOT NULL,
192 `course_units` int(11) NOT NULL,
193 `course_prerequisites` varchar(200) NOT NULL,
194 `course_optional` tinyint(1) NOT NULL,
195 `course_type` int(11) NOT NULL,
196 `course_textbook` varchar(255) NOT NULL,
197 PRIMARY KEY (`id`)
198) ENGINE=InnoDB DEFAULT CHARSET=utf8;
199
200-- Data exporting was unselected.
201
202-- Dumping structure for table formsuob_newenuob_en.course_levels
203CREATE TABLE IF NOT EXISTS `course_levels` (
204 `id` int(11) NOT NULL AUTO_INCREMENT,
205 `title` varchar(20) NOT NULL,
206 PRIMARY KEY (`id`)
207) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
208
209-- Data exporting was unselected.
210
211-- Dumping structure for table formsuob_newenuob_en.course_types
212CREATE TABLE IF NOT EXISTS `course_types` (
213 `id` int(11) NOT NULL AUTO_INCREMENT,
214 `title` varchar(50) NOT NULL,
215 PRIMARY KEY (`id`)
216) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
217
218-- Data exporting was unselected.
219
220-- Dumping structure for table formsuob_newenuob_en.data_rows
221CREATE TABLE IF NOT EXISTS `data_rows` (
222 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
223 `data_type_id` int(10) unsigned NOT NULL,
224 `field` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
225 `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
226 `display_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
227 `required` tinyint(1) NOT NULL DEFAULT '0',
228 `browse` tinyint(1) NOT NULL DEFAULT '1',
229 `read` tinyint(1) NOT NULL DEFAULT '1',
230 `edit` tinyint(1) NOT NULL DEFAULT '1',
231 `add` tinyint(1) NOT NULL DEFAULT '1',
232 `delete` tinyint(1) NOT NULL DEFAULT '1',
233 `details` text COLLATE utf8mb4_unicode_ci,
234 `order` int(11) NOT NULL DEFAULT '1',
235 PRIMARY KEY (`id`),
236 KEY `data_rows_data_type_id_foreign` (`data_type_id`),
237 CONSTRAINT `data_rows_data_type_id_foreign` FOREIGN KEY (`data_type_id`) REFERENCES `data_types` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
238) ENGINE=InnoDB AUTO_INCREMENT=204 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
239
240-- Data exporting was unselected.
241
242-- Dumping structure for table formsuob_newenuob_en.data_types
243CREATE TABLE IF NOT EXISTS `data_types` (
244 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
245 `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
246 `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
247 `display_name_singular` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
248 `display_name_plural` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
249 `icon` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
250 `model_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
251 `policy_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
252 `controller` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
253 `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
254 `generate_permissions` tinyint(1) NOT NULL DEFAULT '0',
255 `server_side` tinyint(4) NOT NULL DEFAULT '0',
256 `details` text COLLATE utf8mb4_unicode_ci,
257 `created_at` timestamp NULL DEFAULT NULL,
258 `updated_at` timestamp NULL DEFAULT NULL,
259 PRIMARY KEY (`id`),
260 UNIQUE KEY `data_types_name_unique` (`name`),
261 UNIQUE KEY `data_types_slug_unique` (`slug`)
262) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
263
264-- Data exporting was unselected.
265
266-- Dumping structure for table formsuob_newenuob_en.degree_requirements
267CREATE TABLE IF NOT EXISTS `degree_requirements` (
268 `id` int(11) NOT NULL AUTO_INCREMENT,
269 `college_id` int(11) NOT NULL,
270 `bachelor` text NOT NULL,
271 `diploma` text NOT NULL,
272 `master` text NOT NULL,
273 `phd` text NOT NULL,
274 PRIMARY KEY (`id`)
275) ENGINE=InnoDB DEFAULT CHARSET=utf8;
276
277-- Data exporting was unselected.
278
279-- Dumping structure for table formsuob_newenuob_en.departments
280CREATE TABLE IF NOT EXISTS `departments` (
281 `id` int(11) NOT NULL AUTO_INCREMENT,
282 `name` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
283 `ename` varchar(50) DEFAULT NULL,
284 `college_id` tinyint(4) DEFAULT NULL,
285 `study_years` tinyint(4) DEFAULT '4',
286 `branch` tinyint(1) DEFAULT '0',
287 `address` varchar(200) DEFAULT NULL,
288 `phone` varchar(50) DEFAULT NULL,
289 `fax` varchar(255) DEFAULT NULL,
290 `email` varchar(100) DEFAULT NULL,
291 `chairman_name` varchar(50) DEFAULT NULL,
292 `chairman_name_ar` varchar(50) NOT NULL,
293 `chair_message` text,
294 `chair_message_ar` text NOT NULL,
295 `description` text,
296 `description_ar` text NOT NULL,
297 PRIMARY KEY (`id`)
298) ENGINE=InnoDB AUTO_INCREMENT=116 DEFAULT CHARSET=latin1;
299
300-- Data exporting was unselected.
301
302-- Dumping structure for table formsuob_newenuob_en.department_students
303CREATE TABLE IF NOT EXISTS `department_students` (
304 `id` int(11) NOT NULL AUTO_INCREMENT,
305 `dept_id` int(11) NOT NULL,
306 `year` int(11) NOT NULL,
307 `undergraduate` int(11) NOT NULL,
308 `undergraduate_first` int(11) NOT NULL,
309 `graduate` int(11) NOT NULL,
310 `graduate_first` int(11) NOT NULL,
311 `bachelor_granted` int(11) NOT NULL,
312 `diploma_granted` int(11) NOT NULL,
313 `master_granted` int(11) NOT NULL,
314 `phd_granted` int(11) NOT NULL,
315 `board_granted` int(11) NOT NULL,
316 PRIMARY KEY (`id`)
317) ENGINE=InnoDB DEFAULT CHARSET=utf8;
318
319-- Data exporting was unselected.
320
321-- Dumping structure for table formsuob_newenuob_en.events
322CREATE TABLE IF NOT EXISTS `events` (
323 `id` int(11) NOT NULL AUTO_INCREMENT,
324 `ar_title` varchar(255) NOT NULL,
325 `ar_details` text NOT NULL,
326 `en_title` varchar(255) NOT NULL,
327 `en_details` text NOT NULL,
328 `date` datetime NOT NULL,
329 `category_id` int(11) NOT NULL,
330 `post_date` datetime NOT NULL,
331 `events_target_level_id` int(11) NOT NULL COMMENT 'table target_levels',
332 `target_id` int(11) NOT NULL COMMENT 'college or dept id, 0 for univ.',
333 `photo` varchar(200) NOT NULL,
334 `priority` int(11) NOT NULL,
335 PRIMARY KEY (`id`)
336) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
337
338-- Data exporting was unselected.
339
340-- Dumping structure for table formsuob_newenuob_en.faculty
341CREATE TABLE IF NOT EXISTS `faculty` (
342 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
343 `f_name` varchar(45) DEFAULT NULL,
344 `s_name` varchar(45) DEFAULT NULL,
345 `th_name` varchar(45) DEFAULT NULL,
346 `l_name` varchar(45) DEFAULT NULL,
347 `fam_name` varchar(45) DEFAULT NULL,
348 `gender` varchar(45) DEFAULT NULL,
349 `ename` varchar(100) DEFAULT NULL,
350 `religion` varchar(45) DEFAULT NULL,
351 `nationality` varchar(100) DEFAULT NULL,
352 `nationalism` varchar(100) DEFAULT NULL,
353 `idcard_no` varchar(45) DEFAULT NULL,
354 `birth_place` varchar(45) DEFAULT NULL,
355 `birth_date` varchar(10) DEFAULT NULL,
356 `year` varchar(45) DEFAULT NULL,
357 `department_id` int(10) unsigned DEFAULT NULL,
358 `certificate_id` int(11) NOT NULL,
359 `rank_id` int(11) NOT NULL,
360 `major` varchar(100) DEFAULT NULL,
361 `minor` varchar(100) DEFAULT NULL,
362 `hire_year` int(11) DEFAULT NULL,
363 `unicard_no` varchar(45) DEFAULT NULL,
364 `unicard_issue_date` varchar(45) DEFAULT NULL,
365 `city` varchar(45) DEFAULT NULL,
366 `district` varchar(45) DEFAULT NULL,
367 `district_no` varchar(45) DEFAULT NULL,
368 `street` varchar(45) DEFAULT NULL,
369 `nearest_point` varchar(300) DEFAULT NULL,
370 `phone` varchar(45) DEFAULT NULL,
371 `registration_code` varchar(45) DEFAULT NULL,
372 `email` varchar(100) DEFAULT NULL,
373 `email_verified_at` timestamp NULL DEFAULT NULL,
374 `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
375 `created_at` timestamp NULL DEFAULT NULL,
376 `updated_at` timestamp NULL DEFAULT NULL,
377 `password` varchar(255) DEFAULT NULL,
378 `cv` varchar(3000) DEFAULT NULL,
379 `cvpath` varchar(50) DEFAULT NULL,
380 `photo` varchar(50) DEFAULT NULL,
381 `scholar` varchar(255) DEFAULT NULL,
382 `researchgate` varchar(255) DEFAULT NULL,
383 `orcid` varchar(255) DEFAULT NULL,
384 `webofscience` varchar(255) DEFAULT NULL,
385 `scopus` varchar(255) DEFAULT NULL,
386 `visits` int(11) NOT NULL DEFAULT '5',
387 `last_update` date NOT NULL DEFAULT '2018-10-01',
388 PRIMARY KEY (`id`)
389) ENGINE=InnoDB AUTO_INCREMENT=3032 DEFAULT CHARSET=utf8;
390
391-- Data exporting was unselected.
392
393-- Dumping structure for table formsuob_newenuob_en.faculty_activites
394CREATE TABLE IF NOT EXISTS `faculty_activites` (
395 `id` int(22) NOT NULL AUTO_INCREMENT,
396 `name` varchar(200) CHARACTER SET utf8 NOT NULL,
397 `type` int(4) NOT NULL,
398 `year` int(4) NOT NULL,
399 `lecturer_id` int(11) NOT NULL,
400 `local` int(2) NOT NULL,
401 PRIMARY KEY (`id`)
402) ENGINE=InnoDB AUTO_INCREMENT=9900 DEFAULT CHARSET=latin1;
403
404-- Data exporting was unselected.
405
406-- Dumping structure for table formsuob_newenuob_en.faculty_activites_type
407CREATE TABLE IF NOT EXISTS `faculty_activites_type` (
408 `id` int(2) NOT NULL AUTO_INCREMENT,
409 `name` varchar(50) CHARACTER SET utf8 NOT NULL,
410 `ename` varchar(30) NOT NULL,
411 PRIMARY KEY (`id`)
412) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
413
414-- Data exporting was unselected.
415
416-- Dumping structure for table formsuob_newenuob_en.faculty_certificates
417CREATE TABLE IF NOT EXISTS `faculty_certificates` (
418 `id` int(11) NOT NULL AUTO_INCREMENT,
419 `faculty_id` int(11) NOT NULL,
420 `certificate_id` int(11) NOT NULL,
421 `year` int(11) NOT NULL,
422 `major` varchar(100) NOT NULL,
423 `minor` varchar(100) NOT NULL,
424 `university` varchar(50) NOT NULL,
425 `country` varchar(50) NOT NULL,
426 PRIMARY KEY (`id`)
427) ENGINE=InnoDB AUTO_INCREMENT=4017 DEFAULT CHARSET=utf8;
428
429-- Data exporting was unselected.
430
431-- Dumping structure for table formsuob_newenuob_en.faculty_links
432CREATE TABLE IF NOT EXISTS `faculty_links` (
433 `id` int(22) NOT NULL AUTO_INCREMENT,
434 `name` varchar(100) CHARACTER SET utf8 NOT NULL,
435 `url` text CHARACTER SET utf8 NOT NULL,
436 `faculty_id` int(11) NOT NULL,
437 PRIMARY KEY (`id`)
438) ENGINE=InnoDB AUTO_INCREMENT=1550 DEFAULT CHARSET=latin1;
439
440-- Data exporting was unselected.
441
442-- Dumping structure for table formsuob_newenuob_en.faculty_teaching
443CREATE TABLE IF NOT EXISTS `faculty_teaching` (
444 `id` int(22) NOT NULL AUTO_INCREMENT,
445 `name` varchar(50) CHARACTER SET utf8 NOT NULL,
446 `stage` int(11) NOT NULL,
447 `location` varchar(100) CHARACTER SET utf8 NOT NULL,
448 `local` int(2) NOT NULL,
449 `faculty_id` int(11) NOT NULL,
450 `path` text CHARACTER SET utf8,
451 `year` int(4) NOT NULL,
452 `downloads` int(11) NOT NULL DEFAULT '0',
453 PRIMARY KEY (`id`)
454) ENGINE=InnoDB AUTO_INCREMENT=18967 DEFAULT CHARSET=latin1;
455
456-- Data exporting was unselected.
457
458-- Dumping structure for table formsuob_newenuob_en.faculty_teaching2
459CREATE TABLE IF NOT EXISTS `faculty_teaching2` (
460 `id` int(22) NOT NULL AUTO_INCREMENT,
461 `name` varchar(50) CHARACTER SET utf8 NOT NULL,
462 `stage` int(11) NOT NULL,
463 `location` varchar(100) CHARACTER SET utf8 NOT NULL,
464 `local` int(2) NOT NULL,
465 `faculty_id` int(11) NOT NULL,
466 `path` text CHARACTER SET utf8,
467 `year` int(4) NOT NULL,
468 `downloads` int(11) NOT NULL DEFAULT '0',
469 PRIMARY KEY (`id`)
470) ENGINE=InnoDB AUTO_INCREMENT=18645 DEFAULT CHARSET=latin1;
471
472-- Data exporting was unselected.
473
474-- Dumping structure for table formsuob_newenuob_en.failed_jobs
475CREATE TABLE IF NOT EXISTS `failed_jobs` (
476 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
477 `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
478 `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
479 `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
480 `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
481 `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
482 PRIMARY KEY (`id`)
483) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
484
485-- Data exporting was unselected.
486
487-- Dumping structure for table formsuob_newenuob_en.graduate_publications
488CREATE TABLE IF NOT EXISTS `graduate_publications` (
489 `id` int(20) NOT NULL AUTO_INCREMENT,
490 `title` varchar(255) CHARACTER SET utf8 NOT NULL,
491 `year` int(4) NOT NULL,
492 `jo_name` varchar(150) CHARACTER SET utf8 NOT NULL,
493 `jo` tinyint(1) NOT NULL,
494 `single` tinyint(1) NOT NULL,
495 `local` int(11) NOT NULL,
496 `url` text CHARACTER SET utf8 NOT NULL,
497 `clar` tinyint(1) NOT NULL,
498 `sco` tinyint(1) NOT NULL,
499 `path` text CHARACTER SET utf8 NOT NULL,
500 `graduate_student_id` int(11) NOT NULL,
501 `downloads` int(11) NOT NULL DEFAULT '0',
502 PRIMARY KEY (`id`)
503) ENGINE=InnoDB DEFAULT CHARSET=latin1;
504
505-- Data exporting was unselected.
506
507-- Dumping structure for table formsuob_newenuob_en.graduate_students
508CREATE TABLE IF NOT EXISTS `graduate_students` (
509 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
510 `f_name` varchar(45) DEFAULT NULL,
511 `s_name` varchar(45) DEFAULT NULL,
512 `th_name` varchar(45) DEFAULT NULL,
513 `l_name` varchar(45) DEFAULT NULL,
514 `fam_name` varchar(45) DEFAULT NULL,
515 `gender` varchar(45) DEFAULT NULL,
516 `ename` varchar(100) DEFAULT NULL,
517 `supervisor_id` int(11) NOT NULL,
518 `religion` varchar(45) DEFAULT NULL,
519 `nationality` varchar(100) DEFAULT NULL,
520 `nationalism` varchar(100) DEFAULT NULL,
521 `birth_date` varchar(10) DEFAULT NULL,
522 `department_id` int(10) unsigned DEFAULT NULL,
523 `academic_level_id` int(11) NOT NULL,
524 `academic_program_id` int(11) NOT NULL,
525 `phone` varchar(45) DEFAULT NULL,
526 `email` varchar(100) DEFAULT NULL,
527 `password` varchar(255) DEFAULT NULL,
528 `short_bio` varchar(3000) DEFAULT NULL,
529 `interests` varchar(200) NOT NULL,
530 `photo` varchar(50) DEFAULT NULL,
531 `scholar` varchar(255) DEFAULT NULL,
532 `researchgate` varchar(255) DEFAULT NULL,
533 `visits` int(11) NOT NULL DEFAULT '5',
534 `last_update` date NOT NULL DEFAULT '2018-10-01',
535 `gender_ar` varchar(20) NOT NULL,
536 `religion_ar` varchar(100) NOT NULL,
537 `nationality_ar` varchar(100) NOT NULL,
538 `nationalism_ar` varchar(200) NOT NULL,
539 `short_bio_ar` varchar(300) NOT NULL,
540 `interests_ar` varchar(200) NOT NULL,
541 PRIMARY KEY (`id`)
542) ENGINE=InnoDB DEFAULT CHARSET=utf8;
543
544-- Data exporting was unselected.
545
546-- Dumping structure for table formsuob_newenuob_en.halls
547CREATE TABLE IF NOT EXISTS `halls` (
548 `id` int(11) NOT NULL AUTO_INCREMENT,
549 `name` varchar(200) NOT NULL,
550 `capacity` int(11) NOT NULL,
551 `fee` int(11) NOT NULL,
552 `college_id` int(11) NOT NULL,
553 `equipment` text NOT NULL,
554 `ename` varchar(200) NOT NULL,
555 `equipment_ar` text NOT NULL,
556 PRIMARY KEY (`id`)
557) ENGINE=InnoDB DEFAULT CHARSET=utf8;
558
559-- Data exporting was unselected.
560
561-- Dumping structure for table formsuob_newenuob_en.health_centers
562CREATE TABLE IF NOT EXISTS `health_centers` (
563 `id` int(11) NOT NULL AUTO_INCREMENT,
564 `name` varchar(200) NOT NULL,
565 `location` text NOT NULL,
566 `services` text NOT NULL,
567 `contact` text NOT NULL,
568 `ename` varchar(200) NOT NULL,
569 `location_ar` text NOT NULL,
570 `services_ar` text NOT NULL,
571 `contact_ar` text NOT NULL,
572 PRIMARY KEY (`id`)
573) ENGINE=InnoDB DEFAULT CHARSET=utf8;
574
575-- Data exporting was unselected.
576
577-- Dumping structure for table formsuob_newenuob_en.journals
578CREATE TABLE IF NOT EXISTS `journals` (
579 `id` int(11) NOT NULL AUTO_INCREMENT,
580 `title` varchar(255) NOT NULL,
581 `ISSN` varchar(20) NOT NULL,
582 `title_ar` varchar(200) NOT NULL,
583 PRIMARY KEY (`id`)
584) ENGINE=InnoDB DEFAULT CHARSET=utf8;
585
586-- Data exporting was unselected.
587
588-- Dumping structure for table formsuob_newenuob_en.keywords
589CREATE TABLE IF NOT EXISTS `keywords` (
590 `id` int(11) NOT NULL AUTO_INCREMENT,
591 `keyword` varchar(50) NOT NULL,
592 `keyword_ar` varchar(50) NOT NULL,
593 `faculty_id` int(11) NOT NULL,
594 PRIMARY KEY (`id`)
595) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
596
597-- Data exporting was unselected.
598
599-- Dumping structure for table formsuob_newenuob_en.lecturer_roles
600CREATE TABLE IF NOT EXISTS `lecturer_roles` (
601 `id` int(11) NOT NULL AUTO_INCREMENT,
602 `name` varchar(50) NOT NULL,
603 `ename` varchar(50) NOT NULL,
604 PRIMARY KEY (`id`)
605) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
606
607-- Data exporting was unselected.
608
609-- Dumping structure for table formsuob_newenuob_en.libraries
610CREATE TABLE IF NOT EXISTS `libraries` (
611 `id` int(11) NOT NULL AUTO_INCREMENT,
612 `name` varchar(200) NOT NULL,
613 `location` varchar(200) NOT NULL,
614 `services` text NOT NULL,
615 `college_id` int(11) NOT NULL,
616 `contact` text NOT NULL,
617 `ename` varchar(200) NOT NULL,
618 `location_ar` varchar(200) NOT NULL,
619 `services_ar` text NOT NULL,
620 `country_ar` text NOT NULL,
621 PRIMARY KEY (`id`)
622) ENGINE=InnoDB DEFAULT CHARSET=utf8;
623
624-- Data exporting was unselected.
625
626-- Dumping structure for table formsuob_newenuob_en.major_leadership
627CREATE TABLE IF NOT EXISTS `major_leadership` (
628 `id` int(11) NOT NULL AUTO_INCREMENT,
629 `name` varchar(100) NOT NULL,
630 `role_id` int(11) NOT NULL,
631 `college_id` int(11) NOT NULL,
632 `address` varchar(200) NOT NULL,
633 `phone` varchar(50) NOT NULL,
634 `email` varchar(100) NOT NULL,
635 `photo` varchar(50) NOT NULL,
636 `ename` varchar(100) NOT NULL,
637 `address_ar` varchar(200) NOT NULL,
638 PRIMARY KEY (`id`)
639) ENGINE=InnoDB DEFAULT CHARSET=utf8;
640
641-- Data exporting was unselected.
642
643-- Dumping structure for table formsuob_newenuob_en.menus
644CREATE TABLE IF NOT EXISTS `menus` (
645 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
646 `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
647 `created_at` timestamp NULL DEFAULT NULL,
648 `updated_at` timestamp NULL DEFAULT NULL,
649 PRIMARY KEY (`id`),
650 UNIQUE KEY `menus_name_unique` (`name`)
651) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
652
653-- Data exporting was unselected.
654
655-- Dumping structure for table formsuob_newenuob_en.menu_items
656CREATE TABLE IF NOT EXISTS `menu_items` (
657 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
658 `menu_id` int(10) unsigned DEFAULT NULL,
659 `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
660 `url` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
661 `target` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '_self',
662 `icon_class` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
663 `color` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
664 `parent_id` int(11) DEFAULT NULL,
665 `order` int(11) NOT NULL,
666 `created_at` timestamp NULL DEFAULT NULL,
667 `updated_at` timestamp NULL DEFAULT NULL,
668 `route` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
669 `parameters` text COLLATE utf8mb4_unicode_ci,
670 PRIMARY KEY (`id`),
671 KEY `menu_items_menu_id_foreign` (`menu_id`),
672 CONSTRAINT `menu_items_menu_id_foreign` FOREIGN KEY (`menu_id`) REFERENCES `menus` (`id`) ON DELETE CASCADE
673) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
674
675-- Data exporting was unselected.
676
677-- Dumping structure for table formsuob_newenuob_en.migrations
678CREATE TABLE IF NOT EXISTS `migrations` (
679 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
680 `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
681 `batch` int(11) NOT NULL,
682 PRIMARY KEY (`id`)
683) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
684
685-- Data exporting was unselected.
686
687-- Dumping structure for table formsuob_newenuob_en.minor_leadership
688CREATE TABLE IF NOT EXISTS `minor_leadership` (
689 `id` int(11) NOT NULL AUTO_INCREMENT,
690 `name` varchar(100) NOT NULL,
691 `role_id` int(11) NOT NULL,
692 `dept_id` int(11) NOT NULL,
693 `address` varchar(200) NOT NULL,
694 `phone` varchar(50) NOT NULL,
695 `email` varchar(100) NOT NULL,
696 `photo` varchar(50) NOT NULL,
697 `ename` varchar(100) NOT NULL,
698 `address_ar` varchar(200) NOT NULL,
699 PRIMARY KEY (`id`)
700) ENGINE=InnoDB DEFAULT CHARSET=utf8;
701
702-- Data exporting was unselected.
703
704-- Dumping structure for table formsuob_newenuob_en.nav_menus
705CREATE TABLE IF NOT EXISTS `nav_menus` (
706 `id` int(11) NOT NULL AUTO_INCREMENT,
707 `menu_title_ar` varchar(255) NOT NULL,
708 `menu_title_en` varchar(255) NOT NULL,
709 `note` text,
710 PRIMARY KEY (`id`)
711) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
712
713-- Data exporting was unselected.
714
715-- Dumping structure for table formsuob_newenuob_en.nav_menu_items
716CREATE TABLE IF NOT EXISTS `nav_menu_items` (
717 `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
718 `title` varchar(255) NOT NULL COMMENT ' عنوان',
719 `title_en` varchar(255) NOT NULL,
720 `url` varchar(255) NOT NULL COMMENT 'الرابط',
721 `url_en` varchar(255) NOT NULL,
722 `item_order` int(11) NOT NULL COMMENT 'ترتيب العنصر',
723 `menu_id` int(1) NOT NULL COMMENT 'رقم القائمة',
724 `parent_id` int(11) NOT NULL COMMENT 'رقم العنصر الاب',
725 `created_at` timestamp NULL DEFAULT NULL,
726 `updated_at` timestamp NULL DEFAULT NULL,
727 PRIMARY KEY (`id`)
728) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8;
729
730-- Data exporting was unselected.
731
732-- Dumping structure for table formsuob_newenuob_en.news
733CREATE TABLE IF NOT EXISTS `news` (
734 `id` int(11) NOT NULL AUTO_INCREMENT,
735 `ar_title` varchar(255) DEFAULT NULL,
736 `ar_details` text,
737 `en_title` varchar(255) DEFAULT NULL,
738 `en_details` text,
739 `publisher` varchar(300) DEFAULT NULL,
740 `news_topics_id` int(11) DEFAULT NULL,
741 `news_target_level_id` int(11) DEFAULT NULL COMMENT 'table target_levels',
742 `target_id` int(11) DEFAULT NULL COMMENT 'college or dept id, 0 for univ.',
743 `reporter` varchar(100) DEFAULT NULL,
744 `photo` text,
745 `priority` int(11) DEFAULT NULL,
746 `publisher_ar` varchar(300) DEFAULT NULL,
747 `reporter_ar` varchar(100) DEFAULT NULL,
748 `old_id` int(11) DEFAULT NULL COMMENT 'الاي دي القديم',
749 `created_at` timestamp NULL DEFAULT NULL,
750 `updated_at` timestamp NULL DEFAULT NULL,
751 PRIMARY KEY (`id`)
752) ENGINE=InnoDB AUTO_INCREMENT=4073 DEFAULT CHARSET=utf8;
753
754-- Data exporting was unselected.
755
756-- Dumping structure for table formsuob_newenuob_en.news_topics
757CREATE TABLE IF NOT EXISTS `news_topics` (
758 `id` int(11) NOT NULL AUTO_INCREMENT,
759 `ar_title` varchar(50) NOT NULL,
760 `en_title` varchar(50) NOT NULL,
761 PRIMARY KEY (`id`)
762) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
763
764-- Data exporting was unselected.
765
766-- Dumping structure for table formsuob_newenuob_en.pages
767CREATE TABLE IF NOT EXISTS `pages` (
768 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
769 `author_id` int(11) NOT NULL,
770 `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
771 `excerpt` text COLLATE utf8mb4_unicode_ci,
772 `body` text COLLATE utf8mb4_unicode_ci,
773 `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
774 `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
775 `meta_description` text COLLATE utf8mb4_unicode_ci,
776 `meta_keywords` text COLLATE utf8mb4_unicode_ci,
777 `status` enum('ACTIVE','INACTIVE') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'INACTIVE',
778 `created_at` timestamp NULL DEFAULT NULL,
779 `updated_at` timestamp NULL DEFAULT NULL,
780 PRIMARY KEY (`id`),
781 UNIQUE KEY `pages_slug_unique` (`slug`)
782) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
783
784-- Data exporting was unselected.
785
786-- Dumping structure for table formsuob_newenuob_en.pages2
787CREATE TABLE IF NOT EXISTS `pages2` (
788 `id` int(11) NOT NULL AUTO_INCREMENT,
789 `title_ar` varchar(255) DEFAULT NULL,
790 `title_en` varchar(255) DEFAULT NULL,
791 `content_ar` text,
792 `content_en` text,
793 `slug` varchar(255) DEFAULT NULL,
794 `slug_ar` varchar(250) NOT NULL,
795 `college_id` int(11) DEFAULT '0',
796 PRIMARY KEY (`id`)
797) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
798
799-- Data exporting was unselected.
800
801-- Dumping structure for table formsuob_newenuob_en.password_resets
802CREATE TABLE IF NOT EXISTS `password_resets` (
803 `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
804 `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
805 `created_at` timestamp NULL DEFAULT NULL,
806 KEY `password_resets_email_index` (`email`)
807) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
808
809-- Data exporting was unselected.
810
811-- Dumping structure for table formsuob_newenuob_en.permissions
812CREATE TABLE IF NOT EXISTS `permissions` (
813 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
814 `key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
815 `table_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
816 `created_at` timestamp NULL DEFAULT NULL,
817 `updated_at` timestamp NULL DEFAULT NULL,
818 PRIMARY KEY (`id`),
819 KEY `permissions_key_index` (`key`)
820) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
821
822-- Data exporting was unselected.
823
824-- Dumping structure for table formsuob_newenuob_en.permission_role
825CREATE TABLE IF NOT EXISTS `permission_role` (
826 `permission_id` bigint(20) unsigned NOT NULL,
827 `role_id` bigint(20) unsigned NOT NULL,
828 PRIMARY KEY (`permission_id`,`role_id`),
829 KEY `permission_role_permission_id_index` (`permission_id`),
830 KEY `permission_role_role_id_index` (`role_id`),
831 CONSTRAINT `permission_role_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
832 CONSTRAINT `permission_role_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
833) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
834
835-- Data exporting was unselected.
836
837-- Dumping structure for table formsuob_newenuob_en.posts
838CREATE TABLE IF NOT EXISTS `posts` (
839 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
840 `author_id` int(11) NOT NULL,
841 `category_id` int(11) DEFAULT NULL,
842 `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
843 `seo_title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
844 `excerpt` text COLLATE utf8mb4_unicode_ci,
845 `body` text COLLATE utf8mb4_unicode_ci NOT NULL,
846 `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
847 `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
848 `meta_description` text COLLATE utf8mb4_unicode_ci,
849 `meta_keywords` text COLLATE utf8mb4_unicode_ci,
850 `status` enum('PUBLISHED','DRAFT','PENDING') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'DRAFT',
851 `featured` tinyint(1) NOT NULL DEFAULT '0',
852 `created_at` timestamp NULL DEFAULT NULL,
853 `updated_at` timestamp NULL DEFAULT NULL,
854 `en_title` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
855 `en_description` text COLLATE utf8mb4_unicode_ci,
856 PRIMARY KEY (`id`),
857 UNIQUE KEY `posts_slug_unique` (`slug`)
858) ENGINE=InnoDB AUTO_INCREMENT=150 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
859
860-- Data exporting was unselected.
861
862-- Dumping structure for table formsuob_newenuob_en.publ
863CREATE TABLE IF NOT EXISTS `publ` (
864 `id` int(11) NOT NULL AUTO_INCREMENT,
865 `name` varchar(17) CHARACTER SET utf8 NOT NULL,
866 `ename` varchar(20) NOT NULL,
867 PRIMARY KEY (`id`)
868) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
869
870-- Data exporting was unselected.
871
872-- Dumping structure for table formsuob_newenuob_en.publications
873CREATE TABLE IF NOT EXISTS `publications` (
874 `id` int(20) NOT NULL AUTO_INCREMENT,
875 `title` varchar(150) CHARACTER SET utf8 NOT NULL,
876 `year` int(4) NOT NULL,
877 `jo_name` varchar(150) CHARACTER SET utf8 DEFAULT NULL,
878 `jo` tinyint(1) NOT NULL,
879 `single` tinyint(1) NOT NULL,
880 `local` int(11) NOT NULL,
881 `url` text CHARACTER SET utf8,
882 `clar` tinyint(1) NOT NULL,
883 `sco` tinyint(1) NOT NULL,
884 `path` text CHARACTER SET utf8,
885 `lecturer_id` int(11) NOT NULL,
886 `downloads` int(11) NOT NULL DEFAULT '0',
887 PRIMARY KEY (`id`)
888) ENGINE=InnoDB AUTO_INCREMENT=20102 DEFAULT CHARSET=latin1;
889
890-- Data exporting was unselected.
891
892-- Dumping structure for table formsuob_newenuob_en.publications2
893CREATE TABLE IF NOT EXISTS `publications2` (
894 `id` int(20) NOT NULL AUTO_INCREMENT,
895 `title` varchar(150) CHARACTER SET utf8 NOT NULL,
896 `year` int(4) NOT NULL,
897 `jo_name` varchar(150) CHARACTER SET utf8 NOT NULL,
898 `jo` tinyint(1) NOT NULL,
899 `single` tinyint(1) NOT NULL,
900 `local` int(11) NOT NULL,
901 `url` text CHARACTER SET utf8 NOT NULL,
902 `clar` tinyint(1) NOT NULL,
903 `sco` tinyint(1) NOT NULL,
904 `path` text CHARACTER SET utf8 NOT NULL,
905 `lecturer_id` int(11) NOT NULL,
906 `downloads` int(11) NOT NULL DEFAULT '0',
907 PRIMARY KEY (`id`)
908) ENGINE=InnoDB AUTO_INCREMENT=19914 DEFAULT CHARSET=latin1;
909
910-- Data exporting was unselected.
911
912-- Dumping structure for table formsuob_newenuob_en.ranks
913CREATE TABLE IF NOT EXISTS `ranks` (
914 `id` int(11) NOT NULL AUTO_INCREMENT,
915 `name` varchar(50) CHARACTER SET utf8 NOT NULL,
916 `abbrev` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
917 `abbrev_en` varchar(10) NOT NULL,
918 `ename` varchar(30) NOT NULL,
919 PRIMARY KEY (`id`)
920) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
921
922-- Data exporting was unselected.
923
924-- Dumping structure for table formsuob_newenuob_en.research_areas
925CREATE TABLE IF NOT EXISTS `research_areas` (
926 `id` int(11) NOT NULL AUTO_INCREMENT,
927 `title` varchar(255) NOT NULL,
928 `dept_id` int(11) NOT NULL,
929 `description` text NOT NULL,
930 `team_leader` varchar(255) NOT NULL,
931 `address` varchar(200) NOT NULL,
932 `title_ar` varchar(250) NOT NULL,
933 `description_ar` text NOT NULL,
934 `team_leader_ar` varchar(250) NOT NULL,
935 `address_ar` varchar(200) NOT NULL,
936 `phone` varchar(50) NOT NULL,
937 `email` varchar(100) NOT NULL,
938 PRIMARY KEY (`id`)
939) ENGINE=InnoDB DEFAULT CHARSET=utf8;
940
941-- Data exporting was unselected.
942
943-- Dumping structure for table formsuob_newenuob_en.reset_pass_faculty
944CREATE TABLE IF NOT EXISTS `reset_pass_faculty` (
945 `id` int(11) NOT NULL AUTO_INCREMENT,
946 `faculty_id` int(11) NOT NULL,
947 `code` varchar(60) NOT NULL,
948 PRIMARY KEY (`id`)
949) ENGINE=MyISAM AUTO_INCREMENT=1920 DEFAULT CHARSET=utf8;
950
951-- Data exporting was unselected.
952
953-- Dumping structure for table formsuob_newenuob_en.roles
954CREATE TABLE IF NOT EXISTS `roles` (
955 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
956 `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
957 `display_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
958 `created_at` timestamp NULL DEFAULT NULL,
959 `updated_at` timestamp NULL DEFAULT NULL,
960 PRIMARY KEY (`id`),
961 UNIQUE KEY `roles_name_unique` (`name`)
962) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
963
964-- Data exporting was unselected.
965
966-- Dumping structure for table formsuob_newenuob_en.settings
967CREATE TABLE IF NOT EXISTS `settings` (
968 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
969 `key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
970 `display_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
971 `value` text COLLATE utf8mb4_unicode_ci,
972 `details` text COLLATE utf8mb4_unicode_ci,
973 `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
974 `order` int(11) NOT NULL DEFAULT '1',
975 `group` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
976 PRIMARY KEY (`id`),
977 UNIQUE KEY `settings_key_unique` (`key`)
978) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
979
980-- Data exporting was unselected.
981
982-- Dumping structure for table formsuob_newenuob_en.social_media
983CREATE TABLE IF NOT EXISTS `social_media` (
984 `id` int(11) NOT NULL AUTO_INCREMENT,
985 `college_id` int(11) NOT NULL,
986 `facebook` text NOT NULL,
987 `twitter` text NOT NULL,
988 `youtube` text NOT NULL,
989 `linkedin` text NOT NULL,
990 PRIMARY KEY (`id`)
991) ENGINE=InnoDB DEFAULT CHARSET=utf8;
992
993-- Data exporting was unselected.
994
995-- Dumping structure for table formsuob_newenuob_en.sport_centers
996CREATE TABLE IF NOT EXISTS `sport_centers` (
997 `id` int(11) NOT NULL AUTO_INCREMENT,
998 `name` varchar(200) NOT NULL,
999 `location` varchar(200) NOT NULL,
1000 `services` text NOT NULL,
1001 `college_id` int(11) NOT NULL,
1002 `contact` text NOT NULL,
1003 `ename` varchar(200) NOT NULL,
1004 `location_ar` varchar(200) NOT NULL,
1005 `services_ar` text NOT NULL,
1006 `contact_ar` text NOT NULL,
1007 PRIMARY KEY (`id`)
1008) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1009
1010-- Data exporting was unselected.
1011
1012-- Dumping structure for table formsuob_newenuob_en.stages
1013CREATE TABLE IF NOT EXISTS `stages` (
1014 `id` int(11) NOT NULL AUTO_INCREMENT,
1015 `name` varchar(20) CHARACTER SET utf8 NOT NULL,
1016 `ename` varchar(10) NOT NULL,
1017 PRIMARY KEY (`id`)
1018) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
1019
1020-- Data exporting was unselected.
1021
1022-- Dumping structure for table formsuob_newenuob_en.student_guide
1023CREATE TABLE IF NOT EXISTS `student_guide` (
1024 `id` int(11) NOT NULL AUTO_INCREMENT,
1025 `college_id` int(11) DEFAULT NULL,
1026 `information` text,
1027 `student_rights` text,
1028 `relations` text,
1029 `exam_details` text,
1030 `examination_rules` text,
1031 `grade_book` text,
1032 `registration_process` text,
1033 `requlations` text,
1034 `information_ar` text NOT NULL,
1035 `student_rights_ar` text NOT NULL,
1036 `relations_ar` text NOT NULL,
1037 `exam_details_ar` text NOT NULL,
1038 `examination_rules_ar` text NOT NULL,
1039 `grade_book_ar` text NOT NULL,
1040 `registration_process_ar` text NOT NULL,
1041 `requlations_ar` text NOT NULL,
1042 PRIMARY KEY (`id`)
1043) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;
1044
1045-- Data exporting was unselected.
1046
1047-- Dumping structure for table formsuob_newenuob_en.target_levels
1048CREATE TABLE IF NOT EXISTS `target_levels` (
1049 `id` int(11) NOT NULL AUTO_INCREMENT,
1050 `title` varchar(50) NOT NULL,
1051 `title_ar` varchar(50) NOT NULL,
1052 PRIMARY KEY (`id`)
1053) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
1054
1055-- Data exporting was unselected.
1056
1057-- Dumping structure for table formsuob_newenuob_en.translations
1058CREATE TABLE IF NOT EXISTS `translations` (
1059 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1060 `table_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
1061 `column_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
1062 `foreign_key` int(10) unsigned NOT NULL,
1063 `locale` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
1064 `value` text COLLATE utf8mb4_unicode_ci NOT NULL,
1065 `created_at` timestamp NULL DEFAULT NULL,
1066 `updated_at` timestamp NULL DEFAULT NULL,
1067 PRIMARY KEY (`id`),
1068 UNIQUE KEY `translations_table_name_column_name_foreign_key_locale_unique` (`table_name`,`column_name`,`foreign_key`,`locale`)
1069) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1070
1071-- Data exporting was unselected.
1072
1073-- Dumping structure for table formsuob_newenuob_en.users
1074CREATE TABLE IF NOT EXISTS `users` (
1075 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1076 `role_id` bigint(20) unsigned DEFAULT NULL,
1077 `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
1078 `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
1079 `avatar` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT 'users/default.png',
1080 `email_verified_at` timestamp NULL DEFAULT NULL,
1081 `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
1082 `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1083 `settings` text COLLATE utf8mb4_unicode_ci,
1084 `created_at` timestamp NULL DEFAULT NULL,
1085 `updated_at` timestamp NULL DEFAULT NULL,
1086 PRIMARY KEY (`id`),
1087 UNIQUE KEY `users_email_unique` (`email`),
1088 KEY `users_role_id_foreign` (`role_id`),
1089 CONSTRAINT `users_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`)
1090) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1091
1092-- Data exporting was unselected.
1093
1094-- Dumping structure for table formsuob_newenuob_en.user_roles
1095CREATE TABLE IF NOT EXISTS `user_roles` (
1096 `user_id` bigint(20) unsigned NOT NULL,
1097 `role_id` bigint(20) unsigned NOT NULL,
1098 PRIMARY KEY (`user_id`,`role_id`),
1099 KEY `user_roles_user_id_index` (`user_id`),
1100 KEY `user_roles_role_id_index` (`role_id`),
1101 CONSTRAINT `user_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE,
1102 CONSTRAINT `user_roles_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
1103) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1104
1105-- Data exporting was unselected.
1106
1107/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
1108/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
1109/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1110