14 lines
507 B
SQL
14 lines
507 B
SQL
-- 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;
|