-- Kategori kısa açıklama alanı (anasayfa kart hover). idempotent

SET @c := (SELECT COUNT(*) FROM information_schema.COLUMNS
  WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'product_categories' AND COLUMN_NAME = 'kisa_aciklama');
SET @sql := IF(@c = 0,
  'ALTER TABLE product_categories ADD COLUMN kisa_aciklama TEXT NOT NULL AFTER meta_description',
  'SELECT 1');
PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
