-- Add study_type column to distinguish between card sort and prototype testing
-- Run this SQL in phpMyAdmin or your MySQL client

ALTER TABLE `studies` 
ADD COLUMN `study_type` VARCHAR(20) NOT NULL DEFAULT 'card_sort' AFTER `sort_type`;

-- Update existing studies to be card_sort type
UPDATE `studies` SET `study_type` = 'card_sort' WHERE `study_type` = 'card_sort';

-- Verify the changes
DESCRIBE `studies`;