BusinessLogic.Migrations.GamingGroupsAndAspNetAuth.Up C# (CSharp) Метод

        public override void Up()
        {
            CreateTable(
                "dbo.AspNetRoles",
                c => new
                    {
                        Id = c.String(nullable: false, maxLength: 128),
                        Name = c.String(nullable: false, maxLength: 256),
                    })
                .PrimaryKey(t => t.Id)
                .Index(t => t.Name, unique: true, name: "RoleNameIndex");

            CreateTable(
                "dbo.AspNetUserRoles",
                c => new
                    {
                        UserId = c.String(nullable: false, maxLength: 128),
                        RoleId = c.String(nullable: false, maxLength: 128),
                    })
                .PrimaryKey(t => new { t.UserId, t.RoleId })
                .ForeignKey("dbo.AspNetRoles", t => t.RoleId, cascadeDelete: true)
                .ForeignKey("dbo.AspNetUsers", t => t.UserId, cascadeDelete: true)
                .Index(t => t.UserId)
                .Index(t => t.RoleId);

            CreateTable(
                "dbo.AspNetUsers",
                c => new
                    {
                        Id = c.String(nullable: false, maxLength: 128),
                        Email = c.String(maxLength: 256),
                        EmailConfirmed = c.Boolean(nullable: false),
                        PasswordHash = c.String(),
                        SecurityStamp = c.String(),
                        PhoneNumber = c.String(),
                        PhoneNumberConfirmed = c.Boolean(nullable: false),
                        TwoFactorEnabled = c.Boolean(nullable: false),
                        LockoutEndDateUtc = c.DateTime(),
                        LockoutEnabled = c.Boolean(nullable: false),
                        AccessFailedCount = c.Int(nullable: false),
                        UserName = c.String(nullable: false, maxLength: 256),
                    })
                .PrimaryKey(t => t.Id)
                .Index(t => t.UserName, unique: true, name: "UserNameIndex");

            CreateTable(
                "dbo.AspNetUserClaims",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        UserId = c.String(nullable: false, maxLength: 128),
                        ClaimType = c.String(),
                        ClaimValue = c.String(),
                    })
                .PrimaryKey(t => t.Id)
                .ForeignKey("dbo.AspNetUsers", t => t.UserId, cascadeDelete: true)
                .Index(t => t.UserId);

            CreateTable(
                "dbo.AspNetUserLogins",
                c => new
                    {
                        LoginProvider = c.String(nullable: false, maxLength: 128),
                        ProviderKey = c.String(nullable: false, maxLength: 128),
                        UserId = c.String(nullable: false, maxLength: 128),
                    })
                .PrimaryKey(t => new { t.LoginProvider, t.ProviderKey, t.UserId })
                .ForeignKey("dbo.AspNetUsers", t => t.UserId, cascadeDelete: true)
                .Index(t => t.UserId);

            CreateTable(
                "dbo.GamingGroup",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    Name = c.String()
                })
                .PrimaryKey(t => t.Id);

            //create a new GamingGroup only if there are existing users
            Sql("INSERT INTO GamingGroup (Name) SELECT 'Initial Gaming Group' FROM AspNetUsers WHERE EXISTS(SELECT TOP 1 1 FROM AspNetUsers)");

            AddColumn("dbo.Player", "GamingGroupId", c => c.Int(nullable: true));
            AddForeignKey("dbo.Player", "GamingGroupId", "dbo.GamingGroup", "Id");
            Sql("UPDATE dbo.Player SET GamingGroupID = (SELECT TOP 1 Id FROM GamingGroup)");
            AlterColumn("dbo.Player", "GamingGroupId", c => c.Int(nullable: false));

            AddColumn("dbo.GameDefinition", "GamingGroupId", c => c.Int(nullable: true));
            AddForeignKey("dbo.GameDefinition", "GamingGroupId", "dbo.GamingGroup", "Id");
            Sql("UPDATE dbo.GameDefinition SET GamingGroupID = (SELECT TOP 1 Id FROM GamingGroup)");
            AlterColumn("dbo.GameDefinition", "GamingGroupId", c => c.Int(nullable: false));

            AddColumn("dbo.PlayedGame", "GamingGroupId", c => c.Int(nullable: true));
            AddForeignKey("dbo.PlayedGame", "GamingGroupId", "dbo.GamingGroup", "Id");
            Sql("UPDATE dbo.PlayedGame SET GamingGroupID = (SELECT TOP 1 Id FROM GamingGroup)");
            AlterColumn("dbo.PlayedGame", "GamingGroupId", c => c.Int(nullable: false));
        }