PHP Classes

File: database.sql

Recommend this page to a friend!
  Classes of Cuonic  >  PHPAuth  >  database.sql  >  Download  
File: database.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: PHPAuth
Register and authenticate users stored in MySQL
Author: By
Last change: Spring cleaning... Big changes, take a look before you update.
Date: 8 years ago
Size: 3,081 bytes
 

Contents

Class file image Download
-- phpMyAdmin SQL Dump -- version 4.1.14 -- http://www.phpmyadmin.net -- -- Host: 127.0.0.1 -- Generation Time: Aug 15, 2014 at 02:48 AM -- Server version: 5.6.17 -- PHP Version: 5.5.12 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; 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 utf8 */; -- -- Database: `frontend` -- -- -------------------------------------------------------- -- -- Table structure for table `attempts` -- CREATE TABLE IF NOT EXISTS `attempts` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ip` varchar(39) NOT NULL, `count` int(11) NOT NULL, `expiredate` datetime NOT NULL, PRIMARY KEY (`id`), KEY `ip` (`ip`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ; -- -------------------------------------------------------- -- -- Table structure for table `log` -- CREATE TABLE IF NOT EXISTS `log` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NOT NULL DEFAULT '0', `action` varchar(100) NOT NULL, `info` varchar(1000) NOT NULL DEFAULT 'None provided', `ip` varchar(39) NOT NULL DEFAULT '0.0.0.0', `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ; -- -------------------------------------------------------- -- -- Table structure for table `requests` -- CREATE TABLE IF NOT EXISTS `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`), KEY `activekey` (`rkey`), KEY `uid` (`uid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ; -- -------------------------------------------------------- -- -- Table structure for table `sessions` -- CREATE TABLE IF NOT EXISTS `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`), KEY `hash` (`hash`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ; -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE IF NOT EXISTS `users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(30) DEFAULT NULL, `password` varchar(60) DEFAULT NULL, `email` varchar(100) DEFAULT NULL, `salt` varchar(22) DEFAULT NULL, `isactive` tinyint(1) NOT NULL DEFAULT '0', `dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `email` (`email`), KEY `username` (`username`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ; /*!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 */;