| Index: trunk/extensions/WikiAtHome/WikiAtHome.sql |
| — | — | @@ -16,7 +16,7 @@ |
| 17 | 17 | PRIMARY KEY (`job_id`), |
| 18 | 18 | KEY `job_last_assigned_user_id` (`job_last_assigned_user_id`), |
| 19 | 19 | KEY `job_set_id` (`job_set_id`,`job_order_id`) |
| 20 | | -) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; |
| | 20 | +) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1; |
| 21 | 21 | |
| 22 | 22 | -- -------------------------------------------------------- |
| 23 | 23 | |
| — | — | @@ -31,6 +31,7 @@ |
| 32 | 32 | `set_title` varchar(255) default NULL, |
| 33 | 33 | `set_jobs_count` int(11) unsigned NOT NULL, |
| 34 | 34 | `set_encodekey` varchar(40) default NULL, |
| | 35 | + `set_job_type` enum('transcode','flatten') NOT NULL, |
| 35 | 36 | `set_creation_time` int(14) NOT NULL, |
| 36 | 37 | `set_done_time` int(14) default NULL, |
| 37 | 38 | `set_failed` tinyint(1) default NULL, |
| — | — | @@ -38,5 +39,6 @@ |
| 39 | 40 | PRIMARY KEY (`set_id`), |
| 40 | 41 | KEY `set_namespace` (`set_namespace`,`set_title`), |
| 41 | 42 | KEY `set_done_time` (`set_done_time`), |
| 42 | | - KEY `set_client_count` (`set_client_count`) |
| | 43 | + KEY `set_client_count` (`set_client_count`), |
| | 44 | + KEY `set_job_type` (`set_job_type`) |
| 43 | 45 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; |
| \ No newline at end of file |