MyVideos48
Trigger "delete_set"
Previous topic Chapter index Next topic

System:
Table: sets
Events: DELETE
Type: After
Enabled:
When expression: (no value)
Body:

Definition:
CREATE TRIGGER delete_set
  AFTER DELETE
  ON sets
BEGIN
        DELETE FROM art WHERE media_id=old.idSet AND media_type='set';
        DELETE FROM uniqueid WHERE media_id=old.idSet AND media_type='set';
        END;


Previous topic Chapter index Next topic
Generated by ""SQLite Maestro Professional"" at 08.07.2021 23:49:20