You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
virt/web/sql/paytaro_payment.sql

43 lines
1.9 KiB
MySQL

-- Paytaro payment integration for the PHP panel.
-- Import this file once before enabling Paytaro in the admin panel.
CREATE TABLE `paytaro_orders` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`order_no` varchar(32) NOT NULL,
`gateway_trade_no` varchar(80) DEFAULT NULL,
`paylist_id` bigint(20) UNSIGNED NOT NULL,
`user_id` bigint(20) UNSIGNED NOT NULL,
`amount` decimal(12,2) NOT NULL,
`payment_kind` varchar(16) NOT NULL DEFAULT '',
`payment_value` text DEFAULT NULL,
`status` varchar(16) NOT NULL DEFAULT 'creating',
`error_message` varchar(500) NOT NULL DEFAULT '',
`paid_at` int(10) UNSIGNED NOT NULL DEFAULT 0,
`created_at` int(10) UNSIGNED NOT NULL DEFAULT 0,
`updated_at` int(10) UNSIGNED NOT NULL DEFAULT 0,
CONSTRAINT `chk_paytaro_order_status` CHECK (`status` IN (
'creating','pending','paid','not_created','creation_unknown'
)),
PRIMARY KEY (`id`),
UNIQUE KEY `uniq_paytaro_order_no` (`order_no`),
UNIQUE KEY `uniq_paytaro_gateway_trade_no` (`gateway_trade_no`),
UNIQUE KEY `uniq_paytaro_paylist_id` (`paylist_id`),
KEY `idx_paytaro_user_created` (`user_id`,`created_at`),
KEY `idx_paytaro_status_created` (`status`,`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
CREATE TABLE `paytaro_callback_events` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`event_key` char(64) NOT NULL,
`order_no` varchar(32) NOT NULL,
`gateway_trade_no` varchar(80) NOT NULL,
`trade_status` varchar(32) NOT NULL,
`payload` mediumtext NOT NULL,
`received_at` int(10) UNSIGNED NOT NULL DEFAULT 0,
`processed_at` int(10) UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY (`id`),
UNIQUE KEY `uniq_paytaro_event_key` (`event_key`),
KEY `idx_paytaro_event_order` (`order_no`,`received_at`),
KEY `idx_paytaro_event_trade` (`gateway_trade_no`,`received_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;