id summary reporter owner description type status priority milestone component version severity resolution keywords cc mlocked 1919 Schema Change for MythMusic/Web + mp3Act Port Colin Guthrie xris "Hi, As mentioned on the list, here is the (hopefully) final version of the patch started on Ticket #1699. I decided to open a new ticket for the sake of neatness as #1699 is a bit crazy now!). This patch changes the schema of the database as used by MythMusic. It splits out the tables into separate songs, artists and albums tables and names the tables consistently. This split reportedly speeds up loading of music due to the reduced communications between the frontend and the db for large collections. This also adds a port of mp3Act (a web based interface for music streaming) to MythWeb (just visit the music module when not using the compact theme). This interface allows full playlist management with the ability to create, edit, delete and reorder your playlists. This patch is large but has so far been tested by 4 people with success (some issues have cropped up concerning MySQL3 support but these have now been resolved). It has undergone several revisions in my own SVN mirror of the live trunk version to allow for this testing and polishing. Some refactoring in MythMusic was also performed to reduce the code footprint and duplication (e.g. concerning playlist saving and filling lists of artists/albums/genres on 3 separate UI screens). For the sake of convenience to the patcher here is the list of commands needed to apply this patch: {{{ svn co http://svn.mythtv.org/svn/trunk/mythplugins mythplugins.schema+act cd mythplugins.schema+act tar xjf ../binary_files.tar.bz2 svn add mythweb/skins/{default,grey}/img/music svn propset svn:mimetype image/gif mythweb/skins/{default,grey}/img/music/*.gif svn propset svn:mimetype image/x-png mythweb/skins/{default,grey}/img/music/*.png bzcat ../music_schema_change+mythweb_mp3act.diff.bz2 | patch -p0 svn add mythweb/skins/{default,grey}/music.css svn add mythweb/modules/music/mp3act_* svn add mythweb/modules/music/music_handler.php }}} " patch closed minor 0.21 mythweb head medium fixed 0