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


-- Dumping structure for table candyskl.kelulusan
CREATE TABLE IF NOT EXISTS `kelulusan` (
  `id` int(11) unsigned NOT NULL,
  `tgl_surat` varchar(255) NOT NULL,
  `kop_img` enum('Y','N') NOT NULL DEFAULT 'N',
  `nilai` enum('Y','N') NOT NULL DEFAULT 'N',
  `jurusan` enum('Y','N') NOT NULL DEFAULT 'N',
  `no_surat` varchar(255) NOT NULL,
  `nama_surat` varchar(255) NOT NULL,
  `header_surat` text NOT NULL,
  `ttd` varchar(255) NOT NULL,
  `ttd64` longtext NOT NULL,
  `stempel` varchar(255) NOT NULL,
  `dasar_surat` text NOT NULL,
  `isi_surat` text NOT NULL,
  `penutup_surat` text NOT NULL,
  `tahunpelajaran` varchar(255) NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- Dumping data for table candyskl.kelulusan: ~0 rows (approximately)
INSERT INTO `kelulusan` (`id`, `tgl_surat`, `kop_img`, `nilai`, `jurusan`, `no_surat`, `nama_surat`, `header_surat`, `ttd`, `ttd64`, `stempel`, `dasar_surat`, `isi_surat`, `penutup_surat`, `tahunpelajaran`, `updated_at`) VALUES
	(1, '25 Januari 2024', 'N', 'Y', 'Y', '005/SMKHSA/2023', 'SURAT KETERANGAN', '<h2>YAYASAN SOFIA MUJAHIDA UTAMA</h2><h2>SMK HS AGUNG</h2><p>Jl buyut kaipa kp pulo bambu desa karang Bahagia Kec. Karang Bahagia</p><p>Notelp. 021 12347654 email : smk.hsagung@gmail.com</p>', 'ttd.png', '[BLOB]', 'xx', '<p><span style="color: rgb(0, 0, 0);">Yang bertanda tangan dibawah ini Kepala SMK HS AGUNG (NPSN :&nbsp;</span><span style="color: rgb(32, 33, 36);">69787351</span><span style="color: rgb(0, 0, 0);">) Kabupaten Bekasi Provinsi Jawa Barat. Dengan ini menerangkan :</span></p>', '<p><span style="color: rgb(0, 0, 0);">Berdasarkan kriteria kelulusan peserta didik yang sudah ditetapkan, maka yang bersangkutan dinyatakan :</span></p>', '<p><span style="color: rgb(0, 0, 0);">Surat Keterangan ini bersifat sementara dan berlaku sampai ditertibkannya ijazah untuk siswa yang bersangkutan.</span></p><p><span style="color: rgb(0, 0, 0);">Demikian Surat Keterangan diberikan agar dapat dipergunakan sebagaimana mestinya.</span></p><p><br></p>', 'xx', '2024-04-09 15:12:36');

-- Dumping structure for table candyskl.logs
CREATE TABLE IF NOT EXISTS `logs` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `id_users` varchar(255) NOT NULL,
  `riwayat` varchar(255) NOT NULL,
  `role` enum('admin','siswa') NOT NULL DEFAULT 'admin',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- Dumping data for table candyskl.logs: ~4 rows (approximately)

-- Dumping structure for table candyskl.matapelajaran
CREATE TABLE IF NOT EXISTS `matapelajaran` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `nama_matapelajaran` varchar(255) NOT NULL,
  `kode` varchar(255) NOT NULL,
  `kelompok` varchar(255) NOT NULL,
  `jurusan` varchar(255) NOT NULL,
  `no_urut` int(2) NOT NULL,
  `status` enum('aktif','tidak') NOT NULL DEFAULT 'aktif',
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- Dumping data for table candyskl.matapelajaran: ~20 rows (approximately)

-- Dumping structure for table candyskl.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(11) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- Dumping data for table candyskl.migrations: ~8 rows (approximately)
INSERT INTO `migrations` (`id`, `version`, `class`, `group`, `namespace`, `time`, `batch`) VALUES
	(1, '2024-04-03-124729', 'App\\Database\\Migrations\\Siswa', 'default', 'App', 1712152573, 1),
	(2, '2024-04-03-124735', 'App\\Database\\Migrations\\User', 'default', 'App', 1712152573, 1),
	(3, '2024-04-03-124759', 'App\\Database\\Migrations\\Settings', 'default', 'App', 1712152573, 1),
	(4, '2024-04-03-141047', 'App\\Database\\Migrations\\Logs', 'default', 'App', 1712206126, 2),
	(5, '2024-04-04-135808', 'App\\Database\\Migrations\\Pengumuman', 'default', 'App', 1712239573, 3),
	(6, '2024-04-04-165552', 'App\\Database\\Migrations\\Kelulusan', 'default', 'App', 1712268462, 4),
	(7, '2024-04-08-065133', 'App\\Database\\Migrations\\Matapelajaran', 'default', 'App', 1712559489, 5),
	(8, '2024-04-08-151838', 'App\\Database\\Migrations\\Penilaian', 'default', 'App', 1712590900, 6);

-- Dumping structure for table candyskl.pengumuman
CREATE TABLE IF NOT EXISTS `pengumuman` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `id_user` int(11) NOT NULL DEFAULT 0,
  `judul` varchar(255) NOT NULL,
  `pengumuman` text NOT NULL,
  `status` enum('aktif','tidak') NOT NULL DEFAULT 'aktif',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- Dumping data for table candyskl.pengumuman: ~1 rows (approximately)
INSERT INTO `pengumuman` (`id`, `id_user`, `judul`, `pengumuman`, `status`, `created_at`) VALUES
	(2, 3, 'Test test test', '<p>testttct<strong> ya ty tyadt yadt ya tyad dcad avda a </strong></p><p><strong>dvdav </strong></p><p><strong>davdavadvadvad</strong></p><p><strong>dvadvdavdavdavadvdavadv</strong></p><p><strong>davdavadvda</strong></p>', 'aktif', '2024-04-04 15:28:38');

-- Dumping structure for table candyskl.penilaian
CREATE TABLE IF NOT EXISTS `penilaian` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `nis` varchar(200) NOT NULL,
  `kode_mapel` varchar(250) NOT NULL,
  `nilai` varchar(50) NOT NULL,
  `semester` int(1) NOT NULL DEFAULT 0,
  `tahun_lulus` varchar(250) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- Dumping data for table candyskl.penilaian: ~40 rows (approximately)

-- Dumping structure for table candyskl.settings
CREATE TABLE IF NOT EXISTS `settings` (
  `id` int(11) unsigned NOT NULL,
  `appname` varchar(255) NOT NULL,
  `npsn` varchar(255) NOT NULL,
  `nss` varchar(255) NOT NULL,
  `nama_sekolah` varchar(255) NOT NULL,
  `jenjang` varchar(255) NOT NULL,
  `website` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `alamat_sekolah` varchar(255) NOT NULL,
  `kelurahan` varchar(255) NOT NULL,
  `kecamatan` varchar(255) NOT NULL,
  `kabupaten_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,
  `kementrian` varchar(255) NOT NULL,
  `logokementrian` varchar(255) NOT NULL,
  `logokementrian64` longtext NOT NULL,
  `logo` varchar(255) NOT NULL,
  `logo64` longtext NOT NULL,
  `favicon` varchar(255) NOT NULL,
  `kop_surat` varchar(255) NOT NULL,
  `tgl_pengumuman` datetime NOT NULL,
  `kop64` longtext NOT NULL,
  `key_encrypt` varchar(255) NOT NULL,
  `appversion` varchar(50) NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- Dumping data for table candyskl.settings: ~0 rows (approximately)
INSERT INTO `settings` (`id`, `appname`, `npsn`, `nss`, `nama_sekolah`, `jenjang`, `website`, `email`, `alamat_sekolah`, `kelurahan`, `kecamatan`, `kabupaten_kota`, `provinsi`, `nama_kepsek`, `nip_kepsek`, `tahunpelajaran`, `kementrian`, `logokementrian`, `logokementrian64`, `logo`, `logo64`, `favicon`, `kop_surat`, `tgl_pengumuman`, `kop64`, `key_encrypt`, `appversion`, `updated_at`) VALUES
	(1, 'CANDY SKL PREMIUM VERSION', '69787351', '', 'SKL CANDY', 'SMK', 'www.smkhsagung.sch.id', 'smk.hsagung@gmail.com', 'JL. BUYUT KAIPAH, KP. PULO BAMBU RT 01/02', 'KARANGBAHAGIA', 'KEC. KARANG BAHAGIA', 'KAB. BEKASI', 'PROV. JAWA BARAT', 'Nama Kepala Sekolah', 'NIP Kepala Sekolah', 'Tahun Pelajaran', 'KEMENTRIAN PENDIDIKAN DAN KEBUDAYAAN', 'logomentri.png', '[BLOB]', 'Desain tanpa judul (1).png', '[BLOB]', 'favicon.ico', 'kopsurat.png', '2024-04-10 12:00:00', '[BLOB]', '123456789ABVCDF', '1.0.1', '2024-04-09 10:14:40');

