/
githubmirror
/
pi-hole
Обзор
Документация
Войти
/
githubmirror
/
pi-hole
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
advanced/Scripts/database_migration/gravity/18_to_19.sql
27 строк
647 B
DL6ER
Modify DELETE triggers to delete BEFORE instead of AFTER to prevent possible foreign key constraint violations
28 дек 2023, 13:12
Не верифицирован
28 дек 2023, 13:12
d282831
Код
Авторство
О чём код?
.timeout 30000 PRAGMA FOREIGN_KEYS=OFF; BEGIN TRANSACTION; DROP TRIGGER tr_domainlist_delete; CREATE TRIGGER tr_domainlist_delete BEFORE DELETE ON domainlist BEGIN DELETE FROM domainlist_by_group WHERE domainlist_id = OLD.id; END; DROP TRIGGER tr_adlist_delete; CREATE TRIGGER tr_adlist_delete BEFORE DELETE ON adlist BEGIN DELETE FROM adlist_by_group WHERE adlist_id = OLD.id; END; DROP TRIGGER tr_client_delete; CREATE TRIGGER tr_client_delete BEFORE DELETE ON client BEGIN DELETE FROM client_by_group WHERE client_id = OLD.id; END; UPDATE info SET value = 19 WHERE property = 'version'; COMMIT;