[Buildbot-commits] [Buildbot] #1053: schedulerdb should have id columns on all tables

[Buildbot]

#1053: schedulerdb should have id columns on all tables
------------------------+---------------------------------------------------
Reporter:  Pike         |       Owner:          
    Type:  enhancement  |      Status:  new     
Priority:  major        |   Milestone:  0.8.3   
 Version:  0.8.2        |    Keywords:  database
------------------------+---------------------------------------------------
Changes (by dustin):

  * keywords:  => database
  * type:  undecided => enhancement
  * milestone:  undecided => 0.8.3


Old description:

> I've been hacking on a django wrapper on the schedulerdb, and django
> really wants id columns on all tables.
>
> The list of affected tables seems to be
>
> buildset_properties
> change_files
> change_links
> change_properties
> last_access
> scheduler_changes
> scheduler_upstream_buildsets
> sourcestamp_changes
> version

New description:

 I've been hacking on a django wrapper on the schedulerdb, and django
 really wants id columns on all tables.

 The list of affected tables seems to be

 {{{
 buildset_properties
 change_files
 change_links
 change_properties
 last_access
 scheduler_changes
 scheduler_upstream_buildsets
 sourcestamp_changes
 version
 }}}

--

Comment:

 The {{{version}}} table is a singleton (soon to be replaced with
 {{{migrate_version}}}).

 I don't see what harm an extra column will do in the other tables.  I'll
 take care of this when the SQLAlchemy stuff lands.

 Thanks, Axel!

-- 
Ticket URL: <http://buildbot.net/trac/ticket/1053#comment:1>
Buildbot <http://buildbot.net/>
Buildbot: build/test automation