CREATE TABLE IF NOT EXISTS `payments` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`package_id` int(11) DEFAULT NULL,
`processor` enum('PAYPAL','STRIPE') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`type` enum('ONE-TIME','RECURRING') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`plan` varchar(16) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`code` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`payment_id` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`subscription_id` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`payer_id` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`email` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`name` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`amount` float DEFAULT NULL,
`currency` varchar(4) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `payments_user_id` (`user_id`),
KEY `package_id` (`package_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;