PHP Classes

File: auth.sql

Recommend this page to a friend!
  Classes of Cuonic   Auth Class   auth.sql   Download  
File: auth.sql
Role: Auxiliary data
Content type: text/plain
Description: The MySQL Database Structure
Class: Auth Class
Manage accounts and authenticate users
Author: By
Last change: Updating to latest version
Date: 11 years ago
Size: 2,248 bytes
 

Contents

Class file image Download
-- phpMyAdmin SQL Dump -- version 3.3.7 -- http://www.phpmyadmin.net -- -- Serveur: localhost -- Généré le : Jeu 19 Janvier 2012 à 01:58 -- Version du serveur: 5.1.58 -- Version de PHP: 5.2.17 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!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 */; -- -- Base de données: `u667856163_auth` -- -- -------------------------------------------------------- -- -- Structure de la table `activitylog` -- CREATE TABLE IF NOT EXISTS `activitylog` ( `id` int(11) NOT NULL AUTO_INCREMENT, `date` datetime NOT NULL, `username` varchar(30) NOT NULL, `action` varchar(100) NOT NULL, `additionalinfo` varchar(500) NOT NULL DEFAULT 'none', `ip` varchar(15) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ; -- -------------------------------------------------------- -- -- Structure de la table `attempts` -- CREATE TABLE IF NOT EXISTS `attempts` ( `ip` varchar(15) NOT NULL, `count` int(11) NOT NULL, `expiredate` datetime NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Structure de la table `sessions` -- CREATE TABLE IF NOT EXISTS `sessions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NOT NULL, `username` varchar(30) NOT NULL, `hash` varchar(32) NOT NULL, `expiredate` datetime NOT NULL, `ip` varchar(15) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; -- -------------------------------------------------------- -- -- Structure de la table `users` -- CREATE TABLE IF NOT EXISTS `users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(30) NOT NULL, `password` varchar(128) NOT NULL, `email` varchar(100) NOT NULL, `isactive` tinyint(1) NOT NULL DEFAULT '0', `activekey` varchar(15) NOT NULL DEFAULT '0', `resetkey` varchar(15) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=73 ;