http://www.mediawiki.org/wiki/Special:Code/MediaWiki/90690
Revision: 90690
Author: kaldari
Date: 2011-06-24 01:58:52 +0000 (Fri, 24 Jun 2011)
Log Message:
-----------
adding sql patch file for upcoming campaign logs
Added Paths:
-----------
trunk/extensions/CentralNotice/patches/patch-notice_logs.sql
Added: trunk/extensions/CentralNotice/patches/patch-notice_logs.sql
===================================================================
--- trunk/extensions/CentralNotice/patches/patch-notice_logs.sql
(rev 0)
+++ trunk/extensions/CentralNotice/patches/patch-notice_logs.sql
2011-06-24 01:58:52 UTC (rev 90690)
@@ -0,0 +1,34 @@
+-- Update to allow for logging of changes to campaign settings.
+
+CREATE TABLE IF NOT EXISTS /*$wgDBprefix*/cn_log (
+ `notlog_id` int unsigned NOT NULL PRIMARY KEY auto_increment,
+ `notlog_timestamp` binary(14) NOT NULL,
+ `notlog_user_id` int unsigned NOT NULL,
+ `notlog_action` enum('created','modified','removed') NOT NULL DEFAULT
'modified',
+ `notlog_not_id` int unsigned NOT NULL,
+ `notlog_begin_name` varchar(255),
+ `notlog_end_name` varchar(255),
+ `notlog_begin_projects` varchar(255),
+ `notlog_end_projects` varchar(255),
+ `notlog_begin_languages` text,
+ `notlog_end_languages` text,
+ `notlog_begin_countries` text,
+ `notlog_end_countries` text,
+ `notlog_begin_start` char(14),
+ `notlog_end_start` char(14),
+ `notlog_begin_end` char(14),
+ `notlog_end_end` char(14),
+ `notlog_begin_enabled` tinyint(1),
+ `notlog_end_enabled` tinyint(1),
+ `notlog_begin_preferred` tinyint(1),
+ `notlog_end_preferred` tinyint(1),
+ `notlog_begin_locked` tinyint(1),
+ `notlog_end_locked` tinyint(1),
+ `notlog_begin_geo` tinyint(1),
+ `notlog_end_geo` tinyint(1),
+ `notlog_begin_assignments` text,
+ `notlog_end_assignments` text
+) /*$wgDBTableOptions*/;
+CREATE INDEX /*i*/notlog_timestamp ON /*_*/cn_log (notlog_timestamp);
+CREATE INDEX /*i*/notlog_user_id ON /*_*/cn_log (notlog_user_id,
notlog_timestamp);
+CREATE INDEX /*i*/notlog_not_id ON /*_*/cn_log (notlog_not_id,
notlog_timestamp);
\ No newline at end of file
_______________________________________________
MediaWiki-CVS mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
