-- Add Slogan and SEO fields to institutes table
ALTER TABLE institutes
ADD COLUMN slogan VARCHAR(255) COMMENT 'Institute slogan or tagline' AFTER name,
ADD COLUMN meta_title VARCHAR(255) COMMENT 'SEO Meta Title' AFTER website,
ADD COLUMN meta_description TEXT COMMENT 'SEO Meta Description' AFTER meta_title,
ADD COLUMN keywords TEXT COMMENT 'SEO Keywords' AFTER meta_description,
ADD COLUMN author VARCHAR(255) COMMENT 'SEO Author' AFTER keywords;
