-- Migration: Add team_size, position, industry, trial columns to organizations table
-- For Business Registration flow and 7-day trial system

ALTER TABLE organizations 
ADD COLUMN team_size VARCHAR(20) DEFAULT '5-10';

ALTER TABLE organizations 
ADD COLUMN admin_position VARCHAR(100) DEFAULT NULL;

ALTER TABLE organizations 
ADD COLUMN industry VARCHAR(100) DEFAULT NULL;

-- Trial system columns
ALTER TABLE organizations 
ADD COLUMN trial_start_date DATETIME DEFAULT NULL;

ALTER TABLE organizations 
ADD COLUMN trial_end_date DATETIME DEFAULT NULL;

ALTER TABLE organizations 
ADD COLUMN trial_status ENUM('active', 'expired', 'converted') DEFAULT 'active';

-- Optional: Add admin_position to organization_members as well for tracking
-- ALTER TABLE organization_members 
-- ADD COLUMN position VARCHAR(100) DEFAULT NULL;
