987 lines
56 KiB
C#
987 lines
56 KiB
C#
using System;
|
|
using Microsoft.EntityFrameworkCore.Metadata;
|
|
using Microsoft.EntityFrameworkCore.Migrations;
|
|
|
|
#nullable disable
|
|
|
|
namespace SystemRevivalServer.Migrations
|
|
{
|
|
/// <inheritdoc />
|
|
public partial class Initialize : Migration
|
|
{
|
|
/// <inheritdoc />
|
|
protected override void Up(MigrationBuilder migrationBuilder)
|
|
{
|
|
migrationBuilder.AlterDatabase()
|
|
.Annotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.CreateTable(
|
|
name: "accounts",
|
|
columns: table => new
|
|
{
|
|
Id = table.Column<ulong>(type: "bigint unsigned", nullable: false)
|
|
.Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
|
|
Username = table.Column<string>(type: "varchar(32)", maxLength: 32, nullable: false)
|
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
|
Email = table.Column<string>(type: "varchar(255)", maxLength: 255, nullable: true)
|
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
|
PasswordHash = table.Column<byte[]>(type: "varbinary(64)", nullable: false),
|
|
PasswordSalt = table.Column<byte[]>(type: "varbinary(32)", nullable: false),
|
|
IsBanned = table.Column<bool>(type: "tinyint(1)", nullable: false),
|
|
BannedUntil = table.Column<DateTime>(type: "datetime(6)", nullable: true),
|
|
Role = table.Column<int>(type: "int", nullable: false, defaultValue: 0),
|
|
CreatedAt = table.Column<DateTime>(type: "datetime(6)", nullable: false, defaultValueSql: "CURRENT_TIMESTAMP(6)"),
|
|
UpdatedAt = table.Column<DateTime>(type: "datetime(6)", nullable: false, defaultValueSql: "CURRENT_TIMESTAMP(6)")
|
|
.Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.ComputedColumn)
|
|
},
|
|
constraints: table =>
|
|
{
|
|
table.PrimaryKey("PK_accounts", x => x.Id);
|
|
})
|
|
.Annotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.CreateTable(
|
|
name: "dungeon_item_definitions",
|
|
columns: table => new
|
|
{
|
|
Id = table.Column<int>(type: "int", nullable: false)
|
|
.Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
|
|
Name = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: false)
|
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
|
Description = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: false)
|
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
|
Type = table.Column<int>(type: "int", nullable: false),
|
|
Rarity = table.Column<int>(type: "int", nullable: false),
|
|
EquipSlot = table.Column<int>(type: "int", nullable: true),
|
|
RequiredStrength = table.Column<int>(type: "int", nullable: false),
|
|
RequiredIntelligence = table.Column<int>(type: "int", nullable: false),
|
|
RequiredWisdom = table.Column<int>(type: "int", nullable: false),
|
|
RequiredDexterity = table.Column<int>(type: "int", nullable: false),
|
|
RequiredLevel = table.Column<int>(type: "int", nullable: false),
|
|
BonusStrength = table.Column<int>(type: "int", nullable: false),
|
|
BonusIntelligence = table.Column<int>(type: "int", nullable: false),
|
|
BonusWisdom = table.Column<int>(type: "int", nullable: false),
|
|
BonusEndurance = table.Column<int>(type: "int", nullable: false),
|
|
BonusDexterity = table.Column<int>(type: "int", nullable: false),
|
|
BonusHealth = table.Column<int>(type: "int", nullable: false),
|
|
BonusMana = table.Column<int>(type: "int", nullable: false),
|
|
MinDamage = table.Column<int>(type: "int", nullable: false),
|
|
MaxDamage = table.Column<int>(type: "int", nullable: false),
|
|
AttackRange = table.Column<float>(type: "float", nullable: false),
|
|
DamageType = table.Column<int>(type: "int", nullable: false),
|
|
Armor = table.Column<int>(type: "int", nullable: false),
|
|
MagicResist = table.Column<int>(type: "int", nullable: false),
|
|
HealAmount = table.Column<int>(type: "int", nullable: false),
|
|
ManaRestore = table.Column<int>(type: "int", nullable: false),
|
|
StaminaRestore = table.Column<int>(type: "int", nullable: false),
|
|
IsTeleportScroll = table.Column<bool>(type: "tinyint(1)", nullable: false),
|
|
TeachesSpellId = table.Column<int>(type: "int", nullable: true),
|
|
Stackable = table.Column<bool>(type: "tinyint(1)", nullable: false),
|
|
MaxStack = table.Column<int>(type: "int", nullable: false),
|
|
SpriteId = table.Column<int>(type: "int", nullable: false),
|
|
IsEnabled = table.Column<bool>(type: "tinyint(1)", nullable: false)
|
|
},
|
|
constraints: table =>
|
|
{
|
|
table.PrimaryKey("PK_dungeon_item_definitions", x => x.Id);
|
|
})
|
|
.Annotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.CreateTable(
|
|
name: "dungeon_loot_tables",
|
|
columns: table => new
|
|
{
|
|
Id = table.Column<int>(type: "int", nullable: false)
|
|
.Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
|
|
Name = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: false)
|
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
|
Description = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: false)
|
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
|
MinTier = table.Column<int>(type: "int", nullable: false),
|
|
MaxTier = table.Column<int>(type: "int", nullable: false),
|
|
DropChanceMultiplier = table.Column<float>(type: "float", nullable: false),
|
|
MinDrops = table.Column<int>(type: "int", nullable: false),
|
|
MaxDrops = table.Column<int>(type: "int", nullable: false),
|
|
GuaranteedDrop = table.Column<bool>(type: "tinyint(1)", nullable: false),
|
|
IsEnabled = table.Column<bool>(type: "tinyint(1)", nullable: false)
|
|
},
|
|
constraints: table =>
|
|
{
|
|
table.PrimaryKey("PK_dungeon_loot_tables", x => x.Id);
|
|
})
|
|
.Annotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.CreateTable(
|
|
name: "dungeon_mob_definitions",
|
|
columns: table => new
|
|
{
|
|
Id = table.Column<int>(type: "int", nullable: false)
|
|
.Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
|
|
Name = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: false)
|
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
|
Description = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: false)
|
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
|
Type = table.Column<int>(type: "int", nullable: false),
|
|
Category = table.Column<int>(type: "int", nullable: false),
|
|
MinTier = table.Column<int>(type: "int", nullable: false),
|
|
MaxTier = table.Column<int>(type: "int", nullable: false),
|
|
BaseHealth = table.Column<int>(type: "int", nullable: false),
|
|
BaseMana = table.Column<int>(type: "int", nullable: false),
|
|
BasePhysicalDamage = table.Column<int>(type: "int", nullable: false),
|
|
BaseMagicDamage = table.Column<int>(type: "int", nullable: false),
|
|
BaseArmor = table.Column<int>(type: "int", nullable: false),
|
|
BaseMagicResist = table.Column<int>(type: "int", nullable: false),
|
|
MoveSpeed = table.Column<float>(type: "float", nullable: false),
|
|
AttackRange = table.Column<float>(type: "float", nullable: false),
|
|
AttackSpeed = table.Column<float>(type: "float", nullable: false),
|
|
AggroRange = table.Column<float>(type: "float", nullable: false),
|
|
LeashRange = table.Column<float>(type: "float", nullable: false),
|
|
HealthPerTier = table.Column<float>(type: "float", nullable: false),
|
|
DamagePerTier = table.Column<float>(type: "float", nullable: false),
|
|
ArmorPerTier = table.Column<float>(type: "float", nullable: false),
|
|
BaseXp = table.Column<int>(type: "int", nullable: false),
|
|
XpPerTier = table.Column<float>(type: "float", nullable: false),
|
|
LootTableId = table.Column<int>(type: "int", nullable: false),
|
|
DropChanceMultiplier = table.Column<float>(type: "float", nullable: false),
|
|
ResistancesJson = table.Column<string>(type: "varchar(1024)", maxLength: 1024, nullable: false)
|
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
|
AbilitiesJson = table.Column<string>(type: "varchar(1024)", maxLength: 1024, nullable: false)
|
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
|
SpriteSheet = table.Column<string>(type: "varchar(128)", maxLength: 128, nullable: false)
|
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
|
SpriteIndex = table.Column<int>(type: "int", nullable: false),
|
|
SpriteWidth = table.Column<int>(type: "int", nullable: false),
|
|
SpriteHeight = table.Column<int>(type: "int", nullable: false),
|
|
TintColor = table.Column<string>(type: "varchar(16)", maxLength: 16, nullable: false)
|
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
|
IdleFrames = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: false)
|
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
|
WalkFrames = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: false)
|
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
|
AttackFrames = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: false)
|
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
|
DeathFrames = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: false)
|
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
|
AnimationSpeed = table.Column<float>(type: "float", nullable: false),
|
|
IsEnabled = table.Column<bool>(type: "tinyint(1)", nullable: false)
|
|
},
|
|
constraints: table =>
|
|
{
|
|
table.PrimaryKey("PK_dungeon_mob_definitions", x => x.Id);
|
|
})
|
|
.Annotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.CreateTable(
|
|
name: "dungeon_spell_definitions",
|
|
columns: table => new
|
|
{
|
|
Id = table.Column<int>(type: "int", nullable: false)
|
|
.Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
|
|
Name = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: false)
|
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
|
Description = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: false)
|
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
|
Type = table.Column<int>(type: "int", nullable: false),
|
|
RequiredWisdom = table.Column<int>(type: "int", nullable: false),
|
|
RequiredIntelligence = table.Column<int>(type: "int", nullable: false),
|
|
RequiredLevel = table.Column<int>(type: "int", nullable: false),
|
|
ManaCost = table.Column<int>(type: "int", nullable: false),
|
|
Cooldown = table.Column<float>(type: "float", nullable: false),
|
|
BaseDamage = table.Column<int>(type: "int", nullable: false),
|
|
BaseHealing = table.Column<int>(type: "int", nullable: false),
|
|
Range = table.Column<float>(type: "float", nullable: false),
|
|
AreaOfEffect = table.Column<float>(type: "float", nullable: false),
|
|
IsTeleport = table.Column<bool>(type: "tinyint(1)", nullable: false),
|
|
IsShield = table.Column<bool>(type: "tinyint(1)", nullable: false),
|
|
ShieldAmount = table.Column<int>(type: "int", nullable: false),
|
|
SpriteId = table.Column<int>(type: "int", nullable: false),
|
|
EffectColor = table.Column<string>(type: "longtext", nullable: false)
|
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
|
IsEnabled = table.Column<bool>(type: "tinyint(1)", nullable: false)
|
|
},
|
|
constraints: table =>
|
|
{
|
|
table.PrimaryKey("PK_dungeon_spell_definitions", x => x.Id);
|
|
})
|
|
.Annotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.CreateTable(
|
|
name: "game_items",
|
|
columns: table => new
|
|
{
|
|
Id = table.Column<int>(type: "int", nullable: false),
|
|
Name = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: false)
|
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
|
Category = table.Column<int>(type: "int", nullable: false),
|
|
CraftCost = table.Column<int>(type: "int", nullable: false),
|
|
Description = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: false)
|
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
|
LootValue = table.Column<int>(type: "int", nullable: false),
|
|
Stackable = table.Column<bool>(type: "tinyint(1)", nullable: false),
|
|
IsEnabled = table.Column<bool>(type: "tinyint(1)", nullable: false, defaultValue: true),
|
|
Damage = table.Column<int>(type: "int", nullable: false),
|
|
FireRate = table.Column<float>(type: "float", nullable: false),
|
|
ProjectileSpeed = table.Column<float>(type: "float", nullable: false),
|
|
Range = table.Column<float>(type: "float", nullable: false),
|
|
AmmoType = table.Column<int>(type: "int", nullable: false),
|
|
PelletCount = table.Column<int>(type: "int", nullable: false),
|
|
Spread = table.Column<float>(type: "float", nullable: false),
|
|
ExplosionRadius = table.Column<float>(type: "float", nullable: false),
|
|
HarvestMultiplier = table.Column<float>(type: "float", nullable: false),
|
|
ScanRadius = table.Column<float>(type: "float", nullable: false),
|
|
ScanCooldown = table.Column<float>(type: "float", nullable: false),
|
|
ShieldHealth = table.Column<int>(type: "int", nullable: false),
|
|
ShieldDuration = table.Column<float>(type: "float", nullable: false),
|
|
HealAmount = table.Column<int>(type: "int", nullable: false),
|
|
ShieldBoostDuration = table.Column<float>(type: "float", nullable: false),
|
|
DamageReduction = table.Column<float>(type: "float", nullable: false),
|
|
SpeedBoostDuration = table.Column<float>(type: "float", nullable: false),
|
|
SpeedMultiplier = table.Column<float>(type: "float", nullable: false),
|
|
HealthBonus = table.Column<int>(type: "int", nullable: false),
|
|
SpeedPenalty = table.Column<float>(type: "float", nullable: false),
|
|
DashDistance = table.Column<float>(type: "float", nullable: false),
|
|
DashCooldown = table.Column<float>(type: "float", nullable: false),
|
|
CreatedAt = table.Column<DateTime>(type: "datetime(6)", nullable: false, defaultValueSql: "CURRENT_TIMESTAMP(6)"),
|
|
UpdatedAt = table.Column<DateTime>(type: "datetime(6)", nullable: false, defaultValueSql: "CURRENT_TIMESTAMP(6)")
|
|
.Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.ComputedColumn)
|
|
},
|
|
constraints: table =>
|
|
{
|
|
table.PrimaryKey("PK_game_items", x => x.Id);
|
|
})
|
|
.Annotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.CreateTable(
|
|
name: "item_templates",
|
|
columns: table => new
|
|
{
|
|
Id = table.Column<ulong>(type: "bigint unsigned", nullable: false)
|
|
.Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
|
|
Name = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: false)
|
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
|
ItemType = table.Column<byte>(type: "tinyint unsigned", nullable: false),
|
|
Rarity = table.Column<byte>(type: "tinyint unsigned", nullable: false),
|
|
MaxStack = table.Column<uint>(type: "int unsigned", nullable: false),
|
|
Weight = table.Column<uint>(type: "int unsigned", nullable: false),
|
|
StatsJson = table.Column<string>(type: "json", nullable: true)
|
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
|
CreatedAt = table.Column<DateTime>(type: "datetime(6)", nullable: false, defaultValueSql: "CURRENT_TIMESTAMP(6)"),
|
|
UpdatedAt = table.Column<DateTime>(type: "datetime(6)", nullable: false, defaultValueSql: "CURRENT_TIMESTAMP(6)")
|
|
.Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.ComputedColumn)
|
|
},
|
|
constraints: table =>
|
|
{
|
|
table.PrimaryKey("PK_item_templates", x => x.Id);
|
|
})
|
|
.Annotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.CreateTable(
|
|
name: "zones",
|
|
columns: table => new
|
|
{
|
|
Id = table.Column<ulong>(type: "bigint unsigned", nullable: false)
|
|
.Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
|
|
Name = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: false)
|
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
|
MinX = table.Column<double>(type: "double", nullable: false),
|
|
MinY = table.Column<double>(type: "double", nullable: false),
|
|
MinZ = table.Column<double>(type: "double", nullable: false),
|
|
MaxX = table.Column<double>(type: "double", nullable: false),
|
|
MaxY = table.Column<double>(type: "double", nullable: false),
|
|
MaxZ = table.Column<double>(type: "double", nullable: false),
|
|
CreatedAt = table.Column<DateTime>(type: "datetime(6)", nullable: false, defaultValueSql: "CURRENT_TIMESTAMP(6)"),
|
|
UpdatedAt = table.Column<DateTime>(type: "datetime(6)", nullable: false, defaultValueSql: "CURRENT_TIMESTAMP(6)")
|
|
.Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.ComputedColumn)
|
|
},
|
|
constraints: table =>
|
|
{
|
|
table.PrimaryKey("PK_zones", x => x.Id);
|
|
})
|
|
.Annotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.CreateTable(
|
|
name: "dungeon_characters",
|
|
columns: table => new
|
|
{
|
|
Id = table.Column<ulong>(type: "bigint unsigned", nullable: false)
|
|
.Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
|
|
AccountId = table.Column<ulong>(type: "bigint unsigned", nullable: false),
|
|
Name = table.Column<string>(type: "varchar(32)", maxLength: 32, nullable: false)
|
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
|
CreatedAt = table.Column<DateTime>(type: "datetime(6)", nullable: false),
|
|
LastPlayedAt = table.Column<DateTime>(type: "datetime(6)", nullable: false),
|
|
Level = table.Column<int>(type: "int", nullable: false),
|
|
Experience = table.Column<long>(type: "bigint", nullable: false),
|
|
UnspentStatPoints = table.Column<int>(type: "int", nullable: false),
|
|
Strength = table.Column<int>(type: "int", nullable: false),
|
|
Intelligence = table.Column<int>(type: "int", nullable: false),
|
|
Wisdom = table.Column<int>(type: "int", nullable: false),
|
|
Endurance = table.Column<int>(type: "int", nullable: false),
|
|
Dexterity = table.Column<int>(type: "int", nullable: false),
|
|
CurrentHealth = table.Column<int>(type: "int", nullable: false),
|
|
CurrentMana = table.Column<int>(type: "int", nullable: false),
|
|
EquippedWeapon = table.Column<ulong>(type: "bigint unsigned", nullable: true),
|
|
EquippedOffhand = table.Column<ulong>(type: "bigint unsigned", nullable: true),
|
|
EquippedHead = table.Column<ulong>(type: "bigint unsigned", nullable: true),
|
|
EquippedChest = table.Column<ulong>(type: "bigint unsigned", nullable: true),
|
|
EquippedLegs = table.Column<ulong>(type: "bigint unsigned", nullable: true),
|
|
EquippedBoots = table.Column<ulong>(type: "bigint unsigned", nullable: true),
|
|
EquippedGloves = table.Column<ulong>(type: "bigint unsigned", nullable: true),
|
|
EquippedAccessory = table.Column<ulong>(type: "bigint unsigned", nullable: true),
|
|
TotalKills = table.Column<int>(type: "int", nullable: false),
|
|
TotalDeaths = table.Column<int>(type: "int", nullable: false),
|
|
PlayersKilled = table.Column<int>(type: "int", nullable: false),
|
|
DungeonsCompleted = table.Column<int>(type: "int", nullable: false),
|
|
BossesKilled = table.Column<int>(type: "int", nullable: false),
|
|
IsDeleted = table.Column<bool>(type: "tinyint(1)", nullable: false)
|
|
},
|
|
constraints: table =>
|
|
{
|
|
table.PrimaryKey("PK_dungeon_characters", x => x.Id);
|
|
table.ForeignKey(
|
|
name: "FK_dungeon_characters_accounts_AccountId",
|
|
column: x => x.AccountId,
|
|
principalTable: "accounts",
|
|
principalColumn: "Id",
|
|
onDelete: ReferentialAction.Cascade);
|
|
})
|
|
.Annotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.CreateTable(
|
|
name: "match_history",
|
|
columns: table => new
|
|
{
|
|
Id = table.Column<ulong>(type: "bigint unsigned", nullable: false)
|
|
.Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
|
|
MatchId = table.Column<string>(type: "varchar(32)", maxLength: 32, nullable: false)
|
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
|
AccountId = table.Column<ulong>(type: "bigint unsigned", nullable: false),
|
|
Result = table.Column<int>(type: "int", nullable: false),
|
|
Placement = table.Column<int>(type: "int", nullable: false),
|
|
TotalPlayers = table.Column<int>(type: "int", nullable: false),
|
|
Kills = table.Column<int>(type: "int", nullable: false),
|
|
Deaths = table.Column<int>(type: "int", nullable: false),
|
|
DamageDealt = table.Column<int>(type: "int", nullable: false),
|
|
DamageTaken = table.Column<int>(type: "int", nullable: false),
|
|
ScrapCollected = table.Column<int>(type: "int", nullable: false),
|
|
EnergyCollected = table.Column<int>(type: "int", nullable: false),
|
|
RareCollected = table.Column<int>(type: "int", nullable: false),
|
|
ItemsCrafted = table.Column<int>(type: "int", nullable: false),
|
|
SurvivalTimeSeconds = table.Column<int>(type: "int", nullable: false),
|
|
MatchDurationSeconds = table.Column<int>(type: "int", nullable: false),
|
|
EloChange = table.Column<int>(type: "int", nullable: false),
|
|
EloAfter = table.Column<int>(type: "int", nullable: false),
|
|
PlayedAt = table.Column<DateTime>(type: "datetime(6)", nullable: false, defaultValueSql: "CURRENT_TIMESTAMP(6)")
|
|
},
|
|
constraints: table =>
|
|
{
|
|
table.PrimaryKey("PK_match_history", x => x.Id);
|
|
table.ForeignKey(
|
|
name: "FK_match_history_accounts_AccountId",
|
|
column: x => x.AccountId,
|
|
principalTable: "accounts",
|
|
principalColumn: "Id",
|
|
onDelete: ReferentialAction.Cascade);
|
|
})
|
|
.Annotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.CreateTable(
|
|
name: "player_stats",
|
|
columns: table => new
|
|
{
|
|
Id = table.Column<ulong>(type: "bigint unsigned", nullable: false)
|
|
.Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
|
|
AccountId = table.Column<ulong>(type: "bigint unsigned", nullable: false),
|
|
MatchesPlayed = table.Column<int>(type: "int", nullable: false),
|
|
Wins = table.Column<int>(type: "int", nullable: false),
|
|
Losses = table.Column<int>(type: "int", nullable: false),
|
|
Extractions = table.Column<int>(type: "int", nullable: false),
|
|
Kills = table.Column<int>(type: "int", nullable: false),
|
|
Deaths = table.Column<int>(type: "int", nullable: false),
|
|
TotalDamageDealt = table.Column<long>(type: "bigint", nullable: false),
|
|
TotalDamageTaken = table.Column<long>(type: "bigint", nullable: false),
|
|
TotalScrapCollected = table.Column<long>(type: "bigint", nullable: false),
|
|
TotalEnergyCollected = table.Column<long>(type: "bigint", nullable: false),
|
|
TotalRareCollected = table.Column<long>(type: "bigint", nullable: false),
|
|
ItemsCrafted = table.Column<int>(type: "int", nullable: false),
|
|
TotalPlayTimeSeconds = table.Column<long>(type: "bigint", nullable: false),
|
|
LongestSurvivalSeconds = table.Column<int>(type: "int", nullable: false),
|
|
Elo = table.Column<int>(type: "int", nullable: false, defaultValue: 1000),
|
|
CreatedAt = table.Column<DateTime>(type: "datetime(6)", nullable: false, defaultValueSql: "CURRENT_TIMESTAMP(6)"),
|
|
UpdatedAt = table.Column<DateTime>(type: "datetime(6)", nullable: false, defaultValueSql: "CURRENT_TIMESTAMP(6)")
|
|
.Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.ComputedColumn)
|
|
},
|
|
constraints: table =>
|
|
{
|
|
table.PrimaryKey("PK_player_stats", x => x.Id);
|
|
table.ForeignKey(
|
|
name: "FK_player_stats_accounts_AccountId",
|
|
column: x => x.AccountId,
|
|
principalTable: "accounts",
|
|
principalColumn: "Id",
|
|
onDelete: ReferentialAction.Cascade);
|
|
})
|
|
.Annotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.CreateTable(
|
|
name: "sessions",
|
|
columns: table => new
|
|
{
|
|
Id = table.Column<ulong>(type: "bigint unsigned", nullable: false)
|
|
.Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
|
|
AccountId = table.Column<ulong>(type: "bigint unsigned", nullable: false),
|
|
TokenHash = table.Column<string>(type: "varchar(128)", maxLength: 128, nullable: false)
|
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
|
ExpiresAt = table.Column<DateTime>(type: "datetime(6)", nullable: false),
|
|
CreatedAt = table.Column<DateTime>(type: "datetime(6)", nullable: false, defaultValueSql: "CURRENT_TIMESTAMP(6)"),
|
|
CreatedIp = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: true)
|
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
|
UserAgent = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true)
|
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
|
RevokedAt = table.Column<DateTime>(type: "datetime(6)", nullable: true)
|
|
},
|
|
constraints: table =>
|
|
{
|
|
table.PrimaryKey("PK_sessions", x => x.Id);
|
|
table.ForeignKey(
|
|
name: "FK_sessions_accounts_AccountId",
|
|
column: x => x.AccountId,
|
|
principalTable: "accounts",
|
|
principalColumn: "Id",
|
|
onDelete: ReferentialAction.Cascade);
|
|
})
|
|
.Annotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.CreateTable(
|
|
name: "dungeon_loot_table_entries",
|
|
columns: table => new
|
|
{
|
|
Id = table.Column<int>(type: "int", nullable: false)
|
|
.Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
|
|
LootTableId = table.Column<int>(type: "int", nullable: false),
|
|
ItemDefinitionId = table.Column<int>(type: "int", nullable: false),
|
|
DropChance = table.Column<float>(type: "float", nullable: false),
|
|
MinQuantity = table.Column<int>(type: "int", nullable: false),
|
|
MaxQuantity = table.Column<int>(type: "int", nullable: false),
|
|
Weight = table.Column<int>(type: "int", nullable: false),
|
|
Guaranteed = table.Column<bool>(type: "tinyint(1)", nullable: false),
|
|
DropChancePerTier = table.Column<float>(type: "float", nullable: false),
|
|
MaxDropChance = table.Column<float>(type: "float", nullable: false)
|
|
},
|
|
constraints: table =>
|
|
{
|
|
table.PrimaryKey("PK_dungeon_loot_table_entries", x => x.Id);
|
|
table.ForeignKey(
|
|
name: "FK_dungeon_loot_table_entries_dungeon_item_definitions_ItemDefi~",
|
|
column: x => x.ItemDefinitionId,
|
|
principalTable: "dungeon_item_definitions",
|
|
principalColumn: "Id",
|
|
onDelete: ReferentialAction.Cascade);
|
|
table.ForeignKey(
|
|
name: "FK_dungeon_loot_table_entries_dungeon_loot_tables_LootTableId",
|
|
column: x => x.LootTableId,
|
|
principalTable: "dungeon_loot_tables",
|
|
principalColumn: "Id",
|
|
onDelete: ReferentialAction.Cascade);
|
|
})
|
|
.Annotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.CreateTable(
|
|
name: "dungeon_mob_loot_tables",
|
|
columns: table => new
|
|
{
|
|
Id = table.Column<int>(type: "int", nullable: false)
|
|
.Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
|
|
MobDefinitionId = table.Column<int>(type: "int", nullable: false),
|
|
LootTableId = table.Column<int>(type: "int", nullable: false),
|
|
Priority = table.Column<int>(type: "int", nullable: false),
|
|
RollChance = table.Column<float>(type: "float", nullable: false)
|
|
},
|
|
constraints: table =>
|
|
{
|
|
table.PrimaryKey("PK_dungeon_mob_loot_tables", x => x.Id);
|
|
table.ForeignKey(
|
|
name: "FK_dungeon_mob_loot_tables_dungeon_loot_tables_LootTableId",
|
|
column: x => x.LootTableId,
|
|
principalTable: "dungeon_loot_tables",
|
|
principalColumn: "Id",
|
|
onDelete: ReferentialAction.Cascade);
|
|
table.ForeignKey(
|
|
name: "FK_dungeon_mob_loot_tables_dungeon_mob_definitions_MobDefinitio~",
|
|
column: x => x.MobDefinitionId,
|
|
principalTable: "dungeon_mob_definitions",
|
|
principalColumn: "Id",
|
|
onDelete: ReferentialAction.Cascade);
|
|
})
|
|
.Annotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.CreateTable(
|
|
name: "game_recipes",
|
|
columns: table => new
|
|
{
|
|
Id = table.Column<int>(type: "int", nullable: false),
|
|
ResultItemId = table.Column<int>(type: "int", nullable: false),
|
|
IsEnabled = table.Column<bool>(type: "tinyint(1)", nullable: false, defaultValue: true),
|
|
ScrapCost = table.Column<int>(type: "int", nullable: false),
|
|
EnergyCost = table.Column<int>(type: "int", nullable: false),
|
|
RareCost = table.Column<int>(type: "int", nullable: false),
|
|
CreatedAt = table.Column<DateTime>(type: "datetime(6)", nullable: false, defaultValueSql: "CURRENT_TIMESTAMP(6)"),
|
|
UpdatedAt = table.Column<DateTime>(type: "datetime(6)", nullable: false, defaultValueSql: "CURRENT_TIMESTAMP(6)")
|
|
.Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.ComputedColumn)
|
|
},
|
|
constraints: table =>
|
|
{
|
|
table.PrimaryKey("PK_game_recipes", x => x.Id);
|
|
table.ForeignKey(
|
|
name: "FK_game_recipes_game_items_ResultItemId",
|
|
column: x => x.ResultItemId,
|
|
principalTable: "game_items",
|
|
principalColumn: "Id",
|
|
onDelete: ReferentialAction.Cascade);
|
|
})
|
|
.Annotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.CreateTable(
|
|
name: "characters",
|
|
columns: table => new
|
|
{
|
|
Id = table.Column<ulong>(type: "bigint unsigned", nullable: false)
|
|
.Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
|
|
AccountId = table.Column<ulong>(type: "bigint unsigned", nullable: false),
|
|
Name = table.Column<string>(type: "varchar(32)", maxLength: 32, nullable: false)
|
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
|
Level = table.Column<uint>(type: "int unsigned", nullable: false),
|
|
Xp = table.Column<ulong>(type: "bigint unsigned", nullable: false),
|
|
StatStrength = table.Column<uint>(type: "int unsigned", nullable: false),
|
|
StatDexterity = table.Column<uint>(type: "int unsigned", nullable: false),
|
|
StatWisdom = table.Column<uint>(type: "int unsigned", nullable: false),
|
|
StatIntelligence = table.Column<uint>(type: "int unsigned", nullable: false),
|
|
StatEndurance = table.Column<uint>(type: "int unsigned", nullable: false),
|
|
HpCurrent = table.Column<uint>(type: "int unsigned", nullable: false),
|
|
HpMax = table.Column<uint>(type: "int unsigned", nullable: false),
|
|
MpCurrent = table.Column<uint>(type: "int unsigned", nullable: false),
|
|
MpMax = table.Column<uint>(type: "int unsigned", nullable: false),
|
|
StaminaCurrent = table.Column<uint>(type: "int unsigned", nullable: false),
|
|
StaminaMax = table.Column<uint>(type: "int unsigned", nullable: false),
|
|
ZoneId = table.Column<ulong>(type: "bigint unsigned", nullable: false),
|
|
PosX = table.Column<double>(type: "double", nullable: false),
|
|
PosY = table.Column<double>(type: "double", nullable: false),
|
|
PosZ = table.Column<double>(type: "double", nullable: false),
|
|
FacingDeg = table.Column<float>(type: "float", nullable: false),
|
|
AppearanceJson = table.Column<string>(type: "json", nullable: true)
|
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
|
CreatedAt = table.Column<DateTime>(type: "datetime(6)", nullable: false, defaultValueSql: "CURRENT_TIMESTAMP(6)"),
|
|
UpdatedAt = table.Column<DateTime>(type: "datetime(6)", nullable: false, defaultValueSql: "CURRENT_TIMESTAMP(6)")
|
|
.Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.ComputedColumn)
|
|
},
|
|
constraints: table =>
|
|
{
|
|
table.PrimaryKey("PK_characters", x => x.Id);
|
|
table.ForeignKey(
|
|
name: "FK_characters_accounts_AccountId",
|
|
column: x => x.AccountId,
|
|
principalTable: "accounts",
|
|
principalColumn: "Id",
|
|
onDelete: ReferentialAction.Cascade);
|
|
table.ForeignKey(
|
|
name: "FK_characters_zones_ZoneId",
|
|
column: x => x.ZoneId,
|
|
principalTable: "zones",
|
|
principalColumn: "Id",
|
|
onDelete: ReferentialAction.Restrict);
|
|
})
|
|
.Annotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.CreateTable(
|
|
name: "dungeon_character_items",
|
|
columns: table => new
|
|
{
|
|
Id = table.Column<ulong>(type: "bigint unsigned", nullable: false)
|
|
.Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
|
|
CharacterId = table.Column<ulong>(type: "bigint unsigned", nullable: false),
|
|
ItemDefinitionId = table.Column<int>(type: "int", nullable: false),
|
|
Quantity = table.Column<int>(type: "int", nullable: false),
|
|
SlotIndex = table.Column<int>(type: "int", nullable: false),
|
|
IsEquipped = table.Column<bool>(type: "tinyint(1)", nullable: false),
|
|
EquipSlot = table.Column<int>(type: "int", nullable: true),
|
|
AcquiredAt = table.Column<DateTime>(type: "datetime(6)", nullable: false)
|
|
},
|
|
constraints: table =>
|
|
{
|
|
table.PrimaryKey("PK_dungeon_character_items", x => x.Id);
|
|
table.ForeignKey(
|
|
name: "FK_dungeon_character_items_dungeon_characters_CharacterId",
|
|
column: x => x.CharacterId,
|
|
principalTable: "dungeon_characters",
|
|
principalColumn: "Id",
|
|
onDelete: ReferentialAction.Cascade);
|
|
table.ForeignKey(
|
|
name: "FK_dungeon_character_items_dungeon_item_definitions_ItemDefinit~",
|
|
column: x => x.ItemDefinitionId,
|
|
principalTable: "dungeon_item_definitions",
|
|
principalColumn: "Id",
|
|
onDelete: ReferentialAction.Cascade);
|
|
})
|
|
.Annotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.CreateTable(
|
|
name: "dungeon_learned_spells",
|
|
columns: table => new
|
|
{
|
|
Id = table.Column<ulong>(type: "bigint unsigned", nullable: false)
|
|
.Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
|
|
CharacterId = table.Column<ulong>(type: "bigint unsigned", nullable: false),
|
|
SpellDefinitionId = table.Column<int>(type: "int", nullable: false),
|
|
LearnedAt = table.Column<DateTime>(type: "datetime(6)", nullable: false),
|
|
SpellLevel = table.Column<int>(type: "int", nullable: false),
|
|
DefinitionId = table.Column<int>(type: "int", nullable: true)
|
|
},
|
|
constraints: table =>
|
|
{
|
|
table.PrimaryKey("PK_dungeon_learned_spells", x => x.Id);
|
|
table.ForeignKey(
|
|
name: "FK_dungeon_learned_spells_dungeon_characters_CharacterId",
|
|
column: x => x.CharacterId,
|
|
principalTable: "dungeon_characters",
|
|
principalColumn: "Id",
|
|
onDelete: ReferentialAction.Cascade);
|
|
table.ForeignKey(
|
|
name: "FK_dungeon_learned_spells_dungeon_spell_definitions_DefinitionId",
|
|
column: x => x.DefinitionId,
|
|
principalTable: "dungeon_spell_definitions",
|
|
principalColumn: "Id");
|
|
})
|
|
.Annotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.CreateTable(
|
|
name: "dungeon_stash_items",
|
|
columns: table => new
|
|
{
|
|
Id = table.Column<ulong>(type: "bigint unsigned", nullable: false)
|
|
.Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
|
|
CharacterId = table.Column<ulong>(type: "bigint unsigned", nullable: false),
|
|
ItemDefinitionId = table.Column<int>(type: "int", nullable: false),
|
|
Quantity = table.Column<int>(type: "int", nullable: false),
|
|
SlotIndex = table.Column<int>(type: "int", nullable: false),
|
|
StoredAt = table.Column<DateTime>(type: "datetime(6)", nullable: false),
|
|
DefinitionId = table.Column<int>(type: "int", nullable: true)
|
|
},
|
|
constraints: table =>
|
|
{
|
|
table.PrimaryKey("PK_dungeon_stash_items", x => x.Id);
|
|
table.ForeignKey(
|
|
name: "FK_dungeon_stash_items_dungeon_characters_CharacterId",
|
|
column: x => x.CharacterId,
|
|
principalTable: "dungeon_characters",
|
|
principalColumn: "Id",
|
|
onDelete: ReferentialAction.Cascade);
|
|
table.ForeignKey(
|
|
name: "FK_dungeon_stash_items_dungeon_item_definitions_DefinitionId",
|
|
column: x => x.DefinitionId,
|
|
principalTable: "dungeon_item_definitions",
|
|
principalColumn: "Id");
|
|
})
|
|
.Annotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.CreateTable(
|
|
name: "equipment",
|
|
columns: table => new
|
|
{
|
|
Id = table.Column<ulong>(type: "bigint unsigned", nullable: false)
|
|
.Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
|
|
CharacterId = table.Column<ulong>(type: "bigint unsigned", nullable: false),
|
|
SlotCode = table.Column<byte>(type: "tinyint unsigned", nullable: false),
|
|
ItemTemplateId = table.Column<ulong>(type: "bigint unsigned", nullable: false),
|
|
CreatedAt = table.Column<DateTime>(type: "datetime(6)", nullable: false, defaultValueSql: "CURRENT_TIMESTAMP(6)"),
|
|
UpdatedAt = table.Column<DateTime>(type: "datetime(6)", nullable: false, defaultValueSql: "CURRENT_TIMESTAMP(6)")
|
|
.Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.ComputedColumn)
|
|
},
|
|
constraints: table =>
|
|
{
|
|
table.PrimaryKey("PK_equipment", x => x.Id);
|
|
table.ForeignKey(
|
|
name: "FK_equipment_characters_CharacterId",
|
|
column: x => x.CharacterId,
|
|
principalTable: "characters",
|
|
principalColumn: "Id",
|
|
onDelete: ReferentialAction.Cascade);
|
|
table.ForeignKey(
|
|
name: "FK_equipment_item_templates_ItemTemplateId",
|
|
column: x => x.ItemTemplateId,
|
|
principalTable: "item_templates",
|
|
principalColumn: "Id",
|
|
onDelete: ReferentialAction.Restrict);
|
|
})
|
|
.Annotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.CreateTable(
|
|
name: "inventories",
|
|
columns: table => new
|
|
{
|
|
Id = table.Column<ulong>(type: "bigint unsigned", nullable: false)
|
|
.Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
|
|
CharacterId = table.Column<ulong>(type: "bigint unsigned", nullable: false),
|
|
SlotIndex = table.Column<uint>(type: "int unsigned", nullable: false),
|
|
ItemTemplateId = table.Column<ulong>(type: "bigint unsigned", nullable: false),
|
|
Quantity = table.Column<uint>(type: "int unsigned", nullable: false),
|
|
CreatedAt = table.Column<DateTime>(type: "datetime(6)", nullable: false, defaultValueSql: "CURRENT_TIMESTAMP(6)"),
|
|
UpdatedAt = table.Column<DateTime>(type: "datetime(6)", nullable: false, defaultValueSql: "CURRENT_TIMESTAMP(6)")
|
|
.Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.ComputedColumn)
|
|
},
|
|
constraints: table =>
|
|
{
|
|
table.PrimaryKey("PK_inventories", x => x.Id);
|
|
table.ForeignKey(
|
|
name: "FK_inventories_characters_CharacterId",
|
|
column: x => x.CharacterId,
|
|
principalTable: "characters",
|
|
principalColumn: "Id",
|
|
onDelete: ReferentialAction.Cascade);
|
|
table.ForeignKey(
|
|
name: "FK_inventories_item_templates_ItemTemplateId",
|
|
column: x => x.ItemTemplateId,
|
|
principalTable: "item_templates",
|
|
principalColumn: "Id",
|
|
onDelete: ReferentialAction.Restrict);
|
|
})
|
|
.Annotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.CreateIndex(
|
|
name: "IX_accounts_Email",
|
|
table: "accounts",
|
|
column: "Email",
|
|
unique: true);
|
|
|
|
migrationBuilder.CreateIndex(
|
|
name: "IX_accounts_Username",
|
|
table: "accounts",
|
|
column: "Username",
|
|
unique: true);
|
|
|
|
migrationBuilder.CreateIndex(
|
|
name: "IX_characters_AccountId",
|
|
table: "characters",
|
|
column: "AccountId",
|
|
unique: true);
|
|
|
|
migrationBuilder.CreateIndex(
|
|
name: "IX_characters_ZoneId",
|
|
table: "characters",
|
|
column: "ZoneId");
|
|
|
|
migrationBuilder.CreateIndex(
|
|
name: "IX_dungeon_character_items_CharacterId",
|
|
table: "dungeon_character_items",
|
|
column: "CharacterId");
|
|
|
|
migrationBuilder.CreateIndex(
|
|
name: "IX_dungeon_character_items_ItemDefinitionId",
|
|
table: "dungeon_character_items",
|
|
column: "ItemDefinitionId");
|
|
|
|
migrationBuilder.CreateIndex(
|
|
name: "IX_dungeon_characters_AccountId",
|
|
table: "dungeon_characters",
|
|
column: "AccountId");
|
|
|
|
migrationBuilder.CreateIndex(
|
|
name: "IX_dungeon_learned_spells_CharacterId",
|
|
table: "dungeon_learned_spells",
|
|
column: "CharacterId");
|
|
|
|
migrationBuilder.CreateIndex(
|
|
name: "IX_dungeon_learned_spells_DefinitionId",
|
|
table: "dungeon_learned_spells",
|
|
column: "DefinitionId");
|
|
|
|
migrationBuilder.CreateIndex(
|
|
name: "IX_dungeon_loot_table_entries_ItemDefinitionId",
|
|
table: "dungeon_loot_table_entries",
|
|
column: "ItemDefinitionId");
|
|
|
|
migrationBuilder.CreateIndex(
|
|
name: "IX_dungeon_loot_table_entries_LootTableId",
|
|
table: "dungeon_loot_table_entries",
|
|
column: "LootTableId");
|
|
|
|
migrationBuilder.CreateIndex(
|
|
name: "IX_dungeon_mob_loot_tables_LootTableId",
|
|
table: "dungeon_mob_loot_tables",
|
|
column: "LootTableId");
|
|
|
|
migrationBuilder.CreateIndex(
|
|
name: "IX_dungeon_mob_loot_tables_MobDefinitionId",
|
|
table: "dungeon_mob_loot_tables",
|
|
column: "MobDefinitionId");
|
|
|
|
migrationBuilder.CreateIndex(
|
|
name: "IX_dungeon_stash_items_CharacterId",
|
|
table: "dungeon_stash_items",
|
|
column: "CharacterId");
|
|
|
|
migrationBuilder.CreateIndex(
|
|
name: "IX_dungeon_stash_items_DefinitionId",
|
|
table: "dungeon_stash_items",
|
|
column: "DefinitionId");
|
|
|
|
migrationBuilder.CreateIndex(
|
|
name: "IX_equipment_CharacterId_SlotCode",
|
|
table: "equipment",
|
|
columns: new[] { "CharacterId", "SlotCode" },
|
|
unique: true);
|
|
|
|
migrationBuilder.CreateIndex(
|
|
name: "IX_equipment_ItemTemplateId",
|
|
table: "equipment",
|
|
column: "ItemTemplateId");
|
|
|
|
migrationBuilder.CreateIndex(
|
|
name: "IX_game_items_Category",
|
|
table: "game_items",
|
|
column: "Category");
|
|
|
|
migrationBuilder.CreateIndex(
|
|
name: "IX_game_items_IsEnabled",
|
|
table: "game_items",
|
|
column: "IsEnabled");
|
|
|
|
migrationBuilder.CreateIndex(
|
|
name: "IX_game_recipes_IsEnabled",
|
|
table: "game_recipes",
|
|
column: "IsEnabled");
|
|
|
|
migrationBuilder.CreateIndex(
|
|
name: "IX_game_recipes_ResultItemId",
|
|
table: "game_recipes",
|
|
column: "ResultItemId");
|
|
|
|
migrationBuilder.CreateIndex(
|
|
name: "IX_inventories_CharacterId",
|
|
table: "inventories",
|
|
column: "CharacterId");
|
|
|
|
migrationBuilder.CreateIndex(
|
|
name: "IX_inventories_CharacterId_SlotIndex",
|
|
table: "inventories",
|
|
columns: new[] { "CharacterId", "SlotIndex" },
|
|
unique: true);
|
|
|
|
migrationBuilder.CreateIndex(
|
|
name: "IX_inventories_ItemTemplateId",
|
|
table: "inventories",
|
|
column: "ItemTemplateId");
|
|
|
|
migrationBuilder.CreateIndex(
|
|
name: "IX_item_templates_Name",
|
|
table: "item_templates",
|
|
column: "Name",
|
|
unique: true);
|
|
|
|
migrationBuilder.CreateIndex(
|
|
name: "IX_match_history_AccountId",
|
|
table: "match_history",
|
|
column: "AccountId");
|
|
|
|
migrationBuilder.CreateIndex(
|
|
name: "IX_match_history_MatchId",
|
|
table: "match_history",
|
|
column: "MatchId");
|
|
|
|
migrationBuilder.CreateIndex(
|
|
name: "IX_match_history_PlayedAt",
|
|
table: "match_history",
|
|
column: "PlayedAt");
|
|
|
|
migrationBuilder.CreateIndex(
|
|
name: "IX_player_stats_AccountId",
|
|
table: "player_stats",
|
|
column: "AccountId",
|
|
unique: true);
|
|
|
|
migrationBuilder.CreateIndex(
|
|
name: "IX_sessions_AccountId",
|
|
table: "sessions",
|
|
column: "AccountId");
|
|
|
|
migrationBuilder.CreateIndex(
|
|
name: "IX_sessions_TokenHash",
|
|
table: "sessions",
|
|
column: "TokenHash",
|
|
unique: true);
|
|
|
|
migrationBuilder.CreateIndex(
|
|
name: "IX_zones_Name",
|
|
table: "zones",
|
|
column: "Name",
|
|
unique: true);
|
|
}
|
|
|
|
/// <inheritdoc />
|
|
protected override void Down(MigrationBuilder migrationBuilder)
|
|
{
|
|
migrationBuilder.DropTable(
|
|
name: "dungeon_character_items");
|
|
|
|
migrationBuilder.DropTable(
|
|
name: "dungeon_learned_spells");
|
|
|
|
migrationBuilder.DropTable(
|
|
name: "dungeon_loot_table_entries");
|
|
|
|
migrationBuilder.DropTable(
|
|
name: "dungeon_mob_loot_tables");
|
|
|
|
migrationBuilder.DropTable(
|
|
name: "dungeon_stash_items");
|
|
|
|
migrationBuilder.DropTable(
|
|
name: "equipment");
|
|
|
|
migrationBuilder.DropTable(
|
|
name: "game_recipes");
|
|
|
|
migrationBuilder.DropTable(
|
|
name: "inventories");
|
|
|
|
migrationBuilder.DropTable(
|
|
name: "match_history");
|
|
|
|
migrationBuilder.DropTable(
|
|
name: "player_stats");
|
|
|
|
migrationBuilder.DropTable(
|
|
name: "sessions");
|
|
|
|
migrationBuilder.DropTable(
|
|
name: "dungeon_spell_definitions");
|
|
|
|
migrationBuilder.DropTable(
|
|
name: "dungeon_loot_tables");
|
|
|
|
migrationBuilder.DropTable(
|
|
name: "dungeon_mob_definitions");
|
|
|
|
migrationBuilder.DropTable(
|
|
name: "dungeon_characters");
|
|
|
|
migrationBuilder.DropTable(
|
|
name: "dungeon_item_definitions");
|
|
|
|
migrationBuilder.DropTable(
|
|
name: "game_items");
|
|
|
|
migrationBuilder.DropTable(
|
|
name: "characters");
|
|
|
|
migrationBuilder.DropTable(
|
|
name: "item_templates");
|
|
|
|
migrationBuilder.DropTable(
|
|
name: "accounts");
|
|
|
|
migrationBuilder.DropTable(
|
|
name: "zones");
|
|
}
|
|
}
|
|
}
|