/
githubmirror
/
pi-hole
Обзор
Документация
Войти
/
githubmirror
/
pi-hole
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
advanced/Scripts/database_migration/gravity/7_to_8.sql
35 строк
950 B
Adam Warner
tabs->spaces for editorconfig (Not sure how this has nto been caught before...)
05 июл 2024, 21:03
05 июл 2024, 21:03
4148f2c
Код
Авторство
О чём код?
.timeout 30000 PRAGMA FOREIGN_KEYS=OFF; BEGIN TRANSACTION; ALTER TABLE "group" RENAME TO "group__"; CREATE TABLE "group" ( id INTEGER PRIMARY KEY AUTOINCREMENT, enabled BOOLEAN NOT NULL DEFAULT 1, name TEXT UNIQUE NOT NULL, date_added INTEGER NOT NULL DEFAULT (cast(strftime('%s', 'now') as int)), date_modified INTEGER NOT NULL DEFAULT (cast(strftime('%s', 'now') as int)), description TEXT ); CREATE TRIGGER tr_group_update AFTER UPDATE ON "group" BEGIN UPDATE "group" SET date_modified = (cast(strftime('%s', 'now') as int)) WHERE id = NEW.id; END; INSERT OR IGNORE INTO "group" (id,enabled,name,description) SELECT id,enabled,name,description FROM "group__"; DROP TABLE "group__"; CREATE TRIGGER tr_group_zero AFTER DELETE ON "group" BEGIN INSERT OR IGNORE INTO "group" (id,enabled,name) VALUES (0,1,'Unassociated'); END; UPDATE info SET value = 8 WHERE property = 'version'; COMMIT;