ALTER TABLE users ADD COLUMN background_url TEXT NOT NULL DEFAULT '';
ALTER TABLE users ADD COLUMN is_approved INTEGER NOT NULL DEFAULT 1;
ALTER TABLE repositories ADD COLUMN avatar_url TEXT NOT NULL DEFAULT '';

INSERT INTO settings (key, value)
SELECT 'registration_mode',
       CASE WHEN LOWER(value) IN ('1', 'true', 'on') THEN 'public' ELSE 'closed' END
FROM settings
WHERE key = 'registration_enabled';