== 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)}}}