Changes between Version 2 and Version 3 of AdvancedDatabaseDevelopment


Ignore:
Timestamp:
05/28/26 03:53:54 (6 hours ago)
Author:
181201
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • AdvancedDatabaseDevelopment

    v2 v3  
    4343$$;
    4444
    45 DROP TRIGGER IF EXISTS trg_booking_validation ON bookings;
     45DROP TRIGGER IF EXISTS trg_booking_validation ON project.bookings;
    4646CREATE TRIGGER trg_booking_validation
    4747BEFORE INSERT OR UPDATE ON project.bookings
     
    8989$$;
    9090
    91 DROP TRIGGER IF EXISTS trg_review_integrity ON reviews;
     91DROP TRIGGER IF EXISTS trg_review_integrity ON project.reviews;
    9292CREATE TRIGGER trg_review_integrity
    9393BEFORE INSERT ON project.reviews
     
    105105$$;
    106106
    107 DROP TRIGGER IF EXISTS trg_reviews_no_update ON reviews;
     107DROP TRIGGER IF EXISTS trg_reviews_no_update ON project.reviews;
    108108CREATE TRIGGER trg_reviews_no_update
    109109BEFORE UPDATE ON project.reviews