-- --------------------------------------------------------
-- Host: 127.0.0.1
-- Server version: 10.6.15-MariaDB-log - mariadb.org binary distribution
-- Server OS: Win64
-- HeidiSQL Version: 12.1.0.6537
-- --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
-- Dumping structure for table candy_examweb.exambro_block
CREATE TABLE IF NOT EXISTS `exambro_block` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`package_name` varchar(255) NOT NULL,
`app_name` varchar(100) DEFAULT NULL,
`category` varchar(50) DEFAULT NULL,
`is_blocked` tinyint(1) NOT NULL DEFAULT 1,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- Dumping data for table candy_examweb.exambro_block: ~2 rows (approximately)
INSERT INTO `exambro_block` (`id`, `package_name`, `app_name`, `category`, `is_blocked`, `created_at`, `updated_at`) VALUES
(1, 'com.whatsapp', 'whatsapp', '', 0, '2025-06-22 15:01:42', '2025-07-23 18:29:27'),
(2, 'com.whatsapp.w4b', 'Whatapp Business', '', 0, '2025-06-22 17:29:00', '2025-06-22 19:46:58');
-- Dumping structure for table candy_examweb.exambro_menu
CREATE TABLE IF NOT EXISTS `exambro_menu` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(100) NOT NULL,
`link` text NOT NULL,
`icon` varchar(50) DEFAULT NULL,
`is_active` tinyint(1) NOT NULL DEFAULT 1,
`order` int(11) NOT NULL DEFAULT 0,
`token` varchar(50) DEFAULT NULL,
`is_token` tinyint(1) NOT NULL DEFAULT 1,
`tgl_dibuka` datetime DEFAULT NULL,
`tgl_ditutup` datetime DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- Dumping data for table candy_examweb.exambro_menu: ~5 rows (approximately)
INSERT INTO `exambro_menu` (`id`, `title`, `link`, `icon`, `is_active`, `order`, `token`, `is_token`, `tgl_dibuka`, `tgl_ditutup`, `created_at`, `updated_at`) VALUES
(1, 'Matematika', 'https://google.com', 'home', 1, 1, 'abc123', 0, '2025-06-22 07:00:00', '2025-06-26 10:00:00', '2025-06-23 12:08:07', '2025-08-24 14:17:34'),
(2, 'B Indonesia', 'https://elearning.cbtcandy.com', 'file-text', 1, 2, '1234', 1, '2025-06-22 19:24:00', '2025-07-15 19:24:00', '2025-06-23 12:08:07', '2025-07-14 18:35:52'),
(3, 'Bahasa Inggris', 'https://elearning.cbtcandy.com', 'home', 1, 3, '1234', 1, '2025-06-24 21:07:00', '2025-08-24 14:17:00', '2025-06-23 14:07:31', '2025-08-24 14:17:49'),
(4, 'Fisika', 'https://elearning.cbtcandy.com', 'home', 1, 4, '1234', 1, '2025-06-24 00:13:00', '2025-07-16 00:13:00', '2025-06-24 17:13:43', '2025-07-14 18:36:09'),
(5, 'SUNDA', 'https://elearning.cbtcandy.com', 'home', 1, 5, '1234', 1, '2025-06-24 00:14:00', '2025-08-24 14:17:00', '2025-06-24 17:14:14', '2025-08-24 14:17:54');
-- Dumping structure for table candy_examweb.migrations
CREATE TABLE IF NOT EXISTS `migrations` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`version` varchar(255) NOT NULL,
`class` varchar(255) NOT NULL,
`group` varchar(255) NOT NULL,
`namespace` varchar(255) NOT NULL,
`time` int(11) NOT NULL,
`batch` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- Dumping data for table candy_examweb.migrations: ~20 rows (approximately)
INSERT INTO `migrations` (`id`, `version`, `class`, `group`, `namespace`, `time`, `batch`) VALUES
(1, '2025-06-17-132907', 'App\\Database\\Migrations\\CreateUsersTable', 'default', 'App', 1750170516, 1),
(2, '2025-06-17-154413', 'App\\Database\\Migrations\\CreateSettingsTable', 'default', 'App', 1750175177, 2),
(3, '2025-06-17-173834', 'App\\Database\\Migrations\\CreateSettingsExambroTable', 'default', 'App', 1750182361, 3),
(5, '2025-06-19-223542', 'App\\Database\\Migrations\\CreateExambroBlockTable', 'default', 'App', 1750372567, 4),
(6, '2025-06-19-223119', 'App\\Database\\Migrations\\CreateExambroMenuTable', 'default', 'App', 1750680459, 5),
(8, '2025-06-28-143320', 'App\\Database\\Migrations\\CreateBankSoalTable', 'default', 'App', 1751125649, 7),
(11, '2025-06-28-143520', 'App\\Database\\Migrations\\CreateJawabanTable', 'default', 'App', 1751125649, 7),
(12, '2025-06-28-143630', 'App\\Database\\Migrations\\CreateHasilUjianTable', 'default', 'App', 1751125649, 7),
(13, '2025-06-28-143453', 'App\\Database\\Migrations\\CreateSoalTable', 'default', 'App', 1751168254, 8),
(15, '2025-06-29-031819', 'App\\Database\\Migrations\\CreateSoalOpsiTable', 'default', 'App', 1751174194, 9),
(16, '2025-06-28-143342', 'App\\Database\\Migrations\\CreateUjianTable', 'default', 'App', 1751194607, 10),
(17, '2025-06-29-135202', 'App\\Database\\Migrations\\CreateTingkatTable', 'default', 'App', 1751205889, 11),
(18, '2025-06-29-135214', 'App\\Database\\Migrations\\CreateKelasTable', 'default', 'App', 1751205889, 11),
(19, '2025-06-29-135220', 'App\\Database\\Migrations\\CreateJurusanTable', 'default', 'App', 1751205889, 11),
(20, '2025-06-29-135233', 'App\\Database\\Migrations\\CreateAgamaTable', 'default', 'App', 1751205889, 11),
(21, '2025-06-28-143214', 'App\\Database\\Migrations\\CreatePesertaTable', 'default', 'App', 1751212869, 12),
(22, '2025-07-02-121837', 'App\\Database\\Migrations\\CreateTopikSoal', 'default', 'App', 1751461331, 13),
(24, '2025-07-10-134638', 'App\\Database\\Migrations\\CreateMediaFilesTable', 'default', 'App', 1752155545, 14),
(25, '2025-09-29-130950', 'App\\Database\\Migrations\\CreateShiftTable', 'default', 'App', 1759155231, 15),
(26, '2025-09-29-131029', 'App\\Database\\Migrations\\CreateAbsensiTable', 'default', 'App', 1759155231, 15);
-- Dumping structure for table candy_examweb.settings
CREATE TABLE IF NOT EXISTS `settings` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`appname` varchar(255) NOT NULL,
`nama_sekolah` varchar(255) NOT NULL,
`npsn` varchar(255) NOT NULL,
`nss` varchar(255) NOT NULL,
`jenjang` varchar(255) NOT NULL,
`alamat_sekolah` varchar(255) NOT NULL,
`website` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`kelurahan` varchar(255) NOT NULL,
`kecamatan` varchar(255) NOT NULL,
`kota` varchar(255) NOT NULL,
`provinsi` varchar(255) NOT NULL,
`nama_kepsek` varchar(255) NOT NULL,
`nip_kepsek` varchar(255) NOT NULL,
`tahunpelajaran` varchar(255) NOT NULL,
`logo` varchar(255) NOT NULL,
`logokementrian` varchar(255) NOT NULL,
`favicon` varchar(255) NOT NULL,
`kop_surat` varchar(255) NOT NULL,
`key_encrypt` varchar(255) NOT NULL,
`api_token` varchar(255) NOT NULL,
`api_url` varchar(255) NOT NULL,
`kementrian` varchar(255) NOT NULL,
`appversion` varchar(255) NOT NULL,
`verifywa_template` text NOT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- Dumping data for table candy_examweb.settings: ~1 rows (approximately)
INSERT INTO `settings` (`id`, `appname`, `nama_sekolah`, `npsn`, `nss`, `jenjang`, `alamat_sekolah`, `website`, `email`, `kelurahan`, `kecamatan`, `kota`, `provinsi`, `nama_kepsek`, `nip_kepsek`, `tahunpelajaran`, `logo`, `logokementrian`, `favicon`, `kop_surat`, `key_encrypt`, `api_token`, `api_url`, `kementrian`, `appversion`, `verifywa_template`, `updated_at`) VALUES
(1, 'CANDY EXAM BROWSER', 'SEKOLAH CANDY', '12345678', '987654321', 'SMA', 'Jl. Pendidikan No.1', 'https://smkcontoh.sch.id', 'admin@smkcontoh.sch.id', 'Kelurahan Contoh', 'Kecamatan Mandiri', 'Kota Edukasi', 'Provinsi Belajar', 'Ibu Guru Hebat', '196512301990032001', '2024/2025', 'logo tutwuri.png', 'logomentri.png', 'favicon.ico', 'kop.png', 'secretkey123456', '12345', 'https://tka.sman12depok.sch.id', 'Kementerian Pendidikan', '3.0.0', 'Halo {nama}, akun Anda telah diverifikasi untuk ujian.', '2025-09-30 00:35:06');
-- Dumping structure for table candy_examweb.settings_exambro
CREATE TABLE IF NOT EXISTS `settings_exambro` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`logo_resource` varchar(255) DEFAULT NULL,
`banner_img` varchar(255) DEFAULT NULL,
`default_brightness` int(11) NOT NULL DEFAULT 95,
`bell_sound` varchar(255) NOT NULL DEFAULT 'bell_sound.mp3',
`exit_sound` varchar(255) NOT NULL DEFAULT 'exit_sound.mp3',
`app_volume` int(11) NOT NULL DEFAULT 80,
`school_name` varchar(255) NOT NULL,
`app_name` varchar(255) NOT NULL,
`version` varchar(50) NOT NULL DEFAULT 'Version 1.0',
`password_exit` varchar(100) NOT NULL,
`secret_code` varchar(100) NOT NULL,
`theme_color` varchar(50) NOT NULL DEFAULT '#2196F3',
`user_agent` varchar(200) NOT NULL DEFAULT 'CandyExamApp',
`file_exam_config` varchar(200) NOT NULL,
`informasi` text NOT NULL,
`menu_url` tinyint(1) NOT NULL DEFAULT 1,
`menu_scanqr` tinyint(1) NOT NULL DEFAULT 1,
`bluetooth` tinyint(1) NOT NULL DEFAULT 1,
`headset` tinyint(1) NOT NULL DEFAULT 1,
`restrict_user_agent` tinyint(1) NOT NULL DEFAULT 1,
`portal_ujian` tinyint(1) NOT NULL DEFAULT 1,
`login_nopassword` tinyint(1) NOT NULL DEFAULT 1,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- Dumping data for table candy_examweb.settings_exambro: ~1 rows (approximately)
INSERT INTO `settings_exambro` (`id`, `logo_resource`, `banner_img`, `default_brightness`, `bell_sound`, `exit_sound`, `app_volume`, `school_name`, `app_name`, `version`, `password_exit`, `secret_code`, `theme_color`, `user_agent`, `file_exam_config`, `informasi`, `menu_url`, `menu_scanqr`, `bluetooth`, `headset`, `restrict_user_agent`, `portal_ujian`, `login_nopassword`, `updated_at`) VALUES
(1, '1750260164_20d8cdfd4ddcc60deab6.png', '1750269074_f6bf49f226a1c634061d.png', 87, '1750269025_9b92c066a8cc9284e4ec.wav', '1750259755_aa944277541ea51bb143.wav', 92, 'SMK HS AGUNG', 'CANDY EXAM', 'Version 3.0.0', '1234', '$2a$09$gs6X2MIXdFe2VR7IvzlVc.7UyKJ6GNT6RcdazukThmrcAQV50pA9O', '#4CB9FF', 'CandyCBTBro/1.0', 'seb_upload_1758948808.seb', '📋 Peraturan Ujian
📆Ujian hanya pada jadwal yang ditentukan.
📱 Gunakan aplikasi resmi Candy Exam.
🚫 Dilarang membuka aplikasi lain saat ujian.
📸 Dilarang screenshot atau merekam layar.
📡 Jika koneksi terputus, login ulang diperbolehkan selama waktu masih aktif.
📠Jawaban tersimpan otomatis.
⚠︠Pelanggaran dapat dikenakan sanksi.
', 1, 1, 0, 0, 0, 1, 1, '2025-11-04 06:14:58');
-- Dumping structure for table candy_examweb.users
CREATE TABLE IF NOT EXISTS `users` (
`id` char(36) NOT NULL,
`username` varchar(50) NOT NULL,
`email` varchar(100) NOT NULL,
`full_name` varchar(100) DEFAULT NULL,
`password` varchar(255) NOT NULL,
`roles` text DEFAULT NULL,
`is_active` tinyint(1) NOT NULL DEFAULT 1,
`remember_token` varchar(100) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`deleted_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`),
UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- Dumping data for table candy_examweb.users: ~1 rows (approximately)
INSERT INTO `users` (`id`, `username`, `email`, `full_name`, `password`, `roles`, `is_active`, `remember_token`, `created_at`, `updated_at`, `deleted_at`) VALUES
('09a72f09-5e9b-497f-bfba-0aaaa4aa4469', 'admin', 'admin@example.com', 'Administrator Utama', '$2y$10$ii9ZvOKv.MV3vUnNorQVJ.79n8x1flem/sukOgwLC9gNFUK5kO94O', 'admin', 1, NULL, '2025-06-17 14:28:58', '2025-11-04 06:12:43', NULL);
/*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;