WEP_V2.1.3/SourceCode/We.AppOnline/WeOnlineApp.EntityFramework/Migrations/202008050851223_InitCreate.cs

namespace WeOnlineApp.Migrations
{
    using System;
    using System.Collections.Generic;
    using System.Data.Entity.Infrastructure.Annotations;
    using System.Data.Entity.Migrations;
    
    public partial class InitCreate : DbMigration
    {
        public override void Up()
        {
            CreateTable(
                "dbo.Train_CampInfos",
                c => new
                    {
                        Id = c.String(nullable: false, maxLength: 128),
                        Name = c.String(maxLength: 50),
                        PackageNo = c.String(maxLength: 20),
                        PackageName = c.String(maxLength: 50),
                        Organizer = c.String(maxLength: 100),
                        ContactInfo = c.String(maxLength: 50),
                        CampState = c.Int(nullable: false),
                        Purposes = c.String(maxLength: 500),
                        AssessRoleNames = c.String(maxLength: 500),
                        RoundScore = c.Decimal(nullable: false, precision: 18, scale: 2),
                        Variable = c.String(maxLength: 1000),
                        StartDate = c.DateTime(),
                        EndDate = c.DateTime(),
                        MaxTrainingMinute = c.Decimal(nullable: false, precision: 18, scale: 2),
                        Description = c.String(maxLength: 500),
                        EvalBehaviorTags = c.String(maxLength: 500),
                        StudyContent = c.String(),
                        SubjectType = c.String(maxLength: 128),
                        SubjectPoint = c.Int(nullable: false),
                        Remark = c.String(maxLength: 500),
                        IsDeleted = c.Boolean(nullable: false),
                        DeleterUserId = c.Long(),
                        DeletionTime = c.DateTime(),
                        LastModificationTime = c.DateTime(),
                        LastModifierUserId = c.Long(),
                        CreationTime = c.DateTime(nullable: false),
                        CreatorUserId = c.Long(),
                    },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_CampInfo_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id)
                .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
                .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
                .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
                .ForeignKey("dbo.Base_SubjectCategories", t => t.SubjectType)
                .Index(t => t.SubjectType)
                .Index(t => t.IsDeleted)
                .Index(t => t.DeleterUserId)
                .Index(t => t.LastModifierUserId)
                .Index(t => t.CreatorUserId);
            
            CreateTable(
                "dbo.Sys_Users",
                c => new
                    {
                        Id = c.Long(nullable: false, identity: true),
                        NormalizedUserName = c.String(nullable: false, maxLength: 256),
                        NormalizedEmailAddress = c.String(nullable: false, maxLength: 256),
                        ConcurrencyStamp = c.String(maxLength: 128),
                        AuthenticationSource = c.String(maxLength: 64),
                        UserName = c.String(nullable: false, maxLength: 256),
                        UserType = c.Int(nullable: false),
                        AccountType = c.Int(),
                        AccountNo = c.String(maxLength: 100),
                        ImagePath = c.String(maxLength: 1000),
                        TenantId = c.Int(),
                        EmailAddress = c.String(nullable: false, maxLength: 256),
                        Name = c.String(nullable: false, maxLength: 64),
                        Surname = c.String(maxLength: 64),
                        AvatarImagePath = c.String(maxLength: 500),
                        Password = c.String(nullable: false, maxLength: 128),
                        EmailConfirmationCode = c.String(maxLength: 328),
                        PasswordResetCode = c.String(maxLength: 328),
                        LockoutEndDateUtc = c.DateTime(),
                        AccessFailedCount = c.Int(nullable: false),
                        IsLockoutEnabled = c.Boolean(nullable: false),
                        PhoneNumber = c.String(maxLength: 32),
                        IsPhoneNumberConfirmed = c.Boolean(nullable: false),
                        SecurityStamp = c.String(maxLength: 128),
                        IsTwoFactorEnabled = c.Boolean(nullable: false),
                        IsEmailConfirmed = c.Boolean(nullable: false),
                        IsActive = c.Boolean(nullable: false),
                        IsDeleted = c.Boolean(nullable: false),
                        DeleterUserId = c.Long(),
                        DeletionTime = c.DateTime(),
                        LastModificationTime = c.DateTime(),
                        LastModifierUserId = c.Long(),
                        CreationTime = c.DateTime(nullable: false),
                        CreatorUserId = c.Long(),
                    },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_User_MayHaveTenant", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                    { "DynamicFilter_User_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id)
                .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
                .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
                .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
                .Index(t => t.UserName)
                .Index(t => t.UserType)
                .Index(t => t.AccountType)
                .Index(t => t.TenantId)
                .Index(t => t.EmailAddress)
                .Index(t => t.PhoneNumber)
                .Index(t => t.IsDeleted)
                .Index(t => t.DeleterUserId)
                .Index(t => t.LastModifierUserId)
                .Index(t => t.CreatorUserId);
            
            CreateTable(
                "dbo.Sys_UserClaims",
                c => new
                    {
                        Id = c.Long(nullable: false, identity: true),
                        TenantId = c.Int(),
                        UserId = c.Long(nullable: false),
                        ClaimType = c.String(maxLength: 256),
                        ClaimValue = c.String(),
                        CreationTime = c.DateTime(nullable: false),
                        CreatorUserId = c.Long(),
                    },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_UserClaim_MayHaveTenant", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id)
                .ForeignKey("dbo.Sys_Users", t => t.UserId)
                .Index(t => t.TenantId)
                .Index(t => t.UserId);
            
            CreateTable(
                "dbo.Sys_UserLogins",
                c => new
                    {
                        Id = c.Long(nullable: false, identity: true),
                        TenantId = c.Int(),
                        UserId = c.Long(nullable: false),
                        LoginProvider = c.String(nullable: false, maxLength: 128),
                        ProviderKey = c.String(nullable: false, maxLength: 256),
                    },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_UserLogin_MayHaveTenant", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id)
                .ForeignKey("dbo.Sys_Users", t => t.UserId)
                .Index(t => t.TenantId)
                .Index(t => t.UserId);
            
            CreateTable(
                "dbo.Sys_UserRoles",
                c => new
                    {
                        Id = c.Long(nullable: false, identity: true),
                        TenantId = c.Int(),
                        UserId = c.Long(nullable: false),
                        RoleId = c.Int(nullable: false),
                        CreationTime = c.DateTime(nullable: false),
                        CreatorUserId = c.Long(),
                    },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_UserRole_MayHaveTenant", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id)
                .ForeignKey("dbo.Sys_Users", t => t.UserId)
                .Index(t => t.TenantId)
                .Index(t => t.UserId);
            
            CreateTable(
                "dbo.Sys_Settings",
                c => new
                    {
                        Id = c.Long(nullable: false, identity: true),
                        TenantId = c.Int(),
                        UserId = c.Long(),
                        Name = c.String(nullable: false, maxLength: 256),
                        Value = c.String(),
                        DisplayName = c.String(maxLength: 50),
                        Type = c.Int(),
                        Description = c.String(maxLength: 500),
                        Remark = c.String(maxLength: 500),
                        LastModificationTime = c.DateTime(),
                        LastModifierUserId = c.Long(),
                        CreationTime = c.DateTime(nullable: false),
                        CreatorUserId = c.Long(),
                    },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_SysSetting_MayHaveTenant", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id)
                .ForeignKey("dbo.Sys_Users", t => t.UserId)
                .Index(t => new { t.TenantId, t.Name, t.UserId }, unique: true);
            
            CreateTable(
                "dbo.Base_SubjectCategories",
                c => new
                    {
                        Id = c.String(nullable: false, maxLength: 128),
                        ParentNo = c.String(maxLength: 128),
                        CategoryName = c.String(maxLength: 50),
                        CategoryPath = c.String(maxLength: 500),
                        Sort = c.Int(nullable: false),
                        Description = c.String(maxLength: 500),
                        Remark = c.String(maxLength: 500),
                        LastModificationTime = c.DateTime(),
                        LastModifierUserId = c.Long(),
                        CreationTime = c.DateTime(nullable: false),
                        CreatorUserId = c.Long(),
                    })
                .PrimaryKey(t => t.Id)
                .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
                .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
                .ForeignKey("dbo.Base_SubjectCategories", t => t.ParentNo)
                .Index(t => t.ParentNo)
                .Index(t => t.LastModifierUserId)
                .Index(t => t.CreatorUserId);
            
            CreateTable(
                "dbo.Train_CampPlayInfos",
                c => new
                    {
                        Id = c.String(nullable: false, maxLength: 128),
                        Name = c.String(maxLength: 50),
                        CampNo = c.String(maxLength: 128),
                        PlayModel = c.Int(nullable: false),
                        IsPublic = c.Boolean(nullable: false),
                        InvitationCode = c.String(),
                        PlayRoleNames = c.String(maxLength: 500),
                        PlayState = c.Int(nullable: false),
                        RoundIndex = c.Int(nullable: false),
                        StartDate = c.DateTime(),
                        EndDate = c.DateTime(),
                        TrainingMinute = c.Decimal(nullable: false, precision: 18, scale: 2),
                        RunningInfo = c.String(),
                        Remark = c.String(maxLength: 500),
                        CreationTime = c.DateTime(nullable: false),
                        CreatorUserId = c.Long(),
                    })
                .PrimaryKey(t => t.Id)
                .ForeignKey("dbo.Train_CampInfos", t => t.CampNo)
                .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
                .Index(t => t.CampNo)
                .Index(t => t.CreatorUserId);
            
            CreateTable(
                "dbo.Train_CampPlayLogs",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        CampNo = c.String(maxLength: 128),
                        PlayNo = c.String(maxLength: 128),
                        UserName = c.String(),
                        RoundIndex = c.Int(nullable: false),
                        LogType = c.Int(nullable: false),
                        ScenePath = c.String(maxLength: 100),
                        LogCommand = c.String(maxLength: 30),
                        LogMessage = c.String(maxLength: 500),
                        RoleName = c.String(maxLength: 50),
                        LogState = c.Int(nullable: false),
                        LogScore = c.Decimal(nullable: false, precision: 18, scale: 2),
                        ParentNo = c.String(maxLength: 128),
                        UserId = c.Long(nullable: false),
                        CreationTime = c.DateTime(nullable: false),
                        CreatorUserId = c.Long(),
                    })
                .PrimaryKey(t => t.Id)
                .ForeignKey("dbo.Train_CampPlayInfos", t => t.PlayNo)
                .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
                .Index(t => t.CampNo)
                .Index(t => t.PlayNo)
                .Index(t => t.CreatorUserId);
            
            CreateTable(
                "dbo.Train_CampPlayScores",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        CampNo = c.String(maxLength: 128),
                        PlayNo = c.String(maxLength: 128),
                        RoundIndex = c.Int(nullable: false),
                        SystemScore = c.Decimal(nullable: false, precision: 18, scale: 2),
                        BehaviorTagScoreInfo = c.String(),
                        CreationTime = c.DateTime(nullable: false),
                        CreatorUserId = c.Long(),
                    })
                .PrimaryKey(t => t.Id)
                .ForeignKey("dbo.Train_CampPlayInfos", t => t.PlayNo)
                .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
                .Index(t => t.CampNo)
                .Index(t => t.PlayNo)
                .Index(t => t.CreatorUserId);
            
            CreateTable(
                "dbo.Train_CampPlayUsers",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        CampNo = c.String(maxLength: 128),
                        PlayNo = c.String(maxLength: 128),
                        PlayUserId = c.Long(nullable: false),
                        PlayerType = c.Int(nullable: false),
                        PlayerState = c.Int(nullable: false),
                        Role = c.String(maxLength: 50),
                        CreationTime = c.DateTime(nullable: false),
                        CreatorUserId = c.Long(),
                    })
                .PrimaryKey(t => t.Id)
                .ForeignKey("dbo.Train_CampPlayInfos", t => t.PlayNo)
                .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
                .ForeignKey("dbo.Sys_Users", t => t.PlayUserId)
                .Index(t => t.CampNo)
                .Index(t => t.PlayNo)
                .Index(t => t.PlayUserId)
                .Index(t => t.CreatorUserId);
            
            CreateTable(
                "dbo.Train_CampSceneMaps",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        SceneNo = c.String(),
                        SceneName = c.String(),
                        AttachNos = c.String(),
                        CampNo = c.String(maxLength: 128),
                        CreationTime = c.DateTime(nullable: false),
                        CreatorUserId = c.Long(),
                    })
                .PrimaryKey(t => t.Id)
                .ForeignKey("dbo.Train_CampInfos", t => t.CampNo)
                .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
                .Index(t => t.CampNo)
                .Index(t => t.CreatorUserId);
            
            CreateTable(
                "dbo.Sys_Permissions",
                c => new
                    {
                        Id = c.Long(nullable: false, identity: true),
                        TenantId = c.Int(),
                        Name = c.String(nullable: false, maxLength: 500),
                        Master = c.Int(),
                        MasterValue = c.String(maxLength: 100),
                        Access = c.Int(),
                        AccessValue = c.String(maxLength: 500),
                        IsGranted = c.Boolean(nullable: false),
                        CreationTime = c.DateTime(nullable: false),
                        CreatorUserId = c.Long(),
                        UserId = c.Long(),
                        Discriminator = c.String(nullable: false, maxLength: 128),
                    },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_DataPermission_MayHaveTenant", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                    { "DynamicFilter_PermissionSetting_MayHaveTenant", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                    { "DynamicFilter_RolePermissionSetting_MayHaveTenant", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                    { "DynamicFilter_UserPermissionSetting_MayHaveTenant", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id)
                .Index(t => t.TenantId);
            
            CreateTable(
                "dbo.Sys_Notifications",
                c => new
                    {
                        Id = c.Guid(nullable: false),
                        NotificationName = c.String(nullable: false, maxLength: 96),
                        Data = c.String(),
                        DataTypeName = c.String(maxLength: 512),
                        EntityTypeName = c.String(maxLength: 250),
                        EntityTypeAssemblyQualifiedName = c.String(maxLength: 512),
                        EntityId = c.String(maxLength: 96),
                        Severity = c.Byte(nullable: false),
                        UserIds = c.String(),
                        ExcludedUserIds = c.String(),
                        TenantIds = c.String(),
                        CreationTime = c.DateTime(nullable: false),
                        CreatorUserId = c.Long(),
                    })
                .PrimaryKey(t => t.Id);
            
            CreateTable(
                "dbo.Sys_NotificationSubscriptions",
                c => new
                    {
                        Id = c.Guid(nullable: false),
                        TenantId = c.Int(),
                        UserId = c.Long(nullable: false),
                        NotificationName = c.String(maxLength: 96),
                        EntityTypeName = c.String(maxLength: 250),
                        EntityTypeAssemblyQualifiedName = c.String(maxLength: 512),
                        EntityId = c.String(maxLength: 96),
                        CreationTime = c.DateTime(nullable: false),
                        CreatorUserId = c.Long(),
                    },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_NotificationSubscriptionInfo_MayHaveTenant", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id)
                .Index(t => t.TenantId)
                .Index(t => new { t.NotificationName, t.EntityTypeName, t.EntityId, t.UserId });
            
            CreateTable(
                "dbo.Train_QuestionAnswerInfos",
                c => new
                    {
                        Id = c.String(nullable: false, maxLength: 128),
                        AnswerNo = c.String(maxLength: 128),
                        QuestionNo = c.String(maxLength: 128),
                        AnswerState = c.Int(nullable: false),
                        ContentInfo = c.String(maxLength: 1000),
                        Remark = c.String(maxLength: 500),
                        LastModificationTime = c.DateTime(),
                        LastModifierUserId = c.Long(),
                        CreationTime = c.DateTime(nullable: false),
                        CreatorUserId = c.Long(),
                    })
                .PrimaryKey(t => t.Id)
                .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
                .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
                .ForeignKey("dbo.Train_QuestionAnswerInfos", t => t.AnswerNo)
                .ForeignKey("dbo.Train_QuestionInfos", t => t.QuestionNo)
                .Index(t => t.AnswerNo)
                .Index(t => t.QuestionNo)
                .Index(t => t.LastModifierUserId)
                .Index(t => t.CreatorUserId);
            
            CreateTable(
                "dbo.Train_QuestionInfos",
                c => new
                    {
                        Id = c.String(nullable: false, maxLength: 128),
                        SubjectCategoryNo = c.String(maxLength: 128),
                        CampNo = c.String(maxLength: 128),
                        Title = c.String(maxLength: 500),
                        ContentInfo = c.String(maxLength: 1000),
                        QuestionState = c.Int(nullable: false),
                        AnswerDateTime = c.DateTime(),
                        AnswerNo = c.String(),
                        IsFavorite = c.Boolean(nullable: false),
                        Remark = c.String(maxLength: 500),
                        IsDeleted = c.Boolean(nullable: false),
                        DeleterUserId = c.Long(),
                        DeletionTime = c.DateTime(),
                        LastModificationTime = c.DateTime(),
                        LastModifierUserId = c.Long(),
                        CreationTime = c.DateTime(nullable: false),
                        CreatorUserId = c.Long(),
                    },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_QuestionInfo_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id)
                .ForeignKey("dbo.Train_CampInfos", t => t.CampNo)
                .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
                .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
                .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
                .ForeignKey("dbo.Base_SubjectCategories", t => t.SubjectCategoryNo)
                .Index(t => t.SubjectCategoryNo)
                .Index(t => t.CampNo)
                .Index(t => t.IsDeleted)
                .Index(t => t.DeleterUserId)
                .Index(t => t.LastModifierUserId)
                .Index(t => t.CreatorUserId);
            
            CreateTable(
                "dbo.Sys_Roles",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        Description = c.String(),
                        NormalizedName = c.String(nullable: false, maxLength: 32),
                        ConcurrencyStamp = c.String(maxLength: 128),
                        TenantId = c.Int(),
                        Name = c.String(nullable: false, maxLength: 32),
                        RoleType = c.Int(nullable: false),
                        AccountType = c.Int(),
                        DisplayName = c.String(nullable: false, maxLength: 64),
                        IsStatic = c.Boolean(nullable: false),
                        IsDefault = c.Boolean(nullable: false),
                        IsDeleted = c.Boolean(nullable: false),
                        DeleterUserId = c.Long(),
                        DeletionTime = c.DateTime(),
                        LastModificationTime = c.DateTime(),
                        LastModifierUserId = c.Long(),
                        CreationTime = c.DateTime(nullable: false),
                        CreatorUserId = c.Long(),
                    },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_Role_MayHaveTenant", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                    { "DynamicFilter_Role_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id)
                .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
                .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
                .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
                .Index(t => t.TenantId)
                .Index(t => t.Name)
                .Index(t => t.RoleType)
                .Index(t => t.AccountType)
                .Index(t => t.IsDeleted)
                .Index(t => t.DeleterUserId)
                .Index(t => t.LastModifierUserId)
                .Index(t => t.CreatorUserId);
            
            CreateTable(
                "dbo.Sys_RoleClaims",
                c => new
                    {
                        Id = c.Long(nullable: false, identity: true),
                        TenantId = c.Int(),
                        RoleId = c.Int(nullable: false),
                        ClaimType = c.String(maxLength: 256),
                        ClaimValue = c.String(),
                        CreationTime = c.DateTime(nullable: false),
                        CreatorUserId = c.Long(),
                    },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_RoleClaim_MayHaveTenant", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id)
                .ForeignKey("dbo.Sys_Roles", t => t.RoleId)
                .Index(t => t.TenantId)
                .Index(t => t.RoleId);
            
            CreateTable(
                "dbo.Sys_AppGuids",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        Step = c.Short(nullable: false),
                        LastId = c.Int(nullable: false),
                        IdType = c.Short(nullable: false),
                        LastUseDate = c.DateTime(),
                    })
                .PrimaryKey(t => t.Id)
                .Index(t => t.IdType);
            
            CreateTable(
                "dbo.Sys_AttachFiles",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        AttachNo = c.String(maxLength: 32),
                        TableName = c.String(maxLength: 50),
                        ColumnName = c.String(maxLength: 50),
                        SourceKey = c.String(maxLength: 50),
                        FileTitle = c.String(maxLength: 50),
                        FileName = c.String(maxLength: 50),
                        FilePath = c.String(maxLength: 500),
                        FileType = c.String(maxLength: 20),
                        FileExt = c.String(maxLength: 10),
                        Description = c.String(maxLength: 500),
                        TenantId = c.Int(nullable: false),
                        IsDeleted = c.Boolean(nullable: false),
                        DeleterUserId = c.Long(),
                        DeletionTime = c.DateTime(),
                        LastModificationTime = c.DateTime(),
                        LastModifierUserId = c.Long(),
                        CreationTime = c.DateTime(nullable: false),
                        CreatorUserId = c.Long(),
                    },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_SysAttachFile_MustHaveTenant", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                    { "DynamicFilter_SysAttachFile_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id)
                .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
                .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
                .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
                .Index(t => t.TenantId)
                .Index(t => t.IsDeleted)
                .Index(t => t.DeleterUserId)
                .Index(t => t.LastModifierUserId)
                .Index(t => t.CreatorUserId);
            
            CreateTable(
                "dbo.Sys_Functions",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        FunctionNo = c.String(maxLength: 100),
                        ParentNo = c.String(maxLength: 100),
                        FunctionName = c.String(maxLength: 100),
                        PermissionName = c.String(maxLength: 500),
                        FunctionType = c.Int(nullable: false),
                        Action = c.String(maxLength: 50),
                        Controller = c.String(maxLength: 50),
                        Url = c.String(),
                        Icon = c.String(maxLength: 50),
                        Class = c.String(maxLength: 100),
                        Script = c.String(),
                        NeedAuth = c.Boolean(nullable: false),
                        Sort = c.Int(nullable: false),
                        Depth = c.Int(nullable: false),
                        IsLeaf = c.Boolean(),
                        IsDeleted = c.Boolean(nullable: false),
                        DeleterUserId = c.Long(),
                        DeletionTime = c.DateTime(),
                        LastModificationTime = c.DateTime(),
                        LastModifierUserId = c.Long(),
                        CreationTime = c.DateTime(nullable: false),
                        CreatorUserId = c.Long(),
                    },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_SysFunction_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id)
                .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
                .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
                .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
                .Index(t => t.FunctionNo)
                .Index(t => t.PermissionName, unique: true)
                .Index(t => t.IsDeleted)
                .Index(t => t.DeleterUserId)
                .Index(t => t.LastModifierUserId)
                .Index(t => t.CreatorUserId);
            
            CreateTable(
                "dbo.Sys_SysHelps",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        Classification = c.String(maxLength: 40),
                        HelpTitle = c.String(nullable: false, maxLength: 50),
                        HelpKeyWords = c.String(maxLength: 50),
                        HelpContent = c.String(),
                        FunctionNo = c.String(maxLength: 100),
                        PermissionName = c.String(maxLength: 500),
                        Sequence = c.Int(nullable: false),
                        Description = c.String(),
                        Remark = c.String(maxLength: 1000),
                        IsDeleted = c.Boolean(nullable: false),
                        DeleterUserId = c.Long(),
                        DeletionTime = c.DateTime(),
                        LastModificationTime = c.DateTime(),
                        LastModifierUserId = c.Long(),
                        CreationTime = c.DateTime(nullable: false),
                        CreatorUserId = c.Long(),
                    },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_SysHelp_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id)
                .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
                .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
                .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
                .Index(t => t.IsDeleted)
                .Index(t => t.DeleterUserId)
                .Index(t => t.LastModifierUserId)
                .Index(t => t.CreatorUserId);
            
            CreateTable(
                "dbo.Sys_AuditLogs",
                c => new
                    {
                        Id = c.Long(nullable: false, identity: true),
                        TenantId = c.Int(nullable: false),
                        UserId = c.Long(),
                        UserName = c.String(),
                        ServiceName = c.String(maxLength: 256),
                        ServiceNameLang = c.String(),
                        MethodName = c.String(maxLength: 256),
                        MethodNameLang = c.String(),
                        Parameters = c.String(maxLength: 1024),
                        ExecutionTime = c.DateTime(nullable: false),
                        ExecutionDuration = c.Int(nullable: false),
                        ClientIpAddress = c.String(maxLength: 64),
                        ClientName = c.String(maxLength: 128),
                        BrowserInfo = c.String(maxLength: 512),
                        Exception = c.String(maxLength: 2000),
                        ImpersonatorUserId = c.Long(),
                        ImpersonatorTenantId = c.Int(),
                        CustomData = c.String(maxLength: 2000),
                        LogType = c.Int(nullable: false),
                    },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_SysLog_MustHaveTenant", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id)
                .Index(t => t.TenantId)
                .Index(t => t.UserId);
            
            CreateTable(
                "dbo.Sys_States",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        StateNo = c.String(maxLength: 32),
                        StateName = c.String(maxLength: 50),
                        TableName = c.String(nullable: false, maxLength: 50),
                        ColumnName = c.String(nullable: false, maxLength: 50),
                        CodeValue = c.String(nullable: false, maxLength: 100),
                        DisplayValue = c.String(nullable: false, maxLength: 100),
                        IsDeleted = c.Boolean(nullable: false),
                        DeleterUserId = c.Long(),
                        DeletionTime = c.DateTime(),
                        LastModificationTime = c.DateTime(),
                        LastModifierUserId = c.Long(),
                        CreationTime = c.DateTime(nullable: false),
                        CreatorUserId = c.Long(),
                    },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_SysState_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id)
                .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
                .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
                .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
                .Index(t => t.IsDeleted)
                .Index(t => t.DeleterUserId)
                .Index(t => t.LastModifierUserId)
                .Index(t => t.CreatorUserId);
            
            CreateTable(
                "dbo.Sys_NotificationTenants",
                c => new
                    {
                        Id = c.Guid(nullable: false),
                        TenantId = c.Int(),
                        NotificationName = c.String(nullable: false, maxLength: 96),
                        Data = c.String(),
                        DataTypeName = c.String(maxLength: 512),
                        EntityTypeName = c.String(maxLength: 250),
                        EntityTypeAssemblyQualifiedName = c.String(maxLength: 512),
                        EntityId = c.String(maxLength: 96),
                        Severity = c.Byte(nullable: false),
                        CreationTime = c.DateTime(nullable: false),
                        CreatorUserId = c.Long(),
                    },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_TenantNotificationInfo_MayHaveTenant", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id)
                .Index(t => t.TenantId);
            
            CreateTable(
                "dbo.Sys_Tenants",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        TenancyName = c.String(nullable: false, maxLength: 64),
                        Name = c.String(nullable: false, maxLength: 128),
                        ConnectionString = c.String(maxLength: 1024),
                        IsActive = c.Boolean(nullable: false),
                        IsDeleted = c.Boolean(nullable: false),
                        DeleterUserId = c.Long(),
                        DeletionTime = c.DateTime(),
                        LastModificationTime = c.DateTime(),
                        LastModifierUserId = c.Long(),
                        CreationTime = c.DateTime(nullable: false),
                        CreatorUserId = c.Long(),
                    },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_Tenant_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id)
                .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
                .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
                .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
                .Index(t => t.IsDeleted)
                .Index(t => t.DeleterUserId)
                .Index(t => t.LastModifierUserId)
                .Index(t => t.CreatorUserId);
            
            CreateTable(
                "dbo.Sys_UserAccounts",
                c => new
                    {
                        Id = c.Long(nullable: false, identity: true),
                        TenantId = c.Int(),
                        UserId = c.Long(nullable: false),
                        UserLinkId = c.Long(),
                        UserName = c.String(maxLength: 256),
                        EmailAddress = c.String(maxLength: 256),
                        IsDeleted = c.Boolean(nullable: false),
                        DeleterUserId = c.Long(),
                        DeletionTime = c.DateTime(),
                        LastModificationTime = c.DateTime(),
                        LastModifierUserId = c.Long(),
                        CreationTime = c.DateTime(nullable: false),
                        CreatorUserId = c.Long(),
                    },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_UserAccount_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id)
                .Index(t => t.IsDeleted);
            
            CreateTable(
                "dbo.Sys_UserLoginAttempts",
                c => new
                    {
                        Id = c.Long(nullable: false, identity: true),
                        TenantId = c.Int(),
                        TenancyName = c.String(maxLength: 64),
                        UserId = c.Long(),
                        UserNameOrEmailAddress = c.String(maxLength: 255),
                        ClientIpAddress = c.String(maxLength: 64),
                        ClientName = c.String(maxLength: 128),
                        BrowserInfo = c.String(maxLength: 512),
                        Result = c.Byte(nullable: false),
                        CreationTime = c.DateTime(nullable: false),
                    },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_UserLoginAttempt_MayHaveTenant", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id)
                .Index(t => t.TenantId)
                .Index(t => new { t.UserId, t.TenantId })
                .Index(t => new { t.TenancyName, t.UserNameOrEmailAddress, t.Result });
            
            CreateTable(
                "dbo.Sys_NotificationUsers",
                c => new
                    {
                        Id = c.Guid(nullable: false),
                        TenantId = c.Int(),
                        UserId = c.Long(nullable: false),
                        TenantNotificationId = c.Guid(nullable: false),
                        State = c.Int(nullable: false),
                        CreationTime = c.DateTime(nullable: false),
                    },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_UserNotificationInfo_MayHaveTenant", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id)
                .Index(t => t.TenantId)
                .Index(t => new { t.UserId, t.State, t.CreationTime });
            
        }
        
        public override void Down()
        {
            DropForeignKey("dbo.Sys_Tenants", "LastModifierUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Sys_Tenants", "DeleterUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Sys_Tenants", "CreatorUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Sys_States", "LastModifierUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Sys_States", "DeleterUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Sys_States", "CreatorUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Sys_SysHelps", "LastModifierUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Sys_SysHelps", "DeleterUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Sys_SysHelps", "CreatorUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Sys_Functions", "LastModifierUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Sys_Functions", "DeleterUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Sys_Functions", "CreatorUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Sys_AttachFiles", "LastModifierUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Sys_AttachFiles", "DeleterUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Sys_AttachFiles", "CreatorUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Sys_Roles", "LastModifierUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Sys_Roles", "DeleterUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Sys_Roles", "CreatorUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Sys_RoleClaims", "RoleId", "dbo.Sys_Roles");
            DropForeignKey("dbo.Train_QuestionInfos", "SubjectCategoryNo", "dbo.Base_SubjectCategories");
            DropForeignKey("dbo.Train_QuestionInfos", "LastModifierUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Train_QuestionInfos", "DeleterUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Train_QuestionInfos", "CreatorUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Train_QuestionInfos", "CampNo", "dbo.Train_CampInfos");
            DropForeignKey("dbo.Train_QuestionAnswerInfos", "QuestionNo", "dbo.Train_QuestionInfos");
            DropForeignKey("dbo.Train_QuestionAnswerInfos", "AnswerNo", "dbo.Train_QuestionAnswerInfos");
            DropForeignKey("dbo.Train_QuestionAnswerInfos", "LastModifierUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Train_QuestionAnswerInfos", "CreatorUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Train_CampSceneMaps", "CreatorUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Train_CampSceneMaps", "CampNo", "dbo.Train_CampInfos");
            DropForeignKey("dbo.Train_CampPlayUsers", "PlayUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Train_CampPlayUsers", "CreatorUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Train_CampPlayUsers", "PlayNo", "dbo.Train_CampPlayInfos");
            DropForeignKey("dbo.Train_CampPlayScores", "CreatorUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Train_CampPlayScores", "PlayNo", "dbo.Train_CampPlayInfos");
            DropForeignKey("dbo.Train_CampPlayLogs", "CreatorUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Train_CampPlayLogs", "PlayNo", "dbo.Train_CampPlayInfos");
            DropForeignKey("dbo.Train_CampPlayInfos", "CreatorUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Train_CampPlayInfos", "CampNo", "dbo.Train_CampInfos");
            DropForeignKey("dbo.Train_CampInfos", "SubjectType", "dbo.Base_SubjectCategories");
            DropForeignKey("dbo.Base_SubjectCategories", "ParentNo", "dbo.Base_SubjectCategories");
            DropForeignKey("dbo.Base_SubjectCategories", "LastModifierUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Base_SubjectCategories", "CreatorUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Train_CampInfos", "LastModifierUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Train_CampInfos", "DeleterUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Train_CampInfos", "CreatorUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Sys_Settings", "UserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Sys_UserRoles", "UserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Sys_UserLogins", "UserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Sys_Users", "LastModifierUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Sys_Users", "DeleterUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Sys_Users", "CreatorUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Sys_UserClaims", "UserId", "dbo.Sys_Users");
            DropIndex("dbo.Sys_NotificationUsers", new[] { "UserId", "State", "CreationTime" });
            DropIndex("dbo.Sys_NotificationUsers", new[] { "TenantId" });
            DropIndex("dbo.Sys_UserLoginAttempts", new[] { "TenancyName", "UserNameOrEmailAddress", "Result" });
            DropIndex("dbo.Sys_UserLoginAttempts", new[] { "UserId", "TenantId" });
            DropIndex("dbo.Sys_UserLoginAttempts", new[] { "TenantId" });
            DropIndex("dbo.Sys_UserAccounts", new[] { "IsDeleted" });
            DropIndex("dbo.Sys_Tenants", new[] { "CreatorUserId" });
            DropIndex("dbo.Sys_Tenants", new[] { "LastModifierUserId" });
            DropIndex("dbo.Sys_Tenants", new[] { "DeleterUserId" });
            DropIndex("dbo.Sys_Tenants", new[] { "IsDeleted" });
            DropIndex("dbo.Sys_NotificationTenants", new[] { "TenantId" });
            DropIndex("dbo.Sys_States", new[] { "CreatorUserId" });
            DropIndex("dbo.Sys_States", new[] { "LastModifierUserId" });
            DropIndex("dbo.Sys_States", new[] { "DeleterUserId" });
            DropIndex("dbo.Sys_States", new[] { "IsDeleted" });
            DropIndex("dbo.Sys_AuditLogs", new[] { "UserId" });
            DropIndex("dbo.Sys_AuditLogs", new[] { "TenantId" });
            DropIndex("dbo.Sys_SysHelps", new[] { "CreatorUserId" });
            DropIndex("dbo.Sys_SysHelps", new[] { "LastModifierUserId" });
            DropIndex("dbo.Sys_SysHelps", new[] { "DeleterUserId" });
            DropIndex("dbo.Sys_SysHelps", new[] { "IsDeleted" });
            DropIndex("dbo.Sys_Functions", new[] { "CreatorUserId" });
            DropIndex("dbo.Sys_Functions", new[] { "LastModifierUserId" });
            DropIndex("dbo.Sys_Functions", new[] { "DeleterUserId" });
            DropIndex("dbo.Sys_Functions", new[] { "IsDeleted" });
            DropIndex("dbo.Sys_Functions", new[] { "PermissionName" });
            DropIndex("dbo.Sys_Functions", new[] { "FunctionNo" });
            DropIndex("dbo.Sys_AttachFiles", new[] { "CreatorUserId" });
            DropIndex("dbo.Sys_AttachFiles", new[] { "LastModifierUserId" });
            DropIndex("dbo.Sys_AttachFiles", new[] { "DeleterUserId" });
            DropIndex("dbo.Sys_AttachFiles", new[] { "IsDeleted" });
            DropIndex("dbo.Sys_AttachFiles", new[] { "TenantId" });
            DropIndex("dbo.Sys_AppGuids", new[] { "IdType" });
            DropIndex("dbo.Sys_RoleClaims", new[] { "RoleId" });
            DropIndex("dbo.Sys_RoleClaims", new[] { "TenantId" });
            DropIndex("dbo.Sys_Roles", new[] { "CreatorUserId" });
            DropIndex("dbo.Sys_Roles", new[] { "LastModifierUserId" });
            DropIndex("dbo.Sys_Roles", new[] { "DeleterUserId" });
            DropIndex("dbo.Sys_Roles", new[] { "IsDeleted" });
            DropIndex("dbo.Sys_Roles", new[] { "AccountType" });
            DropIndex("dbo.Sys_Roles", new[] { "RoleType" });
            DropIndex("dbo.Sys_Roles", new[] { "Name" });
            DropIndex("dbo.Sys_Roles", new[] { "TenantId" });
            DropIndex("dbo.Train_QuestionInfos", new[] { "CreatorUserId" });
            DropIndex("dbo.Train_QuestionInfos", new[] { "LastModifierUserId" });
            DropIndex("dbo.Train_QuestionInfos", new[] { "DeleterUserId" });
            DropIndex("dbo.Train_QuestionInfos", new[] { "IsDeleted" });
            DropIndex("dbo.Train_QuestionInfos", new[] { "CampNo" });
            DropIndex("dbo.Train_QuestionInfos", new[] { "SubjectCategoryNo" });
            DropIndex("dbo.Train_QuestionAnswerInfos", new[] { "CreatorUserId" });
            DropIndex("dbo.Train_QuestionAnswerInfos", new[] { "LastModifierUserId" });
            DropIndex("dbo.Train_QuestionAnswerInfos", new[] { "QuestionNo" });
            DropIndex("dbo.Train_QuestionAnswerInfos", new[] { "AnswerNo" });
            DropIndex("dbo.Sys_NotificationSubscriptions", new[] { "NotificationName", "EntityTypeName", "EntityId", "UserId" });
            DropIndex("dbo.Sys_NotificationSubscriptions", new[] { "TenantId" });
            DropIndex("dbo.Sys_Permissions", new[] { "TenantId" });
            DropIndex("dbo.Train_CampSceneMaps", new[] { "CreatorUserId" });
            DropIndex("dbo.Train_CampSceneMaps", new[] { "CampNo" });
            DropIndex("dbo.Train_CampPlayUsers", new[] { "CreatorUserId" });
            DropIndex("dbo.Train_CampPlayUsers", new[] { "PlayUserId" });
            DropIndex("dbo.Train_CampPlayUsers", new[] { "PlayNo" });
            DropIndex("dbo.Train_CampPlayUsers", new[] { "CampNo" });
            DropIndex("dbo.Train_CampPlayScores", new[] { "CreatorUserId" });
            DropIndex("dbo.Train_CampPlayScores", new[] { "PlayNo" });
            DropIndex("dbo.Train_CampPlayScores", new[] { "CampNo" });
            DropIndex("dbo.Train_CampPlayLogs", new[] { "CreatorUserId" });
            DropIndex("dbo.Train_CampPlayLogs", new[] { "PlayNo" });
            DropIndex("dbo.Train_CampPlayLogs", new[] { "CampNo" });
            DropIndex("dbo.Train_CampPlayInfos", new[] { "CreatorUserId" });
            DropIndex("dbo.Train_CampPlayInfos", new[] { "CampNo" });
            DropIndex("dbo.Base_SubjectCategories", new[] { "CreatorUserId" });
            DropIndex("dbo.Base_SubjectCategories", new[] { "LastModifierUserId" });
            DropIndex("dbo.Base_SubjectCategories", new[] { "ParentNo" });
            DropIndex("dbo.Sys_Settings", new[] { "TenantId", "Name", "UserId" });
            DropIndex("dbo.Sys_UserRoles", new[] { "UserId" });
            DropIndex("dbo.Sys_UserRoles", new[] { "TenantId" });
            DropIndex("dbo.Sys_UserLogins", new[] { "UserId" });
            DropIndex("dbo.Sys_UserLogins", new[] { "TenantId" });
            DropIndex("dbo.Sys_UserClaims", new[] { "UserId" });
            DropIndex("dbo.Sys_UserClaims", new[] { "TenantId" });
            DropIndex("dbo.Sys_Users", new[] { "CreatorUserId" });
            DropIndex("dbo.Sys_Users", new[] { "LastModifierUserId" });
            DropIndex("dbo.Sys_Users", new[] { "DeleterUserId" });
            DropIndex("dbo.Sys_Users", new[] { "IsDeleted" });
            DropIndex("dbo.Sys_Users", new[] { "PhoneNumber" });
            DropIndex("dbo.Sys_Users", new[] { "EmailAddress" });
            DropIndex("dbo.Sys_Users", new[] { "TenantId" });
            DropIndex("dbo.Sys_Users", new[] { "AccountType" });
            DropIndex("dbo.Sys_Users", new[] { "UserType" });
            DropIndex("dbo.Sys_Users", new[] { "UserName" });
            DropIndex("dbo.Train_CampInfos", new[] { "CreatorUserId" });
            DropIndex("dbo.Train_CampInfos", new[] { "LastModifierUserId" });
            DropIndex("dbo.Train_CampInfos", new[] { "DeleterUserId" });
            DropIndex("dbo.Train_CampInfos", new[] { "IsDeleted" });
            DropIndex("dbo.Train_CampInfos", new[] { "SubjectType" });
            DropTable("dbo.Sys_NotificationUsers",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_UserNotificationInfo_MayHaveTenant", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.Sys_UserLoginAttempts",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_UserLoginAttempt_MayHaveTenant", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.Sys_UserAccounts",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_UserAccount_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.Sys_Tenants",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_Tenant_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.Sys_NotificationTenants",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_TenantNotificationInfo_MayHaveTenant", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.Sys_States",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_SysState_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.Sys_AuditLogs",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_SysLog_MustHaveTenant", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.Sys_SysHelps",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_SysHelp_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.Sys_Functions",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_SysFunction_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.Sys_AttachFiles",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_SysAttachFile_MustHaveTenant", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                    { "DynamicFilter_SysAttachFile_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.Sys_AppGuids");
            DropTable("dbo.Sys_RoleClaims",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_RoleClaim_MayHaveTenant", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.Sys_Roles",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_Role_MayHaveTenant", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                    { "DynamicFilter_Role_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.Train_QuestionInfos",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_QuestionInfo_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.Train_QuestionAnswerInfos");
            DropTable("dbo.Sys_NotificationSubscriptions",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_NotificationSubscriptionInfo_MayHaveTenant", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.Sys_Notifications");
            DropTable("dbo.Sys_Permissions",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_DataPermission_MayHaveTenant", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                    { "DynamicFilter_PermissionSetting_MayHaveTenant", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                    { "DynamicFilter_RolePermissionSetting_MayHaveTenant", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                    { "DynamicFilter_UserPermissionSetting_MayHaveTenant", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.Train_CampSceneMaps");
            DropTable("dbo.Train_CampPlayUsers");
            DropTable("dbo.Train_CampPlayScores");
            DropTable("dbo.Train_CampPlayLogs");
            DropTable("dbo.Train_CampPlayInfos");
            DropTable("dbo.Base_SubjectCategories");
            DropTable("dbo.Sys_Settings",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_SysSetting_MayHaveTenant", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.Sys_UserRoles",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_UserRole_MayHaveTenant", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.Sys_UserLogins",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_UserLogin_MayHaveTenant", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.Sys_UserClaims",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_UserClaim_MayHaveTenant", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.Sys_Users",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_User_MayHaveTenant", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                    { "DynamicFilter_User_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.Train_CampInfos",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_CampInfo_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
        }
    }
}