/
githubmirror
/
pi-hole
Обзор
Документация
Войти
/
githubmirror
/
pi-hole
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
advanced/Scripts/database_migration/gravity/17_to_18.sql
25 строк
1 KB
DL6ER
Make IDs of anti-/gravity lists available in vw_(anti)gravity
25 дек 2023, 07:29
Не верифицирован
25 дек 2023, 07:29
0066c6f
Код
Авторство
О чём код?
.timeout 30000 PRAGMA FOREIGN_KEYS=OFF; BEGIN TRANSACTION; DROP VIEW vw_gravity; CREATE VIEW vw_gravity AS SELECT domain, adlist.id AS adlist_id, adlist_by_group.group_id AS group_id FROM gravity LEFT JOIN adlist_by_group ON adlist_by_group.adlist_id = gravity.adlist_id LEFT JOIN adlist ON adlist.id = gravity.adlist_id LEFT JOIN "group" ON "group".id = adlist_by_group.group_id WHERE adlist.enabled = 1 AND (adlist_by_group.group_id IS NULL OR "group".enabled = 1); DROP VIEW vw_antigravity; CREATE VIEW vw_antigravity AS SELECT domain, adlist.id AS adlist_id, adlist_by_group.group_id AS group_id FROM antigravity LEFT JOIN adlist_by_group ON adlist_by_group.adlist_id = antigravity.adlist_id LEFT JOIN adlist ON adlist.id = antigravity.adlist_id LEFT JOIN "group" ON "group".id = adlist_by_group.group_id WHERE adlist.enabled = 1 AND (adlist_by_group.group_id IS NULL OR "group".enabled = 1) AND adlist.type = 1; UPDATE info SET value = 18 WHERE property = 'version'; COMMIT;