/// <summary>
/// Создать индекс
/// </summary>
public void EmailMessageParticipantCreateIndex()
{
Transformation.AddIndex(new Index
{
Name = "IX_EmailMessageParticipant_EmailString",
TableName = "EmailMessageParticipant",
Columns = new List <string>
{
nameof(IEmailMessageParticipant.EmailString)
}
});
}
/// <summary>
/// Создать индекс для поля Уникальный идентификатор по ЕГРЮЛ
/// </summary>
public void TrimEmailCreateIndex()
{
const string emailTableName = "Email";
Transformation.ConvertColumnString(emailTableName, nameof(IEmail.EmailString), 320);
Transformation.AddIndex(new Index
{
Name = "IX_Email_EmailString",
TableName = emailTableName,
Columns = new List <string>
{
nameof(IEmail.EmailString)
}
});
}
/// <summary>
/// Создать индекс
/// </summary>
public void EmailMessageCreateIndex()
{
Transformation.AddIndex(new Index
{
Name = "IX_EmailMessage_DateUtc",
TableName = "EmailMessage",
Columns = new List <string>
{
nameof(IEmailMessage.DateUtc),
}
});
Transformation.AddIndex(new Index
{
Name = "IX_EmailMessage_IsDeleted",
TableName = "EmailMessage",
Columns = new List <string>
{
nameof(IEmailMessage.IsDeleted),
}
});
}
