5geuRD0h

1-- MySQL dump 10.13  Distrib 5.7.23, for Linux (x86_64)
2--
3-- Host: localhost    Database: db_premium_cms_sekolahku
4-- ------------------------------------------------------
5-- Server version	5.7.23-0ubuntu0.18.04.1
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `_sessions`
20--
21
22DROP TABLE IF EXISTS `_sessions`;
23/*!40101 SET @saved_cs_client     = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `_sessions` (
26  `id` varchar(128) NOT NULL,
27  `ip_address` varchar(45) NOT NULL,
28  `timestamp` int(10) unsigned NOT NULL DEFAULT '0',
29  `data` blob NOT NULL,
30  KEY `ci_sessions_timestamp` (`timestamp`)
31) ENGINE=InnoDB DEFAULT CHARSET=utf8;
32/*!40101 SET character_set_client = @saved_cs_client */;
33
34--
35-- Dumping data for table `_sessions`
36--
37
38LOCK TABLES `_sessions` WRITE;
39/*!40000 ALTER TABLE `_sessions` DISABLE KEYS */;
40/*!40000 ALTER TABLE `_sessions` ENABLE KEYS */;
41UNLOCK TABLES;
42
43--
44-- Table structure for table `academic_years`
45--
46
47DROP TABLE IF EXISTS `academic_years`;
48/*!40101 SET @saved_cs_client     = @@character_set_client */;
49/*!40101 SET character_set_client = utf8 */;
50CREATE TABLE `academic_years` (
51  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
52  `academic_year` varchar(9) NOT NULL COMMENT 'Tahun Pelajaran',
53  `semester` enum('odd','even') NOT NULL DEFAULT 'odd' COMMENT 'odd = Ganjil, even = Genap',
54  `current_semester` enum('true','false') NOT NULL DEFAULT 'false',
55  `admission_semester` enum('true','false') NOT NULL DEFAULT 'false',
56  `created_at` timestamp DEFAULT NOW(),
57  `updated_at` timestamp NULL DEFAULT NULL,
58  `deleted_at` timestamp NULL DEFAULT NULL,
59  `restored_at` timestamp NULL DEFAULT NULL,
60  `created_by` bigint(20) DEFAULT NULL,
61  `updated_by` bigint(20) DEFAULT NULL,
62  `deleted_by` bigint(20) DEFAULT NULL,
63  `restored_by` bigint(20) DEFAULT NULL,
64  `is_deleted` enum('true','false') DEFAULT 'false',
65  PRIMARY KEY (`id`),
66  UNIQUE KEY `academic_year` (`academic_year`)
67) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
68/*!40101 SET character_set_client = @saved_cs_client */;
69
70--
71-- Dumping data for table `academic_years`
72--
73
74LOCK TABLES `academic_years` WRITE;
75/*!40000 ALTER TABLE `academic_years` DISABLE KEYS */;
76INSERT INTO `academic_years` VALUES (1,'2018-2019','odd','true','true','2018-10-22 05:04:39',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(2,'2019-2020','odd','false','false','2018-10-22 05:04:39',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(3,'2020-2021','odd','false','false','2018-10-22 05:04:39',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false');
77/*!40000 ALTER TABLE `academic_years` ENABLE KEYS */;
78UNLOCK TABLES;
79
80--
81-- Table structure for table `achievements`
82--
83
84DROP TABLE IF EXISTS `achievements`;
85/*!40101 SET @saved_cs_client     = @@character_set_client */;
86/*!40101 SET character_set_client = utf8 */;
87CREATE TABLE `achievements` (
88  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
89  `student_id` bigint(20) NOT NULL DEFAULT '0',
90  `achievement_description` varchar(255) NOT NULL,
91  `achievement_type` bigint(20) NOT NULL DEFAULT '0',
92  `achievement_level` smallint(6) NOT NULL DEFAULT '0',
93  `achievement_year` year(4) NOT NULL,
94  `achievement_organizer` varchar(255) NOT NULL,
95  `created_at` timestamp DEFAULT NOW(),
96  `updated_at` timestamp NULL DEFAULT NULL,
97  `deleted_at` timestamp NULL DEFAULT NULL,
98  `restored_at` timestamp NULL DEFAULT NULL,
99  `created_by` bigint(20) DEFAULT NULL,
100  `updated_by` bigint(20) DEFAULT NULL,
101  `deleted_by` bigint(20) DEFAULT NULL,
102  `restored_by` bigint(20) DEFAULT NULL,
103  `is_deleted` enum('true','false') DEFAULT 'false',
104  PRIMARY KEY (`id`),
105  KEY `achievements_student_id__idx` (`student_id`) USING BTREE
106) ENGINE=InnoDB DEFAULT CHARSET=utf8;
107/*!40101 SET character_set_client = @saved_cs_client */;
108
109--
110-- Dumping data for table `achievements`
111--
112
113LOCK TABLES `achievements` WRITE;
114/*!40000 ALTER TABLE `achievements` DISABLE KEYS */;
115/*!40000 ALTER TABLE `achievements` ENABLE KEYS */;
116UNLOCK TABLES;
117
118--
119-- Table structure for table `admission_exam_attendances`
120--
121
122DROP TABLE IF EXISTS `admission_exam_attendances`;
123/*!40101 SET @saved_cs_client     = @@character_set_client */;
124/*!40101 SET character_set_client = utf8 */;
125CREATE TABLE `admission_exam_attendances` (
126  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
127  `exam_schedule_id` bigint(20) NOT NULL COMMENT 'FK dari table admission_exam_schedules',
128  `student_id` bigint(20) NOT NULL COMMENT 'FK Dari table students',
129  `presence` enum('H','S','I','A') DEFAULT 'H',
130  `created_at` timestamp DEFAULT NOW(),
131  `updated_at` timestamp NULL DEFAULT NULL,
132  `deleted_at` timestamp NULL DEFAULT NULL,
133  `restored_at` timestamp NULL DEFAULT NULL,
134  `created_by` bigint(20) DEFAULT NULL,
135  `updated_by` bigint(20) DEFAULT NULL,
136  `deleted_by` bigint(20) DEFAULT NULL,
137  `restored_by` bigint(20) DEFAULT NULL,
138  `is_deleted` enum('true','false') DEFAULT 'false',
139  PRIMARY KEY (`id`),
140  UNIQUE KEY `unique_field` (`exam_schedule_id`,`student_id`),
141  KEY `admission_exam_attendances_exam_schedule_id__idx` (`exam_schedule_id`) USING BTREE,
142  KEY `admission_exam_attendances_exam_student_id__idx` (`student_id`) USING BTREE
143) ENGINE=InnoDB DEFAULT CHARSET=utf8;
144/*!40101 SET character_set_client = @saved_cs_client */;
145
146--
147-- Dumping data for table `admission_exam_attendances`
148--
149
150LOCK TABLES `admission_exam_attendances` WRITE;
151/*!40000 ALTER TABLE `admission_exam_attendances` DISABLE KEYS */;
152/*!40000 ALTER TABLE `admission_exam_attendances` ENABLE KEYS */;
153UNLOCK TABLES;
154
155--
156-- Table structure for table `admission_exam_schedules`
157--
158
159DROP TABLE IF EXISTS `admission_exam_schedules`;
160/*!40101 SET @saved_cs_client     = @@character_set_client */;
161/*!40101 SET character_set_client = utf8 */;
162CREATE TABLE `admission_exam_schedules` (
163  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
164  `subject_setting_detail_id` bigint(20) NOT NULL COMMENT 'FK dari table admission_subject_setting_details',
165  `room_id` bigint(20) NOT NULL COMMENT 'Ruangan',
166  `exam_date` date DEFAULT NULL COMMENT 'Tanggal Pelaksanaan Ujian Saringan Masuk',
167  `exam_start_time` time NOT NULL COMMENT 'Jam Mulai',
168  `exam_end_time` time NOT NULL COMMENT 'Jam selesai',
169  `created_at` timestamp DEFAULT NOW(),
170  `updated_at` timestamp NULL DEFAULT NULL,
171  `deleted_at` timestamp NULL DEFAULT NULL,
172  `restored_at` timestamp NULL DEFAULT NULL,
173  `created_by` bigint(20) DEFAULT NULL,
174  `updated_by` bigint(20) DEFAULT NULL,
175  `deleted_by` bigint(20) DEFAULT NULL,
176  `restored_by` bigint(20) DEFAULT NULL,
177  `is_deleted` enum('true','false') DEFAULT 'false',
178  PRIMARY KEY (`id`),
179  UNIQUE KEY `unique_field` (`subject_setting_detail_id`,`room_id`,`exam_date`),
180  KEY `admission_exam_schedules_subject_setting_detail_id__idx` (`subject_setting_detail_id`) USING BTREE,
181  KEY `admission_exam_schedules_room_id__idx` (`room_id`) USING BTREE
182) ENGINE=InnoDB DEFAULT CHARSET=utf8;
183/*!40101 SET character_set_client = @saved_cs_client */;
184
185--
186-- Dumping data for table `admission_exam_schedules`
187--
188
189LOCK TABLES `admission_exam_schedules` WRITE;
190/*!40000 ALTER TABLE `admission_exam_schedules` DISABLE KEYS */;
191/*!40000 ALTER TABLE `admission_exam_schedules` ENABLE KEYS */;
192UNLOCK TABLES;
193
194--
195-- Table structure for table `admission_phases`
196--
197
198DROP TABLE IF EXISTS `admission_phases`;
199/*!40101 SET @saved_cs_client     = @@character_set_client */;
200/*!40101 SET character_set_client = utf8 */;
201CREATE TABLE `admission_phases` (
202  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
203  `academic_year_id` bigint(20) NOT NULL COMMENT 'Tahun Pelajaran',
204  `phase_name` varchar(255) NOT NULL COMMENT 'Gelombang Pendaftaran',
205  `phase_start_date` date DEFAULT NULL COMMENT 'Tanggal Mulai',
206  `phase_end_date` date DEFAULT NULL COMMENT 'Tanggal Selesai',
207  `created_at` timestamp DEFAULT NOW(),
208  `updated_at` timestamp NULL DEFAULT NULL,
209  `deleted_at` timestamp NULL DEFAULT NULL,
210  `restored_at` timestamp NULL DEFAULT NULL,
211  `created_by` bigint(20) DEFAULT NULL,
212  `updated_by` bigint(20) DEFAULT NULL,
213  `deleted_by` bigint(20) DEFAULT NULL,
214  `restored_by` bigint(20) DEFAULT NULL,
215  `is_deleted` enum('true','false') DEFAULT 'false',
216  PRIMARY KEY (`id`),
217  UNIQUE KEY `unique_field` (`academic_year_id`,`phase_name`),
218  KEY `admission_phases_academic_year_id__idx` (`academic_year_id`) USING BTREE
219) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
220/*!40101 SET character_set_client = @saved_cs_client */;
221
222--
223-- Dumping data for table `admission_phases`
224--
225
226LOCK TABLES `admission_phases` WRITE;
227/*!40000 ALTER TABLE `admission_phases` DISABLE KEYS */;
228INSERT INTO `admission_phases` VALUES (1,1,'Gelombang I','2018-01-01','2018-04-30','2018-10-22 05:04:39',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(2,1,'Gelombang II','2018-05-01','2018-08-31','2018-10-22 05:04:39',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(3,1,'Gelombang III','2018-09-01','2018-12-31','2018-10-22 05:04:39',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false');
229/*!40000 ALTER TABLE `admission_phases` ENABLE KEYS */;
230UNLOCK TABLES;
231
232--
233-- Table structure for table `admission_quotas`
234--
235
236DROP TABLE IF EXISTS `admission_quotas`;
237/*!40101 SET @saved_cs_client     = @@character_set_client */;
238/*!40101 SET character_set_client = utf8 */;
239CREATE TABLE `admission_quotas` (
240  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
241  `academic_year_id` bigint(20) NOT NULL COMMENT 'Tahun Pelajaran',
242  `admission_type_id` bigint(20) NOT NULL COMMENT 'Jalur Pendaftaran',
243  `major_id` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Program Keahlian',
244  `quota` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Kuota Pendaftaran',
245  `created_at` timestamp DEFAULT NOW(),
246  `updated_at` timestamp NULL DEFAULT NULL,
247  `deleted_at` timestamp NULL DEFAULT NULL,
248  `restored_at` timestamp NULL DEFAULT NULL,
249  `created_by` bigint(20) DEFAULT NULL,
250  `updated_by` bigint(20) DEFAULT NULL,
251  `deleted_by` bigint(20) DEFAULT NULL,
252  `restored_by` bigint(20) DEFAULT NULL,
253  `is_deleted` enum('true','false') DEFAULT 'false',
254  PRIMARY KEY (`id`),
255  UNIQUE KEY `unique_field` (`academic_year_id`,`admission_type_id`,`major_id`),
256  KEY `admission_quotas_academic_year_id__idx` (`academic_year_id`) USING BTREE,
257  KEY `admission_quotas_admission_type_id__idx` (`admission_type_id`) USING BTREE,
258  KEY `admission_quotas_major_id__idx` (`major_id`) USING BTREE
259) ENGINE=InnoDB DEFAULT CHARSET=utf8;
260/*!40101 SET character_set_client = @saved_cs_client */;
261
262--
263-- Dumping data for table `admission_quotas`
264--
265
266LOCK TABLES `admission_quotas` WRITE;
267/*!40000 ALTER TABLE `admission_quotas` DISABLE KEYS */;
268/*!40000 ALTER TABLE `admission_quotas` ENABLE KEYS */;
269UNLOCK TABLES;
270
271--
272-- Table structure for table `admission_subject_scores`
273--
274
275DROP TABLE IF EXISTS `admission_subject_scores`;
276/*!40101 SET @saved_cs_client     = @@character_set_client */;
277/*!40101 SET character_set_client = utf8 */;
278CREATE TABLE `admission_subject_scores` (
279  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
280  `subject_setting_detail_id` bigint(20) NOT NULL,
281  `student_id` bigint(20) NOT NULL,
282  `score` decimal(5,2) NOT NULL,
283  `created_at` timestamp DEFAULT NOW(),
284  `updated_at` timestamp NULL DEFAULT NULL,
285  `deleted_at` timestamp NULL DEFAULT NULL,
286  `restored_at` timestamp NULL DEFAULT NULL,
287  `created_by` bigint(20) DEFAULT NULL,
288  `updated_by` bigint(20) DEFAULT NULL,
289  `deleted_by` bigint(20) DEFAULT NULL,
290  `restored_by` bigint(20) DEFAULT NULL,
291  `is_deleted` enum('true','false') DEFAULT 'false',
292  PRIMARY KEY (`id`),
293  UNIQUE KEY `unique_field` (`subject_setting_detail_id`,`student_id`),
294  KEY `admission_subject_scores_subject_setting_detail_id__idx` (`subject_setting_detail_id`) USING BTREE,
295  KEY `admission_subject_scores_student_id__idx` (`student_id`) USING BTREE
296) ENGINE=InnoDB DEFAULT CHARSET=utf8;
297/*!40101 SET character_set_client = @saved_cs_client */;
298
299--
300-- Dumping data for table `admission_subject_scores`
301--
302
303LOCK TABLES `admission_subject_scores` WRITE;
304/*!40000 ALTER TABLE `admission_subject_scores` DISABLE KEYS */;
305/*!40000 ALTER TABLE `admission_subject_scores` ENABLE KEYS */;
306UNLOCK TABLES;
307
308--
309-- Table structure for table `admission_subject_setting_details`
310--
311
312DROP TABLE IF EXISTS `admission_subject_setting_details`;
313/*!40101 SET @saved_cs_client     = @@character_set_client */;
314/*!40101 SET character_set_client = utf8 */;
315CREATE TABLE `admission_subject_setting_details` (
316  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
317  `subject_setting_id` bigint(20) NOT NULL,
318  `subject_id` bigint(20) DEFAULT NULL,
319  `visibility` enum('public','private') DEFAULT NULL COMMENT 'Tampil di Form PPDB ? public = tampil, private = hanya dari administrator',
320  `created_at` timestamp DEFAULT NOW(),
321  `updated_at` timestamp NULL DEFAULT NULL,
322  `deleted_at` timestamp NULL DEFAULT NULL,
323  `restored_at` timestamp NULL DEFAULT NULL,
324  `created_by` bigint(20) DEFAULT NULL,
325  `updated_by` bigint(20) DEFAULT NULL,
326  `deleted_by` bigint(20) DEFAULT NULL,
327  `restored_by` bigint(20) DEFAULT NULL,
328  `is_deleted` enum('true','false') DEFAULT 'false',
329  PRIMARY KEY (`id`),
330  UNIQUE KEY `unique_field` (`subject_setting_id`,`subject_id`),
331  KEY `admission_subject_setting_details_subject_setting_id__idx` (`subject_setting_id`) USING BTREE,
332  KEY `admission_subject_setting_details_subject_id__idx` (`subject_id`) USING BTREE
333) ENGINE=InnoDB DEFAULT CHARSET=utf8;
334/*!40101 SET character_set_client = @saved_cs_client */;
335
336--
337-- Dumping data for table `admission_subject_setting_details`
338--
339
340LOCK TABLES `admission_subject_setting_details` WRITE;
341/*!40000 ALTER TABLE `admission_subject_setting_details` DISABLE KEYS */;
342/*!40000 ALTER TABLE `admission_subject_setting_details` ENABLE KEYS */;
343UNLOCK TABLES;
344
345--
346-- Table structure for table `admission_subject_settings`
347--
348
349DROP TABLE IF EXISTS `admission_subject_settings`;
350/*!40101 SET @saved_cs_client     = @@character_set_client */;
351/*!40101 SET character_set_client = utf8 */;
352CREATE TABLE `admission_subject_settings` (
353  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
354  `academic_year_id` bigint(20) NOT NULL,
355  `admission_type_id` bigint(20) DEFAULT NULL,
356  `major_id` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Program Keahlian',
357  `subject_type` enum('exam_schedule','semester_report','national_exam') DEFAULT NULL,
358  `created_at` timestamp DEFAULT NOW(),
359  `updated_at` timestamp NULL DEFAULT NULL,
360  `deleted_at` timestamp NULL DEFAULT NULL,
361  `restored_at` timestamp NULL DEFAULT NULL,
362  `created_by` bigint(20) DEFAULT NULL,
363  `updated_by` bigint(20) DEFAULT NULL,
364  `deleted_by` bigint(20) DEFAULT NULL,
365  `restored_by` bigint(20) DEFAULT NULL,
366  `is_deleted` enum('true','false') DEFAULT 'false',
367  PRIMARY KEY (`id`),
368  UNIQUE KEY `unique_field` (`academic_year_id`,`admission_type_id`,`major_id`,`subject_type`),
369  KEY `admission_subject_settings_academic_year_id__idx` (`academic_year_id`) USING BTREE,
370  KEY `admission_subject_settings_admission_type_id__idx` (`admission_type_id`) USING BTREE,
371  KEY `admission_subject_settings_major_id__idx` (`major_id`) USING BTREE
372) ENGINE=InnoDB DEFAULT CHARSET=utf8;
373/*!40101 SET character_set_client = @saved_cs_client */;
374
375--
376-- Dumping data for table `admission_subject_settings`
377--
378
379LOCK TABLES `admission_subject_settings` WRITE;
380/*!40000 ALTER TABLE `admission_subject_settings` DISABLE KEYS */;
381/*!40000 ALTER TABLE `admission_subject_settings` ENABLE KEYS */;
382UNLOCK TABLES;
383
384--
385-- Table structure for table `admission_types`
386--
387
388DROP TABLE IF EXISTS `admission_types`;
389/*!40101 SET @saved_cs_client     = @@character_set_client */;
390/*!40101 SET character_set_client = utf8 */;
391CREATE TABLE `admission_types` (
392  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
393  `admission_type` varchar(255) NOT NULL,
394  `created_at` timestamp DEFAULT NOW(),
395  `updated_at` timestamp NULL DEFAULT NULL,
396  `deleted_at` timestamp NULL DEFAULT NULL,
397  `restored_at` timestamp NULL DEFAULT NULL,
398  `created_by` bigint(20) DEFAULT NULL,
399  `updated_by` bigint(20) DEFAULT NULL,
400  `deleted_by` bigint(20) DEFAULT NULL,
401  `restored_by` bigint(20) DEFAULT NULL,
402  `is_deleted` enum('true','false') DEFAULT 'false',
403  PRIMARY KEY (`id`),
404  UNIQUE KEY `admission_type` (`admission_type`)
405) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
406/*!40101 SET character_set_client = @saved_cs_client */;
407
408--
409-- Dumping data for table `admission_types`
410--
411
412LOCK TABLES `admission_types` WRITE;
413/*!40000 ALTER TABLE `admission_types` DISABLE KEYS */;
414INSERT INTO `admission_types` VALUES (1,'Umum','2018-10-22 05:04:39',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(2,'Prestasi','2018-10-22 05:04:39',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(3,'SKHUN','2018-10-22 05:04:39',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false');
415/*!40000 ALTER TABLE `admission_types` ENABLE KEYS */;
416UNLOCK TABLES;
417
418--
419-- Table structure for table `albums`
420--
421
422DROP TABLE IF EXISTS `albums`;
423/*!40101 SET @saved_cs_client     = @@character_set_client */;
424/*!40101 SET character_set_client = utf8 */;
425CREATE TABLE `albums` (
426  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
427  `album_title` varchar(255) NOT NULL,
428  `album_description` varchar(255) DEFAULT NULL,
429  `album_slug` varchar(255) DEFAULT NULL,
430  `album_cover` varchar(100) DEFAULT NULL,
431  `created_at` timestamp DEFAULT NOW(),
432  `updated_at` timestamp NULL DEFAULT NULL,
433  `deleted_at` timestamp NULL DEFAULT NULL,
434  `restored_at` timestamp NULL DEFAULT NULL,
435  `created_by` bigint(20) DEFAULT NULL,
436  `updated_by` bigint(20) DEFAULT NULL,
437  `deleted_by` bigint(20) DEFAULT NULL,
438  `restored_by` bigint(20) DEFAULT NULL,
439  `is_deleted` enum('true','false') DEFAULT 'false',
440  PRIMARY KEY (`id`),
441  UNIQUE KEY `album_title` (`album_title`)
442) ENGINE=InnoDB DEFAULT CHARSET=utf8;
443/*!40101 SET character_set_client = @saved_cs_client */;
444
445--
446-- Dumping data for table `albums`
447--
448
449LOCK TABLES `albums` WRITE;
450/*!40000 ALTER TABLE `albums` DISABLE KEYS */;
451/*!40000 ALTER TABLE `albums` ENABLE KEYS */;
452UNLOCK TABLES;
453
454--
455-- Table structure for table `answers`
456--
457
458DROP TABLE IF EXISTS `answers`;
459/*!40101 SET @saved_cs_client     = @@character_set_client */;
460/*!40101 SET character_set_client = utf8 */;
461CREATE TABLE `answers` (
462  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
463  `question_id` bigint(20) NOT NULL DEFAULT '0',
464  `answer` varchar(255) DEFAULT NULL,
465  `created_at` timestamp DEFAULT NOW(),
466  `updated_at` timestamp NULL DEFAULT NULL,
467  `deleted_at` timestamp NULL DEFAULT NULL,
468  `restored_at` timestamp NULL DEFAULT NULL,
469  `created_by` bigint(20) DEFAULT NULL,
470  `updated_by` bigint(20) DEFAULT NULL,
471  `deleted_by` bigint(20) DEFAULT NULL,
472  `restored_by` bigint(20) DEFAULT NULL,
473  `is_deleted` enum('true','false') DEFAULT 'false',
474  PRIMARY KEY (`id`),
475  UNIQUE KEY `unique_field` (`question_id`,`answer`),
476  KEY `answers_question_id__idx` (`question_id`) USING BTREE
477) ENGINE=InnoDB DEFAULT CHARSET=utf8;
478/*!40101 SET character_set_client = @saved_cs_client */;
479
480--
481-- Dumping data for table `answers`
482--
483
484LOCK TABLES `answers` WRITE;
485/*!40000 ALTER TABLE `answers` DISABLE KEYS */;
486/*!40000 ALTER TABLE `answers` ENABLE KEYS */;
487UNLOCK TABLES;
488
489--
490-- Table structure for table `buildings`
491--
492
493DROP TABLE IF EXISTS `buildings`;
494/*!40101 SET @saved_cs_client     = @@character_set_client */;
495/*!40101 SET character_set_client = utf8 */;
496CREATE TABLE `buildings` (
497  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
498  `building_name` varchar(255) NOT NULL,
499  `created_at` timestamp DEFAULT NOW(),
500  `updated_at` timestamp NULL DEFAULT NULL,
501  `deleted_at` timestamp NULL DEFAULT NULL,
502  `restored_at` timestamp NULL DEFAULT NULL,
503  `created_by` bigint(20) DEFAULT NULL,
504  `updated_by` bigint(20) DEFAULT NULL,
505  `deleted_by` bigint(20) DEFAULT NULL,
506  `restored_by` bigint(20) DEFAULT NULL,
507  `is_deleted` enum('true','false') DEFAULT 'false',
508  PRIMARY KEY (`id`),
509  UNIQUE KEY `building_name` (`building_name`)
510) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
511/*!40101 SET character_set_client = @saved_cs_client */;
512
513--
514-- Dumping data for table `buildings`
515--
516
517LOCK TABLES `buildings` WRITE;
518/*!40000 ALTER TABLE `buildings` DISABLE KEYS */;
519INSERT INTO `buildings` VALUES (1,'Gedung A','2018-10-22 05:04:38',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(2,'Gedung B','2018-10-22 05:04:38',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false');
520/*!40000 ALTER TABLE `buildings` ENABLE KEYS */;
521UNLOCK TABLES;
522
523--
524-- Table structure for table `categories`
525--
526
527DROP TABLE IF EXISTS `categories`;
528/*!40101 SET @saved_cs_client     = @@character_set_client */;
529/*!40101 SET character_set_client = utf8 */;
530CREATE TABLE `categories` (
531  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
532  `category_name` varchar(255) NOT NULL,
533  `category_slug` varchar(255) DEFAULT NULL,
534  `category_description` varchar(255) DEFAULT NULL,
535  `category_type` enum('post','file') DEFAULT 'post',
536  `created_at` timestamp DEFAULT NOW(),
537  `updated_at` timestamp NULL DEFAULT NULL,
538  `deleted_at` timestamp NULL DEFAULT NULL,
539  `restored_at` timestamp NULL DEFAULT NULL,
540  `created_by` bigint(20) DEFAULT NULL,
541  `updated_by` bigint(20) DEFAULT NULL,
542  `deleted_by` bigint(20) DEFAULT NULL,
543  `restored_by` bigint(20) DEFAULT NULL,
544  `is_deleted` enum('true','false') DEFAULT 'false',
545  PRIMARY KEY (`id`),
546  UNIQUE KEY `unique_field` (`category_name`,`category_type`)
547) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
548/*!40101 SET character_set_client = @saved_cs_client */;
549
550--
551-- Dumping data for table `categories`
552--
553
554LOCK TABLES `categories` WRITE;
555/*!40000 ALTER TABLE `categories` DISABLE KEYS */;
556INSERT INTO `categories` VALUES (1,'Uncategorized','uncategorized','Uncategorized','post','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(2,'Uncategorized','uncategorized','Uncategorized','file','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false');
557/*!40000 ALTER TABLE `categories` ENABLE KEYS */;
558UNLOCK TABLES;
559
560--
561-- Table structure for table `class_group_settings`
562--
563
564DROP TABLE IF EXISTS `class_group_settings`;
565/*!40101 SET @saved_cs_client     = @@character_set_client */;
566/*!40101 SET character_set_client = utf8 */;
567CREATE TABLE `class_group_settings` (
568  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
569  `academic_year_id` bigint(20) NOT NULL DEFAULT '0' COMMENT 'FK dari academic_years',
570  `class_group_id` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Kelas, FK dari class_groups',
571  `class_vice_id` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Wali Kelas, FK dari employees',
572  `created_at` timestamp DEFAULT NOW(),
573  `updated_at` timestamp NULL DEFAULT NULL,
574  `deleted_at` timestamp NULL DEFAULT NULL,
575  `restored_at` timestamp NULL DEFAULT NULL,
576  `created_by` bigint(20) DEFAULT NULL,
577  `updated_by` bigint(20) DEFAULT NULL,
578  `deleted_by` bigint(20) DEFAULT NULL,
579  `restored_by` bigint(20) DEFAULT NULL,
580  `is_deleted` enum('true','false') DEFAULT 'false',
581  PRIMARY KEY (`id`),
582  UNIQUE KEY `unique_field` (`academic_year_id`,`class_group_id`),
583  KEY `class_group_settings_academic_year_id__idx` (`academic_year_id`) USING BTREE,
584  KEY `class_group_settings_class_group_id__idx` (`class_group_id`) USING BTREE
585) ENGINE=InnoDB DEFAULT CHARSET=utf8;
586/*!40101 SET character_set_client = @saved_cs_client */;
587
588--
589-- Dumping data for table `class_group_settings`
590--
591
592LOCK TABLES `class_group_settings` WRITE;
593/*!40000 ALTER TABLE `class_group_settings` DISABLE KEYS */;
594/*!40000 ALTER TABLE `class_group_settings` ENABLE KEYS */;
595UNLOCK TABLES;
596
597--
598-- Table structure for table `class_group_students`
599--
600
601DROP TABLE IF EXISTS `class_group_students`;
602/*!40101 SET @saved_cs_client     = @@character_set_client */;
603/*!40101 SET character_set_client = utf8 */;
604CREATE TABLE `class_group_students` (
605  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
606  `class_group_setting_id` bigint(20) NOT NULL DEFAULT '0',
607  `student_id` bigint(20) NOT NULL DEFAULT '0',
608  `is_class_president` enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'Ketua Kelas ?',
609  `created_at` timestamp DEFAULT NOW(),
610  `updated_at` timestamp NULL DEFAULT NULL,
611  `deleted_at` timestamp NULL DEFAULT NULL,
612  `restored_at` timestamp NULL DEFAULT NULL,
613  `created_by` bigint(20) DEFAULT NULL,
614  `updated_by` bigint(20) DEFAULT NULL,
615  `deleted_by` bigint(20) DEFAULT NULL,
616  `restored_by` bigint(20) DEFAULT NULL,
617  `is_deleted` enum('true','false') DEFAULT 'false',
618  PRIMARY KEY (`id`),
619  UNIQUE KEY `unique_field` (`class_group_setting_id`,`student_id`),
620  KEY `class_group_students_class_group_setting_id__idx` (`class_group_setting_id`) USING BTREE,
621  KEY `class_group_students_student_id__idx` (`student_id`) USING BTREE
622) ENGINE=InnoDB DEFAULT CHARSET=utf8;
623/*!40101 SET character_set_client = @saved_cs_client */;
624
625--
626-- Dumping data for table `class_group_students`
627--
628
629LOCK TABLES `class_group_students` WRITE;
630/*!40000 ALTER TABLE `class_group_students` DISABLE KEYS */;
631/*!40000 ALTER TABLE `class_group_students` ENABLE KEYS */;
632UNLOCK TABLES;
633
634--
635-- Table structure for table `class_groups`
636--
637
638DROP TABLE IF EXISTS `class_groups`;
639/*!40101 SET @saved_cs_client     = @@character_set_client */;
640/*!40101 SET character_set_client = utf8 */;
641CREATE TABLE `class_groups` (
642  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
643  `class_group` varchar(100) DEFAULT NULL,
644  `sub_class_group` varchar(100) DEFAULT NULL,
645  `major_id` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Program Keahlian',
646  `created_at` timestamp DEFAULT NOW(),
647  `updated_at` timestamp NULL DEFAULT NULL,
648  `deleted_at` timestamp NULL DEFAULT NULL,
649  `restored_at` timestamp NULL DEFAULT NULL,
650  `created_by` bigint(20) DEFAULT NULL,
651  `updated_by` bigint(20) DEFAULT NULL,
652  `deleted_by` bigint(20) DEFAULT NULL,
653  `restored_by` bigint(20) DEFAULT NULL,
654  `is_deleted` enum('true','false') DEFAULT 'false',
655  PRIMARY KEY (`id`),
656  UNIQUE KEY `unique_field` (`class_group`,`sub_class_group`,`major_id`),
657  KEY `class_groups_major_id__idx` (`major_id`) USING BTREE
658) ENGINE=InnoDB DEFAULT CHARSET=utf8;
659/*!40101 SET character_set_client = @saved_cs_client */;
660
661--
662-- Dumping data for table `class_groups`
663--
664
665LOCK TABLES `class_groups` WRITE;
666/*!40000 ALTER TABLE `class_groups` DISABLE KEYS */;
667/*!40000 ALTER TABLE `class_groups` ENABLE KEYS */;
668UNLOCK TABLES;
669
670--
671-- Table structure for table `class_meetings`
672--
673
674DROP TABLE IF EXISTS `class_meetings`;
675/*!40101 SET @saved_cs_client     = @@character_set_client */;
676/*!40101 SET character_set_client = utf8 */;
677CREATE TABLE `class_meetings` (
678  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
679  `course_class_id` bigint(20) NOT NULL DEFAULT '0',
680  `date` date NOT NULL,
681  `start_time` time NOT NULL DEFAULT '00:00:00',
682  `end_time` time NOT NULL DEFAULT '00:00:00',
683  `discussion` varchar(255) DEFAULT NULL,
684  `created_at` timestamp DEFAULT NOW(),
685  `updated_at` timestamp NULL DEFAULT NULL,
686  `deleted_at` timestamp NULL DEFAULT NULL,
687  `restored_at` timestamp NULL DEFAULT NULL,
688  `created_by` bigint(20) DEFAULT NULL,
689  `updated_by` bigint(20) DEFAULT NULL,
690  `deleted_by` bigint(20) DEFAULT NULL,
691  `restored_by` bigint(20) DEFAULT NULL,
692  `is_deleted` enum('true','false') DEFAULT 'false',
693  PRIMARY KEY (`id`),
694  KEY `class_meetings_course_class_id__idx` (`course_class_id`) USING BTREE
695) ENGINE=InnoDB DEFAULT CHARSET=utf8;
696/*!40101 SET character_set_client = @saved_cs_client */;
697
698--
699-- Dumping data for table `class_meetings`
700--
701
702LOCK TABLES `class_meetings` WRITE;
703/*!40000 ALTER TABLE `class_meetings` DISABLE KEYS */;
704/*!40000 ALTER TABLE `class_meetings` ENABLE KEYS */;
705UNLOCK TABLES;
706
707--
708-- Table structure for table `comments`
709--
710
711DROP TABLE IF EXISTS `comments`;
712/*!40101 SET @saved_cs_client     = @@character_set_client */;
713/*!40101 SET character_set_client = utf8 */;
714CREATE TABLE `comments` (
715  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
716  `comment_post_id` bigint(20) DEFAULT NULL,
717  `comment_author` varchar(255) NOT NULL,
718  `comment_email` varchar(255) DEFAULT NULL,
719  `comment_url` varchar(255) DEFAULT NULL,
720  `comment_ip_address` varchar(255) NOT NULL,
721  `comment_content` text NOT NULL,
722  `comment_subject` varchar(255) DEFAULT NULL,
723  `comment_reply` text,
724  `comment_status` enum('approved','unapproved','spam') DEFAULT 'approved',
725  `comment_agent` varchar(255) DEFAULT NULL,
726  `comment_parent_id` varchar(255) DEFAULT NULL,
727  `comment_type` enum('post','message') DEFAULT 'post',
728  `created_at` timestamp DEFAULT NOW(),
729  `updated_at` timestamp NULL DEFAULT NULL,
730  `deleted_at` timestamp NULL DEFAULT NULL,
731  `restored_at` timestamp NULL DEFAULT NULL,
732  `created_by` bigint(20) DEFAULT NULL,
733  `updated_by` bigint(20) DEFAULT NULL,
734  `deleted_by` bigint(20) DEFAULT NULL,
735  `restored_by` bigint(20) DEFAULT NULL,
736  `is_deleted` enum('true','false') DEFAULT 'false',
737  PRIMARY KEY (`id`),
738  KEY `comments_comment_post_id__idx` (`comment_post_id`) USING BTREE
739) ENGINE=InnoDB DEFAULT CHARSET=utf8;
740/*!40101 SET character_set_client = @saved_cs_client */;
741
742--
743-- Dumping data for table `comments`
744--
745
746LOCK TABLES `comments` WRITE;
747/*!40000 ALTER TABLE `comments` DISABLE KEYS */;
748/*!40000 ALTER TABLE `comments` ENABLE KEYS */;
749UNLOCK TABLES;
750
751--
752-- Table structure for table `course_classes`
753--
754
755DROP TABLE IF EXISTS `course_classes`;
756/*!40101 SET @saved_cs_client     = @@character_set_client */;
757/*!40101 SET character_set_client = utf8 */;
758CREATE TABLE `course_classes` (
759  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
760  `academic_year_id` bigint(20) NOT NULL DEFAULT '0',
761  `semester` enum('odd','even') NOT NULL DEFAULT 'odd' COMMENT 'odd = Ganjil, even = Genap',
762  `class_group_id` bigint(20) NOT NULL DEFAULT '0',
763  `subject_id` bigint(20) NOT NULL DEFAULT '0',
764  `employee_id` bigint(20) NOT NULL DEFAULT '0',
765  `created_at` timestamp DEFAULT NOW(),
766  `updated_at` timestamp NULL DEFAULT NULL,
767  `deleted_at` timestamp NULL DEFAULT NULL,
768  `restored_at` timestamp NULL DEFAULT NULL,
769  `created_by` bigint(20) DEFAULT NULL,
770  `updated_by` bigint(20) DEFAULT NULL,
771  `deleted_by` bigint(20) DEFAULT NULL,
772  `restored_by` bigint(20) DEFAULT NULL,
773  `is_deleted` enum('true','false') DEFAULT 'false',
774  PRIMARY KEY (`id`),
775  UNIQUE KEY `unique_field` (`academic_year_id`,`semester`,`class_group_id`,`subject_id`),
776  KEY `course_classes_academic_year_id__idx` (`academic_year_id`) USING BTREE,
777  KEY `course_classes_class_group_id__idx` (`class_group_id`) USING BTREE,
778  KEY `course_classes_subject_id__idx` (`subject_id`) USING BTREE,
779  KEY `course_classes_employee_id__idx` (`employee_id`) USING BTREE
780) ENGINE=InnoDB DEFAULT CHARSET=utf8;
781/*!40101 SET character_set_client = @saved_cs_client */;
782
783--
784-- Dumping data for table `course_classes`
785--
786
787LOCK TABLES `course_classes` WRITE;
788/*!40000 ALTER TABLE `course_classes` DISABLE KEYS */;
789/*!40000 ALTER TABLE `course_classes` ENABLE KEYS */;
790UNLOCK TABLES;
791
792--
793-- Table structure for table `employees`
794--
795
796DROP TABLE IF EXISTS `employees`;
797/*!40101 SET @saved_cs_client     = @@character_set_client */;
798/*!40101 SET character_set_client = utf8 */;
799CREATE TABLE `employees` (
800  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
801  `assignment_letter_number` varchar(255) DEFAULT NULL COMMENT 'Nomor Surat Tugas',
802  `assignment_letter_date` date DEFAULT NULL COMMENT 'Tanggal Surat Tugas',
803  `assignment_start_date` date DEFAULT NULL COMMENT 'TMT Tugas',
804  `parent_school_status` enum('true','false') NOT NULL DEFAULT 'true' COMMENT 'Status Sekolah Induk',
805  `full_name` varchar(150) NOT NULL,
806  `gender` enum('M','F') NOT NULL DEFAULT 'M',
807  `nik` varchar(50) DEFAULT NULL,
808  `birth_place` varchar(255) DEFAULT NULL,
809  `birth_date` date DEFAULT NULL,
810  `mother_name` varchar(150) DEFAULT NULL,
811  `street_address` varchar(255) DEFAULT NULL COMMENT 'Alamat Jalan',
812  `rt` varchar(10) DEFAULT NULL COMMENT 'Rukun Tetangga',
813  `rw` varchar(10) DEFAULT NULL COMMENT 'Rukun Warga',
814  `sub_village` varchar(255) DEFAULT NULL COMMENT 'Nama Dusun',
815  `village` varchar(255) DEFAULT NULL COMMENT 'Nama Kelurahan/ Desa',
816  `sub_district` varchar(255) DEFAULT NULL COMMENT 'Kecamatan',
817  `district` varchar(255) DEFAULT NULL COMMENT 'Kabupaten',
818  `postal_code` varchar(20) DEFAULT NULL COMMENT 'Kode POS',
819  `religion_id` bigint(20) NOT NULL DEFAULT '0',
820  `marriage_status_id` bigint(20) NOT NULL DEFAULT '0',
821  `spouse_name` varchar(255) DEFAULT NULL COMMENT 'Nama Pasangan : Suami / Istri',
822  `spouse_employment_id` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Pekerjaan Pasangan : Suami / Istri',
823  `citizenship` enum('WNI','WNA') NOT NULL DEFAULT 'WNI' COMMENT 'Kewarganegaraan',
824  `country` varchar(255) DEFAULT NULL,
825  `npwp` varchar(100) DEFAULT NULL,
826  `employment_status_id` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Status Kepegawaian',
827  `nip` varchar(100) DEFAULT NULL,
828  `niy` varchar(100) DEFAULT NULL COMMENT 'NIY/NIGK',
829  `nuptk` varchar(100) DEFAULT NULL,
830  `employment_type_id` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Jenis Guru dan Tenaga Kependidikan (GTK)',
831  `decree_appointment` varchar(255) DEFAULT NULL COMMENT 'SK Pengangkatan',
832  `appointment_start_date` date DEFAULT NULL COMMENT 'TMT Pengangkatan',
833  `institution_lifter_id` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Lembaga Pengangkat',
834  `decree_cpns` varchar(100) DEFAULT NULL COMMENT 'SK CPNS',
835  `pns_start_date` date DEFAULT NULL COMMENT 'TMT CPNS',
836  `rank_id` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Pangkat / Golongan',
837  `salary_source_id` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Sumber Gaji',
838  `headmaster_license` enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'Punya Lisensi Kepala Sekolah ?',
839  `laboratory_skill_id` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Keahlian Lab oratorium',
840  `special_need_id` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Mampu Menangani Kebutuhan Khusus',
841  `braille_skills` enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'Keahlian Braile ?',
842  `sign_language_skills` enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'Keahlian Bahasa Isyarat ?',
843  `phone` varchar(255) DEFAULT NULL,
844  `mobile_phone` varchar(255) DEFAULT NULL,
845  `email` varchar(255) DEFAULT NULL,
846  `photo` varchar(100) DEFAULT NULL,
847  `created_at` timestamp DEFAULT NOW(),
848  `updated_at` timestamp NULL DEFAULT NULL,
849  `deleted_at` timestamp NULL DEFAULT NULL,
850  `restored_at` timestamp NULL DEFAULT NULL,
851  `created_by` bigint(20) DEFAULT NULL,
852  `updated_by` bigint(20) DEFAULT NULL,
853  `deleted_by` bigint(20) DEFAULT NULL,
854  `restored_by` bigint(20) DEFAULT NULL,
855  `is_deleted` enum('true','false') DEFAULT 'false',
856  PRIMARY KEY (`id`),
857  UNIQUE KEY `nik` (`nik`),
858  UNIQUE KEY `email` (`email`),
859  KEY `employees_nik__idx` (`nik`) USING BTREE,
860  KEY `employees_full_name__idx` (`full_name`) USING BTREE,
861  KEY `employees_email__idx` (`email`) USING BTREE,
862  KEY `employees_religion_id__idx` (`religion_id`) USING BTREE,
863  KEY `employees_marriage_status_id__idx` (`marriage_status_id`) USING BTREE,
864  KEY `employees_spouse_employment_id__idx` (`spouse_employment_id`) USING BTREE,
865  KEY `employees_employment_status_id__idx` (`employment_status_id`) USING BTREE,
866  KEY `employees_employment_type_id__idx` (`employment_type_id`) USING BTREE,
867  KEY `employees_institution_lifter_id__idx` (`institution_lifter_id`) USING BTREE,
868  KEY `employees_rank_id__idx` (`rank_id`) USING BTREE,
869  KEY `employees_salary_source_id__idx` (`salary_source_id`) USING BTREE,
870  KEY `employees_laboratory_skill_id__idx` (`laboratory_skill_id`) USING BTREE,
871  KEY `employees_special_need_id__idx` (`special_need_id`) USING BTREE
872) ENGINE=InnoDB DEFAULT CHARSET=utf8;
873/*!40101 SET character_set_client = @saved_cs_client */;
874
875--
876-- Dumping data for table `employees`
877--
878
879LOCK TABLES `employees` WRITE;
880/*!40000 ALTER TABLE `employees` DISABLE KEYS */;
881/*!40000 ALTER TABLE `employees` ENABLE KEYS */;
882UNLOCK TABLES;
883
884--
885-- Table structure for table `field_settings`
886--
887
888DROP TABLE IF EXISTS `field_settings`;
889/*!40101 SET @saved_cs_client     = @@character_set_client */;
890/*!40101 SET character_set_client = utf8 */;
891CREATE TABLE `field_settings` (
892  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
893  `module_name` varchar(100) NOT NULL,
894  `field_name` varchar(100) DEFAULT NULL,
895  `field_description` varchar(255) DEFAULT NULL,
896  `field_setting` text,
897  `created_at` timestamp DEFAULT NOW(),
898  `updated_at` timestamp NULL DEFAULT NULL,
899  `deleted_at` timestamp NULL DEFAULT NULL,
900  `restored_at` timestamp NULL DEFAULT NULL,
901  `created_by` bigint(20) DEFAULT NULL,
902  `updated_by` bigint(20) DEFAULT NULL,
903  `deleted_by` bigint(20) DEFAULT NULL,
904  `restored_by` bigint(20) DEFAULT NULL,
905  `is_deleted` enum('true','false') DEFAULT 'false',
906  PRIMARY KEY (`id`),
907  UNIQUE KEY `unique_field` (`module_name`,`field_name`)
908) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8;
909/*!40101 SET character_set_client = @saved_cs_client */;
910
911--
912-- Dumping data for table `field_settings`
913--
914
915LOCK TABLES `field_settings` WRITE;
916/*!40000 ALTER TABLE `field_settings` DISABLE KEYS */;
917INSERT INTO `field_settings` VALUES (1,'admission','admission_type_id','Jalur Pendaftaran','{\"admission\":\"true\", \"admission_required\":\"true\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(2,'admission','first_choice_id','Pilihan I','{\"admission\":\"true\", \"admission_required\":\"true\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(3,'admission','second_choice_id','Pilihan II','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(4,'admission','photo','Photo','{\"admission\":\"true\", \"admission_required\":\"true\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(5,'admission','achievement','Prestasi yang Pernah Diraih','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(6,'admission','is_transfer','Jenis Pendaftaran','{\"admission\":\"true\", \"admission_required\":\"true\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(7,'admission','nisn','Nomor Induk Siswa Nasional','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(8,'admission','nik','Nomor Induk Kependudukan / KTP','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(9,'admission','prev_exam_number','Nomor Ujian Nasional Sebelumnya','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(10,'admission','paud','Apakah pernah PAUD','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(11,'admission','tk','Apakah Pernah TK','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(12,'admission','skhun','Nomor Seri SKHUN','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(13,'admission','prev_school_name','Nama Sekolah Sebelumnya','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(14,'admission','prev_school_address','Alamat Sekolah Sebelumnya','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(15,'admission','prev_diploma_number','Nomor Seri Ijazah Sebelumnya','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(16,'admission','hobby','Hobi','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(17,'admission','ambition','Cita-cita','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(18,'admission','full_name','Nama Lengkap','{\"admission\":\"true\", \"admission_required\":\"true\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(19,'admission','gender','Jenis Kelamin','{\"admission\":\"true\", \"admission_required\":\"true\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(20,'admission','birth_date','Tanggal Lahir','{\"admission\":\"true\", \"admission_required\":\"true\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(21,'admission','birth_place','Tempat Lahir','{\"admission\":\"true\", \"admission_required\":\"true\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(22,'admission','religion_id','Agama','{\"admission\":\"true\", \"admission_required\":\"true\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(23,'admission','special_need_id','Kebutuhan Khusus','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(24,'admission','street_address','Alamat Jalan','{\"admission\":\"true\", \"admission_required\":\"true\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(25,'admission','rt','RT','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(26,'admission','rw','RW','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(27,'admission','sub_village','Nama Dusun','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(28,'admission','village','Nama Kelurahan/ Desa','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(29,'admission','sub_district','Kecamatan','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(30,'admission','district','Kabupaten','{\"admission\":\"true\", \"admission_required\":\"true\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(31,'admission','postal_code','Kode POS','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(32,'admission','residence_id','Tempat Tinggal','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(33,'admission','transportation_id','Moda Transportasi','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(34,'admission','phone','Telepon','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(35,'admission','mobile_phone','Handphone','{\"admission\":\"true\", \"admission_required\":\"true\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(36,'admission','email','Email','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(37,'admission','kis','Kartu Indonesia Sehat (KIS)','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(38,'admission','kip','Kartu Indonesia Pintar (KIP)','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(39,'admission','kps','Kartu Pra Sejahtera (KPS)','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(40,'admission','sktm','Surat Keterangan Tidak Mampu (SKTM)','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(41,'admission','kks','Kartu Keluarga Sejahtera (KKS)','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(42,'admission','citizenship','Kewarganegaraan','{\"admission\":\"true\", \"admission_required\":\"true\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(43,'admission','country','Nama Negara','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(44,'admission','father_name','Nama Ayah','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(45,'admission','father_birth_year','Tahun Lahir Ayah','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(46,'admission','father_education_id','Pendidikan Terakhir Ayah','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(47,'admission','father_employment_id','Pekerjaan Ayah','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(48,'admission','father_monthly_income_id','Penghasilan Bulanan Ayah','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(49,'admission','father_special_need_id','Kebutuhan Khusus Ayah','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(50,'admission','mother_name','Nama Ibu','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(51,'admission','mother_birth_year','Tahun Lahir Ibu','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(52,'admission','mother_education_id','Pendidikan Terakhir Ibu','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(53,'admission','mother_employment_id','Pekerjaan Ibu','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(54,'admission','mother_monthly_income_id','Penghasilan Bulanan Ibu','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(55,'admission','mother_special_need_id','Kebutuhan Khusus Ibu','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(56,'admission','guardian_name','Nama Wali','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(57,'admission','guardian_birth_year','Tahun Lahir Wali','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(58,'admission','guardian_education_id','Pendidikan Terakhir Wali','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(59,'admission','guardian_employment_id','Pekerjaan Wali','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(60,'admission','guardian_monthly_income_id','Penghasilan Bulanan Wali','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(61,'admission','mileage','Jarak Tempat Tinggal ke Sekolah','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(62,'admission','traveling_time','Waktu Tempuh ke Sekolah','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(63,'admission','height','Tinggi Badan','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(64,'admission','weight','Berat Badan','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(65,'admission','sibling_number','Jumlah Saudara Kandung','{\"admission\":\"false\", \"admission_required\":\"false\"}','2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false');
918/*!40000 ALTER TABLE `field_settings` ENABLE KEYS */;
919UNLOCK TABLES;
920
921--
922-- Table structure for table `files`
923--
924
925DROP TABLE IF EXISTS `files`;
926/*!40101 SET @saved_cs_client     = @@character_set_client */;
927/*!40101 SET character_set_client = utf8 */;
928CREATE TABLE `files` (
929  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
930  `file_title` varchar(255) DEFAULT NULL,
931  `file_description` varchar(255) DEFAULT NULL,
932  `file_name` varchar(255) DEFAULT NULL,
933  `file_type` varchar(255) DEFAULT NULL,
934  `file_category_id` bigint(20) NOT NULL DEFAULT '0',
935  `file_path` varchar(255) DEFAULT NULL,
936  `file_ext` varchar(255) DEFAULT NULL,
937  `file_size` varchar(255) DEFAULT NULL,
938  `file_visibility` enum('public','private') DEFAULT 'public',
939  `file_counter` bigint(20) NOT NULL DEFAULT '0',
940  `created_at` timestamp DEFAULT NOW(),
941  `updated_at` timestamp NULL DEFAULT NULL,
942  `deleted_at` timestamp NULL DEFAULT NULL,
943  `restored_at` timestamp NULL DEFAULT NULL,
944  `created_by` bigint(20) DEFAULT NULL,
945  `updated_by` bigint(20) DEFAULT NULL,
946  `deleted_by` bigint(20) DEFAULT NULL,
947  `restored_by` bigint(20) DEFAULT NULL,
948  `is_deleted` enum('true','false') DEFAULT 'false',
949  PRIMARY KEY (`id`),
950  KEY `files_file_category_id__idx` (`file_category_id`) USING BTREE
951) ENGINE=InnoDB DEFAULT CHARSET=utf8;
952/*!40101 SET character_set_client = @saved_cs_client */;
953
954--
955-- Dumping data for table `files`
956--
957
958LOCK TABLES `files` WRITE;
959/*!40000 ALTER TABLE `files` DISABLE KEYS */;
960/*!40000 ALTER TABLE `files` ENABLE KEYS */;
961UNLOCK TABLES;
962
963--
964-- Table structure for table `image_sliders`
965--
966
967DROP TABLE IF EXISTS `image_sliders`;
968/*!40101 SET @saved_cs_client     = @@character_set_client */;
969/*!40101 SET character_set_client = utf8 */;
970CREATE TABLE `image_sliders` (
971  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
972  `caption` varchar(255) NOT NULL,
973  `image` varchar(255) DEFAULT NULL,
974  `created_at` timestamp DEFAULT NOW(),
975  `updated_at` timestamp NULL DEFAULT NULL,
976  `deleted_at` timestamp NULL DEFAULT NULL,
977  `restored_at` timestamp NULL DEFAULT NULL,
978  `created_by` bigint(20) DEFAULT NULL,
979  `updated_by` bigint(20) DEFAULT NULL,
980  `deleted_by` bigint(20) DEFAULT NULL,
981  `restored_by` bigint(20) DEFAULT NULL,
982  `is_deleted` enum('true','false') DEFAULT 'false',
983  PRIMARY KEY (`id`)
984) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
985/*!40101 SET character_set_client = @saved_cs_client */;
986
987--
988-- Dumping data for table `image_sliders`
989--
990
991LOCK TABLES `image_sliders` WRITE;
992/*!40000 ALTER TABLE `image_sliders` DISABLE KEYS */;
993INSERT INTO `image_sliders` VALUES (1,'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua','1.png','2018-10-22 05:04:41',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(2,'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua','2.png','2018-10-22 05:04:41',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false');
994/*!40000 ALTER TABLE `image_sliders` ENABLE KEYS */;
995UNLOCK TABLES;
996
997--
998-- Table structure for table `links`
999--
1000
1001DROP TABLE IF EXISTS `links`;
1002/*!40101 SET @saved_cs_client     = @@character_set_client */;
1003/*!40101 SET character_set_client = utf8 */;
1004CREATE TABLE `links` (
1005  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1006  `link_title` varchar(255) NOT NULL,
1007  `link_url` varchar(255) DEFAULT NULL,
1008  `link_target` enum('_blank','_self','_parent','_top') DEFAULT '_blank',
1009  `link_image` varchar(100) DEFAULT NULL,
1010  `link_type` enum('link','banner') DEFAULT 'link',
1011  `created_at` timestamp DEFAULT NOW(),
1012  `updated_at` timestamp NULL DEFAULT NULL,
1013  `deleted_at` timestamp NULL DEFAULT NULL,
1014  `restored_at` timestamp NULL DEFAULT NULL,
1015  `created_by` bigint(20) DEFAULT NULL,
1016  `updated_by` bigint(20) DEFAULT NULL,
1017  `deleted_by` bigint(20) DEFAULT NULL,
1018  `restored_by` bigint(20) DEFAULT NULL,
1019  `is_deleted` enum('true','false') DEFAULT 'false',
1020  PRIMARY KEY (`id`),
1021  UNIQUE KEY `unique_field` (`link_url`,`link_type`)
1022) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
1023/*!40101 SET character_set_client = @saved_cs_client */;
1024
1025--
1026-- Dumping data for table `links`
1027--
1028
1029LOCK TABLES `links` WRITE;
1030/*!40000 ALTER TABLE `links` DISABLE KEYS */;
1031INSERT INTO `links` VALUES (1,'CMS Sekolahku','http://sekolahku.web.id','_blank',NULL,'link','2018-10-22 05:04:41',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(2,'CMS Sekolahku','http://sekolahku.web.id','_blank','1.png','banner','2018-10-22 05:04:41',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false');
1032/*!40000 ALTER TABLE `links` ENABLE KEYS */;
1033UNLOCK TABLES;
1034
1035--
1036-- Table structure for table `login_attempts`
1037--
1038
1039DROP TABLE IF EXISTS `login_attempts`;
1040/*!40101 SET @saved_cs_client     = @@character_set_client */;
1041/*!40101 SET character_set_client = utf8 */;
1042CREATE TABLE `login_attempts` (
1043  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1044  `ip_address` varchar(45) NOT NULL,
1045  `counter` int(11) unsigned NOT NULL DEFAULT '1',
1046  `created_at` timestamp DEFAULT NOW(),
1047  `updated_at` timestamp NULL DEFAULT NULL,
1048  `deleted_at` timestamp NULL DEFAULT NULL,
1049  `restored_at` timestamp NULL DEFAULT NULL,
1050  `created_by` bigint(20) DEFAULT NULL,
1051  `updated_by` bigint(20) DEFAULT NULL,
1052  `deleted_by` bigint(20) DEFAULT NULL,
1053  `restored_by` bigint(20) DEFAULT NULL,
1054  `is_deleted` enum('true','false') DEFAULT 'false',
1055  PRIMARY KEY (`id`)
1056) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1057/*!40101 SET character_set_client = @saved_cs_client */;
1058
1059--
1060-- Dumping data for table `login_attempts`
1061--
1062
1063LOCK TABLES `login_attempts` WRITE;
1064/*!40000 ALTER TABLE `login_attempts` DISABLE KEYS */;
1065/*!40000 ALTER TABLE `login_attempts` ENABLE KEYS */;
1066UNLOCK TABLES;
1067
1068--
1069-- Table structure for table `majors`
1070--
1071
1072DROP TABLE IF EXISTS `majors`;
1073/*!40101 SET @saved_cs_client     = @@character_set_client */;
1074/*!40101 SET character_set_client = utf8 */;
1075CREATE TABLE `majors` (
1076  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1077  `major_name` varchar(255) DEFAULT NULL COMMENT 'Program Keahlian / Jurusan',
1078  `major_short_name` varchar(255) DEFAULT NULL COMMENT 'Nama Singkat',
1079  `is_active` enum('true','false') DEFAULT 'true',
1080  `created_at` timestamp DEFAULT NOW(),
1081  `updated_at` timestamp NULL DEFAULT NULL,
1082  `deleted_at` timestamp NULL DEFAULT NULL,
1083  `restored_at` timestamp NULL DEFAULT NULL,
1084  `created_by` bigint(20) DEFAULT NULL,
1085  `updated_by` bigint(20) DEFAULT NULL,
1086  `deleted_by` bigint(20) DEFAULT NULL,
1087  `restored_by` bigint(20) DEFAULT NULL,
1088  `is_deleted` enum('true','false') DEFAULT 'false',
1089  PRIMARY KEY (`id`),
1090  UNIQUE KEY `major_name` (`major_name`)
1091) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
1092/*!40101 SET character_set_client = @saved_cs_client */;
1093
1094--
1095-- Dumping data for table `majors`
1096--
1097
1098LOCK TABLES `majors` WRITE;
1099/*!40000 ALTER TABLE `majors` DISABLE KEYS */;
1100INSERT INTO `majors` VALUES (1,'Teknik Komputer dan Jaringan','TKJ','true','2018-10-22 05:04:38',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(2,'Teknik Kendaraan Ringan','TKR','true','2018-10-22 05:04:38',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(3,'Komputerisasi Akuntansi','KA','true','2018-10-22 05:04:38',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false');
1101/*!40000 ALTER TABLE `majors` ENABLE KEYS */;
1102UNLOCK TABLES;
1103
1104--
1105-- Table structure for table `meeting_attendences`
1106--
1107
1108DROP TABLE IF EXISTS `meeting_attendences`;
1109/*!40101 SET @saved_cs_client     = @@character_set_client */;
1110/*!40101 SET character_set_client = utf8 */;
1111CREATE TABLE `meeting_attendences` (
1112  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1113  `class_meeting_id` bigint(20) NOT NULL DEFAULT '0',
1114  `student_id` bigint(20) NOT NULL DEFAULT '0',
1115  `presence` enum('present','sick','absent','permit') DEFAULT 'present',
1116  `note` varchar(255) DEFAULT NULL,
1117  `created_at` timestamp DEFAULT NOW(),
1118  `updated_at` timestamp NULL DEFAULT NULL,
1119  `deleted_at` timestamp NULL DEFAULT NULL,
1120  `restored_at` timestamp NULL DEFAULT NULL,
1121  `created_by` bigint(20) DEFAULT NULL,
1122  `updated_by` bigint(20) DEFAULT NULL,
1123  `deleted_by` bigint(20) DEFAULT NULL,
1124  `restored_by` bigint(20) DEFAULT NULL,
1125  `is_deleted` enum('true','false') DEFAULT 'false',
1126  PRIMARY KEY (`id`),
1127  UNIQUE KEY `unique_field` (`class_meeting_id`,`student_id`),
1128  KEY `meeting_attendences_class_meeting_id__idx` (`class_meeting_id`) USING BTREE,
1129  KEY `meeting_attendences_student_id__idx` (`student_id`) USING BTREE
1130) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1131/*!40101 SET character_set_client = @saved_cs_client */;
1132
1133--
1134-- Dumping data for table `meeting_attendences`
1135--
1136
1137LOCK TABLES `meeting_attendences` WRITE;
1138/*!40000 ALTER TABLE `meeting_attendences` DISABLE KEYS */;
1139/*!40000 ALTER TABLE `meeting_attendences` ENABLE KEYS */;
1140UNLOCK TABLES;
1141
1142--
1143-- Table structure for table `menus`
1144--
1145
1146DROP TABLE IF EXISTS `menus`;
1147/*!40101 SET @saved_cs_client     = @@character_set_client */;
1148/*!40101 SET character_set_client = utf8 */;
1149CREATE TABLE `menus` (
1150  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1151  `menu_title` varchar(150) NOT NULL,
1152  `menu_url` varchar(150) NOT NULL,
1153  `menu_target` enum('_blank','_self','_parent','_top') DEFAULT '_self',
1154  `menu_type` varchar(100) NOT NULL DEFAULT 'pages',
1155  `menu_parent_id` bigint(20) NOT NULL DEFAULT '0',
1156  `menu_position` bigint(20) NOT NULL DEFAULT '0',
1157  `created_at` timestamp DEFAULT NOW(),
1158  `updated_at` timestamp NULL DEFAULT NULL,
1159  `deleted_at` timestamp NULL DEFAULT NULL,
1160  `restored_at` timestamp NULL DEFAULT NULL,
1161  `created_by` bigint(20) DEFAULT NULL,
1162  `updated_by` bigint(20) DEFAULT NULL,
1163  `deleted_by` bigint(20) DEFAULT NULL,
1164  `restored_by` bigint(20) DEFAULT NULL,
1165  `is_deleted` enum('true','false') DEFAULT 'false',
1166  PRIMARY KEY (`id`)
1167) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
1168/*!40101 SET character_set_client = @saved_cs_client */;
1169
1170--
1171-- Dumping data for table `menus`
1172--
1173
1174LOCK TABLES `menus` WRITE;
1175/*!40000 ALTER TABLE `menus` DISABLE KEYS */;
1176INSERT INTO `menus` VALUES (1,'Hubungi Kami','hubungi-kami','_self','module',0,4,'2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(2,'Gallery Photo','gallery-photo','_self','module',9,1,'2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(3,'Gallery Video','gallery-video','_self','module',9,2,'2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(4,'Formulir PPDB','formulir-penerimaan-peserta-didik-baru','_self','module',8,1,'2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(5,'Hasil Seleksi','hasil-seleksi-penerimaan-peserta-didik-baru','_self','module',8,2,'2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(6,'Cetak Formulir','cetak-formulir-penerimaan-peserta-didik-baru','_self','module',8,3,'2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(7,'Download Formulir','download-formulir-penerimaan-peserta-didik-baru','_self','module',8,4,'2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(8,'PPDB 2018','#','_self','link',0,2,'2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(9,'Gallery','#','_self','link',0,3,'2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(10,'Kategori','#','_self','link',0,1,'2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(11,'Uncategorized','category/uncategorized','_self','post_category',10,1,'2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false');
1177/*!40000 ALTER TABLE `menus` ENABLE KEYS */;
1178UNLOCK TABLES;
1179
1180--
1181-- Table structure for table `modules`
1182--
1183
1184DROP TABLE IF EXISTS `modules`;
1185/*!40101 SET @saved_cs_client     = @@character_set_client */;
1186/*!40101 SET character_set_client = utf8 */;
1187CREATE TABLE `modules` (
1188  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1189  `module_name` varchar(255) NOT NULL,
1190  `module_description` varchar(255) DEFAULT NULL,
1191  `module_url` varchar(255) DEFAULT NULL,
1192  `created_at` timestamp DEFAULT NOW(),
1193  `updated_at` timestamp NULL DEFAULT NULL,
1194  `deleted_at` timestamp NULL DEFAULT NULL,
1195  `restored_at` timestamp NULL DEFAULT NULL,
1196  `created_by` bigint(20) DEFAULT NULL,
1197  `updated_by` bigint(20) DEFAULT NULL,
1198  `deleted_by` bigint(20) DEFAULT NULL,
1199  `restored_by` bigint(20) DEFAULT NULL,
1200  `is_deleted` enum('true','false') DEFAULT 'false',
1201  PRIMARY KEY (`id`),
1202  UNIQUE KEY `module_name` (`module_name`)
1203) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
1204/*!40101 SET character_set_client = @saved_cs_client */;
1205
1206--
1207-- Dumping data for table `modules`
1208--
1209
1210LOCK TABLES `modules` WRITE;
1211/*!40000 ALTER TABLE `modules` DISABLE KEYS */;
1212INSERT INTO `modules` VALUES (1,'Pengguna','Pengguna','acl','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(2,'Akademik','Akademik','academic','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(3,'PPDB / PMB','PPDB / PMB','admission','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(4,'Tampilan','Tampilan','appearance','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(5,'Blog','Blog','blog','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(6,'GTK / Staff / Dosen','GTK / Staff / Dosen','employees','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(7,'Media','Media','media','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(8,'Plugins','Plugins','plugins','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(9,'Data Induk','Data Induk','reference','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(10,'Pengaturan','Pengaturan','settings','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false');
1213/*!40000 ALTER TABLE `modules` ENABLE KEYS */;
1214UNLOCK TABLES;
1215
1216--
1217-- Table structure for table `options`
1218--
1219
1220DROP TABLE IF EXISTS `options`;
1221/*!40101 SET @saved_cs_client     = @@character_set_client */;
1222/*!40101 SET character_set_client = utf8 */;
1223CREATE TABLE `options` (
1224  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1225  `option_group` varchar(100) NOT NULL,
1226  `option_name` varchar(255) DEFAULT NULL,
1227  `created_at` timestamp DEFAULT NOW(),
1228  `updated_at` timestamp NULL DEFAULT NULL,
1229  `deleted_at` timestamp NULL DEFAULT NULL,
1230  `restored_at` timestamp NULL DEFAULT NULL,
1231  `created_by` bigint(20) DEFAULT NULL,
1232  `updated_by` bigint(20) DEFAULT NULL,
1233  `deleted_by` bigint(20) DEFAULT NULL,
1234  `restored_by` bigint(20) DEFAULT NULL,
1235  `is_deleted` enum('true','false') DEFAULT 'false',
1236  PRIMARY KEY (`id`),
1237  UNIQUE KEY `unique_field` (`option_group`,`option_name`),
1238  KEY `options_option_group__idx` (`option_group`) USING BTREE
1239) ENGINE=InnoDB AUTO_INCREMENT=170 DEFAULT CHARSET=utf8;
1240/*!40101 SET character_set_client = @saved_cs_client */;
1241
1242--
1243-- Dumping data for table `options`
1244--
1245
1246LOCK TABLES `options` WRITE;
1247/*!40000 ALTER TABLE `options` DISABLE KEYS */;
1248INSERT INTO `options` VALUES (1,'student_status','Aktif','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(2,'student_status','Lulus','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(3,'student_status','Mutasi','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(4,'student_status','Dikeluarkan','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(5,'student_status','Mengundurkan Diri','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(6,'student_status','Putus Sekolah','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(7,'student_status','Meninggal','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(8,'student_status','Hilang','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(9,'student_status','Lainnya','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(10,'employments','Tidak bekerja','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(11,'employments','Nelayan','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(12,'employments','Petani','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(13,'employments','Peternak','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(14,'employments','PNS/TNI/POLRI','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(15,'employments','Karyawan Swasta','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(16,'employments','Pedagang Kecil','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(17,'employments','Pedagang Besar','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(18,'employments','Wiraswasta','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(19,'employments','Wirausaha','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(20,'employments','Buruh','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(21,'employments','Pensiunan','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(22,'employments','Lain-lain','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(23,'special_needs','Tidak','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(24,'special_needs','Tuna Netra','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(25,'special_needs','Tuna Rungu','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(26,'special_needs','Tuna Grahita ringan','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(27,'special_needs','Tuna Grahita Sedang','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(28,'special_needs','Tuna Daksa Ringan','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(29,'special_needs','Tuna Daksa Sedang','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(30,'special_needs','Tuna Laras','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(31,'special_needs','Tuna Wicara','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(32,'special_needs','Tuna ganda','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(33,'special_needs','Hiper aktif','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(34,'special_needs','Cerdas Istimewa','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(35,'special_needs','Bakat Istimewa','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(36,'special_needs','Kesulitan Belajar','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(37,'special_needs','Narkoba','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(38,'special_needs','Indigo','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(39,'special_needs','Down Sindrome','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(40,'special_needs','Autis','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(41,'special_needs','Lainnya','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(42,'educations','Tidak sekolah','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(43,'educations','Putus SD','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(44,'educations','SD Sederajat','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(45,'educations','SMP Sederajat','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(46,'educations','SMA Sederajat','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(47,'educations','D1','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(48,'educations','D2','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(49,'educations','D3','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(50,'educations','D4/S1','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(51,'educations','S2','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(52,'educations','S3','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(53,'scholarships','Anak berprestasi','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(54,'scholarships','Anak Miskin','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(55,'scholarships','Pendidikan','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(56,'scholarships','Unggulan','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(57,'scholarships','Lain-lain','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(58,'achievement_types','Sains','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(59,'achievement_types','Seni','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(60,'achievement_types','Olahraga','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(61,'achievement_types','Lain-lain','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(62,'achievement_levels','Sekolah','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(63,'achievement_levels','Kecamatan','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(64,'achievement_levels','Kabupaten','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(65,'achievement_levels','Provinsi','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(66,'achievement_levels','Nasional','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(67,'achievement_levels','Internasional','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(68,'monthly_incomes','Kurang dari 500,000','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(69,'monthly_incomes','500.000 - 999.9999','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(70,'monthly_incomes','1 Juta - 1.999.999','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(71,'monthly_incomes','2 Juta - 4.999.999','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(72,'monthly_incomes','5 Juta - 20 Juta','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(73,'monthly_incomes','Lebih dari 20 Juta','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(74,'residences','Bersama orang tua','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(75,'residences','Wali','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(76,'residences','Kos','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(77,'residences','Asrama','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(78,'residences','Panti Asuhan','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(79,'residences','Lainnya','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(80,'transportations','Jalan kaki','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(81,'transportations','Kendaraan pribadi','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(82,'transportations','Kendaraan Umum / angkot / Pete-pete','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(83,'transportations','Jemputan Sekolah','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(84,'transportations','Kereta Api','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(85,'transportations','Ojek','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(86,'transportations','Andong / Bendi / Sado / Dokar / Delman / Beca','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(87,'transportations','Perahu penyebrangan / Rakit / Getek','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(88,'transportations','Lainnya','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(89,'religions','Islam','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(90,'religions','Kristen / Protestan','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(91,'religions','Katholik','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(92,'religions','Hindu','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(93,'religions','Budha','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(94,'religions','Khong Hu Chu','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(95,'religions','Lainnya','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(96,'school_levels','1 - Sekolah Dasar (SD)/ Sederajat','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(97,'school_levels','2 - Sekolah Menengah Pertama (SMP)/ Sederajat','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(98,'school_levels','3 - Sekolah Menengah Atas (SMA) / Aliyah','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(99,'school_levels','4 - Sekolah Menengah Kejuruan (SMK)','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(100,'school_levels','5 - Universitas','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(101,'school_levels','6 - Sekolah Tinggi','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(102,'school_levels','7 - Politeknik','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(103,'marriage_status','Kawin','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(104,'marriage_status','Belum Kawin','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(105,'marriage_status','Berpisah','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(106,'institution_lifters','Pemerintah Pusat','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(107,'institution_lifters','Pemerintah Provinsi','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(108,'institution_lifters','Pemerintah Kab / Kota','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(109,'institution_lifters','Ketua yayasan','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(110,'institution_lifters','Kepala Sekolah','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(111,'institution_lifters','Komite Sekolah','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(112,'institution_lifters','Lainnya','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(113,'employment_status','PNS ','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(114,'employment_status','PNS Diperbantukan ','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(115,'employment_status','PNS DEPAG ','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(116,'employment_status','GTY/PTY ','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(117,'employment_status','GTT/PTT Provinsi ','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(118,'employment_status','GTT/PTT Kabupaten / Kota','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(119,'employment_status','Guru Bantu Pusat ','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(120,'employment_status','Guru Honor Sekolah ','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(121,'employment_status','Tenaga Honor Sekolah ','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(122,'employment_status','CPNS','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(123,'employment_status','Lainnya','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(124,'employment_types','Guru Kelas','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(125,'employment_types','Guru Mata Pelajaran','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(126,'employment_types','Guru BK','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(127,'employment_types','Guru Inklusi','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(128,'employment_types','Tenaga Administrasi Sekolah','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(129,'employment_types','Gurtu Pendamping','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(130,'employment_types','Guru Magang','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(131,'employment_types','Guru TIK','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(132,'employment_types','Laboran','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(133,'employment_types','Pustakawan','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(134,'employment_types','Lainnya','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(135,'ranks','I/A','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(136,'ranks','I/B','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(137,'ranks','I/C','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(138,'ranks','I/D','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(139,'ranks','II/A','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(140,'ranks','II/B','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(141,'ranks','II/C','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(142,'ranks','II/D','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(143,'ranks','III/A','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(144,'ranks','III/B','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(145,'ranks','III/C','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(146,'ranks','III/D','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(147,'ranks','IV/A','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(148,'ranks','IV/B','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(149,'ranks','IV/C','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(150,'ranks','IV/D','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(151,'ranks','IV/E','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(152,'salary_sources','APBN','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(153,'salary_sources','APBD Provinsi','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(154,'salary_sources','APBD Kab / Kota','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(155,'salary_sources','Yayasan','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(156,'salary_sources','Sekolah','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(157,'salary_sources','Lembaga Donor','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(158,'salary_sources','Lainnya','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(159,'laboratory_skills','Lab IPA','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(160,'laboratory_skills','Lab Fisika','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(161,'laboratory_skills','Lab Biologi','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(162,'laboratory_skills','Lab Kimia','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(163,'laboratory_skills','Lab Bahasa','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(164,'laboratory_skills','Lab Komputer','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(165,'laboratory_skills','Teknik Bangunan','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(166,'laboratory_skills','Teknik Serveai & Pemetaan','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(167,'laboratory_skills','Teknik Ketenagakerjaan','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(168,'laboratory_skills','Teknik Pendidnginan & Tata Udara','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(169,'laboratory_skills','Teknik Mesin','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false');
1249/*!40000 ALTER TABLE `options` ENABLE KEYS */;
1250UNLOCK TABLES;
1251
1252--
1253-- Table structure for table `photos`
1254--
1255
1256DROP TABLE IF EXISTS `photos`;
1257/*!40101 SET @saved_cs_client     = @@character_set_client */;
1258/*!40101 SET character_set_client = utf8 */;
1259CREATE TABLE `photos` (
1260  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1261  `photo_album_id` bigint(20) NOT NULL DEFAULT '0',
1262  `photo_name` varchar(255) NOT NULL,
1263  `created_at` timestamp DEFAULT NOW(),
1264  `updated_at` timestamp NULL DEFAULT NULL,
1265  `deleted_at` timestamp NULL DEFAULT NULL,
1266  `restored_at` timestamp NULL DEFAULT NULL,
1267  `created_by` bigint(20) DEFAULT NULL,
1268  `updated_by` bigint(20) DEFAULT NULL,
1269  `deleted_by` bigint(20) DEFAULT NULL,
1270  `restored_by` bigint(20) DEFAULT NULL,
1271  `is_deleted` enum('true','false') DEFAULT 'false',
1272  PRIMARY KEY (`id`),
1273  KEY `photos_photo_album_id__idx` (`photo_album_id`) USING BTREE
1274) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1275/*!40101 SET character_set_client = @saved_cs_client */;
1276
1277--
1278-- Dumping data for table `photos`
1279--
1280
1281LOCK TABLES `photos` WRITE;
1282/*!40000 ALTER TABLE `photos` DISABLE KEYS */;
1283/*!40000 ALTER TABLE `photos` ENABLE KEYS */;
1284UNLOCK TABLES;
1285
1286--
1287-- Table structure for table `pollings`
1288--
1289
1290DROP TABLE IF EXISTS `pollings`;
1291/*!40101 SET @saved_cs_client     = @@character_set_client */;
1292/*!40101 SET character_set_client = utf8 */;
1293CREATE TABLE `pollings` (
1294  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1295  `answer_id` bigint(20) NOT NULL DEFAULT '0',
1296  `ip_address` varchar(45) DEFAULT NULL,
1297  `created_at` timestamp DEFAULT NOW(),
1298  `updated_at` timestamp NULL DEFAULT NULL,
1299  `deleted_at` timestamp NULL DEFAULT NULL,
1300  `restored_at` timestamp NULL DEFAULT NULL,
1301  `created_by` bigint(20) DEFAULT NULL,
1302  `updated_by` bigint(20) DEFAULT NULL,
1303  `deleted_by` bigint(20) DEFAULT NULL,
1304  `restored_by` bigint(20) DEFAULT NULL,
1305  `is_deleted` enum('true','false') DEFAULT 'false',
1306  PRIMARY KEY (`id`),
1307  KEY `pollings_answer_id__idx` (`answer_id`) USING BTREE
1308) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1309/*!40101 SET character_set_client = @saved_cs_client */;
1310
1311--
1312-- Dumping data for table `pollings`
1313--
1314
1315LOCK TABLES `pollings` WRITE;
1316/*!40000 ALTER TABLE `pollings` DISABLE KEYS */;
1317/*!40000 ALTER TABLE `pollings` ENABLE KEYS */;
1318UNLOCK TABLES;
1319
1320--
1321-- Table structure for table `posts`
1322--
1323
1324DROP TABLE IF EXISTS `posts`;
1325/*!40101 SET @saved_cs_client     = @@character_set_client */;
1326/*!40101 SET character_set_client = utf8 */;
1327CREATE TABLE `posts` (
1328  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1329  `post_title` varchar(255) DEFAULT NULL,
1330  `post_content` longtext,
1331  `post_image` varchar(100) DEFAULT NULL,
1332  `post_author` bigint(20) NOT NULL DEFAULT '0',
1333  `post_categories` varchar(255) DEFAULT NULL,
1334  `post_type` varchar(50) NOT NULL DEFAULT 'post',
1335  `post_status` enum('publish','draft') DEFAULT 'draft',
1336  `post_visibility` enum('public','private') DEFAULT 'public',
1337  `post_comment_status` enum('open','close') DEFAULT 'close',
1338  `post_slug` varchar(255) DEFAULT NULL,
1339  `post_tags` varchar(255) DEFAULT NULL,
1340  `post_counter` bigint(20) DEFAULT NULL,
1341  `created_at` timestamp DEFAULT NOW(),
1342  `updated_at` timestamp NULL DEFAULT NULL,
1343  `deleted_at` timestamp NULL DEFAULT NULL,
1344  `restored_at` timestamp NULL DEFAULT NULL,
1345  `created_by` bigint(20) DEFAULT NULL,
1346  `updated_by` bigint(20) DEFAULT NULL,
1347  `deleted_by` bigint(20) DEFAULT NULL,
1348  `restored_by` bigint(20) DEFAULT NULL,
1349  `is_deleted` enum('true','false') DEFAULT 'false',
1350  PRIMARY KEY (`id`),
1351  KEY `posts_post_author__idx` (`post_author`) USING BTREE
1352) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
1353/*!40101 SET character_set_client = @saved_cs_client */;
1354
1355--
1356-- Dumping data for table `posts`
1357--
1358
1359LOCK TABLES `posts` WRITE;
1360/*!40000 ALTER TABLE `posts` DISABLE KEYS */;
1361INSERT INTO `posts` VALUES (1,NULL,'<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat NULLa pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>',NULL,0,NULL,'welcome','','public','close',NULL,NULL,NULL,'2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(2,'Sample Page','<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat NULLa pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>','400x250.png',1,'1','page','','public','close','sample-page','berita, pengumuman, sekilas-info',1,'2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(3,'Sample Post 1','<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat NULLa pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>','post_image.png',1,'1','post','publish','public','open','sample-post-1','berita, pengumuman, sekilas-info',5,'2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(4,'Sample Post 2','<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat NULLa pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>','post_image.png',1,'1','post','publish','public','open','sample-post-2','berita, pengumuman, sekilas-info',1,'2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(5,'Sample Post 3','<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat NULLa pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>','post_image.png',1,'1','post','publish','public','open','sample-post-3','berita, pengumuman, sekilas-info',1,'2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(6,'Sample Post 4','<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat NULLa pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>','post_image.png',1,'1','post','publish','public','open','sample-post-4','berita, pengumuman, sekilas-info',1,'2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(7,'Sample Post 5','<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat NULLa pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>','post_image.png',1,'1','post','publish','public','open','sample-post-5','berita, pengumuman, sekilas-info',1,'2018-10-22 05:04:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false');
1362/*!40000 ALTER TABLE `posts` ENABLE KEYS */;
1363UNLOCK TABLES;
1364
1365--
1366-- Table structure for table `questions`
1367--
1368
1369DROP TABLE IF EXISTS `questions`;
1370/*!40101 SET @saved_cs_client     = @@character_set_client */;
1371/*!40101 SET character_set_client = utf8 */;
1372CREATE TABLE `questions` (
1373  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1374  `question` varchar(255) DEFAULT NULL,
1375  `is_active` enum('true','false') DEFAULT 'false',
1376  `created_at` timestamp DEFAULT NOW(),
1377  `updated_at` timestamp NULL DEFAULT NULL,
1378  `deleted_at` timestamp NULL DEFAULT NULL,
1379  `restored_at` timestamp NULL DEFAULT NULL,
1380  `created_by` bigint(20) DEFAULT NULL,
1381  `updated_by` bigint(20) DEFAULT NULL,
1382  `deleted_by` bigint(20) DEFAULT NULL,
1383  `restored_by` bigint(20) DEFAULT NULL,
1384  `is_deleted` enum('true','false') DEFAULT 'false',
1385  PRIMARY KEY (`id`),
1386  UNIQUE KEY `question` (`question`)
1387) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1388/*!40101 SET character_set_client = @saved_cs_client */;
1389
1390--
1391-- Dumping data for table `questions`
1392--
1393
1394LOCK TABLES `questions` WRITE;
1395/*!40000 ALTER TABLE `questions` DISABLE KEYS */;
1396/*!40000 ALTER TABLE `questions` ENABLE KEYS */;
1397UNLOCK TABLES;
1398
1399--
1400-- Table structure for table `quotes`
1401--
1402
1403DROP TABLE IF EXISTS `quotes`;
1404/*!40101 SET @saved_cs_client     = @@character_set_client */;
1405/*!40101 SET character_set_client = utf8 */;
1406CREATE TABLE `quotes` (
1407  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1408  `quote` varchar(255) DEFAULT NULL,
1409  `quote_by` varchar(255) DEFAULT NULL,
1410  `created_at` timestamp DEFAULT NOW(),
1411  `updated_at` timestamp NULL DEFAULT NULL,
1412  `deleted_at` timestamp NULL DEFAULT NULL,
1413  `restored_at` timestamp NULL DEFAULT NULL,
1414  `created_by` bigint(20) DEFAULT NULL,
1415  `updated_by` bigint(20) DEFAULT NULL,
1416  `deleted_by` bigint(20) DEFAULT NULL,
1417  `restored_by` bigint(20) DEFAULT NULL,
1418  `is_deleted` enum('true','false') DEFAULT 'false',
1419  PRIMARY KEY (`id`),
1420  UNIQUE KEY `unique_field` (`quote`,`quote_by`)
1421) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1422/*!40101 SET character_set_client = @saved_cs_client */;
1423
1424--
1425-- Dumping data for table `quotes`
1426--
1427
1428LOCK TABLES `quotes` WRITE;
1429/*!40000 ALTER TABLE `quotes` DISABLE KEYS */;
1430/*!40000 ALTER TABLE `quotes` ENABLE KEYS */;
1431UNLOCK TABLES;
1432
1433--
1434-- Table structure for table `rooms`
1435--
1436
1437DROP TABLE IF EXISTS `rooms`;
1438/*!40101 SET @saved_cs_client     = @@character_set_client */;
1439/*!40101 SET character_set_client = utf8 */;
1440CREATE TABLE `rooms` (
1441  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1442  `building_id` bigint(20) NOT NULL COMMENT 'Ruangan ini di gedung mana ?',
1443  `room_name` varchar(100) NOT NULL COMMENT 'Nama Ruang Kelas',
1444  `room_capacity` smallint(6) NOT NULL COMMENT 'Kapasitas / Jumlah Kursi',
1445  `is_class_room` enum('true','false') NOT NULL COMMENT 'Apakah merupakan ruang kelas ?',
1446  `created_at` timestamp DEFAULT NOW(),
1447  `updated_at` timestamp NULL DEFAULT NULL,
1448  `deleted_at` timestamp NULL DEFAULT NULL,
1449  `restored_at` timestamp NULL DEFAULT NULL,
1450  `created_by` bigint(20) DEFAULT NULL,
1451  `updated_by` bigint(20) DEFAULT NULL,
1452  `deleted_by` bigint(20) DEFAULT NULL,
1453  `restored_by` bigint(20) DEFAULT NULL,
1454  `is_deleted` enum('true','false') DEFAULT 'false',
1455  PRIMARY KEY (`id`),
1456  UNIQUE KEY `unique_field` (`building_id`,`room_name`),
1457  KEY `rooms_building_id__idx` (`building_id`) USING BTREE
1458) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
1459/*!40101 SET character_set_client = @saved_cs_client */;
1460
1461--
1462-- Dumping data for table `rooms`
1463--
1464
1465LOCK TABLES `rooms` WRITE;
1466/*!40000 ALTER TABLE `rooms` DISABLE KEYS */;
1467INSERT INTO `rooms` VALUES (1,1,'A1001',40,'true','2018-10-22 05:04:39',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(2,1,'A1002',40,'true','2018-10-22 05:04:39',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(3,1,'A1003',40,'true','2018-10-22 05:04:39',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(4,1,'A1004',40,'true','2018-10-22 05:04:39',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(5,1,'A1005',40,'true','2018-10-22 05:04:39',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(6,1,'A1006',40,'true','2018-10-22 05:04:39',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(7,1,'A1007',40,'true','2018-10-22 05:04:39',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(8,1,'A1008',40,'true','2018-10-22 05:04:39',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(9,1,'A1009',40,'true','2018-10-22 05:04:39',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(10,1,'A1010',40,'true','2018-10-22 05:04:39',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false');
1468/*!40000 ALTER TABLE `rooms` ENABLE KEYS */;
1469UNLOCK TABLES;
1470
1471--
1472-- Table structure for table `scholarships`
1473--
1474
1475DROP TABLE IF EXISTS `scholarships`;
1476/*!40101 SET @saved_cs_client     = @@character_set_client */;
1477/*!40101 SET character_set_client = utf8 */;
1478CREATE TABLE `scholarships` (
1479  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1480  `student_id` bigint(20) NOT NULL DEFAULT '0',
1481  `scholarship_type` bigint(20) NOT NULL DEFAULT '0',
1482  `scholarship_description` varchar(255) NOT NULL,
1483  `scholarship_start_year` year(4) NOT NULL,
1484  `scholarship_end_year` year(4) NOT NULL,
1485  `created_at` timestamp DEFAULT NOW(),
1486  `updated_at` timestamp NULL DEFAULT NULL,
1487  `deleted_at` timestamp NULL DEFAULT NULL,
1488  `restored_at` timestamp NULL DEFAULT NULL,
1489  `created_by` bigint(20) DEFAULT NULL,
1490  `updated_by` bigint(20) DEFAULT NULL,
1491  `deleted_by` bigint(20) DEFAULT NULL,
1492  `restored_by` bigint(20) DEFAULT NULL,
1493  `is_deleted` enum('true','false') DEFAULT 'false',
1494  PRIMARY KEY (`id`),
1495  KEY `scholarships_student_id__idx` (`student_id`) USING BTREE
1496) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1497/*!40101 SET character_set_client = @saved_cs_client */;
1498
1499--
1500-- Dumping data for table `scholarships`
1501--
1502
1503LOCK TABLES `scholarships` WRITE;
1504/*!40000 ALTER TABLE `scholarships` DISABLE KEYS */;
1505/*!40000 ALTER TABLE `scholarships` ENABLE KEYS */;
1506UNLOCK TABLES;
1507
1508--
1509-- Table structure for table `settings`
1510--
1511
1512DROP TABLE IF EXISTS `settings`;
1513/*!40101 SET @saved_cs_client     = @@character_set_client */;
1514/*!40101 SET character_set_client = utf8 */;
1515CREATE TABLE `settings` (
1516  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1517  `setting_group` varchar(100) NOT NULL,
1518  `setting_variable` varchar(255) DEFAULT NULL,
1519  `setting_value` text,
1520  `setting_default_value` text,
1521  `setting_access_group` varchar(255) DEFAULT NULL,
1522  `setting_description` varchar(255) DEFAULT NULL,
1523  `created_at` timestamp DEFAULT NOW(),
1524  `updated_at` timestamp NULL DEFAULT NULL,
1525  `deleted_at` timestamp NULL DEFAULT NULL,
1526  `restored_at` timestamp NULL DEFAULT NULL,
1527  `created_by` bigint(20) DEFAULT NULL,
1528  `updated_by` bigint(20) DEFAULT NULL,
1529  `deleted_by` bigint(20) DEFAULT NULL,
1530  `restored_by` bigint(20) DEFAULT NULL,
1531  `is_deleted` enum('true','false') DEFAULT 'false',
1532  PRIMARY KEY (`id`),
1533  UNIQUE KEY `unique_field` (`setting_group`,`setting_variable`)
1534) ENGINE=InnoDB AUTO_INCREMENT=96 DEFAULT CHARSET=utf8;
1535/*!40101 SET character_set_client = @saved_cs_client */;
1536
1537--
1538-- Dumping data for table `settings`
1539--
1540
1541LOCK TABLES `settings` WRITE;
1542/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
1543INSERT INTO `settings` VALUES (1,'general','automatically_create_user',NULL,'false','administrator, super_user','Automatically Create User ?','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(2,'general','site_maintenance',NULL,'false','public, student, employee, administrator, super_user','Pemeliharaan situs','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(3,'general','site_maintenance_end_date',NULL,'2018-01-01','public, student, employee, administrator, super_user','Tanggal Berakhir Pemeliharaan Situs','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(4,'general','site_cache',NULL,'false','public, student, employee, administrator, super_user','Cache situs','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(5,'general','site_cache_time',NULL,'10','public, student, employee, administrator, super_user','Lama Cache Situs','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(6,'general','meta_description',NULL,'CMS Sekolahku adalah Content Management System dan PPDB Online gratis untuk SD SMP/Sederajat SMA/Sederajat','public, student, employee, administrator, super_user','Deskripsi Meta','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(7,'general','meta_keywords',NULL,'CMS, Website Sekolah Gratis, Cara Membuat Website Sekolah, membuat web sekolah, contoh website sekolah, fitur website sekolah, Sekolah, Website, Internet,Situs, CMS Sekolah, Web Sekolah, Website Sekolah Gratis, Website Sekolah, Aplikasi Sekolah, PPDB Online, PSB Online, PSB Online Gratis, Penerimaan Siswa Baru Online, Raport Online, Kurikulum 2013, SD, SMP, SMA, Aliyah, MTs, SMK','public, student, employee, administrator, super_user','Kata Kunci Meta','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(8,'general','google_map_api_key',NULL,'AIzaSyDmiycFxzYZ37FOwA4wqSbL3z2YvIYIArw','public, student, employee, administrator, super_user','API Key Google Map','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(9,'general','favicon',NULL,'favicon.png','public, student, employee, administrator, super_user','Favicon','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(10,'general','header',NULL,'header.png','public, student, employee, administrator, super_user','Gambar Header','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(11,'general','recaptcha_status',NULL,'enable','public, student, employee, administrator, super_user','reCAPTCHA Status','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(12,'general','recaptcha_site_key',NULL,'6Len_y4UAAAAAMGncwY1nNkKWFg5cdnFt7VxLFcG','public, student, employee, administrator, super_user','reCAPTCHA Site Key','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(13,'general','recaptcha_secret_key',NULL,'6Len_y4UAAAAAJAIxuNyv2daHmdQ5kapvLgoiDAd','','reCAPTCHA Secret Key','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(14,'general','timezone',NULL,'Asia/Jakarta','public, student, employee, administrator, super_user','Time Zone','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(15,'general','latitude',NULL,'-6.2407311','public, student, employee, administrator, super_user','Latitude','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(16,'general','longitude',NULL,'106.9972892','public, student, employee, administrator, super_user','Longitude','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(17,'media','file_allowed_types',NULL,'jpg, jpeg, png, gif','public, student, employee, administrator, super_user','Tipe file yang diizinkan','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(18,'media','upload_max_filesize',NULL,'0','public, student, employee, administrator, super_user','Maksimal Ukuran File yang Diupload','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(19,'media','thumbnail_size_height',NULL,'100','administrator, super_user','Tinggi Gambar Thumbnail','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(20,'media','thumbnail_size_width',NULL,'150','administrator, super_user','Lebar Gambar Thumbnail','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(21,'media','medium_size_height',NULL,'308','administrator, super_user','Tinggi Gambar Sedang','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(22,'media','medium_size_width',NULL,'460','administrator, super_user','Lebar Gambar Sedang','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(23,'media','large_size_height',NULL,'600','administrator, super_user','Tinggi Gambar Besar','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(24,'media','large_size_width',NULL,'800','administrator, super_user','Lebar Gambar Besar','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(25,'media','album_cover_height',NULL,'250','administrator, super_user','Tinggi Cover Album Photo','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(26,'media','album_cover_width',NULL,'400','administrator, super_user','Lebar Cover Album Photo','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(27,'media','banner_height',NULL,'81','administrator, super_user','Tinggi Iklan','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(28,'media','banner_width',NULL,'245','administrator, super_user','Lebar Iklan','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(29,'media','image_slider_height',NULL,'400','administrator, super_user','Tinggi Gambar Slide','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(30,'media','image_slider_width',NULL,'900','administrator, super_user','Lebar Gambar Slide','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(31,'media','student_photo_height',NULL,'400','public, student, employee, administrator, super_user','Tinggi Photo Peserta Didik','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(32,'media','student_photo_width',NULL,'300','public, student, employee, administrator, super_user','Lebar Photo Peserta Didik','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(33,'media','employee_photo_height',NULL,'400','employee, administrator, super_user','Tinggi Photo Guru dan Tenaga Kependidikan','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(34,'media','employee_photo_width',NULL,'300','employee, administrator, super_user','Lebar Photo Guru dan Tenaga Kependidikan','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(35,'media','headmaster_photo_height',NULL,'400','administrator, super_user','Tinggi Photo Kepala Sekolah','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(36,'media','headmaster_photo_width',NULL,'300','administrator, super_user','Lebar Photo Kepala Sekolah','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(37,'media','header_height',NULL,'80','administrator, super_user','Tinggi Gambar Header','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(38,'media','header_width',NULL,'200','administrator, super_user','Lebar Gambar Header','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(39,'media','logo_height',NULL,'120','administrator, super_user','Tinggi Logo Sekolah','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(40,'media','logo_width',NULL,'120','administrator, super_user','Lebar Logo Sekolah','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(41,'writing','default_post_category',NULL,'1','administrator, super_user','Default Kategori Tulisan','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(42,'writing','default_post_status',NULL,'publish','administrator, super_user','Default Status Tulisan','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(43,'writing','default_post_visibility',NULL,'public','administrator, super_user','Default Akses Tulisan','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(44,'writing','default_post_discussion',NULL,'open','administrator, super_user','Default Komentar Tulisan','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(45,'writing','post_image_thumbnail_height',NULL,'100','student, employee, administrator, super_user','Tinggi Gambar Kecil','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(46,'writing','post_image_thumbnail_width',NULL,'150','student, employee, administrator, super_user','Lebar Gambar Kecil','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(47,'writing','post_image_medium_height',NULL,'250','student, employee, administrator, super_user','Tinggi Gambar Sedang','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(48,'writing','post_image_medium_width',NULL,'400','student, employee, administrator, super_user','Lebar Gambar Sedang','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(49,'writing','post_image_large_height',NULL,'450','student, employee, administrator, super_user','Tinggi Gambar Besar','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(50,'writing','post_image_large_width',NULL,'840','student, employee, administrator, super_user','Lebar Gambar Besar','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(51,'reading','post_per_page',NULL,'10','public, student, employee, administrator, super_user','Tulisan per halaman','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(52,'reading','post_rss_count',NULL,'10','public, student, employee, administrator, super_user','Jumlah RSS','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(53,'reading','post_related_count',NULL,'10','public, student, employee, administrator, super_user','Jumlah Tulisan Terkait','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(54,'reading','comment_per_page',NULL,'10','public, student, employee, administrator, super_user','Komentar per halaman','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(55,'discussion','comment_moderation',NULL,'false','administrator, super_user','Komentar harus disetujui secara manual','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(56,'discussion','comment_registration',NULL,'false','public, student, employee, administrator, super_user','Pengguna harus terdaftar dan login untuk komentar','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(57,'discussion','comment_blacklist',NULL,'kampret','public, student, employee, administrator, super_user','Komentar disaring','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(58,'discussion','comment_order',NULL,'asc','public, student, employee, administrator, super_user','Urutan Komentar','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(59,'social_account','facebook',NULL,'https://www.facebook.com/cmssekolahku/','public, student, employee, administrator, super_user','Facebook','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(60,'social_account','twitter',NULL,'https://twitter.com/antonsofyan','public, student, employee, administrator, super_user','Twitter','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(61,'social_account','google_plus',NULL,'google.com/+AntonSofyan','public, student, employee, administrator, super_user','Google Plus','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(62,'social_account','linked_in',NULL,'https://www.linkedin.com/in/anton-sofyan-1428937a/','public, student, employee, administrator, super_user','Linked In','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(63,'social_account','youtube',NULL,'-','public, student, employee, administrator, super_user','Youtube','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(64,'social_account','instagram',NULL,'https://www.instagram.com/anton_sofyan/','public, student, employee, administrator, super_user','Instagram','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(65,'mail_server','sendgrid_username',NULL,'','administrator, super_user','Sendgrid Username','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(66,'mail_server','sendgrid_password',NULL,'','administrator, super_user','Sendgrid Password','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(67,'mail_server','sendgrid_api_key',NULL,'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','administrator, super_user','Sendgrid API Key','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(68,'school_profile','npsn',NULL,'123','public, student, employee, administrator, super_user','NPSN','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(69,'school_profile','school_name',NULL,'SMA Negeri 9 Kuningan','public, student, employee, administrator, super_user','Nama Sekolah','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(70,'school_profile','headmaster',NULL,'Anton Sofyan','public, student, employee, administrator, super_user','Kepala Sekolah','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(71,'school_profile','headmaster_photo',NULL,'headmaster_photo.png','public, student, employee, administrator, super_user','Photo Kepala Sekolah','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(72,'school_profile','school_level',NULL,'3','public, student, employee, administrator, super_user','Bentuk Pendidikan','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(73,'school_profile','school_status',NULL,'1','public, student, employee, administrator, super_user','Status Sekolah','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(74,'school_profile','ownership_status',NULL,'1','administrator, super_user','Status Kepemilikan','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(75,'school_profile','decree_operating_permit',NULL,'-','administrator, super_user','SK Izin Operasional','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(76,'school_profile','decree_operating_permit_date',NULL,'2018-10-22','administrator, super_user','Tanggal SK Izin Operasional','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(77,'school_profile','tagline',NULL,'Where Tomorrow\'s Leaders Come Together','public, student, employee, administrator, super_user','Slogan','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(78,'school_profile','rt',NULL,'12','public, student, employee, administrator, super_user','RT','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(79,'school_profile','rw',NULL,'06','public, student, employee, administrator, super_user','RW','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(80,'school_profile','sub_village',NULL,'Wage','public, student, employee, administrator, super_user','Dusun','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(81,'school_profile','village',NULL,'Kadugede','public, student, employee, administrator, super_user','Kelurahan / Desa','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(82,'school_profile','sub_district',NULL,'Kadugede','public, student, employee, administrator, super_user','Kecamatan','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(83,'school_profile','district',NULL,'Kuningan','public, student, employee, administrator, super_user','Kabupaten','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(84,'school_profile','postal_code',NULL,'45561','public, student, employee, administrator, super_user','Kode Pos','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(85,'school_profile','street_address',NULL,'Jalan Raya Kadugede No. 11','public, student, employee, administrator, super_user','Alamat Jalan','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(86,'school_profile','phone',NULL,'0232123456','public, student, employee, administrator, super_user','Telepon','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(87,'school_profile','fax',NULL,'0232123456','public, student, employee, administrator, super_user','Fax','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(88,'school_profile','email',NULL,'info@sman9kuningan.sch.id','public, student, employee, administrator, super_user','Email','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(89,'school_profile','website',NULL,'http://www.sman9kuningan.sch.id','public, student, employee, administrator, super_user','Website','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(90,'school_profile','logo',NULL,'logo.png','public, student, employee, administrator, super_user','Logo','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(91,'admission','admission_status',NULL,'open','public, student, employee, administrator, super_user','Status Penerimaan Peserta Didik Baru','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(92,'admission','announcement_start_date',NULL,'2018-01-01','public, student, employee, administrator, super_user','Tanggal Mulai Pengumuman Hasil Seleksi Penerimaan Peserta Didik / Mahasiswa Baru','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(93,'admission','announcement_end_date',NULL,'2018-12-31','public, student, employee, administrator, super_user','Tanggal Selesai Pengumuman Hasil Seleksi Penerimaan Peserta Didik / Mahasiswa Baru','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(94,'admission','min_birth_date',NULL,NULL,'administrator, super_user','Tanggal Lahir Minimal Calon Peserta Didik / Mahasiswa Baru','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(95,'admission','max_birth_date',NULL,NULL,'administrator, super_user','Tanggal Lahir Maksimal Calon Peserta Didik / Mahasiswa Baru','2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false');
1544/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
1545UNLOCK TABLES;
1546
1547--
1548-- Table structure for table `students`
1549--
1550
1551DROP TABLE IF EXISTS `students`;
1552/*!40101 SET @saved_cs_client     = @@character_set_client */;
1553/*!40101 SET character_set_client = utf8 */;
1554CREATE TABLE `students` (
1555  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1556  `major_id` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Program Keahlian',
1557  `first_choice_id` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Pilihan Pertama PPDB',
1558  `second_choice_id` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Pilihan Kedua PPDB',
1559  `registration_number` varchar(10) DEFAULT NULL COMMENT 'Nomor Pendaftaran',
1560  `admission_exam_number` varchar(10) DEFAULT NULL COMMENT 'Nomor Ujian Tes Tulis',
1561  `selection_result` varchar(100) DEFAULT NULL COMMENT 'Hasil Seleksi PPDB/PMB',
1562  `admission_phase_id` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Gelombang Pendaftaran',
1563  `admission_type_id` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Jalur Pendaftaran',
1564  `photo` varchar(100) DEFAULT NULL,
1565  `achievement` text COMMENT 'Prestasi Calon Peserta Didik / Mahasiswa',
1566  `is_student` enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'Apakah Siswa Aktif ? Set true jika lolos seleksi PPDB dan set FALSE jika sudah lulus',
1567  `is_prospective_student` enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'Apakah Calon Siswa Baru ?',
1568  `is_alumni` enum('true','false','unverified') NOT NULL DEFAULT 'false' COMMENT 'Apakah Alumni ?',
1569  `is_transfer` enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'Jenis Pendaftaran : Baru / Pindahan ?',
1570  `re_registration` enum('true','false') DEFAULT NULL COMMENT 'Konfirmasi Pendaftaran Ulang Calon Siswa Baru',
1571  `start_date` date DEFAULT NULL COMMENT 'Tanggal Masuk Sekolah',
1572  `identity_number` varchar(50) DEFAULT NULL COMMENT 'NIS/NIM',
1573  `nisn` varchar(50) DEFAULT NULL COMMENT 'Nomor Induk Siswa Nasional',
1574  `nik` varchar(50) DEFAULT NULL COMMENT 'Nomor Induk Kependudukan / KTP',
1575  `prev_exam_number` varchar(50) DEFAULT NULL COMMENT 'Nomor Peserta Ujian Sebelumnya',
1576  `prev_diploma_number` varchar(50) DEFAULT NULL COMMENT 'Nomor Ijazah Sebelumnya',
1577  `paud` enum('true','false') DEFAULT NULL COMMENT 'Apakah pernah PAUD',
1578  `tk` enum('true','false') DEFAULT NULL COMMENT 'Apakah pernah TK',
1579  `skhun` varchar(50) DEFAULT NULL COMMENT 'No. Seri Surat Keterangan Hasil Ujian Nasional Sebelumnya',
1580  `prev_school_name` varchar(255) DEFAULT NULL COMMENT 'Nama Sekolah Sebelumnya',
1581  `prev_school_address` varchar(255) DEFAULT NULL COMMENT 'Alamat Sekolah Sebelumnya',
1582  `hobby` varchar(255) DEFAULT NULL,
1583  `ambition` varchar(255) DEFAULT NULL COMMENT 'Cita-cita',
1584  `full_name` varchar(150) NOT NULL,
1585  `gender` enum('M','F') NOT NULL DEFAULT 'M',
1586  `birth_place` varchar(255) DEFAULT NULL,
1587  `birth_date` date DEFAULT NULL,
1588  `religion_id` bigint(20) NOT NULL DEFAULT '0',
1589  `special_need_id` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Berkeburuhan Khusus',
1590  `street_address` varchar(255) DEFAULT NULL COMMENT 'Alamat Jalan',
1591  `rt` varchar(10) DEFAULT NULL COMMENT 'Alamat Jalan',
1592  `rw` varchar(10) DEFAULT NULL COMMENT 'Alamat Jalan',
1593  `sub_village` varchar(255) DEFAULT NULL COMMENT 'Nama Dusun',
1594  `village` varchar(255) DEFAULT NULL COMMENT 'Nama Kelurahan/ Desa',
1595  `sub_district` varchar(255) DEFAULT NULL COMMENT 'Kecamatan',
1596  `district` varchar(255) DEFAULT NULL COMMENT 'Kabupaten',
1597  `postal_code` varchar(20) DEFAULT NULL COMMENT 'Kode POS',
1598  `residence_id` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Tempat Tinggal',
1599  `transportation_id` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Moda Transportasi',
1600  `phone` varchar(50) DEFAULT NULL,
1601  `mobile_phone` varchar(50) DEFAULT NULL,
1602  `email` varchar(150) DEFAULT NULL,
1603  `sktm` varchar(100) DEFAULT NULL COMMENT 'Surat Keterangan Tidak Mampu (SKTM)',
1604  `kks` varchar(100) DEFAULT NULL COMMENT 'Kartu Keluarga Sejahtera (KKS)',
1605  `kps` varchar(100) DEFAULT NULL COMMENT 'Kartu Pra Sejahtera (KPS)',
1606  `kip` varchar(100) DEFAULT NULL COMMENT 'Kartu Indonesia Pintar (KIP)',
1607  `kis` varchar(100) DEFAULT NULL COMMENT 'Kartu Indonesia Sehat (KIS)',
1608  `citizenship` enum('WNI','WNA') NOT NULL DEFAULT 'WNI' COMMENT 'Kewarganegaraan',
1609  `country` varchar(255) DEFAULT NULL,
1610  `father_name` varchar(150) DEFAULT NULL,
1611  `father_birth_year` year(4) DEFAULT NULL,
1612  `father_education_id` bigint(20) NOT NULL DEFAULT '0',
1613  `father_employment_id` bigint(20) NOT NULL DEFAULT '0',
1614  `father_monthly_income_id` bigint(20) NOT NULL DEFAULT '0',
1615  `father_special_need_id` bigint(20) NOT NULL DEFAULT '0',
1616  `mother_name` varchar(150) DEFAULT NULL,
1617  `mother_birth_year` year(4) DEFAULT NULL,
1618  `mother_education_id` bigint(20) NOT NULL DEFAULT '0',
1619  `mother_employment_id` bigint(20) NOT NULL DEFAULT '0',
1620  `mother_monthly_income_id` bigint(20) NOT NULL DEFAULT '0',
1621  `mother_special_need_id` bigint(20) NOT NULL DEFAULT '0',
1622  `guardian_name` varchar(150) DEFAULT NULL,
1623  `guardian_birth_year` year(4) DEFAULT NULL,
1624  `guardian_education_id` bigint(20) NOT NULL DEFAULT '0',
1625  `guardian_employment_id` bigint(20) NOT NULL DEFAULT '0',
1626  `guardian_monthly_income_id` bigint(20) NOT NULL DEFAULT '0',
1627  `mileage` smallint(6) DEFAULT NULL COMMENT 'Jarak tempat tinggal ke sekolah',
1628  `traveling_time` smallint(6) DEFAULT NULL COMMENT 'Waktu Tempuh',
1629  `height` smallint(3) DEFAULT NULL COMMENT 'Tinggi Badan',
1630  `weight` smallint(3) DEFAULT NULL COMMENT 'Berat Badan',
1631  `sibling_number` smallint(2) DEFAULT '0' COMMENT 'Jumlah Saudara Kandng',
1632  `student_status_id` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Status siswa',
1633  `end_date` date DEFAULT NULL COMMENT 'Tanggal Keluar',
1634  `reason` varchar(255) DEFAULT NULL COMMENT 'Diisi jika peserta didik sudah keluar',
1635  `created_at` timestamp DEFAULT NOW(),
1636  `updated_at` timestamp NULL DEFAULT NULL,
1637  `deleted_at` timestamp NULL DEFAULT NULL,
1638  `restored_at` timestamp NULL DEFAULT NULL,
1639  `created_by` bigint(20) DEFAULT NULL,
1640  `updated_by` bigint(20) DEFAULT NULL,
1641  `deleted_by` bigint(20) DEFAULT NULL,
1642  `restored_by` bigint(20) DEFAULT NULL,
1643  `is_deleted` enum('true','false') DEFAULT 'false',
1644  PRIMARY KEY (`id`),
1645  UNIQUE KEY `identity_number` (`identity_number`),
1646  UNIQUE KEY `nisn` (`nisn`),
1647  UNIQUE KEY `nik` (`nik`),
1648  KEY `students_registration_number__idx` (`registration_number`) USING BTREE,
1649  KEY `students_identity_number__idx` (`identity_number`) USING BTREE,
1650  KEY `students_full_name__idx` (`full_name`) USING BTREE,
1651  KEY `students_first_choice_id__idx` (`first_choice_id`) USING BTREE,
1652  KEY `students_second_choice_id__idx` (`second_choice_id`) USING BTREE,
1653  KEY `students_major_id__idx` (`major_id`) USING BTREE,
1654  KEY `students_admission_phase_id__idx` (`admission_phase_id`) USING BTREE,
1655  KEY `students_admission_type_id__idx` (`admission_type_id`) USING BTREE,
1656  KEY `students_student_status_id__idx` (`student_status_id`) USING BTREE
1657) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1658/*!40101 SET character_set_client = @saved_cs_client */;
1659
1660--
1661-- Dumping data for table `students`
1662--
1663
1664LOCK TABLES `students` WRITE;
1665/*!40000 ALTER TABLE `students` DISABLE KEYS */;
1666/*!40000 ALTER TABLE `students` ENABLE KEYS */;
1667UNLOCK TABLES;
1668
1669--
1670-- Table structure for table `subjects`
1671--
1672
1673DROP TABLE IF EXISTS `subjects`;
1674/*!40101 SET @saved_cs_client     = @@character_set_client */;
1675/*!40101 SET character_set_client = utf8 */;
1676CREATE TABLE `subjects` (
1677  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1678  `subject_name` varchar(255) NOT NULL,
1679  `created_at` timestamp DEFAULT NOW(),
1680  `updated_at` timestamp NULL DEFAULT NULL,
1681  `deleted_at` timestamp NULL DEFAULT NULL,
1682  `restored_at` timestamp NULL DEFAULT NULL,
1683  `created_by` bigint(20) DEFAULT NULL,
1684  `updated_by` bigint(20) DEFAULT NULL,
1685  `deleted_by` bigint(20) DEFAULT NULL,
1686  `restored_by` bigint(20) DEFAULT NULL,
1687  `is_deleted` enum('true','false') DEFAULT 'false',
1688  PRIMARY KEY (`id`),
1689  UNIQUE KEY `subject_name` (`subject_name`)
1690) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
1691/*!40101 SET character_set_client = @saved_cs_client */;
1692
1693--
1694-- Dumping data for table `subjects`
1695--
1696
1697LOCK TABLES `subjects` WRITE;
1698/*!40000 ALTER TABLE `subjects` DISABLE KEYS */;
1699INSERT INTO `subjects` VALUES (1,'Pendidikan Agama','2018-10-22 05:04:39',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(2,'Pendidikan Pancasila dan Kewarganegaraan','2018-10-22 05:04:39',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(3,'Matematika','2018-10-22 05:04:39',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(4,'Sejarah Indonesia','2018-10-22 05:04:39',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(5,'Bahasa Indonesia','2018-10-22 05:04:39',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(6,'Bahasa Inggris','2018-10-22 05:04:39',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(7,'Seni Budaya','2018-10-22 05:04:39',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(8,'Prakarya','2018-10-22 05:04:39',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(9,'Pendidikan Jasmani, Olahraga dan Kesehatan','2018-10-22 05:04:39',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false');
1700/*!40000 ALTER TABLE `subjects` ENABLE KEYS */;
1701UNLOCK TABLES;
1702
1703--
1704-- Table structure for table `subscribers`
1705--
1706
1707DROP TABLE IF EXISTS `subscribers`;
1708/*!40101 SET @saved_cs_client     = @@character_set_client */;
1709/*!40101 SET character_set_client = utf8 */;
1710CREATE TABLE `subscribers` (
1711  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1712  `email` varchar(255) DEFAULT NULL,
1713  `created_at` timestamp DEFAULT NOW(),
1714  `updated_at` timestamp NULL DEFAULT NULL,
1715  `deleted_at` timestamp NULL DEFAULT NULL,
1716  `restored_at` timestamp NULL DEFAULT NULL,
1717  `created_by` bigint(20) DEFAULT NULL,
1718  `updated_by` bigint(20) DEFAULT NULL,
1719  `deleted_by` bigint(20) DEFAULT NULL,
1720  `restored_by` bigint(20) DEFAULT NULL,
1721  `is_deleted` enum('true','false') DEFAULT 'false',
1722  PRIMARY KEY (`id`),
1723  UNIQUE KEY `email` (`email`)
1724) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1725/*!40101 SET character_set_client = @saved_cs_client */;
1726
1727--
1728-- Dumping data for table `subscribers`
1729--
1730
1731LOCK TABLES `subscribers` WRITE;
1732/*!40000 ALTER TABLE `subscribers` DISABLE KEYS */;
1733/*!40000 ALTER TABLE `subscribers` ENABLE KEYS */;
1734UNLOCK TABLES;
1735
1736--
1737-- Table structure for table `tags`
1738--
1739
1740DROP TABLE IF EXISTS `tags`;
1741/*!40101 SET @saved_cs_client     = @@character_set_client */;
1742/*!40101 SET character_set_client = utf8 */;
1743CREATE TABLE `tags` (
1744  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1745  `tag` varchar(255) NOT NULL,
1746  `slug` varchar(255) DEFAULT NULL,
1747  `created_at` timestamp DEFAULT NOW(),
1748  `updated_at` timestamp NULL DEFAULT NULL,
1749  `deleted_at` timestamp NULL DEFAULT NULL,
1750  `restored_at` timestamp NULL DEFAULT NULL,
1751  `created_by` bigint(20) DEFAULT NULL,
1752  `updated_by` bigint(20) DEFAULT NULL,
1753  `deleted_by` bigint(20) DEFAULT NULL,
1754  `restored_by` bigint(20) DEFAULT NULL,
1755  `is_deleted` enum('true','false') DEFAULT 'false',
1756  PRIMARY KEY (`id`),
1757  UNIQUE KEY `tag` (`tag`)
1758) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
1759/*!40101 SET character_set_client = @saved_cs_client */;
1760
1761--
1762-- Dumping data for table `tags`
1763--
1764
1765LOCK TABLES `tags` WRITE;
1766/*!40000 ALTER TABLE `tags` DISABLE KEYS */;
1767INSERT INTO `tags` VALUES (1,'Berita','berita','2018-10-22 05:04:41',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(2,'Pengumuman','pengumuman','2018-10-22 05:04:41',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(3,'Sekilas Info','sekilas-info','2018-10-22 05:04:41',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false');
1768/*!40000 ALTER TABLE `tags` ENABLE KEYS */;
1769UNLOCK TABLES;
1770
1771--
1772-- Table structure for table `themes`
1773--
1774
1775DROP TABLE IF EXISTS `themes`;
1776/*!40101 SET @saved_cs_client     = @@character_set_client */;
1777/*!40101 SET character_set_client = utf8 */;
1778CREATE TABLE `themes` (
1779  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1780  `theme_name` varchar(255) NOT NULL,
1781  `theme_folder` varchar(255) DEFAULT NULL,
1782  `theme_author` varchar(255) DEFAULT NULL,
1783  `is_active` enum('true','false') DEFAULT 'false',
1784  `created_at` timestamp DEFAULT NOW(),
1785  `updated_at` timestamp NULL DEFAULT NULL,
1786  `deleted_at` timestamp NULL DEFAULT NULL,
1787  `restored_at` timestamp NULL DEFAULT NULL,
1788  `created_by` bigint(20) DEFAULT NULL,
1789  `updated_by` bigint(20) DEFAULT NULL,
1790  `deleted_by` bigint(20) DEFAULT NULL,
1791  `restored_by` bigint(20) DEFAULT NULL,
1792  `is_deleted` enum('true','false') DEFAULT 'false',
1793  PRIMARY KEY (`id`),
1794  UNIQUE KEY `nametheme_name` (`theme_name`)
1795) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
1796/*!40101 SET character_set_client = @saved_cs_client */;
1797
1798--
1799-- Dumping data for table `themes`
1800--
1801
1802LOCK TABLES `themes` WRITE;
1803/*!40000 ALTER TABLE `themes` DISABLE KEYS */;
1804INSERT INTO `themes` VALUES (1,'Cosmo','cosmo','Anton Sofyan','false','2018-10-22 05:04:41',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'),(2,'Magazine','magazine','Anton Sofyan','true','2018-10-22 05:04:41',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false');
1805/*!40000 ALTER TABLE `themes` ENABLE KEYS */;
1806UNLOCK TABLES;
1807
1808--
1809-- Table structure for table `user_groups`
1810--
1811
1812DROP TABLE IF EXISTS `user_groups`;
1813/*!40101 SET @saved_cs_client     = @@character_set_client */;
1814/*!40101 SET character_set_client = utf8 */;
1815CREATE TABLE `user_groups` (
1816  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1817  `user_group` varchar(255) NOT NULL,
1818  `created_at` timestamp DEFAULT NOW(),
1819  `updated_at` timestamp NULL DEFAULT NULL,
1820  `deleted_at` timestamp NULL DEFAULT NULL,
1821  `restored_at` timestamp NULL DEFAULT NULL,
1822  `created_by` bigint(20) DEFAULT NULL,
1823  `updated_by` bigint(20) DEFAULT NULL,
1824  `deleted_by` bigint(20) DEFAULT NULL,
1825  `restored_by` bigint(20) DEFAULT NULL,
1826  `is_deleted` enum('true','false') DEFAULT 'false',
1827  PRIMARY KEY (`id`),
1828  UNIQUE KEY `user_group` (`user_group`)
1829) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1830/*!40101 SET character_set_client = @saved_cs_client */;
1831
1832--
1833-- Dumping data for table `user_groups`
1834--
1835
1836LOCK TABLES `user_groups` WRITE;
1837/*!40000 ALTER TABLE `user_groups` DISABLE KEYS */;
1838/*!40000 ALTER TABLE `user_groups` ENABLE KEYS */;
1839UNLOCK TABLES;
1840
1841--
1842-- Table structure for table `user_privileges`
1843--
1844
1845DROP TABLE IF EXISTS `user_privileges`;
1846/*!40101 SET @saved_cs_client     = @@character_set_client */;
1847/*!40101 SET character_set_client = utf8 */;
1848CREATE TABLE `user_privileges` (
1849  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1850  `user_group_id` bigint(20) NOT NULL DEFAULT '0',
1851  `module_id` bigint(20) NOT NULL DEFAULT '0',
1852  `created_at` timestamp DEFAULT NOW(),
1853  `updated_at` timestamp NULL DEFAULT NULL,
1854  `deleted_at` timestamp NULL DEFAULT NULL,
1855  `restored_at` timestamp NULL DEFAULT NULL,
1856  `created_by` bigint(20) DEFAULT NULL,
1857  `updated_by` bigint(20) DEFAULT NULL,
1858  `deleted_by` bigint(20) DEFAULT NULL,
1859  `restored_by` bigint(20) DEFAULT NULL,
1860  `is_deleted` enum('true','false') DEFAULT 'false',
1861  PRIMARY KEY (`id`),
1862  UNIQUE KEY `unique_field` (`user_group_id`,`module_id`),
1863  KEY `user_privileges_user_group_id__idx` (`user_group_id`) USING BTREE,
1864  KEY `user_privileges_module_id__idx` (`module_id`) USING BTREE
1865) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1866/*!40101 SET character_set_client = @saved_cs_client */;
1867
1868--
1869-- Dumping data for table `user_privileges`
1870--
1871
1872LOCK TABLES `user_privileges` WRITE;
1873/*!40000 ALTER TABLE `user_privileges` DISABLE KEYS */;
1874/*!40000 ALTER TABLE `user_privileges` ENABLE KEYS */;
1875UNLOCK TABLES;
1876
1877--
1878-- Table structure for table `users`
1879--
1880
1881DROP TABLE IF EXISTS `users`;
1882/*!40101 SET @saved_cs_client     = @@character_set_client */;
1883/*!40101 SET character_set_client = utf8 */;
1884CREATE TABLE `users` (
1885  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1886  `user_name` varchar(60) NOT NULL,
1887  `user_password` varchar(100) NOT NULL,
1888  `user_full_name` varchar(100) DEFAULT NULL,
1889  `user_email` varchar(100) DEFAULT NULL,
1890  `user_url` varchar(100) DEFAULT NULL,
1891  `user_registered` datetime DEFAULT NULL,
1892  `user_group_id` bigint(20) NOT NULL DEFAULT '0',
1893  `user_type` enum('super_user','administrator','employee','student') NOT NULL DEFAULT 'administrator',
1894  `user_profile_id` bigint(20) unsigned DEFAULT NULL COMMENT 'student_id OR employee_id',
1895  `user_biography` text,
1896  `user_forgot_password_key` varchar(100) DEFAULT NULL,
1897  `user_forgot_password_request_date` date DEFAULT NULL,
1898  `is_logged_in` enum('true','false') DEFAULT 'false',
1899  `last_logged_in` datetime DEFAULT NULL,
1900  `ip_address` varchar(45) DEFAULT NULL,
1901  `created_at` timestamp DEFAULT NOW(),
1902  `updated_at` timestamp NULL DEFAULT NULL,
1903  `deleted_at` timestamp NULL DEFAULT NULL,
1904  `restored_at` timestamp NULL DEFAULT NULL,
1905  `created_by` bigint(20) DEFAULT NULL,
1906  `updated_by` bigint(20) DEFAULT NULL,
1907  `deleted_by` bigint(20) DEFAULT NULL,
1908  `restored_by` bigint(20) DEFAULT NULL,
1909  `is_deleted` enum('true','false') DEFAULT 'false',
1910  PRIMARY KEY (`id`),
1911  UNIQUE KEY `user_name` (`user_name`),
1912  UNIQUE KEY `user_email` (`user_email`),
1913  UNIQUE KEY `user_url` (`user_url`),
1914  KEY `users_user_group_id__idx` (`user_group_id`) USING BTREE,
1915  KEY `users_user_profile_id__idx` (`user_profile_id`) USING BTREE
1916) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
1917/*!40101 SET character_set_client = @saved_cs_client */;
1918
1919--
1920-- Dumping data for table `users`
1921--
1922
1923LOCK TABLES `users` WRITE;
1924/*!40000 ALTER TABLE `users` DISABLE KEYS */;
1925INSERT INTO `users` VALUES (1,'administrator','$2y$10$UGpxUgB8Q03HicvG475vW.yrWn1rCyDmBod9b33llytSule6G6HLG','Administrator','admin@admin.com','sekolahku.web.id','2018-10-22 12:04:40',0,'super_user',NULL,NULL,NULL,NULL,'false',NULL,NULL,'2018-10-22 05:04:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false');
1926/*!40000 ALTER TABLE `users` ENABLE KEYS */;
1927UNLOCK TABLES;
1928/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1929
1930/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1931/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1932/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1933/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1934/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1935/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1936/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1937
1938-- Dump completed on 2018-10-22 12:05:09