MyVideos48 |
Trigger "delete_set" |
System: | |
Table: | sets |
Events: | DELETE |
Type: | After |
Enabled: | |
When expression: | (no value) |
Body: |
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;
Generated by ""SQLite Maestro Professional"" at 08.07.2021 23:49:20 |