-- ============================================================
-- G011 Guest Book Engine — Database Migration
-- ============================================================
-- Adds `status`, `approved_at`, and `approved_by` columns to the `wishes` table.
-- @ref G011
-- ============================================================

ALTER TABLE `wishes` 
    ADD COLUMN IF NOT EXISTS `status` VARCHAR(20) NOT NULL DEFAULT 'approved' COMMENT 'pending | approved | rejected' AFTER `message`,
    ADD COLUMN IF NOT EXISTS `approved_at` DATETIME NULL DEFAULT NULL AFTER `hidden_at`,
    ADD COLUMN IF NOT EXISTS `approved_by` BIGINT UNSIGNED NULL DEFAULT NULL AFTER `approved_at`;