9 lines
321 B
MySQL
9 lines
321 B
MySQL
|
-- Replace intro_email column with config JSONB column
|
||
|
|
ALTER TABLE user_introductions DROP COLUMN intro_email;
|
||
|
|
|
||
|
|
ALTER TABLE user_introductions ADD COLUMN config JSONB NOT NULL DEFAULT '{}'::jsonb;
|
||
|
|
|
||
|
|
-- Update column comment
|
||
|
|
COMMENT ON COLUMN user_introductions.config IS 'User introduction configuration stored as JSON';
|
||
|
|
|