| Index: trunk/extensions/WikiAtHome/WikiAtHome.sql |
| — | — | @@ -2,9 +2,11 @@ |
| 3 | 3 | -- Table structure for table `wah_jobqueue` |
| 4 | 4 | -- |
| 5 | 5 | |
| | 6 | +DROP TABLE IF EXISTS `wah_jobqueue`; |
| 6 | 7 | CREATE TABLE IF NOT EXISTS `wah_jobqueue` ( |
| 7 | 8 | `job_id` int(12) unsigned NOT NULL auto_increment, |
| 8 | 9 | `job_set_id` int(12) unsigned NOT NULL, |
| | 10 | + `job_order_id` int(5) NOT NULL, |
| 9 | 11 | `job_last_assigned_time` int(14) default NULL, |
| 10 | 12 | `job_last_assigned_user_id` int(11) unsigned default NULL, |
| 11 | 13 | `job_done_time` int(14) default NULL, |
| — | — | @@ -12,9 +14,9 @@ |
| 13 | 15 | `job_assign_count` int(4) unsigned NOT NULL default '0', |
| 14 | 16 | `job_json` blob NOT NULL, |
| 15 | 17 | PRIMARY KEY (`job_id`), |
| 16 | | - KEY `job_set_id` (`job_set_id`), |
| 17 | | - KEY `job_last_assigned_user_id` (`job_last_assigned_user_id`) |
| 18 | | -) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; |
| | 18 | + KEY `job_last_assigned_user_id` (`job_last_assigned_user_id`), |
| | 19 | + KEY `job_set_id` (`job_set_id`,`job_order_id`) |
| | 20 | +) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; |
| 19 | 21 | |
| 20 | 22 | -- -------------------------------------------------------- |
| 21 | 23 | |
| — | — | @@ -22,6 +24,7 @@ |
| 23 | 25 | -- Table structure for table `wah_jobset` |
| 24 | 26 | -- |
| 25 | 27 | |
| | 28 | +DROP TABLE IF EXISTS `wah_jobset`; |
| 26 | 29 | CREATE TABLE IF NOT EXISTS `wah_jobset` ( |
| 27 | 30 | `set_id` int(10) unsigned NOT NULL auto_increment, |
| 28 | 31 | `set_namespace` int(11) default NULL, |
| — | — | @@ -35,4 +38,4 @@ |
| 36 | 39 | KEY `set_namespace` (`set_namespace`,`set_title`), |
| 37 | 40 | KEY `set_done_time` (`set_done_time`), |
| 38 | 41 | KEY `set_client_count` (`set_client_count`) |
| 39 | | -) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; |
| | 42 | +) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; |
| \ No newline at end of file |