public override void Up()
{
//Migrate before changing the schema
SqlResource(SqlMigrationScriptRepository.GetResourceName("Migrate_System_Url.sql"));
DropColumn("dbo.ItSystem", "Url");
}
public override void Up()
{
AddColumn("dbo.ItSystem", "ArchiveDutyComment", c => c.String());
AlterColumn("dbo.ItSystem", "ArchiveDuty", c => c.Int());
DropColumn("dbo.ItSystemUsage", "Archived");
SqlResource(SqlMigrationScriptRepository.GetResourceName("Clear_ArchiveDuty_On_ItSystem.sql"));
}
public override void Up()
{
DropIndex("dbo.DataProcessingRegistrations", "DataProcessingRegistration_Index_Name");
DropIndex("dbo.DataProcessingRegistrationReadModels", "DataProcessingRegistrationReadModel_Index_Name");
AlterColumn("dbo.DataProcessingRegistrations", "Name", c => c.String(nullable: false, maxLength: 200));
AlterColumn("dbo.DataProcessingRegistrationReadModels", "Name", c => c.String(nullable: false, maxLength: 200));
CreateIndex("dbo.DataProcessingRegistrations", "Name", name: "DataProcessingRegistration_Index_Name");
CreateIndex("dbo.DataProcessingRegistrationReadModels", "Name", name: "DataProcessingRegistrationReadModel_Index_Name");
SqlResource(SqlMigrationScriptRepository.GetResourceName("Migrate_To_Data_Processing_Registration.sql"));
DropForeignKey("dbo.ItSystemUsageDataWorkerRelations", "DataWorkerId", "dbo.Organization");
DropForeignKey("dbo.ItSystemUsageDataWorkerRelations", "ItSystemUsageId", "dbo.ItSystemUsage");
DropForeignKey("dbo.ItSystemUsageDataWorkerRelations", "LastChangedByUserId", "dbo.User");
DropForeignKey("dbo.ItSystemUsageDataWorkerRelations", "ObjectOwnerId", "dbo.User");
DropIndex("dbo.ItSystemUsageDataWorkerRelations", new[] { "ItSystemUsageId" });
DropIndex("dbo.ItSystemUsageDataWorkerRelations", new[] { "DataWorkerId" });
DropIndex("dbo.ItSystemUsageDataWorkerRelations", new[] { "ObjectOwnerId" });
DropIndex("dbo.ItSystemUsageDataWorkerRelations", new[] { "LastChangedByUserId" });
DropColumn("dbo.ItSystemUsage", "dataProcessor");
DropColumn("dbo.ItSystemUsage", "dataProcessorControl");
DropColumn("dbo.ItSystemUsage", "lastControl");
DropColumn("dbo.ItSystemUsage", "datahandlerSupervisionDocumentationUrlName");
DropColumn("dbo.ItSystemUsage", "datahandlerSupervisionDocumentationUrl");
DropColumn("dbo.ItSystemUsage", "noteUsage");
DropColumn("dbo.ItContract", "ContainsDataHandlerAgreement");
DropColumn("dbo.ItContract", "DataHandlerAgreementUrlName");
DropColumn("dbo.ItContract", "DataHandlerAgreementUrl");
DropTable("dbo.ItSystemUsageDataWorkerRelations");
}
public override void Up()
{
AddColumn("dbo.ItSystem", "Created", c => c.DateTime(precision: 7, storeType: "datetime2"));
AddColumn("dbo.User", "Uuid", c => c.Guid(nullable: false));
SqlResource(SqlMigrationScriptRepository.GetResourceName("Patch_Uuid_System_User.sql"));
CreateIndex("dbo.ItSystem", "Uuid", unique: true, name: "UX_System_Uuuid");
CreateIndex("dbo.User", "Uuid", unique: true, name: "UX_User_Uuid");
}
public override void Up()
{
DropForeignKey("dbo.LocalRegularPersonalDataTypes", "LastChangedByUserId", "dbo.User");
DropForeignKey("dbo.LocalRegularPersonalDataTypes", "ObjectOwnerId", "dbo.User");
DropForeignKey("dbo.LocalRegularPersonalDataTypes", "OrganizationId", "dbo.Organization");
DropForeignKey("dbo.RegularPersonalDataTypes", "LastChangedByUserId", "dbo.User");
DropForeignKey("dbo.RegularPersonalDataTypes", "ObjectOwnerId", "dbo.User");
DropForeignKey("dbo.ItSystem", "RegularPersonalDataType_Id", "dbo.RegularPersonalDataTypes");
DropIndex("dbo.ItSystem", new[] { "RegularPersonalDataType_Id" });
DropIndex("dbo.LocalRegularPersonalDataTypes", new[] { "OrganizationId" });
DropIndex("dbo.LocalRegularPersonalDataTypes", new[] { "ObjectOwnerId" });
DropIndex("dbo.LocalRegularPersonalDataTypes", new[] { "LastChangedByUserId" });
DropIndex("dbo.RegularPersonalDataTypes", new[] { "ObjectOwnerId" });
DropIndex("dbo.RegularPersonalDataTypes", new[] { "LastChangedByUserId" });
DropColumn("dbo.ItSystem", "RegularPersonalDataType_Id");
DropTable("dbo.LocalRegularPersonalDataTypes");
DropTable("dbo.RegularPersonalDataTypes");
SqlResource(SqlMigrationScriptRepository.GetResourceName("Remove_Orphaned_AttachedOptions.sql")); //Make sure orphans are removed
}
public override void Up()
{
CreateTable(
"dbo.DataProcessingRegistrationOversightDates",
c => new
{
Id = c.Int(nullable: false, identity: true),
OversightDate = c.DateTime(nullable: false, precision: 7, storeType: "datetime2"),
OversightRemark = c.String(),
ParentId = c.Int(nullable: false),
})
.PrimaryKey(t => t.Id)
.ForeignKey("dbo.DataProcessingRegistrations", t => t.ParentId, cascadeDelete: true)
.Index(t => t.ParentId);
SqlResource(SqlMigrationScriptRepository.GetResourceName("Migration_DPR_LatestOversightDate.sql"));
DropColumn("dbo.DataProcessingRegistrations", "LatestOversightDate");
}
public override void Up()
{
CreateTable(
"dbo.ItSystemUsageSensitiveDataLevels",
c => new
{
Id = c.Int(nullable: false, identity: true),
SensitivityDataLevel = c.Int(nullable: false),
ItSystemUsage_Id = c.Int(nullable: false),
})
.PrimaryKey(t => t.Id)
.ForeignKey("dbo.ItSystemUsage", t => t.ItSystemUsage_Id, cascadeDelete: true)
.Index(t => t.ItSystemUsage_Id);
SqlResource(SqlMigrationScriptRepository.GetResourceName("SensitiveDataLevelUpdate.sql"));
DropColumn("dbo.ItSystemUsage", "ContainsLegalInfo");
DropColumn("dbo.ItSystemUsage", "DataLevel");
}
public override void Up()
{
SqlResource(SqlMigrationScriptRepository.GetResourceName("Remove_ReadOnly_Role.sql"));
}
public override void Up()
{
SqlResource(SqlMigrationScriptRepository.GetResourceName("AddUuidToOrganizations.sql"));
AlterColumn("dbo.Organization", "Uuid", c => c.Guid(nullable: false));
}
public override void Up()
{
AddColumn("dbo.Config", "ShowDataProcessing", c => c.Boolean(nullable: false));
SqlResource(SqlMigrationScriptRepository.GetResourceName("EnableDataProcessing.sql"));
}
public override void Up()
{
CreateTable(
"dbo.DataProcessingRegistrationRights",
c => new
{
Id = c.Int(nullable: false, identity: true),
UserId = c.Int(nullable: false),
RoleId = c.Int(nullable: false),
ObjectId = c.Int(nullable: false),
ObjectOwnerId = c.Int(nullable: false),
LastChanged = c.DateTime(nullable: false, precision: 7, storeType: "datetime2"),
LastChangedByUserId = c.Int(nullable: false),
})
.PrimaryKey(t => t.Id)
.ForeignKey("dbo.User", t => t.LastChangedByUserId)
.ForeignKey("dbo.DataProcessingRegistrations", t => t.ObjectId, cascadeDelete: true)
.ForeignKey("dbo.User", t => t.ObjectOwnerId)
.ForeignKey("dbo.DataProcessingRegistrationRoles", t => t.RoleId, cascadeDelete: true)
.ForeignKey("dbo.User", t => t.UserId, cascadeDelete: true)
.Index(t => t.UserId)
.Index(t => t.RoleId)
.Index(t => t.ObjectId)
.Index(t => t.ObjectOwnerId)
.Index(t => t.LastChangedByUserId);
CreateTable(
"dbo.DataProcessingRegistrations",
c => new
{
Id = c.Int(nullable: false, identity: true),
Name = c.String(nullable: false, maxLength: 100),
OrganizationId = c.Int(nullable: false),
ReferenceId = c.Int(),
ObjectOwnerId = c.Int(),
LastChanged = c.DateTime(nullable: false, precision: 7, storeType: "datetime2"),
LastChangedByUserId = c.Int(),
DataProcessingBasisForTransferOption_Id = c.Int(),
DataProcessingCountryOption_Id = c.Int(),
DataProcessingDataResponsibleOption_Id = c.Int(),
DataProcessingOversightOption_Id = c.Int(),
})
.PrimaryKey(t => t.Id)
.ForeignKey("dbo.User", t => t.LastChangedByUserId)
.ForeignKey("dbo.User", t => t.ObjectOwnerId)
.ForeignKey("dbo.Organization", t => t.OrganizationId)
.ForeignKey("dbo.ExternalReferences", t => t.ReferenceId)
.ForeignKey("dbo.DataProcessingBasisForTransferOptions", t => t.DataProcessingBasisForTransferOption_Id)
.ForeignKey("dbo.DataProcessingCountryOptions", t => t.DataProcessingCountryOption_Id)
.ForeignKey("dbo.DataProcessingDataResponsibleOptions", t => t.DataProcessingDataResponsibleOption_Id)
.ForeignKey("dbo.DataProcessingOversightOptions", t => t.DataProcessingOversightOption_Id)
.Index(t => t.Name, name: "DataProcessingRegistration_Index_Name")
.Index(t => t.OrganizationId)
.Index(t => t.ReferenceId)
.Index(t => t.ObjectOwnerId)
.Index(t => t.LastChangedByUserId)
.Index(t => t.DataProcessingBasisForTransferOption_Id)
.Index(t => t.DataProcessingCountryOption_Id)
.Index(t => t.DataProcessingDataResponsibleOption_Id)
.Index(t => t.DataProcessingOversightOption_Id);
CreateTable(
"dbo.DataProcessingRegistrationReadModels",
c => new
{
Id = c.Int(nullable: false, identity: true),
Name = c.String(nullable: false, maxLength: 100),
OrganizationId = c.Int(nullable: false),
SourceEntityId = c.Int(nullable: false),
MainReferenceUserAssignedId = c.String(),
MainReferenceUrl = c.String(),
MainReferenceTitle = c.String(maxLength: 100),
SystemNamesAsCsv = c.String(),
})
.PrimaryKey(t => t.Id)
.ForeignKey("dbo.Organization", t => t.OrganizationId)
.ForeignKey("dbo.DataProcessingRegistrations", t => t.SourceEntityId)
.Index(t => t.Name, name: "DataProcessingRegistrationReadModel_Index_Name")
.Index(t => t.OrganizationId)
.Index(t => t.SourceEntityId)
.Index(t => t.MainReferenceTitle, name: "DataProcessingRegistrationReadModel_Index_MainReferenceTitle");
CreateTable(
"dbo.DataProcessingRegistrationRoleAssignmentReadModels",
c => new
{
Id = c.Int(nullable: false, identity: true),
RoleId = c.Int(nullable: false),
UserId = c.Int(nullable: false),
UserFullName = c.String(nullable: false, maxLength: 100),
ParentId = c.Int(nullable: false),
})
.PrimaryKey(t => t.Id)
.ForeignKey("dbo.DataProcessingRegistrationReadModels", t => t.ParentId, cascadeDelete: true)
.Index(t => t.RoleId)
.Index(t => t.UserId)
.Index(t => t.UserFullName)
.Index(t => t.ParentId);
CreateTable(
"dbo.DataProcessingRegistrationRoles",
c => new
{
Id = c.Int(nullable: false, identity: true),
HasReadAccess = c.Boolean(nullable: false),
HasWriteAccess = c.Boolean(nullable: false),
Name = c.String(nullable: false),
IsLocallyAvailable = c.Boolean(nullable: false),
IsObligatory = c.Boolean(nullable: false),
IsSuggestion = c.Boolean(nullable: false),
Description = c.String(),
IsEnabled = c.Boolean(nullable: false),
Priority = c.Int(nullable: false),
ObjectOwnerId = c.Int(nullable: false),
LastChanged = c.DateTime(nullable: false, precision: 7, storeType: "datetime2"),
LastChangedByUserId = c.Int(nullable: false),
})
.PrimaryKey(t => t.Id)
.ForeignKey("dbo.User", t => t.LastChangedByUserId)
.ForeignKey("dbo.User", t => t.ObjectOwnerId)
.Index(t => t.ObjectOwnerId)
.Index(t => t.LastChangedByUserId);
CreateTable(
"dbo.DataProcessingBasisForTransferOptions",
c => new
{
Id = c.Int(nullable: false, identity: true),
Name = c.String(nullable: false),
IsLocallyAvailable = c.Boolean(nullable: false),
IsObligatory = c.Boolean(nullable: false),
IsSuggestion = c.Boolean(nullable: false),
Description = c.String(),
IsEnabled = c.Boolean(nullable: false),
Priority = c.Int(nullable: false),
ObjectOwnerId = c.Int(nullable: false),
LastChanged = c.DateTime(nullable: false, precision: 7, storeType: "datetime2"),
LastChangedByUserId = c.Int(nullable: false),
})
.PrimaryKey(t => t.Id)
.ForeignKey("dbo.User", t => t.LastChangedByUserId)
.ForeignKey("dbo.User", t => t.ObjectOwnerId)
.Index(t => t.ObjectOwnerId)
.Index(t => t.LastChangedByUserId);
CreateTable(
"dbo.DataProcessingCountryOptions",
c => new
{
Id = c.Int(nullable: false, identity: true),
Name = c.String(nullable: false),
IsLocallyAvailable = c.Boolean(nullable: false),
IsObligatory = c.Boolean(nullable: false),
IsSuggestion = c.Boolean(nullable: false),
Description = c.String(),
IsEnabled = c.Boolean(nullable: false),
Priority = c.Int(nullable: false),
ObjectOwnerId = c.Int(nullable: false),
LastChanged = c.DateTime(nullable: false, precision: 7, storeType: "datetime2"),
LastChangedByUserId = c.Int(nullable: false),
})
.PrimaryKey(t => t.Id)
.ForeignKey("dbo.User", t => t.LastChangedByUserId)
.ForeignKey("dbo.User", t => t.ObjectOwnerId)
.Index(t => t.ObjectOwnerId)
.Index(t => t.LastChangedByUserId);
CreateTable(
"dbo.DataProcessingDataResponsibleOptions",
c => new
{
Id = c.Int(nullable: false, identity: true),
Name = c.String(nullable: false),
IsLocallyAvailable = c.Boolean(nullable: false),
IsObligatory = c.Boolean(nullable: false),
IsSuggestion = c.Boolean(nullable: false),
Description = c.String(),
IsEnabled = c.Boolean(nullable: false),
Priority = c.Int(nullable: false),
ObjectOwnerId = c.Int(nullable: false),
LastChanged = c.DateTime(nullable: false, precision: 7, storeType: "datetime2"),
LastChangedByUserId = c.Int(nullable: false),
})
.PrimaryKey(t => t.Id)
.ForeignKey("dbo.User", t => t.LastChangedByUserId)
.ForeignKey("dbo.User", t => t.ObjectOwnerId)
.Index(t => t.ObjectOwnerId)
.Index(t => t.LastChangedByUserId);
CreateTable(
"dbo.DataProcessingOversightOptions",
c => new
{
Id = c.Int(nullable: false, identity: true),
Name = c.String(nullable: false),
IsLocallyAvailable = c.Boolean(nullable: false),
IsObligatory = c.Boolean(nullable: false),
IsSuggestion = c.Boolean(nullable: false),
Description = c.String(),
IsEnabled = c.Boolean(nullable: false),
Priority = c.Int(nullable: false),
ObjectOwnerId = c.Int(nullable: false),
LastChanged = c.DateTime(nullable: false, precision: 7, storeType: "datetime2"),
LastChangedByUserId = c.Int(nullable: false),
})
.PrimaryKey(t => t.Id)
.ForeignKey("dbo.User", t => t.LastChangedByUserId)
.ForeignKey("dbo.User", t => t.ObjectOwnerId)
.Index(t => t.ObjectOwnerId)
.Index(t => t.LastChangedByUserId);
CreateTable(
"dbo.LocalDataProcessingBasisForTransferOptions",
c => new
{
Id = c.Int(nullable: false, identity: true),
Description = c.String(),
OrganizationId = c.Int(nullable: false),
OptionId = c.Int(nullable: false),
IsActive = c.Boolean(nullable: false),
ObjectOwnerId = c.Int(),
LastChanged = c.DateTime(nullable: false, precision: 7, storeType: "datetime2"),
LastChangedByUserId = c.Int(),
})
.PrimaryKey(t => t.Id)
.ForeignKey("dbo.User", t => t.LastChangedByUserId)
.ForeignKey("dbo.User", t => t.ObjectOwnerId)
.ForeignKey("dbo.Organization", t => t.OrganizationId, cascadeDelete: true)
.Index(t => t.OrganizationId)
.Index(t => t.ObjectOwnerId)
.Index(t => t.LastChangedByUserId);
CreateTable(
"dbo.LocalDataProcessingCountryOptions",
c => new
{
Id = c.Int(nullable: false, identity: true),
Description = c.String(),
OrganizationId = c.Int(nullable: false),
OptionId = c.Int(nullable: false),
IsActive = c.Boolean(nullable: false),
ObjectOwnerId = c.Int(),
LastChanged = c.DateTime(nullable: false, precision: 7, storeType: "datetime2"),
LastChangedByUserId = c.Int(),
})
.PrimaryKey(t => t.Id)
.ForeignKey("dbo.User", t => t.LastChangedByUserId)
.ForeignKey("dbo.User", t => t.ObjectOwnerId)
.ForeignKey("dbo.Organization", t => t.OrganizationId, cascadeDelete: true)
.Index(t => t.OrganizationId)
.Index(t => t.ObjectOwnerId)
.Index(t => t.LastChangedByUserId);
CreateTable(
"dbo.LocalDataProcessingDataResponsibleOptions",
c => new
{
Id = c.Int(nullable: false, identity: true),
Description = c.String(),
OrganizationId = c.Int(nullable: false),
OptionId = c.Int(nullable: false),
IsActive = c.Boolean(nullable: false),
ObjectOwnerId = c.Int(),
LastChanged = c.DateTime(nullable: false, precision: 7, storeType: "datetime2"),
LastChangedByUserId = c.Int(),
})
.PrimaryKey(t => t.Id)
.ForeignKey("dbo.User", t => t.LastChangedByUserId)
.ForeignKey("dbo.User", t => t.ObjectOwnerId)
.ForeignKey("dbo.Organization", t => t.OrganizationId, cascadeDelete: true)
.Index(t => t.OrganizationId)
.Index(t => t.ObjectOwnerId)
.Index(t => t.LastChangedByUserId);
CreateTable(
"dbo.LocalDataProcessingOversightOptions",
c => new
{
Id = c.Int(nullable: false, identity: true),
Description = c.String(),
OrganizationId = c.Int(nullable: false),
OptionId = c.Int(nullable: false),
IsActive = c.Boolean(nullable: false),
ObjectOwnerId = c.Int(),
LastChanged = c.DateTime(nullable: false, precision: 7, storeType: "datetime2"),
LastChangedByUserId = c.Int(),
})
.PrimaryKey(t => t.Id)
.ForeignKey("dbo.User", t => t.LastChangedByUserId)
.ForeignKey("dbo.User", t => t.ObjectOwnerId)
.ForeignKey("dbo.Organization", t => t.OrganizationId, cascadeDelete: true)
.Index(t => t.OrganizationId)
.Index(t => t.ObjectOwnerId)
.Index(t => t.LastChangedByUserId);
CreateTable(
"dbo.LocalDataProcessingRegistrationRoles",
c => new
{
Id = c.Int(nullable: false, identity: true),
Description = c.String(),
OrganizationId = c.Int(nullable: false),
OptionId = c.Int(nullable: false),
IsActive = c.Boolean(nullable: false),
ObjectOwnerId = c.Int(),
LastChanged = c.DateTime(nullable: false, precision: 7, storeType: "datetime2"),
LastChangedByUserId = c.Int(),
})
.PrimaryKey(t => t.Id)
.ForeignKey("dbo.User", t => t.LastChangedByUserId)
.ForeignKey("dbo.User", t => t.ObjectOwnerId)
.ForeignKey("dbo.Organization", t => t.OrganizationId, cascadeDelete: true)
.Index(t => t.OrganizationId)
.Index(t => t.ObjectOwnerId)
.Index(t => t.LastChangedByUserId);
CreateTable(
"dbo.PendingReadModelUpdates",
c => new
{
Id = c.Int(nullable: false, identity: true),
SourceId = c.Int(nullable: false),
CreatedAt = c.DateTime(nullable: false, precision: 7, storeType: "datetime2"),
Category = c.Int(nullable: false),
})
.PrimaryKey(t => t.Id);
CreateTable(
"dbo.DataProcessingRegistrationItSystemUsages",
c => new
{
DataProcessingRegistration_Id = c.Int(nullable: false),
ItSystemUsage_Id = c.Int(nullable: false),
})
.PrimaryKey(t => new { t.DataProcessingRegistration_Id, t.ItSystemUsage_Id })
.ForeignKey("dbo.DataProcessingRegistrations", t => t.DataProcessingRegistration_Id)
.ForeignKey("dbo.ItSystemUsage", t => t.ItSystemUsage_Id)
.Index(t => t.DataProcessingRegistration_Id)
.Index(t => t.ItSystemUsage_Id);
AddColumn("dbo.ExternalReferences", "DataProcessingRegistration_Id", c => c.Int());
CreateIndex("dbo.ExternalReferences", "DataProcessingRegistration_Id");
AddForeignKey("dbo.ExternalReferences", "DataProcessingRegistration_Id", "dbo.DataProcessingRegistrations", "Id", cascadeDelete: true);
SqlResource(SqlMigrationScriptRepository.GetResourceName("AddDefaultDpaTypesToExistingDb.sql"));
}
public override void Up()
{
AddColumn("dbo.ArchiveLocations", "Uuid", c => c.Guid(nullable: false));
AddColumn("dbo.AgreementElementTypes", "Uuid", c => c.Guid(nullable: false));
AddColumn("dbo.GoalTypes", "Uuid", c => c.Guid(nullable: false));
AddColumn("dbo.OrganizationUnitRoles", "Uuid", c => c.Guid(nullable: false));
AddColumn("dbo.ReportCategoryTypes", "Uuid", c => c.Guid(nullable: false));
AddColumn("dbo.ItProjectTypes", "Uuid", c => c.Guid(nullable: false));
AddColumn("dbo.ItProjectRoles", "Uuid", c => c.Guid(nullable: false));
AddColumn("dbo.DataTypes", "Uuid", c => c.Guid(nullable: false));
AddColumn("dbo.InterfaceTypes", "Uuid", c => c.Guid(nullable: false));
AddColumn("dbo.RelationFrequencyTypes", "Uuid", c => c.Guid(nullable: false));
AddColumn("dbo.ItContractTemplateTypes", "Uuid", c => c.Guid(nullable: false));
AddColumn("dbo.ItContractTypes", "Uuid", c => c.Guid(nullable: false));
AddColumn("dbo.HandoverTrialTypes", "Uuid", c => c.Guid(nullable: false));
AddColumn("dbo.OptionExtendTypes", "Uuid", c => c.Guid(nullable: false));
AddColumn("dbo.PaymentFreqencyTypes", "Uuid", c => c.Guid(nullable: false));
AddColumn("dbo.PaymentModelTypes", "Uuid", c => c.Guid(nullable: false));
AddColumn("dbo.PriceRegulationTypes", "Uuid", c => c.Guid(nullable: false));
AddColumn("dbo.ProcurementStrategyTypes", "Uuid", c => c.Guid(nullable: false));
AddColumn("dbo.PurchaseFormTypes", "Uuid", c => c.Guid(nullable: false));
AddColumn("dbo.ItContractRoles", "Uuid", c => c.Guid(nullable: false));
AddColumn("dbo.TerminationDeadlineTypes", "Uuid", c => c.Guid(nullable: false));
AddColumn("dbo.DataProcessingBasisForTransferOptions", "Uuid", c => c.Guid(nullable: false));
AddColumn("dbo.DataProcessingDataResponsibleOptions", "Uuid", c => c.Guid(nullable: false));
AddColumn("dbo.DataProcessingCountryOptions", "Uuid", c => c.Guid(nullable: false));
AddColumn("dbo.DataProcessingOversightOptions", "Uuid", c => c.Guid(nullable: false));
AddColumn("dbo.DataProcessingRegistrationRoles", "Uuid", c => c.Guid(nullable: false));
AddColumn("dbo.ItSystemRoles", "Uuid", c => c.Guid(nullable: false));
AddColumn("dbo.ArchiveTestLocations", "Uuid", c => c.Guid(nullable: false));
AddColumn("dbo.ArchiveTypes", "Uuid", c => c.Guid(nullable: false));
AddColumn("dbo.ItSystemCategories", "Uuid", c => c.Guid(nullable: false));
AddColumn("dbo.SensitiveDataTypes", "Uuid", c => c.Guid(nullable: false));
AddColumn("dbo.TerminationDeadlineTypesInSystems", "Uuid", c => c.Guid(nullable: false));
AddColumn("dbo.BusinessTypes", "Uuid", c => c.Guid(nullable: false));
AddColumn("dbo.RegisterTypes", "Uuid", c => c.Guid(nullable: false));
AddColumn("dbo.SensitivePersonalDataTypes", "Uuid", c => c.Guid(nullable: false));
SqlResource(SqlMigrationScriptRepository.GetResourceName("Migrate_Uuid_On_OptionTypes.sql"));
CreateIndex("dbo.AgreementElementTypes", "Uuid", unique: true, name: "UX_Option_Uuid");
CreateIndex("dbo.GoalTypes", "Uuid", unique: true, name: "UX_Option_Uuid");
CreateIndex("dbo.OrganizationUnitRoles", "Uuid", unique: true, name: "UX_Option_Uuid");
CreateIndex("dbo.ItProjectTypes", "Uuid", unique: true, name: "UX_Option_Uuid");
CreateIndex("dbo.ItProjectRoles", "Uuid", unique: true, name: "UX_Option_Uuid");
CreateIndex("dbo.DataTypes", "Uuid", unique: true, name: "UX_Option_Uuid");
CreateIndex("dbo.InterfaceTypes", "Uuid", unique: true, name: "UX_Option_Uuid");
CreateIndex("dbo.RelationFrequencyTypes", "Uuid", unique: true, name: "UX_Option_Uuid");
CreateIndex("dbo.ItContractTemplateTypes", "Uuid", unique: true, name: "UX_Option_Uuid");
CreateIndex("dbo.ItContractTypes", "Uuid", unique: true, name: "UX_Option_Uuid");
CreateIndex("dbo.HandoverTrialTypes", "Uuid", unique: true, name: "UX_Option_Uuid");
CreateIndex("dbo.OptionExtendTypes", "Uuid", unique: true, name: "UX_Option_Uuid");
CreateIndex("dbo.PaymentFreqencyTypes", "Uuid", unique: true, name: "UX_Option_Uuid");
CreateIndex("dbo.PaymentModelTypes", "Uuid", unique: true, name: "UX_Option_Uuid");
CreateIndex("dbo.PriceRegulationTypes", "Uuid", unique: true, name: "UX_Option_Uuid");
CreateIndex("dbo.ProcurementStrategyTypes", "Uuid", unique: true, name: "UX_Option_Uuid");
CreateIndex("dbo.PurchaseFormTypes", "Uuid", unique: true, name: "UX_Option_Uuid");
CreateIndex("dbo.ItContractRoles", "Uuid", unique: true, name: "UX_Option_Uuid");
CreateIndex("dbo.TerminationDeadlineTypes", "Uuid", unique: true, name: "UX_Option_Uuid");
CreateIndex("dbo.DataProcessingBasisForTransferOptions", "Uuid", unique: true, name: "UX_Option_Uuid");
CreateIndex("dbo.DataProcessingDataResponsibleOptions", "Uuid", unique: true, name: "UX_Option_Uuid");
CreateIndex("dbo.DataProcessingCountryOptions", "Uuid", unique: true, name: "UX_Option_Uuid");
CreateIndex("dbo.DataProcessingOversightOptions", "Uuid", unique: true, name: "UX_Option_Uuid");
CreateIndex("dbo.DataProcessingRegistrationRoles", "Uuid", unique: true, name: "UX_Option_Uuid");
CreateIndex("dbo.ItSystemRoles", "Uuid", unique: true, name: "UX_Option_Uuid");
CreateIndex("dbo.ArchiveTypes", "Uuid", unique: true, name: "UX_Option_Uuid");
CreateIndex("dbo.SensitiveDataTypes", "Uuid", unique: true, name: "UX_Option_Uuid");
CreateIndex("dbo.BusinessTypes", "Uuid", unique: true, name: "UX_Option_Uuid");
}
public override void Up()
{
AddColumn("dbo.ItInterfaceUsage", "MigratedToUuid", c => c.Guid(nullable: true));
SqlResource(SqlMigrationScriptRepository.GetResourceName("Migrate_Contract_Relations.sql"));
}
public override void Up()
{
SqlResource(SqlMigrationScriptRepository.GetResourceName("FixAdviceIsActive.sql"));
AddColumn("dbo.Advice", "AdviceType", c => c.Int(nullable: false));
SqlResource(SqlMigrationScriptRepository.GetResourceName("Migrate_Advice_Scheduling_To_AdviceType.sql"));
}