Schema talk:PageRestoration

From Meta, a Wikimedia project coordination wiki
Jump to navigation Jump to search

Inactive since: https://phabricator.wikimedia.org/T171629

J Train (1973-1979).svg
Maintainer:Aaron Halfaker
Team:Research
Project:mw:Analytics/Research and Data
Status:
inactive
Purge:Auto-purge just eventCapsule PII after 90 days, keep the rest indefinitely
Contains user-input text:Yes

Example log events for log_type="delete" and log_action="restore"[edit]

> select * from enwiki.logging where log_type = "delete" and log_action = "restore" order by log_id DESC limit 10;
+----------+----------+------------+----------------+----------+---------------+--------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------+------------+-------------+-----------------+----------+
| log_id   | log_type | log_action | log_timestamp  | log_user | log_namespace | log_title                                  | log_comment                                                                                                                      | log_params | log_deleted | log_user_text   | log_page |
+----------+----------+------------+----------------+----------+---------------+--------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------+------------+-------------+-----------------+----------+
| 55246226 | delete   | restore    | 20140307211228 |    38427 |             5 | Articles_for_creation/Win_Rosenfeld        | 12 revisions restored: requested by 74.66.251.65                                                                                 | a:0:{}     |           0 | Graeme Bartlett | 42140937 |
| 55245914 | delete   | restore    | 20140307205833 |    38427 |             5 | Articles_for_creation/A_V_Varadachar       | 6 revisions restored: requested by Sriharibn                                                                                     | a:0:{}     |           0 | Graeme Bartlett | 42140818 |
| 55244941 | delete   | restore    | 20140307201338 |   524544 |             0 | Tyler_Wotherspoon                          | 8 revisions restored: WP:REFUND                                                                                                  | a:0:{}     |           0 | Amatulic        | 42138259 |
| 55244788 | delete   | restore    | 20140307200426 |   524544 |             6 | CheleyColoradoCampsLogo.jpg                | 4 revisions and 1 file restored: WP:REFUND                                                                                       | a:0:{}     |           0 | Amatulic        | 42140360 |
| 55242416 | delete   | restore    | 20140307173619 | 10728040 |             6 | Cavallaro.jpg                              | 9 revisions and 1 file restored: Uploader asserts that the mural, created in 1965, was never copyrighted. {{tl|PD-US-no notice}} | a:0:{}     |           0 | Diannaa         | 42139341 |
| 55241977 | delete   | restore    | 20140307170535 |  2300502 |            14 | Turkey_football_club_templates             | 1 revision restored: no longer empty                                                                                             | a:0:{}     |           0 | R'n'B           | 42139142 |
| 55241975 | delete   | restore    | 20140307170522 |  2300502 |            14 | Towns_in_Egypt                             | 8 revisions restored: no longer empty                                                                                            | a:0:{}     |           0 | R'n'B           | 42139141 |
| 55241967 | delete   | restore    | 20140307170434 |  2300502 |            14 | States_and_territories_established_in_1432 | 4 revisions restored: no longer empty                                                                                            | a:0:{}     |           0 | R'n'B           | 42139138 |
| 55241965 | delete   | restore    | 20140307170421 |  2300502 |            14 | Spanish_professional_wrestlers             | 2 revisions restored: no longer empty                                                                                            | a:0:{}     |           0 | R'n'B           | 42139137 |
| 55241964 | delete   | restore    | 20140307170411 |  2300502 |            14 | Spanish_crime_writers                      | 2 revisions restored: no longer empty                                                                                            | a:0:{}     |           0 | R'n'B           | 42139136 |
+----------+----------+------------+----------------+----------+---------------+--------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------+------------+-------------+-----------------+----------+
10 rows in set (0.29 sec)

It looks like we should be able to get the new page_id, namespace, title, user, # of revisions restored and # of files restored (always one?). I'd like to also be able to get the old page_id, so I'm going to add that to the schema and hope for the best. --Halfak (WMF) (talk) 21:45, 7 March 2014 (UTC)