protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.AlterColumn <long>( name: "TransactionDate", schema: "medical", table: "MedicalTransactions", type: "INTEGER", nullable: false, oldClrType: typeof(DateTimeOffset), oldType: "TEXT"); migrationBuilder.AlterColumn <long>( name: "TransactionDate", schema: "feed", table: "FeedingTransactions", type: "INTEGER", nullable: false, oldClrType: typeof(DateTimeOffset), oldType: "TEXT"); migrationBuilder.AlterColumn <long>( name: "SellDate", schema: "animal", table: "Animals", type: "INTEGER", nullable: true, oldClrType: typeof(DateTimeOffset), oldType: "TEXT", oldNullable: true); migrationBuilder.AlterColumn <long>( name: "PurchaseDate", schema: "animal", table: "Animals", type: "INTEGER", nullable: false, oldClrType: typeof(DateTimeOffset), oldType: "TEXT"); migrationBuilder.AlterColumn <long>( name: "DateOfDeath", schema: "animal", table: "Animals", type: "INTEGER", nullable: true, oldClrType: typeof(DateTimeOffset), oldType: "TEXT", oldNullable: true); migrationBuilder.AlterColumn <long>( name: "BirthDate", schema: "animal", table: "Animals", type: "INTEGER", nullable: false, oldClrType: typeof(DateTimeOffset), oldType: "TEXT"); migrationBuilder.CreateTable( name: "WeightTransactions", columns: table => new { Id = table.Column <long>(type: "INTEGER", nullable: false) .Annotation("Sqlite:Autoincrement", true), AnimalId = table.Column <long>(type: "INTEGER", nullable: false), Weight = table.Column <decimal>(type: "TEXT", nullable: false), TransactionDate = table.Column <long>(type: "INTEGER", nullable: false) }, constraints: table => { table.PrimaryKey("PK_WeightTransactions", x => x.Id); table.ForeignKey( name: "FK_WeightTransactions_Animals_AnimalId", column: x => x.AnimalId, principalSchema: "animal", principalTable: "Animals", principalColumn: "ID", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateIndex( name: "IX_WeightTransactions_AnimalId", table: "WeightTransactions", column: "AnimalId"); migrationBuilder.AlterColumnDataTypeDateTimeOffsetToLong( propertyNames: new string[] { "BirthDate", "SellDate", "PurchaseDate", "DateOfDeath" }, tableName: "Animals"); migrationBuilder.AlterColumnDataTypeDateTimeOffsetToLong( propertyNames: new string[] { "TransactionDate" }, tableName: "MedicalTransactions"); migrationBuilder.AlterColumnDataTypeDateTimeOffsetToLong( propertyNames: new string[] { "TransactionDate" }, tableName: "FeedingTransactions"); }