mirror of
https://github.com/araxiaonline/mod-mythic-plus.git
synced 2026-06-13 11:12:23 -04:00
101 lines
3.5 KiB
SQL
101 lines
3.5 KiB
SQL
-- Used for tracking group instance data for mythic runs
|
|
DROP TABLE IF EXISTS mp_group_data;
|
|
CREATE TABLE mp_group_data (
|
|
groupId INT UNSIGNED NOT NULL DEFAULT '0',
|
|
difficulty INT UNSIGNED,
|
|
mapId INT UNSIGNED,
|
|
instanceId INT UNSIGNED,
|
|
instanceTimer INT UNSIGNED,
|
|
deaths INT UNSIGNED,
|
|
|
|
PRIMARY KEY (groupId)
|
|
);
|
|
|
|
-- Used for tracking current instance data for players
|
|
DROP TABLE IF EXISTS mp_player_instance_data;
|
|
CREATE TABLE mp_player_instance_data (
|
|
guid INT UNSIGNED NOT NULL DEFAULT '0',
|
|
difficulty INT UNSIGNED NOT NULL DEFAULT '3',
|
|
mapId INT UNSIGNED NOT NULL,
|
|
instanceId INT UNSIGNED,
|
|
deaths INT UNSIGNED NOT NULL,
|
|
|
|
PRIMARY KEY (guid, mapId, instanceId)
|
|
);
|
|
|
|
-- Used for tracking player deaths to specific creatures in mythic runs
|
|
DROP TABLE IF EXISTS mp_player_death_stats;
|
|
CREATE TABLE mp_player_death_stats (
|
|
guid INT UNSIGNED NOT NULL DEFAULT '0',
|
|
creatureEntry INT UNSIGNED NOT NULL,
|
|
difficulty TINYINT UNSIGNED NOT NULL DEFAULT '0',
|
|
numDeaths INT UNSIGNED NOT NULL DEFAULT '0',
|
|
lastUpdated TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
|
|
|
|
PRIMARY KEY (guid, creatureEntry, difficulty)
|
|
);
|
|
|
|
-- Used for tracking player runs in mythic dungeons
|
|
DROP TABLE IF EXISTS mp_player_runs;
|
|
CREATE TABLE mp_player_runs (
|
|
runId INT UNSIGNED AUTO_INCREMENT,
|
|
guid INT UNSIGNED NOT NULL DEFAULT '0',
|
|
difficulty INT UNSIGNED NOT NULL DEFAULT '3',
|
|
mapId INT UNSIGNED NOT NULL DEFAULT '0',
|
|
groupDeaths INT UNSIGNED NOT NULL DEFAULT '0',
|
|
personalDeaths INT UNSIGNED NOT NULL DEFAULT '0',
|
|
startTime INT UNSIGNED,
|
|
completeTime TIMESTAMP,
|
|
botCount TINYINT UNSIGNED DEFAULT '0',
|
|
|
|
PRIMARY KEY (runId),
|
|
INDEX idx_guid (guid),
|
|
INDEX idx_mapId (mapId)
|
|
);
|
|
|
|
-- Used for tracking player stats in mythic dungeons
|
|
DROP TABLE IF EXISTS mp_player_stats;
|
|
CREATE TABLE mp_player_stats (
|
|
guid INT UNSIGNED NOT NULL DEFAULT '0',
|
|
mapId INT UNSIGNED NOT NULL DEFAULT '0',
|
|
difficulty TINYINT UNSIGNED NOT NULL DEFAULT '0',
|
|
deaths INT UNSIGNED DEFAULT '0',
|
|
runs INT UNSIGNED DEFAULT '0',
|
|
completions INT UNSIGNED DEFAULT '0',
|
|
totalTime INT UNSIGNED DEFAULT '0',
|
|
bestTime INT UNSIGNED DEFAULT '0',
|
|
|
|
PRIMARY KEY (guid, mapId, difficulty)
|
|
);
|
|
|
|
-- Used to enable custom stat upgrades from materials and drops in mythic dungeons
|
|
DROP TABLE IF EXISTS mp_player_advancements;
|
|
CREATE TABLE mp_player_advancements (
|
|
guid INT UNSIGNED NOT NULL,
|
|
advancementId INT UNSIGNED NOT NULL,
|
|
bonus FLOAT NOT NULL,
|
|
upgradeRank INT UNSIGNED NOT NULL,
|
|
diceSpent INT UNSIGNED NOT NULL DEFAULT '0',
|
|
|
|
PRIMARY KEY (guid, advancementId)
|
|
);
|
|
|
|
-- Used to show historic player roll data by advancement.
|
|
DROP TABLE IF EXISTS mp_player_advancement_history;
|
|
CREATE TABLE mp_player_advancement_history (
|
|
guid INT UNSIGNED NOT NULL,
|
|
advancementId INT UNSIGNED NOT NULL,
|
|
bonus FLOAT NOT NULL,
|
|
upgradeRank INT UNSIGNED NOT NULL,
|
|
diceSpent INT UNSIGNED NOT NULL DEFAULT '0',
|
|
materialId1 INT UNSIGNED NOT NULL,
|
|
materialId2 INT UNSIGNED NOT NULL,
|
|
materialId3 INT UNSIGNED NOT NULL,
|
|
materialCost1 INT UNSIGNED NOT NULL,
|
|
materialCost2 INT UNSIGNED NOT NULL,
|
|
materialCost3 INT UNSIGNED NOT NULL,
|
|
added TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
|
|
PRIMARY KEY (guid, advancementId)
|
|
);
|
|
|