DELIMITER $$

DROP PROCEDURE IF EXISTS add_wp_logo_column $$
CREATE PROCEDURE add_wp_logo_column()
BEGIN
    IF NOT EXISTS (
        SELECT 1
        FROM information_schema.COLUMNS
        WHERE TABLE_SCHEMA = DATABASE()
          AND TABLE_NAME = 'wp'
          AND COLUMN_NAME = 'wp_logo'
    ) THEN
        ALTER TABLE `wp` ADD COLUMN `wp_logo` varchar(255) NOT NULL DEFAULT '' AFTER `wp_in`;
    END IF;
END $$

CALL add_wp_logo_column() $$
DROP PROCEDURE IF EXISTS add_wp_logo_column $$

DELIMITER ;
