== Manager creates and assigns shift ==
=== Actors ===
* Manager
=== Steps in the Scenario ===
**__1. Manager logs in.__**

SELECT u.email, u.password FROM users u WHERE u.email = ?; -- and password application check

**__2. Manager sees the created shifts.__**

SELECT date, start_time, end_time FROM shifts WHERE manager_id = %s AND date >= current_date;

**__3. Manager creates shift for the following week for employees.__**

INSERT INTO shifts(id, date, start_time, end_time, manager_id) VALUES (1, '2025-01-05', '08:00:00', '17:00:00', 3);

**__4. Manager assigns shifts to employees__**

INSERT INTO assignments(id, manager_id, employee_id, shift_id) VALUES (1, 3, 1, 1);