From 79f5eaf40b93d64be74d8b4f1ef80d19fadbfbe1 Mon Sep 17 00:00:00 2001 From: Paweł Bernaciak Date: Fri, 29 Dec 2023 09:41:56 +0100 Subject: Cywilizowany tailwind --- CoreWiki/Migrations/20231224183732_Initial.cs | 74 +++++++++++++++++++++++++++ 1 file changed, 74 insertions(+) create mode 100644 CoreWiki/Migrations/20231224183732_Initial.cs (limited to 'CoreWiki/Migrations/20231224183732_Initial.cs') diff --git a/CoreWiki/Migrations/20231224183732_Initial.cs b/CoreWiki/Migrations/20231224183732_Initial.cs new file mode 100644 index 0000000..312920a --- /dev/null +++ b/CoreWiki/Migrations/20231224183732_Initial.cs @@ -0,0 +1,74 @@ +using System; +using Microsoft.EntityFrameworkCore.Migrations; + +#nullable disable + +namespace CoreWiki.Migrations +{ + /// + public partial class Initial : Migration + { + /// + protected override void Up(MigrationBuilder migrationBuilder) + { + migrationBuilder.CreateTable( + name: "Articles", + columns: table => new + { + Id = table.Column(type: "INTEGER", nullable: false) + .Annotation("Sqlite:Autoincrement", true), + Slug = table.Column(type: "TEXT", nullable: false), + Topic = table.Column(type: "TEXT", maxLength: 100, nullable: false), + Published = table.Column(type: "TEXT", nullable: false), + Content = table.Column(type: "TEXT", nullable: false) + }, + constraints: table => + { + table.PrimaryKey("PK_Articles", x => x.Id); + }); + + migrationBuilder.CreateTable( + name: "Comment", + columns: table => new + { + Id = table.Column(type: "INTEGER", nullable: false) + .Annotation("Sqlite:Autoincrement", true), + ArticleId = table.Column(type: "INTEGER", nullable: false), + DisplayName = table.Column(type: "TEXT", nullable: false), + EMail = table.Column(type: "TEXT", nullable: false), + Content = table.Column(type: "TEXT", nullable: false), + Submitted = table.Column(type: "TEXT", nullable: false) + }, + constraints: table => + { + table.PrimaryKey("PK_Comment", x => x.Id); + table.ForeignKey( + name: "FK_Comment_Articles_ArticleId", + column: x => x.ArticleId, + principalTable: "Articles", + principalColumn: "Id", + onDelete: ReferentialAction.Cascade); + }); + + migrationBuilder.InsertData( + table: "Articles", + columns: new[] { "Id", "Content", "Published", "Slug", "Topic" }, + values: new object[] { 1, "Welcome to your new CoreWiki installation", new DateTime(2023, 12, 24, 18, 37, 32, 413, DateTimeKind.Utc).AddTicks(8400), "home-page", "Home Page" }); + + migrationBuilder.CreateIndex( + name: "IX_Comment_ArticleId", + table: "Comment", + column: "ArticleId"); + } + + /// + protected override void Down(MigrationBuilder migrationBuilder) + { + migrationBuilder.DropTable( + name: "Comment"); + + migrationBuilder.DropTable( + name: "Articles"); + } + } +} -- cgit v1.2.3