purplecat: Hand Drawn picture of a Toy Cat (programming)
purplecat ([personal profile] purplecat) wrote in [site community profile] dw_dev_training2013-05-12 08:13 pm
  • Add Memory
  • Share This Entry
Entry tags:

userpicmap2/3

Can I ask what is the difference between the database tables userpicmap2 and userpicmap3 (and possibly userpicmap1 though I couldn't find that mentioned in the code on a quick grep). userpicmap3 seems to be the one most used and there are comments in the code that suggest userpicmap2 is just there for backwards compatibility. Is that correct?
Flat | Top-Level Comments Only
denise: Image: Me, facing away from camera, on top of the Castel Sant'Angelo in Rome (Default)

[staff profile] denise 2013-05-13 06:13 am (UTC)(link)
userpicmap was the old table used in pre-dataversion-7 LJ code, userpicmap2 was the old table used in dataversion 7 (clustered userpics), and then userpicmap3 was the table introduced in dataversion 9 (introduced in bug 3064, to allow for renaming userpics).

so, you always want to use userpicmap3.
denise: Image: Me, facing away from camera, on top of the Castel Sant'Angelo in Rome (Default)

[staff profile] denise 2013-05-13 08:18 am (UTC)(link)

you're welcome!

for finding the history of database tables like that, btw, a good first stop is update-db-general.pl in 'blame' mode, then compare to lj's update-db-general.pl, also in blame mode. it helps you narrow down when/where a particular change was made, and (if it was from us as opposed to from lj) will usually give you a link to the bug.

(this works for all files, not just update-db-general.pl, but since you were asking about a db table, that's where you start.)

Flat | Top-Level Comments Only