advanced/Scripts/database_migration/gravity/13_to_14.sql


1
2
3
4
5
6
7
8
9
10
11
12
13

.timeout 30000

PRAGMA FOREIGN_KEYS=OFF;

BEGIN TRANSACTION;

ALTER TABLE adlist ADD COLUMN number INTEGER NOT NULL DEFAULT 0;
ALTER TABLE adlist ADD COLUMN invalid_domains INTEGER NOT NULL DEFAULT 0;
ALTER TABLE adlist ADD COLUMN status INTEGER NOT NULL DEFAULT 0;

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

COMMIT;