PHP Classes

File: database_mysql.sql

Recommend this page to a friend!
  Classes of Con vertor   PHP Auth Class   database_mysql.sql   Download  
File: database_mysql.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: PHP Auth Class
Register and login users stored in a database
Author: By
Last change:
Date: 8 years ago
Size: 2,846 bytes
 

Contents

Class file image Download
-- Adminer 4.2.2 MySQL dump SET NAMES utf8; SET time_zone = '+00:00'; SET foreign_key_checks = 0; SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO'; DROP TABLE IF EXISTS `attempts`; CREATE TABLE `attempts` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ip` varchar(39) NOT NULL, `expiredate` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `config`; CREATE TABLE `config` ( `setting` varchar(100) NOT NULL, `value` varchar(100) DEFAULT NULL, UNIQUE KEY `setting` (`setting`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; INSERT INTO `config` (`setting`, `value`) VALUES ('attack_mitigation_time', '+30 minutes'), ('attempts_before_ban', '30'), ('attempts_before_verify', '5'), ('bcrypt_cost', '10'), ('cookie_domain', NULL), ('cookie_forget', '+30 minutes'), ('cookie_http', '0'), ('cookie_name', 'authID'), ('cookie_path', '/'), ('cookie_remember', '+1 month'), ('cookie_secure', '0'), ('emailmessage_suppress_activation', '0'), ('emailmessage_suppress_reset', '0'), ('mail_charset','UTF-8'), ('password_min_score', '3'), ('site_activation_page', 'activate'), ('site_email', 'no-reply@phpauth.cuonic.com'), ('site_key', 'fghuior.)/!/jdUkd8s2!7HVHG7777ghg'), ('site_name', 'PHPAuth'), ('site_password_reset_page', 'reset'), ('site_timezone', 'Europe/Paris'), ('site_url', 'https://github.com/PHPAuth/PHPAuth'), ('smtp', '0'), ('smtp_auth', '1'), ('smtp_host', 'smtp.example.com'), ('smtp_password', 'password'), ('smtp_port', '25'), ('smtp_security', NULL), ('smtp_username', 'email@example.com'), ('table_attempts', 'attempts'), ('table_requests', 'requests'), ('table_sessions', 'sessions'), ('table_users', 'users'), ('verify_email_max_length', '100'), ('verify_email_min_length', '5'), ('verify_email_use_banlist', '1'), ('verify_password_min_length', '3'), ('request_key_expiration', '+10 minutes'); DROP TABLE IF EXISTS `requests`; CREATE TABLE `requests` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NOT NULL, `rkey` varchar(20) NOT NULL, `expire` datetime NOT NULL, `type` varchar(20) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `sessions`; CREATE TABLE `sessions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NOT NULL, `hash` varchar(40) NOT NULL, `expiredate` datetime NOT NULL, `ip` varchar(39) NOT NULL, `agent` varchar(200) NOT NULL, `cookie_crc` varchar(40) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `users`; CREATE TABLE `users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `email` varchar(100) DEFAULT NULL, `password` varchar(60) DEFAULT NULL, `isactive` tinyint(1) NOT NULL DEFAULT '0', `dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- 2015-11-06 14:09:37