ddon-server/Arrowgene.Ddon.Database/Files/Database/Script/migration_substory_progress.sql
Paul Campbell 0bd7bcd404 feat: Add Sub Story Quest Handlers
Added handlers and required packets for:
- QuestAddPackageQuestPointHandler
- QuestGetPackageQuestInfoDetailHandler
- QuestGetPackageQuestInfoHandler

Added new quests
- q10300102.csx
- q60300030.csx

Added a new settings file substory.csx to describe the mission
requirements.

Database 56 -> 57

Co-authored-by: @hankhotspur
2026-04-21 23:02:46 -04:00

8 lines
490 B
SQL

CREATE TABLE IF NOT EXISTS "ddon_substory_progress" (
"character_id" INTEGER NOT NULL,
"substory_group_id" INTEGER NOT NULL,
"sequence_step" INTEGER NOT NULL DEFAULT 0,
"is_complete" INTEGER NOT NULL DEFAULT 0,
CONSTRAINT "pk_ddon_substory_progress" PRIMARY KEY ("character_id", "substory_group_id"),
CONSTRAINT "fk_ddon_substory_progress_character_id" FOREIGN KEY ("character_id") REFERENCES "ddon_character"("character_id") ON DELETE CASCADE
);