DROP TABLE IF EXISTS `gift_purchase_transactions`;

CREATE TABLE `gift_purchase_transactions`(
    `id` INT NOT NULL AUTO_INCREMENT COMMENT 'id',
    `sender_id` INT NOT NULL COMMENT 'id ',
    `sender_email` VARCHAR(255) NULL DEFAULT NULL COMMENT 'email ',
    `sender_ip` VARCHAR(255) NULL DEFAULT NULL COMMENT 'ip ',
    `recipient_id` INT NOT NULL COMMENT 'id ',
    `recipient_email` VARCHAR(255) NULL DEFAULT NULL COMMENT 'email ',
    `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'created_at',
    `payment_date` DATETIME NULL COMMENT 'payment_date',

    PRIMARY KEY(`id`)
);