2016-12-26 18:42:48 +00:00
|
|
|
|
CREATE TABLE IF NOT EXISTS `fso_tasks` (
|
|
|
|
|
|
`task_id` int(11) NOT NULL AUTO_INCREMENT,
|
2016-12-29 16:36:54 +00:00
|
|
|
|
`task_type` enum('prune_database','bonus') NOT NULL,
|
2016-12-26 18:42:48 +00:00
|
|
|
|
`task_status` enum('in_progress','completed','failed') NOT NULL,
|
|
|
|
|
|
`time_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
|
|
|
|
`time_completed` datetime DEFAULT NULL,
|
|
|
|
|
|
`shard_id` int(11) DEFAULT NULL,
|
|
|
|
|
|
PRIMARY KEY (`task_id`),
|
|
|
|
|
|
KEY `FK_fso_tasks_fso_shards` (`shard_id`),
|
|
|
|
|
|
CONSTRAINT `FK_fso_tasks_fso_shards` FOREIGN KEY (`shard_id`) REFERENCES `fso_shards` (`shard_id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
|
|
|
|
) COLLATE='utf8_general_ci'
|
|
|
|
|
|
ENGINE=InnoDB;
|
