public override void Up() { Sql(ReadSQLScriptFile.Read("15-InsertGlobalConfigurationRecordsAndRemoveAllGameConfigurationRecords.sql")); string aboutHTML = ReadSQLScriptFile.Read("AboutContent.html"); aboutHTML.Replace("'", "''"); string sqlStatement = "INSERT INTO ConfigurationG (Name, Description, DataTypeG, ConfigurationType, Value) VALUES ('InCommon-About','InCommon client about page',0,0,'" + aboutHTML.Replace("'", "''") + "')"; //read in the about html Sql(sqlStatement); //We can add the foreign key back into GameConfiguration because we have removed all its records. AddForeignKey("dbo.GameConfiguration", "ConfigurationGId", "dbo.ConfigurationG", "Id", cascadeDelete: true); }
public override void Up() { //Data Sql(ReadSQLScriptFile.Read("03-Copy-All-GamePlay-to-Game-Table.sql")); Sql(ReadSQLScriptFile.Read("06-Update-GameId-From-Player-Table-Based-On-Copied-GamePlay-Records.sql")); Sql(ReadSQLScriptFile.Read("08-Update-GameId-From-GameQuestion-Table-Based-On-Copied-GamePlay-Records.sql")); Sql(ReadSQLScriptFile.Read("081-Update-GameId-From-GameConfiguration-Table-Based-On-Copied-GamePlay-Records.sql")); Sql(ReadSQLScriptFile.Read("09-Delete-OLD-Games.sql")); Sql(ReadSQLScriptFile.Read("10-Delete-Corrupt-Player-Without-GameAnswer-Records.sql")); Sql(ReadSQLScriptFile.Read("20-InsertLMSGameType.sql")); //Programmability //Sql(ReadSQLScriptFile.Read(@"programmability\15-Drop-GetGamePlayforCode-SP.sql")); //Sql(ReadSQLScriptFile.Read(@"programmability\20-Drop-FncPlayerMatchMinMax-Fnc.sql")); //Sql(ReadSQLScriptFile.Read(@"programmability\FncPercentChosenPerChoice-ALTER-UDF.sql")); //Sql(ReadSQLScriptFile.Read(@"programmability\FncSelectedChoicesForQuestion-ALTER-UDF.sql")); //Sql(ReadSQLScriptFile.Read(@"programmability\GetGameforCode-CREATESP.sql")); //Sql(ReadSQLScriptFile.Read(@"programmability\GetGamePlayerMatchMinMax-ALTERSP.sql")); //Sql(ReadSQLScriptFile.Read(@"programmability\GetPlayerMatchDetail-ALTERSP.sql")); //Sql(ReadSQLScriptFile.Read(@"programmability\GetPlayerMatchSummary-CreateSP.sql")); //Sql(ReadSQLScriptFile.Read(@"programmability\GetPlayerTestDetail-ALTERSP.sql")); //Sql(ReadSQLScriptFile.Read(@"programmability\GetPlayerTestSummary-ALTERSP.sql")); }
public override void Up() { Sql(ReadSQLScriptFile.Read("v1.4-CleanupDescriptionsDocs.sql")); }
public override void Up() { Sql(ReadSQLScriptFile.Read("v1.4-InsertGameTypeConfigurationRecords.sql")); }
public override void Up() { Sql(ReadSQLScriptFile.Read("v1.4-InsertGroup&SetGroupInConfigurationTable.sql")); }
public override void Up() { Sql(ReadSQLScriptFile.Read("v.1.5-InsertGlobalConfiguration-InCommon-Version.sql")); }