protected override void Down(MigrationBuilder migrationBuilder) { //Drop Alias table var aliasEntityBuilder = new AliasEntityBuilder(migrationBuilder, ActiveDatabase); aliasEntityBuilder.Drop(); //Drop JobLog Table var jobLogEntityBuilder = new JobLogEntityBuilder(migrationBuilder, ActiveDatabase); jobLogEntityBuilder.Drop(); //Drop Tenant table var tenantEntityBuilder = new TenantEntityBuilder(migrationBuilder, ActiveDatabase); tenantEntityBuilder.Drop(); //Drop ModuleDefinitions Table var moduleDefinitionsEntityBuilder = new ModuleDefinitionsEntityBuilder(migrationBuilder, ActiveDatabase); moduleDefinitionsEntityBuilder.Drop(); //Drop Job Table var jobEntityBuilder = new JobEntityBuilder(migrationBuilder, ActiveDatabase); jobEntityBuilder.Drop(); }
protected override void Up(MigrationBuilder migrationBuilder) { //Create Tenant table var tenantEntityBuilder = new TenantEntityBuilder(migrationBuilder, ActiveDatabase); tenantEntityBuilder.Create(); //Create Alias table var aliasEntityBuilder = new AliasEntityBuilder(migrationBuilder, ActiveDatabase); aliasEntityBuilder.Create(); //Create ModuleDefinitions Table var moduleDefinitionsEntityBuilder = new ModuleDefinitionsEntityBuilder(migrationBuilder, ActiveDatabase); moduleDefinitionsEntityBuilder.Create(); //Create Job Table var jobEntityBuilder = new JobEntityBuilder(migrationBuilder, ActiveDatabase); jobEntityBuilder.Create(); //Create JobLog Table var jobLogEntityBuilder = new JobLogEntityBuilder(migrationBuilder, ActiveDatabase); jobLogEntityBuilder.Create(); }
protected override void Up(MigrationBuilder migrationBuilder) { //Add Column to Alias table var aliasEntityBuilder = new AliasEntityBuilder(migrationBuilder, ActiveDatabase); aliasEntityBuilder.AddBooleanColumn("IsDefault", true); aliasEntityBuilder.UpdateColumn("IsDefault", "1", "bool", ""); }
protected override void Down(MigrationBuilder migrationBuilder) { //Update JobLog table var jobLogEntityBuilder = new JobLogEntityBuilder(migrationBuilder, ActiveDatabase); jobLogEntityBuilder.DropIndex("IX_JobLog_JobId"); //Update Alias table var aliasEntityBuilder = new AliasEntityBuilder(migrationBuilder, ActiveDatabase); aliasEntityBuilder.DropIndex("IX_Alias_TenantId"); }
protected override void Down(MigrationBuilder migrationBuilder) { //Update Tenant table var tenantEntityBuilder = new TenantEntityBuilder(migrationBuilder, ActiveDatabase); tenantEntityBuilder.DropIndex("IX_Tenant"); //Update Alias table var aliasEntityBuilder = new AliasEntityBuilder(migrationBuilder, ActiveDatabase); aliasEntityBuilder.DropIndex("IX_Alias"); //Update ModuleDefinitions Table var moduleDefinitionsEntityBuilder = new ModuleDefinitionsEntityBuilder(migrationBuilder, ActiveDatabase); moduleDefinitionsEntityBuilder.DropIndex("IX_ModuleDefinition"); //Update Job Table var jobEntityBuilder = new JobEntityBuilder(migrationBuilder, ActiveDatabase); jobEntityBuilder.DropIndex("IX_Job"); }
protected override void Up(MigrationBuilder migrationBuilder) { //Update Tenant table var tenantEntityBuilder = new TenantEntityBuilder(migrationBuilder, ActiveDatabase); tenantEntityBuilder.AddIndex("IX_Tenant", "Name"); //Update Alias table var aliasEntityBuilder = new AliasEntityBuilder(migrationBuilder, ActiveDatabase); aliasEntityBuilder.AddIndex("IX_Alias", "Name"); //Update ModuleDefinitions Table var moduleDefinitionsEntityBuilder = new ModuleDefinitionsEntityBuilder(migrationBuilder, ActiveDatabase); moduleDefinitionsEntityBuilder.AddIndex("IX_ModuleDefinition", "ModuleDefinitionName"); //Update Job Table var jobEntityBuilder = new JobEntityBuilder(migrationBuilder, ActiveDatabase); jobEntityBuilder.AddIndex("IX_Job", "JobType"); }
protected override void Down(MigrationBuilder migrationBuilder) { var aliasEntityBuilder = new AliasEntityBuilder(migrationBuilder, ActiveDatabase); aliasEntityBuilder.DropColumn("IsDefault"); }