Bob Gobeille wrote: > > 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 Bob, Thanks. That is what I thought as well. The last item is already done in my sandbox. I'll complete the others this morning and continue coding.
-- Mark Donohoe ALPS/OSTT, Cupertino CA. fossology.org _______________________________________________ fossology mailing list [email protected] http://fossology.org/mailman/listinfo/fossology
