On 2/24/17, Warren Young <war...@etr-usa.com> wrote: > While poking around inside the Fossil DB, I came away with several > questions: > > 1. What is event.euser? This column seems completely unused on my largest > repository. (select distinct count(euser) from event == 0) I’ve tried > grepping the source, and all I saw is a bunch of coalesce(user,euser) stuff, > which I assume means it uses whichever one is set. (I did not look at every > last instance, however.) So why do we need both?
event.user is the original user name as is appears in the Manifest object. event.euser is the revised or edited user name defined by subsequent tags. For example, if you click on the "Edit" screen for a check-in and change the user name, the revised user name goes in euser but the original user name continues in user. Normally euser is NULL, so the standard way of finding the user name that is preferred for display is coalesce(euser,user). > > 2. ticketchng.username. Also unused here. What is this for, and why do we > have it in addition to ticketchng.login, which does have the expected data > here? Grepping the code, it looks like part of the code uses “username” and > part uses “login.” What’s going on here? The fields of ticketchng (apart from the tkt_id, tkt_rid, and tkt_mtime) are all repository-defined. You can change them to whatever you like. I don't recall right away why there is both a username and login field in the default. > > 3. Is user.photo a half-implemented feature? All I see in the code are bits > to copy the BLOB from one place to another, with no way to set it or display > it. user.photo has never been used. I originally intended it for (can you guess?) storing a thumbnail image of the actual person. Later I thought I might reuse the field for some other purpose, so I have never purged it. It is usually NULL, is it not? -- D. Richard Hipp d...@sqlite.org _______________________________________________ fossil-users mailing list fossil-users@lists.fossil-scm.org http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
