14 lines
507 B
MySQL
14 lines
507 B
MySQL
|
-- Migration 004: Add missing auth columns to profiles table
|
||
|
|
-- Adds columns needed for email verification and trial system
|
||
|
|
|
||
|
|
ALTER TABLE profiles
|
||
|
|
ADD COLUMN IF NOT EXISTS auth_type VARCHAR(50) DEFAULT 'email',
|
||
|
|
ADD COLUMN IF NOT EXISTS verification_expires TIMESTAMP,
|
||
|
|
ADD COLUMN IF NOT EXISTS trial_ends_at TIMESTAMP;
|
||
|
|
|
||
|
|
-- Update existing profiles to have default values
|
||
|
|
UPDATE profiles
|
||
|
|
SET auth_type = 'email',
|
||
|
|
email_verified = true -- existing profiles are considered verified
|
||
|
|
WHERE auth_type IS NULL;
|