ALTER TABLE products ADD COLUMN is_online INT(11) NOT NULL DEFAULT 0 AFTER featured; ALTER TABLE products ADD COLUMN gender ENUM('male', 'female', 'both') DEFAULT 'both' AFTER is_online;