13 lines
341 B
SQL
13 lines
341 B
SQL
ALTER TABLE users
|
|
ALTER COLUMN profile_visibility SET DEFAULT 'friends';
|
|
|
|
ALTER TABLE users
|
|
DROP CONSTRAINT IF EXISTS users_profile_visibility_check;
|
|
|
|
ALTER TABLE users
|
|
ADD CONSTRAINT users_profile_visibility_check
|
|
CHECK (profile_visibility IN ('public', 'friends', 'nobody'));
|
|
|
|
ALTER TABLE concerts
|
|
ADD COLUMN IF NOT EXISTS flyer_url TEXT;
|