URUbyMig

1-- MySQL dump 10.13  Distrib 5.7.24, for Linux (x86_64)
2--
3-- Host: localhost    Database: db_cms_sekolahku
4-- ------------------------------------------------------
5-- Server version	5.7.24-0ubuntu0.16.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` datetime DEFAULT NULL,
57  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
58  `deleted_at` datetime DEFAULT NULL,
59  `restored_at` datetime DEFAULT NULL,
60  `created_by` bigint(20) DEFAULT '0',
61  `updated_by` bigint(20) DEFAULT '0',
62  `deleted_by` bigint(20) DEFAULT '0',
63  `restored_by` bigint(20) DEFAULT '0',
64  `is_deleted` enum('true','false') DEFAULT 'false',
65  PRIMARY KEY (`id`),
66  UNIQUE KEY `academic_year` (`academic_year`)
67) ENGINE=InnoDB 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 */;
76/*!40000 ALTER TABLE `academic_years` ENABLE KEYS */;
77UNLOCK TABLES;
78
79--
80-- Table structure for table `achievements`
81--
82
83DROP TABLE IF EXISTS `achievements`;
84/*!40101 SET @saved_cs_client     = @@character_set_client */;
85/*!40101 SET character_set_client = utf8 */;
86CREATE TABLE `achievements` (
87  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
88  `student_id` bigint(20) NOT NULL DEFAULT '0',
89  `description` varchar(255) NOT NULL,
90  `type` bigint(20) NOT NULL DEFAULT '0',
91  `level` smallint(6) NOT NULL DEFAULT '0',
92  `year` year(4) NOT NULL DEFAULT '0000',
93  `organizer` varchar(255) NOT NULL,
94  `created_at` datetime DEFAULT NULL,
95  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
96  `deleted_at` datetime DEFAULT NULL,
97  `restored_at` datetime DEFAULT NULL,
98  `created_by` bigint(20) DEFAULT '0',
99  `updated_by` bigint(20) DEFAULT '0',
100  `deleted_by` bigint(20) DEFAULT '0',
101  `restored_by` bigint(20) DEFAULT '0',
102  `is_deleted` enum('true','false') DEFAULT 'false',
103  PRIMARY KEY (`id`),
104  KEY `achievements_student_id__idx` (`student_id`) USING BTREE
105) ENGINE=InnoDB DEFAULT CHARSET=utf8;
106/*!40101 SET character_set_client = @saved_cs_client */;
107
108--
109-- Dumping data for table `achievements`
110--
111
112LOCK TABLES `achievements` WRITE;
113/*!40000 ALTER TABLE `achievements` DISABLE KEYS */;
114/*!40000 ALTER TABLE `achievements` ENABLE KEYS */;
115UNLOCK TABLES;
116
117--
118-- Table structure for table `admission_phases`
119--
120
121DROP TABLE IF EXISTS `admission_phases`;
122/*!40101 SET @saved_cs_client     = @@character_set_client */;
123/*!40101 SET character_set_client = utf8 */;
124CREATE TABLE `admission_phases` (
125  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
126  `year` year(4) NOT NULL DEFAULT '0000' COMMENT 'Tahun PPDB',
127  `phase` varchar(255) NOT NULL COMMENT 'Gelombang / Fase Pendaftaran',
128  `start_date` date DEFAULT NULL COMMENT 'Tanggal Mulai',
129  `end_date` date DEFAULT NULL COMMENT 'Tanggal Selesai',
130  `created_at` datetime DEFAULT NULL,
131  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
132  `deleted_at` datetime DEFAULT NULL,
133  `restored_at` datetime DEFAULT NULL,
134  `created_by` bigint(20) DEFAULT '0',
135  `updated_by` bigint(20) DEFAULT '0',
136  `deleted_by` bigint(20) DEFAULT '0',
137  `restored_by` bigint(20) DEFAULT '0',
138  `is_deleted` enum('true','false') DEFAULT 'false',
139  PRIMARY KEY (`id`),
140  UNIQUE KEY `unique_field` (`year`,`phase`)
141) ENGINE=InnoDB DEFAULT CHARSET=utf8;
142/*!40101 SET character_set_client = @saved_cs_client */;
143
144--
145-- Dumping data for table `admission_phases`
146--
147
148LOCK TABLES `admission_phases` WRITE;
149/*!40000 ALTER TABLE `admission_phases` DISABLE KEYS */;
150/*!40000 ALTER TABLE `admission_phases` ENABLE KEYS */;
151UNLOCK TABLES;
152
153--
154-- Table structure for table `admission_quotas`
155--
156
157DROP TABLE IF EXISTS `admission_quotas`;
158/*!40101 SET @saved_cs_client     = @@character_set_client */;
159/*!40101 SET character_set_client = utf8 */;
160CREATE TABLE `admission_quotas` (
161  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
162  `year` year(4) NOT NULL DEFAULT '0000' COMMENT 'Tahun PPDB',
163  `major_id` bigint(20) DEFAULT '0' COMMENT 'Program Keahlian',
164  `quota` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Kuota yang diterima secara keseluruhan',
165  `created_at` datetime DEFAULT NULL,
166  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
167  `deleted_at` datetime DEFAULT NULL,
168  `restored_at` datetime DEFAULT NULL,
169  `created_by` bigint(20) DEFAULT '0',
170  `updated_by` bigint(20) DEFAULT '0',
171  `deleted_by` bigint(20) DEFAULT '0',
172  `restored_by` bigint(20) DEFAULT '0',
173  `is_deleted` enum('true','false') DEFAULT 'false',
174  PRIMARY KEY (`id`),
175  UNIQUE KEY `unique_field` (`year`,`major_id`,`quota`),
176  KEY `registration_student_id__idx` (`major_id`) USING BTREE
177) ENGINE=InnoDB DEFAULT CHARSET=utf8;
178/*!40101 SET character_set_client = @saved_cs_client */;
179
180--
181-- Dumping data for table `admission_quotas`
182--
183
184LOCK TABLES `admission_quotas` WRITE;
185/*!40000 ALTER TABLE `admission_quotas` DISABLE KEYS */;
186/*!40000 ALTER TABLE `admission_quotas` ENABLE KEYS */;
187UNLOCK TABLES;
188
189--
190-- Table structure for table `admission_types`
191--
192
193DROP TABLE IF EXISTS `admission_types`;
194/*!40101 SET @saved_cs_client     = @@character_set_client */;
195/*!40101 SET character_set_client = utf8 */;
196CREATE TABLE `admission_types` (
197  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
198  `admission_type` varchar(255) NOT NULL,
199  `created_at` datetime DEFAULT NULL,
200  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
201  `deleted_at` datetime DEFAULT NULL,
202  `restored_at` datetime DEFAULT NULL,
203  `created_by` bigint(20) DEFAULT '0',
204  `updated_by` bigint(20) DEFAULT '0',
205  `deleted_by` bigint(20) DEFAULT '0',
206  `restored_by` bigint(20) DEFAULT '0',
207  `is_deleted` enum('true','false') DEFAULT 'false',
208  PRIMARY KEY (`id`),
209  UNIQUE KEY `admission_type` (`admission_type`)
210) ENGINE=InnoDB DEFAULT CHARSET=utf8;
211/*!40101 SET character_set_client = @saved_cs_client */;
212
213--
214-- Dumping data for table `admission_types`
215--
216
217LOCK TABLES `admission_types` WRITE;
218/*!40000 ALTER TABLE `admission_types` DISABLE KEYS */;
219/*!40000 ALTER TABLE `admission_types` ENABLE KEYS */;
220UNLOCK TABLES;
221
222--
223-- Table structure for table `albums`
224--
225
226DROP TABLE IF EXISTS `albums`;
227/*!40101 SET @saved_cs_client     = @@character_set_client */;
228/*!40101 SET character_set_client = utf8 */;
229CREATE TABLE `albums` (
230  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
231  `album_title` varchar(255) NOT NULL,
232  `album_description` varchar(255) DEFAULT NULL,
233  `album_slug` varchar(255) DEFAULT NULL,
234  `album_cover` varchar(100) DEFAULT NULL,
235  `created_at` datetime DEFAULT NULL,
236  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
237  `deleted_at` datetime DEFAULT NULL,
238  `restored_at` datetime DEFAULT NULL,
239  `created_by` bigint(20) DEFAULT '0',
240  `updated_by` bigint(20) DEFAULT '0',
241  `deleted_by` bigint(20) DEFAULT '0',
242  `restored_by` bigint(20) DEFAULT '0',
243  `is_deleted` enum('true','false') DEFAULT 'false',
244  PRIMARY KEY (`id`),
245  UNIQUE KEY `album_title` (`album_title`)
246) ENGINE=InnoDB DEFAULT CHARSET=utf8;
247/*!40101 SET character_set_client = @saved_cs_client */;
248
249--
250-- Dumping data for table `albums`
251--
252
253LOCK TABLES `albums` WRITE;
254/*!40000 ALTER TABLE `albums` DISABLE KEYS */;
255/*!40000 ALTER TABLE `albums` ENABLE KEYS */;
256UNLOCK TABLES;
257
258--
259-- Table structure for table `answers`
260--
261
262DROP TABLE IF EXISTS `answers`;
263/*!40101 SET @saved_cs_client     = @@character_set_client */;
264/*!40101 SET character_set_client = utf8 */;
265CREATE TABLE `answers` (
266  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
267  `question_id` bigint(20) DEFAULT '0',
268  `answer` varchar(255) DEFAULT NULL,
269  `created_at` datetime DEFAULT NULL,
270  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
271  `deleted_at` datetime DEFAULT NULL,
272  `restored_at` datetime DEFAULT NULL,
273  `created_by` bigint(20) DEFAULT '0',
274  `updated_by` bigint(20) DEFAULT '0',
275  `deleted_by` bigint(20) DEFAULT '0',
276  `restored_by` bigint(20) DEFAULT '0',
277  `is_deleted` enum('true','false') DEFAULT 'false',
278  PRIMARY KEY (`id`),
279  UNIQUE KEY `unique_field` (`question_id`,`answer`),
280  KEY `answers_question_id__idx` (`question_id`) USING BTREE
281) ENGINE=InnoDB DEFAULT CHARSET=utf8;
282/*!40101 SET character_set_client = @saved_cs_client */;
283
284--
285-- Dumping data for table `answers`
286--
287
288LOCK TABLES `answers` WRITE;
289/*!40000 ALTER TABLE `answers` DISABLE KEYS */;
290/*!40000 ALTER TABLE `answers` ENABLE KEYS */;
291UNLOCK TABLES;
292
293--
294-- Table structure for table `banners`
295--
296
297DROP TABLE IF EXISTS `banners`;
298/*!40101 SET @saved_cs_client     = @@character_set_client */;
299/*!40101 SET character_set_client = utf8 */;
300CREATE TABLE `banners` (
301  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
302  `title` varchar(255) NOT NULL,
303  `url` varchar(255) DEFAULT NULL,
304  `target` enum('_blank','_self','_parent','_top') DEFAULT '_blank',
305  `image` varchar(255) DEFAULT NULL,
306  `created_at` datetime DEFAULT NULL,
307  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
308  `deleted_at` datetime DEFAULT NULL,
309  `restored_at` datetime DEFAULT NULL,
310  `created_by` bigint(20) DEFAULT '0',
311  `updated_by` bigint(20) DEFAULT '0',
312  `deleted_by` bigint(20) DEFAULT '0',
313  `restored_by` bigint(20) DEFAULT '0',
314  `is_deleted` enum('true','false') DEFAULT 'false',
315  PRIMARY KEY (`id`),
316  UNIQUE KEY `url` (`url`)
317) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
318/*!40101 SET character_set_client = @saved_cs_client */;
319
320--
321-- Dumping data for table `banners`
322--
323
324LOCK TABLES `banners` WRITE;
325/*!40000 ALTER TABLE `banners` DISABLE KEYS */;
326INSERT INTO `banners` VALUES (1,'CMS Sekolahku','http://sekolahku.web.id','_blank','1.png','2018-12-24 12:02:00','2018-12-24 05:02:00',NULL,NULL,0,0,0,0,'false'),(2,'President University','http://president.ac.id','_blank','2.png','2018-12-24 12:02:00','2018-12-24 05:02:00',NULL,NULL,0,0,0,0,'false');
327/*!40000 ALTER TABLE `banners` ENABLE KEYS */;
328UNLOCK TABLES;
329
330--
331-- Table structure for table `class_group_settings`
332--
333
334DROP TABLE IF EXISTS `class_group_settings`;
335/*!40101 SET @saved_cs_client     = @@character_set_client */;
336/*!40101 SET character_set_client = utf8 */;
337CREATE TABLE `class_group_settings` (
338  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
339  `academic_year_id` bigint(20) NOT NULL DEFAULT '0',
340  `class_group_id` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Kelas',
341  `student_id` bigint(20) NOT NULL DEFAULT '0',
342  `created_at` datetime DEFAULT NULL,
343  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
344  `deleted_at` datetime DEFAULT NULL,
345  `restored_at` datetime DEFAULT NULL,
346  `created_by` bigint(20) DEFAULT '0',
347  `updated_by` bigint(20) DEFAULT '0',
348  `deleted_by` bigint(20) DEFAULT '0',
349  `restored_by` bigint(20) DEFAULT '0',
350  `is_deleted` enum('true','false') DEFAULT 'false',
351  PRIMARY KEY (`id`),
352  UNIQUE KEY `unique_field` (`academic_year_id`,`student_id`),
353  KEY `class_group_settings_academic_year_id__idx` (`academic_year_id`) USING BTREE,
354  KEY `class_group_settings_class_group_id__idx` (`class_group_id`) USING BTREE,
355  KEY `class_group_settings_student_id__idx` (`student_id`) USING BTREE
356) ENGINE=InnoDB DEFAULT CHARSET=utf8;
357/*!40101 SET character_set_client = @saved_cs_client */;
358
359--
360-- Dumping data for table `class_group_settings`
361--
362
363LOCK TABLES `class_group_settings` WRITE;
364/*!40000 ALTER TABLE `class_group_settings` DISABLE KEYS */;
365/*!40000 ALTER TABLE `class_group_settings` ENABLE KEYS */;
366UNLOCK TABLES;
367
368--
369-- Table structure for table `class_groups`
370--
371
372DROP TABLE IF EXISTS `class_groups`;
373/*!40101 SET @saved_cs_client     = @@character_set_client */;
374/*!40101 SET character_set_client = utf8 */;
375CREATE TABLE `class_groups` (
376  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
377  `class` varchar(100) DEFAULT NULL,
378  `sub_class` varchar(100) DEFAULT NULL,
379  `major_id` bigint(20) DEFAULT '0',
380  `created_at` datetime DEFAULT NULL,
381  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
382  `deleted_at` datetime DEFAULT NULL,
383  `restored_at` datetime DEFAULT NULL,
384  `created_by` bigint(20) DEFAULT '0',
385  `updated_by` bigint(20) DEFAULT '0',
386  `deleted_by` bigint(20) DEFAULT '0',
387  `restored_by` bigint(20) DEFAULT '0',
388  `is_deleted` enum('true','false') DEFAULT 'false',
389  PRIMARY KEY (`id`),
390  UNIQUE KEY `unique_field` (`class`,`sub_class`,`major_id`),
391  KEY `class_groups_major_id__idx` (`major_id`) USING BTREE
392) ENGINE=InnoDB DEFAULT CHARSET=utf8;
393/*!40101 SET character_set_client = @saved_cs_client */;
394
395--
396-- Dumping data for table `class_groups`
397--
398
399LOCK TABLES `class_groups` WRITE;
400/*!40000 ALTER TABLE `class_groups` DISABLE KEYS */;
401/*!40000 ALTER TABLE `class_groups` ENABLE KEYS */;
402UNLOCK TABLES;
403
404--
405-- Table structure for table `comments`
406--
407
408DROP TABLE IF EXISTS `comments`;
409/*!40101 SET @saved_cs_client     = @@character_set_client */;
410/*!40101 SET character_set_client = utf8 */;
411CREATE TABLE `comments` (
412  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
413  `comment_post_id` bigint(20) NOT NULL DEFAULT '0',
414  `comment_author` varchar(255) NOT NULL,
415  `comment_email` varchar(255) DEFAULT NULL,
416  `comment_url` varchar(255) DEFAULT NULL,
417  `comment_ip` varchar(255) NOT NULL,
418  `comment_content` text NOT NULL,
419  `comment_subject` varchar(255) DEFAULT NULL,
420  `comment_reply` text,
421  `comment_status` enum('approved','unapproved','spam') DEFAULT 'approved',
422  `comment_agent` varchar(255) DEFAULT NULL,
423  `parent_id` varchar(255) DEFAULT NULL,
424  `comment_type` enum('post','message') DEFAULT 'post',
425  `created_at` datetime DEFAULT NULL,
426  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
427  `deleted_at` datetime DEFAULT NULL,
428  `restored_at` datetime DEFAULT NULL,
429  `created_by` bigint(20) DEFAULT '0',
430  `updated_by` bigint(20) DEFAULT '0',
431  `deleted_by` bigint(20) DEFAULT '0',
432  `restored_by` bigint(20) DEFAULT '0',
433  `is_deleted` enum('true','false') DEFAULT 'false',
434  PRIMARY KEY (`id`),
435  KEY `comments_comment_post_id__idx` (`comment_post_id`) USING BTREE
436) ENGINE=InnoDB DEFAULT CHARSET=utf8;
437/*!40101 SET character_set_client = @saved_cs_client */;
438
439--
440-- Dumping data for table `comments`
441--
442
443LOCK TABLES `comments` WRITE;
444/*!40000 ALTER TABLE `comments` DISABLE KEYS */;
445/*!40000 ALTER TABLE `comments` ENABLE KEYS */;
446UNLOCK TABLES;
447
448--
449-- Table structure for table `employees`
450--
451
452DROP TABLE IF EXISTS `employees`;
453/*!40101 SET @saved_cs_client     = @@character_set_client */;
454/*!40101 SET character_set_client = utf8 */;
455CREATE TABLE `employees` (
456  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
457  `assignment_letter_number` varchar(255) DEFAULT NULL COMMENT 'Nomor Surat Tugas',
458  `assignment_letter_date` date DEFAULT NULL COMMENT 'Tanggal Surat Tugas',
459  `assignment_start_date` date DEFAULT NULL COMMENT 'TMT Tugas',
460  `parent_school_status` enum('true','false') NOT NULL DEFAULT 'true' COMMENT 'Status Sekolah Induk',
461  `full_name` varchar(150) NOT NULL,
462  `gender` enum('M','F') NOT NULL DEFAULT 'M',
463  `nik` varchar(50) DEFAULT NULL,
464  `birth_place` varchar(255) DEFAULT NULL,
465  `birth_date` date DEFAULT NULL,
466  `mother_name` varchar(150) DEFAULT NULL,
467  `street_address` varchar(255) DEFAULT NULL COMMENT 'Alamat Jalan',
468  `rt` varchar(10) DEFAULT NULL COMMENT 'Rukun Tetangga',
469  `rw` varchar(10) DEFAULT NULL COMMENT 'Rukun Warga',
470  `sub_village` varchar(255) DEFAULT NULL COMMENT 'Nama Dusun',
471  `village` varchar(255) DEFAULT NULL COMMENT 'Nama Kelurahan/ Desa',
472  `sub_district` varchar(255) DEFAULT NULL COMMENT 'Kecamatan',
473  `district` varchar(255) DEFAULT NULL COMMENT 'Kabupaten',
474  `postal_code` varchar(20) DEFAULT NULL COMMENT 'Kode POS',
475  `religion_id` bigint(20) DEFAULT '0',
476  `marriage_status_id` bigint(20) DEFAULT '0',
477  `spouse_name` varchar(255) DEFAULT NULL COMMENT 'Nama Pasangan : Suami / Istri',
478  `spouse_employment_id` bigint(20) DEFAULT '0' COMMENT 'Pekerjaan Pasangan : Suami / Istri',
479  `citizenship` enum('WNI','WNA') NOT NULL DEFAULT 'WNI' COMMENT 'Kewarganegaraan',
480  `country` varchar(255) DEFAULT NULL,
481  `npwp` varchar(100) DEFAULT NULL,
482  `employment_status_id` bigint(20) DEFAULT '0' COMMENT 'Status Kepegawaian',
483  `nip` varchar(100) DEFAULT NULL,
484  `niy` varchar(100) DEFAULT NULL COMMENT 'NIY/NIGK',
485  `nuptk` varchar(100) DEFAULT NULL,
486  `employment_type_id` bigint(20) DEFAULT '0' COMMENT 'Jenis Guru dan Tenaga Kependidikan (GTK)',
487  `decree_appointment` varchar(255) DEFAULT NULL COMMENT 'SK Pengangkatan',
488  `appointment_start_date` date DEFAULT NULL COMMENT 'TMT Pengangkatan',
489  `institution_lifter_id` bigint(20) DEFAULT '0' COMMENT 'Lembaga Pengangkat',
490  `decree_cpns` varchar(100) DEFAULT NULL COMMENT 'SK CPNS',
491  `pns_start_date` date DEFAULT NULL COMMENT 'TMT CPNS',
492  `rank_id` bigint(20) DEFAULT '0' COMMENT 'Pangkat / Golongan',
493  `salary_source_id` bigint(20) DEFAULT '0' COMMENT 'Sumber Gaji',
494  `headmaster_license` enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'Punya Lisensi Kepala Sekolah ?',
495  `laboratory_skill_id` bigint(20) DEFAULT '0' COMMENT 'Keahlian Laboratorium',
496  `special_need_id` bigint(20) DEFAULT '0' COMMENT 'Mampu Menangani Kebutuhan Khusus',
497  `braille_skills` enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'Keahlian Braile ?',
498  `sign_language_skills` enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'Keahlian Bahasa Isyarat ?',
499  `phone` varchar(255) DEFAULT NULL,
500  `mobile_phone` varchar(255) DEFAULT NULL,
501  `email` varchar(255) DEFAULT NULL,
502  `photo` varchar(100) DEFAULT NULL,
503  `created_at` datetime DEFAULT NULL,
504  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
505  `deleted_at` datetime DEFAULT NULL,
506  `restored_at` datetime DEFAULT NULL,
507  `created_by` bigint(20) DEFAULT '0',
508  `updated_by` bigint(20) DEFAULT '0',
509  `deleted_by` bigint(20) DEFAULT '0',
510  `restored_by` bigint(20) DEFAULT '0',
511  `is_deleted` enum('true','false') DEFAULT 'false',
512  PRIMARY KEY (`id`),
513  UNIQUE KEY `nik` (`nik`),
514  UNIQUE KEY `email` (`email`),
515  KEY `employees_nik__idx` (`nik`) USING BTREE,
516  KEY `employees_full_name__idx` (`full_name`) USING BTREE,
517  KEY `employees_email__idx` (`email`) USING BTREE,
518  KEY `employees_religion_id__idx` (`religion_id`) USING BTREE,
519  KEY `employees_marriage_status_id__idx` (`marriage_status_id`) USING BTREE,
520  KEY `employees_spouse_employment_id__idx` (`spouse_employment_id`) USING BTREE,
521  KEY `employees_employment_status_id__idx` (`employment_status_id`) USING BTREE,
522  KEY `employees_employment_type_id__idx` (`employment_type_id`) USING BTREE,
523  KEY `employees_institution_lifter_id__idx` (`institution_lifter_id`) USING BTREE,
524  KEY `employees_rank_id__idx` (`rank_id`) USING BTREE,
525  KEY `employees_salary_source_id__idx` (`salary_source_id`) USING BTREE,
526  KEY `employees_laboratory_skill_id__idx` (`laboratory_skill_id`) USING BTREE,
527  KEY `employees_special_need_id__idx` (`special_need_id`) USING BTREE
528) ENGINE=InnoDB DEFAULT CHARSET=utf8;
529/*!40101 SET character_set_client = @saved_cs_client */;
530
531--
532-- Dumping data for table `employees`
533--
534
535LOCK TABLES `employees` WRITE;
536/*!40000 ALTER TABLE `employees` DISABLE KEYS */;
537/*!40000 ALTER TABLE `employees` ENABLE KEYS */;
538UNLOCK TABLES;
539
540--
541-- Table structure for table `file_categories`
542--
543
544DROP TABLE IF EXISTS `file_categories`;
545/*!40101 SET @saved_cs_client     = @@character_set_client */;
546/*!40101 SET character_set_client = utf8 */;
547CREATE TABLE `file_categories` (
548  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
549  `category` varchar(255) NOT NULL,
550  `slug` varchar(255) DEFAULT NULL,
551  `description` varchar(255) DEFAULT NULL,
552  `created_at` datetime DEFAULT NULL,
553  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
554  `deleted_at` datetime DEFAULT NULL,
555  `restored_at` datetime DEFAULT NULL,
556  `created_by` bigint(20) DEFAULT '0',
557  `updated_by` bigint(20) DEFAULT '0',
558  `deleted_by` bigint(20) DEFAULT '0',
559  `restored_by` bigint(20) DEFAULT '0',
560  `is_deleted` enum('true','false') DEFAULT 'false',
561  PRIMARY KEY (`id`),
562  UNIQUE KEY `category` (`category`)
563) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
564/*!40101 SET character_set_client = @saved_cs_client */;
565
566--
567-- Dumping data for table `file_categories`
568--
569
570LOCK TABLES `file_categories` WRITE;
571/*!40000 ALTER TABLE `file_categories` DISABLE KEYS */;
572INSERT INTO `file_categories` VALUES (1,'Uncategorized','uncategorized','Uncategorized','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false');
573/*!40000 ALTER TABLE `file_categories` ENABLE KEYS */;
574UNLOCK TABLES;
575
576--
577-- Table structure for table `files`
578--
579
580DROP TABLE IF EXISTS `files`;
581/*!40101 SET @saved_cs_client     = @@character_set_client */;
582/*!40101 SET character_set_client = utf8 */;
583CREATE TABLE `files` (
584  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
585  `file_title` varchar(255) DEFAULT NULL,
586  `file_description` varchar(255) DEFAULT NULL,
587  `file_name` varchar(255) DEFAULT NULL,
588  `file_type` varchar(255) DEFAULT NULL,
589  `file_category_id` bigint(20) NOT NULL DEFAULT '0',
590  `file_path` varchar(255) DEFAULT NULL,
591  `file_ext` varchar(255) DEFAULT NULL,
592  `file_size` varchar(255) DEFAULT NULL,
593  `file_visibility` enum('public','private') DEFAULT 'public',
594  `file_counter` bigint(20) NOT NULL DEFAULT '0',
595  `created_at` datetime DEFAULT NULL,
596  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
597  `deleted_at` datetime DEFAULT NULL,
598  `restored_at` datetime DEFAULT NULL,
599  `created_by` bigint(20) DEFAULT '0',
600  `updated_by` bigint(20) DEFAULT '0',
601  `deleted_by` bigint(20) DEFAULT '0',
602  `restored_by` bigint(20) DEFAULT '0',
603  `is_deleted` enum('true','false') DEFAULT 'false',
604  PRIMARY KEY (`id`),
605  KEY `files_file_category_id__idx` (`file_category_id`) USING BTREE
606) ENGINE=InnoDB DEFAULT CHARSET=utf8;
607/*!40101 SET character_set_client = @saved_cs_client */;
608
609--
610-- Dumping data for table `files`
611--
612
613LOCK TABLES `files` WRITE;
614/*!40000 ALTER TABLE `files` DISABLE KEYS */;
615/*!40000 ALTER TABLE `files` ENABLE KEYS */;
616UNLOCK TABLES;
617
618--
619-- Table structure for table `image_sliders`
620--
621
622DROP TABLE IF EXISTS `image_sliders`;
623/*!40101 SET @saved_cs_client     = @@character_set_client */;
624/*!40101 SET character_set_client = utf8 */;
625CREATE TABLE `image_sliders` (
626  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
627  `caption` varchar(255) NOT NULL,
628  `image` varchar(255) DEFAULT NULL,
629  `created_at` datetime DEFAULT NULL,
630  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
631  `deleted_at` datetime DEFAULT NULL,
632  `restored_at` datetime DEFAULT NULL,
633  `created_by` bigint(20) DEFAULT '0',
634  `updated_by` bigint(20) DEFAULT '0',
635  `deleted_by` bigint(20) DEFAULT '0',
636  `restored_by` bigint(20) DEFAULT '0',
637  `is_deleted` enum('true','false') DEFAULT 'false',
638  PRIMARY KEY (`id`)
639) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
640/*!40101 SET character_set_client = @saved_cs_client */;
641
642--
643-- Dumping data for table `image_sliders`
644--
645
646LOCK TABLES `image_sliders` WRITE;
647/*!40000 ALTER TABLE `image_sliders` DISABLE KEYS */;
648INSERT 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-12-24 12:02:00','2018-12-24 05:02:00',NULL,NULL,0,0,0,0,'false'),(2,'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua','2.png','2018-12-24 12:02:00','2018-12-24 05:02:00',NULL,NULL,0,0,0,0,'false');
649/*!40000 ALTER TABLE `image_sliders` ENABLE KEYS */;
650UNLOCK TABLES;
651
652--
653-- Table structure for table `links`
654--
655
656DROP TABLE IF EXISTS `links`;
657/*!40101 SET @saved_cs_client     = @@character_set_client */;
658/*!40101 SET character_set_client = utf8 */;
659CREATE TABLE `links` (
660  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
661  `title` varchar(255) NOT NULL,
662  `url` varchar(255) DEFAULT NULL,
663  `target` enum('_blank','_self','_parent','_top') DEFAULT '_blank',
664  `created_at` datetime DEFAULT NULL,
665  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
666  `deleted_at` datetime DEFAULT NULL,
667  `restored_at` datetime DEFAULT NULL,
668  `created_by` bigint(20) DEFAULT '0',
669  `updated_by` bigint(20) DEFAULT '0',
670  `deleted_by` bigint(20) DEFAULT '0',
671  `restored_by` bigint(20) DEFAULT '0',
672  `is_deleted` enum('true','false') DEFAULT 'false',
673  PRIMARY KEY (`id`),
674  UNIQUE KEY `url` (`url`)
675) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
676/*!40101 SET character_set_client = @saved_cs_client */;
677
678--
679-- Dumping data for table `links`
680--
681
682LOCK TABLES `links` WRITE;
683/*!40000 ALTER TABLE `links` DISABLE KEYS */;
684INSERT INTO `links` VALUES (1,'CMS Sekolahku','http://sekolahku.web.id','_blank','2018-12-24 12:02:00','2018-12-24 05:02:00',NULL,NULL,0,0,0,0,'false');
685/*!40000 ALTER TABLE `links` ENABLE KEYS */;
686UNLOCK TABLES;
687
688--
689-- Table structure for table `login_attempts`
690--
691
692DROP TABLE IF EXISTS `login_attempts`;
693/*!40101 SET @saved_cs_client     = @@character_set_client */;
694/*!40101 SET character_set_client = utf8 */;
695CREATE TABLE `login_attempts` (
696  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
697  `ip_address` varchar(45) NOT NULL,
698  `counter` int(11) unsigned NOT NULL DEFAULT '1',
699  `datetime` datetime DEFAULT NULL,
700  `created_at` datetime DEFAULT NULL,
701  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
702  `deleted_at` datetime DEFAULT NULL,
703  `restored_at` datetime DEFAULT NULL,
704  `created_by` bigint(20) DEFAULT '0',
705  `updated_by` bigint(20) DEFAULT '0',
706  `deleted_by` bigint(20) DEFAULT '0',
707  `restored_by` bigint(20) DEFAULT '0',
708  `is_deleted` enum('true','false') DEFAULT 'false',
709  PRIMARY KEY (`id`)
710) ENGINE=InnoDB DEFAULT CHARSET=utf8;
711/*!40101 SET character_set_client = @saved_cs_client */;
712
713--
714-- Dumping data for table `login_attempts`
715--
716
717LOCK TABLES `login_attempts` WRITE;
718/*!40000 ALTER TABLE `login_attempts` DISABLE KEYS */;
719/*!40000 ALTER TABLE `login_attempts` ENABLE KEYS */;
720UNLOCK TABLES;
721
722--
723-- Table structure for table `majors`
724--
725
726DROP TABLE IF EXISTS `majors`;
727/*!40101 SET @saved_cs_client     = @@character_set_client */;
728/*!40101 SET character_set_client = utf8 */;
729CREATE TABLE `majors` (
730  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
731  `major` varchar(255) DEFAULT NULL COMMENT 'Program Keahlian / Jurusan',
732  `short_name` varchar(255) DEFAULT NULL COMMENT 'Nama Singkat',
733  `created_at` datetime DEFAULT NULL,
734  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
735  `deleted_at` datetime DEFAULT NULL,
736  `restored_at` datetime DEFAULT NULL,
737  `created_by` bigint(20) DEFAULT '0',
738  `updated_by` bigint(20) DEFAULT '0',
739  `deleted_by` bigint(20) DEFAULT '0',
740  `restored_by` bigint(20) DEFAULT '0',
741  `is_deleted` enum('true','false') DEFAULT 'false',
742  PRIMARY KEY (`id`),
743  UNIQUE KEY `major` (`major`)
744) ENGINE=InnoDB DEFAULT CHARSET=utf8;
745/*!40101 SET character_set_client = @saved_cs_client */;
746
747--
748-- Dumping data for table `majors`
749--
750
751LOCK TABLES `majors` WRITE;
752/*!40000 ALTER TABLE `majors` DISABLE KEYS */;
753/*!40000 ALTER TABLE `majors` ENABLE KEYS */;
754UNLOCK TABLES;
755
756--
757-- Table structure for table `menus`
758--
759
760DROP TABLE IF EXISTS `menus`;
761/*!40101 SET @saved_cs_client     = @@character_set_client */;
762/*!40101 SET character_set_client = utf8 */;
763CREATE TABLE `menus` (
764  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
765  `menu_title` varchar(150) NOT NULL,
766  `menu_url` varchar(150) NOT NULL,
767  `menu_target` enum('_blank','_self','_parent','_top') DEFAULT '_self',
768  `menu_type` varchar(100) NOT NULL DEFAULT 'pages',
769  `parent_id` bigint(20) NOT NULL DEFAULT '0',
770  `position` bigint(20) NOT NULL DEFAULT '0',
771  `created_at` datetime DEFAULT NULL,
772  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
773  `deleted_at` datetime DEFAULT NULL,
774  `restored_at` datetime DEFAULT NULL,
775  `created_by` bigint(20) DEFAULT '0',
776  `updated_by` bigint(20) DEFAULT '0',
777  `deleted_by` bigint(20) DEFAULT '0',
778  `restored_by` bigint(20) DEFAULT '0',
779  `is_deleted` enum('true','false') DEFAULT 'false',
780  PRIMARY KEY (`id`)
781) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
782/*!40101 SET character_set_client = @saved_cs_client */;
783
784--
785-- Dumping data for table `menus`
786--
787
788LOCK TABLES `menus` WRITE;
789/*!40000 ALTER TABLE `menus` DISABLE KEYS */;
790INSERT INTO `menus` VALUES (1,'Hubungi Kami','hubungi-kami','_self','modules',0,4,'2018-12-24 12:02:01','2018-12-24 05:02:01',NULL,NULL,0,0,0,0,'false'),(2,'Gallery Photo','gallery-photo','_self','modules',9,1,'2018-12-24 12:02:01','2018-12-24 05:02:01',NULL,NULL,0,0,0,0,'false'),(3,'Gallery Video','gallery-video','_self','modules',9,2,'2018-12-24 12:02:01','2018-12-24 05:02:01',NULL,NULL,0,0,0,0,'false'),(4,'Formulir PPDB','formulir-penerimaan-peserta-didik-baru','_self','modules',8,1,'2018-12-24 12:02:01','2018-12-24 05:02:01',NULL,NULL,0,0,0,0,'false'),(5,'Hasil Seleksi','hasil-seleksi-penerimaan-peserta-didik-baru','_self','modules',8,2,'2018-12-24 12:02:01','2018-12-24 05:02:01',NULL,NULL,0,0,0,0,'false'),(6,'Cetak Formulir','cetak-formulir-penerimaan-peserta-didik-baru','_self','modules',8,3,'2018-12-24 12:02:01','2018-12-24 05:02:01',NULL,NULL,0,0,0,0,'false'),(7,'Download Formulir','download-formulir-penerimaan-peserta-didik-baru','_self','modules',8,4,'2018-12-24 12:02:01','2018-12-24 05:02:01',NULL,NULL,0,0,0,0,'false'),(8,'PPDB 2018','#','_self','links',0,2,'2018-12-24 12:02:01','2018-12-24 05:02:01',NULL,NULL,0,0,0,0,'false'),(9,'Gallery','#','_self','links',0,3,'2018-12-24 12:02:01','2018-12-24 05:02:01',NULL,NULL,0,0,0,0,'false'),(10,'Kategori','#','_self','links',0,1,'2018-12-24 12:02:01','2018-12-24 05:02:01',NULL,NULL,0,0,0,0,'false'),(11,'Uncategorized','category/uncategorized','_self','post_categories',10,1,'2018-12-24 12:02:01','2018-12-24 05:02:01',NULL,NULL,0,0,0,0,'false');
791/*!40000 ALTER TABLE `menus` ENABLE KEYS */;
792UNLOCK TABLES;
793
794--
795-- Table structure for table `modules`
796--
797
798DROP TABLE IF EXISTS `modules`;
799/*!40101 SET @saved_cs_client     = @@character_set_client */;
800/*!40101 SET character_set_client = utf8 */;
801CREATE TABLE `modules` (
802  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
803  `module_name` varchar(255) NOT NULL,
804  `module_description` varchar(255) DEFAULT NULL,
805  `module_url` varchar(255) DEFAULT NULL,
806  `is_active` enum('true','false') DEFAULT 'true',
807  `created_at` datetime DEFAULT NULL,
808  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
809  `deleted_at` datetime DEFAULT NULL,
810  `restored_at` datetime DEFAULT NULL,
811  `created_by` bigint(20) DEFAULT '0',
812  `updated_by` bigint(20) DEFAULT '0',
813  `deleted_by` bigint(20) DEFAULT '0',
814  `restored_by` bigint(20) DEFAULT '0',
815  `is_deleted` enum('true','false') DEFAULT 'false',
816  PRIMARY KEY (`id`),
817  UNIQUE KEY `module_name` (`module_name`)
818) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
819/*!40101 SET character_set_client = @saved_cs_client */;
820
821--
822-- Dumping data for table `modules`
823--
824
825LOCK TABLES `modules` WRITE;
826/*!40000 ALTER TABLE `modules` DISABLE KEYS */;
827INSERT INTO `modules` VALUES (1,'Pengguna','Pengguna','acl','true','2018-12-24 12:01:58','2018-12-24 05:01:58',NULL,NULL,0,0,0,0,'false'),(2,'PPDB / PMB','PPDB / PMB','admission','true','2018-12-24 12:01:58','2018-12-24 05:01:58',NULL,NULL,0,0,0,0,'false'),(3,'Tampilan','Tampilan','appearance','true','2018-12-24 12:01:58','2018-12-24 05:01:58',NULL,NULL,0,0,0,0,'false'),(4,'Blog','Blog','blog','true','2018-12-24 12:01:58','2018-12-24 05:01:58',NULL,NULL,0,0,0,0,'false'),(5,'GTK / Staff / Dosen','GTK / Staff / Dosen','employees','true','2018-12-24 12:01:58','2018-12-24 05:01:58',NULL,NULL,0,0,0,0,'false'),(6,'Media','Media','media','true','2018-12-24 12:01:58','2018-12-24 05:01:58',NULL,NULL,0,0,0,0,'false'),(7,'Plugins','Plugins','plugins','true','2018-12-24 12:01:58','2018-12-24 05:01:58',NULL,NULL,0,0,0,0,'false'),(8,'Data Referensi','Data Referensi','reference','true','2018-12-24 12:01:58','2018-12-24 05:01:58',NULL,NULL,0,0,0,0,'false'),(9,'Pengaturan','Pengaturan','settings','true','2018-12-24 12:01:58','2018-12-24 05:01:58',NULL,NULL,0,0,0,0,'false'),(10,'Peserta Didik / Mahasiswa','Peserta Didik / Mahasiswa','students','true','2018-12-24 12:01:58','2018-12-24 05:01:58',NULL,NULL,0,0,0,0,'false');
828/*!40000 ALTER TABLE `modules` ENABLE KEYS */;
829UNLOCK TABLES;
830
831--
832-- Table structure for table `options`
833--
834
835DROP TABLE IF EXISTS `options`;
836/*!40101 SET @saved_cs_client     = @@character_set_client */;
837/*!40101 SET character_set_client = utf8 */;
838CREATE TABLE `options` (
839  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
840  `option_name` varchar(255) NOT NULL,
841  `option_type` varchar(100) NOT NULL,
842  `created_at` datetime DEFAULT NULL,
843  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
844  `deleted_at` datetime DEFAULT NULL,
845  `restored_at` datetime DEFAULT NULL,
846  `created_by` bigint(20) DEFAULT '0',
847  `updated_by` bigint(20) DEFAULT '0',
848  `deleted_by` bigint(20) DEFAULT '0',
849  `restored_by` bigint(20) DEFAULT '0',
850  `is_deleted` enum('true','false') NOT NULL DEFAULT 'false',
851  PRIMARY KEY (`id`),
852  UNIQUE KEY `unique_field` (`option_name`,`option_type`)
853) ENGINE=InnoDB AUTO_INCREMENT=170 DEFAULT CHARSET=utf8;
854/*!40101 SET character_set_client = @saved_cs_client */;
855
856--
857-- Dumping data for table `options`
858--
859
860LOCK TABLES `options` WRITE;
861/*!40000 ALTER TABLE `options` DISABLE KEYS */;
862INSERT INTO `options` VALUES (1,'Aktif','student_status','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(2,'Lulus','student_status','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(3,'Mutasi','student_status','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(4,'Dikeluarkan','student_status','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(5,'Mengundurkan Diri','student_status','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(6,'Putus Sekolah','student_status','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(7,'Meninggal','student_status','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(8,'Hilang','student_status','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(9,'Lainnya','student_status','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(10,'Tidak bekerja','employment','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(11,'Nelayan','employment','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(12,'Petani','employment','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(13,'Peternak','employment','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(14,'PNS/TNI/POLRI','employment','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(15,'Karyawan Swasta','employment','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(16,'Pedagang Kecil','employment','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(17,'Pedagang Besar','employment','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(18,'Wiraswasta','employment','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(19,'Wirausaha','employment','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(20,'Buruh','employment','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(21,'Pensiunan','employment','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(22,'Lain-lain','employment','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(23,'Tidak','special_need','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(24,'Tuna Netra','special_need','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(25,'Tuna Rungu','special_need','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(26,'Tuna Grahita ringan','special_need','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(27,'Tuna Grahita Sedang','special_need','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(28,'Tuna Daksa Ringan','special_need','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(29,'Tuna Daksa Sedang','special_need','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(30,'Tuna Laras','special_need','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(31,'Tuna Wicara','special_need','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(32,'Tuna ganda','special_need','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(33,'Hiper aktif','special_need','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(34,'Cerdas Istimewa','special_need','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(35,'Bakat Istimewa','special_need','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(36,'Kesulitan Belajar','special_need','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(37,'Narkoba','special_need','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(38,'Indigo','special_need','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(39,'Down Sindrome','special_need','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(40,'Autis','special_need','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(41,'Lainnya','special_need','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(42,'Tidak sekolah','education','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(43,'Putus SD','education','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(44,'SD Sederajat','education','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(45,'SMP Sederajat','education','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(46,'SMA Sederajat','education','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(47,'D1','education','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(48,'D2','education','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(49,'D3','education','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(50,'D4/S1','education','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(51,'S2','education','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(52,'S3','education','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(53,'Anak berprestasi','scholarship','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(54,'Anak Miskin','scholarship','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(55,'Pendidikan','scholarship','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(56,'Unggulan','scholarship','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(57,'Lain-lain','scholarship','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(58,'Sains','achievement_type','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(59,'Seni','achievement_type','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(60,'Olahraga','achievement_type','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(61,'Lain-lain','achievement_type','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(62,'Sekolah','achievement_level','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(63,'Kecamatan','achievement_level','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(64,'Kabupaten','achievement_level','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(65,'Provinsi','achievement_level','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(66,'Nasional','achievement_level','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(67,'Internasional','achievement_level','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(68,'Kurang dari 500,000','monthly_income','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(69,'500.000 - 999.9999','monthly_income','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(70,'1 Juta - 1.999.999','monthly_income','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(71,'2 Juta - 4.999.999','monthly_income','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(72,'5 Juta - 20 Juta','monthly_income','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(73,'Lebih dari 20 Juta','monthly_income','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(74,'Bersama orang tua','residence','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(75,'Wali','residence','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(76,'Kos','residence','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(77,'Asrama','residence','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(78,'Panti Asuhan','residence','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(79,'Lainnya','residence','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(80,'Jalan kaki','transportation','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(81,'Kendaraan pribadi','transportation','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(82,'Kendaraan Umum / angkot / Pete-pete','transportation','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(83,'Jemputan Sekolah','transportation','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(84,'Kereta Api','transportation','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(85,'Ojek','transportation','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(86,'Andong / Bendi / Sado / Dokar / Delman / Beca','transportation','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(87,'Perahu penyebrangan / Rakit / Getek','transportation','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(88,'Lainnya','transportation','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(89,'Islam','religion','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(90,'Kristen / protestan','religion','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(91,'Katholik','religion','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(92,'Hindu','religion','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(93,'Budha','religion','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(94,'Khong Hu Chu','religion','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(95,'Lainnya','religion','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(96,'1 - Sekolah Dasar (SD)/ Sederajat','school_level','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(97,'2 - Sekolah Menengah Pertama (SMP)/ Sederajat','school_level','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(98,'3 - Sekolah Menengah Atas (SMA) / Aliyah','school_level','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(99,'4 - Sekolah Menengah Kejuruan (SMK)','school_level','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(100,'5 - Universitas','school_level','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(101,'6 - Sekolah Tinggi','school_level','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(102,'7 - Politeknik','school_level','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(103,'Kawin','marriage_status','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(104,'Belum Kawin','marriage_status','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(105,'Berpisah','marriage_status','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(106,'Pemerintah Pusat','institution_lifter','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(107,'Pemerintah Provinsi','institution_lifter','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(108,'Pemerintah Kab/Kota','institution_lifter','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(109,'Ketua yayasan','institution_lifter','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(110,'Kepala Sekolah','institution_lifter','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(111,'Komite Sekolah','institution_lifter','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(112,'Lainnya','institution_lifter','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(113,'PNS ','employment_status','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(114,'PNS Diperbantukan ','employment_status','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(115,'PNS DEPAG ','employment_status','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(116,'GTY/PTY ','employment_status','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(117,'GTT/PTT Provinsi ','employment_status','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(118,'GTT/PTT Kabupaten/Kota','employment_status','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(119,'Guru Bantu Pusat ','employment_status','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(120,'Guru Honor Sekolah ','employment_status','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(121,'Tenaga Honor Sekolah ','employment_status','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(122,'CPNS','employment_status','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(123,'Lainnya','employment_status','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(124,'Guru Kelas','employment_type','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(125,'Guru Mata Pelajaran','employment_type','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(126,'Guru BK','employment_type','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(127,'Guru Inklusi','employment_type','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(128,'Tenaga Administrasi Sekola','employment_type','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(129,'Guru Pendamping','employment_type','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(130,'Guru Magang','employment_type','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(131,'Guru TIK','employment_type','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(132,'Laboran','employment_type','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(133,'Pustakawan','employment_type','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(134,'Lainnya','employment_type','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(135,'I/A','rank','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(136,'I/B','rank','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(137,'I/C','rank','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(138,'I/D','rank','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(139,'II/A','rank','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(140,'II/B','rank','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(141,'II/C','rank','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(142,'II/D','rank','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(143,'III/A','rank','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(144,'III/B','rank','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(145,'III/C','rank','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(146,'III/D','rank','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(147,'IV/A','rank','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(148,'IV/B','rank','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(149,'IV/C','rank','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(150,'IV/D','rank','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(151,'IV/E','rank','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(152,'APBN','salary_source','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(153,'APBD Provinsi','salary_source','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(154,'APBD Kab/Kota','salary_source','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(155,'Yayasan','salary_source','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(156,'Sekolah','salary_source','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(157,'Lembaga Donor','salary_source','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(158,'Lainnya','salary_source','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(159,'Lab IPA','laboratory_skill','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(160,'Lab Fisika','laboratory_skill','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(161,'Lab Biologi','laboratory_skill','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(162,'Lab Kimia','laboratory_skill','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(163,'Lab Bahasa','laboratory_skill','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(164,'Lab Komputer','laboratory_skill','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(165,'Teknik Bangunan','laboratory_skill','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(166,'Teknik Survei & Pemetaan','laboratory_skill','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(167,'Teknik Ketenagakerjaan','laboratory_skill','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(168,'Teknik Pendinginan & Tata Udara','laboratory_skill','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(169,'Teknik Mesin','laboratory_skill','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false');
863/*!40000 ALTER TABLE `options` ENABLE KEYS */;
864UNLOCK TABLES;
865
866--
867-- Table structure for table `photos`
868--
869
870DROP TABLE IF EXISTS `photos`;
871/*!40101 SET @saved_cs_client     = @@character_set_client */;
872/*!40101 SET character_set_client = utf8 */;
873CREATE TABLE `photos` (
874  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
875  `photo_album_id` bigint(20) NOT NULL DEFAULT '0',
876  `photo_name` varchar(255) NOT NULL,
877  `created_at` datetime DEFAULT NULL,
878  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
879  `deleted_at` datetime DEFAULT NULL,
880  `restored_at` datetime DEFAULT NULL,
881  `created_by` bigint(20) DEFAULT '0',
882  `updated_by` bigint(20) DEFAULT '0',
883  `deleted_by` bigint(20) DEFAULT '0',
884  `restored_by` bigint(20) DEFAULT '0',
885  `is_deleted` enum('true','false') DEFAULT 'false',
886  PRIMARY KEY (`id`),
887  KEY `photos_photo_album_id__idx` (`photo_album_id`) USING BTREE
888) ENGINE=InnoDB DEFAULT CHARSET=utf8;
889/*!40101 SET character_set_client = @saved_cs_client */;
890
891--
892-- Dumping data for table `photos`
893--
894
895LOCK TABLES `photos` WRITE;
896/*!40000 ALTER TABLE `photos` DISABLE KEYS */;
897/*!40000 ALTER TABLE `photos` ENABLE KEYS */;
898UNLOCK TABLES;
899
900--
901-- Table structure for table `pollings`
902--
903
904DROP TABLE IF EXISTS `pollings`;
905/*!40101 SET @saved_cs_client     = @@character_set_client */;
906/*!40101 SET character_set_client = utf8 */;
907CREATE TABLE `pollings` (
908  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
909  `answer_id` bigint(20) DEFAULT '0',
910  `ip_address` varchar(45) DEFAULT NULL,
911  `created_at` datetime DEFAULT NULL,
912  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
913  `deleted_at` datetime DEFAULT NULL,
914  `restored_at` datetime DEFAULT NULL,
915  `created_by` bigint(20) DEFAULT '0',
916  `updated_by` bigint(20) DEFAULT '0',
917  `deleted_by` bigint(20) DEFAULT '0',
918  `restored_by` bigint(20) DEFAULT '0',
919  `is_deleted` enum('true','false') DEFAULT 'false',
920  PRIMARY KEY (`id`),
921  KEY `pollings_answer_id__idx` (`answer_id`) USING BTREE
922) ENGINE=InnoDB DEFAULT CHARSET=utf8;
923/*!40101 SET character_set_client = @saved_cs_client */;
924
925--
926-- Dumping data for table `pollings`
927--
928
929LOCK TABLES `pollings` WRITE;
930/*!40000 ALTER TABLE `pollings` DISABLE KEYS */;
931/*!40000 ALTER TABLE `pollings` ENABLE KEYS */;
932UNLOCK TABLES;
933
934--
935-- Table structure for table `post_categories`
936--
937
938DROP TABLE IF EXISTS `post_categories`;
939/*!40101 SET @saved_cs_client     = @@character_set_client */;
940/*!40101 SET character_set_client = utf8 */;
941CREATE TABLE `post_categories` (
942  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
943  `category` varchar(255) NOT NULL,
944  `slug` varchar(255) DEFAULT NULL,
945  `description` varchar(255) DEFAULT NULL,
946  `created_at` datetime DEFAULT NULL,
947  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
948  `deleted_at` datetime DEFAULT NULL,
949  `restored_at` datetime DEFAULT NULL,
950  `created_by` bigint(20) DEFAULT '0',
951  `updated_by` bigint(20) DEFAULT '0',
952  `deleted_by` bigint(20) DEFAULT '0',
953  `restored_by` bigint(20) DEFAULT '0',
954  `is_deleted` enum('true','false') DEFAULT 'false',
955  PRIMARY KEY (`id`),
956  UNIQUE KEY `unique_field` (`category`)
957) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
958/*!40101 SET character_set_client = @saved_cs_client */;
959
960--
961-- Dumping data for table `post_categories`
962--
963
964LOCK TABLES `post_categories` WRITE;
965/*!40000 ALTER TABLE `post_categories` DISABLE KEYS */;
966INSERT INTO `post_categories` VALUES (1,'Uncategorized','uncategorized','Uncategorized','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false');
967/*!40000 ALTER TABLE `post_categories` ENABLE KEYS */;
968UNLOCK TABLES;
969
970--
971-- Table structure for table `posts`
972--
973
974DROP TABLE IF EXISTS `posts`;
975/*!40101 SET @saved_cs_client     = @@character_set_client */;
976/*!40101 SET character_set_client = utf8 */;
977CREATE TABLE `posts` (
978  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
979  `post_title` varchar(255) DEFAULT NULL,
980  `post_content` longtext,
981  `post_image` varchar(100) DEFAULT NULL,
982  `post_author` bigint(20) DEFAULT '0',
983  `post_categories` varchar(255) DEFAULT NULL,
984  `post_type` varchar(50) NOT NULL DEFAULT 'post',
985  `post_status` enum('publish','draft') DEFAULT 'publish',
986  `post_visibility` enum('public','private') DEFAULT 'public',
987  `post_comment_status` enum('open','close') DEFAULT 'open',
988  `post_slug` varchar(255) DEFAULT NULL,
989  `post_tags` varchar(255) DEFAULT NULL,
990  `post_counter` bigint(20) DEFAULT '0',
991  `created_at` datetime DEFAULT NULL,
992  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
993  `deleted_at` datetime DEFAULT NULL,
994  `restored_at` datetime DEFAULT NULL,
995  `created_by` bigint(20) DEFAULT '0',
996  `updated_by` bigint(20) DEFAULT '0',
997  `deleted_by` bigint(20) DEFAULT '0',
998  `restored_by` bigint(20) DEFAULT '0',
999  `is_deleted` enum('true','false') DEFAULT 'false',
1000  PRIMARY KEY (`id`),
1001  KEY `posts_post_author__idx` (`post_author`) USING BTREE
1002) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
1003/*!40101 SET character_set_client = @saved_cs_client */;
1004
1005--
1006-- Dumping data for table `posts`
1007--
1008
1009LOCK TABLES `posts` WRITE;
1010/*!40000 ALTER TABLE `posts` DISABLE KEYS */;
1011INSERT INTO `posts` VALUES (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>','headmaster_photo.png',0,'','welcome','publish','public','open','','',0,'2018-12-24 12:02:00','2018-12-24 05:02:00',NULL,NULL,0,0,0,0,'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>',NULL,1,'1','page','publish','public','open','sample-page','berita, pengumuman, sekilas-info',1,'2018-12-24 12:02:00','2018-12-24 05:02:00',NULL,NULL,0,0,0,0,'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-12-24 12:02:00','2018-12-24 05:02:00',NULL,NULL,0,0,0,0,'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-12-24 12:02:00','2018-12-24 05:02:00',NULL,NULL,0,0,0,0,'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-12-24 12:02:00','2018-12-24 05:02:00',NULL,NULL,0,0,0,0,'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-12-24 12:02:00','2018-12-24 05:02:00',NULL,NULL,0,0,0,0,'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-12-24 12:02:00','2018-12-24 05:02:00',NULL,NULL,0,0,0,0,'false');
1012/*!40000 ALTER TABLE `posts` ENABLE KEYS */;
1013UNLOCK TABLES;
1014
1015--
1016-- Table structure for table `questions`
1017--
1018
1019DROP TABLE IF EXISTS `questions`;
1020/*!40101 SET @saved_cs_client     = @@character_set_client */;
1021/*!40101 SET character_set_client = utf8 */;
1022CREATE TABLE `questions` (
1023  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1024  `question` varchar(255) DEFAULT NULL,
1025  `is_active` enum('true','false') DEFAULT 'false',
1026  `created_at` datetime DEFAULT NULL,
1027  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1028  `deleted_at` datetime DEFAULT NULL,
1029  `restored_at` datetime DEFAULT NULL,
1030  `created_by` bigint(20) DEFAULT '0',
1031  `updated_by` bigint(20) DEFAULT '0',
1032  `deleted_by` bigint(20) DEFAULT '0',
1033  `restored_by` bigint(20) DEFAULT '0',
1034  `is_deleted` enum('true','false') DEFAULT 'false',
1035  PRIMARY KEY (`id`),
1036  UNIQUE KEY `question` (`question`)
1037) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1038/*!40101 SET character_set_client = @saved_cs_client */;
1039
1040--
1041-- Dumping data for table `questions`
1042--
1043
1044LOCK TABLES `questions` WRITE;
1045/*!40000 ALTER TABLE `questions` DISABLE KEYS */;
1046/*!40000 ALTER TABLE `questions` ENABLE KEYS */;
1047UNLOCK TABLES;
1048
1049--
1050-- Table structure for table `quotes`
1051--
1052
1053DROP TABLE IF EXISTS `quotes`;
1054/*!40101 SET @saved_cs_client     = @@character_set_client */;
1055/*!40101 SET character_set_client = utf8 */;
1056CREATE TABLE `quotes` (
1057  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1058  `quote` varchar(255) DEFAULT NULL,
1059  `quote_by` varchar(255) DEFAULT NULL,
1060  `created_at` datetime DEFAULT NULL,
1061  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1062  `deleted_at` datetime DEFAULT NULL,
1063  `restored_at` datetime DEFAULT NULL,
1064  `created_by` bigint(20) DEFAULT '0',
1065  `updated_by` bigint(20) DEFAULT '0',
1066  `deleted_by` bigint(20) DEFAULT '0',
1067  `restored_by` bigint(20) DEFAULT '0',
1068  `is_deleted` enum('true','false') DEFAULT 'false',
1069  PRIMARY KEY (`id`),
1070  UNIQUE KEY `unique_field` (`quote`,`quote_by`)
1071) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1072/*!40101 SET character_set_client = @saved_cs_client */;
1073
1074--
1075-- Dumping data for table `quotes`
1076--
1077
1078LOCK TABLES `quotes` WRITE;
1079/*!40000 ALTER TABLE `quotes` DISABLE KEYS */;
1080/*!40000 ALTER TABLE `quotes` ENABLE KEYS */;
1081UNLOCK TABLES;
1082
1083--
1084-- Table structure for table `scholarships`
1085--
1086
1087DROP TABLE IF EXISTS `scholarships`;
1088/*!40101 SET @saved_cs_client     = @@character_set_client */;
1089/*!40101 SET character_set_client = utf8 */;
1090CREATE TABLE `scholarships` (
1091  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1092  `student_id` bigint(20) NOT NULL DEFAULT '0',
1093  `type` bigint(20) NOT NULL DEFAULT '0',
1094  `description` varchar(255) NOT NULL,
1095  `start_year` year(4) NOT NULL DEFAULT '0000',
1096  `end_year` year(4) NOT NULL DEFAULT '0000',
1097  `created_at` datetime DEFAULT NULL,
1098  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1099  `deleted_at` datetime DEFAULT NULL,
1100  `restored_at` datetime DEFAULT NULL,
1101  `created_by` bigint(20) DEFAULT '0',
1102  `updated_by` bigint(20) DEFAULT '0',
1103  `deleted_by` bigint(20) DEFAULT '0',
1104  `restored_by` bigint(20) DEFAULT '0',
1105  `is_deleted` enum('true','false') DEFAULT 'false',
1106  PRIMARY KEY (`id`),
1107  KEY `scholarships_student_id__idx` (`student_id`) USING BTREE
1108) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1109/*!40101 SET character_set_client = @saved_cs_client */;
1110
1111--
1112-- Dumping data for table `scholarships`
1113--
1114
1115LOCK TABLES `scholarships` WRITE;
1116/*!40000 ALTER TABLE `scholarships` DISABLE KEYS */;
1117/*!40000 ALTER TABLE `scholarships` ENABLE KEYS */;
1118UNLOCK TABLES;
1119
1120--
1121-- Table structure for table `settings`
1122--
1123
1124DROP TABLE IF EXISTS `settings`;
1125/*!40101 SET @saved_cs_client     = @@character_set_client */;
1126/*!40101 SET character_set_client = utf8 */;
1127CREATE TABLE `settings` (
1128  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1129  `setting_group` varchar(100) NOT NULL,
1130  `setting_variable` varchar(255) DEFAULT NULL,
1131  `setting_value` text,
1132  `setting_default_value` text,
1133  `setting_access_group` varchar(255) DEFAULT NULL,
1134  `setting_description` varchar(255) DEFAULT NULL,
1135  `created_at` datetime DEFAULT NULL,
1136  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1137  `deleted_at` datetime DEFAULT NULL,
1138  `restored_at` datetime DEFAULT NULL,
1139  `created_by` bigint(20) DEFAULT '0',
1140  `updated_by` bigint(20) DEFAULT '0',
1141  `deleted_by` bigint(20) DEFAULT '0',
1142  `restored_by` bigint(20) DEFAULT '0',
1143  `is_deleted` enum('true','false') DEFAULT 'false',
1144  PRIMARY KEY (`id`),
1145  UNIQUE KEY `unique_field` (`setting_group`,`setting_variable`)
1146) ENGINE=InnoDB AUTO_INCREMENT=96 DEFAULT CHARSET=utf8;
1147/*!40101 SET character_set_client = @saved_cs_client */;
1148
1149--
1150-- Dumping data for table `settings`
1151--
1152
1153LOCK TABLES `settings` WRITE;
1154/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
1155INSERT INTO `settings` VALUES (1,'general','site_maintenance',NULL,'false','public, student, employee, administrator, super_user','Pemeliharaan situs','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(2,'general','site_maintenance_end_date',NULL,'2019-01-01','public, student, employee, administrator, super_user','Tanggal Berakhir Pemeliharaan Situs','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(3,'general','site_cache',NULL,'false','public, student, employee, administrator, super_user','Cache situs','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(4,'general','site_cache_time',NULL,'10','public, student, employee, administrator, super_user','Lama Cache Situs','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(5,'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-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(6,'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-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(7,'general','google_map_api_key',NULL,'AIzaSyDmiycFxzYZ37FOwA4wqSbL3z2YvIYIArw','public, student, employee, administrator, super_user','API Key Google Map','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(8,'general','latitude',NULL,'-6.2407311','public, student, employee, administrator, super_user','Latitude','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(9,'general','longitude',NULL,'106.9972892','public, student, employee, administrator, super_user','Longitude','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(10,'general','favicon',NULL,'favicon.png','public, student, employee, administrator, super_user','Favicon','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(11,'general','header',NULL,'header.png','public, student, employee, administrator, super_user','Gambar Header','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(12,'general','recaptcha_status',NULL,'enable','public, student, employee, administrator, super_user','reCAPTCHA Status','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(13,'general','recaptcha_site_key',NULL,'6LeNCTAUAAAAAADTbL1rDw8GT1DF2DUjVtEXzdMu','public','Recaptcha Site Key','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(14,'general','recaptcha_secret_key',NULL,'6LeNCTAUAAAAAGq8O0ItkzG8fsA9KeJ7mFMMFF1s','','Recaptcha Secret Key','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(15,'general','timezone',NULL,'Asia/Jakarta','public, student, employee, administrator, super_user','Time Zone','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(16,'media','file_allowed_types',NULL,'jpg, jpeg, png, gif','public, student, employee, administrator, super_user','Tipe file yang diizinkan','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(17,'media','upload_max_filesize',NULL,'0','public, student, employee, administrator, super_user','Maksimal Ukuran File yang Diupload','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(18,'media','thumbnail_size_height',NULL,'100','administrator, super_user','Tinggi Gambar Thumbnail','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(19,'media','thumbnail_size_width',NULL,'150','administrator, super_user','Lebar Gambar Thumbnail','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(20,'media','medium_size_height',NULL,'308','administrator, super_user','Tinggi Gambar Sedang','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(21,'media','medium_size_width',NULL,'460','administrator, super_user','Lebar Gambar Sedang','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(22,'media','large_size_height',NULL,'600','administrator, super_user','Tinggi Gambar Besar','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(23,'media','large_size_width',NULL,'800','administrator, super_user','Lebar Gambar Besar','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(24,'media','album_cover_height',NULL,'250','administrator, super_user','Tinggi Cover Album Photo','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(25,'media','album_cover_width',NULL,'400','administrator, super_user','Lebar Cover Album Photo','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(26,'media','banner_height',NULL,'81','administrator, super_user','Tinggi Iklan','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(27,'media','banner_width',NULL,'245','administrator, super_user','Lebar Iklan','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(28,'media','image_slider_height',NULL,'400','administrator, super_user','Tinggi Gambar Slide','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(29,'media','image_slider_width',NULL,'900','administrator, super_user','Lebar Gambar Slide','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(30,'media','student_photo_height',NULL,'170','public, student, employee, administrator, super_user','Tinggi Photo Peserta Didik','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(31,'media','student_photo_width',NULL,'113','public, student, employee, administrator, super_user','Lebar Photo Peserta Didik','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(32,'media','employee_photo_height',NULL,'170','employee, administrator, super_user','Tinggi Photo Guru dan Tenaga Kependidikan','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(33,'media','employee_photo_width',NULL,'113','employee, administrator, super_user','Lebar Photo Guru dan Tenaga Kependidikan','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(34,'media','headmaster_photo_height',NULL,'170','administrator, super_user','Tinggi Photo Kepala Sekolah','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(35,'media','headmaster_photo_width',NULL,'113','administrator, super_user','Lebar Photo Kepala Sekolah','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(36,'media','header_height',NULL,'80','administrator, super_user','Tinggi Gambar Header','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(37,'media','header_width',NULL,'200','administrator, super_user','Lebar Gambar Header','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(38,'media','logo_height',NULL,'120','administrator, super_user','Tinggi Logo Sekolah','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(39,'media','logo_width',NULL,'120','administrator, super_user','Lebar Logo Sekolah','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(40,'writing','default_post_category',NULL,'1','student, employee, administrator, super_user','Default Kategori Tulisan','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(41,'writing','default_post_status',NULL,'publish','student, employee, administrator, super_user','Default Status Tulisan','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(42,'writing','default_post_visibility',NULL,'public','student, employee, administrator, super_user','Default Akses Tulisan','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(43,'writing','default_post_discussion',NULL,'open','student, employee, administrator, super_user','Default Komentar Tulisan','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(44,'writing','post_image_thumbnail_height',NULL,'100','student, employee, administrator, super_user','Tinggi Gambar Kecil','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(45,'writing','post_image_thumbnail_width',NULL,'150','student, employee, administrator, super_user','Lebar Gambar Kecil','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(46,'writing','post_image_medium_height',NULL,'250','student, employee, administrator, super_user','Tinggi Gambar Sedang','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(47,'writing','post_image_medium_width',NULL,'400','student, employee, administrator, super_user','Lebar Gambar Sedang','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(48,'writing','post_image_large_height',NULL,'450','student, employee, administrator, super_user','Tinggi Gambar Besar','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(49,'writing','post_image_large_width',NULL,'840','student, employee, administrator, super_user','Lebar Gambar Besar','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(50,'reading','post_per_page',NULL,'10','public, student, employee, administrator, super_user','Tulisan per halaman','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(51,'reading','post_rss_count',NULL,'10','public, student, employee, administrator, super_user','Jumlah RSS','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(52,'reading','post_related_count',NULL,'10','public, student, employee, administrator, super_user','Jumlah Tulisan Terkait','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(53,'reading','comment_per_page',NULL,'10','public, student, employee, administrator, super_user','Komentar per halaman','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(54,'discussion','comment_moderation',NULL,'false','administrator, super_user','Komentar harus disetujui secara manual','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(55,'discussion','comment_registration',NULL,'false','public, student, employee, administrator, super_user','Pengguna harus terdaftar dan login untuk komentar','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(56,'discussion','comment_blacklist',NULL,'kampret','public, student, employee, administrator, super_user','Komentar disaring','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(57,'discussion','comment_order',NULL,'asc','public, student, employee, administrator, super_user','Urutan Komentar','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(58,'social_account','facebook',NULL,'','public, student, employee, administrator, super_user','Facebook','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(59,'social_account','twitter',NULL,'','public, student, employee, administrator, super_user','Twitter','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(60,'social_account','google_plus',NULL,'','public, student, employee, administrator, super_user','Google Plus','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(61,'social_account','linked_in',NULL,'','public, student, employee, administrator, super_user','Linked In','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(62,'social_account','youtube',NULL,'','public, student, employee, administrator, super_user','Youtube','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(63,'social_account','instagram',NULL,'','public, student, employee, administrator, super_user','Instagram','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(64,'mail_server','sendgrid_username',NULL,'','administrator, super_user','Sendgrid Username','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(65,'mail_server','sendgrid_password',NULL,'','administrator, super_user','Sendgrid Password','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(66,'mail_server','sendgrid_api_key',NULL,'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','administrator, super_user','Sendgrid API Key','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(67,'school_profile','npsn',NULL,'123','public, student, employee, administrator, super_user','NPSN','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(68,'school_profile','school_name',NULL,'SMA Negeri 9 Kuningan','public, student, employee, administrator, super_user','Nama Sekolah','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(69,'school_profile','headmaster',NULL,'Anton Sofyan','public, student, employee, administrator, super_user','Kepala Sekolah','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(70,'school_profile','headmaster_photo',NULL,'headmaster_photo.png','public, student, employee, administrator, super_user','Photo Kepala Sekolah','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(71,'school_profile','school_level',NULL,'3','public, student, employee, administrator, super_user','Bentuk Pendidikan','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(72,'school_profile','school_status',NULL,'1','public, student, employee, administrator, super_user','Status Sekolah','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(73,'school_profile','ownership_status',NULL,'1','administrator, super_user','Status Kepemilikan','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(74,'school_profile','decree_operating_permit',NULL,'-','administrator, super_user','SK Izin Operasional','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(75,'school_profile','decree_operating_permit_date',NULL,'2018-12-24','administrator, super_user','Tanggal SK Izin Operasional','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(76,'school_profile','tagline',NULL,'Where Tomorrow\'s Leaders Come Together','public, student, employee, administrator, super_user','Slogan','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(77,'school_profile','rt',NULL,'12','public, student, employee, administrator, super_user','RT','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(78,'school_profile','rw',NULL,'06','public, student, employee, administrator, super_user','RW','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(79,'school_profile','sub_village',NULL,'Wage','public, student, employee, administrator, super_user','Dusun','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(80,'school_profile','village',NULL,'Kadugede','public, student, employee, administrator, super_user','Kelurahan / Desa','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(81,'school_profile','sub_district',NULL,'Kadugede','public, student, employee, administrator, super_user','Kecamatan','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(82,'school_profile','district',NULL,'Kuningan','public, student, employee, administrator, super_user','Kabupaten','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(83,'school_profile','postal_code',NULL,'45561','public, student, employee, administrator, super_user','Kode Pos','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(84,'school_profile','street_address',NULL,'Jalan Raya Kadugede No. 11','public, student, employee, administrator, super_user','Alamat Jalan','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(85,'school_profile','phone',NULL,'0232123456','public, student, employee, administrator, super_user','Telepon','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(86,'school_profile','fax',NULL,'0232123456','public, student, employee, administrator, super_user','Fax','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(87,'school_profile','email',NULL,'info@sman9kuningan.sch.id','public, student, employee, administrator, super_user','Email','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(88,'school_profile','website',NULL,'http://www.sman9kuningan.sch.id','public, student, employee, administrator, super_user','Website','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(89,'school_profile','logo',NULL,'logo.png','public, student, employee, administrator, super_user','Logo','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(90,'admission','admission_status',NULL,'open','public, student, employee, administrator, super_user','Status Penerimaan Peserta Didik Baru','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(91,'admission','admission_year',NULL,'2018','public, student, employee, administrator, super_user','Tahun Penerimaan Peserta Didik Baru','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(92,'admission','admission_start_date',NULL,'2019-01-01','public, student, employee, administrator, super_user','Tanggal Mulai PPDB','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(93,'admission','admission_end_date',NULL,'2019-12-31','public, student, employee, administrator, super_user','Tanggal Selesai PPDB','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(94,'admission','announcement_start_date',NULL,'2019-01-01','public, student, employee, administrator, super_user','Tanggal Mulai Pengumuman Hasil Seleksi PPDB','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(95,'admission','announcement_end_date',NULL,'2019-12-31','public, student, employee, administrator, super_user','Tanggal Selesai Pengumuman Hasil Seleksi PPDB','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false');
1156/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
1157UNLOCK TABLES;
1158
1159--
1160-- Table structure for table `students`
1161--
1162
1163DROP TABLE IF EXISTS `students`;
1164/*!40101 SET @saved_cs_client     = @@character_set_client */;
1165/*!40101 SET character_set_client = utf8 */;
1166CREATE TABLE `students` (
1167  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1168  `major_id` bigint(20) DEFAULT '0' COMMENT 'Program Keahlian',
1169  `first_choice_id` bigint(20) DEFAULT '0' COMMENT 'Pilihan Pertama PPDB',
1170  `second_choice_id` bigint(20) DEFAULT '0' COMMENT 'Pilihan Kedua PPDB',
1171  `registration_number` varchar(10) DEFAULT NULL COMMENT 'Nomor Pendaftaran',
1172  `admission_exam_number` varchar(10) DEFAULT NULL COMMENT 'Nomor Ujian Tes Tulis',
1173  `selection_result` varchar(100) DEFAULT NULL COMMENT 'Hasil Seleksi PPDB/PMB',
1174  `admission_phase_id` bigint(20) DEFAULT '0' COMMENT 'Gelombang Pendaftaran',
1175  `admission_type_id` bigint(20) DEFAULT '0' COMMENT 'Jalur Pendaftaran',
1176  `photo` varchar(100) DEFAULT NULL,
1177  `achievement` text COMMENT 'Prestasi Calon Peserta Didik / Mahasiswa',
1178  `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',
1179  `is_prospective_student` enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'Apakah Calon Siswa Baru ?',
1180  `is_alumni` enum('true','false','unverified') NOT NULL DEFAULT 'false' COMMENT 'Apakah Alumni ?',
1181  `is_transfer` enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'Jenis Pendaftaran : Baru / Pindahan ?',
1182  `re_registration` enum('true','false') DEFAULT NULL COMMENT 'Konfirmasi Pendaftaran Ulang Calon Siswa Baru',
1183  `start_date` date DEFAULT NULL COMMENT 'Tanggal Masuk Sekolah',
1184  `identity_number` varchar(50) DEFAULT NULL COMMENT 'NIS/NIM',
1185  `nisn` varchar(50) DEFAULT NULL COMMENT 'Nomor Induk Siswa Nasional',
1186  `nik` varchar(50) DEFAULT NULL COMMENT 'Nomor Induk Kependudukan / KTP',
1187  `prev_exam_number` varchar(50) DEFAULT NULL COMMENT 'Nomor Peserta Ujian Sebelumnya',
1188  `prev_diploma_number` varchar(50) DEFAULT NULL COMMENT 'Nomor Ijazah Sebelumnya',
1189  `paud` enum('true','false') DEFAULT NULL COMMENT 'Apakah pernah PAUD',
1190  `tk` enum('true','false') DEFAULT NULL COMMENT 'Apakah pernah TK',
1191  `skhun` varchar(50) DEFAULT NULL COMMENT 'No. Seri Surat Keterangan Hasil Ujian Nasional Sebelumnya',
1192  `prev_school_name` varchar(255) DEFAULT NULL COMMENT 'Nama Sekolah Sebelumnya',
1193  `prev_school_address` varchar(255) DEFAULT NULL COMMENT 'Alamat Sekolah Sebelumnya',
1194  `hobby` varchar(255) DEFAULT NULL,
1195  `ambition` varchar(255) DEFAULT NULL COMMENT 'Cita-cita',
1196  `full_name` varchar(150) NOT NULL,
1197  `gender` enum('M','F') NOT NULL DEFAULT 'M',
1198  `birth_place` varchar(255) DEFAULT NULL,
1199  `birth_date` date DEFAULT NULL,
1200  `religion_id` bigint(20) DEFAULT '0',
1201  `special_need_id` bigint(20) DEFAULT '0' COMMENT 'Berkeburuhan Khusus',
1202  `street_address` varchar(255) DEFAULT NULL COMMENT 'Alamat Jalan',
1203  `rt` varchar(10) DEFAULT NULL COMMENT 'Alamat Jalan',
1204  `rw` varchar(10) DEFAULT NULL COMMENT 'Alamat Jalan',
1205  `sub_village` varchar(255) DEFAULT NULL COMMENT 'Nama Dusun',
1206  `village` varchar(255) DEFAULT NULL COMMENT 'Nama Kelurahan/ Desa',
1207  `sub_district` varchar(255) DEFAULT NULL COMMENT 'Kecamatan',
1208  `district` varchar(255) DEFAULT NULL COMMENT 'Kabupaten',
1209  `postal_code` varchar(20) DEFAULT NULL COMMENT 'Kode POS',
1210  `residence_id` bigint(20) DEFAULT '0' COMMENT 'Tempat Tinggal',
1211  `transportation_id` bigint(20) DEFAULT '0' COMMENT 'Moda Transportasi',
1212  `phone` varchar(50) DEFAULT NULL,
1213  `mobile_phone` varchar(50) DEFAULT NULL,
1214  `email` varchar(150) DEFAULT NULL,
1215  `sktm` varchar(100) DEFAULT NULL COMMENT 'Surat Keterangan Tidak Mampu (SKTM)',
1216  `kks` varchar(100) DEFAULT NULL COMMENT 'Kartu Keluarga Sejahtera (KKS)',
1217  `kps` varchar(100) DEFAULT NULL COMMENT 'Kartu Pra Sejahtera (KPS)',
1218  `kip` varchar(100) DEFAULT NULL COMMENT 'Kartu Indonesia Pintar (KIP)',
1219  `kis` varchar(100) DEFAULT NULL COMMENT 'Kartu Indonesia Sehat (KIS)',
1220  `citizenship` enum('WNI','WNA') NOT NULL DEFAULT 'WNI' COMMENT 'Kewarganegaraan',
1221  `country` varchar(255) DEFAULT NULL,
1222  `father_name` varchar(150) DEFAULT NULL,
1223  `father_birth_year` year(4) DEFAULT NULL,
1224  `father_education_id` bigint(20) DEFAULT '0',
1225  `father_employment_id` bigint(20) DEFAULT '0',
1226  `father_monthly_income_id` bigint(20) DEFAULT '0',
1227  `father_special_need_id` bigint(20) DEFAULT '0',
1228  `mother_name` varchar(150) DEFAULT NULL,
1229  `mother_birth_year` year(4) DEFAULT NULL,
1230  `mother_education_id` bigint(20) DEFAULT '0',
1231  `mother_employment_id` bigint(20) DEFAULT '0',
1232  `mother_monthly_income_id` bigint(20) DEFAULT '0',
1233  `mother_special_need_id` bigint(20) DEFAULT '0',
1234  `guardian_name` varchar(150) DEFAULT NULL,
1235  `guardian_birth_year` year(4) DEFAULT NULL,
1236  `guardian_education_id` bigint(20) DEFAULT '0',
1237  `guardian_employment_id` bigint(20) DEFAULT '0',
1238  `guardian_monthly_income_id` bigint(20) DEFAULT '0',
1239  `mileage` smallint(6) DEFAULT NULL COMMENT 'Jarak tempat tinggal ke sekolah',
1240  `traveling_time` smallint(6) DEFAULT NULL COMMENT 'Waktu Tempuh',
1241  `height` smallint(3) DEFAULT NULL COMMENT 'Tinggi Badan',
1242  `weight` smallint(3) DEFAULT NULL COMMENT 'Berat Badan',
1243  `sibling_number` smallint(2) DEFAULT '0' COMMENT 'Jumlah Saudara Kandng',
1244  `student_status_id` bigint(20) DEFAULT '0' COMMENT 'Status siswa',
1245  `end_date` date DEFAULT NULL COMMENT 'Tanggal Keluar',
1246  `reason` varchar(255) DEFAULT NULL COMMENT 'Diisi jika peserta didik sudah keluar',
1247  `created_at` datetime DEFAULT NULL,
1248  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1249  `deleted_at` datetime DEFAULT NULL,
1250  `restored_at` datetime DEFAULT NULL,
1251  `created_by` bigint(20) DEFAULT '0',
1252  `updated_by` bigint(20) DEFAULT '0',
1253  `deleted_by` bigint(20) DEFAULT '0',
1254  `restored_by` bigint(20) DEFAULT '0',
1255  `is_deleted` enum('true','false') DEFAULT 'false',
1256  PRIMARY KEY (`id`),
1257  UNIQUE KEY `identity_number` (`identity_number`),
1258  UNIQUE KEY `nisn` (`nisn`),
1259  UNIQUE KEY `nik` (`nik`),
1260  KEY `students_registration_number__idx` (`registration_number`) USING BTREE,
1261  KEY `students_identity_number__idx` (`identity_number`) USING BTREE,
1262  KEY `students_full_name__idx` (`full_name`) USING BTREE,
1263  KEY `students_first_choice_id__idx` (`first_choice_id`) USING BTREE,
1264  KEY `students_second_choice_id__idx` (`second_choice_id`) USING BTREE,
1265  KEY `students_major_id__idx` (`major_id`) USING BTREE,
1266  KEY `students_admission_phase_id__idx` (`admission_phase_id`) USING BTREE,
1267  KEY `students_admission_type_id__idx` (`admission_type_id`) USING BTREE,
1268  KEY `students_student_status_id__idx` (`student_status_id`) USING BTREE
1269) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1270/*!40101 SET character_set_client = @saved_cs_client */;
1271
1272--
1273-- Dumping data for table `students`
1274--
1275
1276LOCK TABLES `students` WRITE;
1277/*!40000 ALTER TABLE `students` DISABLE KEYS */;
1278/*!40000 ALTER TABLE `students` ENABLE KEYS */;
1279UNLOCK TABLES;
1280
1281--
1282-- Table structure for table `subscribers`
1283--
1284
1285DROP TABLE IF EXISTS `subscribers`;
1286/*!40101 SET @saved_cs_client     = @@character_set_client */;
1287/*!40101 SET character_set_client = utf8 */;
1288CREATE TABLE `subscribers` (
1289  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1290  `email` varchar(255) DEFAULT NULL,
1291  `is_active` enum('true','false') DEFAULT 'false',
1292  `created_at` datetime DEFAULT NULL,
1293  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1294  `deleted_at` datetime DEFAULT NULL,
1295  `restored_at` datetime DEFAULT NULL,
1296  `created_by` bigint(20) DEFAULT '0',
1297  `updated_by` bigint(20) DEFAULT '0',
1298  `deleted_by` bigint(20) DEFAULT '0',
1299  `restored_by` bigint(20) DEFAULT '0',
1300  `is_deleted` enum('true','false') DEFAULT 'false',
1301  PRIMARY KEY (`id`),
1302  UNIQUE KEY `email` (`email`)
1303) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1304/*!40101 SET character_set_client = @saved_cs_client */;
1305
1306--
1307-- Dumping data for table `subscribers`
1308--
1309
1310LOCK TABLES `subscribers` WRITE;
1311/*!40000 ALTER TABLE `subscribers` DISABLE KEYS */;
1312/*!40000 ALTER TABLE `subscribers` ENABLE KEYS */;
1313UNLOCK TABLES;
1314
1315--
1316-- Table structure for table `tags`
1317--
1318
1319DROP TABLE IF EXISTS `tags`;
1320/*!40101 SET @saved_cs_client     = @@character_set_client */;
1321/*!40101 SET character_set_client = utf8 */;
1322CREATE TABLE `tags` (
1323  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1324  `tag` varchar(255) NOT NULL,
1325  `slug` varchar(255) DEFAULT NULL,
1326  `created_at` datetime DEFAULT NULL,
1327  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1328  `deleted_at` datetime DEFAULT NULL,
1329  `restored_at` datetime DEFAULT NULL,
1330  `created_by` bigint(20) DEFAULT '0',
1331  `updated_by` bigint(20) DEFAULT '0',
1332  `deleted_by` bigint(20) DEFAULT '0',
1333  `restored_by` bigint(20) DEFAULT '0',
1334  `is_deleted` enum('true','false') DEFAULT 'false',
1335  PRIMARY KEY (`id`),
1336  UNIQUE KEY `tag` (`tag`)
1337) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
1338/*!40101 SET character_set_client = @saved_cs_client */;
1339
1340--
1341-- Dumping data for table `tags`
1342--
1343
1344LOCK TABLES `tags` WRITE;
1345/*!40000 ALTER TABLE `tags` DISABLE KEYS */;
1346INSERT INTO `tags` VALUES (1,'Berita','berita','2018-12-24 12:02:00','2018-12-24 05:02:00',NULL,NULL,0,0,0,0,'false'),(2,'Pengumuman','pengumuman','2018-12-24 12:02:00','2018-12-24 05:02:00',NULL,NULL,0,0,0,0,'false'),(3,'Sekilas Info','sekilas-info','2018-12-24 12:02:00','2018-12-24 05:02:00',NULL,NULL,0,0,0,0,'false');
1347/*!40000 ALTER TABLE `tags` ENABLE KEYS */;
1348UNLOCK TABLES;
1349
1350--
1351-- Table structure for table `themes`
1352--
1353
1354DROP TABLE IF EXISTS `themes`;
1355/*!40101 SET @saved_cs_client     = @@character_set_client */;
1356/*!40101 SET character_set_client = utf8 */;
1357CREATE TABLE `themes` (
1358  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1359  `theme_name` varchar(255) NOT NULL,
1360  `theme_folder` varchar(255) DEFAULT NULL,
1361  `theme_author` varchar(255) DEFAULT NULL,
1362  `is_active` enum('true','false') DEFAULT 'false',
1363  `created_at` datetime DEFAULT NULL,
1364  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1365  `deleted_at` datetime DEFAULT NULL,
1366  `restored_at` datetime DEFAULT NULL,
1367  `created_by` bigint(20) DEFAULT '0',
1368  `updated_by` bigint(20) DEFAULT '0',
1369  `deleted_by` bigint(20) DEFAULT '0',
1370  `restored_by` bigint(20) DEFAULT '0',
1371  `is_deleted` enum('true','false') DEFAULT 'false',
1372  PRIMARY KEY (`id`),
1373  UNIQUE KEY `theme_name` (`theme_name`)
1374) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
1375/*!40101 SET character_set_client = @saved_cs_client */;
1376
1377--
1378-- Dumping data for table `themes`
1379--
1380
1381LOCK TABLES `themes` WRITE;
1382/*!40000 ALTER TABLE `themes` DISABLE KEYS */;
1383INSERT INTO `themes` VALUES (1,'Cosmo','cosmo','Anton Sofyan','true','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(2,'Flatly','flatly','Anton Sofyan','false','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(3,'Journal','journal','Anton Sofyan','false','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false'),(4,'Simplex','simplex','Anton Sofyan','false','2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false');
1384/*!40000 ALTER TABLE `themes` ENABLE KEYS */;
1385UNLOCK TABLES;
1386
1387--
1388-- Table structure for table `user_groups`
1389--
1390
1391DROP TABLE IF EXISTS `user_groups`;
1392/*!40101 SET @saved_cs_client     = @@character_set_client */;
1393/*!40101 SET character_set_client = utf8 */;
1394CREATE TABLE `user_groups` (
1395  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1396  `group` varchar(255) NOT NULL,
1397  `created_at` datetime DEFAULT NULL,
1398  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1399  `deleted_at` datetime DEFAULT NULL,
1400  `restored_at` datetime DEFAULT NULL,
1401  `created_by` bigint(20) DEFAULT '0',
1402  `updated_by` bigint(20) DEFAULT '0',
1403  `deleted_by` bigint(20) DEFAULT '0',
1404  `restored_by` bigint(20) DEFAULT '0',
1405  `is_deleted` enum('true','false') DEFAULT 'false',
1406  PRIMARY KEY (`id`),
1407  UNIQUE KEY `group` (`group`)
1408) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1409/*!40101 SET character_set_client = @saved_cs_client */;
1410
1411--
1412-- Dumping data for table `user_groups`
1413--
1414
1415LOCK TABLES `user_groups` WRITE;
1416/*!40000 ALTER TABLE `user_groups` DISABLE KEYS */;
1417/*!40000 ALTER TABLE `user_groups` ENABLE KEYS */;
1418UNLOCK TABLES;
1419
1420--
1421-- Table structure for table `user_privileges`
1422--
1423
1424DROP TABLE IF EXISTS `user_privileges`;
1425/*!40101 SET @saved_cs_client     = @@character_set_client */;
1426/*!40101 SET character_set_client = utf8 */;
1427CREATE TABLE `user_privileges` (
1428  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1429  `user_group_id` bigint(20) NOT NULL,
1430  `module_id` bigint(20) NOT NULL,
1431  `created_at` datetime DEFAULT NULL,
1432  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1433  `deleted_at` datetime DEFAULT NULL,
1434  `restored_at` datetime DEFAULT NULL,
1435  `created_by` bigint(20) DEFAULT '0',
1436  `updated_by` bigint(20) DEFAULT '0',
1437  `deleted_by` bigint(20) DEFAULT '0',
1438  `restored_by` bigint(20) DEFAULT '0',
1439  `is_deleted` enum('true','false') DEFAULT 'false',
1440  PRIMARY KEY (`id`),
1441  UNIQUE KEY `unique_field` (`user_group_id`,`module_id`),
1442  KEY `user_privileges_user_group_id__idx` (`user_group_id`) USING BTREE,
1443  KEY `user_privileges_module_id__idx` (`module_id`) USING BTREE
1444) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1445/*!40101 SET character_set_client = @saved_cs_client */;
1446
1447--
1448-- Dumping data for table `user_privileges`
1449--
1450
1451LOCK TABLES `user_privileges` WRITE;
1452/*!40000 ALTER TABLE `user_privileges` DISABLE KEYS */;
1453/*!40000 ALTER TABLE `user_privileges` ENABLE KEYS */;
1454UNLOCK TABLES;
1455
1456--
1457-- Table structure for table `users`
1458--
1459
1460DROP TABLE IF EXISTS `users`;
1461/*!40101 SET @saved_cs_client     = @@character_set_client */;
1462/*!40101 SET character_set_client = utf8 */;
1463CREATE TABLE `users` (
1464  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1465  `user_name` varchar(60) NOT NULL,
1466  `user_password` varchar(100) NOT NULL,
1467  `user_full_name` varchar(100) DEFAULT NULL,
1468  `user_email` varchar(100) DEFAULT NULL,
1469  `user_url` varchar(100) DEFAULT NULL,
1470  `biography` text,
1471  `user_registered` datetime DEFAULT NULL,
1472  `user_group_id` bigint(20) NOT NULL DEFAULT '0',
1473  `user_type` enum('super_user','administrator','employee','student') NOT NULL DEFAULT 'administrator',
1474  `profile_id` bigint(20) unsigned DEFAULT NULL COMMENT 'student_id OR employee_id',
1475  `forgot_password_key` varchar(100) DEFAULT NULL,
1476  `forgot_password_request_date` date DEFAULT NULL,
1477  `is_active` enum('true','false') DEFAULT 'true',
1478  `is_logged_in` enum('true','false') DEFAULT 'false',
1479  `last_logged_in` datetime DEFAULT NULL,
1480  `ip_address` varchar(45) DEFAULT NULL,
1481  `created_at` datetime DEFAULT NULL,
1482  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1483  `deleted_at` datetime DEFAULT NULL,
1484  `restored_at` datetime DEFAULT NULL,
1485  `created_by` bigint(20) DEFAULT '0',
1486  `updated_by` bigint(20) DEFAULT '0',
1487  `deleted_by` bigint(20) DEFAULT '0',
1488  `restored_by` bigint(20) DEFAULT '0',
1489  `is_deleted` enum('true','false') DEFAULT 'false',
1490  PRIMARY KEY (`id`),
1491  UNIQUE KEY `user_name` (`user_name`),
1492  UNIQUE KEY `user_email` (`user_email`),
1493  UNIQUE KEY `user_url` (`user_url`),
1494  KEY `users_user_group_id__idx` (`user_group_id`) USING BTREE,
1495  KEY `users_profile_id__idx` (`profile_id`) USING BTREE
1496) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
1497/*!40101 SET character_set_client = @saved_cs_client */;
1498
1499--
1500-- Dumping data for table `users`
1501--
1502
1503LOCK TABLES `users` WRITE;
1504/*!40000 ALTER TABLE `users` DISABLE KEYS */;
1505INSERT INTO `users` VALUES (1,'administrator','$2y$10$98S2tyMilz.zTgmik6xW/u7kAxl8H8/lZFhj51hdjnatq2PeyYExi','Administrator','admin@admin.com','sekolahku.web.id',NULL,'2018-12-24 12:01:59',0,'super_user',NULL,'7845e74212289704099c4bab86809f704df773bb',NULL,'true','false',NULL,NULL,'2018-12-24 12:01:59','2018-12-24 05:01:59',NULL,NULL,0,0,0,0,'false');
1506/*!40000 ALTER TABLE `users` ENABLE KEYS */;
1507UNLOCK TABLES;
1508/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1509
1510/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1511/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1512/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1513/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1514/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1515/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1516/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1517
1518-- Dump completed on 2018-12-24 12:02:22