CREATE DATABASE IF NOT EXISTS booking_system;
USE booking_system;

CREATE TABLE users(
 id INT AUTO_INCREMENT PRIMARY KEY,
 name VARCHAR(100),
 email VARCHAR(100) UNIQUE,
 password VARCHAR(255),
 hourly_rate DECIMAL(10,2),
 booking_status ENUM('online','offline') DEFAULT 'offline'
);

INSERT INTO users(name,email,password,hourly_rate,booking_status)
VALUES
('User A','usera@test.com','$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi',25,'online'),
('User B','userb@test.com','$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi',40,'online');

-- Password for both users: password