public override void Up()
{
Rename.Column("UserId").OnTable(Tables.RecentBooks).InSchema(Schemas.Dbo)
.To("AccountId");
Create.ForeignKey("FK_RecentBooks_Accounts_AccountId")
.FromTable(Tables.RecentBooks).InSchema(Schemas.Dbo).ForeignColumn("AccountId")
.ToTable("Accounts").InSchema(Schemas.Dbo).PrimaryColumn(Columns.Id)
.OnDelete(System.Data.Rule.Cascade);
Rename.Column("UserId").OnTable(Tables.FavoriteBooks).InSchema(Schemas.Dbo)
.To("AccountId");
Create.ForeignKey("FK_FavoriteBooks_Accounts_AccountId")
.FromTable(Tables.FavoriteBooks).InSchema(Schemas.Dbo).ForeignColumn("AccountId")
.ToTable("Accounts").InSchema(Schemas.Dbo).PrimaryColumn(Columns.Id)
.OnDelete(System.Data.Rule.Cascade);
Rename.Column("UserId").OnTable(Tables.BookShelf).InSchema(Schemas.Dbo)
.To("AccountId");
Create.ForeignKey("FK_BookShelf_Accounts_AccountId")
.FromTable(Tables.BookShelf).InSchema(Schemas.Dbo).ForeignColumn("AccountId")
.ToTable("Accounts").InSchema(Schemas.Dbo).PrimaryColumn(Columns.Id)
.OnDelete(System.Data.Rule.Cascade);
Rename.Column("UserId").OnTable(Tables.BookPage).InSchema(Schemas.Dbo)
.To("AccountId");
Create.ForeignKey("FK_BookPage_Accounts_AccountId")
.FromTable(Tables.BookPage).InSchema(Schemas.Dbo).ForeignColumn("AccountId")
.ToTable("Accounts").InSchema(Schemas.Dbo).PrimaryColumn(Columns.Id)
.OnDelete(System.Data.Rule.Cascade);
}
public override void Down()
{
Alter.Column("MaxValueDescription").OnTable("AssessmentQuestions").AsString(int.MaxValue).NotNullable();
Alter.Column("MinValueDescription").OnTable("AssessmentQuestions").AsString(int.MaxValue).NotNullable();
Delete.Column("Ordering").FromTable("CompetencyAssessmentQuestions");
Rename.Column("LevelValue").OnTable("AssessmentQuestionLevels").To("LevelValueID");
}
public override void Up()
{
Alter.Column("MaxValueDescription").OnTable("AssessmentQuestions").AsString(255).Nullable();
Alter.Column("MinValueDescription").OnTable("AssessmentQuestions").AsString(255).Nullable();
Alter.Table("CompetencyAssessmentQuestions").AddColumn("Ordering").AsInt32().NotNullable().WithDefaultValue(0);
Rename.Column("LevelValueID").OnTable("AssessmentQuestionLevels").To("LevelValue");
}
private void ConvertLinkedTableToUuid(
string tableName,
string foreignKey,
string columnName,
string newColumnName,
string targetTableName,
string targetColumnName,
string previousIndexName
)
{
Alter.Table(tableName).AddColumn("tmpUuid").AsCustom("CHAR(36) CHARACTER SET ascii NOT NULL");
Execute.Sql($"UPDATE `{tableName}` SET `tmpUuid` = (SELECT `tmpBaseUuid` FROM `{targetTableName}` WHERE `{columnName}` = {targetColumnName})");
Delete.ForeignKey(foreignKey).OnTable(tableName);
Alter.Column(columnName).OnTable(tableName).AsCustom("CHAR(36) CHARACTER SET ascii NOT NULL");
Execute.Sql($"UPDATE `{tableName}` SET `{columnName}` = `tmpUuid`");
Delete.Column("tmpUuid").FromTable(tableName);
Rename.Column(columnName).OnTable(tableName).To(newColumnName);
Alter.Column(newColumnName).OnTable(tableName).AsCustom("CHAR(36) CHARACTER SET ascii NOT NULL");
Delete.Index(previousIndexName).OnTable(tableName);
Create.Index("IX_" + tableName + "_" + newColumnName).OnTable(tableName).OnColumn(newColumnName);
Create.ForeignKey("FK_" + tableName + "_" + newColumnName + "_" + targetTableName + "_" + targetColumnName)
.FromTable(tableName).ForeignColumn(newColumnName)
.ToTable(targetTableName).PrimaryColumn("tmpBaseUuid")
.OnDeleteOrUpdate(Rule.None);
}
public override void Down()
{
// revert back the changes on blocks height & id columns
Alter.Table("Block").AlterColumn("Height").AsInt32().NotNullable(); // remove the private key property from 'Height' column.
Delete.PrimaryKey("Height").FromTable("Block"); // remove the primary key on 'Height'.
Alter.Table("Block").AddColumn("Id").AsInt32().NotNullable().PrimaryKey().Identity(); // create the 'Id' column again and set is as primary key.
// delete the new columns.
Delete.Column("Reward").FromTable("Block");
Delete.Column("Accounted").FromTable("Block");
// revert back table & field names
Rename.Table("Block").To("blocks");
Rename.Column("Id").OnTable("blocks").To("id");
Rename.Column("Height").OnTable("blocks").To("height");
Rename.Column("Orphaned").OnTable("blocks").To("orphaned");
Rename.Column("Confirmed").OnTable("blocks").To("confirmed");
Rename.Column("BlockHash").OnTable("blocks").To("blockHash");
Rename.Column("TxHash").OnTable("blocks").To("txHash");
Rename.Column("Amount").OnTable("blocks").To("amount");
Rename.Column("CreatedAt").OnTable("blocks").To("time");
// delete the newly created tables.
Delete.Table("Account");
Delete.Table("Payment");
Delete.Table("Transaction");
}
public override void Up()
{
Create.Column("ID_HierarquiaNucleo_New").OnTable("TB_HierarquiaNucleo").AsInt32().NotNullable().Identity();
Create.Column("IN_Ativo").OnTable("TB_HierarquiaNucleo").AsBoolean().WithDefaultValue(true);
// Criar relação de Hierarquia com UF.
Create.Column("ID_UF").OnTable("TB_HierarquiaNucleo").AsCustom("TINYINT").NotNullable().WithDefaultValue(1);
Execute.Sql(Scripts_2883.RemoverConstaintHierarquiaNucleo);
// Remover colunas velhas de Hierarquia
Delete.Column("ID_HierarquiaNucleo").FromTable("TB_HierarquiaNucleo");
Rename.Column("ID_HierarquiaNucleo_New").OnTable("TB_HierarquiaNucleo").To("ID_HierarquiaNucleo");
// Readicionar a chave primária de Hierarquia
Execute.Sql("ALTER TABLE TB_HierarquiaNucleo ADD CONSTRAINT PK_TB_HierarquiaNucleo PRIMARY KEY(ID_HierarquiaNucleo)");
Create.ForeignKey("FK_HierarquiaNucleo_UF")
.FromTable("TB_HierarquiaNucleo")
.ForeignColumn("ID_UF")
.ToTable("TB_UF")
.PrimaryColumn("ID_UF");
Create.Column("IN_Ativo").OnTable("HT_HierarquiaNucleo").AsBoolean().WithDefaultValue(true);
Create.Column("ID_UF").OnTable("HT_HierarquiaNucleo").AsCustom("TINYINT").NotNullable().WithDefaultValue(1);
Execute.Sql(Scripts_2883.TriggersHierarquiaNucleo);
}
public override void Up()
{
if (Schema.Schema(SchemaName).Table("Pages").Column("CultureGroupIdentifier").Exists())
{
Rename
.Column("CultureGroupIdentifier")
.OnTable("Pages").InSchema(SchemaName)
.To("LanguageGroupIdentifier");
}
if (Schema.Schema(SchemaName).Table("Pages").Column("CultureId").Exists())
{
Rename
.Column("CultureId")
.OnTable("Pages").InSchema(SchemaName)
.To("LanguageId");
}
if (Schema.Schema(SchemaName).Table("Cultures").Exists())
{
Rename
.Table("Cultures").InSchema(SchemaName)
.To("Languages");
}
}
public override void Down()
{
//Conditional Create-column for Sql Ce databases
IfDatabase(DatabaseProviders.SqlServerCE)
.Create.Column("tabId").OnTable("cmsPropertyType").AsInt16().Nullable();
//Conditional Create-foreign for Sql Ce databases
IfDatabase(DatabaseProviders.SqlServerCE)
.Create.ForeignKey("FK_cmsPropertyType_cmsTab")
.FromTable("cmsPropertyType").ForeignColumn("tabId")
.ToTable("cmsTab").PrimaryColumn("id").OnDeleteOrUpdate(Rule.None);
//Conditional Delete-foreignkey for MySql databases
IfDatabase(DatabaseProviders.MySql)
.Delete.ForeignKey().FromTable("cmsPropertyType").ForeignColumn("propertyTypeGroupId").ToTable("cmsPropertyTypeGroup").PrimaryColumn("id");
Rename.Column("propertyTypeGroupId").OnTable("cmsPropertyType").To("tabId");
//Conditional Create-foreign for MySql databases
IfDatabase(DatabaseProviders.MySql)
.Create.ForeignKey("FK_cmsPropertyType_cmsPropertyTypeGroup")
.FromTable("cmsPropertyType").ForeignColumn("tabId")
.ToTable("cmsPropertyTypeGroup").PrimaryColumn("id").OnDeleteOrUpdate(Rule.None);
//Conditional Delete-foreignkey for Sql Ce databases
IfDatabase(DatabaseProviders.SqlServerCE)
.Delete.ForeignKey("FK_cmsPropertyType_cmsPropertyTypeGroup").OnTable("cmsPropertyType");
//Conditional Delete-column for Sql Ce databases
IfDatabase(DatabaseProviders.SqlServerCE)
.Delete.Column("propertyTypeGroupId").FromTable("propertyTypeGroupId");
}
public override void Up()
{
Delete.ForeignKey("FK_TicketFeeDetails_DiscountId_Discounts_Id")
.OnTable("TicketFeeDetails");
Delete.ForeignKey("FK_TicketFeeDetails_DiscountValueTypeId_DiscountValueTypes_Id")
.OnTable("TicketFeeDetails");
Rename.Column("DiscountId")
.OnTable("TicketFeeDetails")
.To("FeeId");
Rename.Column("DiscountValueTypeId")
.OnTable("TicketFeeDetails")
.To("ValueTypeId");
Rename.Column("DiscountGroupId")
.OnTable("TicketFeeDetails")
.To("FeeGroupId");
Alter.Table("TicketFeeDetails")
.AlterColumn("FeeId")
.AsInt16()
.NotNullable();
Create.ForeignKey()
.FromTable("TicketFeeDetails").ForeignColumn("FeeId")
.ToTable("FeeTypes").PrimaryColumn("Id");
Create.ForeignKey()
.FromTable("TicketFeeDetails").ForeignColumn("ValueTypeId")
.ToTable("ValueTypes").PrimaryColumn("Id");
}
protected override void MainDbUpgrade()
{
//Cleanup cases of Sonarr Interference with Radarr db
if (Schema.Table("PendingReleases").Column("Reason").Exists())
{
Delete.Column("Reason").FromTable("PendingReleases");
}
Alter.Table("PendingReleases").AddColumn("Reason").AsInt32().WithDefaultValue(0);
Rename.Column("IndexerId").OnTable("IndexerStatus").To("ProviderId");
Rename.Column("EnableSearch").OnTable("Indexers").To("EnableAutomaticSearch");
Alter.Table("Indexers").AddColumn("EnableInteractiveSearch").AsBoolean().Nullable();
Execute.Sql("UPDATE Indexers SET EnableInteractiveSearch = EnableAutomaticSearch");
Alter.Table("Indexers").AlterColumn("EnableInteractiveSearch").AsBoolean().NotNullable();
Create.TableForModel("DownloadClientStatus")
.WithColumn("ProviderId").AsInt32().NotNullable().Unique()
.WithColumn("InitialFailure").AsDateTime().Nullable()
.WithColumn("MostRecentFailure").AsDateTime().Nullable()
.WithColumn("EscalationLevel").AsInt32().NotNullable()
.WithColumn("DisabledTill").AsDateTime().Nullable();
}
public override void Up()
{
Rename.Column("UserEmail").OnTable("SupervisorDelegates").To("DelegateEmail");
Alter.Table("SupervisorDelegates")
.AddColumn("SupervisorEmail").AsString(255).NotNullable()
.AddColumn("AddedByDelegate").AsBoolean().NotNullable().WithDefaultValue(0);
}
public override void Up()
{
Alter.Table("trip")
.AddColumn("departure_country_id").AsInt32()
.AddColumn("arrive_country_id").AsInt32();
Rename.Column("from_location_id").OnTable("trip").To("departure_airport_id");
Rename.Column("to_location_id").OnTable("trip").To("arrive_airport_id");
}
public override void Down()
{
Rename.Column("diameter_amount").OnTable("pad_sizes").To("diameter");
Rename.Column("thickness_amount").OnTable("pad_sizes").To("thickness");
Delete.Column("diameter_unit").FromTable("pad_sizes");
Delete.Column("thickness_unit").FromTable("pad_sizes");
}
public override void Up()
{
Rename.Column("diameter").OnTable("pad_sizes").To("diameter_amount");
Rename.Column("thickness").OnTable("pad_sizes").To("thickness_amount");
Alter.Table("pad_sizes").AddColumn("diameter_unit").AsString(2);
Alter.Table("pad_sizes").AddColumn("thickness_unit").AsString(2);
}
public override void Up()
{
Rename.Column("TypeLkp").OnTable("Frwk_Notes").To("CategoryLkp");
Delete.Column("SubTypeLkp").FromTable("Frwk_Notes");
Rename.Column("ImportanceLkp").OnTable("Frwk_Notes").To("PriorityLkp");
Alter.Table("Frwk_Notes").AddForeignKeyColumn("AuthorId", "Core_Persons");
Rename.Table("Frwk_Notes").To("Core_Notes");
}
public override void Down()
{
Rename.Column("CreatedDate").OnTable(Table_Connection).To("CreateDate");
Rename.Column("NextSyncedDate").OnTable(Table_Connection).To("NextSyncDate");
Delete.Column("Message").FromTable(Table_Connection);
Delete.Column("Message").FromTable(Table_ChannelEbay);
Delete.Column("LastSyncedDate_MemberMessage").FromTable(Table_ChannelEbay);
}
public override void Up()
{
Rename.Column("CreateDate").OnTable(Table_Connection).To("CreatedDate");
Rename.Column("NextSyncDate").OnTable(Table_Connection).To("NextSyncedDate");
Alter.Table(Table_Connection).AddColumn("Message").AsMaxString().Nullable();
Alter.Table(Table_ChannelEbay).AddColumn("Message").AsMaxString().Nullable();
Alter.Table(Table_ChannelEbay).AddColumn("LastSyncedDate_MemberMessage").AsDateTime().Nullable();
}
public override void Up()
{
if (Schema.Table("EventCategories").Column("EventCategory").Exists())
{
Rename.Column("EventCategory")
.OnTable("EventCategories")
.To("Category");
}
}
protected override void MainDbUpgrade()
{
Rename.Column("EnableSearch").OnTable("Indexers").To("EnableAutomaticSearch");
Alter.Table("Indexers").AddColumn("EnableInteractiveSearch").AsBoolean().Nullable();
Execute.Sql("UPDATE Indexers SET EnableInteractiveSearch = EnableAutomaticSearch");
Alter.Table("Indexers").AlterColumn("EnableInteractiveSearch").AsBoolean().NotNullable();
}
public override void Down()
{
Rename
.Column("case_type_id")
.OnTable("case_card")
.To("case_card_template_id");
Rename.Table("case_type").To("case_card_template");
}
public override void Up()
{
Delete.ForeignKey("FK_Core_ShaRoleAppointments_WorkflowRoleId_Core_ShaRoles_Id").OnTable("Core_ShaRoleAppointments");
Delete.Index("IX_Core_ShaRoleAppointments_WorkflowRoleId").OnTable("Core_ShaRoleAppointments");
Rename.Column("WorkflowRoleId").OnTable("Core_ShaRoleAppointments").To("RoleId");
Alter.Table("Core_ShaRoleAppointments").AlterColumn("RoleId").AsGuid().ForeignKey("Core_ShaRoles", SheshaDatabaseConsts.IdColumn).Indexed();
}
public override void Down()
{
Create.Column("applicant_extension").OnTable("call_queue").AsString();
Create.Column("applicant_id").OnTable("call_queue").AsString();
Delete.Table("applicant");
Rename.Column("participant_id").OnTable("call_queue").To("operator_id");
}
public override void Up()
{
Rename.Column("ValidateCodelineCompleted")
.OnTable("queue")
.To("ResponseCompleted");
Rename.Column("ValidateCodelineCorrelationId")
.OnTable("queue")
.To("CorrelationId");
}
public override void Up()
{
IfDatabase(DatabaseProviders.SqlServerCE)
.Create.Column(NewName).OnTable(UserLogItem.TableName).AsInt32().Nullable();
Rename.Column(OldName).OnTable(UserLogItem.TableName).To(NewName);
IfDatabase(DatabaseProviders.SqlServerCE)
.Delete.Column(OldName).FromTable(UserLogItem.TableName);
}
public override void Up()
{
Alter.Table("PRF_Source").AddColumn("HashBinary").AsBinary().Nullable();
Execute.Sql("UPDATE [PRF_Source] SET HashBinary = CAST(Hash AS varbinary(max)) WHERE Hash IS NOT NULL");
Delete.Column("Hash").FromTable("PRF_Source");
Rename.Column("HashBinary").OnTable("PRF_Source").To("Hash");
}
public override void Up()
{
Create.Column("Expression").OnTable("Frwk_StoredFilters").AsStringMax().Nullable();
Execute.Sql(@"update Frwk_StoredFilters set Expression = (case when StoredFilterTypeLkp = 1 then HqlExpression when StoredFilterTypeLkp = 2 then JsonLogicExpression else null end)");
Delete.Column("HqlExpression").FromTable("Frwk_StoredFilters");
Delete.Column("JsonLogicExpression").FromTable("Frwk_StoredFilters");
Rename.Column("StoredFilterTypeLkp").OnTable("Frwk_StoredFilters").To("ExpressionTypeLkp");
}
public override void Up()
{
Rename.Table("item_template_category").To("item_template_subcategories");
Rename.Column("category").OnTable("item_template").To("subCategoryId");
Rename.Table("effect_category").To("effect_subcategories");
Rename.Column("category").OnTable("effect").To("subCategoryId");
Rename.Table("monster_category").To("monster_subcategories");
Rename.Column("categoryid").OnTable("monster_template").To("subCategoryId");
}
public override void Up()
{
Rename
.Table("active_line")
.To("line");
Rename
.Column("active_line_id")
.OnTable("call_queue")
.To("line_id");
}
public override void Up()
{
Delete.Column("applicant_id").FromTable("call_queue");
Delete.Column("applicant_extension").FromTable("call_queue");
Create.Table("applicant")
.WithColumn("id").AsGuid().PrimaryKey()
.WithColumn("extension").AsString().Nullable();
Rename.Column("operator_id").OnTable("call_queue").To("participant_id");
}
protected override void MainDbUpgrade()
{
Alter.Table("Notifications").AddColumn("OnHealthIssue").AsBoolean().WithDefaultValue(0);
Alter.Table("Notifications").AddColumn("IncludeHealthWarnings").AsBoolean().WithDefaultValue(0);
Alter.Table("Notifications").AddColumn("OnDownloadFailure").AsBoolean().WithDefaultValue(0);
Alter.Table("Notifications").AddColumn("OnImportFailure").AsBoolean().WithDefaultValue(0);
Alter.Table("Notifications").AddColumn("OnTrackRetag").AsBoolean().WithDefaultValue(0);
Delete.Column("OnDownload").FromTable("Notifications");
Rename.Column("OnAlbumDownload").OnTable("Notifications").To("OnReleaseImport");
}
