< WikiLove
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
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
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
This article is issued from Mediawiki. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.