-- phpMyAdmin SQL Dump -- version 4.9.7 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Jan 18, 2023 at 02:32 PM -- Server version: 10.3.37-MariaDB -- PHP Version: 7.4.33 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; 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: `jagodig1_aplikasi-santri` -- -- -------------------------------------------------------- -- -- Table structure for table `tb_absensi` -- CREATE TABLE `tb_absensi` ( `id` int(11) NOT NULL, `id_santri` int(11) NOT NULL, `sakit` varchar(256) NOT NULL, `izin` varchar(256) NOT NULL, `alpa` varchar(50) NOT NULL, `keterangan` varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `tb_absensi` -- INSERT INTO `tb_absensi` (`id`, `id_santri`, `sakit`, `izin`, `alpa`, `keterangan`) VALUES (2, 8, '5', '5', '5', '5'); -- -------------------------------------------------------- -- -- Table structure for table `tb_agama` -- CREATE TABLE `tb_agama` ( `id` int(11) NOT NULL, `agama` varchar(30) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `tb_agama` -- INSERT INTO `tb_agama` (`id`, `agama`) VALUES (1, 'ISLAM'), (2, 'KRISTEN'), (3, 'KATHOLIK'), (4, 'HINDU'), (5, 'BUDHA'), (6, 'KONGHUCU'); -- -------------------------------------------------------- -- -- Table structure for table `tb_aplikasi` -- CREATE TABLE `tb_aplikasi` ( `id` int(11) NOT NULL, `nama` varchar(256) NOT NULL, `telp` varchar(16) NOT NULL, `email` varchar(256) NOT NULL, `alamat` text NOT NULL, `logo` varchar(128) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `tb_aplikasi` -- INSERT INTO `tb_aplikasi` (`id`, `nama`, `telp`, `email`, `alamat`, `logo`) VALUES (1, 'Aplikasi Santri', '083190781585', 'santri@gmail.com', 'Ngasem Candi Rt. 03 Rw. 01 Kec. Batealit Kab. Jepara', ''); -- -------------------------------------------------------- -- -- Table structure for table `tb_iprouter` -- CREATE TABLE `tb_iprouter` ( `id` int(10) NOT NULL, `router` varchar(25) NOT NULL, `ip_router` varchar(25) NOT NULL, `nama` varchar(25) NOT NULL, `alamat` varchar(50) NOT NULL, `status` varchar(25) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `tb_iprouter` -- INSERT INTO `tb_iprouter` (`id`, `router`, `ip_router`, `nama`, `alamat`, `status`) VALUES (123, 'huawei', '192.168.100.1', 'adi', 'kudu', 'aktif'), (125, 'orbitkk', '192.168.100.100kk', 'dedikk', 'jln sukajadikk', 'Tidak Aktif'); -- -------------------------------------------------------- -- -- Table structure for table `tb_karyawan` -- CREATE TABLE `tb_karyawan` ( `id` int(11) NOT NULL, `nip` varchar(254) NOT NULL, `fullname` varchar(256) NOT NULL, `nickname` varchar(256) NOT NULL, `status` varchar(256) NOT NULL, `jabatan` varchar(256) NOT NULL, `id_agama` int(11) NOT NULL, `alamat` text NOT NULL, `pendidikan` varchar(256) NOT NULL, `jenis_kelamin` varchar(256) NOT NULL, `tempat_lahir` varchar(256) NOT NULL, `tgl_lahir` date NOT NULL, `tgl_masuk` date NOT NULL, `pelajaran` varchar(256) NOT NULL, `no_telpon` varchar(256) NOT NULL, `email` varchar(256) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `tb_karyawan` -- INSERT INTO `tb_karyawan` (`id`, `nip`, `fullname`, `nickname`, `status`, `jabatan`, `id_agama`, `alamat`, `pendidikan`, `jenis_kelamin`, `tempat_lahir`, `tgl_lahir`, `tgl_masuk`, `pelajaran`, `no_telpon`, `email`) VALUES (1015, '19931010', 'Heri ', 'Heri Saja', 'Menikah', 'Kepala Sekolah', 1, 'Jln Apel No 1', 'S3 Filsafat ', 'S3 Filsafat ', 'S3 Filsafat ', '0000-00-00', '0000-00-00', 'S3 Filsafat ', 'S3 Filsafat ', 'S3 Filsafat '), (1016, '12345678910', 'Muhammad Irsyad', 'Irsyad', 'Palembang', 'Guru', 1, 'Jln Nangka No 1', 'S3 Doktoral', 'S3 Doktoral', 'S3 Doktoral', '0000-00-00', '0000-00-00', 'S3 Doktoral', 'S3 Doktoral', 'S3 Doktoral'); -- -------------------------------------------------------- -- -- Table structure for table `tb_kelas` -- CREATE TABLE `tb_kelas` ( `id` int(11) NOT NULL, `kelas` varchar(256) NOT NULL, `no_ruang` varchar(256) NOT NULL, `gedung` varchar(245) NOT NULL, `wali` varchar(245) NOT NULL, `ajaran` varchar(245) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `tb_kelas` -- INSERT INTO `tb_kelas` (`id`, `kelas`, `no_ruang`, `gedung`, `wali`, `ajaran`) VALUES (1, 'VII', '1 (Satu)', 'Wildan', 'Nur Qomariah', '2023'); -- -------------------------------------------------------- -- -- Table structure for table `tb_log` -- CREATE TABLE `tb_log` ( `id` int(11) NOT NULL, `idUser` int(11) NOT NULL, `ipAddress` varchar(32) NOT NULL, `device` text NOT NULL, `status` varchar(16) NOT NULL, `terdaftar` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `tb_log` -- INSERT INTO `tb_log` (`id`, `idUser`, `ipAddress`, `device`, `status`, `terdaftar`) VALUES (1, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/104.0.0.0 Safari/537.36', 'Login', '2022-09-06 21:47:00'), (2, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/104.0.0.0 Safari/537.36', 'Login', '2022-09-10 11:58:53'), (3, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/105.0.0.0 Safari/537.36', 'Login', '2022-09-11 10:42:02'), (4, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/105.0.0.0 Safari/537.36', 'Login', '2022-09-11 18:20:26'), (5, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2022-12-29 07:54:32'), (6, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2022-12-29 14:32:39'), (7, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2023-01-12 09:21:19'), (8, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2023-01-12 11:02:48'), (9, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2023-01-12 16:57:43'), (10, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2023-01-13 08:36:12'), (11, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2023-01-13 21:22:40'), (12, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Logout', '2023-01-13 22:15:27'), (13, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2023-01-13 22:15:33'), (14, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2023-01-13 22:53:32'), (15, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2023-01-14 09:29:45'), (16, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2023-01-14 18:59:05'), (17, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Logout', '2023-01-14 22:38:29'), (18, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2023-01-14 22:38:34'), (19, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2023-01-15 15:04:30'), (20, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2023-01-15 20:08:44'), (21, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Logout', '2023-01-15 22:06:36'), (22, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2023-01-15 22:06:40'), (23, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2023-01-16 09:24:58'), (24, 1, '103.245.179.131', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2023-01-16 16:02:09'), (25, 1, '103.245.179.131', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Logout', '2023-01-16 16:14:59'), (26, 1, '110.139.80.212', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2023-01-16 19:46:08'), (27, 1, '203.78.116.223', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2023-01-16 21:04:47'), (28, 1, '110.139.80.212', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/534.24 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/534.24 XiaoMi/MiuiBrowser/13.22.1-gn', 'Login', '2023-01-16 21:59:57'), (29, 1, '114.125.252.242', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2023-01-17 20:57:44'), (30, 1, '103.153.187.2', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2023-01-18 10:12:19'), (31, 1, '110.139.80.212', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2023-01-18 10:16:01'), (32, 1, '110.139.80.212', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2023-01-18 12:16:56'); -- -------------------------------------------------------- -- -- Table structure for table `tb_mapel` -- CREATE TABLE `tb_mapel` ( `id` int(11) NOT NULL, `mapel` varchar(256) NOT NULL, `kategori_mapel` varchar(256) NOT NULL, `id_kelas` int(11) NOT NULL, `nama_guru` varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `tb_mapel` -- INSERT INTO `tb_mapel` (`id`, `mapel`, `kategori_mapel`, `id_kelas`, `nama_guru`) VALUES (2, 'Adab', 'none', 1, 'Ustadzah aisyah'); -- -------------------------------------------------------- -- -- Table structure for table `tb_pembayaran` -- CREATE TABLE `tb_pembayaran` ( `id` int(11) NOT NULL, `id_santri` int(11) NOT NULL, `pembayaran` varchar(150) NOT NULL, `deskripsi` varchar(256) NOT NULL, `total` varchar(50) NOT NULL, `tgl_mulai` date NOT NULL, `tgl_akhir` date NOT NULL, `denda` varchar(50) NOT NULL, `keterangan` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `tb_pembayaran` -- INSERT INTO `tb_pembayaran` (`id`, `id_santri`, `pembayaran`, `deskripsi`, `total`, `tgl_mulai`, `tgl_akhir`, `denda`, `keterangan`) VALUES (3, 7, 'Pembayaran Gedung', 'Kredit', '80000', '2023-01-18', '2023-01-18', '90.000', 'abc'), (4, 9, '500000', 'Bayar Buku', '700000', '2023-01-17', '2023-01-25', 'Kurang 200.000', 'dd'), (5, 1015, 'asa', 'asa', 'asa', '2023-01-18', '2023-01-18', 'asa', 'asa'); -- -------------------------------------------------------- -- -- Table structure for table `tb_santri` -- CREATE TABLE `tb_santri` ( `id` int(11) NOT NULL, `nis` varchar(256) NOT NULL, `fullname` varchar(256) NOT NULL, `nickname` varchar(256) NOT NULL, `id_agama` int(11) NOT NULL, `jenis_kelamin` varchar(256) NOT NULL, `tempat_lahir` varchar(256) NOT NULL, `tgl_lahir` varchar(256) NOT NULL, `alamat` varchar(254) NOT NULL, `no_telpon` varchar(160) NOT NULL, `email` varchar(160) NOT NULL, `kelas` varchar(160) NOT NULL, `angkatan` varchar(150) NOT NULL, `tgl_masuk` varchar(150) NOT NULL, `asal_sekolah` varchar(150) NOT NULL, `nama_orangtua` varchar(150) NOT NULL, `pekerjaan_orangtua` varchar(150) NOT NULL, `no_telpon_orangtua` varchar(150) NOT NULL, `alamat_orangtua` varchar(150) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `tb_santri` -- INSERT INTO `tb_santri` (`id`, `nis`, `fullname`, `nickname`, `id_agama`, `jenis_kelamin`, `tempat_lahir`, `tgl_lahir`, `alamat`, `no_telpon`, `email`, `kelas`, `angkatan`, `tgl_masuk`, `asal_sekolah`, `nama_orangtua`, `pekerjaan_orangtua`, `no_telpon_orangtua`, `alamat_orangtua`) VALUES (1015, '2223', 'subhan', 'subhan', 6, 'laki-laki', 'Jakarta', '2023-01-18', 'Jl. Kesatrian', '099988666', 'smkpelita@gmail.com', 'VIII', '2023', '2023-01-19', 'SDN 01 Jakarta', 'Tejo', 'Jamet', '0217665306', 'Jl. Kesatrian'); -- -------------------------------------------------------- -- -- Table structure for table `tb_spp` -- CREATE TABLE `tb_spp` ( `id` int(11) NOT NULL, `id_santri` int(11) NOT NULL, `bulan` varchar(256) NOT NULL, `bayar` varchar(256) NOT NULL, `tgl` date NOT NULL, `keterangan` varchar(256) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `tb_spp` -- INSERT INTO `tb_spp` (`id`, `id_santri`, `bulan`, `bayar`, `tgl`, `keterangan`) VALUES (1, 7, 'Februari', '300.000', '2023-01-15', 'Lunas'), (3, 9, 'Januari', '800000', '2023-01-02', 'Lunas'), (4, 1015, 'asas', 'asa', '2023-01-17', 'sasa'); -- -------------------------------------------------------- -- -- Table structure for table `tb_tahunajaran` -- CREATE TABLE `tb_tahunajaran` ( `id` int(11) NOT NULL, `tahun_ajaran` varchar(256) NOT NULL, `status` varchar(246) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `tb_tahunajaran` -- INSERT INTO `tb_tahunajaran` (`id`, `tahun_ajaran`, `status`) VALUES (1, '2022 -2023', 'Aktif'), (3, '2021 - 2022', 'Tidak Aktif'); -- -------------------------------------------------------- -- -- Table structure for table `tb_user` -- CREATE TABLE `tb_user` ( `id` int(11) NOT NULL, `nama` varchar(256) NOT NULL, `telp` varchar(16) NOT NULL, `email` varchar(256) NOT NULL, `username` varchar(256) NOT NULL, `password` varchar(256) NOT NULL, `foto` varchar(128) NOT NULL, `skin` varchar(8) NOT NULL, `level` varchar(16) NOT NULL, `terdaftar` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `tb_user` -- INSERT INTO `tb_user` (`id`, `nama`, `telp`, `email`, `username`, `password`, `foto`, `skin`, `level`, `terdaftar`) VALUES (1, 'Muhammad Irsyad', '083190781585', 'herimunandar041@gmail.com', 'admin', '$2y$10$PqJLOJUlhKGsRvkkNVdgV.fdGFYhdf6gPYvT3Kom8PyXHFqGVXA8O', 'Profil-1662908905.jpg', 'blue', 'Administrator', '2022-09-06 18:57:59'); -- -- Indexes for dumped tables -- -- -- Indexes for table `tb_absensi` -- ALTER TABLE `tb_absensi` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tb_agama` -- ALTER TABLE `tb_agama` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tb_aplikasi` -- ALTER TABLE `tb_aplikasi` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tb_iprouter` -- ALTER TABLE `tb_iprouter` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tb_karyawan` -- ALTER TABLE `tb_karyawan` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tb_kelas` -- ALTER TABLE `tb_kelas` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tb_log` -- ALTER TABLE `tb_log` ADD PRIMARY KEY (`id`), ADD KEY `FK04` (`idUser`); -- -- Indexes for table `tb_mapel` -- ALTER TABLE `tb_mapel` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tb_pembayaran` -- ALTER TABLE `tb_pembayaran` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tb_santri` -- ALTER TABLE `tb_santri` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tb_spp` -- ALTER TABLE `tb_spp` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tb_tahunajaran` -- ALTER TABLE `tb_tahunajaran` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tb_user` -- ALTER TABLE `tb_user` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `tb_absensi` -- ALTER TABLE `tb_absensi` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `tb_agama` -- ALTER TABLE `tb_agama` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `tb_aplikasi` -- ALTER TABLE `tb_aplikasi` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `tb_iprouter` -- ALTER TABLE `tb_iprouter` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=126; -- -- AUTO_INCREMENT for table `tb_karyawan` -- ALTER TABLE `tb_karyawan` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1017; -- -- AUTO_INCREMENT for table `tb_kelas` -- ALTER TABLE `tb_kelas` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `tb_log` -- ALTER TABLE `tb_log` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33; -- -- AUTO_INCREMENT for table `tb_mapel` -- ALTER TABLE `tb_mapel` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `tb_pembayaran` -- ALTER TABLE `tb_pembayaran` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `tb_santri` -- ALTER TABLE `tb_santri` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1016; -- -- AUTO_INCREMENT for table `tb_spp` -- ALTER TABLE `tb_spp` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `tb_tahunajaran` -- ALTER TABLE `tb_tahunajaran` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `tb_user` -- ALTER TABLE `tb_user` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- Constraints for dumped tables -- -- -- Constraints for table `tb_log` -- ALTER TABLE `tb_log` ADD CONSTRAINT `FK01` FOREIGN KEY (`idUser`) REFERENCES `tb_user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; 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 */;