-- phpMyAdmin SQL Dump -- version 5.2.2 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Waktu pembuatan: 16 Apr 2026 pada 16.46 -- Versi server: 10.11.16-MariaDB-cll-lve -- Versi PHP: 8.4.19 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `pcmr6852_dbsms` -- -- -------------------------------------------------------- -- -- Struktur dari tabel `disposisi` -- CREATE TABLE `disposisi` ( `id` int(11) NOT NULL, `surat_masuk_id` int(11) NOT NULL, `from_user_id` int(11) NOT NULL, `to_user_id` int(11) NOT NULL, `pesan` text NOT NULL, `status` varchar(50) NOT NULL DEFAULT 'Diteruskan', `lampiran_balasan` varchar(255) DEFAULT NULL, `balasan_text` text DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data untuk tabel `disposisi` -- INSERT INTO `disposisi` (`id`, `surat_masuk_id`, `from_user_id`, `to_user_id`, `pesan`, `status`, `lampiran_balasan`, `balasan_text`, `created_at`, `updated_at`) VALUES (1, 1, 3, 7, 'Ikuti bersama guru lainnya', 'Diteruskan', NULL, NULL, '2026-04-07 10:18:47', '2026-04-07 10:18:47'), (2, 2, 4, 15, 'Ikuti bersama guru lainnya', 'Diteruskan', NULL, NULL, '2026-04-07 10:48:04', '2026-04-07 10:48:04'), (3, 3, 3, 7, 'IKuti Kegiatan ini', 'Diteruskan', NULL, NULL, '2026-04-10 13:52:40', '2026-04-10 13:52:40'), (4, 4, 2, 4, 'Agar ditugaskan', 'Diteruskan', NULL, NULL, '2026-04-16 16:01:30', '2026-04-16 16:01:30'); -- -------------------------------------------------------- -- -- Struktur dari tabel `instansi` -- CREATE TABLE `instansi` ( `id` int(11) NOT NULL, `code` varchar(50) NOT NULL, `name` varchar(150) NOT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data untuk tabel `instansi` -- INSERT INTO `instansi` (`id`, `code`, `name`, `created_at`, `updated_at`) VALUES (1, 'MAJELIS', 'Majelis Dikdasmen PNF PCM Ujung', '2026-04-06 20:40:31', '2026-04-06 20:40:31'), (2, 'SDM2', 'SD Muhammadiyah 2 Parepare', '2026-04-06 20:40:31', '2026-04-06 20:40:31'), (3, 'SDITAD', 'SD IT Muhammadiyah Ahmad Dahlan Parepare', '2026-04-06 20:40:31', '2026-04-06 20:40:31'); -- -------------------------------------------------------- -- -- Struktur dari tabel `kop_surat` -- CREATE TABLE `kop_surat` ( `id` int(11) NOT NULL, `instansi_id` int(11) NOT NULL, `nama_lembaga` varchar(255) NOT NULL, `alamat` text DEFAULT NULL, `telepon` varchar(100) DEFAULT NULL, `email` varchar(150) DEFAULT NULL, `website` varchar(150) DEFAULT NULL, `logo_path` varchar(255) DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data untuk tabel `kop_surat` -- INSERT INTO `kop_surat` (`id`, `instansi_id`, `nama_lembaga`, `alamat`, `telepon`, `email`, `website`, `logo_path`, `created_at`, `updated_at`) VALUES (1, 1, 'Majelis Dikdasmen PNF PCM Ujung', 'Jalan Jendral Ahmad Yani KM 6, Kota Parepare', '085113444977', 'dikdasmen@pcmujung.com', 'dikdasmen.pcmujung.com', 'assets/uploads/kop_surat/20260406214518_6fc45f7a145c.png', '2026-04-06 20:40:31', '2026-04-06 20:45:18'), (2, 2, 'SD Muhammadiyah 2 Parepare', 'Kompleks BTN Lapadde Mas, Kelurahan Lapadde, Kecamatan Ujung Kota Parepare', '085113444977', 'sdm2@pcmujung.com', 'dikdasmen.pcmujung.com', 'assets/uploads/kop_surat/20260408071340_1d6e808895ed.png', '2026-04-06 20:40:31', '2026-04-08 06:13:40'), (3, 3, 'SD IT Muhammadiyah Ahmad Dahlan Parepare', 'Jalan Tengah Galung, Kecamatan Ujung Kota Parepare', '085113444977', 'sdit.ahmaddahlan@pcmujung.com', 'dikdasmen.pcmujung.com', 'assets/uploads/kop_surat/20260408071246_e4fe128b4276.jpeg', '2026-04-06 20:40:31', '2026-04-08 06:12:46'); -- -------------------------------------------------------- -- -- Struktur dari tabel `memo` -- CREATE TABLE `memo` ( `id` int(11) NOT NULL, `nomor_memo` varchar(100) NOT NULL, `tanggal_memo` date NOT NULL, `tanggal_input` date NOT NULL, `perihal` varchar(255) NOT NULL, `tujuan_memo` varchar(255) NOT NULL, `penginput_user_id` int(11) NOT NULL, `instansi_id` int(11) DEFAULT NULL, `file_path` varchar(255) DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data untuk tabel `memo` -- INSERT INTO `memo` (`id`, `nomor_memo`, `tanggal_memo`, `tanggal_input`, `perihal`, `tujuan_memo`, `penginput_user_id`, `instansi_id`, `file_path`, `created_at`, `updated_at`) VALUES (1, '01', '2026-04-10', '2026-04-10', 'Penggunaan Website dan Sistem Manajemen Persuratan', 'Dahlina', 1, 1, NULL, '2026-04-10 08:13:17', '2026-04-10 16:56:24'), (2, '01', '2026-04-10', '2026-04-10', 'Pencairan dana operasional', 'Hijrah', 4, 3, NULL, '2026-04-10 16:58:09', '2026-04-10 16:58:09'), (3, '03', '2026-04-16', '2026-04-16', 'Undangan Rapat Koordinasi Website dan Sistem Persuratan', 'Henra Ahmad', 2, 1, NULL, '2026-04-16 16:02:39', '2026-04-16 16:02:39'); -- -------------------------------------------------------- -- -- Struktur dari tabel `roles` -- CREATE TABLE `roles` ( `id` int(11) NOT NULL, `code` varchar(50) NOT NULL, `name` varchar(100) NOT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data untuk tabel `roles` -- INSERT INTO `roles` (`id`, `code`, `name`, `created_at`, `updated_at`) VALUES (1, 'SUPER_ADMIN', 'Super Admin', '2026-04-06 20:40:31', '2026-04-06 20:40:31'), (2, 'KETUA_MAJELIS', 'Ketua Majelis Dikdasmen', '2026-04-06 20:40:31', '2026-04-06 20:40:31'), (3, 'ANGGOTA_MAJELIS', 'Anggota Majelis Dikdasmen', '2026-04-06 20:40:31', '2026-04-06 20:40:31'), (4, 'KEPALA_SEKOLAH', 'Kepala Sekolah', '2026-04-06 20:40:31', '2026-04-06 20:40:31'), (5, 'WAKIL_KEPALA', 'Wakil Kepala Sekolah', '2026-04-06 20:40:31', '2026-04-06 20:40:31'), (6, 'GURU', 'Guru', '2026-04-06 20:40:31', '2026-04-06 20:40:31'), (7, 'STAF', 'Staf', '2026-04-06 20:40:31', '2026-04-06 20:40:31'), (8, 'PENGIRIM_SURAT', 'Pengirim Surat', '2026-04-06 20:40:31', '2026-04-06 20:40:31'); -- -------------------------------------------------------- -- -- Struktur dari tabel `surat_masuk` -- CREATE TABLE `surat_masuk` ( `id` int(11) NOT NULL, `tracking_code` varchar(50) NOT NULL, `tanggal_surat` date NOT NULL, `tanggal_input` date NOT NULL, `nomor_surat` varchar(100) NOT NULL, `perihal` varchar(255) NOT NULL, `asal_surat` varchar(255) NOT NULL, `tujuan_user_id` int(11) NOT NULL, `tujuan_role_label` varchar(150) DEFAULT NULL, `penginput_user_id` int(11) NOT NULL, `instansi_id` int(11) DEFAULT NULL, `file_path` varchar(255) NOT NULL, `status` varchar(50) NOT NULL DEFAULT 'Diterima', `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data untuk tabel `surat_masuk` -- INSERT INTO `surat_masuk` (`id`, `tracking_code`, `tanggal_surat`, `tanggal_input`, `nomor_surat`, `perihal`, `asal_surat`, `tujuan_user_id`, `tujuan_role_label`, `penginput_user_id`, `instansi_id`, `file_path`, `status`, `created_at`, `updated_at`) VALUES (1, 'SMS-521837B7', '2026-04-07', '2026-04-07', '001/II.3.AU/F/2026', 'Undangan Sosialisasi Website DIKDASMEN UJUNG', 'Majelis Dikdasmen', 3, 'Pimpinan Tujuan', 14, 2, 'assets/uploads/surat_masuk/20260407111811_13eaae12f435.pdf', 'Didisposisikan', '2026-04-07 10:18:11', '2026-04-07 10:18:47'), (2, 'SMS-35E048CD', '2026-04-07', '2026-04-07', '001/II.3.AU/F/2026', 'Undangan Sosialisasi Website DIKDASMEN UJUNG', 'Majelis Dikdasmen', 4, 'Pimpinan Tujuan', 14, 3, 'assets/uploads/surat_masuk/20260407114718_4bf75c59f65a.pdf', 'Didisposisikan', '2026-04-07 10:47:18', '2026-04-07 10:48:04'), (3, 'SMS-8F533BA8', '2026-04-08', '2026-04-08', '002/II.3.AU/F/2026', 'Undangan Rapat Koordinasi Website dan Sistem Persuratan', 'Majelis Dikdasmen PNF PCM Ujung', 3, 'Pimpinan Tujuan', 1, 2, 'assets/uploads/surat_masuk/20260410082815_06ce0ed2d666.pdf', 'Didisposisikan', '2026-04-10 07:28:15', '2026-04-10 13:52:40'), (4, 'SMS-02E6AAA7', '2026-04-08', '2026-04-08', '002/II.3.AU/F/2026', 'Undangan Rapat Koordinasi Website dan Sistem Persuratan', 'Majelis Dikdasmen PNF PCM Ujung', 4, 'Pimpinan Tujuan', 1, 3, 'assets/uploads/surat_masuk/20260410082947_50b56e7d3636.pdf', 'Didisposisikan', '2026-04-10 07:29:47', '2026-04-16 16:01:30'); -- -------------------------------------------------------- -- -- Struktur dari tabel `users` -- CREATE TABLE `users` ( `id` int(11) NOT NULL, `name` varchar(150) NOT NULL, `email` varchar(150) NOT NULL, `password` varchar(255) NOT NULL, `nbm` varchar(50) DEFAULT NULL, `jabatan` varchar(150) DEFAULT NULL, `instansi_nama_pengirim` varchar(150) DEFAULT NULL, `instansi_id` int(11) DEFAULT NULL, `role_id` int(11) NOT NULL, `signature_path` varchar(255) DEFAULT NULL, `email_verification_token` varchar(100) DEFAULT NULL, `email_verified_at` datetime DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data untuk tabel `users` -- INSERT INTO `users` (`id`, `name`, `email`, `password`, `nbm`, `jabatan`, `instansi_nama_pengirim`, `instansi_id`, `role_id`, `signature_path`, `email_verification_token`, `email_verified_at`, `created_at`, `updated_at`) VALUES (1, 'Super Admin SMS', 'superadmin@sms.pcmujung.com', '$2y$12$Zf.sVJl5yYi.P5aP3CeH.ur3RipYqID6oFLBVP8fAdDqp.YVIC5iC', '000001', 'Admin Majelis Dikdasmen', NULL, 1, 1, NULL, NULL, '2026-04-06 20:40:31', '2026-04-06 20:40:31', '2026-04-06 20:40:31'), (2, 'Ketua Majelis', 'henraahmad.umpar@gmail.com', '$2y$12$Zf.sVJl5yYi.P5aP3CeH.ur3RipYqID6oFLBVP8fAdDqp.YVIC5iC', '000002', 'Ketua Majelis Dikdasmen', NULL, 1, 2, NULL, NULL, '2026-04-06 20:40:31', '2026-04-06 20:40:31', '2026-04-15 12:26:18'), (3, 'Kepala SD Muhammadiyah 2', 'kepalasm2@sms.pcmujung.com', '$2y$12$Zf.sVJl5yYi.P5aP3CeH.ur3RipYqID6oFLBVP8fAdDqp.YVIC5iC', '000003', 'Kepala Sekolah', NULL, 2, 4, NULL, NULL, '2026-04-06 20:40:31', '2026-04-06 20:40:31', '2026-04-06 20:40:31'), (4, 'Alimuddin, S.Pd.', 'kepalasdit@sms.pcmujung.com', '$2y$12$Zf.sVJl5yYi.P5aP3CeH.ur3RipYqID6oFLBVP8fAdDqp.YVIC5iC', '000004', 'Kepala Sekolah', NULL, 3, 4, 'assets/uploads/ttd/20260410114240_7fd33363acf4.png', NULL, '2026-04-06 20:40:31', '2026-04-06 20:40:31', '2026-04-10 10:43:12'), (7, 'Dahlina', 'dahlina@pcmujung.com', '$2y$10$zzbpUF/3Wlutdp5DagCABOq8bKYz64ZU1RiEQarXQ6m3yTZf1mFsi', '1234567', 'Wakil Kepala Sekolah', NULL, 2, 6, NULL, NULL, '2026-04-06 22:09:51', '2026-04-06 21:09:51', '2026-04-06 21:09:51'), (14, 'Henra Ahmad', 'kkn.duatujuh@gmail.com', '$2y$10$A0HbJOrpvtixTCr.2967l.9jvm9qOsuj/2dfyM46IkwesgsuFNeoK', '0917108701', 'Pengirim Surat', 'UMPAR', NULL, 8, NULL, '60fc1d8e8fd0d5aa874d316a1a6019316ec374f42abe189a', NULL, '2026-04-07 08:09:14', '2026-04-07 09:51:03'), (15, 'Hijrah', 'hijrah@pcmujung.com', '$2y$10$bdhy3lnv7T32x8my0V.1auPzy0sVKe1QIBYYDZak2W2qPMDsWuUu6', '1234567', 'Wakil Kepala Sekolah', NULL, 3, 6, NULL, NULL, '2026-04-07 11:45:33', '2026-04-07 10:45:33', '2026-04-07 10:46:06'); -- -- Indexes for dumped tables -- -- -- Indeks untuk tabel `disposisi` -- ALTER TABLE `disposisi` ADD PRIMARY KEY (`id`), ADD KEY `fk_disposisi_surat` (`surat_masuk_id`), ADD KEY `fk_disposisi_from` (`from_user_id`), ADD KEY `fk_disposisi_to` (`to_user_id`); -- -- Indeks untuk tabel `instansi` -- ALTER TABLE `instansi` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `code` (`code`); -- -- Indeks untuk tabel `kop_surat` -- ALTER TABLE `kop_surat` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `instansi_id` (`instansi_id`); -- -- Indeks untuk tabel `memo` -- ALTER TABLE `memo` ADD PRIMARY KEY (`id`), ADD KEY `fk_memo_penginput` (`penginput_user_id`), ADD KEY `fk_memo_instansi` (`instansi_id`); -- -- Indeks untuk tabel `roles` -- ALTER TABLE `roles` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `code` (`code`); -- -- Indeks untuk tabel `surat_masuk` -- ALTER TABLE `surat_masuk` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `tracking_code` (`tracking_code`), ADD KEY `fk_surat_tujuan` (`tujuan_user_id`), ADD KEY `fk_surat_penginput` (`penginput_user_id`), ADD KEY `fk_surat_instansi` (`instansi_id`); -- -- Indeks untuk tabel `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `email` (`email`), ADD KEY `fk_users_instansi` (`instansi_id`), ADD KEY `fk_users_roles` (`role_id`); -- -- AUTO_INCREMENT untuk tabel yang dibuang -- -- -- AUTO_INCREMENT untuk tabel `disposisi` -- ALTER TABLE `disposisi` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT untuk tabel `instansi` -- ALTER TABLE `instansi` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT untuk tabel `kop_surat` -- ALTER TABLE `kop_surat` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT untuk tabel `memo` -- ALTER TABLE `memo` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT untuk tabel `roles` -- ALTER TABLE `roles` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT untuk tabel `surat_masuk` -- ALTER TABLE `surat_masuk` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT untuk tabel `users` -- ALTER TABLE `users` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16; -- -- Ketidakleluasaan untuk tabel pelimpahan (Dumped Tables) -- -- -- Ketidakleluasaan untuk tabel `disposisi` -- ALTER TABLE `disposisi` ADD CONSTRAINT `fk_disposisi_from` FOREIGN KEY (`from_user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `fk_disposisi_surat` FOREIGN KEY (`surat_masuk_id`) REFERENCES `surat_masuk` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `fk_disposisi_to` FOREIGN KEY (`to_user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Ketidakleluasaan untuk tabel `kop_surat` -- ALTER TABLE `kop_surat` ADD CONSTRAINT `fk_kop_instansi` FOREIGN KEY (`instansi_id`) REFERENCES `instansi` (`id`) ON DELETE CASCADE; -- -- Ketidakleluasaan untuk tabel `memo` -- ALTER TABLE `memo` ADD CONSTRAINT `fk_memo_instansi` FOREIGN KEY (`instansi_id`) REFERENCES `instansi` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `fk_memo_penginput` FOREIGN KEY (`penginput_user_id`) REFERENCES `users` (`id`); -- -- Ketidakleluasaan untuk tabel `surat_masuk` -- ALTER TABLE `surat_masuk` ADD CONSTRAINT `fk_surat_instansi` FOREIGN KEY (`instansi_id`) REFERENCES `instansi` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `fk_surat_penginput` FOREIGN KEY (`penginput_user_id`) REFERENCES `users` (`id`), ADD CONSTRAINT `fk_surat_tujuan` FOREIGN KEY (`tujuan_user_id`) REFERENCES `users` (`id`); -- -- Ketidakleluasaan untuk tabel `users` -- ALTER TABLE `users` ADD CONSTRAINT `fk_users_instansi` FOREIGN KEY (`instansi_id`) REFERENCES `instansi` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `fk_users_roles` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`); COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;