CREATE TABLE `ipbnexus_purchases` (
    `ps_id` INT(10) NOT NULL AUTO_INCREMENT,
    `ps_member` MEDIUMINT(8) NOT NULL DEFAULT '0',
    `ps_name` VARCHAR(128) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
    `ps_active` TINYINT(1) NOT NULL DEFAULT '0',
    `ps_cancelled` TINYINT(1) NOT NULL DEFAULT '0',
    `ps_start` INT(10) NOT NULL DEFAULT '0',
    `ps_expire` INT(10) NOT NULL DEFAULT '0',
    `ps_renewals` INT(5) NOT NULL DEFAULT '0',
    `ps_renewal_price` DECIMAL(20,2) NOT NULL DEFAULT '0.00',
    `ps_renewal_unit` CHAR(1) NOT NULL DEFAULT '' COLLATE 'utf8mb4_unicode_ci',
    `ps_app` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
    `ps_type` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
    `ps_item_id` INT(10) NOT NULL DEFAULT '0',
    `ps_item_uri` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
    `ps_admin_uri` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
    `ps_custom_fields` TEXT NULL COLLATE 'utf8mb4_unicode_ci',
    `ps_extra` TEXT NULL COLLATE 'utf8mb4_unicode_ci',
    `ps_parent` INT(10) NOT NULL DEFAULT '0',
    `ps_invoice_pending` INT(10) NOT NULL DEFAULT '0',
    `ps_invoice_warning_sent` TINYINT(1) NOT NULL DEFAULT '0',
    `ps_pay_to` MEDIUMINT(8) NULL DEFAULT NULL,
    `ps_commission` INT(2) NULL DEFAULT NULL,
    `ps_original_invoice` INT(10) NOT NULL DEFAULT '0',
    `ps_tax` INT(5) NOT NULL DEFAULT '0',
    `ps_can_reactivate` TINYINT(1) NOT NULL DEFAULT '0',
    `ps_grouped_renewals` TEXT NULL COLLATE 'utf8mb4_unicode_ci',
    `ps_renewal_currency` CHAR(3) NOT NULL DEFAULT '' COLLATE 'utf8mb4_unicode_ci',
    `ps_show` TINYINT(1) UNSIGNED NOT NULL DEFAULT '1',
    `ps_grace_period` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Grace period in seconds',
    `ps_billing_agreement` BIGINT(20) UNSIGNED NULL DEFAULT NULL COMMENT 'If paid by a billing agreement, its ID',
    PRIMARY KEY (`ps_id`),
    INDEX `ps_member` (`ps_member`),
    INDEX `sort` (`ps_cancelled`, `ps_active`, `ps_start`),
    INDEX `ps_purchases` (`ps_app`(90), `ps_type`(90), `ps_item_id`)
)
COLLATE='utf8mb4_unicode_ci'
ENGINE=InnoDB
AUTO_INCREMENT=4
;