Jean-PierreGassin/user-control-skeleton

A basic user control skeleton which was created for the sole purpose of personal development.

Requirements

MySQL
PHP 5.4+ (not tested in previous versions)

Installation/usage

Re-name 'env.example' to '.env' and configure
Run composer install
Run yarn install
Run node_modules/.bin/bower install
Run node_modules/.bin/gulp
Execute the following SQL and replace table names:

CREATE DATABASE user_control_skeleton;

CREATE TABLE IF NOT EXISTS user_control_skeleton.users (
    id INT(6) AUTO_INCREMENT PRIMARY KEY,
    user VARCHAR(30) UNIQUE NOT NULL,
    password VARCHAR(100) NOT NULL,
    first_name VARCHAR(30) NOT NULL,
    last_name VARCHAR(30) NOT NULL,
    user_group INT(1) DEFAULT 1,
		created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
		updated_at TIMESTAMP NULL,
		deleted_at TIMESTAMP NULL,
		deleted INT(1) DEFAULT 0
) DEFAULT CHARSET=utf8;

NOTE OF CAUTION:

This is not recommended for production environments