by nigelc » Sun Nov 01, 2020 4:03 pm
by nolagunnesch » Wed Jan 16, 2019 11:58 am
by anatole » Tue Jan 27, 2015 5:24 am
by kum » Wed Jun 11, 2014 1:25 am
by greggw » Tue May 29, 2012 5:11 am
by Lowlander » Mon May 28, 2012 9:16 pm
by greggw » Mon May 28, 2012 7:16 pm
by MMuser2011 » Mon Jan 30, 2012 8:30 am
Bex wrote:I think Optimize Database (Quick) is sufficient to remove unused Genres, if not use Optimize Database (Complete). The difference between Quick and Complete is explained here: http://www.ventismedia.com/mantis/view.php?id=5110
You can check the exact SQLs that are executed in the debug log, but there's not much interesting - just some consistency checks and SQLite's VACUUM.
Code: Select all
CREATE TRIGGER delete_GenresSongs DELETE ON GenresSongs BEGIN UPDATE Genres SET UsageCount=UsageCount-1 WHERE Genres.IDGenre=old.IDGenre; DELETE FROM Genres WHERE Genres.IDGenre=old.IDGenre AND Genres.UsageCount=0; END;
by elliottdp » Wed Nov 23, 2011 9:03 am
by Bex » Wed Jun 15, 2011 9:08 am
by elliottdp » Wed Jun 15, 2011 9:06 am
by Bex » Wed Jun 15, 2011 1:49 am
by elliottdp » Tue Jun 14, 2011 5:57 pm
by Mizery_Made » Tue Jun 14, 2011 1:12 pm
by Guest » Tue Jun 14, 2011 12:37 pm
[Statistics] FileName=Stats.vbs ProcName=ShowStats Order=1 DisplayName=&Statistics Description=Library Statistics Report Language=VBScript ScriptType=1 [ExportHTML] FileName=Export.vbs ProcName=ExportHTML Order=2 DisplayName=Track List (&HTML) Description=Exports selected tracks to a .htm file Language=VBScript ScriptType=1 [ExportXML] FileName=Export.vbs ProcName=ExportXML Order=3 DisplayName=Track List (&XML) Description=Exports selected tracks to an .xml file Language=VBScript ScriptType=1 [ExportCSV] FileName=Export.vbs ProcName=ExportCSV Order=4 DisplayName=Track List (CS&V) Description=Exports selected tracks to a .csv file Language=VBScript ScriptType=1 [ExportXLS] FileName=Export.vbs ProcName=ExportXLS Order=5 DisplayName=Track List (&Excel) Description=Exports selected tracks to a .xls file Language=VBScript ScriptType=1 [AutoIncTrackN] FileName=AutoIncTrackN.vbs ProcName=AutoIncTrackNumbers Order=6 DisplayName=Auto-&increment Track #s... Description=Sequentially numbers Tracks Language=VBScript ScriptType=0 [SwapArtistTitle] FileName=SwapArtistTitle.vbs ProcName=SwapArtistTitle Order=7 DisplayName=&Swap Artist and Title Description=Swaps Artist and Title fields Language=VBScript ScriptType=0 [Case] FileName=Case.vbs ProcName=TitleCase Order=8 DisplayName=Case Checker... Description=Checks for correct capitalization Language=VBScript ScriptType=0 [ExportM3Us] FileName=ExportM3Us.vbs ProcName=ExportM3Us Order=9 DisplayName=Export all Playlists... Description=Exports all Playlists to .m3u Language=VBScript ScriptType=0 [ExportOPML] FileName=ExportOPML.vbs ProcName=ExportOPML Order=10 DisplayName=Export subscribed Podcasts... Description=Exports subscribed Podcasts to .opml file Language=VBScript ScriptType=0 [CustomReport] Filename=CustomReport.vbs Procname=CustomReport Order=11 DisplayName=Custom Report Description=Custom Report Language=VBScript ScriptType=1 [CustomReportAuto] Filename=CustomReport.vbs Procname=CustomReportAuto Order=12 DisplayName=Custom Report Auto Description=Custom Report with previous options Language=VBScript ScriptType=1 [JustListArtists] Filename=JustListArtists.vbs Procname=JustListArtists Order=13 DisplayName=Just List Artists Description=Just List Artists Language=VBScript ScriptType=1 [RemoveUnused] Filename=RemoveUnused.vbs Procname=RemoveUnused Order=14 DisplayName=Remove Unused Description=Remove unused properties, genres, etc. Language=VBScript ScriptType=0
Top
Powered by phpBB® Forum Software © phpBB Limited
Theme based on Absolution by PlanetStyles