-- phpMyAdmin SQL Dump -- version 5.2.0 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Feb 25, 2023 at 04:58 AM -- Server version: 10.4.24-MariaDB -- PHP Version: 7.4.29 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: `aplikasi-kas` -- -- -------------------------------------------------------- -- -- 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; -- -- Dumping data for table `tb_aplikasi` -- INSERT INTO `tb_aplikasi` (`id`, `nama`, `telp`, `email`, `alamat`, `logo`) VALUES (1, 'Aplikasi Kas', '083190781585', 'jagodigital@gmail.com', 'Jakarta', ''); -- -------------------------------------------------------- -- -- Table structure for table `tb_kas` -- CREATE TABLE `tb_kas` ( `id` int(11) NOT NULL, `tanggal` date NOT NULL, `jenis_kas` varchar(250) NOT NULL, `jumlah` int(11) NOT NULL, `keterangan` varchar(250) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `tb_kas` -- INSERT INTO `tb_kas` (`id`, `tanggal`, `jenis_kas`, `jumlah`, `keterangan`) VALUES (5, '2023-02-24', 'Pemasukan', 300000, 'kopi'), (9, '2023-02-24', 'Pemasukan', 500000, 'rokok'), (10, '2023-02-25', 'Pengeluaran', 5000, 'sabun'); -- -------------------------------------------------------- -- -- Table structure for table `tb_kelas` -- CREATE TABLE `tb_kelas` ( `id` int(11) NOT NULL, `nama_kelas` varchar(10) NOT NULL, `kompetensi_keahlian` varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `tb_kelas` -- INSERT INTO `tb_kelas` (`id`, `nama_kelas`, `kompetensi_keahlian`) VALUES (2, 'XII', 'TEKNIK JARINGAN 1'), (3, 'XII', 'TEKNIK LISTRIK'); -- -------------------------------------------------------- -- -- 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; -- -- 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/109.0.0.0 Safari/537.36', 'Login', '2023-02-12 09:54:19'), (2, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Login', '2023-02-12 15:32:39'), (3, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Login', '2023-02-12 21:43:31'), (4, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Login', '2023-02-13 19:45:46'), (5, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Logout', '2023-02-13 21:52:38'), (6, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Login', '2023-02-13 21:52:44'), (7, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/110.0.0.0 Safari/537.36', 'Login', '2023-02-24 19:49:45'), (8, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/110.0.0.0 Safari/537.36', 'Logout', '2023-02-24 22:15:58'), (9, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/110.0.0.0 Safari/537.36', 'Login', '2023-02-24 22:16:06'), (10, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/110.0.0.0 Safari/537.36', 'Logout', '2023-02-25 00:39:41'), (11, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/110.0.0.0 Safari/537.36', 'Login', '2023-02-25 00:41:44'), (12, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/110.0.0.0 Safari/537.36', 'Login', '2023-02-25 08:02:09'); -- -------------------------------------------------------- -- -- Table structure for table `tb_pembayaran` -- CREATE TABLE `tb_pembayaran` ( `id` int(11) NOT NULL, `id_siswa` int(11) NOT NULL, `id_user` int(11) NOT NULL, `tgl_bayar` date NOT NULL, `bulan_bayar` varchar(8) NOT NULL, `id_spp` int(11) NOT NULL, `jumlah_bayar` int(250) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `tb_pembayaran` -- INSERT INTO `tb_pembayaran` (`id`, `id_siswa`, `id_user`, `tgl_bayar`, `bulan_bayar`, `id_spp`, `jumlah_bayar`) VALUES (1, 1, 1, '2023-02-12', '12', 1, 500000), (2, 1, 1, '2023-02-18', '122', 1, 800000), (3, 1, 1, '2023-02-01', '11', 2, 400000); -- -------------------------------------------------------- -- -- Table structure for table `tb_spp` -- CREATE TABLE `tb_spp` ( `id` int(11) NOT NULL, `tahun` int(11) NOT NULL, `nominal` int(250) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `tb_spp` -- INSERT INTO `tb_spp` (`id`, `tahun`, `nominal`) VALUES (1, 2023, 600000), (2, 2022, 500000); -- -------------------------------------------------------- -- -- 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; -- -- Dumping data for table `tb_user` -- INSERT INTO `tb_user` (`id`, `nama`, `telp`, `email`, `username`, `password`, `foto`, `skin`, `level`, `terdaftar`) VALUES (1, 'Jagodigital', '083190781585', 'jagodigital@gmail.com', 'admin', '$2y$10$erW39oW5NsCyTVGCrjCcl.ygOiI48VtPqyu1Sr0gC.3G0.bjZ/.De', 'Profil-1676174570.jpg', 'blue', 'Administrator', '2022-09-06 18:57:59'); -- -- Indexes for dumped tables -- -- -- Indexes for table `tb_aplikasi` -- ALTER TABLE `tb_aplikasi` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tb_kas` -- ALTER TABLE `tb_kas` 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_pembayaran` -- ALTER TABLE `tb_pembayaran` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tb_spp` -- ALTER TABLE `tb_spp` 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_aplikasi` -- ALTER TABLE `tb_aplikasi` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `tb_kas` -- ALTER TABLE `tb_kas` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `tb_kelas` -- ALTER TABLE `tb_kelas` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `tb_log` -- ALTER TABLE `tb_log` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- AUTO_INCREMENT for table `tb_pembayaran` -- ALTER TABLE `tb_pembayaran` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `tb_spp` -- ALTER TABLE `tb_spp` 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 */;