public override void Migrate()
{
var tables = SqlSyntax.GetTablesInSchema(Context.Database).ToArray();
if (tables.InvariantContains("cmsContentNu"))
{
return;
}
var textType = SqlSyntax.GetSpecialDbType(SpecialDbTypes.NTEXT);
Create.Table("cmsContentNu")
.WithColumn("nodeId").AsInt32().NotNullable()
.WithColumn("published").AsBoolean().NotNullable()
.WithColumn("data").AsCustom(textType).NotNullable()
.WithColumn("rv").AsInt64().NotNullable().WithDefaultValue(0)
.Do();
Create.PrimaryKey("PK_cmsContentNu")
.OnTable("cmsContentNu")
.Columns(new[] { "nodeId", "published" })
.Do();
Create.ForeignKey("FK_cmsContentNu_umbracoNode_id")
.FromTable("cmsContentNu")
.ForeignColumn("nodeId")
.ToTable("umbracoNode")
.PrimaryColumn("id")
.OnDelete(Rule.Cascade)
.OnUpdate(Rule.None)
.Do();
}
public override void Up()
{
//Don't exeucte if the table is already there
var tables = SqlSyntax.GetTablesInSchema(Context.Database).ToArray();
if (tables.InvariantContains("umbracoDeployChecksum"))
{
return;
}
Create.Table("umbracoDeployChecksum")
.WithColumn("id").AsInt32().Identity().PrimaryKey("PK_umbracoDeployChecksum")
.WithColumn("entityType").AsString(32).NotNullable()
.WithColumn("entityGuid").AsGuid().Nullable()
.WithColumn("entityPath").AsString(256).Nullable()
.WithColumn("localChecksum").AsString(32).NotNullable()
.WithColumn("compositeChecksum").AsString(32).Nullable();
Create.Table("umbracoDeployDependency")
.WithColumn("sourceId").AsInt32().NotNullable().ForeignKey("FK_umbracoDeployDependency_umbracoDeployChecksum_id1", "umbracoDeployChecksum", "id")
.WithColumn("targetId").AsInt32().NotNullable().ForeignKey("FK_umbracoDeployDependency_umbracoDeployChecksum_id2", "umbracoDeployChecksum", "id")
.WithColumn("mode").AsInt32().NotNullable();
Create.PrimaryKey("PK_umbracoDeployDependency").OnTable("umbracoDeployDependency").Columns(new[] { "sourceId", "targetId" });
Create.Index("IX_umbracoDeployChecksum").OnTable("umbracoDeployChecksum")
.OnColumn("entityType")
.Ascending()
.OnColumn("entityGuid")
.Ascending()
.OnColumn("entityPath")
.Unique();
}
public override void Up()
{
//Don't exeucte if the table is already there
var tables = SqlSyntax.GetTablesInSchema(Context.Database).ToArray();
if (tables.InvariantContains("umbracoMigration"))
{
return;
}
Create.Table("umbracoMigration")
.WithColumn("id").AsInt32().NotNullable().PrimaryKey("PK_umbracoMigrations").Identity()
.WithColumn("name").AsString(255).NotNullable()
.WithColumn("version").AsString(50).NotNullable()
.WithColumn("createDate").AsDateTime().NotNullable().WithDefault(SystemMethods.CurrentDateTime);
//unique constraint on name + version
Create.Index("IX_umbracoMigration").OnTable("umbracoMigration")
.OnColumn("name").Ascending()
.OnColumn("version").Ascending()
.WithOptions()
.NonClustered()
.WithOptions()
.Unique();
}
public override void Up()
{
Logger.Debug <CreateSprintProgressTable>("Looking for tables.");
var tables = SqlSyntax.GetTablesInSchema(Context.Database).ToArray();
var dSprintProgressExists = tables.InvariantContains("dSprintProgress");
if (!dSprintProgressExists)
{
Create.Table <SprintProgressDto>();
/*
* Create.Table("dSprintProgress")
* .WithColumn("sprintId").AsInt32().NotNullable()
* .WithColumn("dateTime").AsDateTime().NotNullable()
* .WithColumn("jsonData").AsString(512).NotNullable();
* Create.Index("IX_dSprintProgress")
* .OnTable("dSprintProgress")
* .OnColumn("sprintId").Ascending()
* .OnColumn("dateTime").Ascending()
* .WithOptions().Unique()
* .WithOptions().NonClustered();
*/
}
Logger.Debug <CreateSprintProgressTable>("Done.");
}
public override void Migrate()
{
var tables = SqlSyntax.GetTablesInSchema(Context.Database).ToList();
var constraints = SqlSyntax.GetConstraintsPerColumn(Context.Database).Distinct().ToArray();
var columns = SqlSyntax.GetColumnsInSchema(Context.Database).ToArray();
//In some very rare cases, there might alraedy be user group tables that we'll need to remove first
//but of course we don't want to remove the tables we will be creating below if they already exist so
//need to do some checks first since these old rare tables have a different schema
RemoveOldTablesIfExist(tables, columns);
if (AddNewTables(tables))
{
MigrateUserPermissions();
MigrateUserTypesToGroups();
DeleteOldTables(tables, constraints);
SetDefaultIcons();
}
else
{
//if we aren't adding the tables, make sure that the umbracoUserGroup table has the correct FKs - these
//were added after the beta release so we need to do some cleanup
//if the FK doesn't exist
if (constraints.Any(x => x.Item1.InvariantEquals("umbracoUserGroup") &&
x.Item2.InvariantEquals("startContentId") &&
x.Item3.InvariantEquals("FK_startContentId_umbracoNode_id")) == false)
{
//before we add any foreign key we need to make sure there's no stale data in there which would have happened in the beta
//release if a start node was assigned and then that start node was deleted.
Database.Execute(@"UPDATE umbracoUserGroup SET startContentId = NULL WHERE startContentId NOT IN (SELECT id FROM umbracoNode)");
Create.ForeignKey("FK_startContentId_umbracoNode_id")
.FromTable("umbracoUserGroup")
.ForeignColumn("startContentId")
.ToTable("umbracoNode")
.PrimaryColumn("id")
.OnDelete(Rule.None)
.OnUpdate(Rule.None)
.Do();
}
if (constraints.Any(x => x.Item1.InvariantEquals("umbracoUserGroup") &&
x.Item2.InvariantEquals("startMediaId") &&
x.Item3.InvariantEquals("FK_startMediaId_umbracoNode_id")) == false)
{
//before we add any foreign key we need to make sure there's no stale data in there which would have happened in the beta
//release if a start node was assigned and then that start node was deleted.
Database.Execute(@"UPDATE umbracoUserGroup SET startMediaId = NULL WHERE startMediaId NOT IN (SELECT id FROM umbracoNode)");
Create.ForeignKey("FK_startMediaId_umbracoNode_id")
.FromTable("umbracoUserGroup")
.ForeignColumn("startMediaId")
.ToTable("umbracoNode")
.PrimaryColumn("id")
.OnDelete(Rule.None)
.OnUpdate(Rule.None)
.Do();
}
}
}
public override void Up()
{
var tables = SqlSyntax.GetTablesInSchema(Context.Database).ToArray();
if (!tables.InvariantContains(Comments.Table))
{
Create.Table <UserCommentDTO>();
}
}
public override void Up()
{
var tables = SqlSyntax.GetTablesInSchema(Context.Database);
if (!tables.InvariantContains(Forums.Table))
{
Create.Table <ForumPostsDTO>();
}
}
public override void Migrate()
{
var tables = SqlSyntax.GetTablesInSchema(Context.Database).ToArray();
if (tables.InvariantContains(nameof(FormulateSubmission)) == false)
{
Create.Table <FormulateSubmission>().Do();
}
}
public override void Up()
{
var tables = SqlSyntax.GetTablesInSchema(Context.Database).ToArray();
if (tables.InvariantContains("umbracoUserLogin") == false)
{
Create.Table <UserLoginDto>();
}
}
public override void Migrate()
{
var tables = SqlSyntax.GetTablesInSchema(Context.Database).ToArray();
if (tables.InvariantContains(Constants.DatabaseSchema.Tables.UserLogin) == false)
{
Create.Table <UserLoginDto>().Do();
}
}
public override void Up()
{
var tables = SqlSyntax.GetTablesInSchema(Context.Database).ToArray();
if (!tables.InvariantContains("Aubergine_Configuration"))
{
Create.Table <AubergineConfig>();
}
}
public override void Up()
{
var tables = SqlSyntax.GetTablesInSchema(Context.Database).ToArray();
if (tables.InvariantContains(AuditEntryDto.TableName))
{
return;
}
Create.Table <AuditEntryDto>();
}
public override void Down()
{
Logger.Debug <CreateTableMigration>("Deleting tables");
var tables = SqlSyntax.GetTablesInSchema(Context.Database).ToArray();
if (tables.InvariantContains(MigrationDemoApp.SimpleTableName))
{
Delete.Table(MigrationDemoApp.SimpleTableName);
}
}
private void CreateDatabaseTable()
{
// Add CreatedPackage table in database if it doesn't exist
IEnumerable <string> tables = SqlSyntax.GetTablesInSchema(Context.Database);
if (!tables.InvariantContains(CreatedPackageSchemaDto.TableName))
{
Create.Table <CreatedPackageSchemaDto>().Do();
}
}
protected override void Migrate()
{
IEnumerable <string> tables = SqlSyntax.GetTablesInSchema(Context.Database);
if (tables.InvariantContains(TwoFactorLoginDto.TableName))
{
return;
}
Create.Table <TwoFactorLoginDto>().Do();
}
public override void Migrate()
{
var tables = SqlSyntax.GetTablesInSchema(Context.Database).ToArray();
if (tables.InvariantContains(Constants.DatabaseSchema.Tables.Consent))
{
return;
}
Create.Table <ConsentDto>().Do();
}
protected override void Migrate()
{
IEnumerable <string> tables = SqlSyntax.GetTablesInSchema(Context.Database);
if (tables.InvariantContains("cmsContentNu"))
{
return;
}
Create.Table <ContentNuDto>(true).Do();
}
public override void Down()
{
Logger.Info <CreateATable>("1.0.0: Running Migration Down");
var tables = SqlSyntax.GetTablesInSchema(Context.Database).ToArray();
if (tables.InvariantContains("SomeDataTable"))
{
Delete.Table("SomeDataTable");
}
}
public override void Migrate()
{
var tables = SqlSyntax.GetTablesInSchema(Context.Database);
if (tables.InvariantContains("cmsContentNu"))
{
return;
}
Create.Table <ContentNuDto>(true).Do();
}
public override void Up()
{
var tables = SqlSyntax.GetTablesInSchema(Context.Database).ToArray();
if (tables.InvariantContains("cmsMedia") == false)
{
Create.Table <MediaDto>();
MigrateMediaPaths();
}
}
public override void Up()
{
var tables = SqlSyntax.GetTablesInSchema(Context.Database).ToArray();
if (tables.InvariantContains("umbracoLock") == false)
{
Create.Table("umbracoLock")
.WithColumn("id").AsInt32().PrimaryKey("PK_umbracoLock")
.WithColumn("value").AsInt32().NotNullable()
.WithColumn("name").AsString(64).NotNullable();
}
}
public override void Migrate()
{
var tables = SqlSyntax.GetTablesInSchema(Context.Database).ToArray();
if (tables.InvariantContains(Constants.DatabaseSchema.Tables.MediaVersion))
{
return;
}
Create.Table <MediaVersionDto>().Do();
MigrateMediaPaths();
}
/// <remarks>
/// The conditionals are useful to enable the same migration to be used in multiple
/// migration paths x.x -> 8.18 and x.x -> 9.x
/// </remarks>
protected override void Migrate()
{
IEnumerable <string> tables = SqlSyntax.GetTablesInSchema(Context.Database);
if (!tables.InvariantContains(ContentVersionCleanupPolicyDto.TableName))
{
Create.Table <ContentVersionCleanupPolicyDto>().Do();
}
IEnumerable <ColumnInfo> columns = SqlSyntax.GetColumnsInSchema(Context.Database);
AddColumnIfNotExists <ContentVersionDto>(columns, "preventCleanup");
}
/// <remarks>
/// The conditionals are useful to enable the same migration to be used in multiple
/// migration paths x.x -> 8.18 and x.x -> 9.x
/// </remarks>
public override void Migrate()
{
var tables = SqlSyntax.GetTablesInSchema(Context.Database);
if (!tables.InvariantContains(ContentVersionCleanupPolicyDto.TableName))
{
Create.Table <ContentVersionCleanupPolicyDto>().Do();
}
var columns = SqlSyntax.GetColumnsInSchema(Context.Database);
AddColumnIfNotExists <ContentVersionDto>(columns, "preventCleanup");
}
public override void Up()
{
var updated = false;
var tables = SqlSyntax.GetTablesInSchema(Context.Database).ToList();
//var constraints = SqlSyntax.GetConstraintsPerColumn(Context.Database).Distinct().ToArray();
//var columns = SqlSyntax.GetColumnsInSchema(Context.Database).ToArray();
if (tables.InvariantContains(PageViewCounter.SqlTableName) == false)
{
Create.Table <PageViewCounter>();
updated = true;
}
}
public override void Up()
{
var tables = SqlSyntax.GetTablesInSchema(Context.Database).ToArray();
if (tables.InvariantContains(Constants.ProductName))
{
return;
}
Create.Table(Constants.ProductName)
.WithColumn("userId").AsInt32().NotNullable()
.WithColumn("key").AsString()
.WithColumn("value").AsString()
.WithColumn("confirmed").AsBoolean();
}
public override void Up()
{
var tables = SqlSyntax.GetTablesInSchema(Context.Database).ToArray();
if (!tables.InvariantContains(UserContent.TableName))
{
Create.Table <UserContentDTO>();
/*
* Create.Index("IX_UserContentKeyIndex")
* .OnTable(UserContent.TableName)
* .OnColumn("Key")
* .Unique().WithOptions().NonClustered(); */
}
}
public override void Up()
{
var tables = SqlSyntax.GetTablesInSchema(Context.Database).ToArray();
if (tables.InvariantContains("umbracoUserStartNode") == false)
{
Create.Table <UserStartNodeDto>();
MigrateUserStartNodes();
//now remove the old columns
Delete.Column("startStructureID").FromTable("umbracoUser");
Delete.Column("startMediaID").FromTable("umbracoUser");
}
}
public override void Up()
{
var tableName = "cmsPreviewXml";
var tables = SqlSyntax.GetTablesInSchema(Context.Database).ToArray();
if (tables.InvariantContains(tableName))
{
return;
}
Create.Table(tableName)
.WithColumn("nodeId").AsInt32().NotNullable()
.WithColumn("versionId").AsGuid().NotNullable()
.WithColumn("timestamp").AsDateTime().NotNullable()
.WithColumn("xml").AsString();
}
public override void Up()
{
//Don't exeucte if the table is already there
var tables = SqlSyntax.GetTablesInSchema(Context.Database).ToArray();
if (tables.InvariantContains("umbracoExternalLogin"))
{
return;
}
Create.Table("umbracoExternalLogin")
.WithColumn("id").AsInt32().Identity().PrimaryKey("PK_umbracoExternalLogin")
.WithColumn("userId").AsInt32().NotNullable().ForeignKey("FK_umbracoExternalLogin_umbracoUser_id", "umbracoUser", "id")
.WithColumn("loginProvider").AsString(4000).NotNullable()
.WithColumn("providerKey").AsString(4000).NotNullable()
.WithColumn("createDate").AsDateTime().NotNullable().WithDefault(SystemMethods.CurrentDateTime);
}
