I am looking for a simple asset management solution that will organize, index and display a large library of photos in their original form (PSD) and web form (jpeg/gif) as well as flash media and possibly video. I have looked at gallery2 and some other strictly web gallery suites, but I am looking for something more specifically geared for web development (i.e. ability to link assets to clients with a record of where the assets are published).
Multiple users would be contributing to the library and more would be viewing. I have expert ColdFusion programming resources available if heavy modification of existing software is required, and intermediate PHP if minor modifications. The server environment can be either linux or Windows, but would have to be a MySQL backend (unless MS SQL Express or Developer is sufficient).
Basically I'm looking for anything that's better than plain file system organization, and hopefully something sophisticated and extendable.