WikiLove/Data

From MediaWiki.org
Jump to: navigation, search

Other languages:
العربية • ‎বাংলা • ‎Deutsch • ‎English • ‎español • ‎français • ‎עברית • ‎日本語 • ‎português do Brasil • ‎română • ‎русский • ‎සිංහල • ‎اردو

CC BY-SA licensed dumps of data generated by WikiLove will be available for download shortly. Real-time Wikilove data is currently available from the Toolserver.


Raw WikiLove data[edit]

The following fields are used to store WikiLove data:

field meaning
wll_id the unique identifier for a WikiLove message
wll_timestamp the datetime at which the message was sent
wll_sender the user ID of WikiLove's sender
wll_sender_registration the timestamp of the sender's user account registration
wll_sender_editcount number of edits of the sender at the time WikiLove was sent
wll_receiver the user ID of WikiLove's recipient
wll_receiver_registration the timestamp of the recipient's user account registration
wll_receiver_editcount number of edits of the recipient at the time WikiLove was received
wll_type type of WikiLove sent (e.g. food-strawberries)
wll_subject subject of WikiLove message
wll_message body of WikiLove message

SQL schema[edit]

The following schema can be used to import WikiLove data into a MySQL table:

CREATE TABLE `wikilove_log` (
  `wll_id` int(11) NOT NULL AUTO_INCREMENT,
  `wll_timestamp` binary(14) NOT NULL,
  `wll_sender` int(11) NOT NULL,
  `wll_sender_registration` binary(14) DEFAULT NULL,
  `wll_sender_editcount` int(11) DEFAULT NULL,
  `wll_receiver` int(11) NOT NULL,
  `wll_receiver_registration` binary(14) DEFAULT NULL,
  `wll_receiver_editcount` int(11) DEFAULT NULL,
  `wll_type` varbinary(64) NOT NULL,
  `wll_subject` varbinary(255) NOT NULL,
  `wll_message` blob NOT NULL,
  PRIMARY KEY (`wll_id`),
  KEY `wll_timestamp` (`wll_timestamp`),
  KEY `wll_type_time` (`wll_type`,`wll_timestamp`),
  KEY `wll_sender_time` (`wll_sender`,`wll_timestamp`),
  KEY `wll_receiver_time` (`wll_receiver`,`wll_timestamp`)
) ENGINE=InnoDB  DEFAULT CHARSET=binary