public override void Up()
{
CreateTable(
"dbo.GameDefinition",
c => new
{
Id = c.Int(nullable: false, identity: true),
Name = c.String(),
Description = c.String(),
})
.PrimaryKey(t => t.Id);
CreateTable(
"dbo.PlayedGame",
c => new
{
Id = c.Int(nullable: false, identity: true),
GameDefinitionId = c.Int(nullable: false),
NumberOfPlayers = c.Int(nullable: false),
})
.PrimaryKey(t => t.Id)
.ForeignKey("dbo.GameDefinition", t => t.GameDefinitionId, cascadeDelete: true)
.Index(t => t.GameDefinitionId);
CreateTable(
"dbo.PlayerGameResult",
c => new
{
Id = c.Int(nullable: false, identity: true),
PlayedGameId = c.Int(nullable: false),
PlayerId = c.Int(nullable: false),
GameRank = c.Int(nullable: false),
})
.PrimaryKey(t => t.Id)
.ForeignKey("dbo.PlayedGame", t => t.PlayedGameId, cascadeDelete: true)
.ForeignKey("dbo.Player", t => t.PlayerId, cascadeDelete: true)
.Index(t => t.PlayedGameId)
.Index(t => t.PlayerId);
CreateTable(
"dbo.Player",
c => new
{
Id = c.Int(nullable: false, identity: true),
Name = c.String(),
Active = c.Boolean(nullable: false),
})
.PrimaryKey(t => t.Id);
}