private void AlterTableUsingNewAddAndNewAdd()
{
Alter.Table("Sample")
.AddColumn("NewAddSyntax", col => col.AsInt32())
.AddColumn("NewAddSyntax", col => col.AsInt32());
}
public override void Up()
{
Alter.Column("siteid").OnTable("SW_USER2").AsString(50).Nullable();
Alter.Column("orgid").OnTable("SW_USER2").AsString(50).Nullable();
}
public override void Up()
{
Alter.Table("GoodEntries").AddColumn("Title").AsString().NotNullable();
}
public override void Up()
{
Alter.Table("users")
.AddColumn("profile_img").AsString().Nullable();
}
public override void Up()
{
//now that the controlId column is renamed and now a string we need to convert
if (Context == null || Context.Database == null)
{
return;
}
//var cpt = SqlSyntaxContext.SqlSyntaxProvider.GetConstraintsPerTable(Context.Database);
//var di = SqlSyntaxContext.SqlSyntaxProvider.GetDefinedIndexes(Context.Database);
if (Context.CurrentDatabaseProvider != DatabaseProviders.SqlServer)
{
Delete.DefaultConstraint().OnTable("cmsMacroProperty").OnColumn("macroPropertyHidden");
}
else
{
//If we are on SQLServer, we need to delete default constraints by name, older versions of umbraco did not name these default constraints
// consistently so we need to look up the constraint name to delete, this only pertains to SQL Server and this issue:
// http://issues.umbraco.org/issue/U4-4133
var sqlServerSyntaxProvider = new SqlServerSyntaxProvider();
var defaultConstraints = sqlServerSyntaxProvider.GetDefaultConstraintsPerColumn(Context.Database).Distinct();
//lookup the constraint we want to delete, normally would be called "DF_cmsMacroProperty_macroPropertyHidden" but
// we cannot be sure with really old versions
var constraint = defaultConstraints
.SingleOrDefault(x => x.Item1 == "cmsMacroProperty" && x.Item2 == "macroPropertyHidden");
if (constraint != null)
{
Execute.Sql(string.Format("ALTER TABLE [{0}] DROP CONSTRAINT [{1}]", "cmsMacroProperty", constraint.Item3));
}
}
Delete.Column("macroPropertyHidden").FromTable("cmsMacroProperty");
if (Context.CurrentDatabaseProvider == DatabaseProviders.MySql)
{
Delete.ForeignKey().FromTable("cmsMacroProperty").ForeignColumn("macroPropertyType").ToTable("cmsMacroPropertyType").PrimaryColumn("id");
}
else
{
//Before we try to delete this constraint, we'll see if it exists first, some older schemas never had it and some older schema's had this named
// differently than the default.
var keyConstraints = SqlSyntax.GetConstraintsPerColumn(Context.Database).Distinct();
var constraint = keyConstraints
.SingleOrDefault(x => x.Item1 == "cmsMacroProperty" && x.Item2 == "macroPropertyType" && x.Item3.InvariantStartsWith("PK_") == false);
if (constraint != null)
{
Delete.ForeignKey(constraint.Item3).OnTable("cmsMacroProperty");
}
}
Alter.Table("cmsMacroProperty").AddColumn("editorAlias").AsString(255).NotNullable().WithDefaultValue("");
//we need to get the data and create the migration scripts before we change the actual schema bits below!
var list = Context.Database.Fetch <dynamic>("SELECT * FROM cmsMacroPropertyType");
foreach (var item in list)
{
var alias = item.macroPropertyTypeAlias;
//check if there's a map created
var newAlias = (string)LegacyParameterEditorAliasConverter.GetNewAliasFromLegacyAlias(alias);
if (newAlias.IsNullOrWhiteSpace() == false)
{
alias = newAlias;
}
//update the table with the alias, the current macroPropertyType will contain the original id
Update.Table("cmsMacroProperty").Set(new { editorAlias = alias }).Where(new { macroPropertyType = item.id });
}
//drop the column now
Delete.Column("macroPropertyType").FromTable("cmsMacroProperty");
//drop the default constraint
Delete.DefaultConstraint().OnTable("cmsMacroProperty").OnColumn("editorAlias");
}
public override void Up()
{
Alter.Table("Pessoa")
.AlterColumn("Name").AsFixedLengthAnsiString(60).Nullable();
}
protected override void MainDbUpgrade()
{
Alter.Table("Episodes").AddColumn("AirDateUtc").AsDateTime().Nullable();
Execute.Sql("UPDATE Episodes SET AirDateUtc = AirDate");
}
void Awake() {
instance = this;
}
public override void Up()
{
Alter.Table("Log")
.AddColumn("Number").AsInt32();
}
public override void Up()
{
Delete.Column("State").FromTable("Votes");
Alter.Table("Votes").AddColumn("Published").AsBoolean().NotNullable().WithDefaultValue(false);
}
protected override void MainDbUpgrade()
{
Alter.Table("Series")
.AlterColumn("ImdbId").AsString().Nullable()
.AlterColumn("TitleSlug").AsString().Nullable();
}
public override void Down()
{
Delete.Column("Published").FromTable("Votes");
Alter.Table("Votes").AddColumn("State").AsString(255).NotNullable().WithDefaultValue("draft");
}
public override void Up()
{
Alter.Table("Users").AddColumn("StripeSubscriptionId").AsString(255).Nullable();
Update.Table("Users").Set(new { StripeSubscriptionId = "" }).AllRows();
Alter.Table("Users").AlterColumn("StripeSubscriptionId").AsString(255).NotNullable();
}
public override void Up()
{
Delete.Column("pad_id").FromTable("reviews");
Alter.Table("reviews").AddColumn("pad_color_id").AsGuid().ForeignKey("pad_colors", "id");
}
/// <summary>
/// Migrate up.
/// </summary>
public override void Up()
{
Alter.Table("Medias").InSchema(SchemaName)
.AddColumn("ImageId").AsGuid().Nullable();
}
public override void Up()
{
Alter.Table("subscriptions").AddColumn("price_billing_id").AsString(255);
}
public override void Down()
{
Alter.Table("Pessoa")
.AlterColumn("Name").AsFixedLengthString(60);
}
public override void Up()
{
Alter.Column("playerDescription").OnTable("jobs").AsCustom("longtext").NotNullable();
Alter.Column("playerSummary").OnTable("jobs").AsCustom("text").NotNullable();
}
public override void Up()
{
Alter.Table("Candidates")
.AddColumn("HasBeenPromptedForPrn").AsBoolean().NotNullable().WithDefaultValue(false)
.AddColumn("ProfessionalRegistrationNumber").AsString(32).Nullable();
}
protected override void MainDbUpgrade()
{
Alter.Table("ScheduledTasks").AlterColumn("Interval").AsDouble();
Execute.Sql("UPDATE ScheduledTasks SET Interval=0.25 WHERE TypeName='NzbDrone.Core.Download.CheckForFinishedDownloadCommand'");
}
public override void Up()
{
Alter.Table("CandidateAssessmentSupervisors").AddColumn("Removed").AsDateTime().Nullable();
}
public override void Down()
{
Alter.Table("call_queue")
.AddColumn("transaction_id").AsString().WithDefaultValue(String.Empty);
}
protected override void MainDbUpgrade()
{
Alter.Table("Profiles").AddColumn("PreferredTags").AsString().Nullable();
}
public override void Up()
{
Alter.Table("EmployeesAddresses").InSchema("ldg")
.AddColumn("AddressTypeId").AsInt16().Nullable();
}
public override void Up()
{
Alter.Table("PageComment")
.AddColumn("LastModified").AsDateTime2().NotNullable()
;
}
public override void Up()
{
if (!Schema.Schema(SchemaName).Table("Categories").Column("ParentCategoryId").Exists())
{
Create
.Column("ParentCategoryId")
.OnTable("Categories").InSchema(SchemaName)
.AsGuid()
.Nullable();
Create
.ForeignKey("Fk_Cms_Categories_ParentCategoryId__Categories_Id")
.FromTable("Categories").InSchema(SchemaName).ForeignColumn("ParentCategoryId")
.ToTable("Categories").InSchema(SchemaName).PrimaryColumn("Id");
}
if (!Schema.Schema(SchemaName).Table("Categories").Column("DisplayOrder").Exists())
{
Create
.Column("DisplayOrder")
.OnTable("Categories").InSchema(SchemaName)
.AsInt32().NotNullable().WithDefaultValue(0);
}
if (!Schema.Schema(SchemaName).Table("Categories").Column("Macro").Exists())
{
Create
.Column("Macro")
.OnTable("Categories").InSchema(SchemaName)
.AsString(MaxLength.Text).Nullable();
}
if (!Schema.Schema(SchemaName).Table("CategoryTrees").Exists())
{
Create
.Table("CategoryTrees").InSchema(SchemaName)
.WithCmsBaseColumns()
.WithColumn("Title").AsString(MaxLength.Name).NotNullable();
CreateDefaultCategoryTree();
}
if (!Schema.Schema(SchemaName).Table("Categories").Column("CategoryTreeId").Exists())
{
Create
.Column("CategoryTreeId")
.OnTable("Categories").InSchema(SchemaName)
.AsGuid().Nullable();
Update
.Table("Categories").InSchema(SchemaName)
.Set(new { CategoryTreeId = DefaultCategoryTreeId })
.AllRows();
Alter
.Table("Categories").InSchema(SchemaName)
.AlterColumn("CategoryTreeId")
.AsGuid().NotNullable();
Create
.ForeignKey("FK_Cms_Categories_CategoryTreeId_Cms_CategoryTree_Id")
.FromTable("Categories").InSchema(SchemaName).ForeignColumn("CategoryTreeId")
.ToTable("CategoryTrees").InSchema(SchemaName).PrimaryColumn("Id");
Create
.Index("IX_Cms_Categories_CategoryTreeId")
.OnTable("Categories").InSchema(SchemaName).OnColumn("CategoryTreeId");
}
}
protected override void MainDbUpgrade()
{
Alter.Table("Notifications").AddColumn("OnHealthIssue").AsBoolean().WithDefaultValue(0);
Alter.Table("Notifications").AddColumn("IncludeHealthWarnings").AsBoolean().WithDefaultValue(0);
}
public override void Up()
{
Alter.Table("Movie").InSchema("mov")
.AddColumn("TestField").AsString(100).Nullable();
}
protected override void MainDbUpgrade()
{
Alter.Table("Movies").AddColumn("PhysicalReleaseNote").AsString().Nullable();
}
public override void Down()
{
Delete.Column("image_name").Column("image_data").FromTable("pads");
Alter.Table("pads").AddColumn("image").AsBinary();
}
protected ApplicationTypesBase( Func<ImmutableArray<Assembly>> assemblySource, Alter<IEnumerable<Assembly>> filter, Func<IEnumerable<Assembly>, IEnumerable<Type>> partsSource )
{
this.assemblySource = assemblySource;
this.filter = filter;
this.partsSource = partsSource;
}
public override void Up()
{
Alter.Table("Patients")
.AddColumn("City").AsString(200).Nullable()
.AddColumn("Country").AsString(200).Nullable();
}
