advanced/Scripts/database_migration/gravity/11_to_12.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19

.timeout 30000

PRAGMA FOREIGN_KEYS=OFF;

BEGIN TRANSACTION;

UPDATE "group" SET name = 'Default' WHERE id = 0;
UPDATE "group" SET description = 'The default group' WHERE id = 0;

DROP TRIGGER IF EXISTS tr_group_zero;

CREATE TRIGGER tr_group_zero AFTER DELETE ON "group"
    BEGIN
      INSERT OR IGNORE INTO "group" (id,enabled,name,description) VALUES (0,1,'Default','The default group');
    END;

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

COMMIT;