Skip to content

Instantly share code, notes, and snippets.

@gustavonecore

gustavonecore/job_scheme.sql

Last active October 25, 2017 15:56
Show Gist options
  • Save gustavonecore/a19f047fc25afa8c9d6c05a937c88ed4 to your computer and use it in GitHub Desktop.
Save gustavonecore/a19f047fc25afa8c9d6c05a937c88ed4 to your computer and use it in GitHub Desktop.
Download ZIP
Codeigniter job table
Raw
job_scheme.sql
CREATE TABLE `jobs` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`name` VARCHAR(45) NOT NULL,
`payload` TEXT NULL COMMENT 'JSON payload',
`response` TEXT NULL,
`status` ENUM('running', 'queued', 'done') NOT NULL DEFAULT 'queued',
`run_time` DOUBLE NULL,
`created_dt` DATETIME NOT NULL,
PRIMARY KEY (`id`));
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment