-- +migrate Up
CREATE TABLE `benefactors` (
    `id` INT NOT NULL PRIMARY KEY,
    `first_name` VARCHAR(100) NOT NULL,
    `last_name` VARCHAR(100) NOT NULL,
    `phone_number` VARCHAR(20) NOT NULL,
    `description` TEXT,
   `email` VARCHAR(255),
    `gender` ENUM('male', 'female') NOT NULL,
    `birth_date` DATE,
    `status` ENUM('active', 'inactive') NOT NULL DEFAULT `active`,
    
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

-- +migrate Down
DROP TABLE `benefactors`;