Difference between revisions of "Database Table: jobstatus"
From Dreamwidth Notes
(Created page with 'jobstatus =Definition= <source lang="sql"> CREATE TABLE jobstatus ( handle VARCHAR(100) PRIMARY KEY, result BLOB, start_time INT(10) UNSIGNED N...') |
(No difference)
|
Revision as of 17:14, 22 March 2009
Definition
CREATE TABLE jobstatus ( handle VARCHAR(100) PRIMARY KEY, RESULT BLOB, start_time INT(10) UNSIGNED NOT NULL, end_time INT(10) UNSIGNED NOT NULL, STATUS ENUM('running', 'success', 'error'), KEY (end_time) )