create table sql

 CREATE TABLE `payments_credit_card` (
                        `id` int(20) unsigned NOT NULL AUTO_INCREMENT,
                        `payment_id` int(20) unsigned DEFAULT NULL,
                        `transaction_id` varchar(128) DEFAULT NULL,
                        `ref_transaction_id` varchar(128) DEFAULT NULL,
                        `auth_code` varchar(16) DEFAULT NULL,
                        `response_message` varchar(128) DEFAULT NULL,
                        `gateway_extra_id` varchar(128) DEFAULT NULL,
                        `first` varchar(128) DEFAULT NULL,
                        `last` varchar(128) DEFAULT NULL,
                        `address` varchar(128) DEFAULT NULL,
                        `address2` varchar(128) DEFAULT NULL,
                        `city` varchar(128) DEFAULT NULL,
                        `state_province` char(64) DEFAULT NULL,
                        `postal_code` varchar(18) DEFAULT NULL,
                        `country_code` char(2) DEFAULT NULL,
                        `card_number` varchar(20) DEFAULT NULL,
                        `card_type` varchar(10) DEFAULT NULL,
                        `card_exp_date` char(4) DEFAULT NULL,
                        `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
                        `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
                        `response_code` int(11) DEFAULT NULL,
                        PRIMARY KEY (`id`),
                        KEY `auth_code` (`auth_code`),
                        KEY `card_number` (`card_number`),
                        KEY `ref_transaction_id` (`ref_transaction_id`),
                        KEY `first` (`first`),
                        KEY `last` (`last`),
                        KEY `payment_id` (`payment_id`),
                        KEY `transaction_id` (`transaction_id`)
                      ) ENGINE=InnoDB AUTO_INCREMENT=477148 DEFAULT CHARSET=latin1

CREATE TABLE `gateway_fees_stripe` (
                       `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
                       `fee_id` varchar(48) COLLATE utf8_unicode_ci NOT NULL,
                       `organization_id` int(11) NOT NULL,
                       `transaction_id` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
                       `amount` decimal(8,2) NOT NULL,
                       `fee_type` enum('fee','refund') COLLATE utf8_unicode_ci NOT NULL,
                       `amount_refunded` decimal(8,2) NOT NULL,
                       `currency` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
                       `deleted_at` timestamp NULL DEFAULT NULL,
                       `date_charged` datetime NOT NULL,
                       `created_at` timestamp NULL DEFAULT NULL,
                       `updated_at` timestamp NULL DEFAULT NULL,
                       `ref_transaction_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
                       `processing_fee_bp` int(11) DEFAULT NULL,
                       `surcharge_fee` decimal(5,2) DEFAULT '0.00',
                       `gateway_stripe_id` int(11) NOT NULL,
                       PRIMARY KEY (`id`),
                       KEY `fee_id` (`fee_id`),
                       KEY `organization_id` (`organization_id`),
                       KEY `transaction_id` (`transaction_id`),
                       KEY `date_charged` (`date_charged`),
                       KEY `ref_tx_id` (`ref_transaction_id`),
                       KEY `fee_type` (`fee_type`),
                       KEY `gateway_stripe_id` (`gateway_stripe_id`),
                       KEY `organization_id_2` (`organization_id`,`transaction_id`)
                     ) ENGINE=InnoDB AUTO_INCREMENT=21799 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci