Index: backend/src/main/resources/db.migration/V3__Insert_Doctor_Users.sql
===================================================================
--- backend/src/main/resources/db.migration/V3__Insert_Doctor_Users.sql	(revision 6c00695efaeff79d43ec7934ae4e04fac7bd67a0)
+++ backend/src/main/resources/db.migration/V3__Insert_Doctor_Users.sql	(revision 6c00695efaeff79d43ec7934ae4e04fac7bd67a0)
@@ -0,0 +1,8 @@
+-- Insert Doctor users from doctors table
+INSERT INTO users (username, password, role, first_name, last_name, doctor_id, is_active)
+SELECT d.email_address, 'doctor123', 'DOCTOR', d.first_name, d.last_name, d.doctor_id, true
+FROM doctors d
+WHERE NOT EXISTS (
+    SELECT 1 FROM users u WHERE u.username = d.email_address
+)
+ON CONFLICT (username) DO NOTHING;
Index: backend/src/main/resources/db.migration/V4__Insert_Lab_Technician_Users.sql
===================================================================
--- backend/src/main/resources/db.migration/V4__Insert_Lab_Technician_Users.sql	(revision 6c00695efaeff79d43ec7934ae4e04fac7bd67a0)
+++ backend/src/main/resources/db.migration/V4__Insert_Lab_Technician_Users.sql	(revision 6c00695efaeff79d43ec7934ae4e04fac7bd67a0)
@@ -0,0 +1,9 @@
+-- Insert Lab Technician users
+INSERT INTO users (username, password, role, first_name, last_name, is_active)
+VALUES
+  ('lab_darko', 'lab123', 'LAB_TECHNICIAN', 'Darko', 'Milosev', true),
+  ('lab_biljana', 'lab123', 'LAB_TECHNICIAN', 'Biljana', 'Trajkovska', true),
+  ('lab_stefan', 'lab123', 'LAB_TECHNICIAN', 'Stefan', 'Nikolovski', true),
+  ('lab_marina', 'lab123', 'LAB_TECHNICIAN', 'Marina', 'Petreska', true),
+  ('lab_aleksandar', 'lab123', 'LAB_TECHNICIAN', 'Aleksandar', 'Ristovski', true)
+ON CONFLICT (username) DO NOTHING;
Index: backend/src/main/resources/db.migration/V5__Insert_Billing_Admin_Users.sql
===================================================================
--- backend/src/main/resources/db.migration/V5__Insert_Billing_Admin_Users.sql	(revision 6c00695efaeff79d43ec7934ae4e04fac7bd67a0)
+++ backend/src/main/resources/db.migration/V5__Insert_Billing_Admin_Users.sql	(revision 6c00695efaeff79d43ec7934ae4e04fac7bd67a0)
@@ -0,0 +1,16 @@
+-- Insert Billing Admin users
+INSERT INTO users (username, password, role, first_name, last_name, is_active)
+SELECT 'admin_ilija', 'adminmedora123', 'BILLING_ADMIN', 'Ilija', 'Admin', true
+WHERE NOT EXISTS (SELECT 1 FROM users WHERE username = 'admin_ilija')
+UNION ALL
+SELECT 'admin_elena', 'adminmedora123', 'BILLING_ADMIN', 'Elena', 'Admin', true
+WHERE NOT EXISTS (SELECT 1 FROM users WHERE username = 'admin_elena')
+UNION ALL
+SELECT 'admin_marjan', 'adminmedora123', 'BILLING_ADMIN', 'Marjan', 'Admin', true
+WHERE NOT EXISTS (SELECT 1 FROM users WHERE username = 'admin_marjan')
+UNION ALL
+SELECT 'admin_vesna', 'adminmedora123', 'BILLING_ADMIN', 'Vesna', 'Admin', true
+WHERE NOT EXISTS (SELECT 1 FROM users WHERE username = 'admin_vesna')
+UNION ALL
+SELECT 'admin_dushanka', 'adminmedora123', 'BILLING_ADMIN', 'Dushanka', 'Admin', true
+WHERE NOT EXISTS (SELECT 1 FROM users WHERE username = 'admin_dushanka');
