http://www.mediawiki.org/wiki/Special:Code/MediaWiki/89811
Revision: 89811
Author: kaldari
Date: 2011-06-10 02:17:46 +0000 (Fri, 10 Jun 2011)
Log Message:
-----------
adding new fields for requested analytics
Modified Paths:
--------------
trunk/extensions/WikiLove/patches/WikiLoveLog.sql
Modified: trunk/extensions/WikiLove/patches/WikiLoveLog.sql
===================================================================
--- trunk/extensions/WikiLove/patches/WikiLoveLog.sql 2011-06-10 01:11:18 UTC
(rev 89810)
+++ trunk/extensions/WikiLove/patches/WikiLoveLog.sql 2011-06-10 02:17:46 UTC
(rev 89811)
@@ -5,14 +5,20 @@
--
CREATE TABLE IF NOT EXISTS /*_*/wikilove_log (
- wll_id int NOT NULL PRIMARY KEY auto_increment, -- unique id
- wll_timestamp binary(14) NOT NULL, -- timestamp
- wll_sender int(11) NOT NULL, -- user id of the sender
- wll_receiver int(11) NOT NULL, -- user id of the
receiver
- wll_type varchar(64) NOT NULL, -- type (and subtype)
of message
- wll_subject varchar(255) NOT NULL, -- subject line
- wll_message blob NOT NULL, -- actual message
- wll_email bool NOT NULL default '0' -- whether or not a
notification mail has been sent
+ wll_id int NOT NULL PRIMARY KEY auto_increment, -- unique id
+ wll_timestamp binary(14) NOT NULL, -- timestamp
+ wll_sender int(11) NOT NULL, -- user id of
the sender
+ wll_sender_registration varchar(32) default NULL, -- registration
date of the sender
+ wll_sender_totaledits mediumint(8) default NULL, -- total number
of edits for the sender
+ wll_sender_recentedits smallint(6) default NULL, -- number of
recent edits for the sender
+ wll_receiver int(11) NOT NULL, -- user id of
the receiver
+ wll_receiver_registration varchar(32) default NULL, -- registration
date of the receiver
+ wll_receiver_totaledits mediumint(8) default NULL, -- total number
of edits for the receiver
+ wll_receiver_recentedits smallint(6) default NULL, -- number of
recent edits for the receiver
+ wll_type varchar(64) NOT NULL, -- type (and
subtype) of message
+ wll_subject varchar(255) NOT NULL, -- subject line
+ wll_message blob NOT NULL, -- actual
message
+ wll_email bool NOT NULL default '0' -- whether or
not a notification mail has been sent
) /*$wgDBTableOptions*/;
CREATE INDEX /*i*/wll_timestamp ON /*_*/wikilove_log (wll_timestamp);
_______________________________________________
MediaWiki-CVS mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
