119bd3b86319fe3006e72c4791d696ef1816f5f9
2 -- Table for tracking blobs prior to recompression or similar maintenance operations
4 CREATE TABLE /*$wgDBprefix*/blob_tracking (
6 -- This may be zero for orphan or deleted text
7 bt_page
integer not null,
10 -- This may be zero for orphan or deleted text
11 bt_rev_id
integer not null,
14 bt_text_id
integer not null,
17 bt_cluster
varbinary(255),
20 bt_blob_id
integer not null,
22 -- The CGZ content hash, or null
23 bt_cgz_hash
varbinary(255),
25 PRIMARY KEY (bt_rev_id
, bt_text_id
),
27 -- Sort by page for easy CGZ recompression
28 KEY (bt_page
, bt_rev_id
),
30 -- For fast orphan searches
33 -- Key for determining the revisions using a given blob
34 KEY (bt_cluster
, bt_blob_id
, bt_cgz_hash
)
35 ) /*$wgDBTableOptions*/;