DPB8LxKr

1        CREATE TABLE IF NOT EXISTS `ps_ps24_recuring` (
2            `id` INT NOT NULL AUTO_INCREMENT,
3            `website_id` INT NOT NULL,
4            `customer_id` INT NOT NULL,
5            `reference_id` VARCHAR(35) NOT NULL,
6            `expires` VARCHAR(4) NOT NULL,
7            `mask` VARCHAR (32) NOT NULL,
8            `card_type` VARCHAR (20) NOT NULL,
9            `timestamp` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
10          PRIMARY KEY (`id`),
11          UNIQUE KEY `UNIQUE_FIELDS` (`mask`,`card_type`,`expires`,`customer_id`,`website_id`));