sebastian-heinz / Arrowgene.DragonsDogmaOnline

Server for Dragons Dogma Online
GNU Affero General Public License v3.0
161 stars 52 forks source link

Allow having different pawn SP skills equipped per job #329

Closed alborrajo closed 3 months ago

alborrajo commented 3 months ago

Fixes issue #327

Checklist:

DB Migration Script

DROP TABLE IF EXISTS ddon_sp_skill;

CREATE TABLE IF NOT EXISTS ddon_sp_skill
(
    "pawn_id"     INTEGER  NOT NULL,
    "job"         SMALLINT NOT NULL,
    "sp_skill_id" SMALLINT NOT NULL,
    "sp_skill_lv" SMALLINT NOT NULL,
    CONSTRAINT pk_ddon_sp_skill PRIMARY KEY (pawn_id, job, sp_skill_id),
    CONSTRAINT fk_sp_skill_pawn_id FOREIGN KEY ("pawn_id") REFERENCES ddon_pawn ("pawn_id") ON DELETE CASCADE
);