-- Eski footer_menu_items tabloları için «footer’da göster» sütunu (yeni migration_footer_menu.sql zaten içerir).
USE faunamix;

SET @has := (
  SELECT COUNT(*) FROM information_schema.COLUMNS
  WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'footer_menu_items' AND COLUMN_NAME = 'show_in_footer'
);
SET @sql := IF(@has = 0,
  'ALTER TABLE footer_menu_items ADD COLUMN show_in_footer TINYINT(1) NOT NULL DEFAULT 1 AFTER is_active',
  'SELECT 1');
PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
