Joal has submitted this change and it was merged. ( https://gerrit.wikimedia.org/r/391185 )
Change subject: Correct mediawiki_archive table creation script ...................................................................... Correct mediawiki_archive table creation script The ar_deleted field was set to boolean while it's an int. Change-Id: If167a39084a6ce229fbc9ac472c5ce7ca3b7368e --- M hive/mediawiki/history/create_mediawiki_archive_table.hql 1 file changed, 1 insertion(+), 1 deletion(-) Approvals: Joal: Verified; Looks good to me, approved diff --git a/hive/mediawiki/history/create_mediawiki_archive_table.hql b/hive/mediawiki/history/create_mediawiki_archive_table.hql index 4f710ab..53cf66c 100644 --- a/hive/mediawiki/history/create_mediawiki_archive_table.hql +++ b/hive/mediawiki/history/create_mediawiki_archive_table.hql @@ -21,7 +21,7 @@ `ar_flags` string COMMENT 'This field is similar to old_flags in the text table. It was added in MediaWiki 1.5, but is most likely unused: For revisions archived with older versions, it is not used as it was not there at the time of their deletion\; a conversion, which would have added flags for revisions, which already had been archived when the update to MediaWiki 1.5 or newer was being done, was not applied. Texts of revisions archived with MediaWiki 1.5 or later do not use this field\; they themselves stay in the text table\; together with their flags staying in old_flags.', `ar_rev_id` bigint COMMENT 'When revisions are deleted, their unique rev_id is stored here so it can be retained after undeletion. This is necessary to retain permalinks to given revisions after accidental delete cycles or messy operations like history merges. Note: Old entries from 1.4 will be NULL here, and a new rev_id will be created on undeletion for those revisions.', `ar_text_id` bigint COMMENT 'For revisions deleted in MediaWiki 1.5 and later, this is a key to old_id within the text table\; that is, it is the key to the stored text in the storage backend. To avoid breaking the block-compression scheme and otherwise making storage changes harder, the actual text is *not* deleted from the text table\; rather, the text is merely hidden by removal of the page and revision entries. Comparable to rev_text_id. Note Note: Old entries deleted under MediaWiki 1.2-1.4 will have NULL values in this field, and their ar_text and ar_flags fields will be used to create a new text row upon undeletion.', - `ar_deleted` boolean COMMENT 'This field is reserved for the RevDelete/Suppression (Oversight) system. Equivalent to rev_deleted.', + `ar_deleted` int COMMENT 'This field is reserved for the RevDelete/Suppression (Oversight) system. Equivalent to rev_deleted.', `ar_len` bigint COMMENT 'This field contains the length of the deleted revision, in bytes. Analogous to rev_len.', `ar_page_id` bigint COMMENT 'Reference to page_id. Useful for sysadmin fixing of large pages merged together in the archives, or for cleanly restoring a page at its original ID number if possible. Comparable to rev_page. Will be NULL for pages deleted prior to 1.11.', `ar_parent_id` bigint COMMENT 'The revision id of the previous revision to the page. Populated from rev_parent_id. Will be null for revisions deleted prior to 1.13. First edits to newly created articles (and therefore the creation of the article) can be identified by the value of this field being 0.', -- To view, visit https://gerrit.wikimedia.org/r/391185 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: merged Gerrit-Change-Id: If167a39084a6ce229fbc9ac472c5ce7ca3b7368e Gerrit-PatchSet: 1 Gerrit-Project: analytics/refinery Gerrit-Branch: master Gerrit-Owner: Joal <j...@wikimedia.org> Gerrit-Reviewer: Joal <j...@wikimedia.org> _______________________________________________ MediaWiki-commits mailing list MediaWiki-commits@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
