mirror of
https://github.com/pi-hole/pi-hole.git
synced 2024-11-22 06:03:43 +00:00
16 lines
256 B
MySQL
16 lines
256 B
MySQL
|
.timeout 30000
|
||
|
|
|
||
|
|
PRAGMA FOREIGN_KEYS=OFF;
|
||
|
|
|
||
|
|
BEGIN TRANSACTION;
|
||
|
|
DROP VIEW vw_adlist;
|
||
|
|
|
||
|
|
CREATE VIEW vw_adlist AS SELECT DISTINCT address, id
|
||
|
|
FROM adlist
|
||
|
|
WHERE enabled = 1
|
||
|
|
ORDER BY id;
|
||
|
|
|
||
|
|
UPDATE info SET value = 15 WHERE property = 'version';
|
||
|
|
|
||
|
|
COMMIT;
|