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"); }