sebastian-heinz / Arrowgene.DragonsDogmaOnline

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

Add support for quests in party #353

Closed pacampbell closed 2 months ago

pacampbell commented 2 months ago

Migration Scripts

CREATE TABLE IF NOT EXISTS "ddon_priority_quests" (
    "character_common_id"   INTEGER NOT NULL,
    "quest_id"  INTEGER NOT NULL,
    FOREIGN KEY("character_common_id") REFERENCES "ddon_character_common"("character_common_id") ON DELETE CASCADE
);

Add a new column to the ddon_completed_quests called clear_count

"clear_count"   INTEGER NOT NULL DEFAULT 1

Remove primary key constraint from ddon_quest_progress for character_common_id which was added by mistake.

Checklist: