| Index: trunk/extensions/CentralNotice/CentralNotice.sql |
| — | — | @@ -30,3 +30,9 @@ |
| 31 | 31 | `nl_language` varchar(32) NOT NULL |
| 32 | 32 | ) /*$wgDBTableOptions*/; |
| 33 | 33 | CREATE UNIQUE INDEX /*i*/nl_notice_id_language ON /*$wgDBprefix*/cn_notice_languages (nl_notice_id, nl_language); |
| | 34 | + |
| | 35 | +CREATE TABLE IF NOT EXISTS /*$wgDBprefix*/cn_notice_projects ( |
| | 36 | + `np_notice_id` int unsigned NOT NULL, |
| | 37 | + `np_project` varchar(32) NOT NULL |
| | 38 | +) /*$wgDBTableOptions*/; |
| | 39 | +CREATE UNIQUE INDEX /*i*/np_notice_id_project ON /*$wgDBprefix*/cn_notice_projects (np_notice_id, np_project); |