r71220 MediaWiki - Code Review archive

Repository:MediaWiki
Revision:r71219‎ | r71220 | r71221 >
Date:23:38, 17 August 2010
Author:kaldari
Status:ok
Tags:
Comment:
fixing SQL error introduced in r70969, making index from r70907 UNIQUE
Modified paths:
  • /trunk/extensions/CentralNotice/CentralNotice.sql (modified) (history)
  • /trunk/extensions/CentralNotice/patches/patch-notice_languages.sql (modified) (history)

Diff [purge]

Index: trunk/extensions/CentralNotice/patches/patch-notice_languages.sql
@@ -5,4 +5,4 @@
66 `not_id` int unsigned NOT NULL,
77 `not_language` varchar(32) NOT NULL
88 ) /*$wgDBTableOptions*/;
9 -CREATE INDEX /*i*/cn_not_id_not_language ON /*$wgDBprefix*/cn_notice_languages (not_id, not_language);
 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
Index: trunk/extensions/CentralNotice/CentralNotice.sql
@@ -27,5 +27,4 @@
2828 `not_id` int unsigned NOT NULL,
2929 `not_language` varchar(32) NOT NULL
3030 ) /*$wgDBTableOptions*/;
31 -
32 -CREATE UNIQUE KEY `not_id_not_language` ON /*_*/cn_notice_languages(`not_id`,`not_language`)
 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

Past revisions this follows-up on

RevisionCommit summaryAuthorDate
r70907moving patch-add-preferred.sql prior to adding to update hookkaldari18:53, 11 August 2010
r70969Follow-up r68758: fixed SQLite compatibilitymaxsem16:39, 12 August 2010

Status & tagging log