Changeset f6ed6e4 for petify-backend/sql/dml.sql

Timestamp:

08/22/26 19:00:38 (8 hours ago)

Author:

veronika-ils <ilioskaveronika@…>

Branches:

master

Parents:

ae83647

Message:

feat: The app is consistent with the changes made in phase 1 and phase 2

File:

• petify-backend/sql/dml.sql (modified) (1 diff)

petify-backend/sql/dml.sql

@@ -116 +116 @@
 VALUES (1, (SELECT clinic_id FROM vet_clinics WHERE name='Happy Paws Clinic'));
 
-INSERT INTO user_reviews (review_id, target_user_id) VALUES
-                                                         (2, (SELECT user_id FROM users WHERE username='client.igor')),
-                                                         (3, (SELECT user_id FROM users WHERE username='client.mila'));
+INSERT INTO user_reviews (review_id, target_user_id, interaction_type) VALUES
+                                                         (2, (SELECT user_id FROM users WHERE username='client.igor'), 'PERSONAL_INTERACTION'),
+                                                         (3, (SELECT user_id FROM users WHERE username='client.mila'), 'ONLINE');
 
 INSERT INTO health_records (animal_id, appointment_id, type, description, date) VALUES