Schema talk:PageRestoration
Add topicLatest comment: 10 years ago by Halfak (WMF) in topic Example log events for log_type="delete" and log_action="restore"
Inactive since: https://phabricator.wikimedia.org/T171629
.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 |
This page holds a JSON schema that specifies a data model for EventLogging.
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)