Use the following SQL to create the demo database tables

CREATE DATABASE accesscontrol;

CREATE TABLE IF NOT EXISTS admin (

username varchar(20) NOT NULL,

password varchar(20) NOT NULL,

realfirstName varchar(20) NOT NULL,

reallastName varchar(20) NOT NULL,

role varchar(20) NOT NULL,

>PRIMARY KEY  (username)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO admin (username, password, realfirstName, reallastName, role) VALUES (‘admin’, ‘ a72d11da902a6a63c9702109c9dd3f96’, ‘admin’, ‘admin’, ‘admin’);

INSERT INTO admin (username, password, realfirstName, reallastName, role) VALUES (‘manager’, ‘ a72d11da902a6a63c9702109c9dd3f96’, ‘manager’, ‘manager’, ‘manager’);

INSERT INTO admin (username, password, realfirstName, reallastName, role) VALUES (‘Super’, ‘ a72d11da902a6a63c9702109c9dd3f96’, ‘Super’, ‘Super’, ‘Super’);


Please NOTE:

$password = ‘password’

$salt = “qZPJeZbQv])7fnKxS’U0\2V^Eg.|})+obZ:H6|y.[#EBqo;Evp”

a72d11da902a6a63c9702109c9dd3f96 is the result of MD5($password.$salt)