From b629695c7c28fb89b91f2f7e09f7eea632c21aba Mon Sep 17 00:00:00 2001 From: crupest Date: Sun, 5 Jan 2020 23:19:56 +0800 Subject: Use sqlite development database. --- .../20200105151839_RenameTimelineMember.cs | 107 +++++++++++++++++++++ 1 file changed, 107 insertions(+) create mode 100644 Timeline/Migrations/ProductionDatabase/20200105151839_RenameTimelineMember.cs (limited to 'Timeline/Migrations/ProductionDatabase/20200105151839_RenameTimelineMember.cs') diff --git a/Timeline/Migrations/ProductionDatabase/20200105151839_RenameTimelineMember.cs b/Timeline/Migrations/ProductionDatabase/20200105151839_RenameTimelineMember.cs new file mode 100644 index 00000000..8aef42d7 --- /dev/null +++ b/Timeline/Migrations/ProductionDatabase/20200105151839_RenameTimelineMember.cs @@ -0,0 +1,107 @@ +using Microsoft.EntityFrameworkCore.Migrations; + +namespace Timeline.Migrations.ProductionDatabase +{ + public partial class RenameTimelineMember : Migration + { + protected override void Up(MigrationBuilder migrationBuilder) + { + migrationBuilder.DropForeignKey( + name: "FK_TimelineMembers_timelines_timeline", + table: "TimelineMembers"); + + migrationBuilder.DropForeignKey( + name: "FK_TimelineMembers_users_user", + table: "TimelineMembers"); + + migrationBuilder.DropPrimaryKey( + name: "PK_TimelineMembers", + table: "TimelineMembers"); + + migrationBuilder.RenameTable( + name: "TimelineMembers", + newName: "timeline_members"); + + migrationBuilder.RenameIndex( + name: "IX_TimelineMembers_user", + table: "timeline_members", + newName: "IX_timeline_members_user"); + + migrationBuilder.RenameIndex( + name: "IX_TimelineMembers_timeline", + table: "timeline_members", + newName: "IX_timeline_members_timeline"); + + migrationBuilder.AddPrimaryKey( + name: "PK_timeline_members", + table: "timeline_members", + column: "id"); + + migrationBuilder.AddForeignKey( + name: "FK_timeline_members_timelines_timeline", + table: "timeline_members", + column: "timeline", + principalTable: "timelines", + principalColumn: "id", + onDelete: ReferentialAction.Cascade); + + migrationBuilder.AddForeignKey( + name: "FK_timeline_members_users_user", + table: "timeline_members", + column: "user", + principalTable: "users", + principalColumn: "id", + onDelete: ReferentialAction.Cascade); + } + + protected override void Down(MigrationBuilder migrationBuilder) + { + migrationBuilder.DropForeignKey( + name: "FK_timeline_members_timelines_timeline", + table: "timeline_members"); + + migrationBuilder.DropForeignKey( + name: "FK_timeline_members_users_user", + table: "timeline_members"); + + migrationBuilder.DropPrimaryKey( + name: "PK_timeline_members", + table: "timeline_members"); + + migrationBuilder.RenameTable( + name: "timeline_members", + newName: "TimelineMembers"); + + migrationBuilder.RenameIndex( + name: "IX_timeline_members_user", + table: "TimelineMembers", + newName: "IX_TimelineMembers_user"); + + migrationBuilder.RenameIndex( + name: "IX_timeline_members_timeline", + table: "TimelineMembers", + newName: "IX_TimelineMembers_timeline"); + + migrationBuilder.AddPrimaryKey( + name: "PK_TimelineMembers", + table: "TimelineMembers", + column: "id"); + + migrationBuilder.AddForeignKey( + name: "FK_TimelineMembers_timelines_timeline", + table: "TimelineMembers", + column: "timeline", + principalTable: "timelines", + principalColumn: "id", + onDelete: ReferentialAction.Cascade); + + migrationBuilder.AddForeignKey( + name: "FK_TimelineMembers_users_user", + table: "TimelineMembers", + column: "user", + principalTable: "users", + principalColumn: "id", + onDelete: ReferentialAction.Cascade); + } + } +} -- cgit v1.2.3