PHP Classes

File: SQL_file.sql

Recommend this page to a friend!
  Classes of Abed Nego Ragil Putra   PHP Attendance Management System using Fingerprint   SQL_file.sql   Download  
File: SQL_file.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: PHP Attendance Management System using Fingerprint
Keep track of employee attendance with fingerprint
Author: By
Last change:
Date: 4 years ago
Size: 5,061 bytes
 

Contents

Class file image Download
-- phpMyAdmin SQL Dump -- version 4.8.3 -- https://www.phpmyadmin.net/ -- -- Host: localhost -- Waktu pembuatan: 04 Jan 2020 pada 08.31 -- Versi server: 10.1.37-MariaDB -- Versi PHP: 7.1.24 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: `attendace_fingerprint` -- -- -------------------------------------------------------- -- -- Struktur dari tabel `absent` -- CREATE TABLE `absent` ( `id` int(11) NOT NULL, `name` varchar(50) NOT NULL, `date` date NOT NULL, `in_time` time NOT NULL, `out_time` time DEFAULT NULL, `work_hour` time DEFAULT NULL, `over_time` time DEFAULT NULL, `late_time` time DEFAULT NULL, `early_out_time` time DEFAULT NULL, `in_location` varchar(200) NOT NULL, `out_location` varchar(200) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Struktur dari tabel `location` -- CREATE TABLE `location` ( `id` int(11) NOT NULL, `lat` text NOT NULL, `longt` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Struktur dari tabel `md_location` -- CREATE TABLE `md_location` ( `id` int(11) NOT NULL, `md5` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data untuk tabel `md_location` -- INSERT INTO `md_location` (`id`, `md5`) VALUES (1, '77bb6f644872803a4d0f038a2d0565a6'); -- -------------------------------------------------------- -- -- Struktur dari tabel `settings` -- CREATE TABLE `settings` ( `id` int(11) NOT NULL, `start_time` time NOT NULL, `out_time` time NOT NULL, `many_employee` varchar(50) NOT NULL, `key_insert` char(40) NOT NULL, `timezone` varchar(100) NOT NULL, `recaptcha` tinyint(4) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data untuk tabel `settings` -- INSERT INTO `settings` (`id`, `start_time`, `out_time`, `many_employee`, `key_insert`, `timezone`, `recaptcha`) VALUES (1, '08:00:00', '17:00:00', '8', '51e69892ab49df85c6230ccc57f8e1d1606cabbb', 'Asia/Makassar', 0); -- -------------------------------------------------------- -- -- Struktur dari tabel `tokens` -- CREATE TABLE `tokens` ( `id` int(11) NOT NULL, `token` varchar(255) NOT NULL, `user_id` int(10) NOT NULL, `created` date NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Struktur dari tabel `users` -- CREATE TABLE `users` ( `id` int(10) NOT NULL, `email` varchar(100) NOT NULL, `first_name` varchar(100) NOT NULL, `last_name` varchar(100) NOT NULL, `role` varchar(10) NOT NULL, `password` text NOT NULL, `last_login` varchar(100) NOT NULL, `status` varchar(100) NOT NULL, `banned_users` varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data untuk tabel `users` -- INSERT INTO `users` (`id`, `email`, `first_name`, `last_name`, `role`, `password`, `last_login`, `status`, `banned_users`) VALUES (1, 'admin@gmail.com', 'admin', 'admin', '1', 'sha256:1000:afMG4GHoH0gR1YsZz3Odq6W3n1M7wTUG:gjbZhnxB9K0im16imrc+yDM23q+8n1Wm', '2020-01-04 08:30:28 AM', 'approved', 'unban'); -- -- Indexes for dumped tables -- -- -- Indeks untuk tabel `absent` -- ALTER TABLE `absent` ADD PRIMARY KEY (`id`); -- -- Indeks untuk tabel `location` -- ALTER TABLE `location` ADD PRIMARY KEY (`id`); -- -- Indeks untuk tabel `md_location` -- ALTER TABLE `md_location` ADD PRIMARY KEY (`id`); -- -- Indeks untuk tabel `settings` -- ALTER TABLE `settings` ADD PRIMARY KEY (`id`); -- -- Indeks untuk tabel `tokens` -- ALTER TABLE `tokens` ADD PRIMARY KEY (`id`); -- -- Indeks untuk tabel `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT untuk tabel yang dibuang -- -- -- AUTO_INCREMENT untuk tabel `absent` -- ALTER TABLE `absent` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21; -- -- AUTO_INCREMENT untuk tabel `location` -- ALTER TABLE `location` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=252; -- -- AUTO_INCREMENT untuk tabel `md_location` -- ALTER TABLE `md_location` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=125; -- -- AUTO_INCREMENT untuk tabel `settings` -- ALTER TABLE `settings` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT untuk tabel `tokens` -- ALTER TABLE `tokens` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT untuk tabel `users` -- ALTER TABLE `users` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; 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 */;