13 lines
557 B
SQL
13 lines
557 B
SQL
ALTER TABLE users ADD COLUMN IF NOT EXISTS profile_username TEXT;
|
|
ALTER TABLE users ADD COLUMN IF NOT EXISTS is_future_races_public BOOLEAN NOT NULL DEFAULT FALSE;
|
|
ALTER TABLE users ADD COLUMN IF NOT EXISTS is_completed_races_public BOOLEAN NOT NULL DEFAULT FALSE;
|
|
|
|
UPDATE users
|
|
SET is_future_races_public = is_profile_public,
|
|
is_completed_races_public = is_profile_public
|
|
WHERE is_profile_public = TRUE;
|
|
|
|
CREATE UNIQUE INDEX IF NOT EXISTS users_profile_username_normalized_key
|
|
ON users (LOWER(profile_username))
|
|
WHERE profile_username IS NOT NULL;
|