| Index: trunk/phase3/maintenance/updaters.inc |
| — | — | @@ -138,6 +138,7 @@ |
| 139 | 139 | array( 'add_table', 'category', 'patch-category.sql' ), |
| 140 | 140 | array( 'do_category_population' ), |
| 141 | 141 | array( 'add_field', 'archive', 'ar_parent_id', 'patch-ar_parent_id.sql'), |
| | 142 | + array( 'add_field', 'user_newtalk', 'user_last_timestamp', 'patch-user_last_timestamp.sql'), |
| 142 | 143 | array( 'do_populate_parent_id' ), |
| 143 | 144 | array( 'check_bin', 'protected_titles', 'pt_title', 'patch-pt_title-encoding.sql', ), |
| 144 | 145 | ); |
| Index: trunk/phase3/maintenance/archives/patch-user_last_timestamp.sql |
| — | — | @@ -0,0 +1,3 @@ |
| | 2 | +-- For getting diff since last view |
| | 3 | +ALTER TABLE /*$wgDBprefix*/user_newtalk |
| | 4 | + ADD user_last_timestamp binary(14) NOT NULL default ''; |
| Property changes on: trunk/phase3/maintenance/archives/patch-user_last_timestamp.sql |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 1 | 5 | + native |
| Index: trunk/phase3/maintenance/tables.sql |
| — | — | @@ -166,6 +166,9 @@ |
| 167 | 167 | -- If the user is an anonymous user their IP address is stored here |
| 168 | 168 | -- since the user_id of 0 is ambiguous |
| 169 | 169 | user_ip varbinary(40) NOT NULL default '', |
| | 170 | + -- The highest timestamp of revisions of the talk page viewed |
| | 171 | + -- by this user |
| | 172 | + user_last_timestamp binary(14) NOT NULL default '', |
| 170 | 173 | INDEX user_id (user_id), |
| 171 | 174 | INDEX user_ip (user_ip) |
| 172 | 175 | |