diff options
Diffstat (limited to 'Migrations/20230131125316_Init.cs')
-rw-r--r-- | Migrations/20230131125316_Init.cs | 63 |
1 files changed, 63 insertions, 0 deletions
diff --git a/Migrations/20230131125316_Init.cs b/Migrations/20230131125316_Init.cs new file mode 100644 index 0000000..fe709a8 --- /dev/null +++ b/Migrations/20230131125316_Init.cs @@ -0,0 +1,63 @@ +using Microsoft.EntityFrameworkCore.Migrations; + +#nullable disable + +namespace MyDarling.Migrations +{ + /// <inheritdoc /> + public partial class Init : Migration + { + /// <inheritdoc /> + protected override void Up(MigrationBuilder migrationBuilder) + { + migrationBuilder.CreateTable( + name: "UnderwearBundles", + columns: table => new + { + Id = table.Column<int>(type: "INTEGER", nullable: false) + .Annotation("Sqlite:Autoincrement", true), + Name = table.Column<string>(type: "TEXT", nullable: false), + Description = table.Column<string>(type: "TEXT", nullable: false), + Price = table.Column<decimal>(type: "TEXT", nullable: false) + }, + constraints: table => + { + table.PrimaryKey("PK_UnderwearBundles", x => x.Id); + }); + + migrationBuilder.CreateTable( + name: "Figures", + columns: table => new + { + Id = table.Column<int>(type: "INTEGER", nullable: false) + .Annotation("Sqlite:Autoincrement", true), + FilePath = table.Column<string>(type: "TEXT", nullable: false), + UnderwearBundleId = table.Column<int>(type: "INTEGER", nullable: true) + }, + constraints: table => + { + table.PrimaryKey("PK_Figures", x => x.Id); + table.ForeignKey( + name: "FK_Figures_UnderwearBundles_UnderwearBundleId", + column: x => x.UnderwearBundleId, + principalTable: "UnderwearBundles", + principalColumn: "Id"); + }); + + migrationBuilder.CreateIndex( + name: "IX_Figures_UnderwearBundleId", + table: "Figures", + column: "UnderwearBundleId"); + } + + /// <inheritdoc /> + protected override void Down(MigrationBuilder migrationBuilder) + { + migrationBuilder.DropTable( + name: "Figures"); + + migrationBuilder.DropTable( + name: "UnderwearBundles"); + } + } +} |