Mind Tools Test App

A concept application allowing users to register on the site and verify email to allow them to login.

Requirements

• PHP >= 5.3
• Apache 2
• Composer for dependency installation

Database creation SQL

Execute this on the MySQL database to allow the users to be stored. There is the possibility to replace the depedency on MySQL with another storage backend.

-- Mind Tools Test App
-- Database creation script

CREATE DATABASE mindtools;

CREATE TABLE mindtools.users
(
  id int PRIMARY KEY NOT NULL AUTO_INCREMENT,
  username varchar(255) NOT NULL,
  email varchar(255) NOT NULL,
  name varchar(255) NOT NULL,
  password_hash varchar(255) NOT NULL,
  verification_code varchar(255) NOT NULL,
  status enum('enabled', 'disabled', 'awaiting_verification') DEFAULT 'awaiting_verification' NOT NULL
);