public DatabaseUpdateResponse CreateCMSDatabase()
{
DatabaseUpdateResponse res = new DatabaseUpdateResponse();
if (!DatabaseUpdate.FailedSQL) {
bool bTestResult = SQLUpdateNugget.EvalNuggetKey("DoCMSTablesExist");
if (!bTestResult) {
res.LastException = ExecFileContents("Carrotware.CMS.DBUpdater.DataScripts.CREATE01.sql", false);
res.Response = "Created Database";
res.RanUpdate = true;
// change version key when the DB creation is re-scripted
SetDbSchemaVersion(DatabaseUpdate.DbVersion01);
return res;
}
res.Response = "Database Already Created";
return res;
}
res.Response = "*** Database Access Failed ***";
return res;
}