File indexing completed on 2024-04-21 06:00:36 

0001 CREATE TABLE `paypal_ipn`
0002 (
0003     `id`             INT(11)     NOT NULL AUTO_INCREMENT,
0004     `created_at`     TIMESTAMP   NOT NULL DEFAULT CURRENT_TIMESTAMP,
0005     `txn_type`       VARCHAR(50) NULL     DEFAULT NULL,
0006     `ipn_track_id`   VARCHAR(50) NULL     DEFAULT NULL,
0007     `txn_id`         VARCHAR(50) NULL     DEFAULT NULL,
0008     `payer_email`    VARCHAR(50) NULL     DEFAULT NULL,
0009     `payer_id`       VARCHAR(50) NULL     DEFAULT NULL,
0010     `auth_amount`    VARCHAR(50) NULL     DEFAULT NULL,
0011     `mc_currency`    VARCHAR(50) NULL     DEFAULT NULL,
0012     `mc_fee`         VARCHAR(50) NULL     DEFAULT NULL,
0013     `mc_gross`       VARCHAR(50) NULL     DEFAULT NULL,
0014     `memo`           VARCHAR(50) NULL     DEFAULT NULL,
0015     `payer_status`   VARCHAR(50) NULL     DEFAULT NULL,
0016     `payment_date`   VARCHAR(50) NULL     DEFAULT NULL,
0017     `payment_fee`    VARCHAR(50) NULL     DEFAULT NULL,
0018     `payment_status` VARCHAR(50) NULL     DEFAULT NULL,
0019     `payment_type`   VARCHAR(50) NULL     DEFAULT NULL,
0020     `pending_reason` VARCHAR(50) NULL     DEFAULT NULL,
0021     `reason_code`    VARCHAR(50) NULL     DEFAULT NULL,
0022     `custom`         VARCHAR(50) NULL     DEFAULT NULL,
0023     `raw`            TEXT        NULL,
0024     PRIMARY KEY (`id`)
0025 )
0026     COMMENT ='Save all PayPal IPNs here'
0027     ENGINE = InnoDB
0028 ;
0029