1_to_2.sql « gravity « database_migration « Scripts « advanced - github.com/pi-hole/pi-hole.git - Unnamed repository; edit this file 'description' to name the repository.

Welcome to mirror list, hosted at ThFree Co, Russian Federation.

1_to_2.sql « gravity « database_migration « Scripts « advanced - github.com/pi-hole/pi-hole.git - Unnamed repository; edit this file 'description' to name the repository.

index : github.com/pi-hole/pi-hole.git

Unnamed repository; edit this file 'description' to name the repository.

www-data

summary refs log tree commit diff

path: root/advanced/Scripts/database_migration/gravity/1_to_2.sql

blob: 6d57a6fe696a2a6aed92812837a1b449cb6ea37e (plain)

.timeout 30000

BEGIN TRANSACTION;

CREATE TABLE domain_audit
(
	id INTEGER PRIMARY KEY AUTOINCREMENT,
	domain TEXT UNIQUE NOT NULL,
	date_added INTEGER NOT NULL DEFAULT (cast(strftime('%s', 'now') as int))
);

UPDATE info SET value = 2 WHERE property = 'version';

COMMIT;