PHP Classes

File: database/clictoc.sql

Recommend this page to a friend!
  Classes of zinsou A.A.E.Moïse  >  PHP Mnemonic Secret Path Login  >  database/clictoc.sql  >  Download  
File: database/clictoc.sql
Role: Auxiliary data
Content type: text/plain
Description: mySql database dump file
Class: PHP Mnemonic Secret Path Login
Detect human users telling to click on page places
Author: By
Last change:
Date: 4 years ago
Size: 3,156 bytes
 

Contents

Class file image Download
-- phpMyAdmin SQL Dump -- version 4.7.0 -- https://www.phpmyadmin.net/ -- -- Hôte : 127.0.0.1 -- Généré le : sam. 03 fév. 2018 à 09:51 -- Version du serveur : 5.7.17 -- Version de PHP : 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 */; -- -- Base de données : `clicktoc` -- CREATE DATABASE IF NOT EXISTS `clicktoc` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci; USE `clicktoc`; -- -------------------------------------------------------- -- -- Structure de la table `pictures` -- DROP TABLE IF EXISTS `pictures`; CREATE TABLE `pictures` ( `picture_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `path` varchar(256) NOT NULL, `password` varchar(100) NOT NULL, `user_preference` enum('0','1','2','3','4') NOT NULL DEFAULT '0' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Structure de la table `users` -- DROP TABLE IF EXISTS `users`; CREATE TABLE `users` ( `user_id` int(10) UNSIGNED NOT NULL, `username` varchar(25) NOT NULL, `password` varchar(256) NOT NULL, `mail` varchar(256) NOT NULL, `phone` varchar(18) NOT NULL, `firstname` varchar(256) NOT NULL, `lastname` varchar(256) NOT NULL, `dateinscription` bigint(20) UNSIGNED NOT NULL, `user_preference` enum('0','1','2','3','4') NOT NULL DEFAULT '0', `idvalidation` varchar(300) NOT NULL, `statutvalidation` enum('0','1') NOT NULL DEFAULT '0', `role` enum('admin','modo','user') NOT NULL DEFAULT 'user', `default_ctcpic` varchar(256) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Déchargement des données de la table `users` -- INSERT INTO `users` (`user_id`, `username`, `password`, `mail`, `phone`, `firstname`, `lastname`, `dateinscription`, `user_preference`, `idvalidation`, `statutvalidation`, `role`, `default_ctcpic`) VALUES (1, 'zinsou', '21232f297a57a5a743894a0e4a801fc3', 'leizmo@gmail.com', '069659655', 'zinsou', 'moise', 1505986648, '0', '0', '1', 'admin', ''); -- -- Index pour les tables déchargées -- -- -- Index pour la table `pictures` -- ALTER TABLE `pictures` ADD PRIMARY KEY (`picture_id`), ADD UNIQUE KEY `path` (`path`); -- -- Index pour la table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`user_id`), ADD UNIQUE KEY `username` (`username`), ADD UNIQUE KEY `mail` (`mail`), ADD UNIQUE KEY `phone` (`phone`); -- -- AUTO_INCREMENT pour les tables déchargées -- -- -- AUTO_INCREMENT pour la table `pictures` -- ALTER TABLE `pictures` MODIFY `picture_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT pour la table `users` -- ALTER TABLE `users` MODIFY `user_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;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 */;