(If you don't work with the image or oldimage tables, you can ignore
this message)
Hello,
in [1] we announced that finally we are implementing the changes
described in T28741[2].
This message provides an update on that announcement.
Currently, every current version of an image has a row in the image
table and if there are older versions of that file, those rows could be
found in the oldimage table. These two tables (image and oldimage) will
be dropped in around two months. The replacement will be two main
tables: file and filerevision. Every file will have a row in the file
table describing the name and the type. Every version of the file
(current and old) will have a row in filerevision describing the
file-specific information such as its size or the hash of the file,
similar to the existing distinction between pages and revisions. Another
improvement is that every file and file revision will get a unique auto
increment id simplifying many operations and queries.
The new tables are already accessible in wikireplicas and fully populated.
The old tables are currently also still accessible in wikireplicas.
However, if your tools or queries access image or oldimage directly,
please update them to use the new schema before 28 May. After that date,
the old tables will be removed from wikireplicas.
Thank you,
Alexander Vorwerk — IRC: Zabe
[1] -
https://lists.wikimedia.org/hyperkitty/list/[email protected]/message/7AMRB7G4CZ6BBOILAA6PK4QX44MUAHT4/
[2] - https://phabricator.wikimedia.org/T28741
_______________________________________________
Cloud-announce mailing list -- [email protected]
List information:
https://lists.wikimedia.org/postorius/lists/cloud-announce.lists.wikimedia.org/
