From 054b6237b902c7f7be08afe1229ab9cd84b99469 Mon Sep 17 00:00:00 2001
From: crupest <crupest@outlook.com>
Date: Thu, 12 Mar 2020 19:44:17 +0800
Subject: Add database migration.

---
 Timeline/Migrations/20200312112552_AddImagePost.cs | 38 ++++++++++++++++++++++
 1 file changed, 38 insertions(+)
 create mode 100644 Timeline/Migrations/20200312112552_AddImagePost.cs

(limited to 'Timeline/Migrations/20200312112552_AddImagePost.cs')

diff --git a/Timeline/Migrations/20200312112552_AddImagePost.cs b/Timeline/Migrations/20200312112552_AddImagePost.cs
new file mode 100644
index 00000000..d5098ce0
--- /dev/null
+++ b/Timeline/Migrations/20200312112552_AddImagePost.cs
@@ -0,0 +1,38 @@
+using Microsoft.EntityFrameworkCore.Migrations;
+using Timeline.Models;
+
+namespace Timeline.Migrations
+{
+    public partial class AddImagePost : Migration
+    {
+        protected override void Up(MigrationBuilder migrationBuilder)
+        {
+            migrationBuilder.AddColumn<string>(
+                name: "content_type",
+                table: "timeline_posts",
+                nullable: false,
+                defaultValue: "");
+
+            migrationBuilder.AddColumn<string>(
+                name: "extra_content",
+                table: "timeline_posts",
+                nullable: true);
+
+            migrationBuilder.Sql($@"
+UPDATE timeline_posts
+SET content_type = '{TimelinePostContentTypes.Text}';
+            ");
+        }
+
+        protected override void Down(MigrationBuilder migrationBuilder)
+        {
+            migrationBuilder.DropColumn(
+                name: "content_type",
+                table: "timeline_posts");
+
+            migrationBuilder.DropColumn(
+                name: "extra_content",
+                table: "timeline_posts");
+        }
+    }
+}
-- 
cgit v1.2.3