Changes between Version 2 and Version 3 of AdvancedDatabaseDevelopment
- Timestamp:
- 05/28/26 03:53:54 (6 hours ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
AdvancedDatabaseDevelopment
v2 v3 43 43 $$; 44 44 45 DROP TRIGGER IF EXISTS trg_booking_validation ON bookings;45 DROP TRIGGER IF EXISTS trg_booking_validation ON project.bookings; 46 46 CREATE TRIGGER trg_booking_validation 47 47 BEFORE INSERT OR UPDATE ON project.bookings … … 89 89 $$; 90 90 91 DROP TRIGGER IF EXISTS trg_review_integrity ON reviews;91 DROP TRIGGER IF EXISTS trg_review_integrity ON project.reviews; 92 92 CREATE TRIGGER trg_review_integrity 93 93 BEFORE INSERT ON project.reviews … … 105 105 $$; 106 106 107 DROP TRIGGER IF EXISTS trg_reviews_no_update ON reviews;107 DROP TRIGGER IF EXISTS trg_reviews_no_update ON project.reviews; 108 108 CREATE TRIGGER trg_reviews_no_update 109 109 BEFORE UPDATE ON project.reviews
