| 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 |