/
githubmirror
/
pi-hole
Обзор
Документация
Войти
/
githubmirror
/
pi-hole
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
advanced/Scripts/database_migration/gravity/9_to_10.sql
29 строк
688 B
DL6ER
Add gravity database 9->10 update script.
20 янв 2020, 19:59
Не верифицирован
20 янв 2020, 19:59
633e56e
Код
Авторство
О чём код?
.timeout 30000 PRAGMA FOREIGN_KEYS=OFF; BEGIN TRANSACTION; DROP TABLE IF EXISTS whitelist; DROP TABLE IF EXISTS blacklist; DROP TABLE IF EXISTS regex_whitelist; DROP TABLE IF EXISTS regex_blacklist; CREATE TRIGGER tr_domainlist_delete AFTER DELETE ON domainlist BEGIN DELETE FROM domainlist_by_group WHERE domainlist_id = OLD.id; END; CREATE TRIGGER tr_adlist_delete AFTER DELETE ON adlist BEGIN DELETE FROM adlist_by_group WHERE adlist_id = OLD.id; END; CREATE TRIGGER tr_client_delete AFTER DELETE ON client BEGIN DELETE FROM client_by_group WHERE client_id = OLD.id; END; UPDATE info SET value = 10 WHERE property = 'version'; COMMIT;