PHP Classes

File: SQL-File.sql

Recommend this page to a friend!
  Classes of Abed Nego Ragil Putra   Attendance Login System   SQL-File.sql   Download  
File: SQL-File.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: Attendance Login System
Manage and authenticate company employees users
Author: By
Last change: improve and adding feature

adding settings for turn off/on recaptcha, employess can see the history absent
Date: 5 years ago
Size: 3,883 bytes
 

Contents

Class file image Download
-- phpMyAdmin SQL Dump -- version 4.7.3 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Nov 27, 2017 at 01:40 AM -- Server version: 10.1.29-MariaDB -- PHP Version: 5.6.30 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: `absent` -- -- -------------------------------------------------------- -- -- Table structure for table `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; -- -- Table structure for table `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 for table `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); -- -------------------------------------------------------- -- -- Table structure for table `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; -- -- Table structure for table `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 for table `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', '2017-11-27 01:35:25 AM', 'approved', 'unban'); -- -- Indexes for dumped tables -- -- -- Indexes for table `absent` -- ALTER TABLE `absent` ADD PRIMARY KEY (`id`); -- -- Indexes for table `settings` -- ALTER TABLE `settings` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tokens` -- ALTER TABLE `tokens` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `absent` -- ALTER TABLE `absent` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1; -- -- AUTO_INCREMENT for table `settings` -- ALTER TABLE `settings` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `tokens` -- ALTER TABLE `tokens` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;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 */;