| Index: trunk/extensions/WikiLove/patches/WikiLoveLog.sql |
| — | — | @@ -5,14 +5,20 @@ |
| 6 | 6 | -- |
| 7 | 7 | |
| 8 | 8 | CREATE TABLE IF NOT EXISTS /*_*/wikilove_log ( |
| 9 | | - wll_id int NOT NULL PRIMARY KEY auto_increment, -- unique id |
| 10 | | - wll_timestamp binary(14) NOT NULL, -- timestamp |
| 11 | | - wll_sender int(11) NOT NULL, -- user id of the sender |
| 12 | | - wll_receiver int(11) NOT NULL, -- user id of the receiver |
| 13 | | - wll_type varchar(64) NOT NULL, -- type (and subtype) of message |
| 14 | | - wll_subject varchar(255) NOT NULL, -- subject line |
| 15 | | - wll_message blob NOT NULL, -- actual message |
| 16 | | - wll_email bool NOT NULL default '0' -- whether or not a notification mail has been sent |
| | 9 | + wll_id int NOT NULL PRIMARY KEY auto_increment, -- unique id |
| | 10 | + wll_timestamp binary(14) NOT NULL, -- timestamp |
| | 11 | + wll_sender int(11) NOT NULL, -- user id of the sender |
| | 12 | + wll_sender_registration varchar(32) default NULL, -- registration date of the sender |
| | 13 | + wll_sender_totaledits mediumint(8) default NULL, -- total number of edits for the sender |
| | 14 | + wll_sender_recentedits smallint(6) default NULL, -- number of recent edits for the sender |
| | 15 | + wll_receiver int(11) NOT NULL, -- user id of the receiver |
| | 16 | + wll_receiver_registration varchar(32) default NULL, -- registration date of the receiver |
| | 17 | + wll_receiver_totaledits mediumint(8) default NULL, -- total number of edits for the receiver |
| | 18 | + wll_receiver_recentedits smallint(6) default NULL, -- number of recent edits for the receiver |
| | 19 | + wll_type varchar(64) NOT NULL, -- type (and subtype) of message |
| | 20 | + wll_subject varchar(255) NOT NULL, -- subject line |
| | 21 | + wll_message blob NOT NULL, -- actual message |
| | 22 | + wll_email bool NOT NULL default '0' -- whether or not a notification mail has been sent |
| 17 | 23 | ) /*$wgDBTableOptions*/; |
| 18 | 24 | |
| 19 | 25 | CREATE INDEX /*i*/wll_timestamp ON /*_*/wikilove_log (wll_timestamp); |