|
|
|
|
using Microsoft.EntityFrameworkCore.Migrations;
|
|
|
|
|
using System;
|
|
|
|
|
using System.Collections.Generic;
|
|
|
|
|
|
|
|
|
|
namespace Ombi.Store.Migrations
|
|
|
|
|
{
|
|
|
|
|
public partial class Inital : Migration
|
|
|
|
|
{
|
|
|
|
|
protected override void Up(MigrationBuilder migrationBuilder)
|
|
|
|
|
{
|
|
|
|
|
migrationBuilder.CreateTable(
|
|
|
|
|
name: "ApplicationConfiguration",
|
|
|
|
|
columns: table => new
|
|
|
|
|
{
|
|
|
|
|
Id = table.Column<int>(type: "INTEGER", nullable: false)
|
|
|
|
|
.Annotation("Sqlite:Autoincrement", true),
|
|
|
|
|
Type = table.Column<int>(type: "INTEGER", nullable: false),
|
|
|
|
|
Value = table.Column<string>(type: "TEXT", nullable: true)
|
|
|
|
|
},
|
|
|
|
|
constraints: table =>
|
|
|
|
|
{
|
|
|
|
|
table.PrimaryKey("PK_ApplicationConfiguration", x => x.Id);
|
|
|
|
|
});
|
|
|
|
|
|
|
|
|
|
migrationBuilder.CreateTable(
|
|
|
|
|
name: "AspNetRoles",
|
|
|
|
|
columns: table => new
|
|
|
|
|
{
|
|
|
|
|
Id = table.Column<string>(type: "TEXT", nullable: false),
|
|
|
|
|
ConcurrencyStamp = table.Column<string>(type: "TEXT", nullable: true),
|
|
|
|
|
Name = table.Column<string>(type: "TEXT", maxLength: 256, nullable: true),
|
|
|
|
|
NormalizedName = table.Column<string>(type: "TEXT", maxLength: 256, nullable: true)
|
|
|
|
|
},
|
|
|
|
|
constraints: table =>
|
|
|
|
|
{
|
|
|
|
|
table.PrimaryKey("PK_AspNetRoles", x => x.Id);
|
|
|
|
|
});
|
|
|
|
|
|
|
|
|
|
migrationBuilder.CreateTable(
|
|
|
|
|
name: "AspNetUsers",
|
|
|
|
|
columns: table => new
|
|
|
|
|
{
|
|
|
|
|
Id = table.Column<string>(type: "TEXT", nullable: false),
|
|
|
|
|
AccessFailedCount = table.Column<int>(type: "INTEGER", nullable: false),
|
|
|
|
|
Alias = table.Column<string>(type: "TEXT", nullable: true),
|
|
|
|
|
ConcurrencyStamp = table.Column<string>(type: "TEXT", nullable: true),
|
|
|
|
|
Email = table.Column<string>(type: "TEXT", maxLength: 256, nullable: true),
|
|
|
|
|
EmailConfirmed = table.Column<bool>(type: "INTEGER", nullable: false),
|
|
|
|
|
LastLoggedIn = table.Column<DateTime>(type: "TEXT", nullable: true),
|
|
|
|
|
LockoutEnabled = table.Column<bool>(type: "INTEGER", nullable: false),
|
|
|
|
|
LockoutEnd = table.Column<DateTimeOffset>(type: "TEXT", nullable: true),
|
|
|
|
|
NormalizedEmail = table.Column<string>(type: "TEXT", maxLength: 256, nullable: true),
|
|
|
|
|
NormalizedUserName = table.Column<string>(type: "TEXT", maxLength: 256, nullable: true),
|
|
|
|
|
PasswordHash = table.Column<string>(type: "TEXT", nullable: true),
|
|
|
|
|
PhoneNumber = table.Column<string>(type: "TEXT", nullable: true),
|
|
|
|
|
PhoneNumberConfirmed = table.Column<bool>(type: "INTEGER", nullable: false),
|
|
|
|
|
ProviderUserId = table.Column<string>(type: "TEXT", nullable: true),
|
|
|
|
|
SecurityStamp = table.Column<string>(type: "TEXT", nullable: true),
|
|
|
|
|
TwoFactorEnabled = table.Column<bool>(type: "INTEGER", nullable: false),
|
|
|
|
|
UserName = table.Column<string>(type: "TEXT", maxLength: 256, nullable: true),
|
|
|
|
|
UserType = table.Column<int>(type: "INTEGER", nullable: false)
|
|
|
|
|
},
|
|
|
|
|
constraints: table =>
|
|
|
|
|
{
|
|
|
|
|
table.PrimaryKey("PK_AspNetUsers", x => x.Id);
|
|
|
|
|
});
|
|
|
|
|
|
|
|
|
|
migrationBuilder.CreateTable(
|
|
|
|
|
name: "Audit",
|
|
|
|
|
columns: table => new
|
|
|
|
|
{
|
|
|
|
|
Id = table.Column<int>(type: "INTEGER", nullable: false)
|
|
|
|
|
.Annotation("Sqlite:Autoincrement", true),
|
|
|
|
|
AuditArea = table.Column<int>(type: "INTEGER", nullable: false),
|
|
|
|
|
AuditType = table.Column<int>(type: "INTEGER", nullable: false),
|
|
|
|
|
DateTime = table.Column<DateTime>(type: "TEXT", nullable: false),
|
|
|
|
|
Description = table.Column<string>(type: "TEXT", nullable: true),
|
|
|
|
|
User = table.Column<string>(type: "TEXT", nullable: true)
|
|
|
|
|
},
|
|
|
|
|
constraints: table =>
|
|
|
|
|
{
|
|
|
|
|
table.PrimaryKey("PK_Audit", x => x.Id);
|
|
|
|
|
});
|
|
|
|
|
|
|
|
|
|
migrationBuilder.CreateTable(
|
|
|
|
|
name: "CouchPotatoCache",
|
|
|
|
|
columns: table => new
|
|
|
|
|
{
|
|
|
|
|
Id = table.Column<int>(type: "INTEGER", nullable: false)
|
|
|
|
|
.Annotation("Sqlite:Autoincrement", true),
|
|
|
|
|
TheMovieDbId = table.Column<int>(type: "INTEGER", nullable: false)
|
|
|
|
|
},
|
|
|
|
|
constraints: table =>
|
|
|
|
|
{
|
|
|
|
|
table.PrimaryKey("PK_CouchPotatoCache", x => x.Id);
|
|
|
|
|
});
|
|
|
|
|
|
|
|
|
|
migrationBuilder.CreateTable(
|
|
|
|
|
name: "EmbyContent",
|
|
|
|
|
columns: table => new
|
|
|
|
|
{
|
|
|
|
|
Id = table.Column<int>(type: "INTEGER", nullable: false)
|
|
|
|
|
.Annotation("Sqlite:Autoincrement", true),
|
|
|
|
|
AddedAt = table.Column<DateTime>(type: "TEXT", nullable: false),
|
|
|
|
|
EmbyId = table.Column<string>(type: "TEXT", nullable: false),
|
|
|
|
|
ProviderId = table.Column<string>(type: "TEXT", nullable: true),
|
|
|
|
|
Title = table.Column<string>(type: "TEXT", nullable: true),
|
|
|
|
|
Type = table.Column<int>(type: "INTEGER", nullable: false)
|
|
|
|
|
},
|
|
|
|
|
constraints: table =>
|
|
|
|
|
{
|
|
|
|
|
table.PrimaryKey("PK_EmbyContent", x => x.Id);
|
|
|
|
|
table.UniqueConstraint("AK_EmbyContent_EmbyId", x => x.EmbyId);
|
|
|
|
|
});
|
|
|
|
|
|
|
|
|
|
migrationBuilder.CreateTable(
|
|
|
|
|
name: "GlobalSettings",
|
|
|
|
|
columns: table => new
|
|
|
|
|
{
|
|
|
|
|
Id = table.Column<int>(type: "INTEGER", nullable: false)
|
|
|
|
|
.Annotation("Sqlite:Autoincrement", true),
|
|
|
|
|
Content = table.Column<string>(type: "TEXT", nullable: true),
|
|
|
|
|
SettingsName = table.Column<string>(type: "TEXT", nullable: true)
|
|
|
|
|
},
|
|
|
|
|
constraints: table =>
|
|
|
|
|
{
|
|
|
|
|
table.PrimaryKey("PK_GlobalSettings", x => x.Id);
|
|
|
|
|
});
|
|
|
|
|
|
|
|
|
|
migrationBuilder.CreateTable(
|
|
|
|
|
name: "NotificationTemplates",
|
|
|
|
|
columns: table => new
|
|
|
|
|
{
|
|
|
|
|
Id = table.Column<int>(type: "INTEGER", nullable: false)
|
|
|
|
|
.Annotation("Sqlite:Autoincrement", true),
|
|
|
|
|
Agent = table.Column<int>(type: "INTEGER", nullable: false),
|
|
|
|
|
Enabled = table.Column<bool>(type: "INTEGER", nullable: false),
|
|
|
|
|
Message = table.Column<string>(type: "TEXT", nullable: true),
|
|
|
|
|
NotificationType = table.Column<int>(type: "INTEGER", nullable: false),
|
|
|
|
|
Subject = table.Column<string>(type: "TEXT", nullable: true)
|
|
|
|
|
},
|
|
|
|
|
constraints: table =>
|
|
|
|
|
{
|
|
|
|
|
table.PrimaryKey("PK_NotificationTemplates", x => x.Id);
|
|
|
|
|
});
|
|
|
|
|
|
|
|
|
|
migrationBuilder.CreateTable(
|
|
|
|
|
name: "PlexServerContent",
|
|
|
|
|
columns: table => new
|
|
|
|
|
{
|
|
|
|
|
Id = table.Column<int>(type: "INTEGER", nullable: false)
|
|
|
|
|
.Annotation("Sqlite:Autoincrement", true),
|
|
|
|
|
AddedAt = table.Column<DateTime>(type: "TEXT", nullable: false),
|
|
|
|
|
ImdbId = table.Column<string>(type: "TEXT", nullable: true),
|
|
|
|
|
Key = table.Column<int>(type: "INTEGER", nullable: false),
|
|
|
|
|
Quality = table.Column<string>(type: "TEXT", nullable: true),
|
|
|
|
|
ReleaseYear = table.Column<string>(type: "TEXT", nullable: true),
|
|
|
|
|
TheMovieDbId = table.Column<string>(type: "TEXT", nullable: true),
|
|
|
|
|
Title = table.Column<string>(type: "TEXT", nullable: true),
|
|
|
|
|
TvDbId = table.Column<string>(type: "TEXT", nullable: true),
|
|
|
|
|
Type = table.Column<int>(type: "INTEGER", nullable: false),
|
|
|
|
|
Url = table.Column<string>(type: "TEXT", nullable: true)
|
|
|
|
|
},
|
|
|
|
|
constraints: table =>
|
|
|
|
|
{
|
|
|
|
|
table.PrimaryKey("PK_PlexServerContent", x => x.Id);
|
|
|
|
|
table.UniqueConstraint("AK_PlexServerContent_Key", x => x.Key);
|
|
|
|
|
});
|
|
|
|
|
|
|
|
|
|
migrationBuilder.CreateTable(
|
|
|
|
|
name: "RadarrCache",
|
|
|
|
|
columns: table => new
|
|
|
|
|
{
|
|
|
|
|
Id = table.Column<int>(type: "INTEGER", nullable: false)
|
|
|
|
|
.Annotation("Sqlite:Autoincrement", true),
|
|
|
|
|
TheMovieDbId = table.Column<int>(type: "INTEGER", nullable: false)
|
|
|
|
|
},
|
|
|
|
|
constraints: table =>
|
|
|
|
|
{
|
|
|
|
|
table.PrimaryKey("PK_RadarrCache", x => x.Id);
|
|
|
|
|
});
|
|
|
|
|
|
|
|
|
|
migrationBuilder.CreateTable(
|
|
|
|
|
name: "SonarrCache",
|
|
|
|
|
columns: table => new
|
|
|
|
|
{
|
|
|
|
|
Id = table.Column<int>(type: "INTEGER", nullable: false)
|
|
|
|
|
.Annotation("Sqlite:Autoincrement", true),
|
|
|
|
|
TvDbId = table.Column<int>(type: "INTEGER", nullable: false)
|
|
|
|
|
},
|
|
|
|
|
constraints: table =>
|
|
|
|
|
{
|
|
|
|
|
table.PrimaryKey("PK_SonarrCache", x => x.Id);
|
|
|
|
|
});
|
|
|
|
|
|
|
|
|
|
migrationBuilder.CreateTable(
|
|
|
|
|
name: "SonarrEpisodeCache",
|
|
|
|
|
columns: table => new
|
|
|
|
|
{
|
|
|
|
|
Id = table.Column<int>(type: "INTEGER", nullable: false)
|
|
|
|
|
.Annotation("Sqlite:Autoincrement", true),
|
|
|
|
|
EpisodeNumber = table.Column<int>(type: "INTEGER", nullable: false),
|
|
|
|
|
SeasonNumber = table.Column<int>(type: "INTEGER", nullable: false),
|
|
|
|
|
TvDbId = table.Column<int>(type: "INTEGER", nullable: false)
|
|
|
|
|
},
|
|
|
|
|
constraints: table =>
|
|
|
|
|
{
|
|
|
|
|
table.PrimaryKey("PK_SonarrEpisodeCache", x => x.Id);
|
|
|
|
|
});
|
|
|
|
|
|
|
|
|
|
migrationBuilder.CreateTable(
|
|
|
|
|
name: "TvRequests",
|
|
|
|
|
columns: table => new
|
|
|
|
|
{
|
|
|
|
|
Id = table.Column<int>(type: "INTEGER", nullable: false)
|
|
|
|
|
.Annotation("Sqlite:Autoincrement", true),
|
|
|
|
|
ImdbId = table.Column<string>(type: "TEXT", nullable: true),
|
|
|
|
|
Overview = table.Column<string>(type: "TEXT", nullable: true),
|
|
|
|
|
PosterPath = table.Column<string>(type: "TEXT", nullable: true),
|
|
|
|
|
ReleaseDate = table.Column<DateTime>(type: "TEXT", nullable: false),
|
|
|
|
|
RootFolder = table.Column<int>(type: "INTEGER", nullable: true),
|
|
|
|
|
Status = table.Column<string>(type: "TEXT", nullable: true),
|
|
|
|
|
Title = table.Column<string>(type: "TEXT", nullable: true),
|
|
|
|
|
TvDbId = table.Column<int>(type: "INTEGER", nullable: false)
|
|
|
|
|
},
|
|
|
|
|
constraints: table =>
|
|
|
|
|
{
|
|
|
|
|
table.PrimaryKey("PK_TvRequests", x => x.Id);
|
|
|
|
|
});
|
|
|
|
|
|
|
|
|
|
migrationBuilder.CreateTable(
|
|
|
|
|
name: "AspNetRoleClaims",
|
|
|
|
|
columns: table => new
|
|
|
|
|
{
|
|
|
|
|
Id = table.Column<int>(type: "INTEGER", nullable: false)
|
|
|
|
|
.Annotation("Sqlite:Autoincrement", true),
|
|
|
|
|
ClaimType = table.Column<string>(type: "TEXT", nullable: true),
|
|
|
|
|
ClaimValue = table.Column<string>(type: "TEXT", nullable: true),
|
|
|
|
|
RoleId = table.Column<string>(type: "TEXT", nullable: false)
|
|
|
|
|
},
|
|
|
|
|
constraints: table =>
|
|
|
|
|
{
|
|
|
|
|
table.PrimaryKey("PK_AspNetRoleClaims", x => x.Id);
|
|
|
|
|
table.ForeignKey(
|
|
|
|
|
name: "FK_AspNetRoleClaims_AspNetRoles_RoleId",
|
|
|
|
|
column: x => x.RoleId,
|
|
|
|
|
principalTable: "AspNetRoles",
|
|
|
|
|
principalColumn: "Id",
|
|
|
|
|
onDelete: ReferentialAction.Cascade);
|
|
|
|
|
});
|
|
|
|
|
|
|
|
|
|
migrationBuilder.CreateTable(
|
|
|
|
|
name: "AspNetUserClaims",
|
|
|
|
|
columns: table => new
|
|
|
|
|
{
|
|
|
|
|
Id = table.Column<int>(type: "INTEGER", nullable: false)
|
|
|
|
|
.Annotation("Sqlite:Autoincrement", true),
|
|
|
|
|
ClaimType = table.Column<string>(type: "TEXT", nullable: true),
|
|
|
|
|
ClaimValue = table.Column<string>(type: "TEXT", nullable: true),
|
|
|
|
|
UserId = table.Column<string>(type: "TEXT", nullable: false)
|
|
|
|
|
},
|
|
|
|
|
constraints: table =>
|
|
|
|
|
{
|
|
|
|
|
table.PrimaryKey("PK_AspNetUserClaims", x => x.Id);
|
|
|
|
|
table.ForeignKey(
|
|
|
|
|
name: "FK_AspNetUserClaims_AspNetUsers_UserId",
|
|
|
|
|
column: x => x.UserId,
|
|
|
|
|
principalTable: "AspNetUsers",
|
|
|
|
|
principalColumn: "Id",
|
|
|
|
|
onDelete: ReferentialAction.Cascade);
|
|
|
|
|
});
|
|
|
|
|
|
|
|
|
|
migrationBuilder.CreateTable(
|
|
|
|
|
name: "AspNetUserLogins",
|
|
|
|
|
columns: table => new
|
|
|
|
|
{
|
|
|
|
|
LoginProvider = table.Column<string>(type: "TEXT", nullable: false),
|
|
|
|
|
ProviderKey = table.Column<string>(type: "TEXT", nullable: false),
|
|
|
|
|
ProviderDisplayName = table.Column<string>(type: "TEXT", nullable: true),
|
|
|
|
|
UserId = table.Column<string>(type: "TEXT", nullable: false)
|
|
|
|
|
},
|
|
|
|
|
constraints: table =>
|
|
|
|
|
{
|
|
|
|
|
table.PrimaryKey("PK_AspNetUserLogins", x => new { x.LoginProvider, x.ProviderKey });
|
|
|
|
|
table.ForeignKey(
|
|
|
|
|
name: "FK_AspNetUserLogins_AspNetUsers_UserId",
|
|
|
|
|
column: x => x.UserId,
|
|
|
|
|
principalTable: "AspNetUsers",
|
|
|
|
|
principalColumn: "Id",
|
|
|
|
|
onDelete: ReferentialAction.Cascade);
|
|
|
|
|
});
|
|
|
|
|
|
|
|
|
|
migrationBuilder.CreateTable(
|
|
|
|
|
name: "AspNetUserRoles",
|
|
|
|
|
columns: table => new
|
|
|
|
|
{
|
|
|
|
|
UserId = table.Column<string>(type: "TEXT", nullable: false),
|
|
|
|
|
RoleId = table.Column<string>(type: "TEXT", nullable: false)
|
|
|
|
|
},
|
|
|
|
|
constraints: table =>
|
|
|
|
|
{
|
|
|
|
|
table.PrimaryKey("PK_AspNetUserRoles", x => new { x.UserId, x.RoleId });
|
|
|
|
|
table.ForeignKey(
|
|
|
|
|
name: "FK_AspNetUserRoles_AspNetRoles_RoleId",
|
|
|
|
|
column: x => x.RoleId,
|
|
|
|
|
principalTable: "AspNetRoles",
|
|
|
|
|
principalColumn: "Id",
|
|
|
|
|
onDelete: ReferentialAction.Cascade);
|
|
|
|
|
table.ForeignKey(
|
|
|
|
|
name: "FK_AspNetUserRoles_AspNetUsers_UserId",
|
|
|
|
|
column: x => x.UserId,
|
|
|
|
|
principalTable: "AspNetUsers",
|
|
|
|
|
principalColumn: "Id",
|
|
|
|
|
onDelete: ReferentialAction.Cascade);
|
|
|
|
|
});
|
|
|
|
|
|
|
|
|
|
migrationBuilder.CreateTable(
|
|
|
|
|
name: "AspNetUserTokens",
|
|
|
|
|
columns: table => new
|
|
|
|
|
{
|
|
|
|
|
UserId = table.Column<string>(type: "TEXT", nullable: false),
|
|
|
|
|
LoginProvider = table.Column<string>(type: "TEXT", nullable: false),
|
|
|
|
|
Name = table.Column<string>(type: "TEXT", nullable: false),
|
|
|
|
|
Value = table.Column<string>(type: "TEXT", nullable: true)
|
|
|
|
|
},
|
|
|
|
|
constraints: table =>
|
|
|
|
|
{
|
|
|
|
|
table.PrimaryKey("PK_AspNetUserTokens", x => new { x.UserId, x.LoginProvider, x.Name });
|
|
|
|
|
table.ForeignKey(
|
|
|
|
|
name: "FK_AspNetUserTokens_AspNetUsers_UserId",
|
|
|
|
|
column: x => x.UserId,
|
|
|
|
|
principalTable: "AspNetUsers",
|
|
|
|
|
principalColumn: "Id",
|
|
|
|
|
onDelete: ReferentialAction.Cascade);
|
|
|
|
|
});
|
|
|
|
|
|
|
|
|
|
migrationBuilder.CreateTable(
|
|
|
|
|
name: "MovieRequests",
|
|
|
|
|
columns: table => new
|
|
|
|
|
{
|
|
|
|
|
Id = table.Column<int>(type: "INTEGER", nullable: false)
|
|
|
|
|
.Annotation("Sqlite:Autoincrement", true),
|
|
|
|
|
Approved = table.Column<bool>(type: "INTEGER", nullable: false),
|
|
|
|
|
Available = table.Column<bool>(type: "INTEGER", nullable: false),
|
|
|
|
|
Denied = table.Column<bool>(type: "INTEGER", nullable: true),
|
|
|
|
|
DeniedReason = table.Column<string>(type: "TEXT", nullable: true),
|
|
|
|
|
ImdbId = table.Column<string>(type: "TEXT", nullable: true),
|
|
|
|
|
IssueId = table.Column<int>(type: "INTEGER", nullable: true),
|
|
|
|
|
Overview = table.Column<string>(type: "TEXT", nullable: true),
|
|
|
|
|
PosterPath = table.Column<string>(type: "TEXT", nullable: true),
|
|
|
|
|
QualityOverride = table.Column<int>(type: "INTEGER", nullable: false),
|
|
|
|
|
ReleaseDate = table.Column<DateTime>(type: "TEXT", nullable: false),
|
|
|
|
|
RequestType = table.Column<int>(type: "INTEGER", nullable: false),
|
|
|
|
|
RequestedDate = table.Column<DateTime>(type: "TEXT", nullable: false),
|
|
|
|
|
RequestedUserId = table.Column<string>(type: "TEXT", nullable: true),
|
|
|
|
|
RootPathOverride = table.Column<int>(type: "INTEGER", nullable: false),
|
|
|
|
|
Status = table.Column<string>(type: "TEXT", nullable: true),
|
|
|
|
|
TheMovieDbId = table.Column<int>(type: "INTEGER", nullable: false),
|
|
|
|
|
Title = table.Column<string>(type: "TEXT", nullable: true)
|
|
|
|
|
},
|
|
|
|
|
constraints: table =>
|
|
|
|
|
{
|
|
|
|
|
table.PrimaryKey("PK_MovieRequests", x => x.Id);
|
|
|
|
|
table.ForeignKey(
|
|
|
|
|
name: "FK_MovieRequests_AspNetUsers_RequestedUserId",
|
|
|
|
|
column: x => x.RequestedUserId,
|
|
|
|
|
principalTable: "AspNetUsers",
|
|
|
|
|
principalColumn: "Id",
|
|
|
|
|
onDelete: ReferentialAction.Restrict);
|
|
|
|
|
});
|
|
|
|
|
|
|
|
|
|
migrationBuilder.CreateTable(
|
|
|
|
|
name: "Tokens",
|
|
|
|
|
columns: table => new
|
|
|
|
|
{
|
|
|
|
|
Id = table.Column<int>(type: "INTEGER", nullable: false)
|
|
|
|
|
.Annotation("Sqlite:Autoincrement", true),
|
|
|
|
|
Token = table.Column<string>(type: "TEXT", nullable: true),
|
|
|
|
|
UserId = table.Column<string>(type: "TEXT", nullable: true)
|
|
|
|
|
},
|
|
|
|
|
constraints: table =>
|
|
|
|
|
{
|
|
|
|
|
table.PrimaryKey("PK_Tokens", x => x.Id);
|
|
|
|
|
table.ForeignKey(
|
|
|
|
|
name: "FK_Tokens_AspNetUsers_UserId",
|
|
|
|
|
column: x => x.UserId,
|
|
|
|
|
principalTable: "AspNetUsers",
|
|
|
|
|
principalColumn: "Id",
|
|
|
|
|
onDelete: ReferentialAction.Restrict);
|
|
|
|
|
});
|
|
|
|
|
|
|
|
|
|
migrationBuilder.CreateTable(
|
|
|
|
|
name: "EmbyEpisode",
|
|
|
|
|
columns: table => new
|
|
|
|
|
{
|
|
|
|
|
Id = table.Column<int>(type: "INTEGER", nullable: false)
|
|
|
|
|
.Annotation("Sqlite:Autoincrement", true),
|
|
|
|
|
AddedAt = table.Column<DateTime>(type: "TEXT", nullable: false),
|
|
|
|
|
EmbyId = table.Column<string>(type: "TEXT", nullable: true),
|
|
|
|
|
EpisodeNumber = table.Column<int>(type: "INTEGER", nullable: false),
|
|
|
|
|
ParentId = table.Column<string>(type: "TEXT", nullable: true),
|
|
|
|
|
ProviderId = table.Column<string>(type: "TEXT", nullable: true),
|
|
|
|
|
SeasonNumber = table.Column<int>(type: "INTEGER", nullable: false),
|
|
|
|
|
Title = table.Column<string>(type: "TEXT", nullable: true)
|
|
|
|
|
},
|
|
|
|
|
constraints: table =>
|
|
|
|
|
{
|
|
|
|
|
table.PrimaryKey("PK_EmbyEpisode", x => x.Id);
|
|
|
|
|
table.ForeignKey(
|
|
|
|
|
name: "FK_EmbyEpisode_EmbyContent_ParentId",
|
|
|
|
|
column: x => x.ParentId,
|
|
|
|
|
principalTable: "EmbyContent",
|
|
|
|
|
principalColumn: "EmbyId",
|
|
|
|
|
onDelete: ReferentialAction.Restrict);
|
|
|
|
|
});
|
|
|
|
|
|
|
|
|
|
migrationBuilder.CreateTable(
|
|
|
|
|
name: "PlexEpisode",
|
|
|
|
|
columns: table => new
|
|
|
|
|
{
|
|
|
|
|
Id = table.Column<int>(type: "INTEGER", nullable: false)
|
|
|
|
|
.Annotation("Sqlite:Autoincrement", true),
|
|
|
|
|
EpisodeNumber = table.Column<int>(type: "INTEGER", nullable: false),
|
|
|
|
|
GrandparentKey = table.Column<int>(type: "INTEGER", nullable: false),
|
|
|
|
|
Key = table.Column<int>(type: "INTEGER", nullable: false),
|
|
|
|
|
ParentKey = table.Column<int>(type: "INTEGER", nullable: false),
|
|
|
|
|
SeasonNumber = table.Column<int>(type: "INTEGER", nullable: false),
|
|
|
|
|
Title = table.Column<string>(type: "TEXT", nullable: true)
|
|
|
|
|
},
|
|
|
|
|
constraints: table =>
|
|
|
|
|
{
|
|
|
|
|
table.PrimaryKey("PK_PlexEpisode", x => x.Id);
|
|
|
|
|
table.ForeignKey(
|
|
|
|
|
name: "FK_PlexEpisode_PlexServerContent_GrandparentKey",
|
|
|
|
|
column: x => x.GrandparentKey,
|
|
|
|
|
principalTable: "PlexServerContent",
|
|
|
|
|
principalColumn: "Key",
|
|
|
|
|
onDelete: ReferentialAction.Cascade);
|
|
|
|
|
});
|
|
|
|
|
|
|
|
|
|
migrationBuilder.CreateTable(
|
|
|
|
|
name: "PlexSeasonsContent",
|
|
|
|
|
columns: table => new
|
|
|
|
|
{
|
|
|
|
|
Id = table.Column<int>(type: "INTEGER", nullable: false)
|
|
|
|
|
.Annotation("Sqlite:Autoincrement", true),
|
|
|
|
|
ParentKey = table.Column<int>(type: "INTEGER", nullable: false),
|
|
|
|
|
PlexContentId = table.Column<int>(type: "INTEGER", nullable: false),
|
|
|
|
|
PlexServerContentId = table.Column<int>(type: "INTEGER", nullable: true),
|
|
|
|
|
SeasonKey = table.Column<int>(type: "INTEGER", nullable: false),
|
|
|
|
|
SeasonNumber = table.Column<int>(type: "INTEGER", nullable: false)
|
|
|
|
|
},
|
|
|
|
|
constraints: table =>
|
|
|
|
|
{
|
|
|
|
|
table.PrimaryKey("PK_PlexSeasonsContent", x => x.Id);
|
|
|
|
|
table.ForeignKey(
|
|
|
|
|
name: "FK_PlexSeasonsContent_PlexServerContent_PlexServerContentId",
|
|
|
|
|
column: x => x.PlexServerContentId,
|
|
|
|
|
principalTable: "PlexServerContent",
|
|
|
|
|
principalColumn: "Id",
|
|
|
|
|
onDelete: ReferentialAction.Restrict);
|
|
|
|
|
});
|
|
|
|
|
|
|
|
|
|
migrationBuilder.CreateTable(
|
|
|
|
|
name: "ChildRequests",
|
|
|
|
|
columns: table => new
|
|
|
|
|
{
|
|
|
|
|
Id = table.Column<int>(type: "INTEGER", nullable: false)
|
|
|
|
|
.Annotation("Sqlite:Autoincrement", true),
|
|
|
|
|
Approved = table.Column<bool>(type: "INTEGER", nullable: false),
|
|
|
|
|
Available = table.Column<bool>(type: "INTEGER", nullable: false),
|
|
|
|
|
Denied = table.Column<bool>(type: "INTEGER", nullable: true),
|
|
|
|
|
DeniedReason = table.Column<string>(type: "TEXT", nullable: true),
|
|
|
|
|
IssueId = table.Column<int>(type: "INTEGER", nullable: true),
|
|
|
|
|
ParentRequestId = table.Column<int>(type: "INTEGER", nullable: false),
|
|
|
|
|
RequestType = table.Column<int>(type: "INTEGER", nullable: false),
|
|
|
|
|
RequestedDate = table.Column<DateTime>(type: "TEXT", nullable: false),
|
|
|
|
|
RequestedUserId = table.Column<string>(type: "TEXT", nullable: true),
|
|
|
|
|
Title = table.Column<string>(type: "TEXT", nullable: true)
|
|
|
|
|
},
|
|
|
|
|
constraints: table =>
|
|
|
|
|
{
|
|
|
|
|
table.PrimaryKey("PK_ChildRequests", x => x.Id);
|
|
|
|
|
table.ForeignKey(
|
|
|
|
|
name: "FK_ChildRequests_TvRequests_ParentRequestId",
|
|
|
|
|
column: x => x.ParentRequestId,
|
|
|
|
|
principalTable: "TvRequests",
|
|
|
|
|
principalColumn: "Id",
|
|
|
|
|
onDelete: ReferentialAction.Cascade);
|
|
|
|
|
table.ForeignKey(
|
|
|
|
|
name: "FK_ChildRequests_AspNetUsers_RequestedUserId",
|
|
|
|
|
column: x => x.RequestedUserId,
|
|
|
|
|
principalTable: "AspNetUsers",
|
|
|
|
|
principalColumn: "Id",
|
|
|
|
|
onDelete: ReferentialAction.Restrict);
|
|
|
|
|
});
|
|
|
|
|
|
|
|
|
|
migrationBuilder.CreateTable(
|
|
|
|
|
name: "MovieIssues",
|
|
|
|
|
columns: table => new
|
|
|
|
|
{
|
|
|
|
|
Id = table.Column<int>(type: "INTEGER", nullable: false)
|
|
|
|
|
.Annotation("Sqlite:Autoincrement", true),
|
|
|
|
|
Description = table.Column<string>(type: "TEXT", nullable: true),
|
|
|
|
|
IssueId = table.Column<int>(type: "INTEGER", nullable: true),
|
|
|
|
|
MovieId = table.Column<int>(type: "INTEGER", nullable: false),
|
|
|
|
|
Subject = table.Column<string>(type: "TEXT", nullable: true)
|
|
|
|
|
},
|
|
|
|
|
constraints: table =>
|
|
|
|
|
{
|
|
|
|
|
table.PrimaryKey("PK_MovieIssues", x => x.Id);
|
|
|
|
|
table.ForeignKey(
|
|
|
|
|
name: "FK_MovieIssues_MovieRequests_IssueId",
|
|
|
|
|
column: x => x.IssueId,
|
|
|
|
|
principalTable: "MovieRequests",
|
|
|
|
|
principalColumn: "Id",
|
|
|
|
|
onDelete: ReferentialAction.Restrict);
|
|
|
|
|
table.ForeignKey(
|
|
|
|
|
name: "FK_MovieIssues_MovieRequests_MovieId",
|
|
|
|
|
column: x => x.MovieId,
|
|
|
|
|
principalTable: "MovieRequests",
|
|
|
|
|
principalColumn: "Id",
|
|
|
|
|
onDelete: ReferentialAction.Cascade);
|
|
|
|
|
});
|
|
|
|
|
|
|
|
|
|
migrationBuilder.CreateTable(
|
|
|
|
|
name: "SeasonRequests",
|
|
|
|
|
columns: table => new
|
|
|
|
|
{
|
|
|
|
|
Id = table.Column<int>(type: "INTEGER", nullable: false)
|
|
|
|
|
.Annotation("Sqlite:Autoincrement", true),
|
|
|
|
|
ChildRequestId = table.Column<int>(type: "INTEGER", nullable: false),
|
|
|
|
|
SeasonNumber = table.Column<int>(type: "INTEGER", nullable: false)
|
|
|
|
|
},
|
|
|
|
|
constraints: table =>
|
|
|
|
|
{
|
|
|
|
|
table.PrimaryKey("PK_SeasonRequests", x => x.Id);
|
|
|
|
|
table.ForeignKey(
|
|
|
|
|
name: "FK_SeasonRequests_ChildRequests_ChildRequestId",
|
|
|
|
|
column: x => x.ChildRequestId,
|
|
|
|
|
principalTable: "ChildRequests",
|
|
|
|
|
principalColumn: "Id",
|
|
|
|
|
onDelete: ReferentialAction.Cascade);
|
|
|
|
|
});
|
|
|
|
|
|
|
|
|
|
migrationBuilder.CreateTable(
|
|
|
|
|
name: "TvIssues",
|
|
|
|
|
columns: table => new
|
|
|
|
|
{
|
|
|
|
|
Id = table.Column<int>(type: "INTEGER", nullable: false)
|
|
|
|
|
.Annotation("Sqlite:Autoincrement", true),
|
|
|
|
|
Description = table.Column<string>(type: "TEXT", nullable: true),
|
|
|
|
|
IssueId = table.Column<int>(type: "INTEGER", nullable: true),
|
|
|
|
|
Subject = table.Column<string>(type: "TEXT", nullable: true),
|
|
|
|
|
TvId = table.Column<int>(type: "INTEGER", nullable: false)
|
|
|
|
|
},
|
|
|
|
|
constraints: table =>
|
|
|
|
|
{
|
|
|
|
|
table.PrimaryKey("PK_TvIssues", x => x.Id);
|
|
|
|
|
table.ForeignKey(
|
|
|
|
|
name: "FK_TvIssues_ChildRequests_IssueId",
|
|
|
|
|
column: x => x.IssueId,
|
|
|
|
|
principalTable: "ChildRequests",
|
|
|
|
|
principalColumn: "Id",
|
|
|
|
|
onDelete: ReferentialAction.Restrict);
|
|
|
|
|
table.ForeignKey(
|
|
|
|
|
name: "FK_TvIssues_ChildRequests_TvId",
|
|
|
|
|
column: x => x.TvId,
|
|
|
|
|
principalTable: "ChildRequests",
|
|
|
|
|
principalColumn: "Id",
|
|
|
|
|
onDelete: ReferentialAction.Cascade);
|
|
|
|
|
});
|
|
|
|
|
|
|
|
|
|
migrationBuilder.CreateTable(
|
|
|
|
|
name: "EpisodeRequests",
|
|
|
|
|
columns: table => new
|
|
|
|
|
{
|
|
|
|
|
Id = table.Column<int>(type: "INTEGER", nullable: false)
|
|
|
|
|
.Annotation("Sqlite:Autoincrement", true),
|
|
|
|
|
AirDate = table.Column<DateTime>(type: "TEXT", nullable: false),
|
|
|
|
|
Approved = table.Column<bool>(type: "INTEGER", nullable: false),
|
|
|
|
|
Available = table.Column<bool>(type: "INTEGER", nullable: false),
|
|
|
|
|
EpisodeNumber = table.Column<int>(type: "INTEGER", nullable: false),
|
|
|
|
|
Requested = table.Column<bool>(type: "INTEGER", nullable: false),
|
|
|
|
|
SeasonId = table.Column<int>(type: "INTEGER", nullable: false),
|
|
|
|
|
Title = table.Column<string>(type: "TEXT", nullable: true),
|
|
|
|
|
Url = table.Column<string>(type: "TEXT", nullable: true)
|
|
|
|
|
},
|
|
|
|
|
constraints: table =>
|
|
|
|
|
{
|
|
|
|
|
table.PrimaryKey("PK_EpisodeRequests", x => x.Id);
|
|
|
|
|
table.ForeignKey(
|
|
|
|
|
name: "FK_EpisodeRequests_SeasonRequests_SeasonId",
|
|
|
|
|
column: x => x.SeasonId,
|
|
|
|
|
principalTable: "SeasonRequests",
|
|
|
|
|
principalColumn: "Id",
|
|
|
|
|
onDelete: ReferentialAction.Cascade);
|
|
|
|
|
});
|
|
|
|
|
|
|
|
|
|
migrationBuilder.CreateIndex(
|
|
|
|
|
name: "IX_AspNetRoleClaims_RoleId",
|
|
|
|
|
table: "AspNetRoleClaims",
|
|
|
|
|
column: "RoleId");
|
|
|
|
|
|
|
|
|
|
migrationBuilder.CreateIndex(
|
|
|
|
|
name: "RoleNameIndex",
|
|
|
|
|
table: "AspNetRoles",
|
|
|
|
|
column: "NormalizedName",
|
|
|
|
|
unique: true);
|
|
|
|
|
|
|
|
|
|
migrationBuilder.CreateIndex(
|
|
|
|
|
name: "IX_AspNetUserClaims_UserId",
|
|
|
|
|
table: "AspNetUserClaims",
|
|
|
|
|
column: "UserId");
|
|
|
|
|
|
|
|
|
|
migrationBuilder.CreateIndex(
|
|
|
|
|
name: "IX_AspNetUserLogins_UserId",
|
|
|
|
|
table: "AspNetUserLogins",
|
|
|
|
|
column: "UserId");
|
|
|
|
|
|
|
|
|
|
migrationBuilder.CreateIndex(
|
|
|
|
|
name: "IX_AspNetUserRoles_RoleId",
|
|
|
|
|
table: "AspNetUserRoles",
|
|
|
|
|
column: "RoleId");
|
|
|
|
|
|
|
|
|
|
migrationBuilder.CreateIndex(
|
|
|
|
|
name: "EmailIndex",
|
|
|
|
|
table: "AspNetUsers",
|
|
|
|
|
column: "NormalizedEmail");
|
|
|
|
|
|
|
|
|
|
migrationBuilder.CreateIndex(
|
|
|
|
|
name: "UserNameIndex",
|
|
|
|
|
table: "AspNetUsers",
|
|
|
|
|
column: "NormalizedUserName",
|
|
|
|
|
unique: true);
|
|
|
|
|
|
|
|
|
|
migrationBuilder.CreateIndex(
|
|
|
|
|
name: "IX_ChildRequests_ParentRequestId",
|
|
|
|
|
table: "ChildRequests",
|
|
|
|
|
column: "ParentRequestId");
|
|
|
|
|
|
|
|
|
|
migrationBuilder.CreateIndex(
|
|
|
|
|
name: "IX_ChildRequests_RequestedUserId",
|
|
|
|
|
table: "ChildRequests",
|
|
|
|
|
column: "RequestedUserId");
|
|
|
|
|
|
|
|
|
|
migrationBuilder.CreateIndex(
|
|
|
|
|
name: "IX_EmbyEpisode_ParentId",
|
|
|
|
|
table: "EmbyEpisode",
|
|
|
|
|
column: "ParentId");
|
|
|
|
|
|
|
|
|
|
migrationBuilder.CreateIndex(
|
|
|
|
|
name: "IX_EpisodeRequests_SeasonId",
|
|
|
|
|
table: "EpisodeRequests",
|
|
|
|
|
column: "SeasonId");
|
|
|
|
|
|
|
|
|
|
migrationBuilder.CreateIndex(
|
|
|
|
|
name: "IX_MovieIssues_IssueId",
|
|
|
|
|
table: "MovieIssues",
|
|
|
|
|
column: "IssueId");
|
|
|
|
|
|
|
|
|
|
migrationBuilder.CreateIndex(
|
|
|
|
|
name: "IX_MovieIssues_MovieId",
|
|
|
|
|
table: "MovieIssues",
|
|
|
|
|
column: "MovieId");
|
|
|
|
|
|
|
|
|
|
migrationBuilder.CreateIndex(
|
|
|
|
|
name: "IX_MovieRequests_RequestedUserId",
|
|
|
|
|
table: "MovieRequests",
|
|
|
|
|
column: "RequestedUserId");
|
|
|
|
|
|
|
|
|
|
migrationBuilder.CreateIndex(
|
|
|
|
|
name: "IX_PlexEpisode_GrandparentKey",
|
|
|
|
|
table: "PlexEpisode",
|
|
|
|
|
column: "GrandparentKey");
|
|
|
|
|
|
|
|
|
|
migrationBuilder.CreateIndex(
|
|
|
|
|
name: "IX_PlexSeasonsContent_PlexServerContentId",
|
|
|
|
|
table: "PlexSeasonsContent",
|
|
|
|
|
column: "PlexServerContentId");
|
|
|
|
|
|
|
|
|
|
migrationBuilder.CreateIndex(
|
|
|
|
|
name: "IX_SeasonRequests_ChildRequestId",
|
|
|
|
|
table: "SeasonRequests",
|
|
|
|
|
column: "ChildRequestId");
|
|
|
|
|
|
|
|
|
|
migrationBuilder.CreateIndex(
|
|
|
|
|
name: "IX_Tokens_UserId",
|
|
|
|
|
table: "Tokens",
|
|
|
|
|
column: "UserId");
|
|
|
|
|
|
|
|
|
|
migrationBuilder.CreateIndex(
|
|
|
|
|
name: "IX_TvIssues_IssueId",
|
|
|
|
|
table: "TvIssues",
|
|
|
|
|
column: "IssueId");
|
|
|
|
|
|
|
|
|
|
migrationBuilder.CreateIndex(
|
|
|
|
|
name: "IX_TvIssues_TvId",
|
|
|
|
|
table: "TvIssues",
|
|
|
|
|
column: "TvId");
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
protected override void Down(MigrationBuilder migrationBuilder)
|
|
|
|
|
{
|
|
|
|
|
migrationBuilder.DropTable(
|
|
|
|
|
name: "ApplicationConfiguration");
|
|
|
|
|
|
|
|
|
|
migrationBuilder.DropTable(
|
|
|
|
|
name: "AspNetRoleClaims");
|
|
|
|
|
|
|
|
|
|
migrationBuilder.DropTable(
|
|
|
|
|
name: "AspNetUserClaims");
|
|
|
|
|
|
|
|
|
|
migrationBuilder.DropTable(
|
|
|
|
|
name: "AspNetUserLogins");
|
|
|
|
|
|
|
|
|
|
migrationBuilder.DropTable(
|
|
|
|
|
name: "AspNetUserRoles");
|
|
|
|
|
|
|
|
|
|
migrationBuilder.DropTable(
|
|
|
|
|
name: "AspNetUserTokens");
|
|
|
|
|
|
|
|
|
|
migrationBuilder.DropTable(
|
|
|
|
|
name: "Audit");
|
|
|
|
|
|
|
|
|
|
migrationBuilder.DropTable(
|
|
|
|
|
name: "CouchPotatoCache");
|
|
|
|
|
|
|
|
|
|
migrationBuilder.DropTable(
|
|
|
|
|
name: "EmbyEpisode");
|
|
|
|
|
|
|
|
|
|
migrationBuilder.DropTable(
|
|
|
|
|
name: "EpisodeRequests");
|
|
|
|
|
|
|
|
|
|
migrationBuilder.DropTable(
|
|
|
|
|
name: "GlobalSettings");
|
|
|
|
|
|
|
|
|
|
migrationBuilder.DropTable(
|
|
|
|
|
name: "MovieIssues");
|
|
|
|
|
|
|
|
|
|
migrationBuilder.DropTable(
|
|
|
|
|
name: "NotificationTemplates");
|
|
|
|
|
|
|
|
|
|
migrationBuilder.DropTable(
|
|
|
|
|
name: "PlexEpisode");
|
|
|
|
|
|
|
|
|
|
migrationBuilder.DropTable(
|
|
|
|
|
name: "PlexSeasonsContent");
|
|
|
|
|
|
|
|
|
|
migrationBuilder.DropTable(
|
|
|
|
|
name: "RadarrCache");
|
|
|
|
|
|
|
|
|
|
migrationBuilder.DropTable(
|
|
|
|
|
name: "SonarrCache");
|
|
|
|
|
|
|
|
|
|
migrationBuilder.DropTable(
|
|
|
|
|
name: "SonarrEpisodeCache");
|
|
|
|
|
|
|
|
|
|
migrationBuilder.DropTable(
|
|
|
|
|
name: "Tokens");
|
|
|
|
|
|
|
|
|
|
migrationBuilder.DropTable(
|
|
|
|
|
name: "TvIssues");
|
|
|
|
|
|
|
|
|
|
migrationBuilder.DropTable(
|
|
|
|
|
name: "AspNetRoles");
|
|
|
|
|
|
|
|
|
|
migrationBuilder.DropTable(
|
|
|
|
|
name: "EmbyContent");
|
|
|
|
|
|
|
|
|
|
migrationBuilder.DropTable(
|
|
|
|
|
name: "SeasonRequests");
|
|
|
|
|
|
|
|
|
|
migrationBuilder.DropTable(
|
|
|
|
|
name: "MovieRequests");
|
|
|
|
|
|
|
|
|
|
migrationBuilder.DropTable(
|
|
|
|
|
name: "PlexServerContent");
|
|
|
|
|
|
|
|
|
|
migrationBuilder.DropTable(
|
|
|
|
|
name: "ChildRequests");
|
|
|
|
|
|
|
|
|
|
migrationBuilder.DropTable(
|
|
|
|
|
name: "TvRequests");
|
|
|
|
|
|
|
|
|
|
migrationBuilder.DropTable(
|
|
|
|
|
name: "AspNetUsers");
|
|
|
|
|
}
|
|
|
|
|
}
|
|
|
|
|
}
|