X-Git-Url: https://git.heureux-cyclage.org/?p=lhc%2Fweb%2Fwiklou.git;a=blobdiff_plain;f=maintenance%2Farchives%2Fpatch-filejournal.sql;h=4356d70d27e88608fff4074c4657c4d378267066;hp=114297c6d88f82da2511f2906f6f1635a70e2a52;hb=f5b9af121a07ecc674a63cbc65c3a01e9fa7d785;hpb=ddcf8cc660c810f1601b61c90aa33cb36ca60cad diff --git a/maintenance/archives/patch-filejournal.sql b/maintenance/archives/patch-filejournal.sql index 114297c6d8..4356d70d27 100644 --- a/maintenance/archives/patch-filejournal.sql +++ b/maintenance/archives/patch-filejournal.sql @@ -8,15 +8,13 @@ CREATE TABLE /*_*/filejournal ( fj_backend varchar(255) NOT NULL, -- The storage path that was affected (may be internal paths) fj_path blob NOT NULL, - -- SHA-1 file path hash in base-36 - fj_path_sha1 varbinary(32) NOT NULL default '', -- Primitive operation description (create/update/delete) fj_op varchar(16) NOT NULL default '', -- SHA-1 file content hash in base-36 fj_new_sha1 varbinary(32) NOT NULL default '', -- Timestamp of the batch operation fj_timestamp varbinary(14) NOT NULL default '' -); +) /*$wgDBTableOptions*/; CREATE INDEX /*i*/fj_batch_id ON /*_*/filejournal (fj_batch_uuid); CREATE INDEX /*i*/fj_timestamp ON /*_*/filejournal (fj_timestamp);