The developer for this component will be away for another couple of weeks and may not be able to assist with this issue while he is away. Unfortunately, while I am here to help out I do not know anything about SQL.
I also want to point out that at best you will only be able to use up to version 2.0.7 with Joomla 1.0. At worst you may not get any support help even after the developer returns. According to the archives in November 2009 this was posted on the front page:
Upgrade 2.0.7 to 2.1.0 Available
Wednesday, November 25th, 2009
Joomla 1.5 only. Joomla 1.0 is no longer supported.
I do not know if he meant that future releases will not support Joomla 1.0 or if he meant that he himself and the support forums will no longer support Joomla 1.0. I'm not sure.
I do know that so much has changed (and I also know that so much is also about to change with the next release) both in terms of bug fixes and also with features and user interface. I would not recommend using such an old version of Simple_Review unless you have no other choice.
Perhaps when Row gets back he will be able to help you get to version 2.0.7 - but I would consider if sticking with an older joomla version is the best thing for you and your site. I have already installed one of the Joomla 1.6 betas which are soon to become releases. My only point is that Joomla 1.0 is a few years old and Simple Review is moving in a great direction. Would hate for you to not be able to enjoy it.
But in any case, you should also post your MySQL version if you hope to get help once the developer comes back.