Compalex

Database schema compare tool

tables views procedures functions indexes triggers  all changed

compalex_dev

localhost/compalex_dev

compalex_prod

localhost/compalex_prod

customer::customer_create_date [INSERT/ROW/BEFORE] - 0 1

  • SET NEW.create_date = NOW()

customer::customer_create_date [INSERT/ROW/BEFORE] - 0 1

  • SET NEW.create_date = NOW()

film::del_film [DELETE/ROW/AFTER] - 0 1

  • BEGIN DELETE FROM film_text WHERE film_id = old.film_id; END

film::del_film [DELETE/ROW/AFTER] - 0 1

  • BEGIN DELETE FROM film_text WHERE film_id = old.film_id; END

film::ins_film [INSERT/ROW/AFTER] - 0 1

  • BEGIN INSERT INTO film_text (film_id, title, description) VALUES (new.film_id, new.title, new.description); END

film::ins_film [INSERT/ROW/AFTER] - 0 1

  • BEGIN INSERT INTO film_text (film_id, title, description) VALUES (new.film_id, new.title, new.description); END

film::upd_film [UPDATE/ROW/AFTER] - 0 1

  • BEGIN IF (old.title != new.title) OR (old.description != new.description) OR (old.film_id != new.film_id) THEN UPDATE film_text SET title=new.title, description=new.description, film_id=new.film_id WHERE film_id=old.film_id; END IF; END

film::upd_film [UPDATE/ROW/AFTER] - 0 1

  • BEGIN IF (old.title != new.title) OR (old.description != new.description) OR (old.film_id != new.film_id) THEN UPDATE film_text SET title=new.title, description=new.description, film_id=new.film_id WHERE film_id=old.film_id; END IF; END

payment::payment_date [INSERT/ROW/BEFORE] - 0 1

  • SET NEW.payment_date = NOW()

payment::payment_date [INSERT/ROW/BEFORE] - 0 1

  • SET NEW.payment_date = NOW()

rental::rental_date [INSERT/ROW/BEFORE] - 0 1

  • SET NEW.rental_date = NOW()

rental::rental_date [INSERT/ROW/BEFORE] - 0 1

  • SET NEW.rental_date = NOW()