On Feb 17, 2009, at 9:55 AM, Donohoe, Mark wrote: > Bob, > > Late Friday I was making the DB table changes. I went to make the > change for the job_submitter and couldn't find my notes. I know we > discussed this on fossology irc last week. > > Email says: > > Mark: > Job table: > ---------- > replace job_submitter with user_pk,will need to change the type of the > column. > > Bob: > Yep. It never should have been a text name in the first place. > > But I seem to recall that on IRC we discussed that was not right... I > thought you mentioned something about using a field in the jobqueue > table and leaving the job table as is. When I look at the jobqueue > table, I don't see anything that might apply. > > I thought I made a log of the irc discussion, but I can't find it. Do > you recall?
Not without more context. But what I think needs to be done is: drop job.job_submitter add job.user_fk add user field to denote default notification _______________________________________________ fossology mailing list [email protected] http://fossology.org/mailman/listinfo/fossology
