mirror of
https://github.com/mountain-loop/yaak.git
synced 2026-04-10 11:13:48 +02:00
11 lines
346 B
SQL
11 lines
346 B
SQL
ALTER TABLE settings
|
|
ADD COLUMN hide_license_badge BOOLEAN DEFAULT FALSE;
|
|
|
|
-- 2. Backfill based on old JSON
|
|
UPDATE settings
|
|
SET hide_license_badge = 1
|
|
WHERE EXISTS ( SELECT 1
|
|
FROM key_values kv
|
|
WHERE kv.key = 'license_confirmation'
|
|
AND JSON_EXTRACT(kv.value, '$.confirmedPersonalUse') = TRUE );
|