-- Add role to users table
ALTER TABLE `users` ADD `role` VARCHAR(50) NOT NULL DEFAULT 'free';

-- Add is_premium to templates table
ALTER TABLE `templates` ADD `is_premium` BOOLEAN NOT NULL DEFAULT FALSE;

-- Set the "Professional" template as premium for demonstration
UPDATE `templates` SET `is_premium` = TRUE WHERE `name` = 'Professional';