learn-request-queue/db/upgrade/v0.3-0.4.sql

10 lines
440 B
MySQL
Raw Permalink Normal View History

2021-02-22 06:33:02 +00:00
BEGIN;
UPDATE version SET minor = 4;
ALTER TABLE config ADD COLUMN title varchar, ADD COLUMN colors jsonb;
UPDATE config SET title = '{username}''s Learn Request Queue', colors = '{"bg": {"primary": "#444444","table": "#282828","navbar" : "#666666","error": "#ff0000"},"fg": {"primary": "#dddddd","ahover": "#ffffff","title": "#eeeeee"}}';
ALTER TABLE config ALTER COLUMN title SET NOT NULL, ALTER COLUMN colors SET NOT NULL;
COMMIT;