-- Add username column to settings table if it doesn't exist
ALTER TABLE `settings` ADD COLUMN IF NOT EXISTS `username` VARCHAR(55) DEFAULT NULL;
 
-- Update existing records to have the admin username
UPDATE `settings` SET `username` = 'admin' WHERE `username` IS NULL; 