-- --------------------------------------------------------
-- Server OS:                    Win64
-- HeidiSQL Version:             12.6.0.6765
-- --------------------------------------------------------



-- Dumping database structure for auth_db
CREATE DATABASE IF NOT EXISTS `auth_db` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci */;
USE `auth_db`;

-- Dumping structure for function auth_db.check_user_credentials
DELIMITER //
CREATE FUNCTION `check_user_credentials`(p_username VARCHAR(50),
    p_password VARCHAR(255)
) RETURNS tinyint(4)
    DETERMINISTIC
BEGIN
    DECLARE result TINYINT;

    RETURN result;
END//
DELIMITER ;
END//
DELIMITER ;
END//
DELIMITER ;

-- Dumping structure for function auth_db.is_user_logged_in
DELIMITER //
CREATE FUNCTION `is_user_logged_in`(p_username VARCHAR(50)) RETURNS tinyint(4)
    DETERMINISTIC
BEGIN
    DECLARE result TINYINT DEFAULT 0;

    RETURN result;
END//
DELIMITER ;
    END IF;
END//
DELIMITER ;
END//
DELIMITER ;
END//
DELIMITER ;
END//
DELIMITER ;

