Simple users database

users.sql

CREATE TABLE homestead.users (
	id int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
	first_name     varchar(50)  NOT NULL,
	last_name      varchar(50)  NOT NULL,
	email          varchar(255) NOT NULL,
	password       varchar(255) NOT NULL,
	created_at     timestamp    NULL DEFAULT NULL,
	updated_at     timestamp    NULL DEFAULT NULL,
	PRIMARY KEY (id),
	UNIQUE KEY users_email_unique (email)
);

DELIMITER ;;

CREATE PROCEDURE homestead.users_add(
    OUT _id            int(10) UNSIGNED,
    IN _first_name     varchar(50),
    IN _last_name      varchar(50),
    IN _email          varchar(255),
    IN _password       varchar(255)
)
BEGIN
    
    INSERT INTO users (first_name, last_name, email, password, created_at)
    VALUES (_first_name, _last_name, _email, _password, NOW());
 
    select last_insert_id() into _id;
END;;

CREATE PROCEDURE homestead.users_update(
    IN _id             int(10) UNSIGNED,
    IN _first_name     varchar(50),
    IN _last_name      varchar(50),
    IN _email          varchar(255),
    IN _password       varchar(255)
)
BEGIN
    
    UPDATE users SET
		first_name     = _first_name, 
		last_name      = _last_name, 
		email          = _email, 
		password       = _password, 
		updated_at     = NOW();
 
END;;

CREATE PROCEDURE homestead.users_delete(
    IN _id int(10) UNSIGNED
)
BEGIN    
    DELETE FROM users WHERE id = _id;
END;;
DELIMITER ;