private void CreateColumn(AdHocSqlRunner sqlRunner)
{
var fullTableName = SqlTableJournal.CreateTableName(Schema, SqlTableJournal.Table);
log().WriteInformation($"Adding Version column to the {fullTableName} table");
sqlRunner.ExecuteNonQuery($@"alter table {fullTableName} add [Version] varchar(100) null");
log().WriteInformation($"The Version columns was added to the {fullTableName} table");
}
private void CreateTable(AdHocSqlRunner sqlRunner)
{
var fullTableName = SqlTableJournal.CreateTableName(Schema, SqlTableJournal.Table);
var primaryKeyConstraintName = CreatePrimaryKeyName(SqlTableJournal.Table);
log().WriteInformation($"Creating the {fullTableName} table");
sqlRunner.ExecuteNonQuery($@"create table {fullTableName} (
[Id] int identity(1,1) not null constraint {primaryKeyConstraintName} primary key,
[ScriptName] nvarchar(255) not null,
[Applied] datetime not null,
[Version] varchar(100) not null
)");
log().WriteInformation($"The {fullTableName} table has been created");
}
