Case Sensitive File Names

[JeRoNZ]

Firstly, thanks for this code :)

I had an issue where there are two files in the same folder, File1.jpg and file1.jpg which have different mod times and checksums. The scanner constantly reports these files as changed when they are not, but only lists one of them.

This is because the table definitions are varchar(200), which is not case sensitive. Thus the details of File1.jpg overwrite file1.jpg and vice versa.

I fixed this by modifying the tables like this

ALTER TABLE `baseline` CHANGE `file_path` `file_path` VARCHAR( 200 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ;

ALTER TABLE `history` CHANGE `file_path` `file_path` VARCHAR( 200 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ;