1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

CREATE TABLE `longtasks` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(255) CHARACTER SET utf8 NOT NULL,
  `title` varchar(255) CHARACTER SET utf8 NOT NULL,
  `status` enum('not_started','cancel_pending','canceled','error','fatal_error','done','started') NOT NULL DEFAULT 'not_started',
  `progress_text` varchar(245) CHARACTER SET utf8 NOT NULL,
  `progress_max` int(10) unsigned NOT NULL DEFAULT '1',
  `progress_value` int(10) unsigned NOT NULL DEFAULT '0',
  `start_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `finish_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `owner_type` smallint(5) unsigned NOT NULL DEFAULT '0',
  `owner` int(10) unsigned NOT NULL DEFAULT '0',
  `can_cancel` enum('false','true') NOT NULL DEFAULT 'false',
  `pid` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1

CREATE TABLE `longtasks` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `type` varchar(255) CHARACTER SET utf8 NOT NULL, `title` varchar(255) CHARACTER SET utf8 NOT NULL, `status` enum('not_started','cancel_pending','canceled','error','fatal_error','done','started') NOT NULL DEFAULT 'not_started', `progress_text` varchar(245) CHARACTER SET utf8 NOT NULL, `progress_max` int(10) unsigned NOT NULL DEFAULT '1', `progress_value` int(10) unsigned NOT NULL DEFAULT '0', `start_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `finish_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `owner_type` smallint(5) unsigned NOT NULL DEFAULT '0', `owner` int(10) unsigned NOT NULL DEFAULT '0', `can_cancel` enum('false','true') NOT NULL DEFAULT 'false', `pid` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1