what's strange is that could be fixed in about 10 minutes with a simple database trigger