DROP TABLE IF EXISTS `%table_prefix%imports`;
CREATE TABLE `%table_prefix%imports` (
  `import_id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `import_path` VARCHAR(4096) NOT NULL,
  `import_options` VARCHAR(255) DEFAULT NULL,
  `import_status` ENUM('queued','working','paused','canceled','completed') NOT NULL,
  `import_users` INT UNSIGNED NOT NULL DEFAULT '0',
  `import_images` INT UNSIGNED NOT NULL DEFAULT '0',
  `import_albums` INT UNSIGNED NOT NULL DEFAULT '0',
  `import_time_created` DATETIME DEFAULT NULL,
  `import_time_updated` DATETIME DEFAULT NULL,
  `import_errors` TINYINT UNSIGNED NOT NULL DEFAULT '0',
  `import_started` TINYINT UNSIGNED NOT NULL DEFAULT '0',
  `import_continuous` TINYINT UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`import_id`),
  KEY `import_path` (`import_path`(191)) USING BTREE
) ENGINE=%table_engine% DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

INSERT INTO `%table_prefix%imports` VALUES ('1', '%rootPath%importing/no-parse', 'a:1:{s:4:"root";s:5:"plain";}', 'working', '0', '0', '0', NOW(), NOW(), '0', '1', '1');
INSERT INTO `%table_prefix%imports` VALUES ('2', '%rootPath%importing/parse-users', 'a:1:{s:4:"root";s:5:"users";}', 'working', '0', '0', '0', NOW(), NOW(), '0', '1', '1');
INSERT INTO `%table_prefix%imports` VALUES ('3', '%rootPath%importing/parse-albums', 'a:1:{s:4:"root";s:6:"albums";}', 'working', '0', '0', '0', NOW(), NOW(), '0', '1', '1');
