CREATE TABLE `xf_dbtech_credits_transaction` (
`transaction_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`event_id` int(10) unsigned NOT NULL DEFAULT 0,
`event_trigger_id` varchar(255) NOT NULL DEFAULT '',
`user_id` int(10) unsigned NOT NULL DEFAULT 0,
`dateline` int(10) unsigned NOT NULL DEFAULT 0,
`source_user_id` int(10) unsigned NOT NULL DEFAULT 0,
`amount` double NOT NULL DEFAULT 0,
`status` tinyint(3) unsigned NOT NULL DEFAULT 0,
`reference_id` varchar(255) DEFAULT NULL,
`content_type` varbinary(25) NOT NULL,
`content_id` int(10) unsigned NOT NULL,
`node_id` int(10) unsigned NOT NULL DEFAULT 0,
`owner_id` int(10) unsigned NOT NULL DEFAULT 0,
`multiplier` double NOT NULL DEFAULT 0,
`currency_id` int(10) unsigned NOT NULL DEFAULT 0,
`negate` tinyint(3) unsigned NOT NULL DEFAULT 0,
`message` blob DEFAULT NULL,
`is_disputed` tinyint(3) unsigned NOT NULL DEFAULT 0,
`balance` double NOT NULL DEFAULT 0,
PRIMARY KEY (`transaction_id`),
KEY `dateline` (`dateline`,`user_id`,`status`),
KEY `user_id` (`user_id`),
KEY `user_id_stats` (`user_id`,`event_id`,`status`,`negate`,`dateline`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;