| Index: trunk/extensions/CentralNotice/patches/patch-notice_languages.sql |
| — | — | @@ -1,8 +1,8 @@ |
| 2 | 2 | -- Update to allow for any number of languages per notice. |
| 3 | 3 | |
| 4 | 4 | CREATE TABLE IF NOT EXISTS /*$wgDBprefix*/cn_notice_languages ( |
| 5 | | - `id` int unsigned NOT NULL PRIMARY KEY auto_increment, |
| 6 | | - `not_id` int unsigned NOT NULL, |
| 7 | | - `not_language` varchar(32) NOT NULL |
| | 5 | + `id` int unsigned NOT NULL PRIMARY KEY auto_increment, |
| | 6 | + `not_id` int unsigned NOT NULL, |
| | 7 | + `not_language` varchar(32) NOT NULL |
| 8 | 8 | ) /*$wgDBTableOptions*/; |
| 9 | | -CREATE UNIQUE INDEX /*i*/cn_not_id_not_language ON /*$wgDBprefix*/cn_notice_languages (not_id, not_language); |
| \ No newline at end of file |
| | 9 | +CREATE UNIQUE INDEX /*i*/cn_not_id_not_language ON /*$wgDBprefix*/cn_notice_languages (not_id, not_language); |
| Index: trunk/extensions/CentralNotice/CentralNotice.sql |
| — | — | @@ -1,30 +1,32 @@ |
| 2 | 2 | CREATE TABLE IF NOT EXISTS /*$wgDBprefix*/cn_notices ( |
| 3 | | - `not_id` int NOT NULL PRIMARY KEY auto_increment, |
| 4 | | - `not_name` varchar(255) NOT NULL, |
| 5 | | - `not_start` char(14) NOT NULL, |
| 6 | | - `not_end` char(14) NOT NULL, |
| 7 | | - `not_enabled` bool NOT NULL default '0', |
| 8 | | - `not_preferred` bool NOT NULL default '0', |
| 9 | | - `not_locked` bool NOT NULL default '0', |
| 10 | | - `not_language` varchar(32) NOT NULL, |
| 11 | | - `not_project` varchar(255) NOT NULL |
| | 3 | + `not_id` int NOT NULL PRIMARY KEY auto_increment, |
| | 4 | + `not_name` varchar(255) NOT NULL, |
| | 5 | + `not_start` char(14) NOT NULL, |
| | 6 | + `not_end` char(14) NOT NULL, |
| | 7 | + `not_enabled` bool NOT NULL default '0', |
| | 8 | + `not_preferred` bool NOT NULL default '0', |
| | 9 | + `not_locked` bool NOT NULL default '0', |
| | 10 | + `not_language` varchar(32) NOT NULL, |
| | 11 | + `not_project` varchar(255) NOT NULL |
| 12 | 12 | ) /*$wgDBTableOptions*/; |
| 13 | 13 | |
| 14 | 14 | CREATE TABLE IF NOT EXISTS /*$wgDBprefix*/cn_assignments ( |
| 15 | | - `asn_id` int NOT NULL PRIMARY KEY auto_increment, |
| 16 | | - `not_id` int NOT NULL, |
| 17 | | - `tmp_id` int NOT NULL, |
| 18 | | - `tmp_weight` int NOT NULL |
| | 15 | + `asn_id` int NOT NULL PRIMARY KEY auto_increment, |
| | 16 | + `not_id` int NOT NULL, |
| | 17 | + `tmp_id` int NOT NULL, |
| | 18 | + `tmp_weight` int NOT NULL |
| 19 | 19 | ) /*$wgDBTableOptions*/; |
| 20 | 20 | |
| 21 | 21 | CREATE TABLE IF NOT EXISTS /*$wgDBprefix*/cn_templates ( |
| 22 | | - `tmp_id` int NOT NULL PRIMARY KEY auto_increment, |
| 23 | | - `tmp_name` varchar(255) default NULL |
| | 22 | + `tmp_id` int NOT NULL PRIMARY KEY auto_increment, |
| | 23 | + `tmp_name` varchar(255) default NULL |
| | 24 | + `tmp_display_anon` BOOLEAN NOT NULL DEFAULT 1, |
| | 25 | + `tmp_display_account` BOOLEAN NOT NULL DEFAULT 1; |
| 24 | 26 | ) /*$wgDBTableOptions*/; |
| 25 | 27 | |
| 26 | 28 | CREATE TABLE IF NOT EXISTS /*$wgDBprefix*/cn_notice_languages ( |
| 27 | | - `id` int unsigned NOT NULL PRIMARY KEY auto_increment, |
| 28 | | - `not_id` int unsigned NOT NULL, |
| 29 | | - `not_language` varchar(32) NOT NULL |
| | 29 | + `id` int unsigned NOT NULL PRIMARY KEY auto_increment, |
| | 30 | + `not_id` int unsigned NOT NULL, |
| | 31 | + `not_language` varchar(32) NOT NULL |
| 30 | 32 | ) /*$wgDBTableOptions*/; |
| 31 | | -CREATE UNIQUE INDEX /*i*/cn_not_id_not_language ON /*$wgDBprefix*/cn_notice_languages (not_id, not_language); |
| \ No newline at end of file |
| | 33 | +CREATE UNIQUE INDEX /*i*/cn_not_id_not_language ON /*$wgDBprefix*/cn_notice_languages (not_id, not_language); |