-- Add full_name column to users table
ALTER TABLE `users` ADD COLUMN `full_name` VARCHAR(100) NULL DEFAULT NULL AFTER `username`;

-- Populate existing full_name columns with the username as a default
UPDATE `users` SET `full_name` = `username` WHERE `full_name` IS NULL OR `full_name` = '';
