Gecko [ paroquia-rio-de-mouro.pt ]

Name	Size	Permission	Date
blob_tracking.sql	1.66 KB	-rw-r--r--	2016-11-28 20:20
blobs.sql	186 B	-rw-r--r--	2016-11-28 20:20
checkStorage.php	15.54 KB	-rw-r--r--	2016-11-28 20:20
compressOld.php	13.17 KB	-rw-r--r--	2016-11-28 20:20
drop_content_model_info.sql	337 B	-rw-r--r--	2016-11-28 20:20
dumpRev.php	2.76 KB	-rw-r--r--	2016-11-28 20:20
fixBug20757.php	9.06 KB	-rw-r--r--	2016-11-28 20:20
make-blobs	308 B	-rwxr-xr-x	2016-11-28 20:20
moveToExternal.php	3.58 KB	-rw-r--r--	2016-11-28 20:20
orphanStats.php	2.48 KB	-rw-r--r--	2016-11-28 20:20
recompressTracked.php	21.76 KB	-rw-r--r--	2016-11-28 20:20
resolveStubs.php	3.1 KB	-rw-r--r--	2016-11-28 20:20
storageTypeStats.php	3.11 KB	-rw-r--r--	2016-11-28 20:20
testCompression.php	2.96 KB	-rw-r--r--	2016-11-28 20:20
trackBlobs.php	11.01 KB	-rw-r--r--	2016-11-28 20:20

Rename

-- Table for tracking blobs prior to recompression or similar maintenance operations

CREATE TABLE /*$wgDBprefix*/blob_tracking (
	-- page.page_id
	-- This may be zero for orphan or deleted text
	-- Note that this is for compression grouping only -- it doesn't need to be
	-- accurate at the time recompressTracked is run. Operations such as a
	-- delete/undelete cycle may make it inaccurate.
	bt_page integer not null,

-- revision.rev_id
	-- This may be zero for orphan or deleted text
	-- Like bt_page, it does not need to be accurate when recompressTracked is run.
	bt_rev_id integer not null,

-- text.old_id
	bt_text_id integer not null,

-- The ES cluster
	bt_cluster varbinary(255),

-- The ES blob ID
	bt_blob_id integer not null,

-- The CGZ content hash, or null
	bt_cgz_hash varbinary(255),

-- The URL this blob is to be moved to
	bt_new_url varbinary(255),

-- True if the text table has been updated to point to bt_new_url
	bt_moved bool not null default 0,

-- Primary key
	-- Note that text_id is not unique due to null edits (protection, move)
	-- moveTextRow(), commit(), trackOrphanText()
	PRIMARY KEY (bt_text_id, bt_rev_id),

-- Sort by page for easy CGZ recompression
	-- doAllPages(), doAllOrphans(), doPage(), finishIncompleteMoves()
	KEY (bt_moved, bt_page, bt_text_id),

-- Key for determining the revisions using a given blob
	-- Not used by any scripts yet
	KEY (bt_cluster, bt_blob_id, bt_cgz_hash)

) /*$wgDBTableOptions*/;

-- Tracking table for blob rows that aren't tracked by the text table
CREATE TABLE /*$wgDBprefix*/blob_orphans (
	bo_cluster varbinary(255),
	bo_blob_id integer not null,

PRIMARY KEY (bo_cluster, bo_blob_id)
) /*$wgDBTableOptions*/;