7 lines
242 B
SQL
7 lines
242 B
SQL
|
-- Add metadata field to otp_sessions table
|
||
|
|
ALTER TABLE otp_sessions
|
||
|
|
ADD COLUMN metadata JSONB DEFAULT '{}';
|
||
|
|
|
||
|
|
-- Add comment for the new column
|
||
|
|
COMMENT ON COLUMN otp_sessions.metadata IS 'Additional data stored as JSON for the OTP session';
|