[cvsnt] Re: Auditing with MySql database

[Tony Hoyle]

Andy Southby wrote:
> Edward,
> 
> I tried it and yes I get an error from the %PREFIX% in the SQL. It was I 
> while ago when I created the tables but do not remember %PREFIX% being there 
> before? Unfortunatly my SQL level is basic to say the least, so I can only 
> assume that this script is not suppose to be used standalone or needs an 
> environmental 'PREFIX to be defined to a usefull value?
> 
> As a solution though you could use the 'Create Tables' button on the 'Audit 
> Settings' dialog which works for me. (I used MySQL 5.0 and CVSNT 
> 2.5.03.2238.)

Executing the scripts directly requires you to search and replace 
%PREFIX% with any db prefix you may be using.  The normal way is just to 
use the create tables button.

Tony