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); }