-- --------------------------------------------------------
-- Server OS:                    Win64
-- HeidiSQL Version:             12.1.0.6537
-- --------------------------------------------------------


-- 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', '<p>📋 Peraturan Ujian</p><p><br></p><p>📆 Ujian hanya pada jadwal yang ditentukan.</p><p>📱 Gunakan aplikasi resmi Candy Exam.</p><p>🚫 Dilarang membuka aplikasi lain saat ujian.</p><p>📸 Dilarang screenshot atau merekam layar.</p><p>📡 Jika koneksi terputus, login ulang diperbolehkan selama waktu masih aktif.</p><p>ðŸ“Â Jawaban tersimpan otomatis.</p><p>⚠ï¸Â Pelanggaran dapat dikenakan sanksi.</p><p><br></p>', 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);

