/
githubmirror
/
pi-hole
Обзор
Документация
Войти
/
githubmirror
/
pi-hole
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
advanced/Scripts/database_migration/gravity/8_to_9.sql
27 строк
676 B
DL6ER
Update database version during migration.
30 дек 2019, 12:21
Не верифицирован
30 дек 2019, 12:21
bb30c81
Код
Авторство
О чём код?
.timeout 30000 PRAGMA FOREIGN_KEYS=OFF; BEGIN TRANSACTION; DROP TRIGGER IF EXISTS tr_group_update; DROP TRIGGER IF EXISTS tr_group_zero; PRAGMA legacy_alter_table=ON; ALTER TABLE "group" RENAME TO "group__"; PRAGMA legacy_alter_table=OFF; ALTER TABLE "group__" RENAME TO "group"; 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; 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 = 9 WHERE property = 'version'; COMMIT;