using System; using Microsoft.EntityFrameworkCore.Migrations; #nullable disable namespace SameBeat.Infrastructure.BazaDanych.Migracje { /// public partial class DodanoCzat : Migration { /// protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.CreateTable( name: "UczestnicyCzatu", columns: table => new { Id = table.Column(type: "uuid", nullable: false), WydarzenieId = table.Column(type: "uuid", nullable: false), Nick = table.Column(type: "character varying(40)", maxLength: 40, nullable: false), DolaczylUtc = table.Column(type: "timestamp with time zone", nullable: false), Wyciszony = table.Column(type: "boolean", nullable: false), Zbanowany = table.Column(type: "boolean", nullable: false) }, constraints: table => { table.PrimaryKey("PK_UczestnicyCzatu", x => x.Id); }); migrationBuilder.CreateTable( name: "WiadomosciCzatu", columns: table => new { Id = table.Column(type: "uuid", nullable: false), WydarzenieId = table.Column(type: "uuid", nullable: false), NadawcaTozsamoscId = table.Column(type: "uuid", nullable: false), Nick = table.Column(type: "character varying(40)", maxLength: 40, nullable: false), Tresc = table.Column(type: "character varying(500)", maxLength: 500, nullable: false), WyslanoUtc = table.Column(type: "timestamp with time zone", nullable: false), Usunieta = table.Column(type: "boolean", nullable: false) }, constraints: table => { table.PrimaryKey("PK_WiadomosciCzatu", x => x.Id); }); migrationBuilder.CreateIndex( name: "IX_UczestnicyCzatu_WydarzenieId", table: "UczestnicyCzatu", column: "WydarzenieId"); migrationBuilder.CreateIndex( name: "IX_WiadomosciCzatu_NadawcaTozsamoscId_WyslanoUtc", table: "WiadomosciCzatu", columns: new[] { "NadawcaTozsamoscId", "WyslanoUtc" }); migrationBuilder.CreateIndex( name: "IX_WiadomosciCzatu_WydarzenieId_WyslanoUtc", table: "WiadomosciCzatu", columns: new[] { "WydarzenieId", "WyslanoUtc" }); } /// protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropTable( name: "UczestnicyCzatu"); migrationBuilder.DropTable( name: "WiadomosciCzatu"); } } }