WikiLove/Daten
Appearance
< 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 Dateien
Die folgenden Felder werden für WikiLove Dateien benutzt:
Feld | Bedeutung |
---|---|
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
Das folgende Schema kann verwendet werden, um WikiLove Daten in einer MySQL-Tabelle zu importieren:
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