CREATE TABLE IF NOT EXISTS `#__mokosuitebackup_snapshots` (
	`id`               INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
	`description`      VARCHAR(255) NOT NULL DEFAULT '',
	`content_types`    VARCHAR(255) NOT NULL DEFAULT '[]' COMMENT 'JSON array: ["articles","categories","modules"]',
	`status`           VARCHAR(20) NOT NULL DEFAULT 'complete' COMMENT 'complete, fail',
	`articles_count`   INT(11) UNSIGNED NOT NULL DEFAULT 0,
	`categories_count` INT(11) UNSIGNED NOT NULL DEFAULT 0,
	`modules_count`    INT(11) UNSIGNED NOT NULL DEFAULT 0,
	`data_file`        VARCHAR(512) NOT NULL DEFAULT '' COMMENT 'Absolute path to JSON snapshot file',
	`data_size`        BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Size of JSON file in bytes',
	`log`              MEDIUMTEXT DEFAULT NULL COMMENT 'Snapshot operation log',
	`created`          DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
	`created_by`       INT(11) UNSIGNED NOT NULL DEFAULT 0,
	PRIMARY KEY (`id`),
	KEY `idx_created` (`created`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
