private void UpgradeVersion1_1()
{
if (checkTableExist("Teams", dbconn))
{
dropTable("Teams", dbconn);
}
// Create table Teams
CDatabase.CreateTable(new DatabaseDataset.TeamsDataTable(), dbconn);
string sqlCreate;
OleDbCommand SQL;
// Create restrictions for table Teams
DatabaseDataset dbtemp = new DatabaseDataset();
foreach (System.Data.DataRelation rel in dbtemp.Relations)
{
if (rel.RelationName.IndexOf("Teams") > -1)
{
sqlCreate = "ALTER TABLE " + rel.ChildTable.TableName + " ADD " +
"CONSTRAINT " + rel.RelationName + " FOREIGN KEY " +
"(" + rel.ChildColumns[0].ColumnName + ")" +
" REFERENCES " + rel.ParentTable +
" (" + rel.ParentColumns[0].ColumnName +
")";
// Execute against database
Trace.WriteLine("CDatabase: Running SQL to create relation: " + sqlCreate);
SQL = new OleDbCommand(sqlCreate, dbconn);
SQL.ExecuteNonQuery();
SQL.Dispose();
}
}
// Create table DbInfo
CDatabase.CreateTable(new DatabaseDataset.DbInfoDataTable(), dbconn);
// Change shooter table to include "arrived" column
addColumnToTable("shooters", "Arrived", "bit null", dbconn);
addColumnToTable("shooters", "EmailResult", "bit null", dbconn);
}
