I've created the SQL necessary to generate a videogroups table based
on the information in videometadata.
It works by taking the full path to the file, stripping off the base
videos directory and the filename itself, and parsing each
subdirectory into a group. This will work for files up to 20
subdirectories deep from the base video directory.
This should be enough for anyone looking to create a compatible GUI
for group manipulation.
Since MySQL < 4.1 doesn't support subqueries or UPDATE with joined
tables, the sql file is pretty large as it needs to create several
temporary tables to accumulate the grouping information.
http://www.tcbmi.com/downloads/myth/mythvideo-groups-sql.zip
Anyone should be safe to run this, as it doesn't change anything that
myth currently uses, it only adds some new data that this patch will
eventually use. It will create a backup of your videometadata table
as videometadata_backup, so there's (hopefully) no chance of losing
data.
-- Jeff