[mythtv] handling database structural changes

Kirby Vandivort kvandivo at ks.uiuc.edu
Sat Jun 7 09:51:43 EDT 2003

re: the changes that you've committed..  I've just recently started
digging into the src, so I could be mistaken, but...

it would probably be good to rename the 'dbschemaversion' var to
something that specifies 'mythtv'.  The reason that I say this is
because the other myth 'components' (music, video, etc) also create
tables in mythconverg that could benefit from a version number.
However, I don't think we want mythvideo versions tied to a file in the
mythtv cvs that contains the hardcoded version number (in other words,
as it currently stands, everytime someone changes the mythvideo table,
they will have to remember to go and change something in the mythtv cvs
tree.)  Would be better for mythvideo to keep track of its own.  So, each
component would have its own row in 'settings' that would tell it what
version of the db IT was on.

Just my thoughts..


On Fri, Jun 06, 2003 at 12:15:17PM -0700, Bruce Markey wrote:
> Isaac Richards wrote:
> >On Friday 06 June 2003 11:19 am, Kirby Vandivort wrote:
> >
> >>Any interest in having something like this for Myth?  If so, I can
> >>start working on the code.
> >
> >
> >Not at this point in time, no.  When the database has stabilized more, 
> >yes.  I just don't want to have lots of crufty upgrade code in there at 
> >the moment.
> Agreed that embedding upgrade code is problematic. However,
> the idea of having a schema version number or date in the
> settings table would make a lot of sense. A simple check
> when the master backend starts could warn if the database
> needs to be updated. There seems to be something like this
> for the executables to check the libmyth version.
> --  bjm
> _______________________________________________
> mythtv-dev mailing list
> mythtv-dev at snowman.net
> http://lists.snowman.net/cgi-bin/mailman/listinfo/mythtv-dev


Kirby Vandivort                      Theoretical and Computational Biophysics 
Email: kvandivo at ks.uiuc.edu          3051 Beckman Institute
http://www.ks.uiuc.edu/~kvandivo/    University of Illinois
Phone: (217) 244-5711                405 N. Mathews Ave
Fax  : (217) 244-6078                Urbana, IL  61801, USA

More information about the mythtv-dev mailing list