[slim] Re: Database schema changes with MySQL
When Slimserver connects to the db for the first time it automatically runs the dbcreate.sql for you and starts a scan. There is also the metainformation table that holds details about what version of the database it is. -- Browny Browny's Profile: http://forums.slimdevices.com/member.php?userid=2295 View this thread: http://forums.slimdevices.com/showthread.php?t=19903 ___ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
Re: [slim] Re: Database schema changes with MySQL
In article [EMAIL PROTECTED], Browny[EMAIL PROTECTED] wrote: When Slimserver connects to the db for the first time it automatically runs the dbcreate.sql for you and starts a scan. Ok, so my initial import of the schema was un-necessary. There is also the metainformation table that holds details about what version of the database it is. Does that mean that if a new version of slimserver comes out with a new database version, then the new schema will be applied automatically? Thanks Andy ___ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] Re: Database schema changes with MySQL
adhawkins Wrote: Does that mean that if a new version of slimserver comes out with a new database version, then the new schema will be applied automatically? ... Yes should do. Each release of the database comes with an upgrade script that get applied when Slimserver starts. Normally this script is just incrementing the version number, but occasionally the structure of the tables may change. -- Browny Browny's Profile: http://forums.slimdevices.com/member.php?userid=2295 View this thread: http://forums.slimdevices.com/showthread.php?t=19903 ___ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
Re: [slim] Re: Database schema changes with MySQL
Hi, In article [EMAIL PROTECTED], Browny[EMAIL PROTECTED] wrote: Yes should do. Each release of the database comes with an upgrade script that get applied when Slimserver starts. Normally this script is just incrementing the version number, but occasionally the structure of the tables may change. Excellent, just what I wanted to know. Thanks Andy ___ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss