Re: Alpha coordination and building

[Christopher C Chimelis <chris@classnet.med.miami.edu>]

On Fri, 11 Jun 1999, Bart Warmerdam wrote:

> Possible dB model:
> 
> 
>         Packages
>        ---------------------
> 	
>  +---	pkgID          long PK
>  |	pkgName        text
>  |	pgkVersion     text
>  |	pkgDebRelease  text
>  |	pkgBuildsOk    bool
>  |	dateInstall    date/time
>  |	uploader       text       (example: Bart Warmerdam <bartw@xs4all.nl>)
>  |      btsNotificationDate date/time
>  |
>  |
>  |      ReportedBugs
>  |     ---------------------
>  |
>  |      btsBugNr       long PK
>  +---   pkgID          long 
>  |
>  |
>  |      Patches
>  |     ---------------------
>  |
>  |      bugID          long PK
>  +---   pkgID          long
>         url            text

Wouldn't it make more sense to put the btsNotificationDate field in the
ReportedBugs table?  Maybe just the sheer existance of a record in
ReportedBugs for a package could be enough to trigger a checkbox or "View
Bug Report Info" button on a query reponce.

C