Duplicate songs tables

Post a reply


In an effort to prevent automatic submissions, we require that you complete the following challenge.
Smilies
:D :) :( :o :-? 8) :lol: :x :P :oops: :cry: :evil: :roll: :wink:

BBCode is ON
[img] is ON
[flash] is OFF
[url] is ON
Smilies are ON

Topic review
   

Expand view Topic review: Duplicate songs tables

Re: Duplicate songs tables

by Guest » Mon Sep 08, 2014 5:58 pm

I think I've fount what I was looking for. There is and index, idxSongsSignature that works on Songs.SignPart1.

Thank you!

Re: Duplicate songs tables

by Guest » Mon Sep 08, 2014 5:47 pm

Oh! Ok, thanks.
How about the Duplicate by Content? Is there a way I can search that?

Thanks!!

Re: Duplicate songs tables

by Lowlander » Mon Sep 08, 2014 5:09 pm

There is no table for that, you'd need to do some query yourself that matches fields (ie. like same Artist and same Title) to determine if files are duplicates.

You may want to check if you're not duplicating features already in the Advanced Duplicate Find & Fix Addon: http://www.mediamonkey.com/forum/viewto ... +duplicate

Duplicate songs tables

by eljuanchosf » Mon Sep 08, 2014 3:38 pm

Guys,

I'm working in developing a script (soon to be an extension) to smartly delete dups.
How can I query the database to retrieve a list of all the dup files?

Thanks!

Top