006_media_and_registration.sql · rin/polar

006_media_and_registration.sql · 9 lines · 409 B

1	ALTER TABLE users ADD COLUMN background_url TEXT NOT NULL DEFAULT '';
2	ALTER TABLE users ADD COLUMN is_approved INTEGER NOT NULL DEFAULT 1;
3	ALTER TABLE repositories ADD COLUMN avatar_url TEXT NOT NULL DEFAULT '';
4
5	INSERT INTO settings (key, value)
6	SELECT 'registration_mode',
7	CASE WHEN LOWER(value) IN ('1', 'true', 'on') THEN 'public' ELSE 'closed' END
8	FROM settings
9	WHERE key = 'registration_enabled';