http://www.mediawiki.org/wiki/Special:Code/MediaWiki/71222
Revision: 71222
Author: kaldari
Date: 2010-08-18 00:08:06 +0000 (Wed, 18 Aug 2010)
Log Message:
-----------
forgot to update main SQL file for r71004, cleaning up SQL formatting
Modified Paths:
--------------
trunk/extensions/CentralNotice/CentralNotice.sql
trunk/extensions/CentralNotice/patches/patch-notice_languages.sql
Modified: trunk/extensions/CentralNotice/CentralNotice.sql
===================================================================
--- trunk/extensions/CentralNotice/CentralNotice.sql 2010-08-18 00:03:09 UTC
(rev 71221)
+++ trunk/extensions/CentralNotice/CentralNotice.sql 2010-08-18 00:08:06 UTC
(rev 71222)
@@ -1,30 +1,32 @@
CREATE TABLE IF NOT EXISTS /*$wgDBprefix*/cn_notices (
- `not_id` int NOT NULL PRIMARY KEY auto_increment,
- `not_name` varchar(255) NOT NULL,
- `not_start` char(14) NOT NULL,
- `not_end` char(14) NOT NULL,
- `not_enabled` bool NOT NULL default '0',
- `not_preferred` bool NOT NULL default '0',
- `not_locked` bool NOT NULL default '0',
- `not_language` varchar(32) NOT NULL,
- `not_project` varchar(255) NOT NULL
+ `not_id` int NOT NULL PRIMARY KEY auto_increment,
+ `not_name` varchar(255) NOT NULL,
+ `not_start` char(14) NOT NULL,
+ `not_end` char(14) NOT NULL,
+ `not_enabled` bool NOT NULL default '0',
+ `not_preferred` bool NOT NULL default '0',
+ `not_locked` bool NOT NULL default '0',
+ `not_language` varchar(32) NOT NULL,
+ `not_project` varchar(255) NOT NULL
) /*$wgDBTableOptions*/;
CREATE TABLE IF NOT EXISTS /*$wgDBprefix*/cn_assignments (
- `asn_id` int NOT NULL PRIMARY KEY auto_increment,
- `not_id` int NOT NULL,
- `tmp_id` int NOT NULL,
- `tmp_weight` int NOT NULL
+ `asn_id` int NOT NULL PRIMARY KEY auto_increment,
+ `not_id` int NOT NULL,
+ `tmp_id` int NOT NULL,
+ `tmp_weight` int NOT NULL
) /*$wgDBTableOptions*/;
CREATE TABLE IF NOT EXISTS /*$wgDBprefix*/cn_templates (
- `tmp_id` int NOT NULL PRIMARY KEY auto_increment,
- `tmp_name` varchar(255) default NULL
+ `tmp_id` int NOT NULL PRIMARY KEY auto_increment,
+ `tmp_name` varchar(255) default NULL
+ `tmp_display_anon` BOOLEAN NOT NULL DEFAULT 1,
+ `tmp_display_account` BOOLEAN NOT NULL DEFAULT 1;
) /*$wgDBTableOptions*/;
CREATE TABLE IF NOT EXISTS /*$wgDBprefix*/cn_notice_languages (
- `id` int unsigned NOT NULL PRIMARY KEY auto_increment,
- `not_id` int unsigned NOT NULL,
- `not_language` varchar(32) NOT NULL
+ `id` int unsigned NOT NULL PRIMARY KEY auto_increment,
+ `not_id` int unsigned NOT NULL,
+ `not_language` varchar(32) NOT NULL
) /*$wgDBTableOptions*/;
-CREATE UNIQUE INDEX /*i*/cn_not_id_not_language ON
/*$wgDBprefix*/cn_notice_languages (not_id, not_language);
\ No newline at end of file
+CREATE UNIQUE INDEX /*i*/cn_not_id_not_language ON
/*$wgDBprefix*/cn_notice_languages (not_id, not_language);
Modified: trunk/extensions/CentralNotice/patches/patch-notice_languages.sql
===================================================================
--- trunk/extensions/CentralNotice/patches/patch-notice_languages.sql
2010-08-18 00:03:09 UTC (rev 71221)
+++ trunk/extensions/CentralNotice/patches/patch-notice_languages.sql
2010-08-18 00:08:06 UTC (rev 71222)
@@ -1,8 +1,8 @@
-- Update to allow for any number of languages per notice.
CREATE TABLE IF NOT EXISTS /*$wgDBprefix*/cn_notice_languages (
- `id` int unsigned NOT NULL PRIMARY KEY auto_increment,
- `not_id` int unsigned NOT NULL,
- `not_language` varchar(32) NOT NULL
+ `id` int unsigned NOT NULL PRIMARY KEY auto_increment,
+ `not_id` int unsigned NOT NULL,
+ `not_language` varchar(32) NOT NULL
) /*$wgDBTableOptions*/;
-CREATE UNIQUE INDEX /*i*/cn_not_id_not_language ON
/*$wgDBprefix*/cn_notice_languages (not_id, not_language);
\ No newline at end of file
+CREATE UNIQUE INDEX /*i*/cn_not_id_not_language ON
/*$wgDBprefix*/cn_notice_languages (not_id, not_language);
_______________________________________________
MediaWiki-CVS mailing list
MediaWiki-CVS@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
