namespace WeApp.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_BehaviorTags", c => new { Id = c.Int(nullable: false, identity: true), TagNo = c.String(maxLength: 20), TagName = c.String(maxLength: 50), CampNo = c.String(maxLength: 128), CreationTime = c.DateTime(nullable: false), CreatorUserId = c.Long(), }) .PrimaryKey(t => t.Id) .ForeignKey("dbo.Train_Camps", t => t.CampNo) .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId) .Index(t => t.CampNo) .Index(t => t.CreatorUserId); CreateTable( "dbo.Train_Camps", c => new { Id = c.String(nullable: false, maxLength: 128), Name = c.String(maxLength: 50), PackageNo = c.String(maxLength: 20), PackageName = c.String(maxLength: 50), EngineModelType = c.Int(nullable: false), CampState = c.Int(nullable: false), AssessRoleNos = c.String(maxLength: 500), AssessAuto = c.Boolean(nullable: false), RoundScore = c.Decimal(nullable: false, precision: 18, scale: 2), Variable = c.String(maxLength: 1000), ScoreRule = c.String(maxLength: 100), PlanDate = c.DateTime(nullable: false), StartDate = c.DateTime(), EngDate = c.DateTime(), TrainingMinute = c.Decimal(nullable: false, precision: 18, scale: 2), Description = c.String(maxLength: 500), EvalBehaviorTags = c.String(maxLength: 500), 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 { { "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) .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 { { "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 { { "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 { { "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 { { "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 { { "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.Train_CampGroups", c => new { Id = c.String(nullable: false, maxLength: 128), Name = c.String(maxLength: 50), CampNo = c.String(maxLength: 128), CampGroupState = c.Int(nullable: false), StartDate = c.DateTime(), EngDate = c.DateTime(), TrainingMinute = c.Decimal(nullable: false, precision: 18, scale: 2), 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 { { "DynamicFilter_CampGroupInfo_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, }) .PrimaryKey(t => t.Id) .ForeignKey("dbo.Train_Camps", t => t.CampNo) .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId) .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId) .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId) .Index(t => t.CampNo) .Index(t => t.IsDeleted) .Index(t => t.DeleterUserId) .Index(t => t.LastModifierUserId) .Index(t => t.CreatorUserId); CreateTable( "dbo.Train_CampRoleGroups", c => new { Id = c.Int(nullable: false, identity: true), RoleGroupNo = c.String(maxLength: 128), CampNo = c.String(maxLength: 128), CreationTime = c.DateTime(nullable: false), CreatorUserId = c.Long(), }) .PrimaryKey(t => t.Id) .ForeignKey("dbo.Train_Camps", t => t.CampNo) .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId) .ForeignKey("dbo.Bs_TrainingRoleGroups", t => t.RoleGroupNo) .Index(t => t.RoleGroupNo) .Index(t => t.CampNo) .Index(t => t.CreatorUserId); CreateTable( "dbo.Bs_TrainingRoleGroups", c => new { Id = c.String(nullable: false, maxLength: 128), RoleGroupName = c.String(), Roles = c.String(), Description = c.String(), 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 { { "DynamicFilter_TrainingRoleGroupInfo_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.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_Camps", 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 { { "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.Train_CampGroupLogs", c => new { Id = c.Int(nullable: false, identity: true), CampNo = c.String(maxLength: 128), GroupNo = c.String(maxLength: 128), RoundIndex = c.Int(nullable: false), LogType = c.Int(nullable: false), LogCommand = c.String(maxLength: 30), LogMessage = c.String(maxLength: 500), RoleNo = c.String(maxLength: 20), RoleName = c.String(maxLength: 50), LogState = c.Int(nullable: false), LogScore = c.Decimal(nullable: false, precision: 18, scale: 2), ParentNo = c.String(maxLength: 128), CreationTime = c.DateTime(nullable: false), CreatorUserId = c.Long(), }) .PrimaryKey(t => t.Id) .ForeignKey("dbo.Train_CampGroups", t => t.GroupNo) .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId) .Index(t => t.GroupNo) .Index(t => t.CreatorUserId); CreateTable( "dbo.Train_CampGroupScores", c => new { Id = c.Int(nullable: false, identity: true), CampNo = c.String(maxLength: 128), GroupNo = c.String(maxLength: 128), RoundIndex = c.Int(nullable: false), SystemScore = c.Decimal(nullable: false, precision: 18, scale: 2), CorrectionScore = c.Decimal(nullable: false, precision: 18, scale: 2), SpecialistScore = c.Decimal(nullable: false, precision: 18, scale: 2), AudienceScore = c.Decimal(nullable: false, precision: 18, scale: 2), ReferenceScore = c.Decimal(nullable: false, precision: 18, scale: 2), FinalTotalScore = 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_CampGroups", t => t.GroupNo) .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId) .Index(t => t.GroupNo) .Index(t => t.CreatorUserId); 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 { { "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.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 { { "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 { { "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 { { "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 { { "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 { { "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 { { "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 { { "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.Bs_TempInfos", c => new { Id = c.Int(nullable: false, identity: true), TableName = c.String(maxLength: 50), ColumnName = c.String(maxLength: 50), Key = c.String(maxLength: 50), Value1 = c.String(maxLength: 100), Value2 = c.String(maxLength: 200), Value3 = c.String(maxLength: 500), Value5 = c.String(maxLength: 500), Value6 = c.String(maxLength: 500), Value7 = c.String(maxLength: 500), Value8 = c.String(), CreationTime = c.DateTime(nullable: false), CreatorUserId = c.Long(), }) .PrimaryKey(t => t.Id) .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId) .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 { { "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 { { "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.Bs_TrainingRoles", c => new { Id = c.String(nullable: false, maxLength: 128), RoleName = c.String(maxLength: 50), Description = c.String(maxLength: 200), 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 { { "DynamicFilter_TrainingRoleInfo_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 { { "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 { { "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 { { "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.Bs_TrainingRoles", "LastModifierUserId", "dbo.Sys_Users"); DropForeignKey("dbo.Bs_TrainingRoles", "DeleterUserId", "dbo.Sys_Users"); DropForeignKey("dbo.Bs_TrainingRoles", "CreatorUserId", "dbo.Sys_Users"); 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.Bs_TempInfos", "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_CampGroupScores", "CreatorUserId", "dbo.Sys_Users"); DropForeignKey("dbo.Train_CampGroupScores", "GroupNo", "dbo.Train_CampGroups"); DropForeignKey("dbo.Train_CampGroupLogs", "CreatorUserId", "dbo.Sys_Users"); DropForeignKey("dbo.Train_CampGroupLogs", "GroupNo", "dbo.Train_CampGroups"); DropForeignKey("dbo.Train_CampSceneMaps", "CreatorUserId", "dbo.Sys_Users"); DropForeignKey("dbo.Train_CampSceneMaps", "CampNo", "dbo.Train_Camps"); DropForeignKey("dbo.Train_CampRoleGroups", "RoleGroupNo", "dbo.Bs_TrainingRoleGroups"); DropForeignKey("dbo.Bs_TrainingRoleGroups", "LastModifierUserId", "dbo.Sys_Users"); DropForeignKey("dbo.Bs_TrainingRoleGroups", "DeleterUserId", "dbo.Sys_Users"); DropForeignKey("dbo.Bs_TrainingRoleGroups", "CreatorUserId", "dbo.Sys_Users"); DropForeignKey("dbo.Train_CampRoleGroups", "CreatorUserId", "dbo.Sys_Users"); DropForeignKey("dbo.Train_CampRoleGroups", "CampNo", "dbo.Train_Camps"); DropForeignKey("dbo.Train_CampGroups", "LastModifierUserId", "dbo.Sys_Users"); DropForeignKey("dbo.Train_CampGroups", "DeleterUserId", "dbo.Sys_Users"); DropForeignKey("dbo.Train_CampGroups", "CreatorUserId", "dbo.Sys_Users"); DropForeignKey("dbo.Train_CampGroups", "CampNo", "dbo.Train_Camps"); DropForeignKey("dbo.Train_BehaviorTags", "CreatorUserId", "dbo.Sys_Users"); DropForeignKey("dbo.Train_BehaviorTags", "CampNo", "dbo.Train_Camps"); DropForeignKey("dbo.Train_Camps", "LastModifierUserId", "dbo.Sys_Users"); DropForeignKey("dbo.Train_Camps", "DeleterUserId", "dbo.Sys_Users"); DropForeignKey("dbo.Train_Camps", "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.Bs_TrainingRoles", new[] { "CreatorUserId" }); DropIndex("dbo.Bs_TrainingRoles", new[] { "LastModifierUserId" }); DropIndex("dbo.Bs_TrainingRoles", new[] { "DeleterUserId" }); DropIndex("dbo.Bs_TrainingRoles", 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.Bs_TempInfos", new[] { "CreatorUserId" }); 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.Sys_NotificationSubscriptions", new[] { "NotificationName", "EntityTypeName", "EntityId", "UserId" }); DropIndex("dbo.Sys_NotificationSubscriptions", new[] { "TenantId" }); DropIndex("dbo.Train_CampGroupScores", new[] { "CreatorUserId" }); DropIndex("dbo.Train_CampGroupScores", new[] { "GroupNo" }); DropIndex("dbo.Train_CampGroupLogs", new[] { "CreatorUserId" }); DropIndex("dbo.Train_CampGroupLogs", new[] { "GroupNo" }); DropIndex("dbo.Sys_Permissions", new[] { "TenantId" }); DropIndex("dbo.Train_CampSceneMaps", new[] { "CreatorUserId" }); DropIndex("dbo.Train_CampSceneMaps", new[] { "CampNo" }); DropIndex("dbo.Bs_TrainingRoleGroups", new[] { "CreatorUserId" }); DropIndex("dbo.Bs_TrainingRoleGroups", new[] { "LastModifierUserId" }); DropIndex("dbo.Bs_TrainingRoleGroups", new[] { "DeleterUserId" }); DropIndex("dbo.Bs_TrainingRoleGroups", new[] { "IsDeleted" }); DropIndex("dbo.Train_CampRoleGroups", new[] { "CreatorUserId" }); DropIndex("dbo.Train_CampRoleGroups", new[] { "CampNo" }); DropIndex("dbo.Train_CampRoleGroups", new[] { "RoleGroupNo" }); DropIndex("dbo.Train_CampGroups", new[] { "CreatorUserId" }); DropIndex("dbo.Train_CampGroups", new[] { "LastModifierUserId" }); DropIndex("dbo.Train_CampGroups", new[] { "DeleterUserId" }); DropIndex("dbo.Train_CampGroups", new[] { "IsDeleted" }); DropIndex("dbo.Train_CampGroups", new[] { "CampNo" }); 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_Camps", new[] { "CreatorUserId" }); DropIndex("dbo.Train_Camps", new[] { "LastModifierUserId" }); DropIndex("dbo.Train_Camps", new[] { "DeleterUserId" }); DropIndex("dbo.Train_Camps", new[] { "IsDeleted" }); DropIndex("dbo.Train_BehaviorTags", new[] { "CreatorUserId" }); DropIndex("dbo.Train_BehaviorTags", new[] { "CampNo" }); DropTable("dbo.Sys_NotificationUsers", removedAnnotations: new Dictionary { { "DynamicFilter_UserNotificationInfo_MayHaveTenant", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, }); DropTable("dbo.Sys_UserLoginAttempts", removedAnnotations: new Dictionary { { "DynamicFilter_UserLoginAttempt_MayHaveTenant", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, }); DropTable("dbo.Sys_UserAccounts", removedAnnotations: new Dictionary { { "DynamicFilter_UserAccount_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, }); DropTable("dbo.Bs_TrainingRoles", removedAnnotations: new Dictionary { { "DynamicFilter_TrainingRoleInfo_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, }); DropTable("dbo.Sys_Tenants", removedAnnotations: new Dictionary { { "DynamicFilter_Tenant_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, }); DropTable("dbo.Sys_NotificationTenants", removedAnnotations: new Dictionary { { "DynamicFilter_TenantNotificationInfo_MayHaveTenant", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, }); DropTable("dbo.Bs_TempInfos"); DropTable("dbo.Sys_States", removedAnnotations: new Dictionary { { "DynamicFilter_SysState_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, }); DropTable("dbo.Sys_AuditLogs", removedAnnotations: new Dictionary { { "DynamicFilter_SysLog_MustHaveTenant", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, }); DropTable("dbo.Sys_SysHelps", removedAnnotations: new Dictionary { { "DynamicFilter_SysHelp_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, }); DropTable("dbo.Sys_Functions", removedAnnotations: new Dictionary { { "DynamicFilter_SysFunction_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, }); DropTable("dbo.Sys_AttachFiles", removedAnnotations: new Dictionary { { "DynamicFilter_SysAttachFile_MustHaveTenant", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, { "DynamicFilter_SysAttachFile_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, }); DropTable("dbo.Sys_AppGuids"); DropTable("dbo.Sys_RoleClaims", removedAnnotations: new Dictionary { { "DynamicFilter_RoleClaim_MayHaveTenant", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, }); DropTable("dbo.Sys_Roles", removedAnnotations: new Dictionary { { "DynamicFilter_Role_MayHaveTenant", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, { "DynamicFilter_Role_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, }); DropTable("dbo.Sys_NotificationSubscriptions", removedAnnotations: new Dictionary { { "DynamicFilter_NotificationSubscriptionInfo_MayHaveTenant", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, }); DropTable("dbo.Sys_Notifications"); DropTable("dbo.Train_CampGroupScores"); DropTable("dbo.Train_CampGroupLogs"); DropTable("dbo.Sys_Permissions", removedAnnotations: new Dictionary { { "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.Bs_TrainingRoleGroups", removedAnnotations: new Dictionary { { "DynamicFilter_TrainingRoleGroupInfo_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, }); DropTable("dbo.Train_CampRoleGroups"); DropTable("dbo.Train_CampGroups", removedAnnotations: new Dictionary { { "DynamicFilter_CampGroupInfo_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, }); DropTable("dbo.Sys_Settings", removedAnnotations: new Dictionary { { "DynamicFilter_SysSetting_MayHaveTenant", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, }); DropTable("dbo.Sys_UserRoles", removedAnnotations: new Dictionary { { "DynamicFilter_UserRole_MayHaveTenant", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, }); DropTable("dbo.Sys_UserLogins", removedAnnotations: new Dictionary { { "DynamicFilter_UserLogin_MayHaveTenant", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, }); DropTable("dbo.Sys_UserClaims", removedAnnotations: new Dictionary { { "DynamicFilter_UserClaim_MayHaveTenant", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, }); DropTable("dbo.Sys_Users", removedAnnotations: new Dictionary { { "DynamicFilter_User_MayHaveTenant", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, { "DynamicFilter_User_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, }); DropTable("dbo.Train_Camps", removedAnnotations: new Dictionary { { "DynamicFilter_CampInfo_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, }); DropTable("dbo.Train_BehaviorTags"); } } }