| Index: trunk/extensions/WikiAtHome/WikiAtHome.sql |
| — | — | @@ -0,0 +1,40 @@ |
| | 2 | + |
| | 3 | +SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; |
| | 4 | + |
| | 5 | +-- |
| | 6 | +-- Database: `mvWiki` |
| | 7 | +-- |
| | 8 | + |
| | 9 | +-- -------------------------------------------------------- |
| | 10 | + |
| | 11 | +-- |
| | 12 | +-- Table structure for table `wah_jobqueue` |
| | 13 | +-- |
| | 14 | + |
| | 15 | +CREATE TABLE IF NOT EXISTS `wah_jobqueue` ( |
| | 16 | + `job_id` int(12) unsigned NOT NULL auto_increment, |
| | 17 | + `job_set_id` int(12) unsigned NOT NULL, |
| | 18 | + `job_assigned_time` binary(14) default NULL, |
| | 19 | + `job_retry_count` int(3) unsigned NOT NULL, |
| | 20 | + `job_json` blob NOT NULL, |
| | 21 | + PRIMARY KEY (`job_id`), |
| | 22 | + KEY `job_set_id` (`job_set_id`) |
| | 23 | +) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; |
| | 24 | + |
| | 25 | +-- -------------------------------------------------------- |
| | 26 | + |
| | 27 | +-- |
| | 28 | +-- Table structure for table `wah_jobset` |
| | 29 | +-- |
| | 30 | + |
| | 31 | +CREATE TABLE IF NOT EXISTS `wah_jobset` ( |
| | 32 | + `set_id` int(10) unsigned NOT NULL auto_increment, |
| | 33 | + `set_namespace` int(11) default NULL, |
| | 34 | + `set_title` varchar(255) default NULL, |
| | 35 | + `set_jobs_count` int(11) unsigned NOT NULL, |
| | 36 | + `set_description` varchar(255) default NULL, |
| | 37 | + `set_priority` int(2) NOT NULL default '0', |
| | 38 | + `set_done_time` int(14) default NULL, |
| | 39 | + PRIMARY KEY (`set_id`), |
| | 40 | + KEY `set_namespace` (`set_namespace`,`set_title`) |
| | 41 | +) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; |